RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA1059246" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1059246 · 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
27066900 27066900 PRJNA1059246_P_NODE_47902_length_298_cov_1.720000_g47276_i0 PRJNA1059246 47902 298 1.72 5.1256 Soybean thrips partiti-like virus 1 2801003 Viruses Viruses 54.7 4.49e-6   NR QQO81406.1 2801004 g47276 i0 33.3 0.724832214765101 72 48 72.5 0 249 34 398 469 QQO81406.1 RNA-dependent RNA polymerase, partial [Soybean thrips partiti-like virus 10] diamond 216 54.7 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae   Soybean thrips partiti-like virus 10
27414907 27414907 PRJNA1059246_P_NODE_24103_length_457_cov_1.234375_g23479_i0 PRJNA1059246 24103 457 1.234375 5.64109375 Abutilon theophrasti picorna-like virus 2739846 Viruses Viruses 130 9.31e-32   NR QKK82958.1 2739846 g23479 i0 47.3 0.971553610503282 148 74 96.5 2 454 14 1700 1844 QKK82958.1 hypothetical protein, partial [Abutilon theophrasti picorna-like virus] diamond 444 130 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Abutilon theophrasti picorna-like virus
27635806 27635806 PRJNA1059246_P_NODE_41224_length_330_cov_1.684825_g40598_i0 PRJNA1059246 41224 330 1.684825 5.5599225 Abutilon theophrasti picorna-like virus 2739846 Viruses Viruses 55.1 5.04e-6   NR QKK82958.1 2739846 g40598 i0 32.4 0.954545454545455 105 63 94.5 2 3 314 1461 1558 QKK82958.1 hypothetical protein, partial [Abutilon theophrasti picorna-like virus] diamond 315 55.1 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Abutilon theophrasti picorna-like virus
28614555 28614555 PRJNA1059246_P_NODE_6767_length_947_cov_3.512586_g6296_i0 PRJNA1059246 6767 947 3.512586 33.26418942 Dicistroviridae sp. 1955144 Viruses Viruses 52.4 0.00231   NR XCO49393.1 1955144 g6296 i0 40.5 0.26610348468849 84 49 26.3 1 844 596 1418 1501 XCO49393.1 MAG: putative ORF1 protein [Dicistroviridae sp.] diamond 252 52.4 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.
28677713 28677713 PRJNA1059246_P_NODE_30507_length_396_cov_1.068111_g29881_i0 PRJNA1059246 30507 396 1.068111 4.22971956 Partitiviridae sp. 1955170 Viruses Viruses 126 1.17e-32   NR QDH88920.1 1955170 g29881 i0 48.1 0.992424242424242 131 66 99.2 2 394 2 65 193 QDH88920.1 MAG: RNA-dependent RNA polymerase, partial [Partitiviridae sp.] diamond 393 126 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae   Partitiviridae sp.
32658913 32658913 PRJNA1059246_P_NODE_2400_length_1587_cov_2.013210_g2169_i0 PRJNA1059246 2400 1587 2.01321 31.9496427 Abutilon theophrasti picorna-like virus 2739846 Viruses Viruses 223 5.7e-59   NR QKK82958.1 2739846 g2169 i0 32.1 0.958412098298677 507 259 87.9 14 128 1522 2498 2961 QKK82958.1 hypothetical protein, partial [Abutilon theophrasti picorna-like virus] diamond 1521 223 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Abutilon theophrasti picorna-like virus

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