contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA896758" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27782372 | 27782372 | PRJNA896758_P_NODE_12884_length_320_cov_1.611336_g12494_i0 | PRJNA896758 | 12884 | 320 | 1.611336 | 5.1562752 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 109 | 3.27e-26 | NR | XOS40026.1 | 2832643 | g12494 | i0 | 64.5 | 0.7125 | 76 | 27 | 71.3 | 0 | 230 | 3 | 34 | 109 | XOS40026.1 MAG: hypothetical protein MSP1048_67 [Caudoviricetes sp.] | diamond | 228 | 109 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27782390 | 27782390 | PRJNA896758_P_NODE_24624_length_245_cov_0.895349_g24234_i0 | PRJNA896758 | 24624 | 245 | 0.895349 | 2.19360505 | Ralstonia phage PY | 3145150 | Viruses | Viruses | 145 | 2.86e-39 | NR | XAO34295.1 | 3145150 | g24234 | i0 | 80.2 | 0.991836734693878 | 81 | 16 | 99.2 | 0 | 1 | 243 | 177 | 257 | XAO34295.1 hypothetical protein HMHLAPFJ_00001 [Ralstonia phage PY059YO380] | diamond | 243 | 145 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Ralstonia phage PY059YO380 | |||||
| 28129653 | 28129653 | PRJNA896758_P_NODE_14305_length_304_cov_1.000000_g13915_i0 | PRJNA896758 | 14305 | 304 | 1 | 3.04 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 128 | 1.11e-33 | NR | XOS40026.1 | 2832643 | g13915 | i0 | 59.4 | 0.996710526315789 | 101 | 41 | 99.7 | 0 | 2 | 304 | 213 | 313 | XOS40026.1 MAG: hypothetical protein MSP1048_67 [Caudoviricetes sp.] | diamond | 303 | 128 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28413839 | 28413839 | PRJNA896758_P_NODE_9466_length_371_cov_1.429530_g9076_i0 | PRJNA896758 | 9466 | 371 | 1.42953 | 5.3035563 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 82.4 | 5.64e-17 | NR | XOR88454.1 | 2832643 | g9076 | i0 | 82.2 | 0.363881401617251 | 45 | 8 | 36.4 | 0 | 237 | 371 | 1 | 45 | XOR88454.1 MAG: hypothetical protein MSP1660_66 [Caudoviricetes sp.] | diamond | 135 | 82.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28823905 | 28823905 | PRJNA896758_P_NODE_19088_length_266_cov_1.533679_g18698_i0 | PRJNA896758 | 19088 | 266 | 1.533679 | 4.07958614 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 73.2 | 9.81e-13 | NR | XOR52210.1 | 2832643 | g18698 | i0 | 50 | 1.92857142857143 | 86 | 43 | 97 | 0 | 2 | 259 | 1074 | 1159 | XOR52210.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 513 | 73.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 29992568 | 29992568 | PRJNA896758_P_NODE_23011_length_248_cov_0.880000_g22621_i0 | PRJNA896758 | 23011 | 248 | 0.88 | 2.1824 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 100 | 1.05e-22 | NR | XOS39995.1 | 2832643 | g22621 | i0 | 72.6 | 0.883064516129032 | 73 | 17 | 88.3 | 2 | 30 | 248 | 126 | 195 | XOS39995.1 MAG: conserved phage protein [Caudoviricetes sp.] | diamond | 219 | 100 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31477957 | 31477957 | PRJNA896758_P_NODE_25016_length_244_cov_0.900585_g24626_i0 | PRJNA896758 | 25016 | 244 | 0.900585 | 2.1974274 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 154 | 7.47e-42 | NR | XOR78535.1 | 2832643 | g24626 | i0 | 93.8 | 0.995901639344262 | 81 | 5 | 99.6 | 0 | 1 | 243 | 38 | 118 | XOR78535.1 MAG: ATP-dependent DNA helicase uvsW [Caudoviricetes sp.] | diamond | 243 | 154 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. |
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);;