RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA512103" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 20 ✖

tax_kingdom 1

bioproject 1

  • PRJNA512103 · 20 ✖

analysis 1

  • diamond · 20 ✖

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
4312505 4312505 PRJNA512103_P_NODE_15224_length_262_cov_1.309859_g14812_i0 PRJNA512103 15224 262 1.309859 3.43183058 Rhodospirillum 1081 Bacteria Bacteria 75.1 1.25e-13   NR WP_011389437.1 1085 g14812 i0 63.5 1.43129770992366 63 23 72.1 0 252 64 124 186 WP_011389437.1 NADH-quinone oxidoreductase subunit NuoH [Rhodospirillum rubrum] diamond 375 75.1 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodospirillales Rhodospirillaceae Rhodospirillum Rhodospirillum rubrum
26792415 26792415 PRJNA512103_P_NODE_22121_length_202_cov_0.823529_g21709_i0 PRJNA512103 22121 202 0.823529 1.66352858 Klebsiella pneumoniae 573 Bacteria Bacteria 56.6 4.74e-8   NR WP_416532846.1 573 g21709 i0 67.5 1.18811881188119 40 13 59.4 0 81 200 74 113 WP_416532846.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 240 56.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
26855875 26855875 PRJNA512103_P_NODE_21681_length_204_cov_1.238710_g21269_i0 PRJNA512103 21681 204 1.23871 2.5269684 Varunaivibrio sulfuroxidans 1773489 Bacteria Bacteria 63.2 1.25e-9   NR WP_132938096.1 1773489 g21269 i0 52.5 2.64705882352941 61 29 89.7 0 195 13 53 113 WP_132938096.1 NADH-quinone oxidoreductase subunit NuoH [Varunaivibrio sulfuroxidans] diamond 540 63.2 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodospirillales Magnetovibrionaceae Varunaivibrio Varunaivibrio sulfuroxidans
26855878 26855878 PRJNA512103_P_NODE_26681_length_182_cov_1.037594_g26269_i0 PRJNA512103 26681 182 1.037594 1.88842108 Ferrovibrio sp. 1917215 Bacteria Bacteria 98.2 2.65e-25   NR MFN4166547.1 1917215 g26269 i0 78.6 0.923076923076923 56 12 92.3 0 3 170 9 64 MFN4166547.1 4Fe-4S binding protein [Ferrovibrio sp.] diamond 168 98.2 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodospirillales Rhodospirillaceae Ferrovibrio Ferrovibrio sp.
26902912 26902912 PRJNA512103_P_NODE_24641_length_190_cov_0.978723_g24229_i0 PRJNA512103 24641 190 0.978723 1.8595737 Wolbachia 953 Bacteria Bacteria 44.7 0.00392   NR WP_187296964.1 955 g24229 i0 60 1.65789473684211 35 14 55.3 0 2 106 399 433 WP_187296964.1 ankyrin repeat domain-containing protein [Wolbachia pipientis] diamond 315 44.7 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rickettsiales Anaplasmataceae Wolbachia Wolbachia pipientis
27060929 27060929 PRJNA512103_P_NODE_12482_length_313_cov_0.803030_g12070_i0 PRJNA512103 12482 313 0.80303 2.5134839 root 1 Root_unresolved Root_unresolved 202 6.300000000000001e-65   NR WP_176265472.1 562 g12070 i0 99 43.2555910543131 103 1 98.7 0 311 3 7 109 WP_176265472.1 30S ribosomal protein S15, partial [Escherichia coli] diamond 13539 202 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
27330147 27330147 PRJNA512103_P_NODE_34423_length_162_cov_1.008850_g34011_i0 PRJNA512103 34423 162 1.00885 1.634337 Mesorhizobium sp. Pch-S 2082387 Bacteria Bacteria 54.7 1.93e-7   NR WP_129414448.1 2082387 g34011 i0 51.1 0.833333333333333 45 22 83.3 0 149 15 16 60 WP_129414448.1 GFA family protein [Mesorhizobium sp. Pch-S] diamond 135 54.7 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Phyllobacteriaceae Mesorhizobium Mesorhizobium sp. Pch-S
27456574 27456574 PRJNA512103_P_NODE_33383_length_164_cov_0.904348_g32971_i0 PRJNA512103 33383 164 0.904348 1.48313072 Klebsiella pneumoniae 573 Bacteria Bacteria 42.7 0.00201   NR WP_416493070.1 573 g32971 i0 72 0.457317073170732 25 7 45.7 0 21 95 50 74 WP_416493070.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 75 42.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
27740861 27740861 PRJNA512103_P_NODE_13264_length_296_cov_1.145749_g12852_i0 PRJNA512103 13264 296 1.145749 3.39141704 Alphaproteobacteria bacterium 1913988 Bacteria Bacteria 150 2.02e-41   NR MCC7260163.1 1913988 g12852 i0 77.2 22.3783783783784 92 21 93.2 0 3 278 302 393 MCC7260163.1 NADH-quinone oxidoreductase subunit D [Alphaproteobacteria bacterium] diamond 6624 150 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria       Alphaproteobacteria bacterium
28182327 28182327 PRJNA512103_P_NODE_16446_length_246_cov_1.517766_g16034_i0 PRJNA512103 16446 246 1.517766 3.73370436 Salmonella enterica 28901 Bacteria Bacteria 100 1.5999999999999998e-25   NR MEY6245680.1 593905 g16034 i0 73.8 0.792682926829268 65 17 79.3 0 8 202 17 81 MEY6245680.1 hypothetical protein [Salmonella enterica subsp. enterica serovar Corvallis] diamond 195 100 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Salmonella Salmonella enterica
29413860 29413860 PRJNA512103_P_NODE_14889_length_268_cov_1.031963_g14477_i0 PRJNA512103 14889 268 1.031963 2.76566084 Nitrosomonas sp. 42353 Bacteria Bacteria 48.5 4.82e-4   NR HNJ38565.1 42353 g14477 i0 38.5 1.80223880597015 78 46 85.1 2 247 20 964 1041 HNJ38565.1 reverse transcriptase domain-containing protein [Nitrosomonas sp.] diamond 483 48.5 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Nitrosomonadales Nitrosomonadaceae Nitrosomonas Nitrosomonas sp.
30519500 30519500 PRJNA512103_P_NODE_12433_length_314_cov_0.879245_g12021_i0 PRJNA512103 12433 314 0.879245 2.7608293 Aestuariivirga sp. 2650926 Bacteria Bacteria 96.3 1.19e-20   NR WP_415005741.1 2650926 g12021 i0 45.8 0.917197452229299 96 46 91.7 1 299 12 241 330 WP_415005741.1 hypothetical protein [Aestuariivirga sp.] diamond 288 96.3 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Aestuariivirgaceae Aestuariivirga Aestuariivirga sp.
30677318 30677318 PRJNA512103_P_NODE_33573_length_164_cov_0.695652_g33161_i0 PRJNA512103 33573 164 0.695652 1.14086928 Comamonas endophytica 2949090 Bacteria Bacteria 41.2 0.0455   NR WP_377007594.1 2949090 g33161 i0 41.3 0.841463414634146 46 20 80.5 2 5 136 577 617 WP_377007594.1 exodeoxyribonuclease V subunit gamma [Comamonas endophytica] diamond 138 41.2 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Comamonadaceae Comamonas Comamonas endophytica
30772419 30772419 PRJNA512103_P_NODE_34514_length_162_cov_0.920354_g34102_i0 PRJNA512103 34514 162 0.920354 1.49097348 Pseudomonas sp. L-22-4S-12 2610893 Bacteria Bacteria 50.1 3.03e-5   NR WP_160492232.1 2610893 g34102 i0 100 0.407407407407407 22 0 40.7 0 87 152 35 56 WP_160492232.1 GDP-mannose 4,6-dehydratase [Pseudomonas sp. L-22-4S-12] diamond 66 50.1 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas sp. L-22-4S-12
31008832 31008832 PRJNA512103_P_NODE_30754_length_169_cov_0.866667_g30342_i0 PRJNA512103 30754 169 0.866667 1.46466723 Bacteria 2 Bacteria Bacteria 63.5 1.33e-10   NR WP_369986798.1 2842356 g30342 i0 70.3 4.13609467455621 37 11 65.7 0 51 161 3 39 WP_369986798.1 phage tail protein [Pseudomonas xanthosomatis] diamond 699 63.5 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas xanthosomatis
31451540 31451540 PRJNA512103_P_NODE_21716_length_204_cov_0.961290_g21304_i0 PRJNA512103 21716 204 0.96129 1.9610316 root 1 Root_unresolved Root_unresolved 129 2.01e-36   NR WP_240057741.1 573 g21304 i0 100 178.338235294118 67 0 98.5 0 202 2 61 127 WP_240057741.1 cation-transporting P-type ATPase, partial [Klebsiella pneumoniae] diamond 36381 129 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
31531109 31531109 PRJNA512103_P_NODE_25976_length_184_cov_2.029630_g25564_i0 PRJNA512103 25976 184 2.02963 3.7345192 Chromobacterium sp. ATCC 53434 2059672 Bacteria Bacteria 39.7 0.032   NR WP_101709928.1 2059672 g25564 i0 55.2 0.472826086956522 29 13 47.3 0 136 50 8 36 WP_101709928.1 hypothetical protein [Chromobacterium sp. ATCC 53434] diamond 87 39.7 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Neisseriales Chromobacteriaceae Chromobacterium Chromobacterium sp. ATCC 53434
31878662 31878662 PRJNA512103_P_NODE_20437_length_212_cov_0.846626_g20025_i0 PRJNA512103 20437 212 0.846626 1.79484712 Aeromonas veronii 654 Bacteria Bacteria 144 4.65e-38   NR WP_146163500.1 654 g20025 i0 100 0.94811320754717 67 0 94.8 0 2 202 14 80 WP_146163500.1 hypothetical protein [Aeromonas veronii] diamond 201 144 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Aeromonadales Aeromonadaceae Aeromonas Aeromonas veronii
32005455 32005455 PRJNA512103_P_NODE_30718_length_169_cov_0.866667_g30306_i0 PRJNA512103 30718 169 0.866667 1.46466723 Aeromonas 642 Bacteria Bacteria 84 8.41e-19   NR WP_168797162.1 642 g30306 i0 97.7 0.781065088757396 44 1 78.1 0 12 143 96 139 WP_168797162.1 MULTISPECIES: type IV pilus biogenesis protein PilM [Aeromonas] diamond 132 84 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Aeromonadales Aeromonadaceae Aeromonas  
32858220 32858220 PRJNA512103_P_NODE_16860_length_241_cov_2.645833_g16448_i0 PRJNA512103 16860 241 2.645833 6.37645753 Pseudomonadota bacterium 1977087 Bacteria Bacteria 114 2.84e-28   NR MEM7617289.1 1977087 g16448 i0 70.1 2.87551867219917 77 23 95.9 0 3 233 224 300 MEM7617289.1 NADH-quinone oxidoreductase subunit D [Pseudomonadota bacterium] diamond 693 114 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota 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);;