contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA564013" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27110646 | 27110646 | PRJNA564013_P_NODE_101382_length_407_cov_137.609827_g98548_i0 | PRJNA564013 | 101382 | 407 | 137.609827 | 560.07199589 | Lake Baikal virophage 5 | 3086128 | Viruses | Viruses | 57 | 6.3e-7 | NR | WPF46558.1 | 3086128 | g98548 | i0 | 43.1 | 0.479115479115479 | 65 | 33 | 47.9 | 2 | 130 | 324 | 8 | 68 | WPF46558.1 MAG: hypothetical protein [Lake Baikal virophage 5] | diamond | 195 | 57 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Virophaviricetes | Priklausovirales | Lavidaviridae | Lake Baikal virophage 5 | |||
| 27364028 | 27364028 | PRJNA564013_P_NODE_245303_length_265_cov_4.750000_g242451_i0 | PRJNA564013 | 245303 | 265 | 4.75 | 12.5875 | Lake Baikal virophage 9 | 3086132 | Viruses | Viruses | 57 | 4.58e-7 | NR | WPF46692.1 | 3086132 | g242451 | i0 | 41.1 | 0.826415094339623 | 73 | 40 | 82.6 | 1 | 263 | 45 | 100 | 169 | WPF46692.1 MAG: hypothetical protein [Lake Baikal virophage 9] | diamond | 219 | 57 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Virophaviricetes | Priklausovirales | Lavidaviridae | Lake Baikal virophage 9 | |||
| 27395532 | 27395532 | PRJNA564013_P_NODE_226043_length_282_cov_3.330317_g223192_i0 | PRJNA564013 | 226043 | 282 | 3.330317 | 9.39149394 | Armadillidium vulgare iridescent virus | 72201 | Viruses | Viruses | 87.8 | 9.04e-18 | NR | YP_009046615.1 | 72201 | g223192 | i0 | 58.1 | 0.659574468085106 | 62 | 20 | 59.6 | 1 | 189 | 22 | 3 | 64 | YP_009046615.1 delta DNA polymerase (B family) [Armadillidium vulgare iridescent virus] | diamond | 186 | 87.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Iridoviridae | Iridovirus | Iridovirus armadillidium1 | ||
| 27552946 | 27552946 | PRJNA564013_P_NODE_169884_length_334_cov_2.271062_g167034_i0 | PRJNA564013 | 169884 | 334 | 2.271062 | 7.58534708 | Lake Baikal virophage 9 | 3086132 | Viruses | Viruses | 73.6 | 6.75e-13 | NR | WPF46688.1 | 3086132 | g167034 | i0 | 41 | 0.898203592814371 | 100 | 54 | 85.3 | 1 | 35 | 319 | 139 | 238 | WPF46688.1 MAG: hypothetical protein [Lake Baikal virophage 9] | diamond | 300 | 73.6 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Virophaviricetes | Priklausovirales | Lavidaviridae | Lake Baikal virophage 9 | |||
| 27868771 | 27868771 | PRJNA564013_P_NODE_251125_length_260_cov_5.638191_g248273_i0 | PRJNA564013 | 251125 | 260 | 5.638191 | 14.6592966 | Lake Baikal virophage 9 | 3086132 | Viruses | Viruses | 84.3 | 1.07e-16 | NR | WPF46692.1 | 3086132 | g248273 | i0 | 42.4 | 0.980769230769231 | 85 | 49 | 98.1 | 0 | 257 | 3 | 12 | 96 | WPF46692.1 MAG: hypothetical protein [Lake Baikal virophage 9] | diamond | 255 | 84.3 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Virophaviricetes | Priklausovirales | Lavidaviridae | Lake Baikal virophage 9 | |||
| 28215981 | 28215981 | PRJNA564013_P_NODE_193166_length_312_cov_14.274900_g190315_i0 | PRJNA564013 | 193166 | 312 | 14.2749 | 44.537688 | Adenovirus acanthiza15342 | 3115873 | Viruses | Viruses | 55.8 | 2.3e-7 | NR | DBA47579.1 | 3115873 | g190315 | i0 | 39.2 | 0.759615384615385 | 79 | 48 | 76 | 0 | 25 | 261 | 39 | 117 | DBA47579.1 MAG TPA_asm: Oncoid2 [Adenovirus acanthiza15342] | diamond | 237 | 55.8 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Adenovirus acanthiza15342 | |||
| 28374060 | 28374060 | PRJNA564013_P_NODE_308846_length_220_cov_1.880503_g305994_i0 | PRJNA564013 | 308846 | 220 | 1.880503 | 4.1371066 | Erythrocytic necrosis virus | 1543320 | Viruses | Viruses | 73.9 | 1.02e-13 | NR | QCF47454.1 | 1543320 | g305994 | i0 | 81.4 | 1.17272727272727 | 43 | 8 | 58.6 | 0 | 20 | 148 | 215 | 257 | QCF47454.1 hypothetical protein, partial [Erythrocytic necrosis virus] | diamond | 258 | 73.9 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Iridoviridae | Erythrocytic necrosis virus | |||
| 29132055 | 29132055 | PRJNA564013_P_NODE_264389_length_250_cov_2.100529_g261537_i0 | PRJNA564013 | 264389 | 250 | 2.100529 | 5.2513225 | Tupanvirus deep ocean | 2126984 | Viruses | Viruses | 80.1 | 2.92e-15 | NR | YP_010780508.1 | 2126984 | g261537 | i0 | 75 | 2.304 | 48 | 12 | 57.6 | 0 | 144 | 1 | 315 | 362 | YP_010780508.1 putative DNA mismatch repair protein muts-like protein [Tupanvirus deep ocean] | diamond | 576 | 80.1 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Tupanvirus | Tupanvirus altamarinense | ||
| 29289668 | 29289668 | PRJNA564013_P_NODE_13249_length_975_cov_16.739606_g11361_i0 | PRJNA564013 | 13249 | 975 | 16.739606 | 163.2111585 | Terrestrivirus sp. | 2487775 | Viruses | Viruses | 137 | 3.919999999999999e-34 | NR | AYV76653.1 | 2487775 | g11361 | i0 | 55 | 0.369230769230769 | 120 | 52 | 36.9 | 1 | 8 | 367 | 187 | 304 | AYV76653.1 MAG: beta-lactamase superfamily domain [Terrestrivirus sp.] | diamond | 360 | 137 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Terrestrivirus sp. | |||
| 29763226 | 29763226 | PRJNA564013_P_NODE_307291_length_221_cov_1.675000_g304439_i0 | PRJNA564013 | 307291 | 221 | 1.675 | 3.70175 | Erythrocytic necrosis virus | 1543320 | Viruses | Viruses | 71.6 | 1.42e-14 | NR | QCF47522.1 | 1543320 | g304439 | i0 | 82.9 | 1.66968325791855 | 41 | 7 | 55.7 | 0 | 3 | 125 | 23 | 63 | QCF47522.1 hypothetical protein, partial [Erythrocytic necrosis virus] | diamond | 369 | 71.6 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Iridoviridae | Erythrocytic necrosis virus | |||
| 30805968 | 30805968 | PRJNA564013_P_NODE_203754_length_302_cov_16.605809_g200903_i0 | PRJNA564013 | 203754 | 302 | 16.605809 | 50.14954318 | Bodo saltans virus | 2024608 | Viruses | Viruses | 93.2 | 1.2e-19 | NR | YP_010778545.1 | 2024608 | g200903 | i0 | 46.9 | 0.973509933774834 | 98 | 48 | 96.4 | 2 | 10 | 300 | 369 | 463 | YP_010778545.1 bifunctional dihydrofolate reductase/thymidylate synthase [Bodo saltans virus] | diamond | 294 | 93.2 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Theiavirus | Theiavirus salishense | ||
| 30882865 | 30882865 | PRJNA564013_P_NODE_50194_length_558_cov_5.460765_g47439_i0 | PRJNA564013 | 50194 | 558 | 5.460765 | 30.4710687 | Orthopoxvirus | 10242 | Viruses | Viruses | 344 | 2.0099999999999996e-110 | NR | XEX02893.1 | 10244 | g47439 | i0 | 93.9 | 22.2150537634409 | 181 | 11 | 97.3 | 0 | 1 | 543 | 321 | 501 | XEX02893.1 mRNA capping enzyme large subunit [Monkeypox virus] | diamond | 12396 | 344 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Orthopoxvirus | Orthopoxvirus monkeypox | ||
| 30964076 | 30964076 | PRJNA564013_P_NODE_286954_length_234_cov_1.502890_g284102_i0 | PRJNA564013 | 286954 | 234 | 1.50289 | 3.5167626 | Barrevirus sp. | 2487763 | Viruses | Viruses | 73.9 | 2.72e-13 | NR | AYV76987.1 | 2487763 | g284102 | i0 | 55.1 | 1 | 78 | 25 | 88.5 | 2 | 27 | 233 | 220 | 296 | AYV76987.1 MAG: AAA family ATPase [Barrevirus sp.] | diamond | 234 | 73.9 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Barrevirus sp. | |||
| 31374979 | 31374979 | PRJNA564013_P_NODE_29016_length_702_cov_19.555382_g3266_i2 | PRJNA564013 | 29016 | 702 | 19.555382 | 137.27878164 | Ectromelia virus | 12643 | Viruses | Viruses | 390 | 1.27e-134 | NR | NP_671619.1 | 12643 | g3266 | i2 | 97.5 | 4.23076923076923 | 200 | 5 | 85.5 | 0 | 677 | 78 | 22 | 221 | NP_671619.1 EVM101 [Ectromelia virus] | diamond | 2970 | 390 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Orthopoxvirus | Orthopoxvirus ectromelia | ||
| 32007534 | 32007534 | PRJNA564013_P_NODE_33838_length_659_cov_3.603679_g31200_i0 | PRJNA564013 | 33838 | 659 | 3.603679 | 23.74824461 | Catovirus CTV1 | 1977631 | Viruses | Viruses | 96.7 | 1.9e-20 | NR | ARF08563.1 | 1977631 | g31200 | i0 | 49.5 | 1.05614567526555 | 101 | 51 | 46 | 0 | 334 | 32 | 88 | 188 | ARF08563.1 DNA primase [Catovirus CTV1] | diamond | 696 | 96.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Catovirus | Catovirus CTV1 | ||
| 32734546 | 32734546 | PRJNA564013_P_NODE_194320_length_311_cov_9.808000_g191469_i0 | PRJNA564013 | 194320 | 311 | 9.808 | 30.50288 | Fadolivirus algeromassiliense | 3060017 | Viruses | Viruses | 119 | 8.01e-29 | NR | YP_010803358.1 | 3060017 | g191469 | i0 | 53.1 | 2.80707395498392 | 98 | 46 | 94.5 | 0 | 310 | 17 | 10 | 107 | YP_010803358.1 major capsid protein [Fadolivirus algeromassiliense] | diamond | 873 | 119 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Fadolivirus | Fadolivirus algeromassiliense |
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);;