I am not an expert but I thought this would help... just what I did a long time ago when I was flying Air Warrior...
Please take a look at this table:

Data for this table was borrowed from:
Emmanuel Gustin's Extensive Military Aircraft Database
Vermillion's Website
R. Shaw, Fighter Combat, ISBN 0-87021-059-9
J. Horikoshi and M. Okumiya, Reisen, A small history of the Japanese Naval Aviation, ISBN4-257-79028-8
Magazine Maru Editorial Department, Shiden, Shidenkai, and Type94 Float Plane, ISBN4-7698-0631-0
I took the data from Emmanuel Gustin's Extensive Military Aircraft Database first and then filled the missing parts from Vermillion's Website like the information on explosives and the projectile weight for the Ho-5 cannon. I also used the information on TNT as Vermillion presented which stated that the amount of TNT is proportional to the weight of the projectile. However, I notice that Vermillion's website has moved elsewhere.
Well, depending on the type of projectile it is, the proportion would vary I suppose, together with the type of explosive. But assuming that each of these guns had similar projectiles for the sake of comparison, this table might be of benefit.
I noticed that the energy given off by the explosive is quite high in comparison to the kinetic energy of the projectile itself. Given the distance the projectile has to travel (and the loss of kinetic energy), the energy of the explosive will become more pronounced, I think.
Lastly, if anyone could enlighten me... I believe the table that Hazed posted comes from Mr. R. Shaw's book, Fighter Combat. There, I notice that the lethality is not calculated in the form of kinetic energy, but a formula something close to it. Is this an accepted method of calculating lethality or are there other methods for this?
Just wondering and my two cents on this issue...