Schema for orfToGene
  Database: ce2    Primary Table: orfToGene    Row Count: 23,076   Data last updated: 2005-05-03
Format description: Links from WormBase ORF to WormBase gene classification
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name Y74C9A.6varchar(255) values WormBase Sequence/ORF Name
value Y74C9A.6varchar(255) values WormBase gene classification

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

Sample Rows
 
namevalue
Y74C9A.6Y74C9A.6
Y74C9A.3Y74C9A.3
Y74C9A.2Y74C9A.2
Y74C9A.4aY74C9A.4a
Y74C9A.4bY74C9A.4b
Y74C9A.5Y74C9A.5
Y74C9A.1Y74C9A.1
Y48G1C.4Y48G1C.4
Y48G1C.5Y48G1C.5
Y48G1C.2csk-1

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