Difference between revisions of "Phenote .ace citace upload"
m |
|||
Line 3: | Line 3: | ||
= Dumping Phenote into .ace file = | = Dumping Phenote into .ace file = | ||
− | The phenote-> .ace dump script is called ./use_package.pl and is on tazendra in | + | The phenote-> .ace dump script is called ./use_package.pl and is on tazendra in allele_phenotype. This script takes about 10 minutes and will create two files: ‘allele_phenotype.ace.<date> and err.out.<date>. NOTE: these files will accumulate over time so make sure to clear them out every once in a while. |
− | :ssh | + | :ssh tazendra |
:Pswd | :Pswd | ||
− | :cd | + | :cd...allele_phenotype |
:./use_package.pl | :./use_package.pl | ||
Can open err.out to see if any errors were generated during the dump process. Errors should be indicated at the top of the form. | Can open err.out to see if any errors were generated during the dump process. Errors should be indicated at the top of the form. | ||
− | New allele_phenotype.ace and err.out files will be created as noted by date at the end of each. Send them to your computer | + | New allele_phenotype.ace and err.out files will be created as noted by date at the end of each. Send them to your computer name to var_phen.ace: |
− | : scp allele_phenotype.ace.20080407 | + | : scp allele_phenotype.ace.20080407 xxxxx@xxxxxx.caltech.edu:/.../var_phen.ace |
:pswd | :pswd | ||
= Dumping allele_paper connections into .ace file = | = Dumping allele_paper connections into .ace file = | ||
− | is at :<br>/home/acedb/ | + | is at :<br>/home/acedb/..../get_paper_object.pl |
Run it by going to that directory and redirecting output to a file | Run it by going to that directory and redirecting output to a file | ||
Line 34: | Line 34: | ||
---- | ---- | ||
+--------------+--------------- | +--------------+--------------- | ||
− | + | ... | |
---- | ---- | ||
+------------------+--------------- | +------------------+--------------- | ||
− | + | ... | |
---- | ---- | ||
+-----------------+------------------------------- | +-----------------+------------------------------- | ||
Line 43: | Line 43: | ||
from the CGI | from the CGI | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
= Testing Phenote .ace for upload = | = Testing Phenote .ace for upload = | ||
Line 61: | Line 55: | ||
$ cd Desktop/acedb | $ cd Desktop/acedb | ||
− | $ ./xace / | + | $ ./xace /.../WSXXX/acedb |
Comparing data builds: From the latest build, record | Comparing data builds: From the latest build, record | ||
Line 107: | Line 101: | ||
Deposit .ace for Wen in citace: | Deposit .ace for Wen in citace: | ||
− | scp var_phen.ace | + | scp var_phen.ace xxxx@xxxx.caltech.edu:/.../Data |
− | [[Category:Curation]] | + | [[Category:Phenotype Curation]] |
Revision as of 20:34, 24 September 2010
Contents
Dumping Phenote into .ace file
The phenote-> .ace dump script is called ./use_package.pl and is on tazendra in allele_phenotype. This script takes about 10 minutes and will create two files: ‘allele_phenotype.ace.<date> and err.out.<date>. NOTE: these files will accumulate over time so make sure to clear them out every once in a while.
:ssh tazendra :Pswd :cd...allele_phenotype :./use_package.pl
Can open err.out to see if any errors were generated during the dump process. Errors should be indicated at the top of the form.
New allele_phenotype.ace and err.out files will be created as noted by date at the end of each. Send them to your computer name to var_phen.ace:
: scp allele_phenotype.ace.20080407 xxxxx@xxxxxx.caltech.edu:/.../var_phen.ace :pswd
Dumping allele_paper connections into .ace file
is at :
/home/acedb/..../get_paper_object.pl
Run it by going to that directory and redirecting output to a file
./get_paper_object.pl > file
If there are errors, which is rare, they will look something like:
// ERR There's an object that has no name and no type, but still has a paper. It has postgres database ID 2712 testdb=> SELECT * FROM app_tempname WHERE joinkey = '2712'; joinkey | app_tempname |app_timestamp ---- +--------------+--------------- ... ---- +------------------+--------------- ... ---- +-----------------+------------------------------- 2712 | WBPaper00002087 | 2006-07-11 11:52:20.208295-07 (1 row) Here's all the data for it when it got migrated from the CGI
Testing Phenote .ace for upload
Evaluate how the uploaded data impacts WB by comparing object numbers before and after data upload. This means that you need access to the latest WS and have the means to edit the WS to read the .ace dump.
Test file locally on Acedb
This step is to test two things: First, that the file is readable. Second, that the file does not alter any objects it shouldn’t.
Launch local acedb:
$ cd Desktop/acedb $ ./xace /.../WSXXX/acedb
Comparing data builds: From the latest build, record
- Number strain objects
- Number life stage objects
- Number anatomy terms
- Number variation'-phenotype connection'
use either AQL query:
select all class variation where exists_tag ->phenotype select p, p-> variation from p in class phenotype where exists_tag p->variation
- 5. Number variations that are alleles:
use WQL
find variation variation_type=allele
or AQL
select a from a in class variation where exists_tag a->allele
- 6. Number alleles with a phenotype
Find all alleles with a phenotype
select v from v in class variation where exists_tag v->phenotype
Check that the .ace dump file is readable:
to load in .ace dump
Select ‘Edit..‘ ‘Read .ace file’, Accept change in write privileges, Select ‘Open ace file’, Find and select file to open, Select ‘Read all’
If the .ace file is okay, then 100% of the lines will have been read in. This will be noted in the second line called ‘Line:’. If the dump produced a bad file, the read in will stop at the point where the problem occurred. You can go to that line in the .ace file and check it out.
Check that the file does not alter any objects it shouldn’t:
Once .ace dump is loaded in to acedb, redo counts for all objects as above. Compare object numbers between latest database and new .ace file to make sure data in the dump looks reasonable, i.e., no lost data or inflated numbers.
Uploading .ace for Wen into Citace
Deposit .ace for Wen in citace:
scp var_phen.ace xxxx@xxxx.caltech.edu:/.../Data