RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

  • Pseudomonadati · 13 ✖

bioproject 1

  • PRJNA404067 · 13 ✖

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
13168162 13168162 PRJNA404067_P_NODE_11971_length_305_cov_2.303279_g11585_i0 PRJNA404067 11971 305 2.303279 7.02500095 Nitrospira japonica 1325564 Bacteria Bacteria 329 1.17e-85   NTclustered gi|1167499077|emb|LT828648.1| 1325564 g11585 i0 86.23 10.8918032786885 305 40 100 2 1 305 982653 982351 Nitrospira japonica isolate Genome sequencing of Nitrospira japonica strain NJ11 genome assembly, chromosome: I blastn 3322 329 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira japonica
20816415 20816415 PRJNA404067_P_NODE_35857_length_204_cov_0.860140_g35470_i0 PRJNA404067 35857 204 0.86014 1.7546856 Nitrospira sp. 70125 Bacteria Bacteria 147 7.939999999999999e-31   NTclustered gi|1938802452|gb|CP054184.1| 70125 g35470 i0 85.034 2.13725490196078 147 18 71 4 60 203 1293156 1293301 MAG: Nitrospira sp. isolate H3_NOB1 chromosome, complete genome blastn 436 147 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
23366827 23366827 PRJNA404067_P_NODE_36279_length_203_cov_1.415493_g35892_i0 PRJNA404067 36279 203 1.415493 2.87345079 Nitrospira sp. 70125 Bacteria Bacteria 233 5.889999999999999e-57   NTclustered gi|2194428397|gb|CP092079.1| 70125 g35892 i0 87.879 0.975369458128079 198 24 98 0 1 198 175075 175272 MAG: Nitrospira sp. isolate UBC3 chromosome blastn 198 233 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
24641097 24641097 PRJNA404067_P_NODE_31340_length_209_cov_0.864865_g30953_i0 PRJNA404067 31340 209 0.864865 1.80756785 Nitrospira defluvii 330214 Bacteria Bacteria 219 1.71e-52   NTclustered gi|300603458|emb|FP929003.1| 330214 g30953 i0 86.432 0.952153110047847 199 27 95 0 2 200 1654106 1654304 Candidatus Nitrospira defluvii chromosome, complete genome blastn 199 219 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira defluvii
24641250 24641250 PRJNA404067_P_NODE_39100_length_201_cov_0.878571_g38713_i0 PRJNA404067 39100 201 0.878571 1.76592771 Nitrospira sp. 70125 Bacteria Bacteria 263 7.419999999999999e-66   NTclustered gi|2194428397|gb|CP092079.1| 70125 g38713 i0 90.816 1.92537313432836 196 18 98 0 6 201 200792 200987 MAG: Nitrospira sp. isolate UBC3 chromosome blastn 387 263 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
26822422 26822422 PRJNA404067_P_NODE_24881_length_223_cov_1.549383_g24494_i0 PRJNA404067 24881 223 1.549383 3.45512409 Candidatus Manganitrophaceae bacterium 2932367 Bacteria Bacteria 82.8 2.02e-17   NR MBI3803607.1 2932367 g24494 i0 61.6 0.982062780269058 73 28 98.2 0 219 1 7 79 MBI3803607.1 hypothetical protein [Candidatus Manganitrophaceae bacterium] diamond 219 82.8 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Candidatus Troglogloeales Candidatus Manganitrophaceae   Candidatus Manganitrophaceae bacterium
26948799 26948799 PRJNA404067_P_NODE_44722_length_169_cov_4.370370_g44335_i0 PRJNA404067 44722 169 4.37037 7.3859253 Nitrospira sp. 70125 Bacteria Bacteria 111 3.9900000000000006e-27   NR NOS77599.1 70125 g44335 i0 100 1.95266272189349 55 0 97.6 0 3 167 237 291 NOS77599.1 cytochrome P450 [Nitrospira sp.] diamond 330 111 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
29002214 29002214 PRJNA404067_P_NODE_26868_length_218_cov_1.452229_g26481_i0 PRJNA404067 26868 218 1.452229 3.16585922 Nitrospira lenta 1436998 Bacteria Bacteria 95.1 2.98e-23   NR WP_121989373.1 1436998 g26481 i0 100 0.646788990825688 47 0 64.7 0 2 142 74 120 WP_121989373.1 response regulator [Nitrospira lenta] diamond 141 95.1 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira lenta
29050174 29050174 PRJNA404067_P_NODE_11828_length_307_cov_6.024390_g11442_i0 PRJNA404067 11828 307 6.02439 18.4948773 Pseudomonadati 3379134 Bacteria Bacteria 102 5.16e-23   NR HYM87762.1 2026770 g11442 i0 53.8 4.72964169381108 93 42 89.9 1 1 276 98 190 HYM87762.1 acetate kinase [Nitrospiraceae bacterium] diamond 1452 103 0.990291262135922 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium
29191323 29191323 PRJNA404067_P_NODE_32629_length_207_cov_1.520548_g32242_i0 PRJNA404067 32629 207 1.520548 3.14753436 Nitrospirota bacterium 2026887 Bacteria Bacteria 84.3 1.47e-17   NR MCK9418491.1 2026887 g32242 i0 83.3 0.695652173913043 48 8 69.6 0 145 2 1 48 MCK9418491.1 AmmeMemoRadiSam system protein B [Nitrospirota bacterium] diamond 144 84.3 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
29460209 29460209 PRJNA404067_P_NODE_34430_length_205_cov_1.361111_g34043_i0 PRJNA404067 34430 205 1.361111 2.79027755 Nitrospira 1234 Bacteria Bacteria 95.1 3.7300000000000006e-21   NR MBM4125439.1 70125 g34043 i0 93.6 8.37073170731707 47 3 68.8 0 3 143 180 226 MBM4125439.1 tRNA 4-thiouridine(8) synthase ThiI [Nitrospira sp.] diamond 1716 95.1 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
29934347 29934347 PRJNA404067_P_NODE_37751_length_202_cov_0.900709_g37364_i0 PRJNA404067 37751 202 0.900709 1.81943218 Nitrospira 1234 Bacteria Bacteria 111 9e-27   NR MCS6287308.1 70125 g37364 i0 86.6 8.92574257425743 67 9 99.5 0 202 2 415 481 MCS6287308.1 alpha-D-glucose phosphate-specific phosphoglucomutase [Nitrospira sp.] diamond 1803 111 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
30517772 30517772 PRJNA404067_P_NODE_23533_length_227_cov_0.897590_g23146_i0 PRJNA404067 23533 227 0.89759 2.0375293 Thermodesulfovibrionales bacterium 2814272 Bacteria Bacteria 43.1 0.0132   NR HMK50498.1 2814272 g23146 i0 43.4 0.700440528634361 53 28 67.4 1 47 199 1 53 HMK50498.1 spore coat U domain-containing protein [Thermodesulfovibrionales bacterium] diamond 159 43.1 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);;