Genes showing higher expression in either tumor or metastatic tissues can help in better understanding tumor formation and can serve as biomarkers of progression or as potential therapy targets. Our goal was to establish an integrated database using available transcriptome-level datasets and to create a web platform which enables the mining of this database by comparing normal, tumor and metastatic data across all genes in real time. We utilized data generated by either gene arrays from the Gene Expression Omnibus of the National Center for Biotechnology Information (NCBI-GEO) or RNA-seq from The Cancer Genome Atlas (TCGA), Therapeutically Applicable Research to Generate Effective Treatments (TARGET), and The Genotype-Tissue Expression (GTEx) repositories. The altered expression within different platforms was analyzed separately. Statistical significance was computed using Mann–Whitney or Kruskal–Wallis tests. False Discovery Rate (FDR) was computed using the Benjamini–Hochberg method. The entire database contains 56,938 samples, including 33,520 samples from 3180 gene chip-based studies (453 metastatic, 29,376 tumorous and 3691 normal samples), 11,010 samples from TCGA (394 metastatic, 9886 tumorous and 730 normal), 1193 samples from TARGET (1 metastatic, 1180 tumorous and 12 normal) and 11,215 normal samples from GTEx. The most consistently upregulated genes across multiple tumor types were TOP2A (FC = 7.8), SPP1 (FC = 7.0) and CENPA (FC = 6.03), and the most consistently downregulated gene was ADH1B (FC = 0.15). Validation of differential expression using equally sized training and test sets confirmed the reliability of the database in breast, colon, and lung cancer at an FDR below 10%. The online analysis platform enables unrestricted mining of the database and is accessible at TNMplot.com.

Genes showing higher expression in either tumor or metastatic tissues can help in better understanding tumor formation, and can serve as biomarkers of progression or as therapy targets with minimal off-target effects. Our goal was to establish an integrated database using available transcriptome-level datasets and to create a web-platform enabling mining of this database by comparing normal, tumor and metastatic data across all genes in real time.We utilized data generated by either gene arrays or RNA-seq. Gene array data were manually selected from NCBI-GEO. RNA sequencing data was downloaded from the TCGA, TARGET, and GTEx repositories. TCGA and TARGET contain predominantly tumor and metastatic samples from adult and pediatric patients, while GTEx samples are from healthy tissues. Statistical significance was computed using Mann-Whitney or Kruskall-Wallis tests.The entire database contains 56,938 samples including 33,520 samples from 3,180 gene chip-based studies (453 metastatic, 29,376 tumorous and 3,691 normal samples), 11,010 samples from TCGA (394 metastatic, 9,886 tumorous and 730 normal), 1,193 samples from TARGET (1 metastatic, 1,180 tumor, 12 normal) and 11,215 normal samples from GTEx. The most consistently up-regulated genes across multiple tumor types were TOP2A (mean FC=7.8), SPP1 (FC=7.0) and CENPA (FC=6.03) and the most consistently down-regulated gene was ADH1B (mean FC=0.15). Validation of differential expression using equally sized training and test sets confirmed reliability of the database in breast, colon, and lung cancer (p<0.0001). The online analysis platform enables unrestricted mining of the database and is accessible at www.tnmplot.com.

Whole exome sequencing (WES) enables the analysis of all protein coding sequences in the human genome. This technology enables the investigation of cancer-related genetic aberrations that are predominantly located in the exonic regions. WES delivers high-throughput results at a reasonable price. Here, we review analysis tools enabling utilization of WES data in clinical and research settings. Technically, WES initially allows the detection of single nucleotide variants (SNVs) and copy number variations (CNVs), and data obtained through these methods can be combined and further utilized. Variant calling algorithms for SNVs range from standalone tools to machine learning-based combined pipelines. Tools for CNV detection compare the number of reads aligned to a dedicated segment. Both SNVs and CNVs help to identify mutations resulting in pharmacologically druggable alterations. The identification of homologous recombination deficiency enables the use of PARP inhibitors. Determining microsatellite instability and tumor mutation burden helps to select patients eligible for immunotherapy. To pave the way for clinical applications, we have to recognize some limitations of WES, including its restricted ability to detect CNVs, low coverage compared to targeted sequencing, and the missing consensus regarding references and minimal application requirements. Recently, Galaxy became the leading platform in non-command line-based WES data processing. The maturation of next-generation sequencing is reinforced by Food and Drug Administration (FDA)-approved methods for cancer screening, detection, and follow-up. WES is on the verge of becoming an affordable and sufficiently evolved technology for everyday clinical use.