Table 'reddot_2025.ec_product' doesn't exist in this syntax SELECT 'type' AS `category`, `ep`.`type` AS `name`, COUNT(DISTINCT ep.product_id) AS count FROM ec_product ep WHERE ep.path = '1,14,100' AND ep.status = 20 AND (ep.`sample_type` LIKE '%_extracts%' AND ep.`sample_type` LIKE '%serum%' AND ep.`sample_type` LIKE '%tissue%' AND ep.`sample_type` LIKE '%beverage%' AND ep.`sample_type` LIKE '%food%') GROUP BY ep.`type` UNION ALL SELECT 'sample_type' AS `category`, `st`.`name` AS `name`, COUNT(DISTINCT ep.product_id) AS count FROM ec_product ep CROSS JOIN (SELECT 'All' AS `name` UNION ALL SELECT 'Animal Feeds' AS `name` UNION ALL SELECT 'Beverage' AS `name` UNION ALL SELECT 'Blood' AS `name` UNION ALL SELECT 'Bread Improver Mixtures' AS `name` UNION ALL SELECT 'Cell Culture Media' AS `name` UNION ALL SELECT 'Cell Lysate' AS `name` UNION ALL SELECT 'Enzyme Preparations' AS `name` UNION ALL SELECT 'Food' AS `name` UNION ALL SELECT 'Juice' AS `name` UNION ALL SELECT 'Milk' AS `name` UNION ALL SELECT 'Other Agricultural Products' AS `name` UNION ALL SELECT 'Other Biological Fluids' AS `name` UNION ALL SELECT 'Other Biological Samples' AS `name` UNION ALL SELECT 'Other Materials' AS `name` UNION ALL SELECT 'Plasma' AS `name` UNION ALL SELECT 'Powder' AS `name` UNION ALL SELECT 'Saliva' AS `name` UNION ALL SELECT 'Serum' AS `name` UNION ALL SELECT 'Soil' AS `name` UNION ALL SELECT 'Suspension Or Adherent Cells Cultures' AS `name` UNION ALL SELECT 'Tissue' AS `name` UNION ALL SELECT 'Tissue Extracts' AS `name` UNION ALL SELECT 'Urine' AS `name` UNION ALL SELECT 'Water' AS `name`) st WHERE ep.path = '1,14,100' AND ep.status = 20 AND (ep.`sample_type` LIKE '%_extracts%' AND ep.`sample_type` LIKE '%serum%' AND ep.`sample_type` LIKE '%tissue%' AND ep.`sample_type` LIKE '%beverage%' AND ep.`sample_type` LIKE '%food%') AND ep.sample_type LIKE CONCAT('%', st.name, '%') GROUP BY st.name UNION ALL SELECT 'applications' AS `category`, `at`.`name` AS `name`, COUNT(DISTINCT ep.product_id) AS count FROM ec_product ep CROSS JOIN (SELECT 'All Applications' AS `name` UNION ALL SELECT 'Functional Assay' AS `name` UNION ALL SELECT 'Protein Quantification' AS `name`) at WHERE ep.path = '1,14,100' AND ep.status = 20 AND (ep.`sample_type` LIKE '%_extracts%' AND ep.`sample_type` LIKE '%serum%' AND ep.`sample_type` LIKE '%tissue%' AND ep.`sample_type` LIKE '%beverage%' AND ep.`sample_type` LIKE '%food%') AND ep.applications LIKE CONCAT('%', at.name, '%') GROUP BY at.name UNION ALL SELECT 'detection_method' AS `category`, `ep`.`detection_method` AS `name`, COUNT(DISTINCT ep.product_id) AS count FROM ec_product ep WHERE ep.path = '1,14,100' AND ep.status = 20 AND (ep.`sample_type` LIKE '%_extracts%' AND ep.`sample_type` LIKE '%serum%' AND ep.`sample_type` LIKE '%tissue%' AND ep.`sample_type` LIKE '%beverage%' AND ep.`sample_type` LIKE '%food%') GROUP BY ep.`detection_method` UNION ALL SELECT 'research_areas' AS `category`, `ra`.`name` AS `name`, COUNT(DISTINCT ep.product_id) AS count FROM ec_product ep CROSS JOIN (SELECT 'All Research Areas' AS `name` UNION ALL SELECT 'Cell Biology' AS `name` UNION ALL SELECT 'Metabolism' AS `name`) ra WHERE ep.path = '1,14,100' AND ep.status = 20 AND (ep.`sample_type` LIKE '%_extracts%' AND ep.`sample_type` LIKE '%serum%' AND ep.`sample_type` LIKE '%tissue%' AND ep.`sample_type` LIKE '%beverage%' AND ep.`sample_type` LIKE '%food%') AND ep.research_areas LIKE CONCAT('%', ra.name, '%') GROUP BY ra.name
Table 'reddot_2025.ec_product_detail' doesn't exist in this syntax SELECT 'type' AS `category`, `ep`.`type` AS `name`, COUNT(DISTINCT ep.product_id) AS count FROM ec_product ep WHERE ep.path = '1,14,100' AND ep.status = 20 AND (ep.`sample_type` LIKE '%_extracts%' AND ep.`sample_type` LIKE '%serum%' AND ep.`sample_type` LIKE '%tissue%' AND ep.`sample_type` LIKE '%beverage%' AND ep.`sample_type` LIKE '%food%') GROUP BY ep.`type` UNION ALL SELECT 'sample_type' AS `category`, `st`.`name` AS `name`, COUNT(DISTINCT ep.product_id) AS count FROM ec_product ep CROSS JOIN (SELECT 'All' AS `name` UNION ALL SELECT 'Animal Feeds' AS `name` UNION ALL SELECT 'Beverage' AS `name` UNION ALL SELECT 'Blood' AS `name` UNION ALL SELECT 'Bread Improver Mixtures' AS `name` UNION ALL SELECT 'Cell Culture Media' AS `name` UNION ALL SELECT 'Cell Lysate' AS `name` UNION ALL SELECT 'Enzyme Preparations' AS `name` UNION ALL SELECT 'Food' AS `name` UNION ALL SELECT 'Juice' AS `name` UNION ALL SELECT 'Milk' AS `name` UNION ALL SELECT 'Other Agricultural Products' AS `name` UNION ALL SELECT 'Other Biological Fluids' AS `name` UNION ALL SELECT 'Other Biological Samples' AS `name` UNION ALL SELECT 'Other Materials' AS `name` UNION ALL SELECT 'Plasma' AS `name` UNION ALL SELECT 'Powder' AS `name` UNION ALL SELECT 'Saliva' AS `name` UNION ALL SELECT 'Serum' AS `name` UNION ALL SELECT 'Soil' AS `name` UNION ALL SELECT 'Suspension Or Adherent Cells Cultures' AS `name` UNION ALL SELECT 'Tissue' AS `name` UNION ALL SELECT 'Tissue Extracts' AS `name` UNION ALL SELECT 'Urine' AS `name` UNION ALL SELECT 'Water' AS `name`) st WHERE ep.path = '1,14,100' AND ep.status = 20 AND (ep.`sample_type` LIKE '%_extracts%' AND ep.`sample_type` LIKE '%serum%' AND ep.`sample_type` LIKE '%tissue%' AND ep.`sample_type` LIKE '%beverage%' AND ep.`sample_type` LIKE '%food%') AND ep.sample_type LIKE CONCAT('%', st.name, '%') GROUP BY st.name UNION ALL SELECT 'applications' AS `category`, `at`.`name` AS `name`, COUNT(DISTINCT ep.product_id) AS count FROM ec_product ep CROSS JOIN (SELECT 'All Applications' AS `name` UNION ALL SELECT 'Functional Assay' AS `name` UNION ALL SELECT 'Protein Quantification' AS `name`) at WHERE ep.path = '1,14,100' AND ep.status = 20 AND (ep.`sample_type` LIKE '%_extracts%' AND ep.`sample_type` LIKE '%serum%' AND ep.`sample_type` LIKE '%tissue%' AND ep.`sample_type` LIKE '%beverage%' AND ep.`sample_type` LIKE '%food%') AND ep.applications LIKE CONCAT('%', at.name, '%') GROUP BY at.name UNION ALL SELECT 'detection_method' AS `category`, `ep`.`detection_method` AS `name`, COUNT(DISTINCT ep.product_id) AS count FROM ec_product ep WHERE ep.path = '1,14,100' AND ep.status = 20 AND (ep.`sample_type` LIKE '%_extracts%' AND ep.`sample_type` LIKE '%serum%' AND ep.`sample_type` LIKE '%tissue%' AND ep.`sample_type` LIKE '%beverage%' AND ep.`sample_type` LIKE '%food%') GROUP BY ep.`detection_method` UNION ALL SELECT 'research_areas' AS `category`, `ra`.`name` AS `name`, COUNT(DISTINCT ep.product_id) AS count FROM ec_product ep CROSS JOIN (SELECT 'All Research Areas' AS `name` UNION ALL SELECT 'Cell Biology' AS `name` UNION ALL SELECT 'Metabolism' AS `name`) ra WHERE ep.path = '1,14,100' AND ep.status = 20 AND (ep.`sample_type` LIKE '%_extracts%' AND ep.`sample_type` LIKE '%serum%' AND ep.`sample_type` LIKE '%tissue%' AND ep.`sample_type` LIKE '%beverage%' AND ep.`sample_type` LIKE '%food%') AND ep.research_areas LIKE CONCAT('%', ra.name, '%') GROUP BY ra.name

Assay Kits for Extracts,serum,tissue,beverage,food

0 Items Found In Assay Kits / Page 0 - 0

Search No Result

Currently, there are no products matching your selected filters.

Filters applied:

  • Sample type:

Return to all Assay Kits or Contact Us for assistance.

Your item has been successfully added to your cart .

Item # Price
Proceed to Cart
Never miss an update.

Sign up for our monthly newsletter to hear about exclusive sales and product tips and tricks.