run_metadata
5 rows where experiment.library_layout = "SINGLE", experiment.library_selection = "RT-PCR" and tissue_curation = "Undetermined"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 36504 | 36504 | SRR535848 | SRX174964 | SRS352998 | SRP014772 | PRJNA172016 | Danio rerio strain:*AB Variation | PRJNA172016 | Other | Forward genetic screens have elucidated molecular pathways required for innumerable aspects of life however identifying the causal mutations from such screens has long been the bottleneck in the process particularly in vertebrates. We have developed an RNA Seq based approach that identifies both the region of the genome linked to a mutation and candidate lesions that may be causal for the phenotype of interest. We show that our method successfully identifies zebrafish mutations that cause nonsense or missense changes to codons alter transcript splicing or alter gene expression levels. Furthermore we develop an online accessible or downloadable bioinformatics pipeline allowing for easy implementation of all steps of the method. Overall we show that RNA Seq is a fast reliable and cost effective method to map and identify mutations that will greatly facilitate the power of forward genetics in vertebrate models. | RNA seq data from Miller et al submitted. Data was generated in order to map ENU induced mutations in zebrafish. This data hox20 was created from 20 pooled hoxb1bb1219 fish that were the siblings of wt20. | Miller hox20.bam | Miller hox20.bam | Miller hox20.bam | Miller hox20.bam | 1 | 50 bp Paired End | RNA-Seq | TRANSCRIPTOMIC | RT-PCR | SINGLE | ILLUMINA | Illumina HiSeq 2000 | <SPOT_DESCRIPTOR><SPOT_DECODE_SPEC><SPOT_LENGTH>180</SPOT_LENGTH><READ_SPEC><READ_INDEX>0</READ_INDEX><READ_CLASS>Application Read</READ_CLASS><READ_TYPE>Forward</READ_TYPE><BASE_COORD>1</BASE_COORD></READ_SPEC></SPOT_DECODE_SPEC></SPOT_DESCRIPTOR> | SRP014772 | hox20.bam | bam | 2051648571.0 | 22151528.0 | Miller hox20.bam | 0:49 1:49 | A:528770281;C:501621137;G:487051170;T:534176088;N:29895 | 49 | 49 | 528770281 | 501621137 | 487051170 | 534176088 | 29895 | SRX174964 | SRS352998 | SRA056859 | Fred Hutchinson Cancer Research Center|Moens | Fred Hutchinson Cancer Research Center | 2 | 0.9629 | 0.96282 | 0.07314 | 0.07288 | 0.6714 | 0.67125 | 0.4665 | 0.4637 | 49 | 49 | B | B | biological fallback assumption | illumina | hiseq_era | unknown | other | unknown | bulk | unknown | unknown | United States | 2012-11-30 | Undetermined | Undetermined | Undetermined | Undetermined | |||||||||||||||||||
| 36666 | 36666 | SRR800043 | SRX257153 | SRS405345 | SRP020008 | PRJNA193544 | Danio rerio strain:Tubingen Epigenomics | PRJNA193544 | Other | Early vertebrate embryos must achieve totipotency and prepare for zygotic genome activation ZGA. To better understand we determined DNAme profiles of zebrafish gametes multiple embryo stages flanking ZGA and somatic muscle and compared them to gene activity and histone modifications. First sperm chromatin patterns are virtually identical to those at ZGA. Unexpectedly in the oocyte many genes important for germline functions ie. piwil1 or early development ie. hox genes are DNA methylated. Remarkably these maternal loci are demethylated during zygotic/cleavage stages to precisely the state observed in sperm even in parthenogenetic embryos lacking a replicating paternal genome. Furthermore this cohort constitutes the genes/loci that acquire DNAme during development ie. ZGA to muscle. Finally DNA methyltransferase inhibition experiments suggest that DNAme silences particular gene/chromatin cohorts at ZGA preventing their precocious expression. Thus zebrafish achieve a 'totipotent' chromatin state at ZGA through paternal genome competency and maternal genome DNAme reprogramming. | pubmed:23663776 | Total RNA was extracted using Qiagen AllPrep DNA/RNA/Protein mini kit Cat # 80004 ribosomal RNA was depleted using RiboMinus kit A10837 08 Eukaryote Kit followed by directional RNA library preparation according to Illumina's standard protocol. Detailed experimental procedures and bioinformatics analysis can be found in the supplemental method section of the paper. | Generic sample from Danio rerio | sphere RNAseq totalRNARibominus | strain:Tubingen|label:PE: paired end SE: single end|development stage:sphere | sphere RNAseq totalRNARibominus | sphere RNAseq totalRNARibominus | 7986X2 | Total RNA was extracted using Qiagen AllPrep DNA/RNA/Protein mini kit Cat # 80004 ribosomal RNA was depleted using RiboMinus kit A10837 08 Eukaryote Kit followed by directional RNA library preparation according to Illumina's standard protocol. Detailed experimental procedures and bioinformatics analysis can be found in the supplemental method section of the paper. | RNA-Seq | TRANSCRIPTOMIC | RT-PCR | SINGLE | ILLUMINA | Illumina HiSeq 2000 | <SPOT_DESCRIPTOR><SPOT_DECODE_SPEC><SPOT_LENGTH>50</SPOT_LENGTH><READ_SPEC><READ_INDEX>0</READ_INDEX><READ_CLASS>Application Read</READ_CLASS><READ_TYPE>Forward</READ_TYPE><BASE_COORD>1</BASE_COORD></READ_SPEC></SPOT_DECODE_SPEC></SPOT_DESCRIPTOR> | SRP020008 | sphere_RNAseq_totalRNARibominus_SE_7986X2_110510_SN141_0338_AB06MWABXX_7.txt.gz | Illumina native | 3029181300.0 | 60583626.0 | 7986X2 110510 SN141 0338 AB06MWABXX 7 | 0:50 | A:768949744;C:733340278;G:903149841;T:623482299;N:259138 | 50 | 768949744 | 733340278 | 903149841 | 623482299 | 259138 | SRX257153 | SRS405345 | SRA072148 | University of Utah|Brad Cairns Lab | University of Utah | 1 | 0.83515 | 0.15524 | 0.81209 | 0.81031 | 50 | B | usable mapping rate | illumina | hiseq_era | unknown | rrna_depletion | unknown | bulk | unknown | unknown | United States | 2015-07-22 | Blastula | Embryo | Undetermined | Embryo Imprecise | ||||||||||||||||||||||||
| 36667 | 36667 | SRR800044 | SRX257153 | SRS405345 | SRP020008 | PRJNA193544 | Danio rerio strain:Tubingen Epigenomics | PRJNA193544 | Other | Early vertebrate embryos must achieve totipotency and prepare for zygotic genome activation ZGA. To better understand we determined DNAme profiles of zebrafish gametes multiple embryo stages flanking ZGA and somatic muscle and compared them to gene activity and histone modifications. First sperm chromatin patterns are virtually identical to those at ZGA. Unexpectedly in the oocyte many genes important for germline functions ie. piwil1 or early development ie. hox genes are DNA methylated. Remarkably these maternal loci are demethylated during zygotic/cleavage stages to precisely the state observed in sperm even in parthenogenetic embryos lacking a replicating paternal genome. Furthermore this cohort constitutes the genes/loci that acquire DNAme during development ie. ZGA to muscle. Finally DNA methyltransferase inhibition experiments suggest that DNAme silences particular gene/chromatin cohorts at ZGA preventing their precocious expression. Thus zebrafish achieve a 'totipotent' chromatin state at ZGA through paternal genome competency and maternal genome DNAme reprogramming. | pubmed:23663776 | Total RNA was extracted using Qiagen AllPrep DNA/RNA/Protein mini kit Cat # 80004 ribosomal RNA was depleted using RiboMinus kit A10837 08 Eukaryote Kit followed by directional RNA library preparation according to Illumina's standard protocol. Detailed experimental procedures and bioinformatics analysis can be found in the supplemental method section of the paper. | Generic sample from Danio rerio | sphere RNAseq totalRNARibominus | strain:Tubingen|label:PE: paired end SE: single end|development stage:sphere | sphere RNAseq totalRNARibominus | sphere RNAseq totalRNARibominus | 7986X2 | Total RNA was extracted using Qiagen AllPrep DNA/RNA/Protein mini kit Cat # 80004 ribosomal RNA was depleted using RiboMinus kit A10837 08 Eukaryote Kit followed by directional RNA library preparation according to Illumina's standard protocol. Detailed experimental procedures and bioinformatics analysis can be found in the supplemental method section of the paper. | RNA-Seq | TRANSCRIPTOMIC | RT-PCR | SINGLE | ILLUMINA | Illumina HiSeq 2000 | <SPOT_DESCRIPTOR><SPOT_DECODE_SPEC><SPOT_LENGTH>50</SPOT_LENGTH><READ_SPEC><READ_INDEX>0</READ_INDEX><READ_CLASS>Application Read</READ_CLASS><READ_TYPE>Forward</READ_TYPE><BASE_COORD>1</BASE_COORD></READ_SPEC></SPOT_DECODE_SPEC></SPOT_DESCRIPTOR> | SRP020008 | sphere_RNAseq_totalRNARibominus_SE_7986X2_110606_SN141_0359_BD0D8KABXX_6.txt.gz | Illumina native | 3947123500.0 | 78942470.0 | 7986X2 110606 SN141 0359 BD0D8KABXX 6 | 0:50 | A:1000468440;C:957437794;G:1171831772;T:817292633;N:92861 | 50 | 1000468440 | 957437794 | 1171831772 | 817292633 | 92861 | SRX257153 | SRS405345 | SRA072148 | University of Utah|Brad Cairns Lab | University of Utah | 1 | 0.81283 | 0.14906 | 0.81335 | 0.81698 | 50 | B | usable mapping rate | illumina | hiseq_era | unknown | rrna_depletion | unknown | bulk | unknown | unknown | United States | 2015-07-22 | Blastula | Embryo | Undetermined | Embryo Imprecise | ||||||||||||||||||||||||
| 36668 | 36668 | SRR800037 | SRX257149 | SRS405106 | SRP020008 | PRJNA193544 | Danio rerio strain:Tubingen Epigenomics | PRJNA193544 | Other | Early vertebrate embryos must achieve totipotency and prepare for zygotic genome activation ZGA. To better understand we determined DNAme profiles of zebrafish gametes multiple embryo stages flanking ZGA and somatic muscle and compared them to gene activity and histone modifications. First sperm chromatin patterns are virtually identical to those at ZGA. Unexpectedly in the oocyte many genes important for germline functions ie. piwil1 or early development ie. hox genes are DNA methylated. Remarkably these maternal loci are demethylated during zygotic/cleavage stages to precisely the state observed in sperm even in parthenogenetic embryos lacking a replicating paternal genome. Furthermore this cohort constitutes the genes/loci that acquire DNAme during development ie. ZGA to muscle. Finally DNA methyltransferase inhibition experiments suggest that DNAme silences particular gene/chromatin cohorts at ZGA preventing their precocious expression. Thus zebrafish achieve a 'totipotent' chromatin state at ZGA through paternal genome competency and maternal genome DNAme reprogramming. | pubmed:23663776 | Total RNA was extracted using Qiagen AllPrep DNA/RNA/Protein mini kit Cat # 80004 ribosomal RNA was depleted using RiboMinus kit A10837 08 Eukaryote Kit followed by directional RNA library preparation according to Illumina's standard protocol. Detailed experimental procedures and bioinformatics analysis can be found in the supplemental method section of the paper. | Generic sample from Danio rerio | egg RNAseq totalRNARibominus | strain:Tubingen|label:PE: paired end SE: single end|dev stage:egg | egg RNAseq totalRNARibominus | egg RNAseq totalRNARibominus | 7784X1 | Total RNA was extracted using Qiagen AllPrep DNA/RNA/Protein mini kit Cat # 80004 ribosomal RNA was depleted using RiboMinus kit A10837 08 Eukaryote Kit followed by directional RNA library preparation according to Illumina's standard protocol. Detailed experimental procedures and bioinformatics analysis can be found in the supplemental method section of the paper. | RNA-Seq | TRANSCRIPTOMIC | RT-PCR | SINGLE | ILLUMINA | Illumina HiSeq 2000 | <SPOT_DESCRIPTOR><SPOT_DECODE_SPEC><SPOT_LENGTH>50</SPOT_LENGTH><READ_SPEC><READ_INDEX>0</READ_INDEX><READ_CLASS>Application Read</READ_CLASS><READ_TYPE>Forward</READ_TYPE><BASE_COORD>1</BASE_COORD></READ_SPEC></SPOT_DECODE_SPEC></SPOT_DESCRIPTOR> | SRP020008 | 3584440000.0 | 71688800.0 | 7784X1 110323 SN141 0332 A81FDVABXX 8 | 0:50 | A:1013532157;C:812179975;G:992916103;T:765761452;N:50313 | 50 | 1013532157 | 812179975 | 992916103 | 765761452 | 50313 | SRX257149 | SRS405106 | SRA072148 | University of Utah|Brad Cairns Lab | University of Utah | 1 | 0.87304 | 0.12853 | 0.81988 | 0.80407 | 50 | B | usable mapping rate | illumina | hiseq_era | unknown | rrna_depletion | unknown | bulk | unknown | unknown | United States | 2013-04-01 | Undetermined | Embryo | Undetermined | Embryo Imprecise | ||||||||||||||||||||||||||
| 36669 | 36669 | SRR800038 | SRX257149 | SRS405106 | SRP020008 | PRJNA193544 | Danio rerio strain:Tubingen Epigenomics | PRJNA193544 | Other | Early vertebrate embryos must achieve totipotency and prepare for zygotic genome activation ZGA. To better understand we determined DNAme profiles of zebrafish gametes multiple embryo stages flanking ZGA and somatic muscle and compared them to gene activity and histone modifications. First sperm chromatin patterns are virtually identical to those at ZGA. Unexpectedly in the oocyte many genes important for germline functions ie. piwil1 or early development ie. hox genes are DNA methylated. Remarkably these maternal loci are demethylated during zygotic/cleavage stages to precisely the state observed in sperm even in parthenogenetic embryos lacking a replicating paternal genome. Furthermore this cohort constitutes the genes/loci that acquire DNAme during development ie. ZGA to muscle. Finally DNA methyltransferase inhibition experiments suggest that DNAme silences particular gene/chromatin cohorts at ZGA preventing their precocious expression. Thus zebrafish achieve a 'totipotent' chromatin state at ZGA through paternal genome competency and maternal genome DNAme reprogramming. | pubmed:23663776 | Total RNA was extracted using Qiagen AllPrep DNA/RNA/Protein mini kit Cat # 80004 ribosomal RNA was depleted using RiboMinus kit A10837 08 Eukaryote Kit followed by directional RNA library preparation according to Illumina's standard protocol. Detailed experimental procedures and bioinformatics analysis can be found in the supplemental method section of the paper. | Generic sample from Danio rerio | egg RNAseq totalRNARibominus | strain:Tubingen|label:PE: paired end SE: single end|dev stage:egg | egg RNAseq totalRNARibominus | egg RNAseq totalRNARibominus | 7784X1 | Total RNA was extracted using Qiagen AllPrep DNA/RNA/Protein mini kit Cat # 80004 ribosomal RNA was depleted using RiboMinus kit A10837 08 Eukaryote Kit followed by directional RNA library preparation according to Illumina's standard protocol. Detailed experimental procedures and bioinformatics analysis can be found in the supplemental method section of the paper. | RNA-Seq | TRANSCRIPTOMIC | RT-PCR | SINGLE | ILLUMINA | Illumina HiSeq 2000 | <SPOT_DESCRIPTOR><SPOT_DECODE_SPEC><SPOT_LENGTH>50</SPOT_LENGTH><READ_SPEC><READ_INDEX>0</READ_INDEX><READ_CLASS>Application Read</READ_CLASS><READ_TYPE>Forward</READ_TYPE><BASE_COORD>1</BASE_COORD></READ_SPEC></SPOT_DECODE_SPEC></SPOT_DESCRIPTOR> | SRP020008 | 2794240450.0 | 55884809.0 | 7784X1 110119 SN141 0323 B8162JABXX 8 | 0:50 | A:792200981;C:632130044;G:772351331;T:596980885;N:577209 | 50 | 792200981 | 632130044 | 772351331 | 596980885 | 577209 | SRX257149 | SRS405106 | SRA072148 | University of Utah|Brad Cairns Lab | University of Utah | 1 | 0.86104 | 0.12909 | 0.82266 | 0.80894 | 50 | B | usable mapping rate | illumina | hiseq_era | unknown | rrna_depletion | unknown | bulk | unknown | unknown | United States | 2013-04-01 | Undetermined | Embryo | Undetermined | Embryo Imprecise |
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");;