contig_metadata
20 rows where bioproject = "PRJNA914897" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4723601 | 4723601 | PRJNA914897_P_NODE_8804_length_646_cov_3.312391_g8394_i0 | PRJNA914897 | 8804 | 646 | 3.312391 | 21.39804586 | Megaviridae environmental sample | 1737588 | Viruses | Viruses | 60.2 | 3.84e-4 | NTclustered | gi|1758106775|gb|MN448285.1| | 1737588 | g8394 | i0 | 88 | 0.0773993808049536 | 50 | 6 | 8 | 0 | 88 | 137 | 37557 | 37508 | MAG: Megaviridae environmental sample isolate mPacV-611 clone mPacV-611_c2 | blastn | 50 | 60.2 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Megaviridae environmental sample | |||
| 20021429 | 20021429 | PRJNA914897_P_NODE_12956_length_506_cov_1.193995_g12534_i0 | PRJNA914897 | 12956 | 506 | 1.193995 | 6.0416147 | Raphidovirus japonicum | 3432138 | Viruses | Viruses | 58.4 | 0.001 | NTclustered | gi|1464309061|ref|NC_038553.1| | 97195 | g12534 | i0 | 97.143 | 0.187747035573123 | 35 | 0 | 7 | 1 | 449 | 483 | 266521 | 266488 | Heterosigma akashiwo virus 01 isolate HaV53, complete genome | blastn | 95 | 58.4 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Algavirales | Phycodnaviridae | Raphidovirus | Raphidovirus japonicum | ||
| 21296781 | 21296781 | PRJNA914897_P_NODE_18317_length_402_cov_2.015198_g17895_i0 | PRJNA914897 | 18317 | 402 | 2.015198 | 8.10109596 | Marseillevirus LCMAC102 | 2506603 | Viruses | Viruses | 54.7 | 0.011 | NTclustered | gi|1588059560|gb|MK500334.1| | 2506603 | g17895 | i0 | 100 | 0.0721393034825871 | 29 | 0 | 7 | 0 | 147 | 175 | 151460 | 151432 | MAG: Marseillevirus LCMAC102, sequence | blastn | 29 | 54.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Marseilleviridae | Marseillevirus LCMAC102 | |||
| 27309199 | 27309199 | PRJNA914897_P_NODE_303_length_2459_cov_31.350796_g256_i0 | PRJNA914897 | 303 | 2459 | 31.350796 | 770.91607364 | Gaeavirus sp. | 2487767 | Viruses | Viruses | 367 | 7.88e-111 | NR | AYV80167.1 | 2487767 | g256 | i0 | 36.6 | 0.819845465636438 | 672 | 379 | 80.3 | 18 | 2127 | 154 | 103 | 741 | AYV80167.1 MAG: hypothetical protein Gaeavirus13_9 [Gaeavirus sp.] | diamond | 2016 | 367 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Gaeavirus sp. | |||
| 27403953 | 27403953 | PRJNA914897_P_NODE_5123_length_883_cov_2.016049_g4778_i0 | PRJNA914897 | 5123 | 883 | 2.016049 | 17.80171267 | Fadolivirus algeromassiliense | 3060017 | Viruses | Viruses | 72.8 | 1.27e-10 | NR | YP_010803598.1 | 3060017 | g4778 | i0 | 62.5 | 0.163080407701019 | 48 | 18 | 16.3 | 0 | 772 | 629 | 238 | 285 | YP_010803598.1 histone deacetylase [Fadolivirus algeromassiliense] | diamond | 144 | 72.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Fadolivirus | Fadolivirus algeromassiliense | ||
| 28035383 | 28035383 | PRJNA914897_P_NODE_13525_length_492_cov_1.668258_g13103_i0 | PRJNA914897 | 13525 | 492 | 1.668258 | 8.20782936 | Yasminevirus sp. GU-2 | 3060817 | Viruses | Viruses | 62 | 3.43e-8 | NR | VBB18244.1 | 2420051 | g13103 | i0 | 35.5 | 0.670731707317073 | 110 | 58 | 63.4 | 4 | 367 | 56 | 14 | 116 | VBB18244.1 Rab family, other [Yasminevirus sp. GU-2018] | diamond | 330 | 62 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Yasminevirus | Yasminevirus saudimassiliense | ||
| 28224515 | 28224515 | PRJNA914897_P_NODE_1666_length_1421_cov_12.158754_g1506_i0 | PRJNA914897 | 1666 | 1421 | 12.158754 | 172.77589434 | Fadolivirus algeromassiliense | 3060017 | Viruses | Viruses | 407 | 1.15e-135 | NR | YP_010803269.1 | 3060017 | g1506 | i0 | 48.4 | 0.85503166783955 | 405 | 207 | 85.5 | 2 | 1384 | 170 | 11 | 413 | YP_010803269.1 ornithine decaroboxylase [Fadolivirus algeromassiliense] | diamond | 1215 | 407 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Fadolivirus | Fadolivirus algeromassiliense | ||
| 28350944 | 28350944 | PRJNA914897_P_NODE_1546_length_1456_cov_6.577007_g1395_i0 | PRJNA914897 | 1546 | 1456 | 6.577007 | 95.76122192 | Chlorella virus XW | 10507 | Viruses | Viruses | 177 | 6.67e-46 | NR | ULY68464.1 | 2922419 | g1395 | i0 | 60.3 | 0.521291208791209 | 126 | 46 | 26 | 1 | 424 | 47 | 350 | 471 | ULY68464.1 deoxyribodipyrimidine photo-lyase [Chlorella virus XW01] | diamond | 759 | 177 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Chlorella virus XW01 | |||
| 28414281 | 28414281 | PRJNA914897_P_NODE_1146_length_1598_cov_3.742295_g1018_i0 | PRJNA914897 | 1146 | 1598 | 3.742295 | 59.8018741 | Chlorella virus XW | 10507 | Viruses | Viruses | 131 | 4.85e-29 | NR | ULY68464.1 | 2922419 | g1018 | i0 | 27 | 0.807259073842303 | 430 | 294 | 77.2 | 7 | 13 | 1245 | 1 | 429 | ULY68464.1 deoxyribodipyrimidine photo-lyase [Chlorella virus XW01] | diamond | 1290 | 131 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Chlorella virus XW01 | |||
| 28982726 | 28982726 | PRJNA914897_P_NODE_1708_length_1412_cov_4.850635_g1546_i0 | PRJNA914897 | 1708 | 1412 | 4.850635 | 68.4909662 | Fadolivirus algeromassiliense | 3060017 | Viruses | Viruses | 561 | 1.6299999999999995e-196 | NR | YP_010803269.1 | 3060017 | g1546 | i0 | 64.5 | 0.86685552407932 | 408 | 144 | 86.7 | 1 | 35 | 1258 | 8 | 414 | YP_010803269.1 ornithine decaroboxylase [Fadolivirus algeromassiliense] | diamond | 1224 | 561 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Fadolivirus | Fadolivirus algeromassiliense | ||
| 29676783 | 29676783 | PRJNA914897_P_NODE_35710_length_255_cov_1.324176_g35286_i0 | PRJNA914897 | 35710 | 255 | 1.324176 | 3.3766488 | Fadolivirus algeromassiliense | 3060017 | Viruses | Viruses | 53.5 | 5.53e-6 | NR | YP_010804027.1 | 3060017 | g35286 | i0 | 40 | 1.18823529411765 | 60 | 33 | 70.6 | 1 | 1 | 180 | 139 | 195 | YP_010804027.1 hypothetical protein QKU48_gp1144 [Fadolivirus algeromassiliense] | diamond | 303 | 53.5 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Fadolivirus | Fadolivirus algeromassiliense | ||
| 30087663 | 30087663 | PRJNA914897_P_NODE_24772_length_329_cov_1.203125_g24348_i0 | PRJNA914897 | 24772 | 329 | 1.203125 | 3.95828125 | Fadolivirus algeromassiliense | 3060017 | Viruses | Viruses | 163 | 3.14e-46 | NR | YP_010803269.1 | 3060017 | g24348 | i0 | 67.9 | 0.993920972644377 | 109 | 35 | 99.4 | 0 | 2 | 328 | 279 | 387 | YP_010803269.1 ornithine decaroboxylase [Fadolivirus algeromassiliense] | diamond | 327 | 163 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Fadolivirus | Fadolivirus algeromassiliense | ||
| 30435556 | 30435556 | PRJNA914897_P_NODE_16013_length_439_cov_1.773224_g15591_i0 | PRJNA914897 | 16013 | 439 | 1.773224 | 7.78445336 | Micromonas commoda virus | 3057169 | Viruses | Viruses | 53.5 | 3.42e-5 | NR | XCA47318.1 | 3057169 | g15591 | i0 | 34.7 | 0.5125284738041 | 75 | 48 | 51.3 | 1 | 212 | 436 | 1 | 74 | XCA47318.1 hypothetical protein [Micromonas commoda virus] | diamond | 225 | 53.5 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Algavirales | Phycodnaviridae | Micromonas commoda virus | |||
| 30846080 | 30846080 | PRJNA914897_P_NODE_41114_length_243_cov_1.705882_g40690_i0 | PRJNA914897 | 41114 | 243 | 1.705882 | 4.14529326 | Hokovirus HKV1 | 1977638 | Viruses | Viruses | 47.8 | 6.39e-4 | NR | ARF10265.1 | 1977638 | g40690 | i0 | 47.4 | 1.33333333333333 | 57 | 29 | 70.4 | 1 | 197 | 27 | 457 | 512 | ARF10265.1 hypothetical protein Hokovirus_1_144 [Hokovirus HKV1] | diamond | 324 | 47.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Hokovirus | Hokovirus HKV1 | ||
| 30941010 | 30941010 | PRJNA914897_P_NODE_334_length_2388_cov_6.641037_g283_i0 | PRJNA914897 | 334 | 2388 | 6.641037 | 158.58796356 | Gaeavirus sp. | 2487767 | Viruses | Viruses | 403 | 6.759999999999999e-125 | NR | AYV80167.1 | 2487767 | g283 | i0 | 35 | 0.972361809045226 | 774 | 448 | 94.8 | 16 | 21 | 2285 | 3 | 740 | AYV80167.1 MAG: hypothetical protein Gaeavirus13_9 [Gaeavirus sp.] | diamond | 2322 | 403 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Gaeavirus sp. | |||
| 31573329 | 31573329 | PRJNA914897_P_NODE_21096_length_366_cov_1.000000_g20673_i0 | PRJNA914897 | 21096 | 366 | 1 | 3.66 | Orthopoxvirus akhmetapox | 2200830 | Viruses | Viruses | 45.8 | 0.0122 | NR | QEQ49358.1 | 2200830 | g20673 | i0 | 53.5 | 1.55737704918033 | 43 | 20 | 35.2 | 0 | 228 | 100 | 456 | 498 | QEQ49358.1 Ankyrin [Orthopoxvirus akhmetapox] | diamond | 570 | 45.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Orthopoxvirus | Orthopoxvirus akhmetapox | ||
| 31573353 | 31573353 | PRJNA914897_P_NODE_496_length_2100_cov_3.599408_g421_i0 | PRJNA914897 | 496 | 2100 | 3.599408 | 75.587568 | Fadolivirus algeromassiliense | 3060017 | Viruses | Viruses | 89.7 | 2.75e-14 | NR | YP_010803040.1 | 3060017 | g421 | i0 | 20.8 | 0.57 | 399 | 308 | 56 | 4 | 2084 | 909 | 421 | 818 | YP_010803040.1 helicase [Fadolivirus algeromassiliense] | diamond | 1197 | 89.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Fadolivirus | Fadolivirus algeromassiliense | ||
| 32237807 | 32237807 | PRJNA914897_P_NODE_2198_length_1292_cov_7.044299_g1997_i0 | PRJNA914897 | 2198 | 1292 | 7.044299 | 91.01234308 | Terrestrivirus sp. | 2487775 | Viruses | Viruses | 50.1 | 0.013 | NR | AYV75160.1 | 2487775 | g1997 | i0 | 69.7 | 0.076625386996904 | 33 | 10 | 7.7 | 0 | 844 | 942 | 196 | 228 | AYV75160.1 MAG: hypothetical protein Terrestrivirus1_34 [Terrestrivirus sp.] | diamond | 99 | 50.1 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Terrestrivirus sp. | |||
| 32364206 | 32364206 | PRJNA914897_P_NODE_25759_length_320_cov_1.809717_g25335_i0 | PRJNA914897 | 25759 | 320 | 1.809717 | 5.7910944 | Terrestrivirus sp. | 2487775 | Viruses | Viruses | 70.5 | 1.69e-11 | NR | AYV76445.1 | 2487775 | g25335 | i0 | 56 | 0.46875 | 50 | 22 | 46.9 | 0 | 45 | 194 | 352 | 401 | AYV76445.1 MAG: GTP cyclohydrolase [Terrestrivirus sp.] | diamond | 150 | 70.5 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Terrestrivirus sp. | |||
| 32774241 | 32774241 | PRJNA914897_P_NODE_30760_length_284_cov_1.426540_g30336_i0 | PRJNA914897 | 30760 | 284 | 1.42654 | 4.0513736 | Bodo saltans virus | 2024608 | Viruses | Viruses | 104 | 6.45e-27 | NR | YP_010778194.1 | 2024608 | g30336 | i0 | 60 | 0.897887323943662 | 85 | 33 | 88.7 | 1 | 31 | 282 | 1 | 85 | YP_010778194.1 hypothetical protein QJ851_gp0355 [Bodo saltans virus] | diamond | 255 | 104 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Theiavirus | Theiavirus salishense |
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);;