View source for HDelgadi Project Notebook

==Export Information==
Version of GenMAPP Builder:
2.0b71 
Computer on which export was run:
Personal Laptop
Postgres Database name:
Chlamydiaimport2
UniProt XML filename:
uniprot-organism%3A315277+keyword%3A181_v1_HD_20131120
* UniProt XML version (The version information can be found at [http://uniprot.org/news the UniProt News Page]):
* Time taken to import:
1.24 Minutes
GO OBO-XML filename: go_daily-termdb_v1_HD_20131107.obo-xml
* GO OBO-XML version (The version information can be found in the file properties after the file downloaded from the [http://beta.geneontology.org/page/download-ontology GO Download page] has been unzipped):
* Time taken to import: 16.41
* Time taken to process: 16.05
GOA filename: 22183.C_trachomatis_A_v1_HD_20131120.goa
* GOA version (News on [http://www.ebi.ac.uk/GOA/ this page] records past releases; current information can be found in the Last modified field on the [ftp://ftp.ebi.ac.uk/pub/databases/GO/goa/proteomes/ FTP site]):
* Time taken to import: 0.05 minutes
<nowiki>Insert non-formatted text here</nowiki>
Name of .gdb file: C-Std_20131124_HD_24112013
* Time taken to export .gdb: About 1 hour and 20 minutes
* Upload your file and link to it here.
[[Media:C-Std 20131124 HD 24112013.gdb]]

[[User:HDelgadi|HDelgadi]] ([[User talk:HDelgadi|talk]]) 23:15, 5 December 2013 (PST)

'''''Week 15'''''

*I looked at separating the IDs, so that we may use them to provide a statistical analysis of the microarray data. I was able to work on separating these genes with Katrina's advice. Hence, in Excel, I made sure to add two columns (Columns B and C). Then, I made sure to highlight the gene IDs (CTA_####... AND pCTA_####...) from the first column. I clicked on 'Data' at the top and "Fixed width", pressed 'Next', moved the cursor to where it was necessary (before the second underscore). I erased what was next to the 'Destination' box and clicked on the arrow next to the empty box so that I may highlight the gene IDs (CTA_####... AND pCTA_####...) from the first column. Then, I would make sure to highlight the second portion of the gene ID that I wanted to separate from the first main portion (from the second underscore to the very end of the gene ID). I went to the 'Destination' box and erased what was on there. I then pressed on the arrow and highlighted the second column (column B) next to the original gene IDs. I clicked the arrow again next to the 'Destination' box and pressed 'Finish'. This process resulted in the separation of the gene IDs. from CTA_###_RRMH#####_... to CTA_#### AND _RRMH#####_... in separate columns. This information is of course useful to begin the statistical analysis of the microarray data to further input this data into GenMAPP. 

*Katrina and I were able to look at the relational database schema that I need to make sure to create and were able to find a free trial of adobe illustrator, so that I may have access to "Access" and create the schema. I will work on this by Saturday.

'''Reflection'''
#What worked?
#:Our schedules were able to  match much better this week, so we were all able to meet without any problems.
#What didn't work?
#:We had hoped to start on the paper this week, but unfortunately we faced difficulties with the microarray data and gmbuilder, so we were not able to get far enough in the process to run GenMAPP earlier in the week.
#What will I do next to fix what didn't work? 
#:We have resolved the problems we faced, so we will make sure to begin the paper as soon as possible (by Saturday) and if there are any questions we will contact Dr. Dionisio and Dr. Dahlquist immediately. 

[[User:HDelgadi|HDelgadi]] ([[User talk:HDelgadi|talk]]) 00:07, 6 December 2013 (PST)


{{HDelgadi}}