Near- and mid-IR ultrashort laser pulse filamentation in a molecular atmosphere: a comparative analysis