run_metadata
9 rows where experiment.library_selection = "Oligo-dT", experiment.platform = "BGISEQ" and tissue_curation_coarse = "Reproductive System"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 74160 | 74160 | SRR23576624 | SRX19463433 | SRS16856056 | SRP423783 | PRJNA937311 | Telomere elongation in the gut extends systemic healthspan of zebrafish | PRJNA937311 | Other | Telomere shortening is a hallmark of aging and is counteracted by telomerase. zebrafish gut is one of the organs with the fastest rate of telomere decline. However whether telomere dependent aging of an individual organ the gut causes systemic aging remains unknown. Here we show that preventing telomere shortening in the gut through tissue specific telomerase expression rescues premature aging of tert / . Conclusively we show that gut specific telomerase expression extends lifespan of tert / by 40 % while ameliorating natural aging. Our work demonstrates that delaying telomere shortening in the gut is sufficient to systemically counteract aging in zebrafish. | T1B | strain:AB|age:9 month|dev stage:adulte|sex:male|tissue:testis|biomaterial provider:EL MAI Mounir|birth date:2019/11/20|birth location:Nice France|treatment:testis tert no Cre R1|BioSampleModel:Model organism or animal | RNA Seq of Danio rerio : adult male testis | T1B | T1B | RNA Seq of Danio rerio : adult male testis | RNA-Seq | TRANSCRIPTOMIC | Oligo-dT | PAIRED | BGISEQ | BGISEQ-500 | SRP423783 | T1B_1.fq.gz T1B_2.fq.gz | fastq fastq | 12301883400.0 | 123018834.0 | T1B 1.fq.gz | 0:100 1:100 | A:3241228917;C:2853095411;G:2904960052;T:3302599020;N:0 | 100 | 100 | 3241228917 | 2853095411 | 2904960052 | 3302599020 | 0 | SRX19463433 | SRS16856056 | SRA1593824 | Sun Yat-sen University Cancer Center|State Key Laboratory of Oncology in South China | Sun Yat-sen University Cancer Center Miguel Godinho Ferreira | 1 | 0.95272 | 0.09396 | 0.68469 | 0.54489 | 100 | B | usable mapping rate | bgi | bgi | unknown | poly_a | unknown | bulk | unknown | unknown | China | 2023-02-21 | Adult | Adult | Gonad | Reproductive System | |||||||||||||||||||||||||||
| 74177 | 74177 | SRR23576641 | SRX19463416 | SRS16856039 | SRP423783 | PRJNA937311 | Telomere elongation in the gut extends systemic healthspan of zebrafish | PRJNA937311 | Other | Telomere shortening is a hallmark of aging and is counteracted by telomerase. zebrafish gut is one of the organs with the fastest rate of telomere decline. However whether telomere dependent aging of an individual organ the gut causes systemic aging remains unknown. Here we show that preventing telomere shortening in the gut through tissue specific telomerase expression rescues premature aging of tert / . Conclusively we show that gut specific telomerase expression extends lifespan of tert / by 40 % while ameliorating natural aging. Our work demonstrates that delaying telomere shortening in the gut is sufficient to systemically counteract aging in zebrafish. | T9 | strain:AB|age:9 month|dev stage:adulte|sex:male|tissue:testis|biomaterial provider:EL MAI Mounir|birth date:2019/11/20|birth location:Nice France|treatment:testis WT R3|BioSampleModel:Model organism or animal | RNA Seq of Danio rerio : adult male testis | T9 | T9 | RNA Seq of Danio rerio : adult male testis | RNA-Seq | TRANSCRIPTOMIC | Oligo-dT | PAIRED | BGISEQ | BGISEQ-500 | SRP423783 | T9_1.fq.gz T9_2.fq.gz | fastq fastq | 12386772800.0 | 123867728.0 | T9 1.fq.gz | 0:100 1:100 | A:3400599530;C:2772066139;G:2813890387;T:3400216744;N:0 | 100 | 100 | 3400599530 | 2772066139 | 2813890387 | 3400216744 | 0 | SRX19463416 | SRS16856039 | SRA1593824 | Sun Yat-sen University Cancer Center|State Key Laboratory of Oncology in South China | Sun Yat-sen University Cancer Center Miguel Godinho Ferreira | 1 | 0.93775 | 0.12024 | 0.63838 | 0.49765 | 100 | B | usable mapping rate | bgi | bgi | unknown | poly_a | unknown | bulk | unknown | unknown | China | 2023-02-21 | Adult | Adult | Gonad | Reproductive System | |||||||||||||||||||||||||||
| 74178 | 74178 | SRR23576642 | SRX19463415 | SRS16856037 | SRP423783 | PRJNA937311 | Telomere elongation in the gut extends systemic healthspan of zebrafish | PRJNA937311 | Other | Telomere shortening is a hallmark of aging and is counteracted by telomerase. zebrafish gut is one of the organs with the fastest rate of telomere decline. However whether telomere dependent aging of an individual organ the gut causes systemic aging remains unknown. Here we show that preventing telomere shortening in the gut through tissue specific telomerase expression rescues premature aging of tert / . Conclusively we show that gut specific telomerase expression extends lifespan of tert / by 40 % while ameliorating natural aging. Our work demonstrates that delaying telomere shortening in the gut is sufficient to systemically counteract aging in zebrafish. | T8 | strain:AB|age:9 month|dev stage:adulte|sex:male|tissue:testis|biomaterial provider:EL MAI Mounir|birth date:2019/11/20|birth location:Nice France|treatment:testis WT R2|BioSampleModel:Model organism or animal | RNA Seq of Danio rerio : adult male testis | T8 | T8 | RNA Seq of Danio rerio : adult male testis | RNA-Seq | TRANSCRIPTOMIC | Oligo-dT | PAIRED | BGISEQ | BGISEQ-500 | SRP423783 | T8_1.fq.gz T8_2.fq.gz | fastq fastq | 12176715600.0 | 121767156.0 | T8 1.fq.gz | 0:100 1:100 | A:3287270041;C:2775700062;G:2808469679;T:3305275818;N:0 | 100 | 100 | 3287270041 | 2775700062 | 2808469679 | 3305275818 | 0 | SRX19463415 | SRS16856037 | SRA1593824 | Sun Yat-sen University Cancer Center|State Key Laboratory of Oncology in South China | Sun Yat-sen University Cancer Center Miguel Godinho Ferreira | 1 | 0.94261 | 0.12625 | 0.63838 | 0.49901 | 100 | B | usable mapping rate | bgi | bgi | unknown | poly_a | unknown | bulk | unknown | unknown | China | 2023-02-21 | Adult | Adult | Gonad | Reproductive System | |||||||||||||||||||||||||||
| 74179 | 74179 | SRR23576643 | SRX19463414 | SRS16856038 | SRP423783 | PRJNA937311 | Telomere elongation in the gut extends systemic healthspan of zebrafish | PRJNA937311 | Other | Telomere shortening is a hallmark of aging and is counteracted by telomerase. zebrafish gut is one of the organs with the fastest rate of telomere decline. However whether telomere dependent aging of an individual organ the gut causes systemic aging remains unknown. Here we show that preventing telomere shortening in the gut through tissue specific telomerase expression rescues premature aging of tert / . Conclusively we show that gut specific telomerase expression extends lifespan of tert / by 40 % while ameliorating natural aging. Our work demonstrates that delaying telomere shortening in the gut is sufficient to systemically counteract aging in zebrafish. | T7 | strain:AB|age:9 month|dev stage:adulte|sex:male|tissue:testis|biomaterial provider:EL MAI Mounir|birth date:2019/11/20|birth location:Nice France|treatment:testis WT R1|BioSampleModel:Model organism or animal | RNA Seq of Danio rerio : adult male testis | T7 | T7 | RNA Seq of Danio rerio : adult male testis | RNA-Seq | TRANSCRIPTOMIC | Oligo-dT | PAIRED | BGISEQ | BGISEQ-500 | SRP423783 | T7_1.fq.gz T7_2.fq.gz | fastq fastq | 12172655600.0 | 121726556.0 | T7 1.fq.gz | 0:100 1:100 | A:3248593263;C:2809119242;G:2855399333;T:3259543762;N:0 | 100 | 100 | 3248593263 | 2809119242 | 2855399333 | 3259543762 | 0 | SRX19463414 | SRS16856038 | SRA1593824 | Sun Yat-sen University Cancer Center|State Key Laboratory of Oncology in South China | Sun Yat-sen University Cancer Center Miguel Godinho Ferreira | 1 | 0.94602 | 0.10229 | 0.63603 | 0.48805 | 100 | B | usable mapping rate | bgi | bgi | unknown | poly_a | unknown | bulk | unknown | unknown | China | 2023-02-21 | Adult | Adult | Gonad | Reproductive System | |||||||||||||||||||||||||||
| 74180 | 74180 | SRR23576644 | SRX19463413 | SRS16856036 | SRP423783 | PRJNA937311 | Telomere elongation in the gut extends systemic healthspan of zebrafish | PRJNA937311 | Other | Telomere shortening is a hallmark of aging and is counteracted by telomerase. zebrafish gut is one of the organs with the fastest rate of telomere decline. However whether telomere dependent aging of an individual organ the gut causes systemic aging remains unknown. Here we show that preventing telomere shortening in the gut through tissue specific telomerase expression rescues premature aging of tert / . Conclusively we show that gut specific telomerase expression extends lifespan of tert / by 40 % while ameliorating natural aging. Our work demonstrates that delaying telomere shortening in the gut is sufficient to systemically counteract aging in zebrafish. | T6 | strain:AB|age:9 month|dev stage:adulte|sex:male|tissue:testis|biomaterial provider:EL MAI Mounir|birth date:2019/11/20|birth location:Nice France|treatment:testis tert Cre R3|BioSampleModel:Model organism or animal | RNA Seq of Danio rerio : adult male testis | T6 | T6 | RNA Seq of Danio rerio : adult male testis | RNA-Seq | TRANSCRIPTOMIC | Oligo-dT | PAIRED | BGISEQ | BGISEQ-500 | SRP423783 | T6_1.fq.gz T6_2.fq.gz | fastq fastq | 12378860000.0 | 123788600.0 | T6 1.fq.gz | 0:100 1:100 | A:3314969512;C:2848487369;G:2903637904;T:3311765215;N:0 | 100 | 100 | 3314969512 | 2848487369 | 2903637904 | 3311765215 | 0 | SRX19463413 | SRS16856036 | SRA1593824 | Sun Yat-sen University Cancer Center|State Key Laboratory of Oncology in South China | Sun Yat-sen University Cancer Center Miguel Godinho Ferreira | 1 | 0.94452 | 0.10777 | 0.62422 | 0.49742 | 100 | B | usable mapping rate | bgi | bgi | unknown | poly_a | unknown | bulk | unknown | unknown | China | 2023-02-21 | Adult | Adult | Gonad | Reproductive System | |||||||||||||||||||||||||||
| 74181 | 74181 | SRR23576645 | SRX19463412 | SRS16856034 | SRP423783 | PRJNA937311 | Telomere elongation in the gut extends systemic healthspan of zebrafish | PRJNA937311 | Other | Telomere shortening is a hallmark of aging and is counteracted by telomerase. zebrafish gut is one of the organs with the fastest rate of telomere decline. However whether telomere dependent aging of an individual organ the gut causes systemic aging remains unknown. Here we show that preventing telomere shortening in the gut through tissue specific telomerase expression rescues premature aging of tert / . Conclusively we show that gut specific telomerase expression extends lifespan of tert / by 40 % while ameliorating natural aging. Our work demonstrates that delaying telomere shortening in the gut is sufficient to systemically counteract aging in zebrafish. | T5 | strain:AB|age:9 month|dev stage:adulte|sex:male|tissue:testis|biomaterial provider:EL MAI Mounir|birth date:2019/11/20|birth location:Nice France|treatment:testis tert Cre R2|BioSampleModel:Model organism or animal | RNA Seq of Danio rerio : adult male testis | T5 | T5 | RNA Seq of Danio rerio : adult male testis | RNA-Seq | TRANSCRIPTOMIC | Oligo-dT | PAIRED | BGISEQ | BGISEQ-500 | SRP423783 | T5_1.fq.gz T5_2.fq.gz | fastq fastq | 12128636200.0 | 121286362.0 | T5 1.fq.gz | 0:100 1:100 | A:3365971947;C:2671909728;G:2726788212;T:3363966313;N:0 | 100 | 100 | 3365971947 | 2671909728 | 2726788212 | 3363966313 | 0 | SRX19463412 | SRS16856034 | SRA1593824 | Sun Yat-sen University Cancer Center|State Key Laboratory of Oncology in South China | Sun Yat-sen University Cancer Center Miguel Godinho Ferreira | 1 | 0.93852 | 0.14946 | 0.63747 | 0.52613 | 100 | B | usable mapping rate | bgi | bgi | unknown | poly_a | unknown | bulk | unknown | unknown | China | 2023-02-21 | Adult | Adult | Gonad | Reproductive System | |||||||||||||||||||||||||||
| 74182 | 74182 | SRR23576646 | SRX19463411 | SRS16856032 | SRP423783 | PRJNA937311 | Telomere elongation in the gut extends systemic healthspan of zebrafish | PRJNA937311 | Other | Telomere shortening is a hallmark of aging and is counteracted by telomerase. zebrafish gut is one of the organs with the fastest rate of telomere decline. However whether telomere dependent aging of an individual organ the gut causes systemic aging remains unknown. Here we show that preventing telomere shortening in the gut through tissue specific telomerase expression rescues premature aging of tert / . Conclusively we show that gut specific telomerase expression extends lifespan of tert / by 40 % while ameliorating natural aging. Our work demonstrates that delaying telomere shortening in the gut is sufficient to systemically counteract aging in zebrafish. | T4 | strain:AB|age:9 month|dev stage:adulte|sex:male|tissue:testis|biomaterial provider:EL MAI Mounir|birth date:2019/11/20|birth location:Nice France|treatment:testis tert Cre R1|BioSampleModel:Model organism or animal | RNA Seq of Danio rerio : adult male testis | T4 | T4 | RNA Seq of Danio rerio : adult male testis | RNA-Seq | TRANSCRIPTOMIC | Oligo-dT | PAIRED | BGISEQ | BGISEQ-500 | SRP423783 | T4_1.fq.gz T4_2.fq.gz | fastq fastq | 12162901400.0 | 121629014.0 | T4 1.fq.gz | 0:100 1:100 | A:3278648055;C:2767244505;G:2825703918;T:3291304922;N:0 | 100 | 100 | 3278648055 | 2767244505 | 2825703918 | 3291304922 | 0 | SRX19463411 | SRS16856032 | SRA1593824 | Sun Yat-sen University Cancer Center|State Key Laboratory of Oncology in South China | Sun Yat-sen University Cancer Center Miguel Godinho Ferreira | 1 | 0.94511 | 0.11642 | 0.63258 | 0.4913 | 100 | B | usable mapping rate | bgi | bgi | unknown | poly_a | unknown | bulk | unknown | unknown | China | 2023-02-21 | Adult | Adult | Gonad | Reproductive System | |||||||||||||||||||||||||||
| 74183 | 74183 | SRR23576647 | SRX19463410 | SRS16856035 | SRP423783 | PRJNA937311 | Telomere elongation in the gut extends systemic healthspan of zebrafish | PRJNA937311 | Other | Telomere shortening is a hallmark of aging and is counteracted by telomerase. zebrafish gut is one of the organs with the fastest rate of telomere decline. However whether telomere dependent aging of an individual organ the gut causes systemic aging remains unknown. Here we show that preventing telomere shortening in the gut through tissue specific telomerase expression rescues premature aging of tert / . Conclusively we show that gut specific telomerase expression extends lifespan of tert / by 40 % while ameliorating natural aging. Our work demonstrates that delaying telomere shortening in the gut is sufficient to systemically counteract aging in zebrafish. | T3 | strain:AB|age:9 month|dev stage:adulte|sex:male|tissue:testis|biomaterial provider:EL MAI Mounir|birth date:2019/11/20|birth location:Nice France|treatment:testis tert no Cre R3|BioSampleModel:Model organism or animal | RNA Seq of Danio rerio : adult male testis | T3 | T3 | RNA Seq of Danio rerio : adult male testis | RNA-Seq | TRANSCRIPTOMIC | Oligo-dT | PAIRED | BGISEQ | BGISEQ-500 | SRP423783 | T3_1.fq.gz T3_2.fq.gz | fastq fastq | 12163321600.0 | 121633216.0 | T3 1.fq.gz | 0:100 1:100 | A:3285334843;C:2767357208;G:2816394061;T:3294235488;N:0 | 100 | 100 | 3285334843 | 2767357208 | 2816394061 | 3294235488 | 0 | SRX19463410 | SRS16856035 | SRA1593824 | Sun Yat-sen University Cancer Center|State Key Laboratory of Oncology in South China | Sun Yat-sen University Cancer Center Miguel Godinho Ferreira | 1 | 0.9415 | 0.11969 | 0.62666 | 0.50292 | 100 | B | usable mapping rate | bgi | bgi | unknown | poly_a | unknown | bulk | unknown | unknown | China | 2023-02-21 | Adult | Adult | Gonad | Reproductive System | |||||||||||||||||||||||||||
| 74184 | 74184 | SRR23576648 | SRX19463409 | SRS16856033 | SRP423783 | PRJNA937311 | Telomere elongation in the gut extends systemic healthspan of zebrafish | PRJNA937311 | Other | Telomere shortening is a hallmark of aging and is counteracted by telomerase. zebrafish gut is one of the organs with the fastest rate of telomere decline. However whether telomere dependent aging of an individual organ the gut causes systemic aging remains unknown. Here we show that preventing telomere shortening in the gut through tissue specific telomerase expression rescues premature aging of tert / . Conclusively we show that gut specific telomerase expression extends lifespan of tert / by 40 % while ameliorating natural aging. Our work demonstrates that delaying telomere shortening in the gut is sufficient to systemically counteract aging in zebrafish. | T2B | strain:AB|age:9 month|dev stage:adulte|sex:male|tissue:testis|biomaterial provider:EL MAI Mounir|birth date:2019/11/20|birth location:Nice France|treatment:testis tert no Cre R2|BioSampleModel:Model organism or animal | RNA Seq of Danio rerio : adult male testis | T2B | T2B | RNA Seq of Danio rerio : adult male testis | RNA-Seq | TRANSCRIPTOMIC | Oligo-dT | PAIRED | BGISEQ | BGISEQ-500 | SRP423783 | T2B_1.fq.gz T2B_2.fq.gz | fastq fastq | 12317978600.0 | 123179786.0 | T2B 1.fq.gz | 0:100 1:100 | A:3182137355;C:2913584264;G:2974241242;T:3248015739;N:0 | 100 | 100 | 3182137355 | 2913584264 | 2974241242 | 3248015739 | 0 | SRX19463409 | SRS16856033 | SRA1593824 | Sun Yat-sen University Cancer Center|State Key Laboratory of Oncology in South China | Sun Yat-sen University Cancer Center Miguel Godinho Ferreira | 1 | 0.95364 | 0.08029 | 0.6882 | 0.53887 | 100 | B | usable mapping rate | bgi | bgi | unknown | poly_a | unknown | bulk | unknown | unknown | China | 2023-02-21 | Adult | Adult | Gonad | Reproductive System |
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");;