contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA944406" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1259310 | 1259310 | PRJNA944406_P_NODE_13201_length_349_cov_6.242754_g12242_i0 | PRJNA944406 | 13201 | 349 | 6.242754 | 21.78721146 | Nosematidae | 27974 | Fungi | Fungi | 63.9 | 1.52e-5 | NTclustered | gi|2735586241|ref|XR_010574013.1| | 6039 | g12242 | i0 | 82.895 | 100.707736389685 | 76 | 7 | 22 | 5 | 274 | 349 | 2306 | 2237 | Vairimorpha necatrix 5.8S-23S ribosomal RNA (VNE69_07802), rRNA | blastn | 35147 | 63.9 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vairimorpha | Vairimorpha necatrix | |||
| 3475449 | 3475449 | PRJNA944406_P_NODE_563_length_1640_cov_13.778558_g303_i0 | PRJNA944406 | 563 | 1640 | 13.778558 | 225.9683512 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 741 | 0 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g303 | i0 | 85.226 | 13.4823170731707 | 731 | 96 | 93 | 12 | 8 | 731 | 1743 | 2468 | Enterocytozoon hepatopenaei strain SHFX2 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 22111 | 741 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 6027411 | 6027411 | PRJNA944406_P_NODE_16205_length_320_cov_3.522267_g15246_i0 | PRJNA944406 | 16205 | 320 | 3.522267 | 11.2712544 | Pleistophora mulleri | 249366 | Fungi | Fungi | 220 | 7.77e-53 | NTclustered | gi|134147422|gb|EF119339.1| | 249366 | g15246 | i0 | 96.269 | 13.35625 | 134 | 5 | 42 | 0 | 1 | 134 | 2973 | 2840 | Pleistophora mulleri 16S ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence | blastn | 4274 | 220 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Pleistophora | Pleistophora mulleri | |||
| 6027987 | 6027987 | PRJNA944406_P_NODE_64865_length_251_cov_0.865169_g63906_i0 | PRJNA944406 | 64865 | 251 | 0.865169 | 2.17157419 | Microsporidium sp. | 1844323 | Fungi | Fungi | 462 | 8.869999999999999e-126 | NTclustered | gi|1284874677|gb|KY615713.1| | 1844323 | g63906 | i0 | 100 | 98.398406374502 | 250 | 0 | 99 | 0 | 1 | 250 | 757 | 508 | Microsporidium sp. isolate EC small subunit ribosomal RNA gene, partial sequence | blastn | 24698 | 462 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Microsporidium | Microsporidium sp. | ||||
| 7302260 | 7302260 | PRJNA944406_P_NODE_11426_length_370_cov_2.269360_g10467_i0 | PRJNA944406 | 11426 | 370 | 2.26936 | 8.396632 | Neoflabelliforma dubium | 2995657 | Fungi | Fungi | 82.4 | 4.49e-11 | NTclustered | gi|2338497147|gb|OP881375.1| | 2995657 | g10467 | i0 | 80.342 | 1.08648648648649 | 117 | 15 | 30 | 8 | 21 | 132 | 2105 | 1992 | Neoflabelliforma sp. MQWeng-2022a isolate 3 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 402 | 82.4 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Dubosqiidae | Neoflabelliforma | Neoflabelliforma dubium | |||
| 7302461 | 7302461 | PRJNA944406_P_NODE_3086_length_774_cov_4.495007_g2255_i0 | PRJNA944406 | 3086 | 774 | 4.495007 | 34.79135418 | Enterocytozoon sp. ex Acetes sibogae australis | 2881109 | Fungi | Fungi | 985 | 0 | NTclustered | gi|2108103202|gb|OK413268.1| | 2881109 | g2255 | i0 | 89.767 | 97.7351421188631 | 772 | 76 | 99 | 2 | 4 | 774 | 1 | 770 | Enterocytozoon sp. ex Acetes sibogae australis isolate RA19015_21 small subunit ribosomal RNA gene, partial sequence | blastn | 75647 | 985 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Enterocytozoon | Enterocytozoon sp. ex Acetes sibogae australis | |||
| 7303033 | 7303033 | PRJNA944406_P_NODE_8186_length_437_cov_1.807692_g7229_i0 | PRJNA944406 | 8186 | 437 | 1.807692 | 7.89961404 | Mitosporidium daphniae | 1485682 | Fungi | Fungi | 69.4 | 4.19e-7 | NTclustered | gi|1378896647|gb|MF278562.1| | 1485682 | g7229 | i0 | 100 | 8.22883295194508 | 37 | 0 | 8 | 0 | 296 | 332 | 5304 | 5268 | Mitosporidium daphniae strain UGP3 small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 3596 | 69.4 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Mitosporidium | Mitosporidium daphniae | ||||
| 14013354 | 14013354 | PRJNA944406_P_NODE_23191_length_288_cov_2.865116_g22232_i0 | PRJNA944406 | 23191 | 288 | 2.865116 | 8.25153408 | Eukaryota | 2759 | Fungi | Fungi | 147 | 1.19e-30 | NTclustered | gi|113470857|gb|DQ680158.2| | 174680 | g22232 | i0 | 79.439 | 21.4826388888889 | 214 | 39 | 73 | 5 | 78 | 288 | 1972 | 1761 | Glugoides intestinalis isolate Gi3 23S ribosomal RNA gene, partial sequence; 23S-16S ribosomal RNA spacer, complete sequence; and 16S ribosomal RNA gene, partial sequence | blastn | 6187 | 148 | 0.993243243243243 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Glugeidae | Glugoides | Glugoides intestinalis | |||
| 14952037 | 14952037 | PRJNA944406_P_NODE_10372_length_387_cov_2.130573_g9413_i0 | PRJNA944406 | 10372 | 387 | 2.130573 | 8.24531751 | Vavraia culicis | 103449 | Fungi | Fungi | 102 | 3.62e-17 | NTclustered | gi|667636757|ref|XR_552273.1| | 948595 | g9413 | i0 | 83.186 | 0.291989664082687 | 113 | 18 | 29 | 1 | 245 | 357 | 1461 | 1572 | Vavraia culicis subsp. floridensis 28S ribosomal RNA (VCUG_02832), partial rRNA | blastn | 113 | 102 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Vavraia | Vavraia culicis | |||
| 17502958 | 17502958 | PRJNA944406_P_NODE_5874_length_530_cov_1.514223_g4923_i0 | PRJNA944406 | 5874 | 530 | 1.514223 | 8.0253819 | Vittaforma corneae | 42399 | Fungi | Fungi | 577 | 6.94e-160 | NTclustered | gi|667639983|ref|XR_552275.1| | 993615 | g4923 | i0 | 86.517 | 18.1660377358491 | 534 | 61 | 99 | 8 | 3 | 530 | 892 | 1420 | Vittaforma corneae ATCC 50505 28S ribosomal RNA (VICG_02297), rRNA | blastn | 9628 | 577 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae | |||
| 18776516 | 18776516 | PRJNA944406_P_NODE_59115_length_254_cov_2.541436_g58156_i0 | PRJNA944406 | 59115 | 254 | 2.541436 | 6.45524744 | uncultured Microsporidia | 546760 | Fungi | Fungi | 470 | 5.37e-128 | NTclustered | gi|2054360373|gb|MZ405774.1| | 546760 | g58156 | i0 | 100 | 99.9055118110236 | 254 | 0 | 100 | 0 | 1 | 254 | 267 | 14 | Uncultured Microsporidia clone OTU_9757 small subunit ribosomal RNA gene, partial sequence | blastn | 25376 | 470 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | uncultured Microsporidia | |||||
| 18776741 | 18776741 | PRJNA944406_P_NODE_79835_length_247_cov_2.459770_g78876_i0 | PRJNA944406 | 79835 | 247 | 2.45977 | 6.0756319 | Zelenkaia trichopterae | 462340 | Fungi | Fungi | 296 | 9.34e-76 | NTclustered | gi|156708226|gb|EF537879.1| | 462340 | g78876 | i0 | 88.306 | 4.51821862348178 | 248 | 27 | 100 | 2 | 1 | 247 | 287 | 533 | Zelenkaia trichopterae isolate Levishte small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 1116 | 296 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Zelenkaia | Zelenkaia trichopterae | ||||
| 20050885 | 20050885 | PRJNA944406_P_NODE_1656_length_1090_cov_3.481809_g1061_i0 | PRJNA944406 | 1656 | 1090 | 3.481809 | 37.9517181 | Pleistophora mulleri | 249366 | Fungi | Fungi | 1140 | 0 | NTclustered | gi|134147422|gb|EF119339.1| | 249366 | g1061 | i0 | 85.675 | 49.8045871559633 | 1103 | 131 | 99 | 17 | 1 | 1084 | 1373 | 2467 | Pleistophora mulleri 16S ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence | blastn | 54287 | 1140 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Pleistophora | Pleistophora mulleri | |||
| 20051166 | 20051166 | PRJNA944406_P_NODE_41176_length_271_cov_1.893939_g40217_i0 | PRJNA944406 | 41176 | 271 | 1.893939 | 5.13257469 | uncultured Microsporidium | 1142133 | Fungi | Fungi | 337 | 6.129999999999998e-88 | NTclustered | gi|525526975|gb|KC111788.1| | 1142133 | g40217 | i0 | 89.513 | 77.7564575645756 | 267 | 26 | 98 | 2 | 6 | 271 | 503 | 238 | Uncultured Microsporidium sp. clone Comp_E_Van9 18S ribosomal RNA gene, partial sequence | blastn | 21072 | 337 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Microsporidium | uncultured Microsporidium | ||||
| 22601172 | 22601172 | PRJNA944406_P_NODE_105858_length_242_cov_0.899408_g104899_i0 | PRJNA944406 | 105858 | 242 | 0.899408 | 2.17656736 | uncultured Microsporidium | 1142133 | Fungi | Fungi | 320 | 5.41e-83 | NTclustered | gi|525526968|gb|KC111781.1| | 1142133 | g104899 | i0 | 91.176 | 10.4380165289256 | 238 | 18 | 98 | 3 | 6 | 241 | 140 | 376 | Uncultured Microsporidium sp. clone Comp_BK_Van5 18S ribosomal RNA gene, partial sequence | blastn | 2526 | 320 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Microsporidium | uncultured Microsporidium | ||||
| 23876812 | 23876812 | PRJNA944406_P_NODE_17259_length_312_cov_2.899582_g16300_i0 | PRJNA944406 | 17259 | 312 | 2.899582 | 9.04669584 | Endoreticulatus sp. Zhenjiang | 550794 | Fungi | Fungi | 233 | 9.71e-57 | NTclustered | gi|671183987|gb|KJ784483.1| | 550794 | g16300 | i0 | 82.759 | 7.98717948717949 | 261 | 45 | 84 | 0 | 45 | 305 | 1004 | 1264 | Endoreticulatus sp. Zhenjiang alpha-tubulin mRNA, complete cds | blastn | 2492 | 233 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Endoreticulatus | Endoreticulatus sp. Zhenjiang | ||||
| 23877591 | 23877591 | PRJNA944406_P_NODE_8219_length_436_cov_3.730028_g7262_i0 | PRJNA944406 | 8219 | 436 | 3.730028 | 16.26292208 | Ecytonucleospora nucleophila | 1295219 | Fungi | Fungi | 560 | 5.66e-155 | NTclustered | gi|529283990|gb|KF135643.1| | 1295219 | g7262 | i0 | 90.566 | 89.0321100917431 | 424 | 38 | 97 | 2 | 1 | 423 | 872 | 1294 | Enterospora nucleophila isolate ENTA2 small subunit ribosomal RNA gene, partial sequence | blastn | 38818 | 560 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora nucleophila |
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);;