Validation Log
2025-12-15 01:45:47.811977
mwtab Python Library Version: 2.0.0
Source:        https://www.metabolomicsworkbench.org/rest/study/analysis_id/AN004891/mwtab/json
Study ID:      ST002978
Analysis ID:   AN004891
File format:   json
Status: Contains Validation Issues
Number of Issues: 12

Number of Warnings: 8

Number of Value Errors: 9

Number of Consistency Errors: 0

Number of Format Errors: 1

Issue Log:
Error: An empty value or a null value was detected in ["STUDY"]["NUM_MALES"]. 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 ["STUDY"]["NUM_FEMALES"]. Either a legitimate value should be provided for this key, or it should be removed altogether.
Error: The value, "40-50", in ["CHROMATOGRAPHY"]["COLUMN_TEMPERATURE"] should be a number or range (ex. "5-6") followed by a space with a unit (ex. "5 V") from the following list: ['°C', 'C']. Ignore this when more complicated descriptions are required.
Warning: The "PUBCHEM" column at position 5 in the ["MS_METABOLITE_DATA"]["Metabolites"] table, matches a standard column name, "pubchem_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 "KEGG" column at position 3 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 "KEGG" column at position 3 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:
0                C00612   C01029
21               C02532   C01005
62               C00487   C00308
84               C03104   C05822
89               C21189   C03626
105              C00025   C00217
108              D00031   C00127
131     C16424   C00407   C06418
139              C00047   C00739
199             C00148   C000763
221    DG00125   C00378   D08580
Warning: The "HMDB" column at position 4 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 "HMDB" column at position 4 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      HMDB0001276   HMDB0002189
21     HMDB0000272   HMDB0001721
84     HMDB0240312   HMDB0011692
89     HMDB0003334   HMDB0001539
199    HMDB0000162   HMDB0003411
Warning: The "Comp ID" column at position 2 in the ["MS_METABOLITE_DATA"]["Metabolites"] table, matches a standard column name, "other_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 column "Comp ID" was found in the ["MS_METABOLITE_DATA"]["Metabolites"] table, but this column implies that another column, "other_id_type", should also exist, and that column was not found.
Warning: The standard column, "other_id", was found in the METABOLITES table as "Comp ID". If this column contains database IDs for standard databases such as KEGG, PubChem, HMDB, etc., it is recommended to make individual columns for these and not lump them together into a less descriptive "other_id" column.
Error: The ["MS_METABOLITE_DATA"]["Data"] table does not have a column for "Metabolite". It is likely misspelled or using a common incorrect substitute.