RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

26 rows where analysis = "diamond", bioproject = "PRJNA753151" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 26 ✖

tax_kingdom 1

bioproject 1

  • PRJNA753151 · 26 ✖

analysis 1

  • diamond · 26 ✖

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
5833091 5833091 PRJNA753151_S_NODE_137265_length_247_cov_2.416667_g134975_i0 PRJNA753151 137265 247 2.416667 5.96916749 root 1 Root_unresolved Root_unresolved 81.3 1.06e-15   NR WP_270939598.1 287 g134975 i0 55.6 43.2874493927126 81 36 98.4 0 245 3 690 770 WP_270939598.1 type II CRISPR RNA-guided endonuclease Cas9, partial [Pseudomonas aeruginosa] diamond 10692 81.3 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas aeruginosa
26672702 26672702 PRJNA753151_S_NODE_2281_length_1178_cov_13.584141_g1864_i0 PRJNA753151 2281 1178 13.584141 160.02118098 Pseudomonadota bacterium 1977087 Bacteria Bacteria 64.3 3.28e-8   NR NBP02836.1 1977087 g1864 i0 37.6 0.216468590831918 85 47 21.4 2 746 495 63 142 NBP02836.1 hypothetical protein [Pseudomonadota bacterium] diamond 255 64.3 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
26768066 26768066 PRJNA753151_S_NODE_289941_length_163_cov_3.000000_g287651_i0 PRJNA753151 289941 163 3 4.89 Pelagibacterium lacus 2282655 Bacteria Bacteria 55.8 2.96e-7   NR WP_199562619.1 2282655 g287651 i0 63.9 1.32515337423313 36 13 66.3 0 162 55 19 54 WP_199562619.1 hypothetical protein, partial [Pelagibacterium lacus] diamond 216 55.8 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Devosiaceae Pelagibacterium Pelagibacterium lacus
26799673 26799673 PRJNA753151_S_NODE_266121_length_172_cov_3.139535_g263831_i0 PRJNA753151 266121 172 3.139535 5.4000002 Phreatobacter stygius 1940610 Bacteria Bacteria 42.7 0.0138   NR WP_136961745.1 1940610 g263831 i0 39.5 0.662790697674419 38 23 66.3 0 125 12 178 215 WP_136961745.1 branched-chain amino acid ABC transporter permease [Phreatobacter stygius] diamond 114 42.7 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Phreatobacteraceae Phreatobacter Phreatobacter stygius
26999313 26999313 PRJNA753151_S_NODE_207662_length_200_cov_1.853503_g205372_i0 PRJNA753151 207662 200 1.853503 3.707006 root 1 Root_unresolved Root_unresolved 53.9 2.39e-6   NR WP_270939599.1 287 g205372 i0 56.1 46.53 66 29 99 0 1 198 351 416 WP_270939599.1 type II CRISPR RNA-guided endonuclease Cas9, partial [Pseudomonas aeruginosa] diamond 9306 53.9 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas aeruginosa
27536762 27536762 PRJNA753151_S_NODE_137303_length_247_cov_2.279412_g135013_i0 PRJNA753151 137303 247 2.279412 5.63014764 root 1 Root_unresolved Root_unresolved 87.4 7.36e-18   NR WP_270939599.1 287 g135013 i0 61.8 46.6396761133603 76 29 92.3 0 246 19 406 481 WP_270939599.1 type II CRISPR RNA-guided endonuclease Cas9, partial [Pseudomonas aeruginosa] diamond 11520 87.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas aeruginosa
27821048 27821048 PRJNA753151_S_NODE_253204_length_178_cov_1.333333_g250914_i0 PRJNA753151 253204 178 1.333333 2.37333274 root 1 Root_unresolved Root_unresolved 82.8 1.2e-16   NR WP_270939598.1 287 g250914 i0 77.2 38.4269662921348 57 13 96.1 0 174 4 219 275 WP_270939598.1 type II CRISPR RNA-guided endonuclease Cas9, partial [Pseudomonas aeruginosa] diamond 6840 82.8 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas aeruginosa
27978713 27978713 PRJNA753151_S_NODE_153905_length_234_cov_2.806283_g151615_i0 PRJNA753151 153905 234 2.806283 6.56670222 root 1 Root_unresolved Root_unresolved 68.6 2.64e-11   NR WP_270939598.1 287 g151615 i0 60.7 32.0641025641026 61 24 78.2 0 233 51 464 524 WP_270939598.1 type II CRISPR RNA-guided endonuclease Cas9, partial [Pseudomonas aeruginosa] diamond 7503 68.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas aeruginosa
28347760 28347760 PRJNA753151_S_NODE_285086_length_165_cov_2.065574_g282796_i0 PRJNA753151 285086 165 2.065574 3.4081971 Pseudomonas syringae group genomosp. 7 251699 Bacteria Bacteria 40.4 0.045   NR WP_395573843.1 251699 g282796 i0 49.2 1.14545454545455 63 9 78.2 4 11 139 63 122 WP_395573843.1 hypothetical protein, partial [Pseudomonas syringae group genomosp. 7] diamond 189 40.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas syringae group genomosp. 7
28452513 28452513 PRJNA753151_S_NODE_179186_length_217_cov_1.551724_g176896_i0 PRJNA753151 179186 217 1.551724 3.36724108 Pseudomonas 286 Bacteria Bacteria 138 7.29e-36   NR WP_106119935.1 321846 g176896 i0 98.6 1.99078341013825 72 1 99.5 0 216 1 386 457 WP_106119935.1 phage tail tape measure protein [Pseudomonas simiae] diamond 432 138 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas simiae
28663610 28663610 PRJNA753151_S_NODE_236987_length_185_cov_1.901408_g234697_i0 PRJNA753151 236987 185 1.901408 3.5176048 Curvibacter sp. 1888168 Bacteria Bacteria 126 6.969999999999999e-32   NR RUP29152.1 1888168 g234697 i0 100 0.989189189189189 61 0 98.9 0 2 184 2122 2182 RUP29152.1 MAG: choice-of-anchor D domain-containing protein, partial [Curvibacter sp.] diamond 183 126 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Comamonadaceae Curvibacter Curvibacter sp.
29021017 29021017 PRJNA753151_S_NODE_260288_length_175_cov_1.363636_g257998_i0 PRJNA753151 260288 175 1.363636 2.386363 root 1 Root_unresolved Root_unresolved 54.3 1.21e-6   NR WP_270939598.1 287 g257998 i0 54.4 56.52 57 26 97.7 0 173 3 399 455 WP_270939598.1 type II CRISPR RNA-guided endonuclease Cas9, partial [Pseudomonas aeruginosa] diamond 9891 54.3 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas aeruginosa
29620130 29620130 PRJNA753151_S_NODE_282210_length_166_cov_2.195122_g279920_i0 PRJNA753151 282210 166 2.195122 3.64390252 root 1 Root_unresolved Root_unresolved 78.6 2.94e-15   NR WP_341384898.1 573 g279920 i0 72.2 87.8132530120482 54 15 97.6 0 164 3 182 235 WP_341384898.1 hypothetical protein [Klebsiella pneumoniae] diamond 14577 78.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
29651770 29651770 PRJNA753151_S_NODE_213330_length_197_cov_1.753247_g211040_i0 PRJNA753151 213330 197 1.753247 3.45389659 Pseudomonas 286 Bacteria Bacteria 41.2 0.0494   NR MFH7346609.1 129140 g211040 i0 49.4 2.11675126903553 77 18 92.9 7 9 191 57 128 MFH7346609.1 hypothetical protein [Pseudomonas syringae pv. tagetis] diamond 417 41.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas syringae group genomosp. 7
29936484 29936484 PRJNA753151_S_NODE_20011_length_504_cov_1.318872_g17926_i0 PRJNA753151 20011 504 1.318872 6.64711488 root 1 Root_unresolved Root_unresolved 206 8.55e-60   NR WP_270939599.1 287 g17926 i0 62.9 47.6845238095238 167 62 99.4 0 4 504 424 590 WP_270939599.1 type II CRISPR RNA-guided endonuclease Cas9, partial [Pseudomonas aeruginosa] diamond 24033 206 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas aeruginosa
30031214 30031214 PRJNA753151_S_NODE_246571_length_181_cov_0.978261_g244281_i0 PRJNA753151 246571 181 0.978261 1.77065241 root 1 Root_unresolved Root_unresolved 53.9 1.88e-6   NR WP_270939598.1 287 g244281 i0 57.1 39.9116022099448 56 24 92.8 0 181 14 569 624 WP_270939598.1 type II CRISPR RNA-guided endonuclease Cas9, partial [Pseudomonas aeruginosa] diamond 7224 54.3 0.992633517495396 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas aeruginosa
30400926 30400926 PRJNA753151_S_NODE_234673_length_186_cov_1.965035_g232383_i0 PRJNA753151 234673 186 1.965035 3.6549651 Burkholderiaceae bacterium 2030806 Bacteria Bacteria 45.1 0.00266   NR HEU5297290.1 2030806 g232383 i0 39.2 0.82258064516129 51 27 75.8 1 27 167 657 707 HEU5297290.1 DUF2339 domain-containing protein [Burkholderiaceae bacterium] diamond 153 45.1 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae   Burkholderiaceae bacterium
30473636 30473636 PRJNA753151_S_NODE_145953_length_240_cov_2.862944_g143663_i0 PRJNA753151 145953 240 2.862944 6.8710656 root 1 Root_unresolved Root_unresolved 85.9 2.27e-17   NR WP_270939599.1 287 g143663 i0 65.8 40.4875 79 27 98.8 0 3 239 213 291 WP_270939599.1 type II CRISPR RNA-guided endonuclease Cas9, partial [Pseudomonas aeruginosa] diamond 9717 85.9 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas aeruginosa
30526765 30526765 PRJNA753151_S_NODE_162593_length_228_cov_1.675676_g160303_i0 PRJNA753151 162593 228 1.675676 3.82054128 Klebsiella pneumoniae 573 Bacteria Bacteria 40.8 0.0338   NR MCP6042812.1 573 g160303 i0 32.7 0.723684210526316 55 32 72.4 1 44 208 32 81 MCP6042812.1 PhoH family protein [Klebsiella pneumoniae] diamond 165 40.8 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
30599735 30599735 PRJNA753151_S_NODE_303013_length_159_cov_1.301724_g300723_i0 PRJNA753151 303013 159 1.301724 2.06974116 root 1 Root_unresolved Root_unresolved 52 6.36e-6   NR WP_270939598.1 287 g300723 i0 65.9 38.6792452830189 41 14 77.4 0 128 6 350 390 WP_270939598.1 type II CRISPR RNA-guided endonuclease Cas9, partial [Pseudomonas aeruginosa] diamond 6150 52 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas aeruginosa
30716289 30716289 PRJNA753151_S_NODE_301174_length_159_cov_2.956897_g298884_i0 PRJNA753151 301174 159 2.956897 4.70146623 Pseudomonas syringae group genomosp. 7 251699 Bacteria Bacteria 41.6 0.0183   NR WP_395573649.1 251699 g298884 i0 57.7 0.981132075471698 52 17 96.2 3 3 155 37 84 WP_395573649.1 hypothetical protein, partial [Pseudomonas syringae group genomosp. 7] diamond 156 41.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas syringae group genomosp. 7
30748037 30748037 PRJNA753151_S_NODE_157114_length_232_cov_1.354497_g154824_i0 PRJNA753151 157114 232 1.354497 3.14243304 Pinisolibacter aquiterrae 2815579 Bacteria Bacteria 42.4 0.0421   NR WP_217928410.1 2815579 g154824 i0 33.3 0.698275862068966 54 34 67.2 1 8 163 180 233 WP_217928410.1 hypothetical protein [Pinisolibacter aquiterrae] diamond 162 42.4 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Ancalomicrobiaceae Pinisolibacter Pinisolibacter aquiterrae
31032624 31032624 PRJNA753151_S_NODE_115375_length_266_cov_10.587444_g113085_i0 PRJNA753151 115375 266 10.587444 28.16260104 Shigella sonnei 624 Bacteria Bacteria 108 1.3e-28   NR WP_353763804.1 624 g113085 i0 95.1 0.68796992481203 61 2 68.8 1 185 3 23 82 WP_353763804.1 hypothetical protein, partial [Shigella sonnei] diamond 183 108 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Shigella Shigella sonnei
31064187 31064187 PRJNA753151_S_NODE_101415_length_281_cov_3.025210_g99125_i0 PRJNA753151 101415 281 3.02521 8.5008401 Pseudomonas syringae group genomosp. 7 251699 Bacteria Bacteria 43.9 0.0217   NR WP_395583812.1 251699 g99125 i0 30.9 0.864768683274021 81 50 80.1 1 231 7 2 82 WP_395583812.1 hypothetical protein, partial [Pseudomonas syringae group genomosp. 7] diamond 243 43.9 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas syringae group genomosp. 7
31064188 31064188 PRJNA753151_S_NODE_218775_length_194_cov_2.125828_g216485_i0 PRJNA753151 218775 194 2.125828 4.12410632 Pseudomonas aeruginosa 287 Bacteria Bacteria 90.9 1.1500000000000002e-21   NR WP_367005107.1 287 g216485 i0 97.7 1.36082474226804 44 1 68 0 37 168 62 105 WP_367005107.1 hypothetical protein, partial [Pseudomonas aeruginosa] diamond 264 90.9 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas aeruginosa
32307699 32307699 PRJNA753151_S_NODE_305459_length_158_cov_1.565217_g303169_i0 PRJNA753151 305459 158 1.565217 2.47304286 root 1 Root_unresolved Root_unresolved 52.4 4.63e-6   NR WP_270939599.1 287 g303169 i0 69.7 34.1962025316456 33 10 62.7 0 3 101 489 521 WP_270939599.1 type II CRISPR RNA-guided endonuclease Cas9, partial [Pseudomonas aeruginosa] diamond 5403 52.8 0.992424242424242 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas aeruginosa

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