Reagent

Material used to measure an ANALYTE.

Columns
Name Type Description Foreign Key
reagent_accession varchar(15) Primary key
analyte_accession varchar(15) Foreign key reference to LK_ANALYTE lk_analyte.analyte_accession
analyte_preferred varchar(100) Preferred analyte name
analyte_reported varchar(200) Reported analyte name
antibody_registry_id varchar(250) Reference to AntibodyRegistry.org to describe antibody based reagents
catalog_number varchar(250) An identifier provided by the vendor source
clone_name varchar(200) Reported name of molecular entity used to make a reagent
contact varchar(1000) Whom to contact
description varchar(4000) Free text to expand upon details
is_set varchar(1) (Y/N) field to indicate whether or not the reagent is a member of a set or collection
lot_number varchar(250) Identifies a specific version
manufacturer varchar(100) Name of the reagent manufacturer.
name varchar(200) Name or identifier.
reporter_name varchar(200) Name or identifier
type varchar(50) Category lk_reagent_type.name
weblink varchar(250) Link to URL
workspace_id int(11) Foreign key reference to WORKSPACE table workspace.workspace_id
Indexes
Name Column Description
PRIMARY reagent_accession BTREE
idx_reagent_workspace workspace_id BTREE
fk_reagent_2 type BTREE
fk_reagent_3 analyte_accession BTREE
Tables that Reference this Table
Name Column Table Reference Column Reference
expsample_2_reagent reagent_accession reagent reagent_accession
reagent_set_2_reagent reagent_accession reagent reagent_accession
reagent_set_2_reagent reagent_set_accession reagent reagent_accession
Back to top