Schema for wgEncodeGencodeAttrsV24

Database: hg38 Primary Table: wgEncodeGencodeAttrsV24 Row Count: 215,966 Data last updated: 2015-12-09
On download server: MariaDB table dump directory

field	example	SQL type	info
`geneId`	ENSG00000223972.5	`varchar(255)`	values
`geneName`	DDX11L1	`varchar(255)`	values
`geneType`	transcribed_unprocessed_pse...	`varchar(255)`	values
`geneStatus`	KNOWN	`varchar(255)`	values
`transcriptId`	ENST00000456328.2	`varchar(255)`	values
`transcriptName`	DDX11L1-002	`varchar(255)`	values
`transcriptType`	processed_transcript	`varchar(255)`	values
`transcriptStatus`	KNOWN	`varchar(255)`	values
`havanaGeneId`	OTTHUMG00000000961.2	`varchar(255)`	values
`havanaTranscriptId`	OTTHUMT00000362751.1	`varchar(255)`	values
`ccdsId`		`varchar(255)`	values
`level`	2	`int(11)`	range
`transcriptClass`	pseudo	`varchar(255)`	values

Connected Tables and Joining Fields


	hg38.wgEncodeGencodeGeneSourceV24.geneId (via wgEncodeGencodeAttrsV24.geneId) hg38.wgEncodeGencodeAnnotationRemarkV24.transcriptId (via wgEncodeGencodeAttrsV24.transcriptId) hg38.wgEncodeGencodeBasicV24.name (via wgEncodeGencodeAttrsV24.transcriptId) hg38.wgEncodeGencodeCompV24.name (via wgEncodeGencodeAttrsV24.transcriptId) hg38.wgEncodeGencodeEntrezGeneV24.transcriptId (via wgEncodeGencodeAttrsV24.transcriptId) hg38.wgEncodeGencodeExonSupportV24.transcriptId (via wgEncodeGencodeAttrsV24.transcriptId) hg38.wgEncodeGencodePdbV24.transcriptId (via wgEncodeGencodeAttrsV24.transcriptId) hg38.wgEncodeGencodePseudoGeneV24.name (via wgEncodeGencodeAttrsV24.transcriptId) hg38.wgEncodeGencodePubMedV24.transcriptId (via wgEncodeGencodeAttrsV24.transcriptId) hg38.wgEncodeGencodeRefSeqV24.transcriptId (via wgEncodeGencodeAttrsV24.transcriptId) hg38.wgEncodeGencodeTagV24.transcriptId (via wgEncodeGencodeAttrsV24.transcriptId) hg38.wgEncodeGencodeTranscriptSourceV24.transcriptId (via wgEncodeGencodeAttrsV24.transcriptId) hg38.wgEncodeGencodeTranscriptSupportV24.transcriptId (via wgEncodeGencodeAttrsV24.transcriptId) hg38.wgEncodeGencodeTranscriptionSupportLevelV24.transcriptId (via wgEncodeGencodeAttrsV24.transcriptId) hg38.wgEncodeGencodeUniProtV24.transcriptId (via wgEncodeGencodeAttrsV24.transcriptId)

Sample Rows

geneId	geneName	geneType	geneStatus	transcriptId	transcriptName	transcriptType	transcriptStatus	havanaGeneId	havanaTranscriptId	level	transcriptClass
ENSG00000223972.5	DDX11L1	transcribed_unprocessed_pseudogene	KNOWN	ENST00000456328.2	DDX11L1-002	processed_transcript	KNOWN	OTTHUMG00000000961.2	OTTHUMT00000362751.1	2	pseudo
ENSG00000223972.5	DDX11L1	transcribed_unprocessed_pseudogene	KNOWN	ENST00000450305.2	DDX11L1-001	transcribed_unprocessed_pseudogene	KNOWN	OTTHUMG00000000961.2	OTTHUMT00000002844.2	2	pseudo
ENSG00000227232.5	WASH7P	unprocessed_pseudogene	KNOWN	ENST00000488147.1	WASH7P-001	unprocessed_pseudogene	KNOWN	OTTHUMG00000000958.1	OTTHUMT00000002839.1	2	pseudo
ENSG00000278267.1	MIR6859-1	miRNA	KNOWN	ENST00000619216.1	MIR6859-1-201	miRNA	KNOWN			3	nonCoding
ENSG00000243485.3	RP11-34P13.3	lincRNA	KNOWN	ENST00000473358.1	RP11-34P13.3-001	lincRNA	KNOWN	OTTHUMG00000000959.2	OTTHUMT00000002840.1	2	nonCoding
ENSG00000243485.3	RP11-34P13.3	lincRNA	KNOWN	ENST00000469289.1	RP11-34P13.3-002	lincRNA	KNOWN	OTTHUMG00000000959.2	OTTHUMT00000002841.2	2	nonCoding
ENSG00000274890.1	MIR1302-2	miRNA	KNOWN	ENST00000607096.1	MIR1302-2-201	miRNA	KNOWN			3	nonCoding
ENSG00000237613.2	FAM138A	lincRNA	KNOWN	ENST00000417324.1	FAM138A-001	lincRNA	KNOWN	OTTHUMG00000000960.1	OTTHUMT00000002842.1	2	nonCoding
ENSG00000237613.2	FAM138A	lincRNA	KNOWN	ENST00000461467.1	FAM138A-002	lincRNA	KNOWN	OTTHUMG00000000960.1	OTTHUMT00000002843.1	2	nonCoding
ENSG00000268020.3	OR4G4P	unprocessed_pseudogene	KNOWN	ENST00000606857.1	OR4G4P-001	unprocessed_pseudogene	KNOWN	OTTHUMG00000185779.1	OTTHUMT00000471235.1	2	pseudo

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