Skip to main content
Schema for protein
  Database: uniProt    Primary Table: protein    Row Count: 28,967,110   Data last updated: 2018-04-07
Format description: Amino acid sequence
On download server: MariaDB table dump directory
fieldexampleSQL type description
acc Q6GZX4char(12) Primary accession
val MAFSAEDVLKEYDRRRRMEALLLSLYY...longblob Amino acids

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

Sample Rows
 
accval
Q6GZX4MAFSAEDVLKEYDRRRRMEALLLSLYYPNDRKLLDYKEWSPPRVQVECPKAPVEWNNPPSEKGLIVGHFSGIKYKGEKAQASEVDVNKMCCWVSKFKDAMRRYQGIQTCKIPGKVLSDLDAKIKAYNL ...
Q6GZX3MSIIGATRLQNDKSDTYSAGPCYAGGCSAFTPRGTCGKDWDLGEQTCASGFCTSQPLCARIKKTQVCGLRYSSKGKDPLVSAEWDSRGAPYVRCTYDADLIDTQAQVDQFVSMFGESPSLAERYCMRG ...
Q197F8MASNTVSAQGGSNRPVRDFSNIQDVAQFLLFDPIWNEQPGSIVPWKMNREQALAERYPELQTSEPSEDYSGPVESLELLPLEIKLDIMQYLSWEQISWCKHPWLWTRWYKDNVVRVSAITFEDFQREY ...
Q197F7MYQAINPCPQSWYGSPQLEREIVCKMSGAPHYPNYYPVHPNALGGAWFDTSLNARSLTTTPSLTTCTPPSLAACTPPTSLGMVDSPPHINPPRRIGTLCFDFGSAKSPQRCECVASDRPSTTSNTAPD ...
Q6GZX2MARPLLGKTSSVRRRLESLSACSIFFFLRKFCQKMASLVFLNSPVYQMSNILLTERRQVDRAMGGSDDDGVMVVALSPSDFKTVLGSALLAVERDMVHVVPKYLQTPGILHDMLVLLTPIFGEALSVD ...
Q6GZX1MNAKYDTDQGVGRMLFLGTIGLAVVVGGLMAYGYYYDGKTPSSGTSFHTASPSFSSRYRY
Q197F5MRYTVLIALQGALLLLLLIDDGQGQSPYPYPGMPCNSSRQCGLGTCVHSRCAHCSSDGTLCSPEDPTMVWPCCPESSCQLVVGLPSLVNHYNCLPNQCTDSSQCPGGFGCMTRRSKCELCKADGEACN ...
Q6GZX0MQNPLPEVMSPEHDKRTTTPMSKEANKFIRELDKKPGDLAVVSDFVKRNTGKRLPIGKRSNLYVRICDLSGTIYMGETFILESWEELYLPEPTKMEVLGTLESCCGIPPFPEWIVMVGEDQCVYAYGD ...
Q91G88MDSLNEVCYEQIKGTFYKGLFGDFPLIVDKKTGCFNATKLCVLGGKRFVDWNKTLRSKKLIQYYETRCDIKTESLLYEIKGDNNDEITKQITGTYLPKEFILDIASWISVEFYDKCNNIIINYFVNEY ...
Q6GZW9MYKMYFLKDQKFSLSGTIRINDKTQSEYGSVWCPGLSITGLHHDAIDHNMFEEMETEIIEYLGPWVQAEYRRIKG

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