Schema for spMrna
  Database: hg19    Primary Table: spMrna    Row Count: 110,428   Data last updated: 2024-08-23
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.10_4varchar(255) values GenBank mRNA accession

Connected Tables and Joining Fields
        go.goaPart.dbObjectSymbol (via spMrna.spID)
      hg19.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_4
Q96AH2_HUMANENST00000000412.3
Q569H8_HUMANENST00000000442.11_8
FKBP4_HUMANENST00000001008.6_4
CP26B_HUMANENST00000001146.7_7
NDUF7_HUMANENST00000002125.9_4
FUCO2_HUMANENST00000002165.11_7
DBND1_HUMANENST00000002501.11_6
HS3S1_HUMANENST00000002596.6_7
SEM3F_HUMANENST00000002829.8_6

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