run_metadata
8 rows where experiment.platform = "ION_TORRENT" and tissue_curation_coarse = "Liver and Biliary System"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 62854 | 62854 | SRR13440556 | SRX9853978 | SRS8035408 | SRP301838 | PRJNA691414 | Transcriptomic analysis of GD treated zebrafish liver | PRJNA691414 | Other | Globin digest is a bioactive oligopeptide derived from porcine hemoglobin proteins. We orally administrated GD to diet induced zebrafish fish and performed RNA seq using the liver of zebrafish with or without xxx treatment. | Zebrafish liver from AB strain | GD DIO Zebrafish | strain:AB|age:3 month|sex:female|tissue:liver|disease:Obesity|BioSampleModel:Model organism or animal | RNA seq of Danio rerio: adult female liver | DIO GD 4 | DIO GD 4 | DIO with GD treatment | RNA-Seq | TRANSCRIPTOMIC | PCR | SINGLE | ION_TORRENT | Ion Torrent Proton | SRP301838 | DIO_GD-4 | fastq | 4457846127.0 | 35434325.0 | DIO GD 4 | 0:125.81 | A:1132283216;C:1070720177;G:1157322546;T:1097520188;N:0 | 125 | 1132283216 | 1070720177 | 1157322546 | 1097520188 | 0 | SRX9853978 | SRS8035408 | SRA1184195 | Mie University|Graduate School of Regional Innovation Studies | Mie University | 1 | 0.61358 | 0.13617 | 0.87896 | 0.27516 | 178 | B | usable mapping rate | ion_torrent | ion_torrent | unknown | random_priming | unknown | bulk | unknown | unknown | Japan | 2021-01-14 | Adult | Adult | Liver | Liver and Biliary System | |||||||||||||||||||||||||||
| 62855 | 62855 | SRR13440557 | SRX9853977 | SRS8035408 | SRP301838 | PRJNA691414 | Transcriptomic analysis of GD treated zebrafish liver | PRJNA691414 | Other | Globin digest is a bioactive oligopeptide derived from porcine hemoglobin proteins. We orally administrated GD to diet induced zebrafish fish and performed RNA seq using the liver of zebrafish with or without xxx treatment. | Zebrafish liver from AB strain | GD DIO Zebrafish | strain:AB|age:3 month|sex:female|tissue:liver|disease:Obesity|BioSampleModel:Model organism or animal | RNA seq of Danio rerio: adult female liver | DIO GD 3 | DIO GD 3 | DIO with GD treatment | RNA-Seq | TRANSCRIPTOMIC | PCR | SINGLE | ION_TORRENT | Ion Torrent Proton | SRP301838 | DIO_GD-3 | fastq | 2209140756.0 | 21626130.0 | DIO GD 3 | 0:102.15 | A:583812333;C:487262915;G:584943625;T:553121883;N:0 | 102 | 583812333 | 487262915 | 584943625 | 553121883 | 0 | SRX9853977 | SRS8035408 | SRA1184195 | Mie University|Graduate School of Regional Innovation Studies | Mie University | 1 | 0.63225 | 0.1658 | 0.86379 | 0.37214 | 92 | B | usable mapping rate | ion_torrent | ion_torrent | unknown | random_priming | unknown | bulk | unknown | unknown | Japan | 2021-01-14 | Adult | Adult | Liver | Liver and Biliary System | |||||||||||||||||||||||||||
| 62856 | 62856 | SRR13440558 | SRX9853976 | SRS8035408 | SRP301838 | PRJNA691414 | Transcriptomic analysis of GD treated zebrafish liver | PRJNA691414 | Other | Globin digest is a bioactive oligopeptide derived from porcine hemoglobin proteins. We orally administrated GD to diet induced zebrafish fish and performed RNA seq using the liver of zebrafish with or without xxx treatment. | Zebrafish liver from AB strain | GD DIO Zebrafish | strain:AB|age:3 month|sex:female|tissue:liver|disease:Obesity|BioSampleModel:Model organism or animal | RNA seq of Danio rerio: adult female liver | DIO GD 2 | DIO GD 2 | DIO with GD treatment | RNA-Seq | TRANSCRIPTOMIC | PCR | SINGLE | ION_TORRENT | Ion Torrent Proton | SRP301838 | DIO_GD-2 | fastq | 1777323103.0 | 18933651.0 | DIO GD 2 | 0:93.87 | A:464601836;C:413760770;G:460577599;T:438382898;N:0 | 93 | 464601836 | 413760770 | 460577599 | 438382898 | 0 | SRX9853976 | SRS8035408 | SRA1184195 | Mie University|Graduate School of Regional Innovation Studies | Mie University | 1 | 0.65849 | 0.15297 | 0.84135 | 0.3349 | 101 | B | usable mapping rate | ion_torrent | ion_torrent | unknown | random_priming | unknown | bulk | unknown | unknown | Japan | 2021-01-14 | Adult | Adult | Liver | Liver and Biliary System | |||||||||||||||||||||||||||
| 62857 | 62857 | SRR13440559 | SRX9853975 | SRS8035408 | SRP301838 | PRJNA691414 | Transcriptomic analysis of GD treated zebrafish liver | PRJNA691414 | Other | Globin digest is a bioactive oligopeptide derived from porcine hemoglobin proteins. We orally administrated GD to diet induced zebrafish fish and performed RNA seq using the liver of zebrafish with or without xxx treatment. | Zebrafish liver from AB strain | GD DIO Zebrafish | strain:AB|age:3 month|sex:female|tissue:liver|disease:Obesity|BioSampleModel:Model organism or animal | RNA seq of Danio rerio: adult female liver | DIO GD 1 | DIO GD 1 | DIO with GD treatment | RNA-Seq | TRANSCRIPTOMIC | PCR | SINGLE | ION_TORRENT | Ion Torrent Proton | SRP301838 | DIO_GD-1 | fastq | 3107066238.0 | 25095995.0 | DIO GD 1 | 0:123.81 | A:793240480;C:738189877;G:777063754;T:798572127;N:0 | 123 | 793240480 | 738189877 | 777063754 | 798572127 | 0 | SRX9853975 | SRS8035408 | SRA1184195 | Mie University|Graduate School of Regional Innovation Studies | Mie University | 1 | 0.7426 | 0.17704 | 0.89051 | 0.25099 | 52 | B | usable mapping rate | ion_torrent | ion_torrent | unknown | random_priming | unknown | bulk | unknown | unknown | Japan | 2021-01-14 | Adult | Adult | Liver | Liver and Biliary System | |||||||||||||||||||||||||||
| 62858 | 62858 | SRR13440560 | SRX9853974 | SRS8035408 | SRP301838 | PRJNA691414 | Transcriptomic analysis of GD treated zebrafish liver | PRJNA691414 | Other | Globin digest is a bioactive oligopeptide derived from porcine hemoglobin proteins. We orally administrated GD to diet induced zebrafish fish and performed RNA seq using the liver of zebrafish with or without xxx treatment. | Zebrafish liver from AB strain | GD DIO Zebrafish | strain:AB|age:3 month|sex:female|tissue:liver|disease:Obesity|BioSampleModel:Model organism or animal | RNA seq of Danio rerio: adult female liver | DIO 4 | DIO 4 | Diet incuced obesity DIO | RNA-Seq | TRANSCRIPTOMIC | PCR | SINGLE | ION_TORRENT | Ion Torrent Proton | SRP301838 | DIO-4 | fastq | 2329004075.0 | 20271175.0 | DIO 4 | 0:114.89 | A:567452533;C:570566957;G:621549245;T:569435340;N:0 | 114 | 567452533 | 570566957 | 621549245 | 569435340 | 0 | SRX9853974 | SRS8035408 | SRA1184195 | Mie University|Graduate School of Regional Innovation Studies | Mie University | 1 | 0.84548 | 0.27189 | 0.86198 | 0.45426 | 122 | B | usable mapping rate | ion_torrent | ion_torrent | unknown | random_priming | unknown | bulk | unknown | unknown | Japan | 2021-01-14 | Adult | Adult | Liver | Liver and Biliary System | |||||||||||||||||||||||||||
| 62859 | 62859 | SRR13440561 | SRX9853973 | SRS8035408 | SRP301838 | PRJNA691414 | Transcriptomic analysis of GD treated zebrafish liver | PRJNA691414 | Other | Globin digest is a bioactive oligopeptide derived from porcine hemoglobin proteins. We orally administrated GD to diet induced zebrafish fish and performed RNA seq using the liver of zebrafish with or without xxx treatment. | Zebrafish liver from AB strain | GD DIO Zebrafish | strain:AB|age:3 month|sex:female|tissue:liver|disease:Obesity|BioSampleModel:Model organism or animal | RNA seq of Danio rerio: adult female liver | DIO 3 | DIO 3 | Diet incuced obesity DIO | RNA-Seq | TRANSCRIPTOMIC | PCR | SINGLE | ION_TORRENT | Ion Torrent Proton | SRP301838 | DIO-3 | fastq | 2346162628.0 | 19400931.0 | DIO 3 | 0:120.93 | A:579812559;C:570332195;G:613738317;T:582279557;N:0 | 120 | 579812559 | 570332195 | 613738317 | 582279557 | 0 | SRX9853973 | SRS8035408 | SRA1184195 | Mie University|Graduate School of Regional Innovation Studies | Mie University | 1 | 0.78629 | 0.25304 | 0.89041 | 0.35231 | 150 | B | usable mapping rate | ion_torrent | ion_torrent | unknown | random_priming | unknown | bulk | unknown | unknown | Japan | 2021-01-14 | Adult | Adult | Liver | Liver and Biliary System | |||||||||||||||||||||||||||
| 62860 | 62860 | SRR13440562 | SRX9853972 | SRS8035408 | SRP301838 | PRJNA691414 | Transcriptomic analysis of GD treated zebrafish liver | PRJNA691414 | Other | Globin digest is a bioactive oligopeptide derived from porcine hemoglobin proteins. We orally administrated GD to diet induced zebrafish fish and performed RNA seq using the liver of zebrafish with or without xxx treatment. | Zebrafish liver from AB strain | GD DIO Zebrafish | strain:AB|age:3 month|sex:female|tissue:liver|disease:Obesity|BioSampleModel:Model organism or animal | RNA seq of Danio rerio: adult female liver | DIO 2 | DIO 2 | Diet incuced obesity DIO | RNA-Seq | TRANSCRIPTOMIC | PCR | SINGLE | ION_TORRENT | Ion Torrent Proton | SRP301838 | DIO-2 | fastq | 3553599859.0 | 32601495.0 | DIO 2 | 0:109.00 | A:888818483;C:851068166;G:947933039;T:865780171;N:0 | 109 | 888818483 | 851068166 | 947933039 | 865780171 | 0 | SRX9853972 | SRS8035408 | SRA1184195 | Mie University|Graduate School of Regional Innovation Studies | Mie University | 1 | 0.86167 | 0.31911 | 0.86206 | 0.66264 | 174 | B | usable mapping rate | ion_torrent | ion_torrent | unknown | random_priming | unknown | bulk | unknown | unknown | Japan | 2021-01-20 | Adult | Adult | Liver | Liver and Biliary System | |||||||||||||||||||||||||||
| 62861 | 62861 | SRR13440563 | SRX9853971 | SRS8035408 | SRP301838 | PRJNA691414 | Transcriptomic analysis of GD treated zebrafish liver | PRJNA691414 | Other | Globin digest is a bioactive oligopeptide derived from porcine hemoglobin proteins. We orally administrated GD to diet induced zebrafish fish and performed RNA seq using the liver of zebrafish with or without xxx treatment. | Zebrafish liver from AB strain | GD DIO Zebrafish | strain:AB|age:3 month|sex:female|tissue:liver|disease:Obesity|BioSampleModel:Model organism or animal | RNA seq of Danio rerio: adult female liver | DIO 1 | DIO 1 | Diet incuced obesity DIO | RNA-Seq | TRANSCRIPTOMIC | PCR | SINGLE | ION_TORRENT | Ion Torrent Proton | SRP301838 | DIO-1 | fastq | 2554201974.0 | 21594302.0 | DIO 1 | 0:118.28 | A:631716258;C:620459753;G:664379409;T:637646554;N:0 | 118 | 631716258 | 620459753 | 664379409 | 637646554 | 0 | SRX9853971 | SRS8035408 | SRA1184195 | Mie University|Graduate School of Regional Innovation Studies | Mie University | 1 | 0.77174 | 0.21322 | 0.89962 | 0.33158 | 240 | B | usable mapping rate | ion_torrent | ion_torrent | unknown | random_priming | unknown | bulk | unknown | unknown | Japan | 2021-01-20 | Adult | Adult | Liver | Liver and Biliary 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");;