contig_metadata
9 rows where bioproject = "PRJNA560932" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4372274 | 4372274 | PRJNA560932_P_NODE_57804_length_247_cov_0.885057_g57448_i0 | PRJNA560932 | 57804 | 247 | 0.885057 | 2.18609079 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 451 | 1.88e-122 | NTclustered | gi|2914928861|gb|OR221539.1| | 2832643 | g57448 | i0 | 99.595 | 99.7125506072875 | 247 | 1 | 100 | 0 | 1 | 247 | 14024 | 13778 | MAG: Caudoviricetes sp. isolate MSP1537 genomic sequence | blastn | 24629 | 451 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 6922692 | 6922692 | PRJNA560932_P_NODE_41606_length_283_cov_1.195238_g41250_i0 | PRJNA560932 | 41606 | 283 | 1.195238 | 3.38252354 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 95.3 | 4.28e-15 | NTclustered | gi|2914981896|gb|OR222105.1| | 2832643 | g41250 | i0 | 98.148 | 25.7526501766784 | 54 | 1 | 19 | 0 | 225 | 278 | 4 | 57 | MAG: Caudoviricetes sp. isolate MSP0005 genomic sequence | blastn | 7288 | 95.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 20257102 | 20257102 | PRJNA560932_P_NODE_5436_length_735_cov_1.993958_g5105_i0 | PRJNA560932 | 5436 | 735 | 1.993958 | 14.6555913 | Tequatrovirus | 10663 | Viruses | Viruses | 1079 | 0 | NTclustered | gi|2721715921|emb|OZ035787.1| | 10665 | g5105 | i0 | 100 | 79.4557823129252 | 584 | 0 | 79 | 0 | 152 | 735 | 38777 | 38194 | Tequatrovirus T4 genome assembly, chromosome: 1 | blastn | 58400 | 1079 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pantevenvirales | Straboviridae | Tequatrovirus | Tequatrovirus T4 | ||
| 28089689 | 28089689 | PRJNA560932_P_NODE_66665_length_241_cov_0.916667_g66309_i0 | PRJNA560932 | 66665 | 241 | 0.916667 | 2.20916747 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 42.7 | 0.0375 | NR | CAB4156844.1 | 2100421 | g66309 | i0 | 33.8 | 0.995850622406639 | 80 | 41 | 89.6 | 2 | 216 | 1 | 104 | 179 | CAB4156844.1 hypothetical protein UFOVP658_186 [uncultured Caudovirales phage] | diamond | 240 | 42.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 29921217 | 29921217 | PRJNA560932_P_NODE_17851_length_416_cov_1.556851_g17495_i0 | PRJNA560932 | 17851 | 416 | 1.556851 | 6.47650016 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 82 | 4.45e-15 | NR | CAB4129535.1 | 2100421 | g17495 | i0 | 39.7 | 0.836538461538462 | 116 | 68 | 82.2 | 2 | 344 | 3 | 5 | 120 | CAB4129535.1 HtrL protein [uncultured Caudovirales phage] | diamond | 348 | 82 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 30205159 | 30205159 | PRJNA560932_P_NODE_57272_length_248_cov_0.880000_g56916_i0 | PRJNA560932 | 57272 | 248 | 0.88 | 2.1824 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 42.7 | 0.0314 | NR | DAU73941.1 | 2832643 | g56916 | i0 | 39.7 | 0.82258064516129 | 68 | 35 | 82.3 | 1 | 15 | 218 | 113 | 174 | DAU73941.1 MAG TPA: Dec protein, OB-Fold, Decoration, VIRAL PROTEIN [Caudoviricetes sp.] | diamond | 204 | 42.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30774242 | 30774242 | PRJNA560932_P_NODE_12494_length_494_cov_1.600950_g12140_i0 | PRJNA560932 | 12494 | 494 | 1.60095 | 7.908693 | Phage DSL-LC | 3058958 | Viruses | Viruses | 48.9 | 8.34e-4 | NR | WJZ48090.1 | 3058958 | g12140 | i0 | 32.1 | 0.473684210526316 | 78 | 49 | 47.4 | 1 | 421 | 188 | 7 | 80 | WJZ48090.1 hypothetical protein [Phage DSL-LC04] | diamond | 234 | 48.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Phage DSL-LC04 | |||||
| 30963836 | 30963836 | PRJNA560932_P_NODE_33154_length_315_cov_1.252066_g32798_i0 | PRJNA560932 | 33154 | 315 | 1.252066 | 3.9440079 | Ruegeria phage RpAliso | 3073043 | Viruses | Viruses | 64.7 | 1.66e-9 | NR | WNL50698.1 | 3073043 | g32798 | i0 | 42.7 | 2.02857142857143 | 75 | 43 | 71.4 | 0 | 227 | 3 | 25 | 99 | WNL50698.1 rIIA lysis inhibitor [Ruegeria phage RpAliso] | diamond | 639 | 64.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Ruegeria phage RpAliso | |||||
| 32197165 | 32197165 | PRJNA560932_P_NODE_36098_length_302_cov_2.689956_g35742_i0 | PRJNA560932 | 36098 | 302 | 2.689956 | 8.12366712 | Xanthomonas phage Xp15 | 322855 | Viruses | Viruses | 54.3 | 2.62e-7 | NR | YP_239340.1 | 322855 | g35742 | i0 | 44.4 | 1.87748344370861 | 45 | 25 | 44.7 | 0 | 296 | 162 | 11 | 55 | YP_239340.1 hypothetical protein XPXV15_gp72 [Xanthomonas phage Xp15] | diamond | 567 | 54.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Alachuavirus | Alachuavirus Xp15 |
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);;