Query Results

From WormBaseWiki
Jump to navigationJump to search

WormMine Results Page

Results Page table

All WormMine query results are presented as tables. The number of resulting items is dependent on the query performed (number of rows) and the Data Model classes selected (number of columns; templates have a pre-defined set of columns). Most items in the table showed in blue are active links to WormBase pages, where more information about the item can be found. Hovering over the item will display a popup with some summary information about it.


Results 1.png Results 2.png


Column features

Results tables have a small toolbox available in each column that allows for some operations to be performed


Toolbox.png


  • Up down.png up and down arrows allow for sorting, ascending and descending
  • X.png x allows the column to be removed
  • Dotdotdot.png three dots toggle on and off the visibility of the column (it becomes an arrow when the column is invisible Arrow.png)
  • Funnel.png funnel acts as a filter selector that can be added or removed from the table. Multiple filters can be functional at the same time in different columns
  • Bar graph.png bar graph presents statistics about the column; filters may also be added using this feature


Table manipulation

Results tables also have a set of buttons on top of the table that provide some options for exporting, saving and displaying the contents of the table. Some of these buttons open a dialog box on top of the table with actions that can be performed; these dialog boxes need to be dismissed to return to the results table.


Table 1.png


  • Manage Columns - allows the user to select column order, remove columns, add new columns that are not part of the query/template, sort the order of all columns in bulk, and apply sort order priorities


Table 2.png


  • Manage Filters - allows for multiple filter management at once, including constraints and filter logic. The dialog box allows users to include filters from fields and items that are not part of the query/template


Table 3.png


  • Manage Relationships - this works on excluding classes from the final result set, or making connections that are displayed in the results table to be optional on the screen, making related classes to appear nested Table 4.png
  • After using any of the Manage features, an Undo button will appear, allowing users to reverse their last actions
  • Save as List - this button creates a list that can be saved by the user so it can be applied later on a different query or to be kept between releases, allowing for differences to be examined. One or multiple columns and rows can be selected, and a name has to be provided (to take full advantage, create an account and login first) Table 5.png
  • Generate Code - query can be saved in multiple types of programming languages that take advantage of WormMine's API. Python, Perl, Java, Ruby, Javascript and XML are available Table 6.png
  • Export - saves a text file with the items in the table. Columns and rows can be selected, headers can be added, at the same time as compression (useful for really long tables). Possibility of sending the results to a Galaxy or Genomespace service is available. Depending on the kind of results displayed, there are options to save the file as FASTA or other common formats Table 7.png