contig_metadata
22 rows where bioproject = "PRJNA685607" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3728078 | 3728078 | PRJNA685607_P_NODE_36203_length_310_cov_2.476793_g35844_i0 | PRJNA685607 | 36203 | 310 | 2.476793 | 7.6780583 | root | 1 | Root_unresolved | Root_unresolved | 80.5 | 3.51e-17 | NR | WP_075089093.1 | 2736 | g35844 | i0 | 54.1 | 18.0677419354839 | 74 | 33 | 70.6 | 1 | 236 | 18 | 4 | 77 | WP_075089093.1 RNA recognition motif domain-containing protein, partial [Verrucomicrobium spinosum] | diamond | 5601 | 80.9 | 0.995055624227441 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobium | Verrucomicrobium spinosum | |
| 14695323 | 14695323 | PRJNA685607_P_NODE_58172_length_263_cov_0.810526_g57813_i0 | PRJNA685607 | 58172 | 263 | 0.810526 | 2.13168338 | Ereboglobus luteus | 1796921 | Bacteria | Bacteria | 250 | 7.93e-62 | NTclustered | gi|1387286769|gb|CP023004.1| | 1796921 | g57813 | i0 | 83.908 | 55.254752851711 | 261 | 42 | 99 | 0 | 3 | 263 | 241368 | 241628 | Ereboglobus luteus strain Ho45, complete genome | blastn | 14532 | 250 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Ereboglobus | Ereboglobus luteus | |
| 27145019 | 27145019 | PRJNA685607_P_NODE_85442_length_244_cov_0.900585_g85083_i0 | PRJNA685607 | 85442 | 244 | 0.900585 | 2.1974274 | Chthoniobacterales bacterium | 2201154 | Bacteria | Bacteria | 55.5 | 1.25e-6 | NR | MBX9578643.1 | 2201154 | g85083 | i0 | 49.1 | 0.676229508196721 | 55 | 28 | 67.6 | 0 | 240 | 76 | 438 | 492 | MBX9578643.1 LamG domain-containing protein [Chthoniobacterales bacterium] | diamond | 165 | 55.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacterales bacterium | |||
| 27156658 | 27156658 | PRJNA685607_P_NODE_89842_length_243_cov_0.905882_g89483_i0 | PRJNA685607 | 89842 | 243 | 0.905882 | 2.20129326 | Bacteria | 2 | Bacteria | Bacteria | 48.5 | 3.47e-4 | NR | MBN2508489.1 | 2026799 | g89483 | i0 | 40.2 | 3.82716049382716 | 82 | 47 | 100 | 2 | 243 | 1 | 56 | 136 | MBN2508489.1 HYR domain-containing protein [Verrucomicrobiota bacterium] | diamond | 930 | 48.9 | 0.991820040899796 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 27271860 | 27271860 | PRJNA685607_P_NODE_75643_length_248_cov_0.880000_g75284_i0 | PRJNA685607 | 75643 | 248 | 0.88 | 2.1824 | Verrucomicrobiales bacterium | 2026801 | Bacteria | Bacteria | 115 | 2.3199999999999997e-30 | NR | HCN77698.1 | 2026801 | g75284 | i0 | 85.3 | 0.82258064516129 | 68 | 10 | 82.3 | 0 | 3 | 206 | 114 | 181 | HCN77698.1 RNA polymerase subunit sigma-24 [Verrucomicrobiales bacterium] | diamond | 204 | 115 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales bacterium | |||
| 27335246 | 27335246 | PRJNA685607_P_NODE_65263_length_251_cov_0.865169_g64904_i0 | PRJNA685607 | 65263 | 251 | 0.865169 | 2.17157419 | Chthoniobacter flavus | 191863 | Bacteria | Bacteria | 124 | 8.489999999999999e-31 | NR | WP_131989126.1 | 191863 | g64904 | i0 | 78 | 1.9601593625498 | 82 | 17 | 98 | 1 | 248 | 3 | 1549 | 1629 | WP_131989126.1 autotransporter domain-containing protein [Chthoniobacter flavus] | diamond | 492 | 124 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacter | Chthoniobacter flavus | |
| 27366978 | 27366978 | PRJNA685607_P_NODE_68763_length_250_cov_0.870056_g68404_i0 | PRJNA685607 | 68763 | 250 | 0.870056 | 2.17514 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 90.1 | 4.28e-20 | NR | MES2469889.1 | 2026799 | g68404 | i0 | 88.6 | 0.528 | 44 | 5 | 52.8 | 0 | 132 | 1 | 1 | 44 | MES2469889.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 132 | 90.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 27461596 | 27461596 | PRJNA685607_P_NODE_44063_length_290_cov_1.405530_g43704_i0 | PRJNA685607 | 44063 | 290 | 1.40553 | 4.076037 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 71.2 | 6.35e-12 | NR | MDD8051452.1 | 2026799 | g43704 | i0 | 40 | 2.94827586206897 | 95 | 53 | 98.3 | 3 | 2 | 286 | 91 | 181 | MDD8051452.1 lamin tail domain-containing protein [Verrucomicrobiota bacterium] | diamond | 855 | 71.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 28535156 | 28535156 | PRJNA685607_P_NODE_84867_length_244_cov_2.233918_g84508_i0 | PRJNA685607 | 84867 | 244 | 2.233918 | 5.45075992 | Verrucomicrobiales bacterium | 2026801 | Bacteria | Bacteria | 53.9 | 2.04e-6 | NR | MBG89593.1 | 2026801 | g84508 | i0 | 60 | 1.40163934426229 | 40 | 15 | 48 | 1 | 127 | 243 | 1 | 40 | MBG89593.1 hypothetical protein [Verrucomicrobiales bacterium] | diamond | 342 | 53.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales bacterium | |||
| 28787364 | 28787364 | PRJNA685607_P_NODE_53207_length_272_cov_1.190955_g52848_i0 | PRJNA685607 | 53207 | 272 | 1.190955 | 3.2393976 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 46.6 | 0.00229 | NR | MDB4808113.1 | 2026799 | g52848 | i0 | 47.9 | 0.529411764705882 | 48 | 25 | 52.9 | 0 | 146 | 3 | 28 | 75 | MDB4808113.1 ankyrin repeat domain-containing protein [Verrucomicrobiota bacterium] | diamond | 144 | 46.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29083380 | 29083380 | PRJNA685607_P_NODE_23768_length_355_cov_1.007092_g23409_i0 | PRJNA685607 | 23768 | 355 | 1.007092 | 3.5751766 | Bacteria | 2 | Bacteria | Bacteria | 69.3 | 6.32e-11 | NR | MEC7863212.1 | 2026799 | g23409 | i0 | 43 | 5.52676056338028 | 93 | 44 | 78.6 | 2 | 56 | 334 | 374 | 457 | MEC7863212.1 chitobiase/beta-hexosaminidase C-terminal domain-containing protein [Verrucomicrobiota bacterium] | diamond | 1962 | 69.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29292690 | 29292690 | PRJNA685607_P_NODE_69509_length_250_cov_0.870056_g69150_i0 | PRJNA685607 | 69509 | 250 | 0.870056 | 2.17514 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 84.7 | 3.68e-18 | NR | MES2696275.1 | 2026799 | g69150 | i0 | 90 | 1.2 | 50 | 5 | 60 | 0 | 1 | 150 | 148 | 197 | MES2696275.1 dephospho-CoA kinase [Verrucomicrobiota bacterium] | diamond | 300 | 84.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 30145114 | 30145114 | PRJNA685607_P_NODE_95192_length_241_cov_0.916667_g94833_i0 | PRJNA685607 | 95192 | 241 | 0.916667 | 2.20916747 | Candidatus Didemnitutus sp. | 2814259 | Bacteria | Bacteria | 146 | 4.2e-39 | NR | MDP2137738.1 | 2814259 | g94833 | i0 | 96.2 | 0.983402489626556 | 79 | 3 | 98.3 | 0 | 3 | 239 | 414 | 492 | MDP2137738.1 hypothetical protein [Candidatus Didemnitutus sp.] | diamond | 237 | 146 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Candidatus Didemnitutus | Candidatus Didemnitutus sp. | |
| 30714090 | 30714090 | PRJNA685607_P_NODE_74154_length_248_cov_0.880000_g73795_i0 | PRJNA685607 | 74154 | 248 | 0.88 | 2.1824 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 137 | 2.87e-38 | NR | MES2465814.1 | 2026799 | g73795 | i0 | 82.9 | 0.991935483870968 | 82 | 14 | 99.2 | 0 | 246 | 1 | 87 | 168 | MES2465814.1 YdjY domain-containing protein [Verrucomicrobiota bacterium] | diamond | 246 | 137 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 30935407 | 30935407 | PRJNA685607_P_NODE_80534_length_246_cov_0.890173_g80175_i0 | PRJNA685607 | 80534 | 246 | 0.890173 | 2.18982558 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 112 | 7.260000000000001e-27 | NR | HMP82534.1 | 2026799 | g80175 | i0 | 63 | 1.97560975609756 | 81 | 29 | 97.6 | 1 | 2 | 241 | 149 | 229 | HMP82534.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 486 | 112 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 31156135 | 31156135 | PRJNA685607_P_NODE_24875_length_350_cov_0.981949_g24516_i0 | PRJNA685607 | 24875 | 350 | 0.981949 | 3.4368215 | Opitutaceae bacterium | 2006848 | Bacteria | Bacteria | 55.5 | 4.27e-6 | NR | MDO8544325.1 | 2006848 | g24516 | i0 | 38.1 | 0.54 | 63 | 37 | 54 | 1 | 344 | 156 | 203 | 263 | MDO8544325.1 PRC-barrel domain-containing protein [Opitutaceae bacterium] | diamond | 189 | 55.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium | ||
| 31219330 | 31219330 | PRJNA685607_P_NODE_95395_length_241_cov_0.916667_g95036_i0 | PRJNA685607 | 95395 | 241 | 0.916667 | 2.20916747 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 118 | 6.91e-30 | NR | MBS0648370.1 | 2026799 | g95036 | i0 | 65 | 0.995850622406639 | 80 | 28 | 99.6 | 0 | 241 | 2 | 219 | 298 | MBS0648370.1 pesticidal protein Cry15Aa [Verrucomicrobiota bacterium] | diamond | 240 | 118 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 31282838 | 31282838 | PRJNA685607_P_NODE_48455_length_281_cov_1.475962_g48096_i0 | PRJNA685607 | 48455 | 281 | 1.475962 | 4.14745322 | Prosthecobacter dejongeii | 48465 | Bacteria | Bacteria | 52.4 | 2.29e-5 | NR | WP_184211924.1 | 48465 | g48096 | i0 | 47.3 | 0.587188612099644 | 55 | 28 | 58.7 | 1 | 117 | 281 | 244 | 297 | WP_184211924.1 FAD-binding domain-containing protein [Prosthecobacter dejongeii] | diamond | 165 | 52.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter dejongeii | |
| 31567847 | 31567847 | PRJNA685607_P_NODE_78596_length_247_cov_0.885057_g78237_i0 | PRJNA685607 | 78596 | 247 | 0.885057 | 2.18609079 | Chthoniobacteraceae bacterium | 2811408 | Bacteria | Bacteria | 108 | 3.2300000000000003e-27 | NR | HZJ15627.1 | 2811408 | g78237 | i0 | 73.3 | 0.910931174089069 | 75 | 19 | 91.1 | 1 | 23 | 247 | 2 | 75 | HZJ15627.1 sigma-70 family RNA polymerase sigma factor [Chthoniobacteraceae bacterium] | diamond | 225 | 108 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacteraceae bacterium | ||
| 31788792 | 31788792 | PRJNA685607_P_NODE_81277_length_246_cov_0.890173_g80918_i0 | PRJNA685607 | 81277 | 246 | 0.890173 | 2.18982558 | Luteolibacter sp. SL25 | 1962973 | Bacteria | Bacteria | 127 | 6.329999999999999e-32 | NR | WP_267674639.1 | 2995170 | g80918 | i0 | 75.3 | 1.97560975609756 | 81 | 20 | 98.8 | 0 | 2 | 244 | 364 | 444 | WP_267674639.1 AsmA-like C-terminal region-containing protein [Luteolibacter sp. SL250] | diamond | 486 | 127 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. SL250 | |
| 32465180 | 32465180 | PRJNA685607_P_NODE_96839_length_241_cov_0.916667_g96480_i0 | PRJNA685607 | 96839 | 241 | 0.916667 | 2.20916747 | Bacteria | 2 | Bacteria | Bacteria | 121 | 3.69e-33 | NR | MBM3869666.1 | 2026799 | g96480 | i0 | 70.5 | 6.82157676348548 | 78 | 23 | 97.1 | 0 | 2 | 235 | 27 | 104 | MBM3869666.1 phosphoribosyl-AMP cyclohydrolase [Verrucomicrobiota bacterium] | diamond | 1644 | 121 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 32580149 | 32580149 | PRJNA685607_P_NODE_41419_length_297_cov_0.959821_g41060_i0 | PRJNA685607 | 41419 | 297 | 0.959821 | 2.85066837 | Haloferula helveola | 490095 | Bacteria | Bacteria | 58.9 | 1.5e-7 | NR | WP_338686615.1 | 490095 | g41060 | i0 | 34.8 | 1.70707070707071 | 92 | 58 | 90.9 | 1 | 19 | 288 | 748 | 839 | WP_338686615.1 RICIN domain-containing protein [Haloferula helveola] | diamond | 507 | 58.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Haloferula | Haloferula helveola |
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);;