contig_metadata
21 rows where bioproject = "PRJNA385064" and tax_phylum = "Uroviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1075844 | 1075844 | PRJNA385064_P_NODE_5741_length_178_cov_1.062016_g5616_i0 | PRJNA385064 | 5741 | 178 | 1.062016 | 1.89038848 | Pahexavirus | 1982251 | Viruses | Viruses | 329 | 6.21e-86 | NTclustered | gi|906475808|ref|NC_027622.1| | 1655022 | g5616 | i0 | 100 | 89.1685393258427 | 178 | 0 | 100 | 0 | 1 | 178 | 19930 | 19753 | Propionibacterium phage Stormborn, complete genome | blastn | 15872 | 329 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Pahexavirus stormborn | ||||
| 2956060 | 2956060 | PRJNA385064_P_NODE_6863_length_166_cov_0.871795_g6738_i0 | PRJNA385064 | 6863 | 166 | 0.871795 | 1.4471797 | Geobacillus virus E3 | 1572712 | Viruses | Viruses | 235 | 1.2899999999999998e-57 | NTclustered | gi|985758336|ref|NC_029073.1| | 1572712 | g6738 | i0 | 93.125 | 0.963855421686747 | 160 | 11 | 96 | 0 | 2 | 161 | 49938 | 50097 | Geobacillus virus E3, complete genome | blastn | 160 | 235 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Geobacillus virus E3 | |||||
| 2956067 | 2956067 | PRJNA385064_P_NODE_7363_length_164_cov_0.886957_g7238_i0 | PRJNA385064 | 7363 | 164 | 0.886957 | 1.45460948 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 281 | 1.6000000000000001e-71 | NTclustered | gi|2054649992|tpg|BK052003.1| | 2832643 | g7238 | i0 | 97.561 | 1 | 164 | 4 | 100 | 0 | 1 | 164 | 50489 | 50326 | MAG TPA_asm: Caudoviricetes sp. isolate ctupA9, partial genome | blastn | 164 | 281 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 5509080 | 5509080 | PRJNA385064_P_NODE_5285_length_186_cov_1.153285_g5160_i0 | PRJNA385064 | 5285 | 186 | 1.153285 | 2.1451101 | Geobacillus virus E3 | 1572712 | Viruses | Viruses | 315 | 1.84e-81 | NTclustered | gi|985758336|ref|NC_029073.1| | 1572712 | g5160 | i0 | 97.297 | 1.76344086021505 | 185 | 5 | 99 | 0 | 2 | 186 | 62121 | 62305 | Geobacillus virus E3, complete genome | blastn | 328 | 315 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Geobacillus virus E3 | |||||
| 10609164 | 10609164 | PRJNA385064_P_NODE_3309_length_241_cov_1.177083_g3184_i0 | PRJNA385064 | 3309 | 241 | 1.177083 | 2.83677003 | Geobacillus phage vB_GthS_PK5.1 | 2985566 | Viruses | Viruses | 119 | 2.11e-22 | NTclustered | gi|2320141253|gb|OP341628.1| | 2985566 | g3184 | i0 | 84.746 | 0.62655601659751 | 118 | 18 | 49 | 0 | 124 | 241 | 36061 | 35944 | Geobacillus phage vB_GthS_PK5.1, complete genome | blastn | 151 | 119 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Geobacillus phage vB_GthS_PK5.1 | |||||
| 11884051 | 11884051 | PRJNA385064_P_NODE_7030_length_165_cov_0.879310_g6905_i0 | PRJNA385064 | 7030 | 165 | 0.87931 | 1.4508615 | Geobacillus virus E3 | 1572712 | Viruses | Viruses | 159 | 7.9e-35 | NTclustered | gi|985758336|ref|NC_029073.1| | 1572712 | g6905 | i0 | 88.148 | 0.818181818181818 | 135 | 15 | 82 | 1 | 31 | 165 | 114601 | 114734 | Geobacillus virus E3, complete genome | blastn | 135 | 159 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Geobacillus virus E3 | |||||
| 14434101 | 14434101 | PRJNA385064_P_NODE_6892_length_166_cov_0.871795_g6767_i0 | PRJNA385064 | 6892 | 166 | 0.871795 | 1.4471797 | Deep-sea thermophilic phage D6E | 749413 | Viruses | Viruses | 302 | 1.2500000000000001e-77 | NTclustered | gi|423262327|ref|NC_019544.1| | 749413 | g6767 | i0 | 99.398 | 1 | 166 | 1 | 100 | 0 | 1 | 166 | 9597 | 9762 | Deep-sea thermophilic phage D6E, complete genome | blastn | 166 | 302 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Deep-sea thermophilic phage D6E | |||||
| 16982740 | 16982740 | PRJNA385064_P_NODE_3054_length_251_cov_1.262376_g2929_i0 | PRJNA385064 | 3054 | 251 | 1.262376 | 3.16856376 | Geobacillus phage vB_GthS_PK5.1 | 2985566 | Viruses | Viruses | 117 | 7.95e-22 | NTclustered | gi|2320141253|gb|OP341628.1| | 2985566 | g2929 | i0 | 98.485 | 2.51394422310757 | 66 | 1 | 26 | 0 | 1 | 66 | 28570 | 28505 | Geobacillus phage vB_GthS_PK5.1, complete genome | blastn | 631 | 117 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Geobacillus phage vB_GthS_PK5.1 | |||||
| 16982747 | 16982747 | PRJNA385064_P_NODE_5274_length_186_cov_1.540146_g5149_i0 | PRJNA385064 | 5274 | 186 | 1.540146 | 2.86467156 | Geobacillus phage vB_GthS_NIIg9.7 | 2985562 | Viruses | Viruses | 279 | 6.7000000000000014e-71 | NTclustered | gi|2320140953|gb|OP341624.1| | 2985562 | g5149 | i0 | 93.651 | 10.8817204301075 | 189 | 9 | 100 | 1 | 1 | 186 | 3817 | 3629 | Geobacillus phage vB_GthS_NIIg9.7, complete genome | blastn | 2024 | 279 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Geobacillus phage vB_GthS_NIIg9.7 | |||||
| 18256902 | 18256902 | PRJNA385064_P_NODE_7095_length_165_cov_0.879310_g6970_i0 | PRJNA385064 | 7095 | 165 | 0.87931 | 1.4508615 | Geobacillus virus E3 | 1572712 | Viruses | Viruses | 272 | 9.73e-69 | NTclustered | gi|985758336|ref|NC_029073.1| | 1572712 | g6970 | i0 | 96.364 | 1 | 165 | 6 | 100 | 0 | 1 | 165 | 68618 | 68454 | Geobacillus virus E3, complete genome | blastn | 165 | 272 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Geobacillus virus E3 | |||||
| 19531230 | 19531230 | PRJNA385064_P_NODE_7476_length_163_cov_0.894737_g7351_i0 | PRJNA385064 | 7476 | 163 | 0.894737 | 1.45842131 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 241 | 2.7000000000000008e-59 | NTclustered | gi|2054427358|tpg|BK035868.1| | 2832643 | g7351 | i0 | 93.252 | 7 | 163 | 11 | 100 | 0 | 1 | 163 | 165666 | 165828 | MAG TPA_asm: Caudoviricetes sp. isolate ctExz15, partial genome | blastn | 1141 | 241 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 24631762 | 24631762 | PRJNA385064_P_NODE_6360_length_168_cov_1.714286_g6235_i0 | PRJNA385064 | 6360 | 168 | 1.714286 | 2.88000048 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 233 | 4.7e-57 | NTclustered | gi|2057092551|tpg|BK038147.1| | 2832643 | g6235 | i0 | 91.667 | 1 | 168 | 14 | 100 | 0 | 1 | 168 | 6871 | 7038 | MAG TPA_asm: Caudoviricetes sp. isolate ctGN732, partial genome | blastn | 168 | 233 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 26885512 | 26885512 | PRJNA385064_P_NODE_7221_length_164_cov_0.886957_g7096_i0 | PRJNA385064 | 7221 | 164 | 0.886957 | 1.45460948 | Bacillus phage pW2 | 2500559 | Viruses | Viruses | 93.6 | 1.57e-20 | NR | YP_010680019.1 | 2500559 | g7096 | i0 | 86.5 | 1.90243902439024 | 52 | 7 | 95.1 | 0 | 162 | 7 | 61 | 112 | YP_010680019.1 DNA polymerase III alpha subunit [Bacillus phage pW2] | diamond | 312 | 93.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Sophritavirus | Sophritavirus pW2 | ||||
| 27169753 | 27169753 | PRJNA385064_P_NODE_1442_length_396_cov_1.265130_g1317_i0 | PRJNA385064 | 1442 | 396 | 1.26513 | 5.0099148 | Bacillus phage vB_BanS-Tsamsa | 1308863 | Viruses | Viruses | 147 | 3.5399999999999987e-41 | NR | YP_008873475.1 | 1308863 | g1317 | i0 | 59.8 | 0.886363636363636 | 117 | 46 | 88.6 | 1 | 351 | 1 | 103 | 218 | YP_008873475.1 hypothetical protein X915_gp233 [Bacillus phage vB_BanS-Tsamsa] | diamond | 351 | 147 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Tsamsavirus | Tsamsavirus tsamsa | ||||
| 27391418 | 27391418 | PRJNA385064_P_NODE_5743_length_178_cov_1.023256_g5618_i0 | PRJNA385064 | 5743 | 178 | 1.023256 | 1.82139568 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 52 | 8.41e-6 | NR | XOR03320.1 | 2832643 | g5618 | i0 | 52.9 | 2.59550561797753 | 51 | 22 | 86 | 1 | 2 | 154 | 287 | 335 | XOR03320.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 462 | 52 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29380414 | 29380414 | PRJNA385064_P_NODE_6169_length_171_cov_0.860656_g6044_i0 | PRJNA385064 | 6169 | 171 | 0.860656 | 1.47172176 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 77 | 1.76e-15 | NR | XOR03451.1 | 2832643 | g6044 | i0 | 61.1 | 1.91228070175439 | 54 | 21 | 94.7 | 0 | 9 | 170 | 61 | 114 | XOR03451.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 327 | 77 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29617969 | 29617969 | PRJNA385064_P_NODE_3670_length_227_cov_1.162921_g3545_i0 | PRJNA385064 | 3670 | 227 | 1.162921 | 2.63983067 | Viruses | 10239 | Viruses | Viruses | 55.5 | 9.99e-7 | NR | YP_010679447.1 | 2783539 | g3545 | i0 | 40.6 | 1.81057268722467 | 64 | 36 | 84.6 | 1 | 193 | 2 | 19 | 80 | YP_010679447.1 ATP binding domain TrwB-like protein [Bacillus phage Kirov] | diamond | 411 | 55.8 | 0.99462365591397806 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Kirovvirus | Kirovvirus kirov | ||||
| 31212185 | 31212185 | PRJNA385064_P_NODE_4915_length_193_cov_1.493056_g4790_i0 | PRJNA385064 | 4915 | 193 | 1.493056 | 2.88159808 | Bacillus phage vB_BcoS-136 | 2419619 | Viruses | Viruses | 103 | 4.87e-24 | NR | YP_010681548.1 | 2419619 | g4790 | i0 | 75.4 | 0.948186528497409 | 61 | 15 | 94.8 | 0 | 184 | 2 | 203 | 263 | YP_010681548.1 DNA ligase [Bacillus phage vB_BcoS-136] | diamond | 183 | 103 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Kenyattavirus | Kenyattavirus kv136 | ||||
| 31339052 | 31339052 | PRJNA385064_P_NODE_7996_length_161_cov_0.937500_g7871_i0 | PRJNA385064 | 7996 | 161 | 0.9375 | 1.509375 | Bacillus phage vB_BanS_Skywalker | 2894789 | Viruses | Viruses | 69.7 | 7.23e-13 | NR | YP_010680729.1 | 2894789 | g7871 | i0 | 60.4 | 0.987577639751553 | 53 | 21 | 98.8 | 0 | 159 | 1 | 142 | 194 | YP_010680729.1 RuvC-like Holliday junction resolvase [Bacillus phage vB_BanS_Skywalker] | diamond | 159 | 69.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Tsamsavirus | Tsamsavirus skywalker | ||||
| 31356170 | 31356170 | PRJNA385064_P_NODE_5336_length_185_cov_1.125000_g5211_i0 | PRJNA385064 | 5336 | 185 | 1.125 | 2.08125 | Sophritavirus | 3044834 | Viruses | Viruses | 63.5 | 7.91e-10 | NR | YP_010679908.1 | 2894790 | g5211 | i0 | 51 | 1.86486486486486 | 51 | 25 | 82.7 | 0 | 33 | 185 | 466 | 516 | YP_010679908.1 tail fiber protein [Bacillus phage vB_BanS_Sophrita] | diamond | 345 | 63.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Sophritavirus | Sophritavirus sophrita | ||||
| 32698747 | 32698747 | PRJNA385064_P_NODE_4740_length_197_cov_1.054054_g4615_i0 | PRJNA385064 | 4740 | 197 | 1.054054 | 2.07648638 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 54.7 | 1.26e-6 | NR | XOR52690.1 | 2832643 | g4615 | i0 | 60.4 | 0.807106598984772 | 53 | 21 | 80.7 | 0 | 8 | 166 | 285 | 337 | XOR52690.1 MAG: recombination endonuclease subunit [Caudoviricetes sp.] | diamond | 159 | 54.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes 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);;