metadata: run_metadata: 9 rows where experiment.library_selection = "other", experiment.library_strategy = "miRNA-Seq" and tissue_curation

9 rows where experiment.library_selection = "other", experiment.library_strategy = "miRNA-Seq" 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.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.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
39671	39671	SRR2043046	SRX1041307	SRS947739	SRP058729	PRJNA284830	MicroRNA expression changes during zebrafish Danio rerio development induced by hexabromocyclododecane	PRJNA284830	Whole Genome Sequencing	Hexabromocyclododecane HBCD one of the most widely used brominated flame retardants has been found to cause toxic effects on animals. Although microRNAs miRNAs play an important role in many biological and metabolic processes whether and how they are involved in the process of HBCD induced toxicity is largely unknown. In the present study zebrafish embryos were exposed to HBCD at low concentrations of 0 2 20 and 200 nM. Subsequently RNA was isolated from the embryo pool and the miRNAs expression profiles were analyzed using deep sequencing.	HBCD 200nM sample3	zebrafish at normal developmental age of 72hpf in the 200 nM HBCD rep3	HBCD 200nM 3	breed:zebrafish\|strain:Wild type TU strain\|age:72 hpf£¨hpf stage:embryo\|sex:pooled male and female\|tissue:whole zebrafish\|treatment:HBCD 200nM 3\|BioSampleModel:Model organism or animal	zebrafish at normal developmental age of 72hpf in the 200 nM HBCD rep3	Sample HBCD 200nM 3	1	1	miRNA-Seq	TRANSCRIPTOMIC	other	SINGLE	ILLUMINA	Illumina Genome Analyzer II	<SPOT_DESCRIPTOR><SPOT_DECODE_SPEC><SPOT_LENGTH>36</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>	SRP058729	Sample_HBCD_200nM-3.fastq.tar.gz	fastq	549695784.0	16657448.0	Sample HBCD 200nM 3	0:33	A:120885057;C:120386921;G:146939259;T:161323403;N:161144	33	120885057	120386921	146939259	161323403	161144	SRX1041307	SRS947739	SRA269780	MG	Xiamen University	1	0.13819	0.03714	0.94968	0.52004	33	B	usable mapping rate	illumina	early_illumina	unknown	small_rna	unknown	bulk	unknown	unknown	China	2015-09-18	Larval	Larval	Whole Organism	All anatomical structures
39672	39672	SRR2043044	SRX1041306	SRS947738	SRP058729	PRJNA284830	MicroRNA expression changes during zebrafish Danio rerio development induced by hexabromocyclododecane	PRJNA284830	Whole Genome Sequencing	Hexabromocyclododecane HBCD one of the most widely used brominated flame retardants has been found to cause toxic effects on animals. Although microRNAs miRNAs play an important role in many biological and metabolic processes whether and how they are involved in the process of HBCD induced toxicity is largely unknown. In the present study zebrafish embryos were exposed to HBCD at low concentrations of 0 2 20 and 200 nM. Subsequently RNA was isolated from the embryo pool and the miRNAs expression profiles were analyzed using deep sequencing.	HBCD 200nM sample2	zebrafish at normal developmental age of 72hpf in the 200 nM HBCD rep2	HBCD 200nM 2	breed:zebrafish\|strain:Wild type TU strain\|age:72 hpf£¨hpf stage:embryo\|sex:pooled male and female\|tissue:whole zebrafish\|treatment:HBCD 200nM 2\|BioSampleModel:Model organism or animal	zebrafish at normal developmental age of 72hpf in the 2 nM HBCD rep2	Sample HBCD 200nM 2	1	1	miRNA-Seq	TRANSCRIPTOMIC	other	SINGLE	ILLUMINA	Illumina Genome Analyzer II	<SPOT_DESCRIPTOR><SPOT_DECODE_SPEC><SPOT_LENGTH>36</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>	SRP058729	Sample_HBCD_200nM-2.fastq.tar.gz	fastq	566585217.0	17169249.0	Sample HBCD 200nM 2	0:33	A:119904892;C:129504656;G:159539041;T:157545273;N:91355	33	119904892	129504656	159539041	157545273	91355	SRX1041306	SRS947738	SRA269780	MG	Xiamen University	1	0.07072	0.01837	0.96246	0.52439	33	B	usable mapping rate	illumina	early_illumina	unknown	small_rna	unknown	bulk	unknown	unknown	China	2015-05-27	Larval	Larval	Whole Organism	All anatomical structures
39673	39673	SRR2043035	SRX1041305	SRS947737	SRP058729	PRJNA284830	MicroRNA expression changes during zebrafish Danio rerio development induced by hexabromocyclododecane	PRJNA284830	Whole Genome Sequencing	Hexabromocyclododecane HBCD one of the most widely used brominated flame retardants has been found to cause toxic effects on animals. Although microRNAs miRNAs play an important role in many biological and metabolic processes whether and how they are involved in the process of HBCD induced toxicity is largely unknown. In the present study zebrafish embryos were exposed to HBCD at low concentrations of 0 2 20 and 200 nM. Subsequently RNA was isolated from the embryo pool and the miRNAs expression profiles were analyzed using deep sequencing.	HBCD 200nM sample1	zebrafish at normal developmental age of 72hpf in the 200 nM HBCD rep1	HBCD 200nM 1	breed:zebrafish\|strain:Wild type TU strain\|age:72 hpf£¨hpf stage:embryo\|sex:pooled male and female\|tissue:whole zebrafish\|treatment:HBCD 200nM 1\|BioSampleModel:Model organism or animal	zebrafish at normal developmental age of 72hpf in the 200 nM HBCD rep1	Sample HBCD 200nM 1	1	1	miRNA-Seq	TRANSCRIPTOMIC	other	SINGLE	ILLUMINA	Illumina Genome Analyzer II	<SPOT_DESCRIPTOR><SPOT_DECODE_SPEC><SPOT_LENGTH>36</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>	SRP058729	Sample_HBCD_200nM-1.fastq.tar.gz	fastq	636936228.0	17692673.0	Sample HBCD 200nM 1	0:36	A:138321201;C:126054708;G:184822056;T:187709777;N:28486	36	138321201	126054708	184822056	187709777	28486	SRX1041305	SRS947737	SRA269780	MG	Xiamen University	1	0.04374	0.0115	0.97839	0.29573	36	B	usable mapping rate	illumina	early_illumina	unknown	small_rna	unknown	bulk	unknown	unknown	China	2015-09-18	Larval	Larval	Whole Organism	All anatomical structures
39674	39674	SRR2043030	SRX1041276	SRS947712	SRP058729	PRJNA284830	MicroRNA expression changes during zebrafish Danio rerio development induced by hexabromocyclododecane	PRJNA284830	Whole Genome Sequencing	Hexabromocyclododecane HBCD one of the most widely used brominated flame retardants has been found to cause toxic effects on animals. Although microRNAs miRNAs play an important role in many biological and metabolic processes whether and how they are involved in the process of HBCD induced toxicity is largely unknown. In the present study zebrafish embryos were exposed to HBCD at low concentrations of 0 2 20 and 200 nM. Subsequently RNA was isolated from the embryo pool and the miRNAs expression profiles were analyzed using deep sequencing.	HBCD 2nM sample3	zebrafish at normal developmental age of 72hpf in the 2 nM HBCD rep3	HBCD 2nM 3	breed:zebrafish\|strain:Wild type TU strain\|age:72 hpf£¨hpf stage:embryo\|sex:pooled male and female\|tissue:whole zebrafish\|treatment:HBCD 2nM 3\|BioSampleModel:Model organism or animal	zebrafish at normal developmental age of 72hpf in the 200 nM HBCD rep3	Sample HBCD 2nM 3	1	1	miRNA-Seq	TRANSCRIPTOMIC	other	SINGLE	ILLUMINA	Illumina Genome Analyzer II	<SPOT_DESCRIPTOR><SPOT_DECODE_SPEC><SPOT_LENGTH>36</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>	SRP058729	Sample_HBCD_2nM-3.fastq.tar.gz	fastq	636936228.0	17692673.0	Sample HBCD 2nM 3	0:36	A:138321201;C:126054708;G:184822056;T:187709777;N:28486	36	138321201	126054708	184822056	187709777	28486	SRX1041276	SRS947712	SRA269780	MG	Xiamen University	1	0.04377	0.01174	0.97812	0.30675	36	B	usable mapping rate	illumina	early_illumina	unknown	small_rna	unknown	bulk	unknown	unknown	China	2015-05-27	Larval	Larval	Whole Organism	All anatomical structures
39675	39675	SRR2042999	SRX1041271	SRS947707	SRP058729	PRJNA284830	MicroRNA expression changes during zebrafish Danio rerio development induced by hexabromocyclododecane	PRJNA284830	Whole Genome Sequencing	Hexabromocyclododecane HBCD one of the most widely used brominated flame retardants has been found to cause toxic effects on animals. Although microRNAs miRNAs play an important role in many biological and metabolic processes whether and how they are involved in the process of HBCD induced toxicity is largely unknown. In the present study zebrafish embryos were exposed to HBCD at low concentrations of 0 2 20 and 200 nM. Subsequently RNA was isolated from the embryo pool and the miRNAs expression profiles were analyzed using deep sequencing.	HBCD 2nM sample2	zebrafish at normal developmental age of 72hpf in the 2 nM HBCD rep2	HBCD 2nM 2	breed:zebrafish\|strain:Wild type TU strain\|age:72 hpf£¨hpf stage:embryo\|sex:pooled male and female\|tissue:whole zebrafish\|treatment:HBCD 2nM 2\|BioSampleModel:Model organism or animal	zebrafish at normal developmental age of 72hpf in the 2 nM HBCD rep2	Sample HBCD 2nM 2	1	1	miRNA-Seq	TRANSCRIPTOMIC	other	SINGLE	ILLUMINA	Illumina Genome Analyzer II	<SPOT_DESCRIPTOR><SPOT_DECODE_SPEC><SPOT_LENGTH>36</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>	SRP058729	Sample_HBCD_2nM-2.fastq.tar.gz	fastq	482176476.0	13393791.0	Sample HBCD 2nM 2	0:36	A:104565872;C:92998014;G:137403437;T:147164823;N:44330	36	104565872	92998014	137403437	147164823	44330	SRX1041271	SRS947707	SRA269780	MG	Xiamen University	1	0.0759	0.02077	0.97025	0.33489	36	B	usable mapping rate	illumina	early_illumina	unknown	small_rna	unknown	bulk	unknown	unknown	China	2015-09-18	Larval	Larval	Whole Organism	All anatomical structures
39676	39676	SRR2040574	SRX1038901	SRS945650	SRP058729	PRJNA284830	MicroRNA expression changes during zebrafish Danio rerio development induced by hexabromocyclododecane	PRJNA284830	Whole Genome Sequencing	Hexabromocyclododecane HBCD one of the most widely used brominated flame retardants has been found to cause toxic effects on animals. Although microRNAs miRNAs play an important role in many biological and metabolic processes whether and how they are involved in the process of HBCD induced toxicity is largely unknown. In the present study zebrafish embryos were exposed to HBCD at low concentrations of 0 2 20 and 200 nM. Subsequently RNA was isolated from the embryo pool and the miRNAs expression profiles were analyzed using deep sequencing.	HBCD 2nM sample1	zebrafish at normal developmental age of 72hpf in the 2 nM HBCD rep1	HBCD 2nM 1	breed:zebrafish\|strain:Wild type TU strain\|age:72 hpf£¨hpf stage:embryo\|sex:pooled male and female\|tissue:whole zebrafish\|treatment:HBCD 2nM 1\|BioSampleModel:Model organism or animal	zebrafish at normal developmental age of 72hpf in the 2 nM HBCD rep1	Sample HBCD 2nM 1	1	1	miRNA-Seq	TRANSCRIPTOMIC	other	SINGLE	ILLUMINA	Illumina Genome Analyzer II	<SPOT_DESCRIPTOR><SPOT_DECODE_SPEC><SPOT_LENGTH>36</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>	SRP058729	Sample_HBCD_2nM-1.fastq.tar.gz	fastq	327925620.0	9109045.0	Sample HBCD 2nM 1	0:36	A:71167117;C:63917852;G:94874537;T:97936051;N:30063	36	71167117	63917852	94874537	97936051	30063	SRX1038901	SRS945650	SRA269780	MG	Xiamen University	1	0.06484	0.01622	0.97459	0.35746	36	B	usable mapping rate	illumina	early_illumina	unknown	small_rna	unknown	bulk	unknown	unknown	China	2015-05-27	Larval	Larval	Whole Organism	All anatomical structures
39677	39677	SRR2040573	SRX1038898	SRS945648	SRP058729	PRJNA284830	MicroRNA expression changes during zebrafish Danio rerio development induced by hexabromocyclododecane	PRJNA284830	Whole Genome Sequencing	Hexabromocyclododecane HBCD one of the most widely used brominated flame retardants has been found to cause toxic effects on animals. Although microRNAs miRNAs play an important role in many biological and metabolic processes whether and how they are involved in the process of HBCD induced toxicity is largely unknown. In the present study zebrafish embryos were exposed to HBCD at low concentrations of 0 2 20 and 200 nM. Subsequently RNA was isolated from the embryo pool and the miRNAs expression profiles were analyzed using deep sequencing.	HBCD 0nM sample3	zebrafish at normal developmental age of 72hpf in the control rep3	control 3	breed:zebrafish\|strain:Wild type TU strain\|age:72 hpf£¨hpf stage:embryo\|sex:pooled male and female\|tissue:whole zebrafish\|treatment:control 3\|BioSampleModel:Model organism or animal	zebrafish at normal developmental age of 72hpf in the control rep3	Sample control 3	1	1	miRNA-Seq	TRANSCRIPTOMIC	other	SINGLE	ILLUMINA	Illumina Genome Analyzer II	<SPOT_DESCRIPTOR><SPOT_DECODE_SPEC><SPOT_LENGTH>33</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>	SRP058729	Sample_control-3.fastq.tar.gz	fastq	456812301.0	13842797.0	Sample control 3	0:33	A:99424011;C:100923631;G:121758068;T:134398048;N:308543	33	99424011	100923631	121758068	134398048	308543	SRX1038898	SRS945648	SRA269780	MG	Xiamen University	1	0.14866	0.03878	0.95079	0.53781	33	B	usable mapping rate	illumina	early_illumina	unknown	small_rna	unknown	bulk	unknown	unknown	China	2015-09-18	Larval	Larval	Whole Organism	All anatomical structures
39678	39678	SRR2040572	SRX1038893	SRS945643	SRP058729	PRJNA284830	MicroRNA expression changes during zebrafish Danio rerio development induced by hexabromocyclododecane	PRJNA284830	Whole Genome Sequencing	Hexabromocyclododecane HBCD one of the most widely used brominated flame retardants has been found to cause toxic effects on animals. Although microRNAs miRNAs play an important role in many biological and metabolic processes whether and how they are involved in the process of HBCD induced toxicity is largely unknown. In the present study zebrafish embryos were exposed to HBCD at low concentrations of 0 2 20 and 200 nM. Subsequently RNA was isolated from the embryo pool and the miRNAs expression profiles were analyzed using deep sequencing.	HBCD 0nM sample2	zebrafish at normal developmental age of 72hpf in the control rep2	control 2	breed:zebrafish\|strain:Wild type TU strain\|age:72 hpf£¨hpf stage:embryo\|sex:pooled male and female\|tissue:whole zebrafish\|treatment:control 2\|BioSampleModel:Model organism or animal	zebrafish at normal developmental age of 72hpf in the control rep2	Sample control 2	1	1	miRNA-Seq	TRANSCRIPTOMIC	other	SINGLE	ILLUMINA	Illumina Genome Analyzer II	<SPOT_DESCRIPTOR><SPOT_DECODE_SPEC><SPOT_LENGTH>33</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>	SRP058729			451846230.0	13692310.0	Sample control 2	0:33	A:100056403;C:97812076;G:121442936;T:132449348;N:85467	33	100056403	97812076	121442936	132449348	85467	SRX1038893	SRS945643	SRA269780	MG	Xiamen University	1	0.06007	0.01901	0.96794	0.4743	33	B	usable mapping rate	illumina	early_illumina	unknown	small_rna	unknown	bulk	unknown	unknown	China	2015-05-27	Larval	Larval	Whole Organism	All anatomical structures
39679	39679	SRR2040562	SRX1038887	SRS945623	SRP058729	PRJNA284830	MicroRNA expression changes during zebrafish Danio rerio development induced by hexabromocyclododecane	PRJNA284830	Whole Genome Sequencing	Hexabromocyclododecane HBCD one of the most widely used brominated flame retardants has been found to cause toxic effects on animals. Although microRNAs miRNAs play an important role in many biological and metabolic processes whether and how they are involved in the process of HBCD induced toxicity is largely unknown. In the present study zebrafish embryos were exposed to HBCD at low concentrations of 0 2 20 and 200 nM. Subsequently RNA was isolated from the embryo pool and the miRNAs expression profiles were analyzed using deep sequencing.	Hexabromocyclododecane HBCD one of the most widely used brominated flame retardants has been found to cause toxic effects on animals. Although microRNAs miRNAs play an important role in many biological and metabolic processes whether and how they are involved in the process of HBCD induced toxicity is largely unknown. In the present study zebrafish embryos were exposed to HBCD at low concentrations of 0 2 20 200 nM. Subsequently RNA was isolated from the embryo pool and the miRNAs expression profiles were analyzed using deep sequencing.	zebrafish at normal developmental age of 72hpf in the control rep1	control 1	breed:zebrafish\|strain:Wild type TU strain\|age:72 hpf£¨hpf stage:embryo\|sex:pooled male and female\|tissue:whole zebrafish\|treatment:control 1\|BioSampleModel:Model organism or animal	zebrafish at normal developmental age of 72hpf in the control rep1	Sample control 1	1	1	miRNA-Seq	TRANSCRIPTOMIC	other	SINGLE	ILLUMINA	Illumina Genome Analyzer II	<SPOT_DESCRIPTOR><SPOT_DECODE_SPEC><SPOT_LENGTH>33</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>	SRP058729	Sample_control-1.fastq.tar.gz	fastq	398024253.0	12061341.0	Sample control 1	0:33	A:90133666;C:86672655;G:103932053;T:117192591;N:93288	33	90133666	86672655	103932053	117192591	93288	SRX1038887	SRS945623	SRA269780	MG	Xiamen University	1	0.08082	0.02367	0.96106	0.52033	33	B	usable mapping rate	illumina	early_illumina	unknown	small_rna	unknown	bulk	unknown	unknown	China	2015-05-27	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");;