contig_metadata
19 rows where bioproject = "PRJNA515078", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10690584 | 10690584 | PRJNA515078_P_NODE_18369_length_203_cov_0.939759_g18136_i0 | PRJNA515078 | 18369 | 203 | 0.939759 | 1.90771077 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 104 | 3.13e-24 | NR | NBD37350.1 | 2026799 | g18136 | i0 | 73.1 | 1.98029556650246 | 67 | 18 | 99 | 0 | 3 | 203 | 26 | 92 | NBD37350.1 molecular chaperone HtpG [Verrucomicrobiota bacterium] | diamond | 402 | 104 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 14515896 | 14515896 | PRJNA515078_P_NODE_8112_length_322_cov_2.280702_g7879_i0 | PRJNA515078 | 8112 | 322 | 2.280702 | 7.34386044 | Luteolibacter luteus | 2728835 | Bacteria | Bacteria | 54.7 | 0.008 | NTclustered | gi|1835317346|gb|CP051774.1| | 2728835 | g7879 | i0 | 100 | 0.0900621118012422 | 29 | 0 | 9 | 0 | 241 | 269 | 1840248 | 1840220 | Luteolibacter luteus strain G-1-1-1 chromosome, complete genome | blastn | 29 | 54.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter luteus | |
| 24712819 | 24712819 | PRJNA515078_P_NODE_10580_length_277_cov_1.300000_g10347_i0 | PRJNA515078 | 10580 | 277 | 1.3 | 3.601 | Fontisphaera persica | 2974023 | Bacteria | Bacteria | 230 | 1.1e-55 | NTclustered | gi|2439237958|gb|CP116615.1| | 2974023 | g10347 | i0 | 82.482 | 105.335740072202 | 274 | 36 | 96 | 8 | 1 | 265 | 3861307 | 3861037 | Fontisphaera persica strain B-154 chromosome, complete genome | blastn | 29178 | 230 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Limisphaerales | Fontisphaeraceae | Fontisphaera | Fontisphaera persica | |
| 26824174 | 26824174 | PRJNA515078_P_NODE_6901_length_356_cov_1.360502_g6668_i0 | PRJNA515078 | 6901 | 356 | 1.360502 | 4.84338712 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 70.5 | 2.01e-11 | NR | RYD71398.1 | 2026800 | g6668 | i0 | 38.7 | 0.935393258426966 | 111 | 57 | 89.3 | 5 | 22 | 339 | 149 | 253 | RYD71398.1 MAG: hypothetical protein EOP84_24945, partial [Verrucomicrobiaceae bacterium] | diamond | 333 | 70.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 26919019 | 26919019 | PRJNA515078_P_NODE_482_length_1302_cov_6.989723_g409_i0 | PRJNA515078 | 482 | 1302 | 6.989723 | 91.00619346 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 414 | 3.64e-140 | NR | RYD65414.1 | 2026800 | g409 | i0 | 67.9 | 0.688940092165899 | 299 | 90 | 68.9 | 2 | 246 | 1142 | 43 | 335 | RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium] | diamond | 897 | 414 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 27330153 | 27330153 | PRJNA515078_P_NODE_11543_length_263_cov_1.517699_g11310_i0 | PRJNA515078 | 11543 | 263 | 1.517699 | 3.99154837 | Prosthecobacter sp. | 1965333 | Bacteria | Bacteria | 43.5 | 0.0255 | NR | HEY1083865.1 | 1965333 | g11310 | i0 | 36.2 | 0.787072243346008 | 69 | 42 | 76.4 | 1 | 3 | 203 | 324 | 392 | HEY1083865.1 tetratricopeptide repeat protein [Prosthecobacter sp.] | diamond | 207 | 43.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter sp. | |
| 27582623 | 27582623 | PRJNA515078_P_NODE_29064_length_162_cov_1.112000_g28831_i0 | PRJNA515078 | 29064 | 162 | 1.112 | 1.80144 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 61.2 | 3.79e-9 | NR | RFC52718.1 | 2026799 | g28831 | i0 | 57.4 | 1 | 54 | 22 | 98.1 | 1 | 162 | 4 | 646 | 699 | RFC52718.1 MAG: F5/8 type C domain-containing protein/F5/8 type C domain-containing protein [Verrucomicrobiota bacterium] | diamond | 162 | 61.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 27819299 | 27819299 | PRJNA515078_P_NODE_12604_length_250_cov_1.798122_g12371_i0 | PRJNA515078 | 12604 | 250 | 1.798122 | 4.495305 | PVC group | 1783257 | Bacteria | Bacteria | 121 | 2.18e-31 | NR | MBR4107997.1 | 1872421 | g12371 | i0 | 66.3 | 31.872 | 83 | 28 | 99.6 | 0 | 1 | 249 | 176 | 258 | MBR4107997.1 elongation factor Tu [Akkermansia sp.] | diamond | 7968 | 122 | 0.991803278688525 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansia | Akkermansia sp. | |
| 28024827 | 28024827 | PRJNA515078_P_NODE_5725_length_395_cov_2.321229_g5492_i0 | PRJNA515078 | 5725 | 395 | 2.321229 | 9.16885455 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 72 | 8.65e-12 | NR | RYD71398.1 | 2026800 | g5492 | i0 | 40.4 | 3.06835443037975 | 109 | 50 | 73.7 | 5 | 390 | 100 | 185 | 290 | RYD71398.1 MAG: hypothetical protein EOP84_24945, partial [Verrucomicrobiaceae bacterium] | diamond | 1212 | 72 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 28308978 | 28308978 | PRJNA515078_P_NODE_28566_length_163_cov_1.238095_g28333_i0 | PRJNA515078 | 28566 | 163 | 1.238095 | 2.01809485 | Luteolibacter luteus | 2728835 | Bacteria | Bacteria | 68.2 | 1.36e-11 | NR | WP_169453120.1 | 2728835 | g28333 | i0 | 49.1 | 0.975460122699387 | 53 | 27 | 97.5 | 0 | 5 | 163 | 100 | 152 | WP_169453120.1 lectin-like domain-containing protein [Luteolibacter luteus] | diamond | 159 | 68.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter luteus | |
| 28466906 | 28466906 | PRJNA515078_P_NODE_18026_length_205_cov_1.392857_g17793_i0 | PRJNA515078 | 18026 | 205 | 1.392857 | 2.85535685 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 70.5 | 3.77e-12 | NR | RYD77031.1 | 2026800 | g17793 | i0 | 76.7 | 1.85853658536585 | 43 | 10 | 62.9 | 0 | 133 | 5 | 253 | 295 | RYD77031.1 MAG: hypothetical protein EOP84_16100, partial [Verrucomicrobiaceae bacterium] | diamond | 381 | 70.5 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 28782345 | 28782345 | PRJNA515078_P_NODE_34067_length_151_cov_1.087719_g33834_i0 | PRJNA515078 | 34067 | 151 | 1.087719 | 1.64245569 | Prosthecobacter sp. | 1965333 | Bacteria | Bacteria | 50.1 | 2.67e-5 | NR | WP_294231434.1 | 1965333 | g33834 | i0 | 58.7 | 0.913907284768212 | 46 | 19 | 91.4 | 0 | 149 | 12 | 2103 | 2148 | WP_294231434.1 Calx-beta domain-containing protein [Prosthecobacter sp.] | diamond | 138 | 50.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Prosthecobacter | Prosthecobacter sp. | |
| 28908501 | 28908501 | PRJNA515078_P_NODE_18528_length_202_cov_0.945455_g18295_i0 | PRJNA515078 | 18528 | 202 | 0.945455 | 1.9098191 | Akkermansiaceae bacterium | 2562705 | Bacteria | Bacteria | 54.3 | 1.84e-6 | NR | MFT6181639.1 | 2562705 | g18295 | i0 | 39.3 | 1.66336633663366 | 56 | 34 | 83.2 | 0 | 34 | 201 | 178 | 233 | MFT6181639.1 serine/threonine protein kinase [Akkermansiaceae bacterium] | diamond | 336 | 54.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Akkermansiaceae | Akkermansiaceae bacterium | ||
| 29839832 | 29839832 | PRJNA515078_P_NODE_34291_length_150_cov_2.070796_g34058_i0 | PRJNA515078 | 34291 | 150 | 2.070796 | 3.106194 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 73.9 | 1.01e-13 | NR | MBL63421.1 | 2026771 | g34058 | i0 | 78 | 4.42 | 41 | 9 | 82 | 0 | 125 | 3 | 2072 | 2112 | MBL63421.1 hypothetical protein [Opitutia bacterium] | diamond | 663 | 74.3 | 0.994616419919246 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutia bacterium | ||||
| 31309445 | 31309445 | PRJNA515078_P_NODE_735_length_1107_cov_2.287850_g636_i0 | PRJNA515078 | 735 | 1107 | 2.28785 | 25.3264995 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 401 | 3.6e-136 | NR | RYD65414.1 | 2026800 | g636 | i0 | 70.9 | 0.764227642276423 | 282 | 79 | 76.2 | 2 | 223 | 1065 | 56 | 335 | RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium] | diamond | 846 | 401 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 31562787 | 31562787 | PRJNA515078_P_NODE_27836_length_165_cov_1.218750_g27603_i0 | PRJNA515078 | 27836 | 165 | 1.21875 | 2.0109375 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 97.1 | 4.11e-24 | NR | RYD67074.1 | 2026800 | g27603 | i0 | 88.7 | 0.963636363636364 | 53 | 5 | 94.5 | 1 | 3 | 158 | 32 | 84 | RYD67074.1 MAG: J domain-containing protein, partial [Verrucomicrobiaceae bacterium] | diamond | 159 | 97.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 31941934 | 31941934 | PRJNA515078_P_NODE_12297_length_254_cov_1.023041_g12064_i0 | PRJNA515078 | 12297 | 254 | 1.023041 | 2.59852414 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 132 | 1.71e-37 | NR | RYD73503.1 | 2026800 | g12064 | i0 | 82.1 | 0.992125984251969 | 84 | 15 | 99.2 | 0 | 252 | 1 | 64 | 147 | RYD73503.1 MAG: fructose-bisphosphate aldolase class I, partial [Verrucomicrobiaceae bacterium] | diamond | 252 | 132 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 32132152 | 32132152 | PRJNA515078_P_NODE_23798_length_178_cov_1.106383_g23565_i0 | PRJNA515078 | 23798 | 178 | 1.106383 | 1.96936174 | Opitutia bacterium | 2026771 | Bacteria | Bacteria | 45.4 | 0.00176 | NR | HAD21876.1 | 2026771 | g23565 | i0 | 55.9 | 0.573033707865168 | 34 | 15 | 57.3 | 0 | 5 | 106 | 310 | 343 | HAD21876.1 hypothetical protein [Opitutia bacterium] | diamond | 102 | 45.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutia bacterium | ||||
| 32369102 | 32369102 | PRJNA515078_P_NODE_32139_length_155_cov_1.177966_g31906_i0 | PRJNA515078 | 32139 | 155 | 1.177966 | 1.8258473 | Opitutia | 414999 | Bacteria | Bacteria | 54.7 | 6.78e-7 | NR | WP_068773056.1 | 1184151 | g31906 | i0 | 49 | 8.67096774193548 | 51 | 26 | 98.7 | 0 | 3 | 155 | 113 | 163 | WP_068773056.1 insulinase family protein [Termitidicoccus mucosus] | diamond | 1344 | 55.1 | 0.992740471869329 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Opitutales | Opitutaceae | Termitidicoccus | Termitidicoccus mucosus |
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);;