contig_metadata
8 rows where bioproject = "PRJNA1059246" and tax_phylum = "Nucleocytoviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2727610 | 2727610 | PRJNA1059246_P_NODE_40183_length_336_cov_0.768061_g39557_i0 | PRJNA1059246 | 40183 | 336 | 0.768061 | 2.58068496 | Satyrvirus sp. | 2487771 | Viruses | Viruses | 52.8 | 0.032 | NTclustered | gi|1512480655|gb|MK072438.1| | 2487771 | g39557 | i0 | 100 | 0.0833333333333333 | 28 | 0 | 8 | 0 | 215 | 242 | 4879 | 4852 | MAG: Satyrvirus sp. clone Satyrvirus_2 genomic sequence | blastn | 28 | 52.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Satyrvirus sp. | |||
| 5279685 | 5279685 | PRJNA1059246_P_NODE_28285_length_415_cov_1.511696_g27660_i0 | PRJNA1059246 | 28285 | 415 | 1.511696 | 6.2735384 | root | 1 | Root_unresolved | Root_unresolved | 78.2 | 1.99e-16 | NR | ARF12247.1 | 1977640 | g27660 | i0 | 77.5 | 3.6144578313253 | 40 | 9 | 28.9 | 0 | 47 | 166 | 1 | 40 | ARF12247.1 hypothetical protein Klosneuvirus_4_62 [Klosneuvirus KNV1] | diamond | 1500 | 78.6 | 0.994910941475827 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Klosneuvirus | Klosneuvirus KNV1 | ||
| 20578111 | 20578111 | PRJNA1059246_P_NODE_36897_length_354_cov_0.875445_g36271_i0 | PRJNA1059246 | 36897 | 354 | 0.875445 | 3.0990753 | Orpheovirus IHUMI-LCC2 | 2023057 | Viruses | Viruses | 145 | 5.18e-40 | NR | YP_009449055.1 | 2023057 | g36271 | i0 | 64 | 0.966101694915254 | 114 | 40 | 96.6 | 1 | 13 | 354 | 4 | 116 | YP_009449055.1 ribonucleotide reductase large subunit [Orpheovirus IHUMI-LCC2] | diamond | 342 | 145 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Orpheoviridae | Alphaorpheovirus | Alphaorpheovirus massiliense | ||
| 27027143 | 27027143 | PRJNA1059246_P_NODE_54262_length_276_cov_1.369458_g53636_i0 | PRJNA1059246 | 54262 | 276 | 1.369458 | 3.77970408 | Tupanvirus | 2094720 | Viruses | Viruses | 46.6 | 0.00203 | NR | YP_010780069.1 | 2126984 | g53636 | i0 | 48.8 | 0.891304347826087 | 41 | 21 | 44.6 | 0 | 265 | 143 | 186 | 226 | YP_010780069.1 hypothetical protein QJ856_gp0053 [Tupanvirus deep ocean] | diamond | 246 | 47 | 0.991489361702128 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Tupanvirus | Tupanvirus altamarinense | ||
| 29909153 | 29909153 | PRJNA1059246_P_NODE_28431_length_414_cov_1.307918_g27806_i0 | PRJNA1059246 | 28431 | 414 | 1.307918 | 5.41478052 | Hyperionvirus sp. | 2487770 | Viruses | Viruses | 58.5 | 5.72e-7 | NR | AYV82936.1 | 2487770 | g27806 | i0 | 35.1 | 0.557971014492754 | 77 | 49 | 55.1 | 1 | 3 | 230 | 238 | 314 | AYV82936.1 MAG: glycoside hydrolase [Hyperionvirus sp.] | diamond | 231 | 58.5 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Hyperionvirus sp. | |||
| 30288522 | 30288522 | PRJNA1059246_P_NODE_25072_length_446_cov_2.254692_g24448_i0 | PRJNA1059246 | 25072 | 446 | 2.254692 | 10.05592632 | Tupanvirus soda lake | 2126985 | Viruses | Viruses | 61.6 | 4.07e-8 | NR | YP_010782386.1 | 2126985 | g24448 | i0 | 34 | 0.672645739910314 | 100 | 65 | 67.3 | 1 | 441 | 142 | 108 | 206 | YP_010782386.1 hypothetical protein QJ857_gp0321 [Tupanvirus soda lake] | diamond | 300 | 61.6 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Tupanvirus | Tupanvirus salinum | ||
| 30351950 | 30351950 | PRJNA1059246_P_NODE_64232_length_249_cov_0.875000_g63606_i0 | PRJNA1059246 | 64232 | 249 | 0.875 | 2.17875 | Hyperionvirus sp. | 2487770 | Viruses | Viruses | 50.1 | 1.02e-4 | NR | AYV82886.1 | 2487770 | g63606 | i0 | 38.4 | 0.879518072289157 | 73 | 38 | 79.5 | 1 | 39 | 236 | 25 | 97 | AYV82886.1 MAG: hypothetical protein Hyperionvirus3_32 [Hyperionvirus sp.] | diamond | 219 | 50.1 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Hyperionvirus sp. | |||
| 30983465 | 30983465 | PRJNA1059246_P_NODE_62574_length_250_cov_0.954802_g61948_i0 | PRJNA1059246 | 62574 | 250 | 0.954802 | 2.387005 | Dishui Lake phycodnavirus 3 | 2704074 | Viruses | Viruses | 45.1 | 0.00606 | NR | QIG59731.1 | 2704074 | g61948 | i0 | 74.1 | 0.624 | 27 | 7 | 32.4 | 0 | 2 | 82 | 371 | 397 | QIG59731.1 ornithine decarboxylase [Dishui Lake phycodnavirus 3] | diamond | 156 | 45.1 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Algavirales | Phycodnaviridae | Prasinovirus | Dishui Lake phycodnavirus 3 |
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);;