contig_metadata
26 rows where analysis = "blastn", bioproject = "PRJNA596870" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3119392 | 3119392 | PRJNA596870_P_NODE_26283_length_265_cov_1.270833_g26150_i0 | PRJNA596870 | 26283 | 265 | 1.270833 | 3.36770745 | Henunavirus hena1 | 2844163 | Viruses | Viruses | 217 | 8.119999999999999e-52 | NTclustered | gi|1859666053|ref|NC_048828.1| | 2678601 | g26150 | i0 | 81.439 | 0.99622641509434 | 264 | 49 | 99 | 0 | 1 | 264 | 62827 | 62564 | Erwinia phage Hena1, complete genome | blastn | 264 | 217 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Henunavirus | Henunavirus hena1 | ||||
| 4396240 | 4396240 | PRJNA596870_P_NODE_39344_length_242_cov_0.881657_g39211_i0 | PRJNA596870 | 39344 | 242 | 0.881657 | 2.13360994 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 111 | 3.55e-20 | NTclustered | gi|2914829364|gb|OR222460.1| | 2832643 | g39211 | i0 | 100 | 25.3842975206612 | 60 | 0 | 25 | 0 | 1 | 60 | 33888 | 33829 | MAG: Caudoviricetes sp. isolate MSP0934 genomic sequence | blastn | 6143 | 111 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 5672105 | 5672105 | PRJNA596870_P_NODE_24305_length_275_cov_1.143564_g24172_i0 | PRJNA596870 | 24305 | 275 | 1.143564 | 3.144801 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 425 | 1.29e-114 | NTclustered | gi|2054595048|tpg|BK021614.1| | 2832643 | g24172 | i0 | 94.545 | 44.4872727272727 | 275 | 15 | 100 | 0 | 1 | 275 | 3464 | 3738 | MAG TPA_asm: Caudoviricetes sp. isolate ctTh72, partial genome | blastn | 12234 | 425 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 5672106 | 5672106 | PRJNA596870_P_NODE_24405_length_274_cov_1.532338_g24272_i0 | PRJNA596870 | 24405 | 274 | 1.532338 | 4.19860612 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 462 | 9.81e-126 | NTclustered | gi|2914947028|gb|OR221843.1| | 2832643 | g24272 | i0 | 97.08 | 20.6569343065693 | 274 | 8 | 100 | 0 | 1 | 274 | 8787 | 9060 | MAG: Caudoviricetes sp. isolate MSP1171 genomic sequence | blastn | 5660 | 462 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 5672202 | 5672202 | PRJNA596870_P_NODE_28645_length_252_cov_2.212291_g28512_i0 | PRJNA596870 | 28645 | 252 | 2.212291 | 5.57497332 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 388 | 1.5299999999999998e-103 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g28512 | i0 | 94.444 | 3 | 252 | 14 | 100 | 0 | 1 | 252 | 1804 | 2055 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 756 | 388 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 8221385 | 8221385 | PRJNA596870_P_NODE_16947_length_321_cov_0.931452_g16814_i0 | PRJNA596870 | 16947 | 321 | 0.931452 | 2.98996092 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 555 | 1.8799999999999998e-153 | NTclustered | gi|1812398529|gb|MN524064.1| | 2304617 | g16814 | i0 | 97.819 | 3 | 321 | 7 | 100 | 0 | 1 | 321 | 3851 | 3531 | Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome | blastn | 963 | 555 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 8221571 | 8221571 | PRJNA596870_P_NODE_25907_length_267_cov_1.252577_g25774_i0 | PRJNA596870 | 25907 | 267 | 1.252577 | 3.34438059 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 455 | 1.5900000000000002e-123 | NTclustered | gi|2914806477|gb|OR221547.1| | 2832643 | g25774 | i0 | 97.378 | 5.78277153558052 | 267 | 7 | 100 | 0 | 1 | 267 | 8823 | 9089 | MAG: Caudoviricetes sp. isolate MSP1533 genomic sequence | blastn | 1544 | 455 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 8221684 | 8221684 | PRJNA596870_P_NODE_31967_length_249_cov_0.875000_g31834_i0 | PRJNA596870 | 31967 | 249 | 0.875 | 2.17875 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 113 | 1.02e-20 | NTclustered | gi|2914921414|gb|OR221392.1| | 2832643 | g31834 | i0 | 100 | 25.7309236947791 | 61 | 0 | 24 | 0 | 189 | 249 | 70 | 10 | MAG: Caudoviricetes sp. isolate MSP1708 genomic sequence | blastn | 6407 | 113 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 9497059 | 9497059 | PRJNA596870_P_NODE_40628_length_230_cov_2.566879_g40495_i0 | PRJNA596870 | 40628 | 230 | 2.566879 | 5.9038217 | Jeruvirus PSTNGR1 | 3430083 | Viruses | Viruses | 298 | 2.39e-76 | NTclustered | gi|1930293603|gb|MW145136.1| | 2783542 | g40495 | i0 | 90 | 1 | 230 | 23 | 100 | 0 | 1 | 230 | 14591 | 14362 | Providencia phage PSTNGR1, complete genome | blastn | 230 | 298 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Autographivirales | Autonotataviridae | Jeruvirus | Jeruvirus PSTNGR1 | ||
| 10772781 | 10772781 | PRJNA596870_P_NODE_30769_length_250_cov_0.870056_g30636_i0 | PRJNA596870 | 30769 | 250 | 0.870056 | 2.17514 | Siphoviridae sp. ctoof1 | 2828227 | Viruses | Viruses | 462 | 8.83e-126 | NTclustered | gi|2054400656|tpg|BK031210.1| | 2828227 | g30636 | i0 | 100 | 5.928 | 250 | 0 | 100 | 0 | 1 | 250 | 15572 | 15323 | MAG TPA_asm: Siphoviridae sp. ctoof1, partial genome | blastn | 1482 | 462 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Siphoviridae sp. ctoof1 | |||||
| 13322430 | 13322430 | PRJNA596870_P_NODE_31771_length_249_cov_0.875000_g31638_i0 | PRJNA596870 | 31771 | 249 | 0.875 | 2.17875 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 95.3 | 3.69e-15 | NTclustered | gi|2914829364|gb|OR222460.1| | 2832643 | g31638 | i0 | 98.148 | 29.7630522088353 | 54 | 1 | 22 | 0 | 188 | 241 | 33830 | 33883 | MAG: Caudoviricetes sp. isolate MSP0934 genomic sequence | blastn | 7411 | 95.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14597452 | 14597452 | PRJNA596870_P_NODE_36012_length_245_cov_0.895349_g35879_i0 | PRJNA596870 | 36012 | 245 | 0.895349 | 2.19360505 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 453 | 5.1900000000000006e-123 | NTclustered | gi|2914977637|gb|OR222081.1| | 2832643 | g35879 | i0 | 100 | 5.00408163265306 | 245 | 0 | 100 | 0 | 1 | 245 | 142241 | 141997 | MAG: Caudoviricetes sp. isolate MSP0031 genomic sequence | blastn | 1226 | 453 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 15168658 | 15168658 | PRJNA596870_P_NODE_31652_length_249_cov_0.875000_g31519_i0 | PRJNA596870 | 31652 | 249 | 0.875 | 2.17875 | Kolesnikvirus | 1985293 | Viruses | Viruses | 449 | 6.840000000000001e-122 | NTclustered | gi|1797168264|gb|MK759884.1| | 2698415 | g31519 | i0 | 99.197 | 30.1927710843373 | 249 | 2 | 100 | 0 | 1 | 249 | 21221 | 21469 | Salmonella phage vB_SenM_SB18, complete genome | blastn | 7518 | 449 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Andersonviridae | Kolesnikvirus | Kolesnikvirus Ea214 | |||
| 16443232 | 16443232 | PRJNA596870_P_NODE_23453_length_279_cov_1.519417_g23320_i0 | PRJNA596870 | 23453 | 279 | 1.519417 | 4.23917343 | root | 1 | Root_unresolved | Root_unresolved | 507 | 4.56e-139 | NTclustered | gi|2294886298|gb|OP076147.1| | 38018 | g23320 | i0 | 99.639 | 17.2401433691756 | 277 | 1 | 99 | 0 | 1 | 277 | 29994 | 29718 | MAG: Bacteriophage sp. isolate 4216_17120, complete genome | blastn | 4810 | 512 | 0.990234375 | Viruses | Bacteriophage sp. | ||||||||
| 17146313 | 17146313 | PRJNA596870_P_NODE_4534_length_564_cov_1.853360_g4403_i0 | PRJNA596870 | 4534 | 564 | 1.85336 | 10.4529504 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 113 | 2.51e-20 | NTclustered | gi|2914921414|gb|OR221392.1| | 2832643 | g4403 | i0 | 100 | 11.0744680851064 | 61 | 0 | 11 | 0 | 5 | 65 | 11 | 71 | MAG: Caudoviricetes sp. isolate MSP1708 genomic sequence | blastn | 6246 | 113 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18420400 | 18420400 | PRJNA596870_P_NODE_31015_length_250_cov_0.796610_g30882_i0 | PRJNA596870 | 31015 | 250 | 0.79661 | 1.991525 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 106 | 1.71e-18 | NTclustered | gi|2914981896|gb|OR222105.1| | 2832643 | g30882 | i0 | 98.333 | 25.864 | 60 | 1 | 24 | 0 | 4 | 63 | 63 | 4 | MAG: Caudoviricetes sp. isolate MSP0005 genomic sequence | blastn | 6466 | 106 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19694492 | 19694492 | PRJNA596870_P_NODE_10996_length_383_cov_1.709677_g10863_i0 | PRJNA596870 | 10996 | 383 | 1.709677 | 6.54806291 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 652 | 0 | NTclustered | gi|1812398529|gb|MN524064.1| | 2304617 | g10863 | i0 | 97.389 | 3 | 383 | 10 | 100 | 0 | 1 | 383 | 7861 | 7479 | Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome | blastn | 1149 | 652 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 19694800 | 19694800 | PRJNA596870_P_NODE_26576_length_263_cov_1.621053_g26443_i0 | PRJNA596870 | 26576 | 263 | 1.621053 | 4.26336939 | Aeromonas phage ST4 | 3065692 | Viruses | Viruses | 470 | 5.59e-128 | NTclustered | gi|2582033029|gb|OR261032.1| | 3065692 | g26443 | i0 | 98.859 | 1 | 263 | 3 | 100 | 0 | 1 | 263 | 13942 | 13680 | Aeromonas phage ST4, complete genome | blastn | 263 | 470 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Aeromonas phage ST4 | |||||
| 19694941 | 19694941 | PRJNA596870_P_NODE_33676_length_247_cov_0.885057_g33543_i0 | PRJNA596870 | 33676 | 247 | 0.885057 | 2.18609079 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 99 | 2.83e-16 | NTclustered | gi|2914981896|gb|OR222105.1| | 2832643 | g33543 | i0 | 100 | 29.0769230769231 | 53 | 0 | 21 | 0 | 12 | 64 | 56 | 4 | MAG: Caudoviricetes sp. isolate MSP0005 genomic sequence | blastn | 7182 | 99 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19694953 | 19694953 | PRJNA596870_P_NODE_34296_length_246_cov_1.566474_g34163_i0 | PRJNA596870 | 34296 | 246 | 1.566474 | 3.85352604 | Aeromonas phage ST4 | 3065692 | Viruses | Viruses | 398 | 2.4799999999999997e-106 | NTclustered | gi|2582033029|gb|OR261032.1| | 3065692 | g34163 | i0 | 95.918 | 0.995934959349594 | 245 | 10 | 99 | 0 | 2 | 246 | 88893 | 88649 | Aeromonas phage ST4, complete genome | blastn | 245 | 398 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Aeromonas phage ST4 | |||||
| 19695058 | 19695058 | PRJNA596870_P_NODE_39436_length_241_cov_1.476190_g39303_i0 | PRJNA596870 | 39436 | 241 | 1.47619 | 3.5576179 | Adoxophyes orana nucleopolyhedrovirus | 542343 | Viruses | Viruses | 52.8 | 0.022 | NTclustered | gi|192758757|gb|EU591746.1| | 542343 | g39303 | i0 | 100 | 0.232365145228216 | 28 | 0 | 12 | 0 | 26 | 53 | 58438 | 58411 | Adoxophyes orana nucleopolyhedrovirus, complete genome | blastn | 56 | 52.8 | 1 | Viruses | Naldaviricetes | Lefavirales | Baculoviridae | Alphabaculovirus | Adoxophyes orana nucleopolyhedrovirus | ||||
| 20970505 | 20970505 | PRJNA596870_P_NODE_20917_length_292_cov_1.757991_g20784_i0 | PRJNA596870 | 20917 | 292 | 1.757991 | 5.13333372 | Polycipiviridae sp. | 2496155 | Viruses | Viruses | 52.8 | 0.027 | NTclustered | gi|2756421824|gb|PP744841.1| | 2496155 | g20784 | i0 | 90.244 | 0.14041095890411 | 41 | 3 | 14 | 1 | 246 | 285 | 9211 | 9171 | MAG: Polycipiviridae sp. isolate 086_167342 genomic sequence | blastn | 41 | 52.8 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Polycipiviridae | Polycipiviridae sp. | |||
| 22245361 | 22245361 | PRJNA596870_P_NODE_18278_length_311_cov_0.970588_g18145_i0 | PRJNA596870 | 18278 | 311 | 0.970588 | 3.01852868 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 99 | 3.68e-16 | NTclustered | gi|2914921414|gb|OR221392.1| | 2832643 | g18145 | i0 | 96.61 | 22.9903536977492 | 59 | 2 | 19 | 0 | 1 | 59 | 19 | 77 | MAG: Caudoviricetes sp. isolate MSP1708 genomic sequence | blastn | 7150 | 99 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 23520742 | 23520742 | PRJNA596870_P_NODE_26139_length_266_cov_1.196891_g26006_i0 | PRJNA596870 | 26139 | 266 | 1.196891 | 3.18373006 | Jeruvirus PSTNGR1 | 3430083 | Viruses | Viruses | 257 | 4.8e-64 | NTclustered | gi|1930293603|gb|MW145136.1| | 2783542 | g26006 | i0 | 85.659 | 0.969924812030075 | 258 | 22 | 96 | 9 | 1 | 255 | 28084 | 28329 | Providencia phage PSTNGR1, complete genome | blastn | 258 | 257 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Autographivirales | Autonotataviridae | Jeruvirus | Jeruvirus PSTNGR1 | ||
| 23521037 | 23521037 | PRJNA596870_P_NODE_40599_length_231_cov_3.449367_g40466_i0 | PRJNA596870 | 40599 | 231 | 3.449367 | 7.96803777 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 427 | 2.9399999999999998e-115 | NTclustered | gi|2914922737|gb|OR221423.1| | 2832643 | g40466 | i0 | 100 | 50.2727272727273 | 231 | 0 | 100 | 0 | 1 | 231 | 42108 | 42338 | MAG: Caudoviricetes sp. isolate MSP1668 genomic sequence | blastn | 11613 | 427 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 24794476 | 24794476 | PRJNA596870_P_NODE_25340_length_270_cov_0.842640_g25207_i0 | PRJNA596870 | 25340 | 270 | 0.84264 | 2.275128 | Gammaretrovirus murleu | 3428959 | Viruses | Viruses | 483 | 7.409999999999998e-132 | NTclustered | gi|375344385|gb|JQ048953.1| | 11786 | g25207 | i0 | 98.889 | 99.9333333333333 | 270 | 3 | 100 | 0 | 1 | 270 | 408 | 139 | Murine leukemia virus isolate PCR amplicon 3220_2 group specific antigen (gag) gene, partial cds | blastn | 26982 | 483 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu |
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);;