Learning to love mothballs

/
Today, I learned about the existence of a bacterial species named Polaromonas naphthalenivorans. This lil' guy* fits into the mysterious, often baffling category of extremophile bacteria - that is, species capable of living in environments we normally wouldn't consider habitable. Originally isolated from a coal-tar-contaminated aquifer somewhere in the northeastern US,** P. naphthalenivorans can grow using naphthalene as its only carbon source. It's not terribly surprising, as naphthalene is a major component of coal tar (and was originally isolated from coal tar, in fact), so this species is just working with what it has. It's still rather odd as naphthalene is toxic and a suspected carcinogen. Those kind of rules don't always apply to bacteria.

Dividing P. naphthalenivorans cells. Micrograph is from the Joint Genome Institute (JGI). See this page for more details.


Most people are familiar with naphthalene as a component of mothballs. This paper suggests that a whole metabolic community could subsist on naphthalene, or at least could adapt to its presence. Evolution is great that way!

*Literary anthropomorphism is a constant danger when discussing animals and especially when discussing microbes since it's difficult to understand why they do what they do. I will rarely, however, avoid an opportunity to make bacteria seem cute. They're already tiny, and tiny things are cute, right?

**A paper describing the aquifer describes it using little more detail than "A single truckload of coal tar was buried in a forested area in the northeastern United States." This MicrobeWiki page says it's in South Glens Falls, New York. There's a lab at Cornell that likes to work there. As far as they know, the local drinking water isn't contaminated with coal tar or anything like that.

Goofy Excel tricks episode #1048577

/

Note from August 2015: The following method does not appear to work correctly in LibreOffice Calc but it may work, albeit somewhat irregularly, in Google Sheets. Aren't these discrepancies fun?

Just a quick trick I learned today about how to make Excel search a series of values and return one or more corresponding adjacent values for each. I'd normally use VLOOKUP for such a thing but the function only returns the first match it finds. How about situations when I have more than one match, like this one:
A   elephant
B   truck
C   large rock
D   pudding
B   gopher

in which I want to know which values are adjacent to value 'B'?

Googling a bit provided this convenient and non-obvious answer. The general function is:
=INDEX([the values you want to return], SMALL(INDEX(([the search value]=[the values being searched])*(MATCH(ROW([the values being searched]), ROW([the values being searched])))+([the search value]<>[the values being searched])*1048577, 0, 0), COLUMN(A1)))


The function will return one matched value at a time, so to get the other matched values to appear in the same row just copy it over to the adjacent cells in the row. It will return #REF! if the search value isn't found.


Don't forget to make references static as needed, i.e. $A$4:$A$979. The 1048577 is to convert the function from an array function into a normal one, I think. Not really sure what that COLUMN(A1) part is doing. Maybe it's just to establish where the upper-leftmost cell is.


This post is mostly for my own edification but I hope it was helpful. To me. Most people don't use Excel arrays for things that are better suited to a bit of SQL, right?