contig_metadata
6 rows where analysis = "diamond", bioproject = "PRJNA674308" and tax_kingdom = "Orthornavirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27871418 | 27871418 | PRJNA674308_P_NODE_52905_length_162_cov_0.920354_g52670_i0 | PRJNA674308 | 52905 | 162 | 0.920354 | 1.49097348 | Malassezia globosa associated totivirus 1 | 3048756 | Viruses | Viruses | 113 | 1.86e-27 | NR | CAI9858974.1 | 3048756 | g52670 | i0 | 94.3 | 0.981481481481482 | 53 | 3 | 98.1 | 0 | 2 | 160 | 143 | 195 | CAI9858974.1 capsid protein [Malassezia globosa associated totivirus 1] | diamond | 159 | 113 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia globosa associated totivirus 1 | ||
| 29481432 | 29481432 | PRJNA674308_P_NODE_44410_length_166_cov_0.888889_g44175_i0 | PRJNA674308 | 44410 | 166 | 0.888889 | 1.47555574 | Malassezia globosa associated totivirus 1 | 3048756 | Viruses | Viruses | 100 | 8.189999999999999e-23 | NR | CAI9858974.1 | 3048756 | g44175 | i0 | 75.9 | 0.975903614457831 | 54 | 13 | 97.6 | 0 | 5 | 166 | 395 | 448 | CAI9858974.1 capsid protein [Malassezia globosa associated totivirus 1] | diamond | 162 | 100 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia globosa associated totivirus 1 | ||
| 30441390 | 30441390 | PRJNA674308_P_NODE_36593_length_169_cov_0.866667_g36358_i0 | PRJNA674308 | 36593 | 169 | 0.866667 | 1.46466723 | Totivirus | 11007 | Viruses | Viruses | 66.2 | 7.09e-11 | NR | QJW70335.1 | 2737096 | g36358 | i0 | 51.9 | 1.84615384615385 | 52 | 25 | 92.3 | 0 | 166 | 11 | 723 | 774 | QJW70335.1 RNA-dependent RNA polymerase [Erysiphe necator associated totivirus 6] | diamond | 312 | 66.2 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Erysiphe necator associated totivirus 6 | ||
| 30492596 | 30492596 | PRJNA674308_P_NODE_28693_length_188_cov_1.496403_g28458_i0 | PRJNA674308 | 28693 | 188 | 1.496403 | 2.81323764 | Malassezia restricta virus MrV4 | 76775 | Viruses | Viruses | 102 | 2.3599999999999998e-23 | NR | QJA42332.1 | 2727863 | g28458 | i0 | 79 | 1.97872340425532 | 62 | 13 | 98.9 | 0 | 186 | 1 | 807 | 868 | QJA42332.1 polyprotein [Malassezia restricta virus MrV40L] | diamond | 372 | 102 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 31124103 | 31124103 | PRJNA674308_P_NODE_45915_length_165_cov_0.896552_g45680_i0 | PRJNA674308 | 45915 | 165 | 0.896552 | 1.4793108 | Malassezia restricta associated totivirus 1 | 3048757 | Viruses | Viruses | 94.4 | 8.4e-21 | NR | CAI9858976.1 | 3048757 | g45680 | i0 | 83.3 | 0.981818181818182 | 54 | 9 | 98.2 | 0 | 3 | 164 | 486 | 539 | CAI9858976.1 polyprotein, partial [Malassezia restricta associated totivirus 1] | diamond | 162 | 94.4 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta associated totivirus 1 | ||
| 31598989 | 31598989 | PRJNA674308_P_NODE_44356_length_166_cov_0.888889_g44121_i0 | PRJNA674308 | 44356 | 166 | 0.888889 | 1.47555574 | Malassezia globosa associated totivirus 1 | 3048756 | Viruses | Viruses | 91.7 | 7.44e-20 | NR | CAI9858973.1 | 3048756 | g44121 | i0 | 74.1 | 0.975903614457831 | 54 | 14 | 97.6 | 0 | 3 | 164 | 223 | 276 | CAI9858973.1 RNA-dependent RNA polymerase [Malassezia globosa associated totivirus 1] | diamond | 162 | 91.7 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia globosa associated totivirus 1 |
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);;