contig_metadata
18 rows where analysis = "blastn", bioproject = "PRJNA849822" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2113991 | 2113991 | PRJNA849822_P_NODE_20402_length_320_cov_3.279352_g20228_i0 | PRJNA849822 | 20402 | 320 | 3.279352 | 10.4939264 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 436 | 7.089999999999999e-118 | NTclustered | gi|2059825520|tpg|BK040067.1| | 2832643 | g20228 | i0 | 91.25 | 13.625 | 320 | 28 | 100 | 0 | 1 | 320 | 9860 | 10179 | MAG TPA_asm: Caudoviricetes sp. isolate ctJwv2, partial genome | blastn | 4360 | 436 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 2114132 | 2114132 | PRJNA849822_P_NODE_40722_length_245_cov_0.906977_g40548_i0 | PRJNA849822 | 40722 | 245 | 0.906977 | 2.22209365 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 448 | 2.41e-121 | NTclustered | gi|2914805019|gb|OR221447.1| | 2832643 | g40548 | i0 | 99.592 | 3.23673469387755 | 245 | 1 | 100 | 0 | 1 | 245 | 1541 | 1297 | MAG: Caudoviricetes sp. isolate MSP1632 genomic sequence | blastn | 793 | 448 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 3389356 | 3389356 | PRJNA849822_P_NODE_31983_length_258_cov_2.718919_g31809_i0 | PRJNA849822 | 31983 | 258 | 2.718919 | 7.01481102 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 477 | 3.2699999999999985e-130 | NTclustered | gi|2059879362|tpg|BK040996.1| | 2832643 | g31809 | i0 | 100 | 39.0387596899225 | 258 | 0 | 100 | 0 | 1 | 258 | 30708 | 30965 | MAG TPA_asm: Caudoviricetes sp. isolate ctGGP1, partial genome | blastn | 10072 | 477 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 3785435 | 3785435 | PRJNA849822_P_NODE_20743_length_318_cov_1.269388_g20569_i0 | PRJNA849822 | 20743 | 318 | 1.269388 | 4.03665384 | Viruses | 10239 | Viruses | Viruses | 52.8 | 0.03 | NTclustered | gi|2052868870|tpg|BK032591.1| | 2827975 | g20569 | i0 | 100 | 0.440251572327044 | 28 | 0 | 9 | 0 | 211 | 238 | 19130 | 19157 | MAG TPA_asm: Siphoviridae sp. ctxvK3, partial genome | blastn | 140 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Siphoviridae sp. ctxvK3 | |||||
| 4667059 | 4667059 | PRJNA849822_P_NODE_25864_length_286_cov_1.436620_g25690_i0 | PRJNA849822 | 25864 | 286 | 1.43662 | 4.1087332 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 54.7 | 0.007 | NTclustered | gi|2058041910|tpg|BK042357.1| | 2832643 | g25690 | i0 | 100 | 0.493006993006993 | 29 | 0 | 10 | 0 | 82 | 110 | 32096 | 32068 | MAG TPA_asm: Caudoviricetes sp. isolate ctpLI1, partial genome | blastn | 141 | 54.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 4667178 | 4667178 | PRJNA849822_P_NODE_42284_length_243_cov_0.917647_g42110_i0 | PRJNA849822 | 42284 | 243 | 0.917647 | 2.22988221 | Pahexavirus P101A | 1982267 | Viruses | Viruses | 392 | 1.14e-104 | NTclustered | gi|408905836|ref|NC_018841.1| | 1229786 | g42110 | i0 | 96.234 | 98.761316872428 | 239 | 9 | 98 | 0 | 1 | 239 | 24767 | 25005 | Propionibacterium phage P101A, complete genome | blastn | 23999 | 392 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Pahexavirus P101A | ||||
| 5061560 | 5061560 | PRJNA849822_P_NODE_34944_length_251_cov_1.533708_g34770_i0 | PRJNA849822 | 34944 | 251 | 1.533708 | 3.84960708 | Maltschvirus | 2948815 | Viruses | Viruses | 453 | 5.34e-123 | NTclustered | gi|1220001425|gb|MF417902.1| | 2100421 | g34770 | i0 | 99.203 | 87.0637450199203 | 251 | 2 | 100 | 0 | 1 | 251 | 10924 | 10674 | Uncultured Caudovirales phage clone 8F_8, partial genome | blastn | 21853 | 453 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 11042320 | 11042320 | PRJNA849822_P_NODE_33909_length_253_cov_0.866667_g33735_i0 | PRJNA849822 | 33909 | 253 | 0.866667 | 2.19266751 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 446 | 9.01e-121 | NTclustered | gi|2914927861|gb|OR221512.1| | 2832643 | g33735 | i0 | 98.419 | 1 | 253 | 4 | 100 | 0 | 1 | 253 | 43463 | 43715 | MAG: Caudoviricetes sp. isolate MSP1567 genomic sequence | blastn | 253 | 446 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 12317704 | 12317704 | PRJNA849822_P_NODE_16490_length_357_cov_1.862676_g16316_i0 | PRJNA849822 | 16490 | 357 | 1.862676 | 6.64975332 | Gualtarvirus mp1 | 2955964 | Viruses | Viruses | 52.8 | 0.034 | NTclustered | gi|1070065303|ref|NC_031020.1| | 1852628 | g16316 | i0 | 100 | 0.156862745098039 | 28 | 0 | 8 | 0 | 159 | 186 | 124205 | 124178 | Morganella phage vB_MmoM_MP1, complete genome | blastn | 56 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pantevenvirales | Straboviridae | Gualtarvirus | Gualtarvirus mp1 | ||
| 12317800 | 12317800 | PRJNA849822_P_NODE_29170_length_270_cov_2.005076_g28996_i0 | PRJNA849822 | 29170 | 270 | 2.005076 | 5.4137052 | Thermus phage phiLo | 2301536 | Viruses | Viruses | 185 | 2.34e-42 | NTclustered | gi|1490638517|gb|MH673673.1| | 2301536 | g28996 | i0 | 86.782 | 1.16296296296296 | 174 | 14 | 64 | 7 | 32 | 202 | 150585 | 150418 | Thermus phage phiLo, complete genome | blastn | 314 | 185 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Thermus phage phiLo | |||||
| 12317835 | 12317835 | PRJNA849822_P_NODE_34890_length_251_cov_1.752809_g34716_i0 | PRJNA849822 | 34890 | 251 | 1.752809 | 4.39955059 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 459 | 1.1499999999999996e-124 | NTclustered | gi|2057002355|tpg|BK048525.1| | 2832643 | g34716 | i0 | 99.602 | 50.7171314741036 | 251 | 1 | 100 | 0 | 1 | 251 | 17843 | 18093 | MAG TPA_asm: Caudoviricetes sp. isolate ct5j14, partial genome | blastn | 12730 | 459 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 13592281 | 13592281 | PRJNA849822_P_NODE_22691_length_304_cov_1.350649_g22517_i0 | PRJNA849822 | 22691 | 304 | 1.350649 | 4.10597296 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 429 | 1.12e-115 | NTclustered | gi|2057009609|tpg|BK048657.1| | 2832643 | g22517 | i0 | 92.105 | 9.99671052631579 | 304 | 24 | 100 | 0 | 1 | 304 | 12380 | 12683 | MAG TPA_asm: Caudoviricetes sp. isolate ct98G4, partial genome | blastn | 3039 | 429 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14866666 | 14866666 | PRJNA849822_P_NODE_35832_length_250_cov_1.322034_g35658_i0 | PRJNA849822 | 35832 | 250 | 1.322034 | 3.305085 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 396 | 9.079999999999996e-106 | NTclustered | gi|2059825520|tpg|BK040067.1| | 2832643 | g35658 | i0 | 95.2 | 17.728 | 250 | 12 | 100 | 0 | 1 | 250 | 14872 | 15121 | MAG TPA_asm: Caudoviricetes sp. isolate ctJwv2, partial genome | blastn | 4432 | 396 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17416827 | 17416827 | PRJNA849822_P_NODE_26854_length_281_cov_1.394231_g26680_i0 | PRJNA849822 | 26854 | 281 | 1.394231 | 3.91778911 | Staphylococcus phage S-CoN_Ph32 | 3076590 | Viruses | Viruses | 479 | 9.999999999999999e-131 | NTclustered | gi|2582095295|gb|OR354855.1| | 3076590 | g26680 | i0 | 97.834 | 5.76512455516014 | 277 | 6 | 99 | 0 | 1 | 277 | 3943 | 3667 | Staphylococcus phage S-CoN_Ph32, complete genome | blastn | 1620 | 479 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Rountreeviridae | Andhravirus | Staphylococcus phage S-CoN_Ph32 | |||
| 17810985 | 17810985 | PRJNA849822_P_NODE_43474_length_242_cov_0.899408_g43300_i0 | PRJNA849822 | 43474 | 242 | 0.899408 | 2.17656736 | Pahexavirus | 1982251 | Viruses | Viruses | 414 | 2.41e-111 | NTclustered | gi|148727082|ref|NC_009541.1| | 376758 | g43300 | i0 | 97.521 | 100.148760330579 | 242 | 6 | 100 | 0 | 1 | 242 | 5 | 246 | Propionibacterium phage PA6, complete genome | blastn | 24236 | 414 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Pahexavirus PA6 | ||||
| 21240741 | 21240741 | PRJNA849822_P_NODE_36957_length_249_cov_0.886364_g36783_i0 | PRJNA849822 | 36957 | 249 | 0.886364 | 2.20704636 | Skunavirus CB13 | 665883 | Viruses | Viruses | 257 | 4.45e-64 | NTclustered | gi|256588023|ref|NC_013155.1| | 2898541 | g36783 | i0 | 99.296 | 57.8112449799197 | 142 | 1 | 57 | 0 | 1 | 142 | 10202 | 10061 | Lactococcus phage CB13, complete genome | blastn | 14395 | 257 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Skunavirus | Skunavirus CB13 | ||||
| 23790756 | 23790756 | PRJNA849822_P_NODE_14739_length_380_cov_0.856678_g14565_i0 | PRJNA849822 | 14739 | 380 | 0.856678 | 3.2553764 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 56.5 | 0.003 | NTclustered | gi|2914860368|gb|OR222087.1| | 2832643 | g14565 | i0 | 100 | 0.0789473684210526 | 30 | 0 | 8 | 0 | 116 | 145 | 212098 | 212127 | MAG: Caudoviricetes sp. isolate MSP0025 genomic sequence | blastn | 30 | 56.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 23790975 | 23790975 | PRJNA849822_P_NODE_43459_length_242_cov_0.923077_g43285_i0 | PRJNA849822 | 43459 | 242 | 0.923077 | 2.23384634 | Percavirus equidgamma2 | 3050281 | Viruses | Viruses | 399 | 6.759999999999999e-107 | NTclustered | gi|2271301500|gb|MW322569.1| | 12657 | g43285 | i0 | 96.667 | 23.9256198347107 | 240 | 8 | 99 | 0 | 3 | 242 | 103980 | 104219 | Equid gammaherpesvirus 2 strain 1-141/67, complete genome | blastn | 5790 | 399 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Percavirus | Percavirus equidgamma2 |
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);;