RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

run_metadata

12 rows where experiment.library_selection = "RANDOM", experiment.platform = "BGISEQ" and tissue_curation = "Kidney"

✎ View and edit SQL

This data as json, CSV (advanced)

tissue_curation_coarse 1

tissue_curation 1

  • Kidney · 12 ✖

technology 1

experiment.platform 1

  • BGISEQ · 12 ✖

experiment.library_strategy 1

experiment.library_source 1

experiment.library_selection 1

  • RANDOM · 12 ✖

experiment.library_layout 1

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
63046 63046 SRR13587431 SRX9982126 SRS8153604 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 head kidney of Danio rerio   isolate:river|age:adult|sex:not determined|tissue:head kidney|BioSampleModel:Model organism or animal                 9ZHK 9ZHK 9ZHK The head kidney experiment repeat 3 of Gobiocypris rarus     RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED BGISEQ BGISEQ-500   SRP303929     9ZHK_1.fq.gz 9ZHK_2.fq.gz fastq fastq 8120179200.0 54134528.0 9ZHK 1.fq.gz 0:150 1:150 A:2233782125;C:1817163304;G:1810150041;T:2259083730;N:0 150 150     2233782125 1817163304 1810150041 2259083730 0 SRX9982126 SRS8153604 SRA1189633 Center for Ecological and Environmental Sciences|Northwestern Polytechnical University Center for Ecological and Environmental Sciences 1 0.92334   0.08214   0.71926   0.53557   150   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2021-01-30 Adult Adult Kidney Renal System
63047 63047 SRR13587432 SRX9982125 SRS8153604 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 head kidney of Danio rerio   isolate:river|age:adult|sex:not determined|tissue:head kidney|BioSampleModel:Model organism or animal                 24ZHK 24ZHK 24ZHK The head kidney control repeat 3 of Gobiocypris rarus     RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED BGISEQ BGISEQ-500   SRP303929     24ZHK_1.fq.gz 24ZHK_2.fq.gz fastq fastq 8285296800.0 55235312.0 24ZHK 1.fq.gz 0:150 1:150 A:2319759918;C:1824087204;G:1797861715;T:2343319625;N:268338 150 150     2319759918 1824087204 1797861715 2343319625 268338 SRX9982125 SRS8153604 SRA1189633 Center for Ecological and Environmental Sciences|Northwestern Polytechnical University Center for Ecological and Environmental Sciences 1 0.93067   0.0988   0.74241   0.55453   150   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2021-01-30 Adult Adult Kidney Renal System
63048 63048 SRR13587433 SRX9982124 SRS8153604 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 head kidney of Danio rerio   isolate:river|age:adult|sex:not determined|tissue:head kidney|BioSampleModel:Model organism or animal                 8ZHK 8ZHK 8ZHK The head kidney experiment repeat 2 of Gobiocypris rarus     RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED BGISEQ BGISEQ-500   SRP303929     8ZHK_1.fq.gz 8ZHK_2.fq.gz fastq fastq 8153939700.0 54359598.0 8ZHK 1.fq.gz 0:150 1:150 A:2258284333;C:1815761334;G:1799498163;T:2279047560;N:1348310 150 150     2258284333 1815761334 1799498163 2279047560 1348310 SRX9982124 SRS8153604 SRA1189633 Center for Ecological and Environmental Sciences|Northwestern Polytechnical University Center for Ecological and Environmental Sciences 1 0.91032   0.08827   0.72673   0.51792   150   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2021-01-30 Adult Adult Kidney Renal System
63049 63049 SRR13587434 SRX9982123 SRS8153604 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 head kidney of Danio rerio   isolate:river|age:adult|sex:not determined|tissue:head kidney|BioSampleModel:Model organism or animal                 19Z HK 19Z HK 19Z HK The head kidney control repeat 2 of Gobiocypris rarus     RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED BGISEQ BGISEQ-500   SRP303929     19Z_HK_1.fq.gz 19Z_HK_2.fq.gz fastq fastq 8406183300.0 56041222.0 19Z HK 1.fq.gz 0:150 1:150 A:2335489974;C:1857072213;G:1842430689;T:2370663226;N:527198 150 150     2335489974 1857072213 1842430689 2370663226 527198 SRX9982123 SRS8153604 SRA1189633 Center for Ecological and Environmental Sciences|Northwestern Polytechnical University Center for Ecological and Environmental Sciences 1 0.90938   0.09376   0.72486   0.55731   150   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2021-01-30 Adult Adult Kidney Renal System
63050 63050 SRR13587435 SRX9982122 SRS8153604 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 head kidney of Danio rerio   isolate:river|age:adult|sex:not determined|tissue:head kidney|BioSampleModel:Model organism or animal                 10ZHK 10ZHK 10ZHK The head kidney experiment repeat 1 of Gobiocypris rarus     RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED BGISEQ BGISEQ-500   SRP303929     10ZHK_1.fq.gz 10ZHK_2.fq.gz fastq fastq 8039735100.0 53598234.0 10ZHK 1.fq.gz 0:150 1:150 A:2243931802;C:1770968625;G:1759940752;T:2264893921;N:0 150 150     2243931802 1770968625 1759940752 2264893921 0 SRX9982122 SRS8153604 SRA1189633 Center for Ecological and Environmental Sciences|Northwestern Polytechnical University Center for Ecological and Environmental Sciences 1 0.9182   0.10087   0.71417   0.54166   150   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2021-01-30 Adult Adult Kidney Renal System
63051 63051 SRR13587436 SRX9982121 SRS8153604 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 head kidney of Danio rerio   isolate:river|age:adult|sex:not determined|tissue:head kidney|BioSampleModel:Model organism or animal                 10Z HK 10Z HK 10Z HK The head kidney control repeat 1 of Gobiocypris rarus     RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED BGISEQ BGISEQ-500   SRP303929     10Z_HK_1.fq.gz 10Z_HK_2.fq.gz fastq fastq 8419659600.0 56131064.0 10Z HK 1.fq.gz 0:150 1:150 A:2310224890;C:1885764527;G:1880790942;T:2342359008;N:520233 150 150     2310224890 1885764527 1880790942 2342359008 520233 SRX9982121 SRS8153604 SRA1189633 Center for Ecological and Environmental Sciences|Northwestern Polytechnical University Center for Ecological and Environmental Sciences 1 0.91616   0.06612   0.76152   0.37751   150   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2021-01-30 Adult Adult Kidney Renal System
63058 63058 SRR13587413 SRX9982108 SRS8153601 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 kidney of Danio rerio   isolate:river|age:adult|sex:not collected|tissue:kidney|BioSampleModel:Model organism or animal                 9ZK 9ZK 9ZK The kidney experiment repeat 3 of Gobiocypris rarus     RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED BGISEQ BGISEQ-500   SRP303929     9ZK_1.fq.gz 9ZK_2.fq.gz fastq fastq 8175736200.0 54504908.0 9ZK 1.fq.gz 0:150 1:150 A:2263839094;C:1817074671;G:1806345887;T:2288476548;N:0 150 150     2263839094 1817074671 1806345887 2288476548 0 SRX9982108 SRS8153601 SRA1189630 Center for Ecological and Environmental Sciences|Northwestern Polytechnical University Center for Ecological and Environmental Sciences 1 0.92014   0.08977   0.72236   0.53162   150   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2021-01-30 Adult Adult Kidney Renal System
63059 63059 SRR13587414 SRX9982107 SRS8153601 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 kidney of Danio rerio   isolate:river|age:adult|sex:not collected|tissue:kidney|BioSampleModel:Model organism or animal                 24ZK 24ZK 24ZK The kidney control repeat 3 of Gobiocypris rarus     RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED BGISEQ BGISEQ-500   SRP303929     24ZK_1.fq.gz 24ZK_2.fq.gz fastq fastq 8238567600.0 54923784.0 24ZK 1.fq.gz 0:150 1:150 A:2258633038;C:1860080137;G:1835508827;T:2284016515;N:329083 150 150     2258633038 1860080137 1835508827 2284016515 329083 SRX9982107 SRS8153601 SRA1189630 Center for Ecological and Environmental Sciences|Northwestern Polytechnical University Center for Ecological and Environmental Sciences 1 0.92468   0.0959   0.70907   0.53327   150   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2021-01-30 Adult Adult Kidney Renal System
63060 63060 SRR13587415 SRX9982106 SRS8153601 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 kidney of Danio rerio   isolate:river|age:adult|sex:not collected|tissue:kidney|BioSampleModel:Model organism or animal                 8ZK 8ZK 8ZK The kidney experiment repeat 2 of Gobiocypris rarus     RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED BGISEQ BGISEQ-500   SRP303929     8ZK_1.fq.gz 8ZK_2.fq.gz fastq fastq 8191887900.0 54612586.0 8ZK 1.fq.gz 0:150 1:150 A:2267646460;C:1825604395;G:1807903598;T:2289958188;N:775259 150 150     2267646460 1825604395 1807903598 2289958188 775259 SRX9982106 SRS8153601 SRA1189630 Center for Ecological and Environmental Sciences|Northwestern Polytechnical University Center for Ecological and Environmental Sciences 1 0.91157   0.09088   0.72723   0.52217   150   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2021-01-30 Adult Adult Kidney Renal System
63061 63061 SRR13587416 SRX9982105 SRS8153601 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 kidney of Danio rerio   isolate:river|age:adult|sex:not collected|tissue:kidney|BioSampleModel:Model organism or animal                 19Z K 19Z K 19Z K The kidney control repeat 2 of Gobiocypris rarus     RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED BGISEQ BGISEQ-500   SRP303929     19Z_K_1.fq.gz 19Z_K_2.fq.gz fastq fastq 8402134200.0 56014228.0 19Z K 1.fq.gz 0:150 1:150 A:2338499372;C:1849973662;G:1840214821;T:2372961719;N:484626 150 150     2338499372 1849973662 1840214821 2372961719 484626 SRX9982105 SRS8153601 SRA1189630 Center for Ecological and Environmental Sciences|Northwestern Polytechnical University Center for Ecological and Environmental Sciences 1 0.90113   0.10231   0.72703   0.56124   150   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2021-01-30 Adult Adult Kidney Renal System
63062 63062 SRR13587417 SRX9982104 SRS8153601 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 kidney of Danio rerio   isolate:river|age:adult|sex:not collected|tissue:kidney|BioSampleModel:Model organism or animal                 10ZK 10ZK 10ZK The kidney experiment repeat 1 of Gobiocypris rarus     RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED BGISEQ BGISEQ-500   SRP303929     10ZK_1.fq.gz 10ZK_2.fq.gz fastq fastq 8208016200.0 54720108.0 10ZK 1.fq.gz 0:150 1:150 A:2303193070;C:1796200671;G:1783288010;T:2325334449;N:0 150 150     2303193070 1796200671 1783288010 2325334449 0 SRX9982104 SRS8153601 SRA1189630 Center for Ecological and Environmental Sciences|Northwestern Polytechnical University Center for Ecological and Environmental Sciences 1 0.9173   0.1039   0.72224   0.541   150   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2021-01-30 Adult Adult Kidney Renal System
63063 63063 SRR13587418 SRX9982103 SRS8153601 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 kidney of Danio rerio   isolate:river|age:adult|sex:not collected|tissue:kidney|BioSampleModel:Model organism or animal                 10Z K 10Z K 10Z K The kidney control repeat 1 of Gobiocypris rarus     RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED BGISEQ BGISEQ-500   SRP303929     10Z_K_1.fq.gz 10Z_K_2.fq.gz fastq fastq 8205024600.0 54700164.0 10Z K 1.fq.gz 0:150 1:150 A:2259032946;C:1833449876;G:1824313852;T:2287704541;N:523385 150 150     2259032946 1833449876 1824313852 2287704541 523385 SRX9982103 SRS8153601 SRA1189630 Center for Ecological and Environmental Sciences|Northwestern Polytechnical University Center for Ecological and Environmental Sciences 1 0.91993   0.0808   0.73308   0.55396   150   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2021-01-30 Adult Adult Kidney Renal 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");;