B rØ`uã@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  rc Cs‚g}t|ƒ}t ¡}xf|D]\}d |¡}| |¡}g}x*|D] }|ddksB|ddkrbqBd |d¡} | | ¡d} d |d|¡} | | ¡d} d |d|¡} | | ¡d } d }d  |d|¡}| |¡}t|ƒ}x |D]}|d d kræ|d 7}qæWd ||d¡}| |¡d}d ||d¡}| |¡d}| |d| d | ¡|||| |dœ¡qBW| |d|i¡qW|S)NzASELECT DISTINCT disease FROM mbodymap_samples WHERE BodySite="{}"ÚdiseaseZNAz)SELECT term FROM mesh_data WHERE uid="{}"Útermz…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="{}"z{:,})rÚ disease_nameÚrun_numÚ processed_numZ valid_numÚ species_numÚ project_numZ genus_numZ PhenotypeTbl)rrrrÚqueryrÚlenr)rr r r Z site_itemÚ sql_diseaseZ site_diseaseZ site_resultr Zsql_disease_namerZsql_runsZruns_numrZvalidZsql_loaded_runsZ loaded_runsrZ loaded_runZ sql_speciesZspeciesZ sql_genusZgenusr r rÚtblDatasV           rcCs,|dkrdddgS|dkr"ddgS|gSdS)NzLarge intestineÚRectumÚColonÚCecumzSmall intestineÚIleumÚDuodenumr )rr r rrZs  rc CsÄt ¡}|dkrXd |¡}| |¡}xš|D](}d |d¡}| |¡d}||d<q*Wnhd |¡}| |¡}d} g}xJ|D]B}| dkrzd  |d¡} | | ¡} | rzt| ƒ| |¡| d 7} qzW|S) NÚidz€SELECT DISTINCT ncbi_taxon_id,taxon_rank_level from mbodymap_relative_species_abundances where ncbi_taxon_id LIKE "{}%" limit 10z6SELECT name FROM biosql_taxon_2 WHERE ncbi_taxon_id={}Z ncbi_taxon_idÚnamezbSELECT DISTINCT name, node_rank, ncbi_taxon_id from biosql_taxon_2 where name LIKE "%{}%" LIMIT 20ré zKSELECT * FROM mbodymap_relative_species_abundances where ncbi_taxon_id="{}"r)rrrrrÚprintr) Ú searchInputÚ searchOptr ÚsqlÚ searchResultr Úsql_namer"r ÚiÚ sql_existÚexistr r rÚ searchTaxacs0        r-c CsÄt ¡}|dkrXd |¡}| |¡}xš|D](}d |d¡}| |¡d}||d<q*Wnhd |¡}| |¡}d} g}xJ|D]B}| d krzd  |d ¡} | | ¡} | rzt| ƒ| |¡| d 7} qzW|S) Nr!zOSELECT DISTINCT disease from mbodymap_samples where disease LIKE "{}%" limit 10z)SELECT term FROM mesh_data WHERE uid="{}"rrr"zHSELECT DISTINCT term, uid from mesh_data where term LIKE "%{}%" LIMIT 20rr#z1SELECT * FROM mbodymap_samples where disease="{}"Úuidr)rrrrrr$r) r%r&r r'r(r r)r"r r*r+r,r r rÚsearchPhenotypes*         r/cCs t ¡}d |¡}| |¡}|S)Nz>SELECT BodySite FROM mbodymap_intro WHERE BodySite LIKE "%{}%")rrrr)r%r r'r r r rÚsearchBodysitešs  r0cCs 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  r1cCs 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  r2N) Úutilsrrrrr-r/r0r1r2r r r rÚs G