Schema for kgAlias
  Database: hg18    Primary Table: kgAlias    Row Count: 458,806   Data last updated: 2009-03-03
Format description: Link together a Known Gene ID and a gene alias
On download server: MariaDB table dump directory
fieldexampleSQL type info description
kgID uc001aaa.2varchar(40) values Known Gene ID
alias BC032353varchar(80) values a gene alias

Connected Tables and Joining Fields
        hg18.kgSpAlias.alias (via kgAlias.alias)
      hg18.kgXref.geneSymbol (via kgAlias.alias)
      hg18.refFlat.geneName (via kgAlias.alias)
      hgFixed.refLink.name (via kgAlias.alias)
      visiGene.gene.name (via kgAlias.alias)
      hg18.bioCycPathway.kgID (via kgAlias.kgID)
      hg18.ccdsKgMap.geneId (via kgAlias.kgID)
      hg18.ceBlastTab.query (via kgAlias.kgID)
      hg18.dmBlastTab.query (via kgAlias.kgID)
      hg18.drBlastTab.query (via kgAlias.kgID)
      hg18.foldUtr3.name (via kgAlias.kgID)
      hg18.foldUtr5.name (via kgAlias.kgID)
      hg18.gnfAtlas2Distance.query (via kgAlias.kgID)
      hg18.gnfAtlas2Distance.target (via kgAlias.kgID)
      hg18.gnfU95Distance.query (via kgAlias.kgID)
      hg18.gnfU95Distance.target (via kgAlias.kgID)
      hg18.humanHprdP2P.query (via kgAlias.kgID)
      hg18.humanHprdP2P.target (via kgAlias.kgID)
      hg18.humanVidalP2P.query (via kgAlias.kgID)
      hg18.humanVidalP2P.target (via kgAlias.kgID)
      hg18.humanWankerP2P.query (via kgAlias.kgID)
      hg18.humanWankerP2P.target (via kgAlias.kgID)
      hg18.keggPathway.kgID (via kgAlias.kgID)
      hg18.kgColor.kgID (via kgAlias.kgID)
      hg18.kgProtAlias.kgID (via kgAlias.kgID)
      hg18.kgProtMap2.qName (via kgAlias.kgID)
      hg18.kgSpAlias.kgID (via kgAlias.kgID)
      hg18.kgTargetAli.qName (via kgAlias.kgID)
      hg18.kgTxInfo.name (via kgAlias.kgID)
      hg18.kgXref.kgID (via kgAlias.kgID)
      hg18.knownBlastTab.query (via kgAlias.kgID)
      hg18.knownBlastTab.target (via kgAlias.kgID)
      hg18.knownCanonToDecipher.name (via kgAlias.kgID)
      hg18.knownCanonical.protein (via kgAlias.kgID)
      hg18.knownCanonical.transcript (via kgAlias.kgID)
      hg18.knownGene.name (via kgAlias.kgID)
      hg18.knownGeneMrna.name (via kgAlias.kgID)
      hg18.knownGenePep.name (via kgAlias.kgID)
      hg18.knownIsoforms.transcript (via kgAlias.kgID)
      hg18.knownToAllenBrain.name (via kgAlias.kgID)
      hg18.knownToDecipher.name (via kgAlias.kgID)
      hg18.knownToEnsembl.name (via kgAlias.kgID)
      hg18.knownToGnf1h.name (via kgAlias.kgID)
      hg18.knownToGnfAtlas2.name (via kgAlias.kgID)
      hg18.knownToHInv.name (via kgAlias.kgID)
      hg18.knownToHprd.name (via kgAlias.kgID)
      hg18.knownToKeggEntrez.name (via kgAlias.kgID)
      hg18.knownToLocusLink.name (via kgAlias.kgID)
      hg18.knownToMupit.name (via kgAlias.kgID)
      hg18.knownToPfam.name (via kgAlias.kgID)
      hg18.knownToRefSeq.name (via kgAlias.kgID)
      hg18.knownToSuper.gene (via kgAlias.kgID)
      hg18.knownToTreefam.name (via kgAlias.kgID)
      hg18.knownToU133.name (via kgAlias.kgID)
      hg18.knownToU133Plus2.name (via kgAlias.kgID)
      hg18.knownToU95.name (via kgAlias.kgID)
      hg18.knownToVisiGene.name (via kgAlias.kgID)
      hg18.mmBlastTab.query (via kgAlias.kgID)
      hg18.rnBlastTab.query (via kgAlias.kgID)
      hg18.scBlastTab.query (via kgAlias.kgID)
      hg18.ucscScop.ucscId (via kgAlias.kgID)
      knownGeneV39.bioCycPathway.kgID (via kgAlias.kgID)
      knownGeneV39.ceBlastTab.query (via kgAlias.kgID)
      knownGeneV39.dmBlastTab.query (via kgAlias.kgID)
      knownGeneV39.drBlastTab.query (via kgAlias.kgID)
      knownGeneV39.foldUtr3.name (via kgAlias.kgID)
      knownGeneV39.foldUtr5.name (via kgAlias.kgID)
      knownGeneV39.gnfAtlas2Distance.query (via kgAlias.kgID)
      knownGeneV39.gnfAtlas2Distance.target (via kgAlias.kgID)
      knownGeneV39.kgAlias.kgID (via kgAlias.kgID)
      knownGeneV39.kgColor.kgID (via kgAlias.kgID)
      knownGeneV39.kgProtAlias.kgID (via kgAlias.kgID)
      knownGeneV39.kgSpAlias.kgID (via kgAlias.kgID)
      knownGeneV39.kgTargetAli.qName (via kgAlias.kgID)
      knownGeneV39.kgXref.kgID (via kgAlias.kgID)
      knownGeneV39.knownAttrs.kgID (via kgAlias.kgID)
      knownGeneV39.knownBlastTab.query (via kgAlias.kgID)
      knownGeneV39.knownBlastTab.target (via kgAlias.kgID)
      knownGeneV39.knownCanonical.protein (via kgAlias.kgID)
      knownGeneV39.knownCanonical.transcript (via kgAlias.kgID)
      knownGeneV39.knownCds.name (via kgAlias.kgID)
      knownGeneV39.knownGene.name (via kgAlias.kgID)
      knownGeneV39.knownGeneMrna.name (via kgAlias.kgID)
      knownGeneV39.knownGenePep.name (via kgAlias.kgID)
      knownGeneV39.knownIsoforms.transcript (via kgAlias.kgID)
      knownGeneV39.knownToEnsembl.name (via kgAlias.kgID)
      knownGeneV39.knownToGnfAtlas2.name (via kgAlias.kgID)
      knownGeneV39.knownToHprd.name (via kgAlias.kgID)
      knownGeneV39.knownToLocusLink.name (via kgAlias.kgID)
      knownGeneV39.knownToMrna.name (via kgAlias.kgID)
      knownGeneV39.knownToMrnaSingle.name (via kgAlias.kgID)
      knownGeneV39.knownToMupit.name (via kgAlias.kgID)
      knownGeneV39.knownToPfam.name (via kgAlias.kgID)
      knownGeneV39.knownToRefSeq.name (via kgAlias.kgID)
      knownGeneV39.knownToSuper.gene (via kgAlias.kgID)
      knownGeneV39.knownToTag.name (via kgAlias.kgID)
      knownGeneV39.knownToU133.name (via kgAlias.kgID)
      knownGeneV39.knownToU95.name (via kgAlias.kgID)
      knownGeneV39.knownToVisiGene.name (via kgAlias.kgID)
      knownGeneV39.knownToWikipedia.name (via kgAlias.kgID)
      knownGeneV39.mmBlastTab.query (via kgAlias.kgID)
      knownGeneV39.rnBlastTab.query (via kgAlias.kgID)
      knownGeneV39.scBlastTab.query (via kgAlias.kgID)
      knownGeneV39.ucscScop.ucscId (via kgAlias.kgID)

Sample Rows
 
kgIDalias
uc001aaa.2BC032353
uc001aaa.2uc001aaa.1
uc001aaa.2uc001aaa.2
uc001aab.2CR613196
uc001aab.2DKFZp434K1323
uc001aab.2uc001aab.1
uc001aab.2uc001aab.2
uc001aac.2BC063459
uc001aac.2FLJ00038
uc001aac.2uc001aac.1

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