Schema for citation
  Database: uniProt    Primary Table: citation    Row Count: 35,635,564   Data last updated: 2018-04-06
Format description: A SwissProt citation of a reference
On download server: MariaDB table dump directory
fieldexampleSQL type description
id 1int(11) ID of this citation
acc Q6GZX4char(12) Primary accession
reference 1int(11) ID in reference table
rp 1int(11) ID in rp table

Connected Tables and Joining Fields
        ce2.sangerCanonical.protein (via citation.acc)
      ce2.sangerGene.proteinID (via citation.acc)
      ce2.sangerLinks.protName (via citation.acc)
      ce4.sangerCanonical.protein (via citation.acc)
      ce4.sangerGene.proteinID (via citation.acc)
      ce4.sangerLinks.protName (via citation.acc)
      ce6.sangerCanonical.protein (via citation.acc)
      ce6.sangerGene.proteinID (via citation.acc)
      ce6.sangerLinks.protName (via citation.acc)
      dm1.bdgpCanonical.protein (via citation.acc)
      dm1.bdgpGene.proteinID (via citation.acc)
      dm1.bdgpSwissProt.swissProtId (via citation.acc)
      dm1.flyBaseSwissProt.swissProtId (via citation.acc)
      go.goaPart.dbObjectId (via citation.acc)
      hg16.kgProtAlias.alias (via citation.acc)
      hg16.kgProtMap.qName (via citation.acc)
      hg16.kgXref.spID (via citation.acc)
      hg17.kgProtAlias.alias (via citation.acc)
      hg17.kgProtMap.qName (via citation.acc)
      hg17.kgSpAlias.spID (via citation.acc)
      hg17.kgXref.spID (via citation.acc)
      hg18.kgSpAlias.spID (via citation.acc)
      hg18.kgXref.spID (via citation.acc)
      hg19.kgSpAlias.spID (via citation.acc)
      hg19.kgXref.spID (via citation.acc)
      hg38.kgSpAlias.spID (via citation.acc)
      hg38.kgXref.spID (via citation.acc)
      knownGeneV39.kgProtAlias.alias (via citation.acc)
      knownGeneV39.kgSpAlias.spID (via citation.acc)
      knownGeneV39.kgXref.spID (via citation.acc)
      mm10.kgSpAlias.spID (via citation.acc)
      mm10.kgXref.spID (via citation.acc)
      mm7.kgProtAlias.alias (via citation.acc)
      mm7.kgProtMap.qName (via citation.acc)
      mm7.kgSpAlias.spID (via citation.acc)
      mm7.kgXref.spID (via citation.acc)
      mm8.kgProtAlias.alias (via citation.acc)
      mm8.kgProtMap.qName (via citation.acc)
      mm8.kgSpAlias.spID (via citation.acc)
      mm8.kgXref.spID (via citation.acc)
      mm9.kgSpAlias.spID (via citation.acc)
      mm9.kgXref.spID (via citation.acc)
      proteome.spOldNew.acc (via citation.acc)
      proteome.spReactomeEvent.spID (via citation.acc)
      proteome.spReactomeId.spID (via citation.acc)
      rn3.kgProtAlias.alias (via citation.acc)
      rn3.kgProtMap.qName (via citation.acc)
      rn3.kgSpAlias.spID (via citation.acc)
      rn3.kgXref.spID (via citation.acc)
      rn4.rgdGene2ToUniProt.value (via citation.acc)
      sacCer1.sgdCanonical.protein (via citation.acc)
      sacCer1.sgdGene.proteinID (via citation.acc)
      sacCer1.sgdToSwissProt.value (via citation.acc)
      sacCer2.sgdCanonical.protein (via citation.acc)
      sacCer2.sgdGene.proteinID (via citation.acc)
      sacCer2.sgdToSwissProt.value (via citation.acc)
      sacCer3.sgdCanonical.protein (via citation.acc)
      sacCer3.sgdGene.proteinID (via citation.acc)
      sacCer3.sgdToSwissProt.value (via citation.acc)
      uniProt.accToKeyword.acc (via citation.acc)
      uniProt.accToTaxon.acc (via citation.acc)
      uniProt.comment.acc (via citation.acc)
      uniProt.description.acc (via citation.acc)
      uniProt.displayId.acc (via citation.acc)
      uniProt.extDbRef.acc (via citation.acc)
      uniProt.feature.acc (via citation.acc)
      uniProt.gene.acc (via citation.acc)
      uniProt.geneLogic.acc (via citation.acc)
      uniProt.info.acc (via citation.acc)
      uniProt.otherAcc.acc (via citation.acc)
      uniProt.protein.acc (via citation.acc)
      visiGene.gene.uniProt (via citation.acc)
      uniProt.citationRc.citation (via citation.id)
      uniProt.reference.id (via citation.reference)
      uniProt.referenceAuthors.reference (via citation.reference)
      uniProt.citationRp.id (via citation.rp)

Sample Rows
 
idaccreferencerp
1Q6GZX411
2Q6GZX311
3Q197F821
4Q197F721
5Q6GZX211
6Q6GZX111
7Q197F521
8Q6GZX011
9Q91G8831
10Q91G8842

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