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

5 rows where experiment.library_selection = "RANDOM", experiment.library_strategy = "RNA-Seq" and tissue_curation = "Swim Bladder"

descending

Link	rowid ▼	run.accession	experiment.accession	sample.accession	study.accession	bioproject	study.title	study.alias	study.type	study.abstract	study.PMIDs	sample.alias	sample.attributes	experiment.title	experiment.alias	experiment.library_name	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.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
55997	55997	SRR10895904	SRX7564575	SRS6001799	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 004	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:Swim bladder\|BioSampleModel:Model organism or animal	RNA Seq of Danio rerio : adult	CL100103858 L02 9	CL100103858 L02 9	RNA-Seq	TRANSCRIPTOMIC	RANDOM	PAIRED	BGISEQ	BGISEQ-500	SRP241982	CL100103858_L02_527_2.fq.gz CL100103858_L02_527_1.fq.gz	fastq fastq	9389292400.0	93892924.0	CL100103858 L02 527 1.fq.gz	0:100 1:100	A:2535177343;C:2107498353;G:2159172216;T:2574271698;N:13172790	100	100	2535177343	2107498353	2159172216	2574271698	13172790	SRX7564575	SRS6001799	SRA1026516	BGI\|BGI-Research	BGI	1	0.94054	0.10829	0.70818	0.51214	100	B	usable mapping rate	bgi	bgi	unknown	random_priming	unknown	bulk	unknown	unknown	China	2020-01-15	Adult	Adult	Swim Bladder	Swim Bladder
55998	55998	SRR10895905	SRX7564574	SRS6001799	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 004	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:Swim bladder\|BioSampleModel:Model organism or animal	RNA Seq of Danio rerio : adult	CL100103178 L02 9	CL100103178 L02 9	RNA-Seq	TRANSCRIPTOMIC	RANDOM	PAIRED	BGISEQ	BGISEQ-500	SRP241982	CL100103178_L02_580_2.fq.gz CL100103178_L02_580_1.fq.gz	fastq fastq	9451878800.0	94518788.0	CL100103178 L02 580 1.fq.gz	0:100 1:100	A:2482432185;C:2200816673;G:2254475373;T:2504225593;N:9928976	100	100	2482432185	2200816673	2254475373	2504225593	9928976	SRX7564574	SRS6001799	SRA1026516	BGI\|BGI-Research	BGI	1	0.91363	0.08854	0.67399	0.52315	100	B	usable mapping rate	bgi	bgi	unknown	random_priming	unknown	bulk	unknown	unknown	China	2020-01-15	Adult	Adult	Swim Bladder	Swim Bladder
55999	55999	SRR10895906	SRX7564573	SRS6001799	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 004	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:Swim bladder\|BioSampleModel:Model organism or animal	RNA Seq of Danio rerio : adult	CL100103178 L02 8	CL100103178 L02 8	RNA-Seq	TRANSCRIPTOMIC	RANDOM	PAIRED	BGISEQ	BGISEQ-500	SRP241982	CL100103178_L02_579_1.fq.gz CL100103178_L02_579_2.fq.gz	fastq fastq	6784370200.0	67843702.0	CL100103178 L02 579 1.fq.gz	0:100 1:100	A:1799307225;C:1565118646;G:1599826091;T:1813320759;N:6797479	100	100	1799307225	1565118646	1599826091	1813320759	6797479	SRX7564573	SRS6001799	SRA1026516	BGI\|BGI-Research	BGI	1	0.91866	0.10227	0.71928	0.50827	100	B	usable mapping rate	bgi	bgi	unknown	random_priming	unknown	bulk	unknown	unknown	China	2020-01-15	Adult	Adult	Swim Bladder	Swim Bladder
56000	56000	SRR10895907	SRX7564572	SRS6001799	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 004	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:Swim bladder\|BioSampleModel:Model organism or animal	RNA Seq of Danio rerio : adult	CL100103858 L02 8	CL100103858 L02 8	RNA-Seq	TRANSCRIPTOMIC	RANDOM	PAIRED	BGISEQ	BGISEQ-500	SRP241982	CL100103858_L02_529_2.fq.gz CL100103858_L02_529_1.fq.gz	fastq fastq	10614517200.0	106145172.0	CL100103858 L02 529 1.fq.gz	0:100 1:100	A:2821297968;C:2430515408;G:2486443963;T:2861653662;N:14606199	100	100	2821297968	2430515408	2486443963	2861653662	14606199	SRX7564572	SRS6001799	SRA1026516	BGI\|BGI-Research	BGI	1	0.94747	0.08863	0.64632	0.50637	100	B	usable mapping rate	bgi	bgi	unknown	random_priming	unknown	bulk	unknown	unknown	China	2020-01-15	Adult	Adult	Swim Bladder	Swim Bladder
56001	56001	SRR10895908	SRX7564571	SRS6001799	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 004	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:Swim bladder\|BioSampleModel:Model organism or animal	RNA Seq of Danio rerio : adult	CL100103858 L02 7	CL100103858 L02 7	RNA-Seq	TRANSCRIPTOMIC	RANDOM	PAIRED	BGISEQ	BGISEQ-500	SRP241982	CL100103858_L02_526_2.fq.gz CL100103858_L02_526_1.fq.gz	fastq fastq	8829000400.0	88290004.0	CL100103858 L02 526 1.fq.gz	0:100 1:100	A:2346419057;C:2025176439;G:2073455037;T:2371666164;N:12283703	100	100	2346419057	2025176439	2073455037	2371666164	12283703	SRX7564571	SRS6001799	SRA1026516	BGI\|BGI-Research	BGI	1	0.93744	0.08552	0.70918	0.49156	100	B	usable mapping rate	bgi	bgi	unknown	random_priming	unknown	bulk	unknown	unknown	China	2020-01-15	Adult	Adult	Swim Bladder	Swim Bladder

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