contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA986481" and tax_kingdom = "Bamfordvirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18825663 | 18825663 | PRJNA986481_P_NODE_56615_length_245_cov_1.030612_g56090_i0 | PRJNA986481 | 56615 | 245 | 1.030612 | 2.5249994 | root | 1 | Root_unresolved | Root_unresolved | 124 | 7.789999999999999e-31 | NR | ADX05798.1 | 938081 | g56090 | i0 | 69.1 | 1.98367346938776 | 81 | 25 | 99.2 | 0 | 1 | 243 | 290 | 370 | ADX05798.1 putative heat shock protein 70 [Organic Lake phycodnavirus 1] | diamond | 486 | 124 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Algavirales | Phycodnaviridae | Organic Lake phycodnavirus 1 | |||
| 26931505 | 26931505 | PRJNA986481_P_NODE_53582_length_248_cov_1.015075_g53057_i0 | PRJNA986481 | 53582 | 248 | 1.015075 | 2.517386 | Fadolivirus algeromassiliense | 3060017 | Viruses | Viruses | 82.8 | 1.17e-17 | NR | YP_010804033.1 | 3060017 | g53057 | i0 | 47.4 | 0.943548387096774 | 78 | 41 | 94.4 | 0 | 4 | 237 | 94 | 171 | YP_010804033.1 mitochondrial 18kda protein [Fadolivirus algeromassiliense] | diamond | 234 | 82.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Fadolivirus | Fadolivirus algeromassiliense | ||
| 27120897 | 27120897 | PRJNA986481_P_NODE_31962_length_289_cov_1.683333_g31437_i0 | PRJNA986481 | 31962 | 289 | 1.683333 | 4.86483237 | Bodo saltans virus | 2024608 | Viruses | Viruses | 130 | 5.81e-36 | NR | YP_010778932.1 | 2024608 | g31437 | i0 | 69.2 | 0.944636678200692 | 91 | 26 | 94.5 | 1 | 275 | 3 | 1 | 89 | YP_010778932.1 N6-adenine methyltransferase [Bodo saltans virus] | diamond | 273 | 130 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Theiavirus | Theiavirus salishense | ||
| 27468948 | 27468948 | PRJNA986481_P_NODE_33643_length_282_cov_0.948498_g33118_i0 | PRJNA986481 | 33643 | 282 | 0.948498 | 2.67476436 | Hyperionvirus sp. | 2487770 | Viruses | Viruses | 91.3 | 6.18e-20 | NR | AYV83005.1 | 2487770 | g33118 | i0 | 52.4 | 0.893617021276596 | 84 | 37 | 88.3 | 2 | 30 | 278 | 155 | 236 | AYV83005.1 MAG: YchF/TatD family DNA exonuclease [Hyperionvirus sp.] | diamond | 252 | 91.3 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Hyperionvirus sp. | |||
| 27531945 | 27531945 | PRJNA986481_P_NODE_11103_length_492_cov_1.516930_g10580_i0 | PRJNA986481 | 11103 | 492 | 1.51693 | 7.4632956 | Terrestrivirus sp. | 2487775 | Viruses | Viruses | 100 | 9.86e-22 | NR | AYV75160.1 | 2487775 | g10580 | i0 | 44.6 | 0.615853658536585 | 101 | 47 | 61.6 | 1 | 491 | 189 | 224 | 315 | AYV75160.1 MAG: hypothetical protein Terrestrivirus1_34 [Terrestrivirus sp.] | diamond | 303 | 100 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Terrestrivirus sp. | |||
| 28416151 | 28416151 | PRJNA986481_P_NODE_24666_length_330_cov_3.523132_g24141_i0 | PRJNA986481 | 24666 | 330 | 3.523132 | 11.6263356 | Terrestrivirus sp. | 2487775 | Viruses | Viruses | 77.4 | 4.08e-14 | NR | AYV75160.1 | 2487775 | g24141 | i0 | 40.9 | 0.845454545454545 | 93 | 54 | 83.6 | 1 | 18 | 293 | 247 | 339 | AYV75160.1 MAG: hypothetical protein Terrestrivirus1_34 [Terrestrivirus sp.] | diamond | 279 | 77.4 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Terrestrivirus sp. | |||
| 28668750 | 28668750 | PRJNA986481_P_NODE_20287_length_364_cov_1.279365_g19762_i0 | PRJNA986481 | 20287 | 364 | 1.279365 | 4.6568886 | Terrestrivirus sp. | 2487775 | Viruses | Viruses | 80.9 | 3.23e-15 | NR | AYV75160.1 | 2487775 | g19762 | i0 | 36.2 | 1.0467032967033 | 127 | 69 | 97.3 | 3 | 359 | 6 | 98 | 221 | AYV75160.1 MAG: hypothetical protein Terrestrivirus1_34 [Terrestrivirus sp.] | diamond | 381 | 80.9 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Terrestrivirus sp. | |||
| 28794698 | 28794698 | PRJNA986481_P_NODE_27287_length_314_cov_1.962264_g26762_i0 | PRJNA986481 | 27287 | 314 | 1.962264 | 6.16150896 | Klosneuvirus KNV1 | 1977640 | Viruses | Viruses | 44.7 | 0.0181 | NR | ARF11354.1 | 1977640 | g26762 | i0 | 32.7 | 0.964968152866242 | 101 | 61 | 96.5 | 3 | 310 | 8 | 516 | 609 | ARF11354.1 Hsp70 protein [Klosneuvirus KNV1] | diamond | 303 | 44.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Klosneuvirus | Klosneuvirus KNV1 | ||
| 28953045 | 28953045 | PRJNA986481_P_NODE_27248_length_314_cov_3.177358_g26723_i0 | PRJNA986481 | 27248 | 314 | 3.177358 | 9.97690412 | Bodo saltans virus | 2024608 | Viruses | Viruses | 55.5 | 2.64e-6 | NR | YP_010778112.1 | 2024608 | g26723 | i0 | 38.4 | 0.697452229299363 | 73 | 43 | 67.8 | 1 | 310 | 98 | 263 | 335 | YP_010778112.1 hypothetical protein QJ851_gp0273 [Bodo saltans virus] | diamond | 219 | 55.5 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Theiavirus | Theiavirus salishense | ||
| 30089541 | 30089541 | PRJNA986481_P_NODE_62172_length_229_cov_3.288889_g61647_i0 | PRJNA986481 | 62172 | 229 | 3.288889 | 7.53155581 | Hokovirus HKV1 | 1977638 | Viruses | Viruses | 92 | 1.73e-20 | NR | ARF10338.1 | 1977638 | g61647 | i0 | 46.7 | 0.982532751091703 | 75 | 40 | 98.3 | 0 | 3 | 227 | 178 | 252 | ARF10338.1 mitochondrial carrier protein [Hokovirus HKV1] | diamond | 225 | 92 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Hokovirus | Hokovirus HKV1 | ||
| 31100541 | 31100541 | PRJNA986481_P_NODE_9035_length_542_cov_2.012170_g8521_i0 | PRJNA986481 | 9035 | 542 | 2.01217 | 10.9059614 | Marseillevirus LCMAC1 | 2506602 | Viruses | Viruses | 49.3 | 5.06e-4 | NR | QBK85646.1 | 2506602 | g8521 | i0 | 32.8 | 0.370848708487085 | 67 | 45 | 37.1 | 0 | 408 | 208 | 34 | 100 | QBK85646.1 MAG: hypothetical protein LCMAC101_02410 [Marseillevirus LCMAC101] | diamond | 201 | 49.3 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Marseilleviridae | Marseillevirus LCMAC101 | |||
| 31511903 | 31511903 | PRJNA986481_P_NODE_23416_length_339_cov_1.613793_g22891_i0 | PRJNA986481 | 23416 | 339 | 1.613793 | 5.47075827 | Marseillevirus LCMAC1 | 2506602 | Viruses | Viruses | 52.8 | 5.16e-6 | NR | QBK85646.1 | 2506602 | g22891 | i0 | 24.5 | 0.831858407079646 | 94 | 68 | 83.2 | 1 | 292 | 11 | 33 | 123 | QBK85646.1 MAG: hypothetical protein LCMAC101_02410 [Marseillevirus LCMAC101] | diamond | 282 | 52.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Marseilleviridae | Marseillevirus LCMAC101 | |||
| 32524423 | 32524423 | PRJNA986481_P_NODE_40059_length_264_cov_0.939535_g39534_i0 | PRJNA986481 | 40059 | 264 | 0.939535 | 2.4803724 | Fadolivirus algeromassiliense | 3060017 | Viruses | Viruses | 65.5 | 7.36e-11 | NR | YP_010804033.1 | 3060017 | g39534 | i0 | 54.4 | 0.647727272727273 | 57 | 26 | 64.8 | 0 | 205 | 35 | 17 | 73 | YP_010804033.1 mitochondrial 18kda protein [Fadolivirus algeromassiliense] | diamond | 171 | 65.5 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Fadolivirus | Fadolivirus algeromassiliense |
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);;