To support the weight of an aquarium your legs will need to be cross braced. 4x4's will handle the downward force with no problem but small metal brackets wont handle the twisting forces very effectively.
Usually the twisting forces are are handled by firmly attached plywood panels. If you want an open bottom stand cross bracing is a good solution.