contig_metadata
4 rows where bioproject = "PRJNA495391" and tax_phylum = "Duplornaviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6854383 | 6854383 | PRJNA495391_S_NODE_50226_length_174_cov_2.611511_g49174_i0 | PRJNA495391 | 50226 | 174 | 2.611511 | 4.54402914 | Xian Totiv tick virus 2 | 2972358 | Viruses | Viruses | 283 | 4.769999999999999e-72 | NTclustered | gi|2320153247|gb|ON746556.1| | 2972358 | g49174 | i0 | 95.977 | 1 | 174 | 7 | 100 | 0 | 1 | 174 | 435 | 262 | MAG: Xian Totiv tick virus 2 isolate TIGMIC 1 genomic sequence | blastn | 174 | 283 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Xian Totiv tick virus 2 | |||
| 30740423 | 30740423 | PRJNA495391_S_NODE_15014_length_309_cov_1.901460_g13962_i0 | PRJNA495391 | 15014 | 309 | 1.90146 | 5.8755114 | Malassezia restricta associated totivirus 1 | 3048757 | Viruses | Viruses | 173 | 2.41e-48 | NR | CAI9858976.1 | 3048757 | g13962 | i0 | 87.5 | 0.932038834951456 | 96 | 12 | 93.2 | 0 | 308 | 21 | 595 | 690 | CAI9858976.1 polyprotein, partial [Malassezia restricta associated totivirus 1] | diamond | 288 | 173 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta associated totivirus 1 | ||
| 31277576 | 31277576 | PRJNA495391_S_NODE_1235_length_1430_cov_4.279570_g524_i0 | PRJNA495391 | 1235 | 1430 | 4.27957 | 61.197851 | Malassezia restricta associated totivirus 1 | 3048757 | Viruses | Viruses | 707 | 1.3899999999999998e-249 | NR | CAI9858976.1 | 3048757 | g524 | i0 | 91 | 0.795104895104895 | 379 | 34 | 79.5 | 0 | 6 | 1142 | 312 | 690 | CAI9858976.1 polyprotein, partial [Malassezia restricta associated totivirus 1] | diamond | 1137 | 707 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta associated totivirus 1 | ||
| 31562566 | 31562566 | PRJNA495391_S_NODE_32336_length_214_cov_1.391061_g31284_i0 | PRJNA495391 | 32336 | 214 | 1.391061 | 2.97687054 | Malassezia restricta associated totivirus 1 | 3048757 | Viruses | Viruses | 146 | 6.4e-39 | NR | CAI9858976.1 | 3048757 | g31284 | i0 | 94.4 | 0.995327102803738 | 71 | 4 | 99.5 | 0 | 214 | 2 | 390 | 460 | CAI9858976.1 polyprotein, partial [Malassezia restricta associated totivirus 1] | diamond | 213 | 146 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta 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);;