contig_metadata
10 rows where bioproject = "PRJNA675331" and tax_phylum = "Negarnaviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1168554 | 1168554 | PRJNA675331_P_NODE_2021_length_644_cov_1.509632_g1855_i0 | PRJNA675331 | 2021 | 644 | 1.509632 | 9.72203008 | Paramyxoviridae | 11158 | Viruses | Viruses | 1173 | 0 | NTclustered | gi|9998888|emb|AJ278916.1| | 251774 | g1855 | i0 | 99.534 | 97.9673913043478 | 644 | 3 | 100 | 0 | 1 | 644 | 267 | 910 | Porcine parainfluenza virus mRNA for fusion protein (f gene) | blastn | 63091 | 1184 | 0.990709459459459 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Rubulavirus | Porcine parainfluenza virus | ||
| 2443874 | 2443874 | PRJNA675331_P_NODE_1802_length_681_cov_1.687500_g1641_i0 | PRJNA675331 | 1802 | 681 | 1.6875 | 11.491875 | Orthorubulavirus | 2560195 | Viruses | Viruses | 1247 | 0 | NTclustered | gi|146351838|gb|EF543648.1| | 149595 | g1641 | i0 | 99.706 | 70.5565345080764 | 681 | 2 | 100 | 0 | 1 | 681 | 1348 | 668 | Canine parainfluenza virus strain FA nucleocapsid (N) gene, complete cds | blastn | 48049 | 1253 | 0.995211492418196 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Canine parainfluenza virus | |||
| 6272474 | 6272474 | PRJNA675331_P_NODE_2205_length_618_cov_1.743119_g2039_i0 | PRJNA675331 | 2205 | 618 | 1.743119 | 10.77247542 | Paramyxoviridae | 11158 | Viruses | Viruses | 1114 | 0 | NTclustered | gi|2721617856|gb|PP711545.1| | 251774 | g2039 | i0 | 99.191 | 96.9983818770227 | 618 | 5 | 100 | 0 | 1 | 618 | 4981 | 4364 | Porcine parainfluenza virus isolate PPIV-DX-Gansu-2020, partial genome | blastn | 59945 | 1120 | 0.994642857142857 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Rubulavirus | Porcine parainfluenza virus | ||
| 6272476 | 6272476 | PRJNA675331_P_NODE_2245_length_613_cov_2.361111_g2079_i0 | PRJNA675331 | 2245 | 613 | 2.361111 | 14.47361043 | Paramyxoviridae | 11158 | Viruses | Viruses | 1133 | 0 | NTclustered | gi|2721617856|gb|PP711545.1| | 251774 | g2079 | i0 | 100 | 68.9967373572594 | 613 | 0 | 100 | 0 | 1 | 613 | 2151 | 2763 | Porcine parainfluenza virus isolate PPIV-DX-Gansu-2020, partial genome | blastn | 42295 | 1133 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Rubulavirus | Porcine parainfluenza virus | ||
| 7546426 | 7546426 | PRJNA675331_P_NODE_20026_length_248_cov_0.880000_g19854_i0 | PRJNA675331 | 20026 | 248 | 0.88 | 2.1824 | Paramyxoviridae | 11158 | Viruses | Viruses | 455 | 1.4600000000000002e-123 | NTclustered | gi|2721617856|gb|PP711545.1| | 251774 | g19854 | i0 | 100 | 69.1209677419355 | 246 | 0 | 99 | 0 | 3 | 248 | 8311 | 8556 | Porcine parainfluenza virus isolate PPIV-DX-Gansu-2020, partial genome | blastn | 17142 | 455 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Rubulavirus | Porcine parainfluenza virus | ||
| 7546435 | 7546435 | PRJNA675331_P_NODE_6086_length_390_cov_0.798107_g5914_i0 | PRJNA675331 | 6086 | 390 | 0.798107 | 3.1126173 | Paramyxoviridae | 11158 | Viruses | Viruses | 699 | 0 | NTclustered | gi|2721617856|gb|PP711545.1| | 251774 | g5914 | i0 | 98.974 | 82.9641025641026 | 390 | 4 | 100 | 0 | 1 | 390 | 7112 | 6723 | Porcine parainfluenza virus isolate PPIV-DX-Gansu-2020, partial genome | blastn | 32356 | 704 | 0.992897727272727 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Rubulavirus | Porcine parainfluenza virus | ||
| 8821564 | 8821564 | PRJNA675331_P_NODE_887_length_946_cov_1.633448_g755_i0 | PRJNA675331 | 887 | 946 | 1.633448 | 15.45241808 | Paramyxoviridae | 11158 | Viruses | Viruses | 1698 | 0 | NTclustered | gi|2721617856|gb|PP711545.1| | 251774 | g755 | i0 | 99.049 | 84.9778012684989 | 946 | 9 | 100 | 0 | 1 | 946 | 769 | 1714 | Porcine parainfluenza virus isolate PPIV-DX-Gansu-2020, partial genome | blastn | 80389 | 1698 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Rubulavirus | Porcine parainfluenza virus | ||
| 11372076 | 11372076 | PRJNA675331_P_NODE_15689_length_267_cov_1.190722_g15517_i0 | PRJNA675331 | 15689 | 267 | 1.190722 | 3.17922774 | Paramyxoviridae | 11158 | Viruses | Viruses | 494 | 3.38e-135 | NTclustered | gi|2721617856|gb|PP711545.1| | 251774 | g15517 | i0 | 100 | 83.9438202247191 | 267 | 0 | 100 | 0 | 1 | 267 | 6537 | 6271 | Porcine parainfluenza virus isolate PPIV-DX-Gansu-2020, partial genome | blastn | 22413 | 494 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Rubulavirus | Porcine parainfluenza virus | ||
| 13922450 | 13922450 | PRJNA675331_P_NODE_7931_length_347_cov_1.124088_g7759_i0 | PRJNA675331 | 7931 | 347 | 1.124088 | 3.90058536 | Paramyxoviridae | 11158 | Viruses | Viruses | 625 | 1.5399999999999999e-174 | NTclustered | gi|146351836|gb|EF543647.1| | 149595 | g7759 | i0 | 99.135 | 80.6599423631124 | 347 | 3 | 100 | 0 | 1 | 347 | 447 | 101 | Canine parainfluenza virus strain FA hemagglutin-neuraminidase (HN) gene, complete cds | blastn | 27989 | 630 | 0.992063492063492 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Canine parainfluenza virus | |||
| 17746391 | 17746391 | PRJNA675331_P_NODE_2094_length_634_cov_1.290553_g1928_i0 | PRJNA675331 | 2094 | 634 | 1.290553 | 8.18210602 | Orthorubulavirus | 2560195 | Viruses | Viruses | 1155 | 0 | NTclustered | gi|2449300967|gb|ON241249.1| | 2560580 | g1928 | i0 | 99.527 | 85.1514195583596 | 634 | 3 | 100 | 0 | 1 | 634 | 695 | 62 | Mammalian orthorubulavirus 5 isolate ATCC HTB-55 batch no 70037771, complete genome | blastn | 53986 | 1155 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis |
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);;