Validation Log 2025-12-14 21:00:13.576648 mwtab Python Library Version: 2.0.0 Source: https://www.metabolomicsworkbench.org/rest/study/analysis_id/AN000035/mwtab/json Study ID: ST000017 Analysis ID: AN000035 File format: json Status: Contains Validation Issues Number of Issues: 15 Number of Warnings: 7 Number of Value Errors: 12 Number of Consistency Errors: 2 Number of Format Errors: 0 Issue Log: Error: An empty value or a null value was detected in ["PROJECT"]["ADDRESS"]. A legitimate value should be provided for this required key. Error: An empty value or a null value was detected in ["STUDY"]["ADDRESS"]. A legitimate value should be provided for this required key. Error: An empty value or a null value was detected in ["COLLECTION"]["COLLECTION_SUMMARY"]. A legitimate value should be provided for this required key. Error: An empty value or a null value was detected in ["SAMPLEPREP"]["SAMPLEPREP_SUMMARY"]. A legitimate value should be provided for this required key. Error: The value, "3500V", in ["MS"]["CAPILLARY_VOLTAGE"] should be a number followed by a space with a unit (ex. "5 V") from the following list: ['V', 'kV']. Ignore this when more complicated descriptions are required. Error: The value, "40C", 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 following metabolites in the, ["MS_METABOLITE_DATA"]["Data"] table were not found in the ["MS_METABOLITE_DATA"]["Metabolites"] table: "11BETA_21-DIHYDROXY-5BETA-PREGNANE-3_20-DIONE" "11-BETA-HYDROXYANDROST-4-ENE-3_17-DIONE" "2_3-DIPHOSPHO-D-GLYCERIC ACID" "2-CARBOXY-2_3-DIHYDRO-5_6-DIHYDROXYINDOLE" "3_4-DIHYDROXYBENZOATE" "3_4-DIHYDROXYPHENYL GLYCOL" "3ALPHA_7ALPHA_12ALPHA_26-TETRAHYDROXY-5BETA-CHOLESTANE" "3ALPHA_7ALPHA_12ALPHA-TRIHYDROXY-5BETA-CHOLESTANOATE" "3ALPHA_7ALPHA-DIHYDROXY-5BETA-CHOLESTANATE" "4-(2-AMINO-3-HYDROXYPHENYL)-2_4-DIOXOBUTANOATE" "4-ANDROSTEN-3BETA_17BETA-DIOL DISULFATE" "5_6-DIHYDROURACIL" "CIS-7_10_13_16-DOCOSATETRAENOIC ACID" "FRUCTOSE 1_6-BIPHOSPHATE" "GULONO-1_4-LACTONE" "PYRIDINE-2_3-DICARBOXYLATE" "STEAROYLGLYCEROPHOSPHOETHANOLAMINE_1" "XANTHOSINE 5^-MONOPHOSPHATE" Error: The following metabolites in the ["MS_METABOLITE_DATA"]["Metabolites"] table were not found in the ["MS_METABOLITE_DATA"]["Data"] table: "11BETA,21-DIHYDROXY-5BETA-PREGNANE-3,20-DIONE" "2-CARBOXY-2,3-DIHYDRO-5,6-DIHYDROXYINDOLE" "3ALPHA,7ALPHA,12ALPHA,26-TETRAHYDROXY-5BETA-CHOLESTANE" "3ALPHA,7ALPHA,12ALPHA-TRIHYDROXY-5BETA-CHOLESTANOATE" "3ALPHA,7ALPHA-DIHYDROXY-5BETA-CHOLESTANATE" "4-(2-AMINO-3-HYDROXYPHENYL)-2,4-DIOXOBUTANOATE" "4-ANDROSTEN-3BETA,17BETA-DIOL DISULFATE" "STEAROYLGLYCEROPHOSPHOETHANOLAMINE_2" "XANTHOSINE 5'-MONOPHOSPHATE" Warning: The "ri" column at position 3 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 4 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. Warning: The "moverz_quant" column at position 2 in the ["MS_METABOLITE_DATA"]["Metabolites"] table has all null values. Warning: The "ri" column at position 3 in the ["MS_METABOLITE_DATA"]["Metabolites"] table has all null values. Warning: The "ri_type" column at position 4 in the ["MS_METABOLITE_DATA"]["Metabolites"] table has all null values. Warning: The "inchi_key" column at position 6 in the ["MS_METABOLITE_DATA"]["Metabolites"] table has all null values.