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

▶ clickhouse_run_select_query
{
 "query": "SELECT type_of_cancer_id, name FROM type_of_cancer ORDER BY name",
 "max_rows": 300
}

◀ result
{"rows":[{"type_of_cancer_id":"alklbcl","name":"ALK Positive Large B-Cell Lymphoma"},{"type_of_cancer_id":"amlrbm15mkl1","name":"AML (megakaryoblastic) with t(1;22)(p13.3;q13.3);RBM15-MKL1"},{"type_of_cancer_id":"amlbcrabl1","name":"AML with BCR-ABL1"},{"type_of_cancer_id":"amlcebpa","name":"AML with Biallelic Mutations of CEBPA"},{"type_of_cancer_id":"am","name":"AML with Maturation"},{"type_of_cancer_id":"amlmd","name":"AML with Minimal Differentiation"},{"type_of_cancer_id":"amlnpm1","name":"AML with Mutated NPM1"},{"type_of_cancer_id":"amlrunx1","name":"AML with Mutated RUNX1"},{"type_of_cancer_id":"amlmrc","name":"AML with Myelodysplasia-Related Changes"},{"type_of_cancer_id":"amlrga","name":"AML with Recurrent Genetic Abnormalities"},{"type_of_cancer_id":"amlrara","name":"AML with Variant RARA translocation"},{"type_of_cancer_id":"amlcbfbmyh11","name":"AML with inv(16)(p13.1q22) or t(16;16)(p13.1;q22);CBFB-MYH11"},{"type_of_cancer_id":"amlgata2mecom","name":"AML with inv(3)(q21.3q26.2) or t(3;3)(q21.3;q26.2); GATA2, MECOM"},{"type_of_cancer_id":"amldeknup214","name":"AML with t(6;9)(p23;q34.1);DEK-NUP214"},{"type_of_cancer_id":"amlrunx1runx1t1","name":"AML with t(8;21)(q22;q22.1);RUNX1-RUNX1T1"},{"type_of_cancer_id":"amlmllt3kmt2a","name":"AML with t(9;11)(p21.3;q23.3);MLLT3-KMT2A"},{"type_of_cancer_id":"awm","name":"AML without Maturation"},{"type_of_cancer_id":"amlnos","name":"AML, NOS"},{"type_of_cancer_id":"aplpmlrara","name":"APL with PML-RARA"},{"type_of_cancer_id":"paac","name":"Acinar Cell Carcinoma of the Pancreas"},{"type_of_cancer_id":"acn","name":"Acinar Cell Carcinoma, NOS"},{"type_of_cancer_id":"accc","name":"Acinic Cell Carcinoma"},{"type_of_cancer_id":"acrm","name":"Acral Melanoma"},{"type_of_cancer_id":"abc","name":"Activated B-cell Type"},{"type_of_cancer_id":"abl","name":"Acute Basophilic Leukemia"},{"type_of_cancer_id":"alal","name":"Acute Leukemias of Ambiguous Lineage"},{"type_of_cancer_id":"amkl","name":"Acute Megakaryoblastic Leukemia"},{"type_of_cancer_id":"amol","name":"Acute Monoblastic/Monocytic Leukemia"},{"type_of_cancer_id":"aml","name":"Acute Myeloid Leukemia"},{"type_of_cancer_id":"amml","name":"Acute Myelomonocytic Leukemia"},{"type_of_cancer_id":"apmf","name":"Acute Panmyelosis with Myelofibrosis"},{"type_of_cancer_id":"aul","name":"Acute Undifferentiated Leukemia"},{"type_of_cancer_id":"adma","name":"Adamantinoma"},{"type_of_cancer_id":"ais","name":"Adenocarcinoma In Situ"},{"type_of_cancer_id":"arch","name":"Adenocarcinoma in Retrorectal Cystic Hamartoma"},{"type_of_cancer_id":"gej","name":"Adenocarcinoma of the Gastroesophageal Junction"},{"type_of_cancer_id":"adnos","name":"Adenocarcinoma, NOS"},{"type_of_cancer_id":"acbc","name":"Adenoid Cystic Breast Cancer"},{"type_of_cancer_id":"acyc","name":"Adenoid Cystic Carcinoma"},{"type_of_cancer_id":"aclg","name":"Adenoid Cystic Carcinoma of the Lacrimal Gland"},{"type_of_cancer_id":"luacc","name":"Adenoid Cystic Carcinoma of the Lung"},{"type_of_cancer_id": … (18381 more chars)

▶ clickhouse_run_select_query
{
 "query": "SELECT count(*) AS total_oncotree_codes FROM type_of_cancer"
}

◀ result
{"rows":[{"total_oncotree_codes":897}]}

▶ clickhouse_run_select_query
{
 "query": "
SELECT tc.type_of_cancer_id, tc.name, count(*) AS num_studies, sum(tc.dedicated_color != '') AS has_color
FROM cancer_study cs
JOIN type_of_cancer tc ON cs.type_of_cancer_id = tc.type_of_cancer_id
GROUP BY tc.type_of_cancer_id, tc.name
ORDER BY num_studies DESC
LIMIT 40
"
}

◀ result
{"rows":[{"tc.type_of_cancer_id":"mixed","tc.name":"Mixed Cancer Types","num_studies":48,"has_color":48},{"tc.type_of_cancer_id":"brca","tc.name":"Invasive Breast Carcinoma","num_studies":27,"has_color":27},{"tc.type_of_cancer_id":"prad","tc.name":"Prostate Adenocarcinoma","num_studies":25,"has_color":25},{"tc.type_of_cancer_id":"difg","tc.name":"Diffuse Glioma","num_studies":20,"has_color":20},{"tc.type_of_cancer_id":"blca","tc.name":"Bladder Urothelial Carcinoma","num_studies":18,"has_color":18},{"tc.type_of_cancer_id":"luad","tc.name":"Lung Adenocarcinoma","num_studies":17,"has_color":17},{"tc.type_of_cancer_id":"coadread","tc.name":"Colorectal Adenocarcinoma","num_studies":16,"has_color":16},{"tc.type_of_cancer_id":"soft_tissue","tc.name":"Soft Tissue","num_studies":13,"has_color":13},{"tc.type_of_cancer_id":"hcc","tc.name":"Hepatocellular Carcinoma","num_studies":12,"has_color":12},{"tc.type_of_cancer_id":"ucec","tc.name":"Endometrial Carcinoma","num_studies":12,"has_color":12},{"tc.type_of_cancer_id":"skcm","tc.name":"Cutaneous Melanoma","num_studies":12,"has_color":12},{"tc.type_of_cancer_id":"ccrcc","tc.name":"Renal Clear Cell Carcinoma","num_studies":10,"has_color":10},{"tc.type_of_cancer_id":"paad","tc.name":"Pancreatic Adenocarcinoma","num_studies":10,"has_color":10},{"tc.type_of_cancer_id":"aml","tc.name":"Acute Myeloid Leukemia","num_studies":9,"has_color":9},{"tc.type_of_cancer_id":"nsclc","tc.name":"Non-Small Cell Lung Cancer","num_studies":9,"has_color":9},{"tc.type_of_cancer_id":"chol","tc.name":"Cholangiocarcinoma","num_studies":8,"has_color":8},{"tc.type_of_cancer_id":"stad","tc.name":"Stomach Adenocarcinoma","num_studies":8,"has_color":8},{"tc.type_of_cancer_id":"hnsc","tc.name":"Head and Neck Squamous Cell Carcinoma","num_studies":8,"has_color":8},{"tc.type_of_cancer_id":"breast","tc.name":"Breast","num_studies":8,"has_color":8},{"tc.type_of_cancer_id":"mel","tc.name":"Melanoma","num_studies":7,"has_color":7},{"tc.type_of_cancer_id":"acyc","tc.name":"Adenoid Cystic Carcinoma","num_studies":7,"has_color":7},{"tc.type_of_cancer_id":"nbl","tc.name":"Neuroblastoma","num_studies":6,"has_color":6},{"tc.type_of_cancer_id":"cllsll","tc.name":"Chronic Lymphocytic Leukemia/Small Lymphocytic Lymphoma","num_studies":6,"has_color":6},{"tc.type_of_cancer_id":"prostate","tc.name":"Prostate","num_studies":6,"has_color":6},{"tc.type_of_cancer_id":"dlbclnos","tc.name":"Diffuse Large B-Cell Lymphoma, NOS","num_studies":6,"has_color":6},{"tc.type_of_cancer_id":"egc","tc.name":"Esophagogastric Adenocarcinoma","num_studies":6,"has_color":6},{"tc.type_of_cancer_id":"lusc","tc.name":"Lung Squamous Cell Carcinoma","num_studies":6,"has_color":6},{"tc.type_of_cancer_id":"coad","tc.name":"Colon Adenocarcinoma","num_studies":5,"has_color":5},{"tc.type_of_cancer_id":"ihch","tc.name":"Intrahepatic Cholangiocarcinoma","num_studies":5,"has_color":5},{"tc.type_of_cancer_id":"plmeso","tc.name":"Pleural Mesothelioma","num_studies":5,"has_color":5},{"tc.type_of_ … (957 more chars)

═ answer (success)
cBioPortal's database (via the ClickHouse backend used here) covers essentially the full spectrum of human cancer, organized through the OncoTree classification system:

**Scale:**
- **897 distinct OncoTree cancer type/subtype codes** — from broad tissue categories down to fine histologic and molecular subtypes (e.g., separate codes for "Astrocytoma, IDH-Mutant, Grade 2" vs. "Grade 3" vs. "Grade 4").
- These codes are organized under a much smaller number of top-level tissue lineages (breast, lung, CNS/brain, hematopoietic, GI, GU, skin, soft tissue, etc.).

**Most heavily studied cancer types** (by number of distinct cBioPortal studies):
| Cancer type | # Studies |
|---|---|
| Mixed Cancer Types (pan-cancer cohorts) | 48 |
| Invasive Breast Carcinoma | 27 |
| Prostate Adenocarcinoma | 25 |
| Diffuse Glioma | 20 |
| Bladder Urothelial Carcinoma | 18 |
| Lung Adenocarcinoma | 17 |
| Colorectal Adenocarcinoma | 16 |
| Hepatocellular Carcinoma, Endometrial Carcinoma, Cutaneous Melanoma | 12 each |
| Renal Clear Cell Carcinoma, Pancreatic Adenocarcinoma | 10 each |
| Acute Myeloid Leukemia, Non-Small Cell Lung Cancer | 9 each |

Beyond these, the database includes many rarer entities — sarcomas (Ewing sarcoma, rhabdomyosarcoma, chondrosarcoma), pediatric tumors (neuroblastoma, medulloblastoma), hematologic malignancies (dozens of leukemia/lymphoma subtypes), and numerous rare carcinomas.

If you'd like, I can:
- Show the full list of top-level tissue categories,
- Search for a specific cancer type/subtype, or
- Take you to the [cBioPortal homepage](https://www.cbioportal.org) to browse all studies by cancer type interactively.

Which would be most useful?