RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

run_metadata

12 rows where experiment.library_layout = "SINGLE", experiment.library_selection = "RANDOM PCR" and tissue_curation = "Trunk"

✎ View and edit SQL

This data as json, CSV (advanced)

tissue_curation_coarse 1

tissue_curation 1

  • Trunk · 12 ✖

technology 1

experiment.platform 1

experiment.library_strategy 1

experiment.library_source 1

experiment.library_selection 1

  • RANDOM PCR · 12 ✖

experiment.library_layout 1

  • SINGLE · 12 ✖

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
32541 32541 SRR29303120 SRX24820197 SRS21534299 SRP512097 PRJNA1120592 Light induce Zebrafish larvae PRJNA1120592 Other Light induce Zebrafish larvae miRNA         L6H 1 miRNA   breed:zebrafish|cultivar:not applicable|ecotype:AB|age:5 dpf|dev stage:larvae|collection date:2020 10 10|geo loc name:China: Lanzhou|sex:not determined|tissue:whole body|BioSampleModel:Model organism or animal                 miRNA seq of zebrafish larvae L6H 1 L6H 1 miRNA seq     miRNA-Seq TRANSCRIPTOMIC RANDOM PCR SINGLE ILLUMINA Illumina HiSeq 3000   SRP512097     L6H_1.fq.gz fastq 619966455.0 12156205.0 L6H 1.fq.gz 0:51 A:143411079;C:162001488;G:168382605;T:146007422;N:163861 51       143411079 162001488 168382605 146007422 163861 SRX24820197 SRS21534299 SRA1890590 Lanzhou University|College of Life Science Lanzhou University 1 0.01303   0.00337   0.99472   0.5628   51   B   usable mapping rate illumina hiseq_era unknown random_priming unknown bulk unknown unknown   China 2024-06-06 Larval Larval Trunk Surface Structure
32542 32542 SRR29303121 SRX24820196 SRS21534298 SRP512097 PRJNA1120592 Light induce Zebrafish larvae PRJNA1120592 Other Light induce Zebrafish larvae miRNA         L3H 3 miRNA   breed:zebrafish|cultivar:not applicable|ecotype:AB|age:5 dpf|dev stage:larvae|collection date:2020 10 09|geo loc name:China: Lanzhou|sex:not determined|tissue:whole body|BioSampleModel:Model organism or animal                 miRNA seq of zebrafish larvae L3H 3 L3H 3 miRNA seq     miRNA-Seq TRANSCRIPTOMIC RANDOM PCR SINGLE ILLUMINA Illumina HiSeq 3000   SRP512097     L3H_3.fq.gz fastq 738125703.0 14473053.0 L3H 3.fq.gz 0:51 A:176614297;C:190760467;G:197157923;T:173400138;N:192878 51       176614297 190760467 197157923 173400138 192878 SRX24820196 SRS21534298 SRA1890590 Lanzhou University|College of Life Science Lanzhou University 1 0.01163   0.00356   0.99379   0.55469   51   T   under 1.2% mapping rate illumina hiseq_era unknown random_priming unknown bulk unknown unknown   China 2024-06-06 Larval Larval Trunk Surface Structure
32543 32543 SRR29303122 SRX24820195 SRS21534297 SRP512097 PRJNA1120592 Light induce Zebrafish larvae PRJNA1120592 Other Light induce Zebrafish larvae miRNA         L3H 2 miRNA   breed:zebrafish|cultivar:not applicable|ecotype:AB|age:5 dpf|dev stage:larvae|collection date:2020 10 08|geo loc name:China: Lanzhou|sex:not determined|tissue:whole body|BioSampleModel:Model organism or animal                 miRNA seq of zebrafish larvae L3H 2 L3H 2 miRNA seq     miRNA-Seq TRANSCRIPTOMIC RANDOM PCR SINGLE ILLUMINA Illumina HiSeq 3000   SRP512097     L3H_2.fq.gz fastq 489154821.0 9591271.0 L3H 2.fq.gz 0:51 A:109695797;C:132121151;G:127787221;T:119539033;N:11619 51       109695797 132121151 127787221 119539033 11619 SRX24820195 SRS21534297 SRA1890590 Lanzhou University|College of Life Science Lanzhou University 1 0.05359   0.01132   0.98924   0.55364   51   B   usable mapping rate illumina hiseq_era unknown random_priming unknown bulk unknown unknown   China 2024-06-06 Larval Larval Trunk Surface Structure
32544 32544 SRR29303123 SRX24820194 SRS21534296 SRP512097 PRJNA1120592 Light induce Zebrafish larvae PRJNA1120592 Other Light induce Zebrafish larvae miRNA         L3H 1 miRNA   breed:zebrafish|cultivar:not applicable|ecotype:AB|age:5 dpf|dev stage:larvae|collection date:2020 10 07|geo loc name:China: Lanzhou|sex:not determined|tissue:whole body|BioSampleModel:Model organism or animal                 miRNA seq of zebrafish larvae L3H 1 L3H 1 miRNA seq     miRNA-Seq TRANSCRIPTOMIC RANDOM PCR SINGLE ILLUMINA Illumina HiSeq 3000   SRP512097     L3H_1.fq.gz fastq 551502015.0 10813765.0 L3H 1.fq.gz 0:51 A:130437158;C:141969110;G:146479841;T:132605147;N:10759 51       130437158 141969110 146479841 132605147 10759 SRX24820194 SRS21534296 SRA1890590 Lanzhou University|College of Life Science Lanzhou University 1 0.13403   0.01834   0.98735   0.54849   51   B   usable mapping rate illumina hiseq_era unknown random_priming unknown bulk unknown unknown   China 2024-06-06 Larval Larval Trunk Surface Structure
32545 32545 SRR29303124 SRX24820193 SRS21534295 SRP512097 PRJNA1120592 Light induce Zebrafish larvae PRJNA1120592 Other Light induce Zebrafish larvae miRNA         L1H 3 miRNA   breed:zebrafish|cultivar:not applicable|ecotype:AB|age:5 dpf|dev stage:larvae|collection date:2020 10 06|geo loc name:China: Lanzhou|sex:not determined|tissue:whole body|BioSampleModel:Model organism or animal                 miRNA seq of zebrafish larvae L1H 3 L1H 3 miRNA seq     miRNA-Seq TRANSCRIPTOMIC RANDOM PCR SINGLE ILLUMINA Illumina HiSeq 3000   SRP512097     L1H_3.fq.gz fastq 524533827.0 10284977.0 L1H 3.fq.gz 0:51 A:118598837;C:136729611;G:142993590;T:126201873;N:9916 51       118598837 136729611 142993590 126201873 9916 SRX24820193 SRS21534295 SRA1890590 Lanzhou University|College of Life Science Lanzhou University 1 0.00829   0.00187   0.99472   0.54701   51   T   under 1.2% mapping rate illumina hiseq_era unknown random_priming unknown bulk unknown unknown   China 2024-06-06 Larval Larval Trunk Surface Structure
32546 32546 SRR29303125 SRX24820192 SRS21534294 SRP512097 PRJNA1120592 Light induce Zebrafish larvae PRJNA1120592 Other Light induce Zebrafish larvae miRNA         L1H 2 miRNA   breed:zebrafish|cultivar:not applicable|ecotype:AB|age:5 dpf|dev stage:larvae|collection date:2020 10 05|geo loc name:China: Lanzhou|sex:not determined|tissue:whole body|BioSampleModel:Model organism or animal                 miRNA seq of zebrafish larvae L1H 2 L1H 2 miRNA seq     miRNA-Seq TRANSCRIPTOMIC RANDOM PCR SINGLE ILLUMINA Illumina HiSeq 3000   SRP512097     L1H_2.fq.gz fastq 541697163.0 10621513.0 L1H 2.fq.gz 0:51 A:126751483;C:135818134;G:141122995;T:137953543;N:51008 51       126751483 135818134 141122995 137953543 51008 SRX24820192 SRS21534294 SRA1890590 Lanzhou University|College of Life Science Lanzhou University 1 0.33438   0.08101   0.98238   0.53337   51   B   usable mapping rate illumina hiseq_era unknown random_priming unknown bulk unknown unknown   China 2024-06-06 Larval Larval Trunk Surface Structure
32547 32547 SRR29303126 SRX24820191 SRS21534293 SRP512097 PRJNA1120592 Light induce Zebrafish larvae PRJNA1120592 Other Light induce Zebrafish larvae miRNA         L1H 1 miRNA   breed:zebrafish|cultivar:not applicable|ecotype:AB|age:5 dpf|dev stage:larvae|collection date:2020 10 04|geo loc name:China: Lanzhou|sex:not determined|tissue:whole body|BioSampleModel:Model organism or animal                 miRNA seq of zebrafish larvae L1H 1 L1H 1 miRNA seq     miRNA-Seq TRANSCRIPTOMIC RANDOM PCR SINGLE ILLUMINA Illumina HiSeq 3000   SRP512097     L1H_1.fq.gz fastq 930096282.0 18237182.0 L1H 1.fq.gz 0:51 A:212568445;C:243497911;G:260145458;T:213851032;N:33436 51       212568445 243497911 260145458 213851032 33436 SRX24820191 SRS21534293 SRA1890590 Lanzhou University|College of Life Science Lanzhou University 1 0.64143   0.02683   0.98683   0.5342   51   B   usable mapping rate illumina hiseq_era unknown random_priming unknown bulk unknown unknown   China 2024-06-06 Larval Larval Trunk Surface Structure
32548 32548 SRR29303127 SRX24820190 SRS21534292 SRP512097 PRJNA1120592 Light induce Zebrafish larvae PRJNA1120592 Other Light induce Zebrafish larvae miRNA         DD 3 miRNA   breed:zebrafish|cultivar:not applicable|ecotype:AB|age:5 dpf|dev stage:larvae|collection date:2020 10 03|geo loc name:China: Lanzhou|sex:not determined|tissue:whole body|BioSampleModel:Model organism or animal                 miRNA seq of zebrafish larvae DD 3 DD 3 miRNA seq     miRNA-Seq TRANSCRIPTOMIC RANDOM PCR SINGLE ILLUMINA Illumina HiSeq 3000   SRP512097     DD_3.fq.gz fastq 667459389.0 13087439.0 DD 3.fq.gz 0:51 A:157267065;C:168909886;G:178336724;T:162865168;N:80546 51       157267065 168909886 178336724 162865168 80546 SRX24820190 SRS21534292 SRA1890590 Lanzhou University|College of Life Science Lanzhou University 1 0.19375   0.03528   0.98827   0.55124   51   B   usable mapping rate illumina hiseq_era unknown random_priming unknown bulk unknown unknown   China 2024-06-06 Larval Larval Trunk Surface Structure
32549 32549 SRR29303128 SRX24820189 SRS21534291 SRP512097 PRJNA1120592 Light induce Zebrafish larvae PRJNA1120592 Other Light induce Zebrafish larvae miRNA         L6H 3 miRNA   breed:zebrafish|cultivar:not applicable|ecotype:AB|age:5 dpf|dev stage:larvae|collection date:2020 10 12|geo loc name:China: Lanzhou|sex:not determined|tissue:whole body|BioSampleModel:Model organism or animal                 miRNA seq of zebrafish larvae L6H 3 L6H 3 miRNA seq     miRNA-Seq TRANSCRIPTOMIC RANDOM PCR SINGLE ILLUMINA Illumina HiSeq 3000   SRP512097     L6H_3.fq.gz fastq 551181072.0 10807472.0 L6H 3.fq.gz 0:51 A:126813056;C:141881980;G:147676363;T:134665008;N:144665 51       126813056 141881980 147676363 134665008 144665 SRX24820189 SRS21534291 SRA1890590 Lanzhou University|College of Life Science Lanzhou University 1 0.09301   0.01507   0.99042   0.54323   51   B   usable mapping rate illumina hiseq_era unknown random_priming unknown bulk unknown unknown   China 2024-06-06 Larval Larval Trunk Surface Structure
32550 32550 SRR29303129 SRX24820188 SRS21534290 SRP512097 PRJNA1120592 Light induce Zebrafish larvae PRJNA1120592 Other Light induce Zebrafish larvae miRNA         L6H 2 miRNA   breed:zebrafish|cultivar:not applicable|ecotype:AB|age:5 dpf|dev stage:larvae|collection date:2020 10 11|geo loc name:China: Lanzhou|sex:not determined|tissue:whole body|BioSampleModel:Model organism or animal                 miRNA seq of zebrafish larvae L6H 2 L6H 2 miRNA seq     miRNA-Seq TRANSCRIPTOMIC RANDOM PCR SINGLE ILLUMINA Illumina HiSeq 3000   SRP512097     L6H_2.fq.gz fastq 571762632.0 11211032.0 L6H 2.fq.gz 0:51 A:138521192;C:148068464;G:150615597;T:134408189;N:149190 51       138521192 148068464 150615597 134408189 149190 SRX24820188 SRS21534290 SRA1890590 Lanzhou University|College of Life Science Lanzhou University 1 0.01523   0.00336   0.9933   0.57685   51   B   usable mapping rate illumina hiseq_era unknown random_priming unknown bulk unknown unknown   China 2024-06-06 Larval Larval Trunk Surface Structure
32551 32551 SRR29303130 SRX24820187 SRS21534289 SRP512097 PRJNA1120592 Light induce Zebrafish larvae PRJNA1120592 Other Light induce Zebrafish larvae miRNA         DD 2 miRNA   breed:zebrafish|cultivar:not applicable|ecotype:AB|age:5 dpf|dev stage:larvae|collection date:2020 10 02|geo loc name:China: Lanzhou|sex:not determined|tissue:whole body|BioSampleModel:Model organism or animal                 miRNA seq of zebrafish larvae DD 2 DD 2 miRNA seq     miRNA-Seq TRANSCRIPTOMIC RANDOM PCR SINGLE ILLUMINA Illumina HiSeq 3000   SRP512097     DD_2.fq.gz fastq 706940937.0 13861587.0 DD 2.fq.gz 0:51 A:162899595;C:189209828;G:187422113;T:167222837;N:186564 51       162899595 189209828 187422113 167222837 186564 SRX24820187 SRS21534289 SRA1890590 Lanzhou University|College of Life Science Lanzhou University 1 0.02266   0.00566   0.99334   0.56959   51   B   usable mapping rate illumina hiseq_era unknown random_priming unknown bulk unknown unknown   China 2024-06-06 Larval Larval Trunk Surface Structure
32552 32552 SRR29303131 SRX24820186 SRS21534288 SRP512097 PRJNA1120592 Light induce Zebrafish larvae PRJNA1120592 Other Light induce Zebrafish larvae miRNA         DD 1 miRNA   breed:zebrafish|cultivar:not applicable|ecotype:AB|age:5 dpf|dev stage:larvae|collection date:2020 10 01|geo loc name:China: Lanzhou|sex:not determined|tissue:whole body|BioSampleModel:Model organism or animal                 miRNA seq of zebrafish larvae DD 1 DD 1 miRNA seq     miRNA-Seq TRANSCRIPTOMIC RANDOM PCR SINGLE ILLUMINA Illumina HiSeq 3000   SRP512097     DD_1.fq.gz fastq 540332862.0 10594762.0 DD 1.fq.gz 0:51 A:127336994;C:143901414;G:142437491;T:126515166;N:141797 51       127336994 143901414 142437491 126515166 141797 SRX24820186 SRS21534288 SRA1890590 Lanzhou University|College of Life Science Lanzhou University 1 0.01404   0.00313   0.99484   0.56573   51   B   usable mapping rate illumina hiseq_era unknown random_priming unknown bulk unknown unknown   China 2024-06-06 Larval Larval Trunk Surface Structure

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