Difference between revisions of "OA forms, tables, scripts, etc"

From WormBaseWiki
Jump to navigationJump to search
Line 111: Line 111:
 
|||Disease||dis_species||?Species <br>||Pristionchus pacificus<br>Homo sapiens<br>Caenorhabditis japonica<br>Caenorhabditis briggsae<br>Cruznema tripartitum<br>Caenorhabditis sp.3<br>Brugia malayi<br>Caenorhabditis brenneri<br>Caenorhabditis remanei<br>Panagrellus redivivus<br>Caenorhabditis elegans||?
 
|||Disease||dis_species||?Species <br>||Pristionchus pacificus<br>Homo sapiens<br>Caenorhabditis japonica<br>Caenorhabditis briggsae<br>Cruznema tripartitum<br>Caenorhabditis sp.3<br>Brugia malayi<br>Caenorhabditis brenneri<br>Caenorhabditis remanei<br>Panagrellus redivivus<br>Caenorhabditis elegans||?
 
|-
 
|-
|||Expression pattern||exp_qualifier||||Certain<br>Partial<br>Uncertain|yes|
+
|||Expression pattern||exp_qualifier||||Certain<br>Partial<br>Uncertain||yes
 
|-
 
|-
|||Expression pattern||exp_exprtype||||Antibody<br>Reporter_gene<br>In_Situ<br>RT_PCR<br>Northern<br>Western|yes|
+
|||Expression pattern||exp_exprtype||||Antibody<br>Reporter_gene<br>In_Situ<br>RT_PCR<br>Northern<br>Western||yes
 
|-
 
|-
|||Expression pattern||exp_species||?Species not in model||Pristionchus pacificus<br>Homo sapiens<br>Caenorhabditis japonica<br>Caenorhabditis briggsae<br>Cruznema tripartitum<br>Caenorhabditis sp.3<br>Brugia malayi<br>Caenorhabditis brenneri<br>Caenorhabditis remanei<br>Panagrellus redivivus<br>Caenorhabditis elegans|no|
+
|||Expression pattern||exp_species||?Species not in model||Pristionchus pacificus<br>Homo sapiens<br>Caenorhabditis japonica<br>Caenorhabditis briggsae<br>Cruznema tripartitum<br>Caenorhabditis sp.3<br>Brugia malayi<br>Caenorhabditis brenneri<br>Caenorhabditis remanei<br>Panagrellus redivivus<br>Caenorhabditis elegans||no
 
|-
 
|-
 
|||Gene class||glc_type||||molecular<br>phenotype<br>phenotype-function<br>other||
 
|||Gene class||glc_type||||molecular<br>phenotype<br>phenotype-function<br>other||

Revision as of 09:16, 10 October 2013

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 not in model 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
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
Interaction int_neutralityfxn ?Interaction Multiplicative
Additive
Minimal
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 not in model other
lost
new_gene_assignment
no
Phenotype app_curation_status not in model 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 not in any model 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