contig_metadata
9 rows where bioproject = "PRJNA662254" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1161901 | 1161901 | PRJNA662254_P_NODE_541_length_2199_cov_4.032926_g419_i0 | PRJNA662254 | 541 | 2199 | 4.032926 | 88.68404274 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 1507 | 0 | NTclustered | gi|1626609665|gb|MK857730.1| | RQ01 | g419 | i0 | 79.074 | 100.136880400182 | 2203 | 453 | 100 | 8 | 1 | 2199 | 2251 | 53 | Influenza B virus (B/Connecticut/01/2019) segment 1 polymerase PB1 (PB1) gene, complete cds | blastn | 220201 | 1507 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Betainfluenzavirus | Zebrafish influenza B-like virus | ||
| 13382358 | 13382358 | PRJNA662254_P_NODE_41551_length_260_cov_2.299465_g40900_i0 | PRJNA662254 | 41551 | 260 | 2.299465 | 5.978609 | Orthoavulavirus javaense | 3051375 | Viruses | Viruses | 475 | 1.1899999999999999e-129 | NTclustered | gi|1679362523|gb|MH996952.1| | 2560319 | g40900 | i0 | 100 | 99.4153846153846 | 257 | 0 | 99 | 0 | 1 | 257 | 257 | 1 | Avian paramyxovirus 1 isolate chicken/Nigeria/Ibadan/VRD Ibadan/2/1973, partial genome | blastn | 25848 | 475 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthoavulavirus | Orthoavulavirus javaense | ||
| 17206257 | 17206257 | PRJNA662254_P_NODE_2674_length_1091_cov_31.944990_g2260_i0 | PRJNA662254 | 2674 | 1091 | 31.94499 | 348.5198409 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 499 | 3.2999999999999998e-136 | NTclustered | gi|2413738156|gb|OQ034364.1| | RQ01 | g2260 | i0 | 75.362 | 97.1200733272227 | 1104 | 236 | 99 | 32 | 1 | 1090 | 1082 | 1 | Influenza B virus (B/Great Lakes/1739/1954) segment 8 nuclear export protein (NEP) and nonstructural protein 1 (NS1) genes, complete cds | blastn | 105958 | 499 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Betainfluenzavirus | Zebrafish influenza B-like virus | ||
| 17739882 | 17739882 | PRJNA662254_P_NODE_874_length_1830_cov_32.645987_g686_i0 | PRJNA662254 | 874 | 1830 | 32.645987 | 597.4215621 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 928 | 0 | NTclustered | gi|4760940|gb|AF100359.1|AF100359 | RQ01 | g686 | i0 | 77.607 | 84.8060109289618 | 1563 | 329 | 85 | 17 | 249 | 1802 | 193 | 1743 | Influenza B virus B/Victoria/2/87 segment 5 nucleoprotein (NP) gene, complete cds | blastn | 155195 | 929 | 0.998923573735199 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Betainfluenzavirus | Zebrafish influenza B-like virus | ||
| 20288286 | 20288286 | PRJNA662254_P_NODE_476_length_2296_cov_2.701754_g366_i0 | PRJNA662254 | 476 | 2296 | 2.701754 | 62.03227184 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 1411 | 0 | NTclustered | gi|119516769|gb|CY018794.1| | RQ01 | g366 | i0 | 78.532 | 94.2334494773519 | 2166 | 451 | 94 | 14 | 124 | 2282 | 2159 | 1 | Influenza B virus (B/Hong Kong/03/1992) segment 3, complete sequence | blastn | 216360 | 1423 | 0.99156711173577 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Betainfluenzavirus | Zebrafish influenza B-like virus | ||
| 21563884 | 21563884 | PRJNA662254_P_NODE_2297_length_1177_cov_43.203804_g1918_i0 | PRJNA662254 | 2297 | 1177 | 43.203804 | 508.50877308 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 617 | 9.439999999999999e-172 | NTclustered | gi|2413738033|gb|OQ034355.1| | RQ01 | g1918 | i0 | 80.024 | 71.4265080713679 | 841 | 162 | 71 | 6 | 4 | 841 | 2 | 839 | Influenza B virus (B/reassortant/ISMMS M2P4-3 (B/Pennsylvania/5/2007 x B/Texas/06/2011 x B/Michigan/1/1971 x B/Malaysia/2506/2004-MA)) segment 7 matrix protein 1 (M1) and BM2 protein (BM2) genes, complete cds | blastn | 84069 | 617 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Betainfluenzavirus | Zebrafish influenza B-like virus | ||
| 29229021 | 29229021 | PRJNA662254_P_NODE_489_length_2268_cov_3.131663_g378_i0 | PRJNA662254 | 489 | 2268 | 3.131663 | 71.02611684 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 1383 | 0 | NR | 6T0W_C | RQ01 | g378 | i0 | 90.3 | 0.992063492063492 | 750 | 73 | 99.2 | 0 | 2251 | 2 | 10 | 759 | 6T0W_C Chain C, Polymerase PB2 [Influenza B virus] | diamond | 2250 | 1383 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Betainfluenzavirus | Zebrafish influenza B-like virus | ||
| 29260134 | 29260134 | PRJNA662254_P_NODE_1289_length_1542_cov_29.628999_g1023_i0 | PRJNA662254 | 1289 | 1542 | 29.628999 | 456.87916458 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 576 | 1.6099999999999998e-200 | NR | AVM87625.1 | RQ01 | g1023 | i0 | 64 | 0.918287937743191 | 472 | 165 | 90.9 | 3 | 1482 | 82 | 1 | 472 | AVM87625.1 NA [Wuhan spiny eel influenza virus] | diamond | 1416 | 576 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Zebrafish influenza B-like virus | |||
| 30555197 | 30555197 | PRJNA662254_P_NODE_873_length_1831_cov_40.051195_g685_i0 | PRJNA662254 | 873 | 1831 | 40.051195 | 733.33738045 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 713 | 1.09e-251 | NR | AVM87624.1 | RQ01 | g685 | i0 | 62.6 | 0.932277444019661 | 569 | 209 | 93.1 | 3 | 75 | 1778 | 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);;