RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

run_metadata

9 rows where experiment.library_layout = "PAIRED", experiment.library_selection = "Oligo-dT" and tissue_curation = "Muscle"

✎ View and edit SQL

This data as json, CSV (advanced)

tissue_curation_coarse 1

tissue_curation 1

  • Muscle · 9 ✖

technology 1

experiment.platform 1

experiment.library_strategy 1

experiment.library_source 1

experiment.library_selection 1

  • Oligo-dT · 9 ✖

experiment.library_layout 1

  • PAIRED · 9 ✖

devstage_curation_coarse 1

devstage_curation 1

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
72652 72652 SRR23036877 SRX18991135 SRS16411628 SRP416839 PRJNA922057 Danio rerio Raw sequence reads PRJNA922057 Whole Genome Sequencing normal RNA seq of Danio rerio female muscle         NFM 3   strain:AB|age:26 mpf of NMN fish 3|BioSampleModel:Model organism or animal                 RNAseq of muscle s803 s803 normal RNA Seq of muscle     RNA-Seq TRANSCRIPTOMIC Oligo-dT PAIRED ILLUMINA Illumina NovaSeq 6000   SRP416839     NFM3_1.fq.gz NFM3_2.fq.gz fastq fastq 8397732300.0 27992441.0 NFM3 1.fq.gz 0:150 1:150 A:2220565446;C:2001421432;G:1998051892;T:2177474234;N:219296 150 150     2220565446 2001421432 1998051892 2177474234 219296 SRX18991135 SRS16411628 SRA1572325 university of Macau|faculty of health science university of Macau 2 0.96459 0.96418 0.03541 0.03492 0.79166 0.79121 0.52178 0.52025 150 150 B B biological fallback assumption illumina novaseq_era unknown poly_a unknown bulk unknown unknown   China 2023-01-10 Adult Adult Muscle Muscular System
72653 72653 SRR23036878 SRX18991134 SRS16411627 SRP416839 PRJNA922057 Danio rerio Raw sequence reads PRJNA922057 Whole Genome Sequencing normal RNA seq of Danio rerio female muscle         NFM 2   strain:AB|age:26 mpf of NMN fish 2|BioSampleModel:Model organism or animal                 RNAseq of muscle s802 s802 normal RNA Seq of muscle     RNA-Seq TRANSCRIPTOMIC Oligo-dT PAIRED ILLUMINA Illumina NovaSeq 6000   SRP416839     NFM2_1.fq.gz NFM2_2.fq.gz fastq fastq 6501604500.0 21672015.0 NFM2 1.fq.gz 0:150 1:150 A:1723308499;C:1541453592;G:1543023084;T:1693798229;N:21096 150 150     1723308499 1541453592 1543023084 1693798229 21096 SRX18991134 SRS16411627 SRA1572325 university of Macau|faculty of health science university of Macau 2 0.96116 0.96044 0.04017 0.04033 0.7666 0.76712 0.5327 0.51987 150 150 B B biological fallback assumption illumina novaseq_era unknown poly_a unknown bulk unknown unknown   China 2023-01-10 Adult Adult Muscle Muscular System
72654 72654 SRR23036879 SRX18991133 SRS16411626 SRP416839 PRJNA922057 Danio rerio Raw sequence reads PRJNA922057 Whole Genome Sequencing normal RNA seq of Danio rerio female muscle         NFM 1   strain:AB|age:26 mpf of NMN fish 1|BioSampleModel:Model organism or animal                 RNAseq of muscle s801 s801 normal RNA Seq of muscle     RNA-Seq TRANSCRIPTOMIC Oligo-dT PAIRED ILLUMINA Illumina NovaSeq 6000   SRP416839     NFM1_1.fq.gz NFM1_2.fq.gz fastq fastq 7081333800.0 23604446.0 NFM1 1.fq.gz 0:150 1:150 A:1901951058;C:1665551541;G:1644429904;T:1869272170;N:129127 150 150     1901951058 1665551541 1644429904 1869272170 129127 SRX18991133 SRS16411626 SRA1572325 university of Macau|faculty of health science university of Macau 2 0.96442 0.96415 0.04454 0.04446 0.75493 0.75584 0.51869 0.52832 150 150 B B biological fallback assumption illumina novaseq_era unknown poly_a unknown bulk unknown unknown   China 2023-01-10 Adult Adult Muscle Muscular System
72655 72655 SRR23036880 SRX18991132 SRS16411625 SRP416839 PRJNA922057 Danio rerio Raw sequence reads PRJNA922057 Whole Genome Sequencing normal RNA seq of Danio rerio female muscle         AFM 3   strain:AB|age:26 mpf of Aged fish 3|BioSampleModel:Model organism or animal                 RNAseq of muscle s800 s800 normal RNA Seq of muscle     RNA-Seq TRANSCRIPTOMIC Oligo-dT PAIRED ILLUMINA Illumina NovaSeq 6000   SRP416839     AFM3_1.fq.gz AFM3_2.fq.gz fastq fastq 7154871300.0 23849571.0 AFM3 1.fq.gz 0:150 1:150 A:1927832700;C:1679297228;G:1657943955;T:1889668827;N:128590 150 150     1927832700 1679297228 1657943955 1889668827 128590 SRX18991132 SRS16411625 SRA1572325 university of Macau|faculty of health science university of Macau 2 0.96635 0.96581 0.0451 0.04507 0.77118 0.77285 0.50294 0.50373 150 150 B B biological fallback assumption illumina novaseq_era unknown poly_a unknown bulk unknown unknown   China 2023-01-10 Adult Adult Muscle Muscular System
72656 72656 SRR23036881 SRX18991131 SRS16411624 SRP416839 PRJNA922057 Danio rerio Raw sequence reads PRJNA922057 Whole Genome Sequencing normal RNA seq of Danio rerio female muscle         AFM 2   strain:AB|age:26 mpf of Aged fish 2|BioSampleModel:Model organism or animal                 RNAseq of muscle s799 s799 normal RNA Seq of muscle     RNA-Seq TRANSCRIPTOMIC Oligo-dT PAIRED ILLUMINA Illumina NovaSeq 6000   SRP416839     AFM2_1.fq.gz AFM2_2.fq.gz fastq fastq 6480175200.0 21600584.0 AFM2 1.fq.gz 0:150 1:150 A:1713331460;C:1546623954;G:1536148465;T:1683946251;N:125070 150 150     1713331460 1546623954 1536148465 1683946251 125070 SRX18991131 SRS16411624 SRA1572325 university of Macau|faculty of health science university of Macau 2 0.96535 0.96488 0.04149 0.04128 0.79275 0.79318 0.50356 0.50154 150 150 B B biological fallback assumption illumina novaseq_era unknown poly_a unknown bulk unknown unknown   China 2023-01-10 Adult Adult Muscle Muscular System
72657 72657 SRR23036882 SRX18991130 SRS16411623 SRP416839 PRJNA922057 Danio rerio Raw sequence reads PRJNA922057 Whole Genome Sequencing normal RNA seq of Danio rerio female muscle         AFM 1   strain:AB|age:26 mpf of Aged fish 1|BioSampleModel:Model organism or animal                 RNAseq of muscle s798 s798 normal RNA Seq of muscle     RNA-Seq TRANSCRIPTOMIC Oligo-dT PAIRED ILLUMINA Illumina NovaSeq 6000   SRP416839     AFM1_1.fq.gz AFM1_2.fq.gz fastq fastq 6295940700.0 20986469.0 AFM1 1.fq.gz 0:150 1:150 A:1691146259;C:1480427698;G:1469111132;T:1655142365;N:113246 150 150     1691146259 1480427698 1469111132 1655142365 113246 SRX18991130 SRS16411623 SRA1572325 university of Macau|faculty of health science university of Macau 2 0.9692 0.96886 0.03546 0.03532 0.79328 0.79375 0.46699 0.46857 150 150 B B biological fallback assumption illumina novaseq_era unknown poly_a unknown bulk unknown unknown   China 2023-01-10 Adult Adult Muscle Muscular System
72658 72658 SRR23036883 SRX18991129 SRS16411622 SRP416839 PRJNA922057 Danio rerio Raw sequence reads PRJNA922057 Whole Genome Sequencing normal RNA seq of Danio rerio female muscle         YFM 3   strain:AB|age:4 mpf of young fish 3|BioSampleModel:Model organism or animal                 RNAseq of muscle s797 s797 normal RNA Seq of muscle     RNA-Seq TRANSCRIPTOMIC Oligo-dT PAIRED ILLUMINA Illumina NovaSeq 6000   SRP416839     YFM3_1.fq.gz YFM3_2.fq.gz fastq fastq 6749895300.0 22499651.0 YFM3 1.fq.gz 0:150 1:150 A:1798541651;C:1593018727;G:1587162725;T:1771067072;N:105125 150 150     1798541651 1593018727 1587162725 1771067072 105125 SRX18991129 SRS16411622 SRA1572325 university of Macau|faculty of health science university of Macau 2 0.95851 0.95868 0.05157 0.05164 0.78431 0.78393 0.56439 0.56646 150 150 B B biological fallback assumption illumina novaseq_era unknown poly_a unknown bulk unknown unknown   China 2023-01-10 Adult Adult Muscle Muscular System
72659 72659 SRR23036884 SRX18991128 SRS16411621 SRP416839 PRJNA922057 Danio rerio Raw sequence reads PRJNA922057 Whole Genome Sequencing normal RNA seq of Danio rerio female muscle         YFM 2   strain:AB|age:4 mpf of young fish 2|BioSampleModel:Model organism or animal                 RNAseq of muscle s796 s796 normal RNA Seq of muscle     RNA-Seq TRANSCRIPTOMIC Oligo-dT PAIRED ILLUMINA Illumina NovaSeq 6000   SRP416839     YFM2_1.fq.gz YFM2_2.fq.gz fastq fastq 8174977500.0 27249925.0 YFM2 1.fq.gz 0:150 1:150 A:2172990986;C:1934605933;G:1929840977;T:2137409668;N:129936 150 150     2172990986 1934605933 1929840977 2137409668 129936 SRX18991128 SRS16411621 SRA1572325 university of Macau|faculty of health science university of Macau 2 0.95502 0.95505 0.05196 0.05173 0.77114 0.77118 0.53759 0.54189 150 150 B B biological fallback assumption illumina novaseq_era unknown poly_a unknown bulk unknown unknown   China 2023-01-10 Adult Adult Muscle Muscular System
72660 72660 SRR23036885 SRX18991127 SRS16411620 SRP416839 PRJNA922057 Danio rerio Raw sequence reads PRJNA922057 Whole Genome Sequencing normal RNA seq of Danio rerio female muscle         YFM 1   strain:AB|age:4 mpf of young fish 1|BioSampleModel:Model organism or animal                 RNAseq of muscle s795 s795 normal RNA Seq of muscle     RNA-Seq TRANSCRIPTOMIC Oligo-dT PAIRED ILLUMINA Illumina NovaSeq 6000   SRP416839     YFM1_1.fq.gz YFM1_2.fq.gz fastq fastq 6937235700.0 23124119.0 YFM1 1.fq.gz 0:150 1:150 A:1847246655;C:1638505321;G:1634173480;T:1817202700;N:107544 150 150     1847246655 1638505321 1634173480 1817202700 107544 SRX18991127 SRS16411620 SRA1572325 university of Macau|faculty of health science university of Macau 2 0.95659 0.95671 0.05088 0.05058 0.75519 0.75503 0.52441 0.54159 150 150 B B biological fallback assumption illumina novaseq_era unknown poly_a unknown bulk unknown unknown   China 2023-01-10 Adult Adult Muscle Muscular System

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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