Schema for choExpDistance
  Database: sacCer3    Primary Table: choExpDistance    Row Count: 6,259,000   Data last updated: 2011-09-02
Format description: Abstract distance between two genes
On download server: MariaDB table dump directory
fieldexampleSQL type description
query 18srRnaavarchar(255) Query gene. Indexed
target 18srRnaavarchar(255) Target gene. Not indexed
distance 0float Distance between two, possibly in some expression space

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.