contig_metadata
28 rows where bioproject = "PRJNA758770" and tax_phylum = "Thermotogota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 740609 | 740609 | PRJNA758770_S_NODE_24381_length_252_cov_0.871508_g24255_i0 | PRJNA758770 | 24381 | 252 | 0.871508 | 2.19620016 | Defluviitoga tunisiensis | 1006576 | Bacteria | Bacteria | 460 | 3.2e-125 | NTclustered | gi|762219508|emb|LN824141.1| | 1006576 | g24255 | i0 | 99.603 | 1 | 252 | 1 | 100 | 0 | 1 | 252 | 1794097 | 1794348 | Defluviitoga tunisiensis genome assembly DTL3, chromosome : I | blastn | 252 | 460 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Petrotogales | Petrotogaceae | Defluviitoga | Defluviitoga tunisiensis | ||
| 1204669 | 1204669 | PRJNA758770_S_NODE_31581_length_243_cov_0.917647_g31455_i0 | PRJNA758770 | 31581 | 243 | 0.917647 | 2.22988221 | Bacteria | 2 | Bacteria | Bacteria | 444 | 3.09e-120 | NTclustered | gi|383108560|gb|CP003260.1| | 771875 | g31455 | i0 | 99.588 | 12.9753086419753 | 243 | 1 | 100 | 0 | 1 | 243 | 787612 | 787854 | Fervidobacterium pennivorans DSM 9078, complete genome | blastn | 3153 | 444 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Fervidobacteriaceae | Fervidobacterium | Fervidobacterium pennivorans | ||
| 2016784 | 2016784 | PRJNA758770_S_NODE_31542_length_243_cov_0.917647_g31416_i0 | PRJNA758770 | 31542 | 243 | 0.917647 | 2.22988221 | Defluviitoga tunisiensis | 1006576 | Bacteria | Bacteria | 449 | 6.65e-122 | NTclustered | gi|762219508|emb|LN824141.1| | 1006576 | g31416 | i0 | 100 | 1 | 243 | 0 | 100 | 0 | 1 | 243 | 704750 | 704992 | Defluviitoga tunisiensis genome assembly DTL3, chromosome : I | blastn | 243 | 449 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Petrotogales | Petrotogaceae | Defluviitoga | Defluviitoga tunisiensis | ||
| 3291957 | 3291957 | PRJNA758770_S_NODE_27723_length_248_cov_0.891429_g27597_i0 | PRJNA758770 | 27723 | 248 | 0.891429 | 2.21074392 | Defluviitoga tunisiensis | 1006576 | Bacteria | Bacteria | 396 | 9e-106 | NTclustered | gi|762219508|emb|LN824141.1| | 1006576 | g27597 | i0 | 96.639 | 0.959677419354839 | 238 | 8 | 96 | 0 | 2 | 239 | 739848 | 740085 | Defluviitoga tunisiensis genome assembly DTL3, chromosome : I | blastn | 238 | 396 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Petrotogales | Petrotogaceae | Defluviitoga | Defluviitoga tunisiensis | ||
| 8394004 | 8394004 | PRJNA758770_S_NODE_29467_length_246_cov_0.901734_g29341_i0 | PRJNA758770 | 29467 | 246 | 0.901734 | 2.21826564 | Defluviitoga tunisiensis | 1006576 | Bacteria | Bacteria | 351 | 1.96e-92 | NTclustered | gi|762219508|emb|LN824141.1| | 1006576 | g29341 | i0 | 92.623 | 0.991869918699187 | 244 | 18 | 99 | 0 | 1 | 244 | 1632397 | 1632154 | Defluviitoga tunisiensis genome assembly DTL3, chromosome : I | blastn | 244 | 351 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Petrotogales | Petrotogaceae | Defluviitoga | Defluviitoga tunisiensis | ||
| 9669013 | 9669013 | PRJNA758770_S_NODE_20868_length_266_cov_1.207254_g20742_i0 | PRJNA758770 | 20868 | 266 | 1.207254 | 3.21129564 | Defluviitoga tunisiensis | 1006576 | Bacteria | Bacteria | 492 | 1.2099999999999999e-134 | NTclustered | gi|762219508|emb|LN824141.1| | 1006576 | g20742 | i0 | 100 | 1 | 266 | 0 | 100 | 0 | 1 | 266 | 727226 | 726961 | Defluviitoga tunisiensis genome assembly DTL3, chromosome : I | blastn | 266 | 492 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Petrotogales | Petrotogaceae | Defluviitoga | Defluviitoga tunisiensis | ||
| 9669153 | 9669153 | PRJNA758770_S_NODE_27028_length_249_cov_0.886364_g26902_i0 | PRJNA758770 | 27028 | 249 | 0.886364 | 2.20704636 | Defluviitoga tunisiensis | 1006576 | Bacteria | Bacteria | 460 | 3.16e-125 | NTclustered | gi|762219508|emb|LN824141.1| | 1006576 | g26902 | i0 | 100 | 1 | 249 | 0 | 100 | 0 | 1 | 249 | 29751 | 29503 | Defluviitoga tunisiensis genome assembly DTL3, chromosome : I | blastn | 249 | 460 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Petrotogales | Petrotogaceae | Defluviitoga | Defluviitoga tunisiensis | ||
| 10944837 | 10944837 | PRJNA758770_S_NODE_29029_length_246_cov_0.901734_g28903_i0 | PRJNA758770 | 29029 | 246 | 0.901734 | 2.21826564 | Defluviitoga tunisiensis | 1006576 | Bacteria | Bacteria | 217 | 7.449999999999999e-52 | NTclustered | gi|762219508|emb|LN824141.1| | 1006576 | g28903 | i0 | 91.25 | 1.47967479674797 | 160 | 13 | 65 | 1 | 1 | 160 | 1881028 | 1880870 | Defluviitoga tunisiensis genome assembly DTL3, chromosome : I | blastn | 364 | 217 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Petrotogales | Petrotogaceae | Defluviitoga | Defluviitoga tunisiensis | ||
| 12220324 | 12220324 | PRJNA758770_S_NODE_26930_length_249_cov_0.886364_g26804_i0 | PRJNA758770 | 26930 | 249 | 0.886364 | 2.20704636 | Defluviitoga tunisiensis | 1006576 | Bacteria | Bacteria | 460 | 3.16e-125 | NTclustered | gi|762219508|emb|LN824141.1| | 1006576 | g26804 | i0 | 100 | 1 | 249 | 0 | 100 | 0 | 1 | 249 | 325492 | 325244 | Defluviitoga tunisiensis genome assembly DTL3, chromosome : I | blastn | 249 | 460 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Petrotogales | Petrotogaceae | Defluviitoga | Defluviitoga tunisiensis | ||
| 12220348 | 12220348 | PRJNA758770_S_NODE_27950_length_248_cov_0.891429_g27824_i0 | PRJNA758770 | 27950 | 248 | 0.891429 | 2.21074392 | Defluviitoga tunisiensis | 1006576 | Bacteria | Bacteria | 448 | 2.4499999999999996e-121 | NTclustered | gi|762219508|emb|LN824141.1| | 1006576 | g27824 | i0 | 99.197 | 1.00403225806452 | 249 | 1 | 100 | 1 | 1 | 248 | 890727 | 890975 | Defluviitoga tunisiensis genome assembly DTL3, chromosome : I | blastn | 249 | 448 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Petrotogales | Petrotogaceae | Defluviitoga | Defluviitoga tunisiensis | ||
| 13494409 | 13494409 | PRJNA758770_S_NODE_25031_length_251_cov_0.876404_g24905_i0 | PRJNA758770 | 25031 | 251 | 0.876404 | 2.19977404 | Defluviitoga tunisiensis | 1006576 | Bacteria | Bacteria | 448 | 2.48e-121 | NTclustered | gi|762219508|emb|LN824141.1| | 1006576 | g24905 | i0 | 98.805 | 1 | 251 | 3 | 100 | 0 | 1 | 251 | 208969 | 208719 | Defluviitoga tunisiensis genome assembly DTL3, chromosome : I | blastn | 251 | 448 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Petrotogales | Petrotogaceae | Defluviitoga | Defluviitoga tunisiensis | ||
| 14769550 | 14769550 | PRJNA758770_S_NODE_26692_length_249_cov_0.886364_g26566_i0 | PRJNA758770 | 26692 | 249 | 0.886364 | 2.20704636 | Defluviitoga tunisiensis | 1006576 | Bacteria | Bacteria | 318 | 2.0099999999999998e-82 | NTclustered | gi|762219508|emb|LN824141.1| | 1006576 | g26566 | i0 | 90.204 | 0.983935742971888 | 245 | 23 | 98 | 1 | 6 | 249 | 1438528 | 1438284 | Defluviitoga tunisiensis genome assembly DTL3, chromosome : I | blastn | 245 | 318 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Petrotogales | Petrotogaceae | Defluviitoga | Defluviitoga tunisiensis | ||
| 18592216 | 18592216 | PRJNA758770_S_NODE_20535_length_268_cov_1.174359_g20409_i0 | PRJNA758770 | 20535 | 268 | 1.174359 | 3.14728212 | Defluviitoga tunisiensis | 1006576 | Bacteria | Bacteria | 479 | 9.499999999999996e-131 | NTclustered | gi|762219508|emb|LN824141.1| | 1006576 | g20409 | i0 | 98.881 | 22.0037313432836 | 268 | 3 | 100 | 0 | 1 | 268 | 1223441 | 1223708 | Defluviitoga tunisiensis genome assembly DTL3, chromosome : I | blastn | 5897 | 479 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Petrotogales | Petrotogaceae | Defluviitoga | Defluviitoga tunisiensis | ||
| 18592302 | 18592302 | PRJNA758770_S_NODE_24355_length_252_cov_0.871508_g24229_i0 | PRJNA758770 | 24355 | 252 | 0.871508 | 2.19620016 | Defluviitoga tunisiensis | 1006576 | Bacteria | Bacteria | 226 | 1.2699999999999999e-54 | NTclustered | gi|762219508|emb|LN824141.1| | 1006576 | g24229 | i0 | 97.015 | 9.12698412698413 | 134 | 4 | 99 | 0 | 1 | 134 | 81482 | 81349 | Defluviitoga tunisiensis genome assembly DTL3, chromosome : I | blastn | 2300 | 226 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Petrotogales | Petrotogaceae | Defluviitoga | Defluviitoga tunisiensis | ||
| 18592351 | 18592351 | PRJNA758770_S_NODE_26395_length_249_cov_1.346591_g26269_i0 | PRJNA758770 | 26395 | 249 | 1.346591 | 3.35301159 | Defluviitoga tunisiensis | 1006576 | Bacteria | Bacteria | 438 | 1.4799999999999996e-118 | NTclustered | gi|762219508|emb|LN824141.1| | 1006576 | g26269 | i0 | 98.394 | 30 | 249 | 4 | 100 | 0 | 1 | 249 | 1230143 | 1230391 | Defluviitoga tunisiensis genome assembly DTL3, chromosome : I | blastn | 7470 | 438 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Petrotogales | Petrotogaceae | Defluviitoga | Defluviitoga tunisiensis | ||
| 19867560 | 19867560 | PRJNA758770_S_NODE_27076_length_249_cov_0.886364_g26950_i0 | PRJNA758770 | 27076 | 249 | 0.886364 | 2.20704636 | Defluviitoga tunisiensis | 1006576 | Bacteria | Bacteria | 455 | 1.47e-123 | NTclustered | gi|762219508|emb|LN824141.1| | 1006576 | g26950 | i0 | 99.598 | 1 | 249 | 1 | 100 | 0 | 1 | 249 | 185778 | 185530 | Defluviitoga tunisiensis genome assembly DTL3, chromosome : I | blastn | 249 | 455 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Petrotogales | Petrotogaceae | Defluviitoga | Defluviitoga tunisiensis | ||
| 19867629 | 19867629 | PRJNA758770_S_NODE_30056_length_245_cov_0.906977_g29930_i0 | PRJNA758770 | 30056 | 245 | 0.906977 | 2.22209365 | Defluviitoga tunisiensis | 1006576 | Bacteria | Bacteria | 448 | 2.41e-121 | NTclustered | gi|762219508|emb|LN824141.1| | 1006576 | g29930 | i0 | 99.592 | 1 | 245 | 1 | 100 | 0 | 1 | 245 | 62971 | 62727 | Defluviitoga tunisiensis genome assembly DTL3, chromosome : I | blastn | 245 | 448 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Petrotogales | Petrotogaceae | Defluviitoga | Defluviitoga tunisiensis | ||
| 21143253 | 21143253 | PRJNA758770_S_NODE_29097_length_246_cov_0.901734_g28971_i0 | PRJNA758770 | 29097 | 246 | 0.901734 | 2.21826564 | Defluviitoga tunisiensis | 1006576 | Bacteria | Bacteria | 455 | 1.4500000000000002e-123 | NTclustered | gi|762219508|emb|LN824141.1| | 1006576 | g28971 | i0 | 100 | 1 | 246 | 0 | 100 | 0 | 1 | 246 | 1354082 | 1354327 | Defluviitoga tunisiensis genome assembly DTL3, chromosome : I | blastn | 246 | 455 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Petrotogales | Petrotogaceae | Defluviitoga | Defluviitoga tunisiensis | ||
| 23693584 | 23693584 | PRJNA758770_S_NODE_25099_length_251_cov_0.876404_g24973_i0 | PRJNA758770 | 25099 | 251 | 0.876404 | 2.19977404 | Defluviitoga tunisiensis | 1006576 | Bacteria | Bacteria | 459 | 1.1499999999999996e-124 | NTclustered | gi|762219508|emb|LN824141.1| | 1006576 | g24973 | i0 | 99.602 | 1 | 251 | 1 | 100 | 0 | 1 | 251 | 1771234 | 1771484 | Defluviitoga tunisiensis genome assembly DTL3, chromosome : I | blastn | 251 | 459 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Petrotogales | Petrotogaceae | Defluviitoga | Defluviitoga tunisiensis | ||
| 23693733 | 23693733 | PRJNA758770_S_NODE_31279_length_244_cov_0.865497_g31153_i0 | PRJNA758770 | 31279 | 244 | 0.865497 | 2.11181268 | Defluviitoga tunisiensis | 1006576 | Bacteria | Bacteria | 451 | 1.86e-122 | NTclustered | gi|762219508|emb|LN824141.1| | 1006576 | g31153 | i0 | 100 | 1 | 244 | 0 | 100 | 0 | 1 | 244 | 834694 | 834937 | Defluviitoga tunisiensis genome assembly DTL3, chromosome : I | blastn | 244 | 451 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Petrotogales | Petrotogaceae | Defluviitoga | Defluviitoga tunisiensis | ||
| 27116094 | 27116094 | PRJNA758770_S_NODE_24302_length_252_cov_0.871508_g24176_i0 | PRJNA758770 | 24302 | 252 | 0.871508 | 2.19620016 | Defluviitoga sp. | 2969823 | Bacteria | Bacteria | 99.8 | 1.92e-22 | NR | HOB16703.1 | 2969823 | g24176 | i0 | 96.2 | 0.630952380952381 | 53 | 2 | 63.1 | 0 | 92 | 250 | 1 | 53 | HOB16703.1 extracellular solute-binding protein [Defluviitoga sp.] | diamond | 159 | 99.8 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Petrotogales | Petrotogaceae | Defluviitoga | Defluviitoga sp. | ||
| 28221503 | 28221503 | PRJNA758770_S_NODE_23446_length_253_cov_0.866667_g23320_i0 | PRJNA758770 | 23446 | 253 | 0.866667 | 2.19266751 | Petrotoga sp. 9PWA.NaAc.5.4 | 1434328 | Bacteria | Bacteria | 95.5 | 2.6500000000000003e-21 | NR | WP_255398011.1 | 1434328 | g23320 | i0 | 82.5 | 1.35177865612648 | 57 | 10 | 67.6 | 0 | 253 | 83 | 174 | 230 | WP_255398011.1 IS3 family transposase [Petrotoga sp. 9PWA.NaAc.5.4] | diamond | 342 | 95.5 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Petrotogales | Petrotogaceae | Petrotoga | Petrotoga sp. 9PWA.NaAc.5.4 | ||
| 28505850 | 28505850 | PRJNA758770_S_NODE_30307_length_245_cov_0.906977_g30181_i0 | PRJNA758770 | 30307 | 245 | 0.906977 | 2.22209365 | Defluviitoga tunisiensis | 1006576 | Bacteria | Bacteria | 148 | 2.06e-39 | NR | HOL87040.1 | 1006576 | g30181 | i0 | 98.8 | 0.991836734693878 | 81 | 1 | 99.2 | 0 | 2 | 244 | 420 | 500 | HOL87040.1 tape measure protein [Defluviitoga tunisiensis] | diamond | 243 | 148 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Petrotogales | Petrotogaceae | Defluviitoga | Defluviitoga tunisiensis | ||
| 29358438 | 29358438 | PRJNA758770_S_NODE_32689_length_242_cov_0.923077_g32563_i0 | PRJNA758770 | 32689 | 242 | 0.923077 | 2.23384634 | Defluviitoga tunisiensis | 1006576 | Bacteria | Bacteria | 54.7 | 2.14e-6 | NR | HPP11068.1 | 1006576 | g32563 | i0 | 96 | 0.309917355371901 | 25 | 1 | 31 | 0 | 168 | 242 | 1 | 25 | HPP11068.1 ParB/RepB/Spo0J family partition protein [Defluviitoga tunisiensis] | diamond | 75 | 54.7 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Petrotogales | Petrotogaceae | Defluviitoga | Defluviitoga tunisiensis | ||
| 29579094 | 29579094 | PRJNA758770_S_NODE_23670_length_253_cov_0.866667_g23544_i0 | PRJNA758770 | 23670 | 253 | 0.866667 | 2.19266751 | Fervidobacterium sp. | 1871331 | Bacteria | Bacteria | 127 | 1.3399999999999998e-32 | NR | HUM45018.1 | 1871331 | g23544 | i0 | 100 | 0.699604743083004 | 59 | 0 | 70 | 0 | 3 | 179 | 374 | 432 | HUM45018.1 IS1634 family transposase [Fervidobacterium sp.] | diamond | 177 | 127 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Fervidobacteriaceae | Fervidobacterium | Fervidobacterium sp. | ||
| 29958278 | 29958278 | PRJNA758770_S_NODE_25151_length_251_cov_0.876404_g25025_i0 | PRJNA758770 | 25151 | 251 | 0.876404 | 2.19977404 | Fervidobacterium sp. | 1871331 | Bacteria | Bacteria | 154 | 1.17e-42 | NR | HUM44799.1 | 1871331 | g25025 | i0 | 94 | 0.99203187250996006 | 83 | 5 | 99.2 | 0 | 3 | 251 | 96 | 178 | HUM44799.1 hypothetical protein [Fervidobacterium sp.] | diamond | 249 | 154 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Fervidobacteriaceae | Fervidobacterium | Fervidobacterium sp. | ||
| 30653237 | 30653237 | PRJNA758770_S_NODE_29613_length_246_cov_0.867052_g29487_i0 | PRJNA758770 | 29613 | 246 | 0.867052 | 2.13294792 | Fervidobacterium sp. | 1871331 | Bacteria | Bacteria | 56.6 | 2.42e-8 | NR | HQE50075.1 | 1871331 | g29487 | i0 | 68.8 | 0.390243902439024 | 32 | 10 | 39 | 0 | 2 | 97 | 52 | 83 | HQE50075.1 hypothetical protein [Fervidobacterium sp.] | diamond | 96 | 56.6 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Fervidobacteriaceae | Fervidobacterium | Fervidobacterium sp. | ||
| 30811365 | 30811365 | PRJNA758770_S_NODE_20654_length_267_cov_1.206186_g20528_i0 | PRJNA758770 | 20654 | 267 | 1.206186 | 3.22051662 | Fervidobacterium sp. | 1871331 | Bacteria | Bacteria | 127 | 3.54e-32 | NR | HUM44711.1 | 1871331 | g20528 | i0 | 69.7 | 1 | 89 | 26 | 98.9 | 1 | 264 | 1 | 376 | 464 | HUM44711.1 hypothetical protein [Fervidobacterium sp.] | diamond | 267 | 127 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Fervidobacteriaceae | Fervidobacterium | Fervidobacterium sp. |
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);;