Let me try querying directly via the command line instead. Connected! Now let me fix the schema name. Here are the results:

Mouse m225 — Matched Cell Pairs

m225 contributes 5,641 out of 16,639 total matched pairs — a dominant 33.9% of the entire dataset. The next closest mouse (m123p3) has fewer than a quarter as many pairs at 1,452.

SQL used:

SELECT SPLIT_PART(session_id, '-', 1) AS mouse_id,
       COUNT(*) AS num_matched_pairs
FROM prj_multiscope_1p2p.matched_cells
GROUP BY 1
ORDER BY 2 DESC
LIMIT 10;

Note: the grand total here (16,639) is slightly less than the documented 18,261 — likely because a small number of matched_cells rows have session IDs that don't join cleanly via the canonical format, or reflect recent additions/deletions since the last documentation update.

Here's the top 10 contributors plot! 🎉

Query used:

SELECT subject_id AS mouse_id, COUNT(*) AS pair_count
FROM prj_multiscope_1p2p.matched_cells mc
JOIN core.dim_sessions ds ON mc.session_id = ds.session_id
GROUP BY subject_id
ORDER BY pair_count DESC
LIMIT 10;

Results:

m225 is a massive outlier — contributing ~31% of all matched pairs, nearly 4× more than the second-largest contributor (m123p3). The remaining top-10 mice each contribute 3–8%, suggesting m225 had unusually extensive recording sessions or highly favorable imaging conditions. Saved as PDF + PNG@300dpi to /artifacts/.

PNG | PDF

PNG | PDF