RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA1233465" and tax_kingdom = "Pararnavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Pararnavirae · 6 ✖

bioproject 1

  • PRJNA1233465 · 6 ✖

analysis 1

  • diamond · 6 ✖
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
32916801 32916801 PRJNA1233465f_S_NODE_174945_length_188_cov_1.258993_g172665_i0 PRJNA1233465 174945 188 1.258993 2.36690684 Physostegia virginiana caulimovirus 2 3075964 Viruses Viruses 45.4 0.00201   NR WNH14479.1 3075964 g172665 i0 53.7 0.654255319148936 41 19 65.4 0 51 173 610 650 WNH14479.1 reverse transcriptase [Physostegia virginiana caulimovirus 2] diamond 123 45.4 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Caulimoviridae Caulimovirus Physostegia virginiana caulimovirus 2
32966877 32966877 PRJNA1233465b_S_NODE_371898_length_161_cov_0.910714_g370213_i0 PRJNA1233465 371898 161 0.910714 1.46624954 Galidia ERV 1400255 Viruses Viruses 91.7 6.46e-20   NR AGV92852.1 1400255 g370213 i0 80.8 0.968944099378882 52 10 96.9 0 158 3 318 369 AGV92852.1 gag protein [Galidia ERV] diamond 156 91.7 1 Viruses Reticuloendotheliosis virus group Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Gammaretrovirus Galidia ERV
33008959 33008959 PRJNA1233465b_S_NODE_124115_length_254_cov_1.380488_g122430_i0 PRJNA1233465 124115 254 1.380488 3.50643952 Viruses 10239 Viruses Viruses 94.7 2.2e-20   NR AAN77285.1 201996 g122430 i0 55.6 1.91338582677165 81 36 95.7 0 248 6 236 316 AAN77285.1 Gag-Pro-Pol protein, partial [Python curtus endogenous retrovirus] diamond 486 94.7 1 Viruses sauropsid retroviruses Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae   Python curtus endogenous retrovirus
33060176 33060176 PRJNA1233465b_S_NODE_37117_length_390_cov_5.785924_g35437_i0 PRJNA1233465 37117 390 5.785924 22.5651036 Gammaretrovirus 153135 Viruses Viruses 243 1.77e-71   NR NP_057933.2 11801 g35437 i0 98.4 1.98461538461538 129 2 99.2 0 3 389 1195 1323 NP_057933.2 Pr180 [Moloney murine leukemia virus] diamond 774 243 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Gammaretrovirus Gammaretrovirus murleu
33068773 33068773 PRJNA1233465b_S_NODE_249965_length_190_cov_1.460993_g248280_i0 PRJNA1233465 249965 190 1.460993 2.7758867 Marsupial endogenous betaretrovirus 5 3386028 Viruses Viruses 57.8 9.22e-8   NR DBA62703.1 3386028 g248280 i0 54.9 0.805263157894737 51 23 80.5 0 23 175 342 392 DBA62703.1 TPA_asm: Gag [Marsupial endogenous betaretrovirus 5] diamond 153 57.8 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Betaretrovirus Marsupial endogenous betaretrovirus 5
33170593 33170593 PRJNA1233465a_S_NODE_178776_length_182_cov_0.902256_g177502_i0 PRJNA1233465 178776 182 0.902256 1.64210592 Marsupial endogenous betaretrovirus 5 3386028 Viruses Viruses 51.2 1.67e-5   NR DBA62703.1 3386028 g177502 i0 53.3 0.741758241758242 45 21 74.2 0 138 4 285 329 DBA62703.1 TPA_asm: Gag [Marsupial endogenous betaretrovirus 5] diamond 135 51.2 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Betaretrovirus Marsupial endogenous betaretrovirus 5

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