Retrieve/find data about microbial growth conditions
- Status: Closed
- Prize: $50
- Entries Received: 2
- Winner: RPaul73
here is an explanation of the task:
In the attachment you will find a table which contains a list of microorganisms with some information about them. For a few of these microorganisms, I need to find optimal growth temperature. Here is a technical description:
• Reduce the attached table by deleting all the rows containing “sp.” symbol.
• Then reduce the table by deleting all but one species from the same genus. For instance, if the table contains several microorganisms with the same first name, such as
and each of these microorganisms has several strains, such as:
Escherichia coli O157
Escherichia coli IAI39
Escherichia coli ATCC16774
then I need to reduce the table by deleting all but one "Escherichia"-containing rows, for instance, delete all but "Escherichia coli IAI39"-containing row. By doing so for every microorganism in the table, we will get a smaller table in which every microorganism will have a unique first name.
• For the remaining species in this reduced table, please find optimal growth temperature and add these temperature values to the table
• I understand that for some species it might be tricky to find the temperature values. In this case, simply make sure that the table contains at least 100 rows for each of the following groups:
A. Psychrophiles (optimal growth below 18°C) – this first group might be smaller than 100 rows but should be bigger than 20 raws (I’m not sure if there are more than 100 microbes in nature that a capable of growth at such a low temperature)
B. Psycrhotrophes (optimal growth between 19 and 24°C)
C. Lower mesophiles (optimal growth 25-30°C)
D. Upper mesophiles (31-40°C)
E. Moderate thermophiles (growth 41-59°C)
F. Thermophiles (60-70°C)
G. Extreme thermophiles (71-80°C) – for this last group I need only more than 10 species (I’m not sure if there are enough species in nature that a capable of growing at these high temperatures)
H. Superthermophiles (above 80°C) – for this last group I don’t expect to see many species either, but more than 10 species are highly desired.
One might ask where to find the info about the optimal growth temperatures? I don't know, but in my experience there are a lot of folks here for whom this is not a problem by doing data scrapping from the world wide web. Also, please feel free to ask any questions if my explanation is not clear.
Best and many thanks for your assistance.
PS: This is not a one-time job. I'm looking for someone to cooperate in the future to scale up this task and complete similar tasks in the coming month or two.