RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJNA1068513" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 22 ✖

tax_clade 1

bioproject 1

  • PRJNA1068513 · 22 ✖

analysis 1

  • diamond · 22 ✖

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
4841653 4841653 PRJNA1068513_S_NODE_4104_length_442_cov_33.466125_g4059_i0 PRJNA1068513 4104 442 33.466125 147.9202725 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 112 3.6199999999999997e-28   NR KAH9139353.1 100861 g4059 i0 54 5.40950226244344 113 50 76.7 2 440 102 64 174 KAH9139353.1 hypothetical protein AeRB84_016376 [Aphanomyces euteiches] diamond 2391 113 0.991150442477876 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
19307400 19307400 PRJNA1068513_S_NODE_11016_length_267_cov_3.819588_g10970_i0 PRJNA1068513 11016 267 3.819588 10.19829996 Aphanomyces stellatus 120398 SAR_Eukaryotes SAR_Eukaryotes 82.4 5.52e-16   NR KAF0685454.1 120398 g10970 i0 84.9 0.595505617977528 53 7 58.4 1 3 158 1074 1126 KAF0685454.1 hypothetical protein As57867_022598 [Aphanomyces stellatus] diamond 159 82.4 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces stellatus
21858729 21858729 PRJNA1068513_S_NODE_6838_length_348_cov_13.745455_g6792_i0 PRJNA1068513 6838 348 13.745455 47.8341834 Viridiplantae 33090 SAR_Eukaryotes SAR_Eukaryotes 134 1.06e-36   NR XP_067822915.1 4779 g6792 i0 58.1 7.23275862068965 93 39 80.2 0 2 280 131 223 XP_067822915.1 hypothetical protein CCR75_009236 [Bremia lactucae] diamond 2517 134 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Bremia Bremia lactucae
27920078 27920078 PRJNA1068513_S_NODE_8005_length_321_cov_0.911290_g7959_i0 PRJNA1068513 8005 321 0.91129 2.9252409 Plasmopara halstedii 4781 SAR_Eukaryotes SAR_Eukaryotes 47.8 0.00145   NR XP_024586716.1 4781 g7959 i0 41.7 1.00934579439252 48 27 43.9 1 145 5 286 333 XP_024586716.1 zinc finger-containing partial [Plasmopara halstedii] diamond 324 47.8 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Plasmopara Plasmopara halstedii
28551784 28551784 PRJNA1068513_S_NODE_6887_length_347_cov_7.281022_g6841_i0 PRJNA1068513 6887 347 7.281022 25.26514634 Phytophthora rubi 129364 SAR_Eukaryotes SAR_Eukaryotes 47 0.00398   NR KAE9028738.1 129364 g6841 i0 49 0.881844380403458 51 26 44.1 0 30 182 10 60 KAE9028738.1 hypothetical protein PR002_g10320 [Phytophthora rubi] diamond 306 47 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora rubi
29080047 29080047 PRJNA1068513_S_NODE_2988_length_499_cov_3.039906_g2943_i0 PRJNA1068513 2988 499 3.039906 15.16913094 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 59.7 5.96e-7   NR RAW38525.1 29920 g2943 i0 52.4 2.65130260521042 63 30 37.9 0 127 315 360 422 RAW38525.1 hypothetical protein PC110_g5230 [Phytophthora cactorum] diamond 1323 59.7 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cactorum
29143399 29143399 PRJNA1068513_S_NODE_6569_length_356_cov_3.522968_g6523_i0 PRJNA1068513 6569 356 3.522968 12.54176608 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 71.2 7.49e-12   NR OQS03155.1 74557 g6523 i0 43.7 3.56460674157303 71 40 59.8 0 140 352 215 285 OQS03155.1 hypothetical protein THRCLA_04539 [Thraustotheca clavata] diamond 1269 71.6 0.994413407821229 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Achlyaceae Thraustotheca Thraustotheca clavata
29277656 29277656 PRJNA1068513_S_NODE_11369_length_262_cov_1.359788_g11323_i0 PRJNA1068513 11369 262 1.359788 3.56264456 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 105 2.67e-25   NR KAH9115385.1 100861 g11323 i0 69.1 3.11450381679389 68 21 77.9 0 260 57 205 272 KAH9115385.1 hypothetical protein AeMF1_010570 [Aphanomyces euteiches] diamond 816 105 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
29309331 29309331 PRJNA1068513_S_NODE_10709_length_272_cov_2.125628_g10663_i0 PRJNA1068513 10709 272 2.125628 5.78170816 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 125 3.4199999999999997e-35   NR RHY14558.1 112090 g10663 i0 74.1 4.51102941176471 81 21 89.3 0 271 29 31 111 RHY14558.1 hypothetical protein DYB36_007101, partial [Aphanomyces astaci] diamond 1227 125 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
29498792 29498792 PRJNA1068513_S_NODE_9550_length_291_cov_1.362385_g9504_i0 PRJNA1068513 9550 291 1.362385 3.96454035 Thraustotheca clavata 74557 SAR_Eukaryotes SAR_Eukaryotes 68.6 5.58e-11   NR OQS07405.1 74557 g9504 i0 43.8 1.62886597938144 80 43 80.4 1 9 242 331 410 OQS07405.1 amidohydrolase family protein, partial [Thraustotheca clavata] diamond 474 68.6 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Achlyaceae Thraustotheca Thraustotheca clavata
30193570 30193570 PRJNA1068513_S_NODE_13452_length_239_cov_3.662651_g13406_i0 PRJNA1068513 13452 239 3.662651 8.75373589 Phytophthora cactorum 29920 SAR_Eukaryotes SAR_Eukaryotes 45.1 0.00539   NR KAG2826132.1 29920 g13406 i0 27.9 0.853556485355649 68 49 85.4 0 237 34 499 566 KAG2826132.1 Serine/threonine-protein phosphatase 2A regulatory subunit A alpha isoform [Phytophthora cactorum] diamond 204 45.1 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cactorum
30288864 30288864 PRJNA1068513_S_NODE_4412_length_429_cov_3.053371_g4367_i0 PRJNA1068513 4412 429 3.053371 13.09896159 Pythium insidiosum 114742 SAR_Eukaryotes SAR_Eukaryotes 90.9 2.51e-18   NR GLD94218.1 114742 g4367 i0 53.8 2.23076923076923 80 36 55.9 1 393 154 220 298 GLD94218.1 hypothetical protein PINS_up002829 [Pythium insidiosum] diamond 957 90.9 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium insidiosum
31078512 31078512 PRJNA1068513_S_NODE_13415_length_240_cov_3.598802_g13369_i0 PRJNA1068513 13415 240 3.598802 8.6371248 Aphanomyces cochlioides 112091 SAR_Eukaryotes SAR_Eukaryotes 68.2 1.16e-12   NR KAG9410382.1 112091 g13369 i0 100 1.35 35 0 43.8 0 3 107 73 107 KAG9410382.1 60S ribosomal protein L37A [Aphanomyces cochlioides] diamond 324 68.2 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces cochlioides
31268017 31268017 PRJNA1068513_S_NODE_10695_length_272_cov_3.839196_g10649_i0 PRJNA1068513 10695 272 3.839196 10.44261312 Aphanomyces cochlioides 112091 SAR_Eukaryotes SAR_Eukaryotes 126 6.399999999999999e-32   NR KAG9405717.1 112091 g10649 i0 80.9 3 68 13 75 0 5 208 416 483 KAG9405717.1 hypothetical protein AC1031_003632 [Aphanomyces cochlioides] diamond 816 126 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces cochlioides
31299594 31299594 PRJNA1068513_S_NODE_4155_length_440_cov_2.629428_g4110_i0 PRJNA1068513 4155 440 2.629428 11.5694832 Phytophthora lilii 2077276 SAR_Eukaryotes SAR_Eukaryotes 54.7 2.07e-5   NR GMF31539.1 2077276 g4110 i0 31.7 0.818181818181818 120 69 74.3 4 113 439 751 868 GMF31539.1 unnamed protein product [Phytophthora lilii] diamond 360 54.7 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora lilii
31354542 31354542 PRJNA1068513_S_NODE_10996_length_268_cov_1.446154_g10950_i0 PRJNA1068513 10996 268 1.446154 3.87569272 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 84.7 4.36e-18   NR OQS05729.1 74557 g10950 i0 57.3 2.49626865671642 75 31 84 1 255 31 117 190 OQS05729.1 HD domain-containing protein 2-like isoform 1 [Thraustotheca clavata] diamond 669 84.7 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Achlyaceae Thraustotheca Thraustotheca clavata
31544374 31544374 PRJNA1068513_S_NODE_4056_length_445_cov_2.096774_g4011_i0 PRJNA1068513 4056 445 2.096774 9.3306443 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 60.1 2.82e-7   NR OQS02123.1 74557 g4011 i0 35 2.19101123595506 120 65 75.5 6 17 352 517 631 OQS02123.1 ubiquitin specific peptidase 38 [Thraustotheca clavata] diamond 975 60.5 0.993388429752066 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Achlyaceae Thraustotheca Thraustotheca clavata
31710818 31710818 PRJNA1068513_S_NODE_12677_length_247_cov_3.574713_g12631_i0 PRJNA1068513 12677 247 3.574713 8.82954111 Aphanomyces invadans 157072 SAR_Eukaryotes SAR_Eukaryotes 45.4 0.00178   NR XP_008877611.1 157072 g12631 i0 84.6 1.50607287449393 26 3 30.4 1 225 151 119 144 XP_008877611.1 hypothetical protein H310_12365 [Aphanomyces invadans] diamond 372 45.4 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces invadans
32050390 32050390 PRJNA1068513_S_NODE_8078_length_319_cov_2.845528_g8032_i0 PRJNA1068513 8078 319 2.845528 9.07723432 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 45.1 0.014   NR CCI42688.1 65357 g8032 i0 51.4 1.5987460815047 35 17 32.9 0 299 195 817 851 CCI42688.1 unnamed protein product [Albugo candida] diamond 510 45.1 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo candida
32153776 32153776 PRJNA1068513_S_NODE_11378_length_262_cov_1.238095_g11332_i0 PRJNA1068513 11378 262 1.238095 3.2438089 Peronosclerospora sorghi 230839 SAR_Eukaryotes SAR_Eukaryotes 50.8 2.16e-5   NR KAI9918082.1 230839 g11332 i0 43.8 1.52290076335878 64 36 73.3 0 255 64 89 152 KAI9918082.1 hypothetical protein PsorP6_012509 [Peronosclerospora sorghi] diamond 399 50.8 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronosclerospora Peronosclerospora sorghi
32312249 32312249 PRJNA1068513_S_NODE_9539_length_291_cov_1.715596_g9493_i0 PRJNA1068513 9539 291 1.715596 4.99238436 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 107 1.03e-24   NR RHY89121.1 112090 g9493 i0 82.5 0.587628865979381 57 10 58.8 0 55 225 497 553 RHY89121.1 hypothetical protein DYB35_011816 [Aphanomyces astaci] diamond 171 107 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
32375335 32375335 PRJNA1068513_S_NODE_8719_length_306_cov_3.356223_g8673_i0 PRJNA1068513 8719 306 3.356223 10.27004238 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 114 1.59e-30   NR KAF0741110.1 100861 g8673 i0 98.1 0.509803921568627 52 1 51 0 277 122 1 52 KAF0741110.1 hypothetical protein Ae201684_003678 [Aphanomyces euteiches] diamond 156 114 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches

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