RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJNA1174207" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 11 ✖

bioproject 1

  • PRJNA1174207 · 11 ✖

analysis 1

  • diamond · 11 ✖

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
18167604 18167604 PRJNA1174207_P_NODE_8215_length_551_cov_2.110879_g7691_i0 PRJNA1174207 8215 551 2.110879 11.63094329 Marnaviridae sp. 2715102 Viruses Viruses 291 2.05e-94   NR QRI44260.1 2715102 g7691 i0 78.1 0.996370235934664 183 40 99.6 0 551 3 181 363 QRI44260.1 MAG: hypothetical protein 1, partial [Marnaviridae sp.] diamond 549 291 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae sp.
21992048 21992048 PRJNA1174207_P_NODE_178_length_3993_cov_402.771429_g129_i0 PRJNA1174207 178 3993 402.771429 16082.66315997 Severe acute respiratory syndrome coronavirus 2 2697049 Viruses Viruses 2459 0   NR ULP78342.1 2697049 g129 i0 98.3 9.5717505634861 1277 15 95.4 1 3945 136 1 1277 ULP78342.1 surface glycoprotein [Severe acute respiratory syndrome coronavirus 2] diamond 38220 2459 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
26692230 26692230 PRJNA1174207_P_NODE_9241_length_508_cov_2.604598_g8716_i0 PRJNA1174207 9241 508 2.604598 13.23135784 Picornaviridae sp. 1530251 Viruses Viruses 266 5.39e-79   NR URG14835.1 1530251 g8716 i0 78.6 0.992125984251969 168 36 99.2 0 506 3 1448 1615 URG14835.1 MAG: RNA dependent RNA polymerase [Picornaviridae sp.] diamond 504 266 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
28019847 28019847 PRJNA1174207_P_NODE_6365_length_656_cov_1.814751_g5850_i0 PRJNA1174207 6365 656 1.814751 11.90476656 Picornaviridae sp. 1530251 Viruses Viruses 301 1.66e-90   NR URG14835.1 1530251 g5850 i0 67 0.996951219512195 218 71 99.7 1 655 2 1188 1404 URG14835.1 MAG: RNA dependent RNA polymerase [Picornaviridae sp.] diamond 654 301 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
28146186 28146186 PRJNA1174207_P_NODE_8605_length_534_cov_1.845987_g8081_i0 PRJNA1174207 8605 534 1.845987 9.85757058 Picornaviridae sp. 1530251 Viruses Viruses 265 2.67e-78   NR URG14835.1 1530251 g8081 i0 65.7 0.98314606741573 175 59 97.8 1 530 9 324 498 URG14835.1 MAG: RNA dependent RNA polymerase [Picornaviridae sp.] diamond 525 265 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
28872105 28872105 PRJNA1174207_P_NODE_41168_length_241_cov_1.636905_g40639_i0 PRJNA1174207 41168 241 1.636905 3.94494105 Shenzhen dicistro-like virus 2789378 Viruses Viruses 75.1 1.51e-13   NR QPG92982.1 2789378 g40639 i0 49.5 2.2655601659751 91 32 95.9 1 11 241 991 1081 QPG92982.1 polyprotein [Shenzhen dicistro-like virus] diamond 546 75.1 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Shenzhen dicistro-like virus
29030281 29030281 PRJNA1174207_P_NODE_35588_length_248_cov_1.554286_g35059_i0 PRJNA1174207 35588 248 1.554286 3.85462928 Erysiphe necator associated virga-like virus 13 2743128 Viruses Viruses 57.4 2.78e-7   NR QKN22650.1 2743128 g35059 i0 48.3 0.725806451612903 60 31 72.6 0 3 182 1103 1162 QKN22650.1 RNA-dependent RNA polymerase [Erysiphe necator associated virga-like virus 13] diamond 180 57.4 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Virgaviridae   Erysiphe necator associated virga-like virus 13
29566713 29566713 PRJNA1174207_P_NODE_41870_length_240_cov_2.371257_g41341_i0 PRJNA1174207 41870 240 2.371257 5.6910168 Leviviridae sp. 2027243 Viruses Viruses 131 4.14e-35   NR UJQ85386.1 2027243 g41341 i0 77.9 0.9625 77 17 96.3 0 5 235 203 279 UJQ85386.1 MAG: hypothetical protein 1, partial [Leviviridae sp.] diamond 231 131 1 Viruses   Orthornavirae Lenarviricota Leviviricetes Norzivirales Fiersviridae   Leviviridae sp.
29629581 29629581 PRJNA1174207_P_NODE_710_length_2258_cov_6.094737_g560_i0 PRJNA1174207 710 2258 6.094737 137.61916146 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 810 1.94e-282   NR XCM67754.1 3003959 g560 i0 60.3 0.919397697077059 692 257 90.6 5 2 2047 215 898 XCM67754.1 MAG: structural polyprotein [Picornavirales sp.] diamond 2076 810 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
29977318 29977318 PRJNA1174207_P_NODE_5351_length_732_cov_3.444613_g4849_i0 PRJNA1174207 5351 732 3.444613 25.21456716 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 156 1.98e-39   NR XCM67754.1 3003959 g4849 i0 55.8 0.565573770491803 138 57 56.6 1 292 705 71 204 XCM67754.1 MAG: structural polyprotein [Picornavirales sp.] diamond 414 156 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
31430898 31430898 PRJNA1174207_P_NODE_31456_length_258_cov_2.729730_g30927_i0 PRJNA1174207 31456 258 2.72973 7.0427034 Picornaviridae sp. 1530251 Viruses Viruses 65.1 6.14e-10   NR URG14835.1 1530251 g30927 i0 42.1 0.883720930232558 76 43 87.2 1 244 20 844 919 URG14835.1 MAG: RNA dependent RNA polymerase [Picornaviridae sp.] diamond 228 65.1 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae 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);;