contig_metadata
26 rows where bioproject = "PRJNA546018", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 510643 | 510643 | PRJNA546018_S_NODE_11841_length_495_cov_2.470046_g11517_i0 | PRJNA546018 | 11841 | 495 | 2.470046 | 12.2267277 | Myxococcus sp. MxC21-1 | 3041439 | Bacteria | Bacteria | 278 | 7.32e-70 | NTclustered | gi|2592002496|gb|CP123278.1| | 3041439 | g11517 | i0 | 78.125 | 9.54545454545454 | 448 | 90 | 90 | 7 | 20 | 463 | 4140688 | 4141131 | Myxococcus sp. MxC21-1 chromosome, complete genome | blastn | 4725 | 278 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcus | Myxococcus sp. MxC21-1 | ||
| 510964 | 510964 | PRJNA546018_S_NODE_33901_length_267_cov_1.893204_g33576_i0 | PRJNA546018 | 33901 | 267 | 1.893204 | 5.05485468 | Archangium gephyra | 48 | Bacteria | Bacteria | 113 | 1.1e-20 | NTclustered | gi|2809295724|gb|CP102578.1| | 48 | g33576 | i0 | 84.167 | 1.25468164794007 | 120 | 15 | 44 | 4 | 9 | 126 | 8620833 | 8620950 | Archangium gephyra strain SDU49 chromosome, complete genome | blastn | 335 | 113 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium gephyra | ||
| 4337579 | 4337579 | PRJNA546018_S_NODE_10724_length_525_cov_3.437500_g10401_i0 | PRJNA546018 | 10724 | 525 | 3.4375 | 18.046875 | root | 1 | Root_unresolved | Root_unresolved | 189 | 6.25e-58 | NR | WP_002619414.1 | 41 | g10401 | i0 | 71.1 | 11.1428571428571 | 128 | 36 | 73.1 | 1 | 506 | 123 | 45 | 171 | WP_002619414.1 peptidylprolyl isomerase [Stigmatella aurantiaca] | diamond | 5850 | 190 | 0.994736842105263 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Stigmatella | Stigmatella aurantiaca | ||
| 6888470 | 6888470 | PRJNA546018_S_NODE_23446_length_330_cov_8.197026_g23121_i0 | PRJNA546018 | 23446 | 330 | 8.197026 | 27.0501858 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 55.8 | 2.39e-6 | NR | MEE8474660.1 | 2818507 | g23121 | i0 | 44 | 1.31818181818182 | 75 | 31 | 65.5 | 3 | 305 | 90 | 347 | 413 | MEE8474660.1 sulfotransferase [Myxococcota bacterium] | diamond | 435 | 55.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 8163661 | 8163661 | PRJNA546018_S_NODE_25487_length_315_cov_2.877953_g25162_i0 | PRJNA546018 | 25487 | 315 | 2.877953 | 9.06555195 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 148 | 1.45e-39 | NR | MBM4370444.1 | 2026735 | g25162 | i0 | 75 | 1.75238095238095 | 92 | 23 | 87.6 | 0 | 17 | 292 | 221 | 312 | MBM4370444.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 552 | 148 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 8163898 | 8163898 | PRJNA546018_S_NODE_39767_length_244_cov_1.770492_g39442_i0 | PRJNA546018 | 39767 | 244 | 1.770492 | 4.32000048 | Myxococcus fulvus | 33 | Bacteria | Bacteria | 368 | 1.92e-97 | NTclustered | gi|817709775|gb|CP006003.1| | 1334629 | g39442 | i0 | 96.413 | 3.66803278688525 | 223 | 8 | 91 | 0 | 22 | 244 | 2617290 | 2617512 | Myxococcus fulvus 124B02, complete genome | blastn | 895 | 368 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcus | Myxococcus fulvus | ||
| 8163920 | 8163920 | PRJNA546018_S_NODE_40867_length_241_cov_1.961111_g40542_i0 | PRJNA546018 | 40867 | 241 | 1.961111 | 4.72627751 | Anaeromyxobacter paludicola | 2918171 | Bacteria | Bacteria | 161 | 3.45e-35 | NTclustered | gi|2199271117|dbj|AP025592.1| | 2918171 | g40542 | i0 | 82.703 | 41.9211618257261 | 185 | 28 | 76 | 4 | 51 | 234 | 1112064 | 1112245 | Anaeromyxobacter paludicola DNA, complete genome | blastn | 10103 | 161 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Anaeromyxobacteraceae | Anaeromyxobacter | Anaeromyxobacter paludicola | ||
| 8164143 | 8164143 | PRJNA546018_S_NODE_53807_length_207_cov_2.479452_g53482_i0 | PRJNA546018 | 53807 | 207 | 2.479452 | 5.13246564 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 99.4 | 1.2e-23 | NR | MCE9574917.1 | 2026735 | g53482 | i0 | 82 | 6.18840579710145 | 61 | 11 | 88.4 | 0 | 24 | 206 | 122 | 182 | MCE9574917.1 SDR family oxidoreductase [Deltaproteobacteria bacterium] | diamond | 1281 | 99.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 10715223 | 10715223 | PRJNA546018_S_NODE_40809_length_241_cov_2.711111_g40484_i0 | PRJNA546018 | 40809 | 241 | 2.711111 | 6.53377751 | Myxococcus fulvus | 33 | Bacteria | Bacteria | 252 | 1.99e-62 | NTclustered | gi|2869653495|gb|CP175551.1| | 33 | g40484 | i0 | 89.796 | 20.0829875518672 | 196 | 20 | 81 | 0 | 22 | 217 | 821643 | 821448 | Myxococcus fulvus strain KYC1117 chromosome, complete genome | blastn | 4840 | 252 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcus | Myxococcus fulvus | ||
| 10715593 | 10715593 | PRJNA546018_S_NODE_9469_length_564_cov_6.192843_g9150_i0 | PRJNA546018 | 9469 | 564 | 6.192843 | 34.92763452 | Myxococcus landrumensis | 2813577 | Bacteria | Bacteria | 580 | 5.729999999999999e-161 | NTclustered | gi|1998497960|gb|CP071091.1| | 2813577 | g9150 | i0 | 86.213 | 10.5620567375887 | 544 | 65 | 96 | 10 | 3 | 541 | 5170267 | 5169729 | Myxococcus landrumus strain SCHIC003 chromosome | blastn | 5957 | 580 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcus | Myxococcus landrumensis | ||
| 11322152 | 11322152 | PRJNA546018_S_NODE_11489_length_504_cov_2.573363_g11165_i0 | PRJNA546018 | 11489 | 504 | 2.573363 | 12.96974952 | Myxococcus | 32 | Bacteria | Bacteria | 665 | 0 | NTclustered | gi|2869653495|gb|CP175551.1| | 33 | g11165 | i0 | 92.81 | 43.2579365079365 | 459 | 33 | 91 | 0 | 20 | 478 | 10226377 | 10226835 | Myxococcus fulvus strain KYC1117 chromosome, complete genome | blastn | 21802 | 671 | 0.991058122205663 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcus | Myxococcus fulvus | ||
| 11989631 | 11989631 | PRJNA546018_S_NODE_25170_length_317_cov_4.867188_g24845_i0 | PRJNA546018 | 25170 | 317 | 4.867188 | 15.42898596 | Sandaracinus amylolyticus | 927083 | Bacteria | Bacteria | 270 | 7.529999999999999e-68 | NTclustered | gi|816953346|gb|CP011125.1| | 927083 | g24845 | i0 | 86.694 | 1.80441640378549 | 248 | 27 | 77 | 5 | 24 | 268 | 1348725 | 1348969 | Sandaracinus amylolyticus strain DSM 53668, complete genome | blastn | 572 | 270 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Sandaracinaceae | Sandaracinus | Sandaracinus amylolyticus | |||
| 11989702 | 11989702 | PRJNA546018_S_NODE_28970_length_292_cov_8.766234_g28645_i0 | PRJNA546018 | 28970 | 292 | 8.766234 | 25.59740328 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 176 | 1.4e-49 | NR | MBA3451750.1 | 2026735 | g28645 | i0 | 97.7 | 0.893835616438356 | 87 | 2 | 89.4 | 0 | 284 | 24 | 196 | 282 | MBA3451750.1 GAF domain-containing protein [Deltaproteobacteria bacterium] | diamond | 261 | 176 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 17697199 | 17697199 | PRJNA546018_S_NODE_41394_length_239_cov_1.859551_g41069_i0 | PRJNA546018 | 41394 | 239 | 1.859551 | 4.44432689 | Myxococcus | 32 | Bacteria | Bacteria | 259 | 1.18e-64 | NTclustered | gi|2722781719|gb|CP102770.1| | 83455 | g41069 | i0 | 88.073 | 14.5564853556485 | 218 | 26 | 91 | 0 | 1 | 218 | 5982549 | 5982766 | Myxococcus stipitatus strain YRE12 chromosome, complete genome | blastn | 3479 | 259 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcus | Myxococcus stipitatus | ||
| 23463711 | 23463711 | PRJNA546018_S_NODE_6939_length_679_cov_1.852751_g6651_i0 | PRJNA546018 | 6939 | 679 | 1.852751 | 12.58017929 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 328 | 1.32e-109 | NR | MBL8682022.1 | 2026763 | g6651 | i0 | 72.7 | 3.87481590574374 | 220 | 59 | 96.8 | 1 | 678 | 22 | 112 | 331 | MBL8682022.1 pyruvate dehydrogenase complex E1 component subunit beta [Myxococcales bacterium] | diamond | 2631 | 328 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 27962311 | 27962311 | PRJNA546018_S_NODE_26845_length_306_cov_2.665306_g26520_i0 | PRJNA546018 | 26845 | 306 | 2.665306 | 8.15583636 | Polyangiales bacterium | 3034171 | Bacteria | Bacteria | 131 | 1.81e-33 | NR | MFO0562219.1 | 3034171 | g26520 | i0 | 74.7 | 0.852941176470588 | 87 | 21 | 85.3 | 1 | 283 | 23 | 282 | 367 | MFO0562219.1 hypothetical protein [Polyangiales bacterium] | diamond | 261 | 131 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiales bacterium | |||||
| 28229487 | 28229487 | PRJNA546018_S_NODE_11926_length_493_cov_2.159722_g11602_i0 | PRJNA546018 | 11926 | 493 | 2.159722 | 10.64742946 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 47.4 | 0.0116 | NR | HEY4179607.1 | 2212474 | g11602 | i0 | 42.6 | 0.967545638945233 | 54 | 31 | 32.9 | 0 | 486 | 325 | 1175 | 1228 | HEY4179607.1 alpha-2-macroglobulin family protein [Kofleriaceae bacterium] | diamond | 477 | 47.8 | 0.99163179916318 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 28545734 | 28545734 | PRJNA546018_S_NODE_11807_length_495_cov_14.880184_g11483_i0 | PRJNA546018 | 11807 | 495 | 14.880184 | 73.6569108 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 62 | 9.39e-8 | NR | WP_224193614.1 | 889268 | g11483 | i0 | 32.8 | 2.53939393939394 | 119 | 74 | 69.1 | 3 | 47 | 388 | 133 | 250 | WP_224193614.1 WD40 repeat domain-containing protein [Nannocystis pusilla] | diamond | 1257 | 62 | 1 | Bacteria | Pseudomonadati | Myxococcota | Nannocystales | Nannocystaceae | Nannocystis | Nannocystis pusilla | |||
| 28814526 | 28814526 | PRJNA546018_S_NODE_50188_length_214_cov_1.274510_g49863_i0 | PRJNA546018 | 50188 | 214 | 1.27451 | 2.7274514 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 77.4 | 7.48e-16 | NR | MBS2015896.1 | 2026735 | g49863 | i0 | 74.5 | 0.714953271028037 | 51 | 13 | 71.5 | 0 | 153 | 1 | 1 | 51 | MBS2015896.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 153 | 77.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29162361 | 29162361 | PRJNA546018_S_NODE_15789_length_416_cov_2.738028_g15464_i0 | PRJNA546018 | 15789 | 416 | 2.738028 | 11.39019648 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 120 | 3.93e-30 | NR | MBN8541789.1 | 2026735 | g15464 | i0 | 46.2 | 0.9375 | 130 | 70 | 93.8 | 0 | 17 | 406 | 87 | 216 | MBN8541789.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 390 | 120 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29730212 | 29730212 | PRJNA546018_S_NODE_29810_length_288_cov_1.444934_g29485_i0 | PRJNA546018 | 29810 | 288 | 1.444934 | 4.16140992 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 159 | 1.02e-44 | NR | HVR21206.1 | 2268199 | g29485 | i0 | 90 | 0.9375 | 90 | 9 | 93.8 | 0 | 270 | 1 | 248 | 337 | HVR21206.1 right-handed parallel beta-helix repeat-containing protein [Polyangiaceae bacterium] | diamond | 270 | 159 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 30187451 | 30187451 | PRJNA546018_S_NODE_49572_length_215_cov_3.610390_g49247_i0 | PRJNA546018 | 49572 | 215 | 3.61039 | 7.7623385 | Myxococcia | 32015 | Bacteria | Bacteria | 97.1 | 4.69e-22 | NR | WP_293254146.1 | 1962667 | g49247 | i0 | 89.6 | 2.0093023255814 | 48 | 5 | 67 | 0 | 213 | 70 | 290 | 337 | WP_293254146.1 DUF294 nucleotidyltransferase-like domain-containing protein [Nannocystis sp.] | diamond | 432 | 97.8 | 0.992842535787321 | Bacteria | Pseudomonadati | Myxococcota | Nannocystales | Nannocystaceae | Nannocystis | Nannocystis sp. | |||
| 30235887 | 30235887 | PRJNA546018_S_NODE_9512_length_563_cov_3.049801_g9193_i0 | PRJNA546018 | 9512 | 563 | 3.049801 | 17.17037963 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 90.1 | 1.44e-19 | NR | MEE2828568.1 | 2818507 | g9193 | i0 | 52.8 | 0.474245115452931 | 89 | 42 | 47.4 | 0 | 541 | 275 | 30 | 118 | MEE2828568.1 S-adenosylmethionine decarboxylase [Myxococcota bacterium] | diamond | 267 | 90.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 30850995 | 30850995 | PRJNA546018_S_NODE_49714_length_215_cov_1.779221_g49389_i0 | PRJNA546018 | 49714 | 215 | 1.779221 | 3.82532515 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 108 | 1.75e-25 | NR | MBN8539685.1 | 2026735 | g49389 | i0 | 82.8 | 1.78604651162791 | 64 | 11 | 89.3 | 0 | 24 | 215 | 458 | 521 | MBN8539685.1 tetratricopeptide repeat protein [Deltaproteobacteria bacterium] | diamond | 384 | 108 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32575847 | 32575847 | PRJNA546018_S_NODE_48119_length_219_cov_1.746835_g47794_i0 | PRJNA546018 | 48119 | 219 | 1.746835 | 3.82556865 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 107 | 1.75e-25 | NR | HEX6272685.1 | 2268199 | g47794 | i0 | 84.6 | 1.79452054794521 | 65 | 10 | 89 | 0 | 216 | 22 | 324 | 388 | HEX6272685.1 right-handed parallel beta-helix repeat-containing protein [Polyangiaceae bacterium] | diamond | 393 | 107 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 32795786 | 32795786 | PRJNA546018_S_NODE_23400_length_331_cov_1.714815_g23075_i0 | PRJNA546018 | 23400 | 331 | 1.714815 | 5.67603765 | Myxococcaceae bacterium | 2484252 | Bacteria | Bacteria | 73.2 | 2.21e-12 | NR | HEX4621222.1 | 2484252 | g23075 | i0 | 43.4 | 0.897280966767372 | 99 | 50 | 87 | 2 | 312 | 25 | 161 | 256 | HEX4621222.1 SDR family oxidoreductase [Myxococcaceae bacterium] | diamond | 297 | 73.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcaceae 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);;