contig_metadata
23 rows where analysis = "blastn", bioproject = "PRJNA841653" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 830921 | 830921 | PRJNA841653_P_NODE_57901_length_243_cov_0.905882_g57227_i0 | PRJNA841653 | 57901 | 243 | 0.905882 | 2.20129326 | Geobacillus virus E3 | 1572712 | Viruses | Viruses | 390 | 4.089999999999999e-104 | NTclustered | gi|985758336|ref|NC_029073.1| | 1572712 | g57227 | i0 | 96.234 | 0.983539094650206 | 239 | 8 | 98 | 1 | 5 | 242 | 86566 | 86328 | Geobacillus virus E3, complete genome | blastn | 239 | 390 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Geobacillus virus E3 | |||||
| 830963 | 830963 | PRJNA841653_P_NODE_60321_length_242_cov_0.911243_g59647_i0 | PRJNA841653 | 60321 | 242 | 0.911243 | 2.20520806 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 165 | 2.68e-36 | NTclustered | gi|2059855778|tpg|BK040580.1| | 2832643 | g59647 | i0 | 90.476 | 1.92148760330579 | 126 | 11 | 52 | 1 | 1 | 126 | 14662 | 14786 | MAG TPA_asm: Caudoviricetes sp. isolate ctzrz2, partial genome | blastn | 465 | 165 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 4659350 | 4659350 | PRJNA841653_P_NODE_59644_length_242_cov_0.911243_g58970_i0 | PRJNA841653 | 59644 | 242 | 0.911243 | 2.20520806 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 418 | 1.8699999999999998e-112 | NTclustered | gi|2915045223|gb|OR222781.1| | 2832643 | g58970 | i0 | 98.723 | 0.971074380165289 | 235 | 3 | 97 | 0 | 1 | 235 | 62613 | 62379 | MAG: Caudoviricetes sp. isolate MSP0579 genomic sequence | blastn | 235 | 418 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 5933917 | 5933917 | PRJNA841653_P_NODE_47545_length_249_cov_0.875000_g46871_i0 | PRJNA841653 | 47545 | 249 | 0.875 | 2.17875 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 357 | 4.2599999999999997e-94 | NTclustered | gi|2054662968|tpg|BK052251.1| | 2832643 | g46871 | i0 | 93.361 | 43.9638554216867 | 241 | 16 | 97 | 0 | 9 | 249 | 14659 | 14419 | MAG TPA_asm: Caudoviricetes sp. isolate ctOtH1, partial genome | blastn | 10947 | 357 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 5933978 | 5933978 | PRJNA841653_P_NODE_50885_length_247_cov_0.885057_g50211_i0 | PRJNA841653 | 50885 | 247 | 0.885057 | 2.18609079 | Streptococcus phage Javan210 | 2548048 | Viruses | Viruses | 331 | 2.5600000000000002e-86 | NTclustered | gi|1608079949|gb|MK448875.1| | 2548048 | g50211 | i0 | 91.632 | 5.84210526315789 | 239 | 20 | 97 | 0 | 4 | 242 | 4694 | 4932 | Streptococcus phage Javan210, complete genome | blastn | 1443 | 331 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Streptococcus phage Javan210 | |||||
| 8483293 | 8483293 | PRJNA841653_P_NODE_34667_length_279_cov_1.121359_g33993_i0 | PRJNA841653 | 34667 | 279 | 1.121359 | 3.12859161 | Ceetrepovirus kimchi1738 | 2955595 | Viruses | Viruses | 366 | 8.08e-97 | NTclustered | gi|2047444183|ref|NC_055772.1| | 2483719 | g33993 | i0 | 90.614 | 1.98566308243728 | 277 | 25 | 99 | 1 | 4 | 279 | 20570 | 20294 | Corynebacterium phage Kimchi1738, complete genome | blastn | 554 | 366 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Zierdtviridae | Ceetrepovirus | Ceetrepovirus kimchi1738 | |||
| 8883576 | 8883576 | PRJNA841653_P_NODE_14347_length_435_cov_1.223757_g13676_i0 | PRJNA841653 | 14347 | 435 | 1.223757 | 5.32334295 | Fishburnevirus | 1983734 | Viruses | Viruses | 93.5 | 2.48e-14 | NTclustered | gi|971482395|ref|NC_028747.1| | 1698358 | g13676 | i0 | 82.857 | 1.05977011494253 | 105 | 16 | 24 | 2 | 1 | 104 | 36997 | 36894 | Mycobacterium phage Brusacoram, complete genome | blastn | 461 | 93.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Fishburnevirus | Fishburnevirus brusacoram | ||||
| 9758546 | 9758546 | PRJNA841653_P_NODE_36908_length_271_cov_1.313131_g36234_i0 | PRJNA841653 | 36908 | 271 | 1.313131 | 3.55858501 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 470 | 5.79e-128 | NTclustered | gi|2057856818|tpg|BK050467.1| | 2832643 | g36234 | i0 | 98.496 | 5.21771217712177 | 266 | 4 | 98 | 0 | 1 | 266 | 38018 | 37753 | MAG TPA_asm: Caudoviricetes sp. isolate ctlhy11, partial genome | blastn | 1414 | 470 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11034307 | 11034307 | PRJNA841653_P_NODE_37169_length_270_cov_1.370558_g36495_i0 | PRJNA841653 | 37169 | 270 | 1.370558 | 3.7005066 | Cutibacterium phage CAP 6-3 | 3061992 | Viruses | Viruses | 394 | 3.57e-105 | NTclustered | gi|2574021525|gb|OR178992.1| | 3061992 | g36495 | i0 | 93.561 | 97.8148148148148 | 264 | 17 | 98 | 0 | 6 | 269 | 26223 | 25960 | Cutibacterium phage CAP 6-3, complete genome | blastn | 26410 | 394 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Cutibacterium phage CAP 6-3 | |||||
| 11034482 | 11034482 | PRJNA841653_P_NODE_47709_length_249_cov_0.875000_g47035_i0 | PRJNA841653 | 47709 | 249 | 0.875 | 2.17875 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 431 | 2.4799999999999995e-116 | NTclustered | gi|2059799285|tpg|BK039676.1| | 2832643 | g47035 | i0 | 100 | 21.4859437751004 | 233 | 0 | 94 | 0 | 17 | 249 | 11527 | 11295 | MAG TPA_asm: Caudoviricetes sp. isolate ctIVQ1, partial genome | blastn | 5350 | 431 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11034653 | 11034653 | PRJNA841653_P_NODE_57669_length_243_cov_0.905882_g56995_i0 | PRJNA841653 | 57669 | 243 | 0.905882 | 2.20129326 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 440 | 4e-119 | NTclustered | gi|2057844767|tpg|BK055780.1| | 2832643 | g56995 | i0 | 100 | 2.95061728395062 | 238 | 0 | 98 | 0 | 6 | 243 | 27271 | 27508 | MAG TPA_asm: Caudoviricetes sp. isolate ctvEa3, partial genome | blastn | 717 | 440 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14858772 | 14858772 | PRJNA841653_P_NODE_52772_length_246_cov_0.890173_g52098_i0 | PRJNA841653 | 52772 | 246 | 0.890173 | 2.18982558 | Geobacillus virus E3 | 1572712 | Viruses | Viruses | 257 | 4.39e-64 | NTclustered | gi|985758336|ref|NC_029073.1| | 1572712 | g52098 | i0 | 86.695 | 0.947154471544715 | 233 | 29 | 94 | 2 | 11 | 242 | 106430 | 106661 | Geobacillus virus E3, complete genome | blastn | 233 | 257 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Geobacillus virus E3 | |||||
| 15258522 | 15258522 | PRJNA841653_P_NODE_14352_length_435_cov_1.046961_g13681_i0 | PRJNA841653 | 14352 | 435 | 1.046961 | 4.55428035 | Pahexavirus | 1982251 | Viruses | Viruses | 702 | 0 | NTclustered | gi|906476164|ref|NC_027629.1| | 1655012 | g13681 | i0 | 96.262 | 98.4045977011494 | 428 | 16 | 98 | 0 | 8 | 435 | 20719 | 21146 | Propionibacterium phage Attacne, complete genome | blastn | 42806 | 702 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Pahexavirus attacne | ||||
| 16132844 | 16132844 | PRJNA841653_P_NODE_18213_length_383_cov_1.225806_g17541_i0 | PRJNA841653 | 18213 | 383 | 1.225806 | 4.69483698 | Pahexavirus SKKY | 1982305 | Viruses | Viruses | 569 | 8.16e-158 | NTclustered | gi|906475910|ref|NC_027624.1| | 1655020 | g17541 | i0 | 93.899 | 98.6370757180157 | 377 | 23 | 98 | 0 | 1 | 377 | 18612 | 18988 | Propionibacterium phage SKKY, complete genome | blastn | 37778 | 569 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Pahexavirus SKKY | ||||
| 17408290 | 17408290 | PRJNA841653_P_NODE_13954_length_441_cov_1.385870_g13283_i0 | PRJNA841653 | 13954 | 441 | 1.38587 | 6.1116867 | Oscarsovirus oscarso | 3431516 | Viruses | Viruses | 315 | 4.93e-81 | NTclustered | gi|2487592458|ref|NC_073466.1| | 2985324 | g13283 | i0 | 81.675 | 0.866213151927438 | 382 | 66 | 86 | 4 | 43 | 422 | 17193 | 17572 | Microbacterium phage OscarSo, complete genome | blastn | 382 | 315 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Oscarsovirus | Oscarsovirus oscarso | ||||
| 17408507 | 17408507 | PRJNA841653_P_NODE_25514_length_323_cov_1.232000_g24840_i0 | PRJNA841653 | 25514 | 323 | 1.232 | 3.97936 | Oscarsovirus oscarso | 3431516 | Viruses | Viruses | 180 | 1.33e-40 | NTclustered | gi|2487592458|ref|NC_073466.1| | 2985324 | g24840 | i0 | 82.096 | 0.851393188854489 | 229 | 24 | 66 | 16 | 99 | 312 | 11680 | 11454 | Microbacterium phage OscarSo, complete genome | blastn | 275 | 180 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Oscarsovirus | Oscarsovirus oscarso | ||||
| 19082445 | 19082445 | PRJNA841653_P_NODE_56475_length_244_cov_0.900585_g55801_i0 | PRJNA841653 | 56475 | 244 | 0.900585 | 2.1974274 | Viruses | 10239 | Viruses | Viruses | 424 | 4.05e-114 | NTclustered | gi|116054663|emb|AJ292531.2| | 46654 | g55801 | i0 | 98.34 | 138.16393442623001 | 241 | 4 | 99 | 0 | 4 | 244 | 11352 | 11112 | Lactococcus bacteriophage phi31 hol31, lys31, cI, cro, ant31, hel31 and pri31 genes and ORF1-14 | blastn | 33712 | 424 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Lactococcus phage phi31 | |||||
| 19957517 | 19957517 | PRJNA841653_P_NODE_9516_length_545_cov_1.540254_g8850_i0 | PRJNA841653 | 9516 | 545 | 1.540254 | 8.3943843 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 793 | 0 | NTclustered | gi|2915016823|gb|OR222530.1| | 2832643 | g8850 | i0 | 93.002 | 58.4678899082569 | 543 | 38 | 99 | 0 | 1 | 543 | 37827 | 38369 | MAG: Caudoviricetes sp. isolate MSP0407 genomic sequence | blastn | 31865 | 793 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 20357245 | 20357245 | PRJNA841653_P_NODE_53716_length_245_cov_1.290698_g53042_i0 | PRJNA841653 | 53716 | 245 | 1.290698 | 3.1622101 | Pahexavirus | 1982251 | Viruses | Viruses | 448 | 2.41e-121 | NTclustered | gi|1336448649|gb|MG820645.1| | 2079404 | g53042 | i0 | 99.592 | 98.8244897959184 | 245 | 1 | 100 | 0 | 1 | 245 | 6254 | 6010 | Propionibacterium phage pa3-SS3, complete genome | blastn | 24212 | 448 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Propionibacterium phage pa3-SS3 | ||||
| 22506794 | 22506794 | PRJNA841653_P_NODE_10558_length_515_cov_1.714932_g9891_i0 | PRJNA841653 | 10558 | 515 | 1.714932 | 8.8318998 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 728 | 0 | NTclustered | gi|2054434277|tpg|BK035998.1| | 2832643 | g9891 | i0 | 95.604 | 453.922330097087 | 455 | 18 | 88 | 2 | 3 | 456 | 17977 | 18430 | MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome | blastn | 233770 | 728 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 22908242 | 22908242 | PRJNA841653_P_NODE_30698_length_294_cov_1.357466_g30024_i0 | PRJNA841653 | 30698 | 294 | 1.357466 | 3.99095004 | Pahexavirus | 1982251 | Viruses | Viruses | 532 | 7.989999999999998e-147 | NTclustered | gi|849255742|ref|NC_027391.1| | 1500801 | g30024 | i0 | 99.32 | 93.9149659863946 | 294 | 2 | 100 | 0 | 1 | 294 | 2269 | 1976 | Propionibacterium phage PHL041M10, complete genome | blastn | 27611 | 532 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Pahexavirus PHL041M10 | ||||
| 23783377 | 23783377 | PRJNA841653_P_NODE_8299_length_587_cov_1.972763_g7638_i0 | PRJNA841653 | 8299 | 587 | 1.972763 | 11.58011881 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 902 | 0 | NTclustered | gi|2915016823|gb|OR222530.1| | 2832643 | g7638 | i0 | 94.378 | 44.4565587734242 | 587 | 33 | 100 | 0 | 1 | 587 | 38951 | 38365 | MAG: Caudoviricetes sp. isolate MSP0407 genomic sequence | blastn | 26096 | 902 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 25056981 | 25056981 | PRJNA841653_P_NODE_52060_length_246_cov_0.890173_g51386_i0 | PRJNA841653 | 52060 | 246 | 0.890173 | 2.18982558 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 370 | 5.399999999999999e-98 | NTclustered | gi|2914936954|gb|OR221675.1| | 2832643 | g51386 | i0 | 94.561 | 1.94308943089431 | 239 | 13 | 97 | 0 | 1 | 239 | 39843 | 40081 | MAG: Caudoviricetes sp. isolate MSP1367 genomic sequence | blastn | 478 | 370 | 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);;