ncbi_taxonomy.citations
import bedrock_bio as bb
rel = bb.load_table('ncbi_taxonomy.citations')
df = rel.limit(5).pl() # Polars
df = rel.limit(5).df() # Pandas
df.head()| sources | citation_id | citation_key | medline_id | pubmed_id | url | text | taxon_ids | |
|---|---|---|---|---|---|---|---|---|
| 0 | [{'url': 'https://ftp.ncbi.nlm.nih.gov/pub/tax... | 100 | Mellado E et al. (1995) | None | 7547290 | None | Mellado, E., Moore, E.R., Nieto, J.J., and Ven... | [42055, 42566] |
| 1 | [{'url': 'https://ftp.ncbi.nlm.nih.gov/pub/tax... | 1000 | Citrobacter intermedius | None | NaN | None | Bergey's Manual of Systematic Bacteriology (19... | [66695] |
| 2 | [{'url': 'https://ftp.ncbi.nlm.nih.gov/pub/tax... | 10000 | Prevot AR (1938c) | None | NaN | None | Prevot, A.R. \"Etudes de systematique bacterie... | [816, 817, 818, 823, 1730, 1736, 1737, 28117, ... |
| 3 | [{'url': 'https://ftp.ncbi.nlm.nih.gov/pub/tax... | 10001 | Holdeman LV et al. (1977) | None | NaN | None | Holdeman, L.V., Cato, E.P., Moore, W.E.C.: Ana... | [905, 28114, 39489, 83339, 84025] |
| 4 | [{'url': 'https://ftp.ncbi.nlm.nih.gov/pub/tax... | 10002 | Dai SK et al. (unpublished_2002) | None | NaN | None | Dai, S.K., Lin, H.P., and Liu, J.K. [No title]... | [185668] |
library(bedrockbio)
lf <- load_table("ncbi_taxonomy.citations")
df <- head(lf, 5) |> collect()
head(df)Sample output (5 rows, showing 6 of 8 columns) citation_id | citation_key | medline_id | pubmed_id | url | text ----------- | ------------------------ | ---------- | --------- | --- | ------------------------ 0 100 | Mellado E et al. (1995) | — | 7547290 | — | Mellado, E., Moore, E.R… 1 1000 | Citrobacter intermedius | — | — | — | Bergey's Manual of Syst… 2 10000 | Prevot AR (1938c) | — | — | — | Prevot, A.R. \"Etudes d… 3 10001 | Holdeman LV et al. (197… | — | — | — | Holdeman, L.V., Cato, E… 4 10002 | Dai SK et al. (unpublis… | — | — | — | Dai, S.K., Lin, H.P., a…
Description
Section titled “Description”Literature citations associated with NCBI Taxonomy nodes, one row per citation.
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)[] |
Source provenance for the row. |
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. |