RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA1180292" and tax_phylum = "Deinococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Deinococcota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1180292 · 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
9245700 9245700 PRJNA1180292_P_NODE_10588_length_247_cov_0.896552_g10456_i0 PRJNA1180292 10588 247 0.896552 2.21448344 Deinococcus aetherius 200252 Bacteria Bacteria 113 2.26e-28   NR WP_264775767.1 200252 g10456 i0 83.6 0.813765182186235 67 11 81.4 0 236 36 64 130 WP_264775767.1 PRC and DUF2382 domain-containing protein [Deinococcus aetherius] diamond 201 113 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aetherius
32000425 32000425 PRJNA1180292_P_NODE_12658_length_243_cov_0.917647_g12526_i0 PRJNA1180292 12658 243 0.917647 2.22988221 Allomeiothermus silvanus 52022 Bacteria Bacteria 71.6 1.85e-12   NR WP_013159700.1 52022 g12526 i0 68.9 0.555555555555556 45 14 55.6 0 143 9 43 87 WP_013159700.1 putative CRISPR-associated protein [Allomeiothermus silvanus] diamond 135 71.6 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Allomeiothermus Allomeiothermus silvanus
32538551 32538551 PRJNA1180292_P_NODE_5439_length_299_cov_1.769912_g5307_i0 PRJNA1180292 5439 299 1.769912 5.29203688 Deinococcus aetherius 200252 Bacteria Bacteria 48.9 4.66e-4   NR WP_264778178.1 200252 g5307 i0 78.6 0.280936454849498 28 6 28.1 0 212 295 372 399 WP_264778178.1 hypothetical protein [Deinococcus aetherius] diamond 84 48.9 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aetherius

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);;