RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

run_metadata

6 rows where experiment.library_selection = "RANDOM PCR", experiment.library_strategy = "RNA-Seq" and tissue_curation = "Oocyte"

✎ View and edit SQL

This data as json, CSV (advanced)

tissue_curation_coarse 1

tissue_curation 1

  • Oocyte · 6 ✖

technology 1

experiment.platform 1

experiment.library_strategy 1

  • RNA-Seq · 6 ✖

experiment.library_source 1

experiment.library_selection 1

  • RANDOM 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
49742 49742 SRR8197481 SRX5016863 SRS4049994 SRP169068 PRJNA495892 Danio rerio Genome sequencing PRJNA495892 Whole Genome Sequencing Transcriptome data of zebrafish in two stages of unfertilized egg and prim 5.     three samples of zebrafish unfertilized eggs and three samples zebrafish fries at the stage of prim5. Model organism or animal sample from Danio rerio The transcriptome data of zebrafish in two stages of unfertilized egg and prim 5.   isolate:zebrafish unfertilized eggs and zebrafish fries at the prim5 stage|dev stage:2 stages of unfertilized egg and prim 5|sex:pooled male and female|tissue:zebrafish in 2 stages of unfertilized egg and prim 5|BioSampleModel:Model organism or animal                 RNA Seq of Danio rerio: prim5 stage Z2 3 F Z2 3 F The unfertilized eggs of zebrafish were taken as three samples Z1 1 Z1 2 and Z1 3 respectively. And the fries of zebrafish were taken as three samples Z2 1 Z2 2 and Z2 3 in the prim5 stage.     RNA-Seq TRANSCRIPTOMIC RANDOM PCR PAIRED ILLUMINA Illumina HiSeq 2500   SRP169068     Z2_3_1.fq.gz Z2_3_2.fq.gz fastq fastq 6979181500.0 27916726.0 Z2 3 1.fq.gz 0:125 1:125 A:1822429760;C:1670132153;G:1694226275;T:1791552753;N:840559 125 125     1822429760 1670132153 1694226275 1791552753 840559 SRX5016863 SRS4049994 SRA810793 Institute of Hydrobiology, Chinese Academy of Sciences|State Key Laboratory of Freshwater Ecology and Bio Institute of Hydrobiology, Chinese Academy of Sciences 2 0.9586 0.9518 0.02217 0.02129 0.81022 0.80921 0.50342 0.51319 125 125 B B biological fallback assumption illumina hiseq_era unknown random_priming unknown bulk unknown unknown   China 2018-11-16 Multi-stage Embryo Oocyte Reproductive System
49743 49743 SRR8197482 SRX5016862 SRS4049994 SRP169068 PRJNA495892 Danio rerio Genome sequencing PRJNA495892 Whole Genome Sequencing Transcriptome data of zebrafish in two stages of unfertilized egg and prim 5.     three samples of zebrafish unfertilized eggs and three samples zebrafish fries at the stage of prim5. Model organism or animal sample from Danio rerio The transcriptome data of zebrafish in two stages of unfertilized egg and prim 5.   isolate:zebrafish unfertilized eggs and zebrafish fries at the prim5 stage|dev stage:2 stages of unfertilized egg and prim 5|sex:pooled male and female|tissue:zebrafish in 2 stages of unfertilized egg and prim 5|BioSampleModel:Model organism or animal                 RNA Seq of Danio rerio: prim5 stage Z2 1 F Z2 1 F The unfertilized eggs of zebrafish were taken as three samples Z1 1 Z1 2 and Z1 3 respectively. And the fries of zebrafish were taken as three samples Z2 1 Z2 2 and Z2 3 in the prim5 stage.     RNA-Seq TRANSCRIPTOMIC RANDOM PCR PAIRED ILLUMINA Illumina HiSeq 2500   SRP169068     Z2_1_2.fq.gz Z2_1_1.fq.gz fastq fastq 6728695750.0 26914783.0 Z2 1 1.fq.gz 0:125 1:125 A:1732100690;C:1624557456;G:1649046037;T:1722193010;N:798557 125 125     1732100690 1624557456 1649046037 1722193010 798557 SRX5016862 SRS4049994 SRA810793 Institute of Hydrobiology, Chinese Academy of Sciences|State Key Laboratory of Freshwater Ecology and Bio Institute of Hydrobiology, Chinese Academy of Sciences 2 0.9585 0.95335 0.01902 0.01833 0.8131 0.81014 0.48431 0.493 125 125 B B biological fallback assumption illumina hiseq_era unknown random_priming unknown bulk unknown unknown   China 2018-11-16 Multi-stage Embryo Oocyte Reproductive System
49744 49744 SRR8197483 SRX5016861 SRS4049994 SRP169068 PRJNA495892 Danio rerio Genome sequencing PRJNA495892 Whole Genome Sequencing Transcriptome data of zebrafish in two stages of unfertilized egg and prim 5.     three samples of zebrafish unfertilized eggs and three samples zebrafish fries at the stage of prim5. Model organism or animal sample from Danio rerio The transcriptome data of zebrafish in two stages of unfertilized egg and prim 5.   isolate:zebrafish unfertilized eggs and zebrafish fries at the prim5 stage|dev stage:2 stages of unfertilized egg and prim 5|sex:pooled male and female|tissue:zebrafish in 2 stages of unfertilized egg and prim 5|BioSampleModel:Model organism or animal                 RNA Seq of Danio rerio: unfertilized egg Z1 3 F Z1 3 F The unfertilized eggs of zebrafish were taken as three samples Z1 1 Z1 2 and Z1 3 respectively. And the fries of zebrafish were taken as three samples Z2 1 Z2 2 and Z2 3 in the prim5 stage.     RNA-Seq TRANSCRIPTOMIC RANDOM PCR PAIRED ILLUMINA Illumina HiSeq 2500   SRP169068     Z1_3_1.fq.gz Z1_3_2.fq.gz fastq fastq 6657035500.0 26628142.0 Z1 3 1.fq.gz 0:125 1:125 A:1796541492;C:1535300915;G:1557971133;T:1766443902;N:778058 125 125     1796541492 1535300915 1557971133 1766443902 778058 SRX5016861 SRS4049994 SRA810793 Institute of Hydrobiology, Chinese Academy of Sciences|State Key Laboratory of Freshwater Ecology and Bio Institute of Hydrobiology, Chinese Academy of Sciences 2 0.95543 0.94989 0.02312 0.02201 0.79689 0.79421 0.51212 0.51203 125 125 B B biological fallback assumption illumina hiseq_era unknown random_priming unknown bulk unknown unknown   China 2018-11-16 Multi-stage Embryo Oocyte Reproductive System
49745 49745 SRR8197484 SRX5016860 SRS4049994 SRP169068 PRJNA495892 Danio rerio Genome sequencing PRJNA495892 Whole Genome Sequencing Transcriptome data of zebrafish in two stages of unfertilized egg and prim 5.     three samples of zebrafish unfertilized eggs and three samples zebrafish fries at the stage of prim5. Model organism or animal sample from Danio rerio The transcriptome data of zebrafish in two stages of unfertilized egg and prim 5.   isolate:zebrafish unfertilized eggs and zebrafish fries at the prim5 stage|dev stage:2 stages of unfertilized egg and prim 5|sex:pooled male and female|tissue:zebrafish in 2 stages of unfertilized egg and prim 5|BioSampleModel:Model organism or animal                 RNA Seq of Danio rerio: unfertilized egg Z1 2 F Z1 2 F The unfertilized eggs of zebrafish were taken as three samples Z1 1 Z1 2 and Z1 3 respectively. And the fries of zebrafish were taken as three samples Z2 1 Z2 2 and Z2 3 in the prim5 stage.     RNA-Seq TRANSCRIPTOMIC RANDOM PCR PAIRED ILLUMINA Illumina HiSeq 2500   SRP169068     Z1_2_1.fq.gz Z1_2_2.fq.gz fastq fastq 8869328500.0 35477314.0 Z1 2 1.fq.gz 0:125 1:125 A:2367358711;C:2085652811;G:2116692954;T:2298597848;N:1026176 125 125     2367358711 2085652811 2116692954 2298597848 1026176 SRX5016860 SRS4049994 SRA810793 Institute of Hydrobiology, Chinese Academy of Sciences|State Key Laboratory of Freshwater Ecology and Bio Institute of Hydrobiology, Chinese Academy of Sciences 2 0.95776 0.95084 0.01896 0.01811 0.79823 0.79608 0.49565 0.49345 125 125 B B biological fallback assumption illumina hiseq_era unknown random_priming unknown bulk unknown unknown   China 2018-11-18 Multi-stage Embryo Oocyte Reproductive System
49746 49746 SRR8197485 SRX5016859 SRS4049994 SRP169068 PRJNA495892 Danio rerio Genome sequencing PRJNA495892 Whole Genome Sequencing Transcriptome data of zebrafish in two stages of unfertilized egg and prim 5.     three samples of zebrafish unfertilized eggs and three samples zebrafish fries at the stage of prim5. Model organism or animal sample from Danio rerio The transcriptome data of zebrafish in two stages of unfertilized egg and prim 5.   isolate:zebrafish unfertilized eggs and zebrafish fries at the prim5 stage|dev stage:2 stages of unfertilized egg and prim 5|sex:pooled male and female|tissue:zebrafish in 2 stages of unfertilized egg and prim 5|BioSampleModel:Model organism or animal                 RNA Seq of Danio rerio: unfertilized egg Z1 1 F Z1 1 F The unfertilized eggs of zebrafish were taken as three samples Z1 1 Z1 2 and Z1 3 respectively. And the fries of zebrafish were taken as three samples Z2 1 Z2 2 and Z2 3 in the prim5 stage.     RNA-Seq TRANSCRIPTOMIC RANDOM PCR PAIRED ILLUMINA Illumina HiSeq 2500   SRP169068     Z1_1_1.fq.gz Z1_1_2.fq.gz fastq fastq 7205390500.0 28821562.0 Z1 1 1.fq.gz 0:125 1:125 A:1900562357;C:1700185416;G:1728383049;T:1875415232;N:844446 125 125     1900562357 1700185416 1728383049 1875415232 844446 SRX5016859 SRS4049994 SRA810793 Institute of Hydrobiology, Chinese Academy of Sciences|State Key Laboratory of Freshwater Ecology and Bio Institute of Hydrobiology, Chinese Academy of Sciences 2 0.95593 0.95003 0.01844 0.01778 0.80064 0.80008 0.4858 0.48331 125 125 B B biological fallback assumption illumina hiseq_era unknown random_priming unknown bulk unknown unknown   China 2018-11-18 Multi-stage Embryo Oocyte Reproductive System
49747 49747 SRR8197486 SRX5016858 SRS4049994 SRP169068 PRJNA495892 Danio rerio Genome sequencing PRJNA495892 Whole Genome Sequencing Transcriptome data of zebrafish in two stages of unfertilized egg and prim 5.     three samples of zebrafish unfertilized eggs and three samples zebrafish fries at the stage of prim5. Model organism or animal sample from Danio rerio The transcriptome data of zebrafish in two stages of unfertilized egg and prim 5.   isolate:zebrafish unfertilized eggs and zebrafish fries at the prim5 stage|dev stage:2 stages of unfertilized egg and prim 5|sex:pooled male and female|tissue:zebrafish in 2 stages of unfertilized egg and prim 5|BioSampleModel:Model organism or animal                 RNA Seq of Danio rerio: prim5 stage Z2 2 F Z2 2 F The unfertilized eggs of zebrafish were taken as three samples Z1 1 Z1 2 and Z1 3 respectively. And the fries of zebrafish were taken as three samples Z2 1 Z2 2 and Z2 3 in the prim5 stage.     RNA-Seq TRANSCRIPTOMIC RANDOM PCR PAIRED ILLUMINA Illumina HiSeq 2500   SRP169068     Z2_2_2.fq.gz Z2_2_1.fq.gz fastq fastq 7724266250.0 30897065.0 Z2 2 1.fq.gz 0:125 1:125 A:1986625683;C:1864133349;G:1894026843;T:1978566785;N:913590 125 125     1986625683 1864133349 1894026843 1978566785 913590 SRX5016858 SRS4049994 SRA810793 Institute of Hydrobiology, Chinese Academy of Sciences|State Key Laboratory of Freshwater Ecology and Bio Institute of Hydrobiology, Chinese Academy of Sciences 2 0.95577 0.94831 0.01968 0.01899 0.80793 0.80667 0.48789 0.48551 125 125 B B biological fallback assumption illumina hiseq_era unknown random_priming unknown bulk unknown unknown   China 2018-11-16 Multi-stage Embryo Oocyte Reproductive 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");;