run_metadata
27 rows where experiment.library_layout = "SINGLE", experiment.library_strategy = "miRNA-Seq" and experiment.platform = "BGISEQ"
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 | |||||||||||||||||||||||||||
| 60445 | 60445 | SRR12272862 | SRX8777892 | SRS7048444 | SRP272672 | PRJNA647444 | mRNA and miRNA Seq in offspring post parental exposure to an antibiotic mixturemiRNA | PRJNA647444 | Other | Zebrafish embryos were exposed to environmentally relevant levels 1 and 100 ug/L of antibiotic mixtures 15 of the most commonly detected antibiotics for 150 days until sexual maturation. miRNA mRNA network analysis in offspring post parental exposure to an antibiotic mixture. | C2 | C2 C2 2 4 | replicate:biological replicate 2|strain:AB|isolate:C2|breed:not applicable|cultivar:not applicable|ecotype:not applicable|age:not applicable|dev stage:not applicable|sex:pooled male and female|tissue:the whole|collection date:2019 11 01|geo loc name:China: Shenzhen Guangdong|phenotype:100ug/L|BioSampleModel:Model organism or animal | RNA seq of zebrafish | C2C220200712 | C2C220200712 | RNA seq of zebrafish in different conditions | miRNA-Seq | TRANSCRIPTOMIC | RANDOM PCR | SINGLE | BGISEQ | BGISEQ-500 | SRP272672 | loader:fastq load.py | C2_C2_2_4.fq | fastq | 542610936.0 | 21965958.0 | C2 C2 2 4.fq.gz | 0:24.70 | A:95221617;C:122628624;G:167025611;T:157730855;N:4229 | 24 | 95221617 | 122628624 | 167025611 | 157730855 | 4229 | SRX8777892 | SRS7048444 | SRA1101037 | Southern University of Science and Technology|School of Environmental Science and Engineering | Southern University of Science and Technology | 1 | 0.8119 | 0.10745 | 0.85717 | 0.51338 | 22 | B | usable mapping rate | bgi | bgi | unknown | random_priming | unknown | bulk | unknown | unknown | China | 2020-08-05 | Undetermined | Embryo | Whole Organism | All anatomical structures | ||||||||||||||||||||||||||
| 60446 | 60446 | SRR12272863 | SRX8777891 | SRS7048443 | SRP272672 | PRJNA647444 | mRNA and miRNA Seq in offspring post parental exposure to an antibiotic mixturemiRNA | PRJNA647444 | Other | Zebrafish embryos were exposed to environmentally relevant levels 1 and 100 ug/L of antibiotic mixtures 15 of the most commonly detected antibiotics for 150 days until sexual maturation. miRNA mRNA network analysis in offspring post parental exposure to an antibiotic mixture. | C2 | C2 C2 1 4 | replicate:biological replicate 1|strain:AB|isolate:C2|breed:not applicable|cultivar:not applicable|ecotype:not applicable|age:not applicable|dev stage:not applicable|sex:pooled male and female|tissue:the whole|collection date:2019 11 01|geo loc name:China: Shenzhen Guangdong|phenotype:100ug/L|BioSampleModel:Model organism or animal | RNA seq of zebrafish | C2C220200711 | C2C220200711 | RNA seq of zebrafish in different conditions | miRNA-Seq | TRANSCRIPTOMIC | RANDOM PCR | SINGLE | BGISEQ | BGISEQ-500 | SRP272672 | loader:fastq load.py | C2_C2_1_4.fq | fastq | 542847476.0 | 22614181.0 | C2 C2 1 4.fq.gz | 0:24.00 | A:99999101;C:125407906;G:162383758;T:155055099;N:1612 | 24 | 99999101 | 125407906 | 162383758 | 155055099 | 1612 | SRX8777891 | SRS7048443 | SRA1101037 | Southern University of Science and Technology|School of Environmental Science and Engineering | Southern University of Science and Technology | 1 | 0.84327 | 0.10491 | 0.83256 | 0.52046 | 19 | B | usable mapping rate | bgi | bgi | unknown | random_priming | unknown | bulk | unknown | unknown | China | 2020-08-05 | Undetermined | Embryo | Whole Organism | All anatomical structures | ||||||||||||||||||||||||||
| 60447 | 60447 | SRR12272864 | SRX8777890 | SRS7048442 | SRP272672 | PRJNA647444 | mRNA and miRNA Seq in offspring post parental exposure to an antibiotic mixturemiRNA | PRJNA647444 | Other | Zebrafish embryos were exposed to environmentally relevant levels 1 and 100 ug/L of antibiotic mixtures 15 of the most commonly detected antibiotics for 150 days until sexual maturation. miRNA mRNA network analysis in offspring post parental exposure to an antibiotic mixture. | C1 | C1 C1 2 4 | replicate:biological replicate 2|strain:AB|isolate:C1|breed:not applicable|cultivar:not applicable|ecotype:not applicable|age:not applicable|dev stage:not applicable|sex:pooled male and female|tissue:the whole|collection date:2019 11 01|geo loc name:China: Shenzhen Guangdong|phenotype:1ug/L|BioSampleModel:Model organism or animal | RNA seq of zebrafish | C1C120200712 | C1C120200712 | RNA seq of zebrafish in different conditions | miRNA-Seq | TRANSCRIPTOMIC | RANDOM PCR | SINGLE | BGISEQ | BGISEQ-500 | SRP272672 | loader:fastq load.py | C1_C1_2_4.fq | fastq | 570918284.0 | 22577002.0 | C1 C1 2 4.fq.gz | 0:25.29 | A:100121235;C:130480588;G:178656113;T:161652765;N:7583 | 25 | 100121235 | 130480588 | 178656113 | 161652765 | 7583 | SRX8777890 | SRS7048442 | SRA1101037 | Southern University of Science and Technology|School of Environmental Science and Engineering | Southern University of Science and Technology | 1 | 0.85096 | 0.12542 | 0.82873 | 0.51535 | 22 | B | usable mapping rate | bgi | bgi | unknown | random_priming | unknown | bulk | unknown | unknown | China | 2020-08-05 | Undetermined | Embryo | Whole Organism | All anatomical structures | ||||||||||||||||||||||||||
| 60448 | 60448 | SRR12272865 | SRX8777889 | SRS7048441 | SRP272672 | PRJNA647444 | mRNA and miRNA Seq in offspring post parental exposure to an antibiotic mixturemiRNA | PRJNA647444 | Other | Zebrafish embryos were exposed to environmentally relevant levels 1 and 100 ug/L of antibiotic mixtures 15 of the most commonly detected antibiotics for 150 days until sexual maturation. miRNA mRNA network analysis in offspring post parental exposure to an antibiotic mixture. | C1 | C1 C1 1 4 | replicate:biological replicate 1|strain:AB|isolate:C1|breed:not applicable|cultivar:not applicable|ecotype:not applicable|age:not applicable|dev stage:not applicable|sex:pooled male and female|tissue:the whole|collection date:2019 11 01|geo loc name:China: Shenzhen Guangdong|phenotype:1ug/L|BioSampleModel:Model organism or animal | RNA seq of zebrafish | C1C120200711 | C1C120200711 | RNA seq of zebrafish in different conditions | miRNA-Seq | TRANSCRIPTOMIC | RANDOM PCR | SINGLE | BGISEQ | BGISEQ-500 | SRP272672 | loader:fastq load.py | C1_C1_1_4.fq | fastq | 545089417.0 | 22812164.0 | C1 C1 1 4.fq.gz | 0:23.89 | A:99851844;C:125314095;G:166401335;T:153521167;N:976 | 23 | 99851844 | 125314095 | 166401335 | 153521167 | 976 | SRX8777889 | SRS7048441 | SRA1101037 | Southern University of Science and Technology|School of Environmental Science and Engineering | Southern University of Science and Technology | 1 | 0.84602 | 0.11725 | 0.83159 | 0.51353 | 19 | B | usable mapping rate | bgi | bgi | unknown | random_priming | unknown | bulk | unknown | unknown | China | 2020-08-05 | Undetermined | Embryo | Whole Organism | All anatomical structures | ||||||||||||||||||||||||||
| 60449 | 60449 | SRR12272866 | SRX8777888 | SRS7048440 | SRP272672 | PRJNA647444 | mRNA and miRNA Seq in offspring post parental exposure to an antibiotic mixturemiRNA | PRJNA647444 | Other | Zebrafish embryos were exposed to environmentally relevant levels 1 and 100 ug/L of antibiotic mixtures 15 of the most commonly detected antibiotics for 150 days until sexual maturation. miRNA mRNA network analysis in offspring post parental exposure to an antibiotic mixture. | C0 | C0 C0 2 4 | replicate:biological replicate 2|strain:AB|isolate:C0|breed:not applicable|cultivar:not applicable|ecotype:not applicable|age:not applicable|dev stage:not applicable|sex:pooled male and female|tissue:the whole|collection date:2019 11 01|geo loc name:China: Shenzhen Guangdong|phenotype:0ug/L|BioSampleModel:Model organism or animal | RNA seq of zebrafish | C0C020200712 | C0C020200712 | RNA seq of zebrafish in different conditions | miRNA-Seq | TRANSCRIPTOMIC | RANDOM PCR | SINGLE | BGISEQ | BGISEQ-500 | SRP272672 | loader:fastq load.py | C0_C0_2_4.fq | fastq | 527443144.0 | 23174740.0 | C0 C0 2 4.fq.gz | 0:22.76 | A:102368401;C:120843229;G:151690193;T:152540806;N:515 | 22 | 102368401 | 120843229 | 151690193 | 152540806 | 515 | SRX8777888 | SRS7048440 | SRA1101037 | Southern University of Science and Technology|School of Environmental Science and Engineering | Southern University of Science and Technology | 1 | 0.83063 | 0.08114 | 0.85169 | 0.50894 | 16 | B | usable mapping rate | bgi | bgi | unknown | random_priming | unknown | bulk | unknown | unknown | China | 2020-08-05 | Undetermined | Embryo | Whole Organism | All anatomical structures | ||||||||||||||||||||||||||
| 60450 | 60450 | SRR12272867 | SRX8777887 | SRS7048439 | SRP272672 | PRJNA647444 | mRNA and miRNA Seq in offspring post parental exposure to an antibiotic mixturemiRNA | PRJNA647444 | Other | Zebrafish embryos were exposed to environmentally relevant levels 1 and 100 ug/L of antibiotic mixtures 15 of the most commonly detected antibiotics for 150 days until sexual maturation. miRNA mRNA network analysis in offspring post parental exposure to an antibiotic mixture. | C0 | C0 C0 1 4 | replicate:biological replicate 1|strain:AB|isolate:C0|breed:not applicable|cultivar:not applicable|ecotype:not applicable|age:not applicable|dev stage:not applicable|sex:pooled male and female|tissue:the whole|collection date:2019 11 01|geo loc name:China: Shenzhen Guangdong|phenotype:0ug/L|BioSampleModel:Model organism or animal | RNA seq of zebrafish | C0C020200711 | C0C020200711 | RNA seq of zebrafish in different conditions | miRNA-Seq | TRANSCRIPTOMIC | RANDOM PCR | SINGLE | BGISEQ | BGISEQ-500 | SRP272672 | loader:fastq load.py | C0_C0_1_4.fq | fastq | 511759408.0 | 22673361.0 | C0 C0 1 4.fq.gz | 0:22.57 | A:100879182;C:120237907;G:142799495;T:147842595;N:229 | 22 | 100879182 | 120237907 | 142799495 | 147842595 | 229 | SRX8777887 | SRS7048439 | SRA1101037 | Southern University of Science and Technology|School of Environmental Science and Engineering | Southern University of Science and Technology | 1 | 0.83904 | 0.0823 | 0.84741 | 0.49929 | 22 | B | usable mapping rate | bgi | bgi | unknown | random_priming | unknown | bulk | unknown | unknown | China | 2020-08-05 | Undetermined | Embryo | Whole Organism | All anatomical structures | ||||||||||||||||||||||||||
| 71643 | 71643 | SRR21869762 | SRX17856938 | SRS15377982 | SRP402080 | PRJNA889683 | miRNA mRNA sequencing of zebrafish embryos | PRJNA889683 | Other | miRNA Seq and RNA Seq data of zebrafish embryos post exposure to TBBPA and TBBPA BHEE | BHEE H 3 | replicate:biological replicate 3|strain:AB|isolate:not applicable|breed:wild type|cultivar:not applicable|ecotype:not applicable|age:120 hpf|dev stage:larvae|sex:not applicable|tissue:whole body 15|BioSampleModel:Model organism or animal | miRNA Seq of zebrafish larvae | AT20221124 | AT20221124 | miRNA Seq of zebrafish larvae | miRNA-Seq | TRANSCRIPTOMIC | size fractionation | SINGLE | BGISEQ | BGISEQ-500 | SRP402080 | loader:fastq load.py | BHEE_H_3.fq.gz | fastq | 533428889.0 | 23211223.0 | BHEE H 3.fq.gz | 0:22.98 | A:120057830;C:104713991;G:142506271;T:166150296;N:501 | 22 | 120057830 | 104713991 | 142506271 | 166150296 | 501 | SRX17856938 | SRS15377982 | SRA1518395 | Jiangsu University|School of Environment and Safety Engineering | Jiangsu University | 1 | 0.79272 | 0.10596 | 0.92431 | 0.52918 | 22 | B | usable mapping rate | bgi | bgi | unknown | size_fractionation | unknown | bulk | unknown | unknown | China | 2022-10-12 | Larval | Larval | Trunk | Surface Structure | |||||||||||||||||||||||||||
| 71644 | 71644 | SRR21869763 | SRX17856937 | SRS15377981 | SRP402080 | PRJNA889683 | miRNA mRNA sequencing of zebrafish embryos | PRJNA889683 | Other | miRNA Seq and RNA Seq data of zebrafish embryos post exposure to TBBPA and TBBPA BHEE | BHEE H 2 | replicate:biological replicate 2|strain:AB|isolate:not applicable|breed:wild type|cultivar:not applicable|ecotype:not applicable|age:120 hpf|dev stage:larvae|sex:not applicable|tissue:whole body 14|BioSampleModel:Model organism or animal | miRNA Seq of zebrafish larvae | AT20221123 | AT20221123 | miRNA Seq of zebrafish larvae | miRNA-Seq | TRANSCRIPTOMIC | size fractionation | SINGLE | BGISEQ | BGISEQ-500 | SRP402080 | loader:fastq load.py | BHEE_H_2.fq.gz | fastq | 542237520.0 | 23757627.0 | BHEE H 2.fq.gz | 0:22.82 | A:118608004;C:107602147;G:146341292;T:169685803;N:274 | 22 | 118608004 | 107602147 | 146341292 | 169685803 | 274 | SRX17856937 | SRS15377981 | SRA1518395 | Jiangsu University|School of Environment and Safety Engineering | Jiangsu University | 1 | 0.78829 | 0.10064 | 0.91346 | 0.52625 | 22 | B | usable mapping rate | bgi | bgi | unknown | size_fractionation | unknown | bulk | unknown | unknown | China | 2022-10-12 | Larval | Larval | Trunk | Surface Structure | |||||||||||||||||||||||||||
| 71645 | 71645 | SRR21869764 | SRX17856936 | SRS15377980 | SRP402080 | PRJNA889683 | miRNA mRNA sequencing of zebrafish embryos | PRJNA889683 | Other | miRNA Seq and RNA Seq data of zebrafish embryos post exposure to TBBPA and TBBPA BHEE | BHEE H 1 | replicate:biological replicate 1|strain:AB|isolate:not applicable|breed:wild type|cultivar:not applicable|ecotype:not applicable|age:120 hpf|dev stage:larvae|sex:not applicable|tissue:whole body 13|BioSampleModel:Model organism or animal | miRNA Seq of zebrafish larvae | AT20221122 | AT20221122 | miRNA Seq of zebrafish larvae | miRNA-Seq | TRANSCRIPTOMIC | size fractionation | SINGLE | BGISEQ | BGISEQ-500 | SRP402080 | loader:fastq load.py | BHEE_H_1.fq.gz | fastq | 553437966.0 | 24068768.0 | BHEE H 1.fq.gz | 0:22.99 | A:123764056;C:109954264;G:151884637;T:167834745;N:264 | 22 | 123764056 | 109954264 | 151884637 | 167834745 | 264 | SRX17856936 | SRS15377980 | SRA1518395 | Jiangsu University|School of Environment and Safety Engineering | Jiangsu University | 1 | 0.70849 | 0.09465 | 0.91768 | 0.52194 | 22 | B | usable mapping rate | bgi | bgi | unknown | size_fractionation | unknown | bulk | unknown | unknown | China | 2022-10-12 | Larval | Larval | Trunk | Surface Structure | |||||||||||||||||||||||||||
| 71646 | 71646 | SRR21869765 | SRX17856935 | SRS15377979 | SRP402080 | PRJNA889683 | miRNA mRNA sequencing of zebrafish embryos | PRJNA889683 | Other | miRNA Seq and RNA Seq data of zebrafish embryos post exposure to TBBPA and TBBPA BHEE | BHEE L 3 | replicate:biological replicate 3|strain:AB|isolate:not applicable|breed:wild type|cultivar:not applicable|ecotype:not applicable|age:120 hpf|dev stage:larvae|sex:not applicable|tissue:whole body 12|BioSampleModel:Model organism or animal | miRNA Seq of zebrafish larvae | AT20221121 | AT20221121 | miRNA Seq of zebrafish larvae | miRNA-Seq | TRANSCRIPTOMIC | size fractionation | SINGLE | BGISEQ | BGISEQ-500 | SRP402080 | loader:fastq load.py | BHEE_L_3.fq.gz | fastq | 534633614.0 | 23823089.0 | BHEE L 3.fq.gz | 0:22.44 | A:117363754;C:102332510;G:134833529;T:180103711;N:110 | 22 | 117363754 | 102332510 | 134833529 | 180103711 | 110 | SRX17856935 | SRS15377979 | SRA1518395 | Jiangsu University|School of Environment and Safety Engineering | Jiangsu University | 1 | 0.91988 | 0.08325 | 0.94073 | 0.53253 | 23 | B | usable mapping rate | bgi | bgi | unknown | size_fractionation | unknown | bulk | unknown | unknown | China | 2022-10-12 | Larval | Larval | Trunk | Surface Structure | |||||||||||||||||||||||||||
| 71647 | 71647 | SRR21869766 | SRX17856934 | SRS15377978 | SRP402080 | PRJNA889683 | miRNA mRNA sequencing of zebrafish embryos | PRJNA889683 | Other | miRNA Seq and RNA Seq data of zebrafish embryos post exposure to TBBPA and TBBPA BHEE | BHEE L 2 | replicate:biological replicate 2|strain:AB|isolate:not applicable|breed:wild type|cultivar:not applicable|ecotype:not applicable|age:120 hpf|dev stage:larvae|sex:not applicable|tissue:whole body 11|BioSampleModel:Model organism or animal | miRNA Seq of zebrafish larvae | AT20221120 | AT20221120 | miRNA Seq of zebrafish larvae | miRNA-Seq | TRANSCRIPTOMIC | size fractionation | SINGLE | BGISEQ | BGISEQ-500 | SRP402080 | loader:fastq load.py | BHEE_L_2.fq.gz | fastq | 544854900.0 | 24226737.0 | BHEE L 2.fq.gz | 0:22.49 | A:119782823;C:104902871;G:136756907;T:183412172;N:127 | 22 | 119782823 | 104902871 | 136756907 | 183412172 | 127 | SRX17856934 | SRS15377978 | SRA1518395 | Jiangsu University|School of Environment and Safety Engineering | Jiangsu University | 1 | 0.93474 | 0.08179 | 0.9345 | 0.52916 | 22 | B | usable mapping rate | bgi | bgi | unknown | size_fractionation | unknown | bulk | unknown | unknown | China | 2022-10-12 | Larval | Larval | Trunk | Surface Structure | |||||||||||||||||||||||||||
| 71648 | 71648 | SRR21869767 | SRX17856933 | SRS15377990 | SRP402080 | PRJNA889683 | miRNA mRNA sequencing of zebrafish embryos | PRJNA889683 | Other | miRNA Seq and RNA Seq data of zebrafish embryos post exposure to TBBPA and TBBPA BHEE | BHEE L 1 | replicate:biological replicate 1|strain:AB|isolate:not applicable|breed:wild type|cultivar:not applicable|ecotype:not applicable|age:120 hpf|dev stage:larvae|sex:not applicable|tissue:whole body 10|BioSampleModel:Model organism or animal | miRNA Seq of zebrafish larvae | AT20221119 | AT20221119 | miRNA Seq of zebrafish larvae | miRNA-Seq | TRANSCRIPTOMIC | size fractionation | SINGLE | BGISEQ | BGISEQ-500 | SRP402080 | loader:fastq load.py | BHEE_L_1.fq.gz | fastq | 536871966.0 | 23768969.0 | BHEE L 1.fq.gz | 0:22.59 | A:117321330;C:102381550;G:133641788;T:183527144;N:154 | 22 | 117321330 | 102381550 | 133641788 | 183527144 | 154 | SRX17856933 | SRS15377990 | SRA1518395 | Jiangsu University|School of Environment and Safety Engineering | Jiangsu University | 1 | 0.94042 | 0.08986 | 0.93141 | 0.51821 | 22 | B | usable mapping rate | bgi | bgi | unknown | size_fractionation | unknown | bulk | unknown | unknown | China | 2022-10-12 | Larval | Larval | Trunk | Surface Structure | |||||||||||||||||||||||||||
| 71649 | 71649 | SRR21869768 | SRX17856932 | SRS15377989 | SRP402080 | PRJNA889683 | miRNA mRNA sequencing of zebrafish embryos | PRJNA889683 | Other | miRNA Seq and RNA Seq data of zebrafish embryos post exposure to TBBPA and TBBPA BHEE | TBBPA H 3 | replicate:biological replicate 3|strain:AB|isolate:not applicable|breed:wild type|cultivar:not applicable|ecotype:not applicable|age:120 hpf|dev stage:larvae|sex:not applicable|tissue:whole body 9|BioSampleModel:Model organism or animal | miRNA Seq of zebrafish larvae | AT20221118 | AT20221118 | miRNA Seq of zebrafish larvae | miRNA-Seq | TRANSCRIPTOMIC | size fractionation | SINGLE | BGISEQ | BGISEQ-500 | SRP402080 | loader:fastq load.py | TBBPA_H_3.fq.gz | fastq | 528430937.0 | 23464221.0 | TBBPA H 3.fq.gz | 0:22.52 | A:115261465;C:101477007;G:136961367;T:174730904;N:194 | 22 | 115261465 | 101477007 | 136961367 | 174730904 | 194 | SRX17856932 | SRS15377989 | SRA1518395 | Jiangsu University|School of Environment and Safety Engineering | Jiangsu University | 1 | 0.89616 | 0.09929 | 0.93042 | 0.5004 | 22 | B | usable mapping rate | bgi | bgi | unknown | size_fractionation | unknown | bulk | unknown | unknown | China | 2022-10-12 | Larval | Larval | Trunk | Surface Structure | |||||||||||||||||||||||||||
| 71650 | 71650 | SRR21869769 | SRX17856931 | SRS15377988 | SRP402080 | PRJNA889683 | miRNA mRNA sequencing of zebrafish embryos | PRJNA889683 | Other | miRNA Seq and RNA Seq data of zebrafish embryos post exposure to TBBPA and TBBPA BHEE | TBBPA H 2 | replicate:biological replicate 2|strain:AB|isolate:not applicable|breed:wild type|cultivar:not applicable|ecotype:not applicable|age:120 hpf|dev stage:larvae|sex:not applicable|tissue:whole body 8|BioSampleModel:Model organism or animal | miRNA Seq of zebrafish larvae | AT20221117 | AT20221117 | miRNA Seq of zebrafish larvae | miRNA-Seq | TRANSCRIPTOMIC | size fractionation | SINGLE | BGISEQ | BGISEQ-500 | SRP402080 | loader:fastq load.py | TBBPA_H_2.fq.gz | fastq | 523343500.0 | 22888420.0 | TBBPA H 2.fq.gz | 0:22.86 | A:114272050;C:101352294;G:133914155;T:173804699;N:302 | 22 | 114272050 | 101352294 | 133914155 | 173804699 | 302 | SRX17856931 | SRS15377988 | SRA1518395 | Jiangsu University|School of Environment and Safety Engineering | Jiangsu University | 1 | 0.90842 | 0.10759 | 0.92088 | 0.53284 | 20 | B | usable mapping rate | bgi | bgi | unknown | size_fractionation | unknown | bulk | unknown | unknown | China | 2022-10-12 | Larval | Larval | Trunk | Surface Structure | |||||||||||||||||||||||||||
| 71651 | 71651 | SRR21869770 | SRX17856930 | SRS15377987 | SRP402080 | PRJNA889683 | miRNA mRNA sequencing of zebrafish embryos | PRJNA889683 | Other | miRNA Seq and RNA Seq data of zebrafish embryos post exposure to TBBPA and TBBPA BHEE | TBBPA H 1 | replicate:biological replicate 1|strain:AB|isolate:not applicable|breed:wild type|cultivar:not applicable|ecotype:not applicable|age:120 hpf|dev stage:larvae|sex:not applicable|tissue:whole body 7|BioSampleModel:Model organism or animal | miRNA Seq of zebrafish larvae | AT20221116 | AT20221116 | miRNA Seq of zebrafish larvae | miRNA-Seq | TRANSCRIPTOMIC | size fractionation | SINGLE | BGISEQ | BGISEQ-500 | SRP402080 | loader:fastq load.py | TBBPA_H_1.fq.gz | fastq | 538481195.0 | 23517366.0 | TBBPA H 1.fq.gz | 0:22.90 | A:117132485;C:106262580;G:143962997;T:171122739;N:394 | 22 | 117132485 | 106262580 | 143962997 | 171122739 | 394 | SRX17856930 | SRS15377987 | SRA1518395 | Jiangsu University|School of Environment and Safety Engineering | Jiangsu University | 1 | 0.83673 | 0.10787 | 0.91238 | 0.53365 | 21 | B | usable mapping rate | bgi | bgi | unknown | size_fractionation | unknown | bulk | unknown | unknown | China | 2022-10-12 | Larval | Larval | Trunk | Surface Structure | |||||||||||||||||||||||||||
| 71652 | 71652 | SRR21869771 | SRX17856929 | SRS15377986 | SRP402080 | PRJNA889683 | miRNA mRNA sequencing of zebrafish embryos | PRJNA889683 | Other | miRNA Seq and RNA Seq data of zebrafish embryos post exposure to TBBPA and TBBPA BHEE | TBBPA L 3 | replicate:biological replicate 3|strain:AB|isolate:not applicable|breed:wild type|cultivar:not applicable|ecotype:not applicable|age:120 hpf|dev stage:larvae|sex:not applicable|tissue:whole body 6|BioSampleModel:Model organism or animal | miRNA Seq of zebrafish larvae | AT20221115 | AT20221115 | miRNA Seq of zebrafish larvae | miRNA-Seq | TRANSCRIPTOMIC | size fractionation | SINGLE | BGISEQ | BGISEQ-500 | SRP402080 | loader:fastq load.py | TBBPA_L_3.fq.gz | fastq | 536529124.0 | 23817957.0 | TBBPA L 3.fq.gz | 0:22.53 | A:115664153;C:104457844;G:136444705;T:179962303;N:119 | 22 | 115664153 | 104457844 | 136444705 | 179962303 | 119 | SRX17856929 | SRS15377986 | SRA1518395 | Jiangsu University|School of Environment and Safety Engineering | Jiangsu University | 1 | 0.86178 | 0.09041 | 0.93624 | 0.4992 | 22 | B | usable mapping rate | bgi | bgi | unknown | size_fractionation | unknown | bulk | unknown | unknown | China | 2022-10-12 | Larval | Larval | Trunk | Surface Structure | |||||||||||||||||||||||||||
| 71654 | 71654 | SRR21869773 | SRX17856927 | SRS15377985 | SRP402080 | PRJNA889683 | miRNA mRNA sequencing of zebrafish embryos | PRJNA889683 | Other | miRNA Seq and RNA Seq data of zebrafish embryos post exposure to TBBPA and TBBPA BHEE | TBBPA L 2 | replicate:biological replicate 2|strain:AB|isolate:not applicable|breed:wild type|cultivar:not applicable|ecotype:not applicable|age:120 hpf|dev stage:larvae|sex:not applicable|tissue:whole body 5|BioSampleModel:Model organism or animal | miRNA Seq of zebrafish larvae | AT20221114 | AT20221114 | miRNA Seq of zebrafish larvae | miRNA-Seq | TRANSCRIPTOMIC | size fractionation | SINGLE | BGISEQ | BGISEQ-500 | SRP402080 | loader:fastq load.py | TBBPA_L_2.fq.gz | fastq | 525712427.0 | 23458446.0 | TBBPA L 2.fq.gz | 0:22.41 | A:115172158;C:103930973;G:133832634;T:172776555;N:107 | 22 | 115172158 | 103930973 | 133832634 | 172776555 | 107 | SRX17856927 | SRS15377985 | SRA1518395 | Jiangsu University|School of Environment and Safety Engineering | Jiangsu University | 1 | 0.87223 | 0.08526 | 0.93845 | 0.54116 | 22 | B | usable mapping rate | bgi | bgi | unknown | size_fractionation | unknown | bulk | unknown | unknown | China | 2022-10-12 | Larval | Larval | Trunk | Surface Structure | |||||||||||||||||||||||||||
| 71655 | 71655 | SRR21869774 | SRX17856926 | SRS15377984 | SRP402080 | PRJNA889683 | miRNA mRNA sequencing of zebrafish embryos | PRJNA889683 | Other | miRNA Seq and RNA Seq data of zebrafish embryos post exposure to TBBPA and TBBPA BHEE | TBBPA L 1 | replicate:biological replicate 1|strain:AB|isolate:not applicable|breed:wild type|cultivar:not applicable|ecotype:not applicable|age:120 hpf|dev stage:larvae|sex:not applicable|tissue:whole body 4|BioSampleModel:Model organism or animal | miRNA Seq of zebrafish larvae | AT20221113 | AT20221113 | miRNA Seq of zebrafish larvae | miRNA-Seq | TRANSCRIPTOMIC | size fractionation | SINGLE | BGISEQ | BGISEQ-500 | SRP402080 | loader:fastq load.py | TBBPA_L_1.fq.gz | fastq | 527804519.0 | 23370082.0 | TBBPA L 1.fq.gz | 0:22.58 | A:114266025;C:102477479;G:134403120;T:176657729;N:166 | 22 | 114266025 | 102477479 | 134403120 | 176657729 | 166 | SRX17856926 | SRS15377984 | SRA1518395 | Jiangsu University|School of Environment and Safety Engineering | Jiangsu University | 1 | 0.89339 | 0.09635 | 0.92608 | 0.48415 | 22 | B | usable mapping rate | bgi | bgi | unknown | size_fractionation | unknown | bulk | unknown | unknown | China | 2022-10-12 | Larval | Larval | Trunk | Surface Structure | |||||||||||||||||||||||||||
| 71656 | 71656 | SRR21869775 | SRX17856925 | SRS15377983 | SRP402080 | PRJNA889683 | miRNA mRNA sequencing of zebrafish embryos | PRJNA889683 | Other | miRNA Seq and RNA Seq data of zebrafish embryos post exposure to TBBPA and TBBPA BHEE | Control 3 | replicate:biological replicate 3|strain:AB|isolate:not applicable|breed:wild type|cultivar:not applicable|ecotype:not applicable|age:120 hpf|dev stage:larvae|sex:not applicable|tissue:whole body 3|BioSampleModel:Model organism or animal | miRNA Seq of zebrafish larvae | AT20221112 | AT20221112 | miRNA Seq of zebrafish larvae | miRNA-Seq | TRANSCRIPTOMIC | size fractionation | SINGLE | BGISEQ | BGISEQ-500 | SRP402080 | loader:fastq load.py | Control_3.fq.gz | fastq | 535579212.0 | 23899710.0 | Control 3.fq.gz | 0:22.41 | A:117125157;C:106586085;G:133001456;T:178866289;N:225 | 22 | 117125157 | 106586085 | 133001456 | 178866289 | 225 | SRX17856925 | SRS15377983 | SRA1518395 | Jiangsu University|School of Environment and Safety Engineering | Jiangsu University | 1 | 0.89094 | 0.06851 | 0.94807 | 0.54835 | 23 | B | usable mapping rate | bgi | bgi | unknown | size_fractionation | unknown | bulk | unknown | unknown | China | 2022-10-12 | Larval | Larval | Trunk | Surface Structure | |||||||||||||||||||||||||||
| 71657 | 71657 | SRR21869776 | SRX17856924 | SRS15377977 | SRP402080 | PRJNA889683 | miRNA mRNA sequencing of zebrafish embryos | PRJNA889683 | Other | miRNA Seq and RNA Seq data of zebrafish embryos post exposure to TBBPA and TBBPA BHEE | Control 2 | replicate:biological replicate 2|strain:AB|isolate:not applicable|breed:wild type|cultivar:not applicable|ecotype:not applicable|age:120 hpf|dev stage:larvae|sex:not applicable|tissue:whole body 2|BioSampleModel:Model organism or animal | miRNA Seq of zebrafish larvae | AT20221111 | AT20221111 | miRNA Seq of zebrafish larvae | miRNA-Seq | TRANSCRIPTOMIC | size fractionation | SINGLE | BGISEQ | BGISEQ-500 | SRP402080 | loader:fastq load.py | Control_2.fq.gz | fastq | 528466892.0 | 23430674.0 | Control 2.fq.gz | 0:22.55 | A:116361274;C:103960709;G:132758802;T:175385846;N:261 | 22 | 116361274 | 103960709 | 132758802 | 175385846 | 261 | SRX17856924 | SRS15377977 | SRA1518395 | Jiangsu University|School of Environment and Safety Engineering | Jiangsu University | 1 | 0.89063 | 0.07453 | 0.94255 | 0.54503 | 21 | B | usable mapping rate | bgi | bgi | unknown | size_fractionation | unknown | bulk | unknown | unknown | China | 2022-10-12 | Larval | Larval | Trunk | Surface Structure | |||||||||||||||||||||||||||
| 71658 | 71658 | SRR21869777 | SRX17856923 | SRS15377976 | SRP402080 | PRJNA889683 | miRNA mRNA sequencing of zebrafish embryos | PRJNA889683 | Other | miRNA Seq and RNA Seq data of zebrafish embryos post exposure to TBBPA and TBBPA BHEE | Control 1 | replicate:biological replicate 1|strain:AB|isolate:not applicable|breed:wild type|cultivar:not applicable|ecotype:not applicable|age:120 hpf|dev stage:larvae|sex:not applicable|tissue:whole body 1|BioSampleModel:Model organism or animal | miRNA Seq of zebrafish larvae | AT20221110 | AT20221110 | miRNA Seq of zebrafish larvae | miRNA-Seq | TRANSCRIPTOMIC | size fractionation | SINGLE | BGISEQ | BGISEQ-500 | SRP402080 | loader:fastq load.py | Control_1.fq.gz | fastq | 517484481.0 | 23046792.0 | Control 1.fq.gz | 0:22.45 | A:114187486;C:101456491;G:129311971;T:172528320;N:213 | 22 | 114187486 | 101456491 | 129311971 | 172528320 | 213 | SRX17856923 | SRS15377976 | SRA1518395 | Jiangsu University|School of Environment and Safety Engineering | Jiangsu University | 1 | 0.89811 | 0.07533 | 0.93198 | 0.55322 | 22 | B | usable mapping rate | bgi | bgi | unknown | size_fractionation | unknown | bulk | unknown | unknown | China | 2022-10-12 | Larval | Larval | Trunk | 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");;