contig_metadata
6 rows where bioproject = "PRJNA1166865" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5416656 | 5416656 | PRJNA1166865_P_NODE_70565_length_261_cov_1.601064_g70324_i0 | PRJNA1166865 | 70565 | 261 | 1.601064 | 4.17877704 | Potyvirus sacchari | 3240610 | Viruses | Viruses | 52.8 | 0.024 | NTclustered | gi|1766756986|gb|MK684196.1| | 12224 | g70324 | i0 | 100 | 0.10727969348659 | 28 | 0 | 11 | 0 | 209 | 236 | 622 | 595 | Sugarcane mosaic virus isolate RwS17_002 polyprotein gene, partial cds | blastn | 28 | 52.8 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Potyvirus | Potyvirus sacchari | ||
| 6142406 | 6142406 | PRJNA1166865_P_NODE_2085_length_1263_cov_6.807563_g1991_i0 | PRJNA1166865 | 2085 | 1263 | 6.807563 | 85.97952069 | Orthorubulavirus | 2560195 | Viruses | Viruses | 2314 | 0 | NTclustered | gi|2449300967|gb|ON241249.1| | 2560580 | g1991 | i0 | 99.762 | 84.507521773555 | 1263 | 1 | 100 | 1 | 1 | 1263 | 1776 | 3036 | Mammalian orthorubulavirus 5 isolate ATCC HTB-55 batch no 70037771, complete genome | blastn | 106733 | 2327 | 0.994413407821229 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 7417542 | 7417542 | PRJNA1166865_P_NODE_886_length_1631_cov_6.725289_g829_i0 | PRJNA1166865 | 886 | 1631 | 6.725289 | 109.68946359 | Orthorubulavirus | 2560195 | Viruses | Viruses | 2979 | 0 | NTclustered | gi|146351838|gb|EF543648.1| | 149595 | g829 | i0 | 99.632 | 76.4794604537094 | 1631 | 6 | 100 | 0 | 1 | 1631 | 2 | 1632 | Canine parainfluenza virus strain FA nucleocapsid (N) gene, complete cds | blastn | 124738 | 2985 | 0.997989949748744 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Canine parainfluenza virus | |||
| 11242846 | 11242846 | PRJNA1166865_P_NODE_2729_length_1148_cov_5.747907_g2618_i0 | PRJNA1166865 | 2729 | 1148 | 5.747907 | 65.98597236 | Paramyxoviridae | 11158 | Viruses | Viruses | 2104 | 0 | NTclustered | gi|2721617856|gb|PP711545.1| | 251774 | g2618 | i0 | 99.739 | 68.9477351916376 | 1148 | 3 | 100 | 0 | 1 | 1148 | 2057 | 3204 | Porcine parainfluenza virus isolate PPIV-DX-Gansu-2020, partial genome | blastn | 79152 | 2115 | 0.994799054373522 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Rubulavirus | Porcine parainfluenza virus | ||
| 21441593 | 21441593 | PRJNA1166865_P_NODE_737_length_1714_cov_4.862279_g690_i0 | PRJNA1166865 | 737 | 1714 | 4.862279 | 83.33946206 | Orthorubulavirus | 2560195 | Viruses | Viruses | 3155 | 0 | NTclustered | gi|2449300967|gb|ON241249.1| | 2560580 | g690 | i0 | 99.883 | 97.0933488914819 | 1714 | 2 | 100 | 0 | 1 | 1714 | 6203 | 4490 | Mammalian orthorubulavirus 5 isolate ATCC HTB-55 batch no 70037771, complete genome | blastn | 166418 | 3155 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 26945416 | 26945416 | PRJNA1166865_P_NODE_61582_length_282_cov_1.392344_g61341_i0 | PRJNA1166865 | 61582 | 282 | 1.392344 | 3.92641008 | African cichlid piscichuvirus | 3065075 | Viruses | Viruses | 82 | 9.73e-16 | NR | WLN26256.1 | 3065075 | g61341 | i0 | 45.3 | 1.01063829787234 | 95 | 50 | 98.9 | 1 | 279 | 1 | 117 | 211 | WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus] | diamond | 285 | 82 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Piscichuvirus | African cichlid piscichuvirus |
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);;