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

This view of ElementResultImp is for array data quantified with the Agilent Feature Extraction software.

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
MEAN_SIGNAL FLOATRaw mean signal of this feature in the channel relative to this quantification (inlier pixels). Edit
BG_MEAN_SIGNAL FLOATMean local background signal for this feature in the channel relative to this quantification (inlier pixels). Edit
PIX_SDEV FLOATStandard deviation of all inlier pixels of this feature in the channel relative to this quantification. Edit
BG_PIX_SDEV FLOATStandard deviation of all inlier pixels per local background of this feature in the channel relative to this quantification. Edit
MEDIAN_SIGNAL FLOATRaw median signal of this feature in the channel relative to this quantification (inlier pixels). Edit
BG_MEDIAN_SIGNAL FLOATMedian local background signal for this feature in the channel relative to this quantification (inlier pixels). Edit
POSITION_X FLOATX coordinate of the feature centroid in pixels. Edit
POSITION_Y FLOATY coordinate of the feature centroid in pixels. Edit
SPOT_RADIUS_X FLOATRadius of the feature (X-axis) when Calculate Spot Size and WholeSpot method are selected. Edit
SPOT_RADIUS_Y FLOATRadius of the feature (Y-axis) when Calculate Spot Size and WholeSpot method are selected. Edit
PIX_CORRELATION FLOATRatio of estimated feature covariance in RedGreen space to product of feature Standard Deviation in RedGreen space. This is a cumulative quantitation of the tendency of pixels belonging to this feature in Red and Green spaces to co-vary. Edit
BG_PIX_CORRELATION FLOATThe same concept as pix_correlation but in case of background. Edit
P_VAL_FEAT_EQ_BG FLOATP-value from t-test of significance between mean signal and background. Edit
IS_FOUND NUMBER(3,0) A boolean used to flag found (strong) features for the channel relative to this quantification. A feature is considered found if the found spot centroid is within the bounds of the spot deviation limit with respect to corresponding nominal centroid. 1=IsFound, 0=IsNotFound. Edit
IS_SATURATED NUMBER(3,0) Boolean flag indicating if a feature is saturated or not. A feature is saturated if 50% of its pixels are above the saturation threshold. 1=Saturated, 0=Non saturated. Edit
IS_FEAT_NON_UNIF_OL NUMBER(3,0) Boolean flag indicating if a feature is a NonUniformity Outlierornot. A feature is non-uniform if its pixel noise exceeds a threshold established for a "uniform" feature. 1 indicates non-uniformity outlier for the channel relative to this quantification. Edit
IS_BG_NON_UNIF_OL NUMBER(5,0) The same concept as is_feat_non_unif_ol but for background. Edit
IS_FEAT_POPN_OL NUMBER(5,0) Boolean flag indicating if a feature is a Population Outlier or not. Probes with replicate features on a microarray are examined using population statistics. A feature is a population outlier if its signal is less than a lower threshold or exceeds an upper threshold determined using the interquartile range of the population. 1 indicates that the feature is a population outlier for the channel relative to this quantification. Edit
IS_BG_POPN_OL NUMBER(5,0) The same concept as is_feat_popn_ol but for background. Edit
IS_MANUAL_FLAG NUMBER(12,0) Edit
IS_POS_AND_SIGNIF NUMBER(12,0) Boolean flag indicating if the mean signal of this feature is greater than the corresponding background (selected by user) and if this difference is significant. Significance is established via a 2-sided t-test against the user-settable maximum p-value. 1 indicates that this feature is positive and significant above background. Edit
IS_WELL_ABOVE_BG NUMBER(12,0) A boolean flag indicating if a feature is WellAbove Background or not. Feature passes is_pos_and_signif and additionally the background subtracted signal is greater than 2.6* bkg. SD. Edit
IS_USED_BG_ADJUST NUMBER(12,0) A boolean used to flag features used for computation of global BG offset. 1=Features used; 0= Feature not used. Edit
NUM_PIX_OL_HI NUMBER(12,0) Number of outlier pixels per feature with intensity > upper threshold set via the pixel outlier rejection method. The number is computed independently in each channel. Edit
NUM_PIX_OL_LO NUMBER(12,0) Number of outlier pixels per feature with intensity < lower threshold set via the pixel outlier rejection method. The number is computed independently in each channel. Edit
NUM_PIX NUMBER(12,0) Total number of pixels used to compute feature statistics; i.e. total number of inlier pixels/per spot; same in both channels. Edit
BG_NUM_PIX NUMBER(12,0) Total number of pixels used to compute local background statistics per spot; i.e. total number of background inlier pixels; same in both channels. Edit
NUM_SAT_PIX NUMBER(12,0) Total number of saturated pixels per feature, computed per channel. Edit

Child tables:

Subclasses: