fix up ids of role importances
remove extraneous join
add a subtype by default