contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJEB58983" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12878246 | 12878246 | PRJEB58983_P_NODE_11_length_7976_cov_6.197900_g9_i0 | PRJEB58983 | 11 | 7976 | 6.1979 | 494.344504 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 1804 | 0 | NR | UNY42121.1 | 3003959 | g9 | i0 | 55 | 0.625501504513541 | 1663 | 711 | 62.4 | 12 | 7973 | 2997 | 113 | 1742 | UNY42121.1 MAG: polyprotein 1 [Picornavirales sp.] | diamond | 4989 | 1804 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 27033570 | 27033570 | PRJEB58983_P_NODE_4722_length_563_cov_5.477551_g4312_i0 | PRJEB58983 | 4722 | 563 | 5.477551 | 30.83861213 | Soldier fly associated narna-like virus | 3133261 | Viruses | Viruses | 193 | 1.9e-53 | NR | WXG23068.1 | 3133261 | g4312 | i0 | 49.2 | 1.99289520426288 | 187 | 95 | 99.6 | 0 | 3 | 563 | 580 | 766 | WXG23068.1 MAG: RNA-dependent RNA polymerase [Soldier fly associated narna-like virus] | diamond | 1122 | 193 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Soldier fly associated narna-like virus | |||
| 27318234 | 27318234 | PRJEB58983_P_NODE_9303_length_408_cov_3.844776_g8889_i0 | PRJEB58983 | 9303 | 408 | 3.844776 | 15.68668608 | Soybean thrips narna-like virus 1 | 2800851 | Viruses | Viruses | 129 | 1.16e-31 | NR | QQP18719.1 | 2800851 | g8889 | i0 | 51.2 | 0.919117647058823 | 125 | 60 | 91.2 | 1 | 380 | 9 | 403 | 527 | QQP18719.1 RNA-dependent RNA polymerase, partial [Soybean thrips narna-like virus 1] | diamond | 375 | 129 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Soybean thrips narna-like virus 1 | |||
| 27444721 | 27444721 | PRJEB58983_P_NODE_2223_length_845_cov_4.291451_g1860_i0 | PRJEB58983 | 2223 | 845 | 4.291451 | 36.26276095 | Narnaviridae sp. | 2583949 | Viruses | Viruses | 379 | 4.25e-122 | NR | UJQ92726.1 | 2583949 | g1860 | i0 | 71.4 | 1.00473372781065 | 283 | 79 | 99.8 | 2 | 843 | 1 | 574 | 856 | UJQ92726.1 MAG: putative RNA-dependent RNA polymerase, partial [Narnaviridae sp.] | diamond | 849 | 379 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnaviridae sp. | |||
| 27760516 | 27760516 | PRJEB58983_P_NODE_9124_length_412_cov_2.902655_g8710_i0 | PRJEB58983 | 9124 | 412 | 2.902655 | 11.9589386 | Digyalum oweni associated virus | 3004187 | Viruses | Viruses | 102 | 2.52e-22 | NR | CAI9240335.1 | 3004187 | g8710 | i0 | 43 | 0.932038834951456 | 128 | 67 | 92.5 | 2 | 382 | 2 | 670 | 792 | CAI9240335.1 polyprotein, partial [Digyalum oweni associated virus] | diamond | 384 | 102 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Digyalum oweni associated virus | ||||
| 27854847 | 27854847 | PRJEB58983_P_NODE_165_length_2622_cov_47.775991_g123_i0 | PRJEB58983 | 165 | 2622 | 47.775991 | 1252.68648402 | Narnaviridae sp. | 2583949 | Viruses | Viruses | 597 | 5.8400000000000005e-198 | NR | UJQ92801.1 | 2583949 | g123 | i0 | 42.5 | 2.83752860411899 | 835 | 459 | 94.1 | 8 | 132 | 2597 | 13 | 839 | UJQ92801.1 MAG: putative RNA-dependent RNA polymerase, partial [Narnaviridae sp.] | diamond | 7440 | 597 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnaviridae sp. | |||
| 27917967 | 27917967 | PRJEB58983_P_NODE_625_length_1631_cov_3.559692_g449_i0 | PRJEB58983 | 625 | 1631 | 3.559692 | 58.05857652 | Qianjiang dicistro-like virus 1 | 3347351 | Viruses | Viruses | 308 | 9.349999999999998e-88 | NR | XHA87906.1 | 3347355 | g449 | i0 | 36.1 | 2.06192519926425 | 560 | 329 | 98.6 | 8 | 9 | 1616 | 1963 | 2517 | XHA87906.1 MAG: polyprotein [Qianjiang dicistro-like virus 102] | diamond | 3363 | 308 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Qianjiang dicistro-like virus 102 | |||
| 28012946 | 28012946 | PRJEB58983_P_NODE_11705_length_368_cov_2.162712_g11290_i0 | PRJEB58983 | 11705 | 368 | 2.162712 | 7.95878016 | Digyalum oweni associated virus | 3004187 | Viruses | Viruses | 47 | 0.00505 | NR | CAI9240335.1 | 3004187 | g11290 | i0 | 28.8 | 1.01902173913043 | 125 | 71 | 94.6 | 4 | 363 | 16 | 226 | 341 | CAI9240335.1 polyprotein, partial [Digyalum oweni associated virus] | diamond | 375 | 47 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Digyalum oweni associated virus | ||||
| 28044310 | 28044310 | PRJEB58983_P_NODE_25385_length_263_cov_1.878947_g24970_i0 | PRJEB58983 | 25385 | 263 | 1.878947 | 4.94163061 | Leviviridae sp. | 2027243 | Viruses | Viruses | 106 | 1.22e-24 | NR | URG15349.1 | 2027243 | g24970 | i0 | 62.1 | 1.98479087452471 | 87 | 31 | 99.2 | 1 | 2 | 262 | 205 | 289 | URG15349.1 MAG: RNA dependent RNA polymerase, partial [Leviviridae sp.] | diamond | 522 | 106 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 28107342 | 28107342 | PRJEB58983_P_NODE_27865_length_253_cov_1.311111_g27450_i0 | PRJEB58983 | 27865 | 253 | 1.311111 | 3.31711083 | Hangzhou mito-like virus 9 | 3028986 | Viruses | Viruses | 77.8 | 1.93e-14 | NR | WEU70947.1 | 3028986 | g27450 | i0 | 49.4 | 0.91304347826087 | 77 | 39 | 91.3 | 0 | 231 | 1 | 25 | 101 | WEU70947.1 MAG: RNA-dependent RNA polymerase, partial [Hangzhou mito-like virus 9] | diamond | 231 | 77.8 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Hangzhou mito-like virus 9 | |||
| 28359946 | 28359946 | PRJEB58983_P_NODE_566_length_1702_cov_8.300184_g405_i0 | PRJEB58983 | 566 | 1702 | 8.300184 | 141.26913168 | Narnaviridae sp. | 2583949 | Viruses | Viruses | 898 | 0 | NR | UJQ92726.1 | 2583949 | g405 | i0 | 78.6 | 0.987074030552291 | 560 | 120 | 98.7 | 0 | 12 | 1691 | 2 | 561 | UJQ92726.1 MAG: putative RNA-dependent RNA polymerase, partial [Narnaviridae sp.] | diamond | 1680 | 898 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnaviridae sp. | |||
| 28549715 | 28549715 | PRJEB58983_P_NODE_16667_length_314_cov_3.278008_g16252_i0 | PRJEB58983 | 16667 | 314 | 3.278008 | 10.29294512 | Harrimaniidae flavivirus | 3004160 | Viruses | Viruses | 43.9 | 0.0353 | NR | CAI5755626.1 | 3004160 | g16252 | i0 | 35.7 | 0.802547770700637 | 84 | 47 | 77.4 | 4 | 27 | 269 | 1784 | 1863 | CAI5755626.1 polyprotein, partial [Harrimaniidae flavivirus] | diamond | 252 | 43.9 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Orthoflavivirus | Harrimaniidae flavivirus | ||
| 28581242 | 28581242 | PRJEB58983_P_NODE_7567_length_449_cov_4.795213_g7153_i0 | PRJEB58983 | 7567 | 449 | 4.795213 | 21.53050637 | Qianjiang dicistro-like virus 91 | 3347509 | Viruses | Viruses | 55.5 | 1.3e-5 | NR | XHA87884.1 | 3347509 | g7153 | i0 | 25.2 | 0.76837416481069 | 115 | 86 | 76.8 | 0 | 105 | 449 | 407 | 521 | XHA87884.1 MAG: polyprotein [Qianjiang dicistro-like virus 91] | diamond | 345 | 55.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Qianjiang dicistro-like virus 91 | |||
| 28833682 | 28833682 | PRJEB58983_P_NODE_848_length_1415_cov_4.379285_g624_i0 | PRJEB58983 | 848 | 1415 | 4.379285 | 61.96688275 | Mute swan feces associated picorna-like virus 6 | 2832207 | Viruses | Viruses | 268 | 7.000000000000001e-75 | NR | QUS52702.1 | 2832207 | g624 | i0 | 36.3 | 2.03533568904594 | 485 | 284 | 99.9 | 11 | 1415 | 3 | 1562 | 2035 | QUS52702.1 polyprotein [Mute swan feces associated picorna-like virus 6] | diamond | 2880 | 268 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Mute swan feces associated picorna-like virus 6 | ||||
| 29181179 | 29181179 | PRJEB58983_P_NODE_14509_length_334_cov_2.904215_g14094_i0 | PRJEB58983 | 14509 | 334 | 2.904215 | 9.7000781 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 48.5 | 0.00106 | NR | XCM67990.1 | 3003959 | g14094 | i0 | 35.2 | 0.790419161676647 | 88 | 56 | 79 | 1 | 28 | 291 | 571 | 657 | XCM67990.1 MAG: polyprotein [Picornavirales sp.] | diamond | 264 | 48.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 29332109 | 29332109 | PRJEB58983_P_NODE_31169_length_245_cov_0.906977_g30754_i0 | PRJEB58983 | 31169 | 245 | 0.906977 | 2.22209365 | Narnavirus | 186767 | Viruses | Viruses | 94 | 3.6e-20 | NR | QJT93782.1 | 2736407 | g30754 | i0 | 51.9 | 1.98367346938776 | 81 | 39 | 99.2 | 0 | 245 | 3 | 431 | 511 | QJT93782.1 RNA-dependent RNA polymerase [Erysiphe necator associated narnavirus 50] | diamond | 486 | 94 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Erysiphe necator associated narnavirus 50 | ||
| 29402047 | 29402047 | PRJEB58983_P_NODE_5209_length_538_cov_1.827957_g4796_i0 | PRJEB58983 | 5209 | 538 | 1.827957 | 9.83440866 | Mitoviridae sp. | 2809572 | Viruses | Viruses | 173 | 3.36e-47 | NR | UJQ92580.1 | 2809572 | g4796 | i0 | 48.9 | 0.981412639405205 | 176 | 84 | 98.1 | 1 | 529 | 2 | 355 | 524 | UJQ92580.1 MAG: putative RNA-dependent RNA polymerase, partial [Mitoviridae sp.] | diamond | 528 | 173 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitoviridae sp. | |||
| 29685865 | 29685865 | PRJEB58983_P_NODE_350_length_2037_cov_3.862525_g250_i0 | PRJEB58983 | 350 | 2037 | 3.862525 | 78.67963425 | Qianjiang dicistro-like virus 91 | 3347509 | Viruses | Viruses | 264 | 2.68e-71 | NR | XHA87884.1 | 3347509 | g250 | i0 | 30.7 | 0.891016200294551 | 605 | 386 | 86.9 | 13 | 266 | 2035 | 939 | 1525 | XHA87884.1 MAG: polyprotein [Qianjiang dicistro-like virus 91] | diamond | 1815 | 264 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Qianjiang dicistro-like virus 91 | |||
| 30570491 | 30570491 | PRJEB58983_P_NODE_3493_length_658_cov_4.282051_g3090_i0 | PRJEB58983 | 3493 | 658 | 4.282051 | 28.17589558 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 118 | 1.33e-26 | NR | XCM68093.1 | 3003959 | g3090 | i0 | 34.7 | 3.70668693009119 | 196 | 119 | 86.6 | 3 | 652 | 83 | 732 | 924 | XCM68093.1 MAG: nonstructural polyprotein, partial [Picornavirales sp.] | diamond | 2439 | 118 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 31107701 | 31107701 | PRJEB58983_P_NODE_17635_length_306_cov_3.497854_g17220_i0 | PRJEB58983 | 17635 | 306 | 3.497854 | 10.70343324 | Hangzhou nephotettix cincticeps narnavirus 1 | 2905330 | Viruses | Viruses | 61.6 | 1.83e-8 | NR | UHK03296.1 | 2905330 | g17220 | i0 | 37.9 | 0.852941176470588 | 87 | 52 | 85.3 | 2 | 3 | 263 | 761 | 845 | UHK03296.1 MAG: RNA-dependent DNA polymerase, partial [Hangzhou nephotettix cincticeps narnavirus 1] | diamond | 261 | 61.6 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Hangzhou nephotettix cincticeps narnavirus 1 | ||
| 32310129 | 32310129 | PRJEB58983_P_NODE_13399_length_346_cov_1.890110_g12984_i0 | PRJEB58983 | 13399 | 346 | 1.89011 | 6.5397806 | Partitiviridae sp. | 1955170 | Viruses | Viruses | 129 | 6.16e-33 | NR | USE08444.1 | 1955170 | g12984 | i0 | 53.5 | 1.97687861271676 | 114 | 53 | 98.8 | 0 | 5 | 346 | 255 | 368 | USE08444.1 MAG: putative RNA-dependent RNA polymerase, partial [Partitiviridae sp.] | diamond | 684 | 129 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Partitiviridae sp. | |||
| 32341680 | 32341680 | PRJEB58983_P_NODE_2539_length_788_cov_5.328671_g2163_i0 | PRJEB58983 | 2539 | 788 | 5.328671 | 41.98992748 | Hangzhou nephotettix cincticeps narnavirus 1 | 2905330 | Viruses | Viruses | 183 | 8.38e-49 | NR | UHK03296.1 | 2905330 | g2163 | i0 | 42.5 | 0.993654822335025 | 261 | 132 | 97.8 | 6 | 2 | 772 | 148 | 394 | UHK03296.1 MAG: RNA-dependent DNA polymerase, partial [Hangzhou nephotettix cincticeps narnavirus 1] | diamond | 783 | 183 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Hangzhou nephotettix cincticeps narnavirus 1 |
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);;