RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

run_metadata

9 rows where experiment.library_selection = "RANDOM PCR", experiment.platform = "BGISEQ" and tissue_curation_coarse = "Reproductive System"

✎ View and edit SQL

This data as json, CSV (advanced)

tissue_curation_coarse 1

  • Reproductive System · 9 ✖

tissue_curation 1

technology 1

experiment.platform 1

  • BGISEQ · 9 ✖

experiment.library_strategy 1

experiment.library_source 1

experiment.library_selection 1

  • RANDOM PCR · 9 ✖

experiment.library_layout 1

devstage_curation_coarse 1

devstage_curation 1

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
58533 58533 SRR11355387 SRX7957249 SRS6343356 SRP253408 PRJNA613558 Transcriptomic assessments RNA sequencing in ovaries following treatments of gravid female zebrafish to an antibiotic mixture PRJNA613558 Other As the use of antimicrobials during pregnancy and the perinatal period may lead to adverse outcomes such as miscarriages and newborn disease the purpose of present study was to evaluate the influence of antibiotic exposure in offspring following treatments of gravid female zebrafish to an antibiotic mixture. For the F0 generation adult zebrafish AB strain at sexual maturity 150 dpf dpf were selected for experimentation 50% male and 50% pregnant female. Given a significant change occurred in eggs production and F1 survival at birth in present study combined with antibiotics bioaccumulated in ovary we suspect that antibiotic exposure might impact the ovary of F0 generation zebrafish and thus affect egg production and survival. Therefore ovaries of the F0 generation were evaluated for transcriptional effects in different antibiotics mixture exposure 0 1 and 100 ug/L using a HTS approach coupled with advanced bioinformatic tools.       C2 3 C2 3   strain:AB|isolate:C2|breed:not applicable|cultivar:not applicable|ecotype:not applicable|age:not applicable|dev stage:not applicable|sex:female|tissue:ovary|collection date:2019 11 01|geo loc name:China: Shenzhen Guangdong|replicate:biological replicate 3|BioSampleModel:Model organism or animal                 RNA seq of zebrafish C2 320200327 C2 320200327 RNA seq of zebrafish in different conditions     RNA-Seq TRANSCRIPTOMIC RANDOM PCR PAIRED BGISEQ BGISEQ-500   SRP253408     C2_3_1.fq.gz C2_3_2.fq.gz fastq fastq 6857650800.0 45717672.0 C2 3 1.fq.gz 0:150 1:150 A:1826466263;C:1599272942;G:1580689630;T:1851144875;N:77090 150 150     1826466263 1599272942 1580689630 1851144875 77090 SRX7957249 SRS6343356 SRA1056819 Southern University of Science and Technology|School of Environmental Science and Engineering Southern University of Science and Technology 1 0.93222   0.02854   0.75138   0.50759   150   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2020-03-20 Undetermined Adult Gonad Reproductive System
58534 58534 SRR11355388 SRX7957248 SRS6343355 SRP253408 PRJNA613558 Transcriptomic assessments RNA sequencing in ovaries following treatments of gravid female zebrafish to an antibiotic mixture PRJNA613558 Other As the use of antimicrobials during pregnancy and the perinatal period may lead to adverse outcomes such as miscarriages and newborn disease the purpose of present study was to evaluate the influence of antibiotic exposure in offspring following treatments of gravid female zebrafish to an antibiotic mixture. For the F0 generation adult zebrafish AB strain at sexual maturity 150 dpf dpf were selected for experimentation 50% male and 50% pregnant female. Given a significant change occurred in eggs production and F1 survival at birth in present study combined with antibiotics bioaccumulated in ovary we suspect that antibiotic exposure might impact the ovary of F0 generation zebrafish and thus affect egg production and survival. Therefore ovaries of the F0 generation were evaluated for transcriptional effects in different antibiotics mixture exposure 0 1 and 100 ug/L using a HTS approach coupled with advanced bioinformatic tools.       C2 2 C2 2   strain:AB|isolate:C2|breed:not applicable|cultivar:not applicable|ecotype:not applicable|age:not applicable|dev stage:not applicable|sex:female|tissue:ovary|collection date:2019 11 01|geo loc name:China: Shenzhen Guangdong|replicate:biological replicate 2|BioSampleModel:Model organism or animal                 RNA seq of zebrafish C2 220200326 C2 220200326 RNA seq of zebrafish in different conditions     RNA-Seq TRANSCRIPTOMIC RANDOM PCR PAIRED BGISEQ BGISEQ-500   SRP253408     C2_2_1.fq.gz C2_2_2.fq.gz fastq fastq 6859954800.0 45733032.0 C2 2 1.fq.gz 0:150 1:150 A:1836618967;C:1591135182;G:1572318102;T:1859806048;N:76501 150 150     1836618967 1591135182 1572318102 1859806048 76501 SRX7957248 SRS6343355 SRA1056819 Southern University of Science and Technology|School of Environmental Science and Engineering Southern University of Science and Technology 1 0.93237   0.03248   0.74663   0.5081   150   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2020-03-20 Undetermined Adult Gonad Reproductive System
58535 58535 SRR11355389 SRX7957247 SRS6343354 SRP253408 PRJNA613558 Transcriptomic assessments RNA sequencing in ovaries following treatments of gravid female zebrafish to an antibiotic mixture PRJNA613558 Other As the use of antimicrobials during pregnancy and the perinatal period may lead to adverse outcomes such as miscarriages and newborn disease the purpose of present study was to evaluate the influence of antibiotic exposure in offspring following treatments of gravid female zebrafish to an antibiotic mixture. For the F0 generation adult zebrafish AB strain at sexual maturity 150 dpf dpf were selected for experimentation 50% male and 50% pregnant female. Given a significant change occurred in eggs production and F1 survival at birth in present study combined with antibiotics bioaccumulated in ovary we suspect that antibiotic exposure might impact the ovary of F0 generation zebrafish and thus affect egg production and survival. Therefore ovaries of the F0 generation were evaluated for transcriptional effects in different antibiotics mixture exposure 0 1 and 100 ug/L using a HTS approach coupled with advanced bioinformatic tools.       C2 1 C2 1   strain:AB|isolate:C2|breed:not applicable|cultivar:not applicable|ecotype:not applicable|age:not applicable|dev stage:not applicable|sex:female|tissue:ovary|collection date:2019 11 01|geo loc name:China: Shenzhen Guangdong|replicate:biological replicate 1|BioSampleModel:Model organism or animal                 RNA seq of zebrafish C2 120200325 C2 120200325 RNA seq of zebrafish in different conditions     RNA-Seq TRANSCRIPTOMIC RANDOM PCR PAIRED BGISEQ BGISEQ-500   SRP253408     C2_1_1.fq.gz C2_1_2.fq.gz fastq fastq 6618974400.0 44126496.0 C2 1 1.fq.gz 0:150 1:150 A:1774116288;C:1533828286;G:1511526952;T:1799423408;N:79466 150 150     1774116288 1533828286 1511526952 1799423408 79466 SRX7957247 SRS6343354 SRA1056819 Southern University of Science and Technology|School of Environmental Science and Engineering Southern University of Science and Technology 1 0.9326   0.02973   0.75426   0.50678   150   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2020-03-20 Undetermined Adult Gonad Reproductive System
58536 58536 SRR11355390 SRX7957246 SRS6343353 SRP253408 PRJNA613558 Transcriptomic assessments RNA sequencing in ovaries following treatments of gravid female zebrafish to an antibiotic mixture PRJNA613558 Other As the use of antimicrobials during pregnancy and the perinatal period may lead to adverse outcomes such as miscarriages and newborn disease the purpose of present study was to evaluate the influence of antibiotic exposure in offspring following treatments of gravid female zebrafish to an antibiotic mixture. For the F0 generation adult zebrafish AB strain at sexual maturity 150 dpf dpf were selected for experimentation 50% male and 50% pregnant female. Given a significant change occurred in eggs production and F1 survival at birth in present study combined with antibiotics bioaccumulated in ovary we suspect that antibiotic exposure might impact the ovary of F0 generation zebrafish and thus affect egg production and survival. Therefore ovaries of the F0 generation were evaluated for transcriptional effects in different antibiotics mixture exposure 0 1 and 100 ug/L using a HTS approach coupled with advanced bioinformatic tools.       C1 3 C1 3   strain:AB|isolate:C1|breed:not applicable|cultivar:not applicable|ecotype:not applicable|age:not applicable|dev stage:not applicable|sex:female|tissue:ovary|collection date:2019 11 01|geo loc name:China: Shenzhen Guangdong|replicate:biological replicate 3|BioSampleModel:Model organism or animal                 RNA seq of zebrafish C1 320200324 C1 320200324 RNA seq of zebrafish in different conditions     RNA-Seq TRANSCRIPTOMIC RANDOM PCR PAIRED BGISEQ BGISEQ-500   SRP253408     C1_3_1.fq.gz C1_3_2.fq.gz fastq fastq 6837729600.0 45584864.0 C1 3 1.fq.gz 0:150 1:150 A:1831266308;C:1587032733;G:1565071069;T:1853950421;N:409069 150 150     1831266308 1587032733 1565071069 1853950421 409069 SRX7957246 SRS6343353 SRA1056819 Southern University of Science and Technology|School of Environmental Science and Engineering Southern University of Science and Technology 1 0.93541   0.03212   0.74681   0.50268   150   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2020-03-20 Undetermined Adult Gonad Reproductive System
58537 58537 SRR11355391 SRX7957245 SRS6343352 SRP253408 PRJNA613558 Transcriptomic assessments RNA sequencing in ovaries following treatments of gravid female zebrafish to an antibiotic mixture PRJNA613558 Other As the use of antimicrobials during pregnancy and the perinatal period may lead to adverse outcomes such as miscarriages and newborn disease the purpose of present study was to evaluate the influence of antibiotic exposure in offspring following treatments of gravid female zebrafish to an antibiotic mixture. For the F0 generation adult zebrafish AB strain at sexual maturity 150 dpf dpf were selected for experimentation 50% male and 50% pregnant female. Given a significant change occurred in eggs production and F1 survival at birth in present study combined with antibiotics bioaccumulated in ovary we suspect that antibiotic exposure might impact the ovary of F0 generation zebrafish and thus affect egg production and survival. Therefore ovaries of the F0 generation were evaluated for transcriptional effects in different antibiotics mixture exposure 0 1 and 100 ug/L using a HTS approach coupled with advanced bioinformatic tools.       C1 2 C1 2   strain:AB|isolate:C1|breed:not applicable|cultivar:not applicable|ecotype:not applicable|age:not applicable|dev stage:not applicable|sex:female|tissue:ovary|collection date:2019 11 01|geo loc name:China: Shenzhen Guangdong|replicate:biological replicate 2|BioSampleModel:Model organism or animal                 RNA seq of zebrafish C1 220200323 C1 220200323 RNA seq of zebrafish in different conditions     RNA-Seq TRANSCRIPTOMIC RANDOM PCR PAIRED BGISEQ BGISEQ-500   SRP253408     C1_2_2.fq.gz C1_2_1.fq.gz fastq fastq 6860328000.0 45735520.0 C1 2 1.fq.gz 0:150 1:150 A:1838176072;C:1591277709;G:1569605888;T:1861063734;N:204597 150 150     1838176072 1591277709 1569605888 1861063734 204597 SRX7957245 SRS6343352 SRA1056819 Southern University of Science and Technology|School of Environmental Science and Engineering Southern University of Science and Technology 1 0.93763   0.033   0.74617   0.50287   150   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2020-03-20 Undetermined Adult Gonad Reproductive System
58538 58538 SRR11355392 SRX7957244 SRS6343351 SRP253408 PRJNA613558 Transcriptomic assessments RNA sequencing in ovaries following treatments of gravid female zebrafish to an antibiotic mixture PRJNA613558 Other As the use of antimicrobials during pregnancy and the perinatal period may lead to adverse outcomes such as miscarriages and newborn disease the purpose of present study was to evaluate the influence of antibiotic exposure in offspring following treatments of gravid female zebrafish to an antibiotic mixture. For the F0 generation adult zebrafish AB strain at sexual maturity 150 dpf dpf were selected for experimentation 50% male and 50% pregnant female. Given a significant change occurred in eggs production and F1 survival at birth in present study combined with antibiotics bioaccumulated in ovary we suspect that antibiotic exposure might impact the ovary of F0 generation zebrafish and thus affect egg production and survival. Therefore ovaries of the F0 generation were evaluated for transcriptional effects in different antibiotics mixture exposure 0 1 and 100 ug/L using a HTS approach coupled with advanced bioinformatic tools.       C1 1 C1 1   strain:AB|isolate:C1|breed:not applicable|cultivar:not applicable|ecotype:not applicable|age:not applicable|dev stage:not applicable|sex:female|tissue:ovary|collection date:2019 11 01|geo loc name:China: Shenzhen Guangdong|replicate:biological replicate 1|BioSampleModel:Model organism or animal                 RNA seq of zebrafish C1 120200322 C1 120200322 RNA seq of zebrafish in different conditions     RNA-Seq TRANSCRIPTOMIC RANDOM PCR PAIRED BGISEQ BGISEQ-500   SRP253408     C1_1_1.fq.gz C1_1_2.fq.gz fastq fastq 6865547700.0 45770318.0 C1 1 1.fq.gz 0:150 1:150 A:1841774713;C:1591288582;G:1570400871;T:1861867728;N:215806 150 150     1841774713 1591288582 1570400871 1861867728 215806 SRX7957244 SRS6343351 SRA1056819 Southern University of Science and Technology|School of Environmental Science and Engineering Southern University of Science and Technology 1 0.93567   0.03152   0.74653   0.50239   150   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2020-03-20 Undetermined Adult Gonad Reproductive System
58539 58539 SRR11355393 SRX7957243 SRS6343350 SRP253408 PRJNA613558 Transcriptomic assessments RNA sequencing in ovaries following treatments of gravid female zebrafish to an antibiotic mixture PRJNA613558 Other As the use of antimicrobials during pregnancy and the perinatal period may lead to adverse outcomes such as miscarriages and newborn disease the purpose of present study was to evaluate the influence of antibiotic exposure in offspring following treatments of gravid female zebrafish to an antibiotic mixture. For the F0 generation adult zebrafish AB strain at sexual maturity 150 dpf dpf were selected for experimentation 50% male and 50% pregnant female. Given a significant change occurred in eggs production and F1 survival at birth in present study combined with antibiotics bioaccumulated in ovary we suspect that antibiotic exposure might impact the ovary of F0 generation zebrafish and thus affect egg production and survival. Therefore ovaries of the F0 generation were evaluated for transcriptional effects in different antibiotics mixture exposure 0 1 and 100 ug/L using a HTS approach coupled with advanced bioinformatic tools.       C0 3 C0 3   strain:AB|isolate:C0|breed:not applicable|cultivar:not applicable|ecotype:not applicable|age:not applicable|dev stage:not applicable|sex:female|tissue:ovary|collection date:2019 11 01|geo loc name:China: Shenzhen Guangdong|replicate:biological replicate 3|BioSampleModel:Model organism or animal                 RNA seq of zebrafish C0 320200321 C0 320200321 RNA seq of zebrafish in different conditions     RNA-Seq TRANSCRIPTOMIC RANDOM PCR PAIRED BGISEQ BGISEQ-500   SRP253408     C0_3_1.fq.gz C0_3_2.fq.gz fastq fastq 6824622600.0 45497484.0 C0 3 1.fq.gz 0:150 1:150 A:1833660953;C:1578510104;G:1558095174;T:1854128169;N:228200 150 150     1833660953 1578510104 1558095174 1854128169 228200 SRX7957243 SRS6343350 SRA1056819 Southern University of Science and Technology|School of Environmental Science and Engineering Southern University of Science and Technology 1 0.93758   0.0323   0.75024   0.50852   150   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2020-03-20 Undetermined Adult Gonad Reproductive System
58540 58540 SRR11355394 SRX7957242 SRS6343349 SRP253408 PRJNA613558 Transcriptomic assessments RNA sequencing in ovaries following treatments of gravid female zebrafish to an antibiotic mixture PRJNA613558 Other As the use of antimicrobials during pregnancy and the perinatal period may lead to adverse outcomes such as miscarriages and newborn disease the purpose of present study was to evaluate the influence of antibiotic exposure in offspring following treatments of gravid female zebrafish to an antibiotic mixture. For the F0 generation adult zebrafish AB strain at sexual maturity 150 dpf dpf were selected for experimentation 50% male and 50% pregnant female. Given a significant change occurred in eggs production and F1 survival at birth in present study combined with antibiotics bioaccumulated in ovary we suspect that antibiotic exposure might impact the ovary of F0 generation zebrafish and thus affect egg production and survival. Therefore ovaries of the F0 generation were evaluated for transcriptional effects in different antibiotics mixture exposure 0 1 and 100 ug/L using a HTS approach coupled with advanced bioinformatic tools.       C0 2 C0 2   strain:AB|isolate:C0|breed:not applicable|cultivar:not applicable|ecotype:not applicable|age:not applicable|dev stage:not applicable|sex:female|tissue:ovary|collection date:2019 11 01|geo loc name:China: Shenzhen Guangdong|replicate:biological replicate 2|BioSampleModel:Model organism or animal                 RNA seq of zebrafish C0 220200320 C0 220200320 RNA seq of zebrafish in different conditions     RNA-Seq TRANSCRIPTOMIC RANDOM PCR PAIRED BGISEQ BGISEQ-500   SRP253408     C0_2_2.fq.gz C0_2_1.fq.gz fastq fastq 6819326400.0 45462176.0 C0 2 1.fq.gz 0:150 1:150 A:1837661215;C:1571877614;G:1550458835;T:1859103408;N:225328 150 150     1837661215 1571877614 1550458835 1859103408 225328 SRX7957242 SRS6343349 SRA1056819 Southern University of Science and Technology|School of Environmental Science and Engineering Southern University of Science and Technology 1 0.93697   0.0339   0.74793   0.5035   150   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2020-03-20 Undetermined Adult Gonad Reproductive System
58541 58541 SRR11355395 SRX7957241 SRS6343348 SRP253408 PRJNA613558 Transcriptomic assessments RNA sequencing in ovaries following treatments of gravid female zebrafish to an antibiotic mixture PRJNA613558 Other As the use of antimicrobials during pregnancy and the perinatal period may lead to adverse outcomes such as miscarriages and newborn disease the purpose of present study was to evaluate the influence of antibiotic exposure in offspring following treatments of gravid female zebrafish to an antibiotic mixture. For the F0 generation adult zebrafish AB strain at sexual maturity 150 dpf dpf were selected for experimentation 50% male and 50% pregnant female. Given a significant change occurred in eggs production and F1 survival at birth in present study combined with antibiotics bioaccumulated in ovary we suspect that antibiotic exposure might impact the ovary of F0 generation zebrafish and thus affect egg production and survival. Therefore ovaries of the F0 generation were evaluated for transcriptional effects in different antibiotics mixture exposure 0 1 and 100 ug/L using a HTS approach coupled with advanced bioinformatic tools.       C0 1 C0 1   strain:AB|isolate:C0|breed:not applicable|cultivar:not applicable|ecotype:not applicable|age:not applicable|dev stage:not applicable|sex:female|tissue:ovary|collection date:2019 11 01|geo loc name:China: Shenzhen Guangdong|replicate:biological replicate 1|BioSampleModel:Model organism or animal                 RNA seq of zebrafish C0 120200319 C0 120200319 RNA seq of zebrafish in different conditions     RNA-Seq TRANSCRIPTOMIC RANDOM PCR PAIRED BGISEQ BGISEQ-500   SRP253408     C0_1_1.fq.gz C0_1_2.fq.gz fastq fastq 7030804800.0 46872032.0 C0 1 1.fq.gz 0:150 1:150 A:1891469955;C:1624531422;G:1603124564;T:1911444454;N:234405 150 150     1891469955 1624531422 1603124564 1911444454 234405 SRX7957241 SRS6343348 SRA1056819 Southern University of Science and Technology|School of Environmental Science and Engineering Southern University of Science and Technology 1 0.93519   0.0328   0.74602   0.48272   150   B   usable mapping rate bgi bgi unknown random_priming unknown bulk unknown unknown   China 2020-03-20 Undetermined Adult Gonad Reproductive System

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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