ncbi_taxonomy.images
import bedrock_bio as bb
rel = bb.load_table('ncbi_taxonomy.images')
df = rel.limit(5).pl() # Polars
df = rel.limit(5).df() # Pandas
df.head()| sources | image_id | image_key | image_url | license | attribution | image_source | properties | taxon_ids | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | [{'url': 'https://ftp.ncbi.nlm.nih.gov/pub/tax... | 100000 | image:Colletes simulans | http://www.ncbi.nlm.nih.gov/Taxonomy/taxi/imag... | CC BY-NC-SA (https://creativecommons.org/licen... | Royal Tyler | iNaturalist.com | [] | [395738] |
| 1 | [{'url': 'https://ftp.ncbi.nlm.nih.gov/pub/tax... | 100001 | image:Physisporinus tasmanicus | http://www.ncbi.nlm.nih.gov/Taxonomy/taxi/imag... | CC BY (https://creativecommons.org/licenses/by... | Heidi Meudt | iNaturalist.com | [] | [2917413] |
| 2 | [{'url': 'https://ftp.ncbi.nlm.nih.gov/pub/tax... | 100002 | image:Colletes sierrensis | http://www.ncbi.nlm.nih.gov/Taxonomy/taxi/imag... | CC BY-NC (https://creativecommons.org/licenses... | martineorianauriol | iNaturalist.com | [] | [420751] |
| 3 | [{'url': 'https://ftp.ncbi.nlm.nih.gov/pub/tax... | 100003 | image:Physma byrsaeum | http://www.ncbi.nlm.nih.gov/Taxonomy/taxi/imag... | CC BY-NC (https://creativecommons.org/licenses... | Common Blue | iNaturalist.com | [] | [586083] |
| 4 | [{'url': 'https://ftp.ncbi.nlm.nih.gov/pub/tax... | 100004 | image:Colletes susannae | http://www.ncbi.nlm.nih.gov/Taxonomy/taxi/imag... | CC BY-NC (https://creativecommons.org/licenses... | dleaon1 | iNaturalist.com | [] | [3038044] |
library(bedrockbio)
lf <- load_table("ncbi_taxonomy.images")
df <- head(lf, 5) |> collect()
head(df)Sample output (5 rows, showing 6 of 9 columns) image_id | image_key | image_url | license | attribution | image_source -------- | ------------------------ | ------------------------ | ------------------------ | ------------------ | --------------- 0 100000 | image:Colletes simulans | http://www.ncbi.nlm.nih… | CC BY-NC-SA (https://cr… | Royal Tyler | iNaturalist.com 1 100001 | image:Physisporinus tas… | http://www.ncbi.nlm.nih… | CC BY (https://creative… | Heidi Meudt | iNaturalist.com 2 100002 | image:Colletes sierrens… | http://www.ncbi.nlm.nih… | CC BY-NC (https://creat… | martineorianauriol | iNaturalist.com 3 100003 | image:Physma byrsaeum | http://www.ncbi.nlm.nih… | CC BY-NC (https://creat… | Common Blue | iNaturalist.com 4 100004 | image:Colletes susannae | http://www.ncbi.nlm.nih… | CC BY-NC (https://creat… | dleaon1 | iNaturalist.com
Description
Section titled “Description”Images associated with NCBI Taxonomy nodes, one row per image.
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. |
image_id |
TEXT |
NCBI Taxonomy image ID. |
image_key |
TEXT |
NCBI image key. |
image_url |
TEXT |
Image URL. |
license |
TEXT |
Image license or rights statement. |
attribution |
TEXT |
Image attribution, if supplied. |
image_source |
TEXT |
Source of the image. |
properties |
TEXT[] |
Image properties, split from NCBI’s semicolon-delimited field. |
taxon_ids |
TEXT[] |
Taxonomy IDs associated with the image, split from NCBI’s space-delimited field. |