3.4. Selecting genes by query

You can access the "Make selection" dialog box (Fig. 3.4.1) by clicking the Table>Select genes by query command on the main menu. Using this dialog box, you can select genes from the working table by search expression.

3.4.1. Dialog box elements

3.4.1.1. Search expression bar is a text field located at the top of the dialog box. To clear the contents of this text field, click the "Clear Expr." button.

3.4.1.2. Status bar (comments) is located below the search expression field. This field contains additional information.

3.4.1.3. The "Field" pane - the field index input bar contains a drop-down list of fields (Fig. 3.4.2.A). Click the "Select" button to view the list. The fields are presented in the following format:

Fn NAME, where n is the number of the field and NAME is its name.

If any field is selected, the status field displays the following information about the field:

$Fn: type=FIELDTYPE. Is item of group(s):x, where n is the field number, FIELDTYPE is the name of the data type for this field, and if the field you are searching for is included into other groups, then õ lists the numbers of these groups.

The "Insert" button adds the current value of $Fn to the expression (n is the field number).

3.4.1.4. Text field selection bar contains:


Figure 3.4.1 "Make selection" dialog box
1. Search expression bar. 2. Status bar. 3. Field index input bar. 4. Text field selection bar. 5. Group number input bar. 6. Card index number bar. 7. The OK button that exits the dialog box, accepts the search results, and creates a new table. 8. The Scan button that performs search by expression. 9. The Cancel button that exits the dialog box without creating a new table. 10. The Clear expression bar button. 11. The checkbox that regulates the list of genes selected by the last query and their scores. 12. List of genes selected by the last query and their scores. 13. Criteria for gene selections. 14. Filter by gene number. 15. Query input buttons.

3.4.1.5. The "Group" pane - Group number input bar contains the following elements:

If additional conditions are defined, they are added to the expression:

$Gn:50%

A B
C
Figure 3.4.2 Selection lists
A. Field list. B. List of text values of the selected field. C. Group list.

3.4.1.6. The "Card No." pane - the card index number bar allows you to enter the number of a gene in the table. The "Insert" adds the $N value to the expression.

3.4.1.7. Query input buttons are used to add various operations, figures, and mathematical functions to the expression.

3.4.1.8. The "Expr. Score options" contains:

3.4.1.9. Control buttons:

Note. When the search is in progress, you will see the "Please wait" information box (Fig. 3.4.3) that will disappear after the search is complete.


Figure 3.4.3 "Please wait" info box

When the search is complete, an additional item appears in the "Select Table" dialog box (Fig. 3.4.4). The name of this item corresponds to the selected set of genes. You can save all gene selections obtained when working with the program and switch between them. To delete the list of current tables, click the Table>Remove all generated selections command on the main menu. Figure 3.4.4 shows a table of genes selected under the search conditions illustrated in Fig. 3.4.1.


Figure 3.4.4 Query results
1. New gene selection. 2. Item corresponding to the new selection.