RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "diamond", bioproject = "PRJNA1012699" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 19 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1012699 · 19 ✖

analysis 1

  • diamond · 19 ✖

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