RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where bioproject = "PRJNA1166865", 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 · 18 ✖

tax_kingdom 1

  • Pseudomonadati · 18 ✖

bioproject 1

  • PRJNA1166865 · 18 ✖

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
5417035 5417035 PRJNA1166865_P_NODE_86725_length_245_cov_0.895349_g86484_i0 PRJNA1166865 86725 245 0.895349 2.19360505 Nitrospira sp. 70125 Bacteria Bacteria 403 5.299999999999998e-108   NTclustered gi|2194436381|gb|CP092080.1| 70125 g86484 i0 96.341 1.00408163265306 246 7 100 2 1 245 2050340 2050096 MAG: Nitrospira sp. isolate UBC1 chromosome blastn 246 403 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
6142453 6142453 PRJNA1166865_P_NODE_46725_length_322_cov_0.927711_g46484_i0 PRJNA1166865 46725 322 0.927711 2.98722942 Pseudomonadati 3379134 Bacteria Bacteria 165 6.169999999999999e-48   NR AKQ04293.1 1665132 g46484 i0 71 28.9099378881988 107 31 99.7 0 322 2 146 252 AKQ04293.1 translation elongation factor Tu [uncultured Nitrospirae bacterium Rifle_16ft_4_minimus_4901] diamond 9309 165 1 Bacteria   Pseudomonadati Nitrospirota         uncultured Nitrospirae bacterium Rifle_16ft_4_minimus_4901
7966567 7966567 PRJNA1166865_P_NODE_58607_length_289_cov_1.287037_g58366_i0 PRJNA1166865 58607 289 1.287037 3.71953693 Nitrospira moscoviensis 42253 Bacteria Bacteria 451 2.26e-122   NTclustered gi|922305621|gb|CP011801.1| 42253 g58366 i0 94.81 37.6470588235294 289 15 100 0 1 289 1277752 1277464 Nitrospira moscoviensis strain NSP M-1, complete genome blastn 10880 451 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira moscoviensis
7966978 7966978 PRJNA1166865_P_NODE_75647_length_251_cov_0.865169_g75406_i0 PRJNA1166865 75647 251 0.865169 2.17157419 Pseudomonadati 3379134 Bacteria Bacteria 156 3.12e-42   NR HEU4683042.1 70125 g75406 i0 96.4 2.97609561752988 83 3 99.2 0 3 251 125 207 HEU4683042.1 monovalent cation/H+ antiporter subunit A [Nitrospira sp.] diamond 747 156 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
13067376 13067376 PRJNA1166865_P_NODE_78591_length_249_cov_1.750000_g78350_i0 PRJNA1166865 78591 249 1.75 4.3575 Nitrospira sp. 70125 Bacteria Bacteria 233 7.5e-57   NTclustered gi|2194428397|gb|CP092079.1| 70125 g78350 i0 83.6 1.00401606425703 250 40 100 1 1 249 1817519 1817270 MAG: Nitrospira sp. isolate UBC3 chromosome blastn 250 233 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
23266050 23266050 PRJNA1166865_P_NODE_83739_length_247_cov_0.885057_g83498_i0 PRJNA1166865 83739 247 0.885057 2.18609079 Nitrospira sp. 70125 Bacteria Bacteria 296 9.34e-76   NTclustered gi|2194428397|gb|CP092079.1| 70125 g83498 i0 88.797 47.2105263157895 241 27 98 0 7 247 1812809 1812569 MAG: Nitrospira sp. isolate UBC3 chromosome blastn 11661 296 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
25265849 25265849 PRJNA1166865_P_NODE_18020_length_505_cov_2.057870_g17779_i0 PRJNA1166865 18020 505 2.05787 10.3922435 Bacteria 2 Bacteria Bacteria 106 3.79e-26   NR HOA84097.1 340095 g17779 i0 56.3 3.11881188118812 87 37 51.1 1 246 503 1 87 HOA84097.1 hydroxylamine reductase [Thermodesulfovibrio thiophilus] diamond 1575 106 1 Bacteria   Pseudomonadati Nitrospirota Thermodesulfovibrionia Thermodesulfovibrionales Thermodesulfovibrionaceae Thermodesulfovibrio Thermodesulfovibrio thiophilus
26850784 26850784 PRJNA1166865_P_NODE_57961_length_290_cov_1.419355_g57720_i0 PRJNA1166865 57961 290 1.419355 4.1161295 Nitrospira sp. 70125 Bacteria Bacteria 71.6 4.51e-12   NR MCG3775456.1 70125 g57720 i0 39.4 0.972413793103448 94 50 97.2 1 5 286 252 338 MCG3775456.1 hypothetical protein [Nitrospira sp.] diamond 282 71.6 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
27577622 27577622 PRJNA1166865_P_NODE_89344_length_244_cov_0.900585_g89103_i0 PRJNA1166865 89344 244 0.900585 2.1974274 Nitrospirota bacterium 2026887 Bacteria Bacteria 42.7 0.0259   NR MBI5633427.1 2026887 g89103 i0 32.2 1.11885245901639 59 39 71.3 1 236 63 129 187 MBI5633427.1 hypothetical protein [Nitrospirota bacterium] diamond 273 42.7 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
28493315 28493315 PRJNA1166865_P_NODE_31487_length_384_cov_1.980707_g31246_i0 PRJNA1166865 31487 384 1.980707 7.60591488 Nitrospira sp. 70125 Bacteria Bacteria 137 2.35e-36   NR HKT33270.1 70125 g31246 i0 60.9 10.875 115 44 89.1 1 384 43 103 217 HKT33270.1 alcohol dehydrogenase [Nitrospira sp.] diamond 4176 137 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
28828072 28828072 PRJNA1166865_P_NODE_63588_length_277_cov_2.205882_g63347_i0 PRJNA1166865 63588 277 2.205882 6.11029314 Pseudomonadati 3379134 Bacteria Bacteria 63.9 1.06e-10   NR HET6674845.1 2026770 g63347 i0 61.7 4.85198555956679 47 18 50.9 0 145 5 20 66 HET6674845.1 hypothetical protein [Nitrospiraceae bacterium] diamond 1344 63.9 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium
29775322 29775322 PRJNA1166865_P_NODE_81851_length_248_cov_0.880000_g81610_i0 PRJNA1166865 81851 248 0.88 2.1824 Pseudomonadati 3379134 Bacteria Bacteria 79.3 5.11e-15   NR MBI4653621.1 2026887 g81610 i0 48.6 4.63306451612903 74 37 89.5 1 16 237 194 266 MBI4653621.1 elongation factor 4 [Nitrospirota bacterium] diamond 1149 79.3 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
30249538 30249538 PRJNA1166865_P_NODE_23532_length_443_cov_1.651351_g23291_i0 PRJNA1166865 23532 443 1.651351 7.31548493 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 136 5.1e-34   NR WP_053379060.1 42253 g23291 i0 50.7 9.09480812641084 148 56 99.5 5 441 1 156 287 WP_053379060.1 iron-containing redox enzyme family protein [Nitrospira moscoviensis] diamond 4029 137 0.992700729927007 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira moscoviensis
30628222 30628222 PRJNA1166865_P_NODE_13913_length_574_cov_1.229541_g13674_i0 PRJNA1166865 13913 574 1.229541 7.05756534 Pseudomonadati 3379134 Bacteria Bacteria 58.5 2.63e-6   NR OGW92741.1 1801718 g13674 i0 41.8 2.46689895470383 79 45 40.8 1 152 385 364 442 OGW92741.1 MAG: serine protease [Nitrospirae bacterium RIFCSPLOWO2_12_FULL_63_8] diamond 1416 58.5 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirae bacterium RIFCSPLOWO2_12_FULL_63_8
31525940 31525940 PRJNA1166865_P_NODE_6516_length_820_cov_1.979920_g6321_i0 PRJNA1166865 6516 820 1.97992 16.235344 Nitrospira sp. 70125 Bacteria Bacteria 60.8 2.61e-6   NR MBM4146623.1 70125 g6321 i0 31.6 0.567073170731707 155 87 54.1 7 749 306 3026 3168 MBM4146623.1 hypothetical protein [Nitrospira sp.] diamond 465 60.8 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
31652119 31652119 PRJNA1166865_P_NODE_14737_length_558_cov_1.270103_g14498_i0 PRJNA1166865 14737 558 1.270103 7.08717474 Nitrospira sp. 70125 Bacteria Bacteria 89.7 4.21e-17   NR MCG3775456.1 70125 g14498 i0 35 0.768817204301075 143 84 76.3 2 6 431 235 369 MCG3775456.1 hypothetical protein [Nitrospira sp.] diamond 429 89.7 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
32430991 32430991 PRJNA1166865_P_NODE_21739_length_461_cov_1.190722_g21498_i0 PRJNA1166865 21739 461 1.190722 5.48922842 Pseudomonadati 3379134 Bacteria Bacteria 68.6 3.08e-11   NR MDW7998106.1 2067987 g21498 i0 29.9 8.2060737527115 127 89 82.6 0 447 67 13 139 MDW7998106.1 SPFH domain-containing protein [Thermodesulfovibrio sp.] diamond 3783 68.9 0.995645863570392 Bacteria   Pseudomonadati Nitrospirota Thermodesulfovibrionia Thermodesulfovibrionales Thermodesulfovibrionaceae Thermodesulfovibrio Thermodesulfovibrio sp.
32664130 32664130 PRJNA1166865_P_NODE_80260_length_249_cov_0.875000_g80019_i0 PRJNA1166865 80260 249 0.875 2.17875 Nitrospira sp. ST-bin5 1978765 Bacteria Bacteria 158 2.7499999999999996e-47   NR OQW64218.1 1978765 g80019 i0 94.9 0.951807228915663 79 4 95.2 0 247 11 98 176 OQW64218.1 MAG: hypothetical protein BVN29_13900 [Nitrospira sp. ST-bin5] diamond 237 158 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp. ST-bin5

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