RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

run_metadata

12 rows where devstage_curation = "Multi-stage" and experiment.library_selection = "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

  • PCR · 12 ✖

experiment.library_layout 1

devstage_curation_coarse 1

devstage_curation 1

  • Multi-stage · 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
33722 33722 SRR30640695 SRX26062515 SRS22631699 SRP532179 PRJNA1159911 Peri Centriolar Material 1 regulates polarized endosome dynamics and neural progenitor fate PRJNA1159911 Other RNA seq was performed on control and maternal zygotic developmentally defective pcm1 morphants MO and pcm1 knock out KO zebrafish embryos at 24 hpf.         WT24hpfcontrol1   breed:natural spawning of AB adults|age:24hpf|dev stage:adult|collection date:2021 03 19|geo loc name:USA:San Francisco|sex:not determined|tissue:WT24hpfcontrol1 embryo|BioSampleModel:Model organism or animal                 RNA seq of Wild type zebrafish : 12 embryos in total 2 3mg WT24hpfcontrol1 R WT24hpfcontrol1 R Wild type zebrafish     RNA-Seq TRANSCRIPTOMIC PCR PAIRED ILLUMINA Illumina HiSeq 1000   SRP532179     WT24hpfcontrol1_R1.clean.fq.gz WT24hpfcontrol1_R2.clean.fq.gz fastq fastq 6761688309.0 27496581.0 WT24hpfcontrol1 R1.clean.fq.gz 0:122.99 1:122.92 A:1946719560;C:1442103403;G:1451347536;T:1921456727;N:61083 122 122     1946719560 1442103403 1451347536 1921456727 61083 SRX26062515 SRS22631699 SRA1970017 Huazhong Agricultural University, China|Department of Neurosurgery Huazhong Agricultural University, China                       B B biological fallback assumption illumina hiseq_era unknown random_priming unknown bulk unknown unknown   China 2024-09-11 Multi-stage Multi-stage Embryo Imprecise All anatomical structures
33723 33723 SRR30640696 SRX26062514 SRS22631698 SRP532179 PRJNA1159911 Peri Centriolar Material 1 regulates polarized endosome dynamics and neural progenitor fate PRJNA1159911 Other RNA seq was performed on control and maternal zygotic developmentally defective pcm1 morphants MO and pcm1 knock out KO zebrafish embryos at 24 hpf.         PCM1MOMutant3   breed:Tg [ef1:Myr Tdtomato]|age:24hpf|dev stage:adult|collection date:2021 03 19|geo loc name:USA:San Francisco|sex:not determined|tissue:PCM1MOMutant3 embryo|BioSampleModel:Model organism or animal                 RNA seq of MO morphants zebrafish : 12 embryos in total 2 5mg PCM1MOMutant3 R PCM1MOMutant3 R MO morphants zebrafish     RNA-Seq TRANSCRIPTOMIC PCR PAIRED ILLUMINA Illumina HiSeq 1000   SRP532179     PCM1MOMutant3_R1.clean.fq.gz PCM1MOMutant3_R2.clean.fq.gz fastq fastq 6356420208.0 23407180.0 PCM1MOMutant3 R1.clean.fq.gz 0:135.78 1:135.78 A:1742323782;C:1448163439;G:1451783264;T:1714090084;N:59639 135 135     1742323782 1448163439 1451783264 1714090084 59639 SRX26062514 SRS22631698 SRA1970017 Huazhong Agricultural University, China|Department of Neurosurgery Huazhong Agricultural University, China                       B B biological fallback assumption illumina hiseq_era unknown random_priming unknown bulk unknown unknown   China 2024-09-11 Multi-stage Multi-stage Embryo Imprecise All anatomical structures
33724 33724 SRR30640697 SRX26062513 SRS22631697 SRP532179 PRJNA1159911 Peri Centriolar Material 1 regulates polarized endosome dynamics and neural progenitor fate PRJNA1159911 Other RNA seq was performed on control and maternal zygotic developmentally defective pcm1 morphants MO and pcm1 knock out KO zebrafish embryos at 24 hpf.         PCM1MOMutant2   breed:Tg [ef1:Myr Tdtomato]|age:24hpf|dev stage:adult|collection date:2021 03 19|geo loc name:USA:San Francisco|sex:not determined|tissue:PCM1MOMutant2 embryo|BioSampleModel:Model organism or animal                 RNA seq of MO morphants zebrafish : 12 embryos in total 2 4mg PCM1MOMutant2 R PCM1MOMutant2 R MO morphants zebrafish     RNA-Seq TRANSCRIPTOMIC PCR PAIRED ILLUMINA Illumina HiSeq 1000   SRP532179     PCM1MOMutant2_R1.clean.fq.gz PCM1MOMutant2_R2.clean.fq.gz fastq fastq 6146772469.0 22703012.0 PCM1MOMutant2 R1.clean.fq.gz 0:135.37 1:135.37 A:1647298308;C:1435201745;G:1438871965;T:1625343182;N:57269 135 135     1647298308 1435201745 1438871965 1625343182 57269 SRX26062513 SRS22631697 SRA1970017 Huazhong Agricultural University, China|Department of Neurosurgery Huazhong Agricultural University, China                       B B biological fallback assumption illumina hiseq_era unknown random_priming unknown bulk unknown unknown   China 2024-09-11 Multi-stage Multi-stage Embryo Imprecise All anatomical structures
33725 33725 SRR30640698 SRX26062512 SRS22631696 SRP532179 PRJNA1159911 Peri Centriolar Material 1 regulates polarized endosome dynamics and neural progenitor fate PRJNA1159911 Other RNA seq was performed on control and maternal zygotic developmentally defective pcm1 morphants MO and pcm1 knock out KO zebrafish embryos at 24 hpf.         PCM1MOMutant1   breed:Tg [ef1:Myr Tdtomato]|age:24hpf|dev stage:adult|collection date:2021 03 19|geo loc name:USA:San Francisco|sex:not determined|tissue:PCM1MOMutant1 embryo|BioSampleModel:Model organism or animal                 RNA seq of MO morphants zebrafish : 12 embryos in total 2 3mg PCM1MOMutant1 R PCM1MOMutant1 R MO morphants zebrafish     RNA-Seq TRANSCRIPTOMIC PCR PAIRED ILLUMINA Illumina HiSeq 1000   SRP532179     PCM1MOMutant1_R1.clean.fq.gz PCM1MOMutant1_R2.clean.fq.gz fastq fastq 5701775379.0 21587297.0 PCM1MOMutant1 R1.clean.fq.gz 0:132.06 1:132.06 A:1578153876;C:1282130829;G:1284978375;T:1556460380;N:51919 132 132     1578153876 1282130829 1284978375 1556460380 51919 SRX26062512 SRS22631696 SRA1970017 Huazhong Agricultural University, China|Department of Neurosurgery Huazhong Agricultural University, China                       B B biological fallback assumption illumina hiseq_era unknown random_priming unknown bulk unknown unknown   China 2024-09-11 Multi-stage Multi-stage Embryo Imprecise All anatomical structures
33726 33726 SRR30640699 SRX26062511 SRS22631695 SRP532179 PRJNA1159911 Peri Centriolar Material 1 regulates polarized endosome dynamics and neural progenitor fate PRJNA1159911 Other RNA seq was performed on control and maternal zygotic developmentally defective pcm1 morphants MO and pcm1 knock out KO zebrafish embryos at 24 hpf.         PCM1KOmutant3   breed:Tg [ef1:Myr Tdtomato]|age:24hpf|dev stage:adult|collection date:2021 03 19|geo loc name:USA:San Francisco|sex:not determined|tissue:PCM1KOmutant3 embryo|BioSampleModel:Model organism or animal                 RNA seq of pcm1 KO mutant zebrafish : 12 embryos in total 2 5mg PCM1KOmutant3 R PCM1KOmutant3 R pcm1 KO mutant zebrafish     RNA-Seq TRANSCRIPTOMIC PCR PAIRED ILLUMINA Illumina HiSeq 1000   SRP532179     PCM1KOmutant3_R1.clean.fq.gz PCM1KOmutant3_R2.clean.fq.gz fastq fastq 4673179612.0 17529406.0 PCM1KOmutant3 R1.clean.fq.gz 0:133.29 1:133.30 A:1266929858;C:1078407007;G:1080490713;T:1247307342;N:44692 133 133     1266929858 1078407007 1080490713 1247307342 44692 SRX26062511 SRS22631695 SRA1970017 Huazhong Agricultural University, China|Department of Neurosurgery Huazhong Agricultural University, China                       B B biological fallback assumption illumina hiseq_era unknown random_priming unknown bulk unknown unknown   China 2024-09-11 Multi-stage Multi-stage Embryo Imprecise All anatomical structures
33727 33727 SRR30640700 SRX26062510 SRS22631694 SRP532179 PRJNA1159911 Peri Centriolar Material 1 regulates polarized endosome dynamics and neural progenitor fate PRJNA1159911 Other RNA seq was performed on control and maternal zygotic developmentally defective pcm1 morphants MO and pcm1 knock out KO zebrafish embryos at 24 hpf.         PCM1KOmutant2   breed:Tg [ef1:Myr Tdtomato]|age:24hpf|dev stage:adult|collection date:2021 03 19|geo loc name:USA:San Francisco|sex:not determined|tissue:PCM1KOmutant2 embryo|BioSampleModel:Model organism or animal                 RNA seq of pcm1 KO mutant zebrafish : 12 embryos in total 2 4mg PCM1KOmutant2 R PCM1KOmutant2 R pcm1 KO mutant zebrafish     RNA-Seq TRANSCRIPTOMIC PCR PAIRED ILLUMINA Illumina HiSeq 1000   SRP532179     PCM1KOmutant2_R1.clean.fq.gz PCM1KOmutant2_R2.clean.fq.gz fastq fastq 6073820902.0 23767661.0 PCM1KOmutant2 R1.clean.fq.gz 0:127.78 1:127.77 A:1691243395;C:1356197711;G:1357868249;T:1668456939;N:54608 127 127     1691243395 1356197711 1357868249 1668456939 54608 SRX26062510 SRS22631694 SRA1970017 Huazhong Agricultural University, China|Department of Neurosurgery Huazhong Agricultural University, China                       B B biological fallback assumption illumina hiseq_era unknown random_priming unknown bulk unknown unknown   China 2024-09-11 Multi-stage Multi-stage Embryo Imprecise All anatomical structures
33728 33728 SRR30640701 SRX26062509 SRS22631693 SRP532179 PRJNA1159911 Peri Centriolar Material 1 regulates polarized endosome dynamics and neural progenitor fate PRJNA1159911 Other RNA seq was performed on control and maternal zygotic developmentally defective pcm1 morphants MO and pcm1 knock out KO zebrafish embryos at 24 hpf.         PCM1KOmutant1   breed:Tg [ef1:Myr Tdtomato]|age:24hpf|dev stage:adult|collection date:2021 03 19|geo loc name:USA:San Francisco|sex:not determined|tissue:PCM1KOmutant1 embryo|BioSampleModel:Model organism or animal                 RNA seq of pcm1 KO mutant zebrafish : 12 embryos in total 2 3mg PCM1KOmutant1 R PCM1KOmutant1 R KO mutant zebrafish     RNA-Seq TRANSCRIPTOMIC PCR PAIRED ILLUMINA Illumina HiSeq 1000   SRP532179     PCM1KOmutant1_R1.clean.fq.gz PCM1KOmutant1_R2.clean.fq.gz fastq fastq 6040589500.0 23826027.0 PCM1KOmutant1 R1.clean.fq.gz 0:126.76 1:126.76 A:1733588631;C:1297359473;G:1301151829;T:1708434373;N:55194 126 126     1733588631 1297359473 1301151829 1708434373 55194 SRX26062509 SRS22631693 SRA1970017 Huazhong Agricultural University, China|Department of Neurosurgery Huazhong Agricultural University, China                       B B biological fallback assumption illumina hiseq_era unknown random_priming unknown bulk unknown unknown   China 2024-09-11 Multi-stage Multi-stage Embryo Imprecise All anatomical structures
33729 33729 SRR30640702 SRX26062508 SRS22631692 SRP532179 PRJNA1159911 Peri Centriolar Material 1 regulates polarized endosome dynamics and neural progenitor fate PRJNA1159911 Other RNA seq was performed on control and maternal zygotic developmentally defective pcm1 morphants MO and pcm1 knock out KO zebrafish embryos at 24 hpf.         PCM1KOcompensate3   breed:Tg [HuC:GFP|age:24hpf|dev stage:adult|collection date:2021 03 19|geo loc name:USA:San Francisco|sex:not determined|tissue:PCM1KOcompensate3 embryo|BioSampleModel:Model organism or animal                 RNA seq of pcm1 KO compensate zebrafish : 12 embryos in total 2 5mg PCM1KOcompensate3 R PCM1KOcompensate3 R pcm1 KO compensate zebrafish     RNA-Seq TRANSCRIPTOMIC PCR PAIRED ILLUMINA Illumina HiSeq 1000   SRP532179     PCM1KOcompensate3_R1.clean.fq.gz PCM1KOcompensate3_R2.clean.fq.gz fastq fastq 5632945620.0 21351897.0 PCM1KOcompensate3 R1.clean.fq.gz 0:131.92 1:131.90 A:1561604697;C:1264380828;G:1267746178;T:1539161674;N:52243 131 131     1561604697 1264380828 1267746178 1539161674 52243 SRX26062508 SRS22631692 SRA1970017 Huazhong Agricultural University, China|Department of Neurosurgery Huazhong Agricultural University, China                       B B biological fallback assumption illumina hiseq_era unknown random_priming unknown bulk unknown unknown   China 2024-09-11 Multi-stage Multi-stage Embryo Imprecise All anatomical structures
33730 33730 SRR30640703 SRX26062507 SRS22631691 SRP532179 PRJNA1159911 Peri Centriolar Material 1 regulates polarized endosome dynamics and neural progenitor fate PRJNA1159911 Other RNA seq was performed on control and maternal zygotic developmentally defective pcm1 morphants MO and pcm1 knock out KO zebrafish embryos at 24 hpf.         WT24hpfcontrol3   breed:natural spawning of AB adults|age:24hpf|dev stage:adult|collection date:2021 03 19|geo loc name:USA:San Francisco|sex:not determined|tissue:WT24hpfcontrol3 embryo|BioSampleModel:Model organism or animal                 RNA seq of Wild type zebrafish : 12 embryos in total 2 5mg WT24hpfcontrol3 R WT24hpfcontrol3 R Wild type zebrafish     RNA-Seq TRANSCRIPTOMIC PCR PAIRED ILLUMINA Illumina HiSeq 1000   SRP532179     WT24hpfcontrol3_R1.clean.fq.gz WT24hpfcontrol3_R2.clean.fq.gz fastq fastq 5047867453.0 19837417.0 WT24hpfcontrol3 R1.clean.fq.gz 0:127.23 1:127.23 A:1412463929;C:1119657233;G:1121642146;T:1394058438;N:45707 127 127     1412463929 1119657233 1121642146 1394058438 45707 SRX26062507 SRS22631691 SRA1970017 Huazhong Agricultural University, China|Department of Neurosurgery Huazhong Agricultural University, China                       B B biological fallback assumption illumina hiseq_era unknown random_priming unknown bulk unknown unknown   China 2024-09-11 Multi-stage Multi-stage Embryo Imprecise All anatomical structures
33731 33731 SRR30640704 SRX26062506 SRS22631690 SRP532179 PRJNA1159911 Peri Centriolar Material 1 regulates polarized endosome dynamics and neural progenitor fate PRJNA1159911 Other RNA seq was performed on control and maternal zygotic developmentally defective pcm1 morphants MO and pcm1 knock out KO zebrafish embryos at 24 hpf.         WT24hpfcontrol2   breed:natural spawning of AB adults|age:24hpf|dev stage:adult|collection date:2021 03 19|geo loc name:USA:San Francisco|sex:not determined|tissue:WT24hpfcontrol2 embryo|BioSampleModel:Model organism or animal                 RNA seq of Wild type zebrafish : 12 embryos in total 2 4mg WT24hpfcontrol2 R WT24hpfcontrol2 R Wild type zebrafish     RNA-Seq TRANSCRIPTOMIC PCR PAIRED ILLUMINA Illumina HiSeq 1000   SRP532179     WT24hpfcontrol2_R1.clean.fq.gz WT24hpfcontrol2_R2.clean.fq.gz fastq fastq 5408273952.0 21601107.0 WT24hpfcontrol2 R1.clean.fq.gz 0:125.19 1:125.18 A:1510365712;C:1201646307;G:1204419555;T:1491793767;N:48611 125 125     1510365712 1201646307 1204419555 1491793767 48611 SRX26062506 SRS22631690 SRA1970017 Huazhong Agricultural University, China|Department of Neurosurgery Huazhong Agricultural University, China                       B B biological fallback assumption illumina hiseq_era unknown random_priming unknown bulk unknown unknown   China 2024-09-11 Multi-stage Multi-stage Embryo Imprecise All anatomical structures
33732 33732 SRR30640705 SRX26062505 SRS22631689 SRP532179 PRJNA1159911 Peri Centriolar Material 1 regulates polarized endosome dynamics and neural progenitor fate PRJNA1159911 Other RNA seq was performed on control and maternal zygotic developmentally defective pcm1 morphants MO and pcm1 knock out KO zebrafish embryos at 24 hpf.         PCM1KOcompensate2   breed:Tg [HuC:GFP|age:24hpf|dev stage:adult|collection date:2021 03 19|geo loc name:USA:San Francisco|sex:not determined|tissue:PCM1KOcompensate2 embryo|BioSampleModel:Model organism or animal                 RNA seq of pcm1 KO compensate zebrafish : 12 embryos in total 2 4mg PCM1KOcompensate2 R PCM1KOcompensate2 R pcm1 KO compensate zebrafish     RNA-Seq TRANSCRIPTOMIC PCR PAIRED ILLUMINA Illumina HiSeq 1000   SRP532179     PCM1KOcompensate2_R1.clean.fq.gz PCM1KOcompensate2_R2.clean.fq.gz fastq fastq 5996379188.0 22765993.0 PCM1KOcompensate2 R1.clean.fq.gz 0:131.70 1:131.70 A:1669800521;C:1339211911;G:1342418096;T:1644890999;N:57661 131 131     1669800521 1339211911 1342418096 1644890999 57661 SRX26062505 SRS22631689 SRA1970017 Huazhong Agricultural University, China|Department of Neurosurgery Huazhong Agricultural University, China                       B B biological fallback assumption illumina hiseq_era unknown random_priming unknown bulk unknown unknown   China 2024-09-11 Multi-stage Multi-stage Embryo Imprecise All anatomical structures
33733 33733 SRR30640706 SRX26062504 SRS22631688 SRP532179 PRJNA1159911 Peri Centriolar Material 1 regulates polarized endosome dynamics and neural progenitor fate PRJNA1159911 Other RNA seq was performed on control and maternal zygotic developmentally defective pcm1 morphants MO and pcm1 knock out KO zebrafish embryos at 24 hpf.         PCM1KOcompensate1   breed:Tg [HuC:GFP|age:24hpf|dev stage:adult|collection date:2021 03 19|geo loc name:USA:San Francisco|sex:not determined|tissue:PCM1KOcompensate1 embryo|BioSampleModel:Model organism or animal                 RNA seq of pcm1 KO compensate zebrafish : 12 embryos in total 2 3mg PCM1KOcompensate1 R PCM1KOcompensate1 R pcm1 KO compensate zebrafish     RNA-Seq TRANSCRIPTOMIC PCR PAIRED ILLUMINA Illumina HiSeq 1000   SRP532179     PCM1KOcompensate1_R1.clean.fq.gz PCM1KOcompensate1_R2.clean.fq.gz fastq fastq 5594219881.0 21191291.0 PCM1KOcompensate1 R1.clean.fq.gz 0:131.99 1:131.99 A:1594003450;C:1214578517;G:1215705001;T:1569880851;N:52062 131 131     1594003450 1214578517 1215705001 1569880851 52062 SRX26062504 SRS22631688 SRA1970017 Huazhong Agricultural University, China|Department of Neurosurgery Huazhong Agricultural University, China                       B B biological fallback assumption illumina hiseq_era unknown random_priming unknown bulk unknown unknown   China 2024-09-11 Multi-stage Multi-stage 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");;