Database: hg19    Primary Table: kgAlias    Row Count: 564,599
Format description: Link together a Known Gene ID and a gene alias

field	example	SQL type	description
kgID	uc001aaa.3	varchar(40)	Known Gene ID
alias	BC032353	varchar(80)	a gene alias

      hg19.kgSpAlias.alias (via kgAlias.alias)
      hg19.kgXref.geneSymbol (via kgAlias.alias)
      hg19.omimMorbidMap.geneSymbols (via kgAlias.alias)
      hg19.refFlat.geneName (via kgAlias.alias)
      hg19.refLink.name (via kgAlias.alias)
      hg19.bioCycPathway.kgID (via kgAlias.kgID)
      hg19.ccdsKgMap.geneId (via kgAlias.kgID)
      hg19.ceBlastTab.query (via kgAlias.kgID)
      hg19.dmBlastTab.query (via kgAlias.kgID)
      hg19.drBlastTab.query (via kgAlias.kgID)
      hg19.foldUtr3.name (via kgAlias.kgID)
      hg19.foldUtr5.name (via kgAlias.kgID)
      hg19.gnfAtlas2Distance.query (via kgAlias.kgID)
      hg19.gnfAtlas2Distance.target (via kgAlias.kgID)
      hg19.humanHprdP2P.query (via kgAlias.kgID)
      hg19.humanHprdP2P.target (via kgAlias.kgID)
      hg19.humanVidalP2P.query (via kgAlias.kgID)
      hg19.humanVidalP2P.target (via kgAlias.kgID)
      hg19.humanWankerP2P.query (via kgAlias.kgID)
      hg19.humanWankerP2P.target (via kgAlias.kgID)
      hg19.keggPathway.kgID (via kgAlias.kgID)
      hg19.kg4ToKg5.newId (via kgAlias.kgID)
      hg19.kgColor.kgID (via kgAlias.kgID)
      hg19.kgProtAlias.kgID (via kgAlias.kgID)
      hg19.kgProtMap2.qName (via kgAlias.kgID)
      hg19.kgSpAlias.kgID (via kgAlias.kgID)
      hg19.kgTargetAli.qName (via kgAlias.kgID)
      hg19.kgTxInfo.name (via kgAlias.kgID)
      hg19.kgXref.kgID (via kgAlias.kgID)
      hg19.knownBlastTab.query (via kgAlias.kgID)
      hg19.knownBlastTab.target (via kgAlias.kgID)
      hg19.knownCanonical.protein (via kgAlias.kgID)
      hg19.knownCanonical.transcript (via kgAlias.kgID)
      hg19.knownGene.name (via kgAlias.kgID)
      hg19.knownGeneMrna.name (via kgAlias.kgID)
      hg19.knownGenePep.name (via kgAlias.kgID)
      hg19.knownIsoforms.transcript (via kgAlias.kgID)
      hg19.knownToAllenBrain.name (via kgAlias.kgID)
      hg19.knownToEnsembl.name (via kgAlias.kgID)
      hg19.knownToGnfAtlas2.name (via kgAlias.kgID)
      hg19.knownToHprd.name (via kgAlias.kgID)
      hg19.knownToLocusLink.name (via kgAlias.kgID)
      hg19.knownToPfam.name (via kgAlias.kgID)
      hg19.knownToRefSeq.name (via kgAlias.kgID)
      hg19.knownToSuper.gene (via kgAlias.kgID)
      hg19.knownToTreefam.name (via kgAlias.kgID)
      hg19.knownToU133.name (via kgAlias.kgID)
      hg19.knownToVisiGene.name (via kgAlias.kgID)
      hg19.mmBlastTab.query (via kgAlias.kgID)
      hg19.rnBlastTab.query (via kgAlias.kgID)
      hg19.scBlastTab.query (via kgAlias.kgID)

kgID	alias
uc001aaa.3	BC032353
uc001aaa.3	DDX11L1
uc001aaa.3	uc001aaa.2
uc001aaa.3	uc001aaa.3
uc001aab.3	CR613196
uc001aab.3	DKFZp434K1323
uc001aab.3	uc001aab.2
uc001aab.3	uc001aab.3
uc001aac.3	BC063459
uc001aac.3	DKFZp434K1323

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