B ?wŁ`¤ć@s0ddlmZdd„Zdd„Zdd„Zdd „Zd S) é)Ś sqlConnectc Csht ”}d |”}| |”}||dt|dƒd t|dƒ”d t|dƒ”d t|dƒ”dœ}|S) NzŻSELECT name, COUNT(DISTINCT BodySite) site_num, COUNT(DISTINCT disease) disease_num, SUM(loaded_uid_num) total_runs, SUM(loaded_uid_num_QC1) valid_runs FROM mbodymap_species_to_samples WHERE ncbi_taxon_id={} GROUP BY nameŚnameŚsite_numz{:,}Ś total_runsŚ valid_runsŚ disease_num)Ś ncbi_taxon_idrrrrr)rŚMySQLConnectionŚformatŚqueryOneŚint)rŚconnectŚ sql_introŚintroŚresult©rśVC:\Users\Administrator\Desktop\mbodymap\mbodymap-server\service\taxonsToSiteService.pyŚgetSpeciesIntros  rcCs$t ”}d |||”}| |”}|S)Nz_SELECT * FROM mbodymap_species_to_site_relative_abundance WHERE ncbi_taxon_id={} ORDER BY {} {})rr r Śquery)rŚpropNameŚ propOrderr ŚsqlrrrrŚgetSpeciesDatas   rc Csht ”}d |”}| |”}||dt|dƒd t|dƒ”d t|dƒ”d t|dƒ”dœ}|S) NzŪSELECT name, COUNT(DISTINCT BodySite) site_num, COUNT(DISTINCT disease) disease_num, SUM(loaded_uid_num) total_runs, SUM(loaded_uid_num_QC1) valid_runs FROM mbodymap_genus_to_samples WHERE ncbi_taxon_id={} GROUP BY namerrz{:,}rrr)rrrrrr)rr r r r )rr rrrrrrŚ getGenusIntros  rcCs$t ”}d |||”}| |”}|S)Nz]SELECT * FROM mbodymap_genus_to_site_relative_abundance WHERE ncbi_taxon_id={} ORDER BY {} {})rr r r)rrrr rrrrrŚ getGenusData.s   rN)ŚutilsrrrrrrrrrŚs