contig_metadata
25 rows where analysis = "blastn", bioproject = "PRJNA951412" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3485460 | 3485460 | PRJNA951412_P_NODE_2903_length_285_cov_1.169811_g2818_i0 | PRJNA951412 | 2903 | 285 | 1.169811 | 3.33396135 | Prokaryotic dsDNA virus sp. | 2591644 | Viruses | Viruses | 353 | 6.44e-93 | NTclustered | gi|1707910805|gb|MK892832.1| | 2591644 | g2818 | i0 | 89.123 | 1.7719298245614 | 285 | 30 | 100 | 1 | 1 | 285 | 40783 | 40500 | MAG: Prokaryotic dsDNA virus sp. isolate Tp1_111_DCM_112609_1, complete genome | blastn | 505 | 353 | 1 | Viruses | Prokaryotic dsDNA virus sp. | ||||||||
| 3814820 | 3814820 | PRJNA951412_P_NODE_3523_length_265_cov_1.614583_g3438_i0 | PRJNA951412 | 3523 | 265 | 1.614583 | 4.27864495 | Moineauvirus | 1623304 | Viruses | Viruses | 473 | 4.3599999999999987e-129 | NTclustered | gi|2437985630|ref|NC_070691.1| | 1971415 | g3438 | i0 | 98.868 | 100.581132075472 | 265 | 3 | 100 | 0 | 1 | 265 | 9340 | 9604 | Streptococcus phage P3681, complete genome | blastn | 26654 | 473 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Aliceevansviridae | Moineauvirus | Moineauvirus P3681 | |||
| 4763152 | 4763152 | PRJNA951412_P_NODE_2924_length_284_cov_1.469194_g2839_i0 | PRJNA951412 | 2924 | 284 | 1.4691940000000001 | 4.17251096 | Taphios ghabri-like virus 1 | 2980097 | Viruses | Viruses | 520 | 5.98e-143 | NTclustered | gi|2306601784|gb|OP191687.1| | 2980097 | g2839 | i0 | 99.648 | 2 | 284 | 1 | 100 | 0 | 1 | 284 | 2433 | 2150 | MAG: Taphios ghabri-like virus 1 isolate Nanocea1, partial genome | blastn | 568 | 520 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Taphios ghabri-like virus 1 | ||||
| 4763208 | 4763208 | PRJNA951412_P_NODE_6924_length_244_cov_1.818713_g6839_i0 | PRJNA951412 | 6924 | 244 | 1.818713 | 4.43765972 | Prokaryotic dsDNA virus sp. | 2591644 | Viruses | Viruses | 147 | 9.81e-31 | NTclustered | gi|1707910805|gb|MK892832.1| | 2591644 | g6839 | i0 | 90.179 | 0.459016393442623 | 112 | 11 | 46 | 0 | 1 | 112 | 17071 | 17182 | MAG: Prokaryotic dsDNA virus sp. isolate Tp1_111_DCM_112609_1, complete genome | blastn | 112 | 147 | 1 | Viruses | Prokaryotic dsDNA virus sp. | ||||||||
| 4763223 | 4763223 | PRJNA951412_P_NODE_844_length_496_cov_2.780142_g759_i0 | PRJNA951412 | 844 | 496 | 2.780142 | 13.78950432 | Shenzhen dicistro-like virus | 2789378 | Viruses | Viruses | 833 | 0 | NTclustered | gi|1940198121|gb|MT757492.1| | 2789378 | g759 | i0 | 96.976 | 1.99798387096774 | 496 | 15 | 100 | 0 | 1 | 496 | 7502 | 7997 | Shenzhen dicistro-like virus strain CHNdp-2 polyprotein gene, complete cds | blastn | 991 | 833 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Shenzhen dicistro-like virus | |||
| 6037902 | 6037902 | PRJNA951412_P_NODE_145_length_1223_cov_2.386087_g96_i0 | PRJNA951412 | 145 | 1223 | 2.386087 | 29.18184401 | Dermatophagoides pteronyssinus virus 2 | 2851129 | Viruses | Viruses | 1766 | 0 | NTclustered | gi|2057568148|gb|MW355890.1| | 2851129 | g96 | i0 | 92.793 | 2.94439901880621 | 1221 | 86 | 99 | 1 | 5 | 1223 | 8445 | 7225 | Dermatophagoides pteronyssinus virus 2 genomic sequence, sequence | blastn | 3601 | 1766 | 1 | Viruses | Dermatophagoides pteronyssinus virus 2 | ||||||||
| 7312847 | 7312847 | PRJNA951412_P_NODE_8206_length_228_cov_2.116129_g8121_i0 | PRJNA951412 | 8206 | 228 | 2.116129 | 4.82477412 | Prokaryotic dsDNA virus sp. | 2591644 | Viruses | Viruses | 366 | 6.39e-97 | NTclustered | gi|1707910805|gb|MK892832.1| | 2591644 | g8121 | i0 | 95.614 | 1 | 228 | 10 | 100 | 0 | 1 | 228 | 51902 | 51675 | MAG: Prokaryotic dsDNA virus sp. isolate Tp1_111_DCM_112609_1, complete genome | blastn | 228 | 366 | 1 | Viruses | Prokaryotic dsDNA virus sp. | ||||||||
| 8587806 | 8587806 | PRJNA951412_P_NODE_627_length_584_cov_4.379648_g542_i0 | PRJNA951412 | 627 | 584 | 4.379648 | 25.57714432 | Shenzhen dicistro-like virus | 2789378 | Viruses | Viruses | 1026 | 0 | NTclustered | gi|1940198121|gb|MT757492.1| | 2789378 | g542 | i0 | 98.294 | 3.81678082191781 | 586 | 8 | 100 | 2 | 1 | 584 | 8377 | 8962 | Shenzhen dicistro-like virus strain CHNdp-2 polyprotein gene, complete cds | blastn | 2229 | 1026 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Shenzhen dicistro-like virus | |||
| 11138448 | 11138448 | PRJNA951412_P_NODE_3049_length_280_cov_1.507246_g2964_i0 | PRJNA951412 | 3049 | 280 | 1.507246 | 4.2202888 | Prokaryotic dsDNA virus sp. | 2591644 | Viruses | Viruses | 468 | 2.16e-127 | NTclustered | gi|1707910805|gb|MK892832.1| | 2591644 | g2964 | i0 | 96.786 | 1 | 280 | 9 | 100 | 0 | 1 | 280 | 67115 | 66836 | MAG: Prokaryotic dsDNA virus sp. isolate Tp1_111_DCM_112609_1, complete genome | blastn | 280 | 468 | 1 | Viruses | Prokaryotic dsDNA virus sp. | ||||||||
| 11466576 | 11466576 | PRJNA951412_P_NODE_6229_length_246_cov_0.901734_g6144_i0 | PRJNA951412 | 6229 | 246 | 0.901734 | 2.21826564 | Viruses | 10239 | Viruses | Viruses | 405 | 1.48e-108 | NTclustered | gi|2053070936|tpg|BK016058.1| | 2825571 | g6144 | i0 | 97.863 | 23.5121951219512 | 234 | 5 | 95 | 0 | 1 | 234 | 364 | 131 | MAG TPA_asm: Siphoviridae sp. ctcK97, partial genome | blastn | 5784 | 405 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Siphoviridae sp. ctcK97 | |||||
| 13688479 | 13688479 | PRJNA951412_P_NODE_591_length_608_cov_1.299065_g506_i0 | PRJNA951412 | 591 | 608 | 1.299065 | 7.8983152 | Prokaryotic dsDNA virus sp. | 2591644 | Viruses | Viruses | 272 | 4.2499999999999985e-68 | NTclustered | gi|1707910805|gb|MK892832.1| | 2591644 | g506 | i0 | 94.828 | 0.286184210526316 | 174 | 9 | 29 | 0 | 1 | 174 | 52464 | 52291 | MAG: Prokaryotic dsDNA virus sp. isolate Tp1_111_DCM_112609_1, complete genome | blastn | 174 | 272 | 1 | Viruses | Prokaryotic dsDNA virus sp. | ||||||||
| 13688484 | 13688484 | PRJNA951412_P_NODE_6431_length_246_cov_0.895954_g6346_i0 | PRJNA951412 | 6431 | 246 | 0.895954 | 2.20404684 | Acinetobacter phage vB_AbaS_TRS1 | 1852629 | Viruses | Viruses | 422 | 1.47e-113 | NTclustered | gi|1070104669|ref|NC_031098.1| | 1852629 | g6346 | i0 | 97.561 | 7.89430894308943 | 246 | 6 | 100 | 0 | 1 | 246 | 33941 | 33696 | Acinetobacter phage vB_AbaS_TRS1, complete genome | blastn | 1942 | 422 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Acinetobacter phage vB_AbaS_TRS1 | |||||
| 14962639 | 14962639 | PRJNA951412_P_NODE_3052_length_280_cov_1.497585_g2967_i0 | PRJNA951412 | 3052 | 280 | 1.497585 | 4.193238 | Shenzhen dicistro-like virus | 2789378 | Viruses | Viruses | 496 | 9.92e-136 | NTclustered | gi|1940198121|gb|MT757492.1| | 2789378 | g2967 | i0 | 98.571 | 3 | 280 | 4 | 100 | 0 | 1 | 280 | 4389 | 4110 | Shenzhen dicistro-like virus strain CHNdp-2 polyprotein gene, complete cds | blastn | 840 | 496 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Shenzhen dicistro-like virus | |||
| 14962651 | 14962651 | PRJNA951412_P_NODE_3752_length_259_cov_1.672043_g3667_i0 | PRJNA951412 | 3752 | 259 | 1.672043 | 4.33059137 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 359 | 1.24e-94 | NTclustered | gi|2914804504|gb|OR221411.1| | 2832643 | g3667 | i0 | 94.421 | 95.0579150579151 | 233 | 13 | 90 | 0 | 27 | 259 | 27143 | 26911 | MAG: Caudoviricetes sp. isolate MSP1680 genomic sequence | blastn | 24620 | 359 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17512913 | 17512913 | PRJNA951412_P_NODE_2334_length_309_cov_1.224576_g2249_i0 | PRJNA951412 | 2334 | 309 | 1.224576 | 3.78393984 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 226 | 1.6099999999999998e-54 | NTclustered | gi|2914792039|gb|OR222787.1| | 2832643 | g2249 | i0 | 90.23 | 0.563106796116505 | 174 | 16 | 56 | 1 | 136 | 309 | 27841 | 27669 | MAG: Caudoviricetes sp. isolate MSP0571 genomic sequence | blastn | 174 | 226 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17512955 | 17512955 | PRJNA951412_P_NODE_5694_length_248_cov_0.880000_g5609_i0 | PRJNA951412 | 5694 | 248 | 0.88 | 2.1824 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 453 | 5.2600000000000005e-123 | NTclustered | gi|2059803870|tpg|BK039751.1| | 2832643 | g5609 | i0 | 99.597 | 1.28225806451613 | 248 | 1 | 100 | 0 | 1 | 248 | 30960 | 31207 | MAG TPA_asm: Caudoviricetes sp. isolate ctkVX2, partial genome | blastn | 318 | 453 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19114127 | 19114127 | PRJNA951412_P_NODE_3035_length_281_cov_1.115385_g2950_i0 | PRJNA951412 | 3035 | 281 | 1.115385 | 3.13423185 | Gammapapillomavirus | 325455 | Viruses | Viruses | 453 | 6.08e-123 | NTclustered | gi|443498402|gb|KC108725.1| | 10566 | g2950 | i0 | 95.73 | 4 | 281 | 12 | 100 | 0 | 1 | 281 | 632 | 912 | Human papillomavirus isolate SE95 L2 protein gene, partial cds | blastn | 1124 | 453 | 1 | Viruses | Human papillomavirus types | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Human papillomavirus | ||
| 20061447 | 20061447 | PRJNA951412_P_NODE_3076_length_279_cov_1.514563_g2991_i0 | PRJNA951412 | 3076 | 279 | 1.514563 | 4.22563077 | Shenzhen dicistro-like virus | 2789378 | Viruses | Viruses | 488 | 1.6499999999999999e-133 | NTclustered | gi|1935607040|gb|MT747995.1| | 2789378 | g2991 | i0 | 98.208 | 3 | 279 | 5 | 100 | 0 | 1 | 279 | 5561 | 5839 | Shenzhen dicistro-like virus strain USAdp-3 polyprotein gene, complete cds | blastn | 837 | 488 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Shenzhen dicistro-like virus | |||
| 22611840 | 22611840 | PRJNA951412_P_NODE_5658_length_248_cov_0.885714_g5573_i0 | PRJNA951412 | 5658 | 248 | 0.885714 | 2.19657072 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 429 | 8.869999999999998e-116 | NTclustered | gi|2915040595|gb|OR222730.1| | 2832643 | g5573 | i0 | 97.976 | 1.20161290322581 | 247 | 5 | 99 | 0 | 1 | 247 | 48884 | 49130 | MAG: Caudoviricetes sp. isolate MSP0629 genomic sequence | blastn | 298 | 429 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 23887114 | 23887114 | PRJNA951412_P_NODE_1399_length_377_cov_4.381579_g1314_i0 | PRJNA951412 | 1399 | 377 | 4.381579 | 16.51855283 | Shenzhen dicistro-like virus | 2789378 | Viruses | Viruses | 636 | 7.789999999999999e-178 | NTclustered | gi|1940198121|gb|MT757492.1| | 2789378 | g1314 | i0 | 97.082 | 2 | 377 | 11 | 100 | 0 | 1 | 377 | 7999 | 8375 | Shenzhen dicistro-like virus strain CHNdp-2 polyprotein gene, complete cds | blastn | 754 | 636 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Shenzhen dicistro-like virus | |||
| 23887164 | 23887164 | PRJNA951412_P_NODE_439_length_729_cov_3.009146_g357_i0 | PRJNA951412 | 439 | 729 | 3.009146 | 21.93667434 | Dermatophagoides pteronyssinus virus 1 | 2851128 | Viruses | Viruses | 1160 | 0 | NTclustered | gi|2057568150|gb|MW355891.1| | 2851128 | g357 | i0 | 95.461 | 1.99451303155007 | 727 | 33 | 99 | 0 | 1 | 727 | 6833 | 7559 | Dermatophagoides pteronyssinus virus 1 genomic sequence, sequence | blastn | 1454 | 1160 | 1 | Viruses | Dermatophagoides pteronyssinus virus 1 | ||||||||
| 24214392 | 24214392 | PRJNA951412_P_NODE_2559_length_298_cov_1.591111_g2474_i0 | PRJNA951412 | 2559 | 298 | 1.591111 | 4.74151078 | Viruses | 10239 | Viruses | Viruses | 86.1 | 2.73e-12 | NTclustered | gi|2053055506|tpg|BK024540.1| | 38018 | g2474 | i0 | 93.103 | 4.22818791946309 | 58 | 4 | 19 | 0 | 18 | 75 | 78439 | 78496 | MAG TPA_asm: Bacteriophage sp. isolate ct9eP3, partial genome | blastn | 1260 | 86.1 | 1 | Viruses | Bacteriophage sp. | ||||||||
| 25160933 | 25160933 | PRJNA951412_P_NODE_3720_length_260_cov_1.475936_g3635_i0 | PRJNA951412 | 3720 | 260 | 1.475936 | 3.8374335999999998 | Prokaryotic dsDNA virus sp. | 2591644 | Viruses | Viruses | 191 | 4.81e-44 | NTclustered | gi|1707910805|gb|MK892832.1| | 2591644 | g3635 | i0 | 91.971 | 0.526923076923077 | 137 | 10 | 52 | 1 | 1 | 136 | 16300 | 16164 | MAG: Prokaryotic dsDNA virus sp. isolate Tp1_111_DCM_112609_1, complete genome | blastn | 137 | 191 | 1 | Viruses | Prokaryotic dsDNA virus sp. | ||||||||
| 25160940 | 25160940 | PRJNA951412_P_NODE_4060_length_253_cov_0.866667_g3975_i0 | PRJNA951412 | 4060 | 253 | 0.866667 | 2.19266751 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 363 | 9.339999999999996e-96 | NTclustered | gi|2057857637|tpg|BK050476.1| | 2832643 | g3975 | i0 | 93.145 | 2.61660079051383 | 248 | 15 | 98 | 2 | 1 | 248 | 19418 | 19663 | MAG TPA_asm: Caudoviricetes sp. isolate ctwJB10, partial genome | blastn | 662 | 363 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 25160958 | 25160958 | PRJNA951412_P_NODE_5520_length_248_cov_0.891429_g5435_i0 | PRJNA951412 | 5520 | 248 | 0.891429 | 2.21074392 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 442 | 1.1399999999999995e-119 | NTclustered | gi|2915040595|gb|OR222730.1| | 2832643 | g5435 | i0 | 98.79 | 1 | 248 | 3 | 100 | 0 | 1 | 248 | 24683 | 24930 | MAG: Caudoviricetes sp. isolate MSP0629 genomic sequence | blastn | 248 | 442 | 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);;