SELECT IGFBP2Cells_Intensity_LowerQuartileIntensity_OrigBlue / 2 FROM Expt_IGFBP2Per_Object WHERE ImageNumber=1 AND ObjectNumber=14;
… I want to know if it can do math on the column… if it can’t then it’s probably a string.
When you start up CPA, it should tell you what the location of the sqlite db is that it’s using. Since it looks like your db is small, you could just send that to me and I could take a look at it myself.
For your second question:
Did you click the lasso tool at the top of the scatterplot frame? This is a fairly recent addition.
How did you get to the data table? Did you just launch it from CPA and then open the per-object table from there? I attached an image of what I get when I double click a ‘*’ cell in the per-object datatable, you can see that there’s a little white box drawn where the center of the selected object is. If your images are large, it may be that you have to scroll to see the box. Careful not to click on the image though, or it will select the nearest cell to where you click.
Oh, re-reading your reply it sounds like you’re actually looking at the enrichments table… is that right? If that’s the case then each row is going to be per-image (default) anyway.
I don’t think so, unless I misunderstood something.