RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

run_metadata

6 rows where experiment.library_layout = "SINGLE", experiment.platform = "BGISEQ" and tissue_curation_coarse = "Digestive System"

✎ View and edit SQL

This data as json, CSV (advanced)

tissue_curation_coarse 1

  • Digestive System · 6 ✖

tissue_curation 1

technology 1

experiment.platform 1

  • BGISEQ · 6 ✖

experiment.library_strategy 1

experiment.library_source 1

experiment.library_selection 1

experiment.library_layout 1

  • SINGLE · 6 ✖

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
60007 60007 SRR12109607 SRX8633610 SRS6920345 SRP269241 PRJNA641989 Zebrafish intestinal SmallRNA PRJNA641989 Other A model of streptococcus agalactiae infected zebrafish was established to determine intestinal small RNA of zebrafish.To explore the molecular mechanism of antibacterial immunity of zebrafish.         Drt3   strain:Streptococcus agalactiae|age:adult|sex:male|tissue:gut|BioSampleModel:Model organism or animal                 miRNA Seq of zebrafish intestine F F BGISEQ     miRNA-Seq TRANSCRIPTOMIC RT-PCR SINGLE BGISEQ BGISEQ-500   SRP269241   loader:fastq load.py Drt3.fq.gz fastq 953116651.0 39450392.0 Drt3.fq.gz 0:24.16 A:165275545;C:266933722;G:285524079;T:235383107;N:198 24       165275545 266933722 285524079 235383107 198 SRX8633610 SRS6920345 SRA1092425 Kunming University of Science and Technology|faculty of life science and technology Kunming University of Science and Technology 1 0.86243   0.21541   0.80294   0.67181   29   B   usable mapping rate bgi bgi unknown small_rna unknown bulk unknown unknown   China 2020-07-10 Adult Adult Gut Digestive System
60008 60008 SRR12109608 SRX8633609 SRS6920344 SRP269241 PRJNA641989 Zebrafish intestinal SmallRNA PRJNA641989 Other A model of streptococcus agalactiae infected zebrafish was established to determine intestinal small RNA of zebrafish.To explore the molecular mechanism of antibacterial immunity of zebrafish.         Drt2   strain:Streptococcus agalactiae|age:adult|sex:male|tissue:gut|BioSampleModel:Model organism or animal                 miRNA Seq of zebrafish intestine E E BGISEQ     miRNA-Seq TRANSCRIPTOMIC RT-PCR SINGLE BGISEQ BGISEQ-500   SRP269241   loader:fastq load.py Drt2.fq.gz fastq 629335361.0 26037543.0 Drt2.fq.gz 0:24.17 A:111827613;C:172564695;G:192159133;T:152783892;N:28 24       111827613 172564695 192159133 152783892 28 SRX8633609 SRS6920344 SRA1092425 Kunming University of Science and Technology|faculty of life science and technology Kunming University of Science and Technology 1 0.86328   0.21943   0.7992   0.64786   26   B   usable mapping rate bgi bgi unknown small_rna unknown bulk unknown unknown   China 2020-07-10 Adult Adult Gut Digestive System
60009 60009 SRR12109609 SRX8633608 SRS6920343 SRP269241 PRJNA641989 Zebrafish intestinal SmallRNA PRJNA641989 Other A model of streptococcus agalactiae infected zebrafish was established to determine intestinal small RNA of zebrafish.To explore the molecular mechanism of antibacterial immunity of zebrafish.         Drt1   strain:Streptococcus agalactiae|age:adult|sex:male|tissue:gut|BioSampleModel:Model organism or animal                 miRNA Seq of zebrafish intestine D D BGISEQ     miRNA-Seq TRANSCRIPTOMIC RT-PCR SINGLE BGISEQ BGISEQ-500   SRP269241   loader:fastq load.py Drt1.fq.gz fastq 898185854.0 37273958.0 Drt1.fq.gz 0:24.10 A:155257170;C:247725871;G:276963807;T:218238980;N:26 24       155257170 247725871 276963807 218238980 26 SRX8633608 SRS6920343 SRA1092425 Kunming University of Science and Technology|faculty of life science and technology Kunming University of Science and Technology 1 0.86686   0.21764   0.79508   0.6694   24   B   usable mapping rate bgi bgi unknown small_rna unknown bulk unknown unknown   China 2020-07-10 Adult Adult Gut Digestive System
60010 60010 SRR12109610 SRX8633607 SRS6920342 SRP269241 PRJNA641989 Zebrafish intestinal SmallRNA PRJNA641989 Other A model of streptococcus agalactiae infected zebrafish was established to determine intestinal small RNA of zebrafish.To explore the molecular mechanism of antibacterial immunity of zebrafish.         Drc3   strain:Streptococcus agalactiae|age:adult|sex:male|tissue:gut|BioSampleModel:Model organism or animal                 miRNA Seq of zebrafish intestine C C BGISEQ     miRNA-Seq TRANSCRIPTOMIC RT-PCR SINGLE BGISEQ BGISEQ-500   SRP269241   loader:fastq load.py Drc3.fq.gz fastq 912782161.0 35931507.0 Drc3.fq.gz 0:25.40 A:153448479;C:252628189;G:280829895;T:225874586;N:1012 25       153448479 252628189 280829895 225874586 1012 SRX8633607 SRS6920342 SRA1092425 Kunming University of Science and Technology|faculty of life science and technology Kunming University of Science and Technology 1 0.89797   0.21308   0.80823   0.62611   23   B   usable mapping rate bgi bgi unknown small_rna unknown bulk unknown unknown   China 2020-07-10 Adult Adult Gut Digestive System
60011 60011 SRR12109611 SRX8633606 SRS6920341 SRP269241 PRJNA641989 Zebrafish intestinal SmallRNA PRJNA641989 Other A model of streptococcus agalactiae infected zebrafish was established to determine intestinal small RNA of zebrafish.To explore the molecular mechanism of antibacterial immunity of zebrafish.         Drc2   strain:Streptococcus agalactiae|age:adult|sex:male|tissue:gut|BioSampleModel:Model organism or animal                 miRNA Seq of zebrafish intestine B B BGISEQ     miRNA-Seq TRANSCRIPTOMIC RT-PCR SINGLE BGISEQ BGISEQ-500   SRP269241   loader:fastq load.py Drc2.fq.gz fastq 784553020.0 31429473.0 Drc2.fq.gz 0:24.96 A:128271350;C:223302609;G:241310233;T:191668193;N:635 24       128271350 223302609 241310233 191668193 635 SRX8633606 SRS6920341 SRA1092425 Kunming University of Science and Technology|faculty of life science and technology Kunming University of Science and Technology 1 0.9087   0.20487   0.80805   0.67324   30   B   usable mapping rate bgi bgi unknown small_rna unknown bulk unknown unknown   China 2020-07-10 Adult Adult Gut Digestive System
60012 60012 SRR12109612 SRX8633605 SRS6920340 SRP269241 PRJNA641989 Zebrafish intestinal SmallRNA PRJNA641989 Other A model of streptococcus agalactiae infected zebrafish was established to determine intestinal small RNA of zebrafish.To explore the molecular mechanism of antibacterial immunity of zebrafish.         Drc1   strain:Streptococcus agalactiae|age:adult|sex:male|tissue:gut|BioSampleModel:Model organism or animal                 miRNA Seq of zebrafish intestine A A BGISEQ     miRNA-Seq TRANSCRIPTOMIC RT-PCR SINGLE BGISEQ BGISEQ-500   SRP269241   loader:fastq load.py Drc1.fq.gz fastq 814894343.0 32234530.0 Drc1.fq.gz 0:25.28 A:133616147;C:230834630;G:253965304;T:196477437;N:825 25       133616147 230834630 253965304 196477437 825 SRX8633605 SRS6920340 SRA1092425 Kunming University of Science and Technology|faculty of life science and technology Kunming University of Science and Technology 1 0.89344   0.21273   0.80738   0.66815   28   B   usable mapping rate bgi bgi unknown small_rna unknown bulk unknown unknown   China 2020-07-10 Adult Adult Gut Digestive 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");;