contig_metadata
11 rows where bioproject = "PRJNA811237", tax_kingdom = "Thermotogati" and tax_superkingdom = "Bacteria"
This data as json, CSV (advanced)
| 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 | ||
| 27338856 | 27338856 | PRJNA811237_S_NODE_35263_length_161_cov_0.910714_g35023_i0 | PRJNA811237 | 35263 | 161 | 0.910714 | 1.46624954 | Deinococcales bacterium | 2478479 | Bacteria | Bacteria | 48.1 | 1.24e-4 | NR | MBC7646480.1 | 2478479 | g35023 | i0 | 57.1 | 0.782608695652174 | 42 | 18 | 78.3 | 0 | 147 | 22 | 179 | 220 | MBC7646480.1 ATP-dependent metallopeptidase FtsH/Yme1/Tma family protein [Deinococcales bacterium] | diamond | 126 | 48.1 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcales bacterium | ||||
| 27433697 | 27433697 | PRJNA811237_S_NODE_18963_length_193_cov_1.416667_g18723_i0 | PRJNA811237 | 18963 | 193 | 1.416667 | 2.73416731 | Synergistaceae bacterium | 2053624 | Bacteria | Bacteria | 76.6 | 1.7e-14 | NR | MDR1916406.1 | 2053624 | g18723 | i0 | 58.3 | 3.59067357512953 | 60 | 25 | 93.3 | 0 | 6 | 185 | 257 | 316 | MDR1916406.1 molecular chaperone DnaJ [Synergistaceae bacterium] | diamond | 693 | 76.6 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Synergistaceae | Synergistaceae bacterium | |||
| 27600373 | 27600373 | PRJNA811237_S_NODE_8184_length_263_cov_1.401869_g7944_i0 | PRJNA811237 | 8184 | 263 | 1.401869 | 3.68691547 | Deinococcus | 1298 | Bacteria | Bacteria | 70.9 | 1.55e-12 | NR | OOV14930.1 | 1938608 | g7944 | i0 | 53.4 | 5.01901140684411 | 73 | 30 | 83.3 | 2 | 258 | 40 | 157 | 225 | OOV14930.1 hypothetical protein BXU09_09940 [Deinococcus sp. LM3] | diamond | 1320 | 71.2 | 0.995786516853933 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. LM3 | ||
| 30780932 | 30780932 | PRJNA811237_S_NODE_7774_length_268_cov_1.744292_g7534_i0 | PRJNA811237 | 7774 | 268 | 1.744292 | 4.67470256 | Deinococcus deserti | 310783 | Bacteria | Bacteria | 58.9 | 1.03e-7 | NR | WP_012692038.1 | 310783 | g7534 | i0 | 36.7 | 1.09701492537313 | 98 | 40 | 94 | 4 | 8 | 259 | 447 | 536 | WP_012692038.1 glutamine--tRNA ligase/YqeY domain fusion protein [Deinococcus deserti] | diamond | 294 | 58.9 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus deserti |
Advanced export
JSON shape: default, array, newline-delimited
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);;