gop_ postgres table name
|
GPAD 2.0 column
|
Action
|
Example
|
gop_wbgene |
1 |
Preface each value with 'WB:' |
WB:WBGene00006925
|
gop_qualifier |
2 |
Add text string "NOT" (Note: an OA query for "NOT" didn't return any values, so I don't think we actually have any of these in the OA.) |
NOT
|
gop_qualifier |
3 |
Map text value to Relations Ontology (RO) term id (see below); add RO id. |
RO:0001025
|
gop_goid |
4 |
Add GO term id. |
GO:0051306
|
gop_accession |
5 |
Add id as it exists in table. |
GO_REF:0000015
|
gop_paper |
5 |
Add WBPaper ID and corresponding PMID, pipe separated. |
PMID:10978280|WB:WBPaper00004310
|
gop_goinference |
6 |
Map three-letter GO code to ECO code (see below); add ECO id. |
ECO:0000314
|
gop_with_gene |
7 |
Preface each value with 'WB:'; comma-separate multiple values |
WB:WBGene00000001
|
gop_with_other |
7 |
Add id as it exists in table; comma-separate multiple values |
FB:FBgn0003719
|
gop_with_phenotype |
7 |
Add id as it exists in table; comma-separate multiple values |
WBPhenotype:0000689
|
gop_with_rnai |
7 |
Preface each value with 'WB:'; comma-separate multiple values |
WB:WBRNAi00001974
|
gop_with_variation |
7 |
Preface each value with 'WB:'; comma-separate multiple values |
WB:WBVar00242156
|
?? |
8 |
Not sure if we have any values for an interacting taxon. |
??
|
gop_last_updated |
9 |
If YYYY-MM-DD, add as exists in table. If YYYY-MM-DD HH:MM:SS convert to: YYYY-MM-DDTHH:MM |
2020-05-13 or 2006-02-03T12:26
|
no OA table |
10 |
Add WB |
WB
|
gop_xref |
11 |
Convert relation name to RO id, add parenthetical value. |
RO:0002233(WB:WBGene00000584)
|