Validation Log 2025-12-15 00:05:34.650574 mwtab Python Library Version: 2.0.0 Source: https://www.metabolomicsworkbench.org/rest/study/analysis_id/AN003289/mwtab/txt Study ID: ST002019 Analysis ID: AN003289 File format: txt 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: An empty value or a null value was detected for the subsection, "INSTRUMENT_NAME", in the "CHROMATOGRAPHY" section. A legitimate value should be provided for this required subsection. Error: An empty value or a null value was detected for the subsection, "COLUMN_NAME", in the "CHROMATOGRAPHY" section. A legitimate value should be provided for this required subsection. 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. 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 9 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 10 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 10 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: 72 26853-31-6;26853-31-6 103 542-32-5;1118-90-7 141 10569-72-9;214139-20-5 169 1460-34-0;51829-07-3 179 10066-90-7;32113-41-0 184 463-003;463-00-3 245 305-72-6;328-50-7;22202-68-2 246 59-02-9;10191-41-0 272 56-41-7;107-95-9 280 55482-27-4;55482-27-4 300 474-24-9;474-25-9 315 52-90-4;56-89-3 350 10-2005-9;10417-94-4 408 475-31-0;863-57-0 508 5657-19-2;5657-19-2 529 997-55-7;997-55-7 578 11-58-0;111-58-0 601 1002-84-2;10002-84-2 678 85187-10-6;85187-10-6 689 87-69-4;6106-24-7 723 69-93-2;120K5305 733 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.