contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA724011" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27368547 | 27368547 | PRJNA724011_P_NODE_28543_length_521_cov_5.700893_g27526_i0 | PRJNA724011 | 28543 | 521 | 5.700893 | 29.70165253 | uncultured phage_MedDCM-OCT-S35-C6 | 2741075 | Viruses | Viruses | 104 | 3.25e-25 | NR | YP_010761261.1 | 2741075 | g27526 | i0 | 39.7 | 0.81190019193858 | 141 | 74 | 79.5 | 2 | 23 | 436 | 7 | 139 | YP_010761261.1 baseplate hub subunit and tail lysozyme [uncultured phage_MedDCM-OCT-S35-C6] | diamond | 423 | 104 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Autographivirales | Pelagivirus | Pelagivirus S35C6 | |||
| 27620990 | 27620990 | PRJNA724011_P_NODE_74504_length_289_cov_2.282407_g73481_i0 | PRJNA724011 | 74504 | 289 | 2.282407 | 6.59615623 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 44.3 | 0.0162 | NR | DAO28100.1 | 2832643 | g73481 | i0 | 29.3 | 0.778546712802768 | 75 | 51 | 76.8 | 2 | 253 | 32 | 20 | 93 | DAO28100.1 MAG TPA: phosphoadenosine-phosphosulfate reductase [Caudoviricetes sp.] | diamond | 225 | 44.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27936664 | 27936664 | PRJNA724011_P_NODE_31705_length_488_cov_1.626506_g30686_i0 | PRJNA724011 | 31705 | 488 | 1.626506 | 7.93734928 | Synechococcus phage S-SM2 | 444860 | Viruses | Viruses | 47.4 | 0.00865 | NR | YP_004322274.1 | 444860 | g30686 | i0 | 27.1 | 2.34836065573771 | 129 | 84 | 73.2 | 4 | 13 | 369 | 134 | 262 | YP_004322274.1 head scaffolding protein [Synechococcus phage S-SM2] | diamond | 1146 | 47.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pantevenvirales | Kyanoviridae | Nilusvirus | Nilusvirus ssm2 | ||
| 29231320 | 29231320 | PRJNA724011_P_NODE_76629_length_285_cov_1.089623_g75606_i0 | PRJNA724011 | 76629 | 285 | 1.089623 | 3.10542555 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 41.2 | 0.0189 | NR | DAU75828.1 | 2832643 | g75606 | i0 | 58.6 | 0.305263157894737 | 29 | 12 | 30.5 | 0 | 169 | 83 | 1 | 29 | DAU75828.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] | diamond | 87 | 41.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29704354 | 29704354 | PRJNA724011_P_NODE_83750_length_270_cov_1.065990_g82727_i0 | PRJNA724011 | 83750 | 270 | 1.06599 | 2.878173 | Human alphaherpesvirus 2 | 10310 | Viruses | Viruses | 43.1 | 0.0349 | NR | QBH85097.1 | 10310 | g82727 | i0 | 48.5 | 3.77777777777778 | 68 | 24 | 75.6 | 3 | 244 | 41 | 126 | 182 | QBH85097.1 hypothetical protein [Human alphaherpesvirus 2] | diamond | 1020 | 43.1 | 1 | Viruses | Heunggongvirae | Peploviricota | Herviviricetes | Herpesvirales | Orthoherpesviridae | Simplexvirus | Simplexvirus humanalpha2 | ||
| 31379380 | 31379380 | PRJNA724011_P_NODE_104036_length_244_cov_1.801170_g103013_i0 | PRJNA724011 | 104036 | 244 | 1.80117 | 4.3948548 | Aeromonas phage ST4 | 3065692 | Viruses | Viruses | 116 | 2.66e-28 | NR | WNL63637.1 | 3065692 | g103013 | i0 | 75 | 0.934426229508197 | 76 | 19 | 93.4 | 0 | 242 | 15 | 29 | 104 | WNL63637.1 tail sheath protein [Aeromonas phage ST4] | diamond | 228 | 116 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Aeromonas phage ST4 | |||||
| 31980279 | 31980279 | PRJNA724011_P_NODE_57278_length_338_cov_1.815094_g56255_i0 | PRJNA724011 | 57278 | 338 | 1.815094 | 6.13501772 | Vibrio phage 252E42.2 | 2859319 | Viruses | Viruses | 91.3 | 4.56e-19 | NR | QZI91326.1 | 2859319 | g56255 | i0 | 42 | 0.887573964497041 | 100 | 58 | 88.8 | 0 | 37 | 336 | 2 | 101 | QZI91326.1 putative recombination-associated protein [Vibrio phage 252E42.2] | diamond | 300 | 91.3 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Vibrio phage 252E42.2 |
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);;