RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA217180" and tax_phylum = "Nitrospirota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrospirota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA217180 · 4 ✖

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
15669893 15669893 PRJNA217180_P_NODE_14933_length_162_cov_0.902655_g14833_i0 PRJNA217180 14933 162 0.902655 1.4623011 Nitrospira sp. 70125 Bacteria Bacteria 100 1.38e-24   NR MEQ1848059.1 70125 g14833 i0 94.4 1 54 3 100 0 162 1 108 161 MEQ1848059.1 lyase family protein [Nitrospira sp.] diamond 162 100 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
31071345 31071345 PRJNA217180_P_NODE_14335_length_163_cov_0.894737_g14235_i0 PRJNA217180 14335 163 0.894737 1.45842131 Nitrospira 1234 Bacteria Bacteria 42.4 0.0168   NR MBS0161809.1 70125 g14235 i0 47.6 2.31901840490798 42 22 77.3 0 9 134 93 134 MBS0161809.1 DNA cytosine methyltransferase [Nitrospira sp.] diamond 378 42.7 0.992974238875878 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
31843882 31843882 PRJNA217180_P_NODE_8217_length_206_cov_1.273885_g8117_i0 PRJNA217180 8217 206 1.273885 2.6242031 Nitrospira sp. 70125 Bacteria Bacteria 50.8 3.12e-5   NR HMV57845.1 70125 g8117 i0 49 0.742718446601942 51 26 74.3 0 51 203 3 53 HMV57845.1 Clp protease ClpP [Nitrospira sp.] diamond 153 50.8 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
32287293 32287293 PRJNA217180_P_NODE_9599_length_189_cov_1.457143_g9499_i0 PRJNA217180 9599 189 1.457143 2.75400027 Nitrospirota bacterium 2026887 Bacteria Bacteria 51.6 1.05e-5   NR HWR72224.1 2026887 g9499 i0 40 0.873015873015873 55 31 84.1 1 29 187 120 174 HWR72224.1 hypothetical protein [Nitrospirota bacterium] diamond 165 51.6 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota 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);;