contig_metadata
15 rows where bioproject = "PRJNA897077", tax_kingdom = "Orthornavirae" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||
| 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 | ||
| 13998077 | 13998077 | PRJNA897077_P_NODE_291_length_1560_cov_54.746469_g256_i0 | PRJNA897077 | 291 | 1560 | 54.746469 | 854.0449164 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 575 | 4.05e-200 | NR | AVM87625.1 | RQ01 | g256 | i0 | 64.2 | 0.907692307692308 | 472 | 164 | 89.8 | 3 | 1494 | 94 | 1 | 472 | AVM87625.1 NA [Wuhan spiny eel influenza virus] | diamond | 1416 | 575 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Zebrafish influenza B-like virus | |||
| 20000230 | 20000230 | PRJNA897077_P_NODE_18436_length_245_cov_1.226744_g18309_i0 | PRJNA897077 | 18436 | 245 | 1.226744 | 3.0055228 | Orthornavirae | 2732396 | Viruses | Viruses | 73.6 | 5.38e-13 | NR | XCO56027.1 | 3233859 | g18309 | i0 | 41.9 | 1.81224489795918 | 74 | 43 | 90.6 | 0 | 243 | 22 | 327 | 400 | XCO56027.1 MAG: putative RNA-dependent RNA polymerase [Fusarium culmorum yue-like virus 1] | diamond | 444 | 73.6 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | Fusarium culmorum yue-like virus 1 | |||
| 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 | ||
| 28476937 | 28476937 | PRJNA897077_P_NODE_6506_length_381_cov_1.474026_g6379_i0 | PRJNA897077 | 6506 | 381 | 1.474026 | 5.61603906 | Qingdao RNA virus 4 | 2979708 | Viruses | Viruses | 125 | 1.9099999999999997e-30 | NR | BDR95913.1 | 2979708 | g6379 | i0 | 48.8 | 0.984251968503937 | 125 | 64 | 98.4 | 0 | 3 | 377 | 1052 | 1176 | BDR95913.1 RNA-dependent RNA polymerase [Qingdao RNA virus 4] | diamond | 375 | 125 | 1 | Viruses | Orthornavirae | Negarnaviricota | Chunqiuviricetes | Muvirales | Qinviridae | Qingdao RNA virus 4 | |||
| 29423916 | 29423916 | PRJNA897077_P_NODE_309_length_1519_cov_17.403873_g273_i0 | PRJNA897077 | 309 | 1519 | 17.403873 | 264.36483087 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 580 | 1.8099999999999999e-202 | NR | AVM87625.1 | RQ01 | g273 | i0 | 64.4 | 0.932192231731402 | 472 | 163 | 92.2 | 3 | 61 | 1461 | 1 | 472 | AVM87625.1 NA [Wuhan spiny eel influenza virus] | diamond | 1416 | 580 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Zebrafish influenza B-like virus | |||
| 29707851 | 29707851 | PRJNA897077_P_NODE_170_length_1847_cov_118.968433_g149_i0 | PRJNA897077 | 170 | 1847 | 118.968433 | 2197.34695751 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 710 | 3.17e-250 | NR | AVM87624.1 | RQ01 | g149 | i0 | 62.2 | 0.924201407688143 | 569 | 211 | 92.3 | 3 | 1773 | 70 | 3 | 568 | AVM87624.1 hemagglutinin, partial [Wuhan spiny eel influenza virus] | diamond | 1707 | 710 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Zebrafish influenza B-like virus |
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);;