contig_metadata
28 rows where analysis = "diamond", bioproject = "PRJNA763243" and tax_phylum = "Myxococcota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4571782 | 4571782 | PRJNA763243_P_NODE_45864_length_263_cov_1.436842_g45518_i0 | PRJNA763243 | 45864 | 263 | 1.436842 | 3.77889446 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 98.6 | 9.02e-22 | NR | MDA8307955.1 | 2026735 | g45518 | i0 | 62.2 | 4.02661596958175 | 90 | 30 | 98.1 | 3 | 261 | 4 | 79 | 168 | MDA8307955.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 1059 | 98.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 8396708 | 8396708 | PRJNA763243_P_NODE_48107_length_258_cov_2.037838_g47761_i0 | PRJNA763243 | 48107 | 258 | 2.037838 | 5.25762204 | Archangiaceae bacterium | 2684409 | Bacteria | Bacteria | 161 | 1.48e-47 | NR | MBM4780508.1 | 2684409 | g47761 | i0 | 98.8 | 0.965116279069767 | 83 | 1 | 96.5 | 0 | 252 | 4 | 134 | 216 | MBM4780508.1 23S rRNA (guanosine(2251)-2'-O)-methyltransferase RlmB [Archangiaceae bacterium] | diamond | 249 | 161 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangiaceae bacterium | |||
| 14772270 | 14772270 | PRJNA763243_P_NODE_43132_length_269_cov_2.806122_g42786_i0 | PRJNA763243 | 43132 | 269 | 2.806122 | 7.54846818 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 129 | 1.66e-32 | NR | HEY1097601.1 | 2818507 | g42786 | i0 | 73.6 | 0.970260223048327 | 87 | 22 | 97 | 1 | 263 | 3 | 493 | 578 | HEY1097601.1 hypothetical protein [Myxococcota bacterium] | diamond | 261 | 129 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 21145416 | 21145416 | PRJNA763243_P_NODE_21397_length_344_cov_2.394834_g21051_i0 | PRJNA763243 | 21397 | 344 | 2.394834 | 8.23822896 | Myxococcaceae bacterium | 2484252 | Bacteria | Bacteria | 207 | 1.35e-63 | NR | RYZ13579.1 | 2484252 | g21051 | i0 | 92 | 0.976744186046512 | 112 | 9 | 97.7 | 0 | 339 | 4 | 158 | 269 | RYZ13579.1 MAG: ABC-F family ATP-binding cassette domain-containing protein, partial [Myxococcaceae bacterium] | diamond | 336 | 207 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcaceae bacterium | |||
| 26926599 | 26926599 | PRJNA763243_P_NODE_29282_length_310_cov_3.721519_g28936_i0 | PRJNA763243 | 29282 | 310 | 3.721519 | 11.5367089 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 65.5 | 5.78e-10 | NR | MEO8552225.1 | 2212474 | g28936 | i0 | 68.6 | 0.493548387096774 | 51 | 15 | 48.4 | 1 | 150 | 1 | 8 | 58 | MEO8552225.1 tetratricopeptide repeat protein [Kofleriaceae bacterium] | diamond | 153 | 65.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 26958054 | 26958054 | PRJNA763243_P_NODE_43922_length_267_cov_3.273196_g43576_i0 | PRJNA763243 | 43922 | 267 | 3.273196 | 8.73943332 | Archangium sp. | 1872627 | Bacteria | Bacteria | 56.6 | 1.22e-7 | NR | HEY0883035.1 | 1872627 | g43576 | i0 | 41 | 1.73033707865169 | 78 | 45 | 86.5 | 1 | 232 | 2 | 45 | 122 | HEY0883035.1 hypothetical protein [Archangium sp.] | diamond | 462 | 56.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium sp. | ||
| 27125618 | 27125618 | PRJNA763243_P_NODE_35002_length_290_cov_8.894009_g34656_i0 | PRJNA763243 | 35002 | 290 | 8.894009 | 25.7926261 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 160 | 1.4899999999999999e-46 | NR | HYG67028.1 | 2510643 | g34656 | i0 | 81.1 | 1.96551724137931 | 95 | 18 | 98.3 | 0 | 4 | 288 | 123 | 217 | HYG67028.1 hypothetical protein [Anaeromyxobacteraceae bacterium] | diamond | 570 | 160 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Anaeromyxobacteraceae | Anaeromyxobacteraceae bacterium | |||
| 27464096 | 27464096 | PRJNA763243_P_NODE_15423_length_393_cov_1.512500_g15078_i0 | PRJNA763243 | 15423 | 393 | 1.5125 | 5.944125 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 46.2 | 0.0119 | NR | MBI2390531.1 | 2026735 | g15078 | i0 | 34.3 | 0.801526717557252 | 105 | 61 | 80.2 | 3 | 335 | 21 | 704 | 800 | MBI2390531.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 315 | 46.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 28032471 | 28032471 | PRJNA763243_P_NODE_71045_length_215_cov_9.725352_g70699_i0 | PRJNA763243 | 71045 | 215 | 9.7253520000000009 | 20.9095068 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 81.6 | 4.72e-16 | NR | HUJ57206.1 | 2212474 | g70699 | i0 | 55.7 | 3.90697674418605 | 70 | 30 | 97.7 | 1 | 5 | 214 | 290 | 358 | HUJ57206.1 M20 family metallopeptidase [Kofleriaceae bacterium] | diamond | 840 | 81.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 28221604 | 28221604 | PRJNA763243_P_NODE_75226_length_197_cov_6.451613_g74880_i0 | PRJNA763243 | 75226 | 197 | 6.451613 | 12.70967761 | Nannocystis pusilla | 889268 | Bacteria | Bacteria | 111 | 1.17e-28 | NR | WP_224189980.1 | 889268 | g74880 | i0 | 98.1 | 0.822335025380711 | 54 | 1 | 82.2 | 0 | 6 | 167 | 161 | 214 | WP_224189980.1 hypothetical protein [Nannocystis pusilla] | diamond | 162 | 111 | 1 | Bacteria | Pseudomonadati | Myxococcota | Nannocystales | Nannocystaceae | Nannocystis | Nannocystis pusilla | |||
| 28736608 | 28736608 | PRJNA763243_P_NODE_71747_length_212_cov_5.316547_g71401_i0 | PRJNA763243 | 71747 | 212 | 5.316547 | 11.27107964 | Bacteria | 2 | Bacteria | Bacteria | 90.9 | 2.76e-19 | NR | MBV8758391.1 | 2026735 | g71401 | i0 | 72.6 | 5.23584905660377 | 62 | 16 | 87.7 | 1 | 14 | 199 | 715 | 775 | MBV8758391.1 GcvT family protein [Deltaproteobacteria bacterium] | diamond | 1110 | 90.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 28789984 | 28789984 | PRJNA763243_P_NODE_65927_length_235_cov_2.635802_g65581_i0 | PRJNA763243 | 65927 | 235 | 2.635802 | 6.1941347 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 122 | 4.92e-31 | NR | MBL9113141.1 | 2026763 | g65581 | i0 | 80.5 | 0.982978723404255 | 77 | 15 | 98.3 | 0 | 3 | 233 | 156 | 232 | MBL9113141.1 MFS transporter [Myxococcales bacterium] | diamond | 231 | 122 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 28989434 | 28989434 | PRJNA763243_P_NODE_10268_length_469_cov_2.005051_g9925_i0 | PRJNA763243 | 10268 | 469 | 2.005051 | 9.40368919 | root | 1 | Root_unresolved | Root_unresolved | 65.5 | 3.36e-9 | NR | MCA9601124.1 | 2026763 | g9925 | i0 | 33.6 | 4.07462686567164 | 113 | 74 | 71.6 | 1 | 459 | 124 | 211 | 323 | MCA9601124.1 hypothetical protein [Myxococcales bacterium] | diamond | 1911 | 65.9 | 0.993930197268589 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 29021076 | 29021076 | PRJNA763243_P_NODE_22368_length_338_cov_5.222642_g22022_i0 | PRJNA763243 | 22368 | 338 | 5.222642 | 17.65252996 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 57 | 7.79e-7 | NR | MFT3769745.1 | 1971901 | g22022 | i0 | 45.9 | 1.08284023668639 | 61 | 31 | 52.4 | 1 | 179 | 3 | 4 | 64 | MFT3769745.1 hypothetical protein [Minicystis sp.] | diamond | 366 | 57 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Minicystis | Minicystis sp. | |||
| 29169140 | 29169140 | PRJNA763243_P_NODE_70629_length_217_cov_10.208333_g70283_i0 | PRJNA763243 | 70629 | 217 | 10.208333 | 22.15208261 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 45.1 | 0.00417 | NR | NUN14370.1 | 2026763 | g70283 | i0 | 44.2 | 0.71889400921659 | 52 | 26 | 67.7 | 1 | 32 | 178 | 135 | 186 | NUN14370.1 hypothetical protein [Myxococcales bacterium] | diamond | 156 | 45.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 29705282 | 29705282 | PRJNA763243_P_NODE_19490_length_357_cov_2.630282_g19144_i0 | PRJNA763243 | 19490 | 357 | 2.630282 | 9.39010674 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 90.5 | 9.47e-21 | NR | MCA9640749.1 | 2026763 | g19144 | i0 | 81 | 0.974789915966387 | 58 | 11 | 48.7 | 0 | 353 | 180 | 55 | 112 | MCA9640749.1 hypothetical protein [Myxococcales bacterium] | diamond | 348 | 90.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 29990001 | 29990001 | PRJNA763243_P_NODE_27471_length_311_cov_61.613445_g27125_i0 | PRJNA763243 | 27471 | 311 | 61.613445 | 191.61781395 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 96.3 | 2.3400000000000003e-21 | NR | MEM9459905.1 | 2818507 | g27125 | i0 | 87.8 | 0.472668810289389 | 49 | 6 | 47.3 | 0 | 311 | 165 | 234 | 282 | MEM9459905.1 SCO family protein [Myxococcota bacterium] | diamond | 147 | 96.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 30053035 | 30053035 | PRJNA763243_P_NODE_48811_length_257_cov_1.027174_g48465_i0 | PRJNA763243 | 48811 | 257 | 1.027174 | 2.63983718 | Polyangiales bacterium | 3034171 | Bacteria | Bacteria | 53.1 | 7.82e-6 | NR | HET8933269.1 | 3034171 | g48465 | i0 | 33.3 | 0.980544747081712 | 84 | 53 | 96.9 | 2 | 9 | 257 | 180 | 261 | HET8933269.1 fibrinogen-like YCDxxxxGGGW domain-containing protein [Polyangiales bacterium] | diamond | 252 | 53.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiales bacterium | |||||
| 30179409 | 30179409 | PRJNA763243_P_NODE_43672_length_268_cov_1.487179_g43326_i0 | PRJNA763243 | 43672 | 268 | 1.487179 | 3.98563972 | Labilithrix sp. | 1971228 | Bacteria | Bacteria | 47 | 0.00157 | NR | MFO0738222.1 | 1971228 | g43326 | i0 | 38.4 | 0.962686567164179 | 86 | 46 | 96.3 | 3 | 3 | 260 | 329 | 407 | MFO0738222.1 thrombospondin type-1 domain-containing protein [Labilithrix sp.] | diamond | 258 | 47 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix sp. | |||
| 30338008 | 30338008 | PRJNA763243_P_NODE_70632_length_217_cov_9.854167_g70286_i0 | PRJNA763243 | 70632 | 217 | 9.854167 | 21.38354239 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 43.5 | 0.0115 | NR | MCB9529711.1 | 2026763 | g70286 | i0 | 43.9 | 0.566820276497696 | 41 | 20 | 56.7 | 1 | 172 | 50 | 166 | 203 | MCB9529711.1 hypothetical protein [Myxococcales bacterium] | diamond | 123 | 43.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 30432699 | 30432699 | PRJNA763243_P_NODE_67693_length_229_cov_5.301282_g67347_i0 | PRJNA763243 | 67693 | 229 | 5.301282 | 12.13993578 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 43.9 | 0.00611 | NR | HTR52097.1 | 2212474 | g67347 | i0 | 61.3 | 0.406113537117904 | 31 | 12 | 40.6 | 0 | 122 | 30 | 39 | 69 | HTR52097.1 hypothetical protein [Kofleriaceae bacterium] | diamond | 93 | 43.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 30906449 | 30906449 | PRJNA763243_P_NODE_64774_length_238_cov_51.945455_g64428_i0 | PRJNA763243 | 64774 | 238 | 51.945455 | 123.6301829 | Myxococcaceae bacterium | 2484252 | Bacteria | Bacteria | 49.7 | 1.21e-4 | NR | MDB5217168.1 | 2484252 | g64428 | i0 | 45.5 | 0.970588235294118 | 77 | 38 | 97.1 | 1 | 3 | 233 | 99 | 171 | MDB5217168.1 Mechanosensitive ion channel family protein [Myxococcaceae bacterium] | diamond | 231 | 49.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcaceae bacterium | |||
| 31221975 | 31221975 | PRJNA763243_P_NODE_41335_length_273_cov_7.045000_g40989_i0 | PRJNA763243 | 41335 | 273 | 7.045 | 19.23285 | Hyalangium rubrum | 3103134 | Bacteria | Bacteria | 75.5 | 1.47e-13 | NR | WP_321544410.1 | 3103134 | g40989 | i0 | 59.1 | 0.725274725274725 | 66 | 27 | 72.5 | 0 | 67 | 264 | 344 | 409 | WP_321544410.1 aldo/keto reductase [Hyalangium rubrum] | diamond | 198 | 75.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Hyalangium | Hyalangium rubrum | ||
| 31664893 | 31664893 | PRJNA763243_P_NODE_29497_length_310_cov_3.033755_g29151_i0 | PRJNA763243 | 29497 | 310 | 3.033755 | 9.4046405 | Aetherobacter fasciculatus | 888830 | Bacteria | Bacteria | 45.1 | 0.0122 | NR | WP_346378682.1 | 888830 | g29151 | i0 | 34.3 | 0.648387096774194 | 67 | 42 | 64.8 | 1 | 103 | 303 | 74 | 138 | WP_346378682.1 protein kinase domain-containing protein [Aetherobacter fasciculatus] | diamond | 201 | 45.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Aetherobacter | Aetherobacter fasciculatus | |||
| 31886390 | 31886390 | PRJNA763243_P_NODE_58277_length_245_cov_1.662791_g57931_i0 | PRJNA763243 | 58277 | 245 | 1.662791 | 4.07383795 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 117 | 9.8e-30 | NR | MBK6462578.1 | 2026763 | g57931 | i0 | 70 | 0.979591836734694 | 80 | 24 | 98 | 0 | 241 | 2 | 144 | 223 | MBK6462578.1 hypothetical protein [Myxococcales bacterium] | diamond | 240 | 117 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 32171413 | 32171413 | PRJNA763243_P_NODE_37818_length_282_cov_6.976077_g37472_i0 | PRJNA763243 | 37818 | 282 | 6.976077 | 19.67253714 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 75.5 | 1.82e-13 | NR | HEY1100393.1 | 2818507 | g37472 | i0 | 44.9 | 0.946808510638298 | 89 | 48 | 94.7 | 1 | 278 | 12 | 732 | 819 | HEY1100393.1 hypothetical protein [Myxococcota bacterium] | diamond | 267 | 75.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 32370900 | 32370900 | PRJNA763243_P_NODE_50939_length_252_cov_5.519553_g50593_i0 | PRJNA763243 | 50939 | 252 | 5.519553 | 13.90927356 | root | 1 | Root_unresolved | Root_unresolved | 116 | 9.04e-29 | NR | WP_011421417.1 | 161493 | g50593 | i0 | 63 | 2.89285714285714 | 81 | 30 | 96.4 | 0 | 248 | 6 | 138 | 218 | WP_011421417.1 acetyl-CoA C-acetyltransferase [Anaeromyxobacter dehalogenans] | diamond | 729 | 116 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Anaeromyxobacteraceae | Anaeromyxobacter | Anaeromyxobacter dehalogenans | ||
| 32465828 | 32465828 | PRJNA763243_P_NODE_46959_length_260_cov_10.684492_g46613_i0 | PRJNA763243 | 46959 | 260 | 10.684492 | 27.7796792 | Polyangium | 55 | Bacteria | Bacteria | 74.3 | 2.75e-13 | NR | HRG95686.1 | 2268199 | g46613 | i0 | 51.3 | 2.76923076923077 | 76 | 36 | 87.7 | 1 | 28 | 255 | 68 | 142 | HRG95686.1 peroxiredoxin family protein [Polyangiaceae bacterium] | diamond | 720 | 74.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae 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);;