contig_metadata
21 rows where bioproject = "PRJNA760976", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14771312 | 14771312 | PRJNA760976_P_NODE_48012_length_251_cov_0.915730_g47691_i0 | PRJNA760976 | 48012 | 251 | 0.91573 | 2.2984823 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 154 | 8.38e-42 | NR | MBI2485459.1 | 2026735 | g47691 | i0 | 79.5 | 15.8725099601594 | 83 | 17 | 99.2 | 0 | 250 | 2 | 362 | 444 | MBI2485459.1 phosphoenolpyruvate carboxykinase (GTP) [Deltaproteobacteria bacterium] | diamond | 3984 | 154 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 22419648 | 22419648 | PRJNA760976_P_NODE_28938_length_306_cov_1.888412_g28617_i0 | PRJNA760976 | 28938 | 306 | 1.888412 | 5.77854072 | Pendulispora brunnea | 2905690 | Bacteria | Bacteria | 302 | 2.5700000000000002e-77 | NTclustered | gi|2698055994|gb|CP089982.1| | 2905690 | g28617 | i0 | 84.641 | 353.59477124183 | 306 | 44 | 99 | 3 | 3 | 306 | 9037910 | 9038214 | Pendulispora brunnea strain MSr12523 chromosome, complete genome | blastn | 108200 | 302 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora brunnea | ||
| 26745909 | 26745909 | PRJNA760976_P_NODE_32781_length_293_cov_1.045455_g32460_i0 | PRJNA760976 | 32781 | 293 | 1.045455 | 3.06318315 | Bacteria | 2 | Bacteria | Bacteria | 122 | 5.21e-30 | NR | TMB15647.1 | 2026735 | g32460 | i0 | 62.4 | 6.64505119453925 | 93 | 33 | 95.2 | 2 | 286 | 8 | 968 | 1058 | TMB15647.1 MAG: hypothetical protein E6J71_18480, partial [Deltaproteobacteria bacterium] | diamond | 1947 | 122 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 26989623 | 26989623 | PRJNA760976_P_NODE_56322_length_241_cov_0.904762_g56001_i0 | PRJNA760976 | 56322 | 241 | 0.904762 | 2.18047642 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 79 | 4.24e-15 | NR | MEW5742578.1 | 2818507 | g56001 | i0 | 44.6 | 2.83817427385892 | 74 | 41 | 92.1 | 0 | 222 | 1 | 147 | 220 | MEW5742578.1 PHB depolymerase family esterase [Myxococcota bacterium] | diamond | 684 | 79 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 27189091 | 27189091 | PRJNA760976_P_NODE_47642_length_251_cov_2.471910_g47321_i0 | PRJNA760976 | 47642 | 251 | 2.47191 | 6.2044941 | Bacteria | 2 | Bacteria | Bacteria | 68.2 | 3.52e-11 | NR | MBA3542242.1 | 2026735 | g47321 | i0 | 41.3 | 1.47011952191235 | 63 | 35 | 72.9 | 1 | 195 | 13 | 29 | 91 | MBA3542242.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 369 | 68.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 27210964 | 27210964 | PRJNA760976_P_NODE_30482_length_301_cov_0.934211_g30161_i0 | PRJNA760976 | 30482 | 301 | 0.934211 | 2.81197511 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 60.1 | 5.96e-8 | NR | MBR56859.1 | 2026763 | g30161 | i0 | 42.4 | 0.847176079734219 | 85 | 32 | 69.8 | 4 | 210 | 1 | 227 | 309 | MBR56859.1 hypothetical protein [Myxococcales bacterium] | diamond | 255 | 60.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 27495592 | 27495592 | PRJNA760976_P_NODE_53943_length_243_cov_0.905882_g53622_i0 | PRJNA760976 | 53943 | 243 | 0.905882 | 2.20129326 | Nannocystis bainbridge | 2995303 | Bacteria | Bacteria | 47.8 | 1.55e-4 | NR | WP_272092255.1 | 2995303 | g53622 | i0 | 39.1 | 2.34567901234568 | 64 | 33 | 76.5 | 2 | 1 | 186 | 62 | 121 | WP_272092255.1 beta/gamma crystallin-related protein [Nannocystis bainbridge] | diamond | 570 | 47.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Nannocystales | Nannocystaceae | Nannocystis | Nannocystis bainbridge | |||
| 27536819 | 27536819 | PRJNA760976_P_NODE_16743_length_371_cov_1.530201_g16422_i0 | PRJNA760976 | 16743 | 371 | 1.530201 | 5.67704571 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 121 | 2.21e-31 | NR | MBW2463484.1 | 2026735 | g16422 | i0 | 54.6 | 2.58760107816712 | 108 | 47 | 87.3 | 1 | 48 | 371 | 98 | 203 | MBW2463484.1 HD domain-containing protein [Deltaproteobacteria bacterium] | diamond | 960 | 121 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 28253214 | 28253214 | PRJNA760976_P_NODE_55566_length_242_cov_0.869822_g55245_i0 | PRJNA760976 | 55566 | 242 | 0.869822 | 2.10496924 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 40.8 | 0.0481 | NR | MDP3040544.1 | 2026735 | g55245 | i0 | 45.5 | 0.545454545454545 | 44 | 24 | 54.5 | 0 | 49 | 180 | 20 | 63 | MDP3040544.1 HU family DNA-binding protein [Deltaproteobacteria bacterium] | diamond | 132 | 40.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 28474340 | 28474340 | PRJNA760976_P_NODE_25366_length_321_cov_1.241935_g25045_i0 | PRJNA760976 | 25366 | 321 | 1.241935 | 3.98661135 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 57.4 | 6.33e-7 | NR | MDD9968233.1 | 2026763 | g25045 | i0 | 32.7 | 0.91588785046729 | 98 | 46 | 74.8 | 3 | 17 | 256 | 255 | 350 | MDD9968233.1 hypothetical protein [Myxococcales bacterium] | diamond | 294 | 57.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 28821318 | 28821318 | PRJNA760976_P_NODE_50388_length_247_cov_0.885057_g50067_i0 | PRJNA760976 | 50388 | 247 | 0.885057 | 2.18609079 | Polyangiales bacterium | 3034171 | Bacteria | Bacteria | 58.9 | 7.28e-8 | NR | MFO0557563.1 | 3034171 | g50067 | i0 | 55.8 | 0.631578947368421 | 52 | 20 | 59.5 | 1 | 2 | 148 | 266 | 317 | MFO0557563.1 hypothetical protein [Polyangiales bacterium] | diamond | 156 | 58.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiales bacterium | |||||
| 28831200 | 28831200 | PRJNA760976_P_NODE_7248_length_508_cov_1.494253_g6930_i0 | PRJNA760976 | 7248 | 508 | 1.494253 | 7.59080524 | Myxococcia | 32015 | Bacteria | Bacteria | 71.2 | 6.64e-11 | NR | HXK18886.1 | 2268199 | g6930 | i0 | 36.8 | 5.40944881889764 | 144 | 70 | 75 | 7 | 382 | 2 | 205 | 344 | HXK18886.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 2748 | 71.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 29084003 | 29084003 | PRJNA760976_P_NODE_49188_length_249_cov_0.875000_g48867_i0 | PRJNA760976 | 49188 | 249 | 0.875 | 2.17875 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 97.4 | 1.4500000000000002e-21 | NR | MBL9103692.1 | 2026763 | g48867 | i0 | 54.9 | 6.91566265060241 | 82 | 37 | 98.8 | 0 | 3 | 248 | 197 | 278 | MBL9103692.1 ATP-binding protein [Myxococcales bacterium] | diamond | 1722 | 97.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 29579139 | 29579139 | PRJNA760976_P_NODE_6810_length_521_cov_2.100446_g6492_i0 | PRJNA760976 | 6810 | 521 | 2.100446 | 10.94332366 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 47 | 0.0194 | NR | MBM4370521.1 | 2026735 | g6492 | i0 | 43.9 | 0.662188099808061 | 57 | 29 | 31.1 | 1 | 306 | 467 | 1847 | 1903 | MBM4370521.1 proprotein convertase P-domain-containing protein [Deltaproteobacteria bacterium] | diamond | 345 | 47 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29642242 | 29642242 | PRJNA760976_P_NODE_18990_length_355_cov_1.329787_g18669_i0 | PRJNA760976 | 18990 | 355 | 1.329787 | 4.72074385 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 54.7 | 8.57e-6 | NR | MBR56859.1 | 2026763 | g18669 | i0 | 35.3 | 2.72112676056338 | 85 | 43 | 71.8 | 3 | 337 | 83 | 238 | 310 | MBR56859.1 hypothetical protein [Myxococcales bacterium] | diamond | 966 | 54.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 29778436 | 29778436 | PRJNA760976_P_NODE_16931_length_370_cov_1.037037_g16610_i0 | PRJNA760976 | 16931 | 370 | 1.037037 | 3.8370369 | Myxococcia | 32015 | Bacteria | Bacteria | 47 | 0.00507 | NR | MCA9609235.1 | 2026763 | g16610 | i0 | 28.3 | 1.84054054054054 | 113 | 79 | 90.8 | 2 | 22 | 357 | 269 | 380 | MCA9609235.1 hypothetical protein [Myxococcales bacterium] | diamond | 681 | 47 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 30937949 | 30937949 | PRJNA760976_P_NODE_9534_length_458_cov_1.171429_g9215_i0 | PRJNA760976 | 9534 | 458 | 1.171429 | 5.36514482 | Nannocystaceae bacterium | 2545255 | Bacteria | Bacteria | 95.1 | 1.72e-19 | NR | MEZ4384866.1 | 2545255 | g9215 | i0 | 34.8 | 0.923580786026201 | 141 | 87 | 89.1 | 3 | 23 | 430 | 221 | 361 | MEZ4384866.1 carotenoid oxygenase family protein [Nannocystaceae bacterium] | diamond | 423 | 95.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Nannocystales | Nannocystaceae | Nannocystaceae bacterium | ||||
| 31317055 | 31317055 | PRJNA760976_P_NODE_31035_length_299_cov_0.991150_g30714_i0 | PRJNA760976 | 31035 | 299 | 0.99115 | 2.9635385 | Sorangium cellulosum | 56 | Bacteria | Bacteria | 48.9 | 4.82e-4 | NR | WP_157906402.1 | 56 | g30714 | i0 | 46.3 | 0.54180602006689 | 54 | 28 | 53.2 | 1 | 116 | 274 | 125 | 178 | WP_157906402.1 right-handed parallel beta-helix repeat-containing protein [Sorangium cellulosum] | diamond | 162 | 48.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Sorangium | Sorangium cellulosum | |||
| 31664857 | 31664857 | PRJNA760976_P_NODE_21977_length_338_cov_0.871698_g21656_i0 | PRJNA760976 | 21977 | 338 | 0.871698 | 2.94633924 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 54.7 | 7.34e-6 | NR | MEM6295469.1 | 2818507 | g21656 | i0 | 29.5 | 3.70118343195266 | 88 | 59 | 75.4 | 1 | 79 | 333 | 601 | 688 | MEM6295469.1 serine/threonine-protein kinase [Myxococcota bacterium] | diamond | 1251 | 54.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 32276023 | 32276023 | PRJNA760976_P_NODE_11678_length_424_cov_1.433048_g11358_i0 | PRJNA760976 | 11678 | 424 | 1.433048 | 6.07612352 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 53.1 | 4.94e-5 | NR | MCB9644768.1 | 2026763 | g11358 | i0 | 47.1 | 1.69811320754717 | 51 | 26 | 36.1 | 1 | 11 | 163 | 113 | 162 | MCB9644768.1 hypothetical protein [Myxococcales bacterium] | diamond | 720 | 53.5 | 0.992523364485981 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 32456141 | 32456141 | PRJNA760976_P_NODE_18679_length_357_cov_1.408451_g18358_i0 | PRJNA760976 | 18679 | 357 | 1.408451 | 5.02817007 | Chondromyces crocatus | 52 | Bacteria | Bacteria | 136 | 4.06e-35 | NR | WP_050432504.1 | 52 | g18358 | i0 | 59 | 0.983193277310924 | 117 | 44 | 98.3 | 1 | 355 | 5 | 9 | 121 | WP_050432504.1 NAD(P)/FAD-dependent oxidoreductase [Chondromyces crocatus] | diamond | 351 | 136 | 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);;