RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA876641" and tax_kingdom = "Pararnavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Pararnavirae · 5 ✖

bioproject 1

  • PRJNA876641 · 5 ✖

analysis 1

  • blastn · 5 ✖

tax_clade 0

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
853318 853318 PRJNA876641_P_NODE_3141_length_414_cov_8.293255_g3067_i0 PRJNA876641 3141 414 8.293255 34.3340757 Gammaretrovirus gibleu 3428953 Viruses Viruses 752 0   NTclustered gi|971888245|gb|KT724047.1| 11840 g3067 i0 99.517 76.9806763285024 414 1 100 1 1 414 8304 7892 Gibbon ape leukemia virus strain San Francisco, complete genome blastn 31870 752 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Gammaretrovirus Gammaretrovirus gibleu
3404104 3404104 PRJNA876641_P_NODE_7243_length_310_cov_1.299578_g7169_i0 PRJNA876641 7243 310 1.299578 4.0286918 Gammaretrovirus gibleu 3428953 Viruses Viruses 573 4.999999999999998e-159   NTclustered gi|971888245|gb|KT724047.1| 11840 g7169 i0 100 89.3516129032258 310 0 100 0 1 310 5948 5639 Gibbon ape leukemia virus strain San Francisco, complete genome blastn 27699 573 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Gammaretrovirus Gammaretrovirus gibleu
5956348 5956348 PRJNA876641_P_NODE_12425_length_268_cov_1.502564_g12351_i0 PRJNA876641 12425 268 1.502564 4.02687152 Gammaretrovirus gibleu 3428953 Viruses Viruses 484 2.0399999999999996e-132   NTclustered gi|971888245|gb|KT724047.1| 11840 g12351 i0 99.254 47.5932835820896 268 2 100 0 1 268 4086 4353 Gibbon ape leukemia virus strain San Francisco, complete genome blastn 12755 484 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Gammaretrovirus Gammaretrovirus gibleu
11056766 11056766 PRJNA876641_P_NODE_11789_length_272_cov_1.160804_g11715_i0 PRJNA876641 11789 272 1.160804 3.15738688 Gammaretrovirus gibleu 3428953 Viruses Viruses 503 5.729999999999998e-138   NTclustered gi|971888245|gb|KT724047.1| 11840 g11715 i0 100 87.5183823529412 272 0 100 0 1 272 5327 5598 Gibbon ape leukemia virus strain San Francisco, complete genome blastn 23805 503 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Gammaretrovirus Gammaretrovirus gibleu
11056886 11056886 PRJNA876641_P_NODE_19329_length_246_cov_1.508671_g19255_i0 PRJNA876641 19329 246 1.508671 3.71133066 Gammaretrovirus gibleu 3428953 Viruses Viruses 455 1.4500000000000002e-123   NTclustered gi|971888245|gb|KT724047.1| 11840 g19255 i0 100 24.9512195121951 246 0 100 0 1 246 7897 7652 Gibbon ape leukemia virus strain San Francisco, complete genome blastn 6138 455 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Gammaretrovirus Gammaretrovirus gibleu

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;