metadata: run_metadata: 6 rows where experiment.library_layout = "SINGLE", technology = "generic-scrnaseq-only" and tissue

6 rows where experiment.library_layout = "SINGLE", technology = "generic-scrnaseq-only" and tissue_curation = "Kidney"

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	GEOsample.title	GEOsample.dataprocessing	GEOsample.source	GEOsample.extractprotocol	GEOsample.characteristics	GEOsample.accession	experiment.title	experiment.alias	experiment.design_description	experiment.library_construction_protocol	experiment.attributes	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.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
41902	41902	SRR5337748	SRX2635098	SRS2043910	SRP101756	PRJNA378882	Transcriptome of the distal late segment of the zebrafish mesonephros	GSE96519	Transcriptome Analysis	We aimed to gain insights into the evolutionary origin of genetic mechanisms of NaCl handling. To this aim we obtained transcription profilings in the zebrafish distal late DL segment the equvalent segment of the mammalian distal convoluted tubules that play a critical role in NaCl homeostasis. Overall design: We compared the transcriptomes from DL segments and the rest of the mesonephros isolated from transgenic zebrafish expressing mCherry in the DL segments.	pubmed:28656378	YS6	GSM2534771	tissue:Mes1phros DL\|transgene:Tgslc12a3:mCherry\|genotype:mCh \|age:adult	YS6	none provided by the submitter Genome build: n/a Supplementary files format and content: raw counts	Mesonephros DL	DL segments were manually micro dissected from Tgslc12a3:mCherry and RNAs were extracted using the RNA extraction kit Machery Nagel. Apaptor ligated cDNA libraries were constructed using Ovation Single Cell RNA seq System NuGEN.	transgene:Tgslc12a3:mCherry\|genotype:mCh \|age:adult	GSM2534771	GSM2534771: YS6; Danio rerio; RNA Seq	GSM2534771	1	DL segments were manually micro dissected from Tgslc12a3:mCherry and RNAs were extracted using the RNA extraction kit Machery Nagel. Apaptor ligated cDNA libraries were constructed using Ovation Single Cell RNA seq System NuGEN.	GEO Accession:GSM2534771	RNA-Seq	TRANSCRIPTOMIC	cDNA	SINGLE	ILLUMINA	Illumina HiSeq 2500	SRP101756	20150717.A-YS6_R1.fastq.gz	fastq	5434051896.0	43127396.0	GSM2534771 r1	0:126	A:1185876928;C:1354521221;G:1643633065;T:1249907593;N:113089	126	1185876928	1354521221	1643633065	1249907593	113089	SRX2635098	SRS2043910	SRA544882	GEO	Drummond, Nephrology, Massachusetts General Hospital	1	0.97351	0.17501	0.85303	0.75625	126	B	usable mapping rate	illumina	hiseq_era	unknown	cdna_unspecified	unknown	sc_generic	single_cell_generic	generic-scrnaseq-only	United States	2017-03-12	Adult	Adult	Kidney	Renal System
41903	41903	SRR5337747	SRX2635097	SRS2043909	SRP101756	PRJNA378882	Transcriptome of the distal late segment of the zebrafish mesonephros	GSE96519	Transcriptome Analysis	We aimed to gain insights into the evolutionary origin of genetic mechanisms of NaCl handling. To this aim we obtained transcription profilings in the zebrafish distal late DL segment the equvalent segment of the mammalian distal convoluted tubules that play a critical role in NaCl homeostasis. Overall design: We compared the transcriptomes from DL segments and the rest of the mesonephros isolated from transgenic zebrafish expressing mCherry in the DL segments.	pubmed:28656378	YS5	GSM2534770	tissue:DL segments\|transgene:Tgslc12a3:mCherry\|genotype:mCh+\|age:adult	YS5	none provided by the submitter Genome build: n/a Supplementary files format and content: raw counts	DL segments	DL segments were manually micro dissected from Tgslc12a3:mCherry and RNAs were extracted using the RNA extraction kit Machery Nagel. Apaptor ligated cDNA libraries were constructed using Ovation Single Cell RNA seq System NuGEN.	transgene:Tgslc12a3:mCherry\|genotype:mCh+\|age:adult	GSM2534770	GSM2534770: YS5; Danio rerio; RNA Seq	GSM2534770	1	DL segments were manually micro dissected from Tgslc12a3:mCherry and RNAs were extracted using the RNA extraction kit Machery Nagel. Apaptor ligated cDNA libraries were constructed using Ovation Single Cell RNA seq System NuGEN.	GEO Accession:GSM2534770	RNA-Seq	TRANSCRIPTOMIC	cDNA	SINGLE	ILLUMINA	Illumina HiSeq 2500	SRP101756	20150717.A-YS5_R1.fastq(1).gz	fastq	2297696058.0	18235683.0	GSM2534770 r1	0:126	A:648837532;C:505738661;G:568578688;T:574489076;N:52101	126	648837532	505738661	568578688	574489076	52101	SRX2635097	SRS2043909	SRA544882	GEO	Drummond, Nephrology, Massachusetts General Hospital	1	0.94402	0.1927	0.77585	0.67728	126	B	usable mapping rate	illumina	hiseq_era	unknown	cdna_unspecified	unknown	sc_generic	single_cell_generic	generic-scrnaseq-only	United States	2017-03-12	Adult	Adult	Kidney	Renal System
41904	41904	SRR5337746	SRX2635096	SRS2043908	SRP101756	PRJNA378882	Transcriptome of the distal late segment of the zebrafish mesonephros	GSE96519	Transcriptome Analysis	We aimed to gain insights into the evolutionary origin of genetic mechanisms of NaCl handling. To this aim we obtained transcription profilings in the zebrafish distal late DL segment the equvalent segment of the mammalian distal convoluted tubules that play a critical role in NaCl homeostasis. Overall design: We compared the transcriptomes from DL segments and the rest of the mesonephros isolated from transgenic zebrafish expressing mCherry in the DL segments.	pubmed:28656378	YS4	GSM2534769	tissue:Mes1phros DL\|transgene:Tgslc12a3:mCherry\|genotype:mCh \|age:adult	YS4	none provided by the submitter Genome build: n/a Supplementary files format and content: raw counts	Mesonephros DL	DL segments were manually micro dissected from Tgslc12a3:mCherry and RNAs were extracted using the RNA extraction kit Machery Nagel. Apaptor ligated cDNA libraries were constructed using Ovation Single Cell RNA seq System NuGEN.	transgene:Tgslc12a3:mCherry\|genotype:mCh \|age:adult	GSM2534769	GSM2534769: YS4; Danio rerio; RNA Seq	GSM2534769	1	DL segments were manually micro dissected from Tgslc12a3:mCherry and RNAs were extracted using the RNA extraction kit Machery Nagel. Apaptor ligated cDNA libraries were constructed using Ovation Single Cell RNA seq System NuGEN.	GEO Accession:GSM2534769	RNA-Seq	TRANSCRIPTOMIC	cDNA	SINGLE	ILLUMINA	Illumina HiSeq 2500	SRP101756	20150717.A-YS4_R1.fastq.gz	fastq	4570634754.0	36274879.0	GSM2534769 r1	0:126	A:1179398927;C:1024363944;G:1239125274;T:1127644877;N:101732	126	1179398927	1024363944	1239125274	1127644877	101732	SRX2635096	SRS2043908	SRA544882	GEO	Drummond, Nephrology, Massachusetts General Hospital	1	0.93083	0.27465	0.78102	0.70638	126	B	usable mapping rate	illumina	hiseq_era	unknown	cdna_unspecified	unknown	sc_generic	single_cell_generic	generic-scrnaseq-only	United States	2017-03-12	Adult	Adult	Kidney	Renal System
41905	41905	SRR5337745	SRX2635095	SRS2043907	SRP101756	PRJNA378882	Transcriptome of the distal late segment of the zebrafish mesonephros	GSE96519	Transcriptome Analysis	We aimed to gain insights into the evolutionary origin of genetic mechanisms of NaCl handling. To this aim we obtained transcription profilings in the zebrafish distal late DL segment the equvalent segment of the mammalian distal convoluted tubules that play a critical role in NaCl homeostasis. Overall design: We compared the transcriptomes from DL segments and the rest of the mesonephros isolated from transgenic zebrafish expressing mCherry in the DL segments.	pubmed:28656378	YS3	GSM2534768	tissue:DL segments\|transgene:Tgslc12a3:mCherry\|genotype:mCh+\|age:adult	YS3	none provided by the submitter Genome build: n/a Supplementary files format and content: raw counts	DL segments	DL segments were manually micro dissected from Tgslc12a3:mCherry and RNAs were extracted using the RNA extraction kit Machery Nagel. Apaptor ligated cDNA libraries were constructed using Ovation Single Cell RNA seq System NuGEN.	transgene:Tgslc12a3:mCherry\|genotype:mCh+\|age:adult	GSM2534768	GSM2534768: YS3; Danio rerio; RNA Seq	GSM2534768	1	DL segments were manually micro dissected from Tgslc12a3:mCherry and RNAs were extracted using the RNA extraction kit Machery Nagel. Apaptor ligated cDNA libraries were constructed using Ovation Single Cell RNA seq System NuGEN.	GEO Accession:GSM2534768	RNA-Seq	TRANSCRIPTOMIC	cDNA	SINGLE	ILLUMINA	Illumina HiSeq 2500	SRP101756	20150717.A-YS3_R1.fastq.gz	fastq	5648398686.0	44828561.0	GSM2534768 r1	0:126	A:1607436982;C:1222995706;G:1369036558;T:1448805498;N:123942	126	1607436982	1222995706	1369036558	1448805498	123942	SRX2635095	SRS2043907	SRA544882	GEO	Drummond, Nephrology, Massachusetts General Hospital	1	0.93399	0.20266	0.78076	0.73978	126	B	usable mapping rate	illumina	hiseq_era	unknown	cdna_unspecified	unknown	sc_generic	single_cell_generic	generic-scrnaseq-only	United States	2017-03-12	Adult	Adult	Kidney	Renal System
41906	41906	SRR5337744	SRX2635094	SRS2043906	SRP101756	PRJNA378882	Transcriptome of the distal late segment of the zebrafish mesonephros	GSE96519	Transcriptome Analysis	We aimed to gain insights into the evolutionary origin of genetic mechanisms of NaCl handling. To this aim we obtained transcription profilings in the zebrafish distal late DL segment the equvalent segment of the mammalian distal convoluted tubules that play a critical role in NaCl homeostasis. Overall design: We compared the transcriptomes from DL segments and the rest of the mesonephros isolated from transgenic zebrafish expressing mCherry in the DL segments.	pubmed:28656378	YS2	GSM2534767	tissue:Mes1phros DL\|transgene:Tgslc12a3:mCherry\|genotype:mCh \|age:adult	YS2	none provided by the submitter Genome build: n/a Supplementary files format and content: raw counts	Mesonephros DL	DL segments were manually micro dissected from Tgslc12a3:mCherry and RNAs were extracted using the RNA extraction kit Machery Nagel. Apaptor ligated cDNA libraries were constructed using Ovation Single Cell RNA seq System NuGEN.	transgene:Tgslc12a3:mCherry\|genotype:mCh \|age:adult	GSM2534767	GSM2534767: YS2; Danio rerio; RNA Seq	GSM2534767	1	DL segments were manually micro dissected from Tgslc12a3:mCherry and RNAs were extracted using the RNA extraction kit Machery Nagel. Apaptor ligated cDNA libraries were constructed using Ovation Single Cell RNA seq System NuGEN.	GEO Accession:GSM2534767	RNA-Seq	TRANSCRIPTOMIC	cDNA	SINGLE	ILLUMINA	Illumina HiSeq 2500	SRP101756	20150717.A-YS2_R1.fastq.gz	fastq	4680679374.0	37148249.0	GSM2534767 r1	0:126	A:1320151433;C:986429614;G:1112497899;T:1261495719;N:104709	126	1320151433	986429614	1112497899	1261495719	104709	SRX2635094	SRS2043906	SRA544882	GEO	Drummond, Nephrology, Massachusetts General Hospital	1	0.91952	0.24724	0.73884	0.63985	126	B	usable mapping rate	illumina	hiseq_era	unknown	cdna_unspecified	unknown	sc_generic	single_cell_generic	generic-scrnaseq-only	United States	2017-03-12	Adult	Adult	Kidney	Renal System
41907	41907	SRR5337743	SRX2635093	SRS2043905	SRP101756	PRJNA378882	Transcriptome of the distal late segment of the zebrafish mesonephros	GSE96519	Transcriptome Analysis	We aimed to gain insights into the evolutionary origin of genetic mechanisms of NaCl handling. To this aim we obtained transcription profilings in the zebrafish distal late DL segment the equvalent segment of the mammalian distal convoluted tubules that play a critical role in NaCl homeostasis. Overall design: We compared the transcriptomes from DL segments and the rest of the mesonephros isolated from transgenic zebrafish expressing mCherry in the DL segments.	pubmed:28656378	YS1	GSM2534766	tissue:DL segments\|transgene:Tgslc12a3:mCherry\|genotype:mCh+\|age:adult	YS1	none provided by the submitter Genome build: n/a Supplementary files format and content: raw counts	DL segments	DL segments were manually micro dissected from Tgslc12a3:mCherry and RNAs were extracted using the RNA extraction kit Machery Nagel. Apaptor ligated cDNA libraries were constructed using Ovation Single Cell RNA seq System NuGEN.	transgene:Tgslc12a3:mCherry\|genotype:mCh+\|age:adult	GSM2534766	GSM2534766: YS1; Danio rerio; RNA Seq	GSM2534766	1	DL segments were manually micro dissected from Tgslc12a3:mCherry and RNAs were extracted using the RNA extraction kit Machery Nagel. Apaptor ligated cDNA libraries were constructed using Ovation Single Cell RNA seq System NuGEN.	GEO Accession:GSM2534766	RNA-Seq	TRANSCRIPTOMIC	cDNA	SINGLE	ILLUMINA	Illumina HiSeq 2500	SRP101756	20150717.A-YS1_R1.fastq.gz	fastq	7000703892.0	55561142.0	GSM2534766 r1	0:126	A:1521231890;C:1760818628;G:2148863730;T:1569634203;N:155441	126	1521231890	1760818628	2148863730	1569634203	155441	SRX2635093	SRS2043905	SRA544882	GEO	Drummond, Nephrology, Massachusetts General Hospital	1	0.96016	0.1982	0.86261	0.75572	126	B	usable mapping rate	illumina	hiseq_era	unknown	cdna_unspecified	unknown	sc_generic	single_cell_generic	generic-scrnaseq-only	United States	2017-03-12	Adult	Adult	Kidney	Renal 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");;