Pattern and reaction curation: Difference between revisions
Jump to navigation
Jump to search
(asdf) |
(asd) |
||
| Line 1: | Line 1: | ||
This is the pattern and reaction curation page. | |||
To lab members: we are being deliberately cryptic here pre-publication. Please look at private google docs for further details. | |||
== current sizes March 1, 2018 == | |||
* reaction 74 | |||
* rxndetail 44 | |||
* rxncomponent 149 | |||
* reagent 43 | |||
* pattern 2002, 171 | |||
* modifier 42 | |||
== how to === | |||
* one window with select * from reaction where reaction_id=x | |||
* one window with select * from rxndetail where reaction_fk = ? | |||
* one window with select * from rxncomponent where reaction_fk = ? | |||
* one window with select * from pattern where pattern_id = ? | |||
* one window with select * from reagent_modifer where pattern_fk= ? | |||
* one window with select * from reagent where rxndetail_fk = ? | |||
then we update one thing at a time | |||
== done == | |||
== in progress == | |||
== pending maintenance == | |||
. 1540 and 1275 patterns are obsolete and can be removed | |||
[[Category:Curator]] | [[Category:Curator]] | ||
Latest revision as of 23:17, 1 March 2018
This is the pattern and reaction curation page. To lab members: we are being deliberately cryptic here pre-publication. Please look at private google docs for further details.
current sizes March 1, 2018
- reaction 74
- rxndetail 44
- rxncomponent 149
- reagent 43
- pattern 2002, 171
- modifier 42
how to =
- one window with select * from reaction where reaction_id=x
- one window with select * from rxndetail where reaction_fk = ?
- one window with select * from rxncomponent where reaction_fk = ?
- one window with select * from pattern where pattern_id = ?
- one window with select * from reagent_modifer where pattern_fk= ?
- one window with select * from reagent where rxndetail_fk = ?
then we update one thing at a time
done
in progress
pending maintenance
. 1540 and 1275 patterns are obsolete and can be removed