Schema for wgEncodeGencodeAnnotationRemarkV34lift37
  Database: hg19    Primary Table: wgEncodeGencodeAnnotationRemarkV34lift37    Row Count: 102,179   Data last updated: 2020-04-29
Format description: Annotation remarks
On download server: MariaDB table dump directory
fieldexampleSQL type info description
transcriptId ENST00000000233.10_2varchar(255) values GENCODE transcript identifier
remark MANE_selectlongblob   Comment by annotator

Connected Tables and Joining Fields
        hg19.wgEncodeGencodeAttrsV34lift37.transcriptId (via wgEncodeGencodeAnnotationRemarkV34lift37.transcriptId)

Sample Rows
 
transcriptIdremark
ENST00000000233.10_2MANE_select
ENST00000000442.11_3MANE_select
ENST00000000442.11_3NAGNAG splice site
ENST00000001008.6_2corf
ENST00000001008.6_2MANE_select
ENST00000001146.6_2NP_063938.1
ENST00000002125.9_2MANE_select
ENST00000002165.11_3MANE_select
ENST00000002165.11_3novel protein (MGC1314) similar to fucosidase, alpha-L- 1, tissue
ENST00000002501.11_2MANE_select

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