RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

run_metadata

11 rows where experiment.library_selection = "RANDOM", experiment.platform = "BGISEQ" and tissue_curation = "Gill"

✎ View and edit SQL

This data as json, CSV (advanced)

tissue_curation_coarse 1

tissue_curation 1

  • Gill · 11 ✖

technology 1

experiment.platform 1

  • BGISEQ · 11 ✖

experiment.library_strategy 1

experiment.library_source 1

experiment.library_selection 1

  • RANDOM · 11 ✖

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
56007 56007 SRR10895915 SRX7564564 SRS6001797 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 002   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:Gill|BioSampleModel:Model organism or animal                 RNA Seq of Danio rerio : adult CL100101924 L01 4 CL100101924 L01 4       RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED BGISEQ BGISEQ-500   SRP241982     CL100101924_L01_542_2.fq.gz CL100101924_L01_542_1.fq.gz fastq fastq 9311999200.0 93119992.0 CL100101924 L01 542 1.fq.gz 0:100 1:100 A:2545207764;C:2065502824;G:2111148485;T:2578747353;N:11392774 100 100     2545207764 2065502824 2111148485 2578747353 11392774 SRX7564564 SRS6001797 SRA1026516 BGI|BGI-Research BGI 1 0.91339   0.10797   0.69792   0.52261   100   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2020-01-15 Adult Adult Gill Respiratory System
56008 56008 SRR10895916 SRX7564563 SRS6001797 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 002   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:Gill|BioSampleModel:Model organism or animal                 RNA Seq of Danio rerio : adult CL100101924 L01 3 CL100101924 L01 3       RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED BGISEQ BGISEQ-500   SRP241982     CL100101924_L01_541_1.fq.gz CL100101924_L01_541_2.fq.gz fastq fastq 10478802600.0 104788026.0 CL100101924 L01 541 1.fq.gz 0:100 1:100 A:2866250643;C:2322460084;G:2375280057;T:2901876128;N:12935688 100 100     2866250643 2322460084 2375280057 2901876128 12935688 SRX7564563 SRS6001797 SRA1026516 BGI|BGI-Research BGI 1 0.9209   0.11359   0.69858   0.53578   100   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2020-01-15 Adult Adult Gill Respiratory System
56009 56009 SRR10895917 SRX7564562 SRS6001797 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 002   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:Gill|BioSampleModel:Model organism or animal                 RNA Seq of Danio rerio : adult CL100101924 L01 2 CL100101924 L01 2       RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED BGISEQ BGISEQ-500   SRP241982     CL100101924_L01_543_1.fq.gz CL100101924_L01_543_2.fq.gz fastq fastq 10370355000.0 103703550.0 CL100101924 L01 543 1.fq.gz 0:100 1:100 A:2824450277;C:2308377166;G:2360285452;T:2864390654;N:12851451 100 100     2824450277 2308377166 2360285452 2864390654 12851451 SRX7564562 SRS6001797 SRA1026516 BGI|BGI-Research BGI 1 0.91018   0.09651   0.70224   0.53831   100   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2020-01-15 Adult Adult Gill Respiratory System
56010 56010 SRR10895918 SRX7564561 SRS6001797 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 002   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:Gill|BioSampleModel:Model organism or animal                 RNA Seq of Danio rerio : adult CL100101924 L01 CL100101924 L01       RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED BGISEQ BGISEQ-500   SRP241982     CL100101924_L01_544_2.fq.gz CL100101924_L01_544_1.fq.gz fastq fastq 8686710000.0 86867100.0 CL100101924 L01 544 1.fq.gz 0:100 1:100 A:2361387592;C:1935295339;G:1982562294;T:2396806096;N:10658679 100 100     2361387592 1935295339 1982562294 2396806096 10658679 SRX7564561 SRS6001797 SRA1026516 BGI|BGI-Research BGI 1 0.90603   0.12145   0.69412   0.52836   100   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2020-01-15 Adult Adult Gill Respiratory System
56011 56011 SRR10895919 SRX7564560 SRS6001797 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 002   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:Gill|BioSampleModel:Model organism or animal                 RNA Seq of Danio rerio : adult CL100103858 L02 CL100103858 L02       RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED BGISEQ BGISEQ-500   SRP241982     CL100103858_L02_530_1.fq.gz CL100103858_L02_530_2.fq.gz fastq fastq 9390776200.0 93907762.0 CL100103858 L02 530 1.fq.gz 0:100 1:100 A:2561256067;C:2084956400;G:2134804271;T:2596713447;N:13046015 100 100     2561256067 2084956400 2134804271 2596713447 13046015 SRX7564560 SRS6001797 SRA1026516 BGI|BGI-Research BGI 1 0.91926   0.11028   0.69485   0.54756   100   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2020-01-15 Adult Adult Gill Respiratory System
63052 63052 SRR13587425 SRX9982120 SRS8153603 SRP303929 PRJNA698005 Danio rerio Raw sequence reads PRJNA698005 Whole Genome Sequencing Danio rerio Raw RNA sequence reads       Model organism or animal sample from Danio rerio The gill of Danio rerio   isolate:river|age:adult|sex:not determined|tissue:gill|BioSampleModel:Model organism or animal                 9ZG 9ZG 9ZG The gill experiment repeat 3 of Danio rerio     RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED BGISEQ BGISEQ-500   SRP303929     9ZG_1.fq.gz 9ZG_2.fq.gz fastq fastq 8056935600.0 53712904.0 9ZG 1.fq.gz 0:150 1:150 A:2282673113;C:1739857627;G:1727599599;T:2306805261;N:0 150 150     2282673113 1739857627 1727599599 2306805261 0 SRX9982120 SRS8153603 SRA1189632 Center for Ecological and Environmental Sciences|Northwestern Polytechnical University Center for Ecological and Environmental Sciences 1 0.89727   0.12013   0.70043   0.53736   150   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2021-01-30 Adult Adult Gill Respiratory System
63053 63053 SRR13587426 SRX9982119 SRS8153603 SRP303929 PRJNA698005 Danio rerio Raw sequence reads PRJNA698005 Whole Genome Sequencing Danio rerio Raw RNA sequence reads       Model organism or animal sample from Danio rerio The gill of Danio rerio   isolate:river|age:adult|sex:not determined|tissue:gill|BioSampleModel:Model organism or animal                 24ZG 24ZG 24ZG The gill control repeat 3 of Danio rerio     RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED BGISEQ BGISEQ-500   SRP303929     24ZG_1.fq.gz 24ZG_2.fq.gz fastq fastq 8223747600.0 54824984.0 24ZG 1.fq.gz 0:150 1:150 A:2300974904;C:1808864978;G:1782331401;T:2331317250;N:259067 150 150     2300974904 1808864978 1782331401 2331317250 259067 SRX9982119 SRS8153603 SRA1189632 Center for Ecological and Environmental Sciences|Northwestern Polytechnical University Center for Ecological and Environmental Sciences 1 0.89723   0.1296   0.69392   0.52375   150   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2021-01-30 Adult Adult Gill Respiratory System
63054 63054 SRR13587427 SRX9982118 SRS8153603 SRP303929 PRJNA698005 Danio rerio Raw sequence reads PRJNA698005 Whole Genome Sequencing Danio rerio Raw RNA sequence reads       Model organism or animal sample from Danio rerio The gill of Danio rerio   isolate:river|age:adult|sex:not determined|tissue:gill|BioSampleModel:Model organism or animal                 8ZG 8ZG 8ZG The gill experiment repeat 2 of Danio rerio     RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED BGISEQ BGISEQ-500   SRP303929     8ZG_1.fq.gz 8ZG_2.fq.gz fastq fastq 8214407100.0 54762714.0 8ZG 1.fq.gz 0:150 1:150 A:2359573564;C:1747625839;G:1728726696;T:2377197140;N:1283861 150 150     2359573564 1747625839 1728726696 2377197140 1283861 SRX9982118 SRS8153603 SRA1189632 Center for Ecological and Environmental Sciences|Northwestern Polytechnical University Center for Ecological and Environmental Sciences 1 0.88408   0.12447   0.72086   0.55321   150   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2021-01-30 Adult Adult Gill Respiratory System
63055 63055 SRR13587428 SRX9982117 SRS8153603 SRP303929 PRJNA698005 Danio rerio Raw sequence reads PRJNA698005 Whole Genome Sequencing Danio rerio Raw RNA sequence reads       Model organism or animal sample from Danio rerio The gill of Danio rerio   isolate:river|age:adult|sex:not determined|tissue:gill|BioSampleModel:Model organism or animal                 19Z G 19Z G 19Z G The gill control repeat 2 of Danio rerio     RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED BGISEQ BGISEQ-500   SRP303929     19Z_G_1.fq.gz 19Z_G_2.fq.gz fastq fastq 8028541200.0 53523608.0 19Z G 1.fq.gz 0:150 1:150 A:2247179404;C:1754236774;G:1743325699;T:2283346353;N:452970 150 150     2247179404 1754236774 1743325699 2283346353 452970 SRX9982117 SRS8153603 SRA1189632 Center for Ecological and Environmental Sciences|Northwestern Polytechnical University Center for Ecological and Environmental Sciences 1 0.89168   0.12028   0.69583   0.53641   150   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2021-01-30 Adult Adult Gill Respiratory System
63056 63056 SRR13587429 SRX9982116 SRS8153603 SRP303929 PRJNA698005 Danio rerio Raw sequence reads PRJNA698005 Whole Genome Sequencing Danio rerio Raw RNA sequence reads       Model organism or animal sample from Danio rerio The gill of Danio rerio   isolate:river|age:adult|sex:not determined|tissue:gill|BioSampleModel:Model organism or animal                 10ZG 10ZG 10ZG The gill experiment repeat 1 of Danio rerio     RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED BGISEQ BGISEQ-500   SRP303929     10ZG_1.fq.gz 10ZG_2.fq.gz fastq fastq 8082344700.0 53882298.0 10ZG 1.fq.gz 0:150 1:150 A:2320760605;C:1718839525;G:1702987067;T:2339757503;N:0 150 150     2320760605 1718839525 1702987067 2339757503 0 SRX9982116 SRS8153603 SRA1189632 Center for Ecological and Environmental Sciences|Northwestern Polytechnical University Center for Ecological and Environmental Sciences 1 0.89032   0.12963   0.70183   0.53117   150   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2021-01-30 Adult Adult Gill Respiratory System
63057 63057 SRR13587430 SRX9982115 SRS8153603 SRP303929 PRJNA698005 Danio rerio Raw sequence reads PRJNA698005 Whole Genome Sequencing Danio rerio Raw RNA sequence reads       Model organism or animal sample from Danio rerio The gill of Danio rerio   isolate:river|age:adult|sex:not determined|tissue:gill|BioSampleModel:Model organism or animal                 10Z G 10Z G 10Z G The gill control repeat 1 of Danio rerio     RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED BGISEQ BGISEQ-500   SRP303929     10Z_G_1.fq.gz 10Z_G_2.fq.gz fastq fastq 8110400400.0 54069336.0 10Z G 1.fq.gz 0:150 1:150 A:2285699758;C:1760759240;G:1749573038;T:2313865140;N:503224 150 150     2285699758 1760759240 1749573038 2313865140 503224 SRX9982115 SRS8153603 SRA1189632 Center for Ecological and Environmental Sciences|Northwestern Polytechnical University Center for Ecological and Environmental Sciences 1 0.88013   0.10821   0.70364   0.55271   150   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2021-01-30 Adult Adult Gill Respiratory 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");;