contig_metadata
23 rows where bioproject = "PRJNA675331", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 647638 | 647638 | PRJNA675331_P_NODE_14341_length_275_cov_1.094059_g14169_i0 | PRJNA675331 | 14341 | 275 | 1.094059 | 3.00866225 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 115 | 2.82e-29 | NR | MBL9044146.1 | 2026763 | g14169 | i0 | 60.2 | 0.96 | 88 | 35 | 96 | 0 | 6 | 269 | 122 | 209 | MBL9044146.1 DUF1295 domain-containing protein [Myxococcales bacterium] | diamond | 264 | 115 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 5751294 | 5751294 | PRJNA675331_P_NODE_14985_length_271_cov_1.555556_g14813_i0 | PRJNA675331 | 14985 | 271 | 1.555556 | 4.21555676 | Anaeromyxobacter paludicola | 2918171 | Bacteria | Bacteria | 189 | 1.8199999999999998e-43 | NTclustered | gi|2199271117|dbj|AP025592.1| | 2918171 | g14813 | i0 | 88.199 | 99.7232472324723 | 161 | 15 | 59 | 4 | 30 | 188 | 1383715 | 1383557 | Anaeromyxobacter paludicola DNA, complete genome | blastn | 27025 | 189 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Anaeromyxobacteraceae | Anaeromyxobacter | Anaeromyxobacter paludicola | ||
| 26797105 | 26797105 | PRJNA675331_P_NODE_18181_length_251_cov_0.865169_g18009_i0 | PRJNA675331 | 18181 | 251 | 0.865169 | 2.17157419 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 94 | 3.86e-20 | NR | MDH5494061.1 | 2026763 | g18009 | i0 | 59 | 1.97211155378486 | 83 | 32 | 99.2 | 2 | 3 | 251 | 523 | 603 | MDH5494061.1 glutamate synthase-related protein [Myxococcales bacterium] | diamond | 495 | 94 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 27113351 | 27113351 | PRJNA675331_P_NODE_23682_length_242_cov_0.905325_g23510_i0 | PRJNA675331 | 23682 | 242 | 0.905325 | 2.1908865 | Polyangia bacterium | 3058050 | Bacteria | Bacteria | 42.4 | 0.0411 | NR | HVX94310.1 | 3058050 | g23510 | i0 | 30.8 | 0.805785123966942 | 65 | 44 | 80.6 | 1 | 237 | 43 | 109 | 172 | HVX94310.1 response regulator [Polyangia bacterium] | diamond | 195 | 42.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangia bacterium | ||||||
| 27492775 | 27492775 | PRJNA675331_P_NODE_17943_length_251_cov_1.466292_g17771_i0 | PRJNA675331 | 17943 | 251 | 1.466292 | 3.68039292 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 57 | 4.93e-8 | NR | MDF1564045.1 | 2026735 | g17771 | i0 | 47.5 | 1.45816733067729 | 61 | 32 | 72.9 | 0 | 37 | 219 | 45 | 105 | MDF1564045.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 366 | 57 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 27630979 | 27630979 | PRJNA675331_P_NODE_22324_length_244_cov_0.900585_g22152_i0 | PRJNA675331 | 22324 | 244 | 0.900585 | 2.1974274 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 55.5 | 1.22e-6 | NR | MFT3699646.1 | 2212474 | g22152 | i0 | 38.6 | 2.48360655737705 | 70 | 37 | 86.1 | 2 | 210 | 1 | 42 | 105 | MFT3699646.1 right-handed parallel beta-helix repeat-containing protein [Kofleriaceae bacterium] | diamond | 606 | 55.8 | 0.99462365591397806 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 27871554 | 27871554 | PRJNA675331_P_NODE_4525_length_446_cov_2.252011_g4353_i0 | PRJNA675331 | 4525 | 446 | 2.252011 | 10.04396906 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 46.2 | 0.0188 | NR | MBV70717.1 | 2026763 | g4353 | i0 | 34.1 | 0.571748878923767 | 85 | 53 | 55.8 | 2 | 40 | 288 | 504 | 587 | MBV70717.1 hypothetical protein [Myxococcales bacterium] | diamond | 255 | 46.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 28155945 | 28155945 | PRJNA675331_P_NODE_11365_length_299_cov_1.022124_g11193_i0 | PRJNA675331 | 11365 | 299 | 1.022124 | 3.05615076 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 58.2 | 2.79e-7 | NR | USN51927.1 | 2026763 | g11193 | i0 | 53.1 | 1.06354515050167 | 49 | 22 | 48.2 | 1 | 129 | 272 | 106 | 154 | USN51927.1 MAG: thrombospondin type 3 repeat-containing protein [Myxococcales bacterium] | diamond | 318 | 58.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 28881883 | 28881883 | PRJNA675331_P_NODE_18848_length_250_cov_0.870056_g18676_i0 | PRJNA675331 | 18848 | 250 | 0.870056 | 2.17514 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 99 | 1.7000000000000002e-22 | NR | MBL9099532.1 | 2026763 | g18676 | i0 | 57.8 | 2.988 | 83 | 35 | 99.6 | 0 | 1 | 249 | 148 | 230 | MBL9099532.1 bis-aminopropyl spermidine synthase family protein [Myxococcales bacterium] | diamond | 747 | 99 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 28976831 | 28976831 | PRJNA675331_P_NODE_8488_length_337_cov_0.875000_g8316_i0 | PRJNA675331 | 8488 | 337 | 0.875 | 2.94875 | Sorangium sp. | 2093377 | Bacteria | Bacteria | 50.4 | 2.01e-4 | NR | HTN92679.1 | 2093377 | g8316 | i0 | 61.5 | 5.63501483679525 | 39 | 14 | 34.7 | 1 | 2 | 118 | 199 | 236 | HTN92679.1 calcium-binding EGF-like domain-containing protein [Sorangium sp.] | diamond | 1899 | 50.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Sorangium | Sorangium sp. | |||
| 29481570 | 29481570 | PRJNA675331_P_NODE_11550_length_297_cov_1.031250_g11378_i0 | PRJNA675331 | 11550 | 297 | 1.03125 | 3.0628125 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 45.4 | 0.00475 | NR | MEI8258264.1 | 2026735 | g11378 | i0 | 35 | 0.606060606060606 | 60 | 36 | 60.6 | 1 | 60 | 239 | 130 | 186 | MEI8258264.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 180 | 45.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29607798 | 29607798 | PRJNA675331_P_NODE_16350_length_262_cov_1.629630_g16178_i0 | PRJNA675331 | 16350 | 262 | 1.62963 | 4.2696306 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 85.9 | 3.21e-17 | NR | HVW25011.1 | 2268199 | g16178 | i0 | 48.8 | 0.961832061068702 | 84 | 42 | 95 | 1 | 253 | 5 | 115 | 198 | HVW25011.1 EGF domain-containing protein [Polyangiaceae bacterium] | diamond | 252 | 85.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 29734174 | 29734174 | PRJNA675331_P_NODE_18910_length_250_cov_0.870056_g18738_i0 | PRJNA675331 | 18910 | 250 | 0.870056 | 2.17514 | Polyangia bacterium | 3058050 | Bacteria | Bacteria | 51.2 | 4.13e-5 | NR | HEX3696334.1 | 3058050 | g18738 | i0 | 54.3 | 0.552 | 46 | 18 | 55.2 | 1 | 218 | 81 | 120 | 162 | HEX3696334.1 calcium-binding EGF-like domain-containing protein [Polyangia bacterium] | diamond | 138 | 51.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangia bacterium | ||||||
| 29904285 | 29904285 | PRJNA675331_P_NODE_19691_length_248_cov_1.314286_g19519_i0 | PRJNA675331 | 19691 | 248 | 1.314286 | 3.25942928 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 53.1 | 8.73e-6 | NR | TFH25223.1 | 2026763 | g19519 | i0 | 35.8 | 5.21370967741935 | 81 | 43 | 87.1 | 2 | 217 | 2 | 454 | 534 | TFH25223.1 MAG: hypothetical protein E4H03_01420 [Myxococcales bacterium] | diamond | 1293 | 53.5 | 0.992523364485981 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 29924078 | 29924078 | PRJNA675331_P_NODE_2591_length_577_cov_0.916667_g2424_i0 | PRJNA675331 | 2591 | 577 | 0.916667 | 5.28916859 | Polyangiales bacterium | 3034171 | Bacteria | Bacteria | 202 | 4.28e-58 | NR | MFO0692508.1 | 3034171 | g2424 | i0 | 51.1 | 0.987868284228769 | 190 | 90 | 98.3 | 2 | 569 | 3 | 2 | 189 | MFO0692508.1 long-chain fatty acid--CoA ligase [Polyangiales bacterium] | diamond | 570 | 202 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiales bacterium | |||||
| 30081760 | 30081760 | PRJNA675331_P_NODE_22492_length_243_cov_2.588235_g22320_i0 | PRJNA675331 | 22492 | 243 | 2.588235 | 6.28941105 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 78.2 | 1.22e-14 | NR | MEC8023817.1 | 2818507 | g22320 | i0 | 49.4 | 0.975308641975309 | 79 | 38 | 97.5 | 2 | 242 | 6 | 576 | 652 | MEC8023817.1 hypothetical protein [Myxococcota bacterium] | diamond | 237 | 78.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 30113428 | 30113428 | PRJNA675331_P_NODE_12752_length_285_cov_2.122642_g12580_i0 | PRJNA675331 | 12752 | 285 | 2.122642 | 6.0495297 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 43.5 | 0.0322 | NR | NUN15889.1 | 2026763 | g12580 | i0 | 36.7 | 0.631578947368421 | 60 | 36 | 63.2 | 2 | 245 | 66 | 160 | 217 | NUN15889.1 hypothetical protein [Myxococcales bacterium] | diamond | 180 | 43.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 30461496 | 30461496 | PRJNA675331_P_NODE_1713_length_694_cov_1.607085_g1552_i0 | PRJNA675331 | 1713 | 694 | 1.607085 | 11.1531699 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 68.2 | 3.89e-9 | NR | MBK6461975.1 | 2026763 | g1552 | i0 | 37.1 | 0.501440922190202 | 116 | 55 | 49.7 | 4 | 652 | 308 | 655 | 753 | MBK6461975.1 DUF11 domain-containing protein [Myxococcales bacterium] | diamond | 348 | 68.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 30682003 | 30682003 | PRJNA675331_P_NODE_13753_length_277_cov_1.509804_g13581_i0 | PRJNA675331 | 13753 | 277 | 1.509804 | 4.18215708 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 58.9 | 1.18e-7 | NR | MBM65906.1 | 2026763 | g13581 | i0 | 35.9 | 1.11552346570397 | 103 | 43 | 89.9 | 4 | 261 | 13 | 739 | 838 | MBM65906.1 hypothetical protein [Myxococcales bacterium] | diamond | 309 | 58.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 30840226 | 30840226 | PRJNA675331_P_NODE_21654_length_245_cov_0.895349_g21482_i0 | PRJNA675331 | 21654 | 245 | 0.895349 | 2.19360505 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 43.5 | 0.0206 | NR | NVB84741.1 | 2212474 | g21482 | i0 | 34.1 | 1.00408163265306 | 82 | 34 | 94.3 | 2 | 8 | 238 | 28 | 94 | NVB84741.1 hypothetical protein [Kofleriaceae bacterium] | diamond | 246 | 43.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 31504204 | 31504204 | PRJNA675331_P_NODE_21796_length_245_cov_0.895349_g21624_i0 | PRJNA675331 | 21796 | 245 | 0.895349 | 2.19360505 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 70.9 | 4.85e-12 | NR | MCB9523155.1 | 2026763 | g21624 | i0 | 56.8 | 3.55102040816327 | 74 | 30 | 90.6 | 1 | 224 | 3 | 781 | 852 | MCB9523155.1 fasciclin domain-containing protein [Myxococcales bacterium] | diamond | 870 | 70.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 31662001 | 31662001 | PRJNA675331_P_NODE_8657_length_334_cov_1.160920_g8485_i0 | PRJNA675331 | 8657 | 334 | 1.16092 | 3.8774728 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 44.3 | 0.0324 | NR | MBP7125772.1 | 2818507 | g8485 | i0 | 63.3 | 0.269461077844311 | 30 | 10 | 26 | 1 | 324 | 238 | 115 | 144 | MBP7125772.1 hypothetical protein [Myxococcota bacterium] | diamond | 90 | 44.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 32654074 | 32654074 | PRJNA675331_P_NODE_3160_length_525_cov_1.190265_g2991_i0 | PRJNA675331 | 3160 | 525 | 1.190265 | 6.24889125 | root | 1 | Root_unresolved | Root_unresolved | 89.4 | 3.89e-17 | NR | WP_169927485.1 | 1391654 | g2991 | i0 | 41.5 | 2.01142857142857 | 118 | 64 | 65.7 | 5 | 525 | 181 | 255 | 370 | WP_169927485.1 MYXO-CTERM sorting domain-containing protein [Labilithrix luteola] | diamond | 1056 | 89.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix luteola |
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);;