Dear expert,
Suppose I have the following two tables:
--- TABLE_A ----
+------------------------------------------------------------------
+ GO_Term | GO_Id | Gene ID
+---------------------------------------------------------------------
biological_process GO:0008150 814629
biological_process GO:0008150 814631
molecular_function GO:0003674 814631
.............................etc ..........................
+----------------------------------------------------------------
--- TABLE_B ----
+------------------------------------------------------------------
+ Gene_Symbol | Gene ID
+---------------------------------------------------------------------
AT2G01050 814629
AT2G01031 814631
PF14_0640 812222
..............................etc ..........................
+----------------------------------------------------------------
How can one construct a sql command so that:
1. Given GO_Term or GO_Id as Input
2. Obtain their respective Gene_Id
3. For each their Gene_Id finally return their Gene_Symbol.
Note that in Table A, the same GO_Term/GO_Id may contain
different Gene_ID.
Thanks and hope to hear from ...
Bookmarks