RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA898105" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermotogati · 3 ✖

bioproject 1

  • PRJNA898105 · 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
9801734 9801734 PRJNA898105_P_NODE_6548_length_249_cov_0.875000_g6348_i0 PRJNA898105 6548 249 0.875 2.17875 Deinococcus peraridilitoris 432329 Bacteria Bacteria 99.4 2.4399999999999999e-23   NR WP_015235812.1 432329 g6348 i0 59.7 2.67469879518072 72 29 86.7 0 218 3 75 146 WP_015235812.1 3-hydroxybutyrate dehydrogenase [Deinococcus peraridilitoris] diamond 666 99.4 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus peraridilitoris
30150290 30150290 PRJNA898105_P_NODE_5752_length_258_cov_1.291892_g5552_i0 PRJNA898105 5752 258 1.291892 3.33308136 Deinococcus ficus 317577 Bacteria Bacteria 127 6.479999999999998e-35   NR WP_027464351.1 317577 g5552 i0 70.6 0.988372093023256 85 25 98.8 0 256 2 19 103 WP_027464351.1 hypothetical protein [Deinococcus ficus] diamond 255 127 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus ficus
32015572 32015572 PRJNA898105_P_NODE_7758_length_244_cov_0.900585_g7558_i0 PRJNA898105 7758 244 0.900585 2.1974274 Thermus sp. 275 Bacteria Bacteria 114 2.38e-27   NR MEN2982684.1 275 g7558 i0 98.2 0.700819672131147 57 1 70.1 0 72 242 1 57 MEN2982684.1 type IV secretory system conjugative DNA transfer family protein [Thermus sp.] diamond 171 114 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus 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);;