contig_metadata
12 rows where bioproject = "PRJNA781427", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11415636 | 11415636 | PRJNA781427_P_NODE_45649_length_335_cov_4.473282_g44766_i0 | PRJNA781427 | 45649 | 335 | 4.473282 | 14.9854947 | Paramyxoviridae | 11158 | Viruses | Viruses | 601 | 2.4999999999999993e-167 | NTclustered | gi|9998884|emb|AJ278914.1| | 251774 | g44766 | i0 | 99.102 | 67.9611940298507 | 334 | 3 | 99 | 0 | 1 | 334 | 930 | 1263 | Porcine parainfluenza virus mRNA for membrane protein (m gene) | blastn | 22767 | 603 | 0.996683250414594 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Rubulavirus | Porcine parainfluenza virus | ||
| 12240976 | 12240976 | PRJNA781427_P_NODE_68270_length_266_cov_0.854922_g67386_i0 | PRJNA781427 | 68270 | 266 | 0.854922 | 2.27409252 | Orthorubulavirus mammalis | 3052558 | Viruses | Viruses | 481 | 2.62e-131 | NTclustered | gi|2562721692|gb|OQ994985.1| | 2905673 | g67386 | i0 | 99.248 | 83 | 266 | 2 | 100 | 0 | 1 | 266 | 7997 | 7732 | Parainfluenza virus 5 strain GX2020, complete genome | blastn | 22078 | 481 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 12691069 | 12691069 | PRJNA781427_P_NODE_14150_length_678_cov_1.644628_g13330_i0 | PRJNA781427 | 14150 | 678 | 1.644628 | 11.15057784 | Paramyxoviridae | 11158 | Viruses | Viruses | 1225 | 0 | NTclustered | gi|2721617856|gb|PP711545.1| | 251774 | g13330 | i0 | 99.263 | 71.5545722713864 | 678 | 5 | 100 | 0 | 1 | 678 | 711 | 34 | Porcine parainfluenza virus isolate PPIV-DX-Gansu-2020, partial genome | blastn | 48514 | 1236 | 0.991100323624595 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Rubulavirus | Porcine parainfluenza virus | ||
| 15240146 | 15240146 | PRJNA781427_P_NODE_43732_length_343_cov_2.733333_g42850_i0 | PRJNA781427 | 43732 | 343 | 2.733333 | 9.37533219 | Orthorubulavirus | 2560195 | Viruses | Viruses | 595 | 1.1899999999999999e-165 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g42850 | i0 | 97.959 | 80.667638483965 | 343 | 7 | 100 | 0 | 1 | 343 | 1800 | 2142 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 27669 | 601 | 0.990016638935108 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 15240525 | 15240525 | PRJNA781427_P_NODE_85072_length_246_cov_0.890173_g84188_i0 | PRJNA781427 | 85072 | 246 | 0.890173 | 2.18982558 | Orthorubulavirus | 2560195 | Viruses | Viruses | 438 | 1.4599999999999996e-118 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g84188 | i0 | 98.78 | 69.280487804878 | 246 | 3 | 100 | 0 | 1 | 246 | 14464 | 14219 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 17043 | 438 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 16514839 | 16514839 | PRJNA781427_P_NODE_61613_length_283_cov_1.100000_g60729_i0 | PRJNA781427 | 61613 | 283 | 1.1 | 3.113 | Paramyxoviridae | 11158 | Viruses | Viruses | 518 | 2.14e-142 | NTclustered | gi|2721617856|gb|PP711545.1| | 251774 | g60729 | i0 | 99.647 | 66.9540636042403 | 283 | 1 | 100 | 0 | 1 | 283 | 12730 | 12448 | Porcine parainfluenza virus isolate PPIV-DX-Gansu-2020, partial genome | blastn | 18948 | 523 | 0.990439770554493 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Rubulavirus | Porcine parainfluenza virus | ||
| 17789213 | 17789213 | PRJNA781427_P_NODE_23534_length_492_cov_1.873508_g22655_i0 | PRJNA781427 | 23534 | 492 | 1.873508 | 9.21765936 | Paramyxoviridae | 11158 | Viruses | Viruses | 898 | 0 | NTclustered | gi|2721617856|gb|PP711545.1| | 251774 | g22655 | i0 | 99.593 | 86.1158536585366 | 492 | 2 | 100 | 0 | 1 | 492 | 1302 | 1793 | Porcine parainfluenza virus isolate PPIV-DX-Gansu-2020, partial genome | blastn | 42369 | 898 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Rubulavirus | Porcine parainfluenza virus | ||
| 19063189 | 19063189 | PRJNA781427_P_NODE_18175_length_577_cov_2.682540_g17318_i0 | PRJNA781427 | 18175 | 577 | 2.68254 | 15.4782558 | Orthorubulavirus | 2560195 | Viruses | Viruses | 1061 | 0 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g17318 | i0 | 99.827 | 74.0693240901213 | 577 | 1 | 100 | 0 | 1 | 577 | 3422 | 2846 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 42738 | 1061 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 19063442 | 19063442 | PRJNA781427_P_NODE_46875_length_331_cov_1.116279_g45992_i0 | PRJNA781427 | 46875 | 331 | 1.116279 | 3.69488349 | Orthorubulavirus | 2560195 | Viruses | Viruses | 593 | 4.129999999999999e-165 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g45992 | i0 | 99.094 | 86.785498489426 | 331 | 2 | 100 | 1 | 1 | 331 | 443 | 772 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 28726 | 593 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 21163555 | 21163555 | PRJNA781427_P_NODE_54337_length_304_cov_1.329004_g53454_i0 | PRJNA781427 | 54337 | 304 | 1.329004 | 4.04017216 | Betapaprhavirus frugiperda | 2844304 | Viruses | Viruses | 556 | 4.919999999999999e-154 | NTclustered | gi|1560769851|gb|MH926029.1| | 1481139 | g53454 | i0 | 99.671 | 11 | 304 | 1 | 100 | 0 | 1 | 304 | 703 | 1006 | Spodoptera frugiperda rhabdovirus, complete genome | blastn | 3344 | 556 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Betapaprhavirus | Betapaprhavirus frugiperda | ||
| 25438540 | 25438540 | PRJNA781427_P_NODE_46340_length_333_cov_0.934615_g45457_i0 | PRJNA781427 | 46340 | 333 | 0.934615 | 3.11226795 | Orthorubulavirus | 2560195 | Viruses | Viruses | 601 | 2.4799999999999996e-167 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g45457 | i0 | 99.396 | 67.5975975975976 | 331 | 2 | 99 | 0 | 3 | 333 | 3787 | 3457 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 22510 | 601 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 28380038 | 28380038 | PRJNA781427_P_NODE_9366_length_876_cov_1.547945_g8674_i0 | PRJNA781427 | 9366 | 876 | 1.547945 | 13.5599982 | Wenzhou rodent rhabdovirus 1 | 3084690 | Viruses | Viruses | 55.1 | 9.28e-5 | NR | WPV62747.1 | 3084690 | g8674 | i0 | 36.3 | 0.349315068493151 | 102 | 64 | 34.9 | 1 | 310 | 5 | 159 | 259 | WPV62747.1 MAG: phosphoprotein [Wenzhou rodent rhabdovirus 1] | diamond | 306 | 55.1 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Wenzhou rodent rhabdovirus 1 |
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);;