The Sigma lens you listed is not a MACRO lens.
It can "close focus" down to 17.7 inches.
Which means you can put the front of the lens as close as 17.7 inches from the object you are photographing, but no closer.
The Tamron can "close focus" down to 37.4 inches.
and it has MACRO capability of 1:3.1, which means something that is 1 inch square will be seen as being about 1/3 inch square.
then click the "specifications" tab.
A Prime lens will magnify more than a zoom lens.
Some are rated 1:1, which means something 1" square will be seen as being 1" square.
The definitions of Prime(Standard) lens, Telephoto lens, Macro lens, and Zoom lens and their uses are well documented. However, what is this Zoom lens with the "Macro" word ? How is it different from a "Pure" Macro lens or a "Pure" Zoom lens ? How is it used for ? [e.g. Sigma 18-200mm f/3.5-6.3 DC OS HSM as against Tamron SP AF 70-200mm F2.8 Di LD (IF) MACRO ?