RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA551951" and tax_phylum = "Deinococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Deinococcota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA551951 · 7 ✖

analysis 1

  • diamond · 7 ✖

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
520465 520465 PRJNA551951_S_NODE_11301_length_214_cov_2.011173_g11183_i0 PRJNA551951 11301 214 2.011173 4.30391022 Deinococcus 1298 Bacteria Bacteria 122 1.66e-30   NR WP_245745554.1 856736 g11183 i0 90.1 2.97196261682243 71 7 99.5 0 213 1 536 606 WP_245745554.1 copper-translocating P-type ATPase [Deinococcus reticulitermitis] diamond 636 122 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus reticulitermitis
17098195 17098195 PRJNA551951_S_NODE_454_length_1307_cov_145.996069_g425_i0 PRJNA551951 454 1307 145.996069 1908.16862183 Deinococcus carri 1211323 Bacteria Bacteria 786 1.5e-278   NR WP_345465559.1 1211323 g425 i0 100 0.938791124713083 409 0 93.9 0 1251 25 373 781 WP_345465559.1 S8 family serine peptidase [Deinococcus carri] diamond 1227 786 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus carri
29162706 29162706 PRJNA551951_S_NODE_8009_length_282_cov_2.263158_g7891_i0 PRJNA551951 8009 282 2.263158 6.38210556 Deinococcus wulumuqiensis 980427 Bacteria Bacteria 179 6.98e-50   NR WP_278912417.1 980427 g7891 i0 97.9 1 94 2 100 0 1 282 1786 1879 WP_278912417.1 phage tail tape measure protein [Deinococcus wulumuqiensis] diamond 282 179 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus wulumuqiensis
30172934 30172934 PRJNA551951_S_NODE_12032_length_203_cov_2.636905_g11914_i0 PRJNA551951 12032 203 2.636905 5.35291715 Deinococcus wulumuqiensis 980427 Bacteria Bacteria 125 2.3e-31   NR WP_278912417.1 980427 g11914 i0 100 0.960591133004926 65 0 96.1 0 203 9 2128 2192 WP_278912417.1 phage tail tape measure protein [Deinococcus wulumuqiensis] diamond 195 125 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus wulumuqiensis
30646685 30646685 PRJNA551951_S_NODE_6053_length_347_cov_21.336538_g5935_i0 PRJNA551951 6053 347 21.336538 74.03778686 Deinococcus marmoris 249408 Bacteria Bacteria 115 2.93e-27   NR WP_075830066.1 249408 g5935 i0 64.9 1.67723342939481 97 34 83.9 0 24 314 569 665 WP_075830066.1 phage tail tape measure protein [Deinococcus marmoris] diamond 582 115 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus marmoris
31911535 31911535 PRJNA551951_S_NODE_2337_length_625_cov_2.315254_g2243_i0 PRJNA551951 2337 625 2.315254 14.4703375 Deinococcus wulumuqiensis 980427 Bacteria Bacteria 302 6.21e-91   NR WP_278912417.1 980427 g2243 i0 99 0.9984 208 2 99.8 0 624 1 1893 2100 WP_278912417.1 phage tail tape measure protein [Deinococcus wulumuqiensis] diamond 624 302 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus wulumuqiensis
32323183 32323183 PRJNA551951_S_NODE_9359_length_250_cov_11.353488_g9241_i0 PRJNA551951 9359 250 11.353488 28.38372 Meiothermus sp. 1955249 Bacteria Bacteria 115 3.59e-28   NR MER3483618.1 1955249 g9241 i0 84.6 0.78 65 10 78 0 226 32 359 423 MER3483618.1 ABC transporter substrate-binding protein [Meiothermus sp.] diamond 195 115 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Meiothermus Meiothermus 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);;