contig_metadata
19 rows where bioproject = "PRJNA849822" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5061604 | 5061604 | PRJNA849822_P_NODE_5624_length_660_cov_1.952300_g5455_i0 | PRJNA849822 | 5624 | 660 | 1.9523 | 12.88518 | Fadolivirus algeromassiliense | 3060017 | Viruses | Viruses | 157 | 3.55e-42 | NR | YP_010802902.1 | 3060017 | g5455 | i0 | 47.2 | 0.818181818181818 | 180 | 85 | 78.2 | 4 | 546 | 31 | 152 | 329 | YP_010802902.1 protein-tyrosine phosphatase [Fadolivirus algeromassiliense] | diamond | 540 | 157 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Fadolivirus | Fadolivirus algeromassiliense | ||
| 7216747 | 7216747 | PRJNA849822_P_NODE_2826_length_973_cov_2.620000_g2687_i0 | PRJNA849822 | 2826 | 973 | 2.62 | 25.4926 | Orpheovirus IHUMI-LCC2 | 2023057 | Viruses | Viruses | 469 | 5.449999999999998e-164 | NR | YP_009449055.1 | 2023057 | g2687 | i0 | 73.7 | 0.92497430626927 | 300 | 79 | 92.5 | 0 | 72 | 971 | 2 | 301 | YP_009449055.1 ribonucleotide reductase large subunit [Orpheovirus IHUMI-LCC2] | diamond | 900 | 469 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Orpheoviridae | Alphaorpheovirus | Alphaorpheovirus massiliense | ||
| 18689922 | 18689922 | PRJNA849822_P_NODE_2515_length_1039_cov_1.286749_g2386_i0 | PRJNA849822 | 2515 | 1039 | 1.286749 | 13.36932211 | Orpheovirus IHUMI-LCC2 | 2023057 | Viruses | Viruses | 85.1 | 6.57e-14 | NR | YP_009449258.1 | 2023057 | g2386 | i0 | 30.9 | 1.90856592877767 | 333 | 193 | 93 | 13 | 11 | 976 | 882 | 1188 | YP_009449258.1 Domain of unknown function (DUF4114) [Orpheovirus IHUMI-LCC2] | diamond | 1983 | 85.1 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Orpheoviridae | Alphaorpheovirus | Alphaorpheovirus massiliense | ||
| 26737977 | 26737977 | PRJNA849822_P_NODE_28561_length_273_cov_1.560000_g28387_i0 | PRJNA849822 | 28561 | 273 | 1.56 | 4.2588 | Orpheovirus IHUMI-LCC2 | 2023057 | Viruses | Viruses | 52 | 3e-5 | NR | YP_009449258.1 | 2023057 | g28387 | i0 | 44.1 | 0.747252747252747 | 68 | 37 | 73.6 | 1 | 238 | 38 | 936 | 1003 | YP_009449258.1 Domain of unknown function (DUF4114) [Orpheovirus IHUMI-LCC2] | diamond | 204 | 52 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Orpheoviridae | Alphaorpheovirus | Alphaorpheovirus massiliense | ||
| 27094806 | 27094806 | PRJNA849822_P_NODE_1162_length_1488_cov_1.171025_g1077_i0 | PRJNA849822 | 1162 | 1488 | 1.171025 | 17.424852 | Fadolivirus | 2763561 | Viruses | Viruses | 107 | 1.67e-20 | NR | AYV75638.1 | 2487775 | g1077 | i0 | 40.3 | 0.633064516129032 | 159 | 91 | 31.3 | 1 | 1023 | 1487 | 1125 | 1283 | AYV75638.1 MAG: DEAD/SNF2-like helicase [Terrestrivirus sp.] | diamond | 942 | 107 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Terrestrivirus sp. | |||
| 27244581 | 27244581 | PRJNA849822_P_NODE_41623_length_244_cov_0.912281_g41449_i0 | PRJNA849822 | 41623 | 244 | 0.912281 | 2.22596564 | Orpheovirus IHUMI-LCC2 | 2023057 | Viruses | Viruses | 74.7 | 1.92e-13 | NR | YP_009448636.1 | 2023057 | g41449 | i0 | 43.6 | 0.959016393442623 | 78 | 43 | 95.9 | 1 | 3 | 236 | 84 | 160 | YP_009448636.1 Cytochrome P450-like protein E-class [Orpheovirus IHUMI-LCC2] | diamond | 234 | 74.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Orpheoviridae | Alphaorpheovirus | Alphaorpheovirus massiliense | ||
| 27308006 | 27308006 | PRJNA849822_P_NODE_6023_length_635_cov_2.781139_g5854_i0 | PRJNA849822 | 6023 | 635 | 2.781139 | 17.66023265 | Orpheovirus IHUMI-LCC2 | 2023057 | Viruses | Viruses | 222 | 1.05e-65 | NR | YP_009448802.1 | 2023057 | g5854 | i0 | 52.9 | 0.973228346456693 | 206 | 87 | 97.3 | 1 | 634 | 17 | 242 | 437 | YP_009448802.1 Tri-functionnal domain DHFR/deoxycytidylate deaminase/Riboflavin biosynthesis protein RibD [Orpheovirus IHUMI-LCC2] | diamond | 618 | 222 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Orpheoviridae | Alphaorpheovirus | Alphaorpheovirus massiliense | ||
| 28294870 | 28294870 | PRJNA849822_P_NODE_18026_length_341_cov_1.455224_g17852_i0 | PRJNA849822 | 18026 | 341 | 1.455224 | 4.96231384 | Orthopoxvirus | 10242 | Viruses | Viruses | 222 | 1.8200000000000002e-71 | NR | ATB55171.1 | 10243 | g17852 | i0 | 100 | 18.8885630498534 | 113 | 0 | 99.4 | 0 | 1 | 339 | 22 | 134 | ATB55171.1 CPXV129 protein [Cowpox virus] | diamond | 6441 | 222 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Orthopoxvirus | Orthopoxvirus cowpox | ||
| 28476119 | 28476119 | PRJNA849822_P_NODE_17526_length_346_cov_2.000000_g17352_i0 | PRJNA849822 | 17526 | 346 | 2 | 6.92 | Terrestrivirus sp. | 2487775 | Viruses | Viruses | 86.3 | 7.05e-17 | NR | AYV75638.1 | 2487775 | g17352 | i0 | 73.9 | 1.07514450867052 | 46 | 12 | 39.9 | 0 | 85 | 222 | 168 | 213 | AYV75638.1 MAG: DEAD/SNF2-like helicase [Terrestrivirus sp.] | diamond | 372 | 86.3 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Terrestrivirus sp. | |||
| 28570735 | 28570735 | PRJNA849822_P_NODE_20547_length_319_cov_2.207317_g20373_i0 | PRJNA849822 | 20547 | 319 | 2.207317 | 7.04134123 | Terrestrivirus sp. | 2487775 | Viruses | Viruses | 68.2 | 1.09e-10 | NR | AYV76394.1 | 2487775 | g20373 | i0 | 62.5 | 0.45141065830721 | 48 | 18 | 45.1 | 0 | 186 | 43 | 37 | 84 | AYV76394.1 MAG: putative helicase/exonuclease [Terrestrivirus sp.] | diamond | 144 | 68.2 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Terrestrivirus sp. | |||
| 28728717 | 28728717 | PRJNA849822_P_NODE_1747_length_1230_cov_2.061366_g1641_i0 | PRJNA849822 | 1747 | 1230 | 2.061366 | 25.3548018 | Marseillevirus LCMAC1 | 2506602 | Viruses | Viruses | 59.3 | 7.59e-7 | NR | QBK85646.1 | 2506602 | g1641 | i0 | 38.4 | 0.178048780487805 | 73 | 45 | 17.8 | 0 | 823 | 1041 | 36 | 108 | QBK85646.1 MAG: hypothetical protein LCMAC101_02410 [Marseillevirus LCMAC101] | diamond | 219 | 59.3 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Marseilleviridae | Marseillevirus LCMAC101 | |||
| 29013182 | 29013182 | PRJNA849822_P_NODE_22748_length_304_cov_1.012987_g22574_i0 | PRJNA849822 | 22748 | 304 | 1.012987 | 3.07948048 | Orpheovirus IHUMI-LCC2 | 2023057 | Viruses | Viruses | 48.1 | 0.00101 | NR | YP_009449258.1 | 2023057 | g22574 | i0 | 37.6 | 0.917763157894737 | 93 | 49 | 90.8 | 3 | 29 | 304 | 945 | 1029 | YP_009449258.1 Domain of unknown function (DUF4114) [Orpheovirus IHUMI-LCC2] | diamond | 279 | 48.1 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Orpheoviridae | Alphaorpheovirus | Alphaorpheovirus massiliense | ||
| 29044645 | 29044645 | PRJNA849822_P_NODE_4448_length_755_cov_2.331378_g4284_i0 | PRJNA849822 | 4448 | 755 | 2.331378 | 17.6019039 | Orpheovirus IHUMI-LCC2 | 2023057 | Viruses | Viruses | 204 | 9.75e-62 | NR | YP_009449316.1 | 2023057 | g4284 | i0 | 45 | 0.874172185430464 | 220 | 111 | 87.4 | 2 | 89 | 748 | 12 | 221 | YP_009449316.1 Fatty acid hydroxylase (C-5 sterol desaturase putative) [Orpheovirus IHUMI-LCC2] | diamond | 660 | 204 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Orpheoviridae | Alphaorpheovirus | Alphaorpheovirus massiliense | ||
| 29139494 | 29139494 | PRJNA849822_P_NODE_8129_length_533_cov_1.513043_g7957_i0 | PRJNA849822 | 8129 | 533 | 1.513043 | 8.06451919 | Orpheovirus IHUMI-LCC2 | 2023057 | Viruses | Viruses | 169 | 3.21e-46 | NR | YP_009448802.1 | 2023057 | g7957 | i0 | 52.6 | 0.962476547842402 | 171 | 70 | 96.2 | 4 | 21 | 533 | 1 | 160 | YP_009448802.1 Tri-functionnal domain DHFR/deoxycytidylate deaminase/Riboflavin biosynthesis protein RibD [Orpheovirus IHUMI-LCC2] | diamond | 513 | 169 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Orpheoviridae | Alphaorpheovirus | Alphaorpheovirus massiliense | ||
| 29233984 | 29233984 | PRJNA849822_P_NODE_30689_length_264_cov_1.272251_g30515_i0 | PRJNA849822 | 30689 | 264 | 1.272251 | 3.35874264 | Marseillevirus LCMAC1 | 2506602 | Viruses | Viruses | 48.9 | 2.06e-4 | NR | QBK85549.1 | 2506602 | g30515 | i0 | 35.6 | 0.829545454545455 | 73 | 41 | 83 | 2 | 43 | 261 | 107 | 173 | QBK85549.1 MAG: U-box domain protein [Marseillevirus LCMAC101] | diamond | 219 | 48.9 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Marseilleviridae | Marseillevirus LCMAC101 | |||
| 29297074 | 29297074 | PRJNA849822_P_NODE_33769_length_253_cov_0.866667_g33595_i0 | PRJNA849822 | 33769 | 253 | 0.866667 | 2.19266751 | Hyperionvirus sp. | 2487770 | Viruses | Viruses | 45.8 | 0.00329 | NR | AYV82696.1 | 2487770 | g33595 | i0 | 53.8 | 2.37154150197628 | 39 | 18 | 46.2 | 0 | 47 | 163 | 27 | 65 | AYV82696.1 MAG: chromosome condensation regulator [Hyperionvirus sp.] | diamond | 600 | 45.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Hyperionvirus sp. | |||
| 31066197 | 31066197 | PRJNA849822_P_NODE_1095_length_1521_cov_2.457182_g1012_i0 | PRJNA849822 | 1095 | 1521 | 2.457182 | 37.37373822 | Orpheovirus IHUMI-LCC2 | 2023057 | Viruses | Viruses | 551 | 2.43e-190 | NR | YP_009448979.1 | 2023057 | g1012 | i0 | 58.2 | 0.911242603550296 | 462 | 183 | 89.9 | 3 | 1518 | 151 | 43 | 500 | YP_009448979.1 Cytochrome P450-like protein E-class [Orpheovirus IHUMI-LCC2] | diamond | 1386 | 551 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Orpheoviridae | Alphaorpheovirus | Alphaorpheovirus massiliense | ||
| 31824774 | 31824774 | PRJNA849822_P_NODE_21717_length_311_cov_1.289916_g21543_i0 | PRJNA849822 | 21717 | 311 | 1.289916 | 4.01163876 | Moumouvirus Monve | 1128131 | Viruses | Viruses | 45.1 | 0.012 | NR | AEX62761.1 | 1128131 | g21543 | i0 | 35.7 | 0.540192926045016 | 56 | 35 | 54 | 1 | 6 | 173 | 299 | 353 | AEX62761.1 putative mRNA enzyme [Moumouvirus Monve] | diamond | 168 | 45.1 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Moumouvirus | Moumouvirus sp. 'Monve' | ||
| 32268078 | 32268078 | PRJNA849822_P_NODE_28438_length_274_cov_1.164179_g28264_i0 | PRJNA849822 | 28438 | 274 | 1.164179 | 3.18985046 | Terrestrivirus sp. | 2487775 | Viruses | Viruses | 52.4 | 2.08e-5 | NR | AYV76215.1 | 2487775 | g28264 | i0 | 34.5 | 0.91970802919708 | 84 | 48 | 90.9 | 3 | 265 | 17 | 10 | 87 | AYV76215.1 MAG: hypothetical protein Terrestrivirus5_37 [Terrestrivirus sp.] | diamond | 252 | 52.4 | 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);;