MySQL SELECT ... FOR UPDATE causing table lock during high traffic while generating sequential transaction IDs
Allocate numeric sequence values in a fast, separate atomic operation (use an auto-increment/sequence or short INSERT) and then use that value to build TXN codes to avoid long locks.
Semantic design of functional de novo genes from a genomic language model - Nature
Genomic language models learn gene functional relationships from genomic context to generate sequence-diverse genes that preserve essential amino acid residues while exploiting nucleotide diversity.