<figure><img src="image_1.png" /></figure>

HAL
open science

# "Do my qPCR calculation", a web tool

Jérémy Tournayre, Matthieu Matthieu.Reichstadt@inrae.Fr Reichstadt,
Laurent Parry, Pierre Fafournoux, Céline Jousse

► To cite this version:

Jérémy Tournayre, Matthieu Matthieu.Reichstadt@inrae.Fr Reichstadt, Laurent Parry, Pierre Fafournoux, Céline Jousse. "Do my qPCR calculation", a web tool. Bioinformation, 2019, 15 (5), pp.369-372. 10.6026/97320630015369. hal-02172518

HAL Id: hal-02172518

https://hal.science/hal-02172518

Submitted on 3 Jul 2019

HAL is a multi-disciplinary open access
archive for the deposit and dissemination of sci-
entific research documents, whether they are pub-
lished or not. The documents may come from
teaching and research institutions in France or
abroad, or from public or private research centers.

L'archive ouverte pluridisciplinaire HAL, est
destinée au dépôt et à la diffusion de documents
scientifiques de niveau recherche, publiés ou non,
émanant des établissements d'enseignement et de
recherche français ou étrangers, des laboratoires
publics ou privés.

<figure><img src="image_2.png" /></figure>

Distributed under a Creative Commons Attribution 4.0 International License
"Do my qPCR calculation", a web tool

Jérémy Tournayre*<fnref n="1" />, Matthieu Reichstadt<fnref n="2" />, Laurent Parry<fnref n="1" />, Pierre Fafournoux<fnref n="1" />, Céline Jousse*<fnref n="1" />

Received April 24, 2019; Accepted May 3, 2019; Published May 15, 2019

DOI: 10.6026/97320630015369

**Abstract:**

In order to automatically process qPCR raw data, we present the tool "Do my qPCR calculation". We offer a website to automatically calculate the data normalization and represent the different samples graphically in an Excel file. This tool is also available on Github for installation and local use with or without web interface.

**Keywords:** qPCR, automation tool, web server

**Availability:** http://147.99.156.182/do_my_qPCRcalc/; The source code: https://github.com/JeremyTournayre/do_my_qPCRcalc

**Background:**

The fluorescence-based quantitative real-time PCR (qPCR) is a molecular biology technique that is routinely used in laboratories. It quantitatively monitors, in real-time, the amplification of a targeted DNA (or cDNA after reverse transcription of a target RNA) molecule during the PCR. The quantification is based on the number of cycles of PCR at which the fluorescence exceeds a given threshold (Cq). Softwares associated with qPCR apparatus provides Cq for each sample and usually propose a tool for calculation for quantification and normalization for each sample. However, the use of such specific software often requires a license and/or is restricted to a given operating system. For example, CFX Maestro™ Software license from Bio-Rad goes from 150 euros for the Mac version to 1000 euros for the Windows version (catalog price seen on 08/02/2019).

Given these constraints, researchers very often extract Cq from the computer connected to the thermocycler in order to carry out their own calculations in their own spreadsheet (for example Excel, LibreOffice, ...) which is tedious. To go further, researchers have built free tools to perform automatic calculations: for example,

QPCR and LinRegPCR. QPCR requires an install on a server and a license request [1]. LinRegPCR is an executable running only on Windows [2]. Unfortunately, it does not propose an example or template file to understand how the input file should be processed. Finally, to our knowledge, there is no free tool available on any plateform without the need to install a particular device to analyze qPCR data. That's why we present our tool: "Do my qPCR calculations".

"Do my qPCR calculations" can be used through a website hosted on a server that provides computing power. "Do my qPCR calculations" allows, from Cq, to calculate almost instantaneously in an excel file the relative quantities of RNA normalized by a reference gene. It allows taking into account groups of samples to perform student test between the control group and experimental groups. Also the tool makes histograms of each result. Input data will only be used for generate results and not for any further purpose. They are automatically deleted from the server when the Excel file is generated. We use the recommended MIQE nomenclature [3], i.e Cq, reference gene.

<footnote n="1">¹Université Clermont Auvergne, INRA, UNH, Unité de Nutrition Humaine, CRNH Auvergne, F-63000 Clermont-Ferrand, France;</footnote>

<footnote n="2">²Université Clermont Auvergne, INRA, VetAgro Sup, UMR1213 Herbivores, Unité Mixte de Recherche sur les Herbivores, F-63000 Clermont-Ferrand, France; Jérémy Tournayre - E-mail: Jeremy.tournayre@inra.fr; Celine Jousee - E-mail: celine.jousse@inra.fr;</footnote>

<footnote>*Corresponding authors</footnote>
<figure><img src="image_3.png" /><figcaption>**Figure 1:** A) The input data has to be in a file in .tsv, .xls, .xlxs. or .odt format or written in the web form. The first two rows contain options. The control group is defined in B1 cell: the "A" group is chosen. The reference gene in D1 cell: the "RefGeneName" gene is selected. The second row allows defining the qPCR efficiency for each gene written on the third row. On the third row there are two column headers: "Group" and "Sample" and then there are the genes: "RefGeneName", "TestGene1", "TestGene2". The other rows correspond to the data table: sample according to the Cq. Submitting this file to "do my qPCR calculation" allows you to obtain the result file in Excel format. B) The Excel file contains the normalized Cq for each sample with histograms. C) The Excel file also contains the average results and the student test for each experimental group between the control groups.</figcaption></figure>
**Methodology**

"Do my qPCR calculation" is built from Perl with libraries: Excel::Writer::XLSX, Spreadsheet::ParseExcel and Statistics::TTest. The ssconvert tool is used to convert xlsx/xls/ods files into .tsv format. The web interface is a PHP script containing HTML, PHP, CSS and javascript with jQuery, Jexcel and jQuery-csv libraries.

**Using the tool**

Figure 1 shows the input and output using an example for the tool

**Input:** "Template" contains a description of the input file. We offer one example, ready to be submitted, that can be downloaded in tabulated separated value .tsv, Excel or in OpenOffice/LibreOffice format. The first two rows permit to specify parameters such as the control group, the reference gene and the qPCR efficiency for each gene. By default: the first group corresponds to the control group, the first gene corresponds to the reference gene and the efficiency is set to 1.85 (92.5% efficiency). If applicable, the user can indicate a custom efficiency right above the gene name. The data has to be given in column with the following headers: "Group", "Sample" and the different amplified genes. Missing values (other than a number, i.e NA, empty...) may be present in the file; they will not be taken into account into calculations.

**Output:** The generated excel file contains two tabs for each analyzed gene. One tab contains the analysis done per sample and the next tab contains the average for each group. In the case of the analysis by sample, the table contains: (A) groups, (B) name of each sample, (C) Cq corresponding to the initial data, (D) average Cq of the control samples which permit to calculate (E) the delta Cq calculated as (D) - (C), (F) quantification calculated using the

efficiency set in the options (eff) and the delta Cq (E) with the formula: $eff^^(E), (G) normalized quantification by the reference gene, and (H) the log2 corresponding to the normalized quantification by the reference gene set in log2. The average tab contains: (A) groups, (B) average of the samples of the group, (C) SEM, (D) pvalue of the student test between the experimental group and the control group, (E, F and G) the results calculated with the log2 data. In each analysis histograms are generated to visualize the data.

**Conclusion:**

Our tool "Do my qPCR calculation" was created to provide to the scientific community a simple and efficient way to deal with qPCR data. In order to make it accessible to a maximum of users the tool is available on a website accessible on any Internet browser commonly used whatever the operating system and type of platform, i.e Windows, Mac... Moreover our tool provides results as a spreadsheet that can be dealt with any spreadsheet software. This tool is meant to be further developed if needed by taking into account the comments of users while keeping the tool easy to use.

**Acknowledgment:**

The Institut de Recherches Servier provided a financial support to the Jérémy Tournayre Ph.D. studies. The Centre National pour la Recherche Scientifique (CNRS) provided support for C.J., and P.F.

**References:**

[1] Pabinger S et al. BMC Bioinformatics. 2009 **10**:268. [PMID: 19712446]

[2] Ruijter JM et al. Nucleic Acids Res. 2009. **37**:e45. [PMID: 19712446]

[3] Bustin SA et al. Clin Chem. 2009. **55**:611. [PMID: 19246619]

Edited by P Kangueane

Citation: Tournayre *et al*. Bioinformation 15(5): 369-372 (2019)

**License statement:** This is an Open Access article which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly credited. This is distributed under the terms of the Creative Commons Attribution License
<figure><img src="image_4.png" /></figure>

<figure><img src="image_5.png" /></figure>

Biomedical Informatics Society

Agro Informatics Society

<figure><img src="image_6.png" /></figure>

Journal