RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

run_metadata

7 rows where experiment.library_selection = "PCR", experiment.platform = "BGISEQ" and tissue_curation_coarse = "All anatomical structures"

✎ View and edit SQL

This data as json, CSV (advanced)

devstage_curation_coarse 2

devstage_curation 2

tissue_curation_coarse 1

  • All anatomical structures · 7 ✖

tissue_curation 1

technology 1

experiment.platform 1

  • BGISEQ · 7 ✖

experiment.library_strategy 1

experiment.library_source 1

experiment.library_selection 1

experiment.library_layout 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
68195 68195 SRR17658724 SRX13826757 SRS11705915 SRP355720 PRJNA798511 Comparative analysis of transcriptome for heat induced zebrafish during sex differentiation PRJNA798511 Other heat treated zebrafish         C25d ZHT   strain:AB|isolate:28|breed:zebrafish|cultivar:WT|ecotype:CHINA|age:25dpf|sex:not collected|tissue:whole organism|BioSampleModel:Model organism or animal                 RNAq of zebrafish C25D C25D WT zebrafish     RNA-Seq TRANSCRIPTOMIC PCR PAIRED BGISEQ BGISEQ-500   SRP355720   loader:fastq load.py     20541691800.0 68472306.0 C25D.7z 0:150 1:150 A:5668751376;C:4596699177;G:4545478495;T:5730382931;N:379821 150 150     5668751376 4596699177 4545478495 5730382931 379821 SRX13826757 SRS11705915 SRA1358616 Hunan University of Science and Technology|School of Life and Health Sciences Hunan University of Science and Technology 2 0.84223 0.84372 0.07155 0.07222 0.70189 0.70321 0.47909 0.495 150 150 B B biological fallback assumption bgi bgi unknown random_priming unknown bulk unknown unknown   China 2022-12-07 Larval Larval Whole Organism All anatomical structures
68196 68196 SRR17658725 SRX13826756 SRS11705914 SRP355720 PRJNA798511 Comparative analysis of transcriptome for heat induced zebrafish during sex differentiation PRJNA798511 Other heat treated zebrafish         T60d ZHT   strain:AB|isolate:35|breed:zebrafish|cultivar:TEST|ecotype:CHINA|age:60dpf|sex:not collected|tissue:whole organism|BioSampleModel:Model organism or animal                 RNAq of zebrafish T60D T60D heat treated zebrafish     RNA-Seq TRANSCRIPTOMIC PCR PAIRED BGISEQ BGISEQ-500   SRP355720   loader:fastq load.py     20334742200.0 67782474.0 T60D.7z 0:150 1:150 A:5482201207;C:4682998764;G:4635775004;T:5533378494;N:388731 150 150     5482201207 4682998764 4635775004 5533378494 388731 SRX13826756 SRS11705914 SRA1358616 Hunan University of Science and Technology|School of Life and Health Sciences Hunan University of Science and Technology 2 0.94378 0.94515 0.04989 0.04997 0.69848 0.69978 0.50317 0.5041 150 150 B B biological fallback assumption bgi bgi unknown random_priming unknown bulk unknown unknown   China 2022-12-09 Juvenile Juvenile Whole Organism All anatomical structures
68197 68197 SRR17658726 SRX13826755 SRS11705913 SRP355720 PRJNA798511 Comparative analysis of transcriptome for heat induced zebrafish during sex differentiation PRJNA798511 Other heat treated zebrafish         T45d ZHT   strain:AB|isolate:35|breed:zebrafish|cultivar:TEST|ecotype:CHINA|age:45dpf|sex:not collected|tissue:whole organism|BioSampleModel:Model organism or animal                 RNAq of zebrafish T45D T45D heat treated zebrafish     RNA-Seq TRANSCRIPTOMIC PCR PAIRED BGISEQ BGISEQ-500   SRP355720   loader:fastq load.py     20230560300.0 67435201.0 T45D.7z 0:150 1:150 A:5444816209;C:4663007584;G:4631943733;T:5490408754;N:384020 150 150     5444816209 4663007584 4631943733 5490408754 384020 SRX13826755 SRS11705913 SRA1358616 Hunan University of Science and Technology|School of Life and Health Sciences Hunan University of Science and Technology 2 0.88041 0.881 0.04485 0.04492 0.72163 0.72236 0.52232 0.52307 150 150 B B biological fallback assumption bgi bgi unknown random_priming unknown bulk unknown unknown   China 2022-12-09 Juvenile Juvenile Whole Organism All anatomical structures
68198 68198 SRR17658727 SRX13826754 SRS11705912 SRP355720 PRJNA798511 Comparative analysis of transcriptome for heat induced zebrafish during sex differentiation PRJNA798511 Other heat treated zebrafish         T35d ZHT   strain:AB|isolate:35|breed:zebrafish|cultivar:TEST|ecotype:CHINA|age:35dpf|sex:not collected|tissue:whole organism|BioSampleModel:Model organism or animal                 RNAq of zebrafish T35D T35D heat treated zebrafish     RNA-Seq TRANSCRIPTOMIC PCR PAIRED BGISEQ BGISEQ-500   SRP355720   loader:fastq load.py     20630503200.0 68768344.0 T35D.7z 0:150 1:150 A:5660657832;C:4654929757;G:4598083304;T:5716350276;N:482031 150 150     5660657832 4654929757 4598083304 5716350276 482031 SRX13826754 SRS11705912 SRA1358616 Hunan University of Science and Technology|School of Life and Health Sciences Hunan University of Science and Technology 2 0.9134 0.91476 0.06961 0.06972 0.69035 0.69215 0.52155 0.5154 150 150 B B biological fallback assumption bgi bgi unknown random_priming unknown bulk unknown unknown   China 2022-12-09 Juvenile Juvenile Whole Organism All anatomical structures
68199 68199 SRR17658728 SRX13826753 SRS11705911 SRP355720 PRJNA798511 Comparative analysis of transcriptome for heat induced zebrafish during sex differentiation PRJNA798511 Other heat treated zebrafish         C60d ZHT   strain:AB|isolate:28|breed:zebrafish|cultivar:WT|ecotype:CHINA|age:60dpf|sex:not collected|tissue:whole organism|BioSampleModel:Model organism or animal                 RNAq of zebrafish C60D C60D WT zebrafish     RNA-Seq TRANSCRIPTOMIC PCR PAIRED BGISEQ BGISEQ-500   SRP355720   loader:fastq load.py     10921407600.0 44923977.0 C60D.7z   A:2992232295;C:2470688717;G:2440861228;T:3017432565;N:192795         2992232295 2470688717 2440861228 3017432565 192795 SRX13826753 SRS11705911 SRA1358616 Hunan University of Science and Technology|School of Life and Health Sciences Hunan University of Science and Technology 2 0.93932 0.94095 0.06489 0.06559 0.77871 0.77759 0.56384 0.56447 150 150 B B biological fallback assumption bgi bgi unknown random_priming unknown bulk unknown unknown   China 2022-12-09 Juvenile Juvenile Whole Organism All anatomical structures
68200 68200 SRR17658729 SRX13826752 SRS11705910 SRP355720 PRJNA798511 Comparative analysis of transcriptome for heat induced zebrafish during sex differentiation PRJNA798511 Other heat treated zebrafish         C45d ZHT   strain:AB|isolate:28|breed:zebrafish|cultivar:WT|ecotype:CHINA|age:45dpf|sex:not collected|tissue:whole organism|BioSampleModel:Model organism or animal                 RNAq of zebrafish C45D C45D WT zebrafish     RNA-Seq TRANSCRIPTOMIC PCR PAIRED BGISEQ BGISEQ-500   SRP355720   loader:fastq load.py     20413229700.0 68044099.0 C45D.7z 0:150 1:150 A:5619395833;C:4581611789;G:4543973618;T:5667873613;N:374847 150 150     5619395833 4581611789 4543973618 5667873613 374847 SRX13826752 SRS11705910 SRA1358616 Hunan University of Science and Technology|School of Life and Health Sciences Hunan University of Science and Technology 2 0.86848 0.87064 0.0719 0.07252 0.69879 0.69834 0.52279 0.51074 150 150 B B biological fallback assumption bgi bgi unknown random_priming unknown bulk unknown unknown   China 2022-12-09 Juvenile Juvenile Whole Organism All anatomical structures
68201 68201 SRR17658730 SRX13826751 SRS11705909 SRP355720 PRJNA798511 Comparative analysis of transcriptome for heat induced zebrafish during sex differentiation PRJNA798511 Other heat treated zebrafish         C35d ZHT   strain:AB|isolate:28|breed:zebrafish|cultivar:WT|ecotype:CHINA|age:35dpf|sex:not collected|tissue:whole organism|BioSampleModel:Model organism or animal                 RNAq of zebrafish C35D C35D WT zebrafish     RNA-Seq TRANSCRIPTOMIC PCR PAIRED BGISEQ BGISEQ-500   SRP355720   loader:fastq load.py     20469803700.0 68232679.0 C35D.7z 0:150 1:150 A:5556774511;C:4678377106;G:4627472920;T:5606765895;N:413268 150 150     5556774511 4678377106 4627472920 5606765895 413268 SRX13826751 SRS11705909 SRA1358616 Hunan University of Science and Technology|School of Life and Health Sciences Hunan University of Science and Technology 2 0.93663 0.93871 0.06853 0.06895 0.6982 0.69901 0.51209 0.51148 150 150 B B biological fallback assumption bgi bgi unknown random_priming unknown bulk unknown unknown   China 2022-12-09 Juvenile Juvenile Whole Organism All anatomical structures

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