RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

run_metadata

7 rows where devstage_curation = "Segmentation" and experiment.library_strategy = "miRNA-Seq"

✎ View and edit SQL

This data as json, CSV (advanced)

tissue_curation_coarse 2

tissue_curation 2

experiment.platform 2

experiment.library_selection 2

technology 1

experiment.library_strategy 1

  • miRNA-Seq · 7 ✖

experiment.library_source 1

experiment.library_layout 1

devstage_curation_coarse 1

devstage_curation 1

  • Segmentation · 7 ✖
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
41429 41429 SRR4423107 SRX2245291 SRS1745856 SRP091534 PRJNA347637 Danio rerio and Xenopus laevis Raw sequence reads PRJNA347637 Other To study the transcriptome during development         Time course 6 Dr   strain:not applicable|isolate:not applicable|breed:ABTL|cultivar:not applicable|ecotype:not applicable|age:not applicable|dev stage:4 somite stage|sex:not determined|tissue:single embryo|BioSampleModel:Model organism or animal                 miRNA Seq of Zebrafish: 4 somite stage11.3 hpf 348 6 348 6 Libraries were generated according to the manufacturers’ protocols using the Ion Total RNA Seq Kit v2 and the Ion Xpress™ RNA Seq bar coding kit Thermo Fisher Scientific. A few modifications were made during purification steps in the small RNAseq to allow sequencing of longer RNAs up to 200 nt than with standard sRNA protocols. Namely: 153 µl ethanol instead of 120 µl during purification of cDNA and 134 µl ethanol instead of 110 µl in protocol.     miRNA-Seq TRANSCRIPTOMIC cDNA SINGLE ION_TORRENT Ion Torrent Proton   SRP091534     S06small.fastq fastq 535288776.0 4443685.0 S06small.fastq 0:120.46 A:119322177;C:152704452;G:149509408;T:113752739;N:0 120       119322177 152704452 149509408 113752739 0 SRX2245291 SRS1745856 SRA485147 Universiteit van Amsterdam|SILS Universiteit van Amsterdam 1 0.82872   0.09035   0.93194   0.81296   159   B   usable mapping rate ion_torrent ion_torrent unknown small_rna unknown bulk unknown unknown   Netherlands 2016-10-19 Segmentation Embryo Embryo Imprecise All anatomical structures
41436 41436 SRR4423100 SRX2245284 SRS1745849 SRP091534 PRJNA347637 Danio rerio and Xenopus laevis Raw sequence reads PRJNA347637 Other To study the transcriptome during development         Time course 7 Dr   strain:not applicable|isolate:not applicable|breed:ABTL|cultivar:not applicable|ecotype:not applicable|age:not applicable|dev stage:12 somite stage|sex:not determined|tissue:single embryo|BioSampleModel:Model organism or animal                 miRNA Seq of Zebrafish: 12 somite stage15 hpf 348 7 348 7 Libraries were generated according to the manufacturers’ protocols using the Ion Total RNA Seq Kit v2 and the Ion Xpress™ RNA Seq bar coding kit Thermo Fisher Scientific. A few modifications were made during purification steps in the small RNAseq to allow sequencing of longer RNAs up to 200 nt than with standard sRNA protocols. Namely: 153 µl ethanol instead of 120 µl during purification of cDNA and 134 µl ethanol instead of 110 µl in protocol.     miRNA-Seq TRANSCRIPTOMIC cDNA SINGLE ION_TORRENT Ion Torrent Proton   SRP091534     S07small.fastq fastq 279201769.0 2713759.0 S07small.fastq 0:102.88 A:61655863;C:78667355;G:77702440;T:61176111;N:0 102       61655863 78667355 77702440 61176111 0 SRX2245284 SRS1745849 SRA485147 Universiteit van Amsterdam|SILS Universiteit van Amsterdam 1 0.79087   0.10046   0.89221   0.77892   158   B   usable mapping rate ion_torrent ion_torrent unknown small_rna unknown bulk unknown unknown   Netherlands 2016-10-19 Segmentation Embryo Embryo Imprecise All anatomical structures
41437 41437 SRR4423099 SRX2245283 SRS1745848 SRP091534 PRJNA347637 Danio rerio and Xenopus laevis Raw sequence reads PRJNA347637 Other To study the transcriptome during development         Time course 8 Dr   strain:not applicable|isolate:not applicable|breed:ABTL|cultivar:not applicable|ecotype:not applicable|age:not applicable|dev stage:22 somite stage|sex:not determined|tissue:single embryo|BioSampleModel:Model organism or animal                 miRNA Seq of Zebrafish: 22 somite stage20 hpf 348 8 348 8 Libraries were generated according to the manufacturers’ protocols using the Ion Total RNA Seq Kit v2 and the Ion Xpress™ RNA Seq bar coding kit Thermo Fisher Scientific. A few modifications were made during purification steps in the small RNAseq to allow sequencing of longer RNAs up to 200 nt than with standard sRNA protocols. Namely: 153 µl ethanol instead of 120 µl during purification of cDNA and 134 µl ethanol instead of 110 µl in protocol.     miRNA-Seq TRANSCRIPTOMIC cDNA SINGLE ION_TORRENT Ion Torrent Proton   SRP091534     S08small.fastq fastq 520785540.0 4495080.0 S08small.fastq 0:115.86 A:115224831;C:149325753;G:144978190;T:111256766;N:0 115       115224831 149325753 144978190 111256766 0 SRX2245283 SRS1745848 SRA485147 Universiteit van Amsterdam|SILS Universiteit van Amsterdam 1 0.83781   0.08976   0.92904   0.80492   183   B   usable mapping rate ion_torrent ion_torrent unknown small_rna unknown bulk unknown unknown   Netherlands 2016-10-19 Segmentation Embryo Embryo Imprecise All anatomical structures
49101 49101 SRR7726444 SRX4582847 SRS3697100 SRP158508 PRJNA487021 MicroRNA expression signatures for gata4/5/6 knocking down in zebrafish GSE118850 Transcriptome Analysis Previous works showed that gata4/5/6 lie at the hierarchical apex of the regulatory network of the hemangioblast formation and primitive myelopoiesis in zebrafish. To explore the roles of miRNAs in zebrafish primitive myelopoiesis we employed deep sequencing to analyze the difference of miRNA expression profiles between gata4/5/6 knockdown embryos gata5/6 morphants and control embryos. Overall design: The embryos microinjected with control MO or gata5/6 MOs at 1 cell stage were collected at 14 hpf for collected for miRNA deep sequencing.The microinjection amount was 1 nl solution containing 6.25 ng gata5 MO and 1.25 ng gata6 MO or 7.5 ng control MO per embryo.       G56 miRNA GSM3349122   tissue:G56 embryos|genotype:gata4/5/6 knockdown|developmental stage:embryos|age:14hpf G56 miRNA The cDNA library was sequenced using Illumina Solexa following version 8 multiplexed single read sequencing recipe. Fastx fastx toolkit 0.0.13.2 was used to preprocess the original reads of the sequence. The CLC genomics workbench5.5 was applied to match the preprocessed sequence to the Sanger miRBase database version 19.0. Genome build: Sanger miRBase database version 19.0 Supplementary files format and content: .csv file includes small RNA sequences and counts Supplementary files format and content: .xls file includes effective reads and fold changes G56 embryos Morpholinos MOs were purchased from Gene Tools http://www.gene tools.com. MOs were dissolved in nanopure water and microinjected into the embryos at xxx cell stages. The microinjection amount was 1 nl solution containing 6.25 ng gata5 MO and 1.25 ng gata6 MO or 7.5 ng control MO per embryo. The embryos microinjected with control MO or gata5/6 MOs at 1 cell stage were collected at 14 hpf for analyzing the miRNA expression changes affected by knocking down gata4/5/6. Total RNA was isolated from 80 of the 14 hpf embryos and its quantity was examined by electrophoresis using Agilent Bioanalyzer 2100 Agilent Technologies Santa Clara US. The miRNA was isolated using mirVana miRNA Isolation Kit Life technologies USA from the total RNA. The 3’ and 5’ adaptors were added to the miRNA sequentially. cDNA was then reverse transcribed from the miRNA and amplified using a PCR reaction 98℃ 30 s 11 × 98℃ 10 s 60℃ 30 s 72 ℃ 15 s for 72 ℃ 10 min 4℃. The cDNA was separated by 6% Novex TBE PAGE Gel for collecting the fragments with 147 157 nt long. The cDNA library was constructed and the quantity was examined using a commercial kit Qubit™ dsDNA HS Aglient 2100. The concentration of the library was no lower than 0.5 ng/µl and the size of cDNA was 140 160 bp. Zebrafish were housed in the zebrafish room of Model Animal Research Center Nanjing University in accordance with IACUC approved protocol. All methods were performed in accordance with the relevant guidelines and regulations. genotype:gata4/5/6 knockdown|developmental stage:embryos|age:14hpf GSM3349122 GSM3349122: G56 miRNA; Danio rerio; miRNA Seq GSM3349122   1 Total RNA was isolated from 80 of the 14 hpf embryos and its quantity was examined by electrophoresis using Agilent Bioanalyzer 2100 Agilent Technologies Santa Clara US. The miRNA was isolated using mirVana miRNA Isolation Kit Life technologies USA from the total RNA. The three prime and five prime adaptors were added to the miRNA sequentially. cDNA was then reverse transcribed from the miRNA and amplified using a PCR reaction 98℃ 30 s 11 × 98℃ 10 s 60℃ 30 s 72 ℃ 15 s for 72 ℃ 10 min 4℃. The cDNA was separated by 6% Novex TBE PAGE Gel for collecting the fragments with 147 157 nt long. The cDNA library was constructed and the quantity was examined using a commercial kit Qubit™ dsDNA HS Aglient 2100. The concentration of the library was no lower than 0.5 ng/µl and the size of cDNA was 140 160 bp. GEO Accession:GSM3349122 miRNA-Seq TRANSCRIPTOMIC size fractionation SINGLE ILLUMINA Illumina MiSeq   SRP158508         655037050.0 13100741.0 GSM3349122 r1 0:50 1:0 A:161448247;C:135821164;G:200213833;T:156824030;N:729776 50 0     161448247 135821164 200213833 156824030 729776 SRX4582847 SRS3697100 SRA761361 GEO Nanjing University 1 0.00066   6e-05   0.99896   0.64583   50   T   under 1.2% mapping rate illumina miseq unknown size_fractionation unknown bulk unknown unknown   China 2018-08-21 Segmentation Embryo Embryo Imprecise All anatomical structures
49102 49102 SRR7726443 SRX4582846 SRS3697099 SRP158508 PRJNA487021 MicroRNA expression signatures for gata4/5/6 knocking down in zebrafish GSE118850 Transcriptome Analysis Previous works showed that gata4/5/6 lie at the hierarchical apex of the regulatory network of the hemangioblast formation and primitive myelopoiesis in zebrafish. To explore the roles of miRNAs in zebrafish primitive myelopoiesis we employed deep sequencing to analyze the difference of miRNA expression profiles between gata4/5/6 knockdown embryos gata5/6 morphants and control embryos. Overall design: The embryos microinjected with control MO or gata5/6 MOs at 1 cell stage were collected at 14 hpf for collected for miRNA deep sequencing.The microinjection amount was 1 nl solution containing 6.25 ng gata5 MO and 1.25 ng gata6 MO or 7.5 ng control MO per embryo.       WT miRNA GSM3349121   tissue:WT embryos|genotype:wild type|developmental stage:embryos|age:14hpf WT miRNA The cDNA library was sequenced using Illumina Solexa following version 8 multiplexed single read sequencing recipe. Fastx fastx toolkit 0.0.13.2 was used to preprocess the original reads of the sequence. The CLC genomics workbench5.5 was applied to match the preprocessed sequence to the Sanger miRBase database version 19.0. Genome build: Sanger miRBase database version 19.0 Supplementary files format and content: .csv file includes small RNA sequences and counts Supplementary files format and content: .xls file includes effective reads and fold changes WT embryos Morpholinos MOs were purchased from Gene Tools http://www.gene tools.com. MOs were dissolved in nanopure water and microinjected into the embryos at xxx cell stages. The microinjection amount was 1 nl solution containing 6.25 ng gata5 MO and 1.25 ng gata6 MO or 7.5 ng control MO per embryo. The embryos microinjected with control MO or gata5/6 MOs at 1 cell stage were collected at 14 hpf for analyzing the miRNA expression changes affected by knocking down gata4/5/6. Total RNA was isolated from 80 of the 14 hpf embryos and its quantity was examined by electrophoresis using Agilent Bioanalyzer 2100 Agilent Technologies Santa Clara US. The miRNA was isolated using mirVana miRNA Isolation Kit Life technologies USA from the total RNA. The 3’ and 5’ adaptors were added to the miRNA sequentially. cDNA was then reverse transcribed from the miRNA and amplified using a PCR reaction 98℃ 30 s 11 × 98℃ 10 s 60℃ 30 s 72 ℃ 15 s for 72 ℃ 10 min 4℃. The cDNA was separated by 6% Novex TBE PAGE Gel for collecting the fragments with 147 157 nt long. The cDNA library was constructed and the quantity was examined using a commercial kit Qubit™ dsDNA HS Aglient 2100. The concentration of the library was no lower than 0.5 ng/µl and the size of cDNA was 140 160 bp. Zebrafish were housed in the zebrafish room of Model Animal Research Center Nanjing University in accordance with IACUC approved protocol. All methods were performed in accordance with the relevant guidelines and regulations. genotype:wild type|developmental stage:embryos|age:14hpf GSM3349121 GSM3349121: WT miRNA; Danio rerio; miRNA Seq GSM3349121   1 Total RNA was isolated from 80 of the 14 hpf embryos and its quantity was examined by electrophoresis using Agilent Bioanalyzer 2100 Agilent Technologies Santa Clara US. The miRNA was isolated using mirVana miRNA Isolation Kit Life technologies USA from the total RNA. The three prime and five prime adaptors were added to the miRNA sequentially. cDNA was then reverse transcribed from the miRNA and amplified using a PCR reaction 98℃ 30 s 11 × 98℃ 10 s 60℃ 30 s 72 ℃ 15 s for 72 ℃ 10 min 4℃. The cDNA was separated by 6% Novex TBE PAGE Gel for collecting the fragments with 147 157 nt long. The cDNA library was constructed and the quantity was examined using a commercial kit Qubit™ dsDNA HS Aglient 2100. The concentration of the library was no lower than 0.5 ng/µl and the size of cDNA was 140 160 bp. GEO Accession:GSM3349121 miRNA-Seq TRANSCRIPTOMIC size fractionation SINGLE ILLUMINA Illumina MiSeq   SRP158508         627151350.0 12543027.0 GSM3349121 r1 0:50 1:0 A:153340174;C:128104541;G:192611227;T:152395340;N:700068 50 0     153340174 128104541 192611227 152395340 700068 SRX4582846 SRS3697099 SRA761361 GEO Nanjing University 1 0.0006   0.00012   0.99904   0.60759   50   T   under 1.2% mapping rate illumina miseq unknown size_fractionation unknown bulk unknown unknown   China 2018-08-21 Segmentation Embryo Embryo Imprecise All anatomical structures
60889 60889 SRR12628232 SRX9110495 SRS7353478 SRP282187 PRJNA663091 Characterization of small RNAs in early zebrafish PGCs GSE157865 Transcriptome Analysis Microscale small RNA high throughput sequencing was used to study small RNA distribution in early zebrafish PGCs primordial germ cells. We find that early zebrafish PGCs have large quantities of piRNAs and small quantities of miRNAs. Among the miRNAs detected miR 430 accounted for the majority which has been proved to play diverse roles in zebrafish development. In addition miR 92a 3p and miR 26a 5p have high expression and previous studies show that these two miRNAs can influence cell proliferation in cancer cells. More experiments should be performed in the future to explore whether miR 92a 3p and miR 26a 5p can influence the number of zebrafish PGCs. Overall design: Small RNA profiles at 6 hpf shield stage 11 hpf 3 somite stage and 24 hpf prim 5 stage of zebrafish PGCs   pubmed:33506864   h11 2: PGCs 11hpf repeat2 GSM4777192   source name:PGCs|cell type:primordial germ cells|strain:AB|tissue:gonad h11 2: PGCs 11hpf repeat2 Raw reads were pre processed by FASTX Toolkit version 0.0.14 1 Reads were mapped to danRer11 using bowtie version 1.0.0 5 miRNAs were quantified based on miRBase version 22.0 piRNAs were quantified using proTRAC version 2.2.0 Genome build: danRer11 Supplementary files format and content: tab delimited text file includes read number and RPM of miRNA expression for each sample … PGCs   PGCs were picked out by green fluoresence small RNA seq library was constructed by microscale small RNA high throughput sequencing method.   cell type:primordial germ cells|strain:AB|tissue:gonad GSM4777192 GSM4777192: h11 2: PGCs 11hpf repeat2; Danio rerio; miRNA Seq GSM4777192   1 PGCs were picked out by green fluoresence small RNA seq library was constructed by microscale small RNA high throughput sequencing method. GEO Accession:GSM4777192 miRNA-Seq TRANSCRIPTOMIC size fractionation SINGLE ILLUMINA HiSeq X Ten   SRP282187     h11_2.fastq fastq 1725506100.0 11503374.0 GSM4777192 r1 0:150 1:0 A:419294958;C:415643261;G:432730446;T:457808038;N:29397 150 0     419294958 415643261 432730446 457808038 29397 SRX9110495 SRS7353478 SRA1124474 GEO Shanghai Institute of Biochemistry and Cell Biology,CAS 1 0.00062   0.0   0.99991   1.0   150   T   under 1.2% mapping rate illumina hiseq_era unknown size_fractionation unknown bulk unknown unknown   China 2020-09-12 Segmentation Embryo Gonad Reproductive System
60890 60890 SRR12628231 SRX9110494 SRS7353477 SRP282187 PRJNA663091 Characterization of small RNAs in early zebrafish PGCs GSE157865 Transcriptome Analysis Microscale small RNA high throughput sequencing was used to study small RNA distribution in early zebrafish PGCs primordial germ cells. We find that early zebrafish PGCs have large quantities of piRNAs and small quantities of miRNAs. Among the miRNAs detected miR 430 accounted for the majority which has been proved to play diverse roles in zebrafish development. In addition miR 92a 3p and miR 26a 5p have high expression and previous studies show that these two miRNAs can influence cell proliferation in cancer cells. More experiments should be performed in the future to explore whether miR 92a 3p and miR 26a 5p can influence the number of zebrafish PGCs. Overall design: Small RNA profiles at 6 hpf shield stage 11 hpf 3 somite stage and 24 hpf prim 5 stage of zebrafish PGCs   pubmed:33506864   h11 1: PGCs 11hpf repeat1 GSM4777191   source name:PGCs|cell type:primordial germ cells|strain:AB|tissue:gonad h11 1: PGCs 11hpf repeat1 Raw reads were pre processed by FASTX Toolkit version 0.0.14 1 Reads were mapped to danRer11 using bowtie version 1.0.0 5 miRNAs were quantified based on miRBase version 22.0 piRNAs were quantified using proTRAC version 2.2.0 Genome build: danRer11 Supplementary files format and content: tab delimited text file includes read number and RPM of miRNA expression for each sample … PGCs   PGCs were picked out by green fluoresence small RNA seq library was constructed by microscale small RNA high throughput sequencing method.   cell type:primordial germ cells|strain:AB|tissue:gonad GSM4777191 GSM4777191: h11 1: PGCs 11hpf repeat1; Danio rerio; miRNA Seq GSM4777191   1 PGCs were picked out by green fluoresence small RNA seq library was constructed by microscale small RNA high throughput sequencing method. GEO Accession:GSM4777191 miRNA-Seq TRANSCRIPTOMIC size fractionation SINGLE ILLUMINA HiSeq X Ten   SRP282187     h11_1.fastq fastq 2690366550.0 17935777.0 GSM4777191 r1 0:150 1:0 A:722881530;C:687611993;G:633563837;T:646263376;N:45814 150 0     722881530 687611993 633563837 646263376 45814 SRX9110494 SRS7353477 SRA1124474 GEO Shanghai Institute of Biochemistry and Cell Biology,CAS 1 0.0006   0.0   0.99991   1.0   150   T   under 1.2% mapping rate illumina hiseq_era unknown size_fractionation unknown bulk unknown unknown   China 2020-09-12 Segmentation Embryo Gonad Reproductive System

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");;