RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJNA340009" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Thermotogati · 15 ✖

bioproject 1

  • PRJNA340009 · 15 ✖

analysis 1

  • diamond · 15 ✖

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
3620751 3620751 PRJNA340009_P_NODE_58523_length_171_cov_1.672131_g58216_i0 PRJNA340009 58523 171 1.672131 2.85934401 Mesotoga sp. 2053577 Bacteria Bacteria 96.3 4.11e-22   NR HRV01178.1 2053577 g58216 i0 85.7 0.982456140350877 56 8 98.2 0 2 169 43 98 HRV01178.1 DUF5309 family protein [Mesotoga sp.] diamond 168 96.3 1 Bacteria   Thermotogati Thermotogota Thermotogae Kosmotogales Kosmotogaceae Mesotoga Mesotoga sp.
4219309 4219309 PRJNA340009_P_NODE_28624_length_231_cov_10.686813_g28317_i0 PRJNA340009 28624 231 10.686813 24.68653803 Bacteria 2 Bacteria Bacteria 128 2.8499999999999995e-35   NR WP_109606442.1 1255275 g28317 i0 80.6 50.1558441558442 72 14 93.5 0 14 229 58 129 WP_109606442.1 MULTISPECIES: ATP-dependent Clp endopeptidase proteolytic subunit ClpP [Oceanotoga] diamond 11586 129 0.992248062015504 Bacteria   Thermotogati Thermotogota Thermotogae Petrotogales Petrotogaceae Oceanotoga  
22068952 22068952 PRJNA340009_P_NODE_66038_length_165_cov_1.758621_g65731_i0 PRJNA340009 66038 165 1.758621 2.90172465 Deinococcus grandis 57498 Bacteria Bacteria 106 5.59e-25   NR WP_058974467.1 57498 g65731 i0 89.1 3 55 6 100 0 165 1 321 375 WP_058974467.1 V-type ATP synthase subunit I [Deinococcus grandis] diamond 495 106 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus grandis
26853450 26853450 PRJNA340009_P_NODE_63981_length_166_cov_1.350427_g63674_i0 PRJNA340009 63981 166 1.350427 2.24170882 Deinococcus saxicola 249406 Bacteria Bacteria 61.2 3.05e-9   NR WP_415789954.1 249406 g63674 i0 52.7 1.98795180722892 55 26 99.4 0 1 165 69 123 WP_415789954.1 HNH endonuclease [Deinococcus saxicola] diamond 330 61.2 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus saxicola
29032886 29032886 PRJNA340009_P_NODE_74488_length_162_cov_0.902655_g74181_i0 PRJNA340009 74488 162 0.902655 1.4623011 Deinococcus fonticola 2528713 Bacteria Bacteria 111 5.12e-27   NR WP_338069172.1 2528713 g74181 i0 100 1 54 0 100 0 1 162 336 389 WP_338069172.1 MBL fold metallo-hydrolase [Deinococcus fonticola] diamond 162 111 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus fonticola
29207914 29207914 PRJNA340009_P_NODE_43909_length_193_cov_3.194444_g43602_i0 PRJNA340009 43909 193 3.194444 6.16527692 Bacteria 2 Bacteria Bacteria 90.5 5.72e-20   NR WP_409605529.1 275 g43602 i0 65 8.87564766839378 60 21 93.3 0 12 191 6 65 WP_409605529.1 hypothetical protein [Thermus sp.] diamond 1713 90.9 0.995599559955996 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus sp.
30391139 30391139 PRJNA340009_P_NODE_60873_length_168_cov_1.714286_g60566_i0 PRJNA340009 60873 168 1.714286 2.88000048 Thermus thermophilus 274 Bacteria Bacteria 98.6 2.32e-23   NR WP_165740296.1 274 g60566 i0 91.1 1 56 5 100 0 1 168 41 96 WP_165740296.1 ABC transporter permease subunit [Thermus thermophilus] diamond 168 98.6 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus thermophilus
30611697 30611697 PRJNA340009_P_NODE_62013_length_167_cov_0.864407_g61706_i0 PRJNA340009 62013 167 0.864407 1.44355969 Allomeiothermus silvanus 52022 Bacteria Bacteria 55.5 4.26e-7   NR WP_013158081.1 52022 g61706 i0 92 0.449101796407186 25 2 44.9 0 1 75 387 411 WP_013158081.1 imidazolonepropionase [Allomeiothermus silvanus] diamond 75 55.5 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Allomeiothermus Allomeiothermus silvanus
31419109 31419109 PRJNA340009_P_NODE_65856_length_165_cov_2.370690_g65549_i0 PRJNA340009 65856 165 2.37069 3.9116385 Thermotogati 3384194 Bacteria Bacteria 97.1 8.079999999999998e-24   NR MFN3692135.1 1871331 g65549 i0 78.2 3 55 12 100 0 165 1 59 113 MFN3692135.1 TIR domain-containing protein [Fervidobacterium sp.] diamond 495 97.1 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium sp.
31623309 31623309 PRJNA340009_P_NODE_67716_length_165_cov_0.879310_g67409_i0 PRJNA340009 67716 165 0.87931 1.4508615 Deinococcus misasensis 392413 Bacteria Bacteria 71.6 4.97e-13   NR WP_084571318.1 392413 g67409 i0 100 0.654545454545455 36 0 65.5 0 163 56 109 144 WP_084571318.1 DMT family transporter [Deinococcus misasensis] diamond 108 71.6 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus misasensis
31813144 31813144 PRJNA340009_P_NODE_72657_length_162_cov_44.008850_g72350_i0 PRJNA340009 72657 162 44.00885 71.294337 Petrotoga olearia 156203 Bacteria Bacteria 81.6 1.13e-16   NR WP_103066482.1 156203 g72350 i0 82.1 1.68518518518519 39 7 72.2 0 160 44 19 57 WP_103066482.1 galactose-1-phosphate uridylyltransferase [Petrotoga olearia] diamond 273 81.6 1 Bacteria   Thermotogati Thermotogota Thermotogae Petrotogales Petrotogaceae Petrotoga Petrotoga olearia
31907998 31907998 PRJNA340009_P_NODE_41837_length_197_cov_4.418919_g41530_i0 PRJNA340009 41837 197 4.418919 8.70527043 Deinococcus misasensis 392413 Bacteria Bacteria 105 2.23e-24   NR WP_051963750.1 392413 g41530 i0 85.5 0.944162436548223 62 9 94.4 0 188 3 577 638 WP_051963750.1 ribonuclease R [Deinococcus misasensis] diamond 186 105 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus misasensis
31908000 31908000 PRJNA340009_P_NODE_43577_length_194_cov_1.406897_g43270_i0 PRJNA340009 43577 194 1.406897 2.72938018 Deinococcus lacus 392561 Bacteria Bacteria 45.4 0.0016   NR WP_380083454.1 392561 g43270 i0 46.7 0.695876288659794 45 24 69.6 0 12 146 68 112 WP_380083454.1 phage tail protein [Deinococcus lacus] diamond 135 45.4 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus lacus
32002941 32002941 PRJNA340009_P_NODE_13038_length_324_cov_4.236364_g12731_i0 PRJNA340009 13038 324 4.236364 13.72581936 Fervidobacterium sp. 1871331 Bacteria Bacteria 84.7 7.03e-18   NR HQE50591.1 1871331 g12731 i0 90 0.37037037037037 40 4 37 0 121 2 140 179 HQE50591.1 hypothetical protein [Fervidobacterium sp.] diamond 120 84.7 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Fervidobacterium Fervidobacterium sp.
32382656 32382656 PRJNA340009_P_NODE_73639_length_162_cov_0.902655_g73332_i0 PRJNA340009 73639 162 0.902655 1.4623011 Deinococcus sp. S9 2545754 Bacteria Bacteria 111 4.95e-29   NR WP_256372754.1 2545754 g73332 i0 100 1.96296296296296 53 0 98.1 0 161 3 105 157 WP_256372754.1 transposase [Deinococcus sp. S9] diamond 318 111 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. S9

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