base_epigenomes_replicates_and_files

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

species_name

text

2147483647

√

null

assembly_name

varchar

2147483647

√

null

base_epigenome_id

uuid

2147483647

√

null

epigenome.epigenome_id

Implied Constraint

material

text

2147483647

√

null

term

text

2147483647

√

null

term_for_label

text

2147483647

√

null

term_ontology

text

2147483647

√

null

sex

text

2147483647

√

null

sex_for_label

text

2147483647

√

null

life_stage

text

2147483647

√

null

life_stage_for_label

text

2147483647

√

null

age_value

text

2147483647

√

null

age_unit

text

2147483647

√

null

modified_age_unit

text

2147483647

√

null

extended_age

text

2147483647

√

null

short_age

text

2147483647

√

null

age_for_label

text

2147483647

√

null

experiment_type

text

2147483647

√

null

experiment_target

text

2147483647

√

null

biosample_accession

text

2147483647

√

null

data_source

text

2147483647

√

null

term_group

text

2147483647

√

null

number_of_replicates

int8

√

null

experiment_id

uuid

2147483647

√

null

assembly_id

uuid

2147483647

√

null

assembly.assembly_id

Implied Constraint

open_chromatin_peak

text

2147483647

√

null

chip_seq_gapped_peak_key

text

2147483647

√

null

chip_seq_narrow_peak_key

text

2147483647

√

null

signal_key

text

2147483647

√

null

biological_group

text

2147483647

√

null

sample_type

text

2147483647

√

null

Relationships

Close relationships within degrees of separation

View Definition

WITH no_replicates AS (
         SELECT base_epigenome_replicates_1.assembly_name,
            base_epigenome_replicates_1.base_epigenome_id,
            base_epigenome_replicates_1.experiment_type,
            base_epigenome_replicates_1.experiment_target,
            count(*) AS number_of_replicates
           FROM base_epigenome_replicates base_epigenome_replicates_1
          GROUP BY base_epigenome_replicates_1.assembly_name, base_epigenome_replicates_1.base_epigenome_id, base_epigenome_replicates_1.experiment_type, base_epigenome_replicates_1.experiment_target
        )
 SELECT DISTINCT base_epigenome_replicates.species_name,
    base_epigenome_replicates.assembly_name,
    base_epigenome_replicates.base_epigenome_id,
    base_epigenome_replicates.material,
    base_epigenome_replicates.term,
    base_epigenome_replicates.term_for_label,
    base_epigenome_replicates.term_ontology,
    base_epigenome_replicates.sex,
    base_epigenome_replicates.sex_for_label,
    base_epigenome_replicates.life_stage,
    base_epigenome_replicates.life_stage_for_label,
    base_epigenome_replicates.age_value,
    base_epigenome_replicates.age_unit,
    base_epigenome_replicates.modified_age_unit,
    base_epigenome_replicates.extended_age,
    base_epigenome_replicates.short_age,
    base_epigenome_replicates.age_for_label,
    base_epigenome_replicates.experiment_type,
    base_epigenome_replicates.experiment_target,
    base_epigenome_replicates.biosample_accession,
    base_epigenome_replicates.data_source,
    biosample_term_group.term_group,
    no_replicates.number_of_replicates,
    curated_experiment_analysis_files.experiment_id,
    curated_experiment_analysis_files.assembly_id,
    curated_experiment_analysis_files.open_chromatin_peak,
    curated_experiment_analysis_files.chip_seq_gapped_peak_key,
    curated_experiment_analysis_files.chip_seq_narrow_peak_key,
    curated_experiment_analysis_files.signal_key,
    biosample_biological_group.biological_group,
    biosample_sample_type.sample_type
   FROM ((((((curated_experiment_metadata
     JOIN curated_experiment_analysis_files ON (((curated_experiment_metadata.experiment_id = curated_experiment_analysis_files.experiment_id) AND (curated_experiment_metadata.assembly_id = curated_experiment_analysis_files.assembly_id))))
     JOIN base_epigenome_replicates ON (((curated_experiment_metadata.experiment_type = base_epigenome_replicates.experiment_type) AND (curated_experiment_metadata.experiment_target = base_epigenome_replicates.experiment_target) AND (curated_experiment_metadata.epigenome_id = base_epigenome_replicates.base_epigenome_id) AND ((curated_experiment_metadata.assembly_name)::text = (base_epigenome_replicates.assembly_name)::text) AND (curated_experiment_metadata.species_name = base_epigenome_replicates.species_name))))
     JOIN no_replicates ON (((curated_experiment_metadata.experiment_type = no_replicates.experiment_type) AND (curated_experiment_metadata.experiment_target = no_replicates.experiment_target) AND (curated_experiment_metadata.epigenome_id = no_replicates.base_epigenome_id) AND ((curated_experiment_metadata.assembly_name)::text = (no_replicates.assembly_name)::text))))
     JOIN biosample_term_group ON (((base_epigenome_replicates.base_epigenome_id = biosample_term_group.epigenome_id) AND (curated_experiment_metadata.epigenome_id = biosample_term_group.epigenome_id) AND (no_replicates.base_epigenome_id = biosample_term_group.epigenome_id))))
     LEFT JOIN biosample_biological_group ON ((base_epigenome_replicates.base_epigenome_id = biosample_biological_group.epigenome_id)))
     LEFT JOIN biosample_sample_type ON ((base_epigenome_replicates.base_epigenome_id = biosample_sample_type.epigenome_id)));

base_epigenomes_replicates_and_files

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views