Schema for kimExpDistance
  Database: ce4    Primary Table: kimExpDistance    Row Count: 19,134,000   Data last updated: 2007-07-30
Format description: Abstract distance between two genes
On download server: MariaDB table dump directory
fieldexampleSQL type description
query AC3.5varchar(255) Query gene. Indexed
target AC3.5varchar(255) Target gene. Not indexed
distance 0float Distance between two, possibly in some expression space

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.