contig_metadata
13 rows where bioproject = "PRJNA1174234" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2316232 | 2316232 | PRJNA1174234_P_NODE_3282_length_725_cov_3.616564_g3104_i0 | PRJNA1174234 | 3282 | 725 | 3.616564 | 26.220089 | Chlorella virus XW | 10507 | Viruses | Viruses | 234 | 6.94e-71 | NR | ULY68464.1 | 2922419 | g3104 | i0 | 62.3 | 1.32413793103448 | 162 | 57 | 65.4 | 1 | 123 | 596 | 276 | 437 | ULY68464.1 deoxyribodipyrimidine photo-lyase [Chlorella virus XW01] | diamond | 960 | 234 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Chlorella virus XW01 | |||
| 6694022 | 6694022 | PRJNA1174234_P_NODE_19706_length_311_cov_1.109244_g19510_i0 | PRJNA1174234 | 19706 | 311 | 1.109244 | 3.44974884 | Bandra megavirus | 2071566 | Viruses | Viruses | 54.7 | 0.008 | NTclustered | gi|1336444313|gb|MG779343.1| | 2071566 | g19510 | i0 | 92.308 | 0.665594855305466 | 39 | 1 | 13 | 1 | 17 | 55 | 903 | 867 | Bandra megavirus isolate KK-1 genomic sequence | blastn | 207 | 54.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Megavirus | Bandra megavirus | ||
| 6694062 | 6694062 | PRJNA1174234_P_NODE_2766_length_777_cov_2.276989_g2595_i0 | PRJNA1174234 | 2766 | 777 | 2.276989 | 17.69220453 | Terrestrivirus sp. | 2487775 | Viruses | Viruses | 84.7 | 5.5e-15 | NR | AYV75160.1 | 2487775 | g2595 | i0 | 36.8 | 0.525096525096525 | 136 | 75 | 51.7 | 3 | 776 | 375 | 212 | 338 | AYV75160.1 MAG: hypothetical protein Terrestrivirus1_34 [Terrestrivirus sp.] | diamond | 408 | 84.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Terrestrivirus sp. | |||
| 19442164 | 19442164 | PRJNA1174234_P_NODE_3016_length_751_cov_3.646018_g2841_i0 | PRJNA1174234 | 3016 | 751 | 3.646018 | 27.38159518 | Terrestrivirus sp. | 2487775 | Viruses | Viruses | 226 | 2.14e-69 | NR | AYV76217.1 | 2487775 | g2841 | i0 | 47.8 | 0.978695073235686 | 245 | 117 | 94.7 | 6 | 37 | 747 | 51 | 292 | AYV76217.1 MAG: DUF3050 domain-containing protein [Terrestrivirus sp.] | diamond | 735 | 226 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Terrestrivirus sp. | |||
| 28619835 | 28619835 | PRJNA1174234_P_NODE_5667_length_570_cov_1.503018_g5471_i0 | PRJNA1174234 | 5667 | 570 | 1.503018 | 8.5672026 | Edafosvirus sp. | 2487765 | Viruses | Viruses | 70.9 | 1.76e-10 | NR | AYV78747.1 | 2487765 | g5471 | i0 | 28.7 | 0.789473684210526 | 150 | 77 | 73.7 | 5 | 502 | 83 | 1013 | 1142 | AYV78747.1 MAG: hypothetical protein Edafosvirus29_11 [Edafosvirus sp.] | diamond | 450 | 70.9 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Edafosvirus sp. | |||
| 28651253 | 28651253 | PRJNA1174234_P_NODE_31127_length_248_cov_0.880000_g30931_i0 | PRJNA1174234 | 31127 | 248 | 0.88 | 2.1824 | Pimephales minnow adintovirus | 2609864 | Viruses | Viruses | 71.2 | 1.71e-12 | NR | DAC81400.1 | 2609864 | g30931 | i0 | 41.5 | 0.991935483870968 | 82 | 48 | 99.2 | 0 | 1 | 246 | 39 | 120 | DAC81400.1 TPA_asm: penton [Pimephales minnow adintovirus] | diamond | 246 | 71.2 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Pimephales minnow adintovirus | |||
| 28714367 | 28714367 | PRJNA1174234_P_NODE_13187_length_379_cov_1.241830_g12991_i0 | PRJNA1174234 | 13187 | 379 | 1.24183 | 4.7065357 | Klosneuvirus KNV1 | 1977640 | Viruses | Viruses | 94.4 | 1.71e-20 | NR | ARF12509.1 | 1977640 | g12991 | i0 | 40.5 | 10.9709762532982 | 126 | 75 | 99.7 | 0 | 379 | 2 | 59 | 184 | ARF12509.1 stomatin family protein [Klosneuvirus KNV1] | diamond | 4158 | 94.4 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Klosneuvirus | Klosneuvirus KNV1 | ||
| 28808750 | 28808750 | PRJNA1174234_P_NODE_22588_length_290_cov_1.419355_g22392_i0 | PRJNA1174234 | 22588 | 290 | 1.419355 | 4.1161295 | Marseillevirus LCMAC1 | 2506602 | Viruses | Viruses | 92 | 2.16e-21 | NR | QBK85938.1 | 2506602 | g22392 | i0 | 51 | 0.993103448275862 | 96 | 45 | 99.3 | 1 | 1 | 288 | 42 | 135 | QBK85938.1 MAG: hypothetical protein LCMAC101_05330 [Marseillevirus LCMAC101] | diamond | 288 | 92 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Marseilleviridae | Marseillevirus LCMAC101 | |||
| 29219685 | 29219685 | PRJNA1174234_P_NODE_34609_length_243_cov_0.864706_g34413_i0 | PRJNA1174234 | 34609 | 243 | 0.864706 | 2.10123558 | Adintovirus pavo15764 | 3115938 | Viruses | Viruses | 82.4 | 4.26e-17 | NR | DBA50340.1 | 3115938 | g34413 | i0 | 49.3 | 0.925925925925926 | 75 | 38 | 92.6 | 0 | 239 | 15 | 81 | 155 | DBA50340.1 MAG TPA_asm: PacK [Adintovirus pavo15764] | diamond | 225 | 82.4 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus pavo15764 | |||
| 30134987 | 30134987 | PRJNA1174234_P_NODE_10892_length_419_cov_1.228324_g10696_i0 | PRJNA1174234 | 10892 | 419 | 1.228324 | 5.14667756 | Mimivirus sp. | 2742700 | Viruses | Viruses | 98.2 | 3.929999999999999e-23 | NR | QZX43511.1 | 2742700 | g10696 | i0 | 45 | 1.43198090692124 | 100 | 52 | 69.5 | 1 | 26 | 316 | 40 | 139 | QZX43511.1 phosphatidylethanolamine-binding protein [Mimivirus sp.] | diamond | 600 | 98.2 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Mimivirus | Mimivirus sp. | ||
| 31133720 | 31133720 | PRJNA1174234_P_NODE_30235_length_249_cov_1.289773_g30039_i0 | PRJNA1174234 | 30235 | 249 | 1.289773 | 3.21153477 | root | 1 | Root_unresolved | Root_unresolved | 50.1 | 9.63e-5 | NR | VBB18459.1 | 2420051 | g30039 | i0 | 35.3 | 1.78313253012048 | 68 | 41 | 78.3 | 1 | 36 | 230 | 161 | 228 | VBB18459.1 class I SAM-dependent methyltransferase [Yasminevirus sp. GU-2018] | diamond | 444 | 50.1 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Yasminevirus | Yasminevirus saudimassiliense | ||
| 31430935 | 31430935 | PRJNA1174234_P_NODE_2596_length_798_cov_1.743448_g2430_i0 | PRJNA1174234 | 2596 | 798 | 1.743448 | 13.91271504 | Catovirus sp. 'naegleriensis' | 3072188 | Viruses | Viruses | 134 | 4.3199999999999996e-32 | NR | CAK7596644.1 | 3072188 | g2430 | i0 | 39.1 | 0.654135338345865 | 174 | 101 | 65 | 3 | 796 | 278 | 355 | 524 | CAK7596644.1 Ubiquitin-conjugating enzyme/RWD-like homologoussuperfamily domain-containing protein [Catovirus sp. 'naegleriensis'] | diamond | 522 | 134 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Catovirus | Catovirus sp. 'naegleriensis' | ||
| 31936997 | 31936997 | PRJNA1174234_P_NODE_9037_length_459_cov_1.378238_g8841_i0 | PRJNA1174234 | 9037 | 459 | 1.378238 | 6.32611242 | Tupanvirus deep ocean | 2126984 | Viruses | Viruses | 166 | 2.4899999999999997e-48 | NR | YP_010780318.1 | 2126984 | g8841 | i0 | 58.7 | 1.81699346405229 | 138 | 50 | 85.6 | 2 | 61 | 453 | 69 | 206 | YP_010780318.1 hypothetical protein QJ856_gp1047 [Tupanvirus deep ocean] | diamond | 834 | 166 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Tupanvirus | Tupanvirus altamarinense |
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);;