contig_metadata
6 rows where analysis = "diamond", bioproject = "PRJNA741997" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27084202 | 27084202 | PRJNA741997_P_NODE_42142_length_335_cov_0.874046_g41022_i0 | PRJNA741997 | 42142 | 335 | 0.874046 | 2.9280541 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 132 | 5.46e-33 | NR | CAB4154472.1 | 2100421 | g41022 | i0 | 77 | 0.77910447761194 | 87 | 20 | 77.9 | 0 | 73 | 333 | 2091 | 2177 | CAB4154472.1 LT_GEWL domain containing protein [uncultured Caudovirales phage] | diamond | 261 | 132 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 27463496 | 27463496 | PRJNA741997_P_NODE_42383_length_334_cov_1.057471_g41263_i0 | PRJNA741997 | 42383 | 334 | 1.057471 | 3.53195314 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 166 | 1.39e-47 | NR | CAB4154604.1 | 2100421 | g41263 | i0 | 65.7 | 1.87724550898204 | 108 | 37 | 97 | 0 | 3 | 326 | 208 | 315 | CAB4154604.1 hypothetical protein UFOVP653_14 [uncultured Caudovirales phage] | diamond | 627 | 166 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 27526498 | 27526498 | PRJNA741997_P_NODE_65383_length_265_cov_2.031250_g64263_i0 | PRJNA741997 | 65383 | 265 | 2.03125 | 5.3828125 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 171 | 2.13e-49 | NR | CAB4122848.1 | 2100421 | g64263 | i0 | 95.4 | 0.984905660377358 | 87 | 4 | 98.5 | 0 | 263 | 3 | 92 | 178 | CAB4122848.1 Terminase RNaseH-like domain containing protein [uncultured Caudovirales phage] | diamond | 261 | 171 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 30874019 | 30874019 | PRJNA741997_P_NODE_71794_length_251_cov_0.865169_g70674_i0 | PRJNA741997 | 71794 | 251 | 0.865169 | 2.17157419 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 137 | 3.84e-39 | NR | DAG79872.1 | 2832643 | g70674 | i0 | 79.5 | 0.99203187250996006 | 83 | 17 | 99.2 | 0 | 3 | 251 | 48 | 130 | DAG79872.1 MAG TPA: major tail protein [Caudoviricetes sp.] | diamond | 249 | 137 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31664274 | 31664274 | PRJNA741997_P_NODE_61237_length_275_cov_1.386139_g60117_i0 | PRJNA741997 | 61237 | 275 | 1.386139 | 3.81188225 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 43.9 | 0.0206 | NR | DAY59767.1 | 2832643 | g60117 | i0 | 39 | 0.643636363636364 | 59 | 33 | 64.4 | 1 | 25 | 201 | 147 | 202 | DAY59767.1 MAG TPA: portal protein [Caudoviricetes sp.] | diamond | 177 | 43.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32075623 | 32075623 | PRJNA741997_P_NODE_29758_length_402_cov_0.796353_g28638_i0 | PRJNA741997 | 29758 | 402 | 0.796353 | 3.20133906 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 116 | 1.97e-29 | NR | XOS28093.1 | 2832643 | g28638 | i0 | 47.7 | 0.813432835820896 | 109 | 57 | 81.3 | 0 | 400 | 74 | 107 | 215 | XOS28093.1 MAG: hypothetical protein MSP0001_901 [Caudoviricetes sp.] | diamond | 327 | 116 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. |
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);;