contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA799842" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27085741 | 27085741 | PRJNA799842_P_NODE_86102_length_312_cov_0.966527_g84529_i0 | PRJNA799842 | 86102 | 312 | 0.966527 | 3.01556424 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 58.9 | 2e-8 | NR | DAK88720.1 | 2832643 | g84529 | i0 | 44.6 | 0.971153846153846 | 101 | 44 | 93.3 | 5 | 302 | 12 | 40 | 132 | DAK88720.1 MAG TPA: regulatory protein [Caudoviricetes sp.] | diamond | 303 | 58.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27275349 | 27275349 | PRJNA799842_P_NODE_184723_length_242_cov_0.911243_g183150_i0 | PRJNA799842 | 184723 | 242 | 0.911243 | 2.20520806 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 56.2 | 1.91e-8 | NR | DAG63403.1 | 2832643 | g183150 | i0 | 71.8 | 0.483471074380165 | 39 | 11 | 48.3 | 0 | 120 | 236 | 19 | 57 | DAG63403.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] | diamond | 117 | 56.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28317376 | 28317376 | PRJNA799842_P_NODE_67106_length_348_cov_1.920000_g65533_i0 | PRJNA799842 | 67106 | 348 | 1.92 | 6.6816 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 56.6 | 7.32e-8 | NR | XOR49598.1 | 2832643 | g65533 | i0 | 36.7 | 0.681034482758621 | 79 | 48 | 67.2 | 2 | 68 | 301 | 3 | 80 | XOR49598.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 237 | 56.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28380431 | 28380431 | PRJNA799842_P_NODE_130826_length_255_cov_1.269231_g129253_i0 | PRJNA799842 | 130826 | 255 | 1.269231 | 3.23653905 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 66.2 | 2.86e-12 | NR | DAK88710.1 | 2832643 | g129253 | i0 | 91.9 | 0.435294117647059 | 37 | 3 | 43.5 | 0 | 254 | 144 | 30 | 66 | DAK88710.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] | diamond | 111 | 66.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28443791 | 28443791 | PRJNA799842_P_NODE_154066_length_248_cov_0.880000_g152493_i0 | PRJNA799842 | 154066 | 248 | 0.88 | 2.1824 | Arthrobacter phage KellEzio | 1796995 | Viruses | Viruses | 66.2 | 2.51e-11 | NR | YP_009301284.1 | 1796995 | g152493 | i0 | 40.5 | 0.955645161290323 | 79 | 46 | 95.6 | 1 | 11 | 247 | 15 | 92 | YP_009301284.1 tail terminator [Arthrobacter phage KellEzio] | diamond | 237 | 66.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Kelleziovirus | Kelleziovirus kellezzio | ||||
| 30022581 | 30022581 | PRJNA799842_P_NODE_135611_length_251_cov_0.865169_g134038_i0 | PRJNA799842 | 135611 | 251 | 0.865169 | 2.17157419 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 133 | 5.02e-34 | NR | DAH90269.1 | 2832643 | g134038 | i0 | 75 | 6.74103585657371 | 80 | 20 | 95.6 | 0 | 2 | 241 | 464 | 543 | DAH90269.1 MAG TPA: tail protein [Caudoviricetes sp.] | diamond | 1692 | 133 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30402041 | 30402041 | PRJNA799842_P_NODE_154053_length_248_cov_0.880000_g152480_i0 | PRJNA799842 | 154053 | 248 | 0.88 | 2.1824 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 93.6 | 1.06e-20 | NR | CAB4194459.1 | 2100421 | g152480 | i0 | 52.9 | 3.97983870967742 | 85 | 35 | 96.8 | 2 | 1 | 240 | 217 | 301 | CAB4194459.1 DNA ligase [uncultured Caudovirales phage] | diamond | 987 | 93.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 31349715 | 31349715 | PRJNA799842_P_NODE_161696_length_246_cov_0.890173_g160123_i0 | PRJNA799842 | 161696 | 246 | 0.890173 | 2.18982558 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 55.5 | 5.96e-8 | NR | XOS54324.1 | 2832643 | g160123 | i0 | 77.1 | 0.426829268292683 | 35 | 8 | 42.7 | 0 | 121 | 17 | 43 | 77 | XOS54324.1 MAG: hypothetical protein MSP0313_52 [Caudoviricetes sp.] | diamond | 105 | 55.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31634175 | 31634175 | PRJNA799842_P_NODE_37336_length_469_cov_1.361111_g35765_i0 | PRJNA799842 | 37336 | 469 | 1.361111 | 6.38361059 | Vibrio phage vB_VhaM_VH-8 | 2660693 | Viruses | Viruses | 172 | 2.55e-49 | NR | QGH73838.1 | 2660693 | g35765 | i0 | 58.4 | 0.876332622601279 | 137 | 57 | 87.6 | 0 | 411 | 1 | 187 | 323 | QGH73838.1 tail fiber protein [Vibrio phage vB_VhaM_VH-8] | diamond | 411 | 172 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Vibrio phage vB_VhaM_VH-8 | |||||
| 31855608 | 31855608 | PRJNA799842_P_NODE_153437_length_248_cov_0.880000_g151864_i0 | PRJNA799842 | 153437 | 248 | 0.88 | 2.1824 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 78.6 | 3.15e-15 | NR | DAZ59539.1 | 2832643 | g151864 | i0 | 68.1 | 1.13709677419355 | 47 | 15 | 56.9 | 0 | 245 | 105 | 232 | 278 | DAZ59539.1 MAG TPA: tail protein [Caudoviricetes sp.] | diamond | 282 | 78.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32203735 | 32203735 | PRJNA799842_P_NODE_139098_length_251_cov_0.842697_g137525_i0 | PRJNA799842 | 139098 | 251 | 0.842697 | 2.11516947 | Pseudomonas phage 2 | 3060698 | Viruses | Viruses | 43.5 | 0.0221 | NR | YP_001956731.1 | 198110 | g137525 | i0 | 32 | 1.19521912350598 | 50 | 33 | 58.6 | 1 | 27 | 173 | 112 | 161 | YP_001956731.1 terminase large subunit [Pseudomonas phage 201phi2-1] | diamond | 300 | 43.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Chimalliviridae | Serwervirus | Serwervirus 201phi21 | |||
| 32583499 | 32583499 | PRJNA799842_P_NODE_152419_length_248_cov_0.880000_g150846_i0 | PRJNA799842 | 152419 | 248 | 0.88 | 2.1824 | Staphylococcus phage 6ec | 1500386 | Viruses | Viruses | 87 | 2.65e-20 | NR | YP_009042645.1 | 1500386 | g150846 | i0 | 71.2 | 0.713709677419355 | 59 | 17 | 71.4 | 0 | 178 | 2 | 1 | 59 | YP_009042645.1 hypothetical protein PHAGE6E_140 [Staphylococcus phage 6ec] | diamond | 177 | 87 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Sextaecvirus | Sextaecvirus sextaec |
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);;