Which plants are most represented by patents?

As we looked at the different plant patents that have been granted, we started to wonder which genera are most represented.

This was pretty easy to do with a simple database query; we get a total for the first word (genus) of all plant names that start with the letters ‘A’ through ‘Z’ (which eliminates greges and the like).

mysql> SELECT COUNT(sci_name) AS total, SUBSTRING_INDEX(sci_name, ' ', 1) AS name FROM patent WHERE sci_name REGEXP '^[A-Z]' GROUP BY name ORDER BY total DESC LIMIT 50;
+-------+---------------+
| total | name          |
+-------+---------------+
|   742 | Rosa          |
|   613 | Chrysanthemum |
|   433 | Prunus        |
|   420 | Pelargonium   |
|   323 | Impatiens     |
|   317 | Petunia       |
|   265 | Calibrachoa   |
|   226 | Osteospermum  |
|   200 | Verbena       |
|   173 | Euphorbia     |
|   165 | Hydrangea     |
|   140 | Hibiscus      |
|   134 | Fragaria      |
|   131 | Begonia       |
|   130 | Echinacea     |
|   125 | Malus         |
|   121 | Dianthus      |
|   118 | Dahlia        |
|   115 | Phlox         |
|   109 | Alstroemeria  |
|   108 | Heuchera      |
|   108 | Vitis         |
|   100 | Kalanchoe     |
|    97 | Vaccinium     |
|    95 | Mandevilla    |
|    92 | Nemesia       |
|    81 | Clematis      |
|    78 | Rhododendron  |
|    70 | Argyranthemum |
|    69 | Sedum         |
|    68 | Lobelia       |
|    68 | Coreopsis     |
|    66 | Hosta         |
|    65 | Rubus         |
|    63 | Lantana       |
|    62 | Lavandula     |
|    61 | Salvia        |
|    60 | Diascia       |
|    57 | Helleborus    |
|    55 | Phalaenopsis  |
|    55 | Campanula     |
|    53 | Angelonia     |
|    52 | Aster         |
|    49 | Lilium        |
|    49 | Sutera        |
|    47 | Veronica      |
|    41 | Torenia       |
|    40 | Gerbera       |
|    38 | Citrus        |
|    38 | Caladium      |
+-------+---------------+
50 rows in set (0.02 sec)

So, there you have it. Those are the 50 most popular genera to receive patents in the last decade.

What do you want to know about plant patents? Let us know in the comments and we’ll look it up. Or maybe we can make a tool that you can use regularly.

Leave a Reply

Your email address will not be published. Required fields are marked *