Q (haiku): is there any imaging data?

▶ 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_list_table_columns
{
 "table": "resource_sample"
}

▶ clickhouse_list_table_columns
{
 "table": "resource_patient"
}

◀ result
{"columns":[{"name":"internal_id","type":"Int64"},{"name":"resource_id","type":"String"},{"name":"url","type":"String"}]}

▶ clickhouse_list_table_columns
{
 "table": "resource_study"
}

▶ clickhouse_list_table_columns
{
 "table": "resource_definition"
}

◀ result
{"columns":[{"name":"internal_id","type":"Int64"},{"name":"resource_id","type":"String"},{"name":"url","type":"String"}]}

◀ result
{"columns":[{"name":"internal_id","type":"Int64"},{"name":"resource_id","type":"String"},{"name":"url","type":"String"}]}

◀ result
{"columns":[{"name":"resource_id","type":"String"},{"name":"display_name","type":"String"},{"name":"description","type":"Nullable(String)"},{"name":"resource_type","type":"String"},{"name":"open_by_default","type":"Nullable(Int32)"},{"name":"priority","type":"Int64"},{"name":"cancer_study_id","type":"Int64"},{"name":"custom_metadata","type":"Nullable(String)"}]}

▶ clickhouse_run_select_query
{
 "query": "
SELECT DISTINCT resource_type, COUNT(*) as count
FROM resource_definition
GROUP BY resource_type
ORDER BY count DESC
"
}

◀ result
{"rows":[{"resource_type":"PATIENT","count":74},{"resource_type":"SAMPLE","count":10}]}

▶ clickhouse_run_select_query
{
 "query": "
SELECT resource_id, display_name, description, resource_type
FROM resource_definition
ORDER BY resource_id
LIMIT 100
",
 "max_rows": 100
}

◀ result
{"rows":[{"resource_id":"CHROMOSCOPE","display_name":"Chromoscope","description":"Link to Chromoscope","resource_type":"SAMPLE"},{"resource_id":"CHROMOSCOPE","display_name":"Chromoscope","description":"Link to Chromoscope","resource_type":"SAMPLE"},{"resource_id":"CYCIF","display_name":"CyCIF","description":"CyCIF","resource_type":"SAMPLE"},{"resource_id":"FIGURES","display_name":"Figures","description":"Figures from https://www.biorxiv.org/content/10.1101/2020.12.03.408500v1/","resource_type":"PATIENT"},{"resource_id":"HE","display_name":"H&E Slide","description":"H&E Slide","resource_type":"SAMPLE"},{"resource_id":"HE","display_name":"H&E Slide","description":"H&E Slide","resource_type":"SAMPLE"},{"resource_id":"HE","display_name":"H&E Slide","description":"H&E Slide","resource_type":"SAMPLE"},{"resource_id":"HE","display_name":"H&E Slide","description":"H&E Slide","resource_type":"SAMPLE"},{"resource_id":"IDC_OHIF_CR","display_name":"Computed Radiography","description":"Computed Radiography","resource_type":"PATIENT"},{"resource_id":"IDC_OHIF_CR","display_name":"Computed Radiography","description":"Computed Radiography","resource_type":"PATIENT"},{"resource_id":"IDC_OHIF_CR","display_name":"Computed Radiography","description":"Computed Radiography","resource_type":"PATIENT"},{"resource_id":"IDC_OHIF_CT","display_name":"Computed Tomography","description":"Computed Tomography","resource_type":"PATIENT"},{"resource_id":"IDC_OHIF_CT","display_name":"Computed Tomography","description":"Computed Tomography","resource_type":"PATIENT"},{"resource_id":"IDC_OHIF_CT","display_name":"Computed Tomography","description":"Computed Tomography","resource_type":"PATIENT"},{"resource_id":"IDC_OHIF_CT","display_name":"Computed Tomography","description":"Computed Tomography","resource_type":"PATIENT"},{"resource_id":"IDC_OHIF_CT","display_name":"Computed Tomography","description":"Computed Tomography","resource_type":"PATIENT"},{"resource_id":"IDC_OHIF_CT","display_name":"Computed Tomography","description":"Computed Tomography","resource_type":"PATIENT"},{"resource_id":"IDC_OHIF_CT","display_name":"Computed Tomography","description":"Computed Tomography","resource_type":"PATIENT"},{"resource_id":"IDC_OHIF_CT","display_name":"Computed Tomography","description":"Computed Tomography","resource_type":"PATIENT"},{"resource_id":"IDC_OHIF_CT","display_name":"Computed Tomography","description":"Computed Tomography","resource_type":"PATIENT"},{"resource_id":"IDC_OHIF_CT","display_name":"Computed Tomography","description":"Computed Tomography","resource_type":"PATIENT"},{"resource_id":"IDC_OHIF_CT","display_name":"Computed Tomography","description":"Computed Tomography","resource_type":"PATIENT"},{"resource_id":"IDC_OHIF_CT","display_name":"Computed Tomography","description":"Computed Tomography","resource_type":"PATIENT"},{"resource_id":"IDC_OHIF_CT","display_name":"Computed Tomography","description":"Computed Tomography","resource_type":"PATIENT"},{"resource_id":"IDC_OHIF … (7433 more chars)

═ answer (success)
Yes, **cBioPortal contains imaging data**. The database includes links to multiple types of imaging and pathology images through the `resource_definition`, `resource_patient`, and `resource_sample` tables:

### Available Imaging Types

**Medical Imaging (via IDC/OHIF viewer):**
- **Computed Tomography (CT)**
- **Magnetic Resonance (MR)**
- **Positron Emission Tomography (PET)**
- **Nuclear Medicine (NM)**
- **Mammography (MG)**
- **Radiography** (Computed Radiography CR, Digital Radiography DX)

**Microscopy & Pathology:**
- **H&E Slides** — Histopathology images
- **CyCIF** — Cyclic Immunofluorescence multiplexed images
- **Slide Microscopy (IDC_SLIM)** — Whole-slide microscopy
- **MxIF Images** — Multiplexed immunofluorescence
- **Chromoscope** — Interactive virtual microscopy

### How It Works

These resources are **linked at the patient or sample level** through:
- `resource_patient` table — patient-level imaging (most imaging data)
- `resource_sample` table — sample-level pathology images (H&E, CyCIF, MxIF)

When you view a patient or sample in PatientView, cBioPortal displays clickable links to these images in an external viewer (typically the **IDC OHIF Viewer** for medical images or **Minerva** for whole-slide pathology).

Would you like to know which studies have imaging data, or how to access images for specific patients?