B ŒâOa+-ã@sPddlmZdd„Zdd„Zdd„Zdd „Zd d „Zd d „Zdd„Zdd„Z dS)é)Ú sqlConnectcCsLg}t|ƒ}t ¡}x2|D]*}d |¡}| |¡}| |d|i¡qW|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 úVC:\Users\Administrator\Desktop\mbodymap\mbodymap-server\service\bodySitePageService.pyÚ introDatas  rcCs\g}t|ƒ}t ¡}x@|D]6}d}d |¡}| |¡}g}x|D]ö} | ddksF| ddkrfqFd | d¡} | | ¡d} d | d|¡} | | ¡d} d  | d|¡} | | ¡d }d }d  | d|¡}| |¡}t|ƒ}x |D]}|d dkrê|d7}qêWd || d¡}| |¡d}d || d¡}| |¡d}d || d¡}| |¡d}|r| ddkrž| | d| d | ¡||||||dœ ¡nvd || d¡}| |¡}|dkrì| | d| d | ¡||||||dœ ¡n(| | d| d | ¡||||||dœ ¡qF| | d| d | ¡||||||dœ ¡qFW| |d|i¡qW|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_numrZvalidZsql_loaded_runsZ loaded_runsrZ loaded_runZ sql_speciesZspeciesÚ sql_genusZgenusZsql_associationrZsql_pheno_has_markerZpheno_has_markerr r rÚtblDatas¦                 rcCs,|dkrdddgS|dkr"ddgS|gSdS)NzLarge intestineÚRectumÚColonÚCecumzSmall intestineÚIleumÚDuodenumr )rr r rrœs  rcCs>t ¡}|dkr&d |¡}| |¡}nd |¡}| |¡}|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)cCs>t ¡}|dkr&d |¡}| |¡}nd |¡}| |¡}|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 rÚsearchPhenotypeÂs    r*cCs t ¡}d |¡}| |¡}|S)Nz>SELECT BodySite FROM mbodymap_intro WHERE BodySite LIKE "%{}%")rrrr)r%r r'r r r rÚsearchBodysiteÜs  r+cCs t ¡}d |¡}| |¡}|S)NzXSELECT accession_id FROM mbodymap_loaded_samples WHERE accession_id LIKE "%{}%" LIMIT 10)rrrr)r%r r'r r r rÚ searchSampleãs  r,cCs t ¡}d |¡}| |¡}|S)Nu`SELECT `NCBI Project ID` FROM mbodymap_projects WHERE `NCBI Project ID` LIKE "%{}%" LIMIT 10)rrrr)r%r r'r r r rÚ searchProjectês  r-N) Úutilsrrrrr)r*r+r,r-r r r rÚs