contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJNA1197996" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4150687 | 4150687 | PRJNA1197996_S_NODE_11384_length_321_cov_1.552419_g11330_i0 | PRJNA1197996 | 11384 | 321 | 1.552419 | 4.98326499 | Mycosphaerellales | 2726947 | Fungi | Fungi | 142 | 7.41e-39 | NR | XP_007680919.1 | 717646 | g11330 | i0 | 74.7 | 3.10280373831776 | 83 | 21 | 77.6 | 0 | 321 | 73 | 265 | 347 | XP_007680919.1 uncharacterized protein BAUCODRAFT_38938 [Baudoinia panamericana UAMH 10762] | diamond | 996 | 142 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Baudoinia | Baudoinia panamericana | |
| 10527671 | 10527671 | PRJNA1197996_S_NODE_16129_length_287_cov_1.439252_g16075_i0 | PRJNA1197996 | 16129 | 287 | 1.439252 | 4.13065324 | Sordariales | 5139 | Fungi | Fungi | 85.1 | 6.13e-17 | NR | KAK0616041.1 | 252184 | g16075 | i0 | 57.8 | 1.71428571428571 | 83 | 31 | 82.6 | 1 | 15 | 251 | 338 | 420 | KAK0616041.1 hypothetical protein B0T17DRAFT_365437 [Bombardia bombarda] | diamond | 492 | 85.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Lasiosphaeriaceae | Bombardia | Bombardia bombarda | |
| 23276042 | 23276042 | PRJNA1197996_S_NODE_13799_length_302_cov_1.419214_g13745_i0 | PRJNA1197996 | 13799 | 302 | 1.419214 | 4.28602628 | Epicoccum nigrum | 105696 | Fungi | Fungi | 146 | 1.23e-42 | NR | OSS46859.1 | 105696 | g13745 | i0 | 83.5 | 0.963576158940397 | 97 | 15 | 95.4 | 1 | 2 | 289 | 51 | 147 | OSS46859.1 hypothetical protein B5807_09069 [Epicoccum nigrum] | diamond | 291 | 146 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Epicoccum | Epicoccum nigrum | |
| 25269865 | 25269865 | PRJNA1197996_S_NODE_25760_length_246_cov_1.554913_g25706_i0 | PRJNA1197996 | 25760 | 246 | 1.554913 | 3.82508598 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 144 | 6.39e-39 | NR | XP_069233864.1 | 1052096 | g25706 | i0 | 89.9 | 0.963414634146341 | 79 | 8 | 96.3 | 0 | 244 | 8 | 373 | 451 | XP_069233864.1 uncharacterized protein WHR41_00561 [Cladosporium halotolerans] | diamond | 237 | 144 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 26851230 | 26851230 | PRJNA1197996_S_NODE_16501_length_285_cov_1.334906_g16447_i0 | PRJNA1197996 | 16501 | 285 | 1.334906 | 3.8044821 | Sarocladium strictum | 5046 | Fungi | Fungi | 118 | 9.02e-30 | NR | KAL2206833.1 | 5046 | g16447 | i0 | 77.3 | 1.58947368421053 | 75 | 17 | 78.9 | 0 | 281 | 57 | 272 | 346 | KAL2206833.1 Aldo/keto reductase [Sarocladium strictum] | diamond | 453 | 118 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium strictum | |
| 26882837 | 26882837 | PRJNA1197996_S_NODE_11561_length_320_cov_0.870445_g11507_i0 | PRJNA1197996 | 11561 | 320 | 0.870445 | 2.785424 | Metarhizium rileyi | 1649241 | Fungi | Fungi | 118 | 1.82e-31 | NR | OAA34287.1 | 1649241 | g11507 | i0 | 96.8 | 0.58125 | 62 | 2 | 58.1 | 0 | 28 | 213 | 56 | 117 | OAA34287.1 Peptidyl-prolyl cis-trans isomerase, FKBP-type [Metarhizium rileyi] | diamond | 186 | 118 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Clavicipitaceae | Metarhizium | Metarhizium rileyi | |
| 27944333 | 27944333 | PRJNA1197996_S_NODE_13165_length_306_cov_1.836910_g13111_i0 | PRJNA1197996 | 13165 | 306 | 1.83691 | 5.6209446 | Ascomycota | 4890 | Fungi | Fungi | 62.4 | 2.15e-10 | NR | VUC33356.1 | 29856 | g13111 | i0 | 85.7 | 4.95098039215686 | 63 | 9 | 61.8 | 0 | 5 | 193 | 1 | 63 | VUC33356.1 unnamed protein product [Clonostachys rosea] | diamond | 1515 | 62.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Bionectriaceae | Clonostachys | Clonostachys rosea | |
| 27956969 | 27956969 | PRJNA1197996_S_NODE_24165_length_250_cov_0.870056_g24111_i0 | PRJNA1197996 | 24165 | 250 | 0.870056 | 2.17514 | Penicillium nalgiovense | 60175 | Fungi | Fungi | 42.7 | 0.0408 | NR | OQE90351.1 | 60175 | g24111 | i0 | 39.5 | 0.516 | 43 | 26 | 51.6 | 0 | 38 | 166 | 14 | 56 | OQE90351.1 hypothetical protein PENNAL_c0012G00065 [Penicillium nalgiovense] | diamond | 129 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium nalgiovense | |
| 28083127 | 28083127 | PRJNA1197996_S_NODE_23405_length_251_cov_1.297753_g23351_i0 | PRJNA1197996 | 23405 | 251 | 1.297753 | 3.25736003 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 47.8 | 6.94e-4 | NR | XP_069226899.1 | 1052096 | g23351 | i0 | 80 | 0.358565737051793 | 30 | 6 | 35.9 | 0 | 251 | 162 | 510 | 539 | XP_069226899.1 uncharacterized protein WHR41_07104 [Cladosporium halotolerans] | diamond | 90 | 47.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 28209343 | 28209343 | PRJNA1197996_S_NODE_23466_length_251_cov_1.157303_g23412_i0 | PRJNA1197996 | 23466 | 251 | 1.157303 | 2.90483053 | Metarhizium rileyi | 1649241 | Fungi | Fungi | 51.2 | 3.1e-5 | NR | OAA49251.1 | 1649241 | g23412 | i0 | 100 | 0.752988047808765 | 21 | 0 | 25.1 | 0 | 1 | 63 | 218 | 238 | OAA49251.1 Golgi SNAP receptor complex, subunit 1 [Metarhizium rileyi] | diamond | 189 | 51.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Clavicipitaceae | Metarhizium | Metarhizium rileyi | |
| 28240907 | 28240907 | PRJNA1197996_S_NODE_22926_length_253_cov_1.594444_g22872_i0 | PRJNA1197996 | 22926 | 253 | 1.594444 | 4.03394332 | Thyridium curvatum | 1093900 | Fungi | Fungi | 82 | 2.95e-18 | NR | XP_030998423.1 | 1093900 | g22872 | i0 | 68.3 | 0.711462450592885 | 60 | 18 | 70 | 1 | 244 | 68 | 26 | 85 | XP_030998423.1 uncharacterized protein E0L32_003653 [Thyridium curvatum] | diamond | 180 | 82 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Thyridiales | Thyridiaceae | Thyridium | Thyridium curvatum | |
| 28525429 | 28525429 | PRJNA1197996_S_NODE_5967_length_392_cov_9.222571_g5913_i0 | PRJNA1197996 | 5967 | 392 | 9.222571 | 36.15247832 | Epicoccum nigrum | 105696 | Fungi | Fungi | 79.7 | 3.85e-16 | NR | OSS49657.1 | 105696 | g5913 | i0 | 65.5 | 0.443877551020408 | 58 | 20 | 44.4 | 0 | 1 | 174 | 74 | 131 | OSS49657.1 hypothetical protein B5807_06295 [Epicoccum nigrum] | diamond | 174 | 79.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Epicoccum | Epicoccum nigrum | |
| 29535618 | 29535618 | PRJNA1197996_S_NODE_27470_length_243_cov_0.905882_g27416_i0 | PRJNA1197996 | 27470 | 243 | 0.905882 | 2.20129326 | Polyplosphaeria fusca | 682080 | Fungi | Fungi | 63.2 | 5.73e-11 | NR | KAF2727960.1 | 682080 | g27416 | i0 | 52.5 | 1.30864197530864 | 59 | 27 | 72.8 | 1 | 236 | 60 | 14 | 71 | KAF2727960.1 hypothetical protein EJ04DRAFT_516925 [Polyplosphaeria fusca] | diamond | 318 | 63.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Tetraplosphaeriaceae | Polyplosphaeria | Polyplosphaeria fusca | |
| 29598482 | 29598482 | PRJNA1197996_S_NODE_22690_length_254_cov_1.701657_g22636_i0 | PRJNA1197996 | 22690 | 254 | 1.701657 | 4.32220878 | Cercospora beticola | 122368 | Fungi | Fungi | 100 | 2.88e-25 | NR | PIA98444.1 | 122368 | g22636 | i0 | 85.2 | 0.720472440944882 | 61 | 6 | 68.5 | 1 | 3 | 176 | 12 | 72 | PIA98444.1 hypothetical protein CB0940_06259 [Cercospora beticola] | diamond | 183 | 100 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Cercospora | Cercospora beticola | |
| 29807026 | 29807026 | PRJNA1197996_S_NODE_17371_length_280_cov_1.487923_g17317_i0 | PRJNA1197996 | 17371 | 280 | 1.487923 | 4.1661844 | Helotiales | 5178 | Fungi | Fungi | 45.1 | 0.0078 | NR | TVY48388.1 | 215460 | g17317 | i0 | 35.2 | 2.175 | 71 | 40 | 69.6 | 1 | 4 | 198 | 191 | 261 | TVY48388.1 hypothetical protein LOCC1_G000918 [Lachnellula occidentalis] | diamond | 609 | 45.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Lachnaceae | Lachnellula | Lachnellula occidentalis | |
| 30059713 | 30059713 | PRJNA1197996_S_NODE_28551_length_241_cov_0.916667_g28497_i0 | PRJNA1197996 | 28551 | 241 | 0.916667 | 2.20916747 | Fungi | 4751 | Fungi | Fungi | 44.3 | 0.0108 | NR | RSL52164.1 | 1325734 | g28497 | i0 | 31.8 | 3.04979253112033 | 85 | 51 | 97.1 | 1 | 240 | 7 | 1391 | 1475 | RSL52164.1 hypothetical protein CEP54_011048 [Fusarium duplospermum] | diamond | 735 | 44.7 | 0.991051454138702 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium duplospermum | |
| 30388900 | 30388900 | PRJNA1197996_S_NODE_23213_length_252_cov_1.290503_g23159_i0 | PRJNA1197996 | 23213 | 252 | 1.290503 | 3.25206756 | Epicoccum nigrum | 105696 | Fungi | Fungi | 169 | 3.839999999999999e-47 | NR | KAG9203146.1 | 105696 | g23159 | i0 | 98.8 | 0.988095238095238 | 83 | 1 | 98.8 | 0 | 2 | 250 | 436 | 518 | KAG9203146.1 Transcriptional regulator of nonfermentable carbon utilization [Epicoccum nigrum] | diamond | 249 | 169 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Epicoccum | Epicoccum nigrum | |
| 31209485 | 31209485 | PRJNA1197996_S_NODE_20455_length_264_cov_2.015707_g20401_i0 | PRJNA1197996 | 20455 | 264 | 2.015707 | 5.32146648 | Knufia obscura | 1635080 | Fungi | Fungi | 51.6 | 3.53e-5 | NR | XP_064733493.1 | 1635080 | g20401 | i0 | 82.1 | 0.318181818181818 | 28 | 5 | 31.8 | 0 | 3 | 86 | 68 | 95 | XP_064733493.1 uncharacterized protein PMZ80_002608 [Knufia obscura] | diamond | 84 | 51.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Trichomeriaceae | Knufia | Knufia obscura | |
| 31209488 | 31209488 | PRJNA1197996_S_NODE_6115_length_390_cov_0.949527_g6061_i0 | PRJNA1197996 | 6115 | 390 | 0.949527 | 3.7031553 | Alternaria tenuissima | 119927 | Fungi | Fungi | 272 | 3.32e-92 | NR | RYN50606.1 | 119927 | g6061 | i0 | 99.2 | 0.992307692307692 | 129 | 1 | 99.2 | 0 | 2 | 388 | 8 | 136 | RYN50606.1 hypothetical protein AA0118_g10795 [Alternaria tenuissima] | diamond | 387 | 272 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria tenuissima | |
| 31399918 | 31399918 | PRJNA1197996_S_NODE_9416_length_340_cov_3.970037_g9362_i0 | PRJNA1197996 | 9416 | 340 | 3.970037 | 13.4981258 | Hyphopichia burtonii NRRL Y-1933 | 984485 | Fungi | Fungi | 52.4 | 2.31e-5 | NR | XP_020079148.1 | 984485 | g9362 | i0 | 41.8 | 0.485294117647059 | 55 | 31 | 48.5 | 1 | 2 | 166 | 127 | 180 | XP_020079148.1 PR-1-like protein [Hyphopichia burtonii NRRL Y-1933] | diamond | 165 | 52.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Hyphopichia | Hyphopichia burtonii | |
| 32146285 | 32146285 | PRJNA1197996_S_NODE_26258_length_245_cov_1.790698_g26204_i0 | PRJNA1197996 | 26258 | 245 | 1.790698 | 4.3872101 | Trichomeriaceae | 1233474 | Fungi | Fungi | 76.6 | 5.81e-15 | NR | KAK5073361.1 | 1690604 | g26204 | i0 | 94.1 | 0.83265306122449 | 34 | 2 | 41.6 | 0 | 142 | 243 | 28 | 61 | KAK5073361.1 rho GDP dissociation inhibitor [Lithohypha guttulata] | diamond | 204 | 76.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Trichomeriaceae | Lithohypha | Lithohypha guttulata | |
| 32380540 | 32380540 | PRJNA1197996_S_NODE_15659_length_290_cov_1.064516_g15605_i0 | PRJNA1197996 | 15659 | 290 | 1.064516 | 3.0870964 | Ascochyta lentis | 205686 | Fungi | Fungi | 146 | 1.49e-41 | NR | KAF9700932.1 | 205686 | g15605 | i0 | 75 | 0.910344827586207 | 88 | 22 | 91 | 0 | 24 | 287 | 151 | 238 | KAF9700932.1 hypothetical protein EKO04_000887 [Ascochyta lentis] | diamond | 264 | 146 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Ascochyta | Ascochyta lentis |
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);;