run_metadata
25 rows where experiment.library_selection = "RT-PCR" and experiment.library_strategy = "miRNA-Seq"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||||||||||||||||||||||||||
| 65669 | 65669 | SRR15498138 | SRX11797853 | SRS9797787 | SRP332839 | PRJNA755482 | miRNA sequencing from zebrafish testes and ovaries exposed to normal and high temperatures | PRJNA755482 | Other | We exposed zebrafish to elevated temperatures during early development a treatment that is known to result in male skewed sex ratios in order to understand the role of the epigenetic regulation mediated by miRNAs in the gonads. | Ovary High Temperature | ZF 36 G12F | strain:AB|age:90 dpf|sex:female|tissue:Ovary|replicate:Biological replicate OHT 2|BioSampleModel:Model organism or animal | miRNA seq of Danio rerio: adult treated ovary | 36 G12 | 36 G12 | NEBNext Small RNA Library Prep Set for Illumina was used on total RNA isolated from zebrafish ovary using Qiagen RNeasy mini kit. Library was constructed using sequencing Lane 1x50 v4 HiSeq single end mode with a read length of 50 bp | miRNA-Seq | TRANSCRIPTOMIC | RT-PCR | SINGLE | ILLUMINA | Illumina HiSeq 2500 | SRP332839 | ZF_36_G12_22313_ATGAGC.fastq ZF_36_G12_24794_ATGAGC.fastq | fastq fastq | 385298900.0 | 7705978.0 | ZF 36 G12 22313 ATGAGC.fastq | 0:50 1:0 | A:115879319;C:84755497;G:100335882;T:84312716;N:15486 | 50 | 0 | 115879319 | 84755497 | 100335882 | 84312716 | 15486 | SRX11797853 | SRS9797787 | SRA1279325 | Institute of Marine Sciences|Repro-Immune Team | Institute of Marine Sciences | 1 | 0.76472 | 0.49644 | 0.83287 | 0.51149 | 50 | B | usable mapping rate | illumina | hiseq_era | unknown | small_rna | nebnext | bulk | unknown | unknown | United States | 2021-08-17 | Adult | Adult | Gonad | Reproductive System | ||||||||||||||||||||||||||
| 65670 | 65670 | SRR15498139 | SRX11797852 | SRS9797788 | SRP332839 | PRJNA755482 | miRNA sequencing from zebrafish testes and ovaries exposed to normal and high temperatures | PRJNA755482 | Other | We exposed zebrafish to elevated temperatures during early development a treatment that is known to result in male skewed sex ratios in order to understand the role of the epigenetic regulation mediated by miRNAs in the gonads. | Ovary High Temperature | ZF 36 G9F | strain:AB|age:90 dpf|sex:female|tissue:Ovary|replicate:Biological replicate OHT 1|BioSampleModel:Model organism or animal | miRNA seq of Danio rerio: adult treated ovary | 36 G9 | 36 G9 | NEBNext Small RNA Library Prep Set for Illumina was used on total RNA isolated from zebrafish ovary using Qiagen RNeasy mini kit. Library was constructed using sequencing Lane 1x50 v4 HiSeq single end mode with a read length of 50 bp | miRNA-Seq | TRANSCRIPTOMIC | RT-PCR | SINGLE | ILLUMINA | Illumina HiSeq 2500 | SRP332839 | ZF_36_G9_22313_ACTGAT.fastq ZF_36_G9_24794_ACTGAT.fastq | fastq fastq | 448040450.0 | 8960809.0 | ZF 36 G9 22313 ACTGAT.fastq | 0:50 1:0 | A:134152732;C:98754272;G:116124383;T:98987716;N:21347 | 50 | 0 | 134152732 | 98754272 | 116124383 | 98987716 | 21347 | SRX11797852 | SRS9797788 | SRA1279325 | Institute of Marine Sciences|Repro-Immune Team | Institute of Marine Sciences | 1 | 0.73407 | 0.52835 | 0.83092 | 0.53201 | 50 | B | usable mapping rate | illumina | hiseq_era | unknown | small_rna | nebnext | bulk | unknown | unknown | United States | 2021-08-17 | Adult | Adult | Gonad | Reproductive System | ||||||||||||||||||||||||||
| 65671 | 65671 | SRR15498140 | SRX11797851 | SRS9797786 | SRP332839 | PRJNA755482 | miRNA sequencing from zebrafish testes and ovaries exposed to normal and high temperatures | PRJNA755482 | Other | We exposed zebrafish to elevated temperatures during early development a treatment that is known to result in male skewed sex ratios in order to understand the role of the epigenetic regulation mediated by miRNAs in the gonads. | Testis Low Temperature | ZF 28 G11M | strain:AB|age:90 dpf|sex:male|tissue:Testis|replicate:Biological replicate TLT 2|BioSampleModel:Model organism or animal | miRNA seq of Danio rerio: adult untreated testis | 28 G11 | 28 G11 | NEBNext Small RNA Library Prep Set for Illumina was used on total RNA isolated from zebrafish testis using Qiagen RNeasy mini kit. Library was constructed using sequencing Lane 1x50 v4 HiSeq single end mode with a read length of 50 bp | miRNA-Seq | TRANSCRIPTOMIC | RT-PCR | SINGLE | ILLUMINA | Illumina HiSeq 2500 | SRP332839 | ZF_28_G11_22312_CACCGG.fastq | fastq | 397315650.0 | 7946313.0 | ZF 28 G11 22312 CACCGG.fastq | 0:50 1:0 | A:117553892;C:87676340;G:103796431;T:88242064;N:46923 | 50 | 0 | 117553892 | 87676340 | 103796431 | 88242064 | 46923 | SRX11797851 | SRS9797786 | SRA1279325 | Institute of Marine Sciences|Repro-Immune Team | Institute of Marine Sciences | 1 | 0.7153 | 0.45777 | 0.85131 | 0.51595 | 50 | B | usable mapping rate | illumina | hiseq_era | unknown | small_rna | nebnext | bulk | unknown | unknown | United States | 2021-08-17 | Adult | Adult | Gonad | Reproductive System | ||||||||||||||||||||||||||
| 65672 | 65672 | SRR15498141 | SRX11797850 | SRS9797785 | SRP332839 | PRJNA755482 | miRNA sequencing from zebrafish testes and ovaries exposed to normal and high temperatures | PRJNA755482 | Other | We exposed zebrafish to elevated temperatures during early development a treatment that is known to result in male skewed sex ratios in order to understand the role of the epigenetic regulation mediated by miRNAs in the gonads. | Testis Low Temperature | ZF 28 G18M | strain:AB|age:90 dpf|sex:male|tissue:Testis|replicate:Biological replicate TLT 1|BioSampleModel:Model organism or animal | miRNA seq of Danio rerio: adult untreated testis | 28 G18 | 28 G18 | NEBNext Small RNA Library Prep Set for Illumina was used on total RNA isolated from zebrafish testis using Qiagen RNeasy mini kit. Library was constructed using sequencing Lane 1x50 v4 HiSeq single end mode with a read length of 50 bp | miRNA-Seq | TRANSCRIPTOMIC | RT-PCR | SINGLE | ILLUMINA | Illumina HiSeq 2500 | SRP332839 | ZF_28_G18_22312_CAACTA.fastq | fastq | 299844950.0 | 5996899.0 | ZF 28 G18 22312 CAACTA.fastq | 0:50 1:0 | A:88371816;C:66221559;G:79693659;T:65522293;N:35623 | 50 | 0 | 88371816 | 66221559 | 79693659 | 65522293 | 35623 | SRX11797850 | SRS9797785 | SRA1279325 | Institute of Marine Sciences|Repro-Immune Team | Institute of Marine Sciences | 1 | 0.70252 | 0.44336 | 0.85782 | 0.53663 | 50 | B | usable mapping rate | illumina | hiseq_era | unknown | small_rna | nebnext | bulk | unknown | unknown | United States | 2021-08-17 | Adult | Adult | Gonad | Reproductive System | ||||||||||||||||||||||||||
| 65673 | 65673 | SRR15498142 | SRX11797849 | SRS9797784 | SRP332839 | PRJNA755482 | miRNA sequencing from zebrafish testes and ovaries exposed to normal and high temperatures | PRJNA755482 | Other | We exposed zebrafish to elevated temperatures during early development a treatment that is known to result in male skewed sex ratios in order to understand the role of the epigenetic regulation mediated by miRNAs in the gonads. | Ovary Low Temperature | ZF 28 G19F | strain:AB|age:90 dpf|sex:female|tissue:Ovary|replicate:Biological replicate OLT 4|BioSampleModel:Model organism or animal | miRNA seq of Danio rerio: adult untreated ovary | 28 G19 | 28 G19 | NEBNext Small RNA Library Prep Set for Illumina was used on total RNA isolated from zebrafish ovary using Qiagen RNeasy mini kit. Library was constructed using sequencing Lane 1x50 v4 HiSeq single end mode with a read length of 50 bp | miRNA-Seq | TRANSCRIPTOMIC | RT-PCR | SINGLE | ILLUMINA | Illumina HiSeq 2500 | SRP332839 | ZF_28_G19_22312_GTTTCG.fastq ZF_28_G19_24794_GTTTCG.fastq | fastq fastq | 453746250.0 | 9074925.0 | ZF 28 G19 22312 GTTTCG.fastq | 0:50 1:0 | A:133375616;C:101583110;G:121165582;T:97585655;N:36287 | 50 | 0 | 133375616 | 101583110 | 121165582 | 97585655 | 36287 | SRX11797849 | SRS9797784 | SRA1279325 | Institute of Marine Sciences|Repro-Immune Team | Institute of Marine Sciences | 1 | 0.72934 | 0.45973 | 0.81659 | 0.55084 | 50 | B | usable mapping rate | illumina | hiseq_era | unknown | small_rna | nebnext | bulk | unknown | unknown | United States | 2021-08-17 | Adult | Adult | Gonad | Reproductive System | ||||||||||||||||||||||||||
| 65674 | 65674 | SRR15498143 | SRX11797848 | SRS9797782 | SRP332839 | PRJNA755482 | miRNA sequencing from zebrafish testes and ovaries exposed to normal and high temperatures | PRJNA755482 | Other | We exposed zebrafish to elevated temperatures during early development a treatment that is known to result in male skewed sex ratios in order to understand the role of the epigenetic regulation mediated by miRNAs in the gonads. | Ovary Low Temperature | ZF 28 G17F | strain:AB|age:90 dpf|sex:female|tissue:Ovary|replicate:Biological replicate OLT 3|BioSampleModel:Model organism or animal | miRNA seq of Danio rerio: adult untreated ovary | 28 G17 | 28 G17 | NEBNext Small RNA Library Prep Set for Illumina was used on total RNA isolated from zebrafish ovary using Qiagen RNeasy mini kit. Library was constructed using sequencing Lane 1x50 v4 HiSeq single end mode with a read length of 50 bp | miRNA-Seq | TRANSCRIPTOMIC | RT-PCR | SINGLE | ILLUMINA | Illumina HiSeq 2500 | SRP332839 | ZF_28_G17_22312_GTGGCC.fastq ZF_28_G17_24794_GTGGCC.fastq | fastq fastq | 400680350.0 | 8013607.0 | ZF 28 G17 22312 GTGGCC.fastq | 0:50 1:0 | A:116055791;C:92144972;G:109622335;T:82823767;N:33485 | 50 | 0 | 116055791 | 92144972 | 109622335 | 82823767 | 33485 | SRX11797848 | SRS9797782 | SRA1279325 | Institute of Marine Sciences|Repro-Immune Team | Institute of Marine Sciences | 1 | 0.67985 | 0.39457 | 0.82678 | 0.60177 | 50 | B | usable mapping rate | illumina | hiseq_era | unknown | small_rna | nebnext | bulk | unknown | unknown | United States | 2021-08-17 | Adult | Adult | Gonad | Reproductive System | ||||||||||||||||||||||||||
| 65675 | 65675 | SRR15498144 | SRX11797847 | SRS9797783 | SRP332839 | PRJNA755482 | miRNA sequencing from zebrafish testes and ovaries exposed to normal and high temperatures | PRJNA755482 | Other | We exposed zebrafish to elevated temperatures during early development a treatment that is known to result in male skewed sex ratios in order to understand the role of the epigenetic regulation mediated by miRNAs in the gonads. | Ovary Low Temperature | ZF 28 G8F | strain:AB|age:90 dpf|sex:female|tissue:Ovary|replicate:Biological replicate OLT 2|BioSampleModel:Model organism or animal | miRNA seq of Danio rerio: adult untreated ovary | 28 G8 | 28 G8 | NEBNext Small RNA Library Prep Set for Illumina was used on total RNA isolated from zebrafish ovary using Qiagen RNeasy mini kit. Library was constructed using sequencing Lane 1x50 v4 HiSeq single end mode with a read length of 50 bp | miRNA-Seq | TRANSCRIPTOMIC | RT-PCR | SINGLE | ILLUMINA | Illumina HiSeq 2500 | SRP332839 | ZF_28_G8_22312_GTAGAG.fastq ZF_28_G8_24794_GTAGAG.fastq | fastq fastq | 436150900.0 | 8723018.0 | ZF 28 G8 22312 GTAGAG.fastq | 0:50 1:0 | A:129619390;C:96543331;G:116417612;T:93533768;N:36799 | 50 | 0 | 129619390 | 96543331 | 116417612 | 93533768 | 36799 | SRX11797847 | SRS9797783 | SRA1279325 | Institute of Marine Sciences|Repro-Immune Team | Institute of Marine Sciences | 1 | 0.74469 | 0.47759 | 0.82637 | 0.51178 | 50 | B | usable mapping rate | illumina | hiseq_era | unknown | small_rna | nebnext | bulk | unknown | unknown | United States | 2021-08-17 | Adult | Adult | Gonad | Reproductive System | ||||||||||||||||||||||||||
| 65676 | 65676 | SRR15498145 | SRX11797846 | SRS9797780 | SRP332839 | PRJNA755482 | miRNA sequencing from zebrafish testes and ovaries exposed to normal and high temperatures | PRJNA755482 | Other | We exposed zebrafish to elevated temperatures during early development a treatment that is known to result in male skewed sex ratios in order to understand the role of the epigenetic regulation mediated by miRNAs in the gonads. | Ovary Low Temperature | ZF 28 G5F | strain:AB|age:90 dpf|sex:female|tissue:Ovary|replicate:Biological replicate OLT 1|BioSampleModel:Model organism or animal | miRNA seq of Danio rerio: adult untreated ovary | 28 G5 | 28 G5 | NEBNext Small RNA Library Prep Set for Illumina was used on total RNA isolated from zebrafish ovary using Qiagen RNeasy mini kit. Library was constructed using sequencing Lane 1x50 v4 HiSeq single end mode with a read length of 50 bp | miRNA-Seq | TRANSCRIPTOMIC | RT-PCR | SINGLE | ILLUMINA | Illumina HiSeq 2500 | SRP332839 | ZF_28_G5_22312_CCGTCC.fastq ZF_28_G5_24794_CCGTCC.fastq | fastq fastq | 452563650.0 | 9051273.0 | ZF 28 G5 22312 CCGTCC.fastq | 0:50 1:0 | A:134503401;C:100875999;G:120893992;T:96252318;N:37940 | 50 | 0 | 134503401 | 100875999 | 120893992 | 96252318 | 37940 | SRX11797846 | SRS9797780 | SRA1279325 | Institute of Marine Sciences|Repro-Immune Team | Institute of Marine Sciences | 1 | 0.78672 | 0.47976 | 0.82207 | 0.50024 | 50 | B | usable mapping rate | illumina | hiseq_era | unknown | small_rna | nebnext | bulk | unknown | unknown | United States | 2021-08-17 | Adult | Adult | Gonad | Reproductive System | ||||||||||||||||||||||||||
| 65677 | 65677 | SRR15498146 | SRX11797845 | SRS9797781 | SRP332839 | PRJNA755482 | miRNA sequencing from zebrafish testes and ovaries exposed to normal and high temperatures | PRJNA755482 | Other | We exposed zebrafish to elevated temperatures during early development a treatment that is known to result in male skewed sex ratios in order to understand the role of the epigenetic regulation mediated by miRNAs in the gonads. | Testis Low Temperature | ZF 28 G9M | strain:AB|age:90 dpf|sex:male|tissue:Testis|replicate:Biological replicate TLT 4|BioSampleModel:Model organism or animal | miRNA seq of Danio rerio: adult untreated testis | 28 G9 | 28 G9 | NEBNext Small RNA Library Prep Set for Illumina was used on total RNA isolated from zebrafish testis using Qiagen RNeasy mini kit. Library was constructed using sequencing Lane 1x50 v4 HiSeq single end mode with a read length of 50 bp | miRNA-Seq | TRANSCRIPTOMIC | RT-PCR | SINGLE | ILLUMINA | Illumina HiSeq 2500 | SRP332839 | ZF_28_G9_22312_CGTACG.fastq ZF_28_G9_24794_CGTACG.fastq | fastq fastq | 449330450.0 | 8986609.0 | ZF 28 G9 22312 CGTACG.fastq | 0:50 1:0 | A:134080706;C:98827246;G:115871708;T:100512830;N:37960 | 50 | 0 | 134080706 | 98827246 | 115871708 | 100512830 | 37960 | SRX11797845 | SRS9797781 | SRA1279325 | Institute of Marine Sciences|Repro-Immune Team | Institute of Marine Sciences | 1 | 0.7104 | 0.46962 | 0.85752 | 0.51154 | 50 | B | usable mapping rate | illumina | hiseq_era | unknown | small_rna | nebnext | bulk | unknown | unknown | United States | 2021-08-17 | Adult | Adult | Gonad | Reproductive System | ||||||||||||||||||||||||||
| 65678 | 65678 | SRR15498147 | SRX11797844 | SRS9797779 | SRP332839 | PRJNA755482 | miRNA sequencing from zebrafish testes and ovaries exposed to normal and high temperatures | PRJNA755482 | Other | We exposed zebrafish to elevated temperatures during early development a treatment that is known to result in male skewed sex ratios in order to understand the role of the epigenetic regulation mediated by miRNAs in the gonads. | Testis Low Temperature | ZF 28 G10M | strain:AB|age:90 dpf|sex:male|tissue:Testis|replicate:Biological replicate TLT 3|BioSampleModel:Model organism or animal | miRNA seq of Danio rerio: adult untreated testis | 28 G10 | 28 G10 | NEBNext Small RNA Library Prep Set for Illumina was used on total RNA isolated from zebrafish testis using Qiagen RNeasy mini kit. Library was constructed using sequencing Lane 1x50 v4 HiSeq single end mode with a read length of 50 bp | miRNA-Seq | TRANSCRIPTOMIC | RT-PCR | SINGLE | ILLUMINA | Illumina HiSeq 2500 | SRP332839 | ZF_28_G10_22312_GGTAGC.fastq | fastq | 326954650.0 | 6539093.0 | ZF 28 G10 22312 GGTAGC.fastq | 0:50 1:0 | A:96514676;C:71851965;G:86535966;T:72013004;N:39039 | 50 | 0 | 96514676 | 71851965 | 86535966 | 72013004 | 39039 | SRX11797844 | SRS9797779 | SRA1279325 | Institute of Marine Sciences|Repro-Immune Team | Institute of Marine Sciences | 1 | 0.69651 | 0.42268 | 0.84829 | 0.52434 | 50 | B | usable mapping rate | illumina | hiseq_era | unknown | small_rna | nebnext | bulk | unknown | unknown | United States | 2021-08-17 | Adult | Adult | Gonad | Reproductive System | ||||||||||||||||||||||||||
| 65679 | 65679 | SRR15498148 | SRX11797843 | SRS9797777 | SRP332839 | PRJNA755482 | miRNA sequencing from zebrafish testes and ovaries exposed to normal and high temperatures | PRJNA755482 | Other | We exposed zebrafish to elevated temperatures during early development a treatment that is known to result in male skewed sex ratios in order to understand the role of the epigenetic regulation mediated by miRNAs in the gonads. | Testis Low Temperature | ZF 28 G20M | strain:AB|age:90 dpf|sex:male|tissue:Testis|replicate:Biological replicate TLT 6|BioSampleModel:Model organism or animal | miRNA seq of Danio rerio: adult untreated testis | 28 G20 | 28 G20 | NEBNext Small RNA Library Prep Set for Illumina was used on total RNA isolated from zebrafish testis using Qiagen RNeasy mini kit. Library was constructed using sequencing Lane 1x50 v4 HiSeq single end mode with a read length of 50 bp | miRNA-Seq | TRANSCRIPTOMIC | RT-PCR | SINGLE | ILLUMINA | Illumina HiSeq 2500 | SRP332839 | ZF_28_G20_22969_TCGAAG.fastq | fastq | 589981600.0 | 11799632.0 | ZF 28 G20 22969 TCGAAG.fastq | 0:50 1:0 | A:174095296;C:129803577;G:155350315;T:130716263;N:16149 | 50 | 0 | 174095296 | 129803577 | 155350315 | 130716263 | 16149 | SRX11797843 | SRS9797777 | SRA1279325 | Institute of Marine Sciences|Repro-Immune Team | Institute of Marine Sciences | 1 | 0.73394 | 0.46125 | 0.85482 | 0.51049 | 50 | B | usable mapping rate | illumina | hiseq_era | unknown | small_rna | nebnext | bulk | unknown | unknown | United States | 2021-08-17 | Adult | Adult | Gonad | Reproductive System | ||||||||||||||||||||||||||
| 65680 | 65680 | SRR15498149 | SRX11797842 | SRS9797778 | SRP332839 | PRJNA755482 | miRNA sequencing from zebrafish testes and ovaries exposed to normal and high temperatures | PRJNA755482 | Other | We exposed zebrafish to elevated temperatures during early development a treatment that is known to result in male skewed sex ratios in order to understand the role of the epigenetic regulation mediated by miRNAs in the gonads. | Testis Low Temperature | ZF 28 G2M | strain:AB|age:90 dpf|sex:male|tissue:Testis|replicate:Biological replicate TLT 5|BioSampleModel:Model organism or animal | miRNA seq of Danio rerio: adult untreated testis | 28 G2 | 28 G2 | NEBNext Small RNA Library Prep Set for Illumina was used on total RNA isolated from zebrafish testis using Qiagen RNeasy mini kit. Library was constructed using sequencing Lane 1x50 v4 HiSeq single end mode with a read length of 50 bp | miRNA-Seq | TRANSCRIPTOMIC | RT-PCR | SINGLE | ILLUMINA | Illumina HiSeq 2500 | SRP332839 | ZF_28_G2_22969_CATTTT.fastq | fastq | 725495800.0 | 14509916.0 | ZF 28 G2 22969 CATTTT.fastq | 0:50 1:0 | A:215282734;C:159179418;G:191027998;T:159985829;N:19821 | 50 | 0 | 215282734 | 159179418 | 191027998 | 159985829 | 19821 | SRX11797842 | SRS9797778 | SRA1279325 | Institute of Marine Sciences|Repro-Immune Team | Institute of Marine Sciences | 1 | 0.74341 | 0.46282 | 0.86365 | 0.52722 | 50 | B | usable mapping rate | illumina | hiseq_era | unknown | small_rna | nebnext | bulk | unknown | unknown | United States | 2021-08-17 | Adult | Adult | Gonad | Reproductive System | ||||||||||||||||||||||||||
| 65681 | 65681 | SRR15498150 | SRX11797841 | SRS9797776 | SRP332839 | PRJNA755482 | miRNA sequencing from zebrafish testes and ovaries exposed to normal and high temperatures | PRJNA755482 | Other | We exposed zebrafish to elevated temperatures during early development a treatment that is known to result in male skewed sex ratios in order to understand the role of the epigenetic regulation mediated by miRNAs in the gonads. | Testis High Temperature | ZF 36 G10M | strain:AB|age:90 dpf|sex:male|tissue:Testis|replicate:Biological replicate THT 4|BioSampleModel:Model organism or animal | miRNA seq of Danio rerio: adult treated testis | 36 G10 | 36 G10 | NEBNext Small RNA Library Prep Set for Illumina was used on total RNA isolated from zebrafish testis using Qiagen RNeasy mini kit. Library was constructed using sequencing Lane 1x50 v4 HiSeq single end mode with a read length of 50 bp | miRNA-Seq | TRANSCRIPTOMIC | RT-PCR | SINGLE | ILLUMINA | Illumina HiSeq 2500 | SRP332839 | ZF_36_G10_22313_ATTCCT.fastq | fastq | 301310100.0 | 6026202.0 | ZF 36 G10 22313 ATTCCT.fastq | 0:50 1:0 | A:89802405;C:66792192;G:77376709;T:67302456;N:36338 | 50 | 0 | 89802405 | 66792192 | 77376709 | 67302456 | 36338 | SRX11797841 | SRS9797776 | SRA1279325 | Institute of Marine Sciences|Repro-Immune Team | Institute of Marine Sciences | 1 | 0.69865 | 0.45741 | 0.86354 | 0.51584 | 50 | B | usable mapping rate | illumina | hiseq_era | unknown | small_rna | nebnext | bulk | unknown | unknown | United States | 2021-08-17 | Adult | Adult | Gonad | Reproductive System | ||||||||||||||||||||||||||
| 65682 | 65682 | SRR15498151 | SRX11797840 | SRS9797775 | SRP332839 | PRJNA755482 | miRNA sequencing from zebrafish testes and ovaries exposed to normal and high temperatures | PRJNA755482 | Other | We exposed zebrafish to elevated temperatures during early development a treatment that is known to result in male skewed sex ratios in order to understand the role of the epigenetic regulation mediated by miRNAs in the gonads. | Testis High Temperature | ZF 36 G15M | strain:AB|age:90 dpf|sex:male|tissue:Testis|replicate:Biological replicate THT 3|BioSampleModel:Model organism or animal | miRNA seq of Danio rerio: adult treated testis | 36 G15 | 36 G15 | NEBNext Small RNA Library Prep Set for Illumina was used on total RNA isolated from zebrafish testis using Qiagen RNeasy mini kit. Library was constructed using sequencing Lane 1x50 v4 HiSeq single end mode with a read length of 50 bp | miRNA-Seq | TRANSCRIPTOMIC | RT-PCR | SINGLE | ILLUMINA | Illumina HiSeq 2500 | SRP332839 | ZF_36_G15_22313_TCATTC.fastq | fastq | 1465003700.0 | 29300074.0 | ZF 36 G15 22313 TCATTC.fastq | 0:50 1:0 | A:431488151;C:331693370;G:386155519;T:315491607;N:175053 | 50 | 0 | 431488151 | 331693370 | 386155519 | 315491607 | 175053 | SRX11797840 | SRS9797775 | SRA1279325 | Institute of Marine Sciences|Repro-Immune Team | Institute of Marine Sciences | 1 | 0.72513 | 0.40489 | 0.86229 | 0.50704 | 50 | B | usable mapping rate | illumina | hiseq_era | unknown | small_rna | nebnext | bulk | unknown | unknown | United States | 2021-08-17 | Adult | Adult | Gonad | Reproductive System | ||||||||||||||||||||||||||
| 65683 | 65683 | SRR15498152 | SRX11797839 | SRS9797774 | SRP332839 | PRJNA755482 | miRNA sequencing from zebrafish testes and ovaries exposed to normal and high temperatures | PRJNA755482 | Other | We exposed zebrafish to elevated temperatures during early development a treatment that is known to result in male skewed sex ratios in order to understand the role of the epigenetic regulation mediated by miRNAs in the gonads. | Testis High Temperature | ZF 36 G14M | strain:AB|age:90 dpf|sex:male|tissue:Testis|replicate:Biological replicate THT 2|BioSampleModel:Model organism or animal | miRNA seq of Danio rerio: adult treated testis | 36 G14 | 36 G14 | NEBNext Small RNA Library Prep Set for Illumina was used on total RNA isolated from zebrafish testis using Qiagen RNeasy mini kit. Library was constructed using sequencing Lane 1x50 v4 HiSeq single end mode with a read length of 50 bp | miRNA-Seq | TRANSCRIPTOMIC | RT-PCR | SINGLE | ILLUMINA | Illumina HiSeq 2500 | SRP332839 | ZF_36_G14_22313_CACGAT.fastq ZF_36_G14_24794_CACGAT.fastq | fastq fastq | 454229750.0 | 9084595.0 | ZF 36 G14 22313 CACGAT.fastq | 0:50 1:0 | A:133880771;C:103643537;G:119108795;T:97573024;N:23623 | 50 | 0 | 133880771 | 103643537 | 119108795 | 97573024 | 23623 | SRX11797839 | SRS9797774 | SRA1279325 | Institute of Marine Sciences|Repro-Immune Team | Institute of Marine Sciences | 1 | 0.67716 | 0.38799 | 0.81949 | 0.53484 | 50 | B | usable mapping rate | illumina | hiseq_era | unknown | small_rna | nebnext | bulk | unknown | unknown | United States | 2021-08-17 | Adult | Adult | Gonad | Reproductive System | ||||||||||||||||||||||||||
| 65684 | 65684 | SRR15498153 | SRX11797838 | SRS9797773 | SRP332839 | PRJNA755482 | miRNA sequencing from zebrafish testes and ovaries exposed to normal and high temperatures | PRJNA755482 | Other | We exposed zebrafish to elevated temperatures during early development a treatment that is known to result in male skewed sex ratios in order to understand the role of the epigenetic regulation mediated by miRNAs in the gonads. | Testis High Temperature | ZF 36 G11M | strain:AB|age:90 dpf|sex:male|tissue:Testis|replicate:Biological replicate THT 1|BioSampleModel:Model organism or animal | miRNA seq of Danio rerio: adult treated testis | 36 G11 | 36 G11 | NEBNext Small RNA Library Prep Set for Illumina was used on total RNA isolated from zebrafish testis using Qiagen RNeasy mini kit. Library was constructed using sequencing Lane 1x50 v4 HiSeq single end mode with a read length of 50 bp | miRNA-Seq | TRANSCRIPTOMIC | RT-PCR | SINGLE | ILLUMINA | Illumina HiSeq 2500 | SRP332839 | ZF_36_G11_22313_CAAAAG.fastq | fastq | 309077000.0 | 6181540.0 | ZF 36 G11 22313 CAAAAG.fastq | 0:50 1:0 | A:92340462;C:68123395;G:79403422;T:69172711;N:37010 | 50 | 0 | 92340462 | 68123395 | 79403422 | 69172711 | 37010 | SRX11797838 | SRS9797773 | SRA1279325 | Institute of Marine Sciences|Repro-Immune Team | Institute of Marine Sciences | 1 | 0.68141 | 0.45311 | 0.86519 | 0.52771 | 50 | B | usable mapping rate | illumina | hiseq_era | unknown | small_rna | nebnext | bulk | unknown | unknown | United States | 2021-08-17 | Adult | Adult | Gonad | Reproductive System | ||||||||||||||||||||||||||
| 65685 | 65685 | SRR15498154 | SRX11797837 | SRS9797772 | SRP332839 | PRJNA755482 | miRNA sequencing from zebrafish testes and ovaries exposed to normal and high temperatures | PRJNA755482 | Other | We exposed zebrafish to elevated temperatures during early development a treatment that is known to result in male skewed sex ratios in order to understand the role of the epigenetic regulation mediated by miRNAs in the gonads. | Testis High Temperature | ZF 36 G13M | strain:AB|age:90 dpf|sex:male|tissue:Testis|replicate:Biological replicate THT 5|BioSampleModel:Model organism or animal | miRNA seq of Danio rerio: adult treated testis | 36 G13 | 36 G13 | NEBNext Small RNA Library Prep Set for Illumina was used on total RNA isolated from zebrafish testis using Qiagen RNeasy mini kit. Library was constructed using sequencing Lane 1x50 v4 HiSeq single end mode with a read length of 50 bp | miRNA-Seq | TRANSCRIPTOMIC | RT-PCR | SINGLE | ILLUMINA | Illumina HiSeq 2500 | SRP332839 | ZF_36_G13_22969_TCGGCA.fastq | fastq | 525673800.0 | 10513476.0 | ZF 36 G13 22969 TCGGCA.fastq | 0:50 1:0 | A:154723201;C:115780155;G:137702409;T:117453866;N:14169 | 50 | 0 | 154723201 | 115780155 | 137702409 | 117453866 | 14169 | SRX11797837 | SRS9797772 | SRA1279325 | Institute of Marine Sciences|Repro-Immune Team | Institute of Marine Sciences | 1 | 0.74813 | 0.46889 | 0.85299 | 0.51699 | 50 | B | usable mapping rate | illumina | hiseq_era | unknown | small_rna | nebnext | bulk | unknown | unknown | United States | 2021-08-17 | Adult | Adult | Gonad | Reproductive System | ||||||||||||||||||||||||||
| 65686 | 65686 | SRR15498155 | SRX11797836 | SRS9797771 | SRP332839 | PRJNA755482 | miRNA sequencing from zebrafish testes and ovaries exposed to normal and high temperatures | PRJNA755482 | Other | We exposed zebrafish to elevated temperatures during early development a treatment that is known to result in male skewed sex ratios in order to understand the role of the epigenetic regulation mediated by miRNAs in the gonads. | Ovary High Temperature | ZF 36 G8F | strain:AB|age:90 dpf|sex:female|tissue:Ovary|replicate:Biological replicate OHT 4|BioSampleModel:Model organism or animal | miRNA seq of Danio rerio: adult treated ovary | 36 G8 | 36 G8 | NEBNext Small RNA Library Prep Set for Illumina was used on total RNA isolated from zebrafish ovary using Qiagen RNeasy mini kit. Library was constructed using sequencing Lane 1x50 v4 HiSeq single end mode with a read length of 50 bp | miRNA-Seq | TRANSCRIPTOMIC | RT-PCR | SINGLE | ILLUMINA | Illumina HiSeq 2500 | SRP332839 | ZF_36_G8_22313_GTGAAA.fastq ZF_36_G8_24794_GTGAAA.fastq | fastq fastq | 354863200.0 | 7097264.0 | ZF 36 G8 22313 GTGAAA.fastq | 0:50 1:0 | A:106167879;C:78499963;G:93422866;T:76761338;N:11154 | 50 | 0 | 106167879 | 78499963 | 93422866 | 76761338 | 11154 | SRX11797836 | SRS9797771 | SRA1279325 | Institute of Marine Sciences|Repro-Immune Team | Institute of Marine Sciences | 1 | 0.74342 | 0.50048 | 0.82919 | 0.51092 | 50 | B | usable mapping rate | illumina | hiseq_era | unknown | small_rna | nebnext | bulk | unknown | unknown | United States | 2021-08-17 | Adult | Adult | Gonad | Reproductive System | ||||||||||||||||||||||||||
| 65687 | 65687 | SRR15498156 | SRX11797835 | SRS9797770 | SRP332839 | PRJNA755482 | miRNA sequencing from zebrafish testes and ovaries exposed to normal and high temperatures | PRJNA755482 | Other | We exposed zebrafish to elevated temperatures during early development a treatment that is known to result in male skewed sex ratios in order to understand the role of the epigenetic regulation mediated by miRNAs in the gonads. | Ovary High Temperature | ZF 36 G6F | strain:AB|age:90 dpf|sex:female|tissue:Ovary|replicate:Biological replicate OHT 3|BioSampleModel:Model organism or animal | miRNA seq of Danio rerio: adult treated ovary | 36 G6 | 36 G6 | NEBNext Small RNA Library Prep Set for Illumina was used on total RNA isolated from zebrafish ovary using Qiagen RNeasy mini kit. Library was constructed using sequencing Lane 1x50 v4 HiSeq single end mode with a read length of 50 bp | miRNA-Seq | TRANSCRIPTOMIC | RT-PCR | SINGLE | ILLUMINA | Illumina HiSeq 2500 | SRP332839 | ZF_36_G6_22313_GTCCGC.fastq ZF_36_G6_24794_GTCCGC.fastq | fastq fastq | 369579500.0 | 7391590.0 | ZF 36 G6 22313 GTCCGC.fastq | 0:50 1:0 | A:110926203;C:80638311;G:95343987;T:82657357;N:13642 | 50 | 0 | 110926203 | 80638311 | 95343987 | 82657357 | 13642 | SRX11797835 | SRS9797770 | SRA1279325 | Institute of Marine Sciences|Repro-Immune Team | Institute of Marine Sciences | 1 | 0.74041 | 0.54329 | 0.82923 | 0.52999 | 50 | B | usable mapping rate | illumina | hiseq_era | unknown | small_rna | nebnext | bulk | unknown | unknown | United States | 2021-08-17 | Adult | Adult | Gonad | Reproductive 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");;