contig_metadata
28 rows where analysis = "diamond", bioproject = "PRJNA1174234" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1590840 | 1590840 | PRJNA1174234_P_NODE_5802_length_564_cov_1.248473_g5606_i0 | PRJNA1174234 | 5802 | 564 | 1.248473 | 7.04138772 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 262 | 2.5400000000000002e-86 | NR | MCA9553765.1 | 2026763 | g5606 | i0 | 65.9 | 7.63829787234043 | 179 | 61 | 95.2 | 0 | 538 | 2 | 1 | 179 | MCA9553765.1 superoxide dismutase [Myxococcales bacterium] | diamond | 4308 | 262 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 13069784 | 13069784 | PRJNA1174234_P_NODE_4071_length_660_cov_15.229983_g3883_i0 | PRJNA1174234 | 4071 | 660 | 15.229983 | 100.5178878 | Nannocystaceae bacterium | 2545255 | Bacteria | Bacteria | 273 | 1.8499999999999999e-90 | NR | MEZ4451588.1 | 2545255 | g3883 | i0 | 75.4 | 1.54090909090909 | 167 | 41 | 75.9 | 0 | 55 | 555 | 5 | 171 | MEZ4451588.1 peptidylprolyl isomerase [Nannocystaceae bacterium] | diamond | 1017 | 273 | 1 | Bacteria | Pseudomonadati | Myxococcota | Nannocystales | Nannocystaceae | Nannocystaceae bacterium | ||||
| 22717839 | 22717839 | PRJNA1174234_P_NODE_23998_length_281_cov_1.288462_g23802_i0 | PRJNA1174234 | 23998 | 281 | 1.288462 | 3.62057822 | Bacteria | 2 | Bacteria | Bacteria | 156 | 2.16e-45 | NR | MBA3457357.1 | 2026735 | g23802 | i0 | 88.9 | 1.94306049822064 | 90 | 10 | 96.1 | 0 | 271 | 2 | 23 | 112 | MBA3457357.1 ABC transporter permease [Deltaproteobacteria bacterium] | diamond | 546 | 157 | 0.993630573248408 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 26787465 | 26787465 | PRJNA1174234_P_NODE_22521_length_291_cov_0.963303_g22325_i0 | PRJNA1174234 | 22521 | 291 | 0.963303 | 2.80321173 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 129 | 2.45e-33 | NR | MBW1877613.1 | 2026735 | g22325 | i0 | 65.2 | 2.92783505154639 | 92 | 32 | 94.8 | 0 | 290 | 15 | 193 | 284 | MBW1877613.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 852 | 129 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 26945488 | 26945488 | PRJNA1174234_P_NODE_22022_length_294_cov_1.389140_g21826_i0 | PRJNA1174234 | 22022 | 294 | 1.38914 | 4.0840716 | Myxococcaceae bacterium | 2484252 | Bacteria | Bacteria | 94 | 5.25e-22 | NR | RYZ15473.1 | 2484252 | g21826 | i0 | 56.2 | 0.908163265306122 | 89 | 39 | 90.8 | 0 | 26 | 292 | 17 | 105 | RYZ15473.1 MAG: ankyrin repeat domain-containing protein [Myxococcaceae bacterium] | diamond | 267 | 94 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcaceae bacterium | |||
| 27154136 | 27154136 | PRJNA1174234_P_NODE_30302_length_249_cov_0.875000_g30106_i0 | PRJNA1174234 | 30302 | 249 | 0.875 | 2.17875 | Bacteria | 2 | Bacteria | Bacteria | 102 | 4.14e-23 | NR | MBM4268004.1 | 2026735 | g30106 | i0 | 57.3 | 5.97590361445783 | 82 | 35 | 98.8 | 0 | 1 | 246 | 375 | 456 | MBM4268004.1 hydroxymethylglutaryl-CoA synthase [Deltaproteobacteria bacterium] | diamond | 1488 | 103 | 0.990291262135922 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 27230116 | 27230116 | PRJNA1174234_P_NODE_14343_length_363_cov_2.224138_g14147_i0 | PRJNA1174234 | 14343 | 363 | 2.224138 | 8.07362094 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 59.7 | 1.81e-7 | NR | MBT9557052.1 | 2026763 | g14147 | i0 | 32.1 | 0.925619834710744 | 112 | 61 | 92.6 | 4 | 22 | 357 | 1167 | 1263 | MBT9557052.1 hypothetical protein [Myxococcales bacterium] | diamond | 336 | 59.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 27261951 | 27261951 | PRJNA1174234_P_NODE_7643_length_495_cov_2.855450_g7447_i0 | PRJNA1174234 | 7643 | 495 | 2.85545 | 14.1344775 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 61.6 | 1.04e-7 | NR | NUO48127.1 | 2268199 | g7447 | i0 | 33.1 | 1.94545454545455 | 160 | 103 | 95.8 | 4 | 494 | 21 | 185 | 342 | NUO48127.1 NAD(P)-dependent alcohol dehydrogenase [Polyangiaceae bacterium] | diamond | 963 | 61.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 27420076 | 27420076 | PRJNA1174234_P_NODE_34083_length_243_cov_0.905882_g33887_i0 | PRJNA1174234 | 34083 | 243 | 0.905882 | 2.20129326 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 77 | 3.12e-16 | NR | MBW1916241.1 | 2026735 | g33887 | i0 | 44.3 | 1.95061728395062 | 79 | 43 | 96.3 | 1 | 2 | 235 | 15 | 93 | MBW1916241.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 474 | 77 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 27609364 | 27609364 | PRJNA1174234_P_NODE_28364_length_255_cov_1.181319_g28168_i0 | PRJNA1174234 | 28364 | 255 | 1.181319 | 3.01236345 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 60.5 | 1.88e-8 | NR | MFO0565523.1 | 2268199 | g28168 | i0 | 43.4 | 2.71764705882353 | 76 | 36 | 88.2 | 2 | 248 | 24 | 159 | 228 | MFO0565523.1 endonuclease/exonuclease/phosphatase family protein [Polyangiaceae bacterium] | diamond | 693 | 60.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 27672559 | 27672559 | PRJNA1174234_P_NODE_15744_length_348_cov_1.872727_g15548_i0 | PRJNA1174234 | 15744 | 348 | 1.872727 | 6.51708996 | Sandaracinaceae bacterium | 2510337 | Bacteria | Bacteria | 51.2 | 1.34e-4 | NR | MCB9661409.1 | 2510337 | g15548 | i0 | 63.9 | 0.577586206896552 | 36 | 12 | 30.2 | 1 | 3 | 107 | 728 | 763 | MCB9661409.1 hypothetical protein [Sandaracinaceae bacterium] | diamond | 201 | 51.2 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Sandaracinaceae | Sandaracinaceae bacterium | ||||
| 27849280 | 27849280 | PRJNA1174234_P_NODE_26244_length_267_cov_1.706186_g26048_i0 | PRJNA1174234 | 26244 | 267 | 1.706186 | 4.55551662 | Bacteria | 2 | Bacteria | Bacteria | 47 | 0.00134 | NR | MBI5903351.1 | 2026735 | g26048 | i0 | 29.5 | 4.76404494382022 | 78 | 53 | 85.4 | 1 | 240 | 13 | 82 | 159 | MBI5903351.1 SIMPL domain-containing protein [Deltaproteobacteria bacterium] | diamond | 1272 | 47 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 27975708 | 27975708 | PRJNA1174234_P_NODE_20345_length_306_cov_1.321888_g20149_i0 | PRJNA1174234 | 20345 | 306 | 1.321888 | 4.04497728 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 118 | 5.23e-31 | NR | NLN63596.1 | 2026763 | g20149 | i0 | 63.9 | 2.91176470588235 | 97 | 35 | 95.1 | 0 | 292 | 2 | 24 | 120 | NLN63596.1 NAD(P)H:quinone oxidoreductase [Myxococcales bacterium] | diamond | 891 | 118 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 28366906 | 28366906 | PRJNA1174234_P_NODE_29746_length_250_cov_0.870056_g29550_i0 | PRJNA1174234 | 29746 | 250 | 0.870056 | 2.17514 | Polyangiaceae bacterium | 2268199 | Bacteria | Bacteria | 53.5 | 6.25e-6 | NR | MFO0613594.1 | 2268199 | g29550 | i0 | 48.5 | 3.408 | 66 | 33 | 79.2 | 1 | 249 | 52 | 255 | 319 | MFO0613594.1 serine/threonine-protein kinase [Polyangiaceae bacterium] | diamond | 852 | 53.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiaceae | Polyangiaceae bacterium | ||||
| 28588255 | 28588255 | PRJNA1174234_P_NODE_27127_length_262_cov_1.211640_g26931_i0 | PRJNA1174234 | 27127 | 262 | 1.21164 | 3.1744968 | Archangium sp. | 1872627 | Bacteria | Bacteria | 64.3 | 1.17e-9 | NR | WP_329733833.1 | 1872627 | g26931 | i0 | 58.3 | 0.549618320610687 | 48 | 20 | 55 | 0 | 6 | 149 | 17 | 64 | WP_329733833.1 kelch repeat-containing protein [Archangium sp.] | diamond | 144 | 64.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium sp. | ||
| 28619811 | 28619811 | PRJNA1174234_P_NODE_27807_length_258_cov_1.248649_g27611_i0 | PRJNA1174234 | 27807 | 258 | 1.248649 | 3.22151442 | Pyxidicoccus fallax | 394095 | Bacteria | Bacteria | 95.1 | 5.91e-22 | NR | WP_169349892.1 | 394095 | g27611 | i0 | 54.2 | 0.965116279069767 | 83 | 37 | 96.5 | 1 | 253 | 5 | 103 | 184 | WP_169349892.1 maleylacetoacetate isomerase [Pyxidicoccus fallax] | diamond | 249 | 95.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Pyxidicoccus | Pyxidicoccus fallax | ||
| 28670489 | 28670489 | PRJNA1174234_P_NODE_3227_length_731_cov_1.164134_g3050_i0 | PRJNA1174234 | 3227 | 731 | 1.164134 | 8.50981954 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 64.7 | 6.85e-8 | NR | MBP6839133.1 | 2212474 | g3050 | i0 | 28.2 | 5.16279069767442 | 216 | 99 | 72.2 | 7 | 599 | 72 | 450 | 649 | MBP6839133.1 hypothetical protein [Kofleriaceae bacterium] | diamond | 3774 | 65.1 | 0.993855606758833 | Bacteria | Pseudomonadati | Myxococcota | Haliangiales | Kofleriaceae | Kofleriaceae bacterium | ||||
| 28777387 | 28777387 | PRJNA1174234_P_NODE_25787_length_270_cov_1.497462_g25591_i0 | PRJNA1174234 | 25787 | 270 | 1.497462 | 4.0431474 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 61.6 | 8.73e-9 | NR | RLB97998.1 | 2026735 | g25591 | i0 | 39.3 | 3.95555555555556 | 89 | 51 | 98.9 | 1 | 268 | 2 | 154 | 239 | RLB97998.1 MAG: signal peptide peptidase SppA [Deltaproteobacteria bacterium] | diamond | 1068 | 61.6 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 28840527 | 28840527 | PRJNA1174234_P_NODE_17308_length_331_cov_2.135659_g17112_i0 | PRJNA1174234 | 17308 | 331 | 2.135659 | 7.06903129 | Myxococcales bacterium | 2026763 | Bacteria | Bacteria | 84 | 2.69e-17 | NR | MCA9634375.1 | 2026763 | g17112 | i0 | 63.8 | 1.22356495468278 | 58 | 21 | 52.6 | 0 | 176 | 3 | 75 | 132 | MCA9634375.1 hypothetical protein [Myxococcales bacterium] | diamond | 405 | 84 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcales bacterium | ||||
| 29093379 | 29093379 | PRJNA1174234_P_NODE_17508_length_329_cov_2.378906_g17312_i0 | PRJNA1174234 | 17508 | 329 | 2.378906 | 7.82660074 | Archangium sp. | 1872627 | Bacteria | Bacteria | 44.7 | 0.0208 | NR | HZH13888.1 | 1872627 | g17312 | i0 | 32.1 | 0.993920972644377 | 109 | 60 | 95.7 | 4 | 316 | 2 | 481 | 579 | HZH13888.1 serine protease [Archangium sp.] | diamond | 327 | 44.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium sp. | ||
| 29250894 | 29250894 | PRJNA1174234_P_NODE_13169_length_379_cov_1.509804_g12973_i0 | PRJNA1174234 | 13169 | 379 | 1.509804 | 5.72215716 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 59.3 | 2.84e-7 | NR | MBM4354478.1 | 2026735 | g12973 | i0 | 41 | 2.62005277044855 | 83 | 43 | 61.7 | 3 | 17 | 250 | 975 | 1056 | MBM4354478.1 hypothetical protein [Deltaproteobacteria bacterium] | diamond | 993 | 59.3 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29250919 | 29250919 | PRJNA1174234_P_NODE_25429_length_272_cov_1.547739_g25233_i0 | PRJNA1174234 | 25429 | 272 | 1.547739 | 4.20985008 | Paraliomyxa miuraensis | 376150 | Bacteria | Bacteria | 69.7 | 1.69e-11 | NR | WP_266214564.1 | 376150 | g25233 | i0 | 61.8 | 1.81985294117647 | 55 | 15 | 60.7 | 1 | 165 | 1 | 402 | 450 | WP_266214564.1 AMP-dependent synthetase/ligase [Paraliomyxa miuraensis] | diamond | 495 | 69.7 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Paraliomyxa | Paraliomyxa miuraensis | |||
| 29503570 | 29503570 | PRJNA1174234_P_NODE_27930_length_257_cov_1.543478_g27734_i0 | PRJNA1174234 | 27930 | 257 | 1.543478 | 3.96673846 | Deltaproteobacteria bacterium | 2026735 | Bacteria | Bacteria | 55.1 | 2.02e-6 | NR | RLB65038.1 | 2026735 | g27734 | i0 | 43.1 | 2.59143968871595 | 72 | 38 | 80.5 | 2 | 257 | 51 | 137 | 208 | RLB65038.1 MAG: hypothetical protein DRI90_03060 [Deltaproteobacteria bacterium] | diamond | 666 | 55.1 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Deltaproteobacteria bacterium | |||||
| 29870204 | 29870204 | PRJNA1174234_P_NODE_15771_length_348_cov_1.120000_g15575_i0 | PRJNA1174234 | 15771 | 348 | 1.12 | 3.8976 | Archangium | 47 | Bacteria | Bacteria | 152 | 6.63e-41 | NR | WP_376759144.1 | 83451 | g15575 | i0 | 60.9 | 10.9310344827586 | 115 | 44 | 99.1 | 1 | 348 | 4 | 458 | 571 | WP_376759144.1 LysM peptidoglycan-binding domain-containing protein [Archangium violaceum] | diamond | 3804 | 152 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Archangiaceae | Archangium | Archangium violaceum | ||
| 30862008 | 30862008 | PRJNA1174234_P_NODE_16814_length_336_cov_2.479087_g16618_i0 | PRJNA1174234 | 16814 | 336 | 2.479087 | 8.32973232 | Myxococcaceae bacterium | 2484252 | Bacteria | Bacteria | 67.8 | 1.75e-11 | NR | RYZ15474.1 | 2484252 | g16618 | i0 | 50.8 | 0.526785714285714 | 59 | 29 | 52.7 | 0 | 328 | 152 | 95 | 153 | RYZ15474.1 MAG: ankyrin repeat domain-containing protein [Myxococcaceae bacterium] | diamond | 177 | 67.8 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcia | Myxococcales | Myxococcaceae | Myxococcaceae bacterium | |||
| 31747204 | 31747204 | PRJNA1174234_P_NODE_21377_length_299_cov_0.995575_g21181_i0 | PRJNA1174234 | 21377 | 299 | 0.995575 | 2.97676925 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 140 | 5.3699999999999996e-40 | NR | MEE3327274.1 | 2818507 | g21181 | i0 | 71.4 | 0.91304347826087 | 91 | 26 | 91.3 | 0 | 273 | 1 | 8 | 98 | MEE3327274.1 nucleoside deaminase [Myxococcota bacterium] | diamond | 273 | 140 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota bacterium | ||||||
| 32158765 | 32158765 | PRJNA1174234_P_NODE_8738_length_466_cov_1.854962_g8542_i0 | PRJNA1174234 | 8738 | 466 | 1.854962 | 8.64412292 | Polyangiales bacterium | 3034171 | Bacteria | Bacteria | 140 | 3.04e-35 | NR | MFO0694287.1 | 3034171 | g8542 | i0 | 45.8 | 0.927038626609442 | 144 | 76 | 92.7 | 2 | 34 | 465 | 242 | 383 | MFO0694287.1 thrombospondin type 3 repeat-containing protein [Polyangiales bacterium] | diamond | 432 | 140 | 1 | Bacteria | Pseudomonadati | Myxococcota | Polyangiales | Polyangiales bacterium | |||||
| 32790070 | 32790070 | PRJNA1174234_P_NODE_15760_length_348_cov_1.400000_g15564_i0 | PRJNA1174234 | 15760 | 348 | 1.4 | 4.872 | Myxococcota bacterium | 2818507 | Bacteria | Bacteria | 75.5 | 5.01e-14 | NR | MFT5453703.1 | 2818507 | g15564 | i0 | 38.3 | 2.97413793103448 | 115 | 69 | 99.1 | 1 | 3 | 347 | 37 | 149 | MFT5453703.1 SAM-dependent methyltransferase [Myxococcota bacterium] | diamond | 1035 | 75.5 | 1 | Bacteria | Pseudomonadati | Myxococcota | Myxococcota 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);;