Schema for orfToGene
  Database: ce4    Primary Table: orfToGene    Row Count: 30,497   Data last updated: 2007-08-08
Format description: Links from WormBase ORF to WormBase gene classification
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name F13H10.3achar(16) values WormBase Sequence/ORF Name
value F13H10.3char(16) values WormBase gene classification

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

Sample Rows
 
namevalue
F13H10.3aF13H10.3
F53E10.1.1F53E10.1
C47E12.5b.2uba-1
K12H6.9K12H6.9
F11C1.6a.2nhr-25
F30F8.2F30F8.2
ZK177.2ZK177.2
T01C4.2aodr-2
M01E11.5.2cey-3
M7.3bcc-1

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