Q (sonnet): What kind of cancer are there in the database?

▶ clickhouse_list_table_columns
{
 "table": "type_of_cancer"
}

◀ result
{"columns":[{"name":"type_of_cancer_id","type":"String"},{"name":"name","type":"String"},{"name":"dedicated_color","type":"String"},{"name":"short_name","type":"Nullable(String)"},{"name":"parent","type":"Nullable(String)"},{"name":"main_type","type":"String","comment":"Broad OncoTree grouping (e.g. Non-Small Cell Lung Cancer, Glioma). Useful for grouping related subtypes."},{"name":"tissue","type":"String","comment":"Tissue of origin (e.g. Lung, CNS/Brain, Breast). Top-level anatomical grouping."},{"name":"level","type":"UInt8","comment":"Depth in OncoTree hierarchy: 1 = tissue, 2-6 = increasingly specific subtypes. Lower = broader."},{"name":"revocations","type":"Array(String)","comment":"Deprecated OncoTree codes that this code replaces (e.g. BLL replaces ALL, GB replaces GBM). Search here when a user code is not found."},{"name":"precursors","type":"Array(String)","comment":"Previous codes merged into this code (e.g. CLLSLL merges CLL and SLL). Similar to revocations but for code merges."}]}

▶ clickhouse_run_select_query
{
 "query": "
SELECT tissue, count() AS num_studies, sum(cs.sample_count) AS total_samples
FROM cancer_study cs
JOIN type_of_cancer toc ON cs.type_of_cancer_id = toc.type_of_cancer_id
GROUP BY tissue
ORDER BY total_samples DESC
",
 "max_rows": 100
}

◀ result
{"rows":[{"tissue":"Other","num_studies":48,"total_samples":236162},{"tissue":"Breast","num_studies":38,"total_samples":24348},{"tissue":"Bowel","num_studies":29,"total_samples":17068},{"tissue":"Myeloid","num_studies":18,"total_samples":16579},{"tissue":"Lung","num_studies":41,"total_samples":15910},{"tissue":"Soft Tissue","num_studies":27,"total_samples":14322},{"tissue":"Prostate","num_studies":31,"total_samples":14076},{"tissue":"CNS/Brain","num_studies":34,"total_samples":10071},{"tissue":"Lymphoid","num_studies":30,"total_samples":9134},{"tissue":"Bladder/Urinary Tract","num_studies":27,"total_samples":6730},{"tissue":"Kidney","num_studies":25,"total_samples":6214},{"tissue":"Esophagus/Stomach","num_studies":22,"total_samples":5623},{"tissue":"Uterus","num_studies":19,"total_samples":5246},{"tissue":"Pancreas","num_studies":21,"total_samples":5189},{"tissue":"Skin","num_studies":28,"total_samples":4592},{"tissue":"Liver","num_studies":14,"total_samples":4072},{"tissue":"Head and Neck","num_studies":18,"total_samples":3779},{"tissue":"Biliary Tract","num_studies":18,"total_samples":3366},{"tissue":"Ovary/Fallopian Tube","num_studies":11,"total_samples":3263},{"tissue":"Peripheral Nervous System","num_studies":10,"total_samples":2467},{"tissue":"Thyroid","num_studies":6,"total_samples":2334},{"tissue":"Cervix","num_studies":4,"total_samples":1093},{"tissue":"Bone","num_studies":4,"total_samples":671},{"tissue":"Testis","num_studies":5,"total_samples":662},{"tissue":"Thymus","num_studies":4,"total_samples":403},{"tissue":"Eye","num_studies":6,"total_samples":365},{"tissue":"Pleura","num_studies":5,"total_samples":297},{"tissue":"Adrenal Gland","num_studies":3,"total_samples":276},{"tissue":"Ampulla of Vater","num_studies":1,"total_samples":160},{"tissue":"Vulva/Vagina","num_studies":1,"total_samples":15}]}

═ answer (success)
The database currently contains **~600 cancer studies spanning nearly 30 tissue/organ groupings**, covering essentially the full range of adult and pediatric solid and hematologic malignancies. Here's the breakdown by tissue of origin (studies / total samples, note: sample totals can double-count patients appearing in multiple overlapping cohorts):

| Tissue | # Studies | Total Samples |
|---|---|---|
| Other (pan-cancer, mixed, rare, pediatric pan-tumor cohorts) | 48 | 236,162 |
| Breast | 38 | 24,348 |
| Bowel (colorectal) | 29 | 17,068 |
| Myeloid (leukemias) | 18 | 16,579 |
| Lung | 41 | 15,910 |
| Soft Tissue (sarcomas) | 27 | 14,322 |
| Prostate | 31 | 14,076 |
| CNS/Brain | 34 | 10,071 |
| Lymphoid (lymphomas/ALL) | 30 | 9,134 |
| Bladder/Urinary Tract | 27 | 6,730 |
| Kidney | 25 | 6,214 |
| Esophagus/Stomach | 22 | 5,623 |
| Uterus | 19 | 5,246 |
| Pancreas | 21 | 5,189 |
| Skin (incl. melanoma) | 28 | 4,592 |
| Liver | 14 | 4,072 |
| Head and Neck | 18 | 3,779 |
| Biliary Tract | 18 | 3,366 |
| Ovary/Fallopian Tube | 11 | 3,263 |
| Peripheral Nervous System (e.g. neuroblastoma) | 10 | 2,467 |
| Thyroid | 6 | 2,334 |
| Cervix | 4 | 1,093 |
| Bone | 4 | 671 |
| Testis | 5 | 662 |
| Thymus | 4 | 403 |
| Eye (e.g. uveal melanoma) | 6 | 365 |
| Pleura (mesothelioma) | 5 | 297 |
| Adrenal Gland | 3 | 276 |
| Ampulla of Vater | 1 | 160 |
| Vulva/Vagina | 1 | 15 |

Within each tissue, studies are further organized into specific histologic subtypes using the OncoTree classification (e.g., under "Lung" you'll find lung adenocarcinoma, squamous cell carcinoma, small cell lung cancer, etc.).

If you'd like to explore a specific cancer type or tissue, I can pull up the matching studies — just let me know which one interests you, or browse the full list yourself at [cBioPortal Studies](https://www.cbioportal.org/study).