Validation Log
2025-12-15 02:31:30.276281
mwtab Python Library Version: 2.0.0
Source:        https://www.metabolomicsworkbench.org/rest/study/analysis_id/AN005782/mwtab/json
Study ID:      ST003521
Analysis ID:   AN005782
File format:   json
Status: Contains Validation Issues
Number of Issues: 22

Number of Warnings: 9

Number of Value Errors: 22

Number of Consistency Errors: 0

Number of Format Errors: 0

Issue Log:
Error: The value, "NA", in ["SUBJECT"]["AGE_OR_AGE_RANGE"] should be a number or range (ex. "5-6") followed by a space with a unit (ex. "5 V") from the following list: ['weeks', 'days', 'months', 'years']. Ignore this when more complicated descriptions are required.
Error: The value, "NA", in ["SUBJECT"]["WEIGHT_OR_WEIGHT_RANGE"] should be a number or range (ex. "5-6") followed by a space with a unit (ex. "5 V") from the following list: ['g', 'mg', 'kg', 'lbs']. Ignore this when more complicated descriptions are required.
Error: The value, "NA", in ["SUBJECT"]["HEIGHT_OR_HEIGHT_RANGE"] should be a number or range (ex. "5-6") followed by a space with a unit (ex. "5 V") from the following list: ['cm', 'in']. Ignore this when more complicated descriptions are required.
Error: The value, "Not applicable", in ["SUBJECT"]["GENDER"] should be one of "Male", "Female", "Male, Female", "Hermaphrodite", or "N/A". Ignore this when more complicated descriptions are required.
Error: An empty value or a null value was detected in ["SUBJECT"]["CELL_BIOSOURCE_OR_SUPPLIER"]. Either a legitimate value should be provided for this key, or it should be removed altogether.
Error: An empty value or a null value was detected in ["SUBJECT"]["CELL_STRAIN_DETAILS"]. Either a legitimate value should be provided for this key, or it should be removed altogether.
Error: An empty value or a null value was detected in ["SUBJECT"]["SUBJECT_COMMENTS"]. Either a legitimate value should be provided for this key, or it should be removed altogether.
Error: An empty value or a null value was detected in ["SUBJECT"]["CELL_PRIMARY_IMMORTALIZED"]. Either a legitimate value should be provided for this key, or it should be removed altogether.
Error: An empty value or a null value was detected in ["SUBJECT"]["CELL_PASSAGE_NUMBER"]. Either a legitimate value should be provided for this key, or it should be removed altogether.
Error: An empty value or a null value was detected in ["SUBJECT"]["CELL_COUNTS"]. Either a legitimate value should be provided for this key, or it should be removed altogether.
Error: An empty value or a null value was detected in ["SUBJECT"]["SPECIES_GROUP"]. Either a legitimate value should be provided for this key, or it should be removed altogether.
Error: The value, "0.3 ml/min", in ["CHROMATOGRAPHY"]["FLOW_RATE"] should be a number or range (ex. "5-6") followed by a space with a unit (ex. "5 V") from the following list: ['mL/min', 'uL/min', 'μL/min']. Ignore this when more complicated descriptions are required.
Error: The value, "60 bar at starting conditions. 180 bar at %A", in ["CHROMATOGRAPHY"]["COLUMN_PRESSURE"] should be a number or range (ex. "5-6") followed by a space with a unit (ex. "5 V") from the following list: ['psi', 'bar']. Ignore this when more complicated descriptions are required.
Warning: The "InchiKEY" column at position 6 in the ["MS_METABOLITE_DATA"]["Metabolites"] table, matches a standard column name, "inchi_key". If this match was not in error, the column should be renamed to the standard name or a name that doesn't resemble the standard name.
Warning: The "InchiKEY" column at position 6 in the ["MS_METABOLITE_DATA"]["Metabolites"] table, matches a standard column name, "inchi_key", and some of the values in the column do not match the expected type or format for that column. The non-matching values are:
10     0
18     0
21     0
23     0
25     0
30     0
39     0
42     0
54     0
65     0
69     0
79     0
91     0
93     0
94     0
96     0
97     0
99     0
100    0
101    0
103    0
106    0
108    0
110    0
112    0
116    0
121    0
122    0
132    0
133    0
135    0
142    0
146    0
151    0
154    0
159    0
168    0
169    0
170    0
172    0
174    0
176    0
183    0
192    0
197    0
198    0
208    0
215    0
230    0
231    0
233    0
249    0
266    0
267    0
272    0
276    0
277    0
284    0
285    0
293    0
296    0
316    0
320    0
321    0
323    0
326    0
339    0
345    0
349    0
356    0
359    0
367    0
369    0
371    0
374    0
375    0
376    0
377    0
382    0
396    0
397    0
400    0
410    0
414    0
427    0
434    0
436    0
439    0
440    0
442    0
446    0
453    0
456    0
457    0
459    0
461    0
462    0
465    0
467    0
469    0
472    0
474    0
477    0
482    0
484    0
491    0
494    0
503    0
510    0
Warning: The "KEGGid" column at position 4 in the ["MS_METABOLITE_DATA"]["Metabolites"] table, matches a standard column name, "kegg_id". If this match was not in error, the column should be renamed to the standard name or a name that doesn't resemble the standard name.
Warning: The "KEGGid" column at position 4 in the ["MS_METABOLITE_DATA"]["Metabolites"] table, matches a standard column name, "kegg_id", and some of the values in the column do not match the expected type or format for that column. The non-matching values are:
9      0
10     0
11     0
13     0
17     0
18     0
21     0
23     0
25     0
30     0
31     0
34     0
37     0
38     0
39     0
42     0
43     0
54     0
57     0
62     0
65     0
66     0
69     0
71     0
77     0
79     0
81     0
91     0
93     0
94     0
96     0
97     0
99     0
100    0
101    0
102    0
103    0
106    0
107    0
108    0
109    0
110    0
111    0
112    0
113    0
116    0
117    0
118    0
120    0
121    0
122    0
124    0
125    0
127    0
132    0
133    0
135    0
138    0
142    0
143    0
145    0
146    0
149    0
150    0
151    0
152    0
154    0
158    0
159    0
160    0
166    0
168    0
169    0
170    0
172    0
174    0
176    0
179    0
180    0
181    0
183    0
185    0
186    0
188    0
189    0
191    0
192    0
196    0
197    0
198    0
199    0
205    0
206    0
208    0
212    0
213    0
214    0
215    0
216    0
221    0
226    0
227    0
230    0
231    0
233    0
236    0
238    0
239    0
240    0
243    0
244    0
245    0
247    0
249    0
252    0
253    0
259    0
263    0
265    0
266    0
267    0
269    0
270    0
272    0
273    0
276    0
280    0
282    0
284    0
285    0
287    0
288    0
289    0
292    0
293    0
296    0
297    0
298    0
300    0
301    0
304    0
306    0
308    0
309    0
311    0
315    0
316    0
319    0
320    0
321    0
322    0
323    0
325    0
326    0
332    0
333    0
335    0
338    0
339    0
340    0
343    0
345    0
346    0
349    0
352    0
354    0
355    0
356    0
358    0
359    0
364    0
365    0
366    0
367    0
368    0
369    0
371    0
374    0
375    0
376    0
377    0
378    0
379    0
380    0
381    0
382    0
385    0
386    0
388    0
396    0
397    0
398    0
400    0
404    0
407    0
409    0
410    0
411    0
413    0
414    0
420    0
422    0
423    0
427    0
428    0
434    0
436    0
438    0
439    0
440    0
441    0
442    0
445    0
446    0
447    0
448    0
451    0
453    0
454    0
456    0
457    0
459    0
461    0
462    0
464    0
465    0
467    0
469    0
471    0
472    0
473    0
474    0
477    0
478    0
479    0
482    0
484    0
485    0
487    0
488    0
491    0
492    0
494    0
495    0
497    0
499    0
502    0
503    0
510    0
511    0
Warning: The "HMDBID" column at position 7 in the ["MS_METABOLITE_DATA"]["Metabolites"] table, matches a standard column name, "hmdb_id". If this match was not in error, the column should be renamed to the standard name or a name that doesn't resemble the standard name.
Warning: The "HMDBID" column at position 7 in the ["MS_METABOLITE_DATA"]["Metabolites"] table, matches a standard column name, "hmdb_id", and some of the values in the column do not match the expected type or format for that column. The non-matching values are:
0      0
5      0
10     0
11     0
12     0
14     0
17     0
18     0
21     0
22     0
23     0
25     0
30     0
35     0
38     0
39     0
42     0
43     0
48     0
54     0
57     0
65     0
69     0
77     0
79     0
82     0
85     0
86     0
88     0
89     0
91     0
92     0
93     0
94     0
96     0
97     0
99     0
100    0
101    0
102    0
103    0
104    0
106    0
107    0
108    0
110    0
113    0
116    0
117    0
118    0
119    0
120    0
121    0
122    0
123    0
124    0
125    0
127    0
129    0
132    0
133    0
135    0
142    0
145    0
146    0
151    0
152    0
153    0
154    0
159    0
160    0
167    0
168    0
169    0
170    0
172    0
173    0
176    0
177    0
178    0
179    0
182    0
183    0
187    0
188    0
190    0
192    0
193    0
195    0
197    0
198    0
201    0
202    0
203    0
204    0
206    0
208    0
212    0
214    0
215    0
216    0
217    0
224    0
228    0
230    0
231    0
233    0
240    0
242    0
243    0
247    0
249    0
252    0
253    0
255    0
256    0
258    0
259    0
260    0
263    0
264    0
266    0
267    0
276    0
278    0
279    0
284    0
285    0
287    0
292    0
293    0
294    0
302    0
303    0
305    0
307    0
311    0
316    0
318    0
320    0
321    0
322    0
323    0
326    0
328    0
330    0
331    0
333    0
335    0
336    0
337    0
339    0
340    0
343    0
345    0
347    0
348    0
349    0
354    0
355    0
356    0
357    0
359    0
361    0
362    0
367    0
369    0
370    0
371    0
374    0
375    0
376    0
377    0
380    0
382    0
385    0
387    0
389    0
391    0
394    0
395    0
396    0
397    0
398    0
400    0
405    0
410    0
412    0
413    0
414    0
417    0
419    0
420    0
421    0
427    0
428    0
430    0
433    0
435    0
436    0
439    0
440    0
442    0
443    0
446    0
450    0
452    0
453    0
457    0
459    0
460    0
461    0
462    0
464    0
465    0
467    0
469    0
470    0
471    0
472    0
473    0
474    0
477    0
480    0
481    0
482    0
484    0
485    0
486    0
488    0
489    0
490    0
491    0
492    0
493    0
494    0
496    0
497    0
498    0
501    0
503    0
506    0
510    0
Warning: The "Lmid" column at position 5 in the ["MS_METABOLITE_DATA"]["Metabolites"] table, matches a standard column name, "lm_id". If this match was not in error, the column should be renamed to the standard name or a name that doesn't resemble the standard name.
Warning: The "Retention time" column at position 2 in the ["MS_METABOLITE_DATA"]["Metabolites"] table, matches a standard column name, "retention_time". If this match was not in error, the column should be renamed to the standard name or a name that doesn't resemble the standard name.
Warning: The "Lmid" column at position 5 in the ["MS_METABOLITE_DATA"]["Metabolites"] table may have incorrect values. 90% or more of the values are the same, but 10% or less are different.