Importing Inventory from Titian Mosaic

Titian Mosaic is a popular inventory management system used by many life sciences companies. Currently, there is no Mosaic plugin that enables directly pushing inventory to Strateos from Mosaic however it is possible to export data from Mosaic and import that data into your Strateos inventory so you have all of your plate annotations available on your Strateos inventory and datasets.

Mosaic Canned Queries

This tutorial makes use of a canned query to generate a .csv for the plate you want to add to Strateos. You need to build a custom query to gather the information you want to add to Strateos but also format the 3 Strateos-required headers to make sure your data is parsed. You can see the Titian Mosaic Query interface below, with more information from Titian

1. Format your query headers

When bulk uploading a plate description with Strateos via a .csv the .csv must have 3 required columns to be parsed properly. These are the well index i.e A01 or E12, the volume in microliters for each well and finally a Well Label.

An example table is shown below, the first 3 column headers must be formatted exactly as below. Any additional columns you include will be attached to the aliquot as an Aliquot Property. Common property choices are: compound_id, molecular_weight, concentration_umol, solvent but you can choose which properties you want to surface. Aliquot properties can be passed through to the dataset generated for the plate, so can be used to make a dataframe that can easily be turned into a concentration curve or another analytical plot. Please make sure the results generated by Mosaic are formatted like in the table below.

❗️

Note that the volume is specified with a u not a µ

Pay close attention to your header formatting, the microliter abbreviation is specified with a u and not a greek µ.

Well Index

Well Label

Vol (uL)

Optional Property Name

Optional Property Name

...

A01

123456

8

Value

Value

...

A02

compound_x

8

Value

Value

...

A03

compound_y_DMSO

8

Value

Value

...

...

...

...

...

2. Run the query and download the results for each of your plates

Once your query has executed the results will be displayed. Click the Export button to download a copy of the results. Before the results are uploaded to Strateos, make sure the file format is a .csv.

3. Create a new container on Transciptic

After you have your .csv files you are ready to create the containers in Strateos. Create the container as you usually would, follow the guide in the Getting Started documentation.

4. Upload the .csv results file from you Mosaic query

After you have clicked the plus to add the container type of choice click the blue link indicated in the screenshot below to view the bulk upload dialogue.

Click the blue link to download the .csv template for bulk uploads and view the upload screen.Click the blue link to download the .csv template for bulk uploads and view the upload screen.

Click the blue link to download the .csv template for bulk uploads and view the upload screen.

When on the bulk upload view make click the blue button at the bottom of the page to upload your .csv from Mosaic.

As you already have the .csv you can just click upload.As you already have the .csv you can just click upload.

As you already have the .csv you can just click upload.

After you have selected your .csv file, the data will be parsed and your plate shown as below. From here you can click on a well and view the well properties to make sure your data has been parsed and attached.

Review the parsed properties for your aliquots.Review the parsed properties for your aliquots.

Review the parsed properties for your aliquots.

If there were any parsing errors with your aliquot properties the well will turn red. Common errors are insufficient volumes or disallowed characters such as / .

🚧

Name your plate!

Also, take the opportunity to name your plate. Barcodes are OK but often difficult for your team to know what the plate is from the barcode. We recommend also including a project name or code for example.

👍

Congratulations!

You just uploaded your plates with lots of detailed information for you to use in your downstream analysis and easier searching in Strateos.