Schema for wgEncodeGencodeTranscriptSourceV42lift37
  Database: hg19    Primary Table: wgEncodeGencodeTranscriptSourceV42lift37    Row Count: 253,737   Data last updated: 2022-11-03
Format description: The source of Gencode transcript annotation
On download server: MariaDB table dump directory
fieldexampleSQL type info description
transcriptId ENST00000450305.2_2varchar(255) values GENCODE transcript identifier
source havana_homo_sapiensvarchar(255) values Source of transcript

Connected Tables and Joining Fields
        hg19.wgEncodeGencodeAttrsV42lift37.transcriptId (via wgEncodeGencodeTranscriptSourceV42lift37.transcriptId)

Sample Rows
 
transcriptIdsource
ENST00000450305.2_2havana_homo_sapiens
ENST00000488147.1_4havana_homo_sapiens
ENST00000473358.1_4havana_homo_sapiens
ENST00000469289.1_1havana_homo_sapiens
ENST00000417324.1_4havana_homo_sapiens
ENST00000461467.1_3havana_homo_sapiens
ENST00000606857.1_2havana_homo_sapiens
ENST00000642116.1_2havana_homo_sapiens
ENST00000492842.2_3havana_homo_sapiens
ENST00000641515.2_4havana_homo_sapiens

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