contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJNA432257" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26632600 | 26632600 | PRJNA432257_S_NODE_113161_length_163_cov_1.563492_g112780_i0 | PRJNA432257 | 113161 | 163 | 1.563492 | 2.54849196 | Erysiphe necator associated flexivirus 2 | 2743099 | Viruses | Viruses | 111 | 9.48e-27 | NR | QKN22646.1 | 2743099 | g112780 | i0 | 88.9 | 0.993865030674847 | 54 | 6 | 99.4 | 0 | 163 | 2 | 1877 | 1930 | QKN22646.1 RNA-dependent RNA polymerase [Erysiphe necator associated flexivirus 2] | diamond | 162 | 111 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Erysiphe necator associated flexivirus 2 | ||||
| 28812365 | 28812365 | PRJNA432257_S_NODE_106548_length_170_cov_2.052632_g106167_i0 | PRJNA432257 | 106548 | 170 | 2.052632 | 3.4894744 | Clover yellow mosaic virus | 12177 | Viruses | Viruses | 42.4 | 0.0183 | NR | UZP17131.1 | 12177 | g106167 | i0 | 87.5 | 1.27058823529412 | 24 | 3 | 42.4 | 0 | 163 | 92 | 233 | 256 | UZP17131.1 ORF5 [Clover yellow mosaic virus] | diamond | 216 | 42.4 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus flavitrifolii | ||
| 29664806 | 29664806 | PRJNA432257_S_NODE_108470_length_168_cov_1.786260_g108089_i0 | PRJNA432257 | 108470 | 168 | 1.78626 | 3.0009168 | Erysiphe necator associated flexivirus 2 | 2743099 | Viruses | Viruses | 93.2 | 2.34e-20 | NR | QKN22646.1 | 2743099 | g108089 | i0 | 76.8 | 1 | 56 | 13 | 100 | 0 | 168 | 1 | 578 | 633 | QKN22646.1 RNA-dependent RNA polymerase [Erysiphe necator associated flexivirus 2] | diamond | 168 | 93.2 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Erysiphe necator associated flexivirus 2 | ||||
| 29886403 | 29886403 | PRJNA432257_S_NODE_122731_length_154_cov_3.264957_g122350_i0 | PRJNA432257 | 122731 | 154 | 3.264957 | 5.02803378 | Erysiphe necator associated flexivirus 2 | 2743099 | Viruses | Viruses | 94 | 1.01e-20 | NR | QKN22646.1 | 2743099 | g122350 | i0 | 96 | 0.974025974025974 | 50 | 2 | 97.4 | 0 | 151 | 2 | 1155 | 1204 | QKN22646.1 RNA-dependent RNA polymerase [Erysiphe necator associated flexivirus 2] | diamond | 150 | 94 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Erysiphe necator associated flexivirus 2 | ||||
| 29917989 | 29917989 | PRJNA432257_S_NODE_26491_length_292_cov_1.376471_g26110_i0 | PRJNA432257 | 26491 | 292 | 1.376471 | 4.01929532 | Erysiphe necator associated flexivirus 2 | 2743099 | Viruses | Viruses | 135 | 2.53e-34 | NR | QKN22646.1 | 2743099 | g26110 | i0 | 68 | 0.996575342465753 | 97 | 31 | 99.7 | 0 | 1 | 291 | 954 | 1050 | QKN22646.1 RNA-dependent RNA polymerase [Erysiphe necator associated flexivirus 2] | diamond | 291 | 135 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Erysiphe necator associated flexivirus 2 | ||||
| 32098906 | 32098906 | PRJNA432257_S_NODE_438_length_2108_cov_59.100917_g428_i0 | PRJNA432257 | 438 | 2108 | 59.100917 | 1245.84733036 | Grapevine wood holobiome associated deltaflexivirus 2 | 3384488 | Viruses | Viruses | 54.7 | 2.43e-4 | NR | XLE34830.1 | 3384488 | g428 | i0 | 33 | 0.163662239089184 | 115 | 68 | 15.8 | 2 | 1061 | 1393 | 62 | 171 | XLE34830.1 hypothetical protein [Grapevine wood holobiome associated deltaflexivirus 2] | diamond | 345 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Deltaflexiviridae | Deltaflexivirus | Grapevine wood holobiome associated deltaflexivirus 2 | ||
| 32320797 | 32320797 | PRJNA432257_S_NODE_439_length_2108_cov_48.098986_g428_i1 | PRJNA432257 | 439 | 2108 | 48.098986 | 1013.92662488 | Grapevine wood holobiome associated deltaflexivirus 2 | 3384488 | Viruses | Viruses | 54.7 | 2.43e-4 | NR | XLE34830.1 | 3384488 | g428 | i1 | 33 | 0.163662239089184 | 115 | 68 | 15.8 | 2 | 1048 | 716 | 62 | 171 | XLE34830.1 hypothetical protein [Grapevine wood holobiome associated deltaflexivirus 2] | diamond | 345 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Deltaflexiviridae | Deltaflexivirus | Grapevine wood holobiome associated deltaflexivirus 2 | ||
| 32731077 | 32731077 | PRJNA432257_S_NODE_67920_length_206_cov_1.254438_g67539_i0 | PRJNA432257 | 67920 | 206 | 1.254438 | 2.58414228 | Erysiphe necator associated flexivirus 2 | 2743099 | Viruses | Viruses | 131 | 1.22e-33 | NR | QKN22646.1 | 2743099 | g67539 | i0 | 94.1 | 0.990291262135922 | 68 | 4 | 99 | 0 | 2 | 205 | 1215 | 1282 | QKN22646.1 RNA-dependent RNA polymerase [Erysiphe necator associated flexivirus 2] | diamond | 204 | 131 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Erysiphe necator associated flexivirus 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);;