contig_metadata
27 rows where analysis = "blastn", bioproject = "PRJNA1022139" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 161512 | 161512 | PRJNA1022139_P_NODE_13041_length_375_cov_1.135762_g12936_i0 | PRJNA1022139 | 13041 | 375 | 1.135762 | 4.2591075 | Bacteriophage sp. | 38018 | Viruses | Viruses | 86.1 | 3.52e-12 | NTclustered | gi|2059756262|tpg|BK028004.1| | 38018 | g12936 | i0 | 96.154 | 0.48 | 52 | 2 | 14 | 0 | 130 | 181 | 39316 | 39265 | MAG TPA_asm: Bacteriophage sp. isolate ctd1f15, partial genome | blastn | 180 | 86.1 | 1 | Viruses | Bacteriophage sp. | ||||||||
| 161788 | 161788 | PRJNA1022139_P_NODE_8681_length_448_cov_3.490667_g8576_i0 | PRJNA1022139 | 8681 | 448 | 3.490667 | 15.63818816 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 348 | 4.940000000000001e-91 | NTclustered | gi|2053078945|tpg|BK020046.1| | 2832643 | g8576 | i0 | 81.046 | 1.02455357142857 | 459 | 68 | 100 | 15 | 1 | 448 | 14940 | 15390 | MAG TPA_asm: Caudoviricetes sp. isolate ctKcv1, partial genome | blastn | 459 | 348 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 2278766 | 2278766 | PRJNA1022139_P_NODE_41002_length_243_cov_0.905882_g40897_i0 | PRJNA1022139 | 41002 | 243 | 0.905882 | 2.20129326 | Viruses | 10239 | Viruses | Viruses | 52.8 | 0.022 | NTclustered | gi|2052868870|tpg|BK032591.1| | 2827975 | g40897 | i0 | 100 | 0.576131687242798 | 28 | 0 | 12 | 0 | 30 | 57 | 19157 | 19130 | MAG TPA_asm: Siphoviridae sp. ctxvK3, partial genome | blastn | 140 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Siphoviridae sp. ctxvK3 | |||||
| 2711890 | 2711890 | PRJNA1022139_P_NODE_11143_length_401_cov_1.618902_g11038_i0 | PRJNA1022139 | 11143 | 401 | 1.618902 | 6.49179702 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 603 | 8.459999999999999e-168 | NTclustered | gi|2053078945|tpg|BK020046.1| | 2832643 | g11038 | i0 | 93.781 | 1.08229426433915 | 402 | 23 | 100 | 2 | 1 | 401 | 16164 | 16564 | MAG TPA_asm: Caudoviricetes sp. isolate ctKcv1, partial genome | blastn | 434 | 603 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 2711985 | 2711985 | PRJNA1022139_P_NODE_21983_length_299_cov_1.362832_g21878_i0 | PRJNA1022139 | 21983 | 299 | 1.362832 | 4.07486768 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 547 | 2.9099999999999987e-151 | NTclustered | gi|2053078945|tpg|BK020046.1| | 2832643 | g21878 | i0 | 99.666 | 1 | 299 | 1 | 100 | 0 | 1 | 299 | 17410 | 17112 | MAG TPA_asm: Caudoviricetes sp. isolate ctKcv1, partial genome | blastn | 299 | 547 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 2712056 | 2712056 | PRJNA1022139_P_NODE_3003_length_722_cov_2.848998_g2906_i0 | PRJNA1022139 | 3003 | 722 | 2.848998 | 20.56976556 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 981 | 0 | NTclustered | gi|2053078945|tpg|BK020046.1| | 2832643 | g2906 | i0 | 91.401 | 1.99861495844875 | 721 | 54 | 99 | 6 | 6 | 722 | 7849 | 8565 | MAG TPA_asm: Caudoviricetes sp. isolate ctKcv1, partial genome | blastn | 1443 | 981 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 2712147 | 2712147 | PRJNA1022139_P_NODE_40143_length_244_cov_1.175439_g40038_i0 | PRJNA1022139 | 40143 | 244 | 1.175439 | 2.86807116 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 396 | 8.829999999999997e-106 | NTclustered | gi|2915008907|gb|OR222427.1| | 2832643 | g40038 | i0 | 96.266 | 1.10245901639344 | 241 | 9 | 99 | 0 | 1 | 241 | 13401 | 13641 | MAG: Caudoviricetes sp. isolate MSP0968 genomic sequence | blastn | 269 | 396 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 3988133 | 3988133 | PRJNA1022139_P_NODE_12184_length_385_cov_2.679487_g12079_i0 | PRJNA1022139 | 12184 | 385 | 2.679487 | 10.31602495 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 235 | 3.3999999999999996e-57 | NTclustered | gi|2053078945|tpg|BK020046.1| | 2832643 | g12079 | i0 | 97.794 | 0.771428571428571 | 136 | 3 | 35 | 0 | 2 | 137 | 6910 | 7045 | MAG TPA_asm: Caudoviricetes sp. isolate ctKcv1, partial genome | blastn | 297 | 235 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 3988374 | 3988374 | PRJNA1022139_P_NODE_5084_length_572_cov_1.823647_g4980_i0 | PRJNA1022139 | 5084 | 572 | 1.823647 | 10.43126084 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 593 | 7.479999999999998e-165 | NTclustered | gi|2053078945|tpg|BK020046.1| | 2832643 | g4980 | i0 | 85.439 | 0.996503496503496 | 570 | 83 | 99 | 0 | 1 | 570 | 13996 | 13427 | MAG TPA_asm: Caudoviricetes sp. isolate ctKcv1, partial genome | blastn | 570 | 593 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 7814199 | 7814199 | PRJNA1022139_P_NODE_22667_length_295_cov_1.157658_g22562_i0 | PRJNA1022139 | 22667 | 295 | 1.157658 | 3.4150911 | Micromonas commoda virus | 3057169 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|2835088474|gb|PQ381123.1| | 3057169 | g22562 | i0 | 100 | 0.101694915254237 | 30 | 0 | 10 | 0 | 255 | 284 | 55044 | 55073 | Micromonas commoda virus isolate McV-SA1, partial genome | blastn | 30 | 56.5 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Algavirales | Phycodnaviridae | Micromonas commoda virus | |||
| 9089136 | 9089136 | PRJNA1022139_P_NODE_15568_length_348_cov_1.221818_g15463_i0 | PRJNA1022139 | 15568 | 348 | 1.221818 | 4.25192664 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 385 | 2.86e-102 | NTclustered | gi|2053078945|tpg|BK020046.1| | 2832643 | g15463 | i0 | 89.735 | 1.73563218390805 | 302 | 29 | 86 | 2 | 1 | 301 | 2431 | 2731 | MAG TPA_asm: Caudoviricetes sp. isolate ctKcv1, partial genome | blastn | 604 | 385 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 9089214 | 9089214 | PRJNA1022139_P_NODE_27748_length_275_cov_1.381188_g27643_i0 | PRJNA1022139 | 27748 | 275 | 1.381188 | 3.798267 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 313 | 1.05e-80 | NTclustered | gi|2053078945|tpg|BK020046.1| | 2832643 | g27643 | i0 | 90.119 | 0.92 | 253 | 8 | 86 | 9 | 40 | 275 | 16120 | 16372 | MAG TPA_asm: Caudoviricetes sp. isolate ctKcv1, partial genome | blastn | 253 | 313 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 9089266 | 9089266 | PRJNA1022139_P_NODE_33528_length_253_cov_1.711111_g33423_i0 | PRJNA1022139 | 33528 | 253 | 1.711111 | 4.32911083 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 396 | 9.209999999999997e-106 | NTclustered | gi|2059798693|tpg|BK039666.1| | 2832643 | g33423 | i0 | 94.862 | 1 | 253 | 13 | 100 | 0 | 1 | 253 | 20607 | 20355 | MAG TPA_asm: Caudoviricetes sp. isolate ctWdx1, partial genome | blastn | 253 | 396 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 10365001 | 10365001 | PRJNA1022139_P_NODE_7689_length_474_cov_1.344140_g7584_i0 | PRJNA1022139 | 7689 | 474 | 1.34414 | 6.3712236 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 481 | 4.96e-131 | NTclustered | gi|2053078945|tpg|BK020046.1| | 2832643 | g7584 | i0 | 88.608 | 1.27426160337553 | 395 | 45 | 83 | 0 | 1 | 395 | 11726 | 12120 | MAG TPA_asm: Caudoviricetes sp. isolate ctKcv1, partial genome | blastn | 604 | 481 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11640293 | 11640293 | PRJNA1022139_P_NODE_36610_length_249_cov_0.875000_g36505_i0 | PRJNA1022139 | 36610 | 249 | 0.875 | 2.17875 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 316 | 7.239999999999998e-82 | NTclustered | gi|2915046741|gb|OR222803.1| | 2832643 | g36505 | i0 | 90.535 | 48.0080321285141 | 243 | 18 | 96 | 5 | 1 | 240 | 54179 | 54419 | MAG: Caudoviricetes sp. isolate MSP0553 genomic sequence | blastn | 11954 | 316 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11640296 | 11640296 | PRJNA1022139_P_NODE_36770_length_248_cov_1.760000_g36665_i0 | PRJNA1022139 | 36770 | 248 | 1.76 | 4.3648 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 324 | 4.31e-84 | NTclustered | gi|2914786721|gb|OR222583.1| | 2832643 | g36665 | i0 | 90.283 | 8.35887096774194 | 247 | 24 | 99 | 0 | 2 | 248 | 45240 | 45486 | MAG: Caudoviricetes sp. isolate MSP0353 genomic sequence | blastn | 2073 | 324 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14190432 | 14190432 | PRJNA1022139_P_NODE_6652_length_508_cov_1.666667_g6547_i0 | PRJNA1022139 | 6652 | 508 | 1.666667 | 8.46666836 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 939 | 0 | NTclustered | gi|2053078945|tpg|BK020046.1| | 2832643 | g6547 | i0 | 100 | 2 | 508 | 0 | 100 | 0 | 1 | 508 | 9641 | 9134 | MAG TPA_asm: Caudoviricetes sp. isolate ctKcv1, partial genome | blastn | 1016 | 939 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 15464494 | 15464494 | PRJNA1022139_P_NODE_4553_length_602_cov_1.856333_g4449_i0 | PRJNA1022139 | 4553 | 602 | 1.856333 | 11.17512466 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 767 | 0 | NTclustered | gi|2053078945|tpg|BK020046.1| | 2832643 | g4449 | i0 | 89.684 | 0.998338870431894 | 601 | 62 | 99 | 0 | 1 | 601 | 4821 | 4221 | MAG TPA_asm: Caudoviricetes sp. isolate ctKcv1, partial genome | blastn | 601 | 767 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 16306031 | 16306031 | PRJNA1022139_P_NODE_2513_length_778_cov_1.499291_g2425_i0 | PRJNA1022139 | 2513 | 778 | 1.499291 | 11.66448398 | Betanudivirus | 1511854 | Viruses | Viruses | 60.2 | 4.66e-4 | NTclustered | gi|2500352098|ref|NC_074969.1| | 29250 | g2425 | i0 | 94.737 | 0.195372750642674 | 38 | 2 | 10 | 0 | 78 | 115 | 57195 | 57232 | Heliothis zea virus 1, complete genome | blastn | 152 | 60.2 | 1 | Viruses | Naldaviricetes | Lefavirales | Nudiviridae | Betanudivirus | Betanudivirus hezeae | ||||
| 16738570 | 16738570 | PRJNA1022139_P_NODE_18674_length_322_cov_1.297189_g18569_i0 | PRJNA1022139 | 18674 | 322 | 1.297189 | 4.17694858 | Lentivirus humimdef1 | 3418650 | Viruses | Viruses | 65.8 | 3.88e-6 | NTclustered | gi|37701115|gb|AY397046.1| | 11676 | g18569 | i0 | 97.368 | 4.08074534161491 | 38 | 1 | 12 | 0 | 12 | 49 | 334 | 297 | HIV-1 strain A|A15 from Ghana gag protein (gag) gene, partial cds | blastn | 1314 | 65.8 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Lentivirus | Lentivirus humimdef1 | ||
| 19287368 | 19287368 | PRJNA1022139_P_NODE_31496_length_261_cov_1.547872_g31391_i0 | PRJNA1022139 | 31496 | 261 | 1.547872 | 4.03994592 | uncultured virus | 340016 | Viruses | Viruses | 466 | 7.17e-127 | NTclustered | gi|1211046705|gb|KY052857.1| | 340016 | g31391 | i0 | 98.851 | 35.7739463601533 | 261 | 3 | 100 | 0 | 1 | 261 | 47346 | 47086 | Uncultured virus clone vSAG-92-D16 genomic sequence | blastn | 9337 | 466 | 1 | Viruses | uncultured virus | ||||||||
| 20562791 | 20562791 | PRJNA1022139_P_NODE_2417_length_792_cov_1.785814_g2329_i0 | PRJNA1022139 | 2417 | 792 | 1.785814 | 14.14364688 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 569 | 1.7699999999999994e-157 | NTclustered | gi|2053078945|tpg|BK020046.1| | 2832643 | g2329 | i0 | 94.34 | 1.06313131313131 | 371 | 21 | 47 | 0 | 422 | 792 | 3604 | 3234 | MAG TPA_asm: Caudoviricetes sp. isolate ctKcv1, partial genome | blastn | 842 | 569 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 20562844 | 20562844 | PRJNA1022139_P_NODE_3217_length_697_cov_2.250000_g3117_i0 | PRJNA1022139 | 3217 | 697 | 2.25 | 15.6825 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 505 | 4.44e-138 | NTclustered | gi|2914938176|gb|OR221695.1| | 2832643 | g3117 | i0 | 80.409 | 0.981348637015782 | 684 | 117 | 98 | 9 | 15 | 697 | 38311 | 38978 | MAG: Caudoviricetes sp. isolate MSP1344 genomic sequence | blastn | 684 | 505 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 20562852 | 20562852 | PRJNA1022139_P_NODE_33197_length_254_cov_2.629834_g33092_i0 | PRJNA1022139 | 33197 | 254 | 2.629834 | 6.67977836 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 399 | 7.149999999999999e-107 | NTclustered | gi|2053078945|tpg|BK020046.1| | 2832643 | g33092 | i0 | 95.582 | 2.82283464566929 | 249 | 11 | 98 | 0 | 6 | 254 | 8907 | 9155 | MAG TPA_asm: Caudoviricetes sp. isolate ctKcv1, partial genome | blastn | 717 | 399 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 21838503 | 21838503 | PRJNA1022139_P_NODE_30238_length_266_cov_1.326425_g30133_i0 | PRJNA1022139 | 30238 | 266 | 1.326425 | 3.5282905 | Pandoravirus salinus | 1349410 | Viruses | Viruses | 52.8 | 0.024 | NTclustered | gi|531034792|ref|NC_022098.1| | 1349410 | g30133 | i0 | 100 | 0.105263157894737 | 28 | 0 | 11 | 0 | 161 | 188 | 1367849 | 1367876 | Pandoravirus salinus, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Pandoravirus | Pandoravirus salinus | |||||||
| 21838531 | 21838531 | PRJNA1022139_P_NODE_33478_length_253_cov_2.938889_g33373_i0 | PRJNA1022139 | 33478 | 253 | 2.938889 | 7.43538917 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 381 | 2.5799999999999995e-101 | NTclustered | gi|2053078945|tpg|BK020046.1| | 2832643 | g33373 | i0 | 94.355 | 1.97628458498024 | 248 | 14 | 98 | 0 | 6 | 253 | 5705 | 5458 | MAG TPA_asm: Caudoviricetes sp. isolate ctKcv1, partial genome | blastn | 500 | 381 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 24387793 | 24387793 | PRJNA1022139_P_NODE_33220_length_254_cov_2.259669_g33115_i0 | PRJNA1022139 | 33220 | 254 | 2.259669 | 5.73955926 | Achromobacter phage JWF | 1589748 | Viruses | Viruses | 276 | 1.26e-69 | NTclustered | gi|985758637|ref|NC_029075.1| | 1589748 | g33115 | i0 | 86.275 | 1.00393700787402 | 255 | 33 | 100 | 2 | 1 | 254 | 34236 | 34489 | Achromobacter phage JWF, complete genome | blastn | 255 | 276 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Achromobacter phage JWF |
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);;