contig_metadata
8 rows where bioproject = "PRJNA657343" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27460710 | 27460710 | PRJNA657343_P_NODE_39983_length_165_cov_1.560345_g39959_i0 | PRJNA657343 | 39983 | 165 | 1.560345 | 2.57456925 | Tupanvirus soda lake | 2126985 | Viruses | Viruses | 85.1 | 1.41e-17 | NR | YP_010782185.1 | 2126985 | g39959 | i0 | 70.4 | 1.96363636363636 | 54 | 16 | 98.2 | 0 | 2 | 163 | 374 | 427 | YP_010782185.1 peptidase inhibitor I9 [Tupanvirus soda lake] | diamond | 324 | 85.1 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Tupanvirus | Tupanvirus salinum | ||
| 28060423 | 28060423 | PRJNA657343_P_NODE_36565_length_168_cov_0.873950_g36541_i0 | PRJNA657343 | 36565 | 168 | 0.87395 | 1.468236 | Cotonvirus japonicus | 2811091 | Viruses | Viruses | 55.8 | 3.17e-7 | NR | YP_010841863.1 | 2811091 | g36541 | i0 | 51 | 1.85714285714286 | 49 | 24 | 87.5 | 0 | 8 | 154 | 939 | 987 | YP_010841863.1 hypothetical protein QLL95_gp0868 [Cotonvirus japonicus] | diamond | 312 | 55.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Cotonvirus | Cotonvirus japonicum | ||
| 28849635 | 28849635 | PRJNA657343_P_NODE_3828_length_383_cov_3.077844_g3805_i0 | PRJNA657343 | 3828 | 383 | 3.077844 | 11.78814252 | Orpheovirus IHUMI-LCC2 | 2023057 | Viruses | Viruses | 52 | 1.05e-4 | NR | YP_009449258.1 | 2023057 | g3805 | i0 | 34.8 | 1.51958224543081 | 92 | 52 | 68.1 | 5 | 78 | 338 | 162 | 250 | YP_009449258.1 Domain of unknown function (DUF4114) [Orpheovirus IHUMI-LCC2] | diamond | 582 | 52 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Orpheoviridae | Alphaorpheovirus | Alphaorpheovirus massiliense | ||
| 29102553 | 29102553 | PRJNA657343_P_NODE_25068_length_191_cov_1.063380_g25044_i0 | PRJNA657343 | 25068 | 191 | 1.06338 | 2.0310558 | Orpheovirus IHUMI-LCC2 | 2023057 | Viruses | Viruses | 68.2 | 8.16e-12 | NR | YP_009449316.1 | 2023057 | g25044 | i0 | 63.6 | 0.691099476439791 | 44 | 16 | 69.1 | 0 | 186 | 55 | 204 | 247 | YP_009449316.1 Fatty acid hydroxylase (C-5 sterol desaturase putative) [Orpheovirus IHUMI-LCC2] | diamond | 132 | 68.2 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Orpheoviridae | Alphaorpheovirus | Alphaorpheovirus massiliense | ||
| 30966194 | 30966194 | PRJNA657343_P_NODE_20474_length_206_cov_0.955414_g20450_i0 | PRJNA657343 | 20474 | 206 | 0.955414 | 1.96815284 | Terrestrivirus sp. | 2487775 | Viruses | Viruses | 107 | 1.54e-25 | NR | AYV76711.1 | 2487775 | g20450 | i0 | 72.7 | 8.60679611650485 | 66 | 18 | 96.1 | 0 | 199 | 2 | 12 | 77 | AYV76711.1 MAG: hypothetical protein Terrestrivirus12_14 [Terrestrivirus sp.] | diamond | 1773 | 107 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Terrestrivirus sp. | |||
| 31630003 | 31630003 | PRJNA657343_P_NODE_36476_length_168_cov_0.873950_g36452_i0 | PRJNA657343 | 36476 | 168 | 0.87395 | 1.468236 | Klosneuvirus KNV1 | 1977640 | Viruses | Viruses | 62.4 | 1.6e-9 | NR | ARF12058.1 | 1977640 | g36452 | i0 | 60.9 | 0.821428571428571 | 46 | 18 | 82.1 | 0 | 13 | 150 | 415 | 460 | ARF12058.1 aminotransferase class-III [Klosneuvirus KNV1] | diamond | 138 | 62.4 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Klosneuvirus | Klosneuvirus KNV1 | ||
| 31851251 | 31851251 | PRJNA657343_P_NODE_35237_length_169_cov_0.866667_g35213_i0 | PRJNA657343 | 35237 | 169 | 0.866667 | 1.46466723 | Catovirus CTV1 | 1977631 | Viruses | Viruses | 80.9 | 6.6e-17 | NR | ARF08362.1 | 1977631 | g35213 | i0 | 69.8 | 24.4615384615385 | 53 | 16 | 94.1 | 0 | 4 | 162 | 105 | 157 | ARF08362.1 cyclophilin type peptidyl-prolyl cis-trans isomerase [Catovirus CTV1] | diamond | 4134 | 80.9 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Catovirus | Catovirus CTV1 | ||
| 32168006 | 32168006 | PRJNA657343_P_NODE_44158_length_162_cov_0.920354_g44134_i0 | PRJNA657343 | 44158 | 162 | 0.920354 | 1.49097348 | Orpheovirus IHUMI-LCC2 | 2023057 | Viruses | Viruses | 58.5 | 8.14e-9 | NR | YP_009449036.1 | 2023057 | g44134 | i0 | 51.2 | 0.796296296296296 | 43 | 21 | 79.6 | 0 | 139 | 11 | 49 | 91 | YP_009449036.1 Hypothetical protein ORPV_830 [Orpheovirus IHUMI-LCC2] | diamond | 129 | 58.5 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Orpheoviridae | Alphaorpheovirus | Alphaorpheovirus massiliense |
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);;