Schema for kgProtAlias
  Database: hg16    Primary Table: kgProtAlias    Row Count: 131,504   Data last updated: 2004-03-27
Format description: Link together a Known Gene ID and a protein alias
On download server: MariaDB table dump directory
fieldexampleSQL type info description
kgID AB000099varchar(40) values Known Gene ID
displayID DSR4_HUMANvarchar(40) values protein display ID
alias BAA25877varchar(80) values a protein alias

Connected Tables and Joining Fields
        go.goaPart.dbObjectId (via kgProtAlias.alias)
      hg16.kgProtMap.qName (via kgProtAlias.alias)
      hg16.kgXref.protAcc (via kgProtAlias.alias)
      hg16.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)
      hg16.dupSpMrna.dupProteinID (via kgProtAlias.displayID)
      hg16.dupSpMrna.proteinID (via kgProtAlias.displayID)
      hg16.kgXref.spDisplayID (via kgProtAlias.displayID)
      hg16.knownCanonical.protein (via kgProtAlias.displayID)
      hg16.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)
      hg16.bioCycPathway.kgID (via kgProtAlias.kgID)
      hg16.dmBlastTab.query (via kgProtAlias.kgID)
      hg16.drBlastTab.query (via kgProtAlias.kgID)
      hg16.dupSpMrna.mrnaID (via kgProtAlias.kgID)
      hg16.foldUtr3.name (via kgProtAlias.kgID)
      hg16.foldUtr5.name (via kgProtAlias.kgID)
      hg16.gnfAtlas2Distance.query (via kgProtAlias.kgID)
      hg16.gnfAtlas2Distance.target (via kgProtAlias.kgID)
      hg16.gnfU95Distance.query (via kgProtAlias.kgID)
      hg16.gnfU95Distance.target (via kgProtAlias.kgID)
      hg16.hg17Kg.name (via kgProtAlias.kgID)
      hg16.keggPathway.kgID (via kgProtAlias.kgID)
      hg16.kgAlias.kgID (via kgProtAlias.kgID)
      hg16.kgXref.kgID (via kgProtAlias.kgID)
      hg16.knownBlastTab.query (via kgProtAlias.kgID)
      hg16.knownBlastTab.target (via kgProtAlias.kgID)
      hg16.knownCanonical.transcript (via kgProtAlias.kgID)
      hg16.knownGene.name (via kgProtAlias.kgID)
      hg16.knownGeneLink.name (via kgProtAlias.kgID)
      hg16.knownGeneMrna.name (via kgProtAlias.kgID)
      hg16.knownGenePep.name (via kgProtAlias.kgID)
      hg16.knownIsoforms.transcript (via kgProtAlias.kgID)
      hg16.knownToEnsembl.name (via kgProtAlias.kgID)
      hg16.knownToGnfAtlas2.name (via kgProtAlias.kgID)
      hg16.knownToHInv.name (via kgProtAlias.kgID)
      hg16.knownToLocusLink.name (via kgProtAlias.kgID)
      hg16.knownToPfam.name (via kgProtAlias.kgID)
      hg16.knownToRefSeq.name (via kgProtAlias.kgID)
      hg16.knownToSuper.gene (via kgProtAlias.kgID)
      hg16.knownToU133.name (via kgProtAlias.kgID)
      hg16.knownToU95.name (via kgProtAlias.kgID)
      hg16.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
AB000099DSR4_HUMANBAA25877
AB000099DSR4_HUMANDSR4_HUMAN
AB000099DSR4_HUMANNP_005858
AB000099DSR4_HUMANP56555
AB000114OMD_HUMANBAA19055
AB000114OMD_HUMANNP_005005
AB000114OMD_HUMANOMD_HUMAN
AB000114OMD_HUMANQ99983
AB000115Q99984BAA19056
AB000115Q99984NP_006811

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