metadata: run_metadata: 1 row where experiment.library_layout = "SINGLE", experiment.library_selection = "RT-PCR" and tissue_curation

1 row where experiment.library_layout = "SINGLE", experiment.library_selection = "RT-PCR" and tissue_curation_coarse = "Muscular System"

descending

Link	rowid ▼	run.accession	experiment.accession	sample.accession	study.accession	bioproject	study.title	study.alias	study.type	study.abstract	study.attributes	study.PMIDs	sample.description	sample.title	sample.alias	sample.centername	sample.attributes	GEOsample.title	GEOsample.dataprocessing	GEOsample.source	GEOsample.treatmentprotocol	GEOsample.extractprotocol	GEOsample.growthprotocol	GEOsample.characteristics	GEOsample.accession	experiment.title	experiment.alias	experiment.library_name	experiment.design_description	experiment.library_construction_protocol	experiment.attributes	experiment.library_strategy	experiment.library_source	experiment.library_selection	experiment.library_layout	experiment.platform	experiment.instrument_model	experiment.spot_descriptor	experiment.study_ref	run.title	run.attributes	run.filename	run.semantic_name	run.total_bases	run.total_spots	run.alias	run.read_lengths	run.base_counts	run.r1_length	run.r2_length	run.r3_length	run.r4_length	run.Acount	run.Ccount	run.Gcount	run.Tcount	run.Ncount	run.experiment	run.pool_member	submission.accession	submission.srasource	submission.bioprojectsource	seqdetective.n_mates	seqdetective.mapping_rate.mate1	seqdetective.mapping_rate.mate2	seqdetective.nofeature_rate.mate1	seqdetective.nofeature_rate.mate2	seqdetective.sparsity.mate1	seqdetective.sparsity.mate2	seqdetective.pos_strand_rate.mate1	seqdetective.pos_strand_rate.mate2	seqdetective.readlen.mate1	seqdetective.readlen.mate2	seqdetective.judgement.mate1	seqdetective.judgement.mate2	seqdetective.judgement.reason	platform_family	instrument_generation	read_bias	selection_class	prep_kit	sc_or_bulk	tech_class	technology	tech_variant	submission.bioprojectsource.country	earliest_date	devstage_curation	devstage_curation_coarse	tissue_curation	tissue_curation_coarse
36665	36665	SRR800045	SRX257154	SRS405708	SRP020008	PRJNA193544	Danio rerio strain:Tubingen Epigenomics	PRJNA193544	Other	Early vertebrate embryos must achieve totipotency and prepare for zygotic genome activation ZGA. To better understand we determined DNAme profiles of zebrafish gametes multiple embryo stages flanking ZGA and somatic muscle and compared them to gene activity and histone modifications. First sperm chromatin patterns are virtually identical to those at ZGA. Unexpectedly in the oocyte many genes important for germline functions ie. piwil1 or early development ie. hox genes are DNA methylated. Remarkably these maternal loci are demethylated during zygotic/cleavage stages to precisely the state observed in sperm even in parthenogenetic embryos lacking a replicating paternal genome. Furthermore this cohort constitutes the genes/loci that acquire DNAme during development ie. ZGA to muscle. Finally DNA methyltransferase inhibition experiments suggest that DNAme silences particular gene/chromatin cohorts at ZGA preventing their precocious expression. Thus zebrafish achieve a 'totipotent' chromatin state at ZGA through paternal genome competency and maternal genome DNAme reprogramming.		pubmed:23663776	Total RNA was extracted using Qiagen AllPrep DNA/RNA/Protein mini kit Cat # 80004 ribosomal RNA was depleted using RiboMinus kit A10837 08 Eukaryote Kit followed by directional RNA library preparation according to Illumina's standard protocol. Detailed experimental procedures and bioinformatics analysis can be found in the supplemental method section of the paper.	Generic sample from Danio rerio	muscle RNAseq totalRNARibominus		strain:Tubingen\|label:PE: paired end SE: single end\|development stage:muscle									muscle RNAseq totalRNARibominus	muscle RNAseq totalRNARibominus	9084X1	Total RNA was extracted using Qiagen AllPrep DNA/RNA/Protein mini kit Cat # 80004 ribosomal RNA was depleted using RiboMinus kit A10837 08 Eukaryote Kit followed by directional RNA library preparation according to Illumina's standard protocol. Detailed experimental procedures and bioinformatics analysis can be found in the supplemental method section of the paper.			RNA-Seq	TRANSCRIPTOMIC	RT-PCR	SINGLE	ILLUMINA	Illumina HiSeq 1000	<SPOT_DESCRIPTOR><SPOT_DECODE_SPEC><SPOT_LENGTH>50</SPOT_LENGTH><READ_SPEC><READ_INDEX>0</READ_INDEX><READ_CLASS>Application Read</READ_CLASS><READ_TYPE>Forward</READ_TYPE><BASE_COORD>1</BASE_COORD></READ_SPEC></SPOT_DECODE_SPEC></SPOT_DESCRIPTOR>	SRP020008			muscle_RNAseq_totalRNARibominus_SE_9084X1_120420_SN141_0500_AD0TG5ACXX_5.txt.gz	Illumina native	3506573750.0	70131475.0	9084X1 120420 SN141 0500 AD0TG5ACXX 5	0:50	A:872717534;C:808774955;G:1036781008;T:777391447;N:10908806	50				872717534	808774955	1036781008	777391447	10908806	SRX257154	SRS405708	SRA072148	University of Utah\|Brad Cairns Lab	University of Utah	1	0.61428		0.09813		0.89305		0.6908		50		B		usable mapping rate	illumina	hiseq_era	unknown	rrna_depletion	unknown	bulk	unknown	unknown		United States	2013-05-07	Undetermined	Embryo	Muscle	Muscular System

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE run_metadata("run.accession" VARCHAR, "experiment.accession" VARCHAR, "sample.accession" VARCHAR, "study.accession" VARCHAR, bioproject VARCHAR, "study.title" VARCHAR, "study.alias" VARCHAR, "study.type" VARCHAR, "study.abstract" VARCHAR, "study.attributes" VARCHAR, "study.PMIDs" VARCHAR, "sample.description" VARCHAR, "sample.title" VARCHAR, "sample.alias" VARCHAR, "sample.centername" VARCHAR, "sample.attributes" VARCHAR, "GEOsample.title" VARCHAR, "GEOsample.dataprocessing" VARCHAR, "GEOsample.source" VARCHAR, "GEOsample.treatmentprotocol" VARCHAR, "GEOsample.extractprotocol" VARCHAR, "GEOsample.growthprotocol" VARCHAR, "GEOsample.characteristics" VARCHAR, "GEOsample.accession" VARCHAR, "experiment.title" VARCHAR, "experiment.alias" VARCHAR, "experiment.library_name" VARCHAR, "experiment.design_description" VARCHAR, "experiment.library_construction_protocol" VARCHAR, "experiment.attributes" VARCHAR, "experiment.library_strategy" VARCHAR, "experiment.library_source" VARCHAR, "experiment.library_selection" VARCHAR, "experiment.library_layout" VARCHAR, "experiment.platform" VARCHAR, "experiment.instrument_model" VARCHAR, "experiment.spot_descriptor" VARCHAR, "experiment.study_ref" VARCHAR, "run.title" VARCHAR, "run.attributes" VARCHAR, "run.filename" VARCHAR, "run.semantic_name" VARCHAR, "run.total_bases" DOUBLE, "run.total_spots" DOUBLE, "run.alias" VARCHAR, "run.read_lengths" VARCHAR, "run.base_counts" VARCHAR, "run.r1_length" BIGINT, "run.r2_length" BIGINT, "run.r3_length" BIGINT, "run.r4_length" BIGINT, "run.Acount" BIGINT, "run.Ccount" BIGINT, "run.Gcount" BIGINT, "run.Tcount" BIGINT, "run.Ncount" BIGINT, "run.experiment" VARCHAR, "run.pool_member" VARCHAR, "submission.accession" VARCHAR, "submission.srasource" VARCHAR, "submission.bioprojectsource" VARCHAR, "seqdetective.n_mates" BIGINT, "seqdetective.mapping_rate.mate1" DOUBLE, "seqdetective.mapping_rate.mate2" DOUBLE, "seqdetective.nofeature_rate.mate1" DOUBLE, "seqdetective.nofeature_rate.mate2" DOUBLE, "seqdetective.sparsity.mate1" DOUBLE, "seqdetective.sparsity.mate2" DOUBLE, "seqdetective.pos_strand_rate.mate1" DOUBLE, "seqdetective.pos_strand_rate.mate2" DOUBLE, "seqdetective.readlen.mate1" BIGINT, "seqdetective.readlen.mate2" BIGINT, "seqdetective.judgement.mate1" VARCHAR, "seqdetective.judgement.mate2" VARCHAR, "seqdetective.judgement.reason" VARCHAR, platform_family VARCHAR, instrument_generation VARCHAR, read_bias VARCHAR, selection_class VARCHAR, prep_kit VARCHAR, sc_or_bulk VARCHAR, tech_class VARCHAR, technology VARCHAR, tech_variant VARCHAR, "submission.bioprojectsource.country" VARCHAR, earliest_date DATE, devstage_curation VARCHAR, devstage_curation_coarse VARCHAR, tissue_curation VARCHAR, tissue_curation_coarse VARCHAR);;
CREATE INDEX idx_run_bioproject ON run_metadata(bioproject);;
CREATE INDEX idx_run_run_accession ON run_metadata("run.accession");;