Skip to content

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]

Images associated with NCBI Taxonomy nodes, one row per image.

Not partitioned.

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.