metadata: run_metadata: 5 rows where experiment.library_selection = "RT-PCR" and tissue_curation

5 rows where experiment.library_selection = "RT-PCR" and tissue_curation_coarse = "Embryo Imprecise"

descending

Link	rowid ▼	run.accession	experiment.accession	sample.accession	study.accession	bioproject	study.title	study.alias	study.type	study.abstract	study.PMIDs	sample.description	sample.title	sample.alias	sample.attributes	experiment.title	experiment.alias	experiment.library_name	experiment.design_description	experiment.library_strategy	experiment.library_source	experiment.library_selection	experiment.library_layout	experiment.platform	experiment.instrument_model	experiment.spot_descriptor	experiment.study_ref	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.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	submission.bioprojectsource.country	earliest_date	devstage_curation	devstage_curation_coarse	tissue_curation	tissue_curation_coarse
29215	29215	SRR27489731	SRX23160978	SRS20111136	SRP483112	PRJNA1056276	five prime UTR MPRA during early zebrafish embryogenesis	PRJNA1056276	Other	The goal is to determine the contribution of zebrafish five prime UTR sequences to translation initiation. The five prime UTR MPRA reporter library was injected at the 1 cell stage and samples were collected during early stages of embryogenesis. Polysome profiling was performed to quantify ribosome occupancy of each five prime UTR reporter.		RNA product	control RNA library	RNA mMessage MPRA library	strain:not applicable\|age:not applicable\|dev stage:not applicable\|collection date:2022 05 16\|geo loc name:Switzerland: Basel\|sex:not applicable\|tissue:not applicable\|biomaterial provider:Schier lab\|collected by:Madalena M. Reimao Pinto\|genotype:not applicable\|growth protocol:not applicable\|sample type:IVT mRNA\|sample number:50\|replicate:unique sample\|BioSampleModel:Model organism or animal	control RNA library	Library 50	Library 50	PCR product was amplified from DNA plasmid pool with reporter specific primer UMI were introduced ath the five primeend and library was amplified to include adapters compatible with Illumina sequencing.	OTHER	TRANSCRIPTOMIC	RT-PCR	PAIRED	ILLUMINA	Illumina NovaSeq 6000		SRP483112	BSSE_QGF_206685_HGWLYDSX3_3_RNA_mMessage_MPRA_library_test_GGTTATAA_GATATCGA_S50_L003_R1_001_MM_1.fastq.gz BSSE_QGF_206685_HGWLYDSX3_3_RNA_mMessage_MPRA_library_test_GGTTATAA_GATATCGA_S50_L003_R2_001_MM_1.fastq.gz	fastq fastq	16695252486.0	55282293.0	BSSE QGF 206685 HGWLYDSX3 3 RNA mMessage MPRA library test GGTTATAA GATATCGA S50 L003 R1 001 MM 1.fastq.gz	0:151 1:151	A:4275447149;C:4413405571;G:3936523108;T:4069049357;N:827301	151	151	4275447149	4413405571	3936523108	4069049357	827301	SRX23160978	SRS20111136	SRA1775336	University of Basel\|Biozentrum Basel	University of Basel	2	0.02176	0.00021	0.00058	2e-05	0.99056	0.99933	0.41475	0.48571	151	151	T	T	mates < 9% mapping rate	illumina	novaseq_era	5prime	other	unknown	bulk	unknown	unknown	Switzerland	2024-01-11	Undetermined	Embryo	Undetermined	Embryo Imprecise
36666	36666	SRR800043	SRX257153	SRS405345	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	sphere RNAseq totalRNARibominus	strain:Tubingen\|label:PE: paired end SE: single end\|development stage:sphere	sphere RNAseq totalRNARibominus	sphere RNAseq totalRNARibominus	7986X2	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 2000	<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	sphere_RNAseq_totalRNARibominus_SE_7986X2_110510_SN141_0338_AB06MWABXX_7.txt.gz	Illumina native	3029181300.0	60583626.0	7986X2 110510 SN141 0338 AB06MWABXX 7	0:50	A:768949744;C:733340278;G:903149841;T:623482299;N:259138	50		768949744	733340278	903149841	623482299	259138	SRX257153	SRS405345	SRA072148	University of Utah\|Brad Cairns Lab	University of Utah	1	0.83515		0.15524		0.81209		0.81031		50		B		usable mapping rate	illumina	hiseq_era	unknown	rrna_depletion	unknown	bulk	unknown	unknown	United States	2015-07-22	Blastula	Embryo	Undetermined	Embryo Imprecise
36667	36667	SRR800044	SRX257153	SRS405345	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	sphere RNAseq totalRNARibominus	strain:Tubingen\|label:PE: paired end SE: single end\|development stage:sphere	sphere RNAseq totalRNARibominus	sphere RNAseq totalRNARibominus	7986X2	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 2000	<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	sphere_RNAseq_totalRNARibominus_SE_7986X2_110606_SN141_0359_BD0D8KABXX_6.txt.gz	Illumina native	3947123500.0	78942470.0	7986X2 110606 SN141 0359 BD0D8KABXX 6	0:50	A:1000468440;C:957437794;G:1171831772;T:817292633;N:92861	50		1000468440	957437794	1171831772	817292633	92861	SRX257153	SRS405345	SRA072148	University of Utah\|Brad Cairns Lab	University of Utah	1	0.81283		0.14906		0.81335		0.81698		50		B		usable mapping rate	illumina	hiseq_era	unknown	rrna_depletion	unknown	bulk	unknown	unknown	United States	2015-07-22	Blastula	Embryo	Undetermined	Embryo Imprecise
36668	36668	SRR800037	SRX257149	SRS405106	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	egg RNAseq totalRNARibominus	strain:Tubingen\|label:PE: paired end SE: single end\|dev stage:egg	egg RNAseq totalRNARibominus	egg RNAseq totalRNARibominus	7784X1	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 2000	<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			3584440000.0	71688800.0	7784X1 110323 SN141 0332 A81FDVABXX 8	0:50	A:1013532157;C:812179975;G:992916103;T:765761452;N:50313	50		1013532157	812179975	992916103	765761452	50313	SRX257149	SRS405106	SRA072148	University of Utah\|Brad Cairns Lab	University of Utah	1	0.87304		0.12853		0.81988		0.80407		50		B		usable mapping rate	illumina	hiseq_era	unknown	rrna_depletion	unknown	bulk	unknown	unknown	United States	2013-04-01	Undetermined	Embryo	Undetermined	Embryo Imprecise
36669	36669	SRR800038	SRX257149	SRS405106	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	egg RNAseq totalRNARibominus	strain:Tubingen\|label:PE: paired end SE: single end\|dev stage:egg	egg RNAseq totalRNARibominus	egg RNAseq totalRNARibominus	7784X1	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 2000	<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			2794240450.0	55884809.0	7784X1 110119 SN141 0323 B8162JABXX 8	0:50	A:792200981;C:632130044;G:772351331;T:596980885;N:577209	50		792200981	632130044	772351331	596980885	577209	SRX257149	SRS405106	SRA072148	University of Utah\|Brad Cairns Lab	University of Utah	1	0.86104		0.12909		0.82266		0.80894		50		B		usable mapping rate	illumina	hiseq_era	unknown	rrna_depletion	unknown	bulk	unknown	unknown	United States	2013-04-01	Undetermined	Embryo	Undetermined	Embryo Imprecise

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");;