RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "diamond", bioproject = "PRJNA657860" and tax_kingdom = "Pseudomonadati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Pseudomonadati · 23 ✖

tax_clade 1

bioproject 1

  • PRJNA657860 · 23 ✖

analysis 1

  • diamond · 23 ✖
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
1901608 1901608 PRJNA657860_P_NODE_1222_length_300_cov_1.733840_g1166_i0 PRJNA657860 1222 300 1.73384 5.20152 Thiobacillus sp. 924 Bacteria Bacteria 63.5 3.79e-10   NR MDZ7586086.1 924 g1166 i0 92.9 0.28 28 2 28 0 39 122 1 28 MDZ7586086.1 hypothetical protein [Thiobacillus sp.] diamond 84 63.5 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Nitrosomonadales Thiobacillaceae Thiobacillus Thiobacillus sp.
17203436 17203436 PRJNA657860_P_NODE_1734_length_239_cov_1.787129_g1678_i0 PRJNA657860 1734 239 1.787129 4.27123831 Thalassobium sp. 2030825 Bacteria Bacteria 118 1.97e-32   NR PHQ87882.1 2030825 g1678 i0 85.7 0.878661087866109 70 10 87.9 0 210 1 5 74 PHQ87882.1 MAG: hypothetical protein COB58_02490 [Thalassobium sp.] diamond 210 118 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodobacterales Paracoccaceae Thalassobium Thalassobium sp.
19012936 19012936 PRJNA657860_P_NODE_715_length_397_cov_1.325000_g659_i0 PRJNA657860 715 397 1.325 5.26025 Alphaproteobacteria bacterium 1913988 Bacteria Bacteria 245 6.430000000000001e-79   NR MDP3641388.1 1913988 g659 i0 94.7 0.997481108312343 132 7 99.7 0 1 396 133 264 MDP3641388.1 Hsp70 family protein [Alphaproteobacteria bacterium] diamond 396 245 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria       Alphaproteobacteria bacterium
24851711 24851711 PRJNA657860_P_NODE_380_length_581_cov_1.966912_g327_i0 PRJNA657860 380 581 1.966912 11.42775872 Hymenobacter sp. 15J16-1T3B 2886941 Bacteria Bacteria 192 1.0999999999999999e-58   NR WP_227765649.1 2886941 g327 i0 58.5 3.80034423407917 188 73 95 3 1 552 18 204 WP_227765649.1 NAD(P)H:quinone oxidoreductase [Hymenobacter sp. 15J16-1T3B] diamond 2208 192 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Hymenobacteraceae Hymenobacter Hymenobacter sp. 15J16-1T3B
26638102 26638102 PRJNA657860_P_NODE_1401_length_275_cov_1.432773_g1345_i0 PRJNA657860 1401 275 1.432773 3.94012575 Acidobacteriota bacterium 1978231 Bacteria Bacteria 59.3 7.94e-8   NR MBX3294083.1 1978231 g1345 i0 36.3 0.992727272727273 91 56 98.2 2 6 275 149 238 MBX3294083.1 hypothetical protein [Acidobacteriota bacterium] diamond 273 59.3 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
26764849 26764849 PRJNA657860_P_NODE_2881_length_175_cov_1.086957_g2825_i0 PRJNA657860 2881 175 1.086957 1.90217475 Polyangiaceae bacterium 2268199 Bacteria Bacteria 77.4 7.3e-15   NR HTQ08171.1 2268199 g2825 i0 62.1 1.98857142857143 58 22 99.4 0 174 1 131 188 HTQ08171.1 S53 family peptidase [Polyangiaceae bacterium] diamond 348 77.4 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae   Polyangiaceae bacterium
26796580 26796580 PRJNA657860_P_NODE_3321_length_162_cov_0.936000_g3265_i0 PRJNA657860 3321 162 0.936 1.51632 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 45.1 0.00185   NR HZN07533.1 2283092 g3265 i0 47.6 1.48148148148148 42 22 77.8 0 2 127 70 111 HZN07533.1 methyltransferase [Pyrinomonadaceae bacterium] diamond 240 45.1 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
26828353 26828353 PRJNA657860_P_NODE_3701_length_152_cov_1.686957_g3645_i0 PRJNA657860 3701 152 1.686957 2.56417464 Oceanobacter sp. 2030817 Bacteria Bacteria 52 5.81e-6   NR PHR97727.1 2030817 g3645 i0 44 0.986842105263158 50 28 98.7 0 1 150 671 720 PHR97727.1 MAG: hypothetical protein COA68_12255 [Oceanobacter sp.] diamond 150 52 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Oceanospirillales Oceanospirillaceae Oceanobacter Oceanobacter sp.
26954632 26954632 PRJNA657860_P_NODE_2142_length_207_cov_1.594118_g2086_i0 PRJNA657860 2142 207 1.594118 3.29982426 Chitiniphilus shinanonensis 553088 Bacteria Bacteria 89 3.46e-19   NR WP_040430830.1 553088 g2086 i0 74.5 1.6231884057971 55 14 79.7 0 193 29 261 315 WP_040430830.1 dihydroorotate oxidase [Chitiniphilus shinanonensis] diamond 336 89 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Neisseriales Chitinibacteraceae Chitiniphilus Chitiniphilus shinanonensis
28186557 28186557 PRJNA657860_P_NODE_1946_length_221_cov_1.489130_g1890_i0 PRJNA657860 1946 221 1.48913 3.2909773 Corallococcus caeni 3082388 Bacteria Bacteria 65.1 9.55e-11   NR WP_338278474.1 3082388 g1890 i0 60 2.57918552036199 50 20 67.9 0 155 6 2 51 WP_338278474.1 malonic semialdehyde reductase [Corallococcus caeni] diamond 570 65.1 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae Corallococcus Corallococcus caeni
28281311 28281311 PRJNA657860_P_NODE_2046_length_213_cov_1.426136_g1990_i0 PRJNA657860 2046 213 1.426136 3.03766968 Bacteroidota bacterium 1898104 Bacteria Bacteria 87.8 3.19e-18   NR MDP4216039.1 1898104 g1990 i0 63.2 1.91549295774648 68 25 95.8 0 208 5 193 260 MDP4216039.1 S53 family peptidase [Bacteroidota bacterium] diamond 408 87.8 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
28471090 28471090 PRJNA657860_P_NODE_186_length_880_cov_4.435350_g148_i0 PRJNA657860 186 880 4.43535 39.03108 Alphaproteobacteria bacterium 1913988 Bacteria Bacteria 285 7.39e-94   NR MDP3640845.1 1913988 g148 i0 71.1 0.6375 187 48 63.8 2 820 260 1 181 MDP3640845.1 LDL receptor domain-containing protein [Alphaproteobacteria bacterium] diamond 561 285 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria       Alphaproteobacteria bacterium
28912739 28912739 PRJNA657860_P_NODE_508_length_490_cov_1.796909_g444_i1 PRJNA657860 508 490 1.796909 8.8048541 Alphaproteobacteria bacterium 1913988 Bacteria Bacteria 121 5.51e-30   NR MDP3641266.1 1913988 g444 i1 88.2 0.416326530612245 68 8 41.6 0 488 285 201 268 MDP3641266.1 Hsp70 family protein [Alphaproteobacteria bacterium] diamond 204 121 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria       Alphaproteobacteria bacterium
29008020 29008020 PRJNA657860_P_NODE_2528_length_188_cov_1.264901_g2472_i0 PRJNA657860 2528 188 1.264901 2.37801388 Ottowia sp. 1898956 Bacteria Bacteria 41.6 0.0128   NR WP_298437077.1 1898956 g2472 i0 62.5 2.25 32 11 51.1 1 68 163 19 49 WP_298437077.1 hypothetical protein [Ottowia sp.] diamond 423 41.6 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Comamonadaceae Ottowia Ottowia sp.
29607224 29607224 PRJNA657860_P_NODE_2850_length_176_cov_1.107914_g2794_i0 PRJNA657860 2850 176 1.107914 1.94992864 Methylococcaceae bacterium 1933926 Bacteria Bacteria 65.5 7.8e-11   NR NJD07146.1 1933926 g2794 i0 60.7 0.954545454545455 56 18 95.5 1 8 175 58 109 NJD07146.1 SDR family NAD(P)-dependent oxidoreductase [Methylococcaceae bacterium] diamond 168 65.5 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Methylococcales Methylococcaceae   Methylococcaceae bacterium
30251737 30251737 PRJNA657860_P_NODE_1592_length_254_cov_1.520737_g1536_i0 PRJNA657860 1592 254 1.520737 3.86267198 Pseudomonadati 3379134 Bacteria Bacteria 62.4 2.91e-10   NR GAA9176272.1 210 g1536 i0 96.3 0.956692913385827 27 1 31.9 0 5 85 1 27 GAA9176272.1 hypothetical protein Kyoto193A_0470 [Helicobacter pylori] diamond 243 62.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30303002 30303002 PRJNA657860_P_NODE_2092_length_210_cov_1.323699_g2036_i0 PRJNA657860 2092 210 1.323699 2.7797679 Helicobacter pylori 210 Bacteria Bacteria 56.6 5.65e-9   NR GAA6859173.1 210 g2036 i0 100 0.685714285714286 24 0 34.3 0 2 73 16 39 GAA6859173.1 hypothetical protein Kyoto206A_0790 [Helicobacter pylori] diamond 144 56.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30303003 30303003 PRJNA657860_P_NODE_2832_length_176_cov_1.683453_g2776_i0 PRJNA657860 2832 176 1.683453 2.96287728 Escherichia coli 562 Bacteria Bacteria 77 1.16e-16   NR WP_347046854.1 562 g2776 i0 72.9 0.818181818181818 48 13 81.8 0 28 171 1 48 WP_347046854.1 hypothetical protein, partial [Escherichia coli] diamond 144 77 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
30618381 30618381 PRJNA657860_P_NODE_3093_length_168_cov_0.809160_g3037_i0 PRJNA657860 3093 168 0.80916 1.3593888 Comamonas denitrificans 117506 Bacteria Bacteria 66.2 3.39e-11   NR WP_207575710.1 117506 g3037 i0 100 0.517857142857143 29 0 51.8 0 167 81 85 113 WP_207575710.1 HEPN domain-containing protein [Comamonas denitrificans] diamond 87 66.2 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Comamonadaceae Comamonas Comamonas denitrificans
31926871 31926871 PRJNA657860_P_NODE_957_length_339_cov_2.549669_g901_i0 PRJNA657860 957 339 2.549669 8.64337791 Pseudomonadati 3379134 Bacteria Bacteria 139 5.999999999999998e-39   NR WP_044236814.1 51 g901 i0 60 5.87610619469027 110 44 97.3 0 1 330 45 154 WP_044236814.1 NAD(P)H:quinone oxidoreductase [Chondromyces apiculatus] diamond 1992 140 0.992857142857143 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae Chondromyces Chondromyces apiculatus
32009645 32009645 PRJNA657860_P_NODE_3598_length_155_cov_1.211864_g3542_i0 PRJNA657860 3598 155 1.211864 1.8783892 Escherichia coli 562 Bacteria Bacteria 40 0.0218   NR MBK1745514.1 562 g3542 i0 80 0.387096774193548 20 4 38.7 0 86 145 1 20 MBK1745514.1 hypothetical protein [Escherichia coli] diamond 60 40 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
32516113 32516113 PRJNA657860_P_NODE_499_length_495_cov_1.838428_g444_i0 PRJNA657860 499 495 1.838428 9.1002186 Alphaproteobacteria bacterium 1913988 Bacteria Bacteria 121 5.9000000000000005e-30   NR MDP3641266.1 1913988 g444 i0 88.2 0.412121212121212 68 8 41.2 0 493 290 201 268 MDP3641266.1 Hsp70 family protein [Alphaproteobacteria bacterium] diamond 204 121 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria       Alphaproteobacteria bacterium
32641776 32641776 PRJNA657860_P_NODE_2540_length_188_cov_0.986755_g2484_i0 PRJNA657860 2540 188 0.986755 1.8550994 Aequorivita sp. 1872390 Bacteria Bacteria 123 2.48e-33   NR PHR11930.1 1872390 g2484 i0 95.2 1.97872340425532 62 3 98.9 0 186 1 80 141 PHR11930.1 MAG: hypothetical protein COA40_09190, partial [Aequorivita sp.] diamond 372 123 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Aequorivita Aequorivita sp.

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