contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA608660" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1860407 | 1860407 | PRJNA608660_P_NODE_10542_length_459_cov_5.956098_g10197_i0 | PRJNA608660 | 10542 | 459 | 5.956098 | 27.33848982 | Chemarfal virus 260 | 3063286 | Viruses | Viruses | 418 | 3.809999999999999e-112 | NTclustered | gi|2626079958|gb|OR270550.1| | 3063286 | g10197 | i0 | 96.8 | 3.35294117647059 | 250 | 8 | 54 | 0 | 210 | 459 | 1431 | 1182 | MAG: Chemarfal virus 260 isolate ML188 genomic sequence | blastn | 1539 | 418 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chemarfal virus 260 | ||||
| 3135416 | 3135416 | PRJNA608660_P_NODE_1663_length_956_cov_16.037486_g1490_i0 | PRJNA608660 | 1663 | 956 | 16.037486 | 153.31836616 | Chemarfal virus 258 | 3063149 | Viruses | Viruses | 564 | 1.01e-155 | NTclustered | gi|2626079799|gb|OR270470.1| | 3063149 | g1490 | i0 | 97.853 | 1.00941422594142 | 326 | 7 | 68 | 0 | 1 | 326 | 1890 | 2215 | MAG: Chemarfal virus 258 isolate ML188 genomic sequence | blastn | 965 | 564 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chemarfal virus 258 | ||||
| 4412493 | 4412493 | PRJNA608660_P_NODE_6064_length_597_cov_20.675182_g5750_i0 | PRJNA608660 | 6064 | 597 | 20.675182 | 123.43083654 | Chemarfal virus 258 | 3063149 | Viruses | Viruses | 1050 | 0 | NTclustered | gi|2626079799|gb|OR270470.1| | 3063149 | g5750 | i0 | 99.652 | 1.92294807370184 | 574 | 2 | 96 | 0 | 15 | 588 | 874 | 301 | MAG: Chemarfal virus 258 isolate ML188 genomic sequence | blastn | 1148 | 1050 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chemarfal virus 258 | ||||
| 5688438 | 5688438 | PRJNA608660_P_NODE_3445_length_750_cov_8.840228_g3195_i0 | PRJNA608660 | 3445 | 750 | 8.840228 | 66.30171 | Totivirus sp. | 2776824 | Viruses | Viruses | 532 | 2.199999999999999e-146 | NTclustered | gi|1918615616|gb|MT949667.1| | 2776824 | g3195 | i0 | 80.056 | 1.56533333333333 | 717 | 143 | 96 | 0 | 21 | 737 | 1308 | 592 | Totivirus sp. isolate sequence_5835 genomic sequence | blastn | 1174 | 532 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus sp. | ||
| 5688656 | 5688656 | PRJNA608660_P_NODE_8825_length_502_cov_9.461369_g8487_i0 | PRJNA608660 | 8825 | 502 | 9.461369 | 47.49607238 | Totivirus sp. | 2776824 | Viruses | Viruses | 442 | 2.4899999999999995e-119 | NTclustered | gi|1918615616|gb|MT949667.1| | 2776824 | g8487 | i0 | 83.617 | 1.83266932270916 | 470 | 77 | 94 | 0 | 15 | 484 | 1227 | 758 | Totivirus sp. isolate sequence_5835 genomic sequence | blastn | 920 | 442 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus sp. | ||
| 6963084 | 6963084 | PRJNA608660_P_NODE_40546_length_186_cov_1.613139_g40189_i0 | PRJNA608660 | 40546 | 186 | 1.613139 | 3.00043854 | Totivirus nijyushichi | 3432964 | Viruses | Viruses | 344 | 2.34e-90 | NTclustered | gi|1895833611|gb|MN812428.1| | 2766745 | g40189 | i0 | 100 | 1 | 186 | 0 | 100 | 0 | 1 | 186 | 3353 | 3168 | Malassezia sympodialis mycovirus isolate MsMV1, complete genome | blastn | 186 | 344 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus nijyushichi | ||
| 6963174 | 6963174 | PRJNA608660_P_NODE_546_length_1329_cov_3.231250_g455_i0 | PRJNA608660 | 546 | 1329 | 3.23125 | 42.9433125 | Malassezia restricta virus MrV40S | 2727864 | Viruses | Viruses | 156 | 1.0099999999999999e-32 | NTclustered | gi|1832308146|gb|MN603498.1| | 2727864 | g455 | i0 | 72.64 | 0.940556809631302 | 625 | 115 | 90 | 44 | 734 | 1329 | 109 | 706 | Malassezia restricta virus MrV40S, complete genome | blastn | 1250 | 156 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40S | |||
| 12064121 | 12064121 | PRJNA608660_P_NODE_35870_length_205_cov_1.666667_g35514_i0 | PRJNA608660 | 35870 | 205 | 1.666667 | 3.41666735 | Totivirus nijyushichi | 3432964 | Viruses | Viruses | 331 | 2.0500000000000006e-86 | NTclustered | gi|1895833611|gb|MN812428.1| | 2766745 | g35514 | i0 | 99.451 | 1.02439024390244 | 182 | 1 | 100 | 0 | 24 | 205 | 2934 | 3115 | Malassezia sympodialis mycovirus isolate MsMV1, complete genome | blastn | 210 | 331 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus nijyushichi | ||
| 13338856 | 13338856 | PRJNA608660_P_NODE_3491_length_746_cov_4.939742_g3238_i0 | PRJNA608660 | 3491 | 746 | 4.939742 | 36.85047532 | Malassezia restricta associated totivirus 2 | 3048758 | Viruses | Viruses | 1094 | 0 | NTclustered | gi|2512878154|emb|OX637980.1| | 3048758 | g3238 | i0 | 94.274 | 4.23324396782842 | 716 | 40 | 96 | 1 | 10 | 724 | 814 | 99 | Malassezia restricta associated totivirus 2 CP gene for capsid protein | blastn | 3158 | 1094 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta associated totivirus 2 | ||
| 13338943 | 13338943 | PRJNA608660_P_NODE_44911_length_171_cov_1.278689_g44554_i0 | PRJNA608660 | 44911 | 171 | 1.278689 | 2.18655819 | Totivirus nijyushichi | 3432964 | Viruses | Viruses | 303 | 3.58e-78 | NTclustered | gi|1895833615|gb|MN831678.1| | 2766745 | g44554 | i0 | 99.405 | 0.982456140350877 | 168 | 0 | 98 | 1 | 5 | 171 | 347 | 180 | Malassezia sympodialis mycovirus isolate MsMV1 hypothetical protein gene, complete cds | blastn | 168 | 303 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus nijyushichi | ||
| 13338959 | 13338959 | PRJNA608660_P_NODE_4651_length_669_cov_2.625806_g4359_i0 | PRJNA608660 | 4651 | 669 | 2.625806 | 17.56664214 | Totivirus sp. | 2776824 | Viruses | Viruses | 370 | 1.6200000000000002e-97 | NTclustered | gi|1918615619|gb|MT949668.1| | 2776824 | g4359 | i0 | 80.672 | 0.711509715994021 | 476 | 92 | 71 | 0 | 132 | 607 | 476 | 1 | Totivirus sp. isolate sequence_10295 genomic sequence | blastn | 476 | 370 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus sp. | ||
| 15887791 | 15887791 | PRJNA608660_P_NODE_6913_length_565_cov_2.575581_g6586_i0 | PRJNA608660 | 6913 | 565 | 2.575581 | 14.55203265 | Malassezia restricta associated totivirus 1 | 3048757 | Viruses | Viruses | 241 | 1.11e-58 | NTclustered | gi|2512878151|emb|OX637978.1| | 3048757 | g6586 | i0 | 75.097 | 0.909734513274336 | 514 | 128 | 91 | 0 | 43 | 556 | 805 | 292 | Malassezia restricta associated totivirus 1 CP gene for capsid protein | blastn | 514 | 241 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta associated totivirus 1 | ||
| 18436660 | 18436660 | PRJNA608660_P_NODE_2215_length_875_cov_15.960048_g1490_i1 | PRJNA608660 | 2215 | 875 | 15.960048 | 139.65042 | Chemarfal virus 260 | 3063286 | Viruses | Viruses | 856 | 0 | NTclustered | gi|2626079958|gb|OR270550.1| | 3063286 | g1490 | i1 | 95.677 | 0.980571428571429 | 532 | 23 | 61 | 0 | 327 | 858 | 1 | 532 | MAG: Chemarfal virus 260 isolate ML188 genomic sequence | blastn | 858 | 856 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chemarfal virus 260 | ||||
| 20986898 | 20986898 | PRJNA608660_P_NODE_17197_length_348_cov_2.896321_g16842_i0 | PRJNA608660 | 17197 | 348 | 2.896321 | 10.07919708 | Totivirus nijyushichi | 3432964 | Viruses | Viruses | 638 | 1.99e-178 | NTclustered | gi|1895833615|gb|MN831678.1| | 2766745 | g16842 | i0 | 99.713 | 1 | 348 | 1 | 100 | 0 | 1 | 348 | 1449 | 1102 | Malassezia sympodialis mycovirus isolate MsMV1 hypothetical protein gene, complete cds | blastn | 348 | 638 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus nijyushichi | ||
| 22261611 | 22261611 | PRJNA608660_P_NODE_12318_length_423_cov_2.879679_g11971_i0 | PRJNA608660 | 12318 | 423 | 2.879679 | 12.18104217 | Totivirus nijyushichi | 3432964 | Viruses | Viruses | 776 | 0 | NTclustered | gi|1895833615|gb|MN831678.1| | 2766745 | g11971 | i0 | 99.764 | 1 | 423 | 1 | 100 | 0 | 1 | 423 | 1083 | 661 | Malassezia sympodialis mycovirus isolate MsMV1 hypothetical protein gene, complete cds | blastn | 423 | 776 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus nijyushichi | ||
| 22262022 | 22262022 | PRJNA608660_P_NODE_8138_length_523_cov_2.955696_g7803_i0 | PRJNA608660 | 8138 | 523 | 2.955696 | 15.45829008 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 839 | 0 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g7803 | i0 | 98.129 | 1.74760994263862 | 481 | 9 | 99 | 0 | 37 | 517 | 3349 | 2869 | Malassezia restricta virus MrV40L, complete genome | blastn | 914 | 839 | 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);;