RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA1078753" and tax_kingdom = "Pararnavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Pararnavirae · 4 ✖

bioproject 1

  • PRJNA1078753 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
6120031 6120031 PRJNA1078753_P_NODE_19025_length_282_cov_6.277512_g18829_i0 PRJNA1078753 19025 282 6.277512 17.70258384 Gammaretrovirus 153135 Viruses Viruses 516 7.67e-142   NTclustered gi|331934|gb|J02255.1|MLMCG 11786 g18829 i0 99.645 98.3156028368794 282 1 100 0 1 282 5368 5087 Moloney murine leukemia virus, complete genome blastn 27725 516 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Gammaretrovirus Gammaretrovirus murleu
8670117 8670117 PRJNA1078753_P_NODE_26487_length_252_cov_2.055866_g26291_i0 PRJNA1078753 26487 252 2.055866 5.18078232 root 1 Root_unresolved Root_unresolved 460 3.2e-125   NTclustered gi|331934|gb|J02255.1|MLMCG 11786 g26291 i0 99.603 98.5555555555556 252 1 100 0 1 252 2418 2167 Moloney murine leukemia virus, complete genome blastn 24836 460 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Gammaretrovirus Gammaretrovirus murleu
11220297 11220297 PRJNA1078753_P_NODE_17009_length_291_cov_3.564220_g16813_i0 PRJNA1078753 17009 291 3.56422 10.3718802 root 1 Root_unresolved Root_unresolved 516 7.95e-142   NTclustered gi|331934|gb|J02255.1|MLMCG 11786 g16813 i0 98.625 74.2680412371134 291 4 100 0 1 291 1654 1364 Moloney murine leukemia virus, complete genome blastn 21612 516 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Gammaretrovirus Gammaretrovirus murleu
18868586 18868586 PRJNA1078753_P_NODE_37595_length_244_cov_2.040936_g37399_i0 PRJNA1078753 37595 244 2.040936 4.97988384 root 1 Root_unresolved Root_unresolved 446 8.639999999999999e-121   NTclustered gi|996270715|gb|KU324804.1| 11786 g37399 i0 99.59 100.385245901639 244 1 100 0 1 244 699 456 Murine leukemia virus isolate Cz524, complete genome blastn 24494 446 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Retroviridae Gammaretrovirus Gammaretrovirus murleu

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