RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJNA1120203" and tax_phylum = "Nitrospirota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrospirota · 22 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1120203 · 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
16852653 16852653 PRJNA1120203_P_NODE_80174_length_251_cov_0.865169_g79158_i0 PRJNA1120203 80174 251 0.865169 2.17157419 Pseudomonadati 3379134 Bacteria Bacteria 156 2.86e-42   NR KPK24657.1 1704023 g79158 i0 86.7 13.8884462151394 83 11 99.2 0 251 3 299 381 KPK24657.1 MAG: GTP pyrophosphokinase [Nitrospira bacterium SG8_3] diamond 3486 157 0.993630573248408 Bacteria   Pseudomonadati Nitrospirota Nitrospiria       Nitrospira bacterium SG8_3
21951964 21951964 PRJNA1120203_P_NODE_65058_length_279_cov_1.281553_g64042_i0 PRJNA1120203 65058 279 1.281553 3.57553287 Nitrospirota bacterium 2026887 Bacteria Bacteria 159 7.76e-45   NR MBI5074496.1 2026887 g64042 i0 79.3 1.97849462365591 92 19 98.9 0 3 278 143 234 MBI5074496.1 methylenetetrahydrofolate--tRNA-(uracil(54)-C(5))-methyltransferase (FADH(2)-oxidizing) TrmFO [Nitrospirota bacterium] diamond 552 159 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
26690183 26690183 PRJNA1120203_P_NODE_61241_length_288_cov_0.837209_g60225_i0 PRJNA1120203 61241 288 0.837209 2.41116192 Nitrospira japonica 1325564 Bacteria Bacteria 136 5.65e-35   NR WP_080888432.1 1325564 g60225 i0 63.5 1 96 35 100 0 1 288 130 225 WP_080888432.1 asparagine synthase (glutamine-hydrolyzing) [Nitrospira japonica] diamond 288 136 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira japonica
26901305 26901305 PRJNA1120203_P_NODE_87181_length_248_cov_0.880000_g86165_i0 PRJNA1120203 87181 248 0.88 2.1824 Pseudomonadati 3379134 Bacteria Bacteria 75.1 2.01e-14   NR MBF0557996.1 2026887 g86165 i0 78.6 1.48790322580645 42 9 50.8 0 126 1 1 42 MBF0557996.1 PAS domain-containing protein [Nitrospirota bacterium] diamond 369 75.1 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
27006674 27006674 PRJNA1120203_P_NODE_74062_length_259_cov_1.645161_g73046_i0 PRJNA1120203 74062 259 1.645161 4.26096699 Nitrospirota bacterium 2026887 Bacteria Bacteria 160 3.539999999999999e-47   NR NJD57279.1 2026887 g73046 i0 86 0.996138996138996 86 12 99.6 0 2 259 137 222 NJD57279.1 epoxyqueuosine reductase [Nitrospirota bacterium] diamond 258 160 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
27438872 27438872 PRJNA1120203_P_NODE_65003_length_279_cov_1.451456_g63987_i0 PRJNA1120203 65003 279 1.451456 4.04956224 Nitrospirota 40117 Bacteria Bacteria 62.8 5.1e-9   NR MDA8387682.1 2026770 g63987 i0 63.6 2.36559139784946 44 16 47.3 0 277 146 753 796 MDA8387682.1 ATP-binding protein [Nitrospiraceae bacterium] diamond 660 62.8 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium
27512517 27512517 PRJNA1120203_P_NODE_63263_length_283_cov_1.261905_g62247_i0 PRJNA1120203 63263 283 1.261905 3.57119115 Nitrospirota bacterium 2026887 Bacteria Bacteria 151 2.7e-43   NR NTW66334.1 2026887 g62247 i0 73.4 3.98586572438163 94 25 99.6 0 283 2 147 240 NTW66334.1 IS3 family transposase [Nitrospirota bacterium] diamond 1128 151 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
27670506 27670506 PRJNA1120203_P_NODE_78824_length_251_cov_0.865169_g77808_i0 PRJNA1120203 78824 251 0.865169 2.17157419 Nitrospirota bacterium 2026887 Bacteria Bacteria 97.1 8.079999999999998e-24   NR MBI3356396.1 2026887 g77808 i0 92 2.98804780876494 50 4 59.8 0 1 150 71 120 MBI3356396.1 cytochrome c [Nitrospirota bacterium] diamond 750 97.1 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
27954518 27954518 PRJNA1120203_P_NODE_86245_length_248_cov_0.880000_g85229_i0 PRJNA1120203 86245 248 0.88 2.1824 Nitrospiraceae bacterium 2026770 Bacteria Bacteria 132 8.659999999999999e-34   NR HSL02569.1 2026770 g85229 i0 83.8 0.967741935483871 80 13 96.8 0 246 7 460 539 HSL02569.1 hypothetical protein [Nitrospiraceae bacterium] diamond 240 132 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium
27954521 27954521 PRJNA1120203_P_NODE_87805_length_248_cov_0.880000_g86789_i0 PRJNA1120203 87805 248 0.88 2.1824 Nitrospirota bacterium 2026887 Bacteria Bacteria 133 9.45e-36   NR MDP3595563.1 2026887 g86789 i0 71.6 0.979838709677419 81 23 98 0 247 5 250 330 MDP3595563.1 SPASM domain-containing protein [Nitrospirota bacterium] diamond 243 133 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
28649220 28649220 PRJNA1120203_P_NODE_106907_length_227_cov_2.915584_g105891_i0 PRJNA1120203 106907 227 2.915584 6.61837568 Nitrospira sp. 70125 Bacteria Bacteria 143 1.4999999999999998e-39   NR HSA87276.1 70125 g105891 i0 96 0.991189427312775 75 3 99.1 0 226 2 28 102 HSA87276.1 ATP-binding protein [Nitrospira sp.] diamond 225 143 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
29490793 29490793 PRJNA1120203_P_NODE_105350_length_241_cov_0.916667_g104334_i0 PRJNA1120203 105350 241 0.916667 2.20916747 Nitrospira 1234 Bacteria Bacteria 145 5.91e-39   NR WP_053379071.1 42253 g104334 i0 85 7.96680497925311 80 12 99.6 0 240 1 239 318 WP_053379071.1 hypothetical protein [Nitrospira moscoviensis] diamond 1920 145 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira moscoviensis
30323419 30323419 PRJNA1120203_P_NODE_97372_length_244_cov_0.900585_g96356_i0 PRJNA1120203 97372 244 0.900585 2.1974274 Nitrospiraceae bacterium 2026770 Bacteria Bacteria 45.4 0.00423   NR MDA8077780.1 2026770 g96356 i0 50.8 0.725409836065574 59 27 71.3 2 244 71 415 472 MDA8077780.1 FecR domain-containing protein [Nitrospiraceae bacterium] diamond 177 45.4 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium
30386434 30386434 PRJNA1120203_P_NODE_89633_length_247_cov_0.885057_g88617_i0 PRJNA1120203 89633 247 0.885057 2.18609079 Nitrospirae bacterium GWC2_56_14 1801696 Bacteria Bacteria 64.3 4.94e-10   NR OGW39373.1 1801696 g88617 i0 68.9 0.546558704453441 45 14 54.7 0 136 2 4 48 OGW39373.1 MAG: glycosyl transferase [Nitrospirae bacterium GWC2_56_14] diamond 135 64.3 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirae bacterium GWC2_56_14
30891696 30891696 PRJNA1120203_P_NODE_105294_length_241_cov_0.916667_g104278_i0 PRJNA1120203 105294 241 0.916667 2.20916747 Nitrospirales bacterium 2358460 Bacteria Bacteria 121 1.3399999999999998e-32   NR HSF08199.1 2358460 g104278 i0 95.2 0.771784232365145 62 3 77.2 0 239 54 126 187 HSF08199.1 carbon-nitrogen hydrolase family protein [Nitrospirales bacterium] diamond 186 121 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales     Nitrospirales bacterium
31007226 31007226 PRJNA1120203_P_NODE_89674_length_247_cov_0.885057_g88658_i0 PRJNA1120203 89674 247 0.885057 2.18609079 Pseudomonadati 3379134 Bacteria Bacteria 143 4.42e-39   NR HMS82075.1 70125 g88658 i0 74.4 6.97165991902834 82 21 99.6 0 1 246 307 388 HMS82075.1 hypothetical protein [Nitrospira sp.] diamond 1722 143 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
31175644 31175644 PRJNA1120203_P_NODE_94675_length_245_cov_0.895349_g93659_i0 PRJNA1120203 94675 245 0.895349 2.19360505 Thermodesulfovibrionales bacterium 2814272 Bacteria Bacteria 150 2.8299999999999998e-43   NR MFI5293722.1 2814272 g93659 i0 91.4 0.991836734693878 81 7 99.2 0 245 3 160 240 MFI5293722.1 tRNA (guanosine(37)-N1)-methyltransferase TrmD [Thermodesulfovibrionales bacterium] diamond 243 150 1 Bacteria   Pseudomonadati Nitrospirota Thermodesulfovibrionia Thermodesulfovibrionales     Thermodesulfovibrionales bacterium
31291540 31291540 PRJNA1120203_P_NODE_103115_length_242_cov_0.911243_g102099_i0 PRJNA1120203 103115 242 0.911243 2.20520806 Pseudomonadati 3379134 Bacteria Bacteria 85.5 1.38e-17   NR MBW8054396.1 70125 g102099 i0 63.2 1.68595041322314 68 20 78.1 1 189 1 173 240 MBW8054396.1 hypothetical protein [Nitrospira sp.] diamond 408 85.5 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
32283328 32283328 PRJNA1120203_P_NODE_105559_length_241_cov_0.916667_g104543_i0 PRJNA1120203 105559 241 0.916667 2.20916747 Nitrospirota bacterium 2026887 Bacteria Bacteria 144 3.66e-40   NR NHZ73243.1 2026887 g104543 i0 83.8 0.995850622406639 80 13 99.6 0 241 2 98 177 NHZ73243.1 hypothetical protein [Nitrospirota bacterium] diamond 240 144 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
32409718 32409718 PRJNA1120203_P_NODE_79199_length_251_cov_0.865169_g78183_i0 PRJNA1120203 79199 251 0.865169 2.17157419 Nitrospirota bacterium 2026887 Bacteria Bacteria 100 6.18e-23   NR MBI5641271.1 2026887 g78183 i0 64.2 0.968127490039841 81 29 96.8 0 3 245 28 108 MBI5641271.1 DUF4388 domain-containing protein [Nitrospirota bacterium] diamond 243 100 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
32662052 32662052 PRJNA1120203_P_NODE_100620_length_243_cov_0.905882_g99604_i0 PRJNA1120203 100620 243 0.905882 2.20129326 Thermodesulfovibrionales bacterium 2814272 Bacteria Bacteria 126 9.599999999999999e-35   NR MFN3740840.1 2814272 g99604 i0 73.8 5.87654320987654 80 21 98.8 0 243 4 16 95 MFN3740840.1 ribosome recycling factor [Thermodesulfovibrionales bacterium] diamond 1428 126 1 Bacteria   Pseudomonadati Nitrospirota Thermodesulfovibrionia Thermodesulfovibrionales     Thermodesulfovibrionales bacterium
32662072 32662072 PRJNA1120203_P_NODE_84680_length_249_cov_0.875000_g83664_i0 PRJNA1120203 84680 249 0.875 2.17875 Thermodesulfovibrionales bacterium 2814272 Bacteria Bacteria 80.9 1.11e-15   NR MFI5293674.1 2814272 g83664 i0 85.7 0.590361445783133 49 6 57.8 1 3 146 346 394 MFI5293674.1 class I SAM-dependent RNA methyltransferase [Thermodesulfovibrionales bacterium] diamond 147 80.9 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);;