GUS Schema >> RAD::GenePixElementResult (subclass of RAD::ElementResult )

Stores results from GenePix *.gpr files.

Light yellow rows indicate columns provided from the superclass.

column nulls? type description
ELEMENT_RESULT_ID no NUMBER(10,0) Edit
SUBCLASS_VIEW no STRING(27) Edit
ELEMENT_ID no RAD::Element (NUMBER(10,0) ) Edit
COMPOSITE_ELEMENT_RESULT_ID RAD::CompositeElementResult (NUMBER(10,0) ) Edit
QUANTIFICATION_ID no RAD::Quantification (NUMBER(8,0) ) Edit
FOREGROUND_SD FLOATThe standard deviation of the intensities for pixels within a circular feature-indicator. Pixels that contact the feature-indicator circle itself are excluded. Edit
BACKGROUND_SD FLOATLocal or global standard deviation of the non-specific signal fluorescence. This value is subtracted from the foreground value prior to ratio calculations. Edit
SPOT_DIAMETER FLOATCircular feature indicators can be variable in diameter. Edit
FOREGROUND_MEAN FLOATThe mean of the intensities for pixels within a circular feature-indicator. Pixels that contact the feature-indicator circle itself are excluded. Edit
FOREGROUND_MEDIAN FLOATThe median of the intensities for pixels within a circular feature-indicator. Pixels that contact the feature-indicator circle itself are excluded. Edit
BACKGROUND_MEAN FLOATLocal or global mean of the non-specific signal fluorescence. This value is subtracted from the foreground value prior to ratio calculations. Edit
BACKGROUND_MEDIAN FLOATLocal or global median of the non-specific signal fluorescence. This value is subtracted from the foreground value prior to ratio calculations. Edit
PERCENT_OVER_BG_PLUS_ONE_SD FLOATThe percentage of pixels greater than one standard deviation above background. A measure of the quality of the data in an experiment. Edit
PERCENT_OVER_BG_PLUS_TWO_SDS FLOATThe percentage of pixels greater than two standard deviations above background. A measure of the quality of the data in an experiment. Edit
PERCENT_FOREGROUND_SATURATED FLOATPercentage of pixels that have an intensity equal to the maximum value of 65535. This indicates an inaccurate signal measurement. Adjusting the PMT gain should prevent such saturation. Edit
MEAN_OF_RATIOS FLOATArithmetic mean of pixel-by-pixel ratios of pixel intensities, with the median background subtracted. More affected by outliers than the median_of_ratios. Edit
MEDIAN_OF_RATIOS FLOATMedian of pixel-by-pixel ratios of pixel intensities, with the median background subtracted. More robust to outliers than the mean_of_ratios. Edit
RATIOS_SD FLOATStandard deviation of pixel-pixel intensity ratios. Edit
RGN_RATIO FLOATThe regression ratio. Edit
RGN_R_SQUARED FLOATThe coefficient of determination for the current regression value. Edit
NUM_FOREGROUND_PIXELS NUMBER(5,0) Number of pixels used to calculate the foreground intensity. Edit
NUM_BACKGROUND_PIXELS NUMBER(5,0) Number of pixels used to calculate the background intensity. Edit
FLAG NUMBER(3,0) Visual inspection may prompt flagging of features that should be excluded from analysis. Flags are stored as numerical values as follows: good = 100, bad = -100, not found = -50, absent = -75, unflagged = 0. Advanced flagging features allow the user to specify custom flag values. Edit
AUTOFLAG NUMBER(3,0) Used to mark whether or not a good or bad flag was applied from the Flag. Edit
CIRCULARITY FLOATUses a metric based on the variance of the distance of each boundary pixel to the centroid of the feature: 100 is most circular, 0 is most non-circular. Circular features are always 100, square features are always 79 (p/4*100). Edit

Child tables:

Subclasses: