contig_metadata
22 rows where bioproject = "PRJNA1151638" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2852963 | 2852963 | PRJNA1151638_P_NODE_6403_length_243_cov_2.752941_g6336_i0 | PRJNA1151638 | 6403 | 243 | 2.752941 | 6.68964663 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 267 | 7.19e-67 | NTclustered | gi|2054683533|tpg|BK052657.1| | 2832643 | g6336 | i0 | 90.594 | 3.08230452674897 | 202 | 17 | 83 | 2 | 34 | 234 | 3207 | 3407 | MAG TPA_asm: Caudoviricetes sp. isolate ctIBL2, partial genome | blastn | 749 | 267 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 6679815 | 6679815 | PRJNA1151638_P_NODE_4266_length_262_cov_1.650794_g4199_i0 | PRJNA1151638 | 4266 | 262 | 1.650794 | 4.32508028 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 435 | 2.0300000000000003e-117 | NTclustered | gi|2057046998|tpg|BK049396.1| | 2832643 | g4199 | i0 | 96.565 | 5.01526717557252 | 262 | 9 | 100 | 0 | 1 | 262 | 11059 | 11320 | MAG TPA_asm: Caudoviricetes sp. isolate ctSSL1, partial genome | blastn | 1314 | 435 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 9229897 | 9229897 | PRJNA1151638_P_NODE_2328_length_321_cov_2.475806_g2261_i0 | PRJNA1151638 | 2328 | 321 | 2.475806 | 7.94733726 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 488 | 1.9399999999999996e-133 | NTclustered | gi|2914750556|gb|OR221279.1| | 2832643 | g2261 | i0 | 94.081 | 10.3738317757009 | 321 | 19 | 100 | 0 | 1 | 321 | 30208 | 30528 | MAG: Caudoviricetes sp. isolate MSP1829 genomic sequence | blastn | 3330 | 488 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 9229947 | 9229947 | PRJNA1151638_P_NODE_4408_length_259_cov_1.494624_g4341_i0 | PRJNA1151638 | 4408 | 259 | 1.494624 | 3.87107616 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 315 | 2.72e-81 | NTclustered | gi|2054454799|tpg|BK031399.1| | 2832643 | g4341 | i0 | 88.603 | 7.74517374517375 | 272 | 14 | 99 | 9 | 2 | 259 | 1735 | 1467 | MAG TPA_asm: Caudoviricetes sp. isolate ct2dy1, partial genome | blastn | 2006 | 315 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 13055586 | 13055586 | PRJNA1151638_P_NODE_3331_length_284_cov_1.478673_g3264_i0 | PRJNA1151638 | 3331 | 284 | 1.478673 | 4.19943132 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 255 | 1.86e-63 | NTclustered | gi|2053090150|tpg|BK020282.1| | 2832643 | g3264 | i0 | 96.732 | 1.54929577464789 | 153 | 5 | 54 | 0 | 1 | 153 | 41839 | 41991 | MAG TPA_asm: Caudoviricetes sp. isolate ct1BD1, partial genome | blastn | 440 | 255 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14330927 | 14330927 | PRJNA1151638_P_NODE_3552_length_278_cov_1.521951_g3485_i0 | PRJNA1151638 | 3552 | 278 | 1.521951 | 4.23102378 | Pahexavirus P100D | 1982266 | Viruses | Viruses | 481 | 2.75e-131 | NTclustered | gi|408905847|ref|NC_018852.1| | 1229789 | g3485 | i0 | 97.842 | 99.9748201438849 | 278 | 6 | 100 | 0 | 1 | 278 | 27696 | 27973 | Propionibacterium phage P100D, complete genome | blastn | 27793 | 481 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Pahexavirus P100D | ||||
| 15604762 | 15604762 | PRJNA1151638_P_NODE_3373_length_283_cov_1.485714_g3306_i0 | PRJNA1151638 | 3373 | 283 | 1.485714 | 4.20457062 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 320 | 6.48e-83 | NTclustered | gi|2053090150|tpg|BK020282.1| | 2832643 | g3306 | i0 | 87.636 | 4.80918727915194 | 275 | 34 | 97 | 0 | 9 | 283 | 17696 | 17422 | MAG TPA_asm: Caudoviricetes sp. isolate ct1BD1, partial genome | blastn | 1361 | 320 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 20703301 | 20703301 | PRJNA1151638_P_NODE_1117_length_429_cov_7.443820_g1050_i0 | PRJNA1151638 | 1117 | 429 | 7.44382 | 31.9339878 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 52.8 | 0.041 | NTclustered | gi|2054791230|tpg|BK049928.1| | 2832643 | g1050 | i0 | 100 | 0.0652680652680653 | 28 | 0 | 7 | 0 | 375 | 402 | 1569 | 1596 | MAG TPA_asm: Caudoviricetes sp. isolate ctwKx1, partial genome | blastn | 28 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 20703302 | 20703302 | PRJNA1151638_P_NODE_1157_length_421_cov_2.152299_g1090_i0 | PRJNA1151638 | 1157 | 421 | 2.152299 | 9.06117879 | Sepunavirus SEP1 | 1980930 | Viruses | Viruses | 235 | 3.75e-57 | NTclustered | gi|1631923064|ref|NC_041928.1| | 1340769 | g1090 | i0 | 79.819 | 7.05225653206651 | 332 | 59 | 78 | 6 | 94 | 421 | 58338 | 58665 | Staphylococcus phage phiIBB-SEP1, complete genome | blastn | 2969 | 235 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Herelleviridae | Sepunavirus | Sepunavirus SEP1 | |||
| 23254247 | 23254247 | PRJNA1151638_P_NODE_4779_length_253_cov_0.866667_g4712_i0 | PRJNA1151638 | 4779 | 253 | 0.866667 | 2.19266751 | Zhangqianvirus IME1354 | 3060827 | Viruses | Viruses | 361 | 3.36e-95 | NTclustered | gi|2437990282|ref|NC_070727.1| | 3070820 | g4712 | i0 | 95.556 | 9.4703557312253 | 225 | 10 | 89 | 0 | 29 | 253 | 42273 | 42049 | Staphylococcus phage IME1354_01, complete genome | blastn | 2396 | 361 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Zhangqianvirus | Zhangqianvirus IME1354 | ||||
| 23989220 | 23989220 | PRJNA1151638_P_NODE_6419_length_243_cov_1.952941_g6352_i0 | PRJNA1151638 | 6419 | 243 | 1.952941 | 4.74564663 | root | 1 | Root_unresolved | Root_unresolved | 342 | 1.16e-89 | NTclustered | gi|2054683533|tpg|BK052657.1| | 2832643 | g6352 | i0 | 92.887 | 9.51028806584362 | 239 | 12 | 98 | 4 | 5 | 243 | 4341 | 4574 | MAG TPA_asm: Caudoviricetes sp. isolate ctIBL2, partial genome | blastn | 2311 | 342 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 24527980 | 24527980 | PRJNA1151638_P_NODE_6920_length_236_cov_2.325153_g6853_i0 | PRJNA1151638 | 6920 | 236 | 2.325153 | 5.48736108 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 303 | 5.29e-78 | NTclustered | gi|2057123275|tpg|BK057999.1| | 2832643 | g6853 | i0 | 89.831 | 4.46610169491525 | 236 | 24 | 100 | 0 | 1 | 236 | 817 | 1052 | MAG TPA_asm: Caudoviricetes sp. isolate ctSjB4, partial genome | blastn | 1054 | 303 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 26850607 | 26850607 | PRJNA1151638_P_NODE_1361_length_392_cov_1.467085_g1294_i0 | PRJNA1151638 | 1361 | 392 | 1.467085 | 5.7509732 | Geobacillus phage vB_GthS_PK3.6 | 2985565 | Viruses | Viruses | 172 | 4.95e-51 | NR | UYL94016.1 | 2985565 | g1294 | i0 | 67.2 | 3.65051020408163 | 119 | 39 | 91.1 | 0 | 374 | 18 | 84 | 202 | UYL94016.1 hypothetical protein PK36_gp44 [Geobacillus phage vB_GthS_PK3.6] | diamond | 1431 | 172 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Geobacillus phage vB_GthS_PK3.6 | |||||
| 27640735 | 27640735 | PRJNA1151638_P_NODE_444_length_650_cov_2.006932_g378_i0 | PRJNA1151638 | 444 | 650 | 2.006932 | 13.045058 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 61.6 | 8.21e-9 | NR | DAN20154.1 | 2832643 | g378 | i0 | 61.9 | 0.387692307692308 | 42 | 16 | 19.4 | 0 | 525 | 650 | 1 | 42 | DAN20154.1 MAG TPA: glutaredoxin-like protein [Caudoviricetes sp.] | diamond | 252 | 61.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28430037 | 28430037 | PRJNA1151638_P_NODE_4106_length_265_cov_2.390625_g4039_i0 | PRJNA1151638 | 4106 | 265 | 2.390625 | 6.33515625 | Rhodococcus phage NiceHouse | 2743998 | Viruses | Viruses | 102 | 5.6999999999999995e-25 | NR | QLF83277.1 | 2743998 | g4039 | i0 | 51.7 | 0.984905660377358 | 87 | 40 | 96.2 | 1 | 262 | 8 | 12 | 98 | QLF83277.1 tRNA-methyltransferase [Rhodococcus phage NiceHouse] | diamond | 261 | 102 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Trinavirus | Rhodococcus phage NiceHouse | ||||
| 28871869 | 28871869 | PRJNA1151638_P_NODE_3428_length_281_cov_2.802885_g3361_i0 | PRJNA1151638 | 3428 | 281 | 2.802885 | 7.87610685 | Staphylococcus phage PMBT8 | 2590894 | Viruses | Viruses | 43.9 | 0.0213 | NR | QDF14352.1 | 2590894 | g3361 | i0 | 36.4 | 0.822064056939502 | 77 | 44 | 82.2 | 2 | 6 | 236 | 191 | 262 | QDF14352.1 hypothetical protein [Staphylococcus phage PMBT8] | diamond | 231 | 43.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Sextaecvirus | Staphylococcus phage PMBT8 | ||||
| 29629351 | 29629351 | PRJNA1151638_P_NODE_2910_length_296_cov_2.358744_g2843_i0 | PRJNA1151638 | 2910 | 296 | 2.358744 | 6.98188224 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 56.6 | 8.43e-7 | NR | DAG71531.1 | 2832643 | g2843 | i0 | 42.4 | 0.597972972972973 | 59 | 31 | 59.8 | 1 | 220 | 44 | 4 | 59 | DAG71531.1 MAG TPA: type-1 restriction enzyme [Caudoviricetes sp.] | diamond | 177 | 56.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30261709 | 30261709 | PRJNA1151638_P_NODE_4372_length_260_cov_1.251337_g4305_i0 | PRJNA1151638 | 4372 | 260 | 1.251337 | 3.2534762 | Burkholderia phage BCSR5 | 2805747 | Viruses | Viruses | 66.6 | 1.73e-10 | NR | QRE00205.1 | 2805747 | g4305 | i0 | 41.7 | 0.830769230769231 | 72 | 42 | 83.1 | 0 | 31 | 246 | 4 | 75 | QRE00205.1 hypothetical protein [Burkholderia phage BCSR5] | diamond | 216 | 66.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Burkholderia phage BCSR5 | |||||
| 30482687 | 30482687 | PRJNA1151638_P_NODE_2153_length_330_cov_2.112840_g2086_i0 | PRJNA1151638 | 2153 | 330 | 2.11284 | 6.972372 | Herelleviridae sp. | 2831613 | Viruses | Viruses | 79.7 | 8.73e-16 | NR | DAN11154.1 | 2831613 | g2086 | i0 | 43.3 | 1.62727272727273 | 90 | 45 | 80 | 2 | 48 | 311 | 1 | 86 | DAN11154.1 MAG TPA: hypothetical protein [Herelleviridae sp.] | diamond | 537 | 79.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Herelleviridae | Herelleviridae sp. | ||||
| 31841745 | 31841745 | PRJNA1151638_P_NODE_6037_length_245_cov_1.767442_g5970_i0 | PRJNA1151638 | 6037 | 245 | 1.767442 | 4.3302329 | Rhodococcus phage Grayson | 2182359 | Viruses | Viruses | 49.7 | 1.07e-4 | NR | AWN04495.1 | 2182359 | g5970 | i0 | 33.9 | 0.759183673469388 | 62 | 38 | 75.9 | 1 | 207 | 22 | 180 | 238 | AWN04495.1 hypothetical protein PBI_GRAYSON_166 [Rhodococcus phage Grayson] | diamond | 186 | 49.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Weaselvirus | Rhodococcus phage Grayson | ||||
| 32474925 | 32474925 | PRJNA1151638_P_NODE_1519_length_375_cov_2.923841_g1452_i0 | PRJNA1151638 | 1519 | 375 | 2.923841 | 10.96440375 | Rhodococcus phage NiceHouse | 2743998 | Viruses | Viruses | 98.6 | 7.31e-23 | NR | QLF83277.1 | 2743998 | g1452 | i0 | 52.2 | 0.736 | 92 | 42 | 72 | 2 | 13 | 282 | 106 | 197 | QLF83277.1 tRNA-methyltransferase [Rhodococcus phage NiceHouse] | diamond | 276 | 98.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Trinavirus | Rhodococcus phage NiceHouse | ||||
| 32695477 | 32695477 | PRJNA1151638_P_NODE_5320_length_249_cov_1.795455_g5253_i0 | PRJNA1151638 | 5320 | 249 | 1.795455 | 4.47068295 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 43.1 | 0.00619 | NR | DAV51079.1 | 2832643 | g5253 | i0 | 60 | 0.36144578313253 | 30 | 12 | 36.1 | 0 | 122 | 33 | 23 | 52 | DAV51079.1 MAG TPA: AcrIIC3 protein [Caudoviricetes sp.] | diamond | 90 | 43.1 | 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);;