contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA1160211" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4136506 | 4136506 | PRJNA1160211_S_NODE_195504_length_316_cov_1.584362_g194271_i0 | PRJNA1160211 | 195504 | 316 | 1.584362 | 5.00658392 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 571 | 1.84e-158 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g194271 | i0 | 100 | 0.977848101265823 | 309 | 0 | 98 | 0 | 8 | 316 | 1 | 309 | Malassezia restricta virus MrV40L, complete genome | blastn | 309 | 571 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 13063656 | 13063656 | PRJNA1160211_S_NODE_248691_length_263_cov_1.489474_g247458_i0 | PRJNA1160211 | 248691 | 263 | 1.489474 | 3.91731662 | Chemarfal virus 258 | 3063149 | Viruses | Viruses | 442 | 1.2199999999999994e-119 | NTclustered | gi|2626079799|gb|OR270470.1| | 3063149 | g247458 | i0 | 98.031 | 0.965779467680608 | 254 | 5 | 97 | 0 | 1 | 254 | 2084 | 1831 | MAG: Chemarfal virus 258 isolate ML188 genomic sequence | blastn | 254 | 442 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chemarfal virus 258 | ||||
| 14338961 | 14338961 | PRJNA1160211_S_NODE_238712_length_271_cov_6.378788_g237479_i0 | PRJNA1160211 | 238712 | 271 | 6.378788 | 17.28651548 | Malassezia restricta associated totivirus 2 | 3048758 | Viruses | Viruses | 462 | 9.69e-126 | NTclustered | gi|2512878154|emb|OX637980.1| | 3048758 | g237479 | i0 | 99.605 | 0.933579335793358 | 253 | 1 | 93 | 0 | 1 | 253 | 206 | 458 | Malassezia restricta associated totivirus 2 CP gene for capsid protein | blastn | 253 | 462 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta associated totivirus 2 | ||
| 15612557 | 15612557 | PRJNA1160211_S_NODE_210413_length_299_cov_3.747788_g209180_i0 | PRJNA1160211 | 210413 | 299 | 3.747788 | 11.20588612 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 475 | 1.3899999999999996e-129 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g209180 | i0 | 99.242 | 0.882943143812709 | 264 | 1 | 88 | 1 | 14 | 276 | 675 | 938 | Malassezia restricta virus MrV40L, complete genome | blastn | 264 | 475 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 15613577 | 15613577 | PRJNA1160211_S_NODE_83193_length_491_cov_10.265550_g81974_i0 | PRJNA1160211 | 83193 | 491 | 10.26555 | 50.4038505 | Totivirus sp. | 2776824 | Viruses | Viruses | 750 | 0 | NTclustered | gi|1918615616|gb|MT949667.1| | 2776824 | g81974 | i0 | 95.339 | 1.88187372708758 | 472 | 22 | 96 | 0 | 1 | 472 | 891 | 1362 | Totivirus sp. isolate sequence_5835 genomic sequence | blastn | 924 | 750 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus sp. | ||
| 16887398 | 16887398 | PRJNA1160211_S_NODE_280274_length_242_cov_2.390533_g279041_i0 | PRJNA1160211 | 280274 | 242 | 2.390533 | 5.78508986 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 405 | 1.45e-108 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g279041 | i0 | 98.268 | 0.954545454545455 | 231 | 4 | 95 | 0 | 12 | 242 | 2969 | 2739 | Malassezia restricta virus MrV40L, complete genome | blastn | 231 | 405 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 16887538 | 16887538 | PRJNA1160211_S_NODE_32634_length_639_cov_27.005300_g31525_i0 | PRJNA1160211 | 32634 | 639 | 27.0053 | 172.563867 | Chemarfal virus 260 | 3063286 | Viruses | Viruses | 841 | 0 | NTclustered | gi|2626079958|gb|OR270550.1| | 3063286 | g31525 | i0 | 96.289 | 0.982785602503912 | 512 | 19 | 80 | 0 | 117 | 628 | 1 | 512 | MAG: Chemarfal virus 260 isolate ML188 genomic sequence | blastn | 628 | 841 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chemarfal virus 260 | ||||
| 22715537 | 22715537 | PRJNA1160211_S_NODE_24678_length_680_cov_10.993410_g23623_i0 | PRJNA1160211 | 24678 | 680 | 10.99341 | 74.755188 | Totivirus | 11007 | Viruses | Viruses | 1234 | 0 | NTclustered | gi|2512878154|emb|OX637980.1| | 3048758 | g23623 | i0 | 99.412 | 2 | 680 | 4 | 100 | 0 | 1 | 680 | 1723 | 1044 | Malassezia restricta associated totivirus 2 CP gene for capsid protein | blastn | 1360 | 1245 | 0.991164658634538 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta associated totivirus 2 | ||
| 23262415 | 23262415 | PRJNA1160211_S_NODE_27439_length_665_cov_2.978041_g26355_i0 | PRJNA1160211 | 27439 | 665 | 2.978041 | 19.80397265 | Malassezia restricta virus MrV40S | 2727864 | Viruses | Viruses | 198 | 8.039999999999999e-46 | NTclustered | gi|1832308146|gb|MN603498.1| | 2727864 | g26355 | i0 | 73.237 | 1.04511278195489 | 695 | 127 | 100 | 48 | 1 | 665 | 795 | 130 | Malassezia restricta virus MrV40S, complete genome | blastn | 695 | 198 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40S | |||
| 23263048 | 23263048 | PRJNA1160211_S_NODE_8619_length_842_cov_12.921977_g7896_i0 | PRJNA1160211 | 8619 | 842 | 12.921977 | 108.80304634 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 1519 | 0 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g7896 | i0 | 99.286 | 0.997624703087886 | 840 | 6 | 99 | 0 | 1 | 840 | 1812 | 2651 | Malassezia restricta virus MrV40L, complete genome | blastn | 840 | 1519 | 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);;