contig_metadata
22 rows where bioproject = "PRJNA760904", tax_clade = "PVC group" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2018264 | 2018264 | PRJNA760904_P_NODE_21202_length_231_cov_2.417722_g21145_i0 | PRJNA760904 | 21202 | 231 | 2.417722 | 5.58493782 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 339 | 1.41e-88 | NTclustered | gi|2874253768|emb|OY969715.1| | 412056 | g21145 | i0 | 93.074 | 79.0735930735931 | 231 | 16 | 100 | 0 | 1 | 231 | 915849 | 915619 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD01916.bin.1.1 genome assembly, chromosome: 1 | blastn | 18266 | 339 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 2018275 | 2018275 | PRJNA760904_P_NODE_3562_length_438_cov_1.191781_g3505_i0 | PRJNA760904 | 3562 | 438 | 1.191781 | 5.22000078 | Opitutia bacterium | 2026771 | Bacteria | Bacteria | 196 | 3.05e-58 | NR | NDH16516.1 | 2026771 | g3505 | i0 | 59 | 7.91095890410959 | 144 | 59 | 98.6 | 0 | 1 | 432 | 43 | 186 | NDH16516.1 phosphoenolpyruvate carboxykinase (GTP) [Opitutia bacterium] | diamond | 3465 | 196 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutia bacterium | ||||
| 14771136 | 14771136 | PRJNA760904_P_NODE_17672_length_246_cov_0.890173_g17615_i0 | PRJNA760904 | 17672 | 246 | 0.890173 | 2.18982558 | Verrucomicrobiaceae | 203557 | Bacteria | Bacteria | 120 | 2.21e-30 | NR | GAA5476635.1 | 490095 | g17615 | i0 | 69.1 | 21.7439024390244 | 81 | 25 | 98.8 | 0 | 1 | 243 | 48 | 128 | GAA5476635.1 UDP-glucose 4-epimerase [Haloferula helveola] | diamond | 5349 | 121 | 0.991735537190083 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Haloferula | Haloferula helveola | |
| 14771198 | 14771198 | PRJNA760904_P_NODE_8672_length_304_cov_2.385281_g8615_i0 | PRJNA760904 | 8672 | 304 | 2.385281 | 7.25125424 | Akkermansiaceae bacterium | 2562705 | Bacteria | Bacteria | 75 | 6.05e-9 | NTclustered | gi|2022020957|gb|CP059069.1| | 2562705 | g8615 | i0 | 86.957 | 9.53618421052632 | 69 | 6 | 23 | 2 | 159 | 227 | 3177127 | 3177062 | Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome | blastn | 2899 | 75 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansiaceae bacterium | ||
| 16044892 | 16044892 | PRJNA760904_P_NODE_16833_length_247_cov_1.764368_g16776_i0 | PRJNA760904 | 16833 | 247 | 1.764368 | 4.35798896 | Opitutaceae bacterium | 2006848 | Bacteria | Bacteria | 87.4 | 4.64e-19 | NR | MEO5958915.1 | 2006848 | g16776 | i0 | 71.2 | 1.48178137651822 | 59 | 17 | 71.7 | 0 | 66 | 242 | 9 | 67 | MEO5958915.1 class I fructose-bisphosphate aldolase [Opitutaceae bacterium] | diamond | 366 | 87.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium | ||
| 16044949 | 16044949 | PRJNA760904_P_NODE_9633_length_290_cov_1.502304_g9576_i0 | PRJNA760904 | 9633 | 290 | 1.502304 | 4.3566816 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 143 | 2.66e-39 | NR | RYD65414.1 | 2026800 | g9576 | i0 | 77.1 | 0.993103448275862 | 96 | 20 | 99.3 | 1 | 289 | 2 | 93 | 186 | RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium] | diamond | 288 | 143 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 24968863 | 24968863 | PRJNA760904_P_NODE_3620_length_435_cov_1.596685_g3563_i0 | PRJNA760904 | 3620 | 435 | 1.596685 | 6.94557975 | Verrucomicrobia bacterium SCGC AG-212-E | 1799654 | Bacteria | Bacteria | 231 | 4.64e-71 | NR | OAI42991.1 | 1799654 | g3563 | i0 | 74.3 | 15.6206896551724 | 144 | 37 | 99.3 | 0 | 434 | 3 | 222 | 365 | OAI42991.1 malate synthase A, partial [Verrucomicrobia bacterium SCGC AG-212-E04] | diamond | 6795 | 231 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobia bacterium SCGC AG-212-E04 | |||||
| 27084769 | 27084769 | PRJNA760904_P_NODE_3682_length_432_cov_1.635097_g3625_i0 | PRJNA760904 | 3682 | 432 | 1.635097 | 7.06361904 | Opitutaceae bacterium EW11 | 2161865 | Bacteria | Bacteria | 61.6 | 7.64e-8 | NR | PTY08534.1 | 2161865 | g3625 | i0 | 34 | 0.673611111111111 | 97 | 64 | 67.4 | 0 | 321 | 31 | 193 | 289 | PTY08534.1 hypothetical protein DB347_02845 [Opitutaceae bacterium EW11] | diamond | 291 | 61.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium EW11 | ||
| 27116121 | 27116121 | PRJNA760904_P_NODE_6822_length_336_cov_1.171103_g6765_i0 | PRJNA760904 | 6822 | 336 | 1.171103 | 3.93490608 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 48.9 | 7.56e-4 | NR | MBI2927208.1 | 2026799 | g6765 | i0 | 38.6 | 0.508928571428571 | 57 | 35 | 50.9 | 0 | 29 | 199 | 471 | 527 | MBI2927208.1 SUMF1/EgtB/PvdO family nonheme iron enzyme [Verrucomicrobiota bacterium] | diamond | 171 | 48.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 27884042 | 27884042 | PRJNA760904_P_NODE_14325_length_253_cov_1.438889_g14268_i0 | PRJNA760904 | 14325 | 253 | 1.438889 | 3.64038917 | Bacteria | 2 | Bacteria | Bacteria | 132 | 1.08e-35 | NR | MFL6538419.1 | 2201154 | g14268 | i0 | 71.4 | 22.9090909090909 | 84 | 24 | 99.6 | 0 | 252 | 1 | 188 | 271 | MFL6538419.1 SDR family oxidoreductase [Chthoniobacterales bacterium] | diamond | 5796 | 133 | 0.992481203007519 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacterales bacterium | |||
| 27915518 | 27915518 | PRJNA760904_P_NODE_2565_length_506_cov_1.581986_g2508_i0 | PRJNA760904 | 2565 | 506 | 1.581986 | 8.00484916 | Nibricoccus | 2576890 | Bacteria | Bacteria | 148 | 2.82e-38 | NR | PTY02515.1 | 2161865 | g2508 | i0 | 45.9 | 4.04940711462451 | 170 | 88 | 99 | 2 | 5 | 505 | 448 | 616 | PTY02515.1 hypothetical protein DB347_24250 [Opitutaceae bacterium EW11] | diamond | 2049 | 148 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium EW11 | ||
| 27978766 | 27978766 | PRJNA760904_P_NODE_1365_length_663_cov_3.054237_g1311_i0 | PRJNA760904 | 1365 | 663 | 3.054237 | 20.24959131 | Verrucomicrobiota | 74201 | Bacteria | Bacteria | 291 | 6.509999999999998e-94 | NR | MDE1171617.1 | 72225 | g1311 | i0 | 75.9 | 16.3619909502262 | 187 | 45 | 84.6 | 0 | 1 | 561 | 254 | 440 | MDE1171617.1 aminotransferase class III-fold pyridoxal phosphate-dependent enzyme [Verrucomicrobium sp.] | diamond | 10848 | 292 | 0.996575342465753 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobium | Verrucomicrobium sp. | |
| 28127086 | 28127086 | PRJNA760904_P_NODE_18925_length_244_cov_0.900585_g18868_i0 | PRJNA760904 | 18925 | 244 | 0.900585 | 2.1974274 | Verrucomicrobium sp. BvORR | 72225 | Bacteria | Bacteria | 54.3 | 3.29e-6 | NR | WP_050030939.1 | 1396418 | g18868 | i0 | 38.7 | 2.49590163934426 | 75 | 45 | 92.2 | 1 | 228 | 4 | 1171 | 1244 | WP_050030939.1 S8 family serine peptidase [Verrucomicrobium sp. BvORR034] | diamond | 609 | 54.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobium | Verrucomicrobium sp. BvORR034 | |
| 28758397 | 28758397 | PRJNA760904_P_NODE_13127_length_262_cov_2.021164_g13070_i0 | PRJNA760904 | 13127 | 262 | 2.021164 | 5.29544968 | Chthoniobacter sp. | 2510640 | Bacteria | Bacteria | 85.1 | 4.96e-17 | NR | MDR3405335.1 | 2510640 | g13070 | i0 | 81.6 | 0.561068702290076 | 49 | 9 | 56.1 | 0 | 3 | 149 | 416 | 464 | MDR3405335.1 translation elongation factor EF1A family protein [Chthoniobacter sp.] | diamond | 147 | 85.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacter | Chthoniobacter sp. | |
| 29295215 | 29295215 | PRJNA760904_P_NODE_749_length_863_cov_2.679747_g703_i0 | PRJNA760904 | 749 | 863 | 2.679747 | 23.12621661 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 54.7 | 3.1e-4 | NR | HXI69412.1 | 2499141 | g703 | i0 | 28.3 | 0.896871378910776 | 258 | 142 | 82.7 | 12 | 779 | 66 | 198 | 432 | HXI69412.1 immunoglobulin domain-containing protein [Verrucomicrobiia bacterium] | diamond | 774 | 54.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 29705264 | 29705264 | PRJNA760904_P_NODE_9350_length_293_cov_8.631818_g9293_i0 | PRJNA760904 | 9350 | 293 | 8.631818 | 25.29122674 | Candidatus Didemnitutus sp. | 2814259 | Bacteria | Bacteria | 53.5 | 1.13e-5 | NR | HVU15720.1 | 2814259 | g9293 | i0 | 42.6 | 0.921501706484642 | 54 | 31 | 55.3 | 0 | 184 | 23 | 646 | 699 | HVU15720.1 toxin TcdB middle/N-terminal domain-containing protein [Candidatus Didemnitutus sp.] | diamond | 270 | 53.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Candidatus Didemnitutus | Candidatus Didemnitutus sp. | |
| 29958288 | 29958288 | PRJNA760904_P_NODE_10651_length_282_cov_1.320574_g10594_i0 | PRJNA760904 | 10651 | 282 | 1.320574 | 3.72401868 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 44.3 | 0.0166 | NR | MCX6917058.1 | 2026799 | g10594 | i0 | 42.9 | 0.595744680851064 | 56 | 29 | 59.6 | 1 | 18 | 185 | 253 | 305 | MCX6917058.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 168 | 44.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 30052992 | 30052992 | PRJNA760904_P_NODE_5571_length_364_cov_2.539519_g5514_i0 | PRJNA760904 | 5571 | 364 | 2.539519 | 9.24384916 | Chthoniobacter sp. | 2510640 | Bacteria | Bacteria | 227 | 3.95e-70 | NR | MDR3405335.1 | 2510640 | g5514 | i0 | 88.4 | 0.997252747252747 | 121 | 14 | 99.7 | 0 | 1 | 363 | 289 | 409 | MDR3405335.1 translation elongation factor EF1A family protein [Chthoniobacter sp.] | diamond | 363 | 227 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacter | Chthoniobacter sp. | |
| 30210887 | 30210887 | PRJNA760904_P_NODE_3572_length_437_cov_1.494505_g3515_i0 | PRJNA760904 | 3572 | 437 | 1.494505 | 6.53098685 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 99 | 1.06e-21 | NR | MEM7385718.1 | 2026799 | g3515 | i0 | 53.5 | 0.693363844393593 | 101 | 42 | 65.9 | 1 | 1 | 288 | 182 | 282 | MEM7385718.1 SPFH domain-containing protein [Verrucomicrobiota bacterium] | diamond | 303 | 99 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 30621693 | 30621693 | PRJNA760904_P_NODE_19813_length_242_cov_1.366864_g19756_i0 | PRJNA760904 | 19813 | 242 | 1.366864 | 3.30781088 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 101 | 3.259999999999999e-23 | NR | MBM3869727.1 | 2026799 | g19756 | i0 | 57 | 1.95867768595041 | 79 | 34 | 97.9 | 0 | 242 | 6 | 97 | 175 | MBM3869727.1 NADP transhydrogenase subunit alpha [Verrucomicrobiota bacterium] | diamond | 474 | 101 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 31886327 | 31886327 | PRJNA760904_P_NODE_13957_length_256_cov_1.262295_g13900_i0 | PRJNA760904 | 13957 | 256 | 1.262295 | 3.2314752 | Lacunisphaera sp. | 1961806 | Bacteria | Bacteria | 77.8 | 7.59e-15 | NR | MDB6165412.1 | 1961806 | g13900 | i0 | 57.6 | 1.48828125 | 66 | 27 | 77.3 | 1 | 57 | 254 | 17 | 81 | MDB6165412.1 N-hydroxyarylamine O-acetyltransferase [Lacunisphaera sp.] | diamond | 381 | 77.8 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Lacunisphaera | Lacunisphaera sp. | |
| 32392641 | 32392641 | PRJNA760904_P_NODE_19779_length_242_cov_1.662722_g19722_i0 | PRJNA760904 | 19779 | 242 | 1.662722 | 4.02378724 | Limisphaerales bacterium | 2052186 | Bacteria | Bacteria | 61.2 | 1.08e-8 | NR | KAF0179106.1 | 2052186 | g19722 | i0 | 48.5 | 4.72314049586777 | 68 | 34 | 83.1 | 1 | 1 | 201 | 108 | 175 | KAF0179106.1 MAG: hypothetical protein FD161_1599 [Limisphaerales bacterium] | diamond | 1143 | 61.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Limisphaerales | Limisphaerales 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);;