contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA493827" and tax_phylum = "Negarnaviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15776901 | 15776901 | PRJNA493827_P_NODE_93_length_11555_cov_8.148406_g65_i0 | PRJNA493827 | 93 | 11555 | 8.148406 | 941.5483133 | brine shrimp arlivirus 5 | 2900380 | Viruses | Viruses | 3731 | 0 | NR | UNI74094.1 | 2900380 | g65 | i0 | 88.5 | 0.532237126784942 | 2050 | 236 | 53.2 | 0 | 5229 | 11378 | 1 | 2050 | UNI74094.1 MAG: RNA-dependent RNA polymerase [brine shrimp arlivirus 5] | diamond | 6150 | 3731 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsafivalis | ||
| 26633664 | 26633664 | PRJNA493827_P_NODE_70521_length_413_cov_2.491176_g68324_i0 | PRJNA493827 | 70521 | 413 | 2.491176 | 10.28855688 | Goldenrod fern yue-like virus | 2933170 | Viruses | Viruses | 69.7 | 9.43e-11 | NR | CAI5383876.1 | 2933170 | g68324 | i0 | 28.7 | 1.03874092009685 | 143 | 95 | 99.5 | 2 | 2 | 412 | 679 | 820 | CAI5383876.1 RNA-dependent RNA polymerase, partial [Goldenrod fern yue-like virus] | diamond | 429 | 69.7 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | Goldenrod fern yue-like virus | |||
| 27361542 | 27361542 | PRJNA493827_P_NODE_226823_length_242_cov_0.911243_g224625_i0 | PRJNA493827 | 226823 | 242 | 0.911243 | 2.20520806 | brine shrimp yue-like virus 6 | 2900458 | Viruses | Viruses | 139 | 4.08e-36 | NR | UNI74179.1 | 2900458 | g224625 | i0 | 82.3 | 0.979338842975207 | 79 | 14 | 97.9 | 0 | 3 | 239 | 836 | 914 | UNI74179.1 MAG: RNA-dependent RNA polymerase [brine shrimp yue-like virus 6] | diamond | 237 | 139 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | brine shrimp yue-like virus 6 | |||
| 27866367 | 27866367 | PRJNA493827_P_NODE_208065_length_246_cov_0.890173_g205867_i0 | PRJNA493827 | 208065 | 246 | 0.890173 | 2.18982558 | Grapevine-associated mononega-like virus 3 | 2814367 | Viruses | Viruses | 64.7 | 7.08e-10 | NR | YP_010805164.1 | 2814367 | g205867 | i0 | 49.3 | 0.865853658536585 | 71 | 36 | 86.6 | 0 | 9 | 221 | 1151 | 1221 | YP_010805164.1 MAG: RNA-dependent RNA polymerase, partial [Grapevine-associated mononega-like virus 3] | diamond | 213 | 64.7 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Mymonaviridae | Hubramonavirus | Hubramonavirus vitis | ||
| 28245209 | 28245209 | PRJNA493827_P_NODE_29526_length_690_cov_3.687196_g27474_i0 | PRJNA493827 | 29526 | 690 | 3.687196 | 25.4416524 | brine shrimp yue-like virus 3 | 2900455 | Viruses | Viruses | 267 | 8.050000000000001e-85 | NR | UNI74156.1 | 2900455 | g27474 | i0 | 54.5 | 3.88260869565217 | 220 | 100 | 95.7 | 0 | 16 | 675 | 170 | 389 | UNI74156.1 MAG: hypothetical protein [brine shrimp yue-like virus 3] | diamond | 2679 | 267 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | brine shrimp yue-like virus 3 | |||
| 28245240 | 28245240 | PRJNA493827_P_NODE_95646_length_350_cov_3.187726_g93448_i0 | PRJNA493827 | 95646 | 350 | 3.187726 | 11.157041 | brine shrimp yue-like virus 3 | 2900455 | Viruses | Viruses | 52 | 6.65e-5 | NR | UNI73809.1 | 2900455 | g93448 | i0 | 29 | 1.33714285714286 | 107 | 65 | 84.9 | 2 | 301 | 5 | 10 | 113 | UNI73809.1 MAG: hypothetical protein [brine shrimp yue-like virus 3] | diamond | 468 | 52 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | brine shrimp yue-like virus 3 | |||
| 28655990 | 28655990 | PRJNA493827_P_NODE_56987_length_468_cov_1.159494_g54793_i0 | PRJNA493827 | 56987 | 468 | 1.159494 | 5.42643192 | brine shrimp yue-like virus 6 | 2900458 | Viruses | Viruses | 266 | 3.35e-79 | NR | UNI74179.1 | 2900458 | g54793 | i0 | 84 | 1 | 156 | 25 | 100 | 0 | 1 | 468 | 951 | 1106 | UNI74179.1 MAG: RNA-dependent RNA polymerase [brine shrimp yue-like virus 6] | diamond | 468 | 266 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | brine shrimp yue-like virus 6 | |||
| 28719120 | 28719120 | PRJNA493827_P_NODE_72807_length_406_cov_1.618619_g70610_i0 | PRJNA493827 | 72807 | 406 | 1.618619 | 6.57159314 | Qianjiang bunya-like virus 4 | 3348931 | Viruses | Viruses | 85.1 | 3.51e-16 | NR | XHA87568.1 | 3348931 | g70610 | i0 | 57.3 | 0.554187192118227 | 75 | 32 | 55.4 | 0 | 4 | 228 | 654 | 728 | XHA87568.1 MAG: putative RNA-dependent RNA polymerase, partial [Qianjiang bunya-like virus 4] | diamond | 225 | 85.1 | 1 | Viruses | Orthornavirae | Negarnaviricota | Ellioviricetes | Bunyavirales | Qianjiang bunya-like virus 4 | ||||
| 29823826 | 29823826 | PRJNA493827_P_NODE_144071_length_285_cov_1.235849_g141873_i0 | PRJNA493827 | 144071 | 285 | 1.235849 | 3.52216965 | brine shrimp yue-like virus 6 | 2900458 | Viruses | Viruses | 178 | 1.3e-49 | NR | UNI74179.1 | 2900458 | g141873 | i0 | 92.6 | 0.989473684210526 | 94 | 7 | 98.9 | 0 | 3 | 284 | 318 | 411 | UNI74179.1 MAG: RNA-dependent RNA polymerase [brine shrimp yue-like virus 6] | diamond | 282 | 178 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | brine shrimp yue-like virus 6 | |||
| 30013776 | 30013776 | PRJNA493827_P_NODE_80931_length_383_cov_0.993548_g78733_i0 | PRJNA493827 | 80931 | 383 | 0.993548 | 3.80528884 | brine shrimp arlivirus 6 | 2900381 | Viruses | Viruses | 160 | 4.33e-45 | NR | UNI74095.1 | 2900381 | g78733 | i0 | 62 | 2.92167101827676 | 121 | 46 | 94.8 | 0 | 21 | 383 | 129 | 249 | UNI74095.1 MAG: hypothetical protein [brine shrimp arlivirus 6] | diamond | 1119 | 160 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsasialis | ||
| 32068247 | 32068247 | PRJNA493827_P_NODE_28658_length_703_cov_2.198413_g26636_i0 | PRJNA493827 | 28658 | 703 | 2.198413 | 15.45484339 | Qianjiang bunya-like virus 4 | 3348931 | Viruses | Viruses | 213 | 7.689999999999999e-61 | NR | XHA87568.1 | 3348931 | g26636 | i0 | 48.7 | 0.972972972972973 | 228 | 106 | 96.9 | 4 | 5 | 685 | 96 | 313 | XHA87568.1 MAG: putative RNA-dependent RNA polymerase, partial [Qianjiang bunya-like virus 4] | diamond | 684 | 213 | 1 | Viruses | Orthornavirae | Negarnaviricota | Ellioviricetes | Bunyavirales | Qianjiang bunya-like virus 4 | ||||
| 32131690 | 32131690 | PRJNA493827_P_NODE_100898_length_341_cov_1.149254_g98700_i0 | PRJNA493827 | 100898 | 341 | 1.149254 | 3.91895614 | Qianjiang bunya-like virus 4 | 3348931 | Viruses | Viruses | 87 | 3.38e-17 | NR | XHA87568.1 | 3348931 | g98700 | i0 | 36.6 | 0.818181818181818 | 93 | 59 | 81.8 | 0 | 5 | 283 | 7 | 99 | XHA87568.1 MAG: putative RNA-dependent RNA polymerase, partial [Qianjiang bunya-like virus 4] | diamond | 279 | 87 | 1 | Viruses | Orthornavirae | Negarnaviricota | Ellioviricetes | Bunyavirales | Qianjiang bunya-like virus 4 | ||||
| 32763372 | 32763372 | PRJNA493827_P_NODE_137000_length_292_cov_0.872146_g134802_i0 | PRJNA493827 | 137000 | 292 | 0.872146 | 2.54666632 | Qianjiang bunya-like virus 4 | 3348931 | Viruses | Viruses | 76.3 | 1.12e-13 | NR | XHA87568.1 | 3348931 | g134802 | i0 | 51.3 | 0.780821917808219 | 76 | 36 | 78.1 | 1 | 291 | 64 | 164 | 238 | XHA87568.1 MAG: putative RNA-dependent RNA polymerase, partial [Qianjiang bunya-like virus 4] | diamond | 228 | 76.3 | 1 | Viruses | Orthornavirae | Negarnaviricota | Ellioviricetes | Bunyavirales | Qianjiang bunya-like virus 4 | ||||
| 32857869 | 32857869 | PRJNA493827_P_NODE_181400_length_253_cov_1.283333_g179202_i0 | PRJNA493827 | 181400 | 253 | 1.283333 | 3.24683249 | brine shrimp yue-like virus 9 | 2900461 | Viruses | Viruses | 82.4 | 4.77e-16 | NR | UNI74195.1 | 2900461 | g179202 | i0 | 64 | 0.889328063241107 | 75 | 23 | 86.6 | 2 | 2 | 220 | 2318 | 2390 | UNI74195.1 MAG: RNA-dependent RNA polymerase [brine shrimp yue-like virus 9] | diamond | 225 | 82.4 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | brine shrimp yue-like virus 9 |
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);;