contig_metadata
25 rows where analysis = "blastn", bioproject = "PRJNA330616" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 389662 | 389662 | PRJNA330616_P_NODE_20261_length_187_cov_2.188406_g19852_i0 | PRJNA330616 | 20261 | 187 | 2.188406 | 4.09231922 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 302 | 1.44e-77 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g19852 | i0 | 100 | 1.54010695187166 | 163 | 0 | 100 | 0 | 25 | 187 | 48890 | 49052 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 288 | 302 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 2940434 | 2940434 | PRJNA330616_P_NODE_29643_length_163_cov_1.342105_g29234_i0 | PRJNA330616 | 29643 | 163 | 1.342105 | 2.18763115 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 302 | 1.22e-77 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g29234 | i0 | 100 | 1 | 163 | 0 | 100 | 0 | 1 | 163 | 36939 | 37101 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 163 | 302 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 4216831 | 4216831 | PRJNA330616_P_NODE_13484_length_226_cov_1.706215_g13075_i0 | PRJNA330616 | 13484 | 226 | 1.706215 | 3.8560459 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 418 | 1.7199999999999998e-112 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g13075 | i0 | 100 | 1 | 226 | 0 | 100 | 0 | 1 | 226 | 32093 | 32318 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 226 | 418 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 5493282 | 5493282 | PRJNA330616_P_NODE_26085_length_167_cov_0.864407_g25676_i0 | PRJNA330616 | 26085 | 167 | 0.864407 | 1.44355969 | Chrocurosk virus | 3129322 | Viruses | Viruses | 213 | 6.07e-51 | NTclustered | gi|2717317280|gb|PP171770.1| | 3129322 | g25676 | i0 | 91.25 | 309.377245508982 | 160 | 8 | 93 | 6 | 2 | 157 | 1662 | 1819 | MAG: Chrocurosk virus isolate CC1A_k141_129357 genomic sequence | blastn | 51666 | 213 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Chrocurosk virus | |||
| 6767296 | 6767296 | PRJNA330616_P_NODE_23046_length_176_cov_1.551181_g22637_i0 | PRJNA330616 | 23046 | 176 | 1.551181 | 2.73007856 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 326 | 7.92e-85 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g22637 | i0 | 100 | 1 | 176 | 0 | 100 | 0 | 1 | 176 | 34281 | 34106 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 176 | 326 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 6767511 | 6767511 | PRJNA330616_P_NODE_8186_length_290_cov_1.481328_g7777_i0 | PRJNA330616 | 8186 | 290 | 1.481328 | 4.2958512 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 283 | 8.75e-72 | NTclustered | gi|2914891224|gb|OR222812.1| | 2832643 | g7777 | i0 | 85.556 | 1.86206896551724 | 270 | 39 | 93 | 0 | 17 | 286 | 71906 | 72175 | MAG: Caudoviricetes sp. isolate MSP0544 genomic sequence | blastn | 540 | 283 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 8042899 | 8042899 | PRJNA330616_P_NODE_18247_length_197_cov_1.297297_g17838_i0 | PRJNA330616 | 18247 | 197 | 1.297297 | 2.55567509 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 364 | 1.929999999999999e-96 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g17838 | i0 | 100 | 1 | 197 | 0 | 100 | 0 | 1 | 197 | 17389 | 17585 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 197 | 364 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11868509 | 11868509 | PRJNA330616_P_NODE_6390_length_331_cov_2.319149_g5981_i0 | PRJNA330616 | 6390 | 331 | 2.319149 | 7.67638319 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 568 | 2.4999999999999998e-157 | NTclustered | gi|2054434277|tpg|BK035998.1| | 2832643 | g5981 | i0 | 97.59 | 348.812688821752 | 332 | 7 | 100 | 1 | 1 | 331 | 18070 | 18401 | MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome | blastn | 115457 | 568 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 13143453 | 13143453 | PRJNA330616_P_NODE_8491_length_284_cov_5.391489_g8082_i0 | PRJNA330616 | 8491 | 284 | 5.391489 | 15.31182876 | Sopidub virus | 3131684 | Viruses | Viruses | 141 | 5.44e-29 | NTclustered | gi|2717323145|gb|PP173985.1| | 3131684 | g8082 | i0 | 88.136 | 10.6901408450704 | 118 | 14 | 42 | 0 | 5 | 122 | 2262 | 2145 | MAG: Sopidub virus isolate SP1B_k141_213983 genomic sequence | blastn | 3036 | 141 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Picobirnaviridae | Sopidub virus | |||
| 14418540 | 14418540 | PRJNA330616_P_NODE_26012_length_167_cov_0.864407_g25603_i0 | PRJNA330616 | 26012 | 167 | 0.864407 | 1.44355969 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 309 | 7.53e-80 | NTclustered | gi|2914953382|gb|OR221926.1| | 2832643 | g25603 | i0 | 100 | 99.4491017964072 | 167 | 0 | 100 | 0 | 1 | 167 | 20573 | 20739 | MAG: Caudoviricetes sp. isolate MSP0203 genomic sequence | blastn | 16608 | 309 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 15692353 | 15692353 | PRJNA330616_P_NODE_23613_length_174_cov_1.224000_g23204_i0 | PRJNA330616 | 23613 | 174 | 1.224 | 2.12976 | Acinetobacter phage vB_ApiM_IME-Ap7 | 3096134 | Viruses | Viruses | 300 | 4.73e-77 | NTclustered | gi|2645993895|gb|OR791279.1| | 3096134 | g23204 | i0 | 97.701 | 34.3908045977011 | 174 | 4 | 100 | 0 | 1 | 174 | 1357 | 1530 | Acinetobacter phage vB_ApiM_IME-Ap7, complete genome | blastn | 5984 | 300 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Obolenskvirus | Acinetobacter phage vB_ApiM_IME-Ap7 | ||||
| 16966939 | 16966939 | PRJNA330616_P_NODE_15894_length_210_cov_1.267081_g15485_i0 | PRJNA330616 | 15894 | 210 | 1.267081 | 2.6608701 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 388 | 1.24e-103 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g15485 | i0 | 100 | 1 | 210 | 0 | 100 | 0 | 1 | 210 | 29346 | 29137 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 210 | 388 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17646926 | 17646926 | PRJNA330616_P_NODE_23274_length_175_cov_1.619048_g22865_i0 | PRJNA330616 | 23274 | 175 | 1.619048 | 2.833334 | Obolenskvirus | 1915205 | Viruses | Viruses | 274 | 2.89e-69 | NTclustered | gi|2619235855|gb|OR665531.1| | 3090859 | g22865 | i0 | 94.857 | 51.84 | 175 | 9 | 100 | 0 | 1 | 175 | 33594 | 33420 | Acinetobacter phage NL, complete genome | blastn | 9072 | 274 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Obolenskvirus | Acinetobacter phage NL | ||||
| 18241125 | 18241125 | PRJNA330616_P_NODE_11035_length_249_cov_1.210000_g10626_i0 | PRJNA330616 | 11035 | 249 | 1.21 | 3.0129 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 388 | 1.51e-103 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g10626 | i0 | 95.142 | 1.99196787148594 | 247 | 11 | 99 | 1 | 4 | 249 | 61023 | 61269 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 496 | 388 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18241152 | 18241152 | PRJNA330616_P_NODE_12495_length_234_cov_1.102703_g12086_i0 | PRJNA330616 | 12495 | 234 | 1.102703 | 2.58032502 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 427 | 2.9799999999999993e-115 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g12086 | i0 | 99.573 | 1 | 234 | 1 | 100 | 0 | 1 | 234 | 50811 | 51044 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 234 | 427 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18920780 | 18920780 | PRJNA330616_P_NODE_20095_length_188_cov_1.467626_g19686_i0 | PRJNA330616 | 20095 | 188 | 1.467626 | 2.75913688 | Obolenskvirus | 1915205 | Viruses | Viruses | 309 | 8.66e-80 | NTclustered | gi|2183381795|gb|OL743187.1| | 2911659 | g19686 | i0 | 96.277 | 56.3457446808511 | 188 | 7 | 100 | 0 | 1 | 188 | 16894 | 17081 | Acinetobacter phage vB_AbM_WUPSU, complete genome | blastn | 10593 | 309 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Obolenskvirus | Acinetobacter phage vB_AbM_WUPSU | ||||
| 19515513 | 19515513 | PRJNA330616_P_NODE_20496_length_186_cov_1.956204_g20087_i0 | PRJNA330616 | 20496 | 186 | 1.956204 | 3.63853944 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 344 | 2.34e-90 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g20087 | i0 | 100 | 1 | 186 | 0 | 100 | 0 | 1 | 186 | 36395 | 36580 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 186 | 344 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19515536 | 19515536 | PRJNA330616_P_NODE_21816_length_181_cov_1.545455_g21407_i0 | PRJNA330616 | 21816 | 181 | 1.545455 | 2.79727355 | Acinetobacter phage Scipio | 2935726 | Viruses | Viruses | 324 | 2.95e-84 | NTclustered | gi|2239983361|gb|ON036883.1| | 2935726 | g21407 | i0 | 98.895 | 22.5193370165746 | 181 | 2 | 100 | 0 | 1 | 181 | 10810 | 10990 | Acinetobacter phage Scipio, complete genome | blastn | 4076 | 324 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Obolenskvirus | Acinetobacter phage Scipio | ||||
| 20791029 | 20791029 | PRJNA330616_P_NODE_13397_length_227_cov_1.146067_g12988_i0 | PRJNA330616 | 13397 | 227 | 1.146067 | 2.60157209 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 420 | 4.81e-113 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g12988 | i0 | 100 | 67.4581497797357 | 227 | 0 | 100 | 0 | 1 | 227 | 18457 | 18683 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 15313 | 420 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 22066097 | 22066097 | PRJNA330616_P_NODE_22158_length_179_cov_3.530769_g21749_i0 | PRJNA330616 | 22158 | 179 | 3.530769 | 6.32007651 | Potexvirus trifolii | 3433859 | Viruses | Viruses | 292 | 8.210000000000001e-75 | NTclustered | gi|1843793423|gb|MN399742.1| | 12188 | g21749 | i0 | 96.089 | 14.2849162011173 | 179 | 7 | 100 | 0 | 1 | 179 | 2822 | 2644 | White clover mosaic virus isolate Kreis Stormarn_18 RNA replication protein, triple gene block protein 1, triple gene block protein 2, triple gene block protein 3, and coat protein genes, complete cds | blastn | 2557 | 292 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus trifolii | ||
| 22066258 | 22066258 | PRJNA330616_P_NODE_31958_length_161_cov_0.910714_g31549_i0 | PRJNA330616 | 31958 | 161 | 0.910714 | 1.46624954 | Bromovirus BMV | 3427622 | Viruses | Viruses | 292 | 7.24e-75 | NTclustered | gi|2239525971|gb|MW568013.1| | 12302 | g31549 | i0 | 99.379 | 34.9627329192547 | 161 | 1 | 100 | 0 | 1 | 161 | 1108 | 948 | Brome mosaic virus isolate BMV-PK RdRp polymerase gene, complete cds | blastn | 5629 | 292 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Bromoviridae | Bromovirus | Bromovirus BMV | ||
| 22066326 | 22066326 | PRJNA330616_P_NODE_7298_length_308_cov_2.374517_g6889_i0 | PRJNA330616 | 7298 | 308 | 2.374517 | 7.31351236 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 453 | 6.75e-123 | NTclustered | gi|2054434277|tpg|BK035998.1| | 2832643 | g6889 | i0 | 93.182 | 277.25974025974 | 308 | 21 | 100 | 0 | 1 | 308 | 17709 | 18016 | MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome | blastn | 85396 | 453 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 23341790 | 23341790 | PRJNA330616_P_NODE_7059_length_314_cov_1.332075_g6650_i0 | PRJNA330616 | 7059 | 314 | 1.332075 | 4.1827155 | Maltschvirus maltsch | 2956182 | Viruses | Viruses | 237 | 7.56e-58 | NTclustered | gi|1219999807|gb|MF417878.1| | 2100421 | g6650 | i0 | 83.083 | 8.82484076433121 | 266 | 39 | 84 | 6 | 51 | 313 | 24062 | 24324 | Uncultured Caudovirales phage clone 8S_7, partial genome | blastn | 2771 | 237 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 24615906 | 24615906 | PRJNA330616_P_NODE_30060_length_163_cov_0.894737_g29651_i0 | PRJNA330616 | 30060 | 163 | 0.894737 | 1.45842131 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 213 | 5.89e-51 | NTclustered | gi|2059603108|tpg|BK037133.1| | 2832643 | g29651 | i0 | 90.303 | 1.01226993865031 | 165 | 13 | 100 | 3 | 1 | 163 | 33539 | 33702 | MAG TPA_asm: Caudoviricetes sp. isolate ctWG610, partial genome | blastn | 165 | 213 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 24616010 | 24616010 | PRJNA330616_P_NODE_700_length_1171_cov_3.073084_g452_i0 | PRJNA330616 | 700 | 1171 | 3.073084 | 35.98581364 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 1609 | 0 | NTclustered | gi|2914927280|gb|OR221502.1| | 2832643 | g452 | i0 | 91.433 | 8.00170794192997 | 1179 | 92 | 100 | 4 | 1 | 1171 | 29558 | 28381 | MAG: Caudoviricetes sp. isolate MSP1578 genomic sequence | blastn | 9370 | 1609 | 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);;