contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA811714" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2085162 | 2085162 | PRJNA811714_P_NODE_28562_length_221_cov_5.067568_g28369_i0 | PRJNA811714 | 28562 | 221 | 5.067568 | 11.19932528 | Tolypocladium paradoxum | 94208 | Fungi | Fungi | 133 | 2.2299999999999993e-34 | NR | POR35274.1 | 94208 | g28369 | i0 | 82.2 | 0.990950226244344 | 73 | 13 | 99.1 | 0 | 221 | 3 | 494 | 566 | POR35274.1 Lysophospholipase [Tolypocladium paradoxum] | diamond | 219 | 133 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Ophiocordycipitaceae | Tolypocladium | Tolypocladium paradoxum | |
| 7187853 | 7187853 | PRJNA811714_P_NODE_32826_length_197_cov_6.653226_g32633_i0 | PRJNA811714 | 32826 | 197 | 6.653226 | 13.10685522 | Argynnaceae | 281106 | Fungi | Fungi | 133 | 5.56e-35 | NR | KAJ9668801.1 | 61459 | g32633 | i0 | 89.2 | 2.96954314720812 | 65 | 7 | 99 | 0 | 195 | 1 | 36 | 100 | KAJ9668801.1 ornithine aminotransferase [Coniosporium apollinis] | diamond | 585 | 133 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Coniosporium | Coniosporium apollinis | |||
| 12288555 | 12288555 | PRJNA811714_P_NODE_19970_length_247_cov_2.655172_g19777_i0 | PRJNA811714 | 19970 | 247 | 2.655172 | 6.55827484 | Sarocladium implicatum | 1610689 | Fungi | Fungi | 154 | 1.42e-41 | NR | KAH8179523.1 | 1610689 | g19777 | i0 | 93.8 | 1.9919028340081 | 81 | 5 | 98.4 | 0 | 244 | 2 | 167 | 247 | KAH8179523.1 type III restriction enzyme, res subunit domain-containing protein [Sarocladium implicatum] | diamond | 492 | 154 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium implicatum | |
| 18660406 | 18660406 | PRJNA811714_P_NODE_11615_length_290_cov_2.129032_g11422_i0 | PRJNA811714 | 11615 | 290 | 2.129032 | 6.1741928 | Sarocladium strictum | 5046 | Fungi | Fungi | 156 | 5e-42 | NR | KAK0392668.1 | 5046 | g11422 | i0 | 87.5 | 1.98620689655172 | 96 | 12 | 99.3 | 0 | 3 | 290 | 183 | 278 | KAK0392668.1 hypothetical protein NLU13_2163 [Sarocladium strictum] | diamond | 576 | 156 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium strictum | |
| 27812628 | 27812628 | PRJNA811714_P_NODE_22984_length_238_cov_2.800000_g22791_i0 | PRJNA811714 | 22984 | 238 | 2.8 | 6.664 | Aspergillus novofumigatus IBT 168 | 340412 | Fungi | Fungi | 43.9 | 0.0136 | NR | XP_024685771.1 | 1392255 | g22791 | i0 | 43.6 | 0.69327731092437 | 55 | 25 | 69.3 | 1 | 53 | 217 | 221 | 269 | XP_024685771.1 putative amino acid transporter [Aspergillus novofumigatus IBT 16806] | diamond | 165 | 43.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus novofumigatus | |
| 27875446 | 27875446 | PRJNA811714_P_NODE_24285_length_234_cov_2.869565_g24092_i0 | PRJNA811714 | 24285 | 234 | 2.869565 | 6.7147821 | Aspergillus ruber CBS 13568 | 396024 | Fungi | Fungi | 78.6 | 8.21e-15 | NR | XP_040640055.1 | 1388766 | g24092 | i0 | 59.2 | 0.974358974358974 | 76 | 24 | 97.4 | 2 | 228 | 1 | 690 | 758 | XP_040640055.1 actin patch protein 1, partial [Aspergillus ruber CBS 135680] | diamond | 228 | 78.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus ruber | |
| 28033572 | 28033572 | PRJNA811714_P_NODE_18105_length_254_cov_2.552486_g17912_i0 | PRJNA811714 | 18105 | 254 | 2.552486 | 6.48331444 | Venturia nashicola | 86259 | Fungi | Fungi | 105 | 2.4199999999999998e-24 | NR | TLD06847.1 | 86259 | g17912 | i0 | 70.4 | 0.838582677165354 | 71 | 21 | 83.9 | 0 | 253 | 41 | 443 | 513 | TLD06847.1 dihydropteroate synthase/7-6-hydroxymethylpterin-pyrophosphokinase/Dihydroneopterin aldolase, partial [Venturia nashicola] | diamond | 213 | 105 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Venturiales | Venturiaceae | Venturia | Venturia nashicola | |
| 28064961 | 28064961 | PRJNA811714_P_NODE_11985_length_287_cov_2.158879_g11792_i0 | PRJNA811714 | 11985 | 287 | 2.158879 | 6.19598273 | Fusarium tricinctum | 61284 | Fungi | Fungi | 85.5 | 5.9e-17 | NR | KAH7251153.1 | 61284 | g11792 | i0 | 53.7 | 0.993031358885017 | 95 | 43 | 98.3 | 1 | 3 | 284 | 356 | 450 | KAH7251153.1 hypothetical protein BKA59DRAFT_543033 [Fusarium tricinctum] | diamond | 285 | 85.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium tricinctum | |
| 28791053 | 28791053 | PRJNA811714_P_NODE_25827_length_230_cov_2.942675_g25634_i0 | PRJNA811714 | 25827 | 230 | 2.942675 | 6.7681525 | Sarocladium strictum | 5046 | Fungi | Fungi | 105 | 1.49e-24 | NR | KAK0385389.1 | 5046 | g25634 | i0 | 77 | 0.795652173913043 | 61 | 14 | 79.6 | 0 | 183 | 1 | 1 | 61 | KAK0385389.1 hypothetical protein NLU13_7865 [Sarocladium strictum] | diamond | 183 | 105 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium strictum | |
| 29801448 | 29801448 | PRJNA811714_P_NODE_25411_length_231_cov_2.924051_g25218_i0 | PRJNA811714 | 25411 | 231 | 2.924051 | 6.75455781 | Sarocladium strictum | 5046 | Fungi | Fungi | 130 | 5.9400000000000005e-33 | NR | KAL2209520.1 | 5046 | g25218 | i0 | 88 | 1.96103896103896 | 75 | 9 | 97.4 | 0 | 6 | 230 | 701 | 775 | KAL2209520.1 hypothetical protein CC79DRAFT_681348 [Sarocladium strictum] | diamond | 453 | 130 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium strictum | |
| 30252840 | 30252840 | PRJNA811714_P_NODE_23312_length_237_cov_2.817073_g23119_i0 | PRJNA811714 | 23312 | 237 | 2.817073 | 6.67646301 | Aspergillus | 5052 | Fungi | Fungi | 134 | 1.5399999999999999e-34 | NR | KAL4782379.1 | 176181 | g23119 | i0 | 82.1 | 6.91139240506329 | 78 | 14 | 98.7 | 0 | 3 | 236 | 164 | 241 | KAL4782379.1 BRO1-like domain-containing protein [Aspergillus varians] | diamond | 1638 | 134 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus varians | |
| 30591332 | 30591332 | PRJNA811714_P_NODE_19353_length_249_cov_2.625000_g19160_i0 | PRJNA811714 | 19353 | 249 | 2.625 | 6.53625 | Sarocladium strictum | 5046 | Fungi | Fungi | 46.6 | 0.0014 | NR | KAL2209005.1 | 5046 | g19160 | i0 | 75 | 0.337349397590361 | 28 | 6 | 32.5 | 1 | 81 | 1 | 1 | 28 | KAL2209005.1 hypothetical protein CC79DRAFT_1356233 [Sarocladium strictum] | diamond | 84 | 46.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium strictum | |
| 30686033 | 30686033 | PRJNA811714_P_NODE_19433_length_249_cov_2.625000_g19240_i0 | PRJNA811714 | 19433 | 249 | 2.625 | 6.53625 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 147 | 4.58e-39 | NR | XP_069234200.1 | 1052096 | g19240 | i0 | 85.4 | 0.987951807228916 | 82 | 12 | 98.8 | 0 | 3 | 248 | 745 | 826 | XP_069234200.1 uncharacterized protein WHR41_00471 [Cladosporium halotolerans] | diamond | 246 | 147 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 31002234 | 31002234 | PRJNA811714_P_NODE_21214_length_243_cov_2.717647_g21021_i0 | PRJNA811714 | 21214 | 243 | 2.717647 | 6.60388221 | Saxophila tyrrhenica | 1690608 | Fungi | Fungi | 106 | 9.74e-25 | NR | XP_064657886.1 | 1690608 | g21021 | i0 | 61.3 | 8.38271604938272 | 80 | 30 | 97.5 | 1 | 5 | 241 | 391 | 470 | XP_064657886.1 uncharacterized protein LTR77_006845 [Saxophila tyrrhenica] | diamond | 2037 | 106 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Extremaceae | Saxophila | Saxophila tyrrhenica | |
| 31034031 | 31034031 | PRJNA811714_P_NODE_20015_length_247_cov_2.655172_g19822_i0 | PRJNA811714 | 20015 | 247 | 2.655172 | 6.55827484 | Hortaea werneckii | 91943 | Fungi | Fungi | 67.4 | 5.16e-11 | NR | KAI6904821.1 | 91943 | g19822 | i0 | 82.1 | 1.42105263157895 | 39 | 7 | 47.4 | 0 | 187 | 71 | 1 | 39 | KAI6904821.1 putative pectate lyase [Hortaea werneckii] | diamond | 351 | 67.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Hortaea | Hortaea werneckii | |
| 31042885 | 31042885 | PRJNA811714_P_NODE_21055_length_243_cov_5.417647_g20862_i0 | PRJNA811714 | 21055 | 243 | 5.417647 | 13.16488221 | Aspergillus | 5052 | Fungi | Fungi | 148 | 7.91e-41 | NR | KAE8147257.1 | 36643 | g20862 | i0 | 80.2 | 13 | 81 | 16 | 100 | 0 | 1 | 243 | 168 | 248 | KAE8147257.1 hypothetical protein BDV25DRAFT_36282 [Aspergillus avenaceus] | diamond | 3159 | 149 | 0.993288590604027 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus avenaceus | |
| 31824121 | 31824121 | PRJNA811714_P_NODE_21997_length_241_cov_2.714286_g21804_i0 | PRJNA811714 | 21997 | 241 | 2.714286 | 6.54142926 | Sarocladium strictum | 5046 | Fungi | Fungi | 152 | 1.0499999999999999e-40 | NR | KAL2209716.1 | 5046 | g21804 | i0 | 88.8 | 1.99170124481328 | 80 | 9 | 99.6 | 0 | 1 | 240 | 832 | 911 | KAL2209716.1 pectin lyase-like protein [Sarocladium strictum] | diamond | 480 | 152 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium strictum | |
| 31982340 | 31982340 | PRJNA811714_P_NODE_26198_length_229_cov_3.557692_g26005_i0 | PRJNA811714 | 26198 | 229 | 3.557692 | 8.14711468 | Immersiella caudata | 314043 | Fungi | Fungi | 43.1 | 0.0237 | NR | KAK0626312.1 | 314043 | g26005 | i0 | 39.4 | 0.864628820960699 | 66 | 39 | 86.5 | 1 | 28 | 225 | 808 | 872 | KAK0626312.1 SAC3/GANP/Nin1/mts3/eIF-3 p25 family-domain-containing protein [Immersiella caudata] | diamond | 198 | 43.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Lasiosphaeriaceae | Immersiella | Immersiella caudata | |
| 32457239 | 32457239 | PRJNA811714_P_NODE_14359_length_272_cov_2.321608_g14166_i0 | PRJNA811714 | 14359 | 272 | 2.321608 | 6.31477376 | Aspergillus glaucus CBS 516.65 | 1160497 | Fungi | Fungi | 51.2 | 5.56e-5 | NR | XP_022399658.1 | 1160497 | g14166 | i0 | 58.7 | 0.694852941176471 | 63 | 19 | 68.4 | 3 | 243 | 58 | 632 | 688 | XP_022399658.1 uncharacterized protein ASPGLDRAFT_48290 [Aspergillus glaucus CBS 516.65] | diamond | 189 | 51.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus glaucus |
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);;