contig_metadata
22 rows where bioproject = "PRJNA560932", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3095652 | 3095652 | PRJNA560932_P_NODE_39543_length_289_cov_1.564815_g39187_i0 | PRJNA560932 | 39543 | 289 | 1.564815 | 4.52231535 | Dictyocoela muelleri | 279532 | Fungi | Fungi | 131 | 1.22e-36 | NR | KAG0440815.1 | 279532 | g39187 | i0 | 64.8 | 2.74048442906574 | 88 | 31 | 91.3 | 0 | 287 | 24 | 81 | 168 | KAG0440815.1 60S ribosomal protein L11 [Dictyocoela muelleri] | diamond | 792 | 131 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Dictyocoela | Dictyocoela muelleri | ||||
| 15847445 | 15847445 | PRJNA560932_P_NODE_28933_length_334_cov_1.440613_g28577_i0 | PRJNA560932 | 28933 | 334 | 1.440613 | 4.81164742 | Vairimorpha ceranae | 40302 | Fungi | Fungi | 98.6 | 1.6700000000000001e-22 | NR | XP_024332259.1 | 40302 | g28577 | i0 | 46.6 | 5.45209580838323 | 103 | 52 | 92.5 | 1 | 322 | 14 | 1 | 100 | XP_024332259.1 mrna deadenylase subunit [Vairimorpha ceranae] | diamond | 1821 | 98.6 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vairimorpha | Vairimorpha ceranae | |||
| 17122400 | 17122400 | PRJNA560932_P_NODE_40794_length_285_cov_1.547170_g40438_i0 | PRJNA560932 | 40794 | 285 | 1.54717 | 4.4094345 | Heterosporis sp. NBDP-2013a | 1289055 | Fungi | Fungi | 95.3 | 4.31e-15 | NTclustered | gi|448278458|gb|KC137554.1| | 1289055 | g40438 | i0 | 82.569 | 0.382456140350877 | 109 | 17 | 38 | 1 | 1 | 109 | 2856 | 2962 | Heterosporis sp. NBDP-2013a isolate MN/CISCO small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 109 | 95.3 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Heterosporis | Heterosporis sp. NBDP-2013a | |||
| 26966393 | 26966393 | PRJNA560932_P_NODE_2602_length_1021_cov_1.502110_g2356_i0 | PRJNA560932 | 2602 | 1021 | 1.50211 | 15.3365431 | Fungi | 4751 | Fungi | Fungi | 71.2 | 1.65e-9 | NR | XP_024331659.1 | 40302 | g2356 | i0 | 25.9 | 4.09010773751224 | 212 | 136 | 62.3 | 9 | 1007 | 372 | 312 | 502 | XP_024331659.1 dna replication factor a protein 1 [Vairimorpha ceranae] | diamond | 4176 | 71.6 | 0.994413407821229 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vairimorpha | Vairimorpha ceranae | |||
| 27251010 | 27251010 | PRJNA560932_P_NODE_8323_length_602_cov_2.487713_g7970_i0 | PRJNA560932 | 8323 | 602 | 2.487713 | 14.97603226 | Nematocida | 586132 | Fungi | Fungi | 95.9 | 2.39e-19 | NR | XP_067545174.1 | 1805483 | g7970 | i0 | 35.1 | 2.66611295681063 | 194 | 107 | 87.7 | 6 | 11 | 538 | 17 | 209 | XP_067545174.1 histone-binding protein RBBP4 [Nematocida displodere] | diamond | 1605 | 96.7 | 0.991726990692865 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nematocida | Nematocida displodere | ||||
| 27521322 | 27521322 | PRJNA560932_P_NODE_39863_length_288_cov_1.669767_g39507_i0 | PRJNA560932 | 39863 | 288 | 1.669767 | 4.80892896 | Amphiamblys sp. WSBS2 | 1866961 | Fungi | Fungi | 56.2 | 1.15e-6 | NR | OIR57392.1 | 1866961 | g39507 | i0 | 33.7 | 1.02083333333333 | 98 | 63 | 100 | 2 | 1 | 288 | 168 | 265 | OIR57392.1 MAG: Importin alpha subunit [Amphiamblys sp. WSBS2006] | diamond | 294 | 56.2 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Amphiacanthidae | Amphiamblys | Amphiamblys sp. WSBS2006 | |||
| 27711294 | 27711294 | PRJNA560932_P_NODE_46044_length_269_cov_1.571429_g45688_i0 | PRJNA560932 | 46044 | 269 | 1.571429 | 4.22714401 | Vairimorpha necatrix | 6039 | Fungi | Fungi | 72.8 | 1.22e-12 | NR | XP_065329013.1 | 6039 | g45688 | i0 | 47.9 | 1.04832713754647 | 94 | 38 | 98.1 | 3 | 3 | 266 | 300 | 388 | XP_065329013.1 E3 ubiquitin-protein ligase [Vairimorpha necatrix] | diamond | 282 | 72.8 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vairimorpha | Vairimorpha necatrix | |||
| 27788074 | 27788074 | PRJNA560932_P_NODE_43384_length_277_cov_1.941176_g43028_i0 | PRJNA560932 | 43384 | 277 | 1.941176 | 5.37705752 | Unikaryonidae | 36734 | Fungi | Fungi | 50.8 | 7.68e-5 | NR | UTX44965.1 | 58839 | g43028 | i0 | 38.8 | 1.61371841155235 | 67 | 40 | 71.5 | 1 | 22 | 219 | 233 | 299 | UTX44965.1 AAA domain-containing protein [Encephalitozoon intestinalis] | diamond | 447 | 51.2 | 0.9921875 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Unikaryonidae | Encephalitozoon | Encephalitozoon intestinalis | |||
| 28942459 | 28942459 | PRJNA560932_P_NODE_26708_length_346_cov_1.608059_g26352_i0 | PRJNA560932 | 26708 | 346 | 1.608059 | 5.56388414 | Ordospora colligata OC4 | 1354746 | Fungi | Fungi | 43.9 | 0.0317 | NR | XP_014564383.1 | 1354746 | g26352 | i0 | 33.8 | 0.69364161849711 | 80 | 46 | 63.3 | 1 | 222 | 4 | 3 | 82 | XP_014564383.1 Rab GTPase [Ordospora colligata OC4] | diamond | 240 | 43.9 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Ordosporidae | Ordospora | Ordospora colligata | |||
| 29321089 | 29321089 | PRJNA560932_P_NODE_62349_length_244_cov_0.900585_g61993_i0 | PRJNA560932 | 62349 | 244 | 0.900585 | 2.1974274 | Nematocida major | 1912982 | Fungi | Fungi | 68.6 | 2.77e-11 | NR | XP_047771023.1 | 1912982 | g61993 | i0 | 40.5 | 0.971311475409836 | 79 | 46 | 97.1 | 1 | 242 | 6 | 188 | 265 | XP_047771023.1 uncharacterized protein NEMAJ01_1228 [Nematocida major] | diamond | 237 | 68.6 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nematocida | Nematocida major | ||||
| 29889649 | 29889649 | PRJNA560932_P_NODE_58971_length_246_cov_1.780347_g58615_i0 | PRJNA560932 | 58971 | 246 | 1.780347 | 4.37965362 | Enteropsectra breve | 1912989 | Fungi | Fungi | 63.5 | 1.78e-9 | NR | KAI5153053.1 | 1912989 | g58615 | i0 | 61.7 | 0.573170731707317 | 47 | 18 | 57.3 | 0 | 188 | 48 | 457 | 503 | KAI5153053.1 DNA topoisomerase III, partial [Enteropsectra breve] | diamond | 141 | 63.5 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enteropsectra | Enteropsectra breve | ||||
| 30110590 | 30110590 | PRJNA560932_P_NODE_51392_length_252_cov_1.720670_g51036_i0 | PRJNA560932 | 51392 | 252 | 1.72067 | 4.3360884 | Vairimorpha ceranae | 40302 | Fungi | Fungi | 80.9 | 8.13e-16 | NR | XP_024332079.1 | 40302 | g51036 | i0 | 46.3 | 1.94047619047619 | 82 | 44 | 97.6 | 0 | 248 | 3 | 19 | 100 | XP_024332079.1 proline hydroxylase [Vairimorpha ceranae] | diamond | 489 | 80.9 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vairimorpha | Vairimorpha ceranae | |||
| 30774276 | 30774276 | PRJNA560932_P_NODE_36194_length_302_cov_1.344978_g35838_i0 | PRJNA560932 | 36194 | 302 | 1.344978 | 4.06183356 | Mitosporidium daphniae | 1485682 | Fungi | Fungi | 62 | 1.25e-8 | NR | XP_013239219.1 | 1485682 | g35838 | i0 | 40.7 | 0.804635761589404 | 81 | 46 | 78.5 | 1 | 13 | 249 | 108 | 188 | XP_013239219.1 uncharacterized protein DI09_136p80, partial [Mitosporidium daphniae] | diamond | 243 | 62 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Mitosporidium | Mitosporidium daphniae | ||||
| 31420187 | 31420187 | PRJNA560932_P_NODE_29556_length_331_cov_1.193798_g29200_i0 | PRJNA560932 | 29556 | 331 | 1.193798 | 3.95147138 | Eukaryota | 2759 | Fungi | Fungi | 47.8 | 0.0017 | NR | KAF7680963.1 | 164912 | g29200 | i0 | 33.3 | 1.67673716012085 | 87 | 58 | 78.9 | 0 | 298 | 38 | 48 | 134 | KAF7680963.1 Serine--tRNA ligase [Astathelohania contejeani] | diamond | 555 | 47.8 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Astathelohaniidae | Astathelohania | Astathelohania contejeani | |||
| 31469657 | 31469657 | PRJNA560932_P_NODE_22196_length_375_cov_6.698675_g21840_i0 | PRJNA560932 | 22196 | 375 | 6.698675 | 25.12003125 | Cucumispora dikerogammari | 658444 | Fungi | Fungi | 55.5 | 5.94e-7 | NR | KAF7699471.1 | 658444 | g21840 | i0 | 59.5 | 4.488 | 42 | 17 | 33.6 | 0 | 160 | 35 | 28 | 69 | KAF7699471.1 DNA-directed RNA polymerases I, II, and III subunit RPABC2 [Cucumispora dikerogammari] | diamond | 1683 | 55.5 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Cucumispora | Cucumispora dikerogammari | ||||
| 31469658 | 31469658 | PRJNA560932_P_NODE_23136_length_369_cov_0.976351_g22780_i0 | PRJNA560932 | 23136 | 369 | 0.976351 | 3.60273519 | Anncaliia algerae PRA1 | 723287 | Fungi | Fungi | 55.1 | 6.05e-6 | NR | KCZ78721.1 | 1240240 | g22780 | i0 | 36.7 | 1.46341463414634 | 90 | 55 | 72.4 | 2 | 103 | 369 | 106 | 194 | KCZ78721.1 hypothetical protein H311_00241, partial [Anncaliia algerae PRA109] | diamond | 540 | 55.1 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Tubulinosematidae | Anncaliia | Anncaliia algerae | |||
| 31501351 | 31501351 | PRJNA560932_P_NODE_63076_length_244_cov_0.900585_g62720_i0 | PRJNA560932 | 63076 | 244 | 0.900585 | 2.1974274 | Dictyocoela roeselum | 288439 | Fungi | Fungi | 66.6 | 1.15e-10 | NR | KAG0417321.1 | 288439 | g62720 | i0 | 41.3 | 0.922131147540984 | 75 | 44 | 92.2 | 0 | 235 | 11 | 33 | 107 | KAG0417321.1 Glutamine--fructose-6-phosphate aminotransferase [isomerizing], partial [Dictyocoela roeselum] | diamond | 225 | 66.6 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Dictyocoela | Dictyocoela roeselum | ||||
| 31912312 | 31912312 | PRJNA560932_P_NODE_21157_length_384_cov_1.170418_g20801_i0 | PRJNA560932 | 21157 | 384 | 1.170418 | 4.49440512 | Anncaliia algerae PRA1 | 723287 | Fungi | Fungi | 44.3 | 0.0446 | NR | KCZ74904.1 | 1240240 | g20801 | i0 | 29.2 | 0.828125 | 106 | 68 | 82.8 | 3 | 383 | 66 | 63 | 161 | KCZ74904.1 hypothetical protein H311_04126, partial [Anncaliia algerae PRA109] | diamond | 318 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Tubulinosematidae | Anncaliia | Anncaliia algerae | |||
| 32496012 | 32496012 | PRJNA560932_P_NODE_28499_length_336_cov_2.281369_g28143_i0 | PRJNA560932 | 28499 | 336 | 2.281369 | 7.66539984 | Hamiltosporidium | 1176354 | Fungi | Fungi | 92.4 | 3.89e-19 | NR | TBT99111.1 | 148818 | g28143 | i0 | 69.5 | 1.58035714285714 | 59 | 18 | 52.7 | 0 | 1 | 177 | 297 | 355 | TBT99111.1 hypothetical protein CWI39_2140p0010, partial [Hamiltosporidium magnivora] | diamond | 531 | 92.4 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Dubosqiidae | Hamiltosporidium | Hamiltosporidium magnivora | |||
| 32671063 | 32671063 | PRJNA560932_P_NODE_29040_length_333_cov_2.957692_g28684_i0 | PRJNA560932 | 29040 | 333 | 2.957692 | 9.84911436 | Encephalitozoon cuniculi GB-M1 | 284813 | Fungi | Fungi | 45.1 | 0.0136 | NR | NP_586288.1 | 284813 | g28684 | i0 | 38.5 | 1.15315315315315 | 78 | 38 | 64.9 | 3 | 234 | 19 | 30 | 103 | NP_586288.1 uncharacterized protein ECU10_1710 [Encephalitozoon cuniculi GB-M1] | diamond | 384 | 45.1 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Unikaryonidae | Encephalitozoon | Encephalitozoon cuniculi | |||
| 32796890 | 32796890 | PRJNA560932_P_NODE_3200_length_937_cov_2.519676_g2930_i0 | PRJNA560932 | 3200 | 937 | 2.519676 | 23.60936412 | Tubulinosema ratisbonensis | 291195 | Fungi | Fungi | 86.7 | 2.17e-15 | NR | RVD92594.1 | 291195 | g2930 | i0 | 51.3 | 0.745997865528282 | 80 | 39 | 25.6 | 0 | 530 | 291 | 6 | 85 | RVD92594.1 transcription factor [Tubulinosema ratisbonensis] | diamond | 699 | 86.7 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Tubulinosematidae | Tubulinosema | Tubulinosema ratisbonensis | |||
| 32811061 | 32811061 | PRJNA560932_P_NODE_51920_length_251_cov_1.297753_g51564_i0 | PRJNA560932 | 51920 | 251 | 1.297753 | 3.25736003 | Fungi | 4751 | Fungi | Fungi | 53.9 | 3.58e-7 | NR | KRH91823.1 | 146866 | g51564 | i0 | 68.8 | 1.14741035856574 | 32 | 10 | 38.2 | 0 | 154 | 249 | 17 | 48 | KRH91823.1 putative Mariner transposable element, partial [Pseudoloma neurophilia] | diamond | 288 | 53.9 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia |
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);;