read_file_metadata


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 R
epigenome_group_description varchar 2147483647 √ null
epigenome_group_id uuid 2147483647 √ null
epigenome_group.epigenome_group_id Implied Constraint R
epigenome_accession text 2147483647 √ null
epigenome_name text 2147483647 √ null
epigenome_description text 2147483647 √ null
name text 2147483647 √ null
experiment_type experiment_type 2147483647 √ null
epigenome_id uuid 2147483647 √ null
epigenome.epigenome_id Implied Constraint R
experiment_id uuid 2147483647 √ null
data_source_id uuid 2147483647 √ null
data_source.data_source_id Implied Constraint R
replicate_set_id uuid 2147483647 √ null
replicate_set.replicate_set_id Implied Constraint R
replicate_set_type text 2147483647 √ null
experiment_target_type text 2147483647 √ null
experiment_target text 2147483647 √ null
replicate_set_accession text 2147483647 √ null
replicate_id uuid 2147483647 √ null
replicate.replicate_id Implied Constraint R
replicate_accession text 2147483647 √ null
biosample_set_id uuid 2147483647 √ null
biosample_set.biosample_set_id Implied Constraint R
biosample_set_type biosample_set_type 2147483647 √ null
accession text 2147483647 √ null
biosample_id uuid 2147483647 √ null
biosample.biosample_id Implied Constraint R
biosample_accession text 2147483647 √ null
biosample_alternative_accession text 2147483647 √ null
biomaterial_type biomaterial_type 2147483647 √ null
biosample_term text 2147483647 √ null
ontology_id uuid 2147483647 √ null
ontology.ontology_id Implied Constraint R
ontology_type ontology_type 2147483647 √ null
curie text 2147483647 √ null
organ_slims _text 2147483647 √ null
cell_slims _text 2147483647 √ null
developmental_slims _text 2147483647 √ null
system_slims _text 2147483647 √ null
synonyms _text 2147483647 √ null
life_stage_id uuid 2147483647 √ null
life_stage.life_stage_id Implied Constraint R
life_stage_term text 2147483647 √ null
life_stage_ontology_relation ontology_relation_type 2147483647 √ null
life_stage_ontology_id uuid 2147483647 √ null
ontology.ontology_id Implied Constraint R
life_stage_ontology_type ontology_type 2147483647 √ null
life_stage_ontology_curie text 2147483647 √ null
age_at_collection numrange 2147483647 √ null
age_at_collection_unit age_unit_type 2147483647 √ null
time_post_fertilisation numeric 0 √ null
time_post_fertilisation_unit time_post_fertilisation_unit_type 2147483647 √ null
thermal_time numeric 0 √ null
perturbed bool 1 √ null
treatments text 2147483647 √ null
health_status text 2147483647 √ null
disease_term_id text 2147483647 √ null
disease_term_name text 2147483647 √ null
genetic_modifications text 2147483647 √ null
biosource_accession text 2147483647 √ null
biosource_alternative_accession text 2147483647 √ null
age numrange 2147483647 √ null
age_unit age_unit_type 2147483647 √ null
sex sex_type 2147483647 √ null
library_accession text 2147483647 √ null
read_file_set_id uuid 2147483647 √ null
read_file_set.read_file_set_id Implied Constraint R
technical_replicate int4 10 √ null
run_type run_type 2147483647 √ null
read_length int4 10 √ null
read_count int4 10 √ null
run_id uuid 2147483647 √ null
run.run_id Implied Constraint R
run_order run_order_type 2147483647 √ null
read_file_accession text 2147483647 √ null
read_file_id uuid 2147483647 √ null
file_id uuid 2147483647 √ null
file.file_id Implied Constraint R
size int8 19 √ null
md5sum text 2147483647 √ null
url text 2147483647 √ null
run_accession text 2147483647 √ null
key text 2147483647 √ null

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views