RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

run_metadata

8 rows where devstage_curation = "Pharyngula" and tissue_curation = "Fin"

✎ View and edit SQL

This data as json, CSV (advanced)

experiment.library_selection 2

tissue_curation_coarse 1

tissue_curation 1

technology 1

experiment.platform 1

experiment.library_strategy 1

experiment.library_source 1

experiment.library_layout 1

devstage_curation_coarse 1

devstage_curation 1

  • Pharyngula · 8 ✖
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
306 306 DRR224536 DRX214821 DRS236344 DRP008458 PRJDB9741 RNA seq for developing pectoral fin in zebrafish DRP008458 Other From the developmental view of fin to limb transition an important event in vertebrate evolution we seek fish specific genes that show characteristic expression pattern in the developing fin.       pectoral fin bud from gM1116A zebrafish at 40hpf C SAMD00222567   sample name:40hpf C                 Illumina NovaSeq 6000 paired end sequencing of SAMD00222567 DRX214821 40hpf C 1 Illumina TruSeq Stranded mRNA Library Prep Kit   RNA-Seq TRANSCRIPTOMIC PolyA PAIRED ILLUMINA Illumina NovaSeq 6000 <SPOT_DESCRIPTOR><SPOT_DECODE_SPEC><SPOT_LENGTH>200</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>101</BASE_COORD></READ_SPEC></SPOT_DECODE_SPEC></SPOT_DESCRIPTOR> DRP008458 Illumina NovaSeq 6000 paired end sequencing of SAMD00222567       14926054400.0 74630272.0 DRR224536 0:100 1:100 A:3647365116;C:3826172690;G:3866071867;T:3586333511;N:111216 100 100     3647365116 3826172690 3866071867 3586333511 111216 DRX214821 DRS236344 DRA010086 TOHOKUGL|Laboratory of organ morphogenesis Graduate School of Life Sciences, Tohoku University 2 0.96395 0.96168 0.05081 0.04957 0.75489 0.75607 0.51046 0.52135 100 100 B B biological fallback assumption illumina novaseq_era unknown poly_a trueseq bulk unknown unknown   Japan 2022-04-21 Pharyngula Embryo Fin Surface Structure
307 307 DRR224535 DRX214820 DRS236343 DRP008458 PRJDB9741 RNA seq for developing pectoral fin in zebrafish DRP008458 Other From the developmental view of fin to limb transition an important event in vertebrate evolution we seek fish specific genes that show characteristic expression pattern in the developing fin.       pectoral fin bud from gM1116A zebrafish at 40hpf B SAMD00222566   sample name:40hpf B                 Illumina NovaSeq 6000 paired end sequencing of SAMD00222566 DRX214820 40hpf B 1 Illumina TruSeq Stranded mRNA Library Prep Kit   RNA-Seq TRANSCRIPTOMIC PolyA PAIRED ILLUMINA Illumina NovaSeq 6000 <SPOT_DESCRIPTOR><SPOT_DECODE_SPEC><SPOT_LENGTH>200</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>101</BASE_COORD></READ_SPEC></SPOT_DECODE_SPEC></SPOT_DESCRIPTOR> DRP008458 Illumina NovaSeq 6000 paired end sequencing of SAMD00222566       14413995800.0 72069979.0 DRR224535 0:100 1:100 A:3598207137;C:3642219692;G:3750145663;T:3423315835;N:107473 100 100     3598207137 3642219692 3750145663 3423315835 107473 DRX214820 DRS236343 DRA010086 TOHOKUGL|Laboratory of organ morphogenesis Graduate School of Life Sciences, Tohoku University 2 0.97396 0.97107 0.04686 0.04549 0.7444 0.74968 0.50051 0.49798 100 100 B B biological fallback assumption illumina novaseq_era unknown poly_a trueseq bulk unknown unknown   Japan 2022-04-21 Pharyngula Embryo Fin Surface Structure
308 308 DRR224534 DRX214819 DRS236342 DRP008458 PRJDB9741 RNA seq for developing pectoral fin in zebrafish DRP008458 Other From the developmental view of fin to limb transition an important event in vertebrate evolution we seek fish specific genes that show characteristic expression pattern in the developing fin.       pectoral fin bud from gM1116A zebrafish at 40hpf A SAMD00222565   sample name:40hpf A                 Illumina NovaSeq 6000 paired end sequencing of SAMD00222565 DRX214819 40hpf A 1 Illumina TruSeq Stranded mRNA Library Prep Kit   RNA-Seq TRANSCRIPTOMIC PolyA PAIRED ILLUMINA Illumina NovaSeq 6000 <SPOT_DESCRIPTOR><SPOT_DECODE_SPEC><SPOT_LENGTH>200</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>101</BASE_COORD></READ_SPEC></SPOT_DECODE_SPEC></SPOT_DESCRIPTOR> DRP008458 Illumina NovaSeq 6000 paired end sequencing of SAMD00222565       14351831800.0 71759159.0 DRR224534 0:100 1:100 A:3552114377;C:3639389412;G:3719404253;T:3440817088;N:106670 100 100     3552114377 3639389412 3719404253 3440817088 106670 DRX214819 DRS236342 DRA010086 TOHOKUGL|Laboratory of organ morphogenesis Graduate School of Life Sciences, Tohoku University 2 0.96606 0.96569 0.04249 0.04107 0.7514 0.75367 0.49762 0.49753 100 100 B B biological fallback assumption illumina novaseq_era unknown poly_a trueseq bulk unknown unknown   Japan 2022-04-21 Pharyngula Embryo Fin Surface Structure
309 309 DRR224533 DRX214818 DRS236341 DRP008458 PRJDB9741 RNA seq for developing pectoral fin in zebrafish DRP008458 Other From the developmental view of fin to limb transition an important event in vertebrate evolution we seek fish specific genes that show characteristic expression pattern in the developing fin.       pectoral fin bud from gM1116A zebrafish at 32hpf C SAMD00222564   sample name:32hpf C                 Illumina NovaSeq 6000 paired end sequencing of SAMD00222564 DRX214818 32hpf C 1 Illumina TruSeq Stranded mRNA Library Prep Kit   RNA-Seq TRANSCRIPTOMIC PolyA PAIRED ILLUMINA Illumina NovaSeq 6000 <SPOT_DESCRIPTOR><SPOT_DECODE_SPEC><SPOT_LENGTH>200</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>101</BASE_COORD></READ_SPEC></SPOT_DECODE_SPEC></SPOT_DESCRIPTOR> DRP008458 Illumina NovaSeq 6000 paired end sequencing of SAMD00222564       18499667800.0 92498339.0 DRR224533 0:100 1:100 A:4655671152;C:4605325822;G:4688156846;T:4550378341;N:135639 100 100     4655671152 4605325822 4688156846 4550378341 135639 DRX214818 DRS236341 DRA010086 TOHOKUGL|Laboratory of organ morphogenesis Graduate School of Life Sciences, Tohoku University 2 0.9673 0.96864 0.04184 0.04008 0.73087 0.73318 0.48331 0.48043 100 100 B B biological fallback assumption illumina novaseq_era unknown poly_a trueseq bulk unknown unknown   Japan 2022-04-21 Pharyngula Embryo Fin Surface Structure
310 310 DRR224532 DRX214817 DRS236340 DRP008458 PRJDB9741 RNA seq for developing pectoral fin in zebrafish DRP008458 Other From the developmental view of fin to limb transition an important event in vertebrate evolution we seek fish specific genes that show characteristic expression pattern in the developing fin.       pectoral fin bud from gM1116A zebrafish at 32hpf B SAMD00222563   sample name:32hpf B                 Illumina NovaSeq 6000 paired end sequencing of SAMD00222563 DRX214817 32hpf B 1 Illumina TruSeq Stranded mRNA Library Prep Kit   RNA-Seq TRANSCRIPTOMIC PolyA PAIRED ILLUMINA Illumina NovaSeq 6000 <SPOT_DESCRIPTOR><SPOT_DECODE_SPEC><SPOT_LENGTH>200</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>101</BASE_COORD></READ_SPEC></SPOT_DECODE_SPEC></SPOT_DESCRIPTOR> DRP008458 Illumina NovaSeq 6000 paired end sequencing of SAMD00222563       19952418000.0 99762090.0 DRR224532 0:100 1:100 A:4972665902;C:5012518349;G:5094132814;T:4872951533;N:149402 100 100     4972665902 5012518349 5094132814 4872951533 149402 DRX214817 DRS236340 DRA010086 TOHOKUGL|Laboratory of organ morphogenesis Graduate School of Life Sciences, Tohoku University 2 0.97325 0.97252 0.03729 0.03575 0.71591 0.7163 0.47191 0.47859 100 100 B B biological fallback assumption illumina novaseq_era unknown poly_a trueseq bulk unknown unknown   Japan 2022-04-21 Pharyngula Embryo Fin Surface Structure
311 311 DRR224531 DRX214816 DRS236339 DRP008458 PRJDB9741 RNA seq for developing pectoral fin in zebrafish DRP008458 Other From the developmental view of fin to limb transition an important event in vertebrate evolution we seek fish specific genes that show characteristic expression pattern in the developing fin.       pectoral fin bud from gM1116A zebrafish at 32hpf A SAMD00222562   sample name:32hpf A                 Illumina NovaSeq 6000 paired end sequencing of SAMD00222562 DRX214816 32hpf A 1 Illumina TruSeq Stranded mRNA Library Prep Kit   RNA-Seq TRANSCRIPTOMIC PolyA PAIRED ILLUMINA Illumina NovaSeq 6000 <SPOT_DESCRIPTOR><SPOT_DECODE_SPEC><SPOT_LENGTH>200</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>101</BASE_COORD></READ_SPEC></SPOT_DECODE_SPEC></SPOT_DESCRIPTOR> DRP008458 Illumina NovaSeq 6000 paired end sequencing of SAMD00222562       16357024800.0 81785124.0 DRR224531 0:100 1:100 A:4049805675;C:4130985751;G:4172952730;T:4003159212;N:121432 100 100     4049805675 4130985751 4172952730 4003159212 121432 DRX214816 DRS236339 DRA010086 TOHOKUGL|Laboratory of organ morphogenesis Graduate School of Life Sciences, Tohoku University 2 0.97046 0.96886 0.03577 0.03489 0.73257 0.73231 0.4825 0.48849 100 100 B B biological fallback assumption illumina novaseq_era unknown poly_a trueseq bulk unknown unknown   Japan 2022-04-21 Pharyngula Embryo Fin Surface Structure
30714 30714 SRR28335985 SRX23944161 SRS20746054 SRP495075 PRJNA1087403 CUT&Tag Reveals a Return of Embryonic H3K4me3 Patterns During Zebrafish Tail Fin Regeneration RNA Seq GSE261539 Transcriptome Analysis The regenerative potential is governed by a complex process of transcriptional reprogramming involving nuclear reorganization and dynamics in transcription factor binding patterns throughout the genome. The degree to which chromatin and epigenetic changes influence this process remains only partially understood. Here we provide a modified CUT&Tag protocol suitable for improved characterization and interrogation of epigenetic changes during of zebrafish caudal fin regeneration. Data generated from our protocol recapitulates results from previously published ChIP Seq methods requires far fewer cells as input and significantly improves signal to noise ratios during profiling. We deliver high resolution enrichment maps for H3K4me3 at 0 dy post amputation DPA and 2DPA using tissue isolated from caudal fins. During regeneration we find that H3K4me3 levels increase over gene promoters which become transcriptionally active and H3K4me3 is lost at genes which are silenced. Remarkably these epigenetic alterations partially recapitulate H3K4me3 patterns that occur normally in 24 hpf embryos. Our results demonstrate that the CUT&Tag method is an effective tool for profiling chromatin landscapes in regenerating fins and that changes in genomic H3K4me3 patterns during fin regeneration occur in a manner consistent with reactivation of developmental programming. Overall design: RNA sequencing and analysis in 24 hpf zebrafish caudal fin folds parent bioproject:PRJNA1087399 pubmed:38645155;pubmed:39033118   Caudal fin fold 24hpf rep2 GSM8146271   source name:fin fold|tissue:fin fold|genotype:WT|treatment:n1|geo loc name:missing|collection date:missing Caudal fin fold 24hpf rep2 Sequenced reads were trimmed for adaptor sequence masked for low complexity or low quality sequence and mapped to danRer11 using STAR aligner Sorted BAM files generated by STAR were processed by deeptools' multibigwigsummary to create RPKM matrix for R's custom scripts to make visualizations bigWig files were also generated using deeptools' bamcoverage with the setting normalizeUsing RPKM Assembly: danRer11 Supplementary files format and content: bigWig fin fold caudal fin folds were amputated with 24 hpf embryos Fin folds were homogenized immediately post dissection and RNA was extracted using Trizol reagent. . RNA libraries were prepared for sequencing using standard Illumina protocols   tissue:fin fold|genotype:WT|treatment:n1 GSM8146271 GSM8146271: Caudal fin fold 24hpf rep2; Danio rerio; RNA Seq GSM8146271 r1 GSM8146271 1 Fin folds were homogenized immediately post dissection and RNA was extracted using Trizol reagent. . RNA libraries were prepared for sequencing using standard Illumina protocols   RNA-Seq TRANSCRIPTOMIC cDNA PAIRED ILLUMINA Illumina NovaSeq 6000   SRP495075   loader:fastq load.py RNAseq_ff_24hpf_rep2_001.fq.gz RNAseq_ff_24hpf_rep2_002.fq.gz fastq fastq 16589285400.0 55297618.0 GSM8146271 r1 0:150 1:150 A:4401530206;C:3938259310;G:3908531351;T:4340822067;N:142466 150 150     4401530206 3938259310 3908531351 4340822067 142466 SRX23944161 SRS20746054 SRA1823686 University of Rochester University of Rochester                       B B biological fallback assumption illumina novaseq_era unknown cdna_unspecified unknown bulk unknown unknown   United States 2024-03-13 Pharyngula Embryo Fin Surface Structure
30715 30715 SRR28335986 SRX23944160 SRS20746060 SRP495075 PRJNA1087403 CUT&Tag Reveals a Return of Embryonic H3K4me3 Patterns During Zebrafish Tail Fin Regeneration RNA Seq GSE261539 Transcriptome Analysis The regenerative potential is governed by a complex process of transcriptional reprogramming involving nuclear reorganization and dynamics in transcription factor binding patterns throughout the genome. The degree to which chromatin and epigenetic changes influence this process remains only partially understood. Here we provide a modified CUT&Tag protocol suitable for improved characterization and interrogation of epigenetic changes during of zebrafish caudal fin regeneration. Data generated from our protocol recapitulates results from previously published ChIP Seq methods requires far fewer cells as input and significantly improves signal to noise ratios during profiling. We deliver high resolution enrichment maps for H3K4me3 at 0 dy post amputation DPA and 2DPA using tissue isolated from caudal fins. During regeneration we find that H3K4me3 levels increase over gene promoters which become transcriptionally active and H3K4me3 is lost at genes which are silenced. Remarkably these epigenetic alterations partially recapitulate H3K4me3 patterns that occur normally in 24 hpf embryos. Our results demonstrate that the CUT&Tag method is an effective tool for profiling chromatin landscapes in regenerating fins and that changes in genomic H3K4me3 patterns during fin regeneration occur in a manner consistent with reactivation of developmental programming. Overall design: RNA sequencing and analysis in 24 hpf zebrafish caudal fin folds parent bioproject:PRJNA1087399 pubmed:38645155;pubmed:39033118   Caudal fin fold 24hpf rep1 GSM8146270   source name:fin fold|tissue:fin fold|genotype:WT|treatment:n1|geo loc name:missing|collection date:missing Caudal fin fold 24hpf rep1 Sequenced reads were trimmed for adaptor sequence masked for low complexity or low quality sequence and mapped to danRer11 using STAR aligner Sorted BAM files generated by STAR were processed by deeptools' multibigwigsummary to create RPKM matrix for R's custom scripts to make visualizations bigWig files were also generated using deeptools' bamcoverage with the setting normalizeUsing RPKM Assembly: danRer11 Supplementary files format and content: bigWig fin fold caudal fin folds were amputated with 24 hpf embryos Fin folds were homogenized immediately post dissection and RNA was extracted using Trizol reagent. . RNA libraries were prepared for sequencing using standard Illumina protocols   tissue:fin fold|genotype:WT|treatment:n1 GSM8146270 GSM8146270: Caudal fin fold 24hpf rep1; Danio rerio; RNA Seq GSM8146270 r1 GSM8146270 1 Fin folds were homogenized immediately post dissection and RNA was extracted using Trizol reagent. . RNA libraries were prepared for sequencing using standard Illumina protocols   RNA-Seq TRANSCRIPTOMIC cDNA PAIRED ILLUMINA Illumina NovaSeq 6000   SRP495075   loader:fastq load.py RNAseq_ff_24hpf_rep1_001.fq.gz RNAseq_ff_24hpf_rep1_002.fq.gz fastq fastq 14542846200.0 48476154.0 GSM8146270 r1 0:150 1:150 A:3861456413;C:3448964037;G:3421753399;T:3810547922;N:124429 150 150     3861456413 3448964037 3421753399 3810547922 124429 SRX23944160 SRS20746060 SRA1823686 University of Rochester University of Rochester                       B B biological fallback assumption illumina novaseq_era unknown cdna_unspecified unknown bulk unknown unknown   United States 2024-03-13 Pharyngula Embryo Fin Surface Structure

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