contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA395690" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18930550 | 18930550 | PRJNA395690_P_NODE_34835_length_162_cov_0.902655_g34683_i0 | PRJNA395690 | 34835 | 162 | 0.902655 | 1.4623011 | Eukaryota | 2759 | Fungi | Fungi | 87 | 3.13e-18 | NR | KAF9916518.1 | 64571 | g34683 | i0 | 68.5 | 21.3888888888889 | 54 | 17 | 100 | 0 | 1 | 162 | 1005 | 1058 | KAF9916518.1 mRNA binding protein puf3 [Lobosporangium transversale] | diamond | 3465 | 87.4 | 0.995423340961098 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Lobosporangium | Lobosporangium transversale | |
| 22088050 | 22088050 | PRJNA395690_P_NODE_1858_length_574_cov_1.925714_g1711_i0 | PRJNA395690 | 1858 | 574 | 1.925714 | 11.05359836 | Mucoromycota | 1913637 | Fungi | Fungi | 253 | 6.66e-82 | NR | KAG2175289.1 | 44442 | g1711 | i0 | 68.4 | 13.9285714285714 | 177 | 50 | 89.4 | 1 | 572 | 60 | 65 | 241 | KAG2175289.1 hypothetical protein INT44_007777 [Umbelopsis vinacea] | diamond | 7995 | 254 | 0.996062992125984 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Umbelopsidomycetes | Umbelopsidales | Umbelopsidaceae | Umbelopsis | Umbelopsis vinacea | |
| 24638183 | 24638183 | PRJNA395690_P_NODE_4700_length_366_cov_1.126183_g4551_i0 | PRJNA395690 | 4700 | 366 | 1.126183 | 4.12182978 | Eukaryota | 2759 | Fungi | Fungi | 162 | 2.62e-46 | NR | CAG8461983.1 | 27381 | g4551 | i0 | 75 | 11.4344262295082 | 104 | 26 | 85.2 | 0 | 366 | 55 | 228 | 331 | CAG8461983.1 4856_t:CDS:2 [Funneliformis mosseae] | diamond | 4185 | 163 | 0.993865030674847 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Glomerales | Glomeraceae | Funneliformis | Funneliformis mosseae | |
| 27075333 | 27075333 | PRJNA395690_P_NODE_25342_length_174_cov_1.224000_g25190_i0 | PRJNA395690 | 25342 | 174 | 1.224 | 2.12976 | Acaulospora morrowiae | 94023 | Fungi | Fungi | 81.3 | 1.83e-16 | NR | CAG8771415.1 | 94023 | g25190 | i0 | 63.2 | 1.96551724137931 | 57 | 21 | 98.3 | 0 | 2 | 172 | 239 | 295 | CAG8771415.1 17356_t:CDS:1, partial [Acaulospora morrowiae] | diamond | 342 | 81.3 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Diversisporales | Acaulosporaceae | Acaulospora | Acaulospora morrowiae | |
| 28008266 | 28008266 | PRJNA395690_P_NODE_13185_length_224_cov_1.457143_g13033_i0 | PRJNA395690 | 13185 | 224 | 1.457143 | 3.26400032 | Fungi | 4751 | Fungi | Fungi | 96.3 | 1.5699999999999994e-23 | NR | RCH92629.1 | 4846 | g13033 | i0 | 61.4 | 8.55803571428571 | 70 | 27 | 93.8 | 0 | 210 | 1 | 4 | 73 | RCH92629.1 40S ribosomal protein S19, partial [Rhizopus stolonifer] | diamond | 1917 | 97.1 | 0.991761071060762 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus stolonifer | |
| 28923584 | 28923584 | PRJNA395690_P_NODE_33368_length_163_cov_0.894737_g33216_i0 | PRJNA395690 | 33368 | 163 | 0.894737 | 1.45842131 | Mucoromycota | 1913637 | Fungi | Fungi | 53.5 | 1.96e-6 | NR | CEI88982.1 | 58291 | g33216 | i0 | 50.9 | 5.94478527607362 | 55 | 25 | 99.4 | 2 | 1 | 162 | 302 | 355 | CEI88982.1 hypothetical protein RMCBS344292_03358 [Rhizopus microsporus] | diamond | 969 | 53.9 | 0.992578849721707 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus microsporus | |
| 30218412 | 30218412 | PRJNA395690_P_NODE_35432_length_161_cov_1.491071_g35280_i0 | PRJNA395690 | 35432 | 161 | 1.491071 | 2.40062431 | Fungi | 4751 | Fungi | Fungi | 42.7 | 0.011 | NR | CAG8603720.1 | 27376 | g35280 | i0 | 47.1 | 1.90062111801242 | 51 | 23 | 95 | 1 | 154 | 2 | 1 | 47 | CAG8603720.1 10601_t:CDS:2 [Acaulospora colombiana] | diamond | 306 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Diversisporales | Acaulosporaceae | Acaulospora | Acaulospora colombiana | |
| 30408383 | 30408383 | PRJNA395690_P_NODE_9913_length_258_cov_1.598086_g9761_i0 | PRJNA395690 | 9913 | 258 | 1.598086 | 4.12306188 | Fungi | 4751 | Fungi | Fungi | 107 | 7.31e-28 | NR | KAF9436798.1 | 979673 | g9761 | i0 | 65.1 | 9.67441860465116 | 83 | 29 | 96.5 | 0 | 253 | 5 | 2 | 84 | KAF9436798.1 hypothetical protein BGZ76_002940 [Entomortierella beljakovae] | diamond | 2496 | 108 | 0.990740740740741 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Entomortierella | Entomortierella beljakovae | |
| 30423255 | 30423255 | PRJNA395690_P_NODE_15273_length_208_cov_1.283019_g15121_i0 | PRJNA395690 | 15273 | 208 | 1.283019 | 2.66867952 | Jimgerdemannia flammicorona | 994334 | Fungi | Fungi | 80.5 | 3.62e-17 | NR | RUS29465.1 | 994334 | g15121 | i0 | 79 | 2.68269230769231 | 62 | 13 | 89.4 | 0 | 3 | 188 | 95 | 156 | RUS29465.1 40S ribosomal protein S24 [Jimgerdemannia flammicorona] | diamond | 558 | 80.5 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Endogonomycetes | Endogonales | Endogonaceae | Jimgerdemannia | Jimgerdemannia flammicorona | |
| 30801962 | 30801962 | PRJNA395690_P_NODE_21574_length_183_cov_1.246269_g21422_i0 | PRJNA395690 | 21574 | 183 | 1.246269 | 2.28067227 | Lunasporangiospora selenospora | 979761 | Fungi | Fungi | 41.2 | 0.0327 | NR | KAF9582147.1 | 979761 | g21422 | i0 | 50 | 0.491803278688525 | 30 | 15 | 49.2 | 0 | 130 | 41 | 115 | 144 | KAF9582147.1 hypothetical protein BGW38_000583 [Lunasporangiospora selenospora] | diamond | 90 | 41.2 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Lunasporangiospora | Lunasporangiospora selenospora | |
| 31546028 | 31546028 | PRJNA395690_P_NODE_4276_length_382_cov_1.822823_g4127_i0 | PRJNA395690 | 4276 | 382 | 1.822823 | 6.96318386 | Fungi | 4751 | Fungi | Fungi | 82.8 | 2.22e-17 | NR | CAG8668522.1 | 1348616 | g4127 | i0 | 42.5 | 8.84293193717278 | 113 | 60 | 88.7 | 2 | 341 | 3 | 7 | 114 | CAG8668522.1 5945_t:CDS:2, partial [Dentiscutata erythropus] | diamond | 3378 | 82.8 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Diversisporales | Gigasporaceae | Dentiscutata | Dentiscutata erythropus | |
| 32146979 | 32146979 | PRJNA395690_P_NODE_28758_length_167_cov_0.864407_g28606_i0 | PRJNA395690 | 28758 | 167 | 0.864407 | 1.44355969 | Mucoromycota | 1913637 | Fungi | Fungi | 45.8 | 0.00109 | NR | KAF8962512.1 | 979712 | g28606 | i0 | 48.1 | 4.02395209580838 | 54 | 24 | 97 | 1 | 3 | 164 | 152 | 201 | KAF8962512.1 hypothetical protein BGZ46_001158 [Entomortierella lignicola] | diamond | 672 | 46.2 | 0.991341991341991 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Entomortierella | Entomortierella lignicola | |
| 32652464 | 32652464 | PRJNA395690_P_NODE_32240_length_164_cov_0.886957_g32088_i0 | PRJNA395690 | 32240 | 164 | 0.886957 | 1.45460948 | Fungi | 4751 | Fungi | Fungi | 73.6 | 6.06e-14 | NR | CAG8448426.1 | 144530 | g32088 | i0 | 69.6 | 5.90853658536585 | 46 | 14 | 84.1 | 0 | 3 | 140 | 200 | 245 | CAG8448426.1 6650_t:CDS:2 [Ambispora gerdemannii] | diamond | 969 | 73.9 | 0.995940460081191 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Archaeosporales | Ambisporaceae | Ambispora | Ambispora gerdemannii |
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);;