{"id":369,"date":"2025-07-03T23:51:12","date_gmt":"2025-07-03T23:51:12","guid":{"rendered":"https:\/\/open.qtlmax.com\/guide\/?p=369"},"modified":"2026-02-20T17:38:06","modified_gmt":"2026-02-20T23:38:06","slug":"merging-phenotype-and-pca-tables","status":"publish","type":"post","link":"https:\/\/open.qtlmax.com\/guide\/index.php\/2025\/07\/03\/merging-phenotype-and-pca-tables\/","title":{"rendered":"How to merge a phenotype and a PCA\/Admixture table"},"content":{"rendered":"\n
\"\"<\/figure>\n\n\n\n

(Figure 1)<\/p>\n\n\n\n

In the Table 1 and Table 2 boxes, you need to select the column name for sample names<\/strong> and move it to the “ID column<\/strong>” text box. Similarly, select the column name for phenotype values<\/strong> from the Table 1 box and send it to the “Columns from triats & reps<\/strong>” text box. Please note that given a replicative factor, you need to make sure that its check box is checked. Then, select the column name for PCA values<\/strong> from the Table 2 box and send it to the “PCA columns<\/strong>” text box. Please ensure that you entered a project name in Project text box. After completing all these configurations, press the [Execute]<\/strong> button. You’ll then see the resulting merged table, created by combining the two files, appear on the “Merged table<\/strong>” tab page (Figure 2).<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Figure 2<\/p>\n\n\n\n

If your original phenotype file<\/strong> contains missing values<\/strong>, the table displayed on the “Merged table<\/strong>” tab will also include them. However, QTLmax doesn’t allow phenotype data with missing values for GWAS analysis. But don’t worry! You can find the merged result files on the “Files for GWAS<\/strong>” tab. In these files, all missing values from the phenotype data will have been removed (Figure 3). Each of these files is structured with a single phenotype column merged with the PCA columns. You can directly access these result files by clicking the [Open the directory]<\/strong> button, which will immediately open the project folder. You can use each file for GWAS works by using QTLmax. <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Figure 3. <\/p>\n","protected":false},"excerpt":{"rendered":"

(Figure 1) In the Table 1 and Table 2 boxes, you need to select the column name for sample names and move it to the “ID column” text box. Similarly, select the column name for phenotype values from the Table 1 box and send it to the “Columns from triats & reps” text box. Please […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-369","post","type-post","status-publish","format-standard","hentry","category-guide"],"_links":{"self":[{"href":"https:\/\/open.qtlmax.com\/guide\/index.php\/wp-json\/wp\/v2\/posts\/369","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/open.qtlmax.com\/guide\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/open.qtlmax.com\/guide\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/open.qtlmax.com\/guide\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/open.qtlmax.com\/guide\/index.php\/wp-json\/wp\/v2\/comments?post=369"}],"version-history":[{"count":10,"href":"https:\/\/open.qtlmax.com\/guide\/index.php\/wp-json\/wp\/v2\/posts\/369\/revisions"}],"predecessor-version":[{"id":1752,"href":"https:\/\/open.qtlmax.com\/guide\/index.php\/wp-json\/wp\/v2\/posts\/369\/revisions\/1752"}],"wp:attachment":[{"href":"https:\/\/open.qtlmax.com\/guide\/index.php\/wp-json\/wp\/v2\/media?parent=369"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/open.qtlmax.com\/guide\/index.php\/wp-json\/wp\/v2\/categories?post=369"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/open.qtlmax.com\/guide\/index.php\/wp-json\/wp\/v2\/tags?post=369"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}