Schema for kgAlias
  Database: mm10    Primary Table: kgAlias    Row Count: 804,057   Data last updated: 2019-09-20
Format description: Link together a Known Gene ID and a gene alias
On download server: MariaDB table dump directory
fieldexampleSQL type description
kgID ENSMUST00000000001.4varchar(40) Known Gene ID
alias A2AE36varchar(80) a gene alias

Connected Tables and Joining Fields
        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)
      mm10.bioCycPathway.kgID (via kgAlias.kgID)
      mm10.ccdsKgMap.geneId (via kgAlias.kgID)
      mm10.ceBlastTab.query (via kgAlias.kgID)
      mm10.dmBlastTab.query (via kgAlias.kgID)
      mm10.drBlastTab.query (via kgAlias.kgID)
      mm10.foldUtr3.name (via kgAlias.kgID)
      mm10.foldUtr5.name (via kgAlias.kgID)
      mm10.hgBlastTab.query (via kgAlias.kgID)
      mm10.keggPathway.kgID (via kgAlias.kgID)
      mm10.kgColor.kgID (via kgAlias.kgID)
      mm10.kgProtAlias.kgID (via kgAlias.kgID)
      mm10.kgProtMap2.qName (via kgAlias.kgID)
      mm10.kgSpAlias.kgID (via kgAlias.kgID)
      mm10.kgTargetAli.qName (via kgAlias.kgID)
      mm10.kgTxInfo.name (via kgAlias.kgID)
      mm10.kgXref.kgID (via kgAlias.kgID)
      mm10.knownAttrs.kgID (via kgAlias.kgID)
      mm10.knownBlastTab.query (via kgAlias.kgID)
      mm10.knownBlastTab.target (via kgAlias.kgID)
      mm10.knownCanonical.transcript (via kgAlias.kgID)
      mm10.knownCds.name (via kgAlias.kgID)
      mm10.knownGene.name (via kgAlias.kgID)
      mm10.knownGeneMrna.name (via kgAlias.kgID)
      mm10.knownGenePep.name (via kgAlias.kgID)
      mm10.knownIsoforms.transcript (via kgAlias.kgID)
      mm10.knownToEnsembl.name (via kgAlias.kgID)
      mm10.knownToKeggEntrez.name (via kgAlias.kgID)
      mm10.knownToLocusLink.name (via kgAlias.kgID)
      mm10.knownToLynx.name (via kgAlias.kgID)
      mm10.knownToMrna.name (via kgAlias.kgID)
      mm10.knownToMrnaSingle.name (via kgAlias.kgID)
      mm10.knownToPfam.name (via kgAlias.kgID)
      mm10.knownToRefSeq.name (via kgAlias.kgID)
      mm10.knownToSuper.gene (via kgAlias.kgID)
      mm10.knownToTag.name (via kgAlias.kgID)
      mm10.knownToVisiGene.name (via kgAlias.kgID)
      mm10.knownToWikipedia.name (via kgAlias.kgID)
      mm10.rnBlastTab.query (via kgAlias.kgID)
      mm10.scBlastTab.query (via kgAlias.kgID)
      mm10.ucscScop.ucscId (via kgAlias.kgID)

Sample Rows
 
kgIDalias
ENSMUST00000000001.4A2AE36
ENSMUST00000000001.4ENSMUST00000000001.4
ENSMUST00000000001.4GNAI3_MOUSE
ENSMUST00000000001.4Gnai3
ENSMUST00000000001.4NM_010306
ENSMUST00000000001.4Q3TGV1
ENSMUST00000000001.4Q61019
ENSMUST00000000001.4Q9DC51
ENSMUST00000000001.4uc008qyd.1
ENSMUST00000000001.4uc008qyd.2

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