contig_metadata
10 rows where analysis = "diamond" and tax_clade = "DHVE2 group"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26813178 | 26813178 | PRJNA1010780_S_NODE_881_length_2356_cov_20.558380_g768_i0 | PRJNA1010780 | 881 | 2356 | 20.55838 | 484.3554328 | Candidatus Aciduliprofundum boonei | 379547 | Archaea | Archaea | 100 | 1.47e-17 | NR | WP_012997047.1 | 379547 | g768 | i0 | 30.5 | 0.669779286926995 | 272 | 172 | 33 | 8 | 955 | 179 | 1204 | 1471 | WP_012997047.1 NosD domain-containing protein [Candidatus Aciduliprofundum boonei] | diamond | 1578 | 100 | 1 | Archaea | DHVE2 group | Methanobacteriati | Thermoplasmatota | Candidatus Aciduliprofundum | Candidatus Aciduliprofundum boonei | ||||
| 27805754 | 27805754 | PRJNA560932_P_NODE_4244_length_828_cov_2.735099_g3942_i0 | PRJNA560932 | 4244 | 828 | 2.735099 | 22.64661972 | Candidatus Aciduliprofundum boonei | 379547 | Archaea | Archaea | 49.7 | 0.00247 | NR | WP_008083872.1 | 379547 | g3942 | i0 | 31.6 | 0.355072463768116 | 98 | 62 | 35.5 | 2 | 443 | 736 | 17 | 109 | WP_008083872.1 RNA 2',3'-cyclic phosphodiesterase [Candidatus Aciduliprofundum boonei] | diamond | 294 | 49.7 | 1 | Archaea | DHVE2 group | Methanobacteriati | Thermoplasmatota | Candidatus Aciduliprofundum | Candidatus Aciduliprofundum boonei | ||||
| 27932610 | 27932610 | PRJNA594101_S_NODE_35865_length_289_cov_1.425926_g35563_i0 | PRJNA594101 | 35865 | 289 | 1.425926 | 4.12092614 | Candidatus Aciduliprofundum boonei | 379547 | Archaea | Archaea | 48.1 | 6.5e-4 | NR | WP_008084383.1 | 379547 | g35563 | i0 | 36.8 | 0.705882352941177 | 68 | 43 | 70.6 | 0 | 27 | 230 | 129 | 196 | WP_008084383.1 sulfite exporter TauE/SafE family protein [Candidatus Aciduliprofundum boonei] | diamond | 204 | 48.1 | 1 | Archaea | DHVE2 group | Methanobacteriati | Thermoplasmatota | Candidatus Aciduliprofundum | Candidatus Aciduliprofundum boonei | ||||
| 28154394 | 28154394 | PRJNA615351_P_NODE_121605_length_246_cov_1.696682_g107505_i0 | PRJNA615351 | 121605 | 246 | 1.696682 | 4.17383772 | Candidatus Aciduliprofundum boonei | 379547 | Archaea | Archaea | 45.8 | 0.00178 | NR | WP_008083872.1 | 379547 | g107505 | i0 | 34.3 | 0.853658536585366 | 70 | 43 | 85.4 | 1 | 215 | 6 | 33 | 99 | WP_008083872.1 RNA 2',3'-cyclic phosphodiesterase [Candidatus Aciduliprofundum boonei] | diamond | 210 | 45.8 | 1 | Archaea | DHVE2 group | Methanobacteriati | Thermoplasmatota | Candidatus Aciduliprofundum | Candidatus Aciduliprofundum boonei | ||||
| 29592081 | 29592081 | PRJNA1010780_S_NODE_3010_length_1526_cov_4.570087_g2690_i0 | PRJNA1010780 | 3010 | 1526 | 4.570087 | 69.73952762 | Candidatus Aciduliprofundum boonei | 379547 | Archaea | Archaea | 50.8 | 0.0189 | NR | WP_012997047.1 | 379547 | g2690 | i0 | 32.7 | 0.204456094364351 | 104 | 60 | 18.5 | 3 | 1162 | 1443 | 1209 | 1312 | WP_012997047.1 NosD domain-containing protein [Candidatus Aciduliprofundum boonei] | diamond | 312 | 50.8 | 1 | Archaea | DHVE2 group | Methanobacteriati | Thermoplasmatota | Candidatus Aciduliprofundum | Candidatus Aciduliprofundum boonei | ||||
| 30034676 | 30034676 | PRJNA1010780_S_NODE_1911_length_1826_cov_5.081519_g1697_i0 | PRJNA1010780 | 1911 | 1826 | 5.081519 | 92.78853694 | Candidatus Aciduliprofundum boonei | 379547 | Archaea | Archaea | 91.7 | 5.7e-15 | NR | WP_012997047.1 | 379547 | g1697 | i0 | 29.1 | 0.463307776560789 | 282 | 169 | 43.9 | 11 | 906 | 106 | 1301 | 1566 | WP_012997047.1 NosD domain-containing protein [Candidatus Aciduliprofundum boonei] | diamond | 846 | 91.7 | 1 | Archaea | DHVE2 group | Methanobacteriati | Thermoplasmatota | Candidatus Aciduliprofundum | Candidatus Aciduliprofundum boonei | ||||
| 30153165 | 30153165 | PRJNA1010780_S_NODE_1712_length_1905_cov_3.551872_g1515_i0 | PRJNA1010780 | 1712 | 1905 | 3.551872 | 67.6631616 | Candidatus Aciduliprofundum | 379546 | Archaea | Archaea | 64.3 | 1.89e-6 | NR | WP_012997047.1 | 379547 | g1515 | i0 | 26.9 | 1.11181102362205 | 242 | 153 | 35.4 | 10 | 678 | 4 | 1204 | 1438 | WP_012997047.1 NosD domain-containing protein [Candidatus Aciduliprofundum boonei] | diamond | 2118 | 64.3 | 1 | Archaea | DHVE2 group | Methanobacteriati | Thermoplasmatota | Candidatus Aciduliprofundum | Candidatus Aciduliprofundum boonei | ||||
| 32293883 | 32293883 | PRJNA615351_P_NODE_69279_length_507_cov_2.330508_g55424_i0 | PRJNA615351 | 69279 | 507 | 2.330508 | 11.81567556 | Aciduliprofundum sp. MAR | 2060325 | Archaea | Archaea | 63.5 | 2.9e-8 | NR | WP_015282595.1 | 673860 | g55424 | i0 | 42.2 | 0.49112426035503 | 83 | 47 | 48.5 | 1 | 278 | 33 | 13 | 95 | WP_015282595.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Aciduliprofundum sp. MAR08-339] | diamond | 249 | 63.5 | 1 | Archaea | DHVE2 group | Methanobacteriati | Thermoplasmatota | Candidatus Aciduliprofundum | Aciduliprofundum sp. MAR08-339 | ||||
| 32453715 | 32453715 | PRJNA685607_P_NODE_51579_length_275_cov_1.173267_g51220_i0 | PRJNA685607 | 51579 | 275 | 1.173267 | 3.22648425 | Candidatus Aciduliprofundum boonei | 379547 | Archaea | Archaea | 105 | 7.57e-25 | NR | WP_187287714.1 | 379547 | g51220 | i0 | 58.2 | 0.992727272727273 | 91 | 38 | 99.3 | 0 | 275 | 3 | 98 | 188 | WP_187287714.1 bis-aminopropyl spermidine synthase family protein [Candidatus Aciduliprofundum boonei] | diamond | 273 | 105 | 1 | Archaea | DHVE2 group | Methanobacteriati | Thermoplasmatota | Candidatus Aciduliprofundum | Candidatus Aciduliprofundum boonei | ||||
| 32945525 | 32945525 | PRJEB20058_P_NODE_35146_length_709_cov_6.785494_g32572_i0 | PRJEB20058 | 35146 | 709 | 6.785494 | 48.10915246 | Aciduliprofundum boonei T469 | 439481 | Archaea | Archaea | 200 | 1.2399999999999998e-55 | NR | EDY34769.1 | 439481 | g32572 | i0 | 55.1 | 0.706629055007052 | 167 | 65 | 70.2 | 2 | 212 | 709 | 376 | 533 | EDY34769.1 N-6 DNA Methylase family [Aciduliprofundum boonei T469] | diamond | 501 | 200 | 1 | Archaea | DHVE2 group | Methanobacteriati | Thermoplasmatota | Candidatus Aciduliprofundum | Candidatus Aciduliprofundum boonei |
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);;