contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA975724" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 946609 | 946609 | PRJNA975724_S_NODE_581_length_944_cov_8.104478_g483_i0 | PRJNA975724 | 581 | 944 | 8.104478 | 76.50627232 | Moloney murine leukemia virus | 11801 | Viruses | Viruses | 537 | 1.1299999999999998e-174 | NR | NP_057933.2 | 11801 | g483 | i0 | 97.5 | 0.883474576271186 | 278 | 7 | 88.3 | 0 | 2 | 835 | 1058 | 1335 | NP_057933.2 Pr180 [Moloney murine leukemia virus] | diamond | 834 | 537 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 13699562 | 13699562 | PRJNA975724_S_NODE_31_length_2426_cov_36.446239_g28_i0 | PRJNA975724 | 31 | 2426 | 36.446239 | 884.18575814 | Sopawar virus | 3131855 | Viruses | Viruses | 91.7 | 7.58e-15 | NR | WZH62023.1 | 3131855 | g28 | i0 | 28.2 | 0.946001648804617 | 291 | 196 | 35.9 | 5 | 897 | 1766 | 260 | 538 | WZH62023.1 MAG: RNA-dependent RNA polymerase [Sopawar virus] | diamond | 2295 | 91.7 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Sopawar virus | |||
| 16248336 | 16248336 | PRJNA975724_S_NODE_15133_length_412_cov_2.648968_g14952_i0 | PRJNA975724 | 15133 | 412 | 2.648968 | 10.91374816 | Viruses | 10239 | Viruses | Viruses | 208 | 2.96e-63 | NR | XOE99880.1 | 2202644 | g14952 | i0 | 68.1 | 2.00242718446602 | 138 | 43 | 99.8 | 1 | 2 | 412 | 201 | 338 | XOE99880.1 MAG: replication initiation protein [Microviridae sp.] | diamond | 825 | 208 | 1 | Viruses | Sangervirae | Phixviricota | Malgrandaviricetes | Petitvirales | Microviridae | Microviridae sp. | |||
| 28225927 | 28225927 | PRJNA975724_S_NODE_54506_length_289_cov_0.675926_g54325_i0 | PRJNA975724 | 54506 | 289 | 0.675926 | 1.95342614 | Escherichia phage Copypasta | 3096133 | Viruses | Viruses | 60.5 | 6.54e-10 | NR | WPH57058.1 | 3096133 | g54325 | i0 | 63.5 | 0.934256055363322 | 52 | 19 | 54 | 0 | 94 | 249 | 1 | 52 | WPH57058.1 hypothetical protein Copypasta_CDS0011 [Escherichia phage Copypasta] | diamond | 270 | 60.5 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Escherichia phage Copypasta | |||
| 29078863 | 29078863 | PRJNA975724_S_NODE_91788_length_241_cov_0.880952_g91607_i0 | PRJNA975724 | 91788 | 241 | 0.880952 | 2.12309432 | Escherichia phage Copypasta | 3096133 | Viruses | Viruses | 55.5 | 3.5e-8 | NR | WPH57058.1 | 3096133 | g91607 | i0 | 60 | 0.622406639004149 | 50 | 20 | 62.2 | 0 | 181 | 32 | 1 | 50 | WPH57058.1 hypothetical protein Copypasta_CDS0011 [Escherichia phage Copypasta] | diamond | 150 | 55.5 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Escherichia phage Copypasta | |||
| 30247403 | 30247403 | PRJNA975724_S_NODE_8392_length_467_cov_6.862944_g8211_i0 | PRJNA975724 | 8392 | 467 | 6.862944 | 32.04994848 | Solumvirus sp. | 2487773 | Viruses | Viruses | 49.3 | 0.00109 | NR | AYV86227.1 | 2487773 | g8211 | i0 | 92.3 | 0.167023554603854 | 26 | 2 | 16.7 | 0 | 467 | 390 | 159 | 184 | AYV86227.1 MAG: hypothetical protein Solumvirus2_34 [Solumvirus sp.] | diamond | 78 | 49.3 | 1 | Viruses | Pithoviruses | Solumvirus sp. | |||||||
| 30437050 | 30437050 | PRJNA975724_S_NODE_75013_length_255_cov_2.538462_g74832_i0 | PRJNA975724 | 75013 | 255 | 2.538462 | 6.4730781 | Phytophthora cinnamomi ormycovirus 2-25 | 3239321 | Viruses | Viruses | 55.1 | 2.03e-6 | NR | XDO01615.1 | 3239321 | g74832 | i0 | 37 | 0.952941176470588 | 81 | 50 | 95.3 | 1 | 1 | 243 | 562 | 641 | XDO01615.1 RNA-dependent RNA polymerase [Phytophthora cinnamomi ormycovirus 2-25] | diamond | 243 | 55.1 | 1 | Viruses | Orthornavirae | Orpoviricetes | Bormycovirales | Deltanormycoviridae | Bormycovirus | Bormycovirus duphytophthorae | |||
| 31037375 | 31037375 | PRJNA975724_S_NODE_22375_length_376_cov_0.963696_g22194_i0 | PRJNA975724 | 22375 | 376 | 0.963696 | 3.62349696 | Escherichia phage Copypasta | 3096133 | Viruses | Viruses | 78.2 | 1.86e-16 | NR | WPH57058.1 | 3096133 | g22194 | i0 | 71.2 | 0.414893617021277 | 52 | 15 | 41.5 | 0 | 181 | 336 | 1 | 52 | WPH57058.1 hypothetical protein Copypasta_CDS0011 [Escherichia phage Copypasta] | diamond | 156 | 78.2 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Inoviridae | Escherichia phage Copypasta | |||
| 31922525 | 31922525 | PRJNA975724_S_NODE_517_length_979_cov_7.325607_g426_i0 | PRJNA975724 | 517 | 979 | 7.325607 | 71.71769253 | Gammaretrovirus murleu | 3428959 | Viruses | Viruses | 650 | 1.1299999999999996e-232 | NR | 8WUS_E | 11801 | g426 | i0 | 99.1 | 7.82022471910112 | 319 | 3 | 97.8 | 0 | 977 | 21 | 28 | 346 | 8WUS_E Chain E, Gag-Pol polyprotein [Moloney murine leukemia virus] | diamond | 7656 | 650 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu |
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);;