contig_metadata
25 rows where bioproject = "PRJNA352610", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26758169 | 26758169 | PRJNA352610_P_NODE_7341_length_415_cov_1.368421_g7280_i0 | PRJNA352610 | 7341 | 415 | 1.368421 | 5.67894715 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 42 | 0.048 | NR | MBM4321556.1 | 2026735 | g7280 | i0 | 42.3 | 0.375903614457831 | 52 | 29 | 37.6 | 1 | 198 | 43 | 22 | 72 | MBM4321556.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 156 | 42 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 26853481 | 26853481 | PRJNA352610_P_NODE_10121_length_367_cov_1.170068_g10060_i0 | PRJNA352610 | 10121 | 367 | 1.170068 | 4.29414956 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 60.5 | 2.2e-8 | NR | MCA9671053.1 | 2026763 | g10060 | i0 | 35.9 | 0.841961852861035 | 103 | 55 | 76 | 2 | 28 | 306 | 55 | 156 | MCA9671053.1 hypothetical protein [Myxococcales bacterium] | diamond | 309 | 60.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 26853517 | 26853517 | PRJNA352610_P_NODE_32101_length_241_cov_0.863095_g32040_i0 | PRJNA352610 | 32101 | 241 | 0.863095 | 2.08005895 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 56.2 | 6.15e-7 | NR | HLK41500.1 | 2268199 | g32040 | i0 | 43.8 | 0.995850622406639 | 80 | 37 | 95.9 | 3 | 233 | 3 | 67 | 141 | HLK41500.1 carboxylesterase/lipase family protein [Polyangiaceae bacterium] | diamond | 240 | 56.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 27548684 | 27548684 | PRJNA352610_P_NODE_2344_length_636_cov_1.184725_g2285_i0 | PRJNA352610 | 2344 | 636 | 1.184725 | 7.534851 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 60.5 | 2.08e-7 | NR | HMJ57057.1 | 2268199 | g2285 | i0 | 36.2 | 0.325471698113208 | 69 | 43 | 32.1 | 1 | 515 | 312 | 108 | 176 | HMJ57057.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 207 | 60.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 27976314 | 27976314 | PRJNA352610_P_NODE_4065_length_520_cov_1.205817_g4004_i0 | PRJNA352610 | 4065 | 520 | 1.205817 | 6.2702484 | Bacteria | 2 | Bacteria | Bacteria | 106 | 2.8199999999999994e-24 | NR | HEX3758815.1 | 2212474 | g4004 | i0 | 36.5 | 5.52692307692308 | 181 | 98 | 99.2 | 5 | 5 | 520 | 58 | 230 | HEX3758815.1 hypothetical protein [Kofleriaceae bacterium] | diamond | 2874 | 107 | 0.990654205607477 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 28022496 | 28022496 | PRJNA352610_P_NODE_28225_length_246_cov_2.219653_g28164_i0 | PRJNA352610 | 28225 | 246 | 2.219653 | 5.46034638 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 51.2 | 1.84e-5 | NR | MCA9671053.1 | 2026763 | g28164 | i0 | 36.6 | 0.865853658536585 | 71 | 39 | 79.3 | 1 | 49 | 243 | 70 | 140 | MCA9671053.1 hypothetical protein [Myxococcales bacterium] | diamond | 213 | 51.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 28102529 | 28102529 | PRJNA352610_P_NODE_9325_length_379_cov_0.993464_g9264_i0 | PRJNA352610 | 9325 | 379 | 0.993464 | 3.76522856 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 59.7 | 1.94e-7 | NR | MES1174858.1 | 2026763 | g9264 | i0 | 55.6 | 5.69129287598945 | 54 | 24 | 42.7 | 0 | 3 | 164 | 360 | 413 | MES1174858.1 cation:proton antiporter [Myxococcales bacterium] | diamond | 2157 | 60.1 | 0.993344425956739 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 28401239 | 28401239 | PRJNA352610_P_NODE_5146_length_474_cov_1.511222_g5085_i0 | PRJNA352610 | 5146 | 474 | 1.511222 | 7.16319228 | Cystobacter sp. | 1965334 | Bacteria | Bacteria | 76.3 | 8.09e-13 | NR | MET0402051.1 | 1965334 | g5085 | i0 | 34.4 | 1.03164556962025 | 163 | 88 | 94.9 | 8 | 18 | 467 | 136 | 292 | MET0402051.1 phosphatidylinositol-specific phospholipase C [Cystobacter sp.] | diamond | 489 | 76.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Cystobacter | Cystobacter sp. | ||
| 28496079 | 28496079 | PRJNA352610_P_NODE_18967_length_287_cov_1.313084_g18906_i0 | PRJNA352610 | 18967 | 287 | 1.313084 | 3.76855108 | Corallococcus carmarthensis | 2316728 | Bacteria | Bacteria | 46.2 | 0.00383 | NR | WP_158625800.1 | 2316728 | g18906 | i0 | 37.2 | 2.61324041811847 | 86 | 51 | 89.9 | 3 | 258 | 1 | 235 | 317 | WP_158625800.1 TIR domain-containing protein [Corallococcus carmarthensis] | diamond | 750 | 46.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Corallococcus | Corallococcus carmarthensis | ||
| 29001504 | 29001504 | PRJNA352610_P_NODE_17328_length_298_cov_1.195556_g17267_i0 | PRJNA352610 | 17328 | 298 | 1.195556 | 3.56275688 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 50.8 | 1.01e-4 | NR | HEY2407106.1 | 2268199 | g17267 | i0 | 33.7 | 1.69127516778523 | 83 | 49 | 78.5 | 2 | 295 | 62 | 238 | 319 | HEY2407106.1 glycosyl hydrolase family 28 protein [Polyangiaceae bacterium] | diamond | 504 | 50.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 29790304 | 29790304 | PRJNA352610_P_NODE_7111_length_420_cov_1.893372_g7050_i0 | PRJNA352610 | 7111 | 420 | 1.893372 | 7.9521624 | Anaeromyxobacteraceae bacterium | 2510643 | Bacteria | Bacteria | 47.8 | 0.00396 | NR | MFL5274676.1 | 2510643 | g7050 | i0 | 39.4 | 0.707142857142857 | 99 | 52 | 70 | 4 | 417 | 124 | 79 | 170 | MFL5274676.1 hypothetical protein [Anaeromyxobacteraceae bacterium] | diamond | 297 | 47.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Anaeromyxobacteraceae | Anaeromyxobacteraceae bacterium | |||
| 30232740 | 30232740 | PRJNA352610_P_NODE_22852_length_263_cov_1.605263_g22791_i0 | PRJNA352610 | 22852 | 263 | 1.605263 | 4.22184169 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 50.4 | 2.56e-5 | NR | MFP6608719.1 | 2026735 | g22791 | i0 | 39.6 | 1.36882129277567 | 53 | 32 | 60.5 | 0 | 225 | 67 | 81 | 133 | MFP6608719.1 DUF1330 domain-containing protein [Deltaproteobacteria bacterium] | diamond | 360 | 50.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 30391230 | 30391230 | PRJNA352610_P_NODE_5173_length_473_cov_1.737500_g5112_i0 | PRJNA352610 | 5173 | 473 | 1.7375 | 8.218375 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 48.1 | 0.00508 | NR | MCO4760791.1 | 2026763 | g5112 | i0 | 60 | 0.221987315010571 | 35 | 14 | 22.2 | 0 | 237 | 133 | 302 | 336 | MCO4760791.1 lamin tail domain-containing protein [Myxococcales bacterium] | diamond | 105 | 48.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 30787076 | 30787076 | PRJNA352610_P_NODE_17454_length_297_cov_1.263393_g17393_i0 | PRJNA352610 | 17454 | 297 | 1.263393 | 3.75227721 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 119 | 3.73e-29 | NR | MCA9626175.1 | 2026763 | g17393 | i0 | 64.6 | 5.66666666666667 | 96 | 32 | 97 | 1 | 5 | 292 | 236 | 329 | MCA9626175.1 tryptophanase [Myxococcales bacterium] | diamond | 1683 | 119 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 31275424 | 31275424 | PRJNA352610_P_NODE_18295_length_291_cov_1.743119_g18234_i0 | PRJNA352610 | 18295 | 291 | 1.743119 | 5.07247629 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 71.6 | 4.72e-12 | NR | MCA9676067.1 | 2026763 | g18234 | i0 | 46.8 | 1.68041237113402 | 79 | 37 | 81.4 | 1 | 267 | 31 | 160 | 233 | MCA9676067.1 histidinol-phosphate aminotransferase family protein [Myxococcales bacterium] | diamond | 489 | 71.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 31307072 | 31307072 | PRJNA352610_P_NODE_8295_length_395_cov_1.195652_g8234_i0 | PRJNA352610 | 8295 | 395 | 1.195652 | 4.7228254 | Polyangia bacterium | 3058050 | Bacteria | Bacteria | 183 | 3.359999999999999e-54 | NR | HEX2568019.1 | 3058050 | g8234 | i0 | 64.3 | 4.93670886075949 | 129 | 46 | 98 | 0 | 394 | 8 | 106 | 234 | HEX2568019.1 methyltransferase domain-containing protein [Polyangia bacterium] | diamond | 1950 | 183 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangia bacterium | ||||||
| 31497059 | 31497059 | PRJNA352610_P_NODE_29476_length_244_cov_1.801170_g29415_i0 | PRJNA352610 | 29476 | 244 | 1.80117 | 4.3948548 | Minicystis rosea | 888845 | Bacteria | Bacteria | 45.8 | 0.00318 | NR | APR85582.1 | 888845 | g29415 | i0 | 43.7 | 0.872950819672131 | 71 | 35 | 86.1 | 2 | 22 | 231 | 8 | 74 | APR85582.1 kinesin light chain-like protein [Minicystis rosea] | diamond | 213 | 45.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Minicystis | Minicystis rosea | |||
| 31528648 | 31528648 | PRJNA352610_P_NODE_8996_length_384_cov_0.926045_g8935_i0 | PRJNA352610 | 8996 | 384 | 0.926045 | 3.5560128 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 44.7 | 0.0326 | NR | MCA9647516.1 | 2026763 | g8935 | i0 | 37.5 | 0.625 | 80 | 44 | 60.9 | 4 | 37 | 270 | 266 | 341 | MCA9647516.1 hypothetical protein [Myxococcales bacterium] | diamond | 240 | 44.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 31908092 | 31908092 | PRJNA352610_P_NODE_7577_length_410_cov_1.448071_g7516_i0 | PRJNA352610 | 7577 | 410 | 1.448071 | 5.9370911 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 47 | 0.00742 | NR | MCO4760791.1 | 2026763 | g7516 | i0 | 51.2 | 0.724390243902439 | 43 | 21 | 31.5 | 0 | 165 | 37 | 302 | 344 | MCO4760791.1 lamin tail domain-containing protein [Myxococcales bacterium] | diamond | 297 | 47 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 32003044 | 32003044 | PRJNA352610_P_NODE_26238_length_249_cov_1.448864_g26177_i0 | PRJNA352610 | 26238 | 249 | 1.448864 | 3.60767136 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 45.1 | 0.00596 | NR | MBS2024131.1 | 2026735 | g26177 | i0 | 50 | 2.91566265060241 | 38 | 19 | 45.8 | 0 | 130 | 17 | 320 | 357 | MBS2024131.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 726 | 45.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32288121 | 32288121 | PRJNA352610_P_NODE_22299_length_266_cov_1.958549_g22238_i0 | PRJNA352610 | 22299 | 266 | 1.958549 | 5.20974034 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 43.9 | 0.0158 | NR | MEE2835165.1 | 2818507 | g22238 | i0 | 35.3 | 0.766917293233083 | 68 | 41 | 73.3 | 1 | 47 | 241 | 18 | 85 | MEE2835165.1 hypothetical protein [Myxococcota bacterium] | diamond | 204 | 43.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 32635234 | 32635234 | PRJNA352610_P_NODE_19940_length_281_cov_1.413462_g19879_i0 | PRJNA352610 | 19940 | 281 | 1.413462 | 3.97182822 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 154 | 7.719999999999998e-42 | NR | MBI2389879.1 | 2026735 | g19879 | i0 | 74.7 | 1.9644128113879 | 91 | 23 | 97.2 | 0 | 6 | 278 | 408 | 498 | MBI2389879.1 RICIN domain-containing protein [Deltaproteobacteria bacterium] | diamond | 552 | 154 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32730008 | 32730008 | PRJNA352610_P_NODE_11500_length_349_cov_2.010870_g11439_i0 | PRJNA352610 | 11500 | 349 | 2.01087 | 7.0179363 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 43.1 | 0.0496 | NR | MEE2959811.1 | 2818507 | g11439 | i0 | 29.4 | 0.584527220630373 | 68 | 48 | 58.5 | 0 | 4 | 207 | 45 | 112 | MEE2959811.1 hypothetical protein [Myxococcota bacterium] | diamond | 204 | 43.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 32747059 | 32747059 | PRJNA352610_P_NODE_9260_length_380_cov_0.905537_g9199_i0 | PRJNA352610 | 9260 | 380 | 0.905537 | 3.4410406 | Myxococcota | 2818505 | Bacteria | Bacteria | 50.1 | 1.95e-4 | NR | MCA9671053.1 | 2026763 | g9199 | i0 | 34.9 | 2.75526315789474 | 86 | 46 | 60 | 2 | 152 | 379 | 65 | 150 | MCA9671053.1 hypothetical protein [Myxococcales bacterium] | diamond | 1047 | 50.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 32855801 | 32855801 | PRJNA352610_P_NODE_23100_length_262_cov_1.148148_g23039_i0 | PRJNA352610 | 23100 | 262 | 1.148148 | 3.00814776 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 65.1 | 5.16e-10 | NR | RLB46302.1 | 2026735 | g23039 | i0 | 53 | 4.05343511450382 | 66 | 31 | 75.6 | 0 | 3 | 200 | 271 | 336 | RLB46302.1 MAG: hypothetical protein DRJ42_27970 [Deltaproteobacteria bacterium] | diamond | 1062 | 65.1 | 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);;