RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

run_metadata

6 rows where experiment.library_selection = "RT-PCR" and tissue_curation_coarse = "Multi-system"

✎ View and edit SQL

This data as json, CSV (advanced)

tissue_curation_coarse 1

  • Multi-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
33373 33373 SRR30168925 SRX25635545 SRS22279934 SRP524879 PRJNA1145574 RNA sequencing of tail fin of zebrafish PRJNA1145574 Other gene expression change post inhibition of HSP90       Ax Ti 3d3 Z Hi 3d3   strain:not applicable|isolate:not applicable|breed:not applicable|cultivar:not applicable|ecotype:not applicable|age:3.5 month|collection date:2022 11 20|geo loc name:missing|sex:not determined|tissue:tail fin|treatment:inhibition 3|BioSampleModel:Model organism or animal                 tail fin regeneration of zebrafish Z Hi 3d3 Z Hi 3d3 cDNA barcode     RNA-Seq TRANSCRIPTOMIC RT-PCR PAIRED ILLUMINA Illumina HiSeq 2500   SRP524879     Z_Hi_3d3_R2.fastq Z_Hi_3d3_R1.fastq fastq fastq 6296371726.0 20848913.0 Z Hi 3d3 R1.fastq 0:151 1:151 A:1704155951;C:1439352121;G:1462544186;T:1690244568;N:74900 151 151     1704155951 1439352121 1462544186 1690244568 74900 SRX25635545 SRS22279934 SRA1942523 Ocean University of China|Department of marine biology Ocean University of China 2 0.9328 0.93327 0.07548 0.07488 0.71985 0.71928 0.5049 0.50889 151 151 B B biological fallback assumption illumina hiseq_era unknown other unknown bulk unknown unknown   China 2024-08-08 Adult Adult Multi-tissue Multi-system
33374 33374 SRR30168926 SRX25635544 SRS22279933 SRP524879 PRJNA1145574 RNA sequencing of tail fin of zebrafish PRJNA1145574 Other gene expression change post inhibition of HSP90       Ax Ti 3d2 Z Hi 3d2   strain:not applicable|isolate:not applicable|breed:not applicable|cultivar:not applicable|ecotype:not applicable|age:3.5 month|collection date:2022 11 20|geo loc name:missing|sex:not determined|tissue:tail fin|treatment:inhibition 2|BioSampleModel:Model organism or animal                 tail fin regeneration of zebrafish Z Hi 3d2 Z Hi 3d2 cDNA barcode     RNA-Seq TRANSCRIPTOMIC RT-PCR PAIRED ILLUMINA Illumina HiSeq 2500   SRP524879     Z_Hi_3d2_R1.fastq Z_Hi_3d2_R2.fastq fastq fastq 6530683862.0 21624781.0 Z Hi 3d2 R1.fastq 0:151 1:151 A:1754695891;C:1502355303;G:1526937743;T:1746614271;N:80654 151 151     1754695891 1502355303 1526937743 1746614271 80654 SRX25635544 SRS22279933 SRA1942523 Ocean University of China|Department of marine biology Ocean University of China 2 0.93139 0.93214 0.08116 0.08178 0.70981 0.70983 0.48395 0.48661 151 151 B B biological fallback assumption illumina hiseq_era unknown other unknown bulk unknown unknown   China 2024-08-08 Adult Adult Multi-tissue Multi-system
33375 33375 SRR30168927 SRX25635543 SRS22279932 SRP524879 PRJNA1145574 RNA sequencing of tail fin of zebrafish PRJNA1145574 Other gene expression change post inhibition of HSP90       Ax Ti 3d1 Z Hi 3d1   strain:not applicable|isolate:not applicable|breed:not applicable|cultivar:not applicable|ecotype:not applicable|age:3.5 month|collection date:2022 11 20|geo loc name:missing|sex:not determined|tissue:tail fin|treatment:inhibition 1|BioSampleModel:Model organism or animal                 tail fin regeneration of zebrafish Z Hi 3d1 Z Hi 3d1 cDNA barcode     RNA-Seq TRANSCRIPTOMIC RT-PCR PAIRED ILLUMINA Illumina HiSeq 2500   SRP524879     Z_Hi_3d1_R1.fastq Z_Hi_3d1_R2.fastq fastq fastq 6160626350.0 20399425.0 Z Hi 3d1 R1.fastq 0:151 1:151 A:1667594818;C:1407434381;G:1429290724;T:1656232741;N:73686 151 151     1667594818 1407434381 1429290724 1656232741 73686 SRX25635543 SRS22279932 SRA1942523 Ocean University of China|Department of marine biology Ocean University of China 2 0.9337 0.93249 0.08009 0.08009 0.71242 0.71338 0.47654 0.47528 151 151 B B biological fallback assumption illumina hiseq_era unknown other unknown bulk unknown unknown   China 2024-08-08 Adult Adult Multi-tissue Multi-system
33376 33376 SRR30168928 SRX25635542 SRS22279930 SRP524879 PRJNA1145574 RNA sequencing of tail fin of zebrafish PRJNA1145574 Other gene expression change post inhibition of HSP90       Ax C 3d3 Z c 3d3   strain:not applicable|isolate:not applicable|breed:not applicable|cultivar:not applicable|ecotype:not applicable|age:3.5 month|collection date:2022 11 20|geo loc name:missing|sex:not determined|tissue:tail fin|treatment:n1 3|BioSampleModel:Model organism or animal                 tail fin regeneration of zebrafish Z c 3d3 Z c 3d3 cDNA barcode     RNA-Seq TRANSCRIPTOMIC RT-PCR PAIRED ILLUMINA Illumina HiSeq 2500   SRP524879     Z_C_3d3_R2.fastq Z_C_3d3_R1.fastq fastq fastq 5810255010.0 19239255.0 Z C 3d3 R1.fastq 0:151 1:151 A:1564226440;C:1336263606;G:1355696622;T:1553998418;N:69924 151 151     1564226440 1336263606 1355696622 1553998418 69924 SRX25635542 SRS22279930 SRA1942523 Ocean University of China|Department of marine biology Ocean University of China 2 0.92958 0.92832 0.07821 0.07745 0.70463 0.70569 0.47036 0.47581 151 151 B B biological fallback assumption illumina hiseq_era unknown other unknown bulk unknown unknown   China 2024-08-08 Adult Adult Multi-tissue Multi-system
33377 33377 SRR30168929 SRX25635541 SRS22279931 SRP524879 PRJNA1145574 RNA sequencing of tail fin of zebrafish PRJNA1145574 Other gene expression change post inhibition of HSP90       Ax C 3d2 Z c 3d2   strain:not applicable|isolate:not applicable|breed:not applicable|cultivar:not applicable|ecotype:not applicable|age:3.5 month|collection date:2022 11 20|geo loc name:missing|sex:not determined|tissue:tail fin|treatment:n1 2|BioSampleModel:Model organism or animal                 tail fin regeneration of zebrafish Z c 3d2 Z c 3d2 cDNA barcode     RNA-Seq TRANSCRIPTOMIC RT-PCR PAIRED ILLUMINA Illumina HiSeq 2500   SRP524879     Z_C_3d2_R2.fastq Z_C_3d2_R1.fastq fastq fastq 6856714606.0 22704353.0 Z C 3d2 R1.fastq 0:151 1:151 A:1850156301;C:1573942247;G:1595025700;T:1837509085;N:81273 151 151     1850156301 1573942247 1595025700 1837509085 81273 SRX25635541 SRS22279931 SRA1942523 Ocean University of China|Department of marine biology Ocean University of China 2 0.92587 0.92539 0.08056 0.08087 0.70343 0.70423 0.48091 0.47768 151 151 B B biological fallback assumption illumina hiseq_era unknown other unknown bulk unknown unknown   China 2024-08-08 Adult Adult Multi-tissue Multi-system
33378 33378 SRR30168930 SRX25635540 SRS22279929 SRP524879 PRJNA1145574 RNA sequencing of tail fin of zebrafish PRJNA1145574 Other gene expression change post inhibition of HSP90       Ax C 3d1 Z c 3d1   strain:not applicable|isolate:not applicable|breed:not applicable|cultivar:not applicable|ecotype:not applicable|age:3.5 month|collection date:2022 11 20|geo loc name:missing|sex:not determined|tissue:tail fin|treatment:n1 1|BioSampleModel:Model organism or animal                 tail fin regeneration of zebrafish Z c 3d1 Z c 3d1 cDNA barcode     RNA-Seq TRANSCRIPTOMIC RT-PCR PAIRED ILLUMINA Illumina HiSeq 2500   SRP524879     Z_C_3d1_R1.fastq Z_C_3d1_R2.fastq fastq fastq 5915874074.0 19588987.0 Z C 3d1 R1.fastq 0:151 1:151 A:1601403264;C:1350219159;G:1374928971;T:1589252208;N:70472 151 151     1601403264 1350219159 1374928971 1589252208 70472 SRX25635540 SRS22279929 SRA1942523 Ocean University of China|Department of marine biology Ocean University of China 2 0.92552 0.92878 0.07906 0.07985 0.70264 0.70323 0.48016 0.48019 151 151 B B biological fallback assumption illumina hiseq_era unknown other unknown bulk unknown unknown   China 2024-08-08 Adult Adult Multi-tissue Multi-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");;