contig_metadata
28 rows where analysis = "blastn", bioproject = "PRJNA554794" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 520850 | 520850 | PRJNA554794_P_NODE_11101_length_332_cov_0.826855_g7175_i0 | PRJNA554794 | 11101 | 332 | 0.826855 | 2.7451586 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 614 | 3.1799999999999995e-171 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g7175 | i0 | 100 | 1 | 332 | 0 | 100 | 0 | 1 | 332 | 50692 | 50361 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 332 | 614 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 520892 | 520892 | PRJNA554794_P_NODE_21061_length_185_cov_1.198529_g17132_i0 | PRJNA554794 | 21061 | 185 | 1.198529 | 2.21727865 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 342 | 8.369999999999999e-90 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g17132 | i0 | 100 | 1 | 185 | 0 | 100 | 0 | 1 | 185 | 10983 | 11167 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 185 | 342 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 520912 | 520912 | PRJNA554794_P_NODE_24341_length_162_cov_0.893805_g20412_i0 | PRJNA554794 | 24341 | 162 | 0.893805 | 1.4479641 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 294 | 2.03e-75 | NTclustered | gi|2058123758|tpg|BK033975.1| | 2832643 | g20412 | i0 | 99.383 | 1 | 162 | 1 | 100 | 0 | 1 | 162 | 8623 | 8462 | MAG TPA_asm: Caudoviricetes sp. isolate ctsWN7, partial genome | blastn | 162 | 294 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 4348027 | 4348027 | PRJNA554794_P_NODE_21064_length_185_cov_1.169118_g17135_i0 | PRJNA554794 | 21064 | 185 | 1.169118 | 2.1628683 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 342 | 8.369999999999999e-90 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g17135 | i0 | 100 | 1 | 185 | 0 | 100 | 0 | 1 | 185 | 46894 | 46710 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 185 | 342 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 4951718 | 4951718 | PRJNA554794_P_NODE_24084_length_162_cov_5.283186_g20155_i0 | PRJNA554794 | 24084 | 162 | 5.283186 | 8.55876132 | root | 1 | Root_unresolved | Root_unresolved | 87.9 | 3.7e-13 | NTclustered | gi|823077642|gb|KR534209.1| | 10359 | g20155 | i0 | 98.039 | 32.1111111111111 | 51 | 0 | 31 | 1 | 82 | 131 | 175264 | 175214 | Human herpesvirus 5 strain JER4755, complete genome | blastn | 5202 | 87.9 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Cytomegalovirus | Cytomegalovirus humanbeta5 | ||
| 5624781 | 5624781 | PRJNA554794_P_NODE_23065_length_165_cov_1.741379_g19136_i0 | PRJNA554794 | 23065 | 165 | 1.741379 | 2.87327535 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 65.8 | 1.77e-6 | NTclustered | gi|2054588553|tpg|BK021483.1| | 2832643 | g19136 | i0 | 87.719 | 1.60606060606061 | 57 | 5 | 35 | 2 | 89 | 145 | 9394 | 9448 | MAG TPA_asm: Caudoviricetes sp. isolate cttwS10, partial genome | blastn | 265 | 65.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 6898788 | 6898788 | PRJNA554794_P_NODE_12626_length_269_cov_0.945455_g8697_i0 | PRJNA554794 | 12626 | 269 | 0.945455 | 2.54327395 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 479 | 9.539999999999999e-131 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g8697 | i0 | 98.141 | 1 | 269 | 5 | 100 | 0 | 1 | 269 | 48357 | 48625 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 269 | 479 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 6898830 | 6898830 | PRJNA554794_P_NODE_21626_length_178_cov_0.829457_g17697_i0 | PRJNA554794 | 21626 | 178 | 0.829457 | 1.47643346 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 318 | 1.34e-82 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g17697 | i0 | 98.876 | 1.80337078651685 | 178 | 2 | 100 | 0 | 1 | 178 | 42610 | 42787 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 321 | 318 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 6898835 | 6898835 | PRJNA554794_P_NODE_22226_length_171_cov_0.885246_g18297_i0 | PRJNA554794 | 22226 | 171 | 0.885246 | 1.51377066 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 316 | 4.6e-82 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g18297 | i0 | 100 | 1 | 171 | 0 | 100 | 0 | 1 | 171 | 54340 | 54170 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 171 | 316 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 6898848 | 6898848 | PRJNA554794_P_NODE_24066_length_163_cov_0.842105_g20137_i0 | PRJNA554794 | 24066 | 163 | 0.842105 | 1.37263115 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 302 | 1.22e-77 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g20137 | i0 | 100 | 99.7975460122699 | 163 | 0 | 100 | 0 | 1 | 163 | 17121 | 17283 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 16267 | 302 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 8173708 | 8173708 | PRJNA554794_P_NODE_24827_length_161_cov_0.642857_g20898_i0 | PRJNA554794 | 24827 | 161 | 0.642857 | 1.03499977 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 298 | 1.56e-76 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g20898 | i0 | 100 | 1 | 161 | 0 | 100 | 0 | 1 | 161 | 34194 | 34354 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 161 | 298 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 9449334 | 9449334 | PRJNA554794_P_NODE_24428_length_162_cov_0.867257_g20499_i0 | PRJNA554794 | 24428 | 162 | 0.867257 | 1.40495634 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 300 | 4.36e-77 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g20499 | i0 | 100 | 1 | 162 | 0 | 100 | 0 | 1 | 162 | 61843 | 62004 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 162 | 300 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11999797 | 11999797 | PRJNA554794_P_NODE_10450_length_367_cov_0.952830_g6552_i0 | PRJNA554794 | 10450 | 367 | 0.95283 | 3.4968861 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 678 | 0 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g6552 | i0 | 100 | 1 | 367 | 0 | 100 | 0 | 1 | 367 | 42261 | 41895 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 367 | 678 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11999851 | 11999851 | PRJNA554794_P_NODE_19710_length_207_cov_0.873418_g15781_i0 | PRJNA554794 | 19710 | 207 | 0.873418 | 1.80797526 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 383 | 5.65e-102 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g15781 | i0 | 100 | 1 | 207 | 0 | 100 | 0 | 1 | 207 | 40259 | 40465 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 207 | 383 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 13274903 | 13274903 | PRJNA554794_P_NODE_10871_length_344_cov_0.806780_g6950_i0 | PRJNA554794 | 10871 | 344 | 0.80678 | 2.7753232 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 630 | 3.289999999999999e-176 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g6950 | i0 | 99.709 | 1 | 344 | 1 | 100 | 0 | 1 | 344 | 40879 | 40536 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 344 | 630 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 13274922 | 13274922 | PRJNA554794_P_NODE_14451_length_220_cov_0.883041_g10522_i0 | PRJNA554794 | 14451 | 220 | 0.883041 | 1.9426902 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 407 | 3.61e-109 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g10522 | i0 | 100 | 1 | 220 | 0 | 100 | 0 | 1 | 220 | 57260 | 57479 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 220 | 407 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 13274963 | 13274963 | PRJNA554794_P_NODE_21451_length_180_cov_0.656489_g17522_i0 | PRJNA554794 | 21451 | 180 | 0.656489 | 1.1816802 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 333 | 4.87e-87 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g17522 | i0 | 100 | 1 | 180 | 0 | 100 | 0 | 1 | 180 | 25804 | 25983 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 180 | 333 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 13274975 | 13274975 | PRJNA554794_P_NODE_22391_length_169_cov_0.800000_g18462_i0 | PRJNA554794 | 22391 | 169 | 0.8 | 1.352 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 313 | 5.859999999999999e-81 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g18462 | i0 | 100 | 1 | 169 | 0 | 100 | 0 | 1 | 169 | 1202 | 1370 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 169 | 313 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14549906 | 14549906 | PRJNA554794_P_NODE_13232_length_251_cov_0.688119_g9303_i0 | PRJNA554794 | 13232 | 251 | 0.688119 | 1.72717869 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 464 | 2.47e-126 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g9303 | i0 | 100 | 1 | 251 | 0 | 100 | 0 | 1 | 251 | 16011 | 16261 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 251 | 464 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14549910 | 14549910 | PRJNA554794_P_NODE_13832_length_235_cov_0.639785_g9903_i0 | PRJNA554794 | 13832 | 235 | 0.639785 | 1.50349475 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 435 | 1.79e-117 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g9903 | i0 | 100 | 1.52765957446809 | 235 | 0 | 100 | 0 | 1 | 235 | 41765 | 41531 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 359 | 435 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14549913 | 14549913 | PRJNA554794_P_NODE_14632_length_217_cov_0.642857_g10703_i0 | PRJNA554794 | 14632 | 217 | 0.642857 | 1.39499969 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 401 | 1.6499999999999994e-107 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g10703 | i0 | 100 | 1 | 217 | 0 | 100 | 0 | 1 | 217 | 52823 | 52607 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 217 | 401 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 15151529 | 15151529 | PRJNA554794_P_NODE_19512_length_208_cov_3.773585_g15583_i0 | PRJNA554794 | 19512 | 208 | 3.773585 | 7.8490568 | root | 1 | Root_unresolved | Root_unresolved | 87.9 | 4.99e-13 | NTclustered | gi|823077642|gb|KR534209.1| | 10359 | g15583 | i0 | 98.039 | 25.0096153846154 | 51 | 0 | 24 | 1 | 128 | 177 | 175264 | 175214 | Human herpesvirus 5 strain JER4755, complete genome | blastn | 5202 | 87.9 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Cytomegalovirus | Cytomegalovirus humanbeta5 | ||
| 15823691 | 15823691 | PRJNA554794_P_NODE_22153_length_172_cov_0.878049_g18224_i0 | PRJNA554794 | 22153 | 172 | 0.878049 | 1.51024428 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 318 | 1.2899999999999999e-82 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g18224 | i0 | 100 | 1 | 172 | 0 | 100 | 0 | 1 | 172 | 19092 | 19263 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 172 | 318 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17098480 | 17098480 | PRJNA554794_P_NODE_13614_length_241_cov_0.895833_g9685_i0 | PRJNA554794 | 13614 | 241 | 0.895833 | 2.15895753 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 446 | 8.519999999999999e-121 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g9685 | i0 | 100 | 1.32780082987552 | 241 | 0 | 100 | 0 | 1 | 241 | 43980 | 44220 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 320 | 446 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18372628 | 18372628 | PRJNA554794_P_NODE_13675_length_239_cov_1.084211_g9746_i0 | PRJNA554794 | 13675 | 239 | 1.084211 | 2.59126429 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 442 | 1.0899999999999994e-119 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g9746 | i0 | 100 | 2.35564853556485 | 239 | 0 | 100 | 0 | 1 | 239 | 49730 | 49492 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 563 | 442 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19647239 | 19647239 | PRJNA554794_P_NODE_13716_length_238_cov_0.777778_g9787_i0 | PRJNA554794 | 13716 | 238 | 0.777778 | 1.85111164 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 440 | 3.899999999999999e-119 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g9787 | i0 | 100 | 1 | 238 | 0 | 100 | 0 | 1 | 238 | 50907 | 51144 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 238 | 440 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 22197807 | 22197807 | PRJNA554794_P_NODE_21278_length_182_cov_2.180451_g17349_i0 | PRJNA554794 | 21278 | 182 | 2.180451 | 3.96842082 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 337 | 3.82e-88 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g17349 | i0 | 100 | 1 | 182 | 0 | 100 | 0 | 1 | 182 | 53425 | 53244 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 182 | 337 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 22800711 | 22800711 | PRJNA554794_P_NODE_22298_length_170_cov_1.099174_g18369_i0 | PRJNA554794 | 22298 | 170 | 1.099174 | 1.8685958 | root | 1 | Root_unresolved | Root_unresolved | 305 | 9.88e-79 | NTclustered | gi|2620236085|gb|OR777220.1| | 10515 | g18369 | i0 | 100 | 97.0588235294118 | 165 | 0 | 97 | 0 | 1 | 165 | 12417 | 12581 | Human adenovirus 2 isolate HAdV-C2/USA/13R1/2017, complete genome | blastn | 16500 | 305 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari |
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);;