Skip to main content
Schema for description
  Database: uniProt    Primary Table: description    Row Count: 28,967,110   Data last updated: 2018-04-07
Format description: Description lines
On download server: MariaDB table dump directory
fieldexampleSQL type description
acc Q6GZX4char(12) Primary accession
val RecName: Full=Putative tran...longtext SwissProt DE lines

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

Sample Rows
 
accval
Q6GZX4RecName: Full=Putative transcription factor 001R;
Q6GZX3RecName: Full=Uncharacterized protein 002L;
Q197F8RecName: Full=Uncharacterized protein 002R;
Q197F7RecName: Full=Uncharacterized protein 003L;
Q6GZX2RecName: Full=Uncharacterized protein 3R; Flags: Precursor;
Q6GZX1RecName: Full=Uncharacterized protein 004R;
Q197F5RecName: Full=Uncharacterized protein 005L; Flags: Precursor;
Q6GZX0RecName: Full=Uncharacterized protein 005R;
Q91G88RecName: Full=Putative KilA-N domain-containing protein 006L;
Q6GZW9RecName: Full=Uncharacterized protein 006R;

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