Schema for wgEncodeGencodeAnnotationRemarkV38lift37
  Database: hg19    Primary Table: wgEncodeGencodeAnnotationRemarkV38lift37    Row Count: 97,369   Data last updated: 2021-06-29
Format description: Annotation remarks
On download server: MariaDB table dump directory
fieldexampleSQL type info description
transcriptId ENST00000000233.10_1varchar(255) values GENCODE transcript identifier
remark MANE_selectlongblob   Comment by annotator

Connected Tables and Joining Fields
        hg19.wgEncodeGencodeAttrsV38lift37.transcriptId (via wgEncodeGencodeAnnotationRemarkV38lift37.transcriptId)

Sample Rows
 
transcriptIdremark
ENST00000000233.10_1MANE_select
ENST00000000442.11_1MANE_select
ENST00000000442.11_1NAGNAG splice site
ENST00000001008.6_1corf
ENST00000001008.6_1MANE_select
ENST00000001146.7_1MANE_select
ENST00000001146.7_1NP_063938.1
ENST00000002125.9_1MANE_select
ENST00000002165.11_1MANE_select
ENST00000002165.11_1novel protein (MGC1314) similar to fucosidase, alpha-L- 1, tissue

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