contig_metadata
20 rows where bioproject = "PRJNA278119" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 371306 | 371306 | PRJNA278119_P_NODE_32421_length_174_cov_1.536000_g32172_i0 | PRJNA278119 | 32421 | 174 | 1.536 | 2.67264 | Verrucomicrobiota | 74201 | Bacteria | Bacteria | 73.6 | 1.35e-13 | NR | PAZ00748.1 | 1982325 | g32172 | i0 | 79.1 | 18.8275862068966 | 43 | 9 | 74.1 | 0 | 138 | 10 | 1 | 43 | PAZ00748.1 MAG: malate dehydrogenase [Spartobacteria bacterium AMD-G4] | diamond | 3276 | 73.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Spartobacteria bacterium AMD-G4 | ||||
| 4886654 | 4886654 | PRJNA278119_P_NODE_14964_length_280_cov_2.601732_g14715_i0 | PRJNA278119 | 14964 | 280 | 2.601732 | 7.2848496 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 164 | 7.59e-47 | NR | MCX6967887.1 | 2026799 | g14715 | i0 | 79.1 | 6.91071428571429 | 91 | 19 | 97.5 | 0 | 274 | 2 | 271 | 361 | MCX6967887.1 elongation factor Tu [Verrucomicrobiota bacterium] | diamond | 1935 | 164 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 9299658 | 9299658 | PRJNA278119_P_NODE_788_length_1323_cov_38.355573_g658_i0 | PRJNA278119 | 788 | 1323 | 38.355573 | 507.44423079 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 427 | 4.799999999999999e-145 | NR | RYD65414.1 | 2026800 | g658 | i0 | 75.5 | 0.639455782312925 | 282 | 66 | 63.7 | 2 | 1011 | 169 | 56 | 335 | RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium] | diamond | 846 | 427 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 14400132 | 14400132 | PRJNA278119_P_NODE_20312_length_222_cov_0.901734_g20063_i0 | PRJNA278119 | 20312 | 222 | 0.901734 | 2.00184948 | Termitidicoccus mucosus | 1184151 | Bacteria | Bacteria | 91.3 | 1.54e-19 | NR | WP_068772074.1 | 1184151 | g20063 | i0 | 78.3 | 4.08108108108108 | 60 | 13 | 81.1 | 0 | 220 | 41 | 31 | 90 | WP_068772074.1 phosphoglycerate kinase [Termitidicoccus mucosus] | diamond | 906 | 91.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Termitidicoccus | Termitidicoccus mucosus | |
| 14400169 | 14400169 | PRJNA278119_P_NODE_22832_length_207_cov_1.031646_g22583_i0 | PRJNA278119 | 22832 | 207 | 1.031646 | 2.13550722 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 230 | 7.7999999999999985e-56 | NTclustered | gi|2874253779|emb|OY969763.1| | 412056 | g22583 | i0 | 89.247 | 92.9420289855072 | 186 | 16 | 90 | 2 | 5 | 190 | 3832565 | 3832384 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1 | blastn | 19239 | 230 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 14400251 | 14400251 | PRJNA278119_P_NODE_28872_length_184_cov_1.540741_g28623_i0 | PRJNA278119 | 28872 | 184 | 1.540741 | 2.83496344 | uncultured Verrucomicrobiae bacterium | 412056 | Bacteria | Bacteria | 244 | 2.41e-60 | NTclustered | gi|2874254040|emb|OY970364.1| | 412056 | g28623 | i0 | 91.16 | 105.66847826087 | 181 | 14 | 98 | 2 | 1 | 180 | 989080 | 989259 | MAG: uncultured Verrucomicrobiae bacterium isolate MFD04463.bin.c.15 genome assembly, chromosome: 1 | blastn | 19443 | 244 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | uncultured Verrucomicrobiae bacterium | ||||
| 16948788 | 16948788 | PRJNA278119_P_NODE_3754_length_623_cov_1.768293_g3516_i0 | PRJNA278119 | 3754 | 623 | 1.768293 | 11.01646539 | Nibricoccus aquaticus | 2576891 | Bacteria | Bacteria | 1016 | 0 | NTclustered | gi|1243404978|gb|CP023344.1| | 2576891 | g3516 | i0 | 96.429 | 106.157303370787 | 616 | 22 | 99 | 0 | 6 | 621 | 2497075 | 2497690 | Nibricoccus aquaticus strain HZ-65 chromosome, complete genome | blastn | 66136 | 1016 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Nibricoccus | Nibricoccus aquaticus | |
| 18223109 | 18223109 | PRJNA278119_P_NODE_39395_length_166_cov_1.333333_g39146_i0 | PRJNA278119 | 39395 | 166 | 1.333333 | 2.21333278 | Actomonas aquatica | 2866162 | Bacteria | Bacteria | 75 | 2.97e-9 | NTclustered | gi|2647674565|gb|CP139781.1| | 2866162 | g39146 | i0 | 97.674 | 0.259036144578313 | 43 | 1 | 26 | 0 | 10 | 52 | 1672679 | 1672637 | Actomonas aquatica strain WL0086 chromosome, complete genome | blastn | 43 | 75 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Actomonas | Actomonas aquatica | |
| 20772953 | 20772953 | PRJNA278119_P_NODE_45637_length_163_cov_0.912281_g45388_i0 | PRJNA278119 | 45637 | 163 | 0.912281 | 1.48701803 | Oleiharenicola sp. Vm1 | 3398393 | Bacteria | Bacteria | 176 | 7.73e-40 | NTclustered | gi|2912653302|gb|CP180537.1| | 3398393 | g45388 | i0 | 86.709 | 4.82822085889571 | 158 | 21 | 97 | 0 | 1 | 158 | 3216485 | 3216328 | Oleiharenicola sp. Vm1 chromosome, complete genome | blastn | 787 | 176 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Oleiharenicola | Oleiharenicola sp. Vm1 | |
| 21460463 | 21460463 | PRJNA278119_P_NODE_1517_length_993_cov_4.096398_g1334_i0 | PRJNA278119 | 1517 | 993 | 4.096398 | 40.67723214 | Nibricoccus | 2576890 | Bacteria | Bacteria | 1171 | 0 | NTclustered | gi|807238858|gb|CP011265.1| | 1637999 | g1334 | i0 | 91.924 | 200.229607250755 | 842 | 61 | 84 | 7 | 1 | 838 | 1902491 | 1901653 | Verrucomicrobia bacterium IMCC26134, complete genome | blastn | 198828 | 1182 | 0.990693739424704 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobia bacterium IMCC26134 | |||||
| 22047651 | 22047651 | PRJNA278119_P_NODE_21338_length_215_cov_1.391566_g21089_i0 | PRJNA278119 | 21338 | 215 | 1.391566 | 2.9918669 | Chthoniobacteraceae bacterium | 2811408 | Bacteria | Bacteria | 93.5 | 1.12e-14 | NTclustered | gi|2813917447|gb|CP170506.1| | 2811408 | g21089 | i0 | 93.651 | 0.423255813953488 | 63 | 3 | 29 | 1 | 81 | 143 | 4278816 | 4278755 | MAG: Chthoniobacteraceae bacterium isolate SH-KS-3 chromosome, complete genome | blastn | 91 | 93.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacteraceae bacterium | ||
| 27895207 | 27895207 | PRJNA278119_P_NODE_12785_length_316_cov_1.168539_g12537_i0 | PRJNA278119 | 12785 | 316 | 1.168539 | 3.69258324 | Pelagicoccus sp. SDUM812 | 2921790 | Bacteria | Bacteria | 162 | 1.85e-48 | NR | WP_309022849.1 | 3041266 | g12537 | i0 | 69.2 | 3.80696202531646 | 104 | 32 | 98.7 | 0 | 3 | 314 | 56 | 159 | WP_309022849.1 sugar O-acetyltransferase [Pelagicoccus sp. SDUM812002] | diamond | 1203 | 162 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Puniceicoccales | Pelagicoccaceae | Pelagicoccus | Pelagicoccus sp. SDUM812002 | |
| 28621693 | 28621693 | PRJNA278119_P_NODE_907_length_1255_cov_7.249585_g766_i0 | PRJNA278119 | 907 | 1255 | 7.249585 | 90.98229175 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 108 | 4.34e-21 | NR | MDA1277427.1 | 2026799 | g766 | i0 | 29.5 | 0.827091633466135 | 346 | 192 | 76.3 | 13 | 1215 | 259 | 32 | 352 | MDA1277427.1 protein kinase [Verrucomicrobiota bacterium] | diamond | 1038 | 108 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29726346 | 29726346 | PRJNA278119_P_NODE_14010_length_296_cov_0.874494_g13761_i0 | PRJNA278119 | 14010 | 296 | 0.874494 | 2.58850224 | Opitutia bacterium | 2026771 | Bacteria | Bacteria | 63.2 | 4.63e-9 | NR | MEK9633257.1 | 2026771 | g13761 | i0 | 50.9 | 2.16891891891892 | 55 | 27 | 55.7 | 0 | 8 | 172 | 382 | 436 | MEK9633257.1 BspA family leucine-rich repeat surface protein [Opitutia bacterium] | diamond | 642 | 63.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutia bacterium | ||||
| 29758111 | 29758111 | PRJNA278119_P_NODE_5111_length_529_cov_1.560417_g4867_i0 | PRJNA278119 | 5111 | 529 | 1.560417 | 8.25460593 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 129 | 1.35e-32 | NR | RYD71398.1 | 2026800 | g4867 | i0 | 48.9 | 0.776937618147448 | 137 | 68 | 76.6 | 2 | 418 | 14 | 60 | 196 | RYD71398.1 MAG: hypothetical protein EOP84_24945, partial [Verrucomicrobiaceae bacterium] | diamond | 411 | 129 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 30408047 | 30408047 | PRJNA278119_P_NODE_42233_length_165_cov_0.896552_g41984_i0 | PRJNA278119 | 42233 | 165 | 0.896552 | 1.4793108 | root | 1 | Root_unresolved | Root_unresolved | 65.5 | 5.4e-11 | NR | NBY42112.1 | 2026799 | g41984 | i0 | 61.5 | 5.78181818181818 | 52 | 20 | 94.5 | 0 | 161 | 6 | 17 | 68 | NBY42112.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 954 | 65.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 31260879 | 31260879 | PRJNA278119_P_NODE_36195_length_168_cov_1.310924_g35946_i0 | PRJNA278119 | 36195 | 168 | 1.310924 | 2.20235232 | Opitutus | 178440 | Bacteria | Bacteria | 67.8 | 1.92e-11 | NR | HYP16395.1 | 1913982 | g35946 | i0 | 58.2 | 4.94642857142857 | 55 | 22 | 98.2 | 1 | 2 | 166 | 207 | 260 | HYP16395.1 RICIN domain-containing protein [Opitutus sp.] | diamond | 831 | 68.2 | 0.994134897360704 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Opitutus | Opitutus sp. | |
| 31337947 | 31337947 | PRJNA278119_P_NODE_17216_length_251_cov_0.935644_g16967_i0 | PRJNA278119 | 17216 | 251 | 0.935644 | 2.34846644 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 99.4 | 2.58e-24 | NR | RYD70705.1 | 2026800 | g16967 | i0 | 56.6 | 0.99203187250996006 | 83 | 35 | 99.2 | 1 | 251 | 3 | 50 | 131 | RYD70705.1 MAG: hypothetical protein EOP84_26235 [Verrucomicrobiaceae bacterium] | diamond | 249 | 99.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 31496388 | 31496388 | PRJNA278119_P_NODE_27136_length_190_cov_1.106383_g26887_i0 | PRJNA278119 | 27136 | 190 | 1.106383 | 2.1021277 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 97.8 | 1.7000000000000002e-22 | NR | RYD65414.1 | 2026800 | g26887 | i0 | 80.3 | 0.963157894736842 | 61 | 12 | 96.3 | 0 | 7 | 189 | 73 | 133 | RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium] | diamond | 183 | 97.8 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 31780701 | 31780701 | PRJNA278119_P_NODE_21197_length_216_cov_1.155689_g20948_i0 | PRJNA278119 | 21197 | 216 | 1.155689 | 2.49628824 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 130 | 6.7e-34 | NR | RYD76251.1 | 2026800 | g20948 | i0 | 84.5 | 1.97222222222222 | 71 | 11 | 98.6 | 0 | 3 | 215 | 34 | 104 | RYD76251.1 MAG: hypothetical protein EOP84_17160, partial [Verrucomicrobiaceae bacterium] | diamond | 426 | 130 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae 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);;