contig_metadata
14 rows where bioproject = "PRJNA1010780", tax_kingdom = "Fungi" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26876654 | 26876654 | PRJNA1010780_S_NODE_22401_length_356_cov_2.442368_g21112_i0 | PRJNA1010780 | 22401 | 356 | 2.442368 | 8.69483008 | Edhazardia aedis USNM 41457 | 1003232 | Fungi | Fungi | 53.1 | 1.31e-5 | NR | EJW04677.1 | 1003232 | g21112 | i0 | 35.4 | 0.691011235955056 | 82 | 51 | 69.1 | 2 | 19 | 264 | 87 | 166 | EJW04677.1 small GTP-binding protein domain [Edhazardia aedis USNM 41457] | diamond | 246 | 53.1 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Culicosporidae | Edhazardia | Edhazardia aedis | |||
| 27153038 | 27153038 | PRJNA1010780_S_NODE_57322_length_160_cov_1.160000_g56033_i0 | PRJNA1010780 | 57322 | 160 | 1.16 | 1.856 | Opisthokonta | 33154 | Fungi | Fungi | 76.3 | 1.86e-14 | NR | XP_065329163.1 | 6039 | g56033 | i0 | 69.2 | 20.68125 | 52 | 16 | 97.5 | 0 | 159 | 4 | 781 | 832 | XP_065329163.1 chromatin-remodeling atpase INO80 [Vairimorpha necatrix] | diamond | 3309 | 76.6 | 0.996083550913838 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vairimorpha | Vairimorpha necatrix | |||
| 27571751 | 27571751 | PRJNA1010780_S_NODE_46424_length_184_cov_3.812081_g45135_i0 | PRJNA1010780 | 46424 | 184 | 3.812081 | 7.01422904 | Pancytospora philotis | 1923975 | Fungi | Fungi | 48.5 | 1.56e-4 | NR | KAI4293013.1 | 1923975 | g45135 | i0 | 45.1 | 0.831521739130435 | 51 | 28 | 83.2 | 0 | 169 | 17 | 52 | 102 | KAI4293013.1 importin subunit alpha-6/7 [Pancytospora philotis] | diamond | 153 | 48.5 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pancytospora | Pancytospora philotis | ||||
| 27824486 | 27824486 | PRJNA1010780_S_NODE_32564_length_246_cov_1.530806_g31275_i0 | PRJNA1010780 | 32564 | 246 | 1.5308059999999999 | 3.76578276 | Hamiltosporidium magnivora | 148818 | Fungi | Fungi | 46.2 | 0.00222 | NR | TBU00038.1 | 148818 | g31275 | i0 | 35.5 | 1.85365853658537 | 76 | 46 | 90.2 | 2 | 21 | 242 | 45 | 119 | TBU00038.1 putative protein kinase [Hamiltosporidium magnivora] | diamond | 456 | 46.2 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Dubosqiidae | Hamiltosporidium | Hamiltosporidium magnivora | |||
| 27855879 | 27855879 | PRJNA1010780_S_NODE_47345_length_182_cov_1.632653_g46056_i0 | PRJNA1010780 | 47345 | 182 | 1.632653 | 2.97142846 | Dictyocoela muelleri | 279532 | Fungi | Fungi | 42.7 | 0.0153 | NR | KAG0422195.1 | 279532 | g46056 | i0 | 52.8 | 2.25824175824176 | 36 | 16 | 59.3 | 1 | 11 | 118 | 159 | 193 | KAG0422195.1 hypothetical protein DMUE_6228, partial [Dictyocoela muelleri] | diamond | 411 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Dictyocoela | Dictyocoela muelleri | ||||
| 28006456 | 28006456 | PRJNA1010780_S_NODE_4425_length_1289_cov_11.044657_g3982_i0 | PRJNA1010780 | 4425 | 1289 | 11.044657 | 142.36562873 | Eukaryota | 2759 | Fungi | Fungi | 53.9 | 0.00112 | NR | TBU01631.1 | 148818 | g3982 | i0 | 44.3 | 0.849495733126455 | 61 | 34 | 14.2 | 0 | 384 | 202 | 10 | 70 | TBU01631.1 DnaJ domain-containing protein, partial [Hamiltosporidium magnivora] | diamond | 1095 | 54.3 | 0.992633517495396 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Dubosqiidae | Hamiltosporidium | Hamiltosporidium magnivora | |||
| 28771555 | 28771555 | PRJNA1010780_S_NODE_55187_length_164_cov_1.333333_g53898_i0 | PRJNA1010780 | 55187 | 164 | 1.333333 | 2.18666612 | Mitosporidium daphniae | 1485682 | Fungi | Fungi | 77.4 | 7.6e-15 | NR | XP_013238259.1 | 1485682 | g53898 | i0 | 63 | 0.98780487804878 | 54 | 19 | 98.8 | 1 | 3 | 164 | 233 | 285 | XP_013238259.1 uncharacterized protein DI09_26p30 [Mitosporidium daphniae] | diamond | 162 | 77.4 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Mitosporidium | Mitosporidium daphniae | ||||
| 29434347 | 29434347 | PRJNA1010780_S_NODE_60490_length_154_cov_2.025210_g59201_i0 | PRJNA1010780 | 60490 | 154 | 2.02521 | 3.1188234 | Enterocytozoon bieneusi H348 | 481877 | Fungi | Fungi | 87.8 | 9.3e-19 | NR | EDQ31300.1 | 481877 | g59201 | i0 | 79.6 | 0.954545454545455 | 49 | 10 | 95.5 | 0 | 6 | 152 | 191 | 239 | EDQ31300.1 deacetylase [Enterocytozoon bieneusi H348] | diamond | 147 | 87.8 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Enterocytozoon | Enterocytozoon bieneusi | |||
| 29686930 | 29686930 | PRJNA1010780_S_NODE_43610_length_193_cov_2.841772_g42321_i0 | PRJNA1010780 | 43610 | 193 | 2.841772 | 5.48461996 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 43.1 | 0.014 | NR | KRH94673.1 | 146866 | g42321 | i0 | 34.3 | 1.04145077720207 | 67 | 41 | 99.5 | 1 | 192 | 1 | 110 | 176 | KRH94673.1 hypothetical protein M153_1720007693 [Pseudoloma neurophilia] | diamond | 201 | 43.1 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 29971392 | 29971392 | PRJNA1010780_S_NODE_25911_length_306_cov_2.369004_g24622_i0 | PRJNA1010780 | 25911 | 306 | 2.369004 | 7.24915224 | Pancytospora philotis | 1923975 | Fungi | Fungi | 61.6 | 1.82e-8 | NR | KAI4293007.1 | 1923975 | g24622 | i0 | 42.2 | 1.66666666666667 | 83 | 44 | 81.4 | 2 | 297 | 49 | 118 | 196 | KAI4293007.1 poly(A) polymerase [Pancytospora philotis] | diamond | 510 | 61.6 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pancytospora | Pancytospora philotis | ||||
| 30216515 | 30216515 | PRJNA1010780_S_NODE_47052_length_183_cov_1.243243_g45763_i0 | PRJNA1010780 | 47052 | 183 | 1.243243 | 2.27513469 | root | 1 | Root_unresolved | Root_unresolved | 55.8 | 4.08e-7 | NR | XP_007605206.1 | 993615 | g45763 | i0 | 43.9 | 12.0491803278689 | 57 | 32 | 93.4 | 0 | 1 | 171 | 438 | 494 | XP_007605206.1 RecQ family ATP-dependent DNA helicase [Vittaforma corneae ATCC 50505] | diamond | 2205 | 56.2 | 0.99288256227758 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae | |||
| 30477164 | 30477164 | PRJNA1010780_S_NODE_59913_length_155_cov_1.841667_g58624_i0 | PRJNA1010780 | 59913 | 155 | 1.841667 | 2.85458385 | Enteropsectra breve | 1912989 | Fungi | Fungi | 63.5 | 4.84e-10 | NR | KAI5151590.1 | 1912989 | g58624 | i0 | 53.1 | 0.948387096774194 | 49 | 23 | 94.8 | 0 | 155 | 9 | 295 | 343 | KAI5151590.1 hypothetical protein ENBRE01_2241 [Enteropsectra breve] | diamond | 147 | 63.5 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enteropsectra | Enteropsectra breve | ||||
| 30848582 | 30848582 | PRJNA1010780_S_NODE_58054_length_158_cov_2.260163_g56765_i0 | PRJNA1010780 | 58054 | 158 | 2.260163 | 3.57105754 | Hamiltosporidium | 1176354 | Fungi | Fungi | 50.8 | 4.47e-6 | NR | TBU01392.1 | 148818 | g56765 | i0 | 43.8 | 1.82278481012658 | 48 | 27 | 91.1 | 0 | 15 | 158 | 10 | 57 | TBU01392.1 putative subunit Rpb7 of DNA-directed RNA polymerase II [Hamiltosporidium magnivora] | diamond | 288 | 50.8 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Dubosqiidae | Hamiltosporidium | Hamiltosporidium magnivora | |||
| 32532615 | 32532615 | PRJNA1010780_S_NODE_60059_length_155_cov_1.525000_g58770_i0 | PRJNA1010780 | 60059 | 155 | 1.525 | 2.36375 | Cucumispora dikerogammari | 658444 | Fungi | Fungi | 47.8 | 1.91e-4 | NR | KAF7687796.1 | 658444 | g58770 | i0 | 56.4 | 0.754838709677419 | 39 | 16 | 75.5 | 1 | 118 | 2 | 664 | 701 | KAF7687796.1 Eukaryotic translation initiation factor 2 subunit gamma [Cucumispora dikerogammari] | diamond | 117 | 47.8 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Cucumispora | Cucumispora dikerogammari |
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);;