RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJNA543299" and tax_phylum = "Nitrospirota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrospirota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA543299 · 7 ✖

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
27014559 27014559 PRJNA543299_P_NODE_24402_length_163_cov_0.894737_g24245_i0 PRJNA543299 24402 163 0.894737 1.45842131 Nitrospira sp. 70125 Bacteria Bacteria 112 2.39e-27   NR HEX6531349.1 70125 g24245 i0 100 7.67484662576687 52 0 95.7 0 3 158 247 298 HEX6531349.1 FAD-linked oxidase C-terminal domain-containing protein [Nitrospira sp.] diamond 1251 112 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
29509358 29509358 PRJNA543299_P_NODE_25990_length_161_cov_0.910714_g25833_i0 PRJNA543299 25990 161 0.910714 1.46624954 Nitrospirota bacterium 2026887 Bacteria Bacteria 58.9 2.29e-8   NR MBI5316897.1 2026887 g25833 i0 100 0.484472049689441 26 0 48.4 0 3 80 345 370 MBI5316897.1 TldD/PmbA family protein [Nitrospirota bacterium] diamond 78 58.9 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
29540882 29540882 PRJNA543299_P_NODE_22630_length_165_cov_0.862069_g22473_i0 PRJNA543299 22630 165 0.862069 1.42241385 Nitrospira sp. 70125 Bacteria Bacteria 63.5 5.3e-10   NR TKB72061.1 70125 g22473 i0 96.9 0.581818181818182 32 1 58.2 0 3 98 322 353 TKB72061.1 MAG: hypothetical protein E8D46_15105 [Nitrospira sp.] diamond 96 63.5 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
29698476 29698476 PRJNA543299_P_NODE_21310_length_166_cov_0.871795_g21153_i0 PRJNA543299 21310 166 0.871795 1.4471797 Nitrospira sp. 70125 Bacteria Bacteria 60.1 1e-8   NR HAN92282.1 70125 g21153 i0 57.4 0.975903614457831 54 23 97.6 0 166 5 157 210 HAN92282.1 hypothetical protein [Nitrospira sp.] diamond 162 60.1 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
30646381 30646381 PRJNA543299_P_NODE_23113_length_164_cov_0.886957_g22956_i0 PRJNA543299 23113 164 0.886957 1.45460948 Nitrospiraceae bacterium 2026770 Bacteria Bacteria 41.6 0.0113   NR NIA09244.1 2026770 g22956 i0 52.3 0.804878048780488 44 10 76.8 3 23 148 70 104 NIA09244.1 hypothetical protein [Nitrospiraceae bacterium] diamond 132 41.6 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium
30773147 30773147 PRJNA543299_P_NODE_23434_length_164_cov_0.886957_g23277_i0 PRJNA543299 23434 164 0.886957 1.45460948 Nitrospirota bacterium 2026887 Bacteria Bacteria 51.2 1.21e-5   NR TAN45985.1 2026887 g23277 i0 38.6 1.04268292682927 57 30 97 2 162 4 105 160 TAN45985.1 MAG: hypothetical protein EPN22_00525 [Nitrospirota bacterium] diamond 171 51.2 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
32527548 32527548 PRJNA543299_P_NODE_21659_length_166_cov_0.871795_g21502_i0 PRJNA543299 21659 166 0.871795 1.4471797 Pseudomonadati 3379134 Bacteria Bacteria 56.2 5.2e-8   NR HMV57849.1 70125 g21502 i0 50 1.89759036144578 52 26 94 0 161 6 64 115 HMV57849.1 hypothetical protein [Nitrospira sp.] diamond 315 56.2 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);;