Browsing quantification results

MISA++ applications store quantification results in a standardized and flexible format that is capable of organizing large amounts of metadata. The data is stored as objects such as quantities with units, locations or application-specific objects such as glomeruli.


MISA++ for ImageJ includes a tool to filter, browse and process the quantification results and create tables of only the relevant information.


Important: The tool is designed to handle millions of data entries and uses a SQLite database to handle such an amount of data. The database is created by the MISA++ Result Analyzer application. Please check if it is installed and in the list of available applications (see Managing applications).


The user interface is divided into three sections:

  1. An interface to filter the quantification results

  2. A tree to navigate the filtered results

  3. The selected object(s) displayed as table or object


The data flows from left to right: Quantification results are filtered by the filter tool and then displayed in the object tree. You can browse the tree and further refine your selection that will be displayed as table or object.

Filtering

To add a filter, click Add filter and select one of the filter types. Each filter has a button Remove filter that deletes the filter from the list and a toggle Disable filter that temporarily disables the filter without deleting it.


Following filters are included in MISA++ for ImageJ:


<col />

<tr >
    <td ><p >
        <b>Filter</b></p>
    </td>
    <td ><p >
        <b>Description</b></p>
    </td>
</tr>
<tr >
    <td ><p >
        <img src="/img/imagej/userguide_html_7e9251409421e5be.png" name="image95.png" class="inline-image" border="0"/>

Filter by SQL

Allows insertion of a custom SQL filter query.

Filter by data

Filters quantification results that are attached to specific data.

Filter by object type

Restricts the object types (e.g. only list glomeruli).

Filter by sample

Only shows quantification results of specified samples.

Filter only direct attachments

MISA++ quantification results are hierarchical. With this filter, objects deeper down in the hierarchy are hidden.



Tip: If you want to re-use the filters for your own SQLite query, click Copy filters as SQL query to obtain the query.

Object tree

The object tree lists all unfiltered objects in a hierarchy and acts as input for the table and object browser.


The toolbar has following actions:


<col />

<tr >
    <td ><p >
        <b>Action</b></p>
    </td>
    <td ><p >
        <b>Description</b></p>
    </td>
</tr>
<tr >
    <td ><p >
        <img src="/img/imagej/userguide_html_7e9251409421e5be.png" name="image2.png" class="inline-image" border="0"/>

Automatically update

If enabled (default), the tree is automatically updated when a filter is changed.


        </p>
        <p >Disable this feature if you
        change lots of filter settings at once and don’t want to wait
        for the database update.</p>
    </td>
</tr>
<tr >
    <td ><p >
        <img src="/img/imagej/userguide_html_741a8f89f0bfae4f.png" name="image5.png" class="inline-image" border="0"/>

Update

Updates the tree manually.

Copy as SQL query

Copies the current selection as SQL query. This includes the SQL query from filtering.

Display by data

If enabled (default), the tree is organized by sample → data → sub-data → type → property.

Display by object type

If enabled, the tree is organized by MISA++ application → type → data → sample → property.


Creating a table and browsing objects

The data browser allows you to either browse the quantification results as objects or create a table (default option).


The table creator has following actions:



<col />

<tr >
    <td ><p >
        <b>Action</b></p>
    </td>
    <td ><p >
        <b>Description</b></p>
    </td>
</tr>
<tr >
    <td ><p >
        <img src="/img/imagej/userguide_html_7e9251409421e5be.png" name="Image6" class="inline-image" border="0"/>

Automatically update

If enabled (default), the table is automatically updated when a filter is changed or the selection the tree changes.

Update

Updates the table manually.

Export

Saves the table as *.csv or *.xlsx

Analyze

Opens a tool to further analyze the table (see Summarizing quantification results).

Current object

Tables can only be created for one object type. Use this selection to change the object type.

Edit columns

By default, the table does not contain all properties of the current object. The column editor allows you to include more columns or exclude unnecessary information.


By changing the current mode from Table to Object list, all selected quantification data is displayed as objects. You can browse the list and export objects in JSON format.