run_metadata
8 rows where experiment.library_selection = "PolyA", technology = "bulk" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6 | 6 | DRR315802 | DRX305194 | DRS231989 | DRP008318 | PRJDB12206 | Transcriptome analysis of strip1 mutant and wildtype zebrafish eyes | DRP008318 | Transcriptome Analysis | Strip1 plays essential roles in the developing zebrafish retinal neural circuit. To identify the underlying molecular mechanisms at the transcriptomic level transcriptome of strip1 mutant "rw147" eye cups at 2.5 dpf was compared to that of wild type siblings using bulk RNA sequencing analysis. | wildtype sibling sample4 | SAMD00400823 | sample name:rw147 2.5dpf wildtype rep 4|biological replicate:4 | Illumina NovaSeq 6000 paired end sequencing of SAMD00400823 | DRX305194 | 1 | 1 | 1 | RNA-Seq | TRANSCRIPTOMIC | PolyA | PAIRED | ILLUMINA | Illumina NovaSeq 6000 | <SPOT_DESCRIPTOR><SPOT_DECODE_SPEC><SPOT_LENGTH>151</SPOT_LENGTH><READ_SPEC><READ_INDEX>0</READ_INDEX><READ_CLASS>Application Read</READ_CLASS><READ_TYPE>Forward</READ_TYPE><BASE_COORD>1</BASE_COORD></READ_SPEC><READ_SPEC><READ_INDEX>1</READ_INDEX><READ_CLASS>Application Read</READ_CLASS><READ_TYPE>Reverse</READ_TYPE><BASE_COORD>76</BASE_COORD></READ_SPEC></SPOT_DECODE_SPEC></SPOT_DESCRIPTOR> | DRP008318 | Illumina NovaSeq 6000 paired end sequencing of SAMD00400823 | 10262353995.0 | 34151547.0 | DRR315802 | 0:150.27 1:150.22 | A:2735078560;C:2386126821;G:2433638250;T:2707202814;N:307550 | 150 | 150 | 2735078560 | 2386126821 | 2433638250 | 2707202814 | 307550 | DRX305194 | DRS231989 | DRA012640 | OIST|Developmental Neurobiology Unit | Developmental Neurobiology Unit | 2 | 0.95231 | 0.95295 | 0.09229 | 0.08773 | 0.71819 | 0.72107 | 0.46746 | 0.46617 | 151 | 150 | B | B | biological fallback assumption | illumina | novaseq_era | unknown | poly_a | unknown | bulk | bulk | bulk | Unknown | 2022-03-16 | Hatching | Embryo | Undetermined | Embryo Imprecise | |||||||||||||||||||
| 7 | 7 | DRR315801 | DRX305193 | DRS231988 | DRP008318 | PRJDB12206 | Transcriptome analysis of strip1 mutant and wildtype zebrafish eyes | DRP008318 | Transcriptome Analysis | Strip1 plays essential roles in the developing zebrafish retinal neural circuit. To identify the underlying molecular mechanisms at the transcriptomic level transcriptome of strip1 mutant "rw147" eye cups at 2.5 dpf was compared to that of wild type siblings using bulk RNA sequencing analysis. | wildtype sibling sample3 | SAMD00400822 | sample name:rw147 2.5dpf wildtype rep 3|biological replicate:3 | Illumina NovaSeq 6000 paired end sequencing of SAMD00400822 | DRX305193 | 1 | 1 | 1 | RNA-Seq | TRANSCRIPTOMIC | PolyA | PAIRED | ILLUMINA | Illumina NovaSeq 6000 | <SPOT_DESCRIPTOR><SPOT_DECODE_SPEC><SPOT_LENGTH>151</SPOT_LENGTH><READ_SPEC><READ_INDEX>0</READ_INDEX><READ_CLASS>Application Read</READ_CLASS><READ_TYPE>Forward</READ_TYPE><BASE_COORD>1</BASE_COORD></READ_SPEC><READ_SPEC><READ_INDEX>1</READ_INDEX><READ_CLASS>Application Read</READ_CLASS><READ_TYPE>Reverse</READ_TYPE><BASE_COORD>76</BASE_COORD></READ_SPEC></SPOT_DECODE_SPEC></SPOT_DESCRIPTOR> | DRP008318 | Illumina NovaSeq 6000 paired end sequencing of SAMD00400822 | 11516368634.0 | 38355888.0 | DRR315801 | 0:150.15 1:150.10 | A:3080341643;C:2678048339;G:2713051368;T:3044449330;N:477954 | 150 | 150 | 3080341643 | 2678048339 | 2713051368 | 3044449330 | 477954 | DRX305193 | DRS231988 | DRA012640 | OIST|Developmental Neurobiology Unit | Developmental Neurobiology Unit | 2 | 0.95353 | 0.95634 | 0.08909 | 0.08533 | 0.71374 | 0.71252 | 0.45986 | 0.46059 | 150 | 151 | B | B | biological fallback assumption | illumina | novaseq_era | unknown | poly_a | unknown | bulk | bulk | bulk | Unknown | 2022-03-16 | Hatching | Embryo | Undetermined | Embryo Imprecise | |||||||||||||||||||
| 8 | 8 | DRR315800 | DRX305192 | DRS231987 | DRP008318 | PRJDB12206 | Transcriptome analysis of strip1 mutant and wildtype zebrafish eyes | DRP008318 | Transcriptome Analysis | Strip1 plays essential roles in the developing zebrafish retinal neural circuit. To identify the underlying molecular mechanisms at the transcriptomic level transcriptome of strip1 mutant "rw147" eye cups at 2.5 dpf was compared to that of wild type siblings using bulk RNA sequencing analysis. | wildtype sibling sample2 | SAMD00400821 | sample name:rw147 2.5dpf wildtype rep 2|biological replicate:2 | Illumina NovaSeq 6000 paired end sequencing of SAMD00400821 | DRX305192 | 1 | 1 | 1 | RNA-Seq | TRANSCRIPTOMIC | PolyA | PAIRED | ILLUMINA | Illumina NovaSeq 6000 | <SPOT_DESCRIPTOR><SPOT_DECODE_SPEC><SPOT_LENGTH>151</SPOT_LENGTH><READ_SPEC><READ_INDEX>0</READ_INDEX><READ_CLASS>Application Read</READ_CLASS><READ_TYPE>Forward</READ_TYPE><BASE_COORD>1</BASE_COORD></READ_SPEC><READ_SPEC><READ_INDEX>1</READ_INDEX><READ_CLASS>Application Read</READ_CLASS><READ_TYPE>Reverse</READ_TYPE><BASE_COORD>76</BASE_COORD></READ_SPEC></SPOT_DECODE_SPEC></SPOT_DESCRIPTOR> | DRP008318 | Illumina NovaSeq 6000 paired end sequencing of SAMD00400821 | 8814057148.0 | 29367513.0 | DRR315800 | 0:150.09 1:150.04 | A:2350403211;C:2054073465;G:2083044327;T:2326181188;N:354957 | 150 | 150 | 2350403211 | 2054073465 | 2083044327 | 2326181188 | 354957 | DRX305192 | DRS231987 | DRA012640 | OIST|Developmental Neurobiology Unit | Developmental Neurobiology Unit | 2 | 0.95287 | 0.95643 | 0.0891 | 0.08586 | 0.70309 | 0.70252 | 0.46384 | 0.46281 | 151 | 149 | B | B | biological fallback assumption | illumina | novaseq_era | unknown | poly_a | unknown | bulk | bulk | bulk | Unknown | 2022-03-16 | Hatching | Embryo | Undetermined | Embryo Imprecise | |||||||||||||||||||
| 9 | 9 | DRR315799 | DRX305191 | DRS231986 | DRP008318 | PRJDB12206 | Transcriptome analysis of strip1 mutant and wildtype zebrafish eyes | DRP008318 | Transcriptome Analysis | Strip1 plays essential roles in the developing zebrafish retinal neural circuit. To identify the underlying molecular mechanisms at the transcriptomic level transcriptome of strip1 mutant "rw147" eye cups at 2.5 dpf was compared to that of wild type siblings using bulk RNA sequencing analysis. | wildtype sibling sample1 | SAMD00400820 | sample name:rw147 2.5dpf wildtype rep 1|biological replicate:1 | Illumina NovaSeq 6000 paired end sequencing of SAMD00400820 | DRX305191 | 1 | 1 | 1 | RNA-Seq | TRANSCRIPTOMIC | PolyA | PAIRED | ILLUMINA | Illumina NovaSeq 6000 | <SPOT_DESCRIPTOR><SPOT_DECODE_SPEC><SPOT_LENGTH>151</SPOT_LENGTH><READ_SPEC><READ_INDEX>0</READ_INDEX><READ_CLASS>Application Read</READ_CLASS><READ_TYPE>Forward</READ_TYPE><BASE_COORD>1</BASE_COORD></READ_SPEC><READ_SPEC><READ_INDEX>1</READ_INDEX><READ_CLASS>Application Read</READ_CLASS><READ_TYPE>Reverse</READ_TYPE><BASE_COORD>76</BASE_COORD></READ_SPEC></SPOT_DECODE_SPEC></SPOT_DESCRIPTOR> | DRP008318 | Illumina NovaSeq 6000 paired end sequencing of SAMD00400820 | 10491955578.0 | 34900682.0 | DRR315799 | 0:150.34 1:150.28 | A:2796521111;C:2446218287;G:2483414564;T:2765477785;N:323831 | 150 | 150 | 2796521111 | 2446218287 | 2483414564 | 2765477785 | 323831 | DRX305191 | DRS231986 | DRA012640 | OIST|Developmental Neurobiology Unit | Developmental Neurobiology Unit | 2 | 0.9539 | 0.95646 | 0.08185 | 0.07808 | 0.70025 | 0.70013 | 0.44713 | 0.44987 | 150 | 151 | B | B | biological fallback assumption | illumina | novaseq_era | unknown | poly_a | unknown | bulk | bulk | bulk | Unknown | 2022-03-16 | Hatching | Embryo | Undetermined | Embryo Imprecise | |||||||||||||||||||
| 10 | 10 | DRR315798 | DRX305190 | DRS231985 | DRP008318 | PRJDB12206 | Transcriptome analysis of strip1 mutant and wildtype zebrafish eyes | DRP008318 | Transcriptome Analysis | Strip1 plays essential roles in the developing zebrafish retinal neural circuit. To identify the underlying molecular mechanisms at the transcriptomic level transcriptome of strip1 mutant "rw147" eye cups at 2.5 dpf was compared to that of wild type siblings using bulk RNA sequencing analysis. | strip1 mutant sample4 | SAMD00400819 | sample name:rw147 2.5dpf Mutant rep 4|biological replicate:4 | Illumina NovaSeq 6000 paired end sequencing of SAMD00400819 | DRX305190 | 1 | 1 | 1 | RNA-Seq | TRANSCRIPTOMIC | PolyA | PAIRED | ILLUMINA | Illumina NovaSeq 6000 | <SPOT_DESCRIPTOR><SPOT_DECODE_SPEC><SPOT_LENGTH>151</SPOT_LENGTH><READ_SPEC><READ_INDEX>0</READ_INDEX><READ_CLASS>Application Read</READ_CLASS><READ_TYPE>Forward</READ_TYPE><BASE_COORD>1</BASE_COORD></READ_SPEC><READ_SPEC><READ_INDEX>1</READ_INDEX><READ_CLASS>Application Read</READ_CLASS><READ_TYPE>Reverse</READ_TYPE><BASE_COORD>76</BASE_COORD></READ_SPEC></SPOT_DECODE_SPEC></SPOT_DESCRIPTOR> | DRP008318 | Illumina NovaSeq 6000 paired end sequencing of SAMD00400819 | 9197802250.0 | 30604326.0 | DRR315798 | 0:150.30 1:150.24 | A:2468967963;C:2130949980;G:2158692262;T:2438931017;N:261028 | 150 | 150 | 2468967963 | 2130949980 | 2158692262 | 2438931017 | 261028 | DRX305190 | DRS231985 | DRA012640 | OIST|Developmental Neurobiology Unit | Developmental Neurobiology Unit | 2 | 0.95159 | 0.95439 | 0.10146 | 0.09758 | 0.71995 | 0.71983 | 0.46519 | 0.46797 | 150 | 151 | B | B | biological fallback assumption | illumina | novaseq_era | unknown | poly_a | unknown | bulk | bulk | bulk | Unknown | 2022-03-16 | Hatching | Embryo | Undetermined | Embryo Imprecise | |||||||||||||||||||
| 11 | 11 | DRR315797 | DRX305189 | DRS231984 | DRP008318 | PRJDB12206 | Transcriptome analysis of strip1 mutant and wildtype zebrafish eyes | DRP008318 | Transcriptome Analysis | Strip1 plays essential roles in the developing zebrafish retinal neural circuit. To identify the underlying molecular mechanisms at the transcriptomic level transcriptome of strip1 mutant "rw147" eye cups at 2.5 dpf was compared to that of wild type siblings using bulk RNA sequencing analysis. | strip1 mutant sample3 | SAMD00400818 | sample name:rw147 2.5dpf Mutant rep 3|biological replicate:3 | Illumina NovaSeq 6000 paired end sequencing of SAMD00400818 | DRX305189 | 1 | 1 | 1 | RNA-Seq | TRANSCRIPTOMIC | PolyA | PAIRED | ILLUMINA | Illumina NovaSeq 6000 | <SPOT_DESCRIPTOR><SPOT_DECODE_SPEC><SPOT_LENGTH>151</SPOT_LENGTH><READ_SPEC><READ_INDEX>0</READ_INDEX><READ_CLASS>Application Read</READ_CLASS><READ_TYPE>Forward</READ_TYPE><BASE_COORD>1</BASE_COORD></READ_SPEC><READ_SPEC><READ_INDEX>1</READ_INDEX><READ_CLASS>Application Read</READ_CLASS><READ_TYPE>Reverse</READ_TYPE><BASE_COORD>76</BASE_COORD></READ_SPEC></SPOT_DECODE_SPEC></SPOT_DESCRIPTOR> | DRP008318 | Illumina NovaSeq 6000 paired end sequencing of SAMD00400818 | 10498982078.0 | 34931731.0 | DRR315797 | 0:150.31 1:150.25 | A:2804535103;C:2445295179;G:2478768789;T:2770066062;N:316945 | 150 | 150 | 2804535103 | 2445295179 | 2478768789 | 2770066062 | 316945 | DRX305189 | DRS231984 | DRA012640 | OIST|Developmental Neurobiology Unit | Developmental Neurobiology Unit | 2 | 0.95448 | 0.95652 | 0.0939 | 0.0887 | 0.71796 | 0.71847 | 0.46335 | 0.46615 | 151 | 151 | B | B | biological fallback assumption | illumina | novaseq_era | unknown | poly_a | unknown | bulk | bulk | bulk | Unknown | 2022-03-16 | Hatching | Embryo | Undetermined | Embryo Imprecise | |||||||||||||||||||
| 12 | 12 | DRR315796 | DRX305188 | DRS231983 | DRP008318 | PRJDB12206 | Transcriptome analysis of strip1 mutant and wildtype zebrafish eyes | DRP008318 | Transcriptome Analysis | Strip1 plays essential roles in the developing zebrafish retinal neural circuit. To identify the underlying molecular mechanisms at the transcriptomic level transcriptome of strip1 mutant "rw147" eye cups at 2.5 dpf was compared to that of wild type siblings using bulk RNA sequencing analysis. | strip1 mutant sample2 | SAMD00400817 | sample name:rw147 2.5dpf Mutant rep 2|biological replicate:2 | Illumina NovaSeq 6000 paired end sequencing of SAMD00400817 | DRX305188 | 1 | 1 | 1 | RNA-Seq | TRANSCRIPTOMIC | PolyA | PAIRED | ILLUMINA | Illumina NovaSeq 6000 | <SPOT_DESCRIPTOR><SPOT_DECODE_SPEC><SPOT_LENGTH>151</SPOT_LENGTH><READ_SPEC><READ_INDEX>0</READ_INDEX><READ_CLASS>Application Read</READ_CLASS><READ_TYPE>Forward</READ_TYPE><BASE_COORD>1</BASE_COORD></READ_SPEC><READ_SPEC><READ_INDEX>1</READ_INDEX><READ_CLASS>Application Read</READ_CLASS><READ_TYPE>Reverse</READ_TYPE><BASE_COORD>76</BASE_COORD></READ_SPEC></SPOT_DECODE_SPEC></SPOT_DESCRIPTOR> | DRP008318 | Illumina NovaSeq 6000 paired end sequencing of SAMD00400817 | 9850145990.0 | 32782079.0 | DRR315796 | 0:150.26 1:150.21 | A:2636205537;C:2286508705;G:2319481100;T:2607600624;N:350024 | 150 | 150 | 2636205537 | 2286508705 | 2319481100 | 2607600624 | 350024 | DRX305188 | DRS231983 | DRA012640 | OIST|Developmental Neurobiology Unit | Developmental Neurobiology Unit | 2 | 0.95193 | 0.95472 | 0.09722 | 0.09375 | 0.7138 | 0.71299 | 0.45542 | 0.45994 | 151 | 151 | B | B | biological fallback assumption | illumina | novaseq_era | unknown | poly_a | unknown | bulk | bulk | bulk | Unknown | 2022-03-16 | Hatching | Embryo | Undetermined | Embryo Imprecise | |||||||||||||||||||
| 13 | 13 | DRR315795 | DRX305187 | DRS231982 | DRP008318 | PRJDB12206 | Transcriptome analysis of strip1 mutant and wildtype zebrafish eyes | DRP008318 | Transcriptome Analysis | Strip1 plays essential roles in the developing zebrafish retinal neural circuit. To identify the underlying molecular mechanisms at the transcriptomic level transcriptome of strip1 mutant "rw147" eye cups at 2.5 dpf was compared to that of wild type siblings using bulk RNA sequencing analysis. | strip1 mutant sample1 | SAMD00400816 | sample name:rw147 2.5dpf Mutant rep 1|biological replicate:1 | Illumina NovaSeq 6000 paired end sequencing of SAMD00400816 | DRX305187 | 1 | 1 | 1 | RNA-Seq | TRANSCRIPTOMIC | PolyA | PAIRED | ILLUMINA | Illumina NovaSeq 6000 | <SPOT_DESCRIPTOR><SPOT_DECODE_SPEC><SPOT_LENGTH>151</SPOT_LENGTH><READ_SPEC><READ_INDEX>0</READ_INDEX><READ_CLASS>Application Read</READ_CLASS><READ_TYPE>Forward</READ_TYPE><BASE_COORD>1</BASE_COORD></READ_SPEC><READ_SPEC><READ_INDEX>1</READ_INDEX><READ_CLASS>Application Read</READ_CLASS><READ_TYPE>Reverse</READ_TYPE><BASE_COORD>76</BASE_COORD></READ_SPEC></SPOT_DECODE_SPEC></SPOT_DESCRIPTOR> | DRP008318 | Illumina NovaSeq 6000 paired end sequencing of SAMD00400816 | 9542039835.0 | 31780260.0 | DRR315795 | 0:150.15 1:150.10 | A:2543384204;C:2224374632;G:2258183435;T:2515655339;N:442225 | 150 | 150 | 2543384204 | 2224374632 | 2258183435 | 2515655339 | 442225 | DRX305187 | DRS231982 | DRA012640 | OIST|Developmental Neurobiology Unit | Developmental Neurobiology Unit | 2 | 0.9528 | 0.95591 | 0.08656 | 0.0828 | 0.70352 | 0.70331 | 0.45316 | 0.44914 | 151 | 151 | B | B | biological fallback assumption | illumina | novaseq_era | unknown | poly_a | unknown | bulk | bulk | bulk | Unknown | 2022-03-16 | Hatching | Embryo | Undetermined | Embryo Imprecise |
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");;