Pattern and reaction curation

From DISI
Jump to navigation Jump to search

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