RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

run_metadata

10 rows where experiment.library_selection = "RANDOM", experiment.platform = "BGISEQ" and tissue_curation_coarse = "Surface Structure"

✎ View and edit SQL

This data as json, CSV (advanced)

tissue_curation 2

tissue_curation_coarse 1

  • Surface Structure · 10 ✖

technology 1

experiment.platform 1

  • BGISEQ · 10 ✖

experiment.library_strategy 1

experiment.library_source 1

experiment.library_selection 1

  • RANDOM · 10 ✖

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
55982 55982 SRR10895887 SRX7564592 SRS6001802 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 007   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:Skin|BioSampleModel:Model organism or animal                 RNA Seq of Danio rerio : adult CL100101924 L01 9 CL100101924 L01 9       RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED BGISEQ BGISEQ-500   SRP241982     CL100101924_L01_550_1.fq.gz CL100101924_L01_550_2.fq.gz fastq fastq 8780226200.0 87802262.0 CL100101924 L01 550 1.fq.gz 0:100 1:100 A:2363664067;C:1983383192;G:2025795704;T:2396528723;N:10854514 100 100     2363664067 1983383192 2025795704 2396528723 10854514 SRX7564592 SRS6001802 SRA1026516 BGI|BGI-Research BGI 1 0.92686   0.10085   0.70903   0.51488   100   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2020-01-15 Adult Adult Skin Surface Structure
55983 55983 SRR10895888 SRX7564591 SRS6001802 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 007   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:Skin|BioSampleModel:Model organism or animal                 RNA Seq of Danio rerio : adult CL100101924 L01 8 CL100101924 L01 8       RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED BGISEQ BGISEQ-500   SRP241982     CL100101924_L01_549_2.fq.gz CL100101924_L01_549_1.fq.gz fastq fastq 9805051200.0 98050512.0 CL100101924 L01 549 1.fq.gz 0:100 1:100 A:2663706429;C:2193838939;G:2241619945;T:2693859046;N:12026841 100 100     2663706429 2193838939 2241619945 2693859046 12026841 SRX7564591 SRS6001802 SRA1026516 BGI|BGI-Research BGI 1 0.92652   0.0983   0.71043   0.53401   100   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2020-01-15 Adult Adult Skin Surface Structure
55984 55984 SRR10895889 SRX7564590 SRS6001802 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 007   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:Skin|BioSampleModel:Model organism or animal                 RNA Seq of Danio rerio : adult CL100101924 L01 7 CL100101924 L01 7       RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED BGISEQ BGISEQ-500   SRP241982     CL100101924_L01_547_1.fq.gz CL100101924_L01_547_2.fq.gz fastq fastq 9137587600.0 91375876.0 CL100101924 L01 547 1.fq.gz 0:100 1:100 A:2471506783;C:2052808667;G:2096159921;T:2505897469;N:11214760 100 100     2471506783 2052808667 2096159921 2505897469 11214760 SRX7564590 SRS6001802 SRA1026516 BGI|BGI-Research BGI 1 0.93126   0.09864   0.70613   0.51947   100   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2020-01-15 Adult Adult Skin Surface Structure
55985 55985 SRR10895890 SRX7564589 SRS6001802 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 007   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:Skin|BioSampleModel:Model organism or animal                 RNA Seq of Danio rerio : adult CL100101924 L01 6 CL100101924 L01 6       RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED BGISEQ BGISEQ-500   SRP241982     CL100101924_L01_551_1.fq.gz CL100101924_L01_551_2.fq.gz fastq fastq 7665129600.0 76651296.0 CL100101924 L01 551 1.fq.gz 0:100 1:100 A:2062939973;C:1731950056;G:1768675635;T:2092110510;N:9453426 100 100     2062939973 1731950056 1768675635 2092110510 9453426 SRX7564589 SRS6001802 SRA1026516 BGI|BGI-Research BGI 1 0.93022   0.10662   0.70512   0.50773   100   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2020-01-15 Adult Adult Skin Surface Structure
55986 55986 SRR10895892 SRX7564587 SRS6001802 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 007   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:Skin|BioSampleModel:Model organism or animal                 RNA Seq of Danio rerio : adult CL100101924 L01 5 CL100101924 L01 5       RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED BGISEQ BGISEQ-500   SRP241982     CL100101924_L01_548_1.fq.gz CL100101924_L01_548_2.fq.gz fastq fastq 6527814200.0 65278142.0 CL100101924 L01 548 1.fq.gz 0:100 1:100 A:1748761735;C:1483522306;G:1516468410;T:1771028617;N:8033132 100 100     1748761735 1483522306 1516468410 1771028617 8033132 SRX7564587 SRS6001802 SRA1026516 BGI|BGI-Research BGI 1 0.93149   0.09371   0.70542   0.51664   100   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2020-01-15 Adult Adult Skin Surface Structure
56002 56002 SRR10895909 SRX7564570 SRS6001798 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 003   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:Jaw|BioSampleModel:Model organism or animal                 RNA Seq of Danio rerio : adult CL100103858 L02 6 CL100103858 L02 6       RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED BGISEQ BGISEQ-500   SRP241982     CL100103858_L02_524_1.fq.gz CL100103858_L02_524_2.fq.gz fastq fastq 8863838800.0 88638388.0 CL100103858 L02 524 1.fq.gz 0:100 1:100 A:2346347928;C:2037236505;G:2089998345;T:2378150886;N:12105136 100 100     2346347928 2037236505 2089998345 2378150886 12105136 SRX7564570 SRS6001798 SRA1026516 BGI|BGI-Research BGI 1 0.93198   0.08128   0.74519   0.48951   100   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2020-01-15 Adult Adult Jaw Surface Structure
56003 56003 SRR10895910 SRX7564569 SRS6001798 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 003   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:Jaw|BioSampleModel:Model organism or animal                 RNA Seq of Danio rerio : adult CL100103858 L02 5 CL100103858 L02 5       RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED BGISEQ BGISEQ-500   SRP241982     CL100103858_L02_521_2.fq.gz CL100103858_L02_521_1.fq.gz fastq fastq 10301853000.0 103018530.0 CL100103858 L02 521 1.fq.gz 0:100 1:100 A:2719789797;C:2379371302;G:2435354849;T:2753122052;N:14215000 100 100     2719789797 2379371302 2435354849 2753122052 14215000 SRX7564569 SRS6001798 SRA1026516 BGI|BGI-Research BGI 1 0.93582   0.08016   0.73466   0.4997   100   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2020-01-15 Adult Adult Jaw Surface Structure
56004 56004 SRR10895911 SRX7564568 SRS6001798 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 003   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:Jaw|BioSampleModel:Model organism or animal                 RNA Seq of Danio rerio : adult CL100103858 L02 4 CL100103858 L02 4       RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED BGISEQ BGISEQ-500   SRP241982     CL100103858_L02_522_1.fq.gz CL100103858_L02_522_2.fq.gz fastq fastq 8856151600.0 88561516.0 CL100103858 L02 522 1.fq.gz 0:100 1:100 A:2327973616;C:2055012813;G:2104952956;T:2356113813;N:12098402 100 100     2327973616 2055012813 2104952956 2356113813 12098402 SRX7564568 SRS6001798 SRA1026516 BGI|BGI-Research BGI 1 0.93888   0.07312   0.74337   0.50608   100   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2020-01-15 Adult Adult Jaw Surface Structure
56005 56005 SRR10895912 SRX7564567 SRS6001798 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 003   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:Jaw|BioSampleModel:Model organism or animal                 RNA Seq of Danio rerio : adult CL100103858 L02 3 CL100103858 L02 3       RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED BGISEQ BGISEQ-500   SRP241982     CL100103858_L02_525_1.fq.gz CL100103858_L02_525_2.fq.gz fastq fastq 8393966200.0 83939662.0 CL100103858 L02 525 1.fq.gz 0:100 1:100 A:2205916604;C:1944354784;G:1992482736;T:2239434609;N:11777467 100 100     2205916604 1944354784 1992482736 2239434609 11777467 SRX7564567 SRS6001798 SRA1026516 BGI|BGI-Research BGI 1 0.93522   0.07124   0.73939   0.50385   100   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2020-01-15 Adult Adult Jaw Surface Structure
56006 56006 SRR10895914 SRX7564565 SRS6001798 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 003   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:Jaw|BioSampleModel:Model organism or animal                 RNA Seq of Danio rerio : adult CL100103858 L02 2 CL100103858 L02 2       RNA-Seq TRANSCRIPTOMIC RANDOM PAIRED BGISEQ BGISEQ-500   SRP241982     CL100103858_L02_523_2.fq.gz CL100103858_L02_523_1.fq.gz fastq fastq 9645085400.0 96450854.0 CL100103858 L02 523 1.fq.gz 0:100 1:100 A:2543300716;C:2229112849;G:2282624833;T:2576502560;N:13544442 100 100     2543300716 2229112849 2282624833 2576502560 13544442 SRX7564565 SRS6001798 SRA1026516 BGI|BGI-Research BGI 1 0.93673   0.0738   0.74337   0.49427   100   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2020-01-15 Adult Adult Jaw 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");;