contig_metadata
18 rows where bioproject = "PRJNA700095" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5786719 | 5786719 | PRJNA700095_P_NODE_39485_length_277_cov_1.509804_g38221_i0 | PRJNA700095 | 39485 | 277 | 1.509804 | 4.18215708 | Betaentomopoxvirus amoorei | 28321 | Viruses | Viruses | 52.8 | 0.025 | NTclustered | gi|9964314|ref|NC_002520.1| | 28321 | g38221 | i0 | 94.286 | 0.126353790613718 | 35 | 1 | 12 | 1 | 204 | 237 | 153509 | 153475 | Amsacta moorei entomopoxvirus 'L', complete genome | blastn | 35 | 52.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Betaentomopoxvirus | Betaentomopoxvirus amoorei | ||
| 26829691 | 26829691 | PRJNA700095_P_NODE_23201_length_360_cov_1.337979_g21937_i0 | PRJNA700095 | 23201 | 360 | 1.337979 | 4.8167244 | Tupanvirus deep ocean | 2126984 | Viruses | Viruses | 103 | 1.1699999999999997e-23 | NR | YP_010781083.1 | 2126984 | g21937 | i0 | 45.4 | 2 | 119 | 61 | 97.5 | 3 | 2 | 352 | 168 | 284 | YP_010781083.1 hypothetical protein QJ856_gp0282 [Tupanvirus deep ocean] | diamond | 720 | 103 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Tupanvirus | Tupanvirus altamarinense | ||
| 26956045 | 26956045 | PRJNA700095_P_NODE_33682_length_294_cov_1.502262_g32418_i0 | PRJNA700095 | 33682 | 294 | 1.502262 | 4.41665028 | Tupanvirus soda lake | 2126985 | Viruses | Viruses | 67 | 1.92e-10 | NR | YP_010782467.1 | 2126985 | g32418 | i0 | 38.2 | 1.04081632653061 | 102 | 54 | 98 | 4 | 6 | 293 | 8 | 106 | YP_010782467.1 hypothetical protein QJ857_gp0240 [Tupanvirus soda lake] | diamond | 306 | 67 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Tupanvirus | Tupanvirus salinum | ||
| 27114150 | 27114150 | PRJNA700095_P_NODE_17562_length_430_cov_1.224090_g16299_i0 | PRJNA700095 | 17562 | 430 | 1.22409 | 5.263587 | Terrestrivirus sp. | 2487775 | Viruses | Viruses | 94 | 4.1e-20 | NR | AYV75674.1 | 2487775 | g16299 | i0 | 40.3 | 0.830232558139535 | 119 | 65 | 79.5 | 3 | 81 | 422 | 1 | 118 | AYV75674.1 MAG: hypothetical protein Terrestrivirus2_182 [Terrestrivirus sp.] | diamond | 357 | 94 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Terrestrivirus sp. | |||
| 27504924 | 27504924 | PRJNA700095_P_NODE_16883_length_441_cov_1.842391_g15620_i0 | PRJNA700095 | 16883 | 441 | 1.842391 | 8.12494431 | Tupanvirus | 2094720 | Viruses | Viruses | 97.1 | 1.95e-21 | NR | YP_010781216.1 | 2126984 | g15620 | i0 | 46.8 | 3.27210884353741 | 111 | 55 | 74.8 | 3 | 339 | 10 | 48 | 155 | YP_010781216.1 hypothetical protein QJ856_gp0149 [Tupanvirus deep ocean] | diamond | 1443 | 97.8 | 0.992842535787321 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Tupanvirus | Tupanvirus altamarinense | ||
| 27809478 | 27809478 | PRJNA700095_P_NODE_28464_length_319_cov_1.825203_g27200_i0 | PRJNA700095 | 28464 | 319 | 1.825203 | 5.82239757 | Tupanvirus deep ocean | 2126984 | Viruses | Viruses | 64.3 | 1.82e-9 | NR | YP_010781083.1 | 2126984 | g27200 | i0 | 40.8 | 0.921630094043887 | 98 | 41 | 92.2 | 3 | 24 | 317 | 53 | 133 | YP_010781083.1 hypothetical protein QJ856_gp0282 [Tupanvirus deep ocean] | diamond | 294 | 64.3 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Tupanvirus | Tupanvirus altamarinense | ||
| 27935650 | 27935650 | PRJNA700095_P_NODE_8085_length_697_cov_2.017628_g6920_i0 | PRJNA700095 | 8085 | 697 | 2.017628 | 14.06286716 | Tupanvirus soda lake | 2126985 | Viruses | Viruses | 202 | 1.67e-58 | NR | YP_010782467.1 | 2126985 | g6920 | i0 | 47.6 | 1.98852223816356 | 231 | 113 | 98.6 | 4 | 688 | 2 | 252 | 476 | YP_010782467.1 hypothetical protein QJ857_gp0240 [Tupanvirus soda lake] | diamond | 1386 | 202 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Tupanvirus | Tupanvirus salinum | ||
| 28736140 | 28736140 | PRJNA700095_P_NODE_18967_length_409_cov_1.211310_g17704_i0 | PRJNA700095 | 18967 | 409 | 1.21131 | 4.9542579 | Tupanvirus | 2094720 | Viruses | Viruses | 85.1 | 1.31e-16 | NR | YP_010781083.1 | 2126984 | g17704 | i0 | 52.3 | 1.26161369193154 | 86 | 21 | 63.1 | 1 | 408 | 151 | 258 | 323 | YP_010781083.1 hypothetical protein QJ856_gp0282 [Tupanvirus deep ocean] | diamond | 516 | 85.1 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Tupanvirus | Tupanvirus altamarinense | ||
| 28819305 | 28819305 | PRJNA700095_P_NODE_16788_length_443_cov_1.100000_g15525_i0 | PRJNA700095 | 16788 | 443 | 1.1 | 4.873 | Tupanvirus deep ocean | 2126984 | Viruses | Viruses | 122 | 2.08e-30 | NR | YP_010781083.1 | 2126984 | g15525 | i0 | 49.2 | 1.65914221218962 | 122 | 59 | 81.3 | 2 | 360 | 1 | 124 | 244 | YP_010781083.1 hypothetical protein QJ856_gp0282 [Tupanvirus deep ocean] | diamond | 735 | 122 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Tupanvirus | Tupanvirus altamarinense | ||
| 29482461 | 29482461 | PRJNA700095_P_NODE_29310_length_314_cov_1.489627_g28046_i0 | PRJNA700095 | 29310 | 314 | 1.489627 | 4.67742878 | Terrestrivirus sp. | 2487775 | Viruses | Viruses | 64.7 | 1.35e-9 | NR | AYV75160.1 | 2487775 | g28046 | i0 | 37.8 | 0.78343949044586 | 82 | 44 | 74.5 | 2 | 303 | 70 | 98 | 176 | AYV75160.1 MAG: hypothetical protein Terrestrivirus1_34 [Terrestrivirus sp.] | diamond | 246 | 64.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Terrestrivirus sp. | |||
| 29872843 | 29872843 | PRJNA700095_P_NODE_1991_length_1329_cov_3.122611_g1429_i0 | PRJNA700095 | 1991 | 1329 | 3.122611 | 41.49950019 | Moumouvirus | 3080801 | Viruses | Viruses | 166 | 6.12e-45 | NR | YP_010779159.1 | 1247379 | g1429 | i0 | 42.1 | 1.79006772009029 | 202 | 105 | 44.5 | 5 | 629 | 39 | 11 | 205 | YP_010779159.1 hypothetical protein QJ854_gp858 [Moumouvirus goulette] | diamond | 2379 | 167 | 0.994011976047904 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Moumouvirus | Moumouvirus goulettemassiliense | ||
| 30367519 | 30367519 | PRJNA700095_P_NODE_10292_length_606_cov_1.675422_g9056_i0 | PRJNA700095 | 10292 | 606 | 1.675422 | 10.15305732 | Faunusvirus sp. | 2487766 | Viruses | Viruses | 74.3 | 1e-11 | NR | AYV79622.1 | 2487766 | g9056 | i0 | 30.9 | 1.5 | 152 | 86 | 75.2 | 3 | 27 | 482 | 247 | 379 | AYV79622.1 MAG: serpin [Faunusvirus sp.] | diamond | 909 | 74.3 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Faunusvirus sp. | |||
| 30556483 | 30556483 | PRJNA700095_P_NODE_39933_length_276_cov_1.492611_g38669_i0 | PRJNA700095 | 39933 | 276 | 1.492611 | 4.11960636 | Tupanvirus soda lake | 2126985 | Viruses | Viruses | 51.6 | 4.04e-5 | NR | YP_010782467.1 | 2126985 | g38669 | i0 | 52.1 | 0.521739130434783 | 48 | 23 | 52.2 | 0 | 194 | 51 | 1 | 48 | YP_010782467.1 hypothetical protein QJ857_gp0240 [Tupanvirus soda lake] | diamond | 144 | 51.6 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Tupanvirus | Tupanvirus salinum | ||
| 30841085 | 30841085 | PRJNA700095_P_NODE_19054_length_407_cov_5.856287_g17791_i0 | PRJNA700095 | 19054 | 407 | 5.856287 | 23.83508809 | Tupanvirus soda lake | 2126985 | Viruses | Viruses | 68.2 | 2.76e-10 | NR | YP_010782467.1 | 2126985 | g17791 | i0 | 38.7 | 0.818181818181818 | 111 | 59 | 77.4 | 4 | 16 | 330 | 1 | 108 | YP_010782467.1 hypothetical protein QJ857_gp0240 [Tupanvirus soda lake] | diamond | 333 | 68.2 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Tupanvirus | Tupanvirus salinum | ||
| 31136261 | 31136261 | PRJNA700095_P_NODE_35995_length_286_cov_2.000000_g34731_i0 | PRJNA700095 | 35995 | 286 | 2 | 5.72 | Viruses | 10239 | Viruses | Viruses | 54.3 | 1.75e-6 | NR | AYV80841.1 | 2487768 | g34731 | i0 | 28.6 | 1.76223776223776 | 84 | 59 | 88.1 | 1 | 284 | 33 | 91 | 173 | AYV80841.1 MAG: hypothetical protein Harvfovirus8_2 [Harvfovirus sp.] | diamond | 504 | 54.3 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Harvfovirus sp. | |||
| 31251778 | 31251778 | PRJNA700095_P_NODE_8395_length_682_cov_2.356322_g7221_i0 | PRJNA700095 | 8395 | 682 | 2.356322 | 16.07011604 | Tupanvirus soda lake | 2126985 | Viruses | Viruses | 123 | 1.1199999999999999e-28 | NR | YP_010782467.1 | 2126985 | g7221 | i0 | 36.4 | 0.906158357771261 | 206 | 114 | 87.1 | 8 | 87 | 680 | 1 | 197 | YP_010782467.1 hypothetical protein QJ857_gp0240 [Tupanvirus soda lake] | diamond | 618 | 123 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Tupanvirus | Tupanvirus salinum | ||
| 32042658 | 32042658 | PRJNA700095_P_NODE_41478_length_272_cov_1.537688_g40214_i0 | PRJNA700095 | 41478 | 272 | 1.537688 | 4.18251136 | Tupanvirus soda lake | 2126985 | Viruses | Viruses | 56.2 | 9.2e-7 | NR | YP_010782467.1 | 2126985 | g40214 | i0 | 40.2 | 1.06985294117647 | 97 | 45 | 96 | 6 | 270 | 10 | 15 | 108 | YP_010782467.1 hypothetical protein QJ857_gp0240 [Tupanvirus soda lake] | diamond | 291 | 56.2 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Tupanvirus | Tupanvirus salinum | ||
| 32422339 | 32422339 | PRJNA700095_P_NODE_28459_length_319_cov_1.959350_g27195_i0 | PRJNA700095 | 28459 | 319 | 1.95935 | 6.2503265 | Terrestrivirus sp. | 2487775 | Viruses | Viruses | 129 | 4.93e-35 | NR | AYV75555.1 | 2487775 | g27195 | i0 | 59.2 | 0.921630094043887 | 98 | 40 | 92.2 | 0 | 23 | 316 | 100 | 197 | AYV75555.1 MAG: putative HD superfamily hydrolase [Terrestrivirus sp.] | diamond | 294 | 129 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Terrestrivirus 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);;