In SQL you use double-quotes around column names not strings (like most other languages). To create a string value you need to use single-quotes. E.g.

SELECT *
FROM miseq_results
WHERE well = 'A01'