contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA986547" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3524606 | 3524606 | PRJNA986547_P_NODE_10483_length_245_cov_3.162791_g10401_i0 | PRJNA986547 | 10483 | 245 | 3.162791 | 7.74883795 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 374 | 4.16e-99 | NTclustered | gi|2059992605|tpg|BK026306.1| | 2832643 | g10401 | i0 | 94.262 | 0.995918367346939 | 244 | 14 | 99 | 0 | 1 | 244 | 13928 | 14171 | MAG TPA_asm: Caudoviricetes sp. isolate ct5Vs3, partial genome | blastn | 244 | 374 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 3824280 | 3824280 | PRJNA986547_P_NODE_6223_length_267_cov_3.835052_g6141_i0 | PRJNA986547 | 6223 | 267 | 3.835052 | 10.23958884 | Obolenskvirus | 1915205 | Viruses | Viruses | 237 | 6.28e-58 | NTclustered | gi|1503529053|gb|MH853788.1| | 2419627 | g6141 | i0 | 83.529 | 11.6367041198502 | 255 | 40 | 95 | 2 | 3 | 256 | 1065 | 1318 | Acinetobacter phage vB_AbaM_IME512, complete genome | blastn | 3107 | 237 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Obolenskvirus | Acinetobacter phage vB_AbaM_IME512 | ||||
| 4802001 | 4802001 | PRJNA986547_P_NODE_12644_length_237_cov_5.426829_g12562_i0 | PRJNA986547 | 12644 | 237 | 5.426829 | 12.86158473 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 433 | 6.5e-117 | NTclustered | gi|2915030199|gb|OR222656.1| | 2832643 | g12562 | i0 | 99.578 | 1 | 237 | 1 | 100 | 0 | 1 | 237 | 97342 | 97578 | MAG: Caudoviricetes sp. isolate MSP0276 genomic sequence | blastn | 237 | 433 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 7351920 | 7351920 | PRJNA986547_P_NODE_16086_length_208_cov_5.881481_g16004_i0 | PRJNA986547 | 16086 | 208 | 5.881481 | 12.23348048 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 368 | 1.59e-97 | NTclustered | gi|2060009164|tpg|BK026788.1| | 2832643 | g16004 | i0 | 98.558 | 3.98076923076923 | 208 | 3 | 100 | 0 | 1 | 208 | 19502 | 19295 | MAG TPA_asm: Caudoviricetes sp. isolate ctvnV1, partial genome | blastn | 828 | 368 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 7351934 | 7351934 | PRJNA986547_P_NODE_1666_length_361_cov_1.524306_g1584_i0 | PRJNA986547 | 1666 | 361 | 1.524306 | 5.50274466 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 649 | 0 | NTclustered | gi|2054434277|tpg|BK035998.1| | 2832643 | g1584 | i0 | 99.167 | 399.986149584488 | 360 | 3 | 99 | 0 | 1 | 360 | 18336 | 17977 | MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome | blastn | 144395 | 649 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 9902240 | 9902240 | PRJNA986547_P_NODE_10428_length_245_cov_5.686047_g10346_i0 | PRJNA986547 | 10428 | 245 | 5.686047 | 13.93081515 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 436 | 5.229999999999999e-118 | NTclustered | gi|2914950888|gb|OR221904.1| | 2832643 | g10346 | i0 | 98.776 | 19.6 | 245 | 3 | 100 | 0 | 1 | 245 | 36455 | 36211 | MAG: Caudoviricetes sp. isolate MSP1100 genomic sequence | blastn | 4802 | 436 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11177465 | 11177465 | PRJNA986547_P_NODE_12669_length_237_cov_4.439024_g12587_i0 | PRJNA986547 | 12669 | 237 | 4.439024 | 10.52048688 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 433 | 6.5e-117 | NTclustered | gi|2059780396|tpg|BK039327.1| | 2832643 | g12587 | i0 | 99.578 | 11 | 237 | 1 | 100 | 0 | 1 | 237 | 11375 | 11611 | MAG TPA_asm: Caudoviricetes sp. isolate ctQqk5, partial genome | blastn | 2607 | 433 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 13727802 | 13727802 | PRJNA986547_P_NODE_4231_length_288_cov_1.432558_g4149_i0 | PRJNA986547 | 4231 | 288 | 1.432558 | 4.12576704 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 427 | 3.7899999999999997e-115 | NTclustered | gi|2059845245|tpg|BK040412.1| | 2832643 | g4149 | i0 | 93.426 | 5.00694444444444 | 289 | 17 | 100 | 2 | 1 | 288 | 13879 | 13592 | MAG TPA_asm: Caudoviricetes sp. isolate ctJnj1, partial genome | blastn | 1442 | 427 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 20100700 | 20100700 | PRJNA986547_P_NODE_3076_length_310_cov_2.877637_g2994_i0 | PRJNA986547 | 3076 | 310 | 2.877637 | 8.9206747 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 411 | 4.149999999999999e-110 | NTclustered | gi|2915051030|gb|OR222847.1| | 2832643 | g2994 | i0 | 90.879 | 10.1741935483871 | 307 | 20 | 99 | 1 | 4 | 310 | 60465 | 60167 | MAG: Caudoviricetes sp. isolate MSP0502 genomic sequence | blastn | 3154 | 411 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 20100747 | 20100747 | PRJNA986547_P_NODE_6376_length_266_cov_2.020725_g6294_i0 | PRJNA986547 | 6376 | 266 | 2.020725 | 5.3751285 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 84.2 | 8.63e-12 | NTclustered | gi|2054709308|tpg|BK053185.1| | 2832643 | g6294 | i0 | 87.013 | 0.289473684210526 | 77 | 6 | 28 | 3 | 117 | 191 | 418 | 344 | MAG TPA_asm: Caudoviricetes sp. isolate ctqrh14, partial genome | blastn | 77 | 84.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 20100764 | 20100764 | PRJNA986547_P_NODE_8176_length_253_cov_1.733333_g8094_i0 | PRJNA986547 | 8176 | 253 | 1.733333 | 4.38533249 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 468 | 1.92e-127 | NTclustered | gi|2914875393|gb|OR221562.1| | 2832643 | g8094 | i0 | 100 | 1 | 253 | 0 | 100 | 0 | 1 | 253 | 26548 | 26800 | MAG: Caudoviricetes sp. isolate MSP1502 genomic sequence | blastn | 253 | 468 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 22949996 | 22949996 | PRJNA986547_P_NODE_3818_length_293_cov_3.295455_g3736_i0 | PRJNA986547 | 3818 | 293 | 3.295455 | 9.65568315 | Obolenskvirus | 1915205 | Viruses | Viruses | 326 | 1.4499999999999999e-84 | NTclustered | gi|1503528882|gb|MH853786.1| | 2419626 | g3736 | i0 | 88.722 | 21.8088737201365 | 266 | 30 | 91 | 0 | 9 | 274 | 4480 | 4745 | Acinetobacter phage vB_AbaM_IME285, complete genome | blastn | 6390 | 326 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Obolenskvirus | Acinetobacter phage vB_AbaM_IME285 | ||||
| 22950004 | 22950004 | PRJNA986547_P_NODE_5358_length_275_cov_3.252475_g5276_i0 | PRJNA986547 | 5358 | 275 | 3.252475 | 8.94430625 | Viruses | 10239 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|2693694904|gb|PP395635.1| | 3126650 | g5276 | i0 | 90.909 | 0.269090909090909 | 44 | 0 | 15 | 2 | 229 | 270 | 26696 | 26655 | Microcystis phage Mae-JY02, complete genome | blastn | 74 | 56.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Microcystis phage Mae-JY02 | |||||
| 25498730 | 25498730 | PRJNA986547_P_NODE_15820_length_210_cov_9.277372_g15738_i0 | PRJNA986547 | 15820 | 210 | 9.277372 | 19.4824812 | Tequatrovirus | 10663 | Viruses | Viruses | 388 | 1.24e-103 | NTclustered | gi|2721715921|emb|OZ035787.1| | 10665 | g15738 | i0 | 100 | 99.9904761904762 | 210 | 0 | 100 | 0 | 1 | 210 | 38592 | 38383 | Tequatrovirus T4 genome assembly, chromosome: 1 | blastn | 20998 | 388 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pantevenvirales | Straboviridae | Tequatrovirus | Tequatrovirus T4 |
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);;