run_metadata
4 rows where experiment.library_layout = "SINGLE", experiment.library_selection = "Oligo-dT" and tissue_curation_coarse = "Cardiovascular System"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5879 | 5879 | ERR1759701 | ERX1826022 | ERS1474296 | ERP020578 | PRJEB18632 | RNA Seq analyses of zebrafish cardiomyocytes at 72 hpf | E-MTAB-5323 | Transcriptome Analysis | The aim of this analysis is to uncover novel molecules synthesized and secreted from cardiomyocytes. | ENA FIRST PUBLIC:2016 12 20|ENA LAST UPDATE:2016 12 15|ArrayExpress:E MTAB 5323 | Protocols: To obtain only cardiomyocytes from the heart two transgenic zebrafish lines were established; Tgmyl7:NLS mCherry and Tgmyl7:actn2 tdEos. Using cardiac myosin light chain myl7 promoter nuclear localization signal conjugated monomeric Cherry or actinin alpha 2 conjugated tandem Eos was expressed in cardiomyocytes. Hearts resected from Tgmyl7:NLS mCherry or Tgmyl7:actn2 tdEos larvae at 72 hpf were collected and digested with protease solution PBS with 5 mg/ml trypsin and 1 mM EDTA pH 8.0 for 1 h. Digestion was terminated with stop solution PBS with 30% fetal bovine serum and 6 mL calcium chloride. mCherry or tdEos positive cells were collected as cardiomyocytes using a FACS Aria III cell sorter BD Bioscience Total RNAs were prepared from mCherry or tdEos positive cells using a NucleoSpin XS kit Macherey Nagel according to the manufacture's instruction. Reverse transcription RT and cDNA library preparation were performed with a SMARTer Ultra Low RNA kit Clontech. cDNA was fragmented with a Covaris S 220 instrument Covaris. Subsequently the sample was end repaired dA tailed adaptor ligated and then subjected to PCR by using a NEBNext DNA Library Preparation and NEBNext Multiplex oligos for Illumina New England BioLabs. | Sample2 | SAMEA27136168 | Department of Cell Biology National Cerebral and Cardiovascular Center Research Institute | ENA first public:2016 12 20|ENA last update:2016 12 15|External Id:SAMEA27136168|INSDC center alias:Department of Cell Biology National Cerebral and Cardiovascular Center Research Institute|INSDC center name:Department of Cell Biology National Cerebral and Cardiovascular Center Research Institute|INSDC first public:2016 12 20T17:02:09Z|INSDC last update:2016 12 15T11:23:10Z|INSDC status:public|Submitter Id:E MTAB 5323:Sample2|broker name:ArrayExpress|cell type:cardiac myocyte|common name:zebrafish|developmental stage:72 hpf|genotype:Tgmyl7:actn2 tdEodncv44Tg|sample name:E MTAB 5323:Sample2 | Illumina MiSeq sequencing; RNA Seq analyses of zebrafish cardiomyocytes at 72 hpf | E MTAB 5323:Sample2 s | Sample2 s | RNA Seq analyses of zebrafish cardiomyocytes at 72 hpf | To obtain only cardiomyocytes from the heart two transgenic zebrafish lines were established; Tgmyl7:NLS mCherry and Tgmyl7:actn2 tdEos. Using cardiac myosin light chain myl7 promoter nuclear localization signal conjugated monomeric Cherry or actinin alpha 2 conjugated tandem Eos was expressed in cardiomyocytes. Hearts resected from Tgmyl7:NLS mCherry or Tgmyl7:actn2 tdEos larvae at 72 hpf were collected and digested with protease solution PBS with 5 mg/ml trypsin and 1 mM EDTA pH 8.0 for 1 h. Digestion was terminated with stop solution PBS with 30% fetal bovine serum and 6 mL calcium chloride. mCherry or tdEos positive cells were collected as cardiomyocytes using a FACS Aria III cell sorter BD Bioscience Total RNAs were prepared from mCherry or tdEos positive cells using a NucleoSpin XS kit Macherey Nagel according to the manufacture’s instruction. Reverse transcription RT and cDNA library preparation were performed with a SMARTer Ultra Low RNA kit Clontech. cDNA was fragmented with a Covaris S 220 instrument Covaris. Subsequently the sample was end repaired dA tailed adaptor ligated and then subjected to PCR by using a NEBNext DNA Library Preparation and NEBNext Multiplex oligos for Illumina New England BioLabs. | Experimental Factor: Tgmyl7:actn2 tdEodncv44Tg:genotype | RNA-Seq | TRANSCRIPTOMIC | Oligo-dT | SINGLE | ILLUMINA | Illumina MiSeq | ERP020578 | Illumina MiSeq sequencing; RNA Seq analyses of zebrafish cardiomyocytes at 72 hpf | ENA FIRST PUBLIC:2016 12 20|ENA LAST UPDATE:2018 11 16 | mochizukis_lab_myl7_actn2tdEos_72h_01.fastq.gz | fastq | 448234901.0 | 6016977.0 | E MTAB 5323:Sample2 | 0:74.50 1:0 | A:118923409;C:100586009;G:99987046;T:126071553;N:2666884 | 74 | 0 | 118923409 | 100586009 | 99987046 | 126071553 | 2666884 | ERX1826022 | ERS1474296 | ERA776061 | Department of Cell Biology National Cerebral and Cardiovascular Center Research Institute|European Nucleotide Archive | Department of Cell Biology National Cerebral and Cardiovascular Center Research Institute|European Nucleotide Archive | 1 | 0.88465 | 0.27583 | 0.75398 | 0.55917 | 75 | B | usable mapping rate | illumina | miseq | full_length | poly_a | nebnext | bulk | unknown | unknown | Japan | 2016-12-15 | Larval | Larval | Heart | Cardiovascular System | |||||||||||||||||||
| 5880 | 5880 | ERR1759702 | ERX1826022 | ERS1474296 | ERP020578 | PRJEB18632 | RNA Seq analyses of zebrafish cardiomyocytes at 72 hpf | E-MTAB-5323 | Transcriptome Analysis | The aim of this analysis is to uncover novel molecules synthesized and secreted from cardiomyocytes. | ENA FIRST PUBLIC:2016 12 20|ENA LAST UPDATE:2016 12 15|ArrayExpress:E MTAB 5323 | Protocols: To obtain only cardiomyocytes from the heart two transgenic zebrafish lines were established; Tgmyl7:NLS mCherry and Tgmyl7:actn2 tdEos. Using cardiac myosin light chain myl7 promoter nuclear localization signal conjugated monomeric Cherry or actinin alpha 2 conjugated tandem Eos was expressed in cardiomyocytes. Hearts resected from Tgmyl7:NLS mCherry or Tgmyl7:actn2 tdEos larvae at 72 hpf were collected and digested with protease solution PBS with 5 mg/ml trypsin and 1 mM EDTA pH 8.0 for 1 h. Digestion was terminated with stop solution PBS with 30% fetal bovine serum and 6 mL calcium chloride. mCherry or tdEos positive cells were collected as cardiomyocytes using a FACS Aria III cell sorter BD Bioscience Total RNAs were prepared from mCherry or tdEos positive cells using a NucleoSpin XS kit Macherey Nagel according to the manufacture's instruction. Reverse transcription RT and cDNA library preparation were performed with a SMARTer Ultra Low RNA kit Clontech. cDNA was fragmented with a Covaris S 220 instrument Covaris. Subsequently the sample was end repaired dA tailed adaptor ligated and then subjected to PCR by using a NEBNext DNA Library Preparation and NEBNext Multiplex oligos for Illumina New England BioLabs. | Sample2 | SAMEA27136168 | Department of Cell Biology National Cerebral and Cardiovascular Center Research Institute | ENA first public:2016 12 20|ENA last update:2016 12 15|External Id:SAMEA27136168|INSDC center alias:Department of Cell Biology National Cerebral and Cardiovascular Center Research Institute|INSDC center name:Department of Cell Biology National Cerebral and Cardiovascular Center Research Institute|INSDC first public:2016 12 20T17:02:09Z|INSDC last update:2016 12 15T11:23:10Z|INSDC status:public|Submitter Id:E MTAB 5323:Sample2|broker name:ArrayExpress|cell type:cardiac myocyte|common name:zebrafish|developmental stage:72 hpf|genotype:Tgmyl7:actn2 tdEodncv44Tg|sample name:E MTAB 5323:Sample2 | Illumina MiSeq sequencing; RNA Seq analyses of zebrafish cardiomyocytes at 72 hpf | E MTAB 5323:Sample2 s | Sample2 s | RNA Seq analyses of zebrafish cardiomyocytes at 72 hpf | To obtain only cardiomyocytes from the heart two transgenic zebrafish lines were established; Tgmyl7:NLS mCherry and Tgmyl7:actn2 tdEos. Using cardiac myosin light chain myl7 promoter nuclear localization signal conjugated monomeric Cherry or actinin alpha 2 conjugated tandem Eos was expressed in cardiomyocytes. Hearts resected from Tgmyl7:NLS mCherry or Tgmyl7:actn2 tdEos larvae at 72 hpf were collected and digested with protease solution PBS with 5 mg/ml trypsin and 1 mM EDTA pH 8.0 for 1 h. Digestion was terminated with stop solution PBS with 30% fetal bovine serum and 6 mL calcium chloride. mCherry or tdEos positive cells were collected as cardiomyocytes using a FACS Aria III cell sorter BD Bioscience Total RNAs were prepared from mCherry or tdEos positive cells using a NucleoSpin XS kit Macherey Nagel according to the manufacture’s instruction. Reverse transcription RT and cDNA library preparation were performed with a SMARTer Ultra Low RNA kit Clontech. cDNA was fragmented with a Covaris S 220 instrument Covaris. Subsequently the sample was end repaired dA tailed adaptor ligated and then subjected to PCR by using a NEBNext DNA Library Preparation and NEBNext Multiplex oligos for Illumina New England BioLabs. | Experimental Factor: Tgmyl7:actn2 tdEodncv44Tg:genotype | RNA-Seq | TRANSCRIPTOMIC | Oligo-dT | SINGLE | ILLUMINA | Illumina MiSeq | ERP020578 | Illumina MiSeq sequencing; RNA Seq analyses of zebrafish cardiomyocytes at 72 hpf | ENA FIRST PUBLIC:2016 12 20|ENA LAST UPDATE:2018 11 16 | mochizukis_lab_myl7_actn2tdEos_72h_02.fastq.gz | fastq | 448116860.0 | 6016977.0 | E MTAB 5323:Sample2 1 | 0:0 1:74.48 | A:127811460;C:99875207;G:106561979;T:113792335;N:75879 | 0 | 74 | 127811460 | 99875207 | 106561979 | 113792335 | 75879 | ERX1826022 | ERS1474296 | ERA776061 | Department of Cell Biology National Cerebral and Cardiovascular Center Research Institute|European Nucleotide Archive | Department of Cell Biology National Cerebral and Cardiovascular Center Research Institute|European Nucleotide Archive | 1 | 0.91589 | 0.2509 | 0.79005 | 0.54852 | 75 | B | usable mapping rate | illumina | miseq | full_length | poly_a | nebnext | bulk | unknown | unknown | Japan | 2016-12-15 | Larval | Larval | Heart | Cardiovascular System | |||||||||||||||||||
| 5881 | 5881 | ERR1759699 | ERX1826021 | ERS1474295 | ERP020578 | PRJEB18632 | RNA Seq analyses of zebrafish cardiomyocytes at 72 hpf | E-MTAB-5323 | Transcriptome Analysis | The aim of this analysis is to uncover novel molecules synthesized and secreted from cardiomyocytes. | ENA FIRST PUBLIC:2016 12 20|ENA LAST UPDATE:2016 12 15|ArrayExpress:E MTAB 5323 | Protocols: To obtain only cardiomyocytes from the heart two transgenic zebrafish lines were established; Tgmyl7:NLS mCherry and Tgmyl7:actn2 tdEos. Using cardiac myosin light chain myl7 promoter nuclear localization signal conjugated monomeric Cherry or actinin alpha 2 conjugated tandem Eos was expressed in cardiomyocytes. Hearts resected from Tgmyl7:NLS mCherry or Tgmyl7:actn2 tdEos larvae at 72 hpf were collected and digested with protease solution PBS with 5 mg/ml trypsin and 1 mM EDTA pH 8.0 for 1 h. Digestion was terminated with stop solution PBS with 30% fetal bovine serum and 6 mL calcium chloride. mCherry or tdEos positive cells were collected as cardiomyocytes using a FACS Aria III cell sorter BD Bioscience Total RNAs were prepared from mCherry or tdEos positive cells using a NucleoSpin XS kit Macherey Nagel according to the manufacture's instruction. Reverse transcription RT and cDNA library preparation were performed with a SMARTer Ultra Low RNA kit Clontech. cDNA was fragmented with a Covaris S 220 instrument Covaris. Subsequently the sample was end repaired dA tailed adaptor ligated and then subjected to PCR by using a NEBNext DNA Library Preparation and NEBNext Multiplex oligos for Illumina New England BioLabs. | Sample1 | SAMEA27135418 | Department of Cell Biology National Cerebral and Cardiovascular Center Research Institute | ENA first public:2016 12 20|ENA last update:2016 12 15|External Id:SAMEA27135418|INSDC center alias:Department of Cell Biology National Cerebral and Cardiovascular Center Research Institute|INSDC center name:Department of Cell Biology National Cerebral and Cardiovascular Center Research Institute|INSDC first public:2016 12 20T17:02:09Z|INSDC last update:2016 12 15T11:23:10Z|INSDC status:public|Submitter Id:E MTAB 5323:Sample1|broker name:ArrayExpress|cell type:cardiac myocyte|common name:zebrafish|developmental stage:72 hpf|genotype:Tgmyl7:Nls mCherryncv11Tg|sample name:E MTAB 5323:Sample1 | Illumina MiSeq sequencing; RNA Seq analyses of zebrafish cardiomyocytes at 72 hpf | E MTAB 5323:Sample1 s | Sample1 s | RNA Seq analyses of zebrafish cardiomyocytes at 72 hpf | To obtain only cardiomyocytes from the heart two transgenic zebrafish lines were established; Tgmyl7:NLS mCherry and Tgmyl7:actn2 tdEos. Using cardiac myosin light chain myl7 promoter nuclear localization signal conjugated monomeric Cherry or actinin alpha 2 conjugated tandem Eos was expressed in cardiomyocytes. Hearts resected from Tgmyl7:NLS mCherry or Tgmyl7:actn2 tdEos larvae at 72 hpf were collected and digested with protease solution PBS with 5 mg/ml trypsin and 1 mM EDTA pH 8.0 for 1 h. Digestion was terminated with stop solution PBS with 30% fetal bovine serum and 6 mL calcium chloride. mCherry or tdEos positive cells were collected as cardiomyocytes using a FACS Aria III cell sorter BD Bioscience Total RNAs were prepared from mCherry or tdEos positive cells using a NucleoSpin XS kit Macherey Nagel according to the manufacture’s instruction. Reverse transcription RT and cDNA library preparation were performed with a SMARTer Ultra Low RNA kit Clontech. cDNA was fragmented with a Covaris S 220 instrument Covaris. Subsequently the sample was end repaired dA tailed adaptor ligated and then subjected to PCR by using a NEBNext DNA Library Preparation and NEBNext Multiplex oligos for Illumina New England BioLabs. | Experimental Factor: Tgmyl7:Nls mCherryncv11Tg:genotype | RNA-Seq | TRANSCRIPTOMIC | Oligo-dT | SINGLE | ILLUMINA | Illumina MiSeq | ERP020578 | Illumina MiSeq sequencing; RNA Seq analyses of zebrafish cardiomyocytes at 72 hpf | ENA FIRST PUBLIC:2016 12 20|ENA LAST UPDATE:2018 11 16 | mochizukis_lab_myl7_NLSmCherry_72h_01.fastq.gz | fastq | 766363334.0 | 10284347.0 | E MTAB 5323:Sample1 | 0:74.52 1:0 | A:201960096;C:174999154;G:173403690;T:211341998;N:4658396 | 74 | 0 | 201960096 | 174999154 | 173403690 | 211341998 | 4658396 | ERX1826021 | ERS1474295 | ERA776061 | Department of Cell Biology National Cerebral and Cardiovascular Center Research Institute|European Nucleotide Archive | Department of Cell Biology National Cerebral and Cardiovascular Center Research Institute|European Nucleotide Archive | 1 | 0.86003 | 0.20554 | 0.76301 | 0.55753 | 74 | B | usable mapping rate | illumina | miseq | full_length | poly_a | nebnext | bulk | unknown | unknown | Japan | 2016-12-15 | Larval | Larval | Heart | Cardiovascular System | |||||||||||||||||||
| 5882 | 5882 | ERR1759700 | ERX1826021 | ERS1474295 | ERP020578 | PRJEB18632 | RNA Seq analyses of zebrafish cardiomyocytes at 72 hpf | E-MTAB-5323 | Transcriptome Analysis | The aim of this analysis is to uncover novel molecules synthesized and secreted from cardiomyocytes. | ENA FIRST PUBLIC:2016 12 20|ENA LAST UPDATE:2016 12 15|ArrayExpress:E MTAB 5323 | Protocols: To obtain only cardiomyocytes from the heart two transgenic zebrafish lines were established; Tgmyl7:NLS mCherry and Tgmyl7:actn2 tdEos. Using cardiac myosin light chain myl7 promoter nuclear localization signal conjugated monomeric Cherry or actinin alpha 2 conjugated tandem Eos was expressed in cardiomyocytes. Hearts resected from Tgmyl7:NLS mCherry or Tgmyl7:actn2 tdEos larvae at 72 hpf were collected and digested with protease solution PBS with 5 mg/ml trypsin and 1 mM EDTA pH 8.0 for 1 h. Digestion was terminated with stop solution PBS with 30% fetal bovine serum and 6 mL calcium chloride. mCherry or tdEos positive cells were collected as cardiomyocytes using a FACS Aria III cell sorter BD Bioscience Total RNAs were prepared from mCherry or tdEos positive cells using a NucleoSpin XS kit Macherey Nagel according to the manufacture's instruction. Reverse transcription RT and cDNA library preparation were performed with a SMARTer Ultra Low RNA kit Clontech. cDNA was fragmented with a Covaris S 220 instrument Covaris. Subsequently the sample was end repaired dA tailed adaptor ligated and then subjected to PCR by using a NEBNext DNA Library Preparation and NEBNext Multiplex oligos for Illumina New England BioLabs. | Sample1 | SAMEA27135418 | Department of Cell Biology National Cerebral and Cardiovascular Center Research Institute | ENA first public:2016 12 20|ENA last update:2016 12 15|External Id:SAMEA27135418|INSDC center alias:Department of Cell Biology National Cerebral and Cardiovascular Center Research Institute|INSDC center name:Department of Cell Biology National Cerebral and Cardiovascular Center Research Institute|INSDC first public:2016 12 20T17:02:09Z|INSDC last update:2016 12 15T11:23:10Z|INSDC status:public|Submitter Id:E MTAB 5323:Sample1|broker name:ArrayExpress|cell type:cardiac myocyte|common name:zebrafish|developmental stage:72 hpf|genotype:Tgmyl7:Nls mCherryncv11Tg|sample name:E MTAB 5323:Sample1 | Illumina MiSeq sequencing; RNA Seq analyses of zebrafish cardiomyocytes at 72 hpf | E MTAB 5323:Sample1 s | Sample1 s | RNA Seq analyses of zebrafish cardiomyocytes at 72 hpf | To obtain only cardiomyocytes from the heart two transgenic zebrafish lines were established; Tgmyl7:NLS mCherry and Tgmyl7:actn2 tdEos. Using cardiac myosin light chain myl7 promoter nuclear localization signal conjugated monomeric Cherry or actinin alpha 2 conjugated tandem Eos was expressed in cardiomyocytes. Hearts resected from Tgmyl7:NLS mCherry or Tgmyl7:actn2 tdEos larvae at 72 hpf were collected and digested with protease solution PBS with 5 mg/ml trypsin and 1 mM EDTA pH 8.0 for 1 h. Digestion was terminated with stop solution PBS with 30% fetal bovine serum and 6 mL calcium chloride. mCherry or tdEos positive cells were collected as cardiomyocytes using a FACS Aria III cell sorter BD Bioscience Total RNAs were prepared from mCherry or tdEos positive cells using a NucleoSpin XS kit Macherey Nagel according to the manufacture’s instruction. Reverse transcription RT and cDNA library preparation were performed with a SMARTer Ultra Low RNA kit Clontech. cDNA was fragmented with a Covaris S 220 instrument Covaris. Subsequently the sample was end repaired dA tailed adaptor ligated and then subjected to PCR by using a NEBNext DNA Library Preparation and NEBNext Multiplex oligos for Illumina New England BioLabs. | Experimental Factor: Tgmyl7:Nls mCherryncv11Tg:genotype | RNA-Seq | TRANSCRIPTOMIC | Oligo-dT | SINGLE | ILLUMINA | Illumina MiSeq | ERP020578 | Illumina MiSeq sequencing; RNA Seq analyses of zebrafish cardiomyocytes at 72 hpf | ENA FIRST PUBLIC:2016 12 20|ENA LAST UPDATE:2018 11 16 | mochizukis_lab_myl7_NLSmCHerry_72h_02.fastq.gz | fastq | 766251339.0 | 10284347.0 | E MTAB 5323:Sample1 1 | 0:0 1:74.51 | A:214234414;C:174215653;G:180382062;T:197361982;N:57228 | 0 | 74 | 214234414 | 174215653 | 180382062 | 197361982 | 57228 | ERX1826021 | ERS1474295 | ERA776061 | Department of Cell Biology National Cerebral and Cardiovascular Center Research Institute|European Nucleotide Archive | Department of Cell Biology National Cerebral and Cardiovascular Center Research Institute|European Nucleotide Archive | 1 | 0.87766 | 0.21561 | 0.77477 | 0.53919 | 73 | B | usable mapping rate | illumina | miseq | full_length | poly_a | nebnext | bulk | unknown | unknown | Japan | 2016-12-15 | 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");;