Schema for wgEncodeGencodeRefSeqVM39

Database: mm39 Primary Table: wgEncodeGencodeRefSeqVM39 Row Count: 58,006 Data last updated: 2026-04-24
Format description: GENCODE transcript to RefSeq mRNA or non-coding RNA and peptide accession mapping
On download server: MariaDB table dump directory

field	example	SQL type	info	description
`transcriptId`	ENSMUST00000201297.2	`varchar(255)`	values	GENCODE transcript identifier
`rnaAcc`	NM_001290692.1	`varchar(255)`	values	RefSeq mRNA or non-coding RNA accession
`pepAcc`	NP_001277621.1	`varchar(255)`	values	RefSeq peptide identifier for coding accession

Connected Tables and Joining Fields


	mm39.refGene.name (via wgEncodeGencodeRefSeqVM39.rnaAcc) mm39.wgEncodeGencodeAttrsVM39.transcriptId (via wgEncodeGencodeRefSeqVM39.transcriptId)

Sample Rows

transcriptId	rnaAcc	pepAcc
ENSMUST00000201297.2	NM_001290692.1	NP_001277621.1
ENSMUST00000043725.9	NM_001077425.2	NP_001070893.1
ENSMUST00000043725.9	NM_001371013.1	NP_001357942.1
ENSMUST00000072079.9	NM_021511.2	NP_067486.2
ENSMUST00000186264.2	NM_001436151.1	NP_001423080.1
ENSMUST00000083639.3	NR_029775.1
ENSMUST00000238662.2	NM_001376984.1	NP_001363913.1
ENSMUST00000183584.3	NR_105761.1
ENSMUST00000191156.2	NR_188937.1
ENSMUST00000184495.3	NR_105770.1

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