contig_metadata
20 rows where bioproject = "PRJNA358490", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2949538 | 2949538 | PRJNA358490_P_NODE_12883_length_225_cov_1.483871_g12539_i0 | PRJNA358490 | 12883 | 225 | 1.483871 | 3.33870975 | Labilithrix luteola | 1391654 | Bacteria | Bacteria | 248 | 2.38e-61 | NTclustered | gi|913610804|gb|CP012333.1| | 1391654 | g12539 | i0 | 88.406 | 430.711111111111 | 207 | 23 | 92 | 1 | 1 | 206 | 7089168 | 7088962 | Labilithrix luteola strain DSM 27648, complete genome | blastn | 96910 | 248 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix luteola | |||
| 4226211 | 4226211 | PRJNA358490_P_NODE_2264_length_943_cov_3.959071_g2104_i0 | PRJNA358490 | 2264 | 943 | 3.959071 | 37.33403953 | Archangium gephyra | 48 | Bacteria | Bacteria | 268 | 8.7e-67 | NTclustered | gi|2809295724|gb|CP102578.1| | 48 | g2104 | i0 | 78.759 | 9.53022269353128 | 419 | 76 | 44 | 13 | 505 | 916 | 8322910 | 8322498 | Archangium gephyra strain SDU49 chromosome, complete genome | blastn | 8987 | 268 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium gephyra | ||
| 6776658 | 6776658 | PRJNA358490_P_NODE_17826_length_154_cov_1.417391_g17482_i0 | PRJNA358490 | 17826 | 154 | 1.417391 | 2.18278214 | Corallococcus exercitus | 2316736 | Bacteria | Bacteria | 176 | 7.189999999999999e-40 | NTclustered | gi|2809270164|gb|CP102577.1| | 2316736 | g17482 | i0 | 90.299 | 43.8311688311688 | 134 | 13 | 87 | 0 | 5 | 138 | 5503452 | 5503319 | Corallococcus exercitus strain SDU142 chromosome, complete genome | blastn | 6750 | 176 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Corallococcus | Corallococcus exercitus | ||
| 14427710 | 14427710 | PRJNA358490_P_NODE_11952_length_252_cov_1.131455_g11608_i0 | PRJNA358490 | 11952 | 252 | 1.131455 | 2.8512666 | Polyangia bacterium | 3058050 | Bacteria | Bacteria | 150 | 6.58e-40 | NR | HEY0707586.1 | 3058050 | g11608 | i0 | 84.3 | 0.988095238095238 | 83 | 13 | 98.8 | 0 | 2 | 250 | 123 | 205 | HEY0707586.1 excinuclease ABC subunit UvrA [Polyangia bacterium] | diamond | 249 | 150 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangia bacterium | ||||||
| 24625326 | 24625326 | PRJNA358490_P_NODE_6040_length_542_cov_2.170974_g5722_i0 | PRJNA358490 | 6040 | 542 | 2.170974 | 11.76667908 | Anaeromyxobacter sp. Fw109-5 | 404589 | Bacteria | Bacteria | 468 | 4.46e-127 | NTclustered | gi|152026452|gb|CP000769.1| | 404589 | g5722 | i0 | 82.505 | 100.160516605166 | 543 | 85 | 99 | 9 | 5 | 542 | 1321440 | 1320903 | Anaeromyxobacter sp. Fw109-5, complete genome | blastn | 54287 | 468 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Anaeromyxobacteraceae | Anaeromyxobacter | Anaeromyxobacter sp. Fw109-5 | ||
| 26631709 | 26631709 | PRJNA358490_P_NODE_12461_length_236_cov_1.228426_g12117_i0 | PRJNA358490 | 12461 | 236 | 1.228426 | 2.89908536 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 143 | 1.2e-37 | NR | MBS1118175.1 | 2026735 | g12117 | i0 | 82.1 | 0.991525423728814 | 78 | 14 | 99.2 | 0 | 236 | 3 | 266 | 343 | MBS1118175.1 Mannosyl oligosaccharide glucosidase [Deltaproteobacteria bacterium] | diamond | 234 | 143 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 26916670 | 26916670 | PRJNA358490_P_NODE_14622_length_188_cov_1.912752_g14278_i0 | PRJNA358490 | 14622 | 188 | 1.912752 | 3.59597376 | Pendulispora albinea | 2741071 | Bacteria | Bacteria | 95.1 | 6.230000000000001e-21 | NR | WP_394828725.1 | 2741071 | g14278 | i0 | 75.8 | 0.98936170212766 | 62 | 15 | 98.9 | 0 | 3 | 188 | 85 | 146 | WP_394828725.1 DUF262 domain-containing protein [Pendulispora albinea] | diamond | 186 | 95.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora albinea | ||
| 26948194 | 26948194 | PRJNA358490_P_NODE_5102_length_608_cov_3.007030_g4820_i0 | PRJNA358490 | 5102 | 608 | 3.00703 | 18.2827424 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 213 | 7.76e-65 | NR | HMJ56734.1 | 2268199 | g4820 | i0 | 55.2 | 0.902960526315789 | 183 | 81 | 90.3 | 1 | 568 | 20 | 118 | 299 | HMJ56734.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 549 | 213 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 27074837 | 27074837 | PRJNA358490_P_NODE_7222_length_473_cov_1.458525_g6888_i0 | PRJNA358490 | 7222 | 473 | 1.458525 | 6.89882325 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 84.3 | 1.08e-15 | NR | MES1176617.1 | 2026763 | g6888 | i0 | 87 | 0.875264270613108 | 46 | 6 | 29.2 | 0 | 1 | 138 | 381 | 426 | MES1176617.1 phosphoenolpyruvate kinase [Myxococcales bacterium] | diamond | 414 | 84.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 27169448 | 27169448 | PRJNA358490_P_NODE_16642_length_164_cov_1.288000_g16298_i0 | PRJNA358490 | 16642 | 164 | 1.288 | 2.11232 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 84.3 | 3.27e-19 | NR | HVJ21037.1 | 2268199 | g16298 | i0 | 68.5 | 0.98780487804878 | 54 | 17 | 98.8 | 0 | 163 | 2 | 45 | 98 | HVJ21037.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 162 | 84.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 27250018 | 27250018 | PRJNA358490_P_NODE_3723_length_741_cov_2.155271_g3498_i0 | PRJNA358490 | 3723 | 741 | 2.155271 | 15.97055811 | Bacteria | 2 | Bacteria | Bacteria | 185 | 6.43e-50 | NR | OJY22933.1 | 1895795 | g3498 | i0 | 44.4 | 2.22672064777328 | 275 | 111 | 95.1 | 11 | 720 | 16 | 429 | 701 | OJY22933.1 MAG: hypothetical protein BGO98_33415 [Myxococcales bacterium 68-20] | diamond | 1650 | 185 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium 68-20 | ||||
| 27422757 | 27422757 | PRJNA358490_P_NODE_6483_length_516_cov_2.844864_g6155_i0 | PRJNA358490 | 6483 | 516 | 2.844864 | 14.67949824 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 134 | 5.19e-35 | NR | HMI86906.1 | 2268199 | g6155 | i0 | 63.6 | 0.511627906976744 | 88 | 31 | 50.6 | 1 | 494 | 234 | 210 | 297 | HMI86906.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 264 | 134 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 27675354 | 27675354 | PRJNA358490_P_NODE_13284_length_214_cov_1.617143_g12940_i0 | PRJNA358490 | 13284 | 214 | 1.617143 | 3.46068602 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 120 | 2.69e-30 | NR | MEO8702332.1 | 2212474 | g12940 | i0 | 77.1 | 0.981308411214953 | 70 | 16 | 98.1 | 0 | 212 | 3 | 304 | 373 | MEO8702332.1 outer membrane protein transport protein [Kofleriaceae bacterium] | diamond | 210 | 120 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 28306596 | 28306596 | PRJNA358490_P_NODE_1346_length_1156_cov_4.679499_g1241_i0 | PRJNA358490 | 1346 | 1156 | 4.679499 | 54.09500844 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 442 | 3.9399999999999985e-152 | NR | MBL8743286.1 | 2026763 | g1241 | i0 | 69.6 | 0.820069204152249 | 316 | 95 | 81.7 | 1 | 1071 | 127 | 3 | 318 | MBL8743286.1 putative beta-lysine N-acetyltransferase [Myxococcales bacterium] | diamond | 948 | 442 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 28369649 | 28369649 | PRJNA358490_P_NODE_9066_length_383_cov_2.142442_g8725_i0 | PRJNA358490 | 9066 | 383 | 2.142442 | 8.20555286 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 70.9 | 9.34e-13 | NR | HMJ56563.1 | 2268199 | g8725 | i0 | 90 | 0.626631853785901 | 40 | 4 | 31.3 | 0 | 140 | 21 | 22 | 61 | HMJ56563.1 PilZ domain-containing protein [Polyangiaceae bacterium] | diamond | 240 | 70.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 29159274 | 29159274 | PRJNA358490_P_NODE_17949_length_153_cov_1.429825_g17605_i0 | PRJNA358490 | 17949 | 153 | 1.429825 | 2.18763225 | Sorangiineae bacterium PRO1 | 2293716 | Bacteria | Bacteria | 45.1 | 0.00165 | NR | MCE7888799.1 | 2293716 | g17605 | i0 | 43.2 | 1.72549019607843 | 44 | 25 | 86.3 | 0 | 6 | 137 | 645 | 688 | MCE7888799.1 ATP-binding protein [Sorangiineae bacterium PRO1] | diamond | 264 | 45.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Sorangiineae bacterium PRO1 | ||||
| 30074699 | 30074699 | PRJNA358490_P_NODE_11812_length_257_cov_1.481651_g11468_i0 | PRJNA358490 | 11812 | 257 | 1.481651 | 3.80784307 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 91.3 | 2.82e-19 | NR | MEO8699164.1 | 2212474 | g11468 | i0 | 85.2 | 0.630350194552529 | 54 | 8 | 63 | 0 | 164 | 3 | 327 | 380 | MEO8699164.1 HAMP domain-containing sensor histidine kinase [Kofleriaceae bacterium] | diamond | 162 | 91.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 31324255 | 31324255 | PRJNA358490_P_NODE_9295_length_370_cov_2.214502_g8953_i0 | PRJNA358490 | 9295 | 370 | 2.214502 | 8.1936574 | Bacteria | 2 | Bacteria | Bacteria | 113 | 3.86e-27 | NR | MBA3819084.1 | 2026735 | g8953 | i0 | 71.8 | 2.87837837837838 | 71 | 20 | 57.6 | 0 | 350 | 138 | 73 | 143 | MBA3819084.1 outer membrane protein transport protein [Deltaproteobacteria bacterium] | diamond | 1065 | 114 | 0.991228070175439 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31497130 | 31497130 | PRJNA358490_P_NODE_16856_length_162_cov_1.292683_g16512_i0 | PRJNA358490 | 16856 | 162 | 1.292683 | 2.09414646 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 90.9 | 1.21e-19 | NR | MBA2542311.1 | 2026735 | g16512 | i0 | 72.2 | 1 | 54 | 14 | 98.1 | 1 | 161 | 3 | 3 | 56 | MBA2542311.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 162 | 90.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31876397 | 31876397 | PRJNA358490_P_NODE_3457_length_768_cov_2.502058_g3238_i0 | PRJNA358490 | 3457 | 768 | 2.502058 | 19.21580544 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 178 | 2.86e-53 | NR | HUS66869.1 | 2212474 | g3238 | i0 | 76.5 | 1.3984375 | 119 | 28 | 46.5 | 0 | 259 | 615 | 1 | 119 | HUS66869.1 glutaredoxin domain-containing protein [Kofleriaceae bacterium] | diamond | 1074 | 178 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae 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);;