My mesh looks torn with little holes when it's transparent but totally fine when opaque. Any idea what could be causing this and how to fix? EDIT: none of the holes are visible in edit mode, only if the object is transparent in object mode. Thanks!

Here I have some images. All are in object mode without any modifiers at all.

Transparency: https://imgur.com/a/L3KDbxZ

No transparency: https://imgur.com/a/NwJQZUB

Again, no holes are visible at all in edit mode and are only visible when the object is transparent in object mode.