contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA795983" and tax_kingdom = "Orthornavirae"
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 | ||
| 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. | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 |
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);;