contig_metadata
21 rows where analysis = "blastn", bioproject = "PRJNA812715" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 814783 | 814783 | PRJNA812715_P_NODE_90401_length_268_cov_1.261538_g88600_i0 | PRJNA812715 | 90401 | 268 | 1.261538 | 3.38092184 | Lycium betacytorhabdovirus 1 | 3078349 | Viruses | Viruses | 117 | 8.58e-22 | NTclustered | gi|2618835662|tpg|BK064324.1| | 3078349 | g88600 | i0 | 97.143 | 1.97388059701493 | 70 | 0 | 25 | 1 | 200 | 267 | 70 | 1 | TPA_asm: Lycium betacytorhabdovirus 1 cRNA sequence | blastn | 529 | 117 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Lycium betacytorhabdovirus 1 | |||
| 2090556 | 2090556 | PRJNA812715_P_NODE_94402_length_261_cov_4.127660_g92601_i0 | PRJNA812715 | 94402 | 261 | 4.12766 | 10.7731926 | Lycium betacytorhabdovirus 1 | 3078349 | Viruses | Viruses | 124 | 4.969999999999999e-24 | NTclustered | gi|2618835662|tpg|BK064324.1| | 3078349 | g92601 | i0 | 98.592 | 3.13409961685824 | 71 | 0 | 27 | 1 | 134 | 203 | 71 | 1 | TPA_asm: Lycium betacytorhabdovirus 1 cRNA sequence | blastn | 818 | 124 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Lycium betacytorhabdovirus 1 | |||
| 5915643 | 5915643 | PRJNA812715_P_NODE_124105_length_228_cov_2.754839_g122304_i0 | PRJNA812715 | 124105 | 228 | 2.754839 | 6.28103292 | Lycium betacytorhabdovirus 1 | 3078349 | Viruses | Viruses | 110 | 1.19e-19 | NTclustered | gi|2618835662|tpg|BK064324.1| | 3078349 | g122304 | i0 | 96.97 | 1.96052631578947 | 66 | 0 | 57 | 2 | 1 | 64 | 6 | 71 | TPA_asm: Lycium betacytorhabdovirus 1 cRNA sequence | blastn | 447 | 110 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Lycium betacytorhabdovirus 1 | |||
| 9740699 | 9740699 | PRJNA812715_P_NODE_21628_length_716_cov_2.356143_g19969_i0 | PRJNA812715 | 21628 | 716 | 2.356143 | 16.86998388 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 1040 | 0 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g19969 | i0 | 94.51 | 2.94972067039106 | 674 | 37 | 100 | 0 | 43 | 716 | 1187 | 1860 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 2112 | 1040 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 9740721 | 9740721 | PRJNA812715_P_NODE_22288_length_699_cov_2.416933_g20613_i0 | PRJNA812715 | 22288 | 699 | 2.416933 | 16.89436167 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 1221 | 0 | NTclustered | gi|1990739381|tpg|BK011179.1| | 2304617 | g20613 | i0 | 98.281 | 2.98855507868383 | 698 | 11 | 99 | 1 | 1 | 697 | 886 | 189 | TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome | blastn | 2089 | 1221 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 9741033 | 9741033 | PRJNA812715_P_NODE_31628_length_531_cov_2.587336_g29857_i0 | PRJNA812715 | 31628 | 531 | 2.587336 | 13.73875416 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 870 | 0 | NTclustered | gi|1812398529|gb|MN524064.1| | 2304617 | g29857 | i0 | 96.234 | 3 | 531 | 20 | 100 | 0 | 1 | 531 | 1609 | 2139 | Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome | blastn | 1593 | 870 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 9741914 | 9741914 | PRJNA812715_P_NODE_59248_length_341_cov_2.641791_g57449_i0 | PRJNA812715 | 59248 | 341 | 2.641791 | 9.00850731 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 547 | 3.3699999999999985e-151 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g57449 | i0 | 95.614 | 3 | 342 | 13 | 100 | 2 | 1 | 341 | 2520 | 2860 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 1023 | 547 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 12291320 | 12291320 | PRJNA812715_P_NODE_116010_length_244_cov_0.900585_g114209_i0 | PRJNA812715 | 116010 | 244 | 0.900585 | 2.1974274 | Mitovirus sp. | 2587224 | Viruses | Viruses | 174 | 4.5e-39 | NTclustered | gi|1698234317|gb|MN033515.1| | 2587224 | g114209 | i0 | 94.643 | 3.84836065573771 | 112 | 6 | 46 | 0 | 5 | 116 | 1 | 112 | MAG: Mitovirus sp. isolate H1_Rhizo_26_FD_scaffold_6751 sequence | blastn | 939 | 174 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Mitovirus sp. | ||
| 12293032 | 12293032 | PRJNA812715_P_NODE_57910_length_346_cov_2.673993_g56111_i0 | PRJNA812715 | 57910 | 346 | 2.673993 | 9.25201578 | Erysiphe necator associated ourmia-like virus 10 | 2689558 | Viruses | Viruses | 396 | 1.31e-105 | NTclustered | gi|1787383298|gb|MN552399.1| | 2689558 | g56111 | i0 | 87.32 | 9.36416184971098 | 347 | 42 | 100 | 2 | 1 | 346 | 1584 | 1239 | Erysiphe necator associated ourmia-like virus 10 isolate PMS-18_DN57060 RNA dependent RNA polymerase gene, complete cds | blastn | 3240 | 396 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Erysiphe necator associated ourmia-like virus 10 | |||
| 13566379 | 13566379 | PRJNA812715_P_NODE_25751_length_623_cov_303.841818_g24030_i0 | PRJNA812715 | 25751 | 623 | 303.841818 | 1892.93452614 | Lycium betacytorhabdovirus 1 | 3078349 | Viruses | Viruses | 132 | 7.72e-26 | NTclustered | gi|2618835662|tpg|BK064324.1| | 3078349 | g24030 | i0 | 100 | 2.75120385232745 | 71 | 0 | 22 | 0 | 142 | 212 | 1 | 71 | TPA_asm: Lycium betacytorhabdovirus 1 cRNA sequence | blastn | 1714 | 132 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Lycium betacytorhabdovirus 1 | |||
| 14839873 | 14839873 | PRJNA812715_P_NODE_103332_length_250_cov_1.514124_g101531_i0 | PRJNA812715 | 103332 | 250 | 1.514124 | 3.78531 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 261 | 3.4600000000000002e-65 | NTclustered | gi|2780183578|gb|PP818844.1| | 1530251 | g101531 | i0 | 87.892 | 0.892 | 223 | 25 | 88 | 1 | 1 | 221 | 3602 | 3380 | Picornaviridae sp. polyprotein and capsid protein genes, complete cds | blastn | 223 | 261 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 17390233 | 17390233 | PRJNA812715_P_NODE_108354_length_248_cov_0.880000_g106553_i0 | PRJNA812715 | 108354 | 248 | 0.88 | 2.1824 | Lycium betacytorhabdovirus 1 | 3078349 | Viruses | Viruses | 71.3 | 6.19e-8 | NTclustered | gi|2618835662|tpg|BK064324.1| | 3078349 | g106553 | i0 | 97.561 | 0.165322580645161 | 41 | 1 | 17 | 0 | 1 | 41 | 41 | 1 | TPA_asm: Lycium betacytorhabdovirus 1 cRNA sequence | blastn | 41 | 71.3 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Lycium betacytorhabdovirus 1 | |||
| 20351087 | 20351087 | PRJNA812715_P_NODE_113716_length_245_cov_0.895349_g111915_i0 | PRJNA812715 | 113716 | 245 | 0.895349 | 2.19360505 | Mitovirus | 186768 | Viruses | Viruses | 346 | 9.059999999999999e-91 | NTclustered | gi|2820293710|gb|PQ180899.1| | 2921206 | g111915 | i0 | 92.276 | 10.3142857142857 | 246 | 16 | 100 | 2 | 1 | 245 | 4 | 247 | MAG: Fusarium asiaticum mitovirus 5 isolate Hebei_050 genomic sequence | blastn | 2527 | 346 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Fusarium asiaticum mitovirus 5 | ||
| 22489311 | 22489311 | PRJNA812715_P_NODE_1838_length_3068_cov_5.371953_g238_i2 | PRJNA812715 | 1838 | 3068 | 5.371953 | 164.81151804 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 4809 | 0 | NTclustered | gi|1812398529|gb|MN524064.1| | 2304617 | g238 | i2 | 94.956 | 3.00456323337679 | 3073 | 148 | 100 | 7 | 1 | 3068 | 2185 | 5255 | Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome | blastn | 9218 | 4809 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 22489574 | 22489574 | PRJNA812715_P_NODE_258_length_5788_cov_9.986877_g238_i0 | PRJNA812715 | 258 | 5788 | 9.986877 | 578.04044076 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 9575 | 0 | NTclustered | gi|1812398529|gb|MN524064.1| | 2304617 | g238 | i0 | 96.514 | 3.00259156876296 | 5795 | 194 | 100 | 6 | 1 | 5788 | 7978 | 2185 | Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome | blastn | 17379 | 9575 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 23764537 | 23764537 | PRJNA812715_P_NODE_114679_length_244_cov_1.801170_g112878_i0 | PRJNA812715 | 114679 | 244 | 1.80117 | 4.3948548 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 385 | 1.91e-102 | NTclustered | gi|1990739381|tpg|BK011179.1| | 2304617 | g112878 | i0 | 95.082 | 3 | 244 | 12 | 100 | 0 | 1 | 244 | 2664 | 2907 | TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome | blastn | 732 | 385 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 23765407 | 23765407 | PRJNA812715_P_NODE_30099_length_552_cov_1.887265_g28336_i0 | PRJNA812715 | 30099 | 552 | 1.887265 | 10.4177028 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 915 | 0 | NTclustered | gi|1812398529|gb|MN524064.1| | 2304617 | g28336 | i0 | 96.558 | 2.9981884057971 | 552 | 19 | 100 | 0 | 1 | 552 | 906 | 1457 | Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome | blastn | 1655 | 915 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 23765529 | 23765529 | PRJNA812715_P_NODE_339_length_5280_cov_8.793547_g238_i1 | PRJNA812715 | 339 | 5280 | 8.793547 | 464.2992816 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 8660 | 0 | NTclustered | gi|1812398529|gb|MN524064.1| | 2304617 | g238 | i1 | 96.255 | 3.00284090909091 | 5287 | 190 | 100 | 6 | 1 | 5280 | 7470 | 2185 | Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome | blastn | 15855 | 8660 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 23766290 | 23766290 | PRJNA812715_P_NODE_57019_length_350_cov_1.509025_g55220_i0 | PRJNA812715 | 57019 | 350 | 1.509025 | 5.2815875 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 592 | 1.5799999999999996e-164 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g55220 | i0 | 97.143 | 2.99428571428571 | 350 | 10 | 100 | 0 | 1 | 350 | 1050 | 1399 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 1048 | 592 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 23767089 | 23767089 | PRJNA812715_P_NODE_84959_length_276_cov_2.502463_g83158_i0 | PRJNA812715 | 84959 | 276 | 2.502463 | 6.90679788 | Henan cystovirus 3 | 2824305 | Viruses | Viruses | 361 | 3.7099999999999996e-95 | NTclustered | gi|2075443683|gb|MW897002.1| | 2824305 | g83158 | i0 | 90.217 | 1 | 276 | 27 | 100 | 0 | 1 | 276 | 583 | 308 | MAG: Henan cystovirus 3 isolate 265-k141_5132 hypothetical protein 1, putative RNA-dependent RNA polymerase, and hypothetical protein 2 genes, complete cds; and hypothetical protein 3 gene, partial cds | blastn | 276 | 361 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Cystovirus | Henan cystovirus 3 | ||
| 25040515 | 25040515 | PRJNA812715_P_NODE_69300_length_308_cov_371.727660_g67500_i0 | PRJNA812715 | 69300 | 308 | 371.72766 | 1144.9211928 | Lycium betacytorhabdovirus 1 | 3078349 | Viruses | Viruses | 119 | 2.7900000000000003e-22 | NTclustered | gi|2618835662|tpg|BK064324.1| | 3078349 | g67500 | i0 | 97.183 | 2.32467532467532 | 71 | 0 | 32 | 1 | 76 | 144 | 1 | 71 | TPA_asm: Lycium betacytorhabdovirus 1 cRNA sequence | blastn | 716 | 119 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Lycium betacytorhabdovirus 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);;