Schema for kgSpAlias
  Database: hg19    Primary Table: kgSpAlias    Row Count: 612,731   Data last updated: 2013-06-15
Format description: Associates Known Gene ID with UniProt accession and gene or protein alias
On download server: MariaDB table dump directory
fieldexampleSQL type description
kgID uc001aaa.3varchar(40) Known Gene ID
spID  varchar(40) UniProt accession
alias DDX11L1varchar(40) Alias, could be either gene alias or protein alias

Connected Tables and Joining Fields
        hg19.kgAlias.alias (via kgSpAlias.alias)
      hg19.kgProtAlias.alias (via kgSpAlias.alias)
      hg19.kgXref.geneSymbol (via kgSpAlias.alias)
      hg19.kgXref.protAcc (via kgSpAlias.alias)
      hg19.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)
      hg19.bioCycPathway.kgID (via kgSpAlias.kgID)
      hg19.ccdsKgMap.geneId (via kgSpAlias.kgID)
      hg19.ceBlastTab.query (via kgSpAlias.kgID)
      hg19.dmBlastTab.query (via kgSpAlias.kgID)
      hg19.drBlastTab.query (via kgSpAlias.kgID)
      hg19.foldUtr3.name (via kgSpAlias.kgID)
      hg19.foldUtr5.name (via kgSpAlias.kgID)
      hg19.gnfAtlas2Distance.query (via kgSpAlias.kgID)
      hg19.gnfAtlas2Distance.target (via kgSpAlias.kgID)
      hg19.gnfU95Distance.query (via kgSpAlias.kgID)
      hg19.gnfU95Distance.target (via kgSpAlias.kgID)
      hg19.humanHprdP2P.query (via kgSpAlias.kgID)
      hg19.humanHprdP2P.target (via kgSpAlias.kgID)
      hg19.humanVidalP2P.query (via kgSpAlias.kgID)
      hg19.humanVidalP2P.target (via kgSpAlias.kgID)
      hg19.humanWankerP2P.query (via kgSpAlias.kgID)
      hg19.humanWankerP2P.target (via kgSpAlias.kgID)
      hg19.keggPathway.kgID (via kgSpAlias.kgID)
      hg19.kgAlias.kgID (via kgSpAlias.kgID)
      hg19.kgColor.kgID (via kgSpAlias.kgID)
      hg19.kgProtAlias.kgID (via kgSpAlias.kgID)
      hg19.kgProtMap2.qName (via kgSpAlias.kgID)
      hg19.kgTargetAli.qName (via kgSpAlias.kgID)
      hg19.kgTxInfo.name (via kgSpAlias.kgID)
      hg19.kgXref.kgID (via kgSpAlias.kgID)
      hg19.knownBlastTab.query (via kgSpAlias.kgID)
      hg19.knownBlastTab.target (via kgSpAlias.kgID)
      hg19.knownCanonical.transcript (via kgSpAlias.kgID)
      hg19.knownGene.name (via kgSpAlias.kgID)
      hg19.knownGeneMrna.name (via kgSpAlias.kgID)
      hg19.knownGenePep.name (via kgSpAlias.kgID)
      hg19.knownGeneTxMrna.name (via kgSpAlias.kgID)
      hg19.knownGeneTxPep.name (via kgSpAlias.kgID)
      hg19.knownIsoforms.transcript (via kgSpAlias.kgID)
      hg19.knownToAllenBrain.name (via kgSpAlias.kgID)
      hg19.knownToEnsembl.name (via kgSpAlias.kgID)
      hg19.knownToGnfAtlas2.name (via kgSpAlias.kgID)
      hg19.knownToHInv.name (via kgSpAlias.kgID)
      hg19.knownToHprd.name (via kgSpAlias.kgID)
      hg19.knownToKeggEntrez.name (via kgSpAlias.kgID)
      hg19.knownToLocusLink.name (via kgSpAlias.kgID)
      hg19.knownToLynx.name (via kgSpAlias.kgID)
      hg19.knownToMupit.name (via kgSpAlias.kgID)
      hg19.knownToNextProt.name (via kgSpAlias.kgID)
      hg19.knownToPfam.name (via kgSpAlias.kgID)
      hg19.knownToRefSeq.name (via kgSpAlias.kgID)
      hg19.knownToSuper.gene (via kgSpAlias.kgID)
      hg19.knownToTreefam.name (via kgSpAlias.kgID)
      hg19.knownToU133.name (via kgSpAlias.kgID)
      hg19.knownToU133Plus2.name (via kgSpAlias.kgID)
      hg19.knownToU95.name (via kgSpAlias.kgID)
      hg19.knownToVisiGene.name (via kgSpAlias.kgID)
      hg19.knownToWikipedia.name (via kgSpAlias.kgID)
      hg19.mmBlastTab.query (via kgSpAlias.kgID)
      hg19.rnBlastTab.query (via kgSpAlias.kgID)
      hg19.scBlastTab.query (via kgSpAlias.kgID)
      hg19.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)
      hg19.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.3DDX11L1
uc001aaa.3NR_046018
uc001aaa.3uc001aaa.3
uc001aac.4BC063459
uc001aac.4WASH7P
uc001aac.4uc001aac.4
uc001aae.4BC053987
uc001aae.4WASH7P
uc001aae.4uc001aae.4
uc001aah.4NR_024540

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