Delaware Microbiome Mapping and Database Development

Submission information

Submission Number: 135

Submission ID: 239

Submission UUID: 4c325773-0029-4aa2-9fd8-27cc8fdf75b9

Submission URI: /form/project

Created: Thu, 01/20/2022 - 23:11

Completed: Thu, 01/20/2022 - 23:11

Changed: Wed, 01/04/2023 - 15:25

Remote IP address: 128.175.160.119

Submitted by: Christina Callahan

Language: English

Is draft: No

Webform: Project

Project Title Delaware Microbiome Mapping and Database Development

Program CAREERS

Project Image {Empty}

Tags {Empty}

Status Halted

Project Leader

Project Leader Christina Callahan

Email tina.callahan@udel.edu

Mobile Phone {Empty}

Work Phone {Empty}

Project Personnel

Mentor(s) {Empty}

Student-facilitator(s) {Empty}

Mentee(s) {Empty}

Project Information

Project Description As part of CEMA's work with the NSF EPScoR Project WiCCED, we are interfacing with projects that require help with data hosting and web visualizations. This project is aimed at ingesting microbial analytics from soil samples taken in locations throughout Delaware by citizens into a database that will support a web app that will be used to share “status” updates to researchers and the general public participating in citizen science. Each soil sample is analyzed and summaries of the microbial analyses are then shared back with the citizen scientists and other researchers to help understand patterns of microbial distribution and function in the environment.

Project Tasks Include:
* Scripting for data ingest into and update data in a PostgreSQL database:
-- Parsing CSV using Python (or another language)
-- Connecting to the database (getting, inserting, and update data)
* Leveraging the data into a web application:
-- Creating a web service that queries the database and returns JSON for web display
-- Developing maps and linked queries from web service to visualize data
* Project and Code Documentation

Project Information Subsection

Project Deliverables {Empty}

Student Research Computing Facilitator Profile -scripting for data management and manipulation (ex. Python, R, etc.)
-web development (ex. HTML, javascript, php, etc.)
-web mapping (ex. GIS, GoogleMaps, Openlayers, etc.)
-familiarity with Linux or Unix OS and basic shell scripting
-familiarity with GitHub (or other code repository)
-time management and organizational skills

Mentee Research Computing Profile {Empty}

Student Facilitator Programming Skill Level {Empty}

Mentee Programming Skill Level {Empty}

Project Institution University of Delaware

Project Address {Empty}

Anchor Institution CR-University of Delaware

Preferred Start Date {Empty}

Start as soon as possible. No

Project Urgency Already behind3Start date is flexible

Expected Project Duration (in months) 3

Launch Presentation {Empty}

Launch Presentation Date {Empty}

Wrap Presentation {Empty}

Wrap Presentation Date {Empty}

Project Milestones

Milestone Title: Scripting for data ingest into and update data in a PostgreSQL database:
Milestone Description: -- Parsing CSV using Python (or another language)
-- Connecting to the database (getting, inserting, and update data)
Milestone Title: Leveraging the data into a web application:
Milestone Description: -- Creating a web service that queries the database and returns JSON for web display
-- Developing maps and linked queries from web service to visualize data
Milestone Title: Project and Code Documentation

Github Contributions {Empty}

Planned Portal Contributions (if any) {Empty}

Planned Publications (if any) {Empty}

What will the student learn? {Empty}

What will the mentee learn? {Empty}

What will the Cyberteam program learn from this project? {Empty}

HPC resources needed to complete this project? {Empty}

Notes {Empty}

Final Report

What is the impact on the development of the principal discipline(s) of the project? {Empty}

What is the impact on other disciplines? {Empty}

Is there an impact physical resources that form infrastructure? {Empty}

Is there an impact on the development of human resources for research computing? {Empty}

Is there an impact on institutional resources that form infrastructure? {Empty}

Is there an impact on information resources that form infrastructure? {Empty}

Is there an impact on technology transfer? {Empty}

Is there an impact on society beyond science and technology? {Empty}

Lessons Learned {Empty}

Overall results {Empty}