contig_metadata
23 rows where analysis = "blastn", bioproject = "PRJNA637328" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 608916 | 608916 | PRJNA637328_P_NODE_12001_length_277_cov_1.421053_g11525_i0 | PRJNA637328 | 12001 | 277 | 1.421053 | 3.93631681 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 512 | 9.73e-141 | NTclustered | gi|2914987236|gb|OR222129.1| | 2832643 | g11525 | i0 | 100 | 22.014440433213 | 277 | 0 | 100 | 0 | 1 | 277 | 29692 | 29968 | MAG: Caudoviricetes sp. isolate MSP0851 genomic sequence | blastn | 6098 | 512 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 1885106 | 1885106 | PRJNA637328_P_NODE_11842_length_278_cov_1.820961_g11366_i0 | PRJNA637328 | 11842 | 278 | 1.820961 | 5.06227158 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 499 | 7.6e-137 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g11366 | i0 | 99.275 | 0.992805755395683 | 276 | 2 | 99 | 0 | 1 | 276 | 55738 | 55463 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 276 | 499 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 1885145 | 1885145 | PRJNA637328_P_NODE_14282_length_262_cov_2.488263_g13805_i0 | PRJNA637328 | 14282 | 262 | 2.488263 | 6.51924906 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 473 | 4.31e-129 | NTclustered | gi|2914987236|gb|OR222129.1| | 2832643 | g13805 | i0 | 99.237 | 2 | 262 | 2 | 100 | 0 | 1 | 262 | 12335 | 12596 | MAG: Caudoviricetes sp. isolate MSP0851 genomic sequence | blastn | 524 | 473 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 1885302 | 1885302 | PRJNA637328_P_NODE_5522_length_374_cov_1.978462_g5047_i0 | PRJNA637328 | 5522 | 374 | 1.978462 | 7.39944788 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 623 | 6.009999999999999e-174 | NTclustered | gi|2057944037|tpg|BK046057.1| | 2832643 | g5047 | i0 | 97.275 | 99.4171122994652 | 367 | 10 | 98 | 0 | 1 | 367 | 29121 | 29487 | MAG TPA_asm: Caudoviricetes sp. isolate ctulL1, partial genome | blastn | 37182 | 623 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 1885347 | 1885347 | PRJNA637328_P_NODE_8762_length_309_cov_2.350000_g8287_i0 | PRJNA637328 | 8762 | 309 | 2.35 | 7.2615 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 566 | 8.33e-157 | NTclustered | gi|2914987236|gb|OR222129.1| | 2832643 | g8287 | i0 | 99.676 | 16.0582524271845 | 309 | 1 | 100 | 0 | 1 | 309 | 42696 | 43004 | MAG: Caudoviricetes sp. isolate MSP0851 genomic sequence | blastn | 4962 | 566 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 3160130 | 3160130 | PRJNA637328_S_NODE_1643_length_273_cov_2.881356_g1566_i0 | PRJNA637328 | 1643 | 273 | 2.881356 | 7.86610188 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 460 | 3.5099999999999996e-125 | NTclustered | gi|2054434277|tpg|BK035998.1| | 2832643 | g1566 | i0 | 97.08 | 462.197802197802 | 274 | 7 | 100 | 1 | 1 | 273 | 18395 | 18122 | MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome | blastn | 126180 | 460 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 4436662 | 4436662 | PRJNA637328_P_NODE_13164_length_268_cov_2.675799_g12688_i0 | PRJNA637328 | 13164 | 268 | 2.675799 | 7.17114132 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 492 | 1.22e-134 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g12688 | i0 | 100 | 0.992537313432836 | 266 | 0 | 99 | 0 | 3 | 268 | 51133 | 50868 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 266 | 492 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 4436744 | 4436744 | PRJNA637328_P_NODE_17864_length_246_cov_1.832487_g17387_i0 | PRJNA637328 | 17864 | 246 | 1.832487 | 4.50791802 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 455 | 1.4500000000000002e-123 | NTclustered | gi|2914987236|gb|OR222129.1| | 2832643 | g17387 | i0 | 100 | 238.788617886179 | 246 | 0 | 100 | 0 | 1 | 246 | 30544 | 30789 | MAG: Caudoviricetes sp. isolate MSP0851 genomic sequence | blastn | 58742 | 455 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 6987583 | 6987583 | PRJNA637328_P_NODE_19626_length_237_cov_2.106383_g19149_i0 | PRJNA637328 | 19626 | 237 | 2.106383 | 4.99212771 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 435 | 1.81e-117 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g19149 | i0 | 100 | 0.991561181434599 | 235 | 0 | 99 | 0 | 1 | 235 | 19094 | 18860 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 235 | 435 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 8262183 | 8262183 | PRJNA637328_P_NODE_15027_length_258_cov_3.698565_g14550_i0 | PRJNA637328 | 15027 | 258 | 3.698565 | 9.5422977 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 468 | 1.97e-127 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g14550 | i0 | 100 | 0.98062015503876 | 253 | 0 | 98 | 0 | 4 | 256 | 11096 | 10844 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 253 | 468 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 8262290 | 8262290 | PRJNA637328_P_NODE_20767_length_228_cov_3.346369_g20290_i0 | PRJNA637328 | 20767 | 228 | 3.346369 | 7.62972132 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 412 | 8.09e-111 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g20290 | i0 | 99.558 | 0.991228070175439 | 226 | 1 | 99 | 0 | 3 | 228 | 31345 | 31570 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 226 | 412 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 8262333 | 8262333 | PRJNA637328_P_NODE_4827_length_400_cov_1.367521_g4352_i0 | PRJNA637328 | 4827 | 400 | 1.367521 | 5.470084 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 697 | 0 | NTclustered | gi|2914852811|gb|OR221766.1| | 2832643 | g4352 | i0 | 98.241 | 2.9525 | 398 | 7 | 99 | 0 | 3 | 400 | 12587 | 12984 | MAG: Caudoviricetes sp. isolate MSP1259 genomic sequence | blastn | 1181 | 697 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 9537541 | 9537541 | PRJNA637328_P_NODE_17068_length_249_cov_3.865000_g16591_i0 | PRJNA637328 | 17068 | 249 | 3.865 | 9.62385 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 453 | 5.29e-123 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g16591 | i0 | 100 | 0.983935742971888 | 245 | 0 | 98 | 0 | 3 | 247 | 711 | 955 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 245 | 453 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11358490 | 11358490 | PRJNA637328_P_NODE_10129_length_293_cov_3.225410_g9654_i0 | PRJNA637328 | 10129 | 293 | 3.22541 | 9.4504513 | Viruses | 10239 | Viruses | Viruses | 488 | 1.7499999999999996e-133 | NTclustered | gi|2052881264|tpg|BK032820.1| | 2827828 | g9654 | i0 | 96.907 | 99.1501706484642 | 291 | 9 | 99 | 0 | 1 | 291 | 32385 | 32095 | MAG TPA_asm: Siphoviridae sp. ctHNg1, partial genome | blastn | 29051 | 492 | 0.991869918699187 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Siphoviridae sp. ctHNg1 | |||||
| 13363237 | 13363237 | PRJNA637328_P_NODE_20751_length_228_cov_4.324022_g20274_i0 | PRJNA637328 | 20751 | 228 | 4.324022 | 9.85877016 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 420 | 4.84e-113 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g20274 | i0 | 100 | 0.995614035087719 | 227 | 0 | 99 | 0 | 2 | 228 | 17838 | 18064 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 227 | 420 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 13363253 | 13363253 | PRJNA637328_P_NODE_2451_length_581_cov_3.783835_g2018_i0 | PRJNA637328 | 2451 | 581 | 3.783835 | 21.98408135 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 1026 | 0 | NTclustered | gi|2054434277|tpg|BK035998.1| | 2832643 | g2018 | i0 | 98.618 | 381.590361445783 | 579 | 8 | 99 | 0 | 3 | 581 | 18330 | 17752 | MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome | blastn | 221704 | 1026 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14637950 | 14637950 | PRJNA637328_P_NODE_17972_length_246_cov_0.928934_g17495_i0 | PRJNA637328 | 17972 | 246 | 0.928934 | 2.28517764 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 344 | 3.27e-90 | NTclustered | gi|2914869935|gb|OR222861.1| | 2832643 | g17495 | i0 | 91.87 | 93.6463414634146 | 246 | 20 | 100 | 0 | 1 | 246 | 75858 | 75613 | MAG: Caudoviricetes sp. isolate MSP0489 genomic sequence | blastn | 23037 | 344 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 15183576 | 15183576 | PRJNA637328_P_NODE_21252_length_222_cov_4.393064_g20775_i0 | PRJNA637328 | 21252 | 222 | 4.393064 | 9.75260208 | Cimandefvirus | 2843366 | Viruses | Viruses | 291 | 3.83e-74 | NTclustered | gi|1886402759|gb|MT740733.1| | 2759723 | g20775 | i0 | 90.498 | 10.9144144144144 | 221 | 19 | 99 | 2 | 1 | 220 | 41610 | 41829 | Ralstonia phage Dimitile, complete genome | blastn | 2423 | 291 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Cimandefvirus | Ralstonia phage Dimitile | ||||
| 16457862 | 16457862 | PRJNA637328_P_NODE_7513_length_332_cov_3.070671_g7038_i0 | PRJNA637328 | 7513 | 332 | 3.070671 | 10.19462772 | Sextaecvirus | 1922243 | Viruses | Viruses | 278 | 4.74e-70 | NTclustered | gi|2465100102|gb|OQ355701.1| | 3028898 | g7038 | i0 | 100 | 23.2259036144578 | 150 | 0 | 91 | 0 | 183 | 332 | 24530 | 24679 | Staphylococcus phage vB_SepS_BE22, complete genome | blastn | 7711 | 278 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Sextaecvirus | Staphylococcus phage vB_SepS_BE22 | ||||
| 17186891 | 17186891 | PRJNA637328_P_NODE_12694_length_271_cov_3.049550_g12218_i0 | PRJNA637328 | 12694 | 271 | 3.04955 | 8.2642805 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 499 | 7.379999999999998e-137 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g12218 | i0 | 100 | 0.996309963099631 | 270 | 0 | 99 | 0 | 2 | 271 | 39423 | 39154 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 270 | 499 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18461101 | 18461101 | PRJNA637328_P_NODE_16355_length_252_cov_4.019704_g15878_i0 | PRJNA637328 | 16355 | 252 | 4.019704 | 10.12965408 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 409 | 1.18e-109 | NTclustered | gi|2914981140|gb|OR222104.1| | 2832643 | g15878 | i0 | 96.371 | 1.98412698412698 | 248 | 9 | 98 | 0 | 1 | 248 | 180061 | 179814 | MAG: Caudoviricetes sp. isolate MSP0003 genomic sequence | blastn | 500 | 409 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19735616 | 19735616 | PRJNA637328_P_NODE_10396_length_291_cov_1.491736_g9921_i0 | PRJNA637328 | 10396 | 291 | 1.491736 | 4.34095176 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 499 | 8.01e-137 | NTclustered | gi|2914987236|gb|OR222129.1| | 2832643 | g9921 | i0 | 97.595 | 2 | 291 | 7 | 100 | 0 | 1 | 291 | 15321 | 15031 | MAG: Caudoviricetes sp. isolate MSP0851 genomic sequence | blastn | 582 | 499 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19735701 | 19735701 | PRJNA637328_P_NODE_14156_length_263_cov_1.373832_g13679_i0 | PRJNA637328 | 14156 | 263 | 1.373832 | 3.61317816 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 477 | 3.339999999999999e-130 | NTclustered | gi|2058123527|tpg|BK033972.1| | 2832643 | g13679 | i0 | 99.617 | 1.97718631178707 | 261 | 1 | 99 | 0 | 3 | 263 | 60503 | 60763 | MAG TPA_asm: Caudoviricetes sp. isolate ct2Fx2, partial genome | blastn | 520 | 477 | 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);;