Help for Database Search

The database interface will prepare a search query that selects all data sets indicated by the search criteria. Once the search criteria are selected, the user can select specific attributes and analytes to display and one of three output formats for reporting the results.

Numbers/values output by the database are in U.S. format with a comma as the thousand separator. A period is used to separate the integer portion from the fractional portion of numbers.

Features and Options in the ILSI-CCDB

Figure 1 - Click to enlarge image.

Screen 1 (Figure 1) is the Welcome page for the ILSI-CCDB. This screen provides users with links to relevant information about the database - About the ILSI-CCDB, How to Cite this Database, Terms of Use, Frequently Asked Questions and Help, which demonstrates how to use the database. The Welcome page also includes a link to Register for Updates and Other Web Sites of Interest. Users access the Database Search functions via the Database Search button or the Database Search link on the Welcome page.

Figure 2 - Click to enlarge image.

On the Database Search tab, Screen 2 (Figure 2) allows users to select Primary Search Criteria including Crop Type, Tissue Type, Crop Year of sample harvest, and Location of field site. The query defaults to All Years, All Countries and All Regions. To select contiguous items in the fields of Crop Years, Country or Region Locations, hold the Shift key and highlight the selected fields. To select non-contiguous fields, hold the Control key and click on the desired items within the fields. Users can activate the optional Analyte Filters to filter the data by a range of values and/or analysis method. Click on View Summary of Search Results.

Figure 3a - Click to enlarge image.Figure 3b - Click to enlarge image.

Screen 3 (Figures 3a and 3b) has three functions. Using the Summary of Search Results tool, users can preview their data and determine if a search refinement is necessary prior to generating an output report. The Summary of Search Results tool allows the user to quickly determine the sample number (N), minimum, maximum, and mean values in the primary unit of measure for any analyte in the database. The Create Report from Search Results tool (Figure 3b) allows the user to create and organize a specific list of analytes with preferred units of measure for an output report. Meta-data can be added to the output report using the Select Fields from Report Output tool (Figure 3b). The information contained in a desired output report and how that information is organized is defined using the Create Report from Search Results tool and the Select Fields for Report Output tool. The options in these tools allow the user to investigate the effects of different variables (e.g., analysis method, crop yield, or location of field site).

Figure 4 - Click to enlarge image.

Screen 4 is accessed with the Report Options button. The features on Screen 4 (Figure 4) allow the user to select the format for output reports (Summary Report, Detailed Report, or Tabular Report). Each of these formats can be generated in either portrait or landscape orientations, and can be displayed as a HTML, a PDF, or comma delimited file (CSV). CSV files can be transferred to Excel, SAS, MATLAB, or the R programming language for advanced statistical analyses and graphics. Screen 4 (Figure 4) also includes text fields for adding header-type information to further customize output reports. Output reports are generated using the Run Report button.

Using the ILSI-CCDB: A Step-by-Step Example

Figure 1 - Click to enlarge image.

Direct your web browser to www.cropcomposition.org On Screen 1 (Figure 1), press the "Database Search" button or the "Database Search" link to initiate a database query.

Figure 2 - Click to enlarge image.

On Screen 2 (Figure 2) use the pull-down menus to select Corn - Field as the Crop Type and Grain as the Tissue Type. If no selections are made in the pull-down menus for Crop Year(s), Country(s), and Region(s), the primary search criteria will default to All Years, All Countries, and All Regions. For this example, accept these defaults by ignoring these three pull-down menus; ignore Analyte Filters (optional) as well. Press the View Summary of Search Results button near the bottom of Screen 2. It should require ~5 seconds to process this initial query because the server is accessing all data and meta-data for more than 5,769 corn grain samples.

Figure 3a - Click to enlarge image.

On Screen 3 (Figure 3a) in the Summary of Search Results tool, activate the check-box buttons adjacent to Bio Actives, Minerals, and Other Metabolites for a quick-view of the composition data for these analytes in corn grain. Note that phytic acid was measured in 5769 corn grain samples and that phytic acid was below the LOQ in seven of these 5769 samples. Thus, all data and meta-data for this analyte derive from 5762 samples (5769 - 7 = 5762) and the minimum, maximum and mean value for phytic acid in this tissue are 0.100 % FW, 1.421 % FW, and 0.731 % FW, respectively. The Summary of Search Results tool also reports that sodium and furfural were measured in 5757 and 5251 grain samples, respectively. Sodium was below the LOQ in 4647 of the samples while furfural was below the LOQ in 5237 of the samples.

Figure 3b - Click to enlarge image.

Next, use the Create Report from Search Results tool to select Bio Actives in the pull-down menu under Analyte Type (Figure 3b). Select phytic acid in the pull-down menu under Analyte. Select % FW in the pull-down menu under Units. Press the Add Analyte(s) button to add phytic acid (% FW) to the Analyte List for the output report. Repeat these steps, except select % DW in the pull-down menu under Units. Press the Add Analyte(s) button to add phytic acid (% DW) to the Analyte List for the output report. Use this same approach to create an Analyte List that includes phytic acid (% FW and % DW), Vitamin B3/Niacin (mg/100g FW), iron (ppm FW), sodium (ppm FW), and furfural (ppm FW). For certain Analyte Types (e.g., Fatty Acids) the pull-down menu under Analyte includes the selection of All Fatty Acids; this convenient option allows users to populate the Analyte List with all fatty acids via a single use of the Add Analyte(s) button. After creating an Analyte List for the output report, use the check-box buttons in the Select Fields for Report Output tool (Figure 3b) to include meta-data for Number of Samples, Samples below LOQ, Samples above LOQ, and Analysis Method in the output report. For this example do not change the default settings for Minimum Value, Maximum Value, Mean Value, Analyte Type or Analyte. Press the Report Options button.

Figure 4 - Click to enlarge image.

On Screen 4 (Figure 4), in the Select Report Format tool, select the radio button for Summary Report. Use the pull-down menus under Report Orientation and Output Format to select the landscape orientation and HTML format, respectively. The HTML format will display the output report on the user's screen. Enter "Short Title 123" in the text field under Title and enter "Short Description 456" in the text field under Description. Press the Run Report button

Figure 5 - Click to enlarge image.

One example of a Summary Report is shown in Figure 5. To print this report use the pull-down menu labeled Output Format and the Go button (Figure 5) to save a PDF to your computer desktop. Note that this output report shows that the phytic acid values were derived using three methods that are identified by method codes and literature citations. For example, method BA0003-AOAC Official Method 986.11 was used for measuring phytic acid in 1724 of the 5769 samples. If statistical analyses or graphical representations of the data are desired, the 5769 phytic acid values (including samples that were below the LOQ) can be retrieved using the Detailed Report option in the Select Report Format tool (Figure 4).

Units of Measure and Limit of Quantitation (LOQ)

The ILSI-CCDB allows users to view and output composition data in multiple units of measure, including % DW, % FW, mg/100g FW, mg/g DW and mg/g FW. In addition, amino acids and fatty acids can be expressed as a relative percentage (i.e., % Total AA or % Total FA) and some nutrients (e.g., ferulic acid, p-coumaric acid) can be expressed as parts per million FW (ppm FW). Minerals are expressed as mg/kg DW and ppm FW, and calories are expressed as Kcal/100g DW and Kcal/100g FW.

All analytes in the database have been assigned a primary unit of measure, which is shown in the right column of the Summary of Search Results tool (Figure 3a). To maximize performance and simplify usage of this data preview tool, the Summary of Search Results tool only shows the composition data in the primary unit of measure. If secondary units of measure (or multiple units of measure for a single analyte) are preferred, the ILSI-CCDB requires that data with secondary units of measure be generated in an output report.

LOQ is defined as the lowest point at which a method can quantify the amount of an analyte in a sample. As shown in Figure 3a, the Summary of Search Results tool reports the number of samples within a search that are below the LOQ. For example, raffinose was measured in 5362 corn grain samples and 777 of the observed values for raffinose in this tissue were below the LOQ (denoted as 777<LOQ). The data that contribute to the minimum, maximum and mean values for raffinose do not include the 777 data points that are below the LOQ. LOQ meta-data can be accessed by activating the Samples below LOQ and Samples above LOQ options in the Select Fields for Report Output tool on Screen 3 (Figure 3b).