RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where bioproject = "PRJNA195897" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Viruses · 17 ✖

bioproject 1

  • PRJNA195897 · 17 ✖

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
365962 365962 PRJNA195897_P_NODE_1_length_9208_cov_44.865378_g0_i0 PRJNA195897 1 9208 44.865378 4131.20400624 Hangzhou marna-like virus 1 3029006 Viruses Viruses 3395 0   NR WEU70895.1 3029006 g0 i0 62.8 0.891724587315378 2737 957 88.9 17 836 9022 12 2694 WEU70895.1 MAG: polyprotein [Hangzhou marna-like virus 1] diamond 8211 3395 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Hangzhou marna-like virus 1
365998 365998 PRJNA195897_P_NODE_5181_length_212_cov_2.092025_g5148_i0 PRJNA195897 5181 212 2.092025 4.435093 Plotvirus plot 2170099 Viruses Viruses 62.1 3.1e-5   NTclustered gi|1720702708|gb|MN119378.1| 2596982 g5148 i0 91.489 1 47 1 21 2 112 155 45867 45913 Mycobacterium phage Penelope2018, complete genome blastn 212 62.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Plotvirus Plotvirus plot
1640753 1640753 PRJNA195897_P_NODE_2_length_8153_cov_6.682379_g1_i0 PRJNA195897 2 8153 6.682379 544.81435987 Perth bee virus 4 2201298 Viruses Viruses 2713 0   NTclustered gi|1390040502|gb|MG995733.1| 2201298 g1 i0 76.558 1.16190359376916 5072 1118 62 64 3118 8153 1981 7017 Perth bee virus 4 isolate WA2-63 nonstructural polyprotein gene, partial cds; and structural polyprotein gene, complete cds blastn 9473 2713 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Perth bee virus 4
8019373 8019373 PRJNA195897_P_NODE_5167_length_213_cov_0.951220_g5134_i0 PRJNA195897 5167 213 0.95122 2.0260986 Pandoravirus neocaledonia 2107708 Viruses Viruses 176 1.07e-39   NTclustered gi|1408258530|ref|NC_037666.1| 2107708 g5134 i0 83.784 72.5117370892019 185 30 87 0 5 189 1577058 1576874 Pandoravirus neocaledonia, complete genome blastn 15445 176 1 Viruses             Pandoravirus Pandoravirus neocaledonia
15668778 15668778 PRJNA195897_P_NODE_3173_length_275_cov_1.610619_g3140_i0 PRJNA195897 3173 275 1.610619 4.42920225 Guapo partitivirus 3078405 Viruses Viruses 206 1.83e-48   NTclustered gi|2583640776|gb|OQ968299.1| 3078405 g3140 i0 83.333 10.2436363636364 222 37 81 0 26 247 740 519 MAG: Guapo partitivirus isolate JARP31 genomic sequence blastn 2817 206 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae   Guapo partitivirus
18217674 18217674 PRJNA195897_P_NODE_3195_length_274_cov_1.413333_g3162_i0 PRJNA195897 3195 274 1.413333 3.87253242 Indivirus ILV1 1977633 Viruses Viruses 108 5.3e-19   NTclustered gi|1174570775|gb|KY684086.1| 1977633 g3162 i0 83.333 0.693430656934307 120 17 43 3 120 238 146633 146516 Indivirus ILV1 isolate ILV1 clone Indivirus_2, sequence blastn 190 108 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae Indivirus Indivirus ILV1
19491995 19491995 PRJNA195897_P_NODE_496_length_760_cov_6.291139_g468_i0 PRJNA195897 496 760 6.291139 47.8126564 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 632 2.1399999999999996e-176   NTclustered gi|2754691651|gb|PP872615.1| 3003959 g468 i0 82.072 0.990789473684211 753 124 99 10 11 759 8526 9271 MAG: Picornavirales sp. isolate TC-PLV-59 MR233-17E/322 genomic sequence blastn 753 632 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
26711617 26711617 PRJNA195897_P_NODE_3961_length_241_cov_1.494792_g3928_i0 PRJNA195897 3961 241 1.494792 3.60244872 Viruses 10239 Viruses Viruses 42.7 0.0367   NR WPF46901.1 3086121 g3928 i0 30 1.94190871369295 60 42 74.7 0 23 202 384 443 WPF46901.1 MAG: putative major capsid protein [Lake Baikal virophage 16] diamond 468 43.1 0.990719257540603 Viruses   Bamfordvirae Preplasmiviricota Virophaviricetes Priklausovirales Lavidaviridae   Lake Baikal virophage 16
27547865 27547865 PRJNA195897_P_NODE_6924_length_189_cov_1.035714_g6891_i0 PRJNA195897 6924 189 1.035714 1.95749946 Moumouvirus goulette 1247379 Viruses Viruses 83.2 4.96e-17   NR YP_010779165.1 1247379 g6891 i0 53.2 0.984126984126984 62 29 98.4 0 3 188 245 306 YP_010779165.1 synthetase [Moumouvirus goulette] diamond 186 83.2 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae Moumouvirus Moumouvirus goulettemassiliense
27642814 27642814 PRJNA195897_P_NODE_11304_length_164_cov_1.217391_g11271_i0 PRJNA195897 11304 164 1.217391 1.99652124 Gaeavirus sp. 2487767 Viruses Viruses 63.5 5.8e-10   NR AYV79987.1 2487767 g11271 i0 56.4 1.00609756097561 55 23 98.8 1 1 162 977 1031 AYV79987.1 MAG: mRNA capping enzyme [Gaeavirus sp.] diamond 165 63.5 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae   Gaeavirus sp.
27990028 27990028 PRJNA195897_P_NODE_3065_length_280_cov_2.952381_g3032_i0 PRJNA195897 3065 280 2.952381 8.2666668 Gaeavirus sp. 2487767 Viruses Viruses 65.9 7.8e-12   NR AYV80119.1 2487767 g3032 i0 46.5 0.760714285714286 71 35 76.1 1 7 219 4 71 AYV80119.1 MAG: hypothetical protein Gaeavirus10_15 [Gaeavirus sp.] diamond 213 65.9 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae   Gaeavirus sp.
28210771 28210771 PRJNA195897_P_NODE_486_length_768_cov_1.824757_g458_i0 PRJNA195897 486 768 1.824757 14.01413376 Klosneuvirus KNV1 1977640 Viruses Viruses 278 3.67e-90   NR ARF11950.1 1977640 g458 i0 57.6 0.9296875 238 99 93 1 763 50 64 299 ARF11950.1 elongation factor Tu EF-Tu-like protein [Klosneuvirus KNV1] diamond 714 278 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae Klosneuvirus Klosneuvirus KNV1
28558408 28558408 PRJNA195897_P_NODE_3367_length_265_cov_2.004630_g3334_i0 PRJNA195897 3367 265 2.00463 5.3122695 Picornaviridae sp. 1530251 Viruses Viruses 138 1.01e-35   NR URG14784.1 1530251 g3334 i0 74.4 0.973584905660377 86 22 97.4 0 4 261 212 297 URG14784.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.] diamond 258 138 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
28779146 28779146 PRJNA195897_P_NODE_5827_length_202_cov_1.359477_g5794_i0 PRJNA195897 5827 202 1.359477 2.74614354 Changjiang picorna-like virus 2 1922791 Viruses Viruses 59.7 2.33e-8   NR YP_009336608.1 1922791 g5794 i0 43.3 0.995049504950495 67 37 98 1 4 201 849 915 YP_009336608.1 hypothetical protein [Changjiang picorna-like virus 2] diamond 201 59.7 1 Viruses               Changjiang picorna-like virus 2
29158362 29158362 PRJNA195897_P_NODE_9269_length_169_cov_0.866667_g9236_i0 PRJNA195897 9269 169 0.866667 1.46466723 Marnaviridae sp. 2715102 Viruses Viruses 57.8 6.94e-8   NR ULG00022.1 2715102 g9236 i0 38.9 1.91715976331361 54 33 95.9 0 7 168 530 583 ULG00022.1 MAG: putative polyprotein [Marnaviridae sp.] diamond 324 57.8 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae sp.
29599954 29599954 PRJNA195897_P_NODE_6730_length_191_cov_1.098592_g6697_i0 PRJNA195897 6730 191 1.098592 2.09831072 uncultured virus 340016 Viruses Viruses 47.8 1.98e-4   NR CAH6421098.1 340016 g6697 i0 36.1 0.958115183246073 61 39 95.8 0 190 8 76 136 CAH6421098.1 2-5 RNA ligase superfamily [uncultured virus] diamond 183 47.8 1 Viruses               uncultured virus
32002181 32002181 PRJNA195897_P_NODE_10218_length_167_cov_0.872881_g10185_i0 PRJNA195897 10218 167 0.872881 1.45771127 Flamingopox virus FGPVKD 503979 Viruses Viruses 54.7 8.06e-7   NR YP_009448168.1 2059380 g10185 i0 55.3 8.60479041916168 47 21 84.4 0 27 167 156 202 YP_009448168.1 ankyrin repeat family protein [Flamingopox virus FGPVKD09] diamond 1437 54.7 1 Viruses   Bamfordvirae Nucleocytoviricota Pokkesviricetes Chitovirales Poxviridae Avipoxvirus Flamingopox virus FGPVKD09

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