run_metadata
12 rows where experiment.library_layout = "SINGLE", experiment.library_selection = "PCR" and tissue_curation_coarse = "Reproductive 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 64249 | 64249 | SRR14373546 | SRX10725858 | SRS8815710 | SRP318063 | PRJNA726592 | GH overexpression on gonadal microRNAome profile in zebrafish males | PRJNA726592 | Other | Evaluate computationally the kinetic parameters as well as to identify and quantify the set of miRNAs of the spermatozoa from gh transgenic gh+ and non transgenic NT zebrafish that may be correlated with low spermatic quality. | gh transgenic 6 | GH3 | strain:F0104|age:15 month|dev stage:adult|sex:male|tissue:gonadal|biological replicate:6|BioSampleModel:Model organism or animal | miRNA Seq of Danio rerio: adult male gonad | GH3 | GH3 | NEBNext Small RNA Library Prep Set | miRNA-Seq | TRANSCRIPTOMIC | PCR | SINGLE | ILLUMINA | Illumina MiSeq | SRP318063 | PoolUFPEL-GH6.fastq | fastq | 20104659.0 | 394209.0 | PoolUFPEL GH6.fastq | 0:51 1:0 | A:4462767;C:4536250;G:6471518;T:4633666;N:458 | 51 | 0 | 4462767 | 4536250 | 6471518 | 4633666 | 458 | SRX10725858 | SRS8815710 | SRA1226279 | Universidade Federal de Pelotas|CDTec | Universidade Federal de Pelotas | 1 | 0.80185 | 0.21091 | 0.91547 | 0.57044 | 51 | B | usable mapping rate | illumina | miseq | unknown | random_priming | nebnext | bulk | unknown | unknown | Brazil | 2021-04-30 | Adult | Adult | Gonad | Reproductive System | ||||||||||||||||||||||||||
| 64250 | 64250 | SRR14373547 | SRX10725857 | SRS8815709 | SRP318063 | PRJNA726592 | GH overexpression on gonadal microRNAome profile in zebrafish males | PRJNA726592 | Other | Evaluate computationally the kinetic parameters as well as to identify and quantify the set of miRNAs of the spermatozoa from gh transgenic gh+ and non transgenic NT zebrafish that may be correlated with low spermatic quality. | gh transgenic 4 | GH2 | strain:F0104|age:15 month|dev stage:adult|sex:male|tissue:gonadal|biological replicate:5|BioSampleModel:Model organism or animal | miRNA Seq of Danio rerio: adult male gonad | GH2 | GH2 | NEBNext Small RNA Library Prep Set | miRNA-Seq | TRANSCRIPTOMIC | PCR | SINGLE | ILLUMINA | Illumina MiSeq | SRP318063 | PoolUFPEL-GH4.fastq | fastq | 136130934.0 | 2669234.0 | PoolUFPEL GH4.fastq | 0:51 1:0 | A:31505752;C:32606264;G:41632000;T:30383900;N:3018 | 51 | 0 | 31505752 | 32606264 | 41632000 | 30383900 | 3018 | SRX10725857 | SRS8815709 | SRA1226279 | Universidade Federal de Pelotas|CDTec | Universidade Federal de Pelotas | 1 | 0.78619 | 0.26843 | 0.87834 | 0.48728 | 51 | B | usable mapping rate | illumina | miseq | unknown | random_priming | nebnext | bulk | unknown | unknown | Brazil | 2021-04-30 | Adult | Adult | Gonad | Reproductive System | ||||||||||||||||||||||||||
| 64251 | 64251 | SRR14373548 | SRX10725856 | SRS8815708 | SRP318063 | PRJNA726592 | GH overexpression on gonadal microRNAome profile in zebrafish males | PRJNA726592 | Other | Evaluate computationally the kinetic parameters as well as to identify and quantify the set of miRNAs of the spermatozoa from gh transgenic gh+ and non transgenic NT zebrafish that may be correlated with low spermatic quality. | gh transgenic 3 | GH1 | strain:F0104|age:15 month|dev stage:adult|sex:male|tissue:gonadal|biological replicate:4|BioSampleModel:Model organism or animal | miRNA Seq of Danio rerio: adult male gonad | GH1 | GH1 | NEBNext Small RNA Library Prep Set | miRNA-Seq | TRANSCRIPTOMIC | PCR | SINGLE | ILLUMINA | Illumina MiSeq | SRP318063 | PoolUFPEL-GH3.fastq | fastq | 364152699.0 | 7140249.0 | PoolUFPEL GH3.fastq | 0:51 1:0 | A:79211373;C:83789471;G:117772711;T:83370974;N:8170 | 51 | 0 | 79211373 | 83789471 | 117772711 | 83370974 | 8170 | SRX10725856 | SRS8815708 | SRA1226279 | Universidade Federal de Pelotas|CDTec | Universidade Federal de Pelotas | 1 | 0.80843 | 0.18707 | 0.92066 | 0.59133 | 51 | B | usable mapping rate | illumina | miseq | unknown | random_priming | nebnext | bulk | unknown | unknown | Brazil | 2021-04-30 | Adult | Adult | Gonad | Reproductive System | ||||||||||||||||||||||||||
| 64252 | 64252 | SRR14373549 | SRX10725855 | SRS8815707 | SRP318063 | PRJNA726592 | GH overexpression on gonadal microRNAome profile in zebrafish males | PRJNA726592 | Other | Evaluate computationally the kinetic parameters as well as to identify and quantify the set of miRNAs of the spermatozoa from gh transgenic gh+ and non transgenic NT zebrafish that may be correlated with low spermatic quality. | Non transgenic 5 | NT3 | strain:F0104|age:15 month|dev stage:adult|sex:male|tissue:gonadal|biological replicate:3|BioSampleModel:Model organism or animal | miRNA Seq of Danio rerio: adult male gonad | NT3 | NT3 | NEBNext Small RNA Library Prep Set | miRNA-Seq | TRANSCRIPTOMIC | PCR | SINGLE | ILLUMINA | Illumina MiSeq | SRP318063 | PoolUFPEL-NT5.fastq | fastq | 234366114.0 | 4595414.0 | PoolUFPEL NT5.fastq | 0:51 1:0 | A:58011123;C:51898677;G:69581397;T:54869614;N:5303 | 51 | 0 | 58011123 | 51898677 | 69581397 | 54869614 | 5303 | SRX10725855 | SRS8815707 | SRA1226279 | Universidade Federal de Pelotas|CDTec | Universidade Federal de Pelotas | 1 | 0.83352 | 0.35958 | 0.85928 | 0.50004 | 51 | B | usable mapping rate | illumina | miseq | unknown | random_priming | nebnext | bulk | unknown | unknown | Brazil | 2021-04-30 | Adult | Adult | Gonad | Reproductive System | ||||||||||||||||||||||||||
| 64253 | 64253 | SRR14373550 | SRX10725854 | SRS8815706 | SRP318063 | PRJNA726592 | GH overexpression on gonadal microRNAome profile in zebrafish males | PRJNA726592 | Other | Evaluate computationally the kinetic parameters as well as to identify and quantify the set of miRNAs of the spermatozoa from gh transgenic gh+ and non transgenic NT zebrafish that may be correlated with low spermatic quality. | Non transgenic 3 | NT2 | strain:F0104|age:15 month|dev stage:adult|sex:male|tissue:gonadal|biological replicate:2|BioSampleModel:Model organism or animal | miRNA Seq of Danio rerio: adult male gonad | NT2 | NT2 | NEBNext Small RNA Library Prep Set | miRNA-Seq | TRANSCRIPTOMIC | PCR | SINGLE | ILLUMINA | Illumina MiSeq | SRP318063 | PoolUFPEL-NT3.fastq | fastq | 147963750.0 | 2901250.0 | PoolUFPEL NT3.fastq | 0:51 1:0 | A:37528568;C:33498521;G:41979920;T:34953411;N:3330 | 51 | 0 | 37528568 | 33498521 | 41979920 | 34953411 | 3330 | SRX10725854 | SRS8815706 | SRA1226279 | Universidade Federal de Pelotas|CDTec | Universidade Federal de Pelotas | 1 | 0.75277 | 0.34872 | 0.86596 | 0.53154 | 51 | B | usable mapping rate | illumina | miseq | unknown | random_priming | nebnext | bulk | unknown | unknown | Brazil | 2021-04-30 | Adult | Adult | Gonad | Reproductive System | ||||||||||||||||||||||||||
| 64254 | 64254 | SRR14373551 | SRX10725853 | SRS8815705 | SRP318063 | PRJNA726592 | GH overexpression on gonadal microRNAome profile in zebrafish males | PRJNA726592 | Other | Evaluate computationally the kinetic parameters as well as to identify and quantify the set of miRNAs of the spermatozoa from gh transgenic gh+ and non transgenic NT zebrafish that may be correlated with low spermatic quality. | Non transgenic 1 | NT1 | strain:F0104|age:15 month|dev stage:adult|sex:male|tissue:gonadal|biological replicate:1|BioSampleModel:Model organism or animal | miRNA Seq of Danio rerio: adult male gonad | NT1 | NT1 | NEBNext Small RNA Library Prep Set | miRNA-Seq | TRANSCRIPTOMIC | PCR | SINGLE | ILLUMINA | Illumina MiSeq | SRP318063 | PoolUFPEL-NT1.fastq | fastq | 218363538.0 | 4281638.0 | PoolUFPEL NT1.fastq | 0:51 1:0 | A:53115431;C:47639482;G:65248144;T:52355651;N:4830 | 51 | 0 | 53115431 | 47639482 | 65248144 | 52355651 | 4830 | SRX10725853 | SRS8815705 | SRA1226279 | Universidade Federal de Pelotas|CDTec | Universidade Federal de Pelotas | 1 | 0.83996 | 0.3606 | 0.87728 | 0.50828 | 51 | B | usable mapping rate | illumina | miseq | unknown | random_priming | nebnext | bulk | unknown | unknown | Brazil | 2021-04-30 | Adult | Adult | Gonad | Reproductive System | ||||||||||||||||||||||||||
| 76734 | 76734 | SRR25361306 | SRX21100653 | SRS18369835 | SRP450509 | PRJNA996758 | Transcriptome analysis of Zebrafish testis | PRJNA996758 | Other | In summary this study obtained whole transcriptome data of mature testis of triploid zebrafish by RNA seq which provided a data platform for the study of reproductive development of triploid fish. Screening and identification of miRNAs related to spermatogenesis in zebrafish. | Zebrafish 3N 3 | strain:not collected|age:3 mpf|collection date:not collected|geo loc name:not applicable|sex:male|tissue:testis|replicate:biological replicate 6|BioSampleModel:Model organism or animal | miRNA Seq of triploid zebrafish: mature testis 3 | S06 | S06 | small RNA Sample Pre Kit | miRNA-Seq | TRANSCRIPTOMIC | PCR | SINGLE | ILLUMINA | HiSeq X Ten | SRP450509 | Zebrafish-3N-3.fq | fastq | 377566667.0 | 15350070.0 | Zebrafish 3N 3.fq | 0:24.60 | A:96137966;C:76631652;G:87723617;T:117047567;N:25865 | 24 | 96137966 | 76631652 | 87723617 | 117047567 | 25865 | SRX21100653 | SRS18369835 | SRA1676237 | Hunan Normal University|College of Life Sciences | Hunan Normal University | 1 | 0.73654 | 0.40118 | 0.8564 | 0.55134 | 20 | B | usable mapping rate | illumina | hiseq_era | full_length | random_priming | unknown | bulk | unknown | unknown | China | 2023-07-20 | Adult | Adult | Gonad | Reproductive System | ||||||||||||||||||||||||||||
| 76735 | 76735 | SRR25361307 | SRX21100652 | SRS18369834 | SRP450509 | PRJNA996758 | Transcriptome analysis of Zebrafish testis | PRJNA996758 | Other | In summary this study obtained whole transcriptome data of mature testis of triploid zebrafish by RNA seq which provided a data platform for the study of reproductive development of triploid fish. Screening and identification of miRNAs related to spermatogenesis in zebrafish. | Zebrafish 3N 2 | strain:not collected|age:3 mpf|collection date:not collected|geo loc name:not applicable|sex:male|tissue:testis|replicate:biological replicate 5|BioSampleModel:Model organism or animal | miRNA Seq of triploid zebrafish: mature testis 2 | S05 | S05 | small RNA Sample Pre Kit | miRNA-Seq | TRANSCRIPTOMIC | PCR | SINGLE | ILLUMINA | HiSeq X Ten | SRP450509 | Zebrafish-3N-2.fq | fastq | 380484856.0 | 15447197.0 | Zebrafish 3N 2.fq | 0:24.63 | A:97242128;C:77738745;G:86938175;T:118539773;N:26035 | 24 | 97242128 | 77738745 | 86938175 | 118539773 | 26035 | SRX21100652 | SRS18369834 | SRA1676237 | Hunan Normal University|College of Life Sciences | Hunan Normal University | 1 | 0.75732 | 0.36733 | 0.86003 | 0.56474 | 30 | B | usable mapping rate | illumina | hiseq_era | full_length | random_priming | unknown | bulk | unknown | unknown | China | 2023-07-20 | Adult | Adult | Gonad | Reproductive System | ||||||||||||||||||||||||||||
| 76736 | 76736 | SRR25361308 | SRX21100651 | SRS18369833 | SRP450509 | PRJNA996758 | Transcriptome analysis of Zebrafish testis | PRJNA996758 | Other | In summary this study obtained whole transcriptome data of mature testis of triploid zebrafish by RNA seq which provided a data platform for the study of reproductive development of triploid fish. Screening and identification of miRNAs related to spermatogenesis in zebrafish. | Zebrafish 3N 1 | strain:not collected|age:3 mpf|collection date:not collected|geo loc name:not applicable|sex:male|tissue:testis|replicate:biological replicate 4|BioSampleModel:Model organism or animal | miRNA Seq of triploid zebrafish: mature testis 1 | S04 | S04 | small RNA Sample Pre Kit | miRNA-Seq | TRANSCRIPTOMIC | PCR | SINGLE | ILLUMINA | HiSeq X Ten | SRP450509 | Zebrafish-3N-1.fq | fastq | 268097774.0 | 10780393.0 | Zebrafish 3N 1.fq | 0:24.87 | A:68574209;C:53994512;G:62001426;T:83509528;N:18099 | 24 | 68574209 | 53994512 | 62001426 | 83509528 | 18099 | SRX21100651 | SRS18369833 | SRA1676237 | Hunan Normal University|College of Life Sciences | Hunan Normal University | 1 | 0.76185 | 0.39184 | 0.86038 | 0.55005 | 27 | B | usable mapping rate | illumina | hiseq_era | full_length | random_priming | unknown | bulk | unknown | unknown | China | 2023-07-20 | Adult | Adult | Gonad | Reproductive System | ||||||||||||||||||||||||||||
| 76737 | 76737 | SRR25361309 | SRX21100650 | SRS18369832 | SRP450509 | PRJNA996758 | Transcriptome analysis of Zebrafish testis | PRJNA996758 | Other | In summary this study obtained whole transcriptome data of mature testis of triploid zebrafish by RNA seq which provided a data platform for the study of reproductive development of triploid fish. Screening and identification of miRNAs related to spermatogenesis in zebrafish. | Zebrafish 2N 3 | strain:not collected|age:3 mpf|collection date:not collected|geo loc name:not applicable|sex:male|tissue:testis|replicate:biological replicate 3|BioSampleModel:Model organism or animal | miRNA Seq of diploid zebrafish: mature testis 3 | S03 | S03 | small RNA Sample Pre Kit | miRNA-Seq | TRANSCRIPTOMIC | PCR | SINGLE | ILLUMINA | HiSeq X Ten | SRP450509 | Zebrafish-2N-3.fq | fastq | 534146242.0 | 21237464.0 | Zebrafish 2N 3.fq | 0:25.15 | A:134813196;C:109988603;G:122363487;T:166967106;N:13850 | 25 | 134813196 | 109988603 | 122363487 | 166967106 | 13850 | SRX21100650 | SRS18369832 | SRA1676237 | Hunan Normal University|College of Life Sciences | Hunan Normal University | 1 | 0.78557 | 0.41489 | 0.84682 | 0.52155 | 26 | B | usable mapping rate | illumina | hiseq_era | full_length | random_priming | unknown | bulk | unknown | unknown | China | 2023-07-20 | Adult | Adult | Gonad | Reproductive System | ||||||||||||||||||||||||||||
| 76738 | 76738 | SRR25361310 | SRX21100649 | SRS18369831 | SRP450509 | PRJNA996758 | Transcriptome analysis of Zebrafish testis | PRJNA996758 | Other | In summary this study obtained whole transcriptome data of mature testis of triploid zebrafish by RNA seq which provided a data platform for the study of reproductive development of triploid fish. Screening and identification of miRNAs related to spermatogenesis in zebrafish. | Zebrafish 2N 2 | strain:not collected|age:3 mpf|collection date:not collected|geo loc name:not applicable|sex:male|tissue:testis|replicate:biological replicate 2|BioSampleModel:Model organism or animal | miRNA Seq of diploid zebrafish: mature testis 2 | S02 | S02 | small RNA Sample Pre Kit | miRNA-Seq | TRANSCRIPTOMIC | PCR | SINGLE | ILLUMINA | HiSeq X Ten | SRP450509 | Zebrafish-2N-2.fq | fastq | 356097642.0 | 14145771.0 | Zebrafish 2N 2.fq | 0:25.17 | A:90441485;C:73979402;G:81604410;T:110063163;N:9182 | 25 | 90441485 | 73979402 | 81604410 | 110063163 | 9182 | SRX21100649 | SRS18369831 | SRA1676237 | Hunan Normal University|College of Life Sciences | Hunan Normal University | 1 | 0.75286 | 0.42266 | 0.8561 | 0.55388 | 25 | B | usable mapping rate | illumina | hiseq_era | full_length | random_priming | unknown | bulk | unknown | unknown | China | 2023-07-20 | Adult | Adult | Gonad | Reproductive System | ||||||||||||||||||||||||||||
| 76739 | 76739 | SRR25361311 | SRX21100648 | SRS18369830 | SRP450509 | PRJNA996758 | Transcriptome analysis of Zebrafish testis | PRJNA996758 | Other | In summary this study obtained whole transcriptome data of mature testis of triploid zebrafish by RNA seq which provided a data platform for the study of reproductive development of triploid fish. Screening and identification of miRNAs related to spermatogenesis in zebrafish. | Zebrafish 2N 1 | strain:not collected|age:3 mpf|collection date:not collected|geo loc name:not applicable|sex:male|tissue:testis|replicate:biological replicate 1|BioSampleModel:Model organism or animal | miRNA Seq of diploid zebrafish: mature testis 1 | S01 | S01 | small RNA Sample Pre Kit | miRNA-Seq | TRANSCRIPTOMIC | PCR | SINGLE | ILLUMINA | HiSeq X Ten | SRP450509 | Zebrafish-2N-1.fq | fastq | 304073792.0 | 11993451.0 | Zebrafish 2N 1.fq | 0:25.35 | A:78785751;C:62508430;G:69338558;T:93420600;N:20453 | 25 | 78785751 | 62508430 | 69338558 | 93420600 | 20453 | SRX21100648 | SRS18369830 | SRA1676237 | Hunan Normal University|College of Life Sciences | Hunan Normal University | 1 | 0.77026 | 0.38872 | 0.86032 | 0.58206 | 23 | B | usable mapping rate | illumina | hiseq_era | full_length | random_priming | unknown | bulk | unknown | unknown | China | 2023-07-20 | Adult | Adult | Gonad | Reproductive 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");;