What data is available for session m225-20210409-s01?

Let me try the MCP tools directly — they should be available without needing to be loaded via ToolSearch. The MCP tools aren't loading as deferred tools, so let me query the database and NAS directly using SQL and Python. Good progress — wh schema doesn't exist in this Redshift instance (it may be warehouse or similar). Let me fix the schema names. Now I have the correct schema names. Let me run the full inventory. Now I have all the correct column and schema names. Let me pull the complete inventory. Here's a full inventory for m225-20210409-s01:

📋 Session: m225-20210409-s01

Field Value
Mouse m225
Date 2021-04-09
Session # 1

🎥 Neural Recordings (4 total)

recording_id Modality Substage Frame Rate Depth (µm) FOV (px)
109 1P — 25.38 Hz 59.9 512×512
431 1P — 25.38 Hz 59.9 512×512
110 2P — 25.38 Hz 59.9 512×512
432 2P — 25.38 Hz 59.9 512×512

Two recording IDs per modality — likely different processing substages (e.g., merge/ls vs raw). Use merge/ls for analysis.

🔗 Matched Cells

  • 605 matched 1P/2P pairs
  • fraction_good_fit / fraction_explained_variance: not populated (older 3-col matched_corrlist.mat format)

🧠 Cell Spatial Features

Modality Cells with spatial data
1P 810
2P 677

🐾 Behavioral Traces

  • 8,001 rows of behavioral data
  • Columns: sample_idx, stimulus_on, velocity, position, lick, reward, photodiode (empty), legacy_recording_id

⚡ Spike / Event Data

  • Paired event concordance (v2): 605 pairs ✅
  • Temporal correlations: 605 pairs ✅
  • Event detection metrics v2: ❌ not populated for this session
  • Cell signal quality: ❌ not populated for this session

📌 Stimulus Metadata

  • ❌ Not in Airtable (session_stimulus_metadata is empty for this session — predates Airtable integration)

SQL used (key query):

-- Session info
SELECT session_id, subject_id, session_date, session_number
FROM core.dim_sessions WHERE session_id = 'm225-20210409-s01';

-- Recordings
SELECT recording_id, modality, framerate_hz, depth_um
FROM core.dim_neural_recordings WHERE session_id = 'm225-20210409-s01';

-- Matched pairs
SELECT COUNT(*), AVG(correlation_coefficient)
FROM prj_multiscope_1p2p.matched_cells WHERE session_id = 'm225-20210409-s01';

Summary: This session has paired 1P+2P recordings at 59.9 µm depth, 605 matched cell pairs, behavioral data (stimulus, velocity, position, lick/reward), spatial features for ~700–800 cells, and spike concordance data. No Airtable stimulus metadata, and FGF/FEV fit quality metrics are unavailable (older corrlist format). Good candidate for trace visualization and matched-pair analysis.

$1.0589