contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA785164" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26768767 | 26768767 | PRJNA785164_P_NODE_36681_length_298_cov_1.884444_g36216_i0 | PRJNA785164 | 36681 | 298 | 1.884444 | 5.61564312 | Prosthecobacter sp. | 1965333 | Bacteria | Bacteria | 169 | 2.459999999999999e-47 | NR | WP_395734110.1 | 1965333 | g36216 | i0 | 84.5 | 1.90268456375839 | 97 | 15 | 97.7 | 0 | 2 | 292 | 351 | 447 | WP_395734110.1 hypothetical protein [Prosthecobacter sp.] | diamond | 567 | 169 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter sp. | |
| 27022081 | 27022081 | PRJNA785164_P_NODE_54002_length_248_cov_1.440000_g53537_i0 | PRJNA785164 | 54002 | 248 | 1.44 | 3.5712 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 110 | 5.4e-26 | NR | HYE22720.1 | 2499141 | g53537 | i0 | 59.3 | 0.979838709677419 | 81 | 32 | 98 | 1 | 5 | 247 | 463 | 542 | HYE22720.1 hypothetical protein [Verrucomicrobiia bacterium] | diamond | 243 | 110 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 27148038 | 27148038 | PRJNA785164_P_NODE_52022_length_250_cov_1.305085_g51557_i0 | PRJNA785164 | 52022 | 250 | 1.305085 | 3.2627125 | Verrucomicrobiales bacterium | 2026801 | Bacteria | Bacteria | 77.4 | 2.45e-14 | NR | HCN76481.1 | 2026801 | g51557 | i0 | 54.2 | 1.98 | 83 | 37 | 98.4 | 1 | 3 | 248 | 157 | 239 | HCN76481.1 hypothetical protein [Verrucomicrobiales bacterium] | diamond | 495 | 77.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales bacterium | |||
| 27379245 | 27379245 | PRJNA785164_P_NODE_45763_length_266_cov_1.326425_g45298_i0 | PRJNA785164 | 45763 | 266 | 1.326425 | 3.5282905 | Bacteria | 2 | Bacteria | Bacteria | 95.9 | 1.02e-20 | NR | MBN9691296.1 | 2026799 | g45298 | i0 | 51.2 | 1.90601503759399 | 82 | 40 | 92.5 | 0 | 263 | 18 | 614 | 695 | MBN9691296.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 507 | 95.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 27969615 | 27969615 | PRJNA785164_P_NODE_41485_length_280_cov_1.193237_g41020_i0 | PRJNA785164 | 41485 | 280 | 1.193237 | 3.3410636 | Luteolibacter yonseiensis | 1144680 | Bacteria | Bacteria | 131 | 9.2e-34 | NR | WP_200351467.1 | 1144680 | g41020 | i0 | 68.9 | 1.93928571428571 | 90 | 28 | 96.4 | 0 | 8 | 277 | 82 | 171 | WP_200351467.1 hypothetical protein [Luteolibacter yonseiensis] | diamond | 543 | 131 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter yonseiensis | |
| 28474893 | 28474893 | PRJNA785164_P_NODE_25786_length_365_cov_1.054795_g25321_i0 | PRJNA785164 | 25786 | 365 | 1.054795 | 3.85000175 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 79.3 | 2.17e-14 | NR | MEI6198185.1 | 2026799 | g25321 | i0 | 46.5 | 1.70958904109589 | 99 | 52 | 81.4 | 1 | 356 | 60 | 285 | 382 | MEI6198185.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 624 | 79.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 28758937 | 28758937 | PRJNA785164_P_NODE_44447_length_270_cov_1.563452_g43982_i0 | PRJNA785164 | 44447 | 270 | 1.563452 | 4.2213204 | Opitutales bacterium | 2026772 | Bacteria | Bacteria | 75.1 | 1.33e-13 | NR | MCH8476057.1 | 2026772 | g43982 | i0 | 48.8 | 1.84444444444444 | 86 | 43 | 95.6 | 1 | 12 | 269 | 20 | 104 | MCH8476057.1 hypothetical protein [Opitutales bacterium] | diamond | 498 | 75.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutales bacterium | |||
| 29336632 | 29336632 | PRJNA785164_P_NODE_46349_length_264_cov_1.612565_g45884_i0 | PRJNA785164 | 46349 | 264 | 1.612565 | 4.2571716 | root | 1 | Root_unresolved | Root_unresolved | 103 | 1.9799999999999998e-23 | NR | MDB4350882.1 | 2026799 | g45884 | i0 | 59.3 | 1.95454545454545 | 86 | 35 | 97.7 | 0 | 262 | 5 | 249 | 334 | MDB4350882.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 516 | 103 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29358980 | 29358980 | PRJNA785164_P_NODE_25089_length_371_cov_1.758389_g24624_i0 | PRJNA785164 | 25089 | 371 | 1.758389 | 6.52362319 | Opitutaceae bacterium | 2006848 | Bacteria | Bacteria | 123 | 4.23e-30 | NR | MFA5056517.1 | 2006848 | g24624 | i0 | 52.6 | 0.93800539083558 | 116 | 55 | 93.8 | 0 | 370 | 23 | 232 | 347 | MFA5056517.1 anti-CBASS Acb1 family protein [Opitutaceae bacterium] | diamond | 348 | 123 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium | ||
| 30780338 | 30780338 | PRJNA785164_P_NODE_44454_length_270_cov_1.558376_g43989_i0 | PRJNA785164 | 44454 | 270 | 1.558376 | 4.2076152 | Verrucomicrobia bacterium RIFCSPHIGHO2_12_FULL_41_1 | 1802433 | Bacteria | Bacteria | 100 | 1.21e-22 | NR | OHE77780.1 | 1802433 | g43989 | i0 | 57.3 | 0.988888888888889 | 89 | 35 | 98.9 | 2 | 3 | 269 | 181 | 266 | OHE77780.1 MAG: hypothetical protein A3F67_08045 [Verrucomicrobia bacterium RIFCSPHIGHO2_12_FULL_41_10] | diamond | 267 | 100 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobia bacterium RIFCSPHIGHO2_12_FULL_41_10 | |||||
| 31444085 | 31444085 | PRJNA785164_P_NODE_57836_length_245_cov_0.895349_g57371_i0 | PRJNA785164 | 57836 | 245 | 0.895349 | 2.19360505 | Akkermansiaceae bacterium | 2562705 | Bacteria | Bacteria | 67.4 | 7.51e-11 | NR | MBX3740818.1 | 2562705 | g57371 | i0 | 65.4 | 0.991836734693878 | 81 | 28 | 99.2 | 0 | 245 | 3 | 46 | 126 | MBX3740818.1 2-oxo acid dehydrogenase subunit E2 [Akkermansiaceae bacterium] | diamond | 243 | 67.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansiaceae bacterium | ||
| 31475887 | 31475887 | PRJNA785164_P_NODE_50336_length_253_cov_1.238889_g49871_i0 | PRJNA785164 | 50336 | 253 | 1.238889 | 3.13438917 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 66.2 | 2.21e-10 | NR | HVU07847.1 | 2499141 | g49871 | i0 | 41 | 0.924901185770751 | 78 | 46 | 92.5 | 0 | 249 | 16 | 124 | 201 | HVU07847.1 phage portal protein [Verrucomicrobiia bacterium] | diamond | 234 | 66.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 31507578 | 31507578 | PRJNA785164_P_NODE_48236_length_259_cov_1.064516_g47771_i0 | PRJNA785164 | 48236 | 259 | 1.064516 | 2.75709644 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 60.1 | 1.1e-8 | NR | HZV34088.1 | 2499141 | g47771 | i0 | 48.5 | 0.787644787644788 | 68 | 35 | 78.8 | 0 | 56 | 259 | 112 | 179 | HZV34088.1 hypothetical protein [Verrucomicrobiia bacterium] | diamond | 204 | 60.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 31539154 | 31539154 | PRJNA785164_P_NODE_51076_length_251_cov_1.101124_g50611_i0 | PRJNA785164 | 51076 | 251 | 1.101124 | 2.76382124 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 78.2 | 9.87e-16 | NR | MBE7497145.1 | 2026800 | g50611 | i0 | 65 | 2.34262948207171 | 60 | 21 | 71.7 | 0 | 219 | 40 | 124 | 183 | MBE7497145.1 molybdenum cofactor guanylyltransferase [Verrucomicrobiaceae bacterium] | diamond | 588 | 78.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 31697165 | 31697165 | PRJNA785164_P_NODE_24077_length_381_cov_0.928571_g23612_i0 | PRJNA785164 | 24077 | 381 | 0.928571 | 3.53785551 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 53.5 | 1.09e-6 | NR | RPJ30610.1 | 2026800 | g23612 | i0 | 51 | 0.385826771653543 | 49 | 24 | 38.6 | 0 | 88 | 234 | 2 | 50 | RPJ30610.1 MAG: hypothetical protein EHM17_16370 [Verrucomicrobiaceae bacterium] | diamond | 147 | 53.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 31791838 | 31791838 | PRJNA785164_P_NODE_61377_length_241_cov_2.351190_g60912_i0 | PRJNA785164 | 61377 | 241 | 2.35119 | 5.6663679 | Opitutaceae bacterium | 2006848 | Bacteria | Bacteria | 64.3 | 8.51e-10 | NR | MFA5262197.1 | 2006848 | g60912 | i0 | 44.4 | 3.84647302904564 | 72 | 39 | 89.6 | 1 | 3 | 218 | 111 | 181 | MFA5262197.1 terminase family protein [Opitutaceae bacterium] | diamond | 927 | 64.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium | ||
| 31823539 | 31823539 | PRJNA785164_P_NODE_28917_length_341_cov_1.414179_g28452_i0 | PRJNA785164 | 28917 | 341 | 1.414179 | 4.82235039 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 60.5 | 6.85e-8 | NR | HXK07758.1 | 2499141 | g28452 | i0 | 36.5 | 3.01759530791789 | 115 | 69 | 99.4 | 3 | 2 | 340 | 455 | 567 | HXK07758.1 SBBP repeat-containing protein [Verrucomicrobiia bacterium] | diamond | 1029 | 60.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 32171919 | 32171919 | PRJNA785164_P_NODE_56458_length_246_cov_0.890173_g55993_i0 | PRJNA785164 | 56458 | 246 | 0.890173 | 2.18982558 | Opitutaceae bacterium | 2006848 | Bacteria | Bacteria | 99.8 | 1.19e-22 | NR | MCC6414779.1 | 2006848 | g55993 | i0 | 63.5 | 0.902439024390244 | 74 | 26 | 89 | 1 | 2 | 220 | 20 | 93 | MCC6414779.1 AAA family ATPase [Opitutaceae bacterium] | diamond | 222 | 99.8 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium | ||
| 32266862 | 32266862 | PRJNA785164_P_NODE_36098_length_301_cov_1.530702_g35633_i0 | PRJNA785164 | 36098 | 301 | 1.530702 | 4.60741302 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 61.6 | 1.34e-9 | NR | MFQ3577770.1 | 2499141 | g35633 | i0 | 45.3 | 0.637873754152824 | 64 | 34 | 62.8 | 1 | 31 | 219 | 28 | 91 | MFQ3577770.1 AAA family ATPase [Verrucomicrobiia bacterium] | diamond | 192 | 61.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 32361825 | 32361825 | PRJNA785164_P_NODE_52599_length_250_cov_0.870056_g52134_i0 | PRJNA785164 | 52599 | 250 | 0.870056 | 2.17514 | Opitutaceae bacterium | 2006848 | Bacteria | Bacteria | 90.9 | 4.27e-19 | NR | MFA5056517.1 | 2006848 | g52134 | i0 | 52.5 | 0.96 | 80 | 38 | 96 | 0 | 1 | 240 | 231 | 310 | MFA5056517.1 anti-CBASS Acb1 family protein [Opitutaceae bacterium] | diamond | 240 | 90.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium | ||
| 32866263 | 32866263 | PRJNA785164_P_NODE_34900_length_307_cov_1.316239_g34435_i0 | PRJNA785164 | 34900 | 307 | 1.316239 | 4.04085373 | Verrucomicrobium spinosum | 2736 | Bacteria | Bacteria | 85.1 | 4.78e-17 | NR | WP_082408217.1 | 2736 | g34435 | i0 | 57.1 | 1.36807817589577 | 70 | 27 | 65.5 | 2 | 217 | 17 | 22 | 91 | WP_082408217.1 replicative DNA helicase [Verrucomicrobium spinosum] | diamond | 420 | 85.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobium | Verrucomicrobium spinosum |
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);;