Report Generation

When it comes to reporting, in addition to the options provided by the “Analysis Actions”, VarSome Clinical offers users the option to generate a report of specific variants in PDF format or a variant list export in Excel spreadsheet format.

Variant reporting works on a sample level, i.e. you can report multiple variants belonging to the same sample, but you cannot report one variant of the sample A and another of the sample B within the same report.

 

To create a report of any type, you can follow these steps:

  1. On the Variant Table page, you can either select one variant at a time just by clicking on it or you can select multiple variants at once (mass selection) by holding Ctrl and clicking on each variant you wish to include to your list.

  2. Then, depending on the type of report you want to create (Spreadsheet or Report) you can click on “Select variant(s) to export to a Spreadsheet” for the variant to be included in the Spreadsheet or “Select variant(s) to export to a Report” and then “Primary finding” or “Secondary finding” according to your findings, for the variant to be included in the Report.

  3. Select  to see the list of the variants selected for the Excel spreadsheet export, 



    or select to see the list of variants selected for the Report creation (Primary and Secondary). 

  4. Selecting   will export the variants in an .xlsx file as shown below:

      Selecting  will direct you to the following screen:

The information of the selected variants will be automatically visible on the Primary and Secondary findings sections, according to your selection. 

The form we provide as a template for creating your report is fully customizable, with all section tables editable to suit the user's needs. The final report layout you choose to generate will be saved for future use.

The report template consists of table sections, where all fields can be changed, along with the text and background colors and even the logo can be replaced with your organization’s logo.


In each section table, there is the option of changing the background color of a cell by right-clicking on it and then going to Cell >> Cell properties as shown below:


In the Cell properties menu, you can choose to change the background color, among other available styling options:

Furthermore, by clicking on the image41 icon, a Report widgets menu will be shown, with the following options:

  • Analysis information: General information including sample name, allelic balance, predicted gender, phenotypes, and diseases.
  • Content area: Field to write content-related information of the analysis.
  • All variants' information: Table with all selected variant's information.
  • Variant information: Mutation identification, followed by its classification and a short description of the variant. More information is included containing HGVS notation, related gene, exon, variant type, rs ID, zygosity, frequency, and coverage.
  • Variant references: List of scientific papers referring to a specific variant.
  • Gene information: Disease-related information from CGD, about the gene containing a specific variant.
  • Related drugs (if applicable): Information regarding the drug-gene interactions from DGIdb, and other data resources.
  • PMKB info (if applicable): Information about the gene containing a specific variant, retrieved from PMKB database.
  • CIVIC info (if applicable): Information about mutations shown to predict response to targeted therapy from CIViC database.
  • GHR info (if applicable): gene information from GHR.
  • Clinical Trials info (if applicable): Information about related clinical studies from AACT database. 

You can "drag and drop" one by one all the information you wish to include in the report.