contig_metadata
13 rows where bioproject = "PRJNA727760" and tax_phylum = "Ascomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1988714 | 1988714 | PRJNA727760_S_NODE_2322_length_297_cov_2.089286_g2294_i0 | PRJNA727760 | 2322 | 297 | 2.089286 | 6.20517942 | Purpureocillium lilacinum | 33203 | Fungi | Fungi | 544 | 3.7299999999999996e-150 | NTclustered | gi|2741354647|ref|XM_065601239.1| | 33203 | g2294 | i0 | 99.663 | 1 | 297 | 1 | 100 | 0 | 1 | 297 | 795 | 499 | Purpureocillium lilacinum uncharacterized protein (PLICBS_007754), partial mRNA | blastn | 297 | 544 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Ophiocordycipitaceae | Purpureocillium | Purpureocillium lilacinum | |
| 3263976 | 3263976 | PRJNA727760_S_NODE_1663_length_357_cov_1.373239_g1635_i0 | PRJNA727760 | 1663 | 357 | 1.373239 | 4.90246323 | Pseudogymnoascus destructans | 655981 | Fungi | Fungi | 108 | 7.11e-19 | NTclustered | gi|1370889069|ref|XM_024471176.1| | 655981 | g1635 | i0 | 82.258 | 0.34733893557423 | 124 | 22 | 35 | 0 | 232 | 355 | 799 | 676 | Pseudogymnoascus destructans uncharacterized protein (VC83_07609), mRNA | blastn | 124 | 108 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Thelebolales | Thelebolaceae | Pseudogymnoascus | Pseudogymnoascus destructans | |
| 5816325 | 5816325 | PRJNA727760_S_NODE_1205_length_425_cov_1.551136_g1177_i0 | PRJNA727760 | 1205 | 425 | 1.551136 | 6.592328 | Metarhizium acridum | 92637 | Fungi | Fungi | 364 | 4.629999999999998e-96 | NTclustered | gi|2749718875|ref|XM_066119671.1| | 92637 | g1177 | i0 | 98.086 | 48.9364705882353 | 209 | 4 | 49 | 0 | 217 | 425 | 1388 | 1180 | Metarhizium acridum translation elongation factor EF-1 alpha (TEF1_1), partial mRNA | blastn | 20798 | 364 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Clavicipitaceae | Metarhizium | Metarhizium acridum | |
| 12674369 | 12674369 | PRJNA727760_S_NODE_2270_length_301_cov_1.561404_g2242_i0 | PRJNA727760 | 2270 | 301 | 1.561404 | 4.69982604 | Ascomycota | 4890 | Fungi | Fungi | 556 | 4.87e-154 | NTclustered | gi|1473258532|gb|MH871476.1| | 5046 | g2242 | i0 | 100 | 100.013289036545 | 301 | 0 | 100 | 0 | 1 | 301 | 307 | 7 | Sarocladium strictum culture CBS:376.70M strain CBS 376.70M large subunit ribosomal RNA gene, partial sequence | blastn | 30104 | 556 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium strictum | |
| 14741723 | 14741723 | PRJNA727760_S_NODE_3892_length_235_cov_2.888889_g3864_i0 | PRJNA727760 | 3892 | 235 | 2.888889 | 6.78888915 | Diaporthe batatas | 748121 | Fungi | Fungi | 139 | 1.57e-28 | NTclustered | gi|2124358414|ref|XM_044782441.1| | 748121 | g3864 | i0 | 100 | 32.6255319148936 | 75 | 0 | 32 | 0 | 1 | 75 | 1004 | 1078 | Diaporthe batatas guanine nucleotide-binding protein subunit beta (KVR01_001289), mRNA | blastn | 7667 | 139 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Diaporthales | Diaporthaceae | Diaporthe | Diaporthe batatas | |
| 16015182 | 16015182 | PRJNA727760_S_NODE_1413_length_388_cov_1.234921_g1385_i0 | PRJNA727760 | 1413 | 388 | 1.234921 | 4.79149348 | Colletotrichum destructivum | 34406 | Fungi | Fungi | 370 | 9.01e-98 | NTclustered | gi|2670800169|ref|XM_062922625.1| | 34406 | g1385 | i0 | 90.034 | 61.6520618556701 | 291 | 21 | 75 | 8 | 25 | 315 | 240 | 522 | Colletotrichum destructivum Putative cytochrome c, class IA/ IB, cytochrome c-like domain superfamily (CDEST_06466), mRNA | blastn | 23921 | 370 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Glomerellales | Glomerellaceae | Colletotrichum | Colletotrichum destructivum | |
| 25421379 | 25421379 | PRJNA727760_S_NODE_3220_length_257_cov_1.695652_g3192_i0 | PRJNA727760 | 3220 | 257 | 1.695652 | 4.35782564 | Pyricularia | 48558 | Fungi | Fungi | 132 | 2.9200000000000003e-26 | NTclustered | gi|389639323|ref|XM_003717247.1| | 242507 | g3192 | i0 | 95.181 | 13.5525291828794 | 83 | 4 | 32 | 0 | 1 | 83 | 443 | 525 | Pyricularia oryzae 70-15 histone H4 (MGG_06293), mRNA | blastn | 3483 | 132 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Magnaporthales | Pyriculariaceae | Pyricularia | Pyricularia oryzae | |
| 29262618 | 29262618 | PRJNA727760_S_NODE_2669_length_279_cov_1.893204_g2641_i0 | PRJNA727760 | 2669 | 279 | 1.893204 | 5.28203916 | Sarocladium strictum | 5046 | Fungi | Fungi | 58.9 | 1.08e-7 | NR | KAL2213322.1 | 5046 | g2641 | i0 | 47.8 | 0.741935483870968 | 69 | 25 | 67.7 | 2 | 12 | 200 | 325 | 388 | KAL2213322.1 concanavalin A-like lectin/glucanase [Sarocladium strictum] | diamond | 207 | 58.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium strictum | |
| 29767924 | 29767924 | PRJNA727760_S_NODE_2491_length_288_cov_1.813953_g2463_i0 | PRJNA727760 | 2491 | 288 | 1.813953 | 5.22418464 | Knufia fluminis | 191047 | Fungi | Fungi | 80.1 | 7.77e-17 | NR | KAK5953335.1 | 191047 | g2463 | i0 | 62.8 | 0.8125 | 78 | 21 | 72.9 | 1 | 287 | 78 | 53 | 130 | KAK5953335.1 hypothetical protein OHC33_005903 [Knufia fluminis] | diamond | 234 | 80.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Trichomeriaceae | Knufia | Knufia fluminis | |
| 29926095 | 29926095 | PRJNA727760_S_NODE_1631_length_361_cov_1.083333_g1603_i0 | PRJNA727760 | 1631 | 361 | 1.083333 | 3.91083213 | Purpureocillium lilacinum | 33203 | Fungi | Fungi | 68.9 | 9.7e-11 | NR | XP_018181215.1 | 33203 | g1603 | i0 | 89.1 | 0.914127423822715 | 55 | 6 | 45.7 | 0 | 361 | 197 | 813 | 867 | XP_018181215.1 translation initiation factor 3 subunit c [Purpureocillium lilacinum] | diamond | 330 | 68.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Ophiocordycipitaceae | Purpureocillium | Purpureocillium lilacinum | |
| 30431873 | 30431873 | PRJNA727760_S_NODE_1193_length_429_cov_1.558989_g1165_i0 | PRJNA727760 | 1193 | 429 | 1.558989 | 6.68806281 | Sarocladium strictum | 5046 | Fungi | Fungi | 137 | 6.74e-39 | NR | KAK0385092.1 | 5046 | g1165 | i0 | 95.3 | 0.741258741258741 | 106 | 2 | 72 | 1 | 429 | 121 | 17 | 122 | KAK0385092.1 hypothetical protein NLU13_7570 [Sarocladium strictum] | diamond | 318 | 137 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium strictum | |
| 31157796 | 31157796 | PRJNA727760_S_NODE_3375_length_252_cov_1.284916_g3347_i0 | PRJNA727760 | 3375 | 252 | 1.284916 | 3.23798832 | Talaromyces marneffei | 37727 | Fungi | Fungi | 57 | 1.65e-8 | NR | XP_054121538.1 | 37727 | g3347 | i0 | 46.4 | 0.821428571428571 | 69 | 34 | 82.1 | 1 | 252 | 46 | 8 | 73 | XP_054121538.1 uncharacterized protein EYB26_006287 [Talaromyces marneffei] | diamond | 207 | 57 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Trichocomaceae | Talaromyces | Talaromyces marneffei | |
| 31822168 | 31822168 | PRJNA727760_S_NODE_2557_length_284_cov_3.322275_g2529_i0 | PRJNA727760 | 2557 | 284 | 3.322275 | 9.435261 | Sarocladium strictum | 5046 | Fungi | Fungi | 92 | 3.8e-21 | NR | KAK0386860.1 | 5046 | g2529 | i0 | 86.4 | 0.623239436619718 | 59 | 8 | 62.3 | 0 | 280 | 104 | 107 | 165 | KAK0386860.1 hypothetical protein NLU13_5173 [Sarocladium strictum] | diamond | 177 | 92 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium strictum |
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);;