RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

run_metadata

8 rows where experiment.library_selection = "PolyA", experiment.library_source = "TRANSCRIPTOMIC SINGLE CELL" and tissue_curation = "Brain"

✎ View and edit SQL

This data as json, CSV (advanced)

technology 2

experiment.platform 2

experiment.library_layout 2

tissue_curation_coarse 1

tissue_curation 1

  • Brain · 8 ✖

experiment.library_strategy 1

experiment.library_source 1

  • TRANSCRIPTOMIC SINGLE CELL · 8 ✖

experiment.library_selection 1

  • PolyA · 8 ✖

devstage_curation_coarse 1

devstage_curation 1

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
11813 11813 ERR11788863 ERX11187331 ERS16221143 ERP149944 PRJEB64780 A single cell transcriptomic atlas reveals a new myeloid parenchymal population in the zebrafish brain E-MTAB-13223 Transcriptome Analysis To understand the cellular basis of the immune compartment of the zebrafish brain we have established reliable protocols for dissociation and prospective isolation of brain leukocytes using fluorescent transgenic lines. By combining this approach with single cell RNA sequencing we have generated a gene expression atlas composed of the distinct immune cells present in the homeostatic brain. These analyses revealed the presence of subpopulations of mononuclear phagocytes and other leukocytes including cell types that have not been or have been poorly characterized so far. Here we present the characterization of a new mononuclear phagocyte population that represents an important fraction among all brain leukocytes. Adult brain single cell suspensions were prepared from adult Tgp2ry12:GFP; cd45:DsRed fish n=3 and a total of 14 000 cd45:DsRed+ cells were processed for single cell profiling using the 10x Genomics platform. ENA FIRST PUBLIC:2023 12 25|ENA LAST UPDATE:2023 12 25   Protocols: FACS sorting of cd45:Dsred cells. Brains from adult Tgp2ry12:GFP; cd45:DsRed fish n=3 were dissected in 0.9X Dulbecco′s Phosphate Buffered Saline DPBS were triturated and treated with Liberase TM at 33°C for 30 45 minutes fully dissociated using a syringe with a 26G needle and washed in 2% fetal bovine serum diluted in 0.9X DPBS. Cell suspensions were centrifuged at 290g 4ºC 10 min and filtered through a 40µm nylon mesh. Just before flow cytometry analysis using calcein violet to exclude dead cells 1µM Thermo Fisher. Flow cytometry acquisition and cell sorting was performed on a FACS ARIA II Becton Dickinson. RNA Illumina Sample 1 SAMEA114235870 Universite Libre de Bruxelles ENA FIRST PUBLIC:2023 12 25T01:15:29Z|ENA LAST UPDATE:2023 12 25T01:15:29Z|External Id:SAMEA114235870|INSDC center name:Universite Libre de Bruxelles|INSDC first public:2023 12 25T01:15:29Z|INSDC last update:2023 12 25T01:15:29Z|INSDC status:public|Submitter Id:E MTAB 13223:Sample 1|age:5|broker name:ArrayExpress|cell type:leukocyte|collection date:not collected|common name:zebrafish|developmental stage:adult|genotype:wild type genotype|geographic location country and/or sea:not collected|individual:pool of 3 fish|isolate:not applicable|organism part:brain|sample name:E MTAB 13223:Sample 1|scientific name:Danio rerio|sex:male and female|strain:AB                 A single cell transcriptomic atlas reveals a new myeloid parenchymal population in the zebrafish brain E MTAB 13223:Sample 1 p Sample 1 p A single cell transcriptomic atlas reveals a new myeloid parenchymal population in the zebrafish brain FACS sorting of cd45:Dsred cells. Brains from adult Tgp2ry12:GFP; cd45:DsRed fish n=3 were dissected in 0.9X Dulbecco′s Phosphate Buffered Saline DPBS were triturated and treated with Liberase TM at 33°C for 30 45 minutes fully dissociated using a syringe with a 26G needle and washed in 2% fetal bovine serum diluted in 0.9X DPBS. Cell suspensions were centrifuged at 290g 4ºC 10 min and filtered through a 40µm nylon mesh. Just before flow cytometry analysis using calcein violet to exclude dead cells 1µM Thermo Fisher. Flow cytometry acquisition and cell sorting was performed on a FACS ARIA II Becton Dickinson. RNA Illumina   RNA-Seq TRANSCRIPTOMIC SINGLE CELL PolyA PAIRED ILLUMINA NextSeq 550   ERP149944 NextSeq 550 paired end sequencing; A single cell transcriptomic atlas reveals a new myeloid parenchymal population in the zebrafish brain ENA FIRST PUBLIC:2023 12 25|ENA LAST UPDATE:2023 12 25 L41805_Track-81843_R1.fastq.gz L41805_Track-81843_R2.fastq.gz fastq fastq 5545444464.0 66017196.0 E MTAB 13223:L41805 Track 81843 0:28 1:56 A:1576174024;C:1193175858;G:1221776615;T:1551009004;N:3308963 28 56     1576174024 1193175858 1221776615 1551009004 3308963 ERX11187331 ERS16221143 ERA26318932 European Bioinformatics Institute|European Nucleotide Archive European Bioinformatics Institute|European Nucleotide Archive 2 0.00738 0.90151 0.00285 0.20553 0.99072 0.82402 0.4645 0.53817 28 56 T B sc-like readlen illumina nextseq unknown poly_a unknown sc single_cell_droplet 10x   United Kingdom 2023-12-25 Adult Adult Brain Nervous System
11814 11814 ERR11788864 ERX11187331 ERS16221143 ERP149944 PRJEB64780 A single cell transcriptomic atlas reveals a new myeloid parenchymal population in the zebrafish brain E-MTAB-13223 Transcriptome Analysis To understand the cellular basis of the immune compartment of the zebrafish brain we have established reliable protocols for dissociation and prospective isolation of brain leukocytes using fluorescent transgenic lines. By combining this approach with single cell RNA sequencing we have generated a gene expression atlas composed of the distinct immune cells present in the homeostatic brain. These analyses revealed the presence of subpopulations of mononuclear phagocytes and other leukocytes including cell types that have not been or have been poorly characterized so far. Here we present the characterization of a new mononuclear phagocyte population that represents an important fraction among all brain leukocytes. Adult brain single cell suspensions were prepared from adult Tgp2ry12:GFP; cd45:DsRed fish n=3 and a total of 14 000 cd45:DsRed+ cells were processed for single cell profiling using the 10x Genomics platform. ENA FIRST PUBLIC:2023 12 25|ENA LAST UPDATE:2023 12 25   Protocols: FACS sorting of cd45:Dsred cells. Brains from adult Tgp2ry12:GFP; cd45:DsRed fish n=3 were dissected in 0.9X Dulbecco′s Phosphate Buffered Saline DPBS were triturated and treated with Liberase TM at 33°C for 30 45 minutes fully dissociated using a syringe with a 26G needle and washed in 2% fetal bovine serum diluted in 0.9X DPBS. Cell suspensions were centrifuged at 290g 4ºC 10 min and filtered through a 40µm nylon mesh. Just before flow cytometry analysis using calcein violet to exclude dead cells 1µM Thermo Fisher. Flow cytometry acquisition and cell sorting was performed on a FACS ARIA II Becton Dickinson. RNA Illumina Sample 1 SAMEA114235870 Universite Libre de Bruxelles ENA FIRST PUBLIC:2023 12 25T01:15:29Z|ENA LAST UPDATE:2023 12 25T01:15:29Z|External Id:SAMEA114235870|INSDC center name:Universite Libre de Bruxelles|INSDC first public:2023 12 25T01:15:29Z|INSDC last update:2023 12 25T01:15:29Z|INSDC status:public|Submitter Id:E MTAB 13223:Sample 1|age:5|broker name:ArrayExpress|cell type:leukocyte|collection date:not collected|common name:zebrafish|developmental stage:adult|genotype:wild type genotype|geographic location country and/or sea:not collected|individual:pool of 3 fish|isolate:not applicable|organism part:brain|sample name:E MTAB 13223:Sample 1|scientific name:Danio rerio|sex:male and female|strain:AB                 A single cell transcriptomic atlas reveals a new myeloid parenchymal population in the zebrafish brain E MTAB 13223:Sample 1 p Sample 1 p A single cell transcriptomic atlas reveals a new myeloid parenchymal population in the zebrafish brain FACS sorting of cd45:Dsred cells. Brains from adult Tgp2ry12:GFP; cd45:DsRed fish n=3 were dissected in 0.9X Dulbecco′s Phosphate Buffered Saline DPBS were triturated and treated with Liberase TM at 33°C for 30 45 minutes fully dissociated using a syringe with a 26G needle and washed in 2% fetal bovine serum diluted in 0.9X DPBS. Cell suspensions were centrifuged at 290g 4ºC 10 min and filtered through a 40µm nylon mesh. Just before flow cytometry analysis using calcein violet to exclude dead cells 1µM Thermo Fisher. Flow cytometry acquisition and cell sorting was performed on a FACS ARIA II Becton Dickinson. RNA Illumina   RNA-Seq TRANSCRIPTOMIC SINGLE CELL PolyA PAIRED ILLUMINA NextSeq 550   ERP149944 NextSeq 550 paired end sequencing; A single cell transcriptomic atlas reveals a new myeloid parenchymal population in the zebrafish brain ENA FIRST PUBLIC:2023 12 25|ENA LAST UPDATE:2023 12 25 L41805_Track-81377_R1.fastq.gz L41805_Track-81377_R2.fastq.gz fastq fastq 3184137096.0 37906394.0 E MTAB 13223:L41805 Track 81377 0:28 1:56 A:899943184;C:685571078;G:703849582;T:889228559;N:5544693 28 56     899943184 685571078 703849582 889228559 5544693 ERX11187331 ERS16221143 ERA26318932 European Bioinformatics Institute|European Nucleotide Archive European Bioinformatics Institute|European Nucleotide Archive 2 0.00734 0.90077 0.00293 0.20318 0.99064 0.82765 0.47994 0.53473 28 56 T B sc-like readlen illumina nextseq unknown poly_a unknown sc single_cell_droplet 10x   United Kingdom 2023-12-25 Adult Adult Brain Nervous System
35865 35865 SRR33094447 SRX28358130 SRS24687221 SRP578075 PRJNA1249535 P301S Mutant Tau Driven Zebrafish Platform Enables Systematic Identification of Pharmacological GSK3B Inhibitors with Anti Neurodegenerative Efficacy PRJNA1249535 Other Single cell transcriptome sequencing provides high resolution transcriptome data on the molecular mechanisms by which Tau P301S mediates Alzheimer's disease like pathological changes in zebrafish providing unique insights into the pathogenesis of Tau pathology mediated cell to cell interactions in AD.     TauP301S 4   TauP301S 4   breed:zebrafish|age:4 month|collection date:2024 05 18|geo loc name:China:Shantou|sex:not determined|tissue:brain|BioSampleModel:Model organism or animal                 P301S Mutant Tau Driven Zebrafish Platform Enables Systematic Identification of Pharmacological GSK3B Inhibitors with Anti Neurodegenerative Efficacy TauP301S 4 TauP301S 4 tissue     RNA-Seq TRANSCRIPTOMIC SINGLE CELL PolyA PAIRED BGISEQ BGISEQ-500   SRP578075     AD4_S1_L001_R1_001.fastq.gz AD4_S1_L001_R2_001.fastq.gz fastq fastq 129145897746.0 427635423.0 AD4 S1 L001 R1 001.fastq.gz 0:151 1:151 A:37870495722;C:24917123133;G:22536537853;T:43764941649;N:56799389 151 151     37870495722 24917123133 22536537853 43764941649 56799389 SRX28358130 SRS24687221 SRA2110625 Shantou university medical college|Neuroscience Center Shantou university medical college                       T B mate1 technical by mapping diff bgi bgi unknown poly_a unknown sc unknown unknown   China 2025-04-13 Adult Adult Brain Nervous System
35866 35866 SRR33094448 SRX28358129 SRS24687220 SRP578075 PRJNA1249535 P301S Mutant Tau Driven Zebrafish Platform Enables Systematic Identification of Pharmacological GSK3B Inhibitors with Anti Neurodegenerative Efficacy PRJNA1249535 Other Single cell transcriptome sequencing provides high resolution transcriptome data on the molecular mechanisms by which Tau P301S mediates Alzheimer's disease like pathological changes in zebrafish providing unique insights into the pathogenesis of Tau pathology mediated cell to cell interactions in AD.     TauP301S 3   TauP301S 3   breed:zebrafish|age:4 month|collection date:2024 05 17|geo loc name:China:Shantou|sex:not determined|tissue:brain|BioSampleModel:Model organism or animal                 P301S Mutant Tau Driven Zebrafish Platform Enables Systematic Identification of Pharmacological GSK3B Inhibitors with Anti Neurodegenerative Efficacy TauP301S 3 TauP301S 3 tissue     RNA-Seq TRANSCRIPTOMIC SINGLE CELL PolyA PAIRED BGISEQ BGISEQ-500   SRP578075     AD3_S1_L001_R1_001.fastq.gz AD3_S1_L001_R2_001.fastq.gz fastq fastq 130723873718.0 432860509.0 AD3 S1 L001 R1 001.fastq.gz 0:151 1:151 A:38509426012;C:25238065771;G:22586405501;T:44332442791;N:57533643 151 151     38509426012 25238065771 22586405501 44332442791 57533643 SRX28358129 SRS24687220 SRA2110625 Shantou university medical college|Neuroscience Center Shantou university medical college                       T B mate1 technical by mapping diff bgi bgi unknown poly_a unknown sc unknown unknown   China 2025-04-13 Adult Adult Brain Nervous System
35867 35867 SRR33094449 SRX28358128 SRS24687219 SRP578075 PRJNA1249535 P301S Mutant Tau Driven Zebrafish Platform Enables Systematic Identification of Pharmacological GSK3B Inhibitors with Anti Neurodegenerative Efficacy PRJNA1249535 Other Single cell transcriptome sequencing provides high resolution transcriptome data on the molecular mechanisms by which Tau P301S mediates Alzheimer's disease like pathological changes in zebrafish providing unique insights into the pathogenesis of Tau pathology mediated cell to cell interactions in AD.     TauP301S 2   TauP301S 2   breed:zebrafish|age:4 month|collection date:2024 05 16|geo loc name:China:Shantou|sex:not determined|tissue:brain|BioSampleModel:Model organism or animal                 P301S Mutant Tau Driven Zebrafish Platform Enables Systematic Identification of Pharmacological GSK3B Inhibitors with Anti Neurodegenerative Efficacy TauP301S 2 TauP301S 2 tissue     RNA-Seq TRANSCRIPTOMIC SINGLE CELL PolyA PAIRED BGISEQ BGISEQ-500   SRP578075     AD2_S1_L001_R1_001.fastq.gz AD2_S1_L001_R2_001.fastq.gz fastq fastq 130145208498.0 430944399.0 AD2 S1 L001 R1 001.fastq.gz 0:151 1:151 A:37802929660;C:22980541562;G:20982421471;T:48304142442;N:75173363 151 151     37802929660 22980541562 20982421471 48304142442 75173363 SRX28358128 SRS24687219 SRA2110625 Shantou university medical college|Neuroscience Center Shantou university medical college                       T B mate1 technical by mapping diff bgi bgi unknown poly_a unknown sc unknown unknown   China 2025-04-13 Adult Adult Brain Nervous System
35868 35868 SRR33094450 SRX28358127 SRS24687218 SRP578075 PRJNA1249535 P301S Mutant Tau Driven Zebrafish Platform Enables Systematic Identification of Pharmacological GSK3B Inhibitors with Anti Neurodegenerative Efficacy PRJNA1249535 Other Single cell transcriptome sequencing provides high resolution transcriptome data on the molecular mechanisms by which Tau P301S mediates Alzheimer's disease like pathological changes in zebrafish providing unique insights into the pathogenesis of Tau pathology mediated cell to cell interactions in AD.     TauP301S 1   TauP301S 1   breed:zebrafish|age:4 month|collection date:2024 05 15|geo loc name:China:Shantou|sex:not determined|tissue:brain|BioSampleModel:Model organism or animal                 P301S Mutant Tau Driven Zebrafish Platform Enables Systematic Identification of Pharmacological GSK3B Inhibitors with Anti Neurodegenerative Efficacy TauP301S 1 TauP301S 1 tissue     RNA-Seq TRANSCRIPTOMIC SINGLE CELL PolyA PAIRED BGISEQ BGISEQ-500   SRP578075     AD1_S1_L001_R1_001.fastq.gz AD1_S1_L001_R2_001.fastq.gz fastq fastq 151897861402.0 502973051.0 AD1 S1 L001 R1 001.fastq.gz 0:151 1:151 A:44290580650;C:26864167508;G:24611898618;T:56043760812;N:87453814 151 151     44290580650 26864167508 24611898618 56043760812 87453814 SRX28358127 SRS24687218 SRA2110625 Shantou university medical college|Neuroscience Center Shantou university medical college                       T B mate1 technical by mapping diff bgi bgi unknown poly_a unknown sc unknown unknown   China 2025-04-13 Adult Adult Brain Nervous System
35869 35869 SRR33094451 SRX28358126 SRS24687216 SRP578075 PRJNA1249535 P301S Mutant Tau Driven Zebrafish Platform Enables Systematic Identification of Pharmacological GSK3B Inhibitors with Anti Neurodegenerative Efficacy PRJNA1249535 Other Single cell transcriptome sequencing provides high resolution transcriptome data on the molecular mechanisms by which Tau P301S mediates Alzheimer's disease like pathological changes in zebrafish providing unique insights into the pathogenesis of Tau pathology mediated cell to cell interactions in AD.     Wildtype2   Wildtype2   breed:zebrafish|age:4 month|collection date:2024 05 14|geo loc name:China:Shantou|sex:not determined|tissue:brain|BioSampleModel:Model organism or animal                 P301S Mutant Tau Driven Zebrafish Platform Enables Systematic Identification of Pharmacological GSK3B Inhibitors with Anti Neurodegenerative Efficacy Wildtype2 Wildtype2 tissue     RNA-Seq TRANSCRIPTOMIC SINGLE CELL PolyA SINGLE BGISEQ BGISEQ-500   SRP578075     WT2_S1_L001_I1_001.fastq.gz fastq 15183539264.0 1897942408.0 WT2 S1 L001 I1 001.fastq.gz 0:8 A:5024041949;C:2632487194;G:2782260146;T:4744243552;N:506423 8       5024041949 2632487194 2782260146 4744243552 506423 SRX28358126 SRS24687216 SRA2110625 Shantou university medical college|Neuroscience Center Shantou university medical college                       T   under 1.2% mapping rate bgi bgi unknown poly_a unknown sc unknown unknown   China 2025-04-18 Adult Adult Brain Nervous System
35870 35870 SRR33094452 SRX28358125 SRS24687217 SRP578075 PRJNA1249535 P301S Mutant Tau Driven Zebrafish Platform Enables Systematic Identification of Pharmacological GSK3B Inhibitors with Anti Neurodegenerative Efficacy PRJNA1249535 Other Single cell transcriptome sequencing provides high resolution transcriptome data on the molecular mechanisms by which Tau P301S mediates Alzheimer's disease like pathological changes in zebrafish providing unique insights into the pathogenesis of Tau pathology mediated cell to cell interactions in AD.     Wildtype1   Wildtype1   breed:zebrafish|age:4 month|collection date:2024 05 13|geo loc name:China:Shantou|sex:not determined|tissue:brain|BioSampleModel:Model organism or animal                 P301S Mutant Tau Driven Zebrafish Platform Enables Systematic Identification of Pharmacological GSK3B Inhibitors with Anti Neurodegenerative Efficacy Wildtype1 Wildtype1 tissue     RNA-Seq TRANSCRIPTOMIC SINGLE CELL PolyA SINGLE BGISEQ BGISEQ-500   SRP578075     WT1_S1_L001_I1_001.fastq.gz fastq 7991376264.0 998922033.0 WT1 S1 L001 I1 001.fastq.gz 0:8 A:2573734851;C:1426474966;G:1492966198;T:2498173074;N:27175 8       2573734851 1426474966 1492966198 2498173074 27175 SRX28358125 SRS24687217 SRA2110625 Shantou university medical college|Neuroscience Center Shantou university medical college                       T   under 1.2% mapping rate bgi bgi unknown poly_a unknown sc unknown unknown   China 2025-04-18 Adult Adult Brain Nervous 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");;