contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA704949" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1973147 | 1973147 | PRJNA704949_P_NODE_37362_length_1268_cov_7.850697_g27610_i0 | PRJNA704949 | 37362 | 1268 | 7.850697 | 99.54683796 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 2242 | 0 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g27610 | i0 | 98.58 | 1 | 1268 | 18 | 100 | 0 | 1 | 1268 | 2739 | 1472 | Malassezia restricta virus MrV40L, complete genome | blastn | 1268 | 2242 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 8343837 | 8343837 | PRJNA704949_P_NODE_1581947_length_194_cov_1.331034_g1566608_i0 | PRJNA704949 | 1581947 | 194 | 1.331034 | 2.58220596 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 353 | 4.1e-93 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g1566608 | i0 | 99.485 | 1.70103092783505 | 194 | 1 | 100 | 0 | 1 | 194 | 3492 | 3299 | Malassezia restricta virus MrV40L, complete genome | blastn | 330 | 353 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 19824876 | 19824876 | PRJNA704949_P_NODE_460116_length_401_cov_3.642045_g444905_i0 | PRJNA704949 | 460116 | 401 | 3.642045 | 14.60460045 | Totiviridae sp. | 1955172 | Viruses | Viruses | 243 | 2.12e-59 | NTclustered | gi|2396038768|gb|ON812661.1| | 1955172 | g444905 | i0 | 80.984 | 2.40648379052369 | 305 | 58 | 76 | 0 | 96 | 400 | 4520 | 4216 | MAG: Totiviridae sp. isolate TIGMIC_4, complete genome | blastn | 965 | 243 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Totiviridae sp. | |||
| 21091613 | 21091613 | PRJNA704949_P_NODE_1390917_length_211_cov_1.401235_g1375579_i0 | PRJNA704949 | 1390917 | 211 | 1.401235 | 2.95660585 | Chemarfal virus 260 | 3063286 | Viruses | Viruses | 331 | 2.13e-86 | NTclustered | gi|2626079958|gb|OR270550.1| | 3063286 | g1375579 | i0 | 96.078 | 3.75355450236967 | 204 | 6 | 97 | 2 | 7 | 210 | 146 | 347 | MAG: Chemarfal virus 260 isolate ML188 genomic sequence | blastn | 792 | 331 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chemarfal virus 260 | ||||
| 22374035 | 22374035 | PRJNA704949_P_NODE_322738_length_475_cov_1.708920_g307845_i0 | PRJNA704949 | 322738 | 475 | 1.70892 | 8.11737 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 850 | 0 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g307845 | i0 | 98.947 | 1.49263157894737 | 475 | 5 | 100 | 0 | 1 | 475 | 3191 | 2717 | Malassezia restricta virus MrV40L, complete genome | blastn | 709 | 850 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 23649709 | 23649709 | PRJNA704949_P_NODE_31699_length_1403_cov_2.081979_g22473_i0 | PRJNA704949 | 31699 | 1403 | 2.081979 | 29.21016537 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 2023 | 0 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g22473 | i0 | 98.517 | 1.23093371347113 | 1146 | 17 | 99 | 0 | 258 | 1403 | 333 | 1478 | Malassezia restricta virus MrV40L, complete genome | blastn | 1727 | 2023 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L |
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);;