contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA1120586" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2826642 | 2826642 | PRJNA1120586_P_NODE_28523_length_265_cov_1.469388_g28332_i0 | PRJNA1120586 | 28523 | 265 | 1.469388 | 3.8938782 | Dactylellina cionopaga | 47266 | Fungi | Fungi | 152 | 5.4699999999999986e-43 | NR | KAF3932129.1 | 47266 | g28332 | i0 | 75 | 5.97735849056604 | 88 | 22 | 99.6 | 0 | 265 | 2 | 131 | 218 | KAF3932129.1 Beta-TrCP [Dactylellina cionopaga] | diamond | 1584 | 152 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Orbiliomycetes | Orbiliales | Orbiliaceae | Dactylellina | Dactylellina cionopaga | |
| 26753220 | 26753220 | PRJNA1120586_P_NODE_35601_length_245_cov_1.403409_g35410_i0 | PRJNA1120586 | 35601 | 245 | 1.403409 | 3.43835205 | Recurvomyces mirabilis | 574656 | Fungi | Fungi | 44.3 | 0.0109 | NR | XP_064690326.1 | 574656 | g35410 | i0 | 32.9 | 0.857142857142857 | 70 | 44 | 84.5 | 2 | 236 | 30 | 382 | 449 | XP_064690326.1 uncharacterized protein LTS14_009436 [Recurvomyces mirabilis] | diamond | 210 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Recurvomyces | Recurvomyces mirabilis | |
| 27291406 | 27291406 | PRJNA1120586_P_NODE_16883_length_317_cov_1.120968_g16692_i0 | PRJNA1120586 | 16883 | 317 | 1.120968 | 3.55346856 | Nosema granulosis | 83296 | Fungi | Fungi | 81.3 | 2.3e-16 | NR | KAF9761595.1 | 83296 | g16692 | i0 | 48 | 0.946372239747634 | 100 | 48 | 90.9 | 1 | 14 | 301 | 55 | 154 | KAF9761595.1 hypothetical protein NGRA_2537 [Nosema granulosis] | diamond | 300 | 81.3 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema granulosis | |||
| 27954534 | 27954534 | PRJNA1120586_P_NODE_38305_length_238_cov_1.704142_g38114_i0 | PRJNA1120586 | 38305 | 238 | 1.704142 | 4.05585796 | Nosema granulosis | 83296 | Fungi | Fungi | 62 | 2.56e-9 | NR | KAF9764754.1 | 83296 | g38114 | i0 | 39.7 | 0.983193277310924 | 78 | 47 | 98.3 | 0 | 235 | 2 | 11 | 88 | KAF9764754.1 Spore wall protein [Nosema granulosis] | diamond | 234 | 62 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema granulosis | |||
| 28733221 | 28733221 | PRJNA1120586_P_NODE_48567_length_229_cov_0.900000_g48376_i0 | PRJNA1120586 | 48567 | 229 | 0.9 | 2.061 | Nectriaceae | 110618 | Fungi | Fungi | 92.4 | 4.8700000000000005e-21 | NR | KAF5667939.1 | 42747 | g48376 | i0 | 84.3 | 6.6943231441048 | 51 | 8 | 66.8 | 0 | 153 | 1 | 125 | 175 | KAF5667939.1 MADS-box transcription protein [Fusarium heterosporum] | diamond | 1533 | 92.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium heterosporum | |
| 29017654 | 29017654 | PRJNA1120586_P_NODE_47768_length_229_cov_0.900000_g47577_i0 | PRJNA1120586 | 47768 | 229 | 0.9 | 2.061 | Leotiomycetes | 147548 | Fungi | Fungi | 109 | 1.14e-25 | NR | CZT51112.1 | 38038 | g47577 | i0 | 91.2 | 2.24017467248908 | 57 | 5 | 74.7 | 0 | 2 | 172 | 383 | 439 | CZT51112.1 related to archipelago beta form (F-box-WD40 repeat protein) [Rhynchosporium secalis] | diamond | 513 | 109 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Ploettnerulaceae | Rhynchosporium | Rhynchosporium secalis | |
| 29501514 | 29501514 | PRJNA1120586_P_NODE_42430_length_233_cov_0.878049_g42239_i0 | PRJNA1120586 | 42430 | 233 | 0.878049 | 2.04585417 | Apiospora kogelbergensis | 1337665 | Fungi | Fungi | 43.5 | 0.0179 | NR | XP_066734597.1 | 1337665 | g42239 | i0 | 30.4 | 0.888412017167382 | 69 | 48 | 88.8 | 0 | 207 | 1 | 773 | 841 | XP_066734597.1 ATP-dependent DNA helicase 2 subunit 1 [Apiospora kogelbergensis] | diamond | 207 | 43.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Amphisphaeriales | Apiosporaceae | Apiospora | Apiospora kogelbergensis | |
| 30164664 | 30164664 | PRJNA1120586_P_NODE_43952_length_232_cov_0.883436_g43761_i0 | PRJNA1120586 | 43952 | 232 | 0.883436 | 2.04957152 | Nosema granulosis | 83296 | Fungi | Fungi | 120 | 2.5199999999999997e-30 | NR | KAF9764715.1 | 83296 | g43761 | i0 | 77.9 | 0.995689655172414 | 77 | 17 | 99.6 | 0 | 2 | 232 | 148 | 224 | KAF9764715.1 Inositol-1,4,5-trisphosphate 5-phosphatase 1 [Nosema granulosis] | diamond | 231 | 120 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema granulosis | |||
| 30354945 | 30354945 | PRJNA1120586_P_NODE_41652_length_234_cov_0.872727_g41461_i0 | PRJNA1120586 | 41652 | 234 | 0.872727 | 2.04218118 | Gyrodon lividus | 85971 | Fungi | Fungi | 41.6 | 0.0449 | NR | KAF9228331.1 | 85971 | g41461 | i0 | 44.7 | 0.487179487179487 | 38 | 21 | 48.7 | 0 | 173 | 60 | 10 | 47 | KAF9228331.1 hypothetical protein BS17DRAFT_692150 [Gyrodon lividus] | diamond | 114 | 41.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Gyrodontaceae | Gyrodon | Gyrodon lividus | |
| 30449448 | 30449448 | PRJNA1120586_P_NODE_44393_length_232_cov_0.883436_g44202_i0 | PRJNA1120586 | 44393 | 232 | 0.883436 | 2.04957152 | Sarocladium strictum | 5046 | Fungi | Fungi | 75.5 | 4.04e-14 | NR | KAK0387188.1 | 5046 | g44202 | i0 | 79.5 | 0.504310344827586 | 39 | 8 | 50.4 | 0 | 119 | 3 | 1 | 39 | KAK0387188.1 hypothetical protein NLU13_5501 [Sarocladium strictum] | diamond | 117 | 75.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium strictum | |
| 30891723 | 30891723 | PRJNA1120586_P_NODE_34594_length_247_cov_2.988764_g34403_i0 | PRJNA1120586 | 34594 | 247 | 2.988764 | 7.38224708 | Friedmanniomyces endolithicus | 329885 | Fungi | Fungi | 124 | 1.59e-33 | NR | KAK0331223.1 | 329885 | g34403 | i0 | 92.6 | 0.983805668016194 | 81 | 6 | 98.4 | 0 | 4 | 246 | 12 | 92 | KAK0331223.1 hypothetical protein LTR94_029781, partial [Friedmanniomyces endolithicus] | diamond | 243 | 124 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Friedmanniomyces | Friedmanniomyces endolithicus | |
| 30923397 | 30923397 | PRJNA1120586_P_NODE_49694_length_228_cov_0.905660_g49503_i0 | PRJNA1120586 | 49694 | 228 | 0.90566 | 2.0649048 | Hapsidospora chrysogenum ATCC 1155 | 5044 | Fungi | Fungi | 49.7 | 1.13e-4 | NR | KFH48892.1 | 857340 | g49503 | i0 | 41 | 0.802631578947368 | 61 | 33 | 76.3 | 2 | 225 | 52 | 679 | 739 | KFH48892.1 PHD finger protein-like protein-like protein [Hapsidospora chrysogenum ATCC 11550] | diamond | 183 | 49.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Bionectriaceae | Hapsidospora | Hapsidospora chrysogena | |
| 31081245 | 31081245 | PRJNA1120586_P_NODE_44395_length_232_cov_0.883436_g44204_i0 | PRJNA1120586 | 44395 | 232 | 0.883436 | 2.04957152 | Endocarpon pusillum | 364733 | Fungi | Fungi | 105 | 3.66e-24 | NR | KAF7510634.1 | 364733 | g44204 | i0 | 72.7 | 0.995689655172414 | 77 | 21 | 99.6 | 0 | 1 | 231 | 584 | 660 | KAF7510634.1 hypothetical protein GJ744_006246 [Endocarpon pusillum] | diamond | 231 | 105 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Verrucariales | Verrucariaceae | Endocarpon | Endocarpon pusillum | |
| 31745107 | 31745107 | PRJNA1120586_P_NODE_41877_length_234_cov_0.872727_g41686_i0 | PRJNA1120586 | 41877 | 234 | 0.872727 | 2.04218118 | Malassezia pachydermatis | 77020 | Fungi | Fungi | 57 | 2.94e-7 | NR | XP_017991756.1 | 77020 | g41686 | i0 | 44.6 | 0.833333333333333 | 65 | 28 | 73.1 | 2 | 63 | 233 | 5 | 69 | XP_017991756.1 hypothetical protein Malapachy_3917 [Malassezia pachydermatis] | diamond | 195 | 57 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia pachydermatis | |
| 32536399 | 32536399 | PRJNA1120586_P_NODE_50679_length_227_cov_0.911392_g50488_i0 | PRJNA1120586 | 50679 | 227 | 0.911392 | 2.06885984 | Nosema granulosis | 83296 | Fungi | Fungi | 81.6 | 4.32e-16 | NR | KAF9761675.1 | 83296 | g50488 | i0 | 56 | 0.991189427312775 | 75 | 33 | 99.1 | 0 | 3 | 227 | 27 | 101 | KAF9761675.1 Chitin synthase regulatory factor 3 [Nosema granulosis] | diamond | 225 | 81.6 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema granulosis | |||
| 32682927 | 32682927 | PRJNA1120586_P_NODE_51460_length_227_cov_0.911392_g51269_i0 | PRJNA1120586 | 51460 | 227 | 0.911392 | 2.06885984 | Lachnellula | 47830 | Fungi | Fungi | 74.3 | 2.28e-13 | NR | TVY48604.1 | 215460 | g51269 | i0 | 56.3 | 1.69162995594714 | 64 | 23 | 78 | 1 | 225 | 49 | 1039 | 1102 | TVY48604.1 Citrinin polyketide synthase [Lachnellula occidentalis] | diamond | 384 | 74.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Lachnaceae | Lachnellula | Lachnellula occidentalis | |
| 32725325 | 32725325 | PRJNA1120586_P_NODE_54280_length_216_cov_2.612245_g54089_i0 | PRJNA1120586 | 54280 | 216 | 2.612245 | 5.6424492 | Nosema bombycis CQ1 | 578461 | Fungi | Fungi | 58.9 | 2.77e-9 | NR | EOB12412.1 | 578461 | g54089 | i0 | 54.8 | 1.16666666666667 | 84 | 14 | 83.3 | 2 | 1 | 180 | 9 | 92 | EOB12412.1 hypothetical protein NBO_447g0004 [Nosema bombycis CQ1] | diamond | 252 | 58.9 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 32788119 | 32788119 | PRJNA1120586_P_NODE_52880_length_226_cov_0.917197_g52689_i0 | PRJNA1120586 | 52880 | 226 | 0.917197 | 2.07286522 | Nosema bombycis CQ1 | 578461 | Fungi | Fungi | 153 | 1.03e-41 | NR | EOB14883.1 | 578461 | g52689 | i0 | 93.3 | 0.995575221238938 | 75 | 5 | 99.6 | 0 | 1 | 225 | 9 | 83 | EOB14883.1 Signal recognition particle SEC65 subunit, partial [Nosema bombycis CQ1] | diamond | 225 | 153 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis |
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);;