metadata: run_metadata: 9 rows where experiment.library_source = "TRANSCRIPTOMIC", experiment.platform = "VELA

9 rows where experiment.library_source = "TRANSCRIPTOMIC", experiment.platform = "VELA_DIAGNOSTICS" and technology = "unknown"

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.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
30611	30611	SRR27899041	SRX23559293	SRS20405500	SRP488601	PRJNA1073976	Transcriptome sequencing of zebrafish	PRJNA1073976	Other	This study utilized transcriptome sequencing technology to investigate the immunomodulatory effect of Lactobacillus gasseri LGV03 on zebrafish.	Zebrafish	Zebrafish	strain:AB\|isolate:Zebrafish\|breed:animals\|cultivar:not applicable\|ecotype:not applicable\|age:7 day\|dev stage:7 day\|collection date:2023 08 21\|geo loc name:China: Guangzhou\|sex:not applicable\|tissue:whole zebrafish\|BioSampleModel:Model organism or animal	RNA Seq of 7 dpf zebrafish	M3	M3	ployA enrichment mRNA fragmentation First strand cDNA synthesis magnetic bead purification of one strand second strand cDNA synthesis strand end repair addition of A at the 3 'end addition of splice Purification and library amplification Sequencing sample library construction completed	RNA-Seq	TRANSCRIPTOMIC	cDNA_randomPriming	PAIRED	VELA_DIAGNOSTICS	Sentosa SQ301	SRP488601	M3_QN202308290926_S33_L006_R1_001.fastq.gz M3_QN202308290926_S33_L006_R2_001.fastq.gz	fastq fastq	5459385900.0	18197953.0	M3 QN202308290926 S33 L006 R1 001.fastq.gz	0:150 1:150	A:1436510558;C:1285969737;G:1307232876;T:1429316327;N:356402	150	150	1436510558	1285969737	1307232876	1429316327	356402	SRX23559293	SRS20405500	SRA1798922	The Seventh Affiliated Hospital Of Southern Medical University\|Department of Laboratory Medicine	The Seventh Affiliated Hospital Of Southern Medical University	B	B	biological fallback assumption	legacy	early	unknown	random_priming	unknown	bulk	unknown	unknown	China	2024-02-07	Larval	Larval	Whole Organism	All anatomical structures
30612	30612	SRR27899042	SRX23559292	SRS20405500	SRP488601	PRJNA1073976	Transcriptome sequencing of zebrafish	PRJNA1073976	Other	This study utilized transcriptome sequencing technology to investigate the immunomodulatory effect of Lactobacillus gasseri LGV03 on zebrafish.	Zebrafish	Zebrafish	strain:AB\|isolate:Zebrafish\|breed:animals\|cultivar:not applicable\|ecotype:not applicable\|age:7 day\|dev stage:7 day\|collection date:2023 08 21\|geo loc name:China: Guangzhou\|sex:not applicable\|tissue:whole zebrafish\|BioSampleModel:Model organism or animal	RNA Seq of 7 dpf zebrafish	M2	M2	ployA enrichment mRNA fragmentation First strand cDNA synthesis magnetic bead purification of one strand second strand cDNA synthesis strand end repair addition of A at the 3 'end addition of splice Purification and library amplification Sequencing sample library construction completed	RNA-Seq	TRANSCRIPTOMIC	cDNA_randomPriming	PAIRED	VELA_DIAGNOSTICS	Sentosa SQ301	SRP488601	M2_QN202308290926_S32_L006_R1_001.fastq.gz M2_QN202308290926_S32_L006_R2_001.fastq.gz	fastq fastq	5650189800.0	18833966.0	M2 QN202308290926 S32 L006 R1 001.fastq.gz	0:150 1:150	A:1497095888;C:1322054602;G:1339271288;T:1491392152;N:375870	150	150	1497095888	1322054602	1339271288	1491392152	375870	SRX23559292	SRS20405500	SRA1798922	The Seventh Affiliated Hospital Of Southern Medical University\|Department of Laboratory Medicine	The Seventh Affiliated Hospital Of Southern Medical University	B	B	biological fallback assumption	legacy	early	unknown	random_priming	unknown	bulk	unknown	unknown	China	2024-02-07	Larval	Larval	Whole Organism	All anatomical structures
30613	30613	SRR27899043	SRX23559291	SRS20405500	SRP488601	PRJNA1073976	Transcriptome sequencing of zebrafish	PRJNA1073976	Other	This study utilized transcriptome sequencing technology to investigate the immunomodulatory effect of Lactobacillus gasseri LGV03 on zebrafish.	Zebrafish	Zebrafish	strain:AB\|isolate:Zebrafish\|breed:animals\|cultivar:not applicable\|ecotype:not applicable\|age:7 day\|dev stage:7 day\|collection date:2023 08 21\|geo loc name:China: Guangzhou\|sex:not applicable\|tissue:whole zebrafish\|BioSampleModel:Model organism or animal	RNA Seq of 7 dpf zebrafish	M1	M1	ployA enrichment mRNA fragmentation First strand cDNA synthesis magnetic bead purification of one strand second strand cDNA synthesis strand end repair addition of A at the 3 'end addition of splice Purification and library amplification Sequencing sample library construction completed	RNA-Seq	TRANSCRIPTOMIC	cDNA_randomPriming	PAIRED	VELA_DIAGNOSTICS	Sentosa SQ301	SRP488601	M1_QN202308290926_S31_L006_R1_001.fastq.gz M1_QN202308290926_S31_L006_R2_001.fastq.gz	fastq fastq	5939011200.0	19796704.0	M1 QN202308290926 S31 L006 R1 001.fastq.gz	0:150 1:150	A:1545732755;C:1425193066;G:1428641258;T:1539050226;N:393895	150	150	1545732755	1425193066	1428641258	1539050226	393895	SRX23559291	SRS20405500	SRA1798922	The Seventh Affiliated Hospital Of Southern Medical University\|Department of Laboratory Medicine	The Seventh Affiliated Hospital Of Southern Medical University	B	B	biological fallback assumption	legacy	early	unknown	random_priming	unknown	bulk	unknown	unknown	China	2024-02-07	Larval	Larval	Whole Organism	All anatomical structures
30614	30614	SRR27899044	SRX23559290	SRS20405500	SRP488601	PRJNA1073976	Transcriptome sequencing of zebrafish	PRJNA1073976	Other	This study utilized transcriptome sequencing technology to investigate the immunomodulatory effect of Lactobacillus gasseri LGV03 on zebrafish.	Zebrafish	Zebrafish	strain:AB\|isolate:Zebrafish\|breed:animals\|cultivar:not applicable\|ecotype:not applicable\|age:7 day\|dev stage:7 day\|collection date:2023 08 21\|geo loc name:China: Guangzhou\|sex:not applicable\|tissue:whole zebrafish\|BioSampleModel:Model organism or animal	RNA Seq of 7 dpf zebrafish	B3	B3	ployA enrichment mRNA fragmentation First strand cDNA synthesis magnetic bead purification of one strand second strand cDNA synthesis strand end repair addition of A at the 3 'end addition of splice Purification and library amplification Sequencing sample library construction completed	RNA-Seq	TRANSCRIPTOMIC	cDNA_randomPriming	PAIRED	VELA_DIAGNOSTICS	Sentosa SQ301	SRP488601	B3_QN202308290926_S30_L006_R1_001.fastq.gz B3_QN202308290926_S30_L006_R2_001.fastq.gz	fastq fastq	5798168100.0	19327227.0	B3 QN202308290926 S30 L006 R1 001.fastq.gz	0:150 1:150	A:1523711096;C:1370345137;G:1386721981;T:1517002959;N:386927	150	150	1523711096	1370345137	1386721981	1517002959	386927	SRX23559290	SRS20405500	SRA1798922	The Seventh Affiliated Hospital Of Southern Medical University\|Department of Laboratory Medicine	The Seventh Affiliated Hospital Of Southern Medical University	B	B	biological fallback assumption	legacy	early	unknown	random_priming	unknown	bulk	unknown	unknown	China	2024-02-07	Larval	Larval	Whole Organism	All anatomical structures
30615	30615	SRR27899045	SRX23559289	SRS20405500	SRP488601	PRJNA1073976	Transcriptome sequencing of zebrafish	PRJNA1073976	Other	This study utilized transcriptome sequencing technology to investigate the immunomodulatory effect of Lactobacillus gasseri LGV03 on zebrafish.	Zebrafish	Zebrafish	strain:AB\|isolate:Zebrafish\|breed:animals\|cultivar:not applicable\|ecotype:not applicable\|age:7 day\|dev stage:7 day\|collection date:2023 08 21\|geo loc name:China: Guangzhou\|sex:not applicable\|tissue:whole zebrafish\|BioSampleModel:Model organism or animal	RNA Seq of 7 dpf zebrafish	B2	B2	ployA enrichment mRNA fragmentation First strand cDNA synthesis magnetic bead purification of one strand second strand cDNA synthesis strand end repair addition of A at the 3 'end addition of splice Purification and library amplification Sequencing sample library construction completed	RNA-Seq	TRANSCRIPTOMIC	cDNA_randomPriming	PAIRED	VELA_DIAGNOSTICS	Sentosa SQ301	SRP488601	B2_QN202308290926_S29_L006_R1_001.fastq.gz B2_QN202308290926_S29_L006_R2_001.fastq.gz	fastq fastq	5863484400.0	19544948.0	B2 QN202308290926 S29 L006 R1 001.fastq.gz	0:150 1:150	A:1534634834;C:1394273573;G:1406495277;T:1527691926;N:388790	150	150	1534634834	1394273573	1406495277	1527691926	388790	SRX23559289	SRS20405500	SRA1798922	The Seventh Affiliated Hospital Of Southern Medical University\|Department of Laboratory Medicine	The Seventh Affiliated Hospital Of Southern Medical University	B	B	biological fallback assumption	legacy	early	unknown	random_priming	unknown	bulk	unknown	unknown	China	2024-02-07	Larval	Larval	Whole Organism	All anatomical structures
30616	30616	SRR27899046	SRX23559288	SRS20405500	SRP488601	PRJNA1073976	Transcriptome sequencing of zebrafish	PRJNA1073976	Other	This study utilized transcriptome sequencing technology to investigate the immunomodulatory effect of Lactobacillus gasseri LGV03 on zebrafish.	Zebrafish	Zebrafish	strain:AB\|isolate:Zebrafish\|breed:animals\|cultivar:not applicable\|ecotype:not applicable\|age:7 day\|dev stage:7 day\|collection date:2023 08 21\|geo loc name:China: Guangzhou\|sex:not applicable\|tissue:whole zebrafish\|BioSampleModel:Model organism or animal	RNA Seq of 7 dpf zebrafish	B1	B1	ployA enrichment mRNA fragmentation First strand cDNA synthesis magnetic bead purification of one strand second strand cDNA synthesis strand end repair addition of A at the 3 'end addition of splice Purification and library amplification Sequencing sample library construction completed	RNA-Seq	TRANSCRIPTOMIC	cDNA_randomPriming	PAIRED	VELA_DIAGNOSTICS	Sentosa SQ301	SRP488601	B1_QN202308290926_S28_L006_R1_001.fastq.gz B1_QN202308290926_S28_L006_R2_001.fastq.gz	fastq fastq	6041746500.0	20139155.0	B1 QN202308290926 S28 L006 R1 001.fastq.gz	0:150 1:150	A:1585824243;C:1429955080;G:1445995253;T:1579566974;N:404950	150	150	1585824243	1429955080	1445995253	1579566974	404950	SRX23559288	SRS20405500	SRA1798922	The Seventh Affiliated Hospital Of Southern Medical University\|Department of Laboratory Medicine	The Seventh Affiliated Hospital Of Southern Medical University	B	B	biological fallback assumption	legacy	early	unknown	random_priming	unknown	bulk	unknown	unknown	China	2024-02-07	Larval	Larval	Whole Organism	All anatomical structures
30617	30617	SRR27899047	SRX23559287	SRS20405500	SRP488601	PRJNA1073976	Transcriptome sequencing of zebrafish	PRJNA1073976	Other	This study utilized transcriptome sequencing technology to investigate the immunomodulatory effect of Lactobacillus gasseri LGV03 on zebrafish.	Zebrafish	Zebrafish	strain:AB\|isolate:Zebrafish\|breed:animals\|cultivar:not applicable\|ecotype:not applicable\|age:7 day\|dev stage:7 day\|collection date:2023 08 21\|geo loc name:China: Guangzhou\|sex:not applicable\|tissue:whole zebrafish\|BioSampleModel:Model organism or animal	RNA Seq of 7 dpf zebrafish	C3	C3	ployA enrichment mRNA fragmentation First strand cDNA synthesis magnetic bead purification of one strand second strand cDNA synthesis strand end repair addition of A at the 3 'end addition of splice Purification and library amplification Sequencing sample library construction completed	RNA-Seq	TRANSCRIPTOMIC	cDNA_randomPriming	PAIRED	VELA_DIAGNOSTICS	Sentosa SQ301	SRP488601	C3_QN202308290926_S27_L006_R1_001.fastq.gz C3_QN202308290926_S27_L006_R2_001.fastq.gz	fastq fastq	6065066400.0	20216888.0	C3 QN202308290926 S27 L006 R1 001.fastq.gz	0:150 1:150	A:1594983080;C:1430417950;G:1449159595;T:1590101910;N:403865	150	150	1594983080	1430417950	1449159595	1590101910	403865	SRX23559287	SRS20405500	SRA1798922	The Seventh Affiliated Hospital Of Southern Medical University\|Department of Laboratory Medicine	The Seventh Affiliated Hospital Of Southern Medical University	B	B	biological fallback assumption	legacy	early	unknown	random_priming	unknown	bulk	unknown	unknown	China	2024-02-07	Larval	Larval	Whole Organism	All anatomical structures
30618	30618	SRR27899048	SRX23559286	SRS20405500	SRP488601	PRJNA1073976	Transcriptome sequencing of zebrafish	PRJNA1073976	Other	This study utilized transcriptome sequencing technology to investigate the immunomodulatory effect of Lactobacillus gasseri LGV03 on zebrafish.	Zebrafish	Zebrafish	strain:AB\|isolate:Zebrafish\|breed:animals\|cultivar:not applicable\|ecotype:not applicable\|age:7 day\|dev stage:7 day\|collection date:2023 08 21\|geo loc name:China: Guangzhou\|sex:not applicable\|tissue:whole zebrafish\|BioSampleModel:Model organism or animal	RNA Seq of 7 dpf zebrafish	C2	C2	ployA enrichment mRNA fragmentation First strand cDNA synthesis magnetic bead purification of one strand second strand cDNA synthesis strand end repair addition of A at the 3 'end addition of splice Purification and library amplification Sequencing sample library construction completed	RNA-Seq	TRANSCRIPTOMIC	cDNA_randomPriming	PAIRED	VELA_DIAGNOSTICS	Sentosa SQ301	SRP488601	C2_QN202308290926_S26_L006_R1_001.fastq.gz C2_QN202308290926_S26_L006_R2_001.fastq.gz	fastq fastq	5689528200.0	18965094.0	C2 QN202308290926 S26 L006 R1 001.fastq.gz	0:150 1:150	A:1489096177;C:1343812970;G:1370219696;T:1486021320;N:378037	150	150	1489096177	1343812970	1370219696	1486021320	378037	SRX23559286	SRS20405500	SRA1798922	The Seventh Affiliated Hospital Of Southern Medical University\|Department of Laboratory Medicine	The Seventh Affiliated Hospital Of Southern Medical University	B	B	biological fallback assumption	legacy	early	unknown	random_priming	unknown	bulk	unknown	unknown	China	2024-02-07	Larval	Larval	Whole Organism	All anatomical structures
30619	30619	SRR27899049	SRX23559285	SRS20405500	SRP488601	PRJNA1073976	Transcriptome sequencing of zebrafish	PRJNA1073976	Other	This study utilized transcriptome sequencing technology to investigate the immunomodulatory effect of Lactobacillus gasseri LGV03 on zebrafish.	Zebrafish	Zebrafish	strain:AB\|isolate:Zebrafish\|breed:animals\|cultivar:not applicable\|ecotype:not applicable\|age:7 day\|dev stage:7 day\|collection date:2023 08 21\|geo loc name:China: Guangzhou\|sex:not applicable\|tissue:whole zebrafish\|BioSampleModel:Model organism or animal	RNA Seq of 7 dpf zebrafish	C1	C1	ployA enrichment mRNA fragmentation First strand cDNA synthesis magnetic bead purification of one strand second strand cDNA synthesis strand end repair addition of A at the 3 'end addition of splice Purification and library amplification Sequencing sample library construction completed	RNA-Seq	TRANSCRIPTOMIC	cDNA_randomPriming	PAIRED	VELA_DIAGNOSTICS	Sentosa SQ301	SRP488601	C1_QN202308290926_S25_L006_R1_001.fastq.gz C1_QN202308290926_S25_L006_R2_001.fastq.gz	fastq fastq	5998914900.0	19996383.0	C1 QN202308290926 S25 L006 R1 001.fastq.gz	0:150 1:150	A:1558078274;C:1434298148;G:1451514838;T:1554627854;N:395786	150	150	1558078274	1434298148	1451514838	1554627854	395786	SRX23559285	SRS20405500	SRA1798922	The Seventh Affiliated Hospital Of Southern Medical University\|Department of Laboratory Medicine	The Seventh Affiliated Hospital Of Southern Medical University	B	B	biological fallback assumption	legacy	early	unknown	random_priming	unknown	bulk	unknown	unknown	China	2024-02-07	Larval	Larval	Whole Organism	All anatomical structures

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