run_metadata
9 rows where experiment.library_selection = "Oligo-dT", technology = "unknown" and tissue_curation_coarse = "Renal 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 74167 | 74167 | SRR23576631 | SRX19463426 | SRS16856050 | 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. | K9 | strain:AB|age:9 month|dev stage:adulte|sex:male|tissue:kidney marrow|biomaterial provider:EL MAI Mounir|birth date:2019/11/20|birth location:Nice France|treatment:kidneymarrow WT R3|BioSampleModel:Model organism or animal | RNA Seq of Danio rerio : adult male kidney marrow | K9 | K9 | RNA Seq of Danio rerio : adult male kidney marrow | RNA-Seq | TRANSCRIPTOMIC | Oligo-dT | PAIRED | BGISEQ | BGISEQ-500 | SRP423783 | k9_1.fq.gz k9_2.fq.gz | fastq fastq | 12170484800.0 | 121704848.0 | k9 1.fq.gz | 0:100 1:100 | A:3429398396;C:2639165188;G:2664600070;T:3437321146;N:0 | 100 | 100 | 3429398396 | 2639165188 | 2664600070 | 3437321146 | 0 | SRX19463426 | SRS16856050 | 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.93913 | 0.13619 | 0.76623 | 0.63929 | 100 | B | usable mapping rate | bgi | bgi | unknown | poly_a | unknown | bulk | unknown | unknown | China | 2023-02-21 | Adult | Adult | Kidney | Renal System | |||||||||||||||||||||||||||
| 74168 | 74168 | SRR23576632 | SRX19463425 | SRS16856047 | 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. | K8 | strain:AB|age:9 month|dev stage:adulte|sex:male|tissue:kidney marrow|biomaterial provider:EL MAI Mounir|birth date:2019/11/20|birth location:Nice France|treatment:kidneymarrow WT R2|BioSampleModel:Model organism or animal | RNA Seq of Danio rerio : adult male kidney marrow | K8 | K8 | RNA Seq of Danio rerio : adult male kidney marrow | RNA-Seq | TRANSCRIPTOMIC | Oligo-dT | PAIRED | BGISEQ | BGISEQ-500 | SRP423783 | k8_1.fq.gz k8_2.fq.gz | fastq fastq | 12160185000.0 | 121601850.0 | k8 1.fq.gz | 0:100 1:100 | A:3416677165;C:2642321577;G:2671959016;T:3429227242;N:0 | 100 | 100 | 3416677165 | 2642321577 | 2671959016 | 3429227242 | 0 | SRX19463425 | SRS16856047 | 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.94207 | 0.13408 | 0.76211 | 0.63866 | 100 | B | usable mapping rate | bgi | bgi | unknown | poly_a | unknown | bulk | unknown | unknown | China | 2023-02-21 | Adult | Adult | Kidney | Renal System | |||||||||||||||||||||||||||
| 74169 | 74169 | SRR23576633 | SRX19463424 | SRS16856049 | 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. | K7 | strain:AB|age:9 month|dev stage:adulte|sex:male|tissue:kidney marrow|biomaterial provider:EL MAI Mounir|birth date:2019/11/20|birth location:Nice France|treatment:kidneymarrow WT R1|BioSampleModel:Model organism or animal | RNA Seq of Danio rerio : adult male kidney marrow | K7 | K7 | RNA Seq of Danio rerio : adult male kidney marrow | RNA-Seq | TRANSCRIPTOMIC | Oligo-dT | PAIRED | BGISEQ | BGISEQ-500 | SRP423783 | k7_1.fq.gz k7_2.fq.gz | fastq fastq | 12148090800.0 | 121480908.0 | k7 1.fq.gz | 0:100 1:100 | A:3393484862;C:2656728106;G:2695881495;T:3401996337;N:0 | 100 | 100 | 3393484862 | 2656728106 | 2695881495 | 3401996337 | 0 | SRX19463424 | SRS16856049 | 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.93783 | 0.12581 | 0.76205 | 0.61561 | 100 | B | usable mapping rate | bgi | bgi | unknown | poly_a | unknown | bulk | unknown | unknown | China | 2023-02-21 | Adult | Adult | Kidney | Renal System | |||||||||||||||||||||||||||
| 74170 | 74170 | SRR23576634 | SRX19463423 | SRS16856046 | 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. | K6 | strain:AB|age:9 month|dev stage:adulte|sex:male|tissue:kidney marrow|biomaterial provider:EL MAI Mounir|birth date:2019/11/20|birth location:Nice France|treatment:kidneymarrow tert Cre R3|BioSampleModel:Model organism or animal | RNA Seq of Danio rerio : adult male kidney marrow | K6 | K6 | RNA Seq of Danio rerio : adult male kidney marrow | RNA-Seq | TRANSCRIPTOMIC | Oligo-dT | PAIRED | BGISEQ | BGISEQ-500 | SRP423783 | k6_1.fq.gz k6_2.fq.gz | fastq fastq | 12173062600.0 | 121730626.0 | k6 1.fq.gz | 0:100 1:100 | A:3357618903;C:2705746086;G:2734807941;T:3374889670;N:0 | 100 | 100 | 3357618903 | 2705746086 | 2734807941 | 3374889670 | 0 | SRX19463423 | SRS16856046 | 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.94651 | 0.13977 | 0.76575 | 0.62959 | 100 | B | usable mapping rate | bgi | bgi | unknown | poly_a | unknown | bulk | unknown | unknown | China | 2023-02-21 | Adult | Adult | Kidney | Renal System | |||||||||||||||||||||||||||
| 74171 | 74171 | SRR23576635 | SRX19463422 | SRS16856045 | 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. | K5 | strain:AB|age:9 month|dev stage:adulte|sex:male|tissue:kidney marrow|biomaterial provider:EL MAI Mounir|birth date:2019/11/20|birth location:Nice France|treatment:kidneymarrow tert Cre R2|BioSampleModel:Model organism or animal | RNA Seq of Danio rerio : adult male kidney marrow | K5 | K5 | RNA Seq of Danio rerio : adult male kidney marrow | RNA-Seq | TRANSCRIPTOMIC | Oligo-dT | PAIRED | BGISEQ | BGISEQ-500 | SRP423783 | k5_1.fq.gz k5_2.fq.gz | fastq fastq | 12151346800.0 | 121513468.0 | k5 1.fq.gz | 0:100 1:100 | A:3323730498;C:2725613099;G:2760112468;T:3341890735;N:0 | 100 | 100 | 3323730498 | 2725613099 | 2760112468 | 3341890735 | 0 | SRX19463422 | SRS16856045 | 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.94297 | 0.12142 | 0.75836 | 0.6001 | 100 | B | usable mapping rate | bgi | bgi | unknown | poly_a | unknown | bulk | unknown | unknown | China | 2023-02-21 | Adult | Adult | Kidney | Renal System | |||||||||||||||||||||||||||
| 74172 | 74172 | SRR23576636 | SRX19463421 | SRS16856044 | 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. | K4 | strain:AB|age:9 month|dev stage:adulte|sex:male|tissue:kidney marrow|biomaterial provider:EL MAI Mounir|birth date:2019/11/20|birth location:Nice France|treatment:kidneymarrow tert Cre R1|BioSampleModel:Model organism or animal | RNA Seq of Danio rerio : adult male kidney marrow | K4 | K4 | RNA Seq of Danio rerio : adult male kidney marrow | RNA-Seq | TRANSCRIPTOMIC | Oligo-dT | PAIRED | BGISEQ | BGISEQ-500 | SRP423783 | k4_1.fq.gz k4_2.fq.gz | fastq fastq | 12130512600.0 | 121305126.0 | k4 1.fq.gz | 0:100 1:100 | A:3347896596;C:2682409134;G:2729255490;T:3370951380;N:0 | 100 | 100 | 3347896596 | 2682409134 | 2729255490 | 3370951380 | 0 | SRX19463421 | SRS16856044 | 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.94729 | 0.12594 | 0.75684 | 0.53755 | 100 | B | usable mapping rate | bgi | bgi | unknown | poly_a | unknown | bulk | unknown | unknown | China | 2023-02-21 | Adult | Adult | Kidney | Renal System | |||||||||||||||||||||||||||
| 74173 | 74173 | SRR23576637 | SRX19463420 | SRS16856043 | 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. | K3 | strain:AB|age:9 month|dev stage:adulte|sex:male|tissue:kidney marrow|biomaterial provider:EL MAI Mounir|birth date:2019/11/20|birth location:Nice France|treatment:kidneymarrow no Cre R3|BioSampleModel:Model organism or animal | RNA Seq of Danio rerio : adult male kidney marrow | K3 | K3 | RNA Seq of Danio rerio : adult male kidney marrow | RNA-Seq | TRANSCRIPTOMIC | Oligo-dT | PAIRED | BGISEQ | BGISEQ-500 | SRP423783 | k3_1.fq.gz k3_2.fq.gz | fastq fastq | 12414982200.0 | 124149822.0 | k3 1.fq.gz | 0:100 1:100 | A:3396256131;C:2779475706;G:2819830912;T:3419419451;N:0 | 100 | 100 | 3396256131 | 2779475706 | 2819830912 | 3419419451 | 0 | SRX19463420 | SRS16856043 | 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.94186 | 0.13004 | 0.7613 | 0.53529 | 100 | B | usable mapping rate | bgi | bgi | unknown | poly_a | unknown | bulk | unknown | unknown | China | 2023-02-21 | Adult | Adult | Kidney | Renal System | |||||||||||||||||||||||||||
| 74175 | 74175 | SRR23576639 | SRX19463418 | SRS16856041 | 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. | K2 | strain:AB|age:9 month|dev stage:adulte|sex:male|tissue:kidney marrow|biomaterial provider:EL MAI Mounir|birth date:2019/11/20|birth location:Nice France|treatment:kidneymarrow no Cre R2|BioSampleModel:Model organism or animal | RNA Seq of Danio rerio : adult male kidney marrow | K2 | K2 | RNA Seq of Danio rerio : adult male kidney marrow | RNA-Seq | TRANSCRIPTOMIC | Oligo-dT | PAIRED | BGISEQ | BGISEQ-500 | SRP423783 | k2_1.fq.gz k2_2.fq.gz | fastq fastq | 12163413800.0 | 121634138.0 | k2 1.fq.gz | 0:100 1:100 | A:3349566787;C:2697789330;G:2746344614;T:3369713069;N:0 | 100 | 100 | 3349566787 | 2697789330 | 2746344614 | 3369713069 | 0 | SRX19463418 | SRS16856041 | 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.93698 | 0.12494 | 0.73933 | 0.59199 | 100 | B | usable mapping rate | bgi | bgi | unknown | poly_a | unknown | bulk | unknown | unknown | China | 2023-02-21 | Adult | Adult | Kidney | Renal System | |||||||||||||||||||||||||||
| 74176 | 74176 | SRR23576640 | SRX19463417 | SRS16856042 | 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. | K1 | strain:AB|age:9 month|dev stage:adulte|sex:male|tissue:kidney marrow|biomaterial provider:EL MAI Mounir|birth date:2019/11/20|birth location:Nice France|treatment:kidneymarrow no Cre R1|BioSampleModel:Model organism or animal | RNA Seq of Danio rerio : adult male kidney marrow | K1 | K1 | RNA Seq of Danio rerio : adult male kidney marrow | RNA-Seq | TRANSCRIPTOMIC | Oligo-dT | PAIRED | BGISEQ | BGISEQ-500 | SRP423783 | k1_1.fq.gz k1_2.fq.gz | fastq fastq | 12163054400.0 | 121630544.0 | k1 1.fq.gz | 0:100 1:100 | A:3337026687;C:2722574700;G:2757511786;T:3345941227;N:0 | 100 | 100 | 3337026687 | 2722574700 | 2757511786 | 3345941227 | 0 | SRX19463417 | SRS16856042 | 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.94273 | 0.11801 | 0.75258 | 0.57192 | 100 | B | usable mapping rate | bgi | bgi | unknown | poly_a | unknown | bulk | unknown | unknown | China | 2023-02-21 | Adult | Adult | Kidney | Renal 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");;