contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA289590" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26775486 | 26775486 | PRJNA289590_P_NODE_20301_length_197_cov_2.790541_g20077_i0 | PRJNA289590 | 20301 | 197 | 2.790541 | 5.49736577 | Viruses | 10239 | Viruses | Viruses | 47.8 | 2.3e-5 | NR | QLI49465.1 | 2743937 | g20077 | i0 | 56.5 | 1.34010152284264 | 46 | 20 | 70.1 | 0 | 1 | 138 | 13 | 58 | QLI49465.1 hypothetical protein vBPaeMUSP18_64 [Pseudomonas phage vB_PaeM_USP_18] | diamond | 264 | 47.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pseudomonas phage vB_PaeM_USP_18 | |||||
| 26852925 | 26852925 | PRJNA289590_P_NODE_6161_length_390_cov_1.454545_g5937_i0 | PRJNA289590 | 6161 | 390 | 1.454545 | 5.6727255 | Pseudoalteromonas phage pYD6-A | 754052 | Viruses | Viruses | 79.7 | 1.83e-14 | NR | YP_007674256.1 | 754052 | g5937 | i0 | 47.3 | 0.992307692307692 | 129 | 62 | 97.7 | 3 | 8 | 388 | 293 | 417 | YP_007674256.1 hypothetical protein PYDG_00047 [Pseudoalteromonas phage pYD6-A] | diamond | 387 | 79.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Schitoviridae | Matsuvirus | Matsuvirus pYD6A | |||
| 27453615 | 27453615 | PRJNA289590_P_NODE_29763_length_164_cov_0.904348_g29539_i0 | PRJNA289590 | 29763 | 164 | 0.904348 | 1.48313072 | Apocheima cinerarium nucleopolyhedrovirus | 307461 | Viruses | Viruses | 74.7 | 8.42e-16 | NR | YP_006607868.1 | 307461 | g29539 | i0 | 75.9 | 13.8292682926829 | 54 | 12 | 98.8 | 1 | 3 | 164 | 22 | 74 | YP_006607868.1 AciNPV99 [Apocheima cinerarium nucleopolyhedrovirus] | diamond | 2268 | 74.7 | 1 | Viruses | Naldaviricetes | Lefavirales | Baculoviridae | Alphabaculovirus | Apocheima cinerarium nucleopolyhedrovirus | ||||
| 28084784 | 28084784 | PRJNA289590_P_NODE_19125_length_204_cov_1.974194_g18901_i0 | PRJNA289590 | 19125 | 204 | 1.974194 | 4.02735576 | Vibrio phage D148 | 3104901 | Viruses | Viruses | 42.7 | 0.0184 | NR | CAM0089275.1 | 3104901 | g18901 | i0 | 45.8 | 0.867647058823529 | 59 | 28 | 83.8 | 2 | 11 | 181 | 87 | 143 | CAM0089275.1 Gp2.5-like ssDNA binding protein and ssDNA anneal ing protein [Vibrio phage D148] | diamond | 177 | 42.7 | 1 | Viruses | Vibrio phage D148 | ||||||||
| 28084797 | 28084797 | PRJNA289590_P_NODE_26085_length_169_cov_0.866667_g25861_i0 | PRJNA289590 | 26085 | 169 | 0.866667 | 1.46466723 | Vibrio phage D69 | 3105312 | Viruses | Viruses | 47 | 3.13e-4 | NR | CAL9985992.1 | 3105312 | g25861 | i0 | 50 | 1.02958579881657 | 58 | 26 | 97.6 | 1 | 1 | 165 | 59 | 116 | CAL9985992.1 hypothetical protein VPHD69_0280 [Vibrio phage D69] | diamond | 174 | 47 | 1 | Viruses | Vibrio phage D69 | ||||||||
| 31622736 | 31622736 | PRJNA289590_P_NODE_13496_length_248_cov_1.045226_g13272_i0 | PRJNA289590 | 13496 | 248 | 1.045226 | 2.59216048 | Vibrio phage D69 | 3105312 | Viruses | Viruses | 81.6 | 5.75e-17 | NR | CAL9985992.1 | 3105312 | g13272 | i0 | 47.8 | 0.834677419354839 | 69 | 36 | 83.5 | 0 | 246 | 40 | 118 | 186 | CAL9985992.1 hypothetical protein VPHD69_0280 [Vibrio phage D69] | diamond | 207 | 81.6 | 1 | Viruses | Vibrio phage D69 | ||||||||
| 31875685 | 31875685 | PRJNA289590_P_NODE_21117_length_193_cov_1.270833_g20893_i0 | PRJNA289590 | 21117 | 193 | 1.270833 | 2.45270769 | Inoviridae sp. | 2219103 | Viruses | Viruses | 50.1 | 5e-5 | NR | XOF06140.1 | 2219103 | g20893 | i0 | 56.6 | 0.823834196891192 | 53 | 16 | 71.5 | 2 | 139 | 2 | 83 | 135 | XOF06140.1 MAG: hypothetical protein [Inoviridae sp.] | diamond | 159 | 50.1 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Inoviridae sp. | |||
| 32603412 | 32603412 | PRJNA289590_P_NODE_10820_length_280_cov_0.982684_g10596_i0 | PRJNA289590 | 10820 | 280 | 0.982684 | 2.7515152 | Nitrincola phage 1M3-16 | 1472912 | Viruses | Viruses | 63.2 | 3.3e-9 | NR | YP_009037253.1 | 1472912 | g10596 | i0 | 42.6 | 0.728571428571429 | 68 | 39 | 72.9 | 0 | 75 | 278 | 244 | 311 | YP_009037253.1 ATP-dependent DNA ligase [Nitrincola phage 1M3-16] | diamond | 204 | 63.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Nitrincola phage 1M3-16 | |||||
| 32729373 | 32729373 | PRJNA289590_P_NODE_17180_length_217_cov_0.928571_g16956_i0 | PRJNA289590 | 17180 | 217 | 0.928571 | 2.01499907 | Vibrio phage D181 | 3104936 | Viruses | Viruses | 87.4 | 4.13e-18 | NR | CAM0042940.1 | 3104936 | g16956 | i0 | 62.7 | 0.815668202764977 | 59 | 22 | 81.6 | 0 | 39 | 215 | 132 | 190 | CAM0042940.1 hypothetical protein VPHD181_0277 [Vibrio phage D181] | diamond | 177 | 87.4 | 1 | Viruses | Vibrio phage D181 |
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);;