contig_metadata
21 rows where bioproject = "PRJNA770826" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 746943 | 746943 | PRJNA770826_P_NODE_43681_length_162_cov_0.920354_g43510_i0 | PRJNA770826 | 43681 | 162 | 0.920354 | 1.49097348 | Trueperaceae bacterium | 2026798 | Bacteria | Bacteria | 239 | 9.64e-59 | NTclustered | gi|2621706202|emb|OY764543.1| | 2026798 | g43510 | i0 | 93.21 | 407.493827160494 | 162 | 11 | 100 | 0 | 1 | 162 | 2559566 | 2559405 | MAG: Trueperaceae bacterium isolate 617606ba-ac04-44ed-b980-3de5d93b502e genome assembly, chromosome: 1 | blastn | 66014 | 239 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Trueperaceae bacterium | |||
| 2482120 | 2482120 | PRJNA770826_P_NODE_30742_length_167_cov_0.881356_g30571_i0 | PRJNA770826 | 30742 | 167 | 0.881356 | 1.47186452 | root | 1 | Root_unresolved | Root_unresolved | 97.1 | 3.08e-23 | NR | MDB5045407.1 | 47478 | g30571 | i0 | 76.4 | 24.6467065868263 | 55 | 13 | 98.8 | 0 | 2 | 166 | 164 | 218 | MDB5045407.1 6-phosphogluconate dehydrogenase [Deinococcus sp.] | diamond | 4116 | 97.1 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. | ||
| 3298129 | 3298129 | PRJNA770826_P_NODE_39483_length_163_cov_0.912281_g39312_i0 | PRJNA770826 | 39483 | 163 | 0.912281 | 1.48701803 | Trueperaceae bacterium | 2026798 | Bacteria | Bacteria | 196 | 5.93e-46 | NTclustered | gi|2108366028|gb|CP070651.1| | 2026798 | g39312 | i0 | 88.344 | 264.20245398773 | 163 | 19 | 100 | 0 | 1 | 163 | 9390 | 9552 | MAG: Trueperaceae bacterium isolate bin86 chromosome | blastn | 43065 | 196 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Trueperaceae bacterium | |||
| 4575115 | 4575115 | PRJNA770826_P_NODE_13244_length_221_cov_1.279070_g13073_i0 | PRJNA770826 | 13244 | 221 | 1.27907 | 2.8267447 | Trueperaceae bacterium | 2026798 | Bacteria | Bacteria | 359 | 1.03e-94 | NTclustered | gi|2621701816|emb|OY759346.1| | 2026798 | g13073 | i0 | 95.928 | 303.638009049774 | 221 | 9 | 100 | 0 | 1 | 221 | 3601170 | 3600950 | MAG: Trueperaceae bacterium isolate dd143a13-9bf8-4812-ba0e-a3cf349d91ff genome assembly, chromosome: 1 | blastn | 67104 | 359 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Trueperaceae bacterium | |||
| 7125617 | 7125617 | PRJNA770826_P_NODE_25246_length_168_cov_2.184874_g25075_i0 | PRJNA770826 | 25246 | 168 | 2.184874 | 3.67058832 | Deinococcus sp. NW-56 | 2080419 | Bacteria | Bacteria | 239 | 1.01e-58 | NTclustered | gi|1339790003|gb|CP026516.1| | 2080419 | g25075 | i0 | 92.262 | 49.4821428571429 | 168 | 13 | 100 | 0 | 1 | 168 | 545162 | 545329 | Deinococcus sp. NW-56 chromosome, complete genome | blastn | 8313 | 239 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. NW-56 | ||
| 8859879 | 8859879 | PRJNA770826_P_NODE_20547_length_178_cov_7.170543_g20376_i0 | PRJNA770826 | 20547 | 178 | 7.170543 | 12.76356654 | Thermotoga | 2335 | Bacteria | Bacteria | 56.5 | 0.001 | NTclustered | gi|752579342|gb|CP007633.1| | 126738 | g20376 | i0 | 100 | 0.337078651685393 | 30 | 0 | 17 | 0 | 39 | 68 | 273020 | 273049 | Thermotoga sp. RQ7, complete genome | blastn | 60 | 56.5 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Thermotogaceae | Thermotoga | Thermotoga sp. RQ7 | ||
| 10135321 | 10135321 | PRJNA770826_P_NODE_9548_length_261_cov_2.339623_g9377_i0 | PRJNA770826 | 9548 | 261 | 2.339623 | 6.10641603 | Deinococcus | 1298 | Bacteria | Bacteria | 344 | 3.51e-90 | NTclustered | gi|1339790003|gb|CP026516.1| | 2080419 | g9377 | i0 | 90.421 | 188.919540229885 | 261 | 25 | 100 | 0 | 1 | 261 | 544552 | 544292 | Deinococcus sp. NW-56 chromosome, complete genome | blastn | 49308 | 346 | 0.994219653179191 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. NW-56 | ||
| 13500653 | 13500653 | PRJNA770826_P_NODE_291_length_1365_cov_2.415653_g235_i0 | PRJNA770826 | 291 | 1365 | 2.415653 | 32.97366345 | Deinococcus grandis | 57498 | Bacteria | Bacteria | 1882 | 0 | NTclustered | gi|1751871007|dbj|AP021849.1| | 57498 | g235 | i0 | 91.63 | 246.16043956044 | 1374 | 95 | 100 | 18 | 1 | 1365 | 423374 | 424736 | Deinococcus grandis ATCC 43672 DNA, complete genome | blastn | 336009 | 1882 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus grandis | ||
| 18598613 | 18598613 | PRJNA770826_P_NODE_19255_length_184_cov_2.622222_g19084_i0 | PRJNA770826 | 19255 | 184 | 2.622222 | 4.82488848 | Deinococcus sp. NW-56 | 2080419 | Bacteria | Bacteria | 233 | 5.22e-57 | NTclustered | gi|1339790003|gb|CP026516.1| | 2080419 | g19084 | i0 | 89.785 | 144.826086956522 | 186 | 13 | 100 | 6 | 1 | 184 | 543317 | 543136 | Deinococcus sp. NW-56 chromosome, complete genome | blastn | 26648 | 233 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. NW-56 | ||
| 22884422 | 22884422 | PRJNA770826_P_NODE_2638_length_535_cov_1.965021_g2469_i0 | PRJNA770826 | 2638 | 535 | 1.965021 | 10.51286235 | Deinococcus | 1298 | Bacteria | Bacteria | 686 | 0 | NTclustered | gi|1220362168|gb|CP021081.1| | 317577 | g2469 | i0 | 91.27 | 198.566355140187 | 504 | 42 | 99 | 2 | 1 | 502 | 2342490 | 2341987 | Deinococcus ficus strain CC-FR2-10, complete genome | blastn | 106233 | 691 | 0.992764109985528 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus ficus | ||
| 25433355 | 25433355 | PRJNA770826_P_NODE_10240_length_252_cov_1.280788_g10069_i0 | PRJNA770826 | 10240 | 252 | 1.280788 | 3.22758576 | Truepera | 332248 | Bacteria | Bacteria | 411 | 3.269999999999999e-110 | NTclustered | gi|470486385|ref|NR_076754.1| | 332249 | g10069 | i0 | 96.386 | 184.761904761905 | 249 | 9 | 99 | 0 | 1 | 249 | 1855 | 2103 | Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence | blastn | 46560 | 411 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | Truepera radiovictrix | ||
| 26936217 | 26936217 | PRJNA770826_P_NODE_6762_length_319_cov_1.759259_g6591_i0 | PRJNA770826 | 6762 | 319 | 1.759259 | 5.61203621 | Bacteria | 2 | Bacteria | Bacteria | 108 | 6.09e-25 | NR | WP_110528403.1 | 370471 | g6591 | i0 | 57.9 | 15.0470219435737 | 107 | 42 | 99.7 | 3 | 2 | 319 | 290 | 394 | WP_110528403.1 MULTISPECIES: NAD-dependent malic enzyme [unclassified Meiothermus] | diamond | 4800 | 108 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Meiothermus | |||
| 27179508 | 27179508 | PRJNA770826_P_NODE_35022_length_165_cov_0.896552_g34851_i0 | PRJNA770826 | 35022 | 165 | 0.896552 | 1.4793108 | Kosmotoga sp. | 1955248 | Bacteria | Bacteria | 69.7 | 2.25e-13 | NR | TYB88804.1 | 1955248 | g34851 | i0 | 54.5 | 3 | 55 | 25 | 100 | 0 | 165 | 1 | 73 | 127 | TYB88804.1 MAG: MaoC family dehydratase [Kosmotoga sp.] | diamond | 495 | 69.7 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Kosmotogales | Kosmotogaceae | Kosmotoga | Kosmotoga sp. | ||
| 27811604 | 27811604 | PRJNA770826_P_NODE_15644_length_204_cov_1.677419_g15473_i0 | PRJNA770826 | 15644 | 204 | 1.677419 | 3.42193476 | Deinococcus hopiensis | 309885 | Bacteria | Bacteria | 67.4 | 4.36e-11 | NR | WP_170928889.1 | 309885 | g15473 | i0 | 64.4 | 1.91176470588235 | 45 | 16 | 66.2 | 0 | 69 | 203 | 43 | 87 | WP_170928889.1 glycoside hydrolase family 30 protein [Deinococcus hopiensis] | diamond | 390 | 67.4 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus hopiensis | ||
| 28136864 | 28136864 | PRJNA770826_P_NODE_7565_length_298_cov_1.610442_g7394_i0 | PRJNA770826 | 7565 | 298 | 1.610442 | 4.79911716 | Bacteria | 2 | Bacteria | Bacteria | 97.8 | 1.3e-22 | NR | WP_033191857.1 | 2422 | g7394 | i0 | 57.6 | 6.66442953020134 | 92 | 38 | 92.6 | 1 | 1 | 276 | 66 | 156 | WP_033191857.1 MULTISPECIES: 50S ribosomal protein L1 [Fervidobacterium] | diamond | 1986 | 98.6 | 0.991886409736308 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Fervidobacteriaceae | Fervidobacterium | |||
| 28158946 | 28158946 | PRJNA770826_P_NODE_23525_length_169_cov_0.866667_g23354_i0 | PRJNA770826 | 23525 | 169 | 0.866667 | 1.46466723 | Thermotogota bacterium | 2053689 | Bacteria | Bacteria | 42.4 | 0.00454 | NR | MCD6238231.1 | 2053689 | g23354 | i0 | 42.2 | 1.36686390532544 | 45 | 23 | 74.6 | 1 | 167 | 42 | 26 | 70 | MCD6238231.1 Asp-tRNA(Asn)/Glu-tRNA(Gln) amidotransferase subunit GatC [Thermotogota bacterium] | diamond | 231 | 42.4 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogota bacterium | ||||||
| 28695658 | 28695658 | PRJNA770826_P_NODE_38887_length_163_cov_1.368421_g38716_i0 | PRJNA770826 | 38887 | 163 | 1.368421 | 2.23052623 | Synergistaceae bacterium | 2053624 | Bacteria | Bacteria | 73.6 | 3.97e-14 | NR | HOO64696.1 | 2053624 | g38716 | i0 | 62.3 | 0.975460122699387 | 53 | 20 | 97.5 | 0 | 3 | 161 | 86 | 138 | HOO64696.1 TIGR00266 family protein [Synergistaceae bacterium] | diamond | 159 | 73.6 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Synergistaceae | Synergistaceae bacterium | |||
| 28727074 | 28727074 | PRJNA770826_P_NODE_4587_length_402_cov_1.600567_g4416_i0 | PRJNA770826 | 4587 | 402 | 1.600567 | 6.43427934 | Thermus arciformis | 482827 | Bacteria | Bacteria | 169 | 8.6199999999999985e-47 | NR | WP_093005720.1 | 482827 | g4416 | i0 | 59.7 | 17.8358208955224 | 134 | 54 | 100 | 0 | 402 | 1 | 11 | 144 | WP_093005720.1 NAD-dependent malic enzyme [Thermus arciformis] | diamond | 7170 | 169 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus arciformis | ||
| 30306511 | 30306511 | PRJNA770826_P_NODE_19412_length_184_cov_1.155556_g19241_i0 | PRJNA770826 | 19412 | 184 | 1.155556 | 2.12622304 | Synergistaceae bacterium | 2053624 | Bacteria | Bacteria | 81.6 | 1.39e-17 | NR | MBQ7665751.1 | 2053624 | g19241 | i0 | 61 | 2.90217391304348 | 59 | 23 | 96.2 | 0 | 6 | 182 | 48 | 106 | MBQ7665751.1 hypoxanthine phosphoribosyltransferase [Synergistaceae bacterium] | diamond | 534 | 81.6 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Synergistaceae | Synergistaceae bacterium | |||
| 31443719 | 31443719 | PRJNA770826_P_NODE_6976_length_314_cov_1.064151_g6805_i0 | PRJNA770826 | 6976 | 314 | 1.064151 | 3.34143414 | Petrotoga sp. 9PWA.NaAc.5.4 | 1434328 | Bacteria | Bacteria | 104 | 9.85e-26 | NR | WP_121958620.1 | 1434328 | g6805 | i0 | 56.2 | 3.39171974522293 | 89 | 38 | 84.1 | 1 | 50 | 313 | 10 | 98 | WP_121958620.1 macro domain-containing protein [Petrotoga sp. 9PWA.NaAc.5.4] | diamond | 1065 | 104 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Petrotogales | Petrotogaceae | Petrotoga | Petrotoga sp. 9PWA.NaAc.5.4 | ||
| 32076433 | 32076433 | PRJNA770826_P_NODE_44098_length_154_cov_2.485714_g43927_i0 | PRJNA770826 | 44098 | 154 | 2.485714 | 3.82799956 | Deinococcus cellulosilyticus | 401558 | Bacteria | Bacteria | 97.4 | 4.76e-22 | NR | WP_146884523.1 | 401558 | g43927 | i0 | 72.5 | 1.98701298701299 | 51 | 14 | 99.4 | 0 | 1 | 153 | 250 | 300 | WP_146884523.1 glycoside hydrolase family 30 protein [Deinococcus cellulosilyticus] | diamond | 306 | 97.4 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus cellulosilyticus |
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);;