contig_metadata
9 rows where bioproject = "PRJNA689790", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 668728 | 668728 | PRJNA689790_S_NODE_2001_length_461_cov_2.915094_g1889_i0 | PRJNA689790 | 2001 | 461 | 2.915094 | 13.43858334 | Thermus brockianus | 56956 | Bacteria | Bacteria | 54.7 | 0.012 | NTclustered | gi|1102955210|gb|CP016312.1| | 56956 | g1889 | i0 | 92.5 | 0.17353579175705 | 40 | 0 | 8 | 3 | 171 | 208 | 283113 | 283075 | Thermus brockianus strain GE-1 chromosome, complete genome | blastn | 80 | 54.7 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus brockianus | ||
| 7047369 | 7047369 | PRJNA689790_S_NODE_8386_length_204_cov_1.622754_g8271_i0 | PRJNA689790 | 8386 | 204 | 1.622754 | 3.31041816 | Deinococcus aetherius | 200252 | Bacteria | Bacteria | 108 | 3.74e-19 | NTclustered | gi|2281894955|dbj|AP026560.1| | 200252 | g8271 | i0 | 92.105 | 7.60294117647059 | 76 | 6 | 37 | 0 | 64 | 139 | 2711438 | 2711363 | Deinococcus aetherius ST0316 DNA, complete genome | blastn | 1551 | 108 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus aetherius | ||
| 12657526 | 12657526 | PRJNA689790_S_NODE_10150_length_186_cov_1.771812_g10035_i0 | PRJNA689790 | 10150 | 186 | 1.771812 | 3.29557032 | Deinococcus | 1298 | Bacteria | Bacteria | 113 | 7.19e-21 | NTclustered | gi|730601855|gb|CP010028.1| | 57497 | g10035 | i0 | 86.111 | 43.8494623655914 | 108 | 11 | 57 | 4 | 77 | 182 | 3163778 | 3163883 | Deinococcus swuensis strain DY59, complete genome | blastn | 8156 | 113 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus radiopugnans | ||
| 26670559 | 26670559 | PRJNA689790_S_NODE_6461_length_235_cov_1.575758_g6346_i0 | PRJNA689790 | 6461 | 235 | 1.575758 | 3.7030313 | Trueperaceae bacterium | 2026798 | Bacteria | Bacteria | 69.7 | 7.1e-12 | NR | MFO7543970.1 | 2026798 | g6346 | i0 | 61.7 | 2.2468085106383 | 60 | 21 | 75.3 | 2 | 225 | 49 | 84 | 142 | MFO7543970.1 oxidoreductase [Trueperaceae bacterium] | diamond | 528 | 69.7 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Trueperaceae bacterium | |||
| 28156381 | 28156381 | PRJNA689790_S_NODE_11325_length_177_cov_1.100000_g11210_i0 | PRJNA689790 | 11325 | 177 | 1.1 | 1.947 | Aminobacterium | 81466 | Bacteria | Bacteria | 41.6 | 0.0379 | NR | WP_286934164.1 | 81466 | g11210 | i0 | 42.6 | 1.55932203389831 | 47 | 27 | 79.7 | 0 | 146 | 6 | 12 | 58 | WP_286934164.1 MULTISPECIES: formate/nitrite transporter family protein [Aminobacterium] | diamond | 276 | 41.6 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Aminobacteriaceae | Aminobacterium | |||
| 28925331 | 28925331 | PRJNA689790_S_NODE_10548_length_183_cov_1.068493_g10433_i0 | PRJNA689790 | 10548 | 183 | 1.068493 | 1.95534219 | PVC group | 1783257 | Bacteria | Bacteria | 60.8 | 6.71e-9 | NR | WP_318773950.1 | 1955249 | g10433 | i0 | 62.5 | 8.22950819672131 | 56 | 20 | 90.2 | 1 | 14 | 178 | 687 | 742 | WP_318773950.1 Ig-like domain-containing protein, partial [Meiothermus sp.] | diamond | 1506 | 60.8 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Meiothermus | Meiothermus sp. | ||
| 29797934 | 29797934 | PRJNA689790_S_NODE_8791_length_199_cov_1.925926_g8676_i0 | PRJNA689790 | 8791 | 199 | 1.925926 | 3.83259274 | Synergistales bacterium | 2268201 | Bacteria | Bacteria | 66.2 | 8.19e-11 | NR | MDD4364172.1 | 2268201 | g8676 | i0 | 51.5 | 1.98994974874372 | 66 | 32 | 99.5 | 0 | 2 | 199 | 58 | 123 | MDD4364172.1 carbamate kinase [Synergistales bacterium] | diamond | 396 | 66.2 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Synergistales bacterium | ||||
| 31093397 | 31093397 | PRJNA689790_S_NODE_4975_length_271_cov_2.290598_g4860_i0 | PRJNA689790 | 4975 | 271 | 2.290598 | 6.20752058 | Deinococcus arenicola | 2994950 | Bacteria | Bacteria | 53.9 | 5.61e-6 | NR | WP_317639123.1 | 2994950 | g4860 | i0 | 49.2 | 2.97785977859779 | 59 | 27 | 65.3 | 1 | 270 | 94 | 262 | 317 | WP_317639123.1 leishmanolysin-related zinc metalloendopeptidase [Deinococcus arenicola] | diamond | 807 | 53.9 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus arenicola | ||
| 32022133 | 32022133 | PRJNA689790_S_NODE_16778_length_150_cov_2.070796_g16663_i0 | PRJNA689790 | 16778 | 150 | 2.070796 | 3.106194 | Bacteria | 2 | Bacteria | Bacteria | 70.1 | 2.38e-12 | NR | WP_211317990.1 | 309889 | g16663 | i0 | 61.2 | 10.4 | 49 | 19 | 98 | 0 | 150 | 4 | 173 | 221 | WP_211317990.1 putative Ig domain-containing protein, partial [Deinococcus yavapaiensis] | diamond | 1560 | 70.1 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus yavapaiensis |
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);;