RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

run_metadata

18 rows where experiment.library_selection = "PCR", tissue_curation = "Gill" and tissue_curation_coarse = "Respiratory System"

✎ View and edit SQL

This data as json, CSV (advanced)

tissue_curation_coarse 1

  • Respiratory System · 18 ✖

tissue_curation 1

  • Gill · 18 ✖

technology 1

experiment.platform 1

experiment.library_strategy 1

experiment.library_source 1

experiment.library_selection 1

  • PCR · 18 ✖

experiment.library_layout 1

devstage_curation_coarse 1

devstage_curation 1

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
30673 30673 SRR28233239 SRX23844453 SRS20664879 SRP493528 PRJNA1084193 Knockout transcriptome sequencing of TRPA1b gene in zebrafish PRJNA1084193 Other WT and KO were sampled at the critical and half death time of room temperature and high temperature treatment respectively.         A1b01   strain:TRPA1b KO1|age:4mpf|dev stage:adult|collection date:2024 01 20|geo loc name:China|sex:male|tissue:gill|BioSampleModel:Model organism or animal                 A1b01 A1b01 A1b01 ribonucleic acid     RNA-Seq TRANSCRIPTOMIC PCR PAIRED ILLUMINA Illumina NovaSeq X Plus   SRP493528     A1b-S1_1.fq.gz A1b-S1_2.fq.gz fastq fastq 10214044500.0 34046815.0 A1b S1 1.fq.gz 0:150 1:150 A:2826731317;C:2254770618;G:2368382524;T:2764027721;N:132320 150 150     2826731317 2254770618 2368382524 2764027721 132320 SRX23844453 SRS20664879 SRA1818205 Shanghai Ocean University|College of Aquaculture and Life Sciences Shanghai Ocean University                       B B biological fallback assumption illumina novaseq_era unknown random_priming unknown bulk unknown unknown   China 2024-03-06 Adult Adult Gill Respiratory System
30674 30674 SRR28233240 SRX23844452 SRS20664878 SRP493528 PRJNA1084193 Knockout transcriptome sequencing of TRPA1b gene in zebrafish PRJNA1084193 Other WT and KO were sampled at the critical and half death time of room temperature and high temperature treatment respectively.         WT23   strain:WT9|age:4mpf|dev stage:adult|collection date:2024 01 20|geo loc name:China|sex:male|tissue:gill|BioSampleModel:Model organism or animal                 WT23 WT23 WT23 ribonucleic acid     RNA-Seq TRANSCRIPTOMIC PCR PAIRED ILLUMINA Illumina NovaSeq X Plus   SRP493528     WT-2-3_R1.fq.gz WT-2-3_R2.fq.gz fastq fastq 6168655800.0 20562186.0 WT 2 3 R1.fq.gz 0:150 1:150 A:1556231017;C:1526432275;G:1545153210;T:1540414611;N:424687 150 150     1556231017 1526432275 1545153210 1540414611 424687 SRX23844452 SRS20664878 SRA1818205 Shanghai Ocean University|College of Aquaculture and Life Sciences Shanghai Ocean University                       B B biological fallback assumption illumina novaseq_era unknown random_priming unknown bulk unknown unknown   China 2024-03-06 Adult Adult Gill Respiratory System
30675 30675 SRR28233241 SRX23844451 SRS20664877 SRP493528 PRJNA1084193 Knockout transcriptome sequencing of TRPA1b gene in zebrafish PRJNA1084193 Other WT and KO were sampled at the critical and half death time of room temperature and high temperature treatment respectively.         WT22   strain:WT8|age:4mpf|dev stage:adult|collection date:2024 01 20|geo loc name:China|sex:male|tissue:gill|BioSampleModel:Model organism or animal                 WT22 WT22 WT22 ribonucleic acid     RNA-Seq TRANSCRIPTOMIC PCR PAIRED ILLUMINA Illumina NovaSeq X Plus   SRP493528     WT-2-2_R1.fq.gz WT-2-2_R2.fq.gz fastq fastq 6503274900.0 21677583.0 WT 2 2 R1.fq.gz 0:150 1:150 A:1677274145;C:1574139629;G:1591639511;T:1659773624;N:447991 150 150     1677274145 1574139629 1591639511 1659773624 447991 SRX23844451 SRS20664877 SRA1818205 Shanghai Ocean University|College of Aquaculture and Life Sciences Shanghai Ocean University                       B B biological fallback assumption illumina novaseq_era unknown random_priming unknown bulk unknown unknown   China 2024-03-06 Adult Adult Gill Respiratory System
30676 30676 SRR28233242 SRX23844450 SRS20664876 SRP493528 PRJNA1084193 Knockout transcriptome sequencing of TRPA1b gene in zebrafish PRJNA1084193 Other WT and KO were sampled at the critical and half death time of room temperature and high temperature treatment respectively.         WT21   strain:WT7|age:4mpf|dev stage:adult|collection date:2024 01 20|geo loc name:China|sex:male|tissue:gill|BioSampleModel:Model organism or animal                 WT21 WT21 WT21 ribonucleic acid     RNA-Seq TRANSCRIPTOMIC PCR PAIRED ILLUMINA Illumina NovaSeq X Plus   SRP493528     WT-2-1_R1.fq.gz WT-2-1_R2.fq.gz fastq fastq 6617487600.0 22058292.0 WT 2 1 R1.fq.gz 0:150 1:150 A:1701231328;C:1606849699;G:1625342674;T:1683607145;N:456754 150 150     1701231328 1606849699 1625342674 1683607145 456754 SRX23844450 SRS20664876 SRA1818205 Shanghai Ocean University|College of Aquaculture and Life Sciences Shanghai Ocean University                       B B biological fallback assumption illumina novaseq_era unknown random_priming unknown bulk unknown unknown   China 2024-03-06 Adult Adult Gill Respiratory System
30677 30677 SRR28233243 SRX23844449 SRS20664875 SRP493528 PRJNA1084193 Knockout transcriptome sequencing of TRPA1b gene in zebrafish PRJNA1084193 Other WT and KO were sampled at the critical and half death time of room temperature and high temperature treatment respectively.         WT13   strain:WT6|age:4mpf|dev stage:adult|collection date:2024 01 20|geo loc name:China|sex:male|tissue:gill|BioSampleModel:Model organism or animal                 WT13 WT13 WT13 ribonucleic acid     RNA-Seq TRANSCRIPTOMIC PCR PAIRED ILLUMINA Illumina NovaSeq X Plus   SRP493528     WT-1-3_R1.fq.gz WT-1-3_R2.fq.gz fastq fastq 7102153500.0 23673845.0 WT 1 3 R1.fq.gz 0:150 1:150 A:1842496944;C:1707310744;G:1727403195;T:1824440904;N:501713 150 150     1842496944 1707310744 1727403195 1824440904 501713 SRX23844449 SRS20664875 SRA1818205 Shanghai Ocean University|College of Aquaculture and Life Sciences Shanghai Ocean University                       B B biological fallback assumption illumina novaseq_era unknown random_priming unknown bulk unknown unknown   China 2024-03-06 Adult Adult Gill Respiratory System
30678 30678 SRR28233244 SRX23844448 SRS20664874 SRP493528 PRJNA1084193 Knockout transcriptome sequencing of TRPA1b gene in zebrafish PRJNA1084193 Other WT and KO were sampled at the critical and half death time of room temperature and high temperature treatment respectively.         WT12   strain:WT5|age:4mpf|dev stage:adult|collection date:2024 01 20|geo loc name:China|sex:male|tissue:gill|BioSampleModel:Model organism or animal                 WT12 WT12 WT12 ribonucleic acid     RNA-Seq TRANSCRIPTOMIC PCR PAIRED ILLUMINA Illumina NovaSeq X Plus   SRP493528     WT-1-2_R1.fq.gz WT-1-2_R2.fq.gz fastq fastq 6904290900.0 23014303.0 WT 1 2 R1.fq.gz 0:150 1:150 A:1794495968;C:1655549612;G:1677906470;T:1775860400;N:478450 150 150     1794495968 1655549612 1677906470 1775860400 478450 SRX23844448 SRS20664874 SRA1818205 Shanghai Ocean University|College of Aquaculture and Life Sciences Shanghai Ocean University                       B B biological fallback assumption illumina novaseq_era unknown random_priming unknown bulk unknown unknown   China 2024-03-06 Adult Adult Gill Respiratory System
30679 30679 SRR28233245 SRX23844447 SRS20664873 SRP493528 PRJNA1084193 Knockout transcriptome sequencing of TRPA1b gene in zebrafish PRJNA1084193 Other WT and KO were sampled at the critical and half death time of room temperature and high temperature treatment respectively.         WT11   strain:WT4|age:4mpf|dev stage:adult|collection date:2024 01 20|geo loc name:China|sex:male|tissue:gill|BioSampleModel:Model organism or animal                 WT11 WT11 WT11 ribonucleic acid     RNA-Seq TRANSCRIPTOMIC PCR PAIRED ILLUMINA Illumina NovaSeq X Plus   SRP493528     WT-1-1_R1.fq.gz WT-1-1_R2.fq.gz fastq fastq 7005297000.0 23350990.0 WT 1 1 R1.fq.gz 0:150 1:150 A:1812285786;C:1684304098;G:1717096826;T:1791123167;N:487123 150 150     1812285786 1684304098 1717096826 1791123167 487123 SRX23844447 SRS20664873 SRA1818205 Shanghai Ocean University|College of Aquaculture and Life Sciences Shanghai Ocean University                       B B biological fallback assumption illumina novaseq_era unknown random_priming unknown bulk unknown unknown   China 2024-03-06 Adult Adult Gill Respiratory System
30680 30680 SRR28233246 SRX23844446 SRS20664872 SRP493528 PRJNA1084193 Knockout transcriptome sequencing of TRPA1b gene in zebrafish PRJNA1084193 Other WT and KO were sampled at the critical and half death time of room temperature and high temperature treatment respectively.         WT03   strain:WT3|age:4mpf|dev stage:adult|collection date:2024 01 20|geo loc name:China|sex:male|tissue:gill|BioSampleModel:Model organism or animal                 WT03 WT03 WT03 ribonucleic acid     RNA-Seq TRANSCRIPTOMIC PCR PAIRED ILLUMINA Illumina NovaSeq X Plus   SRP493528     WT-S3_1.fq.gz WT-S3_2.fq.gz fastq fastq 5014921200.0 16716404.0 WT S3 1.fq.gz 0:150 1:150 A:1376105590;C:1123924635;G:1152769107;T:1361994867;N:127001 150 150     1376105590 1123924635 1152769107 1361994867 127001 SRX23844446 SRS20664872 SRA1818205 Shanghai Ocean University|College of Aquaculture and Life Sciences Shanghai Ocean University                       B B biological fallback assumption illumina novaseq_era unknown random_priming unknown bulk unknown unknown   China 2024-03-06 Adult Adult Gill Respiratory System
30681 30681 SRR28233247 SRX23844445 SRS20664871 SRP493528 PRJNA1084193 Knockout transcriptome sequencing of TRPA1b gene in zebrafish PRJNA1084193 Other WT and KO were sampled at the critical and half death time of room temperature and high temperature treatment respectively.         A1b23   strain:TRPA1b KO9|age:4mpf|dev stage:adult|collection date:2024 01 20|geo loc name:China|sex:male|tissue:gill|BioSampleModel:Model organism or animal                 A1b23 A1b23 A1b23 ribonucleic acid     RNA-Seq TRANSCRIPTOMIC PCR PAIRED ILLUMINA Illumina NovaSeq X Plus   SRP493528     A1-2-3_R1.fq.gz A1-2-3_R2.fq.gz fastq fastq 6844595700.0 22815319.0 A1 2 3 R1.fq.gz 0:150 1:150 A:1778935800;C:1644607281;G:1662211377;T:1758352025;N:489217 150 150     1778935800 1644607281 1662211377 1758352025 489217 SRX23844445 SRS20664871 SRA1818205 Shanghai Ocean University|College of Aquaculture and Life Sciences Shanghai Ocean University                       B B biological fallback assumption illumina novaseq_era unknown random_priming unknown bulk unknown unknown   China 2024-03-06 Adult Adult Gill Respiratory System
30682 30682 SRR28233248 SRX23844444 SRS20664870 SRP493528 PRJNA1084193 Knockout transcriptome sequencing of TRPA1b gene in zebrafish PRJNA1084193 Other WT and KO were sampled at the critical and half death time of room temperature and high temperature treatment respectively.         A1b22   strain:TRPA1b KO8|age:4mpf|dev stage:adult|collection date:2024 01 20|geo loc name:China|sex:male|tissue:gill|BioSampleModel:Model organism or animal                 A1b22 A1b22 A1b22 ribonucleic acid     RNA-Seq TRANSCRIPTOMIC PCR PAIRED ILLUMINA Illumina NovaSeq X Plus   SRP493528     A1-2-2_R1.fq.gz A1-2-2_R2.fq.gz fastq fastq 6529918800.0 21766396.0 A1 2 2 R1.fq.gz 0:150 1:150 A:1681524014;C:1580514490;G:1605344761;T:1662085103;N:450432 150 150     1681524014 1580514490 1605344761 1662085103 450432 SRX23844444 SRS20664870 SRA1818205 Shanghai Ocean University|College of Aquaculture and Life Sciences Shanghai Ocean University                       B B biological fallback assumption illumina novaseq_era unknown random_priming unknown bulk unknown unknown   China 2024-03-06 Adult Adult Gill Respiratory System
30683 30683 SRR28233249 SRX23844443 SRS20664869 SRP493528 PRJNA1084193 Knockout transcriptome sequencing of TRPA1b gene in zebrafish PRJNA1084193 Other WT and KO were sampled at the critical and half death time of room temperature and high temperature treatment respectively.         A1b21   strain:TRPA1b KO7|age:4mpf|dev stage:adult|collection date:2024 01 20|geo loc name:China|sex:male|tissue:gill|BioSampleModel:Model organism or animal                 A1b21 A1b21 A1b21 ribonucleic acid     RNA-Seq TRANSCRIPTOMIC PCR PAIRED ILLUMINA Illumina NovaSeq X Plus   SRP493528     A1-2-1_R1.fq.gz A1-2-1_R2.fq.gz fastq fastq 6836499600.0 22788332.0 A1 2 1 R1.fq.gz 0:150 1:150 A:1769098120;C:1648663116;G:1667962343;T:1750293771;N:482250 150 150     1769098120 1648663116 1667962343 1750293771 482250 SRX23844443 SRS20664869 SRA1818205 Shanghai Ocean University|College of Aquaculture and Life Sciences Shanghai Ocean University                       B B biological fallback assumption illumina novaseq_era unknown random_priming unknown bulk unknown unknown   China 2024-03-06 Adult Adult Gill Respiratory System
30684 30684 SRR28233250 SRX23844442 SRS20664868 SRP493528 PRJNA1084193 Knockout transcriptome sequencing of TRPA1b gene in zebrafish PRJNA1084193 Other WT and KO were sampled at the critical and half death time of room temperature and high temperature treatment respectively.         A1b13   strain:TRPA1b KO6|age:4mpf|dev stage:adult|collection date:2024 01 20|geo loc name:China|sex:male|tissue:gill|BioSampleModel:Model organism or animal                 A1b13 A1b13 A1b13 ribonucleic acid     RNA-Seq TRANSCRIPTOMIC PCR PAIRED ILLUMINA Illumina NovaSeq X Plus   SRP493528     A1-1-3_R1.fq.gz A1-1-3_R2.fq.gz fastq fastq 7024153800.0 23413846.0 A1 1 3 R1.fq.gz 0:150 1:150 A:1803658498;C:1704926954;G:1731475860;T:1783603775;N:488713 150 150     1803658498 1704926954 1731475860 1783603775 488713 SRX23844442 SRS20664868 SRA1818205 Shanghai Ocean University|College of Aquaculture and Life Sciences Shanghai Ocean University                       B B biological fallback assumption illumina novaseq_era unknown random_priming unknown bulk unknown unknown   China 2024-03-06 Adult Adult Gill Respiratory System
30685 30685 SRR28233251 SRX23844441 SRS20664867 SRP493528 PRJNA1084193 Knockout transcriptome sequencing of TRPA1b gene in zebrafish PRJNA1084193 Other WT and KO were sampled at the critical and half death time of room temperature and high temperature treatment respectively.         A1b12   strain:TRPA1b KO5|age:4mpf|dev stage:adult|collection date:2024 01 20|geo loc name:China|sex:male|tissue:gill|BioSampleModel:Model organism or animal                 A1b12 A1b12 A1b12 ribonucleic acid     RNA-Seq TRANSCRIPTOMIC PCR PAIRED ILLUMINA Illumina NovaSeq X Plus   SRP493528     A1-1-2_R1.fq.gz A1-1-2_R2.fq.gz fastq fastq 6764278200.0 22547594.0 A1 1 2 R1.fq.gz 0:150 1:150 A:1765465821;C:1610874768;G:1638217652;T:1749259791;N:460168 150 150     1765465821 1610874768 1638217652 1749259791 460168 SRX23844441 SRS20664867 SRA1818205 Shanghai Ocean University|College of Aquaculture and Life Sciences Shanghai Ocean University                       B B biological fallback assumption illumina novaseq_era unknown random_priming unknown bulk unknown unknown   China 2024-03-06 Adult Adult Gill Respiratory System
30686 30686 SRR28233252 SRX23844440 SRS20664866 SRP493528 PRJNA1084193 Knockout transcriptome sequencing of TRPA1b gene in zebrafish PRJNA1084193 Other WT and KO were sampled at the critical and half death time of room temperature and high temperature treatment respectively.         A1b11   strain:TRPA1b KO4|age:4mpf|dev stage:adult|collection date:2024 01 20|geo loc name:China|sex:male|tissue:gill|BioSampleModel:Model organism or animal                 A1b11 A1b11 A1b11 ribonucleic acid     RNA-Seq TRANSCRIPTOMIC PCR PAIRED ILLUMINA Illumina NovaSeq X Plus   SRP493528     A1-1-1_R1.fq.gz A1-1-1_R2.fq.gz fastq fastq 7001419800.0 23338066.0 A1 1 1 R1.fq.gz 0:150 1:150 A:1755052093;C:1727552789;G:1786513789;T:1731804911;N:496218 150 150     1755052093 1727552789 1786513789 1731804911 496218 SRX23844440 SRS20664866 SRA1818205 Shanghai Ocean University|College of Aquaculture and Life Sciences Shanghai Ocean University                       B B biological fallback assumption illumina novaseq_era unknown random_priming unknown bulk unknown unknown   China 2024-03-06 Adult Adult Gill Respiratory System
30687 30687 SRR28233253 SRX23844439 SRS20664865 SRP493528 PRJNA1084193 Knockout transcriptome sequencing of TRPA1b gene in zebrafish PRJNA1084193 Other WT and KO were sampled at the critical and half death time of room temperature and high temperature treatment respectively.         A1b03   strain:TRPA1b KO3|age:4mpf|dev stage:adult|collection date:2024 01 20|geo loc name:China|sex:male|tissue:gill|BioSampleModel:Model organism or animal                 A1b03 A1b03 A1b03 ribonucleic acid     RNA-Seq TRANSCRIPTOMIC PCR PAIRED ILLUMINA Illumina NovaSeq X Plus   SRP493528     A1b-S3_1.fq.gz A1b-S3_2.fq.gz fastq fastq 6656319000.0 22187730.0 A1b S3 1.fq.gz 0:150 1:150 A:1836354615;C:1486285665;G:1534973763;T:1798492449;N:212508 150 150     1836354615 1486285665 1534973763 1798492449 212508 SRX23844439 SRS20664865 SRA1818205 Shanghai Ocean University|College of Aquaculture and Life Sciences Shanghai Ocean University                       B B biological fallback assumption illumina novaseq_era unknown random_priming unknown bulk unknown unknown   China 2024-03-06 Adult Adult Gill Respiratory System
30688 30688 SRR28233254 SRX23844438 SRS20664864 SRP493528 PRJNA1084193 Knockout transcriptome sequencing of TRPA1b gene in zebrafish PRJNA1084193 Other WT and KO were sampled at the critical and half death time of room temperature and high temperature treatment respectively.         A1b02   strain:TRPA1b KO2|age:4mpf|dev stage:adult|collection date:2024 01 20|geo loc name:China|sex:male|tissue:gill|BioSampleModel:Model organism or animal                 A1b02 A1b02 A1b02 ribonucleic acid     RNA-Seq TRANSCRIPTOMIC PCR PAIRED ILLUMINA Illumina NovaSeq X Plus   SRP493528     A1b-S2_1.fq.gz A1b-S2_2.fq.gz fastq fastq 12350635200.0 41168784.0 A1b S2 1.fq.gz 0:150 1:150 A:3393503091;C:2740767056;G:2872562559;T:3343736443;N:66051 150 150     3393503091 2740767056 2872562559 3343736443 66051 SRX23844438 SRS20664864 SRA1818205 Shanghai Ocean University|College of Aquaculture and Life Sciences Shanghai Ocean University                       B B biological fallback assumption illumina novaseq_era unknown random_priming unknown bulk unknown unknown   China 2024-03-06 Adult Adult Gill Respiratory System
30689 30689 SRR28233255 SRX23844437 SRS20664863 SRP493528 PRJNA1084193 Knockout transcriptome sequencing of TRPA1b gene in zebrafish PRJNA1084193 Other WT and KO were sampled at the critical and half death time of room temperature and high temperature treatment respectively.         WT02   strain:WT2|age:4mpf|dev stage:adult|collection date:2024 01 20|geo loc name:China|sex:male|tissue:gill|BioSampleModel:Model organism or animal                 WT02 WT02 WT02 ribonucleic acid     RNA-Seq TRANSCRIPTOMIC PCR PAIRED ILLUMINA Illumina NovaSeq X Plus   SRP493528     WT-S2_1.fq.gz WT-S2_2.fq.gz fastq fastq 6740391600.0 22467972.0 WT S2 1.fq.gz 0:150 1:150 A:1839600016;C:1523127157;G:1552667106;T:1824551017;N:446304 150 150     1839600016 1523127157 1552667106 1824551017 446304 SRX23844437 SRS20664863 SRA1818205 Shanghai Ocean University|College of Aquaculture and Life Sciences Shanghai Ocean University                       B B biological fallback assumption illumina novaseq_era unknown random_priming unknown bulk unknown unknown   China 2024-03-06 Adult Adult Gill Respiratory System
30690 30690 SRR28233256 SRX23844436 SRS20664862 SRP493528 PRJNA1084193 Knockout transcriptome sequencing of TRPA1b gene in zebrafish PRJNA1084193 Other WT and KO were sampled at the critical and half death time of room temperature and high temperature treatment respectively.         WT01   strain:WT1|age:4mpf|dev stage:adult|collection date:2024 01 20|geo loc name:China|sex:male|tissue:gill|BioSampleModel:Model organism or animal                 WT01 WT01 WT01 ribonucleic acid     RNA-Seq TRANSCRIPTOMIC PCR PAIRED ILLUMINA Illumina NovaSeq X Plus   SRP493528     WT-S1_1.fq.gz WT-S1_2.fq.gz fastq fastq 7104288900.0 23680963.0 WT S1 1.fq.gz 0:150 1:150 A:1946897695;C:1592125410;G:1641002833;T:1923739782;N:523180 150 150     1946897695 1592125410 1641002833 1923739782 523180 SRX23844436 SRS20664862 SRA1818205 Shanghai Ocean University|College of Aquaculture and Life Sciences Shanghai Ocean University                       B B biological fallback assumption illumina novaseq_era unknown random_priming unknown bulk unknown unknown   China 2024-03-06 Adult Adult Gill Respiratory System

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