OA forms, tables, scripts, etc

OA form summaries

OA form wiki page model(all models)	Curation focus	Postgres Tables (all OA tables)	Dumper Script	Ontologies used	Other dependencies	Curator	Other remarks
antibody model	C. elegans antibodies	abp_	/home/acedb/xiaodong/antibody/use_package.pl	Paper Gene Laboratory		Xiaodong Wang
concise gene model	Concise Description	con_	/home/acedb/kimberly/citace_upload/concise/wrapper.pl and /home/postgres/work/citace_upload/concise/dump_concise.pl	n/a	n/a	Ranjana Kishore, Kimberly Van Auken
disease disease wiki	Worm models of human disease	dis_				Ranjana Kishore
exprpat model	Expression pattern of genes	expr_	/home/acedb/draciti/oa_expr_ace_dumper/use_package.pl	Paper Gene Anatomy GO Lifestage Type Transgene Antibody Clone Strain Laboratory		Daniela Raciti
gene class model	Concise description of gene classes			Gene Paper		Karen Yook
go go code model go term model	Gene ontology annotation					Kimberly Van Auken, Ranjana Kishore	GO pipeline is currently in flux as we migrate to using Protein2GO
gene regulation genereg wiki model	Gene regulation	grg_ grg_tables	/home/postgres/work/citace_upload/gene_regulation/use_package.pl	Paper Interaction RNAi Antibody Transgene Variation Rearrangement Expr_pattern Sentence Gene Molecule Sequence Anatomy Lifestage	/home/postgres/work/citace_upload/gene_regulation/get_gene_regulation_ace.pm (Required Perl module)	Xiaodong Wang
gene interaction interaction wiki model	Genetic and physical interactions	int_ int_tables	/home/postgres/work/citace_upload/interaction/use_package.pl	Paper Gene Variation Phenotype Person Laboratory Antibody Rearrangement Transgene RNAi	/home/acedb/xiaodong/assigning_interaction_ids/assign_interaction_ids.pl Nightly cronjob script to assign Interaction IDs to PGIDs that do not already have one	Chris Grove, Gary Schindelman, Kimberly Van Auken, Karen Yook	Only one PGID per Interaction object. Some physical interactions are currently in BioGrid and will need to be migrated to postgres.
molecule molecule wiki model	Drug/Chemical/Small molecule objects	mop_ mop_tables	acedb/karen/Molecule/dump_molecule_ace.pl acedb/karen/Molecule/database.ace	Paper Chebi		Karen Yook
movie model	Movies	mov_	/home/acedb/draciti/oa_movie_ace_dumper use_movie_package.pl	Paper Expr_pattern Variation		Daniela Raciti
phenotype model	Annotation of phenotypes to variations, strains, rearrangements, transgenes	app_ app_tables	acedb/work/allele_phenotype/use_package.pl acedb/karen/phenote/paper_object/get_paper_object.pl	Paper Person Variation Rearrangements Transgene Gene Phenotype Molecule Anatomy Lifestage Laboratory		Karen Yook
picture model	Paper figure	pic_	/home/acedb/draciti/oa_picture_ace_dumper/dump_picture_ace.pl	Paper Person Expr_pattern Anatomy GO Lifestage Cropped_from		Daniela Raciti
biological_topic WS225 model	Process curation	pro_ pro_tables	/home/acedb/karen/process/use_process_curation_package.pl	Paper Person Phenotype Gene Molecule Anatomy Lifestage Expression cluster Taxon Picture		Karen Yook
biological_topic_term WS225 model	Creation of process names	prt_ prt_tables	/home/acedb/karen/process/use_process_package.pl	Paper GO		Karen Yook
RNAi RNAi wiki model	RNAi phenotype curation	rna_ rna_tables	/home/postgres/work/citace_upload/rnai/use_package.pl	Paper Lifestage Phenotype Molecule Person Strain Laboratory PCR Product	/home/postgres/work/citace_upload/rnai/get_rnai_ace.pm (Required Perl module)	Chris Grove, Gary Schindelman, Wen Chen	Possible to have multiple PGIDs per WBRNAi object
transgene transgene wiki model	Transgene object curation	trp_ trp_tables	acedb/karen/transgene ./use_package.pl	Gene Paper Laboratory Person	transgene.pl parses results from transgenes_in_ocr_papers.out and transgenes_in_regular_papers.out and enters them into the trp_tables transgenes_summary.pl|transgenes_summary.plfinds Is/In/Ex transgenes and genomic expressions (not put in any pipeline yet /home/citpub/Karen/TgSummary/getNewTg.pl finds Ex transgenes and # of occurrences for prioritization	Karen Yook

OA form ontology/autocomplete dependencies and update scripts

Any field within an OA that works by autocomplete is in a postgres table. Many of them are either obo tables or taken from other OA datatype tables. obo tables are obo_data_<datatype>, obo_syn_<datatype> or obo_name_<datatype>. Other OA datatype tables include trp_<tables>, mop_, grg_, abp_. Exceptions are person, paper, gene data as these are not curated through an OA.

Last updated	Ontology/Autocomplete	postres table	Source(s)	Updating scripts	Used in OA
	WBPaper	pap_tables (non OA)	NCBI pap_tables paper editor	/home/postgres/work/pgpopulation/pap_papers/new_papers/pap_match.pm the paper editor uses this module to look at NCBI to populate pap_tables	All
201309	Gene	gin_tables (non OA)	genename server (for most info)/WS (for CDS etc)	WBGene_information_and_status_pipeline	Most
	Person	two_tables (non OA)	cecilia person editor	manual for author, on-the-fly scripts for abstracts	Most
201309	Variation object	obo_name_variation (WBVarID + public name) obo_syn_variation -delete	variation name server minus junk variations (total_variations.txt -Variation_gene.txt, -dead variation, -gk(6+digits), -deBono alleles)	updateVariationObo addToVariationObo (routines in the generic.cgi)	Phenotype GeneReg Interaction GO Movie
201309	Variation term_info	obo_data_variation	jolene/WS_AQL_queries/Variation_gene.txt (latest release for variation-gene mappings) Variation Name Server (immediate variation updates--no gene mappings	generic.cgi?updateVariationObo	Phenotype GeneReg Interaction GO Movie
	GO	obo_name_goid and obo_syn_goid	http://www.geneontology.org/ontology/obo_format_1_2/gene_ontology_ext.obo	/postgres/work/pgpopulation/obo_oa_ontologies/update_obo_oa_ontologies.pl	Process GO Expression
	Phenotype		phenotype_ontology_obo (from CVS on spica?)	/postgres/work/pgpopulation/obo_oa_ontologies/update_obo_oa_ontologies.pl	Phenotype Interaction Process
	Molecule		molecule.obo from mop tables?		Phenotype Process Gene regulation RNAi
	Anatomy		https://github.com/raymond91125/Wao/raw/master/WBbt.obo	/postgres/work/pgpopulation/obo_oa_ontologies/update_obo_oa_ontologies.pl	Phenotype Process Expression
	Lifestage		https://raw.github.com/draciti/Life-stage-obo/master/worm_development.obo	/postgres/work/pgpopulation/obo_oa_ontologies/update_obo_oa_ontologies.pl	Phenotype Process Expression
201309	Expression cluster		/home/acedb/jolene/WS_AQL_queries/expr_cluster.txt manually queried from latest release	http://tazendra.caltech.edu/~azurebrd/cgi-bin/forms/generic.cgi?action=UpdateVariationObo?	Process
	Taxon		/home/acedb/karen/processOA/wbspecies.txt (manually updated)	/home/acedb/karen/processOA/update_obo_taxon.pl	Process
	Picture				Process
2011?	Transgene		/home/acedb/jolene/WS_AQL_queries/transgene_summary.txt manual query of latest release for term info in OA changed to retrieve data from trp_tables	http://tazendra.caltech.edu/~azurebrd/cgi-bin/forms/generic.cgi?action=UpdateVariationObo?
201309	Rearrangement object		/home/acedb/jolene/WS_AQL_queries/rearr_simple	http://tazendra.caltech.edu/~azurebrd/cgi-bin/forms/generic.cgi?action=UpdateVariationObo?	Phenotype Interaction
201309	Rearrangement term info		/home/acedb/jolene/WS_AQL_queries/rearr_simple	http://tazendra.caltech.edu/~azurebrd/cgi-bin/forms/generic.cgi?action=UpdateVariationObo?	Phenotype Interaction
	Process		prc tables		Interaction
<2012	Laboratory		obo_data_laboratory	/home/acedb/cron/populate_gin.pl	Transgene Expression pattern Interaction Phenotype /data1/Users/arunr/Curator_related/Alleles/scripts (for Mary Ann's alleles)
201309	Clone object		/home/acedb/jolene/WS_AQL_queries/clone_info.txt manually queried from latest release	http://tazendra.caltech.edu/~azurebrd/cgi-bin/forms/generic.cgi?action=UpdateVariationObo?	Expression pattern Transgene
201309	Clone term info		/home/acedb/jolene/WS_AQL_queries/clone_info.txt manually queried from latest release	http://tazendra.caltech.edu/~azurebrd/cgi-bin/forms/generic.cgi?action=UpdateVariationObo?	Expression pattern Transgene
201309	Strain object		/home/acedb/jolene/WS_AQL_queries/strains.txt manually queried from latest release	http://tazendra.caltech.edu/~azurebrd/cgi-bin/forms/generic.cgi?action=UpdateVariationObo?	Expression pattern Phenotype
201309	Strain term info		/home/acedb/jolene/WS_AQL_queries/strains.txt manually queried from latest release	http://tazendra.caltech.edu/~azurebrd/cgi-bin/forms/generic.cgi?action=UpdateVariationObo?	Expression pattern Phenotype
201309	Expression_cluster		/home/acedb/jolene/WS_AQL_queries/strains.txt manually queried from latest release change to get from spica /home/citpub/CitaceMirror/citace/ after each upload	http://tazendra.caltech.edu/~azurebrd/cgi-bin/forms/generic.cgi?action=UpdateVariationObo?	Process_curation
	ChEBI		ftp://ftp.ebi.ac.uk/pub/databases/chebi/ontology/chebi.obo	/postgres/work/pgpopulation/obo_oa_ontologies/update_obo_oa_ontologies.pl	Molecule
	Human Disease DO (humando)		https://diseaseontology.svn.sourceforge.net/svnroot/diseaseontology/trunk/HumanDO.obo	/postgres/work/pgpopulation/obo_oa_ontologies/update_obo_oa_ontologies.pl	Human disease

OA form dropdown lists

These are the values associated with the dropdown lists in the fields of the OAs. These values are all hardcoded in the wormOA.pm on tazendra.

Last updated	OA	postgres table	?Class tag	Values (id - name)	Controlled vocab in model?
	Antibody	abp_clonality	?Antibody Clonality	Monoclonal Polyclonal	yes
	Antibody	abp_animal	?Antibody Animal	Goat Guinea-pig Rat Mouse Other_animal Rabbit Chicken	yes
	Antibody	abp_antigen	?Antibody Antigen	Peptide Protein other_antigen	yes
	Antibody	abp_source	?Antibody Source	No_orginal_reference Original_publication	yes
	Concise(description)	con_desctype	?Gene Structured description	Provisional_description Sequence_features Functional_pathway Functional_physical_interaction Biological_process Molecular_function Expression Other_description	yes
	Disease	dis_species	?Species	Pristionchus pacificus Homo sapiens Caenorhabditis japonica Caenorhabditis briggsae Cruznema tripartitum Caenorhabditis sp.3 Brugia malayi Caenorhabditis brenneri Caenorhabditis remanei Panagrellus redivivus Caenorhabditis elegans	?
	Expression pattern	exp_qualifier		Certain Partial Uncertain	yes
	Expression pattern	exp_exprtype		Antibody Reporter_gene In_Situ RT_PCR Northern Western	yes
	Expression pattern	exp_species	?Species	Pristionchus pacificus Homo sapiens Caenorhabditis japonica Caenorhabditis briggsae Cruznema tripartitum Caenorhabditis sp.3 Brugia malayi Caenorhabditis brenneri Caenorhabditis remanei Panagrellus redivivus Caenorhabditis elegans	no
	Gene class	glc_type		molecular phenotype phenotype-function other
	GO	go_project		Reference Genomes PAINT Variation phenotype2GO Human Disease Gene Ortholog
	GO	go_goontology		F(Molecular_function) P(Biological_function) C(Cellular_component)
	GO	go_goinference		IDA IEA IEP IGI IMP IPI ISS NAS ND IC TAS RCA EXP ISA ISO ISM IGC
	GO	go_accession		GO_REF:0000011 GO_REF:0000012 GO_REF:0000015 GO_REF:0000033 GO_REF:0000024
	GO	go_qualifier		NOT contributes_to colocalizes_with
	GO	go_dbtype		protein gene transcript complex protein_structure
	Gene regulation	grg_type		Change_of_localization Change_of_expression_level
	Gene regulation	grg_regulationlevel		Transcriptional Post_transcriptional Post_translational
	Gene regulation	grg_result		Positive_regulate Negative_regulate Does_not_regulate
	Interaction	int_type	?Interaction	Physical Predicted Genetic - Genetic Interaction Genetic - Negative genetic Genetic - Synthetic Genetic - Enhancement Genetic - Unilateral enhancement Genetic - Mutual enhancement Genetic - Suppression Genetic - Complete suppression Genetic - Partial suppression Genetic - Unilateral suppression Genetic - Complete unilateral suppression Genetic - Partial unilateral suppression Genetic - Mutual suppression Genetic - Complete mutual suppression Genetic - Partial mutual suppression Genetic - Asynthetic Genetic - Suppression/Enhancement Genetic - Epistasis Genetic - Positive epistasis Genetic - Maximal epistasis Genetic - Minimal epistasis Genetic - Neutral epistasis Genetic - Qualitative epistasis Genetic - Opposing epistasis Genetic - Quantitative epistasis Genetic - Neutral genetic Genetic - Oversuppression Genetic - Unilateral oversuppression Genetic - Mutual oversuppression Genetic - Oversuppression/Enhancement Genetic - Phenotype bias Genetic - No_interaction	yes
	Interaction	int_detectionmethod	?Interaction	Affinity_capture_luminescence Affinity_capture_MS Affinity_capture_RNA Affinity_capture_Western Cofractionation Colocalization Copurification Fluorescence_resonance_energy_transfer Protein_fragment_complementation_assay Yeast_two_hybrid Biochemical_activity Cocrystal_structure Far_western Protein_peptide Protein_RNA Reconstituted_complex Yeast_one_hybrid Directed_yeast_one_hybrid	yes
	Interaction	int_neutralityfxn	?Interaction	Multiplicative Additive Minimal	yes
	Interaction	int_otheronetype	?Interaction	Transgene Chemical
	Interaction	int_othertwotype	?Interaction	Transgene Chemical
	Phenotype	app_easescore	#Phenotype_info Ease_of_scoring	ES0_Impossible_to_score #Evidence ES1_Very_hard_to_score #Evidence ES2_Difficult_to_score #Evidence ES3_Easy_to_score #Evidence	yes
	Phenotype	app_mmateff	?Variation Mating_efficiency Male	Male UNIQUE ME0_Mating_not_successful ME1_Mating_rarely_successful ME2_Mating_usually_successful ME3_Mating_always_successful	yes
	Phenotype	app_hmateff	?Variation Mating_efficiency Hermaphrodite	HME0_Mating_not_successful HME1_Mating_rarely_successful HME2_Mating_usually_successful HME3_Mating_always_successful	yes
	Phenotype	app_nature	#Phenotype_info	Recessive Semi_dominant Dominant	yes
	Phenotype	app_func	#Phenotype_info Loss_of_function/Gain_of_function	Hypomorph Amorph Uncharacterised_loss_of_function Dominant_negative Hypermorph Neomorph Uncharacterised_gain_of_function	yes
	Phenotype	app_penetrance	#Phenotype_info Penetrance	Incomplete Low High Complete	yes
	Phenotype	app_mat_effect	?Phenotype_info Maternal	Strictly_maternal With_maternal_effect	yes
	Phenotype	app_allele_status	Caltech use only	other lost new_gene_assignment	no
	Phenotype	app_curation_status	Caltech use only	happy not_happy down_right_disgusted	no
	Transgene	trp_reporter_product	?Transgene Reporter Reporter_product	GFP GFP(S65C) EGFP YFP CFP LacZ RFP mCherry DsRed DsRed2 BFP Venus Yellow_cameleon Dendra tagRFP tdimer2	no
	RNAi	rna_deliverymethod		Bacterial_feeding Injection Soaking Transgene_expression
	RNAi	rna_species		Pristionchus pacificus Homo sapiens Caenorhabditis japonica Caenorhabditis briggsae Cruznema tripartitum Caenorhabditis sp.3 Brugia malayi Caenorhabditis brenneri Caenorhabditis remanei Panagrellus redivivus Caenorhabditis elegans
	RNAi	rna_penetrance		Incomplete Low High Complete
	Transgene	trp_reporter_product	?Transgene	GFP GFP(S65C) EGFP YFP CFP LacZ RFP mCherry DsRed DsRed2 BFP Venus Yellow_cameleon Dendra tagRFP tdimer2(12)	no
	Transgene	trp_integration_method	?Transgene Integration_method	Gamma_irradiation X-ray Spontaneous UV UV_TMP MMS_mutagenesis Single_copy_insertion Particle_bombardment EMS_mutagenesis	no
	Transgene	trp_reporter_type	?Transgene Reporter_type	Transcriptional fusion Translational fusion	no
	Transgene	trp_map	?Transgene Map ?Map #Map_position	I II III IV V X	no
	ALL	<OA_table>_curator	Caltech use only	two1823 - Juancarlos Chan two101 - Wen Chen two1983 - Paul Davis two2021 - Jolene S. Fernandes two2987 - Chris two12884 - Snehalata Kadam two324 - Ranjana Kishore two363 - Raymond Lee two1 - Cecilia Nakamura two480 - Tuco two12028 - Daniela Raciti two1847 - Anthony Rogers two557 - Gary C. Schindelman two567 - Erich Schwarz two625 - Paul Sternberg two2970 - Mary Ann Tuli two1843 - Kimberly Van Auken two736 - Qinghua Wang two1760 - Xiaodong Wang two712 - Karen Yook	no, not dumped

app_tables

Back to Caltech documentation