RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

run_metadata

4 rows where experiment.library_selection = "cDNA", technology = "quartzseq" and tissue_curation_coarse = "Undetermined"

✎ View and edit SQL

This data as json, CSV (advanced)

tissue_curation_coarse 1

  • Undetermined · 4 ✖

tissue_curation 1

technology 1

  • quartzseq · 4 ✖

experiment.platform 1

experiment.library_strategy 1

experiment.library_source 1

experiment.library_selection 1

  • cDNA · 4 ✖

experiment.library_layout 1

devstage_curation_coarse 1

devstage_curation 1

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
53150 53150 SRR9692020 SRX6451054 SRS5104325 SRP214773 PRJNA554788 Gene expression analysis in the zebrafish fractured scale GSE134330 Transcriptome Analysis Bone is a connective tissue which undergoes continuous remodeling including bone resorption and formation by osteoclasts OCs and osteoblasts OBs respectively. Recently extracellular vesicles EVs are increasingly appreciated as a regulator of intercellular communication between OCs and OBs. The zebrafish scale is a thin membranous bone embedded in the skin and consists of OBs OCs and bone matrix providing an elegant model to visualize OC OB communication. Here we developed a double transgenic zebrafish line trap:GFP; osterix:mCherry which expresses GFP and mCherry under the control of the OC specific trap tartrate resistant acid phosphatase and OB specific osterix enhancer respectively. Utilizing this double transgenic line in combination with Hoechst 33342 Hoe staining we isolated four distinct fractions from the scale at 1 day post fracture by flow cytometry GFP– mCh+ Hoehigh OB fraction GFPlow mCh+ Hoehigh OC precursor pOC fraction GFPhigh Hoehigh mature OC mOC fraction and mCh+ Hoe– OB derived extracellular vesicle EV fraction. In this study we have performed RNA seq analysis using these four fractions to examine the gene expression profile of each fraction. Overall design: mRNA profiles of isolated OBs pOCs mOCs and OB derived EVs in the zebrafish fractured scales were generated by Quartz seq using Illumina NextSeq500.   pubmed:32327701   mOC 2 GSM3942346   source name:mature osteoclasts|age:adult|genotype:wild type|tissue:Sorted from the fractured sclae|cell type:mature osteoclasts|molecule type:Amplified RNA mOC 2 Illumina RTA software was used for base calling. Sequence reads were mapped to the zebrafish reference genome GRCz11 using HiSAT2 version 2.1.0. Reads per million RPM were calculated using the Subread ver. 1.6.4. Genome build: GRCz11 Supplementary files format and content: Reads per million RPM values for each sample. mature osteoclasts   Total RNAs were extracted from sorted cells using RNeasy Mini Kit QIAGEN. Cells were directly sorted in a lysis buffer containing 1 μg/mL of polyinosinic polycytidylic acid and total RNA was extracted using RNeasy Mini Kit. Reverse transcription RT was performed using Super Script III Thermo Fisher Scientific and an RT primer which contains oligo dT T7 promoter and PCR target region sequences. post digestion of remaining RT primers by exonuclease I Takara a poly A tail was added to the 3’ ends of the first strand cDNAs using terminal transferase Sigma. The second strand DNA was then synthesized using MightyAmp DNA polymerase Thermo Fisher Scientific and a tagging primer which contains oligo dT and PCR target region sequences. PCR amplification was performed using a suppression primer which allow to amplify small size DNA that contains complementary sequences at both ends of the template DNA. The amplified double strand cDNA was purified using QIAquick PCR Purification Kit Qiagen. Library preparation was performed using Nextera XT DNA Library Preparation Kit illumina.   age:adult|genotype:wild type|tissue:Sorted from the fractured sclae|cell type:mature osteoclasts|molecule type:Amplified RNA GSM3942346 GSM3942346: mOC 2; Danio rerio; RNA Seq GSM3942346   1 Total RNAs were extracted from sorted cells using RNeasy Mini Kit QIAGEN. Cells were directly sorted in a lysis buffer containing 1 μg/mL of polyinosinic polycytidylic acid and total RNA was extracted using RNeasy Mini Kit. Reverse transcription RT was performed using Super Script III Thermo Fisher Scientific and an RT primer which contains oligo dT T7 promoter and PCR target region sequences. post digestion of remaining RT primers by exonuclease I Takara a poly A tail was added to the three prime ends of the first strand cDNAs using terminal transferase Sigma. The second strand DNA was then synthesized using MightyAmp DNA polymerase Thermo Fisher Scientific and a tagging primer which contains oligo dT and PCR target region sequences. PCR amplification was performed using a suppression primer which allow to amplify small size DNA that contains complementary sequences at both ends of the template DNA. The amplified double strand cDNA was purified using QIAquick PCR Purification Kit Qiagen. Library preparation was performed using Nextera XT DNA Library Preparation Kit illumina.   RNA-Seq TRANSCRIPTOMIC cDNA PAIRED ILLUMINA NextSeq 500   SRP214773     mOC_2_R1.fastq.gz mOC_2_R2.fastq.gz fastq fastq 3442034400.0 11473448.0 GSM3942346 r1 0:150 1:150 A:874790081;C:854584498;G:837659746;T:874907519;N:92556 150 150     874790081 854584498 837659746 874907519 92556 SRX6451054 SRS5104325 SRA921382 GEO Kanazawa University 2 0.94546 0.94169 0.03234 0.03643 0.79845 0.81132 0.49852 0.47127 150 150 B B biological fallback assumption illumina nextseq 3prime poly_a nextera sc single_cell_plate quartzseq   Japan 2019-07-16 Adult Adult Undetermined Undetermined
53151 53151 SRR9692019 SRX6451053 SRS5104324 SRP214773 PRJNA554788 Gene expression analysis in the zebrafish fractured scale GSE134330 Transcriptome Analysis Bone is a connective tissue which undergoes continuous remodeling including bone resorption and formation by osteoclasts OCs and osteoblasts OBs respectively. Recently extracellular vesicles EVs are increasingly appreciated as a regulator of intercellular communication between OCs and OBs. The zebrafish scale is a thin membranous bone embedded in the skin and consists of OBs OCs and bone matrix providing an elegant model to visualize OC OB communication. Here we developed a double transgenic zebrafish line trap:GFP; osterix:mCherry which expresses GFP and mCherry under the control of the OC specific trap tartrate resistant acid phosphatase and OB specific osterix enhancer respectively. Utilizing this double transgenic line in combination with Hoechst 33342 Hoe staining we isolated four distinct fractions from the scale at 1 day post fracture by flow cytometry GFP– mCh+ Hoehigh OB fraction GFPlow mCh+ Hoehigh OC precursor pOC fraction GFPhigh Hoehigh mature OC mOC fraction and mCh+ Hoe– OB derived extracellular vesicle EV fraction. In this study we have performed RNA seq analysis using these four fractions to examine the gene expression profile of each fraction. Overall design: mRNA profiles of isolated OBs pOCs mOCs and OB derived EVs in the zebrafish fractured scales were generated by Quartz seq using Illumina NextSeq500.   pubmed:32327701   mOC 1 GSM3942345   source name:mature osteoclasts|age:adult|genotype:wild type|tissue:Sorted from the fractured sclae|cell type:mature osteoclasts|molecule type:Amplified RNA mOC 1 Illumina RTA software was used for base calling. Sequence reads were mapped to the zebrafish reference genome GRCz11 using HiSAT2 version 2.1.0. Reads per million RPM were calculated using the Subread ver. 1.6.4. Genome build: GRCz11 Supplementary files format and content: Reads per million RPM values for each sample. mature osteoclasts   Total RNAs were extracted from sorted cells using RNeasy Mini Kit QIAGEN. Cells were directly sorted in a lysis buffer containing 1 μg/mL of polyinosinic polycytidylic acid and total RNA was extracted using RNeasy Mini Kit. Reverse transcription RT was performed using Super Script III Thermo Fisher Scientific and an RT primer which contains oligo dT T7 promoter and PCR target region sequences. post digestion of remaining RT primers by exonuclease I Takara a poly A tail was added to the 3’ ends of the first strand cDNAs using terminal transferase Sigma. The second strand DNA was then synthesized using MightyAmp DNA polymerase Thermo Fisher Scientific and a tagging primer which contains oligo dT and PCR target region sequences. PCR amplification was performed using a suppression primer which allow to amplify small size DNA that contains complementary sequences at both ends of the template DNA. The amplified double strand cDNA was purified using QIAquick PCR Purification Kit Qiagen. Library preparation was performed using Nextera XT DNA Library Preparation Kit illumina.   age:adult|genotype:wild type|tissue:Sorted from the fractured sclae|cell type:mature osteoclasts|molecule type:Amplified RNA GSM3942345 GSM3942345: mOC 1; Danio rerio; RNA Seq GSM3942345   1 Total RNAs were extracted from sorted cells using RNeasy Mini Kit QIAGEN. Cells were directly sorted in a lysis buffer containing 1 μg/mL of polyinosinic polycytidylic acid and total RNA was extracted using RNeasy Mini Kit. Reverse transcription RT was performed using Super Script III Thermo Fisher Scientific and an RT primer which contains oligo dT T7 promoter and PCR target region sequences. post digestion of remaining RT primers by exonuclease I Takara a poly A tail was added to the three prime ends of the first strand cDNAs using terminal transferase Sigma. The second strand DNA was then synthesized using MightyAmp DNA polymerase Thermo Fisher Scientific and a tagging primer which contains oligo dT and PCR target region sequences. PCR amplification was performed using a suppression primer which allow to amplify small size DNA that contains complementary sequences at both ends of the template DNA. The amplified double strand cDNA was purified using QIAquick PCR Purification Kit Qiagen. Library preparation was performed using Nextera XT DNA Library Preparation Kit illumina.   RNA-Seq TRANSCRIPTOMIC cDNA PAIRED ILLUMINA NextSeq 500   SRP214773     mOC_1_R1.fastq.gz mOC_1_R2.fastq.gz fastq fastq 3725202300.0 12417341.0 GSM3942345 r1 0:150 1:150 A:939287270;C:932158020;G:913434023;T:940223484;N:99503 150 150     939287270 932158020 913434023 940223484 99503 SRX6451053 SRS5104324 SRA921382 GEO Kanazawa University 2 0.95139 0.94882 0.0326 0.03471 0.79393 0.80507 0.4667 0.49924 150 150 B B biological fallback assumption illumina nextseq 3prime poly_a nextera sc single_cell_plate quartzseq   Japan 2019-07-16 Adult Adult Undetermined Undetermined
53152 53152 SRR9692018 SRX6451052 SRS5104323 SRP214773 PRJNA554788 Gene expression analysis in the zebrafish fractured scale GSE134330 Transcriptome Analysis Bone is a connective tissue which undergoes continuous remodeling including bone resorption and formation by osteoclasts OCs and osteoblasts OBs respectively. Recently extracellular vesicles EVs are increasingly appreciated as a regulator of intercellular communication between OCs and OBs. The zebrafish scale is a thin membranous bone embedded in the skin and consists of OBs OCs and bone matrix providing an elegant model to visualize OC OB communication. Here we developed a double transgenic zebrafish line trap:GFP; osterix:mCherry which expresses GFP and mCherry under the control of the OC specific trap tartrate resistant acid phosphatase and OB specific osterix enhancer respectively. Utilizing this double transgenic line in combination with Hoechst 33342 Hoe staining we isolated four distinct fractions from the scale at 1 day post fracture by flow cytometry GFP– mCh+ Hoehigh OB fraction GFPlow mCh+ Hoehigh OC precursor pOC fraction GFPhigh Hoehigh mature OC mOC fraction and mCh+ Hoe– OB derived extracellular vesicle EV fraction. In this study we have performed RNA seq analysis using these four fractions to examine the gene expression profile of each fraction. Overall design: mRNA profiles of isolated OBs pOCs mOCs and OB derived EVs in the zebrafish fractured scales were generated by Quartz seq using Illumina NextSeq500.   pubmed:32327701   pOC 2 GSM3942344   source name:osteoclast precursors|age:adult|genotype:wild type|tissue:Sorted from the fractured sclae|cell type:osteoclast precursors|molecule type:Amplified RNA pOC 2 Illumina RTA software was used for base calling. Sequence reads were mapped to the zebrafish reference genome GRCz11 using HiSAT2 version 2.1.0. Reads per million RPM were calculated using the Subread ver. 1.6.4. Genome build: GRCz11 Supplementary files format and content: Reads per million RPM values for each sample. osteoclast precursors   Total RNAs were extracted from sorted cells using RNeasy Mini Kit QIAGEN. Cells were directly sorted in a lysis buffer containing 1 μg/mL of polyinosinic polycytidylic acid and total RNA was extracted using RNeasy Mini Kit. Reverse transcription RT was performed using Super Script III Thermo Fisher Scientific and an RT primer which contains oligo dT T7 promoter and PCR target region sequences. post digestion of remaining RT primers by exonuclease I Takara a poly A tail was added to the 3’ ends of the first strand cDNAs using terminal transferase Sigma. The second strand DNA was then synthesized using MightyAmp DNA polymerase Thermo Fisher Scientific and a tagging primer which contains oligo dT and PCR target region sequences. PCR amplification was performed using a suppression primer which allow to amplify small size DNA that contains complementary sequences at both ends of the template DNA. The amplified double strand cDNA was purified using QIAquick PCR Purification Kit Qiagen. Library preparation was performed using Nextera XT DNA Library Preparation Kit illumina.   age:adult|genotype:wild type|tissue:Sorted from the fractured sclae|cell type:osteoclast precursors|molecule type:Amplified RNA GSM3942344 GSM3942344: pOC 2; Danio rerio; RNA Seq GSM3942344   1 Total RNAs were extracted from sorted cells using RNeasy Mini Kit QIAGEN. Cells were directly sorted in a lysis buffer containing 1 μg/mL of polyinosinic polycytidylic acid and total RNA was extracted using RNeasy Mini Kit. Reverse transcription RT was performed using Super Script III Thermo Fisher Scientific and an RT primer which contains oligo dT T7 promoter and PCR target region sequences. post digestion of remaining RT primers by exonuclease I Takara a poly A tail was added to the three prime ends of the first strand cDNAs using terminal transferase Sigma. The second strand DNA was then synthesized using MightyAmp DNA polymerase Thermo Fisher Scientific and a tagging primer which contains oligo dT and PCR target region sequences. PCR amplification was performed using a suppression primer which allow to amplify small size DNA that contains complementary sequences at both ends of the template DNA. The amplified double strand cDNA was purified using QIAquick PCR Purification Kit Qiagen. Library preparation was performed using Nextera XT DNA Library Preparation Kit illumina.   RNA-Seq TRANSCRIPTOMIC cDNA PAIRED ILLUMINA NextSeq 500   SRP214773     pOC_2_R1.fastq.gz pOC_2_R2.fastq.gz fastq fastq 8180901900.0 27269673.0 GSM3942344 r1 0:150 1:150 A:2045941714;C:2067950267;G:1981277316;T:2085490817;N:241786 150 150     2045941714 2067950267 1981277316 2085490817 241786 SRX6451052 SRS5104323 SRA921382 GEO Kanazawa University 2 0.94075 0.93872 0.04606 0.04832 0.77847 0.78482 0.50377 0.50525 150 150 B B biological fallback assumption illumina nextseq 3prime poly_a nextera sc single_cell_plate quartzseq   Japan 2019-07-16 Adult Adult Undetermined Undetermined
53153 53153 SRR9692017 SRX6451051 SRS5104322 SRP214773 PRJNA554788 Gene expression analysis in the zebrafish fractured scale GSE134330 Transcriptome Analysis Bone is a connective tissue which undergoes continuous remodeling including bone resorption and formation by osteoclasts OCs and osteoblasts OBs respectively. Recently extracellular vesicles EVs are increasingly appreciated as a regulator of intercellular communication between OCs and OBs. The zebrafish scale is a thin membranous bone embedded in the skin and consists of OBs OCs and bone matrix providing an elegant model to visualize OC OB communication. Here we developed a double transgenic zebrafish line trap:GFP; osterix:mCherry which expresses GFP and mCherry under the control of the OC specific trap tartrate resistant acid phosphatase and OB specific osterix enhancer respectively. Utilizing this double transgenic line in combination with Hoechst 33342 Hoe staining we isolated four distinct fractions from the scale at 1 day post fracture by flow cytometry GFP– mCh+ Hoehigh OB fraction GFPlow mCh+ Hoehigh OC precursor pOC fraction GFPhigh Hoehigh mature OC mOC fraction and mCh+ Hoe– OB derived extracellular vesicle EV fraction. In this study we have performed RNA seq analysis using these four fractions to examine the gene expression profile of each fraction. Overall design: mRNA profiles of isolated OBs pOCs mOCs and OB derived EVs in the zebrafish fractured scales were generated by Quartz seq using Illumina NextSeq500.   pubmed:32327701   pOC 1 GSM3942343   source name:osteoclast precursors|age:adult|genotype:wild type|tissue:Sorted from the fractured sclae|cell type:osteoclast precursors|molecule type:Amplified RNA pOC 1 Illumina RTA software was used for base calling. Sequence reads were mapped to the zebrafish reference genome GRCz11 using HiSAT2 version 2.1.0. Reads per million RPM were calculated using the Subread ver. 1.6.4. Genome build: GRCz11 Supplementary files format and content: Reads per million RPM values for each sample. osteoclast precursors   Total RNAs were extracted from sorted cells using RNeasy Mini Kit QIAGEN. Cells were directly sorted in a lysis buffer containing 1 μg/mL of polyinosinic polycytidylic acid and total RNA was extracted using RNeasy Mini Kit. Reverse transcription RT was performed using Super Script III Thermo Fisher Scientific and an RT primer which contains oligo dT T7 promoter and PCR target region sequences. post digestion of remaining RT primers by exonuclease I Takara a poly A tail was added to the 3’ ends of the first strand cDNAs using terminal transferase Sigma. The second strand DNA was then synthesized using MightyAmp DNA polymerase Thermo Fisher Scientific and a tagging primer which contains oligo dT and PCR target region sequences. PCR amplification was performed using a suppression primer which allow to amplify small size DNA that contains complementary sequences at both ends of the template DNA. The amplified double strand cDNA was purified using QIAquick PCR Purification Kit Qiagen. Library preparation was performed using Nextera XT DNA Library Preparation Kit illumina.   age:adult|genotype:wild type|tissue:Sorted from the fractured sclae|cell type:osteoclast precursors|molecule type:Amplified RNA GSM3942343 GSM3942343: pOC 1; Danio rerio; RNA Seq GSM3942343   1 Total RNAs were extracted from sorted cells using RNeasy Mini Kit QIAGEN. Cells were directly sorted in a lysis buffer containing 1 μg/mL of polyinosinic polycytidylic acid and total RNA was extracted using RNeasy Mini Kit. Reverse transcription RT was performed using Super Script III Thermo Fisher Scientific and an RT primer which contains oligo dT T7 promoter and PCR target region sequences. post digestion of remaining RT primers by exonuclease I Takara a poly A tail was added to the three prime ends of the first strand cDNAs using terminal transferase Sigma. The second strand DNA was then synthesized using MightyAmp DNA polymerase Thermo Fisher Scientific and a tagging primer which contains oligo dT and PCR target region sequences. PCR amplification was performed using a suppression primer which allow to amplify small size DNA that contains complementary sequences at both ends of the template DNA. The amplified double strand cDNA was purified using QIAquick PCR Purification Kit Qiagen. Library preparation was performed using Nextera XT DNA Library Preparation Kit illumina.   RNA-Seq TRANSCRIPTOMIC cDNA PAIRED ILLUMINA NextSeq 500   SRP214773     pOC_1_R1.fastq.gz pOC_1_R2.fastq.gz fastq fastq 8119854000.0 27066180.0 GSM3942343 r1 0:150 1:150 A:2022941314;C:2067331062;G:1960663076;T:2068678318;N:240230 150 150     2022941314 2067331062 1960663076 2068678318 240230 SRX6451051 SRS5104322 SRA921382 GEO Kanazawa University 2 0.94544 0.94406 0.04202 0.04348 0.77979 0.78624 0.50479 0.48269 150 150 B B biological fallback assumption illumina nextseq 3prime poly_a nextera sc single_cell_plate quartzseq   Japan 2019-07-16 Adult Adult Undetermined Undetermined

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