Schema for kgSpAlias
  Database: mm9    Primary Table: kgSpAlias    Row Count: 367,173   Data last updated: 2011-03-03
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 uc007aet.1varchar(40) values Known Gene ID
spID  varchar(40) values UniProt accession
alias AK135172varchar(40) values Alias, could be either gene alias or protein alias

Connected Tables and Joining Fields
        hgFixed.refLink.protAcc (via kgSpAlias.alias)
      knownGeneV39.kgProtAlias.alias (via kgSpAlias.alias)
      knownGeneV39.kgSpAlias.alias (via kgSpAlias.alias)
      knownGeneV39.kgXref.protAcc (via kgSpAlias.alias)
      mm9.kgProtAlias.alias (via kgSpAlias.alias)
      mm9.kgXref.protAcc (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)
      mm9.affyGnfU74ADistance.query (via kgSpAlias.kgID)
      mm9.affyGnfU74ADistance.target (via kgSpAlias.kgID)
      mm9.affyGnfU74BDistance.query (via kgSpAlias.kgID)
      mm9.affyGnfU74BDistance.target (via kgSpAlias.kgID)
      mm9.affyGnfU74CDistance.query (via kgSpAlias.kgID)
      mm9.affyGnfU74CDistance.target (via kgSpAlias.kgID)
      mm9.bioCycPathway.kgID (via kgSpAlias.kgID)
      mm9.ccdsKgMap.geneId (via kgSpAlias.kgID)
      mm9.ceBlastTab.query (via kgSpAlias.kgID)
      mm9.dmBlastTab.query (via kgSpAlias.kgID)
      mm9.drBlastTab.query (via kgSpAlias.kgID)
      mm9.foldUtr3.name (via kgSpAlias.kgID)
      mm9.foldUtr5.name (via kgSpAlias.kgID)
      mm9.gnfAtlas2Distance.query (via kgSpAlias.kgID)
      mm9.gnfAtlas2Distance.target (via kgSpAlias.kgID)
      mm9.hgBlastTab.query (via kgSpAlias.kgID)
      mm9.keggPathway.kgID (via kgSpAlias.kgID)
      mm9.kgAlias.kgID (via kgSpAlias.kgID)
      mm9.kgColor.kgID (via kgSpAlias.kgID)
      mm9.kgProtAlias.kgID (via kgSpAlias.kgID)
      mm9.kgProtMap2.qName (via kgSpAlias.kgID)
      mm9.kgTargetAli.qName (via kgSpAlias.kgID)
      mm9.kgTxInfo.name (via kgSpAlias.kgID)
      mm9.kgXref.kgID (via kgSpAlias.kgID)
      mm9.knownBlastTab.query (via kgSpAlias.kgID)
      mm9.knownBlastTab.target (via kgSpAlias.kgID)
      mm9.knownCanonical.protein (via kgSpAlias.kgID)
      mm9.knownCanonical.transcript (via kgSpAlias.kgID)
      mm9.knownGene.name (via kgSpAlias.kgID)
      mm9.knownGeneMrna.name (via kgSpAlias.kgID)
      mm9.knownGenePep.name (via kgSpAlias.kgID)
      mm9.knownIsoforms.transcript (via kgSpAlias.kgID)
      mm9.knownToAllenBrain.name (via kgSpAlias.kgID)
      mm9.knownToEnsembl.name (via kgSpAlias.kgID)
      mm9.knownToGnfAtlas2.name (via kgSpAlias.kgID)
      mm9.knownToKeggEntrez.name (via kgSpAlias.kgID)
      mm9.knownToLocusLink.name (via kgSpAlias.kgID)
      mm9.knownToPfam.name (via kgSpAlias.kgID)
      mm9.knownToRefSeq.name (via kgSpAlias.kgID)
      mm9.knownToSuper.gene (via kgSpAlias.kgID)
      mm9.knownToVisiGene.name (via kgSpAlias.kgID)
      mm9.rnBlastTab.query (via kgSpAlias.kgID)
      mm9.scBlastTab.query (via kgSpAlias.kgID)
      mm9.ucscScop.ucscId (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)
      mm9.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
uc007aet.1AK135172
uc007aet.1mKIAA1889
uc007aet.1uc007aet.1
uc007aeu.1Q5GH67NM_001011874
uc007aeu.1Q5GH67NP_001011874
uc007aeu.1Q5GH67Q5GH67
uc007aeu.1Q5GH67XKR4_MOUSE
uc007aeu.1Q5GH67Xkr4
uc007aeu.1Q5GH67Xrg4
uc007aeu.1Q5GH67uc007aeu.1

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