query
Run read-only SQL queries to explore rare-variant, gene-based association results across 1.2M individuals from 10 global biobanks for any gene, trait, or ancestry.
Instructions
Run read-only SQL over the whole BRaVa gene-level results table.
61.8 million rows: every gene x trait x variant-mask x MAF-cutoff x ancestry cell, with the Burden, SKAT and SKAT-O p-values, the effect size and its standard error, and the cross-cohort heterogeneity test. Local, so a query costs no network.
Call schema() first. It returns the tables, the columns, worked query
templates, and the semantic traps that make a syntactically valid query
scientifically wrong here. Several of them invert the answer rather than
degrade it.
Query the results view rather than the raw tables: it exposes p-values
instead of -log10, and labels instead of integer codes, so the obvious query
is also the correct one.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | One read-only statement (SELECT / WITH / DESCRIBE / SHOW / EXPLAIN). Combine steps with a CTE rather than sending several statements. | |
| max_rows | No | Rows returned (default 50, capped 500). The response is also capped at 25,000 characters, so select the columns you need. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |