Schema for sangerToRefSeq
  Database: ce4    Primary Table: sangerToRefSeq    Row Count: 30,336   Data last updated: 2007-07-30
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 T08A9.1varchar(255) values primary ID
value NM_076840varchar(255) values associated ID, label, quantity etc.

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

Sample Rows
 
namevalue
T08A9.1NM_076840
C33D3.3NM_077355
C35C5.8aNM_077524
T24D5.3NM_077702
F40E10.4NM_078036
ZK662.4NM_078186
Y73B3A.13NM_075667
F35H12.3NM_075774
F52D2.7.1NM_075961
K02E10.2aNM_001029577

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