Obama's relevance hangs on Dem showing in midterms