Schema for kgSpAlias
  Database: hg18    Primary Table: kgSpAlias    Row Count: 458,806   Data last updated: 2009-03-06
Format description: Associates Known Gene ID with UniProt accession and gene or protein alias
On download server: MariaDB table dump directory
fieldexampleSQL type info description
kgID uc001aaa.2varchar(40) values Known Gene ID
spID  varchar(40) values UniProt accession
alias BC032353varchar(40) values Alias, could be either gene alias or protein alias

Connected Tables and Joining Fields
        hg18.kgAlias.alias (via kgSpAlias.alias)
      hg18.kgProtAlias.alias (via kgSpAlias.alias)
      hg18.kgXref.geneSymbol (via kgSpAlias.alias)
      hg18.kgXref.protAcc (via kgSpAlias.alias)
      hg18.refFlat.geneName (via kgSpAlias.alias)
      hgFixed.refLink.name (via kgSpAlias.alias)
      hgFixed.refLink.protAcc (via kgSpAlias.alias)
      knownGeneV39.kgProtAlias.alias (via kgSpAlias.alias)
      knownGeneV39.kgSpAlias.alias (via kgSpAlias.alias)
      knownGeneV39.kgXref.protAcc (via kgSpAlias.alias)
      visiGene.gene.name (via kgSpAlias.alias)
      hg18.bioCycPathway.kgID (via kgSpAlias.kgID)
      hg18.ccdsKgMap.geneId (via kgSpAlias.kgID)
      hg18.ceBlastTab.query (via kgSpAlias.kgID)
      hg18.dmBlastTab.query (via kgSpAlias.kgID)
      hg18.drBlastTab.query (via kgSpAlias.kgID)
      hg18.foldUtr3.name (via kgSpAlias.kgID)
      hg18.foldUtr5.name (via kgSpAlias.kgID)
      hg18.gnfAtlas2Distance.query (via kgSpAlias.kgID)
      hg18.gnfAtlas2Distance.target (via kgSpAlias.kgID)
      hg18.gnfU95Distance.query (via kgSpAlias.kgID)
      hg18.gnfU95Distance.target (via kgSpAlias.kgID)
      hg18.humanHprdP2P.query (via kgSpAlias.kgID)
      hg18.humanHprdP2P.target (via kgSpAlias.kgID)
      hg18.humanVidalP2P.query (via kgSpAlias.kgID)
      hg18.humanVidalP2P.target (via kgSpAlias.kgID)
      hg18.humanWankerP2P.query (via kgSpAlias.kgID)
      hg18.humanWankerP2P.target (via kgSpAlias.kgID)
      hg18.keggPathway.kgID (via kgSpAlias.kgID)
      hg18.kgAlias.kgID (via kgSpAlias.kgID)
      hg18.kgColor.kgID (via kgSpAlias.kgID)
      hg18.kgProtAlias.kgID (via kgSpAlias.kgID)
      hg18.kgProtMap2.qName (via kgSpAlias.kgID)
      hg18.kgTargetAli.qName (via kgSpAlias.kgID)
      hg18.kgTxInfo.name (via kgSpAlias.kgID)
      hg18.kgXref.kgID (via kgSpAlias.kgID)
      hg18.knownBlastTab.query (via kgSpAlias.kgID)
      hg18.knownBlastTab.target (via kgSpAlias.kgID)
      hg18.knownCanonToDecipher.name (via kgSpAlias.kgID)
      hg18.knownCanonical.protein (via kgSpAlias.kgID)
      hg18.knownCanonical.transcript (via kgSpAlias.kgID)
      hg18.knownGene.name (via kgSpAlias.kgID)
      hg18.knownGeneMrna.name (via kgSpAlias.kgID)
      hg18.knownGenePep.name (via kgSpAlias.kgID)
      hg18.knownIsoforms.transcript (via kgSpAlias.kgID)
      hg18.knownToAllenBrain.name (via kgSpAlias.kgID)
      hg18.knownToDecipher.name (via kgSpAlias.kgID)
      hg18.knownToEnsembl.name (via kgSpAlias.kgID)
      hg18.knownToGnf1h.name (via kgSpAlias.kgID)
      hg18.knownToGnfAtlas2.name (via kgSpAlias.kgID)
      hg18.knownToHInv.name (via kgSpAlias.kgID)
      hg18.knownToHprd.name (via kgSpAlias.kgID)
      hg18.knownToKeggEntrez.name (via kgSpAlias.kgID)
      hg18.knownToLocusLink.name (via kgSpAlias.kgID)
      hg18.knownToMupit.name (via kgSpAlias.kgID)
      hg18.knownToPfam.name (via kgSpAlias.kgID)
      hg18.knownToRefSeq.name (via kgSpAlias.kgID)
      hg18.knownToSuper.gene (via kgSpAlias.kgID)
      hg18.knownToTreefam.name (via kgSpAlias.kgID)
      hg18.knownToU133.name (via kgSpAlias.kgID)
      hg18.knownToU133Plus2.name (via kgSpAlias.kgID)
      hg18.knownToU95.name (via kgSpAlias.kgID)
      hg18.knownToVisiGene.name (via kgSpAlias.kgID)
      hg18.mmBlastTab.query (via kgSpAlias.kgID)
      hg18.rnBlastTab.query (via kgSpAlias.kgID)
      hg18.scBlastTab.query (via kgSpAlias.kgID)
      hg18.ucscScop.ucscId (via kgSpAlias.kgID)
      knownGeneV39.bioCycPathway.kgID (via kgSpAlias.kgID)
      knownGeneV39.ceBlastTab.query (via kgSpAlias.kgID)
      knownGeneV39.dmBlastTab.query (via kgSpAlias.kgID)
      knownGeneV39.drBlastTab.query (via kgSpAlias.kgID)
      knownGeneV39.foldUtr3.name (via kgSpAlias.kgID)
      knownGeneV39.foldUtr5.name (via kgSpAlias.kgID)
      knownGeneV39.gnfAtlas2Distance.query (via kgSpAlias.kgID)
      knownGeneV39.gnfAtlas2Distance.target (via kgSpAlias.kgID)
      knownGeneV39.kgAlias.kgID (via kgSpAlias.kgID)
      knownGeneV39.kgColor.kgID (via kgSpAlias.kgID)
      knownGeneV39.kgProtAlias.kgID (via kgSpAlias.kgID)
      knownGeneV39.kgSpAlias.kgID (via kgSpAlias.kgID)
      knownGeneV39.kgTargetAli.qName (via kgSpAlias.kgID)
      knownGeneV39.kgXref.kgID (via kgSpAlias.kgID)
      knownGeneV39.knownAttrs.kgID (via kgSpAlias.kgID)
      knownGeneV39.knownBlastTab.query (via kgSpAlias.kgID)
      knownGeneV39.knownBlastTab.target (via kgSpAlias.kgID)
      knownGeneV39.knownCanonical.protein (via kgSpAlias.kgID)
      knownGeneV39.knownCanonical.transcript (via kgSpAlias.kgID)
      knownGeneV39.knownCds.name (via kgSpAlias.kgID)
      knownGeneV39.knownGene.name (via kgSpAlias.kgID)
      knownGeneV39.knownGeneMrna.name (via kgSpAlias.kgID)
      knownGeneV39.knownGenePep.name (via kgSpAlias.kgID)
      knownGeneV39.knownIsoforms.transcript (via kgSpAlias.kgID)
      knownGeneV39.knownToEnsembl.name (via kgSpAlias.kgID)
      knownGeneV39.knownToGnfAtlas2.name (via kgSpAlias.kgID)
      knownGeneV39.knownToHprd.name (via kgSpAlias.kgID)
      knownGeneV39.knownToLocusLink.name (via kgSpAlias.kgID)
      knownGeneV39.knownToMrna.name (via kgSpAlias.kgID)
      knownGeneV39.knownToMrnaSingle.name (via kgSpAlias.kgID)
      knownGeneV39.knownToMupit.name (via kgSpAlias.kgID)
      knownGeneV39.knownToPfam.name (via kgSpAlias.kgID)
      knownGeneV39.knownToRefSeq.name (via kgSpAlias.kgID)
      knownGeneV39.knownToSuper.gene (via kgSpAlias.kgID)
      knownGeneV39.knownToTag.name (via kgSpAlias.kgID)
      knownGeneV39.knownToU133.name (via kgSpAlias.kgID)
      knownGeneV39.knownToU95.name (via kgSpAlias.kgID)
      knownGeneV39.knownToVisiGene.name (via kgSpAlias.kgID)
      knownGeneV39.knownToWikipedia.name (via kgSpAlias.kgID)
      knownGeneV39.mmBlastTab.query (via kgSpAlias.kgID)
      knownGeneV39.rnBlastTab.query (via kgSpAlias.kgID)
      knownGeneV39.scBlastTab.query (via kgSpAlias.kgID)
      knownGeneV39.ucscScop.ucscId (via kgSpAlias.kgID)
      go.goaPart.dbObjectId (via kgSpAlias.spID)
      hg18.kgXref.spID (via kgSpAlias.spID)
      knownGeneV39.kgProtAlias.alias (via kgSpAlias.spID)
      knownGeneV39.kgSpAlias.spID (via kgSpAlias.spID)
      knownGeneV39.kgXref.spID (via kgSpAlias.spID)
      proteome.spOldNew.acc (via kgSpAlias.spID)
      proteome.spReactomeEvent.spID (via kgSpAlias.spID)
      proteome.spReactomeId.spID (via kgSpAlias.spID)
      uniProt.accToKeyword.acc (via kgSpAlias.spID)
      uniProt.accToTaxon.acc (via kgSpAlias.spID)
      uniProt.citation.acc (via kgSpAlias.spID)
      uniProt.comment.acc (via kgSpAlias.spID)
      uniProt.description.acc (via kgSpAlias.spID)
      uniProt.displayId.acc (via kgSpAlias.spID)
      uniProt.extDbRef.acc (via kgSpAlias.spID)
      uniProt.feature.acc (via kgSpAlias.spID)
      uniProt.gene.acc (via kgSpAlias.spID)
      uniProt.geneLogic.acc (via kgSpAlias.spID)
      uniProt.info.acc (via kgSpAlias.spID)
      uniProt.otherAcc.acc (via kgSpAlias.spID)
      uniProt.protein.acc (via kgSpAlias.spID)
      visiGene.gene.uniProt (via kgSpAlias.spID)

Sample Rows
 
kgIDspIDalias
uc001aaa.2BC032353
uc001aaa.2uc001aaa.1
uc001aaa.2uc001aaa.2
uc001aab.2CR613196
uc001aab.2DKFZp434K1323
uc001aab.2uc001aab.1
uc001aab.2uc001aab.2
uc001aac.2BC063459
uc001aac.2FLJ00038
uc001aac.2uc001aac.1

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