contig_metadata
23 rows where analysis = "blastn", bioproject = "PRJNA561212" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 545175 | 545175 | PRJNA561212_P_NODE_1001_length_1062_cov_27595.039434_g676_i6 | PRJNA561212 | 1001 | 1062 | 27595.039434 | 293059.31878908 | Arma chinensis virus 1 | 2974718 | Viruses | Viruses | 95.3 | 1.77e-14 | NTclustered | gi|2289441063|gb|MW846634.1| | 2974718 | g676 | i6 | 85.714 | 1.05461393596987 | 91 | 11 | 8 | 2 | 27 | 115 | 9209 | 9119 | Arma chinensis virus 1 isolate GZ1, complete genome | blastn | 1120 | 95.3 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Arma chinensis virus 1 | ||||
| 545216 | 545216 | PRJNA561212_P_NODE_12521_length_314_cov_12.190871_g12310_i0 | PRJNA561212 | 12521 | 314 | 12.190871 | 38.27933494 | Sobemovirus sp. | 2809869 | Viruses | Viruses | 206 | 2.13e-48 | NTclustered | gi|2171145024|gb|MZ218240.1| | 2809869 | g12310 | i0 | 80 | 400.455414012739 | 280 | 54 | 89 | 2 | 11 | 289 | 4906 | 5184 | MAG: Sobemovirus sp. isolate 267-k141_60134 genomic sequence | blastn | 125743 | 206 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Solemoviridae | Sobemovirus | Sobemovirus sp. | ||
| 1821157 | 1821157 | PRJNA561212_P_NODE_2_length_9251_cov_83.505121_g1_i0 | PRJNA561212 | 2 | 9251 | 83.505121 | 7725.05874371 | brine shrimp iflavirus 3 | 2900464 | Viruses | Viruses | 16831 | 0 | NTclustered | gi|2209094758|gb|OL472451.1| | 2900464 | g1 | i0 | 99.567 | 10.9891903577992 | 9234 | 40 | 99 | 0 | 9 | 9242 | 9236 | 3 | MAG: Brine shrimp iflavirus 3 isolate KAZ/15-16 RNA-dependent RNA polymerase gene, complete cds | blastn | 101661 | 16831 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | brine shrimp iflavirus 3 | ||
| 3096442 | 3096442 | PRJNA561212_P_NODE_3_length_8346_cov_49.070712_g2_i0 | PRJNA561212 | 3 | 8346 | 49.070712 | 4095.44162352 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 13572 | 0 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g2 | i0 | 96.194 | 3.03965971722981 | 8303 | 305 | 99 | 9 | 24 | 8322 | 8298 | 3 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 25369 | 13572 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 3096531 | 3096531 | PRJNA561212_P_NODE_963_length_1087_cov_27600.694280_g676_i3 | PRJNA561212 | 963 | 1087 | 27600.69428 | 300019.5468236 | Arma chinensis virus 1 | 2974718 | Viruses | Viruses | 95.3 | 1.81e-14 | NTclustered | gi|2289441063|gb|MW846634.1| | 2974718 | g676 | i3 | 85.714 | 1.03035878564857 | 91 | 11 | 8 | 2 | 973 | 1061 | 9119 | 9209 | Arma chinensis virus 1 isolate GZ1, complete genome | blastn | 1120 | 95.3 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Arma chinensis virus 1 | ||||
| 4372952 | 4372952 | PRJNA561212_P_NODE_4_length_5507_cov_45.314869_g2_i1 | PRJNA561212 | 4 | 5507 | 45.314869 | 2495.48983583 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 8918 | 0 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g2 | i1 | 95.994 | 2.99201016887598 | 5492 | 214 | 99 | 4 | 10 | 5498 | 7619 | 2131 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 16477 | 8918 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 5649392 | 5649392 | PRJNA561212_P_NODE_885_length_1124_cov_17293.054234_g676_i1 | PRJNA561212 | 885 | 1124 | 17293.054234 | 194373.92959016 | Arma chinensis virus 1 | 2974718 | Viruses | Viruses | 95.3 | 1.87e-14 | NTclustered | gi|2289441063|gb|MW846634.1| | 2974718 | g676 | i1 | 85.714 | 0.99644128113879 | 91 | 11 | 8 | 2 | 27 | 115 | 9209 | 9119 | Arma chinensis virus 1 isolate GZ1, complete genome | blastn | 1120 | 95.3 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Arma chinensis virus 1 | ||||
| 6923298 | 6923298 | PRJNA561212_P_NODE_1306_length_946_cov_26928.316151_g676_i7 | PRJNA561212 | 1306 | 946 | 26928.316151 | 254741.87078846 | Arma chinensis virus 1 | 2974718 | Viruses | Viruses | 95.3 | 1.57e-14 | NTclustered | gi|2289441063|gb|MW846634.1| | 2974718 | g676 | i7 | 85.714 | 1.18393234672304 | 91 | 11 | 9 | 2 | 832 | 920 | 9119 | 9209 | Arma chinensis virus 1 isolate GZ1, complete genome | blastn | 1120 | 95.3 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Arma chinensis virus 1 | ||||
| 12024436 | 12024436 | PRJNA561212_P_NODE_18110_length_267_cov_1.489691_g17899_i0 | PRJNA561212 | 18110 | 267 | 1.489691 | 3.97747497 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 335 | 2.169999999999999e-87 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g17899 | i0 | 90.837 | 1.88014981273408 | 251 | 22 | 94 | 1 | 10 | 259 | 3141 | 2891 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 502 | 335 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 12024438 | 12024438 | PRJNA561212_P_NODE_18230_length_266_cov_1.528497_g18019_i0 | PRJNA561212 | 18230 | 266 | 1.528497 | 4.06580202 | Mitovirus sp. | 2587224 | Viruses | Viruses | 270 | 6.1699999999999986e-68 | NTclustered | gi|1698234317|gb|MN033515.1| | 2587224 | g18019 | i0 | 92.553 | 0.706766917293233 | 188 | 14 | 71 | 0 | 9 | 196 | 9 | 196 | MAG: Mitovirus sp. isolate H1_Rhizo_26_FD_scaffold_6751 sequence | blastn | 188 | 270 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Mitovirus sp. | ||
| 14574200 | 14574200 | PRJNA561212_P_NODE_10392_length_342_cov_2.193309_g10181_i0 | PRJNA561212 | 10392 | 342 | 2.193309 | 7.50111678 | brine shrimp yue-like virus 7 | 2900459 | Viruses | Viruses | 616 | 9.139999999999999e-172 | NTclustered | gi|2209095278|gb|OL472843.1| | 2900459 | g10181 | i0 | 100 | 4.86842105263158 | 333 | 0 | 97 | 0 | 1 | 333 | 1079 | 1411 | MAG: Brine shrimp yue-like virus 7 isolate BH/15 segment 2 hypothetical protein gene, complete cds | blastn | 1665 | 616 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | brine shrimp yue-like virus 7 | |||
| 14574253 | 14574253 | PRJNA561212_P_NODE_1312_length_944_cov_2.814007_g1146_i0 | PRJNA561212 | 1312 | 944 | 2.814007 | 26.56422608 | brine shrimp yue-like virus 7 | 2900459 | Viruses | Viruses | 1729 | 0 | NTclustered | gi|2209095278|gb|OL472843.1| | 2900459 | g1146 | i0 | 100 | 4.98940677966102 | 936 | 0 | 99 | 0 | 1 | 936 | 993 | 58 | MAG: Brine shrimp yue-like virus 7 isolate BH/15 segment 2 hypothetical protein gene, complete cds | blastn | 4710 | 1729 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | brine shrimp yue-like virus 7 | |||
| 14574454 | 14574454 | PRJNA561212_P_NODE_24692_length_244_cov_1.011696_g24481_i0 | PRJNA561212 | 24692 | 244 | 1.011696 | 2.46853824 | brine shrimp yue-like virus 7 | 2900459 | Viruses | Viruses | 403 | 5.27e-108 | NTclustered | gi|2209095276|gb|OL472842.1| | 2900459 | g24481 | i0 | 97.458 | 4.83606557377049 | 236 | 6 | 97 | 0 | 9 | 244 | 6545 | 6310 | MAG: Brine shrimp yue-like virus 7 isolate BH/15 segment 1 RNA-dependent RNA polymerase gene, complete cds | blastn | 1180 | 403 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | brine shrimp yue-like virus 7 | |||
| 14574533 | 14574533 | PRJNA561212_P_NODE_5852_length_457_cov_0.765625_g5641_i0 | PRJNA561212 | 5852 | 457 | 0.765625 | 3.49890625 | Artemvirus bsafialis | 3426459 | Viruses | Viruses | 793 | 0 | NTclustered | gi|2209095102|gb|OL472401.1| | 2900376 | g5641 | i0 | 99.093 | 14.4748358862144 | 441 | 4 | 96 | 0 | 8 | 448 | 6501 | 6061 | MAG: Brine shrimp arlivirus 1 isolate GSL/15 hypothetical protein and RNA-dependent RNA polymerase genes, complete cds | blastn | 6615 | 793 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsafialis | ||
| 17123131 | 17123131 | PRJNA561212_P_NODE_23534_length_246_cov_5.393064_g23323_i0 | PRJNA561212 | 23534 | 246 | 5.393064 | 13.26693744 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 313 | 9.23e-81 | NTclustered | gi|1990739381|tpg|BK011179.1| | 2304617 | g23323 | i0 | 91.342 | 2.81707317073171 | 231 | 17 | 93 | 1 | 10 | 237 | 3129 | 3359 | TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome | blastn | 693 | 313 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 19671863 | 19671863 | PRJNA561212_P_NODE_18156_length_267_cov_1.128866_g17945_i0 | PRJNA561212 | 18156 | 267 | 1.128866 | 3.01407222 | Artemvirus bsafialis | 3426459 | Viruses | Viruses | 449 | 7.410000000000001e-122 | NTclustered | gi|2209095102|gb|OL472401.1| | 2900376 | g17945 | i0 | 99.593 | 13.8202247191011 | 246 | 1 | 92 | 0 | 10 | 255 | 1553 | 1798 | MAG: Brine shrimp arlivirus 1 isolate GSL/15 hypothetical protein and RNA-dependent RNA polymerase genes, complete cds | blastn | 3690 | 449 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsafialis | ||
| 19671941 | 19671941 | PRJNA561212_P_NODE_22796_length_248_cov_0.891429_g22585_i0 | PRJNA561212 | 22796 | 248 | 0.891429 | 2.21074392 | brine shrimp yue-like virus 7 | 2900459 | Viruses | Viruses | 431 | 2.47e-116 | NTclustered | gi|2209095276|gb|OL472842.1| | 2900459 | g22585 | i0 | 100 | 4.69758064516129 | 233 | 0 | 94 | 0 | 9 | 241 | 6709 | 6477 | MAG: Brine shrimp yue-like virus 7 isolate BH/15 segment 1 RNA-dependent RNA polymerase gene, complete cds | blastn | 1165 | 431 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | brine shrimp yue-like virus 7 | |||
| 19672052 | 19672052 | PRJNA561212_P_NODE_7176_length_410_cov_3.824926_g6965_i0 | PRJNA561212 | 7176 | 410 | 3.824926 | 15.6821966 | brine shrimp yue-like virus 7 | 2900459 | Viruses | Viruses | 734 | 0 | NTclustered | gi|2209095276|gb|OL472842.1| | 2900459 | g6965 | i0 | 99.751 | 4.89024390243902 | 401 | 0 | 98 | 1 | 10 | 410 | 7452 | 7851 | MAG: Brine shrimp yue-like virus 7 isolate BH/15 segment 1 RNA-dependent RNA polymerase gene, complete cds | blastn | 2005 | 734 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | brine shrimp yue-like virus 7 | |||
| 20947406 | 20947406 | PRJNA561212_P_NODE_12077_length_320_cov_0.910931_g11866_i0 | PRJNA561212 | 12077 | 320 | 0.910931 | 2.9149792 | Artemvirus bsafialis | 3426459 | Viruses | Viruses | 525 | 1.4699999999999994e-144 | NTclustered | gi|2209095102|gb|OL472401.1| | 2900376 | g11866 | i0 | 97.712 | 14.34375 | 306 | 6 | 95 | 1 | 10 | 314 | 624 | 319 | MAG: Brine shrimp arlivirus 1 isolate GSL/15 hypothetical protein and RNA-dependent RNA polymerase genes, complete cds | blastn | 4590 | 525 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsafialis | ||
| 20947713 | 20947713 | PRJNA561212_P_NODE_797_length_1172_cov_22636.337580_g676_i0 | PRJNA561212 | 797 | 1172 | 22636.33758 | 265297.8764376 | Arma chinensis virus 1 | 2974718 | Viruses | Viruses | 95.3 | 1.96e-14 | NTclustered | gi|2289441063|gb|MW846634.1| | 2974718 | g676 | i0 | 85.714 | 0.955631399317406 | 91 | 11 | 8 | 2 | 1058 | 1146 | 9119 | 9209 | Arma chinensis virus 1 isolate GZ1, complete genome | blastn | 1120 | 95.3 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Arma chinensis virus 1 | ||||
| 22222636 | 22222636 | PRJNA561212_P_NODE_898_length_1121_cov_23521.990458_g676_i2 | PRJNA561212 | 898 | 1121 | 23521.990458 | 263681.51303418 | Arma chinensis virus 1 | 2974718 | Viruses | Viruses | 95.3 | 1.87e-14 | NTclustered | gi|2289441063|gb|MW846634.1| | 2974718 | g676 | i2 | 85.714 | 0.999107939339875 | 91 | 11 | 8 | 2 | 27 | 115 | 9209 | 9119 | Arma chinensis virus 1 isolate GZ1, complete genome | blastn | 1120 | 95.3 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Arma chinensis virus 1 | ||||
| 23497956 | 23497956 | PRJNA561212_P_NODE_999_length_1062_cov_30112.421638_g676_i4 | PRJNA561212 | 999 | 1062 | 30112.421638 | 319793.91779556 | Arma chinensis virus 1 | 2974718 | Viruses | Viruses | 95.3 | 1.77e-14 | NTclustered | gi|2289441063|gb|MW846634.1| | 2974718 | g676 | i4 | 85.714 | 1.05461393596987 | 91 | 11 | 8 | 2 | 27 | 115 | 9209 | 9119 | Arma chinensis virus 1 isolate GZ1, complete genome | blastn | 1120 | 95.3 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Arma chinensis virus 1 | ||||
| 24771483 | 24771483 | PRJNA561212_P_NODE_1000_length_1062_cov_27694.141557_g676_i5 | PRJNA561212 | 1000 | 1062 | 27694.141557 | 294111.78333534 | Arma chinensis virus 1 | 2974718 | Viruses | Viruses | 95.3 | 1.77e-14 | NTclustered | gi|2289441063|gb|MW846634.1| | 2974718 | g676 | i5 | 85.714 | 1.05461393596987 | 91 | 11 | 8 | 2 | 27 | 115 | 9209 | 9119 | Arma chinensis virus 1 isolate GZ1, complete genome | blastn | 1120 | 95.3 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Arma chinensis virus 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);;