Schema for accToKeyword
  Database: uniProt    Primary Table: accToKeyword    Row Count: 62,522,809   Data last updated: 2018-04-06
Format description: Relate keywords and accessions
On download server: MariaDB table dump directory
fieldexampleSQL type description
acc Q6GZX4char(12) Primary accession
keyword 1int(11) ID in keyword table

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

Sample Rows
 
acckeyword
Q6GZX41
Q6GZX42
Q6GZX43
Q6GZX44
Q6GZX45
Q6GZX32
Q6GZX36
Q6GZX37
Q6GZX33
Q6GZX38

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