Difference between revisions of "Query Results"

From WormBaseWiki
Jump to navigationJump to search
 
(17 intermediate revisions by the same user not shown)
Line 2: Line 2:
  
 
===Results Page table===
 
===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 a some summary information about it.
+
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.
  
 
 
 
[[File:results_1.png]]  [[File:results_2.png]]
 
[[File:results_1.png]]  [[File:results_2.png]]
 
  
  
 
===Column features===
 
===Column features===
 
 
Results table have a small toolbox available in each column that allows for some operations to be performed
+
Results tables have a small toolbox available in each column that allows for some operations to be performed
 +
 
 +
 
 +
[[File:toolbox.png]]
  
[[File:images/toolbox.png]]
 
 
  
 
* [[File:up_down.png]]  up and down arrows allow for sorting, ascending and descending
 
* [[File:up_down.png]]  up and down arrows allow for sorting, ascending and descending
 
*[[File:x.png]] x allows the column to be removed
 
*[[File:x.png]] x allows the column to be removed
*[[File:dotdotdot.png]] three dots toggle on and off the visibility of the column (it becomes an arrow when the columns is invisible [[File:arrow.png]])
+
*[[File:dotdotdot.png]] three dots toggle on and off the visibility of the column (it becomes an arrow when the column is invisible [[File:arrow.png]])
 
*[[File: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
 
*[[File: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
*[[File:bar_graph.png]] bar graph presents statistics about the column, at the same time that allows for filters to be added
+
*[[File:bar_graph.png]] bar graph presents statistics about the column; filters may also be added using this feature
 +
 
  
 
===Table manipulation===
 
===Table manipulation===
 
 
Results table also have a set of buttons, on top of the table, that provide some functionality on the results and also on exporting, saving and displaying contents. Some of these buttons open a dialog on top of the column with actions that can be performed and need to be dismissed to return to the result table.
+
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.
+
 +
 
[[File:table_1.png]]
 
[[File:table_1.png]]
  
  
*'''Manage Columns''' - allows the user to select column order, add and remove columns, add new columns that are not part of the query/template and sort the order of all columns in bulk [[File:table_2.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
+
 
*'''Manage filters''' - allows for multiple filter management at once, including constraints and filter logic. The dialog allows to include filters from fields and items that are not part of the query/template [[File:table_3.png]]
+
 
 +
[[File: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  
 +
 
 +
 
 +
[[File:table_3.png]]
 +
 
 +
 
 +
*'''Manage Relationships''' - allows for setting attributes as required (inner join) or optional (outer join). This allows for exclusion of 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 
 +
 
 +
 
 +
[[File: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 WormMine list that can be saved by the user so it can be applied later on a different query or can be kept between releases, allowing for release differences to be examined. One column or individual rows can be selected for a list. Once selected, a list name has to be provided to save the list (to take full advantage, create an account and login first)
 +
 
 +
 
 +
[[File: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
 +
 
 +
 
 +
[[File:table_6.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 (by using this feature a Undo button will the toggled on) [[File:table_4.png]]
 
  
*'''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) [[File:table_5.png]]
+
*'''Export''' - saves a text file with the items in the table. Columns and rows can be selected, headers can be added, and compression can be applied to the resulting file (useful for really long tables). It is possible to send the results to a Galaxy or Genomespace service. Depending on the kind of results displayed, there are options to save the file as FASTA or other common formats
  
*'''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 [[File: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 [[File:table_7.png]]
+
[[File:table_7.png]]

Latest revision as of 21:53, 13 November 2018

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 - allows for setting attributes as required (inner join) or optional (outer join). This allows for exclusion of 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 WormMine list that can be saved by the user so it can be applied later on a different query or can be kept between releases, allowing for release differences to be examined. One column or individual rows can be selected for a list. Once selected, a list name has to be provided to save the list (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, and compression can be applied to the resulting file (useful for really long tables). It is possible to send the results to a Galaxy or Genomespace service. Depending on the kind of results displayed, there are options to save the file as FASTA or other common formats


Table 7.png