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
! database has module pertdb, configure it: lamin settings modules set bionty,pertdb
Get an overview¶
Return the most recent entries of the Artifact registry as a DataFrame:
db.Artifact.to_dataframe()
Show code cell output
! 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 | 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 |
| 29919 | peQnjuPsCigEnV7u0000 | esc_ipsc/metadata.csv | Sample metadata (sample, condition) for ESC vs... | .csv | NaN | DataFrame | 247.0 | Ddu7KmdQm1nHDBiX1puIdA | None | NaN | ... | True | False | 2026-08-16 10:38:37.843063+00:00 | 1 | 1 | 1 | 2 | 13183 | None | 60 |
| 29918 | ovdxb8SwOs10PLnQ0000 | esc_ipsc/counts.csv | Raw gene-level counts matrix (gene_id x sample... | .csv | NaN | DataFrame | 2632050.0 | 8D5m-Qbtdy3iKzSnYSK4jA | None | NaN | ... | True | False | 2026-08-16 10:38:29.011279+00:00 | 1 | 1 | 1 | 2 | 13183 | None | 60 |
| 29866 | GPWEB6BcwRGcrM0G0000 | de_summary.csv | Differential expression summary table across L... | .csv | dataset | DataFrame | 29431.0 | tlLByfIghv0zn5Q_Feo0Rw | None | 400.0 | ... | True | False | 2026-08-14 16:15:35.284810+00:00 | 746 | 746 | 1 | 2 | 13139 | None | 46 |
| 29865 | UTf4W9tEsyHtwRbk0000 | final_clustered.h5ad | Leiden-clustered AnnData with differential exp... | .h5ad | dataset | AnnData | 161656.0 | AKRHvLP-1Fh0oSrSaOu5ww | None | 92.0 | ... | True | False | 2026-08-14 16:15:33.729897+00:00 | 746 | 746 | 1 | 2 | 13139 | None | 46 |
| 29861 | 77JoflIbPRhrMg7K0000 | pca_embeddings.h5ad | Log-normalized counts with PCA embeddings in a... | .h5ad | dataset | AnnData | 64432.0 | 1FQEeOhhC70r8CrhTDpYqw | None | 92.0 | ... | True | False | 2026-08-14 16:13:53.440164+00:00 | 746 | 746 | 1 | 2 | 13137 | None | 46 |
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 | |||
| 31264 | g1uMDs0pD0YOqv570000 | proteins/favorite_protein.fasta | testuser1 |
| 31261 | lr9Dzpx1ikjncS6B0000 | proteins/protein.fasta | testuser1 |
| 31259 | Vrp32G5NMTMNLA8C0000 | NaN | testuser1 |
| 30656 | Shd8DEzRucu3Xvdc0001 | laminprofiler/duration_vs_time.svg | falexwolf |
| 30653 | Shd8DEzRucu3Xvdc0000 | laminprofiler/duration_vs_time.svg | falexwolf |
| 30651 | L1HGZu8CMlrrxACm0003 | laminprofiler/duration_vs_time_import_lamindb_... | falexwolf |
| 30305 | TeERjy0Nt2yY3Cr00000 | sheet_exports/Experiments.csv | sheetalgiri |
| 29994 | fzIkx9MnWq6GVhBj0000 | math/powers_of_4_first_10.txt | ebad |
| 29992 | Y4MKT5zj0Fzl6swK0000 | outputs/powers_of_3.txt | ebad |
| 29991 | KKfGLmFwvmSb56H50000 | NaN | sheetalgiri |
| 29974 | VPpPBvk1EiMoEZJD0000 | datasets/math/fib30_workflow/parity.json | ebad |
| 29972 | R7Hq7dALjxOKQJOX0000 | datasets/math/fib30_workflow/sum.json | ebad |
| 29970 | W6Rs8HwG4l9VtThv0000 | datasets/math/fib30_workflow/numbers.json | ebad |
| 29921 | iVxey5KAwg69PrSz0000 | esc_ipsc/heatmap_top50.png | ishitajain9717 |
| 29920 | rBcRShqxKX33I33l0000 | esc_ipsc/volcano_plot.png | ishitajain9717 |
| 29919 | peQnjuPsCigEnV7u0000 | esc_ipsc/metadata.csv | ishitajain9717 |
| 29918 | ovdxb8SwOs10PLnQ0000 | esc_ipsc/counts.csv | ishitajain9717 |
| 29866 | GPWEB6BcwRGcrM0G0000 | de_summary.csv | sheetalgiri |
| 29865 | UTf4W9tEsyHtwRbk0000 | final_clustered.h5ad | sheetalgiri |
| 29861 | 77JoflIbPRhrMg7K0000 | pca_embeddings.h5ad | sheetalgiri |
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 | |||||||||||||||||||||
| 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 |
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 | |||||||||||||||||||||
| 763 | 9mQr4NM1PWE1 | id | str | None | None | 0 | 0 | None | None | None | ... | None | False | False | 2026-08-21 10:47:04.575513+00:00 | 1 | 1 | 1 | 2 | None | 665 |
| 762 | ZVuuXrUKMe1n | genome | str | None | None | 0 | 0 | None | None | None | ... | None | False | False | 2026-08-21 10:47:03.459785+00:00 | 1 | 1 | 1 | 2 | None | NaN |
| 761 | kSc5Im5srxbm | template | str | None | None | 0 | 0 | None | None | None | ... | None | False | False | 2026-08-21 10:47:02.827953+00:00 | 1 | 1 | 1 | 2 | None | NaN |
| 760 | A9xhVXw5UhNH | protospacer | str | None | None | 0 | 0 | None | None | None | ... | None | False | False | 2026-08-21 10:47:02.333256+00:00 | 1 | 1 | 1 | 2 | None | NaN |
| 759 | 0veFcbyn9je7 | reference | str | None | None | 0 | 0 | None | None | None | ... | None | False | False | 2026-08-21 10:47:01.836545+00:00 | 1 | 1 | 1 | 2 | None | 665 |
| 758 | lcsv7ZddWLzn | antibody | str | None | None | 0 | 0 | None | None | None | ... | None | False | False | 2026-08-21 10:47:00.699225+00:00 | 1 | 1 | 1 | 2 | None | NaN |
| 757 | 3DyteOwjxxUM | control_replicate | int | None | None | 0 | 0 | None | None | None | ... | None | False | False | 2026-08-21 10:47:00.201466+00:00 | 1 | 1 | 1 | 2 | None | NaN |
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 | ||||||||||||||||
| 74777 | qNSUSk3QbHWicJdP | None | None | None | None | None | False | False | 2026-09-07 06:24:53.538217+00:00 | 1 | 1 | 1 | 18 | 52403 | None | 14263 |
| 74776 | V8hDEg2A8WIvrEcR | None | None | None | None | None | False | False | 2026-09-07 06:23:11.114083+00:00 | 1 | 1 | 1 | 18 | 17638 | None | 14257 |
| 74775 | wVW7Ijufm6wJEe10 | None | None | None | None | None | False | False | 2026-09-07 06:18:17.438302+00:00 | 1 | 1 | 1 | 18 | 2759 | None | 14256 |
| 74774 | g78qq5CLQRzFskBO | None | None | None | None | None | False | False | 2026-09-07 06:17:58.123106+00:00 | 1 | 1 | 1 | 18 | 611 | None | 14255 |
| 74773 | sLnvGDKBWb3EW3y6 | None | None | None | None | None | False | False | 2026-09-07 06:17:40.607062+00:00 | 1 | 1 | 1 | 18 | 2319 | None | 14254 |
| 74772 | H4aEf1VwsZRvYGzN | None | None | None | None | None | False | False | 2026-09-06 09:25:33.370614+00:00 | 1 | 1 | 1 | 18 | 2759 | None | 14250 |
| 74771 | zyXdyUxWe30NWVld | None | None | None | None | None | False | False | 2026-09-06 09:25:15.916342+00:00 | 1 | 1 | 1 | 18 | 611 | None | 14249 |
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 | |||||||||||||||||||||
| 14265 | hyeqHfacu4CrBBh8 | NaN | None | NaN | 2026-09-07 06:51:44.943642+00:00 | NaT | None | None | None | None | ... | 2026-09-07 06:51:44.943642+00:00 | 1 | 1 | 1 | 1792 | NaN | 31270 | None | 9 | NaN |
| 14264 | 6IlnOAVe5MSbbOrv | NaN | None | NaN | 2026-09-07 06:24:57.409553+00:00 | 2026-09-07 06:25:00.962439+00:00 | None | None | None | None | ... | 2026-09-07 06:24:57.409553+00:00 | 1 | 1 | 1 | 1791 | 31268 | 31257 | None | 18 | NaN |
| 14263 | 3kC9EgTvebjGcILr | NaN | None | lamin_executable_prompt | 2026-09-07 06:24:44.324402+00:00 | 2026-09-07 06:24:53.838886+00:00 | {'model': 'gemini-flash-latest', 'prompt': 'Cr... | None | None | None | ... | 2026-09-07 06:24:44.324402+00:00 | 1 | 1 | 1 | 1516 | 31267 | 31257 | None | 18 | NaN |
| 14262 | K3CskLrggsFGfu1K | NaN | None | NaN | 2026-09-07 06:24:30.744891+00:00 | 2026-09-07 06:24:33.046998+00:00 | None | None | None | None | ... | 2026-09-07 06:24:30.744891+00:00 | 1 | 1 | 1 | 1790 | 31265 | 31257 | None | 18 | 14261 |
| 14261 | Aqy19mmIwaGVXXRB | Write and run a script that saves a favorite p... | None | NaN | 2026-09-07 06:24:16.264125+00:00 | 2026-09-07 06:24:38.548504+00:00 | None | {'n_steps': 8, 'n_tokens': 0, 'n_tool_calls': 8} | None | None | ... | 2026-09-07 06:24:16.264125+00:00 | 1 | 1 | 1 | 1587 | 31266 | NaN | None | 18 | NaN |
| 14260 | BqHrQu2ajutRJS0W | NaN | None | NaN | 2026-09-07 06:23:47.192648+00:00 | 2026-09-07 06:23:49.433653+00:00 | None | None | None | None | ... | 2026-09-07 06:23:47.192648+00:00 | 1 | 1 | 1 | 1789 | 31262 | 31257 | None | 18 | 14259 |
| 14259 | 9JutMtmLd6qoLFRr | Write and run save_protein.py to store a favor... | None | NaN | 2026-09-07 06:23:27.531114+00:00 | 2026-09-07 06:23:56.769660+00:00 | None | {'n_steps': 8, 'n_tokens': 195874, 'n_tool_cal... | None | None | ... | 2026-09-07 06:23:27.531114+00:00 | 1 | 1 | 1 | 1521 | 31263 | NaN | None | 18 | NaN |
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 | |||||||||||||||||||||
| 259 | hXyVCL89wsTtMjpg | nf-core/proteinfold input | None | 2.0 | True | False | Feature | NaN | None | 2ulsT0d5w3hmBZcP_bs36w | ... | False | False | False | 2026-08-21 10:47:13.579757+00:00 | 1 | 1 | 1 | 2 | None | None |
| 258 | 3RpySfk5IOSZ5gv7 | nf-core/methylseq input with sample link | None | 4.0 | True | False | Feature | NaN | None | RqFmVCqi7mXq7os5d0wOVQ | ... | False | False | False | 2026-08-21 10:47:11.899753+00:00 | 1 | 1 | 1 | 2 | None | None |
| 257 | ta9tRj6ohahwD9Me | nf-core/crisprseq targeted input with sample link | None | 6.0 | True | False | Feature | NaN | None | NGdsJQUw9YMPeHYCwCyJhQ | ... | False | False | False | 2026-08-21 10:47:10.225990+00:00 | 1 | 1 | 1 | 2 | None | None |
| 256 | Miam1meXOpW8GMAZ | nf-core/chipseq input with sample link | None | 5.0 | True | False | Feature | NaN | None | wwJM8x5vHyoL-0SW0TMw5A | ... | False | False | False | 2026-08-21 10:47:08.551482+00:00 | 1 | 1 | 1 | 2 | None | None |
| 255 | xlgVZ0Shp26RA9WL | nf-core/atacseq input with sample link | None | 6.0 | True | False | Feature | NaN | None | svZFXX1HqujbCtBr8f7i3Q | ... | False | False | False | 2026-08-21 10:47:06.871007+00:00 | 1 | 1 | 1 | 2 | None | None |
| 254 | SVFyXEgSXV6AcP3q | nf-core/scrnaseq input with sample link | None | 5.0 | True | False | Feature | NaN | None | IraZQMY13GV934o2VVQbQQ | ... | False | False | False | 2026-08-21 10:47:05.188012+00:00 | 1 | 1 | 1 | 2 | None | None |
| 253 | NPByL9dNtRxytOWt | Biospecimen registry | None | 12.0 | True | False | Feature | DataFrame | None | 5FT71wTgmTxAFEVnabtYDQ | ... | False | False | False | 2026-08-21 08:54:43.934202+00:00 | 1 | 1 | 1 | 2 | None | 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 | |||||||||||||||||||
| 1792 | o39ljgTzvFew0007 | __lamin_io_snapshot__.py | CLI: lamin | script | from __future__ import annotations\n\nimport j... | MtRsRCN8KjqDWSOj9Y9WJw | None | None | None | True | False | 2026-09-07 06:51:44.709622+00:00 | 1 | 1 | 1 | None | None | NaN | 9 |
| 1791 | 5u2Y0v8oZgJy000J | test_02/curate_artifact.py | NaN | script | import lamindb as ln\n\nSOURCE_INSTANCE = "lam... | nORUfSvkMEFYpuL2Z6R1vA | None | None | None | True | False | 2026-09-07 06:24:53.327404+00:00 | 1 | 1 | 1 | None | None | 14263 | 18 |
| 1790 | wJoUb1hzekss0004 | save_protein.py | NaN | script | """Write a favorite protein sequence to a FAST... | EZvDkaq_szsNDUa5UvYjUA | None | None | None | True | False | 2026-09-07 06:24:30.735756+00:00 | 1 | 1 | 1 | None | None | 14261 | 18 |
| 1789 | YbojWJGRcQaj0003 | claudecode/save_protein.py | NaN | script | """Write a favorite protein sequence (avGFP) t... | jwbOYtcgkWAHR7J-orD4-A | None | None | None | True | False | 2026-09-07 06:23:47.183565+00:00 | 1 | 1 | 1 | None | None | 14259 | 18 |
| 1788 | FIOuXJpXvZir0002 | laminagent/save_protein_artifact.py | NaN | script | import lamindb as ln\nln.track()\nfrom pathlib... | iGiTYi8j6WMXq3jmvHUqmg | None | None | None | True | False | 2026-09-07 06:23:10.890102+00:00 | 1 | 1 | 1 | None | None | 14257 | 18 |
| 1783 | 77UArcsm8SY5000C | laminprofiler/plot_duration_vs_date.py | Plot import time improvement for `import lamin... | script | """Plot import time improvement for `import la... | oY-GFUp6VRjzm1wbE2QKsg | None | None | None | True | False | 2026-08-22 18:56:09.418613+00:00 | 1 | 1 | 1 | None | None | NaN | 9 |
| 1782 | 77UArcsm8SY5000B | laminprofiler/plot_duration_vs_date.py | Plot import time improvement for `import lamin... | script | """Plot import time improvement for `import la... | 4T7YRW9Htpshl14YK29rpg | None | None | None | False | False | 2026-08-22 18:55:19.046407+00:00 | 1 | 1 | 1 | None | None | NaN | 9 |
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 | ||||||||||||||
| 781 | 1HB4MOep | day | None | None | None | False | False | 2026-08-21 08:43:08.599750+00:00 | 1 | 1 | 1 | 2 | None | 425 |
| 780 | yvYm5DuA | h | None | None | None | False | False | 2026-08-21 08:43:08.104982+00:00 | 1 | 1 | 1 | 2 | None | 425 |
| 777 | f0vQmjTM | qPCR | None | None | None | False | False | 2026-08-20 12:28:33.077386+00:00 | 1 | 1 | 1 | 2 | None | 316 |
| 776 | vSfLr3qc | ELISA | None | None | None | False | False | 2026-08-20 12:28:32.586336+00:00 | 1 | 1 | 1 | 2 | None | 316 |
| 775 | HEMr2Ywn | Viability screen | None | None | None | False | False | 2026-08-20 12:28:32.098588+00:00 | 1 | 1 | 1 | 2 | None | 316 |
| 774 | IxlO8rNm | Metabolomics | None | None | None | False | False | 2026-08-20 12:28:31.608624+00:00 | 1 | 1 | 1 | 2 | None | 316 |
| 773 | zs01QHRe | Proteomics | None | None | None | False | False | 2026-08-20 12:28:31.118874+00:00 | 1 | 1 | 1 | 2 | None | 316 |
! skipping module 'pertdb': 'pertdb' wasn't configured in this environment -- run: lamin settings modules set pertdb
If your database instance also doesn't have it, go to your instance settings page and add it under 'schema modules' (or ask an admin to do so).
******************
* module: bionty *
******************
CellLine
| uid | name | ontology_id | abbr | synonyms | description | is_locked | created_at | branch_id | created_on_id | space_id | created_by_id | run_id | source_id | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | ||||||||||||||
| 250 | 2rD83IhFD8zXmX | immortal uterine cervix-derived epithelial cel... | CLO:0000283 | None | 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 |
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 | {DMSO, IFNG} | {T cell, B cell} | EFO:0008913 | 21.6 |
You can query for whether a dataset is annotated by a feature:
db.Artifact.filter(perturbation.is_null(False)).to_dataframe(include="features")
Show code cell output
| uid | key | perturbation | cell_type_by_model | assay_oid | temperature | |
|---|---|---|---|---|---|---|
| id | ||||||
| 11925 | AsTXi6hzDFM7L17t0003 | examples/mini_immuno_with_single_typo.parquet | {DMSO, IFNG} | {T cell, B cell} | EFO:0008913 | 21.6 |
Cheat sheet: comparators¶
You can qualify the type of comparison in a query by using a comparator.
Below is a list of the most important ones, but Django supports about two dozen field comparators field__comparator=value.
and¶
db.Artifact.filter(suffix=".h5ad", records=experiment_1).to_dataframe()
Show code cell output
| 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 | |||||||||||||||||||||
| 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 |
| 29919 | peQnjuPsCigEnV7u0000 | esc_ipsc/metadata.csv | Sample metadata (sample, condition) for ESC vs... | .csv | NaN | DataFrame | 247.0 | Ddu7KmdQm1nHDBiX1puIdA | None | NaN | ... | True | False | 2026-08-16 10:38:37.843063+00:00 | 1 | 1 | 1 | 2 | 13183 | None | 60 |
| 29918 | ovdxb8SwOs10PLnQ0000 | esc_ipsc/counts.csv | Raw gene-level counts matrix (gene_id x sample... | .csv | NaN | DataFrame | 2632050.0 | 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 | 306117.0 | FowJyxPuUJwhghAAm2Y5UQ | None | NaN | ... | True | False | 2026-08-12 09:37:35.546038+00:00 | 1 | 1 | 1 | 2 | NaN | None | 46 |
| 29604 | 3c3xD2NjSmqnF71S0000 | examples/squares_1_to_10_sum.parquet | Sum of squares for integers 1 through 10 | .parquet | dataset | DataFrame | 1704.0 | qRuYNcZ69xOB-6Eg-LSuFQ | None | 1.0 | ... | True | False | 2026-08-11 09:09:23.736644+00:00 | 1 | 1 | 1 | 2 | 12940 | None | 76 |
| 29601 | PtALuKQKI2kalopb0000 | examples/squares_1_to_10.parquet | Squares of integers from 1 through 10 | .parquet | dataset | DataFrame | 2284.0 | PgOVDz6mUqBPMF04XWUoGQ | None | 10.0 | ... | True | False | 2026-08-11 09:05:55.611943+00:00 | 1 | 1 | 1 | 2 | 12938 | None | 76 |
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 | |||||||||||||||||||||
| 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 |
| 29919 | peQnjuPsCigEnV7u0000 | esc_ipsc/metadata.csv | Sample metadata (sample, condition) for ESC vs... | .csv | NaN | DataFrame | 247.0 | Ddu7KmdQm1nHDBiX1puIdA | None | NaN | ... | True | False | 2026-08-16 10:38:37.843063+00:00 | 1 | 1 | 1 | 2 | 13183 | None | 60 |
| 29918 | ovdxb8SwOs10PLnQ0000 | esc_ipsc/counts.csv | Raw gene-level counts matrix (gene_id x sample... | .csv | NaN | DataFrame | 2632050.0 | 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 | 306117.0 | FowJyxPuUJwhghAAm2Y5UQ | None | NaN | ... | True | False | 2026-08-12 09:37:35.546038+00:00 | 1 | 1 | 1 | 2 | NaN | None | 46 |
| 29604 | 3c3xD2NjSmqnF71S0000 | examples/squares_1_to_10_sum.parquet | Sum of squares for integers 1 through 10 | .parquet | dataset | DataFrame | 1704.0 | qRuYNcZ69xOB-6Eg-LSuFQ | None | 1.0 | ... | True | False | 2026-08-11 09:09:23.736644+00:00 | 1 | 1 | 1 | 2 | 12940 | None | 76 |
| 29601 | PtALuKQKI2kalopb0000 | examples/squares_1_to_10.parquet | Squares of integers from 1 through 10 | .parquet | dataset | DataFrame | 2284.0 | PgOVDz6mUqBPMF04XWUoGQ | None | 10.0 | ... | True | False | 2026-08-11 09:05:55.611943+00:00 | 1 | 1 | 1 | 2 | 12938 | None | 76 |
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.