run_metadata
9 rows where experiment.library_selection = "PolyA", experiment.platform = "DNBSEQ" and tissue_curation = "Trunk"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 36227 | 36227 | SRR33613672 | SRX28842027 | SRS25072222 | SRP586119 | PRJNA1263917 | Danio rerio Transcriptome or Gene expression | PRJNA1263917 | Other | Analyze the effect of TB KW fermentation on gene expression in high lipid zebrafish. | Danio rerio | Danio rerio | strain:missing|isolate:missing|breed:missing|cultivar:missing|ecotype:missing|age:7 day|dev stage:Juvenile fish|collection date:2024 04 16|geo loc name:China: Hang Zhou|sex:missing|tissue:Whole body|BioSampleModel:Model organism or animal | RNA seq of Danio rerio | HFD 3 | HFD 3 | Total RNA was extracted digested with DNase I and mRNA enriched. post fragmentation cDNA synthesis and library construction the final single stranded DNA nanoball library was generated for sequencing via rolling circle replication. | RNA-Seq | TRANSCRIPTOMIC | PolyA | PAIRED | DNBSEQ | DNBSEQ-T7 | SRP586119 | HFD-3-1.fq.gz HFD-3-2.fq.gz | fastq fastq | 6810755100.0 | 22702517.0 | HFD 3 1.fq.gz | 0:150 1:150 | A:1804127778;C:1596175018;G:1609090701;T:1801361603;N:0 | 150 | 150 | 1804127778 | 1596175018 | 1609090701 | 1801361603 | 0 | SRX28842027 | SRS25072222 | SRA2131918 | Yibin University|Faculty of Quality Management and Inspection & Qua | Yibin University | B | B | biological fallback assumption | bgi | bgi | unknown | poly_a | unknown | bulk | unknown | unknown | China | 2025-05-18 | Multi-stage | Multi-stage | Trunk | Surface Structure | |||||||||||||||||||||||||||||||
| 36228 | 36228 | SRR33613673 | SRX28842026 | SRS25072222 | SRP586119 | PRJNA1263917 | Danio rerio Transcriptome or Gene expression | PRJNA1263917 | Other | Analyze the effect of TB KW fermentation on gene expression in high lipid zebrafish. | Danio rerio | Danio rerio | strain:missing|isolate:missing|breed:missing|cultivar:missing|ecotype:missing|age:7 day|dev stage:Juvenile fish|collection date:2024 04 16|geo loc name:China: Hang Zhou|sex:missing|tissue:Whole body|BioSampleModel:Model organism or animal | RNA seq of Danio rerio | HFD 2 | HFD 2 | Total RNA was extracted digested with DNase I and mRNA enriched. post fragmentation cDNA synthesis and library construction the final single stranded DNA nanoball library was generated for sequencing via rolling circle replication. | RNA-Seq | TRANSCRIPTOMIC | PolyA | PAIRED | DNBSEQ | DNBSEQ-T7 | SRP586119 | HFD-2-1.fq.gz HFD-2-2.fq.gz | fastq fastq | 6826358400.0 | 22754528.0 | HFD 2 1.fq.gz | 0:150 1:150 | A:1826465185;C:1582322712;G:1596188986;T:1821381517;N:0 | 150 | 150 | 1826465185 | 1582322712 | 1596188986 | 1821381517 | 0 | SRX28842026 | SRS25072222 | SRA2131918 | Yibin University|Faculty of Quality Management and Inspection & Qua | Yibin University | B | B | biological fallback assumption | bgi | bgi | unknown | poly_a | unknown | bulk | unknown | unknown | China | 2025-05-18 | Multi-stage | Multi-stage | Trunk | Surface Structure | |||||||||||||||||||||||||||||||
| 36229 | 36229 | SRR33613674 | SRX28842025 | SRS25072222 | SRP586119 | PRJNA1263917 | Danio rerio Transcriptome or Gene expression | PRJNA1263917 | Other | Analyze the effect of TB KW fermentation on gene expression in high lipid zebrafish. | Danio rerio | Danio rerio | strain:missing|isolate:missing|breed:missing|cultivar:missing|ecotype:missing|age:7 day|dev stage:Juvenile fish|collection date:2024 04 16|geo loc name:China: Hang Zhou|sex:missing|tissue:Whole body|BioSampleModel:Model organism or animal | RNA seq of Danio rerio | HFD 1 | HFD 1 | Total RNA was extracted digested with DNase I and mRNA enriched. post fragmentation cDNA synthesis and library construction the final single stranded DNA nanoball library was generated for sequencing via rolling circle replication. | RNA-Seq | TRANSCRIPTOMIC | PolyA | PAIRED | DNBSEQ | DNBSEQ-T7 | SRP586119 | HFD-1-1.fq.gz HFD-1-2.fq.gz | fastq fastq | 6598410300.0 | 21994701.0 | HFD 1 1.fq.gz | 0:150 1:150 | A:1765905584;C:1529581410;G:1542056821;T:1760866485;N:0 | 150 | 150 | 1765905584 | 1529581410 | 1542056821 | 1760866485 | 0 | SRX28842025 | SRS25072222 | SRA2131918 | Yibin University|Faculty of Quality Management and Inspection & Qua | Yibin University | B | B | biological fallback assumption | bgi | bgi | unknown | poly_a | unknown | bulk | unknown | unknown | China | 2025-05-18 | Multi-stage | Multi-stage | Trunk | Surface Structure | |||||||||||||||||||||||||||||||
| 36230 | 36230 | SRR33613675 | SRX28842024 | SRS25072222 | SRP586119 | PRJNA1263917 | Danio rerio Transcriptome or Gene expression | PRJNA1263917 | Other | Analyze the effect of TB KW fermentation on gene expression in high lipid zebrafish. | Danio rerio | Danio rerio | strain:missing|isolate:missing|breed:missing|cultivar:missing|ecotype:missing|age:7 day|dev stage:Juvenile fish|collection date:2024 04 16|geo loc name:China: Hang Zhou|sex:missing|tissue:Whole body|BioSampleModel:Model organism or animal | RNA seq of Danio rerio | HFD10 3 | HFD10 3 | Total RNA was extracted digested with DNase I and mRNA enriched. post fragmentation cDNA synthesis and library construction the final single stranded DNA nanoball library was generated for sequencing via rolling circle replication. | RNA-Seq | TRANSCRIPTOMIC | PolyA | PAIRED | DNBSEQ | DNBSEQ-T7 | SRP586119 | HFD10-3-1.fq.gz HFD10-3-2.fq.gz | fastq fastq | 6609153300.0 | 22030511.0 | HFD10 3 1.fq.gz | 0:150 1:150 | A:1780787716;C:1521027085;G:1532800826;T:1774537673;N:0 | 150 | 150 | 1780787716 | 1521027085 | 1532800826 | 1774537673 | 0 | SRX28842024 | SRS25072222 | SRA2131918 | Yibin University|Faculty of Quality Management and Inspection & Qua | Yibin University | B | B | biological fallback assumption | bgi | bgi | unknown | poly_a | unknown | bulk | unknown | unknown | China | 2025-05-18 | Multi-stage | Multi-stage | Trunk | Surface Structure | |||||||||||||||||||||||||||||||
| 36231 | 36231 | SRR33613676 | SRX28842023 | SRS25072222 | SRP586119 | PRJNA1263917 | Danio rerio Transcriptome or Gene expression | PRJNA1263917 | Other | Analyze the effect of TB KW fermentation on gene expression in high lipid zebrafish. | Danio rerio | Danio rerio | strain:missing|isolate:missing|breed:missing|cultivar:missing|ecotype:missing|age:7 day|dev stage:Juvenile fish|collection date:2024 04 16|geo loc name:China: Hang Zhou|sex:missing|tissue:Whole body|BioSampleModel:Model organism or animal | RNA seq of Danio rerio | HFD10 2 | HFD10 2 | Total RNA was extracted digested with DNase I and mRNA enriched. post fragmentation cDNA synthesis and library construction the final single stranded DNA nanoball library was generated for sequencing via rolling circle replication. | RNA-Seq | TRANSCRIPTOMIC | PolyA | PAIRED | DNBSEQ | DNBSEQ-T7 | SRP586119 | HFD10-2-1.fq.gz HFD10-2-2.fq.gz | fastq fastq | 6605145900.0 | 22017153.0 | HFD10 2 1.fq.gz | 0:150 1:150 | A:1765731508;C:1533254667;G:1545960098;T:1760199627;N:0 | 150 | 150 | 1765731508 | 1533254667 | 1545960098 | 1760199627 | 0 | SRX28842023 | SRS25072222 | SRA2131918 | Yibin University|Faculty of Quality Management and Inspection & Qua | Yibin University | B | B | biological fallback assumption | bgi | bgi | unknown | poly_a | unknown | bulk | unknown | unknown | China | 2025-05-18 | Multi-stage | Multi-stage | Trunk | Surface Structure | |||||||||||||||||||||||||||||||
| 36232 | 36232 | SRR33613677 | SRX28842022 | SRS25072222 | SRP586119 | PRJNA1263917 | Danio rerio Transcriptome or Gene expression | PRJNA1263917 | Other | Analyze the effect of TB KW fermentation on gene expression in high lipid zebrafish. | Danio rerio | Danio rerio | strain:missing|isolate:missing|breed:missing|cultivar:missing|ecotype:missing|age:7 day|dev stage:Juvenile fish|collection date:2024 04 16|geo loc name:China: Hang Zhou|sex:missing|tissue:Whole body|BioSampleModel:Model organism or animal | RNA seq of Danio rerio | HFD10 1 | HFD10 1 | Total RNA was extracted digested with DNase I and mRNA enriched. post fragmentation cDNA synthesis and library construction the final single stranded DNA nanoball library was generated for sequencing via rolling circle replication. | RNA-Seq | TRANSCRIPTOMIC | PolyA | PAIRED | DNBSEQ | DNBSEQ-T7 | SRP586119 | HFD10-1-1.fq.gz HFD10-1-2.fq.gz | fastq fastq | 6780056700.0 | 22600189.0 | HFD10 1 1.fq.gz | 0:150 1:150 | A:1819443100;C:1566081115;G:1580525465;T:1814007020;N:0 | 150 | 150 | 1819443100 | 1566081115 | 1580525465 | 1814007020 | 0 | SRX28842022 | SRS25072222 | SRA2131918 | Yibin University|Faculty of Quality Management and Inspection & Qua | Yibin University | B | B | biological fallback assumption | bgi | bgi | unknown | poly_a | unknown | bulk | unknown | unknown | China | 2025-05-18 | Multi-stage | Multi-stage | Trunk | Surface Structure | |||||||||||||||||||||||||||||||
| 36233 | 36233 | SRR33613678 | SRX28842021 | SRS25072222 | SRP586119 | PRJNA1263917 | Danio rerio Transcriptome or Gene expression | PRJNA1263917 | Other | Analyze the effect of TB KW fermentation on gene expression in high lipid zebrafish. | Danio rerio | Danio rerio | strain:missing|isolate:missing|breed:missing|cultivar:missing|ecotype:missing|age:7 day|dev stage:Juvenile fish|collection date:2024 04 16|geo loc name:China: Hang Zhou|sex:missing|tissue:Whole body|BioSampleModel:Model organism or animal | RNA seq of Danio rerio | NFD 3 | NFD 3 | Total RNA was extracted digested with DNase I and mRNA enriched. post fragmentation cDNA synthesis and library construction the final single stranded DNA nanoball library was generated for sequencing via rolling circle replication. | RNA-Seq | TRANSCRIPTOMIC | PolyA | PAIRED | DNBSEQ | DNBSEQ-T7 | SRP586119 | NFD-3-1.fq.gz NFD-3-2.fq.gz | fastq fastq | 6677775900.0 | 22259253.0 | NFD 3 1.fq.gz | 0:150 1:150 | A:1794821611;C:1541478212;G:1552820105;T:1788655972;N:0 | 150 | 150 | 1794821611 | 1541478212 | 1552820105 | 1788655972 | 0 | SRX28842021 | SRS25072222 | SRA2131918 | Yibin University|Faculty of Quality Management and Inspection & Qua | Yibin University | B | B | biological fallback assumption | bgi | bgi | unknown | poly_a | unknown | bulk | unknown | unknown | China | 2025-05-18 | Multi-stage | Multi-stage | Trunk | Surface Structure | |||||||||||||||||||||||||||||||
| 36234 | 36234 | SRR33613679 | SRX28842020 | SRS25072222 | SRP586119 | PRJNA1263917 | Danio rerio Transcriptome or Gene expression | PRJNA1263917 | Other | Analyze the effect of TB KW fermentation on gene expression in high lipid zebrafish. | Danio rerio | Danio rerio | strain:missing|isolate:missing|breed:missing|cultivar:missing|ecotype:missing|age:7 day|dev stage:Juvenile fish|collection date:2024 04 16|geo loc name:China: Hang Zhou|sex:missing|tissue:Whole body|BioSampleModel:Model organism or animal | RNA seq of Danio rerio | NFD 2 | NFD 2 | Total RNA was extracted digested with DNase I and mRNA enriched. post fragmentation cDNA synthesis and library construction the final single stranded DNA nanoball library was generated for sequencing via rolling circle replication. | RNA-Seq | TRANSCRIPTOMIC | PolyA | PAIRED | DNBSEQ | DNBSEQ-T7 | SRP586119 | NFD-2-1.fq.gz NFD-2-2.fq.gz | fastq fastq | 6680197200.0 | 22267324.0 | NFD 2 1.fq.gz | 0:150 1:150 | A:1810744167;C:1526383805;G:1539949310;T:1803119918;N:0 | 150 | 150 | 1810744167 | 1526383805 | 1539949310 | 1803119918 | 0 | SRX28842020 | SRS25072222 | SRA2131918 | Yibin University|Faculty of Quality Management and Inspection & Qua | Yibin University | B | B | biological fallback assumption | bgi | bgi | unknown | poly_a | unknown | bulk | unknown | unknown | China | 2025-05-18 | Multi-stage | Multi-stage | Trunk | Surface Structure | |||||||||||||||||||||||||||||||
| 36235 | 36235 | SRR33613680 | SRX28842019 | SRS25072222 | SRP586119 | PRJNA1263917 | Danio rerio Transcriptome or Gene expression | PRJNA1263917 | Other | Analyze the effect of TB KW fermentation on gene expression in high lipid zebrafish. | Danio rerio | Danio rerio | strain:missing|isolate:missing|breed:missing|cultivar:missing|ecotype:missing|age:7 day|dev stage:Juvenile fish|collection date:2024 04 16|geo loc name:China: Hang Zhou|sex:missing|tissue:Whole body|BioSampleModel:Model organism or animal | RNA seq of Danio rerio | NFD 1 | NFD 1 | Total RNA was extracted digested with DNase I and mRNA enriched. post fragmentation cDNA synthesis and library construction the final single stranded DNA nanoball library was generated for sequencing via rolling circle replication. | RNA-Seq | TRANSCRIPTOMIC | PolyA | PAIRED | DNBSEQ | DNBSEQ-T7 | SRP586119 | NFD-1-1.fq.gz NFD-1-2.fq.gz | fastq fastq | 6587923800.0 | 21959746.0 | NFD 1 1.fq.gz | 0:150 1:150 | A:1773646514;C:1516320091;G:1530275621;T:1767681574;N:0 | 150 | 150 | 1773646514 | 1516320091 | 1530275621 | 1767681574 | 0 | SRX28842019 | SRS25072222 | SRA2131918 | Yibin University|Faculty of Quality Management and Inspection & Qua | Yibin University | B | B | biological fallback assumption | bgi | bgi | unknown | poly_a | unknown | bulk | unknown | unknown | China | 2025-05-18 | Multi-stage | Multi-stage | Trunk | Surface Structure |
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");;