contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA1129273" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9211236 | 9211236 | PRJNA1129273_P_NODE_10948_length_233_cov_2.193750_g10668_i0 | PRJNA1129273 | 10948 | 233 | 2.19375 | 5.1114375 | Fungi | 4751 | Fungi | Fungi | 108 | 4.75e-26 | NR | XP_069242005.1 | 4840 | g10668 | i0 | 72.9 | 10.6480686695279 | 70 | 19 | 90.1 | 0 | 2 | 211 | 198 | 267 | XP_069242005.1 60S ribosomal protein uL4 [Rhizomucor pusillus] | diamond | 2481 | 108 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Lichtheimiaceae | Rhizomucor | Rhizomucor pusillus | |
| 9211244 | 9211244 | PRJNA1129273_P_NODE_2688_length_465_cov_1.966837_g2410_i0 | PRJNA1129273 | 2688 | 465 | 1.966837 | 9.14579205 | Mucorales | 4827 | Fungi | Fungi | 174 | 1.42e-50 | NR | OBZ89140.1 | 101091 | g2410 | i0 | 71.9 | 7.04516129032258 | 114 | 32 | 73.5 | 0 | 343 | 2 | 14 | 127 | OBZ89140.1 Protein arginine N-methyltransferase 1 [Choanephora cucurbitarum] | diamond | 3276 | 174 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Choanephoraceae | Choanephora | Choanephora cucurbitarum | |
| 27006915 | 27006915 | PRJNA1129273_P_NODE_7462_length_266_cov_1.450777_g7182_i0 | PRJNA1129273 | 7462 | 266 | 1.450777 | 3.85906682 | Calcarisporiella thermophila | 911321 | Fungi | Fungi | 103 | 5.33e-25 | NR | XP_069253582.1 | 911321 | g7182 | i0 | 64.4 | 0.981203007518797 | 87 | 30 | 98.1 | 1 | 4 | 264 | 129 | 214 | XP_069253582.1 60S ribosomal protein eL6 [Calcarisporiella thermophila] | diamond | 261 | 103 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Calcarisporiellales | Calcarisporiellaceae | Calcarisporiella | Calcarisporiella thermophila | ||
| 28270276 | 28270276 | PRJNA1129273_P_NODE_7466_length_266_cov_1.264249_g7186_i0 | PRJNA1129273 | 7466 | 266 | 1.264249 | 3.36290234 | Geosiphon pyriformis | 50956 | Fungi | Fungi | 95.1 | 9.24e-23 | NR | KAG9288311.1 | 50956 | g7186 | i0 | 64.3 | 7.45488721804511 | 84 | 30 | 94.7 | 0 | 3 | 254 | 15 | 98 | KAG9288311.1 hypothetical protein G9A89_021342 [Geosiphon pyriformis] | diamond | 1983 | 95.1 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Archaeosporales | Geosiphonaceae | Geosiphon | Geosiphon pyriformis | |
| 30512619 | 30512619 | PRJNA1129273_P_NODE_10133_length_244_cov_0.900585_g9853_i0 | PRJNA1129273 | 10133 | 244 | 0.900585 | 2.1974274 | Rhizophagus irregularis DAOM 197198w | 1432141 | Fungi | Fungi | 42.4 | 0.0404 | NR | EXX50520.1 | 1432141 | g9853 | i0 | 32.4 | 0.909836065573771 | 74 | 42 | 81.1 | 1 | 226 | 29 | 75 | 148 | EXX50520.1 hypothetical protein RirG_270120 [Rhizophagus irregularis DAOM 197198w] | diamond | 222 | 42.4 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Glomerales | Glomeraceae | Rhizophagus | Rhizophagus irregularis | |
| 31164954 | 31164954 | PRJNA1129273_P_NODE_6575_length_279_cov_1.485437_g6295_i0 | PRJNA1129273 | 6575 | 279 | 1.485437 | 4.14436923 | Mortierellaceae | 4854 | Fungi | Fungi | 91.7 | 3.33e-19 | NR | GJJ71224.1 | 205924 | g6295 | i0 | 48.4 | 2.91397849462366 | 91 | 46 | 96.8 | 1 | 277 | 8 | 393 | 483 | GJJ71224.1 twinfilin [Entomortierella parvispora] | diamond | 813 | 91.7 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Entomortierella | Entomortierella parvispora | |
| 31418216 | 31418216 | PRJNA1129273_P_NODE_7076_length_271_cov_1.727273_g6796_i0 | PRJNA1129273 | 7076 | 271 | 1.727273 | 4.68090983 | Entrophospora | 27375 | Fungi | Fungi | 52.4 | 1.96e-5 | NR | CAG8523998.1 | 984092 | g6796 | i0 | 32.9 | 4.06273062730627 | 73 | 48 | 80.8 | 1 | 256 | 38 | 62 | 133 | CAG8523998.1 15415_t:CDS:10 [Entrophospora candida] | diamond | 1101 | 52.8 | 0.992424242424242 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Entrophosporales | Entrophosporaceae | Entrophospora | Entrophospora candida | |
| 31639544 | 31639544 | PRJNA1129273_P_NODE_7256_length_268_cov_2.317949_g6976_i0 | PRJNA1129273 | 7256 | 268 | 2.317949 | 6.21210332 | Mucoromycota | 1913637 | Fungi | Fungi | 47.8 | 3.94e-4 | NR | KAG1247908.1 | 58291 | g6976 | i0 | 60.6 | 13.0746268656716 | 33 | 13 | 36.9 | 0 | 1 | 99 | 17 | 49 | KAG1247908.1 hypothetical protein G6F68_014006 [Rhizopus microsporus] | diamond | 3504 | 48.1 | 0.993762993762994 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus microsporus | |
| 31987544 | 31987544 | PRJNA1129273_P_NODE_9918_length_245_cov_0.895349_g9638_i0 | PRJNA1129273 | 9918 | 245 | 0.895349 | 2.19360505 | Cunninghamellaceae | 4851 | Fungi | Fungi | 90.1 | 2.62e-20 | NR | SAM06261.1 | 4829 | g9638 | i0 | 55.7 | 2.90204081632653 | 79 | 35 | 96.7 | 0 | 239 | 3 | 110 | 188 | SAM06261.1 hypothetical protein [Absidia glauca] | diamond | 711 | 90.1 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Cunninghamellaceae | Absidia | Absidia glauca | |
| 32019263 | 32019263 | PRJNA1129273_P_NODE_10438_length_242_cov_2.710059_g10158_i0 | PRJNA1129273 | 10438 | 242 | 2.710059 | 6.55834278 | Fungi | 4751 | Fungi | Fungi | 55.5 | 1.2e-6 | NR | XP_052934121.1 | 64632 | g10158 | i0 | 45.3 | 2.49173553719008 | 64 | 35 | 79.3 | 0 | 38 | 229 | 339 | 402 | XP_052934121.1 uncharacterized protein BDF20DRAFT_882488 [Mycotypha africana] | diamond | 603 | 55.5 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mycotyphaceae | Mycotypha | Mycotypha africana | |
| 32145872 | 32145872 | PRJNA1129273_P_NODE_8938_length_250_cov_0.864407_g8658_i0 | PRJNA1129273 | 8938 | 250 | 0.864407 | 2.1610175 | Fungi | 4751 | Fungi | Fungi | 85.1 | 5.02e-17 | NR | GBB99701.1 | 94130 | g8658 | i0 | 44.2 | 4.788 | 77 | 43 | 92.4 | 0 | 13 | 243 | 270 | 346 | GBB99701.1 hypothetical protein RclHR1_00360050 [Rhizophagus clarus] | diamond | 1197 | 85.1 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Glomerales | Glomeraceae | Rhizophagus | Rhizophagus clarus | |
| 32504997 | 32504997 | PRJNA1129273_P_NODE_2919_length_439_cov_3.434426_g2640_i0 | PRJNA1129273 | 2919 | 439 | 3.434426 | 15.07713014 | Rhizophagus clarus | 94130 | Fungi | Fungi | 165 | 7.43e-49 | NR | GBC07495.1 | 94130 | g2640 | i0 | 60.9 | 19.6400911161731 | 128 | 50 | 87.5 | 0 | 55 | 438 | 33 | 160 | GBC07495.1 hypothetical protein RclHR1_00750029 [Rhizophagus clarus] | diamond | 8622 | 165 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Glomerales | Glomeraceae | Rhizophagus | Rhizophagus clarus |
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);;