RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

run_metadata

6 rows where experiment.library_selection = "RT-PCR" 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

experiment.library_strategy 1

experiment.library_source 1

experiment.library_selection 1

  • RT-PCR · 6 ✖

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
76377 76377 SRR24883271 SRX20646607 SRS17944844 SRP442003 PRJNA982106 DEHP exposed zebrafish Danio rerio spleen Transcriptome PRJNA982106 Other Investigating alterations in spleen gene expression profiles following DEHP exposure in adult zebrafish       exposure3 sample6   isolate:missing|breed:danio rerio|age:3 month|dev stage:adult|collection date:2022 09 25|geo loc name:Not collected|sex:not applicable|tissue:spleen|sample type:tissue sample|treatment:DEHP|tmp:DEHP3|BioSampleModel:Model organism or animal                 spleen sample sample6 sample6 exposure     RNA-Seq TRANSCRIPTOMIC RT-PCR PAIRED ILLUMINA Illumina NovaSeq 6000   SRP442003     DEHP3.R2.fq.gz DEHP3.R1.fq.gz fastq fastq 11043658500.0 36812195.0 DEHP3.R1.fq.gz 0:150 1:150 A:2929672242;C:2583571684;G:2658620610;T:2871678831;N:115133 150 150     2929672242 2583571684 2658620610 2871678831 115133 SRX20646607 SRS17944844 SRA1652098 Northeast Agricultural University|College of Resources and Environment Northeast Agricultural University 2 0.92543 0.92492 0.09404 0.09379 0.71904 0.72139 0.51682 0.51908 150 150 B B biological fallback assumption illumina novaseq_era unknown other unknown bulk unknown unknown   China 2023-06-09 Adult Adult Spleen Hematopoietic System
76378 76378 SRR24883272 SRX20646606 SRS17944845 SRP442003 PRJNA982106 DEHP exposed zebrafish Danio rerio spleen Transcriptome PRJNA982106 Other Investigating alterations in spleen gene expression profiles following DEHP exposure in adult zebrafish       exposure2 sample5   isolate:missing|breed:danio rerio|age:3 month|dev stage:adult|collection date:2022 09 25|geo loc name:Not collected|sex:not applicable|tissue:spleen|sample type:tissue sample|treatment:DEHP|tmp:DEHP 2|BioSampleModel:Model organism or animal                 spleen sample sample5 sample5 exposure     RNA-Seq TRANSCRIPTOMIC RT-PCR PAIRED ILLUMINA Illumina NovaSeq 6000   SRP442003     DEHP2.R1.fq.gz DEHP2.R2.fq.gz fastq fastq 11197312500.0 37324375.0 DEHP2.R1.fq.gz 0:150 1:150 A:3003525993;C:2587094762;G:2660240359;T:2946337086;N:114300 150 150     3003525993 2587094762 2660240359 2946337086 114300 SRX20646606 SRS17944845 SRA1652098 Northeast Agricultural University|College of Resources and Environment Northeast Agricultural University 2 0.92402 0.92201 0.09244 0.09091 0.7153 0.71835 0.50728 0.51018 150 150 B B biological fallback assumption illumina novaseq_era unknown other unknown bulk unknown unknown   China 2023-06-09 Adult Adult Spleen Hematopoietic System
76379 76379 SRR24883273 SRX20646605 SRS17944843 SRP442003 PRJNA982106 DEHP exposed zebrafish Danio rerio spleen Transcriptome PRJNA982106 Other Investigating alterations in spleen gene expression profiles following DEHP exposure in adult zebrafish       exposure1 sample4   isolate:missing|breed:danio rerio|age:3 month|dev stage:adult|collection date:2022 09 25|geo loc name:Not collected|sex:not applicable|tissue:spleen|sample type:tissue sample|treatment:DEHP|tmp:DEHP 1|BioSampleModel:Model organism or animal                 spleen sample sample4 sample4 exposure     RNA-Seq TRANSCRIPTOMIC RT-PCR PAIRED ILLUMINA Illumina NovaSeq 6000   SRP442003     DEHP1.R1.fq.gz DEHP1.R2.fq.gz fastq fastq 11344567800.0 37815226.0 DEHP1.R1.fq.gz 0:150 1:150 A:3053207608;C:2620172281;G:2687329750;T:2983695188;N:162973 150 150     3053207608 2620172281 2687329750 2983695188 162973 SRX20646605 SRS17944843 SRA1652098 Northeast Agricultural University|College of Resources and Environment Northeast Agricultural University 2 0.92192 0.9203 0.09048 0.08897 0.71553 0.7181 0.50378 0.50663 150 150 B B biological fallback assumption illumina novaseq_era unknown other unknown bulk unknown unknown   China 2023-06-09 Adult Adult Spleen Hematopoietic System
76380 76380 SRR24883274 SRX20646604 SRS17944840 SRP442003 PRJNA982106 DEHP exposed zebrafish Danio rerio spleen Transcriptome PRJNA982106 Other Investigating alterations in spleen gene expression profiles following DEHP exposure in adult zebrafish       con3 sample3   isolate:missing|breed:danio rerio|age:3 month|dev stage:adult|collection date:2022 09 25|geo loc name:Not collected|sex:not applicable|tissue:spleen|sample type:tissue sample|treatment:control|tmp:ck 3|BioSampleModel:Model organism or animal                 spleen sample sample3 sample3 health     RNA-Seq TRANSCRIPTOMIC RT-PCR PAIRED ILLUMINA Illumina NovaSeq 6000   SRP442003     CK3.R1.fq.gz CK3.R2.fq.gz fastq fastq 13659957000.0 45533190.0 CK3.R1.fq.gz 0:150 1:150 A:3694247259;C:3116013012;G:3220828993;T:3628760297;N:107439 150 150     3694247259 3116013012 3220828993 3628760297 107439 SRX20646604 SRS17944840 SRA1652098 Northeast Agricultural University|College of Resources and Environment Northeast Agricultural University 2 0.92417 0.91872 0.07548 0.07393 0.73559 0.74211 0.44648 0.45163 150 150 B B biological fallback assumption illumina novaseq_era unknown other unknown bulk unknown unknown   China 2023-06-09 Adult Adult Spleen Hematopoietic System
76381 76381 SRR24883275 SRX20646603 SRS17944842 SRP442003 PRJNA982106 DEHP exposed zebrafish Danio rerio spleen Transcriptome PRJNA982106 Other Investigating alterations in spleen gene expression profiles following DEHP exposure in adult zebrafish       con2 sample2   isolate:missing|breed:danio rerio|age:3 month|dev stage:adult|collection date:2022 09 25|geo loc name:Not collected|sex:not applicable|tissue:spleen|sample type:tissue sample|treatment:control|tmp:ck 2|BioSampleModel:Model organism or animal                 spleen sample sample2 sample2 health     RNA-Seq TRANSCRIPTOMIC RT-PCR PAIRED ILLUMINA Illumina NovaSeq 6000   SRP442003     CK2.R1.fq.gz CK2.R2.fq.gz fastq fastq 11443825500.0 38146085.0 CK2.R1.fq.gz 0:150 1:150 A:3107712867;C:2604406715;G:2679598652;T:3051975001;N:132265 150 150     3107712867 2604406715 2679598652 3051975001 132265 SRX20646603 SRS17944842 SRA1652098 Northeast Agricultural University|College of Resources and Environment Northeast Agricultural University 2 0.90432 0.92276 0.07243 0.07326 0.7363 0.73695 0.44003 0.42918 150 150 B B biological fallback assumption illumina novaseq_era unknown other unknown bulk unknown unknown   China 2023-06-09 Adult Adult Spleen Hematopoietic System
76382 76382 SRR24883276 SRX20646602 SRS17944841 SRP442003 PRJNA982106 DEHP exposed zebrafish Danio rerio spleen Transcriptome PRJNA982106 Other Investigating alterations in spleen gene expression profiles following DEHP exposure in adult zebrafish       con1 sample1   isolate:missing|breed:danio rerio|age:3 month|dev stage:adult|collection date:2022 09 25|geo loc name:Not collected|sex:not applicable|tissue:spleen|sample type:tissue sample|treatment:control|tmp:ck 1|BioSampleModel:Model organism or animal                 spleen sample sample1 sample1 health     RNA-Seq TRANSCRIPTOMIC RT-PCR PAIRED ILLUMINA Illumina NovaSeq 6000   SRP442003     CK1.R2.fq.gz CK1.R1.fq.gz fastq fastq 10285960200.0 34286534.0 CK1.R1.fq.gz 0:150 1:150 A:2798446182;C:2334487723;G:2403435339;T:2749453663;N:137293 150 150     2798446182 2334487723 2403435339 2749453663 137293 SRX20646602 SRS17944841 SRA1652098 Northeast Agricultural University|College of Resources and Environment Northeast Agricultural University 2 0.92371 0.92147 0.07268 0.07094 0.733 0.73888 0.44215 0.43613 150 150 B B biological fallback assumption illumina novaseq_era unknown other unknown bulk unknown unknown   China 2023-06-09 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");;