contig_metadata
9 rows where bioproject = "PRJNA835051" and tax_phylum = "Pisuviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 825447 | 825447 | PRJNA835051_S_NODE_11621_length_314_cov_1.571956_g11325_i0 | PRJNA835051 | 11621 | 314 | 1.571956 | 4.93594184 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 54.7 | 0.008 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g11325 | i0 | 100 | 0.181528662420382 | 29 | 0 | 9 | 0 | 1 | 29 | 13 | 41 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 3376316 | 3376316 | PRJNA835051_S_NODE_120263_length_156_cov_2.097345_g119967_i0 | PRJNA835051 | 120263 | 156 | 2.097345 | 3.2718582 | Nepovirus poaceae | 3052358 | Viruses | Viruses | 255 | 9.12e-64 | NTclustered | gi|2500669168|ref|NC_078655.1| | 2822470 | g119967 | i0 | 96.154 | 1 | 156 | 6 | 100 | 0 | 1 | 156 | 3825 | 3980 | Poaceae Liege nepovirus A isolate Antheit polyprotein (QK751_sRNA2gp1) gene, complete cds | blastn | 156 | 255 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Nepovirus | Nepovirus poaceae | ||
| 5929664 | 5929664 | PRJNA835051_S_NODE_80965_length_184_cov_1.262411_g80669_i0 | PRJNA835051 | 80965 | 184 | 1.262411 | 2.32283624 | Dolerus tritici iflavirus 1 | 3350209 | Viruses | Viruses | 56.5 | 0.001 | NTclustered | gi|2833733277|gb|PQ323359.2| | 3350209 | g80669 | i0 | 100 | 0.625 | 30 | 0 | 16 | 0 | 155 | 184 | 85 | 56 | Dolerus tritici iflavirus 1 isolate HN-WS polyprotein gene, complete cds | blastn | 115 | 56.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | Dolerus tritici iflavirus 1 | ||
| 7204794 | 7204794 | PRJNA835051_S_NODE_82946_length_182_cov_1.719424_g82650_i0 | PRJNA835051 | 82946 | 182 | 1.719424 | 3.12935168 | Nepovirus poaceae | 3052358 | Viruses | Viruses | 309 | 8.32e-80 | NTclustered | gi|2500669170|ref|NC_078656.1| | 2822470 | g82650 | i0 | 97.253 | 2 | 182 | 5 | 100 | 0 | 1 | 182 | 7039 | 7220 | Poaceae Liege nepovirus A isolate Antheit polyprotein (QK751_sRNA1gp1) gene, complete cds | blastn | 364 | 309 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Nepovirus | Nepovirus poaceae | ||
| 12304952 | 12304952 | PRJNA835051_S_NODE_23070_length_267_cov_1.955357_g22774_i0 | PRJNA835051 | 23070 | 267 | 1.955357 | 5.22080319 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 54.7 | 0.007 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g22774 | i0 | 100 | 0.213483146067416 | 29 | 0 | 11 | 0 | 1 | 29 | 13 | 41 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 12305284 | 12305284 | PRJNA835051_S_NODE_46350_length_222_cov_1.061453_g46054_i0 | PRJNA835051 | 46350 | 222 | 1.061453 | 2.35642566 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 58.4 | 4.23e-4 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g46054 | i0 | 94.737 | 0.297297297297297 | 38 | 1 | 17 | 1 | 1 | 37 | 13 | 50 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 66 | 58.4 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 18676657 | 18676657 | PRJNA835051_S_NODE_10255_length_324_cov_1.604982_g9959_i0 | PRJNA835051 | 10255 | 324 | 1.604982 | 5.20014168 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 54.7 | 0.008 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g9959 | i0 | 100 | 0.175925925925926 | 29 | 0 | 9 | 0 | 1 | 29 | 13 | 41 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 19952819 | 19952819 | PRJNA835051_S_NODE_68596_length_195_cov_2.177632_g68300_i0 | PRJNA835051 | 68596 | 195 | 2.177632 | 4.2463824 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 54.7 | 0.005 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g68300 | i0 | 100 | 0.292307692307692 | 29 | 0 | 15 | 0 | 1 | 29 | 13 | 41 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 22502140 | 22502140 | PRJNA835051_S_NODE_101838_length_168_cov_1.528000_g101542_i0 | PRJNA835051 | 101838 | 168 | 1.528 | 2.56704 | Partitiviridae sp. | 1955170 | Viruses | Viruses | 274 | 2.7699999999999997e-69 | NTclustered | gi|2120560198|gb|MZ556410.1| | 1955170 | g101542 | i0 | 96.386 | 3.97619047619048 | 166 | 6 | 99 | 0 | 1 | 166 | 1515 | 1680 | MAG: Partitiviridae sp. isolate 248-k141_5206 putative RNA-dependent RNA polymerase gene, partial cds | blastn | 668 | 274 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Partitiviridae sp. |
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);;