contig_metadata
21 rows where bioproject = "PRJNA771359", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 747050 | 747050 | PRJNA771359_S_NODE_361_length_495_cov_16.858079_g283_i0 | PRJNA771359 | 361 | 495 | 16.858079 | 83.44749105 | Labilithrix luteola | 1391654 | Bacteria | Bacteria | 496 | 1.86e-135 | NTclustered | gi|913610804|gb|CP012333.1| | 1391654 | g283 | i0 | 85.02 | 126.414141414141 | 494 | 66 | 99 | 7 | 6 | 495 | 7090555 | 7090066 | Labilithrix luteola strain DSM 27648, complete genome | blastn | 62575 | 496 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix luteola | |||
| 747055 | 747055 | PRJNA771359_S_NODE_4121_length_166_cov_4.248062_g4038_i0 | PRJNA771359 | 4121 | 166 | 4.248062 | 7.05178292 | Nannocystis punicea | 2995304 | Bacteria | Bacteria | 178 | 2.2e-40 | NTclustered | gi|2415023655|gb|CP114040.1| | 2995304 | g4038 | i0 | 94.068 | 69.2951807228916 | 118 | 6 | 70 | 1 | 1 | 117 | 11216857 | 11216974 | Nannocystis poenicansa strain FL3 chromosome, complete genome | blastn | 11503 | 178 | 1 | Bacteria | Pseudomonadati | Myxococcota | Nannocystales | Nannocystaceae | Nannocystis | Nannocystis punicea | |||
| 3298211 | 3298211 | PRJNA771359_S_NODE_1223_length_304_cov_19.835206_g1140_i0 | PRJNA771359 | 1223 | 304 | 19.835206 | 60.29902624 | Labilithrix luteola | 1391654 | Bacteria | Bacteria | 387 | 6.839999999999998e-103 | NTclustered | gi|913610804|gb|CP012333.1| | 1391654 | g1140 | i0 | 89.968 | 129.559210526316 | 309 | 17 | 99 | 10 | 3 | 302 | 3943049 | 3943352 | Labilithrix luteola strain DSM 27648, complete genome | blastn | 39386 | 387 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix luteola | |||
| 3298268 | 3298268 | PRJNA771359_S_NODE_4403_length_161_cov_2.927419_g4320_i0 | PRJNA771359 | 4403 | 161 | 2.927419 | 4.71314459 | Sandaracinus amylolyticus | 927083 | Bacteria | Bacteria | 150 | 4.61e-32 | NTclustered | gi|816953346|gb|CP011125.1| | 927083 | g4320 | i0 | 84.713 | 92.6211180124224 | 157 | 17 | 95 | 7 | 1 | 153 | 8617140 | 8617293 | Sandaracinus amylolyticus strain DSM 53668, complete genome | blastn | 14912 | 150 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Sandaracinaceae | Sandaracinus | Sandaracinus amylolyticus | |||
| 3298282 | 3298282 | PRJNA771359_S_NODE_763_length_363_cov_8.607362_g680_i0 | PRJNA771359 | 763 | 363 | 8.607362 | 31.24472406 | Labilithrix luteola | 1391654 | Bacteria | Bacteria | 577 | 4.589999999999998e-160 | NTclustered | gi|913610804|gb|CP012333.1| | 1391654 | g680 | i0 | 95.317 | 142.867768595041 | 363 | 17 | 100 | 0 | 1 | 363 | 3944164 | 3943802 | Labilithrix luteola strain DSM 27648, complete genome | blastn | 51861 | 577 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix luteola | |||
| 10951121 | 10951121 | PRJNA771359_S_NODE_1849_length_245_cov_10.581731_g1766_i0 | PRJNA771359 | 1849 | 245 | 10.581731 | 25.92524095 | Labilithrix luteola | 1391654 | Bacteria | Bacteria | 353 | 5.41e-93 | NTclustered | gi|913610804|gb|CP012333.1| | 1391654 | g1766 | i0 | 93.004 | 179.689795918367 | 243 | 15 | 99 | 2 | 4 | 245 | 3942339 | 3942098 | Labilithrix luteola strain DSM 27648, complete genome | blastn | 44024 | 353 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix luteola | |||
| 11410581 | 11410581 | PRJNA771359_S_NODE_4289_length_163_cov_4.087302_g4206_i0 | PRJNA771359 | 4289 | 163 | 4.087302 | 6.66230226 | Archangium | 47 | Bacteria | Bacteria | 171 | 3.59e-38 | NTclustered | gi|2809295724|gb|CP102578.1| | 48 | g4206 | i0 | 86.42 | 262.865030674847 | 162 | 15 | 95 | 6 | 9 | 163 | 4475164 | 4475003 | Archangium gephyra strain SDU49 chromosome, complete genome | blastn | 42847 | 171 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium gephyra | ||
| 14775929 | 14775929 | PRJNA771359_S_NODE_2852_length_198_cov_35.142857_g2769_i0 | PRJNA771359 | 2852 | 198 | 35.142857 | 69.58285686 | Anaeromyxobacter sp. Fw109-5 | 404589 | Bacteria | Bacteria | 176 | 9.76e-40 | NTclustered | gi|470482295|ref|NR_076524.1| | 404589 | g2769 | i0 | 83.168 | 151.282828282828 | 202 | 25 | 99 | 7 | 1 | 197 | 215 | 18 | Anaeromyxobacter sp. Fw109-5 strain Fw109-5 23S ribosomal RNA, complete sequence | blastn | 29954 | 176 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Anaeromyxobacteraceae | Anaeromyxobacter | Anaeromyxobacter sp. Fw109-5 | ||
| 15235268 | 15235268 | PRJNA771359_S_NODE_792_length_359_cov_4.425466_g709_i0 | PRJNA771359 | 792 | 359 | 4.425466 | 15.88742294 | Anaeromyxobacter | 161492 | Bacteria | Bacteria | 220 | 8.81e-53 | NTclustered | gi|470477744|ref|NR_076406.1| | 161493 | g709 | i0 | 84.034 | 296.827298050139 | 238 | 28 | 65 | 10 | 127 | 359 | 277 | 45 | Anaeromyxobacter dehalogenans strain 2CP-C 23S ribosomal RNA gene, complete sequence | blastn | 106561 | 220 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Anaeromyxobacteraceae | Anaeromyxobacter | Anaeromyxobacter dehalogenans | ||
| 16509662 | 16509662 | PRJNA771359_S_NODE_1533_length_271_cov_48.632479_g1450_i0 | PRJNA771359 | 1533 | 271 | 48.632479 | 131.79401809 | root | 1 | Root_unresolved | Root_unresolved | 357 | 4.7e-94 | NTclustered | gi|169977285|emb|AM946600.1| | 52 | g1450 | i0 | 90.476 | 146.247232472325 | 273 | 22 | 100 | 4 | 1 | 271 | 1786 | 2056 | Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5 | blastn | 39633 | 357 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Chondromyces | Chondromyces crocatus | |||
| 17784362 | 17784362 | PRJNA771359_S_NODE_1394_length_287_cov_7.636000_g1311_i0 | PRJNA771359 | 1394 | 287 | 7.636 | 21.91532 | Sorangium | 39643 | Bacteria | Bacteria | 442 | 1.3499999999999993e-119 | NTclustered | gi|1566478966|gb|CP012672.1| | 56 | g1311 | i0 | 94.444 | 167.09756097561 | 288 | 15 | 100 | 1 | 1 | 287 | 3691768 | 3691481 | Sorangium cellulosum strain So ce836 chromosome, complete genome | blastn | 47957 | 442 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Sorangium | Sorangium cellulosum | |||
| 17784369 | 17784369 | PRJNA771359_S_NODE_194_length_645_cov_39.432566_g123_i0 | PRJNA771359 | 194 | 645 | 39.432566 | 254.3400507 | Nannocystis | 53 | Bacteria | Bacteria | 780 | 0 | NTclustered | gi|2244669|emb|X87286.1| | 54 | g123 | i0 | 88.647 | 172.063565891473 | 643 | 70 | 99 | 3 | 1 | 640 | 1140 | 498 | N.exedens 23S rRNA gene | blastn | 110981 | 780 | 1 | Bacteria | Pseudomonadati | Myxococcota | Nannocystales | Nannocystaceae | Nannocystis | Nannocystis exedens | |||
| 19873782 | 19873782 | PRJNA771359_S_NODE_1336_length_293_cov_16.902344_g1253_i0 | PRJNA771359 | 1336 | 293 | 16.902344 | 49.52386792 | Minicystis rosea | 888845 | Bacteria | Bacteria | 464 | 2.9399999999999994e-126 | NTclustered | gi|1127353251|gb|CP016211.1| | 888845 | g1253 | i0 | 95.238 | 124.61433447099 | 294 | 12 | 100 | 2 | 1 | 293 | 770416 | 770124 | Minicystis rosea strain DSM 24000 chromosome, complete genome | blastn | 36512 | 464 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Minicystis | Minicystis rosea | |||
| 24973663 | 24973663 | PRJNA771359_S_NODE_3600_length_177_cov_3.600000_g3517_i0 | PRJNA771359 | 3600 | 177 | 3.6 | 6.372 | Minicystis rosea | 888845 | Bacteria | Bacteria | 161 | 2.38e-35 | NTclustered | gi|1127353251|gb|CP016211.1| | 888845 | g3517 | i0 | 85.093 | 46.3898305084746 | 161 | 20 | 89 | 4 | 20 | 177 | 770410 | 770569 | Minicystis rosea strain DSM 24000 chromosome, complete genome | blastn | 8211 | 161 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Minicystis | Minicystis rosea | |||
| 25433419 | 25433419 | PRJNA771359_S_NODE_3540_length_179_cov_1.746479_g3457_i0 | PRJNA771359 | 3540 | 179 | 1.746479 | 3.12619741 | root | 1 | Root_unresolved | Root_unresolved | 148 | 1.8799999999999999e-31 | NTclustered | gi|169977285|emb|AM946600.1| | 52 | g3457 | i0 | 83.436 | 54.6145251396648 | 163 | 24 | 89 | 2 | 18 | 177 | 1581 | 1419 | Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5 | blastn | 9776 | 148 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Chondromyces | Chondromyces crocatus | |||
| 25433439 | 25433439 | PRJNA771359_S_NODE_820_length_355_cov_6.959119_g737_i0 | PRJNA771359 | 820 | 355 | 6.959119 | 24.70487245 | Sorangium | 39643 | Bacteria | Bacteria | 303 | 8.4e-78 | NTclustered | gi|507148211|ref|NR_103018.1| | 56 | g737 | i0 | 87.085 | 278.757746478873 | 271 | 32 | 75 | 3 | 88 | 355 | 275 | 5 | Sorangium cellulosum strain So ce 56 23S ribosomal RNA gene, complete sequence | blastn | 98959 | 303 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Sorangium | Sorangium cellulosum | |||
| 28411428 | 28411428 | PRJNA771359_S_NODE_4846_length_155_cov_1.966102_g4763_i0 | PRJNA771359 | 4846 | 155 | 1.966102 | 3.0474581 | Haliangium sp. | 2663208 | Bacteria | Bacteria | 47.8 | 1.91e-4 | NR | HWN71616.1 | 2663208 | g4763 | i0 | 48.2 | 1.08387096774194 | 56 | 20 | 94.8 | 2 | 5 | 151 | 113 | 166 | HWN71616.1 lysyl oxidase family protein [Haliangium sp.] | diamond | 168 | 47.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Haliangium | Haliangium sp. | |||
| 29421487 | 29421487 | PRJNA771359_S_NODE_2469_length_213_cov_1.960227_g2386_i0 | PRJNA771359 | 2469 | 213 | 1.960227 | 4.17528351 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 67 | 7.09e-11 | NR | HSK02279.1 | 2212474 | g2386 | i0 | 56.3 | 2.02816901408451 | 48 | 20 | 66.2 | 1 | 213 | 73 | 263 | 310 | HSK02279.1 lysyl oxidase family protein [Kofleriaceae bacterium] | diamond | 432 | 67 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 32645251 | 32645251 | PRJNA771359_S_NODE_2040_length_232_cov_2.071795_g1957_i0 | PRJNA771359 | 2040 | 232 | 2.071795 | 4.8065644 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 57 | 3e-7 | NR | HOA14037.1 | 2818507 | g1957 | i0 | 38.2 | 0.879310344827586 | 68 | 41 | 86.6 | 1 | 3 | 203 | 415 | 482 | HOA14037.1 hypothetical protein [Myxococcota bacterium] | diamond | 204 | 57 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 32834414 | 32834414 | PRJNA771359_S_NODE_1200_length_307_cov_2.177778_g1117_i0 | PRJNA771359 | 1200 | 307 | 2.177778 | 6.68577846 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 59.7 | 9.16e-8 | NR | MBT9555065.1 | 2026763 | g1117 | i0 | 45.3 | 1.5928338762215 | 64 | 34 | 62.5 | 1 | 199 | 8 | 121 | 183 | MBT9555065.1 hypothetical protein [Myxococcales bacterium] | diamond | 489 | 59.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 32865936 | 32865936 | PRJNA771359_S_NODE_4500_length_160_cov_1.504065_g4417_i0 | PRJNA771359 | 4500 | 160 | 1.504065 | 2.406504 | Haliangium sp. | 2663208 | Bacteria | Bacteria | 72.8 | 8.27e-14 | NR | HWN71617.1 | 2663208 | g4417 | i0 | 51.9 | 1.9125 | 52 | 25 | 97.5 | 0 | 4 | 159 | 103 | 154 | HWN71617.1 lysyl oxidase family protein [Haliangium sp.] | diamond | 306 | 72.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Haliangium | Haliangium sp. |
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);;