3 D`u@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 Csg}t|}tj}xf|D]\}dj|}|j|}g}x*|D] }|ddksB|ddkrbqBdj|d} |j| d} dj|d|} |j| d} dj|d|} |j| d } d }d j|d|}|j|}t|}x |D]}|d d kr|d 7}qWdj||d}|j|d}dj||d}|j|d}|j|d| dj| |||| |dqBW|j|d|iqW|S)NzASELECT 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="{}"z{:,})r disease_namerun_num processed_numZ valid_num species_num project_numZ genus_numZ PhenotypeTbl)rrrrqueryrlenr)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 rtblDatasV           rcCs,|dkrdddgS|dkr"ddgS|gSdS)NzLarge intestineRectumColonCecumzSmall intestineIleumDuodenumr )rr r rrZs  rc Cstj}|dkrXdj|}|j|}x|D](}dj|d}|j|d}||d<q*Wnhdj|}|j|}d} g}xJ|D]B}| dkrzd j|d} |j| } | rzt| |j|| d 7} qzW|S) NidzSELECT 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_idnamezbSELECT 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)rrrrrprintr) searchInput searchOptr sql searchResultr sql_namer"r i sql_existexistr r r searchTaxacs0        r-c Cstj}|dkrXdj|}|j|}x|D](}dj|d}|j|d}||d<q*Wnhdj|}|j|}d} g}xJ|D]B}| d krzd j|d } |j| } | rzt| |j|| 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 rsearchPhenotypes*         r/cCs tj}dj|}|j|}|S)Nz>SELECT BodySite FROM mbodymap_intro WHERE BodySite LIKE "%{}%")rrrr)r%r r'r r r rsearchBodysites  r0cCs 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  r1cCs 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  r2N) utilsrrrrr-r/r0r1r2r r r rs G