Schema for kgSpAlias
  Database: rn3    Primary Table: kgSpAlias    Row Count: 54,456   Data last updated: 2005-02-11
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 AB000098varchar(40) values Known Gene ID
spID O54755varchar(40) values UniProt accession
alias BAA24351varchar(40) values Alias, could be either gene alias or protein alias

Connected Tables and Joining Fields
        go.goaPart.dbObjectSymbol (via kgSpAlias.alias)
      hgFixed.refLink.protAcc (via kgSpAlias.alias)
      knownGeneV39.kgProtAlias.alias (via kgSpAlias.alias)
      knownGeneV39.kgProtAlias.displayID (via kgSpAlias.alias)
      knownGeneV39.kgSpAlias.alias (via kgSpAlias.alias)
      knownGeneV39.kgXref.protAcc (via kgSpAlias.alias)
      knownGeneV39.kgXref.spDisplayID (via kgSpAlias.alias)
      knownGeneV39.knownCanonical.protein (via kgSpAlias.alias)
      proteome.spOldNew.newDisplayId (via kgSpAlias.alias)
      proteome.spOldNew.oldDisplayId (via kgSpAlias.alias)
      rn3.dupSpMrna.dupProteinID (via kgSpAlias.alias)
      rn3.dupSpMrna.proteinID (via kgSpAlias.alias)
      rn3.kgProtAlias.alias (via kgSpAlias.alias)
      rn3.kgProtAlias.displayID (via kgSpAlias.alias)
      rn3.kgXref.protAcc (via kgSpAlias.alias)
      rn3.kgXref.spDisplayID (via kgSpAlias.alias)
      rn3.knownCanonical.protein (via kgSpAlias.alias)
      rn3.spMrna.spID (via kgSpAlias.alias)
      uniProt.displayId.val (via kgSpAlias.alias)
      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)
      rn3.dmBlastTab.query (via kgSpAlias.kgID)
      rn3.drBlastTab.query (via kgSpAlias.kgID)
      rn3.dupSpMrna.mrnaID (via kgSpAlias.kgID)
      rn3.gnfAtlas2Distance.query (via kgSpAlias.kgID)
      rn3.gnfAtlas2Distance.target (via kgSpAlias.kgID)
      rn3.hgBlastTab.query (via kgSpAlias.kgID)
      rn3.keggPathway.kgID (via kgSpAlias.kgID)
      rn3.kgAlias.kgID (via kgSpAlias.kgID)
      rn3.kgProtAlias.kgID (via kgSpAlias.kgID)
      rn3.kgXref.kgID (via kgSpAlias.kgID)
      rn3.knownBlastTab.query (via kgSpAlias.kgID)
      rn3.knownBlastTab.target (via kgSpAlias.kgID)
      rn3.knownCanonical.transcript (via kgSpAlias.kgID)
      rn3.knownGene.name (via kgSpAlias.kgID)
      rn3.knownGeneLink.name (via kgSpAlias.kgID)
      rn3.knownGeneMrna.name (via kgSpAlias.kgID)
      rn3.knownGenePep.name (via kgSpAlias.kgID)
      rn3.knownIsoforms.transcript (via kgSpAlias.kgID)
      rn3.knownToEnsembl.name (via kgSpAlias.kgID)
      rn3.knownToGnfAtlas2.name (via kgSpAlias.kgID)
      rn3.knownToLocusLink.name (via kgSpAlias.kgID)
      rn3.knownToPfam.name (via kgSpAlias.kgID)
      rn3.knownToRefSeq.name (via kgSpAlias.kgID)
      rn3.knownToSuper.gene (via kgSpAlias.kgID)
      rn3.scBlastTab.query (via kgSpAlias.kgID)
      go.goaPart.dbObjectId (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)
      rn3.kgProtAlias.alias (via kgSpAlias.spID)
      rn3.kgProtMap.qName (via kgSpAlias.spID)
      rn3.kgXref.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
AB000098O54755BAA24351
AB000098O54755Mipp65
AB000098O54755NM_022607
AB000098O54755NP_072129
AB000098O54755O54755
AB000107P97786BAA19054
AB000107P97786NM_022537
AB000107P97786NP_071982
AB000107P97786P97786
AB000107P97786Prlpd

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