RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA703759" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 3

tax_superkingdom 1

tax_kingdom 1

  • Thermotogati · 13 ✖

bioproject 1

  • PRJNA703759 · 13 ✖

analysis 1

  • diamond · 13 ✖

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
3235607 3235607 PRJNA703759_P_NODE_39563_length_250_cov_0.881356_g39087_i0 PRJNA703759 39563 250 0.881356 2.20339 Deinococcus koreensis 2054903 Bacteria Bacteria 142 2.83e-37   NR WP_243398102.1 2054903 g39087 i0 80.7 0.996 83 16 99.6 0 249 1 169 251 WP_243398102.1 translocation/assembly module TamB domain-containing protein [Deinococcus koreensis] diamond 249 142 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus koreensis
27177406 27177406 PRJNA703759_P_NODE_23722_length_290_cov_1.248848_g23246_i0 PRJNA703759 23722 290 1.248848 3.6216592 uncultured Fretibacterium sp. 1678694 Bacteria Bacteria 127 1.47e-32   NR WP_299081963.1 1678694 g23246 i0 100 0.724137931034483 70 0 72.4 0 212 3 1 70 WP_299081963.1 TRAP transporter large permease [uncultured Fretibacterium sp.] diamond 210 127 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium uncultured Fretibacterium sp.
27525173 27525173 PRJNA703759_P_NODE_48163_length_244_cov_0.912281_g47687_i0 PRJNA703759 48163 244 0.912281 2.22596564 Deinococcus reticulitermitis 856736 Bacteria Bacteria 113 5.48e-27   NR WP_092265665.1 856736 g47687 i0 67.5 6.94672131147541 80 26 98.4 0 4 243 499 578 WP_092265665.1 glycoside hydrolase family 3 protein [Deinococcus reticulitermitis] diamond 1695 113 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus reticulitermitis
27809546 27809546 PRJNA703759_P_NODE_46604_length_245_cov_0.906977_g46128_i0 PRJNA703759 46604 245 0.906977 2.22209365 Thermus sp. 2.9 1577051 Bacteria Bacteria 92 2.0900000000000002e-22   NR WP_039460343.1 1577051 g46128 i0 74.6 1.53061224489796 63 16 77.1 0 3 191 14 76 WP_039460343.1 hypothetical protein [Thermus sp. 2.9] diamond 375 92 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus sp. 2.9
28072983 28072983 PRJNA703759_P_NODE_23465_length_291_cov_1.371560_g22989_i0 PRJNA703759 23465 291 1.37156 3.9912396 Deinococcus 1298 Bacteria Bacteria 134 1.57e-36   NR WP_322474786.1 1298 g22989 i0 72.6 7.90721649484536 95 26 97.9 0 1 285 93 187 WP_322474786.1 MULTISPECIES: hypothetical protein [Deinococcus] diamond 2301 134 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus  
29178292 29178292 PRJNA703759_P_NODE_49689_length_243_cov_0.917647_g49213_i0 PRJNA703759 49689 243 0.917647 2.22988221 Deinococcus 1298 Bacteria Bacteria 70.5 6.03e-12   NR WP_353540653.1 457454 g49213 i0 55 4.74074074074074 80 35 97.5 1 6 242 331 410 WP_353540653.1 murein hydrolase activator EnvC family protein [Deinococcus xinjiangensis] diamond 1152 70.5 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus xinjiangensis
30746321 30746321 PRJNA703759_P_NODE_37934_length_251_cov_0.876404_g37458_i0 PRJNA703759 37934 251 0.876404 2.19977404 Deinococcus reticulitermitis 856736 Bacteria Bacteria 152 1.64e-41   NR WP_245745486.1 856736 g37458 i0 95.2 0.99203187250996006 83 4 99.2 0 3 251 341 423 WP_245745486.1 DEAD/DEAH box helicase [Deinococcus reticulitermitis] diamond 249 152 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus reticulitermitis
30746334 30746334 PRJNA703759_P_NODE_52054_length_233_cov_2.925000_g51578_i0 PRJNA703759 52054 233 2.925 6.81525 Pseudothermotoga sp. 2033661 Bacteria Bacteria 46.6 0.00139   NR WP_345966101.1 2033661 g51578 i0 69.2 0.669527896995708 26 8 33.5 0 149 226 211 236 WP_345966101.1 L,D-transpeptidase family protein [Pseudothermotoga sp.] diamond 156 46.6 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Pseudothermotoga Pseudothermotoga sp.
30967643 30967643 PRJNA703759_P_NODE_37354_length_251_cov_0.876404_g36878_i0 PRJNA703759 37354 251 0.876404 2.19977404 Deinococcus sp. JMULE3 2518341 Bacteria Bacteria 56.2 6.61e-7   NR WP_174369222.1 2518341 g36878 i0 88.9 0.322709163346614 27 3 32.3 0 2 82 298 324 WP_174369222.1 tetratricopeptide repeat protein [Deinococcus sp. JMULE3] diamond 81 56.2 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. JMULE3
31104865 31104865 PRJNA703759_P_NODE_39235_length_250_cov_0.881356_g38759_i0 PRJNA703759 39235 250 0.881356 2.20339 Bacteria 2 Bacteria Bacteria 95.1 4.19e-21   NR WP_231623779.1 271 g38759 i0 53 3.912 83 39 99.6 0 249 1 83 165 WP_231623779.1 serine hydrolase [Thermus aquaticus] diamond 978 95.1 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus aquaticus
31346913 31346913 PRJNA703759_P_NODE_45536_length_245_cov_1.802326_g45060_i0 PRJNA703759 45536 245 1.802326 4.4156987 Deinococcus antarcticus 1298767 Bacteria Bacteria 43.9 0.0141   NR WP_380080968.1 1298767 g45060 i0 48.5 0.808163265306122 66 32 78.4 2 51 242 1 66 WP_380080968.1 SDR family oxidoreductase [Deinococcus antarcticus] diamond 198 43.9 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus antarcticus
31737321 31737321 PRJNA703759_P_NODE_35177_length_253_cov_0.866667_g34701_i0 PRJNA703759 35177 253 0.866667 2.19266751 Deinococcus 1298 Bacteria Bacteria 45.4 0.00452   NR WP_380061131.1 309883 g34701 i0 95.7 1.63636363636364 23 1 27.3 0 185 253 1 23 WP_380061131.1 sugar phosphate nucleotidyltransferase [Deinococcus hohokamensis] diamond 414 45.8 0.991266375545852 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus hohokamensis
32232831 32232831 PRJNA703759_P_NODE_49538_length_243_cov_0.917647_g49062_i0 PRJNA703759 49538 243 0.917647 2.22988221 Thermus scotoductus 37636 Bacteria Bacteria 163 1.31e-46   NR WP_279164610.1 37636 g49062 i0 100 0.987654320987654 80 0 98.8 0 3 242 130 209 WP_279164610.1 esterase-like activity of phytase family protein [Thermus scotoductus] diamond 240 163 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus scotoductus

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