Schema for sangerToKim
  Database: ce2    Primary Table: sangerToKim    Row Count: 23,076   Data last updated: 2005-05-03
Format description: Map a primary ID to another type of ID, label, quantity etc.
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name Y74C9A.2varchar(255) values primary ID
value Y74C9A.2varchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        ce2.dmBlastTab.query (via sangerToKim.name)
      ce2.hgBlastTab.query (via sangerToKim.name)
      ce2.kimExpDistance.query (via sangerToKim.name)
      ce2.kimExpDistance.target (via sangerToKim.name)
      ce2.orfToGene.name (via sangerToKim.name)
      ce2.sangerBlastTab.query (via sangerToKim.name)
      ce2.sangerBlastTab.target (via sangerToKim.name)
      ce2.sangerCanonical.transcript (via sangerToKim.name)
      ce2.sangerGene.name (via sangerToKim.name)
      ce2.sangerIsoforms.transcript (via sangerToKim.name)
      ce2.sangerLinks.orfName (via sangerToKim.name)
      ce2.sangerPep.name (via sangerToKim.name)
      ce2.sangerToPfam.name (via sangerToKim.name)
      ce2.sangerToRefSeq.name (via sangerToKim.name)
      hgFixed.kimWormLifeAllRatio.name (via sangerToKim.value)
      hgFixed.kimWormLifeMedianRatio.name (via sangerToKim.value)

Sample Rows
 
namevalue
Y74C9A.2Y74C9A.2
Y74C9A.1Y74C9A.1
Y48G1C.4Y48G1C.4
Y48G1C.2Y48G1C.2
Y48G1C.10Y48G1C.10
Y48G1C.11Y48G1C.11
Y48G1C.9Y48G1C.9
Y48G1C.1Y48G1C.1
F53G12.10F53G12.10
F53G12.9F53G12.9

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