run_metadata
10 rows where experiment.library_selection = "RT-PCR", experiment.library_source = "TRANSCRIPTOMIC" and tissue_curation = "Heart"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 59387 | 59387 | SRR11869421 | SRX8419453 | SRS6730997 | SRP265157 | PRJNA635689 | Identification of potentially relevant genes for pathological cardiac hypertrophy | PRJNA635689 | Other | Identification of potentially relevant genes for excessive exercise induced pathological cardiac hypertrophy in zebrafish | RNAseq | ex3 | strain:not aplicable|isolate:not collected|breed:AB|cultivar:not collected|ecotype:not collected|age:6 mpf|dev stage:not collected|sex:male|tissue:heart|biomaterial provider:hunan normal university|genotype:WT|phenotype:Pathological cardiac hypertrophy|replicates:6|BioSampleModel:Model organism or animal | RNAseq of zebrafish : heart | EX H 3 | EX H 3 | RNA seq for Pathologically hypertrophied heart | RNA-Seq | TRANSCRIPTOMIC | RT-PCR | PAIRED | ILLUMINA | Illumina NovaSeq 6000 | SRP265157 | EX_H_3_R1.fastq.gz EX_H_3_R2.fastq.gz | fastq fastq | 6259636144.0 | 20727272.0 | EX H 3 R1.fastq.gz | 0:151 1:151 | A:1778280447;C:1363197355;G:1403049077;T:1715079291;N:29974 | 151 | 151 | 1778280447 | 1363197355 | 1403049077 | 1715079291 | 29974 | SRX8419453 | SRS6730997 | SRA1080960 | Hunan Normal University|college of physical education | Hunan Normal University | 2 | 0.92733 | 0.88813 | 0.0791 | 0.07597 | 0.76297 | 0.76771 | 0.50252 | 0.50158 | 151 | 151 | B | B | biological fallback assumption | illumina | novaseq_era | unknown | other | unknown | bulk | unknown | unknown | China | 2020-05-28 | Adult | Adult | Heart | Cardiovascular System | ||||||||||||||||||||
| 59388 | 59388 | SRR11869422 | SRX8419452 | SRS6730996 | SRP265157 | PRJNA635689 | Identification of potentially relevant genes for pathological cardiac hypertrophy | PRJNA635689 | Other | Identification of potentially relevant genes for excessive exercise induced pathological cardiac hypertrophy in zebrafish | RNAseq | ex2 | strain:not aplicable|isolate:not collected|breed:AB|cultivar:not collected|ecotype:not collected|age:6 mpf|dev stage:not collected|sex:male|tissue:heart|biomaterial provider:hunan normal university|genotype:WT|phenotype:Pathological cardiac hypertrophy|replicates:5|BioSampleModel:Model organism or animal | RNAseq of zebrafish : heart | EX H 2 | EX H 2 | RNA seq for Pathologically hypertrophied heart | RNA-Seq | TRANSCRIPTOMIC | RT-PCR | PAIRED | ILLUMINA | Illumina NovaSeq 6000 | SRP265157 | EX_H_2_R1.fastq.gz EX_H_2_R2.fastq.gz | fastq fastq | 8103625192.0 | 26833196.0 | EX H 2 R1.fastq.gz | 0:151 1:151 | A:2245093216;C:1807855840;G:1857514326;T:2193123949;N:37861 | 151 | 151 | 2245093216 | 1807855840 | 1857514326 | 2193123949 | 37861 | SRX8419452 | SRS6730996 | SRA1080960 | Hunan Normal University|college of physical education | Hunan Normal University | 2 | 0.92984 | 0.89009 | 0.06796 | 0.06486 | 0.76631 | 0.77163 | 0.4919 | 0.49814 | 151 | 151 | B | B | biological fallback assumption | illumina | novaseq_era | unknown | other | unknown | bulk | unknown | unknown | China | 2020-05-28 | Adult | Adult | Heart | Cardiovascular System | ||||||||||||||||||||
| 59389 | 59389 | SRR11869423 | SRX8419451 | SRS6730995 | SRP265157 | PRJNA635689 | Identification of potentially relevant genes for pathological cardiac hypertrophy | PRJNA635689 | Other | Identification of potentially relevant genes for excessive exercise induced pathological cardiac hypertrophy in zebrafish | RNAseq | ex1 | strain:not aplicable|isolate:not collected|breed:AB|cultivar:not collected|ecotype:not collected|age:6 mpf|dev stage:not collected|sex:male|tissue:heart|biomaterial provider:hunan normal university|genotype:WT|phenotype:Pathological cardiac hypertrophy|replicates:4|BioSampleModel:Model organism or animal | RNAseq of zebrafish : heart | EX H 1 | EX H 1 | RNA seq for Pathologically hypertrophied heart | RNA-Seq | TRANSCRIPTOMIC | RT-PCR | PAIRED | ILLUMINA | Illumina NovaSeq 6000 | SRP265157 | EX_H_1_R1.fastq.gz EX_H_1_R2.fastq.gz | fastq fastq | 6451974810.0 | 21364155.0 | EX H 1 R1.fastq.gz | 0:151 1:151 | A:1790936245;C:1436034787;G:1479727207;T:1745254376;N:22195 | 151 | 151 | 1790936245 | 1436034787 | 1479727207 | 1745254376 | 22195 | SRX8419451 | SRS6730995 | SRA1080960 | Hunan Normal University|college of physical education | Hunan Normal University | 2 | 0.93365 | 0.90193 | 0.07267 | 0.07043 | 0.77778 | 0.78121 | 0.49987 | 0.50115 | 151 | 151 | B | B | biological fallback assumption | illumina | novaseq_era | unknown | other | unknown | bulk | unknown | unknown | China | 2020-05-28 | Adult | Adult | Heart | Cardiovascular System | ||||||||||||||||||||
| 59390 | 59390 | SRR11869424 | SRX8419450 | SRS6730994 | SRP265157 | PRJNA635689 | Identification of potentially relevant genes for pathological cardiac hypertrophy | PRJNA635689 | Other | Identification of potentially relevant genes for excessive exercise induced pathological cardiac hypertrophy in zebrafish | RNAseq | con3 | strain:not aplicable|isolate:not collected|breed:AB|cultivar:not collected|ecotype:not collected|age:6 mpf|dev stage:not collected|sex:male|tissue:heart|biomaterial provider:hunan normal university|genotype:WT|phenotype:normal|replicates:3|BioSampleModel:Model organism or animal | RNAseq of zebrafish : heart | CON H 3 | CON H 3 | RNA seq for normal heart | RNA-Seq | TRANSCRIPTOMIC | RT-PCR | PAIRED | ILLUMINA | Illumina NovaSeq 6000 | SRP265157 | CON_H_3_R1.fastq.gz CON_H_3_R2.fastq.gz | fastq fastq | 6526853596.0 | 21612098.0 | CON H 3 R1.fastq.gz | 0:151 1:151 | A:1812103278;C:1452775339;G:1489864278;T:1772088823;N:21878 | 151 | 151 | 1812103278 | 1452775339 | 1489864278 | 1772088823 | 21878 | SRX8419450 | SRS6730994 | SRA1080960 | Hunan Normal University|college of physical education | Hunan Normal University | 2 | 0.93603 | 0.91137 | 0.07069 | 0.06842 | 0.77133 | 0.77435 | 0.52249 | 0.52352 | 151 | 151 | B | B | biological fallback assumption | illumina | novaseq_era | unknown | other | unknown | bulk | unknown | unknown | China | 2020-05-28 | Adult | Adult | Heart | Cardiovascular System | ||||||||||||||||||||
| 59391 | 59391 | SRR11869425 | SRX8419449 | SRS6730993 | SRP265157 | PRJNA635689 | Identification of potentially relevant genes for pathological cardiac hypertrophy | PRJNA635689 | Other | Identification of potentially relevant genes for excessive exercise induced pathological cardiac hypertrophy in zebrafish | RNAseq | con2 | strain:not aplicable|isolate:not collected|breed:AB|cultivar:not collected|ecotype:not collected|age:6 mpf|dev stage:not collected|sex:male|tissue:heart|biomaterial provider:hunan normal university|genotype:WT|phenotype:normal|replicates:2|BioSampleModel:Model organism or animal | RNAseq of zebrafish : heart | CON H 2 | CON H 2 | RNA seq for normal heart | RNA-Seq | TRANSCRIPTOMIC | RT-PCR | PAIRED | ILLUMINA | Illumina NovaSeq 6000 | SRP265157 | CON_H_2_R1.fastq.gz CON_H_2_R2.fastq.gz | fastq fastq | 6367520510.0 | 21084505.0 | CON H 2 R1.fastq.gz | 0:151 1:151 | A:1744234790;C:1437029037;G:1478909299;T:1707323187;N:24197 | 151 | 151 | 1744234790 | 1437029037 | 1478909299 | 1707323187 | 24197 | SRX8419449 | SRS6730993 | SRA1080960 | Hunan Normal University|college of physical education | Hunan Normal University | 2 | 0.93818 | 0.91397 | 0.07325 | 0.071 | 0.77429 | 0.77656 | 0.53623 | 0.53447 | 151 | 151 | B | B | biological fallback assumption | illumina | novaseq_era | unknown | other | unknown | bulk | unknown | unknown | China | 2020-05-28 | Adult | Adult | Heart | Cardiovascular System | ||||||||||||||||||||
| 59392 | 59392 | SRR11869426 | SRX8419448 | SRS6730992 | SRP265157 | PRJNA635689 | Identification of potentially relevant genes for pathological cardiac hypertrophy | PRJNA635689 | Other | Identification of potentially relevant genes for excessive exercise induced pathological cardiac hypertrophy in zebrafish | RNAseq | con1 | strain:not aplicable|isolate:not collected|breed:AB|cultivar:not collected|ecotype:not collected|age:6 mpf|dev stage:not collected|sex:male|tissue:heart|biomaterial provider:hunan normal university|genotype:WT|phenotype:normal|replicates:1|BioSampleModel:Model organism or animal | RNAseq of zebrafish : heart | CON H 1 | CON H 1 | RNA seq for normal heart | RNA-Seq | TRANSCRIPTOMIC | RT-PCR | PAIRED | ILLUMINA | Illumina NovaSeq 6000 | SRP265157 | CON_H_1_R1.fastq.gz CON_H_1_R2.fastq.gz | fastq fastq | 6359506336.0 | 21057968.0 | CON H 1 R1.fastq.gz | 0:151 1:151 | A:1739787665;C:1437042647;G:1482458254;T:1700195714;N:22056 | 151 | 151 | 1739787665 | 1437042647 | 1482458254 | 1700195714 | 22056 | SRX8419448 | SRS6730992 | SRA1080960 | Hunan Normal University|college of physical education | Hunan Normal University | 2 | 0.93392 | 0.90778 | 0.07115 | 0.06926 | 0.76814 | 0.77108 | 0.46067 | 0.49942 | 151 | 151 | B | B | biological fallback assumption | illumina | novaseq_era | unknown | other | unknown | bulk | unknown | unknown | China | 2020-05-28 | Adult | Adult | Heart | Cardiovascular System | ||||||||||||||||||||
| 66745 | 66745 | SRR16530663 | SRX12733276 | SRS10681588 | SRP342649 | PRJNA773625 | loft ventricle RNAseq | PRJNA773625 | Other | Cardiac looping and trabeculation are key processes during cardiac chamber maturation and alteration of these processes frequently causes congenital heart defects. Here we report the isolation cloning and characterization of the proprotein convertase furina from the cardiovascular mutant loft in zebrafish and thus establish its critical role in heart looping and trabecular development. Although heart defects are previously reported in zebrafish and mouse furin mutants it remains unclear what are the targets of Furin in the heart. This work presents a new layer of post translational modulation of Notch1b proteins by Furina during zebrafish cardiac looping and trabeculation and mutations in the Furina Notch1b axis may shed light on the genetic basis of congenital heart diseases in humans. | RNAseq of zebrafish heart | loft mutant RNAseq rep2 | strain:Tu|dev stage:3 dpf determined|tissue:ventricle|genotype:loft mutant|replicate:biological replicate 2|BioSampleModel:Model organism or animal | RNAseq of zebrafish heart | loft mutant RNAseq rep2 | loft mutant RNAseq rep2 | The cDNA libraries were constructed by MALBAC method KT110700424 Yikon Genomics | RNA-Seq | TRANSCRIPTOMIC | RT-PCR | PAIRED | ILLUMINA | Illumina HiSeq 2500 | SRP342649 | assembly:danRer7 | loft_mutant_RNAseq_rep2.1.bam loft_mutant_RNAseq_rep2.2.bam | bam bam | 4184284762.0 | 20714281.0 | loft mutant RNAseq rep2.1.bam | 0:101 1:101 | A:1235933017;C:598023900;G:852833672;T:1497442499;N:51674 | 101 | 101 | 1235933017 | 598023900 | 852833672 | 1497442499 | 51674 | SRX12733276 | SRS10681588 | SRA1315131 | Peking University|Institute of Molecular Medicine | Peking University | 2 | 0.4825 | 0.50527 | 0.2448 | 0.25451 | 0.87288 | 0.87888 | 0.46562 | 0.45703 | 101 | 101 | B | B | biological fallback assumption | illumina | hiseq_era | unknown | other | unknown | bulk | unknown | unknown | China | 2021-10-22 | Larval | Larval | Heart | Cardiovascular System | |||||||||||||||||||
| 66746 | 66746 | SRR16530664 | SRX12733275 | SRS10681587 | SRP342649 | PRJNA773625 | loft ventricle RNAseq | PRJNA773625 | Other | Cardiac looping and trabeculation are key processes during cardiac chamber maturation and alteration of these processes frequently causes congenital heart defects. Here we report the isolation cloning and characterization of the proprotein convertase furina from the cardiovascular mutant loft in zebrafish and thus establish its critical role in heart looping and trabecular development. Although heart defects are previously reported in zebrafish and mouse furin mutants it remains unclear what are the targets of Furin in the heart. This work presents a new layer of post translational modulation of Notch1b proteins by Furina during zebrafish cardiac looping and trabeculation and mutations in the Furina Notch1b axis may shed light on the genetic basis of congenital heart diseases in humans. | RNAseq of zebrafish heart | loft mutant RNAseq rep1 | strain:Tu|dev stage:3 dpf determined|tissue:ventricle|genotype:loft mutant|replicate:biological replicate 1|BioSampleModel:Model organism or animal | RNAseq of zebrafish heart | loft mutant RNAseq rep1 | loft mutant RNAseq rep1 | The cDNA libraries were constructed by MALBAC method KT110700424 Yikon Genomics | RNA-Seq | TRANSCRIPTOMIC | RT-PCR | PAIRED | ILLUMINA | Illumina HiSeq 2500 | SRP342649 | assembly:danRer7 | loft_mutant_RNAseq_rep1.1.bam loft_mutant_RNAseq_rep1.2.bam | bam bam | 4349194532.0 | 21530666.0 | loft mutant RNAseq rep1.1.bam | 0:101 1:101 | A:1285307324;C:607005074;G:876055199;T:1580773245;N:53690 | 101 | 101 | 1285307324 | 607005074 | 876055199 | 1580773245 | 53690 | SRX12733275 | SRS10681587 | SRA1315131 | Peking University|Institute of Molecular Medicine | Peking University | 2 | 0.50395 | 0.50527 | 0.2163 | 0.21684 | 0.87444 | 0.88371 | 0.47374 | 0.46918 | 101 | 101 | B | B | biological fallback assumption | illumina | hiseq_era | unknown | other | unknown | bulk | unknown | unknown | China | 2021-10-22 | Larval | Larval | Heart | Cardiovascular System | |||||||||||||||||||
| 66747 | 66747 | SRR16530665 | SRX12733274 | SRS10681586 | SRP342649 | PRJNA773625 | loft ventricle RNAseq | PRJNA773625 | Other | Cardiac looping and trabeculation are key processes during cardiac chamber maturation and alteration of these processes frequently causes congenital heart defects. Here we report the isolation cloning and characterization of the proprotein convertase furina from the cardiovascular mutant loft in zebrafish and thus establish its critical role in heart looping and trabecular development. Although heart defects are previously reported in zebrafish and mouse furin mutants it remains unclear what are the targets of Furin in the heart. This work presents a new layer of post translational modulation of Notch1b proteins by Furina during zebrafish cardiac looping and trabeculation and mutations in the Furina Notch1b axis may shed light on the genetic basis of congenital heart diseases in humans. | RNAseq of zebrafish heart | loft sibling RNAseq rep2 | strain:Tu|dev stage:3 dpf determined|tissue:ventricle|genotype:loft sibling|replicate:biological replicate 2|BioSampleModel:Model organism or animal | RNAseq of zebrafish heart | loft sibling RNAseq rep2 | loft sibling RNAseq rep2 | The cDNA libraries were constructed by MALBAC method KT110700424 Yikon Genomics | RNA-Seq | TRANSCRIPTOMIC | RT-PCR | PAIRED | ILLUMINA | Illumina HiSeq 2500 | SRP342649 | assembly:danRer7 | loft_sibling_RNAseq_rep2.1.bam loft_sibling_RNAseq_rep2.2.bam | bam bam | 3901869168.0 | 19316184.0 | loft sibling RNAseq rep2.1.bam | 0:101 1:101 | A:1145110581;C:555289006;G:798238595;T:1403183360;N:47626 | 101 | 101 | 1145110581 | 555289006 | 798238595 | 1403183360 | 47626 | SRX12733274 | SRS10681586 | SRA1315131 | Peking University|Institute of Molecular Medicine | Peking University | 2 | 0.47753 | 0.48927 | 0.20347 | 0.20928 | 0.86994 | 0.87726 | 0.46911 | 0.43318 | 101 | 101 | B | B | biological fallback assumption | illumina | hiseq_era | unknown | other | unknown | bulk | unknown | unknown | China | 2021-10-22 | Larval | Larval | Heart | Cardiovascular System | |||||||||||||||||||
| 66748 | 66748 | SRR16530666 | SRX12733273 | SRS10681585 | SRP342649 | PRJNA773625 | loft ventricle RNAseq | PRJNA773625 | Other | Cardiac looping and trabeculation are key processes during cardiac chamber maturation and alteration of these processes frequently causes congenital heart defects. Here we report the isolation cloning and characterization of the proprotein convertase furina from the cardiovascular mutant loft in zebrafish and thus establish its critical role in heart looping and trabecular development. Although heart defects are previously reported in zebrafish and mouse furin mutants it remains unclear what are the targets of Furin in the heart. This work presents a new layer of post translational modulation of Notch1b proteins by Furina during zebrafish cardiac looping and trabeculation and mutations in the Furina Notch1b axis may shed light on the genetic basis of congenital heart diseases in humans. | RNAseq of zebrafish heart | loft sibling RNAseq rep1 | strain:Tu|dev stage:3 dpf determined|tissue:ventricle|genotype:loft sibling|replicate:biological replicate 1|BioSampleModel:Model organism or animal | RNAseq of zebrafish heart | loft sibling RNAseq rep1 | loft sibling RNAseq rep1 | The cDNA libraries were constructed by MALBAC method KT110700424 Yikon Genomics | RNA-Seq | TRANSCRIPTOMIC | RT-PCR | PAIRED | ILLUMINA | Illumina HiSeq 2500 | SRP342649 | assembly:danRer7 | loft_sibling_RNAseq_rep1.1.bam loft_sibling_RNAseq_rep1.2.bam | bam bam | 3973568260.0 | 19671130.0 | loft sibling RNAseq rep1.1.bam | 0:101 1:101 | A:1171529555;C:572236920;G:816914171;T:1412839393;N:48221 | 101 | 101 | 1171529555 | 572236920 | 816914171 | 1412839393 | 48221 | SRX12733273 | SRS10681585 | SRA1315131 | Peking University|Institute of Molecular Medicine | Peking University | 2 | 0.47895 | 0.47714 | 0.25104 | 0.24998 | 0.86841 | 0.87568 | 0.46945 | 0.47273 | 101 | 101 | B | B | biological fallback assumption | illumina | hiseq_era | unknown | other | unknown | bulk | unknown | unknown | China | 2021-10-22 | Larval | Larval | Heart | Cardiovascular System |
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");;