Schema for kgAlias
  Database: mm39    Primary Table: kgAlias    Row Count: 1,945,627   Data last updated: 2024-08-15
Format description: Link together a Known Gene ID and a gene alias
On download server: MariaDB table dump directory
fieldexampleSQL type description
kgID ENSMUST00000000001.5varchar(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)
      mm39.bioCycPathway.kgID (via kgAlias.kgID)
      mm39.ceBlastTab.query (via kgAlias.kgID)
      mm39.dmBlastTab.query (via kgAlias.kgID)
      mm39.drBlastTab.query (via kgAlias.kgID)
      mm39.foldUtr3.name (via kgAlias.kgID)
      mm39.foldUtr5.name (via kgAlias.kgID)
      mm39.hgBlastTab.query (via kgAlias.kgID)
      mm39.kgColor.kgID (via kgAlias.kgID)
      mm39.kgProtAlias.kgID (via kgAlias.kgID)
      mm39.kgSpAlias.kgID (via kgAlias.kgID)
      mm39.kgTargetAli.qName (via kgAlias.kgID)
      mm39.kgXref.kgID (via kgAlias.kgID)
      mm39.knownAttrs.kgID (via kgAlias.kgID)
      mm39.knownBlastTab.query (via kgAlias.kgID)
      mm39.knownBlastTab.target (via kgAlias.kgID)
      mm39.knownCanonical.transcript (via kgAlias.kgID)
      mm39.knownCds.name (via kgAlias.kgID)
      mm39.knownGene.name (via kgAlias.kgID)
      mm39.knownGeneMrna.name (via kgAlias.kgID)
      mm39.knownIsoforms.transcript (via kgAlias.kgID)
      mm39.knownToEnsembl.name (via kgAlias.kgID)
      mm39.knownToLocusLink.name (via kgAlias.kgID)
      mm39.knownToMrna.name (via kgAlias.kgID)
      mm39.knownToMrnaSingle.name (via kgAlias.kgID)
      mm39.knownToMupit.name (via kgAlias.kgID)
      mm39.knownToNextProt.name (via kgAlias.kgID)
      mm39.knownToPfam.name (via kgAlias.kgID)
      mm39.knownToRefSeq.name (via kgAlias.kgID)
      mm39.knownToSuper.gene (via kgAlias.kgID)
      mm39.knownToTag.name (via kgAlias.kgID)
      mm39.knownToVisiGene.name (via kgAlias.kgID)
      mm39.knownToWikipedia.name (via kgAlias.kgID)
      mm39.rnBlastTab.query (via kgAlias.kgID)
      mm39.scBlastTab.query (via kgAlias.kgID)
      mm39.ucscScop.ucscId (via kgAlias.kgID)

Sample Rows
 
kgIDalias
ENSMUST00000000001.5A2AE36
ENSMUST00000000001.5ENSMUST00000000001.1
ENSMUST00000000001.5ENSMUST00000000001.2
ENSMUST00000000001.5ENSMUST00000000001.3
ENSMUST00000000001.5ENSMUST00000000001.4
ENSMUST00000000001.5ENSMUST00000000001.5
ENSMUST00000000001.5GNAI3_MOUSE
ENSMUST00000000001.5Gnai3
ENSMUST00000000001.5NM_010306
ENSMUST00000000001.5Q3TGV1

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