contig_metadata
25 rows where bioproject = "PRJNA770361" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3297613 | 3297613 | PRJNA770361_P_NODE_19123_length_242_cov_0.923077_g19028_i0 | PRJNA770361 | 19123 | 242 | 0.923077 | 2.23384634 | FCB group | 1783270 | Bacteria | Bacteria | 115 | 1.3e-27 | NR | WP_050433118.1 | 52 | g19028 | i0 | 70.4 | 9.94214876033058 | 81 | 23 | 99.2 | 1 | 242 | 3 | 381 | 461 | WP_050433118.1 type I polyketide synthase [Chondromyces crocatus] | diamond | 2406 | 115 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Chondromyces | Chondromyces crocatus | |||
| 26768392 | 26768392 | PRJNA770361_P_NODE_8001_length_333_cov_0.796154_g7906_i0 | PRJNA770361 | 8001 | 333 | 0.796154 | 2.65119282 | Nannocystaceae bacterium | 2545255 | Bacteria | Bacteria | 156 | 1.1399999999999996e-43 | NR | MEZ4448627.1 | 2545255 | g7906 | i0 | 67.3 | 2.97297297297297 | 110 | 36 | 99.1 | 0 | 331 | 2 | 71 | 180 | MEZ4448627.1 acetyl-CoA C-acetyltransferase [Nannocystaceae bacterium] | diamond | 990 | 156 | 1 | Bacteria | Pseudomonadati | Myxococcota | Nannocystales | Nannocystaceae | Nannocystaceae bacterium | ||||
| 26831777 | 26831777 | PRJNA770361_P_NODE_19061_length_242_cov_0.923077_g18966_i0 | PRJNA770361 | 19061 | 242 | 0.923077 | 2.23384634 | Polyangiales bacterium | 3034171 | Bacteria | Bacteria | 81.6 | 2.37e-16 | NR | MFK7999874.1 | 3034171 | g18966 | i0 | 77.6 | 1.32644628099174 | 49 | 11 | 60.7 | 0 | 94 | 240 | 6 | 54 | MFK7999874.1 SDR family NAD(P)-dependent oxidoreductase [Polyangiales bacterium] | diamond | 321 | 81.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiales bacterium | |||||
| 27021631 | 27021631 | PRJNA770361_P_NODE_15902_length_248_cov_1.434286_g15807_i0 | PRJNA770361 | 15902 | 248 | 1.434286 | 3.55702928 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 100 | 1.1399999999999999e-24 | NR | MBI4405836.1 | 2026735 | g15807 | i0 | 56.1 | 1.97177419354839 | 82 | 36 | 99.2 | 0 | 248 | 3 | 34 | 115 | MBI4405836.1 ferritin-like domain-containing protein [Deltaproteobacteria bacterium] | diamond | 489 | 100 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 27432721 | 27432721 | PRJNA770361_P_NODE_3363_length_514_cov_1.768707_g3268_i0 | PRJNA770361 | 3363 | 514 | 1.768707 | 9.09115398 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 58.5 | 1.34e-6 | NR | MBK6685775.1 | 2026735 | g3268 | i0 | 27.6 | 0.846303501945525 | 145 | 91 | 78.8 | 3 | 468 | 64 | 39 | 179 | MBK6685775.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 435 | 58.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 27505407 | 27505407 | PRJNA770361_P_NODE_17063_length_246_cov_0.901734_g16968_i0 | PRJNA770361 | 17063 | 246 | 0.901734 | 2.21826564 | Bacteria | 2 | Bacteria | Bacteria | 45.1 | 0.00611 | NR | MCB9737511.1 | 2026735 | g16968 | i0 | 45 | 1.59756097560976 | 40 | 22 | 48.8 | 0 | 225 | 106 | 239 | 278 | MCB9737511.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 393 | 45.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 27811572 | 27811572 | PRJNA770361_P_NODE_15024_length_250_cov_0.881356_g14929_i0 | PRJNA770361 | 15024 | 250 | 0.881356 | 2.20339 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 75.1 | 2.98e-14 | NR | MBW1676660.1 | 2026735 | g14929 | i0 | 77.3 | 0.528 | 44 | 10 | 52.8 | 0 | 248 | 117 | 179 | 222 | MBW1676660.1 class I SAM-dependent methyltransferase [Deltaproteobacteria bacterium] | diamond | 132 | 75.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 28001007 | 28001007 | PRJNA770361_P_NODE_13005_length_259_cov_1.193548_g12910_i0 | PRJNA770361 | 13005 | 259 | 1.193548 | 3.09128932 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 60.8 | 1.87e-8 | NR | HEY6079829.1 | 2268199 | g12910 | i0 | 43.8 | 0.741312741312741 | 64 | 30 | 67.2 | 1 | 175 | 2 | 383 | 446 | HEY6079829.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 192 | 60.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 28505989 | 28505989 | PRJNA770361_P_NODE_10627_length_289_cov_1.856481_g10532_i0 | PRJNA770361 | 10627 | 289 | 1.856481 | 5.36523009 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 78.6 | 3.87e-15 | NR | MEC7947125.1 | 2818507 | g10532 | i0 | 44.7 | 3.21799307958478 | 94 | 45 | 92.4 | 2 | 287 | 21 | 125 | 216 | MEC7947125.1 class I SAM-dependent methyltransferase [Myxococcota bacterium] | diamond | 930 | 78.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 28632515 | 28632515 | PRJNA770361_P_NODE_3527_length_501_cov_2.691589_g3432_i0 | PRJNA770361 | 3527 | 501 | 2.691589 | 13.48486089 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 46.6 | 0.0201 | NR | MBM4343832.1 | 2026735 | g3432 | i0 | 54.5 | 0.491017964071856 | 44 | 20 | 26.3 | 0 | 311 | 442 | 432 | 475 | MBM4343832.1 TLD domain-containing protein [Deltaproteobacteria bacterium] | diamond | 246 | 46.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 28884805 | 28884805 | PRJNA770361_P_NODE_2488_length_602_cov_1.255198_g2394_i0 | PRJNA770361 | 2488 | 602 | 1.255198 | 7.55629196 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 206 | 1.6000000000000004e-59 | NR | MCZ6807881.1 | 2026735 | g2394 | i0 | 53 | 3.75249169435216 | 198 | 93 | 98.7 | 0 | 3 | 596 | 126 | 323 | MCZ6807881.1 SDR family oxidoreductase [Deltaproteobacteria bacterium] | diamond | 2259 | 206 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 28916207 | 28916207 | PRJNA770361_P_NODE_15248_length_250_cov_0.881356_g15153_i0 | PRJNA770361 | 15248 | 250 | 0.881356 | 2.20339 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 45.8 | 0.00319 | NR | MBN2799603.1 | 2026735 | g15153 | i0 | 45.1 | 0.612 | 51 | 27 | 60 | 1 | 87 | 236 | 95 | 145 | MBN2799603.1 TIM44-like domain-containing protein [Deltaproteobacteria bacterium] | diamond | 153 | 45.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29778455 | 29778455 | PRJNA770361_P_NODE_7911_length_334_cov_1.655172_g7816_i0 | PRJNA770361 | 7911 | 334 | 1.655172 | 5.52827448 | Bacteria | 2 | Bacteria | Bacteria | 52.4 | 3.95e-5 | NR | RLB53113.1 | 2026735 | g7816 | i0 | 51.4 | 1.86826347305389 | 37 | 18 | 33.2 | 0 | 224 | 334 | 30 | 66 | RLB53113.1 MAG: hypothetical protein DRJ42_12880 [Deltaproteobacteria bacterium] | diamond | 624 | 52.8 | 0.992424242424242 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29958414 | 29958414 | PRJNA770361_P_NODE_16531_length_247_cov_0.896552_g16436_i0 | PRJNA770361 | 16531 | 247 | 0.896552 | 2.21448344 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 129 | 6.97e-33 | NR | MCU0669868.1 | 2818507 | g16436 | i0 | 82.7 | 0.983805668016194 | 81 | 14 | 98.4 | 0 | 4 | 246 | 179 | 259 | MCU0669868.1 hypothetical protein [Myxococcota bacterium] | diamond | 243 | 129 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 30220702 | 30220702 | PRJNA770361_P_NODE_17952_length_244_cov_0.912281_g17857_i0 | PRJNA770361 | 17952 | 244 | 0.912281 | 2.22596564 | Bacteria | 2 | Bacteria | Bacteria | 106 | 1.51e-24 | NR | WP_044245088.1 | 51 | g17857 | i0 | 61.5 | 16.1311475409836 | 78 | 30 | 95.9 | 0 | 244 | 11 | 265 | 342 | WP_044245088.1 hypothetical protein [Chondromyces apiculatus] | diamond | 3936 | 107 | 0.990654205607477 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Chondromyces | Chondromyces apiculatus | |||
| 30338048 | 30338048 | PRJNA770361_P_NODE_12412_length_266_cov_1.616580_g12317_i0 | PRJNA770361 | 12412 | 266 | 1.61658 | 4.3001028 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 50.4 | 1.18e-5 | NR | HET6346565.1 | 2818507 | g12317 | i0 | 42.6 | 2.05263157894737 | 68 | 37 | 76.7 | 2 | 263 | 60 | 11 | 76 | HET6346565.1 U-box domain-containing protein [Myxococcota bacterium] | diamond | 546 | 50.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 30495726 | 30495726 | PRJNA770361_P_NODE_9293_length_310_cov_0.987342_g9198_i0 | PRJNA770361 | 9293 | 310 | 0.987342 | 3.0607602 | Archangiaceae bacterium | 2684409 | Bacteria | Bacteria | 79 | 1.57e-14 | NR | MBM4781417.1 | 2684409 | g9198 | i0 | 57.1 | 1.35483870967742 | 70 | 28 | 67.7 | 2 | 212 | 3 | 374 | 441 | MBM4781417.1 hypothetical protein [Archangiaceae bacterium] | diamond | 420 | 79 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangiaceae bacterium | |||
| 30969684 | 30969684 | PRJNA770361_P_NODE_3314_length_517_cov_2.099099_g3219_i0 | PRJNA770361 | 3314 | 517 | 2.099099 | 10.85234183 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 53.9 | 5.61e-5 | NR | MCC6554980.1 | 2268199 | g3219 | i0 | 36.5 | 0.429400386847195 | 74 | 46 | 42.4 | 1 | 159 | 377 | 253 | 326 | MCC6554980.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 222 | 53.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 31317155 | 31317155 | PRJNA770361_P_NODE_11315_length_280_cov_1.884058_g11220_i0 | PRJNA770361 | 11315 | 280 | 1.884058 | 5.2753624 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 43.1 | 0.0427 | NR | HEU4730804.1 | 2212474 | g11220 | i0 | 35.5 | 0.664285714285714 | 62 | 31 | 62.1 | 2 | 97 | 270 | 233 | 289 | HEU4730804.1 vitamin K epoxide reductase family protein [Kofleriaceae bacterium] | diamond | 186 | 43.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 31412109 | 31412109 | PRJNA770361_P_NODE_11496_length_278_cov_1.302439_g11401_i0 | PRJNA770361 | 11496 | 278 | 1.302439 | 3.62078042 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 65.9 | 1.22e-10 | NR | MBI4700605.1 | 2026735 | g11401 | i0 | 42.5 | 0.938848920863309 | 87 | 48 | 91.7 | 2 | 17 | 271 | 104 | 190 | MBI4700605.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 261 | 65.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31475451 | 31475451 | PRJNA770361_P_NODE_9816_length_301_cov_1.368421_g9721_i0 | PRJNA770361 | 9816 | 301 | 1.368421 | 4.11894721 | Myxococcaceae | 31 | Bacteria | Bacteria | 43.5 | 0.0397 | NR | WP_153866688.1 | 31 | g9721 | i0 | 34.1 | 0.877076411960133 | 88 | 48 | 80.7 | 4 | 280 | 38 | 178 | 262 | WP_153866688.1 MULTISPECIES: HEAT repeat domain-containing protein [Myxococcaceae] | diamond | 264 | 43.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | ||||
| 32044762 | 32044762 | PRJNA770361_P_NODE_14258_length_252_cov_0.871508_g14163_i0 | PRJNA770361 | 14258 | 252 | 0.871508 | 2.19620016 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 86.7 | 5.06e-20 | NR | MDL1962001.1 | 2026735 | g14163 | i0 | 100 | 1.02380952380952 | 43 | 0 | 51.2 | 0 | 129 | 1 | 1 | 43 | MDL1962001.1 nucleotidyltransferase domain-containing protein [Deltaproteobacteria bacterium] | diamond | 258 | 86.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32139723 | 32139723 | PRJNA770361_P_NODE_17238_length_246_cov_0.901734_g17143_i0 | PRJNA770361 | 17238 | 246 | 0.901734 | 2.21826564 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 48.1 | 4.49e-4 | NR | MBE7481979.1 | 2268199 | g17143 | i0 | 53.2 | 0.573170731707317 | 47 | 20 | 56.1 | 2 | 35 | 172 | 273 | 318 | MBE7481979.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 141 | 48.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 32298212 | 32298212 | PRJNA770361_P_NODE_10219_length_295_cov_0.932432_g10124_i0 | PRJNA770361 | 10219 | 295 | 0.932432 | 2.7506744 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 98.2 | 1.4000000000000002e-22 | NR | MBT8370187.1 | 2026735 | g10124 | i0 | 86.3 | 0.51864406779661 | 51 | 7 | 51.9 | 0 | 295 | 143 | 208 | 258 | MBT8370187.1 IS21-like element helper ATPase IstB [Deltaproteobacteria bacterium] | diamond | 153 | 98.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32487860 | 32487860 | PRJNA770361_P_NODE_9619_length_304_cov_1.419913_g9524_i0 | PRJNA770361 | 9619 | 304 | 1.419913 | 4.31653552 | Nannocystis sp. | 1962667 | Bacteria | Bacteria | 134 | 2.05e-35 | NR | MBK8261646.1 | 1962667 | g9524 | i0 | 77.4 | 17.0625 | 84 | 19 | 82.9 | 0 | 304 | 53 | 317 | 400 | MBK8261646.1 acetyl-CoA C-acetyltransferase [Nannocystis sp.] | diamond | 5187 | 134 | 1 | Bacteria | Pseudomonadati | Myxococcota | Nannocystales | Nannocystaceae | Nannocystis | Nannocystis sp. |
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);;