RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA807685" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermotogati · 8 ✖

bioproject 1

  • PRJNA807685 · 8 ✖

analysis 1

  • diamond · 8 ✖

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
806591 806591 PRJNA807685_P_NODE_3741_length_1374_cov_2.081526_g3158_i0 PRJNA807685 3741 1374 2.081526 28.60016724 Deinococcus aquiradiocola 393059 Bacteria Bacteria 404 7.17e-138   NR WP_188963213.1 393059 g3158 i0 96.7 0.467248908296943 214 7 46.7 0 13 654 1 214 WP_188963213.1 hypothetical protein [Deinococcus aquiradiocola] diamond 642 404 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aquiradiocola
4634904 4634904 PRJNA807685_P_NODE_24244_length_272_cov_1.821277_g23171_i0 PRJNA807685 24244 272 1.821277 4.95387344 Deinococcus aquiradiocola 393059 Bacteria Bacteria 182 4.87e-54   NR WP_188960437.1 393059 g23171 i0 98.9 0.992647058823529 90 1 99.3 0 272 3 288 377 WP_188960437.1 ATP-binding protein [Deinococcus aquiradiocola] diamond 270 182 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aquiradiocola
13976578 13976578 PRJNA807685_P_NODE_14791_length_396_cov_1.612813_g13723_i0 PRJNA807685 14791 396 1.612813 6.38673948 Deinococcus aquiradiocola 393059 Bacteria Bacteria 240 1.81e-74   NR WP_188960284.1 393059 g13723 i0 100 0.992424242424242 131 0 99.2 0 395 3 395 525 WP_188960284.1 hypothetical protein [Deinococcus aquiradiocola] diamond 393 240 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aquiradiocola
27054255 27054255 PRJNA807685_P_NODE_57262_length_162_cov_1.112000_g56189_i0 PRJNA807685 57262 162 1.112 1.80144 Deinococcus aquiradiocola 393059 Bacteria Bacteria 87 8.9e-20   NR WP_188962659.1 393059 g56189 i0 95.9 0.907407407407407 49 2 90.7 0 16 162 1 49 WP_188962659.1 hypothetical protein [Deinococcus aquiradiocola] diamond 147 87 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aquiradiocola
27180368 27180368 PRJNA807685_P_NODE_45622_length_181_cov_1.347222_g44549_i0 PRJNA807685 45622 181 1.347222 2.43847182 Deinococcus aquiradiocola 393059 Bacteria Bacteria 115 2.95e-28   NR WP_188960427.1 393059 g44549 i0 95 0.994475138121547 60 3 99.4 0 180 1 857 916 WP_188960427.1 malto-oligosyltrehalose synthase [Deinococcus aquiradiocola] diamond 180 115 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aquiradiocola
28010838 28010838 PRJNA807685_P_NODE_34685_length_212_cov_1.994286_g33612_i0 PRJNA807685 34685 212 1.994286 4.22788632 Deinococcus 1298 Bacteria Bacteria 43.9 0.00976   NR WP_084046826.1 309885 g33612 i0 43.9 1.86792452830189 66 37 93.4 0 205 8 341 406 WP_084046826.1 tetratricopeptide repeat protein [Deinococcus hopiensis] diamond 396 44.3 0.99097065462754 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus hopiensis
29485470 29485470 PRJNA807685_P_NODE_46550_length_179_cov_1.352113_g45477_i0 PRJNA807685 46550 179 1.352113 2.42028227 Deinococcus aestuarii 2774531 Bacteria Bacteria 113 1.6200000000000003e-27   NR WP_343216564.1 2774531 g45477 i0 91.5 0.988826815642458 59 5 98.9 0 1 177 75 133 WP_343216564.1 sensor histidine kinase [Deinococcus aestuarii] diamond 177 113 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aestuarii
32488847 32488847 PRJNA807685_P_NODE_38099_length_200_cov_1.417178_g37026_i0 PRJNA807685 38099 200 1.417178 2.834356 Deinococcus aquiradiocola 393059 Bacteria Bacteria 103 1.3600000000000002e-26   NR GGJ89810.1 393059 g37026 i0 100 1.5 50 0 75 0 3 152 80 129 GGJ89810.1 hypothetical protein GCM10008939_37210 [Deinococcus aquiradiocola] diamond 300 103 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aquiradiocola

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