Validation Log 2025-12-15 00:05:26.381564 mwtab Python Library Version: 2.0.0 Source: https://www.metabolomicsworkbench.org/rest/study/analysis_id/AN003287/mwtab/txt Study ID: ST002017 Analysis ID: AN003287 File format: txt Status: Contains Validation Issues Number of Issues: 21 Number of Warnings: 13 Number of Value Errors: 12 Number of Consistency Errors: 0 Number of Format Errors: 6 Issue Log: Error: The value, "18-50", for the subsection, "AGE_OR_AGE_RANGE", in the "SUBJECT" section 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", for the subsection, "GENDER", in the "SUBJECT" section 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 the "CHROMATOGRAPHY" section is missing. Error: The required property, "FLOW_RATE", in the "CHROMATOGRAPHY" section is missing. Error: The required property, "COLUMN_TEMPERATURE", in the "CHROMATOGRAPHY" section is missing. Error: The required property, "SOLVENT_A", in the "CHROMATOGRAPHY" section is missing. Error: The required property, "SOLVENT_B", in the "CHROMATOGRAPHY" section is missing. Error: Unknown or invalid section, "FACTORS". Warning: The "SUPER PATHWAY" column at position 2 in the 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 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 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 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 "HMDB" column at position 12 in the 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 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 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: 31 71030-37-0;73837-14-6 76 26853-31-6;26853-31-6 148 10569-72-9;214139-20-5 165 4298-05-9;4298-08-2 176 1460-34-0;51829-07-3 190 10066-90-7;32113-41-0 195 463-003;463-00-3 263 305-72-6;328-50-7;22202-68-2 264 59-02-9;10191-41-0 291 56-41-7;107-95-9 300 55482-27-4;55482-27-4 318 474-24-9;474-25-9 336 52-90-4;56-89-3 378 10-2005-9;10417-94-4 393 146-14-5;84366-81-4 440 475-31-0;863-57-0 550 5657-19-2;5657-19-2 571 997-55-7;997-55-7 625 11-58-0;111-58-0 661 1002-84-2;10002-84-2 722 85187-10-6;85187-10-6 765 87-69-4;6106-24-7 796 69-93-2;120K5305 810 59-007 Warning: The "COMP ID" column at position 4 in the 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 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 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 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 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.