RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

30 rows where analysis = "diamond", bioproject = "PRJNA688352" and tax_phylum = "Nitrospirota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrospirota · 30 ✖

tax_kingdom 1

bioproject 1

  • PRJNA688352 · 30 ✖

analysis 1

  • diamond · 30 ✖

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
1942891 1942891 PRJNA688352_P_NODE_7262_length_251_cov_0.865169_g7159_i0 PRJNA688352 7262 251 0.865169 2.17157419 Nitrospirota bacterium 2026887 Bacteria Bacteria 157 9.7e-45   NR MEW6053131.1 2026887 g7159 i0 89 2.9402390438247 82 9 98 0 249 4 196 277 MEW6053131.1 GDP-mannose 4,6-dehydratase [Nitrospirota bacterium] diamond 738 157 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
3217835 3217835 PRJNA688352_P_NODE_9703_length_246_cov_0.890173_g9600_i0 PRJNA688352 9703 246 0.890173 2.18982558 Nitrospirota bacterium 2026887 Bacteria Bacteria 163 1.22e-45   NR MEK7301217.1 2026887 g9600 i0 96.3 2 82 3 100 0 1 246 341 422 MEK7301217.1 transketolase [Nitrospirota bacterium] diamond 492 163 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
5770531 5770531 PRJNA688352_P_NODE_7345_length_251_cov_0.865169_g7242_i0 PRJNA688352 7345 251 0.865169 2.17157419 Thermodesulfovibrionales bacterium 2814272 Bacteria Bacteria 168 8.99e-49   NR HZV46320.1 2814272 g7242 i0 95.2 2.97609561752988 83 4 99.2 0 2 250 204 286 HZV46320.1 methionine adenosyltransferase [Thermodesulfovibrionales bacterium] diamond 747 168 1 Bacteria   Pseudomonadati Nitrospirota Thermodesulfovibrionia Thermodesulfovibrionales     Thermodesulfovibrionales bacterium
17244800 17244800 PRJNA688352_P_NODE_11414_length_243_cov_0.905882_g11311_i0 PRJNA688352 11414 243 0.905882 2.20129326 Nitrospirota bacterium 2026887 Bacteria Bacteria 137 5.28e-36   NR HEC97198.1 2026887 g11311 i0 80 0.987654320987654 80 16 98.8 0 3 242 318 397 HEC97198.1 alkaline phosphatase [Nitrospirota bacterium] diamond 240 137 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
24892970 24892970 PRJNA688352_P_NODE_10380_length_245_cov_0.895349_g10277_i0 PRJNA688352 10380 245 0.895349 2.19360505 Nitrospira sp. 70125 Bacteria Bacteria 60.5 2.01e-8   NR MEQ1845373.1 70125 g10277 i0 71.8 0.477551020408163 39 10 47.8 1 118 2 3 40 MEQ1845373.1 site-specific integrase [Nitrospira sp.] diamond 117 60.5 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
24892976 24892976 PRJNA688352_P_NODE_10740_length_244_cov_0.900585_g10637_i0 PRJNA688352 10740 244 0.900585 2.1974274 Nitrospira sp. CG24D 1985130 Bacteria Bacteria 166 9.33e-46   NR THJ17111.1 1985130 g10637 i0 96.3 0.995901639344262 81 3 99.6 0 1 243 106 186 THJ17111.1 MAG: FAD-binding protein, partial [Nitrospira sp. CG24D] diamond 243 166 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp. CG24D
26777492 26777492 PRJNA688352_P_NODE_8361_length_249_cov_0.875000_g8258_i0 PRJNA688352 8361 249 0.875 2.17875 Bacteria 2 Bacteria Bacteria 148 2.2e-43   NR MCL4477036.1 2026887 g8258 i0 86.6 2.96385542168675 82 11 98.8 0 248 3 24 105 MCL4477036.1 orotate phosphoribosyltransferase [Nitrospirota bacterium] diamond 738 148 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
26797409 26797409 PRJNA688352_P_NODE_7341_length_251_cov_0.865169_g7238_i0 PRJNA688352 7341 251 0.865169 2.17157419 Nitrospirota bacterium 2026887 Bacteria Bacteria 43.5 0.0123   NR MDE3051532.1 2026887 g7238 i0 31.2 0.920318725099602 77 46 92 2 238 8 42 111 MDE3051532.1 hypothetical protein [Nitrospirota bacterium] diamond 231 43.5 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
27113647 27113647 PRJNA688352_P_NODE_11382_length_243_cov_0.905882_g11279_i0 PRJNA688352 11382 243 0.905882 2.20129326 Nitrospiraceae bacterium 2026770 Bacteria Bacteria 125 3.0599999999999993e-34   NR HWI68153.1 2026770 g11279 i0 77.4 1.03703703703704 84 15 98.8 1 242 3 22 105 HWI68153.1 hypothetical protein [Nitrospiraceae bacterium] diamond 252 125 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium
27555949 27555949 PRJNA688352_P_NODE_7324_length_251_cov_0.865169_g7221_i0 PRJNA688352 7324 251 0.865169 2.17157419 Nitrospirota bacterium 2026887 Bacteria Bacteria 160 1.41e-46   NR MFH1025368.1 2026887 g7221 i0 91.6 2.97609561752988 83 7 99.2 0 3 251 23 105 MFH1025368.1 sigma-54 dependent transcriptional regulator [Nitrospirota bacterium] diamond 747 160 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
27651025 27651025 PRJNA688352_P_NODE_10504_length_244_cov_0.900585_g10401_i0 PRJNA688352 10504 244 0.900585 2.1974274 Nitrospirota bacterium 2026887 Bacteria Bacteria 164 1.41e-46   NR NTW59756.1 2026887 g10401 i0 95.1 0.995901639344262 81 4 99.6 0 244 2 298 378 NTW59756.1 ATP-grasp domain-containing protein [Nitrospirota bacterium] diamond 243 164 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
28092912 28092912 PRJNA688352_P_NODE_8665_length_248_cov_0.880000_g8562_i0 PRJNA688352 8665 248 0.88 2.1824 Thermodesulfovibrionales bacterium 2814272 Bacteria Bacteria 149 8.489999999999999e-40   NR HXX81701.1 2814272 g8562 i0 80.5 2.9758064516129 82 16 99.2 0 247 2 3 84 HXX81701.1 patatin-like phospholipase family protein [Thermodesulfovibrionales bacterium] diamond 738 149 1 Bacteria   Pseudomonadati Nitrospirota Thermodesulfovibrionia Thermodesulfovibrionales     Thermodesulfovibrionales bacterium
28957245 28957245 PRJNA688352_P_NODE_11068_length_243_cov_0.905882_g10965_i0 PRJNA688352 11068 243 0.905882 2.20129326 Pseudomonadati 3379134 Bacteria Bacteria 63.2 2.35e-9   NR TLY21392.1 2026887 g10965 i0 44.7 1.64197530864198 76 42 93.8 0 229 2 78 153 TLY21392.1 MAG: peptidase M11 [Nitrospirota bacterium] diamond 399 63.2 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
29166659 29166659 PRJNA688352_P_NODE_7589_length_250_cov_0.870056_g7486_i0 PRJNA688352 7589 250 0.870056 2.17514 Nitrospiraceae bacterium 2026770 Bacteria Bacteria 178 3.82e-50   NR MDA8084342.1 2026770 g7486 i0 96.3 1.968 82 3 98.4 0 2 247 312 393 MDA8084342.1 glucan 1,4-alpha-glucosidase [Nitrospiraceae bacterium] diamond 492 178 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium
29987481 29987481 PRJNA688352_P_NODE_11211_length_243_cov_0.905882_g11108_i0 PRJNA688352 11211 243 0.905882 2.20129326 Nitrospirota bacterium 2026887 Bacteria Bacteria 133 4.55e-38   NR MBI5043601.1 2026887 g11108 i0 76.3 0.987654320987654 80 19 98.8 0 3 242 1 80 MBI5043601.1 hypothetical protein [Nitrospirota bacterium] diamond 240 133 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
30367021 30367021 PRJNA688352_P_NODE_9812_length_246_cov_0.890173_g9709_i0 PRJNA688352 9812 246 0.890173 2.18982558 Nitrospira sp. 70125 Bacteria Bacteria 90.1 1.3100000000000002e-21   NR MBM4136140.1 70125 g9709 i0 95.5 0.536585365853659 44 2 53.7 0 137 6 1 44 MBM4136140.1 response regulator transcription factor [Nitrospira sp.] diamond 132 90.1 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
30524559 30524559 PRJNA688352_P_NODE_9753_length_246_cov_0.890173_g9650_i0 PRJNA688352 9753 246 0.890173 2.18982558 Nitrospirota bacterium 2026887 Bacteria Bacteria 139 4.6e-37   NR MDH4232867.1 2026887 g9650 i0 82.5 0.975609756097561 80 14 97.6 0 240 1 18 97 MDH4232867.1 sigma-54 dependent transcriptional regulator [Nitrospirota bacterium] diamond 240 139 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
30555980 30555980 PRJNA688352_P_NODE_7353_length_251_cov_0.865169_g7250_i0 PRJNA688352 7353 251 0.865169 2.17157419 Nitrospiraceae bacterium 2026770 Bacteria Bacteria 137 2.88e-36   NR MDA8084111.1 2026770 g7250 i0 98.6 0.824701195219124 69 1 82.5 0 3 209 382 450 MDA8084111.1 pitrilysin family protein [Nitrospiraceae bacterium] diamond 207 137 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium
30682343 30682343 PRJNA688352_P_NODE_12253_length_241_cov_0.916667_g12150_i0 PRJNA688352 12253 241 0.916667 2.20916747 Nitrospira sp. 70125 Bacteria Bacteria 158 7.15e-43   NR MBM4146108.1 70125 g12150 i0 92.5 0.995850622406639 80 6 99.6 0 1 240 666 745 MBM4146108.1 PDZ domain-containing protein [Nitrospira sp.] diamond 240 158 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
30872071 30872071 PRJNA688352_P_NODE_9834_length_246_cov_0.890173_g9731_i0 PRJNA688352 9834 246 0.890173 2.18982558 Nitrospirota bacterium 2026887 Bacteria Bacteria 92.8 3.69e-22   NR NHZ73389.1 2026887 g9731 i0 85.7 0.682926829268293 56 8 68.3 0 5 172 67 122 NHZ73389.1 DUF423 domain-containing protein [Nitrospirota bacterium] diamond 168 92.8 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
31187751 31187751 PRJNA688352_P_NODE_8635_length_248_cov_0.880000_g8532_i0 PRJNA688352 8635 248 0.88 2.1824 Thermodesulfovibrionales bacterium 2814272 Bacteria Bacteria 65.1 5.36e-10   NR HWR57513.1 2814272 g8532 i0 42 2.78225806451613 81 47 98 0 243 1 441 521 HWR57513.1 CARDB domain-containing protein [Thermodesulfovibrionales bacterium] diamond 690 65.1 1 Bacteria   Pseudomonadati Nitrospirota Thermodesulfovibrionia Thermodesulfovibrionales     Thermodesulfovibrionales bacterium
31282851 31282851 PRJNA688352_P_NODE_7155_length_251_cov_0.865169_g7052_i0 PRJNA688352 7155 251 0.865169 2.17157419 Nitrospira sp. 70125 Bacteria Bacteria 178 8.49e-52   NR HEX8749816.1 70125 g7052 i0 98.8 0.99203187250996006 83 1 99.2 0 249 1 212 294 HEX8749816.1 hypothetical protein [Nitrospira sp.] diamond 249 178 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
31314574 31314574 PRJNA688352_P_NODE_7375_length_251_cov_0.865169_g7272_i0 PRJNA688352 7375 251 0.865169 2.17157419 Nitrospirota bacterium 2026887 Bacteria Bacteria 149 4.97e-44   NR MBS1112451.1 2026887 g7272 i0 85.7 1.81673306772908 77 11 92 0 250 20 89 165 MBS1112451.1 ogt [Nitrospirota bacterium] diamond 456 149 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
31346313 31346313 PRJNA688352_P_NODE_7296_length_251_cov_0.865169_g7193_i0 PRJNA688352 7296 251 0.865169 2.17157419 Nitrospiraceae bacterium 2026770 Bacteria Bacteria 116 4.22e-28   NR MDA8090884.1 2026770 g7193 i0 68.7 0.99203187250996006 83 26 99.2 0 249 1 8 90 MDA8090884.1 glycosyltransferase [Nitrospiraceae bacterium] diamond 249 116 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium
31757378 31757378 PRJNA688352_P_NODE_9317_length_247_cov_0.885057_g9214_i0 PRJNA688352 9317 247 0.885057 2.18609079 Nitrospirota bacterium 2026887 Bacteria Bacteria 172 3.01e-51   NR MBS1112638.1 2026887 g9214 i0 97.6 2.98785425101215 82 2 99.6 0 1 246 41 122 MBS1112638.1 cytochrome nitrite reductase [Nitrospirota bacterium] diamond 738 172 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
31883833 31883833 PRJNA688352_P_NODE_9837_length_246_cov_0.890173_g9734_i0 PRJNA688352 9837 246 0.890173 2.18982558 Nitrospiraceae bacterium 2026770 Bacteria Bacteria 119 3.55e-29   NR NIA13567.1 2026770 g9734 i0 65.8 0.963414634146341 79 27 96.3 0 8 244 191 269 NIA13567.1 Gfo/Idh/MocA family oxidoreductase [Nitrospiraceae bacterium] diamond 237 119 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium
32137144 32137144 PRJNA688352_P_NODE_12238_length_241_cov_0.916667_g12135_i0 PRJNA688352 12238 241 0.916667 2.20916747 Nitrospiraceae bacterium 2026770 Bacteria Bacteria 158 5.01e-46   NR MDA8103866.1 2026770 g12135 i0 100 0.983402489626556 79 0 98.3 0 3 239 209 287 MDA8103866.1 response regulator [Nitrospiraceae bacterium] diamond 237 158 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium
32232234 32232234 PRJNA688352_P_NODE_8418_length_249_cov_0.875000_g8315_i0 PRJNA688352 8418 249 0.875 2.17875 Nitrospiria bacterium 2306052 Bacteria Bacteria 88.2 8.77e-19   NR HET8760248.1 2306052 g8315 i0 53.9 1.71084337349398 76 34 90.4 1 226 2 1 76 HET8760248.1 HNH endonuclease [Nitrospiria bacterium] diamond 426 88.2 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria       Nitrospiria bacterium
32327283 32327283 PRJNA688352_P_NODE_12339_length_241_cov_0.916667_g12236_i0 PRJNA688352 12339 241 0.916667 2.20916747 Nitrospirota bacterium 2026887 Bacteria Bacteria 107 2.1200000000000003e-27   NR MEP6959712.1 2026887 g12236 i0 80 1.74273858921162 70 14 87.1 0 239 30 100 169 MEP6959712.1 type II secretion system F family protein [Nitrospirota bacterium] diamond 420 107 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
32863304 32863304 PRJNA688352_P_NODE_8160_length_249_cov_0.875000_g8057_i0 PRJNA688352 8160 249 0.875 2.17875 Thermodesulfovibrionales bacterium 2814272 Bacteria Bacteria 113 6.650000000000001e-27   NR HZV45883.1 2814272 g8057 i0 74.4 2.96385542168675 82 21 98.8 0 248 3 296 377 HZV45883.1 chromosome segregation protein SMC [Thermodesulfovibrionales bacterium] diamond 738 113 1 Bacteria   Pseudomonadati Nitrospirota Thermodesulfovibrionia Thermodesulfovibrionales     Thermodesulfovibrionales 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);;