contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA1158727" and tax_phylum = "Mucoromycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7959675 | 7959675 | PRJNA1158727_P_NODE_79647_length_340_cov_3.419476_g72186_i0 | PRJNA1158727 | 79647 | 340 | 3.419476 | 11.6262184 | Fungi | 4751 | Fungi | Fungi | 138 | 2.37e-35 | NR | KAG1177093.1 | 58291 | g72186 | i0 | 59.1 | 14.2411764705882 | 110 | 45 | 97.1 | 0 | 331 | 2 | 484 | 593 | KAG1177093.1 hypothetical protein G6F71_002869 [Rhizopus microsporus] | diamond | 4842 | 139 | 0.992805755395683 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus microsporus | |
| 8690717 | 8690717 | PRJNA1158727_P_NODE_65227_length_396_cov_2.591331_g57766_i0 | PRJNA1158727 | 65227 | 396 | 2.591331 | 10.26167076 | Mortierella sp. AM989 | 1896186 | Fungi | Fungi | 79 | 4.55e-14 | NR | KAF9109561.1 | 1896186 | g57766 | i0 | 52.3 | 0.992424242424242 | 65 | 26 | 49.2 | 1 | 58 | 252 | 350 | 409 | KAF9109561.1 hypothetical protein BGX27_007475 [Mortierella sp. AM989] | diamond | 393 | 79 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Mortierella | Mortierella sp. AM989 | |
| 9231834 | 9231834 | PRJNA1158727_P_NODE_134468_length_251_cov_1.730337_g127006_i0 | PRJNA1158727 | 134468 | 251 | 1.730337 | 4.34314587 | Eukaryota | 2759 | Fungi | Fungi | 124 | 4.38e-33 | NR | CAG8654347.1 | 4874 | g127006 | i0 | 78.2 | 37.1593625498008 | 78 | 17 | 93.2 | 0 | 249 | 16 | 91 | 168 | CAG8654347.1 36623_t:CDS:2 [Gigaspora margarita] | diamond | 9327 | 124 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Diversisporales | Gigasporaceae | Gigaspora | Gigaspora margarita | |
| 13790941 | 13790941 | PRJNA1158727_P_NODE_31071_length_784_cov_1.416315_g24119_i0 | PRJNA1158727 | 31071 | 784 | 1.416315 | 11.1039096 | Fungi | 4751 | Fungi | Fungi | 358 | 2.4399999999999993e-121 | NR | KAF0515524.1 | 4874 | g24119 | i0 | 67.2 | 15.5892857142857 | 253 | 83 | 96.8 | 0 | 6 | 764 | 1 | 253 | KAF0515524.1 40S ribosomal protein S4 [Gigaspora margarita] | diamond | 12222 | 360 | 0.994444444444444 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Diversisporales | Gigasporaceae | Gigaspora | Gigaspora margarita | |
| 18156024 | 18156024 | PRJNA1158727_P_NODE_155675_length_243_cov_2.694118_g148213_i0 | PRJNA1158727 | 155675 | 243 | 2.694118 | 6.54670674 | Fungi | 4751 | Fungi | Fungi | 135 | 1.7399999999999997e-35 | NR | CAG8586502.1 | 27376 | g148213 | i0 | 74.1 | 14 | 81 | 21 | 100 | 0 | 1 | 243 | 359 | 439 | CAG8586502.1 140_t:CDS:2 [Acaulospora colombiana] | diamond | 3402 | 136 | 0.992647058823529 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Diversisporales | Acaulosporaceae | Acaulospora | Acaulospora colombiana | |
| 26806520 | 26806520 | PRJNA1158727_P_NODE_136761_length_250_cov_2.661017_g129299_i0 | PRJNA1158727 | 136761 | 250 | 2.661017 | 6.6525425 | Eukaryota | 2759 | Fungi | Fungi | 106 | 9.61e-25 | NR | KAG9300577.1 | 50956 | g129299 | i0 | 79.7 | 3.708 | 59 | 12 | 70.8 | 0 | 177 | 1 | 7 | 65 | KAG9300577.1 hypothetical protein G9A89_000758 [Geosiphon pyriformis] | diamond | 927 | 106 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Archaeosporales | Geosiphonaceae | Geosiphon | Geosiphon pyriformis | |
| 27735654 | 27735654 | PRJNA1158727_P_NODE_82444_length_332_cov_2.378378_g74983_i0 | PRJNA1158727 | 82444 | 332 | 2.378378 | 7.89621496 | Rhizopus delemar | 936053 | Fungi | Fungi | 139 | 9.98e-39 | NR | KAG1461572.1 | 936053 | g74983 | i0 | 72.7 | 0.894578313253012 | 99 | 24 | 88.6 | 2 | 34 | 327 | 21 | 117 | KAG1461572.1 hypothetical protein G6F56_005699 [Rhizopus delemar] | diamond | 297 | 139 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus delemar | |
| 27924776 | 27924776 | PRJNA1158727_P_NODE_104765_length_286_cov_1.389671_g97304_i0 | PRJNA1158727 | 104765 | 286 | 1.389671 | 3.97445906 | Bifiguratus adelaidae | 1938954 | Fungi | Fungi | 102 | 9.17e-23 | NR | OZJ03038.1 | 1938954 | g97304 | i0 | 57 | 3.93356643356643 | 93 | 38 | 95.5 | 1 | 9 | 281 | 125 | 217 | OZJ03038.1 hypothetical protein BZG36_03263 [Bifiguratus adelaidae] | diamond | 1125 | 102 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Endogonomycetes | Endogonales | Bifiguratus | Bifiguratus adelaidae | ||
| 28619608 | 28619608 | PRJNA1158727_P_NODE_69967_length_374_cov_3.225914_g62506_i0 | PRJNA1158727 | 69967 | 374 | 3.225914 | 12.06491836 | Syncephalastrum racemosum | 13706 | Fungi | Fungi | 113 | 6.23e-29 | NR | ORZ01496.1 | 13706 | g62506 | i0 | 53.5 | 0.914438502673797 | 114 | 48 | 87.4 | 2 | 43 | 369 | 1 | 114 | ORZ01496.1 translationally controlled tumor protein [Syncephalastrum racemosum] | diamond | 342 | 113 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Syncephalastraceae | Syncephalastrum | Syncephalastrum racemosum | |
| 28796423 | 28796423 | PRJNA1158727_P_NODE_52687_length_477_cov_1.690594_g45229_i0 | PRJNA1158727 | 52687 | 477 | 1.690594 | 8.06413338 | Mortierellaceae | 4854 | Fungi | Fungi | 231 | 2.92e-68 | NR | KAF9968364.1 | 64518 | g45229 | i0 | 66 | 19.9811320754717 | 159 | 54 | 100 | 0 | 477 | 1 | 513 | 671 | KAF9968364.1 RING finger and WD repeat domain-containing protein 2, partial [Mortierella alpina] | diamond | 9531 | 232 | 0.995689655172414 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Mortierella | Mortierella alpina | |
| 29345689 | 29345689 | PRJNA1158727_P_NODE_52989_length_474_cov_3.568579_g45531_i0 | PRJNA1158727 | 52989 | 474 | 3.568579 | 16.91506446 | Gongronella butleri | 101105 | Fungi | Fungi | 66.6 | 5.26e-10 | NR | KAI8075209.1 | 101105 | g45531 | i0 | 67.4 | 0.544303797468354 | 43 | 14 | 27.2 | 0 | 15 | 143 | 175 | 217 | KAI8075209.1 GPR1/FUN34/yaaH family-domain-containing protein [Gongronella butleri] | diamond | 258 | 66.6 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Cunninghamellaceae | Gongronella | Gongronella butleri | |
| 29755896 | 29755896 | PRJNA1158727_P_NODE_140151_length_249_cov_1.289773_g132689_i0 | PRJNA1158727 | 140151 | 249 | 1.289773 | 3.21153477 | Entrophospora sp. SA1 | 1920922 | Fungi | Fungi | 59.3 | 5.73e-8 | NR | CAJ0907474.1 | 2562287 | g132689 | i0 | 43.7 | 0.855421686746988 | 71 | 30 | 75.9 | 3 | 59 | 247 | 299 | 367 | CAJ0907474.1 9563_t:CDS:2, partial [Entrophospora sp. SA101] | diamond | 213 | 59.3 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Entrophosporales | Entrophosporaceae | Entrophospora | Entrophospora sp. SA101 | |
| 30691562 | 30691562 | PRJNA1158727_P_NODE_101673_length_290_cov_1.382488_g94212_i0 | PRJNA1158727 | 101673 | 290 | 1.382488 | 4.0092152 | root | 1 | Root_unresolved | Root_unresolved | 88.6 | 3.99e-19 | NR | KAG0337260.1 | 64523 | g94212 | i0 | 46.2 | 3.91034482758621 | 93 | 50 | 96.2 | 0 | 9 | 287 | 133 | 225 | KAG0337260.1 hypothetical protein BG004_007709, partial [Podila humilis] | diamond | 1134 | 89.4 | 0.991051454138702 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Podila | Podila humilis | |
| 31462649 | 31462649 | PRJNA1158727_P_NODE_58576_length_434_cov_2.127424_g51115_i0 | PRJNA1158727 | 58576 | 434 | 2.127424 | 9.23302016 | Absidia repens | 90262 | Fungi | Fungi | 85.1 | 6.04e-18 | NR | ORZ04917.1 | 90262 | g51115 | i0 | 42.4 | 1.76267281105991 | 118 | 63 | 80.9 | 2 | 397 | 47 | 2 | 115 | ORZ04917.1 ribosomal protein L28e [Absidia repens] | diamond | 765 | 85.1 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Cunninghamellaceae | Absidia | Absidia repens | |
| 31873552 | 31873552 | PRJNA1158727_P_NODE_127197_length_259_cov_1.655914_g119736_i0 | PRJNA1158727 | 127197 | 259 | 1.655914 | 4.28881726 | Mortierella sp. NVP85 | 1896193 | Fungi | Fungi | 72.4 | 1.22e-13 | NR | KAF9364308.1 | 1896193 | g119736 | i0 | 43.5 | 2.95366795366795 | 85 | 47 | 98.5 | 1 | 256 | 2 | 23 | 106 | KAF9364308.1 60S ribosomal protein L28 [Mortierella sp. NVP85] | diamond | 765 | 72.4 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Mortierella | Mortierella sp. NVP85 | |
| 32272900 | 32272900 | PRJNA1158727_P_NODE_142598_length_248_cov_1.537143_g135136_i0 | PRJNA1158727 | 142598 | 248 | 1.537143 | 3.81211464 | Eukaryota | 2759 | Fungi | Fungi | 120 | 3.05e-30 | NR | KAF1802766.1 | 29924 | g135136 | i0 | 61 | 30.0241935483871 | 82 | 32 | 99.2 | 0 | 3 | 248 | 3 | 84 | KAF1802766.1 actin family [Mucor lusitanicus] | diamond | 7446 | 120 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Mucor | Mucor lusitanicus | |
| 32651680 | 32651680 | PRJNA1158727_P_NODE_63240_length_407_cov_1.383234_g55779_i0 | PRJNA1158727 | 63240 | 407 | 1.383234 | 5.62976238 | Opisthokonta | 33154 | Fungi | Fungi | 93.2 | 5.17e-19 | NR | XP_069240602.1 | 4840 | g55779 | i0 | 56.6 | 13.4447174447174 | 76 | 32 | 55.3 | 1 | 156 | 380 | 491 | 566 | XP_069240602.1 uncharacterized protein VTP01DRAFT_9096 [Rhizomucor pusillus] | diamond | 5472 | 93.6 | 0.995726495726496 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Lichtheimiaceae | Rhizomucor | Rhizomucor pusillus | |
| 32789869 | 32789869 | PRJNA1158727_P_NODE_135900_length_251_cov_0.865169_g128438_i0 | PRJNA1158727 | 135900 | 251 | 0.865169 | 2.17157419 | Dentiscutata erythropus | 1348616 | Fungi | Fungi | 60.8 | 1.75e-8 | NR | CAG8485594.1 | 1348616 | g128438 | i0 | 45.6 | 2.23505976095618 | 68 | 35 | 81.3 | 1 | 213 | 10 | 446 | 511 | CAG8485594.1 26797_t:CDS:10 [Dentiscutata erythropus] | diamond | 561 | 60.8 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Diversisporales | Gigasporaceae | Dentiscutata | Dentiscutata erythropus |
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);;