Difference between revisions of "All OA tables"

From WormBaseWiki
Jump to navigationJump to search
m
m
Line 1: Line 1:
 
===Antibody abp_tables===
 
===Antibody abp_tables===
−
{| border="1" cellpadding="2" cellspacing="2" {{table}}
+
'''postgres tables for the Antibody class<br> dumper on tazendra at /xiaodong/antibody/use_package.pl '''
−
|+'''postgres tables for the Anitbody class<br> dumper on tazendra at /xiaodong/antibody/use_package.pl '''  
+
{| border="1" cellpadding="2" cellspacing="2" {{table}}
 
| align="center" style="background:#f0f0f0;"|'''Model tag'''
 
| align="center" style="background:#f0f0f0;"|'''Model tag'''
 
| align="center" style="background:#f0f0f0;"|'''table'''
 
| align="center" style="background:#f0f0f0;"|'''table'''
Line 28: Line 28:
 
| Original_publication||abp_original_publication||ontology||Original Publication||all||WBPaper||pap_tables||||
 
| Original_publication||abp_original_publication||ontology||Original Publication||all||WBPaper||pap_tables||||
 
|-
 
|-
−
| style="color: grey;"| Person ''not used??''||||||||||||||||
+
| style="color: grey;"| Person ''(not used??)''||||||||||||||||
 
|-
 
|-
 
| Laboratory||abp_laboratory||multiontology||Laboratory||all||obo||laboratory||||
 
| Laboratory||abp_laboratory||multiontology||Laboratory||all||obo||laboratory||||
Line 59: Line 59:
 
|}
 
|}
  
 +
===Concise description con_tables===
 +
 +
'''postgres tables for Concise descriptions<br> dumper on tazendra at /kimberly/citace_upload/concise/wrapper.pl and /home/postgres/work/citace_upload/concise/dump_concise.pl '''
 +
 +
{| border="1" cellpadding="2" cellspacing="2" {{table}}
 +
| 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||con_id||not a table||pgid||all*||-||-||-||
 +
|-
 +
| style="color: grey;"| pgonly||con_timestamp||not a table||none||||-||||||
 +
|-
 +
| style="color: grey;"| pgonly||con_curator||dropdown||Curator||all||-||-||-||
 +
|-
 +
| Gene||con_wbgene||ontology||WBGene||all||WBGene||gin_tables||||
 +
|-
 +
| ||con_curhistory||ontology||Curator History||all||Concurhst||||||
 +
|-
 +
| Structured_description||con_desctype||dropdown||Description Type||all||||||||
 +
|-
 +
| ||con_desctext||textarea||Description Text||all||||||||cols_size =90, rows_size=12
 +
|-
 +
| ||con_paper||multiontology||Reference||all||WBPaper||pap_tables||||
 +
|-
 +
| ||con_accession||text||Accession Evidence||all||||||||
 +
|-
 +
| ||con_lastupdate||text||Last Updated||all||||||||
 +
|-
 +
| ||con_comment||bigtext||Comment||all||||||||
 +
|-
 +
| ||con_nodump||toggle||NO DUMP||all||||||||
 +
|-
 +
| ||con_person||multiontology||Person||all||WBPerson||?||||
 +
|-
 +
| ||con_exprtext||text||Expression Pattern||all||||||||
 +
|-
 +
| ||con_rnai||text||RNAi||all||||||||
 +
|-
 +
| ||con_microarray||text||Microarray||all||||||||
 +
|}
  
 
===Molecule mop_tables===
 
===Molecule mop_tables===
 +
'''postgres tables for the Molecule class<br> dumper on tazendra at karen/Molecule/dump_molecule_ace.pl'''
 +
 
{| border="1" cellpadding="2" cellspacing="2" {{table}}
 
{| border="1" cellpadding="2" cellspacing="2" {{table}}
−
|+'''postgres tables for the Molecule class<br> dumper on tazendra at karen/Molecule/dump_molecule_ace.pl'''
 
 
| align="center" style="background:#f0f0f0;"|'''Model tag'''
 
| align="center" style="background:#f0f0f0;"|'''Model tag'''
 
| align="center" style="background:#f0f0f0;"|'''table'''
 
| align="center" style="background:#f0f0f0;"|'''table'''

Revision as of 01:35, 4 October 2013

Antibody abp_tables

postgres tables for the Antibody 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

Concise description con_tables

postgres tables for Concise descriptions
dumper on tazendra at /kimberly/citace_upload/concise/wrapper.pl and /home/postgres/work/citace_upload/concise/dump_concise.pl

Model tag table type OA label tab ontology_type ontology_table cross table population script comment
pgonly con_id not a table pgid all* - - -
pgonly con_timestamp not a table none -
pgonly con_curator dropdown Curator all - - -
Gene con_wbgene ontology WBGene all WBGene gin_tables
con_curhistory ontology Curator History all Concurhst
Structured_description con_desctype dropdown Description Type all
con_desctext textarea Description Text all cols_size =90, rows_size=12
con_paper multiontology Reference all WBPaper pap_tables
con_accession text Accession Evidence all
con_lastupdate text Last Updated all
con_comment bigtext Comment all
con_nodump toggle NO DUMP all
con_person multiontology Person all WBPerson ?
con_exprtext text Expression Pattern all
con_rnai text RNAi all
con_microarray text Microarray 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=20624"