RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

28 rows where bioproject = "PRJNA505329", tax_kingdom = "Pseudomonadati" and tax_phylum = "Nitrospirota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Nitrospirota · 28 ✖

tax_kingdom 1

  • Pseudomonadati · 28 ✖

bioproject 1

  • PRJNA505329 · 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
483103 483103 PRJNA505329_P_NODE_10081_length_233_cov_4.733696_g9610_i0 PRJNA505329 10081 233 4.733696 11.02951168 Nitrospira sp. 70125 Bacteria Bacteria 108 1.6500000000000002e-26   NR TKB81448.1 70125 g9610 i0 53.8 1.53218884120172 119 12 97.9 1 2 229 109 227 TKB81448.1 MAG: universal stress protein [Nitrospira sp.] diamond 357 108 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
3034509 3034509 PRJNA505329_P_NODE_33463_length_182_cov_1.548872_g32992_i0 PRJNA505329 33463 182 1.548872 2.81894704 Nitrospira sp. 70125 Bacteria Bacteria 287 3.9e-73   NTclustered gi|2290907019|gb|CP060499.1| 70125 g32992 i0 95.556 17.0934065934066 180 7 98 1 1 179 2683260 2683439 MAG: Nitrospira sp. isolate DH1 chromosome, complete genome blastn 3111 287 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
11962021 11962021 PRJNA505329_P_NODE_18970_length_203_cov_3.707792_g18499_i0 PRJNA505329 18970 203 3.707792 7.52681776 Nitrospira sp. 70125 Bacteria Bacteria 89.8 1.35e-13   NTclustered gi|2511635996|gb|CP126122.1| 70125 g18499 i0 82.828 0.487684729064039 99 17 49 0 4 102 4464155 4464253 MAG: Nitrospira sp. isolate bin_005 chromosome blastn 99 89.8 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
13237458 13237458 PRJNA505329_P_NODE_46531_length_165_cov_0.896552_g46060_i0 PRJNA505329 46531 165 0.896552 1.4793108 Nitrospira sp. 70125 Bacteria Bacteria 110 1.2e-28   NR MBM4127420.1 70125 g46060 i0 100 0.981818181818182 54 0 98.2 0 2 163 163 216 MBM4127420.1 ABC transporter ATP-binding protein [Nitrospira sp.] diamond 162 110 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
14512100 14512100 PRJNA505329_P_NODE_14032_length_233_cov_2.771739_g13561_i0 PRJNA505329 14032 233 2.771739 6.45815187 Nitrospira sp. 70125 Bacteria Bacteria 114 1.01e-28   NR MDR4464465.1 70125 g13561 i0 67.1 1.09442060085837 85 20 99.1 1 3 233 153 237 MDR4464465.1 phytanoyl-CoA dioxygenase family protein [Nitrospira sp.] diamond 255 114 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
19609220 19609220 PRJNA505329_P_NODE_16356_length_233_cov_2.353261_g15885_i0 PRJNA505329 16356 233 2.353261 5.48309813 Nitrospirales bacterium 2358460 Bacteria Bacteria 54.7 0.006   NTclustered gi|2575803423|emb|OY729426.1| 2358460 g15885 i0 96.875 0.137339055793991 32 1 14 0 202 233 1251867 1251836 MAG: Nitrospirales bacterium isolate 092cc351-3adc-43ff-9a6e-f4966337217d genome assembly, chromosome: 1 blastn 32 54.7 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales     Nitrospirales bacterium
20885548 20885548 PRJNA505329_P_NODE_41757_length_169_cov_1.716667_g41286_i0 PRJNA505329 41757 169 1.716667 2.90116723 Nitrospira sp. ST-bin4 1978764 Bacteria Bacteria 90.9 8.33e-20   NR OQW56452.1 1978764 g41286 i0 97.6 0.745562130177515 42 1 74.6 0 169 44 348 389 OQW56452.1 MAG: hypothetical protein BVN28_14175 [Nitrospira sp. ST-bin4] diamond 126 90.9 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp. ST-bin4
21512154 21512154 PRJNA505329_P_NODE_14797_length_233_cov_2.711957_g14326_i0 PRJNA505329 14797 233 2.711957 6.31885981 Nitrospira sp. 70125 Bacteria Bacteria 69.3 1.17e-11   NR MCE3223062.1 70125 g14326 i0 100 4.94420600858369 32 0 41.2 0 229 134 105 136 MCE3223062.1 prfA [Nitrospira sp.] diamond 1152 69.3 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
23435937 23435937 PRJNA505329_P_NODE_40659_length_171_cov_1.680328_g40188_i0 PRJNA505329 40659 171 1.680328 2.87336088 Candidatus Nitrospira kreftii 2652173 Bacteria Bacteria 167 4.9e-37   NTclustered gi|1884724763|gb|CP047423.1| 2652173 g40188 i0 85.897 0.912280701754386 156 22 91 0 11 166 1218784 1218629 Candidatus Nitrospira kreftii isolate comreactor17 chromosome, complete genome blastn 156 167 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Candidatus Nitrospira kreftii
26697137 26697137 PRJNA505329_P_NODE_28041_length_190_cov_1.907801_g27570_i0 PRJNA505329 28041 190 1.907801 3.6248219 Nitrospira sp. 70125 Bacteria Bacteria 85.9 3.76e-19   NR MBH0204106.1 70125 g27570 i0 95.5 3.47368421052632 44 2 69.5 0 56 187 1 44 MBH0204106.1 alternative thymidylate synthase [Nitrospira sp.] diamond 660 85.9 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
26887466 26887466 PRJNA505329_P_NODE_38641_length_174_cov_1.640000_g38170_i0 PRJNA505329 38641 174 1.64 2.8536 Nitrospira sp. 70125 Bacteria Bacteria 103 2.31e-24   NR HBR52028.1 70125 g38170 i0 86.2 2 58 8 100 0 1 174 338 395 HBR52028.1 peptidase [Nitrospira sp.] diamond 348 103 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
27614335 27614335 PRJNA505329_P_NODE_38584_length_174_cov_1.648000_g38113_i0 PRJNA505329 38584 174 1.648 2.86752 Nitrospirales bacterium 2358460 Bacteria Bacteria 47 2.78e-4   NR GJL53095.1 2358460 g38113 i0 54.5 0.568965517241379 33 15 56.9 0 72 170 1 33 GJL53095.1 MAG: hypothetical protein NPIRA02_02270 [Nitrospirales bacterium] diamond 99 47 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales     Nitrospirales bacterium
27835049 27835049 PRJNA505329_P_NODE_12424_length_233_cov_3.168478_g11953_i0 PRJNA505329 12424 233 3.168478 7.38255374 Nitrospira sp. 70125 Bacteria Bacteria 89.7 9.17e-19   NR MDX2251353.1 70125 g11953 i0 67.1 0.978540772532189 76 18 88.8 1 232 26 396 471 MDX2251353.1 DEAD/DEAH box helicase [Nitrospira sp.] diamond 228 89.7 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
27898187 27898187 PRJNA505329_P_NODE_32045_length_184_cov_2.266667_g31574_i0 PRJNA505329 32045 184 2.266667 4.17066728 Nitrospirota bacterium 2026887 Bacteria Bacteria 114 4.41e-31   NR MCX5721018.1 2026887 g31574 i0 93.3 0.978260869565217 60 4 97.8 0 1 180 35 94 MCX5721018.1 PilZ domain-containing protein [Nitrospirota bacterium] diamond 180 114 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
27929931 27929931 PRJNA505329_P_NODE_51605_length_156_cov_2.878505_g51134_i0 PRJNA505329 51605 156 2.878505 4.4904678 Nitrospira sp. 70125 Bacteria Bacteria 91.3 8.189999999999999e-23   NR MBH0192638.1 70125 g51134 i0 92 0.961538461538462 50 4 96.2 0 5 154 5 54 MBH0192638.1 hypothetical protein [Nitrospira sp.] diamond 150 91.3 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
28387346 28387346 PRJNA505329_P_NODE_33246_length_182_cov_2.353383_g32775_i0 PRJNA505329 33246 182 2.353383 4.28315706 Bacteria 2 Bacteria Bacteria 60.5 1.74e-10   NR MEK7271991.1 2026887 g32775 i0 96.6 0.956043956043956 29 1 47.8 0 92 178 1 29 MEK7271991.1 ribonuclease PH [Nitrospirota bacterium] diamond 174 60.5 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
28640189 28640189 PRJNA505329_P_NODE_28527_length_189_cov_2.357143_g28056_i0 PRJNA505329 28527 189 2.357143 4.45500027 Pseudomonadati 3379134 Bacteria Bacteria 102 1.68e-23   NR TKB63190.1 70125 g28056 i0 86.4 1.87301587301587 59 8 93.7 0 6 182 477 535 TKB63190.1 MAG: asparagine synthase (glutamine-hydrolyzing) [Nitrospira sp.] diamond 354 103 0.990291262135922 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
28940478 28940478 PRJNA505329_P_NODE_11548_length_233_cov_3.331522_g11077_i0 PRJNA505329 11548 233 3.331522 7.76244626 Nitrospirota bacterium 2026887 Bacteria Bacteria 62.8 2.19e-9   NR PHX90621.1 2026887 g11077 i0 84.8 0.424892703862661 33 5 42.5 0 230 132 261 293 PHX90621.1 MAG: hypothetical protein CK534_05010 [Nitrospirota bacterium] diamond 99 62.8 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
29129960 29129960 PRJNA505329_P_NODE_38949_length_173_cov_3.120968_g38478_i0 PRJNA505329 38949 173 3.120968 5.39927464 Nitrospirales bacterium 2358460 Bacteria Bacteria 56.6 1.83e-7   NR MDO8546268.1 2358460 g38478 i0 87.9 0.572254335260116 33 4 57.2 0 74 172 1 33 MDO8546268.1 TonB-dependent receptor [Nitrospirales bacterium] diamond 99 56.6 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales     Nitrospirales bacterium
29271260 29271260 PRJNA505329_P_NODE_19569_length_201_cov_5.006579_g19098_i0 PRJNA505329 19569 201 5.006579 10.06322379 Nitrospira 1234 Bacteria Bacteria 73.2 1.45e-13   NR MBX3328005.1 70125 g19098 i0 100 2.95522388059702 33 0 49.3 0 4 102 113 145 MBX3328005.1 adenylosuccinate synthetase [Nitrospira sp.] diamond 594 73.2 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
29334646 29334646 PRJNA505329_P_NODE_24189_length_196_cov_4.081633_g23718_i0 PRJNA505329 24189 196 4.081633 8.00000068 Bacteria 2 Bacteria Bacteria 120 3.05e-33   NR MEQ1792125.1 2026770 g23718 i0 95.3 3.91836734693878 64 3 98 0 193 2 4 67 MEQ1792125.1 S1 RNA-binding domain-containing protein [Nitrospiraceae bacterium] diamond 768 120 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium
29697623 29697623 PRJNA505329_P_NODE_38370_length_174_cov_2.472000_g37899_i0 PRJNA505329 38370 174 2.472 4.30128 Nitrospira sp. 70125 Bacteria Bacteria 107 1.88e-27   NR NJL15803.1 70125 g37899 i0 91.2 1.96551724137931 57 5 98.3 0 173 3 16 72 NJL15803.1 PIG-L family deacetylase [Nitrospira sp.] diamond 342 107 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
29871461 29871461 PRJNA505329_P_NODE_51691_length_156_cov_2.700935_g51220_i0 PRJNA505329 51691 156 2.700935 4.2134586 Nitrospira 1234 Bacteria Bacteria 89.4 1.3e-19   NR MBX3303493.1 70125 g51220 i0 90 4.80769230769231 50 5 96.2 0 5 154 129 178 MBX3303493.1 type II secretion system F family protein [Nitrospira sp.] diamond 750 89.4 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
29887652 29887652 PRJNA505329_P_NODE_13971_length_233_cov_2.771739_g13500_i0 PRJNA505329 13971 233 2.771739 6.45815187 Nitrospira moscoviensis 42253 Bacteria Bacteria 58.9 2.78e-8   NR WP_053379318.1 42253 g13500 i0 81.8 2.1244635193133 33 6 42.5 0 232 134 84 116 WP_053379318.1 SGNH/GDSL hydrolase family protein [Nitrospira moscoviensis] diamond 495 58.9 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira moscoviensis
30866912 30866912 PRJNA505329_P_NODE_40794_length_170_cov_4.074380_g40323_i0 PRJNA505329 40794 170 4.07438 6.926446 Nitrospira sp. 70125 Bacteria Bacteria 83.2 4.78e-17   NR MDH5666866.1 70125 g40323 i0 67.3 0.917647058823529 52 17 91.8 0 169 14 43 94 MDH5666866.1 hypothetical protein [Nitrospira sp.] diamond 156 83.2 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
31973667 31973667 PRJNA505329_P_NODE_43758_length_167_cov_2.601695_g43287_i0 PRJNA505329 43758 167 2.601695 4.34483065 Nitrospira sp. 70125 Bacteria Bacteria 58.5 3.51e-8   NR TKB60383.1 70125 g43287 i0 64 1.88622754491018 50 18 89.8 0 166 17 371 420 TKB60383.1 MAG: HAMP domain-containing protein [Nitrospira sp.] diamond 315 58.5 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
32448550 32448550 PRJNA505329_P_NODE_23459_length_198_cov_3.550336_g22988_i0 PRJNA505329 23459 198 3.550336 7.02966528 Nitrospira sp. 70125 Bacteria Bacteria 122 1.47e-32   NR TKB65074.1 70125 g22988 i0 92.3 6.89393939393939 65 5 98.5 0 4 198 80 144 TKB65074.1 MAG: NADH-quinone oxidoreductase subunit F, partial [Nitrospira sp.] diamond 1365 122 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
32700599 32700599 PRJNA505329_P_NODE_50160_length_162_cov_0.920354_g49689_i0 PRJNA505329 50160 162 0.920354 1.49097348 Nitrospira defluvii 330214 Bacteria Bacteria 124 1.02e-33   NR MBI4002537.1 330214 g49689 i0 98.1 2.94444444444444 53 1 98.1 0 3 161 155 207 MBI4002537.1 hypothetical protein [Nitrospira defluvii] diamond 477 124 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira defluvii

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