Database: hg19    Primary Table: kgProtAlias    Row Count: 367,583
Format description: Link together a Known Gene ID and a protein alias

field	example	SQL type	info	description
kgID	uc001aal.1	varchar(255)	values	Known Gene ID
displayID	Q8NH21	varchar(255)	values	protein display ID
alias	NP_001005484	varchar(255)	values	a protein alias

      hg19.kgSpAlias.alias (via kgProtAlias.alias)
      hg19.kgXref.protAcc (via kgProtAlias.alias)
      hg19.refLink.protAcc (via kgProtAlias.alias)
      hg19.seq.acc (via kgProtAlias.alias)
      hg19.bioCycPathway.kgID (via kgProtAlias.kgID)
      hg19.ccdsKgMap.geneId (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.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.kg4ToKg5.newId (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.knownBlastTab.query (via kgProtAlias.kgID)
      hg19.knownBlastTab.target (via kgProtAlias.kgID)
      hg19.knownCanonical.protein (via kgProtAlias.kgID)
      hg19.knownCanonical.transcript (via kgProtAlias.kgID)
      hg19.knownGene.name (via kgProtAlias.kgID)
      hg19.knownGeneMrna.name (via kgProtAlias.kgID)
      hg19.knownGenePep.name (via kgProtAlias.kgID)
      hg19.knownIsoforms.transcript (via kgProtAlias.kgID)
      hg19.knownToAllenBrain.name (via kgProtAlias.kgID)
      hg19.knownToEnsembl.name (via kgProtAlias.kgID)
      hg19.knownToGnfAtlas2.name (via kgProtAlias.kgID)
      hg19.knownToHprd.name (via kgProtAlias.kgID)
      hg19.knownToLocusLink.name (via kgProtAlias.kgID)
      hg19.knownToPfam.name (via kgProtAlias.kgID)
      hg19.knownToRefSeq.name (via kgProtAlias.kgID)
      hg19.knownToSuper.gene (via kgProtAlias.kgID)
      hg19.knownToTreefam.name (via kgProtAlias.kgID)
      hg19.knownToU133.name (via kgProtAlias.kgID)
      hg19.knownToVisiGene.name (via kgProtAlias.kgID)
      hg19.mmBlastTab.query (via kgProtAlias.kgID)
      hg19.rnBlastTab.query (via kgProtAlias.kgID)
      hg19.scBlastTab.query (via kgProtAlias.kgID)

kgID	displayID	alias
uc001aal.1	Q8NH21	NP_001005484
uc001aal.1	Q8NH21	OR4F5
uc001aal.1	Q8NH21	OR4F5_HUMAN
uc001aal.1	Q8NH21	Q5VT22
uc001aal.1	Q8NH21	Q8NH21
uc001aal.1	Q8NH21	uc009vjh.1
uc001aau.2	B4DF06	B4DF06
uc001aau.2	B4DF06	B4DF06_HUMAN
uc001aau.2	B4DF06	LOC100132287
uc001aau.2	B4DF06	uc001aau.1

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