RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

run_metadata

12 rows where devstage_curation = "Hatching" and experiment.library_selection = "RT-PCR"

✎ View and edit SQL

This data as json, CSV (advanced)

tissue_curation_coarse 1

tissue_curation 1

technology 1

experiment.platform 1

experiment.library_strategy 1

experiment.library_source 1

experiment.library_selection 1

  • RT-PCR · 12 ✖

experiment.library_layout 1

devstage_curation_coarse 1

devstage_curation 1

  • Hatching · 12 ✖
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
43660 43660 SRR6003528 SRX3158823 SRS2490160 SRP116760 PRJNA401346 Raw sequence reads of miR 462/miR 731 knockdwon zebrafish embryos PRJNA401346 Other To elucidate the biological roles of miR 462 731 during embryonic development two morpholinos MOs targeting the mature sequence of miR 462 and miR 731 respectively were microinjected into zebrafish embryos. A total of 100 embryos of uninjected control injected with miR 462 MO or injected with miR 731 MO were collected at xxx hpf respectively for RNA Seq.     100 embyos micorinjected with morphorlinos of miR 462 Danio rerio embryos 462MO 48hpf   strain:AB|dev stage:48hpf|sex:not applicable|tissue:embryos|biomaterial provider:Key Laboratory of Freshwater Animal Breeding College of Fishery Huazhong Agricultural University|collected by:Chun Xiao Huang|sample type:whole embryo|treatment:micorinjected with morphorlinos of miR 462|BioSampleModel:Model organism or animal                 RNA Seq of zebrafish: 48hpf embryos 462MO 48hpf 462MO 48hpf Sequencing libraries were generated using NEBNext? Ultra? RNA LibraryPrep Kit for Illumina? NEB USA following manufacturer¡¯s recommendations and indexcodes were added to attribute sequences to each sample.     RNA-Seq TRANSCRIPTOMIC RT-PCR PAIRED ILLUMINA Illumina HiSeq 2500   SRP116760         3643659000.0 14574636.0 M462MO48 1.fq.gz 0:125 1:125 A:929370426;C:890981335;G:907736720;T:914809265;N:761254 125 125     929370426 890981335 907736720 914809265 761254 SRX3158823 SRS2490160 SRA605241 Huazhong Agricultural University|College of Fisheries Huazhong Agricultural University 2 0.94745 0.94585 0.03062 0.0299 0.71005 0.7167 0.47212 0.46832 125 125 B B biological fallback assumption illumina hiseq_era unknown other nebnext bulk unknown unknown   China 2017-09-05 Hatching Embryo Embryo Imprecise All anatomical structures
43661 43661 SRR6003529 SRX3158822 SRS2490159 SRP116760 PRJNA401346 Raw sequence reads of miR 462/miR 731 knockdwon zebrafish embryos PRJNA401346 Other To elucidate the biological roles of miR 462 731 during embryonic development two morpholinos MOs targeting the mature sequence of miR 462 and miR 731 respectively were microinjected into zebrafish embryos. A total of 100 embryos of uninjected control injected with miR 462 MO or injected with miR 731 MO were collected at xxx hpf respectively for RNA Seq.     100 embyos of uninjected control Danio rerio embryos Control 48hpf   strain:AB|dev stage:48hpf|sex:not applicable|tissue:embryos|biomaterial provider:Key Laboratory of Freshwater Animal Breeding College of Fishery Huazhong Agricultural University|collected by:Chun Xiao Huang|sample type:whole embryo|treatment:uninjected control|BioSampleModel:Model organism or animal                 RNA Seq of zebrafish: 48hpf embryos Control 48hpf Control 48hpf Sequencing libraries were generated using NEBNext? Ultra? RNA LibraryPrep Kit for Illumina? NEB USA following manufacturer¡¯s recommendations and indexcodes were added to attribute sequences to each sample.     RNA-Seq TRANSCRIPTOMIC RT-PCR PAIRED ILLUMINA Illumina HiSeq 2500   SRP116760         3723608000.0 14894432.0 Contr48 2.fq.gz 0:125 1:125 A:947710287;C:910496767;G:932389849;T:932231152;N:779945 125 125     947710287 910496767 932389849 932231152 779945 SRX3158822 SRS2490159 SRA605241 Huazhong Agricultural University|College of Fisheries Huazhong Agricultural University 2 0.94491 0.94085 0.0282 0.02794 0.70928 0.71636 0.46153 0.4685 125 125 B B biological fallback assumption illumina hiseq_era unknown other nebnext bulk unknown unknown   China 2017-09-05 Hatching Embryo Embryo Imprecise All anatomical structures
43662 43662 SRR6003530 SRX3158821 SRS2490158 SRP116760 PRJNA401346 Raw sequence reads of miR 462/miR 731 knockdwon zebrafish embryos PRJNA401346 Other To elucidate the biological roles of miR 462 731 during embryonic development two morpholinos MOs targeting the mature sequence of miR 462 and miR 731 respectively were microinjected into zebrafish embryos. A total of 100 embryos of uninjected control injected with miR 462 MO or injected with miR 731 MO were collected at xxx hpf respectively for RNA Seq.     100 embyos micorinjected with morphorlinos of miR 731 Danio rerio embryos 731MO 48hpf   strain:AB|dev stage:48hpf|sex:not determined|tissue:embryos|biomaterial provider:Key Laboratory of Freshwater Animal Breeding College of Fishery Huazhong Agricultural University|collected by:Chun Xiao Huang|sample type:whole embryo|treatment:micorinjected with morphorlinos of miR 731|BioSampleModel:Model organism or animal                 RNA Seq of zebrafish: 48hpf embryos 731MO 48hpf 731MO 48hpf Sequencing libraries were generated using NEBNext? Ultra? RNA LibraryPrep Kit for Illumina? NEB USA following manufacturer¡¯s recommendations and indexcodes were added to attribute sequences to each sample.     RNA-Seq TRANSCRIPTOMIC RT-PCR PAIRED ILLUMINA Illumina HiSeq 2500   SRP116760         3700848750.0 14803395.0 M731MO48 2.fq.gz 0:125 1:125 A:939687783;C:909029785;G:925521644;T:925836207;N:773331 125 125     939687783 909029785 925521644 925836207 773331 SRX3158821 SRS2490158 SRA605241 Huazhong Agricultural University|College of Fisheries Huazhong Agricultural University 2 0.94623 0.94506 0.02919 0.02927 0.71583 0.72342 0.47105 0.47193 125 125 B B biological fallback assumption illumina hiseq_era unknown other nebnext bulk unknown unknown   China 2017-09-05 Hatching Embryo Embryo Imprecise All anatomical structures
55296 55296 SRR10394606 SRX7094986 SRS5607478 SRP225201 PRJNA576995 RNA sequencing for differential expression gene screening in zebrafish PRJNA576995 Other To screen differential expression genes in zebrafish following BPF exposure         case2 3   sample title for replicate:2 3|strain:not applicable|age:48 hpf|sex:pooled male and female|tissue:embryo|BioSampleModel:Model organism or animal                 case2 3 2 3 2 3 To screen differential expression genes in zebrafish following BPF exposure     RNA-Seq TRANSCRIPTOMIC RT-PCR PAIRED ILLUMINA Illumina HiSeq 2500   SRP225201     170296A-case2-3_HGLWJALXX_L3_1.fq.gz 170296A-case2-3_HGLWJALXX_L3_2.fq.gz fastq fastq 8855015700.0 29516719.0 170296A case2 3 HGLWJALXX L3 1.fq.gz 0:150 1:150 A:2346373651;C:2080129725;G:2086423043;T:2340561908;N:1527373 150 150     2346373651 2080129725 2086423043 2340561908 1527373 SRX7094986 SRS5607478 SRA990382 Chinese academy of fishery sciences|fishery Resource and Environmental Research Center Chinese academy of fishery sciences 2 0.93245 0.93174 0.09246 0.09206 0.65147 0.66393 0.47376 0.47499 150 150 B B biological fallback assumption illumina hiseq_era unknown other unknown bulk unknown unknown   China 2019-11-05 Hatching Embryo Embryo Imprecise All anatomical structures
55297 55297 SRR10394607 SRX7094985 SRS5607477 SRP225201 PRJNA576995 RNA sequencing for differential expression gene screening in zebrafish PRJNA576995 Other To screen differential expression genes in zebrafish following BPF exposure         case2 2   sample title for replicate:2 2|strain:not applicable|age:48 hpf|sex:pooled male and female|tissue:embryo|BioSampleModel:Model organism or animal                 case2 2 2 2 2 2 To screen differential expression genes in zebrafish following BPF exposure     RNA-Seq TRANSCRIPTOMIC RT-PCR PAIRED ILLUMINA Illumina HiSeq 2500   SRP225201     170296A-case2-2_HGLWJALXX_L3_1.fq.gz 170296A-case2-2_HGLWJALXX_L3_2.fq.gz fastq fastq 9061419900.0 30204733.0 170296A case2 2 HGLWJALXX L3 1.fq.gz 0:150 1:150 A:2400908650;C:2127711127;G:2137324991;T:2393913073;N:1562059 150 150     2400908650 2127711127 2137324991 2393913073 1562059 SRX7094985 SRS5607477 SRA990382 Chinese academy of fishery sciences|fishery Resource and Environmental Research Center Chinese academy of fishery sciences 2 0.9283 0.92706 0.09788 0.09751 0.65407 0.66174 0.47665 0.46756 150 150 B B biological fallback assumption illumina hiseq_era unknown other unknown bulk unknown unknown   China 2019-11-05 Hatching Embryo Embryo Imprecise All anatomical structures
55298 55298 SRR10394608 SRX7094984 SRS5607476 SRP225201 PRJNA576995 RNA sequencing for differential expression gene screening in zebrafish PRJNA576995 Other To screen differential expression genes in zebrafish following BPF exposure         case2 1   sample title for replicate:2 1|strain:not applicable|age:48 hpf|sex:pooled male and female|tissue:embryo|BioSampleModel:Model organism or animal                 case2 1 2 1 2 1 To screen differential expression genes in zebrafish following BPF exposure     RNA-Seq TRANSCRIPTOMIC RT-PCR PAIRED ILLUMINA Illumina HiSeq 2500   SRP225201     170296A-case2-1_HGLWJALXX_L3_1.fq.gz 170296A-case2-1_HGLWJALXX_L3_2.fq.gz fastq fastq 7957722900.0 26525743.0 170296A case2 1 HGLWJALXX L3 1.fq.gz 0:150 1:150 A:2091268133;C:1885173791;G:1895292430;T:2084598568;N:1389978 150 150     2091268133 1885173791 1895292430 2084598568 1389978 SRX7094984 SRS5607476 SRA990382 Chinese academy of fishery sciences|fishery Resource and Environmental Research Center Chinese academy of fishery sciences 2 0.93071 0.93062 0.09541 0.09537 0.66218 0.67343 0.44795 0.45757 150 150 B B biological fallback assumption illumina hiseq_era unknown other unknown bulk unknown unknown   China 2019-11-05 Hatching Embryo Embryo Imprecise All anatomical structures
55299 55299 SRR10394609 SRX7094983 SRS5607475 SRP225201 PRJNA576995 RNA sequencing for differential expression gene screening in zebrafish PRJNA576995 Other To screen differential expression genes in zebrafish following BPF exposure         con3   sample title for replicate:0 3|strain:not applicable|age:48 hpf|sex:pooled male and female|tissue:embryo|BioSampleModel:Model organism or animal                 con3 0 3 0 3 To screen differential expression genes in zebrafish following BPF exposure     RNA-Seq TRANSCRIPTOMIC RT-PCR PAIRED ILLUMINA Illumina HiSeq 2500   SRP225201     170296A-con-3_HGLWJALXX_L3_1.fq.gz 170296A-con-3_HGLWJALXX_L3_2.fq.gz fastq fastq 8887815900.0 29626053.0 170296A con 3 HGLWJALXX L3 1.fq.gz 0:150 1:150 A:2352143987;C:2092070321;G:2106757875;T:2335298934;N:1544783 150 150     2352143987 2092070321 2106757875 2335298934 1544783 SRX7094983 SRS5607475 SRA990382 Chinese academy of fishery sciences|fishery Resource and Environmental Research Center Chinese academy of fishery sciences 2 0.92657 0.92558 0.10953 0.10849 0.66665 0.67836 0.46528 0.46952 150 150 B B biological fallback assumption illumina hiseq_era unknown other unknown bulk unknown unknown   China 2019-11-05 Hatching Embryo Embryo Imprecise All anatomical structures
55300 55300 SRR10394610 SRX7094982 SRS5505505 SRP225201 PRJNA576995 RNA sequencing for differential expression gene screening in zebrafish PRJNA576995 Other To screen differential expression genes in zebrafish following BPF exposure         con2   sample title for replicate:0 2|strain:not applicable|age:48 hpf|sex:pooled male and female|tissue:embryo|BioSampleModel:Model organism or animal                 con2 0 2 0 2 To screen differential expression genes in zebrafish following BPF exposure     RNA-Seq TRANSCRIPTOMIC RT-PCR PAIRED ILLUMINA Illumina HiSeq 2500   SRP225201     170296A-con-2_HGLWJALXX_L3_1.fq.gz 170296A-con-2_HGLWJALXX_L3_2.fq.gz fastq fastq 9166144200.0 30553814.0 170296A con 2 HGLWJALXX L3 1.fq.gz 0:150 1:150 A:2412585744;C:2169053726;G:2180991082;T:2401934095;N:1579553 150 150     2412585744 2169053726 2180991082 2401934095 1579553 SRX7094982 SRS5505505 SRA990382 Chinese academy of fishery sciences|fishery Resource and Environmental Research Center Chinese academy of fishery sciences 2 0.93019 0.92958 0.09201 0.0912 0.65202 0.66247 0.4734 0.45718 150 150 B B biological fallback assumption illumina hiseq_era unknown other unknown bulk unknown unknown   China 2019-11-05 Hatching Embryo Embryo Imprecise All anatomical structures
55301 55301 SRR10267094 SRX6980545 SRS5505504 SRP225201 PRJNA576995 RNA sequencing for differential expression gene screening in zebrafish PRJNA576995 Other To screen differential expression genes in zebrafish following BPF exposure         con1   sample title for replicate:0 1|strain:not applicable|age:48 hpf|sex:pooled male and female|tissue:embryo|BioSampleModel:Model organism or animal                 0 1 0 1 0 1 zebrafish embryo samples     RNA-Seq TRANSCRIPTOMIC RT-PCR PAIRED ILLUMINA Illumina HiSeq 2500   SRP225201     170296A-con-1_HGLWJALXX_L3_1.fq.gz 170296A-con-3_HGLWJALXX_L3_2.fq.gz fastq fastq 9415458300.0 31384861.0 170296A con 1 HGLWJALXX L3 1.fq.gz 0:150 1:150 A:2474617601;C:2231195853;G:2241864685;T:2466146702;N:1633459 150 150     2474617601 2231195853 2241864685 2466146702 1633459 SRX6980545 SRS5505504 SRA977706 Chinese academy of fishery sciences|fishery Resource and Environmental Research Center Chinese academy of fishery sciences 2 0.93028 0.92841 0.09571 0.09503 0.65746 0.66543 0.47028 0.46071 150 150 B B biological fallback assumption illumina hiseq_era unknown other unknown bulk unknown unknown   China 2019-10-11 Hatching Embryo Embryo Imprecise All anatomical structures
55302 55302 SRR10267095 SRX6980544 SRS5505503 SRP225201 PRJNA576995 RNA sequencing for differential expression gene screening in zebrafish PRJNA576995 Other To screen differential expression genes in zebrafish following BPF exposure         case1 3   sample title for replicate:1 3|strain:not applicable|age:48 hpf|sex:pooled male and female|tissue:embryo|BioSampleModel:Model organism or animal                 1 3 1 3 1 3 zebrafish embryo samples     RNA-Seq TRANSCRIPTOMIC RT-PCR PAIRED ILLUMINA Illumina HiSeq 2500   SRP225201     170296A-case1-3_HGLWJALXX_L4_1.fq.gz 170296A-case2-3_HGLWJALXX_L4_2.fq.gz fastq fastq 7223133300.0 24077111.0 170296A case1 3 HGLWJALXX L4 1.fq.gz 0:150 1:150 A:1925695574;C:1683782909;G:1684865390;T:1928620280;N:169147 150 150     1925695574 1683782909 1684865390 1928620280 169147 SRX6980544 SRS5505503 SRA977706 Chinese academy of fishery sciences|fishery Resource and Environmental Research Center Chinese academy of fishery sciences 2 0.92712 0.92938 0.10141 0.10152 0.65206 0.65924 0.46219 0.46826 150 150 B B biological fallback assumption illumina hiseq_era unknown other unknown bulk unknown unknown   China 2019-10-11 Hatching Embryo Embryo Imprecise All anatomical structures
55303 55303 SRR10267096 SRX6980543 SRS5505502 SRP225201 PRJNA576995 RNA sequencing for differential expression gene screening in zebrafish PRJNA576995 Other To screen differential expression genes in zebrafish following BPF exposure         case1 2   sample title for replicate:1 2|strain:not applicable|age:48 hpf|sex:pooled male and female|tissue:embryo|BioSampleModel:Model organism or animal                 1 2 1 2 1 2 zebrafish embryo samples     RNA-Seq TRANSCRIPTOMIC RT-PCR PAIRED ILLUMINA Illumina HiSeq 2500   SRP225201     170296A-case2-2_HGLWJALXX_L3_2.fq.gz 170296A-case1-2_HGLWJALXX_L3_1.fq.gz fastq fastq 9322039500.0 31073465.0 170296A case1 2 HGLWJALXX L3 1.fq.gz 0:150 1:150 A:2480808882;C:2178450729;G:2189618007;T:2471557593;N:1604289 150 150     2480808882 2178450729 2189618007 2471557593 1604289 SRX6980543 SRS5505502 SRA977706 Chinese academy of fishery sciences|fishery Resource and Environmental Research Center Chinese academy of fishery sciences 2 0.93046 0.92939 0.10201 0.10148 0.65417 0.66182 0.46825 0.47199 150 150 B B biological fallback assumption illumina hiseq_era unknown other unknown bulk unknown unknown   China 2019-10-11 Hatching Embryo Embryo Imprecise All anatomical structures
55304 55304 SRR10267097 SRX6980542 SRS5505501 SRP225201 PRJNA576995 RNA sequencing for differential expression gene screening in zebrafish PRJNA576995 Other To screen differential expression genes in zebrafish following BPF exposure         case1 1   sample title for replicate:1 1|strain:not applicable|age:48 hpf|sex:pooled male and female|tissue:embryo|BioSampleModel:Model organism or animal                 1 1 1 1 1 1 zebrafish embryo samples     RNA-Seq TRANSCRIPTOMIC RT-PCR PAIRED ILLUMINA Illumina HiSeq 2500   SRP225201     170296A-case1-1_HGLWJALXX_L3_1.fq.gz 170296A-case2-1_HGLWJALXX_L3_2.fq.gz fastq fastq 9593332800.0 31977776.0 170296A case1 1 HGLWJALXX L3 1.fq.gz 0:150 1:150 A:2527044547;C:2268335173;G:2277186987;T:2519119012;N:1647081 150 150     2527044547 2268335173 2277186987 2519119012 1647081 SRX6980542 SRS5505501 SRA977706 Chinese academy of fishery sciences|fishery Resource and Environmental Research Center Chinese academy of fishery sciences 2 0.93213 0.93298 0.09449 0.09434 0.65772 0.66596 0.46597 0.46237 150 150 B B biological fallback assumption illumina hiseq_era unknown other unknown bulk unknown unknown   China 2019-10-11 Hatching 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");;