RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

33 rows where analysis = "diamond", bioproject = "PRJNA663960" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 33 ✖

tax_kingdom 1

bioproject 1

  • PRJNA663960 · 33 ✖

analysis 1

  • diamond · 33 ✖

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
628751 628751 PRJNA663960_S_NODE_33021_length_211_cov_3.731707_g32785_i0 PRJNA663960 33021 211 3.731707 7.87390177 Bacteria 2 Bacteria Bacteria 91.7 3.69e-21   NR WP_141707207.1 723171 g32785 i0 58.6 15.9241706161137 70 29 99.5 0 2 211 90 159 WP_141707207.1 RecQ family ATP-dependent DNA helicase, partial [Vibrio genomosp. F10] diamond 3360 92 0.996739130434783 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Vibrionales Vibrionaceae Vibrio Vibrio genomosp. F10
8282061 8282061 PRJNA663960_S_NODE_52107_length_168_cov_1.049587_g51871_i0 PRJNA663960 52107 168 1.049587 1.76330616 Sphingomonas 13687 Bacteria Bacteria 111 3.8e-29   NR WP_288045031.1 28214 g51871 i0 98.2 1.96428571428571 55 1 98.2 0 167 3 25 79 WP_288045031.1 glutathione S-transferase family protein, partial [Sphingomonas sp.] diamond 330 111 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas Sphingomonas sp.
17206658 17206658 PRJNA663960_S_NODE_19954_length_265_cov_3.885321_g19718_i0 PRJNA663960 19954 265 3.885321 10.29610065 Escherichia coli 562 Bacteria Bacteria 62.8 1e-10   NR WP_329793016.1 562 g19718 i0 56.4 0.622641509433962 55 24 62.3 0 179 15 1 55 WP_329793016.1 hypothetical protein, partial [Escherichia coli] diamond 165 62.8 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
26796658 26796658 PRJNA663960_S_NODE_47101_length_177_cov_1.176923_g46865_i0 PRJNA663960 47101 177 1.176923 2.08315371 Klebsiella pneumoniae 573 Bacteria Bacteria 41.6 0.00824   NR WP_305205333.1 573 g46865 i0 73.9 0.389830508474576 23 6 39 0 2 70 62 84 WP_305205333.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 69 41.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
27049959 27049959 PRJNA663960_S_NODE_19082_length_270_cov_2.439462_g18846_i0 PRJNA663960 19082 270 2.439462 6.5865474 Paraglaciecola agarilytica 368405 Bacteria Bacteria 45.8 0.00375   NR WP_379066239.1 395568 g18846 i0 49 1.72222222222222 49 16 53.3 2 256 113 148 188 WP_379066239.1 hypothetical protein, partial [Paraglaciecola agarilytica] diamond 465 45.8 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Alteromonadales Alteromonadaceae Paraglaciecola Paraglaciecola agarilytica
27081433 27081433 PRJNA663960_S_NODE_22202_length_254_cov_2.410628_g21966_i0 PRJNA663960 22202 254 2.410628 6.12299512 Halomonas hibernica 2591147 Bacteria Bacteria 92.4 6.47e-20   NR WP_172119098.1 2591147 g21966 i0 55.4 0.980314960629921 83 36 96.9 1 252 7 97 179 WP_172119098.1 MobV family relaxase [Halomonas hibernica] diamond 249 92.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Oceanospirillales Halomonadaceae Halomonas Halomonas hibernica
27144253 27144253 PRJNA663960_S_NODE_61182_length_158_cov_2.297297_g60946_i0 PRJNA663960 61182 158 2.297297 3.62972926 unclassified Thioalkalivibrio 2621013 Bacteria Bacteria 63.9 3.59e-10   NR WP_019025382.1 2621013 g60946 i0 53.8 0.987341772151899 52 24 98.7 0 1 156 291 342 WP_019025382.1 MULTISPECIES: helix-hairpin-helix domain-containing protein [unclassified Thioalkalivibrio] diamond 156 63.9 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Chromatiales Ectothiorhodospiraceae Thioalkalivibrio  
27523818 27523818 PRJNA663960_S_NODE_36143_length_202_cov_2.509677_g35907_i0 PRJNA663960 36143 202 2.509677 5.06954754 Escherichia coli 562 Bacteria Bacteria 43.9 0.00132   NR WP_205008163.1 562 g35907 i0 57.1 0.51980198019802 35 15 52 0 132 28 40 74 WP_205008163.1 hypothetical protein, partial [Escherichia coli] diamond 105 43.9 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
27713674 27713674 PRJNA663960_S_NODE_28164_length_228_cov_3.016575_g27928_i0 PRJNA663960 28164 228 3.016575 6.877791 Klebsiella pneumoniae 573 Bacteria Bacteria 42.7 0.00543   NR WP_305205333.1 573 g27928 i0 81 0.276315789473684 21 4 27.6 0 12 74 64 84 WP_305205333.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 63 42.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
27788655 27788655 PRJNA663960_S_NODE_13664_length_304_cov_1.190661_g13428_i0 PRJNA663960 13664 304 1.190661 3.61960944 root 1 Root_unresolved Root_unresolved 70.9 4.98e-13   NR MBD3612052.1 39765 g13428 i0 43.3 1.70723684210526 90 49 88.8 1 299 30 52 139 MBD3612052.1 hypothetical protein [Hydrogenovibrio crunogenus] diamond 519 70.9 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Thiotrichales Piscirickettsiaceae Hydrogenovibrio Hydrogenovibrio crunogenus
28261977 28261977 PRJNA663960_S_NODE_52966_length_166_cov_1.714286_g52730_i0 PRJNA663960 52966 166 1.714286 2.84571476 Oceanospirillales 135619 Bacteria Bacteria 85.1 1.55e-17   NR WP_076517621.1 484498 g52730 i0 85.5 2.94578313253012 55 8 99.4 0 166 2 247 301 WP_076517621.1 hypothetical protein [Thalassolituus maritimus] diamond 489 85.9 0.990686845168801 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Oceanospirillales Oceanospirillaceae Thalassolituus Thalassolituus maritimus
28376222 28376222 PRJNA663960_S_NODE_16306_length_286_cov_5.552301_g16070_i0 PRJNA663960 16306 286 5.552301 15.87958086 Pseudomonas aeruginosa 287 Bacteria Bacteria 42 0.0325   NR MBN0903875.1 287 g16070 i0 30.2 0.660839160839161 63 41 62.9 1 272 93 38 100 MBN0903875.1 LysR family transcriptional regulator [Pseudomonas aeruginosa] diamond 189 42 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas aeruginosa
28376226 28376226 PRJNA663960_S_NODE_61446_length_158_cov_1.378378_g61210_i0 PRJNA663960 61446 158 1.378378 2.17783724 Succinivibrionaceae bacterium 2053620 Bacteria Bacteria 106 2.6600000000000003e-27   NR MDY6375923.1 2053620 g61210 i0 100 1.9746835443038 52 0 98.7 0 156 1 112 163 MDY6375923.1 DUF4143 domain-containing protein [Succinivibrionaceae bacterium] diamond 312 106 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Aeromonadales Succinivibrionaceae   Succinivibrionaceae bacterium
29323413 29323413 PRJNA663960_S_NODE_13469_length_305_cov_2.616279_g13233_i0 PRJNA663960 13469 305 2.616279 7.97965095 Halomonadaceae 28256 Bacteria Bacteria 82 1.04e-16   NR WP_031383959.1 28256 g13233 i0 50 2.14426229508197 72 36 70.8 0 82 297 33 104 WP_031383959.1 MULTISPECIES: outer membrane lipoprotein chaperone LolA [Halomonadaceae] diamond 654 82 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Oceanospirillales Halomonadaceae    
29449594 29449594 PRJNA663960_S_NODE_41710_length_188_cov_3.517730_g41474_i0 PRJNA663960 41710 188 3.51773 6.6133324 Klebsiella pneumoniae 573 Bacteria Bacteria 39.3 0.0303   NR MBL1488551.1 573 g41474 i0 53.6 0.446808510638298 28 13 44.7 0 26 109 3 30 MBL1488551.1 arginase [Klebsiella pneumoniae] diamond 84 39.3 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
29461663 29461663 PRJNA663960_S_NODE_17170_length_281_cov_3.243590_g16934_i0 PRJNA663960 17170 281 3.24359 9.1144879 root 1 Root_unresolved Root_unresolved 56.6 8.38e-8   NR WP_318767904.1 562 g16934 i0 43.6 1.66548042704626 78 35 82.2 2 2 232 5 74 WP_318767904.1 reverse transcriptase domain-containing protein, partial [Escherichia coli] diamond 468 56.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
29575896 29575896 PRJNA663960_S_NODE_53810_length_165_cov_1.296610_g53574_i0 PRJNA663960 53810 165 1.29661 2.1394065 Rheinheimera sp. 1869214 Bacteria Bacteria 103 3.5e-24   NR HAT40198.1 1869214 g53574 i0 92.6 0.981818181818182 54 4 98.2 0 3 164 42 95 HAT40198.1 exonuclease subunit SbcC [Rheinheimera sp.] diamond 162 103 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Chromatiales Chromatiaceae Rheinheimera Rheinheimera sp.
29638947 29638947 PRJNA663960_S_NODE_56570_length_163_cov_0.879310_g56334_i0 PRJNA663960 56570 163 0.87931 1.4332753 Sphingomonas sp. PL2 28214 Bacteria Bacteria 103 6.52e-24   NR WP_209609748.1 2760712 g56334 i0 100 0.993865030674847 54 0 99.4 0 2 163 396 449 WP_209609748.1 AAA family ATPase [Sphingomonas sp. PL20] diamond 162 103 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas Sphingomonas sp. PL20
29651003 29651003 PRJNA663960_S_NODE_19310_length_269_cov_1.837838_g19074_i0 PRJNA663960 19310 269 1.837838 4.94378422 Bosea 85413 Bacteria Bacteria 115 2.1e-28   NR WP_069052471.1 1842539 g19074 i0 59.6 1.98513011152416 89 36 99.3 0 3 269 243 331 WP_069052471.1 type II secretion system F family protein [Bosea sp. RAC05] diamond 534 115 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Boseaceae Bosea Bosea sp. RAC05
29733752 29733752 PRJNA663960_S_NODE_40390_length_192_cov_1.000000_g40154_i0 PRJNA663960 40390 192 1 1.92 Klebsiella pneumoniae 573 Bacteria Bacteria 45.1 3.52e-4   NR WP_416493070.1 573 g40154 i0 44.2 0.8125 52 29 81.3 0 6 161 21 72 WP_416493070.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 156 45.1 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
30713343 30713343 PRJNA663960_S_NODE_33214_length_211_cov_1.298780_g32978_i0 PRJNA663960 33214 211 1.29878 2.7404258 Sphingomonas sp. BE137 2817844 Bacteria Bacteria 88.2 3.8600000000000005e-21   NR MDR6847297.1 2817844 g32978 i0 100 0.597156398104265 42 0 59.7 0 209 84 31 72 MDR6847297.1 hypothetical protein [Sphingomonas sp. BE137] diamond 126 88.2 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas Sphingomonas sp. BE137
30903012 30903012 PRJNA663960_S_NODE_31374_length_217_cov_1.200000_g31138_i0 PRJNA663960 31374 217 1.2 2.604 Rheinheimera sp. 1869214 Bacteria Bacteria 129 1.06e-35   NR HAT40886.1 1869214 g31138 i0 90.3 0.995391705069124 72 7 99.5 0 2 217 34 105 HAT40886.1 toluene tolerance protein [Rheinheimera sp.] diamond 216 129 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Chromatiales Chromatiaceae Rheinheimera Rheinheimera sp.
30934659 30934659 PRJNA663960_S_NODE_39274_length_194_cov_2.095238_g39038_i0 PRJNA663960 39274 194 2.095238 4.06476172 Szabonella alba 2804194 Bacteria Bacteria 45.1 0.00292   NR WP_202686546.1 2804194 g39038 i0 41.2 0.788659793814433 51 23 72.7 2 165 25 117 164 WP_202686546.1 NAD(P)/FAD-dependent oxidoreductase [Szabonella alba] diamond 153 45.1 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodobacterales Paracoccaceae Szabonella Szabonella alba
30978435 30978435 PRJNA663960_S_NODE_53334_length_166_cov_1.033613_g53098_i0 PRJNA663960 53334 166 1.033613 1.71579758 root 1 Root_unresolved Root_unresolved 48.9 1.02e-5   NR WP_204985521.1 562 g53098 i0 60 6.30722891566265 35 14 63.3 0 151 47 45 79 WP_204985521.1 hypothetical protein, partial [Escherichia coli] diamond 1047 48.9 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
31282055 31282055 PRJNA663960_S_NODE_42615_length_186_cov_3.050360_g42379_i0 PRJNA663960 42615 186 3.05036 5.6736696 Klebsiella pneumoniae 573 Bacteria Bacteria 42 0.0157   NR WP_220492980.1 573 g42379 i0 58.1 1 31 13 50 0 82 174 19 49 WP_220492980.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 186 42 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
31724898 31724898 PRJNA663960_S_NODE_47117_length_177_cov_1.176923_g46881_i0 PRJNA663960 47117 177 1.176923 2.08315371 unclassified Sphingomonas 196159 Bacteria Bacteria 104 9.71e-25   NR WP_033965891.1 196159 g46881 i0 100 0.983050847457627 58 0 98.3 0 2 175 194 251 WP_033965891.1 MULTISPECIES: sensor histidine kinase [unclassified Sphingomonas] diamond 174 104 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas  
32294837 32294837 PRJNA663960_S_NODE_28779_length_226_cov_2.150838_g28543_i0 PRJNA663960 28779 226 2.150838 4.86089388 Crenobacter cavernae 2290923 Bacteria Bacteria 46.6 0.00133   NR WP_129212706.1 2290923 g28543 i0 34.2 1.00884955752212 76 42 90.3 1 225 22 698 773 WP_129212706.1 DNA topoisomerase IV subunit A [Crenobacter cavernae] diamond 228 46.6 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Neisseriales Neisseriaceae Crenobacter Crenobacter cavernae
32433399 32433399 PRJNA663960_S_NODE_55859_length_163_cov_1.318966_g55623_i0 PRJNA663960 55859 163 1.318966 2.14991458 Bacteria 2 Bacteria Bacteria 41.2 0.0092   NR MQK21928.1 562 g55623 i0 58.6 2.00613496932515 29 12 53.4 0 155 69 22 50 MQK21928.1 DUF1725 domain-containing protein [Escherichia coli] diamond 327 41.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
32464969 32464969 PRJNA663960_S_NODE_16559_length_285_cov_2.386555_g16323_i0 PRJNA663960 16559 285 2.386555 6.80168175 Rhodoferax 28065 Bacteria Bacteria 43.9 0.0246   NR MCB1981292.1 50421 g16323 i0 38.5 1.09473684210526 52 32 54.7 0 258 103 461 512 MCB1981292.1 VWA domain-containing protein [Rhodoferax sp.] diamond 312 43.9 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Comamonadaceae Rhodoferax Rhodoferax sp.
32528315 32528315 PRJNA663960_S_NODE_49179_length_173_cov_1.214286_g48943_i0 PRJNA663960 49179 173 1.214286 2.10071478 root 1 Root_unresolved Root_unresolved 66.6 1.28e-12   NR MDD0241708.1 623 g48943 i0 66.7 2.30635838150289 45 15 78 0 10 144 3 47 MDD0241708.1 hypothetical protein [Shigella flexneri] diamond 399 66.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Shigella Shigella flexneri
32673464 32673464 PRJNA663960_S_NODE_10520_length_329_cov_2.304965_g10284_i0 PRJNA663960 10520 329 2.304965 7.58333485 Escherichia coli 562 Bacteria Bacteria 48.9 9.4e-5   NR WP_329820420.1 562 g10284 i0 63.2 0.346504559270517 38 14 34.7 0 204 91 14 51 WP_329820420.1 hypothetical protein, partial [Escherichia coli] diamond 114 48.9 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
32673466 32673466 PRJNA663960_S_NODE_42320_length_187_cov_1.457143_g42084_i0 PRJNA663960 42320 187 1.457143 2.72485741 Succinivibrio sp. 2053619 Bacteria Bacteria 45.4 8.81e-4   NR MBQ2268559.1 2053619 g42084 i0 100 0.352941176470588 22 0 35.3 0 186 121 125 146 MBQ2268559.1 NirD/YgiW/YdeI family stress tolerance protein [Succinivibrio sp.] diamond 66 45.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Aeromonadales Succinivibrionaceae Succinivibrio Succinivibrio sp.
32768024 32768024 PRJNA663960_S_NODE_63160_length_157_cov_0.927273_g62924_i0 PRJNA663960 63160 157 0.927273 1.45581861 Pseudomonas huaxiensis 2213017 Bacteria Bacteria 67 1.57e-11   NR WP_110969713.1 2213017 g62924 i0 61.5 2.98089171974522 52 20 99.4 0 157 2 169 220 WP_110969713.1 ABC transporter substrate-binding protein [Pseudomonas huaxiensis] diamond 468 67 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas huaxiensis

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