RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

25 rows where bioproject = "PRJNA980585" and tax_phylum = "Nitrospirota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Nitrospirota · 25 ✖

tax_kingdom 1

bioproject 1

  • PRJNA980585 · 25 ✖

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
2230398 2230398 PRJNA980585_P_NODE_50042_length_246_cov_1.780347_g49788_i0 PRJNA980585 50042 246 1.780347 4.37965362 Nitrospira sp. 70125 Bacteria Bacteria 220 5.76e-53   NTclustered gi|1938802452|gb|CP054184.1| 70125 g49788 i0 83.264 1.95528455284553 239 40 97 0 5 243 850331 850569 MAG: Nitrospira sp. isolate H3_NOB1 chromosome, complete genome blastn 481 220 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
3505320 3505320 PRJNA980585_P_NODE_33323_length_270_cov_1.563452_g33069_i0 PRJNA980585 33323 270 1.563452 4.2213204 Nitrospira 1234 Bacteria Bacteria 181 1.8799999999999996e-55   NR MEQ1793949.1 70125 g33069 i0 98.9 3.95555555555556 89 1 98.9 0 268 2 40 128 MEQ1793949.1 TPM domain-containing protein [Nitrospira sp.] diamond 1068 181 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
3505325 3505325 PRJNA980585_P_NODE_33503_length_270_cov_1.228426_g33249_i0 PRJNA980585 33503 270 1.228426 3.3167502 Nitrospira sp. 70125 Bacteria Bacteria 174 5.06e-39   NTclustered gi|1938802452|gb|CP054184.1| 70125 g33249 i0 80.995 55.2666666666667 221 40 81 2 1 220 1710953 1711172 MAG: Nitrospira sp. isolate H3_NOB1 chromosome, complete genome blastn 14922 174 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
4783366 4783366 PRJNA980585_P_NODE_58984_length_242_cov_0.911243_g58730_i0 PRJNA980585 58984 242 0.911243 2.20520806 Nitrospira sp. 70125 Bacteria Bacteria 152 1.62e-43   NR MCS6284629.1 70125 g58730 i0 95 0.991735537190083 80 4 99.2 0 1 240 61 140 MCS6284629.1 type II secretion system minor pseudopilin GspK [Nitrospira sp.] diamond 240 152 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
7332617 7332617 PRJNA980585_P_NODE_36626_length_261_cov_1.638298_g36372_i0 PRJNA980585 36626 261 1.638298 4.27595778 Nitrospira defluvii 330214 Bacteria Bacteria 263 1.01e-65   NTclustered gi|300603458|emb|FP929003.1| 330214 g36372 i0 85.156 0.980842911877395 256 38 98 0 1 256 3482599 3482854 Candidatus Nitrospira defluvii chromosome, complete genome blastn 256 263 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira defluvii
9883043 9883043 PRJNA980585_P_NODE_43188_length_250_cov_0.870056_g42934_i0 PRJNA980585 43188 250 0.870056 2.17514 Nitrospira sp. 70125 Bacteria Bacteria 385 1.97e-102   NTclustered gi|2194436381|gb|CP092080.1| 70125 g42934 i0 94.4 1 250 14 100 0 1 250 3277668 3277419 MAG: Nitrospira sp. isolate UBC1 chromosome blastn 250 385 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
17533094 17533094 PRJNA980585_P_NODE_57434_length_243_cov_0.905882_g57180_i0 PRJNA980585 57434 243 0.905882 2.20129326 Nitrospira sp. 70125 Bacteria Bacteria 361 3.2e-95   NTclustered gi|2511640680|gb|CP126121.1| 70125 g57180 i0 93.416 1.99588477366255 243 16 100 0 1 243 1080628 1080870 MAG: Nitrospira sp. isolate bin_001 chromosome, complete genome blastn 485 361 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
18806502 18806502 PRJNA980585_P_NODE_30295_length_279_cov_1.233010_g30041_i0 PRJNA980585 30295 279 1.23301 3.4400979 Nitrospira sp. 70125 Bacteria Bacteria 315 2.97e-81   NTclustered gi|2194432121|gb|CP092081.1| 70125 g30041 i0 87.05 1.99641577060932 278 36 99 0 1 278 2538210 2537933 MAG: Nitrospira sp. isolate UBC2 chromosome blastn 557 315 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
25180815 25180815 PRJNA980585_P_NODE_30820_length_277_cov_1.696078_g30566_i0 PRJNA980585 30820 277 1.696078 4.69813606 Pseudomonadati 3379134 Bacteria Bacteria 79.3 2.33e-16   NR MDR4493886.1 2358460 g30566 i0 53.2 1.68953068592058 77 34 83.4 1 234 4 48 122 MDR4493886.1 Hsp20/alpha crystallin family protein [Nitrospirales bacterium] diamond 468 79.3 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales     Nitrospirales bacterium
25181256 25181256 PRJNA980585_P_NODE_55740_length_243_cov_1.723529_g55486_i0 PRJNA980585 55740 243 1.723529 4.18817547 Nitrospira sp. 70125 Bacteria Bacteria 241 4.36e-59   NTclustered gi|2194428397|gb|CP092079.1| 70125 g55486 i0 84.711 0.995884773662551 242 35 99 2 3 243 447874 447634 MAG: Nitrospira sp. isolate UBC3 chromosome blastn 242 241 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
27026119 27026119 PRJNA980585_P_NODE_12182_length_390_cov_1.946372_g11928_i0 PRJNA980585 12182 390 1.946372 7.5908508 Nitrospirota bacterium 2026887 Bacteria Bacteria 67.4 2.94e-10   NR MBF0459651.1 2026887 g11928 i0 36.8 2.24615384615385 106 62 77.7 2 369 67 133 238 MBF0459651.1 hypothetical protein [Nitrospirota bacterium] diamond 876 67.4 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
27626628 27626628 PRJNA980585_P_NODE_45324_length_249_cov_0.875000_g45070_i0 PRJNA980585 45324 249 0.875 2.17875 Nitrospira lenta 1436998 Bacteria Bacteria 161 7.46e-44   NR WP_121990813.1 1436998 g45070 i0 97.6 7.90361445783132 82 2 98.8 0 248 3 241 322 WP_121990813.1 ATP-dependent DNA helicase RecG [Nitrospira lenta] diamond 1968 161 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira lenta
27916596 27916596 PRJNA980585_P_NODE_52305_length_245_cov_0.895349_g52051_i0 PRJNA980585 52305 245 0.895349 2.19360505 Pseudomonadati 3379134 Bacteria Bacteria 97.4 4.41e-22   NR MBX3371688.1 70125 g52051 i0 58 1.98367346938776 81 33 99.2 1 244 2 121 200 MBX3371688.1 PAS domain S-box protein [Nitrospira sp.] diamond 486 97.8 0.995910020449898 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
29179883 29179883 PRJNA980585_P_NODE_36229_length_262_cov_1.629630_g35975_i0 PRJNA980585 36229 262 1.62963 4.2696306 Pseudomonadati 3379134 Bacteria Bacteria 94 1.95e-21   NR MBA3753977.1 70125 g35975 i0 70.7 3.40076335877863 58 17 66.4 0 261 88 122 179 MBA3753977.1 hypothetical protein [Nitrospira sp.] diamond 891 94.4 0.995762711864407 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
29363100 29363100 PRJNA980585_P_NODE_29149_length_282_cov_1.224880_g28895_i0 PRJNA980585 29149 282 1.22488 3.4541616 Nitrospira sp. 70125 Bacteria Bacteria 96.7 5.8100000000000006e-21   NR MBS0172908.1 70125 g28895 i0 47.3 0.968085106382979 91 48 96.8 0 280 8 69 159 MBS0172908.1 hypothetical protein [Nitrospira sp.] diamond 273 96.7 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
29583708 29583708 PRJNA980585_P_NODE_26570_length_289_cov_1.425926_g26316_i0 PRJNA980585 26570 289 1.425926 4.12092614 Nitrospira sp. 70125 Bacteria Bacteria 177 2.2099999999999994e-54   NR MCS6285521.1 70125 g26316 i0 89.6 2.96885813148789 96 10 99.7 0 2 289 62 157 MCS6285521.1 DNA-3-methyladenine glycosylase [Nitrospira sp.] diamond 858 177 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
29646814 29646814 PRJNA980585_P_NODE_7110_length_487_cov_1.487923_g6856_i0 PRJNA980585 7110 487 1.487923 7.24618501 Nitrospirota bacterium 2026887 Bacteria Bacteria 45.1 0.0175   NR HEX9861547.1 2026887 g6856 i0 38.8 0.412731006160164 67 35 39.4 2 255 64 2 65 HEX9861547.1 hypothetical protein [Nitrospirota bacterium] diamond 201 45.1 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
29994770 29994770 PRJNA980585_P_NODE_57011_length_243_cov_0.905882_g56757_i0 PRJNA980585 57011 243 0.905882 2.20129326 Nitrospirota bacterium 2026887 Bacteria Bacteria 162 1.7e-46   NR MEY4527536.1 2026887 g56757 i0 100 4.9382716049382704 80 0 98.8 0 2 241 220 299 MEY4527536.1 hypothetical protein [Nitrospirota bacterium] diamond 1200 162 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
30500153 30500153 PRJNA980585_P_NODE_3673_length_643_cov_5.715789_g3422_i0 PRJNA980585 3673 643 5.715789 36.75252327 Nitrospirota bacterium 2026887 Bacteria Bacteria 82.8 3.13e-15   NR MBF0344046.1 2026887 g3422 i0 42.6 0.438569206842924 94 54 43.9 0 603 322 37 130 MBF0344046.1 hypothetical protein [Nitrospirota bacterium] diamond 282 82.8 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
30500154 30500154 PRJNA980585_P_NODE_38073_length_257_cov_1.673913_g37819_i0 PRJNA980585 38073 257 1.673913 4.30195641 Nitrospiraceae bacterium 2026770 Bacteria Bacteria 166 2.3599999999999996e-47   NR MBX9657328.1 2026770 g37819 i0 95.3 0.992217898832685 85 4 99.2 0 2 256 81 165 MBX9657328.1 hypothetical protein [Nitrospiraceae bacterium] diamond 255 166 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium
30562967 30562967 PRJNA980585_P_NODE_30653_length_278_cov_1.175610_g30399_i0 PRJNA980585 30653 278 1.17561 3.2681958 Nitrospiraceae bacterium 2026770 Bacteria Bacteria 50.1 1.35e-4   NR MDA8171071.1 2026770 g30399 i0 36.2 0.744604316546763 69 44 74.5 0 216 10 1 69 MDA8171071.1 hypothetical protein [Nitrospiraceae bacterium] diamond 207 50.1 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium
30626333 30626333 PRJNA980585_P_NODE_50213_length_246_cov_1.335260_g49959_i0 PRJNA980585 50213 246 1.33526 3.2847396 Nitrospira sp. 70125 Bacteria Bacteria 134 1.1999999999999996e-38   NR MCS6286014.1 70125 g49959 i0 100 0.804878048780488 66 0 80.5 0 199 2 1 66 MCS6286014.1 hypothetical protein [Nitrospira sp.] diamond 198 134 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
31701276 31701276 PRJNA980585_P_NODE_40437_length_251_cov_0.865169_g40183_i0 PRJNA980585 40437 251 0.865169 2.17157419 Nitrospira lenta 1436998 Bacteria Bacteria 119 1.14e-29   NR WP_121989975.1 1436998 g40183 i0 76 1.79282868525896 75 18 89.6 0 225 1 1 75 WP_121989975.1 multiheme c-type cytochrome [Nitrospira lenta] diamond 450 119 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira lenta
32334315 32334315 PRJNA980585_P_NODE_33159_length_271_cov_1.232323_g32905_i0 PRJNA980585 33159 271 1.232323 3.33959533 Nitrospirota bacterium 2026887 Bacteria Bacteria 50.1 5.05e-5   NR RMF83257.1 2026887 g32905 i0 49.1 0.586715867158672 53 27 58.7 0 271 113 74 126 RMF83257.1 MAG: GNAT family N-acetyltransferase [Nitrospirota bacterium] diamond 159 50.1 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
32587264 32587264 PRJNA980585_P_NODE_58059_length_242_cov_0.911243_g57805_i0 PRJNA980585 58059 242 0.911243 2.20520806 Nitrospira sp. 70125 Bacteria Bacteria 151 4.22e-44   NR MCS6297873.1 70125 g57805 i0 97.5 0.991735537190083 80 2 99.2 0 2 241 39 118 MCS6297873.1 response regulator transcription factor [Nitrospira sp.] diamond 240 151 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.

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