contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA340009" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 392292 | 392292 | PRJNA340009_P_NODE_48561_length_186_cov_0.970803_g48254_i0 | PRJNA340009 | 48561 | 186 | 0.970803 | 1.80569358 | Acaulospora morrowiae | 94023 | Fungi | Fungi | 99 | 1.56e-22 | NR | CAG8756323.1 | 94023 | g48254 | i0 | 75.4 | 5.88709677419355 | 61 | 15 | 98.4 | 0 | 3 | 185 | 268 | 328 | CAG8756323.1 6050_t:CDS:2, partial [Acaulospora morrowiae] | diamond | 1095 | 99 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Diversisporales | Acaulosporaceae | Acaulospora | Acaulospora morrowiae | |
| 23344028 | 23344028 | PRJNA340009_P_NODE_32779_length_219_cov_1.476471_g32472_i0 | PRJNA340009 | 32779 | 219 | 1.476471 | 3.23347149 | Calcarisporiella thermophila | 911321 | Fungi | Fungi | 68.9 | 1.39e-11 | NR | XP_069248697.1 | 911321 | g32472 | i0 | 59.1 | 1.80821917808219 | 66 | 26 | 90.4 | 1 | 11 | 208 | 4 | 68 | XP_069248697.1 uncharacterized protein VTP21DRAFT_3818 [Calcarisporiella thermophila] | diamond | 396 | 68.9 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Calcarisporiellales | Calcarisporiellaceae | Calcarisporiella | Calcarisporiella thermophila | ||
| 27439892 | 27439892 | PRJNA340009_P_NODE_27163_length_237_cov_1.351064_g26856_i0 | PRJNA340009 | 27163 | 237 | 1.351064 | 3.20202168 | root | 1 | Root_unresolved | Root_unresolved | 75.5 | 1.01e-13 | NR | RIA80003.1 | 658196 | g26856 | i0 | 56.5 | 22.0886075949367 | 62 | 26 | 78.5 | 1 | 44 | 229 | 1018 | 1078 | RIA80003.1 hypothetical protein C1645_839467 [Glomus cerebriforme] | diamond | 5235 | 75.5 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Glomerales | Glomeraceae | Glomus | Glomus cerebriforme | |
| 27738485 | 27738485 | PRJNA340009_P_NODE_79784_length_154_cov_6.723810_g79477_i0 | PRJNA340009 | 79784 | 154 | 6.72381 | 10.3546674 | Geosiphon pyriformis | 50956 | Fungi | Fungi | 47 | 3.41e-4 | NR | KAG9292464.1 | 50956 | g79477 | i0 | 52.1 | 0.935064935064935 | 48 | 17 | 89.6 | 2 | 15 | 152 | 175 | 218 | KAG9292464.1 hypothetical protein G9A89_000462 [Geosiphon pyriformis] | diamond | 144 | 47 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Archaeosporales | Geosiphonaceae | Geosiphon | Geosiphon pyriformis | |
| 27895849 | 27895849 | PRJNA340009_P_NODE_37965_length_206_cov_1.171975_g37658_i0 | PRJNA340009 | 37965 | 206 | 1.171975 | 2.4142685 | Bifiguratus adelaidae | 1938954 | Fungi | Fungi | 54.7 | 1.42e-6 | NR | OZJ06253.1 | 1938954 | g37658 | i0 | 76.7 | 1.70388349514563 | 30 | 7 | 43.7 | 0 | 204 | 115 | 1658 | 1687 | OZJ06253.1 hypothetical protein BZG36_00796 [Bifiguratus adelaidae] | diamond | 351 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Endogonomycetes | Endogonales | Bifiguratus | Bifiguratus adelaidae | ||
| 29365668 | 29365668 | PRJNA340009_P_NODE_65089_length_166_cov_0.871795_g64782_i0 | PRJNA340009 | 65089 | 166 | 0.871795 | 1.4471797 | Mortierellaceae | 4854 | Fungi | Fungi | 41.6 | 0.0351 | NR | KAG0002609.1 | 101097 | g64782 | i0 | 34.6 | 5.60240963855422 | 52 | 34 | 94 | 0 | 4 | 159 | 1451 | 1502 | KAG0002609.1 hypothetical protein BGZ79_002672 [Entomortierella chlamydospora] | diamond | 930 | 42 | 0.990476190476191 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Entomortierella | Entomortierella chlamydospora | |
| 29523472 | 29523472 | PRJNA340009_P_NODE_56530_length_174_cov_1.368000_g56223_i0 | PRJNA340009 | 56530 | 174 | 1.368 | 2.38032 | Mucoromycota | 1913637 | Fungi | Fungi | 47.8 | 1.91e-4 | NR | ORX50836.1 | 101127 | g56223 | i0 | 84 | 1.25862068965517 | 25 | 4 | 43.1 | 0 | 3 | 77 | 191 | 215 | ORX50836.1 hypothetical protein DM01DRAFT_1337438 [Hesseltinella vesiculosa] | diamond | 219 | 47.8 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Cunninghamellaceae | Hesseltinella | Hesseltinella vesiculosa | |
| 29600692 | 29600692 | PRJNA340009_P_NODE_7150_length_414_cov_2.290411_g6843_i0 | PRJNA340009 | 7150 | 414 | 2.290411 | 9.48230154 | Rhizopus delemar | 936053 | Fungi | Fungi | 153 | 5.12e-44 | NR | KAG1461572.1 | 936053 | g6843 | i0 | 66.4 | 0.86231884057971 | 119 | 37 | 85.5 | 2 | 361 | 8 | 21 | 137 | KAG1461572.1 hypothetical protein G6F56_005699 [Rhizopus delemar] | diamond | 357 | 153 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus delemar | |
| 30565538 | 30565538 | PRJNA340009_P_NODE_76473_length_161_cov_0.910714_g76166_i0 | PRJNA340009 | 76473 | 161 | 0.910714 | 1.46624954 | Mortierellaceae | 4854 | Fungi | Fungi | 53.1 | 2.51e-6 | NR | KAG0230508.1 | 90253 | g76166 | i0 | 51.9 | 4.02484472049689 | 54 | 24 | 96.9 | 1 | 1 | 156 | 85 | 138 | KAG0230508.1 NADH-cytochrome b5 reductase [Actinomortierella wolfii] | diamond | 648 | 53.5 | 0.992523364485981 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Actinomortierella | Actinomortierella wolfii | |
| 30945140 | 30945140 | PRJNA340009_P_NODE_55714_length_175_cov_1.595238_g55407_i0 | PRJNA340009 | 55714 | 175 | 1.595238 | 2.7916665 | Eukaryota | 2759 | Fungi | Fungi | 59.7 | 1.57e-8 | NR | ORX51653.1 | 101127 | g55407 | i0 | 67.4 | 3.34285714285714 | 43 | 14 | 73.7 | 0 | 46 | 174 | 577 | 619 | ORX51653.1 transketolase [Hesseltinella vesiculosa] | diamond | 585 | 59.7 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Cunninghamellaceae | Hesseltinella | Hesseltinella vesiculosa | |
| 31292580 | 31292580 | PRJNA340009_P_NODE_77915_length_159_cov_97.894231_g77608_i0 | PRJNA340009 | 77915 | 159 | 97.894231 | 155.65182729 | Mortierellaceae | 4854 | Fungi | Fungi | 56.2 | 1.8e-8 | NR | KAF9926120.1 | 979765 | g77608 | i0 | 54.2 | 2.75471698113208 | 48 | 22 | 90.6 | 0 | 144 | 1 | 41 | 88 | KAF9926120.1 hypothetical protein FBU30_004264 [Linnemannia zychae] | diamond | 438 | 56.6 | 0.992932862190813 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Linnemannia | Linnemannia zychae | |
| 31767021 | 31767021 | PRJNA340009_P_NODE_77057_length_161_cov_0.910714_g76750_i0 | PRJNA340009 | 77057 | 161 | 0.910714 | 1.46624954 | root | 1 | Root_unresolved | Root_unresolved | 48.5 | 1.12e-4 | NR | OZJ03339.1 | 1938954 | g76750 | i0 | 69.7 | 3.98757763975155 | 33 | 10 | 61.5 | 0 | 139 | 41 | 617 | 649 | OZJ03339.1 hypothetical protein BZG36_04216, partial [Bifiguratus adelaidae] | diamond | 642 | 48.5 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Endogonomycetes | Endogonales | Bifiguratus | Bifiguratus adelaidae | ||
| 32256439 | 32256439 | PRJNA340009_P_NODE_41318_length_198_cov_5.154362_g41011_i0 | PRJNA340009 | 41318 | 198 | 5.154362 | 10.20563676 | Rhizomucor pusillus | 4840 | Fungi | Fungi | 45.1 | 0.00321 | NR | XP_069234733.1 | 4840 | g41011 | i0 | 38.2 | 2.71212121212121 | 55 | 34 | 83.3 | 0 | 34 | 198 | 61 | 115 | XP_069234733.1 uncharacterized protein VTP01DRAFT_6033 [Rhizomucor pusillus] | diamond | 537 | 45.1 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Lichtheimiaceae | Rhizomucor | Rhizomucor pusillus | |
| 32414398 | 32414398 | PRJNA340009_P_NODE_51019_length_182_cov_1.458647_g50712_i0 | PRJNA340009 | 51019 | 182 | 1.458647 | 2.65473754 | Cokeromyces recurvatus | 90255 | Fungi | Fungi | 88.6 | 6.740000000000001e-21 | NR | XP_051378828.1 | 90255 | g50712 | i0 | 65 | 0.989010989010989 | 60 | 21 | 98.9 | 0 | 182 | 3 | 31 | 90 | XP_051378828.1 transcriptional coactivator/pterin dehydratase [Cokeromyces recurvatus] | diamond | 180 | 88.6 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Cokeromyces | Cokeromyces recurvatus |
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);;