Schema for sangerLinks
  Database: ce4    Primary Table: sangerLinks    Row Count: 30,777   Data last updated: 2007-07-30
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 C. elegans KIN-10 protein; ...longblob   Freeform (except for no tabs) description

Connected Tables and Joining Fields
        ce4.kimExpDistance.query (via sangerLinks.orfName)
      ce4.kimExpDistance.target (via sangerLinks.orfName)
      ce4.mmBlastTab.query (via sangerLinks.orfName)
      ce4.orfToGene.name (via sangerLinks.orfName)
      ce4.sangerBlastTab.query (via sangerLinks.orfName)
      ce4.sangerBlastTab.target (via sangerLinks.orfName)
      ce4.sangerCanonical.transcript (via sangerLinks.orfName)
      ce4.sangerGene.name (via sangerLinks.orfName)
      ce4.sangerGeneToWBGeneID.sangerGene (via sangerLinks.orfName)
      ce4.sangerIsoforms.transcript (via sangerLinks.orfName)
      ce4.sangerPep.name (via sangerLinks.orfName)
      ce4.sangerToRefSeq.name (via sangerLinks.orfName)
      ce4.sangerCanonical.protein (via sangerLinks.protName)
      ce4.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.6aP28548C. elegans KIN-10 protein; contains similarity to Pfam domain PF01214 Casein kinase II regulatory subunitcontains similarity to ...
T14G10.1Q22501pps-1 is orthologous to human PAPSS1 (OMIM:603262) and human PAPSS2 (OMIM:603005, mutated in spondyloepimetaphyseal dysplasia).
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 ...
F58D5.2bQ7YTT0contains similarity to Homo sapiens Transmembrane protein 144; ENSEMBL:ENSP00000296529
C14C11.3Q17977contains similarity to Pfam domain PF00728 Glycosyl hydrolase family 20, catalytic domaincontains similarity to Interpro domain ...
R12A1.4Q04457ges-1 encodes a gut-specific type B carboxylesterase; by homology, GES-1 hydrolyzes carboxylic ester substrates to yield an alco ...
F35D2.5cQ86NH0C. elegans SYD-1 protein; contains similarity to Pfam domains PF00620 (RhoGAP domain), PF00168 (C2 domain)contains similarity to ...
C41C4.8P54812C. elegans CDC-48.2 protein; contains similarity to Pfam domains PF00004 (ATPase family associated with various cellular activit ...
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.