Query & search

This guide walks through querying & searching registries. To understand the links between objects that enable relational queries, see Organize datasets. To stream datasets from storage, see Stream datasets from 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
25712	KnRgutpkaOiVVhli0000	None	GFP protein sequence	.fasta	None	None	273	aCG0PbcBSURek59gf5ZA9w	None	NaN	...	True	False	2026-07-05 19:22:45.104339+00:00	2	1	1	2	10222.0	None	18
25696	Q2gXw8D0zkP86n7C0000	None	My favorite protein sequence (GFP)	.fasta	None	None	273	42yLTIs-Wu-Sq_gzdXJgZg	None	NaN	...	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	NaN	...	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	NaN	...	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	NaN	...	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	NaN	...	True	False	2026-07-05 14:57:02.553598+00:00	1	1	1	2	10182.0	None	18
25496	TMRsx3ZV9xcMdj370000	test/agent-trace.jsonl	None	.jsonl	None	None	36065	T6fTmwdaMZmJagO9P_rIzg	None	NaN	...	True	False	2026-07-03 13:42:48.760793+00:00	1	1	1	2	NaN	None	9
25493	IEDEe8XxiD7gBucS0000	falexwolf/adhoc/artifact-type-summary.png	None	.png	None	None	79206	pMmOCGMk_7DI9v8JMUrlFA	None	NaN	...	True	False	2026-07-03 13:35:00.201612+00:00	1	57	1	2	10049.0	None	9
25491	OKMb2f9CBlGmRnOo0000	.plans/lamindata_artifact_summary_3679bd17.pla...	Create a notebook in `/Users/falexwolf/work/db...	.md	plan	None	2451	Nkp7iaGLGZwx4X26KZBGRA	None	NaN	...	True	False	2026-07-03 13:29:14.431662+00:00	1	57	1	2	10050.0	None	9
25063	MdvQpu992LjdLxNz0000	examples/mini_immuno_dataset1_with_typo.parquet	None	.parquet	dataset	DataFrame	9868	AxcqEowD5buTwzecXLVykA	None	3.0	...	True	False	2026-06-25 08:45:16.007021+00:00	1	1	1	2	9697.0	None	9
24890	BFfIHO5w8WPUywgR0000	None	My favorite protein sequence (Ubiquitin)	.fasta	None	None	156	xkHNV8nXb_IkgII2o7rqkw	None	NaN	...	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	NaN	...	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	NaN	...	True	False	2026-06-22 20:02:45.048795+00:00	1	1	1	2	9514.0	None	18
24689	Za9BV8mzLDxSNHoX0000	None	My favorite protein sequence (GFP)	.fasta	None	None	273	mcksul1N3dPAwqc95m0oiQ	None	NaN	...	True	False	2026-06-20 15:04:57.255099+00:00	1	1	1	2	9413.0	None	18
24685	wOwpbTvyue614wZP0000	None	Favorite protein sequence: Green Fluorescent P...	.fasta	None	None	302	FmlEFaBamN7gJNr3RzJsAw	None	NaN	...	True	False	2026-06-20 14:38:23.286709+00:00	1	1	1	2	9411.0	None	18
24676	AhD9v9CkvGxaHmRy0000	None	My favorite protein sequence (Ubiquitin)	.fasta	None	None	88	kAKsQi91nh4onb9Qg2wtNA	None	NaN	...	True	False	2026-06-20 08:07:33.784419+00:00	1	1	1	2	9407.0	None	18
24445	ML3sGjDVygvTErE00000	None	Favorite protein sequence (Green Fluorescent P...	.fasta	None	None	273	Z00XLvk9cGTelGzaM4bRwg	None	NaN	...	True	False	2026-06-15 23:25:29.225893+00:00	1	1	1	2	9223.0	None	18
24135	9nbQYEH7U1HPdClv0000	test_upload_2026-06-09T15-12-54-335Z.csv	None	.csv	None	DataFrame	926	L7-Gyxhb4-yPSFJtFsXI2A	None	NaN	...	True	False	2026-06-09 15:13:40.673436+00:00	1	1	1	2	NaN	None	46
24131	shcxkM3Gki4yvh2I0000	None	Green Fluorescent Protein (GFP) sequence FASTA	.fasta	None	None	336	RGWiZh_NYC0Ga8uiQOu2HQ	None	NaN	...	True	False	2026-06-09 10:36:45.008085+00:00	1	1	1	2	NaN	None	60
24130	JghFkzKE67sVAN2X0000	None	Green fluorescent protein (GFP) sequence	.fasta	None	None	270	xma0rkIdVZw2zlccMDyFZg	None	NaN	...	True	False	2026-06-09 10:35:56.107098+00:00	1	1	1	2	9564.0	None	60

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
25712	KnRgutpkaOiVVhli0000	None	testuser1
25696	Q2gXw8D0zkP86n7C0000	None	testuser1
25690	GYSbsO58JPcaoof10000	None	testuser1
25683	jUVonDJ2uOA4ef2u0000	None	testuser1
25677	Pedin9Spf0t0rx2U0000	None	testuser1
25654	jN5lGSn4g77TSsSk0000	None	testuser1
25496	TMRsx3ZV9xcMdj370000	test/agent-trace.jsonl	falexwolf
25493	IEDEe8XxiD7gBucS0000	falexwolf/adhoc/artifact-type-summary.png	falexwolf
25491	OKMb2f9CBlGmRnOo0000	.plans/lamindata_artifact_summary_3679bd17.pla...	falexwolf
25063	MdvQpu992LjdLxNz0000	examples/mini_immuno_dataset1_with_typo.parquet	falexwolf
24890	BFfIHO5w8WPUywgR0000	None	testuser1
24829	sQoSgM6pa1hul8410000	None	testuser1
24815	5yJpRQHDCWH7qBWF0000	None	testuser1
24689	Za9BV8mzLDxSNHoX0000	None	testuser1
24685	wOwpbTvyue614wZP0000	None	testuser1
24676	AhD9v9CkvGxaHmRy0000	None	testuser1
24445	ML3sGjDVygvTErE00000	None	testuser1
24135	9nbQYEH7U1HPdClv0000	test_upload_2026-06-09T15-12-54-335Z.csv	sheetalgiri
24131	shcxkM3Gki4yvh2I0000	None	ishitajain9717
24130	JghFkzKE67sVAN2X0000	None	ishitajain9717

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
25712	KnRgutpkaOiVVhli0000	None	GFP protein sequence	.fasta	None	None	273	aCG0PbcBSURek59gf5ZA9w	None	None	...	True	False	2026-07-05 19:22:45.104339+00:00	2	1	1	2	10222.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
25496	TMRsx3ZV9xcMdj370000	test/agent-trace.jsonl	None	.jsonl	None	None	36065	T6fTmwdaMZmJagO9P_rIzg	None	None	...	True	False	2026-07-03 13:42:48.760793+00:00	1	1	1	2	NaN	None	9

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
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
44	6aWTZ7J2ej1Rj22q0000	sharded_parquet_collection	None	XavO_EEZSi-shT6uJGFHHA	None	None	None	True	False	2025-08-04 14:05:14.345347+00:00	1	1	1	3	NaN	None

Feature

	uid	name	_dtype_str	unit	description	array_rank	array_size	array_shape	synonyms	default_value	...	coerce	is_locked	is_type	created_at	branch_id	created_on_id	space_id	created_by_id	run_id	type_id
id
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	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	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	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	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	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	692.0
695	8GSUnfVwFVqQ	cell_type_by_model	cat[bionty.CellType]	None	None	0	0	None	None	None	...	None	False	False	2026-06-23 14:50:01.310239+00:00	1	1	1	9	9591	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
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	None
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	None
61	loEcdB4vKZVd	pbmc3k	None	None	None	None	None	False	False	2026-04-17 14:09:59.773585+00:00	1	1	1	46	NaN	None
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	None
29	zq4JlFzOiYRs	nf-lamin-test-project-existing-240890f7	None	None	None	None	None	False	False	2026-02-18 17:38:39.242773+00:00	1	1	1	28	NaN	None
28	aR6prytLD0aT	nf-lamin-test-project-240890f7	None	None	None	None	None	False	False	2026-02-18 17:38:38.961706+00:00	1	1	1	28	NaN	None
27	SCCrukjJbplI	nf-lamin-test-project	None	None	None	None	None	False	False	2026-02-04 13:33:12.272319+00:00	1	1	1	28	NaN	None

Record

	uid	name	description	reference	reference_type	extra_data	is_locked	is_type	created_at	branch_id	created_on_id	space_id	created_by_id	type_id	schema_id	run_id
id
73682	IcBiP82ygPmzogyv	None	None	None	None	None	False	False	2026-07-06 10:58:22.841094+00:00	1	1	1	18	2759	None	10290
73681	jikQJBpJvk7777U1	None	None	None	None	None	False	False	2026-07-06 10:58:06.007148+00:00	1	1	1	18	611	None	10288
73680	IkCgJyFjpoA2XMTp	None	None	None	None	None	False	False	2026-07-06 10:57:46.688507+00:00	1	1	1	18	2319	None	10287
73679	i4kd5k5JFUdeCONO	None	None	None	None	None	False	False	2026-07-06 10:56:08.377923+00:00	1	1	1	18	2759	None	10286
73678	SwkX5aourckEASng	None	None	None	None	None	False	False	2026-07-06 10:55:51.676561+00:00	1	1	1	18	611	None	10285
73677	rPe2hfSr4PRnRzu8	None	None	None	None	None	False	False	2026-07-06 10:55:35.306719+00:00	1	1	1	18	2319	None	10284
73676	WpNWaBxri41DCO95	None	None	None	None	None	False	False	2026-07-06 10:14:15.841518+00:00	1	1	1	18	17753	None	10277

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
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
10298	DHgzSEcaFg6rJqee	None	None	None	2026-07-06 10:58:56.963901+00:00	2026-07-06 10:59:00.559092+00:00	None	None	None	None	...	2026-07-06 10:58:56.963901+00:00	1	1	1	705	NaN	NaN	None	18	10294.0
10297	kFjX1ZFTNmdYNrOp	None	None	None	2026-07-06 10:58:51.203596+00:00	2026-07-06 10:58:52.637086+00:00	None	None	None	None	...	2026-07-06 10:58:51.203596+00:00	1	1	1	411	NaN	NaN	None	18	NaN
10296	NK0DJrQJTwX833yz	None	None	None	2026-07-06 10:58:48.057334+00:00	2026-07-06 10:58:50.771957+00:00	None	None	None	None	...	2026-07-06 10:58:48.057334+00:00	1	1	1	411	NaN	NaN	None	18	NaN
10295	R5o61oAdztDSvGln	None	None	None	2026-07-06 10:58:45.833344+00:00	2026-07-06 10:58:47.464781+00:00	None	None	None	None	...	2026-07-06 10:58:45.833344+00:00	1	1	1	411	NaN	NaN	None	18	NaN
10294	wOtLYw8xCZkmVfD4	None	None	None	2026-07-06 10:58:42.393471+00:00	2026-07-06 10:59:02.264529+00:00	None	None	None	None	...	2026-07-06 10:58:42.393471+00:00	1	1	1	855	25794.0	25792.0	None	18	NaN
10293	xlbQZuHgjN5pp5e7	None	None	None	2026-07-06 10:58:26.324389+00:00	2026-07-06 10:58:28.249574+00:00	None	None	None	None	...	2026-07-06 10:58:26.324389+00:00	1	1	1	705	NaN	NaN	None	18	10289.0
10292	5kFDcRnaAhUTO8Qa	None	None	None	2026-07-06 10:58:20.242263+00:00	2026-07-06 10:58:21.664061+00:00	None	None	None	None	...	2026-07-06 10:58:20.242263+00:00	1	1	1	411	NaN	NaN	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
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
219	bmxc5wZWWvflo6xi	None	None	7	None	False	Feature	None	xxobgo1G_mLLMRGgPMRVTQ	True	...	False	False	False	2026-06-04 16:03:39.542630+00:00	1	1	1	2	NaN	NaN
218	FKPpUu37a3Fb5TPC	None	None	36503	None	False	bionty.Gene.ensembl_gene_id	None	MUuvWpKNXBFEWYfZtrlGpg	True	...	False	False	False	2026-06-03 05:09:31.776330+00:00	1	1	1	60	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
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
43	TwPtYAyQwlyO	s3://lamin-us-east-1/TwPtYAyQwlyO	None	s3	us-east-1	3ytNpiOQry0S	False	2024-08-30 13:34:02.166149+00:00	1	1	1	40	1712.0

Transform

	uid	key	description	kind	source_code	hash	reference	reference_type	version_tag	is_latest	is_locked	created_at	branch_id	created_on_id	space_id	environment_id	plan_id	run_id	created_by_id
id
1518	5u2Y0v8oZgJy000A	test_02/curate_artifact.py	None	script	import lamindb as ln\n\ndef curate():\n SOU...	aMzA4NX753E3S3ETQeM2dA	None	None	None	True	False	2026-07-05 21:03:31.874822+00:00	1	1	1	None	None	10243.0	18
1517	ctqEKfrE1tpw000Z	save_protein.py	None	script	import lamindb as ln\nln.track()\n\n# Define t...	c7jxqFg-DlTl-K88BvMZfw	None	None	None	True	False	2026-07-05 21:03:06.502803+00:00	1	1	1	None	None	10241.0	18
1516	wDJpT3xdqjY8000T	pypackages/laminagent/_lag.py	CLI: lag	script	from __future__ import annotations\n\nimport j...	F7wkY661iOe2SleiL8jvYQ	None	None	None	True	False	2026-07-05 21:02:50.413219+00:00	1	1	1	None	None	NaN	18
1515	5u2Y0v8oZgJy0009	test_02/curate_artifact.py	None	script	import lamindb as ln\n\nSOURCE_INSTANCE = "lam...	zsBTzzxQ62EEu2BToIS_9g	None	None	None	False	False	2026-07-05 20:42:58.191221+00:00	1	1	1	None	None	10236.0	18
1514	ctqEKfrE1tpw000Y	save_protein.py	None	script	import lamindb as ln\nln.track()\n\n# Define t...	VA-GgAeUrx5pUfCmsi_Hbg	None	None	None	False	False	2026-07-05 20:42:37.072163+00:00	1	1	1	None	None	10234.0	18
1513	wDJpT3xdqjY8000S	pypackages/laminagent/_lag.py	CLI: lag	script	from __future__ import annotations\n\nimport j...	ArOjzYS-4azUPg04NWdVSw	None	None	None	False	False	2026-07-05 20:42:24.892570+00:00	1	1	1	None	None	NaN	18
1512	5u2Y0v8oZgJy0008	test_02/curate_artifact.py	None	script	import lamindb as ln\n\n# Define constants\nSO...	DXuMzNX_GFKtKhdP_httQQ	None	None	None	False	False	2026-07-05 19:22:58.563530+00:00	1	1	1	None	None	10223.0	18

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
427	sYKMibhe	DMSO	None	None	None	False	False	2026-05-05 09:20:52.001475+00:00	1	1	1	9	7350.0	NaN
426	QfHuqIYG	min	None	None	None	False	False	2026-03-30 07:08:02.066228+00:00	1	1	1	9	NaN	425.0

******************

* 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

! skipping module 'pertdb': 'pertdb' wasn't configured in this environment -- run: lamin settings modules set pertdb
If your database instance also doesn't have it, go to your instance settings page and add it under 'schema modules' (or ask an admin to do so).

Get one object

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

db.Record.get("HhKWgzjVW6cfnVep")  # by uid
db.Record.get(name="EXP-RNA-001")  # by field, here the name field

Show code cell output 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
682	K415DrXcuPiJmXlX5iXH	iris_studies/study0_raw_images	None		None	None	658465	IVKGMfNwi8zKvnpaD_gG7w	51.0	None	...	True	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
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
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
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

6 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
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
24689	Za9BV8mzLDxSNHoX0000	None	My favorite protein sequence (GFP)	.fasta	None	None	273	mcksul1N3dPAwqc95m0oiQ	None	None	...	True	False	2026-06-20 15:04:57.255099+00:00	1	1	1	2	9413.0	None	18
24685	wOwpbTvyue614wZP0000	None	Favorite protein sequence: Green Fluorescent P...	.fasta	None	None	302	FmlEFaBamN7gJNr3RzJsAw	None	None	...	True	False	2026-06-20 14:38:23.286709+00:00	1	1	1	2	9411.0	None	18
24676	AhD9v9CkvGxaHmRy0000	None	My favorite protein sequence (Ubiquitin)	.fasta	None	None	88	kAKsQi91nh4onb9Qg2wtNA	None	None	...	True	False	2026-06-20 08:07:33.784419+00:00	1	1	1	2	9407.0	None	18
24445	ML3sGjDVygvTErE00000	None	Favorite protein sequence (Green Fluorescent P...	.fasta	None	None	273	Z00XLvk9cGTelGzaM4bRwg	None	None	...	True	False	2026-06-15 23:25:29.225893+00:00	1	1	1	2	9223.0	None	18
23021	IdCuNz7YD7vZsXNp0000	None	CSV upload test 68f86b59	.csv	None	DataFrame	40	V3gPFfaMaj-xOnss_UoN_Q	None	None	...	True	False	2026-05-20 06:32:42.293170+00:00	1	1	1	2	8089.0	None	18
23020	PKXw5o5pbN2rzs1d0000	None	CSV upload test 2b77dfa4	.csv	None	DataFrame	40	MC_53ttXxw6UQcBG9jJzcw	None	None	...	True	False	2026-05-20 06:31:58.159052+00:00	1	1	1	2	8087.0	None	18
23019	KDqaukxeIKmqheJu0000	None	Test artifact from InstanceArtifactApiTest 68f...	.txt	None	None	41	opuUicrM1nRTobhZ-YJxvw	None	None	...	True	False	2026-05-20 06:31:01.225373+00:00	1	1	1	2	NaN	None	18
23018	d22E7ELvz5EFaX7c0000	None	Binary upload test 68f86b59	.bin	None	None	1024	iQSjpPA8GUKgXBZzQNy4mQ	None	None	...	True	False	2026-05-20 06:30:56.584769+00:00	1	1	1	2	NaN	None	18
23017	D4CXZtO1D3rPmxlR0000	None	None	.txt	None	None	53	jWNoUlJBWtqUaXnzljzK6g	None	None	...	True	False	2026-05-20 06:30:52.008934+00:00	1	1	1	2	8089.0	None	18
23016	TsuKLOHuxSqPRWGB0000	None	Upload test 68f86b59	.txt	None	None	56	Dbu8Ozt5WQjZ1I5mBKhPmQ	None	None	...	True	False	2026-05-20 06:30:47.471761+00:00	1	1	1	2	NaN	None	18
23015	3ABF2qnUNDxSdAEG0000	None	Test artifact from InstanceArtifactApiTest 2b7...	.txt	None	None	41	HMs8cOjVzZWsZQQfUt1bhQ	None	None	...	True	False	2026-05-20 06:30:29.688516+00:00	1	1	1	2	NaN	None	18
23014	Lo6Di63ZcoJSztii0000	None	Binary upload test 2b77dfa4	.bin	None	None	1024	7StToXdZkm7T-qjEWy_dYA	None	None	...	True	False	2026-05-20 06:30:26.286814+00:00	1	1	1	2	NaN	None	18

20 rows × 22 columns

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

cd8a = db.bionty.Gene.get(symbol="CD8A")
# query for all schemas that contain CD8A
schemas_with_cd8a = db.Schema.filter(genes=cd8a)
# get all artifacts
db.Artifact.filter(schemas__in=schemas_with_cd8a).to_dataframe()

Show code cell output Hide code cell output

! truncated query result to limit=20 Artifact objects

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

20 rows × 22 columns

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

db.Artifact.filter(schemas__genes__symbol="CD8A").to_dataframe()

Show code cell output Hide code cell output

! truncated query result to limit=20 Artifact objects

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

20 rows × 22 columns

By features

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

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

feature_type = db.Feature.get(name="mini_immuno")
perturbation = db.Feature.get(name="perturbation", type=feature_type)
temperature = db.Feature.get(name="temperature")
db.Artifact.filter(
    perturbation == "DMSO",
    temperature > 21,
).to_dataframe(include="features")

Show code cell output Hide code cell output

	uid	key	perturbation	cell_type_by_model	assay_oid	temperature
id
11925	AsTXi6hzDFM7L17t0003	examples/mini_immuno_with_single_typo.parquet	{DMSO, IFNG}	{T cell, B cell}	EFO:0008913	21.6

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

db.Artifact.filter(perturbation.is_null(False)).to_dataframe(include="features")

Show code cell output Hide code cell output

	uid	key	perturbation	cell_type_by_model	assay_oid	temperature
id
11925	AsTXi6hzDFM7L17t0003	examples/mini_immuno_with_single_typo.parquet	{DMSO, IFNG}	{T cell, B cell}	EFO:0008913	21.6

Cheat sheet: comparators

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

and

db.Artifact.filter(suffix=".h5ad", records=experiment_1).to_dataframe()

Show code cell output Hide code cell output

	uid	id	key	description	suffix	kind	otype	size	hash	n_files	...	is_latest	is_locked	created_at	branch_id	created_on_id	space_id	storage_id	run_id	schema_id	created_by_id

0 rows × 23 columns

less than/ greater than

# artifacts greater than 10kB
db.Artifact.filter(size__gt=1e4).to_dataframe()

Show code cell output Hide code cell output

! truncated query result to limit=20 Artifact objects

	uid	key	description	suffix	kind	otype	size	hash	n_files	n_observations	...	is_latest	is_locked	created_at	branch_id	created_on_id	space_id	storage_id	run_id	schema_id	created_by_id
id
25496	TMRsx3ZV9xcMdj370000	test/agent-trace.jsonl	None	.jsonl	None	None	36065	T6fTmwdaMZmJagO9P_rIzg	None	NaN	...	True	False	2026-07-03 13:42:48.760793+00:00	1	1	1	2	NaN	NaN	9
25493	IEDEe8XxiD7gBucS0000	falexwolf/adhoc/artifact-type-summary.png	None	.png	None	None	79206	pMmOCGMk_7DI9v8JMUrlFA	None	NaN	...	True	False	2026-07-03 13:35:00.201612+00:00	1	57	1	2	10049.0	NaN	9
23733	yYEzVuSqYNyPoaAj0001	datasets/conde22.h5ad	None	.h5ad	dataset	AnnData	57612943	IigmJRzBsUHoKZUw22IUXk	None	1648.0	...	True	False	2026-06-03 05:09:47.703098+00:00	1	1	1	2	NaN	151.0	60
23728	v2CSc7bGTUgdlHeA0000	None	Curated bulk RNA counts	.h5ad	dataset	AnnData	28180	6bieh8XjOCCz6bJToN4u1g	None	5.0	...	True	False	2026-06-03 04:50:49.438844+00:00	1	1	1	2	NaN	216.0	60
23623	siAj6EUthWF8gs2S0000	temp/output/fetchngs/fastq/SRX9315476_SRR12848...	Output artifact for run 8541	.fastq.gz	dataset	None	123467	A_WjRYau-c1h9U6yaDGmZQ	None	NaN	...	True	False	2026-06-01 09:38:35.976330+00:00	1	1	1	59	8541.0	NaN	54
23622	F9Tn8DfxnBPGtssK0000	temp/output/fetchngs/fastq/SRX9315476_SRR12848...	Output artifact for run 8541	.fastq.gz	dataset	None	131539	l3AcXYhK-NlrqV1yN_O_eQ	None	NaN	...	True	False	2026-06-01 09:38:31.103701+00:00	1	1	1	59	8541.0	NaN	54
23617	1YEM2Tzio0JpaPke0000	temp/output/fetchngs/fastq/SRX9504942_SRR13055...	Output artifact for run 8541	.fastq.gz	dataset	None	714907	WtUUYMbEqFDdN6IG4sRBwQ	None	NaN	...	True	False	2026-06-01 09:37:53.956200+00:00	1	1	1	59	8541.0	NaN	54
23616	8DhYtWgZJO545TJo0000	temp/output/fetchngs/fastq/SRX9504942_SRR13055...	Output artifact for run 8541	.fastq.gz	dataset	None	721705	qXc2e_QdrPTCG8DIIBuLiA	None	NaN	...	True	False	2026-06-01 09:37:39.002608+00:00	1	1	1	59	8541.0	NaN	54
23615	NgZujyEK9KmFMlFK0000	temp/output/fetchngs/fastq/SRX9504942_SRR13055...	Output artifact for run 8541	.fastq.gz	dataset	None	717693	XsiU2GP87-OURwoJJa795A	None	NaN	...	True	False	2026-06-01 09:37:29.243127+00:00	1	1	1	59	8541.0	NaN	54
23614	rLzlXSOpP8o1piIs0000	temp/output/fetchngs/fastq/SRX9504942_SRR13055...	Output artifact for run 8541	.fastq.gz	dataset	None	716862	w_NDeTVrKNbaxyEqvBoKBA	None	NaN	...	True	False	2026-06-01 09:37:24.188066+00:00	1	1	1	59	8541.0	NaN	54
23613	3ZaqjSNEoKh6oFhd0000	temp/output/fetchngs/fastq/SRX9504942_SRR13055...	Output artifact for run 8541	.fastq.gz	dataset	None	723429	rq0XDfmFF3PVICtXYMdtdg	None	NaN	...	True	False	2026-06-01 09:37:19.907708+00:00	1	1	1	59	8541.0	NaN	54
23612	bsdimhTQzRM2o8yw0000	temp/output/fetchngs/fastq/SRX9504942_SRR13055...	Output artifact for run 8541	.fastq.gz	dataset	None	723753	GNvpbn9YtjQG2QWJON8ZYg	None	NaN	...	True	False	2026-06-01 09:37:15.705903+00:00	1	1	1	59	8541.0	NaN	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	NaN	...	True	False	2026-06-01 09:37:09.722288+00:00	1	1	1	59	8541.0	NaN	54
23610	WjmuV1mc8tQC91p60000	temp/output/fetchngs/fastq/SRX9504942_SRR13055...	Output artifact for run 8541	.fastq.gz	dataset	None	721167	3PRDjAtoIkLukMXzqAP7QA	None	NaN	...	True	False	2026-06-01 09:37:04.398585+00:00	1	1	1	59	8541.0	NaN	54
23609	BgqbFQuLmJbpmZ980000	temp/output/fetchngs/fastq/SRX6725035_SRR99841...	Output artifact for run 8541	.fastq.gz	dataset	None	605358	C1EtLcMWhZg0Vr1W_YNlRA	None	NaN	...	True	False	2026-06-01 09:36:57.774141+00:00	1	1	1	59	8541.0	NaN	54
23608	n8fhOhvOk2JN5QAH0000	temp/output/fetchngs/fastq/DRX024467_DRR026872...	Output artifact for run 8541	.fastq.gz	dataset	None	38447	UV5USMVeBUETxKIt9fYnkQ	None	NaN	...	True	False	2026-06-01 09:36:53.310799+00:00	1	1	1	59	8541.0	NaN	54
23607	BvcOjWC5ErBlEyw40000	temp/output/fetchngs/fastq/SRX9626017_SRR13191...	Output artifact for run 8541	.fastq.gz	dataset	None	16324	Vicb44qA23jvO9_F2ZCbmA	None	NaN	...	True	False	2026-06-01 09:36:48.813406+00:00	1	1	1	59	8541.0	NaN	54
23606	kTx9UdwTAFjY5VpB0000	temp/output/fetchngs/fastq/SRX9626017_SRR13191...	Output artifact for run 8541	.fastq.gz	dataset	None	15420	icW-kgAhoDUITYrrdPMt9w	None	NaN	...	True	False	2026-06-01 09:36:44.866169+00:00	1	1	1	59	8541.0	NaN	54
23605	jcsGrRR4E7UXvUjv0000	temp/output/fetchngs/fastq/ERX1234253_ERR11608...	Output artifact for run 8541	.fastq.gz	dataset	None	18077	WSTyDvVH69_tfK15W7q25g	None	NaN	...	True	False	2026-06-01 09:36:05.779736+00:00	1	1	1	59	8541.0	NaN	54
23604	0fznQ2Jc0ttK94cU0000	temp/output/fetchngs/fastq/DRX026011_DRR028935...	Output artifact for run 8541	.fastq.gz	dataset	None	61610	lByZmNdGQW2tU8lMSA3fMA	None	NaN	...	True	False	2026-06-01 09:35:42.557319+00:00	1	1	1	59	8541.0	NaN	54

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
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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	None	54
23603	S8IbfSILr9RGgtWf0000	temp/output/fetchngs/fastq/DRX026011_DRR028935...	Output artifact for run 8541	.fastq.gz	dataset	None	60275	zAHfgqk1S7azvpNIOyDDWg	None	None	...	True	False	2026-06-01 09:35:19.711304+00:00	1	1	1	59	8541	None	54

20 rows × 22 columns

order by

db.Artifact.filter().order_by("created_at").to_dataframe()

Show code cell output 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
25696	Q2gXw8D0zkP86n7C0000	None	My favorite protein sequence (GFP)	.fasta	None	None	273	42yLTIs-Wu-Sq_gzdXJgZg	None	NaN	...	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	NaN	...	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	NaN	...	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	NaN	...	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	NaN	...	True	False	2026-07-05 14:57:02.553598+00:00	1	1	1	2	10182.0	None	18
25496	TMRsx3ZV9xcMdj370000	test/agent-trace.jsonl	None	.jsonl	None	None	36065	T6fTmwdaMZmJagO9P_rIzg	None	NaN	...	True	False	2026-07-03 13:42:48.760793+00:00	1	1	1	2	NaN	None	9
25493	IEDEe8XxiD7gBucS0000	falexwolf/adhoc/artifact-type-summary.png	None	.png	None	None	79206	pMmOCGMk_7DI9v8JMUrlFA	None	NaN	...	True	False	2026-07-03 13:35:00.201612+00:00	1	57	1	2	10049.0	None	9
25491	OKMb2f9CBlGmRnOo0000	.plans/lamindata_artifact_summary_3679bd17.pla...	Create a notebook in `/Users/falexwolf/work/db...	.md	plan	None	2451	Nkp7iaGLGZwx4X26KZBGRA	None	NaN	...	True	False	2026-07-03 13:29:14.431662+00:00	1	57	1	2	10050.0	None	9
25063	MdvQpu992LjdLxNz0000	examples/mini_immuno_dataset1_with_typo.parquet	None	.parquet	dataset	DataFrame	9868	AxcqEowD5buTwzecXLVykA	None	3.0	...	True	False	2026-06-25 08:45:16.007021+00:00	1	1	1	2	9697.0	None	9
24890	BFfIHO5w8WPUywgR0000	None	My favorite protein sequence (Ubiquitin)	.fasta	None	None	156	xkHNV8nXb_IkgII2o7rqkw	None	NaN	...	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	NaN	...	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	NaN	...	True	False	2026-06-22 20:02:45.048795+00:00	1	1	1	2	9514.0	None	18
24689	Za9BV8mzLDxSNHoX0000	None	My favorite protein sequence (GFP)	.fasta	None	None	273	mcksul1N3dPAwqc95m0oiQ	None	NaN	...	True	False	2026-06-20 15:04:57.255099+00:00	1	1	1	2	9413.0	None	18
24685	wOwpbTvyue614wZP0000	None	Favorite protein sequence: Green Fluorescent P...	.fasta	None	None	302	FmlEFaBamN7gJNr3RzJsAw	None	NaN	...	True	False	2026-06-20 14:38:23.286709+00:00	1	1	1	2	9411.0	None	18
24676	AhD9v9CkvGxaHmRy0000	None	My favorite protein sequence (Ubiquitin)	.fasta	None	None	88	kAKsQi91nh4onb9Qg2wtNA	None	NaN	...	True	False	2026-06-20 08:07:33.784419+00:00	1	1	1	2	9407.0	None	18
24445	ML3sGjDVygvTErE00000	None	Favorite protein sequence (Green Fluorescent P...	.fasta	None	None	273	Z00XLvk9cGTelGzaM4bRwg	None	NaN	...	True	False	2026-06-15 23:25:29.225893+00:00	1	1	1	2	9223.0	None	18
24135	9nbQYEH7U1HPdClv0000	test_upload_2026-06-09T15-12-54-335Z.csv	None	.csv	None	DataFrame	926	L7-Gyxhb4-yPSFJtFsXI2A	None	NaN	...	True	False	2026-06-09 15:13:40.673436+00:00	1	1	1	2	NaN	None	46
24131	shcxkM3Gki4yvh2I0000	None	Green Fluorescent Protein (GFP) sequence FASTA	.fasta	None	None	336	RGWiZh_NYC0Ga8uiQOu2HQ	None	NaN	...	True	False	2026-06-09 10:36:45.008085+00:00	1	1	1	2	NaN	None	60
24130	JghFkzKE67sVAN2X0000	None	Green fluorescent protein (GFP) sequence	.fasta	None	None	270	xma0rkIdVZw2zlccMDyFZg	None	NaN	...	True	False	2026-06-09 10:35:56.107098+00:00	1	1	1	2	9564.0	None	60
24129	lu8vvjlLy4Lk6fbw0000	None	GFP protein sequence FASTA file	.fasta	None	None	272	IeGHuYx7Mxi2TMkgUHCaxg	None	NaN	...	True	False	2026-06-09 09:56:28.195455+00:00	1	1	1	2	NaN	None	60

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
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
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
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
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
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
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
24676	AhD9v9CkvGxaHmRy0000	None	My favorite protein sequence (Ubiquitin)	.fasta	None	None	88	kAKsQi91nh4onb9Qg2wtNA	None	None	...	True	False	2026-06-20 08:07:33.784419+00:00	1	1	1	2	9407.0	None	18
24685	wOwpbTvyue614wZP0000	None	Favorite protein sequence: Green Fluorescent P...	.fasta	None	None	302	FmlEFaBamN7gJNr3RzJsAw	None	None	...	True	False	2026-06-20 14:38:23.286709+00:00	1	1	1	2	9411.0	None	18
24689	Za9BV8mzLDxSNHoX0000	None	My favorite protein sequence (GFP)	.fasta	None	None	273	mcksul1N3dPAwqc95m0oiQ	None	None	...	True	False	2026-06-20 15:04:57.255099+00:00	1	1	1	2	9413.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
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
24445	ML3sGjDVygvTErE00000	None	Favorite protein sequence (Green Fluorescent P...	.fasta	None	None	273	Z00XLvk9cGTelGzaM4bRwg	None	None	...	True	False	2026-06-15 23:25:29.225893+00:00	1	1	1	2	9223.0	None	18
24097	AkE1Wa5V74f6kA0d0000	None	Protein FASTA file containing Human Insulin, H...	.fasta	None	None	485	iL0fZbocxHNB0YyEKaYf3w	None	None	...	True	False	2026-06-08 19:54:33.814789+00:00	1	1	1	2	8945.0	None	60
24100	Bwf9craFmJUehFkK0000	None	GFP protein sequence in FASTA format	.fasta	None	None	272	qVMXZSDoLWyg5IQEoxJCQA	None	None	...	True	False	2026-06-08 20:09:50.975188+00:00	1	1	1	2	8947.0	None	60
24103	AZXckti4rpSKkaMV0000	None	Human Insulin precursor protein sequence (FASTA)	.fasta	None	None	182	z-atptA_X3mMrS0Vw-Gbyg	None	None	...	True	False	2026-06-08 20:46:50.083998+00:00	1	1	1	2	NaN	None	60
24126	TpWa7724IpOFVFsZ0000	None	GFP protein sequence FASTA file	.fasta	None	None	273	fLSlDTQwGrLPlzkKEpem_g	None	None	...	True	False	2026-06-09 09:47:53.780326+00:00	1	1	1	2	8970.0	None	60
24129	lu8vvjlLy4Lk6fbw0000	None	GFP protein sequence FASTA file	.fasta	None	None	272	IeGHuYx7Mxi2TMkgUHCaxg	None	None	...	True	False	2026-06-09 09:56:28.195455+00:00	1	1	1	2	NaN	None	60
24131	shcxkM3Gki4yvh2I0000	None	Green Fluorescent Protein (GFP) sequence FASTA	.fasta	None	None	336	RGWiZh_NYC0Ga8uiQOu2HQ	None	None	...	True	False	2026-06-09 10:36:45.008085+00:00	1	1	1	2	NaN	None	60
24130	JghFkzKE67sVAN2X0000	None	Green fluorescent protein (GFP) sequence	.fasta	None	None	270	xma0rkIdVZw2zlccMDyFZg	None	None	...	True	False	2026-06-09 10:35:56.107098+00:00	1	1	1	2	9564.0	None	60
23727	LIHC4iDu4ZdhFk1A0000	None	Merged Bulk RNA counts	.tsv	None	None	3787	xxw0k3au3KtxFcgtbEr4eQ	None	None	...	True	False	2026-06-03 04:50:46.166807+00:00	1	1	1	2	NaN	None	60

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
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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	None	54
23603	S8IbfSILr9RGgtWf0000	temp/output/fetchngs/fastq/DRX026011_DRR028935...	Output artifact for run 8541	.fastq.gz	dataset	None	60275	zAHfgqk1S7azvpNIOyDDWg	None	None	...	True	False	2026-06-01 09:35:19.711304+00:00	1	1	1	59	8541	None	54

20 rows × 22 columns

negate/ unequal

db.Artifact.filter(~ln.Q(suffix=".jpg")).to_dataframe()

Show code cell output 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
25696	Q2gXw8D0zkP86n7C0000	None	My favorite protein sequence (GFP)	.fasta	None	None	273	42yLTIs-Wu-Sq_gzdXJgZg	None	NaN	...	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	NaN	...	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	NaN	...	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	NaN	...	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	NaN	...	True	False	2026-07-05 14:57:02.553598+00:00	1	1	1	2	10182.0	None	18
25496	TMRsx3ZV9xcMdj370000	test/agent-trace.jsonl	None	.jsonl	None	None	36065	T6fTmwdaMZmJagO9P_rIzg	None	NaN	...	True	False	2026-07-03 13:42:48.760793+00:00	1	1	1	2	NaN	None	9
25493	IEDEe8XxiD7gBucS0000	falexwolf/adhoc/artifact-type-summary.png	None	.png	None	None	79206	pMmOCGMk_7DI9v8JMUrlFA	None	NaN	...	True	False	2026-07-03 13:35:00.201612+00:00	1	57	1	2	10049.0	None	9
25491	OKMb2f9CBlGmRnOo0000	.plans/lamindata_artifact_summary_3679bd17.pla...	Create a notebook in `/Users/falexwolf/work/db...	.md	plan	None	2451	Nkp7iaGLGZwx4X26KZBGRA	None	NaN	...	True	False	2026-07-03 13:29:14.431662+00:00	1	57	1	2	10050.0	None	9
25063	MdvQpu992LjdLxNz0000	examples/mini_immuno_dataset1_with_typo.parquet	None	.parquet	dataset	DataFrame	9868	AxcqEowD5buTwzecXLVykA	None	3.0	...	True	False	2026-06-25 08:45:16.007021+00:00	1	1	1	2	9697.0	None	9
24890	BFfIHO5w8WPUywgR0000	None	My favorite protein sequence (Ubiquitin)	.fasta	None	None	156	xkHNV8nXb_IkgII2o7rqkw	None	NaN	...	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	NaN	...	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	NaN	...	True	False	2026-06-22 20:02:45.048795+00:00	1	1	1	2	9514.0	None	18
24689	Za9BV8mzLDxSNHoX0000	None	My favorite protein sequence (GFP)	.fasta	None	None	273	mcksul1N3dPAwqc95m0oiQ	None	NaN	...	True	False	2026-06-20 15:04:57.255099+00:00	1	1	1	2	9413.0	None	18
24685	wOwpbTvyue614wZP0000	None	Favorite protein sequence: Green Fluorescent P...	.fasta	None	None	302	FmlEFaBamN7gJNr3RzJsAw	None	NaN	...	True	False	2026-06-20 14:38:23.286709+00:00	1	1	1	2	9411.0	None	18
24676	AhD9v9CkvGxaHmRy0000	None	My favorite protein sequence (Ubiquitin)	.fasta	None	None	88	kAKsQi91nh4onb9Qg2wtNA	None	NaN	...	True	False	2026-06-20 08:07:33.784419+00:00	1	1	1	2	9407.0	None	18
24445	ML3sGjDVygvTErE00000	None	Favorite protein sequence (Green Fluorescent P...	.fasta	None	None	273	Z00XLvk9cGTelGzaM4bRwg	None	NaN	...	True	False	2026-06-15 23:25:29.225893+00:00	1	1	1	2	9223.0	None	18
24135	9nbQYEH7U1HPdClv0000	test_upload_2026-06-09T15-12-54-335Z.csv	None	.csv	None	DataFrame	926	L7-Gyxhb4-yPSFJtFsXI2A	None	NaN	...	True	False	2026-06-09 15:13:40.673436+00:00	1	1	1	2	NaN	None	46
24131	shcxkM3Gki4yvh2I0000	None	Green Fluorescent Protein (GFP) sequence FASTA	.fasta	None	None	336	RGWiZh_NYC0Ga8uiQOu2HQ	None	NaN	...	True	False	2026-06-09 10:36:45.008085+00:00	1	1	1	2	NaN	None	60
24130	JghFkzKE67sVAN2X0000	None	Green fluorescent protein (GFP) sequence	.fasta	None	None	270	xma0rkIdVZw2zlccMDyFZg	None	NaN	...	True	False	2026-06-09 10:35:56.107098+00:00	1	1	1	2	9564.0	None	60
24129	lu8vvjlLy4Lk6fbw0000	None	GFP protein sequence FASTA file	.fasta	None	None	272	IeGHuYx7Mxi2TMkgUHCaxg	None	NaN	...	True	False	2026-06-09 09:56:28.195455+00:00	1	1	1	2	NaN	None	60

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.