contig_metadata
18 rows where analysis = "blastn", bioproject = "PRJNA1156092" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 302649 | 302649 | PRJNA1156092_P_NODE_14521_length_304_cov_1.281385_g14391_i0 | PRJNA1156092 | 14521 | 304 | 1.281385 | 3.8954104 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 562 | 1.06e-155 | NTclustered | gi|2915046274|gb|OR222796.1| | 2832643 | g14391 | i0 | 100 | 81.8881578947368 | 304 | 0 | 100 | 0 | 1 | 304 | 54957 | 54654 | MAG: Caudoviricetes sp. isolate MSP0560 genomic sequence | blastn | 24894 | 562 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 302671 | 302671 | PRJNA1156092_P_NODE_15861_length_292_cov_2.050228_g15731_i0 | PRJNA1156092 | 15861 | 292 | 2.050228 | 5.98666576 | Propionibacterium phage TCUCAP1 | 2806603 | Viruses | Viruses | 540 | 4.74e-149 | NTclustered | gi|1997123824|gb|MW505928.1| | 2806603 | g15731 | i0 | 100 | 96.0684931506849 | 292 | 0 | 100 | 0 | 1 | 292 | 21653 | 21944 | Propionibacterium phage TCUCAP1, partial genome | blastn | 28052 | 540 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Propionibacterium phage TCUCAP1 | ||||
| 1577450 | 1577450 | PRJNA1156092_P_NODE_25342_length_248_cov_0.880000_g25212_i0 | PRJNA1156092 | 25342 | 248 | 0.88 | 2.1824 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 425 | 1.15e-114 | NTclustered | gi|2054660223|tpg|BK052201.1| | 2832643 | g25212 | i0 | 97.581 | 11.0120967741935 | 248 | 6 | 100 | 0 | 1 | 248 | 6332 | 6085 | MAG TPA_asm: Caudoviricetes sp. isolate ctcoh5, partial genome | blastn | 2731 | 425 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 1577561 | 1577561 | PRJNA1156092_P_NODE_31422_length_242_cov_0.911243_g31292_i0 | PRJNA1156092 | 31422 | 242 | 0.911243 | 2.20520806 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 442 | 1.1099999999999995e-119 | NTclustered | gi|2915048543|gb|OR222821.1| | 2832643 | g31292 | i0 | 99.587 | 1.37190082644628 | 242 | 1 | 100 | 0 | 1 | 242 | 66664 | 66423 | MAG: Caudoviricetes sp. isolate MSP0536 genomic sequence | blastn | 332 | 442 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 3587698 | 3587698 | PRJNA1156092_P_NODE_27543_length_246_cov_0.890173_g27413_i0 | PRJNA1156092 | 27543 | 246 | 0.890173 | 2.18982558 | Pahexavirus | 1982251 | Viruses | Viruses | 455 | 1.4500000000000002e-123 | NTclustered | gi|1789795508|gb|MN813683.1| | 2686224 | g27413 | i0 | 100 | 100.243902439024 | 246 | 0 | 100 | 0 | 1 | 246 | 5415 | 5660 | Cutibacterium phage P108C, complete genome | blastn | 24660 | 455 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Cutibacterium phage P108C | ||||
| 4129809 | 4129809 | PRJNA1156092_P_NODE_28744_length_245_cov_0.889535_g28614_i0 | PRJNA1156092 | 28744 | 245 | 0.889535 | 2.17936075 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 106 | 1.67e-18 | NTclustered | gi|2914829364|gb|OR222460.1| | 2832643 | g28614 | i0 | 100 | 24.1836734693878 | 57 | 0 | 23 | 0 | 4 | 60 | 33886 | 33830 | MAG: Caudoviricetes sp. isolate MSP0934 genomic sequence | blastn | 5925 | 106 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 4129811 | 4129811 | PRJNA1156092_P_NODE_28904_length_244_cov_1.134503_g28774_i0 | PRJNA1156092 | 28904 | 244 | 1.134503 | 2.76818732 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 106 | 1.67e-18 | NTclustered | gi|2914981896|gb|OR222105.1| | 2832643 | g28774 | i0 | 98.333 | 25.2786885245902 | 60 | 1 | 25 | 0 | 4 | 63 | 60 | 1 | MAG: Caudoviricetes sp. isolate MSP0005 genomic sequence | blastn | 6168 | 106 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 5405934 | 5405934 | PRJNA1156092_P_NODE_27805_length_245_cov_1.790698_g27675_i0 | PRJNA1156092 | 27805 | 245 | 1.790698 | 4.3872101 | Listeria phage LPJP1 | 2852115 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|2067455222|gb|MZ422438.1| | 2852115 | g27675 | i0 | 100 | 0.23265306122449 | 29 | 0 | 12 | 0 | 136 | 164 | 65778 | 65806 | Listeria phage LPJP1, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Listeria phage LPJP1 | |||||
| 7415156 | 7415156 | PRJNA1156092_P_NODE_33066_length_228_cov_2.477419_g32936_i0 | PRJNA1156092 | 33066 | 228 | 2.477419 | 5.64851532 | Pahexavirus | 1982251 | Viruses | Viruses | 422 | 1.34e-113 | NTclustered | gi|849249558|ref|NC_027336.1| | 1500798 | g32936 | i0 | 100 | 99.7719298245614 | 228 | 0 | 100 | 0 | 1 | 228 | 2776 | 2549 | Propionibacterium phage PHL009M11, complete genome | blastn | 22748 | 422 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Pahexavirus PHL009M11 | ||||
| 10506447 | 10506447 | PRJNA1156092_P_NODE_13869_length_310_cov_0.974684_g13739_i0 | PRJNA1156092 | 13869 | 310 | 0.974684 | 3.0215204 | Propionibacterium phage TCUCAP1 | 2806603 | Viruses | Viruses | 508 | 1.4299999999999999e-139 | NTclustered | gi|1997123824|gb|MW505928.1| | 2806603 | g13739 | i0 | 96.721 | 97.2322580645161 | 305 | 10 | 98 | 0 | 1 | 305 | 22843 | 23147 | Propionibacterium phage TCUCAP1, partial genome | blastn | 30142 | 508 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Propionibacterium phage TCUCAP1 | ||||
| 14331612 | 14331612 | PRJNA1156092_P_NODE_11672_length_331_cov_1.193798_g11542_i0 | PRJNA1156092 | 11672 | 331 | 1.193798 | 3.95147138 | Propionibacterium phage TCUCAP1 | 2806603 | Viruses | Viruses | 590 | 5.3399999999999985e-164 | NTclustered | gi|1997123824|gb|MW505928.1| | 2806603 | g11542 | i0 | 98.792 | 100.262839879154 | 331 | 4 | 100 | 0 | 1 | 331 | 15527 | 15857 | Propionibacterium phage TCUCAP1, partial genome | blastn | 33187 | 590 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Propionibacterium phage TCUCAP1 | ||||
| 14331748 | 14331748 | PRJNA1156092_P_NODE_19592_length_266_cov_1.595855_g19462_i0 | PRJNA1156092 | 19592 | 266 | 1.595855 | 4.2449743 | Pahexavirus pirate | 1982303 | Viruses | Viruses | 448 | 2.6599999999999996e-121 | NTclustered | gi|1725329241|ref|NC_027623.2| | 1655018 | g19462 | i0 | 98.425 | 98.6654135338346 | 254 | 4 | 95 | 0 | 13 | 266 | 11173 | 10920 | Propionibacterium phage Pirate, complete genome | blastn | 26245 | 448 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Pahexavirus pirate | ||||
| 16879777 | 16879777 | PRJNA1156092_P_NODE_16614_length_287_cov_1.224299_g16484_i0 | PRJNA1156092 | 16614 | 287 | 1.224299 | 3.51373813 | Pahexavirus lauchelly | 1982257 | Viruses | Viruses | 486 | 6.139999999999999e-133 | NTclustered | gi|906476115|ref|NC_027628.1| | 1655015 | g16484 | i0 | 97.213 | 99.1672473867596 | 287 | 8 | 100 | 0 | 1 | 287 | 12047 | 12333 | Propionibacterium phage Lauchelly, complete genome | blastn | 28461 | 486 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Pahexavirus lauchelly | ||||
| 17615033 | 17615033 | PRJNA1156092_P_NODE_3834_length_518_cov_1.200000_g3705_i0 | PRJNA1156092 | 3834 | 518 | 1.2 | 6.216 | Pahexavirus | 1982251 | Viruses | Viruses | 680 | 0 | NTclustered | gi|1631925795|ref|NC_041954.1| | 1655013 | g3705 | i0 | 91.506 | 107.233590733591 | 518 | 8 | 100 | 7 | 1 | 518 | 27725 | 27244 | Propionibacterium phage Keiki, complete genome | blastn | 55547 | 680 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Pahexavirus keiki | ||||
| 22714200 | 22714200 | PRJNA1156092_P_NODE_30638_length_243_cov_0.905882_g30508_i0 | PRJNA1156092 | 30638 | 243 | 0.905882 | 2.20129326 | root | 1 | Root_unresolved | Root_unresolved | 412 | 8.72e-111 | NTclustered | gi|2914761720|gb|OR221827.1| | 2832643 | g30508 | i0 | 97.51 | 7.93004115226337 | 241 | 6 | 99 | 0 | 1 | 241 | 1047 | 1287 | MAG: Caudoviricetes sp. isolate MSP1184 genomic sequence | blastn | 1927 | 412 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 24528744 | 24528744 | PRJNA1156092_P_NODE_22360_length_251_cov_0.865169_g22230_i0 | PRJNA1156092 | 22360 | 251 | 0.865169 | 2.17157419 | Psychrobacter phage vB_PmaS_Y8A | 3017068 | Viruses | Viruses | 213 | 9.86e-51 | NTclustered | gi|2419022835|gb|OQ059336.1| | 3017068 | g22230 | i0 | 88.764 | 2.38247011952191 | 178 | 14 | 69 | 4 | 78 | 251 | 33878 | 33703 | Psychrobacter phage vB_PmaS_Y8A, complete genome | blastn | 598 | 213 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Psychrobacter phage vB_PmaS_Y8A | |||||
| 24528754 | 24528754 | PRJNA1156092_P_NODE_22900_length_250_cov_0.870056_g22770_i0 | PRJNA1156092 | 22900 | 250 | 0.870056 | 2.17514 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 462 | 8.83e-126 | NTclustered | gi|2915041279|gb|OR222739.1| | 2832643 | g22770 | i0 | 100 | 20.992 | 250 | 0 | 100 | 0 | 1 | 250 | 11244 | 10995 | MAG: Caudoviricetes sp. isolate MSP0627 genomic sequence | blastn | 5248 | 462 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 25263453 | 25263453 | PRJNA1156092_P_NODE_17300_length_282_cov_1.473684_g17170_i0 | PRJNA1156092 | 17300 | 282 | 1.473684 | 4.15578888 | Pahexavirus | 1982251 | Viruses | Viruses | 442 | 1.3199999999999993e-119 | NTclustered | gi|1631925795|ref|NC_041954.1| | 1655013 | g17170 | i0 | 95.035 | 100.216312056738 | 282 | 13 | 99 | 1 | 2 | 282 | 28644 | 28363 | Propionibacterium phage Keiki, complete genome | blastn | 28261 | 442 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Pahexavirus keiki |
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);;