RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA630877" 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 · 17 ✖

bioproject 1

  • PRJNA630877 · 17 ✖

analysis 1

  • diamond · 17 ✖
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
26891274 26891274 PRJNA630877_S_NODE_122841_length_186_cov_2.027586_g103704_i0 PRJNA630877 122841 186 2.027586 3.77130996 Planctomycetota bacterium 2026780 Bacteria Bacteria 42.4 0.025   NR MEM7164993.1 2026780 g103704 i0 45.7 0.741935483870968 46 23 71 1 28 159 52 97 MEM7164993.1 hypothetical protein [Planctomycetota bacterium] diamond 138 42.4 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
26954109 26954109 PRJNA630877_S_NODE_126162_length_182_cov_1.510638_g107025_i0 PRJNA630877 126162 182 1.510638 2.74936116 Planctomycetia bacterium 2052181 Bacteria Bacteria 42.7 0.0163   NR MEI7702286.1 2052181 g107025 i0 48.8 0.675824175824176 41 20 65.9 1 128 9 54 94 MEI7702286.1 TerC family protein [Planctomycetia bacterium] diamond 123 42.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia       Planctomycetia bacterium
27017552 27017552 PRJNA630877_S_NODE_85142_length_272_cov_2.393939_g66005_i0 PRJNA630877 85142 272 2.393939 6.51151408 Planctomycetota bacterium 2026780 Bacteria Bacteria 42.7 0.0111   NR HUW32127.1 2026780 g66005 i0 37.9 0.727941176470588 66 35 68.4 2 33 218 6 69 HUW32127.1 hypothetical protein [Planctomycetota bacterium] diamond 198 42.7 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
27713078 27713078 PRJNA630877_S_NODE_74364_length_324_cov_2.201413_g55227_i0 PRJNA630877 74364 324 2.201413 7.13257812 Candidatus Omnitrophota bacterium 2035772 Bacteria Bacteria 44.3 0.0192   NR MFA5115065.1 2035772 g55227 i0 39 1.09259259259259 59 32 50.9 3 239 75 81 139 MFA5115065.1 endonuclease III domain-containing protein [Candidatus Omnitrophota bacterium] diamond 354 44.3 1 Bacteria PVC group Pseudomonadati Candidatus Omnitrophota         Candidatus Omnitrophota bacterium
28154903 28154903 PRJNA630877_S_NODE_120845_length_189_cov_1.358108_g101708_i0 PRJNA630877 120845 189 1.358108 2.56682412 Planctomycetota bacterium 2026780 Bacteria Bacteria 41.2 0.0263   NR MFC1766865.1 2026780 g101708 i0 34.8 0.73015873015873 46 28 73 1 23 160 46 89 MFC1766865.1 tyrosine-type recombinase/integrase [Planctomycetota bacterium] diamond 138 41.2 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
28407352 28407352 PRJNA630877_S_NODE_101566_length_223_cov_2.950549_g82429_i0 PRJNA630877 101566 223 2.950549 6.57972427 Phycisphaerae bacterium 2026778 Bacteria Bacteria 42.4 0.0371   NR MFB3890659.1 2026778 g82429 i0 40.6 0.860986547085202 64 29 80.7 2 209 30 222 280 MFB3890659.1 uroporphyrinogen decarboxylase family protein [Phycisphaerae bacterium] diamond 192 42.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
28470584 28470584 PRJNA630877_S_NODE_9486_length_2249_cov_6.140399_g5154_i0 PRJNA630877 9486 2249 6.140399 138.09757351 Candidatus Omnitrophota bacterium 2035772 Bacteria Bacteria 51.6 0.0115   NR MCG8431411.1 2035772 g5154 i0 40 0.133392618941752 100 51 13.2 3 1710 2006 263 354 MCG8431411.1 reverse transcriptase family protein [Candidatus Omnitrophota bacterium] diamond 300 51.6 1 Bacteria PVC group Pseudomonadati Candidatus Omnitrophota         Candidatus Omnitrophota bacterium
29165320 29165320 PRJNA630877_S_NODE_122289_length_187_cov_1.506849_g103152_i0 PRJNA630877 122289 187 1.506849 2.81780763 Tepidisphaeraceae bacterium 2876886 Bacteria Bacteria 41.6 0.0456   NR HEV2293353.1 2876886 g103152 i0 39.3 0.898395721925134 56 34 89.8 0 4 171 171 226 HEV2293353.1 integron integrase [Tepidisphaeraceae bacterium] diamond 168 41.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae   Tepidisphaeraceae bacterium
29430021 29430021 PRJNA630877_S_NODE_107129_length_212_cov_1.216374_g87992_i0 PRJNA630877 107129 212 1.216374 2.57871288 Planctomycetia 203683 Bacteria Bacteria 42.7 0.024   NR HEV8067191.1 2026779 g87992 i0 33.9 2.34905660377358 59 39 83.5 0 191 15 5 63 HEV8067191.1 ABC transporter ATP-binding protein [Planctomycetaceae bacterium] diamond 498 42.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
29575318 29575318 PRJNA630877_S_NODE_92370_length_248_cov_1.376812_g73233_i0 PRJNA630877 92370 248 1.376812 3.41449376 Pirellulaceae bacterium 2699754 Bacteria Bacteria 42.7 0.0367   NR MEZ6091620.1 2699754 g73233 i0 35.2 0.653225806451613 54 28 58.1 2 14 157 175 227 MEZ6091620.1 hypothetical protein [Pirellulaceae bacterium] diamond 162 42.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae   Pirellulaceae bacterium
30554624 30554624 PRJNA630877_S_NODE_109433_length_207_cov_1.765060_g90296_i0 PRJNA630877 109433 207 1.76506 3.6536742 Lentisphaeraceae bacterium 2461380 Bacteria Bacteria 41.2 0.0489   NR MCM8534648.1 2461380 g90296 i0 34.5 0.797101449275362 55 33 75.4 1 36 191 68 122 MCM8534648.1 dCMP deaminase family protein [Lentisphaeraceae bacterium] diamond 165 41.2 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria Lentisphaerales Lentisphaeraceae   Lentisphaeraceae bacterium
30554636 30554636 PRJNA630877_S_NODE_91133_length_252_cov_0.952607_g71996_i0 PRJNA630877 91133 252 0.952607 2.40056964 Phycisphaerae bacterium SM23_33 1703412 Bacteria Bacteria 45.8 0.00329   NR KPK84483.1 1703412 g71996 i0 32.1 0.964285714285714 81 37 75 3 224 36 303 383 KPK84483.1 MAG: hypothetical protein AMJ81_05380 [Phycisphaerae bacterium SM23_33] diamond 243 45.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium SM23_33
30680953 30680953 PRJNA630877_S_NODE_95453_length_239_cov_1.333333_g76316_i0 PRJNA630877 95453 239 1.333333 3.18666587 Planctomycetota bacterium 2026780 Bacteria Bacteria 46.6 0.00152   NR MEO1715707.1 2026780 g76316 i0 34.7 0.903765690376569 72 46 89.1 1 6 218 288 359 MEO1715707.1 hypothetical protein [Planctomycetota bacterium] diamond 216 46.6 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31028927 31028927 PRJNA630877_S_NODE_70515_length_348_cov_2.778502_g51378_i0 PRJNA630877 70515 348 2.778502 9.66918696 Planctomycetota bacterium 2026780 Bacteria Bacteria 46.2 0.00678   NR MCB9832231.1 2026780 g51378 i0 50.8 0.560344827586207 65 21 56 3 292 98 116 169 MCB9832231.1 hypothetical protein [Planctomycetota bacterium] diamond 195 46.2 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
32040769 32040769 PRJNA630877_S_NODE_49378_length_581_cov_2.151852_g30881_i0 PRJNA630877 49378 581 2.151852 12.50226012 Planctomycetota bacterium 2026780 Bacteria Bacteria 47 0.0199   NR MEY4176768.1 2026780 g30881 i0 40 0.309810671256454 60 30 31 2 356 177 174 227 MEY4176768.1 hypothetical protein [Planctomycetota bacterium] diamond 180 47 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
32452341 32452341 PRJNA630877_S_NODE_62819_length_410_cov_3.837398_g43688_i0 PRJNA630877 62819 410 3.837398 15.7333318 Pirellulaceae bacterium 2699754 Bacteria Bacteria 45.8 0.00837   NR MEZ6137792.1 2699754 g43688 i0 34.3 0.51219512195122 70 41 51.2 1 395 186 34 98 MEZ6137792.1 DinB family protein [Pirellulaceae bacterium] diamond 210 45.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae   Pirellulaceae bacterium
32798777 32798777 PRJNA630877_S_NODE_126220_length_182_cov_1.269504_g107083_i0 PRJNA630877 126220 182 1.269504 2.31049728 Neorhodopirellula pilleata 2714738 Bacteria Bacteria 41.6 0.0421   NR WP_231602722.1 2714738 g107083 i0 43.8 0.527472527472527 32 18 52.7 0 144 49 235 266 WP_231602722.1 sigma-54 interaction domain-containing protein [Neorhodopirellula pilleata] diamond 96 41.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Neorhodopirellula Neorhodopirellula pilleata

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