contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA897077" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 873696 | 873696 | PRJNA897077_P_NODE_1_length_7187_cov_25.882626_g0_i0 | PRJNA897077 | 1 | 7187 | 25.882626 | 1860.18433062 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 2876 | 0 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g0 | i0 | 96.239 | 0.665646305829971 | 1755 | 62 | 67 | 4 | 5435 | 7187 | 5329 | 7081 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 4784 | 2876 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 2148795 | 2148795 | PRJNA897077_P_NODE_10162_length_309_cov_2.533898_g10035_i0 | PRJNA897077 | 10162 | 309 | 2.533898 | 7.82974482 | Ripiglaq virus | 3130859 | Viruses | Viruses | 80.5 | 1.32e-10 | NTclustered | gi|2717320975|gb|PP173161.1| | 3130859 | g10035 | i0 | 82.292 | 19.3300970873786 | 96 | 14 | 30 | 3 | 1 | 94 | 6770 | 6676 | MAG: Ripiglaq virus isolate KCAP3_k141_198887 genomic sequence | blastn | 5973 | 80.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Marnaviridae | Ripiglaq virus | |||
| 3796079 | 3796079 | PRJNA897077_P_NODE_183_length_1803_cov_25.034682_g162_i0 | PRJNA897077 | 183 | 1803 | 25.034682 | 451.37531646 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 907 | 0 | NTclustered | gi|4760940|gb|AF100359.1|AF100359 | RQ01 | g162 | i0 | 77.77 | 82.4525790349418 | 1507 | 313 | 83 | 19 | 54 | 1550 | 1687 | 193 | Influenza B virus B/Victoria/2/87 segment 5 nucleoprotein (NP) gene, complete cds | blastn | 148662 | 907 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Betainfluenzavirus | Zebrafish influenza B-like virus | ||
| 5977128 | 5977128 | PRJNA897077_P_NODE_945_length_960_cov_16.502818_g59_i1 | PRJNA897077 | 945 | 960 | 16.502818 | 158.4270528 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 442 | 4.9299999999999984e-119 | NTclustered | gi|161377386|gb|EU305611.1| | RQ01 | g59 | i1 | 83.23 | 49.9604166666667 | 483 | 79 | 50 | 2 | 477 | 958 | 482 | 1 | Influenza B virus (B/Guangzhou/01/2007) segment 1, complete sequence | blastn | 47962 | 442 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Betainfluenzavirus | Zebrafish influenza B-like virus | ||
| 5977131 | 5977131 | PRJNA897077_P_NODE_9685_length_317_cov_1.344262_g9558_i0 | PRJNA897077 | 9685 | 317 | 1.344262 | 4.26131054 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 470 | 6.92e-128 | NTclustered | gi|1990739381|tpg|BK011179.1| | 2304617 | g9558 | i0 | 93.375 | 3 | 317 | 21 | 100 | 0 | 1 | 317 | 5167 | 5483 | TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome | blastn | 951 | 470 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 6348149 | 6348149 | PRJNA897077_P_NODE_185_length_1800_cov_64.767805_g164_i0 | PRJNA897077 | 185 | 1800 | 64.767805 | 1165.82049 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 944 | 0 | NTclustered | gi|1000392034|gb|CY198788.1| | RQ01 | g164 | i0 | 77.857 | 85.8166666666667 | 1549 | 326 | 86 | 17 | 2 | 1543 | 1781 | 243 | Influenza B virus (B/Sydney/31/2013) nucleoprotein (NP) gene, complete cds | blastn | 154470 | 944 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Betainfluenzavirus | Zebrafish influenza B-like virus | ||
| 6348183 | 6348183 | PRJNA897077_P_NODE_65_length_2373_cov_11.017826_g56_i0 | PRJNA897077 | 65 | 2373 | 11.017826 | 261.45301098 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 1578 | 0 | NTclustered | gi|2778032212|gb|PQ079036.1| | RQ01 | g56 | i0 | 78.889 | 99.417614833544 | 2359 | 474 | 99 | 24 | 16 | 2362 | 1 | 2347 | Influenza B virus (B/Delaware/30/2024) segment 2 polymerase PB2 (PB2) gene, complete cds | blastn | 235918 | 1578 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Betainfluenzavirus | Zebrafish influenza B-like virus | ||
| 11077252 | 11077252 | PRJNA897077_P_NODE_69_length_2357_cov_9.592382_g59_i0 | PRJNA897077 | 69 | 2357 | 9.592382 | 226.09244374 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 1600 | 0 | NTclustered | gi|2915732589|gb|PV140086.1| | RQ01 | g59 | i0 | 79.546 | 95.3440814594824 | 2249 | 454 | 95 | 6 | 3 | 2248 | 1 | 2246 | Influenza B virus (B/King County/WA-S27707/2019) segment 1 polymerase PB1 (PB1) gene, complete cds | blastn | 224726 | 1600 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Betainfluenzavirus | Zebrafish influenza B-like virus | ||
| 11077255 | 11077255 | PRJNA897077_P_NODE_709_length_1078_cov_59.726368_g626_i0 | PRJNA897077 | 709 | 1078 | 59.726368 | 643.85024704 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 472 | 7.1e-128 | NTclustered | gi|2413738274|gb|OQ034436.1| | RQ01 | g626 | i0 | 75.069 | 88.4137291280148 | 1087 | 233 | 99 | 28 | 5 | 1076 | 1 | 1064 | Influenza B virus (B/Yamagata/16/1988) segment 8 nuclear export protein (NEP) and nonstructural protein 1 (NS1) genes, complete cds | blastn | 95310 | 472 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Betainfluenzavirus | Zebrafish influenza B-like virus | ||
| 12352450 | 12352450 | PRJNA897077_P_NODE_10_length_4140_cov_34.527662_g0_i1 | PRJNA897077 | 10 | 4140 | 34.527662 | 1429.4452068 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 2876 | 0 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g0 | i1 | 96.239 | 0.721739130434783 | 1755 | 62 | 72 | 4 | 2388 | 4140 | 5329 | 7081 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 2988 | 2876 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 13627389 | 13627389 | PRJNA897077_P_NODE_17611_length_247_cov_1.436782_g17484_i0 | PRJNA897077 | 17611 | 247 | 1.436782 | 3.54885154 | Sopazov virus | 3131687 | Viruses | Viruses | 335 | 1.9799999999999992e-87 | NTclustered | gi|2717323152|gb|PP173988.1| | 3131687 | g17484 | i0 | 91.463 | 62.8097165991903 | 246 | 17 | 99 | 4 | 1 | 244 | 60 | 303 | MAG: Sopazov virus isolate SP1B_k141_222276 genomic sequence | blastn | 15514 | 335 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Sopazov virus | |||||
| 17451840 | 17451840 | PRJNA897077_P_NODE_194_length_1778_cov_44.815836_g0_i2 | PRJNA897077 | 194 | 1778 | 44.815836 | 796.82556408 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 2865 | 0 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g0 | i2 | 96.125 | 0.987064116985377 | 1755 | 64 | 99 | 4 | 1 | 1753 | 7081 | 5329 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 1755 | 2865 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 24195702 | 24195702 | PRJNA897077_P_NODE_539_length_1214_cov_128.316389_g477_i0 | PRJNA897077 | 539 | 1214 | 128.316389 | 1557.76096246 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 686 | 0 | NTclustered | gi|2413738133|gb|OQ034387.1| | RQ01 | g477 | i0 | 81.473 | 70.834431630972 | 842 | 150 | 69 | 6 | 42 | 880 | 1 | 839 | Influenza B virus (B/Michigan/1/1971) segment 7 matrix protein 1 (M1) and BM2 protein (BM2) genes, complete cds | blastn | 85993 | 686 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Betainfluenzavirus | Zebrafish influenza B-like virus | ||
| 24195719 | 24195719 | PRJNA897077_P_NODE_79_length_2265_cov_8.452099_g69_i0 | PRJNA897077 | 79 | 2265 | 8.452099 | 191.44004235 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 1485 | 0 | NTclustered | gi|125663455|gb|CY019704.1| | RQ01 | g69 | i0 | 78.974 | 97.153642384106 | 2202 | 445 | 97 | 18 | 51 | 2243 | 2193 | 1 | Influenza B virus (B/Johannesburg/06/1994) segment 3, complete sequence | blastn | 220053 | 1496 | 0.992647058823529 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Betainfluenzavirus | Zebrafish influenza B-like virus | ||
| 25099676 | 25099676 | PRJNA897077_P_NODE_3040_length_554_cov_26.307692_g2913_i0 | PRJNA897077 | 3040 | 554 | 26.307692 | 145.74461368 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 231 | 6.529999999999999e-56 | NTclustered | gi|2716152687|gb|PP644821.1| | RQ01 | g2913 | i0 | 81.818 | 13.6913357400722 | 275 | 50 | 50 | 0 | 12 | 286 | 2347 | 2073 | Influenza B virus (B/Washington/30/2023) segment 2 polymerase PB2 (PB2) gene, complete cds | blastn | 7585 | 231 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Betainfluenzavirus | Zebrafish influenza B-like virus | ||
| 25470835 | 25470835 | PRJNA897077_P_NODE_13140_length_274_cov_1.139303_g13013_i0 | PRJNA897077 | 13140 | 274 | 1.139303 | 3.12169022 | Orthorubulavirus | 2560195 | Viruses | Viruses | 507 | 4.47e-139 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g13013 | i0 | 100 | 69.5620437956204 | 274 | 0 | 100 | 0 | 1 | 274 | 1424 | 1151 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 19060 | 507 | 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);;