RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJNA547066" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 21 ✖

tax_kingdom 1

bioproject 1

  • PRJNA547066 · 21 ✖

analysis 1

  • diamond · 21 ✖

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
5615400 5615400 PRJNA547066_P_NODE_5605_length_159_cov_1.290323_g5511_i0 PRJNA547066 5605 159 1.290323 2.05161357 root 1 Root_unresolved Root_unresolved 114 1.02e-28   NR HAL9819988.1 562 g5511 i0 100 5 53 0 100 0 159 1 111 163 HAL9819988.1 MobA/MobL family protein [Escherichia coli] diamond 795 114 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
26729325 26729325 PRJNA547066_P_NODE_3581_length_225_cov_1.678947_g3487_i0 PRJNA547066 3581 225 1.678947 3.77763075 Acinetobacter nectaris 1219382 Bacteria Bacteria 97.1 2.23e-21   NR WP_237416191.1 1219382 g3487 i0 64.8 0.946666666666667 71 25 94.7 0 223 11 136 206 WP_237416191.1 relaxase/mobilization nuclease domain-containing protein [Acinetobacter nectaris] diamond 213 97.1 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter nectaris
27092735 27092735 PRJNA547066_P_NODE_4742_length_179_cov_1.666667_g4648_i0 PRJNA547066 4742 179 1.666667 2.98333393 root 1 Root_unresolved Root_unresolved 126 1.04e-34   NR HAL9334457.1 562 g4648 i0 100 5.93296089385475 59 0 98.9 0 179 3 21 79 HAL9334457.1 MobA/MobL family protein [Escherichia coli] diamond 1062 126 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
27773073 27773073 PRJNA547066_P_NODE_3784_length_215_cov_1.372222_g3690_i0 PRJNA547066 3784 215 1.372222 2.9502773 Sphingomonadaceae 41297 Bacteria Bacteria 138 5.13e-36   NR WP_281124192.1 41297 g3690 i0 94.4 0.990697674418605 71 4 99.1 0 215 3 281 351 WP_281124192.1 MULTISPECIES: hypothetical protein [Sphingomonadaceae] diamond 213 138 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae    
27867461 27867461 PRJNA547066_P_NODE_2845_length_269_cov_1.705128_g2751_i0 PRJNA547066 2845 269 1.705128 4.58679432 Acinetobacter nectaris 1219382 Bacteria Bacteria 48.9 3.46e-4   NR WP_237416191.1 1219382 g2751 i0 36.4 0.981412639405205 88 49 98.1 2 6 269 566 646 WP_237416191.1 relaxase/mobilization nuclease domain-containing protein [Acinetobacter nectaris] diamond 264 48.9 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter nectaris
27930754 27930754 PRJNA547066_P_NODE_4465_length_187_cov_1.046053_g4371_i0 PRJNA547066 4465 187 1.046053 1.95611911 Actinobacillus pleuropneumoniae 715 Bacteria Bacteria 49.3 1.43e-5   NR WP_267994754.1 715 g4371 i0 70 0.481283422459893 30 9 48.1 0 94 5 28 57 WP_267994754.1 hypothetical protein, partial [Actinobacillus pleuropneumoniae] diamond 90 49.3 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pasteurellales Pasteurellaceae Actinobacillus Actinobacillus pleuropneumoniae
28088506 28088506 PRJNA547066_P_NODE_3705_length_219_cov_1.793478_g3611_i0 PRJNA547066 3705 219 1.793478 3.92771682 Rheinheimera sp. 1869214 Bacteria Bacteria 132 3.1199999999999995e-35   NR HAT41570.1 1869214 g3611 i0 93.2 1 73 5 100 0 219 1 225 297 HAT41570.1 beta-aspartyl-peptidase [Rheinheimera sp.] diamond 219 132 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Chromatiales Chromatiaceae Rheinheimera Rheinheimera sp.
28530817 28530817 PRJNA547066_P_NODE_3067_length_253_cov_1.100917_g2973_i0 PRJNA547066 3067 253 1.100917 2.78532001 unclassified Sphingomonas 196159 Bacteria Bacteria 164 1.28e-47   NR WP_137902292.1 196159 g2973 i0 100 0.984189723320158 83 0 98.4 0 3 251 56 138 WP_137902292.1 MULTISPECIES: GTP 3',8-cyclase MoaA [unclassified Sphingomonas] diamond 249 164 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas  
28593908 28593908 PRJNA547066_P_NODE_4967_length_174_cov_0.812950_g4873_i0 PRJNA547066 4967 174 0.81295 1.414533 Escherichia coli 562 Bacteria Bacteria 45.8 1.13e-4   NR MDW3502867.1 562 g4873 i0 35.3 0.879310344827586 51 33 87.9 0 16 168 1 51 MDW3502867.1 hypothetical protein [Escherichia coli] diamond 153 45.8 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
28829550 28829550 PRJNA547066_P_NODE_4568_length_184_cov_1.342282_g4474_i0 PRJNA547066 4568 184 1.342282 2.46979888 root 1 Root_unresolved Root_unresolved 116 3.96e-32   NR HAL9979905.1 562 g4474 i0 100 4.89130434782609 60 0 97.8 0 182 3 33 92 HAL9979905.1 hypothetical protein [Escherichia coli] diamond 900 116 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
28909257 28909257 PRJNA547066_P_NODE_348_length_813_cov_44.723650_g292_i0 PRJNA547066 348 813 44.72365 363.6032745 Enterobacter hormaechei 158836 Bacteria Bacteria 134 5.11e-36   NR WP_096179768.1 158836 g292 i0 99.1 0.413284132841328 112 1 41.3 0 338 3 1 112 WP_096179768.1 hypothetical protein, partial [Enterobacter hormaechei] diamond 336 134 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Enterobacter Enterobacter hormaechei
28941352 28941352 PRJNA547066_P_NODE_2048_length_339_cov_1.976974_g1954_i0 PRJNA547066 2048 339 1.976974 6.70194186 Acinetobacter nectaris 1219382 Bacteria Bacteria 84.3 2.89e-16   NR WP_237416191.1 1219382 g1954 i0 70.4 0.47787610619469 54 16 47.8 0 176 337 1 54 WP_237416191.1 relaxase/mobilization nuclease domain-containing protein [Acinetobacter nectaris] diamond 162 84.3 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter nectaris
29383250 29383250 PRJNA547066_P_NODE_2149_length_332_cov_1.474747_g2055_i0 PRJNA547066 2149 332 1.474747 4.89616004 Acinetobacter junii 40215 Bacteria Bacteria 205 2.07e-63   NR WP_368567254.1 40215 g2055 i0 88.1 1.82530120481928 101 12 91.3 0 304 2 10 110 WP_368567254.1 replication initiation protein [Acinetobacter junii] diamond 606 205 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter junii
29825051 29825051 PRJNA547066_P_NODE_5551_length_160_cov_1.272000_g5457_i0 PRJNA547066 5551 160 1.272 2.0352 Klebsiella pneumoniae 573 Bacteria Bacteria 45.1 2.28e-4   NR WP_416493070.1 573 g5457 i0 49 0.91875 49 25 91.9 0 12 158 14 62 WP_416493070.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 147 45.1 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
30520233 30520233 PRJNA547066_P_NODE_1533_length_395_cov_2.022222_g1440_i0 PRJNA547066 1533 395 2.022222 7.9877769 Acinetobacter nectaris 1219382 Bacteria Bacteria 114 1.3e-26   NR WP_237416191.1 1219382 g1440 i0 44.4 1.0253164556962 135 63 98.7 3 5 394 668 795 WP_237416191.1 relaxase/mobilization nuclease domain-containing protein [Acinetobacter nectaris] diamond 405 114 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter nectaris
30804623 30804623 PRJNA547066_P_NODE_6174_length_150_cov_1.382609_g6080_i0 PRJNA547066 6174 150 1.382609 2.0739135 Acinetobacter 469 Bacteria Bacteria 105 4.78e-26   NR WP_087696032.1 469 g6080 i0 100 1 50 0 100 0 1 150 214 263 WP_087696032.1 MULTISPECIES: pyridoxal-phosphate dependent enzyme [Acinetobacter] diamond 150 105 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter  
31278505 31278505 PRJNA547066_P_NODE_1475_length_402_cov_1.408719_g1382_i0 PRJNA547066 1475 402 1.408719 5.66305038 Acinetobacter nectaris 1219382 Bacteria Bacteria 69.3 1.81e-11   NR WP_237416078.1 1219382 g1382 i0 81.6 0.283582089552239 38 7 28.4 0 287 400 16 53 WP_237416078.1 plasmid mobilization relaxosome protein MobC [Acinetobacter nectaris] diamond 114 69.3 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter nectaris
31595152 31595152 PRJNA547066_P_NODE_3896_length_209_cov_2.028736_g3802_i0 PRJNA547066 3896 209 2.028736 4.24005824 Rubrivivax sp. 50259 Bacteria Bacteria 42.4 0.0323   NR MCC7150554.1 50259 g3802 i0 44.2 0.746411483253589 52 27 74.6 1 199 44 238 287 MCC7150554.1 hypothetical protein [Rubrivivax sp.] diamond 156 42.4 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Sphaerotilaceae Rubrivivax Rubrivivax sp.
31689715 31689715 PRJNA547066_P_NODE_5957_length_153_cov_2.703390_g5863_i0 PRJNA547066 5957 153 2.70339 4.1361867 Sphingomonadaceae 41297 Bacteria Bacteria 106 3.47e-25   NR WP_281124192.1 41297 g5863 i0 98 1 51 1 100 0 1 153 178 228 WP_281124192.1 MULTISPECIES: hypothetical protein [Sphingomonadaceae] diamond 153 106 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae    
32795799 32795799 PRJNA547066_P_NODE_5080_length_171_cov_1.470588_g4986_i0 PRJNA547066 5080 171 1.470588 2.51470548 Acinetobacter nectaris 1219382 Bacteria Bacteria 73.6 1.96e-13   NR WP_237416191.1 1219382 g4986 i0 65.5 0.964912280701754 55 19 96.5 0 1 165 209 263 WP_237416191.1 relaxase/mobilization nuclease domain-containing protein [Acinetobacter nectaris] diamond 165 73.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter nectaris
32890353 32890353 PRJNA547066_P_NODE_320_length_859_cov_1.953883_g268_i0 PRJNA547066 320 859 1.953883 16.78385497 Acinetobacter nectaris 1219382 Bacteria Bacteria 95.5 6.14e-18   NR WP_237416191.1 1219382 g268 i0 28.3 1.0128055878929 290 201 99.2 2 853 2 266 554 WP_237416191.1 relaxase/mobilization nuclease domain-containing protein [Acinetobacter nectaris] diamond 870 95.5 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter nectaris

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