contig_metadata
6 rows where analysis = "diamond", bioproject = "PRJNA1237347" and tax_phylum = "Kitrinoviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27326254 | 27326254 | PRJNA1237347_P_NODE_537063_length_243_cov_0.905882_g530490_i0 | PRJNA1237347 | 537063 | 243 | 0.905882 | 2.20129326 | Erysiphe necator associated flexivirus 3 | 2743100 | Viruses | Viruses | 112 | 1.15e-26 | NR | QKN22675.1 | 2743100 | g530490 | i0 | 67.1 | 0.975308641975309 | 79 | 26 | 97.5 | 0 | 3 | 239 | 1607 | 1685 | QKN22675.1 RNA-dependent RNA polymerase [Erysiphe necator associated flexivirus 3] | diamond | 237 | 112 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Erysiphe necator associated flexivirus 3 | ||||
| 28052091 | 28052091 | PRJNA1237347_P_NODE_273145_length_354_cov_1.832740_g266572_i0 | PRJNA1237347 | 273145 | 354 | 1.83274 | 6.4878996 | Martellivirales sp. gcode 6 | 3108922 | Viruses | Viruses | 51.2 | 1.48e-4 | NR | WRQ64721.1 | 3108922 | g266572 | i0 | 59 | 0.330508474576271 | 39 | 16 | 33.1 | 0 | 125 | 9 | 961 | 999 | WRQ64721.1 polyprotein, partial [Martellivirales sp. gcode 6] | diamond | 117 | 51.2 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Martellivirales sp. gcode 6 | ||||
| 28399479 | 28399479 | PRJNA1237347_P_NODE_31626_length_1384_cov_2.932876_g27960_i0 | PRJNA1237347 | 31626 | 1384 | 2.932876 | 40.59100384 | Martellivirales sp. gcode 6 | 3108922 | Viruses | Viruses | 63.2 | 2.25e-6 | NR | WRQ64714.1 | 3108922 | g27960 | i0 | 65.9 | 0.0888728323699422 | 41 | 14 | 8.9 | 0 | 365 | 487 | 1198 | 1238 | WRQ64714.1 polyprotein, partial [Martellivirales sp. gcode 6] | diamond | 123 | 63.2 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Martellivirales sp. gcode 6 | ||||
| 31400778 | 31400778 | PRJNA1237347_P_NODE_56_length_14188_cov_108.549982_g48_i0 | PRJNA1237347 | 56 | 14188 | 108.549982 | 15401.07144616 | Martellivirales sp. gcode 6 | 3108922 | Viruses | Viruses | 150 | 2.08e-31 | NR | WRQ64721.1 | 3108922 | g48 | i0 | 55.3 | 0.0279109106287003 | 132 | 59 | 2.8 | 0 | 7115 | 6720 | 897 | 1028 | WRQ64721.1 polyprotein, partial [Martellivirales sp. gcode 6] | diamond | 396 | 150 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Martellivirales sp. gcode 6 | ||||
| 31874605 | 31874605 | PRJNA1237347_P_NODE_294677_length_338_cov_1.049057_g288104_i0 | PRJNA1237347 | 294677 | 338 | 1.049057 | 3.54581266 | Erysiphe necator associated flexivirus 3 | 2743100 | Viruses | Viruses | 186 | 7.539999999999999e-52 | NR | QKN22675.1 | 2743100 | g288104 | i0 | 76.4 | 0.976331360946746 | 110 | 26 | 97.6 | 0 | 330 | 1 | 147 | 256 | QKN22675.1 RNA-dependent RNA polymerase [Erysiphe necator associated flexivirus 3] | diamond | 330 | 186 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Erysiphe necator associated flexivirus 3 | ||||
| 32032825 | 32032825 | PRJNA1237347_P_NODE_2138_length_4895_cov_3.693281_g1858_i0 | PRJNA1237347 | 2138 | 4895 | 3.693281 | 180.78610495 | Martellivirales sp. gcode 6 | 3108922 | Viruses | Viruses | 89.7 | 1.48e-13 | NR | WRQ64721.1 | 3108922 | g1858 | i0 | 34.6 | 0.0796731358529111 | 130 | 85 | 8 | 0 | 315 | 704 | 1901 | 2030 | WRQ64721.1 polyprotein, partial [Martellivirales sp. gcode 6] | diamond | 390 | 89.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Martellivirales sp. gcode 6 |
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);;