contig_metadata
22 rows where bioproject = "PRJEB14664" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1295426 | 1295426 | PRJEB14664_P_NODE_2_length_9077_cov_27.573877_g1_i0 | PRJEB14664 | 2 | 9077 | 27.573877 | 2502.88081529 | Maanshan Dicis tick virus 1 | 2972097 | Viruses | Viruses | 846 | 3.18e-261 | NR | UYL95314.1 | 2972097 | g1 | i0 | 32.7 | 5.34229370937534 | 1821 | 965 | 58.1 | 36 | 440 | 5710 | 108 | 1731 | UYL95314.1 MAG: replicase polyprotein [Maanshan Dicis tick virus 1] | diamond | 48492 | 846 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Maanshan Dicis tick virus 1 | |||
| 7673495 | 7673495 | PRJEB14664_P_NODE_6227_length_331_cov_1.777027_g6097_i0 | PRJEB14664 | 6227 | 331 | 1.777027 | 5.88195937 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 558 | 1.51e-154 | NTclustered | gi|1990739381|tpg|BK011179.1| | 2304617 | g6097 | i0 | 97.264 | 2.98187311178248 | 329 | 9 | 99 | 0 | 3 | 331 | 5190 | 4862 | TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome | blastn | 987 | 558 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 10223867 | 10223867 | PRJEB14664_P_NODE_10049_length_240_cov_8.560976_g9919_i0 | PRJEB14664 | 10049 | 240 | 8.560976 | 20.5463424 | Mitovirus sp. | 2587224 | Viruses | Viruses | 119 | 2.1e-22 | NTclustered | gi|1698234317|gb|MN033515.1| | 2587224 | g9919 | i0 | 93.671 | 0.329166666666667 | 79 | 5 | 33 | 0 | 23 | 101 | 33 | 111 | MAG: Mitovirus sp. isolate H1_Rhizo_26_FD_scaffold_6751 sequence | blastn | 79 | 119 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Mitovirus sp. | ||
| 11499198 | 11499198 | PRJEB14664_P_NODE_13730_length_194_cov_1.496855_g13600_i0 | PRJEB14664 | 13730 | 194 | 1.496855 | 2.9038987 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 320 | 4.16e-83 | NTclustered | gi|2754692084|gb|PP872771.1| | 3003959 | g13600 | i0 | 96.392 | 1 | 194 | 7 | 100 | 0 | 1 | 194 | 3775 | 3582 | MAG: Picornavirales sp. isolate TC-PLV-215 MR233-17E/839 genomic sequence | blastn | 194 | 320 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 14049272 | 14049272 | PRJEB14664_P_NODE_12232_length_210_cov_1.371429_g12102_i0 | PRJEB14664 | 12232 | 210 | 1.371429 | 2.8800009 | Solumvirus sp. | 2487773 | Viruses | Viruses | 110 | 5.06e-28 | NR | AYV86227.1 | 2487773 | g12102 | i0 | 86.7 | 0.857142857142857 | 60 | 8 | 85.7 | 0 | 210 | 31 | 125 | 184 | AYV86227.1 MAG: hypothetical protein Solumvirus2_34 [Solumvirus sp.] | diamond | 180 | 110 | 1 | Viruses | Pithoviruses | Solumvirus sp. | |||||||
| 15323351 | 15323351 | PRJEB14664_P_NODE_15593_length_178_cov_1.650350_g15463_i0 | PRJEB14664 | 15593 | 178 | 1.65035 | 2.937623 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 291 | 2.93e-74 | NTclustered | gi|1812398529|gb|MN524064.1| | 2304617 | g15463 | i0 | 96.067 | 3 | 178 | 7 | 100 | 0 | 1 | 178 | 2845 | 2668 | Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome | blastn | 534 | 291 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 15323365 | 15323365 | PRJEB14664_P_NODE_1633_length_723_cov_2.340116_g1533_i0 | PRJEB14664 | 1633 | 723 | 2.340116 | 16.91903868 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 1264 | 0 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g1533 | i0 | 98.202 | 3 | 723 | 13 | 100 | 0 | 1 | 723 | 7206 | 7928 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 2169 | 1264 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 16598004 | 16598004 | PRJEB14664_P_NODE_15174_length_181_cov_2.712329_g15044_i0 | PRJEB14664 | 15174 | 181 | 2.712329 | 4.90931549 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 52.8 | 0.015 | NTclustered | gi|2054791230|tpg|BK049928.1| | 2832643 | g15044 | i0 | 100 | 0.154696132596685 | 28 | 0 | 15 | 0 | 97 | 124 | 1569 | 1596 | MAG TPA_asm: Caudoviricetes sp. isolate ctwKx1, partial genome | blastn | 28 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 16598069 | 16598069 | PRJEB14664_P_NODE_3094_length_513_cov_1.755230_g2972_i0 | PRJEB14664 | 3094 | 513 | 1.75523 | 9.0043299 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 848 | 0 | NTclustered | gi|1812398529|gb|MN524064.1| | 2304617 | g2972 | i0 | 96.491 | 3 | 513 | 18 | 100 | 0 | 1 | 513 | 4204 | 4716 | Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome | blastn | 1539 | 848 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 16598083 | 16598083 | PRJEB14664_P_NODE_3974_length_441_cov_2.128079_g3847_i0 | PRJEB14664 | 3974 | 441 | 2.128079 | 9.38482839 | Chrocagosk virus | 3129397 | Viruses | Viruses | 466 | 1.2899999999999999e-126 | NTclustered | gi|2717317479|gb|PP171845.1| | 3129397 | g3847 | i0 | 92.145 | 71.3446712018141 | 331 | 24 | 75 | 2 | 89 | 419 | 329 | 1 | MAG: Chrocagosk virus isolate CC1A_k141_83719 genomic sequence | blastn | 31463 | 466 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocagosk virus | |||||
| 20421851 | 20421851 | PRJEB14664_P_NODE_14117_length_191_cov_1.134615_g13987_i0 | PRJEB14664 | 14117 | 191 | 1.134615 | 2.16711465 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 318 | 1.4699999999999996e-82 | NTclustered | gi|1812398529|gb|MN524064.1| | 2304617 | g13987 | i0 | 96.842 | 2.98429319371728 | 190 | 6 | 99 | 0 | 2 | 191 | 3661 | 3850 | Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome | blastn | 570 | 318 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 20421978 | 20421978 | PRJEB14664_P_NODE_7597_length_291_cov_2.234375_g7467_i0 | PRJEB14664 | 7597 | 291 | 2.234375 | 6.50203125 | Mitovirus sp. | 2587224 | Viruses | Viruses | 174 | 5.51e-39 | NTclustered | gi|1698234317|gb|MN033515.1| | 2587224 | g7467 | i0 | 94.643 | 3.22680412371134 | 112 | 6 | 38 | 0 | 176 | 287 | 112 | 1 | MAG: Mitovirus sp. isolate H1_Rhizo_26_FD_scaffold_6751 sequence | blastn | 939 | 174 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Mitovirus sp. | ||
| 21697858 | 21697858 | PRJEB14664_P_NODE_11958_length_213_cov_1.741573_g11828_i0 | PRJEB14664 | 11958 | 213 | 1.741573 | 3.70955049 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 344 | 2.76e-90 | NTclustered | gi|1812398529|gb|MN524064.1| | 2304617 | g11828 | i0 | 95.775 | 3 | 213 | 9 | 100 | 0 | 1 | 213 | 3980 | 4192 | Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome | blastn | 639 | 344 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 22973120 | 22973120 | PRJEB14664_P_NODE_12619_length_205_cov_2.094118_g12489_i0 | PRJEB14664 | 12619 | 205 | 2.094118 | 4.2929419 | Macrobrachium rosenbergii nudivirus | 2904783 | Viruses | Viruses | 58.4 | 3.85e-4 | NTclustered | gi|2166981788|gb|MW484891.1| | 2904783 | g12489 | i0 | 100 | 0.902439024390244 | 31 | 0 | 15 | 0 | 51 | 81 | 51868 | 51838 | Macrobrachium rosenbergii nudivirus isolate CN-SL2011, complete genome | blastn | 185 | 58.4 | 1 | Viruses | Naldaviricetes | Lefavirales | Nudiviridae | Macrobrachium rosenbergii nudivirus | |||||
| 22973180 | 22973180 | PRJEB14664_P_NODE_18339_length_159_cov_1.935484_g18209_i0 | PRJEB14664 | 18339 | 159 | 1.935484 | 3.07741956 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 267 | 4.3199999999999996e-67 | NTclustered | gi|1812398529|gb|MN524064.1| | 2304617 | g18209 | i0 | 96.855 | 2.9874213836478 | 159 | 5 | 100 | 0 | 1 | 159 | 2852 | 3010 | Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome | blastn | 475 | 267 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 22973233 | 22973233 | PRJEB14664_P_NODE_5119_length_374_cov_2.784661_g4989_i0 | PRJEB14664 | 5119 | 374 | 2.784661 | 10.41463214 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 647 | 0 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g4989 | i0 | 97.861 | 2.99465240641711 | 374 | 8 | 100 | 0 | 1 | 374 | 6943 | 6570 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 1120 | 647 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 24246963 | 24246963 | PRJEB14664_P_NODE_12720_length_204_cov_1.863905_g12590_i0 | PRJEB14664 | 12720 | 204 | 1.863905 | 3.8023662 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 353 | 4.36e-93 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g12590 | i0 | 98.03 | 2.98529411764706 | 203 | 4 | 99 | 0 | 1 | 203 | 5687 | 5485 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 609 | 353 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 29237374 | 29237374 | PRJEB14664_P_NODE_13649_length_195_cov_1.087500_g13519_i0 | PRJEB14664 | 13649 | 195 | 1.0875 | 2.120625 | Viruses | 10239 | Viruses | Viruses | 48.5 | 1.84e-4 | NR | YP_001686789.1 | 425010 | g13519 | i0 | 46.8 | 4.47692307692308 | 47 | 25 | 72.3 | 0 | 7 | 147 | 428 | 474 | YP_001686789.1 RNA-dependent RNA polymerase [Botryotinia fuckeliana partitivirus 1] | diamond | 873 | 48.9 | 0.991820040899796 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Botryotinia fuckeliana partitivirus 1 | |||
| 30728103 | 30728103 | PRJEB14664_P_NODE_13334_length_198_cov_1.226994_g13204_i0 | PRJEB14664 | 13334 | 198 | 1.226994 | 2.42944812 | Dishui Lake phycodnavirus 3 | 2704074 | Viruses | Viruses | 72 | 8.64e-13 | NR | QIG59731.1 | 2704074 | g13204 | i0 | 63 | 0.696969696969697 | 46 | 17 | 69.7 | 0 | 60 | 197 | 39 | 84 | QIG59731.1 ornithine decarboxylase [Dishui Lake phycodnavirus 3] | diamond | 138 | 72 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Algavirales | Phycodnaviridae | Prasinovirus | Dishui Lake phycodnavirus 3 | ||
| 31771403 | 31771403 | PRJEB14664_P_NODE_9257_length_255_cov_1.781818_g9127_i0 | PRJEB14664 | 9257 | 255 | 1.781818 | 4.5436359 | Homavirus sp. | 2487769 | Viruses | Viruses | 129 | 2.22e-34 | NR | AYV82419.1 | 2487769 | g9127 | i0 | 67.1 | 1.98823529411765 | 85 | 27 | 98.8 | 1 | 253 | 2 | 79 | 163 | AYV82419.1 MAG: elongation factor 1-alpha-like protein [Homavirus sp.] | diamond | 507 | 129 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Homavirus sp. | |||
| 31834520 | 31834520 | PRJEB14664_P_NODE_9037_length_259_cov_4.816964_g8907_i0 | PRJEB14664 | 9037 | 259 | 4.816964 | 12.47593676 | Terrestrivirus sp. | 2487775 | Viruses | Viruses | 45.1 | 0.00178 | NR | AYV76392.1 | 2487775 | g8907 | i0 | 52.2 | 0.532818532818533 | 46 | 21 | 53.3 | 1 | 223 | 86 | 1 | 45 | AYV76392.1 MAG: hypothetical protein Terrestrivirus6_18 [Terrestrivirus sp.] | diamond | 138 | 45.1 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Terrestrivirus sp. | |||
| 32625286 | 32625286 | PRJEB14664_P_NODE_13340_length_198_cov_0.981595_g13210_i0 | PRJEB14664 | 13340 | 198 | 0.981595 | 1.9435581 | Macrobrachium rosenbergii picorna-like virus 4 | 3132542 | Viruses | Viruses | 84.7 | 3.45e-17 | NR | WWZ85593.1 | 3132542 | g13210 | i0 | 53 | 1 | 66 | 31 | 100 | 0 | 1 | 198 | 2768 | 2833 | WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4] | diamond | 198 | 84.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Macrobrachium rosenbergii picorna-like virus 4 |
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);;