Schema for spMrna
  Database: mm39    Primary Table: spMrna    Row Count: 65,935   Data last updated: 2024-08-15
Format description: The best representative mRNA for a protein
On download server: MariaDB table dump directory
fieldexampleSQL type info description
spID GNAI3_MOUSEvarchar(255) values SWISS-PROT display ID
mrnaID ENSMUST00000000001.5varchar(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)
      proteome.spOldNew.newDisplayId (via spMrna.spID)
      proteome.spOldNew.oldDisplayId (via spMrna.spID)
      uniProt.displayId.val (via spMrna.spID)

Sample Rows
 
spIDmrnaID
GNAI3_MOUSEENSMUST00000000001.5
Q3UV89_MOUSEENSMUST00000000003.14
HXB9_MOUSEENSMUST00000000010.9
CDC45_MOUSEENSMUST00000000028.14
IGF2_MOUSEENSMUST00000000033.12
APOH_MOUSEENSMUST00000000049.6
CAV2_MOUSEENSMUST00000000058.7
Q8BPQ2_MOUSEENSMUST00000000080.8
SCMH1_MOUSEENSMUST00000000087.13
COX5A_MOUSEENSMUST00000000090.8

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