RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA940501" and tax_kingdom = "Pararnavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Pararnavirae · 7 ✖

bioproject 1

  • PRJNA940501 · 7 ✖

analysis 1

  • diamond · 7 ✖

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
16222440 16222440 PRJNA940501_S_NODE_2293_length_2191_cov_91.374302_g2155_i0 PRJNA940501 2293 2191 91.374302 2002.01095682 Moloney murine leukemia virus 11801 Viruses Viruses 1294 0   NR NP_057933.2 11801 g2155 i0 97.6 2.70698311273391 659 16 90.2 0 143 2119 677 1335 NP_057933.2 Pr180 [Moloney murine leukemia virus] diamond 5931 1294 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Gammaretrovirus Gammaretrovirus murleu
27972788 27972788 PRJNA940501_S_NODE_153605_length_210_cov_1.275449_g152787_i0 PRJNA940501 153605 210 1.275449 2.6784429 Marsupial endogenous gammaretrovirus 2 3386030 Viruses Viruses 67 6.93e-11   NR DBA62711.1 3386030 g152787 i0 73.2 1.18571428571429 41 11 58.6 0 10 132 177 217 DBA62711.1 TPA_asm: Pol [Marsupial endogenous gammaretrovirus 2] diamond 249 67 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Gammaretrovirus Marsupial endogenous gammaretrovirus 2
30183166 30183166 PRJNA940501_S_NODE_287312_length_170_cov_1.173228_g286494_i0 PRJNA940501 287312 170 1.173228 1.9944876 Marsupial endogenous betaretrovirus 5 3386028 Viruses Viruses 68.9 7.95e-12   NR DBA62705.1 3386028 g286494 i0 57.7 7.44705882352941 52 22 91.8 0 6 161 638 689 DBA62705.1 TPA_asm: Pol [Marsupial endogenous betaretrovirus 5] diamond 1266 68.9 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Betaretrovirus Marsupial endogenous betaretrovirus 5
31036559 31036559 PRJNA940501_S_NODE_296755_length_168_cov_1.128000_g295937_i0 PRJNA940501 296755 168 1.128 1.89504 Retroviridae sp. 2681591 Viruses Viruses 43.1 0.0099   NR XNT20491.1 2681591 g295937 i0 43.9 0.732142857142857 41 23 73.2 0 32 154 536 576 XNT20491.1 MAG: hypothetical protein, partial [Retroviridae sp.] diamond 123 43.1 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae   Retroviridae sp.
31068047 31068047 PRJNA940501_S_NODE_341995_length_159_cov_1.215517_g341177_i0 PRJNA940501 341995 159 1.215517 1.93267203 Marsupial endogenous gammaretrovirus 2 3386030 Viruses Viruses 65.1 1.52e-10   NR DBA62711.1 3386030 g341177 i0 61.1 5.09433962264151 54 18 96.2 1 155 3 901 954 DBA62711.1 TPA_asm: Pol [Marsupial endogenous gammaretrovirus 2] diamond 810 65.1 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Gammaretrovirus Marsupial endogenous gammaretrovirus 2
31193873 31193873 PRJNA940501_S_NODE_57535_length_275_cov_1.801724_g56717_i0 PRJNA940501 57535 275 1.801724 4.954741 Walleye epidermal hyperplasia virus 1 64462 Viruses Viruses 51.2 5.82e-5   NR AAD30048.1 64462 g56717 i0 55.6 2.19272727272727 45 19 48 1 64 195 690 734 AAD30048.1 pol polyprotein, partial [Walleye epidermal hyperplasia virus 1] diamond 603 51.2 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Epsilonretrovirus Epsilonretrovirus walepihyp1
31700339 31700339 PRJNA940501_S_NODE_333797_length_160_cov_2.410256_g332979_i0 PRJNA940501 333797 160 2.410256 3.8564096 Marsupial endogenous gammaretrovirus 2 3386030 Viruses Viruses 51.6 9.04e-6   NR DBA62710.1 3386030 g332979 i0 53.1 0.91875 49 23 91.9 0 151 5 430 478 DBA62710.1 TPA_asm: Gag [Marsupial endogenous gammaretrovirus 2] diamond 147 51.6 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Gammaretrovirus Marsupial endogenous gammaretrovirus 2

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