Schema for wgEncodeGencodeAnnotationRemarkV28lift37
  Database: hg19    Primary Table: wgEncodeGencodeAnnotationRemarkV28lift37    Row Count: 42,636   Data last updated: 2018-04-17
Format description: Annotation remarks
On download server: MariaDB table dump directory
fieldexampleSQL type info description
transcriptId ENST00000000442.10_1varchar(255) values GENCODE transcript identifier
remark NAGNAG splice sitelongblob   Comment by annotator

Connected Tables and Joining Fields
        hg19.wgEncodeGencodeAttrsV28lift37.transcriptId (via wgEncodeGencodeAnnotationRemarkV28lift37.transcriptId)

Sample Rows
 
transcriptIdremark
ENST00000000442.10_1NAGNAG splice site
ENST00000001008.5_1corf
ENST00000001146.6_1NP_063938.1
ENST00000002165.10_1novel protein (MGC1314) similar to fucosidase, alpha-L- 1, tissue
ENST00000003100.12_2NP_000777
ENST00000003912.7_2DJ462O23.2
ENST00000005226.11_2NP_710142
ENST00000005286.8_3NAGNAG splice site
ENST00000005558.8_2alternative 5' UTR
ENST00000006251.11_3NP_056181.2

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