contig_metadata
18 rows where bioproject = "PRJNA666695" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2437766 | 2437766 | PRJNA666695_S_NODE_136342_length_187_cov_3.116438_g135248_i0 | PRJNA666695 | 136342 | 187 | 3.116438 | 5.82773906 | Deinococcus | 1298 | Bacteria | Bacteria | 346 | 6.56e-91 | NTclustered | gi|2113031129|gb|OK500351.1| | 47478 | g135248 | i0 | 100 | 103.823529411765 | 187 | 0 | 100 | 0 | 1 | 187 | 214 | 28 | Deinococcus sp. strain R11 16S ribosomal RNA gene, partial sequence | blastn | 19415 | 346 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. | ||
| 3714612 | 3714612 | PRJNA666695_S_NODE_30203_length_355_cov_12.222930_g29109_i0 | PRJNA666695 | 30203 | 355 | 12.22293 | 43.3914015 | Bacteria | 2 | Bacteria | Bacteria | 58.4 | 7.22e-4 | NTclustered | gi|1751871007|dbj|AP021849.1| | 57498 | g29109 | i0 | 87.755 | 0.611267605633803 | 49 | 6 | 14 | 0 | 272 | 320 | 1264762 | 1264714 | Deinococcus grandis ATCC 43672 DNA, complete genome | blastn | 217 | 58.4 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus grandis | ||
| 7011899 | 7011899 | PRJNA666695_S_NODE_82646_length_239_cov_3.484848_g81552_i0 | PRJNA666695 | 82646 | 239 | 3.484848 | 8.32878672 | Deinococcales bacterium | 2478479 | Bacteria | Bacteria | 118 | 1.2699999999999998e-32 | NR | MEZ4606634.1 | 2478479 | g81552 | i0 | 74 | 1.93305439330544 | 77 | 20 | 96.7 | 0 | 1 | 231 | 15 | 91 | MEZ4606634.1 hypothetical protein [Deinococcales bacterium] | diamond | 462 | 118 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcales bacterium | ||||
| 10091331 | 10091331 | PRJNA666695_S_NODE_175208_length_161_cov_3.066667_g174114_i0 | PRJNA666695 | 175208 | 161 | 3.066667 | 4.93733387 | Deinococcus | 1298 | Bacteria | Bacteria | 237 | 3.44e-58 | NTclustered | gi|821341785|gb|CP011389.1| | 1309411 | g174114 | i0 | 93.21 | 281.111801242236 | 162 | 10 | 100 | 1 | 1 | 161 | 1637763 | 1637924 | 'Deinococcus soli' Cha et al. 2014 strain N5, complete genome | blastn | 45259 | 237 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus soli (ex Cha et al. 2016) | ||
| 10091707 | 10091707 | PRJNA666695_S_NODE_54128_length_284_cov_4.934156_g53034_i0 | PRJNA666695 | 54128 | 284 | 4.934156 | 14.01300304 | Thermosipho | 2420 | Bacteria | Bacteria | 52.8 | 0.026 | NTclustered | gi|1042792521|gb|CP007121.1| | 1437364 | g53034 | i0 | 96.875 | 0.225352112676056 | 32 | 0 | 11 | 1 | 22 | 53 | 314545 | 314575 | Thermosipho sp. 1070 chromosome, complete genome | blastn | 64 | 52.8 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Fervidobacteriaceae | Thermosipho | Thermosipho sp. 1070 | ||
| 13916803 | 13916803 | PRJNA666695_S_NODE_191551_length_152_cov_2.369369_g190457_i0 | PRJNA666695 | 191551 | 152 | 2.369369 | 3.60144088 | Deinococcus | 1298 | Bacteria | Bacteria | 281 | 1.46e-71 | NTclustered | gi|821341785|gb|CP011389.1| | 1309411 | g190457 | i0 | 100 | 185.039473684211 | 152 | 0 | 100 | 0 | 1 | 152 | 1636181 | 1636332 | 'Deinococcus soli' Cha et al. 2014 strain N5, complete genome | blastn | 28126 | 281 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus soli (ex Cha et al. 2016) | ||
| 17740487 | 17740487 | PRJNA666695_S_NODE_144794_length_181_cov_2.292857_g143700_i0 | PRJNA666695 | 144794 | 181 | 2.292857 | 4.15007117 | Deinococcus | 1298 | Bacteria | Bacteria | 335 | 1.36e-87 | NTclustered | gi|821341785|gb|CP011389.1| | 1309411 | g143700 | i0 | 100 | 205 | 181 | 0 | 100 | 0 | 1 | 181 | 1636755 | 1636935 | 'Deinococcus soli' Cha et al. 2014 strain N5, complete genome | blastn | 37105 | 335 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus soli (ex Cha et al. 2016) | ||
| 21034764 | 21034764 | PRJNA666695_S_NODE_36597_length_331_cov_2.062069_g35503_i0 | PRJNA666695 | 36597 | 331 | 2.062069 | 6.82544839 | Deinococcus soli (ex Cha et al. 2016) | 1309411 | Bacteria | Bacteria | 606 | 5.299999999999998e-169 | NTclustered | gi|821341785|gb|CP011389.1| | 1309411 | g35503 | i0 | 99.698 | 209.075528700906 | 331 | 1 | 100 | 0 | 1 | 331 | 1638529 | 1638859 | 'Deinococcus soli' Cha et al. 2014 strain N5, complete genome | blastn | 69204 | 606 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus soli (ex Cha et al. 2016) | ||
| 26745133 | 26745133 | PRJNA666695_S_NODE_13821_length_479_cov_2.573059_g12735_i0 | PRJNA666695 | 13821 | 479 | 2.573059 | 12.32495261 | Bacteria | 2 | Bacteria | Bacteria | 57.8 | 2e-6 | NR | WP_051304049.1 | 52023 | g12735 | i0 | 42.6 | 1.13987473903967 | 61 | 35 | 38.2 | 0 | 5 | 187 | 231 | 291 | WP_051304049.1 ion transporter [Calidithermus chliarophilus] | diamond | 546 | 57.8 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Calidithermus | Calidithermus chliarophilus | ||
| 27682072 | 27682072 | PRJNA666695_S_NODE_101624_length_218_cov_1.819209_g100530_i0 | PRJNA666695 | 101624 | 218 | 1.819209 | 3.96587562 | Truepera sp. | 2478917 | Bacteria | Bacteria | 71.2 | 1.85e-12 | NR | MBS3933500.1 | 2478917 | g100530 | i0 | 45.8 | 1.96788990825688 | 72 | 37 | 96.3 | 1 | 8 | 217 | 106 | 177 | MBS3933500.1 Gfo/Idh/MocA family oxidoreductase [Truepera sp.] | diamond | 429 | 71.2 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | Truepera sp. | ||
| 27757249 | 27757249 | PRJNA666695_S_NODE_167764_length_166_cov_1.472000_g166670_i0 | PRJNA666695 | 167764 | 166 | 1.472 | 2.44352 | Candidatus Equadaptatus | 3082824 | Bacteria | Bacteria | 46.6 | 5.44e-4 | NR | MDO4953064.1 | 2053624 | g166670 | i0 | 55 | 1.44578313253012 | 40 | 18 | 72.3 | 0 | 148 | 29 | 158 | 197 | MDO4953064.1 tetratricopeptide repeat protein [Synergistaceae bacterium] | diamond | 240 | 46.6 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Synergistaceae | Synergistaceae bacterium | |||
| 28483228 | 28483228 | PRJNA666695_S_NODE_13046_length_490_cov_7.198218_g11964_i0 | PRJNA666695 | 13046 | 490 | 7.198218 | 35.2712682 | FCB group | 1783270 | Bacteria | Bacteria | 125 | 1.94e-31 | NR | KUK94576.1 | 1635293 | g11964 | i0 | 44.4 | 7.9469387755102 | 144 | 76 | 88.2 | 2 | 1 | 432 | 169 | 308 | KUK94576.1 MAG: Carbamate kinase [Thermotogales bacterium 46_20] | diamond | 3894 | 126 | 0.992063492063492 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Thermotogales bacterium 46_20 | ||||
| 29493586 | 29493586 | PRJNA666695_S_NODE_55590_length_281_cov_6.633333_g54496_i0 | PRJNA666695 | 55590 | 281 | 6.633333 | 18.63966573 | FCB group | 1783270 | Bacteria | Bacteria | 69.7 | 1.91e-11 | NR | WP_012896544.1 | 93929 | g54496 | i0 | 34.4 | 3.72597864768683 | 93 | 60 | 99.3 | 1 | 1 | 279 | 542 | 633 | WP_012896544.1 beta-galactosidase [Thermotoga petrophila] | diamond | 1047 | 69.7 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Thermotogaceae | Thermotoga | Thermotoga petrophila | ||
| 29872540 | 29872540 | PRJNA666695_S_NODE_63371_length_267_cov_3.256637_g62277_i0 | PRJNA666695 | 63371 | 267 | 3.256637 | 8.69522079 | Bacteria | 2 | Bacteria | Bacteria | 126 | 9.8e-32 | NR | WP_013178765.1 | 332249 | g62277 | i0 | 68.2 | 9.8876404494382 | 88 | 17 | 98.9 | 1 | 2 | 265 | 75 | 151 | WP_013178765.1 fucose isomerase [Truepera radiovictrix] | diamond | 2640 | 127 | 0.992125984251969 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | Truepera radiovictrix | ||
| 30271379 | 30271379 | PRJNA666695_S_NODE_27052_length_370_cov_4.960486_g25959_i0 | PRJNA666695 | 27052 | 370 | 4.960486 | 18.3537982 | Meiothermus sp. | 1955249 | Bacteria | Bacteria | 58.5 | 1.29e-7 | NR | MER3483845.1 | 1955249 | g25959 | i0 | 33.8 | 1.2 | 74 | 49 | 60 | 0 | 369 | 148 | 101 | 174 | MER3483845.1 adenylate kinase [Meiothermus sp.] | diamond | 444 | 58.5 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Meiothermus | Meiothermus sp. | ||
| 30461103 | 30461103 | PRJNA666695_S_NODE_180653_length_158_cov_2.256410_g179559_i0 | PRJNA666695 | 180653 | 158 | 2.25641 | 3.5651278 | Deinococcus navajonensis | 309884 | Bacteria | Bacteria | 65.9 | 8.15e-11 | NR | WP_380036170.1 | 309884 | g179559 | i0 | 60.9 | 0.873417721518987 | 46 | 18 | 87.3 | 0 | 1 | 138 | 697 | 742 | WP_380036170.1 bifunctional cytochrome P450/NADPH--P450 reductase [Deinococcus navajonensis] | diamond | 138 | 65.9 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus navajonensis | ||
| 30630586 | 30630586 | PRJNA666695_S_NODE_29293_length_359_cov_12.345912_g28200_i0 | PRJNA666695 | 29293 | 359 | 12.345912 | 44.32182408 | Deinococcus | 1298 | Bacteria | Bacteria | 63.2 | 6.53e-9 | NR | WP_343756891.1 | 392408 | g28200 | i0 | 46.4 | 1.35376044568245 | 84 | 40 | 66 | 2 | 349 | 113 | 177 | 260 | WP_343756891.1 complex I NDUFA9 subunit family protein [Deinococcus depolymerans] | diamond | 486 | 63.2 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus depolymerans | ||
| 31567101 | 31567101 | PRJNA666695_S_NODE_134696_length_189_cov_1.033784_g133602_i0 | PRJNA666695 | 134696 | 189 | 1.033784 | 1.95385176 | Thermosipho sp. (in: thermotogales) | 1968895 | Bacteria | Bacteria | 43.1 | 0.0135 | NR | MBO8160797.1 | 1968895 | g133602 | i0 | 40.7 | 1.71428571428571 | 54 | 30 | 85.7 | 1 | 189 | 28 | 290 | 341 | MBO8160797.1 low-specificity L-threonine aldolase [Thermosipho sp. (in: thermotogales)] | diamond | 324 | 43.1 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Fervidobacteriaceae | Thermosipho | Thermosipho sp. (in: thermotogales) |
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);;