o ŒFQa+-ã@sPddlmZdd„Zdd„Zdd„Zdd „Zd d „Zd d „Zdd„Zdd„Z dS)é)Ú sqlConnectcCsHg}t|ƒ}t ¡}|D]}d |¡}| |¡}| |d|i¡q |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)Ú handleSiterÚMySQLConnectionÚformatÚqueryOneÚappend)ÚsiteÚresultÚsiteListÚconnectÚitemZ sql_introZ site_intro©r ú=/var/www/html/mybodymap/server/service/bodySitePageService.pyÚ introDatasÿ ÿrcCsFg}t|ƒ}t ¡}|D]}d}d |¡}| |¡}g}|D]÷} | ddks-| ddur.qd | d¡} | | ¡d} d | d|¡} | | ¡d} d  | d|¡} | | ¡d }d }d  | d|¡}| |¡}t|ƒ}|D] }|d dkr{|d7}qod || d¡}| |¡d}d || d¡}| |¡d}d || d¡}| |¡d}|r| ddkrÇ| | d| d | ¡||||||dœ ¡qd || d¡}| |¡}|durí| | d| d | ¡||||||dœ ¡q| | d| d | ¡||||||dœ ¡q| | d| d | ¡||||||dœ ¡q| |d|i¡q |S)NFzASELECT DISTINCT disease FROM mbodymap_samples WHERE BodySite="{}"ÚdiseaseZNAz)SELECT term FROM mesh_data WHERE uid="{}"Ztermz…SELECT 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_numrzžSELECT accession_id,QCStatus,uid FROM mbodymap_loaded_samples WHERE accession_id IN (SELECT run_id From mbodymap_samples WHERE disease="{}" AND BodySite="{}")ZQCStatusézjSELECT 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="{}"Ú associationÚD006262z{:,}) rÚ disease_nameÚrun_numÚ processed_numZ valid_numÚ species_numÚ project_numÚ genus_numrzTselect * from curated_lefse_analysis_results where bodysite="{}" and phenotype2="{}"Z PhenotypeTbl)rrrrÚqueryrÚlenr)rr r r Z site_itemZ has_markerÚ sql_diseaseZ site_diseaseZ site_resultr Zsql_disease_namerZsql_runsZruns_numrÚvalidZsql_loaded_runsZ loaded_runsrZ loaded_runZ sql_speciesZspeciesÚ sql_genusZgenusZsql_associationrZsql_pheno_has_markerZpheno_has_markerr r rÚtblDatas¼   ÿÿ  €ÿÿÿ  õ  õ õ õÿrcCs&|dkrgd¢S|dkrddgS|gS)NzLarge intestine)ÚRectumÚColonÚCecumzSmall intestineÚIleumÚDuodenumr )rr r rrœs rcCó@t ¡}|dkrd |¡}| |¡}|Sd |¡}| |¡}|S)NÚidzpSELECT 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Ú searchTaxa¥sÿ òÿ  r-cCr%)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 10r'r(r r rÚsearchPhenotypeÂs   ô  r.cCó t ¡}d |¡}| |¡}|S)Nz>SELECT BodySite FROM mbodymap_intro WHERE BodySite LIKE "%{}%"r'©r)r r+r r r rÚsearchBodysiteÜó  r1cCr/)NzXSELECT accession_id FROM mbodymap_loaded_samples WHERE accession_id LIKE "%{}%" LIMIT 10r'r0r r rÚ searchSampleãr2r3cCr/)Nu`SELECT `NCBI Project ID` FROM mbodymap_projects WHERE `NCBI Project ID` LIKE "%{}%" LIMIT 10r'r0r r rÚ searchProjectês ÿ r4N) Úutilsrrrrr-r.r1r3r4r r r rÚs