contig_metadata
21 rows where bioproject = "PRJNA889065" and tax_phylum = "Microsporidia"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19990053 | 19990053 | PRJNA889065_S_NODE_6016_length_384_cov_3.818182_g5778_i0 | PRJNA889065 | 6016 | 384 | 3.818182 | 14.66181888 | Mitosporidium daphniae | 1485682 | Fungi | Fungi | 139 | 2.4e-36 | NR | XP_013238601.1 | 1485682 | g5778 | i0 | 57.7 | 0.8125 | 104 | 44 | 81.3 | 0 | 380 | 69 | 325 | 428 | XP_013238601.1 histone deacetylase [Mitosporidium daphniae] | diamond | 312 | 139 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Mitosporidium | Mitosporidium daphniae | ||||
| 27940019 | 27940019 | PRJNA889065_S_NODE_18385_length_227_cov_1.396739_g18147_i0 | PRJNA889065 | 18385 | 227 | 1.396739 | 3.17059753 | Enteropsectra breve | 1912989 | Fungi | Fungi | 44.3 | 0.00653 | NR | KAI5151745.1 | 1912989 | g18147 | i0 | 37.5 | 0.740088105726872 | 56 | 34 | 72.7 | 1 | 192 | 28 | 119 | 174 | KAI5151745.1 hypothetical protein ENBRE01_2355 [Enteropsectra breve] | diamond | 168 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enteropsectra | Enteropsectra breve | ||||
| 27971456 | 27971456 | PRJNA889065_S_NODE_3645_length_476_cov_2.387991_g3416_i0 | PRJNA889065 | 3645 | 476 | 2.387991 | 11.36683716 | Hamiltosporidium tvaerminnensis | 1176355 | Fungi | Fungi | 60.5 | 2.49e-8 | NR | KAK1351077.1 | 1176355 | g3416 | i0 | 50.7 | 2.23739495798319 | 71 | 34 | 44.1 | 1 | 211 | 2 | 1 | 71 | KAK1351077.1 hypothetical protein LUQ84_000350 [Hamiltosporidium tvaerminnensis] | diamond | 1065 | 60.5 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Dubosqiidae | Hamiltosporidium | Hamiltosporidium tvaerminnensis | |||
| 28003279 | 28003279 | PRJNA889065_S_NODE_28265_length_182_cov_1.474820_g28027_i0 | PRJNA889065 | 28265 | 182 | 1.47482 | 2.6841724 | Anncaliia algerae PRA339 | 1288291 | Fungi | Fungi | 40.4 | 0.0283 | NR | KCZ81735.1 | 1288291 | g28027 | i0 | 48.6 | 0.576923076923077 | 35 | 18 | 57.7 | 0 | 9 | 113 | 23 | 57 | KCZ81735.1 hypothetical protein H312_00774 [Anncaliia algerae PRA339] | diamond | 105 | 40.4 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Tubulinosematidae | Anncaliia | Anncaliia algerae | |||
| 28287042 | 28287042 | PRJNA889065_S_NODE_4806_length_426_cov_5.336815_g4568_i0 | PRJNA889065 | 4806 | 426 | 5.336815 | 22.7348319 | Enteropsectra breve | 1912989 | Fungi | Fungi | 67.4 | 4.46e-10 | NR | KAI5152145.1 | 1912989 | g4568 | i0 | 58.8 | 0.359154929577465 | 51 | 21 | 35.9 | 0 | 384 | 232 | 212 | 262 | KAI5152145.1 hypothetical protein ENBRE01_2602, partial [Enteropsectra breve] | diamond | 153 | 67.4 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enteropsectra | Enteropsectra breve | ||||
| 28610851 | 28610851 | PRJNA889065_S_NODE_21347_length_211_cov_1.333333_g21109_i0 | PRJNA889065 | 21347 | 211 | 1.333333 | 2.81333263 | Hamiltosporidium | 1176354 | Fungi | Fungi | 57.8 | 1.06e-7 | NR | TBT99772.1 | 148818 | g21109 | i0 | 63.4 | 3.62559241706161 | 41 | 15 | 58.3 | 0 | 125 | 3 | 212 | 252 | TBT99772.1 DDE-like endonuclease, partial [Hamiltosporidium magnivora] | diamond | 765 | 57.8 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Dubosqiidae | Hamiltosporidium | Hamiltosporidium magnivora | |||
| 28666265 | 28666265 | PRJNA889065_S_NODE_6547_length_369_cov_2.923313_g6309_i0 | PRJNA889065 | 6547 | 369 | 2.923313 | 10.78702497 | Mitosporidium daphniae | 1485682 | Fungi | Fungi | 46.2 | 0.00124 | NR | XP_013239108.1 | 1485682 | g6309 | i0 | 53.1 | 0.894308943089431 | 32 | 15 | 26 | 0 | 86 | 181 | 33 | 64 | XP_013239108.1 uncharacterized protein DI09_145p20 [Mitosporidium daphniae] | diamond | 330 | 46.2 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Mitosporidium | Mitosporidium daphniae | ||||
| 28697879 | 28697879 | PRJNA889065_S_NODE_37567_length_155_cov_1.642857_g37329_i0 | PRJNA889065 | 37567 | 155 | 1.642857 | 2.54642835 | Hamiltosporidium tvaerminnensis | 1176355 | Fungi | Fungi | 45.1 | 6.64e-4 | NR | KAK1351077.1 | 1176355 | g37329 | i0 | 95.5 | 0.425806451612903 | 22 | 1 | 42.6 | 0 | 130 | 65 | 76 | 97 | KAK1351077.1 hypothetical protein LUQ84_000350 [Hamiltosporidium tvaerminnensis] | diamond | 66 | 45.1 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Dubosqiidae | Hamiltosporidium | Hamiltosporidium tvaerminnensis | |||
| 28760740 | 28760740 | PRJNA889065_S_NODE_31127_length_172_cov_2.201550_g30889_i0 | PRJNA889065 | 31127 | 172 | 2.20155 | 3.786666 | Enterospora canceri | 1081671 | Fungi | Fungi | 52.4 | 5.37e-6 | NR | ORD93307.1 | 1081671 | g30889 | i0 | 41.1 | 1.95348837209302 | 56 | 33 | 97.7 | 0 | 169 | 2 | 67 | 122 | ORD93307.1 Y132A [Enterospora canceri] | diamond | 336 | 52.4 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Enterospora | Enterospora canceri | |||
| 28894862 | 28894862 | PRJNA889065_S_NODE_39948_length_150_cov_1.121495_g39710_i0 | PRJNA889065 | 39948 | 150 | 1.121495 | 1.6822425 | Opisthokonta | 33154 | Fungi | Fungi | 44.3 | 0.00293 | NR | KAF7687784.1 | 658444 | g39710 | i0 | 46.8 | 6.34 | 47 | 24 | 94 | 1 | 148 | 8 | 270 | 315 | KAF7687784.1 hypothetical protein CDIK_3019 [Cucumispora dikerogammari] | diamond | 951 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Cucumispora | Cucumispora dikerogammari | ||||
| 29013779 | 29013779 | PRJNA889065_S_NODE_5748_length_393_cov_3.277143_g5510_i0 | PRJNA889065 | 5748 | 393 | 3.277143 | 12.87917199 | Enteropsectra breve | 1912989 | Fungi | Fungi | 57.4 | 4.6e-7 | NR | KAI5150402.1 | 1912989 | g5510 | i0 | 52.9 | 1.16030534351145 | 51 | 24 | 38.9 | 0 | 100 | 252 | 97 | 147 | KAI5150402.1 hypothetical protein ENBRE01_1476 [Enteropsectra breve] | diamond | 456 | 57.4 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enteropsectra | Enteropsectra breve | ||||
| 29084560 | 29084560 | PRJNA889065_S_NODE_29468_length_178_cov_0.925926_g29230_i0 | PRJNA889065 | 29468 | 178 | 0.925926 | 1.64814828 | Dubosqiidae | 103457 | Fungi | Fungi | 79 | 8.52e-17 | NR | KAG0441588.1 | 279532 | g29230 | i0 | 57.4 | 6.13483146067416 | 61 | 22 | 96.1 | 1 | 173 | 3 | 80 | 140 | KAG0441588.1 hypothetical protein DMUE_0934 [Dictyocoela muelleri] | diamond | 1092 | 79.7 | 0.991217063989962 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Dictyocoela | Dictyocoela muelleri | ||||
| 29834395 | 29834395 | PRJNA889065_S_NODE_9891_length_304_cov_1.773946_g9653_i0 | PRJNA889065 | 9891 | 304 | 1.773946 | 5.39279584 | Cucumispora dikerogammari | 658444 | Fungi | Fungi | 53.1 | 1.6e-5 | NR | KAF7684984.1 | 658444 | g9653 | i0 | 48.2 | 1.63815789473684 | 56 | 29 | 55.3 | 0 | 1 | 168 | 194 | 249 | KAF7684984.1 hypothetical protein CDIK_4267, partial [Cucumispora dikerogammari] | diamond | 498 | 53.1 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Cucumispora | Cucumispora dikerogammari | ||||
| 29865969 | 29865969 | PRJNA889065_S_NODE_28131_length_182_cov_2.647482_g27893_i0 | PRJNA889065 | 28131 | 182 | 2.647482 | 4.81841724 | Vairimorpha ceranae | 40302 | Fungi | Fungi | 41.6 | 0.0352 | NR | XP_024330525.1 | 40302 | g27893 | i0 | 55 | 1.17032967032967 | 40 | 18 | 65.9 | 0 | 49 | 168 | 139 | 178 | XP_024330525.1 putative transposase-like protein [Vairimorpha ceranae] | diamond | 213 | 41.6 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vairimorpha | Vairimorpha ceranae | |||
| 31066766 | 31066766 | PRJNA889065_S_NODE_13495_length_263_cov_1.359091_g13257_i0 | PRJNA889065 | 13495 | 263 | 1.359091 | 3.57440933 | Enteropsectra breve | 1912989 | Fungi | Fungi | 76.3 | 8.2e-16 | NR | KAI5151711.1 | 1912989 | g13257 | i0 | 48.8 | 0.958174904942966 | 84 | 41 | 94.7 | 2 | 250 | 2 | 3 | 85 | KAI5151711.1 hypothetical protein ENBRE01_2329 [Enteropsectra breve] | diamond | 252 | 76.3 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enteropsectra | Enteropsectra breve | ||||
| 31667273 | 31667273 | PRJNA889065_S_NODE_17577_length_232_cov_1.703704_g17339_i0 | PRJNA889065 | 17577 | 232 | 1.703704 | 3.95259328 | Dictyocoela muelleri | 279532 | Fungi | Fungi | 46.6 | 2.6e-4 | NR | KAG0424313.1 | 279532 | g17339 | i0 | 69.2 | 0.336206896551724 | 26 | 8 | 33.6 | 0 | 80 | 3 | 43 | 68 | KAG0424313.1 hypothetical protein DMUE_6098, partial [Dictyocoela muelleri] | diamond | 78 | 46.6 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Dictyocoela | Dictyocoela muelleri | ||||
| 31888669 | 31888669 | PRJNA889065_S_NODE_12417_length_273_cov_2.000000_g12179_i0 | PRJNA889065 | 12417 | 273 | 2 | 5.46 | Enteropsectra breve | 1912989 | Fungi | Fungi | 59.3 | 3.02e-8 | NR | KAI5153789.1 | 1912989 | g12179 | i0 | 44.3 | 2.30769230769231 | 70 | 39 | 76.9 | 0 | 273 | 64 | 105 | 174 | KAI5153789.1 hypothetical protein ENBRE01_3257, partial [Enteropsectra breve] | diamond | 630 | 59.3 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enteropsectra | Enteropsectra breve | ||||
| 31983623 | 31983623 | PRJNA889065_S_NODE_18678_length_225_cov_2.247253_g18440_i0 | PRJNA889065 | 18678 | 225 | 2.247253 | 5.05631925 | Anncaliia algerae PRA1 | 723287 | Fungi | Fungi | 56.2 | 4.22e-7 | NR | KCZ78782.1 | 1240240 | g18440 | i0 | 37.3 | 1.44 | 67 | 42 | 89.3 | 0 | 225 | 25 | 25 | 91 | KCZ78782.1 hypothetical protein H311_00181, partial [Anncaliia algerae PRA109] | diamond | 324 | 56.2 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Tubulinosematidae | Anncaliia | Anncaliia algerae | |||
| 32205247 | 32205247 | PRJNA889065_S_NODE_18318_length_227_cov_2.103261_g18080_i0 | PRJNA889065 | 18318 | 227 | 2.103261 | 4.77440247 | Cucumispora dikerogammari | 658444 | Fungi | Fungi | 72.8 | 8.64e-14 | NR | KAF7686015.1 | 658444 | g18080 | i0 | 70.2 | 0.621145374449339 | 47 | 10 | 56.8 | 1 | 130 | 2 | 46 | 92 | KAF7686015.1 Histone-lysine N-methyltransferase SETMAR [Cucumispora dikerogammari] | diamond | 141 | 72.8 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Cucumispora | Cucumispora dikerogammari | ||||
| 32213167 | 32213167 | PRJNA889065_S_NODE_10698_length_293_cov_2.200000_g10460_i0 | PRJNA889065 | 10698 | 293 | 2.2 | 6.446 | Opisthokonta | 33154 | Fungi | Fungi | 63.2 | 3.7e-9 | NR | KAF7684917.1 | 658444 | g10460 | i0 | 34.7 | 1.5358361774744 | 75 | 49 | 76.8 | 0 | 292 | 68 | 203 | 277 | KAF7684917.1 hypothetical protein CDIK_4334 [Cucumispora dikerogammari] | diamond | 450 | 63.2 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Cucumispora | Cucumispora dikerogammari | ||||
| 32742381 | 32742381 | PRJNA889065_S_NODE_6960_length_358_cov_4.882540_g6722_i0 | PRJNA889065 | 6960 | 358 | 4.88254 | 17.4794932 | Edhazardia aedis USNM 41457 | 1003232 | Fungi | Fungi | 63.2 | 9.24e-9 | NR | EJW03807.1 | 1003232 | g6722 | i0 | 41.6 | 0.645251396648045 | 77 | 44 | 63.7 | 1 | 129 | 356 | 123 | 199 | EJW03807.1 hypothetical protein EDEG_01899 [Edhazardia aedis USNM 41457] | diamond | 231 | 63.2 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Culicosporidae | Edhazardia | Edhazardia aedis |
Advanced export
JSON shape: default, array, newline-delimited
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);;