contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA1035005" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16310272 | 16310272 | PRJNA1035005_P_NODE_5113_length_469_cov_3.684343_g4713_i0 | PRJNA1035005 | 5113 | 469 | 3.684343 | 17.27956867 | Orthopoxvirus | 10242 | Viruses | Viruses | 252 | 7.2e-76 | NR | WBA78916.1 | 10244 | g4713 | i0 | 100 | 19.1705756929638 | 125 | 0 | 80 | 0 | 1 | 375 | 721 | 845 | WBA78916.1 mRNA capping enzyme large subunit [Monkeypox virus] | diamond | 8991 | 252 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Orthopoxvirus | Orthopoxvirus monkeypox | ||
| 26837420 | 26837420 | PRJNA1035005_P_NODE_4261_length_518_cov_1.676404_g3863_i0 | PRJNA1035005 | 4261 | 518 | 1.676404 | 8.68377272 | Orthopoxvirus | 10242 | Viruses | Viruses | 342 | 4.449999999999999e-110 | NR | XEX02893.1 | 10244 | g3863 | i0 | 98.3 | 28.7142857142857 | 172 | 3 | 99.6 | 0 | 516 | 1 | 321 | 492 | XEX02893.1 mRNA capping enzyme large subunit [Monkeypox virus] | diamond | 14874 | 342 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Orthopoxvirus | Orthopoxvirus monkeypox | ||
| 27540806 | 27540806 | PRJNA1035005_P_NODE_11444_length_349_cov_3.358696_g11039_i0 | PRJNA1035005 | 11444 | 349 | 3.358696 | 11.72184904 | Ectromelia virus | 12643 | Viruses | Viruses | 228 | 5.599999999999999e-73 | NR | NP_671619.1 | 12643 | g11039 | i0 | 98.3 | 7.97707736389685 | 116 | 2 | 99.7 | 0 | 1 | 348 | 156 | 271 | NP_671619.1 EVM101 [Ectromelia virus] | diamond | 2784 | 228 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Orthopoxvirus | Orthopoxvirus ectromelia | ||
| 29214391 | 29214391 | PRJNA1035005_P_NODE_71349_length_247_cov_0.896552_g70943_i0 | PRJNA1035005 | 71349 | 247 | 0.896552 | 2.21448344 | Tupanvirus deep ocean | 2126984 | Viruses | Viruses | 46.2 | 0.00223 | NR | YP_010781083.1 | 2126984 | g70943 | i0 | 40.8 | 1.50607287449393 | 71 | 32 | 86.2 | 2 | 35 | 247 | 72 | 132 | YP_010781083.1 hypothetical protein QJ856_gp0282 [Tupanvirus deep ocean] | diamond | 372 | 46.2 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Tupanvirus | Tupanvirus altamarinense | ||
| 29269078 | 29269078 | PRJNA1035005_P_NODE_15529_length_320_cov_1.263158_g15123_i0 | PRJNA1035005 | 15529 | 320 | 1.263158 | 4.0421056 | Marseillevirus | 1513458 | Viruses | Viruses | 75.5 | 2.69e-13 | NR | YP_003406934.1 | 694581 | g15123 | i0 | 33.3 | 2.859375 | 102 | 54 | 94.7 | 2 | 306 | 4 | 318 | 406 | YP_003406934.1 zinc finger protein [Marseillevirus marseillevirus] | diamond | 915 | 75.5 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Marseilleviridae | Marseillevirus | Marseillevirus massiliense | ||
| 29647806 | 29647806 | PRJNA1035005_P_NODE_4210_length_521_cov_1.901786_g3812_i0 | PRJNA1035005 | 4210 | 521 | 1.901786 | 9.90830506 | Orthopoxvirus | 10242 | Viruses | Viruses | 335 | 3.029999999999999e-107 | NR | WJG57483.1 | 10244 | g3812 | i0 | 99.4 | 19.89443378119 | 173 | 1 | 99.6 | 0 | 521 | 3 | 40 | 212 | WJG57483.1 mRNA capping enzyme large subunit [Monkeypox virus] | diamond | 10365 | 335 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Orthopoxvirus | Orthopoxvirus monkeypox | ||
| 30098239 | 30098239 | PRJNA1035005_P_NODE_10572_length_358_cov_1.466667_g10167_i0 | PRJNA1035005 | 10572 | 358 | 1.466667 | 5.25066786 | Terrestrivirus sp. | 2487775 | Viruses | Viruses | 71.6 | 7.01e-12 | NR | AYV75160.1 | 2487775 | g10167 | i0 | 41.5 | 0.687150837988827 | 82 | 41 | 65.4 | 2 | 105 | 338 | 91 | 169 | AYV75160.1 MAG: hypothetical protein Terrestrivirus1_34 [Terrestrivirus sp.] | diamond | 246 | 71.6 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Terrestrivirus sp. | |||
| 30563996 | 30563996 | PRJNA1035005_P_NODE_7813_length_394_cov_1.931464_g7411_i0 | PRJNA1035005 | 7813 | 394 | 1.931464 | 7.60996816 | Megaviricetes | 2732523 | Viruses | Viruses | 102 | 1.9499999999999994e-23 | NR | ARF12675.1 | 1977640 | g7411 | i0 | 51.6 | 3.47969543147208 | 91 | 44 | 69.3 | 0 | 392 | 120 | 196 | 286 | ARF12675.1 dTDP-4-dehydrorhamnose reductase [Klosneuvirus KNV1] | diamond | 1371 | 102 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Klosneuvirus | Klosneuvirus KNV1 | ||
| 30722169 | 30722169 | PRJNA1035005_P_NODE_6714_length_416_cov_1.591837_g6312_i0 | PRJNA1035005 | 6714 | 416 | 1.591837 | 6.62204192 | Orthopoxvirus | 10242 | Viruses | Viruses | 267 | 7.55e-82 | NR | UWJ11783.1 | 10244 | g6312 | i0 | 97.1 | 39.8076923076923 | 138 | 4 | 99.5 | 0 | 414 | 1 | 203 | 340 | UWJ11783.1 mRNA capping enzyme large subunit [Monkeypox virus] | diamond | 16560 | 267 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Orthopoxvirus | Orthopoxvirus monkeypox | ||
| 31203764 | 31203764 | PRJNA1035005_P_NODE_83235_length_243_cov_0.917647_g82829_i0 | PRJNA1035005 | 83235 | 243 | 0.917647 | 2.22988221 | Erythrocytic necrosis virus | 1543320 | Viruses | Viruses | 100 | 6.97e-26 | NR | QCF47522.1 | 1543320 | g82829 | i0 | 82.5 | 1.45679012345679 | 57 | 10 | 70.4 | 0 | 60 | 230 | 9 | 65 | QCF47522.1 hypothetical protein, partial [Erythrocytic necrosis virus] | diamond | 354 | 100 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Iridoviridae | Erythrocytic necrosis virus | |||
| 31267487 | 31267487 | PRJNA1035005_P_NODE_73775_length_246_cov_0.901734_g73369_i0 | PRJNA1035005 | 73775 | 246 | 0.901734 | 2.21826564 | Fadolivirus algeromassiliense | 3060017 | Viruses | Viruses | 66.6 | 1.46e-10 | NR | YP_010804074.1 | 3060017 | g73369 | i0 | 41.3 | 0.914634146341463 | 75 | 44 | 91.5 | 0 | 232 | 8 | 570 | 644 | YP_010804074.1 peptidase family M49 [Fadolivirus algeromassiliense] | diamond | 225 | 66.6 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Fadolivirus | Fadolivirus algeromassiliense | ||
| 31615370 | 31615370 | PRJNA1035005_P_NODE_19876_length_301_cov_1.026316_g19470_i0 | PRJNA1035005 | 19876 | 301 | 1.026316 | 3.08921116 | Hyperionvirus sp. | 2487770 | Viruses | Viruses | 99 | 2.31e-24 | NR | AYV83304.1 | 2487770 | g19470 | i0 | 58.1 | 1.46511627906977 | 74 | 31 | 73.8 | 0 | 301 | 80 | 23 | 96 | AYV83304.1 MAG: cysteine methyltransferase [Hyperionvirus sp.] | diamond | 441 | 99 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Hyperionvirus sp. | |||
| 32406407 | 32406407 | PRJNA1035005_P_NODE_48219_length_259_cov_1.655914_g47813_i0 | PRJNA1035005 | 48219 | 259 | 1.655914 | 4.28881726 | Erythrocytic necrosis virus | 1543320 | Viruses | Viruses | 108 | 5.57e-29 | NR | QCF47522.1 | 1543320 | g47813 | i0 | 78.8 | 0.764478764478765 | 66 | 14 | 76.4 | 0 | 198 | 1 | 1 | 66 | QCF47522.1 hypothetical protein, partial [Erythrocytic necrosis virus] | diamond | 198 | 108 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Iridoviridae | Erythrocytic necrosis virus | |||
| 32469830 | 32469830 | PRJNA1035005_P_NODE_65179_length_249_cov_0.886364_g64773_i0 | PRJNA1035005 | 65179 | 249 | 0.886364 | 2.20704636 | Fadolivirus algeromassiliense | 3060017 | Viruses | Viruses | 45.1 | 0.00613 | NR | YP_010802949.1 | 3060017 | g64773 | i0 | 41.7 | 0.72289156626506 | 60 | 31 | 67.5 | 1 | 11 | 178 | 780 | 839 | YP_010802949.1 chitin synthase [Fadolivirus algeromassiliense] | diamond | 180 | 45.1 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Fadolivirus | Fadolivirus algeromassiliense | ||
| 32816381 | 32816381 | PRJNA1035005_P_NODE_60120_length_251_cov_0.876404_g59714_i0 | PRJNA1035005 | 60120 | 251 | 0.876404 | 2.19977404 | Niemeyer virus | 1766765 | Viruses | Viruses | 42.4 | 0.0482 | NR | ALR83978.1 | 1766765 | g59714 | i0 | 72.4 | 0.346613545816733 | 29 | 8 | 34.7 | 0 | 87 | 1 | 59 | 87 | ALR83978.1 hypothetical protein [Niemeyer virus] | diamond | 87 | 42.4 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Mimivirus | Niemeyer virus |
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);;