Skip to main content
These are the underlying raw data tables snapshotted from the sequencing and alignment pipeline. Each table is stored as a directory of Parquet files.

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 per sample_id. Key relationships:
  • sample_id joins to aligned_reads.sample_id, labeling_candidates_data.sample_id.
  • Binding samples (selection = true) correspond to binding_umi_counts.binding_sample_id.
  • Expression samples (selection = false) correspond to expression_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_id joins to dim_samples.sample_id.
  • candidate_id is the shared candidate key across all tables.
  • candidate_name is the customer-provided name that maps to the internal candidate_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_id joins to dim_samples.sample_id.
  • candidate_id is the shared candidate key across all tables.

binding_umi_counts

Per-UMI read counts for binding samples (samples where selection = 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_id corresponds to dim_samples.sample_id where selection = true.
  • candidate_id is the shared candidate key across all tables.

expression_umi_counts

Per-UMI read counts for expression samples (samples where selection = false). Structure mirrors binding_umi_counts. Grain: one row per (expression_sample_id, candidate_id, variant_id, umi). Key relationships:
  • expression_sample_id corresponds to dim_samples.sample_id where selection = false.
  • candidate_id is the shared candidate key across all tables.