contig_metadata
9 rows where bioproject = "PRJNA770361" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10950416 | 10950416 | PRJNA770361_P_NODE_16169_length_248_cov_0.891429_g16074_i0 | PRJNA770361 | 16169 | 248 | 0.891429 | 2.21074392 | Synergistales bacterium | 2268201 | Bacteria | Bacteria | 130 | 1.01e-25 | NTclustered | gi|2621703689|emb|OY762654.1| | 2268201 | g16074 | i0 | 94.186 | 47.6895161290323 | 86 | 3 | 34 | 2 | 146 | 230 | 446381 | 446297 | MAG: Synergistales bacterium isolate e2a2af2a-30b9-47e3-8e03-f1be080e1666 genome assembly, chromosome: 1 | blastn | 11827 | 130 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Synergistales bacterium | ||||
| 16048882 | 16048882 | PRJNA770361_P_NODE_14593_length_251_cov_0.876404_g14498_i0 | PRJNA770361 | 14593 | 251 | 0.876404 | 2.19977404 | Mesotoga infera | 1236046 | Bacteria | Bacteria | 364 | 2.57e-96 | NTclustered | gi|1417721526|emb|LS974202.1| | 1236046 | g14498 | i0 | 92.829 | 1 | 251 | 18 | 100 | 0 | 1 | 251 | 809042 | 808792 | Mesotoga infera isolate MESINF1 genome assembly, chromosome: MESINF | blastn | 251 | 364 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Kosmotogales | Kosmotogaceae | Mesotoga | Mesotoga infera | ||
| 23699291 | 23699291 | PRJNA770361_P_NODE_16839_length_246_cov_1.352601_g16744_i0 | PRJNA770361 | 16839 | 246 | 1.352601 | 3.32739846 | Deinococcus sp. VB343 | 3385567 | Bacteria | Bacteria | 156 | 1.65e-33 | NTclustered | gi|2905211496|gb|CP179945.1| | 3385567 | g16744 | i0 | 79.545 | 42.4430894308943 | 220 | 43 | 89 | 2 | 28 | 246 | 1463475 | 1463257 | Deinococcus sp. VB343 chromosome 1, complete sequence | blastn | 10441 | 156 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. VB343 | ||
| 26682858 | 26682858 | PRJNA770361_P_NODE_18081_length_244_cov_0.912281_g17986_i0 | PRJNA770361 | 18081 | 244 | 0.912281 | 2.22596564 | Truepera | 332248 | Bacteria | Bacteria | 88.6 | 9.96e-20 | NR | WP_013176890.1 | 332249 | g17986 | i0 | 82.5 | 2.07786885245902 | 57 | 10 | 70.1 | 0 | 1 | 171 | 136 | 192 | WP_013176890.1 protein jag [Truepera radiovictrix] | diamond | 507 | 88.6 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | Truepera radiovictrix | ||
| 29936555 | 29936555 | PRJNA770361_P_NODE_11791_length_274_cov_1.507463_g11696_i0 | PRJNA770361 | 11791 | 274 | 1.507463 | 4.13044862 | Bacteria | 2 | Bacteria | Bacteria | 44.7 | 0.011 | NR | MEA1884334.1 | 2053689 | g11696 | i0 | 33.3 | 0.985401459854015 | 45 | 30 | 49.3 | 0 | 242 | 108 | 416 | 460 | MEA1884334.1 C69 family dipeptidase [Thermotogota bacterium] | diamond | 270 | 44.7 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogota bacterium | ||||||
| 30527106 | 30527106 | PRJNA770361_P_NODE_14653_length_251_cov_0.876404_g14558_i0 | PRJNA770361 | 14653 | 251 | 0.876404 | 2.19977404 | Synergistaceae bacterium | 2053624 | Bacteria | Bacteria | 166 | 6.42e-48 | NR | MEA4880595.1 | 2053624 | g14558 | i0 | 95.2 | 0.99203187250996006 | 83 | 4 | 99.2 | 0 | 250 | 2 | 162 | 244 | MEA4880595.1 molybdopterin molybdotransferase MoeA [Synergistaceae bacterium] | diamond | 249 | 166 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Synergistaceae | Synergistaceae bacterium | |||
| 31548410 | 31548410 | PRJNA770361_P_NODE_8476_length_323_cov_1.464000_g8381_i0 | PRJNA770361 | 8476 | 323 | 1.464 | 4.72872 | root | 1 | Root_unresolved | Root_unresolved | 110 | 7.830000000000001e-26 | NR | MCA9840345.1 | 2026798 | g8381 | i0 | 53.1 | 3.64086687306502 | 98 | 46 | 91 | 0 | 1 | 294 | 319 | 416 | MCA9840345.1 acetyl-CoA C-acyltransferase [Trueperaceae bacterium] | diamond | 1176 | 111 | 0.990990990990991 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Trueperaceae bacterium | |||
| 31664982 | 31664982 | PRJNA770361_P_NODE_5157_length_414_cov_1.826979_g5062_i0 | PRJNA770361 | 5157 | 414 | 1.826979 | 7.56369306 | Deinococcus radiotolerans | 1309407 | Bacteria | Bacteria | 65.1 | 1.5e-9 | NR | WP_189070513.1 | 1309407 | g5062 | i0 | 38.4 | 1.2536231884058 | 86 | 47 | 60.1 | 4 | 159 | 407 | 151 | 233 | WP_189070513.1 phospholipase A2 [Deinococcus radiotolerans] | diamond | 519 | 65.1 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus radiotolerans | ||
| 32424458 | 32424458 | PRJNA770361_P_NODE_5639_length_396_cov_1.448916_g5544_i0 | PRJNA770361 | 5639 | 396 | 1.448916 | 5.73770736 | Aminobacterium colombiense | 81468 | Bacteria | Bacteria | 132 | 2.62e-36 | NR | WP_288925378.1 | 81468 | g5544 | i0 | 78.8 | 0.643939393939394 | 85 | 15 | 64.4 | 1 | 394 | 140 | 91 | 172 | WP_288925378.1 hypothetical protein [Aminobacterium colombiense] | diamond | 255 | 132 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Aminobacteriaceae | Aminobacterium | Aminobacterium colombiense |
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);;