Q (sonnet): show me gbm with mgmt hypermethylation ▶ list_guides {} ▶ resolve_and_route { "studyKeywords": [ "glioblastoma", "TCGA" ] } ◀ result {"result":[{"uri":"cbioportal://mutation-frequency-guide","description":"Comprehensive guide for calculating gene mutation frequencies with gene-specific profiling denominators"},{"uri":"cbioportal://clinical-data-guide","description":"Guide for querying clinical data including patient vs sample level considerations"},{"uri":"cbioportal://sample-filtering-guide","description":"Guide for filtering samples and studies in cBioPortal queries"},{"uri":"cbioportal://common-pitfalls","description":"Guide to avoid common mistakes when querying cBioPortal data. If you already know which numbered pitfall applies, fetch just that section via read_guide(\"cbioportal://common-pitfalls#\") (e.g. #16) instead of the full guide"},{"uri":"cbioportal://treatment-guide","description":"Guide for querying treatment/clinical event data including drug agents, timelines, and linking to genomic data"},{"uri":"cbioportal://faq-guide","description":"General cBioPortal FAQ: history, how to cite, data types, reference genome, abbreviations, GISTIC thresholds, API access"},{"uri":"cbioportal://statistical-tests-guide","description":"Statistical test selection guide — decision matrix for choosing Fisher's exact, Wilcoxon, chi-squared, t-test, ANOVA, etc. based on data type and group count"},{"uri":"cbioportal://gene-expression-guide","description":"Gene expression / copy-number / methylation analysis. Covers genetic_alteration_derived, profile_type discovery, and the gene_pair_coexpression view for Spearman correlation between two genes"},{"uri":"cbioportal://external-resources-guide","description":"Guide for finding external linked resources such as imaging, pathology, Minerva, HTAN, or other resource_* table links before declaring data unavailable"},{"uri":"cbioportal://gene-resolution-guide","description":"Guide for resolving ambiguous gene symbols, aliases, gene families, and shorthand such as CD3 before querying expression or alteration data"},{"uri":"cbioportal://study-resolution-guide","description":"Guide for resolving requested studies, avoiding silent substitute cohorts, and redirecting to known external cBioPortal instances when data is not in this deployment"},{"uri":"cbioportal://germline-guide","description":"Guide for querying germline variant data — storage columns, study discovery, query patterns, and somatic vs germline considerations"},{"uri":"cbioportal://study-guide/{study_id}","description":"Dynamic study-specific guide - use get_study_guide(study_id) tool to generate"}]} ◀ result {"success":true,"message":"Found 5 matching studies. Pick the best match (prefer TCGA → prefer PanCancer Atlas), use its metadata to call the appropriate navigation tool(s) and generate URLs immediately. Present other studies as alternatives.","data":{"totalCount":5,"studiesWithMetadata":[{"studyId":"gbm_tcga","name":"Glioblastoma Multiforme (TCGA, Firehose Legacy)","sampleCount":619,"studyViewUrl":"https://www.cbioportal.org/study?id=gbm_tcga","metadata":{"clinicalAttributeIds":["AGE","CANCER_TYPE","CANCER_TYPE_DETAILED","DAYS_TO_COLLECTION","DAYS_TO_INITIAL_PATHOLOGIC_DIAGNOSIS","DAYS_TO_SPECIMEN_COLLECTION","DFS_MONTHS","DFS_STATUS","DISEASE_CODE","ECOG_SCORE","ETHNICITY","FORM_COMPLETION_DATE","FRACTION_GENOME_ALTERED","HISTOLOGICAL_DIAGNOSIS","HISTORY_LGG_DX_OF_BRAIN_TISSUE","HISTORY_NEOADJUVANT_TRTYN","HISTORY_OTHER_MALIGNANCY","ICD_10","ICD_O_3_HISTOLOGY","ICD_O_3_SITE","INFORMED_CONSENT_VERIFIED","INITIAL_PATHOLOGIC_DX_YEAR","IS_FFPE","KARNOFSKY_PERFORMANCE_SCORE","LONGEST_DIMENSION","METHOD_OF_INITIAL_SAMPLE_PROCUREMENT","METHOD_OF_INITIAL_SAMPLE_PROCUREMENT_OTHER","METHOD_OF_SAMPLE_PROCUREMENT","MUTATION_COUNT","NEW_TUMOR_EVENT_AFTER_INITIAL_TREATMENT","OCT_EMBEDDED","ONCOTREE_CODE","OS_MONTHS","OS_STATUS","OTHER_METHOD_OF_SAMPLE_PROCUREMENT","OTHER_PATIENT_ID","OTHER_SAMPLE_ID","PATHOLOGY_REPORT_FILE_NAME","PATHOLOGY_REPORT_UUID","PERFORMANCE_STATUS_TIMING","PHARMACEUTICAL_TX_ADJUVANT","PRIMARY_SITE_PATIENT","PROJECT_CODE","PROSPECTIVE_COLLECTION","RACE","RADIATION_TREATMENT_ADJUVANT","RETROSPECTIVE_COLLECTION","SAMPLE_COUNT","SAMPLE_INITIAL_WEIGHT","SAMPLE_TYPE","SAMPLE_TYPE_ID","SEX","SHORTEST_DIMENSION","SITE_OF_TUMOR_TISSUE","SOMATIC_STATUS","SPECIMEN_CURRENT_WEIGHT","SPECIMEN_FREEZING_METHOD","SPECIMEN_SECOND_LONGEST_DIMENSION","TIME_BETWEEN_CLAMPING_AND_FREEZING","TIME_BETWEEN_EXCISION_AND_FREEZING","TISSUE_SOURCE_SITE","TMB_NONSYNONYMOUS","TREATMENT_OUTCOME_FIRST_COURSE","TUMOR_STATUS","VIAL_NUMBER"],"molecularProfileIds":["gbm_tcga_gistic","gbm_tcga_linear_CNA","gbm_tcga_methylation_hm27","gbm_tcga_methylation_hm450","gbm_tcga_mrna","gbm_tcga_mrna_U133","gbm_tcga_mrna_U133_Zscores","gbm_tcga_mrna_U133_all_sample_Zscores","gbm_tcga_mrna_median_Zscores","gbm_tcga_mrna_median_all_sample_Zscores","gbm_tcga_mutations","gbm_tcga_rna_seq_v2_mrna","gbm_tcga_rna_seq_v2_mrna_median_Zscores","gbm_tcga_rna_seq_v2_mrna_median_all_sample_Zscores","gbm_tcga_rppa","gbm_tcga_rppa_Zscores"],"heatmapProfileIds":["gbm_tcga_methylation_hm27","gbm_tcga_methylation_hm450","gbm_tcga_mrna_U133_Zscores","gbm_tcga_mrna_U133_all_sample_Zscores","gbm_tcga_mrna_median_Zscores","gbm_tcga_mrna_median_all_sample_Zscores","gbm_tcga_rna_seq_v2_mrna_median_Zscores","gbm_tcga_rna_seq_v2_mrna_median_all_sample_Zscores","gbm_tcga_rppa_Zscores"],"availableComparisonTabs":["overlap","clinical","survival","alterations","mutations","mrna","protein","dna_methylation"]}},{"studyId":"gbm_tcga_gdc","name":"Glioblastoma Multiforme (TCGA GDC, 2025)","sampleCount":611,"studyVi … (5985 more chars) ▶ get_studyviewfilter_options { "studyId": "gbm_tcga_pub2013", "attributeIds": [ "MGMT_STATUS", "METHYLATION_STATUS" ] } ◀ result {"success":true,"message":"Successfully retrieved StudyView filter options","data":{"studyId":"gbm_tcga_pub2013","attributes":[{"attributeId":"METHYLATION_STATUS","displayName":"Methylation Status","description":"Yes/No indicator for methylation data","datatype":"STRING","values":["CL_4","CL_3","NA","CL_2","CL_1","G-CIMP","CL_6"]},{"attributeId":"MGMT_STATUS","displayName":"MGMT Status","description":"MGMT Status","datatype":"STRING","values":["NA","METHYLATED","UNMETHYLATED"]}]}} ▶ clickhouse_run_select_query { "query": " SELECT attribute_value, count(distinct sample_unique_id) as n_samples FROM clinical_data_derived WHERE cancer_study_identifier = 'gbm_tcga_pub2013' AND attribute_name = 'MGMT_STATUS' GROUP BY attribute_value ORDER BY n_samples DESC " } ▶ navigate_to_study_view { "studyIds": [ "gbm_tcga_pub2013" ], "filterJson": { "clinicalDataFilters": [ { "attributeId": "MGMT_STATUS", "values": [ { "value": "METHYLATED" } ] } ] } } ◀ result {"rows":[{"n_samples":227},{"attribute_value":"UNMETHYLATED","n_samples":180},{"attribute_value":"METHYLATED","n_samples":170}]} ◀ result {"success":true,"message":"Navigating to https://www.cbioportal.org/study/summary?id=gbm_tcga_pub2013#filterJson=%7B%22clinicalDataFilters%22%3A%5B%7B%22attributeId%22%3A%22MGMT_STATUS%22%2C%22values%22%3A%5B%7B%22value%22%3A%22METHYLATED%22%7D%5D%7D%5D%7D","url":"https://www.cbioportal.org/study/summary?id=gbm_tcga_pub2013#filterJson=%7B%22clinicalDataFilters%22%3A%5B%7B%22attributeId%22%3A%22MGMT_STATUS%22%2C%22values%22%3A%5B%7B%22value%22%3A%22METHYLATED%22%7D%5D%7D%5D%7D","data":{"studyIds":["gbm_tcga_pub2013"],"studies":[{"studyId":"gbm_tcga_pub2013","name":"Glioblastoma (TCGA, Cell 2013)","sampleCount":577}],"tab":"summary","hasFilters":true,"hasPlotsConfig":false,"pageDescription":"Overview of all study data displayed as interactive charts summarizing available clinical and genomic data. Click within a chart to filter. Additional charts may be available in the Charts menu."}} ═ answer (success) ## MGMT Methylation Status in GBM (TCGA, Cell 2013) Study: **Glioblastoma (TCGA, Cell 2013)** — `gbm_tcga_pub2013`, 577 total samples | MGMT Status | Samples | |---|---| | **METHYLATED** (hypermethylated) | **170** | | UNMETHYLATED | 180 | | NA (not tested) | 227 | Of 350 samples with known MGMT status, **170 (48.6%)** are hypermethylated. [View GBM samples with MGMT hypermethylation](https://www.cbioportal.org/study/summary?id=gbm_tcga_pub2013#filterJson=%7B%22clinicalDataFilters%22%3A%5B%7B%22attributeId%22%3A%22MGMT_STATUS%22%2C%22values%22%3A%5B%7B%22value%22%3A%22METHYLATED%22%7D%5D%7D%5D%7D) This links to the Study View overview filtered to `MGMT_STATUS = METHYLATED`, where you can further explore clinical and genomic data for this subgroup (this is the only GBM cohort in the database with curated MGMT methylation status as a clinical attribute; other GBM cohorts, e.g. `gbm_tcga_pan_can_atlas_2018`, have raw HM450 methylation array data instead but no curated MGMT call).