RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJNA674048" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 15 ✖

tax_kingdom 1

bioproject 1

  • PRJNA674048 · 15 ✖

analysis 1

  • diamond · 15 ✖

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
26701739 26701739 PRJNA674048_P_NODE_28121_length_168_cov_0.873950_g27918_i0 PRJNA674048 28121 168 0.87395 1.468236 Macrobrachium rosenbergii picorna-like virus 4 3132542 Viruses Viruses 72.8 3.38e-13   NR WWZ85593.1 3132542 g27918 i0 63.6 0.982142857142857 55 20 98.2 0 167 3 1055 1109 WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4] diamond 165 72.8 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Macrobrachium rosenbergii picorna-like virus 4
27271401 27271401 PRJNA674048_P_NODE_9023_length_318_cov_2.156134_g8820_i0 PRJNA674048 9023 318 2.156134 6.85650612 Crogonang virus 66 3063073 Viruses Viruses 134 8.76e-34   NR WPR18337.1 3063073 g8820 i0 72.3 0.952830188679245 101 28 95.3 0 11 313 293 393 WPR18337.1 MAG: capsid protein, partial [Crogonang virus 66] diamond 303 134 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Crogonang virus 66
27776882 27776882 PRJNA674048_P_NODE_29264_length_166_cov_0.888889_g29061_i0 PRJNA674048 29264 166 0.888889 1.47555574 Picornaviridae sp. 1530251 Viruses Viruses 75.1 4.96e-14   NR URG14688.1 1530251 g29061 i0 52.8 0.957831325301205 53 25 95.8 0 164 6 1332 1384 URG14688.1 MAG: RNA dependent RNA polymerase [Picornaviridae sp.] diamond 159 75.1 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
28072731 28072731 PRJNA674048_P_NODE_4105_length_537_cov_4.715164_g3906_i0 PRJNA674048 4105 537 4.715164 25.32043068 Sobemovirus 12137 Viruses Viruses 45.8 0.0467   NR WRQ64918.1 2809868 g3906 i0 29.8 1.68715083798883 151 81 77.1 7 435 22 104 242 WRQ64918.1 proteinase [Sobelivirales sp.] diamond 906 45.8 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Sobelivirales     Sobelivirales sp.
28755511 28755511 PRJNA674048_P_NODE_27447_length_168_cov_2.050420_g27244_i0 PRJNA674048 27447 168 2.05042 3.4447056 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 77.4 7.93e-15   NR UNY42169.1 3003959 g27244 i0 61.8 2.94642857142857 55 21 98.2 0 166 2 68 122 UNY42169.1 MAG: polyprotein 2, partial [Picornavirales sp.] diamond 495 77.4 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
28850057 28850057 PRJNA674048_P_NODE_14688_length_234_cov_2.491892_g14485_i0 PRJNA674048 14688 234 2.491892 5.83102728 Locarnavirus sp. 2809529 Viruses Viruses 73.2 6.62e-13   NR ULG00048.1 2809529 g14485 i0 50 1 78 39 100 0 1 234 1869 1946 ULG00048.1 MAG: hypothetical protein [Locarnavirus sp.] diamond 234 73.2 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae Locarnavirus Locarnavirus sp.
28881726 28881726 PRJNA674048_P_NODE_11228_length_277_cov_4.131579_g11025_i0 PRJNA674048 11228 277 4.131579 11.44447383 Sobelivirales sp. 2809868 Viruses Viruses 55.1 2.46e-6   NR UHS71473.1 2809868 g11025 i0 39.2 0.855595667870036 79 41 84.5 2 12 245 458 530 UHS71473.1 MAG: putative RNA-dependent RNA polymerase [Sobelivirales sp.] diamond 237 55.1 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Sobelivirales     Sobelivirales sp.
29449895 29449895 PRJNA674048_P_NODE_13990_length_241_cov_1.552083_g13787_i0 PRJNA674048 13990 241 1.552083 3.74052003 Locarnavirus sp. 2809529 Viruses Viruses 85.9 2.45e-17   NR ULG00048.1 2809529 g13787 i0 72.5 0.634854771784232 51 14 63.5 0 53 205 77 127 ULG00048.1 MAG: hypothetical protein [Locarnavirus sp.] diamond 153 85.9 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae Locarnavirus Locarnavirus sp.
29576190 29576190 PRJNA674048_P_NODE_27870_length_168_cov_0.873950_g27667_i0 PRJNA674048 27870 168 0.87395 1.468236 Dicistroviridae sp. 1955144 Viruses Viruses 47 4.48e-4   NR XCO49173.1 1955144 g27667 i0 37.5 1.57142857142857 48 30 85.7 0 19 162 719 766 XCO49173.1 MAG: putative ORF1 protein, partial [Dicistroviridae sp.] diamond 264 47 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.
30050005 30050005 PRJNA674048_P_NODE_1311_length_1032_cov_5.084435_g1197_i0 PRJNA674048 1311 1032 5.084435 52.4713692 Ripikanb virus 3130340 Viruses Viruses 77 3.16e-11   NR WZH59460.1 3130340 g1197 i0 25.5 0.808139534883721 278 171 74.7 6 23 793 1351 1613 WZH59460.1 MAG: RNA-dependent RNA polymerase [Ripikanb virus] diamond 834 77 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Sobelivirales Solemoviridae   Ripikanb virus
31187278 31187278 PRJNA674048_P_NODE_32195_length_162_cov_3.115044_g31992_i0 PRJNA674048 32195 162 3.115044 5.04637128 Chaetarnavirus 2 2560376 Viruses Viruses 85.9 7.99e-18   NR XFE97000.1 2560376 g31992 i0 73.6 3.92592592592593 53 14 98.1 0 4 162 1402 1454 XFE97000.1 putative replication-related protein [Chaetarnavirus 2] diamond 636 85.9 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae Sogarnavirus Sogarnavirus tomaruii
31642159 31642159 PRJNA674048_P_NODE_25956_length_172_cov_1.691057_g25753_i0 PRJNA674048 25956 172 1.691057 2.90861804 Viruses 10239 Viruses Viruses 77.4 8.65e-15   NR ULG00002.1 2715102 g25753 i0 61.4 2.91279069767442 57 22 99.4 0 1 171 300 356 ULG00002.1 MAG: hypothetical protein 2 [Marnaviridae sp.] diamond 501 77.4 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae sp.
32484768 32484768 PRJNA674048_P_NODE_29699_length_165_cov_3.905172_g29496_i0 PRJNA674048 29699 165 3.905172 6.4435338 Locarnavirus sp. 2809529 Viruses Viruses 97.4 6.97e-22   NR ULG00072.1 2809529 g29496 i0 81.5 3.92727272727273 54 10 98.2 0 2 163 240 293 ULG00072.1 MAG: hypothetical protein, partial [Locarnavirus sp.] diamond 648 97.4 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae Locarnavirus Locarnavirus sp.
32768315 32768315 PRJNA674048_P_NODE_31820_length_163_cov_0.912281_g31617_i0 PRJNA674048 31820 163 0.912281 1.48701803 Porcine picobirnavirus 442302 Viruses Viruses 56.6 1.54e-7   NR ASM93464.1 442302 g31617 i0 57.8 0.828220858895706 45 19 82.8 0 137 3 110 154 ASM93464.1 capsid protein, partial [Porcine picobirnavirus] diamond 135 56.6 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Picobirnaviridae Orthopicobirnavirus Porcine picobirnavirus
32831391 32831391 PRJNA674048_P_NODE_33980_length_153_cov_3.000000_g33777_i0 PRJNA674048 33980 153 3 4.59 Picornaviridae sp. 1530251 Viruses Viruses 68.9 6.13e-12   NR URG14822.1 1530251 g33777 i0 64 0.980392156862745 50 18 98 0 3 152 635 684 URG14822.1 MAG: RNA dependent RNA polymerase [Picornaviridae sp.] diamond 150 68.9 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);;