SELECT sample_no FROM samples
SELECT genus FROM register WHERE register_no IN (26346,55904,40185,47642,20907,26948,89694,54218,54389,29498) AND species REGEXP '^[a-z]*$'
The Ecological Register

The Ecological Register is a repository for published lists and counts of plants and animals from individual locations around the world. It is intended for use by ecologists and students who want quick and simple access to spatially localized species abundance distributions, and is particularly useful for macroecological studies of diversity patterns.

Data are entered over the web by professional researchers with an interest in ecology. The site is hosted by the Australian Astronomical Optics group at Macquarie University. It is administered by John Alroy, and technical support is provided by Simon O'Toole at AAO.

Right now, you can use the site to view individual ecological samples, species, or references to the papers that were consulted. All of the Register data can be downloaded, and there is a a stand-alone size measurement download form. You can explore the data by using graphs to compare samples, making scatter plots, and creating biogeographic maps. And you can view maps of samples that indicate species richness with point colours. Major groups include:

There are also global fossil vertebrate data for the Pleistocene and Holocene, plus European data for the Eocene, Oligocene, Miocene, and Pliocene.

The Register is intended to complement databases such as GBIF, PREDICTS, the Mammal Community Database, AmphibiaWeb, FishBase, and NOW that are related intellectually but have very different scopes and purposes.