T-ACE

T-ACE: Transcriptome Analysis and Comparison Explorer

Background

T-ACE was developed for the analysis and organization of transcriptome projects but is also helpful for the organization of small sequence datasets e.g. extracts of a large transcriptome databases. T-ACE does not provide an assembly function, thus data gained by NGS projects (e.g. 454, Illumina, SoliD) have to be assembled prior to the upload (e.g. using Newbler, Celera or TGICL). For transcriptome comparisons T-ACE was designed to work with a dataset composed of several transcriptomes of different treatments or tissues, which are assembled into a consensus transcriptome. Subsequently reads of the different transcriptomes are again mapped against the consensus transcriptome for information of transcriptome expression pattern i.e. number of reads per specific contig.

Setting up a T-­ACE Client

If there is already a running T-ACE database server, there is not much to do to set up a T-ACE client. At first TCL/TK 8.5.10.1 or higher should be installed. The easiest way to do this is to use an ActiveState package; it contains already most necessary additional TCL packages. The additional packages are listed in the Required Software section below.
When TCL is installed, just download T-ACE from this website and extract it to any convenient directory. Then just double-click on the T-ACE.tcl file in the T-ACE folder and the client interface should open.
To set up the connection to the T-ACE database server open the 'Database connection' in the config menu.
It is also recommended to install additional software like NCBI-Blast+, Phobos and Primer3; otherwise some T-ACE features will not be working. Look in T-ACE manual or the Additional software section below for specifications.
 

Setting up a T­ACE database server

To set up a T-ACE database server a PostgreSQL server is necessary. The additional software pgAdmin3 should also be installed for an easier handling of the Postgres database. For the functions used in T-ACE parent database the additional module 'postgresql-pltcl-8.3' is needed.
After the installation of the PostgreSQL server some configurations have to be made:

Resetting the password of the postgresuser:

sudo su postgres -c psql template1
template1=# ALTER USER postgres WITH PASSWORD 'password';
template1=# \q

Then it is necessary to change some lines in the 'postgresql.conf':

#listen_addresses = 'localhost'
to
listen_addresses = '*'

#password_encryption = on
to
password_encryption = on

The 'pg_hba.conf' file should be edited to use md5 for password checks.
If T-ACEpg is used for non-local access the following line should be added:

# IPv6 local connections:

# TYPE DATABASE USER CIDR-ADDRESS METHOD
Host tace_parentdb tace_user 0.0.0.0/0 md5


This would allow the user 'tace_user' to access the database 'tace_parentdb' from anywhere in the internet. Change the CIDR-ADDRESS to limit the access further.
The normal T-ACE version accesses the Postgres database via a php script; this means it is not necessary to make the Postgres server accessible for external IP-addresses.

Now the server has to be restarted:

sudo /etc/init.d/postgresql-8.4 restart


Then an Apache web server is needed to allow external T-ACE clients the access to the Postgres database. An external T-ACE client will access the Postgres database through a php script which runs on the Apache server, so make sure that php scripts can be executed correctly on the server.
Now TCL/TK and T-ACE can be installed. For configuring a 'tace_parentdb' the additional TCL package 'Pgtcl' is needed, otherwise the T-ACE_DB_manager cannot be used.
When T-ACE is extracted, copy the T-ACE.php into the /htdocs folder of the Apache web server. To set up the T-ACE parent database, functions and login roles follow the instructions in the T- ACE_DB_manager. When this is done the first T-ACE transcriptome database can be created, for this look here.
Additionally wwwblast should be installed on an apache server, but it does not need to run on the same machine as the Postgres server. Then blast databases of the T-ACE databases have to be copied to the /db directory of blast server and added to the blast.rc file, otherwise the blast function of T- ACE will not work.
 

Downloads:

T-ACE software

T-ACE_v1.9.5.zip for Windows/Linux/MacOS ...
T-ACE_v1.9.4.zip for Windows/Linux/MacOS ...
T-ACE_v1.9.3.zip for Windows/Linux/MacOS ...
T-ACE_v1.9.2.zip for Windows/Linux/MacOS ...
T-ACE_v1.9.1.zip for Windows/Linux/MacOS ...
T-ACEpg_v1.8.zip for Windows/Linux/MacOS ...

 

T-ACE references

T-ACE reference sql files for upload to the T-ACE parent database.
The files contain data for the respective refdb schema table. For example the 'T-ACE_refDB_blastprodom.sql' contains the prodom IDs and descriptions, the 'T-ACE_refDB_interpro2go.sql' contains the interpro to GO relations.
The 'T-ACE_refDB_all.sql' contains data of all other reference files in this list. If you download the 'T-ACE_refDB_all.sql' you don't have to download any other reference file.

The reference files on this page won't contain always the newest reference lists, so you may use the T-ACE_DB_manager to upload the newest reference files. In the T-ACE manual you will find links to the reference download webpages.
To upload a sql to the PostgreSQL server file extract the file and use:

  • psql -h [server host] -U [user name] [name of T-ACE parentDB] < [name of SQL file].sql


 

Download md5sum
T-ACE_refDB_all.sql.zip (449M) 15a2a58a8432a9f0da1918fb238aab4f
T-ACE_refDB_blastprodom.sql.zip (6.6K) f9501214c06de7fe82d3ae40900c5f05
T-ACE_refDB_gene3d.sql.zip (47K) a2413e251ab816a1709ac14120b5b9da
T-ACE_refDB_go.sql.zip (1.7M) 70f8553f0a42f3e96ca4ef60a8482953
T-ACE_refDB_gotree.sql.zip (1.5M) d8e138bfb2ccf8757d0416454e45c63e
T-ACE_refDB_interpro.sql.zip (236K) 76be65ac29ba7eae66efbf133360bff6
T-ACE_refDB_interpro2domain.sql.zip (142K) ea7d4fcb4fda39c19a90f80b389b0a6a
T-ACE_refDB_interpro2go.sql.zip (90K) cf68b657b25ec4e0967725cd52938e3e
T-ACE_refDB_interpro2protein.sql.zip (288M) b5b91f03f6dbf36130fc58067a93682d
T-ACE_refDB_kegg.sql.zip (188K) 50152eaf55d6b55dfc6b9707f1ede359
T-ACE_refDB_kegg2go.sql.zip (15k) 787a783a4def30acb46616771622c1ac
T-ACE_refDB_kegg2protein.sql.zip (16M) 2554f1823b1d1909a45ad67060de9870
T-ACE_refDB_kegg_maps.sql.zip (98K) cd1a688a6ae172deba18cb82c9be496a
T-ACE_refDB_nr.sql.zip (11M) 33bf9a7f3d1a0c6d5c22de8e0483732a
T-ACE_refDB_nt.sql.zip (7.4M) e38508d9b4936114cfaee795a0ead986
T-ACE_refDB_panther.sql.zip (122K) 502dd31c8f6a302ef1346db2767a2088
T-ACE_refDB_patternscan.sql.zip (5.9K) 1c3ce7e38d6052ee7acf24290572a8fd
T-ACE_refDB_pfam.sql.zip (30K) 1dc29be49c4b25e6a4d70961e3e1ef75
T-ACE_refDB_pir.sql.zip (5.7K) 233fa2b7852174fc227f90337106501b
T-ACE_refDB_profilescan.sql.zip (4.4K) 27a26dedde4da4520a7acaa2e34da2f1
T-ACE_refDB_smart.sql.zip (17K) a62be46bfbb04cecd216d8b4ddc79fde
T-ACE_refDB_superfamily.sql.zip (14K) 53df202d223bbfffba5b36df4db04afe
T-ACE_refDB_tigr.sql.zip (7.7K) a7765ebdab08e57f8e7a18303f6a69b5
T-ACE_refDB_uniprot_sprot.sql.zip (9.8M) 1308957b16e00f0af8306caf8b770888
T-ACE_refDB_uniref100.sql.zip (114M) 08c67a9b6dda1397d8cc2562fbd53de9


T-ACE Demo

To test T-ACE it is not necessary to set up a PostgreSQL server and install the T-ACE parent database and the example databases. A webserver is available, where T-ACE can be tested. To test T-ACE only TCL and the T-ACE client have to be installed.
To access the server use the following database connection settings (see 'Config'-menu -> 'Database connection' in the the T-ACE client) or download the 'T-ACE.conf' file below copy it to the T-ACE/conf folder.
See also Tutorial 1.

Database connection:

Host: 178.77.99.132
Port: 5432
Parent DB: transcriptomes

Server autdentification

Folder: tace
User: testuser
Password: T-ACE


Blast parameters:

URL: https://178.77.99.132/blast2/blast.cgi


Login parameters:

User: testuser
Password: test123



If a local installation is preferred, it is necessary to upload the T-ACE_refDB_all.sql to the refdb schema of the T-ACE parent database, otherwise the description of annotations in the example databases will not be available.

T-ACE example databases

Sabella spallanzanii database:

S. spallanzanii individuals were sampled in May 2009 from Moulin Blanc harbor (Brest, France) by staff of the Station Biologique (Roscoff, France), stored in RNAlater and send to the Institute of Clinical Molecular Biology (Kiel, Germany). A single individual was taken from the RNAlater, dissected and the fan tissue removed, blotted dry and frozen in liquid nitrogen for further processing. Frozen tissue was ground in liquid nitrogen and total RNA extracted using the Qiagen RNeasy kit in combination with the QiaShredder from Qiagen (Hilden, Germany). mRNA was purified by using the Qiagen Oligotex mRNA purification kit (Qiagen, Hilden, Germany) and cDNA generated with the SMART cDNA synthesis kit (Clontech Laboratories, Palo Alto, CA, USA). Quality control in each extraction step was investigated using a nanodrop spectrophotometer (Peqlab, Erlangen). Only samples with a 260/280 and 260/230 ratio >1.8 were used for sequencing. Samples were prepared for 454 sequencing according to the manufacturers protocol and sequenced on a Genome Sequencer FLX system (454 Life Sciences, Branford, CT, USA) with FLX and Titanium chemistry. The resulting 454 sequences were extracted from FLX output files using the 'sffinfo' script from Roche.


Mytilus galloprovincialis database:

The generation of M. galloprovincialis sequences are described in detail in Craft et al.. Original sequences were downloaded in December 2010 from the MG-RAST portal (https://metagenomics.nmpdr.org) and cleaned and assembled as described in Philipp et al (submitted). In total 104123 MG-RAST sequences (av. length 211bp) of M. galloprovincialis were assembled into 12827 contigs (av. length 279bp) and 40972 singletons (av. length 207bp). Using AMOS the different reads originating from either gill, foot, digestive gland or mantle tissue were mapped against the generated contigs and the Mytilus edulis mitochondrion genome (GI:55977238), which resulted in the final contigs and assigned reads from the different tissues.


Annotation of M. galloprovincialis and S. spallanzanii contigs:

Putative gene names and protein domains were assigned to all contigs by using the BLASTX algorithm against the UniprotKBSwissprot and UniRef100 protein databases of UniProt Knowledgebase (UniProtKB, https://www.expasy.org/sprot/) with a cut off e-value of e <= 10-3, as well as tBLASTx (e <= 10-3) and BLASTn (e <= 10-10) against the NCBI non-redundant nucleotide (nt) database (https://www.ncbi.nlm.nih.gov). The Sabella dataset was also investigated for conserved domains, by running the assembled contigs via InterProScan. Gene Ontology (GO) terms were deduced from BLAST and InterProScan results.


References:

  • Craft JA, Gilbert JA, Temperton B, Dempsey KE, Ashelford K, Tiwari B, et al. Pyrosequencing of Mytilus galloprovincialis cDNAs: Tissue-Specific Expression Patterns. PLoS ONE. 2010;5(1):e8875.
  • Meyer F, Paarmann D, D'Souza M, Olson R, Glass E, Kubal M, et al. The metagenomics RAST server - a public resource for the automatic phylogenetic and functional analysis of metagenomes. BMC Bioinformatics. 2008;9(1):386.
  • Hunter S, Apweiler R, Attwood TK, Bairoch A, Bateman A, Binns D, et al. InterPro: the integrative protein signature database. Nucleic Acids Research. 2009 January 1, 2009;37(suppl 1):D211-D5.
 
Download md5sum
T-ACE_mytilus_galloprovincialis.sql.zip (15M) 8338172d669920b1d197a4677f7e840e
T-ACE_sabella_spallanzanii.sql.zip (16M) f34742da3bc46e9f9de92e2ebced1590
 

Additional software

TCL/TK

 

PostgreSQL 8.4

 

Apache 2.0 HTTP server

 

NCBI Blast

 

InterProScan v4.6

 

Phobos v.3.3.12

 

Primer3 v1.1.4

 


Tutorial

Tutorial 1

 

Tutorial 2

 

Tutorial 3

 

Tutorial 4

 

Tutorial 5


Cite as


The Transcriptome Analysis and Comparison Explorer - T-ACE: a platform-independent, graphical tool to process large RNAseq data sets of non-model organisms.
E.E.R. Philipp; L. Kraemer; D. Mountfort; M. Schilhabel; S. Schreiber; P. Rosenstiel
Bioinformatics 2012; doi: 10.1093/bioinformatics/bts056


Change Log

04. June 2013:

T-ACE v1.9.5 now available

Changes:
  • Minor bugs removed.

30. March 2012:

T-ACE v1.9.4 now available

Changes:
  • New login form. It is now possible to save multiple database conncetions.
  • Minor bugs removed.
  • Changes in configuration files.
  • Manual update.

1. February 2012:

T-ACE v1.9.3 now available

Changes:
  • Extended module management.
  • Major changes in configuration files and module scipts.
  • Manual update.

13. January 2012:

T-ACE v1.9.2 now available

Changes:
  • Sequence import: SAM format now supported. Reference sequences must be imported into database first.
  • Manual update.

8. November 2011:

T-ACE v1.9.1 now available

Changes:
  • Expression analysis: p-value correction added (Benjamini-Hochberg)
  • Blast: when switching the blast program the currently selected database does not switch automatically to the working database
  • GO-term upload: corrected error while uploading .annot or .txt GO-term files (Blast2GO formats) into T-ACE
  • Manual update.

31. August 2011:

Please update TCL/TK to version 8.5.10.1 for complete functionality of new changes in T-ACE v1.9

Changes:
  • Run Compare: added ability to export hits of each cohort for each term into project tabs
  • Blast: corrected error which occured while blasting against the protein sequences of a T-ACE database in protein mode.

Welcome

This is the online resource for T-ACE. Recent package versions, manual updates and example data sets are available here. We very welcome comments, suggestions and bug-reports to T-ACE. Please post at our T-ACE google group or email to:


  • Lars Kraemer:
    l.kraemer [at] ikmb.uni-kiel.de (bioinformatics)

  • Eva Philipp:
    e.philipp [at] ikmb.uni-kiel.de (biological sciences)

News

June. 04 2013:
T-ACE v1.9.5 now available

 

March. 30 2012:
T-ACE v1.9.4 now available
New Login Form
T-ACE Manual updated

 

February. 01 2012:
Paper Published in Bioinformatics.
How to cite.
T-ACE v1.9.3 now available
T-ACE Manual updated

 

January. 13 2012:
T-ACE v1.9.2 now available
Upload of SAM files now possible
T-ACE Manual updated

 

November. 08 2011:
Tutorials are now available
T-ACE v1.9.1 now available
T-ACE Manual updated


Address

Institute of Clinical Molecular Biology

Christian-Albrechts-University zu Kiel

Schittenhelmstr. 12

D-24105 Kiel

https://www.ikmb.uni-kiel.de