contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA554794" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 520902 | 520902 | PRJNA554794_P_NODE_22381_length_169_cov_0.941667_g18452_i0 | PRJNA554794 | 22381 | 169 | 0.941667 | 1.59141723 | Eukaryota | 2759 | Fungi | Fungi | 90.9 | 1.45e-19 | NR | CAG8503373.1 | 144538 | g18452 | i0 | 71.4 | 9.94082840236686 | 56 | 16 | 99.4 | 0 | 1 | 168 | 328 | 383 | CAG8503373.1 8135_t:CDS:10 [Paraglomus brasilianum] | diamond | 1680 | 91.7 | 0.991275899672846 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Paraglomerales | Paraglomeraceae | Paraglomus | Paraglomus brasilianum | |
| 27615483 | 27615483 | PRJNA554794_P_NODE_11244_length_324_cov_1.025455_g7317_i0 | PRJNA554794 | 11244 | 324 | 1.025455 | 3.3224742 | Entrophospora sp. SA1 | 1920922 | Fungi | Fungi | 103 | 4.48e-24 | NR | CAJ0844475.1 | 2562287 | g7317 | i0 | 58.2 | 7.34259259259259 | 79 | 33 | 73.1 | 0 | 4 | 240 | 208 | 286 | CAJ0844475.1 10764_t:CDS:2, partial [Entrophospora sp. SA101] | diamond | 2379 | 103 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Entrophosporales | Entrophosporaceae | Entrophospora | Entrophospora sp. SA101 | |
| 27615484 | 27615484 | PRJNA554794_P_NODE_21384_length_181_cov_0.553030_g17455_i0 | PRJNA554794 | 21384 | 181 | 0.55303 | 1.0009843 | Paraglomus occultum | 144539 | Fungi | Fungi | 43.9 | 0.0057 | NR | CAG8495575.1 | 144539 | g17455 | i0 | 45.6 | 1.87292817679558 | 57 | 31 | 94.5 | 0 | 10 | 180 | 6 | 62 | CAG8495575.1 10001_t:CDS:2 [Paraglomus occultum] | diamond | 339 | 43.9 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Paraglomerales | Paraglomeraceae | Paraglomus | Paraglomus occultum | |
| 28703523 | 28703523 | PRJNA554794_P_NODE_19907_length_203_cov_1.376623_g15978_i0 | PRJNA554794 | 19907 | 203 | 1.376623 | 2.79454469 | Mucoromycota | 1913637 | Fungi | Fungi | 106 | 1.09e-26 | NR | XP_069237088.1 | 4840 | g15978 | i0 | 77.6 | 10.8916256157635 | 67 | 15 | 99 | 0 | 202 | 2 | 42 | 108 | XP_069237088.1 60S ribosomal protein eL19 [Rhizomucor pusillus] | diamond | 2211 | 107 | 0.990654205607477 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Lichtheimiaceae | Rhizomucor | Rhizomucor pusillus | |
| 28720511 | 28720511 | PRJNA554794_P_NODE_20447_length_194_cov_0.862069_g16518_i0 | PRJNA554794 | 20447 | 194 | 0.862069 | 1.67241386 | Rhizopus arrhizus | 64495 | Fungi | Fungi | 56.6 | 2.46e-7 | NR | KAG1322365.1 | 64495 | g16518 | i0 | 40.6 | 6.61855670103093 | 64 | 38 | 99 | 0 | 3 | 194 | 517 | 580 | KAG1322365.1 hypothetical protein G6F62_010288 [Rhizopus arrhizus] | diamond | 1284 | 56.6 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus arrhizus | |
| 30773454 | 30773454 | PRJNA554794_P_NODE_22714_length_167_cov_0.788136_g18785_i0 | PRJNA554794 | 22714 | 167 | 0.788136 | 1.31618712 | Diversispora eburnea | 1213867 | Fungi | Fungi | 87.4 | 2.26e-20 | NR | CAG8458558.1 | 1213867 | g18785 | i0 | 72.7 | 3.95209580838323 | 55 | 15 | 98.8 | 0 | 165 | 1 | 45 | 99 | CAG8458558.1 1650_t:CDS:2 [Diversispora eburnea] | diamond | 660 | 87.4 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Diversisporales | Diversisporaceae | Diversispora | Diversispora eburnea | |
| 30819533 | 30819533 | PRJNA554794_P_NODE_23974_length_163_cov_0.885965_g20045_i0 | PRJNA554794 | 23974 | 163 | 0.885965 | 1.44412295 | Glomeromycetes | 214506 | Fungi | Fungi | 57.8 | 6.27e-8 | NR | CAG8771437.1 | 4874 | g20045 | i0 | 59.5 | 8.7239263803681 | 42 | 17 | 77.3 | 0 | 4 | 129 | 310 | 351 | CAG8771437.1 43936_t:CDS:2 [Gigaspora margarita] | diamond | 1422 | 57.8 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Diversisporales | Gigasporaceae | Gigaspora | Gigaspora margarita | |
| 31166757 | 31166757 | PRJNA554794_P_NODE_23155_length_165_cov_0.879310_g19226_i0 | PRJNA554794 | 23155 | 165 | 0.87931 | 1.4508615 | Opisthokonta | 33154 | Fungi | Fungi | 98.2 | 1.5899999999999999e-24 | NR | RCH88300.1 | 4846 | g19226 | i0 | 74.5 | 5.98181818181818 | 55 | 14 | 100 | 0 | 1 | 165 | 79 | 133 | RCH88300.1 Guanine nucleotide-binding protein subunit beta-2-like 1, partial [Rhizopus stolonifer] | diamond | 987 | 99 | 0.991919191919192 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus stolonifer | |
| 31468898 | 31468898 | PRJNA554794_P_NODE_12216_length_282_cov_0.866953_g8287_i0 | PRJNA554794 | 12216 | 282 | 0.866953 | 2.44480746 | Actinomortierella ambigua | 1343610 | Fungi | Fungi | 75.9 | 3.45e-14 | NR | KAF9974692.1 | 1343610 | g8287 | i0 | 56.7 | 4.37234042553191 | 90 | 34 | 95.7 | 1 | 272 | 3 | 6 | 90 | KAF9974692.1 60S ribosomal protein L7 [Actinomortierella ambigua] | diamond | 1233 | 75.9 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Actinomortierella | Actinomortierella ambigua | |
| 31690042 | 31690042 | PRJNA554794_P_NODE_20517_length_193_cov_0.611111_g16588_i0 | PRJNA554794 | 20517 | 193 | 0.611111 | 1.17944423 | Gigaspora margarita | 4874 | Fungi | Fungi | 67 | 1.98e-11 | NR | CAG8654347.1 | 4874 | g16588 | i0 | 53.4 | 0.901554404145078 | 58 | 26 | 90.2 | 1 | 183 | 10 | 178 | 234 | CAG8654347.1 36623_t:CDS:2 [Gigaspora margarita] | diamond | 174 | 67 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Diversisporales | Gigasporaceae | Gigaspora | Gigaspora margarita | |
| 31799426 | 31799426 | PRJNA554794_P_NODE_14917_length_214_cov_0.866667_g10988_i0 | PRJNA554794 | 14917 | 214 | 0.866667 | 1.85466738 | Mortierella | 4855 | Fungi | Fungi | 74.7 | 3.82e-15 | NR | KAG0252756.1 | 41804 | g10988 | i0 | 63.5 | 5.88785046728972 | 52 | 19 | 72.9 | 0 | 165 | 10 | 1 | 52 | KAG0252756.1 hypothetical protein BG011_006815 [Mortierella polycephala] | diamond | 1260 | 74.7 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Mortierella | Mortierella polycephala | |
| 31848203 | 31848203 | PRJNA554794_P_NODE_10917_length_340_cov_65.835052_g6996_i0 | PRJNA554794 | 10917 | 340 | 65.835052 | 223.8391768 | Gigaspora rosea | 44941 | Fungi | Fungi | 64.7 | 8.8e-11 | NR | RIA99826.1 | 44941 | g6996 | i0 | 51.3 | 4.16470588235294 | 76 | 25 | 65.3 | 2 | 2 | 223 | 2 | 67 | RIA99826.1 hypothetical protein C2G38_1995017 [Gigaspora rosea] | diamond | 1416 | 64.7 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Diversisporales | Gigasporaceae | Gigaspora | Gigaspora rosea | |
| 32559209 | 32559209 | PRJNA554794_P_NODE_23019_length_166_cov_0.692308_g19090_i0 | PRJNA554794 | 23019 | 166 | 0.692308 | 1.14923128 | Gigasporaceae | 36753 | Fungi | Fungi | 74.3 | 1.05e-14 | NR | CAG8530723.1 | 60492 | g19090 | i0 | 73.5 | 2.69277108433735 | 49 | 13 | 88.6 | 0 | 162 | 16 | 31 | 79 | CAG8530723.1 1442_t:CDS:2 [Racocetra fulgida] | diamond | 447 | 74.7 | 0.994645247657296 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Diversisporales | Gigasporaceae | Racocetra | Racocetra fulgida |
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);;