contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA982106" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4792122 | 4792122 | PRJNA982106_P_NODE_4_length_9164_cov_18.789792_g1_i0 | PRJNA982106 | 4 | 9164 | 18.789792 | 1721.89653888 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 1885 | 0 | NR | WWV86902.1 | 1530251 | g1 | i0 | 72 | 0.42099519860323 | 1286 | 348 | 41.8 | 7 | 1801 | 5628 | 2 | 1285 | WWV86902.1 MAG: hypothetical protein, partial [Picornaviridae sp.] | diamond | 3858 | 1885 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 26715377 | 26715377 | PRJNA982106_P_NODE_2961_length_508_cov_1.482759_g2722_i0 | PRJNA982106 | 2961 | 508 | 1.482759 | 7.53241572 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 291 | 2.4099999999999998e-95 | NR | AXG64379.1 | RQ01 | g2722 | i0 | 87.6 | 6.98622047244094 | 169 | 21 | 99.8 | 0 | 2 | 508 | 18 | 186 | AXG64379.1 nucleoprotein, partial [Influenza B virus] | diamond | 3549 | 291 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Betainfluenzavirus | Zebrafish influenza B-like virus | ||
| 28194745 | 28194745 | PRJNA982106_P_NODE_28406_length_244_cov_0.900585_g28166_i0 | PRJNA982106 | 28406 | 244 | 0.900585 | 2.1974274 | Spring viraemia of carp virus | 696863 | Viruses | Viruses | 118 | 2.19e-29 | NR | NP_116744.1 | 696863 | g28166 | i0 | 71.6 | 2.98770491803279 | 81 | 23 | 99.6 | 0 | 2 | 244 | 222 | 302 | NP_116744.1 nucleocapsid protein [Sprivivirus cyprinus] | diamond | 729 | 118 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Sprivivirus | Spring viraemia of carp virus | ||
| 29205483 | 29205483 | PRJNA982106_P_NODE_24009_length_248_cov_0.880000_g23769_i0 | PRJNA982106 | 24009 | 248 | 0.88 | 2.1824 | Spring viraemia of carp virus | 696863 | Viruses | Viruses | 123 | 1.52e-30 | NR | NP_116748.1 | 696863 | g23769 | i0 | 80.5 | 0.991935483870968 | 82 | 16 | 99.2 | 0 | 1 | 246 | 1748 | 1829 | NP_116748.1 polymerase [Sprivivirus cyprinus] | diamond | 246 | 123 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Sprivivirus | Spring viraemia of carp virus | ||
| 29495453 | 29495453 | PRJNA982106_P_NODE_16850_length_272_cov_1.547739_g16610_i0 | PRJNA982106 | 16850 | 272 | 1.547739 | 4.20985008 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 173 | 2.7799999999999995e-48 | NR | NP_056659.1 | RQ01 | g16610 | i0 | 92.2 | 18.8602941176471 | 90 | 7 | 99.3 | 0 | 3 | 272 | 570 | 659 | NP_056659.1 polymerase PA [Influenza B virus (B/Lee/1940)] | diamond | 5130 | 173 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Betainfluenzavirus | Zebrafish influenza B-like virus | ||
| 29552387 | 29552387 | PRJNA982106_P_NODE_26190_length_246_cov_0.890173_g25950_i0 | PRJNA982106 | 26190 | 246 | 0.890173 | 2.18982558 | Spring viraemia of carp virus | 696863 | Viruses | Viruses | 102 | 2.86e-23 | NR | NP_116748.1 | 696863 | g25950 | i0 | 65.4 | 0.98780487804878 | 81 | 28 | 98.8 | 0 | 3 | 245 | 1828 | 1908 | NP_116748.1 polymerase [Sprivivirus cyprinus] | diamond | 243 | 102 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Sprivivirus | Spring viraemia of carp virus | ||
| 30184263 | 30184263 | PRJNA982106_P_NODE_32272_length_241_cov_0.916667_g32032_i0 | PRJNA982106 | 32272 | 241 | 0.916667 | 2.20916747 | Spring viraemia of carp virus | 696863 | Viruses | Viruses | 118 | 7.6e-29 | NR | NP_116748.1 | 696863 | g32032 | i0 | 72.2 | 0.983402489626556 | 79 | 22 | 98.3 | 0 | 3 | 239 | 1825 | 1903 | NP_116748.1 polymerase [Sprivivirus cyprinus] | diamond | 237 | 118 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Sprivivirus | Spring viraemia of carp virus | ||
| 31131879 | 31131879 | PRJNA982106_P_NODE_31195_length_242_cov_0.911243_g30955_i0 | PRJNA982106 | 31195 | 242 | 0.911243 | 2.20520806 | Spring viraemia of carp virus | 696863 | Viruses | Viruses | 118 | 1.4999999999999996e-29 | NR | NP_116744.1 | 696863 | g30955 | i0 | 78.2 | 1.93388429752066 | 78 | 17 | 96.7 | 0 | 2 | 235 | 3 | 80 | NP_116744.1 nucleocapsid protein [Sprivivirus cyprinus] | diamond | 468 | 118 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Sprivivirus | Spring viraemia of carp virus | ||
| 31638062 | 31638062 | PRJNA982106_P_NODE_2476_length_552_cov_1.202505_g2238_i0 | PRJNA982106 | 2476 | 552 | 1.202505 | 6.6378276 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 217 | 7.87e-66 | NR | 7XVR_A | RQ01 | g2238 | i0 | 61.7 | 1.98913043478261 | 183 | 70 | 99.5 | 0 | 550 | 2 | 172 | 354 | 7XVR_A Chain A, Neuraminidase [Wuhan spiny eel influenza virus] | diamond | 1098 | 217 | 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);;