RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA811237" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermotogati · 7 ✖

bioproject 1

  • PRJNA811237 · 7 ✖

analysis 1

  • blastn · 7 ✖

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
808788 808788 PRJNA811237_S_NODE_29441_length_166_cov_0.871795_g29201_i0 PRJNA811237 29441 166 0.871795 1.4471797 Thermus aquaticus 271 Bacteria Bacteria 302 1.2500000000000001e-77   NTclustered gi|939575972|gb|CP010822.1| 498848 g29201 i0 99.398 1 166 1 100 0 1 166 2058480 2058315 Thermus aquaticus Y51MC23, complete genome blastn 166 302 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus aquaticus
3775425 3775425 PRJNA811237_S_NODE_25803_length_171_cov_1.254098_g25563_i0 PRJNA811237 25803 171 1.254098 2.14450758 root 1 Root_unresolved Root_unresolved 316 4.6e-82   NTclustered gi|155128|gb|J04639.1|TTHTAQP1A 271 g25563 i0 100 67.6900584795322 171 0 100 0 1 171 1743 1573 Thermus aquaticus DNA polymerase (PolI) gene blastn 11575 316 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus aquaticus
18660253 18660253 PRJNA811237_S_NODE_32595_length_163_cov_0.894737_g32355_i0 PRJNA811237 32595 163 0.894737 1.45842131 Meiothermus taiwanensis 172827 Bacteria Bacteria 243 7.51e-60   NTclustered gi|1395894659|gb|CP021130.1| 1339250 g32355 i0 93.789 0.987730061349693 161 10 99 0 1 161 1906930 1906770 Meiothermus taiwanensis WR-220 chromosome, complete genome blastn 161 243 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Meiothermus Meiothermus taiwanensis
20349943 20349943 PRJNA811237_S_NODE_25056_length_173_cov_1.645161_g24816_i0 PRJNA811237 25056 173 1.645161 2.84612853 root 1 Root_unresolved Root_unresolved 320 3.61e-83   NTclustered gi|155128|gb|J04639.1|TTHTAQP1A 271 g24816 i0 100 15.2485549132948 173 0 100 0 1 173 1404 1576 Thermus aquaticus DNA polymerase (PolI) gene blastn 2638 320 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus aquaticus
21210953 21210953 PRJNA811237_S_NODE_11817_length_228_cov_1.709497_g11577_i0 PRJNA811237 11817 228 1.709497 3.89765316 Meiothermus ruber 277 Bacteria Bacteria 52.8 0.02   NTclustered gi|290469363|gb|CP001743.1| 504728 g11577 i0 100 0.245614035087719 28 0 12 0 148 175 1505152 1505179 Meiothermus ruber DSM 1279, complete genome blastn 56 52.8 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Meiothermus Meiothermus ruber
21625608 21625608 PRJNA811237_S_NODE_13777_length_216_cov_1.676647_g13537_i0 PRJNA811237 13777 216 1.676647 3.62155752 root 1 Root_unresolved Root_unresolved 399 5.909999999999999e-107   NTclustered gi|155128|gb|J04639.1|TTHTAQP1A 271 g13537 i0 100 60.7268518518519 216 0 100 0 1 216 2124 1909 Thermus aquaticus DNA polymerase (PolI) gene blastn 13117 399 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus aquaticus
25450200 25450200 PRJNA811237_S_NODE_11580_length_230_cov_1.127072_g11340_i0 PRJNA811237 11580 230 1.127072 2.5922656 Bacteria 2 Bacteria Bacteria 420 4.89e-113   NTclustered gi|155128|gb|J04639.1|TTHTAQP1A 271 g11340 i0 99.565 69.3217391304348 230 1 100 0 1 230 368 139 Thermus aquaticus DNA polymerase (PolI) gene blastn 15944 420 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus aquaticus

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