nodes

Identifier

ncbi_taxonomy.nodes

Description

NCBI Taxonomy node hierarchy and inherited classification settings, from nodes.dmp.

Partitions

Not partitioned.

Schema

Column	Type	Description
sources	STRUCT(url TEXT, filename TEXT, last_modified_at TIMESTAMPTZ, sha256 TEXT)[]	Original external inputs used to produce the row. Each item contains its source URL, filename, HTTP Last-Modified timestamp when available, and computed SHA-256 checksum.
taxon_id	TEXT	Taxonomy ID for this node.
parent_taxon_id	TEXT	Taxonomy ID for this node’s parent.
rank	TEXT	Taxonomic rank, such as species, genus, family, or no rank.
embl_code	TEXT	EMBL locus-name prefix, if assigned.
division_id	TEXT	NCBI Taxonomy division ID.
inherits_division	BOOLEAN	Whether the node inherits its division from its parent.
genetic_code_id	TEXT	NCBI genetic-code ID.
inherits_genetic_code	BOOLEAN	Whether the node inherits its genetic code from its parent.
mitochondrial_genetic_code_id	TEXT	NCBI mitochondrial genetic-code ID.
inherits_mitochondrial_genetic_code	BOOLEAN	Whether the node inherits its mitochondrial genetic code from its parent.
is_genbank_hidden	BOOLEAN	Whether the node name is suppressed in a GenBank entry lineage.
is_hidden_subtree_root	BOOLEAN	Whether the node roots a subtree with no sequence data.
comment	TEXT	Free-text NCBI comments and citations, if supplied.
plastid_genetic_code_id	TEXT	NCBI plastid genetic-code ID, if supplied.
inherits_plastid_genetic_code	BOOLEAN	Whether the node inherits its plastid genetic code from its parent, if supplied.
has_specified_species	BOOLEAN	Whether the species in the node’s lineage has a formal name.
hydrogenosome_genetic_code_id	TEXT	NCBI hydrogenosome genetic-code ID, if supplied.
inherits_hydrogenosome_genetic_code	BOOLEAN	Whether the node inherits its hydrogenosome genetic code from its parent.