Schema for wgEncodeGencodeUniProtV28

JavaScript is disabled in your web browser

You must have JavaScript enabled in your web browser to use the Genome Browser

Schema for wgEncodeGencodeUniProtV28

Database: hg38 Primary Table: wgEncodeGencodeUniProtV28 Row Count: 113,473 Data last updated: 2020-06-30

field	example	SQL type	info
`transcriptId`	ENST00000000233.9	`varchar(255)`	values
`acc`	A4D0Z3	`varchar(255)`	values
`name`	A4D0Z3	`varchar(255)`	values
`dataset`	TrEMBL	`enum('SwissProt', 'TrEMBL')`	values

Connected Tables and Joining Fields


	hg38.wgEncodeGencodeAttrsV28.transcriptId (via wgEncodeGencodeUniProtV28.transcriptId)

Sample Rows

transcriptId	acc	name	dataset
ENST00000000233.9	A4D0Z3	A4D0Z3	TrEMBL
ENST00000000233.9	P84085	P84085	SwissProt
ENST00000000412.7	P20645	P20645	SwissProt
ENST00000000442.10	P11474	P11474	SwissProt
ENST00000000442.10	Q569H8	Q569H8	TrEMBL
ENST00000001008.5	Q02790	Q02790	SwissProt
ENST00000001146.6	Q9NR63	Q9NR63	SwissProt
ENST00000002125.8	Q7L592	Q7L592	SwissProt
ENST00000002165.10	Q9BTY2	Q9BTY2	SwissProt
ENST00000002501.10	Q9H9R9	Q9H9R9	SwissProt

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