RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "blastn", bioproject = "PRJNA169559" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermotogati · 12 ✖

bioproject 1

  • PRJNA169559 · 12 ✖

analysis 1

  • blastn · 12 ✖

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
1639772 1639772 PRJNA169559_P_NODE_2542_length_1037_cov_146.067460_g1633_i0 PRJNA169559 2542 1037 146.06746 1514.7195602 Deinococcus sp. QL22 2939437 Bacteria Bacteria 1694 0   NTclustered gi|2238957582|gb|CP097149.1| 2939437 g1633 i0 96.589 392.466730954677 1026 28 99 6 14 1037 1507424 1508444 Deinococcus sp. QL22 chromosome, complete genome blastn 406988 1694 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. QL22
2330088 2330088 PRJNA169559_P_NODE_25302_length_299_cov_1.366667_g23226_i0 PRJNA169559 25302 299 1.366667 4.08633433 Thermus 270 Bacteria Bacteria 204 7.249999999999999e-48   NTclustered gi|470468782|ref|NR_076136.1| 37636 g23226 i0 92.958 108.816053511706 142 7 67 3 161 299 1727 1586 Thermus scotoductus strain SA-01 23S ribosomal RNA gene, complete sequence blastn 32536 204 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus scotoductus
2330109 2330109 PRJNA169559_P_NODE_47322_length_179_cov_97.540000_g45245_i0 PRJNA169559 47322 179 97.54 174.5966 Deinococcus 1298 Bacteria Bacteria 257 2.99e-64   NTclustered gi|1028459476|gb|CP011387.1| 1182568 g45245 i0 95.625 196.826815642458 160 7 89 0 20 179 69596 69755 Deinococcus puniceus strain DY1, complete genome blastn 35232 257 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus puniceus
3605251 3605251 PRJNA169559_P_NODE_2543_length_1037_cov_137.644841_g1633_i1 PRJNA169559 2543 1037 137.644841 1427.37700117 Deinococcus 1298 Bacteria Bacteria 1578 0   NTclustered gi|1751871007|dbj|AP021849.1| 57498 g1633 i1 94.531 375.17743490839 1024 53 99 3 15 1037 422843 423864 Deinococcus grandis ATCC 43672 DNA, complete genome blastn 389059 1591 0.991829038340666 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus grandis
6742668 6742668 PRJNA169559_P_NODE_25306_length_298_cov_144.702602_g23230_i0 PRJNA169559 25306 298 144.702602 431.21375396 Deinococcus actinosclerus 1768108 Bacteria Bacteria 484 2.3e-132   NTclustered gi|972944657|gb|CP013910.1| 1768108 g23230 i0 95.973 315.909395973154 298 12 100 0 1 298 76091 75794 Deinococcus actinosclerus strain BM2 chromosome, complete genome blastn 94141 484 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus actinosclerus
7432728 7432728 PRJNA169559_P_NODE_30386_length_263_cov_2.132479_g28310_i0 PRJNA169559 30386 263 2.132479 5.60841977 Bacteria 2 Bacteria Bacteria 180 1.06e-40   NTclustered gi|1236765911|gb|MF359428.1| 275 g28310 i0 100 67.9847908745247 97 0 70 0 1 97 853 757 Thermus sp. strain InS-183 16S ribosomal RNA gene, partial sequence blastn 17880 180 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus sp.
17632473 17632473 PRJNA169559_P_NODE_5674_length_712_cov_190.906296_g1633_i3 PRJNA169559 5674 712 190.906296 1359.25282752 Deinococcus 1298 Bacteria Bacteria 1277 0   NTclustered gi|1028459476|gb|CP011387.1| 1182568 g1633 i3 99.017 320.476123595506 712 7 100 0 1 712 71381 72092 Deinococcus puniceus strain DY1, complete genome blastn 228179 1288 0.991459627329193 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus puniceus
19491182 19491182 PRJNA169559_P_NODE_8716_length_576_cov_1.824497_g7052_i0 PRJNA169559 8716 576 1.824497 10.50910272 Meiothermus ruber 277 Bacteria Bacteria 189 4.15e-43   NTclustered gi|290469363|gb|CP001743.1| 504728 g7052 i0 84.158 32.4565972222222 202 25 35 7 125 323 1237199 1237396 Meiothermus ruber DSM 1279, complete genome blastn 18695 189 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Meiothermus Meiothermus ruber
20180875 20180875 PRJNA169559_P_NODE_29616_length_267_cov_1.147059_g27540_i0 PRJNA169559 29616 267 1.147059 3.06264753 Thermus 270 Bacteria Bacteria 207 4.93e-49   NTclustered gi|470468782|ref|NR_076136.1| 37636 g27540 i0 100 64.3258426966292 112 0 65 0 156 267 2716 2605 Thermus scotoductus strain SA-01 23S ribosomal RNA gene, complete sequence blastn 17175 207 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus scotoductus
22041618 22041618 PRJNA169559_P_NODE_2698_length_1005_cov_145.028689_g1633_i2 PRJNA169559 2698 1005 145.02868900000001 1457.53832445 Deinococcus actinosclerus 1768108 Bacteria Bacteria 1633 0   NTclustered gi|972944657|gb|CP013910.1| 1768108 g1633 i2 96.024 385.914427860696 1006 37 100 3 1 1005 74228 73225 Deinococcus actinosclerus strain BM2 chromosome, complete genome blastn 387844 1633 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus actinosclerus
22731572 22731572 PRJNA169559_P_NODE_13418_length_457_cov_164.439252_g11515_i0 PRJNA169559 13418 457 164.439252 751.48738164 root 1 Root_unresolved Root_unresolved 769 0   NTclustered gi|2444916559|dbj|LC733524.2| 47478 g11515 i0 96.957 104.846827133479 460 11 100 3 1 457 39 498 Deinococcus sp. AKn-1 gene for 16S rRNA, partial sequence blastn 47915 769 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp.
23316981 23316981 PRJNA169559_P_NODE_16879_length_412_cov_35.245431_g14898_i0 PRJNA169559 16879 412 35.245431 145.21117572 Deinococcus soli (ex Cha et al. 2016) 1309411 Bacteria Bacteria 595 1.4599999999999996e-165   NTclustered gi|821341785|gb|CP011389.1| 1309411 g14898 i0 93.719 220.330097087379 398 23 96 2 2 398 1886367 1885971 'Deinococcus soli' Cha et al. 2014 strain N5, complete genome blastn 90776 595 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus soli (ex Cha et al. 2016)

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