contig_metadata
22 rows where analysis = "blastn", bioproject = "PRJNA1078753" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 192622 | 192622 | PRJNA1078753_P_NODE_37601_length_244_cov_1.842105_g37405_i0 | PRJNA1078753 | 37601 | 244 | 1.842105 | 4.4947362 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 196 | 9.61e-46 | NTclustered | gi|2914888655|gb|OR222597.1| | 2832643 | g37405 | i0 | 82.278 | 0.971311475409836 | 237 | 32 | 94 | 8 | 1 | 230 | 36684 | 36917 | MAG: Caudoviricetes sp. isolate MSP0337 genomic sequence | blastn | 237 | 196 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 1467068 | 1467068 | PRJNA1078753_P_NODE_17442_length_289_cov_1.703704_g17246_i0 | PRJNA1078753 | 17442 | 289 | 1.703704 | 4.92370456 | Staphylococcus phage Lacachita | 2970965 | Viruses | Viruses | 429 | 1.06e-115 | NTclustered | gi|2287971722|gb|OP142323.1| | 2973490 | g17246 | i0 | 93.426 | 8.98961937716263 | 289 | 19 | 100 | 0 | 1 | 289 | 44630 | 44918 | Staphylococcus phage Lacachita, complete genome | blastn | 2598 | 429 | 1 | Viruses | Duplodnaviria | Heunggongvirae | Uroviricota | Caudoviricetes | Staphylococcus phage Lacachita | ||||
| 2292170 | 2292170 | PRJNA1078753_P_NODE_18362_length_285_cov_1.943396_g18166_i0 | PRJNA1078753 | 18362 | 285 | 1.943396 | 5.5386786 | Viruses | 10239 | Viruses | Viruses | 516 | 7.77e-142 | NTclustered | gi|2057104082|tpg|BK038382.1| | 2832643 | g18166 | i0 | 99.298 | 76.8385964912281 | 285 | 2 | 100 | 0 | 1 | 285 | 15429 | 15713 | MAG TPA_asm: Caudoviricetes sp. isolate ctBfO1, partial genome | blastn | 21899 | 516 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 2743216 | 2743216 | PRJNA1078753_P_NODE_20723_length_275_cov_1.737624_g20527_i0 | PRJNA1078753 | 20723 | 275 | 1.737624 | 4.778466 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 508 | 1.2499999999999999e-139 | NTclustered | gi|2057844767|tpg|BK055780.1| | 2832643 | g20527 | i0 | 100 | 30.8 | 275 | 0 | 100 | 0 | 1 | 275 | 41037 | 40763 | MAG TPA_asm: Caudoviricetes sp. isolate ctvEa3, partial genome | blastn | 8470 | 508 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 2743343 | 2743343 | PRJNA1078753_P_NODE_36563_length_245_cov_0.895349_g36367_i0 | PRJNA1078753 | 36563 | 245 | 0.895349 | 2.19360505 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 409 | 1.1399999999999998e-109 | NTclustered | gi|2915011501|gb|OR222465.1| | 2832643 | g36367 | i0 | 96.735 | 3.14285714285714 | 245 | 8 | 100 | 0 | 1 | 245 | 54424 | 54180 | MAG: Caudoviricetes sp. isolate MSP0923 genomic sequence | blastn | 770 | 409 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 4018976 | 4018976 | PRJNA1078753_P_NODE_1004_length_943_cov_2.725287_g858_i0 | PRJNA1078753 | 1004 | 943 | 2.725287 | 25.69945641 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 56.5 | 0.007 | NTclustered | gi|2057832268|tpg|BK055563.1| | 2832643 | g858 | i0 | 96.97 | 0.177094379639449 | 33 | 1 | 3 | 0 | 726 | 758 | 4716 | 4748 | MAG TPA_asm: Caudoviricetes sp. isolate ctpdP10, partial genome | blastn | 167 | 56.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 4019164 | 4019164 | PRJNA1078753_P_NODE_35844_length_246_cov_0.890173_g35648_i0 | PRJNA1078753 | 35844 | 246 | 0.890173 | 2.18982558 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 289 | 1.56e-73 | NTclustered | gi|2054694536|tpg|BK052869.1| | 2832643 | g35648 | i0 | 87.854 | 4.82113821138211 | 247 | 28 | 99 | 2 | 2 | 246 | 11051 | 11297 | MAG TPA_asm: Caudoviricetes sp. isolate ct7qV16, partial genome | blastn | 1186 | 289 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 5295422 | 5295422 | PRJNA1078753_P_NODE_38165_length_244_cov_0.900585_g37969_i0 | PRJNA1078753 | 38165 | 244 | 0.900585 | 2.1974274 | Pahexavirus ouroboros | 1982259 | Viruses | Viruses | 429 | 8.699999999999998e-116 | NTclustered | gi|906476212|ref|NC_027630.1| | 1655017 | g37969 | i0 | 98.361 | 94.7704918032787 | 244 | 4 | 100 | 0 | 1 | 244 | 4019 | 4262 | Propionibacterium phage Ouroboros, complete genome | blastn | 23124 | 429 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Pahexavirus ouroboros | ||||
| 5295427 | 5295427 | PRJNA1078753_P_NODE_38725_length_244_cov_0.900585_g38529_i0 | PRJNA1078753 | 38725 | 244 | 0.900585 | 2.1974274 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 420 | 5.24e-113 | NTclustered | gi|2914774203|gb|OR222100.1| | 2832643 | g38529 | i0 | 97.934 | 0.991803278688525 | 242 | 5 | 99 | 0 | 3 | 244 | 251953 | 251712 | MAG: Caudoviricetes sp. isolate MSP0010 genomic sequence | blastn | 242 | 420 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 10395963 | 10395963 | PRJNA1078753_P_NODE_41569_length_242_cov_0.911243_g41373_i0 | PRJNA1078753 | 41569 | 242 | 0.911243 | 2.20520806 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 448 | 2.3799999999999995e-121 | NTclustered | gi|2057844767|tpg|BK055780.1| | 2832643 | g41373 | i0 | 100 | 33.9710743801653 | 242 | 0 | 100 | 0 | 1 | 242 | 274 | 33 | MAG TPA_asm: Caudoviricetes sp. isolate ctvEa3, partial genome | blastn | 8221 | 448 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11220383 | 11220383 | PRJNA1078753_P_NODE_32329_length_248_cov_0.880000_g32133_i0 | PRJNA1078753 | 32329 | 248 | 0.88 | 2.1824 | Sextaecvirus | 1922243 | Viruses | Viruses | 436 | 5.3e-118 | NTclustered | gi|1867214620|gb|MT596499.1| | 2750285 | g32133 | i0 | 98.387 | 22 | 248 | 4 | 100 | 0 | 1 | 248 | 31179 | 31426 | Staphylococcus virus BESEP2, complete genome | blastn | 5456 | 436 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Sextaecvirus | Staphylococcus phage vB_SepS_BE02 | ||||
| 14221258 | 14221258 | PRJNA1078753_P_NODE_25292_length_257_cov_1.619565_g25096_i0 | PRJNA1078753 | 25292 | 257 | 1.619565 | 4.16228205 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 228 | 3.6199999999999984e-55 | NTclustered | gi|2058054707|tpg|BK042612.1| | 2832643 | g25096 | i0 | 91.228 | 4.6420233463035 | 171 | 10 | 65 | 4 | 91 | 257 | 17272 | 17441 | MAG TPA_asm: Caudoviricetes sp. isolate cthIY3, partial genome | blastn | 1193 | 228 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 15044648 | 15044648 | PRJNA1078753_P_NODE_37752_length_244_cov_1.415205_g37556_i0 | PRJNA1078753 | 37752 | 244 | 1.415205 | 3.4531002 | Maltschvirus | 2948815 | Viruses | Viruses | 385 | 1.91e-102 | NTclustered | gi|1220000536|gb|MF417888.1| | 2100421 | g37556 | i0 | 95.102 | 8.03688524590164 | 245 | 10 | 100 | 2 | 1 | 244 | 36902 | 36659 | Uncultured Caudovirales phage clone 9S_3, partial genome | blastn | 1961 | 385 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 15495143 | 15495143 | PRJNA1078753_P_NODE_21033_length_274_cov_1.422886_g20837_i0 | PRJNA1078753 | 21033 | 274 | 1.422886 | 3.89870764 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 346 | 1.03e-90 | NTclustered | gi|2915014604|gb|OR222508.1| | 2832643 | g20837 | i0 | 89.416 | 34.8211678832117 | 274 | 29 | 100 | 0 | 1 | 274 | 5539 | 5812 | MAG: Caudoviricetes sp. isolate MSP0878 genomic sequence | blastn | 9541 | 346 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 15495253 | 15495253 | PRJNA1078753_P_NODE_35413_length_246_cov_0.890173_g35217_i0 | PRJNA1078753 | 35413 | 246 | 0.890173 | 2.18982558 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 377 | 3.2300000000000003e-100 | NTclustered | gi|2914914457|gb|OR221253.1| | 2832643 | g35217 | i0 | 94.65 | 0.98780487804878 | 243 | 13 | 99 | 0 | 4 | 246 | 22794 | 22552 | MAG: Caudoviricetes sp. isolate MSP1863 genomic sequence | blastn | 243 | 377 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 16319477 | 16319477 | PRJNA1078753_P_NODE_37013_length_245_cov_0.895349_g36817_i0 | PRJNA1078753 | 37013 | 245 | 0.895349 | 2.19360505 | Viruses | 10239 | Viruses | Viruses | 381 | 2.4799999999999995e-101 | NTclustered | gi|2052995918|tpg|BK030923.1| | 2832643 | g36817 | i0 | 94.694 | 6.14285714285714 | 245 | 13 | 100 | 0 | 1 | 245 | 34850 | 35094 | MAG TPA_asm: Caudoviricetes sp. isolate ct5pN1, partial genome | blastn | 1505 | 381 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18044387 | 18044387 | PRJNA1078753_P_NODE_37995_length_244_cov_0.900585_g37799_i0 | PRJNA1078753 | 37995 | 244 | 0.900585 | 2.1974274 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 86.1 | 2.17e-12 | NTclustered | gi|2914754352|gb|OR221458.1| | 2832643 | g37799 | i0 | 100 | 0.491803278688525 | 46 | 0 | 19 | 0 | 64 | 109 | 13435 | 13480 | MAG: Caudoviricetes sp. isolate MSP1621 genomic sequence | blastn | 120 | 86.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18044407 | 18044407 | PRJNA1078753_P_NODE_40415_length_243_cov_0.905882_g40219_i0 | PRJNA1078753 | 40415 | 243 | 0.905882 | 2.20129326 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 449 | 6.65e-122 | NTclustered | gi|2057844767|tpg|BK055780.1| | 2832643 | g40219 | i0 | 100 | 1 | 243 | 0 | 100 | 0 | 1 | 243 | 36386 | 36144 | MAG TPA_asm: Caudoviricetes sp. isolate ctvEa3, partial genome | blastn | 243 | 449 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19318259 | 19318259 | PRJNA1078753_P_NODE_26736_length_251_cov_2.292135_g26540_i0 | PRJNA1078753 | 26736 | 251 | 2.292135 | 5.75325885 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 464 | 2.47e-126 | NTclustered | gi|2914921323|gb|OR221391.1| | 2832643 | g26540 | i0 | 100 | 3.79681274900398 | 251 | 0 | 100 | 0 | 1 | 251 | 34236 | 34486 | MAG: Caudoviricetes sp. isolate MSP1709 genomic sequence | blastn | 953 | 464 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 21869316 | 21869316 | PRJNA1078753_P_NODE_23978_length_262_cov_4.888889_g23782_i0 | PRJNA1078753 | 23978 | 262 | 4.888889 | 12.80888918 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 52.8 | 0.024 | NTclustered | gi|2054641436|tpg|BK051826.1| | 2832643 | g23782 | i0 | 100 | 0.213740458015267 | 28 | 0 | 11 | 0 | 67 | 94 | 29202 | 29175 | MAG TPA_asm: Caudoviricetes sp. isolate ctC3Q12, partial genome | blastn | 56 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 21869364 | 21869364 | PRJNA1078753_P_NODE_29698_length_250_cov_0.870056_g29502_i0 | PRJNA1078753 | 29698 | 250 | 0.870056 | 2.17514 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 448 | 2.4699999999999996e-121 | NTclustered | gi|2914916405|gb|OR221289.1| | 2832643 | g29502 | i0 | 99.194 | 12.828 | 248 | 2 | 99 | 0 | 1 | 248 | 40372 | 40619 | MAG: Caudoviricetes sp. isolate MSP1816 genomic sequence | blastn | 3207 | 448 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 23144779 | 23144779 | PRJNA1078753_P_NODE_30199_length_249_cov_0.875000_g30003_i0 | PRJNA1078753 | 30199 | 249 | 0.875 | 2.17875 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 353 | 5.52e-93 | NTclustered | gi|2053078945|tpg|BK020046.1| | 2832643 | g30003 | i0 | 95.475 | 1.14457831325301 | 221 | 10 | 89 | 0 | 29 | 249 | 1 | 221 | MAG TPA_asm: Caudoviricetes sp. isolate ctKcv1, partial genome | blastn | 285 | 353 | 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);;