contig_metadata
27 rows where analysis = "blastn", bioproject = "PRJNA1118794" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 231075 | 231075 | PRJNA1118794_P_NODE_72241_length_241_cov_1.732143_g71491_i0 | PRJNA1118794 | 72241 | 241 | 1.732143 | 4.17446463 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 440 | 3.959999999999999e-119 | NTclustered | gi|2057844767|tpg|BK055780.1| | 2832643 | g71491 | i0 | 99.585 | 1 | 241 | 1 | 100 | 0 | 1 | 241 | 39068 | 38828 | MAG TPA_asm: Caudoviricetes sp. isolate ctvEa3, partial genome | blastn | 241 | 440 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 1505271 | 1505271 | PRJNA1118794_P_NODE_24062_length_317_cov_1.405738_g23312_i0 | PRJNA1118794 | 24062 | 317 | 1.405738 | 4.45618946 | Pahexavirus P100A | 1982265 | Viruses | Viruses | 289 | 2.08e-73 | NTclustered | gi|408905833|ref|NC_018838.1| | 1229790 | g23312 | i0 | 83.234 | 76.3249211356467 | 334 | 36 | 99 | 16 | 1 | 316 | 27569 | 27900 | Propionibacterium phage P100_A, complete genome | blastn | 24195 | 289 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Pahexavirus P100A | ||||
| 2781523 | 2781523 | PRJNA1118794_P_NODE_63923_length_245_cov_0.895349_g63173_i0 | PRJNA1118794 | 63923 | 245 | 0.895349 | 2.19360505 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 52.8 | 0.022 | NTclustered | gi|2914792039|gb|OR222787.1| | 2832643 | g63173 | i0 | 100 | 0.114285714285714 | 28 | 0 | 11 | 0 | 89 | 116 | 28843 | 28870 | MAG: Caudoviricetes sp. isolate MSP0571 genomic sequence | blastn | 28 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 6608631 | 6608631 | PRJNA1118794_P_NODE_30186_length_292_cov_1.059361_g29436_i0 | PRJNA1118794 | 30186 | 292 | 1.059361 | 3.09333412 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 540 | 4.74e-149 | NTclustered | gi|2057844767|tpg|BK055780.1| | 2832643 | g29436 | i0 | 100 | 3 | 292 | 0 | 100 | 0 | 1 | 292 | 30766 | 30475 | MAG TPA_asm: Caudoviricetes sp. isolate ctvEa3, partial genome | blastn | 876 | 540 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 6608889 | 6608889 | PRJNA1118794_P_NODE_52226_length_250_cov_0.870056_g51476_i0 | PRJNA1118794 | 52226 | 250 | 0.870056 | 2.17514 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 462 | 8.83e-126 | NTclustered | gi|2057844767|tpg|BK055780.1| | 2832643 | g51476 | i0 | 100 | 1 | 250 | 0 | 100 | 0 | 1 | 250 | 35965 | 36214 | MAG TPA_asm: Caudoviricetes sp. isolate ctvEa3, partial genome | blastn | 250 | 462 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 7883734 | 7883734 | PRJNA1118794_P_NODE_47767_length_252_cov_1.720670_g47017_i0 | PRJNA1118794 | 47767 | 252 | 1.72067 | 4.3360884 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 466 | 6.89e-127 | NTclustered | gi|2914941530|gb|OR221752.1| | 2832643 | g47017 | i0 | 100 | 100.31746031746 | 252 | 0 | 100 | 0 | 1 | 252 | 35531 | 35782 | MAG: Caudoviricetes sp. isolate MSP1281 genomic sequence | blastn | 25280 | 466 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 10434365 | 10434365 | PRJNA1118794_P_NODE_54329_length_249_cov_0.875000_g53579_i0 | PRJNA1118794 | 54329 | 249 | 0.875 | 2.17875 | environmental Halophage eHP-42 | 1168845 | Viruses | Viruses | 52.8 | 0.023 | NTclustered | gi|968559666|gb|JQ807261.2| | 1168845 | g53579 | i0 | 100 | 0.112449799196787 | 28 | 0 | 11 | 0 | 220 | 247 | 5016 | 4989 | Environmental Halophage eHP-42, partial genome | blastn | 28 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Kirjokansivirales | Haloferuviridae | environmental Halophage eHP-42 | |||
| 10434507 | 10434507 | PRJNA1118794_P_NODE_66809_length_244_cov_0.900585_g66059_i0 | PRJNA1118794 | 66809 | 244 | 0.900585 | 2.1974274 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 451 | 1.86e-122 | NTclustered | gi|2057844767|tpg|BK055780.1| | 2832643 | g66059 | i0 | 100 | 2.20491803278689 | 244 | 0 | 100 | 0 | 1 | 244 | 19547 | 19304 | MAG TPA_asm: Caudoviricetes sp. isolate ctvEa3, partial genome | blastn | 538 | 451 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11709488 | 11709488 | PRJNA1118794_P_NODE_43250_length_262_cov_1.222222_g42500_i0 | PRJNA1118794 | 43250 | 262 | 1.222222 | 3.20222164 | Pahexavirus ouroboros | 1982259 | Viruses | Viruses | 455 | 1.56e-123 | NTclustered | gi|906476212|ref|NC_027630.1| | 1655017 | g42500 | i0 | 98.084 | 99.736641221374 | 261 | 5 | 99 | 0 | 1 | 261 | 2099 | 2359 | Propionibacterium phage Ouroboros, complete genome | blastn | 26131 | 455 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Pahexavirus ouroboros | ||||
| 11709491 | 11709491 | PRJNA1118794_P_NODE_43390_length_261_cov_2.053191_g42640_i0 | PRJNA1118794 | 43390 | 261 | 2.053191 | 5.35882851 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 481 | 2.56e-131 | NTclustered | gi|2057844767|tpg|BK055780.1| | 2832643 | g42640 | i0 | 100 | 1.99233716475096 | 260 | 0 | 99 | 0 | 1 | 260 | 8920 | 9179 | MAG TPA_asm: Caudoviricetes sp. isolate ctvEa3, partial genome | blastn | 520 | 481 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11709831 | 11709831 | PRJNA1118794_P_NODE_74130_length_241_cov_0.916667_g73380_i0 | PRJNA1118794 | 74130 | 241 | 0.916667 | 2.20916747 | Siphoviridae sp. ctHip2 | 2827830 | Viruses | Viruses | 440 | 3.959999999999999e-119 | NTclustered | gi|2052861377|tpg|BK032497.1| | 2827830 | g73380 | i0 | 99.585 | 3 | 241 | 1 | 100 | 0 | 1 | 241 | 143562 | 143322 | MAG TPA_asm: Siphoviridae sp. ctHip2, partial genome | blastn | 723 | 440 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Siphoviridae sp. ctHip2 | |||||
| 12984192 | 12984192 | PRJNA1118794_P_NODE_14411_length_382_cov_1.495146_g13661_i0 | PRJNA1118794 | 14411 | 382 | 1.495146 | 5.71145772 | Cutibacterium phage Ristretto | 3117545 | Viruses | Viruses | 346 | 1.49e-90 | NTclustered | gi|2664206023|gb|PP165414.1| | 3117545 | g13661 | i0 | 85.886 | 63.1675392670157 | 333 | 37 | 86 | 10 | 56 | 382 | 16678 | 17006 | Cutibacterium phage Ristretto, complete genome | blastn | 24130 | 346 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Cutibacterium phage Ristretto | ||||
| 12984199 | 12984199 | PRJNA1118794_P_NODE_14851_length_378_cov_1.000000_g14101_i0 | PRJNA1118794 | 14851 | 378 | 1 | 3.78 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 699 | 0 | NTclustered | gi|2057844767|tpg|BK055780.1| | 2832643 | g14101 | i0 | 100 | 2 | 378 | 0 | 100 | 0 | 1 | 378 | 26893 | 26516 | MAG TPA_asm: Caudoviricetes sp. isolate ctvEa3, partial genome | blastn | 756 | 699 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 12984874 | 12984874 | PRJNA1118794_P_NODE_69731_length_242_cov_1.597633_g68981_i0 | PRJNA1118794 | 69731 | 242 | 1.597633 | 3.86627186 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 442 | 1.1099999999999995e-119 | NTclustered | gi|2057844767|tpg|BK055780.1| | 2832643 | g68981 | i0 | 99.587 | 3 | 242 | 1 | 100 | 0 | 1 | 242 | 28360 | 28601 | MAG TPA_asm: Caudoviricetes sp. isolate ctvEa3, partial genome | blastn | 726 | 442 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14259567 | 14259567 | PRJNA1118794_P_NODE_29112_length_296_cov_1.336323_g28362_i0 | PRJNA1118794 | 29112 | 296 | 1.336323 | 3.95551608 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 542 | 1.34e-149 | NTclustered | gi|2914941530|gb|OR221752.1| | 2832643 | g28362 | i0 | 99.662 | 1 | 296 | 1 | 100 | 0 | 1 | 296 | 41159 | 40864 | MAG: Caudoviricetes sp. isolate MSP1281 genomic sequence | blastn | 296 | 542 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 16807780 | 16807780 | PRJNA1118794_P_NODE_37014_length_275_cov_1.475248_g36264_i0 | PRJNA1118794 | 37014 | 275 | 1.475248 | 4.056932 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 459 | 1.27e-124 | NTclustered | gi|2052991526|tpg|BK030840.1| | 2832643 | g36264 | i0 | 96.727 | 6 | 275 | 9 | 100 | 0 | 1 | 275 | 17696 | 17970 | MAG TPA_asm: Caudoviricetes sp. isolate ctAhk1, partial genome | blastn | 1650 | 459 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18082472 | 18082472 | PRJNA1118794_P_NODE_48235_length_251_cov_1.730337_g47485_i0 | PRJNA1118794 | 48235 | 251 | 1.730337 | 4.34314587 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 464 | 2.47e-126 | NTclustered | gi|2057844767|tpg|BK055780.1| | 2832643 | g47485 | i0 | 100 | 2 | 251 | 0 | 100 | 0 | 1 | 251 | 7916 | 7666 | MAG TPA_asm: Caudoviricetes sp. isolate ctvEa3, partial genome | blastn | 502 | 464 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18876639 | 18876639 | PRJNA1118794_P_NODE_37575_length_274_cov_1.358209_g36825_i0 | PRJNA1118794 | 37575 | 274 | 1.358209 | 3.72149266 | Pahexavirus | 1982251 | Viruses | Viruses | 392 | 1.3099999999999999e-104 | NTclustered | gi|849255497|ref|NC_027386.1| | 1500825 | g36825 | i0 | 92.701 | 93.492700729927 | 274 | 16 | 100 | 2 | 1 | 274 | 22955 | 23224 | Propionibacterium phage PHL152M00, complete genome | blastn | 25617 | 392 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Pahexavirus PHL152M00 | ||||
| 19356757 | 19356757 | PRJNA1118794_P_NODE_52596_length_249_cov_2.801136_g51846_i0 | PRJNA1118794 | 52596 | 249 | 2.801136 | 6.97482864 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 455 | 1.47e-123 | NTclustered | gi|2057844767|tpg|BK055780.1| | 2832643 | g51846 | i0 | 99.598 | 2 | 249 | 1 | 100 | 0 | 1 | 249 | 11372 | 11124 | MAG TPA_asm: Caudoviricetes sp. isolate ctvEa3, partial genome | blastn | 498 | 455 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19356920 | 19356920 | PRJNA1118794_P_NODE_66336_length_244_cov_0.900585_g65586_i0 | PRJNA1118794 | 66336 | 244 | 0.900585 | 2.1974274 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 451 | 1.86e-122 | NTclustered | gi|2057844767|tpg|BK055780.1| | 2832643 | g65586 | i0 | 100 | 3.84426229508197 | 244 | 0 | 100 | 0 | 1 | 244 | 5448 | 5691 | MAG TPA_asm: Caudoviricetes sp. isolate ctvEa3, partial genome | blastn | 938 | 451 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 20151402 | 20151402 | PRJNA1118794_P_NODE_40236_length_268_cov_1.579487_g39486_i0 | PRJNA1118794 | 40236 | 268 | 1.579487 | 4.23302516 | Pahexavirus | 1982251 | Viruses | Viruses | 300 | 7.94e-77 | NTclustered | gi|543171494|ref|NC_022339.1| | 1235646 | g39486 | i0 | 88.98 | 71.5485074626866 | 245 | 23 | 91 | 3 | 26 | 268 | 16591 | 16349 | Propionibacterium phage PHL037M02, complete genome | blastn | 19175 | 300 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Pahexavirus PHL037M02 | ||||
| 20631436 | 20631436 | PRJNA1118794_P_NODE_13217_length_396_cov_1.241486_g12467_i0 | PRJNA1118794 | 13217 | 396 | 1.241486 | 4.91628456 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 732 | 0 | NTclustered | gi|2057844767|tpg|BK055780.1| | 2832643 | g12467 | i0 | 100 | 3.00757575757576 | 396 | 0 | 100 | 0 | 1 | 396 | 1431 | 1036 | MAG TPA_asm: Caudoviricetes sp. isolate ctvEa3, partial genome | blastn | 1191 | 732 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 20631893 | 20631893 | PRJNA1118794_P_NODE_47697_length_252_cov_2.268156_g46947_i0 | PRJNA1118794 | 47697 | 252 | 2.268156 | 5.71575312 | Propionibacterium phage BruceLethal | 1654740 | Viruses | Viruses | 422 | 1.51e-113 | NTclustered | gi|1070103683|ref|NC_031084.1| | 1654740 | g46947 | i0 | 96.825 | 99.3730158730159 | 252 | 8 | 100 | 0 | 1 | 252 | 9064 | 8813 | Propionibacterium phage BruceLethal, complete genome | blastn | 25042 | 422 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Propionibacterium phage BruceLethal | ||||
| 23182965 | 23182965 | PRJNA1118794_P_NODE_40839_length_267_cov_1.262887_g40089_i0 | PRJNA1118794 | 40839 | 267 | 1.262887 | 3.37190829 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 488 | 1.5699999999999998e-133 | NTclustered | gi|2056826021|tpg|BK043839.1| | 2832643 | g40089 | i0 | 99.625 | 1 | 267 | 1 | 100 | 0 | 1 | 267 | 26549 | 26283 | MAG TPA_asm: Caudoviricetes sp. isolate ctRRw1, partial genome | blastn | 267 | 488 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 23977232 | 23977232 | PRJNA1118794_P_NODE_2099_length_1004_cov_2.832438_g1520_i0 | PRJNA1118794 | 2099 | 1004 | 2.832438 | 28.43767752 | Varicellovirus | 10319 | Viruses | Viruses | 65.8 | 1.31e-5 | NTclustered | gi|1129800201|gb|KU552118.1| | 10345 | g1520 | i0 | 93.182 | 1.27390438247012 | 44 | 3 | 4 | 0 | 364 | 407 | 115396 | 115353 | Suid alphaherpesvirus 1 isolate LA, complete genome | blastn | 1279 | 65.8 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Varicellovirus | Varicellovirus suidalpha1 | ||
| 24456672 | 24456672 | PRJNA1118794_P_NODE_21340_length_331_cov_1.434109_g20590_i0 | PRJNA1118794 | 21340 | 331 | 1.434109 | 4.74690079 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 612 | 1.14e-170 | NTclustered | gi|2057844767|tpg|BK055780.1| | 2832643 | g20590 | i0 | 100 | 1 | 331 | 0 | 100 | 0 | 1 | 331 | 38488 | 38158 | MAG TPA_asm: Caudoviricetes sp. isolate ctvEa3, partial genome | blastn | 331 | 612 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 24456961 | 24456961 | PRJNA1118794_P_NODE_42260_length_264_cov_1.277487_g41510_i0 | PRJNA1118794 | 42260 | 264 | 1.277487 | 3.37256568 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 372 | 1.63e-98 | NTclustered | gi|2054792953|tpg|BK049957.1| | 2832643 | g41510 | i0 | 92.045 | 1 | 264 | 21 | 100 | 0 | 1 | 264 | 50156 | 49893 | MAG TPA_asm: Caudoviricetes sp. isolate ctx1X17, partial genome | blastn | 264 | 372 | 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);;