metadata: run_metadata: 6 rows where experiment.library_selection = "PCR", experiment.library_source = "TRANSCRIPTOMIC" and experiment.platform = "DNBSEQ"

6 rows where experiment.library_selection = "PCR", experiment.library_source = "TRANSCRIPTOMIC" and experiment.platform = "DNBSEQ"

descending

Link	rowid ▼	run.accession	experiment.accession	sample.accession	study.accession	bioproject	study.title	study.alias	study.type	study.abstract	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.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.nofeature_rate.mate1	seqdetective.sparsity.mate1	seqdetective.pos_strand_rate.mate1	seqdetective.readlen.mate1	seqdetective.judgement.mate1	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
70859	70859	SRR20789445	SRX16809298	SRS14430425	SRP389652	PRJNA865655	Effects of microplastic leachate and a typical plastic additive on the early development of zebrafish embryos and the gut microbiota of adult zebrafish	PRJNA865655	Other	To investigate the toxic effects of microplastic leachate and antioxidant 2 4 Di tert butylphenol 2 4 DTBP which is a composition of microplastic leachate on zebrafish embryonic development and zebrafish adult intestinal flora we collected agricultural films simulated environmental fragmentation and light processes indoors and examined microplastic leachate components. 2 4 DTBP from microplastic leachate alters the transcription levels of genes related to digestion and absorption in zebrafish larvae and the composition of intestinal flora in adult fish hinders energy uptake and utilization in zebrafish interferes with the process of glucolipid metabolism and leads to disease organ malformation and even death in zebrafish.	DTBP3	strain:AB\|breed:zebrafish\|dev stage:96h\|sex:not determined\|tissue:whole organism\|birth location:120.498664E、36.161313N\|BioSampleModel:Model organism or animal	RNA Seq of larvae from Danio rerio exposed to DMSO	DTBP3	DTBP3	tissues	RNA-Seq	TRANSCRIPTOMIC	PCR	PAIRED	DNBSEQ	DNBSEQ-G50	SRP389652	DTBP3_1.fq.gz DTBP3_2.fq.gz	fastq fastq	6640654800.0	44271032.0	DTBP3 1.fq.gz	0:150 1:150	A:1857715776;C:1468251534;G:1450498102;T:1864102458;N:86930	150	150	1857715776	1468251534	1450498102	1864102458	86930	SRX16809298	SRS14430425	SRA1468070	Ocean University of China\|College of Wnvironmental Science and Engineering	Ocean University of China	1	0.87483	0.13614	0.69459	0.50402	150	B	usable mapping rate	bgi	bgi	unknown	random_priming	unknown	bulk	unknown	unknown	China	2022-08-03	Larval	Larval	Whole Organism	All anatomical structures
70860	70860	SRR20789446	SRX16809297	SRS14430426	SRP389652	PRJNA865655	Effects of microplastic leachate and a typical plastic additive on the early development of zebrafish embryos and the gut microbiota of adult zebrafish	PRJNA865655	Other	To investigate the toxic effects of microplastic leachate and antioxidant 2 4 Di tert butylphenol 2 4 DTBP which is a composition of microplastic leachate on zebrafish embryonic development and zebrafish adult intestinal flora we collected agricultural films simulated environmental fragmentation and light processes indoors and examined microplastic leachate components. 2 4 DTBP from microplastic leachate alters the transcription levels of genes related to digestion and absorption in zebrafish larvae and the composition of intestinal flora in adult fish hinders energy uptake and utilization in zebrafish interferes with the process of glucolipid metabolism and leads to disease organ malformation and even death in zebrafish.	DTBP2	strain:AB\|breed:zebrafish\|dev stage:96h\|sex:not determined\|tissue:whole organism\|birth location:120.498664E、36.161311N\|BioSampleModel:Model organism or animal	RNA Seq of larvae from Danio rerio exposed to DMSO	DTBP2	DTBP2	tissues	RNA-Seq	TRANSCRIPTOMIC	PCR	PAIRED	DNBSEQ	DNBSEQ-G50	SRP389652	DTBP2_1.fq.gz DTBP2_2.fq.gz	fastq fastq	6612930300.0	44086202.0	DTBP2 1.fq.gz	0:150 1:150	A:1843555432;C:1467844074;G:1451826890;T:1849614860;N:89044	150	150	1843555432	1467844074	1451826890	1849614860	89044	SRX16809297	SRS14430426	SRA1468070	Ocean University of China\|College of Wnvironmental Science and Engineering	Ocean University of China	1	0.87565	0.13532	0.69489	0.49286	150	B	usable mapping rate	bgi	bgi	unknown	random_priming	unknown	bulk	unknown	unknown	China	2022-08-03	Larval	Larval	Whole Organism	All anatomical structures
70861	70861	SRR20789447	SRX16809296	SRS14430424	SRP389652	PRJNA865655	Effects of microplastic leachate and a typical plastic additive on the early development of zebrafish embryos and the gut microbiota of adult zebrafish	PRJNA865655	Other	To investigate the toxic effects of microplastic leachate and antioxidant 2 4 Di tert butylphenol 2 4 DTBP which is a composition of microplastic leachate on zebrafish embryonic development and zebrafish adult intestinal flora we collected agricultural films simulated environmental fragmentation and light processes indoors and examined microplastic leachate components. 2 4 DTBP from microplastic leachate alters the transcription levels of genes related to digestion and absorption in zebrafish larvae and the composition of intestinal flora in adult fish hinders energy uptake and utilization in zebrafish interferes with the process of glucolipid metabolism and leads to disease organ malformation and even death in zebrafish.	DTBP1	strain:AB\|breed:zebrafish\|dev stage:96h\|sex:not determined\|tissue:whole organism\|birth location:120.498664E、36.161309N\|BioSampleModel:Model organism or animal	RNA Seq of larvae from Danio rerio exposed to DMSO	DTBP1	DTBP1	tissues	RNA-Seq	TRANSCRIPTOMIC	PCR	PAIRED	DNBSEQ	DNBSEQ-G50	SRP389652	DTBP1_2.fq.gz DTBP1_1.fq.gz	fastq fastq	6661758000.0	44411720.0	DTBP1 1.fq.gz	0:150 1:150	A:1852821325;C:1483402791;G:1464548936;T:1860899167;N:85781	150	150	1852821325	1483402791	1464548936	1860899167	85781	SRX16809296	SRS14430424	SRA1468070	Ocean University of China\|College of Wnvironmental Science and Engineering	Ocean University of China	1	0.85082	0.13289	0.69698	0.48384	150	B	usable mapping rate	bgi	bgi	unknown	random_priming	unknown	bulk	unknown	unknown	China	2022-08-03	Larval	Larval	Whole Organism	All anatomical structures
70862	70862	SRR20789448	SRX16809295	SRS14430423	SRP389652	PRJNA865655	Effects of microplastic leachate and a typical plastic additive on the early development of zebrafish embryos and the gut microbiota of adult zebrafish	PRJNA865655	Other	To investigate the toxic effects of microplastic leachate and antioxidant 2 4 Di tert butylphenol 2 4 DTBP which is a composition of microplastic leachate on zebrafish embryonic development and zebrafish adult intestinal flora we collected agricultural films simulated environmental fragmentation and light processes indoors and examined microplastic leachate components. 2 4 DTBP from microplastic leachate alters the transcription levels of genes related to digestion and absorption in zebrafish larvae and the composition of intestinal flora in adult fish hinders energy uptake and utilization in zebrafish interferes with the process of glucolipid metabolism and leads to disease organ malformation and even death in zebrafish.	CK3	strain:AB\|breed:zebrafish\|dev stage:96h\|sex:not determined\|tissue:whole organism\|birth location:120.498664E、36.161307N\|BioSampleModel:Model organism or animal	RNA Seq of larvae from Danio rerio exposed to DMSO	CK3	CK3	tissues	RNA-Seq	TRANSCRIPTOMIC	PCR	PAIRED	DNBSEQ	DNBSEQ-G50	SRP389652	CK3_1.fq.gz CK3_2.fq.gz	fastq fastq	6632165700.0	44214438.0	CK3 1.fq.gz	0:150 1:150	A:1838766908;C:1481172882;G:1465701380;T:1846438539;N:85991	150	150	1838766908	1481172882	1465701380	1846438539	85991	SRX16809295	SRS14430423	SRA1468070	Ocean University of China\|College of Wnvironmental Science and Engineering	Ocean University of China	1	0.87731	0.13142	0.68641	0.48874	150	B	usable mapping rate	bgi	bgi	unknown	random_priming	unknown	bulk	unknown	unknown	China	2022-08-03	Larval	Larval	Whole Organism	All anatomical structures
70863	70863	SRR20789449	SRX16809294	SRS14430422	SRP389652	PRJNA865655	Effects of microplastic leachate and a typical plastic additive on the early development of zebrafish embryos and the gut microbiota of adult zebrafish	PRJNA865655	Other	To investigate the toxic effects of microplastic leachate and antioxidant 2 4 Di tert butylphenol 2 4 DTBP which is a composition of microplastic leachate on zebrafish embryonic development and zebrafish adult intestinal flora we collected agricultural films simulated environmental fragmentation and light processes indoors and examined microplastic leachate components. 2 4 DTBP from microplastic leachate alters the transcription levels of genes related to digestion and absorption in zebrafish larvae and the composition of intestinal flora in adult fish hinders energy uptake and utilization in zebrafish interferes with the process of glucolipid metabolism and leads to disease organ malformation and even death in zebrafish.	CK2	strain:AB\|breed:zebrafish\|dev stage:96h\|sex:not determined\|tissue:whole organism\|birth location:120.498664E、36.161305N\|BioSampleModel:Model organism or animal	RNA Seq of larvae from Danio rerio exposed to DMSO	CK2	CK2	tissues	RNA-Seq	TRANSCRIPTOMIC	PCR	PAIRED	DNBSEQ	DNBSEQ-G50	SRP389652	CK2_2.fq.gz CK2_1.fq.gz	fastq fastq	6471271800.0	43141812.0	CK2 1.fq.gz	0:150 1:150	A:2017142143;C:1222481695;G:1205635015;T:2025887170;N:125777	150	150	2017142143	1222481695	1205635015	2025887170	125777	SRX16809294	SRS14430422	SRA1468070	Ocean University of China\|College of Wnvironmental Science and Engineering	Ocean University of China	1	0.82447	0.36752	0.80121	0.68898	150	B	usable mapping rate	bgi	bgi	unknown	random_priming	unknown	bulk	unknown	unknown	China	2022-08-03	Larval	Larval	Whole Organism	All anatomical structures
70864	70864	SRR20789450	SRX16809293	SRS14430421	SRP389652	PRJNA865655	Effects of microplastic leachate and a typical plastic additive on the early development of zebrafish embryos and the gut microbiota of adult zebrafish	PRJNA865655	Other	To investigate the toxic effects of microplastic leachate and antioxidant 2 4 Di tert butylphenol 2 4 DTBP which is a composition of microplastic leachate on zebrafish embryonic development and zebrafish adult intestinal flora we collected agricultural films simulated environmental fragmentation and light processes indoors and examined microplastic leachate components. 2 4 DTBP from microplastic leachate alters the transcription levels of genes related to digestion and absorption in zebrafish larvae and the composition of intestinal flora in adult fish hinders energy uptake and utilization in zebrafish interferes with the process of glucolipid metabolism and leads to disease organ malformation and even death in zebrafish.	CK1	strain:AB\|breed:zebrafish\|dev stage:96h\|sex:not determined\|tissue:whole organism\|birth location:120.498664E、36.161303N\|BioSampleModel:Model organism or animal	RNA Seq of larvae from Danio rerio exposed to DMSO	CK1	CK1	tissues	RNA-Seq	TRANSCRIPTOMIC	PCR	PAIRED	DNBSEQ	DNBSEQ-G50	SRP389652	CK1_2.fq.gz CK1_1.fq.gz	fastq fastq	6653620200.0	44357468.0	CK1 1.fq.gz	0:150 1:150	A:1846923508;C:1483544965;G:1467204186;T:1855860338;N:87203	150	150	1846923508	1483544965	1467204186	1855860338	87203	SRX16809293	SRS14430421	SRA1468070	Ocean University of China\|College of Wnvironmental Science and Engineering	Ocean University of China	1	0.88292	0.12768	0.69936	0.49774	150	B	usable mapping rate	bgi	bgi	unknown	random_priming	unknown	bulk	unknown	unknown	China	2022-08-03	Larval	Larval	Whole Organism	All anatomical structures

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