RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

run_metadata

5 rows where experiment.library_layout = "PAIRED", experiment.library_selection = "RANDOM" and tissue_curation = "Spinal Cord"

✎ View and edit SQL

This data as json, CSV (advanced)

tissue_curation_coarse 1

tissue_curation 1

  • Spinal Cord · 5 ✖

technology 1

experiment.platform 1

experiment.library_strategy 1

experiment.library_source 1

experiment.library_selection 1

  • RANDOM · 5 ✖

experiment.library_layout 1

  • PAIRED · 5 ✖

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
55972 55972 SRR10895875 SRX7564604 SRS6001805 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 009   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:Spinal cord|BioSampleModel:Model organism or animal                 RNA Seq of Danio rerio : adult CL100103178 L01 9 CL100103178 L01 9       RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED BGISEQ BGISEQ-500   SRP241982     CL100103178_L01_567_1.fq.gz CL100103178_L01_567_2.fq.gz fastq fastq 7926659000.0 79266590.0 CL100103178 L01 567 1.fq.gz 0:100 1:100 A:2177233520;C:1750763335;G:1793690428;T:2195598681;N:9373036 100 100     2177233520 1750763335 1793690428 2195598681 9373036 SRX7564604 SRS6001805 SRA1026516 BGI|BGI-Research BGI 1 0.90731   0.11069   0.70548   0.53521   100   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2020-01-15 Adult Adult Spinal Cord Nervous System
55973 55973 SRR10895876 SRX7564603 SRS6001805 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 009   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:Spinal cord|BioSampleModel:Model organism or animal                 RNA Seq of Danio rerio : adult CL100103178 L01 8 CL100103178 L01 8       RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED BGISEQ BGISEQ-500   SRP241982     CL100103178_L01_563_1.fq.gz CL100103178_L01_563_2.fq.gz fastq fastq 9981278800.0 99812788.0 CL100103178 L01 563 1.fq.gz 0:100 1:100 A:2753622693;C:2192952746;G:2243702494;T:2779006876;N:11993991 100 100     2753622693 2192952746 2243702494 2779006876 11993991 SRX7564603 SRS6001805 SRA1026516 BGI|BGI-Research BGI 1 0.90715   0.11372   0.71467   0.5089   100   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2020-01-15 Adult Adult Spinal Cord Nervous System
55974 55974 SRR10895877 SRX7564602 SRS6001805 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 009   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:Spinal cord|BioSampleModel:Model organism or animal                 RNA Seq of Danio rerio : adult CL100103178 L01 7 CL100103178 L01 7       RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED BGISEQ BGISEQ-500   SRP241982     CL100103178_L01_562_1.fq.gz CL100103178_L01_562_2.fq.gz fastq fastq 8857552800.0 88575528.0 CL100103178 L01 562 1.fq.gz 0:100 1:100 A:2418167382;C:1969456035;G:2015821568;T:2442764114;N:11343701 100 100     2418167382 1969456035 2015821568 2442764114 11343701 SRX7564602 SRS6001805 SRA1026516 BGI|BGI-Research BGI 1 0.90895   0.10978   0.71336   0.50272   100   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2020-01-15 Adult Adult Spinal Cord Nervous System
55975 55975 SRR10895878 SRX7564601 SRS6001805 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 009   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:Spinal cord|BioSampleModel:Model organism or animal                 RNA Seq of Danio rerio : adult CL100103178 L01 6 CL100103178 L01 6       RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED BGISEQ BGISEQ-500   SRP241982     CL100103178_L01_564_1.fq.gz CL100103178_L01_564_2.fq.gz fastq fastq 7468499200.0 74684992.0 CL100103178 L01 564 1.fq.gz 0:100 1:100 A:2052720985;C:1649448011;G:1690698471;T:2068073830;N:7557903 100 100     2052720985 1649448011 1690698471 2068073830 7557903 SRX7564601 SRS6001805 SRA1026516 BGI|BGI-Research BGI 1 0.90905   0.10883   0.69578   0.54193   100   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2020-01-15 Adult Adult Spinal Cord Nervous System
55976 55976 SRR10895881 SRX7564598 SRS6001805 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 009   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:Spinal cord|BioSampleModel:Model organism or animal                 RNA Seq of Danio rerio : adult CL100103178 L01 5 CL100103178 L01 5       RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED BGISEQ BGISEQ-500   SRP241982     CL100103178_L01_561_1.fq.gz CL100103178_L01_561_2.fq.gz fastq fastq 9173572800.0 91735728.0 CL100103178 L01 561 1.fq.gz 0:100 1:100 A:2527132650;C:2020739240;G:2066720461;T:2548747865;N:10232584 100 100     2527132650 2020739240 2066720461 2548747865 10232584 SRX7564598 SRS6001805 SRA1026516 BGI|BGI-Research BGI 1 0.91539   0.11063   0.71427   0.48162   100   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2020-01-15 Adult Adult Spinal Cord Nervous 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");;