Generally, you would use a cotton 50 wt thread for piecing. The cotton can take the high heat of an iron and the 50 wt is good for keeping the 1/4" seam true. When quilting you can go from a 60 wt (for texture or when you don't want to see the thread) to 30 wt or thicker (when you want to see the quilting).
Ricci