contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA596870" and tax_kingdom = "Heunggongvirae"
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. | |||||
| 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 | |||
| 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. | |||||
| 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 | |||||
| 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. |
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);;