RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where bioproject = "PRJNA532380" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_kingdom 2

analysis 2

tax_superkingdom 1

  • Viruses · 18 ✖

bioproject 1

  • PRJNA532380 · 18 ✖

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
503768 503768 PRJNA532380_P_NODE_1_length_10979_cov_1690.222232_g0_i0 PRJNA532380 1 10979 1690.222232 185569.49885128 Spring viraemia of carp virus 696863 Viruses Viruses 20242 0   NTclustered gi|15211934|emb|AJ318079.1| 696863 g0 i0 99.954 30.0786046087986 10978 2 99 2 2 10979 10994 20 Spring Viremia of Carp complete genome, genomic RNA blastn 330233 20242 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Mononegavirales Rhabdoviridae Sprivivirus Spring viraemia of carp virus
1779363 1779363 PRJNA532380_P_NODE_30462_length_165_cov_1.344828_g30137_i0 PRJNA532380 30462 165 1.344828 2.2189662 Polycipiviridae sp. 2496155 Viruses Viruses 52.8 0.014   NTclustered gi|2756421824|gb|PP744841.1| 2496155 g30137 i0 90.244 0.248484848484848 41 3 24 1 39 78 9171 9211 MAG: Polycipiviridae sp. isolate 086_167342 genomic sequence blastn 41 52.8 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Polycipiviridae   Polycipiviridae sp.
27092652 27092652 PRJNA532380_P_NODE_24262_length_181_cov_1.916667_g23937_i0 PRJNA532380 24262 181 1.916667 3.46916727 Viruses 10239 Viruses Viruses 71.6 1.03e-12   NR QUS52711.1 2832186 g23937 i0 56.9 1.92265193370166 58 25 96.1 0 176 3 1221 1278 QUS52711.1 hypothetical protein 1 [Mute swan feces associated picorna-like virus 13] diamond 348 71.6 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Mute swan feces associated picorna-like virus 13
27393807 27393807 PRJNA532380_P_NODE_19763_length_202_cov_1.816993_g19438_i0 PRJNA532380 19763 202 1.816993 3.67032586 Scallop picorna-like virus 1 2932679 Viruses Viruses 96.7 2.2e-21   NR UTS51938.1 2932679 g19438 i0 61.5 0.965346534653465 65 25 96.5 0 3 197 637 701 UTS51938.1 MAG: polyprotein [Scallop picorna-like virus 1] diamond 195 96.7 1 Viruses               Scallop picorna-like virus 1
27425465 27425465 PRJNA532380_P_NODE_17483_length_215_cov_1.403614_g17158_i0 PRJNA532380 17483 215 1.403614 3.0177701 Scallop picorna-like virus 1 2932679 Viruses Viruses 79 4.57e-15   NR UTS51938.1 2932679 g17158 i0 57.6 0.92093023255814 66 28 92.1 0 15 212 1311 1376 UTS51938.1 MAG: polyprotein [Scallop picorna-like virus 1] diamond 198 79 1 Viruses               Scallop picorna-like virus 1
28088160 28088160 PRJNA532380_P_NODE_28065_length_168_cov_1.310924_g27740_i0 PRJNA532380 28065 168 1.310924 2.20235232 Mimiviridae sp. ChoanoV1 2596887 Viruses Viruses 56.6 1.53e-7   NR QDY52386.1 2596887 g27740 i0 44.4 1.91071428571429 54 30 96.4 0 164 3 95 148 QDY52386.1 hypothetical protein 7_34 [Mimiviridae sp. ChoanoV1] diamond 321 56.6 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Schizomimiviridae   Mimiviridae sp. ChoanoV1
28530481 28530481 PRJNA532380_P_NODE_9067_length_312_cov_1.532319_g8742_i0 PRJNA532380 9067 312 1.532319 4.78083528 Mute swan feces associated picorna-like virus 13 2832186 Viruses Viruses 170 8.45e-47   NR QUS52710.1 2832186 g8742 i0 76 2 104 23 100 1 312 1 350 451 QUS52710.1 hypothetical protein 2 [Mute swan feces associated picorna-like virus 13] diamond 624 170 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Mute swan feces associated picorna-like virus 13
28671837 28671837 PRJNA532380_P_NODE_26167_length_173_cov_1.677419_g25842_i0 PRJNA532380 26167 173 1.677419 2.90193487 Viruses 10239 Viruses Viruses 43.9 0.0058   NR QUS52711.1 2832186 g25842 i0 40.8 1.71676300578035 49 29 85 0 147 1 822 870 QUS52711.1 hypothetical protein 1 [Mute swan feces associated picorna-like virus 13] diamond 297 44.3 0.99097065462754 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Mute swan feces associated picorna-like virus 13
28751327 28751327 PRJNA532380_P_NODE_1487_length_869_cov_2.229268_g1275_i0 PRJNA532380 1487 869 2.229268 19.37233892 Mute swan feces associated picorna-like virus 13 2832186 Viruses Viruses 408 8.98e-134   NR QUS52710.1 2832186 g1275 i0 73.6 0.901035673187572 261 66 90.1 2 1 783 565 822 QUS52710.1 hypothetical protein 2 [Mute swan feces associated picorna-like virus 13] diamond 783 408 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Mute swan feces associated picorna-like virus 13
29098712 29098712 PRJNA532380_P_NODE_12528_length_257_cov_1.466346_g12203_i0 PRJNA532380 12528 257 1.466346 3.76850922 Scallop picorna-like virus 1 2932679 Viruses Viruses 99 7.58e-22   NR UTS51938.1 2932679 g12203 i0 63.9 0.840466926070039 72 25 84 1 42 257 262 332 UTS51938.1 MAG: polyprotein [Scallop picorna-like virus 1] diamond 216 99 1 Viruses               Scallop picorna-like virus 1
29287975 29287975 PRJNA532380_P_NODE_7869_length_339_cov_2.155172_g7544_i0 PRJNA532380 7869 339 2.155172 7.30603308 Mute swan feces associated picorna-like virus 13 2832186 Viruses Viruses 167 1.49e-45   NR QUS52710.1 2832186 g7544 i0 71.4 0.991150442477876 112 32 99.1 0 3 338 452 563 QUS52710.1 hypothetical protein 2 [Mute swan feces associated picorna-like virus 13] diamond 336 167 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Mute swan feces associated picorna-like virus 13
29351350 29351350 PRJNA532380_P_NODE_8809_length_317_cov_1.776119_g8484_i0 PRJNA532380 8809 317 1.776119 5.63029723 Scallop picorna-like virus 1 2932679 Viruses Viruses 129 5.06e-32   NR UTS51938.1 2932679 g8484 i0 56.6 2.00630914826498 106 44 98.4 1 313 2 1671 1776 UTS51938.1 MAG: polyprotein [Scallop picorna-like virus 1] diamond 636 129 1 Viruses               Scallop picorna-like virus 1
29666655 29666655 PRJNA532380_P_NODE_4690_length_467_cov_1.528708_g4365_i0 PRJNA532380 4690 467 1.528708 7.13906636 Scallop picorna-like virus 1 2932679 Viruses Viruses 271 1.35e-82   NR UTS51939.1 2932679 g4365 i0 83.9 0.995717344753747 155 25 99.6 0 466 2 103 257 UTS51939.1 MAG: capsid protein [Scallop picorna-like virus 1] diamond 465 271 1 Viruses               Scallop picorna-like virus 1
29698148 29698148 PRJNA532380_P_NODE_2550_length_665_cov_2.025974_g2267_i0 PRJNA532380 2550 665 2.025974 13.4727271 Mute swan feces associated picorna-like virus 13 2832186 Viruses Viruses 380 4.9599999999999985e-124   NR QUS52710.1 2832186 g2267 i0 82.8 1.98496240601504 221 38 99.7 0 2 664 136 356 QUS52710.1 hypothetical protein 2 [Mute swan feces associated picorna-like virus 13] diamond 1320 380 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Mute swan feces associated picorna-like virus 13
31025546 31025546 PRJNA532380_P_NODE_10915_length_279_cov_1.660870_g10590_i0 PRJNA532380 10915 279 1.66087 4.6338273 Scallop picorna-like virus 1 2932679 Viruses Viruses 46.2 0.00354   NR UTS51938.1 2932679 g10590 i0 38.1 0.67741935483871 63 39 67.7 0 191 3 733 795 UTS51938.1 MAG: polyprotein [Scallop picorna-like virus 1] diamond 189 46.2 1 Viruses               Scallop picorna-like virus 1
31214598 31214598 PRJNA532380_P_NODE_7975_length_337_cov_1.083333_g7650_i0 PRJNA532380 7975 337 1.083333 3.65083221 Scallop picorna-like virus 1 2932679 Viruses Viruses 110 2e-25   NR UTS51938.1 2932679 g7650 i0 49.6 1.04154302670623 117 53 99.7 3 337 2 857 972 UTS51938.1 MAG: polyprotein [Scallop picorna-like virus 1] diamond 351 110 1 Viruses               Scallop picorna-like virus 1
31672878 31672878 PRJNA532380_P_NODE_29577_length_166_cov_2.145299_g29252_i0 PRJNA532380 29577 166 2.145299 3.56119634 Viruses 10239 Viruses Viruses 81.3 3.37e-16   NR QUS52711.1 2832186 g29252 i0 68 1.87951807228916 50 16 90.4 0 15 164 445 494 QUS52711.1 hypothetical protein 1 [Mute swan feces associated picorna-like virus 13] diamond 312 81.3 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Mute swan feces associated picorna-like virus 13
31847522 31847522 PRJNA532380_P_NODE_6157_length_393_cov_1.418605_g5832_i0 PRJNA532380 6157 393 1.418605 5.57511765 Scallop picorna-like virus 1 2932679 Viruses Viruses 182 3.64e-50   NR UTS51938.1 2932679 g5832 i0 64.1 1 131 47 100 0 1 393 1392 1522 UTS51938.1 MAG: polyprotein [Scallop picorna-like virus 1] diamond 393 182 1 Viruses               Scallop picorna-like virus 1

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