Validation Log 2025-12-14 23:17:56.883974 mwtab Python Library Version: 2.0.0 Source: https://www.metabolomicsworkbench.org/rest/study/analysis_id/AN002387/mwtab/json Study ID: ST001428 Analysis ID: AN002387 File format: json Status: Contains Validation Issues Number of Issues: 18 Number of Warnings: 7 Number of Value Errors: 14 Number of Consistency Errors: 0 Number of Format Errors: 2 Issue Log: Error: The value, "ages 2 to 18 years", 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, "250C", in ["MS"]["CAPILLARY_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. Error: The value, "N2", in ["MS"]["COLLISION_GAS"] should be one of "Nitrogen" or "Argon". Ignore this when more complicated descriptions are required. Error: The value, "45", in ["MS"]["DRY_GAS_FLOW"] should be a number followed by a space with a unit (ex. "5 V") from the following list: ['L/hr', 'L/min']. Ignore this when more complicated descriptions are required. Error: The value, "150C", in ["MS"]["DRY_GAS_TEMP"] should be a number followed by a space with a unit (ex. "5 V") from the following list: ['°C', 'C']. Ignore this when more complicated descriptions are required. Error: The value, "3500", in ["MS"]["SPRAY_VOLTAGE"] should be a number followed by a space with a unit (ex. "5 V") from the following list: ['kV']. Ignore this when more complicated descriptions are required. Error: The value, "118ms", in ["MS"]["ACTIVATION_TIME"] should be a number followed by a space with a unit (ex. "5 V") from the following list: ['ms']. Ignore this when more complicated descriptions are required. Error: An empty value or a null value was detected in ["MS"]["MS_COMMENTS"]. Either a legitimate value should be provided for this key, or it should be removed altogether. Error: The value, "60C", 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. Error: The required property, "FLOW_GRADIENT", in ["CHROMATOGRAPHY"] is missing. Error: The required property, "FLOW_RATE", in ["CHROMATOGRAPHY"] is missing. Warning: The "quantitated m/z" column at position 4 in the ["MS_METABOLITE_DATA"]["Metabolites"] table, matches a standard column name, "moverz_quant". 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 "InChiKey" column at position 3 in the ["MS_METABOLITE_DATA"]["Metabolites"] table, matches a standard column name, "inchi_key". 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 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 "retention time" column at position 5 in the ["MS_METABOLITE_DATA"]["Metabolites"] table, matches a standard column name, "retention_time". 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 "MSIcategory" column at position 6 in the ["MS_METABOLITE_DATA"]["Metabolites"] table, matches a standard column name, "msi_category". 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 "chemical_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 "chemical_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.