dim_samples
Sample metadata for each physical sample in the experiment. Combines sample run execution data with plan-level identifiers and antigen information. Grain: one row persample_id.
Key relationships:
sample_idjoins toaligned_reads.sample_id,labeling_candidates_data.sample_id.- Binding samples (
selection = true) correspond tobinding_umi_counts.binding_sample_id. - Expression samples (
selection = false) correspond toexpression_umi_counts.expression_sample_id.
labeling_candidates_data
Candidate designs enriched with sample-run metadata, antigen information, and selection status. This table connects customer-provided candidate names and sequences with the experimental conditions under which they were tested. Grain: one row per(sample_id, candidate_id, sino_catalog_id, antigen_concentration_nM).
Key relationships:
sample_idjoins todim_samples.sample_id.candidate_idis the shared candidate key across all tables.candidate_nameis the customer-provided name that maps to the internalcandidate_id.
aligned_reads
Full-length aligned reads with non-null UMI, filtered to the latest sequencing task attempt per sample and candidate. Joins alignment metrics with read sequences. Grain: one row per(read_id, sample_id).
Key relationships:
sample_idjoins todim_samples.sample_id.candidate_idis the shared candidate key across all tables.
binding_umi_counts
Per-UMI read counts for binding samples (samples whereselection = true). Each row represents a unique combination of binding sample, candidate, variant, and UMI.
Grain: one row per (binding_sample_id, candidate_id, variant_id, umi).
Key relationships:
binding_sample_idcorresponds todim_samples.sample_idwhereselection = true.candidate_idis the shared candidate key across all tables.
expression_umi_counts
Per-UMI read counts for expression samples (samples whereselection = false). Structure mirrors binding_umi_counts.
Grain: one row per (expression_sample_id, candidate_id, variant_id, umi).
Key relationships:
expression_sample_idcorresponds todim_samples.sample_idwhereselection = false.candidate_idis the shared candidate key across all tables.

