Home › Programs › Long Term Agricultural Research › Microbial Ecology › The Plant-Microbial Database (PMD) ›

Plant-Microbial Database (PMD)

Tags:

The Plant-Microbial Database (beta version) is a project-management database being developed to facilitate sample tracking and data management for research investigating plant-associated microbial interactions.

It will be useful for many kinds of plant and microbiology research that involve maintaining strain information, cloning, and sequencing data.

Features:

  • Simple interface requires minimal database experience to use
  • Data entry forms allow users to maintain accurate records of plant, microbial, and soil samples from which individual microbes are isolated or DNA is extracted.  These records may include the geographic coordinates from which samples were collected.
  • Plant, soil, fungal isolate, and bacterial isolate samples may all be documented, inventoried, and related to subsequent DNA, amplicon, clone, or sequence data.
  • Data outputs from popular pyrosequencing pipelines can imported for initial data review, or transferred to an SQL Server for long term data archival.

Planned Additions:

  • Query interface with pull down menus to address a variety of common queries
  • Automated submission forms for public sequence databases, including CAMERA.
Download Instructions:
  1. Double-click the link, "Download Database", and click "Save". Choose a location to save the file. Save the file to a known location on your computer, for example, the desktop or a new folder.
  2. Unzip the saved file to a known location on your computer.
  3. Double-click "PM db…*.mdb". Click "Open" in the Security Window. The program will open in Microsoft Access (requires Access 2003 or higher).
  4. Download the “Instructions (.docx or pdf)” for a general overview on how to get started, or just open the database and begin exploring the various features.
  5. If you have any problems, please contact Ruth Sedillo at rusedill@nmsu.edu or 575-646-3584.

 

The Plant-Microbial Database will be updated from time to time to meet local needs, and, as resources permit, to accommodate suggestions from outside users.  Suggestions for future enhancements should be directed to Ruth Sedillo (rusedillo@nmsu.edu).

Can the Database be Altered? Yes, but…

  • Users with Access experience can readily add queries, reports, and other features. These features will not transfer to new database versions, but will have to be manually added. 
  • User-generated structural changes, such as additions of new data fields or alteration of field restrictions, will prevent users from importing data into newer versions. 

 

**Click here to register for our mailing list and we will notify you about new versions**

 

Mention of trade names or commercial products in this webpage is solely for the purpose of providing specific information and does not imply recommendation or endorsement by the U.S. Department of Agriculture.

Acknowledgements. This database was developed by Barry Lavine, Independent Consultant (blavine@usa.net) to meet data management needs defined by Mary Lucero and Ruth Sedillo, with occasional input from other collaborators. Ken Ramsey developed and maintains a locally compatible SQL database, and provided the instructions for interfacing with SQL. The pyrosequencing data import function utilizes data formats as provided by Research and Testing Labs, LLC in Lubbock Texas in spring of 2010.

  • Share this