RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA576995" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_kingdom 2

tax_superkingdom 1

  • Viruses · 6 ✖

bioproject 1

  • PRJNA576995 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
26763046 26763046 PRJNA576995_P_NODE_23201_length_316_cov_1.267490_g22609_i0 PRJNA576995 23201 316 1.26749 4.0052684 Hyperionvirus sp. 2487770 Viruses Viruses 53.9 1.04e-5   NR AYV83003.1 2487770 g22609 i0 32.6 0.901898734177215 95 63 90.2 1 287 3 96 189 AYV83003.1 MAG: MAC/perforin domain protein [Hyperionvirus sp.] diamond 285 53.9 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae   Hyperionvirus sp.
27851107 27851107 PRJNA576995_P_NODE_29604_length_280_cov_1.487923_g29012_i0 PRJNA576995 29604 280 1.487923 4.1661844 Tupanvirus 2094720 Viruses Viruses 77.4 3.26e-14   NR YP_010780137.1 2126984 g29012 i0 43.8 2.83928571428571 89 33 87.9 3 3 248 352 430 YP_010780137.1 hypothetical protein QJ856_gp1228 [Tupanvirus deep ocean] diamond 795 77.4 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae Tupanvirus Tupanvirus altamarinense
29826771 29826771 PRJNA576995_P_NODE_871_length_1548_cov_1.297627_g709_i0 PRJNA576995 871 1548 1.297627 20.08726596 Downy mildew lesion associated ormycovirus 6 3162774 Viruses Viruses 473 1.0799999999999998e-154   NR USW07198.1 3162774 g709 i0 46.4 0.994186046511628 513 269 98.4 4 23 1546 47 558 USW07198.1 putative RNA-dependent RNA polymerase [Downy mildew lesion associated ormycovirus 6] diamond 1539 473 1 Viruses               Downy mildew lesion associated ormycovirus 6
30237564 30237564 PRJNA576995_P_NODE_21992_length_323_cov_2.344000_g21400_i0 PRJNA576995 21992 323 2.344 7.57112 African cichlid piscichuvirus 3065075 Viruses Viruses 89 5.99e-18   NR WLN26256.1 3065075 g21400 i0 54.2 0.770897832817337 83 38 77.1 0 71 319 229 311 WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus] diamond 249 89 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Jingchuvirales Chuviridae Piscichuvirus African cichlid piscichuvirus
30837851 30837851 PRJNA576995_P_NODE_15154_length_385_cov_2.669872_g14562_i0 PRJNA576995 15154 385 2.669872 10.2790072 Hebei tick virus 12 3371291 Viruses Viruses 59.3 3.03e-7   NR XHY85231.1 3371291 g14562 i0 29.1 2.1974025974026 141 86 99 2 5 385 211 351 XHY85231.1 MAG: putative RNA-dependent RNA polymerase, partial [Hebei tick virus 12] diamond 846 59.3 1 Viruses               Hebei tick virus 12
32766122 32766122 PRJNA576995_P_NODE_22260_length_322_cov_1.132530_g21668_i0 PRJNA576995 22260 322 1.13253 3.6467466 Downy mildew lesion associated ormycovirus 6 3162774 Viruses Viruses 103 5.61e-23   NR USW07198.1 3162774 g21668 i0 45.1 0.950310559006211 102 56 95 0 3 308 597 698 USW07198.1 putative RNA-dependent RNA polymerase [Downy mildew lesion associated ormycovirus 6] diamond 306 103 1 Viruses               Downy mildew lesion associated ormycovirus 6

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