contig_metadata
26 rows where bioproject = "PRJNA576995", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7514799 | 7514799 | PRJNA576995_P_NODE_30006_length_278_cov_1.356098_g29414_i0 | PRJNA576995 | 30006 | 278 | 1.356098 | 3.76995244 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 78.2 | 3.21e-15 | NR | MBU6161592.1 | 2026763 | g29414 | i0 | 49.3 | 1.65107913669065 | 69 | 35 | 74.5 | 0 | 272 | 66 | 58 | 126 | MBU6161592.1 adenylate/guanylate cyclase domain-containing protein [Myxococcales bacterium] | diamond | 459 | 78.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 19687352 | 19687352 | PRJNA576995_P_NODE_41976_length_243_cov_0.905882_g41384_i0 | PRJNA576995 | 41976 | 243 | 0.905882 | 2.20129326 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 108 | 3.83e-29 | NR | MFN7699925.1 | 2026735 | g41384 | i0 | 98 | 0.62962962962963 | 51 | 1 | 63 | 0 | 241 | 89 | 25 | 75 | MFN7699925.1 cold-shock protein [Deltaproteobacteria bacterium] | diamond | 153 | 108 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 20962747 | 20962747 | PRJNA576995_P_NODE_20257_length_335_cov_1.931298_g19665_i0 | PRJNA576995 | 20257 | 335 | 1.931298 | 6.4698483 | Nannocystis punicea | 2995304 | Bacteria | Bacteria | 340 | 6.019999999999999e-89 | NTclustered | gi|2415023655|gb|CP114040.1| | 2995304 | g19665 | i0 | 88.153 | 80.3283582089552 | 287 | 32 | 85 | 2 | 42 | 327 | 5377562 | 5377277 | Nannocystis poenicansa strain FL3 chromosome, complete genome | blastn | 26910 | 340 | 1 | Bacteria | Pseudomonadati | Myxococcota | Nannocystales | Nannocystaceae | Nannocystis | Nannocystis punicea | |||
| 20963132 | 20963132 | PRJNA576995_P_NODE_617_length_1721_cov_5.493325_g498_i0 | PRJNA576995 | 617 | 1721 | 5.493325 | 94.54012325 | Pendulispora albinea | 2741071 | Bacteria | Bacteria | 2170 | 0 | NTclustered | gi|2698035964|gb|CP089984.1| | 2741071 | g498 | i0 | 89.544 | 145.398024404416 | 1731 | 156 | 99 | 19 | 3 | 1721 | 7190402 | 7192119 | Pendulispora albinea strain MSr11954 chromosome, complete genome | blastn | 250230 | 2170 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora albinea | ||
| 26826567 | 26826567 | PRJNA576995_P_NODE_26221_length_298_cov_1.368889_g25629_i0 | PRJNA576995 | 26221 | 298 | 1.368889 | 4.07928922 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 90.1 | 5.32e-19 | NR | MEO1228096.1 | 2818507 | g25629 | i0 | 43.8 | 3.16107382550336 | 105 | 49 | 97.7 | 3 | 291 | 1 | 112 | 214 | MEO1228096.1 inositol 2-dehydrogenase [Myxococcota bacterium] | diamond | 942 | 90.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 27174172 | 27174172 | PRJNA576995_P_NODE_26122_length_299_cov_1.154867_g25530_i0 | PRJNA576995 | 26122 | 299 | 1.154867 | 3.45305233 | Myxococcaceae bacterium | 2484252 | Bacteria | Bacteria | 50.1 | 1.91e-4 | NR | MBX7098910.1 | 2484252 | g25530 | i0 | 57.4 | 1.83612040133779 | 47 | 20 | 47.2 | 0 | 59 | 199 | 537 | 583 | MBX7098910.1 N-acetylmuramoyl-L-alanine amidase [Myxococcaceae bacterium] | diamond | 549 | 50.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcaceae bacterium | |||
| 28229833 | 28229833 | PRJNA576995_P_NODE_27506_length_291_cov_1.059633_g26914_i0 | PRJNA576995 | 27506 | 291 | 1.059633 | 3.08353203 | Bacteria | 2 | Bacteria | Bacteria | 67.4 | 1.42e-10 | NR | MCA9520103.1 | 2026763 | g26914 | i0 | 40.8 | 2.93814432989691 | 98 | 51 | 93.8 | 4 | 1 | 273 | 324 | 421 | MCA9520103.1 hypothetical protein [Myxococcales bacterium] | diamond | 855 | 67.8 | 0.994100294985251 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 28279526 | 28279526 | PRJNA576995_P_NODE_32926_length_262_cov_0.878307_g32334_i0 | PRJNA576995 | 32926 | 262 | 0.878307 | 2.30116434 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 50.4 | 8.95e-5 | NR | MEZ4299829.1 | 2268199 | g32334 | i0 | 39.5 | 2.83969465648855 | 81 | 41 | 91.6 | 2 | 245 | 6 | 29 | 102 | MEZ4299829.1 DNRLRE domain-containing protein [Polyangiaceae bacterium] | diamond | 744 | 50.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 28500843 | 28500843 | PRJNA576995_P_NODE_39947_length_245_cov_0.895349_g39355_i0 | PRJNA576995 | 39947 | 245 | 0.895349 | 2.19360505 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 57.8 | 1.78e-7 | NR | MEJ7602469.1 | 2212474 | g39355 | i0 | 55.1 | 3.75918367346939 | 49 | 21 | 60 | 1 | 193 | 47 | 128 | 175 | MEJ7602469.1 MopE-related protein [Kofleriaceae bacterium] | diamond | 921 | 57.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 28658793 | 28658793 | PRJNA576995_P_NODE_36167_length_250_cov_0.870056_g35575_i0 | PRJNA576995 | 36167 | 250 | 0.870056 | 2.17514 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 108 | 2.11e-25 | NR | HEY1697811.1 | 2268199 | g35575 | i0 | 68.6 | 0.84 | 70 | 22 | 84 | 0 | 8 | 217 | 685 | 754 | HEY1697811.1 cytochrome c3 family protein [Polyangiaceae bacterium] | diamond | 210 | 108 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 28974506 | 28974506 | PRJNA576995_P_NODE_39728_length_246_cov_0.890173_g39136_i0 | PRJNA576995 | 39728 | 246 | 0.890173 | 2.18982558 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 45.1 | 0.00593 | NR | RLB53486.1 | 2026735 | g39136 | i0 | 35.9 | 1.42682926829268 | 78 | 31 | 73.2 | 3 | 224 | 45 | 421 | 497 | RLB53486.1 MAG: hypothetical protein DRI34_13335, partial [Deltaproteobacteria bacterium] | diamond | 351 | 45.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29353385 | 29353385 | PRJNA576995_P_NODE_41549_length_243_cov_0.905882_g40957_i0 | PRJNA576995 | 41549 | 243 | 0.905882 | 2.20129326 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 81.3 | 5.15e-17 | NR | MBK6461155.1 | 2026763 | g40957 | i0 | 59.5 | 1.95061728395062 | 79 | 31 | 97.5 | 1 | 242 | 6 | 42 | 119 | MBK6461155.1 RNA polymerase sigma factor [Myxococcales bacterium] | diamond | 474 | 81.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 29447738 | 29447738 | PRJNA576995_P_NODE_21150_length_329_cov_1.203125_g20558_i0 | PRJNA576995 | 21150 | 329 | 1.203125 | 3.95828125 | Hyalangium sp. | 2028555 | Bacteria | Bacteria | 102 | 1.14e-22 | NR | WP_324981267.1 | 2028555 | g20558 | i0 | 45.5 | 2.80851063829787 | 101 | 53 | 90.3 | 2 | 313 | 17 | 433 | 533 | WP_324981267.1 lysyl oxidase family protein [Hyalangium sp.] | diamond | 924 | 102 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Hyalangium | Hyalangium sp. | ||
| 29447760 | 29447760 | PRJNA576995_P_NODE_39710_length_246_cov_0.890173_g39118_i0 | PRJNA576995 | 39710 | 246 | 0.890173 | 2.18982558 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 71.6 | 2.43e-12 | NR | MBK6462327.1 | 2026763 | g39118 | i0 | 43.2 | 0.98780487804878 | 81 | 45 | 97.6 | 1 | 244 | 5 | 67 | 147 | MBK6462327.1 hypothetical protein [Myxococcales bacterium] | diamond | 243 | 71.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 29479235 | 29479235 | PRJNA576995_P_NODE_23210_length_316_cov_1.267490_g22618_i0 | PRJNA576995 | 23210 | 316 | 1.26749 | 4.0052684 | Myxococcaceae bacterium | 2484252 | Bacteria | Bacteria | 45.1 | 0.00997 | NR | GMU58513.1 | 2484252 | g22618 | i0 | 40 | 2.45886075949367 | 65 | 37 | 59.8 | 1 | 245 | 57 | 82 | 146 | GMU58513.1 MAG: hypothetical protein AMXMBFR34_02760 [Myxococcaceae bacterium] | diamond | 777 | 45.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcaceae bacterium | |||
| 29763540 | 29763540 | PRJNA576995_P_NODE_37531_length_248_cov_0.880000_g36939_i0 | PRJNA576995 | 37531 | 248 | 0.88 | 2.1824 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 115 | 1.38e-30 | NR | HXX67380.1 | 2268199 | g36939 | i0 | 71.3 | 4.69354838709677 | 80 | 23 | 96.8 | 0 | 246 | 7 | 81 | 160 | HXX67380.1 DoxX family protein [Polyangiaceae bacterium] | diamond | 1164 | 115 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 30521897 | 30521897 | PRJNA576995_P_NODE_40993_length_244_cov_0.900585_g40401_i0 | PRJNA576995 | 40993 | 244 | 0.900585 | 2.1974274 | Pendulispora rubella | 2741070 | Bacteria | Bacteria | 55.5 | 1.2e-6 | NR | WP_394838810.1 | 2741070 | g40401 | i0 | 47.3 | 1.83196721311475 | 74 | 29 | 86.1 | 3 | 210 | 1 | 12 | 79 | WP_394838810.1 hypothetical protein [Pendulispora rubella] | diamond | 447 | 55.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora rubella | ||
| 30837883 | 30837883 | PRJNA576995_P_NODE_42634_length_242_cov_0.911243_g42042_i0 | PRJNA576995 | 42634 | 242 | 0.911243 | 2.20520806 | Pendulispora albinea | 2741071 | Bacteria | Bacteria | 62.8 | 3.25e-9 | NR | WP_394826916.1 | 2741071 | g42042 | i0 | 44.7 | 0.942148760330578 | 76 | 42 | 94.2 | 0 | 15 | 242 | 350 | 425 | WP_394826916.1 hypothetical protein [Pendulispora albinea] | diamond | 228 | 62.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora albinea | ||
| 31121853 | 31121853 | PRJNA576995_P_NODE_31795_length_268_cov_2.369231_g31203_i0 | PRJNA576995 | 31795 | 268 | 2.369231 | 6.34953908 | Paraliomyxa miuraensis | 376150 | Bacteria | Bacteria | 43.1 | 0.038 | NR | WP_266217561.1 | 376150 | g31203 | i0 | 37.3 | 0.66044776119403 | 59 | 33 | 66 | 1 | 267 | 91 | 652 | 706 | WP_266217561.1 serine/threonine-protein kinase [Paraliomyxa miuraensis] | diamond | 177 | 43.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Paraliomyxa | Paraliomyxa miuraensis | |||
| 31343606 | 31343606 | PRJNA576995_P_NODE_42716_length_242_cov_0.911243_g42124_i0 | PRJNA576995 | 42716 | 242 | 0.911243 | 2.20520806 | Archangium lipolyticum | 2970465 | Bacteria | Bacteria | 52 | 1.88e-5 | NR | WP_257462508.1 | 2970465 | g42124 | i0 | 44.1 | 2.50413223140496 | 59 | 29 | 70.7 | 2 | 46 | 216 | 171 | 227 | WP_257462508.1 hypothetical protein [Archangium lipolyticum] | diamond | 606 | 52 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium lipolyticum | ||
| 31470207 | 31470207 | PRJNA576995_P_NODE_18336_length_351_cov_0.830935_g17744_i0 | PRJNA576995 | 18336 | 351 | 0.830935 | 2.91658185 | Labilithrix sp. | 1971228 | Bacteria | Bacteria | 48.5 | 0.00113 | NR | HVH45298.1 | 1971228 | g17744 | i0 | 46.7 | 0.641025641025641 | 75 | 37 | 64.1 | 2 | 305 | 81 | 288 | 359 | HVH45298.1 hypothetical protein [Labilithrix sp.] | diamond | 225 | 48.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix sp. | |||
| 31817908 | 31817908 | PRJNA576995_P_NODE_35657_length_250_cov_0.870056_g35065_i0 | PRJNA576995 | 35657 | 250 | 0.870056 | 2.17514 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 58.2 | 6.92e-8 | NR | MCA9634375.1 | 2026763 | g35065 | i0 | 65 | 0.48 | 40 | 14 | 48 | 0 | 121 | 2 | 78 | 117 | MCA9634375.1 hypothetical protein [Myxococcales bacterium] | diamond | 120 | 58.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 31912904 | 31912904 | PRJNA576995_P_NODE_41717_length_243_cov_0.905882_g41125_i0 | PRJNA576995 | 41717 | 243 | 0.905882 | 2.20129326 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 98.2 | 5.17e-22 | NR | MEM6991430.1 | 2818507 | g41125 | i0 | 68.2 | 2.44444444444444 | 66 | 21 | 81.5 | 0 | 198 | 1 | 5 | 70 | MEM6991430.1 peroxidase family protein [Myxococcota bacterium] | diamond | 594 | 98.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 32039505 | 32039505 | PRJNA576995_P_NODE_31618_length_269_cov_1.964286_g31026_i0 | PRJNA576995 | 31618 | 269 | 1.964286 | 5.28392934 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 91.7 | 3.19e-19 | NR | RME21121.1 | 2026735 | g31026 | i0 | 52.4 | 2.86617100371747 | 84 | 38 | 93.7 | 2 | 14 | 265 | 596 | 677 | RME21121.1 MAG: hypothetical protein D6806_15245, partial [Deltaproteobacteria bacterium] | diamond | 771 | 91.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32608816 | 32608816 | PRJNA576995_P_NODE_6800_length_612_cov_2.298701_g6216_i0 | PRJNA576995 | 6800 | 612 | 2.298701 | 14.06805012 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 196 | 1.66e-58 | NR | HEY0254123.1 | 2212474 | g6216 | i0 | 51 | 7.99509803921569 | 202 | 83 | 99 | 4 | 2 | 607 | 116 | 301 | HEY0254123.1 pirin family protein [Kofleriaceae bacterium] | diamond | 4893 | 196 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 32640007 | 32640007 | PRJNA576995_P_NODE_34940_length_251_cov_0.865169_g34348_i0 | PRJNA576995 | 34940 | 251 | 0.865169 | 2.17157419 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 43.5 | 0.0213 | NR | MFI5321362.1 | 2818507 | g34348 | i0 | 46 | 1.19521912350598 | 50 | 25 | 59.8 | 1 | 201 | 52 | 99 | 146 | MFI5321362.1 zf-HC2 domain-containing protein [Myxococcota bacterium] | diamond | 300 | 43.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota 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);;