Depends what type of 'aggression' you mean. For general meanness you're probably looking at a big cichlid (flowerhorn, dovii, anything like that) that can usually only be kept on their own. But they can come off worse (theoretically) in fights with other types of fish like snakeheads because they would try to lip-lock and can get their face ripped off.
For ruthlessness and killing ability, some snakeheads are pure killers and will rip fish apart just because.
Other things like arowana, gars etc can be peaceful for years but then suddenly change their mind, or tolerate some tankmates but destroy others.
Payara have beastly teeth and are unpredictable, and wolf fish (sometimes known as 'piranha eaters') are amazing hunters but otherwise can just sit there doing nothing all day.
Tiger fish including the goliath are awesome in the wild, but, like gars, quite often freak out at being in a tank and end up throwing themselves into the glass or jumping out.
Only snakehead I know of to beat a full grown male dovii or a jaguar would be the red snakehead (giant snakehead) iv got 3 rainbow snakeheads and my mates got 5 assam (i think thats what there are) snakeheads that grow larger than mine and neither would stand a chance. Larger arowanas are mean too
A reminder of the Goliath Tigerfish Jeremy Wade caught, which sadly was offered to a local tribe, as it sustained a massive head trauma while being reeled in and died (something that upset Jeremy, but at least it fed a village)...