RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

run_metadata

5 rows where experiment.library_selection = "RANDOM", experiment.platform = "BGISEQ" and tissue_curation_coarse = "Cardiovascular System"

✎ View and edit SQL

This data as json, CSV (advanced)

tissue_curation_coarse 1

  • Cardiovascular System · 5 ✖

tissue_curation 1

technology 1

experiment.platform 1

  • BGISEQ · 5 ✖

experiment.library_strategy 1

experiment.library_source 1

experiment.library_selection 1

  • RANDOM · 5 ✖

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
55977 55977 SRR10895882 SRX7564597 SRS6001804 SRP241982 PRJNA599026 Project of basal ray finned fishes PRJNA599026 Other The project is to study the oldest fish lineages in the ray finned fishes. Although they belong to fish their body structure and behavior remain highly similar to that of the tetrapods. Through comparative genome analysis with living vertebrates we provides insights into the molecular basis of terrestrial adaptation of basal ray finned fishes.   pubmed:33545088;pubmed:12470943     Zebrafish 008   strain:not collected|isolate:not collected|breed:not collected|cultivar:not collected|ecotype:not collected|age:not collected|dev stage:Adult|sex:not determined|tissue:Heart|BioSampleModel:Model organism or animal                 RNA Seq of Danio rerio : adult CL100101924 L01 10 CL100101924 L01 10       RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED BGISEQ BGISEQ-500   SRP241982     CL100101924_L01_545_2.fq.gz CL100101924_L01_545_1.fq.gz fastq fastq 9098943800.0 90989438.0 CL100101924 L01 545 1.fq.gz 0:100 1:100 A:2494855042;C:2016596912;G:2050775890;T:2525488540;N:11227416 100 100     2494855042 2016596912 2050775890 2525488540 11227416 SRX7564597 SRS6001804 SRA1026516 BGI|BGI-Research BGI 1 0.93737   0.07867   0.76061   0.53141   100   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2020-01-15 Adult Adult Heart Cardiovascular System
55978 55978 SRR10895883 SRX7564596 SRS6001804 SRP241982 PRJNA599026 Project of basal ray finned fishes PRJNA599026 Other The project is to study the oldest fish lineages in the ray finned fishes. Although they belong to fish their body structure and behavior remain highly similar to that of the tetrapods. Through comparative genome analysis with living vertebrates we provides insights into the molecular basis of terrestrial adaptation of basal ray finned fishes.   pubmed:33545088;pubmed:12470943     Zebrafish 008   strain:not collected|isolate:not collected|breed:not collected|cultivar:not collected|ecotype:not collected|age:not collected|dev stage:Adult|sex:not determined|tissue:Heart|BioSampleModel:Model organism or animal                 RNA Seq of Danio rerio : adult CL100103178 L01 4 CL100103178 L01 4       RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED BGISEQ BGISEQ-500   SRP241982     CL100103178_L01_570_2.fq.gz CL100103178_L01_570_1.fq.gz fastq fastq 6098551000.0 60985510.0 CL100103178 L01 570 1.fq.gz 0:100 1:100 A:1665824009;C:1362170830;G:1387665851;T:1676412762;N:6477548 100 100     1665824009 1362170830 1387665851 1676412762 6477548 SRX7564596 SRS6001804 SRA1026516 BGI|BGI-Research BGI 1 0.9281   0.07522   0.77715   0.52597   100   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2020-01-15 Adult Adult Heart Cardiovascular System
55979 55979 SRR10895884 SRX7564595 SRS6001804 SRP241982 PRJNA599026 Project of basal ray finned fishes PRJNA599026 Other The project is to study the oldest fish lineages in the ray finned fishes. Although they belong to fish their body structure and behavior remain highly similar to that of the tetrapods. Through comparative genome analysis with living vertebrates we provides insights into the molecular basis of terrestrial adaptation of basal ray finned fishes.   pubmed:33545088;pubmed:12470943     Zebrafish 008   strain:not collected|isolate:not collected|breed:not collected|cultivar:not collected|ecotype:not collected|age:not collected|dev stage:Adult|sex:not determined|tissue:Heart|BioSampleModel:Model organism or animal                 RNA Seq of Danio rerio : adult CL100103178 L01 3 CL100103178 L01 3       RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED BGISEQ BGISEQ-500   SRP241982     CL100103178_L01_568_2.fq.gz CL100103178_L01_568_1.fq.gz fastq fastq 7674097800.0 76740978.0 CL100103178 L01 568 1.fq.gz 0:100 1:100 A:2066126344;C:1741642506;G:1775116741;T:2081782365;N:9429844 100 100     2066126344 1741642506 1775116741 2081782365 9429844 SRX7564595 SRS6001804 SRA1026516 BGI|BGI-Research BGI 1 0.92233   0.07056   0.76029   0.55672   100   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2020-01-15 Adult Adult Heart Cardiovascular System
55980 55980 SRR10895885 SRX7564594 SRS6001804 SRP241982 PRJNA599026 Project of basal ray finned fishes PRJNA599026 Other The project is to study the oldest fish lineages in the ray finned fishes. Although they belong to fish their body structure and behavior remain highly similar to that of the tetrapods. Through comparative genome analysis with living vertebrates we provides insights into the molecular basis of terrestrial adaptation of basal ray finned fishes.   pubmed:33545088;pubmed:12470943     Zebrafish 008   strain:not collected|isolate:not collected|breed:not collected|cultivar:not collected|ecotype:not collected|age:not collected|dev stage:Adult|sex:not determined|tissue:Heart|BioSampleModel:Model organism or animal                 RNA Seq of Danio rerio : adult CL100103178 L01 2 CL100103178 L01 2       RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED BGISEQ BGISEQ-500   SRP241982     CL100103178_L01_569_1.fq.gz CL100103178_L01_569_2.fq.gz fastq fastq 10407446000.0 104074460.0 CL100103178 L01 569 1.fq.gz 0:100 1:100 A:2806156548;C:2359148121;G:2410612409;T:2819342794;N:12186128 100 100     2806156548 2359148121 2410612409 2819342794 12186128 SRX7564594 SRS6001804 SRA1026516 BGI|BGI-Research BGI 1 0.9202   0.06921   0.77384   0.56843   100   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2020-01-15 Adult Adult Heart Cardiovascular System
55981 55981 SRR10895886 SRX7564593 SRS6001804 SRP241982 PRJNA599026 Project of basal ray finned fishes PRJNA599026 Other The project is to study the oldest fish lineages in the ray finned fishes. Although they belong to fish their body structure and behavior remain highly similar to that of the tetrapods. Through comparative genome analysis with living vertebrates we provides insights into the molecular basis of terrestrial adaptation of basal ray finned fishes.   pubmed:33545088;pubmed:12470943     Zebrafish 008   strain:not collected|isolate:not collected|breed:not collected|cultivar:not collected|ecotype:not collected|age:not collected|dev stage:Adult|sex:not determined|tissue:Heart|BioSampleModel:Model organism or animal                 RNA Seq of Danio rerio : adult CL100103178 L01 CL100103178 L01       RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED BGISEQ BGISEQ-500   SRP241982     CL100103178_L01_571_2.fq.gz CL100103178_L01_571_1.fq.gz fastq fastq 8778390800.0 87783908.0 CL100103178 L01 571 1.fq.gz 0:100 1:100 A:2364575734;C:1991773326;G:2031934839;T:2379995507;N:10111394 100 100     2364575734 1991773326 2031934839 2379995507 10111394 SRX7564593 SRS6001804 SRA1026516 BGI|BGI-Research BGI 1 0.92192   0.08454   0.7544   0.53692   100   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2020-01-15 Adult Adult Heart Cardiovascular 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");;