contig_metadata
12 rows where bioproject = "PRJNA1112809" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7871718 | 7871718 | PRJNA1112809_P_NODE_118287_length_299_cov_2.504425_g115012_i0 | PRJNA1112809 | 118287 | 299 | 2.504425 | 7.48823075 | Hodnevirus arvenecus | 3429420 | Viruses | Viruses | 206 | 2.02e-48 | NTclustered | gi|2497516987|ref|NC_074588.1| | 2786153 | g115012 | i0 | 80.069 | 0.973244147157191 | 291 | 47 | 95 | 7 | 17 | 299 | 323 | 36 | SsRNA phage Gephyllon.3_13 genomic sequence | blastn | 291 | 206 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Timlovirales | Steitzviridae | Hodnevirus | Hodnevirus arvenecus | ||
| 23171759 | 23171759 | PRJNA1112809_P_NODE_148139_length_265_cov_1.901042_g144864_i0 | PRJNA1112809 | 148139 | 265 | 1.901042 | 5.0377613 | Skomarfal virus 41 | 3063341 | Viruses | Viruses | 368 | 2.12e-97 | NTclustered | gi|2626079977|gb|OR270559.1| | 3063341 | g144864 | i0 | 91.985 | 1.97735849056604 | 262 | 21 | 99 | 0 | 4 | 265 | 919 | 658 | MAG: Skomarfal virus 41 isolate MSK8 genomic sequence | blastn | 524 | 368 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Magsaviricetes | Nodamuvirales | Skomarfal virus 41 | ||||
| 27121935 | 27121935 | PRJNA1112809_P_NODE_131282_length_283_cov_1.376190_g128007_i0 | PRJNA1112809 | 131282 | 283 | 1.37619 | 3.8946177 | Durnavirales | 2732549 | Viruses | Viruses | 89 | 2.99e-18 | NR | AWV67005.1 | 2169481 | g128007 | i0 | 60.6 | 1.37809187279152 | 66 | 26 | 70 | 0 | 82 | 279 | 5 | 70 | AWV67005.1 RdRp, partial [Lysoka partiti-like virus] | diamond | 390 | 89 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Picobirnaviridae | Lysoka partiti-like virus | |||
| 27920681 | 27920681 | PRJNA1112809_P_NODE_182885_length_244_cov_2.298246_g179610_i0 | PRJNA1112809 | 182885 | 244 | 2.298246 | 5.60772024 | Yanbian Narna tick virus 1 | 2972247 | Viruses | Viruses | 67.4 | 7.85e-11 | NR | UYL95396.1 | 2972247 | g179610 | i0 | 54.8 | 0.762295081967213 | 62 | 25 | 72.5 | 1 | 67 | 243 | 421 | 482 | UYL95396.1 MAG: RNA-dependent RNA polymerase [Yanbian Narna tick virus 1] | diamond | 186 | 67.4 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Yanbian Narna tick virus 1 | |||
| 27983887 | 27983887 | PRJNA1112809_P_NODE_76245_length_396_cov_1.368421_g72970_i0 | PRJNA1112809 | 76245 | 396 | 1.368421 | 5.41894716 | Melon mild mottle virus | 669377 | Viruses | Viruses | 86.3 | 1.25e-16 | NR | YP_009507922.1 | 669377 | g72970 | i0 | 36.9 | 0.984848484848485 | 130 | 79 | 97 | 2 | 389 | 6 | 348 | 476 | YP_009507922.1 polyprotein [Melon mild mottle virus] | diamond | 390 | 86.3 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Nepovirus | Nepovirus cucumis | ||
| 28647076 | 28647076 | PRJNA1112809_P_NODE_22907_length_1065_cov_2.915323_g20174_i0 | PRJNA1112809 | 22907 | 1065 | 2.915323 | 31.04818995 | Lysoka partiti-like virus | 2169481 | Viruses | Viruses | 351 | 1.22e-114 | NR | AWV67005.1 | 2169481 | g20174 | i0 | 61.2 | 1.57746478873239 | 281 | 108 | 79.2 | 1 | 222 | 1064 | 5 | 284 | AWV67005.1 RdRp, partial [Lysoka partiti-like virus] | diamond | 1680 | 351 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Picobirnaviridae | Lysoka partiti-like virus | |||
| 28710293 | 28710293 | PRJNA1112809_P_NODE_85367_length_366_cov_2.525597_g82092_i0 | PRJNA1112809 | 85367 | 366 | 2.525597 | 9.24368502 | Mitoviridae sp. | 2809572 | Viruses | Viruses | 46.2 | 0.00883 | NR | WAK72391.1 | 2809572 | g82092 | i0 | 34.7 | 0.614754098360656 | 75 | 49 | 61.5 | 0 | 364 | 140 | 511 | 585 | WAK72391.1 MAG: RNA-dependent RNA polymerase [Mitoviridae sp.] | diamond | 225 | 46.2 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitoviridae sp. | |||
| 29332738 | 29332738 | PRJNA1112809_P_NODE_131169_length_283_cov_1.466667_g127894_i0 | PRJNA1112809 | 131169 | 283 | 1.466667 | 4.15066761 | Chuvivirus | 2842604 | Viruses | Viruses | 140 | 3.4599999999999997e-37 | NR | WET19887.1 | 2842604 | g127894 | i0 | 68.8 | 1.97173144876325 | 93 | 29 | 98.6 | 0 | 279 | 1 | 296 | 388 | WET19887.1 MAG: nucleoprotein [Freshwater turtle neural virus 1] | diamond | 558 | 140 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Chuvivirus | Chuvivirus | ||
| 29341679 | 29341679 | PRJNA1112809_P_NODE_189429_length_242_cov_1.272189_g186154_i0 | PRJNA1112809 | 189429 | 242 | 1.272189 | 3.07869738 | Malassezia restricta associated totivirus 1 | 3048757 | Viruses | Viruses | 159 | 1.6499999999999999e-43 | NR | CAI9858976.1 | 3048757 | g186154 | i0 | 95 | 0.991735537190083 | 80 | 4 | 99.2 | 0 | 240 | 1 | 205 | 284 | CAI9858976.1 polyprotein, partial [Malassezia restricta associated totivirus 1] | diamond | 240 | 159 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta associated totivirus 1 | ||
| 29341731 | 29341731 | PRJNA1112809_P_NODE_86009_length_365_cov_0.941781_g82734_i0 | PRJNA1112809 | 86009 | 365 | 0.941781 | 3.43750065 | Totiviridae sp. | 1955172 | Viruses | Viruses | 156 | 1.19e-41 | NR | WAK77569.1 | 1955172 | g82734 | i0 | 64.4 | 0.96986301369863 | 118 | 42 | 97 | 0 | 355 | 2 | 22 | 139 | WAK77569.1 MAG: capsid protein [Totiviridae sp.] | diamond | 354 | 156 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Totiviridae sp. | |||
| 29910125 | 29910125 | PRJNA1112809_P_NODE_36331_length_702_cov_1.616852_g33166_i0 | PRJNA1112809 | 36331 | 702 | 1.616852 | 11.35030104 | Potato black ringspot virus | 257464 | Viruses | Viruses | 50.8 | 0.00272 | NR | AGZ62583.1 | 257464 | g33166 | i0 | 27.6 | 0.448717948717949 | 105 | 76 | 44.9 | 0 | 419 | 105 | 582 | 686 | AGZ62583.1 RNA 2 polyprotein [Potato black ringspot virus] | diamond | 315 | 50.8 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Nepovirus | Nepovirus solani | ||
| 31458534 | 31458534 | PRJNA1112809_P_NODE_171776_length_248_cov_1.754286_g168501_i0 | PRJNA1112809 | 171776 | 248 | 1.754286 | 4.35062928 | Totiviridae sp. | 1955172 | Viruses | Viruses | 106 | 1.75e-24 | NR | WAK77569.1 | 1955172 | g168501 | i0 | 57.3 | 0.991935483870968 | 82 | 35 | 99.2 | 0 | 2 | 247 | 462 | 543 | WAK77569.1 MAG: capsid protein [Totiviridae sp.] | diamond | 246 | 106 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Totiviridae 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);;