RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA738523" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA738523 · 6 ✖

analysis 1

  • blastn · 6 ✖

tax_kingdom 0

Link rowid ▼ query bioproject node length coverage rel_abundance taxname_lca taxid_lca taxoncategory taxoncategorysimple bits evalue lowcoverage_flag analysis_used target taxid gene allele pident sumperc_cov alnlen mismatch qcov gapopen qstart qend tstart tend target_title analysis sumalnlen maxbits bits_percmax tax_superkingdom tax_clade tax_kingdom tax_phylum tax_class tax_order tax_family tax_genus tax_species
5025980 5025980 PRJNA738523_P_NODE_12004_length_248_cov_1.760000_g11933_i0 PRJNA738523 12004 248 1.76 4.3648 Saprolegnia 4769 SAR_Eukaryotes SAR_Eukaryotes 193 1.27e-44   NTclustered gi|813233307|ref|XM_012358054.1| 695850 g11933 i0 82.143 38.0846774193548 224 40 90 0 4 227 284 61 Saprolegnia parasitica CBS 223.65 40S ribosomal protein S15a partial mRNA blastn 9445 193 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia parasitica
7098287 7098287 PRJNA738523_P_NODE_8946_length_265_cov_1.348958_g8875_i0 PRJNA738523 8946 265 1.348958 3.5747387 Phytopythium vexans 907947 SAR_Eukaryotes SAR_Eukaryotes 252 2.22e-62   NTclustered gi|71063372|gb|DQ071321.1| 907947 g8875 i0 83.895 28.1358490566038 267 39 100 4 1 265 292 556 Pythium vexans strain NBRC100112 beta-tubulin gene, partial cds blastn 7456 252 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Phytopythium Phytopythium vexans
17297648 17297648 PRJNA738523_P_NODE_7154_length_282_cov_1.473684_g7083_i0 PRJNA738523 7154 282 1.473684 4.15578888 Phytophthora ramorum 164328 SAR_Eukaryotes SAR_Eukaryotes 161 4.14e-35   NTclustered gi|2794921884|ref|XM_067881184.1| 164328 g7083 i0 81.633 12.4893617021277 196 34 69 2 9 203 196 390 Phytophthora ramorum 60S ribosomal protein L23 (KRP23_10704), partial mRNA blastn 3522 161 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora ramorum
18571371 18571371 PRJNA738523_P_NODE_8595_length_268_cov_1.579487_g8524_i0 PRJNA738523 8595 268 1.579487 4.23302516 Saprolegnia parasitica 101203 SAR_Eukaryotes SAR_Eukaryotes 174 5.02e-39   NTclustered gi|813142527|ref|XM_012343931.1| 695850 g8524 i0 80.426 73.5746268656716 235 41 86 5 30 260 656 423 Saprolegnia parasitica CBS 223.65 60S ribosomal protein L3 mRNA blastn 19718 174 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia parasitica
23672510 23672510 PRJNA738523_P_NODE_10539_length_251_cov_0.865169_g10468_i0 PRJNA738523 10539 251 0.865169 2.17157419 Phytophthora sojae 67593 SAR_Eukaryotes SAR_Eukaryotes 196 9.93e-46   NTclustered gi|695372681|ref|XM_009516579.1| 67593 g10468 i0 82.174 95.5418326693227 230 39 91 2 7 235 633 861 Phytophthora sojae hypothetical protein mRNA blastn 23981 196 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora sojae
23672563 23672563 PRJNA738523_P_NODE_3979_length_345_cov_1.698529_g3908_i0 PRJNA738523 3979 345 1.698529 5.85992505 Phytophthora ramorum 164328 SAR_Eukaryotes SAR_Eukaryotes 265 3.8499999999999995e-66   NTclustered gi|2794906124|ref|XM_067889988.1| 164328 g3908 i0 80.826 70.0840579710145 339 63 98 2 6 343 632 969 Phytophthora ramorum 60S ribosomal protein L3 (KRP23_4970), partial mRNA blastn 24179 265 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora ramorum

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;