Schema for kgAlias
  Database: hg19    Primary Table: kgAlias    Row Count: 621,522   Data last updated: 2021-12-14
Format description: Link together a Known Gene ID and a gene alias
On download server: MariaDB table dump directory
fieldexampleSQL type description
kgID uc001aaa.3varchar(40) Known Gene ID
alias DDX11L1varchar(80) a gene alias

Connected Tables and Joining Fields
        hg19.kgSpAlias.alias (via kgAlias.alias)
      hg19.kgXref.geneSymbol (via kgAlias.alias)
      hg19.refFlat.geneName (via kgAlias.alias)
      hgFixed.refLink.name (via kgAlias.alias)
      visiGene.gene.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.gnfU95Distance.query (via kgAlias.kgID)
      hg19.gnfU95Distance.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.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.transcript (via kgAlias.kgID)
      hg19.knownGene.name (via kgAlias.kgID)
      hg19.knownGeneMrna.name (via kgAlias.kgID)
      hg19.knownGenePep.name (via kgAlias.kgID)
      hg19.knownGeneTxMrna.name (via kgAlias.kgID)
      hg19.knownGeneTxPep.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.knownToHInv.name (via kgAlias.kgID)
      hg19.knownToHprd.name (via kgAlias.kgID)
      hg19.knownToKeggEntrez.name (via kgAlias.kgID)
      hg19.knownToLocusLink.name (via kgAlias.kgID)
      hg19.knownToLynx.name (via kgAlias.kgID)
      hg19.knownToMupit.name (via kgAlias.kgID)
      hg19.knownToNextProt.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.knownToU133Plus2.name (via kgAlias.kgID)
      hg19.knownToU95.name (via kgAlias.kgID)
      hg19.knownToVisiGene.name (via kgAlias.kgID)
      hg19.knownToWikipedia.name (via kgAlias.kgID)
      hg19.mmBlastTab.query (via kgAlias.kgID)
      hg19.rnBlastTab.query (via kgAlias.kgID)
      hg19.scBlastTab.query (via kgAlias.kgID)
      hg19.ucscScop.ucscId (via kgAlias.kgID)

Sample Rows
 
kgIDalias
uc001aaa.3DDX11L1
uc001aaa.3NR_046018
uc001aaa.3uc001aaa.3
uc001aac.4BC063459
uc001aac.4WASH7P
uc001aac.4uc001aac.4
uc001aae.4BC053987
uc001aae.4WASH7P
uc001aae.4uc001aae.4
uc001aah.4NR_024540

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