RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA812715" and tax_phylum = "Preplasmiviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Preplasmiviricota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA812715 · 4 ✖

analysis 1

  • diamond · 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
28002036 28002036 PRJNA812715_P_NODE_16585_length_882_cov_2.184178_g15101_i0 PRJNA812715 16585 882 2.184178 19.26444996 Pimephales minnow adintovirus 2609864 Viruses Viruses 89.7 6.85e-17   NR DAC81404.1 2609864 g15101 i0 30.8 1.47959183673469 169 115 56.8 2 330 830 17 185 DAC81404.1 TPA_asm: hypothetical protein [Pimephales minnow adintovirus] diamond 1305 90.5 0.991160220994475 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Pimephales minnow adintovirus
28159995 28159995 PRJNA812715_P_NODE_99345_length_254_cov_1.690608_g97544_i0 PRJNA812715 99345 254 1.6906080000000001 4.29414432 Adintovirus androctonus13 3115887 Viruses Viruses 109 1.24e-27   NR DBA46914.1 3115887 g97544 i0 65 0.94488188976378 80 27 94.5 1 242 3 1 79 DBA46914.1 MAG TPA_asm: PacK [Adintovirus androctonus13035] diamond 240 109 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus androctonus13035
28728111 28728111 PRJNA812715_P_NODE_14567_length_975_cov_4.294900_g13176_i0 PRJNA812715 14567 975 4.2949 41.875275 Pimephales minnow adintovirus 2609864 Viruses Viruses 61.6 8.15e-7   NR DAC81404.1 2609864 g13176 i0 28.6 1.26769230769231 119 84 36.3 1 36 389 17 135 DAC81404.1 TPA_asm: hypothetical protein [Pimephales minnow adintovirus] diamond 1236 61.6 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Pimephales minnow adintovirus
29864736 29864736 PRJNA812715_P_NODE_14671_length_970_cov_4.031215_g13176_i1 PRJNA812715 14671 970 4.031215 39.1027855 Pimephales minnow adintovirus 2609864 Viruses Viruses 60.8 1.47e-6   NR DAC81404.1 2609864 g13176 i1 28.4 0.64639175257732 116 82 35.6 1 40 384 20 135 DAC81404.1 TPA_asm: hypothetical protein [Pimephales minnow adintovirus] diamond 627 60.8 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Pimephales minnow adintovirus

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