metadata: run_metadata: 21 rows where experiment.library_layout = "PAIRED", experiment.library_selection = "other" and tissue_curation

21 rows where experiment.library_layout = "PAIRED", experiment.library_selection = "other" 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.attributes	sample.title	sample.alias	sample.centername	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.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.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
9337	9337	ERR2865439	ERX2871399	ERS2871019	ERP111778	PRJEB29472	RNAseq analysis of slbp mutants in Zebrafish	ena-STUDY-Department of Cell and Developmental Biology-01-11-2018-15:10:58:144-14	Other	Through forward genetic screening for mutations affecting visual system development we identified prominent coloboma and cell autonomous retinal neuron differentiation lamination and retinal axon projection defects in eisspalte ele mutant zebrafish. Additional axonal deficits were present most notably at midline axon commissures. Genetic mapping and cloning of the ele mutation showed that the affected gene is slbp which encodes a conserved RNA stem loop binding protein involved in replication dependent histone mRNA metabolism. Cells throughout the central nervous system remained in the cell cycle in ele mutant embryos at stages when and locations where post mitotic cells have differentiated in wild type siblings. Indeed RNAseq analysis showed down regulation of many genes associated with neuronal differentiation. This was coincident with changes in the levels and spatial localisation of expression of various genes implicated for instance in axon guidance that likely underlie specific ele phenotypes. These results suggest that many of the cell and tissue specific phenotypes in ele mutant embryos are secondary to altered expression of modules of developmental regulatory genes that characterise or promote transitions in cell state and require the correct function of Slbp dependent histone and chromatin regulatory genes.	ENA FIRST PUBLIC:2018 11 02\|ENA LAST UPDATE:2018 11 01	sibling 3	SAMEA5059848	Department of Cell and Developmental Biology	ENA FIRST PUBLIC:2018 11 02T17:01:55Z\|ENA LAST UPDATE:2018 11 01T15:11:02Z\|External Id:SAMEA5059848\|INSDC center name:Department of Cell and Developmental Biology\|INSDC first public:2018 11 02T17:01:55Z\|INSDC last update:2018 11 01T15:11:02Z\|INSDC status:public\|Submitter Id:ele sibling3\|common name:zebrafish\|sample name:ele sibling3\|scientific name:Danio rerio	Illumina HiSeq 3000 paired end sequencing	ena EXPERIMENT Department of Cell and Developmental Biology 01 11 2018 15:10:57:717 6	unspecified	1	RNA-Seq	TRANSCRIPTOMIC	other	PAIRED	ILLUMINA	Illumina HiSeq 3000	ERP111778	Illumina HiSeq 3000 paired end sequencing	ENA FIRST PUBLIC:2018 11 02\|ENA LAST UPDATE:2018 11 16	ele_sib_F_CTTGTA_L004_R2_001.fastq.gz ele_sib_F_CTTGTA_L004_R1_001.fastq.gz	fastq fastq	2823621200.0	14118106.0	ena RUN Department of Cell and Developmental Biology 01 11 2018 15:10:57:717 6	0:100 1:100	A:752781583;C:663838191;G:656422705;T:750213027;N:365694	100	100	752781583	663838191	656422705	750213027	365694	ERX2871399	ERS2871019	ERA1643817	Department of Cell and Developmental Biology\|European Nucleotide Archive	Department of Cell and Developmental Biology	2	0.95595	0.95486	0.09407	0.09431	0.67529	0.67673	0.45173	0.44515	100	100	B	B	biological fallback assumption	illumina	hiseq_era	unknown	other	unknown	bulk	unknown	unknown	Unknown	2018-11-01	Undetermined	Embryo	Undetermined	Embryo Imprecise
9338	9338	ERR2865438	ERX2871398	ERS2871018	ERP111778	PRJEB29472	RNAseq analysis of slbp mutants in Zebrafish	ena-STUDY-Department of Cell and Developmental Biology-01-11-2018-15:10:58:144-14	Other	Through forward genetic screening for mutations affecting visual system development we identified prominent coloboma and cell autonomous retinal neuron differentiation lamination and retinal axon projection defects in eisspalte ele mutant zebrafish. Additional axonal deficits were present most notably at midline axon commissures. Genetic mapping and cloning of the ele mutation showed that the affected gene is slbp which encodes a conserved RNA stem loop binding protein involved in replication dependent histone mRNA metabolism. Cells throughout the central nervous system remained in the cell cycle in ele mutant embryos at stages when and locations where post mitotic cells have differentiated in wild type siblings. Indeed RNAseq analysis showed down regulation of many genes associated with neuronal differentiation. This was coincident with changes in the levels and spatial localisation of expression of various genes implicated for instance in axon guidance that likely underlie specific ele phenotypes. These results suggest that many of the cell and tissue specific phenotypes in ele mutant embryos are secondary to altered expression of modules of developmental regulatory genes that characterise or promote transitions in cell state and require the correct function of Slbp dependent histone and chromatin regulatory genes.	ENA FIRST PUBLIC:2018 11 02\|ENA LAST UPDATE:2018 11 01	sibling 2	SAMEA5059847	Department of Cell and Developmental Biology	ENA FIRST PUBLIC:2018 11 02T17:01:55Z\|ENA LAST UPDATE:2018 11 01T15:11:02Z\|External Id:SAMEA5059847\|INSDC center name:Department of Cell and Developmental Biology\|INSDC first public:2018 11 02T17:01:55Z\|INSDC last update:2018 11 01T15:11:02Z\|INSDC status:public\|Submitter Id:ele sibling2\|common name:zebrafish\|sample name:ele sibling2\|scientific name:Danio rerio	Illumina HiSeq 3000 paired end sequencing	ena EXPERIMENT Department of Cell and Developmental Biology 01 11 2018 15:10:57:717 5	unspecified	1	RNA-Seq	TRANSCRIPTOMIC	other	PAIRED	ILLUMINA	Illumina HiSeq 3000	ERP111778	Illumina HiSeq 3000 paired end sequencing	ENA FIRST PUBLIC:2018 11 02\|ENA LAST UPDATE:2018 11 16	ele_sib_D_GCCAAT_L004_R1_001.fastq.gz ele_sib_D_GCCAAT_L004_R2_001.fastq.gz	fastq fastq	4217962600.0	21089813.0	ena RUN Department of Cell and Developmental Biology 01 11 2018 15:10:57:717 5	0:100 1:100	A:1119324653;C:996982862;G:984906708;T:1116209552;N:538825	100	100	1119324653	996982862	984906708	1116209552	538825	ERX2871398	ERS2871018	ERA1643817	Department of Cell and Developmental Biology\|European Nucleotide Archive	Department of Cell and Developmental Biology	2	0.95341	0.95274	0.09215	0.09238	0.67296	0.67493	0.46185	0.4648	100	100	B	B	biological fallback assumption	illumina	hiseq_era	unknown	other	unknown	bulk	unknown	unknown	Unknown	2018-11-01	Undetermined	Embryo	Undetermined	Embryo Imprecise
9339	9339	ERR2865437	ERX2871397	ERS2871017	ERP111778	PRJEB29472	RNAseq analysis of slbp mutants in Zebrafish	ena-STUDY-Department of Cell and Developmental Biology-01-11-2018-15:10:58:144-14	Other	Through forward genetic screening for mutations affecting visual system development we identified prominent coloboma and cell autonomous retinal neuron differentiation lamination and retinal axon projection defects in eisspalte ele mutant zebrafish. Additional axonal deficits were present most notably at midline axon commissures. Genetic mapping and cloning of the ele mutation showed that the affected gene is slbp which encodes a conserved RNA stem loop binding protein involved in replication dependent histone mRNA metabolism. Cells throughout the central nervous system remained in the cell cycle in ele mutant embryos at stages when and locations where post mitotic cells have differentiated in wild type siblings. Indeed RNAseq analysis showed down regulation of many genes associated with neuronal differentiation. This was coincident with changes in the levels and spatial localisation of expression of various genes implicated for instance in axon guidance that likely underlie specific ele phenotypes. These results suggest that many of the cell and tissue specific phenotypes in ele mutant embryos are secondary to altered expression of modules of developmental regulatory genes that characterise or promote transitions in cell state and require the correct function of Slbp dependent histone and chromatin regulatory genes.	ENA FIRST PUBLIC:2018 11 02\|ENA LAST UPDATE:2018 11 01	sibling 1	SAMEA5059846	Department of Cell and Developmental Biology	ENA FIRST PUBLIC:2018 11 02T17:01:55Z\|ENA LAST UPDATE:2018 11 01T15:11:02Z\|External Id:SAMEA5059846\|INSDC center name:Department of Cell and Developmental Biology\|INSDC first public:2018 11 02T17:01:55Z\|INSDC last update:2018 11 01T15:11:02Z\|INSDC status:public\|Submitter Id:ele sibling1\|common name:zebrafish\|sample name:ele sibling1\|scientific name:Danio rerio	Illumina HiSeq 3000 paired end sequencing	ena EXPERIMENT Department of Cell and Developmental Biology 01 11 2018 15:10:57:717 4	unspecified	1	RNA-Seq	TRANSCRIPTOMIC	other	PAIRED	ILLUMINA	Illumina HiSeq 3000	ERP111778	Illumina HiSeq 3000 paired end sequencing	ENA FIRST PUBLIC:2018 11 02\|ENA LAST UPDATE:2018 11 16	ele_sib_B_TGACCA_L004_R1_001.fastq.gz ele_sib_B_TGACCA_L004_R2_001.fastq.gz	fastq fastq	5241628000.0	26208140.0	ena RUN Department of Cell and Developmental Biology 01 11 2018 15:10:57:717 4	0:100 1:100	A:1393802799;C:1235804455;G:1219328189;T:1392021956;N:670601	100	100	1393802799	1235804455	1219328189	1392021956	670601	ERX2871397	ERS2871017	ERA1643817	Department of Cell and Developmental Biology\|European Nucleotide Archive	Department of Cell and Developmental Biology	2	0.95296	0.95133	0.10275	0.1028	0.67018	0.67146	0.46488	0.46482	100	100	B	B	biological fallback assumption	illumina	hiseq_era	unknown	other	unknown	bulk	unknown	unknown	Unknown	2018-11-01	Undetermined	Embryo	Undetermined	Embryo Imprecise
9340	9340	ERR2865436	ERX2871396	ERS2871016	ERP111778	PRJEB29472	RNAseq analysis of slbp mutants in Zebrafish	ena-STUDY-Department of Cell and Developmental Biology-01-11-2018-15:10:58:144-14	Other	Through forward genetic screening for mutations affecting visual system development we identified prominent coloboma and cell autonomous retinal neuron differentiation lamination and retinal axon projection defects in eisspalte ele mutant zebrafish. Additional axonal deficits were present most notably at midline axon commissures. Genetic mapping and cloning of the ele mutation showed that the affected gene is slbp which encodes a conserved RNA stem loop binding protein involved in replication dependent histone mRNA metabolism. Cells throughout the central nervous system remained in the cell cycle in ele mutant embryos at stages when and locations where post mitotic cells have differentiated in wild type siblings. Indeed RNAseq analysis showed down regulation of many genes associated with neuronal differentiation. This was coincident with changes in the levels and spatial localisation of expression of various genes implicated for instance in axon guidance that likely underlie specific ele phenotypes. These results suggest that many of the cell and tissue specific phenotypes in ele mutant embryos are secondary to altered expression of modules of developmental regulatory genes that characterise or promote transitions in cell state and require the correct function of Slbp dependent histone and chromatin regulatory genes.	ENA FIRST PUBLIC:2018 11 02\|ENA LAST UPDATE:2018 11 01	mutant3	SAMEA5059845	Department of Cell and Developmental Biology	ENA FIRST PUBLIC:2018 11 02T17:01:55Z\|ENA LAST UPDATE:2018 11 01T15:11:02Z\|External Id:SAMEA5059845\|INSDC center name:Department of Cell and Developmental Biology\|INSDC first public:2018 11 02T17:01:55Z\|INSDC last update:2018 11 01T15:11:02Z\|INSDC status:public\|Submitter Id:ele mutant3\|common name:zebrafish\|sample name:ele mutant3\|scientific name:Danio rerio	Illumina HiSeq 3000 paired end sequencing	ena EXPERIMENT Department of Cell and Developmental Biology 01 11 2018 15:10:57:717 3	unspecified	1	RNA-Seq	TRANSCRIPTOMIC	other	PAIRED	ILLUMINA	Illumina HiSeq 3000	ERP111778	Illumina HiSeq 3000 paired end sequencing	ENA FIRST PUBLIC:2018 11 02\|ENA LAST UPDATE:2018 11 16	ele_E_CAGATC_L004_R1_001.fastq.gz ele_E_CAGATC_L004_R2_001.fastq.gz	fastq fastq	3529752000.0	17648760.0	ena RUN Department of Cell and Developmental Biology 01 11 2018 15:10:57:717 3	0:100 1:100	A:933354224;C:837396695;G:828677816;T:929860782;N:462483	100	100	933354224	837396695	828677816	929860782	462483	ERX2871396	ERS2871016	ERA1643817	Department of Cell and Developmental Biology\|European Nucleotide Archive	Department of Cell and Developmental Biology	2	0.95621	0.95302	0.08584	0.08536	0.67048	0.67146	0.46615	0.46682	100	100	B	B	biological fallback assumption	illumina	hiseq_era	unknown	other	unknown	bulk	unknown	unknown	Unknown	2018-11-01	Undetermined	Embryo	Undetermined	Embryo Imprecise
9341	9341	ERR2865435	ERX2871395	ERS2871015	ERP111778	PRJEB29472	RNAseq analysis of slbp mutants in Zebrafish	ena-STUDY-Department of Cell and Developmental Biology-01-11-2018-15:10:58:144-14	Other	Through forward genetic screening for mutations affecting visual system development we identified prominent coloboma and cell autonomous retinal neuron differentiation lamination and retinal axon projection defects in eisspalte ele mutant zebrafish. Additional axonal deficits were present most notably at midline axon commissures. Genetic mapping and cloning of the ele mutation showed that the affected gene is slbp which encodes a conserved RNA stem loop binding protein involved in replication dependent histone mRNA metabolism. Cells throughout the central nervous system remained in the cell cycle in ele mutant embryos at stages when and locations where post mitotic cells have differentiated in wild type siblings. Indeed RNAseq analysis showed down regulation of many genes associated with neuronal differentiation. This was coincident with changes in the levels and spatial localisation of expression of various genes implicated for instance in axon guidance that likely underlie specific ele phenotypes. These results suggest that many of the cell and tissue specific phenotypes in ele mutant embryos are secondary to altered expression of modules of developmental regulatory genes that characterise or promote transitions in cell state and require the correct function of Slbp dependent histone and chromatin regulatory genes.	ENA FIRST PUBLIC:2018 11 02\|ENA LAST UPDATE:2018 11 01	mutant2	SAMEA5059844	Department of Cell and Developmental Biology	ENA FIRST PUBLIC:2018 11 02T17:01:55Z\|ENA LAST UPDATE:2018 11 01T15:11:02Z\|External Id:SAMEA5059844\|INSDC center name:Department of Cell and Developmental Biology\|INSDC first public:2018 11 02T17:01:55Z\|INSDC last update:2018 11 01T15:11:02Z\|INSDC status:public\|Submitter Id:ele mutant2\|common name:zebrafish\|sample name:ele mutant2\|scientific name:Danio rerio	Illumina HiSeq 3000 paired end sequencing	ena EXPERIMENT Department of Cell and Developmental Biology 01 11 2018 15:10:57:717 2	unspecified	1	RNA-Seq	TRANSCRIPTOMIC	other	PAIRED	ILLUMINA	Illumina HiSeq 3000	ERP111778	Illumina HiSeq 3000 paired end sequencing	ENA FIRST PUBLIC:2018 11 02\|ENA LAST UPDATE:2018 11 16	ele_C_ACAGTG_L004_R1_001.fastq.gz ele_C_ACAGTG_L004_R2_001.fastq.gz	fastq fastq	3119723800.0	15598619.0	ena RUN Department of Cell and Developmental Biology 01 11 2018 15:10:57:717 2	0:100 1:100	A:828335602;C:736691663;G:727853394;T:826449133;N:394008	100	100	828335602	736691663	727853394	826449133	394008	ERX2871395	ERS2871015	ERA1643817	Department of Cell and Developmental Biology\|European Nucleotide Archive	Department of Cell and Developmental Biology	2	0.94967	0.94864	0.0992	0.09955	0.65928	0.66014	0.47042	0.46835	100	100	B	B	biological fallback assumption	illumina	hiseq_era	unknown	other	unknown	bulk	unknown	unknown	Unknown	2018-11-01	Undetermined	Embryo	Undetermined	Embryo Imprecise
9342	9342	ERR2865434	ERX2871394	ERS2871014	ERP111778	PRJEB29472	RNAseq analysis of slbp mutants in Zebrafish	ena-STUDY-Department of Cell and Developmental Biology-01-11-2018-15:10:58:144-14	Other	Through forward genetic screening for mutations affecting visual system development we identified prominent coloboma and cell autonomous retinal neuron differentiation lamination and retinal axon projection defects in eisspalte ele mutant zebrafish. Additional axonal deficits were present most notably at midline axon commissures. Genetic mapping and cloning of the ele mutation showed that the affected gene is slbp which encodes a conserved RNA stem loop binding protein involved in replication dependent histone mRNA metabolism. Cells throughout the central nervous system remained in the cell cycle in ele mutant embryos at stages when and locations where post mitotic cells have differentiated in wild type siblings. Indeed RNAseq analysis showed down regulation of many genes associated with neuronal differentiation. This was coincident with changes in the levels and spatial localisation of expression of various genes implicated for instance in axon guidance that likely underlie specific ele phenotypes. These results suggest that many of the cell and tissue specific phenotypes in ele mutant embryos are secondary to altered expression of modules of developmental regulatory genes that characterise or promote transitions in cell state and require the correct function of Slbp dependent histone and chromatin regulatory genes.	ENA FIRST PUBLIC:2018 11 02\|ENA LAST UPDATE:2018 11 01	mutant1	SAMEA5059843	Department of Cell and Developmental Biology	ENA FIRST PUBLIC:2018 11 02T17:01:55Z\|ENA LAST UPDATE:2018 11 01T15:11:02Z\|External Id:SAMEA5059843\|INSDC center name:Department of Cell and Developmental Biology\|INSDC first public:2018 11 02T17:01:55Z\|INSDC last update:2018 11 01T15:11:02Z\|INSDC status:public\|Submitter Id:ele mutant1\|common name:zebrafish\|sample name:ele mutant1\|scientific name:Danio rerio	Illumina HiSeq 3000 paired end sequencing	ena EXPERIMENT Department of Cell and Developmental Biology 01 11 2018 15:10:57:716 1	unspecified	1	RNA-Seq	TRANSCRIPTOMIC	other	PAIRED	ILLUMINA	Illumina HiSeq 3000	ERP111778	Illumina HiSeq 3000 paired end sequencing	ENA FIRST PUBLIC:2018 11 02\|ENA LAST UPDATE:2018 11 16	ele_A_CGATGT_L004_R1_001.fastq.gz ele_A_CGATGT_L004_R2_001.fastq.gz	fastq fastq	2181939600.0	10909698.0	ena RUN Department of Cell and Developmental Biology 01 11 2018 15:10:57:717 1	0:100 1:100	A:578028200;C:516249107;G:510965740;T:576417363;N:279190	100	100	578028200	516249107	510965740	576417363	279190	ERX2871394	ERS2871014	ERA1643817	Department of Cell and Developmental Biology\|European Nucleotide Archive	Department of Cell and Developmental Biology	2	0.94968	0.94939	0.1131	0.11293	0.66245	0.66251	0.46654	0.47475	100	100	B	B	biological fallback assumption	illumina	hiseq_era	unknown	other	unknown	bulk	unknown	unknown	Unknown	2018-11-01	Undetermined	Embryo	Undetermined	Embryo Imprecise
33886	33886	SRR30907854	SRX26311176	SRS22839346	SRP537088	PRJNA1167252	Eukaryotic transcriptome sequencing of zebrafish	PRJNA1167252	Other	To study the effects of TDCPP reports on protein expression and RNA transcription in zebrafish		zebrafish	E2 R1		strain:zebrafish\|isolate:missing\|breed:AB\|cultivar:missing\|ecotype:missing\|age:48hpf\|dev stage:48hpf\|collection date:2023 11 30\|geo loc name:missing\|sex:missing\|tissue:missing\|tmp:9\|BioSampleModel:Model organism or animal	zebrafish	9	9	Effects of TDCPP exposure on transcription in zebrafish	RNA-Seq	TRANSCRIPTOMIC	other	PAIRED	ILLUMINA	Illumina MiSeq	SRP537088			L1EFA241016_E2.R1.raw.fastq.gz L1EFA241016_E2.R2.raw.fastq.gz	fastq fastq	8244899282.0	27300991.0	L1EFA241016 E2.R1.raw.fastq.gz	0:151 1:151	A:2186915781;C:1920264424;G:1996130250;T:2141502974;N:85853	151	151	2186915781	1920264424	1996130250	2141502974	85853	SRX26311176	SRS22839346	SRA1987398	Beijing Normal University\|College of Water Sciences	Beijing Normal University												B	B	biological fallback assumption	illumina	miseq	unknown	other	unknown	bulk	unknown	unknown	China	2024-10-08	Hatching	Embryo	Undetermined	Embryo Imprecise
33887	33887	SRR30907855	SRX26311175	SRS22839344	SRP537088	PRJNA1167252	Eukaryotic transcriptome sequencing of zebrafish	PRJNA1167252	Other	To study the effects of TDCPP reports on protein expression and RNA transcription in zebrafish		zebrafish	E1 R1		strain:zebrafish\|isolate:missing\|breed:AB\|cultivar:missing\|ecotype:missing\|age:48hpf\|dev stage:48hpf\|collection date:2023 11 30\|geo loc name:missing\|sex:missing\|tissue:missing\|tmp:7\|BioSampleModel:Model organism or animal	zebrafish	7	7	Effects of TDCPP exposure on transcription in zebrafish	RNA-Seq	TRANSCRIPTOMIC	other	PAIRED	ILLUMINA	Illumina MiSeq	SRP537088			L1EFA241015_E1.R1.raw.fastq.gz L1EFA241015_E1.R2.raw.fastq.gz	fastq fastq	7083661566.0	23455833.0	L1EFA241015 E1.R1.raw.fastq.gz	0:151 1:151	A:1848193884;C:1679679234;G:1751186922;T:1804529897;N:71629	151	151	1848193884	1679679234	1751186922	1804529897	71629	SRX26311175	SRS22839344	SRA1987398	Beijing Normal University\|College of Water Sciences	Beijing Normal University												B	B	biological fallback assumption	illumina	miseq	unknown	other	unknown	bulk	unknown	unknown	China	2024-10-08	Hatching	Embryo	Undetermined	Embryo Imprecise
33888	33888	SRR30907856	SRX26311174	SRS22839345	SRP537088	PRJNA1167252	Eukaryotic transcriptome sequencing of zebrafish	PRJNA1167252	Other	To study the effects of TDCPP reports on protein expression and RNA transcription in zebrafish		zebrafish	A3 R1		strain:zebrafish\|isolate:missing\|breed:AB\|cultivar:missing\|ecotype:missing\|age:48hpf\|dev stage:48hpf\|collection date:2023 11 30\|geo loc name:missing\|sex:missing\|tissue:missing\|tmp:5\|BioSampleModel:Model organism or animal	zebrafish	5	5	Effects of TDCPP exposure on transcription in zebrafish	RNA-Seq	TRANSCRIPTOMIC	other	PAIRED	ILLUMINA	Illumina MiSeq	SRP537088			L1EFA241014_A3.R1.raw.fastq.gz L1EFA241014_A3.R2.raw.fastq.gz	fastq fastq	7926170898.0	26245599.0	L1EFA241014 A3.R1.raw.fastq.gz	0:151 1:151	A:2128209130;C:1819597773;G:1900902610;T:2077378388;N:82997	151	151	2128209130	1819597773	1900902610	2077378388	82997	SRX26311174	SRS22839345	SRA1987398	Beijing Normal University\|College of Water Sciences	Beijing Normal University												B	B	biological fallback assumption	illumina	miseq	unknown	other	unknown	bulk	unknown	unknown	China	2024-10-08	Hatching	Embryo	Undetermined	Embryo Imprecise
33889	33889	SRR30907857	SRX26311173	SRS22839343	SRP537088	PRJNA1167252	Eukaryotic transcriptome sequencing of zebrafish	PRJNA1167252	Other	To study the effects of TDCPP reports on protein expression and RNA transcription in zebrafish		zebrafish	A2 R1		strain:zebrafish\|isolate:missing\|breed:AB\|cultivar:missing\|ecotype:missing\|age:48hpf\|dev stage:48hpf\|collection date:2023 11 30\|geo loc name:missing\|sex:missing\|tissue:missing\|tmp:3\|BioSampleModel:Model organism or animal	zebrafish	3	3	Effects of TDCPP exposure on transcription in zebrafish	RNA-Seq	TRANSCRIPTOMIC	other	PAIRED	ILLUMINA	Illumina MiSeq	SRP537088			L1EFA241013_A2.R1.raw.fastq.gz L1EFA241013_A2.R2.raw.fastq.gz	fastq fastq	7889851774.0	26125337.0	L1EFA241013 A2.R1.raw.fastq.gz	0:151 1:151	A:2121620438;C:1812268472;G:1879664190;T:2076216345;N:82329	151	151	2121620438	1812268472	1879664190	2076216345	82329	SRX26311173	SRS22839343	SRA1987398	Beijing Normal University\|College of Water Sciences	Beijing Normal University												B	B	biological fallback assumption	illumina	miseq	unknown	other	unknown	bulk	unknown	unknown	China	2024-10-08	Hatching	Embryo	Undetermined	Embryo Imprecise
33890	33890	SRR30907858	SRX26311172	SRS22839342	SRP537088	PRJNA1167252	Eukaryotic transcriptome sequencing of zebrafish	PRJNA1167252	Other	To study the effects of TDCPP reports on protein expression and RNA transcription in zebrafish		zebrafish	E3 R1		strain:zebrafish\|isolate:missing\|breed:AB\|cultivar:missing\|ecotype:missing\|age:48hpf\|dev stage:48hpf\|collection date:2023 11 30\|geo loc name:missing\|sex:missing\|tissue:missing\|tmp:11\|BioSampleModel:Model organism or animal	zebrafish	11	11	Effects of TDCPP exposure on transcription in zebrafish	RNA-Seq	TRANSCRIPTOMIC	other	PAIRED	ILLUMINA	Illumina MiSeq	SRP537088			L1EFA241017_E3.R1.raw.fastq.gz L1EFA241017_E3.R2.raw.fastq.gz	fastq fastq	7824546992.0	25909096.0	L1EFA241017 E3.R1.raw.fastq.gz	0:151 1:151	A:2082463940;C:1810596613;G:1891675714;T:2039730477;N:80248	151	151	2082463940	1810596613	1891675714	2039730477	80248	SRX26311172	SRS22839342	SRA1987398	Beijing Normal University\|College of Water Sciences	Beijing Normal University												B	B	biological fallback assumption	illumina	miseq	unknown	other	unknown	bulk	unknown	unknown	China	2024-10-08	Hatching	Embryo	Undetermined	Embryo Imprecise
33891	33891	SRR30907859	SRX26311171	SRS22839341	SRP537088	PRJNA1167252	Eukaryotic transcriptome sequencing of zebrafish	PRJNA1167252	Other	To study the effects of TDCPP reports on protein expression and RNA transcription in zebrafish		zebrafish	A1 R1		strain:zebrafish\|isolate:missing\|breed:AB\|cultivar:missing\|ecotype:missing\|age:48hpf\|dev stage:48hpf\|collection date:2023 11 30\|geo loc name:missing\|sex:missing\|tissue:missing\|tmp:1\|BioSampleModel:Model organism or animal	zebrafish	1	1	Effects of TDCPP exposure on transcription in zebrafish	RNA-Seq	TRANSCRIPTOMIC	other	PAIRED	ILLUMINA	Illumina MiSeq	SRP537088			L1EFA241012_A1.R1.raw.fastq.gz L1EFA241012_A1.R2.raw.fastq.gz	fastq fastq	8017250474.0	26547187.0	L1EFA241012 A1.R1.raw.fastq.gz	0:151 1:151	A:2139416119;C:1853218216;G:1930287523;T:2094246996;N:81620	151	151	2139416119	1853218216	1930287523	2094246996	81620	SRX26311171	SRS22839341	SRA1987398	Beijing Normal University\|College of Water Sciences	Beijing Normal University												B	B	biological fallback assumption	illumina	miseq	unknown	other	unknown	bulk	unknown	unknown	China	2024-10-08	Hatching	Embryo	Undetermined	Embryo Imprecise
50535	50535	SRR8134458	SRX4955494	SRS3996631	SRP167225	PRJNA501843	Characterization of Transcriptomic Profile in Early Zebrafish PGCs by Single Cell Sequencing	PRJNA501843	Other	Single cell RNA seq was applied for studying the transcriptomic profile in early zebrafish PGCsprimordial germ cells by choosing three time points during zebrafish embryonic development. The three time points were 6hpfhpf also called shield stage 11hpfalso called 3 somite stage and 24hpfalso called prim 5 stage.			H24 3		strain:AB\|isolate:missing\|breed:missing\|cultivar:missing\|ecotype:missing\|dev stage:24hpf biological replicate 3\|sex:missing\|tissue:PGC\|BioSampleModel:Model organism or animal	RNA Seq of Danio rerio: PGC	H24 3	H24 3	smart2	RNA-Seq	TRANSCRIPTOMIC	other	PAIRED	ILLUMINA	Illumina HiSeq 2500	SRP167225			H24_3_R1.fastq H24_3_R2.fastq	fastq fastq	1303220750.0	5212883.0	H24 3 R1.fastq	0:125 1:125	A:353042196;C:298548859;G:299882991;T:351742904;N:3800	125	125	353042196	298548859	299882991	351742904	3800	SRX4955494	SRS3996631	SRA800727	Shanghai Institute of Biochemistry and Cell Biology, CAS\|State Key Laboratory of cell Biology	Shanghai Institute of Biochemistry and Cell Biology, CAS	2	0.95284	0.94903	0.03485	0.03522	0.8606	0.86168	0.49556	0.49795	125	125	B	B	biological fallback assumption	illumina	hiseq_era	unknown	other	unknown	sc_generic	single_cell_generic	generic-scrnaseq-only	China	2019-02-01	Pharyngula	Embryo	Undetermined	Embryo Imprecise
50536	50536	SRR8134459	SRX4955493	SRS3996630	SRP167225	PRJNA501843	Characterization of Transcriptomic Profile in Early Zebrafish PGCs by Single Cell Sequencing	PRJNA501843	Other	Single cell RNA seq was applied for studying the transcriptomic profile in early zebrafish PGCsprimordial germ cells by choosing three time points during zebrafish embryonic development. The three time points were 6hpfhpf also called shield stage 11hpfalso called 3 somite stage and 24hpfalso called prim 5 stage.			H24 1		strain:AB\|isolate:missing\|breed:missing\|cultivar:missing\|ecotype:missing\|dev stage:24hpf biological replicate 1\|sex:missing\|tissue:PGC\|BioSampleModel:Model organism or animal	RNA Seq of Danio rerio: PGC	H24 1	H24 1	smart2	RNA-Seq	TRANSCRIPTOMIC	other	PAIRED	ILLUMINA	Illumina HiSeq 2500	SRP167225			H24_1_R1.fastq H24_1_R2.fastq	fastq fastq	1040367750.0	4161471.0	H24 1 R1.fastq	0:125 1:125	A:285190807;C:235796611;G:237165817;T:282211556;N:2959	125	125	285190807	235796611	237165817	282211556	2959	SRX4955493	SRS3996630	SRA800727	Shanghai Institute of Biochemistry and Cell Biology, CAS\|State Key Laboratory of cell Biology	Shanghai Institute of Biochemistry and Cell Biology, CAS	2	0.94648	0.94488	0.0507	0.05253	0.87353	0.87513	0.52936	0.52764	125	125	B	B	biological fallback assumption	illumina	hiseq_era	unknown	other	unknown	sc_generic	single_cell_generic	generic-scrnaseq-only	China	2019-02-01	Pharyngula	Embryo	Undetermined	Embryo Imprecise
50537	50537	SRR8134460	SRX4955492	SRS3996629	SRP167225	PRJNA501843	Characterization of Transcriptomic Profile in Early Zebrafish PGCs by Single Cell Sequencing	PRJNA501843	Other	Single cell RNA seq was applied for studying the transcriptomic profile in early zebrafish PGCsprimordial germ cells by choosing three time points during zebrafish embryonic development. The three time points were 6hpfhpf also called shield stage 11hpfalso called 3 somite stage and 24hpfalso called prim 5 stage.			H24 2		strain:AB\|isolate:missing\|breed:missing\|cultivar:missing\|ecotype:missing\|dev stage:24hpf biological replicate 2\|sex:missing\|tissue:PGC\|BioSampleModel:Model organism or animal	RNA Seq of Danio rerio: PGC	H24 2	H24 2	smart2	RNA-Seq	TRANSCRIPTOMIC	other	PAIRED	ILLUMINA	Illumina HiSeq 2500	SRP167225			H24_2_R1.fastq H24_2_R2.fastq	fastq fastq	1003243000.0	4012972.0	H24 2 R1.fastq	0:125 1:125	A:275192369;C:227024454;G:228346661;T:272676506;N:3010	125	125	275192369	227024454	228346661	272676506	3010	SRX4955492	SRS3996629	SRA800727	Shanghai Institute of Biochemistry and Cell Biology, CAS\|State Key Laboratory of cell Biology	Shanghai Institute of Biochemistry and Cell Biology, CAS	2	0.94467	0.94348	0.06361	0.06541	0.8423	0.84478	0.51257	0.51745	125	125	B	B	biological fallback assumption	illumina	hiseq_era	unknown	other	unknown	sc_generic	single_cell_generic	generic-scrnaseq-only	China	2019-02-01	Pharyngula	Embryo	Undetermined	Embryo Imprecise
50538	50538	SRR8134461	SRX4955491	SRS3996628	SRP167225	PRJNA501843	Characterization of Transcriptomic Profile in Early Zebrafish PGCs by Single Cell Sequencing	PRJNA501843	Other	Single cell RNA seq was applied for studying the transcriptomic profile in early zebrafish PGCsprimordial germ cells by choosing three time points during zebrafish embryonic development. The three time points were 6hpfhpf also called shield stage 11hpfalso called 3 somite stage and 24hpfalso called prim 5 stage.			H11 2		strain:AB\|isolate:missing\|breed:missing\|cultivar:missing\|ecotype:missing\|dev stage:11hpf biological replicate 2\|sex:missing\|tissue:PGC\|BioSampleModel:Model organism or animal	RNA Seq of Danio rerio: PGC	H11 2	H11 2	smart2	RNA-Seq	TRANSCRIPTOMIC	other	PAIRED	ILLUMINA	Illumina HiSeq 2500	SRP167225			H11_2_R1.fastq H11_2_R2.fastq	fastq fastq	1034277500.0	4137110.0	H11 2 R1.fastq	0:125 1:125	A:286346530;C:232910512;G:234755237;T:280262966;N:2255	125	125	286346530	232910512	234755237	280262966	2255	SRX4955491	SRS3996628	SRA800727	Shanghai Institute of Biochemistry and Cell Biology, CAS\|State Key Laboratory of cell Biology	Shanghai Institute of Biochemistry and Cell Biology, CAS	2	0.94693	0.94598	0.03067	0.03082	0.8562	0.85774	0.51961	0.51451	125	125	B	B	biological fallback assumption	illumina	hiseq_era	unknown	other	unknown	sc_generic	single_cell_generic	generic-scrnaseq-only	China	2019-02-01	Segmentation	Embryo	Undetermined	Embryo Imprecise
50539	50539	SRR8134462	SRX4955490	SRS3996627	SRP167225	PRJNA501843	Characterization of Transcriptomic Profile in Early Zebrafish PGCs by Single Cell Sequencing	PRJNA501843	Other	Single cell RNA seq was applied for studying the transcriptomic profile in early zebrafish PGCsprimordial germ cells by choosing three time points during zebrafish embryonic development. The three time points were 6hpfhpf also called shield stage 11hpfalso called 3 somite stage and 24hpfalso called prim 5 stage.			H11 3		strain:AB\|isolate:missing\|breed:missing\|cultivar:missing\|ecotype:missing\|dev stage:11hpf biological replicate 3\|sex:missing\|tissue:PGC\|BioSampleModel:Model organism or animal	RNA Seq of Danio rerio: PGC	H11 3	H11 3	smart2	RNA-Seq	TRANSCRIPTOMIC	other	PAIRED	ILLUMINA	Illumina HiSeq 2500	SRP167225			H11_3_R1.fastq H11_3_R2.fastq	fastq fastq	1084328250.0	4337313.0	H11 3 R1.fastq	0:125 1:125	A:296459005;C:246835042;G:248291057;T:292740098;N:3048	125	125	296459005	246835042	248291057	292740098	3048	SRX4955490	SRS3996627	SRA800727	Shanghai Institute of Biochemistry and Cell Biology, CAS\|State Key Laboratory of cell Biology	Shanghai Institute of Biochemistry and Cell Biology, CAS	2	0.95199	0.95021	0.02101	0.02158	0.85914	0.86058	0.51593	0.41299	125	125	B	B	biological fallback assumption	illumina	hiseq_era	unknown	other	unknown	sc_generic	single_cell_generic	generic-scrnaseq-only	China	2019-02-01	Segmentation	Embryo	Undetermined	Embryo Imprecise
50540	50540	SRR8134463	SRX4955489	SRS3996626	SRP167225	PRJNA501843	Characterization of Transcriptomic Profile in Early Zebrafish PGCs by Single Cell Sequencing	PRJNA501843	Other	Single cell RNA seq was applied for studying the transcriptomic profile in early zebrafish PGCsprimordial germ cells by choosing three time points during zebrafish embryonic development. The three time points were 6hpfhpf also called shield stage 11hpfalso called 3 somite stage and 24hpfalso called prim 5 stage.			H6 3		strain:AB\|isolate:missing\|breed:missing\|cultivar:missing\|ecotype:missing\|dev stage:6hpf biological replicate 3\|sex:missing\|tissue:PGC\|BioSampleModel:Model organism or animal	RNA Seq of Danio rerio: PGC	H6 3	H6 3	smart2	RNA-Seq	TRANSCRIPTOMIC	other	PAIRED	ILLUMINA	Illumina HiSeq 2500	SRP167225			H6_3_R1.fastq H6_3_R2.fastq	fastq fastq	989016500.0	3956066.0	H6 3 R1.fastq	0:125 1:125	A:270941686;C:224568911;G:226264637;T:267238750;N:2516	125	125	270941686	224568911	226264637	267238750	2516	SRX4955489	SRS3996626	SRA800727	Shanghai Institute of Biochemistry and Cell Biology, CAS\|State Key Laboratory of cell Biology	Shanghai Institute of Biochemistry and Cell Biology, CAS	2	0.94889	0.94713	0.02757	0.02789	0.84415	0.84571	0.52218	0.52291	125	125	B	B	biological fallback assumption	illumina	hiseq_era	unknown	other	unknown	sc_generic	single_cell_generic	generic-scrnaseq-only	China	2019-02-01	Gastrula	Embryo	Undetermined	Embryo Imprecise
50541	50541	SRR8134464	SRX4955488	SRS3996623	SRP167225	PRJNA501843	Characterization of Transcriptomic Profile in Early Zebrafish PGCs by Single Cell Sequencing	PRJNA501843	Other	Single cell RNA seq was applied for studying the transcriptomic profile in early zebrafish PGCsprimordial germ cells by choosing three time points during zebrafish embryonic development. The three time points were 6hpfhpf also called shield stage 11hpfalso called 3 somite stage and 24hpfalso called prim 5 stage.			H11 1		strain:AB\|isolate:missing\|breed:missing\|cultivar:missing\|ecotype:missing\|dev stage:11hpf biological replicate 1\|sex:missing\|tissue:PGC\|BioSampleModel:Model organism or animal	RNA Seq of Danio rerio: PGC	H11 1	H11 1	smart2	RNA-Seq	TRANSCRIPTOMIC	other	PAIRED	ILLUMINA	Illumina HiSeq 2500	SRP167225			H11_1_R1.fastq H11_1_R2.fastq	fastq fastq	707998500.0	2831994.0	H11 1 R1.fastq	0:125 1:125	A:194434087;C:160870744;G:162119289;T:190572787;N:1593	125	125	194434087	160870744	162119289	190572787	1593	SRX4955488	SRS3996623	SRA800727	Shanghai Institute of Biochemistry and Cell Biology, CAS\|State Key Laboratory of cell Biology	Shanghai Institute of Biochemistry and Cell Biology, CAS	2	0.94561	0.94128	0.03328	0.03394	0.8589	0.86062	0.48582	0.48548	125	125	B	B	biological fallback assumption	illumina	hiseq_era	unknown	other	unknown	sc_generic	single_cell_generic	generic-scrnaseq-only	China	2019-02-01	Segmentation	Embryo	Undetermined	Embryo Imprecise
50542	50542	SRR8134465	SRX4955487	SRS3996624	SRP167225	PRJNA501843	Characterization of Transcriptomic Profile in Early Zebrafish PGCs by Single Cell Sequencing	PRJNA501843	Other	Single cell RNA seq was applied for studying the transcriptomic profile in early zebrafish PGCsprimordial germ cells by choosing three time points during zebrafish embryonic development. The three time points were 6hpfhpf also called shield stage 11hpfalso called 3 somite stage and 24hpfalso called prim 5 stage.			H6 1		strain:AB\|isolate:missing\|breed:missing\|cultivar:missing\|ecotype:missing\|dev stage:6hpf biological replicate 1\|sex:missing\|tissue:PGC\|BioSampleModel:Model organism or animal	RNA Seq of Danio rerio: PGC	H6 1	H6 1	smart2	RNA-Seq	TRANSCRIPTOMIC	other	PAIRED	ILLUMINA	Illumina HiSeq 2500	SRP167225			H6_1_R1.fastq H6_1_R2.fastq	fastq fastq	759809500.0	3039238.0	H6 1 R1.fastq	0:125 1:125	A:211499426;C:170044275;G:171920878;T:206342561;N:2360	125	125	211499426	170044275	171920878	206342561	2360	SRX4955487	SRS3996624	SRA800727	Shanghai Institute of Biochemistry and Cell Biology, CAS\|State Key Laboratory of cell Biology	Shanghai Institute of Biochemistry and Cell Biology, CAS	2	0.94965	0.94791	0.04309	0.04276	0.83485	0.83676	0.5519	0.56156	125	125	B	B	biological fallback assumption	illumina	hiseq_era	unknown	other	unknown	sc_generic	single_cell_generic	generic-scrnaseq-only	China	2019-02-01	Gastrula	Embryo	Undetermined	Embryo Imprecise
50543	50543	SRR8134466	SRX4955486	SRS3996625	SRP167225	PRJNA501843	Characterization of Transcriptomic Profile in Early Zebrafish PGCs by Single Cell Sequencing	PRJNA501843	Other	Single cell RNA seq was applied for studying the transcriptomic profile in early zebrafish PGCsprimordial germ cells by choosing three time points during zebrafish embryonic development. The three time points were 6hpfhpf also called shield stage 11hpfalso called 3 somite stage and 24hpfalso called prim 5 stage.			H6 2		strain:AB\|isolate:missing\|breed:missing\|cultivar:missing\|ecotype:missing\|dev stage:6hpf biological replicate 2\|sex:missing\|tissue:PGC\|BioSampleModel:Model organism or animal	RNA Seq of Danio rerio: PGC	H6 2	H6 2	smart2	RNA-Seq	TRANSCRIPTOMIC	other	PAIRED	ILLUMINA	Illumina HiSeq 2500	SRP167225			H6_2_R1.fastq H6_2_R2.fastq	fastq fastq	858125000.0	3432500.0	H6 2 R1.fastq	0:125 1:125	A:236752508;C:193146437;G:194455657;T:233768197;N:2201	125	125	236752508	193146437	194455657	233768197	2201	SRX4955486	SRS3996625	SRA800727	Shanghai Institute of Biochemistry and Cell Biology, CAS\|State Key Laboratory of cell Biology	Shanghai Institute of Biochemistry and Cell Biology, CAS	2	0.94359	0.93966	0.04047	0.03943	0.83924	0.84396	0.54153	0.54602	125	125	B	B	biological fallback assumption	illumina	hiseq_era	unknown	other	unknown	sc_generic	single_cell_generic	generic-scrnaseq-only	China	2019-02-01	Gastrula	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");;