RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

31 rows where analysis = "diamond", bioproject = "PRJNA1196384" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 31 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1196384 · 31 ✖

analysis 1

  • diamond · 31 ✖

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
322667 322667 PRJNA1196384_S_NODE_1_length_12927_cov_6.852366_g0_i0 PRJNA1196384 1 12927 6.852366 885.80535282 Gammaproteobacteria bacterium 1913989 Bacteria Bacteria 572 3.76e-178   NR NCB86281.1 1913989 g0 i0 51.9 0.281271756788118 563 262 12.9 5 2324 3994 1 560 NCB86281.1 terminase [Gammaproteobacteria bacterium] diamond 3636 572 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       Gammaproteobacteria bacterium
6700615 6700615 PRJNA1196384_S_NODE_6586_length_164_cov_0.921260_g6522_i0 PRJNA1196384 6586 164 0.92126 1.5108664 Aquabacterium sp. G14 3130164 Bacteria Bacteria 119 6.41e-30   NR WP_339582727.1 3130164 g6522 i0 100 0.98780487804878 54 0 98.8 0 3 164 60 113 WP_339582727.1 IS21 family transposase [Aquabacterium sp. G14] diamond 162 119 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales   Aquabacterium Aquabacterium sp. G14
7421058 7421058 PRJNA1196384_S_NODE_5126_length_180_cov_2.356643_g5062_i0 PRJNA1196384 5126 180 2.356643 4.2419574 root 1 Root_unresolved Root_unresolved 111 3.06e-29   NR WP_140424235.1 562 g5062 i0 86.4 3.93333333333333 59 8 98.3 0 178 2 98 156 WP_140424235.1 ADP-ribosylation factor-like protein, partial [Escherichia coli] diamond 708 111 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
18174264 18174264 PRJNA1196384_S_NODE_115_length_930_cov_5.592385_g84_i0 PRJNA1196384 115 930 5.592385 52.0091805 Alphaproteobacteria 28211 Bacteria Bacteria 447 8.039999999999998e-153   NR WP_101249876.1 382514 g84 i0 73.7 174.993548387097 308 80 99.4 1 929 6 148 454 WP_101249876.1 F0F1 ATP synthase subunit alpha [Telmatospirillum siberiense] diamond 162744 449 0.99554565701559 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodospirillales Rhodospirillaceae Telmatospirillum Telmatospirillum siberiense
18174292 18174292 PRJNA1196384_S_NODE_3375_length_213_cov_2.863636_g3311_i0 PRJNA1196384 3375 213 2.863636 6.09954468 root 1 Root_unresolved Root_unresolved 119 5.49e-33   NR WP_353802580.1 470 g3311 i0 82.4 34.5774647887324 68 12 95.8 0 205 2 1 68 WP_353802580.1 uL14 family ribosomal protein, partial [Acinetobacter baumannii] diamond 7365 120 0.991666666666667 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter baumannii
26660652 26660652 PRJNA1196384_S_NODE_7901_length_154_cov_0.982906_g7837_i0 PRJNA1196384 7901 154 0.982906 1.51367524 Amaricoccus macauensis 57001 Bacteria Bacteria 95.5 2.7e-21   NR WP_184154975.1 57001 g7837 i0 91.7 0.935064935064935 48 4 93.5 0 154 11 468 515 WP_184154975.1 FAD-dependent oxidoreductase [Amaricoccus macauensis] diamond 144 95.5 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodobacterales Paracoccaceae Amaricoccus Amaricoccus macauensis
26787768 26787768 PRJNA1196384_S_NODE_5661_length_173_cov_2.573529_g5597_i0 PRJNA1196384 5661 173 2.573529 4.45220517 Bowmanella dokdonensis 751969 Bacteria Bacteria 42.7 0.0147   NR WP_206573398.1 751969 g5597 i0 42.9 2.15028901734104 42 24 72.8 0 171 46 58 99 WP_206573398.1 C39 family peptidase [Bowmanella dokdonensis] diamond 372 42.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Alteromonadales Alteromonadaceae Bowmanella Bowmanella dokdonensis
27009053 27009053 PRJNA1196384_S_NODE_3562_length_208_cov_2.485380_g3498_i0 PRJNA1196384 3562 208 2.48538 5.1695904 Aestuariispira insulae 1461337 Bacteria Bacteria 120 5.95e-33   NR WP_115937859.1 1461337 g3498 i0 79.7 7.875 69 14 99.5 0 1 207 42 110 WP_115937859.1 rubrerythrin family protein [Aestuariispira insulae] diamond 1638 120 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodospirillales Kiloniellaceae Aestuariispira Aestuariispira insulae
27072412 27072412 PRJNA1196384_S_NODE_6162_length_168_cov_1.114504_g6098_i0 PRJNA1196384 6162 168 1.114504 1.87236672 unclassified Seohaeicola 2641111 Bacteria Bacteria 49.3 1.32e-5   NR WP_274561007.1 2641111 g6098 i0 63.6 0.589285714285714 33 12 58.9 0 69 167 67 99 WP_274561007.1 MULTISPECIES: hypothetical protein [unclassified Seohaeicola] diamond 99 49.3 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodobacterales Roseobacteraceae Seohaeicola  
27103909 27103909 PRJNA1196384_S_NODE_4962_length_182_cov_2.158621_g4898_i0 PRJNA1196384 4962 182 2.158621 3.92869022 uncultured Brevundimonas sp. 213418 Bacteria Bacteria 91.7 3.89e-21   NR WP_297933130.1 213418 g4898 i0 85 0.989010989010989 60 9 98.9 0 1 180 133 192 WP_297933130.1 helix-turn-helix domain-containing protein, partial [uncultured Brevundimonas sp.] diamond 180 91.7 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Caulobacterales Caulobacteraceae Brevundimonas uncultured Brevundimonas sp.
27514842 27514842 PRJNA1196384_S_NODE_763_length_437_cov_3.465000_g699_i0 PRJNA1196384 763 437 3.465 15.14205 Gammaproteobacteria bacterium 1913989 Bacteria Bacteria 77.8 5.15e-15   NR NCB86282.1 1913989 g699 i0 39 0.720823798627002 105 62 72.1 1 318 4 1 103 NCB86282.1 hypothetical protein [Gammaproteobacteria bacterium] diamond 315 77.8 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       Gammaproteobacteria bacterium
27628720 27628720 PRJNA1196384_S_NODE_144_length_866_cov_3.731001_g106_i0 PRJNA1196384 144 866 3.731001 32.31046866 Pseudomonadota 1224 Bacteria Bacteria 87.4 4.79e-16   NR WP_158229526.1 1236 g106 i0 35.8 1.96420323325635 165 95 57.2 3 15 509 105 258 WP_158229526.1 MULTISPECIES: replication initiation protein [Gammaproteobacteria] diamond 1701 87.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria        
27799171 27799171 PRJNA1196384_S_NODE_6924_length_161_cov_1.225806_g6860_i0 PRJNA1196384 6924 161 1.225806 1.97354766 Bowmanella dokdonensis 751969 Bacteria Bacteria 61.2 3.61e-9   NR WP_206573398.1 751969 g6860 i0 51 0.950310559006211 51 25 95 0 155 3 21 71 WP_206573398.1 C39 family peptidase [Bowmanella dokdonensis] diamond 153 61.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Alteromonadales Alteromonadaceae Bowmanella Bowmanella dokdonensis
28259804 28259804 PRJNA1196384_S_NODE_426_length_564_cov_3.442125_g366_i0 PRJNA1196384 426 564 3.442125 19.413585 root 1 Root_unresolved Root_unresolved 177 9.95e-51   NR MBL4763129.1 1913989 g366 i0 54.2 3.03723404255319 142 62 75.5 1 3 428 230 368 MBL4763129.1 multicopper oxidase domain-containing protein [Gammaproteobacteria bacterium] diamond 1713 177 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       Gammaproteobacteria bacterium
28556926 28556926 PRJNA1196384_S_NODE_227_length_725_cov_3.873547_g179_i0 PRJNA1196384 227 725 3.873547 28.08321575 Pseudoalteromonas sp. PA2MD11 2785057 Bacteria Bacteria 117 4.62e-26   NR WP_209328609.1 2785057 g179 i0 31.7 1.5848275862069 221 114 85.7 5 640 20 23 220 WP_209328609.1 C39 family peptidase [Pseudoalteromonas sp. PA2MD11] diamond 1149 117 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Alteromonadales Pseudoalteromonadaceae Pseudoalteromonas Pseudoalteromonas sp. PA2MD11
28796553 28796553 PRJNA1196384_S_NODE_6587_length_164_cov_0.913386_g6523_i0 PRJNA1196384 6587 164 0.913386 1.49795304 Bacteria 2 Bacteria Bacteria 79.3 9.34e-16   NR WP_043766354.1 382454 g6523 i0 75.9 4.9390243902439 54 12 98.8 1 1 162 48 100 WP_043766354.1 class I fructose-bisphosphate aldolase [Algiphilus aromaticivorans] diamond 810 79.3 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Nevskiales Algiphilaceae Algiphilus Algiphilus aromaticivorans
29112592 29112592 PRJNA1196384_S_NODE_7568_length_156_cov_1.294118_g7504_i0 PRJNA1196384 7568 156 1.294118 2.01882408 Neisseria 482 Bacteria Bacteria 73.2 1.7e-13   NR WP_030002114.1 489 g7504 i0 70.8 6.48076923076923 48 14 92.3 0 146 3 170 217 WP_030002114.1 replication initiation protein RepM [Neisseria polysaccharea] diamond 1011 73.2 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Neisseriales Neisseriaceae Neisseria Neisseria polysaccharea
29333510 29333510 PRJNA1196384_S_NODE_7129_length_159_cov_1.590164_g7065_i0 PRJNA1196384 7129 159 1.590164 2.52836076 Pseudomonadati 3379134 Bacteria Bacteria 75.9 2.63e-15   NR HWP00483.1 39769 g7065 i0 63.5 4.83018867924528 52 19 98.1 0 157 2 45 96 HWP00483.1 Fe-Mn family superoxide dismutase [Methylococcus sp.] diamond 768 76.6 0.990861618798956 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Methylococcales Methylococcaceae Methylococcus Methylococcus sp.
29585795 29585795 PRJNA1196384_S_NODE_1150_length_360_cov_6.498452_g1086_i0 PRJNA1196384 1150 360 6.498452 23.3944272 Pseudomonadati 3379134 Bacteria Bacteria 103 3.7e-23   NR MEL0107590.1 1898112 g1086 i0 50 6.975 120 57 100 3 360 1 33 149 MEL0107590.1 F0F1 ATP synthase subunit alpha [Rhodospirillaceae bacterium] diamond 2511 103 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodospirillales Rhodospirillaceae   Rhodospirillaceae bacterium
29598408 29598408 PRJNA1196384_S_NODE_8370_length_151_cov_1.017544_g8306_i0 PRJNA1196384 8370 151 1.017544 1.53649144 Paracoccus chinensis 525640 Bacteria Bacteria 99 1.61e-22   NR WP_090755287.1 525640 g8306 i0 100 0.973509933774834 49 0 97.4 0 149 3 884 932 WP_090755287.1 methionine synthase [Paracoccus chinensis] diamond 147 99 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodobacterales Paracoccaceae Paracoccus Paracoccus chinensis
29965113 29965113 PRJNA1196384_S_NODE_7711_length_155_cov_1.313559_g7647_i0 PRJNA1196384 7711 155 1.313559 2.03601645 Gammaproteobacteria 1236 Bacteria Bacteria 106 4.62e-27   NR ECB2966022.1 28147 g7647 i0 100 1.9741935483871 51 0 98.7 0 2 154 113 163 ECB2966022.1 RepB family plasmid replication initiator protein [Salmonella enterica subsp. enterica serovar Oranienburg] diamond 306 106 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Salmonella Salmonella enterica
30009438 30009438 PRJNA1196384_S_NODE_3471_length_211_cov_1.557471_g3407_i0 PRJNA1196384 3471 211 1.557471 3.28626381 Acinetobacter baumannii 470 Bacteria Bacteria 132 3.169999999999999e-38   NR MDA5862620.1 470 g3407 i0 100 0.938388625592417 66 0 93.8 0 200 3 1 66 MDA5862620.1 GNAT family N-acetyltransferase [Acinetobacter baumannii] diamond 198 132 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter baumannii
30281425 30281425 PRJNA1196384_S_NODE_4452_length_190_cov_1.241830_g4388_i0 PRJNA1196384 4452 190 1.24183 2.359477 root 1 Root_unresolved Root_unresolved 89.7 4.41e-19   NR WP_092787086.1 69960 g4388 i0 71.4 2.98421052631579 63 18 99.5 0 190 2 333 395 WP_092787086.1 pyruvate dehydrogenase complex E1 component subunit beta [Rhodospira trueperi] diamond 567 90.5 0.991160220994475 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodospirillales Rhodospirillaceae Rhodospira Rhodospira trueperi
30357344 30357344 PRJNA1196384_S_NODE_4512_length_189_cov_1.243421_g4448_i0 PRJNA1196384 4512 189 1.243421 2.35006569 Alphaproteobacteria bacterium 1913988 Bacteria Bacteria 48.9 6.2e-5   NR GHU13458.1 1913988 g4448 i0 48.9 1.98412698412698 45 19 65.1 2 189 67 87 131 GHU13458.1 hypothetical protein FACS189449_08840 [Alphaproteobacteria bacterium] diamond 375 48.9 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria       Alphaproteobacteria bacterium
30388832 30388832 PRJNA1196384_S_NODE_2613_length_240_cov_1.876847_g2549_i0 PRJNA1196384 2613 240 1.876847 4.5044328 Pectobacterium brasiliense 180957 Bacteria Bacteria 149 1.98e-44   NR WP_072061699.1 180957 g2549 i0 92.4 0.9875 79 6 98.8 0 239 3 7 85 WP_072061699.1 nucleoside-diphosphate kinase [Pectobacterium brasiliense] diamond 237 149 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Pectobacteriaceae Pectobacterium Pectobacterium brasiliense
30565007 30565007 PRJNA1196384_S_NODE_2953_length_226_cov_2.354497_g2889_i0 PRJNA1196384 2953 226 2.354497 5.32116322 Pseudomonadati 3379134 Bacteria Bacteria 100 1.5299999999999999e-24   NR MDE2090994.1 1913989 g2889 i0 62.2 5.88053097345133 74 27 98.2 1 226 5 30 102 MDE2090994.1 multicopper oxidase domain-containing protein [Gammaproteobacteria bacterium] diamond 1329 100 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       Gammaproteobacteria bacterium
30862312 30862312 PRJNA1196384_S_NODE_8334_length_151_cov_1.350877_g8270_i0 PRJNA1196384 8334 151 1.350877 2.03982427 Paracoccus salipaludis 2032623 Bacteria Bacteria 47.8 5.66e-5   NR WP_095641473.1 2032623 g8270 i0 100 0.47682119205298 24 0 47.7 0 150 79 108 131 WP_095641473.1 hypothetical protein [Paracoccus salipaludis] diamond 72 47.8 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodobacterales Paracoccaceae Paracoccus Paracoccus salipaludis
31241389 31241389 PRJNA1196384_S_NODE_1275_length_342_cov_4.118033_g1211_i0 PRJNA1196384 1275 342 4.118033 14.08367286 Shigella sonnei 624 Bacteria Bacteria 163 8.69e-50   NR WP_353763784.1 624 g1211 i0 96.3 1.40350877192982 80 3 70.2 0 340 101 29 108 WP_353763784.1 hypothetical protein, partial [Shigella sonnei] diamond 480 163 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Shigella Shigella sonnei
31589644 31589644 PRJNA1196384_S_NODE_5436_length_176_cov_1.517986_g5372_i0 PRJNA1196384 5436 176 1.517986 2.67165536 Pseudomonas aeruginosa 287 Bacteria Bacteria 120 2.48e-33   NR WP_367005107.1 287 g5372 i0 96.6 1.97727272727273 58 2 98.9 0 175 2 42 99 WP_367005107.1 hypothetical protein, partial [Pseudomonas aeruginosa] diamond 348 120 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas aeruginosa
32443946 32443946 PRJNA1196384_S_NODE_1279_length_342_cov_1.481967_g1215_i0 PRJNA1196384 1279 342 1.481967 5.06832714 Alphaproteobacteria bacterium 17-39-52 1970491 Bacteria Bacteria 132 2.8399999999999997e-37   NR OZA43274.1 1970491 g1215 i0 70.5 0.684210526315789 78 22 68.4 1 340 107 50 126 OZA43274.1 MAG: hypothetical protein B7X84_03595 [Alphaproteobacteria bacterium 17-39-52] diamond 234 132 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria       Alphaproteobacteria bacterium 17-39-52
32664476 32664476 PRJNA1196384_S_NODE_6040_length_169_cov_1.287879_g5976_i0 PRJNA1196384 6040 169 1.287879 2.17651551 Salmonella enterica 28901 Bacteria Bacteria 75.1 3.06e-16   NR WP_415368838.1 28901 g5976 i0 87.8 1.38461538461538 41 5 72.8 0 45 167 3 43 WP_415368838.1 hypothetical protein, partial [Salmonella enterica] diamond 234 75.1 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Salmonella Salmonella enterica

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