contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJEB10140" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26621082 | 26621082 | PRJEB10140_P_NODE_39781_length_895_cov_8.860520_g25654_i0 | PRJEB10140 | 39781 | 895 | 8.86052 | 79.301654 | Invertebrate iridescent virus 6 | 176652 | Viruses | Viruses | 65.5 | 1.3e-8 | NR | QMS79707.1 | 176652 | g25654 | i0 | 38.5 | 0.49608938547486 | 78 | 47 | 26.1 | 1 | 651 | 418 | 40 | 116 | QMS79707.1 hypothetical protein IIV6-T1_193 [Invertebrate iridescent virus 6] | diamond | 444 | 65.5 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Iridoviridae | Iridovirus | Iridovirus chilo1 | ||
| 28106378 | 28106378 | PRJEB10140_P_NODE_22685_length_1389_cov_4.244030_g13322_i0 | PRJEB10140 | 22685 | 1389 | 4.24403 | 58.9495767 | Fadolivirus algeromassiliense | 3060017 | Viruses | Viruses | 99.8 | 1.74e-18 | NR | YP_010804011.1 | 3060017 | g13322 | i0 | 23.6 | 1.47948164146868 | 369 | 228 | 77.5 | 8 | 251 | 1327 | 144 | 468 | YP_010804011.1 globin/protoglobin [Fadolivirus algeromassiliense] | diamond | 2055 | 99.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Fadolivirus | Fadolivirus algeromassiliense | ||
| 29527376 | 29527376 | PRJEB10140_P_NODE_181650_length_211_cov_1.246914_g164341_i0 | PRJEB10140 | 181650 | 211 | 1.246914 | 2.63098854 | Shearwaterpox virus | 1974596 | Viruses | Viruses | 50.1 | 1.24e-5 | NR | ARF02626.1 | 1974596 | g164341 | i0 | 39.1 | 0.909952606635071 | 64 | 38 | 91 | 1 | 2 | 193 | 43 | 105 | ARF02626.1 SWPV1-007 [Shearwaterpox virus] | diamond | 192 | 50.1 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Avipoxvirus | Avipoxvirus canarypox | ||
| 30158761 | 30158761 | PRJEB10140_P_NODE_273212_length_164_cov_2.017391_g255903_i0 | PRJEB10140 | 273212 | 164 | 2.017391 | 3.30852124 | Volepox virus | 28874 | Viruses | Viruses | 41.6 | 0.0326 | NR | YP_009281930.1 | 28874 | g255903 | i0 | 41.9 | 0.786585365853659 | 43 | 23 | 78.7 | 1 | 36 | 164 | 196 | 236 | YP_009281930.1 eev type-1 membrane glycoprotein [Volepox virus] | diamond | 129 | 41.6 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Orthopoxvirus | Orthopoxvirus volepox | ||
| 31296410 | 31296410 | PRJEB10140_P_NODE_11855_length_2061_cov_17.050199_g6613_i0 | PRJEB10140 | 11855 | 2061 | 17.050199 | 351.40460139 | Invertebrate iridescent virus 6 | 176652 | Viruses | Viruses | 67.8 | 8.7e-9 | NR | QMS79707.1 | 176652 | g6613 | i0 | 34.5 | 0.126637554585153 | 87 | 56 | 12.7 | 1 | 207 | 467 | 31 | 116 | QMS79707.1 hypothetical protein IIV6-T1_193 [Invertebrate iridescent virus 6] | diamond | 261 | 67.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Iridoviridae | Iridovirus | Iridovirus chilo1 | ||
| 31796370 | 31796370 | PRJEB10140_P_NODE_197937_length_197_cov_1.054054_g180628_i0 | PRJEB10140 | 197937 | 197 | 1.054054 | 2.07648638 | root | 1 | Root_unresolved | Root_unresolved | 48.1 | 2.51e-4 | NR | YP_010841440.1 | 2811091 | g180628 | i0 | 41.8 | 2.43654822335025 | 55 | 32 | 83.8 | 0 | 12 | 176 | 143 | 197 | YP_010841440.1 putative ankyrin repeat protein [Cotonvirus japonicus] | diamond | 480 | 48.1 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Cotonvirus | Cotonvirus japonicum | ||
| 31802421 | 31802421 | PRJEB10140_P_NODE_199477_length_196_cov_0.761905_g182168_i0 | PRJEB10140 | 199477 | 196 | 0.761905 | 1.4933338 | Klosneuvirus KNV1 | 1977640 | Viruses | Viruses | 79 | 2.94e-15 | NR | ARF11985.1 | 1977640 | g182168 | i0 | 57.1 | 0.964285714285714 | 63 | 27 | 96.4 | 0 | 196 | 8 | 322 | 384 | ARF11985.1 hypothetical protein Klosneuvirus_3_120 [Klosneuvirus KNV1] | diamond | 189 | 79 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Klosneuvirus | Klosneuvirus KNV1 | ||
| 32087308 | 32087308 | PRJEB10140_P_NODE_12658_length_1989_cov_15.491237_g6613_i2 | PRJEB10140 | 12658 | 1989 | 15.491237 | 308.12070393 | Invertebrate iridescent virus 6 | 176652 | Viruses | Viruses | 67.8 | 8.33e-9 | NR | QMS79707.1 | 176652 | g6613 | i2 | 34.5 | 0.131221719457014 | 87 | 56 | 13.1 | 1 | 207 | 467 | 31 | 116 | QMS79707.1 hypothetical protein IIV6-T1_193 [Invertebrate iridescent virus 6] | diamond | 261 | 67.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Iridoviridae | Iridovirus | Iridovirus chilo1 |
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);;