contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA1122875" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11755888 | 11755888 | PRJNA1122875_P_NODE_10150_length_520_cov_1.035794_g9931_i0 | PRJNA1122875 | 10150 | 520 | 1.035794 | 5.3861288 | Methylophilales phage MEP4 | 3003801 | Viruses | Viruses | 57.8 | 1.16e-6 | NR | WBF78151.1 | 3003801 | g9931 | i0 | 38.4 | 0.496153846153846 | 86 | 49 | 47.3 | 2 | 8 | 253 | 118 | 203 | WBF78151.1 hypothetical protein MEP402_gp31 [Methylophilales phage MEP402] | diamond | 258 | 57.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Zobellviridae | Methylophilales phage MEP402 | ||||
| 27386431 | 27386431 | PRJNA1122875_P_NODE_44143_length_250_cov_0.870056_g43919_i0 | PRJNA1122875 | 44143 | 250 | 0.870056 | 2.17514 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 95.5 | 1.14e-20 | NR | DAH28747.1 | 2832643 | g43919 | i0 | 57.3 | 0.984 | 82 | 35 | 98.4 | 0 | 4 | 249 | 590 | 671 | DAH28747.1 MAG TPA: tail protein [Caudoviricetes sp.] | diamond | 246 | 95.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27512559 | 27512559 | PRJNA1122875_P_NODE_18723_length_386_cov_0.984026_g18499_i0 | PRJNA1122875 | 18723 | 386 | 0.984026 | 3.79834036 | Caudovirales sp. ctOwN3 | 2656725 | Viruses | Viruses | 45.4 | 0.019 | NR | QGH72153.1 | 2656725 | g18499 | i0 | 36.5 | 0.83160621761658 | 63 | 37 | 46.6 | 1 | 345 | 166 | 174 | 236 | QGH72153.1 MAG: primase [Caudovirales sp. ctOwN3] | diamond | 321 | 45.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudovirales sp. ctOwN3 | |||||
| 29248980 | 29248980 | PRJNA1122875_P_NODE_47049_length_247_cov_1.758621_g46825_i0 | PRJNA1122875 | 47049 | 247 | 1.758621 | 4.34379387 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 40 | 0.0271 | NR | DAR99514.1 | 2832643 | g46825 | i0 | 78.9 | 0.230769230769231 | 19 | 4 | 23.1 | 0 | 62 | 6 | 15 | 33 | DAR99514.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] | diamond | 57 | 40 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29269708 | 29269708 | PRJNA1122875_P_NODE_18389_length_389_cov_1.348101_g18165_i0 | PRJNA1122875 | 18389 | 389 | 1.348101 | 5.24411289 | Viruses | 10239 | Viruses | Viruses | 43.5 | 0.00982 | NR | BAQ85168.1 | 1407671 | g18165 | i0 | 49 | 1.12596401028278 | 49 | 23 | 37.8 | 1 | 234 | 88 | 26 | 72 | BAQ85168.1 phage terminase small subunit [uncultured Mediterranean phage uvMED] | diamond | 438 | 43.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | uncultured Mediterranean phage uvMED | |||||
| 30291692 | 30291692 | PRJNA1122875_P_NODE_11472_length_491_cov_2.511962_g11250_i0 | PRJNA1122875 | 11472 | 491 | 2.511962 | 12.33373342 | Methylophilales phage MEP4 | 3003801 | Viruses | Viruses | 72 | 4.51e-12 | NR | WBF78151.1 | 3003801 | g11250 | i0 | 36.8 | 1.40529531568228 | 133 | 69 | 72.1 | 5 | 1 | 354 | 71 | 203 | WBF78151.1 hypothetical protein MEP402_gp31 [Methylophilales phage MEP402] | diamond | 690 | 72 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Zobellviridae | Methylophilales phage MEP402 | ||||
| 30480983 | 30480983 | PRJNA1122875_P_NODE_51273_length_243_cov_1.358824_g51049_i0 | PRJNA1122875 | 51273 | 243 | 1.358824 | 3.30194232 | uncultured Caudovirales phage | 2100421 | Viruses | Viruses | 65.9 | 1.68e-10 | NR | CAB4196822.1 | 2100421 | g51049 | i0 | 43.8 | 3.93827160493827 | 80 | 39 | 96.3 | 3 | 7 | 240 | 175 | 250 | CAB4196822.1 TIGR02452, TIGR02452 family protein [uncultured Caudovirales phage] | diamond | 957 | 65.9 | 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);;