contig_metadata
25 rows where bioproject = "PRJNA1214993", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15633209 | 15633209 | PRJNA1214993_P_NODE_213_length_1738_cov_24.783183_g167_i0 | PRJNA1214993 | 213 | 1738 | 24.783183 | 430.73172054 | Pendulispora brunnea | 2905690 | Bacteria | Bacteria | 2248 | 0 | NTclustered | gi|2698055994|gb|CP089982.1| | 2905690 | g167 | i0 | 90.109 | 160.72669735328 | 1749 | 147 | 99 | 21 | 1 | 1736 | 7409503 | 7407768 | Pendulispora brunnea strain MSr12523 chromosome, complete genome | blastn | 279343 | 2248 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Pendulisporaceae | Pendulispora | Pendulispora brunnea | ||
| 26755967 | 26755967 | PRJNA1214993_P_NODE_8961_length_364_cov_1.525773_g8775_i0 | PRJNA1214993 | 8961 | 364 | 1.525773 | 5.55381372 | Polyangia bacterium | 3058050 | Bacteria | Bacteria | 181 | 1.72e-53 | NR | HEX2568019.1 | 3058050 | g8775 | i0 | 67.5 | 2.95054945054945 | 120 | 39 | 98.9 | 0 | 362 | 3 | 104 | 223 | HEX2568019.1 methyltransferase domain-containing protein [Polyangia bacterium] | diamond | 1074 | 181 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangia bacterium | ||||||
| 27028236 | 27028236 | PRJNA1214993_P_NODE_13562_length_300_cov_1.030837_g13376_i0 | PRJNA1214993 | 13562 | 300 | 1.030837 | 3.092511 | Bacteria | 2 | Bacteria | Bacteria | 74.7 | 1.19e-13 | NR | APR78274.1 | 888845 | g13376 | i0 | 41.6 | 2.98 | 101 | 54 | 98 | 3 | 295 | 2 | 21 | 119 | APR78274.1 Hypothetical protein A7982_03621 [Minicystis rosea] | diamond | 894 | 74.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Minicystis | Minicystis rosea | |||
| 27452088 | 27452088 | PRJNA1214993_P_NODE_17043_length_271_cov_1.575758_g16857_i0 | PRJNA1214993 | 17043 | 271 | 1.575758 | 4.27030418 | Nannocystis sp. ILAH1 | 2996789 | Bacteria | Bacteria | 52.8 | 1.64e-5 | NR | WP_267741719.1 | 2996789 | g16857 | i0 | 39.3 | 1.88191881918819 | 89 | 43 | 90.8 | 3 | 249 | 4 | 1772 | 1856 | WP_267741719.1 LamG-like jellyroll fold domain-containing protein [Nannocystis sp. ILAH1] | diamond | 510 | 52.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Nannocystales | Nannocystaceae | Nannocystis | Nannocystis sp. ILAH1 | |||
| 27502470 | 27502470 | PRJNA1214993_P_NODE_15903_length_280_cov_1.169082_g15717_i0 | PRJNA1214993 | 15903 | 280 | 1.169082 | 3.2734296 | Myxococcia | 32015 | Bacteria | Bacteria | 144 | 1.22e-37 | NR | HEY8377888.1 | 1962667 | g15717 | i0 | 76.3 | 26.9035714285714 | 93 | 22 | 99.6 | 0 | 1 | 279 | 34 | 126 | HEY8377888.1 SDR family NAD(P)-dependent oxidoreductase [Nannocystis sp.] | diamond | 7533 | 145 | 0.993103448275862 | Bacteria | Pseudomonadati | Myxococcota | Nannocystales | Nannocystaceae | Nannocystis | Nannocystis sp. | |||
| 27609836 | 27609836 | PRJNA1214993_P_NODE_20424_length_251_cov_1.348315_g20238_i0 | PRJNA1214993 | 20424 | 251 | 1.348315 | 3.38427065 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 51.2 | 2.43e-5 | NR | HEY1698064.1 | 2268199 | g20238 | i0 | 42.5 | 1.91235059760956 | 80 | 37 | 94.4 | 5 | 8 | 244 | 6 | 77 | HEY1698064.1 glutathione S-transferase family protein [Polyangiaceae bacterium] | diamond | 480 | 51.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 27704848 | 27704848 | PRJNA1214993_P_NODE_26484_length_235_cov_2.518519_g26298_i0 | PRJNA1214993 | 26484 | 235 | 2.518519 | 5.91851965 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 76.6 | 3.18e-14 | NR | HEY6728916.1 | 2268199 | g26298 | i0 | 50 | 0.893617021276596 | 70 | 35 | 89.4 | 0 | 3 | 212 | 262 | 331 | HEY6728916.1 phosphoglycerate kinase [Polyangiaceae bacterium] | diamond | 210 | 76.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 27881123 | 27881123 | PRJNA1214993_P_NODE_12545_length_312_cov_0.970711_g12359_i0 | PRJNA1214993 | 12545 | 312 | 0.970711 | 3.02861832 | Bacteria | 2 | Bacteria | Bacteria | 87 | 2.12e-17 | NR | MCK6510237.1 | 2818507 | g12359 | i0 | 45.6 | 4.79807692307692 | 103 | 55 | 99 | 1 | 3 | 311 | 386 | 487 | MCK6510237.1 leucyl aminopeptidase [Myxococcota bacterium] | diamond | 1497 | 87.4 | 0.995423340961098 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 28620278 | 28620278 | PRJNA1214993_P_NODE_17767_length_266_cov_1.196891_g17581_i0 | PRJNA1214993 | 17767 | 266 | 1.196891 | 3.18373006 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 54.3 | 4.22e-6 | NR | MBL91784.1 | 2026763 | g17581 | i0 | 44.9 | 0.552631578947368 | 49 | 25 | 55.3 | 2 | 26 | 172 | 266 | 312 | MBL91784.1 hypothetical protein [Myxococcales bacterium] | diamond | 147 | 54.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 28841045 | 28841045 | PRJNA1214993_P_NODE_9968_length_347_cov_1.124088_g9782_i0 | PRJNA1214993 | 9968 | 347 | 1.124088 | 3.90058536 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 50.4 | 2.14e-4 | NR | MBK9070054.1 | 2026763 | g9782 | i0 | 37.2 | 0.674351585014409 | 78 | 43 | 64 | 4 | 113 | 334 | 231 | 306 | MBK9070054.1 PPC domain-containing protein [Myxococcales bacterium] | diamond | 234 | 50.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 28999376 | 28999376 | PRJNA1214993_P_NODE_3968_length_533_cov_2.010870_g3783_i0 | PRJNA1214993 | 3968 | 533 | 2.01087 | 10.7179371 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 64.7 | 1.67e-8 | NR | TNE44083.1 | 2026735 | g3783 | i0 | 57.4 | 1.05816135084428 | 47 | 20 | 26.5 | 0 | 531 | 391 | 82 | 128 | TNE44083.1 MAG: discoidin domain-containing protein [Deltaproteobacteria bacterium] | diamond | 564 | 64.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29346396 | 29346396 | PRJNA1214993_P_NODE_10969_length_332_cov_1.783784_g10783_i0 | PRJNA1214993 | 10969 | 332 | 1.783784 | 5.92216288 | Enhygromyxa sp. | 2666105 | Bacteria | Bacteria | 99.8 | 4.03e-22 | NR | HVH99620.1 | 2666105 | g10783 | i0 | 44.9 | 0.966867469879518 | 107 | 53 | 95.8 | 3 | 9 | 326 | 264 | 365 | HVH99620.1 cellulase family glycosylhydrolase [Enhygromyxa sp.] | diamond | 321 | 99.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Nannocystales | Nannocystaceae | Enhygromyxa | Enhygromyxa sp. | |||
| 29535741 | 29535741 | PRJNA1214993_P_NODE_12610_length_311_cov_1.201681_g12424_i0 | PRJNA1214993 | 12610 | 311 | 1.201681 | 3.73722791 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 96.3 | 1.09e-20 | NR | MBL8606644.1 | 2026763 | g12424 | i0 | 50.5 | 0.916398713826367 | 95 | 46 | 90.7 | 1 | 296 | 15 | 328 | 422 | MBL8606644.1 hypothetical protein [Myxococcales bacterium] | diamond | 285 | 96.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 29535787 | 29535787 | PRJNA1214993_P_NODE_8910_length_365_cov_1.496575_g8724_i0 | PRJNA1214993 | 8910 | 365 | 1.496575 | 5.46249875 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 48.9 | 6.98e-4 | NR | MBI3555187.1 | 2026735 | g8724 | i0 | 45.8 | 0.394520547945205 | 48 | 24 | 37.8 | 1 | 139 | 2 | 54 | 101 | MBI3555187.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 144 | 48.9 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29819712 | 29819712 | PRJNA1214993_P_NODE_19731_length_253_cov_0.866667_g19545_i0 | PRJNA1214993 | 19731 | 253 | 0.866667 | 2.19266751 | Myxococcaceae bacterium | 2484252 | Bacteria | Bacteria | 66.6 | 1.57e-10 | NR | MCA2980133.1 | 2484252 | g19545 | i0 | 63.4 | 0.486166007905138 | 41 | 15 | 48.6 | 0 | 253 | 131 | 4 | 44 | MCA2980133.1 hypothetical protein [Myxococcaceae bacterium] | diamond | 123 | 66.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcaceae bacterium | |||
| 30104155 | 30104155 | PRJNA1214993_P_NODE_23272_length_247_cov_0.885057_g23086_i0 | PRJNA1214993 | 23272 | 247 | 0.885057 | 2.18609079 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 110 | 1.9400000000000003e-27 | NR | MBO6937473.1 | 2026735 | g23086 | i0 | 67.9 | 1.96761133603239 | 81 | 22 | 98.4 | 2 | 247 | 5 | 14 | 90 | MBO6937473.1 exonuclease domain-containing protein [Deltaproteobacteria bacterium] | diamond | 486 | 110 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 30357552 | 30357552 | PRJNA1214993_P_NODE_8252_length_378_cov_0.816393_g8066_i0 | PRJNA1214993 | 8252 | 378 | 0.816393 | 3.08596554 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 45.4 | 0.016 | NR | HVY29083.1 | 2268199 | g8066 | i0 | 26.5 | 0.896825396825397 | 113 | 69 | 80.2 | 2 | 18 | 320 | 217 | 327 | HVY29083.1 hypothetical protein [Polyangiaceae bacterium] | diamond | 339 | 45.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 30452040 | 30452040 | PRJNA1214993_P_NODE_21193_length_250_cov_0.881356_g21007_i0 | PRJNA1214993 | 21193 | 250 | 0.881356 | 2.20339 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 93.6 | 5.49e-20 | NR | MBT9555180.1 | 2026763 | g21007 | i0 | 57.8 | 0.996 | 83 | 32 | 99.6 | 3 | 2 | 250 | 101 | 180 | MBT9555180.1 PKD domain-containing protein [Myxococcales bacterium] | diamond | 249 | 93.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 30862497 | 30862497 | PRJNA1214993_P_NODE_10474_length_339_cov_0.988722_g10288_i0 | PRJNA1214993 | 10474 | 339 | 0.988722 | 3.35176758 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 84 | 5.19e-17 | NR | RMG94844.1 | 2026735 | g10288 | i0 | 44 | 0.743362831858407 | 84 | 46 | 74.3 | 1 | 297 | 46 | 111 | 193 | RMG94844.1 MAG: hypothetical protein D6705_15075 [Deltaproteobacteria bacterium] | diamond | 252 | 84 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 31146476 | 31146476 | PRJNA1214993_P_NODE_13535_length_300_cov_1.356828_g13349_i0 | PRJNA1214993 | 13535 | 300 | 1.356828 | 4.070484 | Nannocystaceae bacterium | 2545255 | Bacteria | Bacteria | 125 | 6.129999999999999e-32 | NR | MEZ4448627.1 | 2545255 | g13349 | i0 | 62.2 | 0.98 | 98 | 37 | 98 | 0 | 3 | 296 | 97 | 194 | MEZ4448627.1 acetyl-CoA C-acetyltransferase [Nannocystaceae bacterium] | diamond | 294 | 125 | 1 | Bacteria | Pseudomonadati | Myxococcota | Nannocystales | Nannocystaceae | Nannocystaceae bacterium | ||||
| 31558248 | 31558248 | PRJNA1214993_P_NODE_21816_length_249_cov_0.886364_g21630_i0 | PRJNA1214993 | 21816 | 249 | 0.886364 | 2.20704636 | Sandaracinus amylolyticus | 927083 | Bacteria | Bacteria | 68.2 | 4.26e-11 | NR | WP_236606936.1 | 927083 | g21630 | i0 | 47.5 | 3.81927710843373 | 80 | 38 | 91.6 | 1 | 230 | 3 | 167 | 246 | WP_236606936.1 trypsin-like serine peptidase [Sandaracinus amylolyticus] | diamond | 951 | 68.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Sandaracinaceae | Sandaracinus | Sandaracinus amylolyticus | |||
| 32032591 | 32032591 | PRJNA1214993_P_NODE_2778_length_632_cov_2.359571_g2600_i0 | PRJNA1214993 | 2778 | 632 | 2.359571 | 14.91248872 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 91.7 | 2.94e-18 | NR | TNE43614.1 | 2026735 | g2600 | i0 | 33.8 | 1.89398734177215 | 210 | 124 | 97.8 | 6 | 632 | 15 | 73 | 271 | TNE43614.1 MAG: SAM-dependent methyltransferase [Deltaproteobacteria bacterium] | diamond | 1197 | 91.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32127640 | 32127640 | PRJNA1214993_P_NODE_17118_length_270_cov_5.106599_g16932_i0 | PRJNA1214993 | 17118 | 270 | 5.106599 | 13.7878173 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 87.4 | 3.05e-20 | NR | MBN2798920.1 | 2026735 | g16932 | i0 | 49.4 | 0.966666666666667 | 87 | 44 | 96.7 | 0 | 265 | 5 | 1 | 87 | MBN2798920.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 261 | 87.4 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32853719 | 32853719 | PRJNA1214993_P_NODE_9980_length_347_cov_0.817518_g9794_i0 | PRJNA1214993 | 9980 | 347 | 0.817518 | 2.83678746 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 45.1 | 0.0188 | NR | MDX2165657.1 | 2026735 | g9794 | i0 | 30.8 | 0.674351585014409 | 78 | 49 | 65.7 | 2 | 19 | 246 | 692 | 766 | MDX2165657.1 glycosyltransferase [Deltaproteobacteria bacterium] | diamond | 234 | 45.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 32903912 | 32903912 | PRJNA1214993_P_NODE_16560_length_275_cov_1.143564_g16374_i0 | PRJNA1214993 | 16560 | 275 | 1.143564 | 3.144801 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 70.5 | 1.24e-12 | NR | NQW62152.1 | 2026735 | g16374 | i0 | 42.7 | 3.24 | 75 | 37 | 78.5 | 2 | 49 | 264 | 22 | 93 | NQW62152.1 lipocalin family protein [Deltaproteobacteria bacterium] | diamond | 891 | 70.5 | 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);;