contig_metadata
16 rows where bioproject = "PRJNA930380" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2184807 | 2184807 | PRJNA930380_P_NODE_542_length_812_cov_1.504736_g493_i0 | PRJNA930380 | 542 | 812 | 1.504736 | 12.21845632 | Sclerotinia sclerotiorum | 5180 | Fungi | Fungi | 1495 | 0 | NTclustered | gi|156036075|ref|XM_001586099.1| | 665079 | g493 | i0 | 99.877 | 1.70689655172414 | 812 | 1 | 100 | 0 | 1 | 812 | 1065 | 254 | Sclerotinia sclerotiorum 1980 UF-70 hypothetical protein partial mRNA | blastn | 1386 | 1495 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Sclerotiniaceae | Sclerotinia | Sclerotinia sclerotiorum | |
| 4737710 | 4737710 | PRJNA930380_P_NODE_13804_length_243_cov_0.905882_g13751_i0 | PRJNA930380 | 13804 | 243 | 0.905882 | 2.20129326 | Penicillium solitum | 60172 | Fungi | Fungi | 449 | 6.65e-122 | NTclustered | gi|357196637|ref|NC_016187.1| | 60172 | g13751 | i0 | 100 | 54.5679012345679 | 243 | 0 | 100 | 0 | 1 | 243 | 6119 | 6361 | Penicillium solitum mitochondrion, complete genome | blastn | 13260 | 449 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium solitum | |
| 10183590 | 10183590 | PRJNA930380_P_NODE_3088_length_363_cov_3.010345_g3035_i0 | PRJNA930380 | 3088 | 363 | 3.010345 | 10.92755235 | Elsinoe | 40996 | Fungi | Fungi | 665 | 0 | NTclustered | gi|2166975980|gb|OL898501.1| | 302913 | g3035 | i0 | 99.725 | 95.1900826446281 | 363 | 1 | 100 | 0 | 1 | 363 | 1052 | 690 | Elsinoe ampelina strain CECT 20119 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 | 34554 | 665 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Myriangiales | Elsinoaceae | Elsinoe | Elsinoe ampelina | |
| 11112908 | 11112908 | PRJNA930380_P_NODE_11109_length_255_cov_1.269231_g11056_i0 | PRJNA930380 | 11109 | 255 | 1.269231 | 3.23653905 | Saccharomycodes ludwigii | 36035 | Fungi | Fungi | 52.8 | 0.023 | NTclustered | gi|2185212228|ref|XM_046078229.1| | 36035 | g11056 | i0 | 100 | 0.109803921568627 | 28 | 0 | 11 | 0 | 98 | 125 | 1480 | 1453 | Saccharomycodes ludwigii uncharacterized protein (SCDLUD_003694), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycodales | Saccharomycodaceae | Saccharomycodes | Saccharomycodes ludwigii | |
| 11112937 | 11112937 | PRJNA930380_P_NODE_12129_length_249_cov_0.875000_g12076_i0 | PRJNA930380 | 12129 | 249 | 0.875 | 2.17875 | Thyridium curvatum | 1093900 | Fungi | Fungi | 361 | 3.3e-95 | NTclustered | gi|1758353532|ref|XM_031144458.1| | 1093900 | g12076 | i0 | 92.771 | 1 | 249 | 18 | 100 | 0 | 1 | 249 | 1530 | 1282 | Thyridium curvatum uncharacterized protein (E0L32_009487), partial mRNA | blastn | 249 | 361 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Thyridiales | Thyridiaceae | Thyridium | Thyridium curvatum | |
| 12388462 | 12388462 | PRJNA930380_P_NODE_11870_length_250_cov_0.870056_g11817_i0 | PRJNA930380 | 11870 | 250 | 0.870056 | 2.17514 | Thyridium curvatum | 1093900 | Fungi | Fungi | 446 | 8.89e-121 | NTclustered | gi|1758348818|ref|XM_031141840.1| | 1093900 | g11817 | i0 | 98.8 | 3.04 | 250 | 3 | 100 | 0 | 1 | 250 | 298 | 49 | Thyridium curvatum uncharacterized protein (E0L32_007130), partial mRNA | blastn | 760 | 446 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Thyridiales | Thyridiaceae | Thyridium | Thyridium curvatum | |
| 12388517 | 12388517 | PRJNA930380_P_NODE_13990_length_242_cov_0.911243_g13937_i0 | PRJNA930380 | 13990 | 242 | 0.911243 | 2.20520806 | Fusarium verticillioides | 117187 | Fungi | Fungi | 442 | 1.1099999999999995e-119 | NTclustered | gi|1092952487|ref|XM_018887963.1| | 334819 | g13937 | i0 | 99.587 | 13.004132231405 | 242 | 1 | 100 | 0 | 1 | 242 | 242 | 1 | Fusarium verticillioides 7600 thymidylate synthase (FVEG_01159), partial mRNA | blastn | 3147 | 442 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium verticillioides | |
| 14937272 | 14937272 | PRJNA930380_P_NODE_12952_length_246_cov_0.890173_g12899_i0 | PRJNA930380 | 12952 | 246 | 0.890173 | 2.18982558 | Podosphaera aphanis | 79252 | Fungi | Fungi | 170 | 8.62e-51 | NR | KAI1000974.1 | 79252 | g12899 | i0 | 100 | 0.98780487804878 | 81 | 0 | 98.8 | 0 | 3 | 245 | 92 | 172 | KAI1000974.1 F-actin-capping protein subunit beta [Podosphaera aphanis] | diamond | 243 | 170 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Erysiphales | Erysiphaceae | Podosphaera | Podosphaera aphanis | |
| 17487650 | 17487650 | PRJNA930380_P_NODE_2454_length_401_cov_2.384146_g2401_i0 | PRJNA930380 | 2454 | 401 | 2.384146 | 9.56042546 | Dothideomycetes sp. NU200 | 2983309 | Fungi | Fungi | 405 | 2.56e-108 | NTclustered | gi|2328117298|dbj|LC739043.1| | 2983309 | g2401 | i0 | 86.885 | 89.3142144638404 | 366 | 43 | 91 | 5 | 1 | 364 | 2843 | 3205 | Dothideomycetes sp. NU200 gene for 28S ribosomal RNA, partial sequence | blastn | 35815 | 405 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideomycetes sp. NU200 | ||||
| 19106291 | 19106291 | PRJNA930380_P_NODE_11515_length_251_cov_0.865169_g11462_i0 | PRJNA930380 | 11515 | 251 | 0.865169 | 2.17157419 | Fusarium | 5506 | Fungi | Fungi | 453 | 5.34e-123 | NTclustered | gi|1092957201|ref|XM_018894462.1| | 334819 | g11462 | i0 | 99.203 | 8.93227091633466 | 251 | 2 | 100 | 0 | 1 | 251 | 663 | 913 | Fusarium verticillioides 7600 hypothetical protein (FVEG_06177), mRNA | blastn | 2242 | 453 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium verticillioides | |
| 23861608 | 23861608 | PRJNA930380_P_NODE_12059_length_249_cov_0.875000_g12006_i0 | PRJNA930380 | 12059 | 249 | 0.875 | 2.17875 | Fusarium verticillioides | 117187 | Fungi | Fungi | 455 | 1.47e-123 | NTclustered | gi|1092966203|ref|XM_018892471.1| | 334819 | g12006 | i0 | 99.598 | 73.6506024096386 | 249 | 1 | 100 | 0 | 1 | 249 | 566 | 318 | Fusarium verticillioides 7600 ADP,ATP carrier protein (FVEG_04651), mRNA | blastn | 18339 | 455 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium verticillioides | |
| 27088273 | 27088273 | PRJNA930380_P_NODE_9482_length_274_cov_1.532338_g9429_i0 | PRJNA930380 | 9482 | 274 | 1.532338 | 4.19860612 | Trichophyton interdigitale H6 | 1215336 | Fungi | Fungi | 43.1 | 0.0375 | NR | EZF32639.1 | 1215336 | g9429 | i0 | 44 | 0.547445255474453 | 50 | 25 | 54.7 | 1 | 82 | 231 | 91 | 137 | EZF32639.1 hypothetical protein H101_03765 [Trichophyton interdigitale H6] | diamond | 150 | 43.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Onygenales | Arthrodermataceae | Trichophyton | Trichophyton interdigitale | |
| 28635841 | 28635841 | PRJNA930380_P_NODE_12727_length_247_cov_0.885057_g12674_i0 | PRJNA930380 | 12727 | 247 | 0.885057 | 2.18609079 | Emericellopsis atlantica | 2614577 | Fungi | Fungi | 113 | 1.02e-27 | NR | XP_046115883.1 | 2614577 | g12674 | i0 | 79.1 | 0.813765182186235 | 67 | 14 | 81.4 | 0 | 202 | 2 | 1 | 67 | XP_046115883.1 uncharacterized protein F5Z01DRAFT_682998 [Emericellopsis atlantica] | diamond | 201 | 113 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Bionectriaceae | Emericellopsis | Emericellopsis atlantica | |
| 29298690 | 29298690 | PRJNA930380_P_NODE_12889_length_246_cov_0.890173_g12836_i0 | PRJNA930380 | 12889 | 246 | 0.890173 | 2.18982558 | Watsoniomyces obsoletus | 2796175 | Fungi | Fungi | 167 | 2.0499999999999998e-47 | NR | KAI9885714.1 | 2796175 | g12836 | i0 | 92.6 | 0.98780487804878 | 81 | 6 | 98.8 | 0 | 245 | 3 | 351 | 431 | KAI9885714.1 MAG: hypothetical protein M1823_002479 [Watsoniomyces obsoletus] | diamond | 243 | 167 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lichinomycetes | Lichinales | Porocyphaceae | Watsoniomyces | Watsoniomyces obsoletus | |
| 30498921 | 30498921 | PRJNA930380_P_NODE_11393_length_251_cov_0.865169_g11340_i0 | PRJNA930380 | 11393 | 251 | 0.865169 | 2.17157419 | Sarocladium strictum | 5046 | Fungi | Fungi | 147 | 5.08e-41 | NR | KAK0383465.1 | 5046 | g11340 | i0 | 85.9 | 1.01593625498008 | 85 | 10 | 99.2 | 1 | 251 | 3 | 90 | 174 | KAK0383465.1 hypothetical protein NLU13_9376 [Sarocladium strictum] | diamond | 255 | 147 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium strictum | |
| 32396182 | 32396182 | PRJNA930380_P_NODE_13399_length_244_cov_0.900585_g13346_i0 | PRJNA930380 | 13399 | 244 | 0.900585 | 2.1974274 | Podospora didyma | 330526 | Fungi | Fungi | 43.9 | 0.0137 | NR | KAK3394802.1 | 330526 | g13346 | i0 | 37.5 | 0.688524590163934 | 56 | 35 | 68.9 | 0 | 236 | 69 | 110 | 165 | KAK3394802.1 UbiA prenyltransferase family-domain-containing protein [Podospora didyma] | diamond | 168 | 43.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Podosporaceae | Podospora | Podospora didyma |
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);;