INTRODUCTION {#SEC1}
============

During recent years, gene expression data from many studies have been made publicly available through resources such as the NCBI GEO repository (<http://www.ncbi.nlm.nih.gov/geo>, ([@B1])). These public resources are widely used to analyze changes in gene expression between different cells. For instance, in normal tissue, gene expression analysis can be used to identify housekeeping genes and tissue-selective expression patterns ([@B2],[@B3]). In cancer cells, the oncogenic transformation is associated with major alterations in gene expression ([@B4]). These changes result in a unique expression profile found in each tumor type and is considered a key molecular marker for diagnostic and prognostic assessment of cancer ([@B5],[@B6]). For example, breast cancers can be categorized into subtypes (Luminal, Basal A and Basal B) solely through their unique gene expression profiles ([@B5],[@B7],[@B8]). Thus, analyzing databases generated from a superset of gene expression experiments across cancer types can potentially yield further categorization into new tumor subtypes. However, tumor-specific gene expression analysis is not limited to the identification of molecular markers but can also serve as a tool to identify unknown mechanism essential for the cancer cells.

Among the six cancer hallmarks which were proposed more than a decade ago is 'sustained proliferation signaling' ([@B9]). Many of these unregulated signaling cascades induce the expression of genes needed to support the proliferation machinery. Metabolic remodeling was recently suggested as one of the emerging hallmarks of cancer ([@B10]), with the notion that cells must generate and supply the building blocks needed for proliferating cells (reviewed in ([@B11]--[@B14])). This remodeling includes nucleotide biosynthesis, as the expression and activity of many enzymes in this pathway, such as thymidylate synthase (TYMS) and ribonucleotide reductase (RRM1 and RRM2), are elevated in proliferating cells ([@B15]). Because of their proliferative-related activity and expression, many of these metabolic enzymes are the targets of common chemotherapeutic drugs. Thus, a comparison in the gene expression between normal resting cells and the counterpart tumors may result in the identification of molecular mechanism needed to support the proliferation machinery. Among them are uncharacterized metabolic processes that generate metabolites needed to satisfy the proliferative cells metabolic demand.

The unique expression profile of each cancer strongly indicates on the existence of subtype-specific mechanisms. For instance, some metabolic genes demonstrate selective expression in specific cancer types, suggesting unique metabolic demand in these cells. Phosphoglycerate dehydrogenase (PHGDH) is upregulated primarily in estrogen receptor-negative breast cancer and melanoma ([@B16],[@B17]). Similarly, serine hydroxymethyltransferase 2 (SHMT2) and glycine decarboxylase (GLDC) are upregulated in human glioblastoma multiforme ([@B18]); alkylglycerone phosphate synthase (AGPS) in aggressive breast cancers ([@B19]); and the mesenchymal metabolic signature genes in mesenchymal-like cancers ([@B20]). Therefore, a systemic analysis of cancer-dependent gene expression can serve as a tool to identify unknown mechanisms essential for the tumor cells. Any method to detect novel cancer-related mechanisms needs to include the ability to identify genes essential for proliferation as well as those critical for only a subset of tumors. Since these types of analysis across many different samples can be challenging, pre-processed expression compendia could be a powerful tool for assisting gene expression studies.

The increase in gene expression analysis usage in recent years was followed by the development of web-based tools, which provide a relatively easy and convenient method for analysis. One of the advantages of analyzing Affymetrix expression arrays is the ability to assemble arrays generated in different experiments but in a very consistent manner ([@B2],[@B20]). This results in a large-scale expression profile that has more statistical power and can better overcome non-biological biases which could confound data generated in a single experiment ([@B21]). The optimal usage of these websites is dependent on particular scientific question as each one of them contains different features. Among the commonly used websites is BioGPS (<http://biogps.org> ([@B22],[@B23])) which displays gene expression in many different datasets. Similar to BioGPS, Oncomine (<https://www.oncomine.org> ([@B24],[@B25])) has a large variety of samples, but also allows the user to compare expression between normal tissues and tumors. However, in this commercially available website paid subscription is required for enhanced support and features. Web-based tools such as the GTEx portal (<http://www.gtexportal.org> ([@B26],[@B27])) are resources for studying human gene expression in the context of genetic variation. The EBI Expression Atlas (<https://www.ebi.ac.uk/gxa/home> ([@B28],[@B29])) provides information on gene expression patterns under multiple biological conditions. Other websites such as the Human Protein Atlas (<http://www.proteinatlas.org> ([@B30])) are not limited to RNA profiles but also provide information on protein levels, including images of their spatial distribution. More recent gene expression analysis tools include GENT (<http://medical-genome.kribb.re.kr/GENT/> ([@B31])) and BioXpress (<https://hive.biochemistry.gwu.edu/tools/bioxpress/> ([@B32])). Despite the existence of many gene expression analysis tools, a resource providing the ability to quickly compare the expression of multiple genes in parallel between normal tissues, primary tumors and cancer cell lines, is still limited.

The Metabolic gEne RApid Visualizer (MERAV) website was generated in order to provide additional and more advanced tools in analyzing gene expression. In MERAV, all microarrays were normalized together, providing a more accurate way to compare the expression between the different cell types (normal tissues, primary tumors and cancer cell lines). The user is not limited to the analysis of a single gene, as the website provide the option to analyze multiple genes in parallel. The search option is flexible as one can pinpoint and filter the search on specific tissues at multiple levels. In addition, all the arrays have detailed annotation, providing a reference to the original experiments. The website also offers the option to calculate the correlation between pairs of genes and to present the data in multiple ways (barplot, boxplot and heatmap). MERAV is linked to two other databases, NCBI Entrez Gene (<http://www.ncbi.nlm.nih.gov>) and the Kyoto Encyclopedia of Genes and Genomes (KEGG) (<http://www.genome.jp/kegg/>) pathway search ([@B33],[@B34]), which allow the user to obtain more comprehensive information for each of the genes selected. Importantly, as opposed to many other tools, MERAV uses updated Affymetrix probeset definitions. These updated probesets are much more accurate than those from the array\'s original design and produce one value per gene, rather than multiple values which can be inconsistent and more difficult to interpret ([@B35]). Finally, the MERAV database has been generated and designed as a preferred tool for the specific analysis of metabolic gene expression. We designated a specific matrix that contains the expression data of metabolic genes only, resulting in a faster analysis for these gene sets. Additionally, the website provides an easy option to compare the expression level of all the genes which belong to the same metabolic pathway as determined by KEGG. The MERAV advanced attributes are expected to facilitate a wide range of studies of gene expression across a broad spectrum of biological processes, and in particular to analyze metabolic genes expression both in normal and tumor tissues.

MATERIALS AND METHODS {#SEC2}
=====================

Database content {#SEC2-1}
----------------

MERAV database was assembled from the human gene expression data obtained from the NCBI GEO repository. In particular, we manually curated Affymetrix U133 Plus 2.0 arrays (GPL570 platform in GEO). This platform was chosen over other Affymetrix designs because it includes a relatively recent set of probes and comprises a wide range of experiments (115,886 in GEO as of August 2015). The assembled arrays reflect the human gene expression in normal tissues, cancer cell lines and primary tumors, and were collected from the following sources (Figure [1A](#F1){ref-type="fig"} and Table [1](#tbl1){ref-type="table"}): (i) Cancer Cell Line Encyclopedia (CCLE) ([@B36]), a joint project between Novartis and the Broad Institute, representing the expression of 729 cell lines; (ii) GlaxoSmithKline (GSK) representing the expression of 870 cell lines ([@B37]); (iii) Expression Project for Oncology (ExpO), a gene expression database representing the expression of 1,312 primary tumors generated by the International Genomic Consortium (GEO accession: GSE2109); (iv) Human Body Index (HBI) that represents the expression of 426 normal human tissues (GEO accession: GSE7307); (v) Gene Expression Omnibus database (GEO) ([@B1],[@B38]), human microarray data is publicly available from the NCBI GEO database. In order to retrieve the GEO arrays we manually searched the NCBI GEO dataset for the most relevant experiments. This dataset includes gene expression data from normal tissues (N, 317 arrays), primary tumors (P, 292 arrays) and cancer cell lines (C, 508 arrays) and were labeled GEO-N, GEO-P, GEO-C respectively.

![Generation of the MERAV database. (**A**) Schematic presentation of the procedures used to generate the MERAV database. (I) Human gene expression data were collected from the following resources: Cancer Cell Line Encyclopedia (CCLE), GlaxoSmithKline (GSK), Gene Expression Omnibus database (GEO), Human Body Index (HBI) and Expression Project for Oncology (ExpO). (II) The data were assembled and normalized together, followed by quality control and removal of low quality arrays. (III) The database was renormalized and non-specific probes were removed. (IV) The arrays were annotated to obtain a more complete and unified annotation style. (**B**) Relative proportion of each component array type in the database. The number in parenthesis indicates the number of arrays of each type. (**C**) Identical cell lines demonstrate a higher Pearson correlation, despite having been generated in different experiments. Using all arrays from cancer cell lines (2,016 samples), the Pearson correlation between each one pair was calculated. The boxplot represent the distribution in the correlation between the non-identical and the identical cell lines. The *p* values for the indicated comparisons were determined using Student\'s *t*-test.](gkv1337fig1){#F1}

###### Number of arrays from each source

  Source   Number of arrays
  -------- ------------------
  EXPO     1,312
  GSK      870
  CCLE     729
  GEO-C    506
  HBI      426
  GEO-N    317
  GEO-P    292

The MERAV database was generated from the indicated sources, with the number of constituent arrays shown.

Array quality control {#SEC2-2}
---------------------

The assembled microarrays were initially normalized by robust multichip analysis using the 'affy' package from Bioconductor, resulting in a database composed of 4,644 arrays. Due to the heterogeneity of sources, we applied standard quality parameters, which included normalized unscaled standard error, relative log expression ([@B39]) and the deletion of duplicate arrays. In addition, if \<35% of the genes in a given array were found to be 'present' based on the absent/present call, the array was removed ([@B39]). In total, 190 arrays did not meet the quality standard and were removed from our compendium (Figure [1A](#F1){ref-type="fig"}). The remaining arrays were then reassembled and normalized together as before. Combined, there are 4,454 arrays, including normal tissues (726 arrays), cancer cell lines (2,016 arrays), primary tumors (1,460 arrays), non-cancer cell lines (79 arrays) and metastatic tumors (173 arrays) (Figure [1B](#F1){ref-type="fig"}). We found the analysis of the metastatic samples to be challenging as their expression demonstrated a combination of both the primary tumors and the host tissues. Due to this complexity, we decided to omit the option to analyze metastatic tumor tissues from the website, despite their presence in the database, leaving a total of 4,281 arrays (Figure [1A](#F1){ref-type="fig"}).

Probe quality control {#SEC2-3}
---------------------

Basing the analysis on standard Affymetrix probesets can complicate the analysis. First, the annotation of Affymetrix probes relies on earlier genome and transcriptome models that in some cases have been found to contain errors ([@B35]). In addition, each gene in the array is represented by several probesets. In some cases, different probesets can demonstrate differing or even opposing changes in expression levels, making the analysis challenging. We therefore took advantage of redefined probesets, assigning a single probeset per gene using the method proposed by Dai *et* *al*. ([@B35]). This reorganization not only eliminated non-specific probes, but was demonstrated to improve the precision and accuracy of the microarray ([@B40]). However, the elimination of these non-specific probes resulted in the loss of 247 genes, which included 72 metabolic genes (Supplementary Table S1). The remaining arrays and genes were then assembled to generate the MERAV database.

Annotation {#SEC2-4}
----------

The Affymetrix arrays were gathered from a variety of sources, each having its own sample annotation method. To achieve consistency, we applied a more uniform annotation standard across the arrays. This annotation includes the type of sample (normal tissues, cancer cell lines, non-cancer cell lines and primary tumors), tissue of origin, and tissue subtype (in normal tissues) or cancer classification (in primary tumors or cancer cell lines) (Supplementary Table S2). Furthermore, we added the GSM accession number for each array, which uniquely identifies the exact experiment in the NCBI GEO Dataset (<http://www.ncbi.nlm.nih.gov/gds>) in which the data were generated. Cell line names were assigned according to the following order of precedence: Cancer genome project \>ATCC\> DSMZ\>Web search.

Batch effects {#SEC2-5}
-------------

The accuracy of high-throughput genome analysis is sometimes subject to non-biological errors, which may affect the interpretation of the data. One of the most common sources of error is batch effects ([@B21]), where experimental measurements are influenced by batch-specific biases. Due to batch effects, replicated samples obtained from the same source can demonstrate a greater similarity than those from different sources. In order to assay the magnitude of any such non-biological effects, we compared the expression profile of the same cell lines obtained from different sources when available (Table [2](#tbl2){ref-type="table"}). This was accomplished by downloading the entire set of cancer cell line arrays (2,016 arrays) assaying expression of the entire transcriptome (17,789 genes). Using Pearson correlation, the gene profile of each array was compared to that of each other array. Analyzing the correlation between the arrays showed that the same cell lines demonstrate a higher correlation between the replicates (mean = 0.962, +/−0.035) than with non-identical cell lines (mean = 0.845, +/−0.035). The high correlation between identical cell lines indicates a low magnitude of batch effect (Figure [1C](#F1){ref-type="fig"}) in the MERAV database. Also, given that MERAV contains data from a large variety of sources (Table [1](#tbl1){ref-type="table"}), results that are consistent across sources reflect higher reproducibility than results from only a single source. In order to maximally reduce the batch effect, we adjusted the samples with ComBat ([@B41],[@B42]), using the sample description as a covariate. As shown by Principal Component Analysis (PCA) (Supplementary Figure S1), batch adjustment, as expected, effectively removed much of the dataset component of the expression profiles of the cell line samples, many of which are present in multiple datasets. The primary tumors and normal tissue samples displayed lower batch correction, largely because most samples were present in only one dataset.

###### Number of cell line replicates

  Number of representative arrays   Number of cell lines
  --------------------------------- ----------------------
  1                                 469
  2                                 83
  3                                 128
  4                                 143
  5                                 33
  6                                 23
  7 and up                          3

Some of the cell lines in the MERAV database are represented by multiple arrays, summarized in this table.

For example, 469 cell lines have data from a single array, 83 have data from two arrays, etc.

WEBSITE IMPLEMENTATION {#SEC3}
======================

MERAV is written in Perl CGI and JavaScript, specifically using Ajax/jQuery. In addition, scripts for boxplots were implemented in R. Heatmap data can be visualized in Java TreeView ([@B43]). Data are stored in simple text files.

WEBSITE PROPERTIES {#SEC4}
==================

Metabolic genes {#SEC4-1}
---------------

We generated the MERAV database to assist in the analysis of gene expression in normal tissues and cancer samples. Even though MERAV is designed to analyze the whole genome, we implemented multiple features, which can further facilitate the study of metabolic genes. First, we added the option to search for a subset of genes that were previously identified as 'metabolic genes' ([@B17],[@B20]). This metabolic set includes 1,704 genes, which encode enzymes that modify small molecules. This list was generated by cross-referencing metabolic pathway maps with their corresponding KEGG pathways ([@B17]). In addition, MERAV is linked to KEGG pathway search; when the user searches for the presence of gene(s) of interest in the matrix, a pop-up search result window appears to provide additional information: this window includes a direct link to KEGG pathway search, which indicates the corresponding pathways (metabolic or signaling) to which the gene of interest belongs. Finally, we provide the user with the ability to search for multiple genes from the same metabolic pathway, as determined by KEGG. Thus, although MERAV can be used to analyze gene expression in the entire human genome, we also provide a convenient predefined subset particular to metabolic genes.

Examples {#SEC4-2}
--------

Many metabolic genes demonstrate a tissue-specific expression profile ([@B44]). For example, the three isoenzymes of the glycolytic gene aldolase (ALDOA, ALDOB and ALDOC) are expressed in distinct tissues. ALDOA is expressed in the muscle, ALDOB in the liver and kidney, and ALDOC in the brain and central nervous systems ([@B45],[@B46]). Searching ALDO isoenzymes in MERAV yields similar tissue expression as can be found in the literature (Figure [2A](#F2){ref-type="fig"} and [B](#F2){ref-type="fig"}), suggesting that MERAV can be used as a tool to identify tissue-selective genes.

![MERAV can detect known gene expression profiles. (**A**) Expression of Aldolase isoenzymes in different normal tissues. The three Aldolase isoenzymes were subjected to a search in MERAV for their expression in selected normal tissues. The results represent the bar graph, (generated by MERAV). The bars colors were manipulated (a feature in the MERAV) in order to indicate the tissue of origin. The color legend is shown in the upper right-hand corner. CNS-Central Nervous System. (**B**) Expression of Aldolase isoenzymes in different normal tissues. The same search parameters as in (A), with the results presented as a boxplot. This figure was generated using MERAV without any additional tools. CNS-Central Nervous System. (**C**) RRM1, RRM2 and TYMS expression is elevated in cancer cell lines. These three genes were subjected to a search in MERAV. For each tissue, a boxplot was generated that demonstrates the expression in normal tissues (orange) and cancer cell lines (green). This figure was generated using MERAV without any additional tools. CNS-Central Nervous System. (**D**) RRM1, RRM2 and TYMS expression is elevated in cancer cell lines. A table represents the *p* values for each tissue and gene as indicated in (C). The expression data was downloaded and the distribution between the normal tissues and cancer cell lines for each tissue was determined. The *p* values for the indicated comparisons were determined using Student\'s *t*-test and calculated in R.](gkv1337fig2){#F2}

Several metabolic genes, such as RRM1, RRM2 and TYMS, are overexpressed in cancer cells. TYMS, a gene essential for cell viability, is inhibited by 5-fluorouracil, a known chemotherapeutic drug ([@B15]). Searching the MERAV database for the expression of these metabolic enzymes both in normal tissues and in cancer cell lines shows that the expression levels of all three genes are significantly elevated in cancer cells (Figure [2C](#F2){ref-type="fig"} and [D](#F2){ref-type="fig"}). This identification of metabolic genes known to be upregulated in cancer cells indicates that MERAV has the potential to effectively identify uncharacterized cancer-induced genes.

CONCLUSION {#SEC5}
==========

We created the MERAV database and analysis tools in order to harness aggregate array data for deeper insights into gene expression across the entire human genome and across normal cell lines, primary tumors and cancer cell lines. In order to provide investigators with a tool to accurately determine under which conditions and in which primary tumors and cell types the expression of a gene or set of genes of interest is altered, we collected and curated a matrix comprised of data from multiple public repositories and developed analysis tools for the study of changes in gene expression between cell types. Furthermore, MERAV was additionally designed to facilitate the identification of metabolic genes known to be upregulated in cancer cells therefore promoting the identification of uncharacterized cancer-induced genes.

SUPPLEMENTARY DATA {#SEC6}
==================

[Supplementary Data](http://nar.oxfordjournals.org/lookup/suppl/doi:10.1093/nar/gkv1337/-/DC1) are available at NAR Online.

We want to thank Eric Hagman, Brad Wilson and Logan Engstrom for their help in initiating the website; Michael Pacold for suggesting the name MERAV; and members of the Sabatini lab for their helpful suggestions.

FUNDING {#SEC7}
=======

National Institutes of Health \[CA103866, AI47389 to D.M.S\]; Life Science Research Foundation and Ludwig Postdoctoral Fellowship (to Y.D.S.); Howard Hughes Medical Institute (to D.M.S.). Funding for open access charge: NIH \[CA103866, AI47389\].

*Conflict of interest statement*. None declared.
