contig_metadata
28 rows where bioproject = "PRJNA407886", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2358075 | 2358075 | PRJNA407886_P_NODE_79842_length_242_cov_1.781065_g78148_i0 | PRJNA407886 | 79842 | 242 | 1.781065 | 4.3101773 | Sandaracinus | 1055688 | Bacteria | Bacteria | 121 | 1.04e-32 | NR | MFO0685325.1 | 2024858 | g78148 | i0 | 73.2 | 11.4917355371901 | 71 | 19 | 88 | 0 | 14 | 226 | 62 | 132 | MFO0685325.1 superoxide dismutase [Sandaracinus sp.] | diamond | 2781 | 122 | 0.991803278688525 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Sandaracinaceae | Sandaracinus | Sandaracinus sp. | |||
| 5521845 | 5521845 | PRJNA407886_P_NODE_73205_length_248_cov_0.880000_g71511_i0 | PRJNA407886 | 73205 | 248 | 0.88 | 2.1824 | Corallococcus sp. NCRR | 2996782 | Bacteria | Bacteria | 87.9 | 6.15e-13 | NTclustered | gi|2415015785|gb|CP114039.1| | 2996782 | g71511 | i0 | 83.696 | 1.19758064516129 | 92 | 15 | 37 | 0 | 20 | 111 | 9443839 | 9443748 | Corallococcus sp. NCRR chromosome, complete genome | blastn | 297 | 87.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Corallococcus | Corallococcus sp. NCRR | ||
| 13171897 | 13171897 | PRJNA407886_P_NODE_79791_length_242_cov_1.822485_g78097_i0 | PRJNA407886 | 79791 | 242 | 1.822485 | 4.4104137 | Myxococcaceae bacterium | 2484252 | Bacteria | Bacteria | 150 | 4.39e-42 | NR | RYZ13579.1 | 2484252 | g78097 | i0 | 92.5 | 0.991735537190083 | 80 | 6 | 99.2 | 0 | 2 | 241 | 184 | 263 | RYZ13579.1 MAG: ABC-F family ATP-binding cassette domain-containing protein, partial [Myxococcaceae bacterium] | diamond | 240 | 150 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcaceae bacterium | |||
| 21484146 | 21484146 | PRJNA407886_P_NODE_60857_length_272_cov_1.482412_g59163_i0 | PRJNA407886 | 60857 | 272 | 1.482412 | 4.03216064 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 86.7 | 8.95e-18 | NR | MCC7107856.1 | 2026735 | g59163 | i0 | 80 | 1.10294117647059 | 50 | 10 | 55.1 | 0 | 2 | 151 | 302 | 351 | MCC7107856.1 helix-turn-helix transcriptional regulator [Deltaproteobacteria bacterium] | diamond | 300 | 86.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 27328475 | 27328475 | PRJNA407886_P_NODE_32503_length_396_cov_1.430341_g30809_i0 | PRJNA407886 | 32503 | 396 | 1.430341 | 5.66415036 | Archangium gephyra | 48 | Bacteria | Bacteria | 50.4 | 1.8e-4 | NR | WP_375765066.1 | 48 | g30809 | i0 | 43.8 | 0.484848484848485 | 64 | 32 | 45.5 | 1 | 216 | 395 | 4 | 67 | WP_375765066.1 hypothetical protein [Archangium gephyra] | diamond | 192 | 50.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium gephyra | ||
| 27376940 | 27376940 | PRJNA407886_P_NODE_51703_length_298_cov_2.048889_g50009_i0 | PRJNA407886 | 51703 | 298 | 2.048889 | 6.10568922 | Bacteria | 2 | Bacteria | Bacteria | 51.6 | 5.76e-5 | NR | MBT6489693.1 | 2026735 | g50009 | i0 | 46.2 | 5.85906040268456 | 52 | 23 | 47.3 | 2 | 7 | 147 | 1544 | 1595 | MBT6489693.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 1746 | 52 | 0.992307692307692 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 27391761 | 27391761 | PRJNA407886_P_NODE_72003_length_249_cov_0.875000_g70309_i0 | PRJNA407886 | 72003 | 249 | 0.875 | 2.17875 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 113 | 6.590000000000001e-27 | NR | MBP9863556.1 | 2212474 | g70309 | i0 | 65.4 | 0.975903614457831 | 81 | 28 | 97.6 | 0 | 6 | 248 | 754 | 834 | MBP9863556.1 hypothetical protein [Kofleriaceae bacterium] | diamond | 243 | 113 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 27580952 | 27580952 | PRJNA407886_P_NODE_70024_length_251_cov_0.865169_g68330_i0 | PRJNA407886 | 70024 | 251 | 0.865169 | 2.17157419 | Polyangiales bacterium | 3034171 | Bacteria | Bacteria | 80.9 | 1.53e-15 | NR | MFO0692638.1 | 3034171 | g68330 | i0 | 43.2 | 0.968127490039841 | 81 | 46 | 96.8 | 0 | 244 | 2 | 344 | 424 | MFO0692638.1 hypothetical protein [Polyangiales bacterium] | diamond | 243 | 80.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiales bacterium | |||||
| 27928331 | 27928331 | PRJNA407886_P_NODE_36125_length_369_cov_2.398649_g34431_i0 | PRJNA407886 | 36125 | 369 | 2.398649 | 8.85101481 | Myxococcaceae bacterium | 2484252 | Bacteria | Bacteria | 189 | 3.1199999999999996e-56 | NR | RYZ13579.1 | 2484252 | g34431 | i0 | 75.6 | 1 | 123 | 30 | 100 | 0 | 1 | 369 | 66 | 188 | RYZ13579.1 MAG: ABC-F family ATP-binding cassette domain-containing protein, partial [Myxococcaceae bacterium] | diamond | 369 | 189 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcaceae bacterium | |||
| 28008324 | 28008324 | PRJNA407886_P_NODE_52785_length_295_cov_1.382883_g51091_i0 | PRJNA407886 | 52785 | 295 | 1.382883 | 4.07950485 | Archangium | 47 | Bacteria | Bacteria | 58.5 | 2.02e-7 | NR | MFT3708381.1 | 1872627 | g51091 | i0 | 43.4 | 2.89830508474576 | 106 | 45 | 96.6 | 7 | 289 | 5 | 766 | 867 | MFT3708381.1 hypothetical protein [Archangium sp.] | diamond | 855 | 58.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium sp. | ||
| 28307245 | 28307245 | PRJNA407886_P_NODE_49486_length_306_cov_1.433476_g47792_i0 | PRJNA407886 | 49486 | 306 | 1.433476 | 4.38643656 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 45.8 | 0.0065 | NR | HVJ14492.1 | 2268199 | g47792 | i0 | 32 | 0.735294117647059 | 75 | 42 | 68.6 | 3 | 74 | 283 | 92 | 162 | HVJ14492.1 beta-propeller domain-containing protein [Polyangiaceae bacterium] | diamond | 225 | 45.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 28843808 | 28843808 | PRJNA407886_P_NODE_71348_length_250_cov_0.870056_g69654_i0 | PRJNA407886 | 71348 | 250 | 0.870056 | 2.17514 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 52 | 2.31e-5 | NR | MCC6623602.1 | 2026735 | g69654 | i0 | 38.5 | 0.936 | 78 | 36 | 82.8 | 3 | 7 | 213 | 460 | 534 | MCC6623602.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 234 | 52 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 28875547 | 28875547 | PRJNA407886_P_NODE_58528_length_278_cov_1.829268_g56834_i0 | PRJNA407886 | 58528 | 278 | 1.829268 | 5.08536504 | Myxococcaceae bacterium | 2484252 | Bacteria | Bacteria | 160 | 9.91e-46 | NR | RYZ13579.1 | 2484252 | g56834 | i0 | 85.9 | 0.992805755395683 | 92 | 13 | 99.3 | 0 | 276 | 1 | 297 | 388 | RYZ13579.1 MAG: ABC-F family ATP-binding cassette domain-containing protein, partial [Myxococcaceae bacterium] | diamond | 276 | 160 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcaceae bacterium | |||
| 29002317 | 29002317 | PRJNA407886_P_NODE_81428_length_241_cov_0.916667_g79734_i0 | PRJNA407886 | 81428 | 241 | 0.916667 | 2.20916747 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 42.4 | 0.0479 | NR | MES2504807.1 | 2818507 | g79734 | i0 | 33.3 | 0.634854771784232 | 51 | 31 | 63.5 | 2 | 77 | 229 | 144 | 191 | MES2504807.1 hypothetical protein [Myxococcota bacterium] | diamond | 153 | 42.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 29506973 | 29506973 | PRJNA407886_P_NODE_81370_length_241_cov_0.916667_g79676_i0 | PRJNA407886 | 81370 | 241 | 0.916667 | 2.20916747 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 89 | 2.12e-19 | NR | MBL8683519.1 | 2026763 | g79676 | i0 | 57.4 | 1.73029045643154 | 61 | 26 | 75.9 | 0 | 4 | 186 | 70 | 130 | MBL8683519.1 fatty acid desaturase family protein [Myxococcales bacterium] | diamond | 417 | 89 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 29696087 | 29696087 | PRJNA407886_P_NODE_57850_length_280_cov_1.487923_g56156_i0 | PRJNA407886 | 57850 | 280 | 1.487923 | 4.1661844 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 59.3 | 8.56e-8 | NR | MED5463341.1 | 2818507 | g56156 | i0 | 46 | 0.675 | 63 | 31 | 67.5 | 1 | 240 | 52 | 171 | 230 | MED5463341.1 5'-nucleotidase C-terminal domain-containing protein [Myxococcota bacterium] | diamond | 189 | 59.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 29759504 | 29759504 | PRJNA407886_P_NODE_78531_length_243_cov_2.452941_g76837_i0 | PRJNA407886 | 78531 | 243 | 2.452941 | 5.96064663 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 87.8 | 2.14e-18 | NR | MCA9578702.1 | 2026763 | g76837 | i0 | 59.8 | 3.02469135802469 | 82 | 31 | 100 | 2 | 1 | 243 | 82 | 162 | MCA9578702.1 oxaloacetate-decarboxylating malate dehydrogenase [Myxococcales bacterium] | diamond | 735 | 87.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 29807773 | 29807773 | PRJNA407886_P_NODE_63271_length_266_cov_1.196891_g61577_i0 | PRJNA407886 | 63271 | 266 | 1.196891 | 3.18373006 | Bacteria | 2 | Bacteria | Bacteria | 105 | 3.12e-24 | NR | MCB9639759.1 | 2026763 | g61577 | i0 | 58.8 | 2.93233082706767 | 85 | 35 | 95.9 | 0 | 11 | 265 | 891 | 975 | MCB9639759.1 NAD-glutamate dehydrogenase [Myxococcales bacterium] | diamond | 780 | 105 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 29997544 | 29997544 | PRJNA407886_P_NODE_32791_length_393_cov_2.615625_g31097_i0 | PRJNA407886 | 32791 | 393 | 2.615625 | 10.27940625 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 76.6 | 1.19e-14 | NR | MBN2468948.1 | 2026735 | g31097 | i0 | 47.1 | 3.88549618320611 | 85 | 39 | 64.9 | 1 | 389 | 135 | 77 | 155 | MBN2468948.1 Hsp20/alpha crystallin family protein [Deltaproteobacteria bacterium] | diamond | 1527 | 76.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 30075413 | 30075413 | PRJNA407886_P_NODE_82032_length_241_cov_0.916667_g80338_i0 | PRJNA407886 | 82032 | 241 | 0.916667 | 2.20916747 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 67 | 1e-10 | NR | HAA54013.1 | 2026763 | g80338 | i0 | 48.7 | 5.850622406639 | 78 | 37 | 94.6 | 2 | 236 | 9 | 867 | 943 | HAA54013.1 hypothetical protein [Myxococcales bacterium] | diamond | 1410 | 67 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 30170153 | 30170153 | PRJNA407886_P_NODE_58952_length_277_cov_1.500000_g57258_i0 | PRJNA407886 | 58952 | 277 | 1.5 | 4.155 | Polyangia bacterium | 3058050 | Bacteria | Bacteria | 57.4 | 3.97e-7 | NR | HLK93526.1 | 3058050 | g57258 | i0 | 40.5 | 0.8014440433213 | 74 | 39 | 75.8 | 2 | 14 | 223 | 110 | 182 | HLK93526.1 hypothetical protein [Polyangia bacterium] | diamond | 222 | 57.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangia bacterium | ||||||
| 30170172 | 30170172 | PRJNA407886_P_NODE_80052_length_242_cov_1.266272_g78358_i0 | PRJNA407886 | 80052 | 242 | 1.266272 | 3.06437824 | Aetherobacter fasciculatus | 888830 | Bacteria | Bacteria | 42.4 | 0.0402 | NR | WP_346367567.1 | 888830 | g78358 | i0 | 46.9 | 0.607438016528926 | 49 | 25 | 59.5 | 1 | 235 | 92 | 116 | 164 | WP_346367567.1 hypothetical protein [Aetherobacter fasciculatus] | diamond | 147 | 42.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Aetherobacter | Aetherobacter fasciculatus | |||
| 30201602 | 30201602 | PRJNA407886_P_NODE_14932_length_722_cov_2.869029_g13338_i0 | PRJNA407886 | 14932 | 722 | 2.869029 | 20.71438938 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 91.7 | 1.61e-17 | NR | MBI4776311.1 | 2026735 | g13338 | i0 | 34.1 | 0.889196675900277 | 214 | 119 | 84.8 | 8 | 90 | 701 | 167 | 368 | MBI4776311.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 642 | 91.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 30297187 | 30297187 | PRJNA407886_P_NODE_79932_length_242_cov_1.526627_g78238_i0 | PRJNA407886 | 79932 | 242 | 1.526627 | 3.69443734 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 65.5 | 3.71e-10 | NR | MCC6623667.1 | 2026735 | g78238 | i0 | 52.5 | 0.731404958677686 | 59 | 27 | 73.1 | 1 | 185 | 9 | 3502 | 3559 | MCC6623667.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 177 | 65.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31212481 | 31212481 | PRJNA407886_P_NODE_20035_length_570_cov_2.006036_g18352_i0 | PRJNA407886 | 20035 | 570 | 2.006036 | 11.4344052 | Polyangiales bacterium | 3034171 | Bacteria | Bacteria | 159 | 1.77e-42 | NR | MFO0696186.1 | 3034171 | g18352 | i0 | 51.4 | 0.973684210526316 | 185 | 88 | 96.8 | 2 | 557 | 6 | 79 | 262 | MFO0696186.1 discoidin domain-containing protein [Polyangiales bacterium] | diamond | 555 | 159 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiales bacterium | |||||
| 31307751 | 31307751 | PRJNA407886_P_NODE_66435_length_258_cov_1.664865_g64741_i0 | PRJNA407886 | 66435 | 258 | 1.664865 | 4.2953517 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 51.6 | 3.59e-5 | NR | MEW5847593.1 | 2818507 | g64741 | i0 | 36.3 | 0.930232558139535 | 80 | 47 | 93 | 2 | 4 | 243 | 846 | 921 | MEW5847593.1 hypothetical protein [Myxococcota bacterium] | diamond | 240 | 51.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 32320480 | 32320480 | PRJNA407886_P_NODE_29599_length_422_cov_1.521490_g27906_i0 | PRJNA407886 | 29599 | 422 | 1.52149 | 6.4206878 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 50.8 | 3.26e-4 | NR | MEC9464894.1 | 2818507 | g27906 | i0 | 34.8 | 0.632701421800948 | 89 | 47 | 61.8 | 4 | 353 | 93 | 106 | 185 | MEC9464894.1 hypothetical protein [Myxococcota bacterium] | diamond | 267 | 50.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 32478595 | 32478595 | PRJNA407886_P_NODE_70239_length_251_cov_0.865169_g68545_i0 | PRJNA407886 | 70239 | 251 | 0.865169 | 2.17157419 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 121 | 5.019999999999999e-31 | NR | HEX4516865.1 | 2268199 | g68545 | i0 | 63.9 | 6.94422310756972 | 83 | 30 | 99.2 | 0 | 250 | 2 | 101 | 183 | HEX4516865.1 methyltransferase domain-containing protein [Polyangiaceae bacterium] | diamond | 1743 | 121 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae 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);;