Gene Regulation

From WormBaseWiki
Revision as of 09:47, 2 November 2010 by Jchan (talk | contribs)
Jump to navigationJump to search

Types of fields Juancarlos can implement:

  • text : text
  • bigtext : like longtext, but makes the text box expand when you click in it so you can see everything you've written
  • dropdown : few values
  • ontology : controlled vocabulary (tell me where they come from)
  • multiontology / multidropdown : (allows multiple values)
  • toggle : on / off, yes/no etc.


Italic text== Gene_regulation OA ==

  • Pgdbid - postgras database ID, entered automatically
  • Reference - WBPaperID paper ontology - will you ever need to enter more than one paper? No
  • Name (free text) - this gets appended to the reference to be the object name. usually a WBPaperID followed by regulated gene name, i.e.WBPaper00036472_dod-3.a
  • Summary (long text) - most of time copy and paste from paper directly with curator's slight modifications do you actually want a big text box, i.e., something that expands to see all the info when you click in the box? yes, that's what I want. Then, I should say 'Big Text'
  • Antibody Info - antibody multiontology, fill the field with existing antibody, inform the curator (myself) to curate non-existing antibody objects otherwise you could have this work the way Molecule works, when you need a new antibody, you go to the Antibody OA and create, then update the ontology so you can use the new antibody right awayyes, I would like to do so. Autocomplete on abp_ antibody table -> name. in term information show -> original publication, location. .ace -> Antibody_info
  • Antibody Remark (free text). .ace -> Antibody If data exactly matches abp_name then put in Antibody info.
  • Reporter_gene (free text) -reporter gene construct, eg. [daf-16::gfp], translational fusion is this just the transgene summary?
    yes.
  • Transgene - transgene multiontology, fill the field with existing transgene, (use app_tempname, or whatever gets split into for transgenes) need a way to inform transgene curator(Karen) when transgene is not existing yet


I'm not sure about what you need for these following method fields, would it work to have one field called Method and then a drop down list? or would you like to have a toggle (yes/no with default of no) for each of these values? I thought about the dropdown list for method first, then later I think, sometimes, I will need to comment in some fields. i.e. For 'RT_PCR', I will need to write ' semi-quantitative'. so a toggle with yes/no will not be enough, right?

  • In_situ (toggle text) - don't have to write anything in the field, but will need method (In_situ) shown.
  • Northern (toggle text) - don't have to write anything in the field, but will need method (Northern) shown.
  • Western (toggle text) - don't have to write anything in the field, but will need method (Western) shown.
  • RT_PCR (toggle text) - don't have to write anything in the field, but will need method (RT_PCR) shown.
  • Other_method (toggle text)


  • Type - multidropdown list with 'Change_of_localization' and 'Change_of_level'
  • Regulation_level - multidropdown list with 'Transcriptional', 'Post_transcriptional' and 'Post_translational'
  • Allele - variation multiontology and a way to inform relevant curator about non-existing allele The work flow will be that you go to the NS, create the variation, update the postges variation list so the new VarID is on it (this is done by a script you will run by pressing a button), then you can enter the ID from the list.


  • RNAi - text with pipes. need a way to inform RNAi curators (Chris and Gary) about new RNAi id requirement. there need to be a way they can come in later and fill the field I'm not sure how Juancarlos will deal with this


  • Trans_regulator_gene - (multiontology on gene) I will enter gene by public/sequence name, please autocomplete with WBGeneID
  • Molecule_regulator - (multiontology like app_molecule) Karen's molecule ontology, and a way to inform her non-existing molecules, you will be able to create add new molecules or synonyms to molecules and update the postgres list
  • Trans_regulator_seq multiontology of sequence objects off of gin_sequence
  • Other_regulator- free text separate by pipe for multivalues, but if any match mop_publicname, put them in Molecule_regulator.


  • Expr_pattern - (text until expr pattern OA only one value) since expr_pattern is not in postgres, I am not sure how to do this field. currently, I look up relevant expr_pattern, and copy paste into my ace file.For new expr_pattern objects, I have to wait wen to curate them first, then filled in my ace file. multiontology like gene picture OA's expr_pattern field. Based on obo_<name|data>_pic_exprpattern, needs to be based on Expr_pattern OA when that's live
  • No Dump - toggle to prevent dumping object if it should have expr_pattern but doesn't yet.
  • Trans_regulated_gene - I will enter gene by public/sequence name, please autocomplete with WBGeneID
  • Trans_regulated_seq multiontology of sequence objects off of gin_sequence
  • Other_regulated - free text separate by pipe for multivalues


  • Result - dropdown of Positive_regulate, Negative_regulate, Does_not_regulate
  • Anatomy_term - (multiontology app_anatomy) anatomy ontolgy
  • Life_stage - (multiontology app_lifestage - check the names) life_stage ontology
  • Subcellular_localization (toggle text) wouldn't this be a cell component GO term? , so could be the GO cell component Ontology The model was designed to enter the free text


  • Remark (long text) perhaps big text? yes


.ace template : different OA rows will have the same object, so dump like phenotype does, grouping all rows with the same name into a single .ace object.

//Template for Gene_regulation

  • Gene_regulation : ""
  • Summary ""
  • Antibody ""
  • Antibody_info ""
  • Reporter_gene ""
  • Transgene ""
  • In_situ "" (toggle just writes In_situ toggle + text or just text write In_situ "text")
  • Northern ""
  • Western ""
  • RT_PCR ""
  • Other_method ""
  • Allele ""
  • RNAi ""
  • Molecule_regulator ""
  • Trans_regulator_seq ""
  • Other_regulator ""
  • Trans_regulator_gene ""
  • Expr_pattern ""
  • Trans_regulated_gene ""
  • Trans_regulated_seq ""
  • Other_regulated
  • Positive_regulate Anatomy_term ""
  • Positive_regulate Life_stage ""
  • Positive_regulate Subcellular_localization ""
  • Negative_regulate Anatomy_term ""
  • Negative_regulate Life_stage ""
  • Negative_regulate Subcellular_localization ""
  • Does_not_regulate Anatomy_term ""
  • Does_not_regulate Life_stage ""
  • Does_not_regulate Subcellular_localization ""
  • Type "?Change_of_expression_level"
  • Regulation_level "?Transcriptional"
  • Remark ""
  • Reference ""


Populating postgres

On mangolassi at /home/postgres/work/pgpopulation/grg_generegulation/ create tables with create_grg_tables.pl populate tables based on GR_OA.ace , CellAO.txt , obo_ and other postgres tables. Errors at populate_pg.err (there's a few check them out, need to fix the source file at /home/acedb/xiaodong/gene_regulation/GR_OA.ace ) TODO on tazendra when live.