contig_metadata
16 rows where bioproject = "PRJNA1198392", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 324461 | 324461 | PRJNA1198392_P_NODE_12921_length_268_cov_1.256410_g12780_i0 | PRJNA1198392 | 12921 | 268 | 1.25641 | 3.3671788 | Minicystis rosea | 888845 | Bacteria | Bacteria | 110 | 1.44e-19 | NTclustered | gi|1127353251|gb|CP016211.1| | 888845 | g12780 | i0 | 91.25 | 2.67910447761194 | 80 | 7 | 30 | 0 | 186 | 265 | 3013390 | 3013311 | Minicystis rosea strain DSM 24000 chromosome, complete genome | blastn | 718 | 110 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Minicystis | Minicystis rosea | |||
| 4151738 | 4151738 | PRJNA1198392_P_NODE_8424_length_289_cov_1.907407_g8283_i0 | PRJNA1198392 | 8424 | 289 | 1.907407 | 5.51240623 | Polyangiales bacterium | 3034171 | Bacteria | Bacteria | 166 | 6.39e-51 | NR | MEO7094792.1 | 3034171 | g8283 | i0 | 90.6 | 1.99307958477509 | 96 | 9 | 99.7 | 0 | 289 | 2 | 5 | 100 | MEO7094792.1 50S ribosomal protein L22 [Polyangiales bacterium] | diamond | 576 | 166 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiales bacterium | |||||
| 6702501 | 6702501 | PRJNA1198392_P_NODE_2246_length_495_cov_1.459716_g2105_i0 | PRJNA1198392 | 2246 | 495 | 1.459716 | 7.2255942 | Pendulispora albinea | 2741071 | Bacteria | Bacteria | 636 | 1.0499999999999998e-177 | NTclustered | gi|2698035964|gb|CP089984.1| | 2741071 | g2105 | i0 | 90.141 | 137.442424242424 | 497 | 38 | 99 | 9 | 5 | 495 | 3589271 | 3588780 | Pendulispora albinea strain MSr11954 chromosome, complete genome | blastn | 68034 | 636 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora albinea | ||
| 7978141 | 7978141 | PRJNA1198392_P_NODE_7227_length_305_cov_1.336207_g7086_i0 | PRJNA1198392 | 7227 | 305 | 1.336207 | 4.07543135 | Pendulispora rubella | 2741070 | Bacteria | Bacteria | 433 | 8.69e-117 | NTclustered | gi|2698045512|gb|CP089929.1| | 2741070 | g7086 | i0 | 92.208 | 126.986885245902 | 308 | 20 | 100 | 4 | 1 | 305 | 7289706 | 7289400 | Pendulispora rubella strain MSr11368 chromosome, complete genome | blastn | 38731 | 433 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora rubella | ||
| 9252594 | 9252594 | PRJNA1198392_P_NODE_21168_length_241_cov_0.916667_g21027_i0 | PRJNA1198392 | 21168 | 241 | 0.916667 | 2.20916747 | Anaeromyxobacter paludicola | 2918171 | Bacteria | Bacteria | 115 | 2.73e-21 | NTclustered | gi|2199271117|dbj|AP025592.1| | 2918171 | g21027 | i0 | 93.506 | 8.90041493775934 | 77 | 5 | 32 | 0 | 2 | 78 | 1383634 | 1383558 | Anaeromyxobacter paludicola DNA, complete genome | blastn | 2145 | 115 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Anaeromyxobacteraceae | Anaeromyxobacter | Anaeromyxobacter paludicola | ||
| 9252773 | 9252773 | PRJNA1198392_P_NODE_9448_length_285_cov_1.363208_g9307_i0 | PRJNA1198392 | 9448 | 285 | 1.363208 | 3.8851428 | Labilithrix luteola | 1391654 | Bacteria | Bacteria | 366 | 8.28e-97 | NTclustered | gi|913610804|gb|CP012333.1| | 1391654 | g9307 | i0 | 90.614 | 0.971929824561404 | 277 | 24 | 97 | 2 | 2 | 277 | 5311062 | 5311337 | Labilithrix luteola strain DSM 27648, complete genome | blastn | 277 | 366 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix luteola | |||
| 11247084 | 11247084 | PRJNA1198392_P_NODE_8429_length_289_cov_1.884259_g8288_i0 | PRJNA1198392 | 8429 | 289 | 1.884259 | 5.44550851 | Corallococcus | 83461 | Bacteria | Bacteria | 252 | 2.46e-62 | NTclustered | gi|2851136330|gb|CP172866.1| | 184914 | g8288 | i0 | 82.534 | 99.7923875432526 | 292 | 45 | 100 | 6 | 1 | 289 | 8994959 | 8994671 | Corallococcus coralloides strain KYC2213 chromosome, complete genome | blastn | 28840 | 252 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Corallococcus | Corallococcus coralloides | ||
| 20725833 | 20725833 | PRJNA1198392_P_NODE_13397_length_265_cov_1.604167_g13256_i0 | PRJNA1198392 | 13397 | 265 | 1.604167 | 4.25104255 | Labilithrix luteola | 1391654 | Bacteria | Bacteria | 150 | 8.349999999999998e-32 | NTclustered | gi|913610804|gb|CP012333.1| | 1391654 | g13256 | i0 | 83.974 | 54.8264150943396 | 156 | 25 | 59 | 0 | 108 | 263 | 2661291 | 2661136 | Labilithrix luteola strain DSM 27648, complete genome | blastn | 14529 | 150 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix luteola | |||
| 26977609 | 26977609 | PRJNA1198392_P_NODE_20482_length_242_cov_1.822485_g20341_i0 | PRJNA1198392 | 20482 | 242 | 1.822485 | 4.4104137 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 80.1 | 3.91e-16 | NR | HET6303176.1 | 2818507 | g20341 | i0 | 55.3 | 2.77685950413223 | 76 | 34 | 94.2 | 0 | 229 | 2 | 122 | 197 | HET6303176.1 crotonase/enoyl-CoA hydratase family protein [Myxococcota bacterium] | diamond | 672 | 80.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 27135317 | 27135317 | PRJNA1198392_P_NODE_17122_length_249_cov_0.875000_g16981_i0 | PRJNA1198392 | 17122 | 249 | 0.875 | 2.17875 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 87 | 9.62e-18 | NR | MEM9865836.1 | 2818507 | g16981 | i0 | 58.1 | 0.891566265060241 | 74 | 30 | 89.2 | 1 | 27 | 248 | 201 | 273 | MEM9865836.1 RNA-binding protein [Myxococcota bacterium] | diamond | 222 | 87 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 27217639 | 27217639 | PRJNA1198392_P_NODE_21042_length_241_cov_1.785714_g20901_i0 | PRJNA1198392 | 21042 | 241 | 1.785714 | 4.30357074 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 45.4 | 0.00366 | NR | MBS2023511.1 | 2026735 | g20901 | i0 | 42.2 | 2.83817427385892 | 45 | 25 | 56 | 1 | 239 | 105 | 246 | 289 | MBS2023511.1 metal-dependent hydrolase [Deltaproteobacteria bacterium] | diamond | 684 | 45.8 | 0.991266375545852 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 27704701 | 27704701 | PRJNA1198392_P_NODE_8264_length_290_cov_1.419355_g8123_i0 | PRJNA1198392 | 8264 | 290 | 1.419355 | 4.1161295 | Labilithrix sp. | 1971228 | Bacteria | Bacteria | 78.2 | 1.38e-14 | NR | HSO31379.1 | 1971228 | g8123 | i0 | 52.6 | 1.97586206896552 | 97 | 38 | 95.2 | 4 | 289 | 14 | 192 | 285 | HSO31379.1 serine/threonine-protein kinase [Labilithrix sp.] | diamond | 573 | 78.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix sp. | |||
| 28714784 | 28714784 | PRJNA1198392_P_NODE_8507_length_289_cov_1.425926_g8366_i0 | PRJNA1198392 | 8507 | 289 | 1.425926 | 4.12092614 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 69.7 | 1.58e-11 | NR | MEO8800990.1 | 2268199 | g8366 | i0 | 60.5 | 1.39100346020761 | 43 | 16 | 43.6 | 1 | 275 | 150 | 301 | 343 | MEO8800990.1 PHB depolymerase family esterase [Polyangiaceae bacterium] | diamond | 402 | 69.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 30167139 | 30167139 | PRJNA1198392_P_NODE_17552_length_248_cov_0.880000_g17411_i0 | PRJNA1198392 | 17552 | 248 | 0.88 | 2.1824 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 83.6 | 2.92e-17 | NR | MCU0693776.1 | 2268199 | g17411 | i0 | 69.6 | 1.33064516129032 | 56 | 17 | 67.7 | 0 | 79 | 246 | 1 | 56 | MCU0693776.1 SDR family NAD(P)-dependent oxidoreductase [Polyangiaceae bacterium] | diamond | 330 | 83.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 32222265 | 32222265 | PRJNA1198392_P_NODE_11498_length_275_cov_1.475248_g11357_i0 | PRJNA1198392 | 11498 | 275 | 1.475248 | 4.056932 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 129 | 1.4999999999999995e-32 | NR | MEO7109371.1 | 2268199 | g11357 | i0 | 65.9 | 0.992727272727273 | 91 | 30 | 99.3 | 1 | 1 | 273 | 404 | 493 | MEO7109371.1 sulfatase-like hydrolase/transferase [Polyangiaceae bacterium] | diamond | 273 | 129 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 32632993 | 32632993 | PRJNA1198392_P_NODE_12920_length_268_cov_1.256410_g12779_i0 | PRJNA1198392 | 12920 | 268 | 1.25641 | 3.3671788 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 49.7 | 1.63e-4 | NR | MCA9623104.1 | 2026763 | g12779 | i0 | 38 | 0.794776119402985 | 71 | 44 | 79.5 | 0 | 266 | 54 | 213 | 283 | MCA9623104.1 hypothetical protein [Myxococcales bacterium] | diamond | 213 | 49.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales 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);;