Variants with protein change as MUTATED in public DB

[rmadupuri]

A couple of variants are still annotated as MUTATED in the public database. See the query below.

select cs.cancer_study_identifier, me.*
from mutation_event as me
join mutation as m on me.mutation_event_id = m.mutation_event_id
join genetic_profile as gp on m.genetic_profile_id = gp.genetic_profile_id
join cancer_study as cs on gp.cancer_study_id = cs.cancer_study_id
where me.protein_change = 'MUTATED';

And here is the MUTATED count per study: (4700 variants from 93 studies)

study_id	count
cscc_ucsf_2021	1925
rectal_msk_2022	846
angs_painter_2020	343
ucec_tcga_pan_can_atlas_2018	157
blca_bcan_hcrn_2022	146
skcm_tcga_pan_can_atlas_2018	85
luad_broad	80
mng_utoronto_2021	76
prostate_pcbm_swiss_2019	72
pog570_bcgsc_2020	64
acc_2019	60
pancan_pcawg_2020	55
coadread_tcga_pan_can_atlas_2018	50
luad_tcga_pan_can_atlas_2018	50
lusc_tcga_pan_can_atlas_2018	48
stad_tcga_pan_can_atlas_2018	37
brca_tcga_pan_can_atlas_2018	33
difg_glass_2019	32
brca_cptac_2020	31
ov_tcga_pan_can_atlas_2018	28
cesc_tcga_pan_can_atlas_2018	27
stad_oncosg_2018	26
blca_tcga_pan_can_atlas_2018	22
gbm_tcga_pan_can_atlas_2018	22
hcc_meric_2021	22
lihc_tcga_pan_can_atlas_2018	22
luad_mskcc_2023_met_organotropism	18
hnsc_tcga_pan_can_atlas_2018	17
lusc_tcga_pub	17
mds_iwg_2022	15
mixed_allen_2018	15
msk_met_2021	15
brca_mbcproject_2022	14
mixed_msk_tcga_2021	14
paad_cptac_2021	13
kirp_tcga_pan_can_atlas_2018	12
coadread_mskresistance_2022	10
pan_origimed_2020	10
prad_tcga_pan_can_atlas_2018	10
sclc_jhu	10
esca_tcga_pan_can_atlas_2018	9
mel_dfci_2019	9
coad_silu_2022	8
ov_tcga	8
cellline_ccle_broad	7
hcc_inserm_fr_2015	7
nsclc_tracerx_2017	7
sarc_tcga_pan_can_atlas_2018	7
blca_msk_tcga_2020	6
cesc_tcga	6
lgg_tcga_pan_can_atlas_2018	6
skcm_dfci_2015	6
mel_ucla_2016	5
mpcproject_broad_2021	5
prad_p1000	5
brca_igr_2015	4
mbl_dkfz_2017	4
paad_tcga_pan_can_atlas_2018	4
skcm_mskcc_2014	4
acc_tcga_pan_can_atlas_2018	3
bowel_colitis_msk_2022	3
brain_cptac_2020	3
gbm_mayo_pdx_sarkaria_2019	3
hccihch_pku_2019	3
kirc_tcga_pan_can_atlas_2018	3
mixed_kunga_msk_2022	3
bcc_unige_2016	2
blca_tcga_pub_2017	2
cll_iuopa_2015	2
dlbc_tcga_pan_can_atlas_2018	2
lusc_cptac_2021	2
mpnst_mskcc	2
sarcoma_mskcc_2022	2
skcm_broad	2
thym_tcga_pan_can_atlas_2018	2
ucs_tcga_pan_can_atlas_2018	2
brca_tcga_pub	1
brca_tcga_pub2015	1
coadread_tcga_pub	1
crc_apc_impact_2020	1
crc_eo_2020	1
crc_nigerian_2020	1
egc_mskcc_2020	1
gbc_mskcc_2022	1
histiocytosis_cobi_msk_2019	1
mds_mskcc_2020	1
meso_tcga_pan_can_atlas_2018	1
mixed_cfdna_msk_2020	1
mixed_selpercatinib_2020	1
msk_access_2021	1
prad_mcspc_mskcc_2020	1
prad_msk_stopsack_2021	1
thca_tcga_pan_can_atlas_2018	1
vsc_cuk_2018	1