contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJEB14664" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 |
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);;