contig_metadata
8 rows where bioproject = "PRJNA345071", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2345731 | 2345731 | PRJNA345071_P_NODE_22_length_1844_cov_504.219085_g16_i0 | PRJNA345071 | 22 | 1844 | 504.219085 | 9297.7999274 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 900 | 0 | NTclustered | gi|4760940|gb|AF100359.1|AF100359 | RQ01 | g16 | i0 | 77.302 | 84.337852494577 | 1564 | 332 | 84 | 19 | 37 | 1590 | 1743 | 193 | Influenza B virus B/Victoria/2/87 segment 5 nucleoprotein (NP) gene, complete cds | blastn | 155519 | 902 | 0.997782705099778 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Betainfluenzavirus | Zebrafish influenza B-like virus | ||
| 7448274 | 7448274 | PRJNA345071_P_NODE_6_length_2383_cov_21.471429_g3_i0 | PRJNA345071 | 6 | 2383 | 21.471429 | 511.66415307 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 1711 | 0 | NTclustered | gi|2070683497|gb|MZ603947.1| | RQ01 | g3 | i0 | 79.84 | 99.0709190096517 | 2371 | 456 | 99 | 22 | 4 | 2363 | 2 | 2361 | Influenza B virus (B/USA/5/2017) segment 2 polymerase PB2 (PB2) gene, complete cds | blastn | 236086 | 1711 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Betainfluenzavirus | Zebrafish influenza B-like virus | ||
| 8722949 | 8722949 | PRJNA345071_P_NODE_7_length_2357_cov_14.318301_g4_i0 | PRJNA345071 | 7 | 2357 | 14.318301 | 337.48235457 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 1628 | 0 | NTclustered | gi|2054205231|gb|MZ401397.1| | RQ01 | g4 | i0 | 79.504 | 96.7293169282987 | 2298 | 463 | 97 | 8 | 62 | 2355 | 2295 | 2 | Influenza B virus (B/USA/762910_Segment_1/2021) segment 1 polymerase PB1 (PB1) gene, complete cds | blastn | 227991 | 1628 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Betainfluenzavirus | Zebrafish influenza B-like virus | ||
| 11273616 | 11273616 | PRJNA345071_P_NODE_9_length_2260_cov_14.909465_g6_i0 | PRJNA345071 | 9 | 2260 | 14.909465 | 336.953909 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 1448 | 0 | NTclustered | gi|1128385509|gb|CY211229.1| | RQ01 | g6 | i0 | 78.662 | 97.1092920353982 | 2198 | 455 | 97 | 14 | 19 | 2209 | 2 | 2192 | Influenza B virus (B/Florida/91/2016) polymerase PA (PA) gene, complete cds | blastn | 219467 | 1448 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Betainfluenzavirus | Zebrafish influenza B-like virus | ||
| 12548899 | 12548899 | PRJNA345071_P_NODE_110_length_1179_cov_515.866184_g97_i0 | PRJNA345071 | 110 | 1179 | 515.866184 | 6082.06230936 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 641 | 5.609999999999999e-179 | NTclustered | gi|2449947533|gb|OQ535360.1| | RQ01 | g97 | i0 | 80.546 | 71.4758269720102 | 843 | 156 | 71 | 8 | 6 | 844 | 1 | 839 | Influenza B virus (B/USA/8B1/2011) segment 7 matrix protein 1 (M1) and BM2 protein (BM2) genes, complete cds | blastn | 84270 | 641 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Betainfluenzavirus | Zebrafish influenza B-like virus | ||
| 14422036 | 14422036 | PRJNA345071_P_NODE_152_length_1090_cov_195.870206_g133_i0 | PRJNA345071 | 152 | 1090 | 195.870206 | 2134.9852454 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 468 | 9.29e-127 | NTclustered | gi|2413738156|gb|OQ034364.1| | RQ01 | g133 | i0 | 74.886 | 79.2403669724771 | 1099 | 240 | 99 | 32 | 1 | 1085 | 1077 | 1 | Influenza B virus (B/Great Lakes/1739/1954) segment 8 nuclear export protein (NEP) and nonstructural protein 1 (NS1) genes, complete cds | blastn | 86372 | 468 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Betainfluenzavirus | Zebrafish influenza B-like virus | ||
| 26599629 | 26599629 | PRJNA345071_P_NODE_41_length_1563_cov_367.995973_g33_i0 | PRJNA345071 | 41 | 1563 | 367.995973 | 5751.77705799 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 578 | 1.75e-201 | NR | AVM87625.1 | RQ01 | g33 | i0 | 64.4 | 0.90595009596929 | 472 | 163 | 89.6 | 3 | 66 | 1466 | 1 | 472 | AVM87625.1 NA [Wuhan spiny eel influenza virus] | diamond | 1416 | 578 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Zebrafish influenza B-like virus | |||
| 26885076 | 26885076 | PRJNA345071_P_NODE_21_length_1869_cov_841.831292_g15_i0 | PRJNA345071 | 21 | 1869 | 841.831292 | 15733.82684748 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 713 | 2.5100000000000007e-251 | NR | AVM87624.1 | RQ01 | g15 | i0 | 62.7 | 0.913322632423756 | 569 | 208 | 91.2 | 3 | 1796 | 93 | 3 | 568 | AVM87624.1 hemagglutinin, partial [Wuhan spiny eel influenza virus] | diamond | 1707 | 713 | 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);;