RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

run_metadata

15 rows where experiment.library_layout = "SINGLE", experiment.library_selection = "size fractionation" and experiment.platform = "BGISEQ"

✎ View and edit SQL

This data as json, CSV (advanced)

tissue_curation_coarse 1

tissue_curation 1

technology 1

experiment.platform 1

  • BGISEQ · 15 ✖

experiment.library_strategy 1

experiment.library_source 1

experiment.library_selection 1

  • size fractionation · 15 ✖

experiment.library_layout 1

  • SINGLE · 15 ✖

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
71643 71643 SRR21869762 SRX17856938 SRS15377982 SRP402080 PRJNA889683 miRNA mRNA sequencing of zebrafish embryos PRJNA889683 Other miRNA Seq and RNA Seq data of zebrafish embryos post exposure to TBBPA and TBBPA BHEE         BHEE H 3   replicate:biological replicate 3|strain:AB|isolate:not applicable|breed:wild type|cultivar:not applicable|ecotype:not applicable|age:120 hpf|dev stage:larvae|sex:not applicable|tissue:whole body 15|BioSampleModel:Model organism or animal                 miRNA Seq of zebrafish larvae AT20221124 AT20221124 miRNA Seq of zebrafish larvae     miRNA-Seq TRANSCRIPTOMIC size fractionation SINGLE BGISEQ BGISEQ-500   SRP402080   loader:fastq load.py BHEE_H_3.fq.gz fastq 533428889.0 23211223.0 BHEE H 3.fq.gz 0:22.98 A:120057830;C:104713991;G:142506271;T:166150296;N:501 22       120057830 104713991 142506271 166150296 501 SRX17856938 SRS15377982 SRA1518395 Jiangsu University|School of Environment and Safety Engineering Jiangsu University 1 0.79272   0.10596   0.92431   0.52918   22   B   usable mapping rate bgi bgi unknown size_fractionation unknown bulk unknown unknown   China 2022-10-12 Larval Larval Trunk Surface Structure
71644 71644 SRR21869763 SRX17856937 SRS15377981 SRP402080 PRJNA889683 miRNA mRNA sequencing of zebrafish embryos PRJNA889683 Other miRNA Seq and RNA Seq data of zebrafish embryos post exposure to TBBPA and TBBPA BHEE         BHEE H 2   replicate:biological replicate 2|strain:AB|isolate:not applicable|breed:wild type|cultivar:not applicable|ecotype:not applicable|age:120 hpf|dev stage:larvae|sex:not applicable|tissue:whole body 14|BioSampleModel:Model organism or animal                 miRNA Seq of zebrafish larvae AT20221123 AT20221123 miRNA Seq of zebrafish larvae     miRNA-Seq TRANSCRIPTOMIC size fractionation SINGLE BGISEQ BGISEQ-500   SRP402080   loader:fastq load.py BHEE_H_2.fq.gz fastq 542237520.0 23757627.0 BHEE H 2.fq.gz 0:22.82 A:118608004;C:107602147;G:146341292;T:169685803;N:274 22       118608004 107602147 146341292 169685803 274 SRX17856937 SRS15377981 SRA1518395 Jiangsu University|School of Environment and Safety Engineering Jiangsu University 1 0.78829   0.10064   0.91346   0.52625   22   B   usable mapping rate bgi bgi unknown size_fractionation unknown bulk unknown unknown   China 2022-10-12 Larval Larval Trunk Surface Structure
71645 71645 SRR21869764 SRX17856936 SRS15377980 SRP402080 PRJNA889683 miRNA mRNA sequencing of zebrafish embryos PRJNA889683 Other miRNA Seq and RNA Seq data of zebrafish embryos post exposure to TBBPA and TBBPA BHEE         BHEE H 1   replicate:biological replicate 1|strain:AB|isolate:not applicable|breed:wild type|cultivar:not applicable|ecotype:not applicable|age:120 hpf|dev stage:larvae|sex:not applicable|tissue:whole body 13|BioSampleModel:Model organism or animal                 miRNA Seq of zebrafish larvae AT20221122 AT20221122 miRNA Seq of zebrafish larvae     miRNA-Seq TRANSCRIPTOMIC size fractionation SINGLE BGISEQ BGISEQ-500   SRP402080   loader:fastq load.py BHEE_H_1.fq.gz fastq 553437966.0 24068768.0 BHEE H 1.fq.gz 0:22.99 A:123764056;C:109954264;G:151884637;T:167834745;N:264 22       123764056 109954264 151884637 167834745 264 SRX17856936 SRS15377980 SRA1518395 Jiangsu University|School of Environment and Safety Engineering Jiangsu University 1 0.70849   0.09465   0.91768   0.52194   22   B   usable mapping rate bgi bgi unknown size_fractionation unknown bulk unknown unknown   China 2022-10-12 Larval Larval Trunk Surface Structure
71646 71646 SRR21869765 SRX17856935 SRS15377979 SRP402080 PRJNA889683 miRNA mRNA sequencing of zebrafish embryos PRJNA889683 Other miRNA Seq and RNA Seq data of zebrafish embryos post exposure to TBBPA and TBBPA BHEE         BHEE L 3   replicate:biological replicate 3|strain:AB|isolate:not applicable|breed:wild type|cultivar:not applicable|ecotype:not applicable|age:120 hpf|dev stage:larvae|sex:not applicable|tissue:whole body 12|BioSampleModel:Model organism or animal                 miRNA Seq of zebrafish larvae AT20221121 AT20221121 miRNA Seq of zebrafish larvae     miRNA-Seq TRANSCRIPTOMIC size fractionation SINGLE BGISEQ BGISEQ-500   SRP402080   loader:fastq load.py BHEE_L_3.fq.gz fastq 534633614.0 23823089.0 BHEE L 3.fq.gz 0:22.44 A:117363754;C:102332510;G:134833529;T:180103711;N:110 22       117363754 102332510 134833529 180103711 110 SRX17856935 SRS15377979 SRA1518395 Jiangsu University|School of Environment and Safety Engineering Jiangsu University 1 0.91988   0.08325   0.94073   0.53253   23   B   usable mapping rate bgi bgi unknown size_fractionation unknown bulk unknown unknown   China 2022-10-12 Larval Larval Trunk Surface Structure
71647 71647 SRR21869766 SRX17856934 SRS15377978 SRP402080 PRJNA889683 miRNA mRNA sequencing of zebrafish embryos PRJNA889683 Other miRNA Seq and RNA Seq data of zebrafish embryos post exposure to TBBPA and TBBPA BHEE         BHEE L 2   replicate:biological replicate 2|strain:AB|isolate:not applicable|breed:wild type|cultivar:not applicable|ecotype:not applicable|age:120 hpf|dev stage:larvae|sex:not applicable|tissue:whole body 11|BioSampleModel:Model organism or animal                 miRNA Seq of zebrafish larvae AT20221120 AT20221120 miRNA Seq of zebrafish larvae     miRNA-Seq TRANSCRIPTOMIC size fractionation SINGLE BGISEQ BGISEQ-500   SRP402080   loader:fastq load.py BHEE_L_2.fq.gz fastq 544854900.0 24226737.0 BHEE L 2.fq.gz 0:22.49 A:119782823;C:104902871;G:136756907;T:183412172;N:127 22       119782823 104902871 136756907 183412172 127 SRX17856934 SRS15377978 SRA1518395 Jiangsu University|School of Environment and Safety Engineering Jiangsu University 1 0.93474   0.08179   0.9345   0.52916   22   B   usable mapping rate bgi bgi unknown size_fractionation unknown bulk unknown unknown   China 2022-10-12 Larval Larval Trunk Surface Structure
71648 71648 SRR21869767 SRX17856933 SRS15377990 SRP402080 PRJNA889683 miRNA mRNA sequencing of zebrafish embryos PRJNA889683 Other miRNA Seq and RNA Seq data of zebrafish embryos post exposure to TBBPA and TBBPA BHEE         BHEE L 1   replicate:biological replicate 1|strain:AB|isolate:not applicable|breed:wild type|cultivar:not applicable|ecotype:not applicable|age:120 hpf|dev stage:larvae|sex:not applicable|tissue:whole body 10|BioSampleModel:Model organism or animal                 miRNA Seq of zebrafish larvae AT20221119 AT20221119 miRNA Seq of zebrafish larvae     miRNA-Seq TRANSCRIPTOMIC size fractionation SINGLE BGISEQ BGISEQ-500   SRP402080   loader:fastq load.py BHEE_L_1.fq.gz fastq 536871966.0 23768969.0 BHEE L 1.fq.gz 0:22.59 A:117321330;C:102381550;G:133641788;T:183527144;N:154 22       117321330 102381550 133641788 183527144 154 SRX17856933 SRS15377990 SRA1518395 Jiangsu University|School of Environment and Safety Engineering Jiangsu University 1 0.94042   0.08986   0.93141   0.51821   22   B   usable mapping rate bgi bgi unknown size_fractionation unknown bulk unknown unknown   China 2022-10-12 Larval Larval Trunk Surface Structure
71649 71649 SRR21869768 SRX17856932 SRS15377989 SRP402080 PRJNA889683 miRNA mRNA sequencing of zebrafish embryos PRJNA889683 Other miRNA Seq and RNA Seq data of zebrafish embryos post exposure to TBBPA and TBBPA BHEE         TBBPA H 3   replicate:biological replicate 3|strain:AB|isolate:not applicable|breed:wild type|cultivar:not applicable|ecotype:not applicable|age:120 hpf|dev stage:larvae|sex:not applicable|tissue:whole body 9|BioSampleModel:Model organism or animal                 miRNA Seq of zebrafish larvae AT20221118 AT20221118 miRNA Seq of zebrafish larvae     miRNA-Seq TRANSCRIPTOMIC size fractionation SINGLE BGISEQ BGISEQ-500   SRP402080   loader:fastq load.py TBBPA_H_3.fq.gz fastq 528430937.0 23464221.0 TBBPA H 3.fq.gz 0:22.52 A:115261465;C:101477007;G:136961367;T:174730904;N:194 22       115261465 101477007 136961367 174730904 194 SRX17856932 SRS15377989 SRA1518395 Jiangsu University|School of Environment and Safety Engineering Jiangsu University 1 0.89616   0.09929   0.93042   0.5004   22   B   usable mapping rate bgi bgi unknown size_fractionation unknown bulk unknown unknown   China 2022-10-12 Larval Larval Trunk Surface Structure
71650 71650 SRR21869769 SRX17856931 SRS15377988 SRP402080 PRJNA889683 miRNA mRNA sequencing of zebrafish embryos PRJNA889683 Other miRNA Seq and RNA Seq data of zebrafish embryos post exposure to TBBPA and TBBPA BHEE         TBBPA H 2   replicate:biological replicate 2|strain:AB|isolate:not applicable|breed:wild type|cultivar:not applicable|ecotype:not applicable|age:120 hpf|dev stage:larvae|sex:not applicable|tissue:whole body 8|BioSampleModel:Model organism or animal                 miRNA Seq of zebrafish larvae AT20221117 AT20221117 miRNA Seq of zebrafish larvae     miRNA-Seq TRANSCRIPTOMIC size fractionation SINGLE BGISEQ BGISEQ-500   SRP402080   loader:fastq load.py TBBPA_H_2.fq.gz fastq 523343500.0 22888420.0 TBBPA H 2.fq.gz 0:22.86 A:114272050;C:101352294;G:133914155;T:173804699;N:302 22       114272050 101352294 133914155 173804699 302 SRX17856931 SRS15377988 SRA1518395 Jiangsu University|School of Environment and Safety Engineering Jiangsu University 1 0.90842   0.10759   0.92088   0.53284   20   B   usable mapping rate bgi bgi unknown size_fractionation unknown bulk unknown unknown   China 2022-10-12 Larval Larval Trunk Surface Structure
71651 71651 SRR21869770 SRX17856930 SRS15377987 SRP402080 PRJNA889683 miRNA mRNA sequencing of zebrafish embryos PRJNA889683 Other miRNA Seq and RNA Seq data of zebrafish embryos post exposure to TBBPA and TBBPA BHEE         TBBPA H 1   replicate:biological replicate 1|strain:AB|isolate:not applicable|breed:wild type|cultivar:not applicable|ecotype:not applicable|age:120 hpf|dev stage:larvae|sex:not applicable|tissue:whole body 7|BioSampleModel:Model organism or animal                 miRNA Seq of zebrafish larvae AT20221116 AT20221116 miRNA Seq of zebrafish larvae     miRNA-Seq TRANSCRIPTOMIC size fractionation SINGLE BGISEQ BGISEQ-500   SRP402080   loader:fastq load.py TBBPA_H_1.fq.gz fastq 538481195.0 23517366.0 TBBPA H 1.fq.gz 0:22.90 A:117132485;C:106262580;G:143962997;T:171122739;N:394 22       117132485 106262580 143962997 171122739 394 SRX17856930 SRS15377987 SRA1518395 Jiangsu University|School of Environment and Safety Engineering Jiangsu University 1 0.83673   0.10787   0.91238   0.53365   21   B   usable mapping rate bgi bgi unknown size_fractionation unknown bulk unknown unknown   China 2022-10-12 Larval Larval Trunk Surface Structure
71652 71652 SRR21869771 SRX17856929 SRS15377986 SRP402080 PRJNA889683 miRNA mRNA sequencing of zebrafish embryos PRJNA889683 Other miRNA Seq and RNA Seq data of zebrafish embryos post exposure to TBBPA and TBBPA BHEE         TBBPA L 3   replicate:biological replicate 3|strain:AB|isolate:not applicable|breed:wild type|cultivar:not applicable|ecotype:not applicable|age:120 hpf|dev stage:larvae|sex:not applicable|tissue:whole body 6|BioSampleModel:Model organism or animal                 miRNA Seq of zebrafish larvae AT20221115 AT20221115 miRNA Seq of zebrafish larvae     miRNA-Seq TRANSCRIPTOMIC size fractionation SINGLE BGISEQ BGISEQ-500   SRP402080   loader:fastq load.py TBBPA_L_3.fq.gz fastq 536529124.0 23817957.0 TBBPA L 3.fq.gz 0:22.53 A:115664153;C:104457844;G:136444705;T:179962303;N:119 22       115664153 104457844 136444705 179962303 119 SRX17856929 SRS15377986 SRA1518395 Jiangsu University|School of Environment and Safety Engineering Jiangsu University 1 0.86178   0.09041   0.93624   0.4992   22   B   usable mapping rate bgi bgi unknown size_fractionation unknown bulk unknown unknown   China 2022-10-12 Larval Larval Trunk Surface Structure
71654 71654 SRR21869773 SRX17856927 SRS15377985 SRP402080 PRJNA889683 miRNA mRNA sequencing of zebrafish embryos PRJNA889683 Other miRNA Seq and RNA Seq data of zebrafish embryos post exposure to TBBPA and TBBPA BHEE         TBBPA L 2   replicate:biological replicate 2|strain:AB|isolate:not applicable|breed:wild type|cultivar:not applicable|ecotype:not applicable|age:120 hpf|dev stage:larvae|sex:not applicable|tissue:whole body 5|BioSampleModel:Model organism or animal                 miRNA Seq of zebrafish larvae AT20221114 AT20221114 miRNA Seq of zebrafish larvae     miRNA-Seq TRANSCRIPTOMIC size fractionation SINGLE BGISEQ BGISEQ-500   SRP402080   loader:fastq load.py TBBPA_L_2.fq.gz fastq 525712427.0 23458446.0 TBBPA L 2.fq.gz 0:22.41 A:115172158;C:103930973;G:133832634;T:172776555;N:107 22       115172158 103930973 133832634 172776555 107 SRX17856927 SRS15377985 SRA1518395 Jiangsu University|School of Environment and Safety Engineering Jiangsu University 1 0.87223   0.08526   0.93845   0.54116   22   B   usable mapping rate bgi bgi unknown size_fractionation unknown bulk unknown unknown   China 2022-10-12 Larval Larval Trunk Surface Structure
71655 71655 SRR21869774 SRX17856926 SRS15377984 SRP402080 PRJNA889683 miRNA mRNA sequencing of zebrafish embryos PRJNA889683 Other miRNA Seq and RNA Seq data of zebrafish embryos post exposure to TBBPA and TBBPA BHEE         TBBPA L 1   replicate:biological replicate 1|strain:AB|isolate:not applicable|breed:wild type|cultivar:not applicable|ecotype:not applicable|age:120 hpf|dev stage:larvae|sex:not applicable|tissue:whole body 4|BioSampleModel:Model organism or animal                 miRNA Seq of zebrafish larvae AT20221113 AT20221113 miRNA Seq of zebrafish larvae     miRNA-Seq TRANSCRIPTOMIC size fractionation SINGLE BGISEQ BGISEQ-500   SRP402080   loader:fastq load.py TBBPA_L_1.fq.gz fastq 527804519.0 23370082.0 TBBPA L 1.fq.gz 0:22.58 A:114266025;C:102477479;G:134403120;T:176657729;N:166 22       114266025 102477479 134403120 176657729 166 SRX17856926 SRS15377984 SRA1518395 Jiangsu University|School of Environment and Safety Engineering Jiangsu University 1 0.89339   0.09635   0.92608   0.48415   22   B   usable mapping rate bgi bgi unknown size_fractionation unknown bulk unknown unknown   China 2022-10-12 Larval Larval Trunk Surface Structure
71656 71656 SRR21869775 SRX17856925 SRS15377983 SRP402080 PRJNA889683 miRNA mRNA sequencing of zebrafish embryos PRJNA889683 Other miRNA Seq and RNA Seq data of zebrafish embryos post exposure to TBBPA and TBBPA BHEE         Control 3   replicate:biological replicate 3|strain:AB|isolate:not applicable|breed:wild type|cultivar:not applicable|ecotype:not applicable|age:120 hpf|dev stage:larvae|sex:not applicable|tissue:whole body 3|BioSampleModel:Model organism or animal                 miRNA Seq of zebrafish larvae AT20221112 AT20221112 miRNA Seq of zebrafish larvae     miRNA-Seq TRANSCRIPTOMIC size fractionation SINGLE BGISEQ BGISEQ-500   SRP402080   loader:fastq load.py Control_3.fq.gz fastq 535579212.0 23899710.0 Control 3.fq.gz 0:22.41 A:117125157;C:106586085;G:133001456;T:178866289;N:225 22       117125157 106586085 133001456 178866289 225 SRX17856925 SRS15377983 SRA1518395 Jiangsu University|School of Environment and Safety Engineering Jiangsu University 1 0.89094   0.06851   0.94807   0.54835   23   B   usable mapping rate bgi bgi unknown size_fractionation unknown bulk unknown unknown   China 2022-10-12 Larval Larval Trunk Surface Structure
71657 71657 SRR21869776 SRX17856924 SRS15377977 SRP402080 PRJNA889683 miRNA mRNA sequencing of zebrafish embryos PRJNA889683 Other miRNA Seq and RNA Seq data of zebrafish embryos post exposure to TBBPA and TBBPA BHEE         Control 2   replicate:biological replicate 2|strain:AB|isolate:not applicable|breed:wild type|cultivar:not applicable|ecotype:not applicable|age:120 hpf|dev stage:larvae|sex:not applicable|tissue:whole body 2|BioSampleModel:Model organism or animal                 miRNA Seq of zebrafish larvae AT20221111 AT20221111 miRNA Seq of zebrafish larvae     miRNA-Seq TRANSCRIPTOMIC size fractionation SINGLE BGISEQ BGISEQ-500   SRP402080   loader:fastq load.py Control_2.fq.gz fastq 528466892.0 23430674.0 Control 2.fq.gz 0:22.55 A:116361274;C:103960709;G:132758802;T:175385846;N:261 22       116361274 103960709 132758802 175385846 261 SRX17856924 SRS15377977 SRA1518395 Jiangsu University|School of Environment and Safety Engineering Jiangsu University 1 0.89063   0.07453   0.94255   0.54503   21   B   usable mapping rate bgi bgi unknown size_fractionation unknown bulk unknown unknown   China 2022-10-12 Larval Larval Trunk Surface Structure
71658 71658 SRR21869777 SRX17856923 SRS15377976 SRP402080 PRJNA889683 miRNA mRNA sequencing of zebrafish embryos PRJNA889683 Other miRNA Seq and RNA Seq data of zebrafish embryos post exposure to TBBPA and TBBPA BHEE         Control 1   replicate:biological replicate 1|strain:AB|isolate:not applicable|breed:wild type|cultivar:not applicable|ecotype:not applicable|age:120 hpf|dev stage:larvae|sex:not applicable|tissue:whole body 1|BioSampleModel:Model organism or animal                 miRNA Seq of zebrafish larvae AT20221110 AT20221110 miRNA Seq of zebrafish larvae     miRNA-Seq TRANSCRIPTOMIC size fractionation SINGLE BGISEQ BGISEQ-500   SRP402080   loader:fastq load.py Control_1.fq.gz fastq 517484481.0 23046792.0 Control 1.fq.gz 0:22.45 A:114187486;C:101456491;G:129311971;T:172528320;N:213 22       114187486 101456491 129311971 172528320 213 SRX17856923 SRS15377976 SRA1518395 Jiangsu University|School of Environment and Safety Engineering Jiangsu University 1 0.89811   0.07533   0.93198   0.55322   22   B   usable mapping rate bgi bgi unknown size_fractionation unknown bulk unknown unknown   China 2022-10-12 Larval Larval Trunk Surface Structure

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");;