At the risk of mudding the already murky waters, the tensions are not just between science and religion. Even if you are a deist, there is a tension between god as revealed in a book that is a few thousand years old (though edited in various ways a lot more recently), or a god as revealed in the wonders of DNA, nuclear physics and so forth. Which 'has the last word' is just as important to them.