Schema for kgProtAlias
  Database: mm10    Primary Table: kgProtAlias    Row Count: 270,666   Data last updated: 2019-09-20
Format description: Link together a Known Gene ID and a protein alias
On download server: MariaDB table dump directory
fieldexampleSQL type info description
kgID ENSMUST00000000001.4varchar(255) values Known Gene ID
displayID Q9DC51varchar(255) values protein display ID
alias A2AE36varchar(255) values a protein alias

Connected Tables and Joining Fields
        hgFixed.refLink.protAcc (via kgProtAlias.alias)
      knownGeneV39.kgProtAlias.alias (via kgProtAlias.alias)
      knownGeneV39.kgSpAlias.alias (via kgProtAlias.alias)
      knownGeneV39.kgXref.protAcc (via kgProtAlias.alias)
      mm10.kgSpAlias.alias (via kgProtAlias.alias)
      mm10.kgXref.protAcc (via kgProtAlias.alias)
      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)
      mm10.bioCycPathway.kgID (via kgProtAlias.kgID)
      mm10.ccdsKgMap.geneId (via kgProtAlias.kgID)
      mm10.ceBlastTab.query (via kgProtAlias.kgID)
      mm10.dmBlastTab.query (via kgProtAlias.kgID)
      mm10.drBlastTab.query (via kgProtAlias.kgID)
      mm10.foldUtr3.name (via kgProtAlias.kgID)
      mm10.foldUtr5.name (via kgProtAlias.kgID)
      mm10.hgBlastTab.query (via kgProtAlias.kgID)
      mm10.keggPathway.kgID (via kgProtAlias.kgID)
      mm10.kgAlias.kgID (via kgProtAlias.kgID)
      mm10.kgColor.kgID (via kgProtAlias.kgID)
      mm10.kgProtMap2.qName (via kgProtAlias.kgID)
      mm10.kgSpAlias.kgID (via kgProtAlias.kgID)
      mm10.kgTargetAli.qName (via kgProtAlias.kgID)
      mm10.kgTxInfo.name (via kgProtAlias.kgID)
      mm10.kgXref.kgID (via kgProtAlias.kgID)
      mm10.knownAttrs.kgID (via kgProtAlias.kgID)
      mm10.knownBlastTab.query (via kgProtAlias.kgID)
      mm10.knownBlastTab.target (via kgProtAlias.kgID)
      mm10.knownCanonical.transcript (via kgProtAlias.kgID)
      mm10.knownCds.name (via kgProtAlias.kgID)
      mm10.knownGene.name (via kgProtAlias.kgID)
      mm10.knownGeneMrna.name (via kgProtAlias.kgID)
      mm10.knownGenePep.name (via kgProtAlias.kgID)
      mm10.knownIsoforms.transcript (via kgProtAlias.kgID)
      mm10.knownToEnsembl.name (via kgProtAlias.kgID)
      mm10.knownToKeggEntrez.name (via kgProtAlias.kgID)
      mm10.knownToLocusLink.name (via kgProtAlias.kgID)
      mm10.knownToLynx.name (via kgProtAlias.kgID)
      mm10.knownToMrna.name (via kgProtAlias.kgID)
      mm10.knownToMrnaSingle.name (via kgProtAlias.kgID)
      mm10.knownToPfam.name (via kgProtAlias.kgID)
      mm10.knownToRefSeq.name (via kgProtAlias.kgID)
      mm10.knownToSuper.gene (via kgProtAlias.kgID)
      mm10.knownToTag.name (via kgProtAlias.kgID)
      mm10.knownToVisiGene.name (via kgProtAlias.kgID)
      mm10.knownToWikipedia.name (via kgProtAlias.kgID)
      mm10.rnBlastTab.query (via kgProtAlias.kgID)
      mm10.scBlastTab.query (via kgProtAlias.kgID)
      mm10.ucscScop.ucscId (via kgProtAlias.kgID)

Sample Rows
 
kgIDdisplayIDalias
ENSMUST00000000001.4Q9DC51A2AE36
ENSMUST00000000001.4Q9DC51GNAI3_MOUSE
ENSMUST00000000001.4Q9DC51Gnai3
ENSMUST00000000001.4Q9DC51NM_010306
ENSMUST00000000001.4Q9DC51Q3TGV1
ENSMUST00000000001.4Q9DC51Q61019
ENSMUST00000000001.4Q9DC51Q9DC51
ENSMUST00000000003.13Q3UV89NM_017471
ENSMUST00000000003.13Q3UV89Pbsn
ENSMUST00000000003.13Q3UV89Q3UV89

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