contig_metadata
29 rows where analysis = "diamond", bioproject = "PRJEB49404" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16676909 | 16676909 | PRJEB49404_P_NODE_280634_length_277_cov_1.336134_g266833_i0 | PRJEB49404 | 280634 | 277 | 1.336134 | 3.70109118 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 157 | 2.0699999999999998e-42 | NR | MBV8137665.1 | 2026735 | g266833 | i0 | 79.1 | 5.91335740072202 | 91 | 19 | 98.6 | 0 | 275 | 3 | 183 | 273 | MBV8137665.1 FdhF/YdeP family oxidoreductase [Deltaproteobacteria bacterium] | diamond | 1638 | 157 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 17964597 | 17964597 | PRJEB49404_P_NODE_548495_length_170_cov_1.358779_g534694_i0 | PRJEB49404 | 548495 | 170 | 1.358779 | 2.3099243 | Myxococcus xanthus | 34 | Bacteria | Bacteria | 98.6 | 2.98e-22 | NR | WP_140792499.1 | 34 | g534694 | i0 | 76.4 | 1.95882352941176 | 55 | 13 | 97.1 | 0 | 165 | 1 | 232 | 286 | WP_140792499.1 UvrD-helicase domain-containing protein [Myxococcus xanthus] | diamond | 333 | 98.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcus | Myxococcus xanthus | ||
| 21771541 | 21771541 | PRJEB49404_P_NODE_165358_length_403_cov_1.785714_g151571_i0 | PRJEB49404 | 165358 | 403 | 1.785714 | 7.19642742 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 250 | 3.7299999999999997e-81 | NR | MBP1689099.1 | 2026735 | g151571 | i0 | 85.1 | 2.99255583126551 | 134 | 20 | 99.8 | 0 | 403 | 2 | 135 | 268 | MBP1689099.1 transposase [Deltaproteobacteria bacterium] | diamond | 1206 | 250 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 22668050 | 22668050 | PRJEB49404_P_NODE_585958_length_162_cov_1.504065_g572157_i0 | PRJEB49404 | 585958 | 162 | 1.504065 | 2.4365853 | Polyangiales | 3031712 | Bacteria | Bacteria | 111 | 6.22e-28 | NR | MFO0734638.1 | 1971228 | g572157 | i0 | 94.3 | 4.90740740740741 | 53 | 3 | 98.1 | 0 | 161 | 3 | 157 | 209 | MFO0734638.1 IS21-like element helper ATPase IstB [Labilithrix sp.] | diamond | 795 | 111 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix sp. | |||
| 25217204 | 25217204 | PRJEB49404_P_NODE_507380_length_180_cov_1.163121_g493579_i0 | PRJEB49404 | 507380 | 180 | 1.163121 | 2.0936178 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 93.6 | 1.88e-20 | NR | HEX7604230.1 | 2268199 | g493579 | i0 | 76.7 | 1 | 60 | 14 | 100 | 0 | 180 | 1 | 16 | 75 | HEX7604230.1 ATP-binding protein [Polyangiaceae bacterium] | diamond | 180 | 93.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 26748193 | 26748193 | PRJEB49404_P_NODE_606301_length_158_cov_1.462185_g592500_i0 | PRJEB49404 | 606301 | 158 | 1.462185 | 2.3102523 | Stigmatella aurantiaca | 41 | Bacteria | Bacteria | 61.6 | 1.79e-9 | NR | WP_002615540.1 | 41 | g592500 | i0 | 63.5 | 0.987341772151899 | 52 | 19 | 98.7 | 0 | 158 | 3 | 11 | 62 | WP_002615540.1 SDR family oxidoreductase [Stigmatella aurantiaca] | diamond | 156 | 61.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Stigmatella | Stigmatella aurantiaca | ||
| 26780442 | 26780442 | PRJEB49404_P_NODE_323501_length_250_cov_1.360190_g309700_i0 | PRJEB49404 | 323501 | 250 | 1.36019 | 3.400475 | Myxococcus xanthus | 34 | Bacteria | Bacteria | 163 | 1.2e-47 | NR | WP_140792497.1 | 34 | g309700 | i0 | 92.8 | 0.996 | 83 | 6 | 99.6 | 0 | 2 | 250 | 95 | 177 | WP_140792497.1 PD-(D/E)XK nuclease family protein [Myxococcus xanthus] | diamond | 249 | 163 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcus | Myxococcus xanthus | ||
| 27058417 | 27058417 | PRJEB49404_P_NODE_500002_length_182_cov_1.146853_g486201_i0 | PRJEB49404 | 500002 | 182 | 1.146853 | 2.08727246 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 74.7 | 1.5e-14 | NR | WP_143903617.1 | 2596829 | g486201 | i0 | 63.5 | 6.36263736263736 | 52 | 19 | 85.7 | 0 | 182 | 27 | 39 | 90 | WP_143903617.1 7-carboxy-7-deazaguanine synthase [Corallococcus sp. Z5C101001] | diamond | 1158 | 74.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Corallococcus | Corallococcus sp. Z5C101001 | ||
| 27222986 | 27222986 | PRJEB49404_P_NODE_596063_length_160_cov_1.487603_g582262_i0 | PRJEB49404 | 596063 | 160 | 1.487603 | 2.3801648 | Archangium sp. | 1872627 | Bacteria | Bacteria | 51.2 | 2.34e-6 | NR | HEY0881708.1 | 1872627 | g582262 | i0 | 66.7 | 1.81875 | 33 | 11 | 61.9 | 0 | 156 | 58 | 79 | 111 | HEY0881708.1 c-type cytochrome [Archangium sp.] | diamond | 291 | 51.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium sp. | ||
| 27413022 | 27413022 | PRJEB49404_P_NODE_150503_length_431_cov_1.566327_g136724_i0 | PRJEB49404 | 150503 | 431 | 1.566327 | 6.75086937 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 139 | 1.17e-39 | NR | HEY0469537.1 | 2268199 | g136724 | i0 | 62.4 | 0.758700696055684 | 109 | 39 | 75.9 | 2 | 3 | 329 | 16 | 122 | HEY0469537.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 327 | 139 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 27602411 | 27602411 | PRJEB49404_P_NODE_579404_length_163_cov_2.201613_g565603_i0 | PRJEB49404 | 579404 | 163 | 2.201613 | 3.58862919 | Anaeromyxobacter sp. | 1872521 | Bacteria | Bacteria | 43.9 | 0.00235 | NR | HTN53639.1 | 1872521 | g565603 | i0 | 42 | 0.920245398773006 | 50 | 29 | 92 | 0 | 154 | 5 | 40 | 89 | HTN53639.1 hypothetical protein [Anaeromyxobacter sp.] | diamond | 150 | 43.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Anaeromyxobacteraceae | Anaeromyxobacter | Anaeromyxobacter sp. | ||
| 27728907 | 27728907 | PRJEB49404_P_NODE_581384_length_163_cov_1.322581_g567583_i0 | PRJEB49404 | 581384 | 163 | 1.322581 | 2.15580703 | Anaeromyxobacteraceae bacterium | 2510643 | Bacteria | Bacteria | 90.5 | 6.1e-21 | NR | HTP25508.1 | 2510643 | g567583 | i0 | 83.3 | 0.993865030674847 | 54 | 9 | 99.4 | 0 | 162 | 1 | 51 | 104 | HTP25508.1 HdeD family acid-resistance protein [Anaeromyxobacteraceae bacterium] | diamond | 162 | 90.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Anaeromyxobacteraceae | Anaeromyxobacteraceae bacterium | |||
| 28454925 | 28454925 | PRJEB49404_P_NODE_581426_length_163_cov_1.322581_g567625_i0 | PRJEB49404 | 581426 | 163 | 1.322581 | 2.15580703 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 85.9 | 7.64e-18 | NR | MEO8979435.1 | 2268199 | g567625 | i0 | 71.7 | 1.95092024539877 | 53 | 15 | 97.5 | 0 | 3 | 161 | 290 | 342 | MEO8979435.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 318 | 85.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 28985066 | 28985066 | PRJEB49404_P_NODE_446748_length_197_cov_1.905063_g432947_i0 | PRJEB49404 | 446748 | 197 | 1.905063 | 3.75297411 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 96.3 | 2.85e-21 | NR | WP_140792499.1 | 34 | g432947 | i0 | 73.8 | 1.97969543147208 | 65 | 17 | 99 | 0 | 197 | 3 | 45 | 109 | WP_140792499.1 UvrD-helicase domain-containing protein [Myxococcus xanthus] | diamond | 390 | 96.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcus | Myxococcus xanthus | ||
| 29401949 | 29401949 | PRJEB49404_P_NODE_642689_length_151_cov_2.205357_g628888_i0 | PRJEB49404 | 642689 | 151 | 2.205357 | 3.33008907 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 47.4 | 2.5e-4 | NR | MDR3135167.1 | 2026735 | g628888 | i0 | 41.2 | 2.94039735099338 | 51 | 29 | 99.3 | 1 | 1 | 150 | 212 | 262 | MDR3135167.1 TraM recognition domain-containing protein [Deltaproteobacteria bacterium] | diamond | 444 | 47.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29528335 | 29528335 | PRJEB49404_P_NODE_504730_length_180_cov_3.000000_g490929_i0 | PRJEB49404 | 504730 | 180 | 3 | 5.4 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 47.8 | 2.68e-4 | NR | MEM7153912.1 | 2818507 | g490929 | i0 | 42.9 | 0.816666666666667 | 49 | 28 | 81.7 | 0 | 27 | 173 | 419 | 467 | MEM7153912.1 tetratricopeptide repeat protein [Myxococcota bacterium] | diamond | 147 | 47.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 30507492 | 30507492 | PRJEB49404_P_NODE_383093_length_221_cov_1.208791_g369292_i0 | PRJEB49404 | 383093 | 221 | 1.208791 | 2.67142811 | Polyangia bacterium | 3058050 | Bacteria | Bacteria | 63.9 | 8.95e-11 | NR | MFL5308085.1 | 3058050 | g369292 | i0 | 58.7 | 0.624434389140271 | 46 | 19 | 62.4 | 0 | 220 | 83 | 87 | 132 | MFL5308085.1 hypothetical protein [Polyangia bacterium] | diamond | 138 | 63.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangia bacterium | ||||||
| 30602115 | 30602115 | PRJEB49404_P_NODE_637673_length_152_cov_1.858407_g623872_i0 | PRJEB49404 | 637673 | 152 | 1.858407 | 2.82477864 | Archangium violaceum | 83451 | Bacteria | Bacteria | 87 | 4.9900000000000006e-21 | NR | WP_204224780.1 | 83451 | g623872 | i0 | 72 | 0.986842105263158 | 50 | 14 | 98.7 | 0 | 150 | 1 | 19 | 68 | WP_204224780.1 hypothetical protein [Archangium violaceum] | diamond | 150 | 87 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium violaceum | ||
| 30879831 | 30879831 | PRJEB49404_P_NODE_637094_length_152_cov_2.176991_g623293_i0 | PRJEB49404 | 637094 | 152 | 2.176991 | 3.30902632 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 79.3 | 1.34e-15 | NR | MBV8137665.1 | 2026735 | g623293 | i0 | 70 | 1.97368421052632 | 50 | 15 | 98.7 | 0 | 2 | 151 | 276 | 325 | MBV8137665.1 FdhF/YdeP family oxidoreductase [Deltaproteobacteria bacterium] | diamond | 300 | 79.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31038174 | 31038174 | PRJEB49404_P_NODE_621875_length_155_cov_1.767241_g608074_i0 | PRJEB49404 | 621875 | 155 | 1.767241 | 2.73922355 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 100 | 5.059999999999999e-23 | NR | WP_407759337.1 | 1872627 | g608074 | i0 | 94.1 | 10.858064516129 | 51 | 3 | 98.7 | 0 | 153 | 1 | 524 | 574 | WP_407759337.1 VPS10 domain-containing protein [Archangium sp.] | diamond | 1683 | 101 | 0.99009900990099 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium sp. | ||
| 31234002 | 31234002 | PRJEB49404_P_NODE_406395_length_211_cov_2.226744_g392594_i0 | PRJEB49404 | 406395 | 211 | 2.226744 | 4.69842984 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 95.5 | 6.3e-21 | NR | HEV3190874.1 | 2268199 | g392594 | i0 | 65.7 | 1.90521327014218 | 67 | 23 | 95.3 | 0 | 9 | 209 | 666 | 732 | HEV3190874.1 thioesterase domain-containing protein [Polyangiaceae bacterium] | diamond | 402 | 95.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 31582253 | 31582253 | PRJEB49404_P_NODE_585036_length_162_cov_1.804878_g571235_i0 | PRJEB49404 | 585036 | 162 | 1.804878 | 2.92390236 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 91.3 | 7.66e-21 | NR | HEX2733546.1 | 2268199 | g571235 | i0 | 80.8 | 5.7037037037037 | 52 | 10 | 96.3 | 0 | 159 | 4 | 91 | 142 | HEX2733546.1 PAS domain S-box protein [Polyangiaceae bacterium] | diamond | 924 | 91.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 31670242 | 31670242 | PRJEB49404_P_NODE_605377_length_158_cov_1.722689_g591576_i0 | PRJEB49404 | 605377 | 158 | 1.722689 | 2.72184862 | Myxococcia | 32015 | Bacteria | Bacteria | 87.8 | 3.71e-19 | NR | WP_203407045.1 | 83451 | g591576 | i0 | 73.1 | 5.88607594936709 | 52 | 14 | 98.7 | 0 | 2 | 157 | 121 | 172 | WP_203407045.1 hypothetical protein [Archangium violaceum] | diamond | 930 | 87.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium violaceum | ||
| 31993314 | 31993314 | PRJEB49404_P_NODE_511158_length_179_cov_1.207143_g497357_i0 | PRJEB49404 | 511158 | 179 | 1.207143 | 2.16078597 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 96.3 | 3.24e-22 | NR | HYV65733.1 | 2026763 | g497357 | i0 | 79.7 | 1.97765363128492 | 59 | 12 | 98.9 | 0 | 177 | 1 | 55 | 113 | HYV65733.1 LysR family transcriptional regulator [Myxococcales bacterium] | diamond | 354 | 96.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 31993316 | 31993316 | PRJEB49404_P_NODE_529238_length_174_cov_2.296296_g515437_i0 | PRJEB49404 | 529238 | 174 | 2.296296 | 3.99555504 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 92.8 | 3.33e-20 | NR | HEY5243061.1 | 2268199 | g515437 | i0 | 78.9 | 1.96551724137931 | 57 | 12 | 98.3 | 0 | 173 | 3 | 290 | 346 | HEY5243061.1 amidohydrolase family protein [Polyangiaceae bacterium] | diamond | 342 | 92.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 32088251 | 32088251 | PRJEB49404_P_NODE_445358_length_198_cov_1.031447_g431557_i0 | PRJEB49404 | 445358 | 198 | 1.031447 | 2.04226506 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 111 | 7.68e-30 | NR | MBI3758645.1 | 2026735 | g431557 | i0 | 100 | 0.803030303030303 | 53 | 0 | 80.3 | 0 | 2 | 160 | 62 | 114 | MBI3758645.1 MaoC family dehydratase N-terminal domain-containing protein [Deltaproteobacteria bacterium] | diamond | 159 | 111 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32524872 | 32524872 | PRJEB49404_P_NODE_583059_length_163_cov_0.991935_g569258_i0 | PRJEB49404 | 583059 | 163 | 0.991935 | 1.61685405 | Myxococcia | 32015 | Bacteria | Bacteria | 93.6 | 1.49e-20 | NR | MBK6695529.1 | 2026763 | g569258 | i0 | 81.1 | 1.95092024539877 | 53 | 9 | 97.5 | 1 | 161 | 3 | 555 | 606 | MBK6695529.1 TIGR04551 family protein [Myxococcales bacterium] | diamond | 318 | 94.4 | 0.991525423728813 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 32751804 | 32751804 | PRJEB49404_P_NODE_424180_length_205_cov_1.343373_g410379_i0 | PRJEB49404 | 424180 | 205 | 1.343373 | 2.75391465 | Cystobacter ferrugineus | 83449 | Bacteria | Bacteria | 67 | 6.1e-11 | NR | WP_143177954.1 | 83449 | g410379 | i0 | 51.5 | 0.995121951219512 | 68 | 31 | 98 | 2 | 3 | 203 | 491 | 557 | WP_143177954.1 sensor histidine kinase [Cystobacter ferrugineus] | diamond | 204 | 67 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Cystobacter | Cystobacter ferrugineus | ||
| 32751806 | 32751806 | PRJEB49404_P_NODE_442920_length_198_cov_2.515723_g429119_i0 | PRJEB49404 | 442920 | 198 | 2.515723 | 4.98113154 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 102 | 1.43e-23 | NR | TMB32751.1 | 2026735 | g429119 | i0 | 75.4 | 0.984848484848485 | 65 | 16 | 98.5 | 0 | 197 | 3 | 673 | 737 | TMB32751.1 MAG: PAS domain S-box protein [Deltaproteobacteria bacterium] | diamond | 195 | 102 | 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);;