contig_metadata
9 rows where bioproject = "PRJNA670521" and tax_kingdom = "Thermotogati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5741935 | 5741935 | PRJNA670521_P_NODE_86765_length_244_cov_0.900585_g86020_i0 | PRJNA670521 | 86765 | 244 | 0.900585 | 2.1974274 | Deinococcus budaensis | 1665626 | Bacteria | Bacteria | 127 | 2.21e-33 | NR | WP_184025918.1 | 1665626 | g86020 | i0 | 83.8 | 0.983606557377049 | 80 | 13 | 98.4 | 0 | 242 | 3 | 169 | 248 | WP_184025918.1 LLM class flavin-dependent oxidoreductase [Deinococcus budaensis] | diamond | 240 | 127 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus budaensis | ||
| 8291292 | 8291292 | PRJNA670521_P_NODE_20587_length_416_cov_1.807580_g19844_i0 | PRJNA670521 | 20587 | 416 | 1.80758 | 7.5195328 | Thermus brockianus | 56956 | Bacteria | Bacteria | 54.7 | 0.011 | NTclustered | gi|1102955210|gb|CP016312.1| | 56956 | g19844 | i0 | 92.5 | 0.192307692307692 | 40 | 0 | 9 | 3 | 355 | 392 | 283075 | 283113 | Thermus brockianus strain GE-1 chromosome, complete genome | blastn | 80 | 54.7 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus brockianus | ||
| 12644247 | 12644247 | PRJNA670521_P_NODE_8730_length_603_cov_3.577358_g8000_i0 | PRJNA670521 | 8730 | 603 | 3.577358 | 21.57146874 | Bacteria | 2 | Bacteria | Bacteria | 1109 | 0 | NTclustered | gi|281313262|gb|GU214163.1| | 158789 | g8000 | i0 | 99.834 | 105.512437810945 | 603 | 1 | 100 | 0 | 1 | 603 | 765 | 163 | Uncultured Deinococcus sp. clone IAFpp8j45 16S ribosomal RNA gene, partial sequence | blastn | 63624 | 1109 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | uncultured Deinococcus sp. | ||
| 17216010 | 17216010 | PRJNA670521_P_NODE_12594_length_511_cov_1.237443_g11858_i0 | PRJNA670521 | 12594 | 511 | 1.237443 | 6.32333373 | Trueperaceae bacterium | 2026798 | Bacteria | Bacteria | 693 | 0 | NTclustered | gi|2621706202|emb|OY764543.1| | 2026798 | g11858 | i0 | 91.085 | 576.350293542074 | 516 | 41 | 100 | 4 | 1 | 511 | 2559909 | 2559394 | MAG: Trueperaceae bacterium isolate 617606ba-ac04-44ed-b980-3de5d93b502e genome assembly, chromosome: 1 | blastn | 294515 | 693 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Trueperaceae bacterium | |||
| 19016610 | 19016610 | PRJNA670521_P_NODE_53975_length_286_cov_1.516432_g53230_i0 | PRJNA670521 | 53975 | 286 | 1.516432 | 4.33699552 | Deinococcus | 1298 | Bacteria | Bacteria | 239 | 1.89e-58 | NTclustered | gi|485099143|ref|NR_102538.1| | 432329 | g53230 | i0 | 82.578 | 384.888111888112 | 287 | 34 | 97 | 12 | 7 | 282 | 20 | 301 | Deinococcus peraridilitoris strain KR-200 23S ribosomal RNA gene, complete sequence | blastn | 110078 | 239 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus peraridilitoris | ||
| 19765122 | 19765122 | PRJNA670521_P_NODE_57856_length_278_cov_1.009756_g57111_i0 | PRJNA670521 | 57856 | 278 | 1.009756 | 2.80712168 | Deinococcus aquaticus | 328692 | Bacteria | Bacteria | 453 | 5.999999999999999e-123 | NTclustered | gi|2444120906|gb|CP115165.1| | 328692 | g57111 | i0 | 96.043 | 200.543165467626 | 278 | 11 | 100 | 0 | 1 | 278 | 715913 | 716190 | Deinococcus aquaticus strain PB-314 chromosome, complete genome | blastn | 55751 | 453 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus aquaticus | ||
| 28218428 | 28218428 | PRJNA670521_P_NODE_15466_length_469_cov_0.805556_g14724_i0 | PRJNA670521 | 15466 | 469 | 0.805556 | 3.77805764 | Meiothermus hypogaeus | 884155 | Bacteria | Bacteria | 44.7 | 0.047 | NR | WP_119342060.1 | 884155 | g14724 | i0 | 31 | 0.454157782515991 | 71 | 43 | 41.6 | 1 | 171 | 365 | 2 | 72 | WP_119342060.1 lysophospholipid acyltransferase family protein [Meiothermus hypogaeus] | diamond | 213 | 44.7 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Meiothermus | Meiothermus hypogaeus | ||
| 31978230 | 31978230 | PRJNA670521_P_NODE_72958_length_250_cov_0.870056_g72213_i0 | PRJNA670521 | 72958 | 250 | 0.870056 | 2.17514 | Deinococcus aestuarii | 2774531 | Bacteria | Bacteria | 98.6 | 6.84e-22 | NR | WP_216328793.1 | 2774531 | g72213 | i0 | 63.4 | 0.984 | 82 | 26 | 98.4 | 1 | 5 | 250 | 45 | 122 | WP_216328793.1 bifunctional UDP-N-acetylglucosamine diphosphorylase/glucosamine-1-phosphate N-acetyltransferase GlmU [Deinococcus aestuarii] | diamond | 246 | 98.6 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus aestuarii | ||
| 32516443 | 32516443 | PRJNA670521_P_NODE_83839_length_245_cov_0.895349_g83094_i0 | PRJNA670521 | 83839 | 245 | 0.895349 | 2.19360505 | Deinococcus taklimakanensis | 536443 | Bacteria | Bacteria | 129 | 8.88e-33 | NR | WP_386843300.1 | 536443 | g83094 | i0 | 98.4 | 0.783673469387755 | 64 | 1 | 78.4 | 0 | 52 | 243 | 434 | 497 | WP_386843300.1 hypothetical protein [Deinococcus taklimakanensis] | diamond | 192 | 129 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus taklimakanensis |
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);;