Query & search
¶
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
→ connected lamindb: anonymous/docs
• tip: to work with the additional module (pertdb) of database laminlabs/lamindata, configure your environment for 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
! 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 | |||||||||||||||||||||
| 33167 | 6JZQcGHVVaYxKuUQ0000 | probes/probe_artifact.csv | Small probe CSV dataset | .csv | dataset | DataFrame | 61.0 | vnX6jSSm-fztWG9KdnSCuw | None | 3.0 | ... | True | False | 2026-09-22 14:44:45.568391+00:00 | 1467 | 1467 | 1 | 2 | 15742 | None | 76 |
| 33164 | o8EEIaeJfoaBwuwL0000 | probes/child_probe_artifact.csv | Small CSV artifact created by child probe script | .csv | dataset | DataFrame | 59.0 | oOxjLVm2AZnE119_glMGaQ | None | 3.0 | ... | True | False | 2026-09-22 14:33:58.178578+00:00 | 1466 | 1466 | 1 | 2 | 15740 | None | 76 |
| 32405 | G01bYTnXtheyHn6d0000 | clinical/fictional_patient_treatment_summary.csv | Summary statistics of fictional patient record... | .csv | dataset | DataFrame | 295.0 | kNZ4RfZdoiUSCyCTLAZ6Mg | None | 2.0 | ... | True | False | 2026-09-15 08:56:24.179384+00:00 | 1220 | 1220 | 1 | 2 | 15145 | None | 76 |
| 32404 | 40B9zKPoTb0BDOut0000 | clinical/fictional_patient_records.csv | 50 reproducible fictional patient records with... | .csv | dataset | DataFrame | 1327.0 | 4vkKI7HE0q6zOCXoK3HvDw | None | 50.0 | ... | True | False | 2026-09-15 08:56:17.794657+00:00 | 1220 | 1220 | 1 | 2 | 15145 | None | 76 |
| 32402 | QLta8LlkQ2MZzLWf0000 | enzyme-kinetics/michaelis_menten_velocities.csv | Simulated Michaelis–Menten reaction velocities... | .csv | dataset | DataFrame | 1423.0 | U3bADqhnwwvj0kZhx9RQQw | None | 20.0 | ... | True | False | 2026-09-15 08:56:14.912028+00:00 | 1220 | 1220 | 1 | 2 | 15144 | None | 76 |
| 32370 | ThfkwZ82gTSkCfaJ0000 | proteins/human_insulin_b_chain_aa_composition.csv | Amino-acid composition of the human insulin B-... | .csv | dataset | DataFrame | 402.0 | 4AFoDfSYzAljDfRPIqXMqg | None | 16.0 | ... | True | False | 2026-09-15 07:54:32.343772+00:00 | 1220 | 1220 | 1 | 2 | 15119 | None | 76 |
| 32312 | Zd3fI2S5c38M14HH0000 | proteins/human_insulin_b_chain.fasta | Human insulin B-chain amino-acid sequence in F... | .fasta | NaN | NaN | 68.0 | gJBJWTj85Lpe3CIF1PbQnA | None | NaN | ... | True | False | 2026-09-14 14:00:09.229742+00:00 | 1208 | 1208 | 1 | 2 | 15068 | None | 76 |
| 32309 | KluzQbOolGiOtUDR0000 | proteins/human_hemoglobin_beta_amino_acid_comp... | Amino-acid composition of human hemoglobin beta | .csv | dataset | DataFrame | 540.0 | 92zmUgeZhSYC9X-TcdUxvg | None | 20.0 | ... | True | False | 2026-09-14 13:50:13.115164+00:00 | 1204 | 1204 | 1 | 2 | 15066 | None | 76 |
| 32293 | cMQ69rtol53tPidM0000 | proteins/human_insulin_amino_acid_composition.csv | Amino-acid composition of human insulin | .csv | dataset | DataFrame | 505.0 | RxLbYE6_H8oANuUYxHq4CQ | None | 20.0 | ... | True | False | 2026-09-14 13:20:25.114528+00:00 | 1193 | 1193 | 1 | 2 | 15054 | None | 76 |
| 31662 | Bhh82ZsCzzgjKcLc0000 | fasta/human_glucagon_aa_composition.csv | Amino-acid composition (counts and fractions) ... | .csv | dataset | DataFrame | 457.0 | EVXmhMG310d_a6FbyuhCtQ | None | 16.0 | ... | True | False | 2026-09-10 19:33:01.337153+00:00 | 1014 | 1014 | 1 | 2 | 14562 | None | 76 |
| 31658 | 5AKaBSsO7uiI9YLD0000 | fasta/human_glucagon.fasta | Human glucagon (UniProt P01275) protein sequen... | .fasta | NaN | NaN | 61.0 | Cq2HZTTXfHDOmUYg5KF6hQ | None | NaN | ... | True | False | 2026-09-10 19:24:35.209750+00:00 | 1014 | 1014 | 1 | 2 | 14559 | None | 76 |
| 31651 | EVQ4GHXdWyOuvFxB0000 | fasta/human_insulin_b_chain.fasta | Human insulin B-chain sequence (UniProt P01308) | .fasta | NaN | NaN | 68.0 | ixJED8V7zgF3sb9spUNe1g | None | NaN | ... | True | False | 2026-09-10 18:55:10.083392+00:00 | 1013 | 1013 | 1 | 2 | 14554 | None | 76 |
| 31634 | MKUstTC3MvylENNs0002 | fasta/protein.fasta | Small FASTA file containing the human insulin ... | .fasta | NaN | NaN | 66.0 | VbBXwriFzoqK0B5qZy-2lw | None | NaN | ... | True | False | 2026-09-10 14:55:41.516858+00:00 | 1004 | 1004 | 1 | 2 | 14542 | None | 76 |
| 31441 | N2N25ecPjU1uhIRN0000 | fasta/cytochrome_c_human_aa_frequencies.parquet | Amino-acid composition analysis of human cytoc... | .parquet | dataset | DataFrame | 2946.0 | arOXbnDIa8lATHRFYegTfQ | None | 20.0 | ... | True | False | 2026-09-08 22:10:17.518495+00:00 | 1 | 1 | 1 | 2 | 14388 | None | 76 |
| 31438 | x7gkzDW9dDIXjMgF0000 | fasta/cytochrome_c_human.fasta | Human cytochrome c (CYCS, UniProt P99999) prot... | .fasta | NaN | NaN | 183.0 | 6rYbxRvZr5LftJaBZ3Ltaw | None | NaN | ... | True | False | 2026-09-08 22:08:58.275001+00:00 | 1 | 1 | 1 | 2 | 14387 | None | 76 |
| 31435 | tna1ksLbhUUZCiNz0000 | fasta/myoglobin_human.fasta | Human myoglobin (UniProt P02144) protein seque... | .fasta | NaN | NaN | 228.0 | zsyBEtGSPvAfNyBBm4pNGg | None | NaN | ... | True | False | 2026-09-08 22:03:16.717387+00:00 | 971 | 971 | 1 | 2 | 14385 | None | 76 |
| 31433 | fUvBvCy30c1kU7WL0000 | fasta/hemoglobin_beta_composition.json | Sequence length and amino-acid composition of ... | .json | NaN | NaN | 295.0 | OCWUFB7v0hgnJ4Lg_T32lQ | None | NaN | ... | True | False | 2026-09-08 21:38:43.107004+00:00 | 971 | 971 | 1 | 2 | 14383 | None | 76 |
| 31430 | xS7uxgbJ3ktfyjWG0000 | fasta/hemoglobin_beta.fasta | Human hemoglobin subunit beta (HBB, UniProt P6... | .fasta | NaN | NaN | 236.0 | yU8iOxOXnun5htqDB8lxYA | None | NaN | ... | True | False | 2026-09-08 21:37:16.475631+00:00 | 971 | 971 | 1 | 2 | 14382 | None | 76 |
| 31415 | W3q98o3Rxv5wxiS40000 | NaN | mix-test | .txt | NaN | NaN | 62.0 | xMtGxadDGhAvlDQKmNJ_ZA | None | NaN | ... | True | False | 2026-09-08 20:30:51.088739+00:00 | 1 | 1 | 1 | 2 | NaN | None | 3 |
| 31414 | Uu0CthUXD2BP4MMr0000 | NaN | upload2 | .txt | NaN | NaN | 54.0 | wzKrXgQvmWqiM4yGu9uEOA | None | NaN | ... | True | False | 2026-09-08 20:23:51.195724+00:00 | 1 | 1 | 1 | 2 | NaN | None | 3 |
20 rows × 22 columns
Include fields from other registries with the __ syntax:
db.Artifact.to_dataframe(include=["created_by__handle"])
Show code cell output
! truncated query result to limit=20 Artifact objects
| uid | key | created_by__handle | |
|---|---|---|---|
| id | |||
| 33167 | 6JZQcGHVVaYxKuUQ0000 | probes/probe_artifact.csv | ebad |
| 33164 | o8EEIaeJfoaBwuwL0000 | probes/child_probe_artifact.csv | ebad |
| 32405 | G01bYTnXtheyHn6d0000 | clinical/fictional_patient_treatment_summary.csv | ebad |
| 32404 | 40B9zKPoTb0BDOut0000 | clinical/fictional_patient_records.csv | ebad |
| 32402 | QLta8LlkQ2MZzLWf0000 | enzyme-kinetics/michaelis_menten_velocities.csv | ebad |
| 32370 | ThfkwZ82gTSkCfaJ0000 | proteins/human_insulin_b_chain_aa_composition.csv | ebad |
| 32312 | Zd3fI2S5c38M14HH0000 | proteins/human_insulin_b_chain.fasta | ebad |
| 32309 | KluzQbOolGiOtUDR0000 | proteins/human_hemoglobin_beta_amino_acid_comp... | ebad |
| 32293 | cMQ69rtol53tPidM0000 | proteins/human_insulin_amino_acid_composition.csv | ebad |
| 31662 | Bhh82ZsCzzgjKcLc0000 | fasta/human_glucagon_aa_composition.csv | ebad |
| 31658 | 5AKaBSsO7uiI9YLD0000 | fasta/human_glucagon.fasta | ebad |
| 31651 | EVQ4GHXdWyOuvFxB0000 | fasta/human_insulin_b_chain.fasta | ebad |
| 31634 | MKUstTC3MvylENNs0002 | fasta/protein.fasta | ebad |
| 31441 | N2N25ecPjU1uhIRN0000 | fasta/cytochrome_c_human_aa_frequencies.parquet | ebad |
| 31438 | x7gkzDW9dDIXjMgF0000 | fasta/cytochrome_c_human.fasta | ebad |
| 31435 | tna1ksLbhUUZCiNz0000 | fasta/myoglobin_human.fasta | ebad |
| 31433 | fUvBvCy30c1kU7WL0000 | fasta/hemoglobin_beta_composition.json | ebad |
| 31430 | xS7uxgbJ3ktfyjWG0000 | fasta/hemoglobin_beta.fasta | ebad |
| 31415 | W3q98o3Rxv5wxiS40000 | NaN | Koncopd |
| 31414 | Uu0CthUXD2BP4MMr0000 | NaN | Koncopd |
Get an overview of all most recent objects in the database:
db.view()
Show 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 | |||||||||||||||||||||
| 33167 | 6JZQcGHVVaYxKuUQ0000 | probes/probe_artifact.csv | Small probe CSV dataset | .csv | dataset | DataFrame | 61.0 | vnX6jSSm-fztWG9KdnSCuw | None | 3.0 | ... | True | False | 2026-09-22 14:44:45.568391+00:00 | 1467 | 1467 | 1 | 2 | 15742 | None | 76 |
| 33164 | o8EEIaeJfoaBwuwL0000 | probes/child_probe_artifact.csv | Small CSV artifact created by child probe script | .csv | dataset | DataFrame | 59.0 | oOxjLVm2AZnE119_glMGaQ | None | 3.0 | ... | True | False | 2026-09-22 14:33:58.178578+00:00 | 1466 | 1466 | 1 | 2 | 15740 | None | 76 |
| 32405 | G01bYTnXtheyHn6d0000 | clinical/fictional_patient_treatment_summary.csv | Summary statistics of fictional patient record... | .csv | dataset | DataFrame | 295.0 | kNZ4RfZdoiUSCyCTLAZ6Mg | None | 2.0 | ... | True | False | 2026-09-15 08:56:24.179384+00:00 | 1220 | 1220 | 1 | 2 | 15145 | None | 76 |
| 32404 | 40B9zKPoTb0BDOut0000 | clinical/fictional_patient_records.csv | 50 reproducible fictional patient records with... | .csv | dataset | DataFrame | 1327.0 | 4vkKI7HE0q6zOCXoK3HvDw | None | 50.0 | ... | True | False | 2026-09-15 08:56:17.794657+00:00 | 1220 | 1220 | 1 | 2 | 15145 | None | 76 |
| 32402 | QLta8LlkQ2MZzLWf0000 | enzyme-kinetics/michaelis_menten_velocities.csv | Simulated Michaelis–Menten reaction velocities... | .csv | dataset | DataFrame | 1423.0 | U3bADqhnwwvj0kZhx9RQQw | None | 20.0 | ... | True | False | 2026-09-15 08:56:14.912028+00:00 | 1220 | 1220 | 1 | 2 | 15144 | None | 76 |
| 32370 | ThfkwZ82gTSkCfaJ0000 | proteins/human_insulin_b_chain_aa_composition.csv | Amino-acid composition of the human insulin B-... | .csv | dataset | DataFrame | 402.0 | 4AFoDfSYzAljDfRPIqXMqg | None | 16.0 | ... | True | False | 2026-09-15 07:54:32.343772+00:00 | 1220 | 1220 | 1 | 2 | 15119 | None | 76 |
| 32312 | Zd3fI2S5c38M14HH0000 | proteins/human_insulin_b_chain.fasta | Human insulin B-chain amino-acid sequence in F... | .fasta | NaN | NaN | 68.0 | gJBJWTj85Lpe3CIF1PbQnA | None | NaN | ... | True | False | 2026-09-14 14:00:09.229742+00:00 | 1208 | 1208 | 1 | 2 | 15068 | 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... | NaN | None | None | None | True | False | 2026-07-29 22:29:08.441329+00:00 | 1 | 1 | 1 | 20 | NaN | 229 | 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 | NaN | 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... | NaN | vpleElXxZiaZblQ09q9K-g | None | None | None | True | False | 2026-01-28 23:40:21.984321+00:00 | 1 | 1 | 1 | 18 | 2250 | NaN | None |
| 50 | H1AlT19wFq7HdHqZ0000 | View Habib17 (h5ad) in Vitessce | NaN | hmrSAi0jDsrxvo9Oy3Hiqg | None | None | None | True | False | 2026-01-20 20:28:39.313883+00:00 | 1 | 1 | 1 | 18 | 1934 | NaN | None |
| 49 | p46U2L7tUlotAAkI0000 | View Xenium_V1_humanLung_Cancer_FFPE_he_image ... | NaN | 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 | NaN | QUraKB3k9PERvsRza4ycCQ | None | None | None | True | False | 2025-11-30 22:35:25.029942+00:00 | 1 | 1 | 1 | 9 | 1591 | 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 | |||||||||||||||||||||
| 774 | e9FQfTbe94WM | xferbench_note | str | None | None | 0 | 0 | None | None | None | ... | None | False | False | 2026-09-16 10:36:52.715455+00:00 | 1 | 1 | 1 | 60 | 15215 | None |
| 773 | p2S3xd6oFl8E | xferbench_date | date | None | None | 0 | 0 | None | None | None | ... | None | False | False | 2026-09-16 10:36:52.143674+00:00 | 1 | 1 | 1 | 60 | 15215 | None |
| 772 | I4EDx3reEbK6 | xferbench_n_samples | int | None | None | 0 | 0 | None | None | None | ... | None | False | False | 2026-09-16 10:36:51.562201+00:00 | 1 | 1 | 1 | 60 | 15215 | None |
| 771 | ZP2RbbaxPmvJ | xferbench_treatment | str | None | None | 0 | 0 | None | None | None | ... | None | False | False | 2026-09-16 10:36:51.105332+00:00 | 1 | 1 | 1 | 60 | 15215 | None |
| 770 | JL7bN6sz9X50 | xferbench_qc_status | cat[ULabel[suHk8o2k]] | None | None | 0 | 0 | None | None | None | ... | None | False | False | 2026-09-16 10:36:50.480587+00:00 | 1 | 1 | 1 | 60 | 15215 | None |
| 769 | FM3eaRqkFmrH | xferbench_samples | list[cat[Record[8kevjYnegidPu8P2]]] | None | None | 0 | 0 | None | None | None | ... | None | False | False | 2026-09-16 10:36:50.027247+00:00 | 1 | 1 | 1 | 60 | 15215 | None |
| 768 | kHUxs4a7qsHp | xferbench_treated | bool | None | None | 0 | 0 | None | None | None | ... | None | False | False | 2026-09-16 10:36:47.569334+00:00 | 1 | 1 | 1 | 60 | 15215 | None |
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 | ||||||||||||||||
| 79 | wPC2QrhipjSY | Space issue debugging | None | None | None | None | None | False | True | 2026-08-06 10:57:15.128752+00:00 | 1 | 1 | 37 | 60 | NaN | 74 |
| 78 | LGBhpB09J1b2 | Space issue debugging | None | None | None | None | None | False | True | 2026-08-06 09:47:20.412192+00:00 | -1 | 1 | 37 | 60 | 12591 | NaN |
| 77 | f71hDEwbOjqx | Space debugging | None | None | None | None | None | False | False | 2026-08-06 09:45:28.864762+00:00 | 1 | 1 | 1 | 60 | NaN | NaN |
| 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 | NaN | NaN |
| 75 | OU7MHu1D2q2s | Space debugging | None | None | None | None | None | False | True | 2026-08-06 09:24:12.296292+00:00 | 1 | 1 | 37 | 60 | NaN | 74 |
| 74 | KrzaeLA1wPV1 | Program Type | None | None | None | None | None | False | True | 2026-08-06 09:24:11.347019+00:00 | 1 | 1 | 1 | 60 | NaN | NaN |
| 73 | dLGPJoG8TQhd | Space debugging | None | None | None | None | None | False | True | 2026-08-06 09:18:32.052879+00:00 | -1 | 1 | 1 | 60 | NaN | NaN |
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 | ||||||||||||||||
| 75026 | wnb2mNHX9gTSTCHJ | None | None | None | None | None | False | False | 2026-09-24 07:56:45.221928+00:00 | 1 | 1 | 1 | 18 | 2759 | None | 15869 |
| 75025 | S8hcjjuGCVQJlzut | None | None | None | None | None | False | False | 2026-09-24 07:56:32.377760+00:00 | 1 | 1 | 1 | 18 | 611 | None | 15868 |
| 75024 | qg8B5KAegFKYiJxa | None | None | None | None | None | False | False | 2026-09-24 07:56:19.811773+00:00 | 1 | 1 | 1 | 18 | 2319 | None | 15867 |
| 75023 | RVXFWRFGcOBmF9jX | None | None | None | None | None | False | False | 2026-09-23 10:32:45.805996+00:00 | 1 | 1 | 1 | 18 | 2759 | None | 15791 |
| 75022 | Az5HphPI3uOQB36a | None | None | None | None | None | False | False | 2026-09-23 10:32:34.259259+00:00 | 1 | 1 | 1 | 18 | 611 | None | 15790 |
| 75021 | Ee1IQoAHDpqXgjpF | None | None | None | None | None | False | False | 2026-09-23 10:32:23.087119+00:00 | 1 | 1 | 1 | 18 | 2319 | None | 15789 |
| 75020 | vwO3zfnR1L5WZ5D8 | None | None | None | None | None | False | False | 2026-09-22 19:52:14.618507+00:00 | 1 | 1 | 1 | 18 | 2759 | None | 15759 |
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... | NaN | https://doi.org/10.1038/nbt.3820 | NaN | NaN | NaN | 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... | NaN | Schmidt22 | NaN | 35113687.0 | NaN | Regulation of cytokine production in stimulate... | None | False | False | 2025-09-28 14:05:36.774006+00:00 | 1 | 1 | 1 | 9 | 840 | None |
| 3 | v19l0ASlvdLj | SEA-AD: Seattle Alzheimer’s Disease Brain Cell... | The Seattle Alzheimer's Disease Brain Cell Atl... | NaN | https://cellxgene.cziscience.com/collections/1... | NaN | 10.1038/s41593-024-01774-5 | NaN | 2022-05-31 | False | False | 2024-11-25 11:13:49.872888+00:00 | 1 | 1 | 1 | 30 | 501 | None |
| 2 | XVqpeeo4rOGh | Spatially mapping T cell receptors and transcr... | This repository contains data from our manuscr... | NaN | https://cellxgene.cziscience.com/collections/0... | NaN | 10.1016/j.immuni.2022.09.002 | NaN | 2023-09-29 | False | False | 2024-11-25 10:31:38.620076+00:00 | 1 | 1 | 1 | 30 | 501 | None |
| 1 | 1XqufHiwjUaq | Multiplexed single-cell transcriptional respon... | NaN | 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 | |||||||||||||||||||||
| 15889 | 6GigwRIo1stLLziT | None | None | NaN | 2026-09-24 12:39:21.738503+00:00 | NaT | None | None | None | None | ... | 2026-09-24 12:39:21.738503+00:00 | 1 | 1 | 1 | 1792 | NaN | 33356 | None | 9 | None |
| 15888 | pUmSRAuOEIqCgrcO | None | None | check | 2026-09-24 12:30:40.232753+00:00 | 2026-09-24 12:30:46.436682+00:00 | {'no_run': False, 'repeats': 4, 'threshold': 1.5} | None | None | None | ... | 2026-09-24 12:30:40.232753+00:00 | 1 | 1 | 1 | 1413 | 33355 | 33352 | None | 18 | None |
| 15887 | 4oErpUfgrJTZHuog | None | None | check | 2026-09-24 12:30:28.510749+00:00 | 2026-09-24 12:30:34.647643+00:00 | {'no_run': False, 'repeats': 4, 'threshold': 1.5} | None | None | None | ... | 2026-09-24 12:30:28.510749+00:00 | 1 | 1 | 1 | 1413 | 33354 | 33352 | None | 18 | None |
| 15886 | 8AjhnBAE7gHOBD9x | None | None | check | 2026-09-24 12:30:09.560887+00:00 | 2026-09-24 12:30:23.709921+00:00 | {'no_run': False, 'repeats': 4, 'threshold': 3.5} | None | None | None | ... | 2026-09-24 12:30:09.560887+00:00 | 1 | 1 | 1 | 1413 | 33353 | 33352 | None | 18 | None |
| 15885 | LOkT6Fc8RA9LyKiJ | None | None | check | 2026-09-24 12:03:59.555135+00:00 | 2026-09-24 12:04:04.741734+00:00 | {'no_run': False, 'repeats': 4, 'threshold': 1.5} | None | None | None | ... | 2026-09-24 12:03:59.555135+00:00 | 1 | 1 | 1 | 1413 | 33351 | 33348 | None | 18 | None |
| 15884 | phIsmaxpxbIFgmxL | None | None | check | 2026-09-24 12:03:50.431104+00:00 | 2026-09-24 12:03:55.482307+00:00 | {'no_run': False, 'repeats': 4, 'threshold': 1.5} | None | None | None | ... | 2026-09-24 12:03:50.431104+00:00 | 1 | 1 | 1 | 1413 | 33350 | 33348 | None | 18 | None |
| 15883 | Jc8JQHD0ZHQOfXvw | None | None | check | 2026-09-24 12:03:35.927853+00:00 | 2026-09-24 12:03:46.809671+00:00 | {'no_run': False, 'repeats': 4, 'threshold': 3.5} | None | None | None | ... | 2026-09-24 12:03:35.927853+00:00 | 1 | 1 | 1 | 1413 | 33349 | 33348 | 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 | |||||||||||||||||||||
| 262 | 09pdMItyqpSpp2wn | xferbench_experiment_schema | None | 6.0 | None | False | Feature | None | None | upTQGp-oddPwUS38tj8nmw | ... | False | False | False | 2026-09-16 10:36:53.306152+00:00 | 1 | 1 | 1 | 60 | 15215 | None |
| 261 | 5Lhx12bUOi5OoWGP | xferbench_sample_schema | None | 3.0 | None | False | Feature | None | None | 1w-XLSqJGsqLzTDVQiOEew | ... | False | False | False | 2026-09-16 10:36:48.141850+00:00 | 1 | 1 | 1 | 60 | 15215 | None |
| 260 | U4Q6kRvkeHjPSVTo | xferbench_donor_schema | None | 2.0 | None | False | Feature | None | None | Blysp9VGabriCn73qWnvfQ | ... | False | False | False | 2026-09-16 10:36:44.374795+00:00 | 1 | 1 | 1 | 60 | 15215 | None |
| 259 | hXyVCL89wsTtMjpg | nf-core/proteinfold input | None | 2.0 | True | False | Feature | None | None | 2ulsT0d5w3hmBZcP_bs36w | ... | False | False | False | 2026-08-21 10:47:13.579757+00:00 | 1 | 1 | 1 | 2 | NaN | None |
| 258 | 3RpySfk5IOSZ5gv7 | nf-core/methylseq input with sample link | None | 4.0 | True | False | Feature | None | None | RqFmVCqi7mXq7os5d0wOVQ | ... | False | False | False | 2026-08-21 10:47:11.899753+00:00 | 1 | 1 | 1 | 2 | NaN | None |
| 257 | ta9tRj6ohahwD9Me | nf-core/crisprseq targeted input with sample link | None | 6.0 | True | False | Feature | None | None | NGdsJQUw9YMPeHYCwCyJhQ | ... | False | False | False | 2026-08-21 10:47:10.225990+00:00 | 1 | 1 | 1 | 2 | NaN | None |
| 256 | Miam1meXOpW8GMAZ | nf-core/chipseq input with sample link | None | 5.0 | True | False | Feature | None | None | wwJM8x5vHyoL-0SW0TMw5A | ... | False | False | False | 2026-08-21 10:47:08.551482+00:00 | 1 | 1 | 1 | 2 | NaN | None |
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 | |||||||||||||
| 65 | I5vhvNJq9EJF | s3://lamin-us-east-1/I5vhvNJq9EJF | None | s3 | us-east-1 | 4XIuR0tvaiXM | False | 2026-08-06 07:27:27.965079+00:00 | 1 | 1 | 37 | 9 | NaN |
| 64 | BN5hkmpQV3A5 | s3://cellxgene-census-public-us-west-2 | None | s3 | us-west-2 | NaN | False | 2026-08-05 13:06:18.181461+00:00 | 1 | 1 | 1 | 60 | 12513 |
| 63 | ytKACRVv0kZX | s3://ngi-igenomes | None | s3 | eu-west-1 | NaN | False | 2026-07-23 07:40:47.354980+00:00 | 1 | 1 | 1 | 54 | NaN |
| 62 | VHK54QHjGJwM | https://ftp.ensembl.org | None | https | NaN | NaN | 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 | NaN | NaN | 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 | NaN | False | 2026-05-21 08:57:21.367940+00:00 | 1 | 1 | 1 | 54 | NaN |
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 | |||||||||||||||||||
| 1820 | ybiORS7u2cyD0000 | write_probe_csv.py | None | script | import pandas as pd\nimport lamindb as ln\n\nl... | WzrR-wd65Z1gusf-sMoiMw | None | None | None | True | False | 2026-09-22 14:44:43.719619+00:00 | 1467 | 1467 | 1 | None | None | 15741 | 76 |
| 1819 | EewE1LOV4req0000 | create_probe_csv.py | None | script | """Self-tracking script: create a small CSV ar... | B7-FHQA566f3ZAhe3eeARg | None | None | None | True | False | 2026-09-22 14:33:52.358482+00:00 | 1466 | 1466 | 1 | None | None | 15739 | 76 |
| 1818 | KH94KXtabo7Q0002 | create_complex_source.py | None | script | """Build a nested record graph on lamindata fo... | UVkP6uy8_FfEMQaiGECBCg | None | None | None | True | False | 2026-09-16 11:05:10.399138+00:00 | 1 | 1 | 1 | None | None | NaN | 60 |
| 1817 | KH94KXtabo7Q0001 | create_complex_source.py | None | script | """Build a nested record graph on lamindata fo... | o29gyra_S0__qaHuVahqJA | None | None | None | False | False | 2026-09-16 11:01:11.435527+00:00 | 1 | 1 | 1 | None | None | NaN | 60 |
| 1816 | KH94KXtabo7Q0000 | create_complex_source.py | None | script | """Build a nested record graph on lamindata fo... | gqwqbDOhzK4u2LPcW5443A | None | None | None | False | False | 2026-09-16 10:36:34.224102+00:00 | 1 | 1 | 1 | None | None | NaN | 60 |
| 1815 | LSAQXbD6rGdg0000 | generate_patient_records.py | None | script | """Generate reproducible fictional patient rec... | VBGshtrpm5piegpXSnuodQ | None | None | None | True | False | 2026-09-15 08:56:15.161342+00:00 | 1220 | 1220 | 1 | None | None | 15143 | 76 |
| 1814 | vUiKJplO1dRL0000 | simulate_michaelis_menten.py | None | script | """Simulate a Michaelis–Menten enzyme kinetics... | wPNhfrR_EBZk1RRifAG1hQ | None | None | None | True | False | 2026-09-15 08:56:03.278169+00:00 | 1220 | 1220 | 1 | None | None | 15142 | 76 |
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 | ||||||||||||||
| 870 | no2mLCN3 | xferbench_fail | None | None | None | False | False | 2026-09-16 10:36:42.764603+00:00 | 1 | 1 | 1 | 60 | 15215 | 868 |
| 869 | TVP0pu9R | xferbench_pass | None | None | None | False | False | 2026-09-16 10:36:42.307325+00:00 | 1 | 1 | 1 | 60 | 15215 | 868 |
| 868 | suHk8o2k | xferbench_qc | None | None | None | False | True | 2026-09-16 10:36:41.837480+00:00 | 1 | 1 | 1 | 60 | 15215 | NaN |
| 781 | 1HB4MOep | day | None | None | None | False | False | 2026-08-21 08:43:08.599750+00:00 | 1 | 1 | 1 | 2 | NaN | 425 |
| 780 | yvYm5DuA | h | None | None | None | False | False | 2026-08-21 08:43:08.104982+00:00 | 1 | 1 | 1 | 2 | NaN | 425 |
| 777 | f0vQmjTM | qPCR | None | None | None | False | False | 2026-08-20 12:28:33.077386+00:00 | 1 | 1 | 1 | 2 | NaN | 316 |
| 776 | vSfLr3qc | ELISA | None | None | None | False | False | 2026-08-20 12:28:32.586336+00:00 | 1 | 1 | 1 | 2 | NaN | 316 |
******************
* 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 | NaN | An immortal epithelial cell line cell that der... | False | 2026-04-28 11:23:46.687389+00:00 | 1 | 1 | 1 | 46 | 7001 | 9 |
| 249 | 3mYHwNTcJYDLrt | immortal epithelial cell line cell | CLO:0000129 | None | NaN | a immortal animal cell line that is derived fr... | False | 2026-04-28 11:23:46.687389+00:00 | 1 | 1 | 1 | 46 | 7001 | 9 |
| 248 | 45i0CvX67rIhVi | immortal human uterine cervix-derived epitheli... | CLO:0000636 | None | NaN | An immortal uterine cervix-derived epithelial ... | False | 2026-04-28 11:23:45.353143+00:00 | 1 | 1 | 1 | 46 | 7001 | 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 | 9 |
| 246 | 1n5kUkyJP7ekyJ | immortal human blood cell line cell | CLO:0000617 | None | NaN | 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 | NaN | None | CD14/19 | NaN | NaN | NaN | False | 2023-10-04 16:08:58.846323+00:00 | 1 | 1 | 1 | 2 | None | NaN | 2 |
| 82 | 1iLDs6cZIpxjB6 | None | NaN | None | CD69 | CD69 | 969 | Q07108 | False | 2023-10-04 16:08:40.134192+00:00 | 1 | 1 | 1 | 2 | None | 7 | 2 |
| 81 | 31nZfqQo8yZgeb | None | NaN | None | CD103 | ITGAE | 3682 | P38570 | False | 2023-10-04 16:08:40.134170+00:00 | 1 | 1 | 1 | 2 | None | 7 | 2 |
| 80 | 5c4A0r7gMiGwGk | None | NaN | None | CD95 | FAS | 2194 | P49327 | False | 2023-10-04 16:08:40.134151+00:00 | 1 | 1 | 1 | 2 | None | 7 | 2 |
| 79 | 3IPMBjs68Vy1oM | None | NaN | None | CXCR4 | CXCR4 | 7852 | P61073 | False | 2023-10-04 16:08:40.134128+00:00 | 1 | 1 | 1 | 2 | None | 7 | 2 |
| 78 | 525YfNUB967zee | None | NaN | None | CD49B | ITGA2 | 3673 | P17301 | False | 2023-10-04 16:08:40.134091+00:00 | 1 | 1 | 1 | 2 | None | 7 | 2 |
| 77 | 3l9bWDSZiukI6O | None | LIVE/DEAD | None | Dead | NaN | NaN | NaN | 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 | NaN | None | None | NaN | False | 2026-04-14 08:59:53.779824+00:00 | 1 | 1 | 1 | 9 | 6113 | NaN |
| 220 | 23ekfCDhJCSN44 | cancer associated fibroblast | NaN | None | None | NaN | False | 2026-04-14 08:59:53.779824+00:00 | 1 | 1 | 1 | 9 | 6113 | 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 | 64 |
| 218 | 7KCFubjGu7ok8G | iPSC-induced neuron | NaN | None | None | NaN | 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 |
| 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 |
| 215 | 1e5QBUmKJGM4e9 | visual pigment cell | CL:0000149 | None | None | NaN | False | 2025-01-06 12:00:39.805825+00:00 | 1 | 1 | 1 | 2 | NaN | 65 |
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 | NaN | 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 |
| 42 | 5q73MbS33MJVGx | 85-year-old human stage | HsapDv:0000211 | None | NaN | 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 |
| 41 | 5QzRYqqcaGITDU | 84-year-old human stage | HsapDv:0000210 | None | NaN | 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 |
| 40 | 3MeD86peox5beX | 82-year-old human stage | HsapDv:0000208 | None | NaN | 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 |
| 39 | 1FAjljBZPandRY | 81-year-old human stage | HsapDv:0000207 | None | NaN | 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 |
| 38 | 2nEVCZzoSi6YS2 | 80-year-old human stage | HsapDv:0000206 | None | NaN | 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 |
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 | NaN | NaN | 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 | NaN | 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 | NaN | NaN | Includes Individuals Who Either Self-Report Or... | False | 2024-12-05 16:37:41.019432+00:00 | 1 | 1 | 1 | 3 | 384 | 51 |
| 5 | 67yD7yy4XCWOLA | African American | HANCESTRO:0568 | NaN | NaN | NaN | False | 2024-12-05 16:37:40.220495+00:00 | 1 | 1 | 1 | 3 | 384 | 51 |
| 4 | 2dwBSQ1z0XEYfL | Asian | HANCESTRO:0008 | NaN | 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 |
| 3 | 5HWRj1ODkb6V1S | unknown | unknown | NaN | NaN | 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 | NaN | ancestral group | Population Category Defined Using Ancestry Inf... | False | 2024-06-05 12:09:31.274046+00:00 | 1 | 1 | 1 | 2 | 181 | 51 |
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 | ||||||||||||||
| 63 | 2CIIhUdxb6DU9a | NEBNext Ultra II RNA Library Prep | NaN | None | NEBNext Ultra II RNA | NaN | False | 2026-08-20 12:38:44.401629+00:00 | 1 | 1 | 1 | 2 | None | NaN |
| 62 | 13FoJ8KuqrUbp7 | Illumina stranded mRNA library construction | NaN | None | Illumina Stranded mRNA | NaN | False | 2026-08-20 12:38:43.915132+00:00 | 1 | 1 | 1 | 2 | None | NaN |
| 61 | 7BkAKOrhPpOCZy | Illumina NextSeq 2000 | NaN | None | NextSeq 2000 | NaN | False | 2026-08-20 12:38:43.428186+00:00 | 1 | 1 | 1 | 2 | None | NaN |
| 60 | 011TlgkJL8DA4D | Illumina NovaSeq X Plus | NaN | None | NovaSeq X Plus | NaN | False | 2026-08-20 12:38:42.916927+00:00 | 1 | 1 | 1 | 2 | None | NaN |
| 59 | 3C8KLOGpZkHsC5 | RNA-Seq | EFO:0008896 | None | NaN | 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 |
| 58 | 3VAgTSkxVwvsyT | Xenium Spatial Gene Expression | NaN | None | Xenium|10X Xenium | NaN | False | 2025-12-09 12:46:38.150561+00:00 | 1 | 1 | 1 | 40 | None | NaN |
| 57 | 2UEkfRqukGb1oI | TraCe-seq | NaN | None | NaN | NaN | False | 2025-01-08 12:43:38.479402+00:00 | 1 | 1 | 1 | 2 | None | NaN |
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 | NaN | novel protein | NaN | 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 | NaN | novel transcript | NaN | None | ENSG00000293599 | None | lncRNA | False | 2025-10-26 14:38:48.560365+00:00 | 1 | 1 | 1 | 9 | 1260 | 55 | 2 |
| 154344 | 12nPu7ce9hLZ4k | None | NaN | 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 | NaN | novel transcript | NaN | 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 | NaN | ribosomal protein L41 (RPL41) pseudogene | NaN | 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 | NaN | 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 | NaN | None | Hominidae | False | 2026-08-04 05:42:35.762334+00:00 | 1 | 1 | 1 | 60 | 12367 | 36 |
| 49 | 6yRA7MaNmfnZHP | homininae | NCBITaxon:207598 | None | NaN | None | Homininae | False | 2026-08-04 05:42:35.762334+00:00 | 1 | 1 | 1 | 60 | 12367 | 36 |
| 48 | 7I2BNel8LGSlFQ | chimpanzees | NCBITaxon:9596 | None | NaN | 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 |
| 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 |
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 | |||||||||||||||||||
| 134 | 7au3ZQrD | bionty.Ethnicity | human | hancestro | 2025-10-14 | False | False | Human Ancestry Ontology | http://purl.obolibrary.org/obo/hancestro/relea... | None | https://github.com/EBISPOT/hancestro | False | 2026-08-20 14:21:37.383011+00:00 | 1 | 1 | 1 | 2 | None | None |
| 133 | 6na9vRls | bionty.DevelopmentalStage | mouse | mmusdv | 2025-01-23 | False | False | Mouse Developmental Stages | https://github.com/obophenotype/developmental-... | None | https://github.com/obophenotype/developmental-... | False | 2026-08-20 14:21:37.130015+00:00 | 1 | 1 | 1 | 2 | None | None |
| 132 | 7JO1x6p1 | bionty.DevelopmentalStage | human | hsapdv | 2025-01-23 | False | False | Human Developmental Stages | https://github.com/obophenotype/developmental-... | None | https://github.com/obophenotype/developmental-... | False | 2026-08-20 14:21:36.874259+00:00 | 1 | 1 | 1 | 2 | None | None |
| 131 | 5ax0h5Ue | bionty.Pathway | all | pw | 7.96 | False | False | Pathway Ontology | http://purl.obolibrary.org/obo/pw/7.96/pw.owl | None | https://www.ebi.ac.uk/ols/ontologies/pw | False | 2026-08-20 14:21:35.128816+00:00 | 1 | 1 | 1 | 2 | None | None |
| 130 | 2UZHts8n | bionty.Pathway | all | go | 2025-10-10 | False | False | Gene Ontology | http://purl.obolibrary.org/obo/go/releases/202... | None | http://geneontology.org | False | 2026-08-20 14:21:34.876775+00:00 | 1 | 1 | 1 | 2 | None | None |
| 129 | h5EFbQNJ | bionty.Phenotype | human | hp | 2026-01-08 | False | False | Human Phenotype Ontology | https://github.com/obophenotype/human-phenotyp... | None | https://hpo.jax.org | False | 2026-08-20 14:21:34.093729+00:00 | 1 | 1 | 1 | 2 | None | None |
| 128 | 2rMQe2ZH | bionty.Phenotype | all | pato | 2025-05-14 | False | False | Phenotype And Trait Ontology | http://purl.obolibrary.org/obo/pato/releases/2... | None | https://github.com/pato-ontology/pato | False | 2026-08-20 14:21:33.841764+00:00 | 1 | 1 | 1 | 2 | None | None |
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 | NaN | 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 | NaN | 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 | NaN | 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 |
! 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).
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
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
| 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 | NaN | Iris study 1 - after measuring sepal & petal m... | .parquet | NaN | DataFrame | 5347.0 | ZVkGt2eQubiGc79aOcRfVQ | NaN | None | ... | True | False | 2024-06-06 11:13:05.179131+00:00 | 1 | 1 | 1 | 2 | 206 | None | 2 |
| 683 | 2r8SFCH8TlydF0xnb0Uk | iris_studies/study1_raw_images | NaN | NaN | NaN | 642480.0 | Iip0GzbvjACYC2O7ZrtZiQ | 49.0 | None | ... | True | False | 2024-05-23 16:10:13.728116+00:00 | 1 | 1 | 1 | 2 | 173 | None | 9 | |
| 684 | BWL7PYFvsZ8jA8YJOCz6 | iris_studies/study2_raw_images | NaN | NaN | NaN | 667449.0 | BfyPwSCYPaHRKe4bJk7yRw | 51.0 | None | ... | True | False | 2024-05-23 16:10:13.895052+00:00 | 1 | 1 | 1 | 2 | 173 | None | 9 | |
| 682 | K415DrXcuPiJmXlX5iXH | iris_studies/study0_raw_images | NaN | NaN | NaN | 658465.0 | IVKGMfNwi8zKvnpaD_gG7w | 51.0 | None | ... | False | False | 2024-05-23 16:10:13.393304+00:00 | 1 | 1 | 1 | 2 | 173 | None | 9 | |
| 25855 | K415DrXcuPiJmXlX5iXI | iris_studies/study0_raw_images | NaN | NaN | NaN | 658486.0 | tt98Ho0i3BlFtV84BlI6Dw | 52.0 | None | ... | True | False | 2026-07-07 12:24:59.162462+00:00 | 1 | 1 | 1 | 2 | NaN | None | 46 | |
| 17799 | ZIMVu6cUu2nkyXuK0000 | NaN | log streams of run Xk1i2GFNykkkijDj | .txt | __lamindb_run__ | NaN | 12430.0 | GIRIs96TiSR4dAp4XC5hZA | NaN | None | ... | True | False | 2026-03-20 16:42:05.673008+00:00 | 1 | 1 | 1 | 2 | NaN | None | 18 |
| 23857 | r9b1iRIs7xuCzk7j0000 | NaN | log streams of run vaRP1uN7dBA9to9O | .txt | __lamindb_run__ | NaN | 15497.0 | 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... | NaN | .jpg | NaN | NaN | 14529.0 | e0Gct8LodEyQzNwy1glOPA | NaN | None | ... | True | False | 2026-07-14 14:51:33.166215+00:00 | 1 | 1 | 1 | 2 | NaN | None | 46 |
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
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
<ArtifactQuerySet [Artifact(uid='TxO5CS0h77it3cEl0001', key='nf-core/scrnaseq/samplesheet-2-0.csv', description=None, suffix='.csv', kind='dataset', otype='DataFrame', size=850.0, hash='6NgnIPdAYcwCDbcikid6ZQ', n_files=None, n_observations=3.0, 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.0, 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.0, hash='XARxkaA_Xhcs5yNjlsdWTQ', n_files=None, n_observations=3.0, 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.0, hash='y7GGkIq-Pz3U37HLHoBKTA', n_files=None, n_observations=3.0, 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.0, 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.0, 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.0, 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.0, 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.0, 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.0, 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.0, 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.0, 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.0, 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.0, 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.0, 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.0, 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.0, 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.0, 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.0, 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.0, hash='wZIzufKIrL-JRJg4FF4bfg', n_files=None, n_observations=2.0, 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
| 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.0 | JMLW9LmuKWqNtrnXuGLXdQ | None | 7.0 | ... | 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 pandasDataFramewith 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 orNoneif there is no query result.
You can also:
use the
QuerySetas an iteratorget 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
! 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 | |||||||||||||||||||||
| 31264 | g1uMDs0pD0YOqv570000 | proteins/favorite_protein.fasta | Human lysozyme C (P61626) sequence in FASTA fo... | .fasta | None | NaN | 164.0 | GAIdBieLvpawYHF9RVeAWA | None | None | ... | True | False | 2026-09-07 06:24:31.330992+00:00 | 1 | 1 | 1 | 2 | 14262 | None | 18 |
| 31261 | lr9Dzpx1ikjncS6B0000 | proteins/protein.fasta | avGFP (P42212) amino acid sequence in FASTA fo... | .fasta | None | NaN | 310.0 | FAicO7EuYVgg-fbnIhS0Dw | None | None | ... | True | False | 2026-09-07 06:23:47.778386+00:00 | 1 | 1 | 1 | 2 | 14260 | None | 18 |
| 31259 | Vrp32G5NMTMNLA8C0000 | NaN | Green fluorescent protein (GFP) sequence | .fasta | None | NaN | 288.0 | fiZX67uu9zP_AECYfjmWgQ | None | None | ... | True | False | 2026-09-07 06:23:14.043343+00:00 | 1 | 1 | 1 | 2 | 14258 | None | 18 |
| 28571 | wx0Y1Txx6TWXV83G0000 | profile-submit/vTMSBjI45T4kkPtdxovK/star/mtx_c... | Output artifact for run 12181 | .rds | None | NaN | 15558833.0 | 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 | NaN | 15647698.0 | 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 | NaN | 247006.0 | 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 | NaN | 241260.0 | 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 | NaN | 15558833.0 | 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 | NaN | 15647698.0 | 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 | NaN | 241260.0 | 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 | NaN | 247006.0 | 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 | NaN | 241172.0 | 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 | NaN | 247005.0 | 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 | NaN | 15558833.0 | 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 | NaN | 15647698.0 | 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.0 | 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.0 | 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 | NaN | 7418438.0 | 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 | NaN | 7376591.0 | _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 | NaN | 7426758.0 | HjZvqMKuAOkdxbH1EBQUzg | None | None | ... | True | False | 2026-08-03 04:45:48.077355+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
! 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... | NaN | .zarr | dataset | SpatialData | 3.511626e+07 | CGIUfJc1GcpISZbTS9Ph7A | 148.0 | NaN | ... | True | False | 2026-04-14 09:00:18.158778+00:00 | 1 | 1 | 1 | 2 | 6113 | 198 | 9 |
| 12372 | ERCIUR3bgOOy6uxK0000 | examples/dataset2.h5ad | NaN | .h5ad | dataset | AnnData | 2.689600e+04 | RKJjWbINYNIwYU8BxCejMw | NaN | 3.0 | ... | True | False | 2025-11-20 11:04:08.172526+00:00 | 1 | 1 | 1 | 2 | NaN | 151 | 6 |
| 11833 | 9K1dteZ6Qx0EXK8g0000 | example_datasets/mini_immuno/dataset1.h5ad | Flow cytometry readouts on invitro cell culture | .h5ad | dataset | AnnData | 3.167200e+04 | FB3CeMjmg1ivN6HDy6wsSg | NaN | 3.0 | ... | True | False | 2025-07-29 12:27:25.572900+00:00 | 1 | 1 | 1 | 2 | 791 | 151 | 9 |
| 1132 | AHIfMnXepm6KaEaH0000 | scrna/Parse_10M_PBMC_cytokines_curated.tiledbsoma | NaN | .tiledbsoma | NaN | tiledbsoma | 3.822207e+10 | snBmwsareebO03_9NPvY_w | 1053.0 | 9697974.0 | ... | True | False | 2024-12-16 22:39:02.039538+00:00 | 1 | 1 | 1 | 2 | 401 | NaN | 9 |
| 1117 | xepHn6ScXGs5s1Te0001 | example_datasets/small_dataset1.tiledbsoma | NaN | .tiledbsoma | NaN | tiledbsoma | 1.985300e+04 | xkq9-kEUEChvxq-89_aJ7Q | 57.0 | 3.0 | ... | True | False | 2024-12-16 09:13:47.043028+00:00 | 1 | 1 | 1 | 2 | 394 | NaN | 9 |
| 1116 | mKo82UispVElpGtP0002 | example_datasets/small_dataset1.h5ad | NaN | .h5ad | dataset | AnnData | 2.508800e+04 | YMNwVfQZ78zwkB4shAQMfQ | NaN | 3.0 | ... | True | False | 2024-12-16 09:13:19.877258+00:00 | 1 | 1 | 1 | 2 | 394 | NaN | 9 |
| 1096 | LmlgCMQRhSEHtcbG0000 | census_immune_cells.tiledbsoma | tiledbsoma experiment for Immune cells | .tiledbsoma | NaN | tiledbsoma | 1.268083e+09 | Rug1115Hhc44XG_OvdICRw | 442.0 | 73047.0 | ... | True | False | 2024-12-05 19:14:39.282533+00:00 | 1 | 1 | 1 | 2 | 384 | NaN | 3 |
| 1090 | NiaMP8YQMbmkdOgnAa1T | cell-census/2024-07-01/h5ads/f64e1be1-de15-4d2... | Immune cells | .h5ad | dataset | AnnData | 2.854344e+09 | 3oh1Yk3fZPQMCuJWbhZ4zQ | NaN | 73047.0 | ... | True | False | 2024-12-05 16:37:13.463549+00:00 | 1 | 1 | 1 | 16 | 385 | NaN | 3 |
| 1082 | lNBsZ6Zd02kteKnK0000 | schmidt22/summary_anndata.h5ad | analyzed anndata of schmidt22 perturbseq | .h5ad | dataset | AnnData | 2.067439e+07 | hIIpdQq3gbqt5FJs0KtwEA | NaN | 853.0 | ... | True | False | 2024-12-04 12:51:18.725509+00:00 | 1 | 1 | 1 | 2 | 378 | NaN | 2 |
| 1071 | xepHn6ScXGs5s1Te0000 | example_datasets/small_dataset1.tiledbsoma | NaN | .tiledbsoma | NaN | tiledbsoma | 1.866200e+04 | xFKN6Uzvhz-OXOEr9HmPKQ | 53.0 | 3.0 | ... | False | False | 2024-12-03 14:05:19.776525+00:00 | 1 | 1 | 1 | 2 | 373 | NaN | 3 |
| 1070 | mKo82UispVElpGtP0001 | example_datasets/small_dataset1.h5ad | NaN | .h5ad | dataset | AnnData | 2.564800e+04 | eJnHmQZgRQbUMkij-ziqeA | NaN | 3.0 | ... | False | False | 2024-12-03 14:04:47.882577+00:00 | 1 | 1 | 1 | 2 | 373 | NaN | 3 |
| 1045 | 7dVluLROpalzEh8mNyxk | cell-census/2023-12-15/h5ads/02faf712-92d4-458... | Renal cell carcinoma, pre aPD1, kidney Puck_20... | .h5ad | NaN | AnnData | 1.399786e+07 | YNYuokfAoDFxdaRILjmU9w | NaN | 17612.0 | ... | True | False | 2024-12-02 08:57:19.308058+00:00 | 1 | 1 | 1 | 16 | 361 | NaN | 30 |
| 1010 | dP0F1fEQWtorhDaI0000 | example_datasets/small_dataset2.h5ad | NaN | .h5ad | dataset | AnnData | 2.122400e+04 | 7ok_2cIe73owydEGaj7m0A | NaN | 3.0 | ... | True | False | 2024-11-25 14:59:38.945319+00:00 | 1 | 1 | 1 | 2 | 302 | NaN | 9 |
| 1009 | mKo82UispVElpGtP0000 | example_datasets/small_dataset1.h5ad | NaN | .h5ad | dataset | AnnData | 2.335200e+04 | NYni1vTRM7pqfle8ufPZwQ | NaN | 3.0 | ... | False | False | 2024-11-25 14:59:09.484279+00:00 | 1 | 1 | 1 | 2 | 302 | NaN | 9 |
| 938 | 3TNCsZZcnIBv2WGb0001 | NaN | 10x reference adata, trusted cell type annotation | .h5ad | dataset | AnnData | 8.516640e+05 | iETHP3Lw-tVqZxYAuEC-SA | NaN | 70.0 | ... | True | False | 2024-10-18 21:46:55.467982+00:00 | 1 | 1 | 1 | 2 | 305 | NaN | 9 |
| 937 | 3TNCsZZcnIBv2WGb0000 | NaN | 10x reference adata | .h5ad | dataset | AnnData | 8.598400e+05 | MAjl6lrjrcjqhUUA0ixMKA | NaN | 70.0 | ... | False | False | 2024-10-18 21:45:46.636210+00:00 | 1 | 1 | 1 | 2 | 305 | NaN | 9 |
| 750 | PrHBuKLflU03CeI2xNPJ | NaN | 10x reference adata | .h5ad | NaN | AnnData | 8.577520e+05 | c9ukVXVfpdaH2BWaqBfK4g | NaN | 70.0 | ... | True | False | 2024-06-26 10:00:08.928727+00:00 | 1 | 1 | 1 | 2 | 209 | NaN | 2 |
| 725 | CFcQxNjzSRzWZrVhBk65 | NaN | Kuppe 2022, ATAC | .anndata.zarr | NaN | AnnData | 2.883708e+09 | cqrk4idQ_WGjTe6KBrIKgg | 2799.0 | NaN | ... | True | False | 2024-06-05 10:21:25.684256+00:00 | 1 | 1 | 1 | 2 | 181 | NaN | 2 |
| 708 | ytL7CXi5peqhfSPNSFVG | NaN | Kuppe 2022, RNA | .anndata.zarr | NaN | AnnData | 3.107879e+09 | tMzcoJ_1iz4Zsdvr-sjt6A | 3380.0 | NaN | ... | True | False | 2024-06-26 10:00:29.405916+00:00 | 1 | 1 | 1 | 2 | 181 | NaN | 2 |
| 706 | psrHlYkmysrxtAL3RBTo | NaN | Kuppe 2022, Visium adata | .anndata.zarr | NaN | AnnData | 6.510761e+07 | WN5GxCkcKeO5UElDZ2IA0A | 206.0 | NaN | ... | True | False | 2024-06-04 12:33:00.419035+00:00 | 1 | 1 | 1 | 2 | 181 | 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
! 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... | NaN | .zarr | dataset | SpatialData | 3.511626e+07 | CGIUfJc1GcpISZbTS9Ph7A | 148.0 | NaN | ... | True | False | 2026-04-14 09:00:18.158778+00:00 | 1 | 1 | 1 | 2 | 6113 | 198 | 9 |
| 12372 | ERCIUR3bgOOy6uxK0000 | examples/dataset2.h5ad | NaN | .h5ad | dataset | AnnData | 2.689600e+04 | RKJjWbINYNIwYU8BxCejMw | NaN | 3.0 | ... | True | False | 2025-11-20 11:04:08.172526+00:00 | 1 | 1 | 1 | 2 | NaN | 151 | 6 |
| 11833 | 9K1dteZ6Qx0EXK8g0000 | example_datasets/mini_immuno/dataset1.h5ad | Flow cytometry readouts on invitro cell culture | .h5ad | dataset | AnnData | 3.167200e+04 | FB3CeMjmg1ivN6HDy6wsSg | NaN | 3.0 | ... | True | False | 2025-07-29 12:27:25.572900+00:00 | 1 | 1 | 1 | 2 | 791 | 151 | 9 |
| 1132 | AHIfMnXepm6KaEaH0000 | scrna/Parse_10M_PBMC_cytokines_curated.tiledbsoma | NaN | .tiledbsoma | NaN | tiledbsoma | 3.822207e+10 | snBmwsareebO03_9NPvY_w | 1053.0 | 9697974.0 | ... | True | False | 2024-12-16 22:39:02.039538+00:00 | 1 | 1 | 1 | 2 | 401 | NaN | 9 |
| 1117 | xepHn6ScXGs5s1Te0001 | example_datasets/small_dataset1.tiledbsoma | NaN | .tiledbsoma | NaN | tiledbsoma | 1.985300e+04 | xkq9-kEUEChvxq-89_aJ7Q | 57.0 | 3.0 | ... | True | False | 2024-12-16 09:13:47.043028+00:00 | 1 | 1 | 1 | 2 | 394 | NaN | 9 |
| 1116 | mKo82UispVElpGtP0002 | example_datasets/small_dataset1.h5ad | NaN | .h5ad | dataset | AnnData | 2.508800e+04 | YMNwVfQZ78zwkB4shAQMfQ | NaN | 3.0 | ... | True | False | 2024-12-16 09:13:19.877258+00:00 | 1 | 1 | 1 | 2 | 394 | NaN | 9 |
| 1096 | LmlgCMQRhSEHtcbG0000 | census_immune_cells.tiledbsoma | tiledbsoma experiment for Immune cells | .tiledbsoma | NaN | tiledbsoma | 1.268083e+09 | Rug1115Hhc44XG_OvdICRw | 442.0 | 73047.0 | ... | True | False | 2024-12-05 19:14:39.282533+00:00 | 1 | 1 | 1 | 2 | 384 | NaN | 3 |
| 1090 | NiaMP8YQMbmkdOgnAa1T | cell-census/2024-07-01/h5ads/f64e1be1-de15-4d2... | Immune cells | .h5ad | dataset | AnnData | 2.854344e+09 | 3oh1Yk3fZPQMCuJWbhZ4zQ | NaN | 73047.0 | ... | True | False | 2024-12-05 16:37:13.463549+00:00 | 1 | 1 | 1 | 16 | 385 | NaN | 3 |
| 1082 | lNBsZ6Zd02kteKnK0000 | schmidt22/summary_anndata.h5ad | analyzed anndata of schmidt22 perturbseq | .h5ad | dataset | AnnData | 2.067439e+07 | hIIpdQq3gbqt5FJs0KtwEA | NaN | 853.0 | ... | True | False | 2024-12-04 12:51:18.725509+00:00 | 1 | 1 | 1 | 2 | 378 | NaN | 2 |
| 1071 | xepHn6ScXGs5s1Te0000 | example_datasets/small_dataset1.tiledbsoma | NaN | .tiledbsoma | NaN | tiledbsoma | 1.866200e+04 | xFKN6Uzvhz-OXOEr9HmPKQ | 53.0 | 3.0 | ... | False | False | 2024-12-03 14:05:19.776525+00:00 | 1 | 1 | 1 | 2 | 373 | NaN | 3 |
| 1070 | mKo82UispVElpGtP0001 | example_datasets/small_dataset1.h5ad | NaN | .h5ad | dataset | AnnData | 2.564800e+04 | eJnHmQZgRQbUMkij-ziqeA | NaN | 3.0 | ... | False | False | 2024-12-03 14:04:47.882577+00:00 | 1 | 1 | 1 | 2 | 373 | NaN | 3 |
| 1045 | 7dVluLROpalzEh8mNyxk | cell-census/2023-12-15/h5ads/02faf712-92d4-458... | Renal cell carcinoma, pre aPD1, kidney Puck_20... | .h5ad | NaN | AnnData | 1.399786e+07 | YNYuokfAoDFxdaRILjmU9w | NaN | 17612.0 | ... | True | False | 2024-12-02 08:57:19.308058+00:00 | 1 | 1 | 1 | 16 | 361 | NaN | 30 |
| 1010 | dP0F1fEQWtorhDaI0000 | example_datasets/small_dataset2.h5ad | NaN | .h5ad | dataset | AnnData | 2.122400e+04 | 7ok_2cIe73owydEGaj7m0A | NaN | 3.0 | ... | True | False | 2024-11-25 14:59:38.945319+00:00 | 1 | 1 | 1 | 2 | 302 | NaN | 9 |
| 1009 | mKo82UispVElpGtP0000 | example_datasets/small_dataset1.h5ad | NaN | .h5ad | dataset | AnnData | 2.335200e+04 | NYni1vTRM7pqfle8ufPZwQ | NaN | 3.0 | ... | False | False | 2024-11-25 14:59:09.484279+00:00 | 1 | 1 | 1 | 2 | 302 | NaN | 9 |
| 938 | 3TNCsZZcnIBv2WGb0001 | NaN | 10x reference adata, trusted cell type annotation | .h5ad | dataset | AnnData | 8.516640e+05 | iETHP3Lw-tVqZxYAuEC-SA | NaN | 70.0 | ... | True | False | 2024-10-18 21:46:55.467982+00:00 | 1 | 1 | 1 | 2 | 305 | NaN | 9 |
| 937 | 3TNCsZZcnIBv2WGb0000 | NaN | 10x reference adata | .h5ad | dataset | AnnData | 8.598400e+05 | MAjl6lrjrcjqhUUA0ixMKA | NaN | 70.0 | ... | False | False | 2024-10-18 21:45:46.636210+00:00 | 1 | 1 | 1 | 2 | 305 | NaN | 9 |
| 750 | PrHBuKLflU03CeI2xNPJ | NaN | 10x reference adata | .h5ad | NaN | AnnData | 8.577520e+05 | c9ukVXVfpdaH2BWaqBfK4g | NaN | 70.0 | ... | True | False | 2024-06-26 10:00:08.928727+00:00 | 1 | 1 | 1 | 2 | 209 | NaN | 2 |
| 725 | CFcQxNjzSRzWZrVhBk65 | NaN | Kuppe 2022, ATAC | .anndata.zarr | NaN | AnnData | 2.883708e+09 | cqrk4idQ_WGjTe6KBrIKgg | 2799.0 | NaN | ... | True | False | 2024-06-05 10:21:25.684256+00:00 | 1 | 1 | 1 | 2 | 181 | NaN | 2 |
| 708 | ytL7CXi5peqhfSPNSFVG | NaN | Kuppe 2022, RNA | .anndata.zarr | NaN | AnnData | 3.107879e+09 | tMzcoJ_1iz4Zsdvr-sjt6A | 3380.0 | NaN | ... | True | False | 2024-06-26 10:00:29.405916+00:00 | 1 | 1 | 1 | 2 | 181 | NaN | 2 |
| 706 | psrHlYkmysrxtAL3RBTo | NaN | Kuppe 2022, Visium adata | .anndata.zarr | NaN | AnnData | 6.510761e+07 | WN5GxCkcKeO5UElDZ2IA0A | 206.0 | NaN | ... | True | False | 2024-06-04 12:33:00.419035+00:00 | 1 | 1 | 1 | 2 | 181 | 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
| uid | key | perturbation | cell_type_by_model | assay_oid | temperature | |
|---|---|---|---|---|---|---|
| id | ||||||
| 11925 | AsTXi6hzDFM7L17t0003 | examples/mini_immuno_with_single_typo.parquet | {IFNG, DMSO} | {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
| uid | key | perturbation | cell_type_by_model | assay_oid | temperature | |
|---|---|---|---|---|---|---|
| id | ||||||
| 11925 | AsTXi6hzDFM7L17t0003 | examples/mini_immuno_with_single_typo.parquet | {IFNG, DMSO} | {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
| 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
! 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 | |||||||||||||||||||||
| 30656 | Shd8DEzRucu3Xvdc0001 | laminprofiler/duration_vs_time.svg | duration_in_sec vs. time — init | .svg | NaN | NaN | 3.433000e+04 | LyV1nemOxss-GcvMhaTWlA | None | NaN | ... | True | False | 2026-08-22 18:56:19.059415+00:00 | 1 | 1 | 1 | 2 | 13753 | None | 9 |
| 30653 | Shd8DEzRucu3Xvdc0000 | laminprofiler/duration_vs_time.svg | duration_in_sec vs. time — init | .svg | NaN | NaN | 3.997100e+04 | BGa0TB6WTWMsss9ppxWUUw | None | NaN | ... | False | False | 2026-08-22 18:53:54.778547+00:00 | 1 | 1 | 1 | 2 | 13751 | None | 9 |
| 30651 | L1HGZu8CMlrrxACm0003 | laminprofiler/duration_vs_time_import_lamindb_... | duration_in_sec vs. time — init | .svg | NaN | NaN | 3.997100e+04 | 5V2k7GONKqH1vVa73eW-BQ | None | NaN | ... | True | False | 2026-08-22 18:51:50.828812+00:00 | 1 | 1 | 1 | 2 | 13750 | None | 9 |
| 29991 | KKfGLmFwvmSb56H50000 | NaN | Embedded asset | .png | __easset__ | NaN | 3.495520e+05 | T1sjyK0wVl5t_Ibr1lpqNw | None | NaN | ... | True | False | 2026-08-17 11:17:07.925399+00:00 | 1 | 1 | 1 | 2 | NaN | None | 46 |
| 29921 | iVxey5KAwg69PrSz0000 | esc_ipsc/heatmap_top50.png | Clustered heatmap of top-50 DE genes (by padj)... | .png | NaN | NaN | 3.123520e+05 | IuoQ-te-jQXthkk5Qr0E8w | None | NaN | ... | True | False | 2026-08-16 10:39:12.555464+00:00 | 1 | 1 | 1 | 2 | 13184 | None | 60 |
| 29920 | rBcRShqxKX33I33l0000 | esc_ipsc/volcano_plot.png | Volcano plot: log2FC vs -log10 padj (ESC vs iPSC) | .png | NaN | NaN | 1.187300e+05 | XMRsdEIO8ZQ-KjBY1jvlhA | None | NaN | ... | True | False | 2026-08-16 10:39:10.936477+00:00 | 1 | 1 | 1 | 2 | 13184 | None | 60 |
| 29918 | ovdxb8SwOs10PLnQ0000 | esc_ipsc/counts.csv | Raw gene-level counts matrix (gene_id x sample... | .csv | NaN | DataFrame | 2.632050e+06 | 8D5m-Qbtdy3iKzSnYSK4jA | None | NaN | ... | True | False | 2026-08-16 10:38:29.011279+00:00 | 1 | 1 | 1 | 2 | 13183 | None | 60 |
| 29676 | QIKiDBZTSpmEhkOo0000 | NaN | Embedded asset | .png | __easset__ | NaN | 3.061170e+05 | FowJyxPuUJwhghAAm2Y5UQ | None | NaN | ... | True | False | 2026-08-12 09:37:35.546038+00:00 | 1 | 1 | 1 | 2 | NaN | None | 46 |
| 29414 | NitV7fumJa6TPlJg0000 | esc_ipsc/deseq2_results.csv | PyDESeq2 results table (ESC vs iPSC), sorted b... | .csv | NaN | DataFrame | 4.792375e+06 | i5v_KsCea-DJgqOmtRexcw | None | NaN | ... | True | False | 2026-08-09 19:15:56.482422+00:00 | 1 | 1 | 1 | 2 | 13165 | None | 60 |
| 29405 | L1HGZu8CMlrrxACm0002 | laminprofiler/duration_vs_time_import_lamindb_... | duration_in_sec vs. time — import_lamindb_setup | .svg | NaN | NaN | 1.674770e+05 | MPwecXMw5ffm7PcNAfOpRQ | None | NaN | ... | False | False | 2026-08-08 08:59:53.362823+00:00 | 1 | 565 | 1 | 2 | 12782 | None | 9 |
| 29404 | L1HGZu8CMlrrxACm0001 | laminprofiler/duration_vs_time_import_lamindb_... | duration_in_sec vs. time — import_lamindb_setup | .svg | NaN | NaN | 1.674770e+05 | g8ypIRrdrMGbGbiUjlErJg | None | NaN | ... | False | False | 2026-08-08 08:58:22.233098+00:00 | 1 | 565 | 1 | 2 | 12780 | None | 9 |
| 29330 | f5ziBE16S6cgCcAa0000 | cell-census/2025-11-17/h5ads/b57462e3-1df5-463... | Spinal cord dataset | .h5ad | NaN | AnnData | 8.385448e+08 | 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 | NaN | AnnData | 1.034128e+09 | 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 | NaN | AnnData | 1.591353e+08 | 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 | NaN | AnnData | 1.649709e+07 | zPOKGUYq66NbshPtZ-I08g | None | 26239.0 | ... | True | False | 2026-08-07 10:17:56.084912+00:00 | 1 | 1 | 1 | 16 | 12722 | None | 60 |
| 29176 | mNXum9KZQQbkgWTq0000 | datasets/sales/synthetic_sales.csv | Synthetic transactional sales dataset generate... | .csv | NaN | DataFrame | 1.544440e+05 | mVX-CZ3SHYpI-9VPjR7DrA | None | NaN | ... | True | False | 2026-08-06 14:24:49.526600+00:00 | 1 | 1 | 1 | 2 | 12615 | None | 76 |
| 29075 | gcdtMgwa9e9S9UVp0001 | gwas/raw/raw_gwas_data.csv | Raw GWAS input table with sample metadata and ... | .csv | dataset | DataFrame | 5.335200e+04 | 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 | NaN | NaN | 3.291800e+04 | LmIand9bIihhMFokeroxVw | None | NaN | ... | True | False | 2026-08-05 16:13:15.641407+00:00 | 1 | 1 | 1 | 2 | 12537 | None | 76 |
| 29027 | sDWtv2aElra5VtR40000 | datasets/customer_churn_synthetic.csv | Synthetic customer churn dataset with region a... | .csv | NaN | DataFrame | 1.019200e+04 | depLWDgoATG5Tc5LHJwORw | None | NaN | ... | True | False | 2026-08-05 16:11:55.598858+00:00 | 1 | 1 | 1 | 2 | 12535 | None | 76 |
| 29021 | NINEoAFwQoRhxCuc0000 | gwas_pipeline/visualization/qq_plot.png | Q-Q plot | .png | NaN | NaN | 5.937400e+04 | m5EwTtf8JO5e6MawECUEFA | None | NaN | ... | True | False | 2026-08-05 15:20:27.921251+00:00 | 1 | 1 | 1 | 2 | 12532 | None | 46 |
20 rows × 22 columns
in¶
db.Artifact.filter(suffix__in=[".jpg", ".fastq.gz"]).to_dataframe()
Show 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 | NaN | None | 1.981608e+06 | 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 | NaN | None | 7.376530e+05 | 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 | NaN | None | 4.259756e+06 | 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 | NaN | None | 1.727503e+06 | 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 | NaN | None | 4.259756e+06 | 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 | NaN | None | 1.727503e+06 | 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 | 2.939891e+10 | 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 | 7.675472e+09 | 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 | 2.955347e+10 | 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 | 7.725840e+09 | 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... | NaN | .jpg | NaN | None | 1.452900e+04 | 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 | 1.234670e+05 | A_WjRYau-c1h9U6yaDGmZQ | None | None | ... | True | False | 2026-06-01 09:38:35.976330+00:00 | 1 | 1 | 1 | 59 | 8541 | None | 54 |
| 23622 | F9Tn8DfxnBPGtssK0000 | temp/output/fetchngs/fastq/SRX9315476_SRR12848... | Output artifact for run 8541 | .fastq.gz | dataset | None | 1.315390e+05 | l3AcXYhK-NlrqV1yN_O_eQ | None | None | ... | True | False | 2026-06-01 09:38:31.103701+00:00 | 1 | 1 | 1 | 59 | 8541 | None | 54 |
| 23621 | FtiwkNxd0Ila7VWx0000 | temp/output/fetchngs/fastq/SRX11047067_SRR1470... | Output artifact for run 8541 | .fastq.gz | dataset | None | 1.500000e+02 | eRQN0cs_0cXgLYjgH3w-2g | None | None | ... | True | False | 2026-06-01 09:38:26.673415+00:00 | 1 | 1 | 1 | 59 | 8541 | None | 54 |
| 23620 | Xh881SEOzEhkxVBh0000 | temp/output/fetchngs/fastq/SRX10940790_SRR1459... | Output artifact for run 8541 | .fastq.gz | dataset | None | 4.730000e+02 | y9MHFf3vRX16okoS8Z7t8g | None | None | ... | True | False | 2026-06-01 09:38:22.275334+00:00 | 1 | 1 | 1 | 59 | 8541 | None | 54 |
| 23619 | U4GV6WjzB72LJJNy0000 | temp/output/fetchngs/fastq/SRX10940790_SRR1459... | Output artifact for run 8541 | .fastq.gz | dataset | None | 4.590000e+02 | akdizw8fn1VE03NeLgfF0w | None | None | ... | True | False | 2026-06-01 09:38:18.479607+00:00 | 1 | 1 | 1 | 59 | 8541 | None | 54 |
| 23617 | 1YEM2Tzio0JpaPke0000 | temp/output/fetchngs/fastq/SRX9504942_SRR13055... | Output artifact for run 8541 | .fastq.gz | dataset | None | 7.149070e+05 | WtUUYMbEqFDdN6IG4sRBwQ | None | None | ... | True | False | 2026-06-01 09:37:53.956200+00:00 | 1 | 1 | 1 | 59 | 8541 | None | 54 |
| 23616 | 8DhYtWgZJO545TJo0000 | temp/output/fetchngs/fastq/SRX9504942_SRR13055... | Output artifact for run 8541 | .fastq.gz | dataset | None | 7.217050e+05 | qXc2e_QdrPTCG8DIIBuLiA | None | None | ... | True | False | 2026-06-01 09:37:39.002608+00:00 | 1 | 1 | 1 | 59 | 8541 | None | 54 |
| 23615 | NgZujyEK9KmFMlFK0000 | temp/output/fetchngs/fastq/SRX9504942_SRR13055... | Output artifact for run 8541 | .fastq.gz | dataset | None | 7.176930e+05 | XsiU2GP87-OURwoJJa795A | None | None | ... | True | False | 2026-06-01 09:37:29.243127+00:00 | 1 | 1 | 1 | 59 | 8541 | None | 54 |
| 23614 | rLzlXSOpP8o1piIs0000 | temp/output/fetchngs/fastq/SRX9504942_SRR13055... | Output artifact for run 8541 | .fastq.gz | dataset | None | 7.168620e+05 | w_NDeTVrKNbaxyEqvBoKBA | None | None | ... | True | False | 2026-06-01 09:37:24.188066+00:00 | 1 | 1 | 1 | 59 | 8541 | None | 54 |
20 rows × 22 columns
order by¶
db.Artifact.filter().order_by("created_at").to_dataframe()
Show 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 | NaN | 4.795677e+09 | NaN | None | None | ... | True | False | 2023-04-24 18:16:32.313696+00:00 | 1 | 1 | 1 | 8 | 1 | None | 9 |
| 2 | 0PsCY8SjhD1FIqw9e99v | paradisi05.jpg | paradisi05.jpg | .jpg | None | NaN | 2.935800e+04 | r4tnqmKI_SjrkdLzpuWp4g | None | None | ... | True | False | 2023-05-11 17:27:12.479874+00:00 | 1 | 1 | 1 | 2 | 6 | None | 2 |
| 3 | 1YOa919kJFXzvgfmq4Pv | alignment_result.bam | alignment_result.bam | .bam | None | NaN | 1.400000e+01 | rGSwtSEKB65DaaQq740p6A | None | None | ... | True | False | 2023-05-11 17:27:22.895303+00:00 | 1 | 1 | 1 | 2 | 6 | None | 2 |
| 4 | DoI5k2zRvBdI29OO7vGu | alignment_result.fastq.gz | alignment_result.fastq.gz | .fastq.gz | None | NaN | 1.600000e+01 | QDkCIyDtWe8tlrS9zG8gnw | None | None | ... | True | False | 2023-05-11 17:29:35.872683+00:00 | 1 | 1 | 1 | 2 | 6 | None | 2 |
| 7 | ODQVll1jtwfvv1lQwyw3 | NaN | human immune cells | .h5ad | None | NaN | 6.094764e+07 | 6QUqNaIQurw-HLIkXg9_1w | None | None | ... | True | False | 2023-05-17 07:27:10.961723+00:00 | 1 | 1 | 1 | 2 | 6 | None | 2 |
| 8 | SAPKv9zC4hBmXsHvdReg | NaN | scRNA-seq mouse lymph_node | .h5ad | None | NaN | 1.734124e+07 | Qprqj0O23197Ko-VobaZiw | None | None | ... | True | False | 2023-05-17 07:29:20.858230+00:00 | 1 | 1 | 1 | 2 | 6 | None | 2 |
| 9 | myPxexSQMW3Xrdz5C31U | NaN | scRNA-seq pbmc3k processed | .h5ad | None | NaN | 4.021251e+07 | 8uy3ub-USOUcnkFEw5UzzA | None | None | ... | True | False | 2023-05-17 07:34:56.434082+00:00 | 1 | 1 | 1 | 2 | 6 | None | 2 |
| 10 | YdTtu9TBPYe6ov1ItOVK | NaN | scRNA-seq pbmc68k reduced | .h5ad | None | NaN | 6.384840e+05 | -QNUPBbAug3jFmmk3fsOQA | None | None | ... | True | False | 2023-05-17 07:37:43.536825+00:00 | 1 | 1 | 1 | 2 | 6 | None | 2 |
| 16 | i8iBR6gPn7NIvxwgjyxD | NaN | Human Lung Cell Atlas (core) | .h5ad | None | NaN | 6.024042e+09 | -B4rkeu0-NKqWVpJqPq6aX | None | None | ... | True | False | 2023-07-14 12:48:12.378063+00:00 | 1 | 1 | 1 | 2 | 24 | None | 5 |
| 18 | dPraor9rU1EofcFb6Wph | tabula_sapiens_lung.h5ad | Part of Tabula Sapiens, a benchmark, first-dra... | .h5ad | None | NaN | 3.899436e+09 | 8mB1KK2wd51F6HQdvqipcQ | None | None | ... | True | False | 2023-07-14 19:00:30.621330+00:00 | 1 | 1 | 1 | 2 | 9 | None | 3 |
| 21 | uAAHUIGb13zvUYkMRsGR | schmidt22/schmidt22_merged.h5ad | CRISPRa Perturb-seq of primary human T cells | .h5ad | None | NaN | 3.155686e+09 | gJcjALISed0J5OhSmEDJ2v | None | None | ... | True | False | 2023-07-14 19:58:17.360062+00:00 | 1 | 1 | 1 | 2 | 30 | None | 6 |
| 22 | JQjRzDBw2OLQ5XLbhtUg | NaN | schmidt22_data/Genome-wide-screens/data/gene_s... | .parquet | None | NaN | 1.242827e+06 | 2XQbncQ48h4kczkYd95lZQ | None | None | ... | True | False | 2023-07-15 12:30:06.020349+00:00 | 1 | 1 | 1 | 2 | 30 | None | 6 |
| 23 | wukqLbKCfN6xXuzwcbW2 | NaN | schmidt22_data/Genome-wide-screens/data/gene_s... | .parquet | None | NaN | 1.203729e+06 | ebsJsQG1xyr1Rfurc5UShw | None | None | ... | True | False | 2023-07-15 12:30:10.051671+00:00 | 1 | 1 | 1 | 2 | 30 | None | 6 |
| 24 | GDHZJ99oQDiPsS7o8GSl | NaN | schmidt22_data/Genome-wide-screens/data/gene_s... | .parquet | None | NaN | 1.222490e+06 | 5G4M1Qw2Kqj69w28Z6_YBA | None | None | ... | True | False | 2023-07-15 12:30:13.575614+00:00 | 1 | 1 | 1 | 2 | 30 | None | 6 |
| 25 | 9Gw50HQnl2vYyzWOpOvx | NaN | schmidt22_data/Genome-wide-screens/data/gene_s... | .parquet | None | NaN | 1.246652e+06 | CsEMn21jx3ooCzuN1bokHw | None | None | ... | True | False | 2023-07-15 12:30:17.140265+00:00 | 1 | 1 | 1 | 2 | 30 | None | 6 |
| 346 | OYMsfQft74x86KVv0000 | fasta/PO5F1.fasta | NaN | .fasta | None | NaN | 4.770000e+02 | -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 | NaN | .fasta | None | NaN | 5.360000e+02 | 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 | NaN | .fasta | None | NaN | 4.140000e+02 | 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 | NaN | .fasta | None | NaN | 6.090000e+02 | LyuoYkWs4SgYcH7P7JLJtA | None | None | ... | True | False | 2023-09-19 13:22:32.679683+00:00 | 1 | 1 | 1 | 2 | NaN | None | 9 |
| 383 | Ff4XZtm6Lko0Fz3ysIEl | NaN | 10x reference adata | .h5ad | None | AnnData | 6.607920e+05 | TRHLp5EVjDGdv7DufMAnmg | None | None | ... | True | False | 2023-10-04 13:19:07.817861+00:00 | 1 | 1 | 1 | 2 | 33 | None | 2 |
20 rows × 22 columns
# reverse ordering
db.Artifact.filter().order_by("-created_at").to_dataframe()
Show 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 | |||||||||||||||||||||
| 31441 | N2N25ecPjU1uhIRN0000 | fasta/cytochrome_c_human_aa_frequencies.parquet | Amino-acid composition analysis of human cytoc... | .parquet | dataset | DataFrame | 2946.0 | arOXbnDIa8lATHRFYegTfQ | None | 20.0 | ... | True | False | 2026-09-08 22:10:17.518495+00:00 | 1 | 1 | 1 | 2 | 14388 | None | 76 |
| 31438 | x7gkzDW9dDIXjMgF0000 | fasta/cytochrome_c_human.fasta | Human cytochrome c (CYCS, UniProt P99999) prot... | .fasta | NaN | NaN | 183.0 | 6rYbxRvZr5LftJaBZ3Ltaw | None | NaN | ... | True | False | 2026-09-08 22:08:58.275001+00:00 | 1 | 1 | 1 | 2 | 14387 | None | 76 |
| 31415 | W3q98o3Rxv5wxiS40000 | NaN | mix-test | .txt | NaN | NaN | 62.0 | xMtGxadDGhAvlDQKmNJ_ZA | None | NaN | ... | True | False | 2026-09-08 20:30:51.088739+00:00 | 1 | 1 | 1 | 2 | NaN | None | 3 |
| 31414 | Uu0CthUXD2BP4MMr0000 | NaN | upload2 | .txt | NaN | NaN | 54.0 | wzKrXgQvmWqiM4yGu9uEOA | None | NaN | ... | True | False | 2026-09-08 20:23:51.195724+00:00 | 1 | 1 | 1 | 2 | NaN | None | 3 |
| 31410 | ud8k72RyfgQ1nWYE0000 | NaN | check upload | .txt | NaN | NaN | 45.0 | IHTGvkKqzNPWo5dcubvmvw | None | NaN | ... | True | False | 2026-09-08 19:41:22.287573+00:00 | 1 | 1 | 1 | 2 | NaN | None | 3 |
| 31264 | g1uMDs0pD0YOqv570000 | proteins/favorite_protein.fasta | Human lysozyme C (P61626) sequence in FASTA fo... | .fasta | NaN | NaN | 164.0 | GAIdBieLvpawYHF9RVeAWA | None | NaN | ... | True | False | 2026-09-07 06:24:31.330992+00:00 | 1 | 1 | 1 | 2 | 14262 | None | 18 |
| 31261 | lr9Dzpx1ikjncS6B0000 | proteins/protein.fasta | avGFP (P42212) amino acid sequence in FASTA fo... | .fasta | NaN | NaN | 310.0 | FAicO7EuYVgg-fbnIhS0Dw | None | NaN | ... | True | False | 2026-09-07 06:23:47.778386+00:00 | 1 | 1 | 1 | 2 | 14260 | None | 18 |
| 31259 | Vrp32G5NMTMNLA8C0000 | NaN | Green fluorescent protein (GFP) sequence | .fasta | NaN | NaN | 288.0 | fiZX67uu9zP_AECYfjmWgQ | None | NaN | ... | True | False | 2026-09-07 06:23:14.043343+00:00 | 1 | 1 | 1 | 2 | 14258 | None | 18 |
| 30656 | Shd8DEzRucu3Xvdc0001 | laminprofiler/duration_vs_time.svg | duration_in_sec vs. time — init | .svg | NaN | NaN | 34330.0 | LyV1nemOxss-GcvMhaTWlA | None | NaN | ... | True | False | 2026-08-22 18:56:19.059415+00:00 | 1 | 1 | 1 | 2 | 13753 | None | 9 |
| 30653 | Shd8DEzRucu3Xvdc0000 | laminprofiler/duration_vs_time.svg | duration_in_sec vs. time — init | .svg | NaN | NaN | 39971.0 | BGa0TB6WTWMsss9ppxWUUw | None | NaN | ... | False | False | 2026-08-22 18:53:54.778547+00:00 | 1 | 1 | 1 | 2 | 13751 | None | 9 |
| 30651 | L1HGZu8CMlrrxACm0003 | laminprofiler/duration_vs_time_import_lamindb_... | duration_in_sec vs. time — init | .svg | NaN | NaN | 39971.0 | 5V2k7GONKqH1vVa73eW-BQ | None | NaN | ... | True | False | 2026-08-22 18:51:50.828812+00:00 | 1 | 1 | 1 | 2 | 13750 | None | 9 |
| 30305 | TeERjy0Nt2yY3Cr00000 | sheet_exports/Experiments.csv | Export of sheet fNBzuANAusnkFv2p: Our experime... | .csv | dataset | DataFrame | 125.0 | no__3ZZD0t_AgOMO91saUg | None | 3.0 | ... | True | False | 2026-08-20 10:36:31.440148+00:00 | 1 | 1 | 1 | 2 | 13478 | None | 46 |
| 29994 | fzIkx9MnWq6GVhBj0000 | math/powers_of_4_first_10.txt | Text file listing the first 10 powers of 4 | .txt | NaN | NaN | 110.0 | wFhHIH5JbLZS0o0_E0Dx1g | None | NaN | ... | True | False | 2026-08-17 11:30:32.142793+00:00 | 1 | 1 | 1 | 2 | 13237 | None | 76 |
| 29992 | Y4MKT5zj0Fzl6swK0000 | outputs/powers_of_3.txt | First 10 powers of 3 (3^1 through 3^10) | .txt | NaN | NaN | 101.0 | fwGZaFBn16u6wbqF-A2TzQ | None | NaN | ... | True | False | 2026-08-17 11:28:53.844630+00:00 | 1 | 1 | 1 | 2 | 13236 | None | 76 |
| 29991 | KKfGLmFwvmSb56H50000 | NaN | Embedded asset | .png | __easset__ | NaN | 349552.0 | T1sjyK0wVl5t_Ibr1lpqNw | None | NaN | ... | True | False | 2026-08-17 11:17:07.925399+00:00 | 1 | 1 | 1 | 2 | NaN | None | 46 |
| 29974 | VPpPBvk1EiMoEZJD0000 | datasets/math/fib30_workflow/parity.json | Even/odd check of the sum of the first 30 Fibo... | .json | NaN | NaN | 40.0 | 28ZpUqGu3SW9KITScUTJFA | None | NaN | ... | True | False | 2026-08-17 09:57:07.284293+00:00 | 1 | 1 | 1 | 2 | 13225 | None | 76 |
| 29972 | R7Hq7dALjxOKQJOX0000 | datasets/math/fib30_workflow/sum.json | Sum of the first 30 Fibonacci numbers. | .json | NaN | NaN | 20.0 | JvZGFprq7qx699-J3O_H5g | None | NaN | ... | True | False | 2026-08-17 09:56:53.848403+00:00 | 1 | 1 | 1 | 2 | 13224 | None | 76 |
| 29970 | W6Rs8HwG4l9VtThv0000 | datasets/math/fib30_workflow/numbers.json | First 30 Fibonacci numbers. | .json | NaN | NaN | 300.0 | qQyW0dtcPdhKbcqjqUVG7A | None | NaN | ... | True | False | 2026-08-17 09:56:37.938618+00:00 | 1 | 1 | 1 | 2 | 13223 | None | 76 |
| 29921 | iVxey5KAwg69PrSz0000 | esc_ipsc/heatmap_top50.png | Clustered heatmap of top-50 DE genes (by padj)... | .png | NaN | NaN | 312352.0 | IuoQ-te-jQXthkk5Qr0E8w | None | NaN | ... | True | False | 2026-08-16 10:39:12.555464+00:00 | 1 | 1 | 1 | 2 | 13184 | None | 60 |
| 29920 | rBcRShqxKX33I33l0000 | esc_ipsc/volcano_plot.png | Volcano plot: log2FC vs -log10 padj (ESC vs iPSC) | .png | NaN | NaN | 118730.0 | XMRsdEIO8ZQ-KjBY1jvlhA | None | NaN | ... | True | False | 2026-08-16 10:39:10.936477+00:00 | 1 | 1 | 1 | 2 | 13184 | None | 60 |
20 rows × 22 columns
db.Artifact.filter().order_by("key").to_dataframe()
Show 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 | |||||||||||||||||||||
| 12636 | 35ObjdYJlHtNB3bX0000 | None | Output artifact for run 1770 | .json | NaN | NaN | 80.0 | FgHcIsT7rT3ofLeWhiYEGQ | None | None | ... | True | False | 2026-01-12 07:51:02.590141+00:00 | 1 | 1 | 1 | 2 | 1770 | None | 18 |
| 1282 | WQtsc0CQZKB9GEst0000 | None | Example R cars dataset | .parquet | dataset | DataFrame | 2402.0 | eIk8NXNiwMoGmhhjrMILbg | None | None | ... | True | False | 2025-01-15 14:22:51.192955+00:00 | 1 | 1 | 1 | 2 | 460 | None | 30 |
| 12637 | DlI6q1KyYwXa8JDg0000 | None | Output artifact for run 1771 | .json | NaN | NaN | 80.0 | _0FUb8Xz9Ly79tXBJUpSmw | None | None | ... | True | False | 2026-01-12 07:51:09.479761+00:00 | 1 | 1 | 1 | 2 | 1771 | None | 18 |
| 12635 | Hd09etkjOsgvX1JA0000 | None | test | NaN | NaN | 3949.0 | i9NhjVeKePm4-48opDt7xw | None | None | ... | True | False | 2026-01-07 17:47:05.361341+00:00 | 1 | 1 | 1 | 2 | NaN | None | 3 | |
| 1339 | 6gX0kYoaGMkxzcGU0000 | None | Marker genes for renal cell carcinoma dataset | .parquet | dataset | DataFrame | 6456.0 | qc88qFiDolluPt8YIiSq_g | None | None | ... | True | False | 2025-02-17 12:48:31.963510+00:00 | 1 | 1 | 1 | 2 | 462 | None | 30 |
| 20756 | qCEizASjJg7lfbDO0000 | None | CSV upload test efba5645 | .csv | NaN | DataFrame | 40.0 | du-FuXzpOCU4K0RlIEmuBw | None | None | ... | True | False | 2026-04-25 05:45:13.307128+00:00 | 1 | 1 | 1 | 2 | 6838 | None | 18 |
| 12638 | GblMs81hx8QGJCen0000 | None | Output artifact for run 1774 | .json | NaN | NaN | 80.0 | C8bX81iEj2UbtzSvgAfpqA | None | None | ... | True | False | 2026-01-12 09:03:31.964983+00:00 | 1 | 1 | 1 | 2 | 1774 | None | 18 |
| 1484 | TK9vvBJUDzDAjhWl0000 | None | adme_dataset_test | .sdf | NaN | NaN | 4789857.0 | yS_cv8YsScZqJXfLkU_Uzg | None | None | ... | True | False | 2025-04-12 16:08:52.747861+00:00 | 1 | 1 | 1 | 2 | NaN | None | 37 |
| 607 | sRapK07mMtToihzFeTaf | None | View Papalexi21 in Vitessce | .vitessce.json | NaN | NaN | 1527.0 | jfAtjNNzdvetUaEo5zhf0Q | None | None | ... | True | False | 2024-04-30 12:51:16.348884+00:00 | 1 | 1 | 1 | 2 | 141 | None | 2 |
| 726 | HXJ4DDAw8012jVKwoxgd | None | View Kuppe2022 in Vitessce | .vitessce.json | NaN | NaN | 5258.0 | JsVK8X8EGRsyTEMnD3Z-6g | None | None | ... | True | False | 2024-06-26 10:35:31.697669+00:00 | 1 | 1 | 1 | 2 | 198 | None | 2 |
| 932 | NDOlPsxP59pEWbbE0000 | None | test-rename | .parquet | dataset | DataFrame | 2380.0 | 78-cWLRn4ckaWn5wZs4TYw | None | None | ... | True | False | 2024-10-18 13:14:52.522736+00:00 | 1 | 1 | 1 | 2 | 301 | None | 2 |
| 12639 | PpMSbCxoLwAKjIxO0000 | None | Output artifact for run 1775 | .json | NaN | NaN | 80.0 | N5jn7KqL-txKLk8zAaa-jw | None | None | ... | True | False | 2026-01-12 09:03:41.465518+00:00 | 1 | 1 | 1 | 2 | 1775 | None | 18 |
| 12640 | ItAg10VDzxLJoz820000 | None | Output artifact for run 1778 | .json | NaN | NaN | 80.0 | ceQOS7lNBEaIfZuFbg-zRA | None | None | ... | True | False | 2026-01-12 10:46:19.452302+00:00 | 1 | 1 | 1 | 2 | 1778 | None | 18 |
| 16971 | hTZCRq1NIXdlXrbV0000 | None | Upload test ecec7867 | .txt | NaN | NaN | 56.0 | cYIADRgtkcKovZbPdDLcxw | None | None | ... | True | False | 2026-03-14 05:28:27.330185+00:00 | 1 | 1 | 1 | 2 | NaN | None | 18 |
| 12641 | 5GrpFuIwFUd29UD30000 | None | Output artifact for run 1779 | .json | NaN | NaN | 80.0 | -dLO-WyZerW6RWf_zD_2cw | None | None | ... | True | False | 2026-01-12 10:46:28.787149+00:00 | 1 | 1 | 1 | 2 | 1779 | None | 18 |
| 865 | xqcaHbOU2jTohiwi0000 | None | my RNA-seq | .parquet | dataset | DataFrame | 4091.0 | PV-3u9wm_rq35o6J8d5A5w | None | None | ... | True | False | 2024-09-24 13:10:10.580062+00:00 | 1 | 1 | 1 | 2 | 260 | None | 9 |
| 996 | Xr8OgqkMM78cPpTY0000 | None | Marker genes for renal cell carninoma dataset | .parquet | dataset | DataFrame | 71299.0 | qT2DWTxxXPDYER6WKVn05Q | None | None | ... | True | False | 2024-11-22 14:33:53.803326+00:00 | 1 | 1 | 1 | 2 | 342 | None | 28 |
| 12765 | 1AwziZKdEj2IXwWo0000 | None | Output artifact for run 1859 | .json | NaN | NaN | 80.0 | ndKHofUZnRSIP0-zFx9D8g | None | None | ... | True | False | 2026-01-15 05:15:09.053471+00:00 | 1 | 1 | 1 | 2 | 1859 | None | 18 |
| 12642 | ofOwUan29TR1WbhW0000 | None | Output artifact for run 1782 | .json | NaN | NaN | 80.0 | XJZRUFXtNNQ7wL1cqs476g | None | None | ... | True | False | 2026-01-12 11:02:56.517095+00:00 | 1 | 1 | 1 | 2 | 1782 | None | 18 |
| 20576 | tNa9JwfjVo3n9peM0000 | None | CSV upload test c1bf706e | .csv | NaN | DataFrame | 40.0 | sjI9d7jzpuL5vn9f7Ey6pg | None | None | ... | True | False | 2026-04-23 12:07:52.787528+00:00 | 1 | 1 | 1 | 2 | 6746 | None | 18 |
20 rows × 22 columns
# reverse ordering
db.Artifact.filter().order_by("-key").to_dataframe()
Show 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 | |||||||||||||||||||||
| 1392 | KFhRNPqcdoxBCNZt0000 | xenium_aligned_2_guide_min.zarr | NaN | .zarr | dataset | SpatialData | 4.082240e+07 | BByzNgmQLwel85gqCO3mFw | 174.0 | None | ... | False | False | 2025-03-25 18:18:47.973259+00:00 | 1 | 1 | 1 | 2 | 544 | None | 6 |
| 1403 | KFhRNPqcdoxBCNZt0001 | xenium_aligned_2_guide_min.zarr | NaN | .zarr | dataset | SpatialData | 4.082231e+07 | oH569Lh4koYRB1I6AatnGQ | 174.0 | None | ... | True | False | 2025-03-26 15:15:49.153243+00:00 | 1 | 1 | 1 | 2 | 546 | None | 6 |
| 1391 | kVMuYil81BHTwQ9G0000 | xenium_aligned_1_guide_min.zarr | NaN | .zarr | dataset | SpatialData | 3.511540e+07 | texqoOnX5OgqxMWd6gF6Ww | 145.0 | None | ... | False | False | 2025-03-25 18:18:16.374973+00:00 | 1 | 1 | 1 | 2 | 544 | None | 6 |
| 1402 | kVMuYil81BHTwQ9G0001 | xenium_aligned_1_guide_min.zarr | NaN | .zarr | dataset | SpatialData | 3.511530e+07 | 8f1qC6IkpSvFw2H8TdhplQ | 145.0 | None | ... | True | False | 2025-03-26 15:15:13.756370+00:00 | 1 | 1 | 1 | 2 | 546 | None | 6 |
| 1326 | 8sPWscz3SICG1D8t0000 | xenium/2.0.0/Xenium_V1_humanLung_Cancer_FFPE_o... | NaN | .zarr | NaN | spatialdata | 6.952541e+09 | LququnPo8WKQBQmgbkTiOg | 1105.0 | None | ... | False | False | 2025-02-11 10:20:24.518854+00:00 | 1 | 1 | 1 | 2 | 489 | None | 2 |
| 12608 | 8sPWscz3SICG1D8t0001 | xenium/2.0.0/Xenium_V1_humanLung_Cancer_FFPE_o... | NaN | .zarr | NaN | spatialdata | 7.045223e+09 | jgalhtHw00CzuZA_jrTygw | 1457.0 | None | ... | True | False | 2025-12-16 14:14:28.067901+00:00 | 1 | 1 | 1 | 2 | NaN | None | 40 |
| 12760 | KtgQShCvwLqTeUab0000 | vitessce_examples/xenium/2.0.0/Xenium_V1_human... | Xenium_V1_humanLung_Cancer_FFPE_he_image offse... | .json | NaN | NaN | 4.000000e+00 | hisagMLiCNBl8wqyGenU7g | NaN | None | ... | True | False | 2026-01-14 14:31:44.438921+00:00 | 1 | 1 | 1 | 2 | NaN | None | 40 |
| 12857 | Z1Q9alE7dBr5lZty0000 | vitessce_examples/visium.sdata.zarr | Visium SpatialData Example | .zarr | dataset | SpatialData | 1.473182e+09 | iDvq8-aqbbY8EBA1QCoMzw | 9170.0 | None | ... | True | False | 2026-01-20 19:53:35.630352+00:00 | 1 | 1 | 1 | 2 | 1933 | None | 40 |
| 12858 | dYRJon1HZoJuWhz80000 | vitessce_examples/visium.ome.zarr | Visium OME-Zarr Example | .ome.zarr | dataset | SpatialData | 1.400252e+09 | LNdpQjV21yjPlL8hgJW6dA | 8809.0 | None | ... | True | False | 2026-01-20 20:00:29.408312+00:00 | 1 | 1 | 1 | 2 | 1933 | None | 40 |
| 12853 | cyzNRxkUQF1sMVrr0000 | vitessce_examples/habib17.reference.json | Reference JSON for H5AD file, Habib et al., 20... | .json | NaN | NaN | 5.435750e+05 | XFOV2X6Bw6_zTugTOEBehg | NaN | None | ... | True | False | 2026-01-20 19:52:54.593799+00:00 | 1 | 1 | 1 | 2 | 1932 | None | 40 |
| 12852 | NNUzTpWz3a0PU2aT0000 | vitessce_examples/habib17.h5ad | Habib et al., 2017 Nature Methods, h5ad | .h5ad | dataset | AnnData | 2.258652e+07 | nBetKKNFs4mjJ04X_f4uaA | NaN | None | ... | True | False | 2026-01-20 19:52:45.252392+00:00 | 1 | 1 | 1 | 2 | 1932 | None | 40 |
| 12854 | Ljx9cSOxELkGisVt0000 | vitessce_examples/habib17.adata.zarr | Habib et al., 2017 Nature Methods, zarr | .zarr | dataset | AnnData | 1.060106e+07 | YPuOwAd5BZ3pbPoGNBH4aw | 208.0 | None | ... | True | False | 2026-01-20 19:53:03.970394+00:00 | 1 | 1 | 1 | 2 | 1932 | None | 40 |
| 12762 | PigRQD8Yoj4GKBJo0000 | vitessce_examples/at3_1m4_01.tif | NaN | .tif | NaN | NaN | 3.102020e+05 | PQU8IPgfr43-EeVSiHFY9Q | NaN | None | ... | True | False | 2026-01-14 14:42:53.949834+00:00 | 1 | 1 | 1 | 2 | NaN | None | 40 |
| 12759 | sKPQwWK8muQFXjAp0000 | vitessce_examples/Xenium_V1_humanLung_Cancer_F... | NaN | .tif | NaN | NaN | 1.190771e+09 | 37IPIKhuwptPftWMRjKodr | NaN | None | ... | True | False | 2026-01-14 14:27:37.821779+00:00 | 1 | 1 | 1 | 2 | NaN | None | 40 |
| 13134 | wkRgbeUNJLAPN9Re0000 | vitessce_examples/VAN0006-LK-2-85-PAS_register... | PAS OME-TIFF file, Neumann et al., 2020 | .tif | dataset | NaN | 1.021561e+09 | pa3FYqKL6afG8PduprhRJk | NaN | None | ... | True | False | 2026-01-28 23:32:35.755947+00:00 | 1 | 1 | 1 | 2 | 2244 | None | 40 |
| 13135 | mPRpRQxVjW5UxKKz0000 | vitessce_examples/VAN0006-LK-2-85-PAS_register... | PAS offsets file, Neumann et al., 2020 | .json | NaN | NaN | 3.600000e+01 | 5ADv5d7DI5oYVaMOPnhqiw | NaN | None | ... | True | False | 2026-01-28 23:36:27.657135+00:00 | 1 | 1 | 1 | 2 | 2244 | None | 40 |
| 1390 | bjH534dxVi1drmLZ0000 | visium_aligned_guide_min.zarr | NaN | .zarr | dataset | SpatialData | 5.809880e+06 | M4MhCm2NH0ZFzcv1cQ8Q9g | 133.0 | None | ... | False | False | 2025-03-25 18:18:04.889274+00:00 | 1 | 1 | 1 | 2 | 544 | None | 6 |
| 1401 | bjH534dxVi1drmLZ0001 | visium_aligned_guide_min.zarr | NaN | .zarr | dataset | SpatialData | 5.809684e+06 | a8rVkf_kjp9To9KI06i03g | 133.0 | None | ... | True | False | 2025-03-26 15:15:03.452298+00:00 | 1 | 1 | 1 | 2 | 546 | None | 6 |
| 21092 | XrsrpoDTl686DsHO0000 | trimgalore/WT_REP2_trimmed_2.fastq.gz_trimming... | Output artifact for run 7994 | .txt | NaN | NaN | 2.945000e+03 | Zkks_pMt40x-dkVn1uMacA | NaN | None | ... | True | False | 2026-04-28 11:02:45.298135+00:00 | 1 | 1 | 1 | 2 | 6999 | None | 54 |
| 21091 | 5pWHP6qrJonnQtzF0000 | trimgalore/WT_REP2_trimmed_1.fastq.gz_trimming... | Output artifact for run 7994 | .txt | NaN | NaN | 2.762000e+03 | CwkJVxQFJNeRqT0uj7lGqA | NaN | None | ... | True | False | 2026-04-28 11:02:41.499010+00:00 | 1 | 1 | 1 | 2 | 6999 | None | 54 |
20 rows × 22 columns
contains¶
db.Transform.filter(description__contains="search").to_dataframe().head(5)
Show 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
| 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
| 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 | NaN | NaN | 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 | NaN | NaN | 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 | NaN | NaN | 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#  | ln.Q(suffix=".fastq.gz")).to_dataframe()
Show 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 | NaN | None | 1.981608e+06 | 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 | NaN | None | 7.376530e+05 | 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 | NaN | None | 4.259756e+06 | 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 | NaN | None | 1.727503e+06 | 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 | NaN | None | 4.259756e+06 | 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 | NaN | None | 1.727503e+06 | 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 | 2.939891e+10 | 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 | 7.675472e+09 | 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 | 2.955347e+10 | 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 | 7.725840e+09 | 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... | NaN | .jpg | NaN | None | 1.452900e+04 | 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 | 1.234670e+05 | A_WjRYau-c1h9U6yaDGmZQ | None | None | ... | True | False | 2026-06-01 09:38:35.976330+00:00 | 1 | 1 | 1 | 59 | 8541 | None | 54 |
| 23622 | F9Tn8DfxnBPGtssK0000 | temp/output/fetchngs/fastq/SRX9315476_SRR12848... | Output artifact for run 8541 | .fastq.gz | dataset | None | 1.315390e+05 | l3AcXYhK-NlrqV1yN_O_eQ | None | None | ... | True | False | 2026-06-01 09:38:31.103701+00:00 | 1 | 1 | 1 | 59 | 8541 | None | 54 |
| 23621 | FtiwkNxd0Ila7VWx0000 | temp/output/fetchngs/fastq/SRX11047067_SRR1470... | Output artifact for run 8541 | .fastq.gz | dataset | None | 1.500000e+02 | eRQN0cs_0cXgLYjgH3w-2g | None | None | ... | True | False | 2026-06-01 09:38:26.673415+00:00 | 1 | 1 | 1 | 59 | 8541 | None | 54 |
| 23620 | Xh881SEOzEhkxVBh0000 | temp/output/fetchngs/fastq/SRX10940790_SRR1459... | Output artifact for run 8541 | .fastq.gz | dataset | None | 4.730000e+02 | y9MHFf3vRX16okoS8Z7t8g | None | None | ... | True | False | 2026-06-01 09:38:22.275334+00:00 | 1 | 1 | 1 | 59 | 8541 | None | 54 |
| 23619 | U4GV6WjzB72LJJNy0000 | temp/output/fetchngs/fastq/SRX10940790_SRR1459... | Output artifact for run 8541 | .fastq.gz | dataset | None | 4.590000e+02 | akdizw8fn1VE03NeLgfF0w | None | None | ... | True | False | 2026-06-01 09:38:18.479607+00:00 | 1 | 1 | 1 | 59 | 8541 | None | 54 |
| 23617 | 1YEM2Tzio0JpaPke0000 | temp/output/fetchngs/fastq/SRX9504942_SRR13055... | Output artifact for run 8541 | .fastq.gz | dataset | None | 7.149070e+05 | WtUUYMbEqFDdN6IG4sRBwQ | None | None | ... | True | False | 2026-06-01 09:37:53.956200+00:00 | 1 | 1 | 1 | 59 | 8541 | None | 54 |
| 23616 | 8DhYtWgZJO545TJo0000 | temp/output/fetchngs/fastq/SRX9504942_SRR13055... | Output artifact for run 8541 | .fastq.gz | dataset | None | 7.217050e+05 | qXc2e_QdrPTCG8DIIBuLiA | None | None | ... | True | False | 2026-06-01 09:37:39.002608+00:00 | 1 | 1 | 1 | 59 | 8541 | None | 54 |
| 23615 | NgZujyEK9KmFMlFK0000 | temp/output/fetchngs/fastq/SRX9504942_SRR13055... | Output artifact for run 8541 | .fastq.gz | dataset | None | 7.176930e+05 | XsiU2GP87-OURwoJJa795A | None | None | ... | True | False | 2026-06-01 09:37:29.243127+00:00 | 1 | 1 | 1 | 59 | 8541 | None | 54 |
| 23614 | rLzlXSOpP8o1piIs0000 | temp/output/fetchngs/fastq/SRX9504942_SRR13055... | Output artifact for run 8541 | .fastq.gz | dataset | None | 7.168620e+05 | w_NDeTVrKNbaxyEqvBoKBA | None | None | ... | True | False | 2026-06-01 09:37:24.188066+00:00 | 1 | 1 | 1 | 59 | 8541 | None | 54 |
20 rows × 22 columns
negate/ unequal¶
db.Artifact.filter(~ln.Q(suffix=".jpg")).to_dataframe()
Show 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 | |||||||||||||||||||||
| 31441 | N2N25ecPjU1uhIRN0000 | fasta/cytochrome_c_human_aa_frequencies.parquet | Amino-acid composition analysis of human cytoc... | .parquet | dataset | DataFrame | 2946.0 | arOXbnDIa8lATHRFYegTfQ | None | 20.0 | ... | True | False | 2026-09-08 22:10:17.518495+00:00 | 1 | 1 | 1 | 2 | 14388 | None | 76 |
| 31438 | x7gkzDW9dDIXjMgF0000 | fasta/cytochrome_c_human.fasta | Human cytochrome c (CYCS, UniProt P99999) prot... | .fasta | NaN | NaN | 183.0 | 6rYbxRvZr5LftJaBZ3Ltaw | None | NaN | ... | True | False | 2026-09-08 22:08:58.275001+00:00 | 1 | 1 | 1 | 2 | 14387 | None | 76 |
| 31415 | W3q98o3Rxv5wxiS40000 | NaN | mix-test | .txt | NaN | NaN | 62.0 | xMtGxadDGhAvlDQKmNJ_ZA | None | NaN | ... | True | False | 2026-09-08 20:30:51.088739+00:00 | 1 | 1 | 1 | 2 | NaN | None | 3 |
| 31414 | Uu0CthUXD2BP4MMr0000 | NaN | upload2 | .txt | NaN | NaN | 54.0 | wzKrXgQvmWqiM4yGu9uEOA | None | NaN | ... | True | False | 2026-09-08 20:23:51.195724+00:00 | 1 | 1 | 1 | 2 | NaN | None | 3 |
| 31410 | ud8k72RyfgQ1nWYE0000 | NaN | check upload | .txt | NaN | NaN | 45.0 | IHTGvkKqzNPWo5dcubvmvw | None | NaN | ... | True | False | 2026-09-08 19:41:22.287573+00:00 | 1 | 1 | 1 | 2 | NaN | None | 3 |
| 31264 | g1uMDs0pD0YOqv570000 | proteins/favorite_protein.fasta | Human lysozyme C (P61626) sequence in FASTA fo... | .fasta | NaN | NaN | 164.0 | GAIdBieLvpawYHF9RVeAWA | None | NaN | ... | True | False | 2026-09-07 06:24:31.330992+00:00 | 1 | 1 | 1 | 2 | 14262 | None | 18 |
| 31261 | lr9Dzpx1ikjncS6B0000 | proteins/protein.fasta | avGFP (P42212) amino acid sequence in FASTA fo... | .fasta | NaN | NaN | 310.0 | FAicO7EuYVgg-fbnIhS0Dw | None | NaN | ... | True | False | 2026-09-07 06:23:47.778386+00:00 | 1 | 1 | 1 | 2 | 14260 | None | 18 |
| 31259 | Vrp32G5NMTMNLA8C0000 | NaN | Green fluorescent protein (GFP) sequence | .fasta | NaN | NaN | 288.0 | fiZX67uu9zP_AECYfjmWgQ | None | NaN | ... | True | False | 2026-09-07 06:23:14.043343+00:00 | 1 | 1 | 1 | 2 | 14258 | None | 18 |
| 30656 | Shd8DEzRucu3Xvdc0001 | laminprofiler/duration_vs_time.svg | duration_in_sec vs. time — init | .svg | NaN | NaN | 34330.0 | LyV1nemOxss-GcvMhaTWlA | None | NaN | ... | True | False | 2026-08-22 18:56:19.059415+00:00 | 1 | 1 | 1 | 2 | 13753 | None | 9 |
| 30653 | Shd8DEzRucu3Xvdc0000 | laminprofiler/duration_vs_time.svg | duration_in_sec vs. time — init | .svg | NaN | NaN | 39971.0 | BGa0TB6WTWMsss9ppxWUUw | None | NaN | ... | False | False | 2026-08-22 18:53:54.778547+00:00 | 1 | 1 | 1 | 2 | 13751 | None | 9 |
| 30651 | L1HGZu8CMlrrxACm0003 | laminprofiler/duration_vs_time_import_lamindb_... | duration_in_sec vs. time — init | .svg | NaN | NaN | 39971.0 | 5V2k7GONKqH1vVa73eW-BQ | None | NaN | ... | True | False | 2026-08-22 18:51:50.828812+00:00 | 1 | 1 | 1 | 2 | 13750 | None | 9 |
| 30305 | TeERjy0Nt2yY3Cr00000 | sheet_exports/Experiments.csv | Export of sheet fNBzuANAusnkFv2p: Our experime... | .csv | dataset | DataFrame | 125.0 | no__3ZZD0t_AgOMO91saUg | None | 3.0 | ... | True | False | 2026-08-20 10:36:31.440148+00:00 | 1 | 1 | 1 | 2 | 13478 | None | 46 |
| 29994 | fzIkx9MnWq6GVhBj0000 | math/powers_of_4_first_10.txt | Text file listing the first 10 powers of 4 | .txt | NaN | NaN | 110.0 | wFhHIH5JbLZS0o0_E0Dx1g | None | NaN | ... | True | False | 2026-08-17 11:30:32.142793+00:00 | 1 | 1 | 1 | 2 | 13237 | None | 76 |
| 29992 | Y4MKT5zj0Fzl6swK0000 | outputs/powers_of_3.txt | First 10 powers of 3 (3^1 through 3^10) | .txt | NaN | NaN | 101.0 | fwGZaFBn16u6wbqF-A2TzQ | None | NaN | ... | True | False | 2026-08-17 11:28:53.844630+00:00 | 1 | 1 | 1 | 2 | 13236 | None | 76 |
| 29991 | KKfGLmFwvmSb56H50000 | NaN | Embedded asset | .png | __easset__ | NaN | 349552.0 | T1sjyK0wVl5t_Ibr1lpqNw | None | NaN | ... | True | False | 2026-08-17 11:17:07.925399+00:00 | 1 | 1 | 1 | 2 | NaN | None | 46 |
| 29974 | VPpPBvk1EiMoEZJD0000 | datasets/math/fib30_workflow/parity.json | Even/odd check of the sum of the first 30 Fibo... | .json | NaN | NaN | 40.0 | 28ZpUqGu3SW9KITScUTJFA | None | NaN | ... | True | False | 2026-08-17 09:57:07.284293+00:00 | 1 | 1 | 1 | 2 | 13225 | None | 76 |
| 29972 | R7Hq7dALjxOKQJOX0000 | datasets/math/fib30_workflow/sum.json | Sum of the first 30 Fibonacci numbers. | .json | NaN | NaN | 20.0 | JvZGFprq7qx699-J3O_H5g | None | NaN | ... | True | False | 2026-08-17 09:56:53.848403+00:00 | 1 | 1 | 1 | 2 | 13224 | None | 76 |
| 29970 | W6Rs8HwG4l9VtThv0000 | datasets/math/fib30_workflow/numbers.json | First 30 Fibonacci numbers. | .json | NaN | NaN | 300.0 | qQyW0dtcPdhKbcqjqUVG7A | None | NaN | ... | True | False | 2026-08-17 09:56:37.938618+00:00 | 1 | 1 | 1 | 2 | 13223 | None | 76 |
| 29921 | iVxey5KAwg69PrSz0000 | esc_ipsc/heatmap_top50.png | Clustered heatmap of top-50 DE genes (by padj)... | .png | NaN | NaN | 312352.0 | IuoQ-te-jQXthkk5Qr0E8w | None | NaN | ... | True | False | 2026-08-16 10:39:12.555464+00:00 | 1 | 1 | 1 | 2 | 13184 | None | 60 |
| 29920 | rBcRShqxKX33I33l0000 | esc_ipsc/volcano_plot.png | Volcano plot: log2FC vs -log10 padj (ESC vs iPSC) | .png | NaN | NaN | 118730.0 | XMRsdEIO8ZQ-KjBY1jvlhA | None | NaN | ... | True | False | 2026-08-16 10:39:10.936477+00:00 | 1 | 1 | 1 | 2 | 13184 | None | 60 |
20 rows × 22 columns
JSON¶
db.Run.filter(params__learning_rate__gt=0.01).to_dataframe()
Show 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.