contig_metadata
9 rows where bioproject = "PRJNA715462", tax_phylum = "Nucleocytoviricota" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2467615 | 2467615 | PRJNA715462_P_NODE_39282_length_283_cov_1.461905_g38486_i0 | PRJNA715462 | 39282 | 283 | 1.461905 | 4.13719115 | Marseillevirus | 1513458 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|1143708043|gb|KX066233.1| | 1955558 | g38486 | i0 | 83.607 | 1.68197879858657 | 61 | 9 | 22 | 1 | 57 | 117 | 77933 | 77992 | Noumeavirus isolate NMV1, complete genome | blastn | 476 | 56.5 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Marseilleviridae | Marseillevirus | Noumeavirus | ||
| 18558056 | 18558056 | PRJNA715462_P_NODE_54955_length_249_cov_0.875000_g54159_i0 | PRJNA715462 | 54955 | 249 | 0.875 | 2.17875 | Orpheovirus IHUMI-LCC2 | 2023057 | Viruses | Viruses | 143 | 1.45e-38 | NR | YP_009448811.1 | 2023057 | g54159 | i0 | 79.3 | 5.92771084337349 | 82 | 17 | 98.8 | 0 | 247 | 2 | 299 | 380 | YP_009448811.1 Serine-tRNA synthetase, type1 [Orpheovirus IHUMI-LCC2] | diamond | 1476 | 143 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Orpheoviridae | Alphaorpheovirus | Alphaorpheovirus massiliense | ||
| 26767095 | 26767095 | PRJNA715462_P_NODE_54261_length_249_cov_0.875000_g53465_i0 | PRJNA715462 | 54261 | 249 | 0.875 | 2.17875 | Terrestrivirus sp. | 2487775 | Viruses | Viruses | 50.1 | 1.06e-4 | NR | AYV76641.1 | 2487775 | g53465 | i0 | 68.8 | 0.385542168674699 | 32 | 9 | 38.6 | 1 | 106 | 11 | 796 | 826 | AYV76641.1 MAG: ubiquitin-conjugating enzyme subfamily protein [Terrestrivirus sp.] | diamond | 96 | 50.1 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Terrestrivirus sp. | |||
| 27620749 | 27620749 | PRJNA715462_P_NODE_50164_length_251_cov_1.730337_g49368_i0 | PRJNA715462 | 50164 | 251 | 1.730337 | 4.34314587 | Mimiviridae sp. ChoanoV1 | 2596887 | Viruses | Viruses | 74.7 | 2.14e-13 | NR | QDY51925.1 | 2596887 | g49368 | i0 | 45.8 | 0.99203187250996006 | 83 | 42 | 99.2 | 1 | 251 | 3 | 353 | 432 | QDY51925.1 indoleamine 2,3-dioxygenase [Mimiviridae sp. ChoanoV1] | diamond | 249 | 74.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Schizomimiviridae | Mimiviridae sp. ChoanoV1 | |||
| 28188708 | 28188708 | PRJNA715462_P_NODE_60046_length_246_cov_0.890173_g59250_i0 | PRJNA715462 | 60046 | 246 | 0.890173 | 2.18982558 | Terrestrivirus sp. | 2487775 | Viruses | Viruses | 90.1 | 8.12e-19 | NR | AYV75980.1 | 2487775 | g59250 | i0 | 51.9 | 0.98780487804878 | 81 | 37 | 98.8 | 1 | 245 | 3 | 493 | 571 | AYV75980.1 MAG: hypothetical protein Terrestrivirus4_28 [Terrestrivirus sp.] | diamond | 243 | 90.1 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Terrestrivirus sp. | |||
| 30220409 | 30220409 | PRJNA715462_P_NODE_13872_length_532_cov_1.675381_g13078_i0 | PRJNA715462 | 13872 | 532 | 1.675381 | 8.91302692 | Tupanvirus | 2094720 | Viruses | Viruses | 139 | 2.3e-37 | NR | YP_010781102.1 | 2126984 | g13078 | i0 | 50 | 1.62406015037594 | 148 | 72 | 83.5 | 2 | 446 | 3 | 6 | 151 | YP_010781102.1 hypoxanthine phosphoribosyltransferase [Tupanvirus deep ocean] | diamond | 864 | 140 | 0.992857142857143 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Tupanvirus | Tupanvirus altamarinense | ||
| 31663674 | 31663674 | PRJNA715462_P_NODE_70077_length_234_cov_2.018634_g69281_i0 | PRJNA715462 | 70077 | 234 | 2.018634 | 4.72360356 | Fadolivirus algeromassiliense | 3060017 | Viruses | Viruses | 103 | 5.0599999999999996e-24 | NR | YP_010803269.1 | 3060017 | g69281 | i0 | 61 | 0.987179487179487 | 77 | 30 | 98.7 | 0 | 3 | 233 | 226 | 302 | YP_010803269.1 ornithine decaroboxylase [Fadolivirus algeromassiliense] | diamond | 231 | 103 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Fadolivirus | Fadolivirus algeromassiliense | ||
| 31790140 | 31790140 | PRJNA715462_P_NODE_8737_length_742_cov_2.121076_g7992_i0 | PRJNA715462 | 8737 | 742 | 2.121076 | 15.73838392 | Satyrvirus sp. | 2487771 | Viruses | Viruses | 79.7 | 3.99e-14 | NR | AYV85215.1 | 2487771 | g7992 | i0 | 33.6 | 0.529649595687331 | 131 | 80 | 53 | 2 | 719 | 327 | 71 | 194 | AYV85215.1 MAG: START domain containing protein [Satyrvirus sp.] | diamond | 393 | 79.7 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Satyrvirus sp. | |||
| 32801509 | 32801509 | PRJNA715462_P_NODE_22640_length_383_cov_1.435484_g21844_i0 | PRJNA715462 | 22640 | 383 | 1.435484 | 5.49790372 | Emiliania huxleyi virus 2 | 181208 | Viruses | Viruses | 68.6 | 1.11e-10 | NR | AET42571.1 | 181211 | g21844 | i0 | 39.2 | 2.88250652741514 | 120 | 48 | 94 | 3 | 2 | 361 | 212 | 306 | AET42571.1 fatty acid elongase [Emiliania huxleyi virus 202] | diamond | 1104 | 68.6 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Algavirales | Phycodnaviridae | Coccolithovirus | Emiliania huxleyi virus 202 |
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);;