RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

32 rows where analysis = "diamond", bioproject = "PRJNA438687" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 32 ✖

tax_kingdom 1

bioproject 1

  • PRJNA438687 · 32 ✖

analysis 1

  • diamond · 32 ✖

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
17012690 17012690 PRJNA438687_S_NODE_6894_length_166_cov_1.389313_g6804_i0 PRJNA438687 6894 166 1.389313 2.30625958 Microvirga lupini 420324 Bacteria Bacteria 79.3 1.64e-15   NR WP_183447232.1 420324 g6804 i0 61.4 2.06024096385542 57 20 99.4 1 166 2 61 117 WP_183447232.1 hypothetical protein [Microvirga lupini] diamond 342 79.3 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Methylobacteriaceae Microvirga Microvirga lupini
26727399 26727399 PRJNA438687_S_NODE_7781_length_155_cov_1.658333_g7691_i0 PRJNA438687 7781 155 1.658333 2.57041615 Gammaproteobacteria bacterium 1913989 Bacteria Bacteria 97.8 1.77e-22   NR NCB88934.1 1913989 g7691 i0 78.4 0.987096774193548 51 11 98.7 0 3 155 114 164 NCB88934.1 hypothetical protein [Gammaproteobacteria bacterium] diamond 153 97.8 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       Gammaproteobacteria bacterium
26917814 26917814 PRJNA438687_S_NODE_5122_length_196_cov_1.397516_g5032_i0 PRJNA438687 5122 196 1.397516 2.73913136 Gammaproteobacteria bacterium 1913989 Bacteria Bacteria 140 3.37e-38   NR NCB90084.1 1913989 g5032 i0 95.4 0.994897959183674 65 3 99.5 0 1 195 322 386 NCB90084.1 hypothetical protein [Gammaproteobacteria bacterium] diamond 195 140 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       Gammaproteobacteria bacterium
27218474 27218474 PRJNA438687_S_NODE_6082_length_178_cov_1.335664_g5992_i0 PRJNA438687 6082 178 1.335664 2.37748192 root 1 Root_unresolved Root_unresolved 71.6 1.01e-12   NR WP_288075275.1 306 g5992 i0 66.7 3.05056179775281 45 15 75.8 0 1 135 526 570 WP_288075275.1 phage tail sheath subtilisin-like domain-containing protein [Pseudomonas sp.] diamond 543 71.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas sp.
27423901 27423901 PRJNA438687_S_NODE_2283_length_292_cov_2.272374_g2193_i0 PRJNA438687 2283 292 2.272374 6.63533208 Kaistia sp. 32K 2795690 Bacteria Bacteria 45.4 0.0028   NR WP_201401983.1 2795690 g2193 i0 48 0.513698630136986 50 23 51.4 1 179 30 1 47 WP_201401983.1 hypothetical protein [Kaistia sp. 32K] diamond 150 45.4 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Kaistiaceae Kaistia Kaistia sp. 32K
27644892 27644892 PRJNA438687_S_NODE_6684_length_169_cov_1.373134_g6594_i0 PRJNA438687 6684 169 1.373134 2.32059646 Gammaproteobacteria bacterium 1913989 Bacteria Bacteria 103 5.38e-26   NR NCB88654.1 1913989 g6594 i0 96.4 0.994082840236686 56 2 99.4 0 168 1 69 124 NCB88654.1 hypothetical protein [Gammaproteobacteria bacterium] diamond 168 103 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       Gammaproteobacteria bacterium
28197593 28197593 PRJNA438687_S_NODE_2326_length_290_cov_1.949020_g2236_i0 PRJNA438687 2326 290 1.94902 5.652158 Enterobacteriaceae 543 Bacteria Bacteria 44.3 0.00281   NR WP_063082130.1 562 g2236 i0 40 1.61379310344828 50 30 51.7 0 20 169 36 85 WP_063082130.1 hypothetical protein [Escherichia coli] diamond 468 44.7 0.991051454138702 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
28545270 28545270 PRJNA438687_S_NODE_7667_length_156_cov_2.057851_g7577_i0 PRJNA438687 7667 156 2.057851 3.21024756 root 1 Root_unresolved Root_unresolved 58.9 1.54e-8   NR WP_276662907.1 164330 g7577 i0 70.3 4.11538461538461 37 11 71.2 0 17 127 68 104 WP_276662907.1 hypothetical protein [Thauera aminoaromatica] diamond 642 59.3 0.993254637436762 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Rhodocyclales Zoogloeaceae Thauera Thauera aminoaromatica
28718272 28718272 PRJNA438687_S_NODE_6887_length_166_cov_1.679389_g6797_i0 PRJNA438687 6887 166 1.679389 2.78778574 Leisingera sp. MMG 1879318 Bacteria Bacteria 44.3 6.97e-4   NR WP_237456657.1 2909982 g6797 i0 82.1 0.993975903614458 28 5 50.6 0 5 88 60 87 WP_237456657.1 PAAR domain-containing protein [Leisingera sp. MMG026] diamond 165 44.3 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodobacterales Roseobacteraceae Leisingera Leisingera sp. MMG026
28844307 28844307 PRJNA438687_S_NODE_3228_length_249_cov_1.897196_g3138_i0 PRJNA438687 3228 249 1.897196 4.72401804 Gammaproteobacteria bacterium 1913989 Bacteria Bacteria 110 8.88e-30   NR NCB89554.1 1913989 g3138 i0 100 0.63855421686747 53 0 63.9 0 160 2 1 53 NCB89554.1 hypothetical protein [Gammaproteobacteria bacterium] diamond 159 110 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       Gammaproteobacteria bacterium
29160484 29160484 PRJNA438687_S_NODE_3289_length_246_cov_1.113744_g3199_i0 PRJNA438687 3289 246 1.113744 2.73981024 Shigella sonnei 624 Bacteria Bacteria 42 0.0171   NR EFV9547734.1 624 g3199 i0 39.6 0.646341463414634 53 31 63.4 1 241 86 31 83 EFV9547734.1 hypothetical protein [Shigella sonnei] diamond 159 42 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Shigella Shigella sonnei
29191925 29191925 PRJNA438687_S_NODE_5169_length_195_cov_1.968750_g5079_i0 PRJNA438687 5169 195 1.96875 3.8390625 Paraburkholderia phenoliruptrix 252970 Bacteria Bacteria 60.1 1.5e-8   NR WP_368580468.1 252970 g5079 i0 45.9 2.67692307692308 61 33 93.8 0 194 12 835 895 WP_368580468.1 helicase-related protein [Paraburkholderia phenoliruptrix] diamond 522 60.1 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Paraburkholderia Paraburkholderia phenoliruptrix
29381253 29381253 PRJNA438687_S_NODE_2149_length_299_cov_1.708333_g2059_i0 PRJNA438687 2149 299 1.708333 5.10791567 Citrobacter europaeus 1914243 Bacteria Bacteria 84 1.52e-18   NR WP_410683879.1 1914243 g2059 i0 48.2 2.51839464882943 85 44 85.3 0 29 283 9 93 WP_410683879.1 hypothetical protein [Citrobacter europaeus] diamond 753 84 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Citrobacter Citrobacter europaeus
29381254 29381254 PRJNA438687_S_NODE_7809_length_155_cov_0.991667_g7719_i0 PRJNA438687 7809 155 0.991667 1.53708385 Gammaproteobacteria bacterium 1913989 Bacteria Bacteria 114 4.22e-29   NR NCB89916.1 1913989 g7719 i0 100 0.987096774193548 51 0 98.7 0 2 154 129 179 NCB89916.1 hypothetical protein [Gammaproteobacteria bacterium] diamond 153 114 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       Gammaproteobacteria bacterium
29507473 29507473 PRJNA438687_S_NODE_990_length_380_cov_1.710145_g901_i0 PRJNA438687 990 380 1.710145 6.498551 unclassified Serratia (in: enterobacteria) 2647522 Bacteria Bacteria 82.4 1.36e-17   NR WP_099786130.1 2647522 g901 i0 47.5 0.631578947368421 80 40 62.4 2 46 282 17 95 WP_099786130.1 MULTISPECIES: hypothetical protein [unclassified Serratia (in: enterobacteria)] diamond 240 82.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Yersiniaceae Serratia  
29696594 29696594 PRJNA438687_S_NODE_710_length_416_cov_2.514436_g621_i0 PRJNA438687 710 416 2.514436 10.46005376 Klebsiella pneumoniae 573 Bacteria Bacteria 121 4.43e-30   NR WP_368762155.1 573 g621 i0 46.3 0.980769230769231 136 72 97.4 1 8 412 201 336 WP_368762155.1 baseplate J/gp47 family protein [Klebsiella pneumoniae] diamond 408 121 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
30471605 30471605 PRJNA438687_S_NODE_3653_length_233_cov_1.358586_g3563_i0 PRJNA438687 3653 233 1.358586 3.16550538 root 1 Root_unresolved Root_unresolved 101 9.52e-25   NR WP_288081024.1 306 g3563 i0 68.1 3.82403433476395 72 23 92.7 0 216 1 96 167 WP_288081024.1 hypothetical protein, partial [Pseudomonas sp.] diamond 891 102 0.990196078431373 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas sp.
30629244 30629244 PRJNA438687_S_NODE_433_length_479_cov_2.367117_g352_i0 PRJNA438687 433 479 2.367117 11.33849043 Pseudomonadati 3379134 Bacteria Bacteria 96.7 1.77e-22   NR WP_288075272.1 306 g352 i0 57.5 0.995824634655532 80 34 50.1 0 477 238 24 103 WP_288075272.1 hypothetical protein [Pseudomonas sp.] diamond 477 97.4 0.992813141683778 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas sp.
30739463 30739463 PRJNA438687_S_NODE_7714_length_156_cov_0.983471_g7624_i0 PRJNA438687 7714 156 0.983471 1.53421476 Gammaproteobacteria bacterium 1913989 Bacteria Bacteria 86.3 6.67e-19   NR NCB90640.1 1913989 g7624 i0 97.6 0.807692307692308 42 1 80.8 0 3 128 207 248 NCB90640.1 hypothetical protein [Gammaproteobacteria bacterium] diamond 126 86.3 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       Gammaproteobacteria bacterium
31245029 31245029 PRJNA438687_S_NODE_3495_length_238_cov_1.635468_g3405_i0 PRJNA438687 3495 238 1.635468 3.89241384 Microvirga lupini 420324 Bacteria Bacteria 111 2.78e-26   NR WP_183447168.1 420324 g3405 i0 69.6 0.995798319327731 79 24 99.6 0 237 1 759 837 WP_183447168.1 hypothetical protein [Microvirga lupini] diamond 237 111 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Methylobacteriaceae Microvirga Microvirga lupini
31245030 31245030 PRJNA438687_S_NODE_4675_length_205_cov_4.611765_g4585_i0 PRJNA438687 4675 205 4.611765 9.45411825 Cronobacter sakazakii 28141 Bacteria Bacteria 42.7 0.00245   NR WP_105605779.1 28141 g4585 i0 55.6 0.526829268292683 36 16 52.7 0 96 203 24 59 WP_105605779.1 hypothetical protein, partial [Cronobacter sakazakii] diamond 108 42.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Cronobacter Cronobacter sakazakii
31356406 31356406 PRJNA438687_S_NODE_2816_length_266_cov_6.632035_g2726_i0 PRJNA438687 2816 266 6.632035 17.6412131 root 1 Root_unresolved Root_unresolved 68.6 2.12e-11   NR EKK5567994.1 158836 g2726 i0 43.2 2.97744360902256 88 49 98.1 1 4 264 65 152 EKK5567994.1 hypothetical protein [Enterobacter hormaechei] diamond 792 68.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Enterobacter Enterobacter hormaechei
31483035 31483035 PRJNA438687_S_NODE_4016_length_222_cov_1.802139_g3926_i0 PRJNA438687 4016 222 1.802139 4.00074858 root 1 Root_unresolved Root_unresolved 119 1.59e-29   NR HED35452.1 1913989 g3926 i0 73.6 7.7972972972973 72 19 97.3 0 5 220 167 238 HED35452.1 phage portal protein [Gammaproteobacteria bacterium] diamond 1731 119 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       Gammaproteobacteria bacterium
31546221 31546221 PRJNA438687_S_NODE_36_length_868_cov_2.015606_g19_i0 PRJNA438687 36 868 2.015606 17.49546008 root 1 Root_unresolved Root_unresolved 223 8.35e-69   NR WP_368762151.1 573 g19 i0 54.3 2.00460829493088 188 85 64.6 1 80 640 3 190 WP_368762151.1 hypothetical protein [Klebsiella pneumoniae] diamond 1740 224 0.995535714285714 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
31687837 31687837 PRJNA438687_S_NODE_5337_length_191_cov_3.608974_g5247_i0 PRJNA438687 5337 191 3.608974 6.89314034 Acinetobacter baumannii 470 Bacteria Bacteria 97.4 5.91e-25   NR WP_212750389.1 470 g5247 i0 100 0.801047120418848 51 0 80.1 0 189 37 18 68 WP_212750389.1 hypothetical protein, partial [Acinetobacter baumannii] diamond 153 97.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter baumannii
31719538 31719538 PRJNA438687_S_NODE_3417_length_241_cov_2.174757_g3327_i0 PRJNA438687 3417 241 2.174757 5.24116437 Rahnella rivi 2816249 Bacteria Bacteria 52.4 1.87e-6   NR WP_414072288.1 2816249 g3327 i0 39.7 0.784232365145228 63 37 77.2 1 49 234 8 70 WP_414072288.1 hypothetical protein [Rahnella rivi] diamond 189 52.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Yersiniaceae Rahnella Rahnella rivi
31988840 31988840 PRJNA438687_S_NODE_7798_length_155_cov_1.316667_g7708_i0 PRJNA438687 7798 155 1.316667 2.04083385 Pseudomonadati 3379134 Bacteria Bacteria 49.7 3.08e-6   NR WP_288073955.1 306 g7708 i0 41.2 2.96129032258065 51 30 98.7 0 2 154 21 71 WP_288073955.1 hypothetical protein [Pseudomonas sp.] diamond 459 49.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas sp.
32352553 32352553 PRJNA438687_S_NODE_7679_length_156_cov_1.768595_g7589_i0 PRJNA438687 7679 156 1.768595 2.7590082 Salmonella enterica 28901 Bacteria Bacteria 50.8 1.55e-5   NR EBW9734658.1 1005394 g7589 i0 72.7 0.634615384615385 33 9 63.5 0 103 5 1 33 EBW9734658.1 hypothetical protein [Salmonella enterica subsp. enterica serovar Oslo] diamond 99 50.8 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Salmonella Salmonella enterica
32510794 32510794 PRJNA438687_S_NODE_8039_length_152_cov_1.846154_g7949_i0 PRJNA438687 8039 152 1.846154 2.80615408 Stenotrophomonas sp. GD 69392 Bacteria Bacteria 58.2 3.87e-8   NR WP_279924968.1 2975363 g7949 i0 50 0.947368421052632 48 24 94.7 0 148 5 298 345 WP_279924968.1 hypothetical protein [Stenotrophomonas sp. GD03657] diamond 144 58.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Lysobacterales Lysobacteraceae Stenotrophomonas Stenotrophomonas sp. GD03657
32636463 32636463 PRJNA438687_S_NODE_5460_length_189_cov_2.116883_g5370_i0 PRJNA438687 5460 189 2.116883 4.00090887 Salmonella enterica subsp. diarizonae serovar 48:i:z 1192842 Bacteria Bacteria 41.2 0.0106   NR WGI49873.1 1192842 g5370 i0 40.4 0.904761904761905 57 32 90.5 1 187 17 17 71 WGI49873.1 hypothetical protein QBX66_26070 [Salmonella enterica subsp. diarizonae serovar 48:i:z] diamond 171 41.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Salmonella Salmonella enterica
32668099 32668099 PRJNA438687_S_NODE_8200_length_150_cov_3.147826_g8110_i0 PRJNA438687 8200 150 3.147826 4.721739 Mycoavidus cysteinexigens 1553431 Bacteria Bacteria 39.7 0.0279   NR BBE08256.1 1553431 g8110 i0 71 1.22 31 7 58 1 92 6 32 62 BBE08256.1 Uncharacterized protein MCB1EB_0095 [Mycoavidus cysteinexigens] diamond 183 39.7 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Mycoavidus Mycoavidus cysteinexigens
32684279 32684279 PRJNA438687_S_NODE_5740_length_184_cov_2.080537_g5650_i0 PRJNA438687 5740 184 2.080537 3.82818808 Hyphomicrobiales 356 Bacteria Bacteria 65.5 1.56e-10   NR BFW87023.1 29468 g5650 i0 63.8 2.625 47 17 76.6 0 149 9 269 315 BFW87023.1 hypothetical protein NpR2016_35710 [Methylocystis echinoides] diamond 483 65.5 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Methylocystaceae Methylocystis Methylocystis echinoides

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