contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA1063685" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 179501 | 179501 | PRJNA1063685_S_NODE_24421_length_470_cov_11.473552_g23881_i0 | PRJNA1063685 | 24421 | 470 | 11.473552 | 53.9256944 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 811 | 0 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g23881 | i0 | 98.899 | 1.14255319148936 | 454 | 5 | 97 | 0 | 17 | 470 | 1037 | 584 | Malassezia restricta virus MrV40L, complete genome | blastn | 537 | 811 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 2729810 | 2729810 | PRJNA1063685_S_NODE_10823_length_616_cov_12.694291_g10308_i0 | PRJNA1063685 | 10823 | 616 | 12.694291 | 78.19683256 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 1098 | 0 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g10308 | i0 | 99.503 | 0.980519480519481 | 604 | 2 | 98 | 1 | 1 | 603 | 4604 | 4001 | Malassezia restricta virus MrV40L, complete genome | blastn | 604 | 1098 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 2730153 | 2730153 | PRJNA1063685_S_NODE_44723_length_344_cov_1.442804_g44180_i0 | PRJNA1063685 | 44723 | 344 | 1.442804 | 4.96324576 | Malassezia restricta associated totivirus 2 | 3048758 | Viruses | Viruses | 488 | 2.0899999999999996e-133 | NTclustered | gi|2512878154|emb|OX637980.1| | 3048758 | g44180 | i0 | 94.081 | 1.43313953488372 | 321 | 19 | 93 | 0 | 24 | 344 | 711 | 391 | Malassezia restricta associated totivirus 2 CP gene for capsid protein | blastn | 493 | 488 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta associated totivirus 2 | ||
| 7832260 | 7832260 | PRJNA1063685_S_NODE_42507_length_355_cov_3.567376_g41964_i0 | PRJNA1063685 | 42507 | 355 | 3.567376 | 12.6641848 | Malassezia restricta virus MrV40S | 2727864 | Viruses | Viruses | 542 | 1.63e-149 | NTclustered | gi|1832308146|gb|MN603498.1| | 2727864 | g41964 | i0 | 99.331 | 0.842253521126761 | 299 | 2 | 84 | 0 | 57 | 355 | 1335 | 1037 | Malassezia restricta virus MrV40S, complete genome | blastn | 299 | 542 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40S | |||
| 7832392 | 7832392 | PRJNA1063685_S_NODE_59447_length_282_cov_1.794258_g58904_i0 | PRJNA1063685 | 59447 | 282 | 1.794258 | 5.05980756 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 499 | 7.729999999999999e-137 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g58904 | i0 | 98.582 | 2 | 282 | 4 | 100 | 0 | 1 | 282 | 330 | 611 | Malassezia restricta virus MrV40L, complete genome | blastn | 564 | 499 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 9107115 | 9107115 | PRJNA1063685_S_NODE_27928_length_444_cov_4.347709_g27387_i0 | PRJNA1063685 | 27928 | 444 | 4.347709 | 19.30382796 | Malassezia restricta virus MrV40S | 2727864 | Viruses | Viruses | 752 | 0 | NTclustered | gi|1832308146|gb|MN603498.1| | 2727864 | g27387 | i0 | 99.045 | 0.943693693693694 | 419 | 4 | 94 | 0 | 24 | 442 | 914 | 496 | Malassezia restricta virus MrV40S, complete genome | blastn | 419 | 752 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40S | |||
| 10382874 | 10382874 | PRJNA1063685_S_NODE_37089_length_384_cov_3.292605_g36546_i0 | PRJNA1063685 | 37089 | 384 | 3.292605 | 12.6436032 | Malassezia restricta associated totivirus 1 | 3048757 | Viruses | Viruses | 553 | 8.239999999999998e-153 | NTclustered | gi|2512878152|emb|OX637979.1| | 3048757 | g36546 | i0 | 93.767 | 1.22395833333333 | 369 | 21 | 96 | 2 | 1 | 368 | 1055 | 1422 | Malassezia restricta associated totivirus 1 polyprotein gene for polyprotein | blastn | 470 | 553 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta associated totivirus 1 | ||
| 12933388 | 12933388 | PRJNA1063685_S_NODE_431_length_1475_cov_27.145506_g298_i0 | PRJNA1063685 | 431 | 1475 | 27.145506 | 400.3962135 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 2627 | 0 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g298 | i0 | 99.86 | 1.89491525423729 | 1428 | 2 | 97 | 0 | 24 | 1451 | 3231 | 1804 | Malassezia restricta virus MrV40L, complete genome | blastn | 2795 | 2627 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 16756450 | 16756450 | PRJNA1063685_S_NODE_31834_length_416_cov_2.020408_g31292_i0 | PRJNA1063685 | 31834 | 416 | 2.020408 | 8.40489728 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 713 | 0 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g31292 | i0 | 97.596 | 1 | 416 | 10 | 100 | 0 | 1 | 416 | 1742 | 1327 | Malassezia restricta virus MrV40L, complete genome | blastn | 416 | 713 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 21856258 | 21856258 | PRJNA1063685_S_NODE_18198_length_527_cov_9.451542_g17662_i0 | PRJNA1063685 | 18198 | 527 | 9.451542 | 49.80962634 | Malassezia restricta virus MrV40S | 2727864 | Viruses | Viruses | 756 | 0 | NTclustered | gi|1832308146|gb|MN603498.1| | 2727864 | g17662 | i0 | 93.077 | 0.986717267552182 | 520 | 31 | 98 | 4 | 12 | 527 | 436 | 954 | Malassezia restricta virus MrV40S, complete genome | blastn | 520 | 756 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40S |
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);;