RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

run_metadata

12 rows where experiment.library_selection = "cDNA", experiment.library_strategy = "miRNA-Seq" and tissue_curation = "Embryo Imprecise"

✎ View and edit SQL

This data as json, CSV (advanced)

devstage_curation 7

devstage_curation_coarse 2

tissue_curation_coarse 1

tissue_curation 1

  • Embryo Imprecise · 12 ✖

technology 1

experiment.platform 1

experiment.library_strategy 1

  • miRNA-Seq · 12 ✖

experiment.library_source 1

experiment.library_selection 1

  • cDNA · 12 ✖

experiment.library_layout 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
41406 41406 SRR4423130 SRX2245314 SRS1745863 SRP091534 PRJNA347637 Danio rerio and Xenopus laevis Raw sequence reads PRJNA347637 Other To study the transcriptome during development         Time course 10 Dr   strain:not applicable|isolate:not applicable|breed:ABTL|cultivar:not applicable|ecotype:not applicable|age:not applicable|dev stage:prim 16 stage|sex:not determined|tissue:single embryo|BioSampleModel:Model organism or animal                 miRNA Seq of Zebrafish: prim 16 stage31 hpf 348 10 348 10 Libraries were generated according to the manufacturers’ protocols using the Ion Total RNA Seq Kit v2 and the Ion Xpress™ RNA Seq bar coding kit Thermo Fisher Scientific. A few modifications were made during purification steps in the small RNAseq to allow sequencing of longer RNAs up to 200 nt than with standard sRNA protocols. Namely: 153 µl ethanol instead of 120 µl during purification of cDNA and 134 µl ethanol instead of 110 µl in protocol.     miRNA-Seq TRANSCRIPTOMIC cDNA SINGLE ION_TORRENT Ion Torrent Proton   SRP091534     S10small.fastq fastq 427409571.0 5026564.0 S10small.fastq 0:85.03 A:98026046;C:116630773;G:114413502;T:98339250;N:0 85       98026046 116630773 114413502 98339250 0 SRX2245314 SRS1745863 SRA485147 Universiteit van Amsterdam|SILS Universiteit van Amsterdam 1 0.81583   0.17938   0.9094   0.63072   126   B   usable mapping rate ion_torrent ion_torrent unknown small_rna unknown bulk unknown unknown   Netherlands 2016-10-19 Pharyngula Embryo Embryo Imprecise All anatomical structures
41407 41407 SRR4423129 SRX2245313 SRS1745862 SRP091534 PRJNA347637 Danio rerio and Xenopus laevis Raw sequence reads PRJNA347637 Other To study the transcriptome during development         Time course 9 Dr   strain:not applicable|isolate:not applicable|breed:ABTL|cultivar:not applicable|ecotype:not applicable|age:not applicable|dev stage:prim 5 stage|sex:not determined|tissue:single embryo|BioSampleModel:Model organism or animal                 miRNA Seq of Zebrafish: prim 5 stage24 hpf 348 9 348 9 Libraries were generated according to the manufacturers’ protocols using the Ion Total RNA Seq Kit v2 and the Ion Xpress™ RNA Seq bar coding kit Thermo Fisher Scientific. A few modifications were made during purification steps in the small RNAseq to allow sequencing of longer RNAs up to 200 nt than with standard sRNA protocols. Namely: 153 µl ethanol instead of 120 µl during purification of cDNA and 134 µl ethanol instead of 110 µl in protocol.     miRNA-Seq TRANSCRIPTOMIC cDNA SINGLE ION_TORRENT Ion Torrent Proton   SRP091534     S09small.fastq fastq 516614705.0 6246071.0 S09small.fastq 0:82.71 A:117786535;C:140799134;G:139362428;T:118666608;N:0 82       117786535 140799134 139362428 118666608 0 SRX2245313 SRS1745862 SRA485147 Universiteit van Amsterdam|SILS Universiteit van Amsterdam 1 0.81132   0.18952   0.88925   0.69719   17   B   usable mapping rate ion_torrent ion_torrent unknown small_rna unknown bulk unknown unknown   Netherlands 2016-10-19 Pharyngula Embryo Embryo Imprecise All anatomical structures
41408 41408 SRR4423128 SRX2245312 SRS1745850 SRP091534 PRJNA347637 Danio rerio and Xenopus laevis Raw sequence reads PRJNA347637 Other To study the transcriptome during development         Time course 12 Dr   strain:not applicable|isolate:not applicable|breed:ABTL|cultivar:not applicable|ecotype:not applicable|age:not applicable|dev stage:protruding mouth stage|sex:not determined|tissue:single embryo|BioSampleModel:Model organism or animal                 miRNA Seq of Zebrafish: protruding mouth stage72 hpf 348 12 348 12 Libraries were generated according to the manufacturers’ protocols using the Ion Total RNA Seq Kit v2 and the Ion Xpress™ RNA Seq bar coding kit Thermo Fisher Scientific. A few modifications were made during purification steps in the small RNAseq to allow sequencing of longer RNAs up to 200 nt than with standard sRNA protocols. Namely: 153 µl ethanol instead of 120 µl during purification of cDNA and 134 µl ethanol instead of 110 µl in protocol.     miRNA-Seq TRANSCRIPTOMIC cDNA SINGLE ION_TORRENT Ion Torrent Proton   SRP091534     S12small.fastq fastq 186817590.0 3062463.0 S12small.fastq 0:61.00 A:42863072;C:49941244;G:49513828;T:44499446;N:0 61       42863072 49941244 49513828 44499446 0 SRX2245312 SRS1745850 SRA485147 Universiteit van Amsterdam|SILS Universiteit van Amsterdam 1 0.77668   0.17381   0.8915   0.54189   36   B   usable mapping rate ion_torrent ion_torrent unknown small_rna unknown bulk unknown unknown   Netherlands 2016-10-19 Larval Larval Embryo Imprecise All anatomical structures
41409 41409 SRR4423127 SRX2245311 SRS1745851 SRP091534 PRJNA347637 Danio rerio and Xenopus laevis Raw sequence reads PRJNA347637 Other To study the transcriptome during development         Time course 11 Dr   strain:not applicable|isolate:not applicable|breed:ABTL|cultivar:not applicable|ecotype:not applicable|age:not applicable|dev stage:long pec stage|sex:not determined|tissue:single embryo|BioSampleModel:Model organism or animal                 miRNA Seq of Zebrafish: long pec stage48 hpf 348 11 348 11 Libraries were generated according to the manufacturers’ protocols using the Ion Total RNA Seq Kit v2 and the Ion Xpress™ RNA Seq bar coding kit Thermo Fisher Scientific. A few modifications were made during purification steps in the small RNAseq to allow sequencing of longer RNAs up to 200 nt than with standard sRNA protocols. Namely: 153 µl ethanol instead of 120 µl during purification of cDNA and 134 µl ethanol instead of 110 µl in protocol.     miRNA-Seq TRANSCRIPTOMIC cDNA SINGLE ION_TORRENT Ion Torrent Proton   SRP091534     S11small.fastq fastq 405003101.0 5197273.0 S11small.fastq 0:77.93 A:93494059;C:109265919;G:106696649;T:95546474;N:0 77       93494059 109265919 106696649 95546474 0 SRX2245311 SRS1745851 SRA485147 Universiteit van Amsterdam|SILS Universiteit van Amsterdam 1 0.78244   0.17047   0.93379   0.6272   30   B   usable mapping rate ion_torrent ion_torrent unknown small_rna unknown bulk unknown unknown   Netherlands 2016-10-19 Hatching Embryo Embryo Imprecise All anatomical structures
41428 41428 SRR4423108 SRX2245292 SRS1745857 SRP091534 PRJNA347637 Danio rerio and Xenopus laevis Raw sequence reads PRJNA347637 Other To study the transcriptome during development         Time course 5 Dr   strain:not applicable|isolate:not applicable|breed:ABTL|cultivar:not applicable|ecotype:not applicable|age:not applicable|dev stage:90% epiboly stage|sex:not determined|tissue:single embryo|BioSampleModel:Model organism or animal                 miRNA Seq of Zebrafish: 90% epiboly stage 9 hpf 348 5 348 5 Libraries were generated according to the manufacturers’ protocols using the Ion Total RNA Seq Kit v2 and the Ion Xpress™ RNA Seq bar coding kit Thermo Fisher Scientific. A few modifications were made during purification steps in the small RNAseq to allow sequencing of longer RNAs up to 200 nt than with standard sRNA protocols. Namely: 153 µl ethanol instead of 120 µl during purification of cDNA and 134 µl ethanol instead of 110 µl in protocol.     miRNA-Seq TRANSCRIPTOMIC cDNA SINGLE ION_TORRENT Ion Torrent Proton   SRP091534     S05small.fastq fastq 412237561.0 3386443.0 S05small.fastq 0:121.73 A:91644321;C:118905395;G:115070912;T:86616933;N:0 121       91644321 118905395 115070912 86616933 0 SRX2245292 SRS1745857 SRA485147 Universiteit van Amsterdam|SILS Universiteit van Amsterdam 1 0.81233   0.06309   0.93385   0.93973   163   B   usable mapping rate ion_torrent ion_torrent unknown small_rna unknown bulk unknown unknown   Netherlands 2016-10-19 Gastrula Embryo Embryo Imprecise All anatomical structures
41429 41429 SRR4423107 SRX2245291 SRS1745856 SRP091534 PRJNA347637 Danio rerio and Xenopus laevis Raw sequence reads PRJNA347637 Other To study the transcriptome during development         Time course 6 Dr   strain:not applicable|isolate:not applicable|breed:ABTL|cultivar:not applicable|ecotype:not applicable|age:not applicable|dev stage:4 somite stage|sex:not determined|tissue:single embryo|BioSampleModel:Model organism or animal                 miRNA Seq of Zebrafish: 4 somite stage11.3 hpf 348 6 348 6 Libraries were generated according to the manufacturers’ protocols using the Ion Total RNA Seq Kit v2 and the Ion Xpress™ RNA Seq bar coding kit Thermo Fisher Scientific. A few modifications were made during purification steps in the small RNAseq to allow sequencing of longer RNAs up to 200 nt than with standard sRNA protocols. Namely: 153 µl ethanol instead of 120 µl during purification of cDNA and 134 µl ethanol instead of 110 µl in protocol.     miRNA-Seq TRANSCRIPTOMIC cDNA SINGLE ION_TORRENT Ion Torrent Proton   SRP091534     S06small.fastq fastq 535288776.0 4443685.0 S06small.fastq 0:120.46 A:119322177;C:152704452;G:149509408;T:113752739;N:0 120       119322177 152704452 149509408 113752739 0 SRX2245291 SRS1745856 SRA485147 Universiteit van Amsterdam|SILS Universiteit van Amsterdam 1 0.82872   0.09035   0.93194   0.81296   159   B   usable mapping rate ion_torrent ion_torrent unknown small_rna unknown bulk unknown unknown   Netherlands 2016-10-19 Segmentation Embryo Embryo Imprecise All anatomical structures
41430 41430 SRR4423106 SRX2245290 SRS1745854 SRP091534 PRJNA347637 Danio rerio and Xenopus laevis Raw sequence reads PRJNA347637 Other To study the transcriptome during development         Time course 3 Dr   strain:not applicable|isolate:not applicable|breed:ABTL|cultivar:not applicable|ecotype:not applicable|age:not applicable|dev stage:zfs:0000015 stage|sex:not determined|tissue:single embryo|BioSampleModel:Model organism or animal                 miRNA Seq of Zebrafish: zfs:0000015 stage 4.7 hpf 348 3 348 3 Libraries were generated according to the manufacturers’ protocols using the Ion Total RNA Seq Kit v2 and the Ion Xpress™ RNA Seq bar coding kit Thermo Fisher Scientific. A few modifications were made during purification steps in the small RNAseq to allow sequencing of longer RNAs up to 200 nt than with standard sRNA protocols. Namely: 153 µl ethanol instead of 120 µl during purification of cDNA and 134 µl ethanol instead of 110 µl in protocol.     miRNA-Seq TRANSCRIPTOMIC cDNA SINGLE ION_TORRENT Ion Torrent Proton   SRP091534     S03small.fastq fastq 1025732824.0 7452991.0 S03small.fastq 0:137.63 A:225573059;C:298586545;G:288470386;T:213102834;N:0 137       225573059 298586545 288470386 213102834 0 SRX2245290 SRS1745854 SRA485147 Universiteit van Amsterdam|SILS Universiteit van Amsterdam 1 0.8983   0.04271   0.95546   0.91281   159   B   usable mapping rate ion_torrent ion_torrent unknown small_rna unknown bulk unknown unknown   Netherlands 2016-10-19 Blastula Embryo Embryo Imprecise All anatomical structures
41431 41431 SRR4423105 SRX2245289 SRS1745855 SRP091534 PRJNA347637 Danio rerio and Xenopus laevis Raw sequence reads PRJNA347637 Other To study the transcriptome during development         Time course 4 Dr   strain:not applicable|isolate:not applicable|breed:ABTL|cultivar:not applicable|ecotype:not applicable|age:not applicable|dev stage:70% epiboly stage|sex:not determined|tissue:single embryo|BioSampleModel:Model organism or animal                 miRNA Seq of Zebrafish: 70% epiboly stage7 hpf 348 4 348 4 Libraries were generated according to the manufacturers’ protocols using the Ion Total RNA Seq Kit v2 and the Ion Xpress™ RNA Seq bar coding kit Thermo Fisher Scientific. A few modifications were made during purification steps in the small RNAseq to allow sequencing of longer RNAs up to 200 nt than with standard sRNA protocols. Namely: 153 µl ethanol instead of 120 µl during purification of cDNA and 134 µl ethanol instead of 110 µl in protocol.     miRNA-Seq TRANSCRIPTOMIC cDNA SINGLE ION_TORRENT Ion Torrent Proton   SRP091534     S04small.fastq fastq 193259658.0 1840126.0 S04small.fastq 0:105.03 A:43516548;C:54669405;G:53501927;T:41571778;N:0 105       43516548 54669405 53501927 41571778 0 SRX2245289 SRS1745855 SRA485147 Universiteit van Amsterdam|SILS Universiteit van Amsterdam 1 0.81053   0.16265   0.90698   0.92112   159   B   usable mapping rate ion_torrent ion_torrent unknown small_rna unknown bulk unknown unknown   Netherlands 2016-10-19 Gastrula Embryo Embryo Imprecise All anatomical structures
41432 41432 SRR4423104 SRX2245288 SRS1745853 SRP091534 PRJNA347637 Danio rerio and Xenopus laevis Raw sequence reads PRJNA347637 Other To study the transcriptome during development         Time course 1 Dr   strain:not applicable|isolate:not applicable|breed:ABTL|cultivar:not applicable|ecotype:not applicable|age:not applicable|dev stage:64 cells|sex:not determined|tissue:single embryo|BioSampleModel:Model organism or animal                 miRNA Seq of Zebrafish: 64 cells2 hpf 348 1 348 1 Libraries were generated according to the manufacturers’ protocols using the Ion Total RNA Seq Kit v2 and the Ion Xpress™ RNA Seq bar coding kit Thermo Fisher Scientific. A few modifications were made during purification steps in the small RNAseq to allow sequencing of longer RNAs up to 200 nt than with standard sRNA protocols. Namely: 153 µl ethanol instead of 120 µl during purification of cDNA and 134 µl ethanol instead of 110 µl in protocol.     miRNA-Seq TRANSCRIPTOMIC cDNA SINGLE ION_TORRENT Ion Torrent Proton   SRP091534     S01small.fastq fastq 91910627.0 1396009.0 S01small.fastq 0:65.84 A:21663404;C:25661192;G:25069267;T:19516764;N:0 65       21663404 25661192 25069267 19516764 0 SRX2245288 SRS1745853 SRA485147 Universiteit van Amsterdam|SILS Universiteit van Amsterdam 1 0.56828   0.1715   0.92435   0.90047   34   B   usable mapping rate ion_torrent ion_torrent unknown small_rna unknown bulk unknown unknown   Netherlands 2016-10-19 Cleavage Embryo Embryo Imprecise All anatomical structures
41433 41433 SRR4423103 SRX2245287 SRS1745852 SRP091534 PRJNA347637 Danio rerio and Xenopus laevis Raw sequence reads PRJNA347637 Other To study the transcriptome during development         Time course 2 Dr   strain:not applicable|isolate:not applicable|breed:ABTL|cultivar:not applicable|ecotype:not applicable|age:not applicable|dev stage:high stage|sex:not determined|tissue:single embryo|BioSampleModel:Model organism or animal                 miRNA Seq of Zebrafish: high stage3.3 hpf 348 2 348 2 Libraries were generated according to the manufacturers’ protocols using the Ion Total RNA Seq Kit v2 and the Ion Xpress™ RNA Seq bar coding kit Thermo Fisher Scientific. A few modifications were made during purification steps in the small RNAseq to allow sequencing of longer RNAs up to 200 nt than with standard sRNA protocols. Namely: 153 µl ethanol instead of 120 µl during purification of cDNA and 134 µl ethanol instead of 110 µl in protocol.     miRNA-Seq TRANSCRIPTOMIC cDNA SINGLE ION_TORRENT Ion Torrent Proton   SRP091534     S02small.fastq fastq 304535574.0 3376105.0 S02small.fastq 0:90.20 A:69193719;C:84372087;G:86707481;T:64262287;N:0 90       69193719 84372087 86707481 64262287 0 SRX2245287 SRS1745852 SRA485147 Universiteit van Amsterdam|SILS Universiteit van Amsterdam 1 0.56812   0.09695   0.93474   0.93654   51   B   usable mapping rate ion_torrent ion_torrent unknown small_rna unknown bulk unknown unknown   Netherlands 2016-10-19 Blastula Embryo Embryo Imprecise All anatomical structures
41436 41436 SRR4423100 SRX2245284 SRS1745849 SRP091534 PRJNA347637 Danio rerio and Xenopus laevis Raw sequence reads PRJNA347637 Other To study the transcriptome during development         Time course 7 Dr   strain:not applicable|isolate:not applicable|breed:ABTL|cultivar:not applicable|ecotype:not applicable|age:not applicable|dev stage:12 somite stage|sex:not determined|tissue:single embryo|BioSampleModel:Model organism or animal                 miRNA Seq of Zebrafish: 12 somite stage15 hpf 348 7 348 7 Libraries were generated according to the manufacturers’ protocols using the Ion Total RNA Seq Kit v2 and the Ion Xpress™ RNA Seq bar coding kit Thermo Fisher Scientific. A few modifications were made during purification steps in the small RNAseq to allow sequencing of longer RNAs up to 200 nt than with standard sRNA protocols. Namely: 153 µl ethanol instead of 120 µl during purification of cDNA and 134 µl ethanol instead of 110 µl in protocol.     miRNA-Seq TRANSCRIPTOMIC cDNA SINGLE ION_TORRENT Ion Torrent Proton   SRP091534     S07small.fastq fastq 279201769.0 2713759.0 S07small.fastq 0:102.88 A:61655863;C:78667355;G:77702440;T:61176111;N:0 102       61655863 78667355 77702440 61176111 0 SRX2245284 SRS1745849 SRA485147 Universiteit van Amsterdam|SILS Universiteit van Amsterdam 1 0.79087   0.10046   0.89221   0.77892   158   B   usable mapping rate ion_torrent ion_torrent unknown small_rna unknown bulk unknown unknown   Netherlands 2016-10-19 Segmentation Embryo Embryo Imprecise All anatomical structures
41437 41437 SRR4423099 SRX2245283 SRS1745848 SRP091534 PRJNA347637 Danio rerio and Xenopus laevis Raw sequence reads PRJNA347637 Other To study the transcriptome during development         Time course 8 Dr   strain:not applicable|isolate:not applicable|breed:ABTL|cultivar:not applicable|ecotype:not applicable|age:not applicable|dev stage:22 somite stage|sex:not determined|tissue:single embryo|BioSampleModel:Model organism or animal                 miRNA Seq of Zebrafish: 22 somite stage20 hpf 348 8 348 8 Libraries were generated according to the manufacturers’ protocols using the Ion Total RNA Seq Kit v2 and the Ion Xpress™ RNA Seq bar coding kit Thermo Fisher Scientific. A few modifications were made during purification steps in the small RNAseq to allow sequencing of longer RNAs up to 200 nt than with standard sRNA protocols. Namely: 153 µl ethanol instead of 120 µl during purification of cDNA and 134 µl ethanol instead of 110 µl in protocol.     miRNA-Seq TRANSCRIPTOMIC cDNA SINGLE ION_TORRENT Ion Torrent Proton   SRP091534     S08small.fastq fastq 520785540.0 4495080.0 S08small.fastq 0:115.86 A:115224831;C:149325753;G:144978190;T:111256766;N:0 115       115224831 149325753 144978190 111256766 0 SRX2245283 SRS1745848 SRA485147 Universiteit van Amsterdam|SILS Universiteit van Amsterdam 1 0.83781   0.08976   0.92904   0.80492   183   B   usable mapping rate ion_torrent ion_torrent unknown small_rna unknown bulk unknown unknown   Netherlands 2016-10-19 Segmentation Embryo 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");;