RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

28 rows where bioproject = "PRJNA1022392", tax_phylum = "Nitrospirota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 28 ✖

tax_phylum 1

  • Nitrospirota · 28 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1022392 · 28 ✖

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
162452 162452 PRJNA1022392_P_NODE_68161_length_167_cov_1.625000_g67492_i0 PRJNA1022392 68161 167 1.625 2.71375 Nitrospira sp. 70125 Bacteria Bacteria 193 7.909999999999999e-45   NTclustered gi|2194432121|gb|CP092081.1| 70125 g67492 i0 87.425 2 167 21 100 0 1 167 2471874 2471708 MAG: Nitrospira sp. isolate UBC2 chromosome blastn 334 193 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
5265413 5265413 PRJNA1022392_P_NODE_77285_length_159_cov_2.258929_g76616_i0 PRJNA1022392 77285 159 2.258929 3.59169711 Nitrospira sp. 70125 Bacteria Bacteria 185 1.2399999999999997e-42   NTclustered gi|2194432121|gb|CP092081.1| 70125 g76616 i0 87.898 0.987421383647799 157 19 99 0 1 157 3362224 3362380 MAG: Nitrospira sp. isolate UBC2 chromosome blastn 157 185 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
5265483 5265483 PRJNA1022392_P_NODE_85085_length_150_cov_2.116505_g84416_i0 PRJNA1022392 85085 150 2.116505 3.1747575 Bacteria 2 Bacteria Bacteria 67.4 5.15e-12   NR MEW6324750.1 2026887 g84416 i0 69.4 13.58 49 15 98 0 3 149 3 51 MEW6324750.1 sigma-70 family RNA polymerase sigma factor [Nitrospirota bacterium] diamond 2037 67.8 0.994100294985251 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
16739548 16739548 PRJNA1022392_P_NODE_80234_length_157_cov_1.827273_g79565_i0 PRJNA1022392 80234 157 1.827273 2.86881861 Nitrospira japonica 1325564 Bacteria Bacteria 134 4.5e-27   NTclustered gi|1167499077|emb|LT828648.1| 1325564 g79565 i0 83.333 0.917197452229299 144 24 92 0 7 150 1625755 1625898 Nitrospira japonica isolate Genome sequencing of Nitrospira japonica strain NJ11 genome assembly, chromosome: I blastn 144 134 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira japonica
18855683 18855683 PRJNA1022392_P_NODE_76635_length_160_cov_0.902655_g75966_i0 PRJNA1022392 76635 160 0.902655 1.444248 Nitrospira cf. moscoviensis SBR1 96242 Bacteria Bacteria 104 2.46e-24   NR WP_087476085.1 96242 g75966 i0 100 0.99375 53 0 99.4 0 160 2 540 592 WP_087476085.1 response regulator [Nitrospira cf. moscoviensis SBR1015] diamond 159 104 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira cf. moscoviensis SBR1015
21839144 21839144 PRJNA1022392_P_NODE_51878_length_187_cov_7.264286_g51209_i0 PRJNA1022392 51878 187 7.264286 13.58421482 Nitrospira sp. 70125 Bacteria Bacteria 107 1.11e-25   NR HSN04062.1 70125 g51209 i0 66.7 2.79144385026738 87 4 99.5 1 186 1 70 156 HSN04062.1 helicase-related protein [Nitrospira sp.] diamond 522 107 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
21839203 21839203 PRJNA1022392_P_NODE_57018_length_181_cov_1.955224_g56349_i0 PRJNA1022392 57018 181 1.955224 3.53895544 Nitrospira japonica 1325564 Bacteria Bacteria 156 1.14e-33   NTclustered gi|1167499077|emb|LT828648.1| 1325564 g56349 i0 83.041 1.79558011049724 171 29 94 0 10 180 1762503 1762333 Nitrospira japonica isolate Genome sequencing of Nitrospira japonica strain NJ11 genome assembly, chromosome: I blastn 325 156 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira japonica
24388402 24388402 PRJNA1022392_P_NODE_53840_length_185_cov_2.079710_g53171_i0 PRJNA1022392 53840 185 2.07971 3.8474635 Candidatus Nitrospira inopinata 1715989 Bacteria Bacteria 159 9.049999999999999e-35   NTclustered gi|952974062|emb|LN885086.1| 1715989 g53171 i0 83.832 0.902702702702703 167 27 90 0 17 183 2005455 2005289 Nitrospira sp. ENR4 genome assembly NiCh1, chromosome : 1 blastn 167 159 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Candidatus Nitrospira inopinata
26845369 26845369 PRJNA1022392_P_NODE_84001_length_151_cov_4.692308_g83332_i0 PRJNA1022392 84001 151 4.692308 7.08538508 Nitrospirota bacterium 2026887 Bacteria Bacteria 90.5 2.63e-20   NR MEK7352359.1 2026887 g83332 i0 93.9 0.973509933774834 49 3 97.4 0 148 2 78 126 MEK7352359.1 alpha/beta hydrolase [Nitrospirota bacterium] diamond 147 90.5 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
26908432 26908432 PRJNA1022392_P_NODE_33482_length_206_cov_2.729560_g32813_i0 PRJNA1022392 33482 206 2.72956 5.6228936 Nitrospira sp. WS238 2039812 Bacteria Bacteria 66.2 1.19e-10   NR NGZ04350.1 2039812 g32813 i0 93.8 1.39805825242718 32 2 46.6 0 206 111 720 751 NGZ04350.1 hypothetical protein [Nitrospira sp. WS238] diamond 288 66.2 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp. WS238
27540638 27540638 PRJNA1022392_P_NODE_63624_length_172_cov_4.288000_g62955_i0 PRJNA1022392 63624 172 4.288 7.37536 Nitrospira sp. 70125 Bacteria Bacteria 45.4 4.41e-4   NR MBH0195532.1 70125 g62955 i0 95.8 0.418604651162791 24 1 41.9 0 73 2 1 24 MBH0195532.1 hypothetical protein [Nitrospira sp.] diamond 72 45.4 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
27564014 27564014 PRJNA1022392_P_NODE_77364_length_159_cov_2.035714_g76695_i0 PRJNA1022392 77364 159 2.035714 3.23678526 Nitrospira 1234 Bacteria Bacteria 48.9 7.77e-5   NR HSA86063.1 70125 g76695 i0 89.3 10.3396226415094 28 3 52.8 0 85 2 1 28 HSA86063.1 membrane protein insertase YidC [Nitrospira sp.] diamond 1644 49.3 0.991886409736308 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
28266523 28266523 PRJNA1022392_P_NODE_34046_length_206_cov_2.616352_g33377_i0 PRJNA1022392 34046 206 2.616352 5.38968512 Nitrospiraceae bacterium 2026770 Bacteria Bacteria 67 7.78e-12   NR MBX9658208.1 2026770 g33377 i0 47.6 2.44660194174757 84 14 78.6 1 206 45 82 165 MBX9658208.1 TIR domain-containing protein [Nitrospiraceae bacterium] diamond 504 67 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium
28393037 28393037 PRJNA1022392_P_NODE_73906_length_162_cov_0.886957_g73237_i0 PRJNA1022392 73906 162 0.886957 1.43687034 Nitrospira cf. moscoviensis SBR1 96242 Bacteria Bacteria 109 2.8e-26   NR WP_087475437.1 96242 g73237 i0 98.1 0.981481481481482 53 1 98.1 0 161 3 226 278 WP_087475437.1 ShlB/FhaC/HecB family hemolysin secretion/activation protein [Nitrospira cf. moscoviensis SBR1015] diamond 159 109 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira cf. moscoviensis SBR1015
28519459 28519459 PRJNA1022392_P_NODE_31467_length_206_cov_3.194969_g30798_i0 PRJNA1022392 31467 206 3.194969 6.58163614 Nitrospira cf. moscoviensis SBR1 96242 Bacteria Bacteria 107 1.19e-25   NR WP_087475053.1 96242 g30798 i0 68.8 1.35436893203884 93 4 99 1 1 204 125 217 WP_087475053.1 NAD(P)/FAD-dependent oxidoreductase [Nitrospira cf. moscoviensis SBR1015] diamond 279 107 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira cf. moscoviensis SBR1015
28551104 28551104 PRJNA1022392_P_NODE_66307_length_169_cov_2.221311_g65638_i0 PRJNA1022392 66307 169 2.221311 3.75401559 Nitrospiraceae bacterium 2026770 Bacteria Bacteria 117 9.5e-30   NR MBX9661449.1 2026770 g65638 i0 100 0.994082840236686 56 0 99.4 0 168 1 120 175 MBX9661449.1 hypothetical protein [Nitrospiraceae bacterium] diamond 168 117 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium
28614077 28614077 PRJNA1022392_P_NODE_80487_length_157_cov_1.409091_g79818_i0 PRJNA1022392 80487 157 1.409091 2.21227287 Nitrospiraceae bacterium 2026770 Bacteria Bacteria 115 8.720000000000001e-29   NR MBX9661055.1 2026770 g79818 i0 98.1 0.993630573248408 52 1 99.4 0 2 157 31 82 MBX9661055.1 hypothetical protein [Nitrospiraceae bacterium] diamond 156 115 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium
29087832 29087832 PRJNA1022392_P_NODE_77288_length_159_cov_2.250000_g76619_i0 PRJNA1022392 77288 159 2.25 3.5775 Nitrospirota bacterium 2026887 Bacteria Bacteria 48.1 1.47e-4   NR MBF0553271.1 2026887 g76619 i0 54.1 4.90566037735849 37 17 69.8 0 158 48 541 577 MBF0553271.1 serine/threonine protein kinase [Nitrospirota bacterium] diamond 780 48.1 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
29584689 29584689 PRJNA1022392_P_NODE_80530_length_157_cov_1.336364_g79861_i0 PRJNA1022392 80530 157 1.336364 2.09809148 Nitrospira 1234 Bacteria Bacteria 104 2.35e-24   NR MBH0205949.1 70125 g79861 i0 96.2 4.96815286624204 52 2 99.4 0 2 157 321 372 MBH0205949.1 UvrD-helicase domain-containing protein [Nitrospira sp.] diamond 780 104 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
29908793 29908793 PRJNA1022392_P_NODE_62411_length_174_cov_2.023622_g61742_i0 PRJNA1022392 62411 174 2.023622 3.52110228 Nitrospira cf. moscoviensis SBR1 96242 Bacteria Bacteria 115 2.2e-29   NR WP_087476553.1 96242 g61742 i0 100 1.96551724137931 57 0 98.3 0 172 2 67 123 WP_087476553.1 50S ribosomal protein L10 [Nitrospira cf. moscoviensis SBR1015] diamond 342 115 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira cf. moscoviensis SBR1015
30129446 30129446 PRJNA1022392_P_NODE_50012_length_190_cov_2.524476_g49343_i0 PRJNA1022392 50012 190 2.524476 4.7965044 Nitrospira sp. 70125 Bacteria Bacteria 87.4 2.42e-19   NR TKB68503.1 70125 g49343 i0 71.4 1.98947368421053 63 18 99.5 0 1 189 120 182 TKB68503.1 MAG: response regulator transcription factor [Nitrospira sp.] diamond 378 87.4 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
30856454 30856454 PRJNA1022392_P_NODE_50514_length_189_cov_3.683099_g49845_i0 PRJNA1022392 50514 189 3.683099 6.96105711 Nitrospira sp. 70125 Bacteria Bacteria 65.1 1.84e-10   NR MCP9465670.1 70125 g49845 i0 90.9 1.03174603174603 33 3 52.4 0 2 100 262 294 MCP9465670.1 riboflavin biosynthesis protein RibF [Nitrospira sp.] diamond 195 65.1 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
30888103 30888103 PRJNA1022392_P_NODE_77594_length_159_cov_1.580357_g76925_i0 PRJNA1022392 77594 159 1.580357 2.51276763 Nitrospira cf. moscoviensis SBR1 96242 Bacteria Bacteria 119 6.84e-31   NR WP_087474872.1 96242 g76925 i0 100 0.981132075471698 52 0 98.1 0 2 157 236 287 WP_087474872.1 RnfABCDGE type electron transport complex subunit D [Nitrospira cf. moscoviensis SBR1015] diamond 156 119 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira cf. moscoviensis SBR1015
31544187 31544187 PRJNA1022392_P_NODE_85076_length_150_cov_2.165049_g84407_i0 PRJNA1022392 85076 150 2.165049 3.2475735 Pseudomonadati 3379134 Bacteria Bacteria 47.8 1.75e-4   NR MBX3335759.1 70125 g84407 i0 100 5.88 21 0 42 0 2 64 638 658 MBX3335759.1 penicillin-binding protein activator [Nitrospira sp.] diamond 882 47.8 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
31741609 31741609 PRJNA1022392_P_NODE_80097_length_157_cov_2.190909_g79428_i0 PRJNA1022392 80097 157 2.190909 3.43972713 Nitrospira lenta 1436998 Bacteria Bacteria 77.4 3.25e-15   NR WP_121990767.1 1436998 g79428 i0 92.3 0.745222929936306 39 3 74.5 0 157 41 265 303 WP_121990767.1 HNH endonuclease [Nitrospira lenta] diamond 117 77.4 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira lenta
31868131 31868131 PRJNA1022392_P_NODE_71457_length_164_cov_0.871795_g70788_i0 PRJNA1022392 71457 164 0.871795 1.4297438 Nitrospira sp. 70125 Bacteria Bacteria 75.1 2.22e-16   NR HNV26031.1 70125 g70788 i0 100 0.640243902439024 35 0 64 0 58 162 2 36 HNV26031.1 hypothetical protein [Nitrospira sp.] diamond 105 75.1 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
32374656 32374656 PRJNA1022392_P_NODE_80279_length_157_cov_1.727273_g79610_i0 PRJNA1022392 80279 157 1.727273 2.71181861 Nitrospira sp. 70125 Bacteria Bacteria 46.2 6.42e-4   NR MCP9456251.1 70125 g79610 i0 64.1 0.745222929936306 39 13 72.6 1 1 114 214 252 MCP9456251.1 1-acyl-sn-glycerol-3-phosphate acyltransferase [Nitrospira sp.] diamond 117 46.2 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
32406237 32406237 PRJNA1022392_P_NODE_77379_length_159_cov_1.991071_g76710_i0 PRJNA1022392 77379 159 1.991071 3.16580289 Nitrospira cf. moscoviensis SBR1 96242 Bacteria Bacteria 107 1.9e-25   NR WP_087475648.1 96242 g76710 i0 100 1.9622641509434 52 0 98.1 0 158 3 19 70 WP_087475648.1 NADH-quinone oxidoreductase subunit L [Nitrospira cf. moscoviensis SBR1015] diamond 312 107 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira cf. moscoviensis SBR1015

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