prikaz prve stranice dokumenta Izrada SQL upita za analizu bioloških podataka
  Download
PDF 1.71 MB
master's thesis
Izrada SQL upita za analizu bioloških podataka
Zagreb: University of Zagreb, Faculty of Food Technology and Biotechnology, 2019. urn:nbn:hr:159:087957
Plec, Andrea
University of Zagreb
Faculty of Food Technology and Biotechnology
Department of Biochemical Engineering
Section for Bioinformatics

Institutional repository: Repository of the Faculty of Food Technology and Biotechnology

Cite this document

Plec, A. (2019). Izrada SQL upita za analizu bioloških podataka (Master's thesis). Zagreb: University of Zagreb, Faculty of Food Technology and Biotechnology. Retrieved from https://urn.nsk.hr/urn:nbn:hr:159:087957

Plec, Andrea. "Izrada SQL upita za analizu bioloških podataka." Master's thesis, University of Zagreb, Faculty of Food Technology and Biotechnology, 2019. https://urn.nsk.hr/urn:nbn:hr:159:087957

Plec, Andrea. "Izrada SQL upita za analizu bioloških podataka." Master's thesis, University of Zagreb, Faculty of Food Technology and Biotechnology, 2019. https://urn.nsk.hr/urn:nbn:hr:159:087957

Plec, A. (2019). 'Izrada SQL upita za analizu bioloških podataka', Master's thesis, University of Zagreb, Faculty of Food Technology and Biotechnology, accessed 28 April 2024, https://urn.nsk.hr/urn:nbn:hr:159:087957

Plec A. Izrada SQL upita za analizu bioloških podataka [Master's thesis]. Zagreb: University of Zagreb, Faculty of Food Technology and Biotechnology; 2019 [cited 2024 April 28] Available at: https://urn.nsk.hr/urn:nbn:hr:159:087957

A. Plec, "Izrada SQL upita za analizu bioloških podataka", Master's thesis, University of Zagreb, Faculty of Food Technology and Biotechnology, Zagreb, 2019. Available at: https://urn.nsk.hr/urn:nbn:hr:159:087957

Metadata
TitleIzrada SQL upita za analizu bioloških podataka
Title (english)Building SQL queries for biological data analysis
AuthorAndrea Plec
MentorJanko Diminić (mentor)
GranterUniversity of Zagreb
Faculty of Food Technology and Biotechnology
(Department of Biochemical Engineering)
(Section for Bioinformatics)
Zagreb
Defense date and country2019-12-12, Croatia
Scientific / art field,
discipline and subdiscipline		BIOTECHNICAL SCIENCES
Biotechnology
Abstract
Zahvaljujući mnogim istraživanjima, crijevna mikrobiota se pokazala kao važna komponenta fiziologije čovjeka s kojim živi u mutualističkom odnosu. S obzirom da je riječ o kompleksnoj zajednici mikroorganizama na čiji sastav utječu mnogobrojni unutarnji i vanjski čimbenici, svaki pojedinac posjeduje jedinstveni sastav crijevne mikrobiote. Disbioza crijevne mikrobiote može dovesti do raznih upalnih i metaboličkih poremećaja, što može rezultirati bolestima. Utvrđivanje sličnosti i razlika među zdravim i bolesnim skupinama pojedinaca pruža mogućnost određivanja povezanosti sastava crijevne mikrobiote s tim poremećajima i bolestima. U tu svrhu se provodi sekvenciranje mnogobrojnih uzoraka crijevne mikrobiote, a dobivena očitanja se zatim bioinformatički obrađuju te se rezultati pohranjuju u baze podataka. U ovom radu je u sklopu računalnog paketa MySQL korištena baza podataka koja sadrži brojnosti pojedinih taksona za 1639 uzoraka crijevne mikrobiote. Korištenjem računalnog jezika SQL izrađeni su pohranjeni postupci za analizu raznolikosti sastava pojedinih uzoraka i procjenu prosječnog sastava za sve uzorke.
Abstract (english)
According to numerous studies, gut microbiota lives in a mutualistically beneficial relationship with humans and has proven to be an important component of their physiology. Each individual has a unique gut microbiota composition, given that it’s a complex community of microorganisms whose composition is affected by many internal and external factors. Dysbiosis of the gut microbiota can lead to various inflammatory and metabolic disorders, which can result in illness. Determining similarities and differences among healthy and affected cohorts provides an opportunity to establish correlations between gut microbiota composition and various afflictions. Such research requires sequencing of numerous intestinal microbiota samples. The acquired sequence reads are then bioinformatically processed and the results are stored in databases. In order to build several stored procedures using SQL, a database containing taxa abundance of 1639 gut microbiota samples was used. The stored procedures were built within MySQL database management system, and used to analyze the composition diversity of individual samples and to estimate the average composition for all samples.
Keywords
Keywords (english)
Languagecroatian
URN:NBNurn:nbn:hr:159:087957
Study programmeTitle: Molecular Biotechnology
Study programme type: university
Study level: graduate
Academic / professional title: magistar/magistra inženjer/inženjerka molekularne biotehnologije (magistar/magistra inženjer/inženjerka molekularne biotehnologije)
Type of resourceText
File originBorn digital
Access conditionsOpen access
Terms of useLicence Attribution-NoDerivatives 4.0 International (CC BY-ND 4.0) icon
Created on2020-01-28 12:06:09