Dissimilatory nitrate reduction results in the production of gaseous products, while assimilatory nitrate reduction results in the production of ammonia for biosynthesis.