Schema for kgProtAlias
  Database: mm9    Primary Table: kgProtAlias    Row Count: 232,729   Data last updated: 2011-03-02
Format description: Link together a Known Gene ID and a protein alias
On download server: MariaDB table dump directory
fieldexampleSQL type info description
kgID uc007aeu.1varchar(255) values Known Gene ID
displayID Q5GH67varchar(255) values protein display ID
alias NP_001011874varchar(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)
      mm9.kgSpAlias.alias (via kgProtAlias.alias)
      mm9.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)
      mm9.affyGnfU74ADistance.query (via kgProtAlias.kgID)
      mm9.affyGnfU74ADistance.target (via kgProtAlias.kgID)
      mm9.affyGnfU74BDistance.query (via kgProtAlias.kgID)
      mm9.affyGnfU74BDistance.target (via kgProtAlias.kgID)
      mm9.affyGnfU74CDistance.query (via kgProtAlias.kgID)
      mm9.affyGnfU74CDistance.target (via kgProtAlias.kgID)
      mm9.bioCycPathway.kgID (via kgProtAlias.kgID)
      mm9.ccdsKgMap.geneId (via kgProtAlias.kgID)
      mm9.ceBlastTab.query (via kgProtAlias.kgID)
      mm9.dmBlastTab.query (via kgProtAlias.kgID)
      mm9.drBlastTab.query (via kgProtAlias.kgID)
      mm9.foldUtr3.name (via kgProtAlias.kgID)
      mm9.foldUtr5.name (via kgProtAlias.kgID)
      mm9.gnfAtlas2Distance.query (via kgProtAlias.kgID)
      mm9.gnfAtlas2Distance.target (via kgProtAlias.kgID)
      mm9.hgBlastTab.query (via kgProtAlias.kgID)
      mm9.keggPathway.kgID (via kgProtAlias.kgID)
      mm9.kgAlias.kgID (via kgProtAlias.kgID)
      mm9.kgColor.kgID (via kgProtAlias.kgID)
      mm9.kgProtMap2.qName (via kgProtAlias.kgID)
      mm9.kgSpAlias.kgID (via kgProtAlias.kgID)
      mm9.kgTargetAli.qName (via kgProtAlias.kgID)
      mm9.kgTxInfo.name (via kgProtAlias.kgID)
      mm9.kgXref.kgID (via kgProtAlias.kgID)
      mm9.knownBlastTab.query (via kgProtAlias.kgID)
      mm9.knownBlastTab.target (via kgProtAlias.kgID)
      mm9.knownCanonical.protein (via kgProtAlias.kgID)
      mm9.knownCanonical.transcript (via kgProtAlias.kgID)
      mm9.knownGene.name (via kgProtAlias.kgID)
      mm9.knownGeneMrna.name (via kgProtAlias.kgID)
      mm9.knownGenePep.name (via kgProtAlias.kgID)
      mm9.knownIsoforms.transcript (via kgProtAlias.kgID)
      mm9.knownToAllenBrain.name (via kgProtAlias.kgID)
      mm9.knownToEnsembl.name (via kgProtAlias.kgID)
      mm9.knownToGnfAtlas2.name (via kgProtAlias.kgID)
      mm9.knownToKeggEntrez.name (via kgProtAlias.kgID)
      mm9.knownToLocusLink.name (via kgProtAlias.kgID)
      mm9.knownToPfam.name (via kgProtAlias.kgID)
      mm9.knownToRefSeq.name (via kgProtAlias.kgID)
      mm9.knownToSuper.gene (via kgProtAlias.kgID)
      mm9.knownToVisiGene.name (via kgProtAlias.kgID)
      mm9.rnBlastTab.query (via kgProtAlias.kgID)
      mm9.scBlastTab.query (via kgProtAlias.kgID)
      mm9.ucscScop.ucscId (via kgProtAlias.kgID)

Sample Rows
 
kgIDdisplayIDalias
uc007aeu.1Q5GH67NP_001011874
uc007aeu.1Q5GH67Q5GH67
uc007aeu.1Q5GH67XKR4_MOUSE
uc007aeu.1Q5GH67Xkr4
uc007aeu.1Q5GH67Xrg4
uc007aex.2Q548Q8NP_035413
uc007aex.2Q548Q8Q548Q8
uc007aex.2Q548Q8Q548Q8_MOUSE
uc007aex.2Q548Q8Rp1
uc007aex.2Q548Q8Rp1h

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