contig_metadata
14 rows where bioproject = "PRJNA728642" and tax_phylum = "Uroviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 712972 | 712972 | PRJNA728642_P_NODE_7701_length_369_cov_1.040541_g7430_i0 | PRJNA728642 | 7701 | 369 | 1.040541 | 3.83959629 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 660 | 0 | NTclustered | gi|2914793330|gb|OR222845.1| | 2832643 | g7430 | i0 | 98.916 | 15.9376693766938 | 369 | 4 | 100 | 0 | 1 | 369 | 21010 | 21378 | MAG: Caudoviricetes sp. isolate MSP0506 genomic sequence | blastn | 5881 | 660 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 3264066 | 3264066 | PRJNA728642_P_NODE_14083_length_268_cov_1.364103_g13812_i0 | PRJNA728642 | 14083 | 268 | 1.364103 | 3.65579604 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 435 | 2.09e-117 | NTclustered | gi|2914793330|gb|OR222845.1| | 2832643 | g13812 | i0 | 95.896 | 2.53358208955224 | 268 | 11 | 100 | 0 | 1 | 268 | 19622 | 19355 | MAG: Caudoviricetes sp. isolate MSP0506 genomic sequence | blastn | 679 | 435 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 4541145 | 4541145 | PRJNA728642_P_NODE_13784_length_271_cov_1.505051_g13513_i0 | PRJNA728642 | 13784 | 271 | 1.505051 | 4.07868821 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 484 | 2.07e-132 | NTclustered | gi|2054490021|tpg|BK032134.1| | 2832643 | g13513 | i0 | 98.893 | 10.5092250922509 | 271 | 3 | 100 | 0 | 1 | 271 | 463 | 193 | MAG TPA_asm: Caudoviricetes sp. isolate ctHoU9, partial genome | blastn | 2848 | 484 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 8366038 | 8366038 | PRJNA728642_P_NODE_14287_length_266_cov_1.373057_g14016_i0 | PRJNA728642 | 14287 | 266 | 1.373057 | 3.65233162 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 457 | 4.41e-124 | NTclustered | gi|2054434277|tpg|BK035998.1| | 2832643 | g14016 | i0 | 97.736 | 260.492481203008 | 265 | 6 | 99 | 0 | 2 | 266 | 17751 | 18015 | MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome | blastn | 69291 | 457 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 12192364 | 12192364 | PRJNA728642_P_NODE_9350_length_333_cov_1.184615_g9079_i0 | PRJNA728642 | 9350 | 333 | 1.184615 | 3.94476795 | Maltschvirus maltsch | 2956182 | Viruses | Viruses | 610 | 4.13e-170 | NTclustered | gi|1219999807|gb|MF417878.1| | 2100421 | g9079 | i0 | 99.7 | 22.7867867867868 | 333 | 1 | 100 | 0 | 1 | 333 | 23562 | 23230 | Uncultured Caudovirales phage clone 8S_7, partial genome | blastn | 7588 | 610 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 13466613 | 13466613 | PRJNA728642_P_NODE_20071_length_227_cov_2.805195_g19800_i0 | PRJNA728642 | 20071 | 227 | 2.805195 | 6.36779265 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 326 | 1.08e-84 | NTclustered | gi|2915042807|gb|OR222762.1| | 2832643 | g19800 | i0 | 92.511 | 4 | 227 | 17 | 100 | 0 | 1 | 227 | 34880 | 35106 | MAG: Caudoviricetes sp. isolate MSP0596 genomic sequence | blastn | 908 | 326 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14742025 | 14742025 | PRJNA728642_P_NODE_6672_length_397_cov_0.827160_g6401_i0 | PRJNA728642 | 6672 | 397 | 0.82716 | 3.2838252 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 678 | 0 | NTclustered | gi|2914791159|gb|OR222754.1| | 2832643 | g6401 | i0 | 97.481 | 5.87153652392947 | 397 | 10 | 100 | 0 | 1 | 397 | 52122 | 52518 | MAG: Caudoviricetes sp. isolate MSP0603 genomic sequence | blastn | 2331 | 678 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 15223445 | 15223445 | PRJNA728642_P_NODE_13772_length_271_cov_1.555556_g13501_i0 | PRJNA728642 | 13772 | 271 | 1.555556 | 4.21555676 | Readingvirus | 3152626 | Viruses | Viruses | 291 | 4.84e-74 | NTclustered | gi|2497518697|ref|NC_074661.1| | 2875722 | g13501 | i0 | 86.397 | 9.23616236162362 | 272 | 29 | 99 | 7 | 1 | 268 | 30934 | 31201 | Pseudomonas phage psageK9, complete genome | blastn | 2503 | 291 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Readingvirus | Readingvirus psageK9 | ||||
| 17290949 | 17290949 | PRJNA728642_P_NODE_3734_length_539_cov_1.321888_g3465_i0 | PRJNA728642 | 3734 | 539 | 1.321888 | 7.12497632 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 941 | 0 | NTclustered | gi|2915014604|gb|OR222508.1| | 2832643 | g3465 | i0 | 98.145 | 12.4582560296846 | 539 | 10 | 100 | 0 | 1 | 539 | 53074 | 53612 | MAG: Caudoviricetes sp. isolate MSP0878 genomic sequence | blastn | 6715 | 941 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17291009 | 17291009 | PRJNA728642_P_NODE_6774_length_393_cov_2.671875_g6503_i0 | PRJNA728642 | 6774 | 393 | 2.671875 | 10.50046875 | Purivirus UFJFPfDIW6 | 3060664 | Viruses | Viruses | 359 | 1.9799999999999998e-94 | NTclustered | gi|2214231935|gb|OM418631.1| | 2927622 | g6503 | i0 | 83.99 | 42.2188295165394 | 406 | 32 | 100 | 18 | 1 | 393 | 33115 | 33500 | Pseudomonas phage UFJF_PfDIW6, complete genome | blastn | 16592 | 359 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Purivirus | Purivirus UFJFPfDIW6 | ||||
| 23665976 | 23665976 | PRJNA728642_P_NODE_6059_length_417_cov_1.764535_g5788_i0 | PRJNA728642 | 6059 | 417 | 1.764535 | 7.35811095 | Purivirus UFJFPfDIW6 | 3060664 | Viruses | Viruses | 566 | 1.16e-156 | NTclustered | gi|2214231935|gb|OM418631.1| | 2927622 | g5788 | i0 | 91.169 | 32.0239808153477 | 419 | 34 | 100 | 3 | 1 | 417 | 27192 | 27609 | Pseudomonas phage UFJF_PfDIW6, complete genome | blastn | 13354 | 566 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Purivirus | Purivirus UFJFPfDIW6 | ||||
| 23666009 | 23666009 | PRJNA728642_P_NODE_7999_length_361_cov_1.069444_g7728_i0 | PRJNA728642 | 7999 | 361 | 1.069444 | 3.86069284 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 628 | 1.2399999999999997e-175 | NTclustered | gi|2915014604|gb|OR222508.1| | 2832643 | g7728 | i0 | 98.061 | 4.99722991689751 | 361 | 7 | 100 | 0 | 1 | 361 | 53064 | 52704 | MAG: Caudoviricetes sp. isolate MSP0878 genomic sequence | blastn | 1804 | 628 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 26830882 | 26830882 | PRJNA728642_P_NODE_14681_length_262_cov_1.222222_g14410_i0 | PRJNA728642 | 14681 | 262 | 1.222222 | 3.20222164 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 88.2 | 2.67e-18 | NR | XOR16625.1 | 2832643 | g14410 | i0 | 51.9 | 1.80916030534351 | 79 | 38 | 90.5 | 0 | 241 | 5 | 61 | 139 | XOR16625.1 MAG: RNaseH ribonuclease [Caudoviricetes sp.] | diamond | 474 | 88.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30031088 | 30031088 | PRJNA728642_P_NODE_16351_length_250_cov_0.870056_g16080_i0 | PRJNA728642 | 16351 | 250 | 0.870056 | 2.17514 | Viruses | 10239 | Viruses | Viruses | 131 | 8.02e-36 | NR | AWD93218.1 | 2163899 | g16080 | i0 | 73.5 | 1.98 | 83 | 22 | 99.6 | 0 | 1 | 249 | 93 | 175 | AWD93218.1 PhoH-like protein [Acinetobacter phage vB_AbaM_B9] | diamond | 495 | 131 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Acinetobacter phage vB_AbaM_B9 |
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);;