contig_metadata
13 rows where bioproject = "PRJNA382357", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26822076 | 26822076 | PRJNA382357_P_NODE_40401_length_361_cov_1.096667_g39662_i0 | PRJNA382357 | 40401 | 361 | 1.096667 | 3.95896787 | Vittaforma corneae ATCC 5 | 42399 | Fungi | Fungi | 66.6 | 3.04e-10 | NR | XP_007603680.1 | 993615 | g39662 | i0 | 41 | 1.38781163434903 | 83 | 49 | 69 | 0 | 327 | 79 | 85 | 167 | XP_007603680.1 uncharacterized protein VICG_00227 [Vittaforma corneae ATCC 50505] | diamond | 501 | 66.6 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae | |||
| 27106525 | 27106525 | PRJNA382357_P_NODE_32202_length_399_cov_2.568047_g31463_i0 | PRJNA382357 | 32202 | 399 | 2.568047 | 10.24650753 | Nematocida sp. AWRm8 | 1927920 | Fungi | Fungi | 62 | 3.1e-8 | NR | KAI5182255.1 | 2670343 | g31463 | i0 | 32.3 | 1.50375939849624 | 124 | 80 | 90.2 | 2 | 3 | 362 | 64 | 187 | KAI5182255.1 hypothetical protein NEOKW01_2156, partial [Nematocida sp. AWRm80] | diamond | 600 | 62 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nematocida | Nematocida sp. AWRm80 | ||||
| 27169661 | 27169661 | PRJNA382357_P_NODE_24762_length_449_cov_1.417526_g24025_i0 | PRJNA382357 | 24762 | 449 | 1.417526 | 6.36469174 | Spraguea lophii 42_11 | 51541 | Fungi | Fungi | 60.5 | 1.93e-7 | NR | EPR79992.1 | 1358809 | g24025 | i0 | 45.9 | 1.14253897550111 | 61 | 32 | 40.8 | 1 | 259 | 441 | 277 | 336 | EPR79992.1 DEAD/DEAH box RNA helicase [Spraguea lophii 42_110] | diamond | 513 | 60.5 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Spragueidae | Spraguea | Spraguea lophii | |||
| 27517508 | 27517508 | PRJNA382357_P_NODE_70123_length_283_cov_0.981982_g69384_i0 | PRJNA382357 | 70123 | 283 | 0.981982 | 2.77900906 | Dictyocoela muelleri | 279532 | Fungi | Fungi | 53.5 | 8.72e-6 | NR | KAG0435040.1 | 279532 | g69384 | i0 | 48.8 | 0.45583038869258 | 43 | 22 | 45.6 | 0 | 16 | 144 | 191 | 233 | KAG0435040.1 hypothetical protein DMUE_4915 [Dictyocoela muelleri] | diamond | 129 | 53.5 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Dictyocoela | Dictyocoela muelleri | ||||
| 27675583 | 27675583 | PRJNA382357_P_NODE_3724_length_990_cov_3.625404_g3160_i0 | PRJNA382357 | 3724 | 990 | 3.625404 | 35.8914996 | Nematocida sp. AWRm8 | 1927920 | Fungi | Fungi | 110 | 8.09e-24 | NR | KAI5182255.1 | 2670343 | g3160 | i0 | 33.5 | 0.542424242424242 | 179 | 111 | 51.8 | 1 | 177 | 689 | 9 | 187 | KAI5182255.1 hypothetical protein NEOKW01_2156, partial [Nematocida sp. AWRm80] | diamond | 537 | 110 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nematocida | Nematocida sp. AWRm80 | ||||
| 28338453 | 28338453 | PRJNA382357_P_NODE_66626_length_289_cov_1.942982_g65887_i0 | PRJNA382357 | 66626 | 289 | 1.942982 | 5.61521798 | Nematocida sp. AWRm8 | 1927920 | Fungi | Fungi | 76.3 | 6.73e-14 | NR | KAI5182255.1 | 2670343 | g65887 | i0 | 43 | 0.892733564013841 | 86 | 49 | 89.3 | 0 | 3 | 260 | 18 | 103 | KAI5182255.1 hypothetical protein NEOKW01_2156, partial [Nematocida sp. AWRm80] | diamond | 258 | 76.3 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nematocida | Nematocida sp. AWRm80 | ||||
| 28780300 | 28780300 | PRJNA382357_P_NODE_7787_length_732_cov_1.955291_g7115_i0 | PRJNA382357 | 7787 | 732 | 1.955291 | 14.31273012 | Nematocida sp. AWRm8 | 1927920 | Fungi | Fungi | 118 | 1.4e-27 | NR | KAI5182255.1 | 2670343 | g7115 | i0 | 35 | 0.737704918032787 | 180 | 114 | 73 | 3 | 135 | 668 | 9 | 187 | KAI5182255.1 hypothetical protein NEOKW01_2156, partial [Nematocida sp. AWRm80] | diamond | 540 | 118 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nematocida | Nematocida sp. AWRm80 | ||||
| 29064689 | 29064689 | PRJNA382357_P_NODE_153028_length_203_cov_0.915493_g152289_i0 | PRJNA382357 | 153028 | 203 | 0.915493 | 1.85845079 | Nematocida sp. AWRm8 | 1927920 | Fungi | Fungi | 48.5 | 1.95e-4 | NR | KAI5182255.1 | 2670343 | g152289 | i0 | 39.1 | 0.945812807881773 | 64 | 37 | 91.6 | 1 | 15 | 200 | 22 | 85 | KAI5182255.1 hypothetical protein NEOKW01_2156, partial [Nematocida sp. AWRm80] | diamond | 192 | 48.5 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nematocida | Nematocida sp. AWRm80 | ||||
| 29474799 | 29474799 | PRJNA382357_P_NODE_82090_length_264_cov_1.359606_g81351_i0 | PRJNA382357 | 82090 | 264 | 1.359606 | 3.58935984 | Nematocida sp. AWRm8 | 1927920 | Fungi | Fungi | 65.5 | 3.95e-10 | NR | KAI5182255.1 | 2670343 | g81351 | i0 | 44.3 | 0.693181818181818 | 61 | 34 | 69.3 | 0 | 251 | 69 | 9 | 69 | KAI5182255.1 hypothetical protein NEOKW01_2156, partial [Nematocida sp. AWRm80] | diamond | 183 | 65.5 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nematocida | Nematocida sp. AWRm80 | ||||
| 29586416 | 29586416 | PRJNA382357_P_NODE_99370_length_243_cov_1.071429_g98631_i0 | PRJNA382357 | 99370 | 243 | 1.071429 | 2.60357247 | Opisthokonta | 33154 | Fungi | Fungi | 47 | 0.00122 | NR | XP_047770762.1 | 1912982 | g98631 | i0 | 48.9 | 1.91358024691358 | 45 | 23 | 55.6 | 0 | 135 | 1 | 91 | 135 | XP_047770762.1 heat shock 70kDa protein 1/2/6/8 [Nematocida major] | diamond | 465 | 47 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nematocida | Nematocida major | ||||
| 29790574 | 29790574 | PRJNA382357_P_NODE_34871_length_385_cov_1.731481_g34132_i0 | PRJNA382357 | 34871 | 385 | 1.731481 | 6.66620185 | Nematocida sp. AWRm8 | 1927920 | Fungi | Fungi | 60.5 | 1.11e-7 | NR | KAI5181997.1 | 2670343 | g34132 | i0 | 43.9 | 0.981818181818182 | 66 | 35 | 51.4 | 1 | 198 | 1 | 367 | 430 | KAI5181997.1 hypothetical protein NEOKW01_2139, partial [Nematocida sp. AWRm80] | diamond | 378 | 60.5 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nematocida | Nematocida sp. AWRm80 | ||||
| 30137941 | 30137941 | PRJNA382357_P_NODE_6812_length_772_cov_5.088608_g6156_i0 | PRJNA382357 | 6812 | 772 | 5.088608 | 39.28405376 | Nematocida sp. AWRm8 | 1927920 | Fungi | Fungi | 118 | 2.8700000000000003e-27 | NR | KAI5182255.1 | 2670343 | g6156 | i0 | 38 | 0.69559585492228 | 179 | 107 | 68 | 2 | 52 | 576 | 9 | 187 | KAI5182255.1 hypothetical protein NEOKW01_2156, partial [Nematocida sp. AWRm80] | diamond | 537 | 118 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nematocida | Nematocida sp. AWRm80 | ||||
| 32887524 | 32887524 | PRJNA382357_P_NODE_25120_length_446_cov_1.825974_g24382_i0 | PRJNA382357 | 25120 | 446 | 1.825974 | 8.14384404 | Nematocida sp. AWRm8 | 1927920 | Fungi | Fungi | 72.4 | 9.9e-12 | NR | KAI5182255.1 | 2670343 | g24382 | i0 | 37.5 | 0.699551569506726 | 104 | 65 | 70 | 0 | 27 | 338 | 27 | 130 | KAI5182255.1 hypothetical protein NEOKW01_2156, partial [Nematocida sp. AWRm80] | diamond | 312 | 72.4 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nematocida | Nematocida sp. AWRm80 |
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);;