RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA986481" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Thermotogati · 6 ✖

bioproject 1

  • PRJNA986481 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
7351503 7351503 PRJNA986481_P_NODE_4466_length_741_cov_2.776012_g4052_i0 PRJNA986481 4466 741 2.776012 20.57024892 Pseudothermotoga sp. 2033661 Bacteria Bacteria 125 1.04e-32   NR WP_345967341.1 2033661 g4052 i0 51.3 0.481781376518219 119 56 47.8 2 157 510 4 121 WP_345967341.1 glycine cleavage system protein GcvH [Pseudothermotoga sp.] diamond 357 125 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Pseudothermotoga Pseudothermotoga sp.
26614674 26614674 PRJNA986481_P_NODE_17261_length_394_cov_5.997101_g16736_i0 PRJNA986481 17261 394 5.997101 23.62857794 Deinococcus budaensis 1665626 Bacteria Bacteria 85.5 6.89e-17   NR WP_184026840.1 1665626 g16736 i0 42.7 3.25888324873096 110 58 82.2 2 351 28 190 296 WP_184026840.1 alpha/beta fold hydrolase [Deinococcus budaensis] diamond 1284 85.5 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus budaensis
27531982 27531982 PRJNA986481_P_NODE_4303_length_750_cov_4.804565_g3895_i0 PRJNA986481 4303 750 4.804565 36.0342375 Deinococcus rhizophilus 3049544 Bacteria Bacteria 117 1.59e-29   NR WP_285522375.1 3049544 g3895 i0 90.8 0.26 65 6 26 0 282 88 59 123 WP_285522375.1 type II toxin-antitoxin system PemK/MazF family toxin [Deinococcus rhizophilus] diamond 195 117 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus rhizophilus
29242950 29242950 PRJNA986481_P_NODE_36909_length_268_cov_1.799087_g36384_i0 PRJNA986481 36909 268 1.799087 4.82155316 root 1 Root_unresolved Root_unresolved 107 1.2699999999999999e-24   NR WP_027877425.1 65552 g36384 i0 55.7 8.87686567164179 88 38 97.4 1 4 264 232 319 WP_027877425.1 G8 domain-containing protein [Meiothermus cerbereus] diamond 2379 107 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Meiothermus Meiothermus cerbereus
29931849 29931849 PRJNA986481_P_NODE_57491_length_244_cov_1.035897_g56966_i0 PRJNA986481 57491 244 1.035897 2.52758868 Meiothermus sp. 1955249 Bacteria Bacteria 44.7 0.00775   NR MER3556030.1 1955249 g56966 i0 36.4 0.811475409836066 66 38 77.5 3 224 36 657 721 MER3556030.1 penicillin acylase family protein [Meiothermus sp.] diamond 198 44.7 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Meiothermus Meiothermus sp.
29969134 29969134 PRJNA986481_P_NODE_14971_length_424_cov_1.565333_g14446_i0 PRJNA986481 14971 424 1.565333 6.63701192 Bacteria 2 Bacteria Bacteria 46.2 0.015   NR WP_092264861.1 856736 g14446 i0 40 1.47877358490566 105 48 71.5 5 57 359 194 287 WP_092264861.1 DUF937 domain-containing protein [Deinococcus reticulitermitis] diamond 627 46.2 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus reticulitermitis

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