RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

run_metadata

9 rows where experiment.library_selection = "PCR", experiment.library_strategy = "RNA-Seq" and tissue_curation = "Multi-tissue"

✎ View and edit SQL

This data as json, CSV (advanced)

tissue_curation_coarse 1

tissue_curation 1

  • Multi-tissue · 9 ✖

technology 1

experiment.platform 1

experiment.library_strategy 1

  • RNA-Seq · 9 ✖

experiment.library_source 1

experiment.library_selection 1

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
64970 64970 SRR14999363 SRX11311655 SRS9340853 SRP324442 PRJNA738523 Identification of chromatin states during zebrafish gastrulation using CUT&RUN and CUT&Tag GSE178343 Other Here we describe successful implementation of CUT&RUN for profiling protein DNA interactions in zebrafish embryos. We apply modified a CUT&RUN method to generate high resolution maps of enrichment for H3K4me3 H3K27me3 H3K9me3 and RNA polymerase II during zebrafish gastrulation. Using this data we identify a conserved subset of developmental genes that are enriched in both H3K4me3 and H3K27me3 during gastrulation and we demonstrate the increased effectiveness of CUT&RUN for detecting protein enrichment at repetitive sequences with reduced mappability. Our work demonstrates the power of combining CUT&RUN with the strengths of the zebrafish system to better understand the changing embryonic chromatin landscape and its roles in shaping development. Overall design: CUT&RUN in 6hpf zebrafish embryos for H3K27me3 H3K4me3 H3K9me3 and pol II. Experiments performed in duplicate with an IgG control.       L 1 L 1   strain:not collected|isolate:Similar in size|breed:AB wild type|ecotype:Illumina sequencing|age:4 months|dev stage:adult|sex:not collected|tissue:Liver and brain|biomaterial provider:CZRC|replicate:replicate =L 1|BioSampleModel:Model organism or animal                 L 1 FRAS210007515 1r FRAS210007515 1r 0.8g/L;h=96h;zebrafish     RNA-Seq TRANSCRIPTOMIC PCR PAIRED ILLUMINA Illumina NovaSeq 6000   SRP324442     L_96h_1_1.fq.gz L_96h_1_2.fq.gz fastq fastq 6019278600.0 20064262.0 L 96h 1 1.fq.gz 0:150 1:150 A:1581092490;C:1430552191;G:1435208634;T:1572284027;N:141258 150 150     1581092490 1430552191 1435208634 1572284027 141258 SRX11311655 SRS9340853 SRA1252645 Shandong Normal University|School of geography and environment Genetics, University of Goergia 2 0.94261 0.9417 0.02923 0.02882 0.7051 0.70725 0.48809 0.49074 150 150 B B biological fallback assumption illumina novaseq_era unknown random_priming unknown bulk unknown unknown   United States 2021-06-30 Adult Adult Multi-tissue Multi-system
64971 64971 SRR14999364 SRX11311654 SRS9340852 SRP324442 PRJNA738523 Identification of chromatin states during zebrafish gastrulation using CUT&RUN and CUT&Tag GSE178343 Other Here we describe successful implementation of CUT&RUN for profiling protein DNA interactions in zebrafish embryos. We apply modified a CUT&RUN method to generate high resolution maps of enrichment for H3K4me3 H3K27me3 H3K9me3 and RNA polymerase II during zebrafish gastrulation. Using this data we identify a conserved subset of developmental genes that are enriched in both H3K4me3 and H3K27me3 during gastrulation and we demonstrate the increased effectiveness of CUT&RUN for detecting protein enrichment at repetitive sequences with reduced mappability. Our work demonstrates the power of combining CUT&RUN with the strengths of the zebrafish system to better understand the changing embryonic chromatin landscape and its roles in shaping development. Overall design: CUT&RUN in 6hpf zebrafish embryos for H3K27me3 H3K4me3 H3K9me3 and pol II. Experiments performed in duplicate with an IgG control.       C 3 C 3   strain:not collected|isolate:Similar in size|breed:AB wild type|ecotype:Illumina sequencing|age:4 months|dev stage:adult|sex:not collected|tissue:Liver and brain|biomaterial provider:CZRC|replicate:replicate =C 3|BioSampleModel:Model organism or animal                 C 3 FRAS210007514 3r FRAS210007514 3r 0g/L;h=96h;zebrafish     RNA-Seq TRANSCRIPTOMIC PCR PAIRED ILLUMINA Illumina NovaSeq 6000   SRP324442     C_96h_3_1.fq.gz C_96h_3_2.fq.gz fastq fastq 6857670600.0 22858902.0 C 96h 3 1.fq.gz 0:150 1:150 A:1841430105;C:1590688013;G:1597543269;T:1827853044;N:156169 150 150     1841430105 1590688013 1597543269 1827853044 156169 SRX11311654 SRS9340852 SRA1252645 Shandong Normal University|School of geography and environment Genetics, University of Goergia 2 0.93924 0.93826 0.0592 0.05873 0.65673 0.65766 0.49758 0.50371 150 150 B B biological fallback assumption illumina novaseq_era unknown random_priming unknown bulk unknown unknown   United States 2021-06-30 Adult Adult Multi-tissue Multi-system
64972 64972 SRR14999365 SRX11311653 SRS9340851 SRP324442 PRJNA738523 Identification of chromatin states during zebrafish gastrulation using CUT&RUN and CUT&Tag GSE178343 Other Here we describe successful implementation of CUT&RUN for profiling protein DNA interactions in zebrafish embryos. We apply modified a CUT&RUN method to generate high resolution maps of enrichment for H3K4me3 H3K27me3 H3K9me3 and RNA polymerase II during zebrafish gastrulation. Using this data we identify a conserved subset of developmental genes that are enriched in both H3K4me3 and H3K27me3 during gastrulation and we demonstrate the increased effectiveness of CUT&RUN for detecting protein enrichment at repetitive sequences with reduced mappability. Our work demonstrates the power of combining CUT&RUN with the strengths of the zebrafish system to better understand the changing embryonic chromatin landscape and its roles in shaping development. Overall design: CUT&RUN in 6hpf zebrafish embryos for H3K27me3 H3K4me3 H3K9me3 and pol II. Experiments performed in duplicate with an IgG control.       C 2 C 2   strain:not collected|isolate:Similar in size|breed:AB wild type|ecotype:Illumina sequencing|age:4 months|dev stage:adult|sex:not collected|tissue:Liver and brain|biomaterial provider:CZRC|replicate:replicate =C 2|BioSampleModel:Model organism or animal                 C 2 FRAS210007514 2r FRAS210007514 2r 0g/L;h=96h;zebrafish     RNA-Seq TRANSCRIPTOMIC PCR PAIRED ILLUMINA Illumina NovaSeq 6000   SRP324442     C_96h_2_1.fq.gz C_96h_2_2.fq.gz fastq fastq 6348703200.0 21162344.0 C 96h 2 1.fq.gz 0:150 1:150 A:1700541402;C:1478742180;G:1481199683;T:1688070707;N:149228 150 150     1700541402 1478742180 1481199683 1688070707 149228 SRX11311653 SRS9340851 SRA1252645 Shandong Normal University|School of geography and environment Genetics, University of Goergia 2 0.94135 0.94114 0.05775 0.0572 0.66101 0.66265 0.50778 0.50788 150 150 B B biological fallback assumption illumina novaseq_era unknown random_priming unknown bulk unknown unknown   United States 2021-06-30 Adult Adult Multi-tissue Multi-system
64973 64973 SRR14999366 SRX11311652 SRS9340850 SRP324442 PRJNA738523 Identification of chromatin states during zebrafish gastrulation using CUT&RUN and CUT&Tag GSE178343 Other Here we describe successful implementation of CUT&RUN for profiling protein DNA interactions in zebrafish embryos. We apply modified a CUT&RUN method to generate high resolution maps of enrichment for H3K4me3 H3K27me3 H3K9me3 and RNA polymerase II during zebrafish gastrulation. Using this data we identify a conserved subset of developmental genes that are enriched in both H3K4me3 and H3K27me3 during gastrulation and we demonstrate the increased effectiveness of CUT&RUN for detecting protein enrichment at repetitive sequences with reduced mappability. Our work demonstrates the power of combining CUT&RUN with the strengths of the zebrafish system to better understand the changing embryonic chromatin landscape and its roles in shaping development. Overall design: CUT&RUN in 6hpf zebrafish embryos for H3K27me3 H3K4me3 H3K9me3 and pol II. Experiments performed in duplicate with an IgG control.       C 1 C 1   strain:not collected|isolate:Similar in size|breed:AB wild type|cultivar:not collected|ecotype:Illumina sequencing|age:4 months|dev stage:adult|sex:not collected|tissue:Liver and brain|biomaterial provider:CZRC|replicate:replicate =C 1|BioSampleModel:Model organism or animal                 C 1 FRAS210007514 1r FRAS210007514 1r 0g/L;h=96h;zebrafish     RNA-Seq TRANSCRIPTOMIC PCR PAIRED ILLUMINA Illumina NovaSeq 6000   SRP324442     C_96h_1_1.fq.gz C_96h_1_2.fq.gz fastq fastq 6463471200.0 21544904.0 C 96h 1 1.fq.gz 0:150 1:150 A:1733784762;C:1501594175;G:1506005187;T:1721935805;N:151271 150 150     1733784762 1501594175 1506005187 1721935805 151271 SRX11311652 SRS9340850 SRA1252645 Shandong Normal University|School of geography and environment Genetics, University of Goergia 2 0.93808 0.93829 0.05961 0.05918 0.65884 0.65873 0.50462 0.50091 150 150 B B biological fallback assumption illumina novaseq_era unknown random_priming unknown bulk unknown unknown   United States 2021-06-30 Adult Adult Multi-tissue Multi-system
64974 64974 SRR14999367 SRX11311651 SRS9340849 SRP324442 PRJNA738523 Identification of chromatin states during zebrafish gastrulation using CUT&RUN and CUT&Tag GSE178343 Other Here we describe successful implementation of CUT&RUN for profiling protein DNA interactions in zebrafish embryos. We apply modified a CUT&RUN method to generate high resolution maps of enrichment for H3K4me3 H3K27me3 H3K9me3 and RNA polymerase II during zebrafish gastrulation. Using this data we identify a conserved subset of developmental genes that are enriched in both H3K4me3 and H3K27me3 during gastrulation and we demonstrate the increased effectiveness of CUT&RUN for detecting protein enrichment at repetitive sequences with reduced mappability. Our work demonstrates the power of combining CUT&RUN with the strengths of the zebrafish system to better understand the changing embryonic chromatin landscape and its roles in shaping development. Overall design: CUT&RUN in 6hpf zebrafish embryos for H3K27me3 H3K4me3 H3K9me3 and pol II. Experiments performed in duplicate with an IgG control.       H 3 H 3   strain:not collected|isolate:Similar in size|breed:AB wild type|ecotype:Illumina sequencing|age:4 months|dev stage:adult|sex:not collected|tissue:Liver and brain|biomaterial provider:CZRC|replicate:replicate =H 3|BioSampleModel:Model organism or animal                 H 3 FRAS210007516 3r FRAS210007516 3r 2.0g/L;h=96h;zebrafish     RNA-Seq TRANSCRIPTOMIC PCR PAIRED ILLUMINA Illumina NovaSeq 6000   SRP324442     H_96h_3_1.fq.gz H_96h_3_2.fq.gz fastq fastq 5638058700.0 18793529.0 H 96h 3 1.fq.gz 0:150 1:150 A:1495034040;C:1330177281;G:1330682910;T:1482034263;N:130206 150 150     1495034040 1330177281 1330682910 1482034263 130206 SRX11311651 SRS9340849 SRA1252645 Shandong Normal University|School of geography and environment Genetics, University of Goergia 2 0.93535 0.93491 0.02553 0.02529 0.72456 0.72474 0.50213 0.49962 150 150 B B biological fallback assumption illumina novaseq_era unknown random_priming unknown bulk unknown unknown   United States 2021-06-30 Adult Adult Multi-tissue Multi-system
64975 64975 SRR14999368 SRX11311650 SRS9340848 SRP324442 PRJNA738523 Identification of chromatin states during zebrafish gastrulation using CUT&RUN and CUT&Tag GSE178343 Other Here we describe successful implementation of CUT&RUN for profiling protein DNA interactions in zebrafish embryos. We apply modified a CUT&RUN method to generate high resolution maps of enrichment for H3K4me3 H3K27me3 H3K9me3 and RNA polymerase II during zebrafish gastrulation. Using this data we identify a conserved subset of developmental genes that are enriched in both H3K4me3 and H3K27me3 during gastrulation and we demonstrate the increased effectiveness of CUT&RUN for detecting protein enrichment at repetitive sequences with reduced mappability. Our work demonstrates the power of combining CUT&RUN with the strengths of the zebrafish system to better understand the changing embryonic chromatin landscape and its roles in shaping development. Overall design: CUT&RUN in 6hpf zebrafish embryos for H3K27me3 H3K4me3 H3K9me3 and pol II. Experiments performed in duplicate with an IgG control.       H 2 H 2   strain:not collected|isolate:Similar in size|breed:AB wild type|ecotype:Illumina sequencing|age:4 months|dev stage:adult|sex:not collected|tissue:Liver and brain|biomaterial provider:CZRC|replicate:replicate =H 2|BioSampleModel:Model organism or animal                 H 2 FRAS210007516 2r FRAS210007516 2r 2.0g/L;h=96h;zebrafish     RNA-Seq TRANSCRIPTOMIC PCR PAIRED ILLUMINA Illumina NovaSeq 6000   SRP324442     H_96h_2_1.fq.gz H_96h_2_2.fq.gz fastq fastq 6161230800.0 20537436.0 H 96h 2 1.fq.gz 0:150 1:150 A:1637006263;C:1449880253;G:1451565756;T:1622634286;N:144242 150 150     1637006263 1449880253 1451565756 1622634286 144242 SRX11311650 SRS9340848 SRA1252645 Shandong Normal University|School of geography and environment Genetics, University of Goergia 2 0.93477 0.93452 0.02553 0.02539 0.72395 0.72494 0.49506 0.49921 150 150 B B biological fallback assumption illumina novaseq_era unknown random_priming unknown bulk unknown unknown   United States 2021-06-30 Adult Adult Multi-tissue Multi-system
64976 64976 SRR14999369 SRX11311649 SRS9340847 SRP324442 PRJNA738523 Identification of chromatin states during zebrafish gastrulation using CUT&RUN and CUT&Tag GSE178343 Other Here we describe successful implementation of CUT&RUN for profiling protein DNA interactions in zebrafish embryos. We apply modified a CUT&RUN method to generate high resolution maps of enrichment for H3K4me3 H3K27me3 H3K9me3 and RNA polymerase II during zebrafish gastrulation. Using this data we identify a conserved subset of developmental genes that are enriched in both H3K4me3 and H3K27me3 during gastrulation and we demonstrate the increased effectiveness of CUT&RUN for detecting protein enrichment at repetitive sequences with reduced mappability. Our work demonstrates the power of combining CUT&RUN with the strengths of the zebrafish system to better understand the changing embryonic chromatin landscape and its roles in shaping development. Overall design: CUT&RUN in 6hpf zebrafish embryos for H3K27me3 H3K4me3 H3K9me3 and pol II. Experiments performed in duplicate with an IgG control.       H 1 H 1   strain:not collected|isolate:Similar in size|breed:AB wild type|ecotype:Illumina sequencing|age:4 months|dev stage:adult|sex:not collected|tissue:Liver and brain|biomaterial provider:CZRC|replicate:replicate=H 1|BioSampleModel:Model organism or animal                 H 1 FRAS210007516 1r FRAS210007516 1r 2.0g/L;h=96h;zebrafish     RNA-Seq TRANSCRIPTOMIC PCR PAIRED ILLUMINA Illumina NovaSeq 6000   SRP324442     H_96h_1_1.fq.gz H_96h_1_2.fq.gz fastq fastq 6624273900.0 22080913.0 H 96h 1 1.fq.gz 0:150 1:150 A:1755735186;C:1561147696;G:1566612960;T:1740622508;N:155550 150 150     1755735186 1561147696 1566612960 1740622508 155550 SRX11311649 SRS9340847 SRA1252645 Shandong Normal University|School of geography and environment Genetics, University of Goergia 2 0.93425 0.93322 0.0254 0.0252 0.72606 0.72669 0.50622 0.50832 150 150 B B biological fallback assumption illumina novaseq_era unknown random_priming unknown bulk unknown unknown   United States 2021-06-30 Adult Adult Multi-tissue Multi-system
64977 64977 SRR14999370 SRX11311648 SRS9340845 SRP324442 PRJNA738523 Identification of chromatin states during zebrafish gastrulation using CUT&RUN and CUT&Tag GSE178343 Other Here we describe successful implementation of CUT&RUN for profiling protein DNA interactions in zebrafish embryos. We apply modified a CUT&RUN method to generate high resolution maps of enrichment for H3K4me3 H3K27me3 H3K9me3 and RNA polymerase II during zebrafish gastrulation. Using this data we identify a conserved subset of developmental genes that are enriched in both H3K4me3 and H3K27me3 during gastrulation and we demonstrate the increased effectiveness of CUT&RUN for detecting protein enrichment at repetitive sequences with reduced mappability. Our work demonstrates the power of combining CUT&RUN with the strengths of the zebrafish system to better understand the changing embryonic chromatin landscape and its roles in shaping development. Overall design: CUT&RUN in 6hpf zebrafish embryos for H3K27me3 H3K4me3 H3K9me3 and pol II. Experiments performed in duplicate with an IgG control.       L 3 L 3   strain:not collected|isolate:Similar in size|breed:AB wild type|ecotype:Illumina sequencing|age:4 months|dev stage:adult|sex:not collected|tissue:Liver and brain|biomaterial provider:CZRC|replicate:replicate =L 3|BioSampleModel:Model organism or animal                 L 3 FRAS210007515 3r FRAS210007515 3r 0.8g/L;h=96h;zebrafish     RNA-Seq TRANSCRIPTOMIC PCR PAIRED ILLUMINA Illumina NovaSeq 6000   SRP324442     L_96h_3_1.fq.gz L_96h_3_2.fq.gz fastq fastq 6466250400.0 21554168.0 L 96h 3 1.fq.gz 0:150 1:150 A:1702486578;C:1534421173;G:1535282758;T:1693909718;N:150173 150 150     1702486578 1534421173 1535282758 1693909718 150173 SRX11311648 SRS9340845 SRA1252645 Shandong Normal University|School of geography and environment Genetics, University of Goergia 2 0.94324 0.94217 0.03039 0.02989 0.70278 0.70418 0.49161 0.49083 150 150 B B biological fallback assumption illumina novaseq_era unknown random_priming unknown bulk unknown unknown   United States 2021-06-30 Adult Adult Multi-tissue Multi-system
64978 64978 SRR14999371 SRX11311647 SRS9340846 SRP324442 PRJNA738523 Identification of chromatin states during zebrafish gastrulation using CUT&RUN and CUT&Tag GSE178343 Other Here we describe successful implementation of CUT&RUN for profiling protein DNA interactions in zebrafish embryos. We apply modified a CUT&RUN method to generate high resolution maps of enrichment for H3K4me3 H3K27me3 H3K9me3 and RNA polymerase II during zebrafish gastrulation. Using this data we identify a conserved subset of developmental genes that are enriched in both H3K4me3 and H3K27me3 during gastrulation and we demonstrate the increased effectiveness of CUT&RUN for detecting protein enrichment at repetitive sequences with reduced mappability. Our work demonstrates the power of combining CUT&RUN with the strengths of the zebrafish system to better understand the changing embryonic chromatin landscape and its roles in shaping development. Overall design: CUT&RUN in 6hpf zebrafish embryos for H3K27me3 H3K4me3 H3K9me3 and pol II. Experiments performed in duplicate with an IgG control.       L 2 L 2   strain:not collected|isolate:Similar in size|breed:AB wild type|ecotype:Illumina sequencing|age:4 months|dev stage:adult|sex:not collected|tissue:Liver and brain|biomaterial provider:CZRC|replicate:replicate =L 2|BioSampleModel:Model organism or animal                 L 2 FRAS210007515 2r FRAS210007515 2r 0.8g/L;h=96h;zebrafish     RNA-Seq TRANSCRIPTOMIC PCR PAIRED ILLUMINA Illumina NovaSeq 6000   SRP324442     L_96h_2_1.fq.gz L_96h_2_2.fq.gz fastq fastq 6804970800.0 22683236.0 L 96h 2 1.fq.gz 0:150 1:150 A:1788345091;C:1614590700;G:1621811406;T:1780069163;N:154440 150 150     1788345091 1614590700 1621811406 1780069163 154440 SRX11311647 SRS9340846 SRA1252645 Shandong Normal University|School of geography and environment Genetics, University of Goergia 2 0.94141 0.94045 0.03027 0.0302 0.70207 0.70234 0.48625 0.48905 150 150 B B biological fallback assumption illumina novaseq_era unknown random_priming unknown bulk unknown unknown   United States 2021-06-30 Adult Adult Multi-tissue Multi-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");;