Kevinmcgee:

User:Kevinmcgee

2015-05-18T17:03:35Z

Kevinmcgee:

=Kevin McGee=

==Contact Information==

===Address===

8020 Cowan Avenue,
Los Angeles, CA, 90045

===Email Address===

kmcgee3@lion.lmu.edu

==Education==

===August 2012-Present===

[http://www.lmu.edu Loyola Marymount Universtiy]

#Bachelors of Science of Biology
#*Expected Year of Graduation: 2016
#*Upper Division Biology Courses:
#**Biological Databases
#**Marine Biology
#**Physiology of Disease
#**Urban Ecology
#**Plant Interactions

===Independent Research===
*Two semesters of research have been completed with the guidance of Dr. Dahlquist at Loyola Marymount University
*"Creating and Exporting a Combined GenMAPP Gene Database for ''Leishmania major'' and ''Leishmania infantum'' "

==Work Experience==

#Classroom Support Office
#*August 2013-Present
#*Field Technician
#*Responsible for responding to problems that teachers and students run into with the classrooms during class time
#*This includes all functions and connections of the computer, the projector, sound, laptops, etc.
#*Also included maintenance of the classroom (number of desks, markers and erasers, etc.)

==Extra Curricular Work==
*The Crimson Circle
**On Campus Service Organization at Loyola Marymount University. Complete service on campus and in communities around Los Angeles

==Personal Interests/Hobbies==

#Anaheim Sports teams (Angel's Baseball and Duck's Hockey)
#Surfing
#Hiking
#Camping
#Television Shows
#*Breaking Bad
#*Game Of Thrones
#*Sons of Anarchy

[[New Wiki Page]]

Click here for a link to the [https://xmlpipedb.cs.lmu.edu/biodb/fall2013/index.php/Week_1 Week 1 Assignment page]

Click here for a link to the [https://xmlpipedb.cs.lmu.edu/biodb/fall2013/index.php/Class_Journal_Week_1 Week 1 Journal]

[[Category: User Page]]
[[Category: Individual Homework]]

Click here for a link to my full resume [[media:Resume.pdf]]

==Assignments==

[[template:Kevin]]

{{template:Kevin}}



[[User:Kevinmcgee|Kevinmcgee]] ([[User talk:Kevinmcgee|talk]]) 20:09, 3 September 2013 (PDT)

Final Project Deliverables

2013-12-13T22:39:52Z

Final Project Deliverables

2013-12-13T22:28:34Z

Kevinmcgee: Added Map

:GenMAPP Gene Database for assigned species (.gdb): [[Media:LeishmaniaGDB Lena Gabe 20131205.zip]]
:ReadMe file to accompany the Gene Database (.pdf): [[Media:ReadMe Leishmania 20131212.pdf]]
:Gene Database Testing Report for final submitted Gene Database (print from wiki to .pdf file): [[Media:Leishmania Gene Database Testing Report.pdf]]
:Processed and analyzed DNA microarray dataset (.xls): [[File:L.majorStats.xls]],[[Media:L.infantumStats_B.xls]]
:GenMAPP Expression Dataset file (.gex): [[Media:LeishmaniaCompiledStatAnalysisLMJFiltered(B).gex]]
:Filtered MAPPFinder Results (.xls)
:Sample MAPP file of a relevant biological pathway for your species (.mapp)[[Arromatic_Compound_Catabolic_Process_Comparative_Pathway_Map.mapp]]
:Group Report describing the creation of the Gene Database and the biological analysis of the data (.doc or .pdf)
:PowerPoint presentation (.ppt, given on Thursday, December 12): [[Media:Leishmania PowerPoint 12122013.pdf]]

File:Arromatic Compound Catabolic Process Comparative Pathway Map.mapp

2013-12-13T22:27:49Z

Kevinmcgee:

Kevin McGee Assessment and Reflection

2013-12-12T06:33:29Z

Kevinmcgee: Created page with "Statement of Work Describe exactly what you did on the project. Kevinmcgee Week 10 # #*I used the PubMed database to find the reference geneome of Leishmania Major. #*I se..."

Statement of Work
Describe exactly what you did on the project.
[[Kevinmcgee Week 10]]
#
#*I used the PubMed database to find the reference geneome of Leishmania Major.
#*I searched with the terms "Leishmania Major [MeSH Terms] AND Genome [Title]"
#*The search terms came back with 30 articles
#*The 9th article was titled: ''The Genome of the kinetoplastid parasite, Leishmania Major'' (Ivens et al., 2005) This is the reference genome.
#*[http://www.ncbi.nlm.nih.gov/pubmed/16020728 Link to Article Online]
#
#*On Web of Science, I searched using the search terms "Leishmania Major" for the Title and "Ivens AC" for the author.
#*I got 7 article results back from my search terms. The 1st article was the reference genome that I found on PubMed.
#*The last thing that Ivens published was the genome sequence and has not had published work on Leishmania Major since then. However, looking at the people who have referenced his reference genome, you can see many of the directions people have taken his research. Many articles have been posted in the last year on determining Leishmania resistance to drugs and many properties of different proteins within the gene.
#
#*Didn't find any good sources on Leishmania microarray data. Went to ArrayExpress, to look for arrays on Leishmania major to backtrack to articles.
#*I typed in "Leishmania Major" in the organism field and "Array assay" in the technology field and filtered down my results.
#*[http://europepmc.org/abstract/MED/18638379/reload=0;jsessionid=UIW9RunP1XHUGCaWD7p4.48 ''Modulation of gene expression in drug resistant Leishmania is associated with gene amplification, gene deletion and chromosome aneuploidy.''] Found on ArrayExpress
#*[http://europepmc.org/abstract/MED/18510761 ''Genome-wide gene expression profiling analysis of Leishmania major and Leishmania infantum developmental stages reveals substantial differences between the two species.''] Found on ArrayExpress
[[Kevinmcgee Week 11]] Journal club Reference article
[[Kevinmcgee Week 12]]
#Downloaded SDRF file off of the wiki.
#Started to edit SDRF file
#*Left the following columns while deleting the rest:
#**Source NAme
#**Characteristics
#**Comment (Sample_description)
#**Comment (Sample_source_name)
#**Label
#**Array Data File
#Filtered the file down to only L.Infantum samples
#Was left with the following image
#*[[image:SDRFL.Infantum (1).PNG]]
#*This image showed me what data was where when looking at the raw data files
#Proceeded to go into each data file for L.Infantum and keeping the name of each gene along with the log ratio of each gene.
#Compiled all data into a single sheet
#Was left with the following image
#*[[image:L.InfantumCompiledRawData.PNG]]
#Uploaded the Compiled Raw data file onto the wiki
#*Sdrf file was uploaded by Viktoria

[[Kevinmcgee Week 13]]
*Opened [[media:L.infantumCompliedRawData(A).txt | L.infantumCompliedRawData(A).txt]]
*Finished the formatting by flipping the dye swap chips negative
*Created a column next to dye swap chips and did the formula:
=-1*(dye swap chip column)
*made a new sheet
*added all data from old sheet except only added the flipped dye swaps
*looked for background information in the array paper
**L. infantum MHOM/MA/67/ITMAP-263 and L. major LV39 MRHO/SU/59/P strains used in this study
**All microarray data will be freely available on the Geo NCBI database in the MIAME format
***The series accession number for our manuscript is GSE10407.
**Each chip compares promastigote vs. amastigote with different replicates
**Following data files found
[[File:LmjSampleInfo.PNG]]
*Finished naming sheet with helpful names to know what is what on the sheet
*Ready for statistical analysis
*Began analysis by taking the average and standard deviation of our data chips seperately and using that information to scale and center our data:
=(B4-B$2)/B$3 This shows the equation we used to scale and center.
*Copied and pasted values of scaled centered onto a new page. From there, we edited out all VALUE! cells and left them blank. GenMAPP will ignore these blanks when we input our data.
*Made a column of the average fold change for each gene call Avg_LogFC_All
Average B2:G2
*Made a column of the Tstat and Pvalue for the fold changes of each gene:
=AVERAGE(B2:G2)/STDEV(B2:G2)/SQRT(6) TStat
=TDIST(ABS(I2),5,2) Pvalue
*Created a new page titled forGENMAPP
**Copied and pasted all values from statistics page
*Cut and pasted columns H-J and moved them to columns B-D
*Inserted a new column at B called System Code. Filled in column with the letter N
*File is now ready for GenMAPP import

*Sample of what the final file looked like
[[File:L.InfantumforGenMAPP.PNG]]

[[Kevinmcgee Week 15]]
=Uploading Into GenMAPP=
==Datasheet==
#compiled all data onto a single data sheet including both L.Major and L.Infantum and uploaded into GenMAPP
#*Ran into some problems uploading (almost everything was an error)
#Filtered out any Lin genes and created a new datasheet for only LmfJ genes.
#*Still ran into problems uploading
#looked at the database OrthologicalNames sheet, and saw that the GeneID's were in a different format on there then in the spreadsheet.
#*Made a quick-fix file by changing the names on the spreadsheet, but longterm fixes are being made to the coding so that other users do not have to change the names on their spreadsheets every time (for convenience).
#Were able to upload our data and continue on with the project.
==Sanity Check==
===Leishmania Infantum===
#Filtered P-value
#*1392 genes were <.05
#*327 genes were <.01
#*67 genes were <.001
#*28 genes were >.0001
#Filtered Average Log Fold Change
#*748 genes were >0
#*646 genes were <0
#*699 genes were >.25 while 646 were <.05
#*748 genes were >.05 while 606 were <.-25
==MAPPFinder Color Changes==
#The colors were assigned to the two main criterion
#*Increased relative to control had a Log FC> 0.25 and P-Value <0.05 these were colored blue
#*Decreased relative to control had a Log FC< -0.25 and P-Value <0.05 these were colored purple
==Running MAPPFinder==
*Set up MAPPFinder to run with the file name LMajorGOMap
*Ran for about 1 1/2 hours
#Top Ten GO Terms
#*catalytic activity
#*Endonuclease activity
#*DNA catabolic process
#*Aromatic compound catabolic process
#*cellular nitrogen compound catabolic process
#*nucleobase-containing compound catabolic process
#*organic cyclic compound catabolic process
#*heterocycle catabolic process
#*oxidoreductase activity
#*macromolecular complex

[[image: Picture GO.PNG]]
=== Statement of Work ===

* Describe exactly what you did on the project.
* Provide references or links to artifacts of your work, such as:
** Wiki pages
** Other files or documents
** Code or scripts

=== Assessment of Project ===

* Give an objective assessment of the success of your project workflow and teamwork.
* What worked and what didn't work?
* What would you do differently if you could do it all over again?
* Evaluate the Gene Database Project and Group Report in the following areas:
*# Content: What is the quality of the work?
*# Organization: Comment on the organization of the project and of your group's wiki pages.
*# Completeness: Did your team achieve all of the project objectives? Why or why not?

=== Reflection on the Process ===

* What did you learn?
** With your head (biological or computer science principles)
** With your heart (personal qualities and teamwork qualities that make things work or not work)?
** With your hands (technical skills)?
* What lesson will you take away from this project that you will still use a year from now?

Template:Kevin

2013-12-12T06:26:17Z

Kevinmcgee:

*[[Week 1]]

*[[Class Journal Week 1]]

*[[Week 2]]

*[[Class Journal Week 2]]

*[[Kevinmcgee Week 2]]

*[[Week 3]]

*[[Class Journal Week 3]]

*[[Kevinmcgee Week 3]]

*[[Week 4]]

*[[Class Journal Week 4]]

*[[Kevinmcgee Week 4]]

*[[Week 5]]

*[[Class Journal Week 5]]

*[[Kevinmcgee Week 5]]

*[[Week 6]]

*[[Class Journal Week 6]]

*[[Kevinmcgee Week 6]]

*[[Week 7]]

*[[Class Journal Week 7]]

*[[Kevinmcgee Week 7]]

*[[Week 8]]

*[[Class Journal Week 8]]

*[[Kevinmcgee Week 8]]

*[[Week 9]]

*[[Class Journal Week 9]]

*[[Kevinmcgee Week 9]]

*[[Week 10]]

*[[Class Journal Week 10]]

*[[Kevinmcgee Week 10]]

*[[Week 11]]

*[[Kevinmcgee Week 11]]

*[[Week 12]]

*[[Kevinmcgee Week 12]]

*[[Week 13]]

*[[Kevinmcgee Week 13]]

*[[Week 15]]

*[[Kevinmcgee Week 15]]

*[[Ensembl Database]]

*[[Kevin McGee Assessment and Reflection]]

Template:Kevin

2013-12-12T06:25:43Z

Kevinmcgee:

Template:Leishmania Major File Updates

2013-12-08T01:23:08Z

Kevinmcgee:

#11/5/2013
#*[[Media:A-GEOD-6855.adf_A.txt]] Array Design File
#*[[Media:E-GEOD-10407.idf_A.txt]] Investigation Description File
#*[[Media:E-GEOD-10407.processed.1_A.zip]] Processed Data
#*[[Media:E-GEOD-10407.raw.1_A.zip]] Raw Data
#*[[Media:E-GEOD-10407.sdrf_A.txt]] Sample and Data Relationship File
#11/7/2013
#*[[Media:E-GEOD-10407.sdrf_B.txt]] Leishmania major Chips
#*Completed Import/Export Cycle, conducted a Tally Count, opened .gdb file in Microsoft Access and compared original row counts.
#*Access was missing 2 genes for GeneID and RefSeq, and we had no GO terms in the Tally or in Access.
#11/11/2013
#*[[Media:Leishmania_major_BD.pdf|Leishmania major Genome Reference Article Presentation]]
#11/14/13
#*[[Media:E-GEOD-10407.sdrf_C.txt]] Edited Sample and Data (Ordered based on species and relevant data)
#*[[Media:L.majorCompiledRawData.txt]] L. major raw compiled data
#*[[Media:L.infantumCompliedRawData(A).txt]] L. infantum raw compiled data
#11/19/2013:
#*[[Media:L.majorCompiledRawData_B.txt]] L. major raw compiled data with adjusted dye swap values
#*[[Media:L.infantumCompliedRawData(B).txt]] L. infantum raw compiled data with adjusted dye swap values and sample names
#*[[Media:L.majorCompiledRawData_C.txt]] L. major raw compiled data with adjusted dye swap values and sample names
#11/21/2013
#*[[Media:L.infantumStats.txt]]
#*[[Media:L.infantumStats.xls]]
#*[[File:L.majorStats.xls]]
#*[[File:L.majorStats.txt]]
#*[[File:L.majorStats(A).txt]]
#*[[File:L.infantumStats(A).txt]]
#*[[File:LeishmaniaCompiledStatAnalysis.txt]]
#12/3/2013
#*[[File:LeishmaniaCompiledStatAnalysis(A).txt]]
#*[[File:LeishmaniaCompiledStatAnalysis(A).EX.txt]]
#*[[Media:L.infantumStats_B.xls]] Fixed infantum p-value parenthesis
#*[[Media:LeishmaniaCompiledStatAnalysis(B).txt]]
#*[[Media:LeishmaniaCompiledStatAnalysisLMJFiltered.txt]] Original File That should work in GenMAPP once coding is fixed
#*[[Media:LeishmaniaCompiledStatAnalysisLMJFiltered(B).txt]] Quick fix file with underscores to work in GenMAPP until coding is fixed
#*[[Media:LeishmaniaCompiledStatAnalysisLMJFiltered(B).EX.txt]]
#*[[Media:LeishmaniaCompiledStatAnalysisLMJFiltered(B).gex]]
#*[[Media:ExceptionFileErrorID.txt]]
#*[[Leishmania Major Group Project Report]]
#*[[Media:Dist Leishmania Lena Gabe 05112013.zip]]
#12/5/2013
#*[[Media:LeishmaniaGDB Lena Gabe 20131205.zip]]
#12/7/2013
#*[[File:LMajorGOMapp-Criterion1-GO.txt ]]
#*[[File:LMajorGOMapp-Criterion0-GO.txt]]

File:LMajorGOMapp-Criterion0-GO.txt

2013-12-08T01:22:24Z

Kevinmcgee:

Kevinmcgee Week 15

2013-12-05T18:52:57Z

Kevinmcgee:

=Uploading Into GenMAPP=
==Datasheet==
#compiled all data onto a single data sheet including both L.Major and L.Infantum and uploaded into GenMAPP
#*Ran into some problems uploading (almost everything was an error)
#Filtered out any Lin genes and created a new datasheet for only LmfJ genes.
#*Still ran into problems uploading
#looked at the database OrthologicalNames sheet, and saw that the GeneID's were in a different format on there then in the spreadsheet.
#*Made a quick-fix file by changing the names on the spreadsheet, but longterm fixes are being made to the coding so that other users do not have to change the names on their spreadsheets every time (for convenience).
#Were able to upload our data and continue on with the project.
==Sanity Check==
===Leishmania Infantum===
#Filtered P-value
#*1392 genes were <.05
#*327 genes were <.01
#*67 genes were <.001
#*28 genes were >.0001
#Filtered Average Log Fold Change
#*748 genes were >0
#*646 genes were <0
#*699 genes were >.25 while 646 were <.05
#*748 genes were >.05 while 606 were <.-25

==MAPPFinder Color Changes==
#The colors were assigned to the two main criterion
#*Increased relative to control had a Log FC> 0.25 and P-Value <0.05 these were colored blue
#*Decreased relative to control had a Log FC< -0.25 and P-Value <0.05 these were colored purple
==Running MAPPFinder==
#Set up MAPPFinder to run with the file name LMajorGOMap

Kevinmcgee Week 15

2013-12-05T18:51:28Z

Kevinmcgee:

=Uploading Into GenMAPP=
==Datasheet==
#compiled all data onto a single data sheet including both L.Major and L.Infantum and uploaded into GenMAPP
#*Ran into some problems uploading (almost everything was an error)
#Filtered out any Lin genes and created a new datasheet for only LmfJ genes.
#*Still ran into problems uploading
#looked at the database OrthologicalNames sheet, and saw that the GeneID's were in a different format on there then in the spreadsheet.
#*Made a quick-fix file by changing the names on the spreadsheet, but longterm fixes are being made to the coding so that other users do not have to change the names on their spreadsheets every time (for convenience).
#Were able to upload our data and continue on with the project.
==Sanity Check==
===Leishmania Infantum===
#Filtered P-value
#*1392 genes were <.05
#*327 genes were <.01
#*67 genes were <.001
#*28 genes were >.0001
#Filtered Average Log Fold Change
#*748 genes were >0
#*646 genes were <0
#*699 genes were >.25 while 646 were <.05
#*748 genes were >.05 while 606 were <.-25

==GenMAPP Finder Color Changes==
#The colors were assigned to the two main criterion
#*Increased relative to control had a Log FC> 0.25 and P-Value <0.05 these were colored blue
#*Decreased relative to control had a Log FC< -0.25 and P-Value <0.05 these were colored purple

Kevinmcgee Week 15

2013-12-05T18:28:31Z

Kevinmcgee:

Kevinmcgee Week 15

2013-12-05T18:19:12Z

Kevinmcgee: updated answers

=Uploading Into GenMAPP=

=Sanity Check=
==Leishmania Infantum==
#Filtered P-value
#*1392 genes were <.05
#*327 genes were <.01
#*67 genes were <.001
#*28 genes were >.0001
#Filtered Average Log Fold Change
#*748 genes were >0
#*646 genes were <0
#*699 genes were >.25 while 646 were <.05
#*748 genes were >.05 while 606 were <.-25

Kevinmcgee Week 15

2013-12-05T18:02:40Z

Kevinmcgee: Added Sanity Check

=Sanity Check=
==Leishmania Infantum==
#Filtered P-value
#*12 genes were <.05
#*6 genes were <.01
#*2 genes were <.001
#*1 gene was =.0001 (Blank_G20)
#Filtered Average Log Fold Change
#*10 genes were >0
#*2 genes were <0
#*10 genes were >.25 while 2 were <.05
#*10 genes were >.05 while 2 were <.-25

Template:Leishmania Major File Updates

2013-12-03T18:56:46Z

Kevinmcgee: Added Descriptions

#11/5/2013
#*[[Media:A-GEOD-6855.adf_A.txt]] Array Design File
#*[[Media:E-GEOD-10407.idf_A.txt]] Investigation Description File
#*[[Media:E-GEOD-10407.processed.1_A.zip]] Processed Data
#*[[Media:E-GEOD-10407.raw.1_A.zip]] Raw Data
#*[[Media:E-GEOD-10407.sdrf_A.txt]] Sample and Data Relationship File
#11/7/2013
#*[[Media:E-GEOD-10407.sdrf_B.txt]] Leishmania major Chips
#*Completed Import/Export Cycle, conducted a Tally Count, opened .gdb file in Microsoft Access and compared original row counts.
#*Access was missing 2 genes for GeneID and RefSeq, and we had no GO terms in the Tally or in Access.
#11/11/2013
#*[[Media:Leishmania_major_BD.pdf|Leishmania major Genome Reference Article Presentation]]
#11/14/13
#*[[Media:E-GEOD-10407.sdrf_C.txt]] Edited Sample and Data (Ordered based on species and relevant data)
#*[[Media:L.majorCompiledRawData.txt]] L. major raw compiled data
#*[[Media:L.infantumCompliedRawData(A).txt]] L. infantum raw compiled data
#11/19/2013:
#*[[Media:L.majorCompiledRawData_B.txt]] L. major raw compiled data with adjusted dye swap values
#*[[Media:L.infantumCompliedRawData(B).txt]] L. infantum raw compiled data with adjusted dye swap values and sample names
#*[[Media:L.majorCompiledRawData_C.txt]] L. major raw compiled data with adjusted dye swap values and sample names
#11/21/2013
#*[[Media:L.infantumStats.txt]]
#*[[Media:L.infantumStats.xls]]
#*[[File:L.majorStats.xls]]
#*[[File:L.majorStats.txt]]
#11/28/2013
#*[[File:L.majorStats(A).txt]]
#*[[File:L.infantumStats(A).txt]]
#*[[File:LeishmaniaCompiledStatAnalysis.txt]]
#12/3/2013
#*[[File:LeishmaniaCompiledStatAnalysis(A).txt]]
#*[[File:LeishmaniaCompiledStatAnalysis(A).EX.txt]]
#*[[File:L.infantumStats_B.xls]] Fixed infantum p-value parenthesis
#*[[File:LeishmaniaCompiledStatAnalysis(B).txt]]
#*[[File:LeishmaniaCompiledStatAnalysisLMJFiltered.txt]] Original File That should work in GenMAPP once coding is fixed
#*[[File:LeishmaniaCompiledStatAnalysisLMJFiltered(B).txt]] Quick fix file with underscores to work in GenMAPP until coding is fixed
#*[[File:LeishmaniaCompiledStatAnalysisLMJFiltered(B).EX.txt]]
#*[[File:LeishmaniaCompiledStatAnalysisLMJFiltered(B).gex]]
#*[[File:ExceptionFileErrorID.txt]]

Template:Leishmania Major File Updates

2013-12-03T18:55:16Z

2013-12-03T18:48:43Z

Kevinmcgee: