Schema for sangerLinks
  Database: ce2    Primary Table: sangerLinks    Row Count: 21,914   Data last updated: 2005-05-03
Format description: Links from WormBase ORF to SwissProt/trEMBL ID and Description
On download server: MariaDB table dump directory
fieldexampleSQL type info description
orfName B0303.14varchar(255) values WormBase Sequence/ORF Name
protName P34263varchar(255) values SwissProt/trEMBL ID
description Giant secretory protein I-Clongblob   Freeform (except for no tabs) description

Connected Tables and Joining Fields
        ce2.dmBlastTab.query (via sangerLinks.orfName)
      ce2.hgBlastTab.query (via sangerLinks.orfName)
      ce2.kimExpDistance.query (via sangerLinks.orfName)
      ce2.kimExpDistance.target (via sangerLinks.orfName)
      ce2.orfToGene.name (via sangerLinks.orfName)
      ce2.sangerBlastTab.query (via sangerLinks.orfName)
      ce2.sangerBlastTab.target (via sangerLinks.orfName)
      ce2.sangerCanonical.transcript (via sangerLinks.orfName)
      ce2.sangerGene.name (via sangerLinks.orfName)
      ce2.sangerIsoforms.transcript (via sangerLinks.orfName)
      ce2.sangerPep.name (via sangerLinks.orfName)
      ce2.sangerToKim.name (via sangerLinks.orfName)
      ce2.sangerToPfam.name (via sangerLinks.orfName)
      ce2.sangerToRefSeq.name (via sangerLinks.orfName)
      ce2.sangerCanonical.protein (via sangerLinks.protName)
      ce2.sangerGene.proteinID (via sangerLinks.protName)
      go.goaPart.dbObjectId (via sangerLinks.protName)
      knownGeneV39.kgProtAlias.alias (via sangerLinks.protName)
      knownGeneV39.kgSpAlias.spID (via sangerLinks.protName)
      knownGeneV39.kgXref.spID (via sangerLinks.protName)
      proteome.spOldNew.acc (via sangerLinks.protName)
      proteome.spReactomeEvent.spID (via sangerLinks.protName)
      proteome.spReactomeId.spID (via sangerLinks.protName)
      uniProt.accToKeyword.acc (via sangerLinks.protName)
      uniProt.accToTaxon.acc (via sangerLinks.protName)
      uniProt.citation.acc (via sangerLinks.protName)
      uniProt.comment.acc (via sangerLinks.protName)
      uniProt.description.acc (via sangerLinks.protName)
      uniProt.displayId.acc (via sangerLinks.protName)
      uniProt.extDbRef.acc (via sangerLinks.protName)
      uniProt.feature.acc (via sangerLinks.protName)
      uniProt.gene.acc (via sangerLinks.protName)
      uniProt.geneLogic.acc (via sangerLinks.protName)
      uniProt.info.acc (via sangerLinks.protName)
      uniProt.otherAcc.acc (via sangerLinks.protName)
      uniProt.protein.acc (via sangerLinks.protName)
      visiGene.gene.uniProt (via sangerLinks.protName)

Sample Rows
 
orfNameprotNamedescription
B0303.14P34263Giant secretory protein I-C
B0303.15P34264Ribosomal protein L11
B0303.5P34257Tc3
B0464.1Q03577drs-1 - a member of the gene class aspartyl(D) tRNA Synthetase
B0464.3Q03561
C02C2.4P34272
C02D5.2P34276
C02F5.10P34287
C02F5.2P34279
C02F5.4P34281

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