contig_metadata
15 rows where bioproject = "PRJEB4632" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 990068 | 990068 | PRJEB4632_P_NODE_401_length_347_cov_8.350365_g363_i0 | PRJEB4632 | 401 | 347 | 8.350365 | 28.97576655 | Ascomycota | 4890 | Fungi | Fungi | 621 | 1.9999999999999997e-173 | NTclustered | gi|1050550568|gb|KX664389.1| | 29917 | g363 | i0 | 99.13 | 99.4236311239193 | 345 | 3 | 99 | 0 | 3 | 347 | 501 | 845 | Cladosporium cladosporioides isolate F37-03 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 34500 | 621 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium cladosporioides | |
| 11193410 | 11193410 | PRJEB4632_P_NODE_1089_length_200_cov_4.220472_g1051_i0 | PRJEB4632 | 1089 | 200 | 4.220472 | 8.440944 | Eukaryota | 2759 | Fungi | Fungi | 370 | 4.22e-98 | NTclustered | gi|33334391|gb|AF548077.1| | 5520 | g1051 | i0 | 100 | 99.955 | 200 | 0 | 100 | 0 | 1 | 200 | 1362 | 1561 | Microdochium nivale strain UPSC 3273 18S ribosomal RNA gene, partial sequence | blastn | 19991 | 370 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Xylariales | Microdochiaceae | Microdochium | Microdochium nivale | |
| 13743509 | 13743509 | PRJEB4632_P_NODE_1091_length_199_cov_5.023810_g1053_i0 | PRJEB4632 | 1091 | 199 | 5.02381 | 9.9973819 | Sordariomycetes | 147550 | Fungi | Fungi | 366 | 5.43e-97 | NTclustered | gi|1391724147|gb|MH379771.1| | 31870 | g1053 | i0 | 100 | 103.984924623116 | 198 | 0 | 99 | 0 | 2 | 199 | 53 | 250 | Colletotrichum graminicola strain SF11 large subunit ribosomal RNA gene, partial sequence | blastn | 20693 | 368 | 0.994565217391304 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Glomerellales | Glomerellaceae | Colletotrichum | Colletotrichum graminicola | |
| 15363783 | 15363783 | PRJEB4632_P_NODE_1053_length_223_cov_6.680000_g1015_i0 | PRJEB4632 | 1053 | 223 | 6.68 | 14.8964 | Neonectria lugdunensis | 57155 | Fungi | Fungi | 394 | 2.86e-105 | NTclustered | gi|2532687047|gb|OR243775.1| | 57155 | g1015 | i0 | 98.655 | 104.013452914798 | 223 | 2 | 100 | 1 | 1 | 223 | 3701 | 3922 | Neonectria lugdunensis strain DSM 104372 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 | 23195 | 394 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Neonectria | Neonectria lugdunensis | |
| 16638355 | 16638355 | PRJEB4632_P_NODE_714_length_258_cov_2.313514_g676_i0 | PRJEB4632 | 714 | 258 | 2.313514 | 5.96886612 | Exophiala xenobiotica | 348802 | Fungi | Fungi | 416 | 7.229999999999998e-112 | NTclustered | gi|915144019|ref|XR_001230708.1| | 348802 | g676 | i0 | 96.787 | 96.5891472868217 | 249 | 8 | 97 | 0 | 1 | 249 | 2574 | 2326 | Exophiala xenobiotica 28S ribosomal RNA (PV05_12071), rRNA | blastn | 24920 | 416 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Herpotrichiellaceae | Exophiala | Exophiala xenobiotica | |
| 17567867 | 17567867 | PRJEB4632_P_NODE_474_length_321_cov_2.943548_g436_i0 | PRJEB4632 | 474 | 321 | 2.943548 | 9.44878908 | Cladosporium | 5498 | Fungi | Fungi | 593 | 3.9899999999999986e-165 | NTclustered | gi|283827952|gb|EU019262.2| | 29917 | g436 | i0 | 100 | 74.803738317757 | 321 | 0 | 100 | 0 | 1 | 321 | 2936 | 3256 | Cladosporium cladosporioides strain CBS 109.21 28S large subunit ribosomal RNA gene, partial sequence | blastn | 24012 | 593 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium cladosporioides | |
| 19187102 | 19187102 | PRJEB4632_P_NODE_856_length_247_cov_0.885057_g818_i0 | PRJEB4632 | 856 | 247 | 0.885057 | 2.18609079 | Ascomycota | 4890 | Fungi | Fungi | 169 | 6.73e-49 | NR | KKO96813.1 | 5544 | g818 | i0 | 93.9 | 5.97570850202429 | 82 | 5 | 99.6 | 0 | 2 | 247 | 282 | 363 | KKO96813.1 high-affinity iron transporter [Trichoderma harzianum] | diamond | 1476 | 170 | 0.994117647058824 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Hypocreaceae | Trichoderma | Trichoderma harzianum | |
| 20462431 | 20462431 | PRJEB4632_P_NODE_517_length_309_cov_4.355932_g479_i0 | PRJEB4632 | 517 | 309 | 4.355932 | 13.45982988 | Clonostachys rosea | 29856 | Fungi | Fungi | 508 | 1.42e-139 | NTclustered | gi|1358186631|gb|MH047188.1| | 29856 | g479 | i0 | 96.44 | 104.006472491909 | 309 | 9 | 100 | 2 | 1 | 309 | 3753 | 4059 | Clonostachys rosea 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 32138 | 508 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Bionectriaceae | Clonostachys | Clonostachys rosea | |
| 21392128 | 21392128 | PRJEB4632_P_NODE_577_length_292_cov_4.146119_g539_i0 | PRJEB4632 | 577 | 292 | 4.146119 | 12.10666748 | Fusarium | 5506 | Fungi | Fungi | 518 | 2.22e-142 | NTclustered | gi|1206256888|emb|LT841236.1| | 42551 | g539 | i0 | 98.63 | 112.890410958904 | 292 | 4 | 100 | 0 | 1 | 292 | 5529 | 5238 | Fusarium oxysporum f. sp. dianthi partial 18S rRNA gene for 18S ribosomal RNA, strain Fod008 | blastn | 32964 | 523 | 0.990439770554493 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium oxysporum | |
| 23013530 | 23013530 | PRJEB4632_P_NODE_1059_length_220_cov_5.244898_g1021_i0 | PRJEB4632 | 1059 | 220 | 5.244898 | 11.5387756 | Acremonium sp. A109 | 1420317 | Fungi | Fungi | 390 | 3.629999999999999e-104 | NTclustered | gi|557786427|gb|KC987222.1| | 1420317 | g1021 | i0 | 98.636 | 100.259090909091 | 220 | 3 | 100 | 0 | 1 | 220 | 1392 | 1611 | Acremonium sp. A109 28S large subunit ribosomal RNA gene, partial sequence | blastn | 22057 | 390 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Acremonium | Acremonium sp. A109 | ||
| 25216177 | 25216177 | PRJEB4632_P_NODE_1020_length_232_cov_2.283019_g982_i0 | PRJEB4632 | 1020 | 232 | 2.283019 | 5.29660408 | root | 1 | Root_unresolved | Root_unresolved | 429 | 8.2e-116 | NTclustered | gi|1280049812|gb|MF072571.1| | 29917 | g982 | i0 | 100 | 100 | 232 | 0 | 100 | 0 | 1 | 232 | 309 | 78 | Cladosporium cladosporioides strain 007 small subunit ribosomal RNA gene, partial sequence | blastn | 23200 | 429 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium cladosporioides | |
| 25216184 | 25216184 | PRJEB4632_P_NODE_680_length_267_cov_1.211340_g642_i0 | PRJEB4632 | 680 | 267 | 1.21134 | 3.2342778 | Dothideales | 5014 | Fungi | Fungi | 494 | 3.38e-135 | NTclustered | gi|1472904920|gb|MH844411.1| | 64485 | g642 | i0 | 100 | 99.6441947565543 | 267 | 0 | 100 | 0 | 1 | 267 | 178 | 444 | Dothiora europaea strain AG7 internal transcribed spacer 2 and large subunit ribosomal RNA gene, partial sequence | blastn | 26605 | 494 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Dothioraceae | Dothiora | Dothiora europaea | |
| 30696862 | 30696862 | PRJEB4632_P_NODE_974_length_242_cov_0.911243_g936_i0 | PRJEB4632 | 974 | 242 | 0.911243 | 2.20520806 | Exophiala viscosa | 2486360 | Fungi | Fungi | 68.2 | 4.03e-11 | NR | XP_062674322.1 | 2486360 | g936 | i0 | 58.9 | 1.09090909090909 | 56 | 21 | 66.9 | 2 | 1 | 162 | 672 | 727 | XP_062674322.1 P-loop containing nucleoside triphosphate hydrolase protein, partial [Exophiala viscosa] | diamond | 264 | 68.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Herpotrichiellaceae | Exophiala | Exophiala viscosa | |
| 30886576 | 30886576 | PRJEB4632_P_NODE_874_length_246_cov_0.890173_g836_i0 | PRJEB4632 | 874 | 246 | 0.890173 | 2.18982558 | Lecanicillium sp. MT-2 | 1756136 | Fungi | Fungi | 100 | 1.71e-22 | NR | KAK3192082.1 | 1964301 | g836 | i0 | 87.5 | 0.682926829268293 | 56 | 7 | 68.3 | 0 | 172 | 5 | 188 | 243 | KAK3192082.1 hypothetical protein K4F52_001709 [Lecanicillium sp. MT-2017a] | diamond | 168 | 100 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Cordycipitaceae | Lecanicillium | Lecanicillium sp. MT-2017a | |
| 30949902 | 30949902 | PRJEB4632_P_NODE_654_length_271_cov_1.353535_g616_i0 | PRJEB4632 | 654 | 271 | 1.353535 | 3.66807985 | Lecanicillium sp. MT-2 | 1756136 | Fungi | Fungi | 154 | 1.91e-41 | NR | KAK3186245.1 | 1964301 | g616 | i0 | 96.4 | 10.1070110701107 | 83 | 3 | 91.9 | 0 | 2 | 250 | 370 | 452 | KAK3186245.1 hypothetical protein K4F52_005009 [Lecanicillium sp. MT-2017a] | diamond | 2739 | 154 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Cordycipitaceae | Lecanicillium | Lecanicillium sp. MT-2017a |
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);;