In fairness I am not an expert of Qiime2R, I would start from this tutorial:
I may have mislead also, (sorry for that) you still to import the metadata file in R by read.table() command, but you should be good to go!
When you say 'the column sample id is missing in your data' in which qza file are you looking for it?
Cheers
Luca