Schema for displayId
  Database: uniProt    Primary Table: displayId    Row Count: 28,967,110   Data last updated: 2018-04-06
Format description: Relate ID and primary accession. A good table to use just get handle on all records.
On download server: MariaDB table dump directory
fieldexampleSQL type description
acc Q6GZX4char(12) Primary accession
val 001R_FRG3Gchar(24) SwissProt display ID

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

Sample Rows
 
accval
Q6GZX4001R_FRG3G
Q6GZX3002L_FRG3G
Q197F8002R_IIV3
Q197F7003L_IIV3
Q6GZX2003R_FRG3G
Q6GZX1004R_FRG3G
Q197F5005L_IIV3
Q6GZX0005R_FRG3G
Q91G88006L_IIV6
Q6GZW9006R_FRG3G

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