Schema for kgAlias
  Database: rn3    Primary Table: kgAlias    Row Count: 25,711   Data last updated: 2004-03-23
Format description: Link together a Known Gene ID and a gene alias
On download server: MariaDB table dump directory
fieldexampleSQL type info description
kgID AB000098varchar(40) values Known Gene ID
alias Mipp65varchar(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)
      rn3.dmBlastTab.query (via kgAlias.kgID)
      rn3.drBlastTab.query (via kgAlias.kgID)
      rn3.dupSpMrna.mrnaID (via kgAlias.kgID)
      rn3.gnfAtlas2Distance.query (via kgAlias.kgID)
      rn3.gnfAtlas2Distance.target (via kgAlias.kgID)
      rn3.hgBlastTab.query (via kgAlias.kgID)
      rn3.keggPathway.kgID (via kgAlias.kgID)
      rn3.kgProtAlias.kgID (via kgAlias.kgID)
      rn3.kgSpAlias.kgID (via kgAlias.kgID)
      rn3.kgXref.kgID (via kgAlias.kgID)
      rn3.knownBlastTab.query (via kgAlias.kgID)
      rn3.knownBlastTab.target (via kgAlias.kgID)
      rn3.knownCanonical.transcript (via kgAlias.kgID)
      rn3.knownGene.name (via kgAlias.kgID)
      rn3.knownGeneLink.name (via kgAlias.kgID)
      rn3.knownGeneMrna.name (via kgAlias.kgID)
      rn3.knownGenePep.name (via kgAlias.kgID)
      rn3.knownIsoforms.transcript (via kgAlias.kgID)
      rn3.knownToEnsembl.name (via kgAlias.kgID)
      rn3.knownToGnfAtlas2.name (via kgAlias.kgID)
      rn3.knownToLocusLink.name (via kgAlias.kgID)
      rn3.knownToPfam.name (via kgAlias.kgID)
      rn3.knownToRefSeq.name (via kgAlias.kgID)
      rn3.knownToSuper.gene (via kgAlias.kgID)
      rn3.scBlastTab.query (via kgAlias.kgID)

Sample Rows
 
kgIDalias
AB000098Mipp65
AB000098NM_022607
AB000107NM_022537
AB000107Prlpd
AB000113ATRC3
AB000113CAT-3
AB000113CAT3
AB000113FLJ14541
AB000113NM_017217
AB000113SLC7A3

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