Schema for wgEncodeGencodeGeneSymbolV40
  Database: hg38    Primary Table: wgEncodeGencodeGeneSymbolV40    Row Count: 231,980   Data last updated: 2022-04-21
Format description: GENCODE transcript to official gene symbol. For human, this is the HUGO Gene Nomenclature Committee (HGNC) gene symbo. For mouse, this is the Mouse Genome Informatics (MGI) gene symbol.
On download server: MariaDB table dump directory
fieldexampleSQL type info description
transcriptId ENST00000379236.4varchar(255) values GENCODE transcript identifier
symbol TNFRSF4varchar(255) values HGNC/MGI gene symbol
geneId HGNC:11918varchar(255) values HGNC/MGI symbol id used by database

Connected Tables and Joining Fields
        hg38.wgEncodeGencodeAttrsV40.transcriptId (via wgEncodeGencodeGeneSymbolV40.transcriptId)

Sample Rows
 
transcriptIdsymbolgeneId
ENST00000379236.4TNFRSF4HGNC:11918
ENST00000497869.5TNFRSF4HGNC:11918
ENST00000453580.1TNFRSF4HGNC:11918
ENST00000328596.10TNFRSF18HGNC:11914
ENST00000379268.7TNFRSF18HGNC:11914
ENST00000486728.5TNFRSF18HGNC:11914
ENST00000379265.5TNFRSF18HGNC:11914
ENST00000673477.1ATAD3BHGNC:24007
ENST00000472194.6ATAD3BHGNC:24007
ENST00000378736.3ATAD3BHGNC:24007

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