contig_metadata
27 rows where analysis = "diamond", bioproject = "PRJNA724011" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13464165 | 13464165 | PRJNA724011_P_NODE_111151_length_235_cov_2.061728_g110128_i0 | PRJNA724011 | 111151 | 235 | 2.061728 | 4.8450608 | Eukaryota | 2759 | Fungi | Fungi | 103 | 1.0799999999999999e-23 | NR | KAF9762566.1 | 83296 | g110128 | i0 | 62.8 | 10.9276595744681 | 78 | 29 | 99.6 | 0 | 2 | 235 | 271 | 348 | KAF9762566.1 Serine palmitoyltransferase 2 [Nosema granulosis] | diamond | 2568 | 104 | 0.990384615384615 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema granulosis | |||
| 21113447 | 21113447 | PRJNA724011_P_NODE_78137_length_281_cov_1.879808_g77114_i0 | PRJNA724011 | 78137 | 281 | 1.879808 | 5.28226048 | Eukaryota | 2759 | Fungi | Fungi | 141 | 6.56e-38 | NR | KCZ81339.1 | 1288291 | g77114 | i0 | 88.3 | 33.6939501779359 | 77 | 9 | 82.2 | 0 | 2 | 232 | 178 | 254 | KCZ81339.1 hypothetical protein H312_01220 [Anncaliia algerae PRA339] | diamond | 9468 | 142 | 0.992957746478873 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Tubulinosematidae | Anncaliia | Anncaliia algerae | |||
| 27083750 | 27083750 | PRJNA724011_P_NODE_13902_length_823_cov_2.486667_g12975_i0 | PRJNA724011 | 13902 | 823 | 2.486667 | 20.46526941 | Vairimorpha apis BRL | 35231 | Fungi | Fungi | 198 | 1.4999999999999999e-58 | NR | EQB60565.1 | 1037528 | g12975 | i0 | 47.4 | 1.40704738760632 | 194 | 96 | 69.3 | 3 | 2 | 571 | 101 | 292 | EQB60565.1 casein kinase i [Vairimorpha apis BRL 01] | diamond | 1158 | 198 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vairimorpha | Vairimorpha apis | |||
| 27505151 | 27505151 | PRJNA724011_P_NODE_83943_length_269_cov_1.887755_g82920_i0 | PRJNA724011 | 83943 | 269 | 1.887755 | 5.07806095 | Nematocida | 586132 | Fungi | Fungi | 55.1 | 2.35e-6 | NR | XP_051333222.1 | 1912983 | g82920 | i0 | 53.5 | 2.14126394052045 | 43 | 18 | 45.7 | 1 | 129 | 7 | 107 | 149 | XP_051333222.1 ubiquitin carboxyl-terminal hydrolase 7 [Nematocida minor] | diamond | 576 | 55.1 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nematocida | Nematocida minor | ||||
| 28347016 | 28347016 | PRJNA724011_P_NODE_55886_length_343_cov_1.707407_g54863_i0 | PRJNA724011 | 55886 | 343 | 1.707407 | 5.85640601 | Enteropsectra breve | 1912989 | Fungi | Fungi | 50.1 | 2.83e-4 | NR | KAI5154673.1 | 1912989 | g54863 | i0 | 41.8 | 1.50437317784257 | 67 | 38 | 57.7 | 1 | 20 | 217 | 37 | 103 | KAI5154673.1 hypothetical protein ENBRE01_3435, partial [Enteropsectra breve] | diamond | 516 | 50.1 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enteropsectra | Enteropsectra breve | ||||
| 28567979 | 28567979 | PRJNA724011_P_NODE_49507_length_369_cov_1.040541_g48484_i0 | PRJNA724011 | 49507 | 369 | 1.040541 | 3.83959629 | Dictyocoela muelleri | 279532 | Fungi | Fungi | 58.2 | 6.41e-7 | NR | KAG0440682.1 | 279532 | g48484 | i0 | 34.5 | 1.92682926829268 | 113 | 61 | 89.4 | 4 | 330 | 1 | 223 | 325 | KAG0440682.1 GPI ethanolamine phosphate transferase 3 [Dictyocoela muelleri] | diamond | 711 | 58.2 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Dictyocoela | Dictyocoela muelleri | ||||
| 28725919 | 28725919 | PRJNA724011_P_NODE_47467_length_378_cov_1.727869_g46444_i0 | PRJNA724011 | 47467 | 378 | 1.727869 | 6.53134482 | Edhazardia aedis USNM 41457 | 1003232 | Fungi | Fungi | 106 | 4.69e-25 | NR | EJW03775.1 | 1003232 | g46444 | i0 | 44.2 | 0.896825396825397 | 113 | 58 | 89.7 | 2 | 377 | 39 | 88 | 195 | EJW03775.1 hypothetical protein EDEG_01931 [Edhazardia aedis USNM 41457] | diamond | 339 | 106 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Culicosporidae | Edhazardia | Edhazardia aedis | |||
| 28725927 | 28725927 | PRJNA724011_P_NODE_52407_length_356_cov_1.971731_g51384_i0 | PRJNA724011 | 52407 | 356 | 1.971731 | 7.01936236 | Dictyocoela muelleri | 279532 | Fungi | Fungi | 49.7 | 4.54e-4 | NR | KAG0434721.1 | 279532 | g51384 | i0 | 34.8 | 0.969101123595506 | 115 | 63 | 87.6 | 5 | 10 | 321 | 222 | 335 | KAG0434721.1 Choline-phosphate cytidylyltransferase B [Dictyocoela muelleri] | diamond | 345 | 49.7 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Dictyocoela | Dictyocoela muelleri | ||||
| 28788833 | 28788833 | PRJNA724011_P_NODE_110427_length_240_cov_4.053892_g109404_i0 | PRJNA724011 | 110427 | 240 | 4.053892 | 9.7293408 | Vairimorpha apis BRL | 35231 | Fungi | Fungi | 91.7 | 3.62e-20 | NR | EQB62048.1 | 1037528 | g109404 | i0 | 62.9 | 9.65 | 70 | 26 | 87.5 | 0 | 220 | 11 | 200 | 269 | EQB62048.1 dna replication factor c subunit [Vairimorpha apis BRL 01] | diamond | 2316 | 91.7 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vairimorpha | Vairimorpha apis | |||
| 29052202 | 29052202 | PRJNA724011_P_NODE_106628_length_243_cov_0.905882_g105605_i0 | PRJNA724011 | 106628 | 243 | 0.905882 | 2.20129326 | Eukaryota | 2759 | Fungi | Fungi | 89.7 | 1.09e-18 | NR | KAK6090075.1 | 40135 | g105605 | i0 | 55.7 | 5.87654320987654 | 79 | 33 | 97.5 | 1 | 7 | 243 | 12 | 88 | KAK6090075.1 hypothetical protein P3W45_000963 [Vairimorpha bombi] | diamond | 1428 | 89.7 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vairimorpha | Vairimorpha bombi | |||
| 29073473 | 29073473 | PRJNA724011_P_NODE_77988_length_282_cov_1.062201_g76965_i0 | PRJNA724011 | 77988 | 282 | 1.062201 | 2.99540682 | Enteropsectra breve | 1912989 | Fungi | Fungi | 62.8 | 5.34e-9 | NR | KAI5150025.1 | 1912989 | g76965 | i0 | 29.6 | 2.07446808510638 | 98 | 63 | 100 | 2 | 1 | 282 | 131 | 226 | KAI5150025.1 importin subunit alpha-6/7 [Enteropsectra breve] | diamond | 585 | 62.8 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enteropsectra | Enteropsectra breve | ||||
| 29136593 | 29136593 | PRJNA724011_P_NODE_104329_length_244_cov_1.350877_g103306_i0 | PRJNA724011 | 104329 | 244 | 1.350877 | 3.29613988 | Dictyocoela roeselum | 288439 | Fungi | Fungi | 90.1 | 3.27e-19 | NR | KAG0417511.1 | 288439 | g103306 | i0 | 46.8 | 1.90573770491803 | 79 | 41 | 97.1 | 1 | 238 | 2 | 7 | 84 | KAG0417511.1 DNA topoisomerase 2, partial [Dictyocoela roeselum] | diamond | 465 | 90.1 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Dictyocoela | Dictyocoela roeselum | ||||
| 29168123 | 29168123 | PRJNA724011_P_NODE_17889_length_705_cov_4.485759_g16891_i0 | PRJNA724011 | 17889 | 705 | 4.485759 | 31.62460095 | Dictyocoela muelleri | 279532 | Fungi | Fungi | 68.6 | 1.56e-9 | NR | KAG0426065.1 | 279532 | g16891 | i0 | 30.6 | 0.736170212765957 | 173 | 118 | 72.8 | 1 | 538 | 26 | 6 | 178 | KAG0426065.1 hypothetical protein DMUE_5992, partial [Dictyocoela muelleri] | diamond | 519 | 68.6 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Dictyocoela | Dictyocoela muelleri | ||||
| 29451810 | 29451810 | PRJNA724011_P_NODE_59390_length_331_cov_1.705426_g58367_i0 | PRJNA724011 | 59390 | 331 | 1.705426 | 5.64496006 | Nematocida sp. LUAm3 | 2670340 | Fungi | Fungi | 69.3 | 9.83e-12 | NR | KAI5172394.1 | 2670340 | g58367 | i0 | 29.5 | 0.95166163141994 | 105 | 72 | 95.2 | 1 | 330 | 16 | 7 | 109 | KAI5172394.1 Ras-related protein Rab-6A [Nematocida sp. LUAm3] | diamond | 315 | 69.3 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nematocida | Nematocida sp. LUAm3 | ||||
| 29672765 | 29672765 | PRJNA724011_P_NODE_13670_length_831_cov_4.795515_g12746_i0 | PRJNA724011 | 13670 | 831 | 4.795515 | 39.85072965 | Edhazardia aedis USNM 41457 | 1003232 | Fungi | Fungi | 130 | 4.16e-33 | NR | EJW04091.1 | 1003232 | g12746 | i0 | 38 | 2.06137184115523 | 208 | 116 | 74.4 | 4 | 765 | 148 | 9 | 205 | EJW04091.1 small GTP-binding protein domain [Edhazardia aedis USNM 41457] | diamond | 1713 | 130 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Culicosporidae | Edhazardia | Edhazardia aedis | |||
| 30115227 | 30115227 | PRJNA724011_P_NODE_29692_length_509_cov_1.658257_g28674_i0 | PRJNA724011 | 29692 | 509 | 1.658257 | 8.44052813 | Vavraia culicis subsp. floridensis | 948595 | Fungi | Fungi | 52.4 | 2.62e-5 | NR | XP_008073572.1 | 948595 | g28674 | i0 | 28.1 | 1.34970530451866 | 121 | 70 | 69 | 2 | 496 | 146 | 5 | 112 | XP_008073572.1 uncharacterized protein VCUG_00552 [Vavraia culicis subsp. floridensis] | diamond | 687 | 52.4 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Vavraia | Vavraia culicis | |||
| 30273595 | 30273595 | PRJNA724011_P_NODE_37912_length_436_cov_2.567493_g36889_i0 | PRJNA724011 | 37912 | 436 | 2.567493 | 11.19426948 | Pancytospora philotis | 1923975 | Fungi | Fungi | 85.9 | 5.28e-18 | NR | KAI4291392.1 | 1923975 | g36889 | i0 | 40.6 | 0.694954128440367 | 101 | 53 | 69.5 | 1 | 303 | 1 | 28 | 121 | KAI4291392.1 ubiquitin-conjugating enzyme E2 A [Pancytospora philotis] | diamond | 303 | 85.9 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pancytospora | Pancytospora philotis | ||||
| 30747248 | 30747248 | PRJNA724011_P_NODE_110254_length_241_cov_0.916667_g109231_i0 | PRJNA724011 | 110254 | 241 | 0.916667 | 2.20916747 | Dictyocoela muelleri | 279532 | Fungi | Fungi | 49.3 | 1.7e-4 | NR | KAG0438889.1 | 279532 | g109231 | i0 | 38.3 | 1.46887966804979 | 60 | 37 | 74.7 | 0 | 2 | 181 | 49 | 108 | KAG0438889.1 Retrovirus-related Pol polyprotein from transposon 17.6 [Dictyocoela muelleri] | diamond | 354 | 49.3 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Dictyocoela | Dictyocoela muelleri | ||||
| 31189245 | 31189245 | PRJNA724011_P_NODE_56995_length_339_cov_1.736842_g55972_i0 | PRJNA724011 | 56995 | 339 | 1.736842 | 5.88789438 | Amphiamblys sp. WSBS2 | 1866961 | Fungi | Fungi | 59.3 | 1.68e-7 | NR | OIR57869.1 | 1866961 | g55972 | i0 | 34.4 | 0.823008849557522 | 93 | 58 | 82.3 | 2 | 50 | 328 | 460 | 549 | OIR57869.1 MAG: DNA replication factor A protein 1 [Amphiamblys sp. WSBS2006] | diamond | 279 | 59.3 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Amphiacanthidae | Amphiamblys | Amphiamblys sp. WSBS2006 | |||
| 31379376 | 31379376 | PRJNA724011_P_NODE_102016_length_246_cov_0.890173_g100993_i0 | PRJNA724011 | 102016 | 246 | 0.890173 | 2.18982558 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 154 | 5.51e-45 | NR | KRH92994.1 | 146866 | g100993 | i0 | 100 | 0.98780487804878 | 81 | 0 | 98.8 | 0 | 244 | 2 | 26 | 106 | KRH92994.1 60S ribosomal protein L5 [Pseudoloma neurophilia] | diamond | 243 | 154 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 31632287 | 31632287 | PRJNA724011_P_NODE_2936_length_1743_cov_5.835928_g2570_i0 | PRJNA724011 | 2936 | 1743 | 5.835928 | 101.72022504 | Encephalitozoon romaleae SJ-2 | 571949 | Fungi | Fungi | 75.9 | 1.5e-10 | NR | XP_009265412.1 | 1178016 | g2570 | i0 | 30.1 | 0.987951807228916 | 156 | 105 | 26.3 | 3 | 22 | 480 | 13 | 167 | XP_009265412.1 polyadenylate-binding protein 2 [Encephalitozoon romaleae SJ-2008] | diamond | 1722 | 75.9 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Unikaryonidae | Encephalitozoon | Encephalitozoon romaleae | |||
| 31758881 | 31758881 | PRJNA724011_P_NODE_56637_length_340_cov_2.865169_g55614_i0 | PRJNA724011 | 56637 | 340 | 2.865169 | 9.7415746 | Nematocida minor | 1912983 | Fungi | Fungi | 57.8 | 6.02e-7 | NR | XP_051333857.1 | 1912983 | g55614 | i0 | 31.5 | 0.979411764705882 | 111 | 72 | 96.2 | 4 | 331 | 5 | 399 | 507 | XP_051333857.1 replication factor A1 [Nematocida minor] | diamond | 333 | 57.8 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nematocida | Nematocida minor | ||||
| 32233743 | 32233743 | PRJNA724011_P_NODE_28598_length_521_cov_1.491071_g27581_i0 | PRJNA724011 | 28598 | 521 | 1.491071 | 7.76847991 | Nosema bombycis CQ1 | 578461 | Fungi | Fungi | 45.8 | 0.0427 | NR | EOB14631.1 | 578461 | g27581 | i0 | 27.6 | 1.95777351247601 | 170 | 97 | 97.9 | 5 | 3 | 512 | 408 | 551 | EOB14631.1 DNA replication licensing factor MCM8, partial [Nosema bombycis CQ1] | diamond | 1020 | 45.8 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 32423395 | 32423395 | PRJNA724011_P_NODE_71839_length_296_cov_1.035874_g70816_i0 | PRJNA724011 | 71839 | 296 | 1.035874 | 3.06618704 | Nematocida sp. LUAm3 | 2670340 | Fungi | Fungi | 45.8 | 0.00593 | NR | KAI5171981.1 | 2670340 | g70816 | i0 | 52.6 | 0.760135135135135 | 38 | 18 | 38.5 | 0 | 119 | 6 | 304 | 341 | KAI5171981.1 hypothetical protein NEFER03_1246 [Nematocida sp. LUAm3] | diamond | 225 | 45.8 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nematocida | Nematocida sp. LUAm3 | ||||
| 32465557 | 32465557 | PRJNA724011_P_NODE_72919_length_293_cov_1.622727_g71896_i0 | PRJNA724011 | 72919 | 293 | 1.622727 | 4.75459011 | Eukaryota | 2759 | Fungi | Fungi | 117 | 1.22e-29 | NR | KAK1349500.1 | 1176355 | g71896 | i0 | 53.6 | 17.2320819112628 | 97 | 41 | 99.3 | 1 | 291 | 1 | 183 | 275 | KAK1349500.1 Serine/threonine-protein phosphatase PP2A-4 catalytic subunit [Hamiltosporidium tvaerminnensis] | diamond | 5049 | 118 | 0.991525423728814 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Dubosqiidae | Hamiltosporidium | Hamiltosporidium tvaerminnensis | |||
| 32675767 | 32675767 | PRJNA724011_P_NODE_70300_length_300_cov_1.017621_g69277_i0 | PRJNA724011 | 70300 | 300 | 1.017621 | 3.052863 | Nematocida displodere | 1805483 | Fungi | Fungi | 45.4 | 0.00738 | NR | XP_067545206.1 | 1805483 | g69277 | i0 | 41.5 | 1.99 | 53 | 31 | 53 | 0 | 296 | 138 | 27 | 79 | XP_067545206.1 uncharacterized protein NEDG_00080 [Nematocida displodere] | diamond | 597 | 45.4 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nematocida | Nematocida displodere | ||||
| 32896122 | 32896122 | PRJNA724011_P_NODE_108100_length_242_cov_0.911243_g107077_i0 | PRJNA724011 | 108100 | 242 | 0.911243 | 2.20520806 | Nosema bombycis CQ1 | 578461 | Fungi | Fungi | 118 | 2.4899999999999996e-29 | NR | EOB15468.1 | 578461 | g107077 | i0 | 63.2 | 3.80578512396694 | 76 | 28 | 94.2 | 0 | 1 | 228 | 295 | 370 | EOB15468.1 Diacylglycerol O-acyltransferase 1 [Nosema bombycis CQ1] | diamond | 921 | 118 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis |
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);;