Schema for wgEncodeGencodeAnnotationRemarkV31lift37
  Database: hg19    Primary Table: wgEncodeGencodeAnnotationRemarkV31lift37    Row Count: 77,196   Data last updated: 2019-07-05
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.wgEncodeGencodeAttrsV31lift37.transcriptId (via wgEncodeGencodeAnnotationRemarkV31lift37.transcriptId)

Sample Rows
 
transcriptIdremark
ENST00000000233.10_2MANE_select
ENST00000000442.11_2MANE_select
ENST00000000442.11_2NAGNAG splice site
ENST00000001008.6_2corf
ENST00000001008.6_2MANE_select
ENST00000001146.6_1NP_063938.1
ENST00000002125.9_2MANE_select
ENST00000002165.10_1novel protein (MGC1314) similar to fucosidase, alpha-L- 1, tissue
ENST00000002829.8_3MANE_select
ENST00000003084.10_1LR annotation

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