RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA289590" and tax_phylum = "Nitrospirota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrospirota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA289590 · 3 ✖

analysis 1

  • diamond · 3 ✖

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
26648435 26648435 PRJNA289590_P_NODE_12721_length_256_cov_1.444444_g12497_i0 PRJNA289590 12721 256 1.444444 3.69777664 Pseudomonadati 3379134 Bacteria Bacteria 104 5.24e-24   NR MCA9474030.1 70125 g12497 i0 65.1 3.90234375 83 22 97.3 2 251 3 3 78 MCA9474030.1 NERD domain-containing protein [Nitrospira sp.] diamond 999 104 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
26725573 26725573 PRJNA289590_P_NODE_17501_length_215_cov_0.939759_g17277_i0 PRJNA289590 17501 215 0.939759 2.02048185 Nitrospira sp. 70125 Bacteria Bacteria 85.1 3.1e-17   NR MCA9474063.1 70125 g17277 i0 63.4 0.990697674418605 71 25 97.7 1 2 211 348 418 MCA9474063.1 AAA family ATPase [Nitrospira sp.] diamond 213 85.1 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
30660515 30660515 PRJNA289590_P_NODE_18173_length_210_cov_1.602484_g17949_i0 PRJNA289590 18173 210 1.602484 3.3652164 Pseudomonadati 3379134 Bacteria Bacteria 90.5 3.63e-19   NR MCA9474063.1 70125 g17949 i0 59.4 5.91428571428571 69 28 98.6 0 209 3 243 311 MCA9474063.1 AAA family ATPase [Nitrospira sp.] diamond 1242 90.5 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);;