RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

32 rows where analysis = "diamond", bioproject = "PRJNA1113956" and tax_phylum = "Microsporidia"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Microsporidia · 32 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1113956 · 32 ✖

analysis 1

  • diamond · 32 ✖
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
7874894 7874894 PRJNA1113956_P_NODE_8587_length_500_cov_2.592506_g8249_i0 PRJNA1113956 8587 500 2.592506 12.96253 Mitosporidium daphniae 1485682 Fungi Fungi 130 2.15e-32   NR XP_013238601.1 1485682 g8249 i0 56.4 0.606 101 44 60.6 0 337 35 328 428 XP_013238601.1 histone deacetylase [Mitosporidium daphniae] diamond 303 130 1 Eukaryota Opisthokonta Fungi Microsporidia       Mitosporidium Mitosporidium daphniae
26846697 26846697 PRJNA1113956_P_NODE_6721_length_617_cov_1.220588_g6396_i0 PRJNA1113956 6721 617 1.220588 7.53102796 Hamiltosporidium tvaerminnensis 1176355 Fungi Fungi 63.9 3.39e-9   NR KAK1351077.1 1176355 g6396 i0 51.7 0.282009724473258 58 28 28.2 0 616 443 40 97 KAK1351077.1 hypothetical protein LUQ84_000350 [Hamiltosporidium tvaerminnensis] diamond 174 63.9 1 Eukaryota Opisthokonta Fungi Microsporidia     Dubosqiidae Hamiltosporidium Hamiltosporidium tvaerminnensis
27794670 27794670 PRJNA1113956_P_NODE_13504_length_344_cov_1.136531_g13164_i0 PRJNA1113956 13504 344 1.136531 3.90966664 Anncaliia algerae PRA1 723287 Fungi Fungi 56.2 1.76e-6   NR KCZ78048.1 1240240 g13164 i0 68.6 1.57848837209302 35 11 30.5 0 2 106 228 262 KCZ78048.1 hypothetical protein H311_00932 [Anncaliia algerae PRA109] diamond 543 56.2 1 Eukaryota Opisthokonta Fungi Microsporidia     Tubulinosematidae Anncaliia Anncaliia algerae
27880323 27880323 PRJNA1113956_P_NODE_22045_length_243_cov_0.905882_g21705_i0 PRJNA1113956 22045 243 0.905882 2.20129326 Hamiltosporidium 1176354 Fungi Fungi 64.3 6.44e-10   NR TBU02984.1 148818 g21705 i0 62.5 5.33333333333333 48 18 59.3 0 93 236 167 214 TBU02984.1 DDE-like endonuclease [Hamiltosporidium magnivora] diamond 1296 64.3 1 Eukaryota Opisthokonta Fungi Microsporidia     Dubosqiidae Hamiltosporidium Hamiltosporidium magnivora
28078596 28078596 PRJNA1113956_P_NODE_13325_length_348_cov_1.178182_g12985_i0 PRJNA1113956 13325 348 1.178182 4.10007336 Hamiltosporidium tvaerminnensis 1176355 Fungi Fungi 86.3 2.3e-19   NR TBU11636.1 1176355 g12985 i0 69 2 58 17 50 1 294 121 25 81 TBU11636.1 putative DDE-like endonuclease, partial [Hamiltosporidium tvaerminnensis] diamond 696 86.3 1 Eukaryota Opisthokonta Fungi Microsporidia     Dubosqiidae Hamiltosporidium Hamiltosporidium tvaerminnensis
28204779 28204779 PRJNA1113956_P_NODE_9666_length_452_cov_1.197889_g9327_i0 PRJNA1113956 9666 452 1.197889 5.41445828 Anncaliia algerae PRA339 1288291 Fungi Fungi 55.5 9.2e-6   NR KCZ82149.1 1288291 g9327 i0 38.2 1.38716814159292 68 42 45.1 0 202 405 178 245 KCZ82149.1 hypothetical protein H312_00426 [Anncaliia algerae PRA339] diamond 627 55.5 1 Eukaryota Opisthokonta Fungi Microsporidia     Tubulinosematidae Anncaliia Anncaliia algerae
28331197 28331197 PRJNA1113956_P_NODE_5426_length_725_cov_2.374233_g5119_i0 PRJNA1113956 5426 725 2.374233 17.21318925 Hamiltosporidium tvaerminnensis 1176355 Fungi Fungi 273 1.46e-81   NR TBU13616.1 1176355 g5119 i0 73.5 1.63448275862069 200 53 82.8 0 601 2 19 218 TBU13616.1 putative DDE endonuclease [Hamiltosporidium tvaerminnensis] diamond 1185 273 1 Eukaryota Opisthokonta Fungi Microsporidia     Dubosqiidae Hamiltosporidium Hamiltosporidium tvaerminnensis
28426125 28426125 PRJNA1113956_P_NODE_20766_length_247_cov_1.770115_g20426_i0 PRJNA1113956 20766 247 1.770115 4.37218405 Enteropsectra breve 1912989 Fungi Fungi 66.6 5.53e-11   NR KAI5151716.1 1912989 g20426 i0 42.5 1.84615384615385 80 44 94.7 1 3 236 97 176 KAI5151716.1 hypothetical protein ENBRE01_2334 [Enteropsectra breve] diamond 456 66.6 1 Eukaryota Opisthokonta Fungi Microsporidia       Enteropsectra Enteropsectra breve
28710322 28710322 PRJNA1113956_P_NODE_21027_length_246_cov_1.780347_g20687_i0 PRJNA1113956 21027 246 1.780347 4.37965362 Anncaliia algerae PRA339 1288291 Fungi Fungi 52.4 2.43e-6   NR KCZ81516.1 1288291 g20687 i0 35.2 0.658536585365854 54 35 65.9 0 236 75 52 105 KCZ81516.1 hypothetical protein H312_01094 [Anncaliia algerae PRA339] diamond 162 52.4 1 Eukaryota Opisthokonta Fungi Microsporidia     Tubulinosematidae Anncaliia Anncaliia algerae
28804651 28804651 PRJNA1113956_P_NODE_16888_length_288_cov_1.074419_g16548_i0 PRJNA1113956 16888 288 1.074419 3.09432672 Anncaliia algerae PRA1 723287 Fungi Fungi 60.5 2.1e-8   NR KCZ78016.1 1240240 g16548 i0 40.2 0.854166666666667 82 49 85.4 0 247 2 71 152 KCZ78016.1 hypothetical protein H311_00962, partial [Anncaliia algerae PRA109] diamond 246 60.5 1 Eukaryota Opisthokonta Fungi Microsporidia     Tubulinosematidae Anncaliia Anncaliia algerae
28836372 28836372 PRJNA1113956_P_NODE_16908_length_287_cov_1.747664_g16568_i0 PRJNA1113956 16908 287 1.747664 5.01579568 Cucumispora dikerogammari 658444 Fungi Fungi 45.8 0.00304   NR KAF7686015.1 658444 g16568 i0 56.8 0.386759581881533 37 16 38.7 0 285 175 148 184 KAF7686015.1 Histone-lysine N-methyltransferase SETMAR [Cucumispora dikerogammari] diamond 111 45.8 1 Eukaryota Opisthokonta Fungi Microsporidia       Cucumispora Cucumispora dikerogammari
28962968 28962968 PRJNA1113956_P_NODE_20128_length_250_cov_0.870056_g19788_i0 PRJNA1113956 20128 250 0.870056 2.17514 Cucumispora dikerogammari 658444 Fungi Fungi 81.3 1.63e-16   NR KAF7694580.1 658444 g19788 i0 56.8 1.944 81 35 97.2 0 248 6 143 223 KAF7694580.1 Paired box protein Pax-2-A, partial [Cucumispora dikerogammari] diamond 486 81.3 1 Eukaryota Opisthokonta Fungi Microsporidia       Cucumispora Cucumispora dikerogammari
29215555 29215555 PRJNA1113956_P_NODE_1589_length_1461_cov_4.134006_g1460_i0 PRJNA1113956 1589 1461 4.134006 60.39782766 Cucumispora dikerogammari 658444 Fungi Fungi 115 1.5899999999999999e-24   NR KAF7685763.1 658444 g1460 i0 51.6 0.496919917864476 122 59 25.1 0 967 1332 71 192 KAF7685763.1 hypothetical protein CDIK_3488 [Cucumispora dikerogammari] diamond 726 115 1 Eukaryota Opisthokonta Fungi Microsporidia       Cucumispora Cucumispora dikerogammari
29404804 29404804 PRJNA1113956_P_NODE_20009_length_250_cov_0.870056_g19669_i0 PRJNA1113956 20009 250 0.870056 2.17514 Cucumispora dikerogammari 658444 Fungi Fungi 47.8 3.52e-4   NR KAF7701713.1 658444 g19669 i0 55.6 1.212 45 19 54 1 142 8 106 149 KAF7701713.1 hypothetical protein CDIK_0575 [Cucumispora dikerogammari] diamond 303 47.8 1 Eukaryota Opisthokonta Fungi Microsporidia       Cucumispora Cucumispora dikerogammari
29846888 29846888 PRJNA1113956_P_NODE_11091_length_405_cov_1.271084_g10751_i0 PRJNA1113956 11091 405 1.271084 5.1478902 Cucumispora dikerogammari 658444 Fungi Fungi 50.8 2.84e-4   NR KAF7684984.1 658444 g10751 i0 44.9 0.362962962962963 49 27 36.3 0 148 2 167 215 KAF7684984.1 hypothetical protein CDIK_4267, partial [Cucumispora dikerogammari] diamond 147 50.8 1 Eukaryota Opisthokonta Fungi Microsporidia       Cucumispora Cucumispora dikerogammari
29910164 29910164 PRJNA1113956_P_NODE_17031_length_286_cov_1.084507_g16691_i0 PRJNA1113956 17031 286 1.084507 3.10169002 Enteropsectra breve 1912989 Fungi Fungi 57.4 1.45e-7   NR KAI5150402.1 1912989 g16691 i0 52.9 1.59440559440559 51 24 53.5 0 218 66 97 147 KAI5150402.1 hypothetical protein ENBRE01_1476 [Enteropsectra breve] diamond 456 57.4 1 Eukaryota Opisthokonta Fungi Microsporidia       Enteropsectra Enteropsectra breve
29941752 29941752 PRJNA1113956_P_NODE_16491_length_293_cov_2.800000_g16151_i0 PRJNA1113956 16491 293 2.8 8.204 Mitosporidium daphniae 1485682 Fungi Fungi 46.2 6.13e-4   NR XP_013239108.1 1485682 g16151 i0 53.1 0.645051194539249 32 15 32.8 0 239 144 33 64 XP_013239108.1 uncharacterized protein DI09_145p20 [Mitosporidium daphniae] diamond 189 46.2 1 Eukaryota Opisthokonta Fungi Microsporidia       Mitosporidium Mitosporidium daphniae
30036447 30036447 PRJNA1113956_P_NODE_8451_length_508_cov_1.770115_g8113_i0 PRJNA1113956 8451 508 1.770115 8.9921842 Hamiltosporidium magnivora 148818 Fungi Fungi 59.3 2.35e-7   NR TBT99822.1 148818 g8113 i0 56.6 0.625984251968504 53 23 31.3 0 432 274 1 53 TBT99822.1 hypothetical protein CWI36_1836p0010 [Hamiltosporidium magnivora] diamond 318 59.3 1 Eukaryota Opisthokonta Fungi Microsporidia     Dubosqiidae Hamiltosporidium Hamiltosporidium magnivora
30225910 30225910 PRJNA1113956_P_NODE_8092_length_525_cov_2.057522_g7757_i0 PRJNA1113956 8092 525 2.057522 10.8019905 Dictyocoela muelleri 279532 Fungi Fungi 55.1 2.92e-6   NR KAG0426064.1 279532 g7757 i0 39.1 0.697142857142857 64 39 36.6 0 128 319 28 91 KAG0426064.1 hypothetical protein DMUE_5993 [Dictyocoela muelleri] diamond 366 55.1 1 Eukaryota Opisthokonta Fungi Microsporidia       Dictyocoela Dictyocoela muelleri
30352889 30352889 PRJNA1113956_P_NODE_18112_length_271_cov_1.555556_g17772_i0 PRJNA1113956 18112 271 1.555556 4.21555676 Anncaliia algerae PRA339 1288291 Fungi Fungi 61.2 1.31e-9   NR KCZ81497.1 1288291 g17772 i0 44.1 0.653136531365314 59 32 64.2 1 77 250 24 82 KCZ81497.1 hypothetical protein H312_01075, partial [Anncaliia algerae PRA339] diamond 177 61.2 1 Eukaryota Opisthokonta Fungi Microsporidia     Tubulinosematidae Anncaliia Anncaliia algerae
30352892 30352892 PRJNA1113956_P_NODE_20452_length_249_cov_0.875000_g20112_i0 PRJNA1113956 20452 249 0.875 2.17875 Pseudoloma neurophilia 146866 Fungi Fungi 53.5 4.76e-6   NR KRH94204.1 146866 g20112 i0 32.1 0.975903614457831 81 53 96.4 2 240 1 34 113 KRH94204.1 hypothetical protein M153_340000906 [Pseudoloma neurophilia] diamond 243 53.5 1 Eukaryota Opisthokonta Fungi Microsporidia       Pseudoloma Pseudoloma neurophilia
30384353 30384353 PRJNA1113956_P_NODE_353_length_2481_cov_7.037375_g312_i0 PRJNA1113956 353 2481 7.037375 174.59727375 Enteropsectra breve 1912989 Fungi Fungi 80.1 2.22e-12   NR KAI5152746.1 1912989 g312 i0 43.4 0.119709794437727 99 53 11.7 2 1665 1955 71 168 KAI5152746.1 hypothetical protein ENBRE01_2973, partial [Enteropsectra breve] diamond 297 80.1 1 Eukaryota Opisthokonta Fungi Microsporidia       Enteropsectra Enteropsectra breve
30659356 30659356 PRJNA1113956_P_NODE_12273_length_372_cov_1.488294_g11933_i0 PRJNA1113956 12273 372 1.488294 5.53645368 Tubulinosematidae 307623 Fungi Fungi 81.6 4.71e-16   NR KAG0421195.1 279532 g11933 i0 39.4 3.12903225806452 99 59 79.8 1 368 72 42 139 KAG0421195.1 hypothetical protein DMUE_6306, partial [Dictyocoela muelleri] diamond 1164 82.4 0.990291262135922 Eukaryota Opisthokonta Fungi Microsporidia       Dictyocoela Dictyocoela muelleri
30690888 30690888 PRJNA1113956_P_NODE_17133_length_284_cov_1.824645_g16793_i0 PRJNA1113956 17133 284 1.824645 5.1819918 Hamiltosporidium 1176354 Fungi Fungi 89.7 1.21e-19   NR TBU08170.1 148818 g16793 i0 78.2 5.38732394366197 55 12 58.1 0 170 6 77 131 TBU08170.1 hypothetical protein CWI39_0217p0030 [Hamiltosporidium magnivora] diamond 1530 89.7 1 Eukaryota Opisthokonta Fungi Microsporidia     Dubosqiidae Hamiltosporidium Hamiltosporidium magnivora
30794584 30794584 PRJNA1113956_P_NODE_6014_length_671_cov_1.545151_g5693_i0 PRJNA1113956 6014 671 1.545151 10.36796321 Cucumispora dikerogammari 658444 Fungi Fungi 94 1.52e-18   NR KAF7687784.1 658444 g5693 i0 55.8 0.344262295081967 77 34 34.4 0 234 464 293 369 KAF7687784.1 hypothetical protein CDIK_3019 [Cucumispora dikerogammari] diamond 231 94 1 Eukaryota Opisthokonta Fungi Microsporidia       Cucumispora Cucumispora dikerogammari
30952825 30952825 PRJNA1113956_P_NODE_22674_length_241_cov_0.916667_g22334_i0 PRJNA1113956 22674 241 0.916667 2.20916747 Pseudoloma neurophilia 146866 Fungi Fungi 76.6 9.3e-15   NR KRH93076.1 146866 g22334 i0 59.7 0.896265560165975 72 29 89.6 0 2 217 169 240 KRH93076.1 hypothetical protein M153_156700021, partial [Pseudoloma neurophilia] diamond 216 76.6 1 Eukaryota Opisthokonta Fungi Microsporidia       Pseudoloma Pseudoloma neurophilia
31110438 31110438 PRJNA1113956_P_NODE_15975_length_302_cov_1.161572_g15635_i0 PRJNA1113956 15975 302 1.161572 3.50794744 Pseudoloma neurophilia 146866 Fungi Fungi 199 1.1499999999999999e-60   NR KRH94915.1 146866 g15635 i0 98 0.993377483443709 100 2 99.3 0 1 300 11 110 KRH94915.1 hypothetical protein M153_11200021404 [Pseudoloma neurophilia] diamond 300 199 1 Eukaryota Opisthokonta Fungi Microsporidia       Pseudoloma Pseudoloma neurophilia
31110442 31110442 PRJNA1113956_P_NODE_2435_length_1193_cov_3.634821_g2246_i0 PRJNA1113956 2435 1193 3.634821 43.36341453 Hamiltosporidium tvaerminnensis 1176355 Fungi Fungi 210 1.16e-60   NR TBU11490.1 1176355 g2246 i0 87.7 0.573344509639564 114 14 28.7 0 1192 851 49 162 TBU11490.1 DDE-like endonuclease [Hamiltosporidium tvaerminnensis] diamond 684 210 1 Eukaryota Opisthokonta Fungi Microsporidia     Dubosqiidae Hamiltosporidium Hamiltosporidium tvaerminnensis
31521865 31521865 PRJNA1113956_P_NODE_3876_length_908_cov_2.402395_g3605_i0 PRJNA1113956 3876 908 2.402395 21.8137466 Hamiltosporidium tvaerminnensis 1176355 Fungi Fungi 160 5.86e-40   NR TBU13616.1 1176355 g3605 i0 43.5 1.62555066079295 246 131 81.3 2 739 2 1 238 TBU13616.1 putative DDE endonuclease [Hamiltosporidium tvaerminnensis] diamond 1476 160 1 Eukaryota Opisthokonta Fungi Microsporidia     Dubosqiidae Hamiltosporidium Hamiltosporidium tvaerminnensis
32376019 32376019 PRJNA1113956_P_NODE_8599_length_500_cov_1.374707_g8261_i0 PRJNA1113956 8599 500 1.374707 6.873535 Pseudoloma neurophilia 146866 Fungi Fungi 301 1.73e-102   NR KRH93876.1 146866 g8261 i0 100 0.918 153 0 91.8 0 499 41 11 163 KRH93876.1 hypothetical protein M153_5050002994 [Pseudoloma neurophilia] diamond 459 301 1 Eukaryota Opisthokonta Fungi Microsporidia       Pseudoloma Pseudoloma neurophilia
32502702 32502702 PRJNA1113956_P_NODE_22099_length_243_cov_0.905882_g21759_i0 PRJNA1113956 22099 243 0.905882 2.20129326 Nosema granulosis 83296 Fungi Fungi 60.1 1.9e-9   NR KAF9760563.1 83296 g21759 i0 45.1 2.02469135802469 82 44 100 1 243 1 10 91 KAF9760563.1 Transposable element Tcb1 transposase, partial [Nosema granulosis] diamond 492 60.1 1 Eukaryota Opisthokonta Fungi Microsporidia     Nosematidae Nosema Nosema granulosis
32754679 32754679 PRJNA1113956_P_NODE_9220_length_472_cov_1.671679_g8881_i0 PRJNA1113956 9220 472 1.671679 7.89032488 Enteropsectra breve 1912989 Fungi Fungi 53.1 6.17e-5   NR KAI5152746.1 1912989 g8881 i0 44.4 0.343220338983051 54 30 34.3 0 272 111 84 137 KAI5152746.1 hypothetical protein ENBRE01_2973, partial [Enteropsectra breve] diamond 162 53.1 1 Eukaryota Opisthokonta Fungi Microsporidia       Enteropsectra Enteropsectra breve

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