BIMS: Searching Data

You can search the data in a breeding program using BIMS.  Click on the "Search" section of the left side accordion menu and then click on "Accession" (Fig. 7A).  This will open the "Search Accession" tab (Fig. 7B). 

Figure 7.  Opening the Search tab


The first step to start a search is to select a property or trait under the "Choose property" section (Fig. 8A).  In this example, we are choosing "Parent."  After the property is selected, the "Set filter" section will populate with options for that data type (Fig. 8B).  After selecting the options you want, click "Add."  The selected filter will then appear in the "Search results" section.  If you want to reset the search, click the "Reset" button (Fig. 8C).

Figure 8.  Selecting a Property and setting a Filter in the Search Tab


You can further filter the search results by adding another property or trait under the "Choose property" section.  In this example, we are further refining the search by adding the "boll color" trait (Fig. 9A).  The "Set filter" section will show the data that are relevant for the previous filter you chose. For example, the statistics shown for "boll color" trait here is only for those accessions from the parents you chose in the previous search. You can choose which values for boll color to filter by, or for data that is numerical you can set the minimun and maximum value for that trait, and then click "Add" (Fig. 9B).  The new filter is added to the "Search results" section and the selected filters can be removed with the "Remove" button under "Search results" (Fig. 9C).  To view the search results, and to generate a file to export, click on "View" under "Search results" (Fig. 9C).

Figure 9.  Adding more filters to the search and viewing results


When the "View" button is clicked (Fig. 9C), a new tab opens called "Search Results" (Fig. 10).  On this tab there is a "Column options" section (Fig. 10A) and a preview of the data table (Fig. 10B).

Figure 10.  Search Results tab


Users can add more information to the table before exporting the data.  To do this, click on the "Column options" section to expand it (Fig. 11).  There are two sections, "Properties" (Fig. 11A) and "Traits" (Fig. 11B).  You can select additional items to display by clicking on the check boxes in these two sections.  Once all the selections have been made, click "Update".

Figure 11. Adding more columns to search results table with Column Options section


After selecting additional data to display on the table, you can preview the table on the "Search Results" tab (Fig. 12A) and see the original filters that were used to generate the initial table by clicking on "Descriptions" in the "Results" section (Fig. 12B).  To download the data table, click on the "Download" button in the "Save Results / Download Data" section (Fig. 12C).  If you do not see your browser start to downoad the file after clicking "Download," please make sure the pop-up was not blocked.

Figure 12.  Downloading data from the Search Results tab


BIMS generates a CSV file of the search results table (Fig. 13).   This table is easily opened by Microsoft Excel and other programs.

Figure 13.  Example CSV file exported from BIMS


If you have a CottonGen account, you can also save the search results to a list.  You will see a "Save" button with boxes for a list name and description (Fig. 14A).  This list can be saved to either a private or public program that you are in.

Figure 14.  Saving lists from searches to private breeding programs


Saved search results are accessed by clicking on "Search Results" in the "Search" section of the accordion menu (Fig. 15A).  Any search results you have saved will appear unded "Saved Results" (Fig. 15B) and you can also see details about the saved lists and delete, view, or edit them (Fig. 15C).

Figure 15.  Accessing saved search results