Schema for orfToGene
  Database: ce6    Primary Table: orfToGene    Row Count: 30,296   Data last updated: 2008-06-20
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
        ce6.dmBlastTab.query (via orfToGene.name)
      ce6.drBlastTab.query (via orfToGene.name)
      ce6.hgBlastTab.query (via orfToGene.name)
      ce6.kimExpDistance.query (via orfToGene.name)
      ce6.kimExpDistance.target (via orfToGene.name)
      ce6.mmBlastTab.query (via orfToGene.name)
      ce6.rnBlastTab.query (via orfToGene.name)
      ce6.sangerBlastTab.query (via orfToGene.name)
      ce6.sangerBlastTab.target (via orfToGene.name)
      ce6.sangerCanonical.transcript (via orfToGene.name)
      ce6.sangerGene.name (via orfToGene.name)
      ce6.sangerGeneToWBGeneID.sangerGene (via orfToGene.name)
      ce6.sangerIsoforms.transcript (via orfToGene.name)
      ce6.sangerLinks.orfName (via orfToGene.name)
      ce6.sangerPep.name (via orfToGene.name)
      ce6.sangerToRefSeq.name (via orfToGene.name)
      ce6.scBlastTab.query (via orfToGene.name)

Sample Rows
 
namevalue
F13H10.3aF13H10.3
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
F36G9.15F36G9.15

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