contig_metadata
26 rows where bioproject = "PRJNA879067", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2129718 | 2129718 | PRJNA879067_P_NODE_23242_length_911_cov_3.874702_g20159_i0 | PRJNA879067 | 23242 | 911 | 3.874702 | 35.29853522 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 379 | 5.45e-126 | NR | HEV8541407.1 | 2499141 | g20159 | i0 | 64.7 | 0.987925356750823 | 300 | 104 | 98.1 | 2 | 16 | 909 | 120 | 419 | HEV8541407.1 ATP-binding protein [Verrucomicrobiia bacterium] | diamond | 900 | 379 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 5959677 | 5959677 | PRJNA879067_P_NODE_91965_length_291_cov_1.412844_g88479_i0 | PRJNA879067 | 91965 | 291 | 1.412844 | 4.11137604 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 94.4 | 1.75e-20 | NR | PYJ06183.1 | 2026799 | g88479 | i0 | 58 | 3.69072164948454 | 100 | 39 | 100 | 1 | 1 | 291 | 102 | 201 | PYJ06183.1 MAG: hypothetical protein DME25_07070, partial [Verrucomicrobiota bacterium] | diamond | 1074 | 94.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 7616961 | 7616961 | PRJNA879067_P_NODE_36646_length_663_cov_14.730508_g33230_i0 | PRJNA879067 | 36646 | 663 | 14.730508 | 97.66326804 | Prosthecobacter sp. | 1965333 | Bacteria | Bacteria | 95.5 | 1.05e-21 | NR | WP_395732677.1 | 1965333 | g33230 | i0 | 97.9 | 0.217194570135747 | 48 | 1 | 21.7 | 0 | 26 | 169 | 36 | 83 | WP_395732677.1 helix-turn-helix domain-containing protein [Prosthecobacter sp.] | diamond | 144 | 95.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter sp. | |
| 9784097 | 9784097 | PRJNA879067_P_NODE_84988_length_318_cov_1.775510_g81502_i0 | PRJNA879067 | 84988 | 318 | 1.77551 | 5.6461218 | Luteolibacter sp. Populi | 3230487 | Bacteria | Bacteria | 359 | 1.57e-94 | NTclustered | gi|2774618348|gb|CP161812.1| | 3230487 | g81502 | i0 | 87.066 | 1.33018867924528 | 317 | 41 | 99 | 0 | 2 | 318 | 446523 | 446207 | Luteolibacter sp. Populi chromosome, complete genome | blastn | 423 | 359 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. Populi | |
| 9784277 | 9784277 | PRJNA879067_P_NODE_92128_length_290_cov_2.571429_g88642_i0 | PRJNA879067 | 92128 | 290 | 2.571429 | 7.4571441 | Actomonas aquatica | 2866162 | Bacteria | Bacteria | 52.8 | 0.027 | NTclustered | gi|2647674565|gb|CP139781.1| | 2866162 | g88642 | i0 | 100 | 0.096551724137931 | 28 | 0 | 10 | 0 | 262 | 289 | 1509966 | 1509993 | Actomonas aquatica strain WL0086 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Actomonas | Actomonas aquatica | |
| 11059167 | 11059167 | PRJNA879067_P_NODE_57109_length_469_cov_9.007576_g53624_i0 | PRJNA879067 | 57109 | 469 | 9.007576 | 42.24553144 | Opitutales bacterium | 2026772 | Bacteria | Bacteria | 132 | 1.81e-33 | NR | HNX05049.1 | 2026772 | g53624 | i0 | 63.4 | 1.7910447761194 | 93 | 34 | 59.5 | 0 | 143 | 421 | 7 | 99 | HNX05049.1 aminotransferase class III-fold pyridoxal phosphate-dependent enzyme [Opitutales bacterium] | diamond | 840 | 132 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutales bacterium | |||
| 18705379 | 18705379 | PRJNA879067_P_NODE_11695_length_1427_cov_5.536189_g9402_i0 | PRJNA879067 | 11695 | 1427 | 5.536189 | 79.00141703 | Limisphaerales bacterium | 2052186 | Bacteria | Bacteria | 69.3 | 6.22e-10 | NR | MFN7141538.1 | 2052186 | g9402 | i0 | 48.9 | 0.279607568325158 | 133 | 57 | 26.9 | 5 | 1272 | 889 | 25 | 151 | MFN7141538.1 hypothetical protein [Limisphaerales bacterium] | diamond | 399 | 69.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Limisphaerales | Limisphaerales bacterium | |||
| 19090406 | 19090406 | PRJNA879067_P_NODE_29155_length_779_cov_16.766289_g25870_i0 | PRJNA879067 | 29155 | 779 | 16.766289 | 130.60939131 | root | 1 | Root_unresolved | Root_unresolved | 54.7 | 0.022 | NTclustered | gi|226525317|gb|FJ872374.1| | 156588 | g25870 | i0 | 100 | 0.0744544287548139 | 29 | 0 | 4 | 0 | 347 | 375 | 1792 | 1764 | Uncultured Verrucomicrobia bacterium clone 184 genomic sequence | blastn | 58 | 54.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | uncultured Verrucomicrobiota bacterium | |||||
| 19981675 | 19981675 | PRJNA879067_P_NODE_40476_length_618_cov_2.467890_g37028_i0 | PRJNA879067 | 40476 | 618 | 2.46789 | 15.2515602 | Termitidicoccus mucosus | 1184151 | Bacteria | Bacteria | 248 | 7.28e-61 | NTclustered | gi|2724066732|gb|CP109796.1| | 1184151 | g37028 | i0 | 85.714 | 5.05663430420712 | 238 | 31 | 38 | 3 | 356 | 591 | 4295974 | 4295738 | Termitidicoccus mucosus strain TSB47 chromosome, complete genome | blastn | 3125 | 248 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Termitidicoccus | Termitidicoccus mucosus | |
| 21256338 | 21256338 | PRJNA879067_P_NODE_19997_length_1009_cov_33.317308_g17076_i0 | PRJNA879067 | 19997 | 1009 | 33.317308 | 336.17163772 | Prosthecobacter sp. | 1965333 | Bacteria | Bacteria | 599 | 1.3399999999999995e-209 | NR | MDB6005009.1 | 1965333 | g17076 | i0 | 92.1 | 3.74925668979187 | 315 | 25 | 93.7 | 0 | 32 | 976 | 369 | 683 | MDB6005009.1 glycine dehydrogenase [Prosthecobacter sp.] | diamond | 3783 | 599 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter sp. | |
| 22533091 | 22533091 | PRJNA879067_P_NODE_89578_length_300_cov_1.696035_g86092_i0 | PRJNA879067 | 89578 | 300 | 1.696035 | 5.088105 | Verrucomicrobium spinosum | 2736 | Bacteria | Bacteria | 392 | 1.4499999999999994e-104 | NTclustered | gi|12583973|gb|AF245377.1| | 240016 | g86092 | i0 | 90.604 | 141.846666666667 | 298 | 25 | 99 | 2 | 5 | 300 | 268 | 564 | Verrucomicrobium spinosum 23S ribosomal RNA gene, partial sequence | blastn | 42554 | 392 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobium | Verrucomicrobium spinosum | |
| 26643594 | 26643594 | PRJNA879067_P_NODE_109461_length_243_cov_0.905882_g105975_i0 | PRJNA879067 | 109461 | 243 | 0.905882 | 2.20129326 | Opitutales bacterium | 2026772 | Bacteria | Bacteria | 126 | 1.06e-35 | NR | HQU09324.1 | 2026772 | g105975 | i0 | 72.7 | 1.90123456790123 | 77 | 21 | 95.1 | 0 | 12 | 242 | 11 | 87 | HQU09324.1 hypothetical protein [Opitutales bacterium] | diamond | 462 | 126 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutales bacterium | |||
| 26738301 | 26738301 | PRJNA879067_P_NODE_45901_length_561_cov_2.692623_g42436_i0 | PRJNA879067 | 45901 | 561 | 2.692623 | 15.10561503 | Prosthecobacter sp. | 1965333 | Bacteria | Bacteria | 189 | 7.340000000000001e-59 | NR | WP_294381935.1 | 1965333 | g42436 | i0 | 92 | 1.06951871657754 | 100 | 8 | 53.5 | 0 | 384 | 85 | 1 | 100 | WP_294381935.1 winged helix-turn-helix domain-containing protein [Prosthecobacter sp.] | diamond | 600 | 189 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter sp. | |
| 27063269 | 27063269 | PRJNA879067_P_NODE_107242_length_246_cov_0.890173_g103756_i0 | PRJNA879067 | 107242 | 246 | 0.890173 | 2.18982558 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 70.1 | 8.66e-12 | NR | WP_006982489.1 | 191863 | g103756 | i0 | 46.2 | 8.32926829268293 | 78 | 40 | 95.1 | 1 | 239 | 6 | 44 | 119 | WP_006982489.1 ABC transporter permease [Chthoniobacter flavus] | diamond | 2049 | 70.5 | 0.994326241134752 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacter | Chthoniobacter flavus | |
| 27371664 | 27371664 | PRJNA879067_P_NODE_93343_length_286_cov_1.446009_g89857_i0 | PRJNA879067 | 93343 | 286 | 1.446009 | 4.13558574 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 59.7 | 4.84e-8 | NR | KAB2644833.1 | 2026799 | g89857 | i0 | 37.1 | 1.81468531468531 | 89 | 33 | 93.4 | 1 | 269 | 3 | 2 | 67 | KAB2644833.1 MAG: phytanoyl-CoA dioxygenase family protein [Verrucomicrobiota bacterium] | diamond | 519 | 59.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 27939805 | 27939805 | PRJNA879067_P_NODE_55245_length_483_cov_3.834146_g51760_i0 | PRJNA879067 | 55245 | 483 | 3.834146 | 18.51892518 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 73.2 | 1.21e-11 | NR | HYV20612.1 | 2499141 | g51760 | i0 | 47.1 | 0.84472049689441 | 68 | 35 | 41.6 | 1 | 202 | 2 | 37 | 104 | HYV20612.1 thrombospondin type 3 repeat-containing protein [Verrucomicrobiia bacterium] | diamond | 408 | 73.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 27971227 | 27971227 | PRJNA879067_P_NODE_26205_length_841_cov_2.891927_g22990_i0 | PRJNA879067 | 26205 | 841 | 2.891927 | 24.32110607 | Terrimicrobium sp. | 1965319 | Bacteria | Bacteria | 260 | 3.84e-76 | NR | HEY6676457.1 | 1965319 | g22990 | i0 | 84.7 | 1.07015457788347 | 150 | 23 | 53.5 | 0 | 392 | 841 | 1 | 150 | HEY6676457.1 ATP-binding protein [Terrimicrobium sp.] | diamond | 900 | 260 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Terrimicrobiia | Terrimicrobiales | Terrimicrobiaceae | Terrimicrobium | Terrimicrobium sp. | |
| 28445037 | 28445037 | PRJNA879067_P_NODE_35746_length_676_cov_5.187396_g32344_i0 | PRJNA879067 | 35746 | 676 | 5.187396 | 35.06679696 | Terrimicrobiaceae bacterium | 2832348 | Bacteria | Bacteria | 397 | 7.4e-138 | NR | HVJ56208.1 | 2832348 | g32344 | i0 | 92.3 | 0.980769230769231 | 221 | 17 | 98.1 | 0 | 2 | 664 | 44 | 264 | HVJ56208.1 SDR family NAD(P)-dependent oxidoreductase [Terrimicrobiaceae bacterium] | diamond | 663 | 397 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Terrimicrobiia | Terrimicrobiales | Terrimicrobiaceae | Terrimicrobiaceae bacterium | ||
| 28958298 | 28958298 | PRJNA879067_P_NODE_34588_length_692_cov_12.201939_g31200_i0 | PRJNA879067 | 34588 | 692 | 12.201939 | 84.43741788 | PVC group | 1783257 | Bacteria | Bacteria | 73.6 | 5.94e-11 | NR | MBE7500477.1 | 2026801 | g31200 | i0 | 36.1 | 2.35404624277457 | 133 | 70 | 53.8 | 4 | 182 | 553 | 422 | 548 | MBE7500477.1 protein kinase [Verrucomicrobiales bacterium] | diamond | 1629 | 73.9 | 0.995940460081191 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales bacterium | |||
| 29108007 | 29108007 | PRJNA879067_P_NODE_28308_length_796_cov_1.441217_g25041_i0 | PRJNA879067 | 28308 | 796 | 1.441217 | 11.47208732 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 345 | 4.22e-105 | NR | MBS0647762.1 | 2026799 | g25041 | i0 | 73.9 | 0.836683417085427 | 222 | 43 | 78 | 1 | 623 | 3 | 1397 | 1618 | MBS0647762.1 autotransporter domain-containing protein [Verrucomicrobiota bacterium] | diamond | 666 | 345 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 30474192 | 30474192 | PRJNA879067_P_NODE_35173_length_684_cov_2.310966_g31777_i0 | PRJNA879067 | 35173 | 684 | 2.310966 | 15.80700744 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 112 | 1.16e-26 | NR | MBS0648465.1 | 2026799 | g31777 | i0 | 54.1 | 0.864035087719298 | 98 | 45 | 43 | 0 | 68 | 361 | 97 | 194 | MBS0648465.1 50S ribosomal protein L11 methyltransferase [Verrucomicrobiota bacterium] | diamond | 591 | 112 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 30750458 | 30750458 | PRJNA879067_P_NODE_14774_length_1236_cov_2.645744_g12173_i0 | PRJNA879067 | 14774 | 1236 | 2.645744 | 32.701395840000004 | Opitutus sp. | 1913982 | Bacteria | Bacteria | 320 | 2.7999999999999996e-98 | NR | HYD83789.1 | 1913982 | g12173 | i0 | 45.9 | 0.941747572815534 | 388 | 202 | 93.4 | 5 | 1186 | 32 | 1 | 383 | HYD83789.1 choice-of-anchor R domain-containing protein [Opitutus sp.] | diamond | 1164 | 320 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutus | Opitutus sp. | |
| 31698805 | 31698805 | PRJNA879067_P_NODE_93617_length_285_cov_1.462264_g90131_i0 | PRJNA879067 | 93617 | 285 | 1.462264 | 4.1674524 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 153 | 1.06e-40 | NR | MBS0647762.1 | 2026799 | g90131 | i0 | 83.9 | 0.978947368421053 | 93 | 15 | 97.9 | 0 | 279 | 1 | 1161 | 1253 | MBS0647762.1 autotransporter domain-containing protein [Verrucomicrobiota bacterium] | diamond | 279 | 153 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 31825114 | 31825114 | PRJNA879067_P_NODE_95077_length_280_cov_1.449275_g91591_i0 | PRJNA879067 | 95077 | 280 | 1.449275 | 4.05797 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 122 | 4.089999999999999e-31 | NR | MBI5818678.1 | 2026799 | g91591 | i0 | 64.4 | 0.964285714285714 | 90 | 32 | 96.4 | 0 | 279 | 10 | 215 | 304 | MBI5818678.1 ATP-binding protein [Verrucomicrobiota bacterium] | diamond | 270 | 122 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 32804926 | 32804926 | PRJNA879067_P_NODE_78360_length_346_cov_1.974359_g74874_i0 | PRJNA879067 | 78360 | 346 | 1.974359 | 6.83128214 | Prosthecobacter sp. | 1965333 | Bacteria | Bacteria | 121 | 2.6e-29 | NR | WP_395740529.1 | 1965333 | g74874 | i0 | 60.9 | 0.953757225433526 | 110 | 39 | 91.9 | 1 | 344 | 27 | 187 | 296 | WP_395740529.1 PAS domain S-box protein [Prosthecobacter sp.] | diamond | 330 | 121 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter sp. | |
| 32812901 | 32812901 | PRJNA879067_P_NODE_21440_length_964_cov_19.821549_g18446_i0 | PRJNA879067 | 21440 | 964 | 19.821549 | 191.07973236 | Bacteria | 2 | Bacteria | Bacteria | 443 | 3.8899999999999996e-150 | NR | MBS0645324.1 | 2026799 | g18446 | i0 | 71.8 | 5.87240663900415 | 312 | 88 | 97.1 | 0 | 963 | 28 | 8 | 319 | MBS0645324.1 DUF262 domain-containing protein [Verrucomicrobiota bacterium] | diamond | 5661 | 443 | 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);;