contig_metadata
9 rows where bioproject = "PRJNA1174234", tax_kingdom = "Thermotogati" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2866954 | 2866954 | PRJNA1174234_P_NODE_22923_length_288_cov_1.195349_g22727_i0 | PRJNA1174234 | 22923 | 288 | 1.195349 | 3.44260512 | Trueperaceae bacterium | 2026798 | Bacteria | Bacteria | 381 | 2.9899999999999995e-101 | NTclustered | gi|2108366028|gb|CP070651.1| | 2026798 | g22727 | i0 | 90.69 | 376.715277777778 | 290 | 22 | 99 | 5 | 1 | 287 | 6529 | 6816 | MAG: Trueperaceae bacterium isolate bin86 chromosome | blastn | 108494 | 381 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Trueperaceae bacterium | |||
| 6694096 | 6694096 | PRJNA1174234_P_NODE_33606_length_244_cov_0.900585_g33410_i0 | PRJNA1174234 | 33606 | 244 | 0.900585 | 2.1974274 | uncultured Truepera sp. | 543023 | Bacteria | Bacteria | 153 | 2.73e-45 | NR | CAA9552189.1 | 543023 | g33410 | i0 | 93.8 | 1.99180327868852 | 81 | 5 | 99.6 | 0 | 1 | 243 | 69 | 149 | CAA9552189.1 MAG: LSU ribosomal protein L6p (L9e) [uncultured Truepera sp.] | diamond | 486 | 153 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | uncultured Truepera sp. | ||
| 9969025 | 9969025 | PRJNA1174234_P_NODE_17608_length_329_cov_0.878906_g17412_i0 | PRJNA1174234 | 17608 | 329 | 0.878906 | 2.89160074 | Deinococcus | 1298 | Bacteria | Bacteria | 603 | 6.819999999999999e-168 | NTclustered | gi|2706837832|gb|CP149782.1| | 3112952 | g17412 | i0 | 99.696 | 198.145896656535 | 329 | 1 | 100 | 0 | 1 | 329 | 1454948 | 1454620 | Deinococcus sp. VB142 chromosome 1, complete sequence | blastn | 65190 | 603 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. VB142 | ||
| 11244224 | 11244224 | PRJNA1174234_P_NODE_29209_length_251_cov_0.865169_g29013_i0 | PRJNA1174234 | 29209 | 251 | 0.865169 | 2.17157419 | uncultured Truepera sp. | 543023 | Bacteria | Bacteria | 140 | 1.02e-36 | NR | CAA9557446.1 | 543023 | g29013 | i0 | 84.3 | 0.99203187250996006 | 83 | 13 | 99.2 | 0 | 249 | 1 | 507 | 589 | CAA9557446.1 MAG: Heterodimeric efflux ABC transporter, permease/ATP-binding subunit 1 [uncultured Truepera sp.] | diamond | 249 | 140 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | uncultured Truepera sp. | ||
| 11244236 | 11244236 | PRJNA1174234_P_NODE_4289_length_646_cov_2.595113_g4100_i0 | PRJNA1174234 | 4289 | 646 | 2.595113 | 16.76442998 | Truepera | 332248 | Bacteria | Bacteria | 784 | 0 | NTclustered | gi|470486385|ref|NR_076754.1| | 332249 | g4100 | i0 | 90.381 | 155.557275541796 | 603 | 48 | 92 | 8 | 1 | 597 | 1841 | 1243 | Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence | blastn | 100490 | 784 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | Truepera radiovictrix | ||
| 12519598 | 12519598 | PRJNA1174234_P_NODE_15470_length_351_cov_1.158273_g15274_i0 | PRJNA1174234 | 15470 | 351 | 1.158273 | 4.06553823 | Truepera | 332248 | Bacteria | Bacteria | 549 | 9.649999999999996e-152 | NTclustered | gi|470486385|ref|NR_076754.1| | 332249 | g15274 | i0 | 94.886 | 159.074074074074 | 352 | 17 | 100 | 1 | 1 | 351 | 1753 | 2104 | Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence | blastn | 55835 | 549 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | Truepera radiovictrix | ||
| 27040594 | 27040594 | PRJNA1174234_P_NODE_31962_length_247_cov_0.867816_g31766_i0 | PRJNA1174234 | 31962 | 247 | 0.867816 | 2.14350552 | uncultured Truepera sp. | 543023 | Bacteria | Bacteria | 164 | 4.279999999999999e-48 | NR | CAA9581748.1 | 543023 | g31766 | i0 | 95.1 | 0.995951417004049 | 82 | 4 | 99.6 | 0 | 247 | 2 | 190 | 271 | CAA9581748.1 MAG: Pyrimidine-specific ribonucleoside hydrolase RihB [uncultured Truepera sp.] | diamond | 246 | 164 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | uncultured Truepera sp. | ||
| 27597017 | 27597017 | PRJNA1174234_P_NODE_17484_length_330_cov_0.898833_g17288_i0 | PRJNA1174234 | 17484 | 330 | 0.898833 | 2.9661489 | Bacteria | 2 | Bacteria | Bacteria | 116 | 1.02e-27 | NR | WP_081895104.1 | 1495039 | g17288 | i0 | 63 | 67.0181818181818 | 92 | 33 | 82.7 | 1 | 330 | 58 | 356 | 447 | WP_081895104.1 molecular chaperone DnaK [Mesoaciditoga lauensis] | diamond | 22116 | 117 | 0.991452991452991 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Mesoaciditogales | Mesoaciditogaceae | Mesoaciditoga | Mesoaciditoga lauensis | ||
| 30135038 | 30135038 | PRJNA1174234_P_NODE_33912_length_244_cov_0.894737_g33716_i0 | PRJNA1174234 | 33912 | 244 | 0.894737 | 2.18315828 | Synergistaceae bacterium | 2053624 | Bacteria | Bacteria | 46.6 | 0.00164 | NR | MBR2207957.1 | 2053624 | g33716 | i0 | 32.9 | 1.72131147540984 | 73 | 46 | 89.8 | 1 | 7 | 225 | 379 | 448 | MBR2207957.1 ankyrin repeat domain-containing protein [Synergistaceae bacterium] | diamond | 420 | 46.6 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Synergistaceae | Synergistaceae bacterium |
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);;