{"id":520,"date":"2013-10-18T16:00:44","date_gmt":"2013-10-18T16:00:44","guid":{"rendered":"https:\/\/arabidopsisunpak.org\/?page_id=520"},"modified":"2024-07-22T15:34:56","modified_gmt":"2024-07-22T15:34:56","slug":"database-tutorial","status":"publish","type":"page","link":"https:\/\/arabidopsisunpak.org\/?page_id=520","title":{"rendered":"Database Tutorial"},"content":{"rendered":"<p>As an introduction to working with the unPAK database this tutorial will walk you through the process of identifying plant lines of based on a certain phenotype of interest. \u00a0To access the unPAK database click <a title=\"database\" href=\"http:\/\/107.170.89.221\" target=\"_blank\" rel=\"noopener\">here<\/a>\u00a0(will open in new window).<\/p>\n<h4 style=\"text-align: left;\"><span style=\"color: #6c9646;\"><strong>STEP 1<\/strong>:<\/span><\/h4>\n<p style=\"text-align: center;\"><a href=\"https:\/\/arabidopsisunpak.org\/wp-content\/uploads\/2013\/10\/Lines_From_Pheno_Main.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-523\" style=\"border: 2px solid black;\" title=\"Lines_From_Pheno_Main\" src=\"https:\/\/arabidopsisunpak.org\/wp-content\/uploads\/2013\/10\/Lines_From_Pheno_Main-1024x365.png\" alt=\"\" width=\"800\" height=\"285\" srcset=\"https:\/\/arabidopsisunpak.org\/wp-content\/uploads\/2013\/10\/Lines_From_Pheno_Main-1024x365.png 1024w, https:\/\/arabidopsisunpak.org\/wp-content\/uploads\/2013\/10\/Lines_From_Pheno_Main-300x107.png 300w, https:\/\/arabidopsisunpak.org\/wp-content\/uploads\/2013\/10\/Lines_From_Pheno_Main.png 1445w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/a><\/p>\n<p>The above page is comprised of two parts, menus on the left that allow you to chose specific traits, experiments, treatments and trait value ranges of interest and a graph on the right that changes to reflect the options you have chose. \u00a0For this example, start by choosing a phenotype, an experiment, and a treatment using the drop down menus. \u00a0<em>For this tutorial, we&#8217;ve chosen &#8220;fruitnum&#8221; (fruit number at time of harvest) as our trait, Experiment 1A1 as our experiment, and the control treatment as our treatment of interest.<\/em><\/p>\n<hr size=\"4\" \/>\n<h4 style=\"text-align: left;\">\u00a0<span style=\"color: #6c9646;\"><strong>STEP 2:<\/strong><\/span><\/h4>\n<p><a href=\"https:\/\/arabidopsisunpak.org\/wp-content\/uploads\/2013\/10\/Lines_within_trait_range_edited.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-593\" style=\"border: 2px solid black;\" title=\"Lines_within_trait_range_edited\" src=\"https:\/\/arabidopsisunpak.org\/wp-content\/uploads\/2013\/10\/Lines_within_trait_range_edited.png\" alt=\"\" width=\"800\" height=\"294\" srcset=\"https:\/\/arabidopsisunpak.org\/wp-content\/uploads\/2013\/10\/Lines_within_trait_range_edited.png 800w, https:\/\/arabidopsisunpak.org\/wp-content\/uploads\/2013\/10\/Lines_within_trait_range_edited-300x110.png 300w, https:\/\/arabidopsisunpak.org\/wp-content\/uploads\/2013\/10\/Lines_within_trait_range_edited-275x100.png 275w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/a><\/p>\n<p>Now, to identify lines that fell within a certain range of trait values move the two blue arrowheads along the trait range slider in the left panel. \u00a0As you move the arrowheads you will see the green bar (lower trait value cutoff) and red bar (upper trait value cutoff) move on the histogram.<\/p>\n<p>Next, click on the link titled &#8220;Lines&#8221; above the graph to find out what Arabidopsis lines tested fall within the trait value range you selected.<\/p>\n<hr size=\"4\" \/>\n<h4><span style=\"color: #6c9646;\"><strong>STEP 3:<\/strong><\/span><\/h4>\n<p style=\"text-align: center;\"><a href=\"https:\/\/arabidopsisunpak.org\/wp-content\/uploads\/2013\/10\/Lines_within_trait_range.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-528\" style=\"border: 2px solid black;\" title=\"Lines_within_trait_range\" src=\"https:\/\/arabidopsisunpak.org\/wp-content\/uploads\/2013\/10\/Lines_within_trait_range.png\" alt=\"\" width=\"700\" height=\"337\" \/><\/a><\/p>\n<p>All of the line IDs listed under the &#8220;Accession&#8221; header in the table are links &#8211; clicking on them will bring you to a new page where you are able to view all of the phenotypes recorded for your plant line of interest. \u00a0<em>For the case of this tutorial, the figure above shows the results returned for plant lines used in Experiment 1A1 that on average produced the greatest number of fruits.\u00a0We&#8217;ve chosen to select the mutant line SALK_058070C.<\/em><\/p>\n<hr size=\"4\" \/>\n<h4 style=\"text-align: left;\"><span style=\"color: #6c9646;\">\u00a0<strong>STEP 4:<\/strong><\/span><a href=\"https:\/\/arabidopsisunpak.org\/wp-content\/uploads\/2013\/10\/Pheno_from_line.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-530\" style=\"border: 2px solid black;\" title=\"Pheno_from_line\" src=\"https:\/\/arabidopsisunpak.org\/wp-content\/uploads\/2013\/10\/Pheno_from_line-1024x625.png\" alt=\"\" width=\"800\" height=\"488\" srcset=\"https:\/\/arabidopsisunpak.org\/wp-content\/uploads\/2013\/10\/Pheno_from_line-1024x625.png 1024w, https:\/\/arabidopsisunpak.org\/wp-content\/uploads\/2013\/10\/Pheno_from_line-300x183.png 300w, https:\/\/arabidopsisunpak.org\/wp-content\/uploads\/2013\/10\/Pheno_from_line.png 1093w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/a><\/h4>\n<p>The &#8220;Phenotypes from line ID&#8221; interactive webpage allows you to view customized results for any plant line unPAK researchers have recorded data for. \u00a0On the right are histograms of trait values of all plants separated by experiment and trait. \u00a0The line of interest (in this case, SALK_058070C) is represented by a red line (the mean value of all replicates measured).<\/p>\n<p>To learn more about your line of interest, the unPAK database is connected to The Arabidopsis Information Resource (TAIR). \u00a0Clicking the link located above the histograms will connect you to the TAIR search results page for the Arabidopsis line you have selected.<\/p>\n<p style=\"text-align: center;\">\u00a0<a href=\"https:\/\/arabidopsisunpak.org\/wp-content\/uploads\/2013\/10\/TAIR_Germplasm_search_results.png\"><img decoding=\"async\" class=\"aligncenter wp-image-531\" style=\"border: 2px solid black;\" title=\"TAIR_Germplasm_search_results\" src=\"https:\/\/arabidopsisunpak.org\/wp-content\/uploads\/2013\/10\/TAIR_Germplasm_search_results.png\" alt=\"\" width=\"700\" height=\"393.3\" srcset=\"https:\/\/arabidopsisunpak.org\/wp-content\/uploads\/2013\/10\/TAIR_Germplasm_search_results.png 767w, https:\/\/arabidopsisunpak.org\/wp-content\/uploads\/2013\/10\/TAIR_Germplasm_search_results-300x168.png 300w\" sizes=\"(max-width: 767px) 100vw, 767px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>As an introduction to working with the unPAK database this tutorial will walk you through the process of identifying plant lines of [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"open","template":"","meta":{"footnotes":""},"class_list":["post-520","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/arabidopsisunpak.org\/index.php?rest_route=\/wp\/v2\/pages\/520","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/arabidopsisunpak.org\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/arabidopsisunpak.org\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/arabidopsisunpak.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/arabidopsisunpak.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=520"}],"version-history":[{"count":78,"href":"https:\/\/arabidopsisunpak.org\/index.php?rest_route=\/wp\/v2\/pages\/520\/revisions"}],"predecessor-version":[{"id":1415,"href":"https:\/\/arabidopsisunpak.org\/index.php?rest_route=\/wp\/v2\/pages\/520\/revisions\/1415"}],"wp:attachment":[{"href":"https:\/\/arabidopsisunpak.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=520"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}