contig_metadata
8 rows where bioproject = "PRJNA685060", tax_phylum = "Pisuviricota" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9594717 | 9594717 | PRJNA685060_P_NODE_11268_length_279_cov_1.495146_g11178_i0 | PRJNA685060 | 11268 | 279 | 1.495146 | 4.17145734 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 505 | 1.6399999999999995e-138 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g11178 | i0 | 99.283 | 3.9247311827957 | 279 | 2 | 100 | 0 | 1 | 279 | 8173 | 7895 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 1095 | 505 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 9594736 | 9594736 | PRJNA685060_P_NODE_1368_length_848_cov_1.766452_g1293_i0 | PRJNA685060 | 1368 | 848 | 1.766452 | 14.97951296 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 1417 | 0 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g1293 | i0 | 96.816 | 3 | 848 | 27 | 100 | 0 | 1 | 848 | 7029 | 7876 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 2544 | 1417 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 13420133 | 13420133 | PRJNA685060_P_NODE_2091_length_682_cov_1.625616_g2004_i0 | PRJNA685060 | 2091 | 682 | 1.625616 | 11.08670112 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 1144 | 0 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g2004 | i0 | 96.921 | 3 | 682 | 21 | 100 | 0 | 1 | 682 | 6305 | 6986 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 2046 | 1144 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 21068525 | 21068525 | PRJNA685060_P_NODE_11177_length_281_cov_1.389423_g11087_i0 | PRJNA685060 | 11177 | 281 | 1.389423 | 3.90427863 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 475 | 1.2999999999999999e-129 | NTclustered | gi|1990739381|tpg|BK011179.1| | 2304617 | g11087 | i0 | 97.153 | 3 | 281 | 8 | 100 | 0 | 1 | 281 | 4869 | 5149 | TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome | blastn | 843 | 475 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 24892323 | 24892323 | PRJNA685060_P_NODE_5240_length_420_cov_1.109510_g5150_i0 | PRJNA685060 | 5240 | 420 | 1.10951 | 4.659942 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 721 | 0 | NTclustered | gi|1990739381|tpg|BK011179.1| | 2304617 | g5150 | i0 | 97.619 | 3 | 420 | 10 | 100 | 0 | 1 | 420 | 5884 | 6303 | TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome | blastn | 1260 | 721 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 27524560 | 27524560 | PRJNA685060_P_NODE_1843_length_731_cov_2.156535_g1761_i0 | PRJNA685060 | 1843 | 731 | 2.156535 | 15.76427085 | Sobelivirales sp. | 2809868 | Viruses | Viruses | 184 | 9.49e-52 | NR | WRQ64934.1 | 2809868 | g1761 | i0 | 57.1 | 0.640218878248974 | 156 | 54 | 61.6 | 3 | 1 | 450 | 277 | 425 | WRQ64934.1 RNA-dependent RNA polymerase [Sobelivirales sp.] | diamond | 468 | 184 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Sobelivirales sp. | ||||
| 29702782 | 29702782 | PRJNA685060_P_NODE_1790_length_743_cov_2.150746_g1708_i0 | PRJNA685060 | 1790 | 743 | 2.150746 | 15.98004278 | Sobelivirales sp. | 2809868 | Viruses | Viruses | 236 | 2.19e-72 | NR | WRQ64935.1 | 2809868 | g1708 | i0 | 50.2 | 1.00538358008075 | 249 | 118 | 99.7 | 5 | 1 | 741 | 67 | 311 | WRQ64935.1 structural protein, partial [Sobelivirales sp.] | diamond | 747 | 236 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Sobelivirales sp. | ||||
| 30430119 | 30430119 | PRJNA685060_P_NODE_12513_length_262_cov_1.010582_g12423_i0 | PRJNA685060 | 12513 | 262 | 1.010582 | 2.64772484 | Sobelivirales sp. | 2809868 | Viruses | Viruses | 78.6 | 1.04e-14 | NR | WRQ64934.1 | 2809868 | g12423 | i0 | 44.8 | 0.99618320610687 | 87 | 48 | 99.6 | 0 | 261 | 1 | 63 | 149 | WRQ64934.1 RNA-dependent RNA polymerase [Sobelivirales sp.] | diamond | 261 | 78.6 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Sobelivirales sp. |
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);;