contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA1067370" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11659330 | 11659330 | PRJNA1067370_P_NODE_23430_length_393_cov_1.606250_g22882_i0 | PRJNA1067370 | 23430 | 393 | 1.60625 | 6.3125625 | Chlorella virus XW | 10507 | Viruses | Viruses | 112 | 5.62e-26 | NR | ULY68464.1 | 2922419 | g22882 | i0 | 78.9 | 0.435114503816794 | 57 | 12 | 43.5 | 0 | 142 | 312 | 381 | 437 | ULY68464.1 deoxyribodipyrimidine photo-lyase [Chlorella virus XW01] | diamond | 171 | 112 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Chlorella virus XW01 | |||
| 26655506 | 26655506 | PRJNA1067370_P_NODE_9141_length_599_cov_2.500000_g8609_i0 | PRJNA1067370 | 9141 | 599 | 2.5 | 14.975 | Cotonvirus japonicus | 2811091 | Viruses | Viruses | 87.4 | 3.42e-16 | NR | YP_010842096.1 | 2811091 | g8609 | i0 | 31.2 | 3.3906510851419 | 157 | 106 | 77.6 | 2 | 465 | 1 | 304 | 460 | YP_010842096.1 putative amine oxidase [Cotonvirus japonicus] | diamond | 2031 | 87.4 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Cotonvirus | Cotonvirus japonicum | ||
| 27415124 | 27415124 | PRJNA1067370_P_NODE_2903_length_1002_cov_2.264801_g2505_i0 | PRJNA1067370 | 2903 | 1002 | 2.264801 | 22.69330602 | Yasminevirus sp. GU-2 | 3060817 | Viruses | Viruses | 428 | 1.16e-146 | NR | VBB17617.1 | 2420051 | g2505 | i0 | 69.3 | 0.937125748502994 | 313 | 96 | 93.7 | 0 | 57 | 995 | 3 | 315 | VBB17617.1 2-nitropropane dioxygenase [Yasminevirus sp. GU-2018] | diamond | 939 | 428 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Yasminevirus | Yasminevirus saudimassiliense | ||
| 27762436 | 27762436 | PRJNA1067370_P_NODE_41164_length_316_cov_0.950617_g40616_i0 | PRJNA1067370 | 41164 | 316 | 0.950617 | 3.00394972 | Catovirus CTV1 | 1977631 | Viruses | Viruses | 72.8 | 2.41e-12 | NR | ARF08384.1 | 1977631 | g40616 | i0 | 38.5 | 1.98417721518987 | 109 | 59 | 99.7 | 3 | 315 | 1 | 164 | 268 | ARF08384.1 choline dehydrogenase / GMC-type oxidoreductase [Catovirus CTV1] | diamond | 627 | 72.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Catovirus | Catovirus CTV1 | ||
| 29214855 | 29214855 | PRJNA1067370_P_NODE_59869_length_280_cov_1.260870_g59320_i0 | PRJNA1067370 | 59869 | 280 | 1.26087 | 3.530436 | Adintovirus tuber11 | 3115950 | Viruses | Viruses | 76.6 | 3.56e-14 | NR | DBA47559.1 | 3115950 | g59320 | i0 | 68.6 | 1.65 | 51 | 16 | 54.6 | 0 | 127 | 279 | 112 | 162 | DBA47559.1 MAG TPA_asm: Integrase [Adintovirus tuber11084] | diamond | 462 | 76.6 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Polintoviricetes | Orthopolintovirales | Adintoviridae | Adintovirus tuber11084 | |||
| 29277500 | 29277500 | PRJNA1067370_P_NODE_10329_length_566_cov_0.967546_g9790_i0 | PRJNA1067370 | 10329 | 566 | 0.967546 | 5.47631036 | Catovirus CTV1 | 1977631 | Viruses | Viruses | 94 | 1.09e-18 | NR | ARF08206.1 | 1977631 | g9790 | i0 | 36.6 | 2.2791519434629 | 183 | 100 | 95.4 | 5 | 542 | 3 | 25 | 194 | ARF08206.1 regulator of G protein signaling domain [Catovirus CTV1] | diamond | 1290 | 94 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Catovirus | Catovirus CTV1 | ||
| 29277615 | 29277615 | PRJNA1067370_P_NODE_80829_length_251_cov_0.865169_g80280_i0 | PRJNA1067370 | 80829 | 251 | 0.865169 | 2.17157419 | Satyrvirus sp. | 2487771 | Viruses | Viruses | 51.2 | 2.39e-5 | NR | AYV85215.1 | 2487771 | g80280 | i0 | 33.3 | 0.968127490039841 | 81 | 49 | 95.6 | 2 | 10 | 249 | 90 | 166 | AYV85215.1 MAG: START domain containing protein [Satyrvirus sp.] | diamond | 243 | 51.2 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Satyrvirus sp. | |||
| 29498744 | 29498744 | PRJNA1067370_P_NODE_87390_length_249_cov_0.875000_g86841_i0 | PRJNA1067370 | 87390 | 249 | 0.875 | 2.17875 | Fadolivirus algeromassiliense | 3060017 | Viruses | Viruses | 108 | 6.44e-26 | NR | YP_010803269.1 | 3060017 | g86841 | i0 | 61.4 | 1 | 83 | 32 | 100 | 0 | 1 | 249 | 226 | 308 | YP_010803269.1 ornithine decaroboxylase [Fadolivirus algeromassiliense] | diamond | 249 | 108 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Fadolivirus | Fadolivirus algeromassiliense | ||
| 30225106 | 30225106 | PRJNA1067370_P_NODE_12952_length_510_cov_1.144165_g12405_i0 | PRJNA1067370 | 12952 | 510 | 1.144165 | 5.8352415 | Barrevirus sp. | 2487763 | Viruses | Viruses | 53.1 | 6.25e-5 | NR | AYV77273.1 | 2487763 | g12405 | i0 | 29.3 | 1.55294117647059 | 164 | 111 | 95.3 | 5 | 487 | 2 | 5 | 165 | AYV77273.1 MAG: START domain containing protein [Barrevirus sp.] | diamond | 792 | 53.1 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Barrevirus sp. | |||
| 30627427 | 30627427 | PRJNA1067370_P_NODE_64313_length_273_cov_1.540000_g63764_i0 | PRJNA1067370 | 64313 | 273 | 1.54 | 4.2042 | Mimiviridae | 549779 | Viruses | Viruses | 54.3 | 4.63e-6 | NR | YP_010780304.1 | 2126984 | g63764 | i0 | 31.1 | 1.97802197802198 | 90 | 59 | 98.9 | 1 | 3 | 272 | 635 | 721 | YP_010780304.1 hypothetical protein QJ856_gp1061 [Tupanvirus deep ocean] | diamond | 540 | 54.3 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Tupanvirus | Tupanvirus altamarinense | ||
| 30952104 | 30952104 | PRJNA1067370_P_NODE_80114_length_251_cov_0.865169_g79565_i0 | PRJNA1067370 | 80114 | 251 | 0.865169 | 2.17157419 | Terrestrivirus sp. | 2487775 | Viruses | Viruses | 45.8 | 8.12e-4 | NR | AYV76392.1 | 2487775 | g79565 | i0 | 47.1 | 0.609561752988048 | 51 | 24 | 61 | 1 | 243 | 91 | 1 | 48 | AYV76392.1 MAG: hypothetical protein Terrestrivirus6_18 [Terrestrivirus sp.] | diamond | 153 | 45.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Terrestrivirus sp. | |||
| 32058607 | 32058607 | PRJNA1067370_P_NODE_108058_length_243_cov_0.905882_g107509_i0 | PRJNA1067370 | 108058 | 243 | 0.905882 | 2.20129326 | Tupanvirus soda lake | 2126985 | Viruses | Viruses | 66.6 | 1.37e-10 | NR | YP_010781435.1 | 2126985 | g107509 | i0 | 34.2 | 0.975308641975309 | 79 | 52 | 97.5 | 0 | 242 | 6 | 123 | 201 | YP_010781435.1 cytidylyltransferase [Tupanvirus soda lake] | diamond | 237 | 66.6 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Tupanvirus | Tupanvirus salinum | ||
| 32240455 | 32240455 | PRJNA1067370_P_NODE_31138_length_350_cov_2.815884_g30590_i0 | PRJNA1067370 | 31138 | 350 | 2.815884 | 9.855594 | root | 1 | Root_unresolved | Root_unresolved | 61.2 | 3.72e-9 | NR | ARF09665.1 | 1977633 | g30590 | i0 | 34.7 | 1.63714285714286 | 101 | 55 | 86.6 | 2 | 46 | 348 | 33 | 122 | ARF09665.1 autophagy protein Atg8 ubiquitin-like protein [Indivirus ILV1] | diamond | 573 | 61.6 | 0.993506493506494 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Indivirus | Indivirus ILV1 | ||
| 32248877 | 32248877 | PRJNA1067370_P_NODE_34698_length_336_cov_3.418251_g34150_i0 | PRJNA1067370 | 34698 | 336 | 3.418251 | 11.48532336 | Catovirus CTV1 | 1977631 | Viruses | Viruses | 112 | 1.01e-29 | NR | ARF08309.1 | 1977631 | g34150 | i0 | 49.5 | 0.883928571428571 | 99 | 50 | 88.4 | 0 | 19 | 315 | 6 | 104 | ARF08309.1 acyl-CoA binding protein [Catovirus CTV1] | diamond | 297 | 112 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Catovirus | Catovirus CTV1 | ||
| 32659178 | 32659178 | PRJNA1067370_P_NODE_61180_length_278_cov_1.302439_g60631_i0 | PRJNA1067370 | 61180 | 278 | 1.302439 | 3.62078042 | Tupanvirus soda lake | 2126985 | Viruses | Viruses | 108 | 3.19e-26 | NR | YP_010782084.1 | 2126985 | g60631 | i0 | 59.1 | 1.91007194244604 | 88 | 35 | 95 | 1 | 264 | 1 | 74 | 160 | YP_010782084.1 thioredoxin-disulfide reductase [Tupanvirus soda lake] | diamond | 531 | 108 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Tupanvirus | Tupanvirus salinum | ||
| 32879724 | 32879724 | PRJNA1067370_P_NODE_107040_length_243_cov_0.905882_g106491_i0 | PRJNA1067370 | 107040 | 243 | 0.905882 | 2.20129326 | Cotonvirus japonicus | 2811091 | Viruses | Viruses | 45.4 | 0.00423 | NR | YP_010841179.1 | 2811091 | g106491 | i0 | 41.6 | 0.950617283950617 | 77 | 42 | 91.4 | 1 | 10 | 231 | 227 | 303 | YP_010841179.1 putative Sel1-like repeat-containing protein [Cotonvirus japonicus] | diamond | 231 | 45.4 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Cotonvirus | Cotonvirus japonicum |
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);;