contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA642647" and tax_phylum = "Verrucomicrobiota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27713476 | 27713476 | PRJNA642647_P_NODE_5644_length_160_cov_1.886179_g5594_i0 | PRJNA642647 | 5644 | 160 | 1.886179 | 3.0178864 | Opitutaceae bacterium | 2006848 | Bacteria | Bacteria | 89.4 | 2.33e-20 | NR | MBW7896562.1 | 2006848 | g5594 | i0 | 78.8 | 0.975 | 52 | 11 | 97.5 | 0 | 3 | 158 | 81 | 132 | MBW7896562.1 hypothetical protein [Opitutaceae bacterium] | diamond | 156 | 89.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium | ||
| 28028934 | 28028934 | PRJNA642647_P_NODE_6265_length_153_cov_0.905172_g6215_i0 | PRJNA642647 | 6265 | 153 | 0.905172 | 1.38491316 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 74.3 | 7.15e-14 | NR | HOX60287.1 | 2026799 | g6215 | i0 | 71.4 | 0.96078431372549 | 49 | 14 | 96.1 | 0 | 151 | 5 | 200 | 248 | HOX60287.1 helicase-related protein [Verrucomicrobiota bacterium] | diamond | 147 | 74.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 28565552 | 28565552 | PRJNA642647_P_NODE_2467_length_220_cov_1.519126_g2417_i0 | PRJNA642647 | 2467 | 220 | 1.519126 | 3.3420772 | Luteolibacter sp. | 1962973 | Bacteria | Bacteria | 114 | 8.729999999999999e-28 | NR | MFT3991681.1 | 1962973 | g2417 | i0 | 72.2 | 0.981818181818182 | 72 | 20 | 98.2 | 0 | 216 | 1 | 105 | 176 | MFT3991681.1 hypothetical protein [Luteolibacter sp.] | diamond | 216 | 114 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. | |
| 28723490 | 28723490 | PRJNA642647_P_NODE_6727_length_150_cov_1.318584_g6677_i0 | PRJNA642647 | 6727 | 150 | 1.318584 | 1.977876 | Verrucomicrobiales bacterium | 2026801 | Bacteria | Bacteria | 86.3 | 2.57e-18 | NR | MBL9172927.1 | 2026801 | g6677 | i0 | 81.6 | 0.98 | 49 | 9 | 98 | 0 | 148 | 2 | 134 | 182 | MBL9172927.1 immunoglobulin domain-containing protein [Verrucomicrobiales bacterium] | diamond | 147 | 86.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales bacterium | |||
| 28912623 | 28912623 | PRJNA642647_P_NODE_4028_length_180_cov_0.804196_g3978_i0 | PRJNA642647 | 4028 | 180 | 0.804196 | 1.4475528 | Verrucomicrobiales bacterium | 2026801 | Bacteria | Bacteria | 55.1 | 7.03e-7 | NR | MFN0130813.1 | 2026801 | g3978 | i0 | 44.1 | 0.983333333333333 | 59 | 31 | 98.3 | 1 | 179 | 3 | 654 | 710 | MFN0130813.1 hypothetical protein [Verrucomicrobiales bacterium] | diamond | 177 | 55.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales bacterium | |||
| 28912627 | 28912627 | PRJNA642647_P_NODE_5048_length_166_cov_2.922481_g4998_i0 | PRJNA642647 | 5048 | 166 | 2.922481 | 4.85131846 | Akkermansiaceae bacterium | 2562705 | Bacteria | Bacteria | 42.7 | 0.0134 | NR | MCF7674599.1 | 2562705 | g4998 | i0 | 82.6 | 1.24698795180723 | 23 | 4 | 41.6 | 0 | 165 | 97 | 88 | 110 | MCF7674599.1 hypothetical protein [Akkermansiaceae bacterium] | diamond | 207 | 42.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansiaceae bacterium | ||
| 29134079 | 29134079 | PRJNA642647_P_NODE_4469_length_172_cov_0.948148_g4419_i0 | PRJNA642647 | 4469 | 172 | 0.948148 | 1.63081456 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 101 | 1.96e-24 | NR | MDQ5980720.1 | 2026799 | g4419 | i0 | 96.3 | 0.941860465116279 | 54 | 2 | 94.2 | 0 | 6 | 167 | 84 | 137 | MDQ5980720.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 162 | 101 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29638741 | 29638741 | PRJNA642647_P_NODE_4910_length_166_cov_3.348837_g4860_i0 | PRJNA642647 | 4910 | 166 | 3.348837 | 5.55906942 | Opitutus sp. | 1913982 | Bacteria | Bacteria | 51.2 | 1.36e-5 | NR | MSU50147.1 | 1913982 | g4860 | i0 | 35.3 | 1.8433734939759 | 102 | 18 | 97.6 | 2 | 4 | 165 | 588 | 689 | MSU50147.1 hypothetical protein [Opitutus sp.] | diamond | 306 | 51.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutus | Opitutus sp. | |
| 29701866 | 29701866 | PRJNA642647_P_NODE_4710_length_168_cov_2.328244_g4660_i0 | PRJNA642647 | 4710 | 168 | 2.328244 | 3.91144992 | Haloferula sp. | 2497595 | Bacteria | Bacteria | 106 | 4.3e-26 | NR | HEY1122245.1 | 2497595 | g4660 | i0 | 83.3 | 1.92857142857143 | 54 | 9 | 96.4 | 0 | 164 | 3 | 119 | 172 | HEY1122245.1 hypothetical protein [Haloferula sp.] | diamond | 324 | 106 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Haloferula | Haloferula sp. | |
| 29796842 | 29796842 | PRJNA642647_P_NODE_6491_length_151_cov_3.096491_g6441_i0 | PRJNA642647 | 6491 | 151 | 3.096491 | 4.67570141 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 51.2 | 1.09e-5 | NR | MBK7997852.1 | 2026799 | g6441 | i0 | 59.5 | 2.32450331125828 | 37 | 8 | 59.6 | 1 | 150 | 61 | 545 | 581 | MBK7997852.1 transglutaminase domain-containing protein [Verrucomicrobiota bacterium] | diamond | 351 | 51.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 30175935 | 30175935 | PRJNA642647_P_NODE_5192_length_166_cov_2.573643_g5142_i0 | PRJNA642647 | 5192 | 166 | 2.573643 | 4.27224738 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 68.9 | 9.22e-13 | NR | HXI72320.1 | 2499141 | g5142 | i0 | 50.8 | 2.15060240963855 | 59 | 23 | 95.8 | 1 | 4 | 162 | 93 | 151 | HXI72320.1 pentapeptide repeat-containing protein [Verrucomicrobiia bacterium] | diamond | 357 | 68.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 30883386 | 30883386 | PRJNA642647_P_NODE_6394_length_151_cov_3.921053_g6344_i0 | PRJNA642647 | 6394 | 151 | 3.921053 | 5.92079003 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 45.1 | 0.00163 | NR | RPJ30090.1 | 2026800 | g6344 | i0 | 72.4 | 3.63576158940397 | 29 | 7 | 55.6 | 1 | 1 | 84 | 138 | 166 | RPJ30090.1 MAG: AAA family ATPase [Verrucomicrobiaceae bacterium] | diamond | 549 | 45.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 30902803 | 30902803 | PRJNA642647_P_NODE_5594_length_161_cov_1.217742_g5544_i0 | PRJNA642647 | 5594 | 161 | 1.217742 | 1.96056462 | Verrucomicrobia bacterium ADurb.Bin122 | 1852929 | Bacteria | Bacteria | 84 | 3.21e-17 | NR | OQB94327.1 | 1852929 | g5544 | i0 | 77.6 | 0.91304347826087 | 49 | 11 | 91.3 | 0 | 158 | 12 | 167 | 215 | OQB94327.1 MAG: Replicative DNA helicase [Verrucomicrobia bacterium ADurb.Bin122] | diamond | 147 | 84 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobia bacterium ADurb.Bin122 | |||||
| 30966115 | 30966115 | PRJNA642647_P_NODE_2774_length_209_cov_0.877907_g2724_i0 | PRJNA642647 | 2774 | 209 | 0.877907 | 1.83482563 | Candidatus Synoicihabitans sp. | 3069606 | Bacteria | Bacteria | 45.8 | 0.0019 | NR | HEX2101322.1 | 3069606 | g2724 | i0 | 44.1 | 0.84688995215311 | 59 | 33 | 84.7 | 0 | 198 | 22 | 171 | 229 | HEX2101322.1 hypothetical protein [Candidatus Synoicihabitans sp.] | diamond | 177 | 45.8 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Synoicihabitans | Candidatus Synoicihabitans sp. | |
| 31060982 | 31060982 | PRJNA642647_P_NODE_2815_length_207_cov_2.441176_g2765_i0 | PRJNA642647 | 2815 | 207 | 2.441176 | 5.05323432 | Luteolibacter pohnpeiensis | 454153 | Bacteria | Bacteria | 115 | 2.55e-28 | NR | WP_200274118.1 | 454153 | g2765 | i0 | 74.2 | 0.956521739130435 | 66 | 17 | 95.7 | 0 | 203 | 6 | 409 | 474 | WP_200274118.1 ParB N-terminal domain-containing protein [Luteolibacter pohnpeiensis] | diamond | 198 | 115 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter pohnpeiensis | |
| 31408569 | 31408569 | PRJNA642647_P_NODE_4016_length_180_cov_1.349650_g3966_i0 | PRJNA642647 | 4016 | 180 | 1.34965 | 2.42937 | Opitutaceae bacterium | 2006848 | Bacteria | Bacteria | 92.8 | 5.78e-22 | NR | MBC7365236.1 | 2006848 | g3966 | i0 | 76.3 | 0.983333333333333 | 59 | 14 | 98.3 | 0 | 2 | 178 | 101 | 159 | MBC7365236.1 hypothetical protein [Opitutaceae bacterium] | diamond | 177 | 92.8 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium | ||
| 31420764 | 31420764 | PRJNA642647_P_NODE_4876_length_166_cov_3.813953_g4826_i0 | PRJNA642647 | 4876 | 166 | 3.813953 | 6.33116198 | Bacteria | 2 | Bacteria | Bacteria | 55.8 | 2.84e-7 | NR | MBS0657466.1 | 2026799 | g4826 | i0 | 58.1 | 5.78313253012048 | 43 | 18 | 77.7 | 0 | 129 | 1 | 140 | 182 | MBS0657466.1 sterol desaturase family protein [Verrucomicrobiota bacterium] | diamond | 960 | 56.2 | 0.99288256227758 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 31819575 | 31819575 | PRJNA642647_P_NODE_5337_length_165_cov_0.890625_g5287_i0 | PRJNA642647 | 5337 | 165 | 0.890625 | 1.46953125 | Haloferula sp. | 2497595 | Bacteria | Bacteria | 49.7 | 1.24e-5 | NR | HEY1121745.1 | 2497595 | g5287 | i0 | 76.7 | 0.545454545454545 | 30 | 7 | 54.5 | 0 | 74 | 163 | 1 | 30 | HEY1121745.1 hypothetical protein [Haloferula sp.] | diamond | 90 | 49.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Haloferula | Haloferula sp. | |
| 32009544 | 32009544 | PRJNA642647_P_NODE_658_length_441_cov_3.455446_g609_i0 | PRJNA642647 | 658 | 441 | 3.455446 | 15.23851686 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 73.2 | 7.17e-12 | NR | HYG84585.1 | 2499141 | g609 | i0 | 39.7 | 0.789115646258503 | 116 | 67 | 78.2 | 2 | 437 | 93 | 295 | 408 | HYG84585.1 hypothetical protein [Verrucomicrobiia bacterium] | diamond | 348 | 73.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 32104392 | 32104392 | PRJNA642647_P_NODE_2238_length_229_cov_6.359375_g2188_i0 | PRJNA642647 | 2238 | 229 | 6.359375 | 14.56296875 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 44.3 | 0.00862 | NR | HYG84585.1 | 2499141 | g2188 | i0 | 31.7 | 1.83406113537118 | 82 | 41 | 89.1 | 2 | 206 | 3 | 199 | 279 | HYG84585.1 hypothetical protein [Verrucomicrobiia bacterium] | diamond | 420 | 44.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 32136165 | 32136165 | PRJNA642647_P_NODE_4898_length_166_cov_3.457364_g4848_i0 | PRJNA642647 | 4898 | 166 | 3.457364 | 5.73922424 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 54.7 | 7.97e-7 | NR | MEY3895831.1 | 2026799 | g4848 | i0 | 33.7 | 1.71686746987952 | 95 | 19 | 92.2 | 1 | 156 | 4 | 88 | 182 | MEY3895831.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 285 | 54.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 32231213 | 32231213 | PRJNA642647_P_NODE_2938_length_204_cov_2.449102_g2888_i0 | PRJNA642647 | 2938 | 204 | 2.449102 | 4.99616808 | Opitutia bacterium | 2026771 | Bacteria | Bacteria | 51.2 | 2.31e-5 | NR | MEL0098007.1 | 2026771 | g2888 | i0 | 57.9 | 0.558823529411765 | 38 | 10 | 55.9 | 1 | 91 | 204 | 191 | 222 | MEL0098007.1 hypothetical protein [Opitutia bacterium] | diamond | 114 | 51.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutia bacterium | ||||
| 32893699 | 32893699 | PRJNA642647_P_NODE_5580_length_161_cov_1.580645_g5530_i0 | PRJNA642647 | 5580 | 161 | 1.580645 | 2.54483845 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 113 | 1.59e-27 | NR | MEY3894838.1 | 2026799 | g5530 | i0 | 96 | 0.93167701863354 | 50 | 2 | 93.2 | 0 | 157 | 8 | 183 | 232 | MEY3894838.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 150 | 113 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium |
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);;