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

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
 
querytargetdistance
YJL072CYJL072C0
YJL072CYPL007C17.9412
YJL072CYOR380W18.6471
YJL072CYHR119w18.8235
YJL072CYGL241W18.8824
YJL072CYBR277c19.5294
YJL072CYOL053W19.7059
YJL072CYKR101W20
YJL072CYDR400W20.0588
YJL072CYOR076C20.1765

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