contig_metadata
16 rows where bioproject = "PRJNA883229" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4688441 | 4688441 | PRJNA883229_P_NODE_9324_length_252_cov_0.871508_g9278_i0 | PRJNA883229 | 9324 | 252 | 0.871508 | 2.19620016 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 138 | 4.83e-36 | NR | MBP7125133.1 | 2818507 | g9278 | i0 | 68.7 | 0.988095238095238 | 83 | 26 | 98.8 | 0 | 1 | 249 | 484 | 566 | MBP7125133.1 hypothetical protein [Myxococcota bacterium] | diamond | 249 | 138 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 7238061 | 7238061 | PRJNA883229_P_NODE_13006_length_247_cov_0.896552_g12960_i0 | PRJNA883229 | 13006 | 247 | 0.896552 | 2.21448344 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 116 | 5.790000000000001e-29 | NR | MBL8786215.1 | 2026735 | g12960 | i0 | 70.7 | 0.995951417004049 | 82 | 24 | 99.6 | 0 | 246 | 1 | 109 | 190 | MBL8786215.1 ADP-forming succinate--CoA ligase subunit beta [Deltaproteobacteria bacterium] | diamond | 246 | 116 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 10169637 | 10169637 | PRJNA883229_P_NODE_13088_length_247_cov_0.896552_g13042_i0 | PRJNA883229 | 13088 | 247 | 0.896552 | 2.21448344 | Corallococcus | 83461 | Bacteria | Bacteria | 75 | 4.76e-9 | NTclustered | gi|337255776|gb|CP002830.1| | 35 | g13042 | i0 | 92.308 | 0.421052631578947 | 52 | 4 | 21 | 0 | 191 | 242 | 5421086 | 5421035 | Myxococcus macrosporus strain HW-1, complete genome | blastn | 104 | 75 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Corallococcus | Corallococcus macrosporus | ||
| 23812134 | 23812134 | PRJNA883229_P_NODE_10579_length_250_cov_0.881356_g10533_i0 | PRJNA883229 | 10579 | 250 | 0.881356 | 2.20339 | Archangium violaceum | 83451 | Bacteria | Bacteria | 292 | 1.2299999999999999e-74 | NTclustered | gi|1981856374|gb|CP069338.1| | 83451 | g10533 | i0 | 87.843 | 2.708 | 255 | 24 | 99 | 6 | 2 | 250 | 3989163 | 3988910 | Archangium violaceum strain SDU34 chromosome, complete genome | blastn | 677 | 292 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium violaceum | ||
| 27149742 | 27149742 | PRJNA883229_P_NODE_12562_length_248_cov_0.868571_g12516_i0 | PRJNA883229 | 12562 | 248 | 0.868571 | 2.15405608 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 45.4 | 0.00166 | NR | MBN2575724.1 | 2026735 | g12516 | i0 | 33.3 | 1.66935483870968 | 69 | 38 | 73.8 | 2 | 200 | 18 | 25 | 93 | MBN2575724.1 DUF1566 domain-containing protein [Deltaproteobacteria bacterium] | diamond | 414 | 45.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 27339969 | 27339969 | PRJNA883229_P_NODE_10323_length_251_cov_0.876404_g10277_i0 | PRJNA883229 | 10323 | 251 | 0.876404 | 2.19977404 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 135 | 5.3e-36 | NR | MBN2397300.1 | 2026735 | g10277 | i0 | 75.9 | 2.97609561752988 | 83 | 20 | 99.2 | 0 | 249 | 1 | 36 | 118 | MBN2397300.1 thiolase family protein [Deltaproteobacteria bacterium] | diamond | 747 | 135 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 27813752 | 27813752 | PRJNA883229_P_NODE_9464_length_252_cov_0.871508_g9418_i0 | PRJNA883229 | 9464 | 252 | 0.871508 | 2.19620016 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 94.7 | 5.51e-22 | NR | HEX7837634.1 | 2212474 | g9418 | i0 | 57.5 | 1.73809523809524 | 73 | 30 | 86.9 | 1 | 252 | 34 | 127 | 198 | HEX7837634.1 hypothetical protein [Kofleriaceae bacterium] | diamond | 438 | 94.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 28137370 | 28137370 | PRJNA883229_P_NODE_15705_length_243_cov_0.917647_g15659_i0 | PRJNA883229 | 15705 | 243 | 0.917647 | 2.22988221 | Bacteria | 2 | Bacteria | Bacteria | 43.1 | 0.026 | NR | MCC6849087.1 | 2026735 | g15659 | i0 | 42.2 | 2.23456790123457 | 64 | 28 | 70.4 | 3 | 35 | 205 | 284 | 345 | MCC6849087.1 FAD-dependent monooxygenase [Deltaproteobacteria bacterium] | diamond | 543 | 43.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 28705624 | 28705624 | PRJNA883229_P_NODE_11827_length_249_cov_0.886364_g11781_i0 | PRJNA883229 | 11827 | 249 | 0.886364 | 2.20704636 | Anaeromyxobacter | 161492 | Bacteria | Bacteria | 114 | 2.6200000000000003e-27 | NR | HET9555004.1 | 2510643 | g11781 | i0 | 74.1 | 1.96385542168675 | 81 | 21 | 97.6 | 0 | 6 | 248 | 304 | 384 | HET9555004.1 transcription-repair coupling factor [Anaeromyxobacteraceae bacterium] | diamond | 489 | 115 | 0.991304347826087 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Anaeromyxobacteraceae | Anaeromyxobacteraceae bacterium | |||
| 29770927 | 29770927 | PRJNA883229_P_NODE_15111_length_244_cov_0.912281_g15065_i0 | PRJNA883229 | 15111 | 244 | 0.912281 | 2.22596564 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 134 | 9.34e-35 | NR | MDA8125027.1 | 2026735 | g15065 | i0 | 84 | 0.995901639344262 | 81 | 13 | 99.6 | 0 | 2 | 244 | 330 | 410 | MDA8125027.1 NAD(P)H-hydrate dehydratase [Deltaproteobacteria bacterium] | diamond | 243 | 134 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 30340278 | 30340278 | PRJNA883229_P_NODE_6232_length_285_cov_1.424528_g6186_i0 | PRJNA883229 | 6232 | 285 | 1.424528 | 4.0599048 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 43.9 | 0.0245 | NR | MCC7541433.1 | 2026735 | g6186 | i0 | 34.7 | 1 | 95 | 51 | 89.5 | 4 | 4 | 258 | 151 | 244 | MCC7541433.1 L,D-transpeptidase family protein [Deltaproteobacteria bacterium] | diamond | 285 | 43.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 30940179 | 30940179 | PRJNA883229_P_NODE_11574_length_249_cov_0.886364_g11528_i0 | PRJNA883229 | 11574 | 249 | 0.886364 | 2.20704636 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 42.7 | 0.0406 | NR | MCL5884410.1 | 2026735 | g11528 | i0 | 34.5 | 1.04819277108434 | 87 | 49 | 96.4 | 2 | 4 | 243 | 295 | 380 | MCL5884410.1 CDP-glycerol glycerophosphotransferase family protein [Deltaproteobacteria bacterium] | diamond | 261 | 42.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31192423 | 31192423 | PRJNA883229_P_NODE_15175_length_244_cov_0.912281_g15129_i0 | PRJNA883229 | 15175 | 244 | 0.912281 | 2.22596564 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 85.5 | 3.04e-19 | NR | MEI9475910.1 | 2026735 | g15129 | i0 | 86.3 | 0.627049180327869 | 51 | 7 | 62.7 | 0 | 2 | 154 | 75 | 125 | MEI9475910.1 rRNA maturation RNase YbeY [Deltaproteobacteria bacterium] | diamond | 153 | 85.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32268518 | 32268518 | PRJNA883229_P_NODE_13658_length_246_cov_0.901734_g13612_i0 | PRJNA883229 | 13658 | 246 | 0.901734 | 2.21826564 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 143 | 9.749999999999999e-40 | NR | MBM3303422.1 | 2026735 | g13612 | i0 | 87.7 | 0.98780487804878 | 81 | 8 | 98.8 | 1 | 244 | 2 | 134 | 212 | MBM3303422.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 243 | 143 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32490010 | 32490010 | PRJNA883229_P_NODE_12399_length_248_cov_0.891429_g12353_i0 | PRJNA883229 | 12399 | 248 | 0.891429 | 2.21074392 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 152 | 3.639999999999999e-43 | NR | MFN0248613.1 | 2212474 | g12353 | i0 | 90.1 | 0.858870967741935 | 71 | 7 | 85.9 | 0 | 2 | 214 | 167 | 237 | MFN0248613.1 hypothetical protein [Kofleriaceae bacterium] | diamond | 213 | 152 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 32521792 | 32521792 | PRJNA883229_P_NODE_9339_length_252_cov_0.871508_g9293_i0 | PRJNA883229 | 9339 | 252 | 0.871508 | 2.19620016 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 63.5 | 1.93e-9 | NR | MCL2724779.1 | 2268199 | g9293 | i0 | 45.3 | 0.892857142857143 | 75 | 34 | 89.3 | 1 | 26 | 250 | 452 | 519 | MCL2724779.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 225 | 63.5 | 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);;