Schema for sangerToRefSeq
  Database: ce2    Primary Table: sangerToRefSeq    Row Count: 21,739   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 NM_058259varchar(255) values associated ID, label, quantity etc.

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

Sample Rows
 
namevalue
Y74C9A.2NM_058259
Y74C9A.1NM_058264
Y48G1C.4NM_058265
Y48G1C.2NM_170790
Y48G1C.10NM_182094
Y48G1C.11NM_182095
Y48G1C.9NM_058270
Y48G1C.1NM_058271
F53G12.10NM_058275
F53G12.9NM_058276

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