MRSpec Database Query and Visualization

Metabolites: Gender: Field Strength: Location:
Classification code: Diagnosis keywords:
Merge Graphs:
Log Scale:
Trendline:
Overlay queries:
Detailed legend:
More options
Submit Query
clear selection (esc) - clear canvas (del) - export canvas to file - export charts as .png - help


tabPatientIDs:
ScanIDs:
Min Age to Show:
Age:

SD score:
tabPatientIDs to exclude:
ScanIDs to exclude:
Max Age to Show:
Limit around age:
Select all metabolites:


Patient label (i.e. name):
Age of patient(s):
Metabolite values:

Diagnosis keywords to exclude:
Indication keywords:
Indication keywords to exclude:
Treatment keywords:
Anesthesia keywords:

The minimum information required to display a query is one or more metabolite to show, which can be entered in the upper left hand corner. You may specify further refinements such as gender, field strength, location, and much more. You can also manually enter patient data to compare to the database. To submit a query, click "submit query" in the upper left hand corner, or press ENTER at any time.

You can find out more about a particular option by hovering over it for a few moments to display a tooltip. The symbol "" indicates that more settings related to that option are available - just click on the symbol to reveal them.

• Keyword search has been expanded to include Treatment, Indication and Anesthesia.
• Now you can manually enter patient data to display on the graph under "More Options". Note that when the 'overlay' query option is selected, the input fields for patient data will be cleared to prevent previously entered data from inadvertently being added again.
• Change default standard deviation thresholds and echotimes by clicking "More options".
• For metabolites, location and indication code, click on or type inside the box to search/reveal options; you may select multiple options
• Merge two or more metabolites on the same graph by selecting the "Merge" checkbox.

Keyword search is implemented using the MySQL 'LIKE' clause, whose basic usage can be summarized as follows:
• For most searches, use the '%' symbol on both ends of the word, i.e. '%glioma%'. '%' is a wildcard for an unlimited number of characters. For instance, if you want to match the word 'dog' in the phrase 'A dog runs', you would need to search '%dog%' since it appears in the middle of the sentence.
• Use the '_' symbol as a wildcard for a single character. For instance, 'T_m' would match 'Tim','Tom','Tum' and any other letter in the middle.
• You can enter multiple keywords separated by a comma; scans will be returned if they match any of the keywords entered in that box.
• By clicking on in the keyword box, you can enter keywords to EXCLUDE scans from being returned as matches. Only scans that do not have any of these words will be returned.