metadata: run_metadata: 1 row where experiment.library_source = "TRANSCRIPTOMIC", experiment.library_strategy = "miRNA-Seq" and tissue

1 row where experiment.library_source = "TRANSCRIPTOMIC", experiment.library_strategy = "miRNA-Seq" and tissue_curation = "Fin"

descending

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
39609	39609	SRR1873571	SRX915251	SRS870223	SRP056014	PRJNA277780	Identification of small non coding RNAs in zebrafish	GSE66718	Transcriptome Analysis	MicroRNAs miRNAs are a new class of small RNAs of approximately 22 nucleotides in length that control eukaryotic gene expression by fine tuning mRNA translation. They regulate a wide variety of biological processes namely developmental timing cell differentiation cell proliferation immune response and infection. For this reason their identification is essential to understand eukaryotic biology. Their small size low abundance and high instability complicated early identification; however cloning/Sanger sequencing and new generation genome sequencing approaches overcame most technical hurdles and are being used for rapid miRNA identification in many eukaryotes. We have applied 454 DNA pyrosequencing technology to miRNA discovery in zebrafish Danio rerio. For this a series of cDNA libraries were prepared from small non coding RNAs isolated at different embryonic time points and from fully developed organs. Each cDNA library was tagged with specific sequences and was sequenced using the Roche FLX genome sequencer. This approach retrieved 90% of the 192 miRNAs previously identified by cloning/Sanger sequencing and bioinformatics and 25 novel miRNAs were predicted. Overall design: Small RNA libraries were prepared from different zebrafish developmental stages namely 24 hpf 72 hpf 96 hpf 5 dpf dpf 45 dpf young adult and from adult brain eyes gills heart skin and fins.		pubmed:26694924		fins	GSM1630515		source name:adult fins 1 year old\|strain/background:AB\|genotype/variation:wild type\|tissue:fins\|developmental stage:adult\|age:1 year	fins	Base calling and quality trimming of sequence reads was carried out using the Genome Sequencer FLX software. Raw images were processed to remove background noise and the data was normalized. TAGs and adapter sequences of zebrafish developmental and adult tissues samples were then identified and trimmed and those reads with correct TAGs and adapters > 15 nt were retrieved for downstream analysis using the miRDeep software https://www.mdc berlin.de/8551903/en/. miRDeep aligned the sequences against the zebrafish genome using megaBlast with seed length set at 12 the traditional blast output and minimum local identity set at 100. The blast output was then parsed for miRDeep uploading and aligned sequences with a maximum of 2 mismatches in the three prime end were retrieved. Reads that matched more than 10 different genome loci were discarded and only those with one or more alignments were kept and using the remaining alignments as guidelines the potential precursors were excised from the genome. The secondary structure of putative precursors was predicted using RNAfold and signatures were created by retaining reads that aligned perfectly with those putative precursors to generate the signature format. Finally miRDeep predicted miRNAs by discarding non plausible Dicer products and scoring plausible ones. To assess seed conservation plausible Dicer processing sequences were blasted against a local version of mature miRNAs from miRBase 12.0 that lacked zebrafish miRNA sequences. Borderline miRNA candidates were also resolved by determining their relative stability using Randfold. To distinguish between novel and known miRNAs selected pre miRNAs were blasted against Danio rerio stem loop sequences miRBase and those that did not produce any or produced imperfect alignments were scored as novel miRNAs. Pairs of signatures and structures were used to estimate the number of false positives by randomly permutation using miRDeep. To overcome the inherent lack of sensitivity of miRDeep novel transcripts encoding miRNAs…	adult fins 1 year old		100 μg of total RNA from each sample was isolated using TRIzol® and small RNAs were enriched by differential precipitation using polyethylene glycol. Total RNAs were fractioned using 12% denaturing PAGE and small RNAs of 15 30 nt were gel isolated using Gel Filtration cartridges from Edge Biosystems. For cDNA synthesis the small RNA molecules previously isolated were first ligated to a three prime adapter AMP five primep five primep/CTGTAGGCACCATCAATdi deoxyC three prime in absence of ATP and gel excised in the range of 35 and 50 nt. A second ligation was performed with the five prime adapter "Nelson's linker" five primeATCGTrArGrGrCrArCrCrUrGrArArA three prime for 1 hour at 37°C followed by phenol extraction. First strand cDNA synthesis was then performed using a specific three prime primer and Superscript™ III reverse transcriptase Invitrogen. RNase H treated cDNA was PCR amplified with adapter specific primers. Each sample contained a specific TAG constituted by 3 nucleotides as detailed next. 24hpf ATC; 72hpf ACT; 96hpf CAG; 5dpf ATG; 45dpf CCG; entire adult GTA; brain CGG; Heart CTG; Eyes GCT; fins GTT; skin TAC; gills TCC. PCR products were then run on 10% denaturing PAGE containing 7 M urea and the corresponding band 100 nt was eluted from the gel with Probe Elution Buffer from Ambion at 37°C overnight. These products were used for the emulsion PCR. Parallel DNA pyrosequencing was performed using the Genome Sequencer FLX Roche following established protocols for DNA library sequencing.	Wild type AB zebrafish strain was maintained at 28ºC on a 14 h light/10 h dark cycle.	strain/background:AB\|genotype/variation:wild type\|tissue:fins\|developmental stage:adult\|age:1 year	GSM1630515	GSM1630515: fins; Danio rerio; miRNA Seq	GSM1630515		1	100 μg of total RNA from each sample was isolated using TRIzol® and small RNAs were enriched by differential precipitation using polyethylene glycol. Total RNAs were fractioned using 12% denaturing PAGE and small RNAs of 15 30 nt were gel isolated using Gel Filtration cartridges from Edge Biosystems. For cDNA synthesis the small RNA molecules previously isolated were first ligated to a three prime adapter AMP five primep five primep/CTGTAGGCACCATCAATdi deoxyC three prime in absence of ATP and gel excised in the range of 35 and 50 nt. A second ligation was performed with the five prime adapter "Nelson's linker" five primeATCGTrArGrGrCrArCrCrUrGrArArA three prime for 1 hour at 37°C followed by phenol extraction. First strand cDNA synthesis was then performed using a specific three prime primer and Superscript™ III reverse transcriptase Invitrogen. RNase H treated cDNA was PCR amplified with adapter specific primers. Each sample contained a specific TAG constituted by 3 nucleotides as detailed next. 24hpf ATC; 72hpf ACT; 96hpf CAG; 5dpf ATG; 45dpf CCG; entire adult GTA; brain CGG; Heart CTG; Eyes GCT; fins GTT; skin TAC; gills TCC. PCR products were then run on 10% denaturing PAGE containing 7 M urea and the corresponding band 100 nt was eluted from the gel with Probe Elution Buffer from Ambion at 37°C overnight. These products were used for the emulsion PCR. Parallel DNA pyrosequencing was performed using the Genome Sequencer FLX Roche following established protocols for DNA library sequencing.	GEO Accession:GSM1630515	miRNA-Seq	TRANSCRIPTOMIC	size fractionation	SINGLE	LS454	454 GS FLX		SRP056014					113161.0	2108.0	GSM1630515 r1	0:4 1:49.68	A:30303;C:30710;G:27210;T:24785;N:153	4	49			30303	30710	27210	24785	153	SRX915251	SRS870223	SRA246117	GEO	University of Aveiro	1	0.0		0.0		1.0				50		T		under 1.2% mapping rate	legacy	early	3prime	size_fractionation	unknown	bulk	other_seq	454		Portugal	2015-03-09	Adult	Adult	Fin	Surface Structure

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");;