contig_metadata
17 rows where bioproject = "PRJEB20058" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26194434 | 26194434 | PRJEB20058_P_NODE_126030_length_353_cov_2.188356_g123211_i0 | PRJEB20058 | 126030 | 353 | 2.188356 | 7.72489668 | Moumouvirus lavasanguinem | 3138182 | Viruses | Viruses | 65.8 | 4.29e-6 | NTclustered | gi|2733972295|dbj|LC813553.1| | 3138182 | g123211 | i0 | 95.238 | 33.0764872521246 | 42 | 0 | 11 | 2 | 313 | 352 | 141829 | 141870 | Moumouvirus lavasanguinem DNA, nearly complete genome | blastn | 11676 | 65.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Moumouvirus | Moumouvirus sp. 'lavasanguinem' | ||
| 26194607 | 26194607 | PRJEB20058_P_NODE_12974_length_1152_cov_10.741522_g11301_i0 | PRJEB20058 | 12974 | 1152 | 10.741522 | 123.74233344 | Hirudovirus strain Sangsue | 1420594 | Viruses | Viruses | 2049 | 0 | NTclustered | gi|557951111|gb|KF493731.1| | 1420594 | g11301 | i0 | 99.91 | 17.3880208333333 | 1113 | 0 | 97 | 1 | 18 | 1130 | 802263 | 801152 | Hirudovirus strain Sangsue, complete genome | blastn | 20031 | 2049 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Mimivirus | Hirudovirus strain Sangsue | ||
| 26202453 | 26202453 | PRJEB20058_P_NODE_79990_length_463_cov_3.288557_g77208_i0 | PRJEB20058 | 79990 | 463 | 3.288557 | 15.22601891 | Fadolivirus algeromassiliense | 3060017 | Viruses | Viruses | 159 | 3.34e-46 | NR | YP_010803238.1 | 3060017 | g77208 | i0 | 60.7 | 0.971922246220302 | 150 | 50 | 95.9 | 3 | 18 | 461 | 27 | 169 | YP_010803238.1 hypothetical protein QKU48_gp0355 [Fadolivirus algeromassiliense] | diamond | 450 | 159 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Fadolivirus | Fadolivirus algeromassiliense | ||
| 26428895 | 26428895 | PRJEB20058_P_NODE_153071_length_309_cov_5.391129_g150248_i0 | PRJEB20058 | 153071 | 309 | 5.391129 | 16.65858861 | Mimivirus | 315393 | Viruses | Viruses | 488 | 1.86e-133 | NTclustered | gi|2267817464|gb|MW685904.1| | 212035 | g150248 | i0 | 100 | 15.4757281553398 | 264 | 0 | 85 | 0 | 46 | 309 | 706572 | 706835 | Acanthamoeba polyphaga mimivirus isolate M4, complete genome | blastn | 4782 | 488 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Mimivirus | Mimivirus bradfordmassiliense | ||
| 32910758 | 32910758 | PRJEB20058_P_NODE_169121_length_288_cov_11.444934_g166298_i0 | PRJEB20058 | 169121 | 288 | 11.444934 | 32.96140992 | Thermus phage phiKo | 2301535 | Viruses | Viruses | 127 | 1.97e-34 | NR | AYJ74689.1 | 2301535 | g166298 | i0 | 63.2 | 0.989583333333333 | 95 | 33 | 96.9 | 1 | 8 | 286 | 109 | 203 | AYJ74689.1 DNA packaging ATPase [Thermus phage phiKo] | diamond | 285 | 127 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Tectiliviricetes | Kalamavirales | Tectiviridae | Thermus phage phiKo | |||
| 32962077 | 32962077 | PRJEB20058_P_NODE_131866_length_342_cov_27.039146_g129047_i0 | PRJEB20058 | 131866 | 342 | 27.039146 | 92.47387932 | Barrevirus sp. | 2487763 | Viruses | Viruses | 132 | 1.12e-34 | NR | AYV76785.1 | 2487763 | g129047 | i0 | 65.2 | 1.5 | 89 | 31 | 78.1 | 0 | 309 | 43 | 248 | 336 | AYV76785.1 MAG: hypothetical protein Barrevirus1_7 [Barrevirus sp.] | diamond | 513 | 132 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Barrevirus sp. | |||
| 32962464 | 32962464 | PRJEB20058_P_NODE_198578_length_257_cov_3.918367_g195754_i0 | PRJEB20058 | 198578 | 257 | 3.918367 | 10.07020319 | Yasminevirus sp. GU-2 | 3060817 | Viruses | Viruses | 121 | 2e-31 | NR | VBB18361.1 | 2420051 | g195754 | i0 | 72.2 | 0.922178988326848 | 79 | 22 | 92.2 | 0 | 255 | 19 | 177 | 255 | VBB18361.1 hypothetical protein YASMINEVIRUS_824 [Yasminevirus sp. GU-2018] | diamond | 237 | 121 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Yasminevirus | Yasminevirus saudimassiliense | ||
| 32974476 | 32974476 | PRJEB20058_P_NODE_99194_length_409_cov_6.324713_g96387_i0 | PRJEB20058 | 99194 | 409 | 6.324713 | 25.86807617 | Chlorovirus | 181083 | Viruses | Viruses | 62.4 | 2.19e-8 | NR | AGE56286.1 | 1278261 | g96387 | i0 | 36.6 | 1.24694376528117 | 82 | 49 | 57.9 | 1 | 388 | 152 | 205 | 286 | AGE56286.1 hypothetical protein PBCVNEJV1_405R [Paramecium bursaria Chlorella virus NE-JV-1] | diamond | 510 | 62.4 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Algavirales | Phycodnaviridae | Chlorovirus | Paramecium bursaria Chlorella virus NE-JV-1 | ||
| 32979463 | 32979463 | PRJEB20058_P_NODE_181619_length_274_cov_2.422535_g178796_i0 | PRJEB20058 | 181619 | 274 | 2.422535 | 6.6377459 | Thermus phage phiKo | 2301535 | Viruses | Viruses | 50.8 | 2.67e-5 | NR | AYJ74682.1 | 2301535 | g178796 | i0 | 51.7 | 0.635036496350365 | 58 | 24 | 59.1 | 2 | 49 | 210 | 102 | 159 | AYJ74682.1 peptidase [Thermus phage phiKo] | diamond | 174 | 50.8 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Tectiliviricetes | Kalamavirales | Tectiviridae | Thermus phage phiKo | |||
| 32996677 | 32996677 | PRJEB20058_P_NODE_26315_length_814_cov_12.416999_g24019_i0 | PRJEB20058 | 26315 | 814 | 12.416999 | 101.07437186 | Catovirus CTV1 | 1977631 | Viruses | Viruses | 50.4 | 0.0056 | NR | ARF08395.1 | 1977631 | g24019 | i0 | 40.9 | 0.342751842751843 | 93 | 49 | 33.9 | 3 | 784 | 509 | 12 | 99 | ARF08395.1 ankyrin repeat protein [Catovirus CTV1] | diamond | 279 | 50.4 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Catovirus | Catovirus CTV1 | ||
| 32997042 | 32997042 | PRJEB20058_P_NODE_88035_length_438_cov_74.026525_g85241_i0 | PRJEB20058 | 88035 | 438 | 74.026525 | 324.2361795 | Thermus phage phiKo | 2301535 | Viruses | Viruses | 77.4 | 2.4e-14 | NR | AYJ74689.1 | 2301535 | g85241 | i0 | 64.9 | 0.39041095890411 | 57 | 18 | 37.7 | 1 | 323 | 159 | 137 | 193 | AYJ74689.1 DNA packaging ATPase [Thermus phage phiKo] | diamond | 171 | 77.4 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Tectiliviricetes | Kalamavirales | Tectiviridae | Thermus phage phiKo | |||
| 33064237 | 33064237 | PRJEB20058_P_NODE_130685_length_344_cov_48.692580_g127866_i0 | PRJEB20058 | 130685 | 344 | 48.69258 | 167.5024752 | Fadolivirus algeromassiliense | 3060017 | Viruses | Viruses | 49.3 | 5.65e-4 | NR | YP_010803343.1 | 3060017 | g127866 | i0 | 63.2 | 0.331395348837209 | 38 | 14 | 33.1 | 0 | 319 | 206 | 439 | 476 | YP_010803343.1 inosine-5'-monophosphate dehydrogenase [Fadolivirus algeromassiliense] | diamond | 114 | 49.3 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Fadolivirus | Fadolivirus algeromassiliense | ||
| 33064438 | 33064438 | PRJEB20058_P_NODE_162485_length_296_cov_45.565957_g159662_i0 | PRJEB20058 | 162485 | 296 | 45.565957 | 134.87523272 | Fadolivirus algeromassiliense | 3060017 | Viruses | Viruses | 45.8 | 0.0042 | NR | YP_010803501.1 | 3060017 | g159662 | i0 | 47.5 | 0.618243243243243 | 61 | 25 | 57.8 | 3 | 123 | 293 | 1 | 58 | YP_010803501.1 DNA-directed RNA polymerase subunit 9 [Fadolivirus algeromassiliense] | diamond | 183 | 45.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Fadolivirus | Fadolivirus algeromassiliense | ||
| 33065045 | 33065045 | PRJEB20058_P_NODE_47789_length_608_cov_28.369287_g45079_i0 | PRJEB20058 | 47789 | 608 | 28.369287 | 172.48526496 | Thermus phage phiKo | 2301535 | Viruses | Viruses | 74.3 | 3.18e-13 | NR | AYJ74698.1 | 2301535 | g45079 | i0 | 58.8 | 0.251644736842105 | 51 | 21 | 25.2 | 0 | 173 | 21 | 30 | 80 | AYJ74698.1 hypothetical protein phiKo_23 [Thermus phage phiKo] | diamond | 153 | 74.3 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Tectiliviricetes | Kalamavirales | Tectiviridae | Thermus phage phiKo | |||
| 33065320 | 33065320 | PRJEB20058_P_NODE_94677_length_420_cov_78.646240_g91876_i0 | PRJEB20058 | 94677 | 420 | 78.64624 | 330.314208 | Harvfovirus sp. | 2487768 | Viruses | Viruses | 57.8 | 1.39e-6 | NR | AYV80539.1 | 2487768 | g91876 | i0 | 29.2 | 0.928571428571429 | 130 | 92 | 92.9 | 0 | 401 | 12 | 336 | 465 | AYV80539.1 MAG: hypothetical protein Harvfovirus2_69 [Harvfovirus sp.] | diamond | 390 | 57.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Harvfovirus sp. | |||
| 33115375 | 33115375 | PRJEB20058_P_NODE_125839_length_353_cov_6.558219_g123020_i0 | PRJEB20058 | 125839 | 353 | 6.558219 | 23.15051307 | Thermus phage phiKo | 2301535 | Viruses | Viruses | 45.4 | 0.00395 | NR | AYJ74698.1 | 2301535 | g123020 | i0 | 37.7 | 0.45042492917847 | 53 | 32 | 45 | 1 | 176 | 18 | 10 | 61 | AYJ74698.1 hypothetical protein phiKo_23 [Thermus phage phiKo] | diamond | 159 | 45.4 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Tectiliviricetes | Kalamavirales | Tectiviridae | Thermus phage phiKo | |||
| 33133520 | 33133520 | PRJEB20058_P_NODE_72391_length_489_cov_5.654206_g69616_i0 | PRJEB20058 | 72391 | 489 | 5.654206 | 27.64906734 | Thermus phage phiKo | 2301535 | Viruses | Viruses | 83.6 | 3e-17 | NR | AYJ74698.1 | 2301535 | g69616 | i0 | 48.8 | 0.49079754601227 | 80 | 40 | 48.5 | 1 | 237 | 473 | 29 | 108 | AYJ74698.1 hypothetical protein phiKo_23 [Thermus phage phiKo] | diamond | 240 | 83.6 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Tectiliviricetes | Kalamavirales | Tectiviridae | Thermus phage phiKo |
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);;