contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA345071" and tax_kingdom = "Orthornavirae"
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 | ||
| 5497048 | 5497048 | PRJNA345071_P_NODE_7365_length_255_cov_2.120879_g7325_i0 | PRJNA345071 | 7365 | 255 | 2.120879 | 5.40824145 | Trichovirus chloropersicae | 3432984 | Viruses | Viruses | 388 | 1.5499999999999998e-103 | NTclustered | gi|1479557639|gb|MH084696.1| | 2358294 | g7325 | i0 | 94.118 | 20.5647058823529 | 255 | 15 | 100 | 0 | 1 | 255 | 5664 | 5918 | Peach chlorotic leaf spot virus isolate RP19-2, complete genome | blastn | 5244 | 388 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Trichovirus | Trichovirus chloropersicae | ||
| 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 | ||
| 8046579 | 8046579 | PRJNA345071_P_NODE_2507_length_368_cov_1.359322_g2467_i0 | PRJNA345071 | 2507 | 368 | 1.359322 | 5.00230496 | Great lobelia partitivirus | 2933144 | Viruses | Viruses | 375 | 1.8299999999999998e-99 | NTclustered | gi|2381814345|emb|OX380358.1| | 2933144 | g2467 | i0 | 85.674 | 0.967391304347826 | 356 | 51 | 97 | 0 | 2 | 357 | 210 | 565 | Great lobelia partitivirus RNA2 | blastn | 356 | 375 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Great lobelia partitivirus | |||
| 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 | ||
| 15696053 | 15696053 | PRJNA345071_P_NODE_6393_length_268_cov_1.610256_g6353_i0 | PRJNA345071 | 6393 | 268 | 1.610256 | 4.31548608 | Trichovirus chloropersicae | 3432984 | Viruses | Viruses | 424 | 4.5099999999999996e-114 | NTclustered | gi|1479557639|gb|MH084696.1| | 2358294 | g6353 | i0 | 95.149 | 46.9850746268657 | 268 | 13 | 100 | 0 | 1 | 268 | 6966 | 6699 | Peach chlorotic leaf spot virus isolate RP19-2, complete genome | blastn | 12592 | 424 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Trichovirus | Trichovirus chloropersicae |
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);;