Schema for comment
  Database: uniProt    Primary Table: comment    Row Count: 37,377,887   Data last updated: 2018-04-06
Format description: A structured comment
On download server: MariaDB table dump directory
fieldexampleSQL type description
acc Q6GZX4char(12) Primary accession
commentType 1int(11) ID in commentType table
commentVal 1int(11) ID in commentVal table

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

Sample Rows
 
acccommentTypecommentVal
Q6GZX411
Q6GZX322
Q6GZX122
Q91G8833
Q91G8834
Q6GZW635
Q6GZW636
Q6GZW522
Q6GZW422
Q197E722

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