RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "diamond", bioproject = "PRJNA763243" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermotogati · 9 ✖

bioproject 1

  • PRJNA763243 · 9 ✖

analysis 1

  • diamond · 9 ✖

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
14771883 14771883 PRJNA763243_P_NODE_27892_length_310_cov_36.818565_g27546_i0 PRJNA763243 27892 310 36.818565 114.1375515 Deinococcus 1298 Bacteria Bacteria 76.3 4.4e-14   NR WP_184024893.1 1665626 g27546 i0 73.5 1.42258064516129 49 13 47.4 0 148 2 38 86 WP_184024893.1 aminoglycoside phosphotransferase family protein [Deinococcus budaensis] diamond 441 76.3 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus budaensis
26799944 26799944 PRJNA763243_P_NODE_64461_length_239_cov_79.000000_g64115_i0 PRJNA763243 64461 239 79 188.81 Deinococcota bacterium 1913990 Bacteria Bacteria 125 6.67e-35   NR MDQ3397649.1 1913990 g64115 i0 75.6 0.97907949790795 78 19 97.9 0 2 235 18 95 MDQ3397649.1 hypothetical protein [Deinococcota bacterium] diamond 234 125 1 Bacteria   Thermotogati Deinococcota         Deinococcota bacterium
27116194 27116194 PRJNA763243_P_NODE_74042_length_202_cov_4.294574_g73696_i0 PRJNA763243 74042 202 4.294574 8.67503948 Deinococcus phoenicis 1476583 Bacteria Bacteria 101 1.8199999999999994e-23   NR WP_034355042.1 1476583 g73696 i0 78.5 0.965346534653465 65 14 96.5 0 196 2 1 65 WP_034355042.1 ABC transporter substrate-binding protein [Deinococcus phoenicis] diamond 195 101 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus phoenicis
28000942 28000942 PRJNA763243_P_NODE_43105_length_269_cov_3.387755_g42759_i0 PRJNA763243 43105 269 3.387755 9.11306095 Deinococcus 1298 Bacteria Bacteria 100 3.5299999999999995e-23   NR WP_295815648.1 1298 g42759 i0 76.9 0.724907063197026 65 15 72.5 0 72 266 21 85 WP_295815648.1 MULTISPECIES: SIS domain-containing protein [Deinococcus] diamond 195 100 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus  
28253267 28253267 PRJNA763243_P_NODE_69186_length_224_cov_14.370861_g68840_i0 PRJNA763243 69186 224 14.370861 32.19072864 Thermus scotoductus 37636 Bacteria Bacteria 138 2.1499999999999993e-40   NR WP_126170576.1 37636 g68840 i0 94.6 2.94642857142857 74 4 99.1 0 1 222 16 89 WP_126170576.1 hypothetical protein [Thermus scotoductus] diamond 660 138 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus scotoductus
29326751 29326751 PRJNA763243_P_NODE_67489_length_230_cov_2.592357_g67143_i0 PRJNA763243 67489 230 2.592357 5.9624211 Thermus scotoductus 37636 Bacteria Bacteria 82 4.61e-16   NR WP_126187301.1 37636 g67143 i0 74 1.30434782608696 50 13 65.2 0 229 80 905 954 WP_126187301.1 DEAD/DEAH box helicase family protein, partial [Thermus scotoductus] diamond 300 82 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus scotoductus
30748317 30748317 PRJNA763243_P_NODE_54514_length_248_cov_46.045714_g54168_i0 PRJNA763243 54514 248 46.045714 114.19337072 Deinococcus oregonensis 1805970 Bacteria Bacteria 47.4 9.41e-4   NR WP_380005130.1 1805970 g54168 i0 39 0.991935483870968 82 47 96.8 2 246 7 801 881 WP_380005130.1 ATP-binding protein [Deinococcus oregonensis] diamond 246 47.4 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus oregonensis
30779885 30779885 PRJNA763243_P_NODE_65994_length_235_cov_2.216049_g65648_i0 PRJNA763243 65994 235 2.216049 5.20771515 Deinococcota bacterium 1913990 Bacteria Bacteria 119 4.55e-29   NR MDQ3458728.1 1913990 g65648 i0 74 0.982978723404255 77 20 98.3 0 233 3 394 470 MDQ3458728.1 heme lyase CcmF/NrfE family subunit [Deinococcota bacterium] diamond 231 119 1 Bacteria   Thermotogati Deinococcota         Deinococcota bacterium
32107922 32107922 PRJNA763243_P_NODE_59238_length_244_cov_4.052632_g58892_i0 PRJNA763243 59238 244 4.052632 9.88842208 Deinococcales bacterium 2478479 Bacteria Bacteria 74.3 2.86e-13   NR MEZ4629984.1 2478479 g58892 i0 48.8 0.983606557377049 80 40 98.4 1 244 5 74 152 MEZ4629984.1 VIT domain-containing protein [Deinococcales bacterium] diamond 240 74.3 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales     Deinococcales 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);;