contig_metadata
10 rows where bioproject = "PRJNA315399", tax_phylum = "Duplornaviricota" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 384492 | 384492 | PRJNA315399_S_NODE_144341_length_162_cov_5.696000_g144140_i0 | PRJNA315399 | 144341 | 162 | 5.696 | 9.22752 | Alphachrysovirus perseae | 2955248 | Viruses | Viruses | 300 | 4.36e-77 | NTclustered | gi|1694999067|ref|NC_043508.1| | 1587509 | g144140 | i0 | 100 | 1 | 162 | 0 | 100 | 0 | 1 | 162 | 1858 | 1697 | Persea americana chrysovirus segment RNA2, complete sequence | blastn | 162 | 300 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chrysoviridae | Alphachrysovirus | Alphachrysovirus perseae | ||
| 5488772 | 5488772 | PRJNA315399_S_NODE_36605_length_234_cov_4.786802_g36404_i0 | PRJNA315399 | 36605 | 234 | 4.786802 | 11.20111668 | Chemarfal virus 258 | 3063149 | Viruses | Viruses | 254 | 5.35e-63 | NTclustered | gi|2626079799|gb|OR270470.1| | 3063149 | g36404 | i0 | 100 | 0.974358974358974 | 137 | 0 | 59 | 0 | 1 | 137 | 2079 | 2215 | MAG: Chemarfal virus 258 isolate ML188 genomic sequence | blastn | 228 | 254 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chemarfal virus 258 | ||||
| 6762828 | 6762828 | PRJNA315399_S_NODE_3666_length_486_cov_31.893096_g3479_i0 | PRJNA315399 | 3666 | 486 | 31.893096 | 155.00044656 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 848 | 0 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g3479 | i0 | 98.148 | 1.88065843621399 | 486 | 9 | 100 | 0 | 1 | 486 | 2265 | 2750 | Malassezia restricta virus MrV40L, complete genome | blastn | 914 | 848 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 8037966 | 8037966 | PRJNA315399_S_NODE_17427_length_292_cov_18.988235_g17226_i0 | PRJNA315399 | 17427 | 292 | 18.988235 | 55.4456462 | Alphachrysovirus perseae | 2955248 | Viruses | Viruses | 484 | 2.2499999999999993e-132 | NTclustered | gi|1694999067|ref|NC_043508.1| | 1587509 | g17226 | i0 | 98.208 | 0.955479452054795 | 279 | 2 | 96 | 1 | 1 | 279 | 2464 | 2189 | Persea americana chrysovirus segment RNA2, complete sequence | blastn | 279 | 484 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chrysoviridae | Alphachrysovirus | Alphachrysovirus perseae | ||
| 8038396 | 8038396 | PRJNA315399_S_NODE_34767_length_237_cov_18.255000_g34566_i0 | PRJNA315399 | 34767 | 237 | 18.255 | 43.26435 | Alphachrysovirus perseae | 2955248 | Viruses | Viruses | 411 | 3.049999999999999e-110 | NTclustered | gi|1694999067|ref|NC_043508.1| | 1587509 | g34566 | i0 | 99.556 | 0.949367088607595 | 225 | 1 | 95 | 0 | 13 | 237 | 1857 | 2081 | Persea americana chrysovirus segment RNA2, complete sequence | blastn | 225 | 411 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chrysoviridae | Alphachrysovirus | Alphachrysovirus perseae | ||
| 9312402 | 9312402 | PRJNA315399_S_NODE_128428_length_167_cov_4.553846_g128227_i0 | PRJNA315399 | 128428 | 167 | 4.553846 | 7.60492282 | Malassezia restricta virus MrV40S | 2727864 | Viruses | Viruses | 235 | 1.3e-57 | NTclustered | gi|1832308146|gb|MN603498.1| | 2727864 | g128227 | i0 | 93.125 | 0.958083832335329 | 160 | 11 | 96 | 0 | 1 | 160 | 868 | 709 | Malassezia restricta virus MrV40S, complete genome | blastn | 160 | 235 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40S | |||
| 16962733 | 16962733 | PRJNA315399_S_NODE_51294_length_213_cov_5.096591_g51093_i0 | PRJNA315399 | 51294 | 213 | 5.096591 | 10.85573883 | Helianthus annuus leaf-associated totivirus 9 | 2883723 | Viruses | Viruses | 86.1 | 1.85e-12 | NTclustered | gi|2204387976|gb|MZ532549.1| | 2883723 | g51093 | i0 | 80.702 | 0.535211267605634 | 114 | 18 | 52 | 4 | 69 | 179 | 2424 | 2536 | Helianthus annuus leaf-associated totivirus 9 capsid protein gene, complete cds | blastn | 114 | 86.1 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Helianthus annuus leaf-associated totivirus 9 | |||
| 22060925 | 22060925 | PRJNA315399_S_NODE_142218_length_163_cov_2.777778_g142017_i0 | PRJNA315399 | 142218 | 163 | 2.777778 | 4.52777814 | Malassezia restricta virus MrV40S | 2727864 | Viruses | Viruses | 195 | 2.13e-45 | NTclustered | gi|1832308146|gb|MN603498.1| | 2727864 | g142017 | i0 | 95.122 | 0.754601226993865 | 123 | 6 | 75 | 0 | 9 | 131 | 981 | 1103 | Malassezia restricta virus MrV40S, complete genome | blastn | 123 | 195 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40S | |||
| 31211411 | 31211411 | PRJNA315399_S_NODE_10355_length_345_cov_8.457792_g10154_i0 | PRJNA315399 | 10355 | 345 | 8.457792 | 29.1793824 | Malassezia restricta virus MrV4 | 76775 | Viruses | Viruses | 197 | 7.379999999999998e-56 | NR | QJA42332.1 | 2727863 | g10154 | i0 | 83 | 1.94782608695652 | 112 | 19 | 97.4 | 0 | 8 | 343 | 792 | 903 | QJA42332.1 polyprotein [Malassezia restricta virus MrV40L] | diamond | 672 | 197 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 32319422 | 32319422 | PRJNA315399_S_NODE_24159_length_264_cov_8.656388_g23958_i0 | PRJNA315399 | 24159 | 264 | 8.656388 | 22.85286432 | Geotrichum candidum totivirus 3b | 2971329 | Viruses | Viruses | 160 | 2.0599999999999996e-43 | NR | UUT40381.1 | 2971329 | g23958 | i0 | 97.5 | 0.920454545454545 | 81 | 2 | 92 | 0 | 22 | 264 | 46 | 126 | UUT40381.1 RNA-dependent RNA polymerase [Geotrichum candidum totivirus 3b] | diamond | 243 | 160 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Geotrichum candidum totivirus 3b |
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);;