genes
Identifier
Section titled “Identifier”Description
Section titled “Description”Current NCBI Gene identity, nomenclature, and cross-reference records, one row per GeneID.
gene_symbol is NCBI’s default symbol and is not necessarily an HGNC symbol. synonyms are alternate symbols, while other_designations are alternate descriptive names. db_xrefs contains external database identifiers as db and normalized id pairs.
Partitions
Section titled “Partitions”Not partitioned.
Schema
Section titled “Schema”| Column | Type | Description |
|---|---|---|
sources |
STRUCT(url TEXT, filename TEXT, last_modified_at TIMESTAMPTZ, sha256 TEXT)[] |
Provenance for the NCBI Gene information file. |
taxon_id |
TEXT |
NCBI taxonomy identifier for the species or strain associated with the gene. |
gene_id |
TEXT |
Current stable numeric NCBI Gene identifier. |
gene_symbol |
TEXT |
NCBI default gene symbol. |
locus_tag |
TEXT |
NCBI locus tag, if supplied. |
synonyms |
TEXT[] |
Alternative or unofficial gene symbols, with database-style prefixes removed. |
db_xrefs |
STRUCT(db TEXT, id TEXT)[] |
External identifiers as db and normalized id pairs. |
chromosome |
TEXT |
Chromosome on which NCBI places the gene, if supplied; mitochondrial genomes use MT. |
map_location |
TEXT |
NCBI map location, if supplied. |
description |
TEXT |
NCBI descriptive gene name, if supplied. |
gene_type |
TEXT |
NCBI gene type. |
nomenclature_symbol |
TEXT |
Symbol supplied by a nomenclature authority, if supplied. |
nomenclature_name |
TEXT |
Full name supplied by a nomenclature authority, if supplied. |
nomenclature_status |
TEXT |
Nomenclature authority status: O for official or I for interim, if supplied. |
other_designations |
TEXT[] |
Alternate descriptive names assigned to the GeneID. |
modified_date |
DATE |
Date NCBI last modified the gene record, if supplied. |
feature_types |
TEXT[] |
Annotated feature types and classes or controlled vocabularies derived from selected RefSeq annotations. |