Skip to content

citations

ncbi_taxonomy.citations

Literature citations associated with NCBI Taxonomy nodes, from citations.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.
citation_id TEXT NCBI Taxonomy citation ID.
citation_key TEXT NCBI citation key, if supplied.
medline_id TEXT MEDLINE identifier, if assigned; null when NCBI supplies zero.
pubmed_id TEXT PubMed identifier, if assigned; null when NCBI supplies zero.
url TEXT Citation URL, if supplied.
text TEXT Citation text. NCBI’s escaped newlines, tabs, quotes, and backslashes remain encoded.
taxon_ids TEXT[] Taxonomy IDs associated with the citation, split from NCBI’s space-delimited field.