Difference between revisions of "Quality Assurance"
From LMU BioDB 2013
(Initial transcription of this page.) |
(→Guild Members: added Lena to members) |
||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 4: | Line 4: | ||
== Guild Members == | == Guild Members == | ||
| − | * | + | * [[User:Slouie | Stephen Louie]] |
| + | *[[User:Lena| Lena Hunt]] | ||
== Milestones == | == Milestones == | ||
| Line 16: | Line 17: | ||
#** UniProt | #** UniProt | ||
#** RefSeq | #** RefSeq | ||
| − | #** | + | #** GeneID (EntrezGene from NCBI) |
#** GO | #** GO | ||
#* The OrderedLocusNames for your species | #* The OrderedLocusNames for your species | ||
| Line 38: | Line 39: | ||
# Document the relational database schema for the gene database. | # Document the relational database schema for the gene database. | ||
# Create the ReadMe with comparisons to MOD for your species | # Create the ReadMe with comparisons to MOD for your species | ||
| + | |||
| + | [[Category:Group Projects]] | ||
Latest revision as of 18:18, 14 November 2013
Contents |
[edit] Guild Members
[edit] Milestones
[edit] Milestone 1
- (with Coders) Get a full import-export cycle done.
- (with Coders) Decide on a file/version management scheme/system.
- Learn the ID systems:
- Systems that are the same for each species (hint: guild members help each other out by posting the relevant information on this page)
- UniProt
- RefSeq
- GeneID (EntrezGene from NCBI)
- GO
- The OrderedLocusNames for your species
- Systems that are the same for each species (hint: guild members help each other out by posting the relevant information on this page)
[edit] Milestone 2
- Characterize regular expression patterns to detect the IDs.
- XMLPipeDB Match utility
- Direct SQL queries in PostgreSQL
- For example, the Vibrio IDs were of the form VC#### or VC_####, how would you express that in Match or as an SQL query?
- Table inspection/filtering/sorting in Microsoft Access
- If needed, side-by-side sorted comparisons in Microsoft Excel
- Document/log all work done, problems encountered, and how they were resolved.
[edit] Milestone 3
Along with your Coder, customize the tally engine setup for your species as specified in these coder steps. You will want to add, at the very least, the ordered locus IDs for your species.
[edit] Milestone 4
- Document the relational database schema for the gene database.
- Create the ReadMe with comparisons to MOD for your species
