Assembly Release QA Steps

Navigation Menu Home Page Assembly QA Part 1: DEV Steps Assembly QA Part 2: Track Steps Assembly QA Part 3: BETA Steps Assembly QA Part 4: RR Steps Assembly QA Part 5: Post Release Steps

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:

1. New species (a species not yet exisiting as a natively-hosted browser in the rr)
2. 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 and add 5 tabs:

1. Drop-down list
2. Dev checklist
3. Tracks checklist
4. Beta checklist
5. RR checklist
6. Post-release checklist

In the "Drop-down list" tab, add the choices that you want to drop-down for your Status column. For example:

• please select
• all substeps completed
• completed
• not completed
• N/A
• see notes

In your assembly QA spreadsheet, add the following lines to the following columns. This will auto-generate your "dev steps" spreadsheet. The first row of the spreadsheet can be column names:

• A: Hide me (you can rt-click and hide this column)
• B: Wiki Link (this column makes a link to the wiki section)
• C: Dev: Assembly Release Steps (this copies the title of each wiki section)
• D: Status (this is your drop down column to track a status like, "completed."
• E: Notes

Put the following formulas in the 2nd row of each column:

A2: =regexmatch(C2,"^Dev.\d*.0")

Drag the formula for "A" down the spreadsheet to populate the other rows.

E.g.,

A3: =regexmatch(C3,"^Dev.\d*.0")

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.

Hover over column D, click "data validation" and Cell range: (select your choices that are in a column on a different tab) and select "Show dropdown in cell" and Save.

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