contig_metadata
7 rows where bioproject = "PRJNA734313" and tax_kingdom = "Pararnavirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5820308 | 5820308 | PRJNA734313_S_NODE_65_length_2170_cov_9.735280_g64_i0 | PRJNA734313 | 65 | 2170 | 9.73528 | 211.255576 | Moloney murine leukemia virus | 11801 | Viruses | Viruses | 1268 | 0 | NR | NP_057933.2 | 11801 | g64 | i0 | 97.5 | 2.67926267281106 | 646 | 16 | 89.3 | 0 | 2157 | 220 | 690 | 1335 | NP_057933.2 Pr180 [Moloney murine leukemia virus] | diamond | 5814 | 1268 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 27621220 | 27621220 | PRJNA734313_S_NODE_26044_length_181_cov_13.134328_g25931_i0 | PRJNA734313 | 26044 | 181 | 13.134328 | 23.77313368 | Spleen focus-forming virus | 11819 | Viruses | Viruses | 62.4 | 1.17e-10 | NR | CAA48763.1 | 11819 | g25931 | i0 | 82.5 | 0.662983425414365 | 40 | 7 | 66.3 | 0 | 2 | 121 | 74 | 113 | CAA48763.1 envelope glycoprotein, partial [Spleen focus-forming virus] | diamond | 120 | 62.4 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Spleen focus-forming virus | ||
| 28031660 | 28031660 | PRJNA734313_S_NODE_26045_length_181_cov_12.843284_g25932_i0 | PRJNA734313 | 26045 | 181 | 12.843284 | 23.24634404 | Spleen focus-forming virus | 11819 | Viruses | Viruses | 62.4 | 1.17e-10 | NR | CAA48763.1 | 11819 | g25932 | i0 | 82.5 | 0.662983425414365 | 40 | 7 | 66.3 | 0 | 2 | 121 | 74 | 113 | CAA48763.1 envelope glycoprotein, partial [Spleen focus-forming virus] | diamond | 120 | 62.4 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Spleen focus-forming virus | ||
| 28883957 | 28883957 | PRJNA734313_S_NODE_22688_length_195_cov_3.135135_g22575_i0 | PRJNA734313 | 22688 | 195 | 3.135135 | 6.11351325 | Spleen focus-forming virus | 11819 | Viruses | Viruses | 53.1 | 5.95e-7 | NR | CAA48763.1 | 11819 | g22575 | i0 | 85.7 | 0.430769230769231 | 28 | 4 | 43.1 | 0 | 87 | 4 | 19 | 46 | CAA48763.1 envelope glycoprotein, partial [Spleen focus-forming virus] | diamond | 84 | 53.1 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Spleen focus-forming virus | ||
| 29389388 | 29389388 | PRJNA734313_S_NODE_1809_length_539_cov_23.245935_g1704_i0 | PRJNA734313 | 1809 | 539 | 23.245935 | 125.29558965 | Spleen focus-forming virus | 11819 | Viruses | Viruses | 90.9 | 4.86e-20 | NR | CAA48763.1 | 11819 | g1704 | i0 | 83.2 | 0.528756957328386 | 95 | 16 | 52.9 | 0 | 296 | 12 | 19 | 113 | CAA48763.1 envelope glycoprotein, partial [Spleen focus-forming virus] | diamond | 285 | 90.9 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Spleen focus-forming virus | ||
| 30242071 | 30242071 | PRJNA734313_S_NODE_17092_length_226_cov_3.184358_g16979_i0 | PRJNA734313 | 17092 | 226 | 3.184358 | 7.19664908 | Spleen focus-forming virus | 11819 | Viruses | Viruses | 54.3 | 3.08e-7 | NR | CAA48763.1 | 11819 | g16979 | i0 | 88.7 | 0.823008849557522 | 62 | 7 | 82.3 | 0 | 40 | 225 | 19 | 80 | CAA48763.1 envelope glycoprotein, partial [Spleen focus-forming virus] | diamond | 186 | 54.3 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Spleen focus-forming virus | ||
| 32012273 | 32012273 | PRJNA734313_S_NODE_10018_length_296_cov_7.971888_g9905_i0 | PRJNA734313 | 10018 | 296 | 7.971888 | 23.59678848 | Spleen focus-forming virus | 11819 | Viruses | Viruses | 89.4 | 1.29e-20 | NR | CAA48763.1 | 11819 | g9905 | i0 | 82.1 | 0.962837837837838 | 95 | 17 | 96.3 | 0 | 1 | 285 | 19 | 113 | CAA48763.1 envelope glycoprotein, partial [Spleen focus-forming virus] | diamond | 285 | 89.4 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Spleen focus-forming virus |
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);;