contig_metadata
6 rows where bioproject = "PRJNA728642" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1194961 | 1194961 | PRJNA728642_P_NODE_1_length_7420_cov_5.861440_g0_i0 | PRJNA728642 | 1 | 7420 | 5.86144 | 434.918848 | Orthoavulavirus | 2560194 | Viruses | Viruses | 13692 | 0 | NTclustered | gi|1852396255|gb|MN862503.1| | 159079 | g0 | i0 | 99.973 | 99.9537735849057 | 7420 | 2 | 100 | 0 | 1 | 7420 | 1723 | 9142 | Pigeon paramyxovirus 1 strain Pigeon/Shandong/LCE4/2016, complete genome | blastn | 741657 | 13692 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthoavulavirus | Orthoavulavirus javaense | ||
| 6299140 | 6299140 | PRJNA728642_P_NODE_5_length_6065_cov_6.578939_g4_i0 | PRJNA728642 | 5 | 6065 | 6.578939 | 399.01265035 | Orthoavulavirus | 2560194 | Viruses | Viruses | 11201 | 0 | NTclustered | gi|1852396262|gb|MN862504.1| | 159079 | g4 | i0 | 100 | 99.8966199505359 | 6065 | 0 | 100 | 0 | 1 | 6065 | 15177 | 9113 | Pigeon paramyxovirus 1 strain Pigeon/Shandong/LC/2017, complete genome | blastn | 605873 | 11201 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthoavulavirus | Orthoavulavirus javaense | ||
| 7572915 | 7572915 | PRJNA728642_P_NODE_386_length_1647_cov_6.378018_g246_i0 | PRJNA728642 | 386 | 1647 | 6.378018 | 105.04595646 | Orthoavulavirus | 2560194 | Viruses | Viruses | 3042 | 0 | NTclustered | gi|1852396255|gb|MN862503.1| | 159079 | g246 | i0 | 100 | 98.8348512446873 | 1647 | 0 | 100 | 0 | 1 | 1647 | 25 | 1671 | Pigeon paramyxovirus 1 strain Pigeon/Shandong/LCE4/2016, complete genome | blastn | 162781 | 3042 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthoavulavirus | Orthoavulavirus javaense | ||
| 8847929 | 8847929 | PRJNA728642_P_NODE_13727_length_272_cov_1.010050_g13456_i0 | PRJNA728642 | 13727 | 272 | 1.01005 | 2.7473359999999998 | Orthoavulavirus | 2560194 | Viruses | Viruses | 501 | 2.06e-137 | NTclustered | gi|1852396276|gb|MN862506.1| | 159079 | g13456 | i0 | 100 | 99.9889705882353 | 271 | 0 | 99 | 0 | 1 | 271 | 11232 | 11502 | Pigeon paramyxovirus 1 strain Pigeon/Shandong/190610-2/2019, complete genome | blastn | 27197 | 503 | 0.996023856858847 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthoavulavirus | Orthoavulavirus javaense | ||
| 10916913 | 10916913 | PRJNA728642_P_NODE_18649_length_243_cov_1.211765_g18378_i0 | PRJNA728642 | 18649 | 243 | 1.211765 | 2.94458895 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 444 | 3.09e-120 | NTclustered | gi|1798036485|gb|MN948960.1| | RQ01 | g18378 | i0 | 99.588 | 100 | 243 | 1 | 100 | 0 | 1 | 243 | 2209 | 1967 | Influenza A virus (A/Pennsylvania/1026/2019(H3N2)) segment 3 polymerase PA (PA) and PA-X protein (PA-X) genes, complete cds | blastn | 24300 | 444 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Zebrafish influenza B-like virus | ||
| 12192100 | 12192100 | PRJNA728642_P_NODE_13230_length_277_cov_0.975490_g12959_i0 | PRJNA728642 | 13230 | 277 | 0.97549 | 2.7021073 | Orthoavulavirus javaense | 3051375 | Viruses | Viruses | 507 | 4.53e-139 | NTclustered | gi|2161956354|gb|MW271787.1| | 2560319 | g12959 | i0 | 99.639 | 100 | 277 | 1 | 100 | 0 | 1 | 277 | 7405 | 7681 | Avian paramyxovirus 1 isolate JS/09/16/Pi nucleoprotein (NP), phosphorprotein (P), matrix protein (M), fusion protein (F), hemagglutinin-neuraminidase (HN), and large polymerase protein (L) genes, complete cds | blastn | 27700 | 507 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthoavulavirus | Orthoavulavirus javaense |
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);;