contig_metadata
6 rows where bioproject = "PRJNA315314", tax_kingdom = "Pararnavirae" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1655544 | 1655544 | PRJNA315314_S_NODE_18322_length_192_cov_4581.717791_g18001_i0 | PRJNA315314 | 18322 | 192 | 4581.717791 | 8796.89815872 | Lentivirus pum | 3418653 | Viruses | Viruses | 73.1 | 1.27e-8 | NTclustered | gi|1817429831|gb|MN531141.1| | 12804 | g18001 | i0 | 95.652 | 22.5572916666667 | 46 | 1 | 23 | 1 | 148 | 192 | 3613 | 3658 | Puma lentivirus isolate x1432, partial genome | blastn | 4331 | 73.1 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Lentivirus | Lentivirus pum | ||
| 9993380 | 9993380 | PRJNA315314_S_NODE_13928_length_218_cov_3941.666667_g13607_i0 | PRJNA315314 | 13928 | 218 | 3941.666667 | 8592.83333406 | Viruses | 10239 | Viruses | Viruses | 71.3 | 5.32e-8 | NTclustered | gi|1817429831|gb|MN531141.1| | 12804 | g13607 | i0 | 97.561 | 20.0366972477064 | 41 | 1 | 19 | 0 | 178 | 218 | 3618 | 3658 | Puma lentivirus isolate x1432, partial genome | blastn | 4368 | 71.3 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Lentivirus | Lentivirus pum | ||
| 27010962 | 27010962 | PRJNA315314_S_NODE_11362_length_240_cov_10.943128_g11041_i0 | PRJNA315314 | 11362 | 240 | 10.943128 | 26.2635072 | Moloney murine leukemia virus | 11801 | Viruses | Viruses | 160 | 2.1099999999999998e-43 | NR | NP_057933.2 | 11801 | g11041 | i0 | 98.7 | 8.7625 | 78 | 1 | 97.5 | 0 | 7 | 240 | 658 | 735 | NP_057933.2 Pr180 [Moloney murine leukemia virus] | diamond | 2103 | 160 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 29586215 | 29586215 | PRJNA315314_S_NODE_10070_length_255_cov_4.269912_g9749_i0 | PRJNA315314 | 10070 | 255 | 4.269912 | 10.8882756 | Gammaretrovirus | 153135 | Viruses | Viruses | 160 | 1.83e-43 | NR | ABU54795.1 | 11786 | g9749 | i0 | 96.4 | 18.7764705882353 | 84 | 3 | 98.8 | 0 | 2 | 253 | 1210 | 1293 | ABU54795.1 gag-pro-pol polyprotein [Murine leukemia virus] | diamond | 4788 | 160 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 31830062 | 31830062 | PRJNA315314_S_NODE_1677_length_600_cov_11.984238_g1411_i0 | PRJNA315314 | 1677 | 600 | 11.984238 | 71.905428 | Gammaretrovirus | 153135 | Viruses | Viruses | 416 | 1.6499999999999999e-131 | NR | NP_057933.2 | 11801 | g1411 | i0 | 100 | 10 | 200 | 0 | 100 | 0 | 1 | 600 | 805 | 1004 | NP_057933.2 Pr180 [Moloney murine leukemia virus] | diamond | 6000 | 416 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 32477368 | 32477368 | PRJNA315314_S_NODE_2719_length_480_cov_8.356984_g2406_i0 | PRJNA315314 | 2719 | 480 | 8.356984 | 40.1135232 | Moloney murine leukemia virus | 11801 | Viruses | Viruses | 324 | 1.5599999999999995e-99 | NR | NP_057933.2 | 11801 | g2406 | i0 | 99.4 | 4.96875 | 159 | 1 | 99.4 | 0 | 479 | 3 | 1056 | 1214 | NP_057933.2 Pr180 [Moloney murine leukemia virus] | diamond | 2385 | 324 | 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);;