Schema for kimExpDistance
  Database: ce4    Primary Table: kimExpDistance    Row Count: 19,134,000   Data last updated: 2007-07-30
Format description: Distance between two genes in expression space.
On download server: MariaDB table dump directory
fieldexampleSQL type description
query AC3.5varchar(255) Name of one gene
target AC3.5varchar(255) Name of other gene
distance 0float Distance in expression space, always >= 0

Connected Tables and Joining Fields
        ce4.mmBlastTab.query (via kimExpDistance.query)
      ce4.orfToGene.name (via kimExpDistance.query)
      ce4.sangerBlastTab.query (via kimExpDistance.query)
      ce4.sangerBlastTab.target (via kimExpDistance.query)
      ce4.sangerCanonical.transcript (via kimExpDistance.query)
      ce4.sangerGene.name (via kimExpDistance.query)
      ce4.sangerGeneToWBGeneID.sangerGene (via kimExpDistance.query)
      ce4.sangerIsoforms.transcript (via kimExpDistance.query)
      ce4.sangerLinks.orfName (via kimExpDistance.query)
      ce4.sangerPep.name (via kimExpDistance.query)
      ce4.sangerToRefSeq.name (via kimExpDistance.query)

Sample Rows
 
querytargetdistance
AC3.5AC3.50
AC3.5T27A1.50.032
AC3.5T26E4.50.103
AC3.5C05D11.10.195857
AC3.5H03A11.20.207286
AC3.5F25D7.40.209143
AC3.5Y110A7A.B0.211
AC3.5C54D10.10.222143
AC3.5K04A8.10.228571
AC3.5F58F12.10.230429

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