Skip to main content
Ctrl+K
logo

lamindb

Site Navigation

  • Guide
  • API Reference
  • Changelog

Site Navigation

  • Guide
  • API Reference
  • Changelog

Overview

  • LaminDB: data management for traceable, multimodal AI

How to

  • Query & search
    • Query tables in storage
    • Query arrays in storage
  • Track notebooks, scripts & workflows
  • Organize datasets
    • Curate datasets
  • Manage changes
  • Manage biological ontologies
  • Transfer & sync data across databases

Other topics

  • System design
    • Will data & metadata stay in sync?
    • Will data get duplicated upon re-running code?
  • FAQ
    • Pydantic & Pandera vs. LaminDB
    • Can I disable tracking run inputs?
    • How do I validate & annotate arbitrary data structures?
    • What happens if I import a schema module without lamindb?
    • Where to store external links and IDs?
    • Keep artifacts local in a cloud instance
    • Django field validation
    • Why should I not index datasets with gene symbols?
    • How does search work?
  • Storage
    • Track artifacts, in-memory objects & folders [S3 storage]
    • Add, replace, cache and delete artifacts
    • Test AnnDataAccessor
    • Prepare sync artifacts from a local instance to a cloud instance
    • Sync artifacts from a local instance to a cloud instance
    • Vitessce integration

Query & search .md .md¶

This guide walks through querying & searching registries. To understand the links between objects that enable relational queries, see Organize datasets. To query datasets in storage, see Query tables in storage and Query arrays in storage .

Basics¶

Create a database object:

import lamindb as ln

db = ln.DB("laminlabs/lamindata")
Show code cell output Hide code cell output
! database has module pertdb, configure it: lamin settings modules set bionty,pertdb

Get an overview¶

Return the most recent entries of the Artifact registry as a DataFrame:

db.Artifact.to_dataframe()
Show code cell output Hide code cell output
! truncated query result to limit=20 Artifact objects
uid key description suffix kind otype size hash n_files n_observations ... is_latest is_locked created_at branch_id created_on_id space_id storage_id run_id schema_id created_by_id
id
29330 f5ziBE16S6cgCcAa0000 cell-census/2025-11-17/h5ads/b57462e3-1df5-463... Spinal cord dataset .h5ad None AnnData 838544828 ea9CevFem3KDHVmKcwAstg None 62711.0 ... True False 2026-08-07 10:18:36.374154+00:00 1 1 1 64 12723.0 None 60
29329 ipr0Yru8t2EUWI6W0000 cell-census/2025-11-17/h5ads/e2a00644-0a48-481... Brain dataset .h5ad None AnnData 1034127754 qmO4ws35SfmhDFjTPt04CQ None 75583.0 ... True False 2026-08-07 10:18:35.132493+00:00 1 1 1 64 12723.0 None 60
29327 VlKotQI94fi5ZeE30000 cell-census/2025-11-08/h5ads/001b01fe-5c70-4bd... WSSS_F_IMMsp10864183 .h5ad None AnnData 159135298 h0WE90MKphz5C2-yEv0wDA None 4992.0 ... True False 2026-08-07 10:17:56.973553+00:00 1 1 1 16 12722.0 None 60
29326 8pdGUzaPNtolFIdF0000 cell-census/2025-11-08/h5ads/00099d5e-154f-4a7... Spatial transcriptomics in mouse: Puck_191206_04 .h5ad None AnnData 16497090 zPOKGUYq66NbshPtZ-I08g None 26239.0 ... True False 2026-08-07 10:17:56.084912+00:00 1 1 1 16 12722.0 None 60
29281 UcBMQ0x1BaoNHzV40000 numbers/squares/first_10_squares.txt First ten square numbers as plain text .txt None None 28 g-iuTY5jGeVA5qtJM9julw None NaN ... True False 2026-08-07 09:25:24.158251+00:00 1 1 1 2 12696.0 None 76
29259 5cJBlMDWOr0pAn3y0000 examples/math/factorials_1_to_8.txt First eight factorial values from 1! through 8! .txt None None 68 lR8fl-ra1qVkEUpp8gxpxw None NaN ... True False 2026-08-07 09:03:57.446595+00:00 1 1 1 2 12680.0 None 76
29258 qtn8fhdZUgIks7G80000 numbers/multiples_of_7_under_200.txt Multiples of 7 under 200 .txt None None 97 SvIqUNLp-HrINGMvNrM1NA None NaN ... True False 2026-08-07 09:03:40.542280+00:00 1 1 1 2 12679.0 None 76
29248 jenYtkkzx95M1TQU0000 None Distance metrics between two random TCR sequences .csv None DataFrame 422 57rUtpQreT92ajZ2sz-IlQ None NaN ... True False 2026-08-07 06:58:24.636779+00:00 692 692 1 2 12667.0 None 46
29223 QxoTrvnz6bkj9TA10000 math/triangular_numbers_first_10.txt First 10 triangular numbers as plain text .txt None None 27 Dd1uQouUJum-KX3SDwdJ3A None NaN ... True False 2026-08-06 17:05:08.030015+00:00 1 1 1 2 12646.0 None 76
29222 r62W3X46XAnz2w5P0000 numbers/powers_of_2.txt All powers of 2 up to 1024, one per line. .txt None None 34 pDq7DpTH7A9AasfMEg9Qrw None NaN ... True False 2026-08-06 17:05:02.485530+00:00 1 1 1 2 12647.0 None 76
29220 dWjAvq6ACZC7rTuw0000 examples/fibonacci/first_12.txt First 12 Fibonacci numbers in a plain text file .txt None None 31 HQN_-xzkhu1li6B90qrtOw None NaN ... True False 2026-08-06 16:54:12.327105+00:00 1 1 1 2 12645.0 None 76
29219 JujVPU7fapWeydnI0000 math/divisors/divisors_of_360.txt All positive divisors of 360 as plain text .txt None None 83 dPwQdtda_ThT-13U_sjXaA None NaN ... True False 2026-08-06 16:54:02.965544+00:00 1 1 1 2 12645.0 None 76
29217 Sdwe8WMSeEGKQVbh0000 results/math/sum_squares_first_50_even.txt Sum of squares of the first 50 even numbers .txt None None 7 rEJ5bn_72WFgqaAl4Pk_bw None NaN ... True False 2026-08-06 16:33:52.222242+00:00 1 1 1 2 12640.0 None 76
29214 xu9q2UnPe0O1FwYt0000 datasets/math/fibonacci_20th.json The 20th Fibonacci number stored in JSON format. .json None None 36 B-yew0i1sL8iv9ADtgoIYQ None NaN ... True False 2026-08-06 16:33:23.868843+00:00 1 1 1 2 12639.0 None 76
29213 eEzb41uRboC2jhoK0000 inputs/math/first_50_even_numbers.txt First 50 even numbers as comma-separated integers .txt None None 146 THFdzn54OtPKvgdAUN7Z-g None NaN ... True False 2026-08-06 16:33:21.419051+00:00 1 1 1 2 NaN None 76
29212 De3Xj5hqtQl7taS30000 configs/fibonacci/nth_20.json Configuration specifying which Fibonacci posit... .json None None 13 dqoPu42JeQS4Jx2Re11dVA None NaN ... True False 2026-08-06 16:33:19.773003+00:00 1 1 1 2 12639.0 None 76
29208 ZzdLyHT9exLFcKW10000 datasets/math/prime_sum_first_100.json Sum and values of the first 100 prime numbers ... .json None None 923 Z7P-2UN4ASB1MeFXcvNgdw None NaN ... True False 2026-08-06 16:05:29.979742+00:00 1 1 1 2 12633.0 None 76
29206 BwGjbYsgPUfSSR1L0000 configs/math/prime_sum_first_100.json Configuration specifying how many prime number... .json None None 18 vz9R4lT82t9zn2abkeoDxQ None NaN ... True False 2026-08-06 16:05:25.888529+00:00 1 1 1 2 12633.0 None 76
29205 ml6u1K8sjEpoZhod0000 datasets/math/factorial_15.json Factorial of 15 stored as JSON. .json None None 43 MWrr2k8ZF72hK4wbWirr6Q None NaN ... True False 2026-08-06 16:05:25.517553+00:00 1 1 1 2 12632.0 None 76
29204 Tp2pMvf7TJBXuYbS0000 configs/math/factorial_15_input.json Configuration for factorial computation. .json None None 13 JL69ZvGDESYcgHwN_1ThJA None NaN ... True False 2026-08-06 16:05:20.833032+00:00 1 1 1 2 12632.0 None 76

20 rows × 22 columns

Include fields from other registries with the __ syntax:

db.Artifact.to_dataframe(include=["created_by__handle"])
Show code cell output Hide code cell output
! truncated query result to limit=20 Artifact objects
uid key created_by__handle
id
29330 f5ziBE16S6cgCcAa0000 cell-census/2025-11-17/h5ads/b57462e3-1df5-463... ishitajain9717
29329 ipr0Yru8t2EUWI6W0000 cell-census/2025-11-17/h5ads/e2a00644-0a48-481... ishitajain9717
29327 VlKotQI94fi5ZeE30000 cell-census/2025-11-08/h5ads/001b01fe-5c70-4bd... ishitajain9717
29326 8pdGUzaPNtolFIdF0000 cell-census/2025-11-08/h5ads/00099d5e-154f-4a7... ishitajain9717
29281 UcBMQ0x1BaoNHzV40000 numbers/squares/first_10_squares.txt ebad
29259 5cJBlMDWOr0pAn3y0000 examples/math/factorials_1_to_8.txt ebad
29258 qtn8fhdZUgIks7G80000 numbers/multiples_of_7_under_200.txt ebad
29248 jenYtkkzx95M1TQU0000 None sheetalgiri
29223 QxoTrvnz6bkj9TA10000 math/triangular_numbers_first_10.txt ebad
29222 r62W3X46XAnz2w5P0000 numbers/powers_of_2.txt ebad
29220 dWjAvq6ACZC7rTuw0000 examples/fibonacci/first_12.txt ebad
29219 JujVPU7fapWeydnI0000 math/divisors/divisors_of_360.txt ebad
29217 Sdwe8WMSeEGKQVbh0000 results/math/sum_squares_first_50_even.txt ebad
29214 xu9q2UnPe0O1FwYt0000 datasets/math/fibonacci_20th.json ebad
29213 eEzb41uRboC2jhoK0000 inputs/math/first_50_even_numbers.txt ebad
29212 De3Xj5hqtQl7taS30000 configs/fibonacci/nth_20.json ebad
29208 ZzdLyHT9exLFcKW10000 datasets/math/prime_sum_first_100.json ebad
29206 BwGjbYsgPUfSSR1L0000 configs/math/prime_sum_first_100.json ebad
29205 ml6u1K8sjEpoZhod0000 datasets/math/factorial_15.json ebad
29204 Tp2pMvf7TJBXuYbS0000 configs/math/factorial_15_input.json ebad

Get an overview of all most recent objects in the database:

db.view()
Show code cell output Hide code cell output
****************
* module: core *
****************
Artifact
uid key description suffix kind otype size hash n_files n_observations ... is_latest is_locked created_at branch_id created_on_id space_id storage_id run_id schema_id created_by_id
id
29330 f5ziBE16S6cgCcAa0000 cell-census/2025-11-17/h5ads/b57462e3-1df5-463... Spinal cord dataset .h5ad None AnnData 838544828 ea9CevFem3KDHVmKcwAstg None 62711.0 ... True False 2026-08-07 10:18:36.374154+00:00 1 1 1 64 12723 None 60
29329 ipr0Yru8t2EUWI6W0000 cell-census/2025-11-17/h5ads/e2a00644-0a48-481... Brain dataset .h5ad None AnnData 1034127754 qmO4ws35SfmhDFjTPt04CQ None 75583.0 ... True False 2026-08-07 10:18:35.132493+00:00 1 1 1 64 12723 None 60
29327 VlKotQI94fi5ZeE30000 cell-census/2025-11-08/h5ads/001b01fe-5c70-4bd... WSSS_F_IMMsp10864183 .h5ad None AnnData 159135298 h0WE90MKphz5C2-yEv0wDA None 4992.0 ... True False 2026-08-07 10:17:56.973553+00:00 1 1 1 16 12722 None 60
29326 8pdGUzaPNtolFIdF0000 cell-census/2025-11-08/h5ads/00099d5e-154f-4a7... Spatial transcriptomics in mouse: Puck_191206_04 .h5ad None AnnData 16497090 zPOKGUYq66NbshPtZ-I08g None 26239.0 ... True False 2026-08-07 10:17:56.084912+00:00 1 1 1 16 12722 None 60
29281 UcBMQ0x1BaoNHzV40000 numbers/squares/first_10_squares.txt First ten square numbers as plain text .txt None None 28 g-iuTY5jGeVA5qtJM9julw None NaN ... True False 2026-08-07 09:25:24.158251+00:00 1 1 1 2 12696 None 76
29259 5cJBlMDWOr0pAn3y0000 examples/math/factorials_1_to_8.txt First eight factorial values from 1! through 8! .txt None None 68 lR8fl-ra1qVkEUpp8gxpxw None NaN ... True False 2026-08-07 09:03:57.446595+00:00 1 1 1 2 12680 None 76
29258 qtn8fhdZUgIks7G80000 numbers/multiples_of_7_under_200.txt Multiples of 7 under 200 .txt None None 97 SvIqUNLp-HrINGMvNrM1NA None NaN ... True False 2026-08-07 09:03:40.542280+00:00 1 1 1 2 12679 None 76

7 rows × 22 columns

Collection
uid key description hash reference reference_type version_tag is_latest is_locked created_at branch_id created_on_id space_id created_by_id run_id schema_id meta_artifact_id
id
55 cqukvOra6GNNB71W0Llw collection-with-schema Empty collection with a direct schema relation... None None None None True False 2026-07-29 22:29:08.441329+00:00 1 1 1 20 NaN 229.0 None
53 br3wYkh6hnAvlLdo0000 csv_uploads_collection A collection of uploaded CSV samples zvW2xO8dU8whNb6COP34Qw None None None True False 2026-07-09 14:39:05.994080+00:00 3 3 1 46 NaN NaN None
52 okxPW6GIKBfRBE3B0001 scrna/collection1 None jKzNshNzE7IkXgRG17rj4A None None None True False 2026-06-03 05:10:43.531698+00:00 1 1 1 60 NaN NaN None
51 DMF53hCJZQdnVIzT0000 View PAS OME-TIFF, Neumann et al., 2020 in Vit... None vpleElXxZiaZblQ09q9K-g None None None True False 2026-01-28 23:40:21.984321+00:00 1 1 1 18 2250.0 NaN None
50 H1AlT19wFq7HdHqZ0000 View Habib17 (h5ad) in Vitessce None hmrSAi0jDsrxvo9Oy3Hiqg None None None True False 2026-01-20 20:28:39.313883+00:00 1 1 1 18 1934.0 NaN None
49 p46U2L7tUlotAAkI0000 View Xenium_V1_humanLung_Cancer_FFPE_he_image ... None KuLnVec2HsgUIbl0fcTXdQ None None None True False 2026-01-14 14:32:16.517376+00:00 1 1 1 40 NaN NaN None
46 mySQPfapuYs3ABLC0000 fasta-test-output-collection-2 None QUraKB3k9PERvsRza4ycCQ None None None True False 2025-11-30 22:35:25.029942+00:00 1 1 1 9 1591.0 NaN None
Feature
uid name _dtype_str unit description array_rank array_size array_shape synonyms default_value ... coerce is_locked is_type created_at branch_id created_on_id space_id created_by_id run_id type_id
id
712 F0ppq3tGFJMc feature_is_filtered bool None None 0 0 None None None ... None False False 2026-08-06 04:39:31.395798+00:00 1 1 1 60 12577.0 NaN
711 lNF0TWgo5d9B var_index cat[bionty.Gene.ensembl_gene_id[source__uid='4... None None 0 0 None None None ... None False False 2026-08-06 04:39:31.050543+00:00 1 1 1 60 12577.0 NaN
710 P35oSvVjfhTs codex_collection_schema_feature_20260729 str None None 0 1 None None None ... None False False 2026-07-29 22:28:37.587956+00:00 1 1 1 20 NaN NaN
709 mIWTishnUfBD 1000_genomes_cnv_vcf None None None 0 0 None None None ... None False True 2026-07-27 09:23:55.835590+00:00 1 1 1 9 NaN NaN
708 iBNQ2DyRdRMY workflow_status cat None The execution status of the Nextflow testing w... 0 0 None None None ... None False False 2026-07-09 14:43:34.246479+00:00 3 3 1 46 NaN NaN
701 YKDqA94Mc3pV bench-record-id str None None 0 0 None None None ... None False False 2026-06-29 10:00:37.486448+00:00 1 1 1 60 9802.0 NaN
700 C8YiQhwwrE5L donor_ethnicity list[cat[bionty.Ethnicity]] None None 0 0 None None None ... None False False 2026-06-23 14:50:03.557222+00:00 1 1 1 9 9591.0 692.0

7 rows × 21 columns

Project
uid name description abbr url start_date end_date is_locked is_type created_at branch_id created_on_id space_id created_by_id run_id type_id
id
77 f71hDEwbOjqx Space debugging None None None None None False False 2026-08-06 09:45:28.864762+00:00 1 1 1 60 None None
76 LtcVwm68sZo2 Space debugging test None None None None None False True 2026-08-06 09:38:55.797287+00:00 -1 1 1 60 None None
74 KrzaeLA1wPV1 Program Type None None None None None False True 2026-08-06 09:24:11.347019+00:00 1 1 1 60 None None
73 dLGPJoG8TQhd Space debugging None None None None None False True 2026-08-06 09:18:32.052879+00:00 -1 1 1 60 None None
72 EFqukxydbjPD SIS-2923 None None None None None False False 2026-08-06 08:52:55.166487+00:00 1 1 1 60 None None
68 OTJ4lkLJhiUW debugging None None None None None False False 2026-08-05 12:39:13.510196+00:00 1 1 1 60 None None
67 SKxRMsUdnW5g nf-lamin-showcase None None None None None False False 2026-07-22 14:25:08.788355+00:00 1 1 1 54 None None
Record
uid name description reference reference_type extra_data is_locked is_type created_at branch_id created_on_id space_id created_by_id type_id schema_id run_id
id
74187 eiplKvvqXcZvRgVI None None None None None False False 2026-08-07 13:32:12.518781+00:00 1 1 1 18 2759 None 12747
74186 56qnbU2PuGDAFf1Z None None None None None False False 2026-08-07 13:31:59.888444+00:00 1 1 1 18 611 None 12746
74185 vU5gJbzhw6gIpYWk None None None None None False False 2026-08-07 13:31:47.053332+00:00 1 1 1 18 2319 None 12745
74184 bpRepvX9weT24gJx None None None None None False False 2026-08-07 13:14:46.586418+00:00 1 1 1 18 2759 None 12744
74183 WZ9IVbWDHQuqoec2 None None None None None False False 2026-08-07 13:14:34.192703+00:00 1 1 1 18 611 None 12743
74182 WvdKpjV5hBDElwtH None None None None None False False 2026-08-07 13:14:21.921946+00:00 1 1 1 18 2319 None 12741
74181 DJVv4x74bwa3kZHN None None None None None False False 2026-08-07 09:28:16.336778+00:00 1 1 1 18 73698 None 12703
Reference
uid name description abbr url pubmed_id doi text date is_locked is_type created_at branch_id created_on_id space_id created_by_id run_id type_id
id
5 WFauEWWBwslb Nextflow enables reproducible computational wo... Di Tommaso, P., Chatzou, M., Floden, E.W. et a... None https://doi.org/10.1038/nbt.3820 NaN None None None False False 2026-07-09 14:41:07.854108+00:00 3 3 1 46 NaN None
4 c0bTj3vLkGPA CRISPR activation and interference screens dec... None Schmidt22 None 35113687.0 None Regulation of cytokine production in stimulate... None False False 2025-09-28 14:05:36.774006+00:00 1 1 1 9 840.0 None
3 v19l0ASlvdLj SEA-AD: Seattle Alzheimer’s Disease Brain Cell... The Seattle Alzheimer's Disease Brain Cell Atl... None https://cellxgene.cziscience.com/collections/1... NaN 10.1038/s41593-024-01774-5 None 2022-05-31 False False 2024-11-25 11:13:49.872888+00:00 1 1 1 30 501.0 None
2 XVqpeeo4rOGh Spatially mapping T cell receptors and transcr... This repository contains data from our manuscr... None https://cellxgene.cziscience.com/collections/0... NaN 10.1016/j.immuni.2022.09.002 None 2023-09-29 False False 2024-11-25 10:31:38.620076+00:00 1 1 1 30 501.0 None
1 1XqufHiwjUaq Multiplexed single-cell transcriptional respon... None McFarland 2020 https://www.nature.com/articles/s41467-020-174... NaN 10.1038/s41467-020-17440-w Assays to study cancer cell responses to pharm... None False False 2024-12-20 13:28:18.813382+00:00 1 1 1 2 NaN None
Run
uid name description entrypoint started_at finished_at params extra_data reference reference_type ... created_at branch_id created_on_id space_id transform_id report_id environment_id plan_id created_by_id initiated_by_run_id
id
12756 EZbZ1O0Z98yv7kKd None None check 2026-08-07 16:20:02.163549+00:00 2026-08-07 16:20:09.080837+00:00 {'no_run': False, 'script': 'tests/profiling/i... None None None ... 2026-08-07 16:20:02.163549+00:00 1 1 1 1413 29372.0 29369.0 None 18 None
12755 qgx5s7shYxm93AYY None None check 2026-08-07 16:19:50.571914+00:00 2026-08-07 16:19:57.430877+00:00 {'no_run': False, 'script': 'tests/profiling/i... None None None ... 2026-08-07 16:19:50.571914+00:00 1 1 1 1413 29371.0 29369.0 None 18 None
12754 zvYsDoVztf0PiEgB None None check 2026-08-07 16:19:31.557099+00:00 2026-08-07 16:19:46.816816+00:00 {'no_run': False, 'script': 'tests/profiling/i... None None None ... 2026-08-07 16:19:31.557099+00:00 1 1 1 1413 29370.0 29369.0 None 18 None
12753 PIVGlOeYgbMqp08S Run external output failure test script and ca... None None 2026-08-07 14:21:07.058214+00:00 NaT None None None None ... 2026-08-07 14:21:07.058214+00:00 692 692 1 1587 NaN NaN None 46 None
12752 aHYraEQDyONse0wj Run scripts/test_external_output_fail.py to pr... None None 2026-08-07 14:18:27.949932+00:00 NaT None None None None ... 2026-08-07 14:18:27.949932+00:00 692 692 1 1587 NaN NaN None 46 None
12751 EDPHyjhnCqvj6KH6 Create a script that writes out.txt using lami... None None 2026-08-07 14:15:22.720845+00:00 2026-08-07 14:16:43.407401+00:00 None {'n_steps': 9, 'n_tokens': 1288, 'n_tool_calls... None None ... 2026-08-07 14:15:22.720845+00:00 692 692 1 1587 29368.0 NaN None 46 None
12750 5ZAqYsZANHY0Cd47 None None check 2026-08-07 13:33:57.707899+00:00 2026-08-07 13:34:03.010451+00:00 {'no_run': False, 'script': 'tests/profiling/i... None None None ... 2026-08-07 13:33:57.707899+00:00 1 1 1 1413 29367.0 29364.0 None 18 None

7 rows × 22 columns

Schema
uid name description n_members coerce flexible itype otype suffix hash ... maximal_set is_locked is_type created_at branch_id created_on_id space_id created_by_id run_id type_id
id
230 hBZ6T9dH1spniqTU var of CELLxGENE None 2.0 True False Feature None None HG5TWQKcIRJ7wwgAXb_zVA ... False False False 2026-08-06 04:39:31.839293+00:00 1 1 1 60 12577.0 NaN
229 9XzDRtiCEcGq1ASF Codex collection schema 2026-07-29 Schema-backed collection fixture for pre- and ... NaN None None Feature None None None ... False False False 2026-07-29 22:28:45.301295+00:00 1 1 1 20 NaN NaN
228 ewcDZIuEfjxvwe0n None None 9.0 None False Feature None None T6KP2dke3yeLrB8uD_rztA ... False False False 2026-07-20 08:29:14.051358+00:00 1 1 1 2 NaN NaN
227 2fNxDBqwRBerwLaX nextflow_testing_metadata None 1.0 None False Feature None None ofbW8htIOfXswgaWACJnsg ... False False False 2026-07-09 14:44:11.589444+00:00 3 3 1 46 NaN NaN
226 99I0W7xRRYOGX0jR ATAC-seq experiment None 2.0 None False Feature None None None ... False False False 2026-07-09 12:45:47.715575+00:00 1 1 1 2 NaN NaN
225 JheDwMyQkrGILG4I bench-schema-with-index None 5.0 None False Feature None None sYqCRMyiEUgH8C4nbGBjMQ ... False False False 2026-06-29 10:00:38.003432+00:00 1 1 1 60 9802.0 NaN
224 Nx6l4qn3T6PHC7Vq test-import-records-from-dataframe-2026-06-24-... None 4.0 None False Feature DataFrame None 0I9w16NyUBwm4Sx9i3bMyg ... False False False 2026-06-24 05:51:27.542800+00:00 1 1 1 60 9601.0 190.0

7 rows × 22 columns

Storage
uid root description type region instance_uid is_locked created_at branch_id created_on_id space_id created_by_id run_id
id
64 BN5hkmpQV3A5 s3://cellxgene-census-public-us-west-2 None s3 us-west-2 None False 2026-08-05 13:06:18.181461+00:00 1 1 1 60 12513.0
63 ytKACRVv0kZX s3://ngi-igenomes None s3 eu-west-1 None False 2026-07-23 07:40:47.354980+00:00 1 1 1 54 NaN
62 VHK54QHjGJwM https://ftp.ensembl.org None https None None False 2026-07-23 07:03:08.272550+00:00 1 1 1 54 NaN
61 pkcs4jm2RZI6 s3://nf-lamin-test/scratch None s3 us-east-1 7clAMMtTbqlK False 2026-07-22 14:25:32.981609+00:00 1 1 1 54 NaN
60 oiIXpnEdjflJ https://static-content.springer.com None https None None False 2026-07-09 13:38:48.347870+00:00 1 1 1 18 NaN
59 xz61M0QVM1uI s3://openproblems-data None s3 us-west-2 None False 2026-05-21 08:57:21.367940+00:00 1 1 1 54 NaN
54 yL17nYM0lRZf s3://lamin-us-west-2/yL17nYM0lRZf None s3 us-west-2 1AjDxIR2ZphW False 2025-04-25 08:32:54.953891+00:00 1 1 1 46 6661.0
Transform
uid key description kind source_code hash reference reference_type version_tag is_latest is_locked created_at branch_id created_on_id space_id environment_id plan_id run_id created_by_id
id
1725 Rrq1bb328HH40003 pypackages/cellxgene_lamin/_register_annotate_... CLI: __main__.py script from __future__ import annotations\n\nfrom typ... sgtaL73UrK-0S2-YPeHdpQ https://github.com/laminlabs/cellxgene-lamin/b... url None True False 2026-08-07 10:13:42.268207+00:00 1 1 1 None None NaN 60
1724 cocUsNscN4Sh0000 print_even_numbers.py None script import lamindb as ln\n\nln.track()\n\nfor i in... u6zVuGAeMJyLghyEnNM5AA None None None True False 2026-08-07 07:58:51.921097+00:00 692 692 1 None None 12671.0 46
1723 Bxu3XHQ05sNC0000 add_two_numbers.py None script import lamindb as ln\n\nln.track()\nresult = 2... VH2KgmiXJi41hHwWwH8J_w None None None True False 2026-08-07 07:42:39.173824+00:00 692 692 1 None None 12669.0 46
1722 OEXJ2naal9Mn0000 add_two_and_four.py None script import lamindb as ln\n\nln.track()\nprint(2 + ... bbnd3arheo3DfBi-P6-J8w None None None True False 2026-08-07 06:55:41.399793+00:00 692 692 1 None None 12664.0 46
1721 DUgYDaWxrtq40000 compute_even_squares.py None script import lamindb as ln\nfrom pathlib import Path... fRia3irebFA3IHnQRSg4BQ None None None True False 2026-08-06 16:33:47.333928+00:00 1 1 1 None None 12638.0 76
1720 eyCJLghJIZT50000 fib20_lamindb.py None script import json\nfrom pathlib import Path\n\nimpor... O0-WIhE85gvx_qyMe-dt7A None None None True False 2026-08-06 16:33:18.216337+00:00 1 1 1 None None 12638.0 76
1719 fEKdrxQaqRFa0000 add_two.py None script import lamindb as ln\n\nln.track()\nprint(2 + ... EawTcZXXf3ic7a1a2bRbww None None None True False 2026-08-06 16:30:55.156586+00:00 692 692 1 None None NaN 46
ULabel
uid name description reference reference_type is_locked is_type created_at branch_id created_on_id space_id created_by_id run_id type_id
id
724 02s2gjBa pre-release None None None False False 2026-08-04 05:50:31.312297+00:00 1 1 1 60 12370.0 NaN
723 7u4RNLEC cell line From CellxGene schema. None None False False 2026-08-04 05:33:43.052215+00:00 1 1 1 60 12364.0 294.0
722 Du8zYde3 primary cell culture From CellxGene schema. None None False False 2026-08-04 05:33:42.712443+00:00 1 1 1 60 12364.0 294.0
721 1N1zBuG9 organoid From CellxGene schema. None None False False 2026-08-04 05:33:42.381189+00:00 1 1 1 60 12364.0 294.0
432 Wsg6AaGs github_hosted None None None False False 2026-06-19 09:27:43.755013+00:00 1 1 1 9 NaN 431.0
431 ljbGg49g RunnerEnvs None None None False True 2026-06-19 09:25:56.560324+00:00 1 1 1 9 NaN NaN
430 2SOng39r ILLUMINA None None None False False 2026-05-05 12:33:17.438691+00:00 1 1 1 2 NaN 429.0
! skipping module 'pertdb': 'pertdb' wasn't configured in this environment -- run: lamin settings modules set pertdb
If your database instance also doesn't have it, go to your instance settings page and add it under 'schema modules' (or ask an admin to do so).
******************
* module: bionty *
******************
CellLine
uid name ontology_id abbr synonyms description is_locked created_at branch_id created_on_id space_id created_by_id run_id source_id
id
250 2rD83IhFD8zXmX immortal uterine cervix-derived epithelial cel... CLO:0000283 None None An immortal epithelial cell line cell that der... False 2026-04-28 11:23:46.687389+00:00 1 1 1 46 7001.0 9
249 3mYHwNTcJYDLrt immortal epithelial cell line cell CLO:0000129 None None a immortal animal cell line that is derived fr... False 2026-04-28 11:23:46.687389+00:00 1 1 1 46 7001.0 9
248 45i0CvX67rIhVi immortal human uterine cervix-derived epitheli... CLO:0000636 None None An immortal uterine cervix-derived epithelial ... False 2026-04-28 11:23:45.353143+00:00 1 1 1 46 7001.0 9
247 4CdAW8HhaBZ3B5 HeLa cell CLO:0003684 None HeLa an immortal human uterine cervix-derived epith... False 2026-04-28 11:23:44.294879+00:00 1 1 1 46 7001.0 9
246 1n5kUkyJP7ekyJ immortal human blood cell line cell CLO:0000617 None None An immortal blood cell line cell that derives ... False 2025-01-08 13:33:33.047544+00:00 1 1 1 2 NaN 9
245 5TRtcD7edroFSw immortal blood cell line cell CLO:0000149 None immortal blood cell line a immortal hematopoietic cell line that is der... False 2025-01-08 13:33:33.047500+00:00 1 1 1 2 NaN 9
244 4HVCf9WcSdLlwt RCB0806 cell CLO:0050978 None RCB0806|Jurkat A immortal human blood cell line cell that has... False 2025-01-08 13:33:32.819503+00:00 1 1 1 2 NaN 9
CellMarker
uid abbr synonyms description name gene_symbol ncbi_gene_id uniprotkb_id is_locked created_at branch_id created_on_id space_id created_by_id run_id source_id organism_id
id
83 3ZFziy5ims8JUV None None None CD14/19 None None None False 2023-10-04 16:08:58.846323+00:00 1 1 1 2 None NaN 2
82 1iLDs6cZIpxjB6 None None CD69 CD69 969 Q07108 False 2023-10-04 16:08:40.134192+00:00 1 1 1 2 None 7.0 2
81 31nZfqQo8yZgeb None None CD103 ITGAE 3682 P38570 False 2023-10-04 16:08:40.134170+00:00 1 1 1 2 None 7.0 2
80 5c4A0r7gMiGwGk None None CD95 FAS 2194 P49327 False 2023-10-04 16:08:40.134151+00:00 1 1 1 2 None 7.0 2
79 3IPMBjs68Vy1oM None None CXCR4 CXCR4 7852 P61073 False 2023-10-04 16:08:40.134128+00:00 1 1 1 2 None 7.0 2
78 525YfNUB967zee None None CD49B ITGA2 3673 P17301 False 2023-10-04 16:08:40.134091+00:00 1 1 1 2 None 7.0 2
77 3l9bWDSZiukI6O None LIVE/DEAD None Dead None None None False 2023-07-26 13:25:18.219619+00:00 1 1 1 2 None NaN 2
CellType
uid name ontology_id abbr synonyms description is_locked created_at branch_id created_on_id space_id created_by_id run_id source_id
id
221 4zrSyDb4opmGJz neoplastic epithelial cell None None None None False 2026-04-14 08:59:53.779824+00:00 1 1 1 9 6113.0 NaN
220 23ekfCDhJCSN44 cancer associated fibroblast None None None None False 2026-04-14 08:59:53.779824+00:00 1 1 1 9 6113.0 NaN
219 3hXuCKYHIHOjiS perivascular cell CL:4033054 None None A Cell That Is Adjacent To A Vessel. A Perivas... False 2026-04-14 08:59:20.955797+00:00 1 1 1 9 6113.0 64.0
218 7KCFubjGu7ok8G iPSC-induced neuron None None None None False 2025-01-08 11:36:53.756884+00:00 1 1 1 2 NaN NaN
217 2nWjcXRrdqX5g0 lymphoblast CL:0017005 None None A Lymphocyte That Has Gotten Larger After Bein... False 2025-01-07 09:41:49.139648+00:00 1 1 1 2 NaN 65.0
216 4qnxelJpe0dakV retinal cell CL:0009004 None None Any Cell In The Retina, The Innermost Layer Or... False 2025-01-06 12:00:39.805850+00:00 1 1 1 2 NaN 65.0
215 1e5QBUmKJGM4e9 visual pigment cell CL:0000149 None None None False 2025-01-06 12:00:39.805825+00:00 1 1 1 2 NaN 65.0
DevelopmentalStage
uid name ontology_id abbr synonyms description is_locked created_at branch_id created_on_id space_id created_by_id run_id source_id
id
44 5HWRj1ODkb6V1S unknown unknown None None From CellxGene schema. False 2024-12-05 16:37:36.726755+00:00 1 1 1 3 385 NaN
43 7k1A0zkTfOLQo4 human life cycle stage HsapDv:0000000 None developmental stage A Spatiotemporal Region Encompassing Some Part... False 2024-12-05 16:37:35.999196+00:00 1 1 1 3 384 49.0
42 5q73MbS33MJVGx 85-year-old human stage HsapDv:0000211 None None Aged Stage That Refers To An Adult Who Is Over... False 2024-12-05 16:37:35.196938+00:00 1 1 1 3 384 49.0
41 5QzRYqqcaGITDU 84-year-old human stage HsapDv:0000210 None None Aged Stage That Refers To An Adult Who Is Over... False 2024-12-05 16:37:35.196920+00:00 1 1 1 3 384 49.0
40 3MeD86peox5beX 82-year-old human stage HsapDv:0000208 None None Aged Stage That Refers To An Adult Who Is Over... False 2024-12-05 16:37:35.196903+00:00 1 1 1 3 384 49.0
39 1FAjljBZPandRY 81-year-old human stage HsapDv:0000207 None None Aged Stage That Refers To An Adult Who Is Over... False 2024-12-05 16:37:35.196887+00:00 1 1 1 3 384 49.0
38 2nEVCZzoSi6YS2 80-year-old human stage HsapDv:0000206 None None Aged Stage That Refers To An Adult Who Is Over... False 2024-12-05 16:37:35.196869+00:00 1 1 1 3 384 49.0
Disease
uid name ontology_id abbr synonyms description is_locked created_at branch_id created_on_id space_id created_by_id run_id source_id
id
182 3lEY9l5KHXHvI6 precancerous condition MONDO:0021074 None precancerous condition|premalignant condition|... A Pathological Process With Signs Indicating I... False 2026-04-13 15:09:54.889610+00:00 1 1 1 9 6070 73
181 3UbujjzPMgLW9n breast ductal adenocarcinoma MONDO:0005590 None ductal carcinoma of breast|mammary duct adenoc... A Breast Carcinoma Arising From The Ducts. Whi... False 2026-04-13 15:09:54.889610+00:00 1 1 1 9 6070 73
180 1yX8SwADeAa956 breast carcinoma MONDO:0004989 None mammary carcinoma|carcinoma of the breast|brea... A Carcinoma That Arises From Epithelial Cells ... False 2026-04-13 15:09:54.889610+00:00 1 1 1 9 6070 73
179 5BMsSAHuNlNkVR breast adenocarcinoma MONDO:0004988 None adenocarcinoma of breast|adenocarcinoma of the... A Carcinoma That Arises From Glandular Epithel... False 2026-04-13 15:09:54.889610+00:00 1 1 1 9 6070 73
178 1vrnOyXFQ3Nd9W breast carcinoma in situ MONDO:0004658 None stage 0 carcinoma of breast|non-infiltrating b... A In Situ Carcinoma That Involves The Breast. False 2026-04-13 15:09:54.889610+00:00 1 1 1 9 6070 73
177 5y3Uc4S81tPlsw in situ carcinoma MONDO:0004647 None stage 0 disease|non-invasive carcinoma|epithel... A Malignant Epithelial Neoplasm Which Is Confi... False 2026-04-13 15:09:54.889610+00:00 1 1 1 9 6070 73
176 1jD296YK6NLFVu breast intraductal proliferative lesion MONDO:0004007 None ductal intraepithelial neoplasia|mammary intra... A Group Of Non-Invasive Epithelial Proliferati... False 2026-04-13 15:09:54.889610+00:00 1 1 1 9 6070 73
Ethnicity
uid name ontology_id abbr synonyms description is_locked created_at branch_id created_on_id space_id created_by_id run_id source_id
id
8 3N1q01iCP7hErP na na None None From CellxGene schema. False 2026-08-04 05:33:38.990134+00:00 1 1 1 60 12364 NaN
7 3FN797FUPWonJO British in England and Scotland (1KGP) HANCESTRO:0765 GBR None A population made up of 107 samples from Briti... False 2025-04-30 14:28:53.884654+00:00 1 1 1 2 638 NaN
6 3AZVW16yI1BsV5 African American or Afro-Caribbean HANCESTRO:0016 None None Includes Individuals Who Either Self-Report Or... False 2024-12-05 16:37:41.019432+00:00 1 1 1 3 384 51.0
5 67yD7yy4XCWOLA African American HANCESTRO:0568 None None None False 2024-12-05 16:37:40.220495+00:00 1 1 1 3 384 51.0
4 2dwBSQ1z0XEYfL Asian HANCESTRO:0008 None Asian unspecified Includes Individuals That Either Self-Report O... False 2024-12-05 16:37:40.220454+00:00 1 1 1 3 384 51.0
3 5HWRj1ODkb6V1S unknown unknown None None From CellxGene schema. False 2024-12-02 08:58:00.689681+00:00 1 1 1 30 361 NaN
2 6Tnv21SwDbUrL5 ancestry category HANCESTRO:0004 None ancestral group Population Category Defined Using Ancestry Inf... False 2024-06-05 12:09:31.274046+00:00 1 1 1 2 181 51.0
ExperimentalFactor
uid name ontology_id abbr synonyms description is_locked created_at branch_id created_on_id space_id created_by_id run_id source_id
id
59 3C8KLOGpZkHsC5 RNA-Seq EFO:0008896 None None Rna-Seq Is A Method That Involves Purifying Rn... False 2026-06-03 04:50:44.387535+00:00 1 1 1 60 None 104.0
58 3VAgTSkxVwvsyT Xenium Spatial Gene Expression None None Xenium|10X Xenium None False 2025-12-09 12:46:38.150561+00:00 1 1 1 40 None NaN
57 2UEkfRqukGb1oI TraCe-seq None None None None False 2025-01-08 12:43:38.479402+00:00 1 1 1 2 None NaN
56 2vzIZ5LkSh7rpi sci-RNA-seq EFO:0010550 None None The Sci-Rna-Seq Uses The Combinatorial Indexin... False 2025-01-08 08:58:19.611931+00:00 1 1 1 2 None 87.0
55 5jxLO4bDAyRVOV sci-Plex EFO:0030026 None None The Combination Of Nuclear Hashing And Sci-Rna... False 2025-01-08 08:58:19.142252+00:00 1 1 1 2 None 87.0
54 2ngGOY7rDGX2IE sequencer EFO:0003739 None None None False 2024-12-02 18:53:05.337572+00:00 1 1 1 2 None 83.0
53 1ImT882pIwABzY instrument EFO:0000548 None HardwareType|hardware An Instrument Is A Device Which Provides A Mec... False 2024-12-02 18:53:05.337209+00:00 1 1 1 2 None 83.0
Gene
uid abbr synonyms description symbol stable_id ensembl_gene_id ncbi_gene_ids biotype is_locked created_at branch_id created_on_id space_id created_by_id run_id source_id organism_id
id
154347 43PKjUN2TuRjeK None TMEM142A|CRACM1|FLJ14466 ORAI calcium release-activated calcium modulat... ORAI1 None ENSG00000293604 None protein_coding False 2025-10-26 14:38:48.560365+00:00 1 1 1 9 1260 55 2
154346 7hbNrFh6GVRtVn None novel protein None None ENSG00000293600 None protein_coding False 2025-10-26 14:38:48.560365+00:00 1 1 1 9 1260 55 2
154345 2DLKDsGV0zX96L None novel transcript None None ENSG00000293599 None lncRNA False 2025-10-26 14:38:48.560365+00:00 1 1 1 9 1260 55 2
154344 12nPu7ce9hLZ4k None long intergenic non-protein coding RNA 970 LINC00970 None ENSG00000293597 None lncRNA False 2025-10-26 14:38:48.560365+00:00 1 1 1 9 1260 55 2
154343 42lwxhgTHxaNKI None novel transcript None None ENSG00000293596 None lncRNA False 2025-10-26 14:38:48.560365+00:00 1 1 1 9 1260 55 2
154342 1cNzYeNWyn5iyY None FLJ40434 solute carrier family 25 member 3 pseudogene 1 SLC25A3P1 None ENSG00000293595 None lncRNA False 2025-10-26 14:38:48.560365+00:00 1 1 1 9 1260 55 2
154341 6uPvR6SwrQ0xlj None ribosomal protein L41 (RPL41) pseudogene None None ENSG00000293594 None processed_pseudogene False 2025-10-26 14:38:48.560365+00:00 1 1 1 9 1260 55 2
Organism
uid name ontology_id abbr synonyms description scientific_name is_locked created_at branch_id created_on_id space_id created_by_id run_id source_id
id
54 7bjJiyyCekRwmb zebra danio NCBITaxon:7955 None zebra fish|leopard danio|zebrafish None Danio rerio False 2026-08-04 05:46:52.938760+00:00 1 1 1 60 12368 36
53 7m3CRmaeekDkVx callithrix NCBITaxon:1965096 None None None Callithrix <subgenus> False 2026-08-04 05:43:01.417474+00:00 1 1 1 60 12367 36
52 3qUn9Zrd0XtCmC white-tufted-ear marmoset NCBITaxon:9483 None white ear-tufted marmoset|common marmoset None Callithrix jacchus False 2026-08-04 05:42:47.582424+00:00 1 1 1 60 12367 36
51 3PVIOuei7zIhdo apes NCBITaxon:314295 None ape None Hominoidea False 2026-08-04 05:42:35.762334+00:00 1 1 1 60 12367 36
50 12laiQ02YZOUpR great apes NCBITaxon:9604 None None None Hominidae False 2026-08-04 05:42:35.762334+00:00 1 1 1 60 12367 36
49 6yRA7MaNmfnZHP homininae NCBITaxon:207598 None None None Homininae False 2026-08-04 05:42:35.762334+00:00 1 1 1 60 12367 36
48 7I2BNel8LGSlFQ chimpanzees NCBITaxon:9596 None None None Pan False 2026-08-04 05:42:23.879737+00:00 1 1 1 60 12367 36
Phenotype
uid name ontology_id abbr synonyms description is_locked created_at branch_id created_on_id space_id created_by_id run_id source_id
id
3 5HWRj1ODkb6V1S unknown unknown None None From CellxGene schema. False 2024-12-20 13:27:12.909577+00:00 1 1 1 2 405 NaN
2 3OV8JZsSny1UQm female PATO:0000383 None None A Biological Sex Quality Inhering In An Indivi... False 2024-06-05 12:09:14.248434+00:00 1 1 1 2 181 48.0
1 kniZxLLf63zsQC male PATO:0000384 None None A Biological Sex Quality Inhering In An Indivi... False 2024-06-05 12:09:13.824774+00:00 1 1 1 2 181 48.0
Protein
uid abbr synonyms description name uniprotkb_id length gene_symbol ensembl_gene_ids is_locked created_at branch_id created_on_id space_id created_by_id run_id source_id organism_id
id
239 231ffq2p4OKIZB None None None VEGF None None None None False 2024-12-13 23:13:13.448561+00:00 1 1 1 9 392 None 2
238 DdtaoUouGdlIFF None None None TSLP None None None None False 2024-12-13 23:13:13.448541+00:00 1 1 1 9 392 None 2
237 2eU4TKDBtwKeND None None None TRAIL None None None None False 2024-12-13 23:13:13.448521+00:00 1 1 1 9 392 None 2
236 5VKVwilvkbLjJ1 None None None TL1A None None None None False 2024-12-13 23:13:13.448499+00:00 1 1 1 9 392 None 2
235 56Q2NU5LlFbQox None None None TGF-beta1 None None None None False 2024-12-13 23:13:13.448478+00:00 1 1 1 9 392 None 2
234 5yxiGKssUC6HCQ None None None PSPN None None None None False 2024-12-13 23:13:13.448458+00:00 1 1 1 9 392 None 2
233 3WgMz3uEzIODQW None None None PBS None None None None False 2024-12-13 23:13:13.448437+00:00 1 1 1 9 392 None 2
Source
uid entity organism name version in_db currently_used description url md5 source_website is_locked created_at branch_id created_on_id space_id created_by_id run_id dataframe_artifact_id
id
105 64RRxCHm bionty.Gene mouse ensembl release-102 False False Ensembl None None None False 2025-04-23 16:17:01.389481+00:00 1 1 1 2 None 1515.0
104 2a1HvjdB bionty.ExperimentalFactor all efo 3.70.0 False True The Experimental Factor Ontology http://www.ebi.ac.uk/efo/releases/v3.70.0/efo.owl https://bioportal.bioontology.org/ontologies/EFO False 2024-12-30 09:11:45.927266+00:00 1 1 1 2 None NaN
103 YXoI7R9t wetlab.Compound all chebi 2024-07-27 True True Chemical Entities of Biological Interest s3://bionty-assets/df_all__chebi__2024-07-27__... None https://www.ebi.ac.uk/chebi/ False 2024-12-20 13:05:00.664713+00:00 1 1 1 2 None 1144.0
102 10va5JSt bionty.DevelopmentalStage mouse mmusdv 2024-05-28 False True Mouse Developmental Stages https://github.com/obophenotype/developmental-... https://github.com/obophenotype/developmental-... False 2024-09-25 11:44:53.469647+00:00 1 1 1 6 None NaN
101 1GbFkOdz bionty.DevelopmentalStage human hsapdv 2024-05-28 False True Human Developmental Stages https://github.com/obophenotype/developmental-... https://github.com/obophenotype/developmental-... False 2024-09-25 11:44:52.894826+00:00 1 1 1 6 None NaN
100 1atB0WnU Drug all chebi 2024-07-27 False False Chemical Entities of Biological Interest s3://bionty-assets/df_all__chebi__2024-07-27__... https://www.ebi.ac.uk/chebi/ False 2024-09-25 11:44:52.685270+00:00 1 1 1 6 None NaN
99 5alKEOMB Drug all dron 2024-03-02 False False Drug Ontology https://data.bioontology.org/ontologies/DRON/s... 84138459de4f65034e979f4e46783747 https://bioportal.bioontology.org/ontologies/DRON False 2024-09-25 11:44:52.151655+00:00 1 1 1 6 None NaN
Tissue
uid name ontology_id abbr synonyms description is_locked created_at branch_id created_on_id space_id created_by_id run_id source_id
id
127 4QeoxdKp9KxQM8 body proper UBERON:0013702 None None The Region Of The Organism Associated With The... False 2025-03-20 22:20:26.347506+00:00 1 1 1 35 536 68
126 3XuRxEhwtpvdlX main body axis UBERON:0013701 None None A Principle Subdivision Of An Organism That In... False 2025-03-20 22:20:26.347506+00:00 1 1 1 35 536 68
125 7ZCdHnvNOjjv2F subdivision of organism along main body axis UBERON:0011676 None axial subdivision of organism A Major Subdivision Of An Organism That Divide... False 2025-03-20 22:20:26.347506+00:00 1 1 1 35 536 68
124 31GPuSXPc7Z4Tz subdivision of trunk UBERON:0009569 None trunk subdivision|region of trunk None False 2025-03-20 22:20:26.347506+00:00 1 1 1 35 536 68
123 7MjYxh4jwppeOe trunk UBERON:0002100 None thoracolumbar region|trunk region|torso Organism Subdivision Which Is The Part Of The ... False 2025-03-20 22:20:26.347506+00:00 1 1 1 35 536 68
122 1boGOeV9Xx1pmN multicellular organism UBERON:0000468 None multi-cellular organism Anatomical Structure That Is An Individual Mem... False 2025-03-20 22:20:26.347506+00:00 1 1 1 35 536 68
121 51UEcfPxUr9DU7 chest UBERON:0001443 None pectus|ventral part of thoracic region|front o... Subdivision Of Trunk Proper, Which Is Demarcat... False 2025-03-20 22:20:24.962147+00:00 1 1 1 35 536 68

Get one object¶

get() errors if it doesn’t find exactly one matching object:

db.Record.get("HhKWgzjVW6cfnVep")  # by uid
db.Record.get(name="EXP-RNA-001")  # by field, here the name field
Show code cell output Hide code cell output
Record(uid='HhKWgzjVW6cfnVep', is_type=False, name='EXP-RNA-001', description=None, reference=None, reference_type=None, extra_data=None, branch_id=1, created_on_id=1, space_id=1, created_by_id=2, type_id=15982, schema_id=None, run_id=None, created_at=2026-05-04 13:46:47 UTC, is_locked=False)

Search¶

You can search every registry via search(). For example, the Artifact registry:

db.Artifact.search("iris").to_dataframe()
Show code cell output Hide code cell output
uid key description suffix kind otype size hash n_files n_observations ... is_latest is_locked created_at branch_id created_on_id space_id storage_id run_id schema_id created_by_id
id
744 KIkHQdyHQVQO1KrXtVKA None Iris study 1 - after measuring sepal & petal m... .parquet None DataFrame 5347 ZVkGt2eQubiGc79aOcRfVQ NaN None ... True False 2024-06-06 11:13:05.179131+00:00 1 1 1 2 206.0 None 2
684 BWL7PYFvsZ8jA8YJOCz6 iris_studies/study2_raw_images None None None 667449 BfyPwSCYPaHRKe4bJk7yRw 51.0 None ... True False 2024-05-23 16:10:13.895052+00:00 1 1 1 2 173.0 None 9
682 K415DrXcuPiJmXlX5iXH iris_studies/study0_raw_images None None None 658465 IVKGMfNwi8zKvnpaD_gG7w 51.0 None ... False False 2024-05-23 16:10:13.393304+00:00 1 1 1 2 173.0 None 9
683 2r8SFCH8TlydF0xnb0Uk iris_studies/study1_raw_images None None None 642480 Iip0GzbvjACYC2O7ZrtZiQ 49.0 None ... True False 2024-05-23 16:10:13.728116+00:00 1 1 1 2 173.0 None 9
25855 K415DrXcuPiJmXlX5iXI iris_studies/study0_raw_images None None None 658486 tt98Ho0i3BlFtV84BlI6Dw 52.0 None ... True False 2026-07-07 12:24:59.162462+00:00 1 1 1 2 NaN None 46
23857 r9b1iRIs7xuCzk7j0000 None log streams of run vaRP1uN7dBA9to9O .txt __lamindb_run__ None 15497 UybnX6pkLA-3kkdZLAMbow NaN None ... True False 2026-06-05 14:38:59.819115+00:00 1 1 1 2 NaN None 18
26631 qGXvU8SFFsQclgR10000 Uploads/iris-0337d20a3b7273aa0ddaa7d6afb57a37a... None .jpg None None 14529 e0Gct8LodEyQzNwy1glOPA NaN None ... True False 2026-07-14 14:51:33.166215+00:00 1 1 1 2 NaN None 46
17799 ZIMVu6cUu2nkyXuK0000 None log streams of run Xk1i2GFNykkkijDj .txt __lamindb_run__ None 12430 GIRIs96TiSR4dAp4XC5hZA NaN None ... True False 2026-03-20 16:42:05.673008+00:00 1 1 1 2 NaN None 18

8 rows × 22 columns

Here is more background on search and examples for searching the cell type registry: How does search work?

Auto-completing can also be a good way of finding an object:

records = db.Record.lookup()
experiment_1 = records.exp_rna_001  # assuming a record named 'EXP-RNA-001' exists
experiment_1
Show code cell output Hide code cell output
Record(uid='HhKWgzjVW6cfnVep', is_type=False, name='EXP-RNA-001', description=None, reference=None, reference_type=None, extra_data=None, branch_id=1, created_on_id=1, space_id=1, created_by_id=2, type_id=15982, schema_id=None, run_id=None, created_at=2026-05-04 13:46:47 UTC, is_locked=False)

This works for any BaseSQLRecord class, e.g., also for plugin bionty:

cell_types = db.bionty.CellType.lookup()

Queries¶

By fields¶

Use filter() to query artifacts by fields, e.g., by suffix:

qs = db.Artifact.filter(suffix=".csv")
qs
Show code cell output Hide code cell output
<ArtifactQuerySet [Artifact(uid='TxO5CS0h77it3cEl0001', key='nf-core/scrnaseq/samplesheet-2-0.csv', description=None, suffix='.csv', kind='dataset', otype='DataFrame', size=850, hash='6NgnIPdAYcwCDbcikid6ZQ', n_files=None, n_observations=3, extra_data=None, branch_id=1, created_on_id=1, space_id=1, storage_id=2, run_id=None, schema_id=139, created_by_id=2, created_at=2025-04-24 15:09:40 UTC, is_locked=False, version_tag=None, is_latest=True), Artifact(uid='qCEizASjJg7lfbDO0000', key=None, description='CSV upload test efba5645', suffix='.csv', kind=None, otype='DataFrame', size=40, hash='du-FuXzpOCU4K0RlIEmuBw', n_files=None, n_observations=None, extra_data=None, branch_id=1, created_on_id=1, space_id=1, storage_id=2, run_id=6838, schema_id=None, created_by_id=18, created_at=2026-04-25 05:45:13 UTC, is_locked=False, version_tag=None, is_latest=True), Artifact(uid='k2mo3InmZviAFBQL0000', key='forms/test_form_fred.csv', description=None, suffix='.csv', kind='dataset', otype='DataFrame', size=812, hash='XARxkaA_Xhcs5yNjlsdWTQ', n_files=None, n_observations=3, extra_data=None, branch_id=1, created_on_id=1, space_id=1, storage_id=2, run_id=None, schema_id=133, created_by_id=24, created_at=2025-04-30 09:24:17 UTC, is_locked=False, version_tag=None, is_latest=True), Artifact(uid='ZRaZhr4HO0ghFVfk0000', key='forms/test_form_sunny.csv', description=None, suffix='.csv', kind='dataset', otype='DataFrame', size=829, hash='y7GGkIq-Pz3U37HLHoBKTA', n_files=None, n_observations=3, extra_data=None, branch_id=1, created_on_id=1, space_id=1, storage_id=2, run_id=None, schema_id=133, created_by_id=2, created_at=2025-04-30 11:44:13 UTC, is_locked=False, version_tag=None, is_latest=True), Artifact(uid='MDG7BbeFVPvEyyUb0000', key='schmidt22/raw-data/gws-crispr-ifng-readout.csv', description='CRIPSRa GWS IFNG readout 2023-08-25', suffix='.csv', kind=None, otype=None, size=1729694, hash='WhvwTUnFe29PopBqMp5UkQ', n_files=None, n_observations=None, extra_data=None, branch_id=1, created_on_id=1, space_id=1, storage_id=2, run_id=None, schema_id=None, created_by_id=2, created_at=2024-12-03 12:14:50 UTC, is_locked=False, version_tag=None, is_latest=True), Artifact(uid='tNa9JwfjVo3n9peM0000', key=None, description='CSV upload test c1bf706e', suffix='.csv', kind=None, otype='DataFrame', size=40, hash='sjI9d7jzpuL5vn9f7Ey6pg', n_files=None, n_observations=None, extra_data=None, branch_id=1, created_on_id=1, space_id=1, storage_id=2, run_id=6746, schema_id=None, created_by_id=18, created_at=2026-04-23 12:07:52 UTC, is_locked=False, version_tag=None, is_latest=True), Artifact(uid='IGXNLaaBmuyU6wWN0000', key=None, description='CSV upload test 1cab37d3', suffix='.csv', kind=None, otype='DataFrame', size=40, hash='e4I1orzM1jhY6PjTEoH5kg', n_files=None, n_observations=None, extra_data=None, branch_id=1, created_on_id=1, space_id=1, storage_id=2, run_id=6745, schema_id=None, created_by_id=18, created_at=2026-04-23 12:08:01 UTC, is_locked=False, version_tag=None, is_latest=True), Artifact(uid='TxO5CS0h77it3cEl0000', key='nf-core/scrnaseq/samplesheet-2-0.csv', description='https://github.com/nf-core/test-datasets/raw/scrnaseq/samplesheet-2-0.csv', suffix='.csv', kind=None, otype=None, size=854, hash='WjKh69Ksaso2CkP0OO_c5Q', n_files=None, n_observations=None, extra_data=None, branch_id=1, created_on_id=1, space_id=1, storage_id=2, run_id=None, schema_id=133, created_by_id=2, created_at=2025-04-22 10:33:14 UTC, is_locked=False, version_tag=None, is_latest=False), Artifact(uid='6XT5pVhWB9hcTTmG0000', key='scrnaseq_input/samplesheet.csv', description=None, suffix='.csv', kind=None, otype=None, size=236, hash='QXMVrT5ZucmidIxbYJ9KHA', n_files=None, n_observations=None, extra_data=None, branch_id=1, created_on_id=1, space_id=1, storage_id=2, run_id=None, schema_id=None, created_by_id=6, created_at=2024-10-03 07:31:27 UTC, is_locked=False, version_tag=None, is_latest=True), Artifact(uid='QJoGe0ALyOcsvUcA0000', key='samples/xenium/2.0.0/Xenium_V1_humanLung_Cancer_FFPE/Xenium_V1_humanLung_Cancer_FFPE_he_imagealignment.csv', description=None, suffix='.csv', kind=None, otype=None, size=126, hash='LJ8xyu4DGqsDT8SEEnhxSw', n_files=None, n_observations=None, extra_data=None, branch_id=1, created_on_id=1, space_id=1, storage_id=23, run_id=488, schema_id=None, created_by_id=2, created_at=2025-02-07 12:53:34 UTC, is_locked=False, version_tag=None, is_latest=True), Artifact(uid='iXG6VILSb8kO8FlZ0000', key=None, description='CSV upload test e0593b52', suffix='.csv', kind=None, otype='DataFrame', size=41, hash='4wlxSR5lpONGfzfKCkqNqQ', n_files=None, n_observations=None, extra_data=None, branch_id=1, created_on_id=1, space_id=1, storage_id=2, run_id=6966, schema_id=None, created_by_id=54, created_at=2026-04-28 08:15:46 UTC, is_locked=False, version_tag=None, is_latest=True), Artifact(uid='QsiBofOFWbxN4QKP0000', key=None, description='CSV upload test bebff57f', suffix='.csv', kind=None, otype='DataFrame', size=40, hash='H1c7Sa71rrtzcysPQ-uyLA', n_files=None, n_observations=None, extra_data=None, branch_id=1, created_on_id=1, space_id=1, storage_id=2, run_id=6982, schema_id=None, created_by_id=18, created_at=2026-04-28 09:16:22 UTC, is_locked=False, version_tag=None, is_latest=True), Artifact(uid='t0SCjdlXN0WJ0ca70000', key=None, description='CSV upload test c935762b', suffix='.csv', kind=None, otype='DataFrame', size=40, hash='bu7DZpN8sAF2VPTR2YgCGw', n_files=None, n_observations=None, extra_data=None, branch_id=1, created_on_id=1, space_id=1, storage_id=2, run_id=6750, schema_id=None, created_by_id=18, created_at=2026-04-23 12:10:45 UTC, is_locked=False, version_tag=None, is_latest=True), Artifact(uid='2oQPB3QJaFPweBnm0000', key=None, description='CSV upload test 0bec62dd', suffix='.csv', kind=None, otype='DataFrame', size=40, hash='HQi3aiai4uDUdBycNxuieQ', n_files=None, n_observations=None, extra_data=None, branch_id=1, created_on_id=1, space_id=1, storage_id=2, run_id=6749, schema_id=None, created_by_id=18, created_at=2026-04-23 12:11:19 UTC, is_locked=False, version_tag=None, is_latest=True), Artifact(uid='yEBVbuzVacAuOIDz0000', key=None, description='CSV upload test 4da9cdd8', suffix='.csv', kind=None, otype='DataFrame', size=40, hash='kHDs0YWfjMyQuCmHw0hJ9A', n_files=None, n_observations=None, extra_data=None, branch_id=1, created_on_id=1, space_id=1, storage_id=2, run_id=6933, schema_id=None, created_by_id=18, created_at=2026-04-27 14:01:13 UTC, is_locked=False, version_tag=None, is_latest=True), Artifact(uid='RcQkAIDvCMZB79jh0000', key=None, description='CSV upload test 53feb2cc', suffix='.csv', kind=None, otype='DataFrame', size=41, hash='2UHYwIYKxKKRN18KlRA_Kw', n_files=None, n_observations=None, extra_data=None, branch_id=1, created_on_id=1, space_id=1, storage_id=2, run_id=6962, schema_id=None, created_by_id=54, created_at=2026-04-28 07:58:52 UTC, is_locked=False, version_tag=None, is_latest=True), Artifact(uid='QA6RSfviURVcnA5W0000', key='Uploads/PRLciWQorcA8CYW60001__2026-04-27T01-34-07-703Z.csv', description=None, suffix='.csv', kind=None, otype='DataFrame', size=318, hash='jFvIdsuthMcHBF3YGkcqvw', n_files=None, n_observations=None, extra_data=None, branch_id=1, created_on_id=1, space_id=1, storage_id=2, run_id=None, schema_id=None, created_by_id=20, created_at=2026-04-27 01:34:12 UTC, is_locked=False, version_tag=None, is_latest=True), Artifact(uid='uWcVCFwaj9ispTkA0000', key=None, description='CSV upload test 19f49eff', suffix='.csv', kind=None, otype='DataFrame', size=40, hash='0zZ3MjMHx8fs9iS8sthjhw', n_files=None, n_observations=None, extra_data=None, branch_id=1, created_on_id=1, space_id=1, storage_id=2, run_id=6932, schema_id=None, created_by_id=18, created_at=2026-04-27 14:01:20 UTC, is_locked=False, version_tag=None, is_latest=True), Artifact(uid='Tvy3d217OdeAcDqd0000', key=None, description='CSV upload test 264d4657', suffix='.csv', kind=None, otype='DataFrame', size=40, hash='qvXg1lA_D-tUwlL_RmexgA', n_files=None, n_observations=None, extra_data=None, branch_id=1, created_on_id=1, space_id=1, storage_id=2, run_id=6948, schema_id=None, created_by_id=18, created_at=2026-04-28 06:10:15 UTC, is_locked=False, version_tag=None, is_latest=True), Artifact(uid='eI8VZCpM9ajGCeiT0000', key='sheet_exports/Demo scRNA samples 2025-08.csv', description='Export of sheet 0LntuZaw3YUsNriI: ', suffix='.csv', kind='dataset', otype='DataFrame', size=241, hash='wZIzufKIrL-JRJg4FF4bfg', n_files=None, n_observations=2, extra_data=None, branch_id=1, created_on_id=1, space_id=1, storage_id=2, run_id=816, schema_id=160, created_by_id=2, created_at=2025-08-14 13:52:37 UTC, is_locked=False, version_tag=None, is_latest=True), '...(remaining elements truncated)...']>

This returns a QuerySet with the objects that match the filter. You can filter a queryset:

qs = qs.filter(records=experiment_1)  # filter to artifacts annotated with a record
qs.to_dataframe()
Show code cell output Hide code cell output
uid key description suffix kind otype size hash n_files n_observations ... is_latest is_locked created_at branch_id created_on_id space_id storage_id run_id schema_id created_by_id
id
21809 vZDmGqGUZRQovJ1c0000 sheet_exports/2026-05-05: RNA-seq samples.csv Export of sheet fphyKgWVQ8e3YiiF: Uploaded fro... .csv dataset DataFrame 1623 JMLW9LmuKWqNtrnXuGLXdQ None 7 ... True False 2026-05-05 16:38:04.973473+00:00 1 1 1 2 7406 132 2

1 rows × 22 columns

To access the results in a queryset:

  • to_dataframe(): A pandas DataFrame with each object in a row.

  • one(): Exactly one object. Will raise an error if there is none. Is equivalent to the .get() method shown above.

  • one_or_none(): Either one object or None if there is no query result.

You can also:

  • use the QuerySet as an iterator

  • get individual objects via qs[0], qs[1]

The SQLRecord classes (registries) in LaminDB are Django Models and any Django query works. Django has a double-under-score syntax to filter based on related tables. This syntax enables you to traverse several layers of relations and comparators.

For example, the following filter selects artifacts based on the users who ran the generating notebook. Under the hood, in the SQL database, it’s joining the artifact table with the user table.

db.Artifact.filter(created_by__handle__startswith="testuse").to_dataframe()
Show code cell output Hide code cell output
! truncated query result to limit=20 Artifact objects
uid key description suffix kind otype size hash n_files n_observations ... is_latest is_locked created_at branch_id created_on_id space_id storage_id run_id schema_id created_by_id
id
28571 wx0Y1Txx6TWXV83G0000 profile-submit/vTMSBjI45T4kkPtdxovK/star/mtx_c... Output artifact for run 12181 .rds None None 15558833 WVZ-CfG1aGQTZ36lGE1b2w None None ... True False 2026-08-03 04:52:58.273324+00:00 1 1 1 37 12181 None 18
28570 I7VXGbPYBXK7NwsR0000 profile-submit/vTMSBjI45T4kkPtdxovK/star/mtx_c... Output artifact for run 12181 .rds None None 15647698 wFV00SE1eHfC_tPC0G2ASg None None ... True False 2026-08-03 04:52:58.245177+00:00 1 1 1 37 12181 None 18
28569 8wrDnwFB9fd9FvVj0000 profile-submit/vTMSBjI45T4kkPtdxovK/star/mtx_c... Output artifact for run 12181 .rds None None 247006 aE3A7RMjhrpOeeuE-dBkHg None None ... True False 2026-08-03 04:51:27.823107+00:00 1 1 1 37 12181 None 18
28568 uv0Dp1MCzo3AKsHf0000 profile-submit/vTMSBjI45T4kkPtdxovK/star/mtx_c... Output artifact for run 12181 .rds None None 241260 zl5DXxY-oKXE5CJSUgif9g None None ... True False 2026-08-03 04:51:27.823342+00:00 1 1 1 37 12181 None 18
28566 grv1gDNXKDlcMu6e0000 profile-submit/nNIYDyCgntDCYlM9LA2G/star/mtx_c... Output artifact for run 12180 .rds None None 15558833 WVZ-CfG1aGQTZ36lGE1b2w None None ... True False 2026-08-03 04:51:08.237491+00:00 1 1 1 37 12180 None 18
28565 dq1tc0quQelnG4bl0000 profile-submit/nNIYDyCgntDCYlM9LA2G/star/mtx_c... Output artifact for run 12180 .rds None None 15647698 wFV00SE1eHfC_tPC0G2ASg None None ... True False 2026-08-03 04:51:08.219823+00:00 1 1 1 37 12180 None 18
28564 ZsMm2lR70Vp6kcWZ0000 profile-submit/nNIYDyCgntDCYlM9LA2G/star/mtx_c... Output artifact for run 12180 .rds None None 241260 zl5DXxY-oKXE5CJSUgif9g None None ... True False 2026-08-03 04:49:42.856567+00:00 1 1 1 37 12180 None 18
28563 QAwuHiMo5FOSWXO50000 profile-submit/nNIYDyCgntDCYlM9LA2G/star/mtx_c... Output artifact for run 12180 .rds None None 247006 aE3A7RMjhrpOeeuE-dBkHg None None ... True False 2026-08-03 04:49:37.648943+00:00 1 1 1 37 12180 None 18
28561 ApOZV9egcoFNxHAF0000 profile-submit/f3SRoG95CH2zacfrKlxD/star/mtx_c... Output artifact for run 12182 .rds None None 241172 s8VBjPPzHCkqZv3SVG6wIg None None ... True False 2026-08-03 04:49:25.951088+00:00 1 1 1 37 12182 None 18
28560 rttfSewCR2M3Qb020000 profile-submit/f3SRoG95CH2zacfrKlxD/star/mtx_c... Output artifact for run 12182 .rds None None 247005 iykSswvk3CYk-VfJ_mC_og None None ... True False 2026-08-03 04:49:25.937788+00:00 1 1 1 37 12182 None 18
28559 bWGJmR5q1TslsHih0000 profile-submit/f3SRoG95CH2zacfrKlxD/star/mtx_c... Output artifact for run 12182 .rds None None 15558833 WVZ-CfG1aGQTZ36lGE1b2w None None ... True False 2026-08-03 04:49:06.478341+00:00 1 1 1 37 12182 None 18
28558 HlIo4lt21s8OoUce0000 profile-submit/f3SRoG95CH2zacfrKlxD/star/mtx_c... Output artifact for run 12182 .rds None None 15647698 wFV00SE1eHfC_tPC0G2ASg None None ... True False 2026-08-03 04:49:06.478724+00:00 1 1 1 37 12182 None 18
28557 5V1NZi6JS75SC8iL0000 profile-submit/vTMSBjI45T4kkPtdxovK/star/mtx_c... Output artifact for run 12181 .h5ad None AnnData 114099984 SnuMvX6hlzvF0TM29OrcQg None None ... True False 2026-08-03 04:47:38.244697+00:00 1 1 1 37 12181 None 18
28555 Lclppakdaxvco1Yt0000 profile-submit/vTMSBjI45T4kkPtdxovK/star/mtx_c... Output artifact for run 12181 .h5ad None AnnData 1262512 oCRvreOC64KXnfeUsP1llg None None ... True False 2026-08-03 04:47:17.904476+00:00 1 1 1 37 12181 None 18
28553 HbC9rLR623ATowPV0000 profile-submit/vTMSBjI45T4kkPtdxovK/star/mtx_c... Output artifact for run 12181 .rds None None 7418438 0wODF4VDxCX6xnV-YPW0xQ None None ... True False 2026-08-03 04:46:48.250422+00:00 1 1 1 37 12181 None 18
28552 tBZezIPdoouEhtEN0000 profile-submit/vTMSBjI45T4kkPtdxovK/star/mtx_c... Output artifact for run 12181 .rds None None 7376591 _AMnH1dA1KgqM7Y3dMMU9Q None None ... True False 2026-08-03 04:46:48.163325+00:00 1 1 1 37 12181 None 18
28551 enF2nQMNXMpkiIWK0000 profile-submit/vTMSBjI45T4kkPtdxovK/star/mtx_c... Output artifact for run 12181 .rds None None 7426758 HjZvqMKuAOkdxbH1EBQUzg None None ... True False 2026-08-03 04:45:48.077355+00:00 1 1 1 37 12181 None 18
28550 H9ZhPxpJtj000CC40000 profile-submit/vTMSBjI45T4kkPtdxovK/star/mtx_c... Output artifact for run 12181 .rds None None 7381161 2Xl4jub_MVx0PSy0T2uCyg None None ... True False 2026-08-03 04:45:48.062513+00:00 1 1 1 37 12181 None 18
28549 Lpa58SCKjXWAQBFs0000 profile-submit/vTMSBjI45T4kkPtdxovK/star/mtx_c... Output artifact for run 12181 .rds None None 136669 SNKuZbACG4NKsfi9K9aDmQ None None ... True False 2026-08-03 04:44:57.776729+00:00 1 1 1 37 12181 None 18
28548 wWnkK96YILTeZ4u70000 profile-submit/vTMSBjI45T4kkPtdxovK/star/mtx_c... Output artifact for run 12181 .rds None None 145506 0bRJDtUbpL--XZJel_Pssg None None ... True False 2026-08-03 04:44:57.774182+00:00 1 1 1 37 12181 None 18

20 rows × 22 columns

Another example would be querying datasets that measure a particular feature. For instance, which datasets measure expression of CD8A:

cd8a = db.bionty.Gene.get(symbol="CD8A")
# query for all schemas that contain CD8A
schemas_with_cd8a = db.Schema.filter(genes=cd8a)
# get all artifacts
db.Artifact.filter(schemas__in=schemas_with_cd8a).to_dataframe()
Show code cell output Hide code cell output
! truncated query result to limit=20 Artifact objects
uid key description suffix kind otype size hash n_files n_observations ... is_latest is_locked created_at branch_id created_on_id space_id storage_id run_id schema_id created_by_id
id
19678 myXXk4pUIgu7jPz00001 sample_datasets/xenium1_curated_breast_carcino... None .zarr dataset SpatialData 35116259 CGIUfJc1GcpISZbTS9Ph7A 148.0 NaN ... True False 2026-04-14 09:00:18.158778+00:00 1 1 1 2 6113.0 198.0 9
12372 ERCIUR3bgOOy6uxK0000 examples/dataset2.h5ad None .h5ad dataset AnnData 26896 RKJjWbINYNIwYU8BxCejMw NaN 3.0 ... True False 2025-11-20 11:04:08.172526+00:00 1 1 1 2 NaN 151.0 6
11833 9K1dteZ6Qx0EXK8g0000 example_datasets/mini_immuno/dataset1.h5ad Flow cytometry readouts on invitro cell culture .h5ad dataset AnnData 31672 FB3CeMjmg1ivN6HDy6wsSg NaN 3.0 ... True False 2025-07-29 12:27:25.572900+00:00 1 1 1 2 791.0 151.0 9
1132 AHIfMnXepm6KaEaH0000 scrna/Parse_10M_PBMC_cytokines_curated.tiledbsoma None .tiledbsoma None tiledbsoma 38222071364 snBmwsareebO03_9NPvY_w 1053.0 9697974.0 ... True False 2024-12-16 22:39:02.039538+00:00 1 1 1 2 401.0 NaN 9
1117 xepHn6ScXGs5s1Te0001 example_datasets/small_dataset1.tiledbsoma None .tiledbsoma None tiledbsoma 19853 xkq9-kEUEChvxq-89_aJ7Q 57.0 3.0 ... True False 2024-12-16 09:13:47.043028+00:00 1 1 1 2 394.0 NaN 9
1116 mKo82UispVElpGtP0002 example_datasets/small_dataset1.h5ad None .h5ad dataset AnnData 25088 YMNwVfQZ78zwkB4shAQMfQ NaN 3.0 ... True False 2024-12-16 09:13:19.877258+00:00 1 1 1 2 394.0 NaN 9
1096 LmlgCMQRhSEHtcbG0000 census_immune_cells.tiledbsoma tiledbsoma experiment for Immune cells .tiledbsoma None tiledbsoma 1268083316 Rug1115Hhc44XG_OvdICRw 442.0 73047.0 ... True False 2024-12-05 19:14:39.282533+00:00 1 1 1 2 384.0 NaN 3
1090 NiaMP8YQMbmkdOgnAa1T cell-census/2024-07-01/h5ads/f64e1be1-de15-4d2... Immune cells .h5ad dataset AnnData 2854344210 3oh1Yk3fZPQMCuJWbhZ4zQ NaN 73047.0 ... True False 2024-12-05 16:37:13.463549+00:00 1 1 1 16 385.0 NaN 3
1082 lNBsZ6Zd02kteKnK0000 schmidt22/summary_anndata.h5ad analyzed anndata of schmidt22 perturbseq .h5ad dataset AnnData 20674389 hIIpdQq3gbqt5FJs0KtwEA NaN 853.0 ... True False 2024-12-04 12:51:18.725509+00:00 1 1 1 2 378.0 NaN 2
1071 xepHn6ScXGs5s1Te0000 example_datasets/small_dataset1.tiledbsoma None .tiledbsoma None tiledbsoma 18662 xFKN6Uzvhz-OXOEr9HmPKQ 53.0 3.0 ... False False 2024-12-03 14:05:19.776525+00:00 1 1 1 2 373.0 NaN 3
1070 mKo82UispVElpGtP0001 example_datasets/small_dataset1.h5ad None .h5ad dataset AnnData 25648 eJnHmQZgRQbUMkij-ziqeA NaN 3.0 ... False False 2024-12-03 14:04:47.882577+00:00 1 1 1 2 373.0 NaN 3
1045 7dVluLROpalzEh8mNyxk cell-census/2023-12-15/h5ads/02faf712-92d4-458... Renal cell carcinoma, pre aPD1, kidney Puck_20... .h5ad None AnnData 13997860 YNYuokfAoDFxdaRILjmU9w NaN 17612.0 ... True False 2024-12-02 08:57:19.308058+00:00 1 1 1 16 361.0 NaN 30
1010 dP0F1fEQWtorhDaI0000 example_datasets/small_dataset2.h5ad None .h5ad dataset AnnData 21224 7ok_2cIe73owydEGaj7m0A NaN 3.0 ... True False 2024-11-25 14:59:38.945319+00:00 1 1 1 2 302.0 NaN 9
1009 mKo82UispVElpGtP0000 example_datasets/small_dataset1.h5ad None .h5ad dataset AnnData 23352 NYni1vTRM7pqfle8ufPZwQ NaN 3.0 ... False False 2024-11-25 14:59:09.484279+00:00 1 1 1 2 302.0 NaN 9
938 3TNCsZZcnIBv2WGb0001 None 10x reference adata, trusted cell type annotation .h5ad dataset AnnData 851664 iETHP3Lw-tVqZxYAuEC-SA NaN 70.0 ... True False 2024-10-18 21:46:55.467982+00:00 1 1 1 2 305.0 NaN 9
937 3TNCsZZcnIBv2WGb0000 None 10x reference adata .h5ad dataset AnnData 859840 MAjl6lrjrcjqhUUA0ixMKA NaN 70.0 ... False False 2024-10-18 21:45:46.636210+00:00 1 1 1 2 305.0 NaN 9
750 PrHBuKLflU03CeI2xNPJ None 10x reference adata .h5ad None AnnData 857752 c9ukVXVfpdaH2BWaqBfK4g NaN 70.0 ... True False 2024-06-26 10:00:08.928727+00:00 1 1 1 2 209.0 NaN 2
725 CFcQxNjzSRzWZrVhBk65 None Kuppe 2022, ATAC .anndata.zarr None AnnData 2883707589 cqrk4idQ_WGjTe6KBrIKgg 2799.0 NaN ... True False 2024-06-05 10:21:25.684256+00:00 1 1 1 2 181.0 NaN 2
708 ytL7CXi5peqhfSPNSFVG None Kuppe 2022, RNA .anndata.zarr None AnnData 3107878597 tMzcoJ_1iz4Zsdvr-sjt6A 3380.0 NaN ... True False 2024-06-26 10:00:29.405916+00:00 1 1 1 2 181.0 NaN 2
706 psrHlYkmysrxtAL3RBTo None Kuppe 2022, Visium adata .anndata.zarr None AnnData 65107609 WN5GxCkcKeO5UElDZ2IA0A 206.0 NaN ... True False 2024-06-04 12:33:00.419035+00:00 1 1 1 2 181.0 NaN 2

20 rows × 22 columns

Instead of splitting this across three queries, the double-underscore syntax allows you to define a path for one query:

db.Artifact.filter(schemas__genes__symbol="CD8A").to_dataframe()
Show code cell output Hide code cell output
! truncated query result to limit=20 Artifact objects
uid key description suffix kind otype size hash n_files n_observations ... is_latest is_locked created_at branch_id created_on_id space_id storage_id run_id schema_id created_by_id
id
19678 myXXk4pUIgu7jPz00001 sample_datasets/xenium1_curated_breast_carcino... None .zarr dataset SpatialData 35116259 CGIUfJc1GcpISZbTS9Ph7A 148.0 NaN ... True False 2026-04-14 09:00:18.158778+00:00 1 1 1 2 6113.0 198.0 9
12372 ERCIUR3bgOOy6uxK0000 examples/dataset2.h5ad None .h5ad dataset AnnData 26896 RKJjWbINYNIwYU8BxCejMw NaN 3.0 ... True False 2025-11-20 11:04:08.172526+00:00 1 1 1 2 NaN 151.0 6
11833 9K1dteZ6Qx0EXK8g0000 example_datasets/mini_immuno/dataset1.h5ad Flow cytometry readouts on invitro cell culture .h5ad dataset AnnData 31672 FB3CeMjmg1ivN6HDy6wsSg NaN 3.0 ... True False 2025-07-29 12:27:25.572900+00:00 1 1 1 2 791.0 151.0 9
1132 AHIfMnXepm6KaEaH0000 scrna/Parse_10M_PBMC_cytokines_curated.tiledbsoma None .tiledbsoma None tiledbsoma 38222071364 snBmwsareebO03_9NPvY_w 1053.0 9697974.0 ... True False 2024-12-16 22:39:02.039538+00:00 1 1 1 2 401.0 NaN 9
1117 xepHn6ScXGs5s1Te0001 example_datasets/small_dataset1.tiledbsoma None .tiledbsoma None tiledbsoma 19853 xkq9-kEUEChvxq-89_aJ7Q 57.0 3.0 ... True False 2024-12-16 09:13:47.043028+00:00 1 1 1 2 394.0 NaN 9
1116 mKo82UispVElpGtP0002 example_datasets/small_dataset1.h5ad None .h5ad dataset AnnData 25088 YMNwVfQZ78zwkB4shAQMfQ NaN 3.0 ... True False 2024-12-16 09:13:19.877258+00:00 1 1 1 2 394.0 NaN 9
1096 LmlgCMQRhSEHtcbG0000 census_immune_cells.tiledbsoma tiledbsoma experiment for Immune cells .tiledbsoma None tiledbsoma 1268083316 Rug1115Hhc44XG_OvdICRw 442.0 73047.0 ... True False 2024-12-05 19:14:39.282533+00:00 1 1 1 2 384.0 NaN 3
1090 NiaMP8YQMbmkdOgnAa1T cell-census/2024-07-01/h5ads/f64e1be1-de15-4d2... Immune cells .h5ad dataset AnnData 2854344210 3oh1Yk3fZPQMCuJWbhZ4zQ NaN 73047.0 ... True False 2024-12-05 16:37:13.463549+00:00 1 1 1 16 385.0 NaN 3
1082 lNBsZ6Zd02kteKnK0000 schmidt22/summary_anndata.h5ad analyzed anndata of schmidt22 perturbseq .h5ad dataset AnnData 20674389 hIIpdQq3gbqt5FJs0KtwEA NaN 853.0 ... True False 2024-12-04 12:51:18.725509+00:00 1 1 1 2 378.0 NaN 2
1071 xepHn6ScXGs5s1Te0000 example_datasets/small_dataset1.tiledbsoma None .tiledbsoma None tiledbsoma 18662 xFKN6Uzvhz-OXOEr9HmPKQ 53.0 3.0 ... False False 2024-12-03 14:05:19.776525+00:00 1 1 1 2 373.0 NaN 3
1070 mKo82UispVElpGtP0001 example_datasets/small_dataset1.h5ad None .h5ad dataset AnnData 25648 eJnHmQZgRQbUMkij-ziqeA NaN 3.0 ... False False 2024-12-03 14:04:47.882577+00:00 1 1 1 2 373.0 NaN 3
1045 7dVluLROpalzEh8mNyxk cell-census/2023-12-15/h5ads/02faf712-92d4-458... Renal cell carcinoma, pre aPD1, kidney Puck_20... .h5ad None AnnData 13997860 YNYuokfAoDFxdaRILjmU9w NaN 17612.0 ... True False 2024-12-02 08:57:19.308058+00:00 1 1 1 16 361.0 NaN 30
1010 dP0F1fEQWtorhDaI0000 example_datasets/small_dataset2.h5ad None .h5ad dataset AnnData 21224 7ok_2cIe73owydEGaj7m0A NaN 3.0 ... True False 2024-11-25 14:59:38.945319+00:00 1 1 1 2 302.0 NaN 9
1009 mKo82UispVElpGtP0000 example_datasets/small_dataset1.h5ad None .h5ad dataset AnnData 23352 NYni1vTRM7pqfle8ufPZwQ NaN 3.0 ... False False 2024-11-25 14:59:09.484279+00:00 1 1 1 2 302.0 NaN 9
938 3TNCsZZcnIBv2WGb0001 None 10x reference adata, trusted cell type annotation .h5ad dataset AnnData 851664 iETHP3Lw-tVqZxYAuEC-SA NaN 70.0 ... True False 2024-10-18 21:46:55.467982+00:00 1 1 1 2 305.0 NaN 9
937 3TNCsZZcnIBv2WGb0000 None 10x reference adata .h5ad dataset AnnData 859840 MAjl6lrjrcjqhUUA0ixMKA NaN 70.0 ... False False 2024-10-18 21:45:46.636210+00:00 1 1 1 2 305.0 NaN 9
750 PrHBuKLflU03CeI2xNPJ None 10x reference adata .h5ad None AnnData 857752 c9ukVXVfpdaH2BWaqBfK4g NaN 70.0 ... True False 2024-06-26 10:00:08.928727+00:00 1 1 1 2 209.0 NaN 2
725 CFcQxNjzSRzWZrVhBk65 None Kuppe 2022, ATAC .anndata.zarr None AnnData 2883707589 cqrk4idQ_WGjTe6KBrIKgg 2799.0 NaN ... True False 2024-06-05 10:21:25.684256+00:00 1 1 1 2 181.0 NaN 2
708 ytL7CXi5peqhfSPNSFVG None Kuppe 2022, RNA .anndata.zarr None AnnData 3107878597 tMzcoJ_1iz4Zsdvr-sjt6A 3380.0 NaN ... True False 2024-06-26 10:00:29.405916+00:00 1 1 1 2 181.0 NaN 2
706 psrHlYkmysrxtAL3RBTo None Kuppe 2022, Visium adata .anndata.zarr None AnnData 65107609 WN5GxCkcKeO5UElDZ2IA0A 206.0 NaN ... True False 2024-06-04 12:33:00.419035+00:00 1 1 1 2 181.0 NaN 2

20 rows × 22 columns

By features¶

The Feature registry indexes variables across datasets to enable querying by dimensions. Registry fields couldn’t scale to millions of dimensions as found in biology:

The Artifact, Record, and Run registries can be queried by feature expressions:

feature_type = db.Feature.get(name="mini_immuno")
perturbation = db.Feature.get(name="perturbation", type=feature_type)
temperature = db.Feature.get(name="temperature")
db.Artifact.filter(
    perturbation == "DMSO",
    temperature > 21,
).to_dataframe(include="features")
Show code cell output Hide code cell output
uid key perturbation cell_type_by_model assay_oid temperature
id
11925 AsTXi6hzDFM7L17t0003 examples/mini_immuno_with_single_typo.parquet {DMSO, IFNG} {T cell, B cell} EFO:0008913 21.6

You can query for whether a dataset is annotated by a feature:

db.Artifact.filter(perturbation.is_null(False)).to_dataframe(include="features")
Show code cell output Hide code cell output
uid key perturbation cell_type_by_model assay_oid temperature
id
11925 AsTXi6hzDFM7L17t0003 examples/mini_immuno_with_single_typo.parquet {DMSO, IFNG} {T cell, B cell} EFO:0008913 21.6

Cheat sheet: comparators¶

You can qualify the type of comparison in a query by using a comparator. Below is a list of the most important ones, but Django supports about two dozen field comparators field__comparator=value.

and¶

db.Artifact.filter(suffix=".h5ad", records=experiment_1).to_dataframe()
Show code cell output Hide code cell output
uid id key description suffix kind otype size hash n_files ... is_latest is_locked created_at branch_id created_on_id space_id storage_id run_id schema_id created_by_id

0 rows × 23 columns

less than/ greater than¶

# artifacts greater than 10kB
db.Artifact.filter(size__gt=1e4).to_dataframe()
Show code cell output Hide code cell output
! truncated query result to limit=20 Artifact objects
uid key description suffix kind otype size hash n_files n_observations ... is_latest is_locked created_at branch_id created_on_id space_id storage_id run_id schema_id created_by_id
id
29330 f5ziBE16S6cgCcAa0000 cell-census/2025-11-17/h5ads/b57462e3-1df5-463... Spinal cord dataset .h5ad None AnnData 838544828 ea9CevFem3KDHVmKcwAstg None 62711.0 ... True False 2026-08-07 10:18:36.374154+00:00 1 1 1 64 12723.0 None 60
29329 ipr0Yru8t2EUWI6W0000 cell-census/2025-11-17/h5ads/e2a00644-0a48-481... Brain dataset .h5ad None AnnData 1034127754 qmO4ws35SfmhDFjTPt04CQ None 75583.0 ... True False 2026-08-07 10:18:35.132493+00:00 1 1 1 64 12723.0 None 60
29327 VlKotQI94fi5ZeE30000 cell-census/2025-11-08/h5ads/001b01fe-5c70-4bd... WSSS_F_IMMsp10864183 .h5ad None AnnData 159135298 h0WE90MKphz5C2-yEv0wDA None 4992.0 ... True False 2026-08-07 10:17:56.973553+00:00 1 1 1 16 12722.0 None 60
29326 8pdGUzaPNtolFIdF0000 cell-census/2025-11-08/h5ads/00099d5e-154f-4a7... Spatial transcriptomics in mouse: Puck_191206_04 .h5ad None AnnData 16497090 zPOKGUYq66NbshPtZ-I08g None 26239.0 ... True False 2026-08-07 10:17:56.084912+00:00 1 1 1 16 12722.0 None 60
29176 mNXum9KZQQbkgWTq0000 datasets/sales/synthetic_sales.csv Synthetic transactional sales dataset generate... .csv None DataFrame 154444 mVX-CZ3SHYpI-9VPjR7DrA None NaN ... True False 2026-08-06 14:24:49.526600+00:00 1 1 1 2 12615.0 None 76
29075 gcdtMgwa9e9S9UVp0001 gwas/raw/raw_gwas_data.csv Input GWAS matrix with phenotype, covariates, ... .csv dataset DataFrame 53352 hFbns715lnEw775gRGjd9w None 250.0 ... True False 2026-08-05 18:04:31.882621+00:00 1 682 1 2 NaN None 46
29031 TR7rauYoGbe3zuQ50000 figures/churn_rate_by_region.png Bar chart of churn rates by region .png None None 32918 LmIand9bIihhMFokeroxVw None NaN ... True False 2026-08-05 16:13:15.641407+00:00 1 1 1 2 12537.0 None 76
29027 sDWtv2aElra5VtR40000 datasets/customer_churn_synthetic.csv Synthetic customer churn dataset with region a... .csv None DataFrame 10192 depLWDgoATG5Tc5LHJwORw None NaN ... True False 2026-08-05 16:11:55.598858+00:00 1 1 1 2 12535.0 None 76
29021 NINEoAFwQoRhxCuc0000 gwas_pipeline/visualization/qq_plot.png Q-Q plot .png None None 59374 m5EwTtf8JO5e6MawECUEFA None NaN ... True False 2026-08-05 15:20:27.921251+00:00 1 1 1 2 12532.0 None 46
29020 D4MfZgpleSokMw5e0000 gwas_pipeline/visualization/manhattan_plot.png Manhattan plot .png None None 36404 QN6ZxDYGfPLsDtYYJP35pg None NaN ... True False 2026-08-05 15:20:26.782948+00:00 1 1 1 2 12532.0 None 46
29005 iFv3cTuMyYhU38S70000 gwas_pipeline/qc/cleaned_gwas_data.csv QC-pass GWAS matrix .csv None DataFrame 76075 Fi2Ng0GNDTHljsitkg0V5g None NaN ... True False 2026-08-05 15:17:59.407127+00:00 1 1 1 2 12525.0 None 46
28997 BtleGDz1pXNmvBMi0000 sales/plots/sales_revenue_summary.png Line plot of monthly total revenue from cleane... .png None None 76912 8LcylcbfIJs4_orkRzsMAQ None NaN ... True False 2026-08-05 14:01:22.891637+00:00 1 1 1 2 12520.0 None 76
28994 yQWijnLot6NuQyuz0000 sales/processed/synthetic_sales_cleaned.csv Cleaned synthetic sales dataset with computed ... .csv None DataFrame 96315 inXlf1q3mxH0GBlivZri8Q None NaN ... True False 2026-08-05 14:00:34.415090+00:00 1 1 1 2 12519.0 None 76
28992 hedxeCi5xwI0woym0000 sales/raw/synthetic_sales_raw.csv Synthetic sales dataset with intentional quali... .csv None DataFrame 72983 TV7hEfZ8VXvMSGY7CmjMXw None NaN ... True False 2026-08-05 14:00:07.864970+00:00 1 1 1 2 12518.0 None 76
28969 QiG5C2dhWN88sXkI0000 gwas/v6wygMYs6uZGzjTh/gwas_report.pdf PDF report with GWAS summary plots and top hits .pdf None None 21203 HGNjCYvRgrLEJrv_NQ-JMQ None NaN ... True False 2026-08-05 12:27:03.625643+00:00 1 1 1 2 12501.0 None 46
28958 7SmdHbvZHu1I7WL20000 ataqseq_data.csv Synthetic ATAC-seq peak count data .csv None DataFrame 24807 aZC1WVu4Io-L2mgAg50jqQ None NaN ... True False 2026-08-05 11:58:02.232125+00:00 1 1 1 2 12494.0 None 46
28944 uFU2haNLgqBmATth0000 None GWAS PDF report with Manhattan-style and QQ plots .pdf None None 21715 -TD6l0MHHmrb4bDfa8u2Hg None NaN ... True False 2026-08-05 11:05:07.005462+00:00 1 1 1 2 12484.0 None 46
28868 VI83Mbll3SSph2Bx0000 None Mouse ATAC-seq peak dataset (synthetic) .csv None DataFrame 49991 9tbQ0yQUCz-QQCjqifY0xw None NaN ... True False 2026-08-05 08:45:52.536655+00:00 1 1 1 2 12428.0 None 76
28837 BTOYJi8k2BONCvlb0000 None Embedded asset .png __easset__ None 451706 xU7YAUklQVvbaZZOTaX8kQ None NaN ... True False 2026-08-04 14:17:19.198359+00:00 1 1 1 2 NaN None 46
28704 DlQvDpIl6fkQtqY50004 scanpy-analysis/pbmc3k_marker_dotplot.svg PBMC3k canonical marker dotplot per cell type .svg None None 249901 TSbwOUhEtHv3FuT_5EF2iA None NaN ... True False 2026-08-03 11:46:27.090373+00:00 1 630 1 2 12270.0 None 2

20 rows × 22 columns

in¶

db.Artifact.filter(suffix__in=[".jpg", ".fastq.gz"]).to_dataframe()
Show code cell output Hide code cell output
! truncated query result to limit=20 Artifact objects
uid key description suffix kind otype size hash n_files n_observations ... is_latest is_locked created_at branch_id created_on_id space_id storage_id run_id schema_id created_by_id
id
28185 7AffjOdqFRIVgpTZ0000 nf-core/test-datasets/scrnaseq/testdata/cellra... Input artifact at https://raw.githubuserconten... .fastq.gz None None 1981608 mmP1JptCPyMLs5sK5sfG3g None None ... True False 2026-08-03 02:15:14.978778+00:00 1 1 1 42 NaN None 18
28184 RQzzsn8f04rpVHBQ0000 nf-core/test-datasets/scrnaseq/testdata/cellra... Input artifact at https://raw.githubuserconten... .fastq.gz None None 737653 lF1s_gl9HqRjDnUghMEBUA None None ... True False 2026-08-03 02:15:14.179540+00:00 1 1 1 42 NaN None 18
28183 hQIafmTUYTCu6U380000 nf-core/test-datasets/scrnaseq/testdata/cellra... Input artifact at https://raw.githubuserconten... .fastq.gz None None 4259756 YAoFK35Aq8NbG3yELgfLpQ None None ... True False 2026-08-03 02:15:13.293893+00:00 1 1 1 42 NaN None 18
28175 DZ2ZlIMHandyStjk0000 nf-core/test-datasets/scrnaseq/testdata/cellra... Input artifact at https://raw.githubuserconten... .fastq.gz None None 1727503 tN8WWL5aSoWSIk9aU1fvLg None None ... True False 2026-08-03 02:15:09.923273+00:00 1 1 1 42 NaN None 18
28171 aWk4SGRJG9HbRcHj0000 nf-core/test-datasets/scrnaseq/testdata/cellra... Input artifact at https://raw.githubuserconten... .fastq.gz None None 4259756 YAoFK35Aq8NbG3yELgfLpQ None None ... True False 2026-08-03 02:14:55.191667+00:00 1 1 1 42 NaN None 18
28170 xY5RtGF79GvK6Ems0000 nf-core/test-datasets/scrnaseq/testdata/cellra... Input artifact at https://raw.githubuserconten... .fastq.gz None None 1727503 tN8WWL5aSoWSIk9aU1fvLg None None ... True False 2026-08-03 02:14:54.229481+00:00 1 1 1 42 NaN None 18
27412 WC1CAMYuqRdf3FP30000 test-data/scrnaseq/pbmc8k_S1_L008_R2_001.fastq.gz Input artifact at s3:///ngi-igenomes/test-data... .fastq.gz dataset None 29398909053 3QmwtB-_YgQk3KzcKo9aKg None None ... True False 2026-07-23 07:40:52.023603+00:00 1 1 1 63 NaN None 54
27411 Isd2IJe9wLX3as4v0000 test-data/scrnaseq/pbmc8k_S1_L008_R1_001.fastq.gz Input artifact at s3:///ngi-igenomes/test-data... .fastq.gz dataset None 7675471589 MdnZwaVvedac8R-Qu-WBLg None None ... True False 2026-07-23 07:40:50.648530+00:00 1 1 1 63 NaN None 54
27410 tUURaCPj0LOUe7gh0000 test-data/scrnaseq/pbmc8k_S1_L007_R2_001.fastq.gz Input artifact at s3:///ngi-igenomes/test-data... .fastq.gz dataset None 29553466687 Te3tftzOgMl5vnmtx3kKvg None None ... True False 2026-07-23 07:40:49.213511+00:00 1 1 1 63 NaN None 54
27409 KXEPPbhLhdvNu4ja0000 test-data/scrnaseq/pbmc8k_S1_L007_R1_001.fastq.gz Input artifact at s3:///ngi-igenomes/test-data... .fastq.gz dataset None 7725840097 iU6K3QJoo5pPp9peYmFedQ None None ... True False 2026-07-23 07:40:47.659248+00:00 1 1 1 63 NaN None 54
26631 qGXvU8SFFsQclgR10000 Uploads/iris-0337d20a3b7273aa0ddaa7d6afb57a37a... None .jpg None None 14529 e0Gct8LodEyQzNwy1glOPA None None ... True False 2026-07-14 14:51:33.166215+00:00 1 1 1 2 NaN None 46
23623 siAj6EUthWF8gs2S0000 temp/output/fetchngs/fastq/SRX9315476_SRR12848... Output artifact for run 8541 .fastq.gz dataset None 123467 A_WjRYau-c1h9U6yaDGmZQ None None ... True False 2026-06-01 09:38:35.976330+00:00 1 1 1 59 8541.0 None 54
23622 F9Tn8DfxnBPGtssK0000 temp/output/fetchngs/fastq/SRX9315476_SRR12848... Output artifact for run 8541 .fastq.gz dataset None 131539 l3AcXYhK-NlrqV1yN_O_eQ None None ... True False 2026-06-01 09:38:31.103701+00:00 1 1 1 59 8541.0 None 54
23621 FtiwkNxd0Ila7VWx0000 temp/output/fetchngs/fastq/SRX11047067_SRR1470... Output artifact for run 8541 .fastq.gz dataset None 150 eRQN0cs_0cXgLYjgH3w-2g None None ... True False 2026-06-01 09:38:26.673415+00:00 1 1 1 59 8541.0 None 54
23620 Xh881SEOzEhkxVBh0000 temp/output/fetchngs/fastq/SRX10940790_SRR1459... Output artifact for run 8541 .fastq.gz dataset None 473 y9MHFf3vRX16okoS8Z7t8g None None ... True False 2026-06-01 09:38:22.275334+00:00 1 1 1 59 8541.0 None 54
23619 U4GV6WjzB72LJJNy0000 temp/output/fetchngs/fastq/SRX10940790_SRR1459... Output artifact for run 8541 .fastq.gz dataset None 459 akdizw8fn1VE03NeLgfF0w None None ... True False 2026-06-01 09:38:18.479607+00:00 1 1 1 59 8541.0 None 54
23617 1YEM2Tzio0JpaPke0000 temp/output/fetchngs/fastq/SRX9504942_SRR13055... Output artifact for run 8541 .fastq.gz dataset None 714907 WtUUYMbEqFDdN6IG4sRBwQ None None ... True False 2026-06-01 09:37:53.956200+00:00 1 1 1 59 8541.0 None 54
23616 8DhYtWgZJO545TJo0000 temp/output/fetchngs/fastq/SRX9504942_SRR13055... Output artifact for run 8541 .fastq.gz dataset None 721705 qXc2e_QdrPTCG8DIIBuLiA None None ... True False 2026-06-01 09:37:39.002608+00:00 1 1 1 59 8541.0 None 54
23615 NgZujyEK9KmFMlFK0000 temp/output/fetchngs/fastq/SRX9504942_SRR13055... Output artifact for run 8541 .fastq.gz dataset None 717693 XsiU2GP87-OURwoJJa795A None None ... True False 2026-06-01 09:37:29.243127+00:00 1 1 1 59 8541.0 None 54
23614 rLzlXSOpP8o1piIs0000 temp/output/fetchngs/fastq/SRX9504942_SRR13055... Output artifact for run 8541 .fastq.gz dataset None 716862 w_NDeTVrKNbaxyEqvBoKBA None None ... True False 2026-06-01 09:37:24.188066+00:00 1 1 1 59 8541.0 None 54

20 rows × 22 columns

order by¶

db.Artifact.filter().order_by("created_at").to_dataframe()
Show code cell output Hide code cell output
! truncated query result to limit=20 Artifact objects
uid key description suffix kind otype size hash n_files n_observations ... is_latest is_locked created_at branch_id created_on_id space_id storage_id run_id schema_id created_by_id
id
1 WGDHevIgEDPJ6CB99foT Data-objects/tabula-muris-senis-facs-processed... tabula-muris-senis-facs-processed-official-ann... .h5ad None None 4795677086 None None None ... True False 2023-04-24 18:16:32.313696+00:00 1 1 1 8 1.0 None 9
2 0PsCY8SjhD1FIqw9e99v paradisi05.jpg paradisi05.jpg .jpg None None 29358 r4tnqmKI_SjrkdLzpuWp4g None None ... True False 2023-05-11 17:27:12.479874+00:00 1 1 1 2 6.0 None 2
3 1YOa919kJFXzvgfmq4Pv alignment_result.bam alignment_result.bam .bam None None 14 rGSwtSEKB65DaaQq740p6A None None ... True False 2023-05-11 17:27:22.895303+00:00 1 1 1 2 6.0 None 2
4 DoI5k2zRvBdI29OO7vGu alignment_result.fastq.gz alignment_result.fastq.gz .fastq.gz None None 16 QDkCIyDtWe8tlrS9zG8gnw None None ... True False 2023-05-11 17:29:35.872683+00:00 1 1 1 2 6.0 None 2
7 ODQVll1jtwfvv1lQwyw3 None human immune cells .h5ad None None 60947643 6QUqNaIQurw-HLIkXg9_1w None None ... True False 2023-05-17 07:27:10.961723+00:00 1 1 1 2 6.0 None 2
8 SAPKv9zC4hBmXsHvdReg None scRNA-seq mouse lymph_node .h5ad None None 17341245 Qprqj0O23197Ko-VobaZiw None None ... True False 2023-05-17 07:29:20.858230+00:00 1 1 1 2 6.0 None 2
9 myPxexSQMW3Xrdz5C31U None scRNA-seq pbmc3k processed .h5ad None None 40212506 8uy3ub-USOUcnkFEw5UzzA None None ... True False 2023-05-17 07:34:56.434082+00:00 1 1 1 2 6.0 None 2
10 YdTtu9TBPYe6ov1ItOVK None scRNA-seq pbmc68k reduced .h5ad None None 638484 -QNUPBbAug3jFmmk3fsOQA None None ... True False 2023-05-17 07:37:43.536825+00:00 1 1 1 2 6.0 None 2
16 i8iBR6gPn7NIvxwgjyxD None Human Lung Cell Atlas (core) .h5ad None None 6024041966 -B4rkeu0-NKqWVpJqPq6aX None None ... True False 2023-07-14 12:48:12.378063+00:00 1 1 1 2 24.0 None 5
18 dPraor9rU1EofcFb6Wph tabula_sapiens_lung.h5ad Part of Tabula Sapiens, a benchmark, first-dra... .h5ad None None 3899435772 8mB1KK2wd51F6HQdvqipcQ None None ... True False 2023-07-14 19:00:30.621330+00:00 1 1 1 2 9.0 None 3
21 uAAHUIGb13zvUYkMRsGR schmidt22/schmidt22_merged.h5ad CRISPRa Perturb-seq of primary human T cells .h5ad None None 3155685871 gJcjALISed0J5OhSmEDJ2v None None ... True False 2023-07-14 19:58:17.360062+00:00 1 1 1 2 30.0 None 6
22 JQjRzDBw2OLQ5XLbhtUg None schmidt22_data/Genome-wide-screens/data/gene_s... .parquet None None 1242827 2XQbncQ48h4kczkYd95lZQ None None ... True False 2023-07-15 12:30:06.020349+00:00 1 1 1 2 30.0 None 6
23 wukqLbKCfN6xXuzwcbW2 None schmidt22_data/Genome-wide-screens/data/gene_s... .parquet None None 1203729 ebsJsQG1xyr1Rfurc5UShw None None ... True False 2023-07-15 12:30:10.051671+00:00 1 1 1 2 30.0 None 6
24 GDHZJ99oQDiPsS7o8GSl None schmidt22_data/Genome-wide-screens/data/gene_s... .parquet None None 1222490 5G4M1Qw2Kqj69w28Z6_YBA None None ... True False 2023-07-15 12:30:13.575614+00:00 1 1 1 2 30.0 None 6
25 9Gw50HQnl2vYyzWOpOvx None schmidt22_data/Genome-wide-screens/data/gene_s... .parquet None None 1246652 CsEMn21jx3ooCzuN1bokHw None None ... True False 2023-07-15 12:30:17.140265+00:00 1 1 1 2 30.0 None 6
346 OYMsfQft74x86KVv0000 fasta/PO5F1.fasta None .fasta None None 477 -7iJgveFO9ia0wE1bqVu6g None None ... True False 2023-09-19 13:22:31.901870+00:00 1 1 1 2 NaN None 9
412 6cZkqq35HhC4SXoz0000 fasta/MYC.fasta None .fasta None None 536 WGbEtzPw-3bQEGcngO_pHQ None None ... True False 2023-09-19 13:22:32.163643+00:00 1 1 1 2 NaN None 9
413 dWps4Flwk1SYHIP00000 fasta/SOX2.fasta None .fasta None None 414 C5q_yaFXGk4SAEpfdqBwnQ None None ... True False 2023-09-19 13:22:32.419702+00:00 1 1 1 2 NaN None 9
414 5Kw7XSsF6jRKiUe60000 fasta/KLF4.fasta None .fasta None None 609 LyuoYkWs4SgYcH7P7JLJtA None None ... True False 2023-09-19 13:22:32.679683+00:00 1 1 1 2 NaN None 9
383 Ff4XZtm6Lko0Fz3ysIEl None 10x reference adata .h5ad None AnnData 660792 TRHLp5EVjDGdv7DufMAnmg None None ... True False 2023-10-04 13:19:07.817861+00:00 1 1 1 2 33.0 None 2

20 rows × 22 columns

# reverse ordering
db.Artifact.filter().order_by("-created_at").to_dataframe()
Show code cell output Hide code cell output
! truncated query result to limit=20 Artifact objects
uid key description suffix kind otype size hash n_files n_observations ... is_latest is_locked created_at branch_id created_on_id space_id storage_id run_id schema_id created_by_id
id
29330 f5ziBE16S6cgCcAa0000 cell-census/2025-11-17/h5ads/b57462e3-1df5-463... Spinal cord dataset .h5ad None AnnData 838544828 ea9CevFem3KDHVmKcwAstg None 62711.0 ... True False 2026-08-07 10:18:36.374154+00:00 1 1 1 64 12723.0 None 60
29329 ipr0Yru8t2EUWI6W0000 cell-census/2025-11-17/h5ads/e2a00644-0a48-481... Brain dataset .h5ad None AnnData 1034127754 qmO4ws35SfmhDFjTPt04CQ None 75583.0 ... True False 2026-08-07 10:18:35.132493+00:00 1 1 1 64 12723.0 None 60
29327 VlKotQI94fi5ZeE30000 cell-census/2025-11-08/h5ads/001b01fe-5c70-4bd... WSSS_F_IMMsp10864183 .h5ad None AnnData 159135298 h0WE90MKphz5C2-yEv0wDA None 4992.0 ... True False 2026-08-07 10:17:56.973553+00:00 1 1 1 16 12722.0 None 60
29326 8pdGUzaPNtolFIdF0000 cell-census/2025-11-08/h5ads/00099d5e-154f-4a7... Spatial transcriptomics in mouse: Puck_191206_04 .h5ad None AnnData 16497090 zPOKGUYq66NbshPtZ-I08g None 26239.0 ... True False 2026-08-07 10:17:56.084912+00:00 1 1 1 16 12722.0 None 60
29281 UcBMQ0x1BaoNHzV40000 numbers/squares/first_10_squares.txt First ten square numbers as plain text .txt None None 28 g-iuTY5jGeVA5qtJM9julw None NaN ... True False 2026-08-07 09:25:24.158251+00:00 1 1 1 2 12696.0 None 76
29259 5cJBlMDWOr0pAn3y0000 examples/math/factorials_1_to_8.txt First eight factorial values from 1! through 8! .txt None None 68 lR8fl-ra1qVkEUpp8gxpxw None NaN ... True False 2026-08-07 09:03:57.446595+00:00 1 1 1 2 12680.0 None 76
29258 qtn8fhdZUgIks7G80000 numbers/multiples_of_7_under_200.txt Multiples of 7 under 200 .txt None None 97 SvIqUNLp-HrINGMvNrM1NA None NaN ... True False 2026-08-07 09:03:40.542280+00:00 1 1 1 2 12679.0 None 76
29223 QxoTrvnz6bkj9TA10000 math/triangular_numbers_first_10.txt First 10 triangular numbers as plain text .txt None None 27 Dd1uQouUJum-KX3SDwdJ3A None NaN ... True False 2026-08-06 17:05:08.030015+00:00 1 1 1 2 12646.0 None 76
29222 r62W3X46XAnz2w5P0000 numbers/powers_of_2.txt All powers of 2 up to 1024, one per line. .txt None None 34 pDq7DpTH7A9AasfMEg9Qrw None NaN ... True False 2026-08-06 17:05:02.485530+00:00 1 1 1 2 12647.0 None 76
29220 dWjAvq6ACZC7rTuw0000 examples/fibonacci/first_12.txt First 12 Fibonacci numbers in a plain text file .txt None None 31 HQN_-xzkhu1li6B90qrtOw None NaN ... True False 2026-08-06 16:54:12.327105+00:00 1 1 1 2 12645.0 None 76
29219 JujVPU7fapWeydnI0000 math/divisors/divisors_of_360.txt All positive divisors of 360 as plain text .txt None None 83 dPwQdtda_ThT-13U_sjXaA None NaN ... True False 2026-08-06 16:54:02.965544+00:00 1 1 1 2 12645.0 None 76
29217 Sdwe8WMSeEGKQVbh0000 results/math/sum_squares_first_50_even.txt Sum of squares of the first 50 even numbers .txt None None 7 rEJ5bn_72WFgqaAl4Pk_bw None NaN ... True False 2026-08-06 16:33:52.222242+00:00 1 1 1 2 12640.0 None 76
29214 xu9q2UnPe0O1FwYt0000 datasets/math/fibonacci_20th.json The 20th Fibonacci number stored in JSON format. .json None None 36 B-yew0i1sL8iv9ADtgoIYQ None NaN ... True False 2026-08-06 16:33:23.868843+00:00 1 1 1 2 12639.0 None 76
29213 eEzb41uRboC2jhoK0000 inputs/math/first_50_even_numbers.txt First 50 even numbers as comma-separated integers .txt None None 146 THFdzn54OtPKvgdAUN7Z-g None NaN ... True False 2026-08-06 16:33:21.419051+00:00 1 1 1 2 NaN None 76
29212 De3Xj5hqtQl7taS30000 configs/fibonacci/nth_20.json Configuration specifying which Fibonacci posit... .json None None 13 dqoPu42JeQS4Jx2Re11dVA None NaN ... True False 2026-08-06 16:33:19.773003+00:00 1 1 1 2 12639.0 None 76
29208 ZzdLyHT9exLFcKW10000 datasets/math/prime_sum_first_100.json Sum and values of the first 100 prime numbers ... .json None None 923 Z7P-2UN4ASB1MeFXcvNgdw None NaN ... True False 2026-08-06 16:05:29.979742+00:00 1 1 1 2 12633.0 None 76
29206 BwGjbYsgPUfSSR1L0000 configs/math/prime_sum_first_100.json Configuration specifying how many prime number... .json None None 18 vz9R4lT82t9zn2abkeoDxQ None NaN ... True False 2026-08-06 16:05:25.888529+00:00 1 1 1 2 12633.0 None 76
29205 ml6u1K8sjEpoZhod0000 datasets/math/factorial_15.json Factorial of 15 stored as JSON. .json None None 43 MWrr2k8ZF72hK4wbWirr6Q None NaN ... True False 2026-08-06 16:05:25.517553+00:00 1 1 1 2 12632.0 None 76
29204 Tp2pMvf7TJBXuYbS0000 configs/math/factorial_15_input.json Configuration for factorial computation. .json None None 13 JL69ZvGDESYcgHwN_1ThJA None NaN ... True False 2026-08-06 16:05:20.833032+00:00 1 1 1 2 12632.0 None 76
29193 c6tPsh1Ext72NKG10000 datasets/math/fibonacci_first_30.json First 30 Fibonacci numbers in JSON format. .json None None 315 0G_bWjuc5BGpuI6zky7pvQ None NaN ... True False 2026-08-06 14:37:16.676596+00:00 1 1 1 2 12621.0 None 76

20 rows × 22 columns

db.Artifact.filter().order_by("key").to_dataframe()
Show code cell output Hide code cell output
! truncated query result to limit=20 Artifact objects
uid key description suffix kind otype size hash n_files n_observations ... is_latest is_locked created_at branch_id created_on_id space_id storage_id run_id schema_id created_by_id
id
1140 1svnRMUAyY7PTZnD0000 1d91e74d48a309724ede35bdb33b5eb2/expr.h5ad Raw gene expression, in HDF5 format, readable ... .h5ad None AnnData 43588144 None None NaN ... True False 2024-12-17 16:16:45.263279+00:00 1 1 1 21 404.0 None 3
1139 FTsnAhhUfVFHzi810000 1d91e74d48a309724ede35bdb33b5eb2/raw_expr.h5ad Raw gene expression, in HDF5 format, readable ... .h5ad None AnnData 22525208 None None NaN ... True False 2024-12-17 16:16:37.875243+00:00 1 1 1 21 404.0 None 3
1141 ALpgSAl5hook33ab0000 1d91e74d48a309724ede35bdb33b5eb2/secondary_ana... Normalized gene expression with additional met... .h5ad None AnnData 151626542 None None NaN ... True False 2024-12-17 16:16:48.760726+00:00 1 1 1 21 404.0 None 3
3 1YOa919kJFXzvgfmq4Pv alignment_result.bam alignment_result.bam .bam None None 14 rGSwtSEKB65DaaQq740p6A None NaN ... True False 2023-05-11 17:27:22.895303+00:00 1 1 1 2 6.0 None 2
4 DoI5k2zRvBdI29OO7vGu alignment_result.fastq.gz alignment_result.fastq.gz .fastq.gz None None 16 QDkCIyDtWe8tlrS9zG8gnw None NaN ... True False 2023-05-11 17:29:35.872683+00:00 1 1 1 2 6.0 None 2
27600 hsCH2XBEje5JOZzq0000 annotated/pbmc8k.h5ad CellTypist annotated PBMCs (Immune_All_Low) .h5ad dataset AnnData 484113278 GZ62huQ9qpuYGNcb8Otoa4 None 8838.0 ... True False 2026-07-24 07:22:08.922568+00:00 1 1 1 2 11708.0 None 54
28958 7SmdHbvZHu1I7WL20000 ataqseq_data.csv Synthetic ATAC-seq peak count data .csv None DataFrame 24807 aZC1WVu4Io-L2mgAg50jqQ None NaN ... True False 2026-08-05 11:58:02.232125+00:00 1 1 1 2 12494.0 None 46
20933 k2Mo0c0rRWaaHEOB0000 B6QFo0adBZ0nfZfQ0000_converted.parquet None .parquet dataset DataFrame 2139 9Zr7blxtc0bbuDhnnzipmQ None 3.0 ... True False 2026-04-28 07:47:28.573229+00:00 1 1 1 2 NaN None 46
13307 M9C4GywJ4uaYaOKF0000 base64/MzZjNmRjMDAtMWE1Zi00MWQ1LTgwYmYtMjQ2M2R... Test artifact created by InstanceTest None None 36 None None NaN ... True False 2026-01-30 14:22:01.813916+00:00 1 1 1 44 2344.0 None 18
13658 1Au3smh05u51pgqf0000 base64/N2I5NjlkYjItYjk0YS00NTBiLThiZjItMDEyMzJ... Test artifact created by InstanceTest None None 36 None None NaN ... True False 2026-02-02 17:52:58.650562+00:00 1 1 1 44 2344.0 None 18
13654 l1A07snw7EGZoxDM0000 base64/NWYwNzU2NWQtZGU0My00NzYwLThhNTktZGFkOTI... Test artifact created by InstanceTest None None 36 None None NaN ... True False 2026-02-02 17:43:24.898030+00:00 1 1 1 44 2344.0 None 28
13309 rHJsVgYL3JeCnys70000 base64/NWZlNjg4M2MtYTc5MC00Njc4LWFhNGItZjQ0ZTc... Test artifact created by InstanceTest None None 36 None None NaN ... True False 2026-01-30 14:22:06.094091+00:00 1 1 1 44 2344.0 None 18
13637 EPdNmYHaEoEcICAU0000 base64/ODQ5NTU2OGItYmYxYy00MDNhLWExODQtOWVlZjg... Test artifact created by InstanceTest None None 36 None None NaN ... True False 2026-02-02 16:32:07.125630+00:00 1 1 1 44 2344.0 None 18
13656 1UPh91VG4Wm5JCmT0000 base64/OGMwZWFlOTItNDk2OS00ZTVkLWI4OGQtN2U5YTI... Test artifact created by InstanceTest None None 36 None None NaN ... True False 2026-02-02 17:52:43.443635+00:00 1 1 1 44 2344.0 None 18
13633 QOkybT6HiuRK3A5Z0000 base64/OTBiNWI2ZjQtZTY2OS00ZjlmLWIxZTgtYzE3Y2F... Test artifact created by InstanceTest None None 36 None None NaN ... True False 2026-02-02 16:13:00.579829+00:00 1 1 1 44 2344.0 None 18
13635 TiN5JQYlwZuQQMwJ0000 base64/YTQxZGRhYzktOGRjYi00M2RlLTk3ZTktYTdkM2Q... Test artifact created by InstanceTest None None 36 None None NaN ... True False 2026-02-02 16:31:36.249177+00:00 1 1 1 44 2344.0 None 18
13631 qoNpF7iF5jofk0Vy0000 base64/YTUxMWUxNmYtODExMC00YTJjLTlkOGYtOTQ2NTZ... Test artifact created by InstanceTest None None 36 None None NaN ... True False 2026-02-02 16:12:53.420857+00:00 1 1 1 44 2344.0 None 18
21116 TO5rwz6jfHPIP8n80000 bbsplit/WT_REP1.stats.txt Output artifact for run 6999 .txt None None 195 p4Y9zbVEhoEN8lrH7QfTvw None NaN ... True False 2026-04-28 11:05:08.327262+00:00 1 1 1 2 6999.0 None 54
12805 oREwvC1DB7voTZA30000 bechmarking_results.csv None .csv dataset DataFrame 1008 VSYoov2LZTGqMeq8sBKiPw None 4.0 ... True False 2026-01-18 21:09:32.834659+00:00 1 1 1 2 1892.0 None 46
17150 WF492K6UM1JWWHt30000 BSA1_F1_ms1_feature_info.parquet Output artifact for run 4742 .parquet None DataFrame 31948 9TsW6AP1An57L44iJqPxFA None NaN ... False False 2026-03-16 13:52:54.249429+00:00 1 1 1 2 4742.0 None 28

20 rows × 22 columns

# reverse ordering
db.Artifact.filter().order_by("-key").to_dataframe()
Show code cell output Hide code cell output
! truncated query result to limit=20 Artifact objects
uid key description suffix kind otype size hash n_files n_observations ... is_latest is_locked created_at branch_id created_on_id space_id storage_id run_id schema_id created_by_id
id
28795 Ea32XPvCPTMZItIq0000 None Favorite protein sequence in FASTA format .fasta None None 176 foOvleUa9YZVGOmgfd4ZCw None None ... True False 2026-08-04 07:58:16.539439+00:00 1 1 1 2 12373.0 None 46
28799 3Y6hBAUfHv0Gf7A30000 None Synthetic RNA-seq expression dataset saved to ... .csv dataset DataFrame 350 h5ou7lb7Gjp3c4qUC6toSQ None None ... True False 2026-08-04 08:46:12.050831+00:00 1 1 1 2 12374.0 None 46
28809 Jg5Lnzs70Vk79K0K0000 None Mouse ATAC-seq dataset .csv None DataFrame 385 XDdVU78700WyM1fVgzX56w None None ... True False 2026-08-04 09:19:20.588579+00:00 1 1 1 2 12383.0 None 46
28837 BTOYJi8k2BONCvlb0000 None Embedded asset .png __easset__ None 451706 xU7YAUklQVvbaZZOTaX8kQ None None ... True False 2026-08-04 14:17:19.198359+00:00 1 1 1 2 NaN None 46
28854 eCEt1JKvhDF4kS7q0000 None Mouse ATAQ-seq dataset .csv None DataFrame 311 VXRTvCwEQJCWHfXsDaycCQ None None ... True False 2026-08-04 15:36:49.340913+00:00 1 1 1 2 12417.0 None 76
28868 VI83Mbll3SSph2Bx0000 None Mouse ATAC-seq peak dataset (synthetic) .csv None DataFrame 49991 9tbQ0yQUCz-QQCjqifY0xw None None ... True False 2026-08-05 08:45:52.536655+00:00 1 1 1 2 12428.0 None 76
28875 NDpzkxv24MFXcG3I0000 None Mouse ATAQ-seq sample metadata dataset .csv None DataFrame 318 rfsjCssnFEaVC9IzqJ_0iA None None ... True False 2026-08-05 09:01:30.770912+00:00 1 1 1 2 12433.0 None 76
28881 5LRwljbQMTXpbO9u0000 None Mouse ATAQ-seq dataset .csv None DataFrame 617 9fOXOLAYYCskT_phS6LRVw None None ... True False 2026-08-05 09:12:08.102477+00:00 1 1 1 2 12438.0 None 76
28883 5jLMBl6v3SVE8ESt0000 None Synthetic mouse ATAQ-seq sample metadata dataset .csv None DataFrame 406 8aWl6GB6iSvICsQ0Mqk1dg None None ... True False 2026-08-05 09:16:40.274034+00:00 1 1 1 2 12440.0 None 76
28939 ZntAURAGmWZx1bwi0000 None Raw synthetic GWAS findings CSV .csv None DataFrame 579 8oxzQ0Qe1rvczlIr1o3kVw None None ... True False 2026-08-05 11:03:31.040513+00:00 1 1 1 2 12482.0 None 46
28941 cE3pkP3cTdBfHwBr0000 None Cleaned GWAS findings CSV .csv None DataFrame 684 sq9OkJ5cr_lakD4ckkC1Qg None None ... True False 2026-08-05 11:04:17.891725+00:00 1 1 1 2 12483.0 None 46
28944 uFU2haNLgqBmATth0000 None GWAS PDF report with Manhattan-style and QQ plots .pdf None None 21715 -TD6l0MHHmrb4bDfa8u2Hg None None ... True False 2026-08-05 11:05:07.005462+00:00 1 1 1 2 12484.0 None 46
28950 DeW0QT827xnGxQ100000 None Distance metrics between two random TCR sequences .csv None DataFrame 392 4NhUamfTX7an9KEdGY0NyQ None None ... True False 2026-08-05 11:30:25.696184+00:00 1 1 1 2 12489.0 None 46
28573 3BEjpr2p0AaE46pP0000 None Favorite protein sequence in FASTA format .fasta None None 43 GXDlCQf5wuwqnqfLKQV5VA None None ... True False 2026-08-03 08:44:25.800929+00:00 1 1 1 2 12184.0 None 76
28576 9Dx6McrD3bvf4kyd0000 None Favorite protein sequence in FASTA format .fasta None None 58 _P3mQLtL5e9poe8J3x4QKQ None None ... True False 2026-08-03 08:53:37.671638+00:00 1 1 1 2 12185.0 None 76
28581 oKpwSoPz4AaKmoiA0000 None My favorite protein sequence in FASTA format .fasta None None 48 tNdKtBQkAI5GHc75ggZgfg None None ... True False 2026-08-03 09:00:33.345421+00:00 1 1 1 2 12189.0 None 76
28583 ASWZP6zHhhVBBVMw0000 None Favorite protein sequence in FASTA format .fasta None None 35 y3H30MrvtIodHQJ4WpkzVA None None ... True False 2026-08-03 09:16:19.403059+00:00 1 1 1 2 12191.0 None 76
28586 TNSk8oXizB22ImVy0000 None FASTA file containing a favorite protein sequence .fasta None None 158 eBy-8x7zFCj218ahT-4Nrw None None ... True False 2026-08-03 09:19:13.598878+00:00 1 1 1 2 12194.0 None 76
28590 AYOq2J9n7kyI4K9X0000 None Favorite protein sequence in FASTA format .fasta None None 116 MnP59zPm2T5115vPTalbSA None None ... True False 2026-08-03 09:33:49.218596+00:00 1 1 1 2 12197.0 None 76
28593 SohciwsP7MsPvQgn0000 None Amino acid counts for hardcoded protein sequence .txt None None 99 4cu1Krv5nrDfRaeATI_hww None None ... True False 2026-08-03 09:42:07.328381+00:00 1 1 1 2 12199.0 None 76

20 rows × 22 columns

contains¶

db.Transform.filter(description__contains="search").to_dataframe().head(5)
Show code cell output Hide code cell output
uid key description kind source_code hash reference reference_type version_tag is_latest is_locked created_at branch_id created_on_id space_id environment_id plan_id run_id created_by_id
id
165 da8MZDFPQ4GB0000 compare_search.ipynb Benchmark search notebook # %% [markdown]\n# # transform.name\n\n# %%\ni... l4u8p4fKK6zu72DWV6GdiA None None None True False 2024-10-30 15:18:00.149553+00:00 1 1 1 None None None 3

And case-insensitive:

db.Transform.filter(description__icontains="Search").to_dataframe().head(5)
Show code cell output Hide code cell output
uid key description kind source_code hash reference reference_type version_tag is_latest is_locked created_at branch_id created_on_id space_id environment_id plan_id run_id created_by_id
id
165 da8MZDFPQ4GB0000 compare_search.ipynb Benchmark search notebook # %% [markdown]\n# # transform.name\n\n# %%\ni... l4u8p4fKK6zu72DWV6GdiA None None None True False 2024-10-30 15:18:00.149553+00:00 1 1 1 None None None 3

startswith¶

db.Transform.filter(description__startswith="Query").to_dataframe()
Show code cell output Hide code cell output
uid key description kind source_code hash reference reference_type version_tag is_latest is_locked created_at branch_id created_on_id space_id environment_id plan_id run_id created_by_id
id
262 vQABAtmRLi9I0002 query-parse-bio-10m-pbmcs.ipynb Query ParseBio 10m PBMCs notebook # %% [markdown] vscode={"languageId": "plainte... VkxM1pp_Ye5uDYSjFpcgXQ None None None True False 2025-01-07 17:34:28.449914+00:00 1 1 1 None None None 3
240 vQABAtmRLi9I0001 query-parse-bio-10m-pbmcs.ipynb Query ParseBio 10m PBMCs notebook # %% [markdown] vscode={"languageId": "plainte... jOa3ISogeUBetQ5bebVMbA None None None False False 2024-12-16 17:58:14.332044+00:00 1 1 1 None None None 9
237 vQABAtmRLi9I0000 query-parse-bio-10m-pbmcs.ipynb Query ParseBio 10m PBMCs notebook # %% [markdown] vscode={"languageId": "plainte... eEmGTrsubPrI_W4hVxTWgA None None None False False 2024-12-16 13:45:14.410851+00:00 1 1 1 None None None 9
103 wukchS8V976U0000 facs3 Query & integrate data notebook # %% [markdown]\n# ![facs3/4](https://img.shie... RMBKhscim8vHAar7Apl88A None None None True False 2024-06-07 09:21:17.248660+00:00 1 1 1 None None None 2
98 agayZTonayqA0001 scrna3 Query artifacts notebook # %% [markdown]\n# ![scrna3/6](https://img.shi... YKNlgbGXWi5Wy9D6aWhE4Q None None None True False 2024-06-06 13:29:04.132784+00:00 1 1 1 None None None 2
32 agayZTonayqA0000 scrna3 Query individual files notebook None None https://lamin.ai/docs/scrna3 lamin-usecases None False False 2023-10-04 13:38:27.829843+00:00 1 1 1 None None None 2

or¶

LaminDB uses Django’s Q objects to encapsulate filters for complex boolean logic.

db.Artifact.filter(ln.Q(suffix=".jpg") | ln.Q(suffix=".fastq.gz")).to_dataframe()
Show code cell output Hide code cell output
! truncated query result to limit=20 Artifact objects
uid key description suffix kind otype size hash n_files n_observations ... is_latest is_locked created_at branch_id created_on_id space_id storage_id run_id schema_id created_by_id
id
28185 7AffjOdqFRIVgpTZ0000 nf-core/test-datasets/scrnaseq/testdata/cellra... Input artifact at https://raw.githubuserconten... .fastq.gz None None 1981608 mmP1JptCPyMLs5sK5sfG3g None None ... True False 2026-08-03 02:15:14.978778+00:00 1 1 1 42 NaN None 18
28184 RQzzsn8f04rpVHBQ0000 nf-core/test-datasets/scrnaseq/testdata/cellra... Input artifact at https://raw.githubuserconten... .fastq.gz None None 737653 lF1s_gl9HqRjDnUghMEBUA None None ... True False 2026-08-03 02:15:14.179540+00:00 1 1 1 42 NaN None 18
28183 hQIafmTUYTCu6U380000 nf-core/test-datasets/scrnaseq/testdata/cellra... Input artifact at https://raw.githubuserconten... .fastq.gz None None 4259756 YAoFK35Aq8NbG3yELgfLpQ None None ... True False 2026-08-03 02:15:13.293893+00:00 1 1 1 42 NaN None 18
28175 DZ2ZlIMHandyStjk0000 nf-core/test-datasets/scrnaseq/testdata/cellra... Input artifact at https://raw.githubuserconten... .fastq.gz None None 1727503 tN8WWL5aSoWSIk9aU1fvLg None None ... True False 2026-08-03 02:15:09.923273+00:00 1 1 1 42 NaN None 18
28171 aWk4SGRJG9HbRcHj0000 nf-core/test-datasets/scrnaseq/testdata/cellra... Input artifact at https://raw.githubuserconten... .fastq.gz None None 4259756 YAoFK35Aq8NbG3yELgfLpQ None None ... True False 2026-08-03 02:14:55.191667+00:00 1 1 1 42 NaN None 18
28170 xY5RtGF79GvK6Ems0000 nf-core/test-datasets/scrnaseq/testdata/cellra... Input artifact at https://raw.githubuserconten... .fastq.gz None None 1727503 tN8WWL5aSoWSIk9aU1fvLg None None ... True False 2026-08-03 02:14:54.229481+00:00 1 1 1 42 NaN None 18
27412 WC1CAMYuqRdf3FP30000 test-data/scrnaseq/pbmc8k_S1_L008_R2_001.fastq.gz Input artifact at s3:///ngi-igenomes/test-data... .fastq.gz dataset None 29398909053 3QmwtB-_YgQk3KzcKo9aKg None None ... True False 2026-07-23 07:40:52.023603+00:00 1 1 1 63 NaN None 54
27411 Isd2IJe9wLX3as4v0000 test-data/scrnaseq/pbmc8k_S1_L008_R1_001.fastq.gz Input artifact at s3:///ngi-igenomes/test-data... .fastq.gz dataset None 7675471589 MdnZwaVvedac8R-Qu-WBLg None None ... True False 2026-07-23 07:40:50.648530+00:00 1 1 1 63 NaN None 54
27410 tUURaCPj0LOUe7gh0000 test-data/scrnaseq/pbmc8k_S1_L007_R2_001.fastq.gz Input artifact at s3:///ngi-igenomes/test-data... .fastq.gz dataset None 29553466687 Te3tftzOgMl5vnmtx3kKvg None None ... True False 2026-07-23 07:40:49.213511+00:00 1 1 1 63 NaN None 54
27409 KXEPPbhLhdvNu4ja0000 test-data/scrnaseq/pbmc8k_S1_L007_R1_001.fastq.gz Input artifact at s3:///ngi-igenomes/test-data... .fastq.gz dataset None 7725840097 iU6K3QJoo5pPp9peYmFedQ None None ... True False 2026-07-23 07:40:47.659248+00:00 1 1 1 63 NaN None 54
26631 qGXvU8SFFsQclgR10000 Uploads/iris-0337d20a3b7273aa0ddaa7d6afb57a37a... None .jpg None None 14529 e0Gct8LodEyQzNwy1glOPA None None ... True False 2026-07-14 14:51:33.166215+00:00 1 1 1 2 NaN None 46
23623 siAj6EUthWF8gs2S0000 temp/output/fetchngs/fastq/SRX9315476_SRR12848... Output artifact for run 8541 .fastq.gz dataset None 123467 A_WjRYau-c1h9U6yaDGmZQ None None ... True False 2026-06-01 09:38:35.976330+00:00 1 1 1 59 8541.0 None 54
23622 F9Tn8DfxnBPGtssK0000 temp/output/fetchngs/fastq/SRX9315476_SRR12848... Output artifact for run 8541 .fastq.gz dataset None 131539 l3AcXYhK-NlrqV1yN_O_eQ None None ... True False 2026-06-01 09:38:31.103701+00:00 1 1 1 59 8541.0 None 54
23621 FtiwkNxd0Ila7VWx0000 temp/output/fetchngs/fastq/SRX11047067_SRR1470... Output artifact for run 8541 .fastq.gz dataset None 150 eRQN0cs_0cXgLYjgH3w-2g None None ... True False 2026-06-01 09:38:26.673415+00:00 1 1 1 59 8541.0 None 54
23620 Xh881SEOzEhkxVBh0000 temp/output/fetchngs/fastq/SRX10940790_SRR1459... Output artifact for run 8541 .fastq.gz dataset None 473 y9MHFf3vRX16okoS8Z7t8g None None ... True False 2026-06-01 09:38:22.275334+00:00 1 1 1 59 8541.0 None 54
23619 U4GV6WjzB72LJJNy0000 temp/output/fetchngs/fastq/SRX10940790_SRR1459... Output artifact for run 8541 .fastq.gz dataset None 459 akdizw8fn1VE03NeLgfF0w None None ... True False 2026-06-01 09:38:18.479607+00:00 1 1 1 59 8541.0 None 54
23617 1YEM2Tzio0JpaPke0000 temp/output/fetchngs/fastq/SRX9504942_SRR13055... Output artifact for run 8541 .fastq.gz dataset None 714907 WtUUYMbEqFDdN6IG4sRBwQ None None ... True False 2026-06-01 09:37:53.956200+00:00 1 1 1 59 8541.0 None 54
23616 8DhYtWgZJO545TJo0000 temp/output/fetchngs/fastq/SRX9504942_SRR13055... Output artifact for run 8541 .fastq.gz dataset None 721705 qXc2e_QdrPTCG8DIIBuLiA None None ... True False 2026-06-01 09:37:39.002608+00:00 1 1 1 59 8541.0 None 54
23615 NgZujyEK9KmFMlFK0000 temp/output/fetchngs/fastq/SRX9504942_SRR13055... Output artifact for run 8541 .fastq.gz dataset None 717693 XsiU2GP87-OURwoJJa795A None None ... True False 2026-06-01 09:37:29.243127+00:00 1 1 1 59 8541.0 None 54
23614 rLzlXSOpP8o1piIs0000 temp/output/fetchngs/fastq/SRX9504942_SRR13055... Output artifact for run 8541 .fastq.gz dataset None 716862 w_NDeTVrKNbaxyEqvBoKBA None None ... True False 2026-06-01 09:37:24.188066+00:00 1 1 1 59 8541.0 None 54

20 rows × 22 columns

negate/ unequal¶

db.Artifact.filter(~ln.Q(suffix=".jpg")).to_dataframe()
Show code cell output Hide code cell output
! truncated query result to limit=20 Artifact objects
uid key description suffix kind otype size hash n_files n_observations ... is_latest is_locked created_at branch_id created_on_id space_id storage_id run_id schema_id created_by_id
id
29330 f5ziBE16S6cgCcAa0000 cell-census/2025-11-17/h5ads/b57462e3-1df5-463... Spinal cord dataset .h5ad None AnnData 838544828 ea9CevFem3KDHVmKcwAstg None 62711.0 ... True False 2026-08-07 10:18:36.374154+00:00 1 1 1 64 12723.0 None 60
29329 ipr0Yru8t2EUWI6W0000 cell-census/2025-11-17/h5ads/e2a00644-0a48-481... Brain dataset .h5ad None AnnData 1034127754 qmO4ws35SfmhDFjTPt04CQ None 75583.0 ... True False 2026-08-07 10:18:35.132493+00:00 1 1 1 64 12723.0 None 60
29327 VlKotQI94fi5ZeE30000 cell-census/2025-11-08/h5ads/001b01fe-5c70-4bd... WSSS_F_IMMsp10864183 .h5ad None AnnData 159135298 h0WE90MKphz5C2-yEv0wDA None 4992.0 ... True False 2026-08-07 10:17:56.973553+00:00 1 1 1 16 12722.0 None 60
29326 8pdGUzaPNtolFIdF0000 cell-census/2025-11-08/h5ads/00099d5e-154f-4a7... Spatial transcriptomics in mouse: Puck_191206_04 .h5ad None AnnData 16497090 zPOKGUYq66NbshPtZ-I08g None 26239.0 ... True False 2026-08-07 10:17:56.084912+00:00 1 1 1 16 12722.0 None 60
29281 UcBMQ0x1BaoNHzV40000 numbers/squares/first_10_squares.txt First ten square numbers as plain text .txt None None 28 g-iuTY5jGeVA5qtJM9julw None NaN ... True False 2026-08-07 09:25:24.158251+00:00 1 1 1 2 12696.0 None 76
29259 5cJBlMDWOr0pAn3y0000 examples/math/factorials_1_to_8.txt First eight factorial values from 1! through 8! .txt None None 68 lR8fl-ra1qVkEUpp8gxpxw None NaN ... True False 2026-08-07 09:03:57.446595+00:00 1 1 1 2 12680.0 None 76
29258 qtn8fhdZUgIks7G80000 numbers/multiples_of_7_under_200.txt Multiples of 7 under 200 .txt None None 97 SvIqUNLp-HrINGMvNrM1NA None NaN ... True False 2026-08-07 09:03:40.542280+00:00 1 1 1 2 12679.0 None 76
29223 QxoTrvnz6bkj9TA10000 math/triangular_numbers_first_10.txt First 10 triangular numbers as plain text .txt None None 27 Dd1uQouUJum-KX3SDwdJ3A None NaN ... True False 2026-08-06 17:05:08.030015+00:00 1 1 1 2 12646.0 None 76
29222 r62W3X46XAnz2w5P0000 numbers/powers_of_2.txt All powers of 2 up to 1024, one per line. .txt None None 34 pDq7DpTH7A9AasfMEg9Qrw None NaN ... True False 2026-08-06 17:05:02.485530+00:00 1 1 1 2 12647.0 None 76
29220 dWjAvq6ACZC7rTuw0000 examples/fibonacci/first_12.txt First 12 Fibonacci numbers in a plain text file .txt None None 31 HQN_-xzkhu1li6B90qrtOw None NaN ... True False 2026-08-06 16:54:12.327105+00:00 1 1 1 2 12645.0 None 76
29219 JujVPU7fapWeydnI0000 math/divisors/divisors_of_360.txt All positive divisors of 360 as plain text .txt None None 83 dPwQdtda_ThT-13U_sjXaA None NaN ... True False 2026-08-06 16:54:02.965544+00:00 1 1 1 2 12645.0 None 76
29217 Sdwe8WMSeEGKQVbh0000 results/math/sum_squares_first_50_even.txt Sum of squares of the first 50 even numbers .txt None None 7 rEJ5bn_72WFgqaAl4Pk_bw None NaN ... True False 2026-08-06 16:33:52.222242+00:00 1 1 1 2 12640.0 None 76
29214 xu9q2UnPe0O1FwYt0000 datasets/math/fibonacci_20th.json The 20th Fibonacci number stored in JSON format. .json None None 36 B-yew0i1sL8iv9ADtgoIYQ None NaN ... True False 2026-08-06 16:33:23.868843+00:00 1 1 1 2 12639.0 None 76
29213 eEzb41uRboC2jhoK0000 inputs/math/first_50_even_numbers.txt First 50 even numbers as comma-separated integers .txt None None 146 THFdzn54OtPKvgdAUN7Z-g None NaN ... True False 2026-08-06 16:33:21.419051+00:00 1 1 1 2 NaN None 76
29212 De3Xj5hqtQl7taS30000 configs/fibonacci/nth_20.json Configuration specifying which Fibonacci posit... .json None None 13 dqoPu42JeQS4Jx2Re11dVA None NaN ... True False 2026-08-06 16:33:19.773003+00:00 1 1 1 2 12639.0 None 76
29208 ZzdLyHT9exLFcKW10000 datasets/math/prime_sum_first_100.json Sum and values of the first 100 prime numbers ... .json None None 923 Z7P-2UN4ASB1MeFXcvNgdw None NaN ... True False 2026-08-06 16:05:29.979742+00:00 1 1 1 2 12633.0 None 76
29206 BwGjbYsgPUfSSR1L0000 configs/math/prime_sum_first_100.json Configuration specifying how many prime number... .json None None 18 vz9R4lT82t9zn2abkeoDxQ None NaN ... True False 2026-08-06 16:05:25.888529+00:00 1 1 1 2 12633.0 None 76
29205 ml6u1K8sjEpoZhod0000 datasets/math/factorial_15.json Factorial of 15 stored as JSON. .json None None 43 MWrr2k8ZF72hK4wbWirr6Q None NaN ... True False 2026-08-06 16:05:25.517553+00:00 1 1 1 2 12632.0 None 76
29204 Tp2pMvf7TJBXuYbS0000 configs/math/factorial_15_input.json Configuration for factorial computation. .json None None 13 JL69ZvGDESYcgHwN_1ThJA None NaN ... True False 2026-08-06 16:05:20.833032+00:00 1 1 1 2 12632.0 None 76
29193 c6tPsh1Ext72NKG10000 datasets/math/fibonacci_first_30.json First 30 Fibonacci numbers in JSON format. .json None None 315 0G_bWjuc5BGpuI6zky7pvQ None NaN ... True False 2026-08-06 14:37:16.676596+00:00 1 1 1 2 12621.0 None 76

20 rows × 22 columns

JSON¶

db.Run.filter(params__learning_rate__gt=0.01).to_dataframe()
Show code cell output Hide code cell output
uid id name description entrypoint started_at finished_at params extra_data reference ... created_at branch_id created_on_id space_id transform_id report_id environment_id plan_id created_by_id initiated_by_run_id

0 rows × 23 columns

Here is an example for querying by parameters: Track parameters & features.

previous

LaminDB: data management for traceable, multimodal AI

next

Query tables in storage

Table of contents
  • Basics
    • Get an overview
    • Get one object
    • Search
  • Queries
    • By fields
    • By features
  • Cheat sheet: comparators
    • and
    • less than/ greater than
    • in
    • order by
    • contains
    • startswith
    • or
    • negate/ unequal
    • JSON
© 2026 Lamin Labs · Hub · Docs · Security · Blog · Contact · About · Legal · Imprint · LinkedIn · X · GitHub