Query & search ¶

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

Basics¶

Create a database object:

import lamindb as ln

db = ln.DB("laminlabs/lamindata")

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
29722	pwSp3LRvGTVBoUzp0000	docs/tiger-image-from-artifact.md	Markdown document that references the LaminDB ...	.md	NaN	NaN	244	YV_4olsNLPyEB4TEzB3ppQ	None	NaN	...	True	False	2026-08-12 15:16:21.077462+00:00	746	746	1	2	13023.0	None	46
29720	dG99VzWpyE6FkSWJ0000	images/tiger-from-wikipedia.jpg	Tiger image downloaded from Wikipedia (Tiger p...	.jpg	NaN	NaN	2540281	2HP9xODrLvtBwtPFouqE_Q	None	NaN	...	True	False	2026-08-12 15:16:02.091955+00:00	746	746	1	2	13022.0	None	46
29676	QIKiDBZTSpmEhkOo0000	NaN	Embedded asset	.png	__easset__	NaN	306117	FowJyxPuUJwhghAAm2Y5UQ	None	NaN	...	True	False	2026-08-12 09:37:35.546038+00:00	1	1	1	2	NaN	None	46
29638	netjbvlUnXwbW1r10000	images/crab-from-wikipedia.jpg	Crab image downloaded from Wikipedia.	.jpg	NaN	NaN	2463676	KiyPVJMWBaWGWqvrJild-A	None	NaN	...	True	False	2026-08-11 18:29:58.930596+00:00	746	746	1	2	12959.0	None	46
29634	0y8hZylRr9PFxgkg0000	docs/cell-image-from-artifact.md	Markdown document that references the LaminDB ...	.md	NaN	NaN	240	qwCc-VL4GWXhILqRb7MWcg	None	NaN	...	True	False	2026-08-11 18:22:29.588403+00:00	746	746	1	2	12957.0	None	46
29632	GW6Extqggjv5qper0000	images/cell-from-wikipedia.jpg	Cell image downloaded from Wikipedia (Cell bio...	.jpg	NaN	NaN	56634	YNagT97mHAyl5RYtR22vKA	None	NaN	...	True	False	2026-08-11 18:21:27.783202+00:00	746	746	1	2	12956.0	None	46
29627	W1Mx5j5gk9yIjrON0000	tmp/lamin-test-file.txt	tmp test	.txt	NaN	NaN	1	ndTkYSaMgDT1yFZOFVxnpg	None	NaN	...	True	False	2026-08-11 18:16:46.183741+00:00	746	746	1	2	NaN	None	46
29612	4MP8fmwelTNty52u0000	scanpy-k-dense/reports/pbmc3k_analysis_report....	PBMC3k scRNA-seq analysis report: intro, metho...	.html	NaN	NaN	3781127	iFkWVI8jXemt28l5j9MSqw	None	NaN	...	True	False	2026-08-11 09:50:17.364594+00:00	747	747	1	2	12861.0	None	2
29611	rZDkpZoNs5StsUV40000	scanpy-k-dense/figures/heatmap_markers_heatmap...	PBMC3k top-10 marker heatmap per Leiden cluste...	.png	NaN	NaN	214886	ZKGWFLJCC6vJVsdl4NDgNQ	None	NaN	...	True	False	2026-08-11 09:39:54.952131+00:00	747	747	1	2	12864.0	None	2
29604	3c3xD2NjSmqnF71S0000	examples/squares_1_to_10_sum.parquet	Sum of squares for integers 1 through 10	.parquet	dataset	DataFrame	1704	qRuYNcZ69xOB-6Eg-LSuFQ	None	1.0	...	True	False	2026-08-11 09:09:23.736644+00:00	1	1	1	2	12940.0	None	76
29601	PtALuKQKI2kalopb0000	examples/squares_1_to_10.parquet	Squares of integers from 1 through 10	.parquet	dataset	DataFrame	2284	PgOVDz6mUqBPMF04XWUoGQ	None	10.0	...	True	False	2026-08-11 09:05:55.611943+00:00	1	1	1	2	12938.0	None	76
29586	j98197IgEfZ432uq0000	weather/reports/berlin_weather_report.txt	Text report for Berlin weather forecast summar...	.txt	NaN	NaN	324	pWI23e-Vnei8LBBzeRz_bw	None	NaN	...	True	False	2026-08-11 08:31:50.720714+00:00	746	746	1	2	12912.0	None	46
29585	ma5bE8CThDTMu69p0000	weather/reports/berlin_weather_summary.csv	Summary statistics from the Berlin hourly weat...	.csv	dataset	DataFrame	196	CL3skIfe-dnAfYwCH-xIYg	None	7.0	...	True	False	2026-08-11 08:31:49.604786+00:00	746	746	1	2	12912.0	None	46
29583	Y4lEQ5m2hxLdi9WV0000	weather/berlin_hourly_forecast.csv	Berlin hourly weather forecast data from Open-...	.csv	dataset	DataFrame	1817	4G4GbJZ_hra_q4rK9DJufw	None	48.0	...	True	False	2026-08-11 08:30:59.993445+00:00	746	746	1	2	12911.0	None	46
29540	uJxDt2T8mUKXFk790000	scanpy-k-dense/figures/umap_final_clusters.png	PBMC3k UMAP coloured by Leiden cluster (res 1.0)	.png	NaN	NaN	48363	5s1qUBmNO4mshYhkqbZ5xg	None	NaN	...	True	False	2026-08-10 16:45:39.871034+00:00	747	747	1	2	12868.0	None	2
29539	KiwA9mcKeB7xPe7a0001	scanpy-k-dense/figures/umap_final_celltypes.png	PBMC3k UMAP coloured by annotated cell type	.png	NaN	NaN	73127	Lw5Y-ahOtmVc-0ufBwmdSQ	None	NaN	...	True	False	2026-08-10 16:45:38.126552+00:00	747	747	1	2	12868.0	None	2
29537	4pDl0lkIznRkJG9m0000	scanpy-k-dense/figures/heatmap_final_celltype_...	PBMC3k marker expression heatmap per cell type	.png	NaN	NaN	127029	M8l_aBZwgPdB31n1lYr1AA	None	NaN	...	True	False	2026-08-10 16:44:24.605805+00:00	747	747	1	2	12868.0	None	2
29536	ciwvOnL26cpDhgVp0000	scanpy-k-dense/figures/umap_final_markers.png	PBMC3k UMAP grid of canonical lineage markers	.png	NaN	NaN	675081	4rTD6BTXSeSzbwYwPQRi5Q	None	NaN	...	True	False	2026-08-10 16:44:22.976624+00:00	747	747	1	2	12868.0	None	2
29533	kPvqrtnIMuqXRGrr0000	scanpy-k-dense/figures/dotplot_celltype_marker...	PBMC3k defining markers per annotated cell type	.png	NaN	NaN	190224	kEhTy4QVLQrHZh7AuIcUOQ	None	NaN	...	True	False	2026-08-10 16:39:07.436940+00:00	747	747	1	2	12866.0	None	2
29532	WaHCDK4VOek5POfH0000	scanpy-k-dense/figures/umap_celltypes.png	PBMC3k UMAP coloured by annotated cell type	.png	NaN	NaN	67134	Ip2kCU5m6iOY5a4OZzdtGA	None	NaN	...	True	False	2026-08-10 16:39:06.316867+00:00	747	747	1	2	12866.0	None	2

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
29722	pwSp3LRvGTVBoUzp0000	docs/tiger-image-from-artifact.md	sheetalgiri
29720	dG99VzWpyE6FkSWJ0000	images/tiger-from-wikipedia.jpg	sheetalgiri
29676	QIKiDBZTSpmEhkOo0000	NaN	sheetalgiri
29638	netjbvlUnXwbW1r10000	images/crab-from-wikipedia.jpg	sheetalgiri
29634	0y8hZylRr9PFxgkg0000	docs/cell-image-from-artifact.md	sheetalgiri
29632	GW6Extqggjv5qper0000	images/cell-from-wikipedia.jpg	sheetalgiri
29627	W1Mx5j5gk9yIjrON0000	tmp/lamin-test-file.txt	sheetalgiri
29612	4MP8fmwelTNty52u0000	scanpy-k-dense/reports/pbmc3k_analysis_report....	sunnyosun
29611	rZDkpZoNs5StsUV40000	scanpy-k-dense/figures/heatmap_markers_heatmap...	sunnyosun
29604	3c3xD2NjSmqnF71S0000	examples/squares_1_to_10_sum.parquet	ebad
29601	PtALuKQKI2kalopb0000	examples/squares_1_to_10.parquet	ebad
29586	j98197IgEfZ432uq0000	weather/reports/berlin_weather_report.txt	sheetalgiri
29585	ma5bE8CThDTMu69p0000	weather/reports/berlin_weather_summary.csv	sheetalgiri
29583	Y4lEQ5m2hxLdi9WV0000	weather/berlin_hourly_forecast.csv	sheetalgiri
29540	uJxDt2T8mUKXFk790000	scanpy-k-dense/figures/umap_final_clusters.png	sunnyosun
29539	KiwA9mcKeB7xPe7a0001	scanpy-k-dense/figures/umap_final_celltypes.png	sunnyosun
29537	4pDl0lkIznRkJG9m0000	scanpy-k-dense/figures/heatmap_final_celltype_...	sunnyosun
29536	ciwvOnL26cpDhgVp0000	scanpy-k-dense/figures/umap_final_markers.png	sunnyosun
29533	kPvqrtnIMuqXRGrr0000	scanpy-k-dense/figures/dotplot_celltype_marker...	sunnyosun
29532	WaHCDK4VOek5POfH0000	scanpy-k-dense/figures/umap_celltypes.png	sunnyosun

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
29722	pwSp3LRvGTVBoUzp0000	docs/tiger-image-from-artifact.md	Markdown document that references the LaminDB ...	.md	NaN	None	244	YV_4olsNLPyEB4TEzB3ppQ	None	None	...	True	False	2026-08-12 15:16:21.077462+00:00	746	746	1	2	13023.0	None	46
29720	dG99VzWpyE6FkSWJ0000	images/tiger-from-wikipedia.jpg	Tiger image downloaded from Wikipedia (Tiger p...	.jpg	NaN	None	2540281	2HP9xODrLvtBwtPFouqE_Q	None	None	...	True	False	2026-08-12 15:16:02.091955+00:00	746	746	1	2	13022.0	None	46
29676	QIKiDBZTSpmEhkOo0000	NaN	Embedded asset	.png	__easset__	None	306117	FowJyxPuUJwhghAAm2Y5UQ	None	None	...	True	False	2026-08-12 09:37:35.546038+00:00	1	1	1	2	NaN	None	46
29638	netjbvlUnXwbW1r10000	images/crab-from-wikipedia.jpg	Crab image downloaded from Wikipedia.	.jpg	NaN	None	2463676	KiyPVJMWBaWGWqvrJild-A	None	None	...	True	False	2026-08-11 18:29:58.930596+00:00	746	746	1	2	12959.0	None	46
29634	0y8hZylRr9PFxgkg0000	docs/cell-image-from-artifact.md	Markdown document that references the LaminDB ...	.md	NaN	None	240	qwCc-VL4GWXhILqRb7MWcg	None	None	...	True	False	2026-08-11 18:22:29.588403+00:00	746	746	1	2	12957.0	None	46
29632	GW6Extqggjv5qper0000	images/cell-from-wikipedia.jpg	Cell image downloaded from Wikipedia (Cell bio...	.jpg	NaN	None	56634	YNagT97mHAyl5RYtR22vKA	None	None	...	True	False	2026-08-11 18:21:27.783202+00:00	746	746	1	2	12956.0	None	46
29627	W1Mx5j5gk9yIjrON0000	tmp/lamin-test-file.txt	tmp test	.txt	NaN	None	1	ndTkYSaMgDT1yFZOFVxnpg	None	None	...	True	False	2026-08-11 18:16:46.183741+00:00	746	746	1	2	NaN	None	46

7 rows × 22 columns

Collection

	uid	key	description	hash	reference	reference_type	version_tag	is_latest	is_locked	created_at	branch_id	created_on_id	space_id	created_by_id	run_id	schema_id	meta_artifact_id
id
55	cqukvOra6GNNB71W0Llw	collection-with-schema	Empty collection with a direct schema relation...	NaN	None	None	None	True	False	2026-07-29 22:29:08.441329+00:00	1	1	1	20	NaN	229.0	None
53	br3wYkh6hnAvlLdo0000	csv_uploads_collection	A collection of uploaded CSV samples	zvW2xO8dU8whNb6COP34Qw	None	None	None	True	False	2026-07-09 14:39:05.994080+00:00	3	3	1	46	NaN	NaN	None
52	okxPW6GIKBfRBE3B0001	scrna/collection1	NaN	jKzNshNzE7IkXgRG17rj4A	None	None	None	True	False	2026-06-03 05:10:43.531698+00:00	1	1	1	60	NaN	NaN	None
51	DMF53hCJZQdnVIzT0000	View PAS OME-TIFF, Neumann et al., 2020 in Vit...	NaN	vpleElXxZiaZblQ09q9K-g	None	None	None	True	False	2026-01-28 23:40:21.984321+00:00	1	1	1	18	2250.0	NaN	None
50	H1AlT19wFq7HdHqZ0000	View Habib17 (h5ad) in Vitessce	NaN	hmrSAi0jDsrxvo9Oy3Hiqg	None	None	None	True	False	2026-01-20 20:28:39.313883+00:00	1	1	1	18	1934.0	NaN	None
49	p46U2L7tUlotAAkI0000	View Xenium_V1_humanLung_Cancer_FFPE_he_image ...	NaN	KuLnVec2HsgUIbl0fcTXdQ	None	None	None	True	False	2026-01-14 14:32:16.517376+00:00	1	1	1	40	NaN	NaN	None
46	mySQPfapuYs3ABLC0000	fasta-test-output-collection-2	NaN	QUraKB3k9PERvsRza4ycCQ	None	None	None	True	False	2025-11-30 22:35:25.029942+00:00	1	1	1	9	1591.0	NaN	None

Feature

	uid	name	_dtype_str	unit	description	array_rank	array_size	array_shape	synonyms	default_value	...	coerce	is_locked	is_type	created_at	branch_id	created_on_id	space_id	created_by_id	run_id	type_id
id
712	F0ppq3tGFJMc	feature_is_filtered	bool	None	NaN	0	0	None	None	None	...	None	False	False	2026-08-06 04:39:31.395798+00:00	1	1	1	60	12577.0	NaN
711	lNF0TWgo5d9B	var_index	cat[bionty.Gene.ensembl_gene_id[source__uid='4...	None	NaN	0	0	None	None	None	...	None	False	False	2026-08-06 04:39:31.050543+00:00	1	1	1	60	12577.0	NaN
710	P35oSvVjfhTs	codex_collection_schema_feature_20260729	str	None	NaN	0	1	None	None	None	...	None	False	False	2026-07-29 22:28:37.587956+00:00	1	1	1	20	NaN	NaN
709	mIWTishnUfBD	1000_genomes_cnv_vcf	NaN	None	NaN	0	0	None	None	None	...	None	False	True	2026-07-27 09:23:55.835590+00:00	1	1	1	9	NaN	NaN
708	iBNQ2DyRdRMY	workflow_status	cat	None	The execution status of the Nextflow testing w...	0	0	None	None	None	...	None	False	False	2026-07-09 14:43:34.246479+00:00	3	3	1	46	NaN	NaN
701	YKDqA94Mc3pV	bench-record-id	str	None	NaN	0	0	None	None	None	...	None	False	False	2026-06-29 10:00:37.486448+00:00	1	1	1	60	9802.0	NaN
700	C8YiQhwwrE5L	donor_ethnicity	list[cat[bionty.Ethnicity]]	None	NaN	0	0	None	None	None	...	None	False	False	2026-06-23 14:50:03.557222+00:00	1	1	1	9	9591.0	692.0

7 rows × 21 columns

Project

	uid	name	description	abbr	url	start_date	end_date	is_locked	is_type	created_at	branch_id	created_on_id	space_id	created_by_id	run_id	type_id
id
77	f71hDEwbOjqx	Space debugging	None	None	None	None	None	False	False	2026-08-06 09:45:28.864762+00:00	1	1	1	60	None	None
76	LtcVwm68sZo2	Space debugging test	None	None	None	None	None	False	True	2026-08-06 09:38:55.797287+00:00	-1	1	1	60	None	None
74	KrzaeLA1wPV1	Program Type	None	None	None	None	None	False	True	2026-08-06 09:24:11.347019+00:00	1	1	1	60	None	None
73	dLGPJoG8TQhd	Space debugging	None	None	None	None	None	False	True	2026-08-06 09:18:32.052879+00:00	-1	1	1	60	None	None
72	EFqukxydbjPD	SIS-2923	None	None	None	None	None	False	False	2026-08-06 08:52:55.166487+00:00	1	1	1	60	None	None
68	OTJ4lkLJhiUW	debugging	None	None	None	None	None	False	False	2026-08-05 12:39:13.510196+00:00	1	1	1	60	None	None
67	SKxRMsUdnW5g	nf-lamin-showcase	None	None	None	None	None	False	False	2026-07-22 14:25:08.788355+00:00	1	1	1	54	None	None

Record

	uid	name	description	reference	reference_type	extra_data	is_locked	is_type	created_at	branch_id	created_on_id	space_id	created_by_id	type_id	schema_id	run_id
id
74202	Lj1Gbi886GCxiSeR	None	None	None	None	None	False	False	2026-08-12 13:40:54.998341+00:00	1	1	1	18	2759	None	13011
74201	R6UFYnS6YoxolxJH	None	None	None	None	None	False	False	2026-08-12 13:40:39.002747+00:00	1	1	1	18	611	None	13010
74200	oFsoc4iHf6cqtmAB	None	None	None	None	None	False	False	2026-08-12 13:40:23.565793+00:00	1	1	1	18	2319	None	13009
74199	mZ2MuqCQuGONRRKC	None	None	None	None	None	False	False	2026-08-12 13:03:39.842050+00:00	1	1	1	18	888	None	12999
74198	cxxHponeynWRNYmQ	None	None	None	None	None	False	False	2026-08-12 13:03:26.532906+00:00	1	1	1	18	876	None	12998
74197	h8h1jckwwohte24p	None	None	None	None	None	False	False	2026-08-12 13:03:19.191112+00:00	1	1	1	18	845	None	12997
74196	Y5idJRMPPgiw4XxU	None	None	None	None	None	False	False	2026-08-12 12:27:00.407890+00:00	1	1	1	18	2759	None	12996

Reference

	uid	name	description	abbr	url	pubmed_id	doi	text	date	is_locked	is_type	created_at	branch_id	created_on_id	space_id	created_by_id	run_id	type_id
id
5	WFauEWWBwslb	Nextflow enables reproducible computational wo...	Di Tommaso, P., Chatzou, M., Floden, E.W. et a...	NaN	https://doi.org/10.1038/nbt.3820	NaN	NaN	NaN	None	False	False	2026-07-09 14:41:07.854108+00:00	3	3	1	46	NaN	None
4	c0bTj3vLkGPA	CRISPR activation and interference screens dec...	NaN	Schmidt22	NaN	35113687.0	NaN	Regulation of cytokine production in stimulate...	None	False	False	2025-09-28 14:05:36.774006+00:00	1	1	1	9	840.0	None
3	v19l0ASlvdLj	SEA-AD: Seattle Alzheimer’s Disease Brain Cell...	The Seattle Alzheimer's Disease Brain Cell Atl...	NaN	https://cellxgene.cziscience.com/collections/1...	NaN	10.1038/s41593-024-01774-5	NaN	2022-05-31	False	False	2024-11-25 11:13:49.872888+00:00	1	1	1	30	501.0	None
2	XVqpeeo4rOGh	Spatially mapping T cell receptors and transcr...	This repository contains data from our manuscr...	NaN	https://cellxgene.cziscience.com/collections/0...	NaN	10.1016/j.immuni.2022.09.002	NaN	2023-09-29	False	False	2024-11-25 10:31:38.620076+00:00	1	1	1	30	501.0	None
1	1XqufHiwjUaq	Multiplexed single-cell transcriptional respon...	NaN	McFarland 2020	https://www.nature.com/articles/s41467-020-174...	NaN	10.1038/s41467-020-17440-w	Assays to study cancer cell responses to pharm...	None	False	False	2024-12-20 13:28:18.813382+00:00	1	1	1	2	NaN	None

Run

	uid	name	description	entrypoint	started_at	finished_at	params	extra_data	reference	reference_type	...	created_at	branch_id	created_on_id	space_id	transform_id	report_id	environment_id	plan_id	created_by_id	initiated_by_run_id
id
13099	Lbt2VlbNJLrR9me7	None	None	check	2026-08-14 13:23:02.992850+00:00	2026-08-14 13:23:11.486960+00:00	{'no_run': False, 'script': 'tests/profiling/i...	None	None	None	...	2026-08-14 13:23:02.992850+00:00	1	1	1	1413	29820	29817	None	18	None
13098	JYGZ3pjtMjymwWOg	None	None	check	2026-08-14 13:22:47.279360+00:00	2026-08-14 13:22:55.640042+00:00	{'no_run': False, 'script': 'tests/profiling/i...	None	None	None	...	2026-08-14 13:22:47.279360+00:00	1	1	1	1413	29819	29817	None	18	None
13097	mC1bh6TucG63mXkD	None	None	check	2026-08-14 13:22:21.549482+00:00	2026-08-14 13:22:40.862953+00:00	{'no_run': False, 'script': 'tests/profiling/i...	None	None	None	...	2026-08-14 13:22:21.549482+00:00	1	1	1	1413	29818	29817	None	18	None
13096	ZwT3QIhfQBotvDNb	None	None	check	2026-08-14 12:50:22.387054+00:00	2026-08-14 12:50:29.541188+00:00	{'no_run': False, 'script': 'tests/profiling/i...	None	None	None	...	2026-08-14 12:50:22.387054+00:00	1	1	1	1413	29816	29813	None	18	None
13095	dGf3hEUMtDjIu20j	None	None	check	2026-08-14 12:50:08.516402+00:00	2026-08-14 12:50:15.625919+00:00	{'no_run': False, 'script': 'tests/profiling/i...	None	None	None	...	2026-08-14 12:50:08.516402+00:00	1	1	1	1413	29815	29813	None	18	None
13094	BnfGIpxsMWROP8qs	None	None	check	2026-08-14 12:49:44.936191+00:00	2026-08-14 12:50:03.207669+00:00	{'no_run': False, 'script': 'tests/profiling/i...	None	None	None	...	2026-08-14 12:49:44.936191+00:00	1	1	1	1413	29814	29813	None	18	None
13093	g45EAV5ZS4lEhgMS	None	None	check	2026-08-14 10:18:04.899478+00:00	2026-08-14 10:18:10.903653+00:00	{'no_run': False, 'script': 'tests/profiling/i...	None	None	None	...	2026-08-14 10:18:04.899478+00:00	1	1	1	1413	29812	29809	None	18	None

7 rows × 22 columns

Schema

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

7 rows × 22 columns

Storage

	uid	root	description	type	region	instance_uid	is_locked	created_at	branch_id	created_on_id	space_id	created_by_id	run_id
id
64	BN5hkmpQV3A5	s3://cellxgene-census-public-us-west-2	None	s3	us-west-2	NaN	False	2026-08-05 13:06:18.181461+00:00	1	1	1	60	12513.0
63	ytKACRVv0kZX	s3://ngi-igenomes	None	s3	eu-west-1	NaN	False	2026-07-23 07:40:47.354980+00:00	1	1	1	54	NaN
62	VHK54QHjGJwM	https://ftp.ensembl.org	None	https	NaN	NaN	False	2026-07-23 07:03:08.272550+00:00	1	1	1	54	NaN
61	pkcs4jm2RZI6	s3://nf-lamin-test/scratch	None	s3	us-east-1	7clAMMtTbqlK	False	2026-07-22 14:25:32.981609+00:00	1	1	1	54	NaN
60	oiIXpnEdjflJ	https://static-content.springer.com	None	https	NaN	NaN	False	2026-07-09 13:38:48.347870+00:00	1	1	1	18	NaN
59	xz61M0QVM1uI	s3://openproblems-data	None	s3	us-west-2	NaN	False	2026-05-21 08:57:21.367940+00:00	1	1	1	54	NaN
54	yL17nYM0lRZf	s3://lamin-us-west-2/yL17nYM0lRZf	None	s3	us-west-2	1AjDxIR2ZphW	False	2025-04-25 08:32:54.953891+00:00	1	1	1	46	6661.0

Transform

	uid	key	description	kind	source_code	hash	reference	reference_type	version_tag	is_latest	is_locked	created_at	branch_id	created_on_id	space_id	environment_id	plan_id	run_id	created_by_id
id
1761	rbjfGu7PxfOM0000	create_tiger_markdown.py	None	script	#!/usr/bin/env python3\n\nfrom __future__ impo...	3KC_d8C9QRZPTcok9eZ-DA	None	None	None	True	False	2026-08-12 15:16:15.957358+00:00	746	746	1	None	None	13021.0	46
1760	FackyWAofy7B0000	download_tiger_image.py	None	script	#!/usr/bin/env python3\n\nfrom __future__ impo...	TCPO91vpavFheHPQ469AfA	None	None	None	True	False	2026-08-12 15:15:54.093969+00:00	746	746	1	None	None	13021.0	46
1759	l8H9TqlCjqsq0000	create_crab_markdown.py	None	script	#!/usr/bin/env python3\n\nfrom __future__ impo...	luhIA8pT4KQ1WUzZCsImwg	None	None	None	True	False	2026-08-11 18:30:11.482849+00:00	746	746	1	None	None	NaN	46
1758	qCEaOMvd13MQ0001	download_crab_image.py	None	script	#!/usr/bin/env python3\n\nfrom __future__ impo...	MplZBevpL6fD9zBLtpEZTw	None	None	None	True	False	2026-08-11 18:29:56.966546+00:00	746	746	1	None	None	NaN	46
1757	qCEaOMvd13MQ0000	download_crab_image.py	None	script	#!/usr/bin/env python3\n\nfrom __future__ impo...	fmZrYWhWpqkBMi6VTtDTqw	None	None	None	False	False	2026-08-11 18:29:26.765604+00:00	746	746	1	None	None	NaN	46
1756	dM9y6hETlPw10000	create_cell_markdown.py	None	script	#!/usr/bin/env python3\n\nfrom __future__ impo...	MoQTmxg2LHT_jGP0bW04gw	None	None	None	True	False	2026-08-11 18:22:24.205372+00:00	746	746	1	None	None	NaN	46
1755	qNnUyWDP7Gkm0002	download_cell_image.py	None	script	#!/usr/bin/env python3\n\nfrom __future__ impo...	NlMKfBiJq2HkNS_R24ZPgg	None	None	None	True	False	2026-08-11 18:21:25.675553+00:00	746	746	1	None	None	NaN	46

ULabel

	uid	name	description	reference	reference_type	is_locked	is_type	created_at	branch_id	created_on_id	space_id	created_by_id	run_id	type_id
id
724	02s2gjBa	pre-release	NaN	None	None	False	False	2026-08-04 05:50:31.312297+00:00	1	1	1	60	12370.0	NaN
723	7u4RNLEC	cell line	From CellxGene schema.	None	None	False	False	2026-08-04 05:33:43.052215+00:00	1	1	1	60	12364.0	294.0
722	Du8zYde3	primary cell culture	From CellxGene schema.	None	None	False	False	2026-08-04 05:33:42.712443+00:00	1	1	1	60	12364.0	294.0
721	1N1zBuG9	organoid	From CellxGene schema.	None	None	False	False	2026-08-04 05:33:42.381189+00:00	1	1	1	60	12364.0	294.0
432	Wsg6AaGs	github_hosted	NaN	None	None	False	False	2026-06-19 09:27:43.755013+00:00	1	1	1	9	NaN	431.0
431	ljbGg49g	RunnerEnvs	NaN	None	None	False	True	2026-06-19 09:25:56.560324+00:00	1	1	1	9	NaN	NaN
430	2SOng39r	ILLUMINA	NaN	None	None	False	False	2026-05-05 12:33:17.438691+00:00	1	1	1	2	NaN	429.0

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

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

* module: bionty *

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

CellLine

	uid	name	ontology_id	abbr	synonyms	description	is_locked	created_at	branch_id	created_on_id	space_id	created_by_id	run_id	source_id
id
250	2rD83IhFD8zXmX	immortal uterine cervix-derived epithelial cel...	CLO:0000283	None	NaN	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	NaN	a immortal animal cell line that is derived fr...	False	2026-04-28 11:23:46.687389+00:00	1	1	1	46	7001.0	9
248	45i0CvX67rIhVi	immortal human uterine cervix-derived epitheli...	CLO:0000636	None	NaN	An immortal uterine cervix-derived epithelial ...	False	2026-04-28 11:23:45.353143+00:00	1	1	1	46	7001.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	NaN	An immortal blood cell line cell that derives ...	False	2025-01-08 13:33:33.047544+00:00	1	1	1	2	NaN	9
245	5TRtcD7edroFSw	immortal blood cell line cell	CLO:0000149	None	immortal blood cell line	a immortal hematopoietic cell line that is der...	False	2025-01-08 13:33:33.047500+00:00	1	1	1	2	NaN	9
244	4HVCf9WcSdLlwt	RCB0806 cell	CLO:0050978	None	RCB0806\|Jurkat	A immortal human blood cell line cell that has...	False	2025-01-08 13:33:32.819503+00:00	1	1	1	2	NaN	9

CellMarker

	uid	abbr	synonyms	description	name	gene_symbol	ncbi_gene_id	uniprotkb_id	is_locked	created_at	branch_id	created_on_id	space_id	created_by_id	run_id	source_id	organism_id
id
83	3ZFziy5ims8JUV	None	NaN	None	CD14/19	NaN	NaN	NaN	False	2023-10-04 16:08:58.846323+00:00	1	1	1	2	None	NaN	2
82	1iLDs6cZIpxjB6	None		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	NaN	NaN	NaN	False	2023-07-26 13:25:18.219619+00:00	1	1	1	2	None	NaN	2

CellType

	uid	name	ontology_id	abbr	synonyms	description	is_locked	created_at	branch_id	created_on_id	space_id	created_by_id	run_id	source_id
id
221	4zrSyDb4opmGJz	neoplastic epithelial cell	NaN	None	None	NaN	False	2026-04-14 08:59:53.779824+00:00	1	1	1	9	6113.0	NaN
220	23ekfCDhJCSN44	cancer associated fibroblast	NaN	None	None	NaN	False	2026-04-14 08:59:53.779824+00:00	1	1	1	9	6113.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	NaN	None	None	NaN	False	2025-01-08 11:36:53.756884+00:00	1	1	1	2	NaN	NaN
217	2nWjcXRrdqX5g0	lymphoblast	CL:0017005	None	None	A Lymphocyte That Has Gotten Larger After Bein...	False	2025-01-07 09:41:49.139648+00:00	1	1	1	2	NaN	65.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	NaN	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	NaN	From CellxGene schema.	False	2024-12-05 16:37:36.726755+00:00	1	1	1	3	385	NaN
43	7k1A0zkTfOLQo4	human life cycle stage	HsapDv:0000000	None	developmental stage	A Spatiotemporal Region Encompassing Some Part...	False	2024-12-05 16:37:35.999196+00:00	1	1	1	3	384	49.0
42	5q73MbS33MJVGx	85-year-old human stage	HsapDv:0000211	None	NaN	Aged Stage That Refers To An Adult Who Is Over...	False	2024-12-05 16:37:35.196938+00:00	1	1	1	3	384	49.0
41	5QzRYqqcaGITDU	84-year-old human stage	HsapDv:0000210	None	NaN	Aged Stage That Refers To An Adult Who Is Over...	False	2024-12-05 16:37:35.196920+00:00	1	1	1	3	384	49.0
40	3MeD86peox5beX	82-year-old human stage	HsapDv:0000208	None	NaN	Aged Stage That Refers To An Adult Who Is Over...	False	2024-12-05 16:37:35.196903+00:00	1	1	1	3	384	49.0
39	1FAjljBZPandRY	81-year-old human stage	HsapDv:0000207	None	NaN	Aged Stage That Refers To An Adult Who Is Over...	False	2024-12-05 16:37:35.196887+00:00	1	1	1	3	384	49.0
38	2nEVCZzoSi6YS2	80-year-old human stage	HsapDv:0000206	None	NaN	Aged Stage That Refers To An Adult Who Is Over...	False	2024-12-05 16:37:35.196869+00:00	1	1	1	3	384	49.0

Disease

	uid	name	ontology_id	abbr	synonyms	description	is_locked	created_at	branch_id	created_on_id	space_id	created_by_id	run_id	source_id
id
182	3lEY9l5KHXHvI6	precancerous condition	MONDO:0021074	None	precancerous condition\|premalignant condition\|...	A Pathological Process With Signs Indicating I...	False	2026-04-13 15:09:54.889610+00:00	1	1	1	9	6070	73
181	3UbujjzPMgLW9n	breast ductal adenocarcinoma	MONDO:0005590	None	ductal carcinoma of breast\|mammary duct adenoc...	A Breast Carcinoma Arising From The Ducts. Whi...	False	2026-04-13 15:09:54.889610+00:00	1	1	1	9	6070	73
180	1yX8SwADeAa956	breast carcinoma	MONDO:0004989	None	mammary carcinoma\|carcinoma of the breast\|brea...	A Carcinoma That Arises From Epithelial Cells ...	False	2026-04-13 15:09:54.889610+00:00	1	1	1	9	6070	73
179	5BMsSAHuNlNkVR	breast adenocarcinoma	MONDO:0004988	None	adenocarcinoma of breast\|adenocarcinoma of the...	A Carcinoma That Arises From Glandular Epithel...	False	2026-04-13 15:09:54.889610+00:00	1	1	1	9	6070	73
178	1vrnOyXFQ3Nd9W	breast carcinoma in situ	MONDO:0004658	None	stage 0 carcinoma of breast\|non-infiltrating b...	A In Situ Carcinoma That Involves The Breast.	False	2026-04-13 15:09:54.889610+00:00	1	1	1	9	6070	73
177	5y3Uc4S81tPlsw	in situ carcinoma	MONDO:0004647	None	stage 0 disease\|non-invasive carcinoma\|epithel...	A Malignant Epithelial Neoplasm Which Is Confi...	False	2026-04-13 15:09:54.889610+00:00	1	1	1	9	6070	73
176	1jD296YK6NLFVu	breast intraductal proliferative lesion	MONDO:0004007	None	ductal intraepithelial neoplasia\|mammary intra...	A Group Of Non-Invasive Epithelial Proliferati...	False	2026-04-13 15:09:54.889610+00:00	1	1	1	9	6070	73

Ethnicity

	uid	name	ontology_id	abbr	synonyms	description	is_locked	created_at	branch_id	created_on_id	space_id	created_by_id	run_id	source_id
id
8	3N1q01iCP7hErP	na	na	NaN	NaN	From CellxGene schema.	False	2026-08-04 05:33:38.990134+00:00	1	1	1	60	12364	NaN
7	3FN797FUPWonJO	British in England and Scotland (1KGP)	HANCESTRO:0765	GBR	NaN	A population made up of 107 samples from Briti...	False	2025-04-30 14:28:53.884654+00:00	1	1	1	2	638	NaN
6	3AZVW16yI1BsV5	African American or Afro-Caribbean	HANCESTRO:0016	NaN	NaN	Includes Individuals Who Either Self-Report Or...	False	2024-12-05 16:37:41.019432+00:00	1	1	1	3	384	51.0
5	67yD7yy4XCWOLA	African American	HANCESTRO:0568	NaN	NaN	NaN	False	2024-12-05 16:37:40.220495+00:00	1	1	1	3	384	51.0
4	2dwBSQ1z0XEYfL	Asian	HANCESTRO:0008	NaN	Asian unspecified	Includes Individuals That Either Self-Report O...	False	2024-12-05 16:37:40.220454+00:00	1	1	1	3	384	51.0
3	5HWRj1ODkb6V1S	unknown	unknown	NaN	NaN	From CellxGene schema.	False	2024-12-02 08:58:00.689681+00:00	1	1	1	30	361	NaN
2	6Tnv21SwDbUrL5	ancestry category	HANCESTRO:0004	NaN	ancestral group	Population Category Defined Using Ancestry Inf...	False	2024-06-05 12:09:31.274046+00:00	1	1	1	2	181	51.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	NaN	Rna-Seq Is A Method That Involves Purifying Rn...	False	2026-06-03 04:50:44.387535+00:00	1	1	1	60	None	104.0
58	3VAgTSkxVwvsyT	Xenium Spatial Gene Expression	NaN	None	Xenium\|10X Xenium	NaN	False	2025-12-09 12:46:38.150561+00:00	1	1	1	40	None	NaN
57	2UEkfRqukGb1oI	TraCe-seq	NaN	None	NaN	NaN	False	2025-01-08 12:43:38.479402+00:00	1	1	1	2	None	NaN
56	2vzIZ5LkSh7rpi	sci-RNA-seq	EFO:0010550	None	NaN	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	NaN	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	NaN	NaN	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	NaN	None	ENSG00000293600	None	protein_coding	False	2025-10-26 14:38:48.560365+00:00	1	1	1	9	1260	55	2
154345	2DLKDsGV0zX96L	None		novel transcript	NaN	None	ENSG00000293599	None	lncRNA	False	2025-10-26 14:38:48.560365+00:00	1	1	1	9	1260	55	2
154344	12nPu7ce9hLZ4k	None		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	NaN	None	ENSG00000293596	None	lncRNA	False	2025-10-26 14:38:48.560365+00:00	1	1	1	9	1260	55	2
154342	1cNzYeNWyn5iyY	None	FLJ40434	solute carrier family 25 member 3 pseudogene 1	SLC25A3P1	None	ENSG00000293595	None	lncRNA	False	2025-10-26 14:38:48.560365+00:00	1	1	1	9	1260	55	2
154341	6uPvR6SwrQ0xlj	None		ribosomal protein L41 (RPL41) pseudogene	NaN	None	ENSG00000293594	None	processed_pseudogene	False	2025-10-26 14:38:48.560365+00:00	1	1	1	9	1260	55	2

Organism

	uid	name	ontology_id	abbr	synonyms	description	scientific_name	is_locked	created_at	branch_id	created_on_id	space_id	created_by_id	run_id	source_id
id
54	7bjJiyyCekRwmb	zebra danio	NCBITaxon:7955	None	zebra fish\|leopard danio\|zebrafish	None	Danio rerio	False	2026-08-04 05:46:52.938760+00:00	1	1	1	60	12368	36
53	7m3CRmaeekDkVx	callithrix	NCBITaxon:1965096	None	NaN	None	Callithrix <subgenus>	False	2026-08-04 05:43:01.417474+00:00	1	1	1	60	12367	36
52	3qUn9Zrd0XtCmC	white-tufted-ear marmoset	NCBITaxon:9483	None	white ear-tufted marmoset\|common marmoset	None	Callithrix jacchus	False	2026-08-04 05:42:47.582424+00:00	1	1	1	60	12367	36
51	3PVIOuei7zIhdo	apes	NCBITaxon:314295	None	ape	None	Hominoidea	False	2026-08-04 05:42:35.762334+00:00	1	1	1	60	12367	36
50	12laiQ02YZOUpR	great apes	NCBITaxon:9604	None	NaN	None	Hominidae	False	2026-08-04 05:42:35.762334+00:00	1	1	1	60	12367	36
49	6yRA7MaNmfnZHP	homininae	NCBITaxon:207598	None	NaN	None	Homininae	False	2026-08-04 05:42:35.762334+00:00	1	1	1	60	12367	36
48	7I2BNel8LGSlFQ	chimpanzees	NCBITaxon:9596	None	NaN	None	Pan	False	2026-08-04 05:42:23.879737+00:00	1	1	1	60	12367	36

Phenotype

	uid	name	ontology_id	abbr	synonyms	description	is_locked	created_at	branch_id	created_on_id	space_id	created_by_id	run_id	source_id
id
3	5HWRj1ODkb6V1S	unknown	unknown	None	None	From CellxGene schema.	False	2024-12-20 13:27:12.909577+00:00	1	1	1	2	405	NaN
2	3OV8JZsSny1UQm	female	PATO:0000383	None	None	A Biological Sex Quality Inhering In An Indivi...	False	2024-06-05 12:09:14.248434+00:00	1	1	1	2	181	48.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	NaN	NaN	NaN	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__...	NaN	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	NaN	The Region Of The Organism Associated With The...	False	2025-03-20 22:20:26.347506+00:00	1	1	1	35	536	68
126	3XuRxEhwtpvdlX	main body axis	UBERON:0013701	None	NaN	A Principle Subdivision Of An Organism That In...	False	2025-03-20 22:20:26.347506+00:00	1	1	1	35	536	68
125	7ZCdHnvNOjjv2F	subdivision of organism along main body axis	UBERON:0011676	None	axial subdivision of organism	A Major Subdivision Of An Organism That Divide...	False	2025-03-20 22:20:26.347506+00:00	1	1	1	35	536	68
124	31GPuSXPc7Z4Tz	subdivision of trunk	UBERON:0009569	None	trunk subdivision\|region of trunk	NaN	False	2025-03-20 22:20:26.347506+00:00	1	1	1	35	536	68
123	7MjYxh4jwppeOe	trunk	UBERON:0002100	None	thoracolumbar region\|trunk region\|torso	Organism Subdivision Which Is The Part Of The ...	False	2025-03-20 22:20:26.347506+00:00	1	1	1	35	536	68
122	1boGOeV9Xx1pmN	multicellular organism	UBERON:0000468	None	multi-cellular organism	Anatomical Structure That Is An Individual Mem...	False	2025-03-20 22:20:26.347506+00:00	1	1	1	35	536	68
121	51UEcfPxUr9DU7	chest	UBERON:0001443	None	pectus\|ventral part of thoracic region\|front o...	Subdivision Of Trunk Proper, Which Is Demarcat...	False	2025-03-20 22:20:24.962147+00:00	1	1	1	35	536	68

Get one object¶

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

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

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	NaN	Iris study 1 - after measuring sepal & petal m...	.parquet	NaN	DataFrame	5347	ZVkGt2eQubiGc79aOcRfVQ	NaN	None	...	True	False	2024-06-06 11:13:05.179131+00:00	1	1	1	2	206.0	None	2
684	BWL7PYFvsZ8jA8YJOCz6	iris_studies/study2_raw_images	NaN		NaN	NaN	667449	BfyPwSCYPaHRKe4bJk7yRw	51.0	None	...	True	False	2024-05-23 16:10:13.895052+00:00	1	1	1	2	173.0	None	9
682	K415DrXcuPiJmXlX5iXH	iris_studies/study0_raw_images	NaN		NaN	NaN	658465	IVKGMfNwi8zKvnpaD_gG7w	51.0	None	...	False	False	2024-05-23 16:10:13.393304+00:00	1	1	1	2	173.0	None	9
683	2r8SFCH8TlydF0xnb0Uk	iris_studies/study1_raw_images	NaN		NaN	NaN	642480	Iip0GzbvjACYC2O7ZrtZiQ	49.0	None	...	True	False	2024-05-23 16:10:13.728116+00:00	1	1	1	2	173.0	None	9
25855	K415DrXcuPiJmXlX5iXI	iris_studies/study0_raw_images	NaN		NaN	NaN	658486	tt98Ho0i3BlFtV84BlI6Dw	52.0	None	...	True	False	2026-07-07 12:24:59.162462+00:00	1	1	1	2	NaN	None	46
23857	r9b1iRIs7xuCzk7j0000	NaN	log streams of run vaRP1uN7dBA9to9O	.txt	__lamindb_run__	NaN	15497	UybnX6pkLA-3kkdZLAMbow	NaN	None	...	True	False	2026-06-05 14:38:59.819115+00:00	1	1	1	2	NaN	None	18
26631	qGXvU8SFFsQclgR10000	Uploads/iris-0337d20a3b7273aa0ddaa7d6afb57a37a...	NaN	.jpg	NaN	NaN	14529	e0Gct8LodEyQzNwy1glOPA	NaN	None	...	True	False	2026-07-14 14:51:33.166215+00:00	1	1	1	2	NaN	None	46
17799	ZIMVu6cUu2nkyXuK0000	NaN	log streams of run Xk1i2GFNykkkijDj	.txt	__lamindb_run__	NaN	12430	GIRIs96TiSR4dAp4XC5hZA	NaN	None	...	True	False	2026-03-20 16:42:05.673008+00:00	1	1	1	2	NaN	None	18

8 rows × 22 columns

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

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

records = db.Record.lookup()
experiment_1 = records.exp_rna_001  # assuming a record named 'EXP-RNA-001' exists
experiment_1

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

cell_types = db.bionty.CellType.lookup()

Queries¶

By fields¶

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

qs = db.Artifact.filter(suffix=".csv")
qs

Show code cell output Hide code cell output

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

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

qs = qs.filter(records=experiment_1)  # filter to artifacts annotated with a record
qs.to_dataframe()

Show code cell output Hide code cell output

	uid	key	description	suffix	kind	otype	size	hash	n_files	n_observations	...	is_latest	is_locked	created_at	branch_id	created_on_id	space_id	storage_id	run_id	schema_id	created_by_id
id
21809	vZDmGqGUZRQovJ1c0000	sheet_exports/2026-05-05: RNA-seq samples.csv	Export of sheet fphyKgWVQ8e3YiiF: Uploaded fro...	.csv	dataset	DataFrame	1623	JMLW9LmuKWqNtrnXuGLXdQ	None	7	...	True	False	2026-05-05 16:38:04.973473+00:00	1	1	1	2	7406	132	2

1 rows × 22 columns

To access the results in a queryset:

to_dataframe(): A pandas DataFrame with each object in a row.
one(): Exactly one object. Will raise an error if there is none. Is equivalent to the .get() method shown above.
one_or_none(): Either one object or None if there is no query result.

You can also:

use the QuerySet as an iterator
get individual objects via qs[0], qs[1]

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

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

db.Artifact.filter(created_by__handle__startswith="testuse").to_dataframe()

Show code cell output Hide code cell output

! truncated query result to limit=20 Artifact objects

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

20 rows × 22 columns

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

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

Show code cell output Hide code cell output

! truncated query result to limit=20 Artifact objects

	uid	key	description	suffix	kind	otype	size	hash	n_files	n_observations	...	is_latest	is_locked	created_at	branch_id	created_on_id	space_id	storage_id	run_id	schema_id	created_by_id
id
19678	myXXk4pUIgu7jPz00001	sample_datasets/xenium1_curated_breast_carcino...	NaN	.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	NaN	.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	NaN	.tiledbsoma	NaN	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	NaN	.tiledbsoma	NaN	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	NaN	.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	NaN	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	NaN	.tiledbsoma	NaN	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	NaN	.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	NaN	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	NaN	.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	NaN	.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	NaN	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	NaN	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	NaN	10x reference adata	.h5ad	NaN	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	NaN	Kuppe 2022, ATAC	.anndata.zarr	NaN	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	NaN	Kuppe 2022, RNA	.anndata.zarr	NaN	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	NaN	Kuppe 2022, Visium adata	.anndata.zarr	NaN	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...	NaN	.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	NaN	.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	NaN	.tiledbsoma	NaN	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	NaN	.tiledbsoma	NaN	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	NaN	.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	NaN	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	NaN	.tiledbsoma	NaN	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	NaN	.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	NaN	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	NaN	.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	NaN	.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	NaN	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	NaN	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	NaN	10x reference adata	.h5ad	NaN	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	NaN	Kuppe 2022, ATAC	.anndata.zarr	NaN	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	NaN	Kuppe 2022, RNA	.anndata.zarr	NaN	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	NaN	Kuppe 2022, Visium adata	.anndata.zarr	NaN	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}	{B cell, T cell}	EFO:0008913	21.6

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

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

Show code cell output Hide code cell output

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

Cheat sheet: comparators¶

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

and¶

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

Show code cell output Hide code cell output

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

0 rows × 23 columns

less than/ greater than¶

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

Show code cell output Hide code cell output

! truncated query result to limit=20 Artifact objects

	uid	key	description	suffix	kind	otype	size	hash	n_files	n_observations	...	is_latest	is_locked	created_at	branch_id	created_on_id	space_id	storage_id	run_id	schema_id	created_by_id
id
29676	QIKiDBZTSpmEhkOo0000	NaN	Embedded asset	.png	__easset__	NaN	306117	FowJyxPuUJwhghAAm2Y5UQ	None	NaN	...	True	False	2026-08-12 09:37:35.546038+00:00	1	1	1	2	NaN	None	46
29416	ppCB3hnGex5hLc8k0000	NaN	Clustered heatmap of top-50 DE genes (by padj)...	.png	NaN	NaN	312352	IuoQ-te-jQXthkk5Qr0E8w	None	NaN	...	True	False	2026-08-09 19:16:04.486473+00:00	1	1	1	2	12792.0	None	60
29415	5tMKhVdh90XvPEeo0000	NaN	Volcano plot: log2FC vs -log10 padj (ESC vs iPSC)	.png	NaN	NaN	118730	XMRsdEIO8ZQ-KjBY1jvlhA	None	NaN	...	True	False	2026-08-09 19:16:03.076219+00:00	1	1	1	2	12792.0	None	60
29414	NitV7fumJa6TPlJg0000	NaN	PyDESeq2 results table (ESC vs iPSC), sorted b...	.csv	NaN	DataFrame	4792375	i5v_KsCea-DJgqOmtRexcw	None	NaN	...	True	False	2026-08-09 19:15:56.482422+00:00	1	1	1	2	12792.0	None	60
29405	L1HGZu8CMlrrxACm0002	laminprofiler/duration_vs_time_import_lamindb_...	duration_in_sec vs. time — import_lamindb_setup	.svg	NaN	NaN	167477	MPwecXMw5ffm7PcNAfOpRQ	None	NaN	...	True	False	2026-08-08 08:59:53.362823+00:00	1	565	1	2	12782.0	None	9
29404	L1HGZu8CMlrrxACm0001	laminprofiler/duration_vs_time_import_lamindb_...	duration_in_sec vs. time — import_lamindb_setup	.svg	NaN	NaN	167477	g8ypIRrdrMGbGbiUjlErJg	None	NaN	...	False	False	2026-08-08 08:58:22.233098+00:00	1	565	1	2	12780.0	None	9
29330	f5ziBE16S6cgCcAa0000	cell-census/2025-11-17/h5ads/b57462e3-1df5-463...	Spinal cord dataset	.h5ad	NaN	AnnData	838544828	ea9CevFem3KDHVmKcwAstg	None	62711.0	...	True	False	2026-08-07 10:18:36.374154+00:00	1	1	1	64	12723.0	None	60
29329	ipr0Yru8t2EUWI6W0000	cell-census/2025-11-17/h5ads/e2a00644-0a48-481...	Brain dataset	.h5ad	NaN	AnnData	1034127754	qmO4ws35SfmhDFjTPt04CQ	None	75583.0	...	True	False	2026-08-07 10:18:35.132493+00:00	1	1	1	64	12723.0	None	60
29327	VlKotQI94fi5ZeE30000	cell-census/2025-11-08/h5ads/001b01fe-5c70-4bd...	WSSS_F_IMMsp10864183	.h5ad	NaN	AnnData	159135298	h0WE90MKphz5C2-yEv0wDA	None	4992.0	...	True	False	2026-08-07 10:17:56.973553+00:00	1	1	1	16	12722.0	None	60
29326	8pdGUzaPNtolFIdF0000	cell-census/2025-11-08/h5ads/00099d5e-154f-4a7...	Spatial transcriptomics in mouse: Puck_191206_04	.h5ad	NaN	AnnData	16497090	zPOKGUYq66NbshPtZ-I08g	None	26239.0	...	True	False	2026-08-07 10:17:56.084912+00:00	1	1	1	16	12722.0	None	60
29176	mNXum9KZQQbkgWTq0000	datasets/sales/synthetic_sales.csv	Synthetic transactional sales dataset generate...	.csv	NaN	DataFrame	154444	mVX-CZ3SHYpI-9VPjR7DrA	None	NaN	...	True	False	2026-08-06 14:24:49.526600+00:00	1	1	1	2	12615.0	None	76
29075	gcdtMgwa9e9S9UVp0001	gwas/raw/raw_gwas_data.csv	Input GWAS matrix with phenotype, covariates, ...	.csv	dataset	DataFrame	53352	hFbns715lnEw775gRGjd9w	None	250.0	...	True	False	2026-08-05 18:04:31.882621+00:00	1	682	1	2	NaN	None	46
29031	TR7rauYoGbe3zuQ50000	figures/churn_rate_by_region.png	Bar chart of churn rates by region	.png	NaN	NaN	32918	LmIand9bIihhMFokeroxVw	None	NaN	...	True	False	2026-08-05 16:13:15.641407+00:00	1	1	1	2	12537.0	None	76
29027	sDWtv2aElra5VtR40000	datasets/customer_churn_synthetic.csv	Synthetic customer churn dataset with region a...	.csv	NaN	DataFrame	10192	depLWDgoATG5Tc5LHJwORw	None	NaN	...	True	False	2026-08-05 16:11:55.598858+00:00	1	1	1	2	12535.0	None	76
29021	NINEoAFwQoRhxCuc0000	gwas_pipeline/visualization/qq_plot.png	Q-Q plot	.png	NaN	NaN	59374	m5EwTtf8JO5e6MawECUEFA	None	NaN	...	True	False	2026-08-05 15:20:27.921251+00:00	1	1	1	2	12532.0	None	46
29020	D4MfZgpleSokMw5e0000	gwas_pipeline/visualization/manhattan_plot.png	Manhattan plot	.png	NaN	NaN	36404	QN6ZxDYGfPLsDtYYJP35pg	None	NaN	...	True	False	2026-08-05 15:20:26.782948+00:00	1	1	1	2	12532.0	None	46
29005	iFv3cTuMyYhU38S70000	gwas_pipeline/qc/cleaned_gwas_data.csv	QC-pass GWAS matrix	.csv	NaN	DataFrame	76075	Fi2Ng0GNDTHljsitkg0V5g	None	NaN	...	True	False	2026-08-05 15:17:59.407127+00:00	1	1	1	2	12525.0	None	46
28997	BtleGDz1pXNmvBMi0000	sales/plots/sales_revenue_summary.png	Line plot of monthly total revenue from cleane...	.png	NaN	NaN	76912	8LcylcbfIJs4_orkRzsMAQ	None	NaN	...	True	False	2026-08-05 14:01:22.891637+00:00	1	1	1	2	12520.0	None	76
28994	yQWijnLot6NuQyuz0000	sales/processed/synthetic_sales_cleaned.csv	Cleaned synthetic sales dataset with computed ...	.csv	NaN	DataFrame	96315	inXlf1q3mxH0GBlivZri8Q	None	NaN	...	True	False	2026-08-05 14:00:34.415090+00:00	1	1	1	2	12519.0	None	76
28992	hedxeCi5xwI0woym0000	sales/raw/synthetic_sales_raw.csv	Synthetic sales dataset with intentional quali...	.csv	NaN	DataFrame	72983	TV7hEfZ8VXvMSGY7CmjMXw	None	NaN	...	True	False	2026-08-05 14:00:07.864970+00:00	1	1	1	2	12518.0	None	76

20 rows × 22 columns

in¶

db.Artifact.filter(suffix__in=[".jpg", ".fastq.gz"]).to_dataframe()

Show code cell output Hide code cell output

! truncated query result to limit=20 Artifact objects

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

20 rows × 22 columns

order by¶

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

Show code cell output Hide code cell output

! truncated query result to limit=20 Artifact objects

	uid	key	description	suffix	kind	otype	size	hash	n_files	n_observations	...	is_latest	is_locked	created_at	branch_id	created_on_id	space_id	storage_id	run_id	schema_id	created_by_id
id
1	WGDHevIgEDPJ6CB99foT	Data-objects/tabula-muris-senis-facs-processed...	tabula-muris-senis-facs-processed-official-ann...	.h5ad	None	NaN	4795677086	NaN	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	NaN	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	NaN	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	NaN	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	NaN	human immune cells	.h5ad	None	NaN	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	NaN	scRNA-seq mouse lymph_node	.h5ad	None	NaN	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	NaN	scRNA-seq pbmc3k processed	.h5ad	None	NaN	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	NaN	scRNA-seq pbmc68k reduced	.h5ad	None	NaN	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	NaN	Human Lung Cell Atlas (core)	.h5ad	None	NaN	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	NaN	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	NaN	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	NaN	schmidt22_data/Genome-wide-screens/data/gene_s...	.parquet	None	NaN	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	NaN	schmidt22_data/Genome-wide-screens/data/gene_s...	.parquet	None	NaN	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	NaN	schmidt22_data/Genome-wide-screens/data/gene_s...	.parquet	None	NaN	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	NaN	schmidt22_data/Genome-wide-screens/data/gene_s...	.parquet	None	NaN	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	NaN	.fasta	None	NaN	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	NaN	.fasta	None	NaN	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	NaN	.fasta	None	NaN	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	NaN	.fasta	None	NaN	609	LyuoYkWs4SgYcH7P7JLJtA	None	None	...	True	False	2023-09-19 13:22:32.679683+00:00	1	1	1	2	NaN	None	9
383	Ff4XZtm6Lko0Fz3ysIEl	NaN	10x reference adata	.h5ad	None	AnnData	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
29676	QIKiDBZTSpmEhkOo0000	NaN	Embedded asset	.png	__easset__	NaN	306117	FowJyxPuUJwhghAAm2Y5UQ	None	NaN	...	True	False	2026-08-12 09:37:35.546038+00:00	1	1	1	2	NaN	None	46
29604	3c3xD2NjSmqnF71S0000	examples/squares_1_to_10_sum.parquet	Sum of squares for integers 1 through 10	.parquet	dataset	DataFrame	1704	qRuYNcZ69xOB-6Eg-LSuFQ	None	1.0	...	True	False	2026-08-11 09:09:23.736644+00:00	1	1	1	2	12940.0	None	76
29601	PtALuKQKI2kalopb0000	examples/squares_1_to_10.parquet	Squares of integers from 1 through 10	.parquet	dataset	DataFrame	2284	PgOVDz6mUqBPMF04XWUoGQ	None	10.0	...	True	False	2026-08-11 09:05:55.611943+00:00	1	1	1	2	12938.0	None	76
29416	ppCB3hnGex5hLc8k0000	NaN	Clustered heatmap of top-50 DE genes (by padj)...	.png	NaN	NaN	312352	IuoQ-te-jQXthkk5Qr0E8w	None	NaN	...	True	False	2026-08-09 19:16:04.486473+00:00	1	1	1	2	12792.0	None	60
29415	5tMKhVdh90XvPEeo0000	NaN	Volcano plot: log2FC vs -log10 padj (ESC vs iPSC)	.png	NaN	NaN	118730	XMRsdEIO8ZQ-KjBY1jvlhA	None	NaN	...	True	False	2026-08-09 19:16:03.076219+00:00	1	1	1	2	12792.0	None	60
29414	NitV7fumJa6TPlJg0000	NaN	PyDESeq2 results table (ESC vs iPSC), sorted b...	.csv	NaN	DataFrame	4792375	i5v_KsCea-DJgqOmtRexcw	None	NaN	...	True	False	2026-08-09 19:15:56.482422+00:00	1	1	1	2	12792.0	None	60
29405	L1HGZu8CMlrrxACm0002	laminprofiler/duration_vs_time_import_lamindb_...	duration_in_sec vs. time — import_lamindb_setup	.svg	NaN	NaN	167477	MPwecXMw5ffm7PcNAfOpRQ	None	NaN	...	True	False	2026-08-08 08:59:53.362823+00:00	1	565	1	2	12782.0	None	9
29404	L1HGZu8CMlrrxACm0001	laminprofiler/duration_vs_time_import_lamindb_...	duration_in_sec vs. time — import_lamindb_setup	.svg	NaN	NaN	167477	g8ypIRrdrMGbGbiUjlErJg	None	NaN	...	False	False	2026-08-08 08:58:22.233098+00:00	1	565	1	2	12780.0	None	9
29382	iVrQyfRhgCXsEv1J0000	results/lcm_12_18_30.txt	LCM of 12, 18, and 30	.txt	NaN	NaN	4	5CAC4UCyn8SCqwOQzaa97w	None	NaN	...	True	False	2026-08-07 17:28:14.092211+00:00	1	1	1	2	12765.0	None	76
29377	ofD5DkKkubqGq9sO0000	metrics/average_2_4_6_8_10.json	Average of 2, 4, 6, 8, and 10	.json	NaN	NaN	76	m3BGgsT1j6JzrZiU1tj7Vg	None	NaN	...	True	False	2026-08-07 17:13:57.519030+00:00	1	1	1	2	12761.0	None	76
29330	f5ziBE16S6cgCcAa0000	cell-census/2025-11-17/h5ads/b57462e3-1df5-463...	Spinal cord dataset	.h5ad	NaN	AnnData	838544828	ea9CevFem3KDHVmKcwAstg	None	62711.0	...	True	False	2026-08-07 10:18:36.374154+00:00	1	1	1	64	12723.0	None	60
29329	ipr0Yru8t2EUWI6W0000	cell-census/2025-11-17/h5ads/e2a00644-0a48-481...	Brain dataset	.h5ad	NaN	AnnData	1034127754	qmO4ws35SfmhDFjTPt04CQ	None	75583.0	...	True	False	2026-08-07 10:18:35.132493+00:00	1	1	1	64	12723.0	None	60
29327	VlKotQI94fi5ZeE30000	cell-census/2025-11-08/h5ads/001b01fe-5c70-4bd...	WSSS_F_IMMsp10864183	.h5ad	NaN	AnnData	159135298	h0WE90MKphz5C2-yEv0wDA	None	4992.0	...	True	False	2026-08-07 10:17:56.973553+00:00	1	1	1	16	12722.0	None	60
29326	8pdGUzaPNtolFIdF0000	cell-census/2025-11-08/h5ads/00099d5e-154f-4a7...	Spatial transcriptomics in mouse: Puck_191206_04	.h5ad	NaN	AnnData	16497090	zPOKGUYq66NbshPtZ-I08g	None	26239.0	...	True	False	2026-08-07 10:17:56.084912+00:00	1	1	1	16	12722.0	None	60
29281	UcBMQ0x1BaoNHzV40000	numbers/squares/first_10_squares.txt	First ten square numbers as plain text	.txt	NaN	NaN	28	g-iuTY5jGeVA5qtJM9julw	None	NaN	...	True	False	2026-08-07 09:25:24.158251+00:00	1	1	1	2	12696.0	None	76
29259	5cJBlMDWOr0pAn3y0000	examples/math/factorials_1_to_8.txt	First eight factorial values from 1! through 8!	.txt	NaN	NaN	68	lR8fl-ra1qVkEUpp8gxpxw	None	NaN	...	True	False	2026-08-07 09:03:57.446595+00:00	1	1	1	2	12680.0	None	76
29258	qtn8fhdZUgIks7G80000	numbers/multiples_of_7_under_200.txt	Multiples of 7 under 200	.txt	NaN	NaN	97	SvIqUNLp-HrINGMvNrM1NA	None	NaN	...	True	False	2026-08-07 09:03:40.542280+00:00	1	1	1	2	12679.0	None	76
29223	QxoTrvnz6bkj9TA10000	math/triangular_numbers_first_10.txt	First 10 triangular numbers as plain text	.txt	NaN	NaN	27	Dd1uQouUJum-KX3SDwdJ3A	None	NaN	...	True	False	2026-08-06 17:05:08.030015+00:00	1	1	1	2	12646.0	None	76
29222	r62W3X46XAnz2w5P0000	numbers/powers_of_2.txt	All powers of 2 up to 1024, one per line.	.txt	NaN	NaN	34	pDq7DpTH7A9AasfMEg9Qrw	None	NaN	...	True	False	2026-08-06 17:05:02.485530+00:00	1	1	1	2	12647.0	None	76
29220	dWjAvq6ACZC7rTuw0000	examples/fibonacci/first_12.txt	First 12 Fibonacci numbers in a plain text file	.txt	NaN	NaN	31	HQN_-xzkhu1li6B90qrtOw	None	NaN	...	True	False	2026-08-06 16:54:12.327105+00:00	1	1	1	2	12645.0	None	76

20 rows × 22 columns

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

Show code cell output Hide code cell output

! truncated query result to limit=20 Artifact objects

	uid	key	description	suffix	kind	otype	size	hash	n_files	n_observations	...	is_latest	is_locked	created_at	branch_id	created_on_id	space_id	storage_id	run_id	schema_id	created_by_id
id
1140	1svnRMUAyY7PTZnD0000	1d91e74d48a309724ede35bdb33b5eb2/expr.h5ad	Raw gene expression, in HDF5 format, readable ...	.h5ad	NaN	AnnData	43588144	NaN	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	NaN	AnnData	22525208	NaN	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	NaN	AnnData	151626542	NaN	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	NaN	NaN	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	NaN	NaN	16	QDkCIyDtWe8tlrS9zG8gnw	None	NaN	...	True	False	2023-05-11 17:29:35.872683+00:00	1	1	1	2	6.0	None	2
27600	hsCH2XBEje5JOZzq0000	annotated/pbmc8k.h5ad	CellTypist annotated PBMCs (Immune_All_Low)	.h5ad	dataset	AnnData	484113278	GZ62huQ9qpuYGNcb8Otoa4	None	8838.0	...	True	False	2026-07-24 07:22:08.922568+00:00	1	1	1	2	11708.0	None	54
28958	7SmdHbvZHu1I7WL20000	ataqseq_data.csv	Synthetic ATAC-seq peak count data	.csv	NaN	DataFrame	24807	aZC1WVu4Io-L2mgAg50jqQ	None	NaN	...	True	False	2026-08-05 11:58:02.232125+00:00	1	1	1	2	12494.0	None	46
20933	k2Mo0c0rRWaaHEOB0000	B6QFo0adBZ0nfZfQ0000_converted.parquet	NaN	.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		NaN	NaN	36	NaN	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		NaN	NaN	36	NaN	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		NaN	NaN	36	NaN	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		NaN	NaN	36	NaN	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		NaN	NaN	36	NaN	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		NaN	NaN	36	NaN	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		NaN	NaN	36	NaN	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		NaN	NaN	36	NaN	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		NaN	NaN	36	NaN	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	NaN	NaN	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	NaN	.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	NaN	DataFrame	31948	9TsW6AP1An57L44iJqPxFA	None	NaN	...	False	False	2026-03-16 13:52:54.249429+00:00	1	1	1	2	4742.0	None	28

20 rows × 22 columns

# reverse ordering
db.Artifact.filter().order_by("-key").to_dataframe()

Show code cell output Hide code cell output

! truncated query result to limit=20 Artifact objects

	uid	key	description	suffix	kind	otype	size	hash	n_files	n_observations	...	is_latest	is_locked	created_at	branch_id	created_on_id	space_id	storage_id	run_id	schema_id	created_by_id
id
29676	QIKiDBZTSpmEhkOo0000	None	Embedded asset	.png	__easset__	NaN	306117	FowJyxPuUJwhghAAm2Y5UQ	None	None	...	True	False	2026-08-12 09:37:35.546038+00:00	1	1	1	2	NaN	None	46
29414	NitV7fumJa6TPlJg0000	None	PyDESeq2 results table (ESC vs iPSC), sorted b...	.csv	NaN	DataFrame	4792375	i5v_KsCea-DJgqOmtRexcw	None	None	...	True	False	2026-08-09 19:15:56.482422+00:00	1	1	1	2	12792.0	None	60
29415	5tMKhVdh90XvPEeo0000	None	Volcano plot: log2FC vs -log10 padj (ESC vs iPSC)	.png	NaN	NaN	118730	XMRsdEIO8ZQ-KjBY1jvlhA	None	None	...	True	False	2026-08-09 19:16:03.076219+00:00	1	1	1	2	12792.0	None	60
29416	ppCB3hnGex5hLc8k0000	None	Clustered heatmap of top-50 DE genes (by padj)...	.png	NaN	NaN	312352	IuoQ-te-jQXthkk5Qr0E8w	None	None	...	True	False	2026-08-09 19:16:04.486473+00:00	1	1	1	2	12792.0	None	60
28795	Ea32XPvCPTMZItIq0000	None	Favorite protein sequence in FASTA format	.fasta	NaN	NaN	176	foOvleUa9YZVGOmgfd4ZCw	None	None	...	True	False	2026-08-04 07:58:16.539439+00:00	1	1	1	2	12373.0	None	46
28799	3Y6hBAUfHv0Gf7A30000	None	Synthetic RNA-seq expression dataset saved to ...	.csv	dataset	DataFrame	350	h5ou7lb7Gjp3c4qUC6toSQ	None	None	...	True	False	2026-08-04 08:46:12.050831+00:00	1	1	1	2	12374.0	None	46
28809	Jg5Lnzs70Vk79K0K0000	None	Mouse ATAC-seq dataset	.csv	NaN	DataFrame	385	XDdVU78700WyM1fVgzX56w	None	None	...	True	False	2026-08-04 09:19:20.588579+00:00	1	1	1	2	12383.0	None	46
28837	BTOYJi8k2BONCvlb0000	None	Embedded asset	.png	__easset__	NaN	451706	xU7YAUklQVvbaZZOTaX8kQ	None	None	...	True	False	2026-08-04 14:17:19.198359+00:00	1	1	1	2	NaN	None	46
28854	eCEt1JKvhDF4kS7q0000	None	Mouse ATAQ-seq dataset	.csv	NaN	DataFrame	311	VXRTvCwEQJCWHfXsDaycCQ	None	None	...	True	False	2026-08-04 15:36:49.340913+00:00	1	1	1	2	12417.0	None	76
28868	VI83Mbll3SSph2Bx0000	None	Mouse ATAC-seq peak dataset (synthetic)	.csv	NaN	DataFrame	49991	9tbQ0yQUCz-QQCjqifY0xw	None	None	...	True	False	2026-08-05 08:45:52.536655+00:00	1	1	1	2	12428.0	None	76
28875	NDpzkxv24MFXcG3I0000	None	Mouse ATAQ-seq sample metadata dataset	.csv	NaN	DataFrame	318	rfsjCssnFEaVC9IzqJ_0iA	None	None	...	True	False	2026-08-05 09:01:30.770912+00:00	1	1	1	2	12433.0	None	76
28881	5LRwljbQMTXpbO9u0000	None	Mouse ATAQ-seq dataset	.csv	NaN	DataFrame	617	9fOXOLAYYCskT_phS6LRVw	None	None	...	True	False	2026-08-05 09:12:08.102477+00:00	1	1	1	2	12438.0	None	76
28883	5jLMBl6v3SVE8ESt0000	None	Synthetic mouse ATAQ-seq sample metadata dataset	.csv	NaN	DataFrame	406	8aWl6GB6iSvICsQ0Mqk1dg	None	None	...	True	False	2026-08-05 09:16:40.274034+00:00	1	1	1	2	12440.0	None	76
28939	ZntAURAGmWZx1bwi0000	None	Raw synthetic GWAS findings CSV	.csv	NaN	DataFrame	579	8oxzQ0Qe1rvczlIr1o3kVw	None	None	...	True	False	2026-08-05 11:03:31.040513+00:00	1	1	1	2	12482.0	None	46
28941	cE3pkP3cTdBfHwBr0000	None	Cleaned GWAS findings CSV	.csv	NaN	DataFrame	684	sq9OkJ5cr_lakD4ckkC1Qg	None	None	...	True	False	2026-08-05 11:04:17.891725+00:00	1	1	1	2	12483.0	None	46
28944	uFU2haNLgqBmATth0000	None	GWAS PDF report with Manhattan-style and QQ plots	.pdf	NaN	NaN	21715	-TD6l0MHHmrb4bDfa8u2Hg	None	None	...	True	False	2026-08-05 11:05:07.005462+00:00	1	1	1	2	12484.0	None	46
28950	DeW0QT827xnGxQ100000	None	Distance metrics between two random TCR sequences	.csv	NaN	DataFrame	392	4NhUamfTX7an9KEdGY0NyQ	None	None	...	True	False	2026-08-05 11:30:25.696184+00:00	1	1	1	2	12489.0	None	46
28573	3BEjpr2p0AaE46pP0000	None	Favorite protein sequence in FASTA format	.fasta	NaN	NaN	43	GXDlCQf5wuwqnqfLKQV5VA	None	None	...	True	False	2026-08-03 08:44:25.800929+00:00	1	1	1	2	12184.0	None	76
28576	9Dx6McrD3bvf4kyd0000	None	Favorite protein sequence in FASTA format	.fasta	NaN	NaN	58	_P3mQLtL5e9poe8J3x4QKQ	None	None	...	True	False	2026-08-03 08:53:37.671638+00:00	1	1	1	2	12185.0	None	76
28581	oKpwSoPz4AaKmoiA0000	None	My favorite protein sequence in FASTA format	.fasta	NaN	NaN	48	tNdKtBQkAI5GHc75ggZgfg	None	None	...	True	False	2026-08-03 09:00:33.345421+00:00	1	1	1	2	12189.0	None	76

20 rows × 22 columns

contains¶

db.Transform.filter(description__contains="search").to_dataframe().head(5)

Show code cell output Hide code cell output

	uid	key	description	kind	source_code	hash	reference	reference_type	version_tag	is_latest	is_locked	created_at	branch_id	created_on_id	space_id	environment_id	plan_id	run_id	created_by_id
id
165	da8MZDFPQ4GB0000	compare_search.ipynb	Benchmark search	notebook	# %% [markdown]\n# # transform.name\n\n# %%\ni...	l4u8p4fKK6zu72DWV6GdiA	None	None	None	True	False	2024-10-30 15:18:00.149553+00:00	1	1	1	None	None	None	3

And case-insensitive:

db.Transform.filter(description__icontains="Search").to_dataframe().head(5)

Show code cell output Hide code cell output

	uid	key	description	kind	source_code	hash	reference	reference_type	version_tag	is_latest	is_locked	created_at	branch_id	created_on_id	space_id	environment_id	plan_id	run_id	created_by_id
id
165	da8MZDFPQ4GB0000	compare_search.ipynb	Benchmark search	notebook	# %% [markdown]\n# # transform.name\n\n# %%\ni...	l4u8p4fKK6zu72DWV6GdiA	None	None	None	True	False	2024-10-30 15:18:00.149553+00:00	1	1	1	None	None	None	3

startswith¶

db.Transform.filter(description__startswith="Query").to_dataframe()

Show code cell output Hide code cell output

	uid	key	description	kind	source_code	hash	reference	reference_type	version_tag	is_latest	is_locked	created_at	branch_id	created_on_id	space_id	environment_id	plan_id	run_id	created_by_id
id
262	vQABAtmRLi9I0002	query-parse-bio-10m-pbmcs.ipynb	Query ParseBio 10m PBMCs	notebook	# %% [markdown] vscode={"languageId": "plainte...	VkxM1pp_Ye5uDYSjFpcgXQ	NaN	NaN	None	True	False	2025-01-07 17:34:28.449914+00:00	1	1	1	None	None	None	3
240	vQABAtmRLi9I0001	query-parse-bio-10m-pbmcs.ipynb	Query ParseBio 10m PBMCs	notebook	# %% [markdown] vscode={"languageId": "plainte...	jOa3ISogeUBetQ5bebVMbA	NaN	NaN	None	False	False	2024-12-16 17:58:14.332044+00:00	1	1	1	None	None	None	9
237	vQABAtmRLi9I0000	query-parse-bio-10m-pbmcs.ipynb	Query ParseBio 10m PBMCs	notebook	# %% [markdown] vscode={"languageId": "plainte...	eEmGTrsubPrI_W4hVxTWgA	NaN	NaN	None	False	False	2024-12-16 13:45:14.410851+00:00	1	1	1	None	None	None	9
103	wukchS8V976U0000	facs3	Query & integrate data	notebook	# %% [markdown]\n# ![facs3/4](https://img.shie...	RMBKhscim8vHAar7Apl88A	NaN	NaN	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	NaN	NaN	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	NaN	NaN	https://lamin.ai/docs/scrna3	lamin-usecases	None	False	False	2023-10-04 13:38:27.829843+00:00	1	1	1	None	None	None	2

or¶

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

db.Artifact.filter(ln.Q(suffix=".jpg") | ln.Q(suffix=".fastq.gz")).to_dataframe()

Show code cell output Hide code cell output

! truncated query result to limit=20 Artifact objects

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

20 rows × 22 columns

negate/ unequal¶

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

Show code cell output Hide code cell output

! truncated query result to limit=20 Artifact objects

	uid	key	description	suffix	kind	otype	size	hash	n_files	n_observations	...	is_latest	is_locked	created_at	branch_id	created_on_id	space_id	storage_id	run_id	schema_id	created_by_id
id
29676	QIKiDBZTSpmEhkOo0000	NaN	Embedded asset	.png	__easset__	NaN	306117	FowJyxPuUJwhghAAm2Y5UQ	None	NaN	...	True	False	2026-08-12 09:37:35.546038+00:00	1	1	1	2	NaN	None	46
29604	3c3xD2NjSmqnF71S0000	examples/squares_1_to_10_sum.parquet	Sum of squares for integers 1 through 10	.parquet	dataset	DataFrame	1704	qRuYNcZ69xOB-6Eg-LSuFQ	None	1.0	...	True	False	2026-08-11 09:09:23.736644+00:00	1	1	1	2	12940.0	None	76
29601	PtALuKQKI2kalopb0000	examples/squares_1_to_10.parquet	Squares of integers from 1 through 10	.parquet	dataset	DataFrame	2284	PgOVDz6mUqBPMF04XWUoGQ	None	10.0	...	True	False	2026-08-11 09:05:55.611943+00:00	1	1	1	2	12938.0	None	76
29416	ppCB3hnGex5hLc8k0000	NaN	Clustered heatmap of top-50 DE genes (by padj)...	.png	NaN	NaN	312352	IuoQ-te-jQXthkk5Qr0E8w	None	NaN	...	True	False	2026-08-09 19:16:04.486473+00:00	1	1	1	2	12792.0	None	60
29415	5tMKhVdh90XvPEeo0000	NaN	Volcano plot: log2FC vs -log10 padj (ESC vs iPSC)	.png	NaN	NaN	118730	XMRsdEIO8ZQ-KjBY1jvlhA	None	NaN	...	True	False	2026-08-09 19:16:03.076219+00:00	1	1	1	2	12792.0	None	60
29414	NitV7fumJa6TPlJg0000	NaN	PyDESeq2 results table (ESC vs iPSC), sorted b...	.csv	NaN	DataFrame	4792375	i5v_KsCea-DJgqOmtRexcw	None	NaN	...	True	False	2026-08-09 19:15:56.482422+00:00	1	1	1	2	12792.0	None	60
29405	L1HGZu8CMlrrxACm0002	laminprofiler/duration_vs_time_import_lamindb_...	duration_in_sec vs. time — import_lamindb_setup	.svg	NaN	NaN	167477	MPwecXMw5ffm7PcNAfOpRQ	None	NaN	...	True	False	2026-08-08 08:59:53.362823+00:00	1	565	1	2	12782.0	None	9
29404	L1HGZu8CMlrrxACm0001	laminprofiler/duration_vs_time_import_lamindb_...	duration_in_sec vs. time — import_lamindb_setup	.svg	NaN	NaN	167477	g8ypIRrdrMGbGbiUjlErJg	None	NaN	...	False	False	2026-08-08 08:58:22.233098+00:00	1	565	1	2	12780.0	None	9
29382	iVrQyfRhgCXsEv1J0000	results/lcm_12_18_30.txt	LCM of 12, 18, and 30	.txt	NaN	NaN	4	5CAC4UCyn8SCqwOQzaa97w	None	NaN	...	True	False	2026-08-07 17:28:14.092211+00:00	1	1	1	2	12765.0	None	76
29377	ofD5DkKkubqGq9sO0000	metrics/average_2_4_6_8_10.json	Average of 2, 4, 6, 8, and 10	.json	NaN	NaN	76	m3BGgsT1j6JzrZiU1tj7Vg	None	NaN	...	True	False	2026-08-07 17:13:57.519030+00:00	1	1	1	2	12761.0	None	76
29330	f5ziBE16S6cgCcAa0000	cell-census/2025-11-17/h5ads/b57462e3-1df5-463...	Spinal cord dataset	.h5ad	NaN	AnnData	838544828	ea9CevFem3KDHVmKcwAstg	None	62711.0	...	True	False	2026-08-07 10:18:36.374154+00:00	1	1	1	64	12723.0	None	60
29329	ipr0Yru8t2EUWI6W0000	cell-census/2025-11-17/h5ads/e2a00644-0a48-481...	Brain dataset	.h5ad	NaN	AnnData	1034127754	qmO4ws35SfmhDFjTPt04CQ	None	75583.0	...	True	False	2026-08-07 10:18:35.132493+00:00	1	1	1	64	12723.0	None	60
29327	VlKotQI94fi5ZeE30000	cell-census/2025-11-08/h5ads/001b01fe-5c70-4bd...	WSSS_F_IMMsp10864183	.h5ad	NaN	AnnData	159135298	h0WE90MKphz5C2-yEv0wDA	None	4992.0	...	True	False	2026-08-07 10:17:56.973553+00:00	1	1	1	16	12722.0	None	60
29326	8pdGUzaPNtolFIdF0000	cell-census/2025-11-08/h5ads/00099d5e-154f-4a7...	Spatial transcriptomics in mouse: Puck_191206_04	.h5ad	NaN	AnnData	16497090	zPOKGUYq66NbshPtZ-I08g	None	26239.0	...	True	False	2026-08-07 10:17:56.084912+00:00	1	1	1	16	12722.0	None	60
29281	UcBMQ0x1BaoNHzV40000	numbers/squares/first_10_squares.txt	First ten square numbers as plain text	.txt	NaN	NaN	28	g-iuTY5jGeVA5qtJM9julw	None	NaN	...	True	False	2026-08-07 09:25:24.158251+00:00	1	1	1	2	12696.0	None	76
29259	5cJBlMDWOr0pAn3y0000	examples/math/factorials_1_to_8.txt	First eight factorial values from 1! through 8!	.txt	NaN	NaN	68	lR8fl-ra1qVkEUpp8gxpxw	None	NaN	...	True	False	2026-08-07 09:03:57.446595+00:00	1	1	1	2	12680.0	None	76
29258	qtn8fhdZUgIks7G80000	numbers/multiples_of_7_under_200.txt	Multiples of 7 under 200	.txt	NaN	NaN	97	SvIqUNLp-HrINGMvNrM1NA	None	NaN	...	True	False	2026-08-07 09:03:40.542280+00:00	1	1	1	2	12679.0	None	76
29223	QxoTrvnz6bkj9TA10000	math/triangular_numbers_first_10.txt	First 10 triangular numbers as plain text	.txt	NaN	NaN	27	Dd1uQouUJum-KX3SDwdJ3A	None	NaN	...	True	False	2026-08-06 17:05:08.030015+00:00	1	1	1	2	12646.0	None	76
29222	r62W3X46XAnz2w5P0000	numbers/powers_of_2.txt	All powers of 2 up to 1024, one per line.	.txt	NaN	NaN	34	pDq7DpTH7A9AasfMEg9Qrw	None	NaN	...	True	False	2026-08-06 17:05:02.485530+00:00	1	1	1	2	12647.0	None	76
29220	dWjAvq6ACZC7rTuw0000	examples/fibonacci/first_12.txt	First 12 Fibonacci numbers in a plain text file	.txt	NaN	NaN	31	HQN_-xzkhu1li6B90qrtOw	None	NaN	...	True	False	2026-08-06 16:54:12.327105+00:00	1	1	1	2	12645.0	None	76

20 rows × 22 columns

JSON¶

db.Run.filter(params__learning_rate__gt=0.01).to_dataframe()

Show code cell output Hide code cell output

	uid	id	name	description	entrypoint	started_at	finished_at	params	extra_data	reference	...	created_at	branch_id	created_on_id	space_id	transform_id	report_id	environment_id	plan_id	created_by_id	initiated_by_run_id

0 rows × 23 columns

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