RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

run_metadata

6 rows where experiment.library_layout = "PAIRED", experiment.platform = "BGISEQ" and tissue_curation_coarse = "Hematopoietic System"

✎ View and edit SQL

This data as json, CSV (advanced)

tissue_curation_coarse 1

  • Hematopoietic System · 6 ✖

tissue_curation 1

technology 1

experiment.platform 1

  • BGISEQ · 6 ✖

experiment.library_strategy 1

experiment.library_source 1

experiment.library_selection 1

experiment.library_layout 1

  • PAIRED · 6 ✖

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
63070 63070 SRR13587384 SRX9982079 SRS8153594 SRP303929 PRJNA698005 Danio rerio Raw sequence reads PRJNA698005 Whole Genome Sequencing Danio rerio Raw RNA sequence reads       Model organism or animal sample from Danio rerio The spleen of Danio rerio   isolate:river|age:adult|sex:not collected|tissue:spleen|BioSampleModel:Model organism or animal                 9ZS 9ZS 9ZS The spleen experiment repeat 3 of Gobiocypris rarus     RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED BGISEQ BGISEQ-500   SRP303929     9ZS_1.fq.gz 9ZS_2.fq.gz fastq fastq 8205802500.0 54705350.0 9ZS 1.fq.gz 0:150 1:150 A:2280163497;C:1814966062;G:1803870112;T:2306802829;N:0 150 150     2280163497 1814966062 1803870112 2306802829 0 SRX9982079 SRS8153594 SRA1189624 Center for Ecological and Environmental Sciences|Northwestern Polytechnical University Center for Ecological and Environmental Sciences 1 0.90674   0.10519   0.73225   0.50894   150   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2021-01-30 Adult Adult Spleen Hematopoietic System
63071 63071 SRR13587385 SRX9982078 SRS8153594 SRP303929 PRJNA698005 Danio rerio Raw sequence reads PRJNA698005 Whole Genome Sequencing Danio rerio Raw RNA sequence reads       Model organism or animal sample from Danio rerio The spleen of Danio rerio   isolate:river|age:adult|sex:not collected|tissue:spleen|BioSampleModel:Model organism or animal                 24ZS 24ZS 24ZS The spleen control repeat 3 of Gobiocypris rarus     RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED BGISEQ BGISEQ-500   SRP303929     24ZS_1.fq.gz 24ZS_2.fq.gz fastq fastq 8279731500.0 55198210.0 24ZS 1.fq.gz 0:150 1:150 A:2228188611;C:1909382391;G:1884421138;T:2257483634;N:255726 150 150     2228188611 1909382391 1884421138 2257483634 255726 SRX9982078 SRS8153594 SRA1189624 Center for Ecological and Environmental Sciences|Northwestern Polytechnical University Center for Ecological and Environmental Sciences 1 0.91852   0.09459   0.74539   0.51194   150   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2021-01-30 Adult Adult Spleen Hematopoietic System
63072 63072 SRR13587386 SRX9982077 SRS8153594 SRP303929 PRJNA698005 Danio rerio Raw sequence reads PRJNA698005 Whole Genome Sequencing Danio rerio Raw RNA sequence reads       Model organism or animal sample from Danio rerio The spleen of Danio rerio   isolate:river|age:adult|sex:not collected|tissue:spleen|BioSampleModel:Model organism or animal                 8ZS 8ZS 8ZS The spleen experiment repeat 2 of Gobiocypris rarus     RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED BGISEQ BGISEQ-500   SRP303929     8ZS_1.fq.gz 8ZS_2.fq.gz fastq fastq 8376961800.0 55846412.0 8ZS 1.fq.gz 0:150 1:150 A:2362175703;C:1822140642;G:1805332183;T:2386668646;N:644626 150 150     2362175703 1822140642 1805332183 2386668646 644626 SRX9982077 SRS8153594 SRA1189624 Center for Ecological and Environmental Sciences|Northwestern Polytechnical University Center for Ecological and Environmental Sciences 1 0.89088   0.11828   0.74138   0.51485   150   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2021-01-30 Adult Adult Spleen Hematopoietic System
63073 63073 SRR13587387 SRX9982076 SRS8153594 SRP303929 PRJNA698005 Danio rerio Raw sequence reads PRJNA698005 Whole Genome Sequencing Danio rerio Raw RNA sequence reads       Model organism or animal sample from Danio rerio The spleen of Danio rerio   isolate:river|age:adult|sex:not collected|tissue:spleen|BioSampleModel:Model organism or animal                 19Z S 19Z S 19Z S The spleen control repeat 2 of Gobiocypris rarus     RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED BGISEQ BGISEQ-500   SRP303929     19Z_S_1.fq.gz 19Z_S_2.fq.gz fastq fastq 8390649600.0 55937664.0 19Z S 1.fq.gz 0:150 1:150 A:2302584143;C:1877946699;G:1869505731;T:2340091695;N:521332 150 150     2302584143 1877946699 1869505731 2340091695 521332 SRX9982076 SRS8153594 SRA1189624 Center for Ecological and Environmental Sciences|Northwestern Polytechnical University Center for Ecological and Environmental Sciences 1 0.89383   0.11774   0.73359   0.4805   150   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2021-01-30 Adult Adult Spleen Hematopoietic System
63074 63074 SRR13587388 SRX9982075 SRS8153594 SRP303929 PRJNA698005 Danio rerio Raw sequence reads PRJNA698005 Whole Genome Sequencing Danio rerio Raw RNA sequence reads       Model organism or animal sample from Danio rerio The spleen of Danio rerio   isolate:river|age:adult|sex:not collected|tissue:spleen|BioSampleModel:Model organism or animal                 10ZS 10ZS 10ZS The spleen experiment repeat 1 of Gobiocypris rarus     RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED BGISEQ BGISEQ-500   SRP303929     10ZS_1.fq.gz 10ZS_2.fq.gz fastq fastq 8391962700.0 55946418.0 10ZS 1.fq.gz 0:150 1:150 A:2326501009;C:1860778012;G:1850272162;T:2354411517;N:0 150 150     2326501009 1860778012 1850272162 2354411517 0 SRX9982075 SRS8153594 SRA1189624 Center for Ecological and Environmental Sciences|Northwestern Polytechnical University Center for Ecological and Environmental Sciences 1 0.907   0.10692   0.72809   0.50685   150   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2021-01-30 Adult Adult Spleen Hematopoietic System
63075 63075 SRR13587389 SRX9982074 SRS8153594 SRP303929 PRJNA698005 Danio rerio Raw sequence reads PRJNA698005 Whole Genome Sequencing Danio rerio Raw RNA sequence reads       Model organism or animal sample from Danio rerio The spleen of Danio rerio   isolate:river|age:adult|sex:not collected|tissue:spleen|BioSampleModel:Model organism or animal                 10Z S 10Z S 10Z S The spleen control repeat 1 of Gobiocypris rarus     RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED BGISEQ BGISEQ-500   SRP303929     10Z_S_1.fq.gz 10Z_S_2.fq.gz fastq fastq 8375904900.0 55839366.0 10Z S 1.fq.gz 0:150 1:150 A:2357505118;C:1814876503;G:1806400464;T:2396638627;N:484188 150 150     2357505118 1814876503 1806400464 2396638627 484188 SRX9982074 SRS8153594 SRA1189624 Center for Ecological and Environmental Sciences|Northwestern Polytechnical University Center for Ecological and Environmental Sciences 1 0.89619   0.12161   0.73878   0.52421   150   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2021-01-30 Adult Adult Spleen Hematopoietic 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");;