contig_metadata
29 rows where bioproject = "PRJNA335774", tax_kingdom = "Pseudomonadati" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26662790 | 26662790 | PRJNA335774_P_NODE_16961_length_367_cov_1.170068_g16809_i0 | PRJNA335774 | 16961 | 367 | 1.170068 | 4.29414956 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 60.5 | 2.2e-8 | NR | MCA9671053.1 | 2026763 | g16809 | i0 | 35.9 | 0.841961852861035 | 103 | 55 | 76 | 2 | 28 | 306 | 55 | 156 | MCA9671053.1 hypothetical protein [Myxococcales bacterium] | diamond | 309 | 60.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 27043054 | 27043054 | PRJNA335774_P_NODE_4682_length_633_cov_1.289286_g4537_i0 | PRJNA335774 | 4682 | 633 | 1.289286 | 8.16118038 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 46.2 | 0.0492 | NR | MCA9647516.1 | 2026763 | g4537 | i0 | 33 | 0.4739336492891 | 100 | 61 | 46.4 | 4 | 226 | 519 | 246 | 341 | MCA9647516.1 hypothetical protein [Myxococcales bacterium] | diamond | 300 | 46.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 27232642 | 27232642 | PRJNA335774_P_NODE_30023_length_287_cov_1.313084_g29871_i0 | PRJNA335774 | 30023 | 287 | 1.313084 | 3.76855108 | Corallococcus carmarthensis | 2316728 | Bacteria | Bacteria | 46.2 | 0.00383 | NR | WP_158625800.1 | 2316728 | g29871 | i0 | 37.2 | 2.61324041811847 | 86 | 51 | 89.9 | 3 | 258 | 1 | 235 | 317 | WP_158625800.1 TIR domain-containing protein [Corallococcus carmarthensis] | diamond | 750 | 46.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Corallococcus | Corallococcus carmarthensis | ||
| 27295883 | 27295883 | PRJNA335774_P_NODE_12283_length_420_cov_1.893372_g12131_i0 | PRJNA335774 | 12283 | 420 | 1.893372 | 7.9521624 | Anaeromyxobacteraceae bacterium | 2510643 | Bacteria | Bacteria | 47.8 | 0.00396 | NR | MFL5274676.1 | 2510643 | g12131 | i0 | 39.4 | 0.707142857142857 | 99 | 52 | 70 | 4 | 417 | 124 | 79 | 170 | MFL5274676.1 hypothetical protein [Anaeromyxobacteraceae bacterium] | diamond | 297 | 47.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Anaeromyxobacteraceae | Anaeromyxobacteraceae bacterium | |||
| 27359297 | 27359297 | PRJNA335774_P_NODE_45123_length_244_cov_1.350877_g44971_i0 | PRJNA335774 | 45123 | 244 | 1.350877 | 3.29613988 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 51.6 | 2.72e-5 | NR | MBV72346.1 | 2026763 | g44971 | i0 | 57.1 | 0.516393442622951 | 42 | 11 | 51.6 | 1 | 96 | 221 | 245 | 279 | MBV72346.1 hypothetical protein [Myxococcales bacterium] | diamond | 126 | 51.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 27580082 | 27580082 | PRJNA335774_P_NODE_12644_length_415_cov_1.368421_g12492_i0 | PRJNA335774 | 12644 | 415 | 1.368421 | 5.67894715 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 42 | 0.048 | NR | MBM4321556.1 | 2026735 | g12492 | i0 | 42.3 | 0.375903614457831 | 52 | 29 | 37.6 | 1 | 198 | 43 | 22 | 72 | MBM4321556.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 156 | 42 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 27580100 | 27580100 | PRJNA335774_P_NODE_29064_length_291_cov_1.743119_g28912_i0 | PRJNA335774 | 29064 | 291 | 1.743119 | 5.07247629 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 71.6 | 4.72e-12 | NR | MCA9676067.1 | 2026763 | g28912 | i0 | 46.8 | 1.68041237113402 | 79 | 37 | 81.4 | 1 | 267 | 31 | 160 | 233 | MCA9676067.1 histidinol-phosphate aminotransferase family protein [Myxococcales bacterium] | diamond | 489 | 71.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 27706867 | 27706867 | PRJNA335774_P_NODE_31444_length_281_cov_1.413462_g31292_i0 | PRJNA335774 | 31444 | 281 | 1.413462 | 3.97182822 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 154 | 7.719999999999998e-42 | NR | MBI2389879.1 | 2026735 | g31292 | i0 | 74.7 | 1.9644128113879 | 91 | 23 | 97.2 | 0 | 6 | 278 | 408 | 498 | MBI2389879.1 RICIN domain-containing protein [Deltaproteobacteria bacterium] | diamond | 552 | 154 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 28022335 | 28022335 | PRJNA335774_P_NODE_13005_length_410_cov_1.448071_g12853_i0 | PRJNA335774 | 13005 | 410 | 1.448071 | 5.9370911 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 47 | 0.00742 | NR | MCO4760791.1 | 2026763 | g12853 | i0 | 51.2 | 0.724390243902439 | 43 | 21 | 31.5 | 0 | 165 | 37 | 302 | 344 | MCO4760791.1 lamin tail domain-containing protein [Myxococcales bacterium] | diamond | 297 | 47 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 28053659 | 28053659 | PRJNA335774_P_NODE_3545_length_710_cov_1.682889_g3406_i0 | PRJNA335774 | 3545 | 710 | 1.682889 | 11.9485119 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 295 | 2.9999999999999993e-96 | NR | MCS6914888.1 | 2818507 | g3406 | i0 | 59.8 | 1.96901408450704 | 234 | 94 | 98.9 | 0 | 2 | 703 | 24 | 257 | MCS6914888.1 methyltransferase domain-containing protein [Myxococcota bacterium] | diamond | 1398 | 295 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 28179830 | 28179830 | PRJNA335774_P_NODE_45046_length_244_cov_1.801170_g44894_i0 | PRJNA335774 | 45046 | 244 | 1.80117 | 4.3948548 | Minicystis rosea | 888845 | Bacteria | Bacteria | 45.8 | 0.00318 | NR | APR85582.1 | 888845 | g44894 | i0 | 43.7 | 0.872950819672131 | 71 | 35 | 86.1 | 2 | 22 | 231 | 8 | 74 | APR85582.1 kinesin light chain-like protein [Minicystis rosea] | diamond | 213 | 45.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Minicystis | Minicystis rosea | |||
| 29001400 | 29001400 | PRJNA335774_P_NODE_48588_length_241_cov_0.863095_g48436_i0 | PRJNA335774 | 48588 | 241 | 0.863095 | 2.08005895 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 56.2 | 6.15e-7 | NR | HLK41500.1 | 2268199 | g48436 | i0 | 43.8 | 0.995850622406639 | 80 | 37 | 95.9 | 3 | 233 | 3 | 67 | 141 | HLK41500.1 carboxylesterase/lipase family protein [Polyangiaceae bacterium] | diamond | 240 | 56.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 29127535 | 29127535 | PRJNA335774_P_NODE_47909_length_241_cov_1.267857_g47757_i0 | PRJNA335774 | 47909 | 241 | 1.267857 | 3.05553537 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 44.3 | 0.00926 | NR | RLB48292.1 | 2026735 | g47757 | i0 | 51.5 | 0.410788381742739 | 33 | 14 | 41.1 | 1 | 90 | 188 | 226 | 256 | RLB48292.1 MAG: hypothetical protein DRJ42_23560 [Deltaproteobacteria bacterium] | diamond | 99 | 44.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29632088 | 29632088 | PRJNA335774_P_NODE_20410_length_339_cov_4.372180_g20258_i0 | PRJNA335774 | 20410 | 339 | 4.37218 | 14.8216902 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 47.8 | 0.00203 | NR | MCO4760791.1 | 2026763 | g20258 | i0 | 60 | 0.309734513274336 | 35 | 14 | 31 | 0 | 103 | 207 | 302 | 336 | MCO4760791.1 lamin tail domain-containing protein [Myxococcales bacterium] | diamond | 105 | 47.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 29695262 | 29695262 | PRJNA335774_P_NODE_4610_length_636_cov_1.230906_g4467_i0 | PRJNA335774 | 4610 | 636 | 1.230906 | 7.82856216 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 60.5 | 2.08e-7 | NR | HMJ57057.1 | 2268199 | g4467 | i0 | 36.2 | 0.325471698113208 | 69 | 43 | 32.1 | 1 | 515 | 312 | 108 | 176 | HMJ57057.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 207 | 60.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 29885246 | 29885246 | PRJNA335774_P_NODE_19031_length_349_cov_2.010870_g18879_i0 | PRJNA335774 | 19031 | 349 | 2.01087 | 7.0179363 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 43.1 | 0.0496 | NR | MEE2959811.1 | 2818507 | g18879 | i0 | 29.4 | 0.584527220630373 | 68 | 48 | 58.5 | 0 | 4 | 207 | 45 | 112 | MEE2959811.1 hypothetical protein [Myxococcota bacterium] | diamond | 204 | 43.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 29979865 | 29979865 | PRJNA335774_P_NODE_37511_length_256_cov_1.262295_g37359_i0 | PRJNA335774 | 37511 | 256 | 1.262295 | 3.2314752 | Sandaracinus sp. | 2024858 | Bacteria | Bacteria | 42.7 | 0.0429 | NR | MFO0684939.1 | 2024858 | g37359 | i0 | 33.9 | 0.7265625 | 62 | 33 | 72.7 | 2 | 244 | 59 | 219 | 272 | MFO0684939.1 matrixin family metalloprotease [Sandaracinus sp.] | diamond | 186 | 42.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Sandaracinaceae | Sandaracinus | Sandaracinus sp. | |||
| 30264538 | 30264538 | PRJNA335774_P_NODE_43192_length_246_cov_2.791908_g43040_i0 | PRJNA335774 | 43192 | 246 | 2.791908 | 6.86809368 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 51.2 | 1.84e-5 | NR | MCA9671053.1 | 2026763 | g43040 | i0 | 36.6 | 0.865853658536585 | 71 | 39 | 79.3 | 1 | 49 | 243 | 70 | 140 | MCA9671053.1 hypothetical protein [Myxococcales bacterium] | diamond | 213 | 51.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 30281907 | 30281907 | PRJNA335774_P_NODE_20212_length_341_cov_1.097015_g20060_i0 | PRJNA335774 | 20212 | 341 | 1.097015 | 3.74082115 | Nannocystaceae | 224463 | Bacteria | Bacteria | 130 | 4.4199999999999985e-34 | NR | WP_224192401.1 | 889268 | g20060 | i0 | 53 | 4.80351906158358 | 100 | 47 | 88 | 0 | 339 | 40 | 254 | 353 | WP_224192401.1 Rieske 2Fe-2S domain-containing protein [Nannocystis pusilla] | diamond | 1638 | 130 | 1 | Bacteria | Pseudomonadati | Myxococcota | Nannocystales | Nannocystaceae | Nannocystis | Nannocystis pusilla | |||
| 30345234 | 30345234 | PRJNA335774_P_NODE_4412_length_647_cov_1.508711_g4269_i0 | PRJNA335774 | 4412 | 647 | 1.508711 | 9.76136017 | Bacteria | 2 | Bacteria | Bacteria | 115 | 6.330000000000001e-27 | NR | HEX3758815.1 | 2212474 | g4269 | i0 | 35 | 5.29984544049459 | 217 | 119 | 96.4 | 7 | 5 | 628 | 58 | 261 | HEX3758815.1 hypothetical protein [Kofleriaceae bacterium] | diamond | 3429 | 115 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 30832930 | 30832930 | PRJNA335774_P_NODE_34954_length_266_cov_1.958549_g34802_i0 | PRJNA335774 | 34954 | 266 | 1.958549 | 5.20974034 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 43.9 | 0.0158 | NR | MEE2835165.1 | 2818507 | g34802 | i0 | 35.3 | 0.766917293233083 | 68 | 41 | 73.3 | 1 | 47 | 241 | 18 | 85 | MEE2835165.1 hypothetical protein [Myxococcota bacterium] | diamond | 204 | 43.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 31180174 | 31180174 | PRJNA335774_P_NODE_6915_length_538_cov_1.292473_g6764_i0 | PRJNA335774 | 6915 | 538 | 1.292473 | 6.95350474 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 70.5 | 1.95e-10 | NR | MBP6837768.1 | 2212474 | g6764 | i0 | 45.9 | 1.23791821561338 | 74 | 35 | 41.3 | 1 | 280 | 59 | 2534 | 2602 | MBP6837768.1 hypothetical protein [Kofleriaceae bacterium] | diamond | 666 | 70.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 31545830 | 31545830 | PRJNA335774_P_NODE_27856_length_297_cov_1.263393_g27704_i0 | PRJNA335774 | 27856 | 297 | 1.263393 | 3.75227721 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 119 | 3.73e-29 | NR | MCA9626175.1 | 2026763 | g27704 | i0 | 64.6 | 5.66666666666667 | 96 | 32 | 97 | 1 | 5 | 292 | 236 | 329 | MCA9626175.1 tryptophanase [Myxococcales bacterium] | diamond | 1683 | 119 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 32034540 | 32034540 | PRJNA335774_P_NODE_36098_length_262_cov_1.148148_g35946_i0 | PRJNA335774 | 36098 | 262 | 1.148148 | 3.00814776 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 65.1 | 5.16e-10 | NR | RLB46302.1 | 2026735 | g35946 | i0 | 53 | 4.05343511450382 | 66 | 31 | 75.6 | 0 | 3 | 200 | 271 | 336 | RLB46302.1 MAG: hypothetical protein DRJ42_27970 [Deltaproteobacteria bacterium] | diamond | 1062 | 65.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32319621 | 32319621 | PRJNA335774_P_NODE_40539_length_249_cov_1.448864_g40387_i0 | PRJNA335774 | 40539 | 249 | 1.448864 | 3.60767136 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 45.1 | 0.00596 | NR | MBS2024131.1 | 2026735 | g40387 | i0 | 50 | 2.91566265060241 | 38 | 19 | 45.8 | 0 | 130 | 17 | 320 | 357 | MBS2024131.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 726 | 45.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32382597 | 32382597 | PRJNA335774_P_NODE_9259_length_474_cov_1.511222_g9107_i0 | PRJNA335774 | 9259 | 474 | 1.511222 | 7.16319228 | Cystobacter sp. | 1965334 | Bacteria | Bacteria | 76.3 | 8.09e-13 | NR | MET0402051.1 | 1965334 | g9107 | i0 | 34.4 | 1.03164556962025 | 163 | 88 | 94.9 | 8 | 18 | 467 | 136 | 292 | MET0402051.1 phosphatidylinositol-specific phospholipase C [Cystobacter sp.] | diamond | 489 | 76.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Cystobacter | Cystobacter sp. | ||
| 32400006 | 32400006 | PRJNA335774_P_NODE_15679_length_379_cov_0.993464_g15527_i0 | PRJNA335774 | 15679 | 379 | 0.993464 | 3.76522856 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 59.7 | 1.94e-7 | NR | MES1174858.1 | 2026763 | g15527 | i0 | 55.6 | 5.69129287598945 | 54 | 24 | 42.7 | 0 | 3 | 164 | 360 | 413 | MES1174858.1 cation:proton antiporter [Myxococcales bacterium] | diamond | 2157 | 60.1 | 0.993344425956739 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 32414295 | 32414295 | PRJNA335774_P_NODE_15499_length_380_cov_1.850163_g15347_i0 | PRJNA335774 | 15499 | 380 | 1.850163 | 7.0306194 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 50.4 | 1.4e-4 | NR | MCA9671053.1 | 2026763 | g15347 | i0 | 34.9 | 0.678947368421053 | 86 | 46 | 60 | 2 | 229 | 2 | 65 | 150 | MCA9671053.1 hypothetical protein [Myxococcales bacterium] | diamond | 258 | 50.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 32792544 | 32792544 | PRJNA335774_P_NODE_35720_length_263_cov_1.605263_g35568_i0 | PRJNA335774 | 35720 | 263 | 1.605263 | 4.22184169 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 50.4 | 2.56e-5 | NR | MFP6608719.1 | 2026735 | g35568 | i0 | 39.6 | 1.36882129277567 | 53 | 32 | 60.5 | 0 | 225 | 67 | 81 | 133 | MFP6608719.1 DUF1330 domain-containing protein [Deltaproteobacteria bacterium] | diamond | 360 | 50.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria 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);;