contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA764222" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12224449 | 12224449 | PRJNA764222_S_NODE_29790_length_170_cov_1.715447_g29632_i0 | PRJNA764222 | 29790 | 170 | 1.715447 | 2.9162599 | Verticillium | 1036719 | Fungi | Fungi | 75.9 | 2.89e-14 | NR | KAG7115392.1 | 100787 | g29632 | i0 | 86.8 | 2.01176470588235 | 38 | 5 | 67.1 | 0 | 1 | 114 | 696 | 733 | KAG7115392.1 4-amino-5-hydroxymethyl-2-methylpyrimidine phosphate synthase like protein [Verticillium longisporum] | diamond | 342 | 75.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Glomerellales | Plectosphaerellaceae | Verticillium | Verticillium longisporum | |
| 26641633 | 26641633 | PRJNA764222_S_NODE_28381_length_175_cov_1.765625_g28223_i0 | PRJNA764222 | 28381 | 175 | 1.765625 | 3.08984375 | Sarocladium strictum | 5046 | Fungi | Fungi | 100 | 6.879999999999999e-23 | NR | KAK0386515.1 | 5046 | g28223 | i0 | 86.2 | 1.98857142857143 | 58 | 8 | 99.4 | 0 | 1 | 174 | 602 | 659 | KAK0386515.1 hypothetical protein NLU13_6350 [Sarocladium strictum] | diamond | 348 | 100 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium strictum | |
| 26768357 | 26768357 | PRJNA764222_S_NODE_28461_length_175_cov_1.187500_g28303_i0 | PRJNA764222 | 28461 | 175 | 1.1875 | 2.078125 | Sarocladium strictum | 5046 | Fungi | Fungi | 119 | 1.3e-33 | NR | KAK0385761.1 | 5046 | g28303 | i0 | 87.9 | 0.994285714285714 | 58 | 7 | 99.4 | 0 | 1 | 174 | 11 | 68 | KAK0385761.1 hypothetical protein NLU13_6938 [Sarocladium strictum] | diamond | 174 | 119 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium strictum | |
| 27147609 | 27147609 | PRJNA764222_S_NODE_15102_length_233_cov_1.344086_g14944_i0 | PRJNA764222 | 15102 | 233 | 1.344086 | 3.13172038 | Sarocladium strictum | 5046 | Fungi | Fungi | 131 | 1.7800000000000002e-33 | NR | KAK0387190.1 | 5046 | g14944 | i0 | 87 | 1.98283261802575 | 77 | 10 | 99.1 | 0 | 232 | 2 | 497 | 573 | KAK0387190.1 hypothetical protein NLU13_5503 [Sarocladium strictum] | diamond | 462 | 131 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium strictum | |
| 27147613 | 27147613 | PRJNA764222_S_NODE_23562_length_194_cov_1.761905_g23404_i0 | PRJNA764222 | 23562 | 194 | 1.761905 | 3.4180957 | Neonectria ditissima | 78410 | Fungi | Fungi | 45.1 | 0.00296 | NR | KPM37187.1 | 78410 | g23404 | i0 | 45 | 0.618556701030928 | 40 | 22 | 61.9 | 0 | 193 | 74 | 100 | 139 | KPM37187.1 hypothetical protein AK830_g9397 [Neonectria ditissima] | diamond | 120 | 45.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Neonectria | Neonectria ditissima | |
| 27284103 | 27284103 | PRJNA764222_S_NODE_19343_length_212_cov_2.527273_g19185_i0 | PRJNA764222 | 19343 | 212 | 2.527273 | 5.35781876 | Hypocreales | 5125 | Fungi | Fungi | 85.5 | 1.79e-18 | NR | KAK0387230.1 | 5046 | g19185 | i0 | 100 | 7.85377358490566 | 37 | 0 | 52.4 | 0 | 2 | 112 | 185 | 221 | KAK0387230.1 hypothetical protein NLU13_5543 [Sarocladium strictum] | diamond | 1665 | 85.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium strictum | |
| 27432695 | 27432695 | PRJNA764222_S_NODE_8563_length_273_cov_7.084071_g8405_i0 | PRJNA764222 | 8563 | 273 | 7.084071 | 19.33951383 | Leptodontidium sp. 2 PMI_412 | 1485227 | Fungi | Fungi | 122 | 1.92e-30 | NR | KAH9203081.1 | 1485227 | g8405 | i0 | 65.9 | 1.86813186813187 | 85 | 29 | 93.4 | 0 | 7 | 261 | 4 | 88 | KAH9203081.1 hypothetical protein DL95DRAFT_322113 [Leptodontidium sp. 2 PMI_412] | diamond | 510 | 122 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Leptodontidiaceae | Leptodontidium | Leptodontidium sp. 2 PMI_412 | |
| 28095487 | 28095487 | PRJNA764222_S_NODE_12445_length_247_cov_2.235000_g12287_i0 | PRJNA764222 | 12445 | 247 | 2.235 | 5.52045 | Ophiocordyceps australis | 1399860 | Fungi | Fungi | 45.1 | 0.00596 | NR | PHH58730.1 | 1399860 | g12287 | i0 | 45.8 | 0.582995951417004 | 48 | 26 | 58.3 | 0 | 232 | 89 | 225 | 272 | PHH58730.1 hypothetical protein CDD81_4735 [Ophiocordyceps australis] | diamond | 144 | 45.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Ophiocordycipitaceae | Ophiocordyceps | Ophiocordyceps australis | |
| 28452597 | 28452597 | PRJNA764222_S_NODE_24386_length_191_cov_1.361111_g24228_i0 | PRJNA764222 | 24386 | 191 | 1.361111 | 2.59972201 | Sarocladium | 284134 | Fungi | Fungi | 102 | 7.9799999999999985e-25 | NR | KAK0391720.1 | 5046 | g24228 | i0 | 94.8 | 1.82198952879581 | 58 | 3 | 91.1 | 0 | 2 | 175 | 201 | 258 | KAK0391720.1 hypothetical protein NLU13_1219 [Sarocladium strictum] | diamond | 348 | 102 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium strictum | |
| 29106012 | 29106012 | PRJNA764222_S_NODE_29148_length_172_cov_2.120000_g28990_i0 | PRJNA764222 | 29148 | 172 | 2.12 | 3.6464 | Sarocladium implicatum | 1610689 | Fungi | Fungi | 127 | 2.0899999999999998e-32 | NR | KAH8173034.1 | 1610689 | g28990 | i0 | 98.2 | 0.994186046511628 | 57 | 1 | 99.4 | 0 | 1 | 171 | 591 | 647 | KAH8173034.1 fungal zn(2)-Cys(6) binuclear cluster domain-containing protein [Sarocladium implicatum] | diamond | 171 | 127 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium implicatum | |
| 29494374 | 29494374 | PRJNA764222_S_NODE_26310_length_183_cov_1.911765_g26152_i0 | PRJNA764222 | 26310 | 183 | 1.911765 | 3.49852995 | Sarocladium | 284134 | Fungi | Fungi | 103 | 6.21e-24 | NR | KAL2202263.1 | 5046 | g26152 | i0 | 88.3 | 2.95081967213115 | 60 | 7 | 98.4 | 0 | 182 | 3 | 70 | 129 | KAL2202263.1 Mechanosensitive ion channel family protein [Sarocladium strictum] | diamond | 540 | 103 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium strictum | |
| 30432735 | 30432735 | PRJNA764222_S_NODE_9313_length_268_cov_1.226244_g9155_i0 | PRJNA764222 | 9313 | 268 | 1.226244 | 3.28633392 | Paramyrothecium foliicola | 1859967 | Fungi | Fungi | 63.2 | 3.39e-9 | NR | KAI9155465.1 | 1859967 | g9155 | i0 | 75 | 1.60074626865672 | 36 | 9 | 40.3 | 0 | 2 | 109 | 1243 | 1278 | KAI9155465.1 ATP-binding cassette multidrug transport protein [Paramyrothecium foliicola] | diamond | 429 | 63.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Stachybotryaceae | Paramyrothecium | Paramyrothecium foliicola | |
| 30464376 | 30464376 | PRJNA764222_S_NODE_24993_length_188_cov_2.156028_g24835_i0 | PRJNA764222 | 24993 | 188 | 2.156028 | 4.05333264 | Podosphaera xanthii | 135283 | Fungi | Fungi | 70.1 | 3.91e-12 | NR | QHD26791.1 | 135283 | g24835 | i0 | 75 | 0.765957446808511 | 48 | 12 | 76.6 | 0 | 146 | 3 | 226 | 273 | QHD26791.1 Ribosomal proteins 3 [Podosphaera xanthii] | diamond | 144 | 70.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Erysiphales | Erysiphaceae | Podosphaera | Podosphaera xanthii | |
| 31158698 | 31158698 | PRJNA764222_S_NODE_18015_length_218_cov_2.695906_g17857_i0 | PRJNA764222 | 18015 | 218 | 2.695906 | 5.87707508 | Purpureocillium lilacinum | 33203 | Fungi | Fungi | 139 | 1.64e-39 | NR | PWI68351.1 | 33203 | g17857 | i0 | 95.5 | 0.922018348623853 | 67 | 3 | 92.2 | 0 | 217 | 17 | 164 | 230 | PWI68351.1 hypothetical protein PCL_02120 [Purpureocillium lilacinum] | diamond | 201 | 139 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Ophiocordycipitaceae | Purpureocillium | Purpureocillium lilacinum | |
| 31190279 | 31190279 | PRJNA764222_S_NODE_22315_length_199_cov_2.032895_g22157_i0 | PRJNA764222 | 22315 | 199 | 2.032895 | 4.04546105 | Plectosphaerella cucumerina | 40658 | Fungi | Fungi | 83.6 | 8.71e-17 | NR | KAH7375148.1 | 40658 | g22157 | i0 | 73.6 | 0.798994974874372 | 53 | 14 | 79.9 | 0 | 37 | 195 | 310 | 362 | KAH7375148.1 copper-transporting P-type ATPase [Plectosphaerella cucumerina] | diamond | 159 | 83.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Glomerellales | Plectosphaerellaceae | Plectosphaerella | Plectosphaerella cucumerina | |
| 31412086 | 31412086 | PRJNA764222_S_NODE_18076_length_218_cov_2.093567_g17918_i0 | PRJNA764222 | 18076 | 218 | 2.093567 | 4.56397606 | Sarocladium strictum | 5046 | Fungi | Fungi | 48.5 | 7.47e-5 | NR | KAK0389902.1 | 5046 | g17918 | i0 | 96 | 0.688073394495413 | 25 | 1 | 34.4 | 0 | 216 | 142 | 113 | 137 | KAK0389902.1 hypothetical protein NLU13_3475 [Sarocladium strictum] | diamond | 150 | 48.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium strictum | |
| 31633374 | 31633374 | PRJNA764222_S_NODE_9076_length_269_cov_3.063063_g8918_i0 | PRJNA764222 | 9076 | 269 | 3.063063 | 8.23963947 | Sarocladium strictum | 5046 | Fungi | Fungi | 116 | 9.45e-29 | NR | KAL2211733.1 | 5046 | g8918 | i0 | 67.9 | 1.79553903345725 | 78 | 25 | 87 | 0 | 235 | 2 | 211 | 288 | KAL2211733.1 hypothetical protein CC79DRAFT_1393013 [Sarocladium strictum] | diamond | 483 | 116 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium strictum | |
| 31642896 | 31642896 | PRJNA764222_S_NODE_27956_length_177_cov_1.200000_g27798_i0 | PRJNA764222 | 27956 | 177 | 1.2 | 2.124 | Fusarium | 5506 | Fungi | Fungi | 103 | 5.29e-24 | NR | TXC11617.1 | 61366 | g27798 | i0 | 82.8 | 6.88135593220339 | 58 | 10 | 98.3 | 0 | 177 | 4 | 509 | 566 | TXC11617.1 hypothetical protein FocTR4_00007661 [Fusarium oxysporum f. sp. cubense] | diamond | 1218 | 103 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium oxysporum | |
| 31759917 | 31759917 | PRJNA764222_S_NODE_12377_length_247_cov_3.580000_g12219_i0 | PRJNA764222 | 12377 | 247 | 3.58 | 8.8426 | Purpureocillium lilacinum | 33203 | Fungi | Fungi | 63.2 | 6.76e-10 | NR | KAK4058956.1 | 33203 | g12219 | i0 | 80 | 0.48582995951417 | 40 | 8 | 48.6 | 0 | 1 | 120 | 156 | 195 | KAK4058956.1 hypothetical protein Purlil1_14414 [Purpureocillium lilacinum] | diamond | 120 | 63.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Ophiocordycipitaceae | Purpureocillium | Purpureocillium lilacinum | |
| 32139687 | 32139687 | PRJNA764222_S_NODE_11138_length_255_cov_2.475962_g10980_i0 | PRJNA764222 | 11138 | 255 | 2.475962 | 6.3137031 | Sarocladium strictum | 5046 | Fungi | Fungi | 42.7 | 0.011 | NR | KAK0386472.1 | 5046 | g10980 | i0 | 100 | 0.247058823529412 | 21 | 0 | 24.7 | 0 | 254 | 192 | 85 | 105 | KAK0386472.1 hypothetical protein NLU13_6307 [Sarocladium strictum] | diamond | 63 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium strictum | |
| 32139695 | 32139695 | PRJNA764222_S_NODE_3998_length_327_cov_1.996429_g3840_i0 | PRJNA764222 | 3998 | 327 | 1.996429 | 6.52832283 | Purpureocillium lilacinum | 33203 | Fungi | Fungi | 179 | 1.69e-49 | NR | PWI65551.1 | 33203 | g3840 | i0 | 94.8 | 0.880733944954128 | 96 | 5 | 88.1 | 0 | 2 | 289 | 757 | 852 | PWI65551.1 hypothetical protein PCL_06970 [Purpureocillium lilacinum] | diamond | 288 | 179 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Ophiocordycipitaceae | Purpureocillium | Purpureocillium lilacinum |
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);;