run_metadata
4 rows where devstage_curation = "Pharyngula" and tissue_curation = "Skin"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 33892 | 33892 | SRR30866052 | SRX26263961 | SRS22803217 | SRP536276 | PRJNA1168147 | Mgat4b mediated selective N glycosyl modification regulates melanocyte development and melanoma progression [scRNA seq] | GSE278654 | Transcriptome Analysis | Dysregulated melanocyte state transitions are a pivotal driver of melanoma development highlighting the need to identify key regulators of these processes. Understanding these factors is key to know how normal melanocyte functions and shift towards initiation of melanoma. Our study identifies Mgat4b a glycosyl transferase involved in selective N glycan branching enriched in pigment progenitors as a key regulator of directional melanocyte migration and establishment of Melanocyte stem cell McSC pool during early development in zebrafish and mammalian melanocytes. Single cell RNA sequencing analysis in zebrafish upon targeted disruption of Mgat4b reveals that a subset of melanocytes marked by aberrant galectin expression are impaired in migration and are lost. Lectin binding proteomic analysis reveals the glycosylation of key melanocyte proteins Gpnmb Kit and Tyrp1 to be under the control of Mgat4b. Additionally mislocalization of Gamma catenin Jup explains the observed defects in cell adhesion and migration to be regulated by mgat4b but not its isozyme mgat4a. Our meta analysis further revealed that melanoma patients with both the BrafV600E mutation and elevated Mgat4b levels have significantly worse survival outcomes compared to those with only the BrafV600E mutation. By leveraging the MAZERATI platform to model BrafV600E driver mutation in vivo we show that Mgat4b mutant cells fail to aggregate and initiate tumors. Our study underscores the importance of selective N glycan branching in both melanocyte development and melanoma initiation suggesting a Mitf controlled Mgat4b as a promising therapeutic target for melanoma treatment. Overall design: To understand how selective N glycosylation modification performed by mgat4b promote melanocyte development we performed single cell RNA sequencing of mitfa+ve melanophores sorted from the 36hpf staged zebrafish. | m4b mut | GSM8552316 | tissue:melanocytes|cell type:melanocytes|age:36 hpf|genotype:mgat4b mutant|treatment:No|geo loc name:missing|collection date:missing | m4b mut | Cellranger mkfastq pipeline was used to generate fastq files The fastq files were then aligned with custom zebrafish reference assembly GRCz11 using cellranger. Assembly: GRCz11 Supplementary files format and content: tab delimited text file including barcodes and features and matrix files | melanocytes | The gfp positive cells are isolated using FACS and 10x Genomics Next GEM three primereagent kit Dual Index was used for bead generation and cDNA synthesis 10x Genomics Next GEM three primereagent kit Dual Index was used for library construction | cell type:melanocytes|age:36 hpf|genotype:mgat4b mutant|treatment:No | GSM8552316 | GSM8552316: m4b mut; Danio rerio; RNA Seq | GSM8552316 r1 | GSM8552316 | 1 | The gfp positive cells are isolated using FACS and 10x Genomics Next GEM three primereagent kit Dual Index was used for bead generation and cDNA synthesis 10x Genomics Next GEM three primereagent kit Dual Index was used for library construction | RNA-Seq | TRANSCRIPTOMIC SINGLE CELL | cDNA | PAIRED | ILLUMINA | NextSeq 2000 | SRP536276 | loader:fastq load.py | m4b_mut_S2_L001_I1_001.fastq.gz m4b_mut_S2_L001_I2_001.fastq.gz m4b_mut_S2_L001_R1_001.fastq.gz m4b_mut_S2_L001_R2_001.fastq.gz | fastq fastq fastq fastq | 18274385040.0 | 132423080.0 | GSM8552316 r1 | 0:10 1:10 2:28 3:90 | A:3788703303;C:2355223955;G:2645521958;T:3126630009;N:1997975 | 10 | 10 | 28 | 90 | 3788703303 | 2355223955 | 2645521958 | 3126630009 | 1997975 | SRX26263961 | SRS22803217 | SRA1984944 | Pigment Cell Biology Lab, CSIR-IGIB | Pigment Cell Biology Lab, CSIR-IGIB | B | usable mapping rate | illumina | nextseq_v2 | unknown | cdna_unspecified | unknown | sc | single_cell_droplet | 10x | India | 2024-10-02 | Pharyngula | Embryo | Skin | Surface Structure | ||||||||||||||||||||||
| 33893 | 33893 | SRR30866053 | SRX26263960 | SRS22803216 | SRP536276 | PRJNA1168147 | Mgat4b mediated selective N glycosyl modification regulates melanocyte development and melanoma progression [scRNA seq] | GSE278654 | Transcriptome Analysis | Dysregulated melanocyte state transitions are a pivotal driver of melanoma development highlighting the need to identify key regulators of these processes. Understanding these factors is key to know how normal melanocyte functions and shift towards initiation of melanoma. Our study identifies Mgat4b a glycosyl transferase involved in selective N glycan branching enriched in pigment progenitors as a key regulator of directional melanocyte migration and establishment of Melanocyte stem cell McSC pool during early development in zebrafish and mammalian melanocytes. Single cell RNA sequencing analysis in zebrafish upon targeted disruption of Mgat4b reveals that a subset of melanocytes marked by aberrant galectin expression are impaired in migration and are lost. Lectin binding proteomic analysis reveals the glycosylation of key melanocyte proteins Gpnmb Kit and Tyrp1 to be under the control of Mgat4b. Additionally mislocalization of Gamma catenin Jup explains the observed defects in cell adhesion and migration to be regulated by mgat4b but not its isozyme mgat4a. Our meta analysis further revealed that melanoma patients with both the BrafV600E mutation and elevated Mgat4b levels have significantly worse survival outcomes compared to those with only the BrafV600E mutation. By leveraging the MAZERATI platform to model BrafV600E driver mutation in vivo we show that Mgat4b mutant cells fail to aggregate and initiate tumors. Our study underscores the importance of selective N glycan branching in both melanocyte development and melanoma initiation suggesting a Mitf controlled Mgat4b as a promising therapeutic target for melanoma treatment. Overall design: To understand how selective N glycosylation modification performed by mgat4b promote melanocyte development we performed single cell RNA sequencing of mitfa+ve melanophores sorted from the 36hpf staged zebrafish. | Control | GSM8552315 | tissue:melanocytes|cell type:melanocytes|age:36 hpf|genotype:control|treatment:No|geo loc name:missing|collection date:missing | Control | Cellranger mkfastq pipeline was used to generate fastq files The fastq files were then aligned with custom zebrafish reference assembly GRCz11 using cellranger. Assembly: GRCz11 Supplementary files format and content: tab delimited text file including barcodes and features and matrix files | melanocytes | The gfp positive cells are isolated using FACS and 10x Genomics Next GEM three primereagent kit Dual Index was used for bead generation and cDNA synthesis 10x Genomics Next GEM three primereagent kit Dual Index was used for library construction | cell type:melanocytes|age:36 hpf|genotype:control|treatment:No | GSM8552315 | GSM8552315: Control; Danio rerio; RNA Seq | GSM8552315 r1 | GSM8552315 | 1 | The gfp positive cells are isolated using FACS and 10x Genomics Next GEM three primereagent kit Dual Index was used for bead generation and cDNA synthesis 10x Genomics Next GEM three primereagent kit Dual Index was used for library construction | RNA-Seq | TRANSCRIPTOMIC SINGLE CELL | cDNA | PAIRED | ILLUMINA | NextSeq 2000 | SRP536276 | loader:fastq load.py | con_S1_L001_I1_001.fastq.gz con_S1_L001_I2_001.fastq.gz con_S1_L001_R1_001.fastq.gz con_S1_L001_R2_001.fastq.gz | fastq fastq fastq fastq | 15825218034.0 | 114675493.0 | GSM8552315 r1 | 0:10 1:10 2:28 3:90 | A:3074750870;C:2137365424;G:2401965854;T:2704984993;N:1727229 | 10 | 10 | 28 | 90 | 3074750870 | 2137365424 | 2401965854 | 2704984993 | 1727229 | SRX26263960 | SRS22803216 | SRA1984944 | Pigment Cell Biology Lab, CSIR-IGIB | Pigment Cell Biology Lab, CSIR-IGIB | B | usable mapping rate | illumina | nextseq_v2 | unknown | cdna_unspecified | unknown | sc | single_cell_droplet | 10x | India | 2024-10-02 | Pharyngula | Embryo | Skin | Surface Structure | ||||||||||||||||||||||
| 53011 | 53011 | SRR9662028 | SRX6422904 | SRS5079694 | SRP213938 | PRJNA553572 | A map of cis regulatory elements and 3D genome structures in zebrafish | GSE134055 | Other | The zebrafish has been widely used for the study of human disease and development as 70% of the protein coding genes are conserved between the two species. Annotation of functional control elements of the zebrafish genome however has lagged behind that of other model systems such as mouse and Drosophila. Based on multi omics approaches taken in the ENCODE and Roadmap Epigenomics projects we performed RNA seq ATAC seq ChIP seq and Hi C experiments in ten adult and two embryonic tissues to generate a comprehensive map of transcriptomes and regulatory elements in the zebrafish Tuebingen reference strain. Overall we have identified 235 596 cis regulatory elements which potentially shape the tissue specific and developmental stage specific gene expression in zebrafish. A comparison of zebrafish human and mouse regulatory elements allowed us to identify both evolutionarily conserved and species specific regulatory sequences. Furthermore through the analysis of Hi C data in zebrafish brain and muscle we observed different levels of 3D genome organization including compartment topological associating domains TADs and chromatin loops in zebrafish. A subset of TADs are deeply conserved between zebrafish and human. This work provides an additional epigenomic anchor for the functional annotation of vertebrate genomes and the study of evolutionally conserved elements of 3D genome organization. Overall design: 13 tissues from adult and embryonic stage were examined using ChIP Seq H3K27ac and H3K4me3 RNA Seq 11 of them were examined using ATAC seq WGBS and ChIP seq H3K9me3 and H3K9me2 and one scATAC seq in brain. Additionally we performed HiC experiments in adult muscle and brain. Please note that for the samples GSM4661977 GSM4662088 [1] each processed data generated from both replicates is linked to the corresponding *rep1 sample records [2] the input sample used for each ChIP sample is indicated in the description field in the corresponding input sample records. | pubmed:33239788;pubmed:35649578 | YueLab RNA Seq Skin rep2 | GSM3934896 | source name:Tissue|strain:Tuebingen|tissue:Skin | YueLab RNA Seq Skin rep2 | RNA seq reads were aligned to zv10 genome assembly using STAR; ChIP seq and ATAC seq reads were aligned to zv10 genome assembly using BWA HiC reads were aligned to zv10 genome assembly using Bowtie2 The TPM value of gene expression was caculated using RSEM ChIP seq and ATAC seq peaks were called using MACS2 with the following setting: ChIP seq q value <10e 2 p value<10e 5 Change>1 FC>2. ATAC seq: q value<10e 2 and p value<10e 5 HiC matrix was generated using HiC Pro Genome build: zv10 Supplementary files format and content: tab delimited text files include TPM values for each Sample; the narrowPeak files included the peaks for each Sample; The .hic file were the matrix of Hi C for each Sample.**All replicates were merged | Tissue | For each RNA seq experiment the same tissues combined from at least two Tuebingen fish were used as one replicate. For embryonic trunk ten 1 dpf fish were dechorionated with pronase and trunk were cut off for RNA seq. For embryonic neuron green cells from TgHuc:Kaede cells were sorted by FACS and approxinately 20 000 cells were used for one replicate. The tissue RNA was extracted from Trizol® according to the protocol Invitrogen. The cDNA libraries were performed using SureSelect Strand Specific RNA Library Preparation Kit Agilent according to the manufacturer’s protocol. Briefly polyA RNA was purified from 1000 ng of total RNA using oligo dT beads Invitrogen. Extracted RNA was first fragmented then followed by reverse transcription end repair adenylation adaptor ligation and subsequent PCR amplification. The final product was checked by size distribution and concentration using BioAnalyzer High Sensitivity DNA Kit Agilent and Kapa Library Quantification Kit Kapa Biosystems and then followed by pair end 2X 50 bp high throughput sequencing using HiSeq 2500 Illumina. | Embryonic and ault Tuebingen zebrafish were raised under standard laboratory conditions | strain:Tuebingen|tissue:Skin | GSM3934896 | GSM3934896: YueLab RNA Seq Skin rep2; Danio rerio; RNA Seq | GSM3934896 | 1 | For each RNA seq experiment the same tissues combined from at least two Tuebingen fish were used as one replicate. For embryonic trunk ten 1 dpf fish were dechorionated with pronase and trunk were cut off for RNA seq. For embryonic neuron green cells from TgHuc:Kaede cells were sorted by FACS and approxinately 20 000 cells were used for one replicate. The tissue RNA was extracted from Trizol® according to the protocol Invitrogen. The cDNA libraries were performed using SureSelect Strand Specific RNA Library Preparation Kit Agilent according to the manufacturer's protocol. Briefly polyA RNA was purified from 1000 ng of total RNA using oligo dT beads Invitrogen. Extracted RNA was first fragmented then followed by reverse transcription end repair adenylation adaptor ligation and subsequent PCR amplification. The final product was checked by size distribution and concentration using BioAnalyzer High Sensitivity DNA Kit Agilent and Kapa Library Quantification Kit Kapa Biosystems and then followed by pair end 2X 50 bp high throughput sequencing using HiSeq 2500 Illumina. | GEO Accession:GSM3934896 | RNA-Seq | TRANSCRIPTOMIC | cDNA | PAIRED | ILLUMINA | Illumina Genome Analyzer | SRP213938 | YueLab-RNA-Seq-Skin-rep2_1.fastq.gz YueLab-RNA-Seq-Skin-rep2_2.fastq.gz | fastq fastq | 3369540489.0 | 27929926.0 | GSM3934896 r1 | 0:60.47 1:60.17 | A:881257889;C:784720097;G:773160075;T:930047288;N:355140 | 60 | 60 | 881257889 | 784720097 | 773160075 | 930047288 | 355140 | SRX6422904 | SRS5079694 | SRA919194 | GEO | Feng Yue, Department of Biochemistry and Molecular Genetics, Northwestern University Feinberg School of Medicine | 2 | 0.96098 | 0.96359 | 0.1219 | 0.11985 | 0.69962 | 0.70161 | 0.48503 | 0.4877 | 61 | 60 | B | B | biological fallback assumption | illumina | early_illumina | unknown | poly_a | unknown | bulk | unknown | unknown | United States | 2019-07-09 | Pharyngula | Embryo | Skin | Surface Structure | |||||||||||
| 53012 | 53012 | SRR9662027 | SRX6422903 | SRS5079693 | SRP213938 | PRJNA553572 | A map of cis regulatory elements and 3D genome structures in zebrafish | GSE134055 | Other | The zebrafish has been widely used for the study of human disease and development as 70% of the protein coding genes are conserved between the two species. Annotation of functional control elements of the zebrafish genome however has lagged behind that of other model systems such as mouse and Drosophila. Based on multi omics approaches taken in the ENCODE and Roadmap Epigenomics projects we performed RNA seq ATAC seq ChIP seq and Hi C experiments in ten adult and two embryonic tissues to generate a comprehensive map of transcriptomes and regulatory elements in the zebrafish Tuebingen reference strain. Overall we have identified 235 596 cis regulatory elements which potentially shape the tissue specific and developmental stage specific gene expression in zebrafish. A comparison of zebrafish human and mouse regulatory elements allowed us to identify both evolutionarily conserved and species specific regulatory sequences. Furthermore through the analysis of Hi C data in zebrafish brain and muscle we observed different levels of 3D genome organization including compartment topological associating domains TADs and chromatin loops in zebrafish. A subset of TADs are deeply conserved between zebrafish and human. This work provides an additional epigenomic anchor for the functional annotation of vertebrate genomes and the study of evolutionally conserved elements of 3D genome organization. Overall design: 13 tissues from adult and embryonic stage were examined using ChIP Seq H3K27ac and H3K4me3 RNA Seq 11 of them were examined using ATAC seq WGBS and ChIP seq H3K9me3 and H3K9me2 and one scATAC seq in brain. Additionally we performed HiC experiments in adult muscle and brain. Please note that for the samples GSM4661977 GSM4662088 [1] each processed data generated from both replicates is linked to the corresponding *rep1 sample records [2] the input sample used for each ChIP sample is indicated in the description field in the corresponding input sample records. | pubmed:33239788;pubmed:35649578 | YueLab RNA Seq Skin rep1 | GSM3934895 | source name:Tissue|strain:Tuebingen|tissue:Skin | YueLab RNA Seq Skin rep1 | RNA seq reads were aligned to zv10 genome assembly using STAR; ChIP seq and ATAC seq reads were aligned to zv10 genome assembly using BWA HiC reads were aligned to zv10 genome assembly using Bowtie2 The TPM value of gene expression was caculated using RSEM ChIP seq and ATAC seq peaks were called using MACS2 with the following setting: ChIP seq q value <10e 2 p value<10e 5 Change>1 FC>2. ATAC seq: q value<10e 2 and p value<10e 5 HiC matrix was generated using HiC Pro Genome build: zv10 Supplementary files format and content: tab delimited text files include TPM values for each Sample; the narrowPeak files included the peaks for each Sample; The .hic file were the matrix of Hi C for each Sample.**All replicates were merged | Tissue | For each RNA seq experiment the same tissues combined from at least two Tuebingen fish were used as one replicate. For embryonic trunk ten 1 dpf fish were dechorionated with pronase and trunk were cut off for RNA seq. For embryonic neuron green cells from TgHuc:Kaede cells were sorted by FACS and approxinately 20 000 cells were used for one replicate. The tissue RNA was extracted from Trizol® according to the protocol Invitrogen. The cDNA libraries were performed using SureSelect Strand Specific RNA Library Preparation Kit Agilent according to the manufacturer’s protocol. Briefly polyA RNA was purified from 1000 ng of total RNA using oligo dT beads Invitrogen. Extracted RNA was first fragmented then followed by reverse transcription end repair adenylation adaptor ligation and subsequent PCR amplification. The final product was checked by size distribution and concentration using BioAnalyzer High Sensitivity DNA Kit Agilent and Kapa Library Quantification Kit Kapa Biosystems and then followed by pair end 2X 50 bp high throughput sequencing using HiSeq 2500 Illumina. | Embryonic and ault Tuebingen zebrafish were raised under standard laboratory conditions | strain:Tuebingen|tissue:Skin | GSM3934895 | GSM3934895: YueLab RNA Seq Skin rep1; Danio rerio; RNA Seq | GSM3934895 | 1 | For each RNA seq experiment the same tissues combined from at least two Tuebingen fish were used as one replicate. For embryonic trunk ten 1 dpf fish were dechorionated with pronase and trunk were cut off for RNA seq. For embryonic neuron green cells from TgHuc:Kaede cells were sorted by FACS and approxinately 20 000 cells were used for one replicate. The tissue RNA was extracted from Trizol® according to the protocol Invitrogen. The cDNA libraries were performed using SureSelect Strand Specific RNA Library Preparation Kit Agilent according to the manufacturer's protocol. Briefly polyA RNA was purified from 1000 ng of total RNA using oligo dT beads Invitrogen. Extracted RNA was first fragmented then followed by reverse transcription end repair adenylation adaptor ligation and subsequent PCR amplification. The final product was checked by size distribution and concentration using BioAnalyzer High Sensitivity DNA Kit Agilent and Kapa Library Quantification Kit Kapa Biosystems and then followed by pair end 2X 50 bp high throughput sequencing using HiSeq 2500 Illumina. | GEO Accession:GSM3934895 | RNA-Seq | TRANSCRIPTOMIC | cDNA | PAIRED | ILLUMINA | Illumina Genome Analyzer | SRP213938 | YueLab-RNA-Seq-Skin-rep1_1.fastq.gz YueLab-RNA-Seq-Skin-rep1_2.fastq.gz | fastq fastq | 2565035707.0 | 21260839.0 | GSM3934895 r1 | 0:60.48 1:60.17 | A:670789880;C:599392091;G:585931498;T:708654706;N:267532 | 60 | 60 | 670789880 | 599392091 | 585931498 | 708654706 | 267532 | SRX6422903 | SRS5079693 | SRA919194 | GEO | Feng Yue, Department of Biochemistry and Molecular Genetics, Northwestern University Feinberg School of Medicine | 2 | 0.96148 | 0.96283 | 0.12215 | 0.11903 | 0.70015 | 0.70114 | 0.47321 | 0.47375 | 60 | 60 | B | B | biological fallback assumption | illumina | early_illumina | unknown | poly_a | unknown | bulk | unknown | unknown | United States | 2019-07-09 | Pharyngula | Embryo | Skin | Surface Structure |
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");;