Schema for kgAlias
  Database: mm9    Primary Table: kgAlias    Row Count: 367,173   Data last updated: 2011-03-02
Format description: Link together a Known Gene ID and a gene alias
On download server: MariaDB table dump directory
fieldexampleSQL type info description
kgID uc007aet.1varchar(40) values Known Gene ID
alias AK135172varchar(80) values 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)
      mm9.affyGnfU74ADistance.query (via kgAlias.kgID)
      mm9.affyGnfU74ADistance.target (via kgAlias.kgID)
      mm9.affyGnfU74BDistance.query (via kgAlias.kgID)
      mm9.affyGnfU74BDistance.target (via kgAlias.kgID)
      mm9.affyGnfU74CDistance.query (via kgAlias.kgID)
      mm9.affyGnfU74CDistance.target (via kgAlias.kgID)
      mm9.bioCycPathway.kgID (via kgAlias.kgID)
      mm9.ccdsKgMap.geneId (via kgAlias.kgID)
      mm9.ceBlastTab.query (via kgAlias.kgID)
      mm9.dmBlastTab.query (via kgAlias.kgID)
      mm9.drBlastTab.query (via kgAlias.kgID)
      mm9.foldUtr3.name (via kgAlias.kgID)
      mm9.foldUtr5.name (via kgAlias.kgID)
      mm9.gnfAtlas2Distance.query (via kgAlias.kgID)
      mm9.gnfAtlas2Distance.target (via kgAlias.kgID)
      mm9.hgBlastTab.query (via kgAlias.kgID)
      mm9.keggPathway.kgID (via kgAlias.kgID)
      mm9.kgColor.kgID (via kgAlias.kgID)
      mm9.kgProtAlias.kgID (via kgAlias.kgID)
      mm9.kgProtMap2.qName (via kgAlias.kgID)
      mm9.kgSpAlias.kgID (via kgAlias.kgID)
      mm9.kgTargetAli.qName (via kgAlias.kgID)
      mm9.kgTxInfo.name (via kgAlias.kgID)
      mm9.kgXref.kgID (via kgAlias.kgID)
      mm9.knownBlastTab.query (via kgAlias.kgID)
      mm9.knownBlastTab.target (via kgAlias.kgID)
      mm9.knownCanonical.protein (via kgAlias.kgID)
      mm9.knownCanonical.transcript (via kgAlias.kgID)
      mm9.knownGene.name (via kgAlias.kgID)
      mm9.knownGeneMrna.name (via kgAlias.kgID)
      mm9.knownGenePep.name (via kgAlias.kgID)
      mm9.knownIsoforms.transcript (via kgAlias.kgID)
      mm9.knownToAllenBrain.name (via kgAlias.kgID)
      mm9.knownToEnsembl.name (via kgAlias.kgID)
      mm9.knownToGnfAtlas2.name (via kgAlias.kgID)
      mm9.knownToKeggEntrez.name (via kgAlias.kgID)
      mm9.knownToLocusLink.name (via kgAlias.kgID)
      mm9.knownToPfam.name (via kgAlias.kgID)
      mm9.knownToRefSeq.name (via kgAlias.kgID)
      mm9.knownToSuper.gene (via kgAlias.kgID)
      mm9.knownToVisiGene.name (via kgAlias.kgID)
      mm9.rnBlastTab.query (via kgAlias.kgID)
      mm9.scBlastTab.query (via kgAlias.kgID)
      mm9.ucscScop.ucscId (via kgAlias.kgID)

Sample Rows
 
kgIDalias
uc007aet.1AK135172
uc007aet.1mKIAA1889
uc007aet.1uc007aet.1
uc007aeu.1NM_001011874
uc007aeu.1NP_001011874
uc007aeu.1Q5GH67
uc007aeu.1XKR4_MOUSE
uc007aeu.1Xkr4
uc007aeu.1Xrg4
uc007aeu.1uc007aeu.1

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