contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA690592" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27335487 | 27335487 | PRJNA690592_S_NODE_182123_length_253_cov_1.711111_g181109_i0 | PRJNA690592 | 182123 | 253 | 1.711111 | 4.32911083 | Spraguea lophii 42_11 | 51541 | Fungi | Fungi | 44.3 | 0.0118 | NR | EPR79613.1 | 1358809 | g181109 | i0 | 34.5 | 2.34782608695652 | 58 | 38 | 68.8 | 0 | 211 | 38 | 340 | 397 | EPR79613.1 Phospholipase D [Spraguea lophii 42_110] | diamond | 594 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Spragueidae | Spraguea | Spraguea lophii | |||
| 27840375 | 27840375 | PRJNA690592_S_NODE_187464_length_251_cov_0.865169_g186450_i0 | PRJNA690592 | 187464 | 251 | 0.865169 | 2.17157419 | Hamiltosporidium magnivora | 148818 | Fungi | Fungi | 43.9 | 0.0162 | NR | TBU07984.1 | 148818 | g186450 | i0 | 35.2 | 1.69721115537849 | 71 | 36 | 72.9 | 1 | 220 | 38 | 271 | 341 | TBU07984.1 hypothetical protein CWI39_0242p0010 [Hamiltosporidium magnivora] | diamond | 426 | 43.9 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Dubosqiidae | Hamiltosporidium | Hamiltosporidium magnivora | |||
| 28282414 | 28282414 | PRJNA690592_S_NODE_215986_length_241_cov_0.916667_g214972_i0 | PRJNA690592 | 215986 | 241 | 0.916667 | 2.20916747 | Encephalitozoon intestinalis ATCC 5 | 58839 | Fungi | Fungi | 110 | 2.38e-26 | NR | XP_003073950.1 | 876142 | g214972 | i0 | 70.5 | 10.7676348547718 | 78 | 19 | 97.1 | 1 | 240 | 7 | 262 | 335 | XP_003073950.1 AAA ATPase proteasome regulatory subunit YTA6 [Encephalitozoon intestinalis ATCC 50506] | diamond | 2595 | 110 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Unikaryonidae | Encephalitozoon | Encephalitozoon intestinalis | |||
| 28314341 | 28314341 | PRJNA690592_S_NODE_8626_length_966_cov_2.479283_g7934_i0 | PRJNA690592 | 8626 | 966 | 2.479283 | 23.94987378 | Tubulinosema ratisbonensis | 291195 | Fungi | Fungi | 50.8 | 0.00743 | NR | RVD92197.1 | 291195 | g7934 | i0 | 24.4 | 0.559006211180124 | 180 | 108 | 51.2 | 8 | 409 | 903 | 480 | 646 | RVD92197.1 Transcription initiation factor TFIID subunit [Tubulinosema ratisbonensis] | diamond | 540 | 50.8 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Tubulinosematidae | Tubulinosema | Tubulinosema ratisbonensis | |||
| 28945959 | 28945959 | PRJNA690592_S_NODE_3928_length_1312_cov_2.460856_g3505_i0 | PRJNA690592 | 3928 | 1312 | 2.460856 | 32.28643072 | Encephalitozoon intestinalis ATCC 5 | 58839 | Fungi | Fungi | 59.7 | 1.77e-5 | NR | XP_003072837.1 | 876142 | g3505 | i0 | 27.5 | 0.532774390243902 | 233 | 133 | 52.8 | 8 | 118 | 810 | 243 | 441 | XP_003072837.1 DNA mismatch repair protein MutL [Encephalitozoon intestinalis ATCC 50506] | diamond | 699 | 59.7 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Unikaryonidae | Encephalitozoon | Encephalitozoon intestinalis | |||
| 29399036 | 29399036 | PRJNA690592_S_NODE_206229_length_244_cov_1.087719_g205215_i0 | PRJNA690592 | 206229 | 244 | 1.087719 | 2.65403436 | Hamiltosporidium | 1176354 | Fungi | Fungi | 43.9 | 0.0144 | NR | TBU01232.1 | 148818 | g205215 | i0 | 56.7 | 0.737704918032787 | 30 | 13 | 36.9 | 0 | 101 | 12 | 342 | 371 | TBU01232.1 ubiquitin carboxyl-terminal hydrolase [Hamiltosporidium magnivora] | diamond | 180 | 43.9 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Dubosqiidae | Hamiltosporidium | Hamiltosporidium magnivora | |||
| 29450633 | 29450633 | PRJNA690592_S_NODE_65250_length_392_cov_1.219436_g64236_i0 | PRJNA690592 | 65250 | 392 | 1.219436 | 4.78018912 | Nematocida homosporus | 1912981 | Fungi | Fungi | 68.6 | 1.43e-10 | NR | XP_051345146.1 | 1912981 | g64236 | i0 | 39.1 | 3.48214285714286 | 92 | 56 | 70.4 | 0 | 328 | 53 | 56 | 147 | XP_051345146.1 cell division control protein 7 [Nematocida homosporus] | diamond | 1365 | 68.6 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nematocida | Nematocida homosporus | ||||
| 29829649 | 29829649 | PRJNA690592_S_NODE_143151_length_283_cov_0.833333_g142137_i0 | PRJNA690592 | 143151 | 283 | 0.833333 | 2.35833239 | Encephalitozoon cuniculi GB-M1 | 284813 | Fungi | Fungi | 67 | 1.04e-10 | NR | NP_585906.1 | 284813 | g142137 | i0 | 39.1 | 1.87632508833922 | 87 | 52 | 92.2 | 1 | 271 | 11 | 46 | 131 | NP_585906.1 uncharacterized protein ECU06_1490 [Encephalitozoon cuniculi GB-M1] | diamond | 531 | 67 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Unikaryonidae | Encephalitozoon | Encephalitozoon cuniculi | |||
| 29987797 | 29987797 | PRJNA690592_S_NODE_48911_length_443_cov_39.964865_g47897_i0 | PRJNA690592 | 48911 | 443 | 39.964865 | 177.04435195 | Nematocida parisii | 586133 | Fungi | Fungi | 45.4 | 0.00634 | NR | KAI5127592.1 | 586133 | g47897 | i0 | 42.6 | 0.36568848758465 | 54 | 30 | 36.6 | 1 | 230 | 391 | 61 | 113 | KAI5127592.1 dynein light chain LC8-type [Nematocida parisii] | diamond | 162 | 45.4 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nematocida | Nematocida parisii | ||||
| 30347201 | 30347201 | PRJNA690592_S_NODE_81712_length_356_cov_1.166078_g80698_i0 | PRJNA690592 | 81712 | 356 | 1.166078 | 4.15123768 | root | 1 | Root_unresolved | Root_unresolved | 48.5 | 0.00122 | NR | XP_065329800.1 | 6039 | g80698 | i0 | 43.4 | 7.12078651685393 | 53 | 30 | 44.7 | 0 | 228 | 70 | 347 | 399 | XP_065329800.1 ABC transporter (ATM1) [Vairimorpha necatrix] | diamond | 2535 | 48.9 | 0.991820040899796 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vairimorpha | Vairimorpha necatrix | |||
| 30650986 | 30650986 | PRJNA690592_S_NODE_63333_length_397_cov_0.950617_g62319_i0 | PRJNA690592 | 63333 | 397 | 0.950617 | 3.77394949 | Mitosporidium daphniae | 1485682 | Fungi | Fungi | 47.8 | 0.00312 | NR | XP_013237925.1 | 1485682 | g62319 | i0 | 40 | 0.340050377833753 | 45 | 27 | 34 | 0 | 229 | 363 | 301 | 345 | XP_013237925.1 uncharacterized protein DI09_33p150 [Mitosporidium daphniae] | diamond | 135 | 47.8 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Mitosporidium | Mitosporidium daphniae | ||||
| 31093618 | 31093618 | PRJNA690592_S_NODE_9115_length_944_cov_8.207807_g8404_i0 | PRJNA690592 | 9115 | 944 | 8.207807 | 77.48169808 | Astathelohania contejeani | 164912 | Fungi | Fungi | 207 | 4.7e-59 | NR | KAF7683727.1 | 164912 | g8404 | i0 | 47.7 | 0.765889830508475 | 241 | 121 | 75.3 | 4 | 909 | 199 | 245 | 484 | KAF7683727.1 ATP-dependent RNA helicase DBP2 [Astathelohania contejeani] | diamond | 723 | 207 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Astathelohaniidae | Astathelohania | Astathelohania contejeani | |||
| 31504807 | 31504807 | PRJNA690592_S_NODE_39336_length_488_cov_1.949398_g38324_i0 | PRJNA690592 | 39336 | 488 | 1.949398 | 9.51306224 | Ordospora colligata OC4 | 1354746 | Fungi | Fungi | 57 | 1.61e-6 | NR | XP_014563188.1 | 1354746 | g38324 | i0 | 40 | 1.10655737704918 | 90 | 51 | 54.1 | 2 | 280 | 17 | 71 | 159 | XP_014563188.1 Rab5-like GTPase [Ordospora colligata OC4] | diamond | 540 | 57 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Ordosporidae | Ordospora | Ordospora colligata | |||
| 32137292 | 32137292 | PRJNA690592_S_NODE_134458_length_290_cov_1.552995_g133444_i0 | PRJNA690592 | 134458 | 290 | 1.552995 | 4.5036855 | Dictyocoela muelleri | 279532 | Fungi | Fungi | 46.6 | 0.00259 | NR | KAG0438736.1 | 279532 | g133444 | i0 | 30.6 | 0.879310344827586 | 85 | 52 | 80.7 | 2 | 18 | 251 | 208 | 292 | KAG0438736.1 Guanine nucleotide-binding protein subunit beta-like protein [Dictyocoela muelleri] | diamond | 255 | 46.6 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Dictyocoela | Dictyocoela muelleri | ||||
| 32200572 | 32200572 | PRJNA690592_S_NODE_129218_length_295_cov_1.581081_g128204_i0 | PRJNA690592 | 129218 | 295 | 1.581081 | 4.66418895 | Hepatospora eriocheir | 1081669 | Fungi | Fungi | 46.6 | 0.00258 | NR | ORD95974.1 | 1081669 | g128204 | i0 | 40.7 | 0.6 | 59 | 34 | 59 | 1 | 110 | 283 | 129 | 187 | ORD95974.1 MRD1 [Hepatospora eriocheir] | diamond | 177 | 46.6 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Hepatosporidae | Hepatospora | Hepatospora eriocheir | |||
| 32485546 | 32485546 | PRJNA690592_S_NODE_35939_length_508_cov_2.190805_g34929_i0 | PRJNA690592 | 35939 | 508 | 2.190805 | 11.1292894 | Enterospora canceri | 1081671 | Fungi | Fungi | 53.1 | 1.05e-4 | NR | ORD94403.1 | 1081671 | g34929 | i0 | 28.2 | 0.732283464566929 | 124 | 85 | 73.2 | 1 | 54 | 425 | 129 | 248 | ORD94403.1 hypothetical protein ECANGB1_2793 [Enterospora canceri] | diamond | 372 | 53.1 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Enterospora | Enterospora canceri |
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);;