Schema for wgEncodeGencodeAnnotationRemarkV40lift37
  Database: hg19    Primary Table: wgEncodeGencodeAnnotationRemarkV40lift37    Row Count: 106,986   Data last updated: 2022-04-28
Format description: Annotation remarks
On download server: MariaDB table dump directory
fieldexampleSQL type info description
transcriptId ENST00000000233.10_3varchar(255) values GENCODE transcript identifier
remark MANE_selectlongblob   Comment by annotator

Connected Tables and Joining Fields
        hg19.wgEncodeGencodeAttrsV40lift37.transcriptId (via wgEncodeGencodeAnnotationRemarkV40lift37.transcriptId)

Sample Rows
 
transcriptIdremark
ENST00000000233.10_3MANE_select
ENST00000000442.11_6MANE_select
ENST00000000442.11_6NAGNAG splice site
ENST00000001008.6_3corf
ENST00000001008.6_3MANE_select
ENST00000001146.7_5MANE_select
ENST00000001146.7_5NP_063938.1
ENST00000002125.9_3MANE_select
ENST00000002165.11_5MANE_select
ENST00000002165.11_5novel 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.