All OA tables

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	-	-	-