run_metadata
9 rows where experiment.library_selection = "Oligo-dT", experiment.platform = "OXFORD_NANOPORE" and tissue_curation = "Undetermined"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9918 | 9918 | ERR5059480 | ERX4865549 | ERS5523939 | ERP122761 | PRJEB39265 | RNA dynamics during zebrafish development | ena-STUDY-CENTER FOR GENOMIC REGULATION (CRG)-06-07-2020-15:41:43:771-1183 | Other | RNA dynamics during early zebrafish development | ENA FIRST PUBLIC:2022 07 05|ENA LAST UPDATE:2022 07 05 | aAM 6h rep1 | JD AD30 PRPN1970901 | ENA FIRST PUBLIC:2022 07 05T12:06:33Z|organism:Danio rerio|ENA LAST UPDATE:2022 07 05T12:06:33Z|scientific name:Danio rerio|common name:zebrafish|ENA FIRST PUBLIC:2022 07 05|ENA LAST UPDATE:2022 07 05 | PromethION sequencing | ena EXPERIMENT CENTER FOR GENOMIC REGULATION CRG 09 01 2021 19:50:56:183 1 | unspecified | 1 | RNA-Seq | TRANSCRIPTOMIC | Oligo-dT | SINGLE | OXFORD_NANOPORE | PromethION | ERP122761 | PromethION sequencing | ENA FIRST PUBLIC:2022 07 05|ENA LAST UPDATE:2022 07 05 | JD-AD30_PRPN197090.tar.gz | nanopore | 3739882337.0 | 3148027.0 | ena RUN CENTER FOR GENOMIC REGULATION CRG 09 01 2021 19:50:56:183 1 | 0:1188.01 | A:1054501690;C:834193435;G:847423060;T:1003764152;N:0 | 1188 | 1054501690 | 834193435 | 847423060 | 1003764152 | 0 | ERX4865549 | ERS5523939 | ERA3206712 | CENTER FOR GENOMIC REGULATION (CRG)|European Nucleotide Archive | CENTER FOR GENOMIC REGULATION (CRG) | B | usable mapping rate | ont | ont | unknown | poly_a | unknown | bulk | unknown | unknown | Spain | 2022-07-05 | Undetermined | Undetermined | Undetermined | Undetermined | ||||||||||||||||||||||||||||||
| 9919 | 9919 | ERR5167510 | ERX4972431 | ERS5593364 | ERP122761 | PRJEB39265 | RNA dynamics during zebrafish development | ena-STUDY-CENTER FOR GENOMIC REGULATION (CRG)-06-07-2020-15:41:43:771-1183 | Other | RNA dynamics during early zebrafish development | ENA FIRST PUBLIC:2022 07 05|ENA LAST UPDATE:2022 07 05 | cDNA WT 2hpf rep1 | JD T20 PDPN191089 | ENA FIRST PUBLIC:2022 07 05T12:06:34Z|organism:Danio rerio|ENA LAST UPDATE:2022 07 05T12:06:34Z|scientific name:Danio rerio|common name:zebrafish|ENA FIRST PUBLIC:2022 07 05|ENA LAST UPDATE:2022 07 05 | PromethION sequencing | ena EXPERIMENT CENTER FOR GENOMIC REGULATION CRG 21 01 2021 22:16:50:154 1 | unspecified | 1 | RNA-Seq | TRANSCRIPTOMIC | Oligo-dT | SINGLE | OXFORD_NANOPORE | PromethION | ERP122761 | PromethION sequencing | ENA FIRST PUBLIC:2022 07 05|ENA LAST UPDATE:2022 07 05 | ena RUN CENTER FOR GENOMIC REGULATION CRG 21 01 2021 22:16:50:154 1 | ERX4972431 | ERA3319053 | CENTER FOR GENOMIC REGULATION (CRG)|European Nucleotide Archive | CENTER FOR GENOMIC REGULATION (CRG) | ont | ont | unknown | poly_a | unknown | bulk | unknown | unknown | Spain | 2022-07-05 | Cleavage | Embryo | Undetermined | Embryo Imprecise | |||||||||||||||||||||||||||||||||||||||||||||
| 9920 | 9920 | ERR4330695 | ERX4277529 | ERS4811113 | ERP122761 | PRJEB39265 | RNA dynamics during zebrafish development | ena-STUDY-CENTER FOR GENOMIC REGULATION (CRG)-06-07-2020-15:41:43:771-1183 | Other | RNA dynamics during early zebrafish development | ENA FIRST PUBLIC:2022 07 05|ENA LAST UPDATE:2022 07 05 | WT 2h rep1 | WT 2h rep1 | SAMEA7050483 | CENTER FOR GENOMIC REGULATION (CRG) | ENA FIRST PUBLIC:2022 07 05|ENA LAST UPDATE:2022 07 05|External Id:SAMEA7050483|INSDC center alias:CENTER FOR GENOMIC REGULATION CRG|INSDC center name:CENTER FOR GENOMIC REGULATION CRG|INSDC first public:2022 07 05T12:06:22Z|INSDC last update:2022 07 05T12:06:22Z|INSDC status:public|Submitter Id:JD B2 PDBN005727|common name:zebrafish|sample name:JD B2 PDBN005727 | PromethION sequencing | ena EXPERIMENT CENTER FOR GENOMIC REGULATION CRG 09 07 2020 13:48:01:100 1 | unspecified | 1 | RNA-Seq | TRANSCRIPTOMIC | Oligo-dT | SINGLE | OXFORD_NANOPORE | PromethION | ERP122761 | PromethION sequencing | ENA FIRST PUBLIC:2022 07 05|ENA LAST UPDATE:2022 07 05 | JD-B2_PDBN005727.tar.gz | fastq | ena RUN CENTER FOR GENOMIC REGULATION CRG 09 07 2020 13:48:01:100 1 | ERX4277529 | ERA2767154 | CENTER FOR GENOMIC REGULATION (CRG)|European Nucleotide Archive | CENTER FOR GENOMIC REGULATION (CRG) | ont | ont | unknown | poly_a | unknown | bulk | unknown | unknown | Spain | 2022-07-05 | Undetermined | Undetermined | Undetermined | Undetermined | |||||||||||||||||||||||||||||||||||||||||
| 9921 | 9921 | ERR4327134 | ERX4273968 | ERS4808634 | ERP122761 | PRJEB39265 | RNA dynamics during zebrafish development | ena-STUDY-CENTER FOR GENOMIC REGULATION (CRG)-06-07-2020-15:41:43:771-1183 | Other | RNA dynamics during early zebrafish development | ENA FIRST PUBLIC:2022 07 05|ENA LAST UPDATE:2022 07 05 | WT 4h rep2 | WT 4h rep2 | SAMEA7048000 | CENTER FOR GENOMIC REGULATION (CRG) | ENA FIRST PUBLIC:2022 07 05|ENA LAST UPDATE:2022 07 05|External Id:SAMEA7048000|INSDC center alias:CENTER FOR GENOMIC REGULATION CRG|INSDC center name:CENTER FOR GENOMIC REGULATION CRG|INSDC first public:2022 07 05T12:06:22Z|INSDC last update:2022 07 05T12:06:22Z|INSDC status:public|Submitter Id:JD AM39 PDBN042841|common name:zebrafish|sample name:JD AM39 PDBN042841 | PromethION sequencing | ena EXPERIMENT CENTER FOR GENOMIC REGULATION CRG 07 07 2020 16:36:02:084 1 | unspecified | 1 | RNA-Seq | TRANSCRIPTOMIC | Oligo-dT | SINGLE | OXFORD_NANOPORE | PromethION | ERP122761 | PromethION sequencing | ENA FIRST PUBLIC:2022 07 05|ENA LAST UPDATE:2022 07 05 | JD-AM39_PDBN042841.tar.gz | nanopore | 719646261.0 | 897768.0 | ena RUN CENTER FOR GENOMIC REGULATION CRG 07 07 2020 16:36:02:084 1 | 0:801.59 | A:210217908;C:152963718;G:157393834;T:199070801;N:0 | 801 | 210217908 | 152963718 | 157393834 | 199070801 | 0 | ERX4273968 | ERS4808634 | ERA2764800 | CENTER FOR GENOMIC REGULATION (CRG)|European Nucleotide Archive | CENTER FOR GENOMIC REGULATION (CRG) | T | under 1.2% mapping rate | ont | ont | unknown | poly_a | unknown | bulk | unknown | unknown | Spain | 2022-07-05 | Undetermined | Undetermined | Undetermined | Undetermined | ||||||||||||||||||||||||||||
| 9922 | 9922 | ERR4330696 | ERX4277530 | ERS4811114 | ERP122761 | PRJEB39265 | RNA dynamics during zebrafish development | ena-STUDY-CENTER FOR GENOMIC REGULATION (CRG)-06-07-2020-15:41:43:771-1183 | Other | RNA dynamics during early zebrafish development | ENA FIRST PUBLIC:2022 07 05|ENA LAST UPDATE:2022 07 05 | WT 4h rep1 | WT 4h rep1 | JD C3 PDBN006177 | ENA FIRST PUBLIC:2022 07 05T12:06:22Z|organism:Danio rerio|ENA LAST UPDATE:2022 07 05T12:06:22Z|scientific name:Danio rerio|common name:zebrafish|ENA FIRST PUBLIC:2022 07 05|ENA LAST UPDATE:2022 07 05 | PromethION sequencing | ena EXPERIMENT CENTER FOR GENOMIC REGULATION CRG 09 07 2020 13:48:01:100 2 | unspecified | 1 | RNA-Seq | TRANSCRIPTOMIC | Oligo-dT | SINGLE | OXFORD_NANOPORE | PromethION | ERP122761 | PromethION sequencing | ENA FIRST PUBLIC:2022 07 05|ENA LAST UPDATE:2022 07 05 | JD-C3_PDBN006177.tar.gz | nanopore | 4240799932.0 | 4331689.0 | ena RUN CENTER FOR GENOMIC REGULATION CRG 09 07 2020 13:48:01:100 2 | 0:979.02 | A:1229803846;C:914476674;G:943703560;T:1152815852;N:0 | 979 | 1229803846 | 914476674 | 943703560 | 1152815852 | 0 | ERX4277530 | ERS4811114 | ERA2767154 | CENTER FOR GENOMIC REGULATION (CRG)|European Nucleotide Archive | CENTER FOR GENOMIC REGULATION (CRG) | B | usable mapping rate | ont | ont | unknown | poly_a | unknown | bulk | unknown | unknown | Spain | 2022-07-05 | Undetermined | Undetermined | Undetermined | Undetermined | |||||||||||||||||||||||||||||
| 9923 | 9923 | ERR4327135 | ERX4273969 | ERS4808635 | ERP122761 | PRJEB39265 | RNA dynamics during zebrafish development | ena-STUDY-CENTER FOR GENOMIC REGULATION (CRG)-06-07-2020-15:41:43:771-1183 | Other | RNA dynamics during early zebrafish development | ENA FIRST PUBLIC:2022 07 05|ENA LAST UPDATE:2022 07 05 | WT 6h rep1 | WT 6h rep1 | JD AC29 PDBN024889 | ENA FIRST PUBLIC:2022 07 05T12:06:22Z|organism:Danio rerio|ENA LAST UPDATE:2022 07 05T12:06:22Z|scientific name:Danio rerio|common name:zebrafish|ENA FIRST PUBLIC:2022 07 05|ENA LAST UPDATE:2022 07 05 | PromethION sequencing | ena EXPERIMENT CENTER FOR GENOMIC REGULATION CRG 07 07 2020 16:36:02:084 2 | unspecified | 1 | RNA-Seq | TRANSCRIPTOMIC | Oligo-dT | SINGLE | OXFORD_NANOPORE | PromethION | ERP122761 | PromethION sequencing | ENA FIRST PUBLIC:2022 07 05|ENA LAST UPDATE:2022 07 05 | JD-AC29_PDBN024889.tar.gz | nanopore | 1900324756.0 | 2013035.0 | ena RUN CENTER FOR GENOMIC REGULATION CRG 07 07 2020 16:36:02:084 2 | 0:944.01 | A:549431032;C:411510218;G:422103800;T:517279706;N:0 | 944 | 549431032 | 411510218 | 422103800 | 517279706 | 0 | ERX4273969 | ERS4808635 | ERA2764800 | CENTER FOR GENOMIC REGULATION (CRG)|European Nucleotide Archive | CENTER FOR GENOMIC REGULATION (CRG) | T | long read | ont | ont | unknown | poly_a | unknown | bulk | unknown | unknown | Spain | 2022-07-05 | Undetermined | Undetermined | Undetermined | Undetermined | |||||||||||||||||||||||||||||
| 9924 | 9924 | ERR4326350 | ERX4273208 | ERS4808398 | ERP122761 | PRJEB39265 | RNA dynamics during zebrafish development | ena-STUDY-CENTER FOR GENOMIC REGULATION (CRG)-06-07-2020-15:41:43:771-1183 | Other | RNA dynamics during early zebrafish development | ENA FIRST PUBLIC:2022 07 05|ENA LAST UPDATE:2022 07 05 | 430 LNA 6h rep1 | 430 LNA 6h rep1 | SAMEA7047764 | CENTER FOR GENOMIC REGULATION (CRG) | ENA FIRST PUBLIC:2022 07 05|ENA LAST UPDATE:2022 07 05|External Id:SAMEA7047764|INSDC center alias:CENTER FOR GENOMIC REGULATION CRG|INSDC center name:CENTER FOR GENOMIC REGULATION CRG|INSDC first public:2022 07 05T12:06:22Z|INSDC last update:2022 07 05T12:06:22Z|INSDC status:public|Submitter Id:JD H8 PDBN059569|common name:zebrafish|sample name:JD H8 PDBN059569 | PromethION sequencing | ena EXPERIMENT CENTER FOR GENOMIC REGULATION CRG 07 07 2020 10:25:22:388 1 | unspecified | 1 | RNA-Seq | TRANSCRIPTOMIC | Oligo-dT | SINGLE | OXFORD_NANOPORE | PromethION | ERP122761 | PromethION sequencing | ENA FIRST PUBLIC:2022 07 05|ENA LAST UPDATE:2022 07 05 | JD-H8_PDBN059569.tar.gz | nanopore | 722817654.0 | 657296.0 | ena RUN CENTER FOR GENOMIC REGULATION CRG 07 07 2020 10:25:22:388 1 | 0:1099.68 | A:206996491;C:157022109;G:155085437;T:203713617;N:0 | 1099 | 206996491 | 157022109 | 155085437 | 203713617 | 0 | ERX4273208 | ERS4808398 | ERA2764399 | CENTER FOR GENOMIC REGULATION (CRG)|European Nucleotide Archive | CENTER FOR GENOMIC REGULATION (CRG) | T | under 1.2% mapping rate | ont | ont | unknown | poly_a | unknown | bulk | unknown | unknown | Spain | 2022-07-05 | Undetermined | Undetermined | Undetermined | Undetermined | ||||||||||||||||||||||||||||
| 9925 | 9925 | ERR4335436 | ERX4282181 | ERS4818366 | ERP122761 | PRJEB39265 | RNA dynamics during zebrafish development | ena-STUDY-CENTER FOR GENOMIC REGULATION (CRG)-06-07-2020-15:41:43:771-1183 | Other | RNA dynamics during early zebrafish development | ENA FIRST PUBLIC:2022 07 05|ENA LAST UPDATE:2022 07 05 | WT 6h rep2 | WT 6h rep2 | JD W23 PRPN039928 | ENA FIRST PUBLIC:2022 07 05T12:06:24Z|organism:Danio rerio|ENA LAST UPDATE:2022 07 05T12:06:24Z|scientific name:Danio rerio|common name:zebrafish|ENA FIRST PUBLIC:2022 07 05|ENA LAST UPDATE:2022 07 05 | PromethION sequencing | ena EXPERIMENT CENTER FOR GENOMIC REGULATION CRG 13 07 2020 18:19:23:456 1 | unspecified | 1 | RNA-Seq | TRANSCRIPTOMIC | Oligo-dT | SINGLE | OXFORD_NANOPORE | PromethION | ERP122761 | PromethION sequencing | ENA FIRST PUBLIC:2022 07 05|ENA LAST UPDATE:2022 07 05 | JD-W23_PRPN039928.tar.gz | nanopore | 1268761319.0 | 1385621.0 | ena RUN CENTER FOR GENOMIC REGULATION CRG 13 07 2020 18:19:23:457 1 | 0:915.66 | A:366823862;C:275507684;G:284634548;T:341795225;N:0 | 915 | 366823862 | 275507684 | 284634548 | 341795225 | 0 | ERX4282181 | ERS4818366 | ERA2769006 | CENTER FOR GENOMIC REGULATION (CRG)|European Nucleotide Archive | CENTER FOR GENOMIC REGULATION (CRG) | T | under 1.2% mapping rate | ont | ont | unknown | poly_a | unknown | bulk | unknown | unknown | Spain | 2022-07-05 | Undetermined | Undetermined | Undetermined | Undetermined | |||||||||||||||||||||||||||||
| 9926 | 9926 | ERR4321680 | ERX4268538 | ERS4808125 | ERP122761 | PRJEB39265 | RNA dynamics during zebrafish development | ena-STUDY-CENTER FOR GENOMIC REGULATION (CRG)-06-07-2020-15:41:43:771-1183 | Other | RNA dynamics during early zebrafish development | ENA FIRST PUBLIC:2022 07 05|ENA LAST UPDATE:2022 07 05 | WT 0h rep1 | WT 0h rep1 | JD A1 GDDN003032 | ENA FIRST PUBLIC:2022 07 05T12:06:22Z|organism:Danio rerio|ENA LAST UPDATE:2022 07 05T12:06:22Z|scientific name:Danio rerio|common name:zebrafish|ENA FIRST PUBLIC:2022 07 05|ENA LAST UPDATE:2022 07 05 | GridION sequencing | ena EXPERIMENT CENTER FOR GENOMIC REGULATION CRG 06 07 2020 17:45:26:236 1 | unspecified | 1 | RNA-Seq | TRANSCRIPTOMIC | Oligo-dT | SINGLE | OXFORD_NANOPORE | GridION | ERP122761 | GridION sequencing | ENA FIRST PUBLIC:2022 07 05|ENA LAST UPDATE:2022 07 05 | JD-A1_GDDN003032.tar.gz | nanopore | 753417826.0 | 698774.0 | ena RUN CENTER FOR GENOMIC REGULATION CRG 06 07 2020 17:45:26:236 1 | 0:1078.20 | A:214525685;C:165042952;G:171160615;T:202688574;N:0 | 1078 | 214525685 | 165042952 | 171160615 | 202688574 | 0 | ERX4268538 | ERS4808125 | ERA2763718 | CENTER FOR GENOMIC REGULATION (CRG)|European Nucleotide Archive | CENTER FOR GENOMIC REGULATION (CRG) | T | long read | ont | ont | unknown | poly_a | unknown | bulk | unknown | unknown | Spain | 2022-07-05 | Undetermined | Undetermined | 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");;