contig_metadata
18 rows where analysis = "blastn", bioproject = "PRJNA675638" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 648454 | 648454 | PRJNA675638_P_NODE_20061_length_164_cov_0.886957_g19864_i0 | PRJNA675638 | 20061 | 164 | 0.886957 | 1.45460948 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 193 | 7.73e-45 | NTclustered | gi|2837719752|ref|XM_069368798.1| | 1052096 | g19864 | i0 | 87.879 | 1.00609756097561 | 165 | 18 | 100 | 2 | 1 | 164 | 447 | 284 | Cladosporium halotolerans uncharacterized protein (WHR41_00192), mRNA | blastn | 165 | 193 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 1168993 | 1168993 | PRJNA675638_S_NODE_6221_length_182_cov_1.308271_g6159_i0 | PRJNA675638 | 6221 | 182 | 1.308271 | 2.38105322 | Pleosporaceae | 28556 | Fungi | Fungi | 337 | 3.82e-88 | NTclustered | gi|1888322|gb|U43465.1|LIU43465 | 45303 | g6159 | i0 | 100 | 100 | 182 | 0 | 100 | 0 | 1 | 182 | 101 | 282 | Lewia infectoria small subunit nuclear ribosomal RNA gene, partial sequence | blastn | 18200 | 337 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria infectoria | |
| 4997294 | 4997294 | PRJNA675638_P_NODE_18164_length_167_cov_0.864407_g17967_i0 | PRJNA675638 | 18164 | 167 | 0.864407 | 1.44355969 | Botrytis | 33196 | Fungi | Fungi | 99 | 1.77e-16 | NTclustered | gi|1955460549|ref|XM_038902033.1| | 1463999 | g17967 | i0 | 95.161 | 2.86826347305389 | 62 | 3 | 37 | 0 | 1 | 62 | 575 | 636 | Botrytis sinoallii uncharacterized protein (EAF02_005985), partial mRNA | blastn | 479 | 99 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Sclerotiniaceae | Botrytis | Botrytis sinoallii | |
| 6272873 | 6272873 | PRJNA675638_P_NODE_17105_length_173_cov_1.209677_g16908_i0 | PRJNA675638 | 17105 | 173 | 1.209677 | 2.09274121 | root | 1 | Root_unresolved | Root_unresolved | 320 | 3.61e-83 | NTclustered | gi|1473255798|gb|MH868742.1| | 5074 | g16908 | i0 | 100 | 100 | 173 | 0 | 100 | 0 | 1 | 173 | 138 | 310 | Penicillium brevicompactum culture CBS:287.53 strain CBS 287.53 large subunit ribosomal RNA gene, partial sequence | blastn | 17300 | 320 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium brevicompactum | |
| 6272913 | 6272913 | PRJNA675638_P_NODE_5425_length_291_cov_1.433884_g5228_i0 | PRJNA675638 | 5425 | 291 | 1.433884 | 4.17260244 | Pleosporaceae | 28556 | Fungi | Fungi | 527 | 3.67e-145 | NTclustered | gi|1783384436|gb|MN818598.1| | 5503 | g5228 | i0 | 99.313 | 99.9656357388316 | 291 | 2 | 100 | 0 | 1 | 291 | 666 | 376 | Curvularia lunata isolate Cu-36 large subunit ribosomal RNA gene, partial sequence | blastn | 29090 | 527 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Curvularia | Curvularia lunata | |
| 7546852 | 7546852 | PRJNA675638_P_NODE_17746_length_169_cov_1.275000_g17549_i0 | PRJNA675638 | 17746 | 169 | 1.275 | 2.15475 | Coniochaeta | 79808 | Fungi | Fungi | 307 | 2.73e-79 | NTclustered | gi|1333183594|gb|MG491499.1| | 91930 | g17549 | i0 | 99.412 | 104.597633136095 | 170 | 0 | 100 | 1 | 1 | 169 | 3800 | 3969 | Coniochaeta hoffmannii strain CBS 245.38 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence; and 28S-18S intergenic spacer, partial sequence | blastn | 17677 | 307 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Coniochaetales | Coniochaetaceae | Coniochaeta | Coniochaeta hoffmannii | |
| 8821976 | 8821976 | PRJNA675638_P_NODE_6147_length_276_cov_1.480176_g5950_i0 | PRJNA675638 | 6147 | 276 | 1.480176 | 4.08528576 | Ascomycota | 4890 | Fungi | Fungi | 494 | 3.51e-135 | NTclustered | gi|2749640508|ref|XR_010715598.1| | 5022 | g5950 | i0 | 98.917 | 112.561594202899 | 277 | 2 | 100 | 1 | 1 | 276 | 1900 | 2176 | Leptosphaeria maculans 28S ribosomal RNA (IAQ61_009836), rRNA | blastn | 31067 | 494 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Leptosphaeriaceae | Plenodomus | Plenodomus lingam | |
| 12127889 | 12127889 | PRJNA675638_S_NODE_2230_length_290_cov_4.937759_g2168_i0 | PRJNA675638 | 2230 | 290 | 4.937759 | 14.3195011 | Botrytis fragariae | 1964551 | Fungi | Fungi | 52.8 | 0.027 | NTclustered | gi|1929730052|ref|XM_037337055.1| | 1964551 | g2168 | i0 | 100 | 0.096551724137931 | 28 | 0 | 10 | 0 | 32 | 59 | 1249 | 1276 | Botrytis fragariae putative cell surface protein (Bfra_006685), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Sclerotiniaceae | Botrytis | Botrytis fragariae | |
| 13402639 | 13402639 | PRJNA675638_S_NODE_511_length_923_cov_35.327231_g416_i1 | PRJNA675638 | 511 | 923 | 35.327231 | 326.07034213 | Leptographium clavigerum | 226899 | Fungi | Fungi | 56.5 | 0.007 | NTclustered | gi|930148321|ref|XM_014319092.1| | 655863 | g416 | i1 | 100 | 0.535211267605634 | 30 | 0 | 3 | 0 | 892 | 921 | 72 | 101 | Grosmannia clavigera kw1407 glycoside hydrolase family 16 (CMQ_5347), partial mRNA | blastn | 494 | 56.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Ophiostomatales | Ophiostomataceae | Leptographium | Leptographium clavigerum | |
| 15951247 | 15951247 | PRJNA675638_P_NODE_18913_length_166_cov_0.871795_g18716_i0 | PRJNA675638 | 18913 | 166 | 0.871795 | 1.4471797 | Phialemonium atrogriseum | 1093897 | Fungi | Fungi | 137 | 3.73e-28 | NTclustered | gi|2607487150|ref|XM_060426618.1| | 1093897 | g18716 | i0 | 81.988 | 1.74698795180723 | 161 | 29 | 97 | 0 | 1 | 161 | 385 | 545 | Phialemonium atrogriseum translation initiation factor 2, alpha subunit (QBC33DRAFT_523277), mRNA | blastn | 290 | 137 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Cephalothecales | Cephalothecaceae | Phialemonium | Phialemonium atrogriseum | |
| 18500842 | 18500842 | PRJNA675638_P_NODE_7915_length_245_cov_2.265306_g7718_i0 | PRJNA675638 | 7915 | 245 | 2.265306 | 5.5499997 | Ascoidea rubescens | 54195 | Fungi | Fungi | 52.8 | 0.022 | NTclustered | gi|1147183483|ref|XM_020189082.1| | 1344418 | g7718 | i0 | 100 | 0.114285714285714 | 28 | 0 | 11 | 0 | 169 | 196 | 1265 | 1238 | Ascoidea rubescens DSM 1968 uncharacterized protein (ASCRUDRAFT_134822), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Ascoideales | Ascoideaceae | Ascoidea | Ascoidea rubescens | |
| 19020666 | 19020666 | PRJNA675638_P_NODE_10495_length_217_cov_1.196429_g10298_i0 | PRJNA675638 | 10495 | 217 | 1.196429 | 2.59625093 | Alternaria | 5598 | Fungi | Fungi | 390 | 3.579999999999999e-104 | NTclustered | gi|670734121|gb|KJ443121.1| | 1525331 | g10298 | i0 | 99.078 | 116.041474654378 | 217 | 2 | 100 | 0 | 1 | 217 | 1813 | 2029 | Alternaria sp. M301 28S large subunit ribosomal RNA gene, partial sequence | blastn | 25181 | 390 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria sp. M301 | |
| 21571098 | 21571098 | PRJNA675638_P_NODE_12237_length_203_cov_1.766234_g12040_i0 | PRJNA675638 | 12237 | 203 | 1.766234 | 3.58545502 | Dothideomycetes | 147541 | Fungi | Fungi | 359 | 9.31e-95 | NTclustered | gi|2791117515|gb|PQ217832.1| | 5599 | g12040 | i0 | 98.522 | 101.399014778325 | 203 | 3 | 100 | 0 | 1 | 203 | 5350 | 5552 | 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 | 20584 | 359 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 21571169 | 21571169 | PRJNA675638_P_NODE_6197_length_275_cov_1.384956_g6000_i0 | PRJNA675638 | 6197 | 275 | 1.384956 | 3.808629 | Eukaryota | 2759 | Fungi | Fungi | 455 | 1.65e-123 | NTclustered | gi|949172902|gb|KT263458.1| | 1750757 | g6000 | i0 | 96.39 | 100.730909090909 | 277 | 8 | 100 | 2 | 1 | 275 | 945 | 669 | Capnodiales sp. A545 large subunit ribosomal RNA gene, partial sequence | blastn | 27701 | 455 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Capnodiales | Capnodiales sp. A545 | |||
| 21571199 | 21571199 | PRJNA675638_S_NODE_7357_length_169_cov_0.833333_g7295_i0 | PRJNA675638 | 7357 | 169 | 0.833333 | 1.40833277 | root | 1 | Root_unresolved | Root_unresolved | 307 | 2.73e-79 | NTclustered | gi|1275558205|ref|NG_055690.1| | 4931 | g7295 | i0 | 99.408 | 112.846153846154 | 169 | 1 | 100 | 0 | 1 | 169 | 1387 | 1555 | Saccharomyces bayanus NRRL Y-12624 28S rRNA gene, partial sequence; from TYPE material | blastn | 19071 | 307 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Saccharomyces | Saccharomyces bayanus | |
| 22846343 | 22846343 | PRJNA675638_P_NODE_13318_length_196_cov_0.965986_g13121_i0 | PRJNA675638 | 13318 | 196 | 0.965986 | 1.89333256 | Fungi | 4751 | Fungi | Fungi | 363 | 6.899999999999998e-96 | NTclustered | gi|2195309747|gb|OM736062.1| | 5599 | g13121 | i0 | 100 | 100 | 196 | 0 | 100 | 0 | 1 | 196 | 241 | 46 | Alternaria alternata strain BJ106.4 small subunit ribosomal RNA gene, partial sequence | blastn | 19600 | 363 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 22846364 | 22846364 | PRJNA675638_P_NODE_18378_length_167_cov_0.864407_g18181_i0 | PRJNA675638 | 18378 | 167 | 0.864407 | 1.44355969 | Saccharomyces | 4930 | Fungi | Fungi | 309 | 7.53e-80 | NTclustered | gi|1389182097|gb|CP029160.1| | 4932 | g18181 | i0 | 100 | 7.97604790419162 | 167 | 0 | 100 | 0 | 1 | 167 | 5097530 | 5097364 | Saccharomyces cerevisiae strain SY14 chromosome I, complete sequence | blastn | 1332 | 309 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Saccharomyces | Saccharomyces cerevisiae | |
| 22846426 | 22846426 | PRJNA675638_S_NODE_4938_length_203_cov_0.824675_g4876_i0 | PRJNA675638 | 4938 | 203 | 0.824675 | 1.67409025 | Cladosporium | 5498 | Fungi | Fungi | 313 | 7.3499999999999995e-81 | NTclustered | gi|169894415|gb|EU343558.1| | 29918 | g4876 | i0 | 94.581 | 100.004926108374 | 203 | 9 | 99 | 2 | 1 | 202 | 86 | 287 | Davidiella tassiana clone k104-5 large subunit ribosomal RNA gene, partial sequence | blastn | 20301 | 313 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium herbarum |
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);;