contig_metadata
21 rows where bioproject = "PRJNA1150539", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4128563 | 4128563 | PRJNA1150539_S_NODE_75464_length_272_cov_1.482412_g74868_i0 | PRJNA1150539 | 75464 | 272 | 1.482412 | 4.03216064 | Anaeromyxobacter paludicola | 2918171 | Bacteria | Bacteria | 274 | 4.889999999999998e-69 | NTclustered | gi|2199271117|dbj|AP025592.1| | 2918171 | g74868 | i0 | 87.983 | 200.522058823529 | 233 | 26 | 86 | 2 | 40 | 272 | 1384407 | 1384177 | Anaeromyxobacter paludicola DNA, complete genome | blastn | 54542 | 274 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Anaeromyxobacteraceae | Anaeromyxobacter | Anaeromyxobacter paludicola | ||
| 6679749 | 6679749 | PRJNA1150539_S_NODE_99546_length_244_cov_1.263158_g98950_i0 | PRJNA1150539 | 99546 | 244 | 1.263158 | 3.08210552 | Pendulispora albinea | 2741071 | Bacteria | Bacteria | 224 | 4.4099999999999997e-54 | NTclustered | gi|2698035964|gb|CP089984.1| | 2741071 | g98950 | i0 | 85.202 | 99.4426229508197 | 223 | 27 | 90 | 5 | 26 | 244 | 3587953 | 3588173 | Pendulispora albinea strain MSr11954 chromosome, complete genome | blastn | 24264 | 224 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora albinea | ||
| 11780237 | 11780237 | PRJNA1150539_S_NODE_74350_length_273_cov_3.160000_g73754_i0 | PRJNA1150539 | 74350 | 273 | 3.16 | 8.6268 | Pendulispora rubella | 2741070 | Bacteria | Bacteria | 298 | 2.92e-76 | NTclustered | gi|2698045512|gb|CP089929.1| | 2741070 | g73754 | i0 | 88.571 | 319.802197802198 | 245 | 28 | 90 | 0 | 29 | 273 | 7290015 | 7289771 | Pendulispora rubella strain MSr11368 chromosome, complete genome | blastn | 87306 | 298 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora rubella | ||
| 23989162 | 23989162 | PRJNA1150539_S_NODE_92059_length_251_cov_1.730337_g91463_i0 | PRJNA1150539 | 92059 | 251 | 1.730337 | 4.34314587 | Pendulispora | 3375062 | Bacteria | Bacteria | 374 | 4.27e-99 | NTclustered | gi|2698045512|gb|CP089929.1| | 2741070 | g91463 | i0 | 93.625 | 174.011952191235 | 251 | 15 | 100 | 1 | 1 | 251 | 7289236 | 7289485 | Pendulispora rubella strain MSr11368 chromosome, complete genome | blastn | 43677 | 374 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora rubella | ||
| 27324814 | 27324814 | PRJNA1150539_S_NODE_55063_length_302_cov_3.759825_g54467_i0 | PRJNA1150539 | 55063 | 302 | 3.759825 | 11.3546715 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 43.5 | 0.0335 | NR | HOU89494.1 | 2268199 | g54467 | i0 | 42.1 | 0.377483443708609 | 38 | 22 | 37.7 | 0 | 176 | 289 | 150 | 187 | HOU89494.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 114 | 43.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 27388149 | 27388149 | PRJNA1150539_S_NODE_91243_length_252_cov_1.720670_g90647_i0 | PRJNA1150539 | 91243 | 252 | 1.72067 | 4.3360884 | Anaeromyxobacteraceae bacterium | 2510643 | Bacteria | Bacteria | 42.7 | 0.0391 | NR | HYS80827.1 | 2510643 | g90647 | i0 | 42.1 | 0.452380952380952 | 38 | 22 | 45.2 | 0 | 134 | 247 | 294 | 331 | HYS80827.1 signal peptidase I [Anaeromyxobacteraceae bacterium] | diamond | 114 | 42.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Anaeromyxobacteraceae | Anaeromyxobacteraceae bacterium | |||
| 28019609 | 28019609 | PRJNA1150539_S_NODE_55065_length_302_cov_3.737991_g54469_i0 | PRJNA1150539 | 55065 | 302 | 3.737991 | 11.28873282 | Myxococcus | 32 | Bacteria | Bacteria | 43.9 | 0.018 | NR | WP_011556118.1 | 32 | g54469 | i0 | 50 | 0.834437086092715 | 42 | 21 | 41.7 | 0 | 37 | 162 | 128 | 169 | WP_011556118.1 MULTISPECIES: hypothetical protein [Myxococcus] | diamond | 252 | 43.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcus | |||
| 28366603 | 28366603 | PRJNA1150539_S_NODE_96826_length_246_cov_2.953757_g96230_i0 | PRJNA1150539 | 96826 | 246 | 2.953757 | 7.26624222 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 42.4 | 0.049 | NR | MBM4280904.1 | 2026735 | g96230 | i0 | 36.4 | 1.07317073170732 | 88 | 38 | 93.9 | 6 | 239 | 9 | 123 | 203 | MBM4280904.1 carotenoid biosynthesis protein [Deltaproteobacteria bacterium] | diamond | 264 | 42.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 28556369 | 28556369 | PRJNA1150539_S_NODE_95427_length_248_cov_0.920000_g94831_i0 | PRJNA1150539 | 95427 | 248 | 0.92 | 2.2816 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 44.3 | 0.0108 | NR | MBW2586917.1 | 2026735 | g94831 | i0 | 40 | 3.3508064516129 | 65 | 30 | 73.8 | 3 | 64 | 246 | 102 | 161 | MBW2586917.1 zinc-dependent alcohol dehydrogenase family protein [Deltaproteobacteria bacterium] | diamond | 831 | 44.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 28871864 | 28871864 | PRJNA1150539_S_NODE_65388_length_286_cov_2.492958_g64792_i0 | PRJNA1150539 | 65388 | 286 | 2.492958 | 7.12985988 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 42 | 0.0451 | NR | MEM9492617.1 | 2818507 | g64792 | i0 | 48 | 0.524475524475524 | 50 | 22 | 52.4 | 1 | 64 | 213 | 75 | 120 | MEM9492617.1 hypothetical protein [Myxococcota bacterium] | diamond | 150 | 42 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 28935171 | 28935171 | PRJNA1150539_S_NODE_52508_length_307_cov_1.235043_g51912_i0 | PRJNA1150539 | 52508 | 307 | 1.235043 | 3.79158201 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 130 | 1.24e-32 | NR | HEU4407791.1 | 2268199 | g51912 | i0 | 64.4 | 0.986970684039088 | 101 | 36 | 98.7 | 0 | 5 | 307 | 220 | 320 | HEU4407791.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 303 | 130 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 29439940 | 29439940 | PRJNA1150539_S_NODE_25590_length_364_cov_9.422680_g24994_i0 | PRJNA1150539 | 25590 | 364 | 9.42268 | 34.2985552 | Anaeromyxobacter sp. K | 447217 | Bacteria | Bacteria | 43.9 | 0.0477 | NR | WP_012526827.1 | 447217 | g24994 | i0 | 36.2 | 0.478021978021978 | 58 | 34 | 47.8 | 1 | 289 | 116 | 146 | 200 | WP_012526827.1 CheR family methyltransferase [Anaeromyxobacter sp. K] | diamond | 174 | 43.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Anaeromyxobacteraceae | Anaeromyxobacter | Anaeromyxobacter sp. K | ||
| 29787424 | 29787424 | PRJNA1150539_S_NODE_70551_length_279_cov_1.121359_g69955_i0 | PRJNA1150539 | 70551 | 279 | 1.121359 | 3.12859161 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 43.1 | 0.0313 | NR | HUB07759.1 | 2026763 | g69955 | i0 | 28.2 | 0.763440860215054 | 71 | 51 | 76.3 | 0 | 260 | 48 | 39 | 109 | HUB07759.1 glycosyltransferase [Myxococcales bacterium] | diamond | 213 | 43.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 29945617 | 29945617 | PRJNA1150539_S_NODE_110371_length_222_cov_4.268456_g109775_i0 | PRJNA1150539 | 110371 | 222 | 4.268456 | 9.47597232 | Myxococcales bacterium 68-2 | 2026763 | Bacteria | Bacteria | 42 | 0.049 | NR | OJY17026.1 | 1895795 | g109775 | i0 | 44.2 | 0.581081081081081 | 43 | 22 | 58.1 | 1 | 42 | 170 | 215 | 255 | OJY17026.1 MAG: hypothetical protein BGO98_12760 [Myxococcales bacterium 68-20] | diamond | 129 | 42 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium 68-20 | ||||
| 30103326 | 30103326 | PRJNA1150539_S_NODE_50732_length_310_cov_1.400844_g50136_i0 | PRJNA1150539 | 50732 | 310 | 1.400844 | 4.3426164 | Bradymonadia bacterium | 3121696 | Bacteria | Bacteria | 43.5 | 0.0357 | NR | MFN3202473.1 | 3121696 | g50136 | i0 | 44.6 | 0.541935483870968 | 56 | 29 | 54.2 | 1 | 178 | 11 | 52 | 105 | MFN3202473.1 hypothetical protein [Bradymonadia bacterium] | diamond | 168 | 43.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Bradymonadia | Bradymonadia bacterium | |||||
| 30103333 | 30103333 | PRJNA1150539_S_NODE_85332_length_259_cov_2.026882_g84736_i0 | PRJNA1150539 | 85332 | 259 | 2.026882 | 5.24962438 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 43.1 | 0.0349 | NR | HVY30603.1 | 2268199 | g84736 | i0 | 31.2 | 0.891891891891892 | 77 | 52 | 89.2 | 1 | 238 | 8 | 1234 | 1309 | HVY30603.1 toxin TcdB middle/N-terminal domain-containing protein [Polyangiaceae bacterium] | diamond | 231 | 43.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 31177464 | 31177464 | PRJNA1150539_S_NODE_99975_length_243_cov_3.705882_g99379_i0 | PRJNA1150539 | 99975 | 243 | 3.705882 | 9.00529326 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 46.6 | 0.00155 | NR | HET6343425.1 | 2818507 | g99379 | i0 | 47.9 | 0.592592592592593 | 48 | 25 | 59.3 | 0 | 43 | 186 | 131 | 178 | HET6343425.1 hypothetical protein [Myxococcota bacterium] | diamond | 144 | 46.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 31399267 | 31399267 | PRJNA1150539_S_NODE_83996_length_261_cov_1.228723_g83400_i0 | PRJNA1150539 | 83996 | 261 | 1.228723 | 3.20696703 | Labilithrix luteola | 1391654 | Bacteria | Bacteria | 139 | 7.709999999999999e-37 | NR | WP_205634004.1 | 1391654 | g83400 | i0 | 81 | 0.96551724137931 | 84 | 16 | 96.6 | 0 | 3 | 254 | 355 | 438 | WP_205634004.1 carbohydrate porin [Labilithrix luteola] | diamond | 252 | 139 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Labilitrichaceae | Labilithrix | Labilithrix luteola | |||
| 31430669 | 31430669 | PRJNA1150539_S_NODE_83796_length_261_cov_1.638298_g83200_i0 | PRJNA1150539 | 83796 | 261 | 1.638298 | 4.27595778 | Cystobacterineae bacterium | 1934914 | Bacteria | Bacteria | 43.5 | 0.0159 | NR | MCL2178075.1 | 1934914 | g83200 | i0 | 35.4 | 0.551724137931034 | 48 | 31 | 55.2 | 0 | 27 | 170 | 123 | 170 | MCL2178075.1 hypothetical protein [Cystobacterineae bacterium] | diamond | 144 | 43.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Cystobacterineae bacterium | ||||
| 31968387 | 31968387 | PRJNA1150539_S_NODE_54418_length_303_cov_4.382609_g53822_i0 | PRJNA1150539 | 54418 | 303 | 4.382609 | 13.27930527 | Myxococcaceae bacterium | 2484252 | Bacteria | Bacteria | 43.9 | 0.0288 | NR | MFT3840204.1 | 2484252 | g53822 | i0 | 45.9 | 0.366336633663366 | 37 | 16 | 36.6 | 1 | 262 | 152 | 120 | 152 | MFT3840204.1 hypothetical protein [Myxococcaceae bacterium] | diamond | 111 | 43.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcaceae bacterium | |||
| 32569918 | 32569918 | PRJNA1150539_S_NODE_81259_length_264_cov_2.607330_g80663_i0 | PRJNA1150539 | 81259 | 264 | 2.60733 | 6.8833512 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 42 | 0.0318 | NR | MBK7760907.1 | 2026735 | g80663 | i0 | 40 | 0.625 | 55 | 27 | 55.7 | 1 | 182 | 36 | 36 | 90 | MBK7760907.1 cytochrome c [Deltaproteobacteria bacterium] | diamond | 165 | 42 | 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);;