Schema for kgAlias
  Database: hg19    Primary Table: kgAlias    Row Count: 2,560,159   Data last updated: 2024-08-23
Format description: Link together a Known Gene ID and a gene alias
On download server: MariaDB table dump directory
fieldexampleSQL type description
kgID ENST00000000233.10_4varchar(40) Known Gene ID
alias ARF5varchar(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.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.knownAttrs.kgID (via kgAlias.kgID)
      hg19.knownBlastTab.query (via kgAlias.kgID)
      hg19.knownBlastTab.target (via kgAlias.kgID)
      hg19.knownCanonToDecipher.name (via kgAlias.kgID)
      hg19.knownCanonical.transcript (via kgAlias.kgID)
      hg19.knownCds.name (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.knownToDecipher.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.knownToMrna.name (via kgAlias.kgID)
      hg19.knownToMrnaSingle.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.knownToTag.name (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)
      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
ENST00000000233.10_4ARF5
ENST00000000233.10_4ARF5_HUMAN
ENST00000000233.10_4ENST00000000233.1
ENST00000000233.10_4ENST00000000233.10_4
ENST00000000233.10_4ENST00000000233.2
ENST00000000233.10_4ENST00000000233.3
ENST00000000233.10_4ENST00000000233.4
ENST00000000233.10_4ENST00000000233.5
ENST00000000233.10_4ENST00000000233.6
ENST00000000233.10_4ENST00000000233.7

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