contig_metadata
27 rows where analysis = "diamond", bioproject = "PRJNA908278" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8901950 | 8901950 | PRJNA908278_P_NODE_21167_length_281_cov_1.480769_g21064_i0 | PRJNA908278 | 21167 | 281 | 1.480769 | 4.16096089 | root | 1 | Root_unresolved | Root_unresolved | 118 | 2.37e-29 | NR | CAH6419174.1 | 340016 | g21064 | i0 | 62.4 | 3.97153024911032 | 93 | 35 | 99.3 | 0 | 2 | 280 | 134 | 226 | CAH6419174.1 S-adenosylmethionine synthetase [uncultured virus] | diamond | 1116 | 118 | 1 | Viruses | uncultured virus | ||||||||
| 26834637 | 26834637 | PRJNA908278_P_NODE_3721_length_593_cov_2.115385_g3618_i0 | PRJNA908278 | 3721 | 593 | 2.115385 | 12.54423305 | Satyrvirus sp. | 2487771 | Viruses | Viruses | 95.1 | 1.81e-20 | NR | AYV85215.1 | 2487771 | g3618 | i0 | 31.8 | 1.84148397976391 | 173 | 109 | 86.5 | 4 | 525 | 13 | 19 | 184 | AYV85215.1 MAG: START domain containing protein [Satyrvirus sp.] | diamond | 1092 | 95.1 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Satyrvirus sp. | |||
| 27095049 | 27095049 | PRJNA908278_P_NODE_16242_length_314_cov_1.908714_g16139_i0 | PRJNA908278 | 16242 | 314 | 1.908714 | 5.99336196 | Mimiviridae | 549779 | Viruses | Viruses | 84 | 2.29e-17 | NR | ARF12537.1 | 1977640 | g16139 | i0 | 40.2 | 2.02547770700637 | 107 | 55 | 97.5 | 3 | 308 | 3 | 35 | 137 | ARF12537.1 hypothetical protein Klosneuvirus_6_99 [Klosneuvirus KNV1] | diamond | 636 | 84.3 | 0.99644128113879 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Klosneuvirus | Klosneuvirus KNV1 | ||
| 27372385 | 27372385 | PRJNA908278_P_NODE_20803_length_283_cov_1.466667_g20700_i0 | PRJNA908278 | 20803 | 283 | 1.466667 | 4.15066761 | Agaricus bisporus virus 6 | 1945750 | Viruses | Viruses | 190 | 8.6e-54 | NR | AQM32763.1 | 1945750 | g20700 | i0 | 96.8 | 1.99293286219081 | 94 | 3 | 99.6 | 0 | 1 | 282 | 907 | 1000 | AQM32763.1 replicase [Agaricus bisporus virus 6] | diamond | 564 | 190 | 1 | Viruses | Agaricus bisporus virus 6 | ||||||||
| 27379782 | 27379782 | PRJNA908278_P_NODE_22263_length_275_cov_1.346535_g22160_i0 | PRJNA908278 | 22263 | 275 | 1.346535 | 3.70297125 | Mimiviridae | 549779 | Viruses | Viruses | 67.4 | 1.19e-10 | NR | YP_010841334.1 | 2811091 | g22160 | i0 | 47.4 | 5.08363636363636 | 76 | 34 | 79.6 | 3 | 223 | 5 | 1442 | 1514 | YP_010841334.1 putative serine/threonine-protein kinase [Cotonvirus japonicus] | diamond | 1398 | 67.4 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Cotonvirus | Cotonvirus japonicum | ||
| 27529946 | 27529946 | PRJNA908278_P_NODE_33503_length_243_cov_0.905882_g33400_i0 | PRJNA908278 | 33503 | 243 | 0.905882 | 2.20129326 | Tupanvirus soda lake | 2126985 | Viruses | Viruses | 83.6 | 1.55e-16 | NR | YP_010782648.1 | 2126985 | g33400 | i0 | 49.4 | 1 | 81 | 40 | 98.8 | 1 | 242 | 3 | 373 | 453 | YP_010782648.1 elongation factor 2 [Tupanvirus soda lake] | diamond | 243 | 83.6 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Tupanvirus | Tupanvirus salinum | ||
| 27656415 | 27656415 | PRJNA908278_P_NODE_20464_length_285_cov_1.452830_g20361_i0 | PRJNA908278 | 20464 | 285 | 1.45283 | 4.1405655 | Riboviria sp. | 2585031 | Viruses | Viruses | 100 | 5.1299999999999997e-23 | NR | QDH89928.1 | 2585031 | g20361 | i0 | 53.3 | 3.90526315789474 | 92 | 42 | 96.8 | 1 | 284 | 9 | 91 | 181 | QDH89928.1 MAG: RNA-dependent RNA polymerase, partial [Riboviria sp.] | diamond | 1113 | 100 | 1 | Viruses | Riboviria sp. | ||||||||
| 27751210 | 27751210 | PRJNA908278_P_NODE_22684_length_272_cov_1.547739_g22581_i0 | PRJNA908278 | 22684 | 272 | 1.547739 | 4.20985008 | African cichlid piscichuvirus | 3065075 | Viruses | Viruses | 86.7 | 1.98e-17 | NR | WLN26256.1 | 3065075 | g22581 | i0 | 49.4 | 0.915441176470588 | 83 | 42 | 91.5 | 0 | 5 | 253 | 152 | 234 | WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus] | diamond | 249 | 86.7 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Piscichuvirus | African cichlid piscichuvirus | ||
| 27782702 | 27782702 | PRJNA908278_P_NODE_35424_length_241_cov_0.916667_g35321_i0 | PRJNA908278 | 35424 | 241 | 0.916667 | 2.20916747 | Emiliania huxleyi virus 2 | 181208 | Viruses | Viruses | 120 | 5.799999999999999e-31 | NR | AET42571.1 | 181211 | g35321 | i0 | 68.4 | 1.96680497925311 | 79 | 25 | 98.3 | 0 | 239 | 3 | 151 | 229 | AET42571.1 fatty acid elongase [Emiliania huxleyi virus 202] | diamond | 474 | 120 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Algavirales | Phycodnaviridae | Coccolithovirus | Emiliania huxleyi virus 202 | ||
| 27814383 | 27814383 | PRJNA908278_P_NODE_33744_length_243_cov_0.905882_g33641_i0 | PRJNA908278 | 33744 | 243 | 0.905882 | 2.20129326 | Agaricus bisporus virus 3 | 1945748 | Viruses | Viruses | 163 | 1.77e-44 | NR | AQM49919.1 | 1945748 | g33641 | i0 | 87.5 | 0.987654320987654 | 80 | 10 | 98.8 | 0 | 3 | 242 | 1865 | 1944 | AQM49919.1 replicase [Agaricus bisporus virus 3] | diamond | 240 | 163 | 1 | Viruses | Agaricus bisporus virus 3 | ||||||||
| 28224379 | 28224379 | PRJNA908278_P_NODE_26326_length_251_cov_1.297753_g26223_i0 | PRJNA908278 | 26326 | 251 | 1.297753 | 3.25736003 | European chub iridovirus | 2578140 | Viruses | Viruses | 51.6 | 2.14e-6 | NR | QCQ67839.1 | 2578140 | g26223 | i0 | 44.8 | 1.51792828685259 | 58 | 31 | 69.3 | 1 | 229 | 56 | 15 | 71 | QCQ67839.1 ubiquitin family protein [European chub iridovirus] | diamond | 381 | 51.6 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Iridoviridae | European chub iridovirus | |||
| 28224383 | 28224383 | PRJNA908278_P_NODE_30266_length_247_cov_0.885057_g30163_i0 | PRJNA908278 | 30266 | 247 | 0.885057 | 2.18609079 | Solumvirus sp. | 2487773 | Viruses | Viruses | 50.1 | 7.24e-5 | NR | AYV86227.1 | 2487773 | g30163 | i0 | 65.8 | 0.461538461538462 | 38 | 13 | 46.2 | 0 | 1 | 114 | 156 | 193 | AYV86227.1 MAG: hypothetical protein Solumvirus2_34 [Solumvirus sp.] | diamond | 114 | 50.1 | 1 | Viruses | Pithoviruses | Solumvirus sp. | |||||||
| 28540564 | 28540564 | PRJNA908278_P_NODE_26027_length_253_cov_0.933333_g25924_i0 | PRJNA908278 | 26027 | 253 | 0.933333 | 2.36133249 | Tupanvirus soda lake | 2126985 | Viruses | Viruses | 78.6 | 1.05e-14 | NR | YP_010782648.1 | 2126985 | g25924 | i0 | 47 | 1.96837944664032 | 83 | 43 | 97.2 | 1 | 246 | 1 | 398 | 480 | YP_010782648.1 elongation factor 2 [Tupanvirus soda lake] | diamond | 498 | 78.6 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Tupanvirus | Tupanvirus salinum | ||
| 28792774 | 28792774 | PRJNA908278_P_NODE_35207_length_241_cov_0.916667_g35104_i0 | PRJNA908278 | 35207 | 241 | 0.916667 | 2.20916747 | uncultured virus | 340016 | Viruses | Viruses | 74.7 | 1.74e-13 | NR | CAH6419317.1 | 340016 | g35104 | i0 | 51.3 | 0.946058091286307 | 76 | 35 | 93.4 | 2 | 239 | 15 | 224 | 298 | CAH6419317.1 Domain of unknown function (DUF4419)-containing protein [uncultured virus] | diamond | 228 | 74.7 | 1 | Viruses | uncultured virus | ||||||||
| 28919040 | 28919040 | PRJNA908278_P_NODE_28968_length_248_cov_1.320000_g28865_i0 | PRJNA908278 | 28968 | 248 | 1.32 | 3.2736 | uncultured virus | 340016 | Viruses | Viruses | 85.1 | 4.77e-17 | NR | CAH6419867.1 | 340016 | g28865 | i0 | 70.2 | 0.689516129032258 | 57 | 16 | 69 | 1 | 181 | 11 | 8 | 63 | CAH6419867.1 Mthfr-prov protein [uncultured virus] | diamond | 171 | 85.1 | 1 | Viruses | uncultured virus | ||||||||
| 29424184 | 29424184 | PRJNA908278_P_NODE_12109_length_354_cov_2.398577_g12006_i0 | PRJNA908278 | 12109 | 354 | 2.398577 | 8.49096258 | Megavirus haemonchus182742 | 3116716 | Viruses | Viruses | 87.8 | 2.15e-17 | NR | DBA45839.1 | 3116716 | g12006 | i0 | 54.4 | 0.669491525423729 | 79 | 35 | 66.9 | 1 | 109 | 345 | 21 | 98 | DBA45839.1 MAG TPA_asm: Kowoid2 [Megavirus haemonchus182742] | diamond | 237 | 87.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Megavirus | Megavirus haemonchus182742 | ||
| 29739890 | 29739890 | PRJNA908278_P_NODE_2850_length_667_cov_6.836700_g2747_i0 | PRJNA908278 | 2850 | 667 | 6.8367000000000004 | 45.600789 | Barrevirus sp. | 2487763 | Viruses | Viruses | 118 | 5.799999999999998e-29 | NR | AYV77273.1 | 2487763 | g2747 | i0 | 28.4 | 0.949025487256372 | 211 | 145 | 94 | 3 | 35 | 661 | 9 | 215 | AYV77273.1 MAG: START domain containing protein [Barrevirus sp.] | diamond | 633 | 118 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Barrevirus sp. | |||
| 30309256 | 30309256 | PRJNA908278_P_NODE_3072_length_643_cov_1.526316_g2969_i0 | PRJNA908278 | 3072 | 643 | 1.526316 | 9.81421188 | Synechococcus phage S-SRM | 3060697 | Viruses | Viruses | 85.9 | 1.17e-15 | NR | YP_010670319.1 | 2781608 | g2969 | i0 | 32.7 | 0.685847589424572 | 147 | 87 | 63 | 3 | 626 | 222 | 112 | 258 | YP_010670319.1 regulator of chromosome condensation [Synechococcus phage S-SRM01] | diamond | 441 | 85.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pantevenvirales | Kyanoviridae | Serangoonvirus | Serangoonvirus essarone | ||
| 31319898 | 31319898 | PRJNA908278_P_NODE_7095_length_444_cov_1.247978_g6992_i0 | PRJNA908278 | 7095 | 444 | 1.247978 | 5.54102232 | uncultured virus | 340016 | Viruses | Viruses | 191 | 1.15e-54 | NR | CAH6419867.1 | 340016 | g6992 | i0 | 65 | 0.966216216216216 | 143 | 48 | 95.9 | 2 | 14 | 439 | 321 | 462 | CAH6419867.1 Mthfr-prov protein [uncultured virus] | diamond | 429 | 191 | 1 | Viruses | uncultured virus | ||||||||
| 31351641 | 31351641 | PRJNA908278_P_NODE_14776_length_327_cov_1.212598_g14673_i0 | PRJNA908278 | 14776 | 327 | 1.212598 | 3.96519546 | Marseillevirus LCMAC1 | 2506602 | Viruses | Viruses | 54.3 | 1.17e-6 | NR | QBK85646.1 | 2506602 | g14673 | i0 | 38.5 | 0.596330275229358 | 65 | 40 | 59.6 | 0 | 292 | 98 | 36 | 100 | QBK85646.1 MAG: hypothetical protein LCMAC101_02410 [Marseillevirus LCMAC101] | diamond | 195 | 54.3 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Marseilleviridae | Marseillevirus LCMAC101 | |||
| 31446493 | 31446493 | PRJNA908278_P_NODE_25476_length_256_cov_1.262295_g25373_i0 | PRJNA908278 | 25476 | 256 | 1.262295 | 3.2314752 | Agaricus bisporus virus 3 | 1945748 | Viruses | Viruses | 53.1 | 9.51e-6 | NR | AQM49919.1 | 1945748 | g25373 | i0 | 36.3 | 2.1328125 | 91 | 50 | 97.3 | 2 | 6 | 254 | 2021 | 2111 | AQM49919.1 replicase [Agaricus bisporus virus 3] | diamond | 546 | 53.1 | 1 | Viruses | Agaricus bisporus virus 3 | ||||||||
| 31478296 | 31478296 | PRJNA908278_P_NODE_34716_length_242_cov_0.911243_g34613_i0 | PRJNA908278 | 34716 | 242 | 0.911243 | 2.20520806 | Parvovirus marine5623s3 | 3117132 | Viruses | Viruses | 49.7 | 1.25e-4 | NR | DBA45660.1 | 3117132 | g34613 | i0 | 37.7 | 0.954545454545455 | 77 | 42 | 89.3 | 2 | 3 | 218 | 190 | 265 | DBA45660.1 MAG TPA_asm: P5662, partial [Parvovirus marine5623s3] | diamond | 231 | 49.7 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvovirus marine5623s3 | |||
| 31984107 | 31984107 | PRJNA908278_P_NODE_22458_length_274_cov_1.144279_g22355_i0 | PRJNA908278 | 22458 | 274 | 1.144279 | 3.13532446 | Megavirus haemonchus182742 | 3116716 | Viruses | Viruses | 51.2 | 5.15e-5 | NR | DBA45825.1 | 3116716 | g22355 | i0 | 31.5 | 0.799270072992701 | 73 | 50 | 79.9 | 0 | 47 | 265 | 236 | 308 | DBA45825.1 MAG TPA_asm: Kowoid1 [Megavirus haemonchus182742] | diamond | 219 | 51.2 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Megavirus | Megavirus haemonchus182742 | ||
| 32174297 | 32174297 | PRJNA908278_P_NODE_28878_length_248_cov_1.760000_g28775_i0 | PRJNA908278 | 28878 | 248 | 1.76 | 4.3648 | Agaricus bisporus virus 5 | 1945749 | Viruses | Viruses | 49.7 | 1.47e-4 | NR | AQM49927.1 | 1945749 | g28775 | i0 | 49.2 | 0.762096774193548 | 63 | 28 | 76.2 | 1 | 58 | 246 | 1991 | 2049 | AQM49927.1 replicase [Agaricus bisporus virus 5] | diamond | 189 | 49.7 | 1 | Viruses | Agaricus bisporus virus 5 | ||||||||
| 32679499 | 32679499 | PRJNA908278_P_NODE_2060_length_773_cov_2.760000_g1966_i0 | PRJNA908278 | 2060 | 773 | 2.76 | 21.3348 | Marseillevirus LCMAC1 | 2506602 | Viruses | Viruses | 52 | 1.35e-4 | NR | QBK85646.1 | 2506602 | g1966 | i0 | 40 | 0.252263906856404 | 65 | 39 | 25.2 | 0 | 102 | 296 | 36 | 100 | QBK85646.1 MAG: hypothetical protein LCMAC101_02410 [Marseillevirus LCMAC101] | diamond | 195 | 52 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Marseilleviridae | Marseillevirus LCMAC101 | |||
| 32711154 | 32711154 | PRJNA908278_P_NODE_15360_length_322_cov_1.236948_g15257_i0 | PRJNA908278 | 15360 | 322 | 1.236948 | 3.98297256 | Terrestrivirus sp. | 2487775 | Viruses | Viruses | 95.5 | 2.87e-20 | NR | AYV76311.1 | 2487775 | g15257 | i0 | 48.1 | 1.00621118012422 | 108 | 53 | 97.8 | 2 | 322 | 8 | 8 | 115 | AYV76311.1 MAG: hypothetical protein Terrestrivirus5_133 [Terrestrivirus sp.] | diamond | 324 | 95.5 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Terrestrivirus sp. | |||
| 32900015 | 32900015 | PRJNA908278_P_NODE_16820_length_310_cov_1.299578_g16717_i0 | PRJNA908278 | 16820 | 310 | 1.299578 | 4.0286918 | Barrevirus sp. | 2487763 | Viruses | Viruses | 50.1 | 1.47e-4 | NR | AYV77273.1 | 2487763 | g16717 | i0 | 28.7 | 0.97741935483871 | 101 | 70 | 97.7 | 1 | 307 | 5 | 52 | 150 | AYV77273.1 MAG: START domain containing protein [Barrevirus sp.] | diamond | 303 | 50.1 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Barrevirus 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);;