RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJNA558770" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Thermotogati · 22 ✖

bioproject 1

  • PRJNA558770 · 22 ✖

analysis 1

  • diamond · 22 ✖

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
13292311 13292311 PRJNA558770_P_NODE_155191_length_234_cov_6.065327_g153186_i0 PRJNA558770 155191 234 6.065327 14.19286518 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 92 1.2e-19   NR WP_303296111.1 638849 g153186 i0 62.8 8 78 2 100 1 1 234 248 298 WP_303296111.1 N-6 DNA methylase [Pyramidobacter piscolens] diamond 1872 92.8 0.991379310344828 Bacteria   Thermotogati Synergistota Synergistia Synergistales Dethiosulfovibrionaceae Pyramidobacter Pyramidobacter piscolens
26730327 26730327 PRJNA558770_P_NODE_267241_length_234_cov_1.959799_g265236_i0 PRJNA558770 267241 234 1.959799 4.58592966 Meiothermus sp. 1955249 Bacteria Bacteria 55.5 1.04e-6   NR MER3483618.1 1955249 g265236 i0 96 0.320512820512821 25 1 32.1 0 2 76 268 292 MER3483618.1 ABC transporter substrate-binding protein [Meiothermus sp.] diamond 75 55.5 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Meiothermus Meiothermus sp.
26871830 26871830 PRJNA558770_P_NODE_249661_length_234_cov_2.316583_g247656_i0 PRJNA558770 249661 234 2.316583 5.42080422 Bacteria 2 Bacteria Bacteria 42.4 0.0335   NR MDR1481780.1 2053624 g247656 i0 82.6 0.858974358974359 23 4 29.5 0 74 6 125 147 MDR1481780.1 O-acetyl-ADP-ribose deacetylase [Synergistaceae bacterium] diamond 201 42.4 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Synergistaceae   Synergistaceae bacterium
27078932 27078932 PRJNA558770_P_NODE_345062_length_233_cov_2.484848_g343057_i0 PRJNA558770 345062 233 2.484848 5.78969584 Thermus aquaticus 271 Bacteria Bacteria 54.7 5.02e-7   NR WP_082333136.1 271 g343057 i0 100 0.321888412017167 25 0 32.2 0 233 159 23 47 WP_082333136.1 prepilin-type N-terminal cleavage/methylation domain-containing protein [Thermus aquaticus] diamond 75 54.7 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus aquaticus
27173559 27173559 PRJNA558770_P_NODE_355082_length_232_cov_12.111675_g353077_i0 PRJNA558770 355082 232 12.111675 28.099086 uncultured Fretibacterium sp. 1678694 Bacteria Bacteria 56.2 5.82e-7   NR WP_299300242.1 1678694 g353077 i0 32.7 1.93965517241379 150 28 99.6 1 1 231 502 651 WP_299300242.1 AsmA-like C-terminal region-containing protein [uncultured Fretibacterium sp.] diamond 450 56.2 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium uncultured Fretibacterium sp.
27363667 27363667 PRJNA558770_P_NODE_233723_length_234_cov_2.703518_g231718_i0 PRJNA558770 233723 234 2.703518 6.32623212 Deinococcus oregonensis 1805970 Bacteria Bacteria 48.9 6.37e-5   NR WP_380008336.1 1805970 g231718 i0 95.8 0.307692307692308 24 1 30.8 0 3 74 88 111 WP_380008336.1 excalibur calcium-binding domain-containing protein [Deinococcus oregonensis] diamond 72 48.9 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus oregonensis
27458323 27458323 PRJNA558770_P_NODE_265563_length_234_cov_1.989950_g263558_i0 PRJNA558770 265563 234 1.98995 4.656483 Deinococcus puniceus 1182568 Bacteria Bacteria 49.3 1.6e-4   NR WP_064013560.1 1182568 g263558 i0 95.8 0.307692307692308 24 1 30.8 0 232 161 283 306 WP_064013560.1 DUF3160 domain-containing protein [Deinococcus puniceus] diamond 72 49.3 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus puniceus
27552610 27552610 PRJNA558770_P_NODE_196964_length_234_cov_3.904523_g194959_i0 PRJNA558770 196964 234 3.904523 9.13658382 uncultured Fretibacterium sp. 1678694 Bacteria Bacteria 80.9 2.26e-17   NR WP_366797457.1 1678694 g194959 i0 59.7 0.987179487179487 77 12 98.7 1 232 2 15 72 WP_366797457.1 Fur family transcriptional regulator, partial [uncultured Fretibacterium sp.] diamond 231 80.9 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium uncultured Fretibacterium sp.
27774043 27774043 PRJNA558770_P_NODE_247644_length_234_cov_2.361809_g245639_i0 PRJNA558770 247644 234 2.361809 5.52663306 Thermus scotoductus 37636 Bacteria Bacteria 51.6 1.31e-5   NR RTH04789.1 37636 g245639 i0 87.5 0.307692307692308 24 3 30.8 0 74 3 118 141 RTH04789.1 hypothetical protein CSW50_01920 [Thermus scotoductus] diamond 72 51.6 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus scotoductus
28057991 28057991 PRJNA558770_P_NODE_265365_length_234_cov_1.994975_g263360_i0 PRJNA558770 265365 234 1.994975 4.6682415 Deinococcus hopiensis 309885 Bacteria Bacteria 45.4 0.00365   NR WP_084045564.1 309885 g263360 i0 86.4 0.282051282051282 22 3 28.2 0 233 168 575 596 WP_084045564.1 glycoside hydrolase family 3 protein [Deinococcus hopiensis] diamond 66 45.4 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus hopiensis
28261333 28261333 PRJNA558770_P_NODE_284266_length_234_cov_1.668342_g282261_i0 PRJNA558770 284266 234 1.668342 3.90392028 Bacteria 2 Bacteria Bacteria 46.6 5.38e-4   NR WP_286952881.1 81466 g282261 i0 72 1.64102564102564 25 7 32.1 0 75 1 109 133 WP_286952881.1 MULTISPECIES: hypothetical protein [Aminobacterium] diamond 384 47 0.991489361702128 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Aminobacterium  
28924422 28924422 PRJNA558770_P_NODE_348028_length_233_cov_1.686869_g346023_i0 PRJNA558770 348028 233 1.686869 3.93040477 Bacteria 2 Bacteria Bacteria 44.7 0.00668   NR WP_022800180.1 1298 g346023 i0 83.3 4.80257510729614 24 4 30.9 0 74 3 135 158 WP_022800180.1 MULTISPECIES: type IV pilus twitching motility protein PilT [Deinococcus] diamond 1119 45.1 0.991130820399113 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus  
28942340 28942340 PRJNA558770_P_NODE_217828_length_234_cov_3.155779_g215823_i0 PRJNA558770 217828 234 3.155779 7.38452286 Deinococcus antarcticus 1298767 Bacteria Bacteria 69.7 1.01e-11   NR WP_380080418.1 1298767 g215823 i0 52 0.961538461538462 75 27 96.2 1 230 6 40 105 WP_380080418.1 lactate utilization protein B [Deinococcus antarcticus] diamond 225 69.7 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus antarcticus
29352709 29352709 PRJNA558770_P_NODE_351489_length_232_cov_18.812183_g349484_i0 PRJNA558770 351489 232 18.812183 43.64426456 Deinococcus saxicola 249406 Bacteria Bacteria 49.7 8.76e-5   NR WP_415791901.1 249406 g349484 i0 100 0.620689655172414 24 0 31 0 2 73 121 144 WP_415791901.1 IS110 family transposase, partial [Deinococcus saxicola] diamond 144 49.7 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus saxicola
29398164 29398164 PRJNA558770_P_NODE_146829_length_234_cov_6.648241_g144824_i0 PRJNA558770 146829 234 6.648241 15.55688394 Bacteria 2 Bacteria Bacteria 56.6 4.22e-7   NR 1TAQ_A 271 g144824 i0 100 1.6025641025641 25 0 32.1 0 233 159 141 165 1TAQ_A Chain A, TAQ DNA POLYMERASE [Thermus aquaticus] diamond 375 56.6 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus aquaticus
29731185 29731185 PRJNA558770_P_NODE_198410_length_234_cov_3.844221_g196405_i0 PRJNA558770 198410 234 3.844221 8.99547714 Trueperaceae bacterium 2026798 Bacteria Bacteria 73.2 2.14e-14   NR MDF1521597.1 2026798 g196405 i0 54.7 0.961538461538462 75 22 96.2 1 230 6 22 84 MDF1521597.1 30S ribosomal protein S8 [Trueperaceae bacterium] diamond 225 73.2 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae   Trueperaceae bacterium
30092756 30092756 PRJNA558770_P_NODE_17632_length_467_cov_4.039352_g15806_i0 PRJNA558770 17632 467 4.039352 18.86377384 Bacteria 2 Bacteria Bacteria 60.8 1.79e-7   NR MFN2322047.1 2026798 g15806 i0 90.9 1.27194860813705 33 3 21.2 0 239 141 92 124 MFN2322047.1 NADH-quinone oxidoreductase subunit L [Trueperaceae bacterium] diamond 594 61.2 0.993464052287582 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae   Trueperaceae bacterium
30092764 30092764 PRJNA558770_P_NODE_273392_length_234_cov_1.844221_g271387_i0 PRJNA558770 273392 234 1.844221 4.31547714 Meiothermus 65551 Bacteria Bacteria 46.2 0.00209   NR WP_299432745.1 157471 g271387 i0 33.8 1.98717948717949 77 27 98.7 1 234 4 103 155 WP_299432745.1 hypothetical protein [uncultured Meiothermus sp.] diamond 465 46.2 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Meiothermus uncultured Meiothermus sp.
30647362 30647362 PRJNA558770_P_NODE_242733_length_234_cov_2.472362_g240728_i0 PRJNA558770 242733 234 2.472362 5.78532708 Meiothermus taiwanensis 172827 Bacteria Bacteria 45.1 0.00288   NR WP_119361622.1 172827 g240728 i0 95.8 0.307692307692308 24 1 30.8 0 3 74 137 160 WP_119361622.1 hypothetical protein [Meiothermus taiwanensis] diamond 72 45.1 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Meiothermus Meiothermus taiwanensis
31058733 31058733 PRJNA558770_P_NODE_333975_length_233_cov_5.237374_g331970_i0 PRJNA558770 333975 233 5.237374 12.20308142 Thermaceae bacterium 2614257 Bacteria Bacteria 43.9 0.0123   NR MBF6596469.1 2614257 g331970 i0 95.8 0.605150214592275 24 1 30.9 0 160 231 12 35 MBF6596469.1 sugar ABC transporter substrate-binding protein [Thermaceae bacterium] diamond 141 43.9 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae   Thermaceae bacterium
31975495 31975495 PRJNA558770_P_NODE_262378_length_234_cov_2.050251_g260373_i0 PRJNA558770 262378 234 2.050251 4.79758734 Trueperaceae bacterium 2026798 Bacteria Bacteria 45.1 0.00487   NR HZW99313.1 2026798 g260373 i0 87.5 0.307692307692308 24 3 30.8 0 232 161 244 267 HZW99313.1 hypothetical protein [Trueperaceae bacterium] diamond 72 45.1 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae   Trueperaceae bacterium
32228827 32228827 PRJNA558770_P_NODE_279418_length_234_cov_1.743719_g277413_i0 PRJNA558770 279418 234 1.743719 4.08030246 Deinococcus sp. Arct2-2 2568653 Bacteria Bacteria 67.8 1.83e-11   NR WP_168733653.1 2568653 g277413 i0 50.5 2.33333333333333 91 32 100 1 234 1 28 118 WP_168733653.1 S8 family serine peptidase [Deinococcus sp. Arct2-2] diamond 546 67.8 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. Arct2-2

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