Q (haiku): Is there any study with a polygenic risk score?

▶ 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 DISTINCT attribute_id, display_name, description
FROM clinical_attribute_meta
WHERE lower(attribute_id) LIKE '%risk%' 
   OR lower(display_name) LIKE '%risk%'
   OR lower(description) LIKE '%risk%'
   OR lower(attribute_id) LIKE '%polygenic%'
   OR lower(display_name) LIKE '%polygenic%'
ORDER BY attribute_id
",
 "max_rows": 50
}

◀ 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 `attribute_id` in scope SELECT DISTINCT attribute_id, display_name, description FROM clinical_attribute_meta WHERE (lower(attribute_id) LIKE '%risk%') OR (lower(display_name) LIKE '%risk%') OR (lower(description) LIKE '%risk%') OR (lower(attribute_id) LIKE '%polygenic%') OR (lower(display_name) LIKE '%polygenic%') ORDER BY attribute_id ASC. (UNKNOWN_IDENTIFIER) (version 26.4.1.2359 (official build))\n"}

▶ clickhouse_list_table_columns
{
 "table": "clinical_attribute_meta"
}

◀ result
{"columns":[{"name":"attr_id","type":"String"},{"name":"display_name","type":"String"},{"name":"description","type":"String"},{"name":"datatype","type":"String"},{"name":"patient_attribute","type":"Int32"},{"name":"priority","type":"String"},{"name":"cancer_study_id","type":"Int64"}]}

▶ clickhouse_run_select_query
{
 "query": "
SELECT DISTINCT attr_id, display_name, description
FROM clinical_attribute_meta
WHERE lower(attr_id) LIKE '%risk%' 
   OR lower(display_name) LIKE '%risk%'
   OR lower(description) LIKE '%risk%'
   OR lower(attr_id) LIKE '%polygenic%'
   OR lower(display_name) LIKE '%polygenic%'
ORDER BY attr_id
",
 "max_rows": 50
}

◀ result
{"rows":[{"attr_id":"CYTOGENETIC_RISK","display_name":"Cytogenetic Risk","description":"Cytogenetic Risk"},{"attr_id":"CYTO_IPSSR","display_name":"IPSS-R Cytogenetic Category","description":"IPSS-R Cytogenetic Risk Category"},{"attr_id":"ELN2017","display_name":"ELN2017","description":"Risk classification assigned to the specimen based on European Leukemia Network 2017 guidelines"},{"attr_id":"ELN_2008","display_name":"ELN 2008 Risk Classification","description":"Risk classification assigned to the Specimen based on European Leukemia Network 2008 guidelines"},{"attr_id":"ELN_2017","display_name":"ELN 2017 Risk Classification","description":"Risk classification assigned to the Specimen based on European Leukemia Network 2017 guidelines"},{"attr_id":"HISTORY_HEPATO_CARCINOMA_RISK_FACTORS","display_name":"History hepato carcinoma risk factor","description":"History hepato carcinoma risk factor"},{"attr_id":"HISTORY_RADIATION_EXPOSURE","display_name":"History radiation exposure","description":"Person lifetime risk radiation exposure indicator"},{"attr_id":"IPSSM","display_name":"IPSS-M ","description":"IPSS-M Risk Category"},{"attr_id":"IPSSM_SCORE","display_name":"IPSS-M Score","description":"IPSS-M Risk Score"},{"attr_id":"IPSSR","display_name":"IPSS-R","description":"IPSS-R Risk Category"},{"attr_id":"IPSSR_SCORE","display_name":"IPSS-R Score","description":"IPSS-R Risk Score"},{"attr_id":"LEIBOVICH_RISK_GROUP","display_name":"Leibovich Risk Group","description":"Leibovich Risk Group"},{"attr_id":"MBR_GROUP","display_name":"MBR Group","description":"Binarized MBR score using the cutoff threshold 0 to classify samples into High Risk and Low Risk groups."},{"attr_id":"MBR_SCORE","display_name":"MBR Score","description":"Microbiome Risk Score calculated by the MBR classifier. The MBR classifier that was built by a relaxed multivariate elastic-net cox regression model including 41 genera"},{"attr_id":"MICROSCORE","display_name":"mICRo Score","description":"Integrated score combining ICR and MBR group. Samples with the co-presence of ICR High and MBR Low risk are referred to as mICRoScore High."},{"attr_id":"OTHER_HEPATO_CARCINOMA_RISK_FACTORS","display_name":"History hepato carcinoma risk factor other","description":"History hepato carcinoma risk factor other"},{"attr_id":"PROGNOSTIC_MODEL","display_name":"Prognostic Model","description":"Genomic Risk Model Classification"},{"attr_id":"RISK","display_name":"Risk Stratification","description":"Risk stratification"},{"attr_id":"RISK_CYTO","display_name":"Risk (Cyto)","description":"Risk (Cyto)."},{"attr_id":"RISK_GROUP","display_name":"Risk Group","description":"Risk group."},{"attr_id":"RISK_GROUP","display_name":"Risk Group ","description":"Risk group assignment"},{"attr_id":"RISK_GROUP","display_name":"Risk Group","description":"Risk group"},{"attr_id":"RISK_MOLECULAR","display_name":"Risk (Molecular)","description":"Risk (Molecular)."},{"attr_id":"RISK_SCORE","display_name":"Total Risk Score","descr … (151 more chars)

▶ clickhouse_list_table_columns
{
 "table": "generic_assay_meta_derived"
}

◀ result
{"columns":[{"name":"entity_stable_id","type":"String"},{"name":"entity_type","type":"LowCardinality(String)"},{"name":"properties","type":"Map(String, String)"}]}

▶ clickhouse_run_select_query
{
 "query": "
SELECT DISTINCT entity_stable_id, entity_type, properties['name'] as name
FROM generic_assay_meta_derived
WHERE lower(entity_stable_id) LIKE '%prs%'
   OR lower(entity_stable_id) LIKE '%polygenic%'
   OR lower(properties['name']) LIKE '%prs%'
   OR lower(properties['name']) LIKE '%polygenic%'
LIMIT 50
",
 "max_rows": 50
}

◀ result
{"rows":[{"entity_stable_id":"1_220006106_220007338_EPRS","entity_type":"GENERIC_ASSAY"},{"entity_stable_id":"ADPRS_K109k","entity_type":"GENERIC_ASSAY"},{"entity_stable_id":"TMPRSS11B_K393k","entity_type":"GENERIC_ASSAY"},{"entity_stable_id":"TMPRSS11B_acetylprotein","entity_type":"GENERIC_ASSAY"},{"entity_stable_id":"TMPRSS13_S135","entity_type":"GENERIC_ASSAY"},{"entity_stable_id":"TMPRSS13_S70","entity_type":"GENERIC_ASSAY"},{"entity_stable_id":"TMPRSS13_T29","entity_type":"GENERIC_ASSAY"},{"entity_stable_id":"TMPRSS13_T49","entity_type":"GENERIC_ASSAY"},{"entity_stable_id":"TMPRSS13_T64","entity_type":"GENERIC_ASSAY"},{"entity_stable_id":"TMPRSS13_acetylprotein","entity_type":"GENERIC_ASSAY"},{"entity_stable_id":"TMPRSS13_pS134","entity_type":"GENERIC_ASSAY"},{"entity_stable_id":"TMPRSS13_pS135","entity_type":"GENERIC_ASSAY"},{"entity_stable_id":"TMPRSS13_pS25_T29","entity_type":"GENERIC_ASSAY"},{"entity_stable_id":"TMPRSS13_pS45","entity_type":"GENERIC_ASSAY"},{"entity_stable_id":"TMPRSS13_pS70","entity_type":"GENERIC_ASSAY"},{"entity_stable_id":"TMPRSS13_pS90","entity_type":"GENERIC_ASSAY"},{"entity_stable_id":"TMPRSS13_pT29","entity_type":"GENERIC_ASSAY"},{"entity_stable_id":"TMPRSS13_pT49","entity_type":"GENERIC_ASSAY"},{"entity_stable_id":"TMPRSS13_pT64","entity_type":"GENERIC_ASSAY"},{"entity_stable_id":"TMPRSS13_pT64_S70","entity_type":"GENERIC_ASSAY"},{"entity_stable_id":"TMPRSS9_Y333:NP_892018.1","entity_type":"GENERIC_ASSAY"},{"entity_stable_id":"TMPRs_S13_S135s","entity_type":"GENERIC_ASSAY"},{"entity_stable_id":"TMPRs_S13_S70s","entity_type":"GENERIC_ASSAY"},{"entity_stable_id":"TMPRs_S13_T29t","entity_type":"GENERIC_ASSAY"},{"entity_stable_id":"TMPRs_S13_T64t","entity_type":"GENERIC_ASSAY"},{"entity_stable_id":"chr11_118103101_118104820_TMPRSS4","entity_type":"GENERIC_ASSAY"},{"entity_stable_id":"chr1_220006106_220007338_EPRS","entity_type":"GENERIC_ASSAY"},{"entity_stable_id":"chr21_18294270_18344060_TMPRSS15","entity_type":"GENERIC_ASSAY"},{"entity_stable_id":"chr21_18312945_18332173_TMPRSS15","entity_type":"GENERIC_ASSAY"},{"entity_stable_id":"chr21_18312945_18344060_TMPRSS15","entity_type":"GENERIC_ASSAY"},{"entity_stable_id":"COPRS_59_66_1_1_S66","entity_type":"GENERIC_ASSAY"},{"entity_stable_id":"COPRS_73_100_1_1_S87","entity_type":"GENERIC_ASSAY"},{"entity_stable_id":"COPRS_S31:NP_060875.2","entity_type":"GENERIC_ASSAY"},{"entity_stable_id":"COPRS_S54:NP_001317105.1","entity_type":"GENERIC_ASSAY"},{"entity_stable_id":"COPRS_S61","entity_type":"GENERIC_ASSAY"},{"entity_stable_id":"COPRS_S61:NP_060875.2","entity_type":"GENERIC_ASSAY"},{"entity_stable_id":"COPRS_S61s_S66s","entity_type":"GENERIC_ASSAY"},{"entity_stable_id":"COPRS_S66","entity_type":"GENERIC_ASSAY"},{"entity_stable_id":"COPRS_S66:NP_060875.2","entity_type":"GENERIC_ASSAY"},{"entity_stable_id":"COPRS_S66_T73_S87:NP_060875.2","entity_type":"GENERIC_ASSAY"},{"entity_stable_id":"COPRS_S66_T73_T93:NP_060875.2","entity_type":"GENERIC_ASSAY"},{"entity_stable_id":"CO … (617 more chars)

▶ clickhouse_run_select_query
{
 "query": "
SELECT DISTINCT 
  cs.cancer_study_identifier,
  cs.name,
  gam.entity_stable_id,
  gam.properties['name'] as assay_name,
  gam.properties['description'] as description
FROM genetic_profile gp
JOIN genetic_alteration ga ON gp.genetic_profile_id = ga.genetic_profile_id
JOIN genetic_entity ge ON ga.genetic_entity_id = ge.genetic_entity_id
JOIN cancer_study cs ON gp.cancer_study_id = cs.cancer_study_id
LEFT JOIN generic_assay_meta_derived gam ON ge.stable_id = gam.entity_stable_id
WHERE lower(gp.genetic_profile_name) LIKE '%prs%'
   OR lower(gp.genetic_profile_name) LIKE '%polygenic%'
   OR lower(gam.entity_stable_id) LIKE '%prs%'
   OR lower(properties['name']) LIKE '%prs%'
LIMIT 20
",
 "max_rows": 20
}

◀ 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: Identifier 'ge.genetic_entity_id' cannot be resolved from table with name ge. In scope SELECT DISTINCT cs.cancer_study_identifier, cs.name, gam.entity_stable_id, gam.properties['name'] AS assay_name, gam.properties['description'] AS description FROM genetic_profile AS gp INNER JOIN genetic_alteration AS ga ON gp.genetic_profile_id = ga.genetic_profile_id INNER JOIN genetic_entity AS ge ON ga.genetic_entity_id = ge.genetic_entity_id INNER JOIN cancer_study AS cs ON gp.cancer_study_id = cs.cancer_study_id LEFT JOIN generic_assay_meta_derived AS gam ON ge.stable_id = gam.entity_stable_id WHERE (lower(gp.genetic_profile_name) LIKE '%prs%') OR (lower(gp.genetic_profile_name) LIKE '%polygenic%') OR (lower(gam.entity_stable_id) LIKE '%prs%') OR (lower(properties['name']) LIKE '%prs%') LIMIT 20. Maybe you meant: ['genetic_entity.id']. (UNKNOWN_IDENTIFIER) (version 26.4.1.2359 (official build))\n"}

▶ clickhouse_list_table_columns
{
 "table": "genetic_profile"
}

◀ result
{"columns":[{"name":"genetic_profile_id","type":"Int64"},{"name":"stable_id","type":"String"},{"name":"cancer_study_id","type":"Int64"},{"name":"genetic_alteration_type","type":"String"},{"name":"generic_assay_type","type":"Nullable(String)"},{"name":"datatype","type":"String"},{"name":"name","type":"String"},{"name":"description","type":"Nullable(String)"},{"name":"show_profile_in_analysis_tab","type":"Int32"},{"name":"pivot_threshold","type":"Nullable(Float64)"},{"name":"sort_order","type":"Nullable(String)"},{"name":"patient_level","type":"Nullable(Int32)"}]}

▶ clickhouse_run_select_query
{
 "query": "
SELECT DISTINCT 
  cs.cancer_study_identifier,
  cs.name,
  gp.name as profile_name,
  gp.description,
  gp.genetic_alteration_type,
  gp.generic_assay_type
FROM genetic_profile gp
JOIN cancer_study cs ON gp.cancer_study_id = cs.cancer_study_id
WHERE lower(gp.name) LIKE '%prs%'
   OR lower(gp.name) LIKE '%polygenic%'
   OR lower(gp.stable_id) LIKE '%prs%'
   OR lower(gp.stable_id) LIKE '%polygenic%'
",
 "max_rows": 50
}

◀ result
{"rows":[]}

▶ clickhouse_run_select_query
{
 "query": "
SELECT DISTINCT cancer_study_identifier, resource_type, count(*)
FROM resource_study
GROUP BY cancer_study_identifier, resource_type
ORDER BY cancer_study_identifier
",
 "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 `cancer_study_identifier` in scope SELECT DISTINCT cancer_study_identifier, resource_type, count(*) FROM resource_study GROUP BY cancer_study_identifier, resource_type ORDER BY cancer_study_identifier ASC. (UNKNOWN_IDENTIFIER) (version 26.4.1.2359 (official build))\n"}

▶ clickhouse_list_table_columns
{
 "table": "resource_study"
}

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

▶ clickhouse_list_table_columns
{
 "table": "resource_definition"
}

◀ 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_id, display_name, description, resource_type
FROM resource_definition
WHERE lower(display_name) LIKE '%prs%'
   OR lower(display_name) LIKE '%polygenic%'
   OR lower(resource_id) LIKE '%prs%'
   OR lower(resource_id) LIKE '%polygenic%'
",
 "max_rows": 50
}

◀ result
{"rows":[]}

▶ clickhouse_run_select_query
{
 "query": "
SELECT DISTINCT cs.cancer_study_identifier, cma.attr_id, cma.display_name
FROM clinical_attribute_meta cma
JOIN cancer_study cs ON cma.cancer_study_id = cs.cancer_study_id
WHERE lower(cma.attr_id) = 'prs' 
   OR lower(cma.display_name) LIKE '%polygenic%'
",
 "max_rows": 50
}

◀ result
{"rows":[]}

═ answer (success)
Based on my comprehensive search of the cBioPortal database, **there are no studies with polygenic risk score (PRS) data currently stored in cBioPortal**.

I searched across:
- **Clinical attributes** — no "PRS" or "polygenic risk score" attributes found
- **Genetic profiles** — no profiles named for PRS or polygenic data
- **Generic assay data** — no PRS assay entities (only phosphoproteins and other assays)
- **External resources** — no linked PRS databases or resources

The cBioPortal instance contains extensive mutation, copy number, expression, and clinical data across hundreds of cancer studies, but PRS data — which is typically derived from germline variants across the genome to estimate inherited disease risk — is not currently integrated into this portal.

If you're interested in genetic risk scores in cancer genomics, you may want to check:
- Individual cancer consortium portals that may host PRS data
- The **[Polygenic Risk Score (PRS) Catalog](https://www.pgscatalog.org/)** for publicly available PRS models
- Study-specific supplementary data from large cohorts that computed PRS data