Schema for kgAlias
  Database: mm7    Primary Table: kgAlias    Row Count: 150,174   Data last updated: 2005-11-14
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 AB001539varchar(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)
      mm7.affyGnfU74ADistance.query (via kgAlias.kgID)
      mm7.affyGnfU74ADistance.target (via kgAlias.kgID)
      mm7.affyGnfU74BDistance.query (via kgAlias.kgID)
      mm7.affyGnfU74BDistance.target (via kgAlias.kgID)
      mm7.affyGnfU74CDistance.query (via kgAlias.kgID)
      mm7.affyGnfU74CDistance.target (via kgAlias.kgID)
      mm7.dmBlastTab.query (via kgAlias.kgID)
      mm7.drBlastTab.query (via kgAlias.kgID)
      mm7.dupSpMrna.mrnaID (via kgAlias.kgID)
      mm7.foldUtr3.name (via kgAlias.kgID)
      mm7.foldUtr5.name (via kgAlias.kgID)
      mm7.gnfAtlas2Distance.query (via kgAlias.kgID)
      mm7.gnfAtlas2Distance.target (via kgAlias.kgID)
      mm7.hgBlastTab.query (via kgAlias.kgID)
      mm7.keggPathway.kgID (via kgAlias.kgID)
      mm7.kgProtAlias.kgID (via kgAlias.kgID)
      mm7.kgSpAlias.kgID (via kgAlias.kgID)
      mm7.kgXref.kgID (via kgAlias.kgID)
      mm7.knownBlastTab.query (via kgAlias.kgID)
      mm7.knownBlastTab.target (via kgAlias.kgID)
      mm7.knownCanonical.transcript (via kgAlias.kgID)
      mm7.knownGene.name (via kgAlias.kgID)
      mm7.knownGeneLink.name (via kgAlias.kgID)
      mm7.knownGeneMrna.name (via kgAlias.kgID)
      mm7.knownGenePep.name (via kgAlias.kgID)
      mm7.knownIsoforms.transcript (via kgAlias.kgID)
      mm7.knownToAllenBrain.name (via kgAlias.kgID)
      mm7.knownToEnsembl.name (via kgAlias.kgID)
      mm7.knownToGnfAtlas2.name (via kgAlias.kgID)
      mm7.knownToKeggEntrez.name (via kgAlias.kgID)
      mm7.knownToLocusLink.name (via kgAlias.kgID)
      mm7.knownToPfam.name (via kgAlias.kgID)
      mm7.knownToRefSeq.name (via kgAlias.kgID)
      mm7.knownToVisiGene.name (via kgAlias.kgID)
      mm7.rnBlastTab.query (via kgAlias.kgID)
      mm7.scBlastTab.query (via kgAlias.kgID)

Sample Rows
 
kgIDalias
AB001539AB001539
AB001539Grwd1
AB001926AB001926
AB003147AB003147
AB003147Bfsp1
AB003147CP95
AB003503AB003503
AB003503Gspt2
AB004048AB004048
AB004048AK077465

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