contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA638138" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 609370 | 609370 | PRJNA638138_P_NODE_24901_length_248_cov_0.880000_g24686_i0 | PRJNA638138 | 24901 | 248 | 0.88 | 2.1824 | Pyricularia oryzae | 318829 | Fungi | Fungi | 60.2 | 1.34e-4 | NTclustered | gi|2263452720|gb|CP099697.1| | 318829 | g24686 | i0 | 97.143 | 6.81048387096774 | 35 | 1 | 14 | 0 | 208 | 242 | 6159781 | 6159747 | Pyricularia oryzae strain ZM2-1 chromosome 2 | blastn | 1689 | 60.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Magnaporthales | Pyriculariaceae | Pyricularia | Pyricularia oryzae | |
| 1885591 | 1885591 | PRJNA638138_P_NODE_27022_length_246_cov_0.890173_g26807_i0 | PRJNA638138 | 27022 | 246 | 0.890173 | 2.18982558 | Pseudogymnoascus destructans | 655981 | Fungi | Fungi | 69.4 | 2.21e-7 | NTclustered | gi|1370887514|ref|XM_024470319.1| | 655981 | g26807 | i0 | 93.617 | 0.939024390243902 | 47 | 1 | 19 | 2 | 1 | 47 | 847 | 803 | Pseudogymnoascus destructans uncharacterized protein (VC83_06729), mRNA | blastn | 231 | 69.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Thelebolales | Thelebolaceae | Pseudogymnoascus | Pseudogymnoascus destructans | |
| 5712926 | 5712926 | PRJNA638138_P_NODE_17045_length_266_cov_1.419689_g16830_i0 | PRJNA638138 | 17045 | 266 | 1.419689 | 3.77637274 | Alternaria alternata | 5599 | Fungi | Fungi | 492 | 1.2099999999999999e-134 | NTclustered | gi|1070557495|ref|XM_018530895.1| | 5599 | g16830 | i0 | 100 | 2.08270676691729 | 266 | 0 | 100 | 0 | 1 | 266 | 1828 | 1563 | Alternaria alternata hypothetical protein mRNA | blastn | 554 | 492 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 5712998 | 5712998 | PRJNA638138_P_NODE_24085_length_248_cov_0.880000_g23870_i0 | PRJNA638138 | 24085 | 248 | 0.88 | 2.1824 | Macroventuria anomochaeta | 301207 | Fungi | Fungi | 169 | 2.13e-37 | NTclustered | gi|1833392732|ref|XM_033700639.1| | 301207 | g23870 | i0 | 85.625 | 2.07258064516129 | 160 | 23 | 65 | 0 | 1 | 160 | 958 | 1117 | Macroventuria anomochaeta uncharacterized protein (BU25DRAFT_152162), mRNA | blastn | 514 | 169 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Macroventuria | Macroventuria anomochaeta | |
| 5713094 | 5713094 | PRJNA638138_P_NODE_32065_length_243_cov_0.905882_g31850_i0 | PRJNA638138 | 32065 | 243 | 0.905882 | 2.20129326 | Aspergillus glaucus | 41413 | Fungi | Fungi | 206 | 1.59e-48 | NTclustered | gi|1245895323|ref|XM_022542462.1| | 1160497 | g31850 | i0 | 81.967 | 2.92181069958848 | 244 | 42 | 100 | 2 | 1 | 243 | 567 | 325 | Aspergillus glaucus CBS 516.65 uncharacterized protein (ASPGLDRAFT_160715), mRNA | blastn | 710 | 206 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus glaucus | |
| 9537895 | 9537895 | PRJNA638138_P_NODE_21328_length_250_cov_0.870056_g21113_i0 | PRJNA638138 | 21328 | 250 | 0.870056 | 2.17514 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 407 | 4.1899999999999994e-109 | NTclustered | gi|2837761265|ref|XM_069375378.1| | 1052096 | g21113 | i0 | 96 | 93.868 | 250 | 10 | 100 | 0 | 1 | 250 | 358 | 109 | Cladosporium halotolerans 60S ribosomal protein eL32 (crp-63), mRNA | blastn | 23467 | 407 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 12088814 | 12088814 | PRJNA638138_P_NODE_26650_length_247_cov_0.873563_g26435_i0 | PRJNA638138 | 26650 | 247 | 0.873563 | 2.15770061 | Drechmeria coniospora | 98403 | Fungi | Fungi | 198 | 2.71e-46 | NTclustered | gi|2028076606|ref|XM_040800449.1| | 98403 | g26435 | i0 | 81.377 | 6.48178137651822 | 247 | 42 | 99 | 4 | 1 | 245 | 1619 | 1375 | Drechmeria coniospora putative alternative NADH dehydrogenase (DCS_03125), partial mRNA | blastn | 1601 | 198 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Ophiocordycipitaceae | Drechmeria | Drechmeria coniospora | |
| 12634293 | 12634293 | PRJNA638138_P_NODE_2850_length_565_cov_1.611789_g2638_i0 | PRJNA638138 | 2850 | 565 | 1.611789 | 9.10660785 | Pleosporales | 92860 | Fungi | Fungi | 1044 | 0 | NTclustered | gi|908900564|gb|KT207688.1| | 5599 | g2638 | i0 | 100 | 100 | 565 | 0 | 100 | 0 | 1 | 565 | 3 | 567 | Alternaria alternata strain KUC21222 28S ribosomal RNA gene, partial sequence | blastn | 56500 | 1044 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 13909188 | 13909188 | PRJNA638138_P_NODE_22071_length_249_cov_1.585227_g21856_i0 | PRJNA638138 | 22071 | 249 | 1.585227 | 3.94721523 | Eukaryota | 2759 | Fungi | Fungi | 460 | 3.16e-125 | NTclustered | gi|33334380|gb|AF548066.1| | 41959 | g21856 | i0 | 100 | 99.9638554216867 | 249 | 0 | 100 | 0 | 1 | 249 | 28 | 276 | Aspergillus penicillioides strain ALI 231 18S ribosomal RNA gene, partial sequence | blastn | 24891 | 460 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus penicillioides | |
| 15912212 | 15912212 | PRJNA638138_P_NODE_20873_length_250_cov_0.870056_g20658_i0 | PRJNA638138 | 20873 | 250 | 0.870056 | 2.17514 | [Candida] subhashii | 561895 | Fungi | Fungi | 158 | 4.66e-34 | NTclustered | gi|2272017969|ref|XM_049409124.1| | 561895 | g20658 | i0 | 83.237 | 45.152 | 173 | 27 | 69 | 2 | 78 | 249 | 1189 | 1018 | [Candida] subhashii CNA1 (J8A68_005094), partial mRNA | blastn | 11288 | 158 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Spathaspora | [Candida] subhashii | |
| 15912302 | 15912302 | PRJNA638138_P_NODE_28833_length_245_cov_0.895349_g28618_i0 | PRJNA638138 | 28833 | 245 | 0.895349 | 2.19360505 | Phialemonium atrogriseum | 1093897 | Fungi | Fungi | 122 | 1.66e-23 | NTclustered | gi|2607543933|ref|XM_060432579.1| | 1093897 | g28618 | i0 | 78.365 | 1.48163265306122 | 208 | 31 | 83 | 9 | 1 | 204 | 2031 | 2228 | Phialemonium atrogriseum WD40 repeat-like protein (QBC33DRAFT_614193), mRNA | blastn | 363 | 122 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Cephalothecales | Cephalothecaceae | Phialemonium | Phialemonium atrogriseum | |
| 17733137 | 17733137 | PRJNA638138_P_NODE_30234_length_244_cov_0.900585_g30019_i0 | PRJNA638138 | 30234 | 244 | 0.900585 | 2.1974274 | Dothideomycetes | 147541 | Fungi | Fungi | 451 | 1.86e-122 | NTclustered | gi|2791117515|gb|PQ217832.1| | 5599 | g30019 | i0 | 100 | 101.770491803279 | 244 | 0 | 100 | 0 | 1 | 244 | 5530 | 5287 | 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 | 24832 | 451 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 19736131 | 19736131 | PRJNA638138_P_NODE_25036_length_248_cov_0.880000_g24821_i0 | PRJNA638138 | 25036 | 248 | 0.88 | 2.1824 | Dothidotthia symphoricarpi | 548649 | Fungi | Fungi | 281 | 2.63e-71 | NTclustered | gi|1833547940|ref|XM_033665300.1| | 1392245 | g24821 | i0 | 87.347 | 28.991935483871 | 245 | 31 | 99 | 0 | 4 | 248 | 1177 | 933 | Dothidotthia symphoricarpi CBS 119687 uncharacterized protein (P153DRAFT_326636), mRNA | blastn | 7190 | 281 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Dothidotthiaceae | Dothidotthia | Dothidotthia symphoricarpi | |
| 20281621 | 20281621 | PRJNA638138_P_NODE_13736_length_293_cov_1.004545_g13521_i0 | PRJNA638138 | 13736 | 293 | 1.004545 | 2.94331685 | Didymellaceae | 683158 | Fungi | Fungi | 536 | 6.149999999999998e-148 | NTclustered | gi|391883728|gb|JQ768399.1| | 749860 | g13521 | i0 | 99.659 | 126.607508532423 | 293 | 1 | 100 | 0 | 1 | 293 | 1730 | 1438 | Heterophoma verbasci-densiflori isolate 115 large subunit ribosomal RNA gene, partial sequence | blastn | 37096 | 536 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Heterophoma | Heterophoma verbasci-densiflori | |
| 22286520 | 22286520 | PRJNA638138_P_NODE_28758_length_245_cov_0.895349_g28543_i0 | PRJNA638138 | 28758 | 245 | 0.895349 | 2.19360505 | Trematosphaeria pertusa | 390896 | Fungi | Fungi | 54.7 | 0.006 | NTclustered | gi|1835087078|ref|XM_033821234.1| | 390896 | g28543 | i0 | 92.308 | 0.159183673469388 | 39 | 2 | 16 | 1 | 162 | 199 | 113 | 75 | Trematosphaeria pertusa uncharacterized protein (BU26DRAFT_258690), mRNA | blastn | 39 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Trematosphaeriaceae | Trematosphaeria | Trematosphaeria pertusa | |
| 22286571 | 22286571 | PRJNA638138_P_NODE_32598_length_243_cov_0.905882_g32383_i0 | PRJNA638138 | 32598 | 243 | 0.905882 | 2.20129326 | Alternaria postmessia | 1187938 | Fungi | Fungi | 444 | 3.09e-120 | NTclustered | gi|2324867670|ref|XM_051732061.1| | 1187938 | g32383 | i0 | 99.588 | 7.45267489711934 | 243 | 1 | 100 | 0 | 1 | 243 | 552 | 310 | Alternaria postmessia uncharacterized protein (J4E82_005800), partial mRNA | blastn | 1811 | 444 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria postmessia |
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);;