From SciStream, data formats can be set up for the new file format being created. The different data formats supported by SciStream are plate block, plate block columnar, and columnar.
- Plate block: Data within the plate is organized into blocks with a value per well, arrayed as a grid.
- Plate block columnar: Data within the plate is organized into blocks per plate; each well shows on a new row, enabling multiple values per well in different columns.
- Columnar: Data is organized in columns. Determining how to read the columns is fundamental.
The following are examples of the different combinations of the plate block, plate block columnar, and columnar data formats when using SciStream.
Plate block, a single value
In this case, there is an individual reading per well. Thus, in the output table, there will be a row for each reading. It is recommended to use header cells to label each reading.
| File contents: | Key settings in SciStream: |
| Output Table: | |
Plate block, multiple values
In this case, there are three readings per well. Here, it is a requirement to define three data blocks for each plate. The first block holds the compound name, the second block holds the concentration, and the third block holds the reading. Thus, the user can assign columns to data blocks by number; the result then presents one row for each well with the three groups of values in different columns.
| File contents: | Key settings in SciStream: |
| Output table: | |
Plate block columnar, a single value
In this case, all data is organized into plate blocks, but the data is arranged in one row for each well. For a three by four plate size, there will be twelve rows in the plate block. The second column holds the compound ID, the third holds the concentration, and the fourth holds the reading.
| File contents: | Key settings in SciStream: |
| Output table: | |
Plate block columnar, multiple values
In this case, all data is arranged into plate blocks with one row for each well. Each column in the data block has the same reading (multiple values for each well). To execute this format, the user should outline a field in the plate header as: plate header cell: 2, 2- or plate header cell: 2, 2-7.
| File contents: | Key settings in SciStream: |
| Output table: | |
Columnar
In this case, all data information from the table is organized into columns, where there is a column for plates, a column for the wells, and a column for the readings. Each of these columns can be defined as attributes on the table.
| File contents: | Key settings in SciStream: |
| Output table: | |