contig_metadata
18 rows where bioproject = "PRJNA382558" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1075692 | 1075692 | PRJNA382558_S_NODE_6441_length_196_cov_116.993711_g6437_i0 | PRJNA382558 | 6441 | 196 | 116.993711 | 229.30767356 | root | 1 | Root_unresolved | Root_unresolved | 357 | 3.2099999999999996e-94 | NTclustered | gi|283827979|gb|DQ008163.2| | 5499 | g6437 | i0 | 99.49 | 109.005102040816 | 196 | 1 | 100 | 0 | 1 | 196 | 2773 | 2578 | Passalora fulva strain CBS 119.46 28S large subunit ribosomal RNA gene, partial sequence | blastn | 21365 | 357 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Fulvia | Fulvia fulva | |
| 4232075 | 4232075 | PRJNA382558_S_NODE_4824_length_213_cov_29.039773_g4820_i0 | PRJNA382558 | 4824 | 213 | 29.039773 | 61.85471649 | Periconia banksiae | 1050831 | Fungi | Fungi | 388 | 1.26e-103 | NTclustered | gi|338809129|gb|JF951167.1| | 1050831 | g4820 | i0 | 99.531 | 99.7887323943662 | 213 | 1 | 100 | 0 | 1 | 213 | 659 | 447 | Noosia banksiae culture-collection CPC:17282 28S ribosomal RNA gene, partial sequence | blastn | 21255 | 388 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Periconiaceae | Periconia | Periconia banksiae | |
| 5508448 | 5508448 | PRJNA382558_S_NODE_10265_length_171_cov_9.246269_g10261_i0 | PRJNA382558 | 10265 | 171 | 9.246269 | 15.81111999 | Periconia digitata | 1303443 | Fungi | Fungi | 202 | 1.34e-47 | NTclustered | gi|2452622577|ref|NC_071711.1| | 1303443 | g10261 | i0 | 92.361 | 61.5380116959064 | 144 | 8 | 83 | 3 | 1 | 142 | 46900 | 46758 | Periconia digitata strain Y3 mitochondrion, complete genome | blastn | 10523 | 202 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Periconiaceae | Periconia | Periconia digitata | |
| 6178697 | 6178697 | PRJNA382558_S_NODE_265_length_431_cov_106.403553_g261_i0 | PRJNA382558 | 265 | 431 | 106.403553 | 458.59931343 | Pleosporales | 92860 | Fungi | Fungi | 728 | 0 | NTclustered | gi|1369210274|gb|KU981158.2| | 97972 | g261 | i0 | 98.778 | 102.08120649652 | 409 | 5 | 100 | 0 | 1 | 409 | 542 | 950 | Periconia macrospinosa strain WC10G1 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1 and 5.8S ribosomal RNA gene, complete sequence; and internal transcribed spacer 2, partial sequence | blastn | 43997 | 732 | 0.994535519125683 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Periconiaceae | Periconia | Periconia macrospinosa | |
| 8058112 | 8058112 | PRJNA382558_S_NODE_1407_length_294_cov_7.856031_g1403_i0 | PRJNA382558 | 1407 | 294 | 7.856031 | 23.09673114 | Periconia digitata | 1303443 | Fungi | Fungi | 488 | 1.7499999999999996e-133 | NTclustered | gi|2452622577|ref|NC_071711.1| | 1303443 | g1403 | i0 | 96.61 | 86.4829931972789 | 295 | 9 | 100 | 1 | 1 | 294 | 37717 | 38011 | Periconia digitata strain Y3 mitochondrion, complete genome | blastn | 25426 | 488 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Periconiaceae | Periconia | Periconia digitata | |
| 9333050 | 9333050 | PRJNA382558_S_NODE_6048_length_200_cov_7.730061_g6044_i0 | PRJNA382558 | 6048 | 200 | 7.730061 | 15.460122 | Periconia digitata | 1303443 | Fungi | Fungi | 171 | 4.599999999999999e-38 | NTclustered | gi|2452622577|ref|NC_071711.1| | 1303443 | g6044 | i0 | 97.959 | 32.32 | 98 | 2 | 49 | 0 | 1 | 98 | 45634 | 45537 | Periconia digitata strain Y3 mitochondrion, complete genome | blastn | 6464 | 171 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Periconiaceae | Periconia | Periconia digitata | |
| 10608824 | 10608824 | PRJNA382558_S_NODE_8469_length_181_cov_10.090278_g8465_i0 | PRJNA382558 | 8469 | 181 | 10.090278 | 18.26340318 | Pseudopithomyces chartarum | 1892770 | Fungi | Fungi | 300 | 4.970000000000001e-77 | NTclustered | gi|1237408708|ref|NC_035636.1| | 1892770 | g8465 | i0 | 99.394 | 93.767955801105 | 165 | 1 | 91 | 0 | 1 | 165 | 32977 | 33141 | Pithomyces chartarum mitochondrion, complete genome | blastn | 16972 | 300 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymosphaeriaceae | Pseudopithomyces | Pseudopithomyces chartarum | |
| 10608841 | 10608841 | PRJNA382558_S_NODE_9189_length_177_cov_6.621429_g9185_i0 | PRJNA382558 | 9189 | 177 | 6.621429 | 11.71992933 | Periconia digitata | 1303443 | Fungi | Fungi | 327 | 2.2199999999999996e-85 | NTclustered | gi|2452622577|ref|NC_071711.1| | 1303443 | g9185 | i0 | 100 | 111.016949152542 | 177 | 0 | 100 | 0 | 1 | 177 | 48184 | 48008 | Periconia digitata strain Y3 mitochondrion, complete genome | blastn | 19650 | 327 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Periconiaceae | Periconia | Periconia digitata | |
| 11278944 | 11278944 | PRJNA382558_S_NODE_69_length_605_cov_37.667254_g66_i0 | PRJNA382558 | 69 | 605 | 37.667254 | 227.8868867 | Eukaryota | 2759 | Fungi | Fungi | 1007 | 0 | NTclustered | gi|391883756|gb|JQ780632.1| | 1198553 | g66 | i0 | 96.694 | 115.955371900826 | 605 | 20 | 100 | 0 | 1 | 605 | 1214 | 1818 | Massarinaceae sp. 113 OG-2012 large subunit ribosomal RNA gene, partial sequence | blastn | 70153 | 1013 | 0.994076999012833 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Massarinaceae | Massarinaceae sp. 113 OG-2012 | ||
| 15707572 | 15707572 | PRJNA382558_S_NODE_1373_length_295_cov_106.344961_g1369_i0 | PRJNA382558 | 1373 | 295 | 106.344961 | 313.71763495 | Phoma sp. 1 OB-2014 | 1573585 | Fungi | Fungi | 366 | 8.61e-97 | NTclustered | gi|724090723|gb|KM387394.1| | 1573585 | g1369 | i0 | 89.456 | 93.0610169491525 | 294 | 25 | 99 | 3 | 3 | 295 | 7519 | 7231 | Phoma sp. 1 OB-2014 28S-18S ribosomal RNA intergenic spacer, partial sequence; 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 27453 | 366 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Phoma | Phoma sp. 1 OB-2014 | |
| 15707666 | 15707666 | PRJNA382558_S_NODE_3413_length_234_cov_49.614213_g3409_i0 | PRJNA382558 | 3413 | 234 | 49.614213 | 116.09725842 | Cryptocoryneum condensatum | 1763021 | Fungi | Fungi | 405 | 1.4e-108 | NTclustered | gi|1187430660|gb|KY995559.1| | 1763021 | g3409 | i0 | 97.863 | 111.615384615385 | 234 | 5 | 100 | 0 | 1 | 234 | 2847 | 3080 | Cryptocoryneum condensatum voucher G.M. 2016-01-29.2 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 26118 | 405 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Cryptocoryneum | Cryptocoryneum condensatum | ||
| 18256519 | 18256519 | PRJNA382558_S_NODE_7995_length_184_cov_14.000000_g7991_i0 | PRJNA382558 | 7995 | 184 | 14 | 25.76 | Periconia digitata | 1303443 | Fungi | Fungi | 246 | 6.71e-61 | NTclustered | gi|2452622577|ref|NC_071711.1| | 1303443 | g7991 | i0 | 91.304 | 68.8315217391304 | 184 | 10 | 100 | 5 | 1 | 184 | 45778 | 45955 | Periconia digitata strain Y3 mitochondrion, complete genome | blastn | 12665 | 246 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Periconiaceae | Periconia | Periconia digitata | |
| 18927204 | 18927204 | PRJNA382558_S_NODE_1715_length_280_cov_51.506173_g1711_i0 | PRJNA382558 | 1715 | 280 | 51.506173 | 144.2172844 | Pleosporales | 92860 | Fungi | Fungi | 448 | 2.8199999999999998e-121 | NTclustered | gi|2791117515|gb|PQ217832.1| | 5599 | g1711 | i0 | 95.699 | 109.589285714286 | 279 | 10 | 99 | 2 | 3 | 280 | 4446 | 4169 | Alternaria alternata isolate Karbala-1 small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence; and external transcribed spacer, partial sequence | blastn | 30685 | 448 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 18927217 | 18927217 | PRJNA382558_S_NODE_3675_length_229_cov_50.994792_g3671_i0 | PRJNA382558 | 3675 | 229 | 50.994792 | 116.77807368 | Periconia | 97971 | Fungi | Fungi | 403 | 4.899999999999998e-108 | NTclustered | gi|1167485301|gb|KY794707.1| | 255782 | g3671 | i0 | 99.107 | 97.8165938864629 | 224 | 2 | 98 | 0 | 4 | 227 | 1040 | 817 | Periconia minutissima strain MFLUCC 15-0245 large subunit ribosomal RNA gene, partial sequence | blastn | 22400 | 403 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Periconiaceae | Periconia | Periconia minutissima | |
| 19530700 | 19530700 | PRJNA382558_S_NODE_15116_length_152_cov_14.495652_g15112_i0 | PRJNA382558 | 15116 | 152 | 14.495652 | 22.03339104 | Periconia digitata | 1303443 | Fungi | Fungi | 209 | 6.97e-50 | NTclustered | gi|2452622577|ref|NC_071711.1| | 1303443 | g15112 | i0 | 93.617 | 55.5460526315789 | 141 | 7 | 92 | 2 | 3 | 142 | 47396 | 47535 | Periconia digitata strain Y3 mitochondrion, complete genome | blastn | 8443 | 209 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Periconiaceae | Periconia | Periconia digitata | |
| 19530765 | 19530765 | PRJNA382558_S_NODE_3676_length_229_cov_15.078125_g3672_i0 | PRJNA382558 | 3676 | 229 | 15.078125 | 34.52890625 | Wettsteinina lacustris | 163246 | Fungi | Fungi | 307 | 3.95e-79 | NTclustered | gi|206573595|gb|FJ190642.1| | 163246 | g3672 | i0 | 97.253 | 77.8864628820961 | 182 | 4 | 79 | 1 | 49 | 229 | 385 | 566 | Wettsteinina lacustris isolate AFTOL-ID 1592 12S small subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 17836 | 307 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Wettsteinina | Wettsteinina lacustris | ||
| 29001908 | 29001908 | PRJNA382558_S_NODE_11668_length_165_cov_5.343750_g11664_i0 | PRJNA382558 | 11668 | 165 | 5.34375 | 8.8171875 | Lithohypha guttulata | 1690604 | Fungi | Fungi | 50.8 | 7.29e-6 | NR | KAK5104716.1 | 1690604 | g11664 | i0 | 53.3 | 0.818181818181818 | 45 | 21 | 81.8 | 0 | 165 | 31 | 76 | 120 | KAK5104716.1 hypothetical protein LTS08_002608 [Lithohypha guttulata] | diamond | 135 | 50.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Trichomeriaceae | Lithohypha | Lithohypha guttulata | |
| 30864965 | 30864965 | PRJNA382558_S_NODE_7094_length_191_cov_7.012987_g7090_i0 | PRJNA382558 | 7094 | 191 | 7.012987 | 13.39480517 | Hypomontagnella submonticulosa | 152308 | Fungi | Fungi | 41.6 | 0.0476 | NR | KAI2634769.1 | 152308 | g7090 | i0 | 44.2 | 0.675392670157068 | 43 | 24 | 67.5 | 0 | 160 | 32 | 190 | 232 | KAI2634769.1 P-loop containing nucleoside triphosphate hydrolase protein [Hypomontagnella submonticulosa] | diamond | 129 | 41.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Xylariales | Hypoxylaceae | Hypomontagnella | Hypomontagnella submonticulosa |
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);;