Schema for choExpDistance
  Database: sacCer3    Primary Table: choExpDistance    Row Count: 6,259,000   Data last updated: 2011-09-02
Format description: Distance between two genes in expression space.
On download server: MariaDB table dump directory
fieldexampleSQL type description
query 18srRnaavarchar(255) Name of one gene
target 18srRnaavarchar(255) Name of other gene
distance 0float Distance in expression space, always >= 0

Connected Tables and Joining Fields
        sacCer3.ceBlastTab.query (via choExpDistance.target)
      sacCer3.dmBlastTab.query (via choExpDistance.target)
      sacCer3.drBlastTab.query (via choExpDistance.target)
      sacCer3.esRegGeneToModule.gene (via choExpDistance.target)
      sacCer3.esRegGeneToMotif.gene (via choExpDistance.target)
      sacCer3.esRegUpstreamRegion.name (via choExpDistance.target)
      sacCer3.hgBlastTab.query (via choExpDistance.target)
      sacCer3.mmBlastTab.query (via choExpDistance.target)
      sacCer3.rnBlastTab.query (via choExpDistance.target)
      sacCer3.sgdBlastTab.query (via choExpDistance.target)
      sacCer3.sgdBlastTab.target (via choExpDistance.target)
      sacCer3.sgdCanonical.transcript (via choExpDistance.target)
      sacCer3.sgdDescription.name (via choExpDistance.target)
      sacCer3.sgdGene.name (via choExpDistance.target)
      sacCer3.sgdIsoforms.transcript (via choExpDistance.target)
      sacCer3.sgdPep.name (via choExpDistance.target)
      sacCer3.sgdToName.name (via choExpDistance.target)
      sacCer3.sgdToSwissProt.name (via choExpDistance.target)

Sample Rows
 
querytargetdistance
18srRnaa18srRnaa0
18srRnaa25srRnac18.8235
18srRnaaYDR534C23.5882
18srRnaaYCR006c24.5294
18srRnaaYDR241W25.2941
18srRnaaYNL145W25.2941
18srRnaaYLR402W25.5294
18srRnaaYJR154W25.6471
18srRnaaYDR525W26.0588
18srRnaaYGR256W26.1176

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