Schema for kgProtAlias
  Database: rn3    Primary Table: kgProtAlias    Row Count: 28,753   Data last updated: 2005-02-11
Format description: Link together a Known Gene ID and a protein alias
On download server: MariaDB table dump directory
fieldexampleSQL type info description
kgID AB000098varchar(40) values Known Gene ID
displayID O54755varchar(40) values protein display ID
alias BAA24351varchar(80) values a protein alias

Connected Tables and Joining Fields
        go.goaPart.dbObjectId (via kgProtAlias.alias)
      hgFixed.refLink.protAcc (via kgProtAlias.alias)
      knownGeneV39.kgProtAlias.alias (via kgProtAlias.alias)
      knownGeneV39.kgSpAlias.alias (via kgProtAlias.alias)
      knownGeneV39.kgSpAlias.spID (via kgProtAlias.alias)
      knownGeneV39.kgXref.protAcc (via kgProtAlias.alias)
      knownGeneV39.kgXref.spID (via kgProtAlias.alias)
      proteome.spOldNew.acc (via kgProtAlias.alias)
      proteome.spReactomeEvent.spID (via kgProtAlias.alias)
      proteome.spReactomeId.spID (via kgProtAlias.alias)
      rn3.kgProtMap.qName (via kgProtAlias.alias)
      rn3.kgSpAlias.alias (via kgProtAlias.alias)
      rn3.kgSpAlias.spID (via kgProtAlias.alias)
      rn3.kgXref.protAcc (via kgProtAlias.alias)
      rn3.kgXref.spID (via kgProtAlias.alias)
      uniProt.accToKeyword.acc (via kgProtAlias.alias)
      uniProt.accToTaxon.acc (via kgProtAlias.alias)
      uniProt.citation.acc (via kgProtAlias.alias)
      uniProt.comment.acc (via kgProtAlias.alias)
      uniProt.description.acc (via kgProtAlias.alias)
      uniProt.displayId.acc (via kgProtAlias.alias)
      uniProt.extDbRef.acc (via kgProtAlias.alias)
      uniProt.feature.acc (via kgProtAlias.alias)
      uniProt.gene.acc (via kgProtAlias.alias)
      uniProt.geneLogic.acc (via kgProtAlias.alias)
      uniProt.info.acc (via kgProtAlias.alias)
      uniProt.otherAcc.acc (via kgProtAlias.alias)
      uniProt.protein.acc (via kgProtAlias.alias)
      visiGene.gene.uniProt (via kgProtAlias.alias)
      go.goaPart.dbObjectSymbol (via kgProtAlias.displayID)
      knownGeneV39.kgProtAlias.displayID (via kgProtAlias.displayID)
      knownGeneV39.kgSpAlias.alias (via kgProtAlias.displayID)
      knownGeneV39.kgXref.spDisplayID (via kgProtAlias.displayID)
      knownGeneV39.knownCanonical.protein (via kgProtAlias.displayID)
      proteome.spOldNew.newDisplayId (via kgProtAlias.displayID)
      proteome.spOldNew.oldDisplayId (via kgProtAlias.displayID)
      rn3.dupSpMrna.dupProteinID (via kgProtAlias.displayID)
      rn3.dupSpMrna.proteinID (via kgProtAlias.displayID)
      rn3.kgSpAlias.alias (via kgProtAlias.displayID)
      rn3.kgXref.spDisplayID (via kgProtAlias.displayID)
      rn3.knownCanonical.protein (via kgProtAlias.displayID)
      rn3.spMrna.spID (via kgProtAlias.displayID)
      uniProt.displayId.val (via kgProtAlias.displayID)
      knownGeneV39.bioCycPathway.kgID (via kgProtAlias.kgID)
      knownGeneV39.ceBlastTab.query (via kgProtAlias.kgID)
      knownGeneV39.dmBlastTab.query (via kgProtAlias.kgID)
      knownGeneV39.drBlastTab.query (via kgProtAlias.kgID)
      knownGeneV39.foldUtr3.name (via kgProtAlias.kgID)
      knownGeneV39.foldUtr5.name (via kgProtAlias.kgID)
      knownGeneV39.gnfAtlas2Distance.query (via kgProtAlias.kgID)
      knownGeneV39.gnfAtlas2Distance.target (via kgProtAlias.kgID)
      knownGeneV39.kgAlias.kgID (via kgProtAlias.kgID)
      knownGeneV39.kgColor.kgID (via kgProtAlias.kgID)
      knownGeneV39.kgProtAlias.kgID (via kgProtAlias.kgID)
      knownGeneV39.kgSpAlias.kgID (via kgProtAlias.kgID)
      knownGeneV39.kgTargetAli.qName (via kgProtAlias.kgID)
      knownGeneV39.kgXref.kgID (via kgProtAlias.kgID)
      knownGeneV39.knownAttrs.kgID (via kgProtAlias.kgID)
      knownGeneV39.knownBlastTab.query (via kgProtAlias.kgID)
      knownGeneV39.knownBlastTab.target (via kgProtAlias.kgID)
      knownGeneV39.knownCanonical.protein (via kgProtAlias.kgID)
      knownGeneV39.knownCanonical.transcript (via kgProtAlias.kgID)
      knownGeneV39.knownCds.name (via kgProtAlias.kgID)
      knownGeneV39.knownGene.name (via kgProtAlias.kgID)
      knownGeneV39.knownGeneMrna.name (via kgProtAlias.kgID)
      knownGeneV39.knownGenePep.name (via kgProtAlias.kgID)
      knownGeneV39.knownIsoforms.transcript (via kgProtAlias.kgID)
      knownGeneV39.knownToEnsembl.name (via kgProtAlias.kgID)
      knownGeneV39.knownToGnfAtlas2.name (via kgProtAlias.kgID)
      knownGeneV39.knownToHprd.name (via kgProtAlias.kgID)
      knownGeneV39.knownToLocusLink.name (via kgProtAlias.kgID)
      knownGeneV39.knownToMrna.name (via kgProtAlias.kgID)
      knownGeneV39.knownToMrnaSingle.name (via kgProtAlias.kgID)
      knownGeneV39.knownToMupit.name (via kgProtAlias.kgID)
      knownGeneV39.knownToPfam.name (via kgProtAlias.kgID)
      knownGeneV39.knownToRefSeq.name (via kgProtAlias.kgID)
      knownGeneV39.knownToSuper.gene (via kgProtAlias.kgID)
      knownGeneV39.knownToTag.name (via kgProtAlias.kgID)
      knownGeneV39.knownToU133.name (via kgProtAlias.kgID)
      knownGeneV39.knownToU95.name (via kgProtAlias.kgID)
      knownGeneV39.knownToVisiGene.name (via kgProtAlias.kgID)
      knownGeneV39.knownToWikipedia.name (via kgProtAlias.kgID)
      knownGeneV39.mmBlastTab.query (via kgProtAlias.kgID)
      knownGeneV39.rnBlastTab.query (via kgProtAlias.kgID)
      knownGeneV39.scBlastTab.query (via kgProtAlias.kgID)
      knownGeneV39.ucscScop.ucscId (via kgProtAlias.kgID)
      rn3.dmBlastTab.query (via kgProtAlias.kgID)
      rn3.drBlastTab.query (via kgProtAlias.kgID)
      rn3.dupSpMrna.mrnaID (via kgProtAlias.kgID)
      rn3.gnfAtlas2Distance.query (via kgProtAlias.kgID)
      rn3.gnfAtlas2Distance.target (via kgProtAlias.kgID)
      rn3.hgBlastTab.query (via kgProtAlias.kgID)
      rn3.keggPathway.kgID (via kgProtAlias.kgID)
      rn3.kgAlias.kgID (via kgProtAlias.kgID)
      rn3.kgSpAlias.kgID (via kgProtAlias.kgID)
      rn3.kgXref.kgID (via kgProtAlias.kgID)
      rn3.knownBlastTab.query (via kgProtAlias.kgID)
      rn3.knownBlastTab.target (via kgProtAlias.kgID)
      rn3.knownCanonical.transcript (via kgProtAlias.kgID)
      rn3.knownGene.name (via kgProtAlias.kgID)
      rn3.knownGeneLink.name (via kgProtAlias.kgID)
      rn3.knownGeneMrna.name (via kgProtAlias.kgID)
      rn3.knownGenePep.name (via kgProtAlias.kgID)
      rn3.knownIsoforms.transcript (via kgProtAlias.kgID)
      rn3.knownToEnsembl.name (via kgProtAlias.kgID)
      rn3.knownToGnfAtlas2.name (via kgProtAlias.kgID)
      rn3.knownToLocusLink.name (via kgProtAlias.kgID)
      rn3.knownToPfam.name (via kgProtAlias.kgID)
      rn3.knownToRefSeq.name (via kgProtAlias.kgID)
      rn3.knownToSuper.gene (via kgProtAlias.kgID)
      rn3.scBlastTab.query (via kgProtAlias.kgID)

Sample Rows
 
kgIDdisplayIDalias
AB000098O54755BAA24351
AB000098O54755NP_072129
AB000098O54755O54755
AB000107P97786BAA19054
AB000107P97786NP_071982
AB000107P97786P97786
AB000113CTR3_RATBAA20133
AB000113CTR3_RATCTR3_RAT
AB000113CTR3_RATNP_058913
AB000113CTR3_RATO08812

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