Schema for spMrna
  Database: mm10    Primary Table: spMrna    Row Count: 50,525   Data last updated: 2019-09-20
Format description: The best representative mRNA for a protein
On download server: MariaDB table dump directory
fieldexampleSQL type info description
spID XKR4_MOUSEvarchar(255) values SWISS-PROT display ID
mrnaID ENSMUST00000070533.4varchar(255) values GenBank mRNA accession

Connected Tables and Joining Fields
        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)
      mm10.kgXref.spDisplayID (via spMrna.spID)
      proteome.spOldNew.newDisplayId (via spMrna.spID)
      proteome.spOldNew.oldDisplayId (via spMrna.spID)
      uniProt.displayId.val (via spMrna.spID)

Sample Rows
 
spIDmrnaID
XKR4_MOUSEENSMUST00000070533.4
RP1_MOUSEENSMUST00000027032.5
SOX17_MOUSEENSMUST00000027035.9
SOX17_MOUSEENSMUST00000195555.1
SOX17_MOUSEENSMUST00000116652.7
RM15_MOUSEENSMUST00000130201.7
RM15_MOUSEENSMUST00000156816.6
F8WHN1_MOUSEENSMUST00000045689.13
J3QP56_MOUSEENSMUST00000134384.7
LYPA1_MOUSEENSMUST00000027036.10

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