run_metadata
12 rows where devstage_curation_coarse = "Adult" and experiment.library_strategy = "WXS"
This data as json, CSV (advanced)
| Link | rowid ▼ | run.accession | experiment.accession | sample.accession | study.accession | bioproject | study.title | study.alias | study.type | study.abstract | study.attributes | study.PMIDs | sample.description | sample.title | sample.alias | sample.centername | sample.attributes | GEOsample.title | GEOsample.dataprocessing | GEOsample.source | GEOsample.treatmentprotocol | GEOsample.extractprotocol | GEOsample.growthprotocol | GEOsample.characteristics | GEOsample.accession | experiment.title | experiment.alias | experiment.library_name | experiment.design_description | experiment.library_construction_protocol | experiment.attributes | experiment.library_strategy | experiment.library_source | experiment.library_selection | experiment.library_layout | experiment.platform | experiment.instrument_model | experiment.spot_descriptor | experiment.study_ref | run.title | run.attributes | run.filename | run.semantic_name | run.total_bases | run.total_spots | run.alias | run.read_lengths | run.base_counts | run.r1_length | run.r2_length | run.r3_length | run.r4_length | run.Acount | run.Ccount | run.Gcount | run.Tcount | run.Ncount | run.experiment | run.pool_member | submission.accession | submission.srasource | submission.bioprojectsource | seqdetective.n_mates | seqdetective.mapping_rate.mate1 | seqdetective.mapping_rate.mate2 | seqdetective.nofeature_rate.mate1 | seqdetective.nofeature_rate.mate2 | seqdetective.sparsity.mate1 | seqdetective.sparsity.mate2 | seqdetective.pos_strand_rate.mate1 | seqdetective.pos_strand_rate.mate2 | seqdetective.readlen.mate1 | seqdetective.readlen.mate2 | seqdetective.judgement.mate1 | seqdetective.judgement.mate2 | seqdetective.judgement.reason | platform_family | instrument_generation | read_bias | selection_class | prep_kit | sc_or_bulk | tech_class | technology | tech_variant | submission.bioprojectsource.country | earliest_date | devstage_curation | devstage_curation_coarse | tissue_curation | tissue_curation_coarse |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 34593 | 34593 | SRR32128857 | SRX27475161 | SRS23899211 | SRP559934 | PRJNA1215774 | 3 mpf dark reared zebrafish eye RNA sequencing | PRJNA1215774 | Other | Outdoor time and light intensity are important emerging factors affecting myopia; however the underlying mechanisms remain unknown. To clarify the possible molecular mechanisms underlying myopia caused by dark environment 3 mpf zebrafish eye RNA sequencing was performed. | lighttreated4 | strain:not applicable|isolate:Sun Yat sen University|breed:not applicable10|cultivar:not applicable|ecotype:not applicable|age:not applicable|dev stage:not applicable10|collection date:2021 04 16|geo loc name:China: GuangZhou|sex:not applicable|tissue:zebrafish10|isolation source:zebrafish10|BioSampleModel:Model organism or animal | sample info | library 10 | library 10 | DNA barcode10 | WXS | TRANSCRIPTOMIC | PCR | PAIRED | ILLUMINA | Illumina NovaSeq 6000 | SRP559934 | lighttreated4.read1.fastq.gz lighttreated4.read2.fastq.gz | fastq fastq | 6388100400.0 | 21293668.0 | lighttreated4.read1.fastq.gz | 0:150 1:150 | A:1711345062;C:1474552325;G:1531680528;T:1670485285;N:37200 | 150 | 150 | 1711345062 | 1474552325 | 1531680528 | 1670485285 | 37200 | SRX27475161 | SRS23899211 | SRA2060897 | zhujiang hospital|ophthalmology | zhujiang hospital | B | B | biological fallback assumption | illumina | novaseq_era | unknown | random_priming | unknown | bulk | unknown | unknown | China | 2025-01-25 | Undetermined | Adult | Undetermined | Undetermined | ||||||||||||||||||||||||||||||||
| 34594 | 34594 | SRR32128858 | SRX27475160 | SRS23899210 | SRP559934 | PRJNA1215774 | 3 mpf dark reared zebrafish eye RNA sequencing | PRJNA1215774 | Other | Outdoor time and light intensity are important emerging factors affecting myopia; however the underlying mechanisms remain unknown. To clarify the possible molecular mechanisms underlying myopia caused by dark environment 3 mpf zebrafish eye RNA sequencing was performed. | lighttreated3 | strain:not applicable|isolate:Sun Yat sen University|breed:not applicable9|cultivar:not applicable|ecotype:not applicable|age:not applicable|dev stage:not applicable9|collection date:2021 04 16|geo loc name:China: GuangZhou|sex:not applicable|tissue:zebrafish9|isolation source:zebrafish9|BioSampleModel:Model organism or animal | sample info | library 9 | library 9 | DNA barcode9 | WXS | TRANSCRIPTOMIC | PCR | PAIRED | ILLUMINA | Illumina NovaSeq 6000 | SRP559934 | lighttreated3.read1.fastq.gz lighttreated3.read2.fastq.gz | fastq fastq | 7919383200.0 | 26397944.0 | lighttreated3.read1.fastq.gz | 0:150 1:150 | A:2135212601;C:1813586654;G:1892878979;T:2077658764;N:46202 | 150 | 150 | 2135212601 | 1813586654 | 1892878979 | 2077658764 | 46202 | SRX27475160 | SRS23899210 | SRA2060897 | zhujiang hospital|ophthalmology | zhujiang hospital | B | B | biological fallback assumption | illumina | novaseq_era | unknown | random_priming | unknown | bulk | unknown | unknown | China | 2025-01-25 | Undetermined | Adult | Undetermined | Undetermined | ||||||||||||||||||||||||||||||||
| 34595 | 34595 | SRR32128859 | SRX27475159 | SRS23899209 | SRP559934 | PRJNA1215774 | 3 mpf dark reared zebrafish eye RNA sequencing | PRJNA1215774 | Other | Outdoor time and light intensity are important emerging factors affecting myopia; however the underlying mechanisms remain unknown. To clarify the possible molecular mechanisms underlying myopia caused by dark environment 3 mpf zebrafish eye RNA sequencing was performed. | lighttreated2 | strain:not applicable|isolate:Sun Yat sen University|breed:not applicable8|cultivar:not applicable|ecotype:not applicable|age:not applicable|dev stage:not applicable8|collection date:2021 04 16|geo loc name:China: GuangZhou|sex:not applicable|tissue:zebrafish8|isolation source:zebrafish8|BioSampleModel:Model organism or animal | sample info | library 8 | library 8 | DNA barcode8 | WXS | TRANSCRIPTOMIC | PCR | PAIRED | ILLUMINA | Illumina NovaSeq 6000 | SRP559934 | lighttreated2.read1.fastq.gz lighttreated2.read2.fastq.gz | fastq fastq | 7060994100.0 | 23536647.0 | lighttreated2.read1.fastq.gz | 0:150 1:150 | A:1921099545;C:1595276449;G:1668657714;T:1875918159;N:42233 | 150 | 150 | 1921099545 | 1595276449 | 1668657714 | 1875918159 | 42233 | SRX27475159 | SRS23899209 | SRA2060897 | zhujiang hospital|ophthalmology | zhujiang hospital | B | B | biological fallback assumption | illumina | novaseq_era | unknown | random_priming | unknown | bulk | unknown | unknown | China | 2025-01-25 | Undetermined | Adult | Undetermined | Undetermined | ||||||||||||||||||||||||||||||||
| 34596 | 34596 | SRR32128860 | SRX27475158 | SRS23899208 | SRP559934 | PRJNA1215774 | 3 mpf dark reared zebrafish eye RNA sequencing | PRJNA1215774 | Other | Outdoor time and light intensity are important emerging factors affecting myopia; however the underlying mechanisms remain unknown. To clarify the possible molecular mechanisms underlying myopia caused by dark environment 3 mpf zebrafish eye RNA sequencing was performed. | lighttreated1 | strain:not applicable|isolate:Sun Yat sen University|breed:not applicable7|cultivar:not applicable|ecotype:not applicable|age:not applicable|dev stage:not applicable7|collection date:2021 04 16|geo loc name:China: GuangZhou|sex:not applicable|tissue:zebrafish7|isolation source:zebrafish7|BioSampleModel:Model organism or animal | sample info | library 7 | library 7 | DNA barcode7 | WXS | TRANSCRIPTOMIC | PCR | PAIRED | ILLUMINA | Illumina NovaSeq 6000 | SRP559934 | lighttreated1.read1.fastq.gz lighttreated1.read2.fastq.gz | fastq fastq | 6908625300.0 | 23028751.0 | lighttreated1.read1.fastq.gz | 0:150 1:150 | A:1872190225;C:1565342714;G:1644929113;T:1826124355;N:38893 | 150 | 150 | 1872190225 | 1565342714 | 1644929113 | 1826124355 | 38893 | SRX27475158 | SRS23899208 | SRA2060897 | zhujiang hospital|ophthalmology | zhujiang hospital | B | B | biological fallback assumption | illumina | novaseq_era | unknown | random_priming | unknown | bulk | unknown | unknown | China | 2025-01-25 | Undetermined | Adult | Undetermined | Undetermined | ||||||||||||||||||||||||||||||||
| 34597 | 34597 | SRR32128861 | SRX27475157 | SRS23899207 | SRP559934 | PRJNA1215774 | 3 mpf dark reared zebrafish eye RNA sequencing | PRJNA1215774 | Other | Outdoor time and light intensity are important emerging factors affecting myopia; however the underlying mechanisms remain unknown. To clarify the possible molecular mechanisms underlying myopia caused by dark environment 3 mpf zebrafish eye RNA sequencing was performed. | darktreated6 | strain:not applicable|isolate:Sun Yat sen University|breed:not applicable6|cultivar:not applicable|ecotype:not applicable|age:not applicable|dev stage:not applicable6|collection date:2021 04 16|geo loc name:China: GuangZhou|sex:not applicable|tissue:zebrafish6|isolation source:zebrafish6|BioSampleModel:Model organism or animal | sample info | library 6 | library 6 | DNA barcode6 | WXS | TRANSCRIPTOMIC | PCR | PAIRED | ILLUMINA | Illumina NovaSeq 6000 | SRP559934 | darktreated6.read1.fastq.gz darktreated6.read2.fastq.gz | fastq fastq | 8601630900.0 | 28672103.0 | darktreated6.read1.fastq.gz | 0:150 1:150 | A:2318530970;C:1973292572;G:2040962638;T:2268796005;N:48715 | 150 | 150 | 2318530970 | 1973292572 | 2040962638 | 2268796005 | 48715 | SRX27475157 | SRS23899207 | SRA2060897 | zhujiang hospital|ophthalmology | zhujiang hospital | B | B | biological fallback assumption | illumina | novaseq_era | unknown | random_priming | unknown | bulk | unknown | unknown | China | 2025-01-25 | Undetermined | Adult | Undetermined | Undetermined | ||||||||||||||||||||||||||||||||
| 34598 | 34598 | SRR32128862 | SRX27475156 | SRS23899206 | SRP559934 | PRJNA1215774 | 3 mpf dark reared zebrafish eye RNA sequencing | PRJNA1215774 | Other | Outdoor time and light intensity are important emerging factors affecting myopia; however the underlying mechanisms remain unknown. To clarify the possible molecular mechanisms underlying myopia caused by dark environment 3 mpf zebrafish eye RNA sequencing was performed. | darktreated5 | strain:not applicable|isolate:Sun Yat sen University|breed:not applicable5|cultivar:not applicable|ecotype:not applicable|age:not applicable|dev stage:not applicable5|collection date:2021 04 16|geo loc name:China: GuangZhou|sex:not applicable|tissue:zebrafish5|isolation source:zebrafish5|BioSampleModel:Model organism or animal | sample info | library 5 | library 5 | DNA barcode5 | WXS | TRANSCRIPTOMIC | PCR | PAIRED | ILLUMINA | Illumina NovaSeq 6000 | SRP559934 | darktreated5.read1.fastq.gz darktreated5.read2.fastq.gz | fastq fastq | 8265255300.0 | 27550851.0 | darktreated5.read1.fastq.gz | 0:150 1:150 | A:2224219375;C:1898065838;G:1969603341;T:2173318912;N:47834 | 150 | 150 | 2224219375 | 1898065838 | 1969603341 | 2173318912 | 47834 | SRX27475156 | SRS23899206 | SRA2060897 | zhujiang hospital|ophthalmology | zhujiang hospital | B | B | biological fallback assumption | illumina | novaseq_era | unknown | random_priming | unknown | bulk | unknown | unknown | China | 2025-01-25 | Undetermined | Adult | Undetermined | Undetermined | ||||||||||||||||||||||||||||||||
| 34599 | 34599 | SRR32128863 | SRX27475155 | SRS23899205 | SRP559934 | PRJNA1215774 | 3 mpf dark reared zebrafish eye RNA sequencing | PRJNA1215774 | Other | Outdoor time and light intensity are important emerging factors affecting myopia; however the underlying mechanisms remain unknown. To clarify the possible molecular mechanisms underlying myopia caused by dark environment 3 mpf zebrafish eye RNA sequencing was performed. | darktreated4 | strain:not applicable|isolate:Sun Yat sen University|breed:not applicable4|cultivar:not applicable|ecotype:not applicable|age:not applicable|dev stage:not applicable4|collection date:2021 04 16|geo loc name:China: GuangZhou|sex:not applicable|tissue:zebrafish4|isolation source:zebrafish4|BioSampleModel:Model organism or animal | sample info | library 4 | library 4 | DNA barcode4 | WXS | TRANSCRIPTOMIC | PCR | PAIRED | ILLUMINA | Illumina NovaSeq 6000 | SRP559934 | darktreated4.read1.fastq.gz darktreated4.read2.fastq.gz | fastq fastq | 8061663600.0 | 26872212.0 | darktreated4.read1.fastq.gz | 0:150 1:150 | A:2171664867;C:1853256385;G:1909447014;T:2127248788;N:46546 | 150 | 150 | 2171664867 | 1853256385 | 1909447014 | 2127248788 | 46546 | SRX27475155 | SRS23899205 | SRA2060897 | zhujiang hospital|ophthalmology | zhujiang hospital | B | B | biological fallback assumption | illumina | novaseq_era | unknown | random_priming | unknown | bulk | unknown | unknown | China | 2025-01-25 | Undetermined | Adult | Undetermined | Undetermined | ||||||||||||||||||||||||||||||||
| 34600 | 34600 | SRR32128864 | SRX27475154 | SRS23899204 | SRP559934 | PRJNA1215774 | 3 mpf dark reared zebrafish eye RNA sequencing | PRJNA1215774 | Other | Outdoor time and light intensity are important emerging factors affecting myopia; however the underlying mechanisms remain unknown. To clarify the possible molecular mechanisms underlying myopia caused by dark environment 3 mpf zebrafish eye RNA sequencing was performed. | darktreated3 | strain:not applicable|isolate:Sun Yat sen University|breed:not applicable3|cultivar:not applicable|ecotype:not applicable|age:not applicable|dev stage:not applicable3|collection date:2021 04 16|geo loc name:China: GuangZhou|sex:not applicable|tissue:zebrafish3|isolation source:zebrafish3|BioSampleModel:Model organism or animal | sample info | library 3 | library 3 | DNA barcode3 | WXS | TRANSCRIPTOMIC | PCR | PAIRED | ILLUMINA | Illumina NovaSeq 6000 | SRP559934 | darktreated3.read1.fastq.gz darktreated3.read2.fastq.gz | fastq fastq | 8287650300.0 | 27625501.0 | darktreated3.read1.fastq.gz | 0:150 1:150 | A:2231337901;C:1902488349;G:1971440974;T:2182335741;N:47335 | 150 | 150 | 2231337901 | 1902488349 | 1971440974 | 2182335741 | 47335 | SRX27475154 | SRS23899204 | SRA2060897 | zhujiang hospital|ophthalmology | zhujiang hospital | B | B | biological fallback assumption | illumina | novaseq_era | unknown | random_priming | unknown | bulk | unknown | unknown | China | 2025-01-25 | Undetermined | Adult | Undetermined | Undetermined | ||||||||||||||||||||||||||||||||
| 34601 | 34601 | SRR32128865 | SRX27475153 | SRS23899203 | SRP559934 | PRJNA1215774 | 3 mpf dark reared zebrafish eye RNA sequencing | PRJNA1215774 | Other | Outdoor time and light intensity are important emerging factors affecting myopia; however the underlying mechanisms remain unknown. To clarify the possible molecular mechanisms underlying myopia caused by dark environment 3 mpf zebrafish eye RNA sequencing was performed. | lighttreated6 | strain:not applicable|isolate:Sun Yat sen University|breed:not applicable12|cultivar:not applicable|ecotype:not applicable|age:not applicable|dev stage:not applicable12|collection date:2021 04 16|geo loc name:China: GuangZhou|sex:not applicable|tissue:zebrafish12|isolation source:zebrafish12|BioSampleModel:Model organism or animal | sample info | library 12 | library 12 | DNA barcode12 | WXS | TRANSCRIPTOMIC | PCR | PAIRED | ILLUMINA | Illumina NovaSeq 6000 | SRP559934 | lighttreated6.read1.fastq.gz lighttreated6.read2.fastq.gz | fastq fastq | 7610579400.0 | 25368598.0 | lighttreated6.read1.fastq.gz | 0:150 1:150 | A:2063115765;C:1733106391;G:1795336188;T:2018975316;N:45740 | 150 | 150 | 2063115765 | 1733106391 | 1795336188 | 2018975316 | 45740 | SRX27475153 | SRS23899203 | SRA2060897 | zhujiang hospital|ophthalmology | zhujiang hospital | B | B | biological fallback assumption | illumina | novaseq_era | unknown | random_priming | unknown | bulk | unknown | unknown | China | 2025-01-25 | Undetermined | Adult | Undetermined | Undetermined | ||||||||||||||||||||||||||||||||
| 34602 | 34602 | SRR32128866 | SRX27475152 | SRS23899202 | SRP559934 | PRJNA1215774 | 3 mpf dark reared zebrafish eye RNA sequencing | PRJNA1215774 | Other | Outdoor time and light intensity are important emerging factors affecting myopia; however the underlying mechanisms remain unknown. To clarify the possible molecular mechanisms underlying myopia caused by dark environment 3 mpf zebrafish eye RNA sequencing was performed. | lighttreated5 | strain:not applicable|isolate:Sun Yat sen University|breed:not applicable11|cultivar:not applicable|ecotype:not applicable|age:not applicable|dev stage:not applicable11|collection date:2021 04 16|geo loc name:China: GuangZhou|sex:not applicable|tissue:zebrafish11|isolation source:zebrafish11|BioSampleModel:Model organism or animal | sample info | library 11 | library 11 | DNA barcode11 | WXS | TRANSCRIPTOMIC | PCR | PAIRED | ILLUMINA | Illumina NovaSeq 6000 | SRP559934 | lighttreated5.read1.fastq.gz lighttreated5.read2.fastq.gz | fastq fastq | 6677234100.0 | 22257447.0 | lighttreated5.read1.fastq.gz | 0:150 1:150 | A:1812295746;C:1506030273;G:1585674870;T:1773195250;N:37961 | 150 | 150 | 1812295746 | 1506030273 | 1585674870 | 1773195250 | 37961 | SRX27475152 | SRS23899202 | SRA2060897 | zhujiang hospital|ophthalmology | zhujiang hospital | B | B | biological fallback assumption | illumina | novaseq_era | unknown | random_priming | unknown | bulk | unknown | unknown | China | 2025-01-25 | Undetermined | Adult | Undetermined | Undetermined | ||||||||||||||||||||||||||||||||
| 34603 | 34603 | SRR32128867 | SRX27475151 | SRS23899201 | SRP559934 | PRJNA1215774 | 3 mpf dark reared zebrafish eye RNA sequencing | PRJNA1215774 | Other | Outdoor time and light intensity are important emerging factors affecting myopia; however the underlying mechanisms remain unknown. To clarify the possible molecular mechanisms underlying myopia caused by dark environment 3 mpf zebrafish eye RNA sequencing was performed. | darktreated2 | strain:not applicable|isolate:Sun Yat sen University|breed:not applicable2|cultivar:not applicable|ecotype:not applicable|age:not applicable|dev stage:not applicable2|collection date:2021 04 16|geo loc name:China: GuangZhou|sex:not applicable|tissue:zebrafish2|isolation source:zebrafish2|BioSampleModel:Model organism or animal | sample info | library 2 | library 2 | DNA barcode2 | WXS | TRANSCRIPTOMIC | PCR | PAIRED | ILLUMINA | Illumina NovaSeq 6000 | SRP559934 | darktreated2.read1.fastq.gz darktreated2.read2.fastq.gz | fastq fastq | 8723972700.0 | 29079909.0 | darktreated2.read1.fastq.gz | 0:150 1:150 | A:2341340036;C:2009282478;G:2082163796;T:2291135873;N:50517 | 150 | 150 | 2341340036 | 2009282478 | 2082163796 | 2291135873 | 50517 | SRX27475151 | SRS23899201 | SRA2060897 | zhujiang hospital|ophthalmology | zhujiang hospital | B | B | biological fallback assumption | illumina | novaseq_era | unknown | random_priming | unknown | bulk | unknown | unknown | China | 2025-01-25 | Undetermined | Adult | Undetermined | Undetermined | ||||||||||||||||||||||||||||||||
| 34604 | 34604 | SRR32128868 | SRX27475150 | SRS23899200 | SRP559934 | PRJNA1215774 | 3 mpf dark reared zebrafish eye RNA sequencing | PRJNA1215774 | Other | Outdoor time and light intensity are important emerging factors affecting myopia; however the underlying mechanisms remain unknown. To clarify the possible molecular mechanisms underlying myopia caused by dark environment 3 mpf zebrafish eye RNA sequencing was performed. | darktreated1 | strain:not applicable|isolate:Sun Yat sen University|breed:not applicable1|cultivar:not applicable|ecotype:not applicable|age:not applicable|dev stage:not applicable1|collection date:2021 04 16|geo loc name:China: GuangZhou|sex:not applicable|tissue:zebrafish1|isolation source:zebrafish1|BioSampleModel:Model organism or animal | sample info | library 1 | library 1 | DNA barcode1 | WXS | TRANSCRIPTOMIC | PCR | PAIRED | ILLUMINA | Illumina NovaSeq 6000 | SRP559934 | darktreated1.read1.fastq.gz darktreated1.read2.fastq.gz | fastq fastq | 7940928300.0 | 26469761.0 | darktreated1.read1.fastq.gz | 0:150 1:150 | A:2133717650;C:1824526059;G:1895330033;T:2087310578;N:43980 | 150 | 150 | 2133717650 | 1824526059 | 1895330033 | 2087310578 | 43980 | SRX27475150 | SRS23899200 | SRA2060897 | zhujiang hospital|ophthalmology | zhujiang hospital | B | B | biological fallback assumption | illumina | novaseq_era | unknown | random_priming | unknown | bulk | unknown | unknown | China | 2025-01-25 | Undetermined | Adult | Undetermined | Undetermined |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE run_metadata("run.accession" VARCHAR, "experiment.accession" VARCHAR, "sample.accession" VARCHAR, "study.accession" VARCHAR, bioproject VARCHAR, "study.title" VARCHAR, "study.alias" VARCHAR, "study.type" VARCHAR, "study.abstract" VARCHAR, "study.attributes" VARCHAR, "study.PMIDs" VARCHAR, "sample.description" VARCHAR, "sample.title" VARCHAR, "sample.alias" VARCHAR, "sample.centername" VARCHAR, "sample.attributes" VARCHAR, "GEOsample.title" VARCHAR, "GEOsample.dataprocessing" VARCHAR, "GEOsample.source" VARCHAR, "GEOsample.treatmentprotocol" VARCHAR, "GEOsample.extractprotocol" VARCHAR, "GEOsample.growthprotocol" VARCHAR, "GEOsample.characteristics" VARCHAR, "GEOsample.accession" VARCHAR, "experiment.title" VARCHAR, "experiment.alias" VARCHAR, "experiment.library_name" VARCHAR, "experiment.design_description" VARCHAR, "experiment.library_construction_protocol" VARCHAR, "experiment.attributes" VARCHAR, "experiment.library_strategy" VARCHAR, "experiment.library_source" VARCHAR, "experiment.library_selection" VARCHAR, "experiment.library_layout" VARCHAR, "experiment.platform" VARCHAR, "experiment.instrument_model" VARCHAR, "experiment.spot_descriptor" VARCHAR, "experiment.study_ref" VARCHAR, "run.title" VARCHAR, "run.attributes" VARCHAR, "run.filename" VARCHAR, "run.semantic_name" VARCHAR, "run.total_bases" DOUBLE, "run.total_spots" DOUBLE, "run.alias" VARCHAR, "run.read_lengths" VARCHAR, "run.base_counts" VARCHAR, "run.r1_length" BIGINT, "run.r2_length" BIGINT, "run.r3_length" BIGINT, "run.r4_length" BIGINT, "run.Acount" BIGINT, "run.Ccount" BIGINT, "run.Gcount" BIGINT, "run.Tcount" BIGINT, "run.Ncount" BIGINT, "run.experiment" VARCHAR, "run.pool_member" VARCHAR, "submission.accession" VARCHAR, "submission.srasource" VARCHAR, "submission.bioprojectsource" VARCHAR, "seqdetective.n_mates" BIGINT, "seqdetective.mapping_rate.mate1" DOUBLE, "seqdetective.mapping_rate.mate2" DOUBLE, "seqdetective.nofeature_rate.mate1" DOUBLE, "seqdetective.nofeature_rate.mate2" DOUBLE, "seqdetective.sparsity.mate1" DOUBLE, "seqdetective.sparsity.mate2" DOUBLE, "seqdetective.pos_strand_rate.mate1" DOUBLE, "seqdetective.pos_strand_rate.mate2" DOUBLE, "seqdetective.readlen.mate1" BIGINT, "seqdetective.readlen.mate2" BIGINT, "seqdetective.judgement.mate1" VARCHAR, "seqdetective.judgement.mate2" VARCHAR, "seqdetective.judgement.reason" VARCHAR, platform_family VARCHAR, instrument_generation VARCHAR, read_bias VARCHAR, selection_class VARCHAR, prep_kit VARCHAR, sc_or_bulk VARCHAR, tech_class VARCHAR, technology VARCHAR, tech_variant VARCHAR, "submission.bioprojectsource.country" VARCHAR, earliest_date DATE, devstage_curation VARCHAR, devstage_curation_coarse VARCHAR, tissue_curation VARCHAR, tissue_curation_coarse VARCHAR);;
CREATE INDEX idx_run_bioproject ON run_metadata(bioproject);;
CREATE INDEX idx_run_run_accession ON run_metadata("run.accession");;