You just inserted a genomics file experiment by importing your excel file (as shown here: Import Excel file with Genomics data to InSilico DB).
To perform comparative analysis on your gene-expression data (e.g Which genes are over-expressed in group1 VS group2?) you have to first label your samples.
After inserting an Excel file, the clinical annotations table of your study will have two columns: ID and Sample Name. The IDs which look like ISDBMxxx are unique to your sample (excel column) and are automatically generated by our system. The Sample Name correspond to the column headers of your excel file.
The Annotations table should look like this:
Click on the "Edit Clinical annotations" Button
And you will enter the "Edit" mode. note the tool bar has now changed.
You can use this tools to add, duplicate, delete columns and use the search and replace tool (all of these work on the current selected column). you can also click on the cells and add clinical annotations by typing labels.
In this example we have many samples (1098). You can see this on the right side of the table. A tree representation of the samples' annotations. I will import a csv file that contains my clinical annotations as shown in the image bellow.
Note the second column of my excel file, containing the clinical annotations, is called SAMPLE_ID, and it corresponds to my column "Sample" in my clinical annotations table. I will edit this in my excel file to make sure they match (I could also edit the header in the InSIlico DB clinical annotations table), and export the file to CSV format .
Back to the "Clinical annotations" table in InSilico DB select the mapping column and click the "Import CSV" button. A message will appear to make sure you have selected the right mapping column. Click "Ok".
That's it! All corresponding annotations have now been added.
Click the "Update last version" to save your changes
Continuing the discussion from How can I edit Clinical Annotations in InSilico DB: