RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA1198392" 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

  • PRJNA1198392 · 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
26914254 26914254 PRJNA1198392_P_NODE_8462_length_289_cov_1.425926_g8321_i0 PRJNA1198392 8462 289 1.425926 4.12092614 Locarnavirus sp. 2809529 Viruses Viruses 167 1.14e-45   NR ULG00073.1 2809529 g8321 i0 80.2 0.996539792387543 96 19 99.7 0 288 1 1293 1388 ULG00073.1 MAG: hypothetical protein 1 [Locarnavirus sp.] diamond 288 167 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae Locarnavirus Locarnavirus sp.
28367276 28367276 PRJNA1198392_P_NODE_16446_length_250_cov_0.870056_g16305_i0 PRJNA1198392 16446 250 0.870056 2.17514 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 76.6 4.82e-14   NR XCM67838.1 3003959 g16305 i0 46.4 1.008 84 43 98.4 1 2 247 487 570 XCM67838.1 MAG: structural polyprotein [Picornavirales sp.] diamond 252 76.6 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
28462352 28462352 PRJNA1198392_P_NODE_12886_length_268_cov_1.410256_g12745_i0 PRJNA1198392 12886 268 1.410256 3.77948608 Moss associated narna-like virus 29 3066988 Viruses Viruses 48.5 4.49e-4   NR WPR17166.1 3066988 g12745 i0 34.2 0.884328358208955 79 51 87.3 1 15 248 160 238 WPR17166.1 MAG: RNA-dependent RNA polymerase, partial [Moss associated narna-like virus 29] diamond 237 48.5 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes Wolframvirales Narnaviridae   Moss associated narna-like virus 29
30641086 30641086 PRJNA1198392_P_NODE_2073_length_514_cov_1.469388_g1932_i0 PRJNA1198392 2073 514 1.469388 7.55265432 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 84.7 1.62e-15   NR XCM68108.1 3003959 g1932 i0 37.5 0.747081712062257 128 77 74.1 3 2 382 862 987 XCM68108.1 MAG: structural polyprotein [Picornavirales sp.] diamond 384 84.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
32032442 32032442 PRJNA1198392_P_NODE_12138_length_271_cov_2.722222_g11997_i0 PRJNA1198392 12138 271 2.722222 7.37722162 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 103 2.19e-23   NR XCM67838.1 3003959 g11997 i0 54.5 0.974169741697417 88 40 97.4 0 2 265 677 764 XCM67838.1 MAG: structural polyprotein [Picornavirales sp.] diamond 264 103 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
32853570 32853570 PRJNA1198392_P_NODE_10860_length_278_cov_1.502439_g10719_i0 PRJNA1198392 10860 278 1.502439 4.17678042 Mitovirus sp. 2587224 Viruses Viruses 62 8.28e-9   NR QDH89904.1 2587224 g10719 i0 42.7 0.884892086330935 82 46 88.5 1 278 33 257 337 QDH89904.1 MAG: RNA-dependent RNA polymerase, partial [Mitovirus sp.] diamond 246 62 1 Viruses   Orthornavirae Lenarviricota Howeltoviricetes Cryppavirales Mitoviridae Mitovirus Mitovirus sp.

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