contig_metadata
22 rows where analysis = "blastn", bioproject = "PRJNA795983" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1216444 | 1216444 | PRJNA795983_S_NODE_921_length_972_cov_2.526140_g849_i0 | PRJNA795983 | 921 | 972 | 2.52614 | 24.5540808 | Paramyxoviridae | 11158 | Viruses | Viruses | 1746 | 0 | NTclustered | gi|2721617856|gb|PP711545.1| | 251774 | g849 | i0 | 99.074 | 85.7839506172839 | 972 | 9 | 100 | 0 | 1 | 972 | 930 | 1901 | Porcine parainfluenza virus isolate PPIV-DX-Gansu-2020, partial genome | blastn | 83382 | 1746 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Rubulavirus | Porcine parainfluenza virus | ||
| 2056121 | 2056121 | PRJNA795983_S_NODE_39582_length_245_cov_1.790698_g39457_i0 | PRJNA795983 | 39582 | 245 | 1.790698 | 4.3872101 | Shockervirus shocker | 3432426 | Viruses | Viruses | 69.4 | 2.2e-7 | NTclustered | gi|2487592915|ref|NC_073470.1| | 2805839 | g39457 | i0 | 95.455 | 0.359183673469388 | 44 | 1 | 18 | 1 | 192 | 235 | 429 | 471 | Microbacterium phage Shocker, complete genome | blastn | 88 | 69.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Shockervirus | Shockervirus shocker | ||||
| 2056165 | 2056165 | PRJNA795983_S_NODE_44042_length_232_cov_10.182390_g43917_i0 | PRJNA795983 | 44042 | 232 | 10.18239 | 23.6231448 | Mitovirus sp. | 2587224 | Viruses | Viruses | 106 | 1.57e-18 | NTclustered | gi|1698234317|gb|MN033515.1| | 2587224 | g43917 | i0 | 90.123 | 0.349137931034483 | 81 | 8 | 35 | 0 | 32 | 112 | 32 | 112 | MAG: Mitovirus sp. isolate H1_Rhizo_26_FD_scaffold_6751 sequence | blastn | 81 | 106 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Mitovirus sp. | ||
| 2491922 | 2491922 | PRJNA795983_S_NODE_24322_length_288_cov_1.074419_g24197_i0 | PRJNA795983 | 24322 | 288 | 1.074419 | 3.09432672 | Christensenvirus | 2732061 | Viruses | Viruses | 527 | 3.63e-145 | NTclustered | gi|1842038479|ref|NC_048208.1| | 2507711 | g24197 | i0 | 99.653 | 30.7881944444444 | 288 | 1 | 100 | 0 | 1 | 288 | 6480 | 6767 | Enterobacteria phage vB_EcoS_IME542, complete genome | blastn | 8867 | 532 | 0.990601503759398 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Drexlerviridae | Christensenvirus | Christensenvirus IME542 | |||
| 3331163 | 3331163 | PRJNA795983_S_NODE_23383_length_292_cov_1.031963_g23258_i0 | PRJNA795983 | 23383 | 292 | 1.031963 | 3.01333196 | Christensenvirus IME542 | 2734000 | Viruses | Viruses | 523 | 4.769999999999998e-144 | NTclustered | gi|1842038479|ref|NC_048208.1| | 2507711 | g23258 | i0 | 98.973 | 8.78767123287671 | 292 | 3 | 100 | 0 | 1 | 292 | 28047 | 28338 | Enterobacteria phage vB_EcoS_IME542, complete genome | blastn | 2566 | 523 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Drexlerviridae | Christensenvirus | Christensenvirus IME542 | |||
| 3331351 | 3331351 | PRJNA795983_S_NODE_42663_length_241_cov_1.714286_g42538_i0 | PRJNA795983 | 42663 | 241 | 1.714286 | 4.13142926 | Moumouvirus australiense | 3080759 | Viruses | Viruses | 106 | 1.64e-18 | NTclustered | gi|2500366567|ref|NC_075368.1| | 2109587 | g42538 | i0 | 83.478 | 3.01659751037344 | 115 | 17 | 49 | 2 | 9 | 122 | 256685 | 256572 | Moumouvirus australiensis isolate 10A, complete genome | blastn | 727 | 106 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Moumouvirus | Moumouvirus australiense | ||
| 7594636 | 7594636 | PRJNA795983_S_NODE_33666_length_256_cov_4.945355_g33541_i0 | PRJNA795983 | 33666 | 256 | 4.945355 | 12.6601088 | Orthorubulavirus | 2560195 | Viruses | Viruses | 462 | 9.07e-126 | NTclustered | gi|1378763606|gb|MF170889.1| | 2560580 | g33541 | i0 | 99.219 | 79.5625 | 256 | 2 | 100 | 0 | 1 | 256 | 2053 | 1798 | Mammalian orthorubulavirus 5 strain Rigel, complete genome | blastn | 20368 | 462 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 8433227 | 8433227 | PRJNA795983_S_NODE_29007_length_271_cov_1.398990_g28882_i0 | PRJNA795983 | 29007 | 271 | 1.39899 | 3.7912629 | Shockervirus shocker | 3432426 | Viruses | Viruses | 385 | 2.16e-102 | NTclustered | gi|2487592915|ref|NC_073470.1| | 2805839 | g28882 | i0 | 92.565 | 0.992619926199262 | 269 | 18 | 99 | 2 | 1 | 267 | 11472 | 11204 | Microbacterium phage Shocker, complete genome | blastn | 269 | 385 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Shockervirus | Shockervirus shocker | ||||
| 8869699 | 8869699 | PRJNA795983_S_NODE_307_length_1426_cov_3.017738_g280_i0 | PRJNA795983 | 307 | 1426 | 3.017738 | 43.03294388 | Orthorubulavirus | 2560195 | Viruses | Viruses | 2628 | 0 | NTclustered | gi|2449300967|gb|ON241249.1| | 2560580 | g280 | i0 | 99.93 | 97.9649368863955 | 1426 | 1 | 100 | 0 | 1 | 1426 | 4514 | 5939 | Mammalian orthorubulavirus 5 isolate ATCC HTB-55 batch no 70037771, complete genome | blastn | 139698 | 2628 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 8869718 | 8869718 | PRJNA795983_S_NODE_4847_length_507_cov_1.711982_g4723_i0 | PRJNA795983 | 4847 | 507 | 1.711982 | 8.67974874 | Orthorubulavirus | 2560195 | Viruses | Viruses | 937 | 0 | NTclustered | gi|2449300967|gb|ON241249.1| | 2560580 | g4723 | i0 | 100 | 82.1992110453649 | 507 | 0 | 100 | 0 | 1 | 507 | 7777 | 8283 | Mammalian orthorubulavirus 5 isolate ATCC HTB-55 batch no 70037771, complete genome | blastn | 41675 | 937 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 9708382 | 9708382 | PRJNA795983_S_NODE_34168_length_255_cov_1.686813_g34043_i0 | PRJNA795983 | 34168 | 255 | 1.686813 | 4.30137315 | uncultured phage | 278008 | Viruses | Viruses | 52.8 | 0.023 | NTclustered | gi|1804151423|emb|LR756500.1| | 278008 | g34043 | i0 | 100 | 0.109803921568627 | 28 | 0 | 11 | 0 | 173 | 200 | 432466 | 432493 | uncultured phage genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Viruses | uncultured phage | ||||||||
| 10144973 | 10144973 | PRJNA795983_S_NODE_1008_length_940_cov_2.068051_g932_i0 | PRJNA795983 | 1008 | 940 | 2.068051 | 19.4396794 | Paramyxoviridae | 11158 | Viruses | Viruses | 1714 | 0 | NTclustered | gi|2721617856|gb|PP711545.1| | 251774 | g932 | i0 | 99.574 | 84 | 940 | 4 | 100 | 0 | 1 | 940 | 5774 | 6713 | Porcine parainfluenza virus isolate PPIV-DX-Gansu-2020, partial genome | blastn | 78960 | 1731 | 0.990179087232813 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Rubulavirus | Porcine parainfluenza virus | ||
| 12259832 | 12259832 | PRJNA795983_S_NODE_9830_length_391_cov_1.210692_g9705_i0 | PRJNA795983 | 9830 | 391 | 1.210692 | 4.73380572 | Christensenvirus IME542 | 2734000 | Viruses | Viruses | 723 | 0 | NTclustered | gi|1842038479|ref|NC_048208.1| | 2507711 | g9705 | i0 | 100 | 35.8005115089514 | 391 | 0 | 100 | 0 | 1 | 391 | 7325 | 6935 | Enterobacteria phage vB_EcoS_IME542, complete genome | blastn | 13998 | 723 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Drexlerviridae | Christensenvirus | Christensenvirus IME542 | |||
| 13970437 | 13970437 | PRJNA795983_S_NODE_171_length_1662_cov_5.879169_g153_i0 | PRJNA795983 | 171 | 1662 | 5.879169 | 97.71178878 | Orthorubulavirus | 2560195 | Viruses | Viruses | 3042 | 0 | NTclustered | gi|2449300967|gb|ON241249.1| | 2560580 | g153 | i0 | 99.699 | 76.2809867629362 | 1662 | 5 | 100 | 0 | 1 | 1662 | 39 | 1700 | Mammalian orthorubulavirus 5 isolate ATCC HTB-55 batch no 70037771, complete genome | blastn | 126779 | 3059 | 0.994442628309905 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 13970452 | 13970452 | PRJNA795983_S_NODE_271_length_1472_cov_3.507505_g246_i0 | PRJNA795983 | 271 | 1472 | 3.507505 | 51.6304736 | Paramyxoviridae | 11158 | Viruses | Viruses | 2695 | 0 | NTclustered | gi|2721617856|gb|PP711545.1| | 251774 | g246 | i0 | 99.728 | 68.9538043478261 | 1471 | 4 | 99 | 0 | 1 | 1471 | 1969 | 3439 | Porcine parainfluenza virus isolate PPIV-DX-Gansu-2020, partial genome | blastn | 101500 | 2712 | 0.993731563421829 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Rubulavirus | Porcine parainfluenza virus | ||
| 13970475 | 13970475 | PRJNA795983_S_NODE_41091_length_243_cov_1.752941_g40966_i0 | PRJNA795983 | 41091 | 243 | 1.752941 | 4.25964663 | Christensenvirus | 2732061 | Viruses | Viruses | 449 | 6.65e-122 | NTclustered | gi|1842038479|ref|NC_048208.1| | 2507711 | g40966 | i0 | 100 | 22.9135802469136 | 243 | 0 | 100 | 0 | 1 | 243 | 41460 | 41702 | Enterobacteria phage vB_EcoS_IME542, complete genome | blastn | 5568 | 449 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Drexlerviridae | Christensenvirus | Christensenvirus IME542 | |||
| 17794205 | 17794205 | PRJNA795983_S_NODE_29134_length_270_cov_2.619289_g29009_i0 | PRJNA795983 | 29134 | 270 | 2.619289 | 7.0720803 | Orthorubulavirus | 2560195 | Viruses | Viruses | 492 | 1.23e-134 | NTclustered | gi|2449300967|gb|ON241249.1| | 2560580 | g29009 | i0 | 99.628 | 96.5703703703704 | 269 | 1 | 99 | 0 | 1 | 269 | 6137 | 5869 | Mammalian orthorubulavirus 5 isolate ATCC HTB-55 batch no 70037771, complete genome | blastn | 26074 | 492 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 21182513 | 21182513 | PRJNA795983_S_NODE_21057_length_302_cov_1.746725_g20932_i0 | PRJNA795983 | 21057 | 302 | 1.746725 | 5.2751095 | Shockervirus shocker | 3432426 | Viruses | Viruses | 451 | 2.37e-122 | NTclustered | gi|2487592915|ref|NC_073470.1| | 2805839 | g20932 | i0 | 93.688 | 1.99006622516556 | 301 | 19 | 99 | 0 | 1 | 301 | 21083 | 20783 | Microbacterium phage Shocker, complete genome | blastn | 601 | 451 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Shockervirus | Shockervirus shocker | ||||
| 21182764 | 21182764 | PRJNA795983_S_NODE_7677_length_427_cov_5.937853_g7552_i0 | PRJNA795983 | 7677 | 427 | 5.937853 | 25.35463231 | Christensenvirus IME542 | 2734000 | Viruses | Viruses | 778 | 0 | NTclustered | gi|1842038479|ref|NC_048208.1| | 2507711 | g7552 | i0 | 99.532 | 1 | 427 | 2 | 100 | 0 | 1 | 427 | 20874 | 20448 | Enterobacteria phage vB_EcoS_IME542, complete genome | blastn | 427 | 778 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Drexlerviridae | Christensenvirus | Christensenvirus IME542 | |||
| 22457155 | 22457155 | PRJNA795983_S_NODE_14338_length_343_cov_1.000000_g14213_i0 | PRJNA795983 | 14338 | 343 | 1 | 3.43 | Shockervirus shocker | 3432426 | Viruses | Viruses | 551 | 2.619999999999999e-152 | NTclustered | gi|2487592915|ref|NC_073470.1| | 2805839 | g14213 | i0 | 95.627 | 1 | 343 | 15 | 100 | 0 | 1 | 343 | 40177 | 40519 | Microbacterium phage Shocker, complete genome | blastn | 343 | 551 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Shockervirus | Shockervirus shocker | ||||
| 24168097 | 24168097 | PRJNA795983_S_NODE_11959_length_364_cov_2.989691_g11834_i0 | PRJNA795983 | 11959 | 364 | 2.989691 | 10.88247524 | Paramyxoviridae | 11158 | Viruses | Viruses | 658 | 0 | NTclustered | gi|146351836|gb|EF543647.1| | 149595 | g11834 | i0 | 99.448 | 80.3736263736264 | 362 | 2 | 99 | 0 | 1 | 362 | 102 | 463 | Canine parainfluenza virus strain FA hemagglutin-neuraminidase (HN) gene, complete cds | blastn | 29256 | 664 | 0.990963855421687 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Canine parainfluenza virus | |||
| 24168122 | 24168122 | PRJNA795983_S_NODE_37279_length_249_cov_0.875000_g37154_i0 | PRJNA795983 | 37279 | 249 | 0.875 | 2.17875 | Viruses | 10239 | Viruses | Viruses | 392 | 1.1699999999999999e-104 | NTclustered | gi|2583948011|gb|OR466728.1| | 3075444 | g37154 | i0 | 95.161 | 9.10441767068273 | 248 | 12 | 99 | 0 | 2 | 249 | 12329 | 12576 | Escherichia phage ES, complete genome | blastn | 2267 | 392 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Drexlerviridae | Escherichia phage ES |
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);;