Schema for choExpDistance

Database: sacCer2 Primary Table: choExpDistance Row Count: 6,259,000 Data last updated: 2009-02-18
Format description: Distance between two genes in expression space.
On download server: MariaDB table dump directory

field	example	SQL type	description
`query`	YJL072C	`varchar(255)`	Name of one gene
`target`	YJL072C	`varchar(255)`	Name of other gene
`distance`	0	`float`	Distance in expression space, always >= 0

Connected Tables and Joining Fields


	sacCer2.ceBlastTab.query (via choExpDistance.target) sacCer2.dmBlastTab.query (via choExpDistance.target) sacCer2.drBlastTab.query (via choExpDistance.target) sacCer2.esRegGeneToModule.gene (via choExpDistance.target) sacCer2.esRegGeneToMotif.gene (via choExpDistance.target) sacCer2.esRegUpstreamRegion.name (via choExpDistance.target) sacCer2.hgBlastTab.query (via choExpDistance.target) sacCer2.mmBlastTab.query (via choExpDistance.target) sacCer2.rnBlastTab.query (via choExpDistance.target) sacCer2.sgdAbundance.name (via choExpDistance.target) sacCer2.sgdBlastTab.query (via choExpDistance.target) sacCer2.sgdBlastTab.target (via choExpDistance.target) sacCer2.sgdCanonical.transcript (via choExpDistance.target) sacCer2.sgdDescription.name (via choExpDistance.target) sacCer2.sgdGene.name (via choExpDistance.target) sacCer2.sgdIsoforms.transcript (via choExpDistance.target) sacCer2.sgdLocalization.name (via choExpDistance.target) sacCer2.sgdPep.name (via choExpDistance.target) sacCer2.sgdToName.name (via choExpDistance.target) sacCer2.sgdToPfam.name (via choExpDistance.target) sacCer2.sgdToSwissProt.name (via choExpDistance.target)

Sample Rows

query	target	distance
YJL072C	YJL072C	0
YJL072C	YPL007C	17.9412
YJL072C	YOR380W	18.6471
YJL072C	YHR119w	18.8235
YJL072C	YGL241W	18.8824
YJL072C	YBR277c	19.5294
YJL072C	YOL053W	19.7059
YJL072C	YKR101W	20
YJL072C	YDR400W	20.0588
YJL072C	YOR076C	20.1765

Note: all start coordinates in our database are 0-based, not 1-based. See explanation here.