RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

28 rows where analysis = "diamond", bioproject = "PRJNA1012699" and tax_kingdom = "Pseudomonadati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_clade 2

tax_superkingdom 1

tax_kingdom 1

  • Pseudomonadati · 28 ✖

bioproject 1

  • PRJNA1012699 · 28 ✖

analysis 1

  • diamond · 28 ✖
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
12911613 12911613 PRJNA1012699_P_NODE_1951_length_282_cov_1.842105_g1919_i0 PRJNA1012699 1951 282 1.842105 5.1947361 Flavobacteriaceae bacterium 1871037 Bacteria Bacteria 114 2.6e-29   NR MDP2061423.1 1871037 g1919 i0 65.6 2.03191489361702 96 30 98.9 1 280 2 97 192 MDP2061423.1 30S ribosomal protein S8e [Flavobacteriaceae bacterium] diamond 573 114 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae   Flavobacteriaceae bacterium
13755848 13755848 PRJNA1012699_P_NODE_3751_length_244_cov_0.912281_g3719_i0 PRJNA1012699 3751 244 0.912281 2.22596564 Hyphomicrobiales 356 Bacteria Bacteria 117 1.25e-30   NR WP_209856484.1 508661 g3719 i0 79.1 14.0040983606557 67 14 82.4 0 241 41 148 214 WP_209856484.1 ThuA domain-containing protein [Rhizobium herbae] diamond 3417 118 0.991525423728814 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Rhizobiaceae Rhizobium Rhizobium herbae
14186657 14186657 PRJNA1012699_P_NODE_3952_length_242_cov_0.923077_g3920_i0 PRJNA1012699 3952 242 0.923077 2.23384634 Mesorhizobium sp. 1871066 Bacteria Bacteria 148 4.5e-40   NR HEY5818483.1 1871066 g3920 i0 87.5 3.96694214876033 80 10 99.2 0 2 241 319 398 HEY5818483.1 ribonuclease J [Mesorhizobium sp.] diamond 960 148 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Phyllobacteriaceae Mesorhizobium Mesorhizobium sp.
21834850 21834850 PRJNA1012699_P_NODE_2438_length_260_cov_1.352941_g2406_i0 PRJNA1012699 2438 260 1.352941 3.5176466 Sphingomonas sp. 28214 Bacteria Bacteria 151 1.8e-43   NR HVJ02003.1 28214 g2406 i0 91.8 0.980769230769231 85 7 98.1 0 257 3 135 219 HVJ02003.1 50S ribosomal protein L11 methyltransferase [Sphingomonas sp.] diamond 255 151 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas Sphingomonas sp.
26654722 26654722 PRJNA1012699_P_NODE_2921_length_251_cov_0.876404_g2889_i0 PRJNA1012699 2921 251 0.876404 2.19977404 uncultured Aquincola sp. 886556 Bacteria Bacteria 155 2.9999999999999996e-42   NR WP_348752303.1 886556 g2889 i0 97.4 0.908366533864542 76 2 90.8 0 3 230 155 230 WP_348752303.1 DUF885 domain-containing protein [uncultured Aquincola sp.] diamond 228 155 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Sphaerotilaceae Aquincola uncultured Aquincola sp.
27192763 27192763 PRJNA1012699_P_NODE_3562_length_245_cov_0.906977_g3530_i0 PRJNA1012699 3562 245 0.906977 2.22209365 Ottowia sp. 1898956 Bacteria Bacteria 45.4 0.00354   NR WP_324555415.1 1898956 g3530 i0 100 0.257142857142857 21 0 25.7 0 182 244 1 21 WP_324555415.1 Crp/Fnr family transcriptional regulator [Ottowia sp.] diamond 63 45.4 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Comamonadaceae Ottowia Ottowia sp.
27351208 27351208 PRJNA1012699_P_NODE_2283_length_267_cov_1.319588_g2251_i0 PRJNA1012699 2283 267 1.319588 3.52329996 Oryzisolibacter propanilivorax 1527607 Bacteria Bacteria 42.7 0.0408   NR WP_091572549.1 1527607 g2251 i0 37.9 0.741573033707865 66 40 74.2 1 239 42 155 219 WP_091572549.1 sulfite oxidase heme-binding subunit YedZ [Oryzisolibacter propanilivorax] diamond 198 42.7 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Comamonadaceae Oryzisolibacter Oryzisolibacter propanilivorax
27603779 27603779 PRJNA1012699_P_NODE_2304_length_266_cov_1.248705_g2272_i0 PRJNA1012699 2304 266 1.248705 3.3215553 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 53.9 5.51e-6   NR MEZ5345544.1 2283092 g2272 i0 36.4 0.744360902255639 66 42 74.4 0 262 65 310 375 MEZ5345544.1 tetratricopeptide repeat protein [Pyrinomonadaceae bacterium] diamond 198 53.9 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
28100840 28100840 PRJNA1012699_P_NODE_2605_length_254_cov_1.430939_g2573_i0 PRJNA1012699 2605 254 1.430939 3.63458506 Bacteria 2 Bacteria Bacteria 73.6 5.89e-13   NR WP_307269524.1 425677 g2573 i0 47.5 2.7992125984252 80 39 94.5 1 11 250 390 466 WP_307269524.1 GMC family oxidoreductase [Labrys wisconsinensis] diamond 711 74.3 0.990578734858681 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Xanthobacteraceae Labrys Labrys wisconsinensis
28677187 28677187 PRJNA1012699_P_NODE_507_length_486_cov_1.283293_g475_i0 PRJNA1012699 507 486 1.283293 6.23680398 Phycisphaerae bacterium 2026778 Bacteria Bacteria 46.2 0.02   NR MFQ5807405.1 2026778 g475 i0 29.4 0.672839506172839 109 46 54.9 5 163 429 188 285 MFQ5807405.1 type II secretion system protein [Phycisphaerae bacterium] diamond 327 46.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
29403301 29403301 PRJNA1012699_P_NODE_2829_length_252_cov_0.871508_g2797_i0 PRJNA1012699 2829 252 0.871508 2.19620016 Sphingomonas lenta 1141887 Bacteria Bacteria 114 5.41e-30   NR WP_095997424.1 1141887 g2797 i0 91.4 0.69047619047619 58 5 69 0 79 252 1 58 WP_095997424.1 hypothetical protein [Sphingomonas lenta] diamond 174 114 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas Sphingomonas lenta
29434536 29434536 PRJNA1012699_P_NODE_2010_length_279_cov_2.480583_g1978_i0 PRJNA1012699 2010 279 2.480583 6.92082657 Phycisphaerales bacterium 2052180 Bacteria Bacteria 53.1 1.27e-5   NR NLX12618.1 2052180 g1978 i0 64.7 0.365591397849462 34 12 36.6 0 223 122 1069 1102 NLX12618.1 fibronectin type III domain-containing protein [Phycisphaerales bacterium] diamond 102 53.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
29877030 29877030 PRJNA1012699_P_NODE_3471_length_246_cov_0.901734_g3439_i0 PRJNA1012699 3471 246 0.901734 2.21826564 Planctomycetota bacterium 2026780 Bacteria Bacteria 52.4 1.01e-5   NR MBL4845093.1 2026780 g3439 i0 36.4 0.939024390243902 77 42 93.9 1 240 10 76 145 MBL4845093.1 PQQ-like beta-propeller repeat protein [Planctomycetota bacterium] diamond 231 52.4 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30129326 30129326 PRJNA1012699_P_NODE_1652_length_297_cov_0.785714_g1620_i0 PRJNA1012699 1652 297 0.785714 2.33357058 Siccirubricoccus sp. G192 2849651 Bacteria Bacteria 44.7 0.0147   NR WP_217382184.1 2849651 g1620 i0 35.1 0.777777777777778 77 45 75.8 3 7 231 414 487 WP_217382184.1 hypothetical protein [Siccirubricoccus sp. G192] diamond 231 44.7 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Acetobacterales Roseomonadaceae Siccirubricoccus Siccirubricoccus sp. G192
30256385 30256385 PRJNA1012699_P_NODE_2412_length_261_cov_1.787234_g2380_i0 PRJNA1012699 2412 261 1.787234 4.66468074 Klebsiella pneumoniae 573 Bacteria Bacteria 50.8 6.68e-6   NR WP_216850647.1 573 g2380 i0 95.8 0.574712643678161 24 1 27.6 0 254 183 1 24 WP_216850647.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 150 50.8 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
30311976 30311976 PRJNA1012699_P_NODE_3572_length_245_cov_0.906977_g3540_i0 PRJNA1012699 3572 245 0.906977 2.22209365 Alcaligenaceae 506 Bacteria Bacteria 74.7 2.07e-13   NR WP_132581287.1 627131 g3540 i0 53.1 1.99591836734694 81 38 99.2 0 243 1 75 155 WP_132581287.1 polysaccharide biosynthesis protein [Paralcaligenes ureilyticus] diamond 489 75.1 0.994673768308922 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Alcaligenaceae Paralcaligenes Paralcaligenes ureilyticus
30666752 30666752 PRJNA1012699_P_NODE_3373_length_247_cov_0.896552_g3341_i0 PRJNA1012699 3373 247 0.896552 2.21448344 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 54.3 3.17e-6   NR MDZ7778902.1 2026742 g3341 i0 57.5 3.32793522267206 40 17 48.6 0 245 126 514 553 MDZ7778902.1 ankyrin repeat domain-containing protein [Gemmatimonadota bacterium] diamond 822 54.3 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
30793066 30793066 PRJNA1012699_P_NODE_2314_length_265_cov_1.625000_g2282_i0 PRJNA1012699 2314 265 1.625 4.30625 Sphingomicrobium sp. 1940456 Bacteria Bacteria 99.4 1.11e-24   NR MFL6763848.1 1940456 g2282 i0 66.7 0.849056603773585 75 25 84.9 0 262 38 38 112 MFL6763848.1 hypothetical protein [Sphingomicrobium sp.] diamond 225 99.4 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomicrobium Sphingomicrobium sp.
30824706 30824706 PRJNA1012699_P_NODE_3074_length_249_cov_1.454545_g3042_i0 PRJNA1012699 3074 249 1.454545 3.62181705 Sphingobium sp. 1912891 Bacteria Bacteria 70.1 1.44e-12   NR MDX3899694.1 1912891 g3042 i0 59 0.734939759036145 61 23 73.5 1 31 213 132 190 MDX3899694.1 IS6 family transposase [Sphingobium sp.] diamond 183 70.1 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingobium Sphingobium sp.
31006557 31006557 PRJNA1012699_P_NODE_2914_length_251_cov_0.876404_g2882_i0 PRJNA1012699 2914 251 0.876404 2.19977404 Bosea 85413 Bacteria Bacteria 160 4.91e-47   NR WP_210169321.1 1736524 g2882 i0 92.8 1.9840637450199201 83 6 99.2 0 3 251 84 166 WP_210169321.1 hypothetical protein [Bosea sp. Root381] diamond 498 160 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Boseaceae Bosea Bosea sp. Root381
31615067 31615067 PRJNA1012699_P_NODE_3496_length_246_cov_0.901734_g3464_i0 PRJNA1012699 3496 246 0.901734 2.21826564 Paracoccus marinus 288426 Bacteria Bacteria 150 1.7599999999999999e-43   NR WP_131672749.1 288426 g3464 i0 100 0.939024390243902 77 0 93.9 0 232 2 1 77 WP_131672749.1 MipA/OmpV family protein [Paracoccus marinus] diamond 231 150 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodobacterales Paracoccaceae Paracoccus Paracoccus marinus
31773149 31773149 PRJNA1012699_P_NODE_457_length_507_cov_1.260369_g425_i0 PRJNA1012699 457 507 1.260369 6.39007083 Chitinophaga pollutisoli 3133966 Bacteria Bacteria 48.1 0.00695   NR WP_341836319.1 3133966 g425 i0 32.7 0.869822485207101 147 91 86.4 4 27 464 1625 1764 WP_341836319.1 PKD domain-containing protein [Chitinophaga pollutisoli] diamond 441 48.1 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae Chitinophaga Chitinophaga pollutisoli
32152918 32152918 PRJNA1012699_P_NODE_1138_length_347_cov_2.197080_g1106_i0 PRJNA1012699 1138 347 2.19708 7.6238676 Myxococcota bacterium 2818507 Bacteria Bacteria 45.4 0.013   NR MEW5855216.1 2818507 g1106 i0 31.3 2.01440922190202 96 46 74.4 4 334 77 2 87 MEW5855216.1 SCE4755 family polysaccharide monooxygenase-like protein [Myxococcota bacterium] diamond 699 45.4 1 Bacteria   Pseudomonadati Myxococcota         Myxococcota bacterium
32279669 32279669 PRJNA1012699_P_NODE_3039_length_250_cov_0.881356_g3007_i0 PRJNA1012699 3039 250 0.881356 2.20339 Paracoccus aeridis 1966466 Bacteria Bacteria 145 7.409999999999999e-40   NR WP_136650616.1 1966466 g3007 i0 89.2 0.996 83 9 99.6 0 250 2 22 104 WP_136650616.1 UbiH/UbiF family hydroxylase [Paracoccus aeridis] diamond 249 145 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodobacterales Paracoccaceae Paracoccus Paracoccus aeridis
32406104 32406104 PRJNA1012699_P_NODE_2779_length_252_cov_0.871508_g2747_i0 PRJNA1012699 2779 252 0.871508 2.19620016 Thalassoroseus pseudoceratinae 2713176 Bacteria Bacteria 78.2 1.46e-14   NR WP_166819670.1 2713176 g2747 i0 50.6 0.988095238095238 83 40 98.8 1 4 252 281 362 WP_166819670.1 MG2 domain-containing protein [Thalassoroseus pseudoceratinae] diamond 249 78.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Thalassoroseus Thalassoroseus pseudoceratinae
32406105 32406105 PRJNA1012699_P_NODE_3839_length_243_cov_0.917647_g3807_i0 PRJNA1012699 3839 243 0.917647 2.22988221 Paracoccus marinus 288426 Bacteria Bacteria 65.1 1.88e-11   NR WP_131672743.1 288426 g3807 i0 100 0.382716049382716 31 0 38.3 0 151 243 1 31 WP_131672743.1 DUF1476 domain-containing protein [Paracoccus marinus] diamond 93 65.1 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodobacterales Paracoccaceae Paracoccus Paracoccus marinus
32437915 32437915 PRJNA1012699_P_NODE_2139_length_273_cov_3.095000_g2107_i0 PRJNA1012699 2139 273 3.095 8.44935 Salmonella sp. s55 599 Bacteria Bacteria 65.9 3.08e-11   NR WP_411025478.1 3159675 g2107 i0 40.4 2.06593406593407 94 49 95.6 1 2 262 23 116 WP_411025478.1 60S ribosomal protein L28, partial [Salmonella sp. s55004] diamond 564 65.9 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Salmonella Salmonella sp. s55004
32847552 32847552 PRJNA1012699_P_NODE_3840_length_243_cov_0.917647_g3808_i0 PRJNA1012699 3840 243 0.917647 2.22988221 Cardiobacterium hominis 2718 Bacteria Bacteria 136 1.51e-36   NR WP_040354392.1 2718 g3808 i0 89.3 0.925925925925926 75 8 92.6 0 17 241 1 75 WP_040354392.1 acetylornithine deacetylase [Cardiobacterium hominis] diamond 225 136 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Cardiobacteriales Cardiobacteriaceae Cardiobacterium Cardiobacterium hominis

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