contig_metadata
7 rows where bioproject = "PRJEB17675" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7673907 | 7673907 | PRJEB17675_P_NODE_1827_length_725_cov_3.392754_g1608_i0 | PRJEB17675 | 1827 | 725 | 3.392754 | 24.5974665 | root | 1 | Root_unresolved | Root_unresolved | 179 | 2.91e-51 | NR | QFG73901.1 | 1737588 | g1608 | i0 | 44.6 | 3.66620689655172 | 222 | 113 | 91 | 5 | 711 | 52 | 114 | 327 | QFG73901.1 MAG: papain family cysteine protease [Megaviridae environmental sample] | diamond | 2658 | 180 | 0.994444444444444 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Megaviridae environmental sample | |||
| 9914009 | 9914009 | PRJEB17675_P_NODE_1368_length_834_cov_1.804756_g1184_i0 | PRJEB17675 | 1368 | 834 | 1.804756 | 15.05166504 | Mimivirus | 315393 | Viruses | Viruses | 58.4 | 0.002 | NTclustered | gi|55416625|gb|AY653733.1| | 212035 | g1184 | i0 | 100 | 0.557553956834532 | 31 | 0 | 4 | 0 | 346 | 376 | 88918 | 88948 | Acanthamoeba polyphaga mimivirus, complete genome | blastn | 465 | 58.4 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Mimivirus | Mimivirus bradfordmassiliense | ||
| 11189205 | 11189205 | PRJEB17675_P_NODE_25249_length_151_cov_1.034483_g24945_i0 | PRJEB17675 | 25249 | 151 | 1.034483 | 1.56206933 | Viruses | 10239 | Viruses | Viruses | 54.7 | 0.003 | NTclustered | gi|1774766378|gb|MN582059.1| | 2656707 | g24945 | i0 | 100 | 0.384105960264901 | 29 | 0 | 19 | 0 | 105 | 133 | 9378 | 9350 | MAG: Podoviridae sp. ct2cs2, complete genome | blastn | 58 | 54.7 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Podoviridae sp. ct2cs2 | |||||
| 26969759 | 26969759 | PRJEB17675_P_NODE_3022_length_567_cov_2.392857_g2753_i0 | PRJEB17675 | 3022 | 567 | 2.392857 | 13.56749919 | Fadolivirus algeromassiliense | 3060017 | Viruses | Viruses | 208 | 3.46e-62 | NR | YP_010803269.1 | 3060017 | g2753 | i0 | 60.1 | 0.862433862433862 | 163 | 65 | 86.2 | 0 | 566 | 78 | 252 | 414 | YP_010803269.1 ornithine decaroboxylase [Fadolivirus algeromassiliense] | diamond | 489 | 208 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Fadolivirus | Fadolivirus algeromassiliense | ||
| 27917482 | 27917482 | PRJEB17675_P_NODE_22085_length_163_cov_1.562500_g21781_i0 | PRJEB17675 | 22085 | 163 | 1.5625 | 2.546875 | Bodo saltans virus | 2024608 | Viruses | Viruses | 43.9 | 0.00498 | NR | YP_010778165.1 | 2024608 | g21781 | i0 | 37.5 | 1.03067484662577 | 56 | 33 | 99.4 | 1 | 163 | 2 | 54 | 109 | YP_010778165.1 serine/threonine-protein phosphatase [Bodo saltans virus] | diamond | 168 | 43.9 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Theiavirus | Theiavirus salishense | ||
| 28580779 | 28580779 | PRJEB17675_P_NODE_23787_length_156_cov_1.380165_g23483_i0 | PRJEB17675 | 23787 | 156 | 1.380165 | 2.1530574 | Penicillium spinulosum metavirus 1 | 1755795 | Viruses | Viruses | 60.1 | 8.34e-9 | NR | ALO50153.1 | 1755795 | g23483 | i0 | 52 | 0.961538461538462 | 50 | 24 | 96.2 | 0 | 154 | 5 | 31 | 80 | ALO50153.1 ORF1 [Penicillium spinulosum metavirus 1] | diamond | 150 | 60.1 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Metaviridae | Penicillium spinulosum metavirus 1 | |||
| 29938488 | 29938488 | PRJEB17675_P_NODE_14871_length_211_cov_1.335227_g14567_i0 | PRJEB17675 | 14871 | 211 | 1.335227 | 2.81732897 | Homavirus sp. | 2487769 | Viruses | Viruses | 75.1 | 6.04e-14 | NR | AYV82419.1 | 2487769 | g14567 | i0 | 46.4 | 0.981042654028436 | 69 | 37 | 98.1 | 0 | 210 | 4 | 254 | 322 | AYV82419.1 MAG: elongation factor 1-alpha-like protein [Homavirus sp.] | diamond | 207 | 75.1 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Homavirus sp. |
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);;