contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJNA795663" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4607909 | 4607909 | PRJNA795663_S_NODE_7384_length_219_cov_3.543956_g7279_i0 | PRJNA795663 | 7384 | 219 | 3.543956 | 7.76126364 | Gammaretrovirus murleu | 3428959 | Viruses | Viruses | 388 | 1.3e-103 | NTclustered | gi|1167936572|gb|KY574505.1| | 11786 | g7279 | i0 | 98.63 | 99.8904109589041 | 219 | 3 | 100 | 0 | 1 | 219 | 5667 | 5449 | Murine leukemia virus isolate AKR-L3, complete genome | blastn | 21876 | 388 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 14807877 | 14807877 | PRJNA795663_S_NODE_13072_length_173_cov_2.514706_g12967_i0 | PRJNA795663 | 13072 | 173 | 2.514706 | 4.35044138 | Gammaretrovirus murleu | 3428959 | Viruses | Viruses | 315 | 1.68e-81 | NTclustered | gi|1167936811|gb|KY574513.1| | 11786 | g12967 | i0 | 99.422 | 99.5086705202312 | 173 | 1 | 100 | 0 | 1 | 173 | 6520 | 6348 | Murine leukemia virus isolate C58v2-MCF, complete genome | blastn | 17215 | 315 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 22456514 | 22456514 | PRJNA795663_S_NODE_16798_length_157_cov_1.341667_g16693_i0 | PRJNA795663 | 16798 | 157 | 1.341667 | 2.10641719 | Gammaretrovirus murleu | 3428959 | Viruses | Viruses | 285 | 1.17e-72 | NTclustered | gi|336462523|gb|JF908817.1| | 11837 | g16693 | i0 | 99.363 | 100 | 157 | 1 | 100 | 0 | 1 | 157 | 3935 | 4091 | Xenotropic murine leukemia virus isolate EKVX, partial genome | blastn | 15700 | 285 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 23732108 | 23732108 | PRJNA795663_S_NODE_12559_length_176_cov_1.964029_g12454_i0 | PRJNA795663 | 12559 | 176 | 1.964029 | 3.45669104 | Gammaretrovirus murleu | 3428959 | Viruses | Viruses | 315 | 1.7199999999999996e-81 | NTclustered | gi|996271182|gb|KU324806.1| | 11786 | g12454 | i0 | 98.864 | 100 | 176 | 2 | 100 | 0 | 1 | 176 | 2033 | 2208 | Murine leukemia virus isolate Kyushu, complete genome | blastn | 17600 | 315 | 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);;