Schema for spMrna
  Database: hg38    Primary Table: spMrna    Row Count: 120,150   Data last updated: 2024-08-19
Format description: The best representative mRNA for a protein
On download server: MariaDB table dump directory
fieldexampleSQL type info description
spID ARF5_HUMANvarchar(255) values SWISS-PROT display ID
mrnaID ENST00000000233.10varchar(255) values GenBank mRNA accession

Connected Tables and Joining Fields
        go.goaPart.dbObjectSymbol (via spMrna.spID)
      hg38.kgXref.spDisplayID (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
ARF5_HUMANENST00000000233.10
MPRD_HUMANENST00000000412.8
Q569H8_HUMANENST00000000442.11
FKBP4_HUMANENST00000001008.6
CP26B_HUMANENST00000001146.7
NDUF7_HUMANENST00000002125.9
FUCO2_HUMANENST00000002165.11
DBND1_HUMANENST00000002501.11
HS3S1_HUMANENST00000002596.6
SEM3F_HUMANENST00000002829.8

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