Schema for extDbRef
  Database: uniProt    Primary Table: extDbRef    Row Count: 330,212,589   Data last updated: 2018-04-06
Format description: A reference to another database
On download server: MariaDB table dump directory
fieldexampleSQL type description
acc Q6GZX4char(12) Primary SwissProt accession
extDb 1int(11) ID in extDb table
extAcc1 AY548484varchar(255) External accession
extAcc2 AAT09660.1varchar(255) External accession
extAcc3 -varchar(255) External accession

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

Sample Rows
 
accextDbextAcc1extAcc2extAcc3
Q6GZX41AY548484AAT09660.1-
Q6GZX42YP_031579.1NC_005946.1
Q6GZX43Q6GZX4-
Q6GZX442947773-
Q6GZX45CLSP2511514-
Q6GZX46GO:0006355P:regulatioo
Q6GZX46GO:0046782P:regulatioo
Q6GZX46GO:0006351P:transcriptionDNA-dependent
Q6GZX47IPR007031Poxvirus_VLTF3
Q6GZX48PF04947Pox_VLTF31

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