Variant and patient data

Viewing and searching variant and patient data

Advanced options
The LOVD variant overviews support a range of advanced options. Not all options are available from all variant overviews.

Sorting
Sorting is available on all variant overviews and allows you to sort the data on whatever column you wish. The column currently sorted on has a darker blue background color than the other columns. Two arrows indicate which direction the values on sorted on:
arrow pointing downwards The values are sorted low to high (standard).
arrow pointing upwards The values are sorted high to low (reversed).

To sort on a certain column, click on the column header or on the arrows. If that column is already selected to sort on, the sort order will be swapped.
LOVD uses an algorithm that interprets the values of the Variant/Exon (if available) and Variant/DNA fields to facilitate proper sorting. The result of the algorithm is stored in a sort column, which LOVD uses by default to sort on. If sorting on any field other than Variant/DNA, LOVD will sort secondarily on this sort column.

Advanced search terms
LOVD allows boolean search terms, meaning you can construct complex queries with AND, OR and NOT logic. All search terms are treated as AND by default. OR is indicated with a pipe '|' with no spaces around it and NOT is indicated by an exclamation mark '!', not followed by a space. If you enclose two or more words in double quotes, LOVD will search for the combination of those words only exactly in the order you specify.
Note that search terms are case-insensitive and that wildcards such as * are treated as normal text!

Examples:
Search terms Field Result
> Variant/DNA Show only substitutions
A>T|T>A Variant/DNA Show only A to T or T to A substitutions
c.328 > Variant/DNA Show only substitutions at position c.328
p.(Arg X) Variant/Protein Show only arginine to stopcodon changes
Asian Patient/Origin/Ethnic Shows "Asian", but also "Caucasian" entries
Asian !Caucasian Patient/Origin/Ethnic Shows "Asian", but no "Caucasian" entries
Asian|African !Caucasian Patient/Origin/Ethnic Shows "Asian" or "African", but no "Caucasian" entries
"South Asian" Patient/Origin/Ethnic Shows "South Asian", but no "South East Asian" entries

Column hiding
The variant overviews can be personalized by hiding columns that you don't need. Especially the full overview including the patient data can get quite wide and to prevent a lot of horizontal scrolling, you can hide the columns you're currently not interested in. These settings will be stored in a cookie on your computer, so that the next time you return to LOVD the settings will remain. The link on the detailed entry view to temporarily unhide all columns does not influence the stored settings.

On the column headers of variant overviews that support this feature, there is a little red icon (red cross) that you can click to hide the column. The column will disappear, and leave a narrow column with an arrow (arrow). If several columns next to each other were hidden, only one arrow will be shown. Clicking on this arrow will show a selection list of the hidden columns, where you can choose the columns which you want to be restored. Use the link "Hide Specific Columns" to show a selection list where you can choose which (additional) columns to hide, and "Hide all columns" to show only the DNA column. To restore all columns all at once, click the "Unhide all columns" link.
Since LOVD v.2.0-23, the hidden columns are also hidden in the detailed view of the variant, in the patient data table, the variant data table and the listing of all variants reported in the selected patient. The hidden fields can be shown by clicking on the "show all fields" link on the top of the page, or by clicking on an arrow in one of the hidden columns of the entries overview at the bottom of the page. As mentioned on the page, this will not influence your configured display settings.