contig_metadata
26 rows where analysis = "diamond", bioproject = "PRJNA807836" and tax_phylum = "Pseudomonadota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 807214 | 807214 | PRJNA807836_S_NODE_2821_length_1025_cov_98.707983_g2649_i0 | PRJNA807836 | 2821 | 1025 | 98.707983 | 1011.75682575 | Acinetobacter indicus | 756892 | Bacteria | Bacteria | 166 | 5.559999999999999e-46 | NR | WP_216075783.1 | 756892 | g2649 | i0 | 74.3 | 0.638048780487805 | 218 | 43 | 62.3 | 5 | 27 | 665 | 1 | 210 | WP_216075783.1 hypothetical protein, partial [Acinetobacter indicus] | diamond | 654 | 166 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Moraxellales | Moraxellaceae | Acinetobacter | Acinetobacter indicus | ||
| 8460396 | 8460396 | PRJNA807836_S_NODE_5607_length_702_cov_2.275040_g5357_i0 | PRJNA807836 | 5607 | 702 | 2.27504 | 15.9707808 | Acinetobacter indicus | 756892 | Bacteria | Bacteria | 246 | 1.08e-79 | NR | WP_168405950.1 | 756892 | g5357 | i0 | 95.3 | 0.551282051282051 | 129 | 6 | 55.1 | 0 | 3 | 389 | 48 | 176 | WP_168405950.1 HPP family protein, partial [Acinetobacter indicus] | diamond | 387 | 246 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Moraxellales | Moraxellaceae | Acinetobacter | Acinetobacter indicus | ||
| 11011368 | 11011368 | PRJNA807836_S_NODE_8969_length_514_cov_2.000000_g8695_i0 | PRJNA807836 | 8969 | 514 | 2 | 10.28 | Klebsiella pneumoniae | 573 | Bacteria | Bacteria | 320 | 2.03e-109 | NR | WP_317869802.1 | 573 | g8695 | i0 | 96.2 | 0.928015564202335 | 159 | 6 | 92.8 | 0 | 513 | 37 | 35 | 193 | WP_317869802.1 peroxidase family protein, partial [Klebsiella pneumoniae] | diamond | 477 | 320 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | Klebsiella | Klebsiella pneumoniae | ||
| 17385522 | 17385522 | PRJNA807836_S_NODE_28814_length_247_cov_0.885057_g28538_i0 | PRJNA807836 | 28814 | 247 | 0.885057 | 2.18609079 | Sphingomonas turrisvirgatae | 1888892 | Bacteria | Bacteria | 167 | 2.1e-46 | NR | WP_069321885.1 | 1888892 | g28538 | i0 | 96.3 | 1.9919028340081 | 82 | 3 | 99.6 | 0 | 247 | 2 | 150 | 231 | WP_069321885.1 PQQ-dependent dehydrogenase, methanol/ethanol family [Sphingomonas turrisvirgatae] | diamond | 492 | 167 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Alphaproteobacteria | Sphingomonadales | Sphingomonadaceae | Sphingomonas | Sphingomonas turrisvirgatae | ||
| 25033939 | 25033939 | PRJNA807836_S_NODE_9160_length_507_cov_1.299539_g8885_i0 | PRJNA807836 | 9160 | 507 | 1.299539 | 6.58866273 | Bacteria | 2 | Bacteria | Bacteria | 112 | 4.88e-29 | NR | PLK57950.1 | 186490 | g8885 | i0 | 80 | 2.71005917159763 | 65 | 13 | 38.5 | 0 | 324 | 130 | 15 | 79 | PLK57950.1 cold-shock protein [Candidatus Palibaumannia cicadellinicola] | diamond | 1374 | 113 | 0.991150442477876 | Bacteria | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Candidatus Palibaumannia | Candidatus Palibaumannia cicadellinicola | ||||
| 26642551 | 26642551 | PRJNA807836_S_NODE_20801_length_298_cov_3.173333_g20525_i0 | PRJNA807836 | 20801 | 298 | 3.173333 | 9.45653234 | Salmonella enterica | 28901 | Bacteria | Bacteria | 169 | 3.57e-51 | NR | WP_312604412.1 | 28901 | g20525 | i0 | 88.3 | 0.946308724832215 | 94 | 11 | 94.6 | 0 | 15 | 296 | 1 | 94 | WP_312604412.1 Kunitz-type protease inhibitor, partial [Salmonella enterica] | diamond | 282 | 169 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | Salmonella | Salmonella enterica | ||
| 26832740 | 26832740 | PRJNA807836_S_NODE_26561_length_255_cov_2.115385_g26285_i0 | PRJNA807836 | 26561 | 255 | 2.115385 | 5.39423175 | Salmonella enterica | 28901 | Bacteria | Bacteria | 75.1 | 2.33e-14 | NR | WP_312604412.1 | 28901 | g26285 | i0 | 51.3 | 2.89411764705882 | 78 | 28 | 82.4 | 3 | 241 | 32 | 128 | 203 | WP_312604412.1 Kunitz-type protease inhibitor, partial [Salmonella enterica] | diamond | 738 | 75.1 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | Salmonella | Salmonella enterica | ||
| 27528124 | 27528124 | PRJNA807836_S_NODE_22223_length_287_cov_1.079439_g21947_i0 | PRJNA807836 | 22223 | 287 | 1.079439 | 3.09798993 | Magnetospirillum gryphiswaldense MSR-1 | 431944 | Bacteria | Bacteria | 44.3 | 0.0172 | NR | CAM74930.1 | 431944 | g21947 | i0 | 40 | 0.470383275261324 | 45 | 25 | 47 | 1 | 19 | 153 | 337 | 379 | CAM74930.1 malonyl CoA-acyl carrier protein transacylase [Magnetospirillum gryphiswaldense MSR-1] | diamond | 135 | 44.3 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Alphaproteobacteria | Rhodospirillales | Rhodospirillaceae | Magnetospirillum | Magnetospirillum gryphiswaldense | ||
| 27718033 | 27718033 | PRJNA807836_S_NODE_3644_length_903_cov_15.985542_g3446_i0 | PRJNA807836 | 3644 | 903 | 15.985542 | 144.34944426 | Salmonella enterica | 28901 | Bacteria | Bacteria | 334 | 7.72e-113 | NR | WP_312604412.1 | 28901 | g3446 | i0 | 78.5 | 1.36212624584718 | 205 | 44 | 68.1 | 0 | 83 | 697 | 1 | 205 | WP_312604412.1 Kunitz-type protease inhibitor, partial [Salmonella enterica] | diamond | 1230 | 334 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | Salmonella | Salmonella enterica | ||
| 28010848 | 28010848 | PRJNA807836_S_NODE_23745_length_275_cov_2.202970_g23469_i0 | PRJNA807836 | 23745 | 275 | 2.20297 | 6.0581675 | Bacteria | 2 | Bacteria | Bacteria | 43.5 | 0.0304 | NR | MCP5283212.1 | 50421 | g23469 | i0 | 37.7 | 1.47272727272727 | 69 | 42 | 74.2 | 1 | 220 | 17 | 756 | 824 | MCP5283212.1 filamentous hemagglutinin N-terminal domain-containing protein [Rhodoferax sp.] | diamond | 405 | 43.5 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Betaproteobacteria | Burkholderiales | Comamonadaceae | Rhodoferax | Rhodoferax sp. | ||
| 28128188 | 28128188 | PRJNA807836_S_NODE_16805_length_338_cov_1.958491_g16529_i0 | PRJNA807836 | 16805 | 338 | 1.958491 | 6.61969958 | Salmonella enterica | 28901 | Bacteria | Bacteria | 107 | 1.95e-26 | NR | WP_312604412.1 | 28901 | g16529 | i0 | 55.4 | 1.94378698224852 | 112 | 47 | 97.6 | 2 | 2 | 331 | 4 | 114 | WP_312604412.1 Kunitz-type protease inhibitor, partial [Salmonella enterica] | diamond | 657 | 107 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | Salmonella | Salmonella enterica | ||
| 28412321 | 28412321 | PRJNA807836_S_NODE_4686_length_784_cov_6.949367_g4458_i0 | PRJNA807836 | 4686 | 784 | 6.949367 | 54.48303728 | Salmonella enterica | 28901 | Bacteria | Bacteria | 160 | 5.51e-45 | NR | WP_312604412.1 | 28901 | g4458 | i0 | 46.8 | 0.784438775510204 | 205 | 95 | 75 | 6 | 18 | 605 | 3 | 202 | WP_312604412.1 Kunitz-type protease inhibitor, partial [Salmonella enterica] | diamond | 615 | 160 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | Salmonella | Salmonella enterica | ||
| 29012465 | 29012465 | PRJNA807836_S_NODE_26648_length_255_cov_1.219780_g26372_i0 | PRJNA807836 | 26648 | 255 | 1.21978 | 3.110439 | Rhodoplanes sp. | 1968906 | Bacteria | Bacteria | 43.9 | 0.016 | NR | HEX5844959.1 | 1968906 | g26372 | i0 | 40.2 | 0.964705882352941 | 82 | 38 | 96.5 | 3 | 255 | 10 | 118 | 188 | HEX5844959.1 RNA pseudouridine synthase [Rhodoplanes sp.] | diamond | 246 | 43.9 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Alphaproteobacteria | Hyphomicrobiales | Nitrobacteraceae | Rhodoplanes | Rhodoplanes sp. | ||
| 29012467 | 29012467 | PRJNA807836_S_NODE_29848_length_244_cov_0.900585_g29572_i0 | PRJNA807836 | 29848 | 244 | 0.900585 | 2.1974274 | Acinetobacter indicus | 756892 | Bacteria | Bacteria | 45.8 | 0.00154 | NR | WP_168415081.1 | 756892 | g29572 | i0 | 88.5 | 0.639344262295082 | 26 | 3 | 32 | 0 | 165 | 242 | 29 | 54 | WP_168415081.1 hypothetical protein, partial [Acinetobacter indicus] | diamond | 156 | 45.8 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Moraxellales | Moraxellaceae | Acinetobacter | Acinetobacter indicus | ||
| 30243924 | 30243924 | PRJNA807836_S_NODE_5332_length_722_cov_44.821263_g5087_i0 | PRJNA807836 | 5332 | 722 | 44.821263 | 323.60951886 | Salmonella enterica | 28901 | Bacteria | Bacteria | 62.8 | 2.13e-8 | NR | MDR5387524.1 | 90371 | g5087 | i0 | 81.1 | 0.614958448753463 | 148 | 24 | 61.5 | 1 | 10 | 453 | 2 | 145 | MDR5387524.1 hypothetical protein [Salmonella enterica subsp. enterica serovar Typhimurium] | diamond | 444 | 62.8 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | Salmonella | Salmonella enterica | ||
| 30402221 | 30402221 | PRJNA807836_S_NODE_26353_length_257_cov_1.255435_g26077_i0 | PRJNA807836 | 26353 | 257 | 1.255435 | 3.22646795 | Alphaproteobacteria bacterium | 1913988 | Bacteria | Bacteria | 45.1 | 0.00675 | NR | MBO7244758.1 | 1913988 | g26077 | i0 | 48.6 | 0.408560311284047 | 35 | 18 | 40.9 | 0 | 66 | 170 | 496 | 530 | MBO7244758.1 hypothetical protein [Alphaproteobacteria bacterium] | diamond | 105 | 45.1 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Alphaproteobacteria | Alphaproteobacteria bacterium | |||||
| 30875678 | 30875678 | PRJNA807836_S_NODE_25374_length_263_cov_3.342105_g25098_i0 | PRJNA807836 | 25374 | 263 | 3.342105 | 8.78973615 | Salmonella enterica | 28901 | Bacteria | Bacteria | 129 | 1.86e-35 | NR | WP_312604412.1 | 28901 | g25098 | i0 | 78.4 | 0.844106463878327 | 74 | 16 | 84.4 | 0 | 3 | 224 | 132 | 205 | WP_312604412.1 Kunitz-type protease inhibitor, partial [Salmonella enterica] | diamond | 222 | 129 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | Salmonella | Salmonella enterica | ||
| 30875679 | 30875679 | PRJNA807836_S_NODE_26234_length_258_cov_0.816216_g25958_i0 | PRJNA807836 | 26234 | 258 | 0.816216 | 2.10583728 | Salmonella enterica | 28901 | Bacteria | Bacteria | 76.6 | 6.19e-15 | NR | WP_312604412.1 | 28901 | g25958 | i0 | 80.5 | 0.476744186046512 | 41 | 8 | 47.7 | 0 | 257 | 135 | 165 | 205 | WP_312604412.1 Kunitz-type protease inhibitor, partial [Salmonella enterica] | diamond | 123 | 76.6 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | Salmonella | Salmonella enterica | ||
| 30907506 | 30907506 | PRJNA807836_S_NODE_7974_length_557_cov_455.652893_g7707_i0 | PRJNA807836 | 7974 | 557 | 455.652893 | 2537.98661401 | Acinetobacter indicus | 756892 | Bacteria | Bacteria | 242 | 7.42e-79 | NR | WP_171526443.1 | 756892 | g7707 | i0 | 73.9 | 0.824057450628366 | 153 | 40 | 82.4 | 0 | 461 | 3 | 1 | 153 | WP_171526443.1 TauD/TfdA family dioxygenase, partial [Acinetobacter indicus] | diamond | 459 | 242 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Moraxellales | Moraxellaceae | Acinetobacter | Acinetobacter indicus | ||
| 31602943 | 31602943 | PRJNA807836_S_NODE_4316_length_822_cov_183.385848_g4100_i0 | PRJNA807836 | 4316 | 822 | 183.385848 | 1507.43167056 | Salmonella enterica | 28901 | Bacteria | Bacteria | 338 | 6.149999999999999e-115 | NR | WP_312604412.1 | 28901 | g4100 | i0 | 78.5 | 0.748175182481752 | 205 | 44 | 74.8 | 0 | 31 | 645 | 1 | 205 | WP_312604412.1 Kunitz-type protease inhibitor, partial [Salmonella enterica] | diamond | 615 | 338 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | Salmonella | Salmonella enterica | ||
| 31611732 | 31611732 | PRJNA807836_S_NODE_31016_length_241_cov_0.916667_g30740_i0 | PRJNA807836 | 31016 | 241 | 0.916667 | 2.20916747 | root | 1 | Root_unresolved | Root_unresolved | 43.9 | 0.0012 | NR | WP_369124374.1 | 715 | g30740 | i0 | 51.3 | 1.0207468879668 | 39 | 19 | 48.5 | 0 | 161 | 45 | 14 | 52 | WP_369124374.1 GAG-pre-integrase domain-containing protein [Actinobacillus pleuropneumoniae] | diamond | 246 | 43.9 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Pasteurellales | Pasteurellaceae | Actinobacillus | Actinobacillus pleuropneumoniae | ||
| 31737973 | 31737973 | PRJNA807836_S_NODE_14317_length_374_cov_2.036545_g14041_i0 | PRJNA807836 | 14317 | 374 | 2.036545 | 7.6166783 | Enterobacteriaceae | 543 | Bacteria | Bacteria | 72 | 1.43e-12 | NR | WP_317869804.1 | 573 | g14041 | i0 | 72.5 | 0.834224598930481 | 51 | 12 | 40.9 | 1 | 206 | 358 | 12 | 60 | WP_317869804.1 Kunitz family serine protease inhibitor, partial [Klebsiella pneumoniae] | diamond | 312 | 72 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | Klebsiella | Klebsiella pneumoniae | ||
| 31855781 | 31855781 | PRJNA807836_S_NODE_2297_length_1132_cov_10.595845_g1813_i1 | PRJNA807836 | 2297 | 1132 | 10.595845 | 119.9449654 | Acinetobacter indicus | 756892 | Bacteria | Bacteria | 343 | 1.27e-115 | NR | WP_171526443.1 | 756892 | g1813 | i1 | 97.7 | 0.458480565371025 | 173 | 4 | 45.8 | 0 | 1025 | 507 | 1 | 173 | WP_171526443.1 TauD/TfdA family dioxygenase, partial [Acinetobacter indicus] | diamond | 519 | 343 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Moraxellales | Moraxellaceae | Acinetobacter | Acinetobacter indicus | ||
| 32592409 | 32592409 | PRJNA807836_S_NODE_11519_length_432_cov_3.512535_g11243_i0 | PRJNA807836 | 11519 | 432 | 3.512535 | 15.1741512 | Enterobacteriaceae | 543 | Bacteria | Bacteria | 233 | 1.3e-75 | NR | WP_317869804.1 | 573 | g11243 | i0 | 83.7 | 1.96527777777778 | 141 | 22 | 97.9 | 1 | 423 | 1 | 1 | 140 | WP_317869804.1 Kunitz family serine protease inhibitor, partial [Klebsiella pneumoniae] | diamond | 849 | 234 | 0.995726495726496 | Bacteria | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Enterobacterales | Enterobacteriaceae | Klebsiella | Klebsiella pneumoniae | ||
| 32646106 | 32646106 | PRJNA807836_S_NODE_1940_length_1218_cov_12.318777_g1813_i0 | PRJNA807836 | 1940 | 1218 | 12.318777 | 150.04270386 | Acinetobacter indicus | 756892 | Bacteria | Bacteria | 346 | 3.049999999999999e-116 | NR | WP_171526443.1 | 756892 | g1813 | i0 | 98.3 | 0.426108374384236 | 173 | 3 | 42.6 | 0 | 108 | 626 | 1 | 173 | WP_171526443.1 TauD/TfdA family dioxygenase, partial [Acinetobacter indicus] | diamond | 519 | 346 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Moraxellales | Moraxellaceae | Acinetobacter | Acinetobacter indicus | ||
| 32866835 | 32866835 | PRJNA807836_S_NODE_6340_length_651_cov_6.782007_g6083_i0 | PRJNA807836 | 6340 | 651 | 6.782007 | 44.15086557 | Acinetobacter indicus | 756892 | Bacteria | Bacteria | 350 | 5.829999999999999e-121 | NR | WP_171526443.1 | 756892 | g6083 | i0 | 98.8 | 0.797235023041475 | 173 | 2 | 79.7 | 0 | 543 | 25 | 1 | 173 | WP_171526443.1 TauD/TfdA family dioxygenase, partial [Acinetobacter indicus] | diamond | 519 | 350 | 1 | Bacteria | Pseudomonadati | Pseudomonadota | Gammaproteobacteria | Moraxellales | Moraxellaceae | Acinetobacter | Acinetobacter indicus |
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);;