run_metadata
8 rows where experiment.library_source = "METATRANSCRIPTOMIC" and experiment.platform = "DNBSEQ"
This data as json, CSV (advanced)
| Link | rowid ▼ | run.accession | experiment.accession | sample.accession | study.accession | bioproject | study.title | study.alias | study.type | study.abstract | study.attributes | study.PMIDs | sample.description | sample.title | sample.alias | sample.centername | sample.attributes | GEOsample.title | GEOsample.dataprocessing | GEOsample.source | GEOsample.treatmentprotocol | GEOsample.extractprotocol | GEOsample.growthprotocol | GEOsample.characteristics | GEOsample.accession | experiment.title | experiment.alias | experiment.library_name | 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.spot_descriptor | experiment.study_ref | run.title | run.attributes | 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.r3_length | run.r4_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 | tech_variant | submission.bioprojectsource.country | earliest_date | devstage_curation | devstage_curation_coarse | tissue_curation | tissue_curation_coarse |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 35452 | 35452 | SRR32815440 | SRX28098911 | SRS24455832 | SRP572346 | PRJNA1240620 | The mechanism of maternal inheritance of glycolipid metabolism disorder in a zebrafish model of type 2 diabetes | PRJNA1240620 | Other | T4Danio rerio | strain:T4|age:96hpf|collection date:2023 12 20|geo loc name:China: Xiangyang|sex:missing|tissue:Tissue of juvenile fish|replicate:T4|BioSampleModel:Model organism or animal | T4 | T4 | T4 | T4 | RNA-Seq | METATRANSCRIPTOMIC | cDNA | PAIRED | DNBSEQ | DNBSEQ-T7 | SRP572346 | T4_1.fq.gz T4_2.fq.gz | fastq fastq | 6608651700.0 | 22028839.0 | T4 1.fq.gz | 0:150 1:150 | A:1815401801;C:1489859310;G:1499379699;T:1804010890;N:0 | 150 | 150 | 1815401801 | 1489859310 | 1499379699 | 1804010890 | 0 | SRX28098911 | SRS24455832 | SRA2098321 | Wuhan University of Science and Technology|School of Medicine | Wuhan University of Science and Technology | B | B | biological fallback assumption | bgi | bgi | unknown | cdna_unspecified | unknown | bulk | unknown | unknown | China | 2025-03-22 | Larval | Larval | Undetermined | Undetermined | |||||||||||||||||||||||||||||||||
| 35453 | 35453 | SRR32815441 | SRX28098910 | SRS24455831 | SRP572346 | PRJNA1240620 | The mechanism of maternal inheritance of glycolipid metabolism disorder in a zebrafish model of type 2 diabetes | PRJNA1240620 | Other | T3Danio rerio | strain:T3|age:96hpf|collection date:2023 12 20|geo loc name:China: Xiangyang|sex:missing|tissue:Tissue of juvenile fish|replicate:T3|BioSampleModel:Model organism or animal | T3 | T3 | T3 | T3 | RNA-Seq | METATRANSCRIPTOMIC | cDNA | PAIRED | DNBSEQ | DNBSEQ-T7 | SRP572346 | T3_1.fq.gz T3_2.fq.gz | fastq fastq | 6656167200.0 | 22187224.0 | T3 1.fq.gz | 0:150 1:150 | A:1840552276;C:1489247530;G:1499297584;T:1827069810;N:0 | 150 | 150 | 1840552276 | 1489247530 | 1499297584 | 1827069810 | 0 | SRX28098910 | SRS24455831 | SRA2098321 | Wuhan University of Science and Technology|School of Medicine | Wuhan University of Science and Technology | B | B | biological fallback assumption | bgi | bgi | unknown | cdna_unspecified | unknown | bulk | unknown | unknown | China | 2025-03-22 | Larval | Larval | Undetermined | Undetermined | |||||||||||||||||||||||||||||||||
| 35454 | 35454 | SRR32815442 | SRX28098909 | SRS24455830 | SRP572346 | PRJNA1240620 | The mechanism of maternal inheritance of glycolipid metabolism disorder in a zebrafish model of type 2 diabetes | PRJNA1240620 | Other | T2Danio rerio | strain:T2|age:96hpf|collection date:2023 12 20|geo loc name:China: Xiangyang|sex:missing|tissue:Tissue of juvenile fish|replicate:T2|BioSampleModel:Model organism or animal | T2 | T2 | T2 | T2 | RNA-Seq | METATRANSCRIPTOMIC | cDNA | PAIRED | DNBSEQ | DNBSEQ-T7 | SRP572346 | T2_1.fq.gz T2_2.fq.gz | fastq fastq | 6622204800.0 | 22074016.0 | T2 1.fq.gz | 0:150 1:150 | A:1834396150;C:1480094606;G:1490046882;T:1817667162;N:0 | 150 | 150 | 1834396150 | 1480094606 | 1490046882 | 1817667162 | 0 | SRX28098909 | SRS24455830 | SRA2098321 | Wuhan University of Science and Technology|School of Medicine | Wuhan University of Science and Technology | B | B | biological fallback assumption | bgi | bgi | unknown | cdna_unspecified | unknown | bulk | unknown | unknown | China | 2025-03-22 | Larval | Larval | Undetermined | Undetermined | |||||||||||||||||||||||||||||||||
| 35455 | 35455 | SRR32815443 | SRX28098908 | SRS24455829 | SRP572346 | PRJNA1240620 | The mechanism of maternal inheritance of glycolipid metabolism disorder in a zebrafish model of type 2 diabetes | PRJNA1240620 | Other | T1Danio rerio | strain:T1|age:96hpf|collection date:2023 12 20|geo loc name:China: Xiangyang|sex:missing|tissue:Tissue of juvenile fish|replicate:T1|BioSampleModel:Model organism or animal | T1 | T1 | T1 | T1 | RNA-Seq | METATRANSCRIPTOMIC | cDNA | PAIRED | DNBSEQ | DNBSEQ-T7 | SRP572346 | T1_1.fq.gz T1_2.fq.gz | fastq fastq | 6626122500.0 | 22087075.0 | T1 1.fq.gz | 0:150 1:150 | A:1833541012;C:1481665295;G:1491851279;T:1819064914;N:0 | 150 | 150 | 1833541012 | 1481665295 | 1491851279 | 1819064914 | 0 | SRX28098908 | SRS24455829 | SRA2098321 | Wuhan University of Science and Technology|School of Medicine | Wuhan University of Science and Technology | B | B | biological fallback assumption | bgi | bgi | unknown | cdna_unspecified | unknown | bulk | unknown | unknown | China | 2025-03-22 | Larval | Larval | Undetermined | Undetermined | |||||||||||||||||||||||||||||||||
| 35456 | 35456 | SRR32815444 | SRX28098907 | SRS24455828 | SRP572346 | PRJNA1240620 | The mechanism of maternal inheritance of glycolipid metabolism disorder in a zebrafish model of type 2 diabetes | PRJNA1240620 | Other | Q4Danio rerio | strain:Q4|age:96hpf|collection date:2023 12 20|geo loc name:China: Xiangyang|sex:missing|tissue:Tissue of juvenile fish|replicate:Q4|BioSampleModel:Model organism or animal | Q4 | Q4 | Q4 | Q4 | RNA-Seq | METATRANSCRIPTOMIC | cDNA | PAIRED | DNBSEQ | DNBSEQ-T7 | SRP572346 | Q4_1.fq.gz Q4_2.fq.gz | fastq fastq | 6646083600.0 | 22153612.0 | Q4 1.fq.gz | 0:150 1:150 | A:1823086981;C:1499930776;G:1510718905;T:1812346938;N:0 | 150 | 150 | 1823086981 | 1499930776 | 1510718905 | 1812346938 | 0 | SRX28098907 | SRS24455828 | SRA2098321 | Wuhan University of Science and Technology|School of Medicine | Wuhan University of Science and Technology | B | B | biological fallback assumption | bgi | bgi | unknown | cdna_unspecified | unknown | bulk | unknown | unknown | China | 2025-03-22 | Larval | Larval | Undetermined | Undetermined | |||||||||||||||||||||||||||||||||
| 35457 | 35457 | SRR32815445 | SRX28098906 | SRS24455827 | SRP572346 | PRJNA1240620 | The mechanism of maternal inheritance of glycolipid metabolism disorder in a zebrafish model of type 2 diabetes | PRJNA1240620 | Other | Q3Danio rerio | strain:Q3|age:96hpf|collection date:2023 12 20|geo loc name:China: Xiangyang|sex:missing|tissue:Tissue of juvenile fish|replicate:Q3|BioSampleModel:Model organism or animal | Q3 | Q3 | Q3 | Q3 | RNA-Seq | METATRANSCRIPTOMIC | cDNA | PAIRED | DNBSEQ | DNBSEQ-T7 | SRP572346 | Q3_1.fq.gz Q3_2.fq.gz | fastq fastq | 6683275200.0 | 22277584.0 | Q3 1.fq.gz | 0:150 1:150 | A:1838068171;C:1503920885;G:1514577234;T:1826708910;N:0 | 150 | 150 | 1838068171 | 1503920885 | 1514577234 | 1826708910 | 0 | SRX28098906 | SRS24455827 | SRA2098321 | Wuhan University of Science and Technology|School of Medicine | Wuhan University of Science and Technology | B | B | biological fallback assumption | bgi | bgi | unknown | cdna_unspecified | unknown | bulk | unknown | unknown | China | 2025-03-22 | Larval | Larval | Undetermined | Undetermined | |||||||||||||||||||||||||||||||||
| 35458 | 35458 | SRR32815446 | SRX28098905 | SRS24455826 | SRP572346 | PRJNA1240620 | The mechanism of maternal inheritance of glycolipid metabolism disorder in a zebrafish model of type 2 diabetes | PRJNA1240620 | Other | Q2Danio rerio | strain:Q2|age:96hpf|collection date:2023 12 20|geo loc name:China: Xiangyang|sex:missing|tissue:Tissue of juvenile fish|replicate:Q2|BioSampleModel:Model organism or animal | Q2 | Q2 | Q2 | Q2 | RNA-Seq | METATRANSCRIPTOMIC | cDNA | PAIRED | DNBSEQ | DNBSEQ-T7 | SRP572346 | Q2_1.fq.gz Q2_2.fq.gz | fastq fastq | 6612253800.0 | 22040846.0 | Q2 1.fq.gz | 0:150 1:150 | A:1821750297;C:1484945478;G:1495582042;T:1809975983;N:0 | 150 | 150 | 1821750297 | 1484945478 | 1495582042 | 1809975983 | 0 | SRX28098905 | SRS24455826 | SRA2098321 | Wuhan University of Science and Technology|School of Medicine | Wuhan University of Science and Technology | B | B | biological fallback assumption | bgi | bgi | unknown | cdna_unspecified | unknown | bulk | unknown | unknown | China | 2025-03-22 | Larval | Larval | Undetermined | Undetermined | |||||||||||||||||||||||||||||||||
| 35459 | 35459 | SRR32815447 | SRX28098904 | SRS24455825 | SRP572346 | PRJNA1240620 | The mechanism of maternal inheritance of glycolipid metabolism disorder in a zebrafish model of type 2 diabetes | PRJNA1240620 | Other | Q1Danio rerio | strain:Q1|age:96hpf|collection date:2023 12 20|geo loc name:China: Xiangyang|sex:missing|tissue:Tissue of juvenile fish|replicate:Q1|BioSampleModel:Model organism or animal | Q1 | Q1 | Q1 | Q1 | RNA-Seq | METATRANSCRIPTOMIC | cDNA | PAIRED | DNBSEQ | DNBSEQ-T7 | SRP572346 | Q1_1.fq.gz Q1_2.fq.gz | fastq fastq | 6725919900.0 | 22419733.0 | Q1 1.fq.gz | 0:150 1:150 | A:1845653740;C:1518697545;G:1530630124;T:1830938491;N:0 | 150 | 150 | 1845653740 | 1518697545 | 1530630124 | 1830938491 | 0 | SRX28098904 | SRS24455825 | SRA2098321 | Wuhan University of Science and Technology|School of Medicine | Wuhan University of Science and Technology | B | B | biological fallback assumption | bgi | bgi | unknown | cdna_unspecified | unknown | bulk | unknown | unknown | China | 2025-03-22 | Larval | Larval | Undetermined | Undetermined |
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");;