Difference between revisions of "All OA tables"
From WormBaseWiki
Jump to navigationJump to searchm (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
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
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 | - | - | - |