contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA835051" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27559985 | 27559985 | PRJNA835051_S_NODE_37424_length_236_cov_1.233161_g37128_i0 | PRJNA835051 | 37424 | 236 | 1.233161 | 2.91025996 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 78.2 | 1.98e-16 | NR | XOS05622.1 | 2832643 | g37128 | i0 | 54.2 | 1.89406779661017 | 72 | 30 | 87.7 | 1 | 28 | 234 | 2 | 73 | XOS05622.1 MAG: gp71 protein [Caudoviricetes sp.] | diamond | 447 | 78.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28223039 | 28223039 | PRJNA835051_S_NODE_5146_length_386_cov_3.338192_g4851_i0 | PRJNA835051 | 5146 | 386 | 3.338192 | 12.88542112 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 72 | 2.9e-12 | NR | XOR80200.1 | 2832643 | g4851 | i0 | 40.8 | 0.800518134715026 | 103 | 59 | 78.5 | 2 | 4 | 306 | 132 | 234 | XOR80200.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 309 | 72 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29044306 | 29044306 | PRJNA835051_S_NODE_81528_length_183_cov_2.357143_g81232_i0 | PRJNA835051 | 81528 | 183 | 2.357143 | 4.31357169 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 47.8 | 1.43e-5 | NR | DAM60462.1 | 2832643 | g81232 | i0 | 65.6 | 0.524590163934426 | 32 | 11 | 52.5 | 0 | 110 | 15 | 1 | 32 | DAM60462.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] | diamond | 96 | 47.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29643672 | 29643672 | PRJNA835051_S_NODE_52770_length_213_cov_1.717647_g52474_i0 | PRJNA835051 | 52770 | 213 | 1.717647 | 3.65858811 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 60.5 | 1.42e-8 | NR | DAZ11227.1 | 2832643 | g52474 | i0 | 51.1 | 0.661971830985915 | 47 | 23 | 66.2 | 0 | 34 | 174 | 248 | 294 | DAZ11227.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] | diamond | 141 | 60.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30907886 | 30907886 | PRJNA835051_S_NODE_24094_length_264_cov_2.257919_g23798_i0 | PRJNA835051 | 24094 | 264 | 2.257919 | 5.96090616 | Gordonia phage Ghobes | 1887647 | Viruses | Viruses | 43.1 | 0.019 | NR | YP_009281156.1 | 1887647 | g23798 | i0 | 39 | 0.670454545454545 | 59 | 36 | 67 | 0 | 84 | 260 | 10 | 68 | YP_009281156.1 deoxyuridine triphosphatase [Gordonia phage Ghobes] | diamond | 177 | 43.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Ghobesvirus | Ghobesvirus ghobes | ||||
| 31318516 | 31318516 | PRJNA835051_S_NODE_70795_length_193_cov_1.586667_g70499_i0 | PRJNA835051 | 70795 | 193 | 1.586667 | 3.06226731 | Podoviridae sp. ctLUJ1 | 2656710 | Viruses | Viruses | 43.1 | 0.00505 | NR | QGH72803.1 | 2656710 | g70499 | i0 | 44.4 | 0.839378238341969 | 54 | 27 | 83.9 | 2 | 27 | 188 | 1 | 51 | QGH72803.1 MAG: protein of unknown function DUF4326 [Podoviridae sp. ctLUJ1] | diamond | 162 | 43.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Schitoviridae | Podoviridae sp. ctLUJ1 | ||||
| 32339617 | 32339617 | PRJNA835051_S_NODE_88459_length_178_cov_1.059259_g88163_i0 | PRJNA835051 | 88459 | 178 | 1.059259 | 1.88548102 | Viruses | 10239 | Viruses | Viruses | 59.3 | 7.1e-9 | NR | WPJ72093.1 | 3079598 | g88163 | i0 | 47.4 | 1.93820224719101 | 57 | 30 | 96.1 | 0 | 173 | 3 | 53 | 109 | WPJ72093.1 hypothetical protein DEEACLCL_00076 [Salmonella phage CRW-SP2] | diamond | 345 | 59.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pantevenvirales | Ackermannviridae | Salmonella phage CRW-SP2 |
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);;