contig_metadata
26 rows where bioproject = "PRJNA235310", tax_phylum = "Myxococcota" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9295433 | 9295433 | PRJNA235310_P_NODE_3228_length_211_cov_1.283951_g3202_i0 | PRJNA235310 | 3228 | 211 | 1.283951 | 2.70913661 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 101 | 4.7e-24 | NR | HEX2876345.1 | 2268199 | g3202 | i0 | 67.1 | 3.98104265402844 | 70 | 23 | 99.5 | 0 | 1 | 210 | 89 | 158 | HEX2876345.1 dienelactone hydrolase family protein [Polyangiaceae bacterium] | diamond | 840 | 102 | 0.990196078431373 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 19493283 | 19493283 | PRJNA235310_P_NODE_1336_length_349_cov_1.636667_g1310_i0 | PRJNA235310 | 1336 | 349 | 1.636667 | 5.71196783 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 188 | 5.08e-56 | NR | MED5372591.1 | 2818507 | g1310 | i0 | 82.9 | 7.62464183381089 | 111 | 19 | 95.4 | 0 | 3 | 335 | 282 | 392 | MED5372591.1 thiolase family protein [Myxococcota bacterium] | diamond | 2661 | 188 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 23319466 | 23319466 | PRJNA235310_P_NODE_879_length_424_cov_0.968000_g853_i0 | PRJNA235310 | 879 | 424 | 0.968 | 4.10432 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 178 | 1.97e-50 | NR | MFT6144364.1 | 2818507 | g853 | i0 | 63.1 | 14.561320754717 | 141 | 52 | 99.8 | 0 | 424 | 2 | 344 | 484 | MFT6144364.1 4-coumarate--CoA ligase [Myxococcota bacterium] | diamond | 6174 | 178 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 26630858 | 26630858 | PRJNA235310_P_NODE_3781_length_194_cov_1.434483_g3755_i0 | PRJNA235310 | 3781 | 194 | 1.434483 | 2.78289702 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 60.1 | 1.51e-8 | NR | MDP7040769.1 | 2818507 | g3755 | i0 | 64.3 | 0.649484536082474 | 42 | 14 | 64.9 | 1 | 163 | 38 | 1484 | 1524 | MDP7040769.1 hypothetical protein [Myxococcota bacterium] | diamond | 126 | 60.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 27232005 | 27232005 | PRJNA235310_P_NODE_3_length_2445_cov_4.610184_g2_i0 | PRJNA235310 | 3 | 2445 | 4.610184 | 112.7189988 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 121 | 5.39e-25 | NR | HTV24288.1 | 2268199 | g2 | i0 | 42.1 | 0.311656441717791 | 254 | 122 | 29 | 11 | 1956 | 1249 | 160 | 406 | HTV24288.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 762 | 121 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 28716261 | 28716261 | PRJNA235310_P_NODE_3627_length_198_cov_1.395973_g3601_i0 | PRJNA235310 | 3627 | 198 | 1.395973 | 2.76402654 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 51.2 | 2e-5 | NR | HWO23783.1 | 2212474 | g3601 | i0 | 47.8 | 0.696969696969697 | 46 | 24 | 69.7 | 0 | 182 | 45 | 211 | 256 | HWO23783.1 plastocyanin/azurin family copper-binding protein [Kofleriaceae bacterium] | diamond | 138 | 51.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 28796881 | 28796881 | PRJNA235310_P_NODE_5227_length_167_cov_1.762712_g5201_i0 | PRJNA235310 | 5227 | 167 | 1.762712 | 2.94372904 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 82.4 | 1.04e-16 | NR | MBM4362244.1 | 2026735 | g5201 | i0 | 65.5 | 3.89820359281437 | 55 | 19 | 98.8 | 0 | 167 | 3 | 272 | 326 | MBM4362244.1 lipid-transfer protein [Deltaproteobacteria bacterium] | diamond | 651 | 83.2 | 0.990384615384615 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 28842321 | 28842321 | PRJNA235310_P_NODE_3528_length_201_cov_1.026316_g3502_i0 | PRJNA235310 | 3528 | 201 | 1.026316 | 2.06289516 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 42 | 0.0401 | NR | MEZ4265313.1 | 2818507 | g3502 | i0 | 44.9 | 0.73134328358209 | 49 | 26 | 73.1 | 1 | 24 | 170 | 402 | 449 | MEZ4265313.1 hypothetical protein [Myxococcota bacterium] | diamond | 147 | 42 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 28905382 | 28905382 | PRJNA235310_P_NODE_6268_length_162_cov_1.274336_g6242_i0 | PRJNA235310 | 6268 | 162 | 1.274336 | 2.06442432 | Labilithrix luteola | 1391654 | Bacteria | Bacteria | 59.3 | 8.02e-9 | NR | WP_146655144.1 | 1391654 | g6242 | i0 | 66.7 | 3.61111111111111 | 39 | 13 | 72.2 | 0 | 118 | 2 | 90 | 128 | WP_146655144.1 peptide-methionine (S)-S-oxide reductase MsrA [Labilithrix luteola] | diamond | 585 | 59.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix luteola | |||
| 28937293 | 28937293 | PRJNA235310_P_NODE_2268_length_257_cov_1.750000_g2242_i0 | PRJNA235310 | 2268 | 257 | 1.75 | 4.4975 | Nannocystaceae bacterium | 2545255 | Bacteria | Bacteria | 72 | 2.1e-12 | NR | MEZ4381494.1 | 2545255 | g2242 | i0 | 39.5 | 1.00389105058366 | 86 | 49 | 96.9 | 1 | 1 | 249 | 251 | 336 | MEZ4381494.1 hypothetical protein [Nannocystaceae bacterium] | diamond | 258 | 72 | 1 | Bacteria | Pseudomonadati | Myxococcota | Nannocystales | Nannocystaceae | Nannocystaceae bacterium | ||||
| 28937294 | 28937294 | PRJNA235310_P_NODE_3388_length_206_cov_0.987261_g3362_i0 | PRJNA235310 | 3388 | 206 | 0.987261 | 2.03375766 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 48.9 | 1.55e-4 | NR | MBT9558510.1 | 2026763 | g3362 | i0 | 49 | 0.742718446601942 | 51 | 24 | 71.4 | 2 | 59 | 205 | 755 | 805 | MBT9558510.1 hypothetical protein [Myxococcales bacterium] | diamond | 153 | 48.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 29410684 | 29410684 | PRJNA235310_P_NODE_169_length_763_cov_3.023810_g151_i0 | PRJNA235310 | 169 | 763 | 3.02381 | 23.0716703 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 78.6 | 1.75e-12 | NR | HUT99814.1 | 2818507 | g151 | i0 | 38.6 | 0.519003931847969 | 132 | 72 | 49.1 | 7 | 95 | 469 | 375 | 504 | HUT99814.1 Ig domain-containing protein [Myxococcota bacterium] | diamond | 396 | 78.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 29428306 | 29428306 | PRJNA235310_P_NODE_5649_length_165_cov_2.060345_g5623_i0 | PRJNA235310 | 5649 | 165 | 2.060345 | 3.39956925 | Bacteria | 2 | Bacteria | Bacteria | 63.2 | 7.95e-10 | NR | MBT6489693.1 | 2026735 | g5623 | i0 | 48.3 | 4.29090909090909 | 58 | 25 | 96.4 | 2 | 5 | 163 | 1544 | 1601 | MBT6489693.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 708 | 63.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29789545 | 29789545 | PRJNA235310_P_NODE_5831_length_165_cov_0.896552_g5805_i0 | PRJNA235310 | 5831 | 165 | 0.896552 | 1.4793108 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 52.4 | 1.15e-6 | NR | HTR55435.1 | 2212474 | g5805 | i0 | 51.4 | 1.34545454545455 | 37 | 18 | 67.3 | 0 | 15 | 125 | 39 | 75 | HTR55435.1 hypothetical protein [Kofleriaceae bacterium] | diamond | 222 | 52.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 30231957 | 30231957 | PRJNA235310_P_NODE_1212_length_366_cov_0.949527_g1186_i0 | PRJNA235310 | 1212 | 366 | 0.949527 | 3.47526882 | Polyangia bacterium | 3058050 | Bacteria | Bacteria | 55.5 | 5.28e-6 | NR | MDY0000024.1 | 3058050 | g1186 | i0 | 40.6 | 1.28688524590164 | 69 | 35 | 54.1 | 2 | 3 | 200 | 404 | 469 | MDY0000024.1 hypothetical protein [Polyangia bacterium] | diamond | 471 | 55.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangia bacterium | ||||||
| 30453392 | 30453392 | PRJNA235310_P_NODE_1133_length_377_cov_1.896341_g1107_i0 | PRJNA235310 | 1133 | 377 | 1.896341 | 7.14920557 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 50.4 | 1.04e-4 | NR | MEO0460890.1 | 2818507 | g1107 | i0 | 50 | 0.716180371352785 | 44 | 22 | 35 | 0 | 344 | 213 | 8 | 51 | MEO0460890.1 hypothetical protein [Myxococcota bacterium] | diamond | 270 | 50.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 30737365 | 30737365 | PRJNA235310_P_NODE_1954_length_283_cov_1.111111_g1928_i0 | PRJNA235310 | 1954 | 283 | 1.111111 | 3.14444413 | Archangium violaceum | 83451 | Bacteria | Bacteria | 50.4 | 1.13e-4 | NR | WP_043406812.1 | 83451 | g1928 | i0 | 36.3 | 0.964664310954064 | 91 | 53 | 96.5 | 3 | 279 | 7 | 240 | 325 | WP_043406812.1 hypothetical protein [Archangium violaceum] | diamond | 273 | 50.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium violaceum | ||
| 30737372 | 30737372 | PRJNA235310_P_NODE_5974_length_164_cov_0.904348_g5948_i0 | PRJNA235310 | 5974 | 164 | 0.904348 | 1.48313072 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 47.4 | 3e-4 | NR | MEM6292225.1 | 2818507 | g5948 | i0 | 51.1 | 0.859756097560976 | 47 | 21 | 82.3 | 1 | 29 | 163 | 404 | 450 | MEM6292225.1 ATP-binding protein [Myxococcota bacterium] | diamond | 141 | 47.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 30895630 | 30895630 | PRJNA235310_P_NODE_4474_length_176_cov_1.228346_g4448_i0 | PRJNA235310 | 4474 | 176 | 1.228346 | 2.16188896 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 54.7 | 9.15e-7 | NR | HQP36693.1 | 2268199 | g4448 | i0 | 60.5 | 0.732954545454545 | 43 | 16 | 71.6 | 1 | 1 | 126 | 523 | 565 | HQP36693.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 129 | 54.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 31021896 | 31021896 | PRJNA235310_P_NODE_3555_length_200_cov_1.304636_g3529_i0 | PRJNA235310 | 3555 | 200 | 1.304636 | 2.609272 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 59.3 | 2.19e-8 | NR | MFT4628491.1 | 2818507 | g3529 | i0 | 61.9 | 1.23 | 42 | 16 | 63 | 0 | 127 | 2 | 4 | 45 | MFT4628491.1 pyruvate/2-oxoglutarate dehydrogenase complex dihydrolipoamide acyltransferase (E2) component [Myxococcota bacterium] | diamond | 246 | 59.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 31401419 | 31401419 | PRJNA235310_P_NODE_636_length_486_cov_1.704805_g610_i0 | PRJNA235310 | 636 | 486 | 1.704805 | 8.2853523 | Polyangia bacterium | 3058050 | Bacteria | Bacteria | 53.5 | 8e-5 | NR | MDY0000024.1 | 3058050 | g610 | i0 | 38.8 | 0.604938271604938 | 98 | 44 | 51.9 | 4 | 136 | 387 | 263 | 358 | MDY0000024.1 hypothetical protein [Polyangia bacterium] | diamond | 294 | 53.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangia bacterium | ||||||
| 31559561 | 31559561 | PRJNA235310_P_NODE_336_length_617_cov_1.875000_g313_i0 | PRJNA235310 | 336 | 617 | 1.875 | 11.56875 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 121 | 1.11e-28 | NR | MEE3329137.1 | 2818507 | g313 | i0 | 38.8 | 0.889789303079417 | 183 | 92 | 81.2 | 9 | 605 | 105 | 168 | 346 | MEE3329137.1 hypothetical protein [Myxococcota bacterium] | diamond | 549 | 121 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 31938796 | 31938796 | PRJNA235310_P_NODE_3717_length_196_cov_1.054422_g3691_i0 | PRJNA235310 | 3717 | 196 | 1.054422 | 2.06666712 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 42.4 | 0.00629 | NR | MBR58855.1 | 2026763 | g3691 | i0 | 47.1 | 0.780612244897959 | 51 | 20 | 78.1 | 2 | 2 | 154 | 43 | 86 | MBR58855.1 integration host factor [Myxococcales bacterium] | diamond | 153 | 42.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 32287306 | 32287306 | PRJNA235310_P_NODE_5819_length_165_cov_0.896552_g5793_i0 | PRJNA235310 | 5819 | 165 | 0.896552 | 1.4793108 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 59.3 | 1.9e-8 | NR | MEZ4361122.1 | 2212474 | g5793 | i0 | 53.7 | 0.981818181818182 | 54 | 23 | 98.2 | 1 | 165 | 4 | 1848 | 1899 | MEZ4361122.1 Ig-like domain-containing protein [Kofleriaceae bacterium] | diamond | 162 | 59.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 32445429 | 32445429 | PRJNA235310_P_NODE_5519_length_166_cov_0.888889_g5493_i0 | PRJNA235310 | 5519 | 166 | 0.888889 | 1.47555574 | Polyangium sp. | 3409587 | Bacteria | Bacteria | 48.9 | 8.89e-5 | NR | HRI69348.1 | 57 | g5493 | i0 | 41.5 | 0.957831325301205 | 53 | 29 | 95.8 | 1 | 2 | 160 | 109 | 159 | HRI69348.1 FG-GAP-like repeat-containing protein [Polyangium sp.] | diamond | 159 | 48.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangium | Polyangium sp. | |||
| 32697542 | 32697542 | PRJNA235310_P_NODE_1880_length_289_cov_1.495833_g1854_i0 | PRJNA235310 | 1880 | 289 | 1.495833 | 4.32295737 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 50.1 | 1.59e-4 | NR | HWU90772.1 | 2212474 | g1854 | i0 | 42.6 | 2.06574394463668 | 68 | 35 | 69.6 | 3 | 3 | 203 | 172 | 236 | HWU90772.1 hypothetical protein [Kofleriaceae bacterium] | diamond | 597 | 50.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae 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);;