contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA506002" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4310993 | 4310993 | PRJNA506002_S_NODE_51744_length_258_cov_1.643243_g51498_i0 | PRJNA506002 | 51744 | 258 | 1.643243 | 4.23956694 | Beauveria bassiana | 176275 | Fungi | Fungi | 124 | 4.91e-24 | NTclustered | gi|667652736|ref|XM_008599978.1| | 655819 | g51498 | i0 | 90.426 | 0.364341085271318 | 94 | 9 | 36 | 0 | 4 | 97 | 960 | 1053 | Beauveria bassiana ARSEF 2860 60S ribosomal protein L4 (BBA_04881), partial mRNA | blastn | 94 | 124 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Cordycipitaceae | Beauveria | Beauveria bassiana | |
| 5587527 | 5587527 | PRJNA506002_S_NODE_18645_length_352_cov_1.197133_g18399_i0 | PRJNA506002 | 18645 | 352 | 1.197133 | 4.21390816 | Gaeumannomyces tritici | 36779 | Fungi | Fungi | 171 | 8.799999999999999e-38 | NTclustered | gi|685395220|ref|XM_009218209.1| | 644352 | g18399 | i0 | 79.747 | 4.84659090909091 | 237 | 46 | 67 | 2 | 74 | 309 | 24 | 259 | Gaeumannomyces tritici R3-111a-1 hypothetical protein mRNA | blastn | 1706 | 171 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Magnaporthales | Magnaporthaceae | Gaeumannomyces | Gaeumannomyces tritici | |
| 6861957 | 6861957 | PRJNA506002_S_NODE_6046_length_458_cov_4.285714_g5801_i0 | PRJNA506002 | 6046 | 458 | 4.285714 | 19.62857012 | Cyphellophora europaea | 293227 | Fungi | Fungi | 217 | 1.49e-51 | NTclustered | gi|671149948|ref|XM_008715760.1| | 1220924 | g5801 | i0 | 81.091 | 28.4235807860262 | 275 | 48 | 60 | 3 | 3 | 275 | 1222 | 1494 | Cyphellophora europaea CBS 101466 pyruvate dehydrogenase complex dihydrolipoamide acetyltransferase (HMPREF1541_11091), partial mRNA | blastn | 13018 | 217 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Cyphellophoraceae | Cyphellophora | Cyphellophora europaea | |
| 9411891 | 9411891 | PRJNA506002_S_NODE_20308_length_344_cov_1.136531_g20062_i0 | PRJNA506002 | 20308 | 344 | 1.136531 | 3.90966664 | Purpureocillium takamizusanense | 2060973 | Fungi | Fungi | 150 | 1.12e-31 | NTclustered | gi|2234672475|ref|XM_047988440.1| | 2060973 | g20062 | i0 | 86.897 | 15.3255813953488 | 145 | 6 | 42 | 6 | 126 | 269 | 550 | 418 | Purpureocillium takamizusanense 60S acidic ribosomal protein P1 (ALTA12), mRNA | blastn | 5272 | 150 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Ophiocordycipitaceae | Purpureocillium | Purpureocillium takamizusanense | |
| 9411953 | 9411953 | PRJNA506002_S_NODE_28668_length_312_cov_1.610879_g28422_i0 | PRJNA506002 | 28668 | 312 | 1.610879 | 5.02594248 | Ascochyta rabiei | 5454 | Fungi | Fungi | 322 | 2.01e-83 | NTclustered | gi|2579372398|ref|XM_038940439.2| | 5454 | g28422 | i0 | 93.519 | 5.76923076923077 | 216 | 14 | 69 | 0 | 97 | 312 | 651 | 436 | Ascochyta rabiei uncharacterized protein (EKO05_0006420), partial mRNA | blastn | 1800 | 322 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymellaceae | Ascochyta | Ascochyta rabiei | |
| 11962921 | 11962921 | PRJNA506002_S_NODE_66790_length_236_cov_2.490798_g66544_i0 | PRJNA506002 | 66790 | 236 | 2.490798 | 5.87828328 | Akanthomyces muscarius | 2231603 | Fungi | Fungi | 169 | 2.01e-37 | NTclustered | gi|2507654566|ref|XM_056200535.1| | 2231603 | g66544 | i0 | 86.928 | 4.4364406779661 | 153 | 16 | 64 | 4 | 1 | 151 | 639 | 789 | Akanthomyces muscarius uncharacterized protein (LMH87_011400), partial mRNA | blastn | 1047 | 169 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Cordycipitaceae | Akanthomyces | Akanthomyces muscarius | |
| 13237682 | 13237682 | PRJNA506002_S_NODE_18031_length_355_cov_1.365248_g17785_i0 | PRJNA506002 | 18031 | 355 | 1.365248 | 4.8466304 | Pochonia chlamydosporia | 280754 | Fungi | Fungi | 228 | 5.2e-55 | NTclustered | gi|1069538784|ref|XM_018281777.1| | 1380566 | g17785 | i0 | 85.455 | 3.33239436619718 | 220 | 30 | 62 | 2 | 128 | 346 | 1464 | 1246 | Pochonia chlamydosporia 170 aldehyde dehydrogenase (VFPPC_02061), partial mRNA | blastn | 1183 | 228 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Clavicipitaceae | Pochonia | Pochonia chlamydosporia | |
| 13237980 | 13237980 | PRJNA506002_S_NODE_49171_length_263_cov_1.215789_g48925_i0 | PRJNA506002 | 49171 | 263 | 1.215789 | 3.19752507 | Paraphaeosphaeria sporulosa | 1460663 | Fungi | Fungi | 401 | 2.0699999999999994e-107 | NTclustered | gi|1066288378|ref|XM_018178813.1| | 1460663 | g48925 | i0 | 96.694 | 22.6692015209125 | 242 | 7 | 92 | 1 | 23 | 263 | 659 | 418 | Paraphaeosphaeria sporulosa 60S ribosomal protein L42 (CC84DRAFT_1165859), mRNA | blastn | 5962 | 401 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Didymosphaeriaceae | Paraphaeosphaeria | Paraphaeosphaeria sporulosa | |
| 13238021 | 13238021 | PRJNA506002_S_NODE_54691_length_253_cov_1.283333_g54445_i0 | PRJNA506002 | 54691 | 253 | 1.283333 | 3.24683249 | Penicillium coprophilum | 36646 | Fungi | Fungi | 87.9 | 6.29e-13 | NTclustered | gi|2513119577|ref|XM_056682061.1| | 36646 | g54445 | i0 | 85.057 | 1.4901185770751 | 87 | 11 | 34 | 2 | 168 | 253 | 1188 | 1103 | Penicillium coprophilum uncharacterized protein (N7500_010923), partial mRNA | blastn | 377 | 87.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium coprophilum | |
| 14512998 | 14512998 | PRJNA506002_S_NODE_53352_length_255_cov_2.115385_g53106_i0 | PRJNA506002 | 53352 | 255 | 2.115385 | 5.39423175 | Saccharomyces eubayanus | 1080349 | Fungi | Fungi | 91.6 | 4.91e-14 | NTclustered | gi|1069852200|ref|XM_018366498.1| | 1080349 | g53106 | i0 | 84.211 | 9.34901960784314 | 95 | 13 | 37 | 2 | 153 | 246 | 1159 | 1066 | Saccharomyces eubayanus translation initiation factor eIF4A (DI49_3430), partial mRNA | blastn | 2384 | 91.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Saccharomyces | Saccharomyces eubayanus | |
| 17061459 | 17061459 | PRJNA506002_S_NODE_59774_length_247_cov_1.770115_g59528_i0 | PRJNA506002 | 59774 | 247 | 1.770115 | 4.37218405 | Penicillium mononematosum | 268346 | Fungi | Fungi | 435 | 1.9e-117 | NTclustered | gi|2517906493|ref|XM_057292147.1| | 268346 | g59528 | i0 | 98.381 | 15.7449392712551 | 247 | 4 | 100 | 0 | 1 | 247 | 1667 | 1421 | Penicillium mononematosum uncharacterized protein (N7519_005371), partial mRNA | blastn | 3889 | 435 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium mononematosum | |
| 18335604 | 18335604 | PRJNA506002_S_NODE_33735_length_297_cov_3.062500_g33489_i0 | PRJNA506002 | 33735 | 297 | 3.0625 | 9.095625 | Purpureocillium takamizusanense | 2060973 | Fungi | Fungi | 233 | 9.180000000000001e-57 | NTclustered | gi|2234647057|ref|XM_047981812.1| | 2060973 | g33489 | i0 | 90 | 15.3771043771044 | 180 | 18 | 61 | 0 | 118 | 297 | 406 | 227 | Purpureocillium takamizusanense 60S ribosomal protein L43 (RPL43), mRNA | blastn | 4567 | 233 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Ophiocordycipitaceae | Purpureocillium | Purpureocillium takamizusanense | |
| 20237007 | 20237007 | PRJNA506002_S_NODE_53656_length_255_cov_1.181319_g53410_i0 | PRJNA506002 | 53656 | 255 | 1.181319 | 3.01236345 | Aspergillus | 5052 | Fungi | Fungi | 178 | 3.66e-40 | NTclustered | gi|1422894546|ref|XM_025702873.1| | 1448311 | g53410 | i0 | 82.126 | 9.33333333333333 | 207 | 37 | 81 | 0 | 34 | 240 | 749 | 543 | Aspergillus vadensis CBS 113365 dienelactone hydrolase family protein (BO88DRAFT_335871), partial mRNA | blastn | 2380 | 178 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus vadensis | |
| 20885815 | 20885815 | PRJNA506002_S_NODE_16677_length_362_cov_1.913495_g16431_i0 | PRJNA506002 | 16677 | 362 | 1.913495 | 6.9268519 | Daldinia decipiens | 326647 | Fungi | Fungi | 189 | 2.51e-43 | NTclustered | gi|2272166360|ref|XM_049240133.1| | 326647 | g16431 | i0 | 81.579 | 1.82044198895028 | 228 | 42 | 63 | 0 | 115 | 342 | 992 | 765 | Daldinia decipiens ribulose-phosphate 3-epimerase (F4813DRAFT_249606), mRNA | blastn | 659 | 189 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Xylariales | Hypoxylaceae | Daldinia | Daldinia decipiens | |
| 22160537 | 22160537 | PRJNA506002_S_NODE_22618_length_334_cov_0.885057_g22372_i0 | PRJNA506002 | 22618 | 334 | 0.885057 | 2.95609038 | Scheffersomyces amazonensis | 1078765 | Fungi | Fungi | 78.7 | 5.19e-10 | NTclustered | gi|2725044944|ref|XM_064881648.1| | 1078765 | g22372 | i0 | 92.727 | 2.17365269461078 | 55 | 3 | 16 | 1 | 126 | 179 | 91 | 145 | Scheffersomyces amazonensis uncharacterized protein (RJT21DRAFT_120199), partial mRNA | blastn | 726 | 78.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Scheffersomyces | Scheffersomyces amazonensis | |
| 24709930 | 24709930 | PRJNA506002_S_NODE_40260_length_281_cov_3.139423_g40014_i0 | PRJNA506002 | 40260 | 281 | 3.139423 | 8.82177863 | Hirsutella rhossiliensis | 111463 | Fungi | Fungi | 274 | 5.08e-69 | NTclustered | gi|2124713977|ref|XM_044859486.1| | 111463 | g40014 | i0 | 88.21 | 6.48398576512456 | 229 | 27 | 81 | 0 | 24 | 252 | 530 | 302 | Hirsutella rhossiliensis amino acid permease domain-containing protein (HRG_01015), partial mRNA | blastn | 1822 | 274 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Ophiocordycipitaceae | Hirsutella | Hirsutella rhossiliensis |
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);;