RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJNA379145" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Thermotogati · 11 ✖

bioproject 1

  • PRJNA379145 · 11 ✖

analysis 1

  • diamond · 11 ✖

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
8054065 8054065 PRJNA379145_P_NODE_33447_length_370_cov_2.077151_g31305_i0 PRJNA379145 33447 370 2.077151 7.6854587 Thermotogae 188708 Bacteria Bacteria 108 1.04e-26   NR WP_072862210.1 287990 g31305 i0 57.9 7.95405405405405 95 39 77 1 44 328 10 103 WP_072862210.1 macro domain-containing protein [Marinitoga hydrogenitolerans] diamond 2943 109 0.990825688073395 Bacteria   Thermotogati Thermotogota Thermotogae Petrotogales Petrotogaceae Marinitoga Marinitoga hydrogenitolerans
15703796 15703796 PRJNA379145_P_NODE_6113_length_1228_cov_6.786611_g5366_i0 PRJNA379145 6113 1228 6.786611 83.33958308 PVC group 1783257 Bacteria Bacteria 245 1.27e-73   NR WP_041082339.1 1508420 g5366 i0 40.4 1.79560260586319 359 200 87.2 7 1135 65 40 386 WP_041082339.1 serpin family protein [Thermotoga profunda] diamond 2205 245 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Thermotoga Thermotoga profunda
26695010 26695010 PRJNA379145_P_NODE_50181_length_232_cov_2.386935_g48027_i0 PRJNA379145 50181 232 2.386935 5.5376892 Petrotogaceae bacterium 2819251 Bacteria Bacteria 40.4 0.0381   NR HOT30906.1 2819251 g48027 i0 52.6 0.491379310344828 38 18 49.1 0 3 116 14 51 HOT30906.1 hypothetical protein [Petrotogaceae bacterium] diamond 114 40.4 1 Bacteria   Thermotogati Thermotogota Thermotogae Petrotogales Petrotogaceae   Petrotogaceae bacterium
27408325 27408325 PRJNA379145_P_NODE_55063_length_208_cov_2.268571_g52909_i0 PRJNA379145 55063 208 2.268571 4.71862768 root 1 Root_unresolved Root_unresolved 53.9 2.06e-7   NR WP_084047938.1 309885 g52909 i0 67.6 4.11057692307692 37 12 53.4 0 113 3 15 51 WP_084047938.1 30S ribosomal protein S15 [Deinococcus hopiensis] diamond 855 54.3 0.992633517495396 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus hopiensis
27707217 27707217 PRJNA379145_P_NODE_56004_length_204_cov_2.339181_g53850_i0 PRJNA379145 56004 204 2.339181 4.77192924 Thermotogota bacterium 2053689 Bacteria Bacteria 51.6 1.04e-5   NR MEA1885386.1 2053689 g53850 i0 57.1 2.26470588235294 42 18 61.8 0 64 189 167 208 MEA1885386.1 response regulator [Thermotogota bacterium] diamond 462 51.6 1 Bacteria   Thermotogati Thermotogota         Thermotogota bacterium
27770177 27770177 PRJNA379145_P_NODE_60784_length_186_cov_1.549020_g58630_i0 PRJNA379145 60784 186 1.54902 2.8811772 Deinococcus multiflagellatus 1656887 Bacteria Bacteria 50.1 3.93e-5   NR WP_380054471.1 1656887 g58630 i0 58.7 3.04838709677419 46 18 72.6 1 146 12 57 102 WP_380054471.1 hypothetical protein [Deinococcus multiflagellatus] diamond 567 50.1 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus multiflagellatus
28653997 28653997 PRJNA379145_P_NODE_24987_length_496_cov_2.123110_g22959_i0 PRJNA379145 24987 496 2.12311 10.5306256 Deinococcus navajonensis 309884 Bacteria Bacteria 107 1.23e-24   NR WP_380040947.1 309884 g22959 i0 45.6 3.84677419354839 125 64 73.2 3 489 127 171 295 WP_380040947.1 leishmanolysin-related zinc metalloendopeptidase [Deinococcus navajonensis] diamond 1908 107 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus navajonensis
29934220 29934220 PRJNA379145_P_NODE_18111_length_641_cov_15.360197_g16333_i0 PRJNA379145 18111 641 15.360197 98.45886277 Bacteria 2 Bacteria Bacteria 271 4.51e-89   NR WP_034337673.1 392413 g16333 i0 63.6 8.35413416536661 198 72 92.7 0 629 36 1 198 WP_034337673.1 cysteine hydrolase [Deinococcus misasensis] diamond 5355 273 0.992673992673993 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus misasensis
31165980 31165980 PRJNA379145_P_NODE_74175_length_150_cov_1.538462_g72020_i0 PRJNA379145 74175 150 1.538462 2.307693 FCB group 1783270 Bacteria Bacteria 44.7 5.69e-4   NR WP_027481645.1 309888 g72020 i0 71.4 4.7 28 8 56 0 65 148 7 34 WP_027481645.1 FKBP-type peptidyl-prolyl cis-trans isomerase [Deinococcus pimensis] diamond 705 44.7 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus pimensis
31781545 31781545 PRJNA379145_P_NODE_29437_length_424_cov_4.994885_g27329_i0 PRJNA379145 29437 424 4.994885 21.1783124 Calidithermus terrae 1408545 Bacteria Bacteria 44.7 0.0476   NR WP_170159516.1 1408545 g27329 i0 39.1 0.452830188679245 64 39 45.3 0 159 350 268 331 WP_170159516.1 PEGA domain-containing protein [Calidithermus terrae] diamond 192 44.7 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Calidithermus Calidithermus terrae
32667033 32667033 PRJNA379145_P_NODE_260_length_3448_cov_4.500146_g209_i0 PRJNA379145 260 3448 4.500146 155.16503408 Kosmotogaceae bacterium 2053567 Bacteria Bacteria 341 2.67e-100   NR MFO7882767.1 2053567 g209 i0 33.9 0.528132250580046 607 357 50.6 16 2638 893 12 599 MFO7882767.1 alpha-amylase family glycosyl hydrolase [Kosmotogaceae bacterium] diamond 1821 341 1 Bacteria   Thermotogati Thermotogota Thermotogae Kosmotogales Kosmotogaceae   Kosmotogaceae 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);;