Schema for info
  Database: uniProt    Primary Table: info    Row Count: 28,934,417   Data last updated: 2018-04-06
Format description: Small stuff with at most one copy associated with each SwissProt record
On download server: MariaDB table dump directory
fieldexampleSQL type description
acc Q6GZX4char(12) Primary accession
isCurated 1tinyint(4) True if curated (SwissProt rather than trEMBL)
aaSize 256int(11) Size in amino acids
molWeight 29735int(11) Molecular weight
createDate 2011-06-28date Creation date
seqDate 2004-07-19date Sequence last update date
annDate 2012-04-18date Annotation last update date
organelle 0int(11) Pointer into organelle table

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

Sample Rows
 
accisCuratedaaSizemolWeightcreateDateseqDateannDateorganelle
Q6GZX41256297352011-06-282004-07-192012-04-180
Q6GZX31320346422011-06-282004-07-192011-10-190
Q197F81458539212009-06-162006-07-112011-09-210
Q197F71156170432009-06-162006-07-112011-09-210
Q6GZX21438482972011-06-282004-07-192011-09-210
Q6GZX116065142011-06-282004-07-192011-09-210
Q197F51217238542009-06-162006-07-112011-09-210
Q6GZX01204234182011-06-282004-07-192011-09-210
Q91G881352416582009-06-162001-12-012012-11-280
Q6GZW917588482011-06-282004-07-192011-09-210

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