RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA312899" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 6 ✖

bioproject 1

  • PRJNA312899 · 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
19505709 19505709 PRJNA312899_P_NODE_5056_length_806_cov_68.248349_g4748_i0 PRJNA312899 5056 806 68.248349 550.08169294 Erysiphe necator associated ourmia-like virus 67 2741847 Viruses Viruses 232 2.6e-68   NR QKI79897.1 2741847 g4748 i0 70.7 0.558312655086849 150 44 55.8 0 4 453 460 609 QKI79897.1 RNA-dependent RNA polymerase [Erysiphe necator associated ourmia-like virus 67] diamond 450 232 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae Ourmiavirus Erysiphe necator associated ourmia-like virus 67
27010926 27010926 PRJNA312899_P_NODE_35622_length_303_cov_13.744094_g35180_i0 PRJNA312899 35622 303 13.744094 41.64460482 Dicistroviridae sp. 1955144 Viruses Viruses 72.4 2.94e-12   NR XCO49407.1 1955144 g35180 i0 44.1 0.920792079207921 93 48 91.1 2 290 15 805 894 XCO49407.1 MAG: putative ORF1 protein, partial [Dicistroviridae sp.] diamond 279 72.4 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.
27042673 27042673 PRJNA312899_P_NODE_3162_length_962_cov_41.704272_g2917_i0 PRJNA312899 3162 962 41.704272 401.19509664 Locarnavirus sp. 2809529 Viruses Viruses 342 8.92e-103   NR ULG00072.1 2809529 g2917 i0 54.2 1.91476091476091 308 115 92.9 4 55 948 49 340 ULG00072.1 MAG: hypothetical protein, partial [Locarnavirus sp.] diamond 1842 342 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae Locarnavirus Locarnavirus sp.
28590345 28590345 PRJNA312899_P_NODE_34687_length_309_cov_1.361538_g34245_i0 PRJNA312899 34687 309 1.361538 4.20715242 ssRNA phage Gephyllon.2_12 2786139 Viruses Viruses 50.8 1.07e-4   NR YP_010769165.1 2786139 g34245 i0 41.2 1.67961165048544 68 40 66 0 218 15 96 163 YP_010769165.1 maturation protein [ssRNA phage Gephyllon.2_12] diamond 519 50.8 1 Viruses   Orthornavirae Lenarviricota Leviviricetes Norzivirales Fiersviridae Cahdavirus Cahdavirus humicola
31717803 31717803 PRJNA312899_P_NODE_19917_length_422_cov_11.911528_g19476_i0 PRJNA312899 19917 422 11.911528 50.26664816 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 95.9 7.27e-20   NR XCM67775.1 3003959 g19476 i0 56 0.533175355450237 75 32 53.3 1 421 197 822 895 XCM67775.1 MAG: structural polyprotein [Picornavirales sp.] diamond 225 95.9 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
32192451 32192451 PRJNA312899_P_NODE_45738_length_260_cov_4.113744_g45296_i0 PRJNA312899 45738 260 4.113744 10.6957344 Colletotrichum associated partitivirus 2 2979641 Viruses Viruses 55.1 2.04e-6   NR UYD21360.1 2979641 g45296 i0 48 0.576923076923077 50 26 57.7 0 255 106 487 536 UYD21360.1 hypothetical protein [Colletotrichum associated partitivirus 2] diamond 150 55.1 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae   Colletotrichum associated partitivirus 2

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