contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJNA993416" and tax_kingdom = "Fungi"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9903993 | 9903993 | PRJNA993416_P_NODE_13668_length_248_cov_0.880000_g13563_i0 | PRJNA993416 | 13668 | 248 | 0.88 | 2.1824 | Aspergillus ruber CBS 13568 | 396024 | Fungi | Fungi | 146 | 1.8e-39 | NR | XP_040640207.1 | 1388766 | g13563 | i0 | 89.2 | 2.68548387096774 | 74 | 8 | 89.5 | 0 | 223 | 2 | 21 | 94 | XP_040640207.1 nonsense-mediated mRNA decay protein 3 [Aspergillus ruber CBS 135680] | diamond | 666 | 146 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus ruber | |
| 17553718 | 17553718 | PRJNA993416_P_NODE_15474_length_243_cov_0.905882_g15369_i0 | PRJNA993416 | 15474 | 243 | 0.905882 | 2.20129326 | Fungi | 4751 | Fungi | Fungi | 92.8 | 9.36e-20 | NR | KAJ3354635.1 | 64505 | g15369 | i0 | 59.7 | 9.58024691358025 | 72 | 27 | 88.9 | 1 | 216 | 1 | 404 | 473 | KAJ3354635.1 DEIH-box ATPase [Allomyces javanicus] | diamond | 2328 | 92.8 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces javanicus | |
| 26715413 | 26715413 | PRJNA993416_P_NODE_15721_length_242_cov_0.911243_g15616_i0 | PRJNA993416 | 15721 | 242 | 0.911243 | 2.20520806 | Trichoderma | 5543 | Fungi | Fungi | 45.1 | 0.00552 | NR | XP_018656489.1 | 398673 | g15616 | i0 | 35.4 | 2.93801652892562 | 79 | 46 | 97.9 | 1 | 242 | 6 | 123 | 196 | XP_018656489.1 hypothetical protein TGAM01_v210907 [Trichoderma gamsii] | diamond | 711 | 45.4 | 0.993392070484582 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Hypocreaceae | Trichoderma | Trichoderma gamsii | |
| 27063945 | 27063945 | PRJNA993416_P_NODE_8382_length_288_cov_1.190698_g8277_i0 | PRJNA993416 | 8382 | 288 | 1.190698 | 3.42921024 | Fungi | 4751 | Fungi | Fungi | 103 | 2.7499999999999995e-23 | NR | KAJ3397893.1 | 4814 | g8277 | i0 | 55.1 | 9.67708333333333 | 78 | 34 | 80.2 | 1 | 16 | 246 | 88 | 165 | KAJ3397893.1 hypothetical protein HDU80_009402 [Chytriomyces hyalinus] | diamond | 2787 | 103 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Chytriomyces | Chytriomyces hyalinus | |
| 27279445 | 27279445 | PRJNA993416_P_NODE_16343_length_240_cov_2.670659_g16238_i0 | PRJNA993416 | 16343 | 240 | 2.670659 | 6.4095816 | Cladochytrium tenue | 1604274 | Fungi | Fungi | 42.7 | 0.0351 | NR | KAJ1554146.1 | 1604274 | g16238 | i0 | 60.5 | 0.5375 | 43 | 16 | 53.8 | 1 | 130 | 2 | 436 | 477 | KAJ1554146.1 hypothetical protein HK405_005893 [Cladochytrium tenue] | diamond | 129 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Cladochytriales | Cladochytriaceae | Cladochytrium | Cladochytrium tenue | |
| 27658530 | 27658530 | PRJNA993416_P_NODE_13664_length_248_cov_0.880000_g13559_i0 | PRJNA993416 | 13664 | 248 | 0.88 | 2.1824 | Lentithecium fluviatile CBS 122367 | 1168545 | Fungi | Fungi | 43.9 | 0.0141 | NR | KAF2677001.1 | 1168545 | g13559 | i0 | 41.3 | 0.556451612903226 | 46 | 27 | 55.6 | 0 | 148 | 11 | 190 | 235 | KAF2677001.1 hypothetical protein K458DRAFT_166946 [Lentithecium fluviatile CBS 122367] | diamond | 138 | 43.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Lentitheciaceae | Lentithecium | Lentithecium fluviatile | |
| 27784851 | 27784851 | PRJNA993416_P_NODE_7704_length_297_cov_1.750000_g7599_i0 | PRJNA993416 | 7704 | 297 | 1.75 | 5.1975 | Cercophora scortea | 314031 | Fungi | Fungi | 46.2 | 0.00125 | NR | KAK3335352.1 | 314031 | g7599 | i0 | 40.4 | 0.474747474747475 | 47 | 28 | 47.5 | 0 | 40 | 180 | 81 | 127 | KAK3335352.1 hypothetical protein B0T19DRAFT_5808 [Cercophora scortea] | diamond | 141 | 46.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Lasiosphaeriaceae | Cercophora | Cercophora scortea | |
| 28573910 | 28573910 | PRJNA993416_P_NODE_15427_length_243_cov_0.905882_g15322_i0 | PRJNA993416 | 15427 | 243 | 0.905882 | 2.20129326 | Dentiscutata heterogama | 1316150 | Fungi | Fungi | 49.7 | 1.33e-4 | NR | CAG8516676.1 | 1316150 | g15322 | i0 | 41.4 | 0.864197530864197 | 70 | 34 | 85.2 | 2 | 19 | 225 | 38 | 101 | CAG8516676.1 3403_t:CDS:2 [Dentiscutata heterogama] | diamond | 210 | 49.7 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Diversisporales | Gigasporaceae | Dentiscutata | Dentiscutata heterogama | |
| 28984712 | 28984712 | PRJNA993416_P_NODE_8928_length_283_cov_2.071429_g8823_i0 | PRJNA993416 | 8928 | 283 | 2.071429 | 5.86214407 | Rhizoctonia solani | 456999 | Fungi | Fungi | 45.4 | 0.00672 | NR | KAH7334455.1 | 456999 | g8823 | i0 | 34.4 | 0.646643109540636 | 61 | 40 | 64.7 | 0 | 79 | 261 | 64 | 124 | KAH7334455.1 hypothetical protein B0J17DRAFT_108148 [Rhizoctonia solani] | diamond | 183 | 45.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Ceratobasidiaceae | Rhizoctonia | Rhizoctonia solani | |
| 29237129 | 29237129 | PRJNA993416_P_NODE_10989_length_265_cov_1.281250_g10884_i0 | PRJNA993416 | 10989 | 265 | 1.28125 | 3.3953125 | Gaertneriomyces semiglobifer | 109897 | Fungi | Fungi | 69.7 | 1.32e-11 | NR | KAI9004755.1 | 109897 | g10884 | i0 | 42.5 | 1.96981132075472 | 87 | 33 | 98.5 | 1 | 3 | 263 | 174 | 243 | KAI9004755.1 P-loop containing nucleoside triphosphate hydrolase protein [Gaertneriomyces semiglobifer] | diamond | 522 | 69.7 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Gaertneriomyces | Gaertneriomyces semiglobifer | |
| 30437496 | 30437496 | PRJNA993416_P_NODE_15253_length_243_cov_1.705882_g15148_i0 | PRJNA993416 | 15253 | 243 | 1.705882 | 4.14529326 | Cordyceps sp. RAO-2 | 1755423 | Fungi | Fungi | 67 | 1.03e-10 | NR | PHH89725.1 | 2004951 | g15148 | i0 | 50.7 | 2.01234567901235 | 69 | 21 | 85.2 | 2 | 35 | 241 | 610 | 665 | PHH89725.1 hypothetical protein CDD83_5422 [Cordyceps sp. RAO-2017] | diamond | 489 | 67 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Cordycipitaceae | Cordyceps | Cordyceps sp. RAO-2017 | |
| 30626636 | 30626636 | PRJNA993416_P_NODE_13153_length_249_cov_0.875000_g13048_i0 | PRJNA993416 | 13153 | 249 | 0.875 | 2.17875 | Acaromyces ingoldii | 215250 | Fungi | Fungi | 42.7 | 0.0351 | NR | XP_025381164.1 | 215250 | g13048 | i0 | 62.9 | 0.421686746987952 | 35 | 12 | 42.2 | 1 | 227 | 123 | 47 | 80 | XP_025381164.1 thioredoxin-like protein [Acaromyces ingoldii] | diamond | 105 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Exobasidiales | Cryptobasidiaceae | Acaromyces | Acaromyces ingoldii | |
| 30658397 | 30658397 | PRJNA993416_P_NODE_6913_length_316_cov_0.876543_g6808_i0 | PRJNA993416 | 6913 | 316 | 0.876543 | 2.76987588 | Zopfochytrium polystomum | 2211651 | Fungi | Fungi | 46.2 | 0.00511 | NR | KAI9361605.1 | 2211651 | g6808 | i0 | 42 | 1.62341772151899 | 69 | 36 | 61.7 | 2 | 54 | 248 | 61 | 129 | KAI9361605.1 hypothetical protein DFJ73DRAFT_773407 [Zopfochytrium polystomum] | diamond | 513 | 46.2 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytridiaceae | Zopfochytrium | Zopfochytrium polystomum | |
| 30784771 | 30784771 | PRJNA993416_P_NODE_8994_length_283_cov_1.219048_g8889_i0 | PRJNA993416 | 8994 | 283 | 1.219048 | 3.44990584 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 157 | 3.3299999999999995e-42 | NR | XP_069229364.1 | 1052096 | g8889 | i0 | 81.3 | 0.964664310954064 | 91 | 17 | 96.5 | 0 | 10 | 282 | 260 | 350 | XP_069229364.1 uncharacterized protein WHR41_05489 [Cladosporium halotolerans] | diamond | 273 | 157 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 31005920 | 31005920 | PRJNA993416_P_NODE_15694_length_242_cov_0.911243_g15589_i0 | PRJNA993416 | 15694 | 242 | 0.911243 | 2.20520806 | Acaromyces ingoldii | 215250 | Fungi | Fungi | 46.6 | 0.00166 | NR | XP_025375574.1 | 215250 | g15589 | i0 | 43 | 0.979338842975207 | 79 | 37 | 95.5 | 2 | 240 | 10 | 873 | 945 | XP_025375574.1 kinesin-domain-containing protein [Acaromyces ingoldii] | diamond | 237 | 46.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Exobasidiales | Cryptobasidiaceae | Acaromyces | Acaromyces ingoldii | |
| 31416929 | 31416929 | PRJNA993416_P_NODE_9676_length_277_cov_1.357843_g9571_i0 | PRJNA993416 | 9676 | 277 | 1.357843 | 3.76122511 | Sungouiella intermedia | 45354 | Fungi | Fungi | 44.3 | 0.0167 | NR | SGZ55957.1 | 45354 | g9571 | i0 | 27.8 | 0.974729241877256 | 90 | 46 | 84.5 | 2 | 235 | 2 | 866 | 948 | SGZ55957.1 CIC11C00000001096 [Sungouiella intermedia] | diamond | 270 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Sungouiella | Sungouiella intermedia | |
| 31827930 | 31827930 | PRJNA993416_P_NODE_2057_length_603_cov_1.307547_g1954_i0 | PRJNA993416 | 2057 | 603 | 1.307547 | 7.88450841 | Podila verticillata | 78898 | Fungi | Fungi | 48.9 | 0.00631 | NR | KAF9379989.1 | 78898 | g1954 | i0 | 36.5 | 0.368159203980099 | 74 | 41 | 34.8 | 3 | 400 | 191 | 504 | 575 | KAF9379989.1 hypothetical protein CPB97_008632 [Podila verticillata] | diamond | 222 | 48.9 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Podila | Podila verticillata | |
| 32334644 | 32334644 | PRJNA993416_P_NODE_15139_length_244_cov_0.900585_g15034_i0 | PRJNA993416 | 15139 | 244 | 0.900585 | 2.1974274 | Epichloe bromicola | 79588 | Fungi | Fungi | 57.8 | 1.05e-7 | NR | GAB0147160.1 | 79588 | g15034 | i0 | 47.6 | 1.52459016393443 | 63 | 33 | 77.5 | 0 | 221 | 33 | 72 | 134 | GAB0147160.1 hypothetical protein EsHS_00007537 [Epichloe bromicola] | diamond | 372 | 57.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Clavicipitaceae | Epichloe | Epichloe bromicola | |
| 32461017 | 32461017 | PRJNA993416_P_NODE_2599_length_532_cov_2.952070_g2495_i0 | PRJNA993416 | 2599 | 532 | 2.95207 | 15.7050124 | Fusarium euwallaceae | 1147111 | Fungi | Fungi | 272 | 2.69e-85 | NR | RTE68074.1 | 1147111 | g2495 | i0 | 93.9 | 0.834586466165414 | 148 | 9 | 83.5 | 0 | 446 | 3 | 245 | 392 | RTE68074.1 hypothetical protein BHE90_017548, partial [Fusarium euwallaceae] | diamond | 444 | 272 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium euwallaceae | |
| 32587530 | 32587530 | PRJNA993416_P_NODE_11779_length_257_cov_1.342391_g11674_i0 | PRJNA993416 | 11779 | 257 | 1.342391 | 3.44994487 | Saitoella complicata NRRL Y-178 | 5606 | Fungi | Fungi | 72 | 2.2e-12 | NR | XP_019021730.1 | 698492 | g11674 | i0 | 53.8 | 1.52918287937743 | 65 | 29 | 74.7 | 1 | 196 | 5 | 455 | 519 | XP_019021730.1 uncharacterized protein SAICODRAFT_9885 [Saitoella complicata NRRL Y-17804] | diamond | 393 | 72 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saitoella | Saitoella complicata |
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);;