Spiral magnetic order and pressure-induced superconductivity in transition metal compounds