RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

31 rows where analysis = "diamond", bioproject = "PRJNA688414" and tax_clade = "PVC group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

tax_clade 1

  • PVC group · 31 ✖

bioproject 1

  • PRJNA688414 · 31 ✖

analysis 1

  • diamond · 31 ✖
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
1943006 1943006 PRJNA688414_P_NODE_6442_length_251_cov_0.876404_g6408_i0 PRJNA688414 6442 251 0.876404 2.19977404 Bacteria 2 Bacteria Bacteria 152 6.74e-45   NR HZA54103.1 2665650 g6408 i0 92.5 2.86852589641434 80 6 95.6 0 3 242 104 183 HZA54103.1 (2Fe-2S)-binding protein [Candidatus Udaeobacter sp.] diamond 720 152 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Spartobacteria Chthoniobacterales Chthoniobacteraceae Candidatus Udaeobacter Candidatus Udaeobacter sp.
4495015 4495015 PRJNA688414_P_NODE_8244_length_242_cov_0.923077_g8210_i0 PRJNA688414 8244 242 0.923077 2.23384634 Gemmataceae bacterium 2052164 Bacteria Bacteria 102 4.36e-24   NR HZY90660.1 2052164 g8210 i0 60 3.95454545454545 80 32 99.2 0 242 3 196 275 HZY90660.1 hypothetical protein [Gemmataceae bacterium] diamond 957 102 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
13420990 13420990 PRJNA688414_P_NODE_8151_length_243_cov_0.917647_g8117_i0 PRJNA688414 8151 243 0.917647 2.22988221 Planctomycetota bacterium 2026780 Bacteria Bacteria 94.7 1.37e-23   NR MEI7687657.1 2026780 g8117 i0 72.9 0.728395061728395 59 16 72.8 0 243 67 6 64 MEI7687657.1 hypothetical protein [Planctomycetota bacterium] diamond 177 94.7 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
18519095 18519095 PRJNA688414_P_NODE_6115_length_252_cov_0.871508_g6081_i0 PRJNA688414 6115 252 0.871508 2.19620016 Chthoniobacterales bacterium 2201154 Bacteria Bacteria 164 9.79e-49   NR HJX98481.1 2201154 g6081 i0 97.6 2.96428571428571 83 2 98.8 0 3 251 149 231 HJX98481.1 succinate dehydrogenase/fumarate reductase iron-sulfur subunit [Chthoniobacterales bacterium] diamond 747 164 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Spartobacteria Chthoniobacterales     Chthoniobacterales bacterium
23619895 23619895 PRJNA688414_P_NODE_8339_length_242_cov_0.923077_g8305_i0 PRJNA688414 8339 242 0.923077 2.23384634 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 161 7.22e-46   NR MDB5338058.1 2026779 g8305 i0 91.3 0.991735537190083 80 7 99.2 0 2 241 38 117 MDB5338058.1 glucose-phosphate adenylyltransferase [Planctomycetaceae bacterium] diamond 240 161 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
26682228 26682228 PRJNA688414_P_NODE_6221_length_252_cov_0.871508_g6187_i0 PRJNA688414 6221 252 0.871508 2.19620016 Terrimicrobium 1649503 Bacteria Bacteria 187 1.33e-53   NR HEY6676884.1 1965319 g6187 i0 98.8 6 84 1 100 0 1 252 410 493 HEY6676884.1 glycosyltransferase [Terrimicrobium sp.] diamond 1512 187 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Terrimicrobiia Terrimicrobiales Terrimicrobiaceae Terrimicrobium Terrimicrobium sp.
26892613 26892613 PRJNA688414_P_NODE_6161_length_252_cov_0.871508_g6127_i0 PRJNA688414 6161 252 0.871508 2.19620016 Planctomycetota bacterium 2026780 Bacteria Bacteria 42.4 0.0156   NR MFV1959459.1 2026780 g6127 i0 39.3 0.726190476190476 61 28 61.9 1 250 95 9 69 MFV1959459.1 hypothetical protein [Planctomycetota bacterium] diamond 183 42.4 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
26967176 26967176 PRJNA688414_P_NODE_6642_length_250_cov_0.881356_g6608_i0 PRJNA688414 6642 250 0.881356 2.20339 Bacteria 2 Bacteria Bacteria 135 1.88e-36   NR MFO1511878.1 2026799 g6608 i0 78 1.968 82 18 98.4 0 248 3 278 359 MFO1511878.1 DegT/DnrJ/EryC1/StrS family aminotransferase [Verrucomicrobiota bacterium] diamond 492 136 0.992647058823529 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
27050705 27050705 PRJNA688414_P_NODE_6422_length_251_cov_0.876404_g6388_i0 PRJNA688414 6422 251 0.876404 2.19977404 Planctomycetota bacterium 2026780 Bacteria Bacteria 67 9.83e-12   NR HZN40169.1 2026780 g6388 i0 42.5 2.84462151394422 87 46 99.2 1 251 3 57 143 HZN40169.1 hypothetical protein [Planctomycetota bacterium] diamond 714 67 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
27113657 27113657 PRJNA688414_P_NODE_6782_length_249_cov_0.886364_g6748_i0 PRJNA688414 6782 249 0.886364 2.20704636 Gemmataceae bacterium 2052164 Bacteria Bacteria 48.1 3.52e-4   NR HEY7425662.1 2052164 g6748 i0 41.2 1.91566265060241 85 40 90.4 4 238 14 128 212 HEY7425662.1 hypothetical protein [Gemmataceae bacterium] diamond 477 48.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
27966567 27966567 PRJNA688414_P_NODE_7045_length_248_cov_0.891429_g7011_i0 PRJNA688414 7045 248 0.891429 2.21074392 Planctomycetales bacterium 2053591 Bacteria Bacteria 100 2.55e-22   NR MBI5757139.1 2053591 g7011 i0 83.6 0.737903225806452 61 10 73.8 0 183 1 1 61 MBI5757139.1 methyl-accepting chemotaxis protein [Planctomycetales bacterium] diamond 183 100 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales     Planctomycetales bacterium
28061281 28061281 PRJNA688414_P_NODE_8045_length_243_cov_0.917647_g8011_i0 PRJNA688414 8045 243 0.917647 2.22988221 Isosphaeraceae bacterium 2691532 Bacteria Bacteria 128 2.07e-35   NR HMB07825.1 2691532 g8011 i0 90.9 0.814814814814815 66 6 81.5 0 200 3 1 66 HMB07825.1 FHA domain-containing protein [Isosphaeraceae bacterium] diamond 198 128 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae   Isosphaeraceae bacterium
28124561 28124561 PRJNA688414_P_NODE_7185_length_247_cov_0.896552_g7151_i0 PRJNA688414 7185 247 0.896552 2.21448344 Planctomycetota bacterium 2026780 Bacteria Bacteria 91.7 2.33e-19   NR HYG77527.1 2026780 g7151 i0 46.9 1.16599190283401 96 36 98.4 1 245 3 323 418 HYG77527.1 redoxin domain-containing protein [Planctomycetota bacterium] diamond 288 91.7 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
28787385 28787385 PRJNA688414_P_NODE_7407_length_246_cov_0.901734_g7373_i0 PRJNA688414 7407 246 0.901734 2.21826564 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 103 1.5099999999999998e-23   NR MEO7299310.1 2026799 g7373 i0 67.5 0.975609756097561 80 26 97.6 0 5 244 377 456 MEO7299310.1 Calx-beta domain-containing protein [Verrucomicrobiota bacterium] diamond 240 103 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
28862133 28862133 PRJNA688414_P_NODE_7768_length_245_cov_0.877907_g7734_i0 PRJNA688414 7768 245 0.877907 2.15087215 Planctomycetia 203683 Bacteria Bacteria 118 1.11e-28   NR MBC7817684.1 2026779 g7734 i0 66.3 4.88571428571429 80 27 98 0 240 1 503 582 MBC7817684.1 DUF1549 domain-containing protein [Planctomycetaceae bacterium] diamond 1197 119 0.991596638655462 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
28882197 28882197 PRJNA688414_P_NODE_6848_length_249_cov_0.886364_g6814_i0 PRJNA688414 6848 249 0.886364 2.20704636 Isosphaeraceae bacterium 2691532 Bacteria Bacteria 99 6.5e-22   NR GIW87159.1 2691532 g6814 i0 55.4 1 83 37 100 0 249 1 161 243 GIW87159.1 MAG: glucose dehydrogenase [Isosphaeraceae bacterium] diamond 249 99 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae   Isosphaeraceae bacterium
28882199 28882199 PRJNA688414_P_NODE_7508_length_246_cov_0.901734_g7474_i0 PRJNA688414 7508 246 0.901734 2.21826564 Pirellulaceae bacterium 2699754 Bacteria Bacteria 73.6 5.45e-13   NR NND97431.1 2699754 g7474 i0 50.6 0.963414634146341 79 35 96.3 1 238 2 343 417 NND97431.1 cadherin-like domain-containing protein [Pirellulaceae bacterium] diamond 237 73.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae   Pirellulaceae bacterium
29418917 29418917 PRJNA688414_P_NODE_7529_length_246_cov_0.901734_g7495_i0 PRJNA688414 7529 246 0.901734 2.21826564 Lacipirellulaceae bacterium 2691534 Bacteria Bacteria 166 5.829999999999999e-46   NR HJQ81629.1 2691534 g7495 i0 98.8 0.98780487804878 81 1 98.8 0 3 245 609 689 HJQ81629.1 HDIG domain-containing protein [Lacipirellulaceae bacterium] diamond 243 166 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Lacipirellulaceae   Lacipirellulaceae bacterium
29671270 29671270 PRJNA688414_P_NODE_8350_length_242_cov_0.923077_g8316_i0 PRJNA688414 8350 242 0.923077 2.23384634 Pirellulales bacterium 2715253 Bacteria Bacteria 61.2 1.1e-8   NR HJT32413.1 2715253 g8316 i0 47.5 0.991735537190083 80 33 89.3 4 237 22 489 567 HJT32413.1 cytochrome c3 family protein [Pirellulales bacterium] diamond 240 61.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales     Pirellulales bacterium
29766219 29766219 PRJNA688414_P_NODE_7331_length_247_cov_0.873563_g7297_i0 PRJNA688414 7331 247 0.873563 2.15770061 Verrucomicrobiales bacterium 2026801 Bacteria Bacteria 160 1.6499999999999999e-43   NR MCI0538562.1 2026801 g7297 i0 90.2 0.995951417004049 82 8 99.6 0 2 247 54 135 MCI0538562.1 ABC transporter permease [Verrucomicrobiales bacterium] diamond 246 160 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales     Verrucomicrobiales bacterium
29924389 29924389 PRJNA688414_P_NODE_6031_length_253_cov_0.866667_g5997_i0 PRJNA688414 6031 253 0.866667 2.19266751 Phycisphaerales bacterium 2052180 Bacteria Bacteria 125 2.68e-33   NR MFM9995621.1 2052180 g5997 i0 71.1 0.984189723320158 83 24 98.4 0 251 3 162 244 MFM9995621.1 sugar phosphate isomerase/epimerase family protein [Phycisphaerales bacterium] diamond 249 125 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
30113749 30113749 PRJNA688414_P_NODE_7392_length_246_cov_0.901734_g7358_i0 PRJNA688414 7392 246 0.901734 2.21826564 Planctomycetota bacterium 2026780 Bacteria Bacteria 86.7 5.34e-19   NR HVQ25817.1 2026780 g7358 i0 66.2 0.792682926829268 65 22 79.3 0 239 45 125 189 HVQ25817.1 hypothetical protein [Planctomycetota bacterium] diamond 195 86.7 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30430168 30430168 PRJNA688414_P_NODE_7833_length_244_cov_0.912281_g7799_i0 PRJNA688414 7833 244 0.912281 2.22596564 Tepidisphaeraceae bacterium 2876886 Bacteria Bacteria 113 4.660000000000001e-27   NR HEV2296258.1 2876886 g7799 i0 67.9 0.995901639344262 81 26 99.6 0 244 2 710 790 HEV2296258.1 TAT-variant-translocated molybdopterin oxidoreductase [Tepidisphaeraceae bacterium] diamond 243 113 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae   Tepidisphaeraceae bacterium
30714103 30714103 PRJNA688414_P_NODE_7494_length_246_cov_0.901734_g7460_i0 PRJNA688414 7494 246 0.901734 2.21826564 Terrimicrobium sp. 1965319 Bacteria Bacteria 133 2.2699999999999997e-35   NR HEY6675672.1 1965319 g7460 i0 82.5 0.975609756097561 80 14 97.6 0 7 246 135 214 HEY6675672.1 gamma-glutamyltransferase [Terrimicrobium sp.] diamond 240 133 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Terrimicrobiia Terrimicrobiales Terrimicrobiaceae Terrimicrobium Terrimicrobium sp.
30714104 30714104 PRJNA688414_P_NODE_8034_length_243_cov_0.917647_g8000_i0 PRJNA688414 8034 243 0.917647 2.22988221 Tepidisphaeraceae bacterium 2876886 Bacteria Bacteria 152 5.93e-43   NR HEV2293130.1 2876886 g8000 i0 88.8 5.92592592592593 80 9 98.8 0 241 2 228 307 HEV2293130.1 aminopeptidase [Tepidisphaeraceae bacterium] diamond 1440 152 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae   Tepidisphaeraceae bacterium
30903811 30903811 PRJNA688414_P_NODE_8174_length_243_cov_0.917647_g8140_i0 PRJNA688414 8174 243 0.917647 2.22988221 Pedosphaera sp. Tous-C6FEB 1982324 Bacteria Bacteria 117 1.45e-28   NR PAW86756.1 1982324 g8140 i0 73.4 0.975308641975309 79 21 97.5 0 242 6 769 847 PAW86756.1 MAG: hypothetical protein B9S33_07420 [Pedosphaera sp. Tous-C6FEB] diamond 237 117 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Pedosphaerae Pedosphaerales Pedosphaeraceae Pedosphaera Pedosphaera sp. Tous-C6FEB
31061972 31061972 PRJNA688414_P_NODE_7015_length_248_cov_0.891429_g6981_i0 PRJNA688414 7015 248 0.891429 2.21074392 Chthoniobacterales bacterium 2201154 Bacteria Bacteria 139 3.4399999999999997e-37   NR HEV2843198.1 2201154 g6981 i0 85.4 0.991935483870968 82 11 99.2 1 246 1 71 151 HEV2843198.1 NAD(P)/FAD-dependent oxidoreductase [Chthoniobacterales bacterium] diamond 246 139 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Spartobacteria Chthoniobacterales     Chthoniobacterales bacterium
31820524 31820524 PRJNA688414_P_NODE_6357_length_251_cov_0.876404_g6323_i0 PRJNA688414 6357 251 0.876404 2.19977404 Planctomycetota bacterium 2026780 Bacteria Bacteria 86.3 5.18e-19   NR HVR75145.1 2026780 g6323 i0 70 0.717131474103586 60 18 71.7 0 67 246 1 60 HVR75145.1 molybdenum cofactor biosynthesis protein B [Planctomycetota bacterium] diamond 180 86.3 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
32232237 32232237 PRJNA688414_P_NODE_6178_length_252_cov_0.871508_g6144_i0 PRJNA688414 6178 252 0.871508 2.19620016 Terrimicrobium sp. 1965319 Bacteria Bacteria 92.4 4.09e-20   NR HEY6675380.1 1965319 g6144 i0 96.3 1.92857142857143 54 2 64.3 0 251 90 283 336 HEY6675380.1 ABC transporter permease [Terrimicrobium sp.] diamond 486 92.4 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Terrimicrobiia Terrimicrobiales Terrimicrobiaceae Terrimicrobium Terrimicrobium sp.
32611462 32611462 PRJNA688414_P_NODE_7240_length_247_cov_0.896552_g7206_i0 PRJNA688414 7240 247 0.896552 2.21448344 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 98.2 2.87e-22   NR MEY2512138.1 2026799 g7206 i0 60.6 0.801619433198381 66 26 80.2 0 245 48 280 345 MEY2512138.1 hypothetical protein [Verrucomicrobiota bacterium] diamond 198 98.2 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
32874827 32874827 PRJNA688414_P_NODE_7480_length_246_cov_0.901734_g7446_i0 PRJNA688414 7480 246 0.901734 2.21826564 PVC group 1783257 Bacteria Bacteria 144 4.08e-40   NR MCI0536380.1 2026801 g7446 i0 80.5 5.95121951219512 82 16 100 0 246 1 108 189 MCI0536380.1 fatty acid desaturase [Verrucomicrobiales bacterium] diamond 1464 145 0.993103448275862 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales     Verrucomicrobiales bacterium

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