contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA414036" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26617368 | 26617368 | PRJNA414036_P_NODE_58841_length_221_cov_2.849462_g57102_i0 | PRJNA414036 | 58841 | 221 | 2.849462 | 6.29731102 | Fungi | 4751 | Fungi | Fungi | 56.2 | 4.95e-7 | NR | CDS14081.1 | 688394 | g57102 | i0 | 57.7 | 19.1809954751131 | 71 | 30 | 96.4 | 0 | 2 | 214 | 256 | 326 | CDS14081.1 hypothetical protein LRAMOSA06252 [Lichtheimia ramosa] | diamond | 4239 | 56.2 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Lichtheimiaceae | Lichtheimia | Lichtheimia ramosa | |
| 26948895 | 26948895 | PRJNA414036_P_NODE_25922_length_297_cov_1.641221_g24188_i0 | PRJNA414036 | 25922 | 297 | 1.641221 | 4.87442637 | Jimgerdemannia flammicorona | 994334 | Fungi | Fungi | 52.8 | 2.08e-5 | NR | RUP48681.1 | 994334 | g24188 | i0 | 39.8 | 0.888888888888889 | 88 | 53 | 88.9 | 0 | 26 | 289 | 167 | 254 | RUP48681.1 LOW QUALITY PROTEIN: hypothetical protein BC936DRAFT_144186 [Jimgerdemannia flammicorona] | diamond | 264 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Endogonomycetes | Endogonales | Endogonaceae | Jimgerdemannia | Jimgerdemannia flammicorona | |
| 27060582 | 27060582 | PRJNA414036_P_NODE_52522_length_231_cov_1.790816_g50783_i0 | PRJNA414036 | 52522 | 231 | 1.790816 | 4.13678496 | Fungi | 4751 | Fungi | Fungi | 44.7 | 0.00655 | NR | KAG2178643.1 | 44442 | g50783 | i0 | 78.3 | 2.09090909090909 | 23 | 5 | 29.9 | 0 | 6 | 74 | 293 | 315 | KAG2178643.1 hypothetical protein INT44_001796 [Umbelopsis vinacea] | diamond | 483 | 45.1 | 0.991130820399113 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Umbelopsidomycetes | Umbelopsidales | Umbelopsidaceae | Umbelopsis | Umbelopsis vinacea | |
| 27170139 | 27170139 | PRJNA414036_P_NODE_23122_length_315_cov_5.264286_g21391_i0 | PRJNA414036 | 23122 | 315 | 5.264286 | 16.5825009 | Dissophora globulifera | 979702 | Fungi | Fungi | 48.5 | 6.94e-4 | NR | KAG0309644.1 | 979702 | g21391 | i0 | 95.2 | 0.4 | 21 | 1 | 20 | 0 | 12 | 74 | 134 | 154 | KAG0309644.1 hypothetical protein BGZ98_000053, partial [Dissophora globulifera] | diamond | 126 | 48.5 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Dissophora | Dissophora globulifera | |
| 27281936 | 27281936 | PRJNA414036_P_NODE_46023_length_231_cov_3.030612_g44284_i0 | PRJNA414036 | 46023 | 231 | 3.030612 | 7.00071372 | Mucoromycota | 1913637 | Fungi | Fungi | 44.7 | 0.00636 | NR | KAG2205364.1 | 64648 | g44284 | i0 | 70.8 | 2.18181818181818 | 24 | 7 | 31.2 | 0 | 229 | 158 | 83 | 106 | KAG2205364.1 hypothetical protein INT47_007149, partial [Mucor saturninus] | diamond | 504 | 44.7 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Mucor | Mucor saturninus | |
| 27440131 | 27440131 | PRJNA414036_P_NODE_76703_length_168_cov_12.661654_g74964_i0 | PRJNA414036 | 76703 | 168 | 12.661654 | 21.27157872 | Fungi | 4751 | Fungi | Fungi | 63.5 | 8.15e-11 | NR | KAL0073005.1 | 4837 | g74964 | i0 | 77.1 | 11.7857142857143 | 35 | 8 | 62.5 | 0 | 5 | 109 | 49 | 83 | KAL0073005.1 hypothetical protein F4703DRAFT_1947858 [Phycomyces blakesleeanus] | diamond | 1980 | 63.5 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Phycomycetaceae | Phycomyces | Phycomyces blakesleeanus | |
| 27850153 | 27850153 | PRJNA414036_P_NODE_78464_length_165_cov_4.769231_g76725_i0 | PRJNA414036 | 78464 | 165 | 4.7692310000000004 | 7.86923115 | root | 1 | Root_unresolved | Root_unresolved | 43.1 | 0.0093 | NR | KAF0471710.1 | 4874 | g76725 | i0 | 56 | 388.181818181818 | 50 | 22 | 90.9 | 0 | 3 | 152 | 123 | 172 | KAF0471710.1 eukaryotic translation initiation factor 2 subunit gamma [Gigaspora margarita] | diamond | 64050 | 43.5 | 0.990804597701149 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Diversisporales | Gigasporaceae | Gigaspora | Gigaspora margarita | |
| 27945092 | 27945092 | PRJNA414036_P_NODE_79305_length_164_cov_2.480620_g77566_i0 | PRJNA414036 | 79305 | 164 | 2.48062 | 4.0682168 | Fungi | 4751 | Fungi | Fungi | 62 | 2.02e-9 | NR | XP_052939809.1 | 64632 | g77566 | i0 | 56.6 | 29.0853658536585 | 53 | 23 | 97 | 0 | 163 | 5 | 214 | 266 | XP_052939809.1 aconitate hydratase [Mycotypha africana] | diamond | 4770 | 62 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mycotyphaceae | Mycotypha | Mycotypha africana | |
| 28149507 | 28149507 | PRJNA414036_P_NODE_21665_length_325_cov_3.931034_g19937_i0 | PRJNA414036 | 21665 | 325 | 3.931034 | 12.7758605 | Ambispora gerdemannii | 144530 | Fungi | Fungi | 46.6 | 8.3e-4 | NR | CAG8672381.1 | 144530 | g19937 | i0 | 38.2 | 0.821538461538462 | 89 | 43 | 82.2 | 1 | 301 | 35 | 1 | 77 | CAG8672381.1 7555_t:CDS:2, partial [Ambispora gerdemannii] | diamond | 267 | 46.6 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Archaeosporales | Ambisporaceae | Ambispora | Ambispora gerdemannii | |
| 28243938 | 28243938 | PRJNA414036_P_NODE_67946_length_189_cov_2.103896_g66207_i0 | PRJNA414036 | 67946 | 189 | 2.103896 | 3.97636344 | Haplosporangium sp. Z 11 | 1897648 | Fungi | Fungi | 59.7 | 1.84e-8 | NR | KAF9188359.1 | 1897648 | g66207 | i0 | 55.7 | 19.3968253968254 | 61 | 27 | 96.8 | 0 | 2 | 184 | 189 | 249 | KAF9188359.1 putative protein serine/threonine kinase [Haplosporangium sp. Z 11] | diamond | 3666 | 59.7 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Haplosporangium | Haplosporangium sp. Z 11 | |
| 28545160 | 28545160 | PRJNA414036_P_NODE_62727_length_206_cov_2.280702_g60988_i0 | PRJNA414036 | 62727 | 206 | 2.280702 | 4.69824612 | Eukaryota | 2759 | Fungi | Fungi | 74.3 | 1.07e-13 | NR | KAI9317987.1 | 101130 | g60988 | i0 | 73.1 | 74.9563106796116 | 52 | 14 | 75.7 | 0 | 44 | 199 | 254 | 305 | KAI9317987.1 XAP5, circadian clock regulator-domain-containing protein [Dichotomocladium elegans] | diamond | 15441 | 74.7 | 0.994645247657296 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Lichtheimiaceae | Dichotomocladium | Dichotomocladium elegans | |
| 28591546 | 28591546 | PRJNA414036_P_NODE_74647_length_172_cov_37.686131_g72908_i0 | PRJNA414036 | 74647 | 172 | 37.686131 | 64.82014532 | Lobosporangium transversale | 64571 | Fungi | Fungi | 44.3 | 0.004 | NR | XP_021875810.1 | 64571 | g72908 | i0 | 63.6 | 0.575581395348837 | 33 | 12 | 57.6 | 0 | 6 | 104 | 573 | 605 | XP_021875810.1 hypothetical protein BCR41DRAFT_426538 [Lobosporangium transversale] | diamond | 99 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Lobosporangium | Lobosporangium transversale | |
| 28623170 | 28623170 | PRJNA414036_P_NODE_89207_length_150_cov_2.165217_g87468_i0 | PRJNA414036 | 89207 | 150 | 2.165217 | 3.2478255 | Cetraspora pellucida | 1433469 | Fungi | Fungi | 45.8 | 5.51e-4 | NR | CAG8814962.1 | 1433469 | g87468 | i0 | 64.9 | 0.74 | 37 | 13 | 74 | 0 | 30 | 140 | 144 | 180 | CAG8814962.1 9201_t:CDS:2, partial [Cetraspora pellucida] | diamond | 111 | 45.8 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Diversisporales | Gigasporaceae | Cetraspora | Cetraspora pellucida | |
| 29096731 | 29096731 | PRJNA414036_P_NODE_18888_length_346_cov_8.344051_g17165_i0 | PRJNA414036 | 18888 | 346 | 8.344051 | 28.87041646 | Acaulospora colombiana | 27376 | Fungi | Fungi | 49.3 | 1.41e-4 | NR | CAG8733833.1 | 27376 | g17165 | i0 | 51 | 0.42485549132948 | 49 | 24 | 42.5 | 0 | 346 | 200 | 10 | 58 | CAG8733833.1 15428_t:CDS:1, partial [Acaulospora colombiana] | diamond | 147 | 49.3 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Diversisporales | Acaulosporaceae | Acaulospora | Acaulospora colombiana | |
| 29475199 | 29475199 | PRJNA414036_P_NODE_27850_length_285_cov_11.844000_g26115_i0 | PRJNA414036 | 27850 | 285 | 11.844 | 33.7554 | Ambispora gerdemannii | 144530 | Fungi | Fungi | 45.4 | 0.00647 | NR | CAG8672369.1 | 144530 | g26115 | i0 | 56.5 | 0.484210526315789 | 46 | 20 | 48.4 | 0 | 120 | 257 | 1 | 46 | CAG8672369.1 7554_t:CDS:2, partial [Ambispora gerdemannii] | diamond | 138 | 45.4 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Archaeosporales | Ambisporaceae | Ambispora | Ambispora gerdemannii | |
| 29601496 | 29601496 | PRJNA414036_P_NODE_72010_length_178_cov_6.895105_g70271_i0 | PRJNA414036 | 72010 | 178 | 6.895105 | 12.2732869 | Phycomyces blakesleeanus NRRL 1555(-) | 763407 | Fungi | Fungi | 41.6 | 0.0405 | NR | XP_018285970.1 | 763407 | g70271 | i0 | 43.2 | 0.741573033707865 | 44 | 24 | 74.2 | 1 | 148 | 17 | 112 | 154 | XP_018285970.1 hypothetical protein PHYBLDRAFT_188905 [Phycomyces blakesleeanus NRRL 1555(-)] | diamond | 132 | 41.6 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Phycomycetaceae | Phycomyces | Phycomyces blakesleeanus | |
| 31782150 | 31782150 | PRJNA414036_P_NODE_59317_length_219_cov_2.804348_g57578_i0 | PRJNA414036 | 59317 | 219 | 2.804348 | 6.14152212 | Geosiphon pyriformis | 50956 | Fungi | Fungi | 42 | 0.0493 | NR | KAG9296627.1 | 50956 | g57578 | i0 | 69 | 0.397260273972603 | 29 | 9 | 39.7 | 0 | 131 | 217 | 42 | 70 | KAG9296627.1 hypothetical protein G9A89_002898 [Geosiphon pyriformis] | diamond | 87 | 42 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Archaeosporales | Geosiphonaceae | Geosiphon | Geosiphon pyriformis | |
| 32130539 | 32130539 | PRJNA414036_P_NODE_83678_length_157_cov_2.811475_g81939_i0 | PRJNA414036 | 83678 | 157 | 2.811475 | 4.41401575 | Endogone sp. FLAS-F59 | 2012134 | Fungi | Fungi | 50.8 | 1.48e-5 | NR | RUS20584.1 | 2340872 | g81939 | i0 | 48 | 0.955414012738854 | 50 | 26 | 95.5 | 0 | 155 | 6 | 238 | 287 | RUS20584.1 hypothetical protein BC937DRAFT_94892 [Endogone sp. FLAS-F59071] | diamond | 150 | 50.8 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Endogonomycetes | Endogonales | Endogonaceae | Endogone | Endogone sp. FLAS-F59071 |
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);;