Schema for sangerToRefSeq
  Database: ce6    Primary Table: sangerToRefSeq    Row Count: 29,995   Data last updated: 2008-06-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 H10E21.2varchar(255) values primary ID
value NM_064724varchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        ce6.dmBlastTab.query (via sangerToRefSeq.name)
      ce6.drBlastTab.query (via sangerToRefSeq.name)
      ce6.hgBlastTab.query (via sangerToRefSeq.name)
      ce6.kimExpDistance.query (via sangerToRefSeq.name)
      ce6.kimExpDistance.target (via sangerToRefSeq.name)
      ce6.mmBlastTab.query (via sangerToRefSeq.name)
      ce6.orfToGene.name (via sangerToRefSeq.name)
      ce6.rnBlastTab.query (via sangerToRefSeq.name)
      ce6.sangerBlastTab.query (via sangerToRefSeq.name)
      ce6.sangerBlastTab.target (via sangerToRefSeq.name)
      ce6.sangerCanonical.transcript (via sangerToRefSeq.name)
      ce6.sangerGene.name (via sangerToRefSeq.name)
      ce6.sangerGeneToWBGeneID.sangerGene (via sangerToRefSeq.name)
      ce6.sangerIsoforms.transcript (via sangerToRefSeq.name)
      ce6.sangerLinks.orfName (via sangerToRefSeq.name)
      ce6.sangerPep.name (via sangerToRefSeq.name)
      ce6.scBlastTab.query (via sangerToRefSeq.name)

Sample Rows
 
namevalue
H10E21.2NM_064724
H10E21.1NM_064726
W05G11.3.1NM_064730
W05G11.3.2NM_064730
W05G11.3NM_064730
W05G11.2NM_064731
F54C4.1NM_064737
C29F9.6NM_064743
C29F9.5NM_064744
C29F9.4NM_064745

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