contig_metadata
22 rows where bioproject = "PRJNA527965", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1114314 | 1114314 | PRJNA527965_S_NODE_861_length_387_cov_417.150568_g778_i0 | PRJNA527965 | 861 | 387 | 417.150568 | 1614.37269816 | Sorangium | 39643 | Bacteria | Bacteria | 383 | 1.1499999999999998e-101 | NTclustered | gi|1338588479|gb|CP012673.1| | 56 | g778 | i0 | 84.733 | 98.3488372093023 | 393 | 49 | 100 | 10 | 1 | 387 | 3904515 | 3904902 | Sorangium cellulosum strain So ce26 chromosome, complete genome | blastn | 38061 | 383 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Sorangium | Sorangium cellulosum | |||
| 2389860 | 2389860 | PRJNA527965_S_NODE_6242_length_150_cov_3.426087_g6159_i0 | PRJNA527965 | 6242 | 150 | 3.426087 | 5.1391305 | Myxococcaceae | 31 | Bacteria | Bacteria | 191 | 2.48e-44 | NTclustered | gi|470488931|ref|NR_076895.1| | 33 | g6159 | i0 | 91.367 | 198.44 | 139 | 12 | 93 | 0 | 12 | 150 | 899 | 761 | Myxococcus fulvus strain HW-1 23S ribosomal RNA gene, complete sequence | blastn | 29766 | 191 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcus | Myxococcus fulvus | ||
| 4323815 | 4323815 | PRJNA527965_S_NODE_3584_length_201_cov_4.439759_g3501_i0 | PRJNA527965 | 3584 | 201 | 4.439759 | 8.92391559 | Minicystis rosea | 888845 | Bacteria | Bacteria | 316 | 5.61e-82 | NTclustered | gi|1127353251|gb|CP016211.1| | 888845 | g3501 | i0 | 95.025 | 227.119402985075 | 201 | 10 | 100 | 0 | 1 | 201 | 768893 | 769093 | Minicystis rosea strain DSM 24000 chromosome, complete genome | blastn | 45651 | 316 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Minicystis | Minicystis rosea | |||
| 4942596 | 4942596 | PRJNA527965_S_NODE_984_length_369_cov_4.245509_g901_i0 | PRJNA527965 | 984 | 369 | 4.245509 | 15.66592821 | Haliangium | 162027 | Bacteria | Bacteria | 429 | 1.39e-115 | NTclustered | gi|470485361|ref|NR_076697.1| | 80816 | g901 | i0 | 89.595 | 231.460704607046 | 346 | 24 | 94 | 6 | 22 | 367 | 1500 | 1167 | Haliangium ochraceum strain SMP-2 23S ribosomal RNA gene, complete sequence | blastn | 85409 | 429 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Haliangium | Haliangium ochraceum | |||
| 5600699 | 5600699 | PRJNA527965_S_NODE_265_length_604_cov_11.511424_g193_i0 | PRJNA527965 | 265 | 604 | 11.511424 | 69.52900096 | Sorangium cellulosum | 56 | Bacteria | Bacteria | 750 | 0 | NTclustered | gi|1338588479|gb|CP012673.1| | 56 | g193 | i0 | 89.091 | 128.996688741722 | 605 | 64 | 100 | 2 | 1 | 604 | 6457701 | 6458304 | Sorangium cellulosum strain So ce26 chromosome, complete genome | blastn | 77914 | 750 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Sorangium | Sorangium cellulosum | |||
| 7492392 | 7492392 | PRJNA527965_S_NODE_4546_length_176_cov_3.418440_g4463_i0 | PRJNA527965 | 4546 | 176 | 3.41844 | 6.0164544 | Sorangium | 39643 | Bacteria | Bacteria | 204 | 3.87e-48 | NTclustered | gi|1566478966|gb|CP012672.1| | 56 | g4463 | i0 | 87.709 | 154.636363636364 | 179 | 17 | 100 | 5 | 1 | 176 | 3689799 | 3689975 | Sorangium cellulosum strain So ce836 chromosome, complete genome | blastn | 27216 | 204 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Sorangium | Sorangium cellulosum | |||
| 10042836 | 10042836 | PRJNA527965_S_NODE_3228_length_212_cov_2.875706_g3145_i0 | PRJNA527965 | 3228 | 212 | 2.875706 | 6.09649672 | Nannocystis | 53 | Bacteria | Bacteria | 159 | 1.0699999999999999e-34 | NTclustered | gi|1386873112|gb|MF774779.1| | 54 | g3145 | i0 | 81.221 | 8.32075471698113 | 213 | 27 | 99 | 8 | 2 | 212 | 525 | 324 | Nannocystis exedens strain Na e1 23S ribosomal RNA gene, partial sequence | blastn | 1764 | 159 | 1 | Bacteria | Pseudomonadati | Myxococcota | Nannocystales | Nannocystaceae | Nannocystis | Nannocystis exedens | |||
| 12593277 | 12593277 | PRJNA527965_S_NODE_2250_length_258_cov_2.139013_g2167_i0 | PRJNA527965 | 2250 | 258 | 2.139013 | 5.51865354 | Nannocystis | 53 | Bacteria | Bacteria | 350 | 7.44e-92 | NTclustered | gi|2244669|emb|X87286.1| | 54 | g2167 | i0 | 91.154 | 215 | 260 | 20 | 100 | 3 | 1 | 258 | 12 | 270 | N.exedens 23S rRNA gene | blastn | 55470 | 350 | 1 | Bacteria | Pseudomonadati | Myxococcota | Nannocystales | Nannocystaceae | Nannocystis | Nannocystis exedens | |||
| 12593293 | 12593293 | PRJNA527965_S_NODE_3810_length_195_cov_2.950000_g3727_i0 | PRJNA527965 | 3810 | 195 | 2.95 | 5.7525 | Nannocystis | 53 | Bacteria | Bacteria | 209 | 9.45e-50 | NTclustered | gi|2244669|emb|X87286.1| | 54 | g3727 | i0 | 87.432 | 10.5589743589744 | 183 | 22 | 94 | 1 | 13 | 195 | 390 | 209 | N.exedens 23S rRNA gene | blastn | 2059 | 209 | 1 | Bacteria | Pseudomonadati | Myxococcota | Nannocystales | Nannocystaceae | Nannocystis | Nannocystis exedens | |||
| 13250704 | 13250704 | PRJNA527965_S_NODE_1851_length_287_cov_85.043651_g1768_i0 | PRJNA527965 | 1851 | 287 | 85.043651 | 244.07527837 | Labilithrix luteola | 1391654 | Bacteria | Bacteria | 394 | 3.83e-105 | NTclustered | gi|913610804|gb|CP012333.1| | 1391654 | g1768 | i0 | 91.608 | 134.268292682927 | 286 | 23 | 99 | 1 | 3 | 287 | 7090350 | 7090065 | Labilithrix luteola strain DSM 27648, complete genome | blastn | 38535 | 394 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix luteola | |||
| 14525823 | 14525823 | PRJNA527965_S_NODE_612_length_448_cov_167.019370_g530_i0 | PRJNA527965 | 612 | 448 | 167.01937 | 748.2467776 | Sandaracinus amylolyticus | 927083 | Bacteria | Bacteria | 523 | 7.649999999999998e-144 | NTclustered | gi|816953346|gb|CP011125.1| | 927083 | g530 | i0 | 87.778 | 241.946428571429 | 450 | 52 | 100 | 3 | 1 | 448 | 8614693 | 8615141 | Sandaracinus amylolyticus strain DSM 53668, complete genome | blastn | 108392 | 523 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Sandaracinaceae | Sandaracinus | Sandaracinus amylolyticus | |||
| 17074137 | 17074137 | PRJNA527965_S_NODE_1694_length_298_cov_7.866920_g1611_i0 | PRJNA527965 | 1694 | 298 | 7.86692 | 23.4434216 | Sorangium cellulosum | 56 | Bacteria | Bacteria | 342 | 1.4699999999999999e-89 | NTclustered | gi|1566495190|gb|CP012670.1| | 56 | g1611 | i0 | 87.417 | 117.557046979866 | 302 | 33 | 100 | 4 | 1 | 298 | 8621276 | 8621576 | Sorangium cellulosum strain So ceGT47 chromosome, complete genome | blastn | 35032 | 342 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Sorangium | Sorangium cellulosum | |||
| 17074145 | 17074145 | PRJNA527965_S_NODE_1894_length_284_cov_7.742972_g1811_i0 | PRJNA527965 | 1894 | 284 | 7.742972 | 21.99004048 | Sorangium cellulosum | 56 | Bacteria | Bacteria | 274 | 5.14e-69 | NTclustered | gi|161158851|emb|AM746676.1| | 448385 | g1811 | i0 | 84.615 | 78.4964788732394 | 286 | 32 | 100 | 10 | 1 | 281 | 10339361 | 10339639 | Sorangium cellulosum 'So ce 56' complete genome | blastn | 22293 | 274 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Sorangium | Sorangium cellulosum | |||
| 17074177 | 17074177 | PRJNA527965_S_NODE_3714_length_198_cov_1.282209_g3631_i0 | PRJNA527965 | 3714 | 198 | 1.282209 | 2.53877382 | Sorangium cellulosum | 56 | Bacteria | Bacteria | 213 | 7.44e-51 | NTclustered | gi|1338588479|gb|CP012673.1| | 56 | g3631 | i0 | 86.07 | 9.18181818181818 | 201 | 25 | 100 | 3 | 1 | 198 | 3904788 | 3904588 | Sorangium cellulosum strain So ce26 chromosome, complete genome | blastn | 1818 | 213 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Sorangium | Sorangium cellulosum | |||
| 18348367 | 18348367 | PRJNA527965_S_NODE_1035_length_362_cov_137.174312_g952_i0 | PRJNA527965 | 1035 | 362 | 137.174312 | 496.57100944 | Sorangium cellulosum | 56 | Bacteria | Bacteria | 545 | 1.2899999999999996e-150 | NTclustered | gi|1566495190|gb|CP012670.1| | 56 | g952 | i0 | 93.906 | 117.240331491713 | 361 | 22 | 99 | 0 | 1 | 361 | 2992320 | 2991960 | Sorangium cellulosum strain So ceGT47 chromosome, complete genome | blastn | 42441 | 545 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Sorangium | Sorangium cellulosum | |||
| 18348480 | 18348480 | PRJNA527965_S_NODE_915_length_380_cov_5.260870_g832_i0 | PRJNA527965 | 915 | 380 | 5.26087 | 19.991306 | Polyangium aurulentum | 2567896 | Bacteria | Bacteria | 411 | 5.189999999999999e-110 | NTclustered | gi|2235996827|gb|CP079217.1| | 2567896 | g832 | i0 | 86.352 | 151.913157894737 | 381 | 46 | 100 | 4 | 1 | 380 | 443633 | 443258 | Polyangium aurulentum strain SDU3-1 chromosome, complete genome | blastn | 57727 | 411 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangium | Polyangium aurulentum | |||
| 19622942 | 19622942 | PRJNA527965_S_NODE_5036_length_167_cov_1.446970_g4953_i0 | PRJNA527965 | 5036 | 167 | 1.44697 | 2.4164399 | Pendulispora brunnea | 2905690 | Bacteria | Bacteria | 82.4 | 1.79e-11 | NTclustered | gi|2698055994|gb|CP089982.1| | 2905690 | g4953 | i0 | 76.923 | 16.1976047904192 | 156 | 28 | 92 | 5 | 2 | 154 | 7409273 | 7409123 | Pendulispora brunnea strain MSr12523 chromosome, complete genome | blastn | 2705 | 82.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora brunnea | ||
| 20899027 | 20899027 | PRJNA527965_S_NODE_457_length_489_cov_8.425110_g375_i0 | PRJNA527965 | 457 | 489 | 8.42511 | 41.1987879 | Sorangium cellulosum | 56 | Bacteria | Bacteria | 453 | 1.12e-122 | NTclustered | gi|1338588479|gb|CP012673.1| | 56 | g375 | i0 | 85.459 | 104.229038854806 | 447 | 52 | 90 | 12 | 1 | 440 | 3904515 | 3904955 | Sorangium cellulosum strain So ce26 chromosome, complete genome | blastn | 50968 | 453 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Sorangium | Sorangium cellulosum | |||
| 20899060 | 20899060 | PRJNA527965_S_NODE_617_length_447_cov_167.623786_g535_i0 | PRJNA527965 | 617 | 447 | 167.623786 | 749.27832342 | Sandaracinus amylolyticus | 927083 | Bacteria | Bacteria | 523 | 7.629999999999998e-144 | NTclustered | gi|2183633570|gb|CP070225.1| | 927083 | g535 | i0 | 87.919 | 343.814317673378 | 447 | 51 | 99 | 3 | 3 | 447 | 9679310 | 9678865 | Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence | blastn | 153685 | 523 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Sandaracinaceae | Sandaracinus | Sandaracinus amylolyticus | |||
| 21516281 | 21516281 | PRJNA527965_S_NODE_317_length_565_cov_7.224528_g241_i0 | PRJNA527965 | 317 | 565 | 7.224528 | 40.8185832 | Sorangium | 39643 | Bacteria | Bacteria | 610 | 7.329999999999998e-170 | NTclustered | gi|1338588479|gb|CP012673.1| | 56 | g241 | i0 | 86.364 | 128.612389380531 | 572 | 63 | 100 | 13 | 1 | 565 | 3905078 | 3904515 | Sorangium cellulosum strain So ce26 chromosome, complete genome | blastn | 72666 | 610 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Sorangium | Sorangium cellulosum | |||
| 22791450 | 22791450 | PRJNA527965_S_NODE_578_length_457_cov_15.419431_g496_i0 | PRJNA527965 | 578 | 457 | 15.419431 | 70.46679967 | root | 1 | Root_unresolved | Root_unresolved | 662 | 0 | NTclustered | gi|1566478966|gb|CP012672.1| | 56 | g496 | i0 | 92.826 | 171.415754923414 | 460 | 28 | 100 | 5 | 1 | 457 | 4328822 | 4328365 | Sorangium cellulosum strain So ce836 chromosome, complete genome | blastn | 78337 | 667 | 0.992503748125937 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Sorangium | Sorangium cellulosum | |||
| 23449253 | 23449253 | PRJNA527965_S_NODE_3339_length_208_cov_7.867052_g3256_i0 | PRJNA527965 | 3339 | 208 | 7.867052 | 16.36346816 | Chondromyces crocatus | 52 | Bacteria | Bacteria | 281 | 2.13e-71 | NTclustered | gi|169977285|emb|AM946600.1| | 52 | g3256 | i0 | 91.304 | 243.716346153846 | 207 | 16 | 99 | 2 | 4 | 208 | 3188 | 2982 | Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5 | blastn | 50693 | 281 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Chondromyces | Chondromyces crocatus |
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);;