Schema for kgProtAlias
  Database: hg19    Primary Table: kgProtAlias    Row Count: 743,916   Data last updated: 2024-08-23
Format description: Link together a Known Gene ID and a protein alias
On download server: MariaDB table dump directory
fieldexampleSQL type description
kgID ENST00000000233.10_4varchar(255) Known Gene ID
displayID P84085varchar(255) protein display ID
alias ARF5varchar(255) a protein alias

Connected Tables and Joining Fields
        hg19.kgSpAlias.alias (via kgProtAlias.alias)
      hg19.kgXref.protAcc (via kgProtAlias.alias)
      hgFixed.refLink.protAcc (via kgProtAlias.alias)
      knownGeneV39.kgProtAlias.alias (via kgProtAlias.alias)
      knownGeneV39.kgSpAlias.alias (via kgProtAlias.alias)
      knownGeneV39.kgXref.protAcc (via kgProtAlias.alias)
      hg19.bioCycPathway.kgID (via kgProtAlias.kgID)
      hg19.ceBlastTab.query (via kgProtAlias.kgID)
      hg19.dmBlastTab.query (via kgProtAlias.kgID)
      hg19.drBlastTab.query (via kgProtAlias.kgID)
      hg19.foldUtr3.name (via kgProtAlias.kgID)
      hg19.foldUtr5.name (via kgProtAlias.kgID)
      hg19.gnfAtlas2Distance.query (via kgProtAlias.kgID)
      hg19.gnfAtlas2Distance.target (via kgProtAlias.kgID)
      hg19.gnfU95Distance.query (via kgProtAlias.kgID)
      hg19.gnfU95Distance.target (via kgProtAlias.kgID)
      hg19.humanHprdP2P.query (via kgProtAlias.kgID)
      hg19.humanHprdP2P.target (via kgProtAlias.kgID)
      hg19.humanVidalP2P.query (via kgProtAlias.kgID)
      hg19.humanVidalP2P.target (via kgProtAlias.kgID)
      hg19.humanWankerP2P.query (via kgProtAlias.kgID)
      hg19.humanWankerP2P.target (via kgProtAlias.kgID)
      hg19.keggPathway.kgID (via kgProtAlias.kgID)
      hg19.kgAlias.kgID (via kgProtAlias.kgID)
      hg19.kgColor.kgID (via kgProtAlias.kgID)
      hg19.kgProtMap2.qName (via kgProtAlias.kgID)
      hg19.kgSpAlias.kgID (via kgProtAlias.kgID)
      hg19.kgTargetAli.qName (via kgProtAlias.kgID)
      hg19.kgTxInfo.name (via kgProtAlias.kgID)
      hg19.kgXref.kgID (via kgProtAlias.kgID)
      hg19.knownAttrs.kgID (via kgProtAlias.kgID)
      hg19.knownBlastTab.query (via kgProtAlias.kgID)
      hg19.knownBlastTab.target (via kgProtAlias.kgID)
      hg19.knownCanonToDecipher.name (via kgProtAlias.kgID)
      hg19.knownCanonical.transcript (via kgProtAlias.kgID)
      hg19.knownCds.name (via kgProtAlias.kgID)
      hg19.knownGene.name (via kgProtAlias.kgID)
      hg19.knownGeneMrna.name (via kgProtAlias.kgID)
      hg19.knownGenePep.name (via kgProtAlias.kgID)
      hg19.knownGeneTxMrna.name (via kgProtAlias.kgID)
      hg19.knownGeneTxPep.name (via kgProtAlias.kgID)
      hg19.knownIsoforms.transcript (via kgProtAlias.kgID)
      hg19.knownToAllenBrain.name (via kgProtAlias.kgID)
      hg19.knownToDecipher.name (via kgProtAlias.kgID)
      hg19.knownToEnsembl.name (via kgProtAlias.kgID)
      hg19.knownToGnfAtlas2.name (via kgProtAlias.kgID)
      hg19.knownToHInv.name (via kgProtAlias.kgID)
      hg19.knownToHprd.name (via kgProtAlias.kgID)
      hg19.knownToKeggEntrez.name (via kgProtAlias.kgID)
      hg19.knownToLocusLink.name (via kgProtAlias.kgID)
      hg19.knownToLynx.name (via kgProtAlias.kgID)
      hg19.knownToMrna.name (via kgProtAlias.kgID)
      hg19.knownToMrnaSingle.name (via kgProtAlias.kgID)
      hg19.knownToMupit.name (via kgProtAlias.kgID)
      hg19.knownToNextProt.name (via kgProtAlias.kgID)
      hg19.knownToPfam.name (via kgProtAlias.kgID)
      hg19.knownToRefSeq.name (via kgProtAlias.kgID)
      hg19.knownToSuper.gene (via kgProtAlias.kgID)
      hg19.knownToTag.name (via kgProtAlias.kgID)
      hg19.knownToTreefam.name (via kgProtAlias.kgID)
      hg19.knownToU133.name (via kgProtAlias.kgID)
      hg19.knownToU133Plus2.name (via kgProtAlias.kgID)
      hg19.knownToU95.name (via kgProtAlias.kgID)
      hg19.knownToVisiGene.name (via kgProtAlias.kgID)
      hg19.knownToWikipedia.name (via kgProtAlias.kgID)
      hg19.mmBlastTab.query (via kgProtAlias.kgID)
      hg19.rnBlastTab.query (via kgProtAlias.kgID)
      hg19.scBlastTab.query (via kgProtAlias.kgID)
      hg19.ucscScop.ucscId (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
ENST00000000233.10_4P84085ARF5
ENST00000000233.10_4P84085ARF5_HUMAN
ENST00000000233.10_4P84085NM_001662
ENST00000000233.10_4P84085P26437
ENST00000000233.10_4P84085P84085
ENST00000000412.3Q96AH2M6PR
ENST00000000412.3Q96AH2NM_002355
ENST00000000412.3Q96AH2Q96AH2
ENST00000000412.3Q96AH2Q96AH2_HUMAN
ENST00000000442.11_8Q569H8ESRRA

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