Skip to content

type_materials

ncbi_taxonomy.type_materials

NCBI type material collection records associated with taxonomy nodes, from typematerial.dmp.

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.
taxon_id TEXT Taxonomy ID associated with the type material.
taxon_name TEXT Organism name to which NCBI assigns the type material.
type_material_type TEXT NCBI type material type.
collection_identifier TEXT Identifier in the type material collection.