MTNU-2015

ekawat.pas@mahidol.ac.th

1.Step by step to make the phylogenetic tree from your interesting sequences with description
2.Summarize the result

Deadline will be 24:00 on 01/11/2015

Assignment for Bioinformatic for molecular technique (MT 2015)

Please show step by step to complete the following assignment

Assignment set 1
1.Download your interesting sequence to your computer
2.Translation of your sequence to protein sequence
3.Select 50-100 amino acid position of your sequence then make BLAST and discuss the result

Assignment set 2
1.Download at least 5 sequences of the same gene in different organism, then make the alignment
2.Make the consensus sequence of the set of sequences using threshold of consensus as 60%
2.Make the phylogenetic tree and discuss the result



Send the assignment to ekawat.pas@mahidol.ac.th
The deadline is 4,October,2015 12:00PM

Designing of viral molecular test kits

Please download the slide in PDF format from the link below;

http://www.mediafire.com/view/za9ctyevbv1ovuz/Designing_of_viral_molecular_test_kits.pdf

Laboratory Information System

Laboratory Administration 2558
http://www.mediafire.com/view/92375s32ko1lb66/Laboratory_Information_System_2015-08.pdf

Remove Carriage Returns manually

From https://www.ablebits.com/office-addins-blog/2013/12/03/remove-carriage-returns-excel/

Remove Carriage Returns manually

Pros: the fastest way.
Cons: no any additional features :(.

Please find the steps for eliminating line breaks using Find and Replace:

1. Select all cells where you want to remove or replace carriage returns.
2. Press Ctrl+H to open the Find & Replace dialog box.
3. In the Find What field enter Ctrl+J. It will look empty, but you will see a tiny dot.
4. In the Replace With field, enter any value to replace carriage returns. Usually, it is space to avoid 2 words join accidentally. If all you need is deleting the line breaks, leave the "Replace With" field empty.
5. Press the Replace All button and enjoy the result!

Handle both Windows and UNIX carriage return/ line feeds combinations.
=SUBSTITUTE(SUBSTITUTE(B2,CHAR(13),""),CHAR(10),"")
The next formula will help you replace line break with any other symbol (comma+space). In this case lines will not join and extra spaces will not appear.
=TRIM(SUBSTITUTE(SUBSTITUTE(B2,CHAR(13),""),CHAR(10),", ")
If you want to remove all nonprintable characters from text, including line breaks:
=CLEAN(B2)

2015-04 Translational Medicine

https://www.mediafire.com/?eep924ebk4d6m4u