A common type of bacteria has been found to make some cancers "melt", according to researchers.