• New tables (tbl_amino_acid, tbl_fatty_acid etc) have many blank samples with no associated data.
• The columns of interest field in the summary table do not accurately break down the data. With the long format data template, all the variables of interest would be as follows (new variables in bold).
  -Data type
  -Age (yrs)
  -Fork length (mm)
  -Standard length (mm)
  -Total length (mm)
  -Weight (g)
  -Sample weight (g)
  -Energy density (Joules/gram dry weight)
  -Energy density (Joules/gram wet weight)
  -Percent water (%)
  -Percent Ash (% dry weight)
  -Percent Lipid (% dry weight)
  -Percent Protein (% dry weight)
  -Percent Carbon (% dry weight)
  -Percent Nitrogen (% dry weight)
  -Percent Ash (% wet weight)
  -Percent Lipid (% wet weight)
  -Percent Protein (% wet weight)
  -Percent Carbon (% wet weight)
  -Percent Nitrogen (% wet weight)
  -δ¹³C (bulk)
  -δ¹⁵N (bulk)
  -δ³⁴S (bulk)
  -δ²H (bulk)
  -δ¹⁸O (bulk)
  -δ¹³C (lipid free)
  -δ¹⁵N (lipid free)
  -δ³⁴S (lipid free)
  -δ²H (lipid free)
  -δ¹⁸O (lipid free)
  -C/N
  -% Lipid Type (% wet sample weight)
  -% Lipid Type (% dry sample weight)
  -% Lipid Type (% total lipids)
  -Fatty Acid Type (ug/mg wet weight)
  -Fatty Acid Type (ug/mg dry weight)
  -% Fatty Acid Type (% total fatty acids)
  -Amino Acid Type (ug/mg wet weight)
  -Amino Acid Type (ug/mg dry weight)
  -% Amino Acid Type (% total protein)
  -Thiamine (nmol/gram)
  -Total Mercury (ppm)
  -Methyl Mercury (ppm)
  -Free Thiamine (nmol/gram wet weight)
  -Thiamine monophosphate (nmol/gram wet weight)
  -Thiamine pyrophosphate (nmol/gram wet weight)
  -Total Thiamine (nmol/gram wet weight)
  -Thiamine activity (nmol/g/min wet weight)
  -Free Thiamine (nmol/gram dry weight)
  -Thiamine monophosphate (nmol/gram dry weight)
  -Thiamine pyrophosphate (nmol/gram dry weight)
  -Total Thiamine (nmol/gram dry weight)
  -Thiamine activity (nmol/g/min dry weight)
  -Total PCB (ng/g wet weight)
  -Total PCB (ng/g dry weight)

This isn't a full list, because there are a further 4 different lipid composition options, 18 different fatty acid options, and 18 different Amino acid options. To avoid the longest list in the world, perhaps Lipid type, Amino acid type, and Fatty acid type be an option for grouping variables? It would be even nicer if they were automatically applied as grouping variables when Fatty acid Type, Amino acid Type, or Lipid Type. This way of doing things mean you can't make a histogram of just Alanine, or include it in a scatterplot, but I don't think that is worth the cost of the long variable of interest list.

Dry and wet weight basis could also be applied as a grouping variable to shorten this list a bit, but that would be similar to just having "Joules/gram" as an option and then expecting the user to filter for dry or wet sample type. The mixed wet and dry samples would also be displayed on the same histogram since it is not effected by the grouping options.

• Current thiamine table has standard deviation option, which is different than all the other data. There has been a lot of standard deviation information present for energy density, length, etc. in the publications I've entered that I have not included because that's calculated separately in the tool. There isn't Thiamine data in here currently, but I'd imagine there would be occasions where it would show sd twice, once as a mean of the values entered and then again as a standard deviation of the standard deviation.....

• I think a really basic barchart or boxplot would be super useful for visualise the data. The summary histogram is very useful, but isn't affected by grouping variables. The scatterplot can show differences within groups, but I often just want to see one variable. There is not a great way to visualise differences in energy density between species, sex etc. I can use the scatterplot, but I have to select another variable I don't really care about which limits the amount of data I can see. I guess a really quick way to cheat this would be to add source_Id as an axis option, since it's numeric and always available, but that's not really ideal. I know the tables are a bit of a pain though.

• Currently the tool functions very well for exploring data if you have a very specific question (i.e you want to know joules/gram wet weight for Lake Trout in Lake Ontario) or if you want to know about a specific data type (i.e joules/gram/wet weight) and then select different grouping variables. However, due to the way the tables are broken up, if you want to learn about a specific location or species, its difficult to find what data is available. If a waterbody or species doesn't have much associated data, you're going to get a lot of empty summary tables before you find out that only % water was recorded. It would be amazing if the summary column of interest tabs were reduced when filters are applied, so you can quickly see what data was collected for the specific waterbody and location you are interested in. From what I know this would be difficult to code, and might go beyond how you intent the tool to be used. However, this problem would get worse if the number of variables expands, like I've suggested in bullet 2.