Schema for dupSpMrna
  Database: mm7    Primary Table: dupSpMrna    Row Count: 228,615   Data last updated: 2005-11-18
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 Q8K335_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)
      mm7.affyGnfU74ADistance.query (via dupSpMrna.mrnaID)
      mm7.affyGnfU74ADistance.target (via dupSpMrna.mrnaID)
      mm7.affyGnfU74BDistance.query (via dupSpMrna.mrnaID)
      mm7.affyGnfU74BDistance.target (via dupSpMrna.mrnaID)
      mm7.affyGnfU74CDistance.query (via dupSpMrna.mrnaID)
      mm7.affyGnfU74CDistance.target (via dupSpMrna.mrnaID)
      mm7.all_mrna.qName (via dupSpMrna.mrnaID)
      mm7.dmBlastTab.query (via dupSpMrna.mrnaID)
      mm7.drBlastTab.query (via dupSpMrna.mrnaID)
      mm7.foldUtr3.name (via dupSpMrna.mrnaID)
      mm7.foldUtr5.name (via dupSpMrna.mrnaID)
      mm7.gnfAtlas2Distance.query (via dupSpMrna.mrnaID)
      mm7.gnfAtlas2Distance.target (via dupSpMrna.mrnaID)
      mm7.hgBlastTab.query (via dupSpMrna.mrnaID)
      mm7.keggPathway.kgID (via dupSpMrna.mrnaID)
      mm7.kgAlias.kgID (via dupSpMrna.mrnaID)
      mm7.kgProtAlias.kgID (via dupSpMrna.mrnaID)
      mm7.kgSpAlias.kgID (via dupSpMrna.mrnaID)
      mm7.kgXref.kgID (via dupSpMrna.mrnaID)
      mm7.kgXref.refseq (via dupSpMrna.mrnaID)
      mm7.knownBlastTab.query (via dupSpMrna.mrnaID)
      mm7.knownBlastTab.target (via dupSpMrna.mrnaID)
      mm7.knownCanonical.transcript (via dupSpMrna.mrnaID)
      mm7.knownGene.name (via dupSpMrna.mrnaID)
      mm7.knownGeneLink.name (via dupSpMrna.mrnaID)
      mm7.knownGeneMrna.name (via dupSpMrna.mrnaID)
      mm7.knownGenePep.name (via dupSpMrna.mrnaID)
      mm7.knownIsoforms.transcript (via dupSpMrna.mrnaID)
      mm7.knownToAllenBrain.name (via dupSpMrna.mrnaID)
      mm7.knownToEnsembl.name (via dupSpMrna.mrnaID)
      mm7.knownToGnfAtlas2.name (via dupSpMrna.mrnaID)
      mm7.knownToKeggEntrez.name (via dupSpMrna.mrnaID)
      mm7.knownToLocusLink.name (via dupSpMrna.mrnaID)
      mm7.knownToPfam.name (via dupSpMrna.mrnaID)
      mm7.knownToRefSeq.name (via dupSpMrna.mrnaID)
      mm7.knownToRefSeq.value (via dupSpMrna.mrnaID)
      mm7.knownToVisiGene.name (via dupSpMrna.mrnaID)
      mm7.mgcFullMrna.qName (via dupSpMrna.mrnaID)
      mm7.mgcGenes.name (via dupSpMrna.mrnaID)
      mm7.mrnaOrientInfo.name (via dupSpMrna.mrnaID)
      mm7.mrnaRefseq.mrna (via dupSpMrna.mrnaID)
      mm7.mrnaRefseq.refseq (via dupSpMrna.mrnaID)
      mm7.refFlat.name (via dupSpMrna.mrnaID)
      mm7.refGene.name (via dupSpMrna.mrnaID)
      mm7.refSeqAli.qName (via dupSpMrna.mrnaID)
      mm7.rnBlastTab.query (via dupSpMrna.mrnaID)
      mm7.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)
      mm7.kgProtAlias.displayID (via dupSpMrna.proteinID)
      mm7.kgSpAlias.alias (via dupSpMrna.proteinID)
      mm7.kgXref.spDisplayID (via dupSpMrna.proteinID)
      mm7.knownCanonical.protein (via dupSpMrna.proteinID)
      mm7.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
AB001539Q8K335_MOUSEAB001539Q810D6
AB001539Q8K335_MOUSEAB001539Q8K335
AB001539Q8K335_MOUSEAB001539Q922H3
AB001926P48722-2AB001926Q3TTD4
AB003147O54770_MOUSEAB003147O35656
AB003147O54770_MOUSEAB003147O54770
AB003503O88180_MOUSEAB003503O88180
AB004048O35081_MOUSEAB004048O35081
AB004048O35081_MOUSEAK077465O35081
AB005654Q9QWG6_MOUSEAB005654O35720

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