contig_metadata
22 rows where bioproject = "PRJNA1122875" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 277803 | 277803 | PRJNA1122875_P_NODE_42241_length_253_cov_3.222222_g42017_i0 | PRJNA1122875 | 42241 | 253 | 3.222222 | 8.15222166 | Deinococcus radiomollis | 468916 | Bacteria | Bacteria | 52.8 | 0.023 | NTclustered | gi|2865409981|gb|CP129906.1| | 468916 | g42017 | i0 | 100 | 0.110671936758893 | 28 | 0 | 11 | 0 | 114 | 141 | 2390560 | 2390533 | Deinococcus radiomollis strain PO-04-20-132 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus radiomollis | ||
| 1552524 | 1552524 | PRJNA1122875_P_NODE_5542_length_670_cov_2.232831_g5331_i0 | PRJNA1122875 | 5542 | 670 | 2.232831 | 14.9599677 | uncultured Deinococcus sp. | 158789 | Bacteria | Bacteria | 1072 | 0 | NTclustered | gi|389546733|gb|JQ401661.1| | 158789 | g5331 | i0 | 95.529 | 106.646268656716 | 671 | 29 | 100 | 1 | 1 | 670 | 21 | 691 | Uncultured Deinococcus sp. clone CNY_01829 16S ribosomal RNA gene, partial sequence | blastn | 71453 | 1072 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | uncultured Deinococcus sp. | ||
| 2828188 | 2828188 | PRJNA1122875_P_NODE_22043_length_353_cov_1.439286_g21819_i0 | PRJNA1122875 | 22043 | 353 | 1.439286 | 5.08067958 | Deinococcus xinjiangensis | 457454 | Bacteria | Bacteria | 99.4 | 2.4899999999999998e-23 | NR | WP_353542942.1 | 457454 | g21819 | i0 | 58.7 | 1.39376770538244 | 92 | 29 | 78.2 | 1 | 278 | 3 | 56 | 138 | WP_353542942.1 hypothetical protein [Deinococcus xinjiangensis] | diamond | 492 | 99.4 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus xinjiangensis | ||
| 4104757 | 4104757 | PRJNA1122875_P_NODE_35824_length_277_cov_1.372549_g35600_i0 | PRJNA1122875 | 35824 | 277 | 1.372549 | 3.80196073 | Meiothermus taiwanensis | 172827 | Bacteria | Bacteria | 507 | 4.53e-139 | NTclustered | gi|1395894659|gb|CP021130.1| | 1339250 | g35600 | i0 | 99.639 | 14.072202166065 | 277 | 1 | 100 | 0 | 1 | 277 | 244900 | 244624 | Meiothermus taiwanensis WR-220 chromosome, complete genome | blastn | 3898 | 507 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Meiothermus | Meiothermus taiwanensis | ||
| 7930726 | 7930726 | PRJNA1122875_P_NODE_45547_length_249_cov_0.875000_g45323_i0 | PRJNA1122875 | 45547 | 249 | 0.875 | 2.17875 | Deinococcus sp. NW-56 | 2080419 | Bacteria | Bacteria | 460 | 3.16e-125 | NTclustered | gi|1339790003|gb|CP026516.1| | 2080419 | g45323 | i0 | 100 | 164.385542168675 | 249 | 0 | 100 | 0 | 1 | 249 | 543562 | 543314 | Deinococcus sp. NW-56 chromosome, complete genome | blastn | 40932 | 460 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. NW-56 | ||
| 16331222 | 16331222 | PRJNA1122875_P_NODE_45193_length_249_cov_0.875000_g44969_i0 | PRJNA1122875 | 45193 | 249 | 0.875 | 2.17875 | Bacteria | 2 | Bacteria | Bacteria | 72 | 1.46e-14 | NR | WP_290644586.1 | 1955248 | g44969 | i0 | 60.4 | 3.68674698795181 | 53 | 21 | 63.9 | 0 | 248 | 90 | 13 | 65 | WP_290644586.1 cold-shock protein [Kosmotoga sp.] | diamond | 918 | 72 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Kosmotogales | Kosmotogaceae | Kosmotoga | Kosmotoga sp. | ||
| 16331266 | 16331266 | PRJNA1122875_P_NODE_51793_length_243_cov_0.905882_g51569_i0 | PRJNA1122875 | 51793 | 243 | 0.905882 | 2.20129326 | FCB group | 1783270 | Bacteria | Bacteria | 100 | 1.41e-23 | NR | MDQ3458296.1 | 1913990 | g51569 | i0 | 55.6 | 3.97530864197531 | 81 | 36 | 100 | 0 | 243 | 1 | 129 | 209 | MDQ3458296.1 tryptophan-rich sensory protein [Deinococcota bacterium] | diamond | 966 | 101 | 0.99009900990099 | Bacteria | Thermotogati | Deinococcota | Deinococcota bacterium | ||||||
| 20155179 | 20155179 | PRJNA1122875_P_NODE_46036_length_248_cov_1.451429_g45812_i0 | PRJNA1122875 | 46036 | 248 | 1.451429 | 3.59954392 | Deinococcus | 1298 | Bacteria | Bacteria | 71.3 | 6.19e-8 | NTclustered | gi|324314064|gb|CP002536.1| | 693977 | g45812 | i0 | 87.097 | 1.47177419354839 | 62 | 8 | 25 | 0 | 139 | 200 | 1213442 | 1213381 | Deinococcus proteolyticus MRP, complete genome | blastn | 365 | 71.3 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus proteolyticus | ||
| 20679044 | 20679044 | PRJNA1122875_P_NODE_2817_length_867_cov_1.797229_g2649_i0 | PRJNA1122875 | 2817 | 867 | 1.797229 | 15.58197543 | Deinococcus actinosclerus | 1768108 | Bacteria | Bacteria | 1351 | 0 | NTclustered | gi|972944657|gb|CP013910.1| | 1768108 | g2649 | i0 | 94.828 | 217.462514417532 | 870 | 38 | 100 | 6 | 1 | 867 | 3086463 | 3085598 | Deinococcus actinosclerus strain BM2 chromosome, complete genome | blastn | 188540 | 1351 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus actinosclerus | ||
| 24503686 | 24503686 | PRJNA1122875_P_NODE_42500_length_252_cov_3.005587_g42276_i0 | PRJNA1122875 | 42500 | 252 | 3.005587 | 7.57407924 | Deinococcus sp. NW-56 | 2080419 | Bacteria | Bacteria | 466 | 6.89e-127 | NTclustered | gi|1339790003|gb|CP026516.1| | 2080419 | g42276 | i0 | 100 | 213.551587301587 | 252 | 0 | 100 | 0 | 1 | 252 | 544624 | 544875 | Deinococcus sp. NW-56 chromosome, complete genome | blastn | 53815 | 466 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. NW-56 | ||
| 27027689 | 27027689 | PRJNA1122875_P_NODE_40682_length_259_cov_2.693548_g40458_i0 | PRJNA1122875 | 40682 | 259 | 2.693548 | 6.97628932 | Bacteria | 2 | Bacteria | Bacteria | 43.5 | 0.00551 | NR | MEX2542640.1 | 2026798 | g40458 | i0 | 45 | 1.86486486486486 | 60 | 27 | 66 | 2 | 19 | 189 | 33 | 89 | MEX2542640.1 stage V sporulation protein S [Trueperaceae bacterium] | diamond | 483 | 43.9 | 0.990888382687927 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Trueperaceae bacterium | |||
| 27070087 | 27070087 | PRJNA1122875_P_NODE_25222_length_330_cov_2.097276_g24998_i0 | PRJNA1122875 | 25222 | 330 | 2.097276 | 6.9210108 | Trueperaceae bacterium | 2026798 | Bacteria | Bacteria | 70.5 | 1.2e-12 | NR | MDZ7705414.1 | 2026798 | g24998 | i0 | 46.4 | 0.881818181818182 | 97 | 51 | 88.2 | 1 | 296 | 6 | 54 | 149 | MDZ7705414.1 universal stress protein [Trueperaceae bacterium] | diamond | 291 | 70.5 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Trueperaceae bacterium | |||
| 28480569 | 28480569 | PRJNA1122875_P_NODE_35966_length_276_cov_2.251232_g35742_i0 | PRJNA1122875 | 35966 | 276 | 2.251232 | 6.21340032 | Bacteria | 2 | Bacteria | Bacteria | 112 | 1.64e-26 | NR | WP_274967493.1 | 177758 | g35742 | i0 | 57.8 | 5.78260869565217 | 90 | 38 | 97.8 | 0 | 272 | 3 | 315 | 404 | WP_274967493.1 dipeptidase [Pseudothermotoga lettingae] | diamond | 1596 | 113 | 0.991150442477876 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Thermotogaceae | Pseudothermotoga | Pseudothermotoga lettingae | ||
| 28606767 | 28606767 | PRJNA1122875_P_NODE_12227_length_476_cov_1.605459_g12004_i0 | PRJNA1122875 | 12227 | 476 | 1.605459 | 7.64198484 | root | 1 | Root_unresolved | Root_unresolved | 98.6 | 3.2899999999999996e-23 | NR | HOJ87808.1 | 2033661 | g12004 | i0 | 53.7 | 1.52521008403361 | 82 | 36 | 50.4 | 1 | 174 | 413 | 42 | 123 | HOJ87808.1 glycine cleavage system protein GcvH [Pseudothermotoga sp.] | diamond | 726 | 98.6 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Thermotogaceae | Pseudothermotoga | Pseudothermotoga sp. | ||
| 28954402 | 28954402 | PRJNA1122875_P_NODE_38528_length_267_cov_1.747423_g38304_i0 | PRJNA1122875 | 38528 | 267 | 1.747423 | 4.66561941 | Bacteria | 2 | Bacteria | Bacteria | 45.4 | 0.00574 | NR | MCD6105328.1 | 1968895 | g38304 | i0 | 29.3 | 4.37078651685393 | 99 | 59 | 98.9 | 2 | 4 | 267 | 519 | 617 | MCD6105328.1 sodium-translocating pyrophosphatase [Thermosipho sp. (in: thermotogales)] | diamond | 1167 | 45.4 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Fervidobacteriaceae | Thermosipho | Thermosipho sp. (in: thermotogales) | ||
| 29312257 | 29312257 | PRJNA1122875_P_NODE_33549_length_284_cov_2.601896_g33325_i0 | PRJNA1122875 | 33549 | 284 | 2.601896 | 7.38938464 | Thermus brockianus | 56956 | Bacteria | Bacteria | 66.2 | 3.31e-10 | NR | WP_071676922.1 | 56956 | g33325 | i0 | 39.1 | 0.971830985915493 | 92 | 32 | 97.2 | 1 | 5 | 280 | 667 | 734 | WP_071676922.1 penicillin acylase family protein [Thermus brockianus] | diamond | 276 | 66.2 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus brockianus | ||
| 29585291 | 29585291 | PRJNA1122875_P_NODE_20510_length_368_cov_1.044068_g20286_i0 | PRJNA1122875 | 20510 | 368 | 1.044068 | 3.84217024 | Bacteria | 2 | Bacteria | Bacteria | 253 | 3.91e-77 | NR | 1TAQ_A | 271 | g20286 | i0 | 100 | 3.97826086956522 | 122 | 0 | 99.5 | 0 | 3 | 368 | 76 | 197 | 1TAQ_A Chain A, TAQ DNA POLYMERASE [Thermus aquaticus] | diamond | 1464 | 253 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus aquaticus | ||
| 29722411 | 29722411 | PRJNA1122875_P_NODE_47050_length_247_cov_1.729885_g46826_i0 | PRJNA1122875 | 47050 | 247 | 1.729885 | 4.27281595 | Meiothermus sp. | 1955249 | Bacteria | Bacteria | 43.9 | 0.0148 | NR | WP_337869854.1 | 1955249 | g46826 | i0 | 29.6 | 0.862348178137652 | 71 | 50 | 86.2 | 0 | 17 | 229 | 162 | 232 | WP_337869854.1 baseplate J/gp47 family protein [Meiothermus sp.] | diamond | 213 | 43.9 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Meiothermus | Meiothermus sp. | ||
| 29849091 | 29849091 | PRJNA1122875_P_NODE_36091_length_276_cov_1.369458_g35867_i0 | PRJNA1122875 | 36091 | 276 | 1.369458 | 3.77970408 | Mesotoga sp. | 2053577 | Bacteria | Bacteria | 42.4 | 0.00809 | NR | HRR45445.1 | 2053577 | g35867 | i0 | 34 | 0.576086956521739 | 53 | 35 | 57.6 | 0 | 250 | 92 | 5 | 57 | HRR45445.1 hypothetical protein [Mesotoga sp.] | diamond | 159 | 42.4 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Kosmotogales | Kosmotogaceae | Mesotoga | Mesotoga sp. | ||
| 31681829 | 31681829 | PRJNA1122875_P_NODE_50617_length_244_cov_0.900585_g50393_i0 | PRJNA1122875 | 50617 | 244 | 0.900585 | 2.1974274 | Synergistaceae bacterium | 2053624 | Bacteria | Bacteria | 54.3 | 1.76e-6 | NR | MBQ7577767.1 | 2053624 | g50393 | i0 | 43.8 | 2.93852459016393 | 48 | 27 | 59 | 0 | 214 | 71 | 111 | 158 | MBQ7577767.1 sel1 repeat family protein [Synergistaceae bacterium] | diamond | 717 | 54.3 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Synergistaceae | Synergistaceae bacterium | |||
| 32315131 | 32315131 | PRJNA1122875_P_NODE_44319_length_250_cov_0.870056_g44095_i0 | PRJNA1122875 | 44319 | 250 | 0.870056 | 2.17514 | Deinococcus malanensis | 1706855 | Bacteria | Bacteria | 75.9 | 8.66e-14 | NR | WP_189009313.1 | 1706855 | g44095 | i0 | 47 | 7.932 | 83 | 39 | 99.6 | 1 | 250 | 2 | 349 | 426 | WP_189009313.1 threonine ammonia-lyase, biosynthetic [Deinococcus malanensis] | diamond | 1983 | 75.9 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus malanensis | ||
| 32399018 | 32399018 | PRJNA1122875_P_NODE_44559_length_250_cov_0.870056_g44335_i0 | PRJNA1122875 | 44559 | 250 | 0.870056 | 2.17514 | FCB group | 1783270 | Bacteria | Bacteria | 125 | 1.2699999999999998e-31 | NR | WP_188961577.1 | 393059 | g44335 | i0 | 69.5 | 10.812 | 82 | 24 | 98.4 | 1 | 3 | 248 | 123 | 203 | WP_188961577.1 malate synthase A [Deinococcus aquiradiocola] | diamond | 2703 | 125 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus aquiradiocola |
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);;