metadata: run_metadata: 4 rows where experiment.library_strategy = "RIP-Seq", technology = "bulk" and tissue_curation

4 rows where experiment.library_strategy = "RIP-Seq", technology = "bulk" and tissue_curation_coarse = "All anatomical structures"

descending

Link	rowid ▼	run.accession	experiment.accession	sample.accession	study.accession	bioproject	study.title	study.alias	study.type	study.abstract	sample.title	sample.alias	sample.attributes	GEOsample.title	GEOsample.dataprocessing	GEOsample.source	GEOsample.extractprotocol	GEOsample.growthprotocol	GEOsample.characteristics	GEOsample.accession	experiment.title	experiment.alias	experiment.library_name	experiment.design_description	experiment.library_construction_protocol	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.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
32033	32033	SRR28976522	SRX24505963	SRS21254128	SRP506702	PRJNA1109723	rbm24a is an organizer component of germ plasm to determine germ cell fate	GSE267086	Other	The formation of germ cells is a critical issue for the continuation of species. A large group of animals follow a preformation strategy to generate their primordial germ cells PGCs. They produce a set of localized maternal mRNAs and proteins to form phase separated germ plasm that functions as the PGC determinants but the mechanisms underlying the assembly of germ plasm is poorly understood. This study identifies Rbm24a as an enssential localized germ plasm protein component that controls the formation of large and functional germ plasm granules. Rbm24a is complexed with Buc and interacts with germ plasm mRNAs which determines the specific grasp of germ plasm mRNAs into the phase separated aggregates. Rbm24a absent granules fail to undergo kinesin dependent transport towards the cleavage furrows where small particles fuse into large ones. The loss of maternal rbm24a causes the complete degradation of germ plasm components and the disappearance of PGCs resulting in totally sterile animals. Our work establishes that Rbm24 is a critical nucleating organizer component of germ plasm highlighting an emerging common mechanism to read and recruit RNA component into phase separated condensates. Overall design: To elucidate the comprehensive RNA binding landscape of Rbm24a in zebrafish we employed RIP seq analysis on both rbm24a GFP knock in and wild type zebrafish.	Zebrafish RIP seq Rbm24a Knock in IP	GSM8259538	source name:whole embryo\|tissue:whole embryo\|developmental stage:4 cell stage\|cell type:embryonic cell\|genotype:Rbm24a Knock in\|antibody:GFP\|geo loc name:missing\|collection date:missing	Zebrafish RIP seq Rbm24a Knock in IP	Each library was amplified by a 15 cycle PCR and 150 bp paired end sequencing was subjected to Illumina Nova seq 6000 to obtain the raw data. Assembly: GRCz11 Supplementary files format and content: tab delimited text file includes raw counts for each Sample Supplementary files format and content: Bigwig file for each Sample	whole embryo	Total RNAs were extracted from WT and Mrbm24a embryos at 4 cell sphere 24 hpf stage using TRIzol reagent Invitrogen and were precipitated by cold isopropanol 50% v/v in the presence of carrier glycogen 20 µg/each sample. 1 μg total RNA was used for following library preparation. The polyA mRNA isolation was performed using OligodT beads. The mRNA and RIP IP RNA fragmentation was performed using divalent cations and high temperature. Priming was performed using Random Primers. First strand cDNA and the second strand cDNA were synthesized. The purified double stranded cDNA was then treated to repair both ends and add a dA tailing in one reaction followed by a T A ligation to add adaptors to both ends. Size selection of Adaptor ligated DNA was then performed using DNA Clean Beads. Each sample was then amplified by PCR using P5 and P7 primers and the PCR products were validated. Then libraries with different indexs were multiplexed and loaded on an Illumina Nova seq 6000 instrument for sequencing using a 2x150 paired end PE configuration according to manufacturer’s instructions.	Zebrafish embryos were maintained in 1/3x Ringer's at 28.5C	tissue:whole embryo\|developmental stage:4 cell stage\|cell type:embryonic cell\|genotype:Rbm24a Knock in\|antibody:GFP	GSM8259538	GSM8259538: Zebrafish RIP seq Rbm24a Knock in IP; Danio rerio; RIP Seq	GSM8259538 r1	GSM8259538	1	Total RNAs were extracted from WT and Mrbm24a embryos at 4 cell sphere 24 hpf stage using TRIzol reagent Invitrogen and were precipitated by cold isopropanol 50% v/v in the presence of carrier glycogen 20 µg/each sample. 1 μg total RNA was used for following library preparation. The polyA mRNA isolation was performed using OligodT beads. The mRNA and RIP IP RNA fragmentation was performed using divalent cations and high temperature. Priming was performed using Random Primers. First strand cDNA and the second strand cDNA were synthesized. The purified double stranded cDNA was then treated to repair both ends and add a dA tailing in one reaction followed by a T A ligation to add adaptors to both ends. Size selection of Adaptor ligated DNA was then performed using DNA Clean Beads. Each sample was then amplified by PCR using P5 and P7 primers and the PCR products were validated. Then libraries with different indexs were multiplexed and loaded on an Illumina Nova seq 6000 instrument for sequencing using a 2x150 paired end PE configuration according to manufacturer's instructions.	RIP-Seq	TRANSCRIPTOMIC	other	PAIRED	ILLUMINA	Illumina NovaSeq 6000	SRP506702	RIP_KI_IP_R2.fq.gz RIP_KI_IP_R1.fq.gz	fastq fastq	6457893104.0	21383752.0	GSM8259538 r1	0:151 1:151	A:975588225;C:2019180290;G:2469634919;T:992947702;N:541968	151	151	975588225	2019180290	2469634919	992947702	541968	SRX24505963	SRS21254128	SRA1863578	Ang Li, College of Life Sciences, shandong university	Ang Li, College of Life Sciences, shandong university	2	0.90304	0.86018	0.20083	0.20471	0.96382	0.96743	0.96102	0.98876	151	151	B	B	biological fallback assumption	illumina	novaseq_era	unknown	poly_a	unknown	bulk	bulk	bulk	China	2024-05-09	Cleavage	Embryo	Whole Organism	All anatomical structures
32034	32034	SRR28976523	SRX24505962	SRS21254127	SRP506702	PRJNA1109723	rbm24a is an organizer component of germ plasm to determine germ cell fate	GSE267086	Other	The formation of germ cells is a critical issue for the continuation of species. A large group of animals follow a preformation strategy to generate their primordial germ cells PGCs. They produce a set of localized maternal mRNAs and proteins to form phase separated germ plasm that functions as the PGC determinants but the mechanisms underlying the assembly of germ plasm is poorly understood. This study identifies Rbm24a as an enssential localized germ plasm protein component that controls the formation of large and functional germ plasm granules. Rbm24a is complexed with Buc and interacts with germ plasm mRNAs which determines the specific grasp of germ plasm mRNAs into the phase separated aggregates. Rbm24a absent granules fail to undergo kinesin dependent transport towards the cleavage furrows where small particles fuse into large ones. The loss of maternal rbm24a causes the complete degradation of germ plasm components and the disappearance of PGCs resulting in totally sterile animals. Our work establishes that Rbm24 is a critical nucleating organizer component of germ plasm highlighting an emerging common mechanism to read and recruit RNA component into phase separated condensates. Overall design: To elucidate the comprehensive RNA binding landscape of Rbm24a in zebrafish we employed RIP seq analysis on both rbm24a GFP knock in and wild type zebrafish.	Zebrafish RIP seq wild type IP	GSM8259537	source name:whole embryo\|tissue:whole embryo\|developmental stage:4 cell stage\|cell type:embryonic cell\|genotype:wild type\|antibody:GFP\|geo loc name:missing\|collection date:missing	Zebrafish RIP seq wild type IP	Each library was amplified by a 15 cycle PCR and 150 bp paired end sequencing was subjected to Illumina Nova seq 6000 to obtain the raw data. Assembly: GRCz11 Supplementary files format and content: tab delimited text file includes raw counts for each Sample Supplementary files format and content: Bigwig file for each Sample	whole embryo	Total RNAs were extracted from WT and Mrbm24a embryos at 4 cell sphere 24 hpf stage using TRIzol reagent Invitrogen and were precipitated by cold isopropanol 50% v/v in the presence of carrier glycogen 20 µg/each sample. 1 μg total RNA was used for following library preparation. The polyA mRNA isolation was performed using OligodT beads. The mRNA and RIP IP RNA fragmentation was performed using divalent cations and high temperature. Priming was performed using Random Primers. First strand cDNA and the second strand cDNA were synthesized. The purified double stranded cDNA was then treated to repair both ends and add a dA tailing in one reaction followed by a T A ligation to add adaptors to both ends. Size selection of Adaptor ligated DNA was then performed using DNA Clean Beads. Each sample was then amplified by PCR using P5 and P7 primers and the PCR products were validated. Then libraries with different indexs were multiplexed and loaded on an Illumina Nova seq 6000 instrument for sequencing using a 2x150 paired end PE configuration according to manufacturer’s instructions.	Zebrafish embryos were maintained in 1/3x Ringer's at 28.5C	tissue:whole embryo\|developmental stage:4 cell stage\|cell type:embryonic cell\|genotype:wild type\|antibody:GFP	GSM8259537	GSM8259537: Zebrafish RIP seq wild type IP; Danio rerio; RIP Seq	GSM8259537 r1	GSM8259537	1	Total RNAs were extracted from WT and Mrbm24a embryos at 4 cell sphere 24 hpf stage using TRIzol reagent Invitrogen and were precipitated by cold isopropanol 50% v/v in the presence of carrier glycogen 20 µg/each sample. 1 μg total RNA was used for following library preparation. The polyA mRNA isolation was performed using OligodT beads. The mRNA and RIP IP RNA fragmentation was performed using divalent cations and high temperature. Priming was performed using Random Primers. First strand cDNA and the second strand cDNA were synthesized. The purified double stranded cDNA was then treated to repair both ends and add a dA tailing in one reaction followed by a T A ligation to add adaptors to both ends. Size selection of Adaptor ligated DNA was then performed using DNA Clean Beads. Each sample was then amplified by PCR using P5 and P7 primers and the PCR products were validated. Then libraries with different indexs were multiplexed and loaded on an Illumina Nova seq 6000 instrument for sequencing using a 2x150 paired end PE configuration according to manufacturer's instructions.	RIP-Seq	TRANSCRIPTOMIC	other	PAIRED	ILLUMINA	Illumina NovaSeq 6000	SRP506702	RIP_WT_IP_R2.fq.gz RIP_WT_IP_R1.fq.gz	fastq fastq	4501412680.0	14905340.0	GSM8259537 r1	0:151 1:151	A:651609366;C:1285679784;G:1901211768;T:662533141;N:378621	151	151	651609366	1285679784	1901211768	662533141	378621	SRX24505962	SRS21254127	SRA1863578	Ang Li, College of Life Sciences, shandong university	Ang Li, College of Life Sciences, shandong university	2	0.96426	0.81361	0.26579	0.2253	0.97784	0.97806	0.8699	0.93379	151	151	B	B	biological fallback assumption	illumina	novaseq_era	unknown	poly_a	unknown	bulk	bulk	bulk	China	2024-05-09	Cleavage	Embryo	Whole Organism	All anatomical structures
32035	32035	SRR28976524	SRX24505961	SRS21254126	SRP506702	PRJNA1109723	rbm24a is an organizer component of germ plasm to determine germ cell fate	GSE267086	Other	The formation of germ cells is a critical issue for the continuation of species. A large group of animals follow a preformation strategy to generate their primordial germ cells PGCs. They produce a set of localized maternal mRNAs and proteins to form phase separated germ plasm that functions as the PGC determinants but the mechanisms underlying the assembly of germ plasm is poorly understood. This study identifies Rbm24a as an enssential localized germ plasm protein component that controls the formation of large and functional germ plasm granules. Rbm24a is complexed with Buc and interacts with germ plasm mRNAs which determines the specific grasp of germ plasm mRNAs into the phase separated aggregates. Rbm24a absent granules fail to undergo kinesin dependent transport towards the cleavage furrows where small particles fuse into large ones. The loss of maternal rbm24a causes the complete degradation of germ plasm components and the disappearance of PGCs resulting in totally sterile animals. Our work establishes that Rbm24 is a critical nucleating organizer component of germ plasm highlighting an emerging common mechanism to read and recruit RNA component into phase separated condensates. Overall design: To elucidate the comprehensive RNA binding landscape of Rbm24a in zebrafish we employed RIP seq analysis on both rbm24a GFP knock in and wild type zebrafish.	Zebrafish RIP seq Rbm24a Knock in input	GSM8259536	source name:whole embryo\|tissue:whole embryo\|developmental stage:4 cell stage\|cell type:embryonic cell\|genotype:Rbm24a Knock in\|antibody:input\|geo loc name:missing\|collection date:missing	Zebrafish RIP seq Rbm24a Knock in input	Each library was amplified by a 15 cycle PCR and 150 bp paired end sequencing was subjected to Illumina Nova seq 6000 to obtain the raw data. Assembly: GRCz11 Supplementary files format and content: tab delimited text file includes raw counts for each Sample Supplementary files format and content: Bigwig file for each Sample	whole embryo	Total RNAs were extracted from WT and Mrbm24a embryos at 4 cell sphere 24 hpf stage using TRIzol reagent Invitrogen and were precipitated by cold isopropanol 50% v/v in the presence of carrier glycogen 20 µg/each sample. 1 μg total RNA was used for following library preparation. The polyA mRNA isolation was performed using OligodT beads. The mRNA and RIP IP RNA fragmentation was performed using divalent cations and high temperature. Priming was performed using Random Primers. First strand cDNA and the second strand cDNA were synthesized. The purified double stranded cDNA was then treated to repair both ends and add a dA tailing in one reaction followed by a T A ligation to add adaptors to both ends. Size selection of Adaptor ligated DNA was then performed using DNA Clean Beads. Each sample was then amplified by PCR using P5 and P7 primers and the PCR products were validated. Then libraries with different indexs were multiplexed and loaded on an Illumina Nova seq 6000 instrument for sequencing using a 2x150 paired end PE configuration according to manufacturer’s instructions.	Zebrafish embryos were maintained in 1/3x Ringer's at 28.5C	tissue:whole embryo\|developmental stage:4 cell stage\|cell type:embryonic cell\|genotype:Rbm24a Knock in\|antibody:input	GSM8259536	GSM8259536: Zebrafish RIP seq Rbm24a Knock in input; Danio rerio; RIP Seq	GSM8259536 r1	GSM8259536	1	Total RNAs were extracted from WT and Mrbm24a embryos at 4 cell sphere 24 hpf stage using TRIzol reagent Invitrogen and were precipitated by cold isopropanol 50% v/v in the presence of carrier glycogen 20 µg/each sample. 1 μg total RNA was used for following library preparation. The polyA mRNA isolation was performed using OligodT beads. The mRNA and RIP IP RNA fragmentation was performed using divalent cations and high temperature. Priming was performed using Random Primers. First strand cDNA and the second strand cDNA were synthesized. The purified double stranded cDNA was then treated to repair both ends and add a dA tailing in one reaction followed by a T A ligation to add adaptors to both ends. Size selection of Adaptor ligated DNA was then performed using DNA Clean Beads. Each sample was then amplified by PCR using P5 and P7 primers and the PCR products were validated. Then libraries with different indexs were multiplexed and loaded on an Illumina Nova seq 6000 instrument for sequencing using a 2x150 paired end PE configuration according to manufacturer's instructions.	RIP-Seq	TRANSCRIPTOMIC	other	PAIRED	ILLUMINA	Illumina NovaSeq 6000	SRP506702	RIP_KI_Input_R2.fq.gz RIP_KI_Input_R1.fq.gz	fastq fastq	9539398726.0	31587413.0	GSM8259536 r1	0:151 1:151	A:2233069830;C:2078359171;G:3009942870;T:2217201959;N:824896	151	151	2233069830	2078359171	3009942870	2217201959	824896	SRX24505961	SRS21254126	SRA1863578	Ang Li, College of Life Sciences, shandong university	Ang Li, College of Life Sciences, shandong university	2	0.90112	0.81448	0.02415	0.01993	0.79287	0.79807	0.47884	0.48186	151	151	B	B	biological fallback assumption	illumina	novaseq_era	unknown	poly_a	unknown	bulk	bulk	bulk	China	2024-05-09	Cleavage	Embryo	Whole Organism	All anatomical structures
32036	32036	SRR28976525	SRX24505960	SRS21254125	SRP506702	PRJNA1109723	rbm24a is an organizer component of germ plasm to determine germ cell fate	GSE267086	Other	The formation of germ cells is a critical issue for the continuation of species. A large group of animals follow a preformation strategy to generate their primordial germ cells PGCs. They produce a set of localized maternal mRNAs and proteins to form phase separated germ plasm that functions as the PGC determinants but the mechanisms underlying the assembly of germ plasm is poorly understood. This study identifies Rbm24a as an enssential localized germ plasm protein component that controls the formation of large and functional germ plasm granules. Rbm24a is complexed with Buc and interacts with germ plasm mRNAs which determines the specific grasp of germ plasm mRNAs into the phase separated aggregates. Rbm24a absent granules fail to undergo kinesin dependent transport towards the cleavage furrows where small particles fuse into large ones. The loss of maternal rbm24a causes the complete degradation of germ plasm components and the disappearance of PGCs resulting in totally sterile animals. Our work establishes that Rbm24 is a critical nucleating organizer component of germ plasm highlighting an emerging common mechanism to read and recruit RNA component into phase separated condensates. Overall design: To elucidate the comprehensive RNA binding landscape of Rbm24a in zebrafish we employed RIP seq analysis on both rbm24a GFP knock in and wild type zebrafish.	Zebrafish RIP seq wild type input	GSM8259535	source name:whole embryo\|tissue:whole embryo\|developmental stage:4 cell stage\|cell type:embryonic cell\|genotype:wild type\|antibody:input\|geo loc name:missing\|collection date:missing	Zebrafish RIP seq wild type input	Each library was amplified by a 15 cycle PCR and 150 bp paired end sequencing was subjected to Illumina Nova seq 6000 to obtain the raw data. Assembly: GRCz11 Supplementary files format and content: tab delimited text file includes raw counts for each Sample Supplementary files format and content: Bigwig file for each Sample	whole embryo	Total RNAs were extracted from WT and Mrbm24a embryos at 4 cell sphere 24 hpf stage using TRIzol reagent Invitrogen and were precipitated by cold isopropanol 50% v/v in the presence of carrier glycogen 20 µg/each sample. 1 μg total RNA was used for following library preparation. The polyA mRNA isolation was performed using OligodT beads. The mRNA and RIP IP RNA fragmentation was performed using divalent cations and high temperature. Priming was performed using Random Primers. First strand cDNA and the second strand cDNA were synthesized. The purified double stranded cDNA was then treated to repair both ends and add a dA tailing in one reaction followed by a T A ligation to add adaptors to both ends. Size selection of Adaptor ligated DNA was then performed using DNA Clean Beads. Each sample was then amplified by PCR using P5 and P7 primers and the PCR products were validated. Then libraries with different indexs were multiplexed and loaded on an Illumina Nova seq 6000 instrument for sequencing using a 2x150 paired end PE configuration according to manufacturer’s instructions.	Zebrafish embryos were maintained in 1/3x Ringer's at 28.5C	tissue:whole embryo\|developmental stage:4 cell stage\|cell type:embryonic cell\|genotype:wild type\|antibody:input	GSM8259535	GSM8259535: Zebrafish RIP seq wild type input; Danio rerio; RIP Seq	GSM8259535 r1	GSM8259535	1	Total RNAs were extracted from WT and Mrbm24a embryos at 4 cell sphere 24 hpf stage using TRIzol reagent Invitrogen and were precipitated by cold isopropanol 50% v/v in the presence of carrier glycogen 20 µg/each sample. 1 μg total RNA was used for following library preparation. The polyA mRNA isolation was performed using OligodT beads. The mRNA and RIP IP RNA fragmentation was performed using divalent cations and high temperature. Priming was performed using Random Primers. First strand cDNA and the second strand cDNA were synthesized. The purified double stranded cDNA was then treated to repair both ends and add a dA tailing in one reaction followed by a T A ligation to add adaptors to both ends. Size selection of Adaptor ligated DNA was then performed using DNA Clean Beads. Each sample was then amplified by PCR using P5 and P7 primers and the PCR products were validated. Then libraries with different indexs were multiplexed and loaded on an Illumina Nova seq 6000 instrument for sequencing using a 2x150 paired end PE configuration according to manufacturer's instructions.	RIP-Seq	TRANSCRIPTOMIC	other	PAIRED	ILLUMINA	Illumina NovaSeq 6000	SRP506702	RIP_WT_Input_R2.fq.gz RIP_WT_Input_R1.fq.gz	fastq fastq	14180410302.0	46955001.0	GSM8259535 r1	0:151 1:151	A:3380011534;C:2883841476;G:4593876270;T:3321465622;N:1215400	151	151	3380011534	2883841476	4593876270	3321465622	1215400	SRX24505960	SRS21254125	SRA1863578	Ang Li, College of Life Sciences, shandong university	Ang Li, College of Life Sciences, shandong university	2	0.86497	0.64685	0.04432	0.02854	0.79324	0.8031	0.52927	0.53304	151	151	B	B	mate2-mate1 similar by mapping diff	illumina	novaseq_era	unknown	poly_a	unknown	bulk	bulk	bulk	China	2024-05-09	Cleavage	Embryo	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");;