3 FQa+-@sPddlmZddZddZddZdd Zd d Zd d ZddZddZ dS)) sqlConnectcCsLg}t|}tj}x2|D]*}dj|}|j|}|j|d|iqW|S)NaESELECT BodySite, FORMAT(disease_num, 0) disease_num, FORMAT(loaded_run_num, 0) loaded_run_num, FORMAT(QC_0_num, 0) QC_0_num, FORMAT(QC_1_num, 0) QC_1_num, FORMAT(run_num, 0) run_num, FORMAT(species_num, 0) species_num, FORMAT(genus_num, 0) genus_num, FORMAT(project_num, 0) project_num FROM mbodymap_intro WHERE BodySite="{}"ZPhenotypeIntro) handleSiterMySQLConnectionformatqueryOneappend)siteresultsiteListconnectitemZ sql_introZ site_intror =/var/www/html/mybodymap/server/service/bodySitePageService.py introDatas  rc Cs\g}t|}tj}x@|D]6}d}dj|}|j|}g}x|D]} | ddksF| ddkrfqFdj| d} |j| d} dj| d|} |j| d} d j| d|} |j| d }d }d j| d|}|j|}t|}x |D]}|d dkr|d7}qWdj|| d}|j|d}dj|| d}|j|d}dj|| d}|j|d}|r| ddkr|j| d| dj| ||||||d nvdj|| d}|j|}|dkr|j| d| dj| ||||||d n(|j| d| dj| ||||||d qF|j| d| dj| ||||||d qFW|j|d|iqW|S)NFzASELECT DISTINCT disease FROM mbodymap_samples WHERE BodySite="{}"diseaseZNAz)SELECT term FROM mesh_data WHERE uid="{}"termzSELECT COUNT(run_id) run_id_num, COUNT(DISTINCT project_id) project_id_num FROM mbodymap_samples WHERE disease="{}" AND BodySite="{}"Z run_id_numzkSELECT COUNT(DISTINCT project_id) project_id_num FROM mbodymap_samples WHERE disease="{}" AND BodySite="{}"Zproject_id_numrzSELECT accession_id,QCStatus,uid FROM mbodymap_loaded_samples WHERE accession_id IN (SELECT run_id From mbodymap_samples WHERE disease="{}" AND BodySite="{}")ZQCStatuszjSELECT COUNT(DISTINCT ncbi_taxon_id) from mbodymap_species_to_samples WHERE BodySite="{}" AND disease="{}"zCOUNT(DISTINCT ncbi_taxon_id)zhSELECT COUNT(DISTINCT ncbi_taxon_id) from mbodymap_genus_to_samples WHERE BodySite="{}" AND disease="{}"zbselect association from mbodymap_bodysite_disease_association where bodysite="{}" and disease="{}" associationD006262z{:,}) r disease_namerun_num processed_numZ valid_num species_num project_num genus_numrzTselect * from curated_lefse_analysis_results where bodysite="{}" and phenotype2="{}"Z PhenotypeTbl)rrrrqueryrlenr)rr r r Z site_itemZ has_marker sql_diseaseZ site_diseaseZ site_resultr Zsql_disease_namerZsql_runsZruns_numrZvalidZsql_loaded_runsZ loaded_runsrZ loaded_runZ sql_speciesZspecies sql_genusZgenusZsql_associationrZsql_pheno_has_markerZpheno_has_markerr r rtblDatas                 rcCs,|dkrdddgS|dkr"ddgS|gSdS)NzLarge intestineRectumColonCecumzSmall intestineIleumDuodenumr )rr r rrs  rcCs>tj}|dkr&dj|}|j|}ndj|}|j|}|S)NidzpSELECT DISTINCT ncbi_taxon_id, taxon_rank_level, name from mbodymap_taxa where ncbi_taxon_id like "{}%" limit 10zgSELECT DISTINCT ncbi_taxon_id, taxon_rank_level, name from mbodymap_taxa where name like "{}%" limit 10)rrrr) searchInput searchOptr sql searchResultr r r searchTaxas  r*cCs>tj}|dkr&dj|}|j|}ndj|}|j|}|S)Nr%znSELECT DISTINCT disease uid, disease_name term from mbodymap_phenotype_index where disease LIKE "{}%" limit 10zsSELECT DISTINCT disease uid, disease_name term from mbodymap_phenotype_index where disease_name LIKE "{}%" limit 10)rrrr)r&r'r r(r)r r rsearchPhenotypes    r+cCs tj}dj|}|j|}|S)Nz>SELECT BodySite FROM mbodymap_intro WHERE BodySite LIKE "%{}%")rrrr)r&r r(r r r rsearchBodysites  r,cCs tj}dj|}|j|}|S)NzXSELECT accession_id FROM mbodymap_loaded_samples WHERE accession_id LIKE "%{}%" LIMIT 10)rrrr)r&r r(r r r r searchSamples  r-cCs tj}dj|}|j|}|S)Nu`SELECT `NCBI Project ID` FROM mbodymap_projects WHERE `NCBI Project ID` LIKE "%{}%" LIMIT 10)rrrr)r&r r(r r r r searchProjects  r.N) utilsrrrrr*r+r,r-r.r r r rs