RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

27 rows where analysis = "diamond", bioproject = "PRJNA1242190" and tax_kingdom = "Pseudomonadati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_clade 2

tax_superkingdom 1

tax_kingdom 1

  • Pseudomonadati · 27 ✖

bioproject 1

  • PRJNA1242190 · 27 ✖

analysis 1

  • diamond · 27 ✖
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
2901662 2901662 PRJNA1242190_S_NODE_1123_length_583_cov_3.756863_g1116_i0 PRJNA1242190 1123 583 3.756863 21.90251129 Pseudomonadota bacterium 1977087 Bacteria Bacteria 208 1.76e-65   NR MEL6702587.1 1977087 g1116 i0 69.5 2.1663807890223 141 43 72.6 0 87 509 19 159 MEL6702587.1 50S ribosomal protein L2 [Pseudomonadota bacterium] diamond 1263 208 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
11829454 11829454 PRJNA1242190_S_NODE_1230_length_570_cov_3.438632_g1223_i0 PRJNA1242190 1230 570 3.438632 19.6002024 Pseudomonadota bacterium 1977087 Bacteria Bacteria 237 5.02e-77   NR MEL6702562.1 1977087 g1223 i0 68.8 3.30526315789474 157 49 82.6 0 555 85 1 157 MEL6702562.1 30S ribosomal protein S17 [Pseudomonadota bacterium] diamond 1884 237 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
12529662 12529662 PRJNA1242190_S_NODE_2390_length_480_cov_2.616708_g2383_i0 PRJNA1242190 2390 480 2.616708 12.5601984 Pseudomonadota bacterium 1977087 Bacteria Bacteria 199 1.28e-62   NR MEL6702598.1 1977087 g2383 i0 68.1 1.8 144 45 90 1 480 49 3 145 MEL6702598.1 uL15 family ribosomal protein [Pseudomonadota bacterium] diamond 864 199 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
20752419 20752419 PRJNA1242190_S_NODE_2017_length_506_cov_1.080831_g2010_i0 PRJNA1242190 2017 506 1.080831 5.46900486 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 177 6.689999999999999e-54   NR GJM17744.1 2202153 g2010 i0 73.3 0.687747035573123 116 31 68.8 0 1 348 12 127 GJM17744.1 MAG: hypothetical protein DHS20C13_30710 [Thermodesulfobacteriota bacterium] diamond 348 177 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
21452825 21452825 PRJNA1242190_S_NODE_2177_length_493_cov_3.976190_g2170_i0 PRJNA1242190 2177 493 3.97619 19.6026167 Pseudomonadota bacterium 1977087 Bacteria Bacteria 198 7.42e-62   NR MEL6702587.1 1977087 g2170 i0 72.7 0.803245436105477 132 36 80.3 0 4 399 28 159 MEL6702587.1 50S ribosomal protein L2 [Pseudomonadota bacterium] diamond 396 198 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
26788876 26788876 PRJNA1242190_S_NODE_13041_length_246_cov_0.901734_g13034_i0 PRJNA1242190 13041 246 0.901734 2.21826564 Providencia sp. PROV 589 Bacteria Bacteria 43.1 0.00775   NR WP_272664213.1 2949751 g13034 i0 58.1 0.524390243902439 43 15 48.8 2 188 69 43 85 WP_272664213.1 hypothetical protein, partial [Providencia sp. PROV016] diamond 129 43.1 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Morganellaceae Providencia Providencia sp. PROV016
26915369 26915369 PRJNA1242190_S_NODE_9702_length_277_cov_1.147059_g9695_i0 PRJNA1242190 9702 277 1.147059 3.17735343 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 53.5 6.6e-6   NR HEX8176079.1 2283092 g9695 i0 47.1 2.35018050541516 70 30 70.4 4 226 32 162 229 HEX8176079.1 CAP domain-containing protein [Pyrinomonadaceae bacterium] diamond 651 53.5 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
27105026 27105026 PRJNA1242190_S_NODE_5382_length_355_cov_2.925532_g5375_i0 PRJNA1242190 5382 355 2.925532 10.3856386 Alphaproteobacteria bacterium 1913988 Bacteria Bacteria 45.1 0.0203   NR MFO1189048.1 1913988 g5375 i0 37.3 0.430985915492958 51 32 43.1 0 89 241 568 618 MFO1189048.1 tetratricopeptide repeat protein [Alphaproteobacteria bacterium] diamond 153 45.1 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria       Alphaproteobacteria bacterium
28052642 28052642 PRJNA1242190_S_NODE_3905_length_405_cov_2.545181_g3898_i0 PRJNA1242190 3905 405 2.545181 10.30798305 Chitinophagaceae bacterium 1869212 Bacteria Bacteria 148 2.55e-38   NR MCA6491779.1 1869212 g3898 i0 55.3 0.911111111111111 123 53 91.1 2 404 36 709 829 MCA6491779.1 GTP-binding protein [Chitinophagaceae bacterium] diamond 369 148 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae   Chitinophagaceae bacterium
28084191 28084191 PRJNA1242190_S_NODE_10065_length_272_cov_1.567839_g10058_i0 PRJNA1242190 10065 272 1.567839 4.26452208 Bacteroidota bacterium 1898104 Bacteria Bacteria 43.5 0.0289   NR MFN5323516.1 1898104 g10058 i0 32.5 0.882352941176471 80 50 83.8 1 253 26 600 679 MFN5323516.1 M1 family metallopeptidase [Bacteroidota bacterium] diamond 240 43.5 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
28273593 28273593 PRJNA1242190_S_NODE_3906_length_405_cov_2.466867_g3899_i0 PRJNA1242190 3906 405 2.466867 9.99081135 Flavobacteriaceae bacterium 1871037 Bacteria Bacteria 101 1.0699999999999997e-23   NR MDP2061423.1 1871037 g3899 i0 51.7 1.74074074074074 118 38 84.4 2 404 63 115 217 MDP2061423.1 30S ribosomal protein S8e [Flavobacteriaceae bacterium] diamond 705 101 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae   Flavobacteriaceae bacterium
28526503 28526503 PRJNA1242190_S_NODE_13867_length_237_cov_2.030488_g13860_i0 PRJNA1242190 13867 237 2.030488 4.81225656 Pseudomonadota bacterium 1977087 Bacteria Bacteria 116 4e-31   NR MEL6702587.1 1977087 g13860 i0 74 0.974683544303797 77 20 97.5 0 236 6 30 106 MEL6702587.1 50S ribosomal protein L2 [Pseudomonadota bacterium] diamond 231 116 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
29347347 29347347 PRJNA1242190_S_NODE_5369_length_356_cov_1.268551_g5362_i0 PRJNA1242190 5369 356 1.268551 4.51604156 Verrucomicrobiaceae bacterium 2026800 Bacteria Bacteria 160 8.65e-46   NR RYD65414.1 2026800 g5362 i0 85.4 0.691011235955056 82 12 69.1 0 3 248 255 336 RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium] diamond 246 160 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae   Verrucomicrobiaceae bacterium
29441697 29441697 PRJNA1242190_S_NODE_11050_length_260_cov_2.283422_g11043_i0 PRJNA1242190 11050 260 2.283422 5.9368972 Acidobacteriota bacterium 1978231 Bacteria Bacteria 50.1 1.95e-5   NR MDQ7008653.1 1978231 g11043 i0 62.9 0.773076923076923 35 13 40.4 0 250 146 75 109 MDQ7008653.1 NFYB/HAP3 family transcription factor subunit [Acidobacteriota bacterium] diamond 201 50.1 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
29536688 29536688 PRJNA1242190_S_NODE_2250_length_488_cov_3.240964_g2243_i0 PRJNA1242190 2250 488 3.240964 15.81590432 Pseudomonadota bacterium 1977087 Bacteria Bacteria 161 6.05e-48   NR MEL6702586.1 1977087 g2243 i0 55.9 0.780737704918033 127 56 78.1 0 39 419 1 127 MEL6702586.1 uL14 family ribosomal protein [Pseudomonadota bacterium] diamond 381 161 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
29568171 29568171 PRJNA1242190_S_NODE_14070_length_227_cov_3.318182_g14063_i0 PRJNA1242190 14070 227 3.318182 7.53227314 Thermodesulfobacteriota bacterium 2202153 Bacteria Bacteria 88.2 4.8e-21   NR GJM17324.1 2202153 g14063 i0 76.5 0.674008810572687 51 12 67.4 0 226 74 21 71 GJM17324.1 MAG: hypothetical protein DHS20C13_26510 [Thermodesulfobacteriota bacterium] diamond 153 88.2 1 Bacteria   Pseudomonadati Thermodesulfobacteriota         Thermodesulfobacteriota bacterium
29789119 29789119 PRJNA1242190_S_NODE_6251_length_334_cov_1.758621_g6244_i0 PRJNA1242190 6251 334 1.758621 5.87379414 Nevskiales bacterium 2026766 Bacteria Bacteria 92 9.12e-22   NR HXG27613.1 2026766 g6244 i0 57.1 1.3562874251497 84 28 73.7 2 327 82 1 78 HXG27613.1 acyl-CoA-binding protein [Nevskiales bacterium] diamond 453 92 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Nevskiales     Nevskiales bacterium
30199723 30199723 PRJNA1242190_S_NODE_12692_length_248_cov_0.874286_g12685_i0 PRJNA1242190 12692 248 0.874286 2.16822928 Rhizobium sp. 391 Bacteria Bacteria 91.3 1.56e-20   NR WP_407766259.1 391 g12685 i0 61.3 1.80241935483871 75 27 89.5 2 246 25 140 213 WP_407766259.1 glycoside hydrolase family 19 protein [Rhizobium sp.] diamond 447 91.3 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Rhizobiaceae Rhizobium Rhizobium sp.
30547510 30547510 PRJNA1242190_S_NODE_5153_length_361_cov_4.201389_g5146_i0 PRJNA1242190 5153 361 4.201389 15.16701429 Acidobacteriaceae bacterium 2052142 Bacteria Bacteria 66.2 6.33e-10   NR MDR3737318.1 2052142 g5146 i0 42.9 0.814404432132964 98 53 78.9 2 355 71 211 308 MDR3737318.1 hypothetical protein [Acidobacteriaceae bacterium] diamond 294 66.2 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae   Acidobacteriaceae bacterium
31084664 31084664 PRJNA1242190_S_NODE_3375_length_429_cov_0.997191_g3368_i0 PRJNA1242190 3375 429 0.997191 4.27794939 Undibacterium jejuense 1344949 Bacteria Bacteria 89.4 9.55e-18   NR WP_246447504.1 1344949 g3368 i0 53.3 1.26573426573427 92 40 62.2 1 163 429 270 361 WP_246447504.1 Wzz/FepE/Etk N-terminal domain-containing protein [Undibacterium jejuense] diamond 543 89.4 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Undibacterium Undibacterium jejuense
31084665 31084665 PRJNA1242190_S_NODE_5275_length_358_cov_1.943860_g5268_i0 PRJNA1242190 5275 358 1.94386 6.9590188 Terriglobales bacterium 2282142 Bacteria Bacteria 71.2 2.63e-12   NR HME33021.1 2282142 g5268 i0 40.2 0.770949720670391 92 55 77.1 0 350 75 99 190 HME33021.1 hypothetical protein [Terriglobales bacterium] diamond 276 71.2 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales     Terriglobales bacterium
31464287 31464287 PRJNA1242190_S_NODE_11436_length_256_cov_1.732240_g11429_i0 PRJNA1242190 11436 256 1.73224 4.4345344 Colwellia sp. 56799 Bacteria Bacteria 44.3 0.00285   NR MCP4991253.1 56799 g11429 i0 38.2 0.796875 68 41 79.7 1 33 236 40 106 MCP4991253.1 hypothetical protein [Colwellia sp.] diamond 204 44.3 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Alteromonadales Colwelliaceae Colwellia Colwellia sp.
31622101 31622101 PRJNA1242190_S_NODE_3976_length_402_cov_1.319149_g3969_i0 PRJNA1242190 3976 402 1.319149 5.30297898 Lysobacterales bacterium 2006849 Bacteria Bacteria 61.6 5.52e-8   NR HKJ19006.1 2006849 g3969 i0 35.5 0.694029850746269 93 56 67.2 2 393 124 125 216 HKJ19006.1 hypothetical protein [Lysobacterales bacterium] diamond 279 61.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Lysobacterales     Lysobacterales bacterium
31748597 31748597 PRJNA1242190_S_NODE_13397_length_244_cov_0.912281_g13390_i0 PRJNA1242190 13397 244 0.912281 2.22596564 Escherichia coli 562 Bacteria Bacteria 102 4.67e-24   NR MCI3325462.1 562 g13390 i0 61.3 0.983606557377049 80 31 98.4 0 3 242 214 293 MCI3325462.1 cathepsin B family protein [Escherichia coli] diamond 240 102 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
31812011 31812011 PRJNA1242190_S_NODE_8757_length_290_cov_1.152074_g8750_i0 PRJNA1242190 8757 290 1.152074 3.3410146 Roseiarcus sp. 1969460 Bacteria Bacteria 58.2 8.03e-8   NR HEY6519662.1 1969460 g8750 i0 53.7 0.558620689655172 54 24 54.8 1 54 212 128 181 HEY6519662.1 glycoside hydrolase family 19 protein [Roseiarcus sp.] diamond 162 58.2 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Roseiarcaceae Roseiarcus Roseiarcus sp.
32223355 32223355 PRJNA1242190_S_NODE_1178_length_576_cov_3.514911_g1171_i0 PRJNA1242190 1178 576 3.514911 20.24588736 Acidobacteriaceae bacterium 2052142 Bacteria Bacteria 147 1.42e-39   NR MDR3737318.1 2052142 g1171 i0 46 0.90625 174 90 89.6 3 557 42 141 312 MDR3737318.1 hypothetical protein [Acidobacteriaceae bacterium] diamond 522 147 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae   Acidobacteriaceae bacterium
32508297 32508297 PRJNA1242190_S_NODE_12479_length_249_cov_0.886364_g12472_i0 PRJNA1242190 12479 249 0.886364 2.20704636 Saprospiraceae bacterium 2202734 Bacteria Bacteria 90.1 4.4300000000000005e-21   NR HMT54961.1 2202734 g12472 i0 64.7 1.63855421686747 68 24 81.9 0 245 42 51 118 HMT54961.1 hypothetical protein [Saprospiraceae bacterium] diamond 408 90.1 1 Bacteria FCB group Pseudomonadati Bacteroidota Saprospiria Saprospirales Saprospiraceae   Saprospiraceae 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);;