contig_metadata
30 rows where analysis = "blastn", bioproject = "PRJNA492406" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 452408 | 452408 | PRJNA492406_P_NODE_15961_length_314_cov_1.278008_g15662_i0 | PRJNA492406 | 15961 | 314 | 1.278008 | 4.01294512 | Marfavirus F48 | 2845079 | Viruses | Viruses | 409 | 1.51e-109 | NTclustered | gi|1726264207|gb|MN013081.1| | 2591366 | g15662 | i0 | 90.354 | 1.97452229299363 | 311 | 30 | 99 | 0 | 2 | 312 | 149079 | 148769 | Klebsiella phage vB_KpnM_Potts1, complete genome | blastn | 620 | 409 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Marfavirus | Marfavirus F48 | ||||
| 452422 | 452422 | PRJNA492406_P_NODE_16461_length_309_cov_0.944915_g16162_i0 | PRJNA492406 | 16461 | 309 | 0.944915 | 2.91978735 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 544 | 3.9e-150 | NTclustered | gi|2914988762|gb|OR222153.1| | 2832643 | g16162 | i0 | 98.382 | 17.653721682847902 | 309 | 5 | 100 | 0 | 1 | 309 | 38581 | 38889 | MAG: Caudoviricetes sp. isolate MSP0823 genomic sequence | blastn | 5455 | 544 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 452513 | 452513 | PRJNA492406_P_NODE_21321_length_277_cov_1.504902_g21022_i0 | PRJNA492406 | 21321 | 277 | 1.504902 | 4.16857854 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 468 | 2.14e-127 | NTclustered | gi|2914920971|gb|OR221384.1| | 2832643 | g21022 | i0 | 97.112 | 5.93501805054152 | 277 | 8 | 100 | 0 | 1 | 277 | 8381 | 8105 | MAG: Caudoviricetes sp. isolate MSP1712 genomic sequence | blastn | 1644 | 468 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 1099315 | 1099315 | PRJNA492406_P_NODE_31721_length_241_cov_2.172619_g31422_i0 | PRJNA492406 | 31721 | 241 | 2.172619 | 5.23601179 | Marfavirus | 2843419 | Viruses | Viruses | 368 | 1.9e-97 | NTclustered | gi|1859661976|ref|NC_048798.1| | 2587809 | g31422 | i0 | 94.191 | 20 | 241 | 14 | 100 | 0 | 1 | 241 | 52196 | 52436 | Klebsiella phage Marfa, complete genome | blastn | 4820 | 368 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Marfavirus | Marfavirus marfa | ||||
| 1727091 | 1727091 | PRJNA492406_P_NODE_16142_length_312_cov_1.083682_g15843_i0 | PRJNA492406 | 16142 | 312 | 1.083682 | 3.38108784 | Klebsiella phage pzk-kv8 | 3062826 | Viruses | Viruses | 411 | 4.179999999999999e-110 | NTclustered | gi|2554109259|gb|OR231917.1| | 3062826 | g15843 | i0 | 90.385 | 2 | 312 | 30 | 100 | 0 | 1 | 312 | 27610 | 27299 | Klebsiella phage pzk-kv8, complete genome | blastn | 624 | 411 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Marfavirus | Klebsiella phage pzk-kv8 | ||||
| 1727117 | 1727117 | PRJNA492406_P_NODE_16962_length_304_cov_1.000000_g16663_i0 | PRJNA492406 | 16962 | 304 | 1 | 3.04 | Klebsiella phage pzk-kv8 | 3062826 | Viruses | Viruses | 375 | 1.48e-99 | NTclustered | gi|2554109259|gb|OR231917.1| | 3062826 | g16663 | i0 | 89.073 | 27.4703947368421 | 302 | 33 | 99 | 0 | 1 | 302 | 100300 | 99999 | Klebsiella phage pzk-kv8, complete genome | blastn | 8351 | 375 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Marfavirus | Klebsiella phage pzk-kv8 | ||||
| 3650326 | 3650326 | PRJNA492406_P_NODE_15763_length_316_cov_0.971193_g15464_i0 | PRJNA492406 | 15763 | 316 | 0.971193 | 3.06896988 | Marfavirus | 2843419 | Viruses | Viruses | 507 | 5.25e-139 | NTclustered | gi|2560277363|gb|OR145792.1| | 3061041 | g15464 | i0 | 95.57 | 17.996835443038 | 316 | 14 | 100 | 0 | 1 | 316 | 151665 | 151980 | Klebsiella phage Kpn BM7, complete genome | blastn | 5687 | 507 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Marfavirus | Klebsiella phage Kpn BM7 | ||||
| 4279575 | 4279575 | PRJNA492406_P_NODE_24624_length_260_cov_2.058824_g24325_i0 | PRJNA492406 | 24624 | 260 | 2.058824 | 5.3529424 | Klebsiella phage pzk-kv8 | 3062826 | Viruses | Viruses | 442 | 1.1999999999999999e-119 | NTclustered | gi|2554109259|gb|OR231917.1| | 3062826 | g24325 | i0 | 97.308 | 61.5076923076923 | 260 | 7 | 100 | 0 | 1 | 260 | 9713 | 9454 | Klebsiella phage pzk-kv8, complete genome | blastn | 15992 | 442 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Marfavirus | Klebsiella phage pzk-kv8 | ||||
| 4279591 | 4279591 | PRJNA492406_P_NODE_25524_length_256_cov_1.262295_g25225_i0 | PRJNA492406 | 25524 | 256 | 1.262295 | 3.2314752 | Marfavirus F48 | 2845079 | Viruses | Viruses | 390 | 4.3399999999999997e-104 | NTclustered | gi|2132900028|gb|MZ571829.1| | 2866697 | g25225 | i0 | 94.141 | 24.30078125 | 256 | 15 | 100 | 0 | 1 | 256 | 8512 | 8257 | Klebsiella phage vB_KpnM-VAC36, complete genome | blastn | 6221 | 390 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Marfavirus | Marfavirus F48 | ||||
| 5556234 | 5556234 | PRJNA492406_P_NODE_32105_length_241_cov_0.916667_g31806_i0 | PRJNA492406 | 32105 | 241 | 0.916667 | 2.20916747 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 401 | 1.8699999999999993e-107 | NTclustered | gi|2914763246|gb|OR221877.1| | 2832643 | g31806 | i0 | 96.68 | 9.73858921161826 | 241 | 8 | 100 | 0 | 1 | 241 | 5849 | 6089 | MAG: Caudoviricetes sp. isolate MSP1125 genomic sequence | blastn | 2347 | 401 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 6829816 | 6829816 | PRJNA492406_P_NODE_12906_length_348_cov_2.272727_g12607_i0 | PRJNA492406 | 12906 | 348 | 2.272727 | 7.90908996 | Klebsiella phage pzk-kv8 | 3062826 | Viruses | Viruses | 536 | 7.459999999999997e-148 | NTclustered | gi|2554109259|gb|OR231917.1| | 3062826 | g12607 | i0 | 94.767 | 23.5747126436782 | 344 | 18 | 99 | 0 | 1 | 344 | 101937 | 102280 | Klebsiella phage pzk-kv8, complete genome | blastn | 8204 | 536 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Marfavirus | Klebsiella phage pzk-kv8 | ||||
| 10027569 | 10027569 | PRJNA492406_P_NODE_29928_length_245_cov_0.895349_g29629_i0 | PRJNA492406 | 29928 | 245 | 0.895349 | 2.19360505 | Marfavirus | 2843419 | Viruses | Viruses | 303 | 5.53e-78 | NTclustered | gi|1726264207|gb|MN013081.1| | 2591366 | g29629 | i0 | 88.98 | 15 | 245 | 27 | 100 | 0 | 1 | 245 | 123099 | 122855 | Klebsiella phage vB_KpnM_Potts1, complete genome | blastn | 3675 | 303 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Marfavirus | Marfavirus F48 | ||||
| 11930889 | 11930889 | PRJNA492406_P_NODE_13570_length_340_cov_1.561798_g13271_i0 | PRJNA492406 | 13570 | 340 | 1.561798 | 5.3101132 | Marfavirus marfa | 2845092 | Viruses | Viruses | 359 | 1.69e-94 | NTclustered | gi|1859661976|ref|NC_048798.1| | 2587809 | g13271 | i0 | 89.199 | 19.6588235294118 | 287 | 31 | 84 | 0 | 54 | 340 | 168381 | 168095 | Klebsiella phage Marfa, complete genome | blastn | 6684 | 359 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Marfavirus | Marfavirus marfa | ||||
| 11930895 | 11930895 | PRJNA492406_P_NODE_13790_length_337_cov_2.136364_g13491_i0 | PRJNA492406 | 13790 | 337 | 2.136364 | 7.19954668 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 244 | 4.8899999999999997e-60 | NTclustered | gi|2914818669|gb|OR222054.1| | 2832643 | g13491 | i0 | 82.562 | 2.41839762611276 | 281 | 45 | 83 | 3 | 59 | 337 | 36151 | 35873 | MAG: Caudoviricetes sp. isolate MSP0061 genomic sequence | blastn | 815 | 244 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11930954 | 11930954 | PRJNA492406_P_NODE_16290_length_310_cov_2.113924_g15991_i0 | PRJNA492406 | 16290 | 310 | 2.113924 | 6.5531644 | Marfavirus F48 | 2845079 | Viruses | Viruses | 261 | 4.42e-65 | NTclustered | gi|1726264207|gb|MN013081.1| | 2591366 | g15991 | i0 | 98 | 5.3258064516129 | 150 | 3 | 97 | 0 | 161 | 310 | 111562 | 111711 | Klebsiella phage vB_KpnM_Potts1, complete genome | blastn | 1651 | 261 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Marfavirus | Marfavirus F48 | ||||
| 11931300 | 11931300 | PRJNA492406_P_NODE_32750_length_229_cov_2.467949_g32451_i0 | PRJNA492406 | 32750 | 229 | 2.467949 | 5.65160321 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 424 | 3.76e-114 | NTclustered | gi|2053025026|tpg|BK023955.1| | 2832643 | g32451 | i0 | 100 | 16.4323144104803 | 229 | 0 | 100 | 0 | 1 | 229 | 19174 | 18946 | MAG TPA_asm: Caudoviricetes sp. isolate ctWEw2, partial genome | blastn | 3763 | 424 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 12578104 | 12578104 | PRJNA492406_P_NODE_12690_length_351_cov_1.302158_g12391_i0 | PRJNA492406 | 12690 | 351 | 1.302158 | 4.57057458 | Marfavirus | 2843419 | Viruses | Viruses | 399 | 1.0299999999999998e-106 | NTclustered | gi|1786622593|gb|MN781108.1| | 2686283 | g12391 | i0 | 87.179 | 3.27635327635328 | 351 | 45 | 100 | 0 | 1 | 351 | 155868 | 156218 | Klebsiella phage vB_Kpn_P545, complete genome | blastn | 1150 | 399 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Marfavirus | Marfavirus F48 | ||||
| 14481285 | 14481285 | PRJNA492406_P_NODE_30832_length_243_cov_0.905882_g30533_i0 | PRJNA492406 | 30832 | 243 | 0.905882 | 2.20129326 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 255 | 1.5600000000000001e-63 | NTclustered | gi|2914869192|gb|OR222811.1| | 2832643 | g30533 | i0 | 86.325 | 2.96707818930041 | 234 | 32 | 96 | 0 | 1 | 234 | 57772 | 58005 | MAG: Caudoviricetes sp. isolate MSP0541 genomic sequence | blastn | 721 | 255 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 15755072 | 15755072 | PRJNA492406_P_NODE_21053_length_278_cov_2.004878_g20754_i0 | PRJNA492406 | 21053 | 278 | 2.004878 | 5.57356084 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 475 | 1.2799999999999997e-129 | NTclustered | gi|2914988762|gb|OR222153.1| | 2832643 | g20754 | i0 | 97.482 | 47.9352517985612 | 278 | 7 | 100 | 0 | 1 | 278 | 1074 | 1351 | MAG: Caudoviricetes sp. isolate MSP0823 genomic sequence | blastn | 13326 | 475 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 15755221 | 15755221 | PRJNA492406_P_NODE_27913_length_249_cov_0.869318_g27614_i0 | PRJNA492406 | 27913 | 249 | 0.869318 | 2.16460182 | Klebsiella phage Kpn BM7 | 3061041 | Viruses | Viruses | 383 | 7.04e-102 | NTclustered | gi|2560277363|gb|OR145792.1| | 3061041 | g27614 | i0 | 94.378 | 20.0120481927711 | 249 | 14 | 100 | 0 | 1 | 249 | 133392 | 133640 | Klebsiella phage Kpn BM7, complete genome | blastn | 4983 | 383 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Marfavirus | Klebsiella phage Kpn BM7 | ||||
| 16401919 | 16401919 | PRJNA492406_P_NODE_7453_length_444_cov_1.245283_g7154_i0 | PRJNA492406 | 7453 | 444 | 1.245283 | 5.52905652 | Marfavirus | 2843419 | Viruses | Viruses | 505 | 2.739999999999999e-138 | NTclustered | gi|2554109259|gb|OR231917.1| | 3062826 | g7154 | i0 | 87.191 | 19.0630630630631 | 445 | 55 | 100 | 2 | 1 | 444 | 74932 | 75375 | Klebsiella phage pzk-kv8, complete genome | blastn | 8464 | 505 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Marfavirus | Klebsiella phage pzk-kv8 | ||||
| 17029506 | 17029506 | PRJNA492406_P_NODE_12174_length_357_cov_1.355634_g11875_i0 | PRJNA492406 | 12174 | 357 | 1.355634 | 4.83961338 | Klebsiella phage pzk-kv8 | 3062826 | Viruses | Viruses | 610 | 4.449999999999999e-170 | NTclustered | gi|2554109259|gb|OR231917.1| | 3062826 | g11875 | i0 | 97.479 | 20.6946778711485 | 357 | 9 | 100 | 0 | 1 | 357 | 7965 | 7609 | Klebsiella phage pzk-kv8, complete genome | blastn | 7388 | 610 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Marfavirus | Klebsiella phage pzk-kv8 | ||||
| 17029685 | 17029685 | PRJNA492406_P_NODE_19014_length_288_cov_1.255814_g18715_i0 | PRJNA492406 | 19014 | 288 | 1.255814 | 3.61674432 | Klebsiella phage pzk-kv8 | 3062826 | Viruses | Viruses | 405 | 1.78e-108 | NTclustered | gi|2554109259|gb|OR231917.1| | 3062826 | g18715 | i0 | 92.042 | 9.56944444444444 | 289 | 21 | 100 | 2 | 1 | 288 | 103627 | 103340 | Klebsiella phage pzk-kv8, complete genome | blastn | 2756 | 405 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Marfavirus | Klebsiella phage pzk-kv8 | ||||
| 18950793 | 18950793 | PRJNA492406_P_NODE_26475_length_251_cov_1.297753_g26176_i0 | PRJNA492406 | 26475 | 251 | 1.297753 | 3.25736003 | Marfavirus | 2843419 | Viruses | Viruses | 342 | 1.21e-89 | NTclustered | gi|1859661976|ref|NC_048798.1| | 2587809 | g26176 | i0 | 91.235 | 20 | 251 | 22 | 100 | 0 | 1 | 251 | 97485 | 97735 | Klebsiella phage Marfa, complete genome | blastn | 5020 | 342 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Marfavirus | Marfavirus marfa | ||||
| 19578306 | 19578306 | PRJNA492406_P_NODE_21796_length_275_cov_1.014851_g21497_i0 | PRJNA492406 | 21796 | 275 | 1.014851 | 2.79084025 | Klebsiella phage pzk-kv8 | 3062826 | Viruses | Viruses | 348 | 2.88e-91 | NTclustered | gi|2554109259|gb|OR231917.1| | 3062826 | g21497 | i0 | 89.455 | 18.0509090909091 | 275 | 29 | 100 | 0 | 1 | 275 | 131297 | 131023 | Klebsiella phage pzk-kv8, complete genome | blastn | 4964 | 348 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Marfavirus | Klebsiella phage pzk-kv8 | ||||
| 20225734 | 20225734 | PRJNA492406_P_NODE_5116_length_530_cov_1.483589_g4821_i0 | PRJNA492406 | 5116 | 530 | 1.483589 | 7.8630217 | Marfavirus | 2843419 | Viruses | Viruses | 723 | 0 | NTclustered | gi|2554109259|gb|OR231917.1| | 3062826 | g4821 | i0 | 91.248 | 14.3452830188679 | 537 | 38 | 100 | 5 | 1 | 530 | 147710 | 147176 | Klebsiella phage pzk-kv8, complete genome | blastn | 7603 | 723 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Marfavirus | Klebsiella phage pzk-kv8 | ||||
| 20853921 | 20853921 | PRJNA492406_P_NODE_13717_length_338_cov_1.841509_g13418_i0 | PRJNA492406 | 13717 | 338 | 1.841509 | 6.22430042 | Marfavirus F48 | 2845079 | Viruses | Viruses | 553 | 7.179999999999998e-153 | NTclustered | gi|1726264207|gb|MN013081.1| | 2591366 | g13418 | i0 | 96.154 | 22 | 338 | 13 | 100 | 0 | 1 | 338 | 49820 | 50157 | Klebsiella phage vB_KpnM_Potts1, complete genome | blastn | 7436 | 553 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Marfavirus | Marfavirus F48 | ||||
| 22128959 | 22128959 | PRJNA492406_P_NODE_2558_length_752_cov_1.291605_g2278_i0 | PRJNA492406 | 2558 | 752 | 1.291605 | 9.7128696 | Marfavirus F48 | 2845079 | Viruses | Viruses | 1339 | 0 | NTclustered | gi|1726264207|gb|MN013081.1| | 2591366 | g2278 | i0 | 98.803 | 26.3018617021277 | 752 | 9 | 100 | 0 | 1 | 752 | 4246 | 3495 | Klebsiella phage vB_KpnM_Potts1, complete genome | blastn | 19779 | 1339 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Marfavirus | Marfavirus F48 | ||||
| 24678652 | 24678652 | PRJNA492406_P_NODE_28980_length_247_cov_0.885057_g28681_i0 | PRJNA492406 | 28980 | 247 | 0.885057 | 2.18609079 | Klebsiella phage pzk-kv8 | 3062826 | Viruses | Viruses | 335 | 1.9799999999999992e-87 | NTclustered | gi|2554109259|gb|OR231917.1| | 3062826 | g28681 | i0 | 91.129 | 4.00404858299595 | 248 | 20 | 100 | 2 | 1 | 247 | 21160 | 20914 | Klebsiella phage pzk-kv8, complete genome | blastn | 989 | 335 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Marfavirus | Klebsiella phage pzk-kv8 | ||||
| 24678689 | 24678689 | PRJNA492406_P_NODE_31040_length_243_cov_0.905882_g30741_i0 | PRJNA492406 | 31040 | 243 | 0.905882 | 2.20129326 | Mycobacterium phage Maddy2 | 3240400 | Viruses | Viruses | 339 | 1.4999999999999997e-88 | NTclustered | gi|2784346100|gb|PQ115172.1| | 3240400 | g30741 | i0 | 91.6 | 1.02880658436214 | 250 | 13 | 100 | 5 | 1 | 243 | 50926 | 50678 | Mycobacterium phage Maddy2, complete genome | blastn | 250 | 339 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Mycobacterium phage Maddy2 |
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);;