contig_metadata
15 rows where bioproject = "PRJNA1034995" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2718854 | 2718854 | PRJNA1034995_S_NODE_24603_length_321_cov_21.514388_g24447_i0 | PRJNA1034995 | 24603 | 321 | 21.514388 | 69.06118548 | Trueperaceae bacterium | 2026798 | Bacteria | Bacteria | 114 | 9.34e-27 | NR | MEX2542841.1 | 2026798 | g24447 | i0 | 55.7 | 3.98130841121495 | 106 | 47 | 99.1 | 0 | 319 | 2 | 722 | 827 | MEX2542841.1 tetratricopeptide repeat protein [Trueperaceae bacterium] | diamond | 1278 | 114 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Trueperaceae bacterium | |||
| 3994875 | 3994875 | PRJNA1034995_S_NODE_17284_length_436_cov_18.956743_g17129_i0 | PRJNA1034995 | 17284 | 436 | 18.956743 | 82.65139948 | Deinococcus soli (ex Cha et al. 2016) | 1309411 | Bacteria | Bacteria | 693 | 0 | NTclustered | gi|821341785|gb|CP011389.1| | 1309411 | g17129 | i0 | 97.767 | 546.098623853211 | 403 | 8 | 92 | 1 | 27 | 428 | 1637984 | 1637582 | 'Deinococcus soli' Cha et al. 2014 strain N5, complete genome | blastn | 238099 | 693 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus soli (ex Cha et al. 2016) | ||
| 5271231 | 5271231 | PRJNA1034995_S_NODE_21165_length_366_cov_14.777090_g21009_i0 | PRJNA1034995 | 21165 | 366 | 14.77709 | 54.0841494 | Bacteria | 2 | Bacteria | Bacteria | 131 | 5.07e-36 | NR | MEM7735398.1 | 1913990 | g21009 | i0 | 87.5 | 3.54098360655738 | 72 | 9 | 59 | 0 | 341 | 126 | 114 | 185 | MEM7735398.1 elongation factor P [Deinococcota bacterium] | diamond | 1296 | 131 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococcota bacterium | ||||||
| 10371694 | 10371694 | PRJNA1034995_S_NODE_31789_length_256_cov_5.755869_g31633_i0 | PRJNA1034995 | 31789 | 256 | 5.755869 | 14.73502464 | Deinococcus sp. YIM 77859 | 1540221 | Bacteria | Bacteria | 63.5 | 1.98e-9 | NR | WP_034383094.1 | 1540221 | g31633 | i0 | 43.4 | 0.890625 | 76 | 41 | 86.7 | 1 | 248 | 27 | 79 | 154 | WP_034383094.1 hypothetical protein [Deinococcus sp. YIM 77859] | diamond | 228 | 63.5 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. YIM 77859 | ||
| 12922014 | 12922014 | PRJNA1034995_S_NODE_13811_length_537_cov_137.898785_g13668_i0 | PRJNA1034995 | 13811 | 537 | 137.898785 | 740.51647545 | uncultured Deinococcus sp. | 158789 | Bacteria | Bacteria | 929 | 0 | NTclustered | gi|199584206|gb|FJ028698.1| | 158789 | g13668 | i0 | 100 | 91.2998137802607 | 503 | 0 | 94 | 0 | 1 | 503 | 503 | 1 | Uncultured Deinococcus sp. clone SSB-84 16S ribosomal RNA gene, partial sequence | blastn | 49028 | 929 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | uncultured Deinococcus sp. | ||
| 14196930 | 14196930 | PRJNA1034995_S_NODE_12292_length_648_cov_22.277686_g12192_i0 | PRJNA1034995 | 12292 | 648 | 22.277686 | 144.35940528 | Truepera radiovictrix | 332249 | Bacteria | Bacteria | 236 | 4.3000000000000005e-74 | NR | WP_013178019.1 | 332249 | g12192 | i0 | 72.3 | 1.47222222222222 | 159 | 44 | 73.6 | 0 | 648 | 172 | 133 | 291 | WP_013178019.1 carbohydrate ABC transporter permease [Truepera radiovictrix] | diamond | 954 | 236 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | Truepera radiovictrix | ||
| 14196939 | 14196939 | PRJNA1034995_S_NODE_13352_length_558_cov_34.114563_g13213_i0 | PRJNA1034995 | 13352 | 558 | 34.114563 | 190.35926154 | Trueperaceae bacterium | 2026798 | Bacteria | Bacteria | 676 | 0 | NTclustered | gi|2108366028|gb|CP070651.1| | 2026798 | g13213 | i0 | 88.632 | 126.123655913978 | 563 | 55 | 99 | 6 | 1 | 556 | 7687 | 8247 | MAG: Trueperaceae bacterium isolate bin86 chromosome | blastn | 70377 | 676 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Trueperaceae bacterium | |||
| 18020169 | 18020169 | PRJNA1034995_S_NODE_14415_length_514_cov_16.422505_g14267_i0 | PRJNA1034995 | 14415 | 514 | 16.422505 | 84.4116757 | Truepera radiovictrix | 332249 | Bacteria | Bacteria | 288 | 1.63e-93 | NR | WP_013178259.1 | 332249 | g14267 | i0 | 85.3 | 0.95136186770428 | 163 | 24 | 95.1 | 0 | 4 | 492 | 162 | 324 | WP_013178259.1 asparagine--tRNA ligase [Truepera radiovictrix] | diamond | 489 | 288 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | Truepera radiovictrix | ||
| 26718195 | 26718195 | PRJNA1034995_S_NODE_31961_length_255_cov_2.825472_g31805_i0 | PRJNA1034995 | 31961 | 255 | 2.825472 | 7.2049536 | uncultured Truepera sp. | 543023 | Bacteria | Bacteria | 126 | 8.53e-32 | NR | CAA9568595.1 | 543023 | g31805 | i0 | 80.5 | 0.905882352941176 | 77 | 14 | 89.4 | 1 | 26 | 253 | 424 | 500 | CAA9568595.1 MAG: Aspartyl-tRNA synthetase [uncultured Truepera sp.] | diamond | 231 | 126 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | uncultured Truepera sp. | ||
| 27382924 | 27382924 | PRJNA1034995_S_NODE_26363_length_303_cov_5.980769_g26207_i0 | PRJNA1034995 | 26363 | 303 | 5.980769 | 18.12173007 | Trueperaceae bacterium | 2026798 | Bacteria | Bacteria | 95.9 | 1.63e-20 | NR | MCA9839205.1 | 2026798 | g26207 | i0 | 48 | 0.99009900990099 | 100 | 52 | 99 | 0 | 2 | 301 | 210 | 309 | MCA9839205.1 ATP-binding protein [Trueperaceae bacterium] | diamond | 300 | 95.9 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Trueperaceae bacterium | |||
| 28416946 | 28416946 | PRJNA1034995_S_NODE_26006_length_306_cov_27.882129_g25850_i0 | PRJNA1034995 | 26006 | 306 | 27.882129 | 85.31931474 | Bacteria | 2 | Bacteria | Bacteria | 40.8 | 0.0313 | NR | MDQ3397214.1 | 1913990 | g25850 | i0 | 56.4 | 0.803921568627451 | 39 | 17 | 38.2 | 0 | 143 | 259 | 4 | 42 | MDQ3397214.1 type II secretion system GspH family protein [Deinococcota bacterium] | diamond | 246 | 41.2 | 0.990291262135922 | Bacteria | Thermotogati | Deinococcota | Deinococcota bacterium | ||||||
| 29182729 | 29182729 | PRJNA1034995_S_NODE_13289_length_562_cov_22.578035_g13150_i0 | PRJNA1034995 | 13289 | 562 | 22.578035 | 126.8885567 | Deinococcota bacterium | 1913990 | Bacteria | Bacteria | 278 | 3.3800000000000003e-91 | NR | MDQ3398552.1 | 1913990 | g13150 | i0 | 82 | 0.891459074733096 | 167 | 30 | 89.1 | 0 | 561 | 61 | 140 | 306 | MDQ3398552.1 ABC transporter permease [Deinococcota bacterium] | diamond | 501 | 278 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococcota bacterium | ||||||
| 30288301 | 30288301 | PRJNA1034995_S_NODE_17152_length_438_cov_33.582278_g16997_i0 | PRJNA1034995 | 17152 | 438 | 33.582278 | 147.09037764 | uncultured Truepera sp. | 543023 | Bacteria | Bacteria | 127 | 3.84e-33 | NR | CAA9585342.1 | 543023 | g16997 | i0 | 80.5 | 0.527397260273973 | 77 | 15 | 52.7 | 0 | 232 | 2 | 3 | 79 | CAA9585342.1 MAG: Cytochrome c oxidase caa3-type assembly factor CtaG_BS (unrelated to Cox11-CtaG family) [uncultured Truepera sp.] | diamond | 231 | 127 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | uncultured Truepera sp. | ||
| 30888257 | 30888257 | PRJNA1034995_S_NODE_18714_length_407_cov_19.019231_g18559_i0 | PRJNA1034995 | 18714 | 407 | 19.019231 | 77.40827017 | Trueperaceae bacterium | 2026798 | Bacteria | Bacteria | 111 | 1.85e-25 | NR | MDZ7703625.1 | 2026798 | g18559 | i0 | 41.5 | 0.995085995085995 | 135 | 72 | 99.5 | 2 | 407 | 3 | 832 | 959 | MDZ7703625.1 plasmid replication protein, CyRepA1 family [Trueperaceae bacterium] | diamond | 405 | 111 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Trueperaceae bacterium | |||
| 31299031 | 31299031 | PRJNA1034995_S_NODE_15635_length_476_cov_30.505774_g15484_i0 | PRJNA1034995 | 15635 | 476 | 30.505774 | 145.20748424 | Truepera radiovictrix | 332249 | Bacteria | Bacteria | 177 | 9.83e-54 | NR | WP_013176733.1 | 332249 | g15484 | i0 | 53.1 | 1.02100840336134 | 162 | 68 | 98.3 | 4 | 6 | 473 | 16 | 175 | WP_013176733.1 hypothetical protein [Truepera radiovictrix] | diamond | 486 | 177 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | Truepera radiovictrix |
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);;