Schema for sangerLinks
  Database: ce6    Primary Table: sangerLinks    Row Count: 30,115   Data last updated: 2008-06-18
Format description: Links from WormBase ORF to SwissProt/trEMBL ID and Description
On download server: MariaDB table dump directory
fieldexampleSQL type info description
orfName T01G9.6avarchar(255) values WormBase Sequence/ORF Name
protName P28548varchar(255) values SwissProt/trEMBL ID
description kin-10 encodes a putative r...longblob   Freeform (except for no tabs) description

Connected Tables and Joining Fields
        ce6.dmBlastTab.query (via sangerLinks.orfName)
      ce6.drBlastTab.query (via sangerLinks.orfName)
      ce6.hgBlastTab.query (via sangerLinks.orfName)
      ce6.kimExpDistance.query (via sangerLinks.orfName)
      ce6.kimExpDistance.target (via sangerLinks.orfName)
      ce6.mmBlastTab.query (via sangerLinks.orfName)
      ce6.orfToGene.name (via sangerLinks.orfName)
      ce6.rnBlastTab.query (via sangerLinks.orfName)
      ce6.sangerBlastTab.query (via sangerLinks.orfName)
      ce6.sangerBlastTab.target (via sangerLinks.orfName)
      ce6.sangerCanonical.transcript (via sangerLinks.orfName)
      ce6.sangerGene.name (via sangerLinks.orfName)
      ce6.sangerGeneToWBGeneID.sangerGene (via sangerLinks.orfName)
      ce6.sangerIsoforms.transcript (via sangerLinks.orfName)
      ce6.sangerPep.name (via sangerLinks.orfName)
      ce6.sangerToRefSeq.name (via sangerLinks.orfName)
      ce6.scBlastTab.query (via sangerLinks.orfName)
      ce6.sangerCanonical.protein (via sangerLinks.protName)
      ce6.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
T01G9.6aP28548kin-10 encodes a putative regulatory (beta) subunit of casein kinase II required for both viability and male mating behavior, th ...
Y48E1B.12O45952C. elegans CSC-1 protein ;
K04F10.4aP51559bli-4 encodes a variety of related subtilases (serine endoproteases of the KEX2/subtilisin class), with shared N-termini but var ...
T25F10.2O02424dbl-1 encodes a member of the transforming growth factor beta (TGFbeta) superfamily that includes Drosophila decapentaplegic (Dp ...
C14C11.3Q17977hex-2 encodes a beta-N-acetylhexosaminidase.
R12A1.4Q04457ges-1 encodes a gut-specific type B carboxylesterase; by homology, GES-1 hydrolyzes carboxylic ester substrates to yield an alco ...
F35D2.5cQ86NH1C. elegans SYD-1 protein; contains similarity to Pfam domains PF00620 (RhoGAP domain) , PF00168 (C2 domain) contains similarity ...
C41C4.8P54812C. elegans CDC-48.2 protein; contains similarity to Pfam domains PF00004 (ATPase family associated with various cellular activit ...
R05H5.3Q21763contains similarity to Pfam domain PF00578 AhpC/TSA family contains similarity to Interpro domains IPR011594 (Thioredoxin-like), ...
B0303.3P34255B0303.3 is orthologous to the human gene 3-KETOACYL-COA THIOLASE BETA-SUBUNIT OF TRIFUNCTIONAL PROTEIN (HADHB; OMIM:143450), whi ...

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