RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

run_metadata

6 rows where devstage_curation = "Juvenile" and tissue_curation = "Lymphatic System"

✎ View and edit SQL

This data as json, CSV (advanced)

tissue_curation_coarse 1

tissue_curation 1

  • Lymphatic System · 6 ✖

technology 1

experiment.platform 1

experiment.library_strategy 1

experiment.library_source 1

experiment.library_selection 1

experiment.library_layout 1

devstage_curation_coarse 1

devstage_curation 1

  • Juvenile · 6 ✖
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
68893 68893 SRR18218072 SRX14364503 SRS12177798 SRP362416 PRJNA812715 Mutant IL7R collaborates with MYC to induce T cell Acute Lymphoblastic Leukemia PRJNA812715 Other T cell acute lymphoblastic leukemia T ALL is an aggressive pediatric cancer. Amongst the wide array of driver mutations 10% of T ALL patients display gain of function mutations in the IL 7 receptor alpha chain IL 7Ralpha encoded by IL7R which occur in different molecular subtypes of this disease. However it is still unclear whether IL 7R mutational activation is sufficient to transform T cell precursors. Also which genes cooperate with IL7R to drive leukemogenesis remain poorly defined. Here we demonstrate that mutant IL7R alone is capable of inducing T ALL with long latency in stable transgenic zebrafish and transformation is associated with MYC transcriptional activation. Additionally we find that mutant IL7R collaborates with Myc to induce early onset T ALL in transgenic zebrafish. T ALLs co expressing mutant IL7R and Myc show activation of STAT5 and AKT pathways harbor reduced numbers of apoptotic cells and remake tumors in transplanted zebrafish faster than T ALLs expressing Myc alone. Moreover limiting dilution cell transplantation experiments reveal that activated IL 7R signaling increases the overall frequency of leukemia propagating cells. Our work highlights a synergy between mutant IL7R and Myc in inducing T ALL and demonstrates that mutant IL7R enriches for leukemia propagating potential.         Tu AB mMyc 7   strain:Tu/AB|age:41 days|sex:not collected|tissue:lymphoid|birth date:04 11 2016|death date:15 12 2016|genotype:rag2:mCherry rag2:mMyc|biological replicate:Tu AB mMyc biological replicate 3|BioSampleModel:Model organism or animal                 RNA seq of Danio rerio leukemia overexpressing mouse Myc Tu/AB Tu AB mMyc 7 Tu AB mMyc 7 Tu/AB zebrafish overexpressing mouse Myc transiently were sacrificed when moribund and sorted leukemias were harvested for further analysis. The RNA was extracted from sorted cells using the RNeasy Mini Kit according to the manufacturers instructions Qiagen. mRNA was enriched using magnetic beads with Oligo dT fragmented and converted to cDNA size selected and PCR amplified generating paired end 100 bp sequences using a Illumina NovaSeq 6000.     RNA-Seq TRANSCRIPTOMIC PolyA PAIRED ILLUMINA Illumina NovaSeq 6000   SRP362416     FCHT5GHDSXX_L1_HKRDZEBmfpEAAXRAAPEI-P87H3_1.fq.gz FCHT5GHDSXX_L1_HKRDZEBmfpEAAXRAAPEI-P87H3_2.fq.gz fastq fastq 18002105400.0 60007018.0 FCHT5GHDSXX L1 HKRDZEBmfpEAAXRAAPEI P87H3 1.fq.gz 0:150 1:150 A:4483057959;C:4549819065;G:4562924506;T:4406277865;N:26005 150 150     4483057959 4549819065 4562924506 4406277865 26005 SRX14364503 SRS12177798 SRA1380603 Instituto de Medicina Molecular Joao Lobo Antunes|JBarata lab Instituto de Medicina Molecular Joao Lobo Antunes 2 0.9259 0.92681 0.09642 0.09697 0.82479 0.82546 0.50634 0.5148 150 150 B B biological fallback assumption illumina novaseq_era unknown poly_a unknown bulk unknown unknown   Portugal 2022-03-04 Juvenile Juvenile Lymphatic System Cardiovascular System
68894 68894 SRR18218073 SRX14364502 SRS12177797 SRP362416 PRJNA812715 Mutant IL7R collaborates with MYC to induce T cell Acute Lymphoblastic Leukemia PRJNA812715 Other T cell acute lymphoblastic leukemia T ALL is an aggressive pediatric cancer. Amongst the wide array of driver mutations 10% of T ALL patients display gain of function mutations in the IL 7 receptor alpha chain IL 7Ralpha encoded by IL7R which occur in different molecular subtypes of this disease. However it is still unclear whether IL 7R mutational activation is sufficient to transform T cell precursors. Also which genes cooperate with IL7R to drive leukemogenesis remain poorly defined. Here we demonstrate that mutant IL7R alone is capable of inducing T ALL with long latency in stable transgenic zebrafish and transformation is associated with MYC transcriptional activation. Additionally we find that mutant IL7R collaborates with Myc to induce early onset T ALL in transgenic zebrafish. T ALLs co expressing mutant IL7R and Myc show activation of STAT5 and AKT pathways harbor reduced numbers of apoptotic cells and remake tumors in transplanted zebrafish faster than T ALLs expressing Myc alone. Moreover limiting dilution cell transplantation experiments reveal that activated IL 7R signaling increases the overall frequency of leukemia propagating cells. Our work highlights a synergy between mutant IL7R and Myc in inducing T ALL and demonstrates that mutant IL7R enriches for leukemia propagating potential.         Tu AB mMyc 6   strain:Tu/AB|age:42 days|sex:not collected|tissue:lymphoid|birth date:03 11 2016|death date:15 12 2016|genotype:rag2:mCherry rag2:mMyc|biological replicate:Tu AB mMyc biological replicate 2|BioSampleModel:Model organism or animal                 RNA seq of Danio rerio leukemia overexpressing mouse Myc Tu/AB Tu AB mMyc 6 Tu AB mMyc 6 Tu/AB zebrafish overexpressing mouse Myc transiently were sacrificed when moribund and sorted leukemias were harvested for further analysis. The RNA was extracted from sorted cells using the RNeasy Mini Kit according to the manufacturers instructions Qiagen. mRNA was enriched using magnetic beads with Oligo dT fragmented and converted to cDNA size selected and PCR amplified generating paired end 100 bp sequences using a Illumina NovaSeq 6000.     RNA-Seq TRANSCRIPTOMIC PolyA PAIRED ILLUMINA Illumina NovaSeq 6000   SRP362416     FCHT5GHDSXX_L1_HKRDZEBmfpEAAWRABPEI-P75G3_1.fq.gz FCHT5GHDSXX_L1_HKRDZEBmfpEAAWRABPEI-P75G3_2.fq.gz fastq fastq 18085463400.0 60284878.0 FCHT5GHDSXX L1 HKRDZEBmfpEAAWRABPEI P75G3 1.fq.gz 0:150 1:150 A:4716166539;C:4371919988;G:4399782048;T:4597568953;N:25872 150 150     4716166539 4371919988 4399782048 4597568953 25872 SRX14364502 SRS12177797 SRA1380603 Instituto de Medicina Molecular Joao Lobo Antunes|JBarata lab Instituto de Medicina Molecular Joao Lobo Antunes 2 0.90432 0.90596 0.06444 0.06367 0.80048 0.80095 0.51671 0.51624 150 150 B B biological fallback assumption illumina novaseq_era unknown poly_a unknown bulk unknown unknown   Portugal 2022-03-04 Juvenile Juvenile Lymphatic System Cardiovascular System
68895 68895 SRR18218074 SRX14364501 SRS12177796 SRP362416 PRJNA812715 Mutant IL7R collaborates with MYC to induce T cell Acute Lymphoblastic Leukemia PRJNA812715 Other T cell acute lymphoblastic leukemia T ALL is an aggressive pediatric cancer. Amongst the wide array of driver mutations 10% of T ALL patients display gain of function mutations in the IL 7 receptor alpha chain IL 7Ralpha encoded by IL7R which occur in different molecular subtypes of this disease. However it is still unclear whether IL 7R mutational activation is sufficient to transform T cell precursors. Also which genes cooperate with IL7R to drive leukemogenesis remain poorly defined. Here we demonstrate that mutant IL7R alone is capable of inducing T ALL with long latency in stable transgenic zebrafish and transformation is associated with MYC transcriptional activation. Additionally we find that mutant IL7R collaborates with Myc to induce early onset T ALL in transgenic zebrafish. T ALLs co expressing mutant IL7R and Myc show activation of STAT5 and AKT pathways harbor reduced numbers of apoptotic cells and remake tumors in transplanted zebrafish faster than T ALLs expressing Myc alone. Moreover limiting dilution cell transplantation experiments reveal that activated IL 7R signaling increases the overall frequency of leukemia propagating cells. Our work highlights a synergy between mutant IL7R and Myc in inducing T ALL and demonstrates that mutant IL7R enriches for leukemia propagating potential.         Tu AB mMyc 5   strain:Tu/AB|age:42 days|sex:not collected|tissue:lymphoid|birth date:03 11 2016|death date:15 12 2016|genotype:rag2:mCherry rag2:mMyc|biological replicate:Tu AB mMyc biological replicate 1|BioSampleModel:Model organism or animal                 RNA seq of Danio rerio leukemia overexpressing mouse Myc Tu/AB Tu AB mMyc 5 Tu AB mMyc 5 Tu/AB zebrafish overexpressing mouse Myc transiently were sacrificed when moribund and sorted leukemias were harvested for further analysis. The RNA was extracted from sorted cells using the RNeasy Mini Kit according to the manufacturers instructions Qiagen. mRNA was enriched using magnetic beads with Oligo dT fragmented and converted to cDNA size selected and PCR amplified generating paired end 100 bp sequences using a Illumina NovaSeq 6000.     RNA-Seq TRANSCRIPTOMIC PolyA PAIRED ILLUMINA Illumina NovaSeq 6000   SRP362416     FCHT5GHDSXX_L1_HKRDZEBmfpEAAVRAAPEI-P63F3_1.fq.gz FCHT5GHDSXX_L1_HKRDZEBmfpEAAVRAAPEI-P63F3_2.fq.gz fastq fastq 18063312600.0 60211042.0 FCHT5GHDSXX L1 HKRDZEBmfpEAAVRAAPEI P63F3 1.fq.gz 0:150 1:150 A:4440821008;C:4618318980;G:4635597240;T:4368548938;N:26434 150 150     4440821008 4618318980 4635597240 4368548938 26434 SRX14364501 SRS12177796 SRA1380603 Instituto de Medicina Molecular Joao Lobo Antunes|JBarata lab Instituto de Medicina Molecular Joao Lobo Antunes 2 0.91708 0.91735 0.0319 0.0316 0.80793 0.80744 0.50004 0.5071 150 150 B B biological fallback assumption illumina novaseq_era unknown poly_a unknown bulk unknown unknown   Portugal 2022-03-04 Juvenile Juvenile Lymphatic System Cardiovascular System
68898 68898 SRR18218077 SRX14364498 SRS12177793 SRP362416 PRJNA812715 Mutant IL7R collaborates with MYC to induce T cell Acute Lymphoblastic Leukemia PRJNA812715 Other T cell acute lymphoblastic leukemia T ALL is an aggressive pediatric cancer. Amongst the wide array of driver mutations 10% of T ALL patients display gain of function mutations in the IL 7 receptor alpha chain IL 7Ralpha encoded by IL7R which occur in different molecular subtypes of this disease. However it is still unclear whether IL 7R mutational activation is sufficient to transform T cell precursors. Also which genes cooperate with IL7R to drive leukemogenesis remain poorly defined. Here we demonstrate that mutant IL7R alone is capable of inducing T ALL with long latency in stable transgenic zebrafish and transformation is associated with MYC transcriptional activation. Additionally we find that mutant IL7R collaborates with Myc to induce early onset T ALL in transgenic zebrafish. T ALLs co expressing mutant IL7R and Myc show activation of STAT5 and AKT pathways harbor reduced numbers of apoptotic cells and remake tumors in transplanted zebrafish faster than T ALLs expressing Myc alone. Moreover limiting dilution cell transplantation experiments reveal that activated IL 7R signaling increases the overall frequency of leukemia propagating cells. Our work highlights a synergy between mutant IL7R and Myc in inducing T ALL and demonstrates that mutant IL7R enriches for leukemia propagating potential.         Tu AB mMyc+P1mut 6   strain:Tu/AB|age:35 days|sex:not collected|tissue:lymphoid|birth date:30 08 2016|death date:04 10 2016|genotype:rag2:mCherry rag2:mMyc rag2:hIL7R mut1|biological replicate:Tu AB mMyc+P1mut biological replicate 3|BioSampleModel:Model organism or animal                 RNA seq of Danio rerio leukemia overexpressing mouse Myc and human mutant IL7R Tu/AB Tu AB mMyc+P1mut 6 Tu AB mMyc+P1mut 6 Tu/AB zebrafish overexpressing mouse Myc and human mutant IL7R transiently were sacrificed when moribund and sorted leukemias were harvested for further analysis. The RNA was extracted from sorted cells using the RNeasy Mini Kit according to the manufacturers instructions Qiagen. mRNA was enriched using magnetic beads with Oligo dT fragmented and converted to cDNA size selected and PCR amplified generating paired end 100 bp sequences using a Illumina NovaSeq 6000.     RNA-Seq TRANSCRIPTOMIC PolyA PAIRED ILLUMINA Illumina NovaSeq 6000   SRP362416     FCHT5GHDSXX_L1_HKRDZEBmfpEABARAAPEI-P28C4_1.fq.gz FCHT5GHDSXX_L1_HKRDZEBmfpEABARAAPEI-P28C4_2.fq.gz fastq fastq 18034321800.0 60114406.0 FCHT5GHDSXX L1 HKRDZEBmfpEABARAAPEI P28C4 1.fq.gz 0:150 1:150 A:4518122158;C:4519676234;G:4543758117;T:4452738564;N:26727 150 150     4518122158 4519676234 4543758117 4452738564 26727 SRX14364498 SRS12177793 SRA1380603 Instituto de Medicina Molecular Joao Lobo Antunes|JBarata lab Instituto de Medicina Molecular Joao Lobo Antunes 2 0.94431 0.94437 0.10494 0.10462 0.83177 0.83037 0.51143 0.51642 150 150 B B biological fallback assumption illumina novaseq_era unknown poly_a unknown bulk unknown unknown   Portugal 2022-03-04 Juvenile Juvenile Lymphatic System Cardiovascular System
68899 68899 SRR18218078 SRX14364497 SRS12177792 SRP362416 PRJNA812715 Mutant IL7R collaborates with MYC to induce T cell Acute Lymphoblastic Leukemia PRJNA812715 Other T cell acute lymphoblastic leukemia T ALL is an aggressive pediatric cancer. Amongst the wide array of driver mutations 10% of T ALL patients display gain of function mutations in the IL 7 receptor alpha chain IL 7Ralpha encoded by IL7R which occur in different molecular subtypes of this disease. However it is still unclear whether IL 7R mutational activation is sufficient to transform T cell precursors. Also which genes cooperate with IL7R to drive leukemogenesis remain poorly defined. Here we demonstrate that mutant IL7R alone is capable of inducing T ALL with long latency in stable transgenic zebrafish and transformation is associated with MYC transcriptional activation. Additionally we find that mutant IL7R collaborates with Myc to induce early onset T ALL in transgenic zebrafish. T ALLs co expressing mutant IL7R and Myc show activation of STAT5 and AKT pathways harbor reduced numbers of apoptotic cells and remake tumors in transplanted zebrafish faster than T ALLs expressing Myc alone. Moreover limiting dilution cell transplantation experiments reveal that activated IL 7R signaling increases the overall frequency of leukemia propagating cells. Our work highlights a synergy between mutant IL7R and Myc in inducing T ALL and demonstrates that mutant IL7R enriches for leukemia propagating potential.         Tu AB mMyc+P1mut 5   strain:Tu/AB|age:35 days|sex:not collected|tissue:lymphoid|birth date:30 08 2016|death date:04 10 2016|genotype:rag2:mCherry rag2:mMyc rag2:hIL7R mut1|biological replicate:Tu AB mMyc+P1mut biological replicate 2|BioSampleModel:Model organism or animal                 RNA seq of Danio rerio leukemia overexpressing mouse Myc and human mutant IL7R Tu/AB Tu AB mMyc+P1mut 5 Tu AB mMyc+P1mut 5 Tu/AB zebrafish overexpressing mouse Myc and human mutant IL7R transiently were sacrificed when moribund and sorted leukemias were harvested for further analysis. The RNA was extracted from sorted cells using the RNeasy Mini Kit according to the manufacturers instructions Qiagen. mRNA was enriched using magnetic beads with Oligo dT fragmented and converted to cDNA size selected and PCR amplified generating paired end 100 bp sequences using a Illumina NovaSeq 6000.     RNA-Seq TRANSCRIPTOMIC PolyA PAIRED ILLUMINA Illumina NovaSeq 6000   SRP362416     FCHT5GHDSXX_L1_HKRDZEBmfpEAAZRAAPEI-P16B4_1.fq.gz FCHT5GHDSXX_L1_HKRDZEBmfpEAAZRAAPEI-P16B4_2.fq.gz fastq fastq 17750634300.0 59168781.0 FCHT5GHDSXX L1 HKRDZEBmfpEAAZRAAPEI P16B4 1.fq.gz 0:150 1:150 A:4503506819;C:4398697723;G:4432972998;T:4415430837;N:25923 150 150     4503506819 4398697723 4432972998 4415430837 25923 SRX14364497 SRS12177792 SRA1380603 Instituto de Medicina Molecular Joao Lobo Antunes|JBarata lab Instituto de Medicina Molecular Joao Lobo Antunes 2 0.94306 0.94321 0.07511 0.0748 0.79837 0.79819 0.51326 0.50902 150 150 B B biological fallback assumption illumina novaseq_era unknown poly_a unknown bulk unknown unknown   Portugal 2022-03-04 Juvenile Juvenile Lymphatic System Cardiovascular System
68900 68900 SRR18218079 SRX14364496 SRS12177791 SRP362416 PRJNA812715 Mutant IL7R collaborates with MYC to induce T cell Acute Lymphoblastic Leukemia PRJNA812715 Other T cell acute lymphoblastic leukemia T ALL is an aggressive pediatric cancer. Amongst the wide array of driver mutations 10% of T ALL patients display gain of function mutations in the IL 7 receptor alpha chain IL 7Ralpha encoded by IL7R which occur in different molecular subtypes of this disease. However it is still unclear whether IL 7R mutational activation is sufficient to transform T cell precursors. Also which genes cooperate with IL7R to drive leukemogenesis remain poorly defined. Here we demonstrate that mutant IL7R alone is capable of inducing T ALL with long latency in stable transgenic zebrafish and transformation is associated with MYC transcriptional activation. Additionally we find that mutant IL7R collaborates with Myc to induce early onset T ALL in transgenic zebrafish. T ALLs co expressing mutant IL7R and Myc show activation of STAT5 and AKT pathways harbor reduced numbers of apoptotic cells and remake tumors in transplanted zebrafish faster than T ALLs expressing Myc alone. Moreover limiting dilution cell transplantation experiments reveal that activated IL 7R signaling increases the overall frequency of leukemia propagating cells. Our work highlights a synergy between mutant IL7R and Myc in inducing T ALL and demonstrates that mutant IL7R enriches for leukemia propagating potential.         Tu AB mMyc+P1mut 4   strain:Tu/AB|age:35 days|sex:not collected|tissue:lymphoid|birth date:30 08 2016|death date:04 10 2016|genotype:rag2:mCherry rag2:mMyc rag2:hIL7R mut1|biological replicate:Tu AB mMyc+P1mut biological replicate 1|BioSampleModel:Model organism or animal                 RNA seq of Danio rerio leukemia overexpressing mouse Myc and human mutant IL7R Tu/AB Tu AB mMyc+P1mut 4 Tu AB mMyc+P1mut 4 Tu/AB zebrafish overexpressing mouse Myc and human mutant IL7R transiently were sacrificed when moribund and sorted leukemias were harvested for further analysis. The RNA was extracted from sorted cells using the RNeasy Mini Kit according to the manufacturers instructions Qiagen. mRNA was enriched using magnetic beads with Oligo dT fragmented and converted to cDNA size selected and PCR amplified generating paired end 100 bp sequences using a Illumina NovaSeq 6000.     RNA-Seq TRANSCRIPTOMIC PolyA PAIRED ILLUMINA Illumina NovaSeq 6000   SRP362416     FCHT5GHDSXX_L1_HKRDZEBmfpEAAYRAAPEI-P4A4_1.fq.gz FCHT5GHDSXX_L1_HKRDZEBmfpEAAYRAAPEI-P4A4_2.fq.gz fastq fastq 18063110700.0 60210369.0 FCHT5GHDSXX L1 HKRDZEBmfpEAAYRAAPEI P4A4 1.fq.gz 0:150 1:150 A:4583950532;C:4496933352;G:4489104841;T:4493095718;N:26257 150 150     4583950532 4496933352 4489104841 4493095718 26257 SRX14364496 SRS12177791 SRA1380603 Instituto de Medicina Molecular Joao Lobo Antunes|JBarata lab Instituto de Medicina Molecular Joao Lobo Antunes 2 0.95231 0.9534 0.12525 0.12554 0.84404 0.84323 0.52132 0.53078 150 150 B B biological fallback assumption illumina novaseq_era unknown poly_a unknown bulk unknown unknown   Portugal 2022-03-04 Juvenile Juvenile Lymphatic System Cardiovascular 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");;