RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA561212" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA561212 · 7 ✖

analysis 1

  • diamond · 7 ✖

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
545332 545332 PRJNA561212_P_NODE_1_length_10659_cov_2833.062441_g0_i0 PRJNA561212 1 10659 2833.062441 301976.12558619 Viruses 10239 Viruses Viruses 833 6.05e-254   NR XCO48968.1 1955144 g0 i0 32.2 5.04728398536448 1841 962 50 38 1940 7267 153 1772 XCO48968.1 MAG: putative ORF1 protein [Dicistroviridae sp.] diamond 53799 841 0.990487514863258 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.
27363863 27363863 PRJNA561212_P_NODE_15783_length_284_cov_1.289100_g15572_i0 PRJNA561212 15783 284 1.2891 3.661044 Qianjiang picorna-like virus 6 3348787 Viruses Viruses 77.8 3.01e-14   NR XHA88449.1 3348787 g15572 i0 37.4 0.961267605633803 91 57 96.1 0 12 284 195 285 XHA88449.1 MAG: polyprotein [Qianjiang picorna-like virus 6] diamond 273 77.8 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Qianjiang picorna-like virus 6
28153137 28153137 PRJNA561212_P_NODE_11305_length_329_cov_2.937500_g11094_i0 PRJNA561212 11305 329 2.9375 9.664375 Picornaviridae sp. 1530251 Viruses Viruses 106 2.1699999999999994e-24   NR WWV87070.1 1530251 g11094 i0 49.1 0.966565349544073 106 54 96.7 0 319 2 120 225 WWV87070.1 MAG: polyprotein, partial [Picornaviridae sp.] diamond 318 106 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
29195056 29195056 PRJNA561212_P_NODE_209_length_1944_cov_2.265099_g160_i0 PRJNA561212 209 1944 2.265099 44.03352456 Qianjiang picorna-like virus 6 3348787 Viruses Viruses 195 3.21e-48   NR XHA88449.1 3348787 g160 i0 52.3 0.300925925925926 195 82 30.1 3 16 600 378 561 XHA88449.1 MAG: polyprotein [Qianjiang picorna-like virus 6] diamond 585 195 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Qianjiang picorna-like virus 6
29447283 29447283 PRJNA561212_P_NODE_90_length_2617_cov_2.301101_g67_i0 PRJNA561212 90 2617 2.301101 60.21981317 Qianjiang picorna-like virus 6 3348787 Viruses Viruses 390 4.769999999999999e-112   NR XHA88449.1 3348787 g67 i0 40.1 0.765762323270921 668 335 74.4 22 11 1957 1946 2567 XHA88449.1 MAG: polyprotein [Qianjiang picorna-like virus 6] diamond 2004 390 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Qianjiang picorna-like virus 6
30616103 30616103 PRJNA561212_P_NODE_12713_length_312_cov_2.150628_g12502_i0 PRJNA561212 12713 312 2.150628 6.70995936 Picornaviridae sp. 1530251 Viruses Viruses 117 4.65e-29   NR WWV86705.1 1530251 g12502 i0 53.9 0.980769230769231 102 46 97.1 1 2 304 134 235 WWV86705.1 MAG: polyprotein, partial [Picornaviridae sp.] diamond 306 117 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
32576993 32576993 PRJNA561212_P_NODE_539_length_1376_cov_1.987721_g436_i0 PRJNA561212 539 1376 1.987721 27.35104096 Qianjiang picorna-like virus 6 3348787 Viruses Viruses 302 6.87e-87   NR XHA88449.1 3348787 g436 i0 40.6 1.0094476744186 463 215 99 6 1371 10 1534 1945 XHA88449.1 MAG: polyprotein [Qianjiang picorna-like virus 6] diamond 1389 302 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Qianjiang picorna-like virus 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);;