RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

run_metadata

6 rows where experiment.library_layout = "PAIRED", technology = "generic-scrnaseq-only" and tissue_curation = "Multi-tissue"

✎ View and edit SQL

This data as json, CSV (advanced)

tissue_curation_coarse 1

tissue_curation 1

  • Multi-tissue · 6 ✖

technology 1

  • generic-scrnaseq-only · 6 ✖

experiment.platform 1

experiment.library_strategy 1

experiment.library_source 1

experiment.library_selection 1

experiment.library_layout 1

  • PAIRED · 6 ✖

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
60001 60001 SRR12083659 SRX8610753 SRS6900398 SRP268708 PRJNA641707 Transcriptional profiling of pax2a Low and pax2a High thyroid follicular cells in zebrafish GSE153197 Transcriptome Analysis Thyroid follicular cells TFCs are responsible for generation storage and release of thyroid hormone. Single cell analysis of zebrafish thyroid gland demonstrated transcriptional heterogeneity within the TFC population Gillotay et al. bioRxiv 2020. doi: 10.1101/2020.01.13.891630. GEO dataset for single cell RNA Seq.: GSE133466. Particularly TFC displayed transcriptional heterogeneity in the expression of pax2a a transcription factor involved in differentiation and maturation of TFCs. To validate the genetic heterogeneity we generated a pax2a knock in line in which mKO2 expression is driven by endogenous pax2a locus. Using Tgtg:nls EGFP; pax2a:mKO2 Knock in we sorted for TFCs GFP+ and separated the pax2a Low mKO2 Low and pax2a High mKO2 High populations for NGS. Overall design: We used fluorescence activated cell sorting FACS coupled with next generation RNA Sequencing to profile pax2a high and pax2a low TFCs from 5 mpf animals. Cells were sorted directly into lysis buffer provided in ReliaPrep™ RNA Miniprep Systems Promega Z6011 and mRNA isolated according to the manufactor's protocol. cDNA was generated using Ribozome depletion protocol followed by adapter ligation. Sequencing was performed on llumina NextSeq500. Reads were splice aligned to the zebrafish genome GRCz11 using HISAT2. Featurecounts was used to assign reads to exons thus eventually getting counts per gene.   pubmed:33140917   Pax2a High TFC 3 GSM4635496   tissue:Thyroid Follicular Cells TFCs|age:5 mpf|genotype/variation:Tgtg:nls EGFP pax2a:mKO2 Knock in|population:pax2a High mKO2 High Pax2a High TFC 3 Mapping using HISAT2 against GRCz11with default parameters Counts per gene generated using FeatureCounts with default parameters Genome build: Zebrafish GRCz11 Supplementary files format and content: read counts as tsv file Thyroid Follicular Cells TFCs   Enzymatic Dissociation Ribozyme depletion adapter ligation followed by llumina NextSeq500   age:5 mpf|genotype/variation:Tgtg:nls EGFP pax2a:mKO2 Knock in|population:pax2a High mKO2 High GSM4635496 GSM4635496: Pax2a High TFC 3; Danio rerio; RNA Seq GSM4635496   1 Enzymatic Dissociation Ribozyme depletion adapter ligation followed by llumina NextSeq500 GEO Accession:GSM4635496 RNA-Seq TRANSCRIPTOMIC cDNA PAIRED ILLUMINA NextSeq 500   SRP268708     Pax2a-highset3_S14_R1_001.fastq.gz Pax2a-highset3_S14_R2_001.fastq.gz fastq fastq 16108716672.0 80176158.0 GSM4635496 r1 0:100.44 1:100.48 A:4075320644;C:4124512580;G:3756402856;T:4151374263;N:1106329 100 100     4075320644 4124512580 3756402856 4151374263 1106329 SRX8610753 SRS6900398 SRA1090834 GEO Single Cell Endocrinology, IRIBHM 2 0.53855 0.55508 0.21647 0.22708 0.82775 0.82838 0.43125 0.42144 101 100 B B biological fallback assumption illumina nextseq unknown cdna_unspecified unknown sc_generic single_cell_generic generic-scrnaseq-only   Belgium 2020-06-24 Adult Adult Multi-tissue Multi-system
60002 60002 SRR12083658 SRX8610752 SRS6900397 SRP268708 PRJNA641707 Transcriptional profiling of pax2a Low and pax2a High thyroid follicular cells in zebrafish GSE153197 Transcriptome Analysis Thyroid follicular cells TFCs are responsible for generation storage and release of thyroid hormone. Single cell analysis of zebrafish thyroid gland demonstrated transcriptional heterogeneity within the TFC population Gillotay et al. bioRxiv 2020. doi: 10.1101/2020.01.13.891630. GEO dataset for single cell RNA Seq.: GSE133466. Particularly TFC displayed transcriptional heterogeneity in the expression of pax2a a transcription factor involved in differentiation and maturation of TFCs. To validate the genetic heterogeneity we generated a pax2a knock in line in which mKO2 expression is driven by endogenous pax2a locus. Using Tgtg:nls EGFP; pax2a:mKO2 Knock in we sorted for TFCs GFP+ and separated the pax2a Low mKO2 Low and pax2a High mKO2 High populations for NGS. Overall design: We used fluorescence activated cell sorting FACS coupled with next generation RNA Sequencing to profile pax2a high and pax2a low TFCs from 5 mpf animals. Cells were sorted directly into lysis buffer provided in ReliaPrep™ RNA Miniprep Systems Promega Z6011 and mRNA isolated according to the manufactor's protocol. cDNA was generated using Ribozome depletion protocol followed by adapter ligation. Sequencing was performed on llumina NextSeq500. Reads were splice aligned to the zebrafish genome GRCz11 using HISAT2. Featurecounts was used to assign reads to exons thus eventually getting counts per gene.   pubmed:33140917   Pax2a Low TFC 3 GSM4635495   tissue:Thyroid Follicular Cells TFCs|age:5 mpf|genotype/variation:Tgtg:nls EGFP pax2a:mKO2 Knock in|population:pax2a Low mKO2 Low Pax2a Low TFC 3 Mapping using HISAT2 against GRCz11with default parameters Counts per gene generated using FeatureCounts with default parameters Genome build: Zebrafish GRCz11 Supplementary files format and content: read counts as tsv file Thyroid Follicular Cells TFCs   Enzymatic Dissociation Ribozyme depletion adapter ligation followed by llumina NextSeq500   age:5 mpf|genotype/variation:Tgtg:nls EGFP pax2a:mKO2 Knock in|population:pax2a Low mKO2 Low GSM4635495 GSM4635495: Pax2a Low TFC 3; Danio rerio; RNA Seq GSM4635495   1 Enzymatic Dissociation Ribozyme depletion adapter ligation followed by llumina NextSeq500 GEO Accession:GSM4635495 RNA-Seq TRANSCRIPTOMIC cDNA PAIRED ILLUMINA NextSeq 500   SRP268708     Pax2a-lowset3_S13_R2_001.fastq.gz Pax2a-lowset3_S13_R1_001.fastq.gz fastq fastq 15927464315.0 79263861.0 GSM4635495 r1 0:100.42 1:100.53 A:3806928663;C:4340989624;G:3919724503;T:3858828310;N:993215 100 100     3806928663 4340989624 3919724503 3858828310 993215 SRX8610752 SRS6900397 SRA1090834 GEO Single Cell Endocrinology, IRIBHM 2 0.18449 0.18221 0.07867 0.07638 0.91488 0.91419 0.61183 0.60137 100 101 B B biological fallback assumption illumina nextseq unknown cdna_unspecified unknown sc_generic single_cell_generic generic-scrnaseq-only   Belgium 2020-06-24 Adult Adult Multi-tissue Multi-system
60003 60003 SRR12083657 SRX8610751 SRS6900396 SRP268708 PRJNA641707 Transcriptional profiling of pax2a Low and pax2a High thyroid follicular cells in zebrafish GSE153197 Transcriptome Analysis Thyroid follicular cells TFCs are responsible for generation storage and release of thyroid hormone. Single cell analysis of zebrafish thyroid gland demonstrated transcriptional heterogeneity within the TFC population Gillotay et al. bioRxiv 2020. doi: 10.1101/2020.01.13.891630. GEO dataset for single cell RNA Seq.: GSE133466. Particularly TFC displayed transcriptional heterogeneity in the expression of pax2a a transcription factor involved in differentiation and maturation of TFCs. To validate the genetic heterogeneity we generated a pax2a knock in line in which mKO2 expression is driven by endogenous pax2a locus. Using Tgtg:nls EGFP; pax2a:mKO2 Knock in we sorted for TFCs GFP+ and separated the pax2a Low mKO2 Low and pax2a High mKO2 High populations for NGS. Overall design: We used fluorescence activated cell sorting FACS coupled with next generation RNA Sequencing to profile pax2a high and pax2a low TFCs from 5 mpf animals. Cells were sorted directly into lysis buffer provided in ReliaPrep™ RNA Miniprep Systems Promega Z6011 and mRNA isolated according to the manufactor's protocol. cDNA was generated using Ribozome depletion protocol followed by adapter ligation. Sequencing was performed on llumina NextSeq500. Reads were splice aligned to the zebrafish genome GRCz11 using HISAT2. Featurecounts was used to assign reads to exons thus eventually getting counts per gene.   pubmed:33140917   Pax2a High TFC 2 GSM4635494   tissue:Thyroid Follicular Cells TFCs|age:5 mpf|genotype/variation:Tgtg:nls EGFP pax2a:mKO2 Knock in|population:pax2a High mKO2 High Pax2a High TFC 2 Mapping using HISAT2 against GRCz11with default parameters Counts per gene generated using FeatureCounts with default parameters Genome build: Zebrafish GRCz11 Supplementary files format and content: read counts as tsv file Thyroid Follicular Cells TFCs   Enzymatic Dissociation Ribozyme depletion adapter ligation followed by llumina NextSeq500   age:5 mpf|genotype/variation:Tgtg:nls EGFP pax2a:mKO2 Knock in|population:pax2a High mKO2 High GSM4635494 GSM4635494: Pax2a High TFC 2; Danio rerio; RNA Seq GSM4635494   1 Enzymatic Dissociation Ribozyme depletion adapter ligation followed by llumina NextSeq500 GEO Accession:GSM4635494 RNA-Seq TRANSCRIPTOMIC cDNA PAIRED ILLUMINA NextSeq 500   SRP268708     Pax2a-highset2_S12_R1_001.fastq.gz Pax2a-highset2_S12_R2_001.fastq.gz fastq fastq 15523399241.0 77253456.0 GSM4635494 r1 0:100.43 1:100.51 A:3874954294;C:4043105713;G:3665233417;T:3939083016;N:1022801 100 100     3874954294 4043105713 3665233417 3939083016 1022801 SRX8610751 SRS6900396 SRA1090834 GEO Single Cell Endocrinology, IRIBHM 2 0.33224 0.33308 0.1301 0.13243 0.87411 0.8732 0.45849 0.46552 101 101 B B biological fallback assumption illumina nextseq unknown cdna_unspecified unknown sc_generic single_cell_generic generic-scrnaseq-only   Belgium 2020-06-24 Adult Adult Multi-tissue Multi-system
60004 60004 SRR12083656 SRX8610750 SRS6900395 SRP268708 PRJNA641707 Transcriptional profiling of pax2a Low and pax2a High thyroid follicular cells in zebrafish GSE153197 Transcriptome Analysis Thyroid follicular cells TFCs are responsible for generation storage and release of thyroid hormone. Single cell analysis of zebrafish thyroid gland demonstrated transcriptional heterogeneity within the TFC population Gillotay et al. bioRxiv 2020. doi: 10.1101/2020.01.13.891630. GEO dataset for single cell RNA Seq.: GSE133466. Particularly TFC displayed transcriptional heterogeneity in the expression of pax2a a transcription factor involved in differentiation and maturation of TFCs. To validate the genetic heterogeneity we generated a pax2a knock in line in which mKO2 expression is driven by endogenous pax2a locus. Using Tgtg:nls EGFP; pax2a:mKO2 Knock in we sorted for TFCs GFP+ and separated the pax2a Low mKO2 Low and pax2a High mKO2 High populations for NGS. Overall design: We used fluorescence activated cell sorting FACS coupled with next generation RNA Sequencing to profile pax2a high and pax2a low TFCs from 5 mpf animals. Cells were sorted directly into lysis buffer provided in ReliaPrep™ RNA Miniprep Systems Promega Z6011 and mRNA isolated according to the manufactor's protocol. cDNA was generated using Ribozome depletion protocol followed by adapter ligation. Sequencing was performed on llumina NextSeq500. Reads were splice aligned to the zebrafish genome GRCz11 using HISAT2. Featurecounts was used to assign reads to exons thus eventually getting counts per gene.   pubmed:33140917   Pax2a Low TFC 2 GSM4635493   tissue:Thyroid Follicular Cells TFCs|age:5 mpf|genotype/variation:Tgtg:nls EGFP pax2a:mKO2 Knock in|population:pax2a Low mKO2 Low Pax2a Low TFC 2 Mapping using HISAT2 against GRCz11with default parameters Counts per gene generated using FeatureCounts with default parameters Genome build: Zebrafish GRCz11 Supplementary files format and content: read counts as tsv file Thyroid Follicular Cells TFCs   Enzymatic Dissociation Ribozyme depletion adapter ligation followed by llumina NextSeq500   age:5 mpf|genotype/variation:Tgtg:nls EGFP pax2a:mKO2 Knock in|population:pax2a Low mKO2 Low GSM4635493 GSM4635493: Pax2a Low TFC 2; Danio rerio; RNA Seq GSM4635493   1 Enzymatic Dissociation Ribozyme depletion adapter ligation followed by llumina NextSeq500 GEO Accession:GSM4635493 RNA-Seq TRANSCRIPTOMIC cDNA PAIRED ILLUMINA NextSeq 500   SRP268708     Pax2a-lowset2_S11_R2_001.fastq.gz Pax2a-lowset2_S11_R1_001.fastq fastq fastq 14562196360.0 85940573.0 GSM4635493 r1 0:100.38 1:100.53 A:3643644077;C:3784618122;G:3352785620;T:3780129729;N:1018812 100 100     3643644077 3784618122 3352785620 3780129729 1018812 SRX8610750 SRS6900395 SRA1090834 GEO Single Cell Endocrinology, IRIBHM 2 0.16299 0.15776 0.06375 0.06201 0.93162 0.93117 0.63175 0.62162 101 101 B B biological fallback assumption illumina nextseq unknown cdna_unspecified unknown sc_generic single_cell_generic generic-scrnaseq-only   Belgium 2020-06-24 Adult Adult Multi-tissue Multi-system
60005 60005 SRR12083655 SRX8610749 SRS6900394 SRP268708 PRJNA641707 Transcriptional profiling of pax2a Low and pax2a High thyroid follicular cells in zebrafish GSE153197 Transcriptome Analysis Thyroid follicular cells TFCs are responsible for generation storage and release of thyroid hormone. Single cell analysis of zebrafish thyroid gland demonstrated transcriptional heterogeneity within the TFC population Gillotay et al. bioRxiv 2020. doi: 10.1101/2020.01.13.891630. GEO dataset for single cell RNA Seq.: GSE133466. Particularly TFC displayed transcriptional heterogeneity in the expression of pax2a a transcription factor involved in differentiation and maturation of TFCs. To validate the genetic heterogeneity we generated a pax2a knock in line in which mKO2 expression is driven by endogenous pax2a locus. Using Tgtg:nls EGFP; pax2a:mKO2 Knock in we sorted for TFCs GFP+ and separated the pax2a Low mKO2 Low and pax2a High mKO2 High populations for NGS. Overall design: We used fluorescence activated cell sorting FACS coupled with next generation RNA Sequencing to profile pax2a high and pax2a low TFCs from 5 mpf animals. Cells were sorted directly into lysis buffer provided in ReliaPrep™ RNA Miniprep Systems Promega Z6011 and mRNA isolated according to the manufactor's protocol. cDNA was generated using Ribozome depletion protocol followed by adapter ligation. Sequencing was performed on llumina NextSeq500. Reads were splice aligned to the zebrafish genome GRCz11 using HISAT2. Featurecounts was used to assign reads to exons thus eventually getting counts per gene.   pubmed:33140917   Pax2a High TFC 1 GSM4635492   tissue:Thyroid Follicular Cells TFCs|age:5 mpf|genotype/variation:Tgtg:nls EGFP pax2a:mKO2 Knock in|population:pax2a High mKO2 High Pax2a High TFC 1 Mapping using HISAT2 against GRCz11with default parameters Counts per gene generated using FeatureCounts with default parameters Genome build: Zebrafish GRCz11 Supplementary files format and content: read counts as tsv file Thyroid Follicular Cells TFCs   Enzymatic Dissociation Ribozyme depletion adapter ligation followed by llumina NextSeq500   age:5 mpf|genotype/variation:Tgtg:nls EGFP pax2a:mKO2 Knock in|population:pax2a High mKO2 High GSM4635492 GSM4635492: Pax2a High TFC 1; Danio rerio; RNA Seq GSM4635492   1 Enzymatic Dissociation Ribozyme depletion adapter ligation followed by llumina NextSeq500 GEO Accession:GSM4635492 RNA-Seq TRANSCRIPTOMIC cDNA PAIRED ILLUMINA NextSeq 500   SRP268708     Pax2a-highset1_S10_R1_001.fastq.gz Pax2a-highset1_S10_R2_001.fastq.gz fastq fastq 16402884907.0 81622449.0 GSM4635492 r1 0:100.45 1:100.51 A:4148895557;C:4226508291;G:3782541016;T:4243916995;N:1023048 100 100     4148895557 4226508291 3782541016 4243916995 1023048 SRX8610749 SRS6900394 SRA1090834 GEO Single Cell Endocrinology, IRIBHM 2 0.25304 0.25554 0.09753 0.10045 0.89986 0.89936 0.4275 0.41328 101 99 B B biological fallback assumption illumina nextseq unknown cdna_unspecified unknown sc_generic single_cell_generic generic-scrnaseq-only   Belgium 2020-06-24 Adult Adult Multi-tissue Multi-system
60006 60006 SRR12083654 SRX8610748 SRS6900393 SRP268708 PRJNA641707 Transcriptional profiling of pax2a Low and pax2a High thyroid follicular cells in zebrafish GSE153197 Transcriptome Analysis Thyroid follicular cells TFCs are responsible for generation storage and release of thyroid hormone. Single cell analysis of zebrafish thyroid gland demonstrated transcriptional heterogeneity within the TFC population Gillotay et al. bioRxiv 2020. doi: 10.1101/2020.01.13.891630. GEO dataset for single cell RNA Seq.: GSE133466. Particularly TFC displayed transcriptional heterogeneity in the expression of pax2a a transcription factor involved in differentiation and maturation of TFCs. To validate the genetic heterogeneity we generated a pax2a knock in line in which mKO2 expression is driven by endogenous pax2a locus. Using Tgtg:nls EGFP; pax2a:mKO2 Knock in we sorted for TFCs GFP+ and separated the pax2a Low mKO2 Low and pax2a High mKO2 High populations for NGS. Overall design: We used fluorescence activated cell sorting FACS coupled with next generation RNA Sequencing to profile pax2a high and pax2a low TFCs from 5 mpf animals. Cells were sorted directly into lysis buffer provided in ReliaPrep™ RNA Miniprep Systems Promega Z6011 and mRNA isolated according to the manufactor's protocol. cDNA was generated using Ribozome depletion protocol followed by adapter ligation. Sequencing was performed on llumina NextSeq500. Reads were splice aligned to the zebrafish genome GRCz11 using HISAT2. Featurecounts was used to assign reads to exons thus eventually getting counts per gene.   pubmed:33140917   Pax2a Low TFC 1 GSM4635491   tissue:Thyroid Follicular Cells TFCs|age:5 mpf|genotype/variation:Tgtg:nls EGFP pax2a:mKO2 Knock in|population:pax2a Low mKO2 Low Pax2a Low TFC 1 Mapping using HISAT2 against GRCz11with default parameters Counts per gene generated using FeatureCounts with default parameters Genome build: Zebrafish GRCz11 Supplementary files format and content: read counts as tsv file Thyroid Follicular Cells TFCs   Enzymatic Dissociation Ribozyme depletion adapter ligation followed by llumina NextSeq500   age:5 mpf|genotype/variation:Tgtg:nls EGFP pax2a:mKO2 Knock in|population:pax2a Low mKO2 Low GSM4635491 GSM4635491: Pax2a Low TFC 1; Danio rerio; RNA Seq GSM4635491   1 Enzymatic Dissociation Ribozyme depletion adapter ligation followed by llumina NextSeq500 GEO Accession:GSM4635491 RNA-Seq TRANSCRIPTOMIC cDNA PAIRED ILLUMINA NextSeq 500   SRP268708     Pax2a-lowset1_S9_R1_001.fastq.gz Pax2a-lowset1_S9_R2_001.fastq.gz fastq fastq 17841813800.0 88772569.0 GSM4635491 r1 0:100.47 1:100.51 A:4653492569;C:4489464840;G:4023148591;T:4674617491;N:1090309 100 100     4653492569 4489464840 4023148591 4674617491 1090309 SRX8610748 SRS6900393 SRA1090834 GEO Single Cell Endocrinology, IRIBHM 2 0.08055 0.07962 0.02812 0.02691 0.96126 0.96126 0.67769 0.72985 100 101 T T mates < 9% mapping rate illumina nextseq unknown cdna_unspecified unknown sc_generic single_cell_generic generic-scrnaseq-only   Belgium 2020-06-24 Adult Adult Multi-tissue Multi-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");;