Previous changeset 9:c32280662103 (2018-09-19) Next changeset 11:ecb6a28552d6 (2018-10-01) |
Commit message:
Master branch Updating - - Fxx |
modified:
t/hmdb_managerTest.pl t/lib/hmdbTest.pm test-data/out_test03.html test-data/out_test03.tabular test-data/out_test03.txt wsdl_hmdb.pl wsdl_hmdb.xml |
b |
diff -r c32280662103 -r 4eb2de7c24d1 t/hmdb_managerTest.pl --- a/t/hmdb_managerTest.pl Wed Sep 19 11:09:30 2018 -0400 +++ b/t/hmdb_managerTest.pl Mon Oct 01 10:36:30 2018 -0400 |
[ |
@@ -57,13 +57,49 @@ # '420.16,HMDB60838,C17H17N3O4S,359.093976737,M+IsoProp+H,+,420.159317,0.000683', # '420.16,HMDB60836,C17H17N3O4S,359.093976737,M+IsoProp+H,+,420.159317,0.000683' ## Update format - 2018-01-19... HMDB V04 - '175.01,HMDB0060293,Hydroxidodioxidosulfidosulfate,C05529,H2O3S2,113.94453531,M+IsoProp+H,+,175.009875,1', - '175.01,HMDB0003745,Mesna,C03576,C2H6O3S2,141.975835438,M+CH3OH+H,+,175.009324,4', - '175.01,HMDB0031436,Silicic acid,n/a,H4O4Si,95.987885149,M+DMSO+H,+,175.009105,5', - '175.01,HMDB0033657,De-o-methylsterigmatocystin,C03683,C17H10O6,310.047738052,M+H+K,+,175.009086,5', - '175.01,HMDB0035230,"6,7-Dihydroxy-3-(4-hydroxyphenyl)furo[3,2-b]chromen-2-one",n/a,C17H10O6,310.047738052,M+H+K,+,175.009086,5', - '420.16,HMDB0060838,"4-hydroxy-5-[(4-{2-[(5-hydroxy-1,2-dihydropyridin-2-ylidene)amino]ethoxy}phenyl)methyl]-2,5-dihydro-1,3-thiazol-2-one",n/a,C17H17N3O4S,359.093976737,M+IsoProp+H,+,420.159317,2', - '420.16,HMDB0060836,N-Desmethyl O-hydroxyrosiglitazone,n/a,C17H17N3O4S,359.093976737,M+IsoProp+H,+,420.159317,2', +# '175.01,HMDB0060293,Hydroxidodioxidosulfidosulfate,C05529,H2O3S2,113.94453531,M+IsoProp+H,+,175.009875,1', +# '175.01,HMDB0003745,Mesna,C03576,C2H6O3S2,141.975835438,M+CH3OH+H,+,175.009324,4', +# '175.01,HMDB0031436,Silicic acid,n/a,H4O4Si,95.987885149,M+DMSO+H,+,175.009105,5', +# '175.01,HMDB0033657,De-o-methylsterigmatocystin,C03683,C17H10O6,310.047738052,M+H+K,+,175.009086,5', +# '175.01,HMDB0035230,"6,7-Dihydroxy-3-(4-hydroxyphenyl)furo[3,2-b]chromen-2-one",n/a,C17H10O6,310.047738052,M+H+K,+,175.009086,5', +# '420.16,HMDB0060838,"4-hydroxy-5-[(4-{2-[(5-hydroxy-1,2-dihydropyridin-2-ylidene)amino]ethoxy}phenyl)methyl]-2,5-dihydro-1,3-thiazol-2-one",n/a,C17H17N3O4S,359.093976737,M+IsoProp+H,+,420.159317,2', +# '420.16,HMDB0060836,N-Desmethyl O-hydroxyrosiglitazone,n/a,C17H17N3O4S,359.093976737,M+IsoProp+H,+,420.159317,2', + ## Update results - 2018-09-20... HMDBv4 + #'query_mass,compound_id,compound_name,kegg_id,formula,monoisotopic_mass,adduct,adduct_type,adduct_m/z,delta(ppm)', + '175.01,HMDB0149376,"2-{[5,6-dihydroxy-3-(4-hydroxyphenyl)-4-oxo-3,4-dihydro-2H-1-benzopyran-7-yl]oxy}-3-(sulfooxy)butanedioic acid",n/a,C19H16O14S,500.026076369,M+2H+Na,+,175.009949,0', + '175.01,HMDB0149375,"2-({5,6-dihydroxy-4-oxo-3-[4-(sulfooxy)phenyl]-3,4-dihydro-2H-1-benzopyran-7-yl}oxy)-3-hydroxybutanedioic acid",n/a,C19H16O14S,500.026076369,M+2H+Na,+,175.009949,0', + '175.01,HMDB0149419,"2-{[5,8-dihydroxy-3-(4-hydroxyphenyl)-4-oxo-3,4-dihydro-2H-1-benzopyran-7-yl]oxy}-3-(sulfooxy)butanedioic acid",n/a,C19H16O14S,500.026076369,M+2H+Na,+,175.009949,0', + '175.01,HMDB0149418,"2-({5,8-dihydroxy-4-oxo-3-[4-(sulfooxy)phenyl]-3,4-dihydro-2H-1-benzopyran-7-yl}oxy)-3-hydroxybutanedioic acid",n/a,C19H16O14S,500.026076369,M+2H+Na,+,175.009949,0', + '175.01,HMDB0149392,"2-{[3-(3,4-dihydroxyphenyl)-5-hydroxy-4-oxo-3,4-dihydro-2H-1-benzopyran-7-yl]oxy}-3-(sulfooxy)butanedioic acid",n/a,C19H16O14S,500.026076369,M+2H+Na,+,175.009949,0', + '175.01,HMDB0149391,"2-hydroxy-3-({5-hydroxy-3-[4-hydroxy-3-(sulfooxy)phenyl]-4-oxo-3,4-dihydro-2H-1-benzopyran-7-yl}oxy)butanedioic acid",n/a,C19H16O14S,500.026076369,M+2H+Na,+,175.009949,0', + '175.01,HMDB0000257,Thiosulfate,C05529,H2O3S2,113.94453531,M+IsoProp+H,+,175.009875,1', + '175.01,HMDB0060293,Thiosulfate,C05529,H2O3S2,113.94453531,M+IsoProp+H,+,175.009875,1', + '175.01,HMDB0141391,{4-[(1E)-3-oxo-3-phenylprop-1-en-1-yl]phenyl}oxidanesulfonic acid,n/a,C15H12O5S,304.04054466,M+2Na,+,175.00949,3', + '175.01,HMDB0141389,{3-[(1E)-3-oxo-3-phenylprop-1-en-1-yl]phenyl}oxidanesulfonic acid,n/a,C15H12O5S,304.04054466,M+2Na,+,175.00949,3', + '175.01,HMDB0135622,{4-[(2E)-3-phenylprop-2-enoyl]phenyl}oxidanesulfonic acid,n/a,C15H12O5S,304.04054466,M+2Na,+,175.00949,3', + '175.01,HMDB0135448,{3-[(2E)-3-phenylprop-2-enoyl]phenyl}oxidanesulfonic acid,n/a,C15H12O5S,304.04054466,M+2Na,+,175.00949,3', + '175.01,HMDB0240280,Methanesulfonic acid,C11145,CH4O3S,95.988114684,M+DMSO+H,+,175.009335,4', + '175.01,HMDB0003745,Coenzyme m,C03576,C2H6O3S2,141.975835438,M+CH3OH+H,+,175.009324,4', + '175.01,HMDB0142159,[2-hydroxy-2-(2-hydroxyphenyl)-1-phenylethoxy]sulfonic acid,n/a,C14H14O6S,310.051109345,M+H+K,+,175.010772,4', + '175.01,HMDB0142160,[2-hydroxy-1-(2-hydroxyphenyl)-2-phenylethoxy]sulfonic acid,n/a,C14H14O6S,310.051109345,M+H+K,+,175.010772,4', + '175.01,HMDB0142162,"[3-(1,2-dihydroxy-2-phenylethyl)phenyl]oxidanesulfonic acid",n/a,C14H14O6S,310.051109345,M+H+K,+,175.010772,4', + '175.01,HMDB0142166,"[4-(1,2-dihydroxy-2-phenylethyl)phenyl]oxidanesulfonic acid",n/a,C14H14O6S,310.051109345,M+H+K,+,175.010772,4', + '175.01,HMDB0142164,[2-hydroxy-1-(3-hydroxyphenyl)-2-phenylethoxy]sulfonic acid,n/a,C14H14O6S,310.051109345,M+H+K,+,175.010772,4', + '175.01,HMDB0142163,[2-hydroxy-2-(3-hydroxyphenyl)-1-phenylethoxy]sulfonic acid,n/a,C14H14O6S,310.051109345,M+H+K,+,175.010772,4', + '175.01,HMDB0142167,[2-hydroxy-2-(4-hydroxyphenyl)-1-phenylethoxy]sulfonic acid,n/a,C14H14O6S,310.051109345,M+H+K,+,175.010772,4', + '175.01,HMDB0142168,[2-hydroxy-1-(4-hydroxyphenyl)-2-phenylethoxy]sulfonic acid,n/a,C14H14O6S,310.051109345,M+H+K,+,175.010772,4', + '175.01,HMDB0129951,"{3-[2-(3,5-dihydroxyphenyl)ethyl]phenyl}oxidanesulfonic acid",n/a,C14H14O6S,310.051109345,M+H+K,+,175.010772,4', + '175.01,HMDB0031436,Silicic acid,n/a,H4O4Si,95.987885149,M+DMSO+H,+,175.009105,5', + '175.01,HMDB0033657,"11,15-Dihydroxy-6,8,20-trioxapentacyclo[10.8.0.0²,⁹.0³,⁷.0¹⁴,¹⁹]icosa-1(12),2(9),4,10,14,16,18-heptaen-13-one",C03683,C17H10O6,310.047738052,M+H+K,+,175.009086,5', + '175.01,HMDB0035230,"6,7-Dihydroxy-3-(4-hydroxyphenyl)-2H-furo[3,2-b]chromen-2-one",n/a,C17H10O6,310.047738052,M+H+K,+,175.009086,5', + '175.01,HMDB0155176,5-Hydroxy-6-hydrouracil,n/a,C4H6N2O3,130.037842061,M+2Na-H,+,175.009002,6', + '420.16,HMDB0060838,N-Desmethyl-p-hydroxyrosiglitazone,n/a,C17H17N3O4S,359.093976737,M+IsoProp+H,+,420.159317,2', + '420.16,HMDB0060836,N-Desmethyl-O-hydroxy rosiglitazone,n/a,C17H17N3O4S,359.093976737,M+IsoProp+H,+,420.159317,2', + '420.16,HMDB0160148,"6-[(5-carboxy-3-methylpentanoyl)oxy]-3,4,5-trihydroxyoxane-2-carboxylic acid",n/a,C13H20O10,336.105646844,M+IsoProp+Na+H,+,420.160757,2', + '420.16,HMDB0160149,"6-[(5-carboxy-4-methylpentanoyl)oxy]-3,4,5-trihydroxyoxane-2-carboxylic acid",n/a,C13H20O10,336.105646844,M+IsoProp+Na+H,+,420.160757,2', + '420.16,HMDB0165020,"6-{[2-(acetyloxy)-3-methylbutanoyl]oxy}-3,4,5-trihydroxyoxane-2-carboxylic acid",n/a,C13H20O10,336.105646844,M+IsoProp+Na+H,+,420.160757,2', + '420.16,HMDB0175397,"6-{[3-(acetyloxy)-3-methylbutanoyl]oxy}-3,4,5-trihydroxyoxane-2-carboxylic acid",n/a,C13H20O10,336.105646844,M+IsoProp+Na+H,+,420.160757,2', + '420.16,HMDB0184353,"6-[(4-carboxy-3,3-dimethylbutanoyl)oxy]-3,4,5-trihydroxyoxane-2-carboxylic acid",n/a,C13H20O10,336.105646844,M+IsoProp+Na+H,+,420.160757,2' ], 'Method \'get_matches_from_hmdb_ua\' works with a well-formated string of mzs and return a complete csv from hmdb'); |
b |
diff -r c32280662103 -r 4eb2de7c24d1 t/lib/hmdbTest.pm --- a/t/lib/hmdbTest.pm Wed Sep 19 11:09:30 2018 -0400 +++ b/t/lib/hmdbTest.pm Mon Oct 01 10:36:30 2018 -0400 |
b |
@@ -45,6 +45,7 @@ my $oHmdb = lib::hmdb->new() ; my $hmdb_pages = $oHmdb->get_matches_from_hmdb_ua($hmdb_masses, $delta, $molecular_species) ; + print Dumper $hmdb_pages ; return ($hmdb_pages) ; } |
b |
diff -r c32280662103 -r 4eb2de7c24d1 test-data/out_test03.html --- a/test-data/out_test03.html Wed Sep 19 11:09:30 2018 -0400 +++ b/test-data/out_test03.html Mon Oct 01 10:36:30 2018 -0400 |
b |
b'@@ -1,1 +1,1 @@\n-<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE html><html lang="en"><head><meta charset="utf-8"><meta name="viewport" content="width=device-width, initial-scale=1.0"><meta name="description" content=""><meta name="author" content="INRA de Clermont-Ferrand"><title>Galaxy HMDB queries - All results</title><link rel="stylesheet" type="text/css" href="css.php" media="all"><link rel="stylesheet" type="text/css" href="https://cdn.rawgit.com/fgiacomoni/galaxy_utils/master/style/simplePagination.css"/><!-- JavaScript --><script src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"></script><script src="https://cdn.rawgit.com/fgiacomoni/galaxy_utils/master/scripts/jquery.simplePagination.js"></script><style type="text/css">body {padding-top: 70px}div.lm-table-warning { font-size: 1.4em; font-weight: bold; padding-right: 25px; color: #21536a; margin-left: 3px;}tr.green td {background-color: #eaf2d3; color: black;}tr.blank td {background-color: #9999CC; color: black;}table {font-family:\'Trebuchet MS\',Arial,Helvetica,sans-serif;width:100%;border-collapse:collapse;}table.detail, table.detail tr.parent, table.detail td, table.detail th, table.detail tr.category {border-collapse:collapse;border:1px solid #98bf21;}table.detail th {font-size: 1.2em;text-align: center;padding-top: 5px;padding-bottom: 10px;background-color: #a7c942;color: #ffffff;}td.ca {text-align:center;}footer { margin: 50px 0;}</style><script>function test(pageNumber){ var page="#page-id-"+pageNumber; $(\'.select\').hide() ; $(page).show()}</script></head><body><div class="container"><div class="lm-table-warning">Results of HMDB queries - Search params : Molecular specie = positive / delta (mass-to-charge ratio) = 0.05</div><div id="detail_table_source" style="display:none"></div><p><div id="choose"></div><p><div id="ms_search_0" class="ms-search-table"></div><!-- HeadRows--><table id="detail_table" class="detail"><col style="width:30px;"><!-- Ids (m/z)--><col style="width:30px;"><!-- Mass (m/z)--><col style="width:120px;"><!-- Met name--><col style="width:50px;"><!-- Cpd ID--><col style="width:40px;"><!-- formula--><col style="width:60px;"><!-- cpd mw--><col style="width:50px;"><!-- adduct --><col style="width:20px;"><!-- adduct type--><col style="width:60px;"><!-- adduct mw--><col style="width:50px;"><!-- delta--><col style="width:120px;"><!-- INCHI--><col style="width:20;"><!-- logP--><thead><th>ID from input</th><th>Mass (m/z)</th><th>Metabolite_Name</th><th>Compound_ID</th><th>Formula</th><th>Compound MW (Da)</th><th>Adduct</th><th>Adduct_Type</th><th>Adduct MW (Da)</th><th>Delta</th><th>InChI Identifier</th><th>Predicted LogP (ALOGPS)</th></thead><tbody class="select" id="page-id-1"><tr class="white"><td class="ca" >mz_00001</td><td id="1" class="ca" >175.01</td><td class="ca" colspan="10"></td></tr><tr class="white"><td class="ca" colspan="2"></td><td class="ca">Hydroxidodioxidosulfidosulfate</td><td class="ca"><a href="http://www.hmdb.ca/metabolites/HMDB0060293" target="_blank" class="btn">HMDB0060293</a></td><td class="ca">H2O3S2</td><td class="ca">113.94453531</td><td class="ca">M+IsoProp+H</td><td class="ca">+</td><td class="ca">175.009875</td><td class="ca">1</td><td class="ca">InChI=1S/H2O3S2/c1-5(2,3)4/h(H2,1,2,3,4)</td><td class="ca">NA</td></tr><tr class="white"><td class="ca" colspan="2"></td><td class="ca">Mesna</td><td class="ca"><a href="http://www.hmdb.ca/metabolites/HMDB0003745" target="_blank" class="btn">HMDB0003745</a></td><td class="ca">C2H6O3S2</td><td class="ca">141.975835438</td><td class="ca">M+CH3OH+H</td><td class="ca">+</td><td class="ca">175.009324</td><td class="ca">4</td><td class="ca">InChI=1S/C2H6O3S2/c3-7(4,5)2-1-6/h6H,1-2H2,(H,3,4,5)</td><td class="ca">-1.53</td></tr><tr class="white"><td class="ca" colspan="2"></td><td class="ca">Silicic acid</td><td class="ca"><a href="http://www.hmdb.ca/metabolites/HMDB0031436" target="_blank" class="btn">HMDB0031436</a></td><td class="ca">H4O4Si</td><td c'..b'td><td class="ca">UNKNOWN</td><td class="ca"><a href="http://www.hmdb.ca/metabolites/HMDB0168231" target="_blank" class="btn">HMDB0168231</a></td><td class="ca">C25H20O9</td><td class="ca">464.110732224</td><td class="ca">2M+2H+3H2O</td><td class="ca">+</td><td class="ca">956.244584</td><td class="ca">6</td><td class="ca">NA</td><td class="ca">NA</td></tr><tr class="white"><td class="ca" colspan="2"></td><td class="ca">UNKNOWN</td><td class="ca"><a href="http://www.hmdb.ca/metabolites/HMDB0138858" target="_blank" class="btn">HMDB0138858</a></td><td class="ca">C25H20O9</td><td class="ca">464.110732224</td><td class="ca">2M+2H+3H2O</td><td class="ca">+</td><td class="ca">956.244584</td><td class="ca">6</td><td class="ca">NA</td><td class="ca">NA</td></tr><tr class="white"><td class="ca" colspan="2"></td><td class="ca">UNKNOWN</td><td class="ca"><a href="http://www.hmdb.ca/metabolites/HMDB0168237" target="_blank" class="btn">HMDB0168237</a></td><td class="ca">C25H20O9</td><td class="ca">464.110732224</td><td class="ca">2M+2H+3H2O</td><td class="ca">+</td><td class="ca">956.244584</td><td class="ca">6</td><td class="ca">NA</td><td class="ca">NA</td></tr><tr class="green"><td class="ca" >mz_00006</td><td id="6" class="ca" >1100.45</td><td class="ca" colspan="10"></td></tr><tr class="green"><td class="ca" colspan="2"></td><td class="ca">NPC</td><td class="ca"><a href="http://www.hmdb.ca/metabolites/HMDB0060499" target="_blank" class="btn">HMDB0060499</a></td><td class="ca">C28H30N4O6</td><td class="ca">518.216534712</td><td class="ca">2M+ACN+Na</td><td class="ca">+</td><td class="ca">1100.448834</td><td class="ca">1</td><td class="ca">InChI=1S/C28H30N4O6/c1-3-17-18-11-16(38-27(35)31-9-7-15(29)8-10-31)5-6-22(18)30-24-19(17)13-32-23(24)12-21-20(25(32)33)14-37-26(34)28(21,36)4-2/h5-6,11-12,15,36H,3-4,7-10,13-14,29H2,1-2H3/t28-/m0/s1</td><td class="ca">2.40</td></tr><tr class="green"><td class="ca" colspan="2"></td><td class="ca">UNKNOWN</td><td class="ca"><a href="http://www.hmdb.ca/metabolites/HMDB0158990" target="_blank" class="btn">HMDB0158990</a></td><td class="ca">C24H38O10S</td><td class="ca">518.218568598</td><td class="ca">2M+ACN+Na</td><td class="ca">+</td><td class="ca">1100.452902</td><td class="ca">3</td><td class="ca">NA</td><td class="ca">NA</td></tr><tr class="green"><td class="ca" colspan="2"></td><td class="ca">UNKNOWN</td><td class="ca"><a href="http://www.hmdb.ca/metabolites/HMDB0158993" target="_blank" class="btn">HMDB0158993</a></td><td class="ca">C24H38O10S</td><td class="ca">518.218568598</td><td class="ca">2M+ACN+Na</td><td class="ca">+</td><td class="ca">1100.452902</td><td class="ca">3</td><td class="ca">NA</td><td class="ca">NA</td></tr><tr class="green"><td class="ca" colspan="2"></td><td class="ca">UNKNOWN</td><td class="ca"><a href="http://www.hmdb.ca/metabolites/HMDB0157972" target="_blank" class="btn">HMDB0157972</a></td><td class="ca">C24H38O10S</td><td class="ca">518.218568598</td><td class="ca">2M+ACN+Na</td><td class="ca">+</td><td class="ca">1100.452902</td><td class="ca">3</td><td class="ca">NA</td><td class="ca">NA</td></tr><tr class="green"><td class="ca" colspan="2"></td><td class="ca">UNKNOWN</td><td class="ca"><a href="http://www.hmdb.ca/metabolites/HMDB0158992" target="_blank" class="btn">HMDB0158992</a></td><td class="ca">C24H38O10S</td><td class="ca">518.218568598</td><td class="ca">2M+ACN+Na</td><td class="ca">+</td><td class="ca">1100.452902</td><td class="ca">3</td><td class="ca">NA</td><td class="ca">NA</td></tr></tbody></table></div><div class="container"><hr><footer><div class="row"> <div class="col-lg-12"><p>Copyright © INRA, N Paulhe, F Giacomoni 2014 </p> </div> </div> </footer></div><script language="javascript">$(function() {$(\'#choose\').pagination({items: 2,itemsOnPage: 1,currentPage: 1,onInit: function () { test(1); },cssStyle: \'light-theme\',onPageClick: function(pageNumber){test(pageNumber)}}).pagination(\'redraw\');});</script></body></html>\n\\ No newline at end of file\n' |
b |
diff -r c32280662103 -r 4eb2de7c24d1 test-data/out_test03.tabular --- a/test-data/out_test03.tabular Wed Sep 19 11:09:30 2018 -0400 +++ b/test-data/out_test03.tabular Mon Oct 01 10:36:30 2018 -0400 |
[ |
@@ -1,31 +1,31 @@ ID Query(Da) Delta Metabolite_Name Cpd_MW(Da) Formula Adduct Adduct_MW(Da) HMDB_ID -mz_00001 175.01 1 [Hydroxidodioxidosulfidosulfate] 113.94453531 H2O3S2 [M+IsoProp+H] 175.009875 HMDB0060293 -mz_00001 175.01 4 [Mesna] 141.975835438 C2H6O3S2 [M+CH3OH+H] 175.009324 HMDB0003745 -mz_00001 175.01 5 [Silicic acid] 95.987885149 H4O4Si [M+DMSO+H] 175.009105 HMDB0031436 -mz_00001 175.01 5 [De-O-methylsterigmatocystin] 310.047738052 C17H10O6 [M+H+K] 175.009086 HMDB0033657 -mz_00001 175.01 5 [Aurantricholide B] 310.047738052 C17H10O6 [M+H+K] 175.009086 HMDB0035230 +mz_00001 175.01 0 [UNKNOWN] 500.026076369 C19H16O14S [M+2H+Na] 175.009949 HMDB0149376 +mz_00001 175.01 0 [UNKNOWN] 500.026076369 C19H16O14S [M+2H+Na] 175.009949 HMDB0149375 +mz_00001 175.01 0 [UNKNOWN] 500.026076369 C19H16O14S [M+2H+Na] 175.009949 HMDB0149391 +mz_00001 175.01 0 [UNKNOWN] 500.026076369 C19H16O14S [M+2H+Na] 175.009949 HMDB0149392 +mz_00001 175.01 0 [UNKNOWN] 500.026076369 C19H16O14S [M+2H+Na] 175.009949 HMDB0149418 +mz_00002 238.19 4 [UNKNOWN] 154.1357652 C10H18O [M+IsoProp+Na+H] 238.190875 HMDB0163116 +mz_00002 238.19 4 [UNKNOWN] 154.1357652 C10H18O [M+IsoProp+Na+H] 238.190875 HMDB0187564 mz_00002 238.19 4 [Alpha-Terpineol] 154.135765198 C10H18O [M+IsoProp+Na+H] 238.190875 HMDB0004043 mz_00002 238.19 4 [(S)-alpha-Terpineol] 154.135765198 C10H18O [M+IsoProp+Na+H] 238.190875 HMDB0036086 mz_00002 238.19 4 [Eucalyptol] 154.1357652 C10H18O [M+IsoProp+Na+H] 238.190875 HMDB0004472 -mz_00002 238.19 4 [Geraniol] 154.1357652 C10H18O [M+IsoProp+Na+H] 238.190875 HMDB0005812 -mz_00002 238.19 4 [trans-(-)-p-Menth-1-en-3-ol] 154.135765198 C10H18O [M+IsoProp+Na+H] 238.190875 HMDB0035861 mz_00003 420.16 2 [N-Desmethyl-O-hydroxy rosiglitazone] 359.093976737 C17H17N3O4S [M+IsoProp+H] 420.159317 HMDB0060836 mz_00003 420.16 2 [N-Desmethyl-p-hydroxyrosiglitazone] 359.093976737 C17H17N3O4S [M+IsoProp+H] 420.159317 HMDB0060838 -mz_00003 420.16 3 [Benzyl glycinate 4-methylbenzenesulfonate salt] 337.098393413 C16H19NO5S [M+2ACN+H] 420.158763 HMDB0033374 -mz_00003 420.16 3 [Glutarylglycine] 189.063722467 C7H11NO5 [2M+ACN+H] 420.161268 HMDB0000590 -mz_00003 420.16 3 [N-Acetylglutamic acid] 189.063722467 C7H11NO5 [2M+ACN+H] 420.161268 HMDB0001138 +mz_00003 420.16 2 [UNKNOWN] 336.105646844 C13H20O10 [M+IsoProp+Na+H] 420.160757 HMDB0160148 +mz_00003 420.16 2 [UNKNOWN] 336.105646844 C13H20O10 [M+IsoProp+Na+H] 420.160757 HMDB0160149 +mz_00003 420.16 2 [UNKNOWN] 336.105646844 C13H20O10 [M+IsoProp+Na+H] 420.160757 HMDB0165020 +mz_00004 780.32 2 [UNKNOWN] 369.142366705 C17H23NO8 [2M+ACN+H] 780.318556 HMDB0162081 mz_00004 780.32 2 [Niazicinin A] 369.142366717 C17H23NO8 [2M+ACN+H] 780.318556 HMDB0031947 -mz_00004 780.32 7 [Mulberrofuran T] 716.298533006 C44H44O9 [M+ACN+Na] 780.314298 HMDB0035940 -mz_00004 780.32 10 [2'-Hydroxy-3',4',5',7,8-pentamethoxyflavan] 376.152203122 C20H24O7 [2M+3H2O+2H] 780.327526 HMDB0033906 -mz_00004 780.32 10 [trans-Grandmarin isovalerate] 376.152203122 C20H24O7 [2M+3H2O+2H] 780.327526 HMDB0039032 -mz_00004 780.32 10 [(1E,4Z,6a,8b,10a)-8-Angeloyloxy-10,15-dihydroxy-3-oxo-1,4,11(13)-germacratrien-12,6-olide] 376.152203122 C20H24O7 [2M+3H2O+2H] 780.327526 HMDB0032731 -mz_00005 956.25 6 [Pelargonidin 3-O-[b-D-Glucopyranosyl-(1->2)-[4-hydroxy-3-methoxy-(E)-cinnamoyl-(->6)]-b-D-glucopyranoside] 5-O-b-D-glucopyranoside] 933.266462874 C43H49O23 [M+Na] 956.255681 HMDB0035451 -mz_00005 956.25 6 [Petanin] 933.266462874 C43H49O23 [M+Na] 956.255681 HMDB0038095 -mz_00005 956.25 9 [UNKNOWN] 446.121296908 C22H22O10 [2M+ACN+Na] 956.258359 HMDB0153300 -mz_00005 956.25 9 [Kaempferide 3-rhamnoside] 446.121296924 C22H22O10 [2M+ACN+Na] 956.258359 HMDB0040803 -mz_00005 956.25 9 [2-(4-hydroxy-3-methoxyphenyl)-7-{[3,4,5-trihydroxy-6-(hydroxymethyl)oxan-2-yl]oxy}-4H-chromen-4-one] 446.121296908 C22H22O10 [2M+ACN+Na] 956.258359 HMDB0141944 +mz_00004 780.32 2 [UNKNOWN] 369.142366705 C17H23NO8 [2M+ACN+H] 780.318556 HMDB0162078 +mz_00004 780.32 2 [UNKNOWN] 369.142366705 C17H23NO8 [2M+ACN+H] 780.318556 HMDB0162083 +mz_00004 780.32 3 [UNKNOWN] 696.262935337 C33H44O16 [M+IsoProp+Na+H] 780.318045 HMDB0150342 +mz_00005 956.25 5 [PRE] 956.222252336 C44H44O24 [M+NH4-H2O] 956.244952 HMDB0041300 +mz_00005 956.25 6 [UNKNOWN] 464.110732224 C25H20O9 [2M+2H+3H2O] 956.244584 HMDB0168193 +mz_00005 956.25 6 [UNKNOWN] 464.110732224 C25H20O9 [2M+2H+3H2O] 956.244584 HMDB0168231 +mz_00005 956.25 6 [UNKNOWN] 464.110732224 C25H20O9 [2M+2H+3H2O] 956.244584 HMDB0138858 +mz_00005 956.25 6 [UNKNOWN] 464.110732224 C25H20O9 [2M+2H+3H2O] 956.244584 HMDB0168237 mz_00006 1100.45 1 [NPC] 518.216534712 C28H30N4O6 [2M+ACN+Na] 1100.448834 HMDB0060499 -mz_00006 1100.45 4 [Cellulose triacetate] 536.210967144 C30H34Cl2N4O [2M+3H2O+2H] 1100.445054 HMDB0032198 -mz_00006 1100.45 13 [Lewis X trisaccharide] 529.200669455 C20H35NO15 [2M+ACN+H] 1100.435162 HMDB0006568 -mz_00006 1100.45 13 [O-6-deoxy-a-L-galactopyranosyl-(1->2)-O-b-D-galactopyranosyl-(1->3)-2-(acetylamino)-2-deoxy-D-Galactose] 529.200669455 C20H35NO15 [2M+ACN+H] 1100.435162 HMDB0002060 -mz_00006 1100.45 13 [Lewis a trisaccharide] 529.200669455 C20H35NO15 [2M+ACN+H] 1100.435162 HMDB0006582 +mz_00006 1100.45 3 [UNKNOWN] 518.218568598 C24H38O10S [2M+ACN+Na] 1100.452902 HMDB0158990 +mz_00006 1100.45 3 [UNKNOWN] 518.218568598 C24H38O10S [2M+ACN+Na] 1100.452902 HMDB0158993 +mz_00006 1100.45 3 [UNKNOWN] 518.218568598 C24H38O10S [2M+ACN+Na] 1100.452902 HMDB0157972 +mz_00006 1100.45 3 [UNKNOWN] 518.218568598 C24H38O10S [2M+ACN+Na] 1100.452902 HMDB0158992 |
b |
diff -r c32280662103 -r 4eb2de7c24d1 test-data/out_test03.txt --- a/test-data/out_test03.txt Wed Sep 19 11:09:30 2018 -0400 +++ b/test-data/out_test03.txt Mon Oct 01 10:36:30 2018 -0400 |
[ |
@@ -1,31 +1,31 @@ ID Query(Da) Delta Metabolite_Name Cpd_MW(Da) Formula Adduct Adduct_MW(Da) HMDB_ID -mz_00001 175.01 1 [Hydroxidodioxidosulfidosulfate] 113.94453531 H2O3S2 [M+IsoProp+H] 175.009875 HMDB0060293 -mz_00001 175.01 4 [Mesna] 141.975835438 C2H6O3S2 [M+CH3OH+H] 175.009324 HMDB0003745 -mz_00001 175.01 5 [Silicic acid] 95.987885149 H4O4Si [M+DMSO+H] 175.009105 HMDB0031436 -mz_00001 175.01 5 [De-O-methylsterigmatocystin] 310.047738052 C17H10O6 [M+H+K] 175.009086 HMDB0033657 -mz_00001 175.01 5 [Aurantricholide B] 310.047738052 C17H10O6 [M+H+K] 175.009086 HMDB0035230 +mz_00001 175.01 0 [UNKNOWN] 500.026076369 C19H16O14S [M+2H+Na] 175.009949 HMDB0149376 +mz_00001 175.01 0 [UNKNOWN] 500.026076369 C19H16O14S [M+2H+Na] 175.009949 HMDB0149375 +mz_00001 175.01 0 [UNKNOWN] 500.026076369 C19H16O14S [M+2H+Na] 175.009949 HMDB0149391 +mz_00001 175.01 0 [UNKNOWN] 500.026076369 C19H16O14S [M+2H+Na] 175.009949 HMDB0149392 +mz_00001 175.01 0 [UNKNOWN] 500.026076369 C19H16O14S [M+2H+Na] 175.009949 HMDB0149418 +mz_00002 238.19 4 [UNKNOWN] 154.1357652 C10H18O [M+IsoProp+Na+H] 238.190875 HMDB0163116 +mz_00002 238.19 4 [UNKNOWN] 154.1357652 C10H18O [M+IsoProp+Na+H] 238.190875 HMDB0187564 mz_00002 238.19 4 [Alpha-Terpineol] 154.135765198 C10H18O [M+IsoProp+Na+H] 238.190875 HMDB0004043 mz_00002 238.19 4 [(S)-alpha-Terpineol] 154.135765198 C10H18O [M+IsoProp+Na+H] 238.190875 HMDB0036086 mz_00002 238.19 4 [Eucalyptol] 154.1357652 C10H18O [M+IsoProp+Na+H] 238.190875 HMDB0004472 -mz_00002 238.19 4 [Geraniol] 154.1357652 C10H18O [M+IsoProp+Na+H] 238.190875 HMDB0005812 -mz_00002 238.19 4 [trans-(-)-p-Menth-1-en-3-ol] 154.135765198 C10H18O [M+IsoProp+Na+H] 238.190875 HMDB0035861 mz_00003 420.16 2 [N-Desmethyl-O-hydroxy rosiglitazone] 359.093976737 C17H17N3O4S [M+IsoProp+H] 420.159317 HMDB0060836 mz_00003 420.16 2 [N-Desmethyl-p-hydroxyrosiglitazone] 359.093976737 C17H17N3O4S [M+IsoProp+H] 420.159317 HMDB0060838 -mz_00003 420.16 3 [Benzyl glycinate 4-methylbenzenesulfonate salt] 337.098393413 C16H19NO5S [M+2ACN+H] 420.158763 HMDB0033374 -mz_00003 420.16 3 [Glutarylglycine] 189.063722467 C7H11NO5 [2M+ACN+H] 420.161268 HMDB0000590 -mz_00003 420.16 3 [N-Acetylglutamic acid] 189.063722467 C7H11NO5 [2M+ACN+H] 420.161268 HMDB0001138 +mz_00003 420.16 2 [UNKNOWN] 336.105646844 C13H20O10 [M+IsoProp+Na+H] 420.160757 HMDB0160148 +mz_00003 420.16 2 [UNKNOWN] 336.105646844 C13H20O10 [M+IsoProp+Na+H] 420.160757 HMDB0160149 +mz_00003 420.16 2 [UNKNOWN] 336.105646844 C13H20O10 [M+IsoProp+Na+H] 420.160757 HMDB0165020 +mz_00004 780.32 2 [UNKNOWN] 369.142366705 C17H23NO8 [2M+ACN+H] 780.318556 HMDB0162081 mz_00004 780.32 2 [Niazicinin A] 369.142366717 C17H23NO8 [2M+ACN+H] 780.318556 HMDB0031947 -mz_00004 780.32 7 [Mulberrofuran T] 716.298533006 C44H44O9 [M+ACN+Na] 780.314298 HMDB0035940 -mz_00004 780.32 10 [2'-Hydroxy-3',4',5',7,8-pentamethoxyflavan] 376.152203122 C20H24O7 [2M+3H2O+2H] 780.327526 HMDB0033906 -mz_00004 780.32 10 [trans-Grandmarin isovalerate] 376.152203122 C20H24O7 [2M+3H2O+2H] 780.327526 HMDB0039032 -mz_00004 780.32 10 [(1E,4Z,6a,8b,10a)-8-Angeloyloxy-10,15-dihydroxy-3-oxo-1,4,11(13)-germacratrien-12,6-olide] 376.152203122 C20H24O7 [2M+3H2O+2H] 780.327526 HMDB0032731 -mz_00005 956.25 6 [Pelargonidin 3-O-[b-D-Glucopyranosyl-(1->2)-[4-hydroxy-3-methoxy-(E)-cinnamoyl-(->6)]-b-D-glucopyranoside] 5-O-b-D-glucopyranoside] 933.266462874 C43H49O23 [M+Na] 956.255681 HMDB0035451 -mz_00005 956.25 6 [Petanin] 933.266462874 C43H49O23 [M+Na] 956.255681 HMDB0038095 -mz_00005 956.25 9 [UNKNOWN] 446.121296908 C22H22O10 [2M+ACN+Na] 956.258359 HMDB0153300 -mz_00005 956.25 9 [Kaempferide 3-rhamnoside] 446.121296924 C22H22O10 [2M+ACN+Na] 956.258359 HMDB0040803 -mz_00005 956.25 9 [2-(4-hydroxy-3-methoxyphenyl)-7-{[3,4,5-trihydroxy-6-(hydroxymethyl)oxan-2-yl]oxy}-4H-chromen-4-one] 446.121296908 C22H22O10 [2M+ACN+Na] 956.258359 HMDB0141944 +mz_00004 780.32 2 [UNKNOWN] 369.142366705 C17H23NO8 [2M+ACN+H] 780.318556 HMDB0162078 +mz_00004 780.32 2 [UNKNOWN] 369.142366705 C17H23NO8 [2M+ACN+H] 780.318556 HMDB0162083 +mz_00004 780.32 3 [UNKNOWN] 696.262935337 C33H44O16 [M+IsoProp+Na+H] 780.318045 HMDB0150342 +mz_00005 956.25 5 [PRE] 956.222252336 C44H44O24 [M+NH4-H2O] 956.244952 HMDB0041300 +mz_00005 956.25 6 [UNKNOWN] 464.110732224 C25H20O9 [2M+2H+3H2O] 956.244584 HMDB0168193 +mz_00005 956.25 6 [UNKNOWN] 464.110732224 C25H20O9 [2M+2H+3H2O] 956.244584 HMDB0168231 +mz_00005 956.25 6 [UNKNOWN] 464.110732224 C25H20O9 [2M+2H+3H2O] 956.244584 HMDB0138858 +mz_00005 956.25 6 [UNKNOWN] 464.110732224 C25H20O9 [2M+2H+3H2O] 956.244584 HMDB0168237 mz_00006 1100.45 1 [NPC] 518.216534712 C28H30N4O6 [2M+ACN+Na] 1100.448834 HMDB0060499 -mz_00006 1100.45 4 [Cellulose triacetate] 536.210967144 C30H34Cl2N4O [2M+3H2O+2H] 1100.445054 HMDB0032198 -mz_00006 1100.45 13 [Lewis X trisaccharide] 529.200669455 C20H35NO15 [2M+ACN+H] 1100.435162 HMDB0006568 -mz_00006 1100.45 13 [O-6-deoxy-a-L-galactopyranosyl-(1->2)-O-b-D-galactopyranosyl-(1->3)-2-(acetylamino)-2-deoxy-D-Galactose] 529.200669455 C20H35NO15 [2M+ACN+H] 1100.435162 HMDB0002060 -mz_00006 1100.45 13 [Lewis a trisaccharide] 529.200669455 C20H35NO15 [2M+ACN+H] 1100.435162 HMDB0006582 +mz_00006 1100.45 3 [UNKNOWN] 518.218568598 C24H38O10S [2M+ACN+Na] 1100.452902 HMDB0158990 +mz_00006 1100.45 3 [UNKNOWN] 518.218568598 C24H38O10S [2M+ACN+Na] 1100.452902 HMDB0158993 +mz_00006 1100.45 3 [UNKNOWN] 518.218568598 C24H38O10S [2M+ACN+Na] 1100.452902 HMDB0157972 +mz_00006 1100.45 3 [UNKNOWN] 518.218568598 C24H38O10S [2M+ACN+Na] 1100.452902 HMDB0158992 |
b |
diff -r c32280662103 -r 4eb2de7c24d1 wsdl_hmdb.pl --- a/wsdl_hmdb.pl Wed Sep 19 11:09:30 2018 -0400 +++ b/wsdl_hmdb.pl Mon Oct 01 10:36:30 2018 -0400 |
b |
@@ -123,7 +123,7 @@ $oHmdb->check_state_from_hmdb_ua($status) ; ## can kill the script execution foreach my $mzs ( @{$submasses} ) { - print Dumper $mzs ; +# print Dumper $mzs ; my $result = undef ; my ( $hmdb_masses, $nb_masses_to_submit ) = $oHmdb->prepare_multi_masses_query($mzs) ; $hmdb_pages = $oHmdb->get_matches_from_hmdb_ua($hmdb_masses, $delta, $molecular_species) ; @@ -139,9 +139,9 @@ ## Map metabocards with results (add supplementary data) - print Dumper $results ; - print Dumper $hmdb_ids ; - print Dumper $metabocard_features ; +# print Dumper $results ; +# print Dumper $hmdb_ids ; +# print Dumper $metabocard_features ; if ( ( defined $results ) and ( defined $metabocard_features ) ) { $results = $oHmdb->map_suppl_data_on_hmdb_results($results, $metabocard_features) ; |
b |
diff -r c32280662103 -r 4eb2de7c24d1 wsdl_hmdb.xml --- a/wsdl_hmdb.xml Wed Sep 19 11:09:30 2018 -0400 +++ b/wsdl_hmdb.xml Mon Oct 01 10:36:30 2018 -0400 |
b |
@@ -4,10 +4,10 @@ </description> <requirements> + <requirement type="package" version="2.97">perl-html-template</requirement> <requirement type="package" version="1.19">perl-soap-lite</requirement> <requirement type="package" version="6.15">perl-lwp-simple</requirement> <requirement type="package" version="6.15">perl-libwww-perl</requirement> - <requirement type="package" version="2.95">perl-html-template</requirement> <requirement type="package" version="1.74">perl-uri</requirement> <requirement type="package" version="1.97">perl-text-csv</requirement> <requirement type="package" version="3.52">perl-xml-twig</requirement> @@ -91,8 +91,9 @@ </outputs> <tests> +<!-- <test> - <!--test 01 no result - fake-mzrt-input-with-id --> + <!~~test 01 no result - fake-mzrt-input-with-id ~~> <param name="choice" value="YES"/> <param name="masses" value="input_test01_fake-mzrt-input-with-id.tabular"/> <param name="header_choice" value="yes"/> @@ -106,7 +107,7 @@ <output name="HmdbOutXlsx" file="out_test01.txt"/> </test> <test> - <!--test 02 : some results - with-mzrt-input-with-id file--> + <!~~test 02 : some results - with-mzrt-input-with-id file~~> <param name="choice" value="YES"/> <param name="masses" value="input_test02_mzrt-input-with-id.tabular"/> <param name="header_choice" value="yes"/> @@ -119,6 +120,7 @@ <output name="HmdbOutWeb" file="out_test02.html"/> <output name="HmdbOutXlsx" file="out_test02.txt"/> </test> + --> <test> <!--test 03 : some results - with-mz list in manual mass mode--> <param name="choice" value="NO"/> |