contig_metadata
30 rows where bioproject = "PRJNA993416" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4803834 | 4803834 | PRJNA993416_P_NODE_4104_length_416_cov_1.346939_g3999_i0 | PRJNA993416 | 4104 | 416 | 1.346939 | 5.60326624 | Herelleviridae sp. | 2831613 | Viruses | Viruses | 664 | 0 | NTclustered | gi|2053201771|tpg|BK035244.1| | 2831613 | g3999 | i0 | 95.433 | 1 | 416 | 19 | 100 | 0 | 1 | 416 | 6748 | 6333 | MAG TPA_asm: Herelleviridae sp. isolate ctpkF3, partial genome | blastn | 416 | 664 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Herelleviridae | Herelleviridae sp. | ||||
| 4803926 | 4803926 | PRJNA993416_P_NODE_7844_length_294_cov_1.307692_g7739_i0 | PRJNA993416 | 7844 | 294 | 1.307692 | 3.84461448 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 481 | 2.94e-131 | NTclustered | gi|2053050829|tpg|BK024457.1| | 2832643 | g7739 | i0 | 97.518 | 0.959183673469388 | 282 | 5 | 96 | 2 | 1 | 281 | 7473 | 7753 | MAG TPA_asm: Caudoviricetes sp. isolate ctsQV1, partial genome | blastn | 282 | 481 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 5101191 | 5101191 | PRJNA993416_P_NODE_7924_length_292_cov_2.041096_g7819_i0 | PRJNA993416 | 7924 | 292 | 2.041096 | 5.96000032 | Viruses | 10239 | Viruses | Viruses | 438 | 1.7799999999999999e-118 | NTclustered | gi|2053201771|tpg|BK035244.1| | 2831613 | g7819 | i0 | 94.138 | 2.95890410958904 | 290 | 13 | 99 | 3 | 1 | 288 | 19538 | 19825 | MAG TPA_asm: Herelleviridae sp. isolate ctpkF3, partial genome | blastn | 864 | 438 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Herelleviridae | Herelleviridae sp. | ||||
| 6078983 | 6078983 | PRJNA993416_P_NODE_11505_length_260_cov_1.235294_g11400_i0 | PRJNA993416 | 11505 | 260 | 1.235294 | 3.2117644 | Herelleviridae sp. | 2831613 | Viruses | Viruses | 392 | 1.2299999999999999e-104 | NTclustered | gi|2053201771|tpg|BK035244.1| | 2831613 | g11400 | i0 | 93.846 | 3.92692307692308 | 260 | 16 | 100 | 0 | 1 | 260 | 18915 | 18656 | MAG TPA_asm: Herelleviridae sp. isolate ctpkF3, partial genome | blastn | 1021 | 392 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Herelleviridae | Herelleviridae sp. | ||||
| 6079019 | 6079019 | PRJNA993416_P_NODE_13325_length_249_cov_0.875000_g13220_i0 | PRJNA993416 | 13325 | 249 | 0.875 | 2.17875 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 237 | 5.8e-58 | NTclustered | gi|2915005496|gb|OR222380.1| | 2832643 | g13220 | i0 | 88.442 | 2.05220883534137 | 199 | 19 | 80 | 3 | 1 | 198 | 4881 | 4686 | MAG: Caudoviricetes sp. isolate MSP1018 genomic sequence | blastn | 511 | 237 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 7353750 | 7353750 | PRJNA993416_P_NODE_7206_length_309_cov_1.305085_g7101_i0 | PRJNA993416 | 7206 | 309 | 1.305085 | 4.03271265 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 257 | 5.7e-64 | NTclustered | gi|2053050829|tpg|BK024457.1| | 2832643 | g7101 | i0 | 86.498 | 0.766990291262136 | 237 | 28 | 76 | 3 | 33 | 267 | 16337 | 16571 | MAG TPA_asm: Caudoviricetes sp. isolate ctsQV1, partial genome | blastn | 237 | 257 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 8628801 | 8628801 | PRJNA993416_P_NODE_12627_length_250_cov_4.112994_g12522_i0 | PRJNA993416 | 12627 | 250 | 4.112994 | 10.282485 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 344 | 3.34e-90 | NTclustered | gi|2914944268|gb|OR221794.1| | 2832643 | g12522 | i0 | 95.775 | 1.62 | 213 | 9 | 85 | 0 | 2 | 214 | 30769 | 30981 | MAG: Caudoviricetes sp. isolate MSP1228 genomic sequence | blastn | 405 | 344 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 8628834 | 8628834 | PRJNA993416_P_NODE_14047_length_247_cov_0.885057_g13942_i0 | PRJNA993416 | 14047 | 247 | 0.885057 | 2.18609079 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 165 | 2.75e-36 | NTclustered | gi|2054449890|tpg|BK031292.1| | 2832643 | g13942 | i0 | 85.806 | 6.89878542510121 | 155 | 22 | 63 | 0 | 93 | 247 | 18385 | 18231 | MAG TPA_asm: Caudoviricetes sp. isolate ctbDe2, partial genome | blastn | 1704 | 165 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 8628872 | 8628872 | PRJNA993416_P_NODE_16227_length_241_cov_0.916667_g16122_i0 | PRJNA993416 | 16227 | 241 | 0.916667 | 2.20916747 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 86.7 | 7.53e-19 | NR | XOR51512.1 | 2832643 | g16122 | i0 | 56 | 0.933609958506224 | 75 | 31 | 90.9 | 1 | 8 | 226 | 46 | 120 | XOR51512.1 MAG: thymidylate kinase [Caudoviricetes sp.] | diamond | 225 | 86.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 9903939 | 9903939 | PRJNA993416_P_NODE_10788_length_267_cov_1.190722_g10683_i0 | PRJNA993416 | 10788 | 267 | 1.190722 | 3.17922774 | Herelleviridae sp. | 2831613 | Viruses | Viruses | 377 | 3.55e-100 | NTclustered | gi|2053201771|tpg|BK035244.1| | 2831613 | g10683 | i0 | 92.135 | 1.59550561797753 | 267 | 21 | 100 | 0 | 1 | 267 | 7395 | 7129 | MAG TPA_asm: Herelleviridae sp. isolate ctpkF3, partial genome | blastn | 426 | 377 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Herelleviridae | Herelleviridae sp. | ||||
| 9903963 | 9903963 | PRJNA993416_P_NODE_12248_length_252_cov_1.284916_g12143_i0 | PRJNA993416 | 12248 | 252 | 1.284916 | 3.23798832 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 281 | 2.68e-71 | NTclustered | gi|2054565022|tpg|BK048322.1| | 2832643 | g12143 | i0 | 91.626 | 4.13095238095238 | 203 | 17 | 81 | 0 | 50 | 252 | 14437 | 14639 | MAG TPA_asm: Caudoviricetes sp. isolate ctfHV29, partial genome | blastn | 1041 | 281 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 9904231 | 9904231 | PRJNA993416_P_NODE_9788_length_276_cov_1.517241_g9683_i0 | PRJNA993416 | 9788 | 276 | 1.517241 | 4.18758516 | Inoviridae sp. | 2219103 | Viruses | Viruses | 438 | 1.6699999999999996e-118 | NTclustered | gi|2053040871|tpg|BK024249.1| | 2219103 | g9683 | i0 | 95.29 | 97.2355072463768 | 276 | 13 | 100 | 0 | 1 | 276 | 1758 | 1483 | MAG TPA_asm: Inoviridae sp. isolate ct4CW1, partial genome | blastn | 26837 | 438 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 11179350 | 11179350 | PRJNA993416_P_NODE_7729_length_297_cov_1.031250_g7624_i0 | PRJNA993416 | 7729 | 297 | 1.03125 | 3.0628125 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 411 | 3.949999999999999e-110 | NTclustered | gi|2059972000|tpg|BK025717.1| | 2832643 | g7624 | i0 | 91.582 | 1 | 297 | 25 | 100 | 0 | 1 | 297 | 35240 | 34944 | MAG TPA_asm: Caudoviricetes sp. isolate ctfMI5, partial genome | blastn | 297 | 411 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 13729342 | 13729342 | PRJNA993416_P_NODE_13431_length_248_cov_1.320000_g13326_i0 | PRJNA993416 | 13431 | 248 | 1.32 | 3.2736 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 431 | 2.47e-116 | NTclustered | gi|2050465289|tpg|BK029942.1| | 2832643 | g13326 | i0 | 97.984 | 5 | 248 | 5 | 100 | 0 | 1 | 248 | 8360 | 8113 | MAG TPA_asm: Caudoviricetes sp. isolate ctcP916, partial genome | blastn | 1240 | 431 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 13729474 | 13729474 | PRJNA993416_P_NODE_4571_length_392_cov_1.206897_g4466_i0 | PRJNA993416 | 4571 | 392 | 1.206897 | 4.73103624 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 564 | 3.89e-156 | NTclustered | gi|2053050829|tpg|BK024457.1| | 2832643 | g4466 | i0 | 92.602 | 1.09948979591837 | 392 | 29 | 100 | 0 | 1 | 392 | 9002 | 9393 | MAG TPA_asm: Caudoviricetes sp. isolate ctsQV1, partial genome | blastn | 431 | 564 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 15300804 | 15300804 | PRJNA993416_P_NODE_2572_length_536_cov_1.291577_g2468_i0 | PRJNA993416 | 2572 | 536 | 1.291577 | 6.92285272 | Sepunavirus | 1980928 | Viruses | Viruses | 985 | 0 | NTclustered | gi|971761109|ref|NC_028962.1| | 1572704 | g2468 | i0 | 99.813 | 41.5746268656716 | 536 | 1 | 100 | 0 | 1 | 536 | 215 | 750 | Staphylococcus phage phiIPLA-C1C, complete genome | blastn | 22284 | 985 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Herelleviridae | Sepunavirus | Sepunavirus IPLAC1C | |||
| 16278651 | 16278651 | PRJNA993416_P_NODE_14193_length_246_cov_0.890173_g14088_i0 | PRJNA993416 | 14193 | 246 | 0.890173 | 2.18982558 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 427 | 3.16e-115 | NTclustered | gi|2915040272|gb|OR222728.1| | 2832643 | g14088 | i0 | 97.967 | 1 | 246 | 5 | 100 | 0 | 1 | 246 | 25140 | 25385 | MAG: Caudoviricetes sp. isolate MSP0637 genomic sequence | blastn | 246 | 427 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18827535 | 18827535 | PRJNA993416_P_NODE_11835_length_256_cov_1.683060_g11730_i0 | PRJNA993416 | 11835 | 256 | 1.68306 | 4.3086336 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 239 | 1.66e-58 | NTclustered | gi|2914851513|gb|OR221600.1| | 2832643 | g11730 | i0 | 83.658 | 1.984375 | 257 | 38 | 99 | 3 | 1 | 255 | 2942 | 2688 | MAG: Caudoviricetes sp. isolate MSP1454 genomic sequence | blastn | 508 | 239 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18827598 | 18827598 | PRJNA993416_P_NODE_14875_length_244_cov_1.801170_g14770_i0 | PRJNA993416 | 14875 | 244 | 1.80117 | 4.3948548 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 446 | 8.639999999999999e-121 | NTclustered | gi|2915040272|gb|OR222728.1| | 2832643 | g14770 | i0 | 99.59 | 1 | 244 | 1 | 100 | 0 | 1 | 244 | 53468 | 53225 | MAG: Caudoviricetes sp. isolate MSP0637 genomic sequence | blastn | 244 | 446 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18827810 | 18827810 | PRJNA993416_P_NODE_9415_length_279_cov_1.674757_g9310_i0 | PRJNA993416 | 9415 | 279 | 1.674757 | 4.67257203 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 268 | 2.3399999999999994e-67 | NTclustered | gi|2914754352|gb|OR221458.1| | 2832643 | g9310 | i0 | 91.71 | 2.22939068100358 | 193 | 16 | 69 | 0 | 87 | 279 | 27234 | 27042 | MAG: Caudoviricetes sp. isolate MSP1621 genomic sequence | blastn | 622 | 268 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 25202151 | 25202151 | PRJNA993416_P_NODE_8300_length_288_cov_2.474419_g8195_i0 | PRJNA993416 | 8300 | 288 | 2.474419 | 7.12632672 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 521 | 1.69e-143 | NTclustered | gi|2057142308|tpg|BK058336.1| | 2832643 | g8195 | i0 | 99.306 | 6.03125 | 288 | 2 | 100 | 0 | 1 | 288 | 17499 | 17212 | MAG TPA_asm: Caudoviricetes sp. isolate ctFgw7, partial genome | blastn | 1737 | 521 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 26905815 | 26905815 | PRJNA993416_P_NODE_16281_length_241_cov_0.916667_g16176_i0 | PRJNA993416 | 16281 | 241 | 0.916667 | 2.20916747 | root | 1 | Root_unresolved | Root_unresolved | 50.4 | 2.53e-5 | NR | YP_006988261.1 | 1211640 | g16176 | i0 | 39.5 | 4.87966804979253 | 76 | 43 | 94.6 | 1 | 12 | 239 | 33 | 105 | YP_006988261.1 hypothetical protein CcrColossus_gp027 [Caulobacter phage CcrColossus] | diamond | 1176 | 50.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Jeanschmidtviridae | Colossusvirus | Colossusvirus colossus | |||
| 26963005 | 26963005 | PRJNA993416_P_NODE_5542_length_355_cov_1.911348_g5437_i0 | PRJNA993416 | 5542 | 355 | 1.911348 | 6.7852854 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 43.9 | 0.00709 | NR | DAI46203.1 | 2832643 | g5437 | i0 | 32.9 | 0.591549295774648 | 70 | 42 | 59.2 | 1 | 215 | 6 | 1 | 65 | DAI46203.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] | diamond | 210 | 43.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28447866 | 28447866 | PRJNA993416_P_NODE_606_length_995_cov_1.658351_g531_i0 | PRJNA993416 | 606 | 995 | 1.658351 | 16.50059245 | uncultured marine virus | 186617 | Viruses | Viruses | 130 | 4.75e-34 | NR | AKH48730.1 | 186617 | g531 | i0 | 61.1 | 0.57286432160804 | 95 | 35 | 28.6 | 1 | 928 | 644 | 1 | 93 | AKH48730.1 hypothetical protein [uncultured marine virus] | diamond | 570 | 130 | 1 | Viruses | uncultured marine virus | ||||||||
| 28573905 | 28573905 | PRJNA993416_P_NODE_11547_length_259_cov_1.655914_g11442_i0 | PRJNA993416 | 11547 | 259 | 1.655914 | 4.28881726 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 140 | 3.17e-40 | NR | DAQ80072.1 | 2832643 | g11442 | i0 | 84.6 | 0.903474903474903 | 78 | 12 | 90.3 | 0 | 255 | 22 | 111 | 188 | DAQ80072.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] | diamond | 234 | 140 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29521172 | 29521172 | PRJNA993416_P_NODE_12910_length_250_cov_0.870056_g12805_i0 | PRJNA993416 | 12910 | 250 | 0.870056 | 2.17514 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 77 | 1.41e-15 | NR | DAQ64683.1 | 2832643 | g12805 | i0 | 50 | 0.912 | 76 | 35 | 91.2 | 1 | 23 | 250 | 20 | 92 | DAQ64683.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] | diamond | 228 | 77 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30469063 | 30469063 | PRJNA993416_P_NODE_10013_length_274_cov_1.393035_g9908_i0 | PRJNA993416 | 10013 | 274 | 1.393035 | 3.8169159 | Sylvanvirus sp. | 2487774 | Viruses | Viruses | 82.4 | 6.1e-16 | NR | AYV87083.1 | 2487774 | g9908 | i0 | 44.3 | 0.963503649635037 | 88 | 49 | 96.4 | 0 | 265 | 2 | 499 | 586 | AYV87083.1 MAG: putative RNA helicase SDE3 [Sylvanvirus sp.] | diamond | 264 | 82.4 | 1 | Viruses | Sylvanvirus sp. | ||||||||
| 32112942 | 32112942 | PRJNA993416_P_NODE_15038_length_244_cov_0.900585_g14933_i0 | PRJNA993416 | 15038 | 244 | 0.900585 | 2.1974274 | Pseudomonas phage KP1 | 2562463 | Viruses | Viruses | 119 | 5.65e-29 | NR | YP_010597331.1 | 2562463 | g14933 | i0 | 72.5 | 2.93852459016393 | 80 | 22 | 98.4 | 0 | 3 | 242 | 73 | 152 | YP_010597331.1 hypothetical protein PM391_gp33 [Pseudomonas phage KP1] | diamond | 717 | 119 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Kipunavirus | Kipunavirus KP1 | ||||
| 32681540 | 32681540 | PRJNA993416_P_NODE_10600_length_268_cov_2.097436_g10495_i0 | PRJNA993416 | 10600 | 268 | 2.097436 | 5.62112848 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 80.1 | 2.93e-15 | NR | DAL31101.1 | 2832643 | g10495 | i0 | 50 | 0.985074626865672 | 88 | 41 | 96.3 | 3 | 258 | 1 | 287 | 373 | DAL31101.1 MAG TPA_asm: DNA encapsidation protein [Caudoviricetes sp.] | diamond | 264 | 80.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32713258 | 32713258 | PRJNA993416_P_NODE_10080_length_273_cov_1.540000_g9975_i0 | PRJNA993416 | 10080 | 273 | 1.54 | 4.2042 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 75.1 | 1.43e-13 | NR | XCI66020.1 | 2832643 | g9975 | i0 | 52.6 | 0.835164835164835 | 76 | 36 | 83.5 | 0 | 228 | 1 | 42 | 117 | XCI66020.1 MAG: DnaB-like replicative helicase [Caudoviricetes sp.] | diamond | 228 | 75.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);;