contig_metadata
24 rows where analysis = "blastn", bioproject = "PRJNA685607" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 666242 | 666242 | PRJNA685607_P_NODE_10261_length_487_cov_1.760870_g9905_i0 | PRJNA685607 | 10261 | 487 | 1.76087 | 8.5754369 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 881 | 0 | NTclustered | gi|2053215695|tpg|BK017244.1| | 2832643 | g9905 | i0 | 99.587 | 2.3347022587269 | 484 | 1 | 99 | 1 | 5 | 487 | 9006 | 9489 | MAG TPA_asm: Caudoviricetes sp. isolate ct0cU1, partial genome | blastn | 1137 | 881 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 666348 | 666348 | PRJNA685607_P_NODE_53741_length_271_cov_1.196970_g53382_i0 | PRJNA685607 | 53741 | 271 | 1.19697 | 3.2437887 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 490 | 4.44e-134 | NTclustered | gi|2053215695|tpg|BK017244.1| | 2832643 | g53382 | i0 | 99.265 | 2.00369003690037 | 272 | 1 | 100 | 1 | 1 | 271 | 7455 | 7184 | MAG TPA_asm: Caudoviricetes sp. isolate ct0cU1, partial genome | blastn | 543 | 490 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 3217343 | 3217343 | PRJNA685607_P_NODE_843_length_1772_cov_3.321954_g733_i0 | PRJNA685607 | 843 | 1772 | 3.321954 | 58.86502488 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 1038 | 0 | NTclustered | gi|2053204594|tpg|BK017036.1| | 2832643 | g733 | i0 | 90.482 | 20.22460496614 | 788 | 74 | 51 | 1 | 99 | 886 | 1790 | 1004 | MAG TPA_asm: Caudoviricetes sp. isolate ctgJ31, partial genome | blastn | 35838 | 1038 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 4494169 | 4494169 | PRJNA685607_P_NODE_10324_length_486_cov_1.631961_g9968_i0 | PRJNA685607 | 10324 | 486 | 1.631961 | 7.93133046 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 226 | 2.64e-54 | NTclustered | gi|2915016412|gb|OR222523.1| | 2832643 | g9968 | i0 | 84.416 | 7.21604938271605 | 231 | 34 | 47 | 2 | 257 | 486 | 58425 | 58196 | MAG: Caudoviricetes sp. isolate MSP0418 genomic sequence | blastn | 3507 | 226 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 4494374 | 4494374 | PRJNA685607_P_NODE_79124_length_246_cov_1.335260_g78765_i0 | PRJNA685607 | 79124 | 246 | 1.33526 | 3.2847396 | Siphoviridae sp. ctGO42 | 2827566 | Viruses | Viruses | 283 | 7.239999999999999e-72 | NTclustered | gi|2051147051|tpg|BK015857.1| | 2827566 | g78765 | i0 | 87.398 | 1 | 246 | 31 | 100 | 0 | 1 | 246 | 28294 | 28049 | MAG TPA_asm: Siphoviridae sp. ctGO42, partial genome | blastn | 246 | 283 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Siphoviridae sp. ctGO42 | |||||
| 5769930 | 5769930 | PRJNA685607_P_NODE_43085_length_293_cov_0.818182_g42726_i0 | PRJNA685607 | 43085 | 293 | 0.818182 | 2.39727326 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 503 | 6.24e-138 | NTclustered | gi|2053215695|tpg|BK017244.1| | 2832643 | g42726 | i0 | 97.611 | 4.43003412969283 | 293 | 7 | 100 | 0 | 1 | 293 | 8181 | 7889 | MAG TPA_asm: Caudoviricetes sp. isolate ct0cU1, partial genome | blastn | 1298 | 503 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 5769950 | 5769950 | PRJNA685607_P_NODE_5205_length_677_cov_1.955298_g4866_i0 | PRJNA685607 | 5205 | 677 | 1.955298 | 13.23736746 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 1234 | 0 | NTclustered | gi|2053215695|tpg|BK017244.1| | 2832643 | g4866 | i0 | 99.557 | 60.2644017725259 | 677 | 3 | 100 | 0 | 1 | 677 | 17108 | 16432 | MAG TPA_asm: Caudoviricetes sp. isolate ct0cU1, partial genome | blastn | 40799 | 1234 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 8319508 | 8319508 | PRJNA685607_P_NODE_67627_length_250_cov_1.084746_g67268_i0 | PRJNA685607 | 67627 | 250 | 1.084746 | 2.711865 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 315 | 2.62e-81 | NTclustered | gi|2057869940|tpg|BK050661.1| | 2832643 | g67268 | i0 | 89.516 | 5.248 | 248 | 26 | 99 | 0 | 3 | 250 | 1177 | 930 | MAG TPA_asm: Caudoviricetes sp. isolate ct0Ww2, partial genome | blastn | 1312 | 315 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 8319556 | 8319556 | PRJNA685607_P_NODE_76747_length_247_cov_0.885057_g76388_i0 | PRJNA685607 | 76747 | 247 | 0.885057 | 2.18609079 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 409 | 1.1499999999999998e-109 | NTclustered | gi|2054683533|tpg|BK052657.1| | 2832643 | g76388 | i0 | 96.735 | 4.96761133603239 | 245 | 8 | 99 | 0 | 1 | 245 | 19770 | 19526 | MAG TPA_asm: Caudoviricetes sp. isolate ctIBL2, partial genome | blastn | 1227 | 409 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 8319653 | 8319653 | PRJNA685607_P_NODE_96547_length_241_cov_0.916667_g96188_i0 | PRJNA685607 | 96547 | 241 | 0.916667 | 2.20916747 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 329 | 8.95e-86 | NTclustered | gi|2915033327|gb|OR222674.1| | 2832643 | g96188 | i0 | 91.286 | 1 | 241 | 21 | 100 | 0 | 1 | 241 | 96766 | 97006 | MAG: Caudoviricetes sp. isolate MSP0256 genomic sequence | blastn | 241 | 329 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 9594877 | 9594877 | PRJNA685607_P_NODE_27908_length_337_cov_2.920455_g27549_i0 | PRJNA685607 | 27908 | 337 | 2.920455 | 9.84193335 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 623 | 5.369999999999999e-174 | NTclustered | gi|2053220447|tpg|BK017336.1| | 2832643 | g27549 | i0 | 100 | 99.2908011869436 | 337 | 0 | 100 | 0 | 1 | 337 | 1648 | 1312 | MAG TPA_asm: Caudoviricetes sp. isolate ctjqC1, partial genome | blastn | 33461 | 623 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14695210 | 14695210 | PRJNA685607_P_NODE_1912_length_1172_cov_2.255687_g1696_i0 | PRJNA685607 | 1912 | 1172 | 2.255687 | 26.43665164 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 1965 | 0 | NTclustered | gi|2053215695|tpg|BK017244.1| | 2832643 | g1696 | i0 | 96.928 | 34.4317406143345 | 1172 | 36 | 100 | 0 | 1 | 1172 | 5651 | 6822 | MAG TPA_asm: Caudoviricetes sp. isolate ct0cU1, partial genome | blastn | 40354 | 1965 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14695266 | 14695266 | PRJNA685607_P_NODE_38432_length_304_cov_1.445887_g38073_i0 | PRJNA685607 | 38432 | 304 | 1.445887 | 4.39549648 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 529 | 1.0699999999999996e-145 | NTclustered | gi|2053215695|tpg|BK017244.1| | 2832643 | g38073 | i0 | 98.026 | 53.9276315789474 | 304 | 6 | 100 | 0 | 1 | 304 | 15893 | 16196 | MAG TPA_asm: Caudoviricetes sp. isolate ct0cU1, partial genome | blastn | 16394 | 529 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14695306 | 14695306 | PRJNA685607_P_NODE_52352_length_273_cov_2.235000_g51993_i0 | PRJNA685607 | 52352 | 273 | 2.235 | 6.10155 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 488 | 1.6099999999999996e-133 | NTclustered | gi|2053220447|tpg|BK017336.1| | 2832643 | g51993 | i0 | 98.901 | 29.2234432234432 | 273 | 3 | 100 | 0 | 1 | 273 | 1666 | 1938 | MAG TPA_asm: Caudoviricetes sp. isolate ctjqC1, partial genome | blastn | 7978 | 488 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 15968991 | 15968991 | PRJNA685607_P_NODE_35593_length_312_cov_1.326360_g35234_i0 | PRJNA685607 | 35593 | 312 | 1.32636 | 4.1382432 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 555 | 1.8199999999999994e-153 | NTclustered | gi|2053220447|tpg|BK017336.1| | 2832643 | g35234 | i0 | 98.718 | 32.1121794871795 | 312 | 4 | 100 | 0 | 1 | 312 | 1021 | 1332 | MAG TPA_asm: Caudoviricetes sp. isolate ctjqC1, partial genome | blastn | 10019 | 555 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18518430 | 18518430 | PRJNA685607_P_NODE_54175_length_270_cov_1.385787_g53816_i0 | PRJNA685607 | 54175 | 270 | 1.385787 | 3.7416249 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 453 | 5.810000000000001e-123 | NTclustered | gi|2053215695|tpg|BK017244.1| | 2832643 | g53816 | i0 | 98.077 | 3.81851851851852 | 260 | 5 | 96 | 0 | 11 | 270 | 8535 | 8794 | MAG TPA_asm: Caudoviricetes sp. isolate ct0cU1, partial genome | blastn | 1031 | 453 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18518449 | 18518449 | PRJNA685607_P_NODE_60715_length_258_cov_1.302703_g60356_i0 | PRJNA685607 | 60715 | 258 | 1.302703 | 3.36097374 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 460 | 3.29e-125 | NTclustered | gi|2914973405|gb|OR222057.1| | 2832643 | g60356 | i0 | 98.837 | 26.3643410852713 | 258 | 3 | 100 | 0 | 1 | 258 | 113179 | 113436 | MAG: Caudoviricetes sp. isolate MSP0058 genomic sequence | blastn | 6802 | 460 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19027909 | 19027909 | PRJNA685607_P_NODE_21075_length_370_cov_1.037037_g20717_i0 | PRJNA685607 | 21075 | 370 | 1.037037 | 3.8370369 | Pahexavirus | 1982251 | Viruses | Viruses | 606 | 5.979999999999998e-169 | NTclustered | gi|849122411|ref|NC_027400.1| | 1500802 | g20717 | i0 | 96.216 | 100.135135135135 | 370 | 14 | 100 | 0 | 1 | 370 | 4261 | 4630 | Propionibacterium phage PHL055N00, complete genome | blastn | 37050 | 606 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Pahexavirus PHL117M00 | ||||
| 19793238 | 19793238 | PRJNA685607_P_NODE_3116_length_889_cov_2.555147_g2832_i0 | PRJNA685607 | 3116 | 889 | 2.555147 | 22.71525683 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 1410 | 0 | NTclustered | gi|2053214783|tpg|BK017231.1| | 2832643 | g2832 | i0 | 95.276 | 101.665916760405 | 889 | 42 | 100 | 0 | 1 | 889 | 14835 | 15723 | MAG TPA_asm: Caudoviricetes sp. isolate ctWXE1, partial genome | blastn | 90381 | 1410 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 21068678 | 21068678 | PRJNA685607_P_NODE_17957_length_391_cov_1.399371_g17599_i0 | PRJNA685607 | 17957 | 391 | 1.399371 | 5.47154061 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 553 | 8.409999999999998e-153 | NTclustered | gi|2053220447|tpg|BK017336.1| | 2832643 | g17599 | i0 | 92.288 | 23.7493606138107 | 389 | 30 | 99 | 0 | 3 | 391 | 2122 | 2510 | MAG TPA_asm: Caudoviricetes sp. isolate ctjqC1, partial genome | blastn | 9286 | 553 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 21068742 | 21068742 | PRJNA685607_P_NODE_40677_length_298_cov_3.217778_g40318_i0 | PRJNA685607 | 40677 | 298 | 3.217778 | 9.58897844 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 473 | 4.9899999999999996e-129 | NTclustered | gi|2053215695|tpg|BK017244.1| | 2832643 | g40318 | i0 | 95.302 | 81.7315436241611 | 298 | 14 | 100 | 0 | 1 | 298 | 13962 | 13665 | MAG TPA_asm: Caudoviricetes sp. isolate ct0cU1, partial genome | blastn | 24356 | 473 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 22343543 | 22343543 | PRJNA685607_P_NODE_20498_length_373_cov_1.826667_g20140_i0 | PRJNA685607 | 20498 | 373 | 1.826667 | 6.81346791 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 617 | 2.79e-172 | NTclustered | gi|2914755044|gb|OR221481.1| | 2832643 | g20140 | i0 | 96.515 | 71.8257372654156 | 373 | 13 | 100 | 0 | 1 | 373 | 12630 | 12258 | MAG: Caudoviricetes sp. isolate MSP1601 genomic sequence | blastn | 26791 | 617 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 22343622 | 22343622 | PRJNA685607_P_NODE_5218_length_676_cov_2.139303_g4879_i0 | PRJNA685607 | 5218 | 676 | 2.139303 | 14.46168828 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 1149 | 0 | NTclustered | gi|2053215695|tpg|BK017244.1| | 2832643 | g4879 | i0 | 97.337 | 12.7899408284024 | 676 | 18 | 100 | 0 | 1 | 676 | 48537 | 49212 | MAG TPA_asm: Caudoviricetes sp. isolate ct0cU1, partial genome | blastn | 8646 | 1149 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 23619181 | 23619181 | PRJNA685607_P_NODE_46559_length_285_cov_1.353774_g46200_i0 | PRJNA685607 | 46559 | 285 | 1.353774 | 3.8582559 | Klebsiella phage vB_Kpn_HF0522 | 3158833 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|2743645575|gb|PP836776.1| | 3158833 | g46200 | i0 | 87.5 | 0.575438596491228 | 48 | 6 | 17 | 0 | 121 | 168 | 13564 | 13517 | Klebsiella phage vB_Kpn_HF0522, complete genome | blastn | 164 | 56.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Klebsiella phage vB_Kpn_HF0522 |
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);;