RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

28 rows where analysis = "diamond", bioproject = "PRJNA1151638" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 28 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1151638 · 28 ✖

analysis 1

  • diamond · 28 ✖

tax_clade 0

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
1576625 1576625 PRJNA1151638_P_NODE_5882_length_246_cov_1.612717_g5815_i0 PRJNA1151638 5882 246 1.612717 3.96728382 Falsiroseomonas sp. 2870721 Bacteria Bacteria 75.9 2.73e-15   NR WP_368415400.1 2870721 g5815 i0 90.5 1.02439024390244 42 4 51.2 0 128 3 1 42 WP_368415400.1 DUF1489 family protein [Falsiroseomonas sp.] diamond 252 75.9 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Acetobacterales Roseomonadaceae Falsiroseomonas Falsiroseomonas sp.
5405079 5405079 PRJNA1151638_P_NODE_5465_length_249_cov_0.886364_g5398_i0 PRJNA1151638 5465 249 0.886364 2.20704636 Cupriavidus gilardii J11 936133 Bacteria Bacteria 148 5.2e-41   NR TWG88441.1 936133 g5398 i0 100 0.951807228915663 79 0 95.2 0 11 247 1 79 TWG88441.1 uncharacterized membrane protein YkvA (DUF1232 family) [Cupriavidus gilardii J11] diamond 237 148 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Cupriavidus Cupriavidus gilardii
7414814 7414814 PRJNA1151638_P_NODE_5446_length_249_cov_0.886364_g5379_i0 PRJNA1151638 5446 249 0.886364 2.20704636 Pseudoxanthomonas sp. J35 935852 Bacteria Bacteria 126 1.5499999999999998e-32   NR WP_198014133.1 935852 g5379 i0 70.7 0.987951807228916 82 24 98.8 0 2 247 228 309 WP_198014133.1 glycosyltransferase family 4 protein [Pseudoxanthomonas sp. J35] diamond 246 126 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Lysobacterales Lysobacteraceae Pseudoxanthomonas Pseudoxanthomonas sp. J35
14331034 14331034 PRJNA1151638_P_NODE_932_length_459_cov_1.533679_g865_i0 PRJNA1151638 932 459 1.533679 7.03958661 Bacteria 2 Bacteria Bacteria 232 2.23e-69   NR WP_009467750.1 744980 g865 i0 75.8 61 153 37 100 0 459 1 119 271 WP_009467750.1 class 1b ribonucleoside-diphosphate reductase subunit alpha [Roseibium sp. TrichSKD4] diamond 27999 233 0.995708154506438 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Stappiaceae Roseibium Roseibium sp. TrichSKD4
18888525 18888525 PRJNA1151638_P_NODE_6315_length_244_cov_0.912281_g6248_i0 PRJNA1151638 6315 244 0.912281 2.22596564 Massilia sp. TN1-12 3377675 Bacteria Bacteria 167 3.33e-49   NR WP_404536040.1 3377675 g6248 i0 100 1.99180327868852 81 0 99.6 0 243 1 108 188 WP_404536040.1 MobV family relaxase, partial [Massilia sp. TN1-12] diamond 486 167 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Massilia Massilia paldalensis
28177071 28177071 PRJNA1151638_P_NODE_2206_length_327_cov_3.413386_g2139_i0 PRJNA1151638 2206 327 3.413386 11.16177222 Pseudomonadota bacterium 1977087 Bacteria Bacteria 70.9 2.27e-13   NR MEC8552706.1 1977087 g2139 i0 38.8 0.73394495412844 80 43 67.9 2 252 31 1 80 MEC8552706.1 hypothetical protein [Pseudomonadota bacterium] diamond 240 70.9 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
28240281 28240281 PRJNA1151638_P_NODE_5206_length_250_cov_0.881356_g5139_i0 PRJNA1151638 5206 250 0.881356 2.20339 Mesorhizobium atlanticum 2233532 Bacteria Bacteria 100 2.04e-22   NR WP_245431496.1 2233532 g5139 i0 72.3 1.56 65 18 78 0 250 56 433 497 WP_245431496.1 cardiolipin synthase [Mesorhizobium atlanticum] diamond 390 100 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Phyllobacteriaceae Mesorhizobium Mesorhizobium atlanticum
28461714 28461714 PRJNA1151638_P_NODE_4906_length_252_cov_0.871508_g4839_i0 PRJNA1151638 4906 252 0.871508 2.19620016 Lysobacter enzymogenes 69 Bacteria Bacteria 136 3.92e-35   NR WP_206410482.1 69 g4839 i0 87.8 1.95238095238095 82 10 97.6 0 246 1 466 547 WP_206410482.1 DUF5682 family protein [Lysobacter enzymogenes] diamond 492 136 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Lysobacterales Lysobacteraceae Lysobacter Lysobacter enzymogenes
28587960 28587960 PRJNA1151638_P_NODE_6507_length_243_cov_0.917647_g6440_i0 PRJNA1151638 6507 243 0.917647 2.22988221 Devosia sp. 1871048 Bacteria Bacteria 100 3.29e-25   NR HZY69047.1 1871048 g6440 i0 73.9 0.851851851851852 69 15 81.5 1 2 199 21 89 HZY69047.1 hypothetical protein [Devosia sp.] diamond 207 100 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Devosiaceae Devosia Devosia sp.
28764958 28764958 PRJNA1151638_P_NODE_6867_length_238_cov_2.448485_g6800_i0 PRJNA1151638 6867 238 2.448485 5.8273943 Bacteria 2 Bacteria Bacteria 126 1.3199999999999999e-31   NR WP_090520657.1 591205 g6800 i0 75.6 22.6134453781513 78 19 98.3 0 236 3 286 363 WP_090520657.1 class 1b ribonucleoside-diphosphate reductase subunit alpha [Paracoccus isoporae] diamond 5382 126 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodobacterales Paracoccaceae Paracoccus Paracoccus isoporae
29187914 29187914 PRJNA1151638_P_NODE_6769_length_242_cov_0.923077_g6702_i0 PRJNA1151638 6769 242 0.923077 2.23384634 Roseateles puraquae 431059 Bacteria Bacteria 88.2 4.51e-21   NR WP_088482880.1 431059 g6702 i0 100 0.520661157024793 42 0 52.1 0 241 116 20 61 WP_088482880.1 hypothetical protein [Roseateles puraquae] diamond 126 88.2 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Sphaerotilaceae Roseateles Roseateles puraquae
29345611 29345611 PRJNA1151638_P_NODE_1429_length_384_cov_1.954984_g1362_i0 PRJNA1151638 1429 384 1.954984 7.50713856 Mesorhizobium sp. YM1C-6-2 1827501 Bacteria Bacteria 46.6 0.00751   NR WP_121580814.1 1827501 g1362 i0 43.4 0.4140625 53 30 41.4 0 75 233 554 606 WP_121580814.1 mechanosensitive ion channel family protein [Mesorhizobium sp. YM1C-6-2] diamond 159 46.6 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Phyllobacteriaceae Mesorhizobium Mesorhizobium sp. YM1C-6-2
29408654 29408654 PRJNA1151638_P_NODE_4889_length_252_cov_0.871508_g4822_i0 PRJNA1151638 4889 252 0.871508 2.19620016 Lysobacter enzymogenes 69 Bacteria Bacteria 134 3.5000000000000003e-34   NR WP_232518383.1 69 g4822 i0 73.8 1 84 22 100 0 1 252 64 147 WP_232518383.1 glucosylglycerol-phosphate synthase [Lysobacter enzymogenes] diamond 252 134 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Lysobacterales Lysobacteraceae Lysobacter Lysobacter enzymogenes
29566498 29566498 PRJNA1151638_P_NODE_6550_length_243_cov_0.917647_g6483_i0 PRJNA1151638 6550 243 0.917647 2.22988221 Cupriavidus gilardii J11 936133 Bacteria Bacteria 168 1.53e-50   NR TWG79659.1 936133 g6483 i0 98.8 0.987654320987654 80 1 98.8 0 2 241 126 205 TWG79659.1 hypothetical protein L602_000600000590 [Cupriavidus gilardii J11] diamond 240 168 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Cupriavidus Cupriavidus gilardii
29882564 29882564 PRJNA1151638_P_NODE_6511_length_243_cov_0.917647_g6444_i0 PRJNA1151638 6511 243 0.917647 2.22988221 Daeguia caeni 439612 Bacteria Bacteria 167 1.18e-49   NR WP_374831619.1 439612 g6444 i0 100 0.987654320987654 80 0 98.8 0 2 241 66 145 WP_374831619.1 glycosyltransferase [Daeguia caeni] diamond 240 167 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Brucellaceae Daeguia Daeguia caeni
30071769 30071769 PRJNA1151638_P_NODE_7172_length_221_cov_68.587838_g7105_i0 PRJNA1151638 7172 221 68.587838 151.57912198 Klebsiella pneumoniae 573 Bacteria Bacteria 111 2.76e-29   NR WP_416532323.1 573 g7105 i0 100 0.678733031674208 50 0 67.9 0 1 150 98 147 WP_416532323.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 150 111 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
30217601 30217601 PRJNA1151638_P_NODE_2812_length_300_cov_2.242291_g2745_i0 PRJNA1151638 2812 300 2.242291 6.726873 root 1 Root_unresolved Root_unresolved 50.4 4.38e-5   NR PZM40848.1 28144 g2745 i0 36 1.5 75 47 74 1 31 252 74 148 PZM40848.1 hypothetical protein DOM01_27445, partial [Salmonella enterica subsp. enterica serovar Derby] diamond 450 50.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Salmonella Salmonella enterica
30388282 30388282 PRJNA1151638_P_NODE_1753_length_355_cov_1.723404_g1686_i0 PRJNA1151638 1753 355 1.723404 6.1180842 Alphaproteobacteria bacterium 1913988 Bacteria Bacteria 44.3 0.0337   NR MDC1134009.1 1913988 g1686 i0 38.5 0.659154929577465 78 46 65.1 2 272 42 254 330 MDC1134009.1 CoA transferase [Alphaproteobacteria bacterium] diamond 234 44.3 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria       Alphaproteobacteria bacterium
30723106 30723106 PRJNA1151638_P_NODE_5434_length_249_cov_0.886364_g5367_i0 PRJNA1151638 5434 249 0.886364 2.20704636 Sphingomonas 13687 Bacteria Bacteria 132 1.75e-34   NR WP_183986842.1 535907 g5367 i0 82.7 2.95180722891566 81 14 97.6 0 2 244 157 237 WP_183986842.1 sugar MFS transporter [Sphingomonas jinjuensis] diamond 735 132 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas Sphingomonas jinjuensis
31430670 31430670 PRJNA1151638_P_NODE_456_length_644_cov_1.612960_g390_i0 PRJNA1151638 456 644 1.61296 10.3874624 Rickettsiales bacterium 2026788 Bacteria Bacteria 198 7.549999999999999e-57   NR MDR2685895.1 2026788 g390 i0 49.5 2.01708074534162 214 97 95 3 32 643 41 253 MDR2685895.1 N-6 DNA methylase [Rickettsiales bacterium] diamond 1299 198 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rickettsiales     Rickettsiales bacterium
31683595 31683595 PRJNA1151638_P_NODE_3937_length_269_cov_1.459184_g3870_i0 PRJNA1151638 3937 269 1.459184 3.92520496 Acinetobacter baumannii 470 Bacteria Bacteria 66.2 4.76e-12   NR WP_413541641.1 470 g3870 i0 44.6 0.825278810408922 74 36 81.4 2 11 229 10 79 WP_413541641.1 DHH family phosphoesterase, partial [Acinetobacter baumannii] diamond 222 66.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter baumannii
31766392 31766392 PRJNA1151638_P_NODE_2197_length_328_cov_1.686275_g2130_i0 PRJNA1151638 2197 328 1.686275 5.530982 Pseudomonadota 1224 Bacteria Bacteria 54.7 6.19e-6   NR WP_188656410.1 517720 g2130 i0 48.2 1.9390243902439 56 27 51.2 1 262 95 188 241 WP_188656410.1 replicative DNA helicase [Stakelama pacifica] diamond 636 55.1 0.992740471869329 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Stakelama Stakelama pacifica
32000131 32000131 PRJNA1151638_P_NODE_6618_length_242_cov_1.846154_g6551_i0 PRJNA1151638 6618 242 1.846154 4.46769268 Raoultella terrigena 577 Bacteria Bacteria 50.4 1.55e-5   NR WP_159322780.1 577 g6551 i0 42.9 0.694214876033058 56 30 66.9 1 64 225 42 97 WP_159322780.1 hypothetical protein, partial [Raoultella terrigena] diamond 168 50.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Raoultella Raoultella terrigena
32063309 32063309 PRJNA1151638_P_NODE_3258_length_286_cov_1.464789_g3191_i0 PRJNA1151638 3258 286 1.464789 4.18929654 Acinetobacter sp. YH12 472 Bacteria Bacteria 131 1.57e-34   NR WP_180108340.1 2601077 g3191 i0 100 0.63986013986014 61 0 64 0 183 1 1 61 WP_180108340.1 hypothetical protein [Acinetobacter sp. YH12085] diamond 183 131 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter sp. YH12085
32095017 32095017 PRJNA1151638_P_NODE_7138_length_227_cov_2.025974_g7071_i0 PRJNA1151638 7138 227 2.025974 4.59896098 Stellaceae bacterium 2910174 Bacteria Bacteria 44.3 0.00173   NR HEV8028266.1 2910174 g7071 i0 42.3 0.687224669603524 52 30 68.7 0 34 189 4 55 HEV8028266.1 hypothetical protein [Stellaceae bacterium] diamond 156 44.3 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodospirillales Stellaceae   Stellaceae bacterium
32443381 32443381 PRJNA1151638_P_NODE_4819_length_253_cov_0.866667_g4752_i0 PRJNA1151638 4819 253 0.866667 2.19266751 Lichenihabitans psoromatis 2528642 Bacteria Bacteria 106 9.55e-25   NR WP_131113651.1 2528642 g4752 i0 69.6 0.818181818181818 69 21 81.8 0 3 209 372 440 WP_131113651.1 HlyD family efflux transporter periplasmic adaptor subunit [Lichenihabitans psoromatis] diamond 207 106 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Lichenihabitantaceae Lichenihabitans Lichenihabitans psoromatis
32789830 32789830 PRJNA1151638_P_NODE_5720_length_247_cov_1.385057_g5653_i0 PRJNA1151638 5720 247 1.385057 3.42109079 Comamonas thiooxydans 363952 Bacteria Bacteria 139 3.11e-36   NR WP_052951055.1 363952 g5653 i0 100 1.79757085020243 74 0 89.9 0 3 224 1064 1137 WP_052951055.1 host specificity factor TipJ family phage tail protein [Comamonas thiooxydans] diamond 444 139 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Comamonadaceae Comamonas Comamonas thiooxydans
32852990 32852990 PRJNA1151638_P_NODE_6340_length_244_cov_0.912281_g6273_i0 PRJNA1151638 6340 244 0.912281 2.22596564 Vogesella sp. AC12 2950550 Bacteria Bacteria 82.8 5.09e-17   NR WP_255908173.1 2950550 g6273 i0 68.5 0.663934426229508 54 17 66.4 0 1 162 182 235 WP_255908173.1 hypothetical protein [Vogesella sp. AC12] diamond 162 82.8 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Neisseriales Chromobacteriaceae Vogesella Vogesella sp. AC12

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;