Abstract

The Functional Annotation of the Mammalian Genome project (FANTOM5) mapped transcription start sites (TSSs) and measured their activities in a diverse range of biological samples. The FANTOM5 project generated a large data set; including detailed information about the profiled samples, the uncovered TSSs at high base-pair resolution on the genome, their transcriptional initiation activities, and further information of transcriptional regulation. Data sets to explore transcriptome in individual cellular states encoded in the mammalian genomes have been enriched by a series of additional analysis, based on the raw experimental data, along with the progress of the research activities. To make the heterogeneous data set accessible and useful for investigators, we developed a web-based database called Semantic catalog of Samples, Transcription initiation And Regulators (SSTAR). SSTAR utilizes the open source wiki software MediaWiki along with the Semantic MediaWiki (SMW) extension, which provides flexibility to model, store, and display a series of data sets produced during the course of the FANTOM5 project. Our use of SMW demonstrates the utility of the framework for dissemination of large-scale analysis results. SSTAR is a case study in handling biological data generated from a large-scale research project in terms of maintenance and growth alongside research activities.

Database URL:http://fantom.gsc.riken.jp/5/sstar/

Introduction

Recent developments in sequencing technology and computational methods have influenced the way molecular biology research is conducted and enables the identification and profiling of molecules at a very high resolution with high accuracy (1). In the field of transcriptomics, the presence of RNA molecules was characterized by sequencing expressed sequence tags (2–4), and their relative abundance was quantified by microarray in a high-throughput manner based on predesigned probes (5). The emergence of next-generation sequencers enabled researchers to quantify transcript structure [exon structure by RNA-Seq (6)] and genome-wide transcription initiation sites (cap analysis of gene expression, CAGE) (7) without previous knowledge of individual transcripts. To ensure reproducibility and increase the utility of high-throughput data, public repositories have been established and maintained. For example the International Nucleotide Sequence Database Collaboration for sequence data (8), NCBI GEO (9), EMBL ArrayExpress (10) for gene expression data and SRA/EGA/DRA for next-generation sequencing (11). On top of these data repositories, targeted databases have been developed that provide curated data to facilitate biological interpretation and findings, such as the Gene Expression Atlas (12), BioGPS (13), UCSC Genome Browser (14), FANTOM3 CAGE databases (15) and FANTOM4 (16).

The FANTOM5 project aimed to obtain transcriptome maps of mammalian genomes in a comprehensive set of cellular states. In particular, human primary cells are of major focus since they have been poorly surveyed with genome-wide methods due to limitation of sample availabilities. The project has identified transcription start sites (TSSs) and measured TSS activities in a diverse range of samples (∼1800 for human and ∼1000 for mouse) using a CAGE method adapted to a single molecule sequencer (17). The analysis results in FANTOM5 range from genomic information, like the definition of TSS regions and their association with known genes (primary analysis), to higher-level analysis, including co-expression clustering of TSSs, statistical assessment of transcription-factor-binding-site motifs within CAGE peaks, samples, and enrichment analysis of pathways or samples. The selection of samples, which covers cell lines, tissues, and primary cells, provided a rich opportunity to explore transcriptome states encoded in the genome. In order to classify these samples, the FANTOM5 sample ontology (FF ontology) was developed consisting of multiple subclasses representing distinct aspects of the samples, such as cell types, anatomical tissues, and diseases (18). In handling these data sets, we faced two major challenges besides increasing data sizes: adaptation to new types of data being generated as research grows, and flexible representation of associations across heterogeneous data. Research activities generate novel ideas, which in turn generate new data. New data do not necessarily fit to existing data models, and its adaptation often requires schematic changes. In parallel to the schematic changes to the data model, visual representation has to be designed for manual inspection. Besides additional representation for newly produced data, its association has to be shown also in the representation of existing data. It requires incremental changes, which can be effectively assisted by flexibility in data representation.

Here, we present a web-based database called Semantic catalog of Samples, Transcription initiation And Regulators (SSTAR) as a platform to deliver FANTOM5 sample information and analysis results to the research community. We employed Semantic MediaWiki (SMW), the open source wiki engine developed for Wikipedia with extended capacity to store additional data (termed semantic properties) alongside wiki content (19). Queries on semantic properties, termed semantic query, improve upon traditional keyword search. The semantic query can be embedded in wiki pages to show the query result in-line with wiki context (termed in-line semantic query). We used semantic properties to adopt new data without destructive schematic change on existing data, and in-line semantic query for representations of data associations. We added several visual components for genomic view, quantitative value display, and ontology classes through development of our custom extension (SSTAR extension). In the course of the FANTOM5 project (17), several database systems have been developed, such as the ZENBU data visualization platform offering all functionalities of a genome browser with interactive operations (20), the FANTOM5 Table Extraction Tool enabling us efficiently to extract subsets of data from selected FANTOM5 data files, and a BioMart (21) instance enabling us to obtain subsets of FANTOM5 promoters and samples via a well-known interface. Although these systems are designed for specific data sets or functionalities, SSTAR is developed to support heterogeneous data, including novel type of data requiring complex associations across the heterogeneous data types. All of these systems are complementary, and several use cases are described in (18). For more information about FANTOM5 data, systems, publications and context, see http://fantom.gsc.riken.jp/5/.

Materials and Methods

Data sets in FANTOM5 SSTAR

SSTAR stores and manages two kinds of data sets: original (raw and processed) data generated by the FANTOM5 consortium and external data supporting interpretation of the FANTOM5 data (Figure 1). The original raw data set consists of sample RNA and sequencing library metadata in sample and data relationship format (SDRF), sequence data in the FASTQ format, genome mapping data in the BAM format and CTSS (CAGE tag starting site) profiles in the BED format. The raw data had been deposited to DDBJ DRA under accession number DRA000991, DRA001026, DRA001027, DRA001028, DRA001101, DRA002216, DRA002711, DRA002747, DRA002748 (17, 22).

SSTAR data model. SSTAR data model consists of six classes, those represents the main ‘categories’ in SMW. The oval represents a class and the kind of the data stored. Relationship between any two categories is represented as an arrow. The direction of the arrow indicates which of the two classes stores the relationship (indicated by the end of the arrow) as a class attribute. The head and color of the arrow indicates the type of relationship.
Figure 1.

SSTAR data model. SSTAR data model consists of six classes, those represents the main ‘categories’ in SMW. The oval represents a class and the kind of the data stored. Relationship between any two categories is represented as an arrow. The direction of the arrow indicates which of the two classes stores the relationship (indicated by the end of the arrow) as a class attribute. The head and color of the arrow indicates the type of relationship.

The original processed data contains a series of transcriptional initiation profiles based on the CAGE technology and the decomposition-based peak identification method (17). We used 201 802 and 158 966 robust CAGE peaks (>3 copies per TSS), as transcription initiation regions in human and mouse genomes, respectively. Individual CAGE peaks were associated with genes based on their genomic coordinates, and activity (or expression) levels of the CAGE peaks were quantified according to the read counts in the CAGE profiles by the FANTOM5 consortium. CAGE peaks with similar expression profiles were also grouped into gene co-expression modules by applying the Markov Cluster Algorithm (23) to the CAGE peak expression data set by the consortium. All the process data are available at FANTOM5 web site (http://fantom.gsc.riken.jp/5/datafiles/).

The FF ontology is composed of three ontologies: cell type ontology (CL), cross-species anatomical ontology (UBERON), and disease ontology. The FF ontology files are accessible from the GitHub repository (https://github.com/cmungall/fantom5-ontology) in Ontology Web Language (OWL) format.

Data sets from external sources include, but are not limited to, gene models retrieved from Entrez Gene in NCBI and information on reported motifs (DNA patterns bound by transcription factors) retrieved from JASPAR (24).

Data storage

The MediaWiki system stores the majority of data as Wiki markup text. It also supports a template scheme to specify presentation style. We used the template parameters to store data as semantic properties (see below), in addition to descriptive text (Figure 2A and B). The templates are used to specify a graphical layout and to set and query semantic properties. The process to generate semantic properties in a SWM system consists of two consecutive steps: (i) all data objects are imported as wiki markup (see ‘Data modeling and implementation of heterogeneous and complex biological states in SMW’ in the ‘Results and Discussion’ section), (ii) the imported markup text is then parsed by the SMW system to generate semantic properties.

Implementation scheme of data model with SMW template. (A) Template dependencies. Each page in SSTAR use one or more template from SMW, the template points to different style sheets, calls semantic property and SSTAR plug-ins to deliver particular function. (B) Data flow from depositing the data file in MediaWiki server to render the page into the client. (C) Code snippet showing template call (EntrezGene) with the semantic properties to generate the page with EntrezGene:4602 http://fantom.gsc.riken.jp/5/sstar/EntrezGene:4602. (D) Statements in the ‘EntrezGene’ template to store template parameters as semantic properties. The statements will add the semantic properties ‘GeneID’, ‘LocusTag’ and ‘type_of_gene’. (E) An example of inline semantic query, retrieving the association between two categories (gene and CAGE peaks) and show the result in an unnumbered list. (F) An example of the inline semantic query modified to call SSTAR ucsc_gb_link function to provide the genomic view of the FFCP in UCSC genome browser.
Figure 2.

Implementation scheme of data model with SMW template. (A) Template dependencies. Each page in SSTAR use one or more template from SMW, the template points to different style sheets, calls semantic property and SSTAR plug-ins to deliver particular function. (B) Data flow from depositing the data file in MediaWiki server to render the page into the client. (C) Code snippet showing template call (EntrezGene) with the semantic properties to generate the page with EntrezGene:4602 http://fantom.gsc.riken.jp/5/sstar/EntrezGene:4602. (D) Statements in the ‘EntrezGene’ template to store template parameters as semantic properties. The statements will add the semantic properties ‘GeneID’, ‘LocusTag’ and ‘type_of_gene’. (E) An example of inline semantic query, retrieving the association between two categories (gene and CAGE peaks) and show the result in an unnumbered list. (F) An example of the inline semantic query modified to call SSTAR ucsc_gb_link function to provide the genomic view of the FFCP in UCSC genome browser.

Interface to the end users

The SSTAR landing page summarizes the content of FANTOM5 data sets into categories: human data, mouse data, cross-species data and others (main menu and submenus are shown in Supplementary Figure S1).

In addition to the standard layouts in MediaWiki we enhanced the function of data tables in the SSTAR system to enable search, export, and data plotting using various JavaScript libraries. We further added components to support specific visualizations for the FANTOM5 data set such as a genomic view with UCSC genome browser (Figure 3A) and a tree view of the ontology structure with NCBO’s ontology visualization widget (http://www.bioontology.org/wiki/index.php/NCBO_Widgets#Ontology_visualization_widget; Supplementary Figure S2C). These functions are implemented as custom extensions to MediaWiki, which calls external services or API (Application Program Interface) provided outside of SSTAR.

Graphical representation of a gene (MYB). (A) Result of the search for MYB gene in SSTAR, with its associated Motifs and list of TSS regions. The user is able to get UCSC genome browser view of the MYB gene. (B) The table shows the expression of five TSS regions associated with MYB. (C) The graphical representation of the B) in which X-axis represents individual samples and y-axis represents expression intensities.
Figure 3.

Graphical representation of a gene (MYB). (A) Result of the search for MYB gene in SSTAR, with its associated Motifs and list of TSS regions. The user is able to get UCSC genome browser view of the MYB gene. (B) The table shows the expression of five TSS regions associated with MYB. (C) The graphical representation of the B) in which X-axis represents individual samples and y-axis represents expression intensities.

Performance testing

We measured the time to complete a user’s request, which consists of the time for the server to start its response (termed ‘latency’), and for a client to load, parse and render the data in a page (termed ‘loading and parsing’). We randomly selected 1% of the total number of the pages in each of the main categories (in Figure 1) to measure distribution of required time per page [4179 pages in total; see Supplementary Table S1 for a summary and the full list is available at our web site (http://fantom.gsc.riken.jp/5/suppl/Abugessaisa_et_al_2016/)]. We also evaluated the effect of server side memory caching (Memcached, http://www.mediawiki.org/wiki/Manual:Configuration_settings#Memcached_settings). The detailed description of the performance evaluation method is in the Supplementary Materials.

Results and Discussion

Data modeling and implementation of heterogeneous and complex biological states in SMW

We have six data classes corresponding to FANTOM5 data types (Figure 1): genes, TSS regions (CAGE peaks), co-expression modules of similarly activated TSS regions, samples, FF ontology terms, and motifs. The six classes are interconnected through different kinds of relationships: associations, annotations, clustering, expression and enrichment. The number of data objects in each class and their properties are summarized in Table 1.

Table 1.

Summary of the number of objects in SSTAR

Data class > CategoryAttributesData objects or attributes
humanmouse
TSS region > FFCPhuman readable description201 802158 966
association with genesa174 802136 492
co-expression modulea240 776180 000
CAGE expressiona201 802158 966
ontology-based sample term enrichment analysisa6 097 4092 843 664
Gene > EntrezGenehuman readable description408 504317 946
DNA-binding motifs (only for transcription factors)9188
association with TSS regions (CAGE peaks)+174 802136 492
Co-expression module> Coexpression_cluster, MCL_coexpression_mm9TSS region (CAGE peak) cluster+310278
pathway enrichment16721385
gene ontology enrichment48 47338 751
ENCODE TF ChIP-seq peak enrichment analysis (with Coexpression)29 778N/A
sample ontology enrichmenta224 85287 181
relative expression of the co-expression clustera889389
Sample > FF Samplehuman readable description18161 018
classification according to the sample ontology (‘Ancestor terms’)a34 68912 357
transcription factors with enriched expression983 000367 000
co-expression clusters with enriched expression300 79881 474
repeat families with enriched expression130 78934 865
overrepresented JASPAR motifs112112
overrepresented novel unique motifs169168
Homer de novo motifs39 32014 680
Sample ontology > FF ontologydescription3782
parent terms9640
children terms9620
Motifs > JASPER_motif, Novel_motifhuman readable description687
association to promoter expressiona1278
Data class > CategoryAttributesData objects or attributes
humanmouse
TSS region > FFCPhuman readable description201 802158 966
association with genesa174 802136 492
co-expression modulea240 776180 000
CAGE expressiona201 802158 966
ontology-based sample term enrichment analysisa6 097 4092 843 664
Gene > EntrezGenehuman readable description408 504317 946
DNA-binding motifs (only for transcription factors)9188
association with TSS regions (CAGE peaks)+174 802136 492
Co-expression module> Coexpression_cluster, MCL_coexpression_mm9TSS region (CAGE peak) cluster+310278
pathway enrichment16721385
gene ontology enrichment48 47338 751
ENCODE TF ChIP-seq peak enrichment analysis (with Coexpression)29 778N/A
sample ontology enrichmenta224 85287 181
relative expression of the co-expression clustera889389
Sample > FF Samplehuman readable description18161 018
classification according to the sample ontology (‘Ancestor terms’)a34 68912 357
transcription factors with enriched expression983 000367 000
co-expression clusters with enriched expression300 79881 474
repeat families with enriched expression130 78934 865
overrepresented JASPAR motifs112112
overrepresented novel unique motifs169168
Homer de novo motifs39 32014 680
Sample ontology > FF ontologydescription3782
parent terms9640
children terms9620
Motifs > JASPER_motif, Novel_motifhuman readable description687
association to promoter expressiona1278

SSTAR data objects and their corresponding categories in MediaWiki and the attributes in each object. Relationship to other objects are indicated with a (*:forward and +reverse).

Table 1.

Summary of the number of objects in SSTAR

Data class > CategoryAttributesData objects or attributes
humanmouse
TSS region > FFCPhuman readable description201 802158 966
association with genesa174 802136 492
co-expression modulea240 776180 000
CAGE expressiona201 802158 966
ontology-based sample term enrichment analysisa6 097 4092 843 664
Gene > EntrezGenehuman readable description408 504317 946
DNA-binding motifs (only for transcription factors)9188
association with TSS regions (CAGE peaks)+174 802136 492
Co-expression module> Coexpression_cluster, MCL_coexpression_mm9TSS region (CAGE peak) cluster+310278
pathway enrichment16721385
gene ontology enrichment48 47338 751
ENCODE TF ChIP-seq peak enrichment analysis (with Coexpression)29 778N/A
sample ontology enrichmenta224 85287 181
relative expression of the co-expression clustera889389
Sample > FF Samplehuman readable description18161 018
classification according to the sample ontology (‘Ancestor terms’)a34 68912 357
transcription factors with enriched expression983 000367 000
co-expression clusters with enriched expression300 79881 474
repeat families with enriched expression130 78934 865
overrepresented JASPAR motifs112112
overrepresented novel unique motifs169168
Homer de novo motifs39 32014 680
Sample ontology > FF ontologydescription3782
parent terms9640
children terms9620
Motifs > JASPER_motif, Novel_motifhuman readable description687
association to promoter expressiona1278
Data class > CategoryAttributesData objects or attributes
humanmouse
TSS region > FFCPhuman readable description201 802158 966
association with genesa174 802136 492
co-expression modulea240 776180 000
CAGE expressiona201 802158 966
ontology-based sample term enrichment analysisa6 097 4092 843 664
Gene > EntrezGenehuman readable description408 504317 946
DNA-binding motifs (only for transcription factors)9188
association with TSS regions (CAGE peaks)+174 802136 492
Co-expression module> Coexpression_cluster, MCL_coexpression_mm9TSS region (CAGE peak) cluster+310278
pathway enrichment16721385
gene ontology enrichment48 47338 751
ENCODE TF ChIP-seq peak enrichment analysis (with Coexpression)29 778N/A
sample ontology enrichmenta224 85287 181
relative expression of the co-expression clustera889389
Sample > FF Samplehuman readable description18161 018
classification according to the sample ontology (‘Ancestor terms’)a34 68912 357
transcription factors with enriched expression983 000367 000
co-expression clusters with enriched expression300 79881 474
repeat families with enriched expression130 78934 865
overrepresented JASPAR motifs112112
overrepresented novel unique motifs169168
Homer de novo motifs39 32014 680
Sample ontology > FF ontologydescription3782
parent terms9640
children terms9620
Motifs > JASPER_motif, Novel_motifhuman readable description687
association to promoter expressiona1278

SSTAR data objects and their corresponding categories in MediaWiki and the attributes in each object. Relationship to other objects are indicated with a (*:forward and +reverse).

In our implementation we used the MediaWiki concepts of ‘category’, ‘page’ and ‘template parameter’ for data class, data object, and object attributes respectively. The attributes were handled as semantic properties (Table 2). Figure 2A and B shows our scheme of storing object attributes as template parameters, and subsequently as semantic properties. Figure 2C–E illustrates individual steps to store and retrieve attributes based on a gene MYB as an example. Attributes of the gene are described as parameters of a template ‘EntrezGene’ in a page of ‘Gene’ category (Figure 2C), and passed to semantic properties using the no. set function within the template (Figure 2D). The properties can be retrieved by using a semantic query (Figure 2E).

Table 2.

Mapping of the modeling entities in SSTAR

Modeling entitiesMediaWikiSMW
ClassCategory
ObjectPage
AttributesTemplate parametersSemantic properties
Modeling entitiesMediaWikiSMW
ClassCategory
ObjectPage
AttributesTemplate parametersSemantic properties

Data objects and their relationships ; the table show the mapping between the data model (column 1), MediaWiki(column 2) and the SMW (column 3).

Table 2.

Mapping of the modeling entities in SSTAR

Modeling entitiesMediaWikiSMW
ClassCategory
ObjectPage
AttributesTemplate parametersSemantic properties
Modeling entitiesMediaWikiSMW
ClassCategory
ObjectPage
AttributesTemplate parametersSemantic properties

Data objects and their relationships ; the table show the mapping between the data model (column 1), MediaWiki(column 2) and the SMW (column 3).

Associations between data objects (pages) are essential to represent the data models as well as to navigate across multiple pages. We stored these associations as semantic properties. While they are stored in only one of the data objects (pages), they can be retrieved immediately in the other object by using semantic queries (Figure 2E). For example, when one gene is activated by multiple promoters it can be associated with multiple CAGE peaks. The number of associated CAGE peaks is dependent on how complex the regulation is that drives the gene. Although we stored associations between gene and CAGE peaks in the ‘CAGE peak’ pages only, we can show ‘associated CAGE peaks’ by writing an inline semantic query (Figure 2E) in “gene” pages (Figure 3A, TSS regions section). This structure was used for all associations illustrated in Figure 1. Semantic queries are not limited for use within SSTAR. Users and external programs can access SSTAR semantic properties by accessing the semantic query interface (http://fantom.gsc.riken.jp/5/sstar/Special:Ask).

Evolution of views

We configured all pages based on the templates as described, and the templates are shared among pages to provide consistent interfaces for data objects in the same class. A template is simply an editable page equivalent to other wiki pages. All of its contents, including presented data, semantic query and graphical layout, can be updated rapidly as research activities move forward.

For example, in the FANTOM5 project, many data sets are usually presented as a table. Many pages display one or multiple data tables. A gene page, e.g. displays an expression table of CAGE peaks associated with the gene, whereas a sample page displays tables of highly expressed CAGE peaks of transcription factors in the sample, co-expressed clusters with enriched expression in the sample, known TFBS (DNA) motifs significantly associated with promoter activities, and novel TFBS motifs discovered in the proximal region of promoters active in this sample. We initially provided these data sets as simple tables; however, it became inefficient for investigators to inspect a fixed table consisting of hundreds of rows without an interactive interface. In order to improve navigation of data tables in SSTAR, we employed a JavaScript module (FLOT, http://www.flotcharts.org/) that enables dynamic operations on the tables (Figure 3B and C and Supplementary Figure S3). The table in Figure 3B shows activities (expressions) of five TSS regions associated with MYB, in individual samples, and Figure 3C is its graphical representation, where the x-axis represents individual samples and the y-axis represents expression intensities of TSS regions (represented by different colors). The table is sortable and linked with the graphical representation, such that when users modify the sort order, changes are immediately reflected in the visualization. Furthermore, when a user clicks a point in the chart, its corresponding CAGE peak is indicated in the table. This enhancement is implemented by modification of the template page, which demonstrates that the SMW framework allowed us to evolve the page layout the needs of researchers’ progress.

Development of extensions to enhance the visual interface

In most cases we did not need to modify the source code of MediaWiki or SMW to develop visual components. Simply modifying the templates as described in the previous section was sufficient. In a limited number of cases, such as to make use of external web services, it was necessary to create SMW extensions (The PHP code of the extensions are available at our web site, http://fantom.gsc.riken.jp/5/suppl/Abugessaisa_et_al_2016/).

One of the extensions we developed embeds a genomic view provided in UCSC Genome Browser (Figure 3A). By calling the extension from the CAGE peak or the EntrezGene template (Figure 2F), SSTAR displays the genomic view in CAGE peak or EntrezGene page. Using this view investigators are able to compare CAGE peaks identified in FANTOM5 with existing genome annotations such as gene models and ENCODE results. Another example is the representation of FF ontology terms. In the T cell (CL: 0000084) term page, e.g. parental terms, such as lymphocyte (CL: 0000542), were shown as text, as in Supplementary Figure S2A. We implemented an MediaWiki extension for an interactive ontology visualization that shows ascendant/descendant ontology terms (Supplementary Figure S2B) by embedding the NCBO’s ontology visualization widget (provided via web services) (Supplementary Figure S2C).

Data export for genomic data in standard formats

Query tools provide a way to select subsets of the data stored in SSTAR according to specified criteria (biological or statistical), allowing researchers to inspect or download the results for further analysis. Three formats—Resource Description Framework (RDF)/XML, JavaScript Object Notation, and comma-separated values (CSV) plain text—are natively supported by SMW. In particular, the columns in the CSV output can be specified either in the query interface or as parameters of the API. Many file formats in biology are based on tab delimitation (e.g. BED, GFF, SDRF etc.), which is just a variation of the CSV export. Therefore, we extended the system to export query results in a tab-separated values (TSVs) format.

MAGE-tab (25) and ISA-tab (26) are accepted as standard formats for metadata describing experiments in functional genomics and other ‘–omics’ research. Both of them employ SDRF, which requires a specific structure within TSV-formatted files. The TSV export, having flexible columns order, makes it possible to generate sample information in these standard formats. Supplementary Figure S4 shows an example of FANTOM5 metadata, with primary name in the ‘source name’ columns and the other attributes in ‘Characteristics […]’ columns, stored as different properties such as ‘Name’ and ‘Sample species’. We implemented a SSTAR extension for downloading search results in TSV, and we embedded download links in pages for specific tables such as CAGE peaks, FF ontology terms, and samples.

Performance evaluation

We assessed the performance of SSTAR on the server side and the client side depending on each category of data. Performance varied depending on the page category, with typical durations of less than one second for gene pages and nearly five seconds for sample pages (Figure 4) without memory caching. Use of a memory cache improved the server processing time more than tenfold (i.e. 0.1 s for all page categories; see Figure 4. The durations required on the client side also differ depending on page categories (Figure 4). Detailed results of the performance evaluation are included in the Supplementary Data.

Measurements of page-timing. x-axis shows FANTOM5 categories and the y-axis is the different timing in seconds. Memcached ON and OFF, for the six categories: n = 87, n = 1003, n = 3011, n = 52, n = 16 and n = 10 . The box denotes the median. The bars on each column show the 25 and 75 percentiles. Latency time changed drastically between cache-on and cache-off. No change in the loading and parsing time and rendering time for all categories.
Figure 4.

Measurements of page-timing. x-axis shows FANTOM5 categories and the y-axis is the different timing in seconds. Memcached ON and OFF, for the six categories: n = 87, n = 1003, n = 3011, n = 52, n = 16 and n = 10 . The box denotes the median. The bars on each column show the 25 and 75 percentiles. Latency time changed drastically between cache-on and cache-off. No change in the loading and parsing time and rendering time for all categories.

Comparison to other SMW/MediaWiki-based database systems

SSTAR is not the first application based on SMW in the field of biology. We compared it with other systems using SMW, such as SNPedia (27) and SEQanswer (28) wiki. The statistics summarized in Tables 3 and 4 indicate that SSTAR stores the largest number of pages and semantic properties, with >400 000 pages and >50 000 000 semantic properties, which is four to five times more than the largest database we examined (Pest Information Wiki; http://wiki.pestinfo.org/).

Table 3.

Number of semantic property values

CategorySemantic property vlaues
Cell ontology646
Coexpression clusters4882
EntrezGene100286
FFCP721537
FF ontology5149
FF samples3605
FF terms1544
Human disease ontoloy260
JASPAR motif113
MCL coexpression mm93771
MacroAPE 10831080
Motif691
MotifCluster204
NonRedundantMotifCluster210
Novel motif170
SwissregulonMotif198
Time courses36
Uber anatomy ontology1354
CategorySemantic property vlaues
Cell ontology646
Coexpression clusters4882
EntrezGene100286
FFCP721537
FF ontology5149
FF samples3605
FF terms1544
Human disease ontoloy260
JASPAR motif113
MCL coexpression mm93771
MacroAPE 10831080
Motif691
MotifCluster204
NonRedundantMotifCluster210
Novel motif170
SwissregulonMotif198
Time courses36
Uber anatomy ontology1354

The table shows categories and their corrsponding semantic property values in SSTAR.

Table 3.

Number of semantic property values

CategorySemantic property vlaues
Cell ontology646
Coexpression clusters4882
EntrezGene100286
FFCP721537
FF ontology5149
FF samples3605
FF terms1544
Human disease ontoloy260
JASPAR motif113
MCL coexpression mm93771
MacroAPE 10831080
Motif691
MotifCluster204
NonRedundantMotifCluster210
Novel motif170
SwissregulonMotif198
Time courses36
Uber anatomy ontology1354
CategorySemantic property vlaues
Cell ontology646
Coexpression clusters4882
EntrezGene100286
FFCP721537
FF ontology5149
FF samples3605
FF terms1544
Human disease ontoloy260
JASPAR motif113
MCL coexpression mm93771
MacroAPE 10831080
Motif691
MotifCluster204
NonRedundantMotifCluster210
Novel motif170
SwissregulonMotif198
Time courses36
Uber anatomy ontology1354

The table shows categories and their corrsponding semantic property values in SSTAR.

Table 4.

Comparison between SSTAR and other systems using SMW / MediaWiki

SystemURLpagesNumber of semantic propertiesSemantic property values
FANTOM5 SSTARhttp://fantom.gsc.riken.jp/5/sstar/415 67619654 266 939
ArthropodBase Wikihttp://arthropodgenomes.org/wiki/990217167 407
Bioinformatics.Orghttp://www.bioinformatics.org/wiki/2378855898
GeneWiki+http://genewikiplus.org/wiki/91 3792451 978 820
GMODhttp://gmod.org/3873549 580
MetaBasehttp://MetaDatabase.Org/46183113 286
NeuroLexhttp://neurolex.org/76 374198546 389
OpenToxipediahttp://www.opentoxipedia.org/128084329
Pest information Wikihttp://wiki.pestinfo.org/wiki/134 9154110 474 99
SNPediahttp://snpedia.com/111 0521034 313 629
SEQanswers wikihttp://SEQanswers.com/wiki/333811036 623
SystemURLpagesNumber of semantic propertiesSemantic property values
FANTOM5 SSTARhttp://fantom.gsc.riken.jp/5/sstar/415 67619654 266 939
ArthropodBase Wikihttp://arthropodgenomes.org/wiki/990217167 407
Bioinformatics.Orghttp://www.bioinformatics.org/wiki/2378855898
GeneWiki+http://genewikiplus.org/wiki/91 3792451 978 820
GMODhttp://gmod.org/3873549 580
MetaBasehttp://MetaDatabase.Org/46183113 286
NeuroLexhttp://neurolex.org/76 374198546 389
OpenToxipediahttp://www.opentoxipedia.org/128084329
Pest information Wikihttp://wiki.pestinfo.org/wiki/134 9154110 474 99
SNPediahttp://snpedia.com/111 0521034 313 629
SEQanswers wikihttp://SEQanswers.com/wiki/333811036 623

The number of pages and semantic properties the statistics were collected on the 17 February 2015.

Table 4.

Comparison between SSTAR and other systems using SMW / MediaWiki

SystemURLpagesNumber of semantic propertiesSemantic property values
FANTOM5 SSTARhttp://fantom.gsc.riken.jp/5/sstar/415 67619654 266 939
ArthropodBase Wikihttp://arthropodgenomes.org/wiki/990217167 407
Bioinformatics.Orghttp://www.bioinformatics.org/wiki/2378855898
GeneWiki+http://genewikiplus.org/wiki/91 3792451 978 820
GMODhttp://gmod.org/3873549 580
MetaBasehttp://MetaDatabase.Org/46183113 286
NeuroLexhttp://neurolex.org/76 374198546 389
OpenToxipediahttp://www.opentoxipedia.org/128084329
Pest information Wikihttp://wiki.pestinfo.org/wiki/134 9154110 474 99
SNPediahttp://snpedia.com/111 0521034 313 629
SEQanswers wikihttp://SEQanswers.com/wiki/333811036 623
SystemURLpagesNumber of semantic propertiesSemantic property values
FANTOM5 SSTARhttp://fantom.gsc.riken.jp/5/sstar/415 67619654 266 939
ArthropodBase Wikihttp://arthropodgenomes.org/wiki/990217167 407
Bioinformatics.Orghttp://www.bioinformatics.org/wiki/2378855898
GeneWiki+http://genewikiplus.org/wiki/91 3792451 978 820
GMODhttp://gmod.org/3873549 580
MetaBasehttp://MetaDatabase.Org/46183113 286
NeuroLexhttp://neurolex.org/76 374198546 389
OpenToxipediahttp://www.opentoxipedia.org/128084329
Pest information Wikihttp://wiki.pestinfo.org/wiki/134 9154110 474 99
SNPediahttp://snpedia.com/111 0521034 313 629
SEQanswers wikihttp://SEQanswers.com/wiki/333811036 623

The number of pages and semantic properties the statistics were collected on the 17 February 2015.

Conclusion

We discussed the development of SSTAR for the FANTOM5 project. SSTAR facilitates managing and publishing of large sets of biological and genomic data and remains adaptable to the changing needs of ongoing research activities. The system allows investigators with different backgrounds to explore the FANTOM5 heterogeneous resource. This approach has been effective for our ongoing and large-scale research project, where novel analysis strategies and findings have been be provided as research progressed. We were able to expand functionalities, such as enhancement of graphical representation and management of data for genomic standards, by developing small extensions without building, testing, debugging an entirely new system from scratch. We also examined the scalability of the system and found that a large number of properties can be handled in an acceptable response time. This suggests that the framework is applicable even when working with data larger than the existing biological databases that rely on SMW. To conclude, the MediaWiki/SMW framework has enabled us to overcome the challenges we experienced to create a scalable system with the capabilities to handle FANTOM5 data sets and the associated analysis results. Other biological database developers could also implement their own database with SMW, storing their data as wiki texts in the system with flexible adaptation of graphical components in a flexible ‘wiki’ manner and extension systems. Our use case in this report delineated successful design principles and configurations as well as the scalability required for genomic research.

Availability

FANTOM5 SSTAR database system is accessible from

(i) http://fantom.gsc.riken.jp/5/sstar/

(ii) The PHP code for the SSTAR extensions, and supplemental data about our performance evaluations are available at our web site, http://fantom.gsc.riken.jp/5/suppl/Abugessaisa_et_al_2016/.

Acknowledgements

We would like to thank Chris Mungall for support with the FF ontology, and all members of FANTOM5 consortium for contributing to generation of samples and analysis of the data-set and thank GeNAS for data production.

Funding

FANTOM5 was made possible by a Research Grant for RIKEN Omics Science Center from MEXT to Yoshihide Hayashizaki and a Grant of the Innovative Cell Biology by Innovative Technology (Cell Innovation Program) from the MEXT, Japan to Yoshihide Hayashizaki and to the RIKEN Center for Life Science Technologies. This study is also supported by Research Grants from the Japanese Ministry of Education, Culture, Sports, Science and Technology through RIKEN Preventive Medicine and Diagnosis Innovation Program to Y. Hayashizaki and RIKEN Centre for Life Science, Division of Genomic Technologies to P. Carninci.

Conflict of interest. None declared.

References

1

Metzker
M.L.
(
2010
)
Sequencing technologies - the next generation
.
Nat. Rev. Genet
.,
11
,
31
46
.

2

Kawamoto
S.
Yoshii
J.
Mizuno
K.
et al. . (
2000
)
BodyMap: a collection of 3' ESTs for analysis of human gene expression information
.
Genome Res
.,
10
,
1817
1827
.

3

Kawai
J.
Shinagawa
A.
Shibata
K.
et al. . (
2001
)
Functional annotation of a full-length mouse cDNA collection
.
Nature
,
409
,
685
690
.

4

Okazaki
Y.
Furuno
M.
Kasukawa
T.
et al. . (
2002
)
Analysis of the mouse transcriptome based on functional annotation of 60,770 full-length cDNAs
.
Nature
,
420
,
563
573
.

5

Su
A.I.
Wiltshire
T.
Batalov
S.
et al. . (
2004
)
A gene atlas of the mouse and human protein-encoding transcriptomes
.
Proc. Natl. Acad. Sci. U S A
,
101
,
6062
6067
.

6

Cloonan
N.
Forrest
A.R.
Kolle
G.
et al. . (
2008
)
Stem cell transcriptome profiling via massive-scale mRNA sequencing
.
Nat. Methods
,
5
,
613
619
.

7

Kanamori-Katayama
M.
Itoh
M.
Kawaji
H.
et al. . (
2011
)
Unamplified cap analysis of gene expression on a single-molecule sequencer
.
Genome Res
.,
21
,
1150
1159
.

8

Nakamura
Y.
Cochrane
G.
Karsch-Mizrachi
I.
International Nucleotide Sequence Database,C
. (
2013
)
The International Nucleotide Sequence Database Collaboration
.
Nucleic Acids Res.
,
41
,
D21
D24
.

9

Barrett
T.
Wilhite
S.E.
Ledoux
P.
et al. . (
2013
)
NCBI GEO: archive for functional genomics data sets–update
.
Nucleic Acids Res
.,
41
,
D991
D995
.

10

Kolesnikov
N.
Hastings
E.
Keays
M.
et al. . (
2015
)
ArrayExpress update–simplifying data submissions
.
Nucleic Acids Res
.,
43
,
D1113
D1116
.

11

Kodama
Y.
Kaminuma
E.
Saruhashi
S.
et al. . (
2010
)
Biological databases at DNA Data Bank of Japan in the era of next-generation sequencing technologies
.
Adv. Exp. Med. Biol
.,
680
,
125
135
.

12

Kapushesky
M.
Adamusiak
T.
Burdett
T.
et al. . (
2012
)
Gene Expression Atlas update–a value-added database of microarray and sequencing-based functional genomics experiments
.
Nucleic Acids Res
.,
40
,
D1077
D1081
.

13

Wu
C.
Orozco
C.
Boyer
J.
et al. . (
2009
)
BioGPS: an extensible and customizable portal for querying and organizing gene annotation resources
.
Genome Biol
.,
10
,
R130.

14

Kent
W.J.
Sugnet
C.W.
Furey
T.S.
et al. . (
2002
)
The human genome browser at UCSC
.
Genome Res
.,
12
,
996
1006
.

15

Kawaji
H.
Kasukawa
T.
Fukuda
S.
et al. . (
2006
)
CAGE Basic/Analysis Databases: the CAGE resource for comprehensive promoter analysis
.
Nucleic Acids Res
.,
34
,
D632
D636
.

16

Kawaji
H.
Severin
J.
Lizio
M.
et al. . (
2009
)
The FANTOM web resource: from mammalian transcriptional landscape to its dynamic regulation
.
Genome Biol
.,
10
,
R40.

17

Forrest
A.R.
Kawaji
H.
Rehli
M.
et al. . (
2014
)
A promoter-level mammalian expression atlas
.
Nature
,
507
,
462
470
.

18

Lizio
M.
Harshbarger
J.
Shimoji
H.
et al. . (
2015
)
Gateways to the FANTOM5 promoter level mammalian expression atlas
.
Genome Biol
.,
16
,
22.

19

Krötzsch
M.
Vrandečić
D.
Völkel
M.
(
2006
) Semantic MediaWiki. In:
Cruz
I
Decker
S
Allemang
D
Preist
C
Schwabe
D
Mika
P.
et al. . (eds).
The Semantic Web - ISWC 2006. Lecture Notes in Computer Science. 4273
:
Springer
Berlin Heidelberg
. pp.
935
9–9342
.

20

Severin
J.
Lizio
M.
Harshbarger
J.
et al. . (
2014
)
Interactive visualization and analysis of large-scale sequencing datasets using ZENBU
.
Nat. Biotechnol
.,
32
,
217
219
.

21

Smedley
D.
Haider
S.
Durinck
S.
et al. . (
2015
)
The BioMart community portal: an innovative alternative to large, centralized data repositories
.
Nucleic Acids Res
.,
43
,
W589
W598
.

22

Arner
E.
Daub
C.O.
Vitting-Seerup
K.
et al. . (
2015
)
Transcribed enhancers lead waves of coordinated transcription in transitioning mammalian cells
.
Science
,
347
,
1010
1014
.

23

Freeman
T.C.
Goldovsky
L.
Brosch
M.
et al. . (
2007
)
Construction, visualisation, and clustering of transcription networks from microarray expression data
.
PLoS Comput. Biol
.,
3
,
2032
2042
.

24

Mathelier
A.
Zhao
X.
Zhang
A.W.
et al. . (
2014
)
JASPAR 2014: an extensively expanded and updated open-access database of transcription factor binding profiles
.
Nucleic Acids Res
.,
42
,
D142
D147
.

25

Rayner
T.F.
Rocca-Serra
P.
Spellman
P.T.
et al. . (
2006
)
A simple spreadsheet-based, MIAME-supportive format for microarray data: MAGE-TAB
.
BMC Bioinformatics
,
7
,
489.

26

Sansone
S.A.
Rocca-Serra
P.
Field
D.
et al. . (
2012
)
Toward interoperable bioscience data
.
Nat. Genet
.,
44
,
121
126
.

27

Cariaso
M.
Lennon
G.
(
2012
)
SNPedia: a wiki supporting personal genome annotation, interpretation and analysis
.
Nucleic Acids Res
.,
40
,
D1308
D1312
.

28

Li
J.W.
Robison
K.
Martin
M.
et al. . (
2012
)
The SEQanswers wiki: a wiki database of tools for high-throughput sequencing analysis
.
Nucleic Acids Res
.,
40
,
D1313
D1317
.

Author notes

These authors contributed equally to this work.

RIKEN Omics Science Center ceased to exist as of April 1st, 2013, due to RIKEN reorganization

Citation details: Abugessaisa,I., Shimoji,H., Sahin,S. et al. FANTOM5 transcriptome catalog of cellular states based on semantic MediaWiki. Database (2016) Vol. 2016: article ID baw105; doi:10.1093/database/baw105

This is an Open Access article distributed under the terms of the Creative Commons Attribution License (http://creativecommons.org/licenses/by/4.0/), which permits unrestricted reuse, distribution, and reproduction in any medium, provided the original work is properly cited.

Supplementary data