RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA942359" 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

  • PRJNA942359 · 7 ✖

analysis 1

  • diamond · 7 ✖

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
11126589 11126589 PRJNA942359_P_NODE_17829_length_246_cov_0.901734_g17714_i0 PRJNA942359 17829 246 0.901734 2.21826564 Nitrospirota bacterium 2026887 Bacteria Bacteria 160 9.04e-47   NR MCE9535777.1 2026887 g17714 i0 97.6 2 82 2 100 0 246 1 182 263 MCE9535777.1 ATP-grasp domain-containing protein [Nitrospirota bacterium] diamond 492 160 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
16226050 16226050 PRJNA942359_P_NODE_6293_length_336_cov_1.262357_g6178_i0 PRJNA942359 6293 336 1.262357 4.24151952 uncultured Nitrospira sp. 157176 Bacteria Bacteria 199 4.97e-61   NR WP_342349387.1 157176 g6178 i0 90.8 1.94642857142857 109 10 97.3 0 327 1 1 109 WP_342349387.1 alpha/beta hydrolase [uncultured Nitrospira sp.] diamond 654 199 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira uncultured Nitrospira sp.
28548229 28548229 PRJNA942359_P_NODE_17367_length_246_cov_0.901734_g17252_i0 PRJNA942359 17367 246 0.901734 2.21826564 Nitrospira 1234 Bacteria Bacteria 125 4.02e-34   NR TKB52926.1 70125 g17252 i0 86.4 2.8780487804878 59 8 72 0 179 3 1 59 TKB52926.1 MAG: hypothetical protein E8D50_09080 [Nitrospira sp.] diamond 708 125 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
29116469 29116469 PRJNA942359_P_NODE_18408_length_245_cov_0.906977_g18293_i0 PRJNA942359 18408 245 0.906977 2.22209365 Nitrospira 1234 Bacteria Bacteria 133 1.81e-38   NR ULA59642.1 70125 g18293 i0 92.4 3.23265306122449 66 5 80.8 0 243 46 31 96 ULA59642.1 MAG: Cytoplasmic protein [Nitrospira sp.] diamond 792 133 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
30214654 30214654 PRJNA942359_P_NODE_10552_length_275_cov_1.544554_g10437_i0 PRJNA942359 10552 275 1.544554 4.2475235 Candidatus Nitrobium versatile 2884831 Bacteria Bacteria 75.1 2.31e-13   NR MBZ0154906.1 2884831 g10437 i0 87.2 0.425454545454545 39 5 42.5 0 275 159 1069 1107 MBZ0154906.1 DUF499 domain-containing protein [Candidatus Nitrobium versatile] diamond 117 75.1 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Candidatus Nitrobium Candidatus Nitrobium versatile
30695512 30695512 PRJNA942359_P_NODE_6613_length_330_cov_0.898833_g6498_i0 PRJNA942359 6613 330 0.898833 2.9661489 Bacteria 2 Bacteria Bacteria 43.1 0.0412   NR MEC4672313.1 2026887 g6498 i0 36.9 1.43636363636364 84 49 72.7 2 87 326 10 93 MEC4672313.1 DUF192 domain-containing protein [Nitrospirota bacterium] diamond 474 43.5 0.990804597701149 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
32586354 32586354 PRJNA942359_P_NODE_17819_length_246_cov_0.901734_g17704_i0 PRJNA942359 17819 246 0.901734 2.21826564 Nitrospira lenta 1436998 Bacteria Bacteria 104 1.5600000000000002e-26   NR WP_121988829.1 1436998 g17704 i0 91.7 0.731707317073171 60 5 73.2 0 182 3 1 60 WP_121988829.1 hypothetical protein [Nitrospira lenta] diamond 180 104 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira lenta

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