Validation Log
2025-12-14 23:58:45.215296
mwtab Python Library Version: 2.0.0
Source:        https://www.metabolomicsworkbench.org/rest/study/analysis_id/AN003156/mwtab/json
Study ID:      ST001940
Analysis ID:   AN003156
File format:   json
Status: Contains Validation Issues
Number of Issues: 20

Number of Warnings: 13

Number of Value Errors: 12

Number of Consistency Errors: 0

Number of Format Errors: 5

Issue Log:
Error: The value, "20-70", 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, "Male and female", in ["SUBJECT"]["GENDER"] should be one of "Male", "Female", "Male, Female", "Hermaphrodite", or "N/A". Ignore this when more complicated descriptions are required.
Error: The required property, "FLOW_GRADIENT", in ["CHROMATOGRAPHY"] is missing.
Error: The required property, "FLOW_RATE", in ["CHROMATOGRAPHY"] is missing.
Error: The required property, "COLUMN_TEMPERATURE", in ["CHROMATOGRAPHY"] is missing.
Error: The required property, "SOLVENT_A", in ["CHROMATOGRAPHY"] is missing.
Error: The required property, "SOLVENT_B", in ["CHROMATOGRAPHY"] is missing.
Warning: The "SUPER PATHWAY" column at position 2 in the ["MS_METABOLITE_DATA"]["Metabolites"] table, matches a standard column name, "pathway". 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 "SUB PATHWAY" column at position 3 in the ["MS_METABOLITE_DATA"]["Metabolites"] table, matches a standard column name, "pathway". 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 "PUBCHEM" column at position 10 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 11 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 "Group HMDB" column at position 12 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 "CAS" column at position 9 in the ["MS_METABOLITE_DATA"]["Metabolites"] table, matches a standard column name, "cas_number". 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 "CAS" column at position 9 in the ["MS_METABOLITE_DATA"]["Metabolites"] table, matches a standard column name, "cas_number", and some of the values in the column do not match the expected type or format for that column. The non-matching values are:
21              2458-08-4;2458-08-4
56            26853-31-6;26853-31-6
81               542-32-5;1118-90-7
126          10569-72-9;214139-20-5
135             588-30-7;14755-02-3
152            1460-34-0;51829-07-3
166           10066-90-7;32113-41-0
169                463-003;463-00-3
240    305-72-6;328-50-7;22202-68-2
242              59-02-9;10191-41-0
276                56-41-7;107-95-9
286           55482-27-4;55482-27-4
292              462-94-2;1476-39-7
316               474-24-9;474-25-9
333                 52-90-4;56-89-3
355             1476-39-7;2577-62-0
362                 59-92-7;63-84-3
382            10-2005-9;10417-94-4
434             1499-55-4;1499-55-4
450               475-31-0;863-57-0
551          141-82-2;26522-22-85-0
582             5657-19-2;5657-19-2
599               997-55-7;997-55-7
639             603-61-2;14259-47-3
666          58725-46-5;474943-14-1
682                11-58-0;111-58-0
747             553-12-8;50865-10-5
809               87-69-4;6106-24-7
849                69-93-2;120K5305
870                          59-007
Warning: The "COMP ID" column at position 4 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 "CHEMICAL ID" column at position 6 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 "RI" column at position 7 in the ["MS_METABOLITE_DATA"]["Metabolites"] table, matches a standard column name, "retention_index". 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 column "RI" was found in the ["MS_METABOLITE_DATA"]["Metabolites"] table, but this column implies that another column, "retention_index_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.