contig_metadata
21 rows where bioproject = "PRJNA994052", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1273288 | 1273288 | PRJNA994052_P_NODE_6961_length_376_cov_1665.366337_g5885_i0 | PRJNA994052 | 6961 | 376 | 1665.366337 | 6261.77742712 | Pleistophora | 35233 | Fungi | Fungi | 652 | 0 | NTclustered | gi|264683451|gb|GU126672.1| | 689837 | g5885 | i0 | 99.174 | 97.2287234042553 | 363 | 2 | 97 | 1 | 1 | 363 | 473 | 834 | Pleistophora hyphessobryconis 16S ribosomal RNA gene, partial sequence | blastn | 36558 | 652 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Pleistophora | Pleistophora hyphessobryconis | |||
| 7651325 | 7651325 | PRJNA994052_P_NODE_7706_length_365_cov_1680.801370_g6559_i0 | PRJNA994052 | 7706 | 365 | 1680.80137 | 6134.9250005 | Pleistophora | 35233 | Fungi | Fungi | 641 | 1.62e-179 | NTclustered | gi|264683451|gb|GU126672.1| | 689837 | g6559 | i0 | 99.16 | 98.5917808219178 | 357 | 2 | 98 | 1 | 9 | 365 | 828 | 473 | Pleistophora hyphessobryconis 16S ribosomal RNA gene, partial sequence | blastn | 35986 | 641 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Pleistophora | Pleistophora hyphessobryconis | |||
| 8629092 | 8629092 | PRJNA994052_P_NODE_11887_length_323_cov_79.436000_g10668_i0 | PRJNA994052 | 11887 | 323 | 79.436 | 256.57828 | Fusasporis stethaprioni | 2777717 | Fungi | Fungi | 451 | 2.5600000000000004e-122 | NTclustered | gi|1914073495|gb|MW077214.1| | 2777717 | g10668 | i0 | 93.443 | 81.5356037151703 | 305 | 19 | 94 | 1 | 13 | 316 | 789 | 485 | Fusasporis stethaprioni strain 2018 small subunit ribosomal RNA gene, partial sequence | blastn | 26336 | 451 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Glugeidae | Fusasporis | Fusasporis stethaprioni | |||
| 16575887 | 16575887 | PRJNA994052_P_NODE_77373_length_203_cov_144.938462_g76116_i0 | PRJNA994052 | 77373 | 203 | 144.938462 | 294.22507786 | Pleistophora | 35233 | Fungi | Fungi | 366 | 5.56e-97 | NTclustered | gi|264683451|gb|GU126672.1| | 689837 | g76116 | i0 | 99.502 | 98.8571428571429 | 201 | 1 | 99 | 0 | 1 | 201 | 1142 | 942 | Pleistophora hyphessobryconis 16S ribosomal RNA gene, partial sequence | blastn | 20068 | 366 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Pleistophora | Pleistophora hyphessobryconis | |||
| 20102764 | 20102764 | PRJNA994052_P_NODE_27536_length_288_cov_29.455814_g26295_i0 | PRJNA994052 | 27536 | 288 | 29.455814 | 84.83274432 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 525 | 1.3099999999999996e-144 | NTclustered | gi|11993647|gb|AF322654.1| | 146866 | g26295 | i0 | 99.65 | 100.673611111111 | 286 | 1 | 99 | 0 | 1 | 286 | 1627 | 1912 | Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 28994 | 525 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 22653307 | 22653307 | PRJNA994052_P_NODE_21438_length_305_cov_298.310345_g20211_i0 | PRJNA994052 | 21438 | 305 | 298.310345 | 909.84655225 | Vairimorpha ceranae | 40302 | Fungi | Fungi | 65.8 | 3.65e-6 | NTclustered | gi|1389532516|gb|MH349975.1| | 40302 | g20211 | i0 | 90.385 | 6.65901639344262 | 52 | 2 | 17 | 3 | 143 | 193 | 235 | 284 | Vairimorpha ceranae clone 7 small subunit ribosomal RNA gene, partial sequence | blastn | 2031 | 65.8 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vairimorpha | Vairimorpha ceranae | |||
| 22653924 | 22653924 | PRJNA994052_P_NODE_77278_length_203_cov_425.453846_g76021_i0 | PRJNA994052 | 77278 | 203 | 425.453846 | 863.67130738 | Microsporidium sp. LVPEI.SMW V3S1-FR | 1734473 | Fungi | Fungi | 313 | 7.3499999999999995e-81 | NTclustered | gi|937656209|gb|KR303710.1| | 1734473 | g76021 | i0 | 96.316 | 93.8374384236453 | 190 | 7 | 94 | 0 | 11 | 200 | 969 | 780 | Microsporidium sp. LVPEI.SMW V3S1-FR small subunit ribosomal RNA gene, partial sequence | blastn | 19049 | 313 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Microsporidium | Microsporidium sp. LVPEI.SMW V3S1-FR | ||||
| 23929430 | 23929430 | PRJNA994052_P_NODE_9939_length_340_cov_40.644195_g8733_i0 | PRJNA994052 | 9939 | 340 | 40.644195 | 138.190263 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 573 | 5.54e-159 | NTclustered | gi|11993647|gb|AF322654.1| | 146866 | g8733 | i0 | 95.906 | 97.6088235294118 | 342 | 12 | 100 | 2 | 1 | 340 | 470 | 811 | Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 33187 | 573 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 27500625 | 27500625 | PRJNA994052_P_NODE_55583_length_232_cov_94.685535_g54328_i0 | PRJNA994052 | 55583 | 232 | 94.685535 | 219.6704412 | Vittaforma corneae ATCC 5 | 42399 | Fungi | Fungi | 82.8 | 2.27e-17 | NR | XP_007605062.1 | 993615 | g54328 | i0 | 60.6 | 0.853448275862069 | 66 | 26 | 85.3 | 0 | 3 | 200 | 149 | 214 | XP_007605062.1 uncharacterized protein VICG_01617 [Vittaforma corneae ATCC 50505] | diamond | 198 | 82.8 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae | |||
| 27816428 | 27816428 | PRJNA994052_P_NODE_24364_length_296_cov_57.798206_g23129_i0 | PRJNA994052 | 24364 | 296 | 57.798206 | 171.08268976 | Trachipleistophora hominis | 72359 | Fungi | Fungi | 158 | 1.7699999999999996e-43 | NR | ELQ75429.1 | 72359 | g23129 | i0 | 82.8 | 0.881756756756757 | 87 | 11 | 84.1 | 1 | 292 | 44 | 446 | 532 | ELQ75429.1 putative Zinc finger, SWIM-type, Zinc finger, PMZ-type protein [Trachipleistophora hominis] | diamond | 261 | 158 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Trachipleistophora | Trachipleistophora hominis | |||
| 28163630 | 28163630 | PRJNA994052_P_NODE_52085_length_238_cov_5.333333_g50830_i0 | PRJNA994052 | 52085 | 238 | 5.333333 | 12.69333254 | Vittaforma corneae ATCC 5 | 42399 | Fungi | Fungi | 82.4 | 2.7e-18 | NR | XP_007604898.1 | 993615 | g50830 | i0 | 57.8 | 0.80672268907563 | 64 | 27 | 80.7 | 0 | 238 | 47 | 42 | 105 | XP_007604898.1 uncharacterized protein VICG_01452 [Vittaforma corneae ATCC 50505] | diamond | 192 | 82.4 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae | |||
| 28258085 | 28258085 | PRJNA994052_P_NODE_14386_length_314_cov_9.609959_g13165_i0 | PRJNA994052 | 14386 | 314 | 9.609959 | 30.17527126 | Vittaforma corneae ATCC 5 | 42399 | Fungi | Fungi | 167 | 5.98e-51 | NR | XP_007604393.1 | 993615 | g13165 | i0 | 85.1 | 0.898089171974522 | 94 | 11 | 86.9 | 1 | 308 | 36 | 53 | 146 | XP_007604393.1 uncharacterized protein VICG_00946 [Vittaforma corneae ATCC 50505] | diamond | 282 | 167 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae | |||
| 28447883 | 28447883 | PRJNA994052_P_NODE_78426_length_202_cov_66.961240_g77169_i0 | PRJNA994052 | 78426 | 202 | 66.96124 | 135.2617048 | Vittaforma corneae ATCC 5 | 42399 | Fungi | Fungi | 98.2 | 6.31e-22 | NR | XP_007605376.1 | 993615 | g77169 | i0 | 85.5 | 0.816831683168317 | 55 | 8 | 81.7 | 0 | 200 | 36 | 1316 | 1370 | XP_007605376.1 uncharacterized protein VICG_01931 [Vittaforma corneae ATCC 50505] | diamond | 165 | 98.2 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae | |||
| 28953144 | 28953144 | PRJNA994052_P_NODE_80088_length_200_cov_112.055118_g78831_i0 | PRJNA994052 | 80088 | 200 | 112.055118 | 224.110236 | Vavraia culicis subsp. floridensis | 948595 | Fungi | Fungi | 62.8 | 5.5e-10 | NR | XP_008074961.1 | 948595 | g78831 | i0 | 48.3 | 0.9 | 60 | 30 | 90 | 1 | 191 | 12 | 136 | 194 | XP_008074961.1 uncharacterized protein VCUG_01947 [Vavraia culicis subsp. floridensis] | diamond | 180 | 62.8 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Vavraia | Vavraia culicis | |||
| 29268457 | 29268457 | PRJNA994052_P_NODE_83089_length_197_cov_41.451613_g81832_i0 | PRJNA994052 | 83089 | 197 | 41.451613 | 81.65967761 | Vavraia culicis subsp. floridensis | 948595 | Fungi | Fungi | 52 | 1.11e-5 | NR | XP_008073558.1 | 948595 | g81832 | i0 | 56.4 | 0.593908629441624 | 39 | 17 | 59.4 | 0 | 191 | 75 | 180 | 218 | XP_008073558.1 uncharacterized protein VCUG_00538 [Vavraia culicis subsp. floridensis] | diamond | 117 | 52 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Vavraia | Vavraia culicis | |||
| 29527144 | 29527144 | PRJNA994052_P_NODE_69830_length_212_cov_159.640288_g68574_i0 | PRJNA994052 | 69830 | 212 | 159.640288 | 338.43741056 | Nosematidae | 27974 | Fungi | Fungi | 105 | 8.32e-28 | NR | XP_007603933.1 | 993615 | g68574 | i0 | 92.5 | 1.5 | 53 | 4 | 75 | 0 | 205 | 47 | 47 | 99 | XP_007603933.1 uncharacterized protein VICG_00481 [Vittaforma corneae ATCC 50505] | diamond | 318 | 105 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae | |||
| 30595077 | 30595077 | PRJNA994052_P_NODE_38613_length_261_cov_61.622340_g37367_i0 | PRJNA994052 | 38613 | 261 | 61.62234 | 160.8343074 | Vittaforma corneae ATCC 5 | 42399 | Fungi | Fungi | 138 | 1.0299999999999999e-38 | NR | XP_007604756.1 | 993615 | g37367 | i0 | 81.1 | 0.850574712643678 | 74 | 14 | 85.1 | 0 | 256 | 35 | 164 | 237 | XP_007604756.1 60S ribosomal protein L7 [Vittaforma corneae ATCC 50505] | diamond | 222 | 138 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae | |||
| 31606733 | 31606733 | PRJNA994052_P_NODE_64636_length_219_cov_70.541096_g63380_i0 | PRJNA994052 | 64636 | 219 | 70.541096 | 154.48500024 | Vittaforma corneae ATCC 5 | 42399 | Fungi | Fungi | 109 | 4.5e-29 | NR | XP_007604846.1 | 993615 | g63380 | i0 | 82.5 | 0.863013698630137 | 63 | 11 | 86.3 | 0 | 213 | 25 | 41 | 103 | XP_007604846.1 uncharacterized protein VICG_01400 [Vittaforma corneae ATCC 50505] | diamond | 189 | 109 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae | |||
| 31669929 | 31669929 | PRJNA994052_P_NODE_79357_length_201_cov_57.929688_g78100_i0 | PRJNA994052 | 79357 | 201 | 57.929688 | 116.43867288 | Vavraia culicis subsp. floridensis | 948595 | Fungi | Fungi | 43.9 | 0.00832 | NR | XP_008074988.1 | 948595 | g78100 | i0 | 51.4 | 0.552238805970149 | 37 | 18 | 55.2 | 0 | 193 | 83 | 600 | 636 | XP_008074988.1 uncharacterized protein VCUG_01973 [Vavraia culicis subsp. floridensis] | diamond | 111 | 43.9 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Vavraia | Vavraia culicis | |||
| 32397789 | 32397789 | PRJNA994052_P_NODE_49839_length_241_cov_70.696429_g48585_i0 | PRJNA994052 | 49839 | 241 | 70.696429 | 170.37839389 | Vittaforma corneae ATCC 5 | 42399 | Fungi | Fungi | 100 | 1.0999999999999998e-24 | NR | XP_007603575.1 | 993615 | g48585 | i0 | 70.6 | 0.846473029045643 | 68 | 20 | 84.6 | 0 | 239 | 36 | 115 | 182 | XP_007603575.1 uncharacterized protein VICG_00122 [Vittaforma corneae ATCC 50505] | diamond | 204 | 100 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae | |||
| 32870749 | 32870749 | PRJNA994052_P_NODE_74880_length_206_cov_108.248120_g73624_i0 | PRJNA994052 | 74880 | 206 | 108.24812 | 222.9911272 | Vavraia culicis subsp. floridensis | 948595 | Fungi | Fungi | 59.3 | 1.23e-8 | NR | XP_008074961.1 | 948595 | g73624 | i0 | 46.7 | 0.87378640776699 | 60 | 31 | 87.4 | 1 | 10 | 189 | 136 | 194 | XP_008074961.1 uncharacterized protein VCUG_01947 [Vavraia culicis subsp. floridensis] | diamond | 180 | 59.3 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Vavraia | Vavraia culicis |
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);;