Q (haiku): What kind of cancer are there in the database? ▶ clickhouse_list_tables {} ◀ result {"tables":[{"name":"allele_specific_copy_number"},{"name":"alteration_driver_annotation"},{"name":"cancer_study"},{"name":"cancer_study_query_preferences"},{"name":"cancer_study_tags"},{"name":"cbioportal_sequence_state"},{"name":"clinical_attribute_counts"},{"name":"clinical_attribute_meta"},{"name":"clinical_data_derived"},{"name":"clinical_event"},{"name":"clinical_event_data"},{"name":"clinical_event_data_derived"},{"name":"clinical_event_derived"},{"name":"clinical_patient"},{"name":"clinical_sample"},{"name":"cna_event"},{"name":"cna_panel_gene_coverage"},{"name":"cna_wes_coverage"},{"name":"co_altered_genes_in_study"},{"name":"copy_number_seg"},{"name":"copy_number_seg_file"},{"name":"gene"},{"name":"gene_alias"},{"name":"gene_alteration_frequency_by_cancer_type"},{"name":"gene_cna_distribution_in_study"},{"name":"gene_mutation_frequency_by_cancer_type"},{"name":"gene_mutation_frequency_in_studies"},{"name":"gene_mutation_frequency_in_study"},{"name":"gene_mutation_variants_in_study"},{"name":"gene_pair_coexpression"},{"name":"gene_panel"},{"name":"gene_panel_list"},{"name":"gene_panel_to_gene_derived"},{"name":"generic_assay_data_derived"},{"name":"generic_assay_meta_derived"},{"name":"generic_assay_profile_entity_derived"},{"name":"generic_entity_properties"},{"name":"geneset"},{"name":"geneset_gene"},{"name":"geneset_hierarchy_leaf"},{"name":"geneset_hierarchy_node"},{"name":"genetic_alteration"},{"name":"genetic_alteration_derived"},{"name":"genetic_entity"},{"name":"genetic_profile"},{"name":"genetic_profile_link"},{"name":"genetic_profile_samples"},{"name":"genomic_event_derived"},{"name":"gistic"},{"name":"gistic_to_gene"},{"name":"info"},{"name":"mut_sig"},{"name":"mutation"},{"name":"mutation_count_by_keyword"},{"name":"mutation_derived"},{"name":"mutation_event"},{"name":"mutation_panel_gene_coverage"},{"name":"mutation_wes_coverage"},{"name":"patient"},{"name":"reference_genome"},{"name":"reference_genome_gene"},{"name":"resource_definition"},{"name":"resource_patient"},{"name":"resource_sample"},{"name":"resource_study"},{"name":"sample"},{"name":"sample_cna_event"},{"name":"sample_derived"},{"name":"sample_list"},{"name":"sample_list_list"},{"name":"sample_profile"},{"name":"sample_to_gene_panel_derived"},{"name":"structural_variant"},{"name":"sv_panel_gene_coverage"},{"name":"sv_wes_coverage"},{"name":"top_cna_genes_in_study"},{"name":"top_mutated_genes_in_cohort"},{"name":"top_mutated_genes_in_study"},{"name":"top_sv_genes_in_study"},{"name":"treatment_counts_in_study"},{"name":"treatment_regimens_in_study"},{"name":"type_of_cancer"}]} ▶ clickhouse_run_select_query { "query": " SELECT type_of_cancer_id, name, tissue, color, parent_type_of_cancer_id FROM type_of_cancer ORDER BY name LIMIT 100 ", "max_rows": 100 } ◀ result {"error_message":"Query execution failed: HTTPDriver for https://dl96orhu96.us-east-1.aws.clickhouse.cloud:8443 received ClickHouse error code 47\n Code: 47. DB::Exception: Unknown expression identifier `color` in scope SELECT type_of_cancer_id, name, tissue, color, parent_type_of_cancer_id FROM type_of_cancer ORDER BY name ASC LIMIT 100. (UNKNOWN_IDENTIFIER) (version 26.4.1.2359 (official build))\n"} ▶ 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 type_of_cancer_id, name, tissue, main_type, level FROM type_of_cancer ORDER BY tissue, main_type, name ", "max_rows": 200 } ◀ result {"rows":[{"type_of_cancer_id":"adrenal_gland","name":"Adrenal Gland","tissue":"Adrenal Gland","main_type":"Adrenal Gland Cancer","level":1},{"type_of_cancer_id":"aca","name":"Adrenocortical Adenoma","tissue":"Adrenal Gland","main_type":"Adrenocortical Adenoma","level":2},{"type_of_cancer_id":"acc","name":"Adrenocortical Carcinoma","tissue":"Adrenal Gland","main_type":"Adrenocortical Carcinoma","level":2},{"type_of_cancer_id":"phc","name":"Pheochromocytoma","tissue":"Adrenal Gland","main_type":"Pheochromocytoma","level":2},{"type_of_cancer_id":"ampca","name":"Ampullary Carcinoma","tissue":"Ampulla of Vater","main_type":"Ampullary Cancer","level":2},{"type_of_cancer_id":"iampca","name":"Intestinal Ampullary Carcinoma","tissue":"Ampulla of Vater","main_type":"Ampullary Cancer","level":3},{"type_of_cancer_id":"mampca","name":"Mixed Ampullary Carcinoma","tissue":"Ampulla of Vater","main_type":"Ampullary Cancer","level":3},{"type_of_cancer_id":"pampca","name":"Pancreatobiliary Ampullary Carcinoma","tissue":"Ampulla of Vater","main_type":"Ampullary Cancer","level":3},{"type_of_cancer_id":"ampulla_of_vater","name":"Ampulla of Vater","tissue":"Ampulla of Vater","main_type":"Ampullary Carcinoma","level":1},{"type_of_cancer_id":"biliary_tract","name":"Biliary Tract","tissue":"Biliary Tract","main_type":"Biliary Tract Cancer","level":1},{"type_of_cancer_id":"gbasc","name":"Adenosquamous Carcinoma of the Gallbladder","tissue":"Biliary Tract","main_type":"Hepatobiliary Cancer","level":4},{"type_of_cancer_id":"chol","name":"Cholangiocarcinoma","tissue":"Biliary Tract","main_type":"Hepatobiliary Cancer","level":3},{"type_of_cancer_id":"ehch","name":"Extrahepatic Cholangiocarcinoma","tissue":"Biliary Tract","main_type":"Hepatobiliary Cancer","level":4},{"type_of_cancer_id":"gbad","name":"Gallbladder Adenocarcinoma, NOS","tissue":"Biliary Tract","main_type":"Hepatobiliary Cancer","level":4},{"type_of_cancer_id":"gbc","name":"Gallbladder Cancer","tissue":"Biliary Tract","main_type":"Hepatobiliary Cancer","level":3},{"type_of_cancer_id":"icpn","name":"Intracholecystic Papillary Neoplasm","tissue":"Biliary Tract","main_type":"Hepatobiliary Cancer","level":2},{"type_of_cancer_id":"ipn","name":"Intraductal Papillary Neoplasm of the Bile Duct","tissue":"Biliary Tract","main_type":"Hepatobiliary Cancer","level":2},{"type_of_cancer_id":"ihch","name":"Intrahepatic Cholangiocarcinoma","tissue":"Biliary Tract","main_type":"Hepatobiliary Cancer","level":4},{"type_of_cancer_id":"phch","name":"Perihilar Cholangiocarcinoma","tissue":"Biliary Tract","main_type":"Hepatobiliary Cancer","level":4},{"type_of_cancer_id":"scgbc","name":"Small Cell Gallbladder Carcinoma","tissue":"Biliary Tract","main_type":"Hepatobiliary Cancer","level":4},{"type_of_cancer_id":"blad","name":"Bladder Adenocarcinoma","tissue":"Bladder/Urinary Tract","main_type":"Bladder Cancer","level":2},{"type_of_cancer_id":"blsc","name":"Bladder Squamous Cell Carcinoma","tissue":"Bladder/Urinary Tract","main_type":"Bl … (23273 more chars) ═ answer (success) The database contains a comprehensive set of **cancer types** organized by anatomical tissue and cancer classification. Here's a summary of the major cancer types available: ## Major Cancer Type Categories **Adrenal/Endocrine:** - Adrenocortical Carcinoma, Pheochromocytoma **Gastrointestinal:** - Colorectal Cancer, Gastric Cancer, Small Bowel Cancer - Anal Cancer, Appendiceal Cancer - Esophageal Cancer, Hepatocellular Carcinoma - Pancreatic Cancer, Biliary Tract Cancer **Genitourinary:** - Bladder/Urinary Tract Cancer - Prostate Cancer, Renal Cell Carcinoma - Urethral Cancer **Breast & Gynecologic:** - Breast Cancer (multiple subtypes: IDC, ILC, inflammatory, metaplastic, etc.) - Ovarian Cancer, Uterine Cancer - Cervical Cancer, Vaginal Cancer - Endometrial Cancer **CNS/Brain:** - Glioblastoma, Glioma (multiple grades and molecular subtypes) - Medulloblastoma, Ependymoma - Meningioma, Brain Stem Glioma - Embryonal Tumors **Head & Neck:** - Oral/Oropharyngeal Squamous Cell Carcinoma - Laryngeal Cancer, Salivary Gland Cancer - Thyroid Cancer (papillary, follicular, anaplastic) **Lung:** - Lung Adenocarcinoma, Lung Squamous Cell Carcinoma - Small Cell Lung Cancer **Hematologic:** - Acute Myeloid Leukemia, Acute Lymphoblastic Leukemia - Chronic Myeloid Leukemia, Chronic Lymphocytic Leukemia - Hodgkin Lymphoma, Non-Hodgkin Lymphoma - Multiple Myeloma **Musculoskeletal:** - Osteosarcoma, Ewing Sarcoma, Chondrosarcoma - Bone Sarcoma (various subtypes) **Skin:** - Melanoma (cutaneous, uveal, mucosal) - Merkel Cell Carcinoma, Basal Cell Carcinoma **Soft Tissue & Other:** - Angiosarcoma, Mesothelioma - Neurofibromatosis-associated tumors - Pediatric cancers (TARGET) The database uses **OncoTree classification**, a standardized hierarchical ontology. You can search for specific cancer types by code (e.g., LUAD = Lung Adenocarcinoma) or name. Would you like me to help you explore specific cancer types, studies, or molecular data?