metadata: run_metadata: 8 rows where experiment.library_selection = "RANDOM", experiment.library_strategy = "RNA-Seq" and tissue_curation

8 rows where experiment.library_selection = "RANDOM", experiment.library_strategy = "RNA-Seq" and tissue_curation_coarse = "Cardiovascular 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.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.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
37107	37107	SRR891495	SRX298188	SRS673878	SRP024369	PRJNA207719	Tissue specific transcriptome profiling of zebrafish	PRJNA207719	Other	Tissue specific transcriptome profiling of zebrafish.			Danio rerio heart	sex:missing\|strain:wild type\|tissue:heart\|health state:normal\|collection date:2013\|geo loc name:India\|biomaterial provider:CSIR Institute of Genomics and Integrative Biology\|age:adult\|BioSampleModel:Model organism or animal	Tissue specific transcriptome of Danio rerio	Transcriptome of zebrafish Danio rerio heart	Zebrafish heart	mRNA sequencing via poly A enrichment using poly A beads Illumina mRNA seq protocol	RNA-Seq	TRANSCRIPTOMIC	RANDOM	PAIRED	ILLUMINA	Illumina Genome Analyzer IIx	<SPOT_DESCRIPTOR><SPOT_DECODE_SPEC><SPOT_LENGTH>102</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><READ_SPEC><READ_INDEX>1</READ_INDEX><READ_CLASS>Application Read</READ_CLASS><READ_TYPE>Reverse</READ_TYPE><BASE_COORD>52</BASE_COORD></READ_SPEC></SPOT_DECODE_SPEC></SPOT_DESCRIPTOR>	SRP024369	lane1_NoIndex_L001_R1_cat.fastq lane1_NoIndex_L001_R2_cat.fastq	fastq fastq	2757807456.0	27037328.0	Transcriptome of zebrafish Danio rerio heart	0:51 1:51	A:685519386;C:693864326;G:733553235;T:643916122;N:954387	51	51	685519386	693864326	733553235	643916122	954387	SRX298188	SRS673878	SRA089174	CSIR-IGIB	CSIR-Institute of Genomics and Integrative Biology CSIR-Institute of Genomics and Integrative Biology	2	0.789	0.79038	0.05666	0.05598	0.76982	0.77441	0.45627	0.46617	51	51	B	B	biological fallback assumption	illumina	early_illumina	unknown	random_priming	unknown	bulk	unknown	unknown	India	2013-10-10	Adult	Adult	Heart	Cardiovascular System
39857	39857	SRR2293665	SRX1158743	SRS1039790	SRP062585	PRJNA293269	Danio rerio bigheart mutant transcriptome	PRJNA293269	Whole Genome Sequencing	Zebrafish cardiac transcriptome of big heart mutant. The Bigheart mutant is generated by random mutagenesis in zebrafish ASWT strain by using gene breaking trap GBT PX vector		Bigheart mutant cardiac transcriptome from Danio rerio	Bigheart	breed:ASWT\|age:Adult\|sex:pooled male and female\|tissue:Heart\|biomaterial provider:CSIR IGIB\|disease:Cardiac hypertrophy\|geo loc name:India\|BioSampleModel:Model organism or animal	zebrafish Bigheart homozygous cardiac mutant	Bigheart homozygous cardiac mutant	Bigheart homozygous	Truseq RNA seq with ribozero gold	RNA-Seq	TRANSCRIPTOMIC	RANDOM	PAIRED	ILLUMINA	Illumina HiSeq 2500	<SPOT_DESCRIPTOR><SPOT_DECODE_SPEC><SPOT_LENGTH>202</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><READ_SPEC><READ_INDEX>1</READ_INDEX><READ_CLASS>Application Read</READ_CLASS><READ_TYPE>Reverse</READ_TYPE><BASE_COORD>102</BASE_COORD></READ_SPEC></SPOT_DECODE_SPEC></SPOT_DESCRIPTOR>	SRP062585	ZF_24F_homo_ATGTCA_R1_cat.fastq.gz ZF_24F_homo_ATGTCA_R2_cat.fastq.gz	fastq fastq	3375458178.0	16710189.0	Zebrafish bigheart homozygous mutant cardiac transcriptome	0:101 1:101	A:914068294;C:764700320;G:768182746;T:927976744;N:530074	101	101	914068294	764700320	768182746	927976744	530074	SRX1158743	SRS1039790	SRA290009	CSIR-IGIB	CSIR- Institute of Genomics and Integrative Biology	2	0.90592	0.90808	0.24934	0.24544	0.73206	0.73316	0.50089	0.50209	101	101	B	B	biological fallback assumption	illumina	hiseq_era	unknown	random_priming	ribozero	bulk	unknown	unknown	India	2016-08-19	Adult	Adult	Heart	Cardiovascular System
39858	39858	SRR2293664	SRX1158742	SRS1039790	SRP062585	PRJNA293269	Danio rerio bigheart mutant transcriptome	PRJNA293269	Whole Genome Sequencing	Zebrafish cardiac transcriptome of big heart mutant. The Bigheart mutant is generated by random mutagenesis in zebrafish ASWT strain by using gene breaking trap GBT PX vector		Bigheart mutant cardiac transcriptome from Danio rerio	Bigheart	breed:ASWT\|age:Adult\|sex:pooled male and female\|tissue:Heart\|biomaterial provider:CSIR IGIB\|disease:Cardiac hypertrophy\|geo loc name:India\|BioSampleModel:Model organism or animal	ZEBRAFISH Bigheart hetrozygous cardiac transcriptome	Bigheart hetrozygous cardiac transcriptome	Bigheart heterozygous	Truseq RNA seq with robozero gold	RNA-Seq	TRANSCRIPTOMIC	RANDOM	PAIRED	ILLUMINA	Illumina HiSeq 2500	<SPOT_DESCRIPTOR><SPOT_DECODE_SPEC><SPOT_LENGTH>202</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><READ_SPEC><READ_INDEX>1</READ_INDEX><READ_CLASS>Application Read</READ_CLASS><READ_TYPE>Reverse</READ_TYPE><BASE_COORD>102</BASE_COORD></READ_SPEC></SPOT_DECODE_SPEC></SPOT_DESCRIPTOR>	SRP062585	ZF_24F_hetero_CCGTCC_R2_cat.fastq.gz ZF_24F_hetero_CCGTCC_R1_cat.fastq.gz	fastq fastq	17775105746.0	87995573.0	Transcriptome of zebrafish Bigheart heterozygous mutant cardiac transcriptome	0:101 1:101	A:4910552704;C:3934124661;G:3958965970;T:4968643725;N:2818686	101	101	4910552704	3934124661	3958965970	4968643725	2818686	SRX1158742	SRS1039790	SRA290009	CSIR-IGIB	CSIR- Institute of Genomics and Integrative Biology	2	0.89569	0.89916	0.30152	0.30176	0.73598	0.73641	0.4892	0.49332	101	101	B	B	biological fallback assumption	illumina	hiseq_era	unknown	random_priming	trueseq	bulk	unknown	unknown	India	2016-08-19	Adult	Adult	Heart	Cardiovascular System
55977	55977	SRR10895882	SRX7564597	SRS6001804	SRP241982	PRJNA599026	Project of basal ray finned fishes	PRJNA599026	Other	The project is to study the oldest fish lineages in the ray finned fishes. Although they belong to fish their body structure and behavior remain highly similar to that of the tetrapods. Through comparative genome analysis with living vertebrates we provides insights into the molecular basis of terrestrial adaptation of basal ray finned fishes.	pubmed:33545088;pubmed:12470943		Zebrafish 008	strain:not collected\|isolate:not collected\|breed:not collected\|cultivar:not collected\|ecotype:not collected\|age:not collected\|dev stage:Adult\|sex:not determined\|tissue:Heart\|BioSampleModel:Model organism or animal	RNA Seq of Danio rerio : adult	CL100101924 L01 10	CL100101924 L01 10		RNA-Seq	TRANSCRIPTOMIC	RANDOM	PAIRED	BGISEQ	BGISEQ-500		SRP241982	CL100101924_L01_545_2.fq.gz CL100101924_L01_545_1.fq.gz	fastq fastq	9098943800.0	90989438.0	CL100101924 L01 545 1.fq.gz	0:100 1:100	A:2494855042;C:2016596912;G:2050775890;T:2525488540;N:11227416	100	100	2494855042	2016596912	2050775890	2525488540	11227416	SRX7564597	SRS6001804	SRA1026516	BGI\|BGI-Research	BGI	1	0.93737		0.07867		0.76061		0.53141		100		B		usable mapping rate	bgi	bgi	unknown	random_priming	unknown	bulk	unknown	unknown	China	2020-01-15	Adult	Adult	Heart	Cardiovascular System
55978	55978	SRR10895883	SRX7564596	SRS6001804	SRP241982	PRJNA599026	Project of basal ray finned fishes	PRJNA599026	Other	The project is to study the oldest fish lineages in the ray finned fishes. Although they belong to fish their body structure and behavior remain highly similar to that of the tetrapods. Through comparative genome analysis with living vertebrates we provides insights into the molecular basis of terrestrial adaptation of basal ray finned fishes.	pubmed:33545088;pubmed:12470943		Zebrafish 008	strain:not collected\|isolate:not collected\|breed:not collected\|cultivar:not collected\|ecotype:not collected\|age:not collected\|dev stage:Adult\|sex:not determined\|tissue:Heart\|BioSampleModel:Model organism or animal	RNA Seq of Danio rerio : adult	CL100103178 L01 4	CL100103178 L01 4		RNA-Seq	TRANSCRIPTOMIC	RANDOM	PAIRED	BGISEQ	BGISEQ-500		SRP241982	CL100103178_L01_570_2.fq.gz CL100103178_L01_570_1.fq.gz	fastq fastq	6098551000.0	60985510.0	CL100103178 L01 570 1.fq.gz	0:100 1:100	A:1665824009;C:1362170830;G:1387665851;T:1676412762;N:6477548	100	100	1665824009	1362170830	1387665851	1676412762	6477548	SRX7564596	SRS6001804	SRA1026516	BGI\|BGI-Research	BGI	1	0.9281		0.07522		0.77715		0.52597		100		B		usable mapping rate	bgi	bgi	unknown	random_priming	unknown	bulk	unknown	unknown	China	2020-01-15	Adult	Adult	Heart	Cardiovascular System
55979	55979	SRR10895884	SRX7564595	SRS6001804	SRP241982	PRJNA599026	Project of basal ray finned fishes	PRJNA599026	Other	The project is to study the oldest fish lineages in the ray finned fishes. Although they belong to fish their body structure and behavior remain highly similar to that of the tetrapods. Through comparative genome analysis with living vertebrates we provides insights into the molecular basis of terrestrial adaptation of basal ray finned fishes.	pubmed:33545088;pubmed:12470943		Zebrafish 008	strain:not collected\|isolate:not collected\|breed:not collected\|cultivar:not collected\|ecotype:not collected\|age:not collected\|dev stage:Adult\|sex:not determined\|tissue:Heart\|BioSampleModel:Model organism or animal	RNA Seq of Danio rerio : adult	CL100103178 L01 3	CL100103178 L01 3		RNA-Seq	TRANSCRIPTOMIC	RANDOM	PAIRED	BGISEQ	BGISEQ-500		SRP241982	CL100103178_L01_568_2.fq.gz CL100103178_L01_568_1.fq.gz	fastq fastq	7674097800.0	76740978.0	CL100103178 L01 568 1.fq.gz	0:100 1:100	A:2066126344;C:1741642506;G:1775116741;T:2081782365;N:9429844	100	100	2066126344	1741642506	1775116741	2081782365	9429844	SRX7564595	SRS6001804	SRA1026516	BGI\|BGI-Research	BGI	1	0.92233		0.07056		0.76029		0.55672		100		B		usable mapping rate	bgi	bgi	unknown	random_priming	unknown	bulk	unknown	unknown	China	2020-01-15	Adult	Adult	Heart	Cardiovascular System
55980	55980	SRR10895885	SRX7564594	SRS6001804	SRP241982	PRJNA599026	Project of basal ray finned fishes	PRJNA599026	Other	The project is to study the oldest fish lineages in the ray finned fishes. Although they belong to fish their body structure and behavior remain highly similar to that of the tetrapods. Through comparative genome analysis with living vertebrates we provides insights into the molecular basis of terrestrial adaptation of basal ray finned fishes.	pubmed:33545088;pubmed:12470943		Zebrafish 008	strain:not collected\|isolate:not collected\|breed:not collected\|cultivar:not collected\|ecotype:not collected\|age:not collected\|dev stage:Adult\|sex:not determined\|tissue:Heart\|BioSampleModel:Model organism or animal	RNA Seq of Danio rerio : adult	CL100103178 L01 2	CL100103178 L01 2		RNA-Seq	TRANSCRIPTOMIC	RANDOM	PAIRED	BGISEQ	BGISEQ-500		SRP241982	CL100103178_L01_569_1.fq.gz CL100103178_L01_569_2.fq.gz	fastq fastq	10407446000.0	104074460.0	CL100103178 L01 569 1.fq.gz	0:100 1:100	A:2806156548;C:2359148121;G:2410612409;T:2819342794;N:12186128	100	100	2806156548	2359148121	2410612409	2819342794	12186128	SRX7564594	SRS6001804	SRA1026516	BGI\|BGI-Research	BGI	1	0.9202		0.06921		0.77384		0.56843		100		B		usable mapping rate	bgi	bgi	unknown	random_priming	unknown	bulk	unknown	unknown	China	2020-01-15	Adult	Adult	Heart	Cardiovascular System
55981	55981	SRR10895886	SRX7564593	SRS6001804	SRP241982	PRJNA599026	Project of basal ray finned fishes	PRJNA599026	Other	The project is to study the oldest fish lineages in the ray finned fishes. Although they belong to fish their body structure and behavior remain highly similar to that of the tetrapods. Through comparative genome analysis with living vertebrates we provides insights into the molecular basis of terrestrial adaptation of basal ray finned fishes.	pubmed:33545088;pubmed:12470943		Zebrafish 008	strain:not collected\|isolate:not collected\|breed:not collected\|cultivar:not collected\|ecotype:not collected\|age:not collected\|dev stage:Adult\|sex:not determined\|tissue:Heart\|BioSampleModel:Model organism or animal	RNA Seq of Danio rerio : adult	CL100103178 L01	CL100103178 L01		RNA-Seq	TRANSCRIPTOMIC	RANDOM	PAIRED	BGISEQ	BGISEQ-500		SRP241982	CL100103178_L01_571_2.fq.gz CL100103178_L01_571_1.fq.gz	fastq fastq	8778390800.0	87783908.0	CL100103178 L01 571 1.fq.gz	0:100 1:100	A:2364575734;C:1991773326;G:2031934839;T:2379995507;N:10111394	100	100	2364575734	1991773326	2031934839	2379995507	10111394	SRX7564593	SRS6001804	SRA1026516	BGI\|BGI-Research	BGI	1	0.92192		0.08454		0.7544		0.53692		100		B		usable mapping rate	bgi	bgi	unknown	random_priming	unknown	bulk	unknown	unknown	China	2020-01-15	Adult	Adult	Heart	Cardiovascular 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");;