contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA884104" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8513036 | 8513036 | PRJNA884104_S_NODE_10527_length_622_cov_1.766849_g9810_i0 | PRJNA884104 | 10527 | 622 | 1.766849 | 10.98980078 | Prunus persica marafivirus | 3120871 | Viruses | Viruses | 316 | 6.889999999999998e-96 | NR | WVW91581.1 | 3120871 | g9810 | i0 | 77.9 | 0.983922829581994 | 204 | 45 | 98.4 | 0 | 613 | 2 | 134 | 337 | WVW91581.1 MAG: polyprotein, partial [Prunus persica marafivirus] | diamond | 612 | 316 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | Marafivirus | Prunus persica marafivirus | ||
| 14888766 | 14888766 | PRJNA884104_S_NODE_42692_length_318_cov_0.963265_g41949_i0 | PRJNA884104 | 42692 | 318 | 0.963265 | 3.0631827 | Glehnia littoralis marafivirus | 2765859 | Viruses | Viruses | 147 | 1.25e-38 | NR | DAF42470.1 | 2765859 | g41949 | i0 | 67.6 | 2.97169811320755 | 105 | 34 | 99.1 | 0 | 2 | 316 | 224 | 328 | DAF42470.1 TPA_exp: polyprotein [Glehnia littoralis marafivirus] | diamond | 945 | 147 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | Marafivirus | Glehnia littoralis marafivirus | ||
| 14889641 | 14889641 | PRJNA884104_S_NODE_87732_length_228_cov_4.658065_g86989_i0 | PRJNA884104 | 87732 | 228 | 4.658065 | 10.6203882 | Prunus persica marafivirus | 3120871 | Viruses | Viruses | 116 | 3.03e-28 | NR | WVW91581.1 | 3120871 | g86989 | i0 | 80 | 0.986842105263158 | 75 | 15 | 98.7 | 0 | 226 | 2 | 366 | 440 | WVW91581.1 MAG: polyprotein, partial [Prunus persica marafivirus] | diamond | 225 | 116 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | Marafivirus | Prunus persica marafivirus | ||
| 25086239 | 25086239 | PRJNA884104_S_NODE_10220_length_632_cov_2.189624_g9507_i0 | PRJNA884104 | 10220 | 632 | 2.189624 | 13.83842368 | Prunus persica marafivirus | 3120871 | Viruses | Viruses | 392 | 5.06e-123 | NR | WVW91581.1 | 3120871 | g9507 | i0 | 88 | 0.992088607594937 | 209 | 25 | 99.2 | 0 | 632 | 6 | 845 | 1053 | WVW91581.1 MAG: polyprotein, partial [Prunus persica marafivirus] | diamond | 627 | 392 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | Marafivirus | Prunus persica marafivirus | ||
| 28223827 | 28223827 | PRJNA884104_S_NODE_45886_length_308_cov_0.982979_g45143_i0 | PRJNA884104 | 45886 | 308 | 0.982979 | 3.02757532 | ranunculus virus M | 3342089 | Viruses | Viruses | 142 | 1.16e-36 | NR | XGI00571.1 | 3342089 | g45143 | i0 | 81 | 0.769480519480519 | 79 | 15 | 76.9 | 0 | 1 | 237 | 302 | 380 | XGI00571.1 polyprotein [ranunculus virus M] | diamond | 237 | 142 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | Marafivirus | ranunculus virus M | ||
| 28508210 | 28508210 | PRJNA884104_S_NODE_16007_length_502_cov_2.223776_g15269_i0 | PRJNA884104 | 16007 | 502 | 2.223776 | 11.16335552 | African cichlid piscichuvirus | 3065075 | Viruses | Viruses | 127 | 1.39e-30 | NR | WLN26256.1 | 3065075 | g15269 | i0 | 46 | 0.818725099601594 | 137 | 74 | 81.9 | 0 | 5 | 415 | 98 | 234 | WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus] | diamond | 411 | 127 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Piscichuvirus | African cichlid piscichuvirus | ||
| 28855282 | 28855282 | PRJNA884104_S_NODE_34708_length_348_cov_2.003636_g33965_i0 | PRJNA884104 | 34708 | 348 | 2.003636 | 6.97265328 | Peach virus T | 1958978 | Viruses | Viruses | 85.1 | 1.82e-16 | NR | ARI47200.1 | 1958978 | g33965 | i0 | 83.9 | 0.482758620689655 | 56 | 9 | 48.3 | 0 | 236 | 69 | 605 | 660 | ARI47200.1 polyprotein [Peach virus T] | diamond | 168 | 85.1 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Peach virus T | ||||
| 29423585 | 29423585 | PRJNA884104_S_NODE_15809_length_505_cov_2.770833_g15071_i0 | PRJNA884104 | 15809 | 505 | 2.770833 | 13.99270665 | Prunus persica marafivirus | 3120871 | Viruses | Viruses | 307 | 1.91e-93 | NR | WVW91581.1 | 3120871 | g15071 | i0 | 86.8 | 0.992079207920792 | 167 | 22 | 99.2 | 0 | 2 | 502 | 691 | 857 | WVW91581.1 MAG: polyprotein, partial [Prunus persica marafivirus] | diamond | 501 | 307 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | Marafivirus | Prunus persica marafivirus | ||
| 30940260 | 30940260 | PRJNA884104_S_NODE_65474_length_257_cov_1.445652_g64731_i0 | PRJNA884104 | 65474 | 257 | 1.445652 | 3.71532564 | Prunus persica marafivirus | 3120871 | Viruses | Viruses | 120 | 2.06e-29 | NR | WVW91581.1 | 3120871 | g64731 | i0 | 69.9 | 0.968871595330739 | 83 | 25 | 96.9 | 0 | 6 | 254 | 1036 | 1118 | WVW91581.1 MAG: polyprotein, partial [Prunus persica marafivirus] | diamond | 249 | 120 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | Marafivirus | Prunus persica marafivirus | ||
| 31445908 | 31445908 | PRJNA884104_S_NODE_5836_length_838_cov_4.138562_g5245_i0 | PRJNA884104 | 5836 | 838 | 4.138562 | 34.68114956 | Prunus persica marafivirus | 3120871 | Viruses | Viruses | 150 | 5.09e-37 | NR | WVW91581.1 | 3120871 | g5245 | i0 | 51.6 | 0.762529832935561 | 213 | 95 | 74.8 | 3 | 836 | 210 | 1354 | 1562 | WVW91581.1 MAG: polyprotein, partial [Prunus persica marafivirus] | diamond | 639 | 150 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | Marafivirus | Prunus persica marafivirus | ||
| 31485638 | 31485638 | PRJNA884104_S_NODE_16_length_8652_cov_8.828418_g14_i0 | PRJNA884104 | 16 | 8652 | 8.828418 | 763.83472536 | Zebrafish jaw picornavirus | RQ13 | Viruses | Viruses | 551 | 1.12e-154 | NR | ADG03747.2 | RQ13 | g14 | i0 | 26.7 | 4.89320388349515 | 2348 | 1263 | 76 | 74 | 1703 | 8275 | 424 | 2464 | ADG03747.2 polyprotein [aichivirus B3] | diamond | 42336 | 551 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Kobuvirus | Zebrafish jaw picornavirus | ||
| 31698975 | 31698975 | PRJNA884104_S_NODE_76377_length_247_cov_0.885057_g75634_i0 | PRJNA884104 | 76377 | 247 | 0.885057 | 2.18609079 | Crogonang virus 12 | 3062925 | Viruses | Viruses | 53.5 | 6.06e-6 | NR | WPR18034.1 | 3062925 | g75634 | i0 | 36.7 | 0.959514170040486 | 79 | 47 | 92.3 | 1 | 230 | 3 | 647 | 725 | WPR18034.1 MAG: RNA-dependent RNA polymerase [Crogonang virus 12] | diamond | 237 | 53.5 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Crogonang virus 12 | ||||
| 31801536 | 31801536 | PRJNA884104_S_NODE_64557_length_259_cov_1.489247_g63814_i0 | PRJNA884104 | 64557 | 259 | 1.489247 | 3.85714973 | Chuvivirus | 2842604 | Viruses | Viruses | 112 | 1.03e-26 | NR | UVF58769.1 | 2842604 | g63814 | i0 | 63.5 | 3.94980694980695 | 85 | 31 | 98.5 | 0 | 4 | 258 | 284 | 368 | UVF58769.1 MAG: S protein [Salarius guttatus piscichuvirus] | diamond | 1023 | 112 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Piscichuvirus | Chuvivirus | ||
| 31856980 | 31856980 | PRJNA884104_S_NODE_4657_length_937_cov_2.031250_g4129_i0 | PRJNA884104 | 4657 | 937 | 2.03125 | 19.0328125 | Glehnia littoralis marafivirus | 2765859 | Viruses | Viruses | 200 | 9.229999999999999e-54 | NR | DAF42470.1 | 2765859 | g4129 | i0 | 45.5 | 1.32230522945571 | 277 | 134 | 83.6 | 5 | 785 | 3 | 576 | 851 | DAF42470.1 TPA_exp: polyprotein [Glehnia littoralis marafivirus] | diamond | 1239 | 200 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | Marafivirus | Glehnia littoralis marafivirus | ||
| 32458392 | 32458392 | PRJNA884104_S_NODE_51839_length_290_cov_4.046083_g51096_i0 | PRJNA884104 | 51839 | 290 | 4.046083 | 11.7336407 | African cichlid piscichuvirus | 3065075 | Viruses | Viruses | 70.9 | 8.81e-12 | NR | UVF58767.1 | 3065075 | g51096 | i0 | 48.1 | 0.837931034482759 | 81 | 41 | 82.8 | 1 | 289 | 50 | 2 | 82 | UVF58767.1 MAG: L protein [Salarius guttatus piscichuvirus] | diamond | 243 | 70.9 | 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);;