contig_metadata
11 rows where bioproject = "PRJNA1156092", tax_phylum = "Negarnaviricota" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2312587 | 2312587 | PRJNA1156092_P_NODE_5762_length_436_cov_1.903581_g5632_i0 | PRJNA1156092 | 5762 | 436 | 1.903581 | 8.29961316 | Paramyxoviridae | 11158 | Viruses | Viruses | 800 | 0 | NTclustered | gi|2721617856|gb|PP711545.1| | 251774 | g5632 | i0 | 99.771 | 68.9839449541284 | 436 | 1 | 100 | 0 | 1 | 436 | 2509 | 2074 | Porcine parainfluenza virus isolate PPIV-DX-Gansu-2020, partial genome | blastn | 30077 | 806 | 0.992555831265509 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Rubulavirus | Porcine parainfluenza virus | ||
| 4865384 | 4865384 | PRJNA1156092_P_NODE_724_length_1041_cov_1.577479_g642_i0 | PRJNA1156092 | 724 | 1041 | 1.577479 | 16.42155639 | Orthorubulavirus | 2560195 | Viruses | Viruses | 1901 | 0 | NTclustered | gi|146351838|gb|EF543648.1| | 149595 | g642 | i0 | 99.616 | 75.073967339097 | 1041 | 4 | 100 | 0 | 1 | 1041 | 1460 | 420 | Canine parainfluenza virus strain FA nucleocapsid (N) gene, complete cds | blastn | 78152 | 1917 | 0.991653625456442 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Canine parainfluenza virus | |||
| 8690327 | 8690327 | PRJNA1156092_P_NODE_3647_length_529_cov_1.065789_g3518_i0 | PRJNA1156092 | 3647 | 529 | 1.065789 | 5.63802381 | Orthorubulavirus | 2560195 | Viruses | Viruses | 966 | 0 | NTclustered | gi|2449300967|gb|ON241249.1| | 2560580 | g3518 | i0 | 99.622 | 85.3478260869565 | 529 | 2 | 100 | 0 | 1 | 529 | 2197 | 2725 | Mammalian orthorubulavirus 5 isolate ATCC HTB-55 batch no 70037771, complete genome | blastn | 45149 | 966 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 14331706 | 14331706 | PRJNA1156092_P_NODE_16732_length_286_cov_1.441315_g16602_i0 | PRJNA1156092 | 16732 | 286 | 1.441315 | 4.1221609 | Orthorubulavirus mammalis | 3052558 | Viruses | Viruses | 529 | 1e-145 | NTclustered | gi|2449300967|gb|ON241249.1| | 2560580 | g16602 | i0 | 100 | 83.9965034965035 | 286 | 0 | 100 | 0 | 1 | 286 | 7485 | 7200 | Mammalian orthorubulavirus 5 isolate ATCC HTB-55 batch no 70037771, complete genome | blastn | 24023 | 529 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 16339625 | 16339625 | PRJNA1156092_P_NODE_14493_length_304_cov_1.333333_g14363_i0 | PRJNA1156092 | 14493 | 304 | 1.333333 | 4.05333232 | Paramyxoviridae | 11158 | Viruses | Viruses | 556 | 4.919999999999999e-154 | NTclustered | gi|2721617856|gb|PP711545.1| | 251774 | g14363 | i0 | 99.671 | 96.9605263157895 | 304 | 1 | 100 | 0 | 1 | 304 | 4834 | 4531 | Porcine parainfluenza virus isolate PPIV-DX-Gansu-2020, partial genome | blastn | 29476 | 556 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Rubulavirus | Porcine parainfluenza virus | ||
| 16339742 | 16339742 | PRJNA1156092_P_NODE_27893_length_245_cov_1.313953_g27763_i0 | PRJNA1156092 | 27893 | 245 | 1.313953 | 3.21918485 | Orthorubulavirus | 2560195 | Viruses | Viruses | 453 | 5.1900000000000006e-123 | NTclustered | gi|2449300967|gb|ON241249.1| | 2560580 | g27763 | i0 | 100 | 76.4367346938776 | 245 | 0 | 100 | 0 | 1 | 245 | 42 | 286 | Mammalian orthorubulavirus 5 isolate ATCC HTB-55 batch no 70037771, complete genome | blastn | 18727 | 453 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 17614978 | 17614978 | PRJNA1156092_P_NODE_25754_length_247_cov_1.770115_g25624_i0 | PRJNA1156092 | 25754 | 247 | 1.770115 | 4.37218405 | Orthorubulavirus | 2560195 | Viruses | Viruses | 446 | 8.759999999999998e-121 | NTclustered | gi|2449300967|gb|ON241249.1| | 2560580 | g25624 | i0 | 99.59 | 53.336032388664 | 244 | 1 | 99 | 0 | 4 | 247 | 6462 | 6219 | Mammalian orthorubulavirus 5 isolate ATCC HTB-55 batch no 70037771, complete genome | blastn | 13174 | 446 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 20163672 | 20163672 | PRJNA1156092_P_NODE_6096_length_427_cov_1.220339_g5966_i0 | PRJNA1156092 | 6096 | 427 | 1.220339 | 5.21084753 | Paramyxoviridae | 11158 | Viruses | Viruses | 767 | 0 | NTclustered | gi|2721617856|gb|PP711545.1| | 251774 | g5966 | i0 | 99.063 | 81.0140515222482 | 427 | 4 | 100 | 0 | 1 | 427 | 1161 | 735 | Porcine parainfluenza virus isolate PPIV-DX-Gansu-2020, partial genome | blastn | 34593 | 767 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Rubulavirus | Porcine parainfluenza virus | ||
| 22714137 | 22714137 | PRJNA1156092_P_NODE_2178_length_663_cov_1.452542_g2053_i0 | PRJNA1156092 | 2178 | 663 | 1.452542 | 9.63035346 | Paramyxoviridae | 11158 | Viruses | Viruses | 1214 | 0 | NTclustered | gi|2721617856|gb|PP711545.1| | 251774 | g2053 | i0 | 99.698 | 69.078431372549 | 663 | 2 | 100 | 0 | 1 | 663 | 3384 | 2722 | Porcine parainfluenza virus isolate PPIV-DX-Gansu-2020, partial genome | blastn | 45799 | 1225 | 0.991020408163265 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Rubulavirus | Porcine parainfluenza virus | ||
| 23989349 | 23989349 | PRJNA1156092_P_NODE_13559_length_312_cov_2.255230_g13429_i0 | PRJNA1156092 | 13559 | 312 | 2.25523 | 7.0363176 | Paramyxoviridae | 11158 | Viruses | Viruses | 575 | 1.3999999999999999e-159 | NTclustered | gi|145617272|gb|EF546392.1| | 149595 | g13429 | i0 | 100 | 97.6410256410256 | 311 | 0 | 99 | 0 | 1 | 311 | 1138 | 828 | Canine parainfluenza virus strain FC fusion protein (F) gene, complete cds | blastn | 30464 | 575 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Canine parainfluenza virus | |||
| 28828045 | 28828045 | PRJNA1156092_P_NODE_18908_length_271_cov_1.166667_g18778_i0 | PRJNA1156092 | 18908 | 271 | 1.166667 | 3.16166757 | Chuvivirus | 2842604 | Viruses | Viruses | 138 | 1.55e-36 | NR | WET19887.1 | 2842604 | g18778 | i0 | 69.7 | 1.97047970479705 | 89 | 27 | 98.5 | 0 | 268 | 2 | 292 | 380 | WET19887.1 MAG: nucleoprotein [Freshwater turtle neural virus 1] | diamond | 534 | 138 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Chuvivirus | Chuvivirus |
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);;