RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJEB14664" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_kingdom 2

tax_superkingdom 1

  • Viruses · 7 ✖

tax_clade 1

bioproject 1

  • PRJEB14664 · 7 ✖

analysis 1

  • diamond · 7 ✖
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
1295426 1295426 PRJEB14664_P_NODE_2_length_9077_cov_27.573877_g1_i0 PRJEB14664 2 9077 27.573877 2502.88081529 Maanshan Dicis tick virus 1 2972097 Viruses Viruses 846 3.18e-261   NR UYL95314.1 2972097 g1 i0 32.7 5.34229370937534 1821 965 58.1 36 440 5710 108 1731 UYL95314.1 MAG: replicase polyprotein [Maanshan Dicis tick virus 1] diamond 48492 846 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Maanshan Dicis tick virus 1
14049272 14049272 PRJEB14664_P_NODE_12232_length_210_cov_1.371429_g12102_i0 PRJEB14664 12232 210 1.371429 2.8800009 Solumvirus sp. 2487773 Viruses Viruses 110 5.06e-28   NR AYV86227.1 2487773 g12102 i0 86.7 0.857142857142857 60 8 85.7 0 210 31 125 184 AYV86227.1 MAG: hypothetical protein Solumvirus2_34 [Solumvirus sp.] diamond 180 110 1 Viruses Pithoviruses             Solumvirus sp.
29237374 29237374 PRJEB14664_P_NODE_13649_length_195_cov_1.087500_g13519_i0 PRJEB14664 13649 195 1.0875 2.120625 Viruses 10239 Viruses Viruses 48.5 1.84e-4   NR YP_001686789.1 425010 g13519 i0 46.8 4.47692307692308 47 25 72.3 0 7 147 428 474 YP_001686789.1 RNA-dependent RNA polymerase [Botryotinia fuckeliana partitivirus 1] diamond 873 48.9 0.991820040899796 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae   Botryotinia fuckeliana partitivirus 1
30728103 30728103 PRJEB14664_P_NODE_13334_length_198_cov_1.226994_g13204_i0 PRJEB14664 13334 198 1.226994 2.42944812 Dishui Lake phycodnavirus 3 2704074 Viruses Viruses 72 8.64e-13   NR QIG59731.1 2704074 g13204 i0 63 0.696969696969697 46 17 69.7 0 60 197 39 84 QIG59731.1 ornithine decarboxylase [Dishui Lake phycodnavirus 3] diamond 138 72 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Algavirales Phycodnaviridae Prasinovirus Dishui Lake phycodnavirus 3
31771403 31771403 PRJEB14664_P_NODE_9257_length_255_cov_1.781818_g9127_i0 PRJEB14664 9257 255 1.781818 4.5436359 Homavirus sp. 2487769 Viruses Viruses 129 2.22e-34   NR AYV82419.1 2487769 g9127 i0 67.1 1.98823529411765 85 27 98.8 1 253 2 79 163 AYV82419.1 MAG: elongation factor 1-alpha-like protein [Homavirus sp.] diamond 507 129 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae   Homavirus sp.
31834520 31834520 PRJEB14664_P_NODE_9037_length_259_cov_4.816964_g8907_i0 PRJEB14664 9037 259 4.816964 12.47593676 Terrestrivirus sp. 2487775 Viruses Viruses 45.1 0.00178   NR AYV76392.1 2487775 g8907 i0 52.2 0.532818532818533 46 21 53.3 1 223 86 1 45 AYV76392.1 MAG: hypothetical protein Terrestrivirus6_18 [Terrestrivirus sp.] diamond 138 45.1 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae   Terrestrivirus sp.
32625286 32625286 PRJEB14664_P_NODE_13340_length_198_cov_0.981595_g13210_i0 PRJEB14664 13340 198 0.981595 1.9435581 Macrobrachium rosenbergii picorna-like virus 4 3132542 Viruses Viruses 84.7 3.45e-17   NR WWZ85593.1 3132542 g13210 i0 53 1 66 31 100 0 1 198 2768 2833 WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4] diamond 198 84.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Macrobrachium rosenbergii picorna-like virus 4

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