Dwemer ingots are required to make Dwemer Swords. They are acquired by melting Dwemer artifacts.

The Dwemer Autoblade is a weapon from the "Dwemer Autoblade" mod by acey195 on the Skyrim Nexus.

The closest you get to a full answer is from the last living Dwemer, Yagrum Bagarn who can be found in The Elder Scrolls III: Morrowind. After you give him a few Dwemer books, he concludes that the Dwemer chief architect Kagrenac somehow tied the Dwemer race's very essence to the Heart of Lorkhan, said to be the very heart of the god who created the world The Elder Scrolls takes place on.

During a battle against the Chimer, who moved to wipe out the Dwemer forever, Kagrenac tried to use his 'profane tools', Wraithguard, Keening and Sunder, on the heart, to animate a giant brass golem as a new god, Numidium. What happened was simulataneously, every Dwemer simply vanished from the face of Nirn, except Bagarn, who claims he was in 'the outer realms' at the time.

Whether the Dwemer were annihilated, or ascended, has not been revealed.

In Odrosal, Dwemer Training Academy

Their race was forced to ask for protection from the Dwemer, who turned them into blind, degenerate slaves by feeding them poisonous fungi. The Dwemer eventually all disappeared, but the Falmer remain, broken and bitter, raging against the surface races.