contig_metadata
3 rows where bioproject = "PRJNA971593", tax_phylum = "Uroviricota" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27658016 | 27658016 | PRJNA971593_P_NODE_24724_length_247_cov_1.770115_g24575_i0 | PRJNA971593 | 24724 | 247 | 1.770115 | 4.37218405 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 109 | 9.04e-28 | NR | CAB4197140.1 | 2100421 | g24575 | i0 | 54.1 | 0.898785425101215 | 74 | 34 | 89.9 | 0 | 230 | 9 | 74 | 147 | CAB4197140.1 phage_rel_nuc, putative phage-type endonuclease [uncultured Caudovirales phage] | diamond | 222 | 109 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 30847448 | 30847448 | PRJNA971593_P_NODE_23974_length_249_cov_0.875000_g23825_i0 | PRJNA971593 | 23974 | 249 | 0.875 | 2.17875 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 66.2 | 1.71e-10 | NR | QHJ79075.1 | 2832643 | g23825 | i0 | 42.1 | 3.32530120481928 | 76 | 41 | 88 | 1 | 22 | 240 | 2 | 77 | QHJ79075.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 828 | 66.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32555618 | 32555618 | PRJNA971593_P_NODE_28739_length_242_cov_0.863905_g28590_i0 | PRJNA971593 | 28739 | 242 | 0.863905 | 2.0906501 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 62.8 | 3.28e-9 | NR | CAB4196507.1 | 2100421 | g28590 | i0 | 42.1 | 0.942148760330578 | 76 | 44 | 94.2 | 0 | 13 | 240 | 223 | 298 | CAB4196507.1 hypothetical protein UFOVP1290_27 [uncultured Caudovirales phage] | diamond | 228 | 62.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch |
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);;