RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA846110", tax_phylum = "Nitrospirota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 6 ✖

tax_phylum 1

  • Nitrospirota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA846110 · 6 ✖

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
11435093 11435093 PRJNA846110_P_NODE_17569_length_275_cov_1.400990_g17324_i0 PRJNA846110 17569 275 1.40099 3.8527225 Nitrospira 1234 Bacteria Bacteria 168 3.13e-50   NR HEX7765317.1 70125 g17324 i0 90.1 5.95636363636364 91 9 99.3 0 275 3 29 119 HEX7765317.1 RQC domain-containing protein [Nitrospira sp.] diamond 1638 169 0.994082840236686 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
14861007 14861007 PRJNA846110_P_NODE_26312_length_246_cov_0.890173_g26067_i0 PRJNA846110 26312 246 0.890173 2.18982558 Nitrospira 1234 Bacteria Bacteria 153 6.75e-44   NR TKB67740.1 70125 g26067 i0 85.4 7 82 12 100 0 246 1 111 192 TKB67740.1 MAG: ATP-dependent Clp protease ATP-binding subunit ClpX, partial [Nitrospira sp.] diamond 1722 153 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
21633361 21633361 PRJNA846110_P_NODE_24137_length_249_cov_0.875000_g23892_i0 PRJNA846110 24137 249 0.875 2.17875 Nitrospirota bacterium 2026887 Bacteria Bacteria 162 1.7699999999999996e-47   NR MEK7300281.1 2026887 g23892 i0 96.3 3.93975903614458 82 3 98.8 0 3 248 58 139 MEK7300281.1 molybdopterin-dependent oxidoreductase [Nitrospirota bacterium] diamond 981 162 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
23785385 23785385 PRJNA846110_P_NODE_25499_length_247_cov_0.885057_g25254_i0 PRJNA846110 25499 247 0.885057 2.18609079 Nitrospira sp. 70125 Bacteria Bacteria 326 1.19e-84   NTclustered gi|2194428397|gb|CP092079.1| 70125 g25254 i0 90.612 3.82591093117409 245 23 99 0 1 245 3493324 3493568 MAG: Nitrospira sp. isolate UBC3 chromosome blastn 945 326 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
28886254 28886254 PRJNA846110_P_NODE_18188_length_272_cov_1.412060_g17943_i0 PRJNA846110 18188 272 1.41206 3.8408032 Nitrospira sp. 70125 Bacteria Bacteria 93.2 9.37e-20   NR MCS6285189.1 70125 g17943 i0 89.1 0.606617647058823 55 6 60.7 0 272 108 543 597 MCS6285189.1 HEAT repeat domain-containing protein [Nitrospira sp.] diamond 165 93.2 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
32394364 32394364 PRJNA846110_P_NODE_16019_length_282_cov_1.971292_g15774_i0 PRJNA846110 16019 282 1.971292 5.55904344 Nitrospira sp. 70125 Bacteria Bacteria 173 1.7299999999999994e-52   NR MCS6286684.1 70125 g15774 i0 95.7 1 94 4 100 0 282 1 44 137 MCS6286684.1 ABC transporter substrate-binding protein [Nitrospira sp.] diamond 282 173 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);;