RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "diamond", bioproject = "PRJNA851399" and tax_clade = "PVC group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

tax_clade 1

  • PVC group · 19 ✖

bioproject 1

  • PRJNA851399 · 19 ✖

analysis 1

  • diamond · 19 ✖
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
12713558 12713558 PRJNA851399_P_NODE_31970_length_164_cov_1.773913_g31517_i0 PRJNA851399 31970 164 1.773913 2.90921732 Phycisphaerae bacterium 2026778 Bacteria Bacteria 91.7 7.43e-20   NR HVP10452.1 2026778 g31517 i0 83.3 1.97560975609756 54 9 98.8 0 162 1 361 414 HVP10452.1 Hsp70 family protein [Phycisphaerae bacterium] diamond 324 91.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
26833562 26833562 PRJNA851399_P_NODE_35221_length_163_cov_0.894737_g34768_i0 PRJNA851399 35221 163 0.894737 1.45842131 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 57 1.18e-7   NR MBS0631760.1 2026799 g34768 i0 52.8 0.975460122699387 53 25 97.5 0 159 1 718 770 MBS0631760.1 M48 family metalloprotease [Verrucomicrobiota bacterium] diamond 159 57 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
27086670 27086670 PRJNA851399_P_NODE_17462_length_184_cov_1.511111_g17009_i0 PRJNA851399 17462 184 1.511111 2.78044424 Lacunisphaera sp. 1961806 Bacteria Bacteria 117 5.22e-29   NR MDI1334970.1 1961806 g17009 i0 93.3 0.978260869565217 60 4 97.8 0 182 3 408 467 MDI1334970.1 penicillin-binding protein 2 [Lacunisphaera sp.] diamond 180 117 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae Lacunisphaera Lacunisphaera sp.
28002762 28002762 PRJNA851399_P_NODE_41365_length_161_cov_0.910714_g40912_i0 PRJNA851399 41365 161 0.910714 1.46624954 Verrucomicrobiales bacterium 2026801 Bacteria Bacteria 42 0.0229   NR MDB6024811.1 2026801 g40912 i0 43.4 1.86335403726708 53 23 98.8 1 2 160 7 52 MDB6024811.1 Binding-protein-dependent transport system inner rane component [Verrucomicrobiales bacterium] diamond 300 42 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales     Verrucomicrobiales bacterium
28128977 28128977 PRJNA851399_P_NODE_35045_length_163_cov_0.894737_g34592_i0 PRJNA851399 35045 163 0.894737 1.45842131 Planctomycetia bacterium 2052181 Bacteria Bacteria 98.2 5.069999999999999e-23   NR MCI0700753.1 2052181 g34592 i0 82.7 2.88957055214724 52 9 95.7 0 162 7 25 76 MCI0700753.1 alpha/beta hydrolase [Planctomycetia bacterium] diamond 471 98.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia       Planctomycetia bacterium
28286494 28286494 PRJNA851399_P_NODE_18586_length_181_cov_1.545455_g18133_i0 PRJNA851399 18586 181 1.545455 2.79727355 Terrimicrobiaceae bacterium 2832348 Bacteria Bacteria 88.2 1.38e-19   NR HEY5704678.1 2832348 g18133 i0 86.4 0.729281767955801 44 6 72.9 0 178 47 190 233 HEY5704678.1 C4-type zinc ribbon domain-containing protein [Terrimicrobiaceae bacterium] diamond 132 88.2 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Terrimicrobiia Terrimicrobiales Terrimicrobiaceae   Terrimicrobiaceae bacterium
29265315 29265315 PRJNA851399_P_NODE_30049_length_165_cov_0.879310_g29596_i0 PRJNA851399 30049 165 0.87931 1.4508615 Planctomycetota bacterium 2026780 Bacteria Bacteria 43.9 0.00499   NR MEM6755981.1 2026780 g29596 i0 60 0.636363636363636 35 14 63.6 0 59 163 20 54 MEM6755981.1 site-specific integrase [Planctomycetota bacterium] diamond 105 43.9 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
29580939 29580939 PRJNA851399_P_NODE_13890_length_202_cov_2.973856_g13437_i0 PRJNA851399 13890 202 2.973856 6.00718912 Singulisphaera sp. 1906241 Bacteria Bacteria 42.7 0.0213   NR MEJ7638550.1 1906241 g13437 i0 38.6 0.846534653465347 57 28 77.2 2 24 179 393 447 MEJ7638550.1 sodium:solute symporter family protein [Singulisphaera sp.] diamond 171 42.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae Singulisphaera Singulisphaera sp.
29842080 29842080 PRJNA851399_P_NODE_28111_length_166_cov_0.871795_g27658_i0 PRJNA851399 28111 166 0.871795 1.4471797 Bacteria 2 Bacteria Bacteria 70.1 1.38e-12   NR HPD28582.1 2026778 g27658 i0 70.5 5.6566265060241 44 13 79.5 0 164 33 227 270 HPD28582.1 hypothetical protein [Phycisphaerae bacterium] diamond 939 70.5 0.994326241134752 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
29842081 29842081 PRJNA851399_P_NODE_41811_length_159_cov_2.736364_g41358_i0 PRJNA851399 41811 159 2.736364 4.35081876 Lacipirellulaceae 2691359 Bacteria Bacteria 102 2.5299999999999998e-24   NR WP_145061785.1 1930276 g41358 i0 92.3 5.88679245283019 52 4 98.1 0 158 3 194 245 WP_145061785.1 cupin-like domain-containing protein [Adhaeretor mobilis] diamond 936 103 0.990291262135922 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Lacipirellulaceae Adhaeretor Adhaeretor mobilis
30276471 30276471 PRJNA851399_P_NODE_10792_length_237_cov_0.744681_g10339_i0 PRJNA851399 10792 237 0.744681 1.76489397 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 43.5 0.0177   NR PYI75966.1 2026799 g10339 i0 38.8 0.848101265822785 67 35 77.2 2 41 223 102 168 PYI75966.1 MAG: acyl-CoA dehydrogenase [Verrucomicrobiota bacterium] diamond 201 43.5 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
30339873 30339873 PRJNA851399_P_NODE_38792_length_162_cov_0.902655_g38339_i0 PRJNA851399 38792 162 0.902655 1.4623011 Chthoniobacterales bacterium 2201154 Bacteria Bacteria 62 1.93e-9   NR HXM29525.1 2201154 g38339 i0 51.9 0.962962962962963 52 25 96.3 0 161 6 169 220 HXM29525.1 Na/Pi cotransporter family protein [Chthoniobacterales bacterium] diamond 156 62 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Spartobacteria Chthoniobacterales     Chthoniobacterales bacterium
30466021 30466021 PRJNA851399_P_NODE_30313_length_165_cov_0.879310_g29860_i0 PRJNA851399 30313 165 0.87931 1.4508615 Prosthecobacter sp. 1965333 Bacteria Bacteria 108 8.37e-26   NR WP_300199569.1 1965333 g29860 i0 100 1.96363636363636 54 0 98.2 0 164 3 455 508 WP_300199569.1 excinuclease ABC subunit UvrA [Prosthecobacter sp.] diamond 324 108 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Prosthecobacter Prosthecobacter sp.
30686770 30686770 PRJNA851399_P_NODE_37413_length_162_cov_0.902655_g36960_i0 PRJNA851399 37413 162 0.902655 1.4623011 Gemmataceae bacterium 2052164 Bacteria Bacteria 43.9 0.00479   NR MCX7699587.1 2052164 g36960 i0 39.2 0.944444444444444 51 31 94.4 0 154 2 363 413 MCX7699587.1 glycoside hydrolase family 5 protein [Gemmataceae bacterium] diamond 153 43.9 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
31761719 31761719 PRJNA851399_P_NODE_31357_length_165_cov_0.879310_g30904_i0 PRJNA851399 31357 165 0.87931 1.4508615 Verrucomicrobiia bacterium 2499141 Bacteria Bacteria 84.3 1.38e-17   NR HEX7569162.1 2499141 g30904 i0 82.6 1.67272727272727 46 8 83.6 0 165 28 294 339 HEX7569162.1 PIN domain-containing protein [Verrucomicrobiia bacterium] diamond 276 84.3 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       Verrucomicrobiia bacterium
32014833 32014833 PRJNA851399_P_NODE_18338_length_182_cov_1.360902_g17885_i0 PRJNA851399 18338 182 1.360902 2.47684164 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 90.5 1.64e-19   NR RFC48550.1 2026799 g17885 i0 74.6 1.96153846153846 59 15 97.3 0 2 178 289 347 RFC48550.1 MAG: MFS family permease [Verrucomicrobiota bacterium] diamond 357 90.5 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
32181420 32181420 PRJNA851399_P_NODE_30278_length_165_cov_0.879310_g29825_i0 PRJNA851399 30278 165 0.87931 1.4508615 Bacteria 2 Bacteria Bacteria 93.6 1.11e-20   NR MES2465762.1 2026799 g29825 i0 75.5 1.90909090909091 53 13 96.4 0 5 163 384 436 MES2465762.1 UDP-N-acetylmuramoyl-L-alanine--D-glutamate ligase [Verrucomicrobiota bacterium] diamond 315 93.6 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
32204732 32204732 PRJNA851399_P_NODE_19738_length_178_cov_1.581395_g19285_i0 PRJNA851399 19738 178 1.581395 2.8148831 Verrucomicrobiia bacterium 2499141 Bacteria Bacteria 105 8.61e-25   NR MDR3455851.1 2499141 g19285 i0 86.4 1.98876404494382 59 8 99.4 0 177 1 222 280 MDR3455851.1 WecB/TagA/CpsF family glycosyltransferase [Verrucomicrobiia bacterium] diamond 354 105 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       Verrucomicrobiia bacterium
32867592 32867592 PRJNA851399_P_NODE_10840_length_236_cov_1.080214_g10387_i0 PRJNA851399 10840 236 1.080214 2.54930504 Opitutaceae bacterium TAV1 278956 Bacteria Bacteria 48.1 3.6e-4   NR EIQ00196.1 278956 g10387 i0 83.3 0.635593220338983 24 4 30.5 0 73 2 3 26 EIQ00196.1 site-specific DNA methylase [Opitutaceae bacterium TAV1] diamond 150 48.1 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae   Opitutaceae bacterium TAV1

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