contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA688931" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8321608 | 8321608 | PRJNA688931_P_NODE_23967_length_209_cov_1.281250_g23754_i0 | PRJNA688931 | 23967 | 209 | 1.28125 | 2.6778125 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 100 | 5.85e-23 | NR | MBP7949858.1 | 2026801 | g23754 | i0 | 77.3 | 3.88995215311005 | 66 | 15 | 94.7 | 0 | 209 | 12 | 308 | 373 | MBP7949858.1 ADP-forming succinate--CoA ligase subunit beta [Verrucomicrobiales bacterium] | diamond | 813 | 100 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales bacterium | |||
| 26607304 | 26607304 | PRJNA688931_P_NODE_301_length_1602_cov_3.237605_g264_i0 | PRJNA688931 | 301 | 1602 | 3.237605 | 51.8664321 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 82.8 | 1.34e-12 | NR | HYG84357.1 | 2499141 | g264 | i0 | 22.8 | 0.779026217228464 | 416 | 257 | 76.4 | 7 | 1601 | 378 | 134 | 493 | HYG84357.1 hypothetical protein [Verrucomicrobiia bacterium] | diamond | 1248 | 82.8 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 26924165 | 26924165 | PRJNA688931_P_NODE_37442_length_167_cov_0.872881_g37229_i0 | PRJNA688931 | 37442 | 167 | 0.872881 | 1.45771127 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 57.4 | 6.21e-8 | NR | MBI4661017.1 | 2026799 | g37229 | i0 | 51 | 0.916167664670659 | 51 | 25 | 91.6 | 0 | 162 | 10 | 69 | 119 | MBI4661017.1 WD40 repeat domain-containing protein [Verrucomicrobiota bacterium] | diamond | 153 | 57.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 27082320 | 27082320 | PRJNA688931_P_NODE_31342_length_181_cov_1.098485_g31129_i0 | PRJNA688931 | 31342 | 181 | 1.098485 | 1.98825785 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 60.1 | 1.19e-8 | NR | HYG84357.1 | 2499141 | g31129 | i0 | 49 | 0.812154696132597 | 49 | 25 | 81.2 | 0 | 15 | 161 | 104 | 152 | HYG84357.1 hypothetical protein [Verrucomicrobiia bacterium] | diamond | 147 | 60.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 27555997 | 27555997 | PRJNA688931_P_NODE_2024_length_796_cov_1.808568_g1867_i0 | PRJNA688931 | 2024 | 796 | 1.808568 | 14.39620128 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 163 | 2.73e-45 | NR | MDH7502297.1 | 2026799 | g1867 | i0 | 36.7 | 0.810301507537688 | 215 | 136 | 81 | 0 | 768 | 124 | 26 | 240 | MDH7502297.1 slipin family protein [Verrucomicrobiota bacterium] | diamond | 645 | 163 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 27777393 | 27777393 | PRJNA688931_P_NODE_14344_length_273_cov_1.446429_g14131_i0 | PRJNA688931 | 14344 | 273 | 1.446429 | 3.94875117 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 45.8 | 0.00444 | NR | HEY4416735.1 | 2499141 | g14131 | i0 | 25.8 | 1.86813186813187 | 89 | 55 | 85.7 | 1 | 268 | 35 | 388 | 476 | HEY4416735.1 protein kinase [Verrucomicrobiia bacterium] | diamond | 510 | 45.8 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 27777422 | 27777422 | PRJNA688931_P_NODE_33144_length_175_cov_1.230159_g32931_i0 | PRJNA688931 | 33144 | 175 | 1.230159 | 2.15277825 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 53.9 | 1.73e-6 | NR | PYK99157.1 | 2026799 | g32931 | i0 | 51.9 | 6.32571428571429 | 54 | 24 | 89.1 | 2 | 174 | 19 | 230 | 283 | PYK99157.1 MAG: hypothetical protein DME19_09690, partial [Verrucomicrobiota bacterium] | diamond | 1107 | 53.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 27809067 | 27809067 | PRJNA688931_P_NODE_704_length_1253_cov_3.393688_g630_i0 | PRJNA688931 | 704 | 1253 | 3.393688 | 42.52291064 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 237 | 2.4699999999999998e-68 | NR | HYG84357.1 | 2499141 | g630 | i0 | 42.2 | 0.895450917797286 | 374 | 191 | 84.3 | 7 | 1066 | 11 | 19 | 389 | HYG84357.1 hypothetical protein [Verrucomicrobiia bacterium] | diamond | 1122 | 237 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 27840229 | 27840229 | PRJNA688931_P_NODE_9564_length_343_cov_2.244898_g9351_i0 | PRJNA688931 | 9564 | 343 | 2.244898 | 7.70000014 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 54.3 | 9.9e-6 | NR | HYG84357.1 | 2499141 | g9351 | i0 | 37.5 | 1.39941690962099 | 80 | 48 | 68.2 | 1 | 3 | 236 | 445 | 524 | HYG84357.1 hypothetical protein [Verrucomicrobiia bacterium] | diamond | 480 | 54.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 27998454 | 27998454 | PRJNA688931_P_NODE_28885_length_189_cov_1.471429_g28672_i0 | PRJNA688931 | 28885 | 189 | 1.471429 | 2.78100081 | Roseibacillus sp. | 2024856 | Bacteria | Bacteria | 40.4 | 0.0209 | NR | MFP6880074.1 | 2024856 | g28672 | i0 | 45.7 | 0.73015873015873 | 46 | 18 | 61.9 | 1 | 181 | 65 | 22 | 67 | MFP6880074.1 hypothetical protein [Roseibacillus sp.] | diamond | 138 | 40.4 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Roseibacillus | Roseibacillus sp. | |
| 28566563 | 28566563 | PRJNA688931_P_NODE_39887_length_165_cov_0.887931_g39674_i0 | PRJNA688931 | 39887 | 165 | 0.887931 | 1.46508615 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 39.3 | 0.0241 | NR | MEY2787959.1 | 2026799 | g39674 | i0 | 77.3 | 0.4 | 22 | 5 | 40 | 0 | 100 | 165 | 4 | 25 | MEY2787959.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 66 | 39.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 29639833 | 29639833 | PRJNA688931_P_NODE_41250_length_164_cov_0.886957_g41037_i0 | PRJNA688931 | 41250 | 164 | 0.886957 | 1.45460948 | Verrucomicrobiales bacterium | 2026801 | Bacteria | Bacteria | 60.8 | 5.13e-9 | NR | MDF1738566.1 | 2026801 | g41037 | i0 | 90 | 0.548780487804878 | 30 | 3 | 54.9 | 0 | 1 | 90 | 109 | 138 | MDF1738566.1 sulfatase-like hydrolase/transferase [Verrucomicrobiales bacterium] | diamond | 90 | 60.8 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales bacterium | |||
| 29671346 | 29671346 | PRJNA688931_P_NODE_36070_length_168_cov_0.873950_g35857_i0 | PRJNA688931 | 36070 | 168 | 0.87395 | 1.468236 | Chthoniobacterales bacterium | 2201154 | Bacteria | Bacteria | 87 | 4.37e-19 | NR | MEO6871375.1 | 2201154 | g35857 | i0 | 70.9 | 6.875 | 55 | 16 | 98.2 | 0 | 3 | 167 | 37 | 91 | MEO6871375.1 UvrB/UvrC motif-containing protein [Chthoniobacterales bacterium] | diamond | 1155 | 87 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacterales bacterium | |||
| 29702887 | 29702887 | PRJNA688931_P_NODE_40470_length_164_cov_1.339130_g40257_i0 | PRJNA688931 | 40470 | 164 | 1.33913 | 2.1961732 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 43.9 | 0.00502 | NR | HYG84357.1 | 2499141 | g40257 | i0 | 42.6 | 0.98780487804878 | 54 | 29 | 98.8 | 1 | 2 | 163 | 132 | 183 | HYG84357.1 hypothetical protein [Verrucomicrobiia bacterium] | diamond | 162 | 43.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 29892970 | 29892970 | PRJNA688931_P_NODE_38351_length_166_cov_0.888889_g38138_i0 | PRJNA688931 | 38351 | 166 | 0.888889 | 1.47555574 | Luteolibacter ambystomatis | 2824561 | Bacteria | Bacteria | 60.1 | 4.12e-9 | NR | WP_211629621.1 | 2824561 | g38138 | i0 | 47.4 | 3.19879518072289 | 57 | 23 | 90.4 | 1 | 14 | 163 | 122 | 178 | WP_211629621.1 metallophosphoesterase family protein [Luteolibacter ambystomatis] | diamond | 531 | 60.1 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Luteolibacter | Luteolibacter ambystomatis | |
| 30177005 | 30177005 | PRJNA688931_P_NODE_38732_length_166_cov_0.880342_g38519_i0 | PRJNA688931 | 38732 | 166 | 0.880342 | 1.46136772 | Verrucomicrobiales bacterium | 2026801 | Bacteria | Bacteria | 54.3 | 1.1e-6 | NR | MBP7948256.1 | 2026801 | g38519 | i0 | 50.9 | 0.957831325301205 | 53 | 26 | 95.8 | 0 | 165 | 7 | 162 | 214 | MBP7948256.1 carboxypeptidase regulatory-like domain-containing protein [Verrucomicrobiales bacterium] | diamond | 159 | 54.3 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiales bacterium | |||
| 31251313 | 31251313 | PRJNA688931_P_NODE_32375_length_177_cov_1.617188_g32162_i0 | PRJNA688931 | 32375 | 177 | 1.617188 | 2.86242276 | Chthoniobacteraceae bacterium | 2811408 | Bacteria | Bacteria | 75.9 | 3.07e-14 | NR | HEV7868859.1 | 2811408 | g32162 | i0 | 66 | 2.66101694915254 | 53 | 18 | 89.8 | 0 | 177 | 19 | 286 | 338 | HEV7868859.1 N-acetylmuramoyl-L-alanine amidase [Chthoniobacteraceae bacterium] | diamond | 471 | 75.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Spartobacteria | Chthoniobacterales | Chthoniobacteraceae | Chthoniobacteraceae bacterium | ||
| 31536267 | 31536267 | PRJNA688931_P_NODE_38636_length_166_cov_0.880342_g38423_i0 | PRJNA688931 | 38636 | 166 | 0.880342 | 1.46136772 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 68.9 | 7.59e-12 | NR | MDQ6654375.1 | 2026799 | g38423 | i0 | 57.4 | 0.975903614457831 | 54 | 23 | 97.6 | 0 | 166 | 5 | 83 | 136 | MDQ6654375.1 hypothetical protein [Verrucomicrobiota bacterium] | diamond | 162 | 68.9 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 31599471 | 31599471 | PRJNA688931_P_NODE_36276_length_168_cov_0.865546_g36063_i0 | PRJNA688931 | 36276 | 168 | 0.865546 | 1.45411728 | Verrucomicrobiia bacterium | 2499141 | Bacteria | Bacteria | 56.6 | 1.68e-7 | NR | HYG84357.1 | 2499141 | g36063 | i0 | 64.9 | 0.660714285714286 | 37 | 13 | 66.1 | 0 | 56 | 166 | 219 | 255 | HYG84357.1 hypothetical protein [Verrucomicrobiia bacterium] | diamond | 111 | 56.6 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiia bacterium | ||||
| 31630879 | 31630879 | PRJNA688931_P_NODE_42736_length_163_cov_0.877193_g42523_i0 | PRJNA688931 | 42736 | 163 | 0.877193 | 1.42982459 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 59.7 | 1.26e-8 | NR | MEI8341392.1 | 2026799 | g42523 | i0 | 54.7 | 0.975460122699387 | 53 | 24 | 97.5 | 0 | 161 | 3 | 360 | 412 | MEI8341392.1 cellulase family glycosylhydrolase [Verrucomicrobiota bacterium] | diamond | 159 | 59.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 31725712 | 31725712 | PRJNA688931_P_NODE_16397_length_254_cov_1.175610_g16184_i0 | PRJNA688931 | 16397 | 254 | 1.17561 | 2.9860494 | Verrucomicrobiaceae bacterium | 2026800 | Bacteria | Bacteria | 71.2 | 3.81e-12 | NR | MFO1486663.1 | 2026800 | g16184 | i0 | 53 | 1.55905511811024 | 66 | 28 | 78 | 1 | 249 | 52 | 437 | 499 | MFO1486663.1 SIS domain-containing protein [Verrucomicrobiaceae bacterium] | diamond | 396 | 71.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiia | Verrucomicrobiales | Verrucomicrobiaceae | Verrucomicrobiaceae bacterium | ||
| 31915569 | 31915569 | PRJNA688931_P_NODE_17237_length_247_cov_1.797980_g17024_i0 | PRJNA688931 | 17237 | 247 | 1.79798 | 4.4410106 | Verrucomicrobiota bacterium | 2026799 | Bacteria | Bacteria | 44.7 | 0.00801 | NR | MEI6588542.1 | 2026799 | g17024 | i0 | 29.2 | 0.874493927125506 | 72 | 49 | 87.4 | 1 | 233 | 18 | 558 | 627 | MEI6588542.1 SulP family inorganic anion transporter [Verrucomicrobiota bacterium] | diamond | 216 | 44.7 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Verrucomicrobiota bacterium | |||||
| 32863364 | 32863364 | PRJNA688931_P_NODE_23300_length_212_cov_1.263804_g23087_i0 | PRJNA688931 | 23300 | 212 | 1.263804 | 2.67926448 | Puniceicoccales bacterium | 2478473 | Bacteria | Bacteria | 46.2 | 0.00149 | NR | MDR2377529.1 | 2478473 | g23087 | i0 | 46.7 | 1.2877358490566 | 45 | 24 | 63.7 | 0 | 76 | 210 | 202 | 246 | MDR2377529.1 LPS-assembly protein LptD [Puniceicoccales bacterium] | diamond | 273 | 46.2 | 1 | Bacteria | PVC group | Pseudomonadati | Verrucomicrobiota | Opitutia | Puniceicoccales | Puniceicoccales 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);;