contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA683902" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27504771 | 27504771 | PRJNA683902_S_NODE_33023_length_168_cov_1.450382_g32579_i0 | PRJNA683902 | 33023 | 168 | 1.450382 | 2.43664176 | Deltaflexivirus | 2169569 | Viruses | Viruses | 87.4 | 2.51e-18 | NR | QKN22675.1 | 2743100 | g32579 | i0 | 69.1 | 3.98214285714286 | 55 | 17 | 98.2 | 0 | 4 | 168 | 638 | 692 | QKN22675.1 RNA-dependent RNA polymerase [Erysiphe necator associated flexivirus 3] | diamond | 669 | 87.4 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Erysiphe necator associated flexivirus 3 | ||||
| 27851775 | 27851775 | PRJNA683902_S_NODE_39064_length_152_cov_1.686957_g38620_i0 | PRJNA683902 | 39064 | 152 | 1.686957 | 2.56417464 | Viruses | 10239 | Viruses | Viruses | 81.6 | 2.06e-16 | NR | QKN22675.1 | 2743100 | g38620 | i0 | 76 | 1.97368421052632 | 50 | 12 | 98.7 | 0 | 150 | 1 | 1693 | 1742 | QKN22675.1 RNA-dependent RNA polymerase [Erysiphe necator associated flexivirus 3] | diamond | 300 | 81.6 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Erysiphe necator associated flexivirus 3 | ||||
| 28124497 | 28124497 | PRJNA683902_S_NODE_36865_length_157_cov_1.950000_g36421_i0 | PRJNA683902 | 36865 | 157 | 1.95 | 3.0615 | Fusarium deltaflexivirus 2 | 2973081 | Viruses | Viruses | 77 | 9.53e-15 | NR | BDQ13824.1 | 2973081 | g36421 | i0 | 65.4 | 1.98726114649682 | 52 | 18 | 99.4 | 0 | 156 | 1 | 367 | 418 | BDQ13824.1 unnamed protein product [Fusarium deltaflexivirus 2] | diamond | 312 | 77 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Deltaflexiviridae | Fusarium deltaflexivirus 2 | |||
| 28313975 | 28313975 | PRJNA683902_S_NODE_19946_length_239_cov_1.108911_g19502_i0 | PRJNA683902 | 19946 | 239 | 1.108911 | 2.65029729 | Erysiphe necator associated flexivirus 1 | 2743098 | Viruses | Viruses | 105 | 2.97e-24 | NR | QKN22686.1 | 2743098 | g19502 | i0 | 64.9 | 0.96652719665272 | 77 | 27 | 96.7 | 0 | 9 | 239 | 511 | 587 | QKN22686.1 RNA-dependent RNA polymerase [Erysiphe necator associated flexivirus 1] | diamond | 231 | 105 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Erysiphe necator associated flexivirus 1 | ||||
| 28988819 | 28988819 | PRJNA683902_S_NODE_28228_length_186_cov_1.436242_g27784_i0 | PRJNA683902 | 28228 | 186 | 1.436242 | 2.67141012 | Deltaflexivirus | 2169569 | Viruses | Viruses | 52.8 | 5.06e-6 | NR | QKN22686.1 | 2743098 | g27784 | i0 | 41.8 | 1.91935483870968 | 55 | 32 | 88.7 | 0 | 15 | 179 | 1036 | 1090 | QKN22686.1 RNA-dependent RNA polymerase [Erysiphe necator associated flexivirus 1] | diamond | 357 | 53.1 | 0.994350282485876 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Erysiphe necator associated flexivirus 1 | ||||
| 29008876 | 29008876 | PRJNA683902_S_NODE_7548_length_630_cov_3.853288_g7155_i0 | PRJNA683902 | 7548 | 630 | 3.853288 | 24.2757144 | Erysiphe necator umbra-like virus 2 | 2695368 | Viruses | Viruses | 149 | 3.43e-40 | NR | QHD64839.1 | 2695368 | g7155 | i0 | 64 | 0.542857142857143 | 114 | 41 | 54.3 | 0 | 5 | 346 | 175 | 288 | QHD64839.1 ORF-B [Erysiphe necator umbra-like virus 2] | diamond | 342 | 149 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Umbravirus | Erysiphe necator umbra-like virus 2 | ||
| 29367524 | 29367524 | PRJNA683902_S_NODE_14629_length_313_cov_4.721014_g14185_i0 | PRJNA683902 | 14629 | 313 | 4.721014 | 14.77677382 | Umbravirus | 39734 | Viruses | Viruses | 136 | 1.99e-35 | NR | QOE55597.1 | 2741667 | g14185 | i0 | 71.1 | 1.9073482428115 | 97 | 28 | 93 | 0 | 292 | 2 | 30 | 126 | QOE55597.1 RNA-dependent RNA polymerase [Macrophomina phaseolina umbra-like virus 3] | diamond | 597 | 136 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Umbravirus | Macrophomina phaseolina umbra-like virus 3 | ||
| 29387554 | 29387554 | PRJNA683902_S_NODE_10249_length_449_cov_2.046117_g9810_i0 | PRJNA683902 | 10249 | 449 | 2.046117 | 9.18706533 | Pestalotiopsis deltaflexivirus 1 | 2816841 | Viruses | Viruses | 52 | 2.04e-4 | NR | QTH80200.1 | 2816841 | g9810 | i0 | 35.1 | 0.648106904231626 | 97 | 61 | 64.1 | 2 | 289 | 2 | 706 | 801 | QTH80200.1 MAG: RNA-dependent RNA polymerase [Pestalotiopsis deltaflexivirus 1] | diamond | 291 | 52 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Deltaflexiviridae | Pestalotiopsis deltaflexivirus 1 | |||
| 29545159 | 29545159 | PRJNA683902_S_NODE_16570_length_279_cov_2.797521_g16126_i0 | PRJNA683902 | 16570 | 279 | 2.797521 | 7.80508359 | Grapevine-associated tymo-like virus 2 | 2814378 | Viruses | Viruses | 144 | 9.209999999999999e-40 | NR | QXN75448.1 | 2814378 | g16126 | i0 | 77.2 | 0.989247311827957 | 92 | 21 | 98.9 | 0 | 2 | 277 | 223 | 314 | QXN75448.1 MAG: RNA-dependent RNA polymerase, partial [Grapevine-associated tymo-like virus 2] | diamond | 276 | 144 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Grapevine-associated tymo-like virus 2 | ||||
| 31946956 | 31946956 | PRJNA683902_S_NODE_4057_length_1145_cov_4.355596_g3828_i0 | PRJNA683902 | 4057 | 1145 | 4.355596 | 49.8715742 | Macrophomina phaseolina umbra-like virus 1 | 2741665 | Viruses | Viruses | 280 | 3.28e-86 | NR | QOE55594.1 | 2741665 | g3828 | i0 | 51.1 | 1.45152838427948 | 276 | 134 | 72.1 | 1 | 1140 | 316 | 234 | 509 | QOE55594.1 RNA-dependent RNA polymerase [Macrophomina phaseolina umbra-like virus 1] | diamond | 1662 | 280 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Umbravirus | Macrophomina phaseolina umbra-like virus 1 | ||
| 32295552 | 32295552 | PRJNA683902_S_NODE_20039_length_238_cov_1.572139_g19595_i0 | PRJNA683902 | 20039 | 238 | 1.572139 | 3.74169082 | Erysiphe necator associated flexivirus 3 | 2743100 | Viruses | Viruses | 113 | 5.660000000000001e-27 | NR | QKN22675.1 | 2743100 | g19595 | i0 | 65.4 | 0.983193277310924 | 78 | 27 | 98.3 | 0 | 3 | 236 | 221 | 298 | QKN22675.1 RNA-dependent RNA polymerase [Erysiphe necator associated flexivirus 3] | diamond | 234 | 113 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Erysiphe necator associated flexivirus 3 |
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);;