RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

run_metadata

15 rows where devstage_curation = "Pharyngula" and experiment.library_selection = "CAGE"

✎ View and edit SQL

This data as json, CSV (advanced)

tissue_curation 2

experiment.library_layout 2

tissue_curation_coarse 1

technology 1

experiment.platform 1

experiment.library_strategy 1

experiment.library_source 1

experiment.library_selection 1

  • CAGE · 15 ✖

devstage_curation_coarse 1

devstage_curation 1

  • Pharyngula · 15 ✖
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
55266 55266 SRR10418684 SRX7116713 SRS5465204 SRP223930 PRJNA575342 CAGE /CappedRNA sequencig PRJNA575342 Other CAGE and full length capped RNA sequencing for identification of transcription start TSS utilisation during Zebrafish Danio rerio embryonic development         S06 Prim5   strain:AB|dev stage:Prim 5|sex:N/A|tissue:whole embryo|BioSampleModel:Model organism or animal                 CAGE seq of Danio rerio whole embryo Prim 5 stage Cycloheximide treated for 2 hours Prim5 tagCAGE CHX Prim5 tagCAGE CHX Tagging CAGE     RNA-Seq TRANSCRIPTOMIC CAGE SINGLE ILLUMINA Illumina Genome Analyzer IIx   SRP223930     S06_Prim5_tagCAGE-CHX.fastq.gz fastq 272077515.0 10076945.0 S06 Prim5 tagCAGE CHX.fastq.gz 0:27 A:67002738;C:62164745;G:73707100;T:69202932;N:0 27       67002738 62164745 73707100 69202932 0 SRX7116713 SRS5465204 SRA993027 University of Birmingham|Cancer and Genomic Sciences University of Birmingham 1 0.44237   0.05018   0.80296   0.84125   27   B   usable mapping rate illumina early_illumina full_length cage unknown bulk unknown unknown   United Kingdom 2019-11-08 Pharyngula Embryo Whole Organism All anatomical structures
55267 55267 SRR10418685 SRX7116712 SRS5465204 SRP223930 PRJNA575342 CAGE /CappedRNA sequencig PRJNA575342 Other CAGE and full length capped RNA sequencing for identification of transcription start TSS utilisation during Zebrafish Danio rerio embryonic development         S06 Prim5   strain:AB|dev stage:Prim 5|sex:N/A|tissue:whole embryo|BioSampleModel:Model organism or animal                 CAGE seq of Danio rerio whole embryo Prim 5 stage DMSO control Prim5 tagCAGE DMSO Prim5 tagCAGE DMSO Tagging CAGE     RNA-Seq TRANSCRIPTOMIC CAGE SINGLE ILLUMINA Illumina Genome Analyzer IIx   SRP223930     S06_Prim5_tagCAGE-DMSO.fastq.gz fastq 339322419.0 12567497.0 S06 Prim5 tagCAGE DMSO.fastq.gz 0:27 A:81884992;C:78138597;G:89012923;T:90285907;N:0 27       81884992 78138597 89012923 90285907 0 SRX7116712 SRS5465204 SRA993027 University of Birmingham|Cancer and Genomic Sciences University of Birmingham 1 0.43876   0.05032   0.82404   0.85765   27   B   usable mapping rate illumina early_illumina full_length cage unknown bulk unknown unknown   United Kingdom 2019-11-08 Pharyngula Embryo Whole Organism All anatomical structures
55270 55270 SRR10215486 SRX6935169 SRS5465204 SRP223930 PRJNA575342 CAGE /CappedRNA sequencig PRJNA575342 Other CAGE and full length capped RNA sequencing for identification of transcription start TSS utilisation during Zebrafish Danio rerio embryonic development         S06 Prim5   strain:AB|dev stage:Prim 5|sex:N/A|tissue:whole embryo|BioSampleModel:Model organism or animal                 CAGE seq of Danio rerio whole embryo Prim 5 stage Prim5 nAnTiCAGE Prim5 nAnTiCAGE nAnTiCAGE     RNA-Seq TRANSCRIPTOMIC CAGE PAIRED ILLUMINA Illumina HiSeq 2500   SRP223930     S06_Prim5_nAnTiCAGE_1.fastq.gz S06_Prim5_nAnTiCAGE_2.fastq.gz fastq fastq 2672456099.0 13565767.0 S06 Prim5 nAnTiCAGE 1.fastq.gz 0:97 1:100 A:641958912;C:678208106;G:686299870;T:662301091;N:3688120 97 100     641958912 678208106 686299870 662301091 3688120 SRX6935169 SRS5465204 SRA971223 University of Birmingham|Cancer and Genomic Sciences University of Birmingham 2 0.94637 0.95975 0.15027 0.16177 0.74119 0.7441 0.50314 0.54386 97 100 B B biological fallback assumption illumina hiseq_era full_length cage unknown bulk unknown unknown   United Kingdom 2019-10-02 Pharyngula Embryo Whole Organism All anatomical structures
69379 69379 SRR18516703 SRX14647800 SRS12413216 SRP366491 PRJNA821088 Enhancer calling in early stages PRJNA821088 Other CAGE seq for enhancer calling in early stages for the DANIO CODE project.         DCD007476BS   strain:WT|age:24hpf|dev stage:Prim 5|sex:not applicable|tissue:early embryonic cell|biomaterial provider:Mueller lab University of Birmingham|replicate:1|BioSampleModel:Model organism or animal                 CAGE seq Prim Nuclear CAGE DCD003719SQ DCD003719SQ max read length:50     RNA-Seq TRANSCRIPTOMIC CAGE SINGLE ILLUMINA Illumina HiSeq 2500   SRP366491     CAGE-seq_Mueller_lab_0014AS.DCD003719SQ.USERdanio-user.R1.fastq.gz fastq 585510192.0 12198129.0 CAGE seq Mueller lab 0014AS.DCD003719SQ.USERdanio user.R1.fastq.gz 0:48 1:0 A:129885703;C:153766182;G:160138903;T:141666883;N:52521 48 0     129885703 153766182 160138903 141666883 52521 SRX14647800 SRS12413216 SRA1393740 DANIO-CODE|Department for Biosciences and Nutrition DANIO-CODE DANIO-CODE 1 0.20391   0.04196   0.83453   0.4979   48   B   usable mapping rate illumina hiseq_era unknown cage unknown bulk unknown unknown   Unknown 2022-03-29 Pharyngula Embryo Embryo Imprecise All anatomical structures
69380 69380 SRR18516704 SRX14647799 SRS12413216 SRP366491 PRJNA821088 Enhancer calling in early stages PRJNA821088 Other CAGE seq for enhancer calling in early stages for the DANIO CODE project.         DCD007476BS   strain:WT|age:24hpf|dev stage:Prim 5|sex:not applicable|tissue:early embryonic cell|biomaterial provider:Mueller lab University of Birmingham|replicate:1|BioSampleModel:Model organism or animal                 CAGE seq Prim Nuclear CAGE DCD003718SQ DCD003718SQ max read length:50     RNA-Seq TRANSCRIPTOMIC CAGE SINGLE ILLUMINA Illumina HiSeq 2500   SRP366491     CAGE-seq_Mueller_lab_0014AS.DCD003718SQ.USERdanio-user.R1.fastq.gz fastq 593136528.0 12357011.0 CAGE seq Mueller lab 0014AS.DCD003718SQ.USERdanio user.R1.fastq.gz 0:48 1:0 A:130366174;C:156810351;G:159219365;T:146691922;N:48716 48 0     130366174 156810351 159219365 146691922 48716 SRX14647799 SRS12413216 SRA1393740 DANIO-CODE|Department for Biosciences and Nutrition DANIO-CODE DANIO-CODE 1 0.14873   0.03239   0.86557   0.49634   48   B   usable mapping rate illumina hiseq_era unknown cage unknown bulk unknown unknown   Unknown 2022-03-29 Pharyngula Embryo Embryo Imprecise All anatomical structures
69381 69381 SRR18516705 SRX14647798 SRS12413216 SRP366491 PRJNA821088 Enhancer calling in early stages PRJNA821088 Other CAGE seq for enhancer calling in early stages for the DANIO CODE project.         DCD007476BS   strain:WT|age:24hpf|dev stage:Prim 5|sex:not applicable|tissue:early embryonic cell|biomaterial provider:Mueller lab University of Birmingham|replicate:1|BioSampleModel:Model organism or animal                 CAGE seq Prim Nuclear CAGE DCD003723SQ DCD003723SQ max read length:50     RNA-Seq TRANSCRIPTOMIC CAGE SINGLE ILLUMINA Illumina HiSeq 2500   SRP366491     CAGE-seq_Mueller_lab_0014AS.DCD003723SQ.USERdanio-user.R1.fastq.gz fastq 422696256.0 8806172.0 CAGE seq Mueller lab 0014AS.DCD003723SQ.USERdanio user.R1.fastq.gz 0:48 1:0 A:92712632;C:111696999;G:115145846;T:103105611;N:35168 48 0     92712632 111696999 115145846 103105611 35168 SRX14647798 SRS12413216 SRA1393740 DANIO-CODE|Department for Biosciences and Nutrition DANIO-CODE DANIO-CODE 1 0.1594   0.02997   0.85591   0.48496   48   B   usable mapping rate illumina hiseq_era unknown cage unknown bulk unknown unknown   Unknown 2022-03-29 Pharyngula Embryo Embryo Imprecise All anatomical structures
69382 69382 SRR18516706 SRX14647797 SRS12413215 SRP366491 PRJNA821088 Enhancer calling in early stages PRJNA821088 Other CAGE seq for enhancer calling in early stages for the DANIO CODE project.         DCD007477BS   strain:WT|age:42hpf|dev stage:High pec|sex:not applicable|tissue:early embryonic cell|biomaterial provider:Mueller lab University of Birmingham|replicate:1|BioSampleModel:Model organism or animal                 CAGE seq High pec Nuclear CAGE DCD003737SQ DCD003737SQ max read length:50     RNA-Seq TRANSCRIPTOMIC CAGE SINGLE ILLUMINA Illumina HiSeq 2500   SRP366491     CAGE-seq_Mueller_lab_0014AS.DCD003737SQ.USERdanio-user.R1.fastq.gz fastq 1041108672.0 21689764.0 CAGE seq Mueller lab 0014AS.DCD003737SQ.USERdanio user.R1.fastq.gz 0:48 1:0 A:233996885;C:276232291;G:275987771;T:254800016;N:91709 48 0     233996885 276232291 275987771 254800016 91709 SRX14647797 SRS12413215 SRA1393740 DANIO-CODE|Department for Biosciences and Nutrition DANIO-CODE DANIO-CODE 1 0.19665   0.0423   0.84271   0.49525   48   B   usable mapping rate illumina hiseq_era unknown cage unknown bulk unknown unknown   Unknown 2022-03-29 Pharyngula Embryo Embryo Imprecise All anatomical structures
69383 69383 SRR18516707 SRX14647796 SRS12413215 SRP366491 PRJNA821088 Enhancer calling in early stages PRJNA821088 Other CAGE seq for enhancer calling in early stages for the DANIO CODE project.         DCD007477BS   strain:WT|age:42hpf|dev stage:High pec|sex:not applicable|tissue:early embryonic cell|biomaterial provider:Mueller lab University of Birmingham|replicate:1|BioSampleModel:Model organism or animal                 CAGE seq High pec Nuclear CAGE DCD003729SQ DCD003729SQ max read length:50     RNA-Seq TRANSCRIPTOMIC CAGE SINGLE ILLUMINA Illumina HiSeq 2500   SRP366491     CAGE-seq_Mueller_lab_0014AS.DCD003729SQ.USERdanio-user.R1.fastq.gz fastq 383268528.0 7984761.0 CAGE seq Mueller lab 0014AS.DCD003729SQ.USERdanio user.R1.fastq.gz 0:48 1:0 A:83789437;C:103371728;G:102876480;T:93198236;N:32647 48 0     83789437 103371728 102876480 93198236 32647 SRX14647796 SRS12413215 SRA1393740 DANIO-CODE|Department for Biosciences and Nutrition DANIO-CODE DANIO-CODE 1 0.15605   0.03059   0.86951   0.50369   48   B   usable mapping rate illumina hiseq_era unknown cage unknown bulk unknown unknown   Unknown 2022-03-29 Pharyngula Embryo Embryo Imprecise All anatomical structures
69384 69384 SRR18516708 SRX14647795 SRS12413215 SRP366491 PRJNA821088 Enhancer calling in early stages PRJNA821088 Other CAGE seq for enhancer calling in early stages for the DANIO CODE project.         DCD007477BS   strain:WT|age:42hpf|dev stage:High pec|sex:not applicable|tissue:early embryonic cell|biomaterial provider:Mueller lab University of Birmingham|replicate:1|BioSampleModel:Model organism or animal                 CAGE seq High pec Nuclear CAGE DCD003734SQ DCD003734SQ max read length:50     RNA-Seq TRANSCRIPTOMIC CAGE SINGLE ILLUMINA Illumina HiSeq 2500   SRP366491     CAGE-seq_Mueller_lab_0014AS.DCD003734SQ.USERdanio-user.R1.fastq.gz fastq 560665392.0 11680529.0 CAGE seq Mueller lab 0014AS.DCD003734SQ.USERdanio user.R1.fastq.gz 0:48 1:0 A:123278501;C:149059346;G:152514412;T:135763704;N:49429 48 0     123278501 149059346 152514412 135763704 49429 SRX14647795 SRS12413215 SRA1393740 DANIO-CODE|Department for Biosciences and Nutrition DANIO-CODE DANIO-CODE 1 0.16518   0.02906   0.85283   0.47924   48   B   usable mapping rate illumina hiseq_era unknown cage unknown bulk unknown unknown   Unknown 2022-03-29 Pharyngula Embryo Embryo Imprecise All anatomical structures
69385 69385 SRR18516709 SRX14647794 SRS12413214 SRP366491 PRJNA821088 Enhancer calling in early stages PRJNA821088 Other CAGE seq for enhancer calling in early stages for the DANIO CODE project.         DCD007471BS   strain:WT|age:42hpf|dev stage:High pec|sex:not applicable|tissue:early embryonic cell|biomaterial provider:Mueller lab University of Birmingham|replicate:2|BioSampleModel:Model organism or animal                 CAGE seq High pec Whole cell CAGE DCD003731SQ DCD003731SQ max read length:50     RNA-Seq TRANSCRIPTOMIC CAGE SINGLE ILLUMINA Illumina HiSeq 2500   SRP366491     CAGE-seq_Mueller_lab_0013AS.DCD003731SQ.USERdanio-user.R1.fastq.gz fastq 534745104.0 11140523.0 CAGE seq Mueller lab 0013AS.DCD003731SQ.USERdanio user.R1.fastq.gz 0:48 1:0 A:122900964;C:145291239;G:142314928;T:124199394;N:38579 48 0     122900964 145291239 142314928 124199394 38579 SRX14647794 SRS12413214 SRA1393740 DANIO-CODE|Department for Biosciences and Nutrition DANIO-CODE DANIO-CODE 1 0.21193   0.03662   0.8576   0.51061   48   B   usable mapping rate illumina hiseq_era unknown cage unknown bulk unknown unknown   Unknown 2022-03-29 Pharyngula Embryo Embryo Imprecise All anatomical structures
69386 69386 SRR18516710 SRX14647793 SRS12413214 SRP366491 PRJNA821088 Enhancer calling in early stages PRJNA821088 Other CAGE seq for enhancer calling in early stages for the DANIO CODE project.         DCD007471BS   strain:WT|age:42hpf|dev stage:High pec|sex:not applicable|tissue:early embryonic cell|biomaterial provider:Mueller lab University of Birmingham|replicate:2|BioSampleModel:Model organism or animal                 CAGE seq High pec Whole cell CAGE DCD003733SQ DCD003733SQ max read length:50     RNA-Seq TRANSCRIPTOMIC CAGE SINGLE ILLUMINA Illumina HiSeq 2500   SRP366491     CAGE-seq_Mueller_lab_0013AS.DCD003733SQ.USERdanio-user.R1.fastq.gz fastq 1106623152.0 23054649.0 CAGE seq Mueller lab 0013AS.DCD003733SQ.USERdanio user.R1.fastq.gz 0:48 1:0 A:244437769;C:302018709;G:293780395;T:266329857;N:56422 48 0     244437769 302018709 293780395 266329857 56422 SRX14647793 SRS12413214 SRA1393740 DANIO-CODE|Department for Biosciences and Nutrition DANIO-CODE DANIO-CODE 1 0.25973   0.02959   0.84778   0.50948   48   B   usable mapping rate illumina hiseq_era unknown cage unknown bulk unknown unknown   Unknown 2022-03-29 Pharyngula Embryo Embryo Imprecise All anatomical structures
69387 69387 SRR18516711 SRX14647792 SRS12413214 SRP366491 PRJNA821088 Enhancer calling in early stages PRJNA821088 Other CAGE seq for enhancer calling in early stages for the DANIO CODE project.         DCD007471BS   strain:WT|age:42hpf|dev stage:High pec|sex:not applicable|tissue:early embryonic cell|biomaterial provider:Mueller lab University of Birmingham|replicate:2|BioSampleModel:Model organism or animal                 CAGE seq High pec Whole cell CAGE DCD003735SQ DCD003735SQ max read length:50     RNA-Seq TRANSCRIPTOMIC CAGE SINGLE ILLUMINA Illumina HiSeq 2500   SRP366491     CAGE-seq_Mueller_lab_0013AS.DCD003735SQ.USERdanio-user.R1.fastq.gz fastq 829987920.0 17291415.0 CAGE seq Mueller lab 0013AS.DCD003735SQ.USERdanio user.R1.fastq.gz 0:48 1:0 A:189638839;C:226118233;G:218991435;T:195178858;N:60555 48 0     189638839 226118233 218991435 195178858 60555 SRX14647792 SRS12413214 SRA1393740 DANIO-CODE|Department for Biosciences and Nutrition DANIO-CODE DANIO-CODE 1 0.20953   0.03562   0.85285   0.52927   48   B   usable mapping rate illumina hiseq_era unknown cage unknown bulk unknown unknown   Unknown 2022-03-29 Pharyngula Embryo Embryo Imprecise All anatomical structures
69392 69392 SRR18516716 SRX14647787 SRS12413212 SRP366491 PRJNA821088 Enhancer calling in early stages PRJNA821088 Other CAGE seq for enhancer calling in early stages for the DANIO CODE project.         DCD007473BS   strain:WT|age:24hpf|dev stage:Prim 5|sex:not applicable|tissue:early embryonic cell|biomaterial provider:Mueller lab University of Birmingham|replicate:2|BioSampleModel:Model organism or animal                 CAGE seq Prim Whole cell CAGE DCD003727SQ DCD003727SQ max read length:50     RNA-Seq TRANSCRIPTOMIC CAGE SINGLE ILLUMINA Illumina HiSeq 2500   SRP366491     CAGE-seq_Mueller_lab_0013AS.DCD003727SQ.USERdanio-user.R1.fastq.gz fastq 924879888.0 19268331.0 CAGE seq Mueller lab 0013AS.DCD003727SQ.USERdanio user.R1.fastq.gz 0:48 1:0 A:214005056;C:251321459;G:244648845;T:214835794;N:68734 48 0     214005056 251321459 244648845 214835794 68734 SRX14647787 SRS12413212 SRA1393740 DANIO-CODE|Department for Biosciences and Nutrition DANIO-CODE DANIO-CODE 1 0.2165   0.03701   0.84768   0.54102   48   B   usable mapping rate illumina hiseq_era unknown cage unknown bulk unknown unknown   Unknown 2022-03-29 Pharyngula Embryo Embryo Imprecise All anatomical structures
69393 69393 SRR18516717 SRX14647786 SRS12413212 SRP366491 PRJNA821088 Enhancer calling in early stages PRJNA821088 Other CAGE seq for enhancer calling in early stages for the DANIO CODE project.         DCD007473BS   strain:WT|age:24hpf|dev stage:Prim 5|sex:not applicable|tissue:early embryonic cell|biomaterial provider:Mueller lab University of Birmingham|replicate:2|BioSampleModel:Model organism or animal                 CAGE seq Prim Whole cell CAGE DCD003717SQ DCD003717SQ max read length:50     RNA-Seq TRANSCRIPTOMIC CAGE SINGLE ILLUMINA Illumina HiSeq 2500   SRP366491     CAGE-seq_Mueller_lab_0013AS.DCD003717SQ.USERdanio-user.R1.fastq.gz fastq 1485845376.0 30955112.0 CAGE seq Mueller lab 0013AS.DCD003717SQ.USERdanio user.R1.fastq.gz 0:48 1:0 A:329122121;C:402514173;G:390388645;T:363745867;N:74570 48 0     329122121 402514173 390388645 363745867 74570 SRX14647786 SRS12413212 SRA1393740 DANIO-CODE|Department for Biosciences and Nutrition DANIO-CODE DANIO-CODE 1 0.23893   0.0248   0.86125   0.50849   48   B   usable mapping rate illumina hiseq_era unknown cage unknown bulk unknown unknown   Unknown 2022-03-29 Pharyngula Embryo Embryo Imprecise All anatomical structures
69394 69394 SRR18516718 SRX14647785 SRS12413212 SRP366491 PRJNA821088 Enhancer calling in early stages PRJNA821088 Other CAGE seq for enhancer calling in early stages for the DANIO CODE project.         DCD007473BS   strain:WT|age:24hpf|dev stage:Prim 5|sex:not applicable|tissue:early embryonic cell|biomaterial provider:Mueller lab University of Birmingham|replicate:2|BioSampleModel:Model organism or animal                 CAGE seq Prim Whole cell CAGE DCD003739SQ DCD003739SQ max read length:50     RNA-Seq TRANSCRIPTOMIC CAGE SINGLE ILLUMINA Illumina HiSeq 2500   SRP366491     CAGE-seq_Mueller_lab_0013AS.DCD003739SQ.USERdanio-user.R1.fastq.gz fastq 1372622736.0 28596307.0 CAGE seq Mueller lab 0013AS.DCD003739SQ.USERdanio user.R1.fastq.gz 0:48 1:0 A:306709302;C:373224967;G:360990874;T:331626639;N:70954 48 0     306709302 373224967 360990874 331626639 70954 SRX14647785 SRS12413212 SRA1393740 DANIO-CODE|Department for Biosciences and Nutrition DANIO-CODE DANIO-CODE 1 0.26574   0.02914   0.85113   0.52147   48   B   usable mapping rate illumina hiseq_era unknown cage unknown bulk unknown unknown   Unknown 2022-03-29 Pharyngula Embryo Embryo Imprecise All anatomical structures

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