run_metadata
2 rows where experiment.platform = "ION_TORRENT", tissue_curation = "Multi-tissue" and tissue_curation_coarse = "Multi-system"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 59501 | 59501 | SRR11924323 | SRX8469995 | SRS6770646 | SRP265951 | PRJNA637293 | The shift from early to late types of ribosomes in zebrafish development involves changes at a subset of rRNA 2' O Me sites | GSE151797 | Other | A sequencing based profiling method RiboMeth seq for ribose methylations was used to study methylation patterns during Zebrafish Danio rerio development Overall design: All samples were analyzed in biological triplicates except for adult tail trunk that was in duplicate. | pubmed:32912962 | Adult tail 2 | GSM4591062 | source name:adult tail trunk|tissue:adult tail trunk|rna fraction:size fractionated 20 40 nt whole cell RNA | Adult tail 2 | Library strategy: RiboMeth seq Barcode separation using python script Adaptor trimming using Cutadapt v. 2.0 Mapping to rRNA reference sequence using Bowtie2 v. 2.3.4.1 Counting read ends and calculating RiboMeth seq scores using python scripts The output FASTA files from small RNA seq were merged and used as the basis of the SNORD search and rRNA interaction prediction. Initially SNORDs were identified by running the merged FASTA file through snoScan Schattner et al. 2005 against zebrafish early and late rRNA reference sequences Locati et al. 2017. Genome build: early and late zebrafish rRNA locati et al. The reference sequences are available in the FASTA file on the series record. Supplementary files format and content: MS Excel file contains five prime and three prime read count and calculated RiboMeth seq score at all positions in the rRNA sequence. | adult tail trunk | Tissues were homogenized and whole cell RNA was extracted using Qiazol Qiagen according to the manufacturer. RiboMeth seq: 5 10 ug of RNA was partially degraded by alkaline at denaturing temperatures. The size fraction 20 40 nt was purified on gels and linkers added using a system relying on a modified Arabidopsis tRNA ligase joining 2' three prime cyclic phosphate and five prime phosphate ends. The library fragments were then sequenced on the Ion Proton platform. See Birkedal U Christensen Dalsgaard M Krogh N Sabarinathan R Gorodkin J Nielsen H. Profiling of ribose methylations in RNA by high throughput sequencing. Angewandte Chemie. 2015;542:451 5 for detailed description | tissue:adult tail trunk|rna fraction:size fractionated 20 40 nt whole cell RNA | GSM4591062 | GSM4591062: Adult tail 2; Danio rerio; OTHER | GSM4591062 | 1 | Tissues were homogenized and whole cell RNA was extracted using Qiazol Qiagen according to the manufacturer. RiboMeth seq: 5 10 ug of RNA was partially degraded by alkaline at denaturing temperatures. The size fraction 20 40 nt was purified on gels and linkers added using a system relying on a modified Arabidopsis tRNA ligase joining 2' three prime cyclic phosphate and five prime phosphate ends. The library fragments were then sequenced on the Ion Proton platform. See Birkedal U Christensen Dalsgaard M Krogh N Sabarinathan R Gorodkin J Nielsen H. Profiling of ribose methylations in RNA by high throughput sequencing. Angewandte Chemie. 2015;542:451 5 for detailed description | GEO Accession:GSM4591062 | OTHER | TRANSCRIPTOMIC | other | SINGLE | ION_TORRENT | Ion Torrent Proton | SRP265951 | intentional duplicate | Adult_tail_2.bam GSE151797_Reference_sequence.fa | bam bam | 156647953.0 | 5517527.0 | GSM4591062 r1 | 0:28.39 | A:32903673;C:49609293;G:39096775;T:35038212;N:0 | 28 | 32903673 | 49609293 | 39096775 | 35038212 | 0 | SRX8469995 | SRS6770646 | SRA1083099 | GEO | RNA Group - Prof. Henrik Nielsen, Department of Cellular and Molecular Medicine, University of Copenhagen | 1 | 0.80662 | 0.20653 | 0.88722 | 0.58074 | 37 | B | usable mapping rate | ion_torrent | ion_torrent | 5prime | small_rna | unknown | bulk | unknown | unknown | Denmark | 2020-06-04 | Adult | Adult | Multi-tissue | Multi-system | ||||||||||||||||||
| 59502 | 59502 | SRR11924321 | SRX8469994 | SRS6770645 | SRP265951 | PRJNA637293 | The shift from early to late types of ribosomes in zebrafish development involves changes at a subset of rRNA 2' O Me sites | GSE151797 | Other | A sequencing based profiling method RiboMeth seq for ribose methylations was used to study methylation patterns during Zebrafish Danio rerio development Overall design: All samples were analyzed in biological triplicates except for adult tail trunk that was in duplicate. | pubmed:32912962 | Adult tail 1 | GSM4591061 | source name:adult tail trunk|tissue:adult tail trunk|rna fraction:size fractionated 20 40 nt whole cell RNA | Adult tail 1 | Library strategy: RiboMeth seq Barcode separation using python script Adaptor trimming using Cutadapt v. 2.0 Mapping to rRNA reference sequence using Bowtie2 v. 2.3.4.1 Counting read ends and calculating RiboMeth seq scores using python scripts The output FASTA files from small RNA seq were merged and used as the basis of the SNORD search and rRNA interaction prediction. Initially SNORDs were identified by running the merged FASTA file through snoScan Schattner et al. 2005 against zebrafish early and late rRNA reference sequences Locati et al. 2017. Genome build: early and late zebrafish rRNA locati et al. The reference sequences are available in the FASTA file on the series record. Supplementary files format and content: MS Excel file contains five prime and three prime read count and calculated RiboMeth seq score at all positions in the rRNA sequence. | adult tail trunk | Tissues were homogenized and whole cell RNA was extracted using Qiazol Qiagen according to the manufacturer. RiboMeth seq: 5 10 ug of RNA was partially degraded by alkaline at denaturing temperatures. The size fraction 20 40 nt was purified on gels and linkers added using a system relying on a modified Arabidopsis tRNA ligase joining 2' three prime cyclic phosphate and five prime phosphate ends. The library fragments were then sequenced on the Ion Proton platform. See Birkedal U Christensen Dalsgaard M Krogh N Sabarinathan R Gorodkin J Nielsen H. Profiling of ribose methylations in RNA by high throughput sequencing. Angewandte Chemie. 2015;542:451 5 for detailed description | tissue:adult tail trunk|rna fraction:size fractionated 20 40 nt whole cell RNA | GSM4591061 | GSM4591061: Adult tail 1; Danio rerio; OTHER | GSM4591061 | 1 | Tissues were homogenized and whole cell RNA was extracted using Qiazol Qiagen according to the manufacturer. RiboMeth seq: 5 10 ug of RNA was partially degraded by alkaline at denaturing temperatures. The size fraction 20 40 nt was purified on gels and linkers added using a system relying on a modified Arabidopsis tRNA ligase joining 2' three prime cyclic phosphate and five prime phosphate ends. The library fragments were then sequenced on the Ion Proton platform. See Birkedal U Christensen Dalsgaard M Krogh N Sabarinathan R Gorodkin J Nielsen H. Profiling of ribose methylations in RNA by high throughput sequencing. Angewandte Chemie. 2015;542:451 5 for detailed description | GEO Accession:GSM4591061 | OTHER | TRANSCRIPTOMIC | other | SINGLE | ION_TORRENT | Ion Torrent Proton | SRP265951 | intentional duplicate | Adult_tail_1.bam GSE151797_Reference_sequence.fa | bam bam | 50029636.0 | 1968329.0 | GSM4591061 r1 | 0:25.42 | A:9571393;C:14825016;G:13276309;T:12356918;N:0 | 25 | 9571393 | 14825016 | 13276309 | 12356918 | 0 | SRX8469994 | SRS6770645 | SRA1083099 | GEO | RNA Group - Prof. Henrik Nielsen, Department of Cellular and Molecular Medicine, University of Copenhagen | 1 | 0.46312 | 0.12127 | 0.91806 | 0.67424 | 44 | B | usable mapping rate | ion_torrent | ion_torrent | 5prime | small_rna | unknown | bulk | unknown | unknown | Denmark | 2020-06-04 | Adult | Adult | Multi-tissue | Multi-system |
Advanced export
JSON shape: default, array, newline-delimited
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");;