Binding affinities (Kd) — source-verified (view)

Data license: CC BY 4.0 · Data source: apt-scout automated curation pipeline (E. Dohi, NCNP) — values harvested from public databases; raw source stored per target

target_name_canonical

Target as named in the source paper.

target_type

protein / cell-line+EV / glycan-conjugate. Filter to 'protein' for molecular targets.

target_uniprot

UniProt accession when a human protein (sparse for now; links to apt-scout target).

aptamer_name

Aptamer identifier as reported.

kd_reported

Kd value AS REPORTED in the paper (value + unit). Units are MIXED — do NOT compare this column directly.

kd_log10_molar

log10(Kd in molar). THE column to sort / compare / learn on (lower = tighter).

measurement_class

intrinsic = equilibrium vs purified target; non_intrinsic = apparent/cellular or avidity (NOT comparable to intrinsic).

binding_constant_type

Kd / apparent-Kd etc. as reported.

assay_method

SPR / filter binding / flow cytometry / ITC / BLI …

assay_temperature_k

Assay temperature (K) — a reason the same pair can have several rows.

source_pmid

PubMed ID of the source paper (links out).

verbatim_quote

The exact sentence the value was taken from.

verification_level

QC status (honest, growing): human_verified / human_corrected = a logged human verdict from the stratified-random sample; multi_agent_verified = passed independent multi-agent (L2) check; extraction_verified = extraction-pipeline verified; automated. Human verification is in progress: as of this release 0 records carry a logged human verdict — the published set is multi-agent-/extraction-verified, and human spot-checking is being added post-publication (version-tracked). No record is labelled human_verified without a logged human review.

sequence_status

Aptamer-sequence provenance: verified_in_text_or_SI = sequence verbatim-verified against the source text/SI (shown); pending_manual_supp / pending_supp_oa / pending_manual_figure = sequence reported only in a (often paywalled) SI or a figure, being curated post-submission; no_single_sequence_pool = a pool/library/primer, no single sequence exists.

pi_provenance_flag

PI manual-review flag: KEEP_seq_in_figure = valid record, sequence is in a 3D-structure figure; FLAG_cited_data = Kd may be a value cited from elsewhere, re-verify. (EXCLUDE rows are hidden from this view.)

seq_source

original (already in source DB) / backfill_text_verified (recovered from paper or SI text).

8 rows where assay_method = "flow_cytometry", measurement_class = "non_intrinsic" and sequence_status = "pending_manual_figure" sorted by kd_log10_molar

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: target_name_canonical, assay_buffer, aptamer_chemistry, aptamer_modifications, source_pmid, doi

CREATE VIEW v_kd AS
SELECT k.id,
 target_name_canonical,
 CASE
   WHEN target_name_canonical LIKE '%cell%' OR target_name_canonical LIKE '%vesicle%' OR target_name_canonical LIKE '%exosome%' THEN 'cell/EV'
   WHEN target_name_canonical LIKE '%BSA%' OR target_name_canonical LIKE '%sLe%' OR target_name_canonical LIKE '%glycan%' OR target_name_canonical LIKE '% Le %' THEN 'glycan/conjugate'
   ELSE 'protein'
 END AS target_type,
 target_uniprot, aptamer_name, aptamer_seq,
 (COALESCE(kd_value,'') || CASE WHEN COALESCE(kd_unit,'')!='' THEN ' '||kd_unit ELSE '' END) AS kd_reported,
 CAST(NULLIF(kd_log10_molar,'') AS REAL) AS kd_log10_molar,
 measurement_class, binding_constant_type, 'Gold' AS tier, k.tier AS source_origin,
 CASE
   WHEN vh.verdict='confirmed' THEN 'human_verified'
   WHEN vh.verdict='corrected' THEN 'human_corrected'
   WHEN vh.verdict='rejected'  THEN 'human_rejected'
   WHEN k.verification_status='agent_verified_L2' THEN 'multi_agent_verified'
   WHEN k.verification_status IN ('verified','CONFIRM') THEN 'extraction_verified'
   ELSE 'automated'
 END AS verification_level,
 sequence_status, seq_source, pi_provenance_flag,
 assay_method,
 CAST(NULLIF(assay_temperature_k,'') AS REAL) AS assay_temperature_k,
 CAST(NULLIF(assay_ph,'') AS REAL) AS assay_ph,
 assay_buffer, assay_cations, aptamer_chemistry, aptamer_modifications,
 source_pmid, doi, verbatim_quote, source_db
FROM kd_measurements k LEFT JOIN verification_human vh ON vh.row_id=k.source_record_id
WHERE LOWER(COALESCE(k.include_in_gold,''))='true';