contig_metadata
21 rows where bioproject = "PRJNA1132896", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6134592 | 6134592 | PRJNA1132896_P_NODE_5265_length_271_cov_1.383838_g5174_i0 | PRJNA1132896 | 5265 | 271 | 1.383838 | 3.75020098 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 106 | 4.7e-26 | NR | MBI5579332.1 | 2026735 | g5174 | i0 | 96.7 | 0.664206642066421 | 60 | 2 | 66.4 | 0 | 90 | 269 | 1 | 60 | MBI5579332.1 slipin family protein [Deltaproteobacteria bacterium] | diamond | 180 | 106 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 11762209 | 11762209 | PRJNA1132896_P_NODE_1390_length_446_cov_1.364611_g1299_i0 | PRJNA1132896 | 1390 | 446 | 1.364611 | 6.08616506 | Polyangium aurulentum | 2567896 | Bacteria | Bacteria | 641 | 2.0099999999999993e-179 | NTclustered | gi|2235996827|gb|CP079217.1| | 2567896 | g1299 | i0 | 92.793 | 186.143497757848 | 444 | 31 | 99 | 1 | 1 | 444 | 442631 | 442189 | Polyangium aurulentum strain SDU3-1 chromosome, complete genome | blastn | 83020 | 641 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangium | Polyangium aurulentum | |||
| 20685057 | 20685057 | PRJNA1132896_P_NODE_9417_length_243_cov_1.358824_g9326_i0 | PRJNA1132896 | 9417 | 243 | 1.358824 | 3.30194232 | Chondromyces crocatus | 52 | Bacteria | Bacteria | 351 | 1.93e-92 | NTclustered | gi|169977285|emb|AM946600.1| | 52 | g9326 | i0 | 93.966 | 136.493827160494 | 232 | 14 | 95 | 0 | 1 | 232 | 2173 | 1942 | Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5 | blastn | 33168 | 351 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Chondromyces | Chondromyces crocatus | |||
| 21433664 | 21433664 | PRJNA1132896_P_NODE_5517_length_267_cov_1.587629_g5426_i0 | PRJNA1132896 | 5517 | 267 | 1.587629 | 4.23896943 | Pendulispora | 3375062 | Bacteria | Bacteria | 361 | 3.57e-95 | NTclustered | gi|2698035964|gb|CP089984.1| | 2741071 | g5426 | i0 | 91.386 | 145.985018726592 | 267 | 18 | 99 | 3 | 2 | 267 | 7191391 | 7191653 | Pendulispora albinea strain MSr11954 chromosome, complete genome | blastn | 38978 | 363 | 0.994490358126722 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora albinea | ||
| 27027736 | 27027736 | PRJNA1132896_P_NODE_9882_length_242_cov_0.911243_g9791_i0 | PRJNA1132896 | 9882 | 242 | 0.911243 | 2.20520806 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 42.7 | 0.0274 | NR | MDX2092204.1 | 2212474 | g9791 | i0 | 37.5 | 1.30165289256198 | 48 | 28 | 59.5 | 1 | 14 | 157 | 10 | 55 | MDX2092204.1 HupE/UreJ family protein [Kofleriaceae bacterium] | diamond | 315 | 42.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 27133182 | 27133182 | PRJNA1132896_P_NODE_602_length_663_cov_1.698305_g513_i0 | PRJNA1132896 | 602 | 663 | 1.698305 | 11.25976215 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 76.3 | 5.93e-12 | NR | MSP92154.1 | 2026763 | g513 | i0 | 32.7 | 4.05882352941176 | 165 | 89 | 73.3 | 7 | 175 | 660 | 1041 | 1186 | MSP92154.1 hypothetical protein [Myxococcales bacterium] | diamond | 2691 | 76.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 27291650 | 27291650 | PRJNA1132896_P_NODE_9343_length_244_cov_0.894737_g9252_i0 | PRJNA1132896 | 9343 | 244 | 0.894737 | 2.18315828 | Chondromyces apiculatus | 51 | Bacteria | Bacteria | 55.5 | 1.22e-6 | NR | WP_044250665.1 | 51 | g9252 | i0 | 52 | 1.22950819672131 | 50 | 23 | 61.5 | 1 | 151 | 2 | 12 | 60 | WP_044250665.1 acetylglutamate kinase [Chondromyces apiculatus] | diamond | 300 | 55.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Chondromyces | Chondromyces apiculatus | |||
| 27418242 | 27418242 | PRJNA1132896_P_NODE_10203_length_241_cov_0.916667_g10112_i0 | PRJNA1132896 | 10203 | 241 | 0.916667 | 2.20916747 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 43.5 | 0.0181 | NR | MEM6731053.1 | 2818507 | g10112 | i0 | 32.6 | 1.07053941908714 | 86 | 50 | 97.1 | 1 | 3 | 236 | 211 | 296 | MEM6731053.1 hypothetical protein [Myxococcota bacterium] | diamond | 258 | 43.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 29112198 | 29112198 | PRJNA1132896_P_NODE_3768_length_293_cov_1.586364_g3677_i0 | PRJNA1132896 | 3768 | 293 | 1.586364 | 4.64804652 | Myxococcales | 29 | Bacteria | Bacteria | 112 | 2.13e-26 | NR | WP_002611940.1 | 41 | g3677 | i0 | 51.2 | 7.10580204778157 | 86 | 42 | 88.1 | 0 | 3 | 260 | 577 | 662 | WP_002611940.1 lysyl oxidase family protein [Stigmatella aurantiaca] | diamond | 2082 | 112 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Stigmatella | Stigmatella aurantiaca | ||
| 30101794 | 30101794 | PRJNA1132896_P_NODE_9712_length_242_cov_1.822485_g9621_i0 | PRJNA1132896 | 9712 | 242 | 1.822485 | 4.4104137 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 79.3 | 4.75e-15 | NR | MBI5512447.1 | 2026735 | g9621 | i0 | 52.9 | 1.05371900826446 | 85 | 31 | 96.7 | 3 | 242 | 9 | 263 | 345 | MBI5512447.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 255 | 79.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 30291920 | 30291920 | PRJNA1132896_P_NODE_9572_length_243_cov_0.905882_g9481_i0 | PRJNA1132896 | 9572 | 243 | 0.905882 | 2.20129326 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 43.9 | 0.0146 | NR | MBI5515920.1 | 2026735 | g9481 | i0 | 32.9 | 1.37037037037037 | 76 | 51 | 93.8 | 0 | 15 | 242 | 295 | 370 | MBI5515920.1 acetoacetate decarboxylase family protein [Deltaproteobacteria bacterium] | diamond | 333 | 43.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31101933 | 31101933 | PRJNA1132896_P_NODE_355_length_883_cov_2.081481_g279_i0 | PRJNA1132896 | 355 | 883 | 2.081481 | 18.37947723 | Bacteria | 2 | Bacteria | Bacteria | 110 | 2.62e-24 | NR | MDP3238743.1 | 2026763 | g279 | i0 | 36.1 | 1.57984144960362 | 155 | 90 | 52.3 | 3 | 734 | 273 | 142 | 288 | MDP3238743.1 CAP domain-containing protein [Myxococcales bacterium] | diamond | 1395 | 111 | 0.990990990990991 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 31133400 | 31133400 | PRJNA1132896_P_NODE_8035_length_247_cov_1.770115_g7944_i0 | PRJNA1132896 | 8035 | 247 | 1.770115 | 4.37218405 | Myxococcia | 32015 | Bacteria | Bacteria | 50.4 | 7.41e-5 | NR | HSO33295.1 | 1971228 | g7944 | i0 | 58.5 | 2.18623481781377 | 41 | 17 | 49.8 | 0 | 123 | 1 | 417 | 457 | HSO33295.1 hypothetical protein [Labilithrix sp.] | diamond | 540 | 50.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix sp. | |||
| 31302646 | 31302646 | PRJNA1132896_P_NODE_135_length_1352_cov_3.272088_g100_i0 | PRJNA1132896 | 135 | 1352 | 3.272088 | 44.23862976 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 375 | 4.68e-120 | NR | MBK9260476.1 | 2268199 | g100 | i0 | 47 | 2.97559171597633 | 447 | 215 | 97.2 | 11 | 1317 | 4 | 131 | 564 | MBK9260476.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 4023 | 375 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 31366114 | 31366114 | PRJNA1132896_P_NODE_8296_length_247_cov_0.885057_g8205_i0 | PRJNA1132896 | 8296 | 247 | 0.885057 | 2.18609079 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 122 | 3.0199999999999997e-32 | NR | MBI2394608.1 | 2026735 | g8205 | i0 | 71.6 | 0.983805668016194 | 81 | 23 | 98.4 | 0 | 245 | 3 | 104 | 184 | MBI2394608.1 succinate dehydrogenase cytochrome b558 subunit [Deltaproteobacteria bacterium] | diamond | 243 | 122 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31650386 | 31650386 | PRJNA1132896_P_NODE_3797_length_292_cov_2.013699_g3706_i0 | PRJNA1132896 | 3797 | 292 | 2.013699 | 5.88000108 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 135 | 9.34e-36 | NR | UCB49634.1 | 2026735 | g3706 | i0 | 59.7 | 2.44520547945205 | 119 | 24 | 97.6 | 1 | 6 | 290 | 119 | 237 | UCB49634.1 MAG: GAF domain-containing protein [Deltaproteobacteria bacterium] | diamond | 714 | 135 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31650389 | 31650389 | PRJNA1132896_P_NODE_5577_length_266_cov_2.316062_g5486_i0 | PRJNA1132896 | 5577 | 266 | 2.316062 | 6.16072492 | Labilithrix luteola | 1391654 | Bacteria | Bacteria | 115 | 6.27e-29 | NR | WP_146647721.1 | 1391654 | g5486 | i0 | 59.1 | 0.992481203007519 | 88 | 36 | 99.2 | 0 | 3 | 266 | 238 | 325 | WP_146647721.1 nuclear transport factor 2 family protein [Labilithrix luteola] | diamond | 264 | 115 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix luteola | |||
| 31998583 | 31998583 | PRJNA1132896_P_NODE_658_length_638_cov_1.707965_g568_i0 | PRJNA1132896 | 658 | 638 | 1.707965 | 10.8968167 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 87.8 | 4.96e-16 | NR | HOU52499.1 | 2818507 | g568 | i0 | 35.4 | 0.851097178683386 | 181 | 78 | 68.2 | 8 | 73 | 507 | 491 | 668 | HOU52499.1 MopE-related protein [Myxococcota bacterium] | diamond | 543 | 87.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 32050896 | 32050896 | PRJNA1132896_P_NODE_1478_length_434_cov_1.490305_g1387_i0 | PRJNA1132896 | 1478 | 434 | 1.490305 | 6.4679237 | Bacteria | 2 | Bacteria | Bacteria | 60.1 | 2.39e-7 | NR | HEX5062632.1 | 2212474 | g1387 | i0 | 56 | 2.5852534562212 | 50 | 17 | 34.6 | 1 | 369 | 220 | 106 | 150 | HEX5062632.1 choice-of-anchor L domain-containing protein [Kofleriaceae bacterium] | diamond | 1122 | 60.5 | 0.993388429752066 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 32378333 | 32378333 | PRJNA1132896_P_NODE_5879_length_262_cov_1.629630_g5788_i0 | PRJNA1132896 | 5879 | 262 | 1.62963 | 4.2696306 | Polyangia bacterium | 3058050 | Bacteria | Bacteria | 53.5 | 6.33e-6 | NR | MFO0620122.1 | 3058050 | g5788 | i0 | 42.6 | 0.698473282442748 | 61 | 34 | 69.8 | 1 | 259 | 77 | 75 | 134 | MFO0620122.1 MBL fold metallo-hydrolase [Polyangia bacterium] | diamond | 183 | 53.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangia bacterium | ||||||
| 32505007 | 32505007 | PRJNA1132896_P_NODE_7099_length_250_cov_0.870056_g7008_i0 | PRJNA1132896 | 7099 | 250 | 0.870056 | 2.17514 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 53.5 | 6.24e-6 | NR | MBN8554511.1 | 2026735 | g7008 | i0 | 37.5 | 0.768 | 64 | 40 | 76.8 | 0 | 194 | 3 | 4 | 67 | MBN8554511.1 HDIG domain-containing protein [Deltaproteobacteria bacterium] | diamond | 192 | 53.5 | 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);;