-
Find duplicates in MySQL SELECT col1, …
Greenville Find duplicates in MySQL SELECT col1, col2, count(col3) FROM t1 GROUP BY col1, col2 HAVING count(col3) > 1 Adapted from http://support.microsoft.com/default.aspx?scid=kb;en-us;139444
-
Rewrapping in Vim gq or gw to stay…
Pasragad Branch Rewrapping in Vim gq or gw to stay at the word where the cursor was. It will re-wrap the text depending on the textwidth or windowmargin value.
-
Another way of adjusting the spacing aft …
Another way of adjusting the spacing after line with stretched table Use bookends package and \toprule, \midrule, and \bottomrule instead of \hline. In premeble \usepackage{booktabs} In context {table}[h] \begin{tabular*}{\linewidth}{@{\extracolsep{\fill}} ccr} \toprule Site pattern & supported $T_i$ & count \\ \midrule xxx & $T_0$ & 4 \\ xxy & $T_1$ & 3 \\ \bottomrule \end{tabular*} \caption{Table1} […]
-
Adjusting spacing after \hline in tabul …
Adjusting spacing after \hline in tabular environment in preamble \newcommand\tstrut{\rule{0pt}{2.4ex}} \newcommand\bstrut{\rule[-1.0ex]{0pt}{0pt}} in content \begin{tabular}{ccc} \hline\hline Head 1 & Head 2 & Head 3 \tstrut \bstrut \\ \hline a1 & a2 & a3 \tstrut \\ b1 & b2 & b3 \\ c1 & c2 & c3 \\ d1 & d2 & d3 \bstrut \\ \hline\hline \end{tabular} […]
-
To find out what method is attached to a …
To find out what method is attached to an object in BioPerl during debugging, use ref commend. >x ref($seq) It’ll show the class where the object belongs to and search for the class. Not so funny… Any other way? NB. As it was said, the commend working during the debugging session; perl -d
-
Simple code example to retrieve annotati …
Simple code example to retrieve annotations 1 #!/usr/bin/perl -w 2 3 use strict; 4 use Carp; 5 use Bio::SeqIO; 6 7 my $embl_file = shift; 8 my $informat = “embl”; 9 10 my $seq_in = Bio::SeqIO -> new(-file => ”
-
Recursively cat all the txt files. fi …
Recursively cat all the txt files. find . -name “*.txt” -print0 |xargs -0 cat Got a clue here.
-
gff3 file format Make sure the fields a …
gff3 file format Make sure the fields are separated by TAB. The format consists of 9 columns, separated by tabs (NOT spaces). http://www.sequenceontology.org/gff3.shtml
-
Change the output directory of pdflatex …
Change the output directory of pdflatex in TeXworks. Go to Preferences -> Typesetting. Then select the tool you want to change in the Processing tools section. Click Edit and add the directory where the output goes by pressing + button. NB. There is no aux directory option in pdflatex unlike latex. So the final pdf […]
-
Visualizing Data with R http://had.blip….
Visualizing Data with R http://had.blip.tv/file/3362248/