Weak antiferromagnetism in the metallic phases of layered cuprates