
Data Technologies 249
> sql = paste("SELECT DISTINCT a.go_id AS hgu95av2.go_id ,",
+ "a._id AS hgu95av2._id ,",
+ "g.go_id AS GO.go_id , g._id AS GO._id ,",
+ "g.ontology",
+ "FROM go_bp_all AS a, go.go_term AS g",
+ "WHERE a.go_id = g.go_id LIMIT 10;")
> dataOut = dbGetQuery(mycon, sql)
> dataOut
hgu95av2.go_id hgu95av2._id GO.go_id GO._id
1 GO:0000002 255 GO:0000002 13
2 GO:0000002 1633 GO:0000002 13
3 GO:0000002 3804 GO:0000002 13
4 GO:0000002 4680 GO:0000002 13
5 GO:0000003 41 GO:0000003 14
6 GO:0000003 43 GO:0000003 14
7 GO:0000003 81 GO:0000003 14
8 GO:0000003 83 GO:0000003 14
9 GO:0000003 104 GO:0000003 14
10 GO:0000003 105 GO:0000003 14
ontology
1 BP
2