All work

Making 20,224 hidden microexons searchable

I built the MySQL database and PHP web app behind MEPDB, a public, peer-reviewed resource for plant exons of 51 nucleotides or fewer across 132 genomes.

20,224
microexons served
132
plant genomes covered
51
nucleotides or fewer, the size that makes them easy to miss
MEPDB home page with the microexon search box and the list of conserved cluster IDs.

At a glance

Role
Undergraduate Researcher, Database & Web Development
Organization
Center for Plant Science Innovation, University of Nebraska–Lincoln
Dates
February 2024 – present
Status
Published, publicly available
Stack
MySQL · PHP · JBrowse 2 · JavaScript · LAMP
Hard skills
SQL · PHP · JavaScript · MySQL schema design · JBrowse 2 integration · LAMP stack
Soft skills
Working inside a research group's method · Building for users outside the lab
Why it matters
Plant labs can search and download 20,224 microexons themselves instead of working from a supplementary table.

Problem

A microexon is an exon of 51 nucleotides or fewer. The shortest are only 1 to 15 nucleotides long. At that length, standard genome annotation routinely misses them. Most of the ones this project found were not annotated in the reference genomes at all, which left them invisible to anyone downstream who might have studied them.

The group’s prediction method found 20,224 of them across 132 plant genomes. At that scale the findings become an infrastructure problem. Nobody can use twenty thousand coordinates in a supplementary table.

What I built

The prediction method and the biology are the group’s work, and the paper has four authors. My part was the database and the web app on top of it: the MySQL schema, the PHP back end, the JBrowse 2 integration, and the search and download tools.

For each microexon, the database holds genomic coordinates, nucleotide and amino-acid sequences, the related gene annotations and corrected CDS information that reflects the new annotation. JBrowse 2 feature tracks, which I set up in JavaScript, show each microexon in its genomic context instead of as a row of coordinates.

All of it is searchable across the 132 genomes and exportable in bulk, because a researcher’s next step is almost always to pull a subset into their own pipeline.

How I checked it

The strongest checks came from outside the lab. The paper describes the database itself, and it went through peer review at New Phytologist before publication. Research groups outside the lab now use its search and download workflows.

What happened

MEPDB was published in New Phytologist in 2025 (volume 248, pages 32 to 37), with me as co-first author. On the public site, anyone can look up a microexon, see it in its genomic context and download its sequences and corrected CDS.

Evidence