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

▶ list_guides
{}

◀ 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#<number>\") (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"}]}

▶ clickhouse_run_select_query
{
 "query": "SELECT DISTINCT attribute_name FROM clinical_data_derived WHERE lower(attribute_name) LIKE '%polygenic%' OR lower(attribute_name) LIKE '%prs%'"
}

▶ clickhouse_list_tables
{}

◀ result
{"rows":[{"attribute_name":"TMPRSS2_ERG_FUSION_STATUS"}]}

◀ 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 stable_id, name, description FROM generic_assay_meta_derived WHERE lower(name) LIKE '%polygenic%' OR lower(stable_id) LIKE '%polygenic%' OR lower(name) LIKE '%prs%' OR lower(description) LIKE '%polygenic%'"
}

▶ clickhouse_run_select_query
{
 "query": "SELECT DISTINCT key FROM clinical_event_derived WHERE lower(key) LIKE '%polygenic%' OR lower(key) LIKE '%prs%'"
}

▶ clickhouse_run_select_query
{
 "query": "SELECT cancer_study_identifier, name, description FROM cancer_study WHERE lower(name) LIKE '%polygenic%' OR lower(description) LIKE '%polygenic%' OR lower(name) LIKE '%risk score%' OR lower(description) LIKE '%risk score%'"
}

◀ 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 `stable_id` in scope SELECT DISTINCT stable_id, name, description FROM generic_assay_meta_derived WHERE (lower(name) LIKE '%polygenic%') OR (lower(stable_id) LIKE '%polygenic%') OR (lower(name) LIKE '%prs%') OR (lower(description) LIKE '%polygenic%'). (UNKNOWN_IDENTIFIER) (version 26.4.1.2359 (official build))\n"}

◀ 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 `key` in scope SELECT DISTINCT key FROM clinical_event_derived WHERE (lower(key) LIKE '%polygenic%') OR (lower(key) LIKE '%prs%'). (UNKNOWN_IDENTIFIER) (version 26.4.1.2359 (official build))\n"}

◀ result
{"rows":[]}

▶ clickhouse_list_table_columns
{
 "table": "generic_assay_meta_derived"
}

▶ clickhouse_list_table_columns
{
 "table": "clinical_event_derived"
}

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

◀ result
{"columns":[{"name":"clinical_event_id","type":"Int64"},{"name":"patient_id","type":"Nullable(Int64)"},{"name":"patient_stable_id","type":"String"},{"name":"start_date","type":"Nullable(Int64)"},{"name":"stop_date","type":"Nullable(Int64)"},{"name":"event_type","type":"LowCardinality(String)"},{"name":"cancer_study_identifier","type":"LowCardinality(String)"}]}

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

▶ clickhouse_list_table_columns
{
 "table": "clinical_event_data_derived"
}

◀ result
{"rows":[{"entity_stable_id":"1_220006106_220007338_EPRS","entity_type":"GENERIC_ASSAY"},{"entity_stable_id":"ADPRS_K109k","entity_type":"GENERIC_ASSAY","name":"ADPRS_K109k","description":"1_1_109_109"},{"entity_stable_id":"TMPRSS11B_K393k","entity_type":"GENERIC_ASSAY","name":"TMPRSS11B_K393k","description":"1_1_393_393"},{"entity_stable_id":"TMPRSS11B_acetylprotein","entity_type":"GENERIC_ASSAY","name":"S97s "},{"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","name":"T29t-S70s-S135s "},{"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","name":"TMPRs_S13_S135s","description":"1_0_134_135"},{"entity_stable_id":"TMPRs_S13_S70s","entity_type":"GENERIC_ASSAY","name":"TMPRs_S13_S70s","description":"1_1_70_70"},{"entity_stable_id":"TMPRs_S13_T29t","entity_type":"GENERIC_ASSAY","name":"TMPRs_S13_T29t","description":"1_1_29_29"},{"entity_stable_id":"TMPRs_S13_T64t","entity_type":"GENERIC_ASSAY","name":"TMPRs_S13_T64t","description":"1_1_64_64"},{"entity_stable_id":"COPRS_59_66_1_1_S66","entity_type":"GENERIC_ASSAY","name":"COPRS S66 59-66 1_1","description":"NP_060875.2"},{"entity_stable_id":"COPRS_73_100_1_1_S87","entity_type":"GENERIC_ASSAY","name":"COPRS S87 73-100 1_1","description":"NP_060875.2"},{"entity_stable_id":"COPRS_S31:NP_060875.2","entity_type":"GENERIC_ASSAY","name":"COPRS_S31:NP_060875.2","description":"COPRS_S31:NP_060875.2"},{"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","name":"COPRS_S61:NP_060875.2","description":"COPRS_S61:NP_060875.2"},{"entity_stable_id":"COPRS_S61s_S66s","entity_type":"GENERIC_ASSAY","name":"COPRS_S61s_S66s","description":"2_2_61_66"},{"entity_stable_id":"COPRS_S66","entity_type":"GENERIC_ASSAY"},{"entity_stable_id":"COPRS_S66:NP_060875.2 … (7324 more chars)

◀ result
{"columns":[{"name":"patient_unique_id","type":"String"},{"name":"key","type":"String"},{"name":"value","type":"String"},{"name":"start_date","type":"Int32"},{"name":"stop_date","type":"Int32"},{"name":"event_type","type":"LowCardinality(String)"},{"name":"cancer_study_identifier","type":"LowCardinality(String)"}]}

▶ clickhouse_run_select_query
{
 "query": "SELECT DISTINCT key FROM clinical_event_data_derived WHERE lower(key) LIKE '%polygenic%' OR lower(key) = 'prs' OR lower(key) LIKE '%prs\\_%' OR lower(key) LIKE '%\\_prs%' OR lower(key) LIKE '%risk score%'"
}

▶ clickhouse_run_select_query
{
 "query": "SELECT DISTINCT entity_stable_id, properties['NAME'] as name, properties['DESCRIPTION'] as description FROM generic_assay_meta_derived WHERE lower(properties['NAME']) LIKE '%polygenic%' OR lower(properties['DESCRIPTION']) LIKE '%polygenic%' OR lower(entity_stable_id) = 'prs' OR lower(entity_stable_id) LIKE '%prs\\_score%' OR lower(properties['NAME']) LIKE '%risk score%'"
}

◀ result
{"rows":[]}

◀ result
{"rows":[]}

═ answer (success)
No matches. I've now searched:
- `clinical_data_derived` (sample/patient clinical attributes)
- `clinical_event_data_derived` (treatment/timeline event data)
- `generic_assay_meta_derived` (generic assay entities — where non-standard quantitative scores like this would typically live)
- `cancer_study` names/descriptions

None contain a "polygenic risk score" (PRS) attribute, entity, or study reference.

**Answer:** No, I did not find any study in this cBioPortal database with polygenic risk score (PRS) data — searched clinical attributes, clinical event data, generic assay entities, and study descriptions with no matches. cBioPortal's data model is centered on somatic/germline genomic alterations, clinical attributes, and treatment timelines; PRS (a germline, genome-wide risk metric) is not a data type typically hosted here. If you're looking for PRS data specifically, that would more likely be found in resources like the PGS Catalog rather than cBioPortal.