history
Identifier
Section titled “Identifier”Description
Section titled “Description”NCBI Gene records for discontinued GeneIDs, one row per discontinued GeneID.
gene_id is the current replacement GeneID when NCBI provides one; it is null when the discontinued record has no replacement.
Use this table to resolve older GeneIDs before querying current NCBI Gene tables.
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 history file. |
taxon_id |
TEXT |
NCBI taxonomy identifier for the species or strain associated with the discontinued gene. |
gene_id |
TEXT |
Current replacement NCBI Gene identifier, if NCBI provides one. |
discontinued_gene_id |
TEXT |
Discontinued NCBI Gene identifier; the unique key. |
discontinued_symbol |
TEXT |
Symbol assigned to the discontinued GeneID, if supplied. |
discontinued_date |
DATE |
Date NCBI discontinued or replaced the GeneID. |