Japanese means it's a game released in Japan in that language. You most likely won't be able to play it unless you know Japanese.
Hacked probably means it's a ROM hack. Not entirely sure on that one.
Translated means the game has been translated from another language to English.
Prototypes are basically just Prototypes of certain games - some of which never got a full release. Star Fox 2 has a prototype (And a full release) though.
Unlicensed means the game was released unofficially on its home system without support or knowledge from the console manufacturer. This is usually an indicator of poor quality though.
"NintenDON'T sue me please haha"