contig_metadata
22 rows where bioproject = "PRJNA597223", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2416209 | 2416209 | PRJNA597223_P_NODE_8922_length_582_cov_186.881170_g7352_i0 | PRJNA597223 | 8922 | 582 | 186.88117 | 1087.6484094 | Myxococcia | 32015 | Bacteria | Bacteria | 863 | 0 | NTclustered | gi|913610804|gb|CP012333.1| | 1391654 | g7352 | i0 | 93.46 | 137.798969072165 | 581 | 38 | 99 | 0 | 1 | 581 | 7089725 | 7090305 | Labilithrix luteola strain DSM 27648, complete genome | blastn | 80199 | 863 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix luteola | |||
| 10773198 | 10773198 | PRJNA597223_P_NODE_21369_length_346_cov_4.877814_g19530_i0 | PRJNA597223 | 21369 | 346 | 4.877814 | 16.87723644 | Labilithrix luteola | 1391654 | Bacteria | Bacteria | 446 | 1.29e-120 | NTclustered | gi|913610804|gb|CP012333.1| | 1391654 | g19530 | i0 | 89.943 | 201.384393063584 | 348 | 31 | 100 | 4 | 1 | 346 | 3942296 | 3941951 | Labilithrix luteola strain DSM 27648, complete genome | blastn | 69679 | 446 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix luteola | |||
| 12619934 | 12619934 | PRJNA597223_P_NODE_9670_length_558_cov_10.074570_g8042_i0 | PRJNA597223 | 9670 | 558 | 10.07457 | 56.2161006 | Pendulispora | 3375062 | Bacteria | Bacteria | 839 | 0 | NTclustered | gi|2698045512|gb|CP089929.1| | 2741070 | g8042 | i0 | 93.907 | 171.584229390681 | 558 | 30 | 100 | 3 | 1 | 558 | 7288976 | 7289529 | Pendulispora rubella strain MSr11368 chromosome, complete genome | blastn | 95744 | 839 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora rubella | ||
| 14598151 | 14598151 | PRJNA597223_P_NODE_56152_length_188_cov_2.241830_g54306_i0 | PRJNA597223 | 56152 | 188 | 2.24183 | 4.2146404 | Polyangium aurulentum | 2567896 | Bacteria | Bacteria | 159 | 9.229999999999999e-35 | NTclustered | gi|2235996827|gb|CP079217.1| | 2567896 | g54306 | i0 | 94.286 | 7.88297872340426 | 105 | 4 | 92 | 2 | 1 | 104 | 443064 | 443167 | Polyangium aurulentum strain SDU3-1 chromosome, complete genome | blastn | 1482 | 159 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangium | Polyangium aurulentum | |||
| 16443487 | 16443487 | PRJNA597223_P_NODE_55693_length_188_cov_669.947712_g53847_i0 | PRJNA597223 | 55693 | 188 | 669.947712 | 1259.50169856 | Pendulispora | 3375062 | Bacteria | Bacteria | 257 | 3.1800000000000004e-64 | NTclustered | gi|2698045512|gb|CP089929.1| | 2741070 | g53847 | i0 | 91.444 | 557.574468085106 | 187 | 16 | 99 | 0 | 1 | 187 | 7289010 | 7288824 | Pendulispora rubella strain MSr11368 chromosome, complete genome | blastn | 104824 | 257 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora rubella | ||
| 17146693 | 17146693 | PRJNA597223_P_NODE_34254_length_250_cov_7.395349_g32408_i0 | PRJNA597223 | 34254 | 250 | 7.395349 | 18.4883725 | Pendulispora albinea | 2741071 | Bacteria | Bacteria | 255 | 1.61e-63 | NTclustered | gi|2698035964|gb|CP089984.1| | 2741071 | g32408 | i0 | 85.433 | 52.936 | 254 | 27 | 99 | 9 | 1 | 248 | 3589471 | 3589222 | Pendulispora albinea strain MSr11954 chromosome, complete genome | blastn | 13234 | 255 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora albinea | ||
| 17146807 | 17146807 | PRJNA597223_P_NODE_43794_length_213_cov_6.280899_g41948_i0 | PRJNA597223 | 43794 | 213 | 6.280899 | 13.37831487 | Labilithrix luteola | 1391654 | Bacteria | Bacteria | 333 | 5.979999999999998e-87 | NTclustered | gi|913610804|gb|CP012333.1| | 1391654 | g41948 | i0 | 94.836 | 148.112676056338 | 213 | 11 | 100 | 0 | 1 | 213 | 3943857 | 3944069 | Labilithrix luteola strain DSM 27648, complete genome | blastn | 31548 | 333 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix luteola | |||
| 22246378 | 22246378 | PRJNA597223_P_NODE_5418_length_749_cov_143.446779_g4152_i0 | PRJNA597223 | 5418 | 749 | 143.446779 | 1074.41637471 | Labilithrix luteola | 1391654 | Bacteria | Bacteria | 1114 | 0 | NTclustered | gi|913610804|gb|CP012333.1| | 1391654 | g4152 | i0 | 93.583 | 142.069425901202 | 748 | 46 | 99 | 2 | 2 | 748 | 7089559 | 7090305 | Labilithrix luteola strain DSM 27648, complete genome | blastn | 106410 | 1114 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix luteola | |||
| 22817831 | 22817831 | PRJNA597223_P_NODE_1838_length_1249_cov_273.705107_g1198_i0 | PRJNA597223 | 1838 | 1249 | 273.705107 | 3418.57678643 | Haliangium | 162027 | Bacteria | Bacteria | 1170 | 0 | NTclustered | gi|470485361|ref|NR_076697.1| | 80816 | g1198 | i0 | 83.797 | 155.436349079263 | 1259 | 177 | 99 | 23 | 5 | 1249 | 1776 | 531 | Haliangium ochraceum strain SMP-2 23S ribosomal RNA gene, complete sequence | blastn | 194140 | 1170 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Haliangium | Haliangium ochraceum | |||
| 23521640 | 23521640 | PRJNA597223_P_NODE_6279_length_695_cov_155.963636_g4910_i0 | PRJNA597223 | 6279 | 695 | 155.963636 | 1083.9472702 | Pendulispora brunnea | 2905690 | Bacteria | Bacteria | 957 | 0 | NTclustered | gi|2698055994|gb|CP089982.1| | 2905690 | g4910 | i0 | 92.782 | 137.174100719424 | 665 | 42 | 95 | 6 | 1 | 662 | 7408722 | 7408061 | Pendulispora brunnea strain MSr12523 chromosome, complete genome | blastn | 95336 | 957 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora brunnea | ||
| 24795205 | 24795205 | PRJNA597223_P_NODE_42640_length_217_cov_2.461538_g40794_i0 | PRJNA597223 | 42640 | 217 | 2.461538 | 5.34153746 | Nannocystis exedens | 54 | Bacteria | Bacteria | 368 | 1.68e-97 | NTclustered | gi|2244669|emb|X87286.1| | 54 | g40794 | i0 | 97.235 | 114.884792626728 | 217 | 6 | 100 | 0 | 1 | 217 | 1343 | 1127 | N.exedens 23S rRNA gene | blastn | 24930 | 368 | 1 | Bacteria | Pseudomonadati | Myxococcota | Nannocystales | Nannocystaceae | Nannocystis | Nannocystis exedens | |||
| 27111289 | 27111289 | PRJNA597223_P_NODE_26922_length_297_cov_2.301527_g25076_i0 | PRJNA597223 | 26922 | 297 | 2.301527 | 6.83553519 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 46.2 | 0.00203 | NR | MCA9527719.1 | 2026763 | g25076 | i0 | 40.8 | 1.12121212121212 | 49 | 29 | 49.5 | 0 | 32 | 178 | 106 | 154 | MCA9527719.1 lipocalin family protein [Myxococcales bacterium] | diamond | 333 | 46.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 27174436 | 27174436 | PRJNA597223_P_NODE_72362_length_167_cov_2.000000_g70516_i0 | PRJNA597223 | 72362 | 167 | 2 | 3.34 | Polyangiales bacterium | 3034171 | Bacteria | Bacteria | 45.1 | 0.002 | NR | HTU61472.1 | 3034171 | g70516 | i0 | 38.8 | 0.880239520958084 | 49 | 30 | 88 | 0 | 16 | 162 | 153 | 201 | HTU61472.1 hypothetical protein [Polyangiales bacterium] | diamond | 147 | 45.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiales bacterium | |||||
| 27301168 | 27301168 | PRJNA597223_P_NODE_47483_length_203_cov_2.738095_g45637_i0 | PRJNA597223 | 47483 | 203 | 2.738095 | 5.55833285 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 82 | 3.13e-16 | NR | MDD9853257.1 | 2026735 | g45637 | i0 | 65.6 | 5.30541871921182 | 61 | 21 | 90.1 | 0 | 19 | 201 | 493 | 553 | MDD9853257.1 reverse transcriptase [Deltaproteobacteria bacterium] | diamond | 1077 | 82 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 28311644 | 28311644 | PRJNA597223_P_NODE_54066_length_190_cov_1.961290_g52220_i0 | PRJNA597223 | 54066 | 190 | 1.96129 | 3.726451 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 40.8 | 0.0188 | NR | MBI5517049.1 | 2026735 | g52220 | i0 | 66.7 | 0.378947368421053 | 24 | 8 | 37.9 | 0 | 5 | 76 | 15 | 38 | MBI5517049.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 72 | 40.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29416503 | 29416503 | PRJNA597223_P_NODE_22889_length_331_cov_3.972973_g21046_i0 | PRJNA597223 | 22889 | 331 | 3.972973 | 13.15054063 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 145 | 1.25e-37 | NR | MBN8536083.1 | 2026735 | g21046 | i0 | 73.6 | 2.99093655589124 | 110 | 29 | 99.7 | 0 | 2 | 331 | 386 | 495 | MBN8536083.1 ATP-dependent chaperone ClpB [Deltaproteobacteria bacterium] | diamond | 990 | 145 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29556140 | 29556140 | PRJNA597223_P_NODE_69750_length_171_cov_1.705882_g67904_i0 | PRJNA597223 | 69750 | 171 | 1.705882 | 2.91705822 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 102 | 1.0199999999999999e-23 | NR | WP_050430577.1 | 52 | g67904 | i0 | 76.7 | 5.26315789473684 | 60 | 11 | 100 | 1 | 171 | 1 | 490 | 549 | WP_050430577.1 5-methyltetrahydropteroyltriglutamate--homocysteine S-methyltransferase [Chondromyces crocatus] | diamond | 900 | 103 | 0.990291262135922 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Chondromyces | Chondromyces crocatus | |||
| 29763773 | 29763773 | PRJNA597223_P_NODE_69691_length_171_cov_1.911765_g67845_i0 | PRJNA597223 | 69691 | 171 | 1.911765 | 3.26911815 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 73.2 | 6.51e-14 | NR | HVH07384.1 | 2818507 | g67845 | i0 | 65.4 | 0.912280701754386 | 52 | 18 | 91.2 | 0 | 160 | 5 | 20 | 71 | HVH07384.1 helix-turn-helix domain-containing protein [Myxococcota bacterium] | diamond | 156 | 73.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 31153720 | 31153720 | PRJNA597223_P_NODE_72755_length_167_cov_1.000000_g70909_i0 | PRJNA597223 | 72755 | 167 | 1 | 1.67 | Myxococcaceae bacterium | 2484252 | Bacteria | Bacteria | 84.3 | 2.84e-17 | NR | MER2562634.1 | 2484252 | g70909 | i0 | 74.1 | 0.970059880239521 | 54 | 14 | 97 | 0 | 1 | 162 | 413 | 466 | MER2562634.1 IS21 family transposase [Myxococcaceae bacterium] | diamond | 162 | 84.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcaceae bacterium | |||
| 31470503 | 31470503 | PRJNA597223_P_NODE_65616_length_178_cov_1.664336_g63770_i0 | PRJNA597223 | 65616 | 178 | 1.664336 | 2.96251808 | Sandaracinaceae bacterium | 2510337 | Bacteria | Bacteria | 89 | 4.24e-20 | NR | MCS6856218.1 | 2510337 | g63770 | i0 | 66.1 | 1.98876404494382 | 59 | 20 | 99.4 | 0 | 177 | 1 | 112 | 170 | MCS6856218.1 peroxiredoxin [Sandaracinaceae bacterium] | diamond | 354 | 89 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Sandaracinaceae | Sandaracinaceae bacterium | ||||
| 32293216 | 32293216 | PRJNA597223_P_NODE_40879_length_223_cov_2.287234_g39033_i0 | PRJNA597223 | 40879 | 223 | 2.287234 | 5.10053182 | Archangium lipolyticum | 2970465 | Bacteria | Bacteria | 56.2 | 3.26e-7 | NR | WP_257447582.1 | 2970465 | g39033 | i0 | 54 | 0.672645739910314 | 50 | 18 | 60.5 | 1 | 87 | 221 | 1 | 50 | WP_257447582.1 beta-ketoacyl synthase chain length factor [Archangium lipolyticum] | diamond | 150 | 56.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium lipolyticum | ||
| 32577701 | 32577701 | PRJNA597223_P_NODE_30279_length_274_cov_1.062762_g28433_i0 | PRJNA597223 | 30279 | 274 | 1.062762 | 2.91196788 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 44.3 | 0.00208 | NR | RYF12390.1 | 2026735 | g28433 | i0 | 50 | 0.45985401459854 | 42 | 21 | 46 | 0 | 107 | 232 | 26 | 67 | RYF12390.1 MAG: membrane protein insertion efficiency factor YidD [Deltaproteobacteria bacterium] | diamond | 126 | 44.3 | 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);;