Schema for dupSpMrna
  Database: mm8    Primary Table: dupSpMrna    Row Count: 252,597   Data last updated: 2006-02-27
Format description: Duplicated mRNA/protein IDs corresponding to a Known Genen mRNA
On download server: MariaDB table dump directory
fieldexampleSQL type info description
mrnaID AB001539varchar(20) values Known Gene (mRNA) ID
proteinID GRWD1_MOUSEvarchar(20) values protein ID for this Known Gene
dupMrnaID AB001539varchar(20) values mrnaID for the duplicate
dupProteinID Q810D6varchar(20) values protein ID for this duplicate

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

Sample Rows
 
mrnaIDproteinIDdupMrnaIDdupProteinID
AB001539GRWD1_MOUSEAB001539Q810D6
AB001539GRWD1_MOUSEAB001539Q8K335
AB001539GRWD1_MOUSEAK077611Q810D6
AB001750RABE1_MOUSEAB001750O35551
AB001750RABE1_MOUSEAB001750O35551-2
AB001750RABE1_MOUSEAB001750O35551-3
AB001750RABE1_MOUSEAB001750O35551-4
AB001750RABE1_MOUSEAB001750O35551-5
AB001750RABE1_MOUSEAB001750Q5QNU3
AB001750RABE1_MOUSEAB001750Q5QNU4

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