metadata: run_metadata: 4 rows where experiment.library_selection = "PolyA", technology = "10x" and tissue_curation

4 rows where experiment.library_selection = "PolyA", technology = "10x" and tissue_curation_coarse = "Reproductive System"

descending

Link	rowid ▼	run.accession	experiment.accession	sample.accession	study.accession	bioproject	study.title	study.alias	study.type	study.abstract	study.PMIDs	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.study_ref	run.attributes	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.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
29187	29187	SRR8176747	SRX4996876	SRS4031879	SRP480945	PRJNA1055160	Single cell RNA seq of Juvenile Zebrafish Gonads from the Nadia Strain	PRJNA1055160	Other	We used single cell RNA Seq 10x Genomics Chromium to profile the transcriptomes of undifferentiated ZZ and ZW gonads at 19 dpf and immature ZZ and ZW gonads at 30 dpf	pubmed:38529407	Nadia 19dpf ZZ Gonad Single Cell RNA Seq	Nadia 19dpf ZZ Gonad Single Cell RNA Seq	strain:Nadia\|age:19 dpf provider:John H. Postlethwait University of Oregon\|genotype:ZZ\|BioSampleModel:Model organism or animal	scRNA Seq of Danio rerio: Nadia 19dpf ZZ gonad	Nadia 19dpf ZZ gonad	Nadia 19dpf ZZ gonad	A single cell suspension was prepared from the pooled gonads of five individuals. The sequencing library was prepared with the Chromium Single Cell 3 Library & Gel Bead Kit v2 10x Genomics.	RNA-Seq	TRANSCRIPTOMIC	PolyA	PAIRED	ILLUMINA	NextSeq 500	SRP480945	loader:fastq load.py	15090036999.0	107021539.0	zz 19NAmale I1 001.fastq.gz	0:8 1:133	A:4154103253;C:3402890354;G:3765557416;T:3755723849;N:11762127	8	133	4154103253	3402890354	3765557416	3755723849	11762127	SRX4996876	SRS4031879	SRA807619	University of Oregon\|Institute of Neuroscience	University of Oregon	T	B	sc-like readlen	illumina	nextseq	unknown	poly_a	unknown	sc	single_cell_droplet	10x	United States	2018-11-08	Larval	Larval	Gonad	Reproductive System
29188	29188	SRR8176753	SRX4996870	SRS4031878	SRP480945	PRJNA1055160	Single cell RNA seq of Juvenile Zebrafish Gonads from the Nadia Strain	PRJNA1055160	Other	We used single cell RNA Seq 10x Genomics Chromium to profile the transcriptomes of undifferentiated ZZ and ZW gonads at 19 dpf and immature ZZ and ZW gonads at 30 dpf	pubmed:38529407	Nadia 30dpf ZZ Gonad Single Cell RNA Seq	Nadia 30dpf ZZ Gonad Single Cell RNA Seq	strain:Nadia\|age:30 dpf provider:John H. Postlethwait University of Oregon\|genotype:ZZ\|BioSampleModel:Model organism or animal	scRNA Seq of Danio rerio: Nadia 30dpf ZZ gonad	Nadia 30dpf ZZ gonad	Nadia 30dpf ZZ gonad	A single cell suspension was prepared from the pooled gonads of five individuals. The sequencing library was prepared with the Chromium Single Cell 3 Library & Gel Bead Kit v2 10x Genomics.	RNA-Seq	TRANSCRIPTOMIC	PolyA	PAIRED	ILLUMINA	NextSeq 500	SRP480945	loader:fastq load.py	23587173438.0	167284918.0	1 I1 001.fastq.gz	0:8 1:133	A:6732844252;C:4934497997;G:5685086026;T:6219863789;N:14881374	8	133	6732844252	4934497997	5685086026	6219863789	14881374	SRX4996870	SRS4031878	SRA807619	University of Oregon\|Institute of Neuroscience	University of Oregon	T	B	sc-like readlen	illumina	nextseq	unknown	poly_a	unknown	sc	single_cell_droplet	10x	United States	2018-11-08	Juvenile	Juvenile	Gonad	Reproductive System
29189	29189	SRR8176754	SRX4996869	SRS4031877	SRP480945	PRJNA1055160	Single cell RNA seq of Juvenile Zebrafish Gonads from the Nadia Strain	PRJNA1055160	Other	We used single cell RNA Seq 10x Genomics Chromium to profile the transcriptomes of undifferentiated ZZ and ZW gonads at 19 dpf and immature ZZ and ZW gonads at 30 dpf	pubmed:38529407	Nadia 30dpf ZW Gonad Single Cell RNA Seq	Nadia 30dpf ZW Gonad Single Cell RNA Seq	strain:Nadia\|age:30 dpf provider:John H. Postlethwait University of Oregon\|genotype:ZW\|BioSampleModel:Model organism or animal	scRNA Seq of Danio rerio: Nadia 30dpf ZW gonad	Nadia 30dpf ZW gonad	Nadia 30dpf ZW gonad	A single cell suspension was prepared from the pooled gonads of five individuals. The sequencing library was prepared with the Chromium Single Cell 3 Library & Gel Bead Kit v2 10x Genomics.	RNA-Seq	TRANSCRIPTOMIC	PolyA	PAIRED	ILLUMINA	NextSeq 500	SRP480945	loader:fastq load.py	43358808480.0	307509280.0	2 I1 001.fastq.gz	0:8 1:133	A:12290612367;C:8880655083;G:10261318751;T:11898771792;N:27450487	8	133	12290612367	8880655083	10261318751	11898771792	27450487	SRX4996869	SRS4031877	SRA807619	University of Oregon\|Institute of Neuroscience	University of Oregon	T	B	sc-like readlen	illumina	nextseq	unknown	poly_a	unknown	sc	single_cell_droplet	10x	United States	2018-11-08	Juvenile	Juvenile	Gonad	Reproductive System
29190	29190	SRR8176756	SRX4996867	SRS4031876	SRP480945	PRJNA1055160	Single cell RNA seq of Juvenile Zebrafish Gonads from the Nadia Strain	PRJNA1055160	Other	We used single cell RNA Seq 10x Genomics Chromium to profile the transcriptomes of undifferentiated ZZ and ZW gonads at 19 dpf and immature ZZ and ZW gonads at 30 dpf	pubmed:38529407	Nadia 19dpf ZW Gonad Single Cell RNA Seq	Nadia 19dpf ZW Gonad Single Cell RNA Seq	strain:Nadia\|age:19 dpf provider:John H. Postlethwait University of Oregon\|genotype:ZW\|BioSampleModel:Model organism or animal	scRNA Seq of Danio rerio: Nadia 19dpf ZW gonad	Nadia 19dpf ZW gonad	Nadia 19dpf ZW gonad	A single cell suspension was prepared from the pooled gonads of five individuals. The sequencing library was prepared with the Chromium Single Cell 3 Library & Gel Bead Kit v2 10x Genomics.	RNA-Seq	TRANSCRIPTOMIC	PolyA	PAIRED	ILLUMINA	NextSeq 500	SRP480945	loader:fastq load.py	17141425554.0	121570394.0	zw 19NAfem I1 001.fastq.gz	0:8 1:133	A:4656207219;C:3824531650;G:4322736498;T:4324676442;N:13273745	8	133	4656207219	3824531650	4322736498	4324676442	13273745	SRX4996867	SRS4031876	SRA807619	University of Oregon\|Institute of Neuroscience	University of Oregon	T	B	sc-like readlen	illumina	nextseq	unknown	poly_a	unknown	sc	single_cell_droplet	10x	United States	2018-11-08	Larval	Larval	Gonad	Reproductive System

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