contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA753704" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16033618 | 16033618 | PRJNA753704_P_NODE_17233_length_290_cov_1.870968_g16872_i0 | PRJNA753704 | 17233 | 290 | 1.870968 | 5.4258072 | Myxococcaceae bacterium | 2484252 | Bacteria | Bacteria | 179 | 5.71e-53 | NR | RYZ13579.1 | 2484252 | g16872 | i0 | 92.7 | 0.993103448275862 | 96 | 7 | 99.3 | 0 | 1 | 288 | 186 | 281 | RYZ13579.1 MAG: ABC-F family ATP-binding cassette domain-containing protein, partial [Myxococcaceae bacterium] | diamond | 288 | 179 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcaceae bacterium | |||
| 24957619 | 24957619 | PRJNA753704_P_NODE_24060_length_252_cov_0.871508_g23699_i0 | PRJNA753704 | 24060 | 252 | 0.871508 | 2.19620016 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 110 | 4.3e-28 | NR | MBK8216004.1 | 2026763 | g23699 | i0 | 75.3 | 1.92857142857143 | 81 | 18 | 94 | 1 | 237 | 1 | 4 | 84 | MBK8216004.1 hypothetical protein [Myxococcales bacterium] | diamond | 486 | 110 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 27094329 | 27094329 | PRJNA753704_P_NODE_27902_length_243_cov_0.917647_g27541_i0 | PRJNA753704 | 27902 | 243 | 0.917647 | 2.22988221 | PVC group | 1783257 | Bacteria | Bacteria | 43.1 | 0.0276 | NR | MBI3295692.1 | 2026735 | g27541 | i0 | 46 | 2.28395061728395 | 63 | 32 | 75.3 | 2 | 58 | 240 | 79 | 141 | MBI3295692.1 LamG domain-containing protein [Deltaproteobacteria bacterium] | diamond | 555 | 43.5 | 0.990804597701149 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 27147278 | 27147278 | PRJNA753704_P_NODE_17102_length_291_cov_1.954128_g16741_i0 | PRJNA753704 | 17102 | 291 | 1.954128 | 5.68651248 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 124 | 7.52e-33 | NR | MBP6743406.1 | 2026735 | g16741 | i0 | 67 | 1 | 97 | 32 | 100 | 0 | 1 | 291 | 85 | 181 | MBP6743406.1 Crp/Fnr family transcriptional regulator [Deltaproteobacteria bacterium] | diamond | 291 | 124 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 27526840 | 27526840 | PRJNA753704_P_NODE_24883_length_250_cov_0.881356_g24522_i0 | PRJNA753704 | 24883 | 250 | 0.881356 | 2.20339 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 140 | 3.31e-38 | NR | MBK6463553.1 | 2026763 | g24522 | i0 | 89.2 | 0.996 | 83 | 9 | 99.6 | 0 | 250 | 2 | 226 | 308 | MBK6463553.1 hypothetical protein [Myxococcales bacterium] | diamond | 249 | 140 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 27716681 | 27716681 | PRJNA753704_P_NODE_16184_length_299_cov_1.380531_g15823_i0 | PRJNA753704 | 16184 | 299 | 1.380531 | 4.12778769 | Polyangia bacterium | 3058050 | Bacteria | Bacteria | 46.6 | 0.00196 | NR | HJZ87591.1 | 3058050 | g15823 | i0 | 36 | 3.561872909699 | 89 | 50 | 89.3 | 2 | 1 | 267 | 56 | 137 | HJZ87591.1 class I SAM-dependent methyltransferase [Polyangia bacterium] | diamond | 1065 | 46.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangia bacterium | ||||||
| 27811235 | 27811235 | PRJNA753704_P_NODE_8644_length_397_cov_5.240741_g8283_i0 | PRJNA753704 | 8644 | 397 | 5.240741 | 20.80574177 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 108 | 1.13e-24 | NR | MBK8256631.1 | 2268199 | g8283 | i0 | 47.9 | 1.82871536523929 | 121 | 44 | 89.9 | 2 | 39 | 395 | 190 | 293 | MBK8256631.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 726 | 108 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 28379326 | 28379326 | PRJNA753704_P_NODE_21466_length_263_cov_2.410526_g21105_i0 | PRJNA753704 | 21466 | 263 | 2.410526 | 6.33968338 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 97.4 | 1.87e-21 | NR | MCA9614681.1 | 2026763 | g21105 | i0 | 80.6 | 0.76425855513308 | 67 | 13 | 76.4 | 0 | 202 | 2 | 3 | 69 | MCA9614681.1 group II intron reverse transcriptase/maturase [Myxococcales bacterium] | diamond | 201 | 97.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 28568737 | 28568737 | PRJNA753704_P_NODE_14387_length_315_cov_1.933884_g14026_i0 | PRJNA753704 | 14387 | 315 | 1.933884 | 6.0917346 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 43.5 | 0.0472 | NR | MEB2310636.1 | 2268199 | g14026 | i0 | 30.6 | 0.685714285714286 | 72 | 45 | 65.7 | 3 | 292 | 86 | 1200 | 1269 | MEB2310636.1 MopE-related protein [Polyangiaceae bacterium] | diamond | 216 | 43.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 28663618 | 28663618 | PRJNA753704_P_NODE_26487_length_246_cov_0.901734_g26126_i0 | PRJNA753704 | 26487 | 246 | 0.901734 | 2.21826564 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 50.1 | 9.63e-5 | NR | MBI2375101.1 | 2026735 | g26126 | i0 | 70 | 0.365853658536585 | 30 | 9 | 36.6 | 0 | 242 | 153 | 364 | 393 | MBI2375101.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 90 | 50.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29200466 | 29200466 | PRJNA753704_P_NODE_15829_length_302_cov_1.213974_g15468_i0 | PRJNA753704 | 15829 | 302 | 1.213974 | 3.66620148 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 115 | 2.59e-29 | NR | NOU29347.1 | 2268199 | g15468 | i0 | 87.9 | 0.655629139072848 | 66 | 8 | 65.6 | 0 | 198 | 1 | 1 | 66 | NOU29347.1 50S ribosomal protein L1 [Polyangiaceae bacterium] | diamond | 198 | 115 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 29841660 | 29841660 | PRJNA753704_P_NODE_27371_length_244_cov_0.912281_g27010_i0 | PRJNA753704 | 27371 | 244 | 0.912281 | 2.22596564 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 110 | 3.96e-26 | NR | WP_104977573.1 | 56 | g27010 | i0 | 69.1 | 12.9467213114754 | 81 | 25 | 99.6 | 0 | 2 | 244 | 116 | 196 | WP_104977573.1 PLP-dependent aminotransferase family protein [Sorangium cellulosum] | diamond | 3159 | 111 | 0.990990990990991 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Sorangium | Sorangium cellulosum | |||
| 29936491 | 29936491 | PRJNA753704_P_NODE_25671_length_248_cov_0.891429_g25310_i0 | PRJNA753704 | 25671 | 248 | 0.891429 | 2.21074392 | Myxococcia | 32015 | Bacteria | Bacteria | 71.2 | 2.87e-12 | NR | MCA9695264.1 | 2026763 | g25310 | i0 | 44.9 | 2.41935483870968 | 69 | 38 | 83.5 | 0 | 208 | 2 | 255 | 323 | MCA9695264.1 hypothetical protein [Myxococcales bacterium] | diamond | 600 | 71.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 30062616 | 30062616 | PRJNA753704_P_NODE_23591_length_253_cov_0.866667_g23230_i0 | PRJNA753704 | 23591 | 253 | 0.866667 | 2.19266751 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 76.3 | 6.83e-14 | NR | MCB9729663.1 | 2026735 | g23230 | i0 | 49.4 | 4.54150197628458 | 77 | 34 | 91.3 | 2 | 249 | 19 | 279 | 350 | MCB9729663.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 1149 | 77 | 0.990909090909091 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 30115986 | 30115986 | PRJNA753704_P_NODE_25812_length_248_cov_0.891429_g25451_i0 | PRJNA753704 | 25812 | 248 | 0.891429 | 2.21074392 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 92 | 1.3e-19 | NR | MBL8613345.1 | 2026763 | g25451 | i0 | 56.3 | 0.967741935483871 | 80 | 35 | 96.8 | 0 | 245 | 6 | 88 | 167 | MBL8613345.1 hypothetical protein [Myxococcales bacterium] | diamond | 240 | 92 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 30274346 | 30274346 | PRJNA753704_P_NODE_26472_length_246_cov_0.901734_g26111_i0 | PRJNA753704 | 26472 | 246 | 0.901734 | 2.21826564 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 108 | 3.64e-25 | NR | MBI5512447.1 | 2026735 | g26111 | i0 | 63.6 | 0.939024390243902 | 77 | 27 | 93.9 | 1 | 7 | 237 | 331 | 406 | MBI5512447.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 231 | 108 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31453360 | 31453360 | PRJNA753704_P_NODE_19636_length_274_cov_1.552239_g19275_i0 | PRJNA753704 | 19636 | 274 | 1.552239 | 4.25313486 | Bacteria | 2 | Bacteria | Bacteria | 132 | 1.01e-34 | NR | MBL9003528.1 | 2026763 | g19275 | i0 | 65.9 | 3.97445255474453 | 91 | 28 | 96.4 | 1 | 266 | 3 | 167 | 257 | MBL9003528.1 DUF1588 domain-containing protein [Myxococcales bacterium] | diamond | 1089 | 132 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 31453364 | 31453364 | PRJNA753704_P_NODE_5696_length_479_cov_1.068966_g5335_i0 | PRJNA753704 | 5696 | 479 | 1.068966 | 5.12034714 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 61.2 | 1.73e-7 | NR | PZR12840.1 | 48 | g5335 | i0 | 41 | 6.36951983298539 | 139 | 70 | 84.6 | 6 | 3 | 407 | 1031 | 1161 | PZR12840.1 MAG: hypothetical protein DI536_14880 [Archangium gephyra] | diamond | 3051 | 61.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium gephyra | ||
| 31516684 | 31516684 | PRJNA753704_P_NODE_16436_length_297_cov_1.071429_g16075_i0 | PRJNA753704 | 16436 | 297 | 1.071429 | 3.18214413 | Haliangium | 162027 | Bacteria | Bacteria | 147 | 5.61e-41 | NR | WP_088740697.1 | 1931276 | g16075 | i0 | 74.5 | 3.95959595959596 | 98 | 25 | 99 | 0 | 3 | 296 | 203 | 300 | WP_088740697.1 phage tail protein [Haliangium sp. UPWRP_2] | diamond | 1176 | 147 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Haliangium | Haliangium sp. UPWRP_2 | |||
| 32234540 | 32234540 | PRJNA753704_P_NODE_25598_length_248_cov_0.891429_g25237_i0 | PRJNA753704 | 25598 | 248 | 0.891429 | 2.21074392 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 101 | 2.21e-25 | NR | MBL9107009.1 | 2026763 | g25237 | i0 | 65.9 | 0.991935483870968 | 82 | 27 | 99.2 | 1 | 246 | 1 | 19 | 99 | MBL9107009.1 biopolymer transporter ExbD [Myxococcales bacterium] | diamond | 246 | 101 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 32582369 | 32582369 | PRJNA753704_P_NODE_19199_length_277_cov_1.294118_g18838_i0 | PRJNA753704 | 19199 | 277 | 1.294118 | 3.58470686 | Pyxidicoccus caerfyrddinensis | 2709663 | Bacteria | Bacteria | 48.5 | 4.4e-4 | NR | WP_205519457.1 | 2709663 | g18838 | i0 | 33 | 1.01805054151625 | 94 | 48 | 92.1 | 3 | 257 | 3 | 51 | 138 | WP_205519457.1 Hint domain-containing protein [Pyxidicoccus caerfyrddinensis] | diamond | 282 | 48.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Pyxidicoccus | Pyxidicoccus caerfyrddinensis | ||
| 32582370 | 32582370 | PRJNA753704_P_NODE_20779_length_267_cov_1.608247_g20418_i0 | PRJNA753704 | 20779 | 267 | 1.608247 | 4.29401949 | Myxococcaceae bacterium | 2484252 | Bacteria | Bacteria | 92.8 | 1.3e-19 | NR | RYZ17952.1 | 2484252 | g20418 | i0 | 51.1 | 0.98876404494382 | 88 | 43 | 98.9 | 0 | 267 | 4 | 1233 | 1320 | RYZ17952.1 MAG: DUF3385 domain-containing protein, partial [Myxococcaceae bacterium] | diamond | 264 | 92.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcaceae bacterium | |||
| 32865545 | 32865545 | PRJNA753704_P_NODE_16640_length_295_cov_1.612613_g16279_i0 | PRJNA753704 | 16640 | 295 | 1.612613 | 4.75720835 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 106 | 1.1e-25 | NR | MEZ4315725.1 | 2268199 | g16279 | i0 | 54 | 0.884745762711864 | 87 | 40 | 88.5 | 0 | 262 | 2 | 30 | 116 | MEZ4315725.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 261 | 106 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae 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);;