Schema for kgAlias
  Database: hg16    Primary Table: kgAlias    Row Count: 107,325   Data last updated: 2004-03-27
Format description: Link together a Known Gene ID and a gene alias
On download server: MariaDB table dump directory
fieldexampleSQL type info description
kgID AB000099varchar(40) values Known Gene ID
alias DCRBvarchar(80) values a gene alias

Connected Tables and Joining Fields
        hg16.atlasOncoGene.locusSymbol (via kgAlias.alias)
      hg16.jaxOrtholog.humanSymbol (via kgAlias.alias)
      hg16.kgXref.geneSymbol (via kgAlias.alias)
      hg16.refFlat.geneName (via kgAlias.alias)
      hgFixed.refLink.name (via kgAlias.alias)
      visiGene.gene.name (via kgAlias.alias)
      hg16.bioCycPathway.kgID (via kgAlias.kgID)
      hg16.dmBlastTab.query (via kgAlias.kgID)
      hg16.drBlastTab.query (via kgAlias.kgID)
      hg16.dupSpMrna.mrnaID (via kgAlias.kgID)
      hg16.foldUtr3.name (via kgAlias.kgID)
      hg16.foldUtr5.name (via kgAlias.kgID)
      hg16.gnfAtlas2Distance.query (via kgAlias.kgID)
      hg16.gnfAtlas2Distance.target (via kgAlias.kgID)
      hg16.gnfU95Distance.query (via kgAlias.kgID)
      hg16.gnfU95Distance.target (via kgAlias.kgID)
      hg16.hg17Kg.name (via kgAlias.kgID)
      hg16.keggPathway.kgID (via kgAlias.kgID)
      hg16.kgProtAlias.kgID (via kgAlias.kgID)
      hg16.kgXref.kgID (via kgAlias.kgID)
      hg16.knownBlastTab.query (via kgAlias.kgID)
      hg16.knownBlastTab.target (via kgAlias.kgID)
      hg16.knownCanonical.transcript (via kgAlias.kgID)
      hg16.knownGene.name (via kgAlias.kgID)
      hg16.knownGeneLink.name (via kgAlias.kgID)
      hg16.knownGeneMrna.name (via kgAlias.kgID)
      hg16.knownGenePep.name (via kgAlias.kgID)
      hg16.knownIsoforms.transcript (via kgAlias.kgID)
      hg16.knownToEnsembl.name (via kgAlias.kgID)
      hg16.knownToGnfAtlas2.name (via kgAlias.kgID)
      hg16.knownToHInv.name (via kgAlias.kgID)
      hg16.knownToLocusLink.name (via kgAlias.kgID)
      hg16.knownToPfam.name (via kgAlias.kgID)
      hg16.knownToRefSeq.name (via kgAlias.kgID)
      hg16.knownToSuper.gene (via kgAlias.kgID)
      hg16.knownToU133.name (via kgAlias.kgID)
      hg16.knownToU95.name (via kgAlias.kgID)
      hg16.scBlastTab.query (via kgAlias.kgID)
      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)

Sample Rows
 
kgIDalias
AB000099DCRB
AB000099DSCR4
AB000099DSCRB
AB000099NM_005867
AB000114NM_005014
AB000114OMD
AB000114SLRR2C
AB000114osteoadherin
AB000115C1orf29
AB000115GS3686

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