For example, in most pipelines, each nucleus has exactly one cytoplasm, so the first row of the Per-Object table contains all of the information about object #1, including both nucleus- and cytoplasm-related measurements. Typically, if multiple types of objects are identified and measured in a pipeline, the numbers of those objects are equal to each other. The Per_Object table has another primary key called ObjectNumber, which is unique to each image. The two tables are connected with the primary key column ImageNumber, which indicates the image to which each object belongs. There is one row of object measurements per object identified.
#Cellprofiler properties file plus
The Per_Image table consists of all the per-image measurements made during the pipeline, plus per-image population statistics (such as mean, median, and standard deviation) of the object measurements.These tables are the Per_Image table and the Per_Object table (which may have a prefix if you specify): The database is set up with two primary tables. If you forget this module, you can also run the ExportDatabase data tool after processing is complete its functionality is the same.
This module must be run at the end of a pipeline, or second to last if you are using the CreateBatchFiles module. Optionally, you can create an SQLite database file if you do not have a server on which to run MySQL itself. It allows you to create and import MySQL and associated data files into a database and gives you the option of creating a properties file for use with CellProfiler Analyst. This module exports measurements directly to a database or to a SQL-compatible format. Export To Database exports data directly to a database, or in database readable format, including an imported file with column names and a CellProfiler Analyst properties file, if desired.
0 kommentar(er)
