RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJNA513467" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 22 ✖

tax_kingdom 1

bioproject 1

  • PRJNA513467 · 22 ✖

analysis 1

  • diamond · 22 ✖

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
3037737 3037737 PRJNA513467_S_NODE_4303_length_191_cov_1.006494_g4280_i0 PRJNA513467 4303 191 1.006494 1.92240354 Lichenibacterium 2714751 Bacteria Bacteria 119 8.909999999999998e-32   NR WP_245501222.1 2316528 g4280 i0 87.3 1.97905759162304 63 8 99 0 2 190 114 176 WP_245501222.1 DsbE family thiol:disulfide interchange protein [Lichenibacterium minor] diamond 378 120 0.991666666666667 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Lichenihabitantaceae Lichenibacterium Lichenibacterium minor
11965475 11965475 PRJNA513467_S_NODE_8230_length_151_cov_2.500000_g8207_i0 PRJNA513467 8230 151 2.5 3.775 Sphingomonas echinoides 59803 Bacteria Bacteria 98.6 2.17e-22   NR WP_010406877.1 59803 g8207 i0 100 0.933774834437086 47 0 93.4 0 3 143 440 486 WP_010406877.1 Y-family DNA polymerase [Sphingomonas echinoides] diamond 141 98.6 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas Sphingomonas echinoides
15789420 15789420 PRJNA513467_S_NODE_6193_length_167_cov_2.400000_g6170_i0 PRJNA513467 6193 167 2.4 4.008 unclassified Methylophilus 2630143 Bacteria Bacteria 103 1.51e-25   NR WP_019881796.1 2630143 g6170 i0 100 0.988023952095808 55 0 98.8 0 3 167 131 185 WP_019881796.1 MULTISPECIES: Bax inhibitor-1 family protein [unclassified Methylophilus] diamond 165 103 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Nitrosomonadales Methylophilaceae Methylophilus  
24712733 24712733 PRJNA513467_S_NODE_2300_length_239_cov_1.683168_g2277_i0 PRJNA513467 2300 239 1.683168 4.02277152 Zavarzinia aquatilis 2211142 Bacteria Bacteria 91.3 7.85e-21   NR WP_109907822.1 2211142 g2277 i0 58.2 2.92468619246862 79 33 99.2 0 2 238 90 168 WP_109907822.1 restriction endonuclease subunit S [Zavarzinia aquatilis] diamond 699 91.3 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodospirillales Zavarziniaceae Zavarzinia Zavarzinia aquatilis
25337305 25337305 PRJNA513467_S_NODE_5360_length_176_cov_2.460432_g5337_i0 PRJNA513467 5360 176 2.460432 4.33036032 Pseudomonadati 3379134 Bacteria Bacteria 101 4.59e-25   NR WP_376770372.1 29428 g5337 i0 80.4 4.73863636363636 56 11 95.5 0 8 175 126 181 WP_376770372.1 chlorite dismutase family protein [Methylorubrum rhodinum] diamond 834 101 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Methylobacteriaceae Methylorubrum Methylorubrum rhodinum
27550937 27550937 PRJNA513467_S_NODE_8064_length_152_cov_2.034783_g8041_i0 PRJNA513467 8064 152 2.034783 3.09287016 Candidatus Aquirickettsiella gammari 2016198 Bacteria Bacteria 107 3.15e-26   NR RDH41035.1 2016198 g8041 i0 100 0.986842105263158 50 0 98.7 0 3 152 74 123 RDH41035.1 MAG: NAD-dependent epimerase/dehydratase family protein [Candidatus Aquirickettsiella gammari] diamond 150 107 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Legionellales Coxiellaceae Candidatus Aquirickettsiella Candidatus Aquirickettsiella gammari
27819296 27819296 PRJNA513467_S_NODE_7304_length_158_cov_1.165289_g7281_i0 PRJNA513467 7304 158 1.165289 1.84115662 Bacteria 2 Bacteria Bacteria 46.6 5.12e-4   NR OYV39926.1 1970566 g7281 i0 52.3 11.9240506329114 44 20 83.5 1 27 158 561 603 OYV39926.1 MAG: hypothetical protein B7Z80_05930 [Rhodospirillales bacterium 20-64-7] diamond 1884 47 0.991489361702128 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodospirillales     Rhodospirillales bacterium 20-64-7
28277154 28277154 PRJNA513467_S_NODE_686_length_385_cov_2.623563_g663_i0 PRJNA513467 686 385 2.623563 10.10071755 Rickettsiaceae bacterium 2023360 Bacteria Bacteria 150 3.47e-39   NR RYE04907.1 2023360 g663 i0 66.4 0.833766233766234 107 36 83.4 0 376 56 903 1009 RYE04907.1 MAG: hypothetical protein EOP33_08190 [Rickettsiaceae bacterium] diamond 321 150 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rickettsiales Rickettsiaceae   Rickettsiaceae bacterium
28719418 28719418 PRJNA513467_S_NODE_4467_length_188_cov_1.549669_g4444_i0 PRJNA513467 4467 188 1.549669 2.91337772 Lichenibacterium minor 2316528 Bacteria Bacteria 115 8.74e-29   NR WP_129227151.1 2316528 g4444 i0 93.5 1.97872340425532 62 4 98.9 0 2 187 214 275 WP_129227151.1 homoserine dehydrogenase [Lichenibacterium minor] diamond 372 115 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Lichenihabitantaceae Lichenibacterium Lichenibacterium minor
30203283 30203283 PRJNA513467_S_NODE_4772_length_184_cov_1.061224_g4749_i0 PRJNA513467 4772 184 1.061224 1.95265216 Burkholderiaceae bacterium 2030806 Bacteria Bacteria 42.7 0.0077   NR HWP19070.1 2030806 g4749 i0 45.3 0.864130434782609 53 27 86.4 1 183 25 77 127 HWP19070.1 MAPEG family protein [Burkholderiaceae bacterium] diamond 159 42.7 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae   Burkholderiaceae bacterium
30250778 30250778 PRJNA513467_S_NODE_3732_length_200_cov_2.644172_g3709_i0 PRJNA513467 3732 200 2.644172 5.288344 Sphingomonadaceae 41297 Bacteria Bacteria 62.4 4.88e-10   NR WP_372888902.1 28214 g3709 i0 93.8 4.485 32 2 48 0 199 104 22 53 WP_372888902.1 hypothetical protein [Sphingomonas sp.] diamond 897 62.8 0.993630573248408 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas Sphingomonas sp.
30330410 30330410 PRJNA513467_S_NODE_8352_length_151_cov_0.947368_g8329_i0 PRJNA513467 8352 151 0.947368 1.43052568 Chelatococcus sambhunathii 363953 Bacteria Bacteria 85.9 2.37e-19   NR WP_309392831.1 363953 g8329 i0 88 0.993377483443709 50 6 99.3 0 150 1 68 117 WP_309392831.1 chlorite dismutase family protein [Chelatococcus sambhunathii] diamond 150 85.9 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Chelatococcaceae Chelatococcus Chelatococcus sambhunathii
30471835 30471835 PRJNA513467_S_NODE_3673_length_201_cov_2.634146_g3650_i0 PRJNA513467 3673 201 2.634146 5.29463346 Alphaproteobacteria 28211 Bacteria Bacteria 48.5 1.6e-4   NR NBW23088.1 1978230 g3650 i0 46.4 1.73134328358209 56 30 83.6 0 1 168 46 101 NBW23088.1 hypothetical protein [Caulobacteraceae bacterium] diamond 348 48.9 0.991820040899796 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Caulobacterales Caulobacteraceae   Caulobacteraceae bacterium
30724422 30724422 PRJNA513467_S_NODE_4774_length_184_cov_1.061224_g4751_i0 PRJNA513467 4774 184 1.061224 1.95265216 Azonexaceae 2008795 Bacteria Bacteria 43.5 0.00386   NR WP_205421433.1 2231055 g4751 i0 48.8 1.28804347826087 41 20 65.2 1 44 163 42 82 WP_205421433.1 MAPEG family protein [Dechloromonas sp. HYN0024] diamond 237 43.9 0.990888382687927 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Rhodocyclales Azonexaceae Dechloromonas Dechloromonas sp. HYN0024
30930242 30930242 PRJNA513467_S_NODE_2034_length_251_cov_1.808411_g2011_i0 PRJNA513467 2034 251 1.808411 4.53911161 Burkholderia cenocepacia 95486 Bacteria Bacteria 82.8 3.26e-16   NR WP_301833432.1 95486 g2011 i0 56.4 5.53386454183267 78 34 93.2 0 8 241 698 775 WP_301833432.1 beta strand repeat-containing protein [Burkholderia cenocepacia] diamond 1389 82.8 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Burkholderia Burkholderia cenocepacia
31150983 31150983 PRJNA513467_S_NODE_3435_length_206_cov_2.289941_g3412_i0 PRJNA513467 3435 206 2.289941 4.71727846 Acinetobacter sp. 472 Bacteria Bacteria 63.9 8.51e-11   NR HQZ60687.1 472 g3412 i0 93.9 0.480582524271845 33 2 48.1 0 106 204 1 33 HQZ60687.1 hypothetical protein [Acinetobacter sp.] diamond 99 63.9 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter sp.
31594381 31594381 PRJNA513467_S_NODE_6536_length_164_cov_2.125984_g6513_i0 PRJNA513467 6536 164 2.125984 3.48661376 Nitrosomonas halophila 44576 Bacteria Bacteria 50.4 2.32e-5   NR WP_090413656.1 44576 g6513 i0 50 1.86585365853659 50 25 91.5 0 2 151 83 132 WP_090413656.1 hypothetical protein [Nitrosomonas halophila] diamond 306 50.4 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Nitrosomonadales Nitrosomonadaceae Nitrosomonas Nitrosomonas halophila
31625736 31625736 PRJNA513467_S_NODE_6156_length_168_cov_1.190840_g6133_i0 PRJNA513467 6156 168 1.19084 2.0006112 Pandoraea iniqua 2508288 Bacteria Bacteria 44.3 0.00377   NR WP_150790062.1 2508288 g6133 i0 95 0.357142857142857 20 1 35.7 0 2 61 315 334 WP_150790062.1 phage major capsid protein [Pandoraea iniqua] diamond 60 44.3 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Pandoraea Pandoraea iniqua
31657229 31657229 PRJNA513467_S_NODE_3617_length_203_cov_1.174699_g3594_i0 PRJNA513467 3617 203 1.174699 2.38463897 Brevundimonas sanguinis 3021811 Bacteria Bacteria 50.1 3.47e-5   NR WP_278070509.1 3021811 g3594 i0 61.5 0.576354679802956 39 14 57.6 1 128 12 58 95 WP_278070509.1 hypothetical protein [Brevundimonas sanguinis] diamond 117 50.1 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Caulobacterales Caulobacteraceae Brevundimonas Brevundimonas sanguinis
31720671 31720671 PRJNA513467_S_NODE_2137_length_246_cov_1.622010_g2114_i0 PRJNA513467 2137 246 1.62201 3.9901446 Sphingomonas sp. AR_OL41 3042729 Bacteria Bacteria 55.5 1.23e-6   NR WP_281129010.1 3042729 g2114 i0 80 0.853658536585366 35 7 42.7 0 68 172 282 316 WP_281129010.1 IS21 family transposase [Sphingomonas sp. AR_OL41] diamond 210 55.5 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas Sphingomonas sp. AR_OL41
32068573 32068573 PRJNA513467_S_NODE_6338_length_166_cov_1.720930_g6315_i0 PRJNA513467 6338 166 1.72093 2.8567438 Candidatus Aquirickettsiella gammari 2016198 Bacteria Bacteria 118 3.17e-30   NR RDH41035.1 2016198 g6315 i0 100 0.993975903614458 55 0 99.4 0 1 165 135 189 RDH41035.1 MAG: NAD-dependent epimerase/dehydratase family protein [Candidatus Aquirickettsiella gammari] diamond 165 118 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Legionellales Coxiellaceae Candidatus Aquirickettsiella Candidatus Aquirickettsiella gammari
32575144 32575144 PRJNA513467_S_NODE_2619_length_227_cov_2.131579_g2596_i0 PRJNA513467 2619 227 2.131579 4.83868433 Escherichia coli 562 Bacteria Bacteria 70.5 7.75e-14   NR WP_203641020.1 562 g2596 i0 79.5 0.581497797356828 44 8 58.1 1 6 137 4 46 WP_203641020.1 hypothetical protein, partial [Escherichia coli] diamond 132 70.5 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli

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