run_metadata
6 rows where experiment.library_selection = "other", experiment.platform = "BGISEQ" and technology = "unknown"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 52210 | 52210 | SRR9021058 | SRX5799154 | SRS4730324 | SRP195685 | PRJNA541367 | Global transcriptomic analysis of zebrafish glucagon receptor mutant | PRJNA541367 | Other | We performed RNA sequencing RNA seq analysis of whole fish to provide a comprehensive view of its global transcriptomic regulation in this study. | WT 1 | replicate:biological replicate 1|strain:AB|age:7 days|sex:not applicable|tissue:total|BioSampleModel:Model organism or animal | Diano rerio transcriptome | WT 1 20190506 1 | WT 1 20190506 1 | RNA seq of WT Diano rerio | RNA-Seq | TRANSCRIPTOMIC | other | SINGLE | BGISEQ | BGISEQ-500 | SRP195685 | loader:fastq load.py | WT1.1.fq | fastq | 1094498950.0 | 21889979.0 | WT1.1.fq | 0:50 | A:291195764;C:255539280;G:262638316;T:284737693;N:387897 | 50 | 291195764 | 255539280 | 262638316 | 284737693 | 387897 | SRX5799154 | SRS4730324 | SRA883435 | Xiamen University|School of Pharmaceutical Sciences | Xiamen University | 1 | 0.94195 | 0.09713 | 0.66689 | 0.47749 | 50 | B | usable mapping rate | bgi | bgi | unknown | random_priming | unknown | bulk | unknown | unknown | China | 2020-01-18 | Larval | Larval | Undetermined | Undetermined | |||||||||||||||||||||||||||
| 52211 | 52211 | SRR9021059 | SRX5799153 | SRS4730323 | SRP195685 | PRJNA541367 | Global transcriptomic analysis of zebrafish glucagon receptor mutant | PRJNA541367 | Other | We performed RNA sequencing RNA seq analysis of whole fish to provide a comprehensive view of its global transcriptomic regulation in this study. | WT 2 | replicate:biological replicate 2|strain:AB|age:7 days|sex:not applicable|tissue:total|BioSampleModel:Model organism or animal | Diano rerio transcriptome | WT 2 20190506 2 | WT 2 20190506 2 | RNA seq of WT Diano rerio | RNA-Seq | TRANSCRIPTOMIC | other | SINGLE | BGISEQ | BGISEQ-500 | SRP195685 | loader:fastq load.py | WT2.1.fq | fastq | 1095133200.0 | 21902664.0 | WT2.1.fq | 0:50 | A:290594757;C:255644044;G:259681140;T:288014102;N:1199157 | 50 | 290594757 | 255644044 | 259681140 | 288014102 | 1199157 | SRX5799153 | SRS4730323 | SRA883435 | Xiamen University|School of Pharmaceutical Sciences | Xiamen University | 1 | 0.93368 | 0.09166 | 0.67085 | 0.46523 | 50 | B | usable mapping rate | bgi | bgi | unknown | random_priming | unknown | bulk | unknown | unknown | China | 2020-01-18 | Larval | Larval | Undetermined | Undetermined | |||||||||||||||||||||||||||
| 52212 | 52212 | SRR9021060 | SRX5799152 | SRS4730322 | SRP195685 | PRJNA541367 | Global transcriptomic analysis of zebrafish glucagon receptor mutant | PRJNA541367 | Other | We performed RNA sequencing RNA seq analysis of whole fish to provide a comprehensive view of its global transcriptomic regulation in this study. | WT 3 | replicate:biological replicate 3|strain:AB|age:7 days|sex:not applicable|tissue:total|BioSampleModel:Model organism or animal | Diano rerio transcriptome | WT 3 20190506 3 | WT 3 20190506 3 | RNA seq of WT Diano rerio | RNA-Seq | TRANSCRIPTOMIC | other | SINGLE | BGISEQ | BGISEQ-500 | SRP195685 | loader:fastq load.py | WT3.1.fq | fastq | 1096083900.0 | 21921678.0 | WT3.1.fq | 0:50 | A:290332094;C:256993500;G:263043956;T:285349722;N:364628 | 50 | 290332094 | 256993500 | 263043956 | 285349722 | 364628 | SRX5799152 | SRS4730322 | SRA883435 | Xiamen University|School of Pharmaceutical Sciences | Xiamen University | 1 | 0.94147 | 0.10157 | 0.66135 | 0.47301 | 50 | B | usable mapping rate | bgi | bgi | unknown | random_priming | unknown | bulk | unknown | unknown | China | 2020-01-18 | Larval | Larval | Undetermined | Undetermined | |||||||||||||||||||||||||||
| 52213 | 52213 | SRR9021061 | SRX5799151 | SRS4730320 | SRP195685 | PRJNA541367 | Global transcriptomic analysis of zebrafish glucagon receptor mutant | PRJNA541367 | Other | We performed RNA sequencing RNA seq analysis of whole fish to provide a comprehensive view of its global transcriptomic regulation in this study. | gcgr 1 | replicate:biological replicate 1|strain:AB|age:7 days|sex:not applicable|tissue:total|BioSampleModel:Model organism or animal | Diano rerio transcriptome | gcgr 1 20190506 1 | gcgr 1 20190506 1 | RNA seq of Diano rerio with gcgr mutant | RNA-Seq | TRANSCRIPTOMIC | other | SINGLE | BGISEQ | BGISEQ-500 | SRP195685 | loader:fastq load.py | gcgr1.1.fq | fastq | 1096307200.0 | 21926144.0 | gcgr1.1.fq | 0:50 | A:288839446;C:258297625;G:264630675;T:284199738;N:339716 | 50 | 288839446 | 258297625 | 264630675 | 284199738 | 339716 | SRX5799151 | SRS4730320 | SRA883435 | Xiamen University|School of Pharmaceutical Sciences | Xiamen University | 1 | 0.94131 | 0.09307 | 0.67574 | 0.46993 | 50 | B | usable mapping rate | bgi | bgi | unknown | random_priming | unknown | bulk | unknown | unknown | China | 2020-01-18 | Larval | Larval | Undetermined | Undetermined | |||||||||||||||||||||||||||
| 52214 | 52214 | SRR9021062 | SRX5799150 | SRS4730321 | SRP195685 | PRJNA541367 | Global transcriptomic analysis of zebrafish glucagon receptor mutant | PRJNA541367 | Other | We performed RNA sequencing RNA seq analysis of whole fish to provide a comprehensive view of its global transcriptomic regulation in this study. | gcgr 2 | replicate:biological replicate 2|strain:AB|age:7 days|sex:not applicable|tissue:total|BioSampleModel:Model organism or animal | Diano rerio transcriptome | gcgr 2 20190506 2 | gcgr 2 20190506 2 | RNA seq of Diano rerio with gcgr mutant | RNA-Seq | TRANSCRIPTOMIC | other | SINGLE | BGISEQ | BGISEQ-500 | SRP195685 | loader:fastq load.py | gcgr2.1.fq | fastq | 1094410100.0 | 21888202.0 | gcgr2.1.fq | 0:50 | A:290062779;C:256358687;G:264488431;T:282812212;N:687991 | 50 | 290062779 | 256358687 | 264488431 | 282812212 | 687991 | SRX5799150 | SRS4730321 | SRA883435 | Xiamen University|School of Pharmaceutical Sciences | Xiamen University | 1 | 0.94074 | 0.09337 | 0.67633 | 0.46861 | 50 | B | usable mapping rate | bgi | bgi | unknown | random_priming | unknown | bulk | unknown | unknown | China | 2020-01-18 | Larval | Larval | Undetermined | Undetermined | |||||||||||||||||||||||||||
| 52215 | 52215 | SRR9021063 | SRX5799149 | SRS4730319 | SRP195685 | PRJNA541367 | Global transcriptomic analysis of zebrafish glucagon receptor mutant | PRJNA541367 | Other | We performed RNA sequencing RNA seq analysis of whole fish to provide a comprehensive view of its global transcriptomic regulation in this study. | gcgr 3 | replicate:biological replicate 3|strain:AB|age:7 days|sex:not applicable|tissue:total|BioSampleModel:Model organism or animal | Diano rerio transcriptome | gcgr 3 20190506 3 | gcgr 3 20190506 3 | RNA seq of Diano rerio with gcgr mutant | RNA-Seq | TRANSCRIPTOMIC | other | SINGLE | BGISEQ | BGISEQ-500 | SRP195685 | loader:fastq load.py | gcgr3.1.fq | fastq | 1094284800.0 | 21885696.0 | gcgr3.1.fq | 0:50 | A:289313514;C:257096636;G:264011408;T:283143600;N:719642 | 50 | 289313514 | 257096636 | 264011408 | 283143600 | 719642 | SRX5799149 | SRS4730319 | SRA883435 | Xiamen University|School of Pharmaceutical Sciences | Xiamen University | 1 | 0.94222 | 0.09557 | 0.67521 | 0.46664 | 50 | B | usable mapping rate | bgi | bgi | unknown | random_priming | unknown | bulk | unknown | unknown | China | 2020-01-18 | Larval | Larval | Undetermined | Undetermined |
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");;