contig_metadata
13 rows where bioproject = "PRJNA745553", tax_kingdom = "Orthornavirae" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 724050 | 724050 | PRJNA745553_S_NODE_14401_length_324_cov_6.163347_g14206_i0 | PRJNA745553 | 14401 | 324 | 6.163347 | 19.96924428 | Dolerus tritici iflavirus 1 | 3350209 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|2833733277|gb|PQ323359.2| | 3350209 | g14206 | i0 | 100 | 0.354938271604938 | 30 | 0 | 9 | 0 | 1 | 30 | 56 | 85 | 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 | ||
| 5827920 | 5827920 | PRJNA745553_S_NODE_27505_length_236_cov_3.055215_g27310_i0 | PRJNA745553 | 27505 | 236 | 3.055215 | 7.2103074 | Nepovirus cycas | 3047785 | Viruses | Viruses | 383 | 6.61e-102 | NTclustered | gi|92019086|dbj|AB237656.1| | 173976 | g27310 | i0 | 96.154 | 52.7923728813559 | 234 | 9 | 99 | 0 | 1 | 234 | 2153 | 1920 | Cycas necrotic stunt virus gene for coat protein, partial cds | blastn | 12459 | 383 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Nepovirus | Nepovirus cycas | ||
| 5827951 | 5827951 | PRJNA745553_S_NODE_29725_length_214_cov_4.914894_g29530_i0 | PRJNA745553 | 29725 | 214 | 4.914894 | 10.51787316 | Dolerus tritici iflavirus 1 | 3350209 | Viruses | Viruses | 52.8 | 0.019 | NTclustered | gi|2833733277|gb|PQ323359.2| | 3350209 | g29530 | i0 | 100 | 0.130841121495327 | 28 | 0 | 13 | 0 | 187 | 214 | 86 | 59 | Dolerus tritici iflavirus 1 isolate HN-WS polyprotein gene, complete cds | blastn | 28 | 52.8 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | Dolerus tritici iflavirus 1 | ||
| 9652493 | 9652493 | PRJNA745553_S_NODE_12888_length_342_cov_4.884758_g12693_i0 | PRJNA745553 | 12888 | 342 | 4.884758 | 16.70587236 | Skokie dicistro-like virus | 2789443 | Viruses | Viruses | 514 | 3.43e-141 | NTclustered | gi|2806502719|gb|PQ054859.1| | 2789443 | g12693 | i0 | 100 | 1.76315789473684 | 278 | 0 | 81 | 0 | 18 | 295 | 5046 | 5323 | MAG: Skokie dicistro-like virus isolate QJ5MS4721 genomic sequence | blastn | 603 | 514 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Skokie dicistro-like virus | |||
| 10928144 | 10928144 | PRJNA745553_S_NODE_19089_length_283_cov_1.690476_g18894_i0 | PRJNA745553 | 19089 | 283 | 1.690476 | 4.78404708 | Dolerus tritici iflavirus 1 | 3350209 | Viruses | Viruses | 52.8 | 0.026 | NTclustered | gi|2833733277|gb|PQ323359.2| | 3350209 | g18894 | i0 | 100 | 0.0989399293286219 | 28 | 0 | 10 | 0 | 256 | 283 | 86 | 59 | Dolerus tritici iflavirus 1 isolate HN-WS polyprotein gene, complete cds | blastn | 28 | 52.8 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | Dolerus tritici iflavirus 1 | ||
| 10928154 | 10928154 | PRJNA745553_S_NODE_19849_length_277_cov_4.897059_g19654_i0 | PRJNA745553 | 19849 | 277 | 4.897059 | 13.56485343 | Dolerus tritici iflavirus 1 | 3350209 | Viruses | Viruses | 52.8 | 0.025 | NTclustered | gi|2833733277|gb|PQ323359.2| | 3350209 | g19654 | i0 | 100 | 0.101083032490975 | 28 | 0 | 10 | 0 | 1 | 28 | 59 | 86 | Dolerus tritici iflavirus 1 isolate HN-WS polyprotein gene, complete cds | blastn | 28 | 52.8 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | Dolerus tritici iflavirus 1 | ||
| 13478008 | 13478008 | PRJNA745553_S_NODE_2191_length_639_cov_5.393993_g2017_i0 | PRJNA745553 | 2191 | 639 | 5.393993 | 34.46761527 | Logan nepovirus | 3115782 | Viruses | Viruses | 972 | 0 | NTclustered | gi|2752247874|tpg|BK065094.1| | 3115782 | g2017 | i0 | 95.559 | 54.1799687010955 | 608 | 25 | 95 | 1 | 34 | 639 | 8213 | 7606 | TPA_asm: Logan nepovirus segment RNA1 polyprotein gene, complete cds | blastn | 34621 | 972 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Nepovirus | Logan nepovirus | ||
| 14753161 | 14753161 | PRJNA745553_S_NODE_2632_length_610_cov_2.648045_g2453_i0 | PRJNA745553 | 2632 | 610 | 2.648045 | 16.1530745 | Dill cryptic virus 1 | 1408895 | Viruses | Viruses | 994 | 0 | NTclustered | gi|551701374|gb|KF484727.1| | 1408895 | g2453 | i0 | 96.066 | 2 | 610 | 24 | 100 | 0 | 1 | 610 | 74 | 683 | Dill cryptic virus 1 isolate IPP_hortorum segment 2, complete sequence | blastn | 1220 | 994 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Dill cryptic virus 1 | |||
| 16026633 | 16026633 | PRJNA745553_S_NODE_11453_length_362_cov_1.307958_g11258_i0 | PRJNA745553 | 11453 | 362 | 1.307958 | 4.73480796 | Rabovirus dehomo | 3432093 | Viruses | Viruses | 492 | 1.71e-134 | NTclustered | gi|2047105450|ref|NC_055160.1| | 2682606 | g11258 | i0 | 93.155 | 0.92817679558011 | 336 | 22 | 93 | 1 | 28 | 362 | 7110 | 6775 | Rabovirus D1 isolate MPV/NYC/2014/M005/0074, partial genome | blastn | 336 | 492 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Rabovirus | Rabovirus dehomo | ||
| 18575779 | 18575779 | PRJNA745553_S_NODE_15795_length_310_cov_3.489451_g15600_i0 | PRJNA745553 | 15795 | 310 | 3.489451 | 10.8172981 | Periplaneta americana dicistro-like virus | 3032225 | Viruses | Viruses | 202 | 2.7199999999999992e-47 | NTclustered | gi|2754804027|tpg|BK063169.1| | 3032225 | g15600 | i0 | 98.276 | 0.374193548387097 | 116 | 1 | 37 | 1 | 2 | 116 | 4552 | 4667 | TPA_asm: Periplaneta americana dicistro-like virus hypothetical protein gene, partial cds | blastn | 116 | 202 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Periplaneta americana dicistro-like virus | |||
| 22401814 | 22401814 | PRJNA745553_S_NODE_4458_length_523_cov_5.071111_g4268_i0 | PRJNA745553 | 4458 | 523 | 5.071111 | 26.52191053 | Polerovirus BWYV | 3431732 | Viruses | Viruses | 534 | 4.18e-147 | NTclustered | gi|666669709|dbj|AB903038.1| | 12042 | g4268 | i0 | 85.465 | 22.7055449330784 | 516 | 72 | 98 | 3 | 1 | 513 | 1477 | 962 | Beet western yellows virus genomic RNA, nearly complete genome, strain: BWYV-Ashoro | blastn | 11875 | 534 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Solemoviridae | Polerovirus | Polerovirus BWYV | ||
| 23677393 | 23677393 | PRJNA745553_S_NODE_439_length_963_cov_4.449438_g360_i0 | PRJNA745553 | 439 | 963 | 4.449438 | 42.84808794 | Rabovirus dehomo | 3432093 | Viruses | Viruses | 889 | 0 | NTclustered | gi|2047105450|ref|NC_055160.1| | 2682606 | g360 | i0 | 83.403 | 3.06126687435099 | 958 | 159 | 99 | 0 | 4 | 961 | 965 | 8 | Rabovirus D1 isolate MPV/NYC/2014/M005/0074, partial genome | blastn | 2948 | 889 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Rabovirus | Rabovirus dehomo | ||
| 27369165 | 27369165 | PRJNA745553_S_NODE_25023_length_248_cov_1.760000_g24828_i0 | PRJNA745553 | 25023 | 248 | 1.76 | 4.3648 | Sclerotinia sclerotiorum fusarivirus 2 | 2822941 | Viruses | Viruses | 171 | 3.839999999999999e-47 | NR | QUE49153.1 | 2822941 | g24828 | i0 | 97.6 | 5.95161290322581 | 82 | 2 | 99.2 | 0 | 248 | 3 | 627 | 708 | QUE49153.1 MAG: polyprotein [Sclerotinia sclerotiorum fusarivirus 2] | diamond | 1476 | 171 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Fusariviridae | Sclerotinia sclerotiorum fusarivirus 2 |
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);;