Skip to content

categories

ncbi_taxonomy.categories

NCBI’s broad category and species-level mapping for each taxon, from categories.dmp in the taxcat archive.

Not partitioned.

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.
category TEXT Broad NCBI category — Archaea, Bacteria, Eukaryota, Viruses and Viroids, Unclassified, or Other.
species_id TEXT Species-level taxonomy ID containing this taxon.
taxon_id TEXT Taxonomy ID for this taxon.