contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA635397" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3156536 | 3156536 | PRJNA635397_P_NODE_23863_length_327_cov_2.716535_g23409_i0 | PRJNA635397 | 23863 | 327 | 2.716535 | 8.88306945 | Alphapapillomavirus 7 | 337042 | Viruses | Viruses | 604 | 1.8799999999999993e-168 | NTclustered | gi|1258167396|gb|MF288663.1| | 333761 | g23409 | i0 | 100 | 100 | 327 | 0 | 100 | 0 | 1 | 327 | 1992 | 1666 | Human papillomavirus 18 isolate C415154_R1_1138896_N-P, complete genome | blastn | 32700 | 604 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Alphapapillomavirus | Alphapapillomavirus 7 | ||
| 3156765 | 3156765 | PRJNA635397_P_NODE_38543_length_254_cov_1.701657_g38089_i0 | PRJNA635397 | 38543 | 254 | 1.701657 | 4.32220878 | Alphabaculovirus bomori | 3047695 | Viruses | Viruses | 52.8 | 0.023 | NTclustered | gi|393717332|gb|JQ991011.1| | 271108 | g38089 | i0 | 100 | 0.110236220472441 | 28 | 0 | 11 | 0 | 77 | 104 | 19131 | 19158 | Bombyx mori NPV strain Guangxi, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Naldaviricetes | Lefavirales | Baculoviridae | Alphabaculovirus | Alphabaculovirus bomori | ||||
| 3705314 | 3705314 | PRJNA635397_P_NODE_20243_length_358_cov_3.666667_g19789_i0 | PRJNA635397 | 20243 | 358 | 3.666667 | 13.12666786 | Audreyjarvisvirus | 2843351 | Viruses | Viruses | 52.8 | 0.034 | NTclustered | gi|1878246544|ref|NC_049854.1| | 1965467 | g19789 | i0 | 100 | 0.547486033519553 | 28 | 0 | 8 | 0 | 37 | 64 | 44760 | 44733 | Lactococcus phage AM1, complete genome | blastn | 196 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Audreyjarvisvirus | Audreyjarvisvirus AM1 | ||||
| 4433439 | 4433439 | PRJNA635397_P_NODE_28024_length_301_cov_1.324561_g27570_i0 | PRJNA635397 | 28024 | 301 | 1.324561 | 3.98692861 | Subteminivirus SMA7 | 2011079 | Viruses | Viruses | 551 | 2.2699999999999992e-152 | NTclustered | gi|514361131|ref|NC_021569.1| | 1343494 | g27570 | i0 | 99.668 | 74.2392026578073 | 301 | 1 | 100 | 0 | 1 | 301 | 1915 | 1615 | Stenotrophomonas phage phiSMA7 proviral complete genome | blastn | 22346 | 551 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Subteminivirus | Subteminivirus SMA7 | ||
| 6984505 | 6984505 | PRJNA635397_P_NODE_46826_length_242_cov_0.869822_g46372_i0 | PRJNA635397 | 46826 | 242 | 0.869822 | 2.10496924 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 414 | 2.41e-111 | NTclustered | gi|2054452022|tpg|BK031338.1| | 2832643 | g46372 | i0 | 97.521 | 18.1115702479339 | 242 | 6 | 100 | 0 | 1 | 242 | 27265 | 27024 | MAG TPA_asm: Caudoviricetes sp. isolate ctUPE4, partial genome | blastn | 4383 | 414 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 8259169 | 8259169 | PRJNA635397_P_NODE_43507_length_246_cov_0.901734_g43053_i0 | PRJNA635397 | 43507 | 246 | 0.901734 | 2.21826564 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 217 | 7.449999999999999e-52 | NTclustered | gi|2054413371|tpg|BK035582.1| | 2832643 | g43053 | i0 | 83.058 | 7.82926829268293 | 242 | 37 | 98 | 4 | 1 | 240 | 40716 | 40477 | MAG TPA_asm: Caudoviricetes sp. isolate ct7A32, partial genome | blastn | 1926 | 217 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 9534136 | 9534136 | PRJNA635397_P_NODE_23548_length_330_cov_1.237354_g23094_i0 | PRJNA635397 | 23548 | 330 | 1.237354 | 4.0832682 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 457 | 5.6299999999999986e-124 | NTclustered | gi|2915004039|gb|OR222348.1| | 2832643 | g23094 | i0 | 96.39 | 16.769696969697 | 277 | 10 | 100 | 0 | 54 | 330 | 35244 | 34968 | MAG: Caudoviricetes sp. isolate MSP1050 genomic sequence | blastn | 5534 | 457 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 10810122 | 10810122 | PRJNA635397_P_NODE_39509_length_252_cov_0.871508_g39055_i0 | PRJNA635397 | 39509 | 252 | 0.871508 | 2.19620016 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 93.5 | 1.35e-14 | NTclustered | gi|2914922610|gb|OR221417.1| | 2832643 | g39055 | i0 | 98.113 | 1.01984126984127 | 53 | 1 | 21 | 0 | 10 | 62 | 27580 | 27632 | MAG: Caudoviricetes sp. isolate MSP1672 genomic sequence | blastn | 257 | 93.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 13359876 | 13359876 | PRJNA635397_P_NODE_29131_length_295_cov_0.977477_g28677_i0 | PRJNA635397 | 29131 | 295 | 0.977477 | 2.88355715 | Gammaretrovirus murleu | 3428959 | Viruses | Viruses | 479 | 1.0599999999999996e-130 | NTclustered | gi|18448741|gb|AF462057.1| | 11801 | g28677 | i0 | 95.932 | 100 | 295 | 12 | 100 | 0 | 1 | 295 | 3248 | 2954 | Moloney murine leukemia virus neuropathogenic variant ts1-92b, complete genome | blastn | 29500 | 479 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 13360045 | 13360045 | PRJNA635397_P_NODE_38251_length_255_cov_1.686813_g37797_i0 | PRJNA635397 | 38251 | 255 | 1.686813 | 4.30137315 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 390 | 4.32e-104 | NTclustered | gi|2054392764|tpg|BK031062.1| | 2832643 | g37797 | i0 | 94.8 | 100.011764705882 | 250 | 13 | 98 | 0 | 4 | 253 | 13959 | 13710 | MAG TPA_asm: Caudoviricetes sp. isolate ctahB1, partial genome | blastn | 25503 | 390 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 15908716 | 15908716 | PRJNA635397_P_NODE_37453_length_258_cov_1.486486_g36999_i0 | PRJNA635397 | 37453 | 258 | 1.486486 | 3.83513388 | Siphoviridae sp. ctLnP14 | 2827851 | Viruses | Viruses | 444 | 3.32e-120 | NTclustered | gi|2052865947|tpg|BK032550.1| | 2827851 | g36999 | i0 | 97.674 | 3.9922480620155 | 258 | 6 | 100 | 0 | 1 | 258 | 7960 | 8217 | MAG TPA_asm: Siphoviridae sp. ctLnP14, partial genome | blastn | 1030 | 444 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Siphoviridae sp. ctLnP14 | |||||
| 21008323 | 21008323 | PRJNA635397_P_NODE_41957_length_248_cov_1.217143_g41503_i0 | PRJNA635397 | 41957 | 248 | 1.217143 | 3.01851464 | Propionibacterium phage LilBandit | 2041561 | Viruses | Viruses | 370 | 5.45e-98 | NTclustered | gi|1269172293|gb|MF919516.1| | 2041561 | g41503 | i0 | 93.574 | 100.625 | 249 | 15 | 100 | 1 | 1 | 248 | 28792 | 28544 | Propionibacterium phage LilBandit, complete genome | blastn | 24955 | 370 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Propionibacterium phage LilBandit | ||||
| 22831138 | 22831138 | PRJNA635397_P_NODE_35338_length_266_cov_1.937824_g34884_i0 | PRJNA635397 | 35338 | 266 | 1.937824 | 5.15461184 | root | 1 | Root_unresolved | Root_unresolved | 492 | 1.2099999999999999e-134 | NTclustered | gi|1465382782|emb|LS992246.1| | 10376 | g34884 | i0 | 100 | 100 | 266 | 0 | 100 | 0 | 1 | 266 | 96544 | 96279 | Human gammaherpesvirus 4 isolate Human herpesvirus 4 genome assembly, chromosome: I | blastn | 26600 | 492 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Lymphocryptovirus | Lymphocryptovirus humangamma4 | ||
| 23558349 | 23558349 | PRJNA635397_P_NODE_29279_length_294_cov_1.217195_g28825_i0 | PRJNA635397 | 29279 | 294 | 1.217195 | 3.5785533 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 472 | 1.7699999999999998e-128 | NTclustered | gi|2058028471|tpg|BK042086.1| | 2832643 | g28825 | i0 | 95.578 | 100.19387755102 | 294 | 13 | 100 | 0 | 1 | 294 | 9929 | 9636 | MAG TPA_asm: Caudoviricetes sp. isolate ctl0w2, partial genome | blastn | 29457 | 472 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 24105604 | 24105604 | PRJNA635397_P_NODE_23039_length_334_cov_1.306513_g22585_i0 | PRJNA635397 | 23039 | 334 | 1.306513 | 4.36375342 | Pahexavirus | 1982251 | Viruses | Viruses | 551 | 2.549999999999999e-152 | NTclustered | gi|670145376|gb|KJ578768.1| | 1500808 | g22585 | i0 | 96.407 | 47.7634730538922 | 334 | 12 | 100 | 0 | 1 | 334 | 14549 | 14216 | Propionibacterium phage PHL082M00, complete genome | blastn | 15953 | 553 | 0.996383363471971 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Pahexavirus PHL082M03 |
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);;