contig_metadata
17 rows where bioproject = "PRJNA1115053", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1503281 | 1503281 | PRJNA1115053_S_NODE_41862_length_358_cov_1.857143_g40045_i0 | PRJNA1115053 | 41862 | 358 | 1.857143 | 6.64857194 | Archangium violaceum | 83451 | Bacteria | Bacteria | 322 | 2.34e-83 | NTclustered | gi|2579675135|gb|CP043493.1| | 83451 | g40045 | i0 | 83.196 | 212.301675977654 | 363 | 50 | 100 | 9 | 1 | 358 | 5180967 | 5181323 | Archangium violaceum strain Cbvi 34 chromosome, complete genome | blastn | 76004 | 322 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium violaceum | ||
| 11702806 | 11702806 | PRJNA1115053_S_NODE_171250_length_207_cov_2.268293_g169433_i0 | PRJNA1115053 | 171250 | 207 | 2.268293 | 4.69536651 | Pendulispora albinea | 2741071 | Bacteria | Bacteria | 241 | 3.6e-59 | NTclustered | gi|2698035964|gb|CP089984.1| | 2741071 | g169433 | i0 | 87.805 | 126.009661835749 | 205 | 25 | 99 | 0 | 1 | 205 | 3588112 | 3587908 | Pendulispora albinea strain MSr11954 chromosome, complete genome | blastn | 26084 | 241 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora albinea | ||
| 15051844 | 15051844 | PRJNA1115053_S_NODE_126152_length_236_cov_1.492228_g124335_i0 | PRJNA1115053 | 126152 | 236 | 1.492228 | 3.52165808 | Sorangium | 39643 | Bacteria | Bacteria | 226 | 1.18e-54 | NTclustered | gi|1566478966|gb|CP012672.1| | 56 | g124335 | i0 | 84.848 | 90.0889830508475 | 231 | 27 | 95 | 7 | 12 | 236 | 6778774 | 6778546 | Sorangium cellulosum strain So ce836 chromosome, complete genome | blastn | 21261 | 226 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Sorangium | Sorangium cellulosum | |||
| 18074086 | 18074086 | PRJNA1115053_S_NODE_10415_length_581_cov_22.996283_g8786_i0 | PRJNA1115053 | 10415 | 581 | 22.996283 | 133.60840423 | Haliangium ochraceum | 80816 | Bacteria | Bacteria | 399 | 1.7799999999999996e-106 | NTclustered | gi|262076673|gb|CP001804.1| | 502025 | g8786 | i0 | 80 | 134.695352839931 | 570 | 90 | 96 | 19 | 1 | 556 | 2901276 | 2900717 | Haliangium ochraceum DSM 14365, complete genome | blastn | 78258 | 399 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Haliangium | Haliangium ochraceum | |||
| 26679011 | 26679011 | PRJNA1115053_S_NODE_281261_length_166_cov_1.853659_g279444_i0 | PRJNA1115053 | 281261 | 166 | 1.853659 | 3.07707394 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 41.2 | 0.0442 | NR | MDR1125858.1 | 2026735 | g279444 | i0 | 39 | 1.59036144578313 | 41 | 25 | 74.1 | 0 | 36 | 158 | 200 | 240 | MDR1125858.1 glycosyltransferase [Deltaproteobacteria bacterium] | diamond | 264 | 41.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 26846717 | 26846717 | PRJNA1115053_S_NODE_311941_length_158_cov_1.669565_g310124_i0 | PRJNA1115053 | 311941 | 158 | 1.669565 | 2.6379127000000002 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 46.6 | 5.04e-4 | NR | MCK5798255.1 | 2026735 | g310124 | i0 | 63 | 0.512658227848101 | 27 | 10 | 51.3 | 0 | 40 | 120 | 273 | 299 | MCK5798255.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 81 | 46.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 27478804 | 27478804 | PRJNA1115053_S_NODE_128543_length_234_cov_1.759162_g126726_i0 | PRJNA1115053 | 128543 | 234 | 1.759162 | 4.11643908 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 42.4 | 0.0394 | NR | MDH3842767.1 | 2026763 | g126726 | i0 | 43.4 | 0.67948717948718 | 53 | 27 | 66.7 | 2 | 41 | 196 | 94 | 144 | MDH3842767.1 hypothetical protein [Myxococcales bacterium] | diamond | 159 | 42.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 27542025 | 27542025 | PRJNA1115053_S_NODE_260904_length_172_cov_1.635659_g259087_i0 | PRJNA1115053 | 260904 | 172 | 1.635659 | 2.81333348 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 55.1 | 5.88e-8 | NR | MBI3542247.1 | 2026735 | g259087 | i0 | 81.1 | 0.645348837209302 | 37 | 6 | 64.5 | 1 | 112 | 2 | 1 | 36 | MBI3542247.1 transposase [Deltaproteobacteria bacterium] | diamond | 111 | 55.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 28489234 | 28489234 | PRJNA1115053_S_NODE_338247_length_153_cov_0.872727_g336430_i0 | PRJNA1115053 | 338247 | 153 | 0.872727 | 1.33527231 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 43.5 | 0.0058 | NR | MDP2342693.1 | 2026735 | g336430 | i0 | 47.4 | 0.745098039215686 | 38 | 20 | 74.5 | 0 | 35 | 148 | 344 | 381 | MDP2342693.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 114 | 43.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 28741782 | 28741782 | PRJNA1115053_S_NODE_355487_length_150_cov_2.242991_g353670_i0 | PRJNA1115053 | 355487 | 150 | 2.242991 | 3.3644865 | Anaeromyxobacteraceae bacterium | 2510643 | Bacteria | Bacteria | 60.5 | 5.65e-9 | NR | HYG68651.1 | 2510643 | g353670 | i0 | 56.3 | 1.94 | 48 | 21 | 96 | 0 | 3 | 146 | 124 | 171 | HYG68651.1 DUF2586 family protein [Anaeromyxobacteraceae bacterium] | diamond | 291 | 60.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Anaeromyxobacteraceae | Anaeromyxobacteraceae bacterium | |||
| 29553525 | 29553525 | PRJNA1115053_S_NODE_145310_length_222_cov_2.681564_g143493_i0 | PRJNA1115053 | 145310 | 222 | 2.681564 | 5.95307208 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 43.1 | 0.0199 | NR | WP_075007115.1 | 41 | g143493 | i0 | 38.1 | 1.7027027027027 | 63 | 39 | 85.1 | 0 | 208 | 20 | 76 | 138 | WP_075007115.1 hypothetical protein [Stigmatella aurantiaca] | diamond | 378 | 43.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Stigmatella | Stigmatella aurantiaca | ||
| 29751878 | 29751878 | PRJNA1115053_S_NODE_169011_length_208_cov_3.575758_g167194_i0 | PRJNA1115053 | 169011 | 208 | 3.575758 | 7.43757664 | Nannocystis pusilla | 889268 | Bacteria | Bacteria | 40.4 | 0.0481 | NR | WP_267771976.1 | 889268 | g167194 | i0 | 41.5 | 0.764423076923077 | 53 | 30 | 76.4 | 1 | 168 | 10 | 49 | 100 | WP_267771976.1 protein kinase [Nannocystis pusilla] | diamond | 159 | 40.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Nannocystales | Nannocystaceae | Nannocystis | Nannocystis pusilla | |||
| 31300339 | 31300339 | PRJNA1115053_S_NODE_278235_length_167_cov_1.548387_g276418_i0 | PRJNA1115053 | 278235 | 167 | 1.548387 | 2.58580629 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 41.2 | 0.0456 | NR | MCH2409717.1 | 2818507 | g276418 | i0 | 47.5 | 0.718562874251497 | 40 | 20 | 71.9 | 1 | 140 | 21 | 183 | 221 | MCH2409717.1 alpha/beta hydrolase [Myxococcota bacterium] | diamond | 120 | 41.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 31585219 | 31585219 | PRJNA1115053_S_NODE_82916_length_279_cov_1.830508_g81099_i0 | PRJNA1115053 | 82916 | 279 | 1.830508 | 5.10711732 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 52 | 2.94e-5 | NR | HEY5935137.1 | 2212474 | g81099 | i0 | 34 | 1.01075268817204 | 94 | 58 | 96.8 | 1 | 2 | 271 | 185 | 278 | HEY5935137.1 hypothetical protein [Kofleriaceae bacterium] | diamond | 282 | 52 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 31711519 | 31711519 | PRJNA1115053_S_NODE_121437_length_240_cov_0.974619_g119620_i0 | PRJNA1115053 | 121437 | 240 | 0.974619 | 2.3390856 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 42.7 | 0.0347 | NR | MET0794252.1 | 2268199 | g119620 | i0 | 41 | 0.7625 | 61 | 34 | 73.8 | 1 | 236 | 60 | 224 | 284 | MET0794252.1 dockerin type I domain-containing protein [Polyangiaceae bacterium] | diamond | 183 | 42.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 31774681 | 31774681 | PRJNA1115053_S_NODE_59397_length_316_cov_2.813187_g57580_i0 | PRJNA1115053 | 59397 | 316 | 2.813187 | 8.88967092 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 143 | 1.32e-38 | NR | NVB77927.1 | 2212474 | g57580 | i0 | 82.4 | 2.38291139240506 | 85 | 15 | 80.7 | 0 | 314 | 60 | 334 | 418 | NVB77927.1 NAD-dependent epimerase/dehydratase family protein [Kofleriaceae bacterium] | diamond | 753 | 143 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 32113948 | 32113948 | PRJNA1115053_S_NODE_124338_length_237_cov_2.505155_g122521_i0 | PRJNA1115053 | 124338 | 237 | 2.505155 | 5.93721735 | Polyangiales | 3031712 | Bacteria | Bacteria | 42.4 | 0.0433 | NR | MAT26778.1 | 2024858 | g122521 | i0 | 34.2 | 1.84810126582278 | 73 | 46 | 89.9 | 1 | 227 | 15 | 115 | 187 | MAT26778.1 hypothetical protein [Sandaracinus sp.] | diamond | 438 | 42.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Sandaracinaceae | Sandaracinus | Sandaracinus 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);;