contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJNA556842" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2399577 | 2399577 | PRJNA556842_P_NODE_5922_length_365_cov_1.746951_g5423_i0 | PRJNA556842 | 5922 | 365 | 1.746951 | 6.37637115 | Gammaretrovirus | 153135 | Viruses | Viruses | 619 | 7.569999999999999e-173 | NTclustered | gi|331934|gb|J02255.1|MLMCG | 11786 | g5423 | i0 | 97.26 | 90.9095890410959 | 365 | 10 | 100 | 0 | 1 | 365 | 4264 | 4628 | Moloney murine leukemia virus, complete genome | blastn | 33182 | 619 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 3675486 | 3675486 | PRJNA556842_P_NODE_4623_length_432_cov_3.027848_g4127_i0 | PRJNA556842 | 4623 | 432 | 3.027848 | 13.08030336 | root | 1 | Root_unresolved | Root_unresolved | 590 | 7.15e-164 | NTclustered | gi|331934|gb|J02255.1|MLMCG | 11786 | g4127 | i0 | 99.085 | 76.0231481481482 | 328 | 3 | 76 | 0 | 2 | 329 | 2923 | 2596 | Moloney murine leukemia virus, complete genome | blastn | 32842 | 590 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 12000745 | 12000745 | PRJNA556842_P_NODE_6630_length_336_cov_2.060201_g6127_i0 | PRJNA556842 | 6630 | 336 | 2.060201 | 6.92227536 | Gammaretrovirus murleu | 3428959 | Viruses | Viruses | 560 | 4.26e-155 | NTclustered | gi|18448741|gb|AF462057.1| | 11801 | g6127 | i0 | 96.726 | 99.8839285714286 | 336 | 11 | 100 | 0 | 1 | 336 | 3257 | 2922 | Moloney murine leukemia virus neuropathogenic variant ts1-92b, complete genome | blastn | 33561 | 560 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 15824555 | 15824555 | PRJNA556842_P_NODE_6633_length_336_cov_1.799331_g6130_i0 | PRJNA556842 | 6633 | 336 | 1.799331 | 6.04575216 | Gammaretrovirus murleu | 3428959 | Viruses | Viruses | 566 | 9.159999999999997e-157 | NTclustered | gi|18448741|gb|AF462057.1| | 11801 | g6130 | i0 | 97.024 | 99.9821428571429 | 336 | 10 | 100 | 0 | 1 | 336 | 3334 | 3669 | Moloney murine leukemia virus neuropathogenic variant ts1-92b, complete genome | blastn | 33594 | 566 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 18373545 | 18373545 | PRJNA556842_P_NODE_14075_length_181_cov_2.493056_g13570_i0 | PRJNA556842 | 14075 | 181 | 2.493056 | 4.51243136 | Gammaretrovirus murleu | 3428959 | Viruses | Viruses | 324 | 2.95e-84 | NTclustered | gi|18448741|gb|AF462057.1| | 11801 | g13570 | i0 | 98.895 | 69.7458563535912 | 181 | 2 | 100 | 0 | 1 | 181 | 3914 | 4094 | Moloney murine leukemia virus neuropathogenic variant ts1-92b, complete genome | blastn | 12624 | 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);;