Difference between revisions of "All OA tables"

From WormBaseWiki
Jump to navigationJump to search
m (Created page with '===Molecule mop_tables=== {| border="1" cellpadding="2" cellspacing="2" {{table}} |+'''postgres tables for the Molecule class<br> dumper on tazendra at karen/Molecule/dump_molecu…')
 
m
Line 1: Line 1:
 +
===Antibody abp_tables===
 +
{| border="1" cellpadding="2" cellspacing="2" {{table}}
 +
|+'''postgres tables for the Anitbody class<br> dumper on tazendra at /xiaodong/antibody/use_package.pl '''
 +
| align="center" style="background:#f0f0f0;"|'''Model tag'''
 +
| align="center" style="background:#f0f0f0;"|'''table'''
 +
| align="center" style="background:#f0f0f0;"|'''type'''
 +
| align="center" style="background:#f0f0f0;"|'''OA label'''
 +
| align="center" style="background:#f0f0f0;"|'''tab'''
 +
| align="center" style="background:#f0f0f0;"|'''ontology_type'''
 +
| align="center" style="background:#f0f0f0;"|'''ontology_table'''
 +
| align="center" style="background:#f0f0f0;"|'''cross table population script'''
 +
| align="center" style="background:#f0f0f0;"|'''comment'''
 +
|-
 +
| style="color: grey;"| pgonly||abp_id||not a table||pgid||all*||-||-||-||
 +
|-
 +
| style="color: grey;"| pgonly||abp_timestamp||not a table||none||||-||||||
 +
|-
 +
| style="color: grey;"| pgonly||abp_curator||dropdown||Curator||all||-||-||-||
 +
|-
 +
| Antibody||abp_name||text||Name||all||||||||
 +
|-
 +
| Summary||abp_summary||bigtext||Summary||all||||||||
 +
|-
 +
| Other_name||abp_other_name||bigtext||Other Name||all||||||||
 +
|-
 +
| Gene||abp_gene||multiontology||Gene||all||WBGene||gin_tables||||
 +
|-
 +
| Original_publication||abp_original_publication||ontology||Original Publication||all||WBPaper||pap_tables||||
 +
|-
 +
| style="color: grey;"| Person ''not used??''||||||||||||||||
 +
|-
 +
| Laboratory||abp_laboratory||multiontology||Laboratory||all||obo||laboratory||||
 +
|-
 +
| Clonality||abp_clonality||dropdown||Clonality||all||||||||
 +
|-
 +
| Antigen||abp_antigen||dropdown||Antigen||all||||||||
 +
|-
 +
| Peptide||abp_peptide||bigtext||Peptide||all||||||||
 +
|-
 +
| Protein||abp_protein||bigtext||Protein||all||||||||
 +
|-
 +
| Source||abp_source||dropdown||Source||all||||||||
 +
|-
 +
| Animal||abp_animal||dropdown||Animal||all||||||||
 +
|-
 +
| Other_animal||abp_other_animal||bigtext||Other Animal||all||||||||
 +
|-
 +
| Other_antigen||abp_other_antigen||bigtext||Other Antigen||all||||||||
 +
|-
 +
| Possible_pseudonym||abp_possible_pseudonym||bigtext||Possible Pseudonym||all||||||||
 +
|-
 +
| Expr_pattern||style="color: green;"| exp_antibody||multiontology||Antibody_info||EXPRPAT tab2||Antibody||abp_tables||||
 +
|-
 +
| Gene_regulation||style="color: green;"| grg_antibody||multiontology||Antibody_info||GENEREG tab2||Antibody||abp_tables||||
 +
|-
 +
| Reference||abp_paper||multiontology||Reference||all||WBPaper||pap_tables||||
 +
|-
 +
| Remark||abp_remark||bigtext||Remark||all||||||||
 +
|}
 +
 +
 
===Molecule mop_tables===
 
===Molecule mop_tables===
 
{| border="1" cellpadding="2" cellspacing="2" {{table}}
 
{| border="1" cellpadding="2" cellspacing="2" {{table}}

Revision as of 01:05, 4 October 2013

Antibody abp_tables

postgres tables for the Anitbody class
dumper on tazendra at /xiaodong/antibody/use_package.pl
Model tag table type OA label tab ontology_type ontology_table cross table population script comment
pgonly abp_id not a table pgid all* - - -
pgonly abp_timestamp not a table none -
pgonly abp_curator dropdown Curator all - - -
Antibody abp_name text Name all
Summary abp_summary bigtext Summary all
Other_name abp_other_name bigtext Other Name all
Gene abp_gene multiontology Gene all WBGene gin_tables
Original_publication abp_original_publication ontology Original Publication all WBPaper pap_tables
Person not used??
Laboratory abp_laboratory multiontology Laboratory all obo laboratory
Clonality abp_clonality dropdown Clonality all
Antigen abp_antigen dropdown Antigen all
Peptide abp_peptide bigtext Peptide all
Protein abp_protein bigtext Protein all
Source abp_source dropdown Source all
Animal abp_animal dropdown Animal all
Other_animal abp_other_animal bigtext Other Animal all
Other_antigen abp_other_antigen bigtext Other Antigen all
Possible_pseudonym abp_possible_pseudonym bigtext Possible Pseudonym all
Expr_pattern exp_antibody multiontology Antibody_info EXPRPAT tab2 Antibody abp_tables
Gene_regulation grg_antibody multiontology Antibody_info GENEREG tab2 Antibody abp_tables
Reference abp_paper multiontology Reference all WBPaper pap_tables
Remark abp_remark bigtext Remark all


Molecule mop_tables

postgres tables for the Molecule class
dumper on tazendra at karen/Molecule/dump_molecule_ace.pl
Model tag table type OA label tab ontology_type ontology_table cross table population script comment
pgonly mop_id not a table pgid all* - - - WBMol: $molId = &pad8Zeros($newPgid)
pgonly mop_timestamp not a table none - - - -
pgonly mop_curator dropdown Curator all - - - same values in all OA curation tables
Name mop_name text Name all - - - WBMolID -added after tables were built
Public_name mop_publicname bigtext Public_name all - - -
Synonym mop_synonym bigtext Synonyms all - - -
DB_info mop_molecule text MeSH / CTD or default all - - - use MeSh ID here
originally used as Name
DB_info mop_chemi text CasRN all - - -
DB_info mop_chebi ontology ChEBI_id all obo chebi
DB_info mop_kegg text Kegg compound (Acc#) all - - -
Remark mop_remark bigtext Remark all - - -
Reference mop_paper multiontology WBPaper all WBPaper pap_tables -
Molecule_use mop_moleculeuse bigtext Molecule use all - - -
Not in model mop_gotarget multiontology GO target all obo goid -
Not in model mop_genetarget multiontology Gene target all WBGene gin_tables -
DB_info mop_smmid text SMID-DB all - - -
Gene_regulation grg_moleculeregulator multiontology Molecule Regulator GENEREG tab3 Molecule mop_tables -
WBProcess pro_molecule multiontology Molecule PROCESS tab1 Molecule mop_tables -
Phenotype app_molecule multiontology Molecule PHENOTYPE tab2 Molecule mop_tables -
RNAi rna_molecule multiontology Molecule RNAi tab2 Molecule mop_ tables -
Interaction int_otheronetype
int_othertwotype		 dropdown Effected other type
Affected other type		 INTERACTION tab4 - - -
Retrieved from "https://wiki.wormbase.org/index.php?title=All_OA_tables&oldid=20621"