Validation Log 2025-12-14 23:15:08.068032 mwtab Python Library Version: 2.0.0 Source: https://www.metabolomicsworkbench.org/rest/study/analysis_id/AN002341/mwtab/json Study ID: ST001400 Analysis ID: AN002341 File format: json Status: Contains Validation Issues Number of Issues: 22 Number of Warnings: 14 Number of Value Errors: 14 Number of Consistency Errors: 0 Number of Format Errors: 5 Issue Log: Error: The value, "11-30 Kilograms", 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, "85 - 137 cm", 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, "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 4 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 11 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 13 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 "HMDB" column at position 14 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 "CHEMSPIDER" column at position 12 in the ["MS_METABOLITE_DATA"]["Metabolites"] table, matches a standard column name, "chemspider_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 ["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 10 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: 16 71030-37-0;73837-14-6 26 542-32-5;1118-90-7 66 1460-34-0;51829-07-3 74 10066-90-7;32113-41-0 148 10-2005-9;10417-94-4 176 475-31-0;863-57-0 222 5657-19-2;5657-19-2 226 997-55-7;997-55-7 244 58725-46-5;474943-14-1 261 11-58-0;111-58-0 315 69-93-2;120K5305 Warning: The "COMP_ID" column at position 5 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 7 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 "Retention Index" column at position 8 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 "Retention Index" 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.