Schema for kgProtAlias
  Database: hg17    Primary Table: kgProtAlias    Row Count: 212,983   Data last updated: 2005-06-05
Format description: Link together a Known Gene ID and a protein alias
On download server: MariaDB table dump directory
fieldexampleSQL type info description
kgID AB000409varchar(255) values Known Gene ID
displayID Q9BUB5-2varchar(255) values protein display ID
alias Q5TC08varchar(255) values a protein alias

Connected Tables and Joining Fields
        go.goaPart.dbObjectId (via kgProtAlias.alias)
      hg17.kgProtMap.qName (via kgProtAlias.alias)
      hg17.kgSpAlias.alias (via kgProtAlias.alias)
      hg17.kgSpAlias.spID (via kgProtAlias.alias)
      hg17.kgXref.protAcc (via kgProtAlias.alias)
      hg17.kgXref.spID (via kgProtAlias.alias)
      hgFixed.refLink.protAcc (via kgProtAlias.alias)
      knownGeneV39.kgProtAlias.alias (via kgProtAlias.alias)
      knownGeneV39.kgSpAlias.alias (via kgProtAlias.alias)
      knownGeneV39.kgSpAlias.spID (via kgProtAlias.alias)
      knownGeneV39.kgXref.protAcc (via kgProtAlias.alias)
      knownGeneV39.kgXref.spID (via kgProtAlias.alias)
      proteome.spOldNew.acc (via kgProtAlias.alias)
      proteome.spReactomeEvent.spID (via kgProtAlias.alias)
      proteome.spReactomeId.spID (via kgProtAlias.alias)
      uniProt.accToKeyword.acc (via kgProtAlias.alias)
      uniProt.accToTaxon.acc (via kgProtAlias.alias)
      uniProt.citation.acc (via kgProtAlias.alias)
      uniProt.comment.acc (via kgProtAlias.alias)
      uniProt.description.acc (via kgProtAlias.alias)
      uniProt.displayId.acc (via kgProtAlias.alias)
      uniProt.extDbRef.acc (via kgProtAlias.alias)
      uniProt.feature.acc (via kgProtAlias.alias)
      uniProt.gene.acc (via kgProtAlias.alias)
      uniProt.geneLogic.acc (via kgProtAlias.alias)
      uniProt.info.acc (via kgProtAlias.alias)
      uniProt.otherAcc.acc (via kgProtAlias.alias)
      uniProt.protein.acc (via kgProtAlias.alias)
      visiGene.gene.uniProt (via kgProtAlias.alias)
      go.goaPart.dbObjectSymbol (via kgProtAlias.displayID)
      hg17.dupSpMrna.dupProteinID (via kgProtAlias.displayID)
      hg17.dupSpMrna.proteinID (via kgProtAlias.displayID)
      hg17.kgSpAlias.alias (via kgProtAlias.displayID)
      hg17.kgXref.spDisplayID (via kgProtAlias.displayID)
      hg17.knownCanonical.protein (via kgProtAlias.displayID)
      hg17.spMrna.spID (via kgProtAlias.displayID)
      knownGeneV39.kgProtAlias.displayID (via kgProtAlias.displayID)
      knownGeneV39.kgSpAlias.alias (via kgProtAlias.displayID)
      knownGeneV39.kgXref.spDisplayID (via kgProtAlias.displayID)
      knownGeneV39.knownCanonical.protein (via kgProtAlias.displayID)
      proteome.spOldNew.newDisplayId (via kgProtAlias.displayID)
      proteome.spOldNew.oldDisplayId (via kgProtAlias.displayID)
      uniProt.displayId.val (via kgProtAlias.displayID)
      hg17.bioCycPathway.kgID (via kgProtAlias.kgID)
      hg17.ccdsKgMap.geneId (via kgProtAlias.kgID)
      hg17.ceBlastTab.query (via kgProtAlias.kgID)
      hg17.dmBlastTab.query (via kgProtAlias.kgID)
      hg17.drBlastTab.query (via kgProtAlias.kgID)
      hg17.dupSpMrna.mrnaID (via kgProtAlias.kgID)
      hg17.foldUtr3.name (via kgProtAlias.kgID)
      hg17.foldUtr5.name (via kgProtAlias.kgID)
      hg17.gladHumESDistance.query (via kgProtAlias.kgID)
      hg17.gladHumESDistance.target (via kgProtAlias.kgID)
      hg17.gnfAtlas2Distance.query (via kgProtAlias.kgID)
      hg17.gnfAtlas2Distance.target (via kgProtAlias.kgID)
      hg17.gnfU95Distance.query (via kgProtAlias.kgID)
      hg17.gnfU95Distance.target (via kgProtAlias.kgID)
      hg17.humanHprdP2P.query (via kgProtAlias.kgID)
      hg17.humanHprdP2P.target (via kgProtAlias.kgID)
      hg17.humanVidalP2P.query (via kgProtAlias.kgID)
      hg17.humanVidalP2P.target (via kgProtAlias.kgID)
      hg17.humanWankerP2P.query (via kgProtAlias.kgID)
      hg17.humanWankerP2P.target (via kgProtAlias.kgID)
      hg17.keggPathway.kgID (via kgProtAlias.kgID)
      hg17.kgAlias.kgID (via kgProtAlias.kgID)
      hg17.kgSpAlias.kgID (via kgProtAlias.kgID)
      hg17.kgTargetAli.qName (via kgProtAlias.kgID)
      hg17.kgXref.kgID (via kgProtAlias.kgID)
      hg17.knownBlastTab.query (via kgProtAlias.kgID)
      hg17.knownBlastTab.target (via kgProtAlias.kgID)
      hg17.knownCanonical.transcript (via kgProtAlias.kgID)
      hg17.knownExpDistance.query (via kgProtAlias.kgID)
      hg17.knownExpDistance.target (via kgProtAlias.kgID)
      hg17.knownGene.name (via kgProtAlias.kgID)
      hg17.knownGeneLink.name (via kgProtAlias.kgID)
      hg17.knownGeneMrna.name (via kgProtAlias.kgID)
      hg17.knownGenePep.name (via kgProtAlias.kgID)
      hg17.knownIsoforms.transcript (via kgProtAlias.kgID)
      hg17.knownToAllenBrain.name (via kgProtAlias.kgID)
      hg17.knownToEnsembl.name (via kgProtAlias.kgID)
      hg17.knownToGnf1h.name (via kgProtAlias.kgID)
      hg17.knownToGnfAtlas2.name (via kgProtAlias.kgID)
      hg17.knownToHInv.name (via kgProtAlias.kgID)
      hg17.knownToHprd.name (via kgProtAlias.kgID)
      hg17.knownToKeggEntrez.name (via kgProtAlias.kgID)
      hg17.knownToLocusLink.name (via kgProtAlias.kgID)
      hg17.knownToPfam.name (via kgProtAlias.kgID)
      hg17.knownToRefSeq.name (via kgProtAlias.kgID)
      hg17.knownToSuper.gene (via kgProtAlias.kgID)
      hg17.knownToU133.name (via kgProtAlias.kgID)
      hg17.knownToU133Plus2.name (via kgProtAlias.kgID)
      hg17.knownToU95.name (via kgProtAlias.kgID)
      hg17.knownToVisiGene.name (via kgProtAlias.kgID)
      hg17.mmBlastTab.query (via kgProtAlias.kgID)
      hg17.rankProp.query (via kgProtAlias.kgID)
      hg17.rankProp.target (via kgProtAlias.kgID)
      hg17.rnBlastTab.query (via kgProtAlias.kgID)
      hg17.scBlastTab.query (via kgProtAlias.kgID)
      knownGeneV39.bioCycPathway.kgID (via kgProtAlias.kgID)
      knownGeneV39.ceBlastTab.query (via kgProtAlias.kgID)
      knownGeneV39.dmBlastTab.query (via kgProtAlias.kgID)
      knownGeneV39.drBlastTab.query (via kgProtAlias.kgID)
      knownGeneV39.foldUtr3.name (via kgProtAlias.kgID)
      knownGeneV39.foldUtr5.name (via kgProtAlias.kgID)
      knownGeneV39.gnfAtlas2Distance.query (via kgProtAlias.kgID)
      knownGeneV39.gnfAtlas2Distance.target (via kgProtAlias.kgID)
      knownGeneV39.kgAlias.kgID (via kgProtAlias.kgID)
      knownGeneV39.kgColor.kgID (via kgProtAlias.kgID)
      knownGeneV39.kgProtAlias.kgID (via kgProtAlias.kgID)
      knownGeneV39.kgSpAlias.kgID (via kgProtAlias.kgID)
      knownGeneV39.kgTargetAli.qName (via kgProtAlias.kgID)
      knownGeneV39.kgXref.kgID (via kgProtAlias.kgID)
      knownGeneV39.knownAttrs.kgID (via kgProtAlias.kgID)
      knownGeneV39.knownBlastTab.query (via kgProtAlias.kgID)
      knownGeneV39.knownBlastTab.target (via kgProtAlias.kgID)
      knownGeneV39.knownCanonical.protein (via kgProtAlias.kgID)
      knownGeneV39.knownCanonical.transcript (via kgProtAlias.kgID)
      knownGeneV39.knownCds.name (via kgProtAlias.kgID)
      knownGeneV39.knownGene.name (via kgProtAlias.kgID)
      knownGeneV39.knownGeneMrna.name (via kgProtAlias.kgID)
      knownGeneV39.knownGenePep.name (via kgProtAlias.kgID)
      knownGeneV39.knownIsoforms.transcript (via kgProtAlias.kgID)
      knownGeneV39.knownToEnsembl.name (via kgProtAlias.kgID)
      knownGeneV39.knownToGnfAtlas2.name (via kgProtAlias.kgID)
      knownGeneV39.knownToHprd.name (via kgProtAlias.kgID)
      knownGeneV39.knownToLocusLink.name (via kgProtAlias.kgID)
      knownGeneV39.knownToMrna.name (via kgProtAlias.kgID)
      knownGeneV39.knownToMrnaSingle.name (via kgProtAlias.kgID)
      knownGeneV39.knownToMupit.name (via kgProtAlias.kgID)
      knownGeneV39.knownToPfam.name (via kgProtAlias.kgID)
      knownGeneV39.knownToRefSeq.name (via kgProtAlias.kgID)
      knownGeneV39.knownToSuper.gene (via kgProtAlias.kgID)
      knownGeneV39.knownToTag.name (via kgProtAlias.kgID)
      knownGeneV39.knownToU133.name (via kgProtAlias.kgID)
      knownGeneV39.knownToU95.name (via kgProtAlias.kgID)
      knownGeneV39.knownToVisiGene.name (via kgProtAlias.kgID)
      knownGeneV39.knownToWikipedia.name (via kgProtAlias.kgID)
      knownGeneV39.mmBlastTab.query (via kgProtAlias.kgID)
      knownGeneV39.rnBlastTab.query (via kgProtAlias.kgID)
      knownGeneV39.scBlastTab.query (via kgProtAlias.kgID)
      knownGeneV39.ucscScop.ucscId (via kgProtAlias.kgID)

Sample Rows
 
kgIDdisplayIDalias
AB000409Q9BUB5-2Q5TC08
AB000409Q9BUB5-2Q6V0N6
AB000409Q9BUB5-2Q7Z319
AB000409Q9BUB5-2Q9BUB5
AB000409Q9BUB5-2Q9BUB5-2
AB000460P78311_HUMANBAA19116
AB000460P78311_HUMANO43607
AB000460P78311_HUMANP78311
AB000460P78311_HUMANP78311_HUMAN
AB000460P78311_HUMANP78312

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