@Chris_Hemmerich --- you will need to cast your numeric data to numeric types in order to use those SQLite comparison operators. Check out this post for an example. Without a CAST, those values are actually being compared as strings --- this means your greater than and less than operators are probably using the string length, instead of the numeric value. Give that a shot and let us know how it goes! 
PS - you might also need to experiment with quoting your column names in the query --- check out the sqlite.org docs for more info. Also, I didn't see any examples of scientific notation in either of your examples, just ordinary real numbers in decimal representation.