Validation Log 2025-12-15 01:49:16.831721 mwtab Python Library Version: 2.0.0 Source: https://www.metabolomicsworkbench.org/rest/study/analysis_id/AN004959/mwtab/txt Study ID: ST003024 Analysis ID: AN004959 File format: txt Status: Contains Validation Issues Number of Issues: 22 Number of Warnings: 8 Number of Value Errors: 22 Number of Consistency Errors: 0 Number of Format Errors: 0 Issue Log: Error: An empty value or a null value was detected for the subsection, "TOTAL_SUBJECTS", in the "STUDY" section. Either a legitimate value should be provided for this subsection, or it should be removed altogether. Error: An empty value or a null value was detected for the subsection, "NUM_MALES", in the "STUDY" section. Either a legitimate value should be provided for this subsection, or it should be removed altogether. Error: An empty value or a null value was detected for the subsection, "NUM_FEMALES", in the "STUDY" section. Either a legitimate value should be provided for this subsection, or it should be removed altogether. Error: The value, "NA", for the subsection, "AGE_OR_AGE_RANGE", in the "SUBJECT" section 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, "NA", for the subsection, "WEIGHT_OR_WEIGHT_RANGE", in the "SUBJECT" section 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, "NA", for the subsection, "HEIGHT_OR_HEIGHT_RANGE", in the "SUBJECT" section 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, "Not applicable", for the subsection, "GENDER", in the "SUBJECT" section should be one of "Male", "Female", "Male, Female", "Hermaphrodite", or "N/A". Ignore this when more complicated descriptions are required. Error: An empty value or a null value was detected for the subsection, "COLLISION_ENERGY", in the "MS" section. Either a legitimate value should be provided for this subsection, or it should be removed altogether. Error: The value, "NA", for the subsection, "COLLISION_GAS", in the "MS" section should be one of "Nitrogen" or "Argon". Ignore this when more complicated descriptions are required. Error: The value, "50", for the subsection, "DRY_GAS_FLOW", in the "MS" section 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, "120", for the subsection, "DRY_GAS_TEMP", in the "MS" section 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, "300", for the subsection, "SOURCE_TEMPERATURE", in the "MS" section 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, "0.3 ml/min", for the subsection, "FLOW_RATE", in the "CHROMATOGRAPHY" section should be a number or range (ex. "5-6") followed by a space with a unit (ex. "5 V") from the following list: ['mL/min', 'uL/min', 'μL/min']. Ignore this when more complicated descriptions are required. Error: The value, "60 bar at starting conditions. 180 bar at %A", for the subsection, "COLUMN_PRESSURE", in the "CHROMATOGRAPHY" section should be a number or range (ex. "5-6") followed by a space with a unit (ex. "5 V") from the following list: ['psi', 'bar']. Ignore this when more complicated descriptions are required. Warning: There are duplicate samples in the MS_METABOLITE_DATA section. Warning: The "InchiKEY" column at position 6 in the 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 "KEGGid" column at position 4 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 "KEGGid" column at position 4 in the METABOLITES table, matches a standard column name, "kegg_id", and some of the values in the column do not match the expected type or format for that column. The non-matching values are: 0 0 1 0 3 0 4 0 5 0 6 0 7 0 8 0 9 0 10 0 11 0 12 0 14 0 16 0 17 0 18 0 20 0 21 0 22 0 23 0 24 0 25 0 28 0 31 0 32 0 33 0 34 0 36 0 37 0 38 0 39 0 40 0 41 0 42 0 44 0 45 0 46 0 48 0 49 0 52 0 53 0 54 0 55 0 56 0 57 0 58 0 59 0 63 0 65 0 67 0 68 0 69 0 75 0 76 0 77 0 78 0 80 0 81 0 84 0 87 0 88 0 89 0 90 0 91 0 93 0 94 0 96 0 99 0 101 0 102 0 105 0 107 0 108 0 111 0 114 0 115 0 116 0 117 0 118 0 120 0 124 0 125 0 127 0 130 0 132 0 135 0 141 0 142 0 143 0 144 0 147 0 148 0 152 0 153 0 156 0 Warning: The "HMDBID" column at position 7 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 "HMDBID" column at position 7 in the METABOLITES table, matches a standard column name, "hmdb_id", and some of the values in the column do not match the expected type or format for that column. The non-matching values are: 0 0 1 0 3 0 5 0 6 0 7 0 8 0 9 0 10 0 12 0 13 0 14 0 16 0 17 0 20 0 21 0 23 0 24 0 28 0 31 0 32 0 37 0 38 0 39 0 40 0 41 0 42 0 45 0 48 0 51 0 53 0 54 0 55 0 56 0 57 0 58 0 60 0 61 0 62 0 66 0 68 0 69 0 70 0 71 0 75 0 77 0 78 0 80 0 81 0 82 0 83 0 84 0 87 0 88 0 89 0 90 0 91 0 96 0 98 0 99 0 101 0 102 0 103 0 105 0 108 0 114 0 115 0 116 0 117 0 118 0 120 0 122 0 124 0 125 0 127 0 130 0 132 0 141 0 142 0 144 0 145 0 148 0 151 0 152 0 153 0 Warning: The "Lmid" column at position 5 in the METABOLITES table, matches a standard column name, "lm_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 2 in the 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.