contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA1166865" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15067253 | 15067253 | PRJNA1166865_P_NODE_39472_length_347_cov_0.843066_g39231_i0 | PRJNA1166865 | 39472 | 347 | 0.843066 | 2.92543902 | Solumvirus sp. | 2487773 | Viruses | Viruses | 151 | 2.27e-43 | NR | AYV86227.1 | 2487773 | g39231 | i0 | 65.5 | 1.0028818443804 | 116 | 39 | 99.4 | 1 | 346 | 2 | 50 | 165 | AYV86227.1 MAG: hypothetical protein Solumvirus2_34 [Solumvirus sp.] | diamond | 348 | 151 | 1 | Viruses | Pithoviruses | Solumvirus sp. | |||||||
| 26692202 | 26692202 | PRJNA1166865_P_NODE_93441_length_242_cov_0.911243_g93200_i0 | PRJNA1166865 | 93441 | 242 | 0.911243 | 2.20520806 | uncultured virus | 340016 | Viruses | Viruses | 79 | 1.15e-15 | NR | CAH6419623.1 | 340016 | g93200 | i0 | 51.3 | 0.991735537190083 | 80 | 31 | 99.2 | 1 | 2 | 241 | 51 | 122 | CAH6419623.1 Hypothetical protein HVR_LOCUS694 [uncultured virus] | diamond | 240 | 79 | 1 | Viruses | uncultured virus | ||||||||
| 26945416 | 26945416 | PRJNA1166865_P_NODE_61582_length_282_cov_1.392344_g61341_i0 | PRJNA1166865 | 61582 | 282 | 1.392344 | 3.92641008 | African cichlid piscichuvirus | 3065075 | Viruses | Viruses | 82 | 9.73e-16 | NR | WLN26256.1 | 3065075 | g61341 | i0 | 45.3 | 1.01063829787234 | 95 | 50 | 98.9 | 1 | 279 | 1 | 117 | 211 | WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus] | diamond | 285 | 82 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Piscichuvirus | African cichlid piscichuvirus | ||
| 27325005 | 27325005 | PRJNA1166865_P_NODE_63743_length_277_cov_1.509804_g63502_i0 | PRJNA1166865 | 63743 | 277 | 1.509804 | 4.18215708 | Solumvirus sp. | 2487773 | Viruses | Viruses | 129 | 5.23e-35 | NR | AYV86227.1 | 2487773 | g63502 | i0 | 65.9 | 0.985559566787004 | 91 | 31 | 98.6 | 0 | 273 | 1 | 56 | 146 | AYV86227.1 MAG: hypothetical protein Solumvirus2_34 [Solumvirus sp.] | diamond | 273 | 129 | 1 | Viruses | Pithoviruses | Solumvirus sp. | |||||||
| 27672503 | 27672503 | PRJNA1166865_P_NODE_86644_length_245_cov_0.895349_g86403_i0 | PRJNA1166865 | 86644 | 245 | 0.895349 | 2.19360505 | Siphoviridae sp. ctBtS1 | 2832643 | Viruses | Viruses | 56.6 | 3.88e-7 | NR | DAE22056.1 | 2826190 | g86403 | i0 | 45.2 | 1.62857142857143 | 62 | 27 | 67.3 | 1 | 168 | 4 | 58 | 119 | DAE22056.1 MAG TPA: Xylosidase [Siphoviridae sp. ctBtS10] | diamond | 399 | 56.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Siphoviridae sp. ctBtS10 | |||||
| 27767286 | 27767286 | PRJNA1166865_P_NODE_89004_length_244_cov_0.900585_g88763_i0 | PRJNA1166865 | 89004 | 244 | 0.900585 | 2.1974274 | Yasminevirus sp. GU-2 | 3060817 | Viruses | Viruses | 50.1 | 2.6e-5 | NR | VBB18571.1 | 2420051 | g88763 | i0 | 41.1 | 0.688524590163934 | 56 | 33 | 68.9 | 0 | 2 | 169 | 80 | 135 | VBB18571.1 vesicle-associated membrane [Yasminevirus sp. GU-2018] | diamond | 168 | 50.1 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Yasminevirus | Yasminevirus saudimassiliense | ||
| 27798796 | 27798796 | PRJNA1166865_P_NODE_73464_length_254_cov_1.701657_g73223_i0 | PRJNA1166865 | 73464 | 254 | 1.701657 | 4.32220878 | Sylvanvirus sp. | 2487774 | Viruses | Viruses | 102 | 9.83e-26 | NR | AYV86982.1 | 2487774 | g73223 | i0 | 70.6 | 0.803149606299213 | 68 | 20 | 80.3 | 0 | 253 | 50 | 69 | 136 | AYV86982.1 MAG: nucleic acid-binding protein [Sylvanvirus sp.] | diamond | 204 | 102 | 1 | Viruses | Sylvanvirus sp. | ||||||||
| 27861649 | 27861649 | PRJNA1166865_P_NODE_89045_length_244_cov_0.900585_g88804_i0 | PRJNA1166865 | 89045 | 244 | 0.900585 | 2.1974274 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 127 | 3.22e-36 | NR | XOR38063.1 | 2832643 | g88804 | i0 | 73.8 | 0.983606557377049 | 80 | 21 | 98.4 | 0 | 240 | 1 | 18 | 97 | XOR38063.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 240 | 127 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28007468 | 28007468 | PRJNA1166865_P_NODE_13645_length_579_cov_1.521739_g13409_i0 | PRJNA1166865 | 13645 | 579 | 1.521739 | 8.81086881 | root | 1 | Root_unresolved | Root_unresolved | 153 | 5.63e-44 | NR | CAB4133097.1 | 2100421 | g13409 | i0 | 50.7 | 2.20725388601036 | 150 | 70 | 76.7 | 3 | 566 | 123 | 1 | 148 | CAB4133097.1 HNHc domain containing protein [uncultured Caudovirales phage] | diamond | 1278 | 154 | 0.993506493506494 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 28051166 | 28051166 | PRJNA1166865_P_NODE_1925_length_1295_cov_3.756137_g1833_i0 | PRJNA1166865 | 1925 | 1295 | 3.756137 | 48.64197415 | Kaumoebavirus | 1859492 | Viruses | Viruses | 54.7 | 7.75e-4 | NR | QQV29711.1 | 1859492 | g1833 | i0 | 23.7 | 0.646332046332046 | 279 | 144 | 58.4 | 10 | 1104 | 349 | 513 | 749 | QQV29711.1 flagellar motor rotation protein [Kaumoebavirus] | diamond | 837 | 54.7 | 1 | Viruses | Kaumoebavirus | ||||||||
| 30071990 | 30071990 | PRJNA1166865_P_NODE_88052_length_244_cov_1.789474_g87811_i0 | PRJNA1166865 | 88052 | 244 | 1.789474 | 4.36631656 | Fadolivirus algeromassiliense | 3060017 | Viruses | Viruses | 86.7 | 3.41e-19 | NR | YP_010804033.1 | 3060017 | g87811 | i0 | 53.3 | 0.922131147540984 | 75 | 35 | 92.2 | 0 | 242 | 18 | 81 | 155 | YP_010804033.1 mitochondrial 18kda protein [Fadolivirus algeromassiliense] | diamond | 225 | 86.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Fadolivirus | Fadolivirus algeromassiliense | ||
| 30103522 | 30103522 | PRJNA1166865_P_NODE_75132_length_251_cov_0.865169_g74891_i0 | PRJNA1166865 | 75132 | 251 | 0.865169 | 2.17157419 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 43.5 | 0.0215 | NR | XOR46424.1 | 2832643 | g74891 | i0 | 34.2 | 1.74501992031873 | 73 | 46 | 86.1 | 2 | 226 | 11 | 379 | 450 | XOR46424.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 438 | 43.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30325373 | 30325373 | PRJNA1166865_P_NODE_27132_length_413_cov_1.170588_g26891_i0 | PRJNA1166865 | 27132 | 413 | 1.170588 | 4.83452844 | TTV-like mini virus | 93678 | Viruses | Viruses | 44.7 | 0.0465 | NR | UGV38236.1 | 93678 | g26891 | i0 | 31.8 | 0.617433414043584 | 85 | 49 | 56.7 | 2 | 180 | 413 | 385 | 467 | UGV38236.1 MAG: ORF1 [TTV-like mini virus] | diamond | 255 | 44.7 | 1 | Viruses | Shotokuvirae | Commensaviricota | Cardeaviricetes | Sanitavirales | Anelloviridae | Betatorquevirus | TTV-like mini virus | ||
| 30546008 | 30546008 | PRJNA1166865_P_NODE_68413_length_266_cov_1.595855_g68172_i0 | PRJNA1166865 | 68413 | 266 | 1.595855 | 4.2449743 | Sylvanvirus sp. | 2487774 | Viruses | Viruses | 70.5 | 2.06e-12 | NR | AYV86745.1 | 2487774 | g68172 | i0 | 50 | 0.744360902255639 | 66 | 33 | 74.4 | 0 | 1 | 198 | 86 | 151 | AYV86745.1 MAG: hypothetical protein Sylvanvirus8_1, partial [Sylvanvirus sp.] | diamond | 198 | 70.5 | 1 | Viruses | Sylvanvirus sp. | ||||||||
| 31070932 | 31070932 | PRJNA1166865_P_NODE_93775_length_241_cov_1.375000_g93534_i0 | PRJNA1166865 | 93775 | 241 | 1.375 | 3.31375 | root | 1 | Root_unresolved | Root_unresolved | 104 | 2.18e-24 | NR | CAH6419174.1 | 340016 | g93534 | i0 | 68.4 | 3.93360995850622 | 79 | 24 | 98.3 | 1 | 239 | 3 | 139 | 216 | CAH6419174.1 S-adenosylmethionine synthetase [uncultured virus] | diamond | 948 | 105 | 0.990476190476191 | Viruses | uncultured virus | ||||||||
| 31145844 | 31145844 | PRJNA1166865_P_NODE_12835_length_597_cov_1.078244_g12601_i0 | PRJNA1166865 | 12835 | 597 | 1.078244 | 6.43711668 | Fadolivirus algeromassiliense | 3060017 | Viruses | Viruses | 147 | 9.1e-40 | NR | YP_010802970.1 | 3060017 | g12601 | i0 | 61 | 0.592964824120603 | 118 | 43 | 58.8 | 2 | 356 | 6 | 1 | 116 | YP_010802970.1 rhamnose synthesis protein [Fadolivirus algeromassiliense] | diamond | 354 | 147 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Fadolivirus | Fadolivirus algeromassiliense | ||
| 31399470 | 31399470 | PRJNA1166865_P_NODE_70556_length_261_cov_1.622340_g70315_i0 | PRJNA1166865 | 70556 | 261 | 1.62234 | 4.2343074 | Edafosvirus sp. | 2487765 | Viruses | Viruses | 98.2 | 1.4500000000000002e-21 | NR | AYV78949.1 | 2487765 | g70315 | i0 | 53.1 | 0.931034482758621 | 81 | 38 | 93.1 | 0 | 248 | 6 | 520 | 600 | AYV78949.1 MAG: hypothetical protein Edafosvirus57_2, partial [Edafosvirus sp.] | diamond | 243 | 98.2 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Edafosvirus sp. | |||
| 31399485 | 31399485 | PRJNA1166865_P_NODE_88196_length_244_cov_1.350877_g87955_i0 | PRJNA1166865 | 88196 | 244 | 1.350877 | 3.29613988 | Solumvirus sp. | 2487773 | Viruses | Viruses | 55.1 | 9.61e-7 | NR | AYV86227.1 | 2487773 | g87955 | i0 | 36.7 | 1.95491803278689 | 79 | 47 | 93.4 | 2 | 230 | 3 | 30 | 108 | AYV86227.1 MAG: hypothetical protein Solumvirus2_34 [Solumvirus sp.] | diamond | 477 | 55.1 | 1 | Viruses | Pithoviruses | Solumvirus sp. | |||||||
| 31462767 | 31462767 | PRJNA1166865_P_NODE_43156_length_333_cov_1.776923_g42915_i0 | PRJNA1166865 | 43156 | 333 | 1.776923 | 5.91715359 | Tupanvirus soda lake | 2126985 | Viruses | Viruses | 62 | 1.71e-8 | NR | YP_010781729.1 | 2126985 | g42915 | i0 | 43.1 | 2.54954954954955 | 72 | 41 | 64.9 | 0 | 242 | 27 | 18 | 89 | YP_010781729.1 serine-tRNA synthetase [Tupanvirus soda lake] | diamond | 849 | 62 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Tupanvirus | Tupanvirus salinum | ||
| 31652140 | 31652140 | PRJNA1166865_P_NODE_5277_length_894_cov_2.700365_g5096_i0 | PRJNA1166865 | 5277 | 894 | 2.700365 | 24.1412631 | Harvfovirus sp. | 2487768 | Viruses | Viruses | 124 | 6.38e-31 | NR | AYV81692.1 | 2487768 | g5096 | i0 | 43.7 | 0.422818791946309 | 126 | 69 | 42.3 | 1 | 827 | 450 | 13 | 136 | AYV81692.1 MAG: putative eukaryotic translation initiation factor 5A-1 [Harvfovirus sp.] | diamond | 378 | 124 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Harvfovirus sp. | |||
| 31905316 | 31905316 | PRJNA1166865_P_NODE_46017_length_324_cov_1.219124_g45776_i0 | PRJNA1166865 | 46017 | 324 | 1.219124 | 3.94996176 | Solumvirus sp. | 2487773 | Viruses | Viruses | 58.9 | 1.92e-7 | NR | AYV86402.1 | 2487773 | g45776 | i0 | 36.5 | 0.685185185185185 | 74 | 42 | 68.5 | 1 | 270 | 49 | 26 | 94 | AYV86402.1 MAG: hypothetical protein Solumvirus9_2 [Solumvirus sp.] | diamond | 222 | 58.9 | 1 | Viruses | Pithoviruses | Solumvirus sp. | |||||||
| 32475074 | 32475074 | PRJNA1166865_P_NODE_33639_length_373_cov_1.026667_g33398_i0 | PRJNA1166865 | 33639 | 373 | 1.026667 | 3.82946791 | Barrevirus sp. | 2487763 | Viruses | Viruses | 132 | 2.09e-34 | NR | AYV77211.1 | 2487763 | g33398 | i0 | 56.1 | 0.989276139410188 | 123 | 51 | 98.9 | 3 | 370 | 2 | 212 | 331 | AYV77211.1 MAG: hypothetical protein Barrevirus19_6 [Barrevirus sp.] | diamond | 369 | 132 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Barrevirus sp. | |||
| 32506784 | 32506784 | PRJNA1166865_P_NODE_8659_length_718_cov_5.568992_g8444_i0 | PRJNA1166865 | 8659 | 718 | 5.568992 | 39.98536256 | Solumvirus sp. | 2487773 | Viruses | Viruses | 232 | 3.77e-73 | NR | AYV86227.1 | 2487773 | g8444 | i0 | 80.6 | 0.601671309192201 | 144 | 28 | 60.2 | 0 | 104 | 535 | 41 | 184 | AYV86227.1 MAG: hypothetical protein Solumvirus2_34 [Solumvirus sp.] | diamond | 432 | 232 | 1 | Viruses | Pithoviruses | Solumvirus sp. | |||||||
| 32506790 | 32506790 | PRJNA1166865_P_NODE_92299_length_242_cov_0.911243_g92058_i0 | PRJNA1166865 | 92299 | 242 | 0.911243 | 2.20520806 | Sylvanvirus sp. | 2487774 | Viruses | Viruses | 46.2 | 0.00109 | NR | AYV87113.1 | 2487774 | g92058 | i0 | 35.4 | 0.805785123966942 | 65 | 36 | 73.1 | 1 | 180 | 4 | 1 | 65 | AYV87113.1 MAG: hypothetical protein Sylvanvirus26_3 [Sylvanvirus sp.] | diamond | 195 | 46.2 | 1 | Viruses | Sylvanvirus sp. |
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);;