RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

run_metadata

6 rows where experiment.library_strategy = "miRNA-Seq", experiment.platform = "BGISEQ" and tissue_curation_coarse = "All anatomical structures"

✎ View and edit SQL

This data as json, CSV (advanced)

tissue_curation_coarse 1

  • All anatomical structures · 6 ✖

tissue_curation 1

technology 1

experiment.platform 1

  • BGISEQ · 6 ✖

experiment.library_strategy 1

  • miRNA-Seq · 6 ✖

experiment.library_source 1

experiment.library_selection 1

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
60445 60445 SRR12272862 SRX8777892 SRS7048444 SRP272672 PRJNA647444 mRNA and miRNA Seq in offspring post parental exposure to an antibiotic mixturemiRNA PRJNA647444 Other Zebrafish embryos were exposed to environmentally relevant levels 1 and 100 ug/L of antibiotic mixtures 15 of the most commonly detected antibiotics for 150 days until sexual maturation. miRNA mRNA network analysis in offspring post parental exposure to an antibiotic mixture.       C2 C2 C2 2 4   replicate:biological replicate 2|strain:AB|isolate:C2|breed:not applicable|cultivar:not applicable|ecotype:not applicable|age:not applicable|dev stage:not applicable|sex:pooled male and female|tissue:the whole|collection date:2019 11 01|geo loc name:China: Shenzhen Guangdong|phenotype:100ug/L|BioSampleModel:Model organism or animal                 RNA seq of zebrafish C2C220200712 C2C220200712 RNA seq of zebrafish in different conditions     miRNA-Seq TRANSCRIPTOMIC RANDOM PCR SINGLE BGISEQ BGISEQ-500   SRP272672   loader:fastq load.py C2_C2_2_4.fq fastq 542610936.0 21965958.0 C2 C2 2 4.fq.gz 0:24.70 A:95221617;C:122628624;G:167025611;T:157730855;N:4229 24       95221617 122628624 167025611 157730855 4229 SRX8777892 SRS7048444 SRA1101037 Southern University of Science and Technology|School of Environmental Science and Engineering Southern University of Science and Technology 1 0.8119   0.10745   0.85717   0.51338   22   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2020-08-05 Undetermined Embryo Whole Organism All anatomical structures
60446 60446 SRR12272863 SRX8777891 SRS7048443 SRP272672 PRJNA647444 mRNA and miRNA Seq in offspring post parental exposure to an antibiotic mixturemiRNA PRJNA647444 Other Zebrafish embryos were exposed to environmentally relevant levels 1 and 100 ug/L of antibiotic mixtures 15 of the most commonly detected antibiotics for 150 days until sexual maturation. miRNA mRNA network analysis in offspring post parental exposure to an antibiotic mixture.       C2 C2 C2 1 4   replicate:biological replicate 1|strain:AB|isolate:C2|breed:not applicable|cultivar:not applicable|ecotype:not applicable|age:not applicable|dev stage:not applicable|sex:pooled male and female|tissue:the whole|collection date:2019 11 01|geo loc name:China: Shenzhen Guangdong|phenotype:100ug/L|BioSampleModel:Model organism or animal                 RNA seq of zebrafish C2C220200711 C2C220200711 RNA seq of zebrafish in different conditions     miRNA-Seq TRANSCRIPTOMIC RANDOM PCR SINGLE BGISEQ BGISEQ-500   SRP272672   loader:fastq load.py C2_C2_1_4.fq fastq 542847476.0 22614181.0 C2 C2 1 4.fq.gz 0:24.00 A:99999101;C:125407906;G:162383758;T:155055099;N:1612 24       99999101 125407906 162383758 155055099 1612 SRX8777891 SRS7048443 SRA1101037 Southern University of Science and Technology|School of Environmental Science and Engineering Southern University of Science and Technology 1 0.84327   0.10491   0.83256   0.52046   19   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2020-08-05 Undetermined Embryo Whole Organism All anatomical structures
60447 60447 SRR12272864 SRX8777890 SRS7048442 SRP272672 PRJNA647444 mRNA and miRNA Seq in offspring post parental exposure to an antibiotic mixturemiRNA PRJNA647444 Other Zebrafish embryos were exposed to environmentally relevant levels 1 and 100 ug/L of antibiotic mixtures 15 of the most commonly detected antibiotics for 150 days until sexual maturation. miRNA mRNA network analysis in offspring post parental exposure to an antibiotic mixture.       C1 C1 C1 2 4   replicate:biological replicate 2|strain:AB|isolate:C1|breed:not applicable|cultivar:not applicable|ecotype:not applicable|age:not applicable|dev stage:not applicable|sex:pooled male and female|tissue:the whole|collection date:2019 11 01|geo loc name:China: Shenzhen Guangdong|phenotype:1ug/L|BioSampleModel:Model organism or animal                 RNA seq of zebrafish C1C120200712 C1C120200712 RNA seq of zebrafish in different conditions     miRNA-Seq TRANSCRIPTOMIC RANDOM PCR SINGLE BGISEQ BGISEQ-500   SRP272672   loader:fastq load.py C1_C1_2_4.fq fastq 570918284.0 22577002.0 C1 C1 2 4.fq.gz 0:25.29 A:100121235;C:130480588;G:178656113;T:161652765;N:7583 25       100121235 130480588 178656113 161652765 7583 SRX8777890 SRS7048442 SRA1101037 Southern University of Science and Technology|School of Environmental Science and Engineering Southern University of Science and Technology 1 0.85096   0.12542   0.82873   0.51535   22   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2020-08-05 Undetermined Embryo Whole Organism All anatomical structures
60448 60448 SRR12272865 SRX8777889 SRS7048441 SRP272672 PRJNA647444 mRNA and miRNA Seq in offspring post parental exposure to an antibiotic mixturemiRNA PRJNA647444 Other Zebrafish embryos were exposed to environmentally relevant levels 1 and 100 ug/L of antibiotic mixtures 15 of the most commonly detected antibiotics for 150 days until sexual maturation. miRNA mRNA network analysis in offspring post parental exposure to an antibiotic mixture.       C1 C1 C1 1 4   replicate:biological replicate 1|strain:AB|isolate:C1|breed:not applicable|cultivar:not applicable|ecotype:not applicable|age:not applicable|dev stage:not applicable|sex:pooled male and female|tissue:the whole|collection date:2019 11 01|geo loc name:China: Shenzhen Guangdong|phenotype:1ug/L|BioSampleModel:Model organism or animal                 RNA seq of zebrafish C1C120200711 C1C120200711 RNA seq of zebrafish in different conditions     miRNA-Seq TRANSCRIPTOMIC RANDOM PCR SINGLE BGISEQ BGISEQ-500   SRP272672   loader:fastq load.py C1_C1_1_4.fq fastq 545089417.0 22812164.0 C1 C1 1 4.fq.gz 0:23.89 A:99851844;C:125314095;G:166401335;T:153521167;N:976 23       99851844 125314095 166401335 153521167 976 SRX8777889 SRS7048441 SRA1101037 Southern University of Science and Technology|School of Environmental Science and Engineering Southern University of Science and Technology 1 0.84602   0.11725   0.83159   0.51353   19   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2020-08-05 Undetermined Embryo Whole Organism All anatomical structures
60449 60449 SRR12272866 SRX8777888 SRS7048440 SRP272672 PRJNA647444 mRNA and miRNA Seq in offspring post parental exposure to an antibiotic mixturemiRNA PRJNA647444 Other Zebrafish embryos were exposed to environmentally relevant levels 1 and 100 ug/L of antibiotic mixtures 15 of the most commonly detected antibiotics for 150 days until sexual maturation. miRNA mRNA network analysis in offspring post parental exposure to an antibiotic mixture.       C0 C0 C0 2 4   replicate:biological replicate 2|strain:AB|isolate:C0|breed:not applicable|cultivar:not applicable|ecotype:not applicable|age:not applicable|dev stage:not applicable|sex:pooled male and female|tissue:the whole|collection date:2019 11 01|geo loc name:China: Shenzhen Guangdong|phenotype:0ug/L|BioSampleModel:Model organism or animal                 RNA seq of zebrafish C0C020200712 C0C020200712 RNA seq of zebrafish in different conditions     miRNA-Seq TRANSCRIPTOMIC RANDOM PCR SINGLE BGISEQ BGISEQ-500   SRP272672   loader:fastq load.py C0_C0_2_4.fq fastq 527443144.0 23174740.0 C0 C0 2 4.fq.gz 0:22.76 A:102368401;C:120843229;G:151690193;T:152540806;N:515 22       102368401 120843229 151690193 152540806 515 SRX8777888 SRS7048440 SRA1101037 Southern University of Science and Technology|School of Environmental Science and Engineering Southern University of Science and Technology 1 0.83063   0.08114   0.85169   0.50894   16   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2020-08-05 Undetermined Embryo Whole Organism All anatomical structures
60450 60450 SRR12272867 SRX8777887 SRS7048439 SRP272672 PRJNA647444 mRNA and miRNA Seq in offspring post parental exposure to an antibiotic mixturemiRNA PRJNA647444 Other Zebrafish embryos were exposed to environmentally relevant levels 1 and 100 ug/L of antibiotic mixtures 15 of the most commonly detected antibiotics for 150 days until sexual maturation. miRNA mRNA network analysis in offspring post parental exposure to an antibiotic mixture.       C0 C0 C0 1 4   replicate:biological replicate 1|strain:AB|isolate:C0|breed:not applicable|cultivar:not applicable|ecotype:not applicable|age:not applicable|dev stage:not applicable|sex:pooled male and female|tissue:the whole|collection date:2019 11 01|geo loc name:China: Shenzhen Guangdong|phenotype:0ug/L|BioSampleModel:Model organism or animal                 RNA seq of zebrafish C0C020200711 C0C020200711 RNA seq of zebrafish in different conditions     miRNA-Seq TRANSCRIPTOMIC RANDOM PCR SINGLE BGISEQ BGISEQ-500   SRP272672   loader:fastq load.py C0_C0_1_4.fq fastq 511759408.0 22673361.0 C0 C0 1 4.fq.gz 0:22.57 A:100879182;C:120237907;G:142799495;T:147842595;N:229 22       100879182 120237907 142799495 147842595 229 SRX8777887 SRS7048439 SRA1101037 Southern University of Science and Technology|School of Environmental Science and Engineering Southern University of Science and Technology 1 0.83904   0.0823   0.84741   0.49929   22   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2020-08-05 Undetermined Embryo 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");;