Validation Log
2025-12-14 23:59:42.366083
mwtab Python Library Version: 2.0.0
Source:        https://www.metabolomicsworkbench.org/rest/study/analysis_id/AN003173/mwtab/json
Study ID:      ST001949
Analysis ID:   AN003173
File format:   json
Status: Contains Validation Issues
Number of Issues: 22

Number of Warnings: 12

Number of Value Errors: 14

Number of Consistency Errors: 2

Number of Format Errors: 5

Issue Log:
Error: The value, "21 - 84", 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.
Error: The following metabolites in the, ["MS_METABOLITE_DATA"]["Data"] table were not found in the ["MS_METABOLITE_DATA"]["Metabolites"] table:
	"1_3_7-Trimethyluric acid"
	"1_3 Cyclohexanedione"
	"1_5-Anhydrosorbitol"
	"2_3-Dihydroxybiphenyl"
	"2_3-dihydroxybutanoic acid"
	"2_4-Dibromophenol"
	"2_5-dihydroxypyrazine"
	"3_6-anhydro-D-galactose"
	"5^-Methylthioadenosine"
	"6_7-Dihydroxycoumarin"
	"Dihydro-4_4-dimethyl-2_3-furandione"
	"N_N-Dimethylformamide"
Error: The following metabolites in the ["MS_METABOLITE_DATA"]["Metabolites"] table were not found in the ["MS_METABOLITE_DATA"]["Data"] table:
	"1,3,7-Trimethyluric acid"
	"1,3 Cyclohexanedione"
	"1,5-Anhydrosorbitol"
	"2,3-Dihydroxybiphenyl"
	"2,3-dihydroxybutanoic acid"
	"2,4-Dibromophenol"
	"2,5-dihydroxypyrazine"
	"3,6-anhydro-D-galactose"
	"5'-Methylthioadenosine"
	"6,7-Dihydroxycoumarin"
	"Dihydro-4,4-dimethyl-2,3-furandione"
	"N,N-Dimethylformamide"
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 "ri_type" column at position 8 in the ["MS_METABOLITE_DATA"]["Metabolites"] table, matches a standard column name, "retention_index_type". 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 standard column, "other_id", was found in the METABOLITES table as "other_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.
Error: Column(s) with no name were found in the ["MS_METABOLITE_DATA"]["Metabolites"] table.
Warning: The "pubchem_id" column at position 2 in the ["MS_METABOLITE_DATA"]["Metabolites"] table has all null values.
Warning: The "inchi_key" column at position 3 in the ["MS_METABOLITE_DATA"]["Metabolites"] table has all null values.
Warning: The "kegg_id" column at position 4 in the ["MS_METABOLITE_DATA"]["Metabolites"] table has all null values.
Warning: The "other_id" column at position 5 in the ["MS_METABOLITE_DATA"]["Metabolites"] table has all null values.
Warning: The "other_id_type" column at position 6 in the ["MS_METABOLITE_DATA"]["Metabolites"] table has all null values.
Warning: The "ri" column at position 7 in the ["MS_METABOLITE_DATA"]["Metabolites"] table has all null values.
Warning: The "ri_type" column at position 8 in the ["MS_METABOLITE_DATA"]["Metabolites"] table has all null values.
Warning: The "moverz_quant" column at position 9 in the ["MS_METABOLITE_DATA"]["Metabolites"] table has all null values.
Warning: The "" column at position 10 in the ["MS_METABOLITE_DATA"]["Metabolites"] table has all null values.