Schema for spMrna
  Database: rn3    Primary Table: spMrna    Row Count: 8,112   Data last updated: 2004-03-23
Format description: The best representative mRNA for a protein
On download server: MariaDB table dump directory
fieldexampleSQL type info description
spID 143B_RATvarchar(255) values SWISS-PROT display ID
mrnaID S83440varchar(255) values GenBank mRNA accession

Connected Tables and Joining Fields
        hgFixed.gbCdnaInfo.acc (via spMrna.mrnaID)
      hgFixed.gbSeq.acc (via spMrna.mrnaID)
      hgFixed.imageClone.acc (via spMrna.mrnaID)
      rn3.all_mrna.qName (via spMrna.mrnaID)
      rn3.dupSpMrna.dupMrnaID (via spMrna.mrnaID)
      rn3.dupSpMrna.mrnaID (via spMrna.mrnaID)
      rn3.mgcFullMrna.qName (via spMrna.mrnaID)
      rn3.mgcGenes.name (via spMrna.mrnaID)
      rn3.mrnaOrientInfo.name (via spMrna.mrnaID)
      rn3.mrnaRefseq.mrna (via spMrna.mrnaID)
      go.goaPart.dbObjectSymbol (via spMrna.spID)
      knownGeneV39.kgProtAlias.displayID (via spMrna.spID)
      knownGeneV39.kgSpAlias.alias (via spMrna.spID)
      knownGeneV39.kgXref.spDisplayID (via spMrna.spID)
      knownGeneV39.knownCanonical.protein (via spMrna.spID)
      proteome.spOldNew.newDisplayId (via spMrna.spID)
      proteome.spOldNew.oldDisplayId (via spMrna.spID)
      rn3.dupSpMrna.dupProteinID (via spMrna.spID)
      rn3.dupSpMrna.proteinID (via spMrna.spID)
      rn3.kgProtAlias.displayID (via spMrna.spID)
      rn3.kgSpAlias.alias (via spMrna.spID)
      rn3.kgXref.spDisplayID (via spMrna.spID)
      rn3.knownCanonical.protein (via spMrna.spID)
      uniProt.displayId.val (via spMrna.spID)

Sample Rows
 
spIDmrnaID
143B_RATS83440
143E_HUMAND30739
143F_MOUSED17445
143G_HUMANS55305
143T_MOUSED17614
143Z_MOUSEU37252
22P1_RATM58167
22P2_RATM58169
2ABA_RATM83298
2ABB_RATD38260

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