RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA436017 · 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
27692776 27692776 PRJNA436017_P_NODE_20684_length_180_cov_1.167832_g20386_i0 PRJNA436017 20684 180 1.167832 2.1020976 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 113 1.2900000000000002e-27   NR HNC85192.1 70125 g20386 i0 89.7 6.76666666666667 58 6 96.7 0 179 6 185 242 HNC85192.1 Fic family protein [Nitrospira sp.] diamond 1218 113 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
30218570 30218570 PRJNA436017_P_NODE_21652_length_176_cov_1.086331_g21354_i0 PRJNA436017 21652 176 1.086331 1.91194256 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 51.6 1.08e-5   NR WP_038505962.1 178606 g21354 i0 54.9 4.27840909090909 51 23 86.9 0 23 175 2 52 WP_038505962.1 sensor domain-containing diguanylate cyclase [Leptospirillum ferriphilum] diamond 753 51.6 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Leptospirillum Leptospirillum ferriphilum
31767355 31767355 PRJNA436017_P_NODE_2617_length_583_cov_1.714286_g2357_i0 PRJNA436017 2617 583 1.714286 9.99428738 Pseudomonadati 3379134 Bacteria Bacteria 189 2.72e-57   NR MBF0317489.1 2026887 g2357 i0 51.1 2.75814751286449 180 86 92.6 2 581 42 14 191 MBF0317489.1 NAD(P)H-dependent oxidoreductase [Nitrospirota bacterium] diamond 1608 190 0.994736842105263 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);;