contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA994052" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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);;