contig_metadata
27 rows where analysis = "blastn", bioproject = "PRJNA763243" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 743010 | 743010 | PRJNA763243_P_NODE_28301_length_310_cov_9.312236_g27955_i0 | PRJNA763243 | 28301 | 310 | 9.312236 | 28.8679316 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 272 | 2.04e-68 | NTclustered | gi|2057844767|tpg|BK055780.1| | 2832643 | g27955 | i0 | 100 | 1.88387096774194 | 147 | 0 | 94 | 0 | 4 | 150 | 21304 | 21158 | MAG TPA_asm: Caudoviricetes sp. isolate ctvEa3, partial genome | blastn | 584 | 272 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 743907 | 743907 | PRJNA763243_P_NODE_66441_length_233_cov_5.325000_g66095_i0 | PRJNA763243 | 66441 | 233 | 5.325 | 12.40725 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 379 | 8.419999999999998e-101 | NTclustered | gi|2057001417|tpg|BK048508.1| | 2832643 | g66095 | i0 | 100 | 2.63948497854077 | 205 | 0 | 88 | 0 | 4 | 208 | 41609 | 41405 | MAG TPA_asm: Caudoviricetes sp. isolate ctVdO5, partial genome | blastn | 615 | 379 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 1205213 | 1205213 | PRJNA763243_P_NODE_65381_length_236_cov_43.969325_g65035_i0 | PRJNA763243 | 65381 | 236 | 43.969325 | 103.767607 | Viruses | 10239 | Viruses | Viruses | 377 | 3.07e-100 | NTclustered | gi|2051134411|tpg|BK015605.1| | 2825632 | g65035 | i0 | 96.889 | 12.3559322033898 | 225 | 7 | 95 | 0 | 10 | 234 | 28977 | 29201 | MAG TPA_asm: Siphoviridae sp. ctjOC2, partial genome | blastn | 2916 | 377 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Siphoviridae sp. ctjOC2 | |||||
| 4571923 | 4571923 | PRJNA763243_P_NODE_52664_length_250_cov_1.728814_g52318_i0 | PRJNA763243 | 52664 | 250 | 1.728814 | 4.322035 | Stenotrophomonas phage CUB19 | 2976424 | Viruses | Viruses | 279 | 9.54e-71 | NTclustered | gi|2295670668|gb|OM638088.1| | 2976424 | g52318 | i0 | 95.429 | 0.7 | 175 | 8 | 70 | 0 | 1 | 175 | 12620 | 12446 | Stenotrophomonas phage CUB19, complete genome | blastn | 175 | 279 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Stenotrophomonas phage CUB19 | |||||
| 4572035 | 4572035 | PRJNA763243_P_NODE_57484_length_246_cov_0.890173_g57138_i0 | PRJNA763243 | 57484 | 246 | 0.890173 | 2.18982558 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 370 | 5.399999999999999e-98 | NTclustered | gi|2914835023|gb|OR222652.1| | 2832643 | g57138 | i0 | 99.507 | 1.97967479674797 | 203 | 1 | 98 | 0 | 4 | 206 | 60206 | 60408 | MAG: Caudoviricetes sp. isolate MSP0277 genomic sequence | blastn | 487 | 370 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 5846872 | 5846872 | PRJNA763243_P_NODE_41305_length_273_cov_10.955000_g40959_i0 | PRJNA763243 | 41305 | 273 | 10.955 | 29.90715 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 460 | 3.5099999999999996e-125 | NTclustered | gi|2057792286|tpg|BK054883.1| | 2832643 | g40959 | i0 | 97.77 | 5.81684981684982 | 269 | 3 | 97 | 2 | 4 | 269 | 6565 | 6833 | MAG TPA_asm: Caudoviricetes sp. isolate ct0zZ12, partial genome | blastn | 1588 | 460 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 5847539 | 5847539 | PRJNA763243_P_NODE_69585_length_222_cov_15.892617_g69239_i0 | PRJNA763243 | 69585 | 222 | 15.892617 | 35.28160974 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 324 | 3.78e-84 | NTclustered | gi|2914991802|gb|OR222194.1| | 2832643 | g69239 | i0 | 93.925 | 0.963963963963964 | 214 | 13 | 96 | 0 | 3 | 216 | 22126 | 21913 | MAG: Caudoviricetes sp. isolate MSP0777 genomic sequence | blastn | 214 | 324 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 6309243 | 6309243 | PRJNA763243_P_NODE_29305_length_310_cov_3.649789_g28959_i0 | PRJNA763243 | 29305 | 310 | 3.649789 | 11.3143459 | Viruses | 10239 | Viruses | Viruses | 252 | 2.6599999999999997e-62 | NTclustered | gi|2051095971|tpg|BK014934.1| | 2826396 | g28959 | i0 | 97.931 | 15.3838709677419 | 145 | 3 | 94 | 0 | 4 | 148 | 3014 | 3158 | MAG TPA_asm: Siphoviridae sp. ctckx14, partial genome | blastn | 4769 | 252 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Siphoviridae sp. ctckx14 | |||||
| 6309371 | 6309371 | PRJNA763243_P_NODE_68265_length_227_cov_14.980519_g67919_i0 | PRJNA763243 | 68265 | 227 | 14.980519 | 34.00577813 | Moineauvirus | 1623304 | Viruses | Viruses | 414 | 2.2399999999999998e-111 | NTclustered | gi|15077558|gb|AF348739.1| | 152561 | g67919 | i0 | 100 | 86.9383259911894 | 224 | 0 | 99 | 0 | 4 | 227 | 695 | 472 | Streptococcus thermophilus bacteriophage DT2 host specificity protein gene, complete cds | blastn | 19735 | 414 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Streptococcus phage DT2 | |||||
| 7121810 | 7121810 | PRJNA763243_P_NODE_30466_length_307_cov_6.688034_g30120_i0 | PRJNA763243 | 30466 | 307 | 6.688034 | 20.53226438 | Maltschvirus maltsch | 2956182 | Viruses | Viruses | 207 | 5.78e-49 | NTclustered | gi|1839155436|emb|LR796392.1| | 2100421 | g30120 | i0 | 78.333 | 1.07817589576547 | 300 | 59 | 96 | 6 | 5 | 299 | 2258 | 1960 | uncultured Caudovirales phage genome assembly | blastn | 331 | 207 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 9672326 | 9672326 | PRJNA763243_P_NODE_65768_length_235_cov_11.135802_g65422_i0 | PRJNA763243 | 65768 | 235 | 11.135802 | 26.1691347 | Hiroshimavirus PPpW3 | 3060034 | Viruses | Viruses | 163 | 9.33e-36 | NTclustered | gi|564292481|ref|NC_023006.1| | 1279082 | g65422 | i0 | 79.911 | 0.953191489361702 | 224 | 43 | 95 | 2 | 13 | 235 | 6761 | 6539 | Pseudomonas phage PPpW-3 DNA, complete sequence | blastn | 224 | 163 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Hiroshimavirus | Hiroshimavirus PPpW3 | ||||
| 10948050 | 10948050 | PRJNA763243_P_NODE_67109_length_231_cov_3.297468_g66763_i0 | PRJNA763243 | 67109 | 231 | 3.297468 | 7.61715108 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 159 | 1.18e-34 | NTclustered | gi|2914810319|gb|OR221740.1| | 2832643 | g66763 | i0 | 91.379 | 1.00865800865801 | 116 | 10 | 50 | 0 | 4 | 119 | 45360 | 45475 | MAG: Caudoviricetes sp. isolate MSP1300 genomic sequence | blastn | 233 | 159 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 10948234 | 10948234 | PRJNA763243_P_NODE_75229_length_197_cov_6.185484_g74883_i0 | PRJNA763243 | 75229 | 197 | 6.185484 | 12.18540348 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 320 | 4.24e-83 | NTclustered | gi|2914935548|gb|OR221652.1| | 2832643 | g74883 | i0 | 96.41 | 2.96954314720812 | 195 | 6 | 98 | 1 | 1 | 194 | 13829 | 14023 | MAG: Caudoviricetes sp. isolate MSP1401 genomic sequence | blastn | 585 | 320 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 12222670 | 12222670 | PRJNA763243_P_NODE_28710_length_310_cov_5.970464_g28364_i0 | PRJNA763243 | 28710 | 310 | 5.970464 | 18.5084384 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 492 | 1.44e-134 | NTclustered | gi|2059817983|tpg|BK039955.1| | 2832643 | g28364 | i0 | 96.091 | 1.98064516129032 | 307 | 2 | 99 | 1 | 1 | 307 | 20545 | 20841 | MAG TPA_asm: Caudoviricetes sp. isolate ct2xH1, partial genome | blastn | 614 | 492 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14772906 | 14772906 | PRJNA763243_P_NODE_70212_length_219_cov_9.856164_g69866_i0 | PRJNA763243 | 70212 | 219 | 9.856164 | 21.58499916 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 350 | 6.139999999999999e-92 | NTclustered | gi|2056819322|tpg|BK057663.1| | 2832643 | g69866 | i0 | 96.667 | 12.4246575342466 | 210 | 7 | 96 | 0 | 4 | 213 | 13686 | 13895 | MAG TPA_asm: Caudoviricetes sp. isolate ctnRd19, partial genome | blastn | 2721 | 350 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 16045987 | 16045987 | PRJNA763243_P_NODE_42193_length_271_cov_4.353535_g41847_i0 | PRJNA763243 | 42193 | 271 | 4.353535 | 11.79807985 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 171 | 6.58e-38 | NTclustered | gi|2915039099|gb|OR222716.1| | 2832643 | g41847 | i0 | 80.617 | 4.19188191881919 | 227 | 38 | 83 | 6 | 46 | 269 | 18179 | 18402 | MAG: Caudoviricetes sp. isolate MSP0645 genomic sequence | blastn | 1136 | 171 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 16508196 | 16508196 | PRJNA763243_P_NODE_66373_length_233_cov_13.237500_g66027_i0 | PRJNA763243 | 66373 | 233 | 13.2375 | 30.843375 | Pahexavirus | 1982251 | Viruses | Viruses | 279 | 8.79e-71 | NTclustered | gi|543171494|ref|NC_022339.1| | 1235646 | g66027 | i0 | 89.035 | 71.4034334763949 | 228 | 22 | 97 | 3 | 1 | 227 | 27315 | 27540 | Propionibacterium phage PHL037M02, complete genome | blastn | 16637 | 279 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Pahexavirus PHL037M02 | ||||
| 17321573 | 17321573 | PRJNA763243_P_NODE_38754_length_280_cov_1.487923_g38408_i0 | PRJNA763243 | 38754 | 280 | 1.487923 | 4.1661844 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 372 | 1.7399999999999995e-98 | NTclustered | gi|2914972312|gb|OR222040.1| | 2832643 | g38408 | i0 | 91.76 | 93.1107142857143 | 267 | 22 | 95 | 0 | 9 | 275 | 53363 | 53097 | MAG: Caudoviricetes sp. isolate MSP0074 genomic sequence | blastn | 26071 | 372 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17322370 | 17322370 | PRJNA763243_P_NODE_73414_length_204_cov_17.694656_g73068_i0 | PRJNA763243 | 73414 | 204 | 17.694656 | 36.09709824 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 350 | 5.64e-92 | NTclustered | gi|2054679236|tpg|BK052569.1| | 2832643 | g73068 | i0 | 98.02 | 32.4705882352941 | 202 | 2 | 99 | 2 | 2 | 202 | 4590 | 4390 | MAG TPA_asm: Caudoviricetes sp. isolate ctPHR8, partial genome | blastn | 6624 | 350 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18594638 | 18594638 | PRJNA763243_P_NODE_28075_length_310_cov_14.573840_g27729_i0 | PRJNA763243 | 28075 | 310 | 14.57384 | 45.178904 | Siphoviridae sp. ctGO42 | 2827566 | Viruses | Viruses | 449 | 8.790000000000001e-122 | NTclustered | gi|2051147051|tpg|BK015857.1| | 2827566 | g27729 | i0 | 92.834 | 19.0709677419355 | 307 | 17 | 99 | 1 | 3 | 309 | 21143 | 20842 | MAG TPA_asm: Siphoviridae sp. ctGO42, partial genome | blastn | 5912 | 449 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Siphoviridae sp. ctGO42 | |||||
| 21146046 | 21146046 | PRJNA763243_P_NODE_48037_length_258_cov_3.108108_g47691_i0 | PRJNA763243 | 48037 | 258 | 3.108108 | 8.01891864 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 54.7 | 0.007 | NTclustered | gi|2914804331|gb|OR221397.1| | 2832643 | g47691 | i0 | 100 | 0.112403100775194 | 29 | 0 | 11 | 0 | 224 | 252 | 40470 | 40498 | MAG: Caudoviricetes sp. isolate MSP1701 genomic sequence | blastn | 29 | 54.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 21146214 | 21146214 | PRJNA763243_P_NODE_55777_length_247_cov_4.252874_g55431_i0 | PRJNA763243 | 55777 | 247 | 4.252874 | 10.50459878 | Pseudomonas phage KV2023 | 3234047 | Viruses | Viruses | 418 | 1.9099999999999998e-112 | NTclustered | gi|2780157563|gb|PP949967.1| | 3234047 | g55431 | i0 | 97.166 | 41.4574898785425 | 247 | 7 | 100 | 0 | 1 | 247 | 27682 | 27928 | Pseudomonas phage KV2023, complete genome | blastn | 10240 | 418 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Bruynoghevirus | Pseudomonas phage KV2023 | ||||
| 22420300 | 22420300 | PRJNA763243_P_NODE_28518_length_310_cov_7.122363_g28172_i0 | PRJNA763243 | 28518 | 310 | 7.122363 | 22.0793253 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 222 | 2.09e-53 | NTclustered | gi|2914792039|gb|OR222787.1| | 2832643 | g28172 | i0 | 93.333 | 0.941935483870968 | 150 | 10 | 94 | 0 | 161 | 310 | 51653 | 51504 | MAG: Caudoviricetes sp. isolate MSP0571 genomic sequence | blastn | 292 | 222 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 22421223 | 22421223 | PRJNA763243_P_NODE_68258_length_227_cov_17.019481_g67912_i0 | PRJNA763243 | 68258 | 227 | 17.019481 | 38.63422187 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 355 | 1.38e-93 | NTclustered | gi|2054738030|tpg|BK038877.1| | 2832643 | g67912 | i0 | 95.89 | 29.2511013215859 | 219 | 9 | 96 | 0 | 6 | 224 | 8740 | 8522 | MAG TPA_asm: Caudoviricetes sp. isolate ctCHt9, partial genome | blastn | 6640 | 355 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 23696573 | 23696573 | PRJNA763243_P_NODE_54599_length_248_cov_6.542857_g54253_i0 | PRJNA763243 | 54599 | 248 | 6.542857 | 16.22628536 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 438 | 1.4699999999999995e-118 | NTclustered | gi|2057025667|tpg|BK048958.1| | 2832643 | g54253 | i0 | 99.583 | 3.87096774193548 | 240 | 1 | 97 | 0 | 6 | 245 | 18127 | 18366 | MAG TPA_asm: Caudoviricetes sp. isolate ctFbg5, partial genome | blastn | 960 | 438 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 24969642 | 24969642 | PRJNA763243_P_NODE_29180_length_310_cov_4.130802_g28834_i0 | PRJNA763243 | 29180 | 310 | 4.130802 | 12.8054862 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 375 | 1.5099999999999998e-99 | NTclustered | gi|2914887418|gb|OR222536.1| | 2832643 | g28834 | i0 | 87.385 | 2.09677419354839 | 325 | 24 | 99 | 11 | 3 | 310 | 40921 | 40597 | MAG: Caudoviricetes sp. isolate MSP0404 genomic sequence | blastn | 650 | 375 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 24970514 | 24970514 | PRJNA763243_P_NODE_66420_length_233_cov_6.612500_g66074_i0 | PRJNA763243 | 66420 | 233 | 6.6125 | 15.407125 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 399 | 6.459999999999998e-107 | NTclustered | gi|2058130956|tpg|BK034114.1| | 2832643 | g66074 | i0 | 97.845 | 0.995708154506438 | 232 | 4 | 99 | 1 | 3 | 233 | 2784 | 3015 | MAG TPA_asm: Caudoviricetes sp. isolate ctp3l1, partial genome | blastn | 232 | 399 | 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);;