Schema for kgAlias
  Database: mm8    Primary Table: kgAlias    Row Count: 184,352   Data last updated: 2006-05-04
Format description: Link together a Known Gene ID and a gene alias
On download server: MariaDB table dump directory
fieldexampleSQL type info description
kgID AB001539varchar(40) values Known Gene ID
alias A301varchar(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)
      mm8.affyGnfU74ADistance.query (via kgAlias.kgID)
      mm8.affyGnfU74ADistance.target (via kgAlias.kgID)
      mm8.affyGnfU74BDistance.query (via kgAlias.kgID)
      mm8.affyGnfU74BDistance.target (via kgAlias.kgID)
      mm8.affyGnfU74CDistance.query (via kgAlias.kgID)
      mm8.affyGnfU74CDistance.target (via kgAlias.kgID)
      mm8.ccdsKgMap.geneId (via kgAlias.kgID)
      mm8.ceBlastTab.query (via kgAlias.kgID)
      mm8.dmBlastTab.query (via kgAlias.kgID)
      mm8.drBlastTab.query (via kgAlias.kgID)
      mm8.dupSpMrna.mrnaID (via kgAlias.kgID)
      mm8.foldUtr3.name (via kgAlias.kgID)
      mm8.foldUtr5.name (via kgAlias.kgID)
      mm8.gnfAtlas2Distance.query (via kgAlias.kgID)
      mm8.gnfAtlas2Distance.target (via kgAlias.kgID)
      mm8.hgBlastTab.query (via kgAlias.kgID)
      mm8.keggPathway.kgID (via kgAlias.kgID)
      mm8.kgProtAlias.kgID (via kgAlias.kgID)
      mm8.kgSpAlias.kgID (via kgAlias.kgID)
      mm8.kgTargetAli.qName (via kgAlias.kgID)
      mm8.kgXref.kgID (via kgAlias.kgID)
      mm8.knownBlastTab.query (via kgAlias.kgID)
      mm8.knownBlastTab.target (via kgAlias.kgID)
      mm8.knownCanonical.transcript (via kgAlias.kgID)
      mm8.knownGene.name (via kgAlias.kgID)
      mm8.knownGeneMrna.name (via kgAlias.kgID)
      mm8.knownGenePep.name (via kgAlias.kgID)
      mm8.knownIsoforms.transcript (via kgAlias.kgID)
      mm8.knownToAllenBrain.name (via kgAlias.kgID)
      mm8.knownToEnsembl.name (via kgAlias.kgID)
      mm8.knownToGnfAtlas2.name (via kgAlias.kgID)
      mm8.knownToKeggEntrez.name (via kgAlias.kgID)
      mm8.knownToLocusLink.name (via kgAlias.kgID)
      mm8.knownToPfam.name (via kgAlias.kgID)
      mm8.knownToRefSeq.name (via kgAlias.kgID)
      mm8.knownToSuper.gene (via kgAlias.kgID)
      mm8.knownToVisiGene.name (via kgAlias.kgID)
      mm8.rnBlastTab.query (via kgAlias.kgID)
      mm8.scBlastTab.query (via kgAlias.kgID)

Sample Rows
 
kgIDalias
AB001539A301
AB001539AB001539
AB001539AK077611
AB001539GRWD
AB001539GRWD1
AB001539Grwd1
AB001539NM_153419
AB001539WDR28
AB001750AB001750
AB001750NM_019400

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