contig_metadata
20 rows where analysis = "blastn", bioproject = "PRJEB81463" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 140508 | 140508 | PRJEB81463_P_NODE_25261_length_246_cov_0.901734_g24989_i0 | PRJEB81463 | 25261 | 246 | 0.901734 | 2.21826564 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 407 | 4.12e-109 | NTclustered | gi|2914887418|gb|OR222536.1| | 2832643 | g24989 | i0 | 96.371 | 2.01626016260163 | 248 | 7 | 100 | 1 | 1 | 246 | 33324 | 33077 | MAG: Caudoviricetes sp. isolate MSP0404 genomic sequence | blastn | 496 | 407 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 1414895 | 1414895 | PRJEB81463_P_NODE_10202_length_316_cov_1.201646_g9930_i0 | PRJEB81463 | 10202 | 316 | 1.201646 | 3.79720136 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 560 | 3.98e-155 | NTclustered | gi|2914992818|gb|OR222202.1| | 2832643 | g9930 | i0 | 98.438 | 1.0126582278481 | 320 | 1 | 100 | 2 | 1 | 316 | 56679 | 56998 | MAG: Caudoviricetes sp. isolate MSP0769 genomic sequence | blastn | 320 | 560 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 3966683 | 3966683 | PRJEB81463_P_NODE_28004_length_242_cov_0.923077_g27732_i0 | PRJEB81463 | 28004 | 242 | 0.923077 | 2.23384634 | Shirevirus langgrundblatt1 | 3432423 | Viruses | Viruses | 366 | 6.85e-97 | NTclustered | gi|2476209669|ref|NC_073093.1| | 2939128 | g27732 | i0 | 95.614 | 2.90495867768595 | 228 | 10 | 94 | 0 | 7 | 234 | 41945 | 42172 | Xanthomonas phage Langgrundblatt1, complete genome | blastn | 703 | 366 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Shirevirus | Shirevirus langgrundblatt1 | ||||
| 5242992 | 5242992 | PRJEB81463_P_NODE_16985_length_267_cov_1.324742_g16713_i0 | PRJEB81463 | 16985 | 267 | 1.324742 | 3.53706114 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 344 | 3.6e-90 | NTclustered | gi|2914887418|gb|OR222536.1| | 2832643 | g16713 | i0 | 96.651 | 1.67041198501873 | 209 | 4 | 78 | 3 | 60 | 267 | 5866 | 6072 | MAG: Caudoviricetes sp. isolate MSP0404 genomic sequence | blastn | 446 | 344 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 6518647 | 6518647 | PRJEB81463_P_NODE_19606_length_255_cov_1.373626_g19334_i0 | PRJEB81463 | 19606 | 255 | 1.373626 | 3.5027463 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 444 | 3.27e-120 | NTclustered | gi|2914921323|gb|OR221391.1| | 2832643 | g19334 | i0 | 98.039 | 15.6352941176471 | 255 | 5 | 100 | 0 | 1 | 255 | 39103 | 39357 | MAG: Caudoviricetes sp. isolate MSP1709 genomic sequence | blastn | 3987 | 444 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 8650595 | 8650595 | PRJEB81463_P_NODE_28167_length_242_cov_0.923077_g27895_i0 | PRJEB81463 | 28167 | 242 | 0.923077 | 2.23384634 | Haloferacalesvirus | 2843389 | Viruses | Viruses | 409 | 1.12e-109 | NTclustered | gi|2098379215|gb|MZ334506.1| | 2877996 | g27895 | i0 | 97.107 | 26.2520661157025 | 242 | 7 | 100 | 0 | 1 | 242 | 41662 | 41903 | Halorubrum virus HRTV-16 isolate HRTV-16/4, complete genome | blastn | 6353 | 409 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Thumleimavirales | Hafunaviridae | Haloferacalesvirus | Halorubrum virus HRTV-16 | ||
| 9067781 | 9067781 | PRJEB81463_P_NODE_21468_length_251_cov_0.876404_g21196_i0 | PRJEB81463 | 21468 | 251 | 0.876404 | 2.19977404 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 387 | 5.489999999999998e-103 | NTclustered | gi|2915005496|gb|OR222380.1| | 2832643 | g21196 | i0 | 94.422 | 2 | 251 | 14 | 100 | 0 | 1 | 251 | 20582 | 20332 | MAG: Caudoviricetes sp. isolate MSP1018 genomic sequence | blastn | 502 | 387 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 9067846 | 9067846 | PRJEB81463_P_NODE_25508_length_245_cov_1.813953_g25236_i0 | PRJEB81463 | 25508 | 245 | 1.813953 | 4.44418485 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 392 | 1.15e-104 | NTclustered | gi|2914992818|gb|OR222202.1| | 2832643 | g25236 | i0 | 95.51 | 1 | 245 | 11 | 100 | 0 | 1 | 245 | 16587 | 16343 | MAG: Caudoviricetes sp. isolate MSP0769 genomic sequence | blastn | 245 | 392 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11618823 | 11618823 | PRJEB81463_P_NODE_12550_length_290_cov_1.645161_g12278_i0 | PRJEB81463 | 12550 | 290 | 1.645161 | 4.7709669 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 464 | 2.9099999999999993e-126 | NTclustered | gi|2914921323|gb|OR221391.1| | 2832643 | g12278 | i0 | 95.533 | 1.00344827586207 | 291 | 11 | 100 | 2 | 1 | 290 | 7894 | 8183 | MAG: Caudoviricetes sp. isolate MSP1709 genomic sequence | blastn | 291 | 464 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 15442964 | 15442964 | PRJEB81463_P_NODE_21813_length_251_cov_0.876404_g21541_i0 | PRJEB81463 | 21813 | 251 | 0.876404 | 2.19977404 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 431 | 2.4999999999999996e-116 | NTclustered | gi|2059727130|tpg|BK024776.1| | 2832643 | g21541 | i0 | 97.61 | 1.21115537848606 | 251 | 6 | 100 | 0 | 1 | 251 | 6887 | 7137 | MAG TPA_asm: Caudoviricetes sp. isolate ct9OW2, partial genome | blastn | 304 | 431 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 15443059 | 15443059 | PRJEB81463_P_NODE_27893_length_242_cov_1.485207_g27621_i0 | PRJEB81463 | 27893 | 242 | 1.485207 | 3.59420094 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 351 | 1.92e-92 | NTclustered | gi|2053078945|tpg|BK020046.1| | 2832643 | g27621 | i0 | 93.277 | 2.1198347107438 | 238 | 16 | 98 | 0 | 5 | 242 | 5441 | 5204 | MAG TPA_asm: Caudoviricetes sp. isolate ctKcv1, partial genome | blastn | 513 | 351 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 16717119 | 16717119 | PRJEB81463_P_NODE_18734_length_259_cov_1.311828_g18462_i0 | PRJEB81463 | 18734 | 259 | 1.311828 | 3.39763452 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 396 | 9.459999999999996e-106 | NTclustered | gi|2058066358|tpg|BK042851.1| | 2832643 | g18462 | i0 | 94.208 | 4 | 259 | 15 | 100 | 0 | 1 | 259 | 21417 | 21159 | MAG TPA_asm: Caudoviricetes sp. isolate ctgIX19, partial genome | blastn | 1036 | 396 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 16717234 | 16717234 | PRJEB81463_P_NODE_26014_length_245_cov_0.906977_g25742_i0 | PRJEB81463 | 26014 | 245 | 0.906977 | 2.22209365 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|2053102184|tpg|BK020520.1| | 2832643 | g25742 | i0 | 100 | 0.122448979591837 | 30 | 0 | 12 | 0 | 122 | 151 | 4305 | 4276 | MAG TPA_asm: Caudoviricetes sp. isolate ctdiI2, partial genome | blastn | 30 | 56.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19265919 | 19265919 | PRJEB81463_P_NODE_18936_length_258_cov_1.313514_g18664_i0 | PRJEB81463 | 18936 | 258 | 1.313514 | 3.38886612 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 427 | 3.34e-115 | NTclustered | gi|2914921323|gb|OR221391.1| | 2832643 | g18664 | i0 | 96.512 | 1 | 258 | 9 | 100 | 0 | 1 | 258 | 16295 | 16552 | MAG: Caudoviricetes sp. isolate MSP1709 genomic sequence | blastn | 258 | 427 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19265943 | 19265943 | PRJEB81463_P_NODE_20396_length_253_cov_0.866667_g20124_i0 | PRJEB81463 | 20396 | 253 | 0.866667 | 2.19266751 | Myunavirus My1 | 2560631 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|408905832|ref|NC_018837.1| | 1204539 | g20124 | i0 | 96.97 | 0.632411067193676 | 33 | 1 | 13 | 0 | 15 | 47 | 16 | 48 | Pectobacterium phage My1, complete genome | blastn | 160 | 56.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Demerecviridae | Myunavirus | Myunavirus My1 | |||
| 21817214 | 21817214 | PRJEB81463_P_NODE_20618_length_252_cov_1.743017_g20346_i0 | PRJEB81463 | 20618 | 252 | 1.743017 | 4.39240284 | Propionibacterium phage pa28 | 2079401 | Viruses | Viruses | 438 | 1.5e-118 | NTclustered | gi|1338076777|gb|MG820642.1| | 2079401 | g20346 | i0 | 98.016 | 97.0912698412698 | 252 | 5 | 100 | 0 | 1 | 252 | 3952 | 4203 | Propionibacterium phage pa28, complete genome | blastn | 24467 | 438 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Propionibacterium phage pa28 | ||||
| 23092238 | 23092238 | PRJEB81463_P_NODE_12439_length_291_cov_1.247706_g12167_i0 | PRJEB81463 | 12439 | 291 | 1.247706 | 3.63082446 | Klebsiella phage vB_KM5a1-KLB28 | 3145203 | Viruses | Viruses | 379 | 1.09e-100 | NTclustered | gi|2899263775|gb|PP582755.1| | 3145203 | g12167 | i0 | 95.102 | 3.58762886597938 | 245 | 5 | 99 | 4 | 1 | 244 | 33909 | 33671 | Klebsiella phage vB_KM5a1-KLB28, complete genome | blastn | 1044 | 379 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Klebsiella phage vB_KM5a1-KLB28 | |||||
| 23092244 | 23092244 | PRJEB81463_P_NODE_12779_length_289_cov_1.305556_g12507_i0 | PRJEB81463 | 12779 | 289 | 1.305556 | 3.77305684 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 496 | 1.03e-135 | NTclustered | gi|2057101500|tpg|BK038328.1| | 2832643 | g12507 | i0 | 97.902 | 97.8512110726644 | 286 | 6 | 99 | 0 | 1 | 286 | 10433 | 10718 | MAG TPA_asm: Caudoviricetes sp. isolate ctCDt1, partial genome | blastn | 28279 | 496 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 23092649 | 23092649 | PRJEB81463_P_NODE_7999_length_355_cov_1.659574_g7727_i0 | PRJEB81463 | 7999 | 355 | 1.659574 | 5.8914877 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 656 | 0 | NTclustered | gi|2914760312|gb|OR221747.1| | 2832643 | g7727 | i0 | 100 | 91.8225352112676 | 355 | 0 | 100 | 0 | 1 | 355 | 44775 | 44421 | MAG: Caudoviricetes sp. isolate MSP1289 genomic sequence | blastn | 32597 | 656 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 24366364 | 24366364 | PRJEB81463_P_NODE_27920_length_242_cov_1.384615_g27648_i0 | PRJEB81463 | 27920 | 242 | 1.384615 | 3.3507683 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 414 | 2.41e-111 | NTclustered | gi|2914921323|gb|OR221391.1| | 2832643 | g27648 | i0 | 97.521 | 49.5826446280992 | 242 | 6 | 100 | 0 | 1 | 242 | 818 | 1059 | MAG: Caudoviricetes sp. isolate MSP1709 genomic sequence | blastn | 11999 | 414 | 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);;