run_metadata
2 rows where experiment.library_layout = "SINGLE", experiment.library_source = "TRANSCRIPTOMIC SINGLE CELL" and experiment.platform = "BGISEQ"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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
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");;