contig_metadata
23 rows where bioproject = "PRJNA1199330", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 325122 | 325122 | PRJNA1199330_P_NODE_124081_length_212_cov_4.345324_g123382_i0 | PRJNA1199330 | 124081 | 212 | 4.345324 | 9.21208688 | Anaeromyxobacter oryzae | 2918170 | Bacteria | Bacteria | 165 | 2.29e-36 | NTclustered | gi|2199265233|dbj|AP025591.1| | 2918170 | g123382 | i0 | 81.068 | 92.7641509433962 | 206 | 39 | 97 | 0 | 7 | 212 | 443306 | 443511 | Anaeromyxobacter oryzae DNA, complete genome | blastn | 19666 | 165 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Anaeromyxobacteraceae | Anaeromyxobacter | Anaeromyxobacter oryzae | ||
| 22002571 | 22002571 | PRJNA1199330_P_NODE_59398_length_291_cov_1.788991_g58699_i0 | PRJNA1199330 | 59398 | 291 | 1.788991 | 5.20596381 | Vulgatibacter incomptus | 1391653 | Bacteria | Bacteria | 457 | 4.89e-124 | NTclustered | gi|913607065|gb|CP012332.1| | 1391653 | g58699 | i0 | 94.898 | 277.082474226804 | 294 | 12 | 100 | 3 | 1 | 291 | 179674 | 179381 | Vulgatibacter incomptus strain DSM 27710, complete genome | blastn | 80631 | 457 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Vulgatibacteraceae | Vulgatibacter | Vulgatibacter incomptus | ||
| 26787862 | 26787862 | PRJNA1199330_P_NODE_56781_length_293_cov_2.754545_g56082_i0 | PRJNA1199330 | 56781 | 293 | 2.754545 | 8.07081685 | Sorangium cellulosum | 56 | Bacteria | Bacteria | 43.1 | 0.0499 | NR | WP_129348003.1 | 56 | g56082 | i0 | 55.6 | 0.368600682593857 | 36 | 16 | 36.9 | 0 | 76 | 183 | 398 | 433 | WP_129348003.1 S8 family serine peptidase [Sorangium cellulosum] | diamond | 108 | 43.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Sorangium | Sorangium cellulosum | |||
| 26914257 | 26914257 | PRJNA1199330_P_NODE_102982_length_251_cov_1.752809_g102283_i0 | PRJNA1199330 | 102982 | 251 | 1.752809 | 4.39955059 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 52.4 | 1.63e-5 | NR | MCA1825563.1 | 2026763 | g102283 | i0 | 47.1 | 0.609561752988048 | 51 | 27 | 61 | 0 | 153 | 1 | 3 | 53 | MCA1825563.1 AMP-binding protein [Myxococcales bacterium] | diamond | 153 | 52.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 27135354 | 27135354 | PRJNA1199330_P_NODE_95342_length_258_cov_1.481081_g94643_i0 | PRJNA1199330 | 95342 | 258 | 1.481081 | 3.82118898 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 43.9 | 0.0171 | NR | MEE8410011.1 | 2818507 | g94643 | i0 | 41.8 | 0.63953488372093 | 55 | 32 | 64 | 0 | 188 | 24 | 381 | 435 | MEE8410011.1 hypothetical protein [Myxococcota bacterium] | diamond | 165 | 43.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 27609734 | 27609734 | PRJNA1199330_P_NODE_91204_length_262_cov_1.650794_g90505_i0 | PRJNA1199330 | 91204 | 262 | 1.650794 | 4.32508028 | Myxococcales bacterium FL481 | 1979545 | Bacteria | Bacteria | 87.8 | 1e-19 | NR | TPV94734.1 | 1979545 | g90505 | i0 | 50.6 | 2.94274809160305 | 87 | 43 | 99.6 | 0 | 2 | 262 | 28 | 114 | TPV94734.1 MAG: hypothetical protein B7733_13670 [Myxococcales bacterium FL481] | diamond | 771 | 87.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium FL481 | ||||
| 27672974 | 27672974 | PRJNA1199330_P_NODE_98844_length_254_cov_2.132597_g98145_i0 | PRJNA1199330 | 98844 | 254 | 2.132597 | 5.41679638 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 42.7 | 0.0435 | NR | MDB4967310.1 | 2026763 | g98145 | i0 | 44.7 | 0.55511811023622 | 47 | 25 | 55.5 | 1 | 177 | 37 | 628 | 673 | MDB4967310.1 Tetratricopeptide 2 repeat protein [Myxococcales bacterium] | diamond | 141 | 42.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 28020278 | 28020278 | PRJNA1199330_P_NODE_65985_length_285_cov_2.193396_g65286_i0 | PRJNA1199330 | 65985 | 285 | 2.193396 | 6.2511786 | Enhygromyxa salina | 215803 | Bacteria | Bacteria | 111 | 1.86e-27 | NR | WP_106391069.1 | 215803 | g65286 | i0 | 63 | 1.75789473684211 | 81 | 30 | 85.3 | 0 | 244 | 2 | 68 | 148 | WP_106391069.1 poly(ADP-ribose) glycohydrolase domain-containing protein [Enhygromyxa salina] | diamond | 501 | 111 | 1 | Bacteria | Pseudomonadati | Myxococcota | Nannocystales | Nannocystaceae | Enhygromyxa | Enhygromyxa salina | |||
| 28304238 | 28304238 | PRJNA1199330_P_NODE_117986_length_238_cov_2.830303_g117287_i0 | PRJNA1199330 | 117986 | 238 | 2.830303 | 6.73612114 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 53.5 | 5.05e-6 | NR | HTM18996.1 | 2212474 | g117287 | i0 | 44.4 | 2.09243697478992 | 81 | 33 | 92 | 3 | 19 | 237 | 188 | 264 | HTM18996.1 serine protease [Kofleriaceae bacterium] | diamond | 498 | 53.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 28777753 | 28777753 | PRJNA1199330_P_NODE_41287_length_321_cov_1.467742_g40588_i0 | PRJNA1199330 | 41287 | 321 | 1.467742 | 4.71145182 | Kofleriaceae bacterium | 2212474 | Bacteria | Bacteria | 68.6 | 5.6e-11 | NR | HEY6037536.1 | 2212474 | g40588 | i0 | 40.7 | 2.51401869158878 | 108 | 56 | 94.4 | 3 | 1 | 303 | 150 | 256 | HEY6037536.1 hypothetical protein [Kofleriaceae bacterium] | diamond | 807 | 68.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 28999273 | 28999273 | PRJNA1199330_P_NODE_73848_length_278_cov_2.092683_g73149_i0 | PRJNA1199330 | 73848 | 278 | 2.092683 | 5.81765874 | Polyangium fumosum | 889272 | Bacteria | Bacteria | 74.7 | 3.32e-13 | NR | WP_136926967.1 | 889272 | g73149 | i0 | 48.8 | 0.928057553956835 | 86 | 43 | 92.8 | 1 | 6 | 263 | 1271 | 1355 | WP_136926967.1 type I polyketide synthase [Polyangium fumosum] | diamond | 258 | 74.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangium | Polyangium fumosum | |||
| 29440626 | 29440626 | PRJNA1199330_P_NODE_106790_length_248_cov_3.308571_g106091_i0 | PRJNA1199330 | 106790 | 248 | 3.308571 | 8.20525608 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 52 | 1.93e-5 | NR | MEO1270141.1 | 2818507 | g106091 | i0 | 52.1 | 1.39112903225806 | 48 | 21 | 58.1 | 1 | 57 | 200 | 249 | 294 | MEO1270141.1 ABC transporter substrate-binding protein [Myxococcota bacterium] | diamond | 345 | 52 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 29788084 | 29788084 | PRJNA1199330_P_NODE_66771_length_284_cov_4.222749_g66072_i0 | PRJNA1199330 | 66771 | 284 | 4.222749 | 11.99260716 | Archangium gephyra | 48 | Bacteria | Bacteria | 43.9 | 0.00813 | NR | AKJ00852.1 | 48 | g66072 | i0 | 30.4 | 1.95422535211268 | 79 | 55 | 83.5 | 0 | 261 | 25 | 47 | 125 | AKJ00852.1 Hypothetical protein AA314_02478 [Archangium gephyra] | diamond | 555 | 43.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium gephyra | ||
| 29946289 | 29946289 | PRJNA1199330_P_NODE_64351_length_287_cov_1.149533_g63652_i0 | PRJNA1199330 | 64351 | 287 | 1.149533 | 3.29915971 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 43.9 | 0.0248 | NR | MDR2140480.1 | 2026735 | g63652 | i0 | 33.9 | 0.616724738675958 | 59 | 39 | 61.7 | 0 | 50 | 226 | 133 | 191 | MDR2140480.1 ATP-dependent RecD-like DNA helicase [Deltaproteobacteria bacterium] | diamond | 177 | 43.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 30546481 | 30546481 | PRJNA1199330_P_NODE_115233_length_242_cov_3.656805_g114534_i0 | PRJNA1199330 | 115233 | 242 | 3.656805 | 8.8494681 | Cystobacter fuscus | 43 | Bacteria | Bacteria | 52 | 1.99e-5 | NR | WP_095985960.1 | 43 | g114534 | i0 | 39.3 | 5.20661157024793 | 84 | 42 | 97.9 | 3 | 241 | 5 | 218 | 297 | WP_095985960.1 phosphatidylinositol-specific phospholipase C [Cystobacter fuscus] | diamond | 1260 | 52 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Cystobacter | Cystobacter fuscus | ||
| 30641112 | 30641112 | PRJNA1199330_P_NODE_54633_length_297_cov_1.044643_g53934_i0 | PRJNA1199330 | 54633 | 297 | 1.044643 | 3.10258971 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 72.4 | 1.41e-12 | NR | MBL8680445.1 | 2026763 | g53934 | i0 | 58.1 | 0.626262626262626 | 62 | 26 | 62.6 | 0 | 111 | 296 | 5 | 66 | MBL8680445.1 SDR family NAD(P)-dependent oxidoreductase [Myxococcales bacterium] | diamond | 186 | 72.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 30988930 | 30988930 | PRJNA1199330_P_NODE_22494_length_432_cov_1.529248_g21800_i0 | PRJNA1199330 | 22494 | 432 | 1.529248 | 6.60635136 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 43.1 | 0.0193 | NR | MBM4321556.1 | 2026735 | g21800 | i0 | 38.2 | 0.527777777777778 | 76 | 40 | 50.7 | 4 | 53 | 271 | 1 | 72 | MBM4321556.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 228 | 43.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31273250 | 31273250 | PRJNA1199330_P_NODE_33875_length_355_cov_4.209220_g33176_i0 | PRJNA1199330 | 33875 | 355 | 4.20922 | 14.942731 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 67.8 | 2.04e-10 | NR | MBK9258989.1 | 2268199 | g33176 | i0 | 67.6 | 0.692957746478873 | 37 | 12 | 31.3 | 0 | 135 | 245 | 410 | 446 | MBK9258989.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 246 | 67.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 31368370 | 31368370 | PRJNA1199330_P_NODE_40076_length_326_cov_2.181818_g39377_i0 | PRJNA1199330 | 40076 | 326 | 2.181818 | 7.11272668 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 56.2 | 6.44e-7 | NR | HMJ57057.1 | 2268199 | g39377 | i0 | 36.4 | 0.607361963190184 | 66 | 41 | 59.8 | 1 | 4 | 198 | 111 | 176 | HMJ57057.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 198 | 56.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 31811000 | 31811000 | PRJNA1199330_P_NODE_92577_length_260_cov_3.705882_g91878_i0 | PRJNA1199330 | 92577 | 260 | 3.705882 | 9.6352932 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 44.7 | 0.00644 | NR | UCD85975.1 | 2026735 | g91878 | i0 | 53.7 | 0.473076923076923 | 41 | 16 | 43.8 | 1 | 120 | 233 | 113 | 153 | UCD85975.1 MAG: hypothetical protein JSU92_07220 [Deltaproteobacteria bacterium] | diamond | 123 | 44.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32190698 | 32190698 | PRJNA1199330_P_NODE_120578_length_232_cov_2.817610_g119879_i0 | PRJNA1199330 | 120578 | 232 | 2.81761 | 6.5368552 | Minicystis rosea | 888845 | Bacteria | Bacteria | 45.4 | 0.00358 | NR | APR75041.1 | 888845 | g119879 | i0 | 48.3 | 0.75 | 58 | 28 | 73.7 | 2 | 31 | 201 | 17 | 73 | APR75041.1 serine/threonine protein kinase [Minicystis rosea] | diamond | 174 | 45.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Minicystis | Minicystis rosea | |||
| 32349069 | 32349069 | PRJNA1199330_P_NODE_38219_length_334_cov_5.720307_g37520_i0 | PRJNA1199330 | 38219 | 334 | 5.720307 | 19.10582538 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 153 | 4.58e-45 | NR | TFG97927.1 | 2026763 | g37520 | i0 | 73.3 | 0.808383233532934 | 90 | 24 | 80.8 | 0 | 329 | 60 | 67 | 156 | TFG97927.1 MAG: GFA family protein [Myxococcales bacterium] | diamond | 270 | 153 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 32696158 | 32696158 | PRJNA1199330_P_NODE_42540_length_315_cov_3.954545_g41841_i0 | PRJNA1199330 | 42540 | 315 | 3.954545 | 12.45681675 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 160 | 1.3e-48 | NR | MAJ48576.1 | 2026735 | g41841 | i0 | 86.2 | 6.23809523809524 | 94 | 13 | 89.5 | 0 | 314 | 33 | 11 | 104 | MAJ48576.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 1965 | 160 | 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);;