contig_metadata
23 rows where analysis = "blastn", bioproject = "PRJNA293022" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2923966 | 2923966 | PRJNA293022_P_NODE_4403_length_663_cov_3.822476_g3768_i0 | PRJNA293022 | 4403 | 663 | 3.822476 | 25.34301588 | Malassezia restricta associated totivirus 1 | 3048757 | Viruses | Viruses | 1040 | 0 | NTclustered | gi|2512878152|emb|OX637979.1| | 3048757 | g3768 | i0 | 95.144 | 1.98793363499246 | 659 | 32 | 99 | 0 | 3 | 661 | 1020 | 362 | Malassezia restricta associated totivirus 1 polyprotein gene for polyprotein | blastn | 1318 | 1040 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta associated totivirus 1 | ||
| 4200632 | 4200632 | PRJNA293022_P_NODE_784_length_1331_cov_3.756630_g545_i0 | PRJNA293022 | 784 | 1331 | 3.75663 | 50.0007453 | Chemarfal virus 260 | 3063286 | Viruses | Viruses | 1646 | 0 | NTclustered | gi|2626079958|gb|OR270550.1| | 3063286 | g545 | i0 | 96.044 | 3.65138993238167 | 1011 | 40 | 76 | 0 | 2 | 1012 | 421 | 1431 | MAG: Chemarfal virus 260 isolate ML188 genomic sequence | blastn | 4860 | 1646 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chemarfal virus 260 | ||||
| 4200654 | 4200654 | PRJNA293022_P_NODE_9544_length_464_cov_1.395181_g8812_i0 | PRJNA293022 | 9544 | 464 | 1.395181 | 6.47363984 | Malassezia restricta virus MrV40S | 2727864 | Viruses | Viruses | 424 | 8.29e-114 | NTclustered | gi|1832308146|gb|MN603498.1| | 2727864 | g8812 | i0 | 83.801 | 0.997844827586207 | 463 | 58 | 98 | 15 | 2 | 456 | 913 | 460 | Malassezia restricta virus MrV40S, complete genome | blastn | 463 | 424 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40S | |||
| 5476622 | 5476622 | PRJNA293022_P_NODE_1005_length_1197_cov_2.593206_g724_i0 | PRJNA293022 | 1005 | 1197 | 2.593206 | 31.04067582 | Malassezia restricta associated totivirus 1 | 3048757 | Viruses | Viruses | 1803 | 0 | NTclustered | gi|2512878152|emb|OX637979.1| | 3048757 | g724 | i0 | 93.891 | 1.30492898913952 | 1195 | 73 | 99 | 0 | 1 | 1195 | 1987 | 793 | Malassezia restricta associated totivirus 1 polyprotein gene for polyprotein | blastn | 1562 | 1803 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta associated totivirus 1 | ||
| 5476835 | 5476835 | PRJNA293022_P_NODE_58505_length_182_cov_1.157895_g57768_i0 | PRJNA293022 | 58505 | 182 | 1.157895 | 2.1073689 | Malassezia restricta associated totivirus 1 | 3048757 | Viruses | Viruses | 315 | 1.79e-81 | NTclustered | gi|2512878151|emb|OX637978.1| | 3048757 | g57768 | i0 | 97.802 | 2 | 182 | 4 | 100 | 0 | 1 | 182 | 1204 | 1023 | Malassezia restricta associated totivirus 1 CP gene for capsid protein | blastn | 364 | 315 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta associated totivirus 1 | ||
| 6750929 | 6750929 | PRJNA293022_P_NODE_35606_length_234_cov_1.945946_g34869_i0 | PRJNA293022 | 35606 | 234 | 1.945946 | 4.55351364 | Totivirus ichi | 3432942 | Viruses | Viruses | 379 | 8.459999999999999e-101 | NTclustered | gi|556414|gb|M28353.1|SCSL1A | 11008 | g34869 | i0 | 98.157 | 2.78205128205128 | 217 | 4 | 93 | 0 | 16 | 232 | 1831 | 1615 | Saccharomyces cerevisiae virus L-A L1 segment capsid protein and RNA polymerase gene, complete cds | blastn | 651 | 379 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus ichi | ||
| 8026527 | 8026527 | PRJNA293022_P_NODE_23487_length_292_cov_2.625514_g22750_i0 | PRJNA293022 | 23487 | 292 | 2.625514 | 7.66650088 | Malassezia restricta associated totivirus 1 | 3048757 | Viruses | Viruses | 460 | 3.789999999999999e-125 | NTclustered | gi|2512878151|emb|OX637978.1| | 3048757 | g22750 | i0 | 95.486 | 1.97260273972603 | 288 | 13 | 99 | 0 | 3 | 290 | 1541 | 1254 | Malassezia restricta associated totivirus 1 CP gene for capsid protein | blastn | 576 | 460 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta associated totivirus 1 | ||
| 10577263 | 10577263 | PRJNA293022_P_NODE_49569_length_198_cov_1.375839_g48832_i0 | PRJNA293022 | 49569 | 198 | 1.375839 | 2.72416122 | Totivirus ni | 3432954 | Viruses | Viruses | 361 | 2.51e-95 | NTclustered | gi|9627980|ref|NC_001641.1| | 42478 | g48832 | i0 | 99.495 | 2.98989898989899 | 198 | 1 | 100 | 0 | 1 | 198 | 1501 | 1698 | Saccharomyces cerevisiae virus L-BC (La), complete genome | blastn | 592 | 361 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus ni | ||
| 11852012 | 11852012 | PRJNA293022_P_NODE_57110_length_184_cov_1.837037_g56373_i0 | PRJNA293022 | 57110 | 184 | 1.837037 | 3.38014808 | Malassezia restricta associated totivirus 1 | 3048757 | Viruses | Viruses | 241 | 3.12e-59 | NTclustered | gi|2512878151|emb|OX637978.1| | 3048757 | g56373 | i0 | 91.011 | 0.967391304347826 | 178 | 16 | 97 | 0 | 6 | 183 | 272 | 95 | Malassezia restricta associated totivirus 1 CP gene for capsid protein | blastn | 178 | 241 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta associated totivirus 1 | ||
| 13126997 | 13126997 | PRJNA293022_P_NODE_15911_length_358_cov_1.326861_g15174_i0 | PRJNA293022 | 15911 | 358 | 1.326861 | 4.75016238 | Totivirus ni | 3432954 | Viruses | Viruses | 652 | 0 | NTclustered | gi|9627980|ref|NC_001641.1| | 42478 | g15174 | i0 | 99.719 | 2.98324022346369 | 356 | 1 | 99 | 0 | 1 | 356 | 1077 | 722 | Saccharomyces cerevisiae virus L-BC (La), complete genome | blastn | 1068 | 652 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus ni | ||
| 14402251 | 14402251 | PRJNA293022_P_NODE_49532_length_198_cov_1.382550_g48795_i0 | PRJNA293022 | 49532 | 198 | 1.38255 | 2.737449 | Malassezia restricta associated totivirus 1 | 3048757 | Viruses | Viruses | 307 | 3.32e-79 | NTclustered | gi|2512878151|emb|OX637978.1| | 3048757 | g48795 | i0 | 94.898 | 0.98989898989899 | 196 | 10 | 99 | 0 | 1 | 196 | 1027 | 832 | Malassezia restricta associated totivirus 1 CP gene for capsid protein | blastn | 196 | 307 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta associated totivirus 1 | ||
| 14402319 | 14402319 | PRJNA293022_P_NODE_6532_length_557_cov_1.726378_g5825_i0 | PRJNA293022 | 6532 | 557 | 1.726378 | 9.61592546 | Totivirus ichi | 3432942 | Viruses | Viruses | 989 | 0 | NTclustered | gi|558066|gb|J04692.1|SCSCOATRNA | 11008 | g5825 | i0 | 98.915 | 5.35368043087971 | 553 | 6 | 99 | 0 | 3 | 555 | 3121 | 3673 | Saccharomyces cerevisiae virus L-A major coat protein, ssRNA-binding protein, and RNA polymerase genes, complete cds | blastn | 2982 | 989 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus ichi | ||
| 15676017 | 15676017 | PRJNA293022_P_NODE_373_length_1711_cov_2.557160_g229_i0 | PRJNA293022 | 373 | 1711 | 2.55716 | 43.7530076 | Totivirus sp. | 2776824 | Viruses | Viruses | 2375 | 0 | NTclustered | gi|1918615616|gb|MT949667.1| | 2776824 | g229 | i0 | 94.376 | 1.89012273524255 | 1547 | 87 | 90 | 0 | 3 | 1549 | 1547 | 1 | Totivirus sp. isolate sequence_5835 genomic sequence | blastn | 3234 | 2375 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus sp. | ||
| 16950755 | 16950755 | PRJNA293022_P_NODE_60674_length_178_cov_2.348837_g59937_i0 | PRJNA293022 | 60674 | 178 | 2.348837 | 4.18092986 | Totivirus ni | 3432954 | Viruses | Viruses | 313 | 6.259999999999999e-81 | NTclustered | gi|9627980|ref|NC_001641.1| | 42478 | g59937 | i0 | 98.315 | 2 | 178 | 3 | 100 | 0 | 1 | 178 | 1523 | 1346 | Saccharomyces cerevisiae virus L-BC (La), complete genome | blastn | 356 | 313 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus ni | ||
| 18225054 | 18225054 | PRJNA293022_P_NODE_60155_length_179_cov_1.676923_g59418_i0 | PRJNA293022 | 60155 | 179 | 1.676923 | 3.00169217 | Malassezia restricta associated totivirus 1 | 3048757 | Viruses | Viruses | 270 | 3.849999999999999e-68 | NTclustered | gi|2512878151|emb|OX637978.1| | 3048757 | g59418 | i0 | 93.855 | 2 | 179 | 11 | 100 | 0 | 1 | 179 | 1720 | 1542 | Malassezia restricta associated totivirus 1 CP gene for capsid protein | blastn | 358 | 270 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta associated totivirus 1 | ||
| 20774879 | 20774879 | PRJNA293022_P_NODE_67977_length_169_cov_0.866667_g67240_i0 | PRJNA293022 | 67977 | 169 | 0.866667 | 1.46466723 | Luoyang Totiv tick virus 3 | 2972362 | Viruses | Viruses | 189 | 1.0299999999999998e-43 | NTclustered | gi|2320153259|gb|ON746560.1| | 2972362 | g67240 | i0 | 87.273 | 0.976331360946746 | 165 | 21 | 98 | 0 | 1 | 165 | 3185 | 3021 | MAG: Luoyang Totiv tick virus 3 isolate TIGMIC 2 genomic sequence | blastn | 165 | 189 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Luoyang Totiv tick virus 3 | |||
| 22049682 | 22049682 | PRJNA293022_P_NODE_32658_length_245_cov_1.428571_g31921_i0 | PRJNA293022 | 32658 | 245 | 1.428571 | 3.49999895 | Malassezia restricta virus MrV40S | 2727864 | Viruses | Viruses | 291 | 4.3000000000000005e-74 | NTclustered | gi|1832308146|gb|MN603498.1| | 2727864 | g31921 | i0 | 95.58 | 0.738775510204082 | 181 | 8 | 74 | 0 | 63 | 243 | 1103 | 923 | Malassezia restricta virus MrV40S, complete genome | blastn | 181 | 291 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40S | |||
| 22049715 | 22049715 | PRJNA293022_P_NODE_38_length_3215_cov_4.786481_g18_i0 | PRJNA293022 | 38 | 3215 | 4.786481 | 153.88536415 | Chemarfal virus 258 | 3063149 | Viruses | Viruses | 3659 | 0 | NTclustered | gi|2626079799|gb|OR270470.1| | 3063149 | g18 | i0 | 96.479 | 4.36920684292379 | 2215 | 78 | 69 | 0 | 618 | 2832 | 1 | 2215 | MAG: Chemarfal virus 258 isolate ML188 genomic sequence | blastn | 14047 | 3659 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chemarfal virus 258 | ||||
| 22049928 | 22049928 | PRJNA293022_P_NODE_7338_length_527_cov_4.322176_g6619_i0 | PRJNA293022 | 7338 | 527 | 4.322176 | 22.77786752 | Malassezia restricta associated totivirus 1 | 3048757 | Viruses | Viruses | 671 | 0 | NTclustered | gi|2512878151|emb|OX637978.1| | 3048757 | g6619 | i0 | 89.714 | 0.996204933586338 | 525 | 54 | 99 | 0 | 1 | 525 | 776 | 252 | Malassezia restricta associated totivirus 1 CP gene for capsid protein | blastn | 525 | 671 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta associated totivirus 1 | ||
| 23325230 | 23325230 | PRJNA293022_P_NODE_16979_length_346_cov_2.976431_g16242_i0 | PRJNA293022 | 16979 | 346 | 2.976431 | 10.29845126 | Malassezia restricta associated totivirus 1 | 3048757 | Viruses | Viruses | 368 | 2.86e-97 | NTclustered | gi|2512878151|emb|OX637978.1| | 3048757 | g16242 | i0 | 95.633 | 0.661849710982659 | 229 | 10 | 66 | 0 | 3 | 231 | 229 | 1 | Malassezia restricta associated totivirus 1 CP gene for capsid protein | blastn | 229 | 368 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta associated totivirus 1 | ||
| 24599360 | 24599360 | PRJNA293022_P_NODE_35680_length_234_cov_1.378378_g34943_i0 | PRJNA293022 | 35680 | 234 | 1.378378 | 3.22540452 | Totivirus ni | 3432954 | Viruses | Viruses | 409 | 1.08e-109 | NTclustered | gi|9627980|ref|NC_001641.1| | 42478 | g34943 | i0 | 98.696 | 0.982905982905983 | 230 | 3 | 98 | 0 | 3 | 232 | 3583 | 3354 | Saccharomyces cerevisiae virus L-BC (La), complete genome | blastn | 230 | 409 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus ni | ||
| 24599377 | 24599377 | PRJNA293022_P_NODE_40180_length_220_cov_2.192982_g39443_i0 | PRJNA293022 | 40180 | 220 | 2.192982 | 4.8245604 | Malassezia restricta associated totivirus 1 | 3048757 | Viruses | Viruses | 351 | 1.72e-92 | NTclustered | gi|2512878151|emb|OX637978.1| | 3048757 | g39443 | i0 | 96.262 | 0.972727272727273 | 214 | 8 | 97 | 0 | 3 | 216 | 526 | 313 | Malassezia restricta associated totivirus 1 CP gene for capsid protein | blastn | 214 | 351 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta associated totivirus 1 | ||
| 24599499 | 24599499 | PRJNA293022_P_NODE_67780_length_169_cov_0.866667_g67043_i0 | PRJNA293022 | 67780 | 169 | 0.866667 | 1.46466723 | Totivirus ni | 3432954 | Viruses | Viruses | 307 | 2.73e-79 | NTclustered | gi|9627980|ref|NC_001641.1| | 42478 | g67043 | i0 | 99.408 | 1 | 169 | 1 | 100 | 0 | 1 | 169 | 3097 | 3265 | Saccharomyces cerevisiae virus L-BC (La), complete genome | blastn | 169 | 307 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus ni |
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);;