If there is always only ONE user doing this, you could use
last.microarrayid = gen_id(microarray_id_gen, 0);
but it is much safer to use your obtained new.microarrayid
from previous new.microarrayid = gen_id(microarray_id_gen, 1);
fort all your sub-table inserts.