RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

run_metadata

16 rows where experiment.library_layout = "SINGLE", experiment.library_selection = "RANDOM PCR" and tissue_curation = "Embryo Imprecise"

✎ View and edit SQL

This data as json, CSV (advanced)

tissue_curation_coarse 1

tissue_curation 1

  • Embryo Imprecise · 16 ✖

technology 1

experiment.platform 1

experiment.library_strategy 1

experiment.library_source 1

experiment.library_selection 1

  • RANDOM PCR · 16 ✖

experiment.library_layout 1

  • SINGLE · 16 ✖

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
65871 65871 SRR15684056 SRX11980374 SRS9988552 SRP335145 PRJNA758770 Danio rerio Raw sequence reads PRJNA758770 Whole Genome Sequencing A polyfluorinated compound H PFMO2OSA induced transcriptome alters in early zebrafish embryo         PFVE80 1.R2   strain:AB|age:120h|sex:N1|tissue:embyo|treatment:PFVE 1.2|BioSampleModel:Model organism or animal                 RNA Seq of embryo SAMN21035685 SAMN21035685 Illumina NovaSeq 6000     RNA-Seq TRANSCRIPTOMIC RANDOM PCR SINGLE ILLUMINA Illumina NovaSeq 6000   SRP335145     PFVE80_1.R2.fastq.gz fastq 3296094440.0 21828440.0 PFVE80 1.R2.fastq.gz 0:0 1:151 A:915433386;C:730204213;G:755908505;T:894514826;N:33510 0 151     915433386 730204213 755908505 894514826 33510 SRX11980374 SRS9988552 SRA1287281 Chinese Academy of Sciences|Institute of Zoology Chinese Academy of Sciences 1 0.93185   0.1143   0.69244   0.47999   151   B   usable mapping rate illumina novaseq_era unknown random_priming unknown bulk unknown unknown   China 2021-09-01 Larval Larval Embryo Imprecise All anatomical structures
65872 65872 SRR15684057 SRX11980373 SRS9988551 SRP335145 PRJNA758770 Danio rerio Raw sequence reads PRJNA758770 Whole Genome Sequencing A polyfluorinated compound H PFMO2OSA induced transcriptome alters in early zebrafish embryo         PFVE80 1.R1   strain:AB|age:120h|sex:N1|tissue:embyo|treatment:PFVE 1.1|BioSampleModel:Model organism or animal                 RNA Seq of embryo SAMN21035684 SAMN21035684 Illumina NovaSeq 6000     RNA-Seq TRANSCRIPTOMIC RANDOM PCR SINGLE ILLUMINA Illumina NovaSeq 6000   SRP335145     PFVE80_1.R1.fastq.gz fastq 3296094440.0 21828440.0 PFVE80 1.R1.fastq.gz 0:151 1:0 A:912467078;C:735556764;G:752785505;T:895102572;N:182521 151 0     912467078 735556764 752785505 895102572 182521 SRX11980373 SRS9988551 SRA1287281 Chinese Academy of Sciences|Institute of Zoology Chinese Academy of Sciences 1 0.93451   0.11559   0.69063   0.48574   151   B   usable mapping rate illumina novaseq_era unknown random_priming unknown bulk unknown unknown   China 2021-09-01 Larval Larval Embryo Imprecise All anatomical structures
65873 65873 SRR15684058 SRX11980372 SRS9988550 SRP335145 PRJNA758770 Danio rerio Raw sequence reads PRJNA758770 Whole Genome Sequencing A polyfluorinated compound H PFMO2OSA induced transcriptome alters in early zebrafish embryo         PFVE0 4.R2   strain:AB|age:120h|sex:N1|tissue:embyo|treatment:H20 4.2|BioSampleModel:Model organism or animal                 RNA Seq of embryo SAMN21035683 SAMN21035683 Illumina NovaSeq 6000     RNA-Seq TRANSCRIPTOMIC RANDOM PCR SINGLE ILLUMINA Illumina NovaSeq 6000   SRP335145     PFVE0_4.R2.fastq.gz fastq 3759908003.0 24900053.0 PFVE0 4.R2.fastq.gz 0:0 1:151 A:1000945494;C:875720109;G:898795328;T:984408950;N:38122 0 151     1000945494 875720109 898795328 984408950 38122 SRX11980372 SRS9988550 SRA1287281 Chinese Academy of Sciences|Institute of Zoology Chinese Academy of Sciences 1 0.9408   0.0837   0.67584   0.46787   151   B   usable mapping rate illumina novaseq_era unknown random_priming unknown bulk unknown unknown   China 2021-09-01 Larval Larval Embryo Imprecise All anatomical structures
65874 65874 SRR15684059 SRX11980371 SRS9988549 SRP335145 PRJNA758770 Danio rerio Raw sequence reads PRJNA758770 Whole Genome Sequencing A polyfluorinated compound H PFMO2OSA induced transcriptome alters in early zebrafish embryo         PFVE0 4.R1   strain:AB|age:120h|sex:N1|tissue:embyo|treatment:H20 4.1|BioSampleModel:Model organism or animal                 RNA Seq of embryo SAMN21035682 SAMN21035682 Illumina NovaSeq 6000     RNA-Seq TRANSCRIPTOMIC RANDOM PCR SINGLE ILLUMINA Illumina NovaSeq 6000   SRP335145     PFVE0_4.R1.fastq.gz fastq 3759908003.0 24900053.0 PFVE0 4.R1.fastq.gz 0:151 1:0 A:998344987;C:880686863;G:894577099;T:986091832;N:207222 151 0     998344987 880686863 894577099 986091832 207222 SRX11980371 SRS9988549 SRA1287281 Chinese Academy of Sciences|Institute of Zoology Chinese Academy of Sciences 1 0.94175   0.08443   0.67334   0.46255   151   B   usable mapping rate illumina novaseq_era unknown random_priming unknown bulk unknown unknown   China 2021-09-01 Larval Larval Embryo Imprecise All anatomical structures
65875 65875 SRR15684060 SRX11980370 SRS9988548 SRP335145 PRJNA758770 Danio rerio Raw sequence reads PRJNA758770 Whole Genome Sequencing A polyfluorinated compound H PFMO2OSA induced transcriptome alters in early zebrafish embryo         PFVE0 3.R2   strain:AB|age:120h|sex:N1|tissue:embyo|treatment:H20 3.2|BioSampleModel:Model organism or animal                 RNA Seq of embryo SAMN21035681 SAMN21035681 Illumina NovaSeq 6000     RNA-Seq TRANSCRIPTOMIC RANDOM PCR SINGLE ILLUMINA Illumina NovaSeq 6000   SRP335145     PFVE0_3.R2.fastq.gz fastq 4110903728.0 27224528.0 PFVE0 3.R2.fastq.gz 0:0 1:151 A:1107531796;C:945271780;G:971476953;T:1086581356;N:41843 0 151     1107531796 945271780 971476953 1086581356 41843 SRX11980370 SRS9988548 SRA1287281 Chinese Academy of Sciences|Institute of Zoology Chinese Academy of Sciences 1 0.94068   0.08433   0.67243   0.45982   151   B   usable mapping rate illumina novaseq_era unknown random_priming unknown bulk unknown unknown   China 2021-09-01 Larval Larval Embryo Imprecise All anatomical structures
65876 65876 SRR15684061 SRX11980369 SRS9988547 SRP335145 PRJNA758770 Danio rerio Raw sequence reads PRJNA758770 Whole Genome Sequencing A polyfluorinated compound H PFMO2OSA induced transcriptome alters in early zebrafish embryo         PFVE0 3.R1   strain:AB|age:120h|sex:N1|tissue:embyo|treatment:H2O 3.1|BioSampleModel:Model organism or animal                 RNA Seq of embryo SAMN21035680 SAMN21035680 Illumina NovaSeq 6000     RNA-Seq TRANSCRIPTOMIC RANDOM PCR SINGLE ILLUMINA Illumina NovaSeq 6000   SRP335145     PFVE0_3.R1.fastq.gz fastq 4110903728.0 27224528.0 PFVE0 3.R1.fastq.gz 0:151 1:0 A:1103234050;C:949977333;G:968068226;T:1089400056;N:224063 151 0     1103234050 949977333 968068226 1089400056 224063 SRX11980369 SRS9988547 SRA1287281 Chinese Academy of Sciences|Institute of Zoology Chinese Academy of Sciences 1 0.94257   0.08462   0.66969   0.46513   151   B   usable mapping rate illumina novaseq_era unknown random_priming unknown bulk unknown unknown   China 2021-09-01 Larval Larval Embryo Imprecise All anatomical structures
65877 65877 SRR15684062 SRX11980368 SRS9988546 SRP335145 PRJNA758770 Danio rerio Raw sequence reads PRJNA758770 Whole Genome Sequencing A polyfluorinated compound H PFMO2OSA induced transcriptome alters in early zebrafish embryo         PFVE0 2.R2   strain:AB|age:120h|sex:N1|tissue:embyo|treatment:H20 2.2|BioSampleModel:Model organism or animal                 RNA Seq of embryo SAMN21035679 SAMN21035679 Illumina NovaSeq 6000     RNA-Seq TRANSCRIPTOMIC RANDOM PCR SINGLE ILLUMINA Illumina NovaSeq 6000   SRP335145     PFVE0_2.R2.fastq.gz fastq 3303194158.0 21875458.0 PFVE0 2.R2.fastq.gz 0:0 1:151 A:882380354;C:765252922;G:789054306;T:866472679;N:33897 0 151     882380354 765252922 789054306 866472679 33897 SRX11980368 SRS9988546 SRA1287281 Chinese Academy of Sciences|Institute of Zoology Chinese Academy of Sciences 1 0.9451   0.07962   0.68034   0.46622   151   B   usable mapping rate illumina novaseq_era unknown random_priming unknown bulk unknown unknown   China 2021-09-01 Larval Larval Embryo Imprecise All anatomical structures
65878 65878 SRR15684063 SRX11980367 SRS9988545 SRP335145 PRJNA758770 Danio rerio Raw sequence reads PRJNA758770 Whole Genome Sequencing A polyfluorinated compound H PFMO2OSA induced transcriptome alters in early zebrafish embryo         PFVE0 2.R1   strain:AB|age:120h|sex:N1|tissue:embyo|treatment:H20 2.1|BioSampleModel:Model organism or animal                 RNA Seq of embryo SAMN21035678 SAMN21035678 Illumina NovaSeq 6000     RNA-Seq TRANSCRIPTOMIC RANDOM PCR SINGLE ILLUMINA Illumina NovaSeq 6000   SRP335145     PFVE0_2.R1.fastq.gz fastq 3303194158.0 21875458.0 PFVE0 2.R1.fastq.gz 0:151 1:0 A:880833177;C:770677822;G:784641418;T:866859145;N:182596 151 0     880833177 770677822 784641418 866859145 182596 SRX11980367 SRS9988545 SRA1287281 Chinese Academy of Sciences|Institute of Zoology Chinese Academy of Sciences 1 0.94592   0.07933   0.67939   0.46558   151   B   usable mapping rate illumina novaseq_era unknown random_priming unknown bulk unknown unknown   China 2021-09-01 Larval Larval Embryo Imprecise All anatomical structures
65879 65879 SRR15684064 SRX11980366 SRS9988544 SRP335145 PRJNA758770 Danio rerio Raw sequence reads PRJNA758770 Whole Genome Sequencing A polyfluorinated compound H PFMO2OSA induced transcriptome alters in early zebrafish embryo         PFVE80 4.R2   strain:AB|age:120h|sex:N1|tissue:embyo|treatment:PFVE 4.2|BioSampleModel:Model organism or animal                 RNA Seq of embryo SAMN21035691 SAMN21035691 Illumina NovaSeq 6000     RNA-Seq TRANSCRIPTOMIC RANDOM PCR SINGLE ILLUMINA Illumina NovaSeq 6000   SRP335145     PFVE80_4.R2.fastq.gz fastq 3525791110.0 23349610.0 PFVE80 4.R2.fastq.gz 0:0 1:151 A:962908653;C:796116922;G:823506287;T:943223019;N:36229 0 151     962908653 796116922 823506287 943223019 36229 SRX11980366 SRS9988544 SRA1287281 Chinese Academy of Sciences|Institute of Zoology Chinese Academy of Sciences 1 0.93487   0.10192   0.68193   0.48466   151   B   usable mapping rate illumina novaseq_era unknown random_priming unknown bulk unknown unknown   China 2021-09-01 Larval Larval Embryo Imprecise All anatomical structures
65880 65880 SRR15684065 SRX11980365 SRS9988543 SRP335145 PRJNA758770 Danio rerio Raw sequence reads PRJNA758770 Whole Genome Sequencing A polyfluorinated compound H PFMO2OSA induced transcriptome alters in early zebrafish embryo         PFVE80 4.R1   strain:AB|age:120h|sex:N1|tissue:embyo|treatment:PFVE 4.1|BioSampleModel:Model organism or animal                 RNA Seq of embryo SAMN21035690 SAMN21035690 Illumina NovaSeq 6000     RNA-Seq TRANSCRIPTOMIC RANDOM PCR SINGLE ILLUMINA Illumina NovaSeq 6000   SRP335145     PFVE80_4.R1.fastq.gz fastq 3525791110.0 23349610.0 PFVE80 4.R1.fastq.gz 0:151 1:0 A:961509026;C:801265885;G:818953915;T:943866829;N:195455 151 0     961509026 801265885 818953915 943866829 195455 SRX11980365 SRS9988543 SRA1287281 Chinese Academy of Sciences|Institute of Zoology Chinese Academy of Sciences 1 0.93687   0.1026   0.67978   0.48493   151   B   usable mapping rate illumina novaseq_era unknown random_priming unknown bulk unknown unknown   China 2021-09-01 Larval Larval Embryo Imprecise All anatomical structures
65881 65881 SRR15684066 SRX11980364 SRS9988542 SRP335145 PRJNA758770 Danio rerio Raw sequence reads PRJNA758770 Whole Genome Sequencing A polyfluorinated compound H PFMO2OSA induced transcriptome alters in early zebrafish embryo         PFVE80 3.R2   strain:AB|age:120h|sex:N1|tissue:embyo|treatment:PFVE 3.2|BioSampleModel:Model organism or animal                 RNA Seq of embryo SAMN21035689 SAMN21035689 Illumina NovaSeq 6000     RNA-Seq TRANSCRIPTOMIC RANDOM PCR SINGLE ILLUMINA Illumina NovaSeq 6000   SRP335145     PFVE80_3.R2.fastq.gz fastq 3894722615.0 25792865.0 PFVE80 3.R2.fastq.gz 0:0 1:151 A:1061897475;C:882432313;G:910119669;T:1040233778;N:39380 0 151     1061897475 882432313 910119669 1040233778 39380 SRX11980364 SRS9988542 SRA1287281 Chinese Academy of Sciences|Institute of Zoology Chinese Academy of Sciences 1 0.92449   0.09119   0.68256   0.47211   151   B   usable mapping rate illumina novaseq_era unknown random_priming unknown bulk unknown unknown   China 2021-09-01 Larval Larval Embryo Imprecise All anatomical structures
65882 65882 SRR15684067 SRX11980363 SRS9988541 SRP335145 PRJNA758770 Danio rerio Raw sequence reads PRJNA758770 Whole Genome Sequencing A polyfluorinated compound H PFMO2OSA induced transcriptome alters in early zebrafish embryo         PFVE80 3.R1   strain:AB|age:120h|sex:N1|tissue:embyo|treatment:PFVE 3.1|BioSampleModel:Model organism or animal                 RNA Seq of embryo SAMN21035688 SAMN21035688 Illumina NovaSeq 6000     RNA-Seq TRANSCRIPTOMIC RANDOM PCR SINGLE ILLUMINA Illumina NovaSeq 6000   SRP335145     PFVE80_3.R1.fastq.gz fastq 3894722615.0 25792865.0 PFVE80 3.R1.fastq.gz 0:151 1:0 A:1058737478;C:888069233;G:906287035;T:1041414732;N:214137 151 0     1058737478 888069233 906287035 1041414732 214137 SRX11980363 SRS9988541 SRA1287281 Chinese Academy of Sciences|Institute of Zoology Chinese Academy of Sciences 1 0.92619   0.09159   0.68219   0.47411   151   B   usable mapping rate illumina novaseq_era unknown random_priming unknown bulk unknown unknown   China 2021-09-01 Larval Larval Embryo Imprecise All anatomical structures
65883 65883 SRR15684068 SRX11980362 SRS9988540 SRP335145 PRJNA758770 Danio rerio Raw sequence reads PRJNA758770 Whole Genome Sequencing A polyfluorinated compound H PFMO2OSA induced transcriptome alters in early zebrafish embryo         PFVE80 2.R2   strain:AB|age:120h|sex:N1|tissue:embyo|treatment:PFVE 2.2|BioSampleModel:Model organism or animal                 RNA Seq of embryo SAMN21035687 SAMN21035687 Illumina NovaSeq 6000     RNA-Seq TRANSCRIPTOMIC RANDOM PCR SINGLE ILLUMINA Illumina NovaSeq 6000   SRP335145     PFVE80_2.R2.fastq.gz fastq 3643079454.0 24126354.0 PFVE80 2.R2.fastq.gz 0:0 1:151 A:970097971;C:847572569;G:875660538;T:949711134;N:37242 0 151     970097971 847572569 875660538 949711134 37242 SRX11980362 SRS9988540 SRA1287281 Chinese Academy of Sciences|Institute of Zoology Chinese Academy of Sciences 1 0.94336   0.07333   0.68105   0.4837   151   B   usable mapping rate illumina novaseq_era unknown random_priming unknown bulk unknown unknown   China 2021-09-01 Larval Larval Embryo Imprecise All anatomical structures
65884 65884 SRR15684069 SRX11980361 SRS9988539 SRP335145 PRJNA758770 Danio rerio Raw sequence reads PRJNA758770 Whole Genome Sequencing A polyfluorinated compound H PFMO2OSA induced transcriptome alters in early zebrafish embryo         PFVE80 2.R1   strain:AB|age:120h|sex:N1|tissue:embyo|treatment:PFVE 2.1|BioSampleModel:Model organism or animal                 RNA Seq of embryo SAMN21035686 SAMN21035686 Illumina NovaSeq 6000     RNA-Seq TRANSCRIPTOMIC RANDOM PCR SINGLE ILLUMINA Illumina NovaSeq 6000   SRP335145     PFVE80_2.R1.fastq.gz fastq 3643079454.0 24126354.0 PFVE80 2.R1.fastq.gz 0:151 1:0 A:967689988;C:854955078;G:869122952;T:951106145;N:205291 151 0     967689988 854955078 869122952 951106145 205291 SRX11980361 SRS9988539 SRA1287281 Chinese Academy of Sciences|Institute of Zoology Chinese Academy of Sciences 1 0.94505   0.07378   0.67909   0.48465   151   B   usable mapping rate illumina novaseq_era unknown random_priming unknown bulk unknown unknown   China 2021-09-01 Larval Larval Embryo Imprecise All anatomical structures
65885 65885 SRR15684070 SRX11980360 SRS9988538 SRP335145 PRJNA758770 Danio rerio Raw sequence reads PRJNA758770 Whole Genome Sequencing A polyfluorinated compound H PFMO2OSA induced transcriptome alters in early zebrafish embryo         PFVE0 1.R2   strain:AB|age:120h|sex:N1|tissue:embyo|treatment:H20 1.2|BioSampleModel:Model organism or animal                 RNA Seq of embryo SAMN21035677 SAMN21035677 Illumina NovaSeq 6000     RNA-Seq TRANSCRIPTOMIC RANDOM PCR SINGLE ILLUMINA Illumina NovaSeq 6000   SRP335145     PFVE0_1.R2.fastq.gz fastq 3437455053.0 22764603.0 PFVE0 1.R2.fastq.gz 0:0 1:151 A:927165985;C:787962049;G:812091935;T:910201170;N:33914 0 151     927165985 787962049 812091935 910201170 33914 SRX11980360 SRS9988538 SRA1287281 Chinese Academy of Sciences|Institute of Zoology Chinese Academy of Sciences 1 0.9386   0.08934   0.67679   0.45689   151   B   usable mapping rate illumina novaseq_era unknown random_priming unknown bulk unknown unknown   China 2021-09-01 Larval Larval Embryo Imprecise All anatomical structures
65886 65886 SRR15684071 SRX11980359 SRS9988537 SRP335145 PRJNA758770 Danio rerio Raw sequence reads PRJNA758770 Whole Genome Sequencing A polyfluorinated compound H PFMO2OSA induced transcriptome alters in early zebrafish embryo         PFVE0 1.R1   strain:AB|age:120h|sex:N1|tissue:embyo|treatment:H20 1.1|BioSampleModel:Model organism or animal                 RNA Seq of embryo SAMN21035676 SAMN21035676 Illumina NovaSeq 6000     RNA-Seq TRANSCRIPTOMIC RANDOM PCR SINGLE ILLUMINA Illumina NovaSeq 6000   SRP335145     PFVE0_1.R1.fastq.gz fastq 3437455053.0 22764603.0 PFVE0 1.R1.fastq.gz 0:151 1:0 A:925579878;C:793447833;G:807004079;T:911233278;N:189985 151 0     925579878 793447833 807004079 911233278 189985 SRX11980359 SRS9988537 SRA1287281 Chinese Academy of Sciences|Institute of Zoology Chinese Academy of Sciences 1 0.93961   0.08975   0.6757   0.4584   151   B   usable mapping rate illumina novaseq_era unknown random_priming unknown bulk unknown unknown   China 2021-09-01 Larval Larval Embryo Imprecise All anatomical structures

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