Schema for kgAlias
  Database: hg17    Primary Table: kgAlias    Row Count: 190,452   Data last updated: 2005-06-08
Format description: Link together a Known Gene ID and a gene alias
On download server: MariaDB table dump directory
fieldexampleSQL type info description
kgID AB000409varchar(40) values Known Gene ID
alias AB000409varchar(80) values a gene alias

Connected Tables and Joining Fields
        hg17.kgSpAlias.alias (via kgAlias.alias)
      hg17.kgXref.geneSymbol (via kgAlias.alias)
      hg17.refFlat.geneName (via kgAlias.alias)
      hgFixed.refLink.name (via kgAlias.alias)
      visiGene.gene.name (via kgAlias.alias)
      hg17.bioCycPathway.kgID (via kgAlias.kgID)
      hg17.ccdsKgMap.geneId (via kgAlias.kgID)
      hg17.ceBlastTab.query (via kgAlias.kgID)
      hg17.dmBlastTab.query (via kgAlias.kgID)
      hg17.drBlastTab.query (via kgAlias.kgID)
      hg17.dupSpMrna.mrnaID (via kgAlias.kgID)
      hg17.foldUtr3.name (via kgAlias.kgID)
      hg17.foldUtr5.name (via kgAlias.kgID)
      hg17.gladHumESDistance.query (via kgAlias.kgID)
      hg17.gladHumESDistance.target (via kgAlias.kgID)
      hg17.gnfAtlas2Distance.query (via kgAlias.kgID)
      hg17.gnfAtlas2Distance.target (via kgAlias.kgID)
      hg17.gnfU95Distance.query (via kgAlias.kgID)
      hg17.gnfU95Distance.target (via kgAlias.kgID)
      hg17.humanHprdP2P.query (via kgAlias.kgID)
      hg17.humanHprdP2P.target (via kgAlias.kgID)
      hg17.humanVidalP2P.query (via kgAlias.kgID)
      hg17.humanVidalP2P.target (via kgAlias.kgID)
      hg17.humanWankerP2P.query (via kgAlias.kgID)
      hg17.humanWankerP2P.target (via kgAlias.kgID)
      hg17.keggPathway.kgID (via kgAlias.kgID)
      hg17.kgProtAlias.kgID (via kgAlias.kgID)
      hg17.kgSpAlias.kgID (via kgAlias.kgID)
      hg17.kgTargetAli.qName (via kgAlias.kgID)
      hg17.kgXref.kgID (via kgAlias.kgID)
      hg17.knownBlastTab.query (via kgAlias.kgID)
      hg17.knownBlastTab.target (via kgAlias.kgID)
      hg17.knownCanonical.transcript (via kgAlias.kgID)
      hg17.knownExpDistance.query (via kgAlias.kgID)
      hg17.knownExpDistance.target (via kgAlias.kgID)
      hg17.knownGene.name (via kgAlias.kgID)
      hg17.knownGeneLink.name (via kgAlias.kgID)
      hg17.knownGeneMrna.name (via kgAlias.kgID)
      hg17.knownGenePep.name (via kgAlias.kgID)
      hg17.knownIsoforms.transcript (via kgAlias.kgID)
      hg17.knownToAllenBrain.name (via kgAlias.kgID)
      hg17.knownToEnsembl.name (via kgAlias.kgID)
      hg17.knownToGnf1h.name (via kgAlias.kgID)
      hg17.knownToGnfAtlas2.name (via kgAlias.kgID)
      hg17.knownToHInv.name (via kgAlias.kgID)
      hg17.knownToHprd.name (via kgAlias.kgID)
      hg17.knownToKeggEntrez.name (via kgAlias.kgID)
      hg17.knownToLocusLink.name (via kgAlias.kgID)
      hg17.knownToPfam.name (via kgAlias.kgID)
      hg17.knownToRefSeq.name (via kgAlias.kgID)
      hg17.knownToSuper.gene (via kgAlias.kgID)
      hg17.knownToU133.name (via kgAlias.kgID)
      hg17.knownToU133Plus2.name (via kgAlias.kgID)
      hg17.knownToU95.name (via kgAlias.kgID)
      hg17.knownToVisiGene.name (via kgAlias.kgID)
      hg17.mmBlastTab.query (via kgAlias.kgID)
      hg17.rankProp.query (via kgAlias.kgID)
      hg17.rankProp.target (via kgAlias.kgID)
      hg17.rnBlastTab.query (via kgAlias.kgID)
      hg17.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
AB000409AB000409
AB000409MKNK1
AB000409MNK1
AB000460AB000460
AB000461AB000461
AB000463AB000463
AB000463CRBM
AB000463RES4-23
AB000463SH3BP2
AB000781AB000781

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