RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where bioproject = "PRJNA1156092", tax_kingdom = "Pseudomonadati" and tax_phylum = "Nitrospirota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrospirota · 8 ✖

tax_kingdom 1

  • Pseudomonadati · 8 ✖

bioproject 1

  • PRJNA1156092 · 8 ✖

analysis 1

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
28366620 28366620 PRJNA1156092_P_NODE_25446_length_248_cov_0.880000_g25316_i0 PRJNA1156092 25446 248 0.88 2.1824 uncultured Nitrospira sp. 157176 Bacteria Bacteria 98.2 6.929999999999999e-23   NR WP_342347815.1 157176 g25316 i0 92 0.604838709677419 50 4 60.5 0 151 2 1 50 WP_342347815.1 23S rRNA (guanosine(2251)-2'-O)-methyltransferase RlmB [uncultured Nitrospira sp.] diamond 150 98.2 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira uncultured Nitrospira sp.
28903322 28903322 PRJNA1156092_P_NODE_21628_length_252_cov_1.318436_g21498_i0 PRJNA1156092 21628 252 1.318436 3.32245872 Nitrospirales bacterium 2358460 Bacteria Bacteria 148 6.019999999999999e-43   NR NKB82822.1 2358460 g21498 i0 79.5 1.97619047619048 83 17 98.8 0 251 3 42 124 NKB82822.1 ImmA/IrrE family metallo-endopeptidase [Nitrospirales bacterium] diamond 498 148 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales     Nitrospirales bacterium
29156362 29156362 PRJNA1156092_P_NODE_29529_length_244_cov_0.900585_g29399_i0 PRJNA1156092 29529 244 0.900585 2.1974274 Nitrospirota bacterium 2026887 Bacteria Bacteria 104 2.78e-26   NR MDX2347895.1 2026887 g29399 i0 89.7 0.713114754098361 58 6 71.3 0 175 2 1 58 MDX2347895.1 response regulator [Nitrospirota bacterium] diamond 174 104 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
29914119 29914119 PRJNA1156092_P_NODE_27731_length_246_cov_0.890173_g27601_i0 PRJNA1156092 27731 246 0.890173 2.18982558 Nitrospirales bacterium 2358460 Bacteria Bacteria 136 4.14e-36   NR MEE8125997.1 2358460 g27601 i0 86.3 2.95121951219512 80 11 97.6 0 241 2 292 371 MEE8125997.1 amidohydrolase family protein [Nitrospirales bacterium] diamond 726 136 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales     Nitrospirales bacterium
31291885 31291885 PRJNA1156092_P_NODE_26695_length_247_cov_0.879310_g26565_i0 PRJNA1156092 26695 247 0.87931 2.1718957 Bacteria 2 Bacteria Bacteria 164 8.229999999999999e-48   NR HDL21403.1 2026887 g26565 i0 85.4 3.98380566801619 82 12 99.6 0 2 247 162 243 HDL21403.1 aminoglycoside phosphotransferase family protein [Nitrospirota bacterium] diamond 984 165 0.993939393939394 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
31399291 31399291 PRJNA1156092_P_NODE_29596_length_244_cov_0.900585_g29466_i0 PRJNA1156092 29596 244 0.900585 2.1974274 Nitrospirota bacterium 2026887 Bacteria Bacteria 145 3.91e-39   NR NHZ73787.1 2026887 g29466 i0 79 0.995901639344262 81 17 99.6 0 243 1 407 487 NHZ73787.1 SUMF1/EgtB/PvdO family nonheme iron enzyme [Nitrospirota bacterium] diamond 243 145 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
31861207 31861207 PRJNA1156092_P_NODE_31137_length_242_cov_0.911243_g31007_i0 PRJNA1156092 31137 242 0.911243 2.20520806 Bacteria 2 Bacteria Bacteria 120 8.739999999999998e-30   NR OGW28254.1 1801697 g31007 i0 75.3 4.7603305785124 77 19 95.5 0 7 237 75 151 OGW28254.1 MAG: hypothetical protein A2X56_08815 [Nitrospirae bacterium GWC2_57_13] diamond 1152 120 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirae bacterium GWC2_57_13
32695491 32695491 PRJNA1156092_P_NODE_25320_length_248_cov_0.880000_g25190_i0 PRJNA1156092 25320 248 0.88 2.1824 Nitrospira sp. 70125 Bacteria Bacteria 148 8.869999999999999e-43   NR MBL7031715.1 70125 g25190 i0 86.6 0.991935483870968 82 11 99.2 0 2 247 78 159 MBL7031715.1 ATP-binding cassette domain-containing protein [Nitrospira sp.] diamond 246 148 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.

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