All OA tables

abp_tables Antibody

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

con_tables Concise description

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

mop_tables Molecule

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

• all in Tab column means the field exists in all tabs, or that there is only one tab in the OA.

&all fields have a corresponding postgres history table