Schema for sangerGeneToWBGeneID
  Database: ce4    Primary Table: sangerGeneToWBGeneID    Row Count: 29,778   Data last updated: 2007-07-31
Format description: sanger gene names to WormBase Gene IDs translation
On download server: MariaDB table dump directory
fieldexampleSQL type info description
sangerGene F13H10.3avarchar(255) values sangerGene name
WBGeneID WBGene00008774varchar(255) values WormBase Gene ID

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

Sample Rows
 
sangerGeneWBGeneID
F13H10.3aWBGene00008774
F53E10.1.1WBGene00018758
C47E12.5b.2WBGene00006699
K12H6.9WBGene00019689
F11C1.6a.2WBGene00003623
F30F8.2WBGene00009271
ZK177.2WBGene00022670
T01C4.2aWBGene00003849
M01E11.5.2WBGene00000474
M7.3WBGene00000246

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