contig_metadata
7 rows where bioproject = "PRJNA885753" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27340066 | 27340066 | PRJNA885753_S_NODE_3543_length_255_cov_1.170330_g3525_i0 | PRJNA885753 | 3543 | 255 | 1.17033 | 2.9843415 | Synechococcus phage S-CREM1 | 2982919 | Viruses | Viruses | 90.9 | 1.77e-20 | NR | UYA57495.1 | 2982919 | g3525 | i0 | 58.7 | 0.882352941176471 | 75 | 31 | 88.2 | 0 | 18 | 242 | 1 | 75 | UYA57495.1 loader of DNA helicase [Synechococcus phage S-CREM1] | diamond | 225 | 90.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pantevenvirales | Kyanoviridae | Synechococcus phage S-CREM1 | |||
| 27908007 | 27908007 | PRJNA885753_S_NODE_2545_length_290_cov_1.078341_g2527_i0 | PRJNA885753 | 2545 | 290 | 1.078341 | 3.1271889 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 85.9 | 8.45e-20 | NR | CAB4184887.1 | 2100421 | g2527 | i0 | 72.6 | 1.24137931034483 | 62 | 17 | 64.1 | 0 | 280 | 95 | 1 | 62 | CAB4184887.1 hypothetical protein UFOVP1116_44 [uncultured Caudovirales phage] | diamond | 360 | 85.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 28223856 | 28223856 | PRJNA885753_S_NODE_1146_length_399_cov_1.128834_g1128_i0 | PRJNA885753 | 1146 | 399 | 1.128834 | 4.50404766 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 152 | 2.1e-40 | NR | CAB4148890.1 | 2100421 | g1128 | i0 | 61.9 | 4.09774436090226 | 139 | 46 | 99.2 | 2 | 397 | 2 | 4 | 142 | CAB4148890.1 COG4695 Phage-related protein [uncultured Caudovirales phage] | diamond | 1635 | 152 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 28476652 | 28476652 | PRJNA885753_S_NODE_3966_length_249_cov_0.886364_g3948_i0 | PRJNA885753 | 3966 | 249 | 0.886364 | 2.20704636 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 119 | 1.76e-29 | NR | CAB4184372.1 | 2100421 | g3948 | i0 | 75.3 | 0.975903614457831 | 81 | 20 | 97.6 | 0 | 3 | 245 | 291 | 371 | CAB4184372.1 COG4653 Predicted phage phi-C31 gp36 major capsid-like protein [uncultured Caudovirales phage] | diamond | 243 | 119 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 28926509 | 28926509 | PRJNA885753_S_NODE_4608_length_242_cov_0.911243_g4590_i0 | PRJNA885753 | 4608 | 242 | 0.911243 | 2.20520806 | root | 1 | Root_unresolved | Root_unresolved | 95.1 | 4.85e-22 | NR | WDS61225.1 | 753087 | g4590 | i0 | 55.7 | 9.76859504132231 | 79 | 35 | 97.9 | 0 | 238 | 2 | 1 | 79 | WDS61225.1 sliding clamp DNA polymerase accessory protein [Synechococcus phage S-BM3] | diamond | 2364 | 95.9 | 0.991657977059437 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pantevenvirales | Kyanoviridae | Synechococcus phage S-BM3 | |||
| 30118526 | 30118526 | PRJNA885753_S_NODE_3092_length_268_cov_1.200000_g3074_i0 | PRJNA885753 | 3092 | 268 | 1.2 | 3.216 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 77 | 1.65e-14 | NR | CAB4148604.1 | 2100421 | g3074 | i0 | 44.2 | 0.962686567164179 | 86 | 48 | 96.3 | 0 | 258 | 1 | 145 | 230 | CAB4148604.1 hypothetical protein UFOVP524_20 [uncultured Caudovirales phage] | diamond | 258 | 77 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 32276552 | 32276552 | PRJNA885753_S_NODE_3538_length_255_cov_1.241758_g3520_i0 | PRJNA885753 | 3538 | 255 | 1.241758 | 3.1664829 | root | 1 | Root_unresolved | Root_unresolved | 88.2 | 4.29e-18 | NR | BAR24318.1 | 1407671 | g3520 | i0 | 67.2 | 2.31764705882353 | 64 | 21 | 75.3 | 0 | 253 | 62 | 537 | 600 | BAR24318.1 terminase large subunit [uncultured Mediterranean phage uvMED] | diamond | 591 | 88.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | uncultured Mediterranean phage uvMED |
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);;