contig_metadata
30 rows where analysis = "blastn", bioproject = "PRJNA725806" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1987738 | 1987738 | PRJNA725806_P_NODE_112062_length_189_cov_2.769737_g111760_i0 | PRJNA725806 | 112062 | 189 | 2.769737 | 5.23480293 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 350 | 5.14e-92 | NTclustered | gi|2053036246|tpg|BK024160.1| | 2832643 | g111760 | i0 | 100 | 3.46031746031746 | 189 | 0 | 100 | 0 | 1 | 189 | 5407 | 5219 | MAG TPA_asm: Caudoviricetes sp. isolate ct1rL2, partial genome | blastn | 654 | 350 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 1987769 | 1987769 | PRJNA725806_P_NODE_127742_length_180_cov_1.629371_g127440_i0 | PRJNA725806 | 127742 | 180 | 1.629371 | 2.9328678 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 333 | 4.87e-87 | NTclustered | gi|2053036246|tpg|BK024160.1| | 2832643 | g127440 | i0 | 100 | 1 | 180 | 0 | 100 | 0 | 1 | 180 | 1998 | 1819 | MAG TPA_asm: Caudoviricetes sp. isolate ct1rL2, partial genome | blastn | 180 | 333 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 2469672 | 2469672 | PRJNA725806_P_NODE_139082_length_174_cov_1.700730_g138780_i0 | PRJNA725806 | 139082 | 174 | 1.70073 | 2.9592702 | root | 1 | Root_unresolved | Root_unresolved | 291 | 2.8499999999999993e-74 | NTclustered | gi|31415740|ref|NC_004820.1| | 225725 | g138780 | i0 | 100 | 23.3850574712644 | 157 | 0 | 90 | 0 | 18 | 174 | 19529 | 19685 | Bacillus prophage phBC6A51, complete genome | blastn | 4069 | 291 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Bacillus phage phBC6A51 | |||||
| 3262991 | 3262991 | PRJNA725806_P_NODE_103443_length_195_cov_1.658228_g103141_i0 | PRJNA725806 | 103443 | 195 | 1.658228 | 3.2335446 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 361 | 2.46e-95 | NTclustered | gi|2053036246|tpg|BK024160.1| | 2832643 | g103141 | i0 | 100 | 3.96923076923077 | 195 | 0 | 100 | 0 | 1 | 195 | 1360 | 1166 | MAG TPA_asm: Caudoviricetes sp. isolate ct1rL2, partial genome | blastn | 774 | 361 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 3263014 | 3263014 | PRJNA725806_P_NODE_110723_length_190_cov_2.156863_g110421_i0 | PRJNA725806 | 110723 | 190 | 2.156863 | 4.0980397 | Levilactobacillus phage ENFP1 | 2912627 | Viruses | Viruses | 52.8 | 0.016 | NTclustered | gi|2228711801|gb|OM293948.2| | 2912627 | g110421 | i0 | 100 | 0.147368421052632 | 28 | 0 | 15 | 0 | 127 | 154 | 19896 | 19923 | Levilactobacillus phage ENFP1, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Herelleviridae | Tybeckvirus | Levilactobacillus phage ENFP1 | |||
| 6298346 | 6298346 | PRJNA725806_P_NODE_105_length_1628_cov_7.005657_g66_i0 | PRJNA725806 | 105 | 1628 | 7.005657 | 114.05209596 | root | 1 | Root_unresolved | Root_unresolved | 2754 | 0 | NTclustered | gi|1859642164|ref|NC_048633.1| | 1759525 | g66 | i0 | 99.668 | 23.1019656019656 | 1506 | 5 | 93 | 0 | 25 | 1530 | 37987 | 36482 | Bacillus phage vB_BceS-MY192, partial genome | blastn | 37610 | 2754 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Hubeivirus | Hubeivirus MY192 | ||||
| 6298350 | 6298350 | PRJNA725806_P_NODE_106505_length_193_cov_1.243590_g106203_i0 | PRJNA725806 | 106505 | 193 | 1.24359 | 2.4001287 | root | 1 | Root_unresolved | Root_unresolved | 357 | 3.1499999999999996e-94 | NTclustered | gi|1043841560|gb|KX227759.1| | 1868600 | g106203 | i0 | 100 | 4.00518134715026 | 193 | 0 | 100 | 0 | 1 | 193 | 17985 | 17793 | Bacillus phage PfIS075, complete genome | blastn | 773 | 357 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Cecivirus | Bacillus phage PfIS075 | ||||
| 7572166 | 7572166 | PRJNA725806_P_NODE_114146_length_188_cov_1.291391_g113844_i0 | PRJNA725806 | 114146 | 188 | 1.291391 | 2.42781508 | root | 1 | Root_unresolved | Root_unresolved | 348 | 1.84e-91 | NTclustered | gi|1043841560|gb|KX227759.1| | 1868600 | g113844 | i0 | 100 | 6.98936170212766 | 188 | 0 | 100 | 0 | 1 | 188 | 43959 | 43772 | Bacillus phage PfIS075, complete genome | blastn | 1314 | 348 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Cecivirus | Bacillus phage PfIS075 | ||||
| 9640367 | 9640367 | PRJNA725806_P_NODE_190728_length_152_cov_1.260870_g190426_i0 | PRJNA725806 | 190728 | 152 | 1.26087 | 1.9165224 | Pahexavirus P100D | 1982266 | Viruses | Viruses | 276 | 6.770000000000001e-70 | NTclustered | gi|408905847|ref|NC_018852.1| | 1229789 | g190426 | i0 | 99.342 | 99.9013157894737 | 152 | 1 | 100 | 0 | 1 | 152 | 7787 | 7938 | Propionibacterium phage P100D, complete genome | blastn | 15185 | 276 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Pahexavirus P100D | ||||
| 10915907 | 10915907 | PRJNA725806_P_NODE_193409_length_151_cov_1.350877_g193107_i0 | PRJNA725806 | 193409 | 151 | 1.350877 | 2.03982427 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 279 | 5.19e-71 | NTclustered | gi|2057844767|tpg|BK055780.1| | 2832643 | g193107 | i0 | 100 | 1 | 151 | 0 | 100 | 0 | 1 | 151 | 39689 | 39839 | MAG TPA_asm: Caudoviricetes sp. isolate ctvEa3, partial genome | blastn | 151 | 279 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 10916015 | 10916015 | PRJNA725806_P_NODE_60049_length_235_cov_1.828283_g59751_i0 | PRJNA725806 | 60049 | 235 | 1.828283 | 4.29646505 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 435 | 1.79e-117 | NTclustered | gi|2053036246|tpg|BK024160.1| | 2832643 | g59751 | i0 | 100 | 1 | 235 | 0 | 100 | 0 | 1 | 235 | 4354 | 4120 | MAG TPA_asm: Caudoviricetes sp. isolate ct1rL2, partial genome | blastn | 235 | 435 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 10916045 | 10916045 | PRJNA725806_P_NODE_71429_length_221_cov_17.114130_g71128_i0 | PRJNA725806 | 71429 | 221 | 17.11413 | 37.8222273 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 52.8 | 0.02 | NTclustered | gi|2056763675|tpg|BK045571.1| | 2832643 | g71128 | i0 | 100 | 0.126696832579186 | 28 | 0 | 13 | 0 | 65 | 92 | 16425 | 16452 | MAG TPA_asm: Caudoviricetes sp. isolate ctiR75, partial genome | blastn | 28 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 13465596 | 13465596 | PRJNA725806_P_NODE_177671_length_157_cov_0.958333_g177369_i0 | PRJNA725806 | 177671 | 157 | 0.958333 | 1.50458281 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 291 | 2.52e-74 | NTclustered | gi|2057933671|tpg|BK045843.1| | 2832643 | g177369 | i0 | 100 | 5.94904458598726 | 157 | 0 | 100 | 0 | 1 | 157 | 12581 | 12737 | MAG TPA_asm: Caudoviricetes sp. isolate ctBKE1, partial genome | blastn | 934 | 291 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 13465657 | 13465657 | PRJNA725806_P_NODE_36571_length_272_cov_4.136170_g36274_i0 | PRJNA725806 | 36571 | 272 | 4.13617 | 11.2503824 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 52.8 | 0.025 | NTclustered | gi|2053126656|tpg|BK021038.1| | 2832643 | g36274 | i0 | 96.875 | 0.117647058823529 | 32 | 0 | 12 | 1 | 213 | 244 | 38018 | 38048 | MAG TPA_asm: Caudoviricetes sp. isolate ctWBv3, partial genome | blastn | 32 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 13465788 | 13465788 | PRJNA725806_P_NODE_91851_length_203_cov_5.891566_g91549_i0 | PRJNA725806 | 91851 | 203 | 5.891566 | 11.95987898 | Siphoviridae sp. ctVFN1 | 2827575 | Viruses | Viruses | 52.8 | 0.018 | NTclustered | gi|2051148227|tpg|BK015874.1| | 2827575 | g91549 | i0 | 100 | 0.137931034482759 | 28 | 0 | 14 | 0 | 97 | 124 | 2365 | 2338 | MAG TPA_asm: Siphoviridae sp. ctVFN1, partial genome | blastn | 28 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Siphoviridae sp. ctVFN1 | |||||
| 14740847 | 14740847 | PRJNA725806_P_NODE_147812_length_170_cov_0.977444_g147510_i0 | PRJNA725806 | 147812 | 170 | 0.977444 | 1.6616548 | Aeromonas phage ACP1 | 3141444 | Viruses | Viruses | 52.8 | 0.014 | NTclustered | gi|2722346426|gb|PP601403.1| | 3141444 | g147510 | i0 | 100 | 0.164705882352941 | 28 | 0 | 16 | 0 | 90 | 117 | 147846 | 147873 | Aeromonas phage ACP1, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Chimalliviridae | Ferozepurvirus | Aeromonas phage ACP1 | |||
| 14741010 | 14741010 | PRJNA725806_P_NODE_58112_length_237_cov_4.610000_g57815_i0 | PRJNA725806 | 58112 | 237 | 4.61 | 10.9257 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|2054794199|tpg|BK049981.1| | 2832643 | g57815 | i0 | 100 | 0.126582278481013 | 30 | 0 | 13 | 0 | 109 | 138 | 12020 | 11991 | MAG TPA_asm: Caudoviricetes sp. isolate ctKXv3, partial genome | blastn | 30 | 56.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 16014261 | 16014261 | PRJNA725806_P_NODE_141113_length_173_cov_1.727941_g140811_i0 | PRJNA725806 | 141113 | 173 | 1.727941 | 2.98933793 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 320 | 3.61e-83 | NTclustered | gi|2053036246|tpg|BK024160.1| | 2832643 | g140811 | i0 | 100 | 6.93063583815029 | 173 | 0 | 100 | 0 | 1 | 173 | 6986 | 6814 | MAG TPA_asm: Caudoviricetes sp. isolate ct1rL2, partial genome | blastn | 1199 | 320 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17772178 | 17772178 | PRJNA725806_P_NODE_190314_length_152_cov_1.678261_g190012_i0 | PRJNA725806 | 190314 | 152 | 1.678261 | 2.55095672 | root | 1 | Root_unresolved | Root_unresolved | 281 | 1.46e-71 | NTclustered | gi|1043841560|gb|KX227759.1| | 1868600 | g190012 | i0 | 100 | 4.97368421052632 | 152 | 0 | 100 | 0 | 1 | 152 | 14079 | 13928 | Bacillus phage PfIS075, complete genome | blastn | 756 | 281 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Cecivirus | Bacillus phage PfIS075 | ||||
| 18563708 | 18563708 | PRJNA725806_P_NODE_58435_length_237_cov_1.865000_g58138_i0 | PRJNA725806 | 58435 | 237 | 1.865 | 4.42005 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 424 | 3.91e-114 | NTclustered | gi|2057844767|tpg|BK055780.1| | 2832643 | g58138 | i0 | 100 | 0.966244725738397 | 229 | 0 | 97 | 0 | 1 | 229 | 39512 | 39284 | MAG TPA_asm: Caudoviricetes sp. isolate ctvEa3, partial genome | blastn | 229 | 424 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19838722 | 19838722 | PRJNA725806_P_NODE_143276_length_172_cov_1.518519_g142974_i0 | PRJNA725806 | 143276 | 172 | 1.518519 | 2.61185268 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 318 | 1.2899999999999999e-82 | NTclustered | gi|2053036246|tpg|BK024160.1| | 2832643 | g142974 | i0 | 100 | 1.96511627906977 | 172 | 0 | 100 | 0 | 1 | 172 | 2557 | 2728 | MAG TPA_asm: Caudoviricetes sp. isolate ct1rL2, partial genome | blastn | 338 | 318 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19838747 | 19838747 | PRJNA725806_P_NODE_158156_length_165_cov_1.742188_g157854_i0 | PRJNA725806 | 158156 | 165 | 1.742188 | 2.8746102 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 305 | 9.59e-79 | NTclustered | gi|2053036246|tpg|BK024160.1| | 2832643 | g157854 | i0 | 100 | 2.85454545454545 | 165 | 0 | 100 | 0 | 1 | 165 | 7357 | 7193 | MAG TPA_asm: Caudoviricetes sp. isolate ct1rL2, partial genome | blastn | 471 | 305 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19838855 | 19838855 | PRJNA725806_P_NODE_42296_length_261_cov_3.357143_g41999_i0 | PRJNA725806 | 42296 | 261 | 3.357143 | 8.76214323 | Cellubavirus phi19una | 2955598 | Viruses | Viruses | 52.8 | 0.024 | NTclustered | gi|514341027|gb|KC821607.1| | 1327970 | g41999 | i0 | 100 | 0.21455938697318 | 28 | 0 | 11 | 0 | 27 | 54 | 17105 | 17132 | Cellulophaga phage phi19:1, complete genome | blastn | 56 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Assiduviridae | Cellubavirus | Cellubavirus phi19una | |||
| 19838862 | 19838862 | PRJNA725806_P_NODE_45696_length_255_cov_6.197248_g45399_i0 | PRJNA725806 | 45696 | 255 | 6.197248 | 15.8029824 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|2057823996|tpg|BK055407.1| | 2832643 | g45399 | i0 | 100 | 0.113725490196078 | 29 | 0 | 11 | 0 | 124 | 152 | 8130 | 8158 | MAG TPA_asm: Caudoviricetes sp. isolate ctWmQ20, partial genome | blastn | 29 | 54.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19838943 | 19838943 | PRJNA725806_P_NODE_83576_length_210_cov_4.606936_g83275_i0 | PRJNA725806 | 83576 | 210 | 4.606936 | 9.6745656 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 316 | 5.92e-82 | NTclustered | gi|2053036246|tpg|BK024160.1| | 2832643 | g83275 | i0 | 99.425 | 2.42857142857143 | 174 | 1 | 83 | 0 | 21 | 194 | 7015 | 7188 | MAG TPA_asm: Caudoviricetes sp. isolate ct1rL2, partial genome | blastn | 510 | 316 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 22389159 | 22389159 | PRJNA725806_P_NODE_123878_length_182_cov_2.393103_g123576_i0 | PRJNA725806 | 123878 | 182 | 2.393103 | 4.35544746 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 231 | 1.85e-56 | NTclustered | gi|2914914457|gb|OR221253.1| | 2832643 | g123576 | i0 | 93.548 | 0.851648351648352 | 155 | 10 | 85 | 0 | 21 | 175 | 16814 | 16660 | MAG: Caudoviricetes sp. isolate MSP1863 genomic sequence | blastn | 155 | 231 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 22389324 | 22389324 | PRJNA725806_P_NODE_32658_length_281_cov_1.106557_g32361_i0 | PRJNA725806 | 32658 | 281 | 1.106557 | 3.10942517 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 520 | 5.909999999999999e-143 | NTclustered | gi|2053036246|tpg|BK024160.1| | 2832643 | g32361 | i0 | 100 | 6.76868327402135 | 281 | 0 | 100 | 0 | 1 | 281 | 1650 | 1370 | MAG TPA_asm: Caudoviricetes sp. isolate ct1rL2, partial genome | blastn | 1902 | 520 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 22389378 | 22389378 | PRJNA725806_P_NODE_57718_length_238_cov_1.363184_g57421_i0 | PRJNA725806 | 57718 | 238 | 1.363184 | 3.24437792 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 396 | 8.5699999999999955e-106 | NTclustered | gi|2059809337|tpg|BK039825.1| | 2832643 | g57421 | i0 | 96.639 | 99.5966386554622 | 238 | 8 | 100 | 0 | 1 | 238 | 16503 | 16740 | MAG TPA_asm: Caudoviricetes sp. isolate ctEoK3, partial genome | blastn | 23704 | 396 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 23664766 | 23664766 | PRJNA725806_P_NODE_130719_length_178_cov_4.177305_g130417_i0 | PRJNA725806 | 130719 | 178 | 4.177305 | 7.4356029 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 52.8 | 0.015 | NTclustered | gi|2056785176|tpg|BK056997.1| | 2832643 | g130417 | i0 | 100 | 0.157303370786517 | 28 | 0 | 16 | 0 | 115 | 142 | 115634 | 115607 | MAG TPA_asm: Caudoviricetes sp. isolate ctmrE8, partial genome | blastn | 28 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 24938470 | 24938470 | PRJNA725806_P_NODE_80900_length_212_cov_10.611429_g80599_i0 | PRJNA725806 | 80900 | 212 | 10.611429 | 22.49622948 | Staphylococcus phage BSwM-KMM1 | 3003612 | Viruses | Viruses | 52.8 | 0.019 | NTclustered | gi|2419109170|gb|OP902294.1| | 3003612 | g80599 | i0 | 100 | 0.132075471698113 | 28 | 0 | 13 | 0 | 102 | 129 | 105847 | 105820 | Staphylococcus phage BSwM-KMM1, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Staphylococcus phage BSwM-KMM1 |
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);;