Schema for dupSpMrna
  Database: hg17    Primary Table: dupSpMrna    Row Count: 253,581   Data last updated: 2005-06-08
Format description: Duplicated mRNA/protein IDs corresponding to a Known Genen mRNA
On download server: MariaDB table dump directory
fieldexampleSQL type info description
mrnaID AB000409varchar(20) values Known Gene (mRNA) ID
proteinID Q9BUB5-2varchar(20) values protein ID for this Known Gene
dupMrnaID AB000409varchar(20) values mrnaID for the duplicate
dupProteinID Q5TC08varchar(20) values protein ID for this duplicate

Connected Tables and Joining Fields
        hg17.all_mrna.qName (via dupSpMrna.mrnaID)
      hg17.altGraphX.mrnaRefs (via dupSpMrna.mrnaID)
      hg17.bioCycPathway.kgID (via dupSpMrna.mrnaID)
      hg17.ccdsInfo.mrnaAcc (via dupSpMrna.mrnaID)
      hg17.ccdsKgMap.geneId (via dupSpMrna.mrnaID)
      hg17.ceBlastTab.query (via dupSpMrna.mrnaID)
      hg17.dmBlastTab.query (via dupSpMrna.mrnaID)
      hg17.drBlastTab.query (via dupSpMrna.mrnaID)
      hg17.foldUtr3.name (via dupSpMrna.mrnaID)
      hg17.foldUtr5.name (via dupSpMrna.mrnaID)
      hg17.gladHumESDistance.query (via dupSpMrna.mrnaID)
      hg17.gladHumESDistance.target (via dupSpMrna.mrnaID)
      hg17.gnfAtlas2Distance.query (via dupSpMrna.mrnaID)
      hg17.gnfAtlas2Distance.target (via dupSpMrna.mrnaID)
      hg17.gnfU95Distance.query (via dupSpMrna.mrnaID)
      hg17.gnfU95Distance.target (via dupSpMrna.mrnaID)
      hg17.humanHprdP2P.query (via dupSpMrna.mrnaID)
      hg17.humanHprdP2P.target (via dupSpMrna.mrnaID)
      hg17.humanVidalP2P.query (via dupSpMrna.mrnaID)
      hg17.humanVidalP2P.target (via dupSpMrna.mrnaID)
      hg17.humanWankerP2P.query (via dupSpMrna.mrnaID)
      hg17.humanWankerP2P.target (via dupSpMrna.mrnaID)
      hg17.keggPathway.kgID (via dupSpMrna.mrnaID)
      hg17.kgAlias.kgID (via dupSpMrna.mrnaID)
      hg17.kgProtAlias.kgID (via dupSpMrna.mrnaID)
      hg17.kgSpAlias.kgID (via dupSpMrna.mrnaID)
      hg17.kgTargetAli.qName (via dupSpMrna.mrnaID)
      hg17.kgXref.kgID (via dupSpMrna.mrnaID)
      hg17.kgXref.refseq (via dupSpMrna.mrnaID)
      hg17.knownBlastTab.query (via dupSpMrna.mrnaID)
      hg17.knownBlastTab.target (via dupSpMrna.mrnaID)
      hg17.knownCanonical.transcript (via dupSpMrna.mrnaID)
      hg17.knownExpDistance.query (via dupSpMrna.mrnaID)
      hg17.knownExpDistance.target (via dupSpMrna.mrnaID)
      hg17.knownGene.name (via dupSpMrna.mrnaID)
      hg17.knownGeneLink.name (via dupSpMrna.mrnaID)
      hg17.knownGeneMrna.name (via dupSpMrna.mrnaID)
      hg17.knownGenePep.name (via dupSpMrna.mrnaID)
      hg17.knownIsoforms.transcript (via dupSpMrna.mrnaID)
      hg17.knownToAllenBrain.name (via dupSpMrna.mrnaID)
      hg17.knownToEnsembl.name (via dupSpMrna.mrnaID)
      hg17.knownToGnf1h.name (via dupSpMrna.mrnaID)
      hg17.knownToGnfAtlas2.name (via dupSpMrna.mrnaID)
      hg17.knownToHInv.name (via dupSpMrna.mrnaID)
      hg17.knownToHprd.name (via dupSpMrna.mrnaID)
      hg17.knownToKeggEntrez.name (via dupSpMrna.mrnaID)
      hg17.knownToLocusLink.name (via dupSpMrna.mrnaID)
      hg17.knownToPfam.name (via dupSpMrna.mrnaID)
      hg17.knownToRefSeq.name (via dupSpMrna.mrnaID)
      hg17.knownToRefSeq.value (via dupSpMrna.mrnaID)
      hg17.knownToSuper.gene (via dupSpMrna.mrnaID)
      hg17.knownToU133.name (via dupSpMrna.mrnaID)
      hg17.knownToU133Plus2.name (via dupSpMrna.mrnaID)
      hg17.knownToU95.name (via dupSpMrna.mrnaID)
      hg17.knownToVisiGene.name (via dupSpMrna.mrnaID)
      hg17.mgcFullMrna.qName (via dupSpMrna.mrnaID)
      hg17.mgcGenes.name (via dupSpMrna.mrnaID)
      hg17.mmBlastTab.query (via dupSpMrna.mrnaID)
      hg17.mrnaOrientInfo.name (via dupSpMrna.mrnaID)
      hg17.mrnaRefseq.mrna (via dupSpMrna.mrnaID)
      hg17.mrnaRefseq.refseq (via dupSpMrna.mrnaID)
      hg17.orfeomeGenes.name (via dupSpMrna.mrnaID)
      hg17.orfeomeMrna.qName (via dupSpMrna.mrnaID)
      hg17.rankProp.query (via dupSpMrna.mrnaID)
      hg17.rankProp.target (via dupSpMrna.mrnaID)
      hg17.refFlat.name (via dupSpMrna.mrnaID)
      hg17.refGene.name (via dupSpMrna.mrnaID)
      hg17.refSeqAli.qName (via dupSpMrna.mrnaID)
      hg17.rnBlastTab.query (via dupSpMrna.mrnaID)
      hg17.scBlastTab.query (via dupSpMrna.mrnaID)
      hg17.spMrna.mrnaID (via dupSpMrna.mrnaID)
      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)
      go.goaPart.dbObjectSymbol (via dupSpMrna.proteinID)
      hg17.kgProtAlias.displayID (via dupSpMrna.proteinID)
      hg17.kgSpAlias.alias (via dupSpMrna.proteinID)
      hg17.kgXref.spDisplayID (via dupSpMrna.proteinID)
      hg17.knownCanonical.protein (via dupSpMrna.proteinID)
      hg17.spMrna.spID (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)
      proteome.spOldNew.newDisplayId (via dupSpMrna.proteinID)
      proteome.spOldNew.oldDisplayId (via dupSpMrna.proteinID)
      uniProt.displayId.val (via dupSpMrna.proteinID)

Sample Rows
 
mrnaIDproteinIDdupMrnaIDdupProteinID
AB000409Q9BUB5-2AB000409Q5TC08
AB000409Q9BUB5-2AB000409Q6V0N6
AB000409Q9BUB5-2AB000409Q7Z319
AB000460P78311_HUMANAB000460O43607
AB000460P78311_HUMANAB000460P78311
AB000460P78311_HUMANAB000460P78312
AB000460P78311_HUMANAB000460P78313
AB000460P78311_HUMANAB000460Q9UEG8
AB000461P78313_HUMANAB000461P78313
AB000463P78314-2AB000463P78314

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