RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA473799", tax_clade = "PVC group" and tax_phylum = "Candidatus Omnitrophota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Omnitrophota · 3 ✖

tax_kingdom 1

tax_clade 1

  • PVC group · 3 ✖

bioproject 1

  • PRJNA473799 · 3 ✖

analysis 1

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
28560631 28560631 PRJNA473799_P_NODE_22027_length_274_cov_1.532338_g21753_i0 PRJNA473799 22027 274 1.532338 4.19860612 Candidatus Omnitrophota bacterium 2035772 Bacteria Bacteria 84.7 3.83e-17   NR NTV30001.1 2035772 g21753 i0 60.9 2.31021897810219 64 25 70.1 0 205 14 10 73 NTV30001.1 hypothetical protein [Candidatus Omnitrophota bacterium] diamond 633 84.7 1 Bacteria PVC group Pseudomonadati Candidatus Omnitrophota         Candidatus Omnitrophota bacterium
30866010 30866010 PRJNA473799_P_NODE_33614_length_252_cov_2.089385_g33340_i0 PRJNA473799 33614 252 2.089385 5.2652502 Omnitrophica WOR_2 bacterium RIFCSPHIGHO2_ 2035772 Bacteria Bacteria 123 2.11e-30   NR OGX29697.1 1801853 g33340 i0 82.4 2.64285714285714 74 13 88.1 0 222 1 1 74 OGX29697.1 MAG: hypothetical protein A2705_00440 [Omnitrophica WOR_2 bacterium RIFCSPHIGHO2_01_FULL_52_10] diamond 666 123 1 Bacteria PVC group Pseudomonadati Candidatus Omnitrophota         Omnitrophica WOR_2 bacterium RIFCSPHIGHO2_01_FULL_52_10
31040507 31040507 PRJNA473799_P_NODE_31915_length_255_cov_2.153846_g31641_i0 PRJNA473799 31915 255 2.153846 5.4923073 Bacteria 2 Bacteria Bacteria 45.1 0.00684   NR MCM8806144.1 2035772 g31641 i0 44.9 1.84705882352941 69 29 76.5 3 36 230 5911 5974 MCM8806144.1 filamentous hemagglutinin N-terminal domain-containing protein [Candidatus Omnitrophota bacterium] diamond 471 45.1 1 Bacteria PVC group Pseudomonadati Candidatus Omnitrophota         Candidatus Omnitrophota 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);;