Skip to Main Content
R Programming for Bioinformatics
book

R Programming for Bioinformatics

by Robert Gentleman
July 2008
Intermediate to advanced content levelIntermediate to advanced
328 pages
10h 53m
English
Chapman and Hall/CRC
Content preview from R Programming for Bioinformatics
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
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Computation in BioInformatics

Computation in BioInformatics

S. Balamurugan, Anand T. Krishnan, Dinesh Goyal, Balakumar Chandrasekaran, Boomi Pandi
R for Data Science Cookbook (n)

R for Data Science Cookbook (n)

Prabhanjan Narayanachar Tattar, Yu-Wei, Chiu (David Chiu)

Publisher Resources

ISBN: 9781420063677