Assembly Release QA Steps: Difference between revisions
mNo edit summary |
|||
Line 40: | Line 40: | ||
The easiest way to create your spreadsheet is to copy the template above. Below are notes on how this template was made. | The easiest way to create your spreadsheet is to copy the template above. Below are notes on how this template was made. | ||
Create a new google spreadsheet | # Create a new google spreadsheet | ||
# | # In your assembly QA spreadsheet, add the following columns. This will auto-populate steps in your spreadsheet based on these wiki sections. | ||
The first row of the spreadsheet can be column names: | The first row of the spreadsheet can be column names: | ||
* A | * A: Wiki Link (this column makes a link to the wiki section) | ||
* B: Assembly QA/Release Steps | |||
* | |||
Put the following formulas in the 2nd row of each column: | Put the following formulas in the 2nd row of each column: | ||
:A2 | :A2 | ||
<pre> | <pre> | ||
= | =HYPERLINK("http://genomewiki.ucsc.edu/genecats/index.php/Assembly_QA_Part_1:_DEV_Steps#"&SUBSTITUTE(B2," ", "_"),"link") | ||
: | |||
</pre> | </pre> | ||
::IMPORTANT: Drag the formula for "A" down the spreadsheet to populate the other rows. | |||
:B2 | :B2 | ||
Line 82: | Line 60: | ||
This formula will populate all the rows below it with the wiki section titles. You do no need to drag this formula down. | This formula will populate all the rows below it with the wiki section titles. You do no need to drag this formula down. | ||
===<span style="color:dodgerblue">Important: How to edit this wiki section and maintain sync with spreadsheet template=== | ===<span style="color:dodgerblue">Important: How to edit this wiki section and maintain sync with spreadsheet template=== |
Revision as of 23:53, 27 March 2017
Navigation Menu |
This page is currently a draft in progress. For now, use Releasing an assembly instead.
Introduction
When a developer is ready for a new assembly to be released,
a member of the QA team will QA and release the assembly.
This wiki section exists as a guide for the assembly QA and release process.
Note the 4 sections in the Navigation menu at the upper right of this home page.
The QA member can follow this guide in unison with a sync'd Google Spreadsheet template.
There are two types of assemblies that the QA team will process:
- New species (a species not yet exisiting as a natively-hosted browser in the rr)
- New version for existing species (A new assembly version for a species that already has at least one version in the rr).
Understanding the google spreadsheet template for QA assembly release
Spreadsheet template: QA Assembly Release
The easiest way to create your spreadsheet is to copy the template above. Below are notes on how this template was made.
- Create a new google spreadsheet
- In your assembly QA spreadsheet, add the following columns. This will auto-populate steps in your spreadsheet based on these wiki sections.
The first row of the spreadsheet can be column names:
- A: Wiki Link (this column makes a link to the wiki section)
- B: Assembly QA/Release Steps
Put the following formulas in the 2nd row of each column:
- A2
=HYPERLINK("http://genomewiki.ucsc.edu/genecats/index.php/Assembly_QA_Part_1:_DEV_Steps#"&SUBSTITUTE(B2," ", "_"),"link")
- IMPORTANT: Drag the formula for "A" down the spreadsheet to populate the other rows.
- B2
=HYPERLINK("http://genomewiki.ucsc.edu/genecats/index.php/Assembly_QA_Part_1:_DEV_Steps#"&SUBSTITUTE(C2," ", "_"),LEFT(C2,7))
This formula will populate all the rows below it with the wiki section titles. You do no need to drag this formula down.
Important: How to edit this wiki section and maintain sync with spreadsheet template
INSTRUCTIONS HERE
🔵 Ready to get started? Go to Assembly QA Part 1: DEV Steps