Multiple tables merging


*
Select a file Example
*
Select a file Example
*ProVIP free
*VIP free
*0 left in the current account

Function：
Several input tables will be merged into one and 3 different merging types are provided.

 

Input：
Input tab delimited text files with headers. If your data is not TAB delimited, you can use Excel to convert it.

 

Parameters：
3 merging types are provided including inner join, left join, and full join.

①Inner join: merge the lines with same row names in all tables.

②Left join: Using table 1 as major table, and the other tables as match table. Default value will be returned for the unmatched lines in other tables.

③Full join: output all the lines existing in all tables. When one lines of one tables does not exist in another table, default value will be returned.

④Default value: when the information exiting in one tables but missing in another, the default value will be filled into the merged table.

 

 

Output：
A merged table will be output in txt format. The first line of the table is header.

There are three tables here. Table1 contains gene expression information of two samples, tabel2 contains information of gene annotation and table3 contains gene expression data of the other three samples. The first column of all tables are gene ID. Through table merging, all the gene expression and annotation information will be merged into one table.

 

Table 1：
geneID root_exp leave_exp
Unigene01 16.4798 3.3122
Unigene02 44.5027 24.1932
Unigene03 86.9566 43.0663
Table 2：
geneID KO_id ko_definition
Unigene02 K10592 E3 ubiquitin-protein ligase HUWE1
Unigene03 K10592 NADH dehydrogenase I subunit 4
Unigene04 K05579 dehydrogenase I subunit 7
Table 3：
geneID A_exp B_exp C_exp
Unigene01 16.4798 3.3122 5597
Unigene02 44.5027 24.1932 16261
Unigene03 86.9566 43.0663 25566
Unigene04 3.3821 2.4806 1595
Inner join results：
geneID root_exp leave_exp KO_id ko_definition A_exp B_exp C_exp
Unigene02 44.5027 24.1932 K10592 E3 ubiquitin-protein ligase HUWE1 44.5027 24.1932 16261
Unigene03 86.9566 43.0663 K10592 NADH dehydrogenase I subunit 4 86.9566 43.0663 25566
Left join results：
geneID root_exp leave_exp KO_id ko_definition A_exp B_exp C_exp
Unigene01 16.4798 3.3122 -- -- 16.4798 3.3122 5597
Unigene02 44.5027 24.1932 K10592 E3 ubiquitin-protein ligase HUWE1 44.5027 24.1932 16261
Unigene03 86.9566 43.0663 K10592 NADH dehydrogenase I subunit 4 86.9566 43.0663 25566
All join results：
geneID root_exp leave_exp KO_id ko_definition A_exp B_exp C_exp
Unigene01 16.4798 3.3122 -- -- 16.4798 3.3122 5597
Unigene02 44.5027 24.1932 K10592 E3 ubiquitin-protein ligase HUWE1 44.5027 24.1932 16261
Unigene03 86.9566 43.0663 K10592 NADH dehydrogenase I subunit 4 86.9566 43.0663 25566
Unigene04 -- -- K05579 dehydrogenase I subunit 7 3.3821 2.4806 1595