contig_metadata
20 rows where bioproject = "PRJNA599026" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15169325 | 15169325 | PRJNA599026_S_NODE_16072_length_253_cov_1.730392_g15616_i0 | PRJNA599026 | 16072 | 253 | 1.730392 | 4.37789176 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 62.1 | 3.81e-5 | NTclustered | gi|2874254020|emb|OY970345.1| | 412056 | g15616 | i0 | 97.222 | 1.12252964426877 | 36 | 1 | 14 | 0 | 3 | 38 | 1738871 | 1738906 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD04212.bin.2.122 genome assembly, chromosome: 1 | blastn | 284 | 62.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 17149591 | 17149591 | PRJNA599026_S_NODE_60694_length_164_cov_0.886957_g60238_i0 | PRJNA599026 | 60694 | 164 | 0.886957 | 1.45460948 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 102 | 7.29e-25 | NR | MBM3879532.1 | 2026799 | g60238 | i0 | 92.5 | 4.88414634146341 | 53 | 4 | 97 | 0 | 3 | 161 | 159 | 211 | MBM3879532.1 macrocin O-methyltransferase [Verrucomicrobiota bacterium] | diamond | 801 | 102 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 24093104 | 24093104 | PRJNA599026_S_NODE_20699_length_230_cov_1.375691_g20243_i0 | PRJNA599026 | 20699 | 230 | 1.375691 | 3.1640893 | Prosthecobacter debontii | 48467 | Bacteria | Bacteria | 80.9 | 7.66e-17 | NR | SKB05870.1 | 48467 | g20243 | i0 | 64.6 | 3.1304347826087 | 65 | 23 | 84.8 | 0 | 10 | 204 | 124 | 188 | SKB05870.1 putative colanic acid biosynthesis acetyltransferase WcaF [Prosthecobacter debontii] | diamond | 720 | 80.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter debontii | |
| 26984872 | 26984872 | PRJNA599026_S_NODE_59962_length_164_cov_0.886957_g59506_i0 | PRJNA599026 | 59962 | 164 | 0.886957 | 1.45460948 | Verrucomicrobium spinosum | 2736 | Bacteria | Bacteria | 75.1 | 4.93e-14 | NR | WP_009962562.1 | 2736 | g59506 | i0 | 74 | 1.82926829268293 | 50 | 13 | 91.5 | 0 | 163 | 14 | 235 | 284 | WP_009962562.1 alginate O-acetyltransferase AlgX-related protein [Verrucomicrobium spinosum] | diamond | 300 | 75.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobium | Verrucomicrobium spinosum | |
| 27712111 | 27712111 | PRJNA599026_S_NODE_33964_length_193_cov_1.062500_g33508_i0 | PRJNA599026 | 33964 | 193 | 1.0625 | 2.050625 | Opitutaceae bacterium TAV5 | 794903 | Bacteria | Bacteria | 73.6 | 2.69e-13 | NR | AHF92541.1 | 794903 | g33508 | i0 | 54 | 0.979274611398964 | 63 | 29 | 97.9 | 0 | 5 | 193 | 1060 | 1122 | AHF92541.1 hemagglutinin [Opitutaceae bacterium TAV5] | diamond | 189 | 73.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutaceae bacterium TAV5 | ||
| 28248255 | 28248255 | PRJNA599026_S_NODE_50806_length_167_cov_0.864407_g50350_i0 | PRJNA599026 | 50806 | 167 | 0.864407 | 1.44355969 | Verrucomicrobiales bacterium | 2026801 | Bacteria | Bacteria | 55.1 | 5.95e-7 | NR | MCB1207669.1 | 2026801 | g50350 | i0 | 53.4 | 2.02994011976048 | 58 | 24 | 98.8 | 1 | 166 | 2 | 1009 | 1066 | MCB1207669.1 autotransporter-associated beta strand repeat-containing protein [Verrucomicrobiales bacterium] | diamond | 339 | 55.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales bacterium | |||
| 28672359 | 28672359 | PRJNA599026_S_NODE_31867_length_197_cov_1.722973_g31411_i0 | PRJNA599026 | 31867 | 197 | 1.722973 | 3.39425681 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 44.7 | 0.00417 | NR | MBS0648952.1 | 2026799 | g31411 | i0 | 48.4 | 1.69035532994924 | 31 | 16 | 47.2 | 0 | 16 | 108 | 272 | 302 | MBS0648952.1 FAD-dependent oxidoreductase [Verrucomicrobiota bacterium] | diamond | 333 | 44.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 28753612 | 28753612 | PRJNA599026_S_NODE_64727_length_163_cov_0.894737_g64271_i0 | PRJNA599026 | 64727 | 163 | 0.894737 | 1.45842131 | Akkermansia sp. | 1872421 | Bacteria | Bacteria | 43.1 | 0.00947 | NR | MBR2125603.1 | 1872421 | g64271 | i0 | 60 | 1.38036809815951 | 25 | 10 | 46 | 0 | 79 | 5 | 188 | 212 | MBR2125603.1 protein kinase [Akkermansia sp.] | diamond | 225 | 43.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 28785026 | 28785026 | PRJNA599026_S_NODE_46727_length_172_cov_1.056911_g46271_i0 | PRJNA599026 | 46727 | 172 | 1.056911 | 1.81788692 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 53.5 | 2.24e-6 | NR | MBN8456733.1 | 2026799 | g46271 | i0 | 42 | 0.872093023255814 | 50 | 29 | 87.2 | 0 | 17 | 166 | 416 | 465 | MBN8456733.1 alpha-L-fucosidase [Verrucomicrobiota bacterium] | diamond | 150 | 53.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29132672 | 29132672 | PRJNA599026_S_NODE_54749_length_166_cov_0.871795_g54293_i0 | PRJNA599026 | 54749 | 166 | 0.871795 | 1.4471797 | Luteolibacter sp. SL25 | 1962973 | Bacteria | Bacteria | 39.7 | 0.0224 | NR | WP_267674657.1 | 2995170 | g54293 | i0 | 76.2 | 0.379518072289157 | 21 | 5 | 38 | 0 | 104 | 166 | 2 | 22 | WP_267674657.1 hypothetical protein [Luteolibacter sp. SL250] | diamond | 63 | 39.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter sp. SL250 | |
| 29290341 | 29290341 | PRJNA599026_S_NODE_52709_length_167_cov_0.864407_g52253_i0 | PRJNA599026 | 52709 | 167 | 0.864407 | 1.44355969 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 70.9 | 5.73e-13 | NR | MBI1840806.1 | 2026799 | g52253 | i0 | 59.2 | 0.880239520958084 | 49 | 20 | 88 | 0 | 5 | 151 | 99 | 147 | MBI1840806.1 type II secretion system protein [Verrucomicrobiota bacterium] | diamond | 147 | 70.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 30206010 | 30206010 | PRJNA599026_S_NODE_64092_length_163_cov_0.894737_g63636_i0 | PRJNA599026 | 64092 | 163 | 0.894737 | 1.45842131 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 72 | 5.75e-13 | NR | MDX1951515.1 | 2026799 | g63636 | i0 | 69.2 | 0.957055214723926 | 52 | 16 | 95.7 | 0 | 158 | 3 | 120 | 171 | MDX1951515.1 tape measure protein [Verrucomicrobiota bacterium] | diamond | 156 | 72 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 30756729 | 30756729 | PRJNA599026_S_NODE_55274_length_166_cov_0.871795_g54818_i0 | PRJNA599026 | 55274 | 166 | 0.871795 | 1.4471797 | Bacteria | 2 | Bacteria | Bacteria | 75.9 | 2.7e-14 | NR | HUI07131.1 | 2499141 | g54818 | i0 | 66.7 | 8.80120481927711 | 54 | 18 | 97.6 | 0 | 166 | 5 | 261 | 314 | HUI07131.1 DUF4041 domain-containing protein [Verrucomicrobiia bacterium] | diamond | 1461 | 76.3 | 0.99475753604194 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 31216909 | 31216909 | PRJNA599026_S_NODE_32275_length_196_cov_2.081633_g31819_i0 | PRJNA599026 | 32275 | 196 | 2.081633 | 4.08000068 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 71.2 | 1.71e-12 | NR | MBS0621877.1 | 2026799 | g31819 | i0 | 50 | 0.948979591836735 | 62 | 31 | 94.9 | 0 | 191 | 6 | 225 | 286 | MBS0621877.1 pyruvate kinase [Verrucomicrobiota bacterium] | diamond | 186 | 71.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 31280530 | 31280530 | PRJNA599026_S_NODE_61875_length_164_cov_0.886957_g61419_i0 | PRJNA599026 | 61875 | 164 | 0.886957 | 1.45460948 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 70.1 | 2.86e-12 | NR | MBI3415380.1 | 2026799 | g61419 | i0 | 66.1 | 1.02439024390244 | 56 | 16 | 97 | 1 | 160 | 2 | 1016 | 1071 | MBI3415380.1 PSD1 domain-containing protein [Verrucomicrobiota bacterium] | diamond | 168 | 70.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 31659950 | 31659950 | PRJNA599026_S_NODE_60717_length_164_cov_0.886957_g60261_i0 | PRJNA599026 | 60717 | 164 | 0.886957 | 1.45460948 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 62 | 2.01e-9 | NR | HEX5222173.1 | 2499141 | g60261 | i0 | 53.7 | 0.98780487804878 | 54 | 25 | 98.8 | 0 | 2 | 163 | 383 | 436 | HEX5222173.1 Calx-beta domain-containing protein [Verrucomicrobiia bacterium] | diamond | 162 | 62 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 31863055 | 31863055 | PRJNA599026_S_NODE_51617_length_167_cov_0.864407_g51161_i0 | PRJNA599026 | 51617 | 167 | 0.864407 | 1.44355969 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 50.8 | 1.84e-5 | NR | MBS0604105.1 | 2026799 | g51161 | i0 | 88.5 | 4.20359281437126 | 26 | 3 | 46.7 | 0 | 3 | 80 | 248 | 273 | MBS0604105.1 diphosphate--fructose-6-phosphate 1-phosphotransferase [Verrucomicrobiota bacterium] | diamond | 702 | 51.2 | 0.9921875 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 32432992 | 32432992 | PRJNA599026_S_NODE_68119_length_162_cov_0.902655_g67663_i0 | PRJNA599026 | 68119 | 162 | 0.902655 | 1.4623011 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 62.4 | 1.41e-9 | NR | MCA1659486.1 | 2026800 | g67663 | i0 | 56 | 3.87037037037037 | 50 | 22 | 92.6 | 0 | 152 | 3 | 364 | 413 | MCA1659486.1 efflux RND transporter permease subunit [Verrucomicrobiaceae bacterium] | diamond | 627 | 62.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 32451366 | 32451366 | PRJNA599026_S_NODE_8079_length_340_cov_1.591065_g7623_i0 | PRJNA599026 | 8079 | 340 | 1.591065 | 5.409621 | Chthoniobacterales bacterium | 2201154 | Bacteria | Bacteria | 44.7 | 0.0217 | NR | HZE56464.1 | 2201154 | g7623 | i0 | 30.3 | 4.69411764705882 | 66 | 41 | 58.2 | 1 | 203 | 6 | 353 | 413 | HZE56464.1 N-acetylmuramoyl-L-alanine amidase [Chthoniobacterales bacterium] | diamond | 1596 | 44.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacterales bacterium | |||
| 32797756 | 32797756 | PRJNA599026_S_NODE_6860_length_366_cov_2.662461_g6404_i0 | PRJNA599026 | 6860 | 366 | 2.662461 | 9.74460726 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 56.2 | 2.73e-6 | NR | MBN8456733.1 | 2026799 | g6404 | i0 | 41.4 | 0.918032786885246 | 58 | 34 | 47.5 | 0 | 191 | 364 | 416 | 473 | MBN8456733.1 alpha-L-fucosidase [Verrucomicrobiota bacterium] | diamond | 336 | 56.2 | 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);;