Schema for kgXref
  Database: mm8    Primary Table: kgXref    Row Count: 31,381   Data last updated: 2006-03-04
Format description: Link together a Known Gene ID and a gene alias
On download server: MariaDB table dump directory
fieldexampleSQL type info description
kgID AB001539varchar(40) values Known Gene ID
mRNA AB001539varchar(40) values mRNA ID
spID Q810D6varchar(40) values UniProt protein Accession number
spDisplayID GRWD1_MOUSEvarchar(40) values UniProt display ID
geneSymbol Grwd1varchar(40) values Gene Symbol
refseq NM_153419varchar(40) values RefSeq ID
protAcc  varchar(40) values NCBI protein Accession number
description Glutamate-rich WD repeat-co...varchar(255) values Description

Connected Tables and Joining Fields
        knownGeneV39.bioCycPathway.kgID (via kgXref.kgID)
      knownGeneV39.ceBlastTab.query (via kgXref.kgID)
      knownGeneV39.dmBlastTab.query (via kgXref.kgID)
      knownGeneV39.drBlastTab.query (via kgXref.kgID)
      knownGeneV39.foldUtr3.name (via kgXref.kgID)
      knownGeneV39.foldUtr5.name (via kgXref.kgID)
      knownGeneV39.gnfAtlas2Distance.query (via kgXref.kgID)
      knownGeneV39.gnfAtlas2Distance.target (via kgXref.kgID)
      knownGeneV39.kgAlias.kgID (via kgXref.kgID)
      knownGeneV39.kgColor.kgID (via kgXref.kgID)
      knownGeneV39.kgProtAlias.kgID (via kgXref.kgID)
      knownGeneV39.kgSpAlias.kgID (via kgXref.kgID)
      knownGeneV39.kgTargetAli.qName (via kgXref.kgID)
      knownGeneV39.kgXref.kgID (via kgXref.kgID)
      knownGeneV39.knownAttrs.kgID (via kgXref.kgID)
      knownGeneV39.knownBlastTab.query (via kgXref.kgID)
      knownGeneV39.knownBlastTab.target (via kgXref.kgID)
      knownGeneV39.knownCanonical.protein (via kgXref.kgID)
      knownGeneV39.knownCanonical.transcript (via kgXref.kgID)
      knownGeneV39.knownCds.name (via kgXref.kgID)
      knownGeneV39.knownGene.name (via kgXref.kgID)
      knownGeneV39.knownGeneMrna.name (via kgXref.kgID)
      knownGeneV39.knownGenePep.name (via kgXref.kgID)
      knownGeneV39.knownIsoforms.transcript (via kgXref.kgID)
      knownGeneV39.knownToEnsembl.name (via kgXref.kgID)
      knownGeneV39.knownToGnfAtlas2.name (via kgXref.kgID)
      knownGeneV39.knownToHprd.name (via kgXref.kgID)
      knownGeneV39.knownToLocusLink.name (via kgXref.kgID)
      knownGeneV39.knownToMrna.name (via kgXref.kgID)
      knownGeneV39.knownToMrnaSingle.name (via kgXref.kgID)
      knownGeneV39.knownToMupit.name (via kgXref.kgID)
      knownGeneV39.knownToPfam.name (via kgXref.kgID)
      knownGeneV39.knownToRefSeq.name (via kgXref.kgID)
      knownGeneV39.knownToSuper.gene (via kgXref.kgID)
      knownGeneV39.knownToTag.name (via kgXref.kgID)
      knownGeneV39.knownToU133.name (via kgXref.kgID)
      knownGeneV39.knownToU95.name (via kgXref.kgID)
      knownGeneV39.knownToVisiGene.name (via kgXref.kgID)
      knownGeneV39.knownToWikipedia.name (via kgXref.kgID)
      knownGeneV39.mmBlastTab.query (via kgXref.kgID)
      knownGeneV39.rnBlastTab.query (via kgXref.kgID)
      knownGeneV39.scBlastTab.query (via kgXref.kgID)
      knownGeneV39.ucscScop.ucscId (via kgXref.kgID)
      mm8.affyGnfU74ADistance.query (via kgXref.kgID)
      mm8.affyGnfU74ADistance.target (via kgXref.kgID)
      mm8.affyGnfU74BDistance.query (via kgXref.kgID)
      mm8.affyGnfU74BDistance.target (via kgXref.kgID)
      mm8.affyGnfU74CDistance.query (via kgXref.kgID)
      mm8.affyGnfU74CDistance.target (via kgXref.kgID)
      mm8.ccdsKgMap.geneId (via kgXref.kgID)
      mm8.ceBlastTab.query (via kgXref.kgID)
      mm8.dmBlastTab.query (via kgXref.kgID)
      mm8.drBlastTab.query (via kgXref.kgID)
      mm8.dupSpMrna.mrnaID (via kgXref.kgID)
      mm8.foldUtr3.name (via kgXref.kgID)
      mm8.foldUtr5.name (via kgXref.kgID)
      mm8.gnfAtlas2Distance.query (via kgXref.kgID)
      mm8.gnfAtlas2Distance.target (via kgXref.kgID)
      mm8.hgBlastTab.query (via kgXref.kgID)
      mm8.keggPathway.kgID (via kgXref.kgID)
      mm8.kgAlias.kgID (via kgXref.kgID)
      mm8.kgProtAlias.kgID (via kgXref.kgID)
      mm8.kgSpAlias.kgID (via kgXref.kgID)
      mm8.kgTargetAli.qName (via kgXref.kgID)
      mm8.knownBlastTab.query (via kgXref.kgID)
      mm8.knownBlastTab.target (via kgXref.kgID)
      mm8.knownCanonical.transcript (via kgXref.kgID)
      mm8.knownGene.name (via kgXref.kgID)
      mm8.knownGeneMrna.name (via kgXref.kgID)
      mm8.knownGenePep.name (via kgXref.kgID)
      mm8.knownIsoforms.transcript (via kgXref.kgID)
      mm8.knownToAllenBrain.name (via kgXref.kgID)
      mm8.knownToEnsembl.name (via kgXref.kgID)
      mm8.knownToGnfAtlas2.name (via kgXref.kgID)
      mm8.knownToKeggEntrez.name (via kgXref.kgID)
      mm8.knownToLocusLink.name (via kgXref.kgID)
      mm8.knownToPfam.name (via kgXref.kgID)
      mm8.knownToRefSeq.name (via kgXref.kgID)
      mm8.knownToSuper.gene (via kgXref.kgID)
      mm8.knownToVisiGene.name (via kgXref.kgID)
      mm8.rnBlastTab.query (via kgXref.kgID)
      mm8.scBlastTab.query (via kgXref.kgID)
      hgFixed.refLink.protAcc (via kgXref.protAcc)
      knownGeneV39.kgProtAlias.alias (via kgXref.protAcc)
      knownGeneV39.kgSpAlias.alias (via kgXref.protAcc)
      knownGeneV39.kgXref.protAcc (via kgXref.protAcc)
      mm8.kgProtAlias.alias (via kgXref.protAcc)
      mm8.kgSpAlias.alias (via kgXref.protAcc)
      hgFixed.gbCdnaInfo.acc (via kgXref.refseq)
      hgFixed.gbSeq.acc (via kgXref.refseq)
      hgFixed.imageClone.acc (via kgXref.refseq)
      hgFixed.refLink.mrnaAcc (via kgXref.refseq)
      hgFixed.refSeqStatus.mrnaAcc (via kgXref.refseq)
      hgFixed.refSeqSummary.mrnaAcc (via kgXref.refseq)
      knownGeneV39.kgXref.refseq (via kgXref.refseq)
      knownGeneV39.knownToRefSeq.value (via kgXref.refseq)
      mm8.ccdsInfo.mrnaAcc (via kgXref.refseq)
      mm8.dupSpMrna.dupMrnaID (via kgXref.refseq)
      mm8.dupSpMrna.mrnaID (via kgXref.refseq)
      mm8.knownToRefSeq.value (via kgXref.refseq)
      mm8.mrnaOrientInfo.name (via kgXref.refseq)
      mm8.mrnaRefseq.mrna (via kgXref.refseq)
      mm8.mrnaRefseq.refseq (via kgXref.refseq)
      mm8.refFlat.name (via kgXref.refseq)
      mm8.refGene.name (via kgXref.refseq)
      mm8.refSeqAli.qName (via kgXref.refseq)
      go.goaPart.dbObjectSymbol (via kgXref.spDisplayID)
      knownGeneV39.kgProtAlias.displayID (via kgXref.spDisplayID)
      knownGeneV39.kgSpAlias.alias (via kgXref.spDisplayID)
      knownGeneV39.kgXref.spDisplayID (via kgXref.spDisplayID)
      knownGeneV39.knownCanonical.protein (via kgXref.spDisplayID)
      mm8.dupSpMrna.dupProteinID (via kgXref.spDisplayID)
      mm8.dupSpMrna.proteinID (via kgXref.spDisplayID)
      mm8.kgProtAlias.displayID (via kgXref.spDisplayID)
      mm8.kgSpAlias.alias (via kgXref.spDisplayID)
      mm8.knownCanonical.protein (via kgXref.spDisplayID)
      mm8.spMrna.spID (via kgXref.spDisplayID)
      proteome.spOldNew.newDisplayId (via kgXref.spDisplayID)
      proteome.spOldNew.oldDisplayId (via kgXref.spDisplayID)
      uniProt.displayId.val (via kgXref.spDisplayID)
      go.goaPart.dbObjectId (via kgXref.spID)
      knownGeneV39.kgProtAlias.alias (via kgXref.spID)
      knownGeneV39.kgSpAlias.spID (via kgXref.spID)
      knownGeneV39.kgXref.spID (via kgXref.spID)
      mm8.kgProtAlias.alias (via kgXref.spID)
      mm8.kgProtMap.qName (via kgXref.spID)
      mm8.kgSpAlias.spID (via kgXref.spID)
      proteome.spOldNew.acc (via kgXref.spID)
      proteome.spReactomeEvent.spID (via kgXref.spID)
      proteome.spReactomeId.spID (via kgXref.spID)
      uniProt.accToKeyword.acc (via kgXref.spID)
      uniProt.accToTaxon.acc (via kgXref.spID)
      uniProt.citation.acc (via kgXref.spID)
      uniProt.comment.acc (via kgXref.spID)
      uniProt.description.acc (via kgXref.spID)
      uniProt.displayId.acc (via kgXref.spID)
      uniProt.extDbRef.acc (via kgXref.spID)
      uniProt.feature.acc (via kgXref.spID)
      uniProt.gene.acc (via kgXref.spID)
      uniProt.geneLogic.acc (via kgXref.spID)
      uniProt.info.acc (via kgXref.spID)
      uniProt.otherAcc.acc (via kgXref.spID)
      uniProt.protein.acc (via kgXref.spID)
      visiGene.gene.uniProt (via kgXref.spID)

Sample Rows
 
kgIDmRNAspIDspDisplayIDgeneSymbolrefseqprotAccdescription
AB001539AB001539Q810D6GRWD1_MOUSEGrwd1NM_153419Glutamate-rich WD repeat-containing protein 1 (Protein A301).
AB001750AB001750O35551RABE1_MOUSERabep1NM_019400Rab GTPase binding effector protein 1 (Rabaptin-5) (Rabaptin-5alpha).
AB001926AB001926Q3TTD4Q3TTD4_MOUSEHspa4lNM_011020Adult male testis cDNA, RIKEN full-length enriched library, clone:4930577E13 product:osmotic stress protein, full insert sequenc ...
AB003147AB003147O54770O54770_MOUSEBfsp1NM_009751Lens fiber cell beaded-filament structure protein.
AB003503AB003503O88180O88180_MOUSEGspt2NM_008179Guanine Nucleotide Regulatory Protein.
AB004048AB004048Q61979NNAT_MOUSENnatNM_010923Neuronatin.
AB005654AB005654O54780O54780_MOUSEMap2k7NM_011944Mitogen-activated protein kinase kinase 7.
AB005654AB005654Q9R1Z3Q9R1Z3_MOUSEMap2k7NM_011944MAP kinase kinase 7 alpha 2.
AB005662AB005662Q3UYC3Q3UYC3_MOUSEMapk8ip3NM_013931Adult male medulla oblongata cDNA, RIKEN full-length enriched library, clone:6330565K05 product:mitogen-activated protein kinase ...
AB005909AB005909Q9JHU8Q9JHU8_MOUSEDmbt1NM_007769Muclin (Fragment).

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