contig_metadata
29 rows where analysis = "blastn", bioproject = "PRJNA556992" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 529695 | 529695 | PRJNA556992_P_NODE_518341_length_265_cov_4.791667_g516152_i0 | PRJNA556992 | 518341 | 265 | 4.791667 | 12.69791755 | Chrocurosk virus | 3129322 | Viruses | Viruses | 263 | 1.03e-65 | NTclustered | gi|2717317280|gb|PP171770.1| | 3129322 | g516152 | i0 | 86.864 | 153.539622641509 | 236 | 30 | 89 | 1 | 4 | 239 | 1662 | 1896 | MAG: Chrocurosk virus isolate CC1A_k141_129357 genomic sequence | blastn | 40688 | 263 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Chrocurosk virus | |||
| 4357995 | 4357995 | PRJNA556992_P_NODE_599204_length_259_cov_1.618280_g597015_i0 | PRJNA556992 | 599204 | 259 | 1.61828 | 4.1913452 | Diaphorina citri reovirus | 557218 | Viruses | Viruses | 52.8 | 0.024 | NTclustered | gi|1864114105|gb|MT027150.1| | 557218 | g597015 | i0 | 100 | 0.216216216216216 | 28 | 0 | 11 | 0 | 77 | 104 | 116 | 89 | Diaphorina citri reovirus isolate Hawaii segment 7, complete sequence | blastn | 56 | 52.8 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Diaphorina citri reovirus | ||||
| 4359031 | 4359031 | PRJNA556992_P_NODE_685524_length_252_cov_2.027933_g683335_i0 | PRJNA556992 | 685524 | 252 | 2.027933 | 5.11039116 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 440 | 4.1699999999999984e-119 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g683335 | i0 | 98.4 | 1.38888888888889 | 250 | 4 | 99 | 0 | 3 | 252 | 3057 | 2808 | Malassezia restricta virus MrV40L, complete genome | blastn | 350 | 440 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 4361895 | 4361895 | PRJNA556992_P_NODE_90624_length_417_cov_5.674419_g88441_i0 | PRJNA556992 | 90624 | 417 | 5.674419 | 23.66232723 | Betacystovirus phi12 | 3427160 | Viruses | Viruses | 693 | 0 | NTclustered | gi|22855221|ref|NC_004175.1| | 161736 | g88441 | i0 | 96.643 | 1 | 417 | 14 | 100 | 0 | 1 | 417 | 2622 | 2206 | Pseudomonas phage phi12 segment M, complete sequence | blastn | 417 | 693 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Betacystovirus | Betacystovirus phi12 | ||
| 5631192 | 5631192 | PRJNA556992_P_NODE_33145_length_604_cov_1.406780_g31031_i0 | PRJNA556992 | 33145 | 604 | 1.40678 | 8.4969512 | Malassezia restricta associated totivirus 2 | 3048758 | Viruses | Viruses | 902 | 0 | NTclustered | gi|2512878154|emb|OX637980.1| | 3048758 | g31031 | i0 | 93.833 | 4.16390728476821 | 600 | 35 | 99 | 2 | 6 | 604 | 764 | 166 | Malassezia restricta associated totivirus 2 CP gene for capsid protein | blastn | 2515 | 902 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta associated totivirus 2 | ||
| 5633360 | 5633360 | PRJNA556992_P_NODE_49785_length_513_cov_12.302273_g47625_i0 | PRJNA556992 | 49785 | 513 | 12.302273 | 63.11066049 | Betacystovirus phi12 | 3427160 | Viruses | Viruses | 510 | 6.8899999999999995e-140 | NTclustered | gi|22855209|ref|NC_004173.1| | 161736 | g47625 | i0 | 84.921 | 0.982456140350877 | 504 | 76 | 98 | 0 | 2 | 505 | 1843 | 1340 | Pseudomonas phage phi12 segment L, complete sequence | blastn | 504 | 510 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Betacystovirus | Betacystovirus phi12 | ||
| 6900372 | 6900372 | PRJNA556992_P_NODE_105566_length_398_cov_6.249231_g103382_i0 | PRJNA556992 | 105566 | 398 | 6.249231 | 24.87193938 | Betacystovirus phi12 | 3427160 | Viruses | Viruses | 719 | 0 | NTclustered | gi|22855216|ref|NC_004174.1| | 161736 | g103382 | i0 | 99.246 | 1 | 398 | 3 | 100 | 0 | 1 | 398 | 623 | 1020 | Pseudomonas phage phi12 segment S, complete sequence | blastn | 398 | 719 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Betacystovirus | Betacystovirus phi12 | ||
| 6912091 | 6912091 | PRJNA556992_P_NODE_873106_length_242_cov_1.763314_g870916_i0 | PRJNA556992 | 873106 | 242 | 1.763314 | 4.26721988 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 418 | 1.8699999999999998e-112 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g870916 | i0 | 97.925 | 0.995867768595041 | 241 | 5 | 99 | 0 | 2 | 242 | 1275 | 1035 | Malassezia restricta virus MrV40L, complete genome | blastn | 241 | 418 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 8183719 | 8183719 | PRJNA556992_P_NODE_61227_length_475_cov_12.208955_g59058_i0 | PRJNA556992 | 61227 | 475 | 12.208955 | 57.99253625 | Betacystovirus phi12 | 3427160 | Viruses | Viruses | 717 | 0 | NTclustered | gi|22855221|ref|NC_004175.1| | 161736 | g59058 | i0 | 93.895 | 1 | 475 | 29 | 100 | 0 | 1 | 475 | 3983 | 3509 | Pseudomonas phage phi12 segment M, complete sequence | blastn | 475 | 717 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Betacystovirus | Betacystovirus phi12 | ||
| 9462810 | 9462810 | PRJNA556992_P_NODE_88168_length_421_cov_2.376437_g85986_i0 | PRJNA556992 | 88168 | 421 | 2.376437 | 10.00479977 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 750 | 0 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g85986 | i0 | 98.815 | 1.00237529691211 | 422 | 3 | 100 | 2 | 1 | 421 | 1491 | 1911 | Malassezia restricta virus MrV40L, complete genome | blastn | 422 | 750 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 10737434 | 10737434 | PRJNA556992_P_NODE_804889_length_245_cov_9.215116_g802699_i0 | PRJNA556992 | 804889 | 245 | 9.215116 | 22.5770342 | Betacystovirus phi12 | 3427160 | Viruses | Viruses | 453 | 5.1900000000000006e-123 | NTclustered | gi|22855216|ref|NC_004174.1| | 161736 | g802699 | i0 | 100 | 1 | 245 | 0 | 100 | 0 | 1 | 245 | 19 | 263 | Pseudomonas phage phi12 segment S, complete sequence | blastn | 245 | 453 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Betacystovirus | Betacystovirus phi12 | ||
| 12003131 | 12003131 | PRJNA556992_P_NODE_12990_length_929_cov_1.650701_g11332_i0 | PRJNA556992 | 12990 | 929 | 1.650701 | 15.33501229 | Chemarfal virus 258 | 3063149 | Viruses | Viruses | 1500 | 0 | NTclustered | gi|2626079799|gb|OR270470.1| | 3063149 | g11332 | i0 | 95.802 | 2 | 929 | 39 | 100 | 0 | 1 | 929 | 261 | 1189 | MAG: Chemarfal virus 258 isolate ML188 genomic sequence | blastn | 1858 | 1500 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chemarfal virus 258 | ||||
| 12007081 | 12007081 | PRJNA556992_P_NODE_393350_length_277_cov_2.210784_g391161_i0 | PRJNA556992 | 393350 | 277 | 2.210784 | 6.12387168 | Bat rotavirus | 1340801 | Viruses | Viruses | 52.8 | 0.025 | NTclustered | gi|1988244386|gb|MT815964.1| | 1340801 | g391161 | i0 | 100 | 0.202166064981949 | 28 | 0 | 10 | 0 | 146 | 173 | 338 | 311 | Bat rotavirus isolate BatRVH/Bat-wt/CH/Myo_dau/2019 VP2 (VP2) gene, complete cds | blastn | 56 | 52.8 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Sedoreoviridae | Rotavirus | Bat rotavirus | ||
| 13278282 | 13278282 | PRJNA556992_P_NODE_133251_length_371_cov_3.281879_g131064_i0 | PRJNA556992 | 133251 | 371 | 3.281879 | 12.17577109 | Betacystovirus phi12 | 3427160 | Viruses | Viruses | 603 | 7.769999999999997e-168 | NTclustered | gi|22855221|ref|NC_004175.1| | 161736 | g131064 | i0 | 95.957 | 1 | 371 | 15 | 100 | 0 | 1 | 371 | 1809 | 2179 | Pseudomonas phage phi12 segment M, complete sequence | blastn | 371 | 603 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Betacystovirus | Betacystovirus phi12 | ||
| 13286521 | 13286521 | PRJNA556992_P_NODE_742831_length_249_cov_0.875000_g740642_i0 | PRJNA556992 | 742831 | 249 | 0.875 | 2.17875 | Reoviridae sp. | 2585267 | Viruses | Viruses | 137 | 6.0499999999999996e-28 | NTclustered | gi|2171145380|gb|MZ218366.1| | 2585267 | g740642 | i0 | 78.189 | 30.4096385542169 | 243 | 33 | 92 | 13 | 2 | 229 | 43 | 280 | MAG: Reoviridae sp. isolate R66-k141_282067 segment 2 genomic sequence | blastn | 7572 | 137 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Reoviridae sp. | ||||
| 14555123 | 14555123 | PRJNA556992_P_NODE_251372_length_304_cov_3.203463_g249183_i0 | PRJNA556992 | 251372 | 304 | 3.203463 | 9.73852752 | Betacystovirus phi12 | 3427160 | Viruses | Viruses | 562 | 1.06e-155 | NTclustered | gi|22855216|ref|NC_004174.1| | 161736 | g249183 | i0 | 100 | 1 | 304 | 0 | 100 | 0 | 1 | 304 | 1026 | 1329 | Pseudomonas phage phi12 segment S, complete sequence | blastn | 304 | 562 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Betacystovirus | Betacystovirus phi12 | ||
| 14561736 | 14561736 | PRJNA556992_P_NODE_76712_length_440_cov_5.209809_g74535_i0 | PRJNA556992 | 76712 | 440 | 5.209809 | 22.9231596 | Betacystovirus phi12 | 3427160 | Viruses | Viruses | 780 | 0 | NTclustered | gi|22855216|ref|NC_004174.1| | 161736 | g74535 | i0 | 98.636 | 1 | 440 | 6 | 100 | 0 | 1 | 440 | 2298 | 1859 | Pseudomonas phage phi12 segment S, complete sequence | blastn | 440 | 780 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Betacystovirus | Betacystovirus phi12 | ||
| 14562830 | 14562830 | PRJNA556992_P_NODE_854992_length_243_cov_1.570588_g852802_i0 | PRJNA556992 | 854992 | 243 | 1.570588 | 3.81652884 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 427 | 3.11e-115 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g852802 | i0 | 98.354 | 1 | 243 | 4 | 100 | 0 | 1 | 243 | 4293 | 4051 | Malassezia restricta virus MrV40L, complete genome | blastn | 243 | 427 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 15829139 | 15829139 | PRJNA556992_P_NODE_26513_length_665_cov_2.788851_g24457_i0 | PRJNA556992 | 26513 | 665 | 2.788851 | 18.54585915 | Betacystovirus phi12 | 3427160 | Viruses | Viruses | 604 | 4.0499999999999986e-168 | NTclustered | gi|22855209|ref|NC_004173.1| | 161736 | g24457 | i0 | 83.107 | 0.996992481203008 | 663 | 112 | 99 | 0 | 3 | 665 | 5424 | 6086 | Pseudomonas phage phi12 segment L, complete sequence | blastn | 663 | 604 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Betacystovirus | Betacystovirus phi12 | ||
| 15831369 | 15831369 | PRJNA556992_P_NODE_42313_length_547_cov_2.978903_g40165_i0 | PRJNA556992 | 42313 | 547 | 2.978903 | 16.29459941 | Betacystovirus phi12 | 3427160 | Viruses | Viruses | 468 | 4.51e-127 | NTclustered | gi|22855209|ref|NC_004173.1| | 161736 | g40165 | i0 | 82.519 | 0.972577696526508 | 532 | 93 | 97 | 0 | 16 | 547 | 2021 | 2552 | Pseudomonas phage phi12 segment L, complete sequence | blastn | 532 | 468 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Betacystovirus | Betacystovirus phi12 | ||
| 18374133 | 18374133 | PRJNA556992_P_NODE_1048735_length_225_cov_4.901316_g1046545_i0 | PRJNA556992 | 1048735 | 225 | 4.901316 | 11.027961 | Betacystovirus phi12 | 3427160 | Viruses | Viruses | 206 | 1.4499999999999998e-48 | NTclustered | gi|22855209|ref|NC_004173.1| | 161736 | g1046545 | i0 | 83.871 | 0.964444444444444 | 217 | 34 | 96 | 1 | 5 | 221 | 6203 | 6418 | Pseudomonas phage phi12 segment L, complete sequence | blastn | 217 | 206 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Betacystovirus | Betacystovirus phi12 | ||
| 19649450 | 19649450 | PRJNA556992_P_NODE_1106416_length_211_cov_5.297101_g1104225_i0 | PRJNA556992 | 1106416 | 211 | 5.297101 | 11.17688311 | Betacystovirus phi12 | 3427160 | Viruses | Viruses | 333 | 5.91e-87 | NTclustered | gi|22855221|ref|NC_004175.1| | 161736 | g1104225 | i0 | 95.238 | 0.995260663507109 | 210 | 10 | 99 | 0 | 2 | 211 | 969 | 760 | Pseudomonas phage phi12 segment M, complete sequence | blastn | 210 | 333 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Betacystovirus | Betacystovirus phi12 | ||
| 19651560 | 19651560 | PRJNA556992_P_NODE_189916_length_333_cov_1.180769_g187728_i0 | PRJNA556992 | 189916 | 333 | 1.180769 | 3.93196077 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 599 | 8.94e-167 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g187728 | i0 | 99.099 | 1.93093093093093 | 333 | 3 | 100 | 0 | 1 | 333 | 3457 | 3125 | Malassezia restricta virus MrV40L, complete genome | blastn | 643 | 599 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 19659612 | 19659612 | PRJNA556992_P_NODE_806496_length_245_cov_4.755814_g804306_i0 | PRJNA556992 | 806496 | 245 | 4.755814 | 11.6517443 | Betacystovirus phi12 | 3427160 | Viruses | Viruses | 235 | 2.05e-57 | NTclustered | gi|22855209|ref|NC_004173.1| | 161736 | g804306 | i0 | 84.232 | 0.983673469387755 | 241 | 38 | 98 | 0 | 5 | 245 | 1218 | 978 | Pseudomonas phage phi12 segment L, complete sequence | blastn | 241 | 235 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Betacystovirus | Betacystovirus phi12 | ||
| 19660560 | 19660560 | PRJNA556992_P_NODE_881616_length_241_cov_12.755952_g879426_i0 | PRJNA556992 | 881616 | 241 | 12.755952 | 30.74184432 | Betacystovirus phi12 | 3427160 | Viruses | Viruses | 435 | 1.84e-117 | NTclustered | gi|22855221|ref|NC_004175.1| | 161736 | g879426 | i0 | 99.17 | 1 | 241 | 2 | 100 | 0 | 1 | 241 | 131 | 371 | Pseudomonas phage phi12 segment M, complete sequence | blastn | 241 | 435 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Betacystovirus | Betacystovirus phi12 | ||
| 20932891 | 20932891 | PRJNA556992_P_NODE_611937_length_258_cov_1.594595_g609748_i0 | PRJNA556992 | 611937 | 258 | 1.594595 | 4.1140551 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 466 | 7.08e-127 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g609748 | i0 | 99.225 | 1 | 258 | 2 | 100 | 0 | 1 | 258 | 12 | 269 | Malassezia restricta virus MrV40L, complete genome | blastn | 258 | 466 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 22212240 | 22212240 | PRJNA556992_P_NODE_959438_length_234_cov_7.832298_g957248_i0 | PRJNA556992 | 959438 | 234 | 7.832298 | 18.32757732 | Betacystovirus phi12 | 3427160 | Viruses | Viruses | 340 | 3.989999999999999e-89 | NTclustered | gi|22855209|ref|NC_004173.1| | 161736 | g957248 | i0 | 93.45 | 0.978632478632479 | 229 | 15 | 98 | 0 | 1 | 229 | 49 | 277 | Pseudomonas phage phi12 segment L, complete sequence | blastn | 229 | 340 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Betacystovirus | Betacystovirus phi12 | ||
| 24750505 | 24750505 | PRJNA556992_P_NODE_133680_length_371_cov_1.818792_g131493_i0 | PRJNA556992 | 133680 | 371 | 1.818792 | 6.74771832 | Malassezia globosa associated totivirus 1 | 3048756 | Viruses | Viruses | 213 | 1.53e-50 | NTclustered | gi|2512878147|emb|OX637976.1| | 3048756 | g131493 | i0 | 79.73 | 0.797843665768194 | 296 | 59 | 80 | 1 | 76 | 370 | 1855 | 2150 | Malassezia globosa associated totivirus 1 RdRp gene for RNA-dependent RNA polymerase | blastn | 296 | 213 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia globosa associated totivirus 1 | ||
| 24750983 | 24750983 | PRJNA556992_P_NODE_16280_length_833_cov_10.802632_g14480_i0 | PRJNA556992 | 16280 | 833 | 10.802632 | 89.98592456 | Betacystovirus phi12 | 3427160 | Viruses | Viruses | 741 | 0 | NTclustered | gi|22855209|ref|NC_004173.1| | 161736 | g14480 | i0 | 82.83 | 0.992797118847539 | 827 | 142 | 99 | 0 | 1 | 827 | 2751 | 3577 | Pseudomonas phage phi12 segment L, complete sequence | blastn | 827 | 741 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Betacystovirus | Betacystovirus phi12 |
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);;