metadata: run_metadata: 3 rows where experiment.library_selection = "RANDOM", experiment.library_source = "TRANSCRIPTOMIC SINGLE CELL" and tissue_curation

3 rows where experiment.library_selection = "RANDOM", experiment.library_source = "TRANSCRIPTOMIC SINGLE CELL" and tissue_curation_coarse = "Digestive System"

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	experiment.title	experiment.alias	experiment.library_name	experiment.design_description	experiment.library_strategy	experiment.library_source	experiment.library_selection	experiment.library_layout	experiment.platform	experiment.instrument_model	experiment.study_ref	run.filename	run.semantic_name	run.total_bases	run.total_spots	run.alias	run.read_lengths	run.base_counts	run.r1_length	run.r2_length	run.Acount	run.Ccount	run.Gcount	run.Tcount	run.Ncount	run.experiment	run.pool_member	submission.accession	submission.srasource	submission.bioprojectsource	seqdetective.n_mates	seqdetective.mapping_rate.mate1	seqdetective.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
71597	71597	SRR21780858	SRX17775679	SRS15301946	SRP400655	PRJNA885906	Cell Type Specific Responses to the Microbiota Across All Tissues of the Larval Zebrafish	PRJNA885906	Other	The transcriptional responses of the host zebrafish to the presence of the microbiota was assessed across all cell types throughout the larval body at single cell resolution. The goal of this work is to generate a resource for generating new hypotheses about the intricate interactions between animal hosts and their microbiota.	BefA diss	BefA 1532	strain:Tgins; eGFP\|dev stage:6dpf\|sex:not applicable\|tissue:dissected digestive systems\|BioSampleModel:Model organism or animal	germ free 6dpf dissected digestive systems treated with protein	1532	1532	the cells are from dissected guts from germ free larvae but were treated with exogenous protein	RNA-Seq	TRANSCRIPTOMIC SINGLE CELL	RANDOM	PAIRED	ILLUMINA	Illumina HiSeq 4000	SRP400655	BefAdiss_S2_L008_R1_001.fastq.gz BefAdiss_S2_L008_R2_001.fastq.gz	fastq fastq	62618506720.0	355786970.0	BefAdiss S2 L008 R1 001.fastq.gz	0:26 1:150	A:18434729847;C:13374700052;G:13922149278;T:16789619859;N:97307684	26	150	18434729847	13374700052	13922149278	16789619859	97307684	SRX17775679	SRS15301946	SRA1511285	University of Oregon\|Institute of Molecular Biology	University of Oregon	2	0.00182	0.89692	0.00064	0.07716	0.9962	0.82798	0.42608	0.6075	26	150	T	B	sc-like readlen	illumina	hiseq_era	unknown	random_priming	unknown	sc	unknown	unknown	United States	2022-10-02	Larval	Larval	Gut	Digestive System
71598	71598	SRR21780859	SRX17775678	SRS15301945	SRP400655	PRJNA885906	Cell Type Specific Responses to the Microbiota Across All Tissues of the Larval Zebrafish	PRJNA885906	Other	The transcriptional responses of the host zebrafish to the presence of the microbiota was assessed across all cell types throughout the larval body at single cell resolution. The goal of this work is to generate a resource for generating new hypotheses about the intricate interactions between animal hosts and their microbiota.	GF diss2	GF 1531	strain:Tgins; eGFP\|dev stage:6dpf\|sex:not applicable\|tissue:dissected digestive systems\|BioSampleModel:Model organism or animal	germ free 6dpf dissected digestive systems lane 2	1531	1531	the cells dissected guts from germ free larvae were split across two lanes library 1530/1531 come from same sample	RNA-Seq	TRANSCRIPTOMIC SINGLE CELL	RANDOM	PAIRED	ILLUMINA	Illumina HiSeq 4000	SRP400655	GFdiss2_S1_L004_R1_001.fastq.gz GFdiss2_S1_L004_R2_001.fastq.gz	fastq fastq	66862372720.0	379899845.0	GFdiss2 S1 L004 R1 001.fastq.gz	0:26 1:150	A:10814720171;C:8609009803;G:8785194946;T:9942289999;N:28711157801	26	150	10814720171	8609009803	8785194946	9942289999	28711157801	SRX17775678	SRS15301945	SRA1511285	University of Oregon\|Institute of Molecular Biology	University of Oregon	2	0.00191	0.92014	0.00074	0.08575	0.99616	0.87793	0.35964	0.58459	26	150	T	B	sc-like readlen	illumina	hiseq_era	unknown	random_priming	unknown	sc	unknown	unknown	United States	2022-10-02	Larval	Larval	Gut	Digestive System
71599	71599	SRR21780860	SRX17775677	SRS15301944	SRP400655	PRJNA885906	Cell Type Specific Responses to the Microbiota Across All Tissues of the Larval Zebrafish	PRJNA885906	Other	The transcriptional responses of the host zebrafish to the presence of the microbiota was assessed across all cell types throughout the larval body at single cell resolution. The goal of this work is to generate a resource for generating new hypotheses about the intricate interactions between animal hosts and their microbiota.	GF diss1	GF 1530	strain:Tgins; eGFP\|dev stage:6dpf\|sex:not applicable\|tissue:dissected digestive systems\|BioSampleModel:Model organism or animal	germ free 6dpf dissected digestive systems lane 1	1530	1530	the cells dissected guts from germ free larvae were split across two lanes library 1530/1531 come from same sample	RNA-Seq	TRANSCRIPTOMIC SINGLE CELL	RANDOM	PAIRED	ILLUMINA	Illumina HiSeq 4000	SRP400655	GFdiss1_S1_L007_R1_001.fastq.gz GFdiss1_S1_L007_R2_001.fastq.gz	fastq fastq	63769716736.0	362327936.0	GFdiss1 S1 L007 R1 001.fastq.gz	0:26 1:150	A:18291156920;C:14095548431;G:14421791117;T:16786925671;N:174294597	26	150	18291156920	14095548431	14421791117	16786925671	174294597	SRX17775677	SRS15301944	SRA1511285	University of Oregon\|Institute of Molecular Biology	University of Oregon	2	0.00172	0.91725	0.00064	0.08763	0.99648	0.82804	0.39234	0.5982	26	150	T	B	sc-like readlen	illumina	hiseq_era	unknown	random_priming	unknown	sc	unknown	unknown	United States	2022-10-02	Larval	Larval	Gut	Digestive 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");;