run_metadata
6 rows where devstage_curation_coarse = "Multi-stage" and experiment.library_selection = "RACE"
This data as json, CSV (advanced)
| Link | rowid ▼ | run.accession | experiment.accession | sample.accession | study.accession | bioproject | study.title | study.alias | study.type | study.abstract | study.attributes | study.PMIDs | sample.description | sample.title | sample.alias | sample.centername | sample.attributes | GEOsample.title | GEOsample.dataprocessing | GEOsample.source | GEOsample.treatmentprotocol | GEOsample.extractprotocol | GEOsample.growthprotocol | GEOsample.characteristics | GEOsample.accession | experiment.title | experiment.alias | experiment.library_name | experiment.design_description | experiment.library_construction_protocol | experiment.attributes | experiment.library_strategy | experiment.library_source | experiment.library_selection | experiment.library_layout | experiment.platform | experiment.instrument_model | experiment.spot_descriptor | experiment.study_ref | run.title | run.attributes | run.filename | run.semantic_name | run.total_bases | run.total_spots | run.alias | run.read_lengths | run.base_counts | run.r1_length | run.r2_length | run.r3_length | run.r4_length | run.Acount | run.Ccount | run.Gcount | run.Tcount | run.Ncount | run.experiment | run.pool_member | submission.accession | submission.srasource | submission.bioprojectsource | seqdetective.n_mates | seqdetective.mapping_rate.mate1 | seqdetective.mapping_rate.mate2 | seqdetective.nofeature_rate.mate1 | seqdetective.nofeature_rate.mate2 | seqdetective.sparsity.mate1 | seqdetective.sparsity.mate2 | seqdetective.pos_strand_rate.mate1 | seqdetective.pos_strand_rate.mate2 | seqdetective.readlen.mate1 | seqdetective.readlen.mate2 | seqdetective.judgement.mate1 | seqdetective.judgement.mate2 | seqdetective.judgement.reason | platform_family | instrument_generation | read_bias | selection_class | prep_kit | sc_or_bulk | tech_class | technology | tech_variant | submission.bioprojectsource.country | earliest_date | devstage_curation | devstage_curation_coarse | tissue_curation | tissue_curation_coarse |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10141 | 10141 | ERR4973564 | ERX4792138 | ERS5459722 | ERP125703 | PRJEB41864 | three prime mRNA seq of sfpq / zebrafish embryos and siblings at 24 hpf | E-MTAB-9899 | Transcriptome Analysis | mRNA was purified from whole zebrafish embryos at 24 hpf and three prime proximal region was sequenced. | ENA FIRST PUBLIC:2021 01 27|ENA LAST UPDATE:2020 12 10 | Protocols: Embryos were collected from in crosses of sfpq+/ adult zebrafish RNA was extracted using the RNEasy Mini Kit Qiagen Library was generated using Lexogen's QuantSeq three prime mRNA Seq Library Prep Kit FWD for Illumina | sibling 3 | SAMEA7703213 | Centre for Developmental Neurobiology King's College London | ENA first public:2021 01 27|ENA last update:2020 12 10|External Id:SAMEA7703213|INSDC center alias:Centre for Developmental Neurobiology King's College London|INSDC center name:Centre for Developmental Neurobiology King's College London|INSDC first public:2021 01 27T17:06:57Z|INSDC last update:2020 12 10T17:23:32Z|INSDC status:public|Submitter Id:E MTAB 9899:sibling 3|age:24|broker name:ArrayExpress|common name:zebrafish|developmental stage:embryo stage|genotype:wild type genotype|organism part:whole organism|sample name:E MTAB 9899:sibling 3 | NextSeq 500 sequencing; 3 prime mRNA seq of sfpq / zebrafish embryos and siblings at 24 hpf | E MTAB 9899:sibling 3 s | sibling 3 s | three prime mRNA seq of sfpq / zebrafish embryos and siblings at 24 hpf | Embryos were collected from in crosses of sfpq+/ adult zebrafish RNA was extracted using the RNEasy Mini Kit Qiagen Library was generated using Lexogen's QuantSeq three prime mRNA Seq Library Prep Kit FWD for Illumina | Experimental Factor: genotype:wild type genotype | RNA-Seq | TRANSCRIPTOMIC | RACE | SINGLE | ILLUMINA | NextSeq 500 | ERP125703 | NextSeq 500 sequencing; three prime mRNA seq of sfpq / zebrafish embryos and siblings at 24 hpf | ENA FIRST PUBLIC:2021 01 27|ENA LAST UPDATE:2020 12 10 | 70_AACCGA_70_ACTAGC_S2_R1_001.fastq.gz | fastq | E MTAB 9899:sibling 3 | 0:76 1:0 | A:385382600;C:210104151;G:238678838;T:315495923;N:5536 | 76 | 0 | 385382600 | 210104151 | 238678838 | 315495923 | 5536 | ERX4792138 | ERS5459722 | ERA3194022 | Centre for Developmental Neurobiology King | Centre for Developmental Neurobiology King | 1 | 0.82613 | 0.13111 | 0.77597 | 0.53833 | 76 | B | usable mapping rate | illumina | nextseq | 3prime | other | lexogen | bulk | unknown | unknown | United Kingdom | 2020-12-10 | Multi-stage | Multi-stage | Whole Organism | All anatomical structures | |||||||||||||||||||||
| 10142 | 10142 | ERR4973563 | ERX4792137 | ERS5459721 | ERP125703 | PRJEB41864 | three prime mRNA seq of sfpq / zebrafish embryos and siblings at 24 hpf | E-MTAB-9899 | Transcriptome Analysis | mRNA was purified from whole zebrafish embryos at 24 hpf and three prime proximal region was sequenced. | ENA FIRST PUBLIC:2021 01 27|ENA LAST UPDATE:2020 12 10 | Protocols: Embryos were collected from in crosses of sfpq+/ adult zebrafish RNA was extracted using the RNEasy Mini Kit Qiagen Library was generated using Lexogen's QuantSeq three prime mRNA Seq Library Prep Kit FWD for Illumina | sibling 2 | SAMEA7703212 | Centre for Developmental Neurobiology King's College London | ENA first public:2021 01 27|ENA last update:2020 12 10|External Id:SAMEA7703212|INSDC center alias:Centre for Developmental Neurobiology King's College London|INSDC center name:Centre for Developmental Neurobiology King's College London|INSDC first public:2021 01 27T17:06:57Z|INSDC last update:2020 12 10T17:23:32Z|INSDC status:public|Submitter Id:E MTAB 9899:sibling 2|age:24|broker name:ArrayExpress|common name:zebrafish|developmental stage:embryo stage|genotype:wild type genotype|organism part:whole organism|sample name:E MTAB 9899:sibling 2 | NextSeq 500 sequencing; 3 prime mRNA seq of sfpq / zebrafish embryos and siblings at 24 hpf | E MTAB 9899:sibling 2 s | sibling 2 s | three prime mRNA seq of sfpq / zebrafish embryos and siblings at 24 hpf | Embryos were collected from in crosses of sfpq+/ adult zebrafish RNA was extracted using the RNEasy Mini Kit Qiagen Library was generated using Lexogen's QuantSeq three prime mRNA Seq Library Prep Kit FWD for Illumina | Experimental Factor: genotype:wild type genotype | RNA-Seq | TRANSCRIPTOMIC | RACE | SINGLE | ILLUMINA | NextSeq 500 | ERP125703 | NextSeq 500 sequencing; three prime mRNA seq of sfpq / zebrafish embryos and siblings at 24 hpf | ENA FIRST PUBLIC:2021 01 27|ENA LAST UPDATE:2020 12 10 | 69_AGTTGA_69_CTTACA_S7_R1_001.fastq.gz | fastq | E MTAB 9899:sibling 2 | 0:76 1:0 | A:405337161;C:226099266;G:255734601;T:341120121;N:5955 | 76 | 0 | 405337161 | 226099266 | 255734601 | 341120121 | 5955 | ERX4792137 | ERS5459721 | ERA3194022 | Centre for Developmental Neurobiology King | Centre for Developmental Neurobiology King | 1 | 0.84066 | 0.12241 | 0.77755 | 0.56472 | 76 | B | usable mapping rate | illumina | nextseq | 3prime | other | lexogen | bulk | unknown | unknown | United Kingdom | 2020-12-10 | Multi-stage | Multi-stage | Whole Organism | All anatomical structures | |||||||||||||||||||||
| 10143 | 10143 | ERR4973562 | ERX4792136 | ERS5459720 | ERP125703 | PRJEB41864 | three prime mRNA seq of sfpq / zebrafish embryos and siblings at 24 hpf | E-MTAB-9899 | Transcriptome Analysis | mRNA was purified from whole zebrafish embryos at 24 hpf and three prime proximal region was sequenced. | ENA FIRST PUBLIC:2021 01 27|ENA LAST UPDATE:2020 12 10 | Protocols: Embryos were collected from in crosses of sfpq+/ adult zebrafish RNA was extracted using the RNEasy Mini Kit Qiagen Library was generated using Lexogen's QuantSeq three prime mRNA Seq Library Prep Kit FWD for Illumina | sibling 1 | SAMEA7703211 | Centre for Developmental Neurobiology King's College London | ENA first public:2021 01 27|ENA last update:2020 12 10|External Id:SAMEA7703211|INSDC center alias:Centre for Developmental Neurobiology King's College London|INSDC center name:Centre for Developmental Neurobiology King's College London|INSDC first public:2021 01 27T17:06:57Z|INSDC last update:2020 12 10T17:23:32Z|INSDC status:public|Submitter Id:E MTAB 9899:sibling 1|age:24|broker name:ArrayExpress|common name:zebrafish|developmental stage:embryo stage|genotype:wild type genotype|organism part:whole organism|sample name:E MTAB 9899:sibling 1 | NextSeq 500 sequencing; 3 prime mRNA seq of sfpq / zebrafish embryos and siblings at 24 hpf | E MTAB 9899:sibling 1 s | sibling 1 s | three prime mRNA seq of sfpq / zebrafish embryos and siblings at 24 hpf | Embryos were collected from in crosses of sfpq+/ adult zebrafish RNA was extracted using the RNEasy Mini Kit Qiagen Library was generated using Lexogen's QuantSeq three prime mRNA Seq Library Prep Kit FWD for Illumina | Experimental Factor: genotype:wild type genotype | RNA-Seq | TRANSCRIPTOMIC | RACE | SINGLE | ILLUMINA | NextSeq 500 | ERP125703 | NextSeq 500 sequencing; three prime mRNA seq of sfpq / zebrafish embryos and siblings at 24 hpf | ENA FIRST PUBLIC:2021 01 27|ENA LAST UPDATE:2020 12 10 | 68_CCAATT_68_GTCCCG_S11_R1_001.fastq.gz | fastq | E MTAB 9899:sibling 1 | 0:76 1:0 | A:440539801;C:236835299;G:268057277;T:355636994;N:6169 | 76 | 0 | 440539801 | 236835299 | 268057277 | 355636994 | 6169 | ERX4792136 | ERS5459720 | ERA3194022 | Centre for Developmental Neurobiology King | Centre for Developmental Neurobiology King | 1 | 0.82002 | 0.12908 | 0.77766 | 0.54981 | 76 | B | usable mapping rate | illumina | nextseq | 3prime | other | lexogen | bulk | unknown | unknown | United Kingdom | 2020-12-10 | Multi-stage | Multi-stage | Whole Organism | All anatomical structures | |||||||||||||||||||||
| 10144 | 10144 | ERR4973561 | ERX4792135 | ERS5459719 | ERP125703 | PRJEB41864 | three prime mRNA seq of sfpq / zebrafish embryos and siblings at 24 hpf | E-MTAB-9899 | Transcriptome Analysis | mRNA was purified from whole zebrafish embryos at 24 hpf and three prime proximal region was sequenced. | ENA FIRST PUBLIC:2021 01 27|ENA LAST UPDATE:2020 12 10 | Protocols: Embryos were collected from in crosses of sfpq+/ adult zebrafish RNA was extracted using the RNEasy Mini Kit Qiagen Library was generated using Lexogen's QuantSeq three prime mRNA Seq Library Prep Kit FWD for Illumina | sfpq 3 | SAMEA7703210 | Centre for Developmental Neurobiology King's College London | ENA first public:2021 01 27|ENA last update:2020 12 10|External Id:SAMEA7703210|INSDC center alias:Centre for Developmental Neurobiology King's College London|INSDC center name:Centre for Developmental Neurobiology King's College London|INSDC first public:2021 01 27T17:06:57Z|INSDC last update:2020 12 10T17:23:32Z|INSDC status:public|Submitter Id:E MTAB 9899:sfpq 3|age:24|broker name:ArrayExpress|common name:zebrafish|developmental stage:embryo stage|genotype:sfpq / |organism part:whole organism|sample name:E MTAB 9899:sfpq 3 | NextSeq 500 sequencing; 3 prime mRNA seq of sfpq / zebrafish embryos and siblings at 24 hpf | E MTAB 9899:sfpq 3 s | sfpq 3 s | three prime mRNA seq of sfpq / zebrafish embryos and siblings at 24 hpf | Embryos were collected from in crosses of sfpq+/ adult zebrafish RNA was extracted using the RNEasy Mini Kit Qiagen Library was generated using Lexogen's QuantSeq three prime mRNA Seq Library Prep Kit FWD for Illumina | Experimental Factor: genotype:sfpq / | RNA-Seq | TRANSCRIPTOMIC | RACE | SINGLE | ILLUMINA | NextSeq 500 | ERP125703 | NextSeq 500 sequencing; three prime mRNA seq of sfpq / zebrafish embryos and siblings at 24 hpf | ENA FIRST PUBLIC:2021 01 27|ENA LAST UPDATE:2020 12 10 | 67_TCGTTC_67_TGCTAT_S22_R1_001.fastq.gz | fastq | E MTAB 9899:sfpq 3 | 0:76 1:0 | A:493165327;C:268347233;G:303443918;T:399152596;N:7138 | 76 | 0 | 493165327 | 268347233 | 303443918 | 399152596 | 7138 | ERX4792135 | ERS5459719 | ERA3194022 | Centre for Developmental Neurobiology King | Centre for Developmental Neurobiology King | 1 | 0.82521 | 0.12349 | 0.78545 | 0.57446 | 76 | B | usable mapping rate | illumina | nextseq | 3prime | other | lexogen | bulk | unknown | unknown | United Kingdom | 2020-12-10 | Multi-stage | Multi-stage | Whole Organism | All anatomical structures | |||||||||||||||||||||
| 10145 | 10145 | ERR4973560 | ERX4792134 | ERS5459718 | ERP125703 | PRJEB41864 | three prime mRNA seq of sfpq / zebrafish embryos and siblings at 24 hpf | E-MTAB-9899 | Transcriptome Analysis | mRNA was purified from whole zebrafish embryos at 24 hpf and three prime proximal region was sequenced. | ENA FIRST PUBLIC:2021 01 27|ENA LAST UPDATE:2020 12 10 | Protocols: Embryos were collected from in crosses of sfpq+/ adult zebrafish RNA was extracted using the RNEasy Mini Kit Qiagen Library was generated using Lexogen's QuantSeq three prime mRNA Seq Library Prep Kit FWD for Illumina | sfpq 2 | SAMEA7703209 | Centre for Developmental Neurobiology King's College London | ENA first public:2021 01 27|ENA last update:2020 12 10|External Id:SAMEA7703209|INSDC center alias:Centre for Developmental Neurobiology King's College London|INSDC center name:Centre for Developmental Neurobiology King's College London|INSDC first public:2021 01 27T17:06:57Z|INSDC last update:2020 12 10T17:23:32Z|INSDC status:public|Submitter Id:E MTAB 9899:sfpq 2|age:24|broker name:ArrayExpress|common name:zebrafish|developmental stage:embryo stage|genotype:sfpq / |organism part:whole organism|sample name:E MTAB 9899:sfpq 2 | NextSeq 500 sequencing; 3 prime mRNA seq of sfpq / zebrafish embryos and siblings at 24 hpf | E MTAB 9899:sfpq 2 s | sfpq 2 s | three prime mRNA seq of sfpq / zebrafish embryos and siblings at 24 hpf | Embryos were collected from in crosses of sfpq+/ adult zebrafish RNA was extracted using the RNEasy Mini Kit Qiagen Library was generated using Lexogen's QuantSeq three prime mRNA Seq Library Prep Kit FWD for Illumina | Experimental Factor: genotype:sfpq / | RNA-Seq | TRANSCRIPTOMIC | RACE | SINGLE | ILLUMINA | NextSeq 500 | ERP125703 | NextSeq 500 sequencing; three prime mRNA seq of sfpq / zebrafish embryos and siblings at 24 hpf | ENA FIRST PUBLIC:2021 01 27|ENA LAST UPDATE:2020 12 10 | 66_GACGAT_66_TCAGTC_S18_R1_001.fastq.gz | fastq | E MTAB 9899:sfpq 2 | 0:76 1:0 | A:426637005;C:227027693;G:257342561;T:338159540;N:5909 | 76 | 0 | 426637005 | 227027693 | 257342561 | 338159540 | 5909 | ERX4792134 | ERS5459718 | ERA3194022 | Centre for Developmental Neurobiology King | Centre for Developmental Neurobiology King | 1 | 0.81933 | 0.11571 | 0.78593 | 0.56675 | 76 | B | usable mapping rate | illumina | nextseq | 3prime | other | lexogen | bulk | unknown | unknown | United Kingdom | 2020-12-10 | Multi-stage | Multi-stage | Whole Organism | All anatomical structures | |||||||||||||||||||||
| 10146 | 10146 | ERR4973559 | ERX4792133 | ERS5459717 | ERP125703 | PRJEB41864 | three prime mRNA seq of sfpq / zebrafish embryos and siblings at 24 hpf | E-MTAB-9899 | Transcriptome Analysis | mRNA was purified from whole zebrafish embryos at 24 hpf and three prime proximal region was sequenced. | ENA FIRST PUBLIC:2021 01 27|ENA LAST UPDATE:2020 12 10 | Protocols: Embryos were collected from in crosses of sfpq+/ adult zebrafish RNA was extracted using the RNEasy Mini Kit Qiagen Library was generated using Lexogen's QuantSeq three prime mRNA Seq Library Prep Kit FWD for Illumina | sfpq 1 | SAMEA7703208 | Centre for Developmental Neurobiology King's College London | ENA first public:2021 01 27|ENA last update:2020 12 10|External Id:SAMEA7703208|INSDC center alias:Centre for Developmental Neurobiology King's College London|INSDC center name:Centre for Developmental Neurobiology King's College London|INSDC first public:2021 01 27T17:06:57Z|INSDC last update:2020 12 10T17:23:32Z|INSDC status:public|Submitter Id:E MTAB 9899:sfpq 1|age:24|broker name:ArrayExpress|common name:zebrafish|developmental stage:embryo stage|genotype:sfpq / |organism part:whole organism|sample name:E MTAB 9899:sfpq 1 | NextSeq 500 sequencing; 3 prime mRNA seq of sfpq / zebrafish embryos and siblings at 24 hpf | E MTAB 9899:sfpq 1 s | sfpq 1 s | three prime mRNA seq of sfpq / zebrafish embryos and siblings at 24 hpf | Embryos were collected from in crosses of sfpq+/ adult zebrafish RNA was extracted using the RNEasy Mini Kit Qiagen Library was generated using Lexogen's QuantSeq three prime mRNA Seq Library Prep Kit FWD for Illumina | Experimental Factor: genotype:sfpq / | RNA-Seq | TRANSCRIPTOMIC | RACE | SINGLE | ILLUMINA | NextSeq 500 | ERP125703 | NextSeq 500 sequencing; three prime mRNA seq of sfpq / zebrafish embryos and siblings at 24 hpf | ENA FIRST PUBLIC:2021 01 27|ENA LAST UPDATE:2020 12 10 | 65_AAGCTC_65_AAGAAG_S3_R1_001.fastq.gz | fastq | E MTAB 9899:sfpq 1 | 0:76 1:0 | A:425613638;C:225707961;G:254738302;T:336863560;N:5847 | 76 | 0 | 425613638 | 225707961 | 254738302 | 336863560 | 5847 | ERX4792133 | ERS5459717 | ERA3194022 | Centre for Developmental Neurobiology King | Centre for Developmental Neurobiology King | 1 | 0.81857 | 0.11342 | 0.78587 | 0.56439 | 76 | B | usable mapping rate | illumina | nextseq | 3prime | other | lexogen | bulk | unknown | unknown | United Kingdom | 2020-12-10 | Multi-stage | Multi-stage | Whole Organism | All anatomical structures |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE run_metadata("run.accession" VARCHAR, "experiment.accession" VARCHAR, "sample.accession" VARCHAR, "study.accession" VARCHAR, bioproject VARCHAR, "study.title" VARCHAR, "study.alias" VARCHAR, "study.type" VARCHAR, "study.abstract" VARCHAR, "study.attributes" VARCHAR, "study.PMIDs" VARCHAR, "sample.description" VARCHAR, "sample.title" VARCHAR, "sample.alias" VARCHAR, "sample.centername" VARCHAR, "sample.attributes" VARCHAR, "GEOsample.title" VARCHAR, "GEOsample.dataprocessing" VARCHAR, "GEOsample.source" VARCHAR, "GEOsample.treatmentprotocol" VARCHAR, "GEOsample.extractprotocol" VARCHAR, "GEOsample.growthprotocol" VARCHAR, "GEOsample.characteristics" VARCHAR, "GEOsample.accession" VARCHAR, "experiment.title" VARCHAR, "experiment.alias" VARCHAR, "experiment.library_name" VARCHAR, "experiment.design_description" VARCHAR, "experiment.library_construction_protocol" VARCHAR, "experiment.attributes" VARCHAR, "experiment.library_strategy" VARCHAR, "experiment.library_source" VARCHAR, "experiment.library_selection" VARCHAR, "experiment.library_layout" VARCHAR, "experiment.platform" VARCHAR, "experiment.instrument_model" VARCHAR, "experiment.spot_descriptor" VARCHAR, "experiment.study_ref" VARCHAR, "run.title" VARCHAR, "run.attributes" VARCHAR, "run.filename" VARCHAR, "run.semantic_name" VARCHAR, "run.total_bases" DOUBLE, "run.total_spots" DOUBLE, "run.alias" VARCHAR, "run.read_lengths" VARCHAR, "run.base_counts" VARCHAR, "run.r1_length" BIGINT, "run.r2_length" BIGINT, "run.r3_length" BIGINT, "run.r4_length" BIGINT, "run.Acount" BIGINT, "run.Ccount" BIGINT, "run.Gcount" BIGINT, "run.Tcount" BIGINT, "run.Ncount" BIGINT, "run.experiment" VARCHAR, "run.pool_member" VARCHAR, "submission.accession" VARCHAR, "submission.srasource" VARCHAR, "submission.bioprojectsource" VARCHAR, "seqdetective.n_mates" BIGINT, "seqdetective.mapping_rate.mate1" DOUBLE, "seqdetective.mapping_rate.mate2" DOUBLE, "seqdetective.nofeature_rate.mate1" DOUBLE, "seqdetective.nofeature_rate.mate2" DOUBLE, "seqdetective.sparsity.mate1" DOUBLE, "seqdetective.sparsity.mate2" DOUBLE, "seqdetective.pos_strand_rate.mate1" DOUBLE, "seqdetective.pos_strand_rate.mate2" DOUBLE, "seqdetective.readlen.mate1" BIGINT, "seqdetective.readlen.mate2" BIGINT, "seqdetective.judgement.mate1" VARCHAR, "seqdetective.judgement.mate2" VARCHAR, "seqdetective.judgement.reason" VARCHAR, platform_family VARCHAR, instrument_generation VARCHAR, read_bias VARCHAR, selection_class VARCHAR, prep_kit VARCHAR, sc_or_bulk VARCHAR, tech_class VARCHAR, technology VARCHAR, tech_variant VARCHAR, "submission.bioprojectsource.country" VARCHAR, earliest_date DATE, devstage_curation VARCHAR, devstage_curation_coarse VARCHAR, tissue_curation VARCHAR, tissue_curation_coarse VARCHAR);;
CREATE INDEX idx_run_bioproject ON run_metadata(bioproject);;
CREATE INDEX idx_run_run_accession ON run_metadata("run.accession");;