RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "diamond", bioproject = "PRJNA914897" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 9 ✖

bioproject 1

  • PRJNA914897 · 9 ✖

analysis 1

  • diamond · 9 ✖

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
20021728 20021728 PRJNA914897_P_NODE_76_length_3496_cov_22.839030_g66_i0 PRJNA914897 76 3496 22.83903 798.4524888 ssRNA phage AVE 2844113 Viruses Viruses 723 4.189999999999999e-248   NR YP_010769330.1 2785989 g66 i0 66.4 0.452231121281465 527 174 45.1 3 1810 3384 1 526 YP_010769330.1 RNA-directed RNA polymerase [ssRNA phage AVE017] diamond 1581 723 1 Viruses   Orthornavirae Lenarviricota Leviviricetes Norzivirales Fiersviridae Emesvirus Emesvirus piscicola
28350943 28350943 PRJNA914897_P_NODE_14146_length_478_cov_1.140741_g13724_i0 PRJNA914897 14146 478 1.140741 5.45274198 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 52 2.36e-4   NR XCM68461.1 3003959 g13724 i0 25.6 1.02928870292887 164 111 97.9 5 6 473 97 257 XCM68461.1 MAG: RNA-dependent RNA polymerase, partial [Picornavirales sp.] diamond 492 52 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
28350964 28350964 PRJNA914897_P_NODE_30146_length_287_cov_1.836449_g29722_i0 PRJNA914897 30146 287 1.836449 5.27060863 Trichosanthes kirilowii picorna-like virus 2739857 Viruses Viruses 80.9 2.58e-15   NR QKK82964.1 2739857 g29722 i0 41.5 0.857142857142857 82 48 85.7 0 37 282 1842 1923 QKK82964.1 hypothetical protein, partial [Trichosanthes kirilowii picorna-like virus] diamond 246 80.9 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Trichosanthes kirilowii picorna-like virus
30435593 30435593 PRJNA914897_P_NODE_9493_length_618_cov_1.209174_g9078_i0 PRJNA914897 9493 618 1.209174 7.47269532 Biomphalaria pfeifferi virus 2884323 Viruses Viruses 95.5 6.9e-19   NR UDL17056.1 2884323 g9078 i0 32.7 1.05339805825243 217 125 99 6 614 3 164 372 UDL17056.1 MAG: capsid protein, partial [Biomphalaria pfeifferi virus] diamond 651 95.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Biomphalaria pfeifferi virus
30467233 30467233 PRJNA914897_P_NODE_37173_length_250_cov_0.870056_g36749_i0 PRJNA914897 37173 250 0.870056 2.17514 Husavirus sp. 1930509 Viruses Viruses 52 2.34e-5   NR QPF30634.1 1930509 g36749 i0 35.3 0.816 68 44 81.6 0 25 228 484 551 QPF30634.1 polyprotein, partial [Husavirus sp.] diamond 204 52 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales   Husavirus Husavirus sp.
30498526 30498526 PRJNA914897_P_NODE_34333_length_263_cov_1.368421_g33909_i0 PRJNA914897 34333 263 1.368421 3.59894723 Qianjiang picorna-like virus 6 3348787 Viruses Viruses 101 1.2800000000000001e-22   NR XHA88449.1 3348787 g33909 i0 55.2 0.992395437262357 87 39 99.2 0 3 263 1634 1720 XHA88449.1 MAG: polyprotein [Qianjiang picorna-like virus 6] diamond 261 101 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Qianjiang picorna-like virus 6
30940982 30940982 PRJNA914897_P_NODE_10354_length_584_cov_1.227006_g9937_i0 PRJNA914897 10354 584 1.227006 7.16571504 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 145 2.94e-36   NR QDH87819.1 3003959 g9937 i0 38.7 0.981164383561644 191 110 97.6 3 7 576 346 530 QDH87819.1 MAG: hypothetical protein H4Bulk4834_000002 [Picornavirales sp.] diamond 573 145 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
31035932 31035932 PRJNA914897_P_NODE_33735_length_267_cov_1.190722_g33311_i0 PRJNA914897 33735 267 1.190722 3.17922774 African cichlid piscichuvirus 3065075 Viruses Viruses 91.7 3.18e-19   NR WLN26256.1 3065075 g33311 i0 48.9 0.98876404494382 88 45 98.9 0 265 2 145 232 WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus] diamond 264 91.7 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Jingchuvirales Chuviridae Piscichuvirus African cichlid piscichuvirus
32554192 32554192 PRJNA914897_P_NODE_21339_length_363_cov_0.875862_g20915_i0 PRJNA914897 21339 363 0.875862 3.17937906 Porcine reproductive and respiratory syndrome virus 28344 Viruses Viruses 45.4 0.0168   NR UTT87587.1 28344 g20915 i0 33.7 1.43801652892562 86 48 67.8 3 45 290 1603 1683 UTT87587.1 replicase polyprotein 1a [Porcine reproductive and respiratory syndrome virus] diamond 522 45.4 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Arteriviridae Betaarterivirus Betaarterivirus americense

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