Skip to main content
Ctrl+K
logo

Lamin Docs

Site Navigation

  • Guide
  • API Reference
  • Integrations
  • Changelog

Site Navigation

  • Guide
  • API Reference
  • Integrations
  • Changelog

Overview

  • Introduction
  • Tutorial

How to

  • Install & setup
  • Query & search
    • Query tables in storage
    • Query arrays in storage
  • Track notebooks, scripts & workflows
  • Organize datasets
    • Curate datasets
  • Manage changes
  • Access & manage ontologies
    • Manage biological ontologies
    • Access public ontologies
      • Gene
      • Protein
      • Organism
      • CellLine
      • CellType
      • CellMarker
      • Tissue
      • Disease
      • Phenotype
      • Pathway
      • ExperimentalFactor
      • DevelopmentalStage
      • Ethnicity
  • Transfer & sync data across databases

Use cases

  • Query & build atlases
    • CELLxGENE: scRNA-seq
      • Curate AnnData based on the CELLxGENE schema
    • Arc Virtual Cell Atlas
    • Hubmap
    • EWAS Data Hub: methylation array data
    • RxRx: cell imaging
  • Manage data types
    • scRNA-seq
      • Standardize and append a dataset
      • Query artifacts
      • Analyze a collection in memory
      • Train a machine learning model on a collection
      • Concatenate datasets to a single array store
      • Preprocessing and clustering 3k PBMCs
    • Bulk RNA-seq
    • Methylation
    • Flow cytometry
      • Append a new dataset
      • Query & integrate data
      • Analyze the collection and save a result
    • Spatial RNA-seq
      • Interactive visualization using Vitessce
      • Curate and ingest spatial data
      • Train a spatial ML model
    • Single-cell imaging
      • Generate single-cell images
      • Featurize single-cell images
      • Identify autophagy-positive cells
    • Multi-modal
    • EHR
  • Leverage ontologies
    • CellTypist
    • Gene Ontology (GO)
    • Cell type annotation and pathway analysis
    • RDF export & SPARQL queries
  • Trace data & code
    • Re-constructing Schmidt et al. (2022)
  • Manage computational pipelines
    • Nextflow
    • Redun
    • Snakemake
  • Manage MLOps
    • Lightning
    • Curate MNIST
    • Weights & Biases
    • MLFlow
    • ClearML
    • Croissant
  • Manage visualization dashboards
    • Vitessce: AnnData
    • Vitessce: SpatialData

The Hub

  • Manage records
  • Launch computational pipelines
  • Manage access permissions
  • Security

Other topics

  • System design
    • Will data & metadata stay in sync?
    • Will data get duplicated upon re-running code?
  • FAQ
    • Pydantic & Pandera vs. LaminDB
    • Can I disable tracking run inputs?
    • How do I validate & annotate arbitrary data structures?
    • What happens if I import a schema module without lamindb?
    • Where to store external links and IDs?
    • Keep artifacts local in a cloud instance
    • Django field validation
    • Why should I not index datasets with gene symbols?
    • How does search work?
  • Influences
  • Glossary

Query & search .md .md¶

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

Basics¶

Create a database object:

import lamindb as ln

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

Get an overview¶

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

db.Artifact.to_dataframe()
Show code cell output Hide code cell output
! truncated query result to limit=20 Artifact objects
uid key description suffix kind otype size hash n_files n_observations ... is_latest is_locked created_at branch_id created_on_id space_id storage_id run_id schema_id created_by_id
id
26942 fsOwNYGqASmvzxth0000 None Claude Code session transcript (rendered) .html None None 54089 9CRTGFcZZbEtDFycYMd5wg None NaN ... True False 2026-07-17 12:24:43.543883+00:00 1 1 1 2 NaN None 2
26916 Xtd7yycLiboMIvpS0000 None Claude Code session transcript (rendered) .html None None 5809 FP7Zoy9t8wYpymRcby9ZyA None NaN ... True False 2026-07-17 08:55:26.841894+00:00 1 1 1 2 NaN None 18
26914 99zGx7Bu1M2FE4Sw0000 None Human insulin protein sequence (UniProt P01308) .fasta None None 140 ldHpRp_1hWpgrMDU-5V6Uw None NaN ... True False 2026-07-17 08:55:13.654872+00:00 1 1 1 2 11163.0 None 18
26835 UttjBSC5KpOkLCnF0000 None Claude Code session transcript (rendered) .html None None 4971 Zwixao9rLkD1ETiPppQyzw None NaN ... True False 2026-07-16 14:14:00.907497+00:00 1 1 1 2 NaN None 76
26833 3n344O47mufZu0lO0000 None Human lysozyme C (P61626) sequence .fasta None None 180 aO0jQkhn0DAk_-6VEwLRYA None NaN ... True False 2026-07-16 14:13:46.211473+00:00 1 1 1 2 11103.0 None 76
26816 vmDUa3zok29bG7BU0000 None Claude Code session transcript (rendered) .html None None 11247 nS-ZUyqlOMkuarBVmHzoXA None NaN ... True False 2026-07-16 13:10:58.083436+00:00 1 1 1 2 NaN None 76
26814 HkcuyVEKNYUfvnZQ0000 None GFP protein sequence .fasta None None 288 u1GCC1M0z5hehWam9ry9Nw None NaN ... True False 2026-07-16 13:10:48.760491+00:00 1 1 1 2 11088.0 None 76
26812 mZGblHNvZOd591fX0000 None Favorite protein: human ubiquitin (P0CG47) .fasta None None 109 Bcds33u64jii0Hk6QbMjjQ None NaN ... True False 2026-07-16 13:02:36.587427+00:00 1 1 1 2 NaN None 76
26705 UnpJi7qjT0xzqMcg0000 None Claude Code session transcript (rendered) .html None None 75628 qVb_8ZKg2pfAsTZqud7qjQ None NaN ... True False 2026-07-15 14:11:04.281778+00:00 1 1 1 2 NaN None 2
26673 NuZqfITKaDxHtL8J0000 schmidt22/ifng-hits-cellstate-prioritized-targ... IFNG CRISPRa hits prioritized by screen streng... .parquet None DataFrame 15891 48DFEvVrjQ2m42IHT_t_fg None NaN ... True False 2026-07-15 10:22:51.241153+00:00 1 1 1 2 10980.0 None 2
26671 J3KAL83hx32Z86YC0000 None Claude Code session transcript (rendered) .html None None 118754 4Jqh500CRi5OwHIVqKXO2Q None NaN ... True False 2026-07-15 09:55:07.318686+00:00 1 1 1 2 NaN None 2
26667 v5yV12AQGsqqkiVo0002 schmidt22/ifng-hits-drug-repurposing-candidate... Step 2: approved/clinical compounds per MoA cl... .parquet None DataFrame 15309 hCfK7MBp8zinZiVaVt43eA None NaN ... True False 2026-07-15 09:50:50.509878+00:00 1 1 1 2 10976.0 None 2
26665 v5yV12AQGsqqkiVo0001 schmidt22/ifng-hits-drug-repurposing-candidate... Step 2: approved/clinical compounds per MoA cl... .parquet None DataFrame 15287 G9R5S-pvaKxe01Q33vrOog None NaN ... False False 2026-07-15 09:48:55.993853+00:00 1 1 1 2 10975.0 None 2
26663 v5yV12AQGsqqkiVo0000 schmidt22/ifng-hits-drug-repurposing-candidate... Step 2: approved/clinical compounds per MoA cl... .parquet None DataFrame 14608 UVc5k5VlV5-SC_2wwe4IjA None NaN ... False False 2026-07-15 09:32:54.545077+00:00 1 1 1 2 10974.0 None 2
26662 sHqkE5Vz9M9C6C900000 schmidt22/ifng-hits-druggability-ranked.parquet Step 2: selected IFN-g CRISPRa hits with Open ... .parquet None DataFrame 17018 UxAg8wSR-BHTuQRtudsBzA None NaN ... True False 2026-07-15 09:32:53.226608+00:00 1 1 1 2 10976.0 None 2
26640 AhvOvqOL3ABR8Ul10000 None Claude Code session transcript (rendered) .html None None 76422 iDqXSRg81e37hKlMJkuLgA None NaN ... True False 2026-07-14 17:27:38.790315+00:00 1 1 1 2 NaN None 2
26639 t4INEklbuA6APFil0000 None Claude Code session transcript (rendered) .html None None 70349 IY0CUrS0zHVx2hzDnWYe7w None NaN ... True False 2026-07-14 17:25:00.737457+00:00 1 1 1 2 NaN None 2
26636 FydRpUZu93QVCXVD0001 schmidt22/ifng-hits-moa-immunotherapy-map.parquet MoA classification + immunotherapy map for Sch... .parquet dataset DataFrame 24769 jCVMvFEEDG2qX4dUQZdhJg None 123.0 ... True False 2026-07-14 16:53:30.700610+00:00 1 1 1 2 10955.0 None 2
26631 qGXvU8SFFsQclgR10000 Uploads/iris-0337d20a3b7273aa0ddaa7d6afb57a37a... None .jpg None None 14529 e0Gct8LodEyQzNwy1glOPA None NaN ... True False 2026-07-14 14:51:33.166215+00:00 1 1 1 2 NaN None 46
26596 cSJxkiptE2yc8l4K0000 None Claude Code session transcript (rendered) .html None None 6263 FRcb6lLJwQb12G_NinK3Lw None NaN ... True False 2026-07-13 09:50:06.450039+00:00 1 1 1 2 NaN None 76

20 rows × 22 columns

Include fields from other registries with the __ syntax:

db.Artifact.to_dataframe(include=["created_by__handle"])
Show code cell output Hide code cell output
! truncated query result to limit=20 Artifact objects
uid key created_by__handle
id
26942 fsOwNYGqASmvzxth0000 None sunnyosun
26916 Xtd7yycLiboMIvpS0000 None testuser1
26914 99zGx7Bu1M2FE4Sw0000 None testuser1
26835 UttjBSC5KpOkLCnF0000 None ebad
26833 3n344O47mufZu0lO0000 None ebad
26816 vmDUa3zok29bG7BU0000 None ebad
26814 HkcuyVEKNYUfvnZQ0000 None ebad
26812 mZGblHNvZOd591fX0000 None ebad
26705 UnpJi7qjT0xzqMcg0000 None sunnyosun
26673 NuZqfITKaDxHtL8J0000 schmidt22/ifng-hits-cellstate-prioritized-targ... sunnyosun
26671 J3KAL83hx32Z86YC0000 None sunnyosun
26667 v5yV12AQGsqqkiVo0002 schmidt22/ifng-hits-drug-repurposing-candidate... sunnyosun
26665 v5yV12AQGsqqkiVo0001 schmidt22/ifng-hits-drug-repurposing-candidate... sunnyosun
26663 v5yV12AQGsqqkiVo0000 schmidt22/ifng-hits-drug-repurposing-candidate... sunnyosun
26662 sHqkE5Vz9M9C6C900000 schmidt22/ifng-hits-druggability-ranked.parquet sunnyosun
26640 AhvOvqOL3ABR8Ul10000 None sunnyosun
26639 t4INEklbuA6APFil0000 None sunnyosun
26636 FydRpUZu93QVCXVD0001 schmidt22/ifng-hits-moa-immunotherapy-map.parquet sunnyosun
26631 qGXvU8SFFsQclgR10000 Uploads/iris-0337d20a3b7273aa0ddaa7d6afb57a37a... sheetalgiri
26596 cSJxkiptE2yc8l4K0000 None ebad

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

db.view()
Show code cell output Hide code cell output
****************
* module: core *
****************
Artifact
uid key description suffix kind otype size hash n_files n_observations ... is_latest is_locked created_at branch_id created_on_id space_id storage_id run_id schema_id created_by_id
id
26942 fsOwNYGqASmvzxth0000 None Claude Code session transcript (rendered) .html None None 54089 9CRTGFcZZbEtDFycYMd5wg None None ... True False 2026-07-17 12:24:43.543883+00:00 1 1 1 2 NaN None 2
26916 Xtd7yycLiboMIvpS0000 None Claude Code session transcript (rendered) .html None None 5809 FP7Zoy9t8wYpymRcby9ZyA None None ... True False 2026-07-17 08:55:26.841894+00:00 1 1 1 2 NaN None 18
26914 99zGx7Bu1M2FE4Sw0000 None Human insulin protein sequence (UniProt P01308) .fasta None None 140 ldHpRp_1hWpgrMDU-5V6Uw None None ... True False 2026-07-17 08:55:13.654872+00:00 1 1 1 2 11163.0 None 18
26835 UttjBSC5KpOkLCnF0000 None Claude Code session transcript (rendered) .html None None 4971 Zwixao9rLkD1ETiPppQyzw None None ... True False 2026-07-16 14:14:00.907497+00:00 1 1 1 2 NaN None 76
26833 3n344O47mufZu0lO0000 None Human lysozyme C (P61626) sequence .fasta None None 180 aO0jQkhn0DAk_-6VEwLRYA None None ... True False 2026-07-16 14:13:46.211473+00:00 1 1 1 2 11103.0 None 76
26816 vmDUa3zok29bG7BU0000 None Claude Code session transcript (rendered) .html None None 11247 nS-ZUyqlOMkuarBVmHzoXA None None ... True False 2026-07-16 13:10:58.083436+00:00 1 1 1 2 NaN None 76
26814 HkcuyVEKNYUfvnZQ0000 None GFP protein sequence .fasta None None 288 u1GCC1M0z5hehWam9ry9Nw None None ... True False 2026-07-16 13:10:48.760491+00:00 1 1 1 2 11088.0 None 76

7 rows × 22 columns

Collection
uid key description hash reference reference_type version_tag is_latest is_locked created_at branch_id created_on_id space_id created_by_id run_id meta_artifact_id
id
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 None
52 okxPW6GIKBfRBE3B0001 scrna/collection1 None jKzNshNzE7IkXgRG17rj4A None None None True False 2026-06-03 05:10:43.531698+00:00 1 1 1 60 NaN None
51 DMF53hCJZQdnVIzT0000 View PAS OME-TIFF, Neumann et al., 2020 in Vit... None vpleElXxZiaZblQ09q9K-g None None None True False 2026-01-28 23:40:21.984321+00:00 1 1 1 18 2250.0 None
50 H1AlT19wFq7HdHqZ0000 View Habib17 (h5ad) in Vitessce None hmrSAi0jDsrxvo9Oy3Hiqg None None None True False 2026-01-20 20:28:39.313883+00:00 1 1 1 18 1934.0 None
49 p46U2L7tUlotAAkI0000 View Xenium_V1_humanLung_Cancer_FFPE_he_image ... None KuLnVec2HsgUIbl0fcTXdQ None None None True False 2026-01-14 14:32:16.517376+00:00 1 1 1 40 NaN None
46 mySQPfapuYs3ABLC0000 fasta-test-output-collection-2 None QUraKB3k9PERvsRza4ycCQ None None None True False 2025-11-30 22:35:25.029942+00:00 1 1 1 9 1591.0 None
45 OvxlsBRYX3ej4QCg0000 fasta-test-output-collection None 1gl1GT37jpyMwjiOrABqbQ None None None True False 2025-11-30 21:43:23.908782+00:00 1 1 1 9 1590.0 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
708 iBNQ2DyRdRMY workflow_status cat None The execution status of the Nextflow testing w... 0 0 None None None ... None False False 2026-07-09 14:43:34.246479+00:00 3 3 1 46 NaN NaN
701 YKDqA94Mc3pV bench-record-id str None None 0 0 None None None ... None False False 2026-06-29 10:00:37.486448+00:00 1 1 1 60 9802.0 NaN
700 C8YiQhwwrE5L donor_ethnicity list[cat[bionty.Ethnicity]] None None 0 0 None None None ... None False False 2026-06-23 14:50:03.557222+00:00 1 1 1 9 9591.0 692.0
699 pMsJ0M9NBHpV donor str None None 0 0 None None None ... None False False 2026-06-23 14:50:03.208512+00:00 1 1 1 9 9591.0 692.0
698 hIUtAWcaRazM treatment_time_h num None None 0 0 None None None ... True False False 2026-06-23 14:50:02.840284+00:00 1 1 1 9 9591.0 692.0
697 6pmJ1oYq2TiQ concentration str None None 0 0 None None None ... None False False 2026-06-23 14:50:02.118090+00:00 1 1 1 9 9591.0 692.0
696 EY2hNjOWac0v assay_oid cat[bionty.ExperimentalFactor.ontology_id] None None 0 0 None None None ... None False False 2026-06-23 14:50:01.690426+00:00 1 1 1 9 9591.0 692.0

7 rows × 21 columns

Project
uid name description abbr url start_date end_date is_locked is_type created_at branch_id created_on_id space_id created_by_id run_id type_id
id
66 JWVub2uocPnP lamindb None None None None None False True 2026-07-16 13:36:58.071259+00:00 1 1 1 2 NaN 65.0
65 69Fj6MZQG8vB Tutorials None None None None None False True 2026-07-16 13:36:47.703165+00:00 1 1 1 2 NaN NaN
64 YJCSJTbvJAH2 UseCases None None None None None False True 2026-07-16 13:36:12.691622+00:00 1 1 1 2 NaN NaN
63 q2P4a9hleXF9 Record demo None None None None None False False 2026-05-05 08:12:13.109444+00:00 1 1 1 2 NaN NaN
62 3YUXAKAZYZOz test-lag None None None None None False False 2026-04-22 18:35:24.967259+00:00 1 1 1 9 NaN NaN
61 loEcdB4vKZVd pbmc3k None None None None None False False 2026-04-17 14:09:59.773585+00:00 1 1 1 46 NaN NaN
60 mKJR9GhdfoCu pbmc3k_tutorial None None None None None False False 2026-04-17 13:07:03.040306+00:00 1 1 1 46 6317.0 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
73920 XUhUZO7bsKZ57I1u None None None None None False False 2026-07-17 13:46:27.288386+00:00 1 1 1 18 2759 None 11232
73919 dJ0oVaVpZsGl81uD None None None None None False False 2026-07-17 13:46:08.368378+00:00 1 1 1 18 611 None 11226
73918 CMkHxdQgYPxvr500 None None None None None False False 2026-07-17 13:45:47.630306+00:00 1 1 1 18 2319 None 11221
73917 3zq9Flje2pnKpioL None None None None None False False 2026-07-17 13:45:20.069356+00:00 1 1 1 18 2759 None 11220
73916 BCssSIjqfXfj5gED None None None None None False False 2026-07-17 13:45:07.087815+00:00 1 1 1 18 611 None 11219
73915 ByaQoUJXBYvm5Oyi None None None None None False False 2026-07-17 13:44:54.401966+00:00 1 1 1 18 2319 None 11218
73914 nWnwp6oxcLr7f225 None None None None None False False 2026-07-17 13:33:30.253456+00:00 1 1 1 18 2759 None 11217
Reference
uid name description abbr url pubmed_id doi text date is_locked is_type created_at branch_id created_on_id space_id created_by_id run_id type_id
id
5 WFauEWWBwslb Nextflow enables reproducible computational wo... Di Tommaso, P., Chatzou, M., Floden, E.W. et a... None https://doi.org/10.1038/nbt.3820 NaN None None None False False 2026-07-09 14:41:07.854108+00:00 3 3 1 46 NaN None
4 c0bTj3vLkGPA CRISPR activation and interference screens dec... None Schmidt22 None 35113687.0 None Regulation of cytokine production in stimulate... None False False 2025-09-28 14:05:36.774006+00:00 1 1 1 9 840.0 None
3 v19l0ASlvdLj SEA-AD: Seattle Alzheimer’s Disease Brain Cell... The Seattle Alzheimer's Disease Brain Cell Atl... None https://cellxgene.cziscience.com/collections/1... NaN 10.1038/s41593-024-01774-5 None 2022-05-31 False False 2024-11-25 11:13:49.872888+00:00 1 1 1 30 501.0 None
2 XVqpeeo4rOGh Spatially mapping T cell receptors and transcr... This repository contains data from our manuscr... None https://cellxgene.cziscience.com/collections/0... NaN 10.1016/j.immuni.2022.09.002 None 2023-09-29 False False 2024-11-25 10:31:38.620076+00:00 1 1 1 30 501.0 None
1 1XqufHiwjUaq Multiplexed single-cell transcriptional respon... None McFarland 2020 https://www.nature.com/articles/s41467-020-174... NaN 10.1038/s41467-020-17440-w Assays to study cancer cell responses to pharm... None False False 2024-12-20 13:28:18.813382+00:00 1 1 1 2 NaN None
Run
uid name description entrypoint started_at finished_at params extra_data reference reference_type ... created_at branch_id created_on_id space_id transform_id report_id environment_id plan_id created_by_id initiated_by_run_id
id
11232 UhhxbrAE3V3cmWgW None None check 2026-07-17 13:46:18.627482+00:00 2026-07-17 13:46:30.166084+00:00 {'no_run': False, 'script': 'tests/profiling/i... None None None ... 2026-07-17 13:46:18.627482+00:00 1 1 1 1413 26988.0 26979.0 None 18 NaN
11231 GAal8VWN3m3eus7K None None None 2026-07-17 13:46:15.023148+00:00 2026-07-17 13:46:15.589534+00:00 None None None None ... 2026-07-17 13:46:15.023148+00:00 1 1 1 705 NaN NaN None 18 11227.0
11230 ob9ArhxmqHmEof0t None None None 2026-07-17 13:46:12.915377+00:00 2026-07-17 13:46:13.037604+00:00 None None None None ... 2026-07-17 13:46:12.915377+00:00 1 1 1 411 NaN NaN None 18 NaN
11229 AFmxgXyXUpYBAJ5m None None None 2026-07-17 13:46:12.624782+00:00 2026-07-17 13:46:12.854496+00:00 None None None None ... 2026-07-17 13:46:12.624782+00:00 1 1 1 411 NaN NaN None 18 NaN
11228 7s0Np21aKhYMk4gV None None None 2026-07-17 13:46:12.245836+00:00 2026-07-17 13:46:12.539649+00:00 None None None None ... 2026-07-17 13:46:12.245836+00:00 1 1 1 411 NaN NaN None 18 NaN
11227 wOn6Y28zybx4g4SF None None None 2026-07-17 13:46:10.061633+00:00 2026-07-17 13:46:16.670783+00:00 None None None None ... 2026-07-17 13:46:10.061633+00:00 1 1 1 855 26987.0 26984.0 None 18 NaN
11226 O72cASBa0CXpN89H None None check 2026-07-17 13:45:59.956596+00:00 2026-07-17 13:46:11.240837+00:00 {'no_run': False, 'script': 'tests/profiling/i... None None None ... 2026-07-17 13:45:59.956596+00:00 1 1 1 1413 26986.0 26979.0 None 18 NaN

7 rows × 22 columns

Schema
uid name description n_members coerce flexible itype otype hash minimal_set ... maximal_set is_locked is_type created_at branch_id created_on_id space_id created_by_id run_id type_id
id
227 2fNxDBqwRBerwLaX nextflow_testing_metadata None 1 None False Feature None ofbW8htIOfXswgaWACJnsg True ... False False False 2026-07-09 14:44:11.589444+00:00 3 3 1 46 NaN NaN
226 99I0W7xRRYOGX0jR ATAC-seq experiment None 2 None False Feature None None True ... False False False 2026-07-09 12:45:47.715575+00:00 1 1 1 2 NaN NaN
225 JheDwMyQkrGILG4I bench-schema-with-index None 5 None False Feature None sYqCRMyiEUgH8C4nbGBjMQ True ... False False False 2026-06-29 10:00:38.003432+00:00 1 1 1 60 9802.0 NaN
224 Nx6l4qn3T6PHC7Vq test-import-records-from-dataframe-2026-06-24-... None 4 None False Feature DataFrame 0I9w16NyUBwm4Sx9i3bMyg True ... False False False 2026-06-24 05:51:27.542800+00:00 1 1 1 60 9601.0 190.0
223 pnQvQVcQ417bfmVq mini_immuno None 6 None False Feature None -a0FXaUEghfpsnLueikQvw True ... False False False 2026-06-23 14:50:04.736211+00:00 1 1 1 9 9591.0 NaN
222 VLx7wOA3lSlSMRBt lag_eval None 8 None False Feature None T3rHednY_vrLcTRikG6k_g True ... False False False 2026-06-20 14:27:03.645838+00:00 1 1 1 9 NaN NaN
221 QlP3YCAkqOaJ1vHa laminprofiler None 4 None False Feature None TpspAHrwVUzpbaQrz8x0Kg True ... False False False 2026-06-20 08:51:14.557178+00:00 1 1 1 9 NaN NaN

7 rows × 21 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
60 oiIXpnEdjflJ https://static-content.springer.com None https None None False 2026-07-09 13:38:48.347870+00:00 1 1 1 18 NaN
59 xz61M0QVM1uI s3://openproblems-data None s3 us-west-2 None False 2026-05-21 08:57:21.367940+00:00 1 1 1 54 NaN
54 yL17nYM0lRZf s3://lamin-us-west-2/yL17nYM0lRZf None s3 us-west-2 1AjDxIR2ZphW False 2025-04-25 08:32:54.953891+00:00 1 1 1 46 6661.0
47 Ksc9WSIuWoB7 https://github.com None https None None False 2026-03-27 13:16:09.525146+00:00 1 1 1 28 NaN
46 BeCKJUiH0kAe s3://1000genomes None s3 us-east-1 None False 2026-02-12 11:28:05.200543+00:00 1 1 1 28 NaN
45 h7mtmId9XIpY s3://openproblems-nextflow None s3 us-west-2 None False 2026-02-11 11:47:51.304040+00:00 1 1 1 28 NaN
44 od6M1Qu9kVjj https://httpbin.org None https None None False 2026-01-30 14:22:00.979551+00:00 1 1 1 18 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
1571 5u2Y0v8oZgJy000F test_02/curate_artifact.py None script import lamindb as ln\n\n# Define constants\nSO... PPZCUJxA_DqzyQpqfidZfQ None None None True False 2026-07-17 08:56:02.792342+00:00 1 1 1 None None 11164.0 18
1570 YbojWJGRcQaj0000 claudecode/save_protein.py None script import lamindb as ln\n\nln.track()\n\n# My fav... DwZXGO89wOGnW6w5b1yyzQ None None None True False 2026-07-17 08:55:12.522061+00:00 1 1 1 None None 11162.0 18
1569 cbYWEp1492lv0000 laminagent/save_protein.py None script import lamindb as ln\nln.track()\n\n# 1. Write... aHkeC1NYwCo2vAoaG0l87A None None None True False 2026-07-17 08:54:24.610317+00:00 1 1 1 None None 11160.0 18
1568 duXJBp1G4gE80000 write_protein_fasta.py None script import lamindb as ln\n\nln.track()\n\n# Human ... VLR3goLh39FHEt-ukf0ckA None None None True False 2026-07-16 14:13:40.019415+00:00 1 1 1 None None 11102.0 76
1567 wJoUb1hzekss0000 save_protein.py None script import lamindb as ln\n\nln.track()\n\n# Green ... voEKgzW_D3cNoOuiV1cRLA None None None True False 2026-07-16 13:10:43.068673+00:00 1 1 1 None None 11087.0 76
1566 7tVVuExlIJaN0002 schmidt22/prioritize_targets.py None script """Cell-state-aware immunotherapy target prior... cLWSANLQw-FUNb0_nNy7hA None None None True False 2026-07-15 10:23:42.272724+00:00 1 1 1 None None 11001.0 2
1565 7tVVuExlIJaN0001 schmidt22/prioritize_targets.py None script """Cell-state-aware immunotherapy target prior... n_XTWGKAXcQSBdCa6dYV3Q None None None False False 2026-07-15 10:22:43.506901+00:00 1 1 1 None None NaN 2
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
432 Wsg6AaGs github_hosted None None None False False 2026-06-19 09:27:43.755013+00:00 1 1 1 9 NaN 431.0
431 ljbGg49g RunnerEnvs None None None False True 2026-06-19 09:25:56.560324+00:00 1 1 1 9 NaN NaN
430 2SOng39r ILLUMINA None None None False False 2026-05-05 12:33:17.438691+00:00 1 1 1 2 NaN 429.0
429 YZ3aglov SeqPlatform Sequencing platforms. None None False True 2026-05-05 12:31:40.349492+00:00 1 1 1 2 NaN NaN
428 wqoBJRkY IFNG None None None False False 2026-05-05 09:20:52.382521+00:00 1 1 1 9 7350.0 NaN
! skipping module 'pertdb': 'pertdb' wasn't configured in this environment -- run: lamin settings modules set pertdb
If your database instance also doesn't have it, go to your instance settings page and add it under 'schema modules' (or ask an admin to do so).
******************
* module: bionty *
******************
CellLine
uid name ontology_id abbr synonyms description is_locked created_at branch_id created_on_id space_id created_by_id run_id source_id
id
250 2rD83IhFD8zXmX immortal uterine cervix-derived epithelial cel... CLO:0000283 None None An immortal epithelial cell line cell that der... False 2026-04-28 11:23:46.687389+00:00 1 1 1 46 7001.0 9
249 3mYHwNTcJYDLrt immortal epithelial cell line cell CLO:0000129 None None a immortal animal cell line that is derived fr... False 2026-04-28 11:23:46.687389+00:00 1 1 1 46 7001.0 9
248 45i0CvX67rIhVi immortal human uterine cervix-derived epitheli... CLO:0000636 None None An immortal uterine cervix-derived epithelial ... False 2026-04-28 11:23:45.353143+00:00 1 1 1 46 7001.0 9
247 4CdAW8HhaBZ3B5 HeLa cell CLO:0003684 None HeLa an immortal human uterine cervix-derived epith... False 2026-04-28 11:23:44.294879+00:00 1 1 1 46 7001.0 9
246 1n5kUkyJP7ekyJ immortal human blood cell line cell CLO:0000617 None None An immortal blood cell line cell that derives ... False 2025-01-08 13:33:33.047544+00:00 1 1 1 2 NaN 9
245 5TRtcD7edroFSw immortal blood cell line cell CLO:0000149 None immortal blood cell line a immortal hematopoietic cell line that is der... False 2025-01-08 13:33:33.047500+00:00 1 1 1 2 NaN 9
244 4HVCf9WcSdLlwt RCB0806 cell CLO:0050978 None RCB0806|Jurkat A immortal human blood cell line cell that has... False 2025-01-08 13:33:32.819503+00:00 1 1 1 2 NaN 9
CellMarker
uid abbr synonyms description name gene_symbol ncbi_gene_id uniprotkb_id is_locked created_at branch_id created_on_id space_id created_by_id run_id source_id organism_id
id
83 3ZFziy5ims8JUV None None None CD14/19 None None None False 2023-10-04 16:08:58.846323+00:00 1 1 1 2 None NaN 2
82 1iLDs6cZIpxjB6 None None CD69 CD69 969 Q07108 False 2023-10-04 16:08:40.134192+00:00 1 1 1 2 None 7.0 2
81 31nZfqQo8yZgeb None None CD103 ITGAE 3682 P38570 False 2023-10-04 16:08:40.134170+00:00 1 1 1 2 None 7.0 2
80 5c4A0r7gMiGwGk None None CD95 FAS 2194 P49327 False 2023-10-04 16:08:40.134151+00:00 1 1 1 2 None 7.0 2
79 3IPMBjs68Vy1oM None None CXCR4 CXCR4 7852 P61073 False 2023-10-04 16:08:40.134128+00:00 1 1 1 2 None 7.0 2
78 525YfNUB967zee None None CD49B ITGA2 3673 P17301 False 2023-10-04 16:08:40.134091+00:00 1 1 1 2 None 7.0 2
77 3l9bWDSZiukI6O None LIVE/DEAD None Dead None None None False 2023-07-26 13:25:18.219619+00:00 1 1 1 2 None NaN 2
CellType
uid name ontology_id abbr synonyms description is_locked created_at branch_id created_on_id space_id created_by_id run_id source_id
id
221 4zrSyDb4opmGJz neoplastic epithelial cell None None None None False 2026-04-14 08:59:53.779824+00:00 1 1 1 9 6113.0 NaN
220 23ekfCDhJCSN44 cancer associated fibroblast None None None None False 2026-04-14 08:59:53.779824+00:00 1 1 1 9 6113.0 NaN
219 3hXuCKYHIHOjiS perivascular cell CL:4033054 None None A Cell That Is Adjacent To A Vessel. A Perivas... False 2026-04-14 08:59:20.955797+00:00 1 1 1 9 6113.0 64.0
218 7KCFubjGu7ok8G iPSC-induced neuron None None None None False 2025-01-08 11:36:53.756884+00:00 1 1 1 2 NaN NaN
217 2nWjcXRrdqX5g0 lymphoblast CL:0017005 None None A Lymphocyte That Has Gotten Larger After Bein... False 2025-01-07 09:41:49.139648+00:00 1 1 1 2 NaN 65.0
216 4qnxelJpe0dakV retinal cell CL:0009004 None None Any Cell In The Retina, The Innermost Layer Or... False 2025-01-06 12:00:39.805850+00:00 1 1 1 2 NaN 65.0
215 1e5QBUmKJGM4e9 visual pigment cell CL:0000149 None None None False 2025-01-06 12:00:39.805825+00:00 1 1 1 2 NaN 65.0
DevelopmentalStage
uid name ontology_id abbr synonyms description is_locked created_at branch_id created_on_id space_id created_by_id run_id source_id
id
44 5HWRj1ODkb6V1S unknown unknown None None None False 2024-12-05 16:37:36.726755+00:00 1 1 1 3 385 NaN
43 7k1A0zkTfOLQo4 human life cycle stage HsapDv:0000000 None developmental stage A Spatiotemporal Region Encompassing Some Part... False 2024-12-05 16:37:35.999196+00:00 1 1 1 3 384 49.0
42 5q73MbS33MJVGx 85-year-old human stage HsapDv:0000211 None None Aged Stage That Refers To An Adult Who Is Over... False 2024-12-05 16:37:35.196938+00:00 1 1 1 3 384 49.0
41 5QzRYqqcaGITDU 84-year-old human stage HsapDv:0000210 None None Aged Stage That Refers To An Adult Who Is Over... False 2024-12-05 16:37:35.196920+00:00 1 1 1 3 384 49.0
40 3MeD86peox5beX 82-year-old human stage HsapDv:0000208 None None Aged Stage That Refers To An Adult Who Is Over... False 2024-12-05 16:37:35.196903+00:00 1 1 1 3 384 49.0
39 1FAjljBZPandRY 81-year-old human stage HsapDv:0000207 None None Aged Stage That Refers To An Adult Who Is Over... False 2024-12-05 16:37:35.196887+00:00 1 1 1 3 384 49.0
38 2nEVCZzoSi6YS2 80-year-old human stage HsapDv:0000206 None None Aged Stage That Refers To An Adult Who Is Over... False 2024-12-05 16:37:35.196869+00:00 1 1 1 3 384 49.0
Disease
uid name ontology_id abbr synonyms description is_locked created_at branch_id created_on_id space_id created_by_id run_id source_id
id
182 3lEY9l5KHXHvI6 precancerous condition MONDO:0021074 None precancerous condition|premalignant condition|... A Pathological Process With Signs Indicating I... False 2026-04-13 15:09:54.889610+00:00 1 1 1 9 6070 73
181 3UbujjzPMgLW9n breast ductal adenocarcinoma MONDO:0005590 None ductal carcinoma of breast|mammary duct adenoc... A Breast Carcinoma Arising From The Ducts. Whi... False 2026-04-13 15:09:54.889610+00:00 1 1 1 9 6070 73
180 1yX8SwADeAa956 breast carcinoma MONDO:0004989 None mammary carcinoma|carcinoma of the breast|brea... A Carcinoma That Arises From Epithelial Cells ... False 2026-04-13 15:09:54.889610+00:00 1 1 1 9 6070 73
179 5BMsSAHuNlNkVR breast adenocarcinoma MONDO:0004988 None adenocarcinoma of breast|adenocarcinoma of the... A Carcinoma That Arises From Glandular Epithel... False 2026-04-13 15:09:54.889610+00:00 1 1 1 9 6070 73
178 1vrnOyXFQ3Nd9W breast carcinoma in situ MONDO:0004658 None stage 0 carcinoma of breast|non-infiltrating b... A In Situ Carcinoma That Involves The Breast. False 2026-04-13 15:09:54.889610+00:00 1 1 1 9 6070 73
177 5y3Uc4S81tPlsw in situ carcinoma MONDO:0004647 None stage 0 disease|non-invasive carcinoma|epithel... A Malignant Epithelial Neoplasm Which Is Confi... False 2026-04-13 15:09:54.889610+00:00 1 1 1 9 6070 73
176 1jD296YK6NLFVu breast intraductal proliferative lesion MONDO:0004007 None ductal intraepithelial neoplasia|mammary intra... A Group Of Non-Invasive Epithelial Proliferati... False 2026-04-13 15:09:54.889610+00:00 1 1 1 9 6070 73
Ethnicity
uid name ontology_id abbr synonyms description is_locked created_at branch_id created_on_id space_id created_by_id run_id source_id
id
7 3FN797FUPWonJO British in England and Scotland (1KGP) HANCESTRO:0765 GBR None A population made up of 107 samples from Briti... False 2025-04-30 14:28:53.884654+00:00 1 1 1 2 638 NaN
6 3AZVW16yI1BsV5 African American or Afro-Caribbean HANCESTRO:0016 None None Includes Individuals Who Either Self-Report Or... False 2024-12-05 16:37:41.019432+00:00 1 1 1 3 384 51.0
5 67yD7yy4XCWOLA African American HANCESTRO:0568 None None None False 2024-12-05 16:37:40.220495+00:00 1 1 1 3 384 51.0
4 2dwBSQ1z0XEYfL Asian HANCESTRO:0008 None Asian unspecified Includes Individuals That Either Self-Report O... False 2024-12-05 16:37:40.220454+00:00 1 1 1 3 384 51.0
3 5HWRj1ODkb6V1S unknown unknown None None None False 2024-12-02 08:58:00.689681+00:00 1 1 1 30 361 NaN
2 6Tnv21SwDbUrL5 ancestry category HANCESTRO:0004 None ancestral group Population Category Defined Using Ancestry Inf... False 2024-06-05 12:09:31.274046+00:00 1 1 1 2 181 51.0
1 15mGvAtWs1laJX European HANCESTRO:0005 EUR Caucasian|white Includes Individuals Who Either Self-Report Or... False 2024-06-05 12:09:29.374920+00:00 1 1 1 2 181 51.0
ExperimentalFactor
uid name ontology_id abbr synonyms description is_locked created_at branch_id created_on_id space_id created_by_id run_id source_id
id
59 3C8KLOGpZkHsC5 RNA-Seq EFO:0008896 None None Rna-Seq Is A Method That Involves Purifying Rn... False 2026-06-03 04:50:44.387535+00:00 1 1 1 60 None 104.0
58 3VAgTSkxVwvsyT Xenium Spatial Gene Expression None None Xenium|10X Xenium None False 2025-12-09 12:46:38.150561+00:00 1 1 1 40 None NaN
57 2UEkfRqukGb1oI TraCe-seq None None None None False 2025-01-08 12:43:38.479402+00:00 1 1 1 2 None NaN
56 2vzIZ5LkSh7rpi sci-RNA-seq EFO:0010550 None None The Sci-Rna-Seq Uses The Combinatorial Indexin... False 2025-01-08 08:58:19.611931+00:00 1 1 1 2 None 87.0
55 5jxLO4bDAyRVOV sci-Plex EFO:0030026 None None The Combination Of Nuclear Hashing And Sci-Rna... False 2025-01-08 08:58:19.142252+00:00 1 1 1 2 None 87.0
54 2ngGOY7rDGX2IE sequencer EFO:0003739 None None None False 2024-12-02 18:53:05.337572+00:00 1 1 1 2 None 83.0
53 1ImT882pIwABzY instrument EFO:0000548 None HardwareType|hardware An Instrument Is A Device Which Provides A Mec... False 2024-12-02 18:53:05.337209+00:00 1 1 1 2 None 83.0
Gene
uid abbr synonyms description symbol stable_id ensembl_gene_id ncbi_gene_ids biotype is_locked created_at branch_id created_on_id space_id created_by_id run_id source_id organism_id
id
154347 43PKjUN2TuRjeK None TMEM142A|CRACM1|FLJ14466 ORAI calcium release-activated calcium modulat... ORAI1 None ENSG00000293604 None protein_coding False 2025-10-26 14:38:48.560365+00:00 1 1 1 9 1260 55 2
154346 7hbNrFh6GVRtVn None novel protein None None ENSG00000293600 None protein_coding False 2025-10-26 14:38:48.560365+00:00 1 1 1 9 1260 55 2
154345 2DLKDsGV0zX96L None novel transcript None None ENSG00000293599 None lncRNA False 2025-10-26 14:38:48.560365+00:00 1 1 1 9 1260 55 2
154344 12nPu7ce9hLZ4k None long intergenic non-protein coding RNA 970 LINC00970 None ENSG00000293597 None lncRNA False 2025-10-26 14:38:48.560365+00:00 1 1 1 9 1260 55 2
154343 42lwxhgTHxaNKI None novel transcript None None ENSG00000293596 None lncRNA False 2025-10-26 14:38:48.560365+00:00 1 1 1 9 1260 55 2
154342 1cNzYeNWyn5iyY None FLJ40434 solute carrier family 25 member 3 pseudogene 1 SLC25A3P1 None ENSG00000293595 None lncRNA False 2025-10-26 14:38:48.560365+00:00 1 1 1 9 1260 55 2
154341 6uPvR6SwrQ0xlj None ribosomal protein L41 (RPL41) pseudogene None None ENSG00000293594 None processed_pseudogene False 2025-10-26 14:38:48.560365+00:00 1 1 1 9 1260 55 2
Organism
uid name ontology_id abbr synonyms description scientific_name is_locked created_at branch_id created_on_id space_id created_by_id run_id source_id
id
4 51ZZUW24OnSz92 rabbit None None None None None False 2026-04-29 10:06:58.762578+00:00 1 1 1 46 None NaN
3 1AnuV4MqEApbJE saccharomyces cerevisiae NCBITaxon:559292 None None None Saccharomyces cerevisiae False 2025-03-21 10:59:03.683876+00:00 1 1 1 6 None 53.0
2 1dpCL6TduFJ3AP human NCBITaxon:9606 None None None Homo sapiens False 2023-07-14 10:41:59.433226+00:00 1 1 1 6 None 1.0
1 3RZqbcSLWNGQGZ mouse NCBITaxon:10090 None None None Mus musculus False 2023-07-26 13:01:56.447025+00:00 1 1 1 2 None 1.0
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 None None None None False 2024-12-20 13:27:12.909577+00:00 1 1 1 2 405 NaN
2 3OV8JZsSny1UQm female PATO:0000383 None None A Biological Sex Quality Inhering In An Indivi... False 2024-06-05 12:09:14.248434+00:00 1 1 1 2 181 48.0
1 kniZxLLf63zsQC male PATO:0000384 None None A Biological Sex Quality Inhering In An Indivi... False 2024-06-05 12:09:13.824774+00:00 1 1 1 2 181 48.0
Protein
uid abbr synonyms description name uniprotkb_id length gene_symbol ensembl_gene_ids is_locked created_at branch_id created_on_id space_id created_by_id run_id source_id organism_id
id
239 231ffq2p4OKIZB None None None VEGF None None None None False 2024-12-13 23:13:13.448561+00:00 1 1 1 9 392 None 2
238 DdtaoUouGdlIFF None None None TSLP None None None None False 2024-12-13 23:13:13.448541+00:00 1 1 1 9 392 None 2
237 2eU4TKDBtwKeND None None None TRAIL None None None None False 2024-12-13 23:13:13.448521+00:00 1 1 1 9 392 None 2
236 5VKVwilvkbLjJ1 None None None TL1A None None None None False 2024-12-13 23:13:13.448499+00:00 1 1 1 9 392 None 2
235 56Q2NU5LlFbQox None None None TGF-beta1 None None None None False 2024-12-13 23:13:13.448478+00:00 1 1 1 9 392 None 2
234 5yxiGKssUC6HCQ None None None PSPN None None None None False 2024-12-13 23:13:13.448458+00:00 1 1 1 9 392 None 2
233 3WgMz3uEzIODQW None None None PBS None None None None False 2024-12-13 23:13:13.448437+00:00 1 1 1 9 392 None 2
Source
uid entity organism name version in_db currently_used description url md5 source_website is_locked created_at branch_id created_on_id space_id created_by_id run_id dataframe_artifact_id
id
105 64RRxCHm bionty.Gene mouse ensembl release-102 False False Ensembl None None None False 2025-04-23 16:17:01.389481+00:00 1 1 1 2 None 1515.0
104 2a1HvjdB bionty.ExperimentalFactor all efo 3.70.0 False True The Experimental Factor Ontology http://www.ebi.ac.uk/efo/releases/v3.70.0/efo.owl https://bioportal.bioontology.org/ontologies/EFO False 2024-12-30 09:11:45.927266+00:00 1 1 1 2 None NaN
103 YXoI7R9t wetlab.Compound all chebi 2024-07-27 True True Chemical Entities of Biological Interest s3://bionty-assets/df_all__chebi__2024-07-27__... None https://www.ebi.ac.uk/chebi/ False 2024-12-20 13:05:00.664713+00:00 1 1 1 2 None 1144.0
102 10va5JSt bionty.DevelopmentalStage mouse mmusdv 2024-05-28 False True Mouse Developmental Stages https://github.com/obophenotype/developmental-... https://github.com/obophenotype/developmental-... False 2024-09-25 11:44:53.469647+00:00 1 1 1 6 None NaN
101 1GbFkOdz bionty.DevelopmentalStage human hsapdv 2024-05-28 False True Human Developmental Stages https://github.com/obophenotype/developmental-... https://github.com/obophenotype/developmental-... False 2024-09-25 11:44:52.894826+00:00 1 1 1 6 None NaN
100 1atB0WnU Drug all chebi 2024-07-27 False False Chemical Entities of Biological Interest s3://bionty-assets/df_all__chebi__2024-07-27__... https://www.ebi.ac.uk/chebi/ False 2024-09-25 11:44:52.685270+00:00 1 1 1 6 None NaN
99 5alKEOMB Drug all dron 2024-03-02 False False Drug Ontology https://data.bioontology.org/ontologies/DRON/s... 84138459de4f65034e979f4e46783747 https://bioportal.bioontology.org/ontologies/DRON False 2024-09-25 11:44:52.151655+00:00 1 1 1 6 None NaN
Tissue
uid name ontology_id abbr synonyms description is_locked created_at branch_id created_on_id space_id created_by_id run_id source_id
id
127 4QeoxdKp9KxQM8 body proper UBERON:0013702 None None The Region Of The Organism Associated With The... False 2025-03-20 22:20:26.347506+00:00 1 1 1 35 536 68
126 3XuRxEhwtpvdlX main body axis UBERON:0013701 None None A Principle Subdivision Of An Organism That In... False 2025-03-20 22:20:26.347506+00:00 1 1 1 35 536 68
125 7ZCdHnvNOjjv2F subdivision of organism along main body axis UBERON:0011676 None axial subdivision of organism A Major Subdivision Of An Organism That Divide... False 2025-03-20 22:20:26.347506+00:00 1 1 1 35 536 68
124 31GPuSXPc7Z4Tz subdivision of trunk UBERON:0009569 None trunk subdivision|region of trunk None False 2025-03-20 22:20:26.347506+00:00 1 1 1 35 536 68
123 7MjYxh4jwppeOe trunk UBERON:0002100 None thoracolumbar region|trunk region|torso Organism Subdivision Which Is The Part Of The ... False 2025-03-20 22:20:26.347506+00:00 1 1 1 35 536 68
122 1boGOeV9Xx1pmN multicellular organism UBERON:0000468 None multi-cellular organism Anatomical Structure That Is An Individual Mem... False 2025-03-20 22:20:26.347506+00:00 1 1 1 35 536 68
121 51UEcfPxUr9DU7 chest UBERON:0001443 None pectus|ventral part of thoracic region|front o... Subdivision Of Trunk Proper, Which Is Demarcat... False 2025-03-20 22:20:24.962147+00:00 1 1 1 35 536 68

Get one object¶

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

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

Search¶

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

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

8 rows × 22 columns

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

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

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

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

cell_types = db.bionty.CellType.lookup()

Queries¶

By fields¶

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

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

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

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

1 rows × 22 columns

To access the results in a queryset:

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

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

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

You can also:

  • use the QuerySet as an iterator

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

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

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

db.Artifact.filter(created_by__handle__startswith="testuse").to_dataframe()
Show code cell output Hide code cell output
! truncated query result to limit=20 Artifact objects
uid key description suffix kind otype size hash n_files n_observations ... is_latest is_locked created_at branch_id created_on_id space_id storage_id run_id schema_id created_by_id
id
26916 Xtd7yycLiboMIvpS0000 None Claude Code session transcript (rendered) .html None None 5809 FP7Zoy9t8wYpymRcby9ZyA None None ... True False 2026-07-17 08:55:26.841894+00:00 1 1 1 2 NaN None 18
26914 99zGx7Bu1M2FE4Sw0000 None Human insulin protein sequence (UniProt P01308) .fasta None None 140 ldHpRp_1hWpgrMDU-5V6Uw None None ... True False 2026-07-17 08:55:13.654872+00:00 1 1 1 2 11163.0 None 18
26078 0u7ej5c3V5sMIuBf0000 None DESeq2 heatmap top 50 DEGs .png None None 284615 7-ZZoqX6c-_5nx382W2nTA None None ... True False 2026-07-09 13:39:26.108685+00:00 1 1 1 2 NaN None 18
26077 9v5zUHvvG2jBfCoX0000 None DESeq2 volcano plot .png None None 179601 uctq5dMMdtdHuBTrVUM40Q None None ... True False 2026-07-09 13:39:26.002063+00:00 1 1 1 2 NaN None 18
26076 MOmOWJUk1mKs8d4x0000 None DESeq2 cleaned DEG table .csv None DataFrame 1100037 BpXbkk-wdAfWk4C1qYnWNA None None ... True False 2026-07-09 13:39:23.492933+00:00 1 1 1 2 NaN None 18
26075 LmM4I1lM3GZQRW4L0000 esm/art%3A10.1038%2Fs41467-022-28120-2/MediaOb... Supplementary MOESM7 — pre-computed DESeq2 bul... .xlsx None None 22274609 AvbNebMwmKOyKvB5Ny_rRQ None None ... True False 2026-07-09 13:38:48.400046+00:00 1 1 1 60 NaN None 18
26072 oU3vZSq9XK7X6ZYk0000 None Claude Code session transcript (rendered) .html None None 4495 Ups0xiIFHRDUK_0tEwXyRg None None ... True False 2026-07-09 13:36:01.939042+00:00 1 1 1 2 NaN None 18
26070 HUdcJYeZdWrsUHhX0000 None Human insulin (INS) protein sequence in FASTA ... .fasta None None 151 DO5BK9oAprLBjPEV3cwgUg None None ... True False 2026-07-09 13:35:31.412676+00:00 1 1 1 2 10515.0 None 18
26068 tDyrsAl7AuQYe4jq0000 None My favorite protein sequence (GFP) .fasta None None 273 E2VFTe7hTogZyl4-m4g87w None None ... True False 2026-07-09 13:34:55.812724+00:00 1 1 1 2 10513.0 None 18
26063 CfnqW1SVa3JJbf5L0000 None Claude Code session transcript (rendered) .html None None 4927 _pBMQN-VAINiQsAGRYxDCg None None ... True False 2026-07-09 11:15:51.294632+00:00 1 1 1 2 NaN None 18
26061 kpIrOnjsOW52Edqb0000 None Favorite protein sequence: human insulin (UniP... .fasta None None 155 s1f_cp9GEb9DbrIk4GuzmQ None None ... True False 2026-07-09 11:15:22.267477+00:00 1 1 1 2 10509.0 None 18
26059 uFN6z2zzrdVvJgbS0000 None My favorite protein sequence (Ubiquitin) .fasta None None 149 7-hEZc3LCYj0hlonUTWiIA None None ... True False 2026-07-09 11:14:42.281007+00:00 1 1 1 2 10507.0 None 18
25696 Q2gXw8D0zkP86n7C0000 None My favorite protein sequence (GFP) .fasta None None 273 42yLTIs-Wu-Sq_gzdXJgZg None None ... True False 2026-07-05 18:22:17.260597+00:00 1 1 1 2 10211.0 None 18
25690 GYSbsO58JPcaoof10000 None My favorite protein sequence .fasta None None 125 Po3ZId69jXz_sI2D-xz5fQ None None ... True False 2026-07-05 17:31:09.792690+00:00 1 1 1 2 10207.0 None 18
25683 jUVonDJ2uOA4ef2u0000 None My favorite protein sequence (Human Myoglobin) .fasta None None 228 Iloz1-UhH-DpUa5lh03SOg None None ... True False 2026-07-05 17:23:56.994656+00:00 1 1 1 2 10202.0 None 18
25677 Pedin9Spf0t0rx2U0000 None My favorite protein sequence (Human Insulin) .fasta None None 181 np2gy6EuZjSLurfRIXk28A None None ... True False 2026-07-05 17:10:27.539197+00:00 1 1 1 2 10198.0 None 18
25654 jN5lGSn4g77TSsSk0000 None My favorite protein sequence (GFP) .fasta None None 270 DfAvtmcmQnijTFWOxLV6OQ None None ... True False 2026-07-05 14:57:02.553598+00:00 1 1 1 2 10182.0 None 18
24890 BFfIHO5w8WPUywgR0000 None My favorite protein sequence (Ubiquitin) .fasta None None 156 xkHNV8nXb_IkgII2o7rqkw None None ... True False 2026-06-23 12:25:09.382779+00:00 1 1 1 2 9568.0 None 18
24829 sQoSgM6pa1hul8410000 None Favorite protein sequence (GFP) .fasta None None 273 pA7qrMMCi-mGD6bbVWjbFA None None ... True False 2026-06-22 20:27:39.519487+00:00 1 1 1 2 9523.0 None 18
24815 5yJpRQHDCWH7qBWF0000 None favorite protein .fasta None None 244 t2fV6Xyijp9KA4dZAi7F-w None None ... True False 2026-06-22 20:02:45.048795+00:00 1 1 1 2 9514.0 None 18

20 rows × 22 columns

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

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

20 rows × 22 columns

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

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

20 rows × 22 columns

By features¶

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

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

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

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

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

Cheat sheet: comparators¶

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

and¶

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

0 rows × 23 columns

less than/ greater than¶

# artifacts greater than 10kB
db.Artifact.filter(size__gt=1e4).to_dataframe()
Show code cell output Hide code cell output
! truncated query result to limit=20 Artifact objects
uid key description suffix kind otype size hash n_files n_observations ... is_latest is_locked created_at branch_id created_on_id space_id storage_id run_id schema_id created_by_id
id
26942 fsOwNYGqASmvzxth0000 None Claude Code session transcript (rendered) .html None None 54089 9CRTGFcZZbEtDFycYMd5wg NaN NaN ... True False 2026-07-17 12:24:43.543883+00:00 1 1 1 2 NaN None 2
26816 vmDUa3zok29bG7BU0000 None Claude Code session transcript (rendered) .html None None 11247 nS-ZUyqlOMkuarBVmHzoXA NaN NaN ... True False 2026-07-16 13:10:58.083436+00:00 1 1 1 2 NaN None 76
26705 UnpJi7qjT0xzqMcg0000 None Claude Code session transcript (rendered) .html None None 75628 qVb_8ZKg2pfAsTZqud7qjQ NaN NaN ... True False 2026-07-15 14:11:04.281778+00:00 1 1 1 2 NaN None 2
26673 NuZqfITKaDxHtL8J0000 schmidt22/ifng-hits-cellstate-prioritized-targ... IFNG CRISPRa hits prioritized by screen streng... .parquet None DataFrame 15891 48DFEvVrjQ2m42IHT_t_fg NaN NaN ... True False 2026-07-15 10:22:51.241153+00:00 1 1 1 2 10980.0 None 2
26671 J3KAL83hx32Z86YC0000 None Claude Code session transcript (rendered) .html None None 118754 4Jqh500CRi5OwHIVqKXO2Q NaN NaN ... True False 2026-07-15 09:55:07.318686+00:00 1 1 1 2 NaN None 2
26667 v5yV12AQGsqqkiVo0002 schmidt22/ifng-hits-drug-repurposing-candidate... Step 2: approved/clinical compounds per MoA cl... .parquet None DataFrame 15309 hCfK7MBp8zinZiVaVt43eA NaN NaN ... True False 2026-07-15 09:50:50.509878+00:00 1 1 1 2 10976.0 None 2
26665 v5yV12AQGsqqkiVo0001 schmidt22/ifng-hits-drug-repurposing-candidate... Step 2: approved/clinical compounds per MoA cl... .parquet None DataFrame 15287 G9R5S-pvaKxe01Q33vrOog NaN NaN ... False False 2026-07-15 09:48:55.993853+00:00 1 1 1 2 10975.0 None 2
26663 v5yV12AQGsqqkiVo0000 schmidt22/ifng-hits-drug-repurposing-candidate... Step 2: approved/clinical compounds per MoA cl... .parquet None DataFrame 14608 UVc5k5VlV5-SC_2wwe4IjA NaN NaN ... False False 2026-07-15 09:32:54.545077+00:00 1 1 1 2 10974.0 None 2
26662 sHqkE5Vz9M9C6C900000 schmidt22/ifng-hits-druggability-ranked.parquet Step 2: selected IFN-g CRISPRa hits with Open ... .parquet None DataFrame 17018 UxAg8wSR-BHTuQRtudsBzA NaN NaN ... True False 2026-07-15 09:32:53.226608+00:00 1 1 1 2 10976.0 None 2
26640 AhvOvqOL3ABR8Ul10000 None Claude Code session transcript (rendered) .html None None 76422 iDqXSRg81e37hKlMJkuLgA NaN NaN ... True False 2026-07-14 17:27:38.790315+00:00 1 1 1 2 NaN None 2
26639 t4INEklbuA6APFil0000 None Claude Code session transcript (rendered) .html None None 70349 IY0CUrS0zHVx2hzDnWYe7w NaN NaN ... True False 2026-07-14 17:25:00.737457+00:00 1 1 1 2 NaN None 2
26636 FydRpUZu93QVCXVD0001 schmidt22/ifng-hits-moa-immunotherapy-map.parquet MoA classification + immunotherapy map for Sch... .parquet dataset DataFrame 24769 jCVMvFEEDG2qX4dUQZdhJg NaN 123.0 ... True False 2026-07-14 16:53:30.700610+00:00 1 1 1 2 10955.0 None 2
26631 qGXvU8SFFsQclgR10000 Uploads/iris-0337d20a3b7273aa0ddaa7d6afb57a37a... None .jpg None None 14529 e0Gct8LodEyQzNwy1glOPA NaN NaN ... True False 2026-07-14 14:51:33.166215+00:00 1 1 1 2 NaN None 46
26334 UbP7rv1tRppT9pmf0000 None Claude Code session transcript (rendered) .html None None 75657 reF24MbDbY-FQb7WQz6sMA NaN NaN ... True False 2026-07-11 14:07:44.557199+00:00 1 1 1 2 NaN None 9
26332 eTL4ijrYfluVYtBa0000 None Timeline of all perturbations in the Perturbat... .png None None 51043 1acFIj0CtQ5ffp6MOHyYwQ NaN NaN ... True False 2026-07-11 13:58:13.246460+00:00 1 1 1 2 10719.0 None 9
26078 0u7ej5c3V5sMIuBf0000 None DESeq2 heatmap top 50 DEGs .png None None 284615 7-ZZoqX6c-_5nx382W2nTA NaN NaN ... True False 2026-07-09 13:39:26.108685+00:00 1 1 1 2 NaN None 18
26077 9v5zUHvvG2jBfCoX0000 None DESeq2 volcano plot .png None None 179601 uctq5dMMdtdHuBTrVUM40Q NaN NaN ... True False 2026-07-09 13:39:26.002063+00:00 1 1 1 2 NaN None 18
26076 MOmOWJUk1mKs8d4x0000 None DESeq2 cleaned DEG table .csv None DataFrame 1100037 BpXbkk-wdAfWk4C1qYnWNA NaN NaN ... True False 2026-07-09 13:39:23.492933+00:00 1 1 1 2 NaN None 18
26075 LmM4I1lM3GZQRW4L0000 esm/art%3A10.1038%2Fs41467-022-28120-2/MediaOb... Supplementary MOESM7 — pre-computed DESeq2 bul... .xlsx None None 22274609 AvbNebMwmKOyKvB5Ny_rRQ NaN NaN ... True False 2026-07-09 13:38:48.400046+00:00 1 1 1 60 NaN None 18
25855 K415DrXcuPiJmXlX5iXI iris_studies/study0_raw_images None None None 658486 tt98Ho0i3BlFtV84BlI6Dw 52.0 NaN ... True False 2026-07-07 12:24:59.162462+00:00 1 1 1 2 NaN None 46

20 rows × 22 columns

in¶

db.Artifact.filter(suffix__in=[".jpg", ".fastq.gz"]).to_dataframe()
Show code cell output Hide code cell output
! truncated query result to limit=20 Artifact objects
uid key description suffix kind otype size hash n_files n_observations ... is_latest is_locked created_at branch_id created_on_id space_id storage_id run_id schema_id created_by_id
id
26631 qGXvU8SFFsQclgR10000 Uploads/iris-0337d20a3b7273aa0ddaa7d6afb57a37a... None .jpg None None 14529 e0Gct8LodEyQzNwy1glOPA None None ... True False 2026-07-14 14:51:33.166215+00:00 1 1 1 2 NaN None 46
23623 siAj6EUthWF8gs2S0000 temp/output/fetchngs/fastq/SRX9315476_SRR12848... Output artifact for run 8541 .fastq.gz dataset None 123467 A_WjRYau-c1h9U6yaDGmZQ None None ... True False 2026-06-01 09:38:35.976330+00:00 1 1 1 59 8541.0 None 54
23622 F9Tn8DfxnBPGtssK0000 temp/output/fetchngs/fastq/SRX9315476_SRR12848... Output artifact for run 8541 .fastq.gz dataset None 131539 l3AcXYhK-NlrqV1yN_O_eQ None None ... True False 2026-06-01 09:38:31.103701+00:00 1 1 1 59 8541.0 None 54
23621 FtiwkNxd0Ila7VWx0000 temp/output/fetchngs/fastq/SRX11047067_SRR1470... Output artifact for run 8541 .fastq.gz dataset None 150 eRQN0cs_0cXgLYjgH3w-2g None None ... True False 2026-06-01 09:38:26.673415+00:00 1 1 1 59 8541.0 None 54
23620 Xh881SEOzEhkxVBh0000 temp/output/fetchngs/fastq/SRX10940790_SRR1459... Output artifact for run 8541 .fastq.gz dataset None 473 y9MHFf3vRX16okoS8Z7t8g None None ... True False 2026-06-01 09:38:22.275334+00:00 1 1 1 59 8541.0 None 54
23619 U4GV6WjzB72LJJNy0000 temp/output/fetchngs/fastq/SRX10940790_SRR1459... Output artifact for run 8541 .fastq.gz dataset None 459 akdizw8fn1VE03NeLgfF0w None None ... True False 2026-06-01 09:38:18.479607+00:00 1 1 1 59 8541.0 None 54
23617 1YEM2Tzio0JpaPke0000 temp/output/fetchngs/fastq/SRX9504942_SRR13055... Output artifact for run 8541 .fastq.gz dataset None 714907 WtUUYMbEqFDdN6IG4sRBwQ None None ... True False 2026-06-01 09:37:53.956200+00:00 1 1 1 59 8541.0 None 54
23616 8DhYtWgZJO545TJo0000 temp/output/fetchngs/fastq/SRX9504942_SRR13055... Output artifact for run 8541 .fastq.gz dataset None 721705 qXc2e_QdrPTCG8DIIBuLiA None None ... True False 2026-06-01 09:37:39.002608+00:00 1 1 1 59 8541.0 None 54
23615 NgZujyEK9KmFMlFK0000 temp/output/fetchngs/fastq/SRX9504942_SRR13055... Output artifact for run 8541 .fastq.gz dataset None 717693 XsiU2GP87-OURwoJJa795A None None ... True False 2026-06-01 09:37:29.243127+00:00 1 1 1 59 8541.0 None 54
23614 rLzlXSOpP8o1piIs0000 temp/output/fetchngs/fastq/SRX9504942_SRR13055... Output artifact for run 8541 .fastq.gz dataset None 716862 w_NDeTVrKNbaxyEqvBoKBA None None ... True False 2026-06-01 09:37:24.188066+00:00 1 1 1 59 8541.0 None 54
23613 3ZaqjSNEoKh6oFhd0000 temp/output/fetchngs/fastq/SRX9504942_SRR13055... Output artifact for run 8541 .fastq.gz dataset None 723429 rq0XDfmFF3PVICtXYMdtdg None None ... True False 2026-06-01 09:37:19.907708+00:00 1 1 1 59 8541.0 None 54
23612 bsdimhTQzRM2o8yw0000 temp/output/fetchngs/fastq/SRX9504942_SRR13055... Output artifact for run 8541 .fastq.gz dataset None 723753 GNvpbn9YtjQG2QWJON8ZYg None None ... True False 2026-06-01 09:37:15.705903+00:00 1 1 1 59 8541.0 None 54
23611 rlSHuDVS2LYCdLoH0000 temp/output/fetchngs/fastq/SRX9504942_SRR13055... Output artifact for run 8541 .fastq.gz dataset None 709867 eV1GCr_2AJx_X_fBS3c_vg None None ... True False 2026-06-01 09:37:09.722288+00:00 1 1 1 59 8541.0 None 54
23610 WjmuV1mc8tQC91p60000 temp/output/fetchngs/fastq/SRX9504942_SRR13055... Output artifact for run 8541 .fastq.gz dataset None 721167 3PRDjAtoIkLukMXzqAP7QA None None ... True False 2026-06-01 09:37:04.398585+00:00 1 1 1 59 8541.0 None 54
23609 BgqbFQuLmJbpmZ980000 temp/output/fetchngs/fastq/SRX6725035_SRR99841... Output artifact for run 8541 .fastq.gz dataset None 605358 C1EtLcMWhZg0Vr1W_YNlRA None None ... True False 2026-06-01 09:36:57.774141+00:00 1 1 1 59 8541.0 None 54
23608 n8fhOhvOk2JN5QAH0000 temp/output/fetchngs/fastq/DRX024467_DRR026872... Output artifact for run 8541 .fastq.gz dataset None 38447 UV5USMVeBUETxKIt9fYnkQ None None ... True False 2026-06-01 09:36:53.310799+00:00 1 1 1 59 8541.0 None 54
23607 BvcOjWC5ErBlEyw40000 temp/output/fetchngs/fastq/SRX9626017_SRR13191... Output artifact for run 8541 .fastq.gz dataset None 16324 Vicb44qA23jvO9_F2ZCbmA None None ... True False 2026-06-01 09:36:48.813406+00:00 1 1 1 59 8541.0 None 54
23606 kTx9UdwTAFjY5VpB0000 temp/output/fetchngs/fastq/SRX9626017_SRR13191... Output artifact for run 8541 .fastq.gz dataset None 15420 icW-kgAhoDUITYrrdPMt9w None None ... True False 2026-06-01 09:36:44.866169+00:00 1 1 1 59 8541.0 None 54
23605 jcsGrRR4E7UXvUjv0000 temp/output/fetchngs/fastq/ERX1234253_ERR11608... Output artifact for run 8541 .fastq.gz dataset None 18077 WSTyDvVH69_tfK15W7q25g None None ... True False 2026-06-01 09:36:05.779736+00:00 1 1 1 59 8541.0 None 54
23604 0fznQ2Jc0ttK94cU0000 temp/output/fetchngs/fastq/DRX026011_DRR028935... Output artifact for run 8541 .fastq.gz dataset None 61610 lByZmNdGQW2tU8lMSA3fMA None None ... True False 2026-06-01 09:35:42.557319+00:00 1 1 1 59 8541.0 None 54

20 rows × 22 columns

order by¶

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

20 rows × 22 columns

# reverse ordering
db.Artifact.filter().order_by("-created_at").to_dataframe()
Show code cell output Hide code cell output
! truncated query result to limit=20 Artifact objects
uid key description suffix kind otype size hash n_files n_observations ... is_latest is_locked created_at branch_id created_on_id space_id storage_id run_id schema_id created_by_id
id
26942 fsOwNYGqASmvzxth0000 None Claude Code session transcript (rendered) .html None None 54089 9CRTGFcZZbEtDFycYMd5wg None NaN ... True False 2026-07-17 12:24:43.543883+00:00 1 1 1 2 NaN None 2
26916 Xtd7yycLiboMIvpS0000 None Claude Code session transcript (rendered) .html None None 5809 FP7Zoy9t8wYpymRcby9ZyA None NaN ... True False 2026-07-17 08:55:26.841894+00:00 1 1 1 2 NaN None 18
26914 99zGx7Bu1M2FE4Sw0000 None Human insulin protein sequence (UniProt P01308) .fasta None None 140 ldHpRp_1hWpgrMDU-5V6Uw None NaN ... True False 2026-07-17 08:55:13.654872+00:00 1 1 1 2 11163.0 None 18
26835 UttjBSC5KpOkLCnF0000 None Claude Code session transcript (rendered) .html None None 4971 Zwixao9rLkD1ETiPppQyzw None NaN ... True False 2026-07-16 14:14:00.907497+00:00 1 1 1 2 NaN None 76
26833 3n344O47mufZu0lO0000 None Human lysozyme C (P61626) sequence .fasta None None 180 aO0jQkhn0DAk_-6VEwLRYA None NaN ... True False 2026-07-16 14:13:46.211473+00:00 1 1 1 2 11103.0 None 76
26816 vmDUa3zok29bG7BU0000 None Claude Code session transcript (rendered) .html None None 11247 nS-ZUyqlOMkuarBVmHzoXA None NaN ... True False 2026-07-16 13:10:58.083436+00:00 1 1 1 2 NaN None 76
26814 HkcuyVEKNYUfvnZQ0000 None GFP protein sequence .fasta None None 288 u1GCC1M0z5hehWam9ry9Nw None NaN ... True False 2026-07-16 13:10:48.760491+00:00 1 1 1 2 11088.0 None 76
26812 mZGblHNvZOd591fX0000 None Favorite protein: human ubiquitin (P0CG47) .fasta None None 109 Bcds33u64jii0Hk6QbMjjQ None NaN ... True False 2026-07-16 13:02:36.587427+00:00 1 1 1 2 NaN None 76
26705 UnpJi7qjT0xzqMcg0000 None Claude Code session transcript (rendered) .html None None 75628 qVb_8ZKg2pfAsTZqud7qjQ None NaN ... True False 2026-07-15 14:11:04.281778+00:00 1 1 1 2 NaN None 2
26673 NuZqfITKaDxHtL8J0000 schmidt22/ifng-hits-cellstate-prioritized-targ... IFNG CRISPRa hits prioritized by screen streng... .parquet None DataFrame 15891 48DFEvVrjQ2m42IHT_t_fg None NaN ... True False 2026-07-15 10:22:51.241153+00:00 1 1 1 2 10980.0 None 2
26671 J3KAL83hx32Z86YC0000 None Claude Code session transcript (rendered) .html None None 118754 4Jqh500CRi5OwHIVqKXO2Q None NaN ... True False 2026-07-15 09:55:07.318686+00:00 1 1 1 2 NaN None 2
26667 v5yV12AQGsqqkiVo0002 schmidt22/ifng-hits-drug-repurposing-candidate... Step 2: approved/clinical compounds per MoA cl... .parquet None DataFrame 15309 hCfK7MBp8zinZiVaVt43eA None NaN ... True False 2026-07-15 09:50:50.509878+00:00 1 1 1 2 10976.0 None 2
26665 v5yV12AQGsqqkiVo0001 schmidt22/ifng-hits-drug-repurposing-candidate... Step 2: approved/clinical compounds per MoA cl... .parquet None DataFrame 15287 G9R5S-pvaKxe01Q33vrOog None NaN ... False False 2026-07-15 09:48:55.993853+00:00 1 1 1 2 10975.0 None 2
26663 v5yV12AQGsqqkiVo0000 schmidt22/ifng-hits-drug-repurposing-candidate... Step 2: approved/clinical compounds per MoA cl... .parquet None DataFrame 14608 UVc5k5VlV5-SC_2wwe4IjA None NaN ... False False 2026-07-15 09:32:54.545077+00:00 1 1 1 2 10974.0 None 2
26662 sHqkE5Vz9M9C6C900000 schmidt22/ifng-hits-druggability-ranked.parquet Step 2: selected IFN-g CRISPRa hits with Open ... .parquet None DataFrame 17018 UxAg8wSR-BHTuQRtudsBzA None NaN ... True False 2026-07-15 09:32:53.226608+00:00 1 1 1 2 10976.0 None 2
26640 AhvOvqOL3ABR8Ul10000 None Claude Code session transcript (rendered) .html None None 76422 iDqXSRg81e37hKlMJkuLgA None NaN ... True False 2026-07-14 17:27:38.790315+00:00 1 1 1 2 NaN None 2
26639 t4INEklbuA6APFil0000 None Claude Code session transcript (rendered) .html None None 70349 IY0CUrS0zHVx2hzDnWYe7w None NaN ... True False 2026-07-14 17:25:00.737457+00:00 1 1 1 2 NaN None 2
26636 FydRpUZu93QVCXVD0001 schmidt22/ifng-hits-moa-immunotherapy-map.parquet MoA classification + immunotherapy map for Sch... .parquet dataset DataFrame 24769 jCVMvFEEDG2qX4dUQZdhJg None 123.0 ... True False 2026-07-14 16:53:30.700610+00:00 1 1 1 2 10955.0 None 2
26631 qGXvU8SFFsQclgR10000 Uploads/iris-0337d20a3b7273aa0ddaa7d6afb57a37a... None .jpg None None 14529 e0Gct8LodEyQzNwy1glOPA None NaN ... True False 2026-07-14 14:51:33.166215+00:00 1 1 1 2 NaN None 46
26596 cSJxkiptE2yc8l4K0000 None Claude Code session transcript (rendered) .html None None 6263 FRcb6lLJwQb12G_NinK3Lw None NaN ... True False 2026-07-13 09:50:06.450039+00:00 1 1 1 2 NaN None 76

20 rows × 22 columns

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

20 rows × 22 columns

# reverse ordering
db.Artifact.filter().order_by("-key").to_dataframe()
Show code cell output Hide code cell output
! truncated query result to limit=20 Artifact objects
uid key description suffix kind otype size hash n_files n_observations ... is_latest is_locked created_at branch_id created_on_id space_id storage_id run_id schema_id created_by_id
id
26596 cSJxkiptE2yc8l4K0000 None Claude Code session transcript (rendered) .html None None 6263 FRcb6lLJwQb12G_NinK3Lw None None ... True False 2026-07-13 09:50:06.450039+00:00 1 1 1 2 NaN None 76
26914 99zGx7Bu1M2FE4Sw0000 None Human insulin protein sequence (UniProt P01308) .fasta None None 140 ldHpRp_1hWpgrMDU-5V6Uw None None ... True False 2026-07-17 08:55:13.654872+00:00 1 1 1 2 11163.0 None 18
26916 Xtd7yycLiboMIvpS0000 None Claude Code session transcript (rendered) .html None None 5809 FP7Zoy9t8wYpymRcby9ZyA None None ... True False 2026-07-17 08:55:26.841894+00:00 1 1 1 2 NaN None 18
26942 fsOwNYGqASmvzxth0000 None Claude Code session transcript (rendered) .html None None 54089 9CRTGFcZZbEtDFycYMd5wg None None ... True False 2026-07-17 12:24:43.543883+00:00 1 1 1 2 NaN None 2
26216 6aBXn4WA7KTY4kdR0000 None My favorite protein: GFP (Aequorea victoria) .fasta None None 286 0sl2VA77p1pLnYW3karEcg None None ... True False 2026-07-10 12:30:53.643423+00:00 1 1 1 2 10628.0 None 76
26218 yKvUMOXFiHZydncp0000 None Claude Code session transcript (rendered) .html None None 8726 P3RVRxTdVMc-lacpuq5AKg None None ... True False 2026-07-10 12:31:08.853041+00:00 1 1 1 2 NaN None 76
26219 2gru6XS8Z6jY8MEO0000 None Hello world Jupyter notebook .ipynb None None 388 TDYEYEIFjfFb6mSnwyhuew None None ... True False 2026-07-10 12:41:04.458910+00:00 1 1 1 2 10629.0 None 76
26220 TuEwdv7nqIqUeQ4n0000 None Claude Code session transcript (rendered) .html None None 6142 faLXEN_58DLTVDWCXIMlnw None None ... True False 2026-07-10 12:41:18.074867+00:00 1 1 1 2 NaN None 76
26221 lka0NtiqFDmJ4t530000 None GFP protein sequence (FASTA) .fasta None None 286 oELzDke-xFxZ5_44vRUhUw None None ... True False 2026-07-10 12:46:36.562812+00:00 1 1 1 2 10631.0 None 76
26223 W8500GlAAnpQy30g0000 None Claude Code session transcript (rendered) .html None None 6311 GQEb_6joM5PiF3L-XuVsiw None None ... True False 2026-07-10 12:46:50.770058+00:00 1 1 1 2 NaN None 76
26224 RuOHH3sYlcFmBzI20000 None GFP (Green Fluorescent Protein) sequence from ... .fasta None None 290 XMuxUfouvaQ3EAAM6Z_TCg None None ... True False 2026-07-10 13:02:19.969023+00:00 1 1 1 2 10633.0 None 76
26226 HHNtInOYtM2dPBTB0000 None Claude Code session transcript (rendered) .html None None 5378 IhSws75fwi_L62n9cWDw2g None None ... True False 2026-07-10 13:02:34.014479+00:00 1 1 1 2 NaN None 76
26227 Uo1ymqYq3PSHxuKy0000 None Claude Code session transcript (rendered) .html None None 4981 PFDaDYUhSyPl6cAqTI2rZw None None ... True False 2026-07-10 13:03:54.863570+00:00 1 1 1 2 NaN None 76
26228 N30Mft6mkyrOHlhy0000 None Claude Code session transcript (rendered) .html None None 3677 5JUcm9Z_XB2FXDOV544vvQ None None ... True False 2026-07-10 13:08:29.485278+00:00 1 1 1 2 NaN None 76
26230 kiW2obvoqFYwFI3j0000 None Claude Code session transcript (rendered) .html None None 6643 ijGpUU3DevQH_SoXK2osUg None None ... True False 2026-07-10 13:11:16.225120+00:00 1 1 1 2 NaN None 76
26243 ihOzc2FvyELILXsX0000 None Claude Code session transcript (rendered) .html None None 4099 Fw9dbYpg801NqmUfYzFRRA None None ... True False 2026-07-10 13:18:17.481708+00:00 1 1 1 2 NaN None 76
26244 Y6LI26PbuXK0njUC0000 None GFP protein sequence (FASTA) .fasta None None 310 luW8doRcIKlizK9tov0f_w None None ... True False 2026-07-10 13:19:18.924430+00:00 1 1 1 2 10649.0 None 76
26246 IE1rDjWQXsGOdOSl0000 None Claude Code session transcript (rendered) .html None None 5753 2RaWoB4AmN9hBpOYsHHg1A None None ... True False 2026-07-10 13:19:37.501796+00:00 1 1 1 2 NaN None 76
26251 STTHnsCi2Wes6ocS0000 None Claude Code session transcript (rendered) .html None None 5888 g7elukxjYlJVHpTL2lynWw None None ... True False 2026-07-10 13:29:26.035475+00:00 1 1 1 2 NaN None 76
26252 4KFh4Zr5cE4foPqK0000 None Claude Code session transcript (rendered) .html None None 5220 BB01Xed2rIf2x-8fJyFIYA None None ... True False 2026-07-10 13:31:56.691074+00:00 1 1 1 2 NaN None 76

20 rows × 22 columns

contains¶

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

And case-insensitive:

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

startswith¶

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

or¶

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

db.Artifact.filter(ln.Q(suffix=".jpg") | ln.Q(suffix=".fastq.gz")).to_dataframe()
Show code cell output Hide code cell output
! truncated query result to limit=20 Artifact objects
uid key description suffix kind otype size hash n_files n_observations ... is_latest is_locked created_at branch_id created_on_id space_id storage_id run_id schema_id created_by_id
id
26631 qGXvU8SFFsQclgR10000 Uploads/iris-0337d20a3b7273aa0ddaa7d6afb57a37a... None .jpg None None 14529 e0Gct8LodEyQzNwy1glOPA None None ... True False 2026-07-14 14:51:33.166215+00:00 1 1 1 2 NaN None 46
23623 siAj6EUthWF8gs2S0000 temp/output/fetchngs/fastq/SRX9315476_SRR12848... Output artifact for run 8541 .fastq.gz dataset None 123467 A_WjRYau-c1h9U6yaDGmZQ None None ... True False 2026-06-01 09:38:35.976330+00:00 1 1 1 59 8541.0 None 54
23622 F9Tn8DfxnBPGtssK0000 temp/output/fetchngs/fastq/SRX9315476_SRR12848... Output artifact for run 8541 .fastq.gz dataset None 131539 l3AcXYhK-NlrqV1yN_O_eQ None None ... True False 2026-06-01 09:38:31.103701+00:00 1 1 1 59 8541.0 None 54
23621 FtiwkNxd0Ila7VWx0000 temp/output/fetchngs/fastq/SRX11047067_SRR1470... Output artifact for run 8541 .fastq.gz dataset None 150 eRQN0cs_0cXgLYjgH3w-2g None None ... True False 2026-06-01 09:38:26.673415+00:00 1 1 1 59 8541.0 None 54
23620 Xh881SEOzEhkxVBh0000 temp/output/fetchngs/fastq/SRX10940790_SRR1459... Output artifact for run 8541 .fastq.gz dataset None 473 y9MHFf3vRX16okoS8Z7t8g None None ... True False 2026-06-01 09:38:22.275334+00:00 1 1 1 59 8541.0 None 54
23619 U4GV6WjzB72LJJNy0000 temp/output/fetchngs/fastq/SRX10940790_SRR1459... Output artifact for run 8541 .fastq.gz dataset None 459 akdizw8fn1VE03NeLgfF0w None None ... True False 2026-06-01 09:38:18.479607+00:00 1 1 1 59 8541.0 None 54
23617 1YEM2Tzio0JpaPke0000 temp/output/fetchngs/fastq/SRX9504942_SRR13055... Output artifact for run 8541 .fastq.gz dataset None 714907 WtUUYMbEqFDdN6IG4sRBwQ None None ... True False 2026-06-01 09:37:53.956200+00:00 1 1 1 59 8541.0 None 54
23616 8DhYtWgZJO545TJo0000 temp/output/fetchngs/fastq/SRX9504942_SRR13055... Output artifact for run 8541 .fastq.gz dataset None 721705 qXc2e_QdrPTCG8DIIBuLiA None None ... True False 2026-06-01 09:37:39.002608+00:00 1 1 1 59 8541.0 None 54
23615 NgZujyEK9KmFMlFK0000 temp/output/fetchngs/fastq/SRX9504942_SRR13055... Output artifact for run 8541 .fastq.gz dataset None 717693 XsiU2GP87-OURwoJJa795A None None ... True False 2026-06-01 09:37:29.243127+00:00 1 1 1 59 8541.0 None 54
23614 rLzlXSOpP8o1piIs0000 temp/output/fetchngs/fastq/SRX9504942_SRR13055... Output artifact for run 8541 .fastq.gz dataset None 716862 w_NDeTVrKNbaxyEqvBoKBA None None ... True False 2026-06-01 09:37:24.188066+00:00 1 1 1 59 8541.0 None 54
23613 3ZaqjSNEoKh6oFhd0000 temp/output/fetchngs/fastq/SRX9504942_SRR13055... Output artifact for run 8541 .fastq.gz dataset None 723429 rq0XDfmFF3PVICtXYMdtdg None None ... True False 2026-06-01 09:37:19.907708+00:00 1 1 1 59 8541.0 None 54
23612 bsdimhTQzRM2o8yw0000 temp/output/fetchngs/fastq/SRX9504942_SRR13055... Output artifact for run 8541 .fastq.gz dataset None 723753 GNvpbn9YtjQG2QWJON8ZYg None None ... True False 2026-06-01 09:37:15.705903+00:00 1 1 1 59 8541.0 None 54
23611 rlSHuDVS2LYCdLoH0000 temp/output/fetchngs/fastq/SRX9504942_SRR13055... Output artifact for run 8541 .fastq.gz dataset None 709867 eV1GCr_2AJx_X_fBS3c_vg None None ... True False 2026-06-01 09:37:09.722288+00:00 1 1 1 59 8541.0 None 54
23610 WjmuV1mc8tQC91p60000 temp/output/fetchngs/fastq/SRX9504942_SRR13055... Output artifact for run 8541 .fastq.gz dataset None 721167 3PRDjAtoIkLukMXzqAP7QA None None ... True False 2026-06-01 09:37:04.398585+00:00 1 1 1 59 8541.0 None 54
23609 BgqbFQuLmJbpmZ980000 temp/output/fetchngs/fastq/SRX6725035_SRR99841... Output artifact for run 8541 .fastq.gz dataset None 605358 C1EtLcMWhZg0Vr1W_YNlRA None None ... True False 2026-06-01 09:36:57.774141+00:00 1 1 1 59 8541.0 None 54
23608 n8fhOhvOk2JN5QAH0000 temp/output/fetchngs/fastq/DRX024467_DRR026872... Output artifact for run 8541 .fastq.gz dataset None 38447 UV5USMVeBUETxKIt9fYnkQ None None ... True False 2026-06-01 09:36:53.310799+00:00 1 1 1 59 8541.0 None 54
23607 BvcOjWC5ErBlEyw40000 temp/output/fetchngs/fastq/SRX9626017_SRR13191... Output artifact for run 8541 .fastq.gz dataset None 16324 Vicb44qA23jvO9_F2ZCbmA None None ... True False 2026-06-01 09:36:48.813406+00:00 1 1 1 59 8541.0 None 54
23606 kTx9UdwTAFjY5VpB0000 temp/output/fetchngs/fastq/SRX9626017_SRR13191... Output artifact for run 8541 .fastq.gz dataset None 15420 icW-kgAhoDUITYrrdPMt9w None None ... True False 2026-06-01 09:36:44.866169+00:00 1 1 1 59 8541.0 None 54
23605 jcsGrRR4E7UXvUjv0000 temp/output/fetchngs/fastq/ERX1234253_ERR11608... Output artifact for run 8541 .fastq.gz dataset None 18077 WSTyDvVH69_tfK15W7q25g None None ... True False 2026-06-01 09:36:05.779736+00:00 1 1 1 59 8541.0 None 54
23604 0fznQ2Jc0ttK94cU0000 temp/output/fetchngs/fastq/DRX026011_DRR028935... Output artifact for run 8541 .fastq.gz dataset None 61610 lByZmNdGQW2tU8lMSA3fMA None None ... True False 2026-06-01 09:35:42.557319+00:00 1 1 1 59 8541.0 None 54

20 rows × 22 columns

negate/ unequal¶

db.Artifact.filter(~ln.Q(suffix=".jpg")).to_dataframe()
Show code cell output Hide code cell output
! truncated query result to limit=20 Artifact objects
uid key description suffix kind otype size hash n_files n_observations ... is_latest is_locked created_at branch_id created_on_id space_id storage_id run_id schema_id created_by_id
id
26942 fsOwNYGqASmvzxth0000 None Claude Code session transcript (rendered) .html None None 54089 9CRTGFcZZbEtDFycYMd5wg None NaN ... True False 2026-07-17 12:24:43.543883+00:00 1 1 1 2 NaN None 2
26916 Xtd7yycLiboMIvpS0000 None Claude Code session transcript (rendered) .html None None 5809 FP7Zoy9t8wYpymRcby9ZyA None NaN ... True False 2026-07-17 08:55:26.841894+00:00 1 1 1 2 NaN None 18
26914 99zGx7Bu1M2FE4Sw0000 None Human insulin protein sequence (UniProt P01308) .fasta None None 140 ldHpRp_1hWpgrMDU-5V6Uw None NaN ... True False 2026-07-17 08:55:13.654872+00:00 1 1 1 2 11163.0 None 18
26835 UttjBSC5KpOkLCnF0000 None Claude Code session transcript (rendered) .html None None 4971 Zwixao9rLkD1ETiPppQyzw None NaN ... True False 2026-07-16 14:14:00.907497+00:00 1 1 1 2 NaN None 76
26833 3n344O47mufZu0lO0000 None Human lysozyme C (P61626) sequence .fasta None None 180 aO0jQkhn0DAk_-6VEwLRYA None NaN ... True False 2026-07-16 14:13:46.211473+00:00 1 1 1 2 11103.0 None 76
26816 vmDUa3zok29bG7BU0000 None Claude Code session transcript (rendered) .html None None 11247 nS-ZUyqlOMkuarBVmHzoXA None NaN ... True False 2026-07-16 13:10:58.083436+00:00 1 1 1 2 NaN None 76
26814 HkcuyVEKNYUfvnZQ0000 None GFP protein sequence .fasta None None 288 u1GCC1M0z5hehWam9ry9Nw None NaN ... True False 2026-07-16 13:10:48.760491+00:00 1 1 1 2 11088.0 None 76
26812 mZGblHNvZOd591fX0000 None Favorite protein: human ubiquitin (P0CG47) .fasta None None 109 Bcds33u64jii0Hk6QbMjjQ None NaN ... True False 2026-07-16 13:02:36.587427+00:00 1 1 1 2 NaN None 76
26705 UnpJi7qjT0xzqMcg0000 None Claude Code session transcript (rendered) .html None None 75628 qVb_8ZKg2pfAsTZqud7qjQ None NaN ... True False 2026-07-15 14:11:04.281778+00:00 1 1 1 2 NaN None 2
26673 NuZqfITKaDxHtL8J0000 schmidt22/ifng-hits-cellstate-prioritized-targ... IFNG CRISPRa hits prioritized by screen streng... .parquet None DataFrame 15891 48DFEvVrjQ2m42IHT_t_fg None NaN ... True False 2026-07-15 10:22:51.241153+00:00 1 1 1 2 10980.0 None 2
26671 J3KAL83hx32Z86YC0000 None Claude Code session transcript (rendered) .html None None 118754 4Jqh500CRi5OwHIVqKXO2Q None NaN ... True False 2026-07-15 09:55:07.318686+00:00 1 1 1 2 NaN None 2
26667 v5yV12AQGsqqkiVo0002 schmidt22/ifng-hits-drug-repurposing-candidate... Step 2: approved/clinical compounds per MoA cl... .parquet None DataFrame 15309 hCfK7MBp8zinZiVaVt43eA None NaN ... True False 2026-07-15 09:50:50.509878+00:00 1 1 1 2 10976.0 None 2
26665 v5yV12AQGsqqkiVo0001 schmidt22/ifng-hits-drug-repurposing-candidate... Step 2: approved/clinical compounds per MoA cl... .parquet None DataFrame 15287 G9R5S-pvaKxe01Q33vrOog None NaN ... False False 2026-07-15 09:48:55.993853+00:00 1 1 1 2 10975.0 None 2
26663 v5yV12AQGsqqkiVo0000 schmidt22/ifng-hits-drug-repurposing-candidate... Step 2: approved/clinical compounds per MoA cl... .parquet None DataFrame 14608 UVc5k5VlV5-SC_2wwe4IjA None NaN ... False False 2026-07-15 09:32:54.545077+00:00 1 1 1 2 10974.0 None 2
26662 sHqkE5Vz9M9C6C900000 schmidt22/ifng-hits-druggability-ranked.parquet Step 2: selected IFN-g CRISPRa hits with Open ... .parquet None DataFrame 17018 UxAg8wSR-BHTuQRtudsBzA None NaN ... True False 2026-07-15 09:32:53.226608+00:00 1 1 1 2 10976.0 None 2
26640 AhvOvqOL3ABR8Ul10000 None Claude Code session transcript (rendered) .html None None 76422 iDqXSRg81e37hKlMJkuLgA None NaN ... True False 2026-07-14 17:27:38.790315+00:00 1 1 1 2 NaN None 2
26639 t4INEklbuA6APFil0000 None Claude Code session transcript (rendered) .html None None 70349 IY0CUrS0zHVx2hzDnWYe7w None NaN ... True False 2026-07-14 17:25:00.737457+00:00 1 1 1 2 NaN None 2
26636 FydRpUZu93QVCXVD0001 schmidt22/ifng-hits-moa-immunotherapy-map.parquet MoA classification + immunotherapy map for Sch... .parquet dataset DataFrame 24769 jCVMvFEEDG2qX4dUQZdhJg None 123.0 ... True False 2026-07-14 16:53:30.700610+00:00 1 1 1 2 10955.0 None 2
26596 cSJxkiptE2yc8l4K0000 None Claude Code session transcript (rendered) .html None None 6263 FRcb6lLJwQb12G_NinK3Lw None NaN ... True False 2026-07-13 09:50:06.450039+00:00 1 1 1 2 NaN None 76
26594 6xqt9irhSbtEPqFi0000 None GFP protein sequence (FASTA) .fasta None None 290 8vMGVk73cPu5a_1JEZJYwQ None NaN ... True False 2026-07-13 09:49:53.184020+00:00 1 1 1 2 10923.0 None 76

20 rows × 22 columns

JSON¶

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

0 rows × 23 columns

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

previous

Install & setup

next

Query tables in storage

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