... | ... | @@ -15,7 +15,7 @@ for doing it recursively (i.e. when the tables are in multiple subdirectories): |
|
|
`find . -type f -name "*.csv" -exec awk 'NR==1 || FNR!=1' {} + > ../table.csv`
|
|
|
Note that the tables must have the same format, i.e. use the same delimiter and have the same columns in the same order. This also assumes that the tables are the only .csv files in the directory.
|
|
|
##### Content
|
|
|
To link data points to images, the table should include one column with the **path to image files relative to the image root directory** and each cell of this column must reference only one file. Using the example below, the image root directory is 'screen\_images' and therefore the table column for data points associated with image W001-P001-Z000-T0000-s1234-Cy3.tif should contain the relative path 'plate1_replicate1/well001/W001-P001-Z000-T0000-s1234-Cy3.tif'. There can be multiple columns with links to images but only two can be used simultaneously in the IDE.
|
|
|
To link data points to images, the table should include one column with the **path to image files relative to the image root directory** and each cell of this column must reference only one file. Using the (example below)[#images], the image root directory is 'screen\_images' and therefore the table column for data points associated with image W001-P001-Z000-T0000-s1234-Cy3.tif should contain the relative path 'plate1_replicate1/well001/W001-P001-Z000-T0000-s1234-Cy3.tif'. There can be multiple columns with links to images but only two can be used simultaneously in the IDE.
|
|
|
The IDE references ROIs by the **coordinates of an anchor point** (e.g. the ROI centre) therefore there should be a column for each of the relevant coordinates: x, y and either z or t. Coordinates (x,y) must be in pixels relative to the top left corner of the image (which is pretty much the standard for image analysis software).
|
|
|
For high-throughput microscopy data, the table should have separate columns for plate and well identifiers. Wells must be identified either by indices starting from 1 in the top left corner of the plate and incremented by row from left to right or by row/column coordinates with rows identified by letters and columns by numbers with well A1 in the top left corner of the plate. When using versions < 1.1.0, all wells must be represented in the data file as missing wells may cause unexpected behaviour in these early versions. In newer versions, plate size must be specified if wells are missing from the data.
|
|
|
##### Data table example
|
... | ... | |