The nature of the unresolved extragalactic cosmic soft X-ray background