previous Adding and removing constraints     (4/9) next
Altering the results output of a template Building a query from scratch

Change the query again to retrieve all genes on the 4th chromosome of Drosophila melanogaster:

  • Click on 'query' in the trail to return to the Query Builder. The right hand side summarises constraints in the current query. Note the constraint on Gene symbol is 'zen'. Clicking on the red cross next to 'symbol' will delete this constraint.

  • [remove_constraint.png ]

  • To constrain the current query to Drosophila melanogaster, click on the '+' sign next to organism in the model browser. Click on 'CONSTRAIN' next to 'name' (under 'organism'). This brings up a 'Constrain' section to the right (you might have to scroll down to view it). Select 'Filter query results on this field having a specific value' and choose Drosophila melanogaster from the drop-down menu. Click 'Add to query' next to the drop-down menu.

  • [add_organismConstraint.png ]

  • Next , constrain the current query for genes on the 4th chromosome, by clicking on 'CONSTRAIN' next to 'identifier' under 'chromosome'. In the 'Constrain' section to the right, enter a value for the chromosomal identifier: the identifier for the 4th chromosome is '4'. Click 'Add to query' next to the drop-down menu. Scroll down and click 'Show results' to run the query.

Re-run the query with the results sorted Z-A on the organismDbId (FBgn)

[buildtemplate_sort.png  ]
previous 4/9 next
Altering the results output of a template Building a query from scratch