experiment_signal_and_control_data_source

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

species_name

text

2147483647

√

null

species_id

uuid

2147483647

√

null

species.species_id

Implied Constraint

description

varchar

2147483647

√

null

epigenome_group_id

uuid

2147483647

√

null

epigenome_group.epigenome_group_id

Implied Constraint

epigenome_accession

text

2147483647

√

null

epigenome_name

text

2147483647

√

null

epigenome_description

text

2147483647

√

null

epigenome_id

uuid

2147483647

√

null

epigenome.epigenome_id

Implied Constraint

experiment_name

text

2147483647

√

null

experiment_id

uuid

2147483647

√

null

experiment_type

2147483647

√

null

experiment_target_type

text

2147483647

√

null

experiment_target

text

2147483647

√

null

signal_replicate_set_accession

text

2147483647

√

null

signal_replicate_set_id

uuid

2147483647

√

null

replicate_set.replicate_set_id

Implied Constraint

control_replicate_set_accession

text

2147483647

√

null

control_replicate_set_id

uuid

2147483647

√

null

replicate_set.replicate_set_id

Implied Constraint

Relationships

Close relationships within degrees of separation

View Definition

SELECT species.name AS species_name,
    species.species_id,
    epigenome_group.description,
    epigenome_group.epigenome_group_id,
    epigenome_data_source.epigenome_accession,
    epigenome_data_source.name AS epigenome_name,
    epigenome_data_source.description AS epigenome_description,
    epigenome_data_source.epigenome_id,
    experiment_signal_data_source.name AS experiment_name,
    experiment_signal_data_source.experiment_id,
    experiment_signal_data_source.experiment_type,
    experiment_signal_data_source.experiment_target_type,
    experiment_signal_data_source.experiment_target,
    experiment_signal_data_source.replicate_set_accession AS signal_replicate_set_accession,
    experiment_signal_data_source.replicate_set_id AS signal_replicate_set_id,
    experiment_control_data_source.replicate_set_accession AS control_replicate_set_accession,
    experiment_control_data_source.replicate_set_id AS control_replicate_set_id
   FROM ((((species
     JOIN epigenome_data_source ON ((species.species_id = epigenome_data_source.species_id)))
     JOIN epigenome_group ON ((epigenome_data_source.epigenome_group_id = epigenome_group.epigenome_group_id)))
     JOIN experiment_signal_data_source ON ((epigenome_data_source.epigenome_id = experiment_signal_data_source.epigenome_id)))
     LEFT JOIN experiment_control_data_source ON ((experiment_signal_data_source.experiment_id = experiment_control_data_source.experiment_id)));

experiment_signal_and_control_data_source

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views