RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA704949", tax_phylum = "Preplasmiviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 4 ✖

tax_phylum 1

  • Preplasmiviricota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA704949 · 4 ✖

analysis 1

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
26703430 26703430 PRJNA704949_P_NODE_867801_length_284_cov_1.285106_g852467_i0 PRJNA704949 867801 284 1.285106 3.64970104 Lake Baikal virophage 16 3086121 Viruses Viruses 47.8 0.00102   NR WPF46888.1 3086121 g852467 i0 30.2 2.72535211267606 86 56 90.8 2 25 282 120 201 WPF46888.1 MAG: hypothetical protein [Lake Baikal virophage 16] diamond 774 47.8 1 Viruses   Bamfordvirae Preplasmiviricota Virophaviricetes Priklausovirales Lavidaviridae   Lake Baikal virophage 16
26766596 26766596 PRJNA704949_P_NODE_1619501_length_191_cov_1.464789_g1604162_i0 PRJNA704949 1619501 191 1.464789 2.79774699 Astyanax tetra cavefish adintovirus 2609866 Viruses Viruses 54.3 1.99e-7   NR DAC81315.1 2609866 g1604162 i0 58.3 0.753926701570681 48 18 72.3 1 49 186 1 48 DAC81315.1 TPA_asm: gasderminX [Larimichthys croaker adintovirus] diamond 144 54.3 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Astyanax tetra cavefish adintovirus
28125388 28125388 PRJNA704949_P_NODE_1767365_length_180_cov_1.190840_g1752026_i0 PRJNA704949 1767365 180 1.19084 2.143512 Megastigmus wasp adintovirus 2609859 Viruses Viruses 62 1.84e-9   NR DAC81337.1 2609859 g1752026 i0 56 3.21666666666667 50 22 83.3 0 180 31 80 129 DAC81337.1 TPA_asm: PLA2X [Megastigmus wasp adintovirus] diamond 579 62 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Megastigmus wasp adintovirus
30431177 30431177 PRJNA704949_P_NODE_2159533_length_162_cov_1.380531_g2144194_i0 PRJNA704949 2159533 162 1.380531 2.23646022 Thermus phage phiKo 2301535 Viruses Viruses 47.8 1.6e-5   NR AYJ74692.1 2301535 g2144194 i0 79.3 1.07407407407407 29 6 53.7 0 162 76 8 36 AYJ74692.1 ribonuclease Z [Thermus phage phiKo] diamond 174 47.8 1 Viruses   Bamfordvirae Preplasmiviricota Tectiliviricetes Kalamavirales Tectiviridae   Thermus phage phiKo

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