RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "diamond", bioproject = "PRJNA1134759" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_kingdom 2

tax_superkingdom 1

  • Viruses · 19 ✖

bioproject 1

  • PRJNA1134759 · 19 ✖

analysis 1

  • diamond · 19 ✖

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
18135930 18135930 PRJNA1134759_P_NODE_455_length_1728_cov_4.331722_g423_i0 PRJNA1134759 455 1728 4.331722 74.85215616 Viruses 10239 Viruses Viruses 161 5.76e-38   NR QXV86620.1 1955144 g423 i0 28.8 3.50347222222222 503 236 84.9 14 7 1473 441 835 QXV86620.1 capsid protein [Dicistroviridae sp.] diamond 6054 161 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.
26690486 26690486 PRJNA1134759_P_NODE_31241_length_301_cov_1.824561_g31065_i0 PRJNA1134759 31241 301 1.824561 5.49192861 brine shrimp arlivirus 9 2900384 Viruses Viruses 178 4.059999999999999e-52   NR UNI74140.1 2900384 g31065 i0 88 1.99335548172757 100 12 99.7 0 1 300 296 395 UNI74140.1 MAG: hypothetical protein [brine shrimp arlivirus 9] diamond 600 178 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Mononegavirales Lispiviridae Arlivirus brine shrimp arlivirus 9
26817371 26817371 PRJNA1134759_P_NODE_56501_length_242_cov_0.923077_g56325_i0 PRJNA1134759 56501 242 0.923077 2.23384634 Caudoviricetes sp. 2832643 Viruses Viruses 92.4 9.06e-22   NR XOR99885.1 2832643 g56325 i0 62.5 1.98347107438017 80 21 99.2 1 3 242 44 114 XOR99885.1 MAG: conserved phage structural protein [Caudoviricetes sp.] diamond 480 92.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27196602 27196602 PRJNA1134759_P_NODE_36902_length_282_cov_1.401914_g36726_i0 PRJNA1134759 36902 282 1.401914 3.95339748 Linepithema humile virus 1 1739631 Viruses Viruses 64.7 1.17e-9   NR UXD80065.1 1739631 g36726 i0 40.3 0.765957446808511 72 39 76.6 1 273 58 754 821 UXD80065.1 putative capsid protein [Linepithema humile virus 1] diamond 216 64.7 1 Viruses               Linepithema humile virus 1
27386610 27386610 PRJNA1134759_P_NODE_18483_length_374_cov_1.813953_g18307_i0 PRJNA1134759 18483 374 1.813953 6.78418422 Fusarium culmorum yue-like virus 1 3233859 Viruses Viruses 68.6 1.53e-10   NR XCO56027.1 3233859 g18307 i0 39.8 0.82620320855615 103 58 81 2 319 17 452 552 XCO56027.1 MAG: putative RNA-dependent RNA polymerase [Fusarium culmorum yue-like virus 1] diamond 309 68.6 1 Viruses   Orthornavirae Negarnaviricota Yunchangviricetes Goujianvirales Yueviridae   Fusarium culmorum yue-like virus 1
28302045 28302045 PRJNA1134759_P_NODE_33886_length_292_cov_0.904110_g33710_i0 PRJNA1134759 33886 292 0.90411 2.6400012 Dicistroviridae sp. 1955144 Viruses Viruses 75.1 2.85e-13   NR XCO49088.1 1955144 g33710 i0 33.3 0.986301369863014 96 64 98.6 0 290 3 403 498 XCO49088.1 MAG: putative ORF1 protein [Dicistroviridae sp.] diamond 288 75.1 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.
28428462 28428462 PRJNA1134759_P_NODE_48346_length_253_cov_2.177778_g48170_i0 PRJNA1134759 48346 253 2.177778 5.50977834 Erwinia phage vB_EamM_Kwan 1883374 Viruses Viruses 94 4.04e-20   NR YP_009278885.1 1883374 g48170 i0 52.4 0.99604743083004 84 40 99.6 0 253 2 204 287 YP_009278885.1 tail sheath [Erwinia phage vB_EamM_Kwan] diamond 252 94 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Chimalliviridae Wellingtonvirus Wellingtonvirus wellington
28796144 28796144 PRJNA1134759_P_NODE_13747_length_427_cov_1.974576_g13571_i0 PRJNA1134759 13747 427 1.974576 8.43143952 Cripavirus 144051 Viruses Viruses 164 4.999999999999998e-44   NR ULF99858.1 1955141 g13571 i0 51.8 16.8407494145199 141 68 99.1 0 426 4 13 153 ULF99858.1 MAG: hypothetical protein 2 [Cripavirus sp.] diamond 7191 165 0.993939393939394 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus sp.
28933623 28933623 PRJNA1134759_P_NODE_4568_length_697_cov_2.844551_g4413_i0 PRJNA1134759 4568 697 2.844551 19.82652047 Erwinia phage vB_EamM_ChrisDB 1883371 Viruses Viruses 174 3.83e-48   NR YP_009292758.1 1883371 g4413 i0 50 2.47489239598278 192 93 81.8 2 574 5 1 191 YP_009292758.1 internal head protein [Erwinia phage vB_EamM_ChrisDB] diamond 1725 174 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Chimalliviridae Machinavirus Erwinia phage vB_EamM_ChrisDB
29217938 29217938 PRJNA1134759_P_NODE_58669_length_227_cov_2.233766_g58493_i0 PRJNA1134759 58669 227 2.233766 5.07064882 brine shrimp arlivirus 9 2900384 Viruses Viruses 70.9 1.98e-12   NR UNI74143.1 2900384 g58493 i0 56 0.991189427312775 75 33 99.1 0 225 1 194 268 UNI74143.1 MAG: hypothetical protein [brine shrimp arlivirus 9] diamond 225 70.9 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Mononegavirales Lispiviridae Arlivirus brine shrimp arlivirus 9
29996402 29996402 PRJNA1134759_P_NODE_51171_length_249_cov_1.329545_g50995_i0 PRJNA1134759 51171 249 1.329545 3.31056705 Chuvivirus 2842604 Viruses Viruses 96.3 4.47e-21   NR WET19887.1 2842604 g50995 i0 61 1.97590361445783 82 32 98.8 0 248 3 261 342 WET19887.1 MAG: nucleoprotein [Freshwater turtle neural virus 1] diamond 492 96.3 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Jingchuvirales Chuviridae Chuvivirus Chuvivirus
30007347 30007347 PRJNA1134759_P_NODE_29271_length_309_cov_2.830508_g29095_i0 PRJNA1134759 29271 309 2.830508 8.74626972 Caudoviricetes sp. 2832643 Viruses Viruses 60.5 2.69e-8   NR XOS23766.1 2832643 g29095 i0 31.4 1.92233009708738 102 70 99 0 3 308 93 194 XOS23766.1 MAG: hypothetical protein MSP0020_13 [Caudoviricetes sp.] diamond 594 60.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30575622 30575622 PRJNA1134759_P_NODE_49773_length_251_cov_1.432584_g49597_i0 PRJNA1134759 49773 251 1.432584 3.59578584 Erwinia phage pEa_SNUABM_11 2859245 Viruses Viruses 111 2.29e-26   NR QXO09710.1 2859245 g49597 i0 64.6 1.91235059760956 79 28 94.4 0 246 10 46 124 QXO09710.1 hypothetical protein pEaSNUABM11_00286 [Erwinia phage pEa_SNUABM_11] diamond 480 111 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Chimalliviridae Wellingtonvirus Erwinia phage pEa_SNUABM_11
30955256 30955256 PRJNA1134759_P_NODE_23074_length_341_cov_1.746269_g22898_i0 PRJNA1134759 23074 341 1.746269 5.95477729 Dicistroviridae sp. 1955144 Viruses Viruses 103 3.9399999999999996e-23   NR QXV86620.1 1955144 g22898 i0 53.2 1.91788856304985 109 50 95 1 16 339 226 334 QXV86620.1 capsid protein [Dicistroviridae sp.] diamond 654 103 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.
30986779 30986779 PRJNA1134759_P_NODE_27434_length_318_cov_1.395918_g27258_i0 PRJNA1134759 27434 318 1.395918 4.43901924 Plasmopara viticola lesion associated Yue-like virus 3 2719591 Viruses Viruses 47 0.00302   NR QIP68029.1 2719591 g27258 i0 28.9 0.783018867924528 83 49 68.9 2 1 219 364 446 QIP68029.1 RNA-dependent RNA polymerase [Plasmopara viticola lesion associated Yue-like virus 3] diamond 249 47 1 Viruses               Plasmopara viticola lesion associated Yue-like virus 3
31050129 31050129 PRJNA1134759_P_NODE_54315_length_245_cov_0.906977_g54139_i0 PRJNA1134759 54315 245 0.906977 2.22209365 Microbacterium phage LeeroyJenkins 2593338 Viruses Viruses 61.6 2.96e-9   NR QDK01467.1 2593338 g54139 i0 57.4 1.2734693877551 47 20 57.6 0 168 28 6 52 QDK01467.1 acetyltransferase [Microbacterium phage LeeroyJenkins] diamond 312 61.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Microbacterium phage LeeroyJenkins
31587502 31587502 PRJNA1134759_P_NODE_36576_length_283_cov_1.485714_g36400_i0 PRJNA1134759 36576 283 1.485714 4.20457062 brine shrimp arlivirus 9 2900384 Viruses Viruses 164 2.24e-50   NR UNI74142.1 2900384 g36400 i0 84.9 0.985865724381625 93 14 98.6 0 1 279 23 115 UNI74142.1 MAG: hypothetical protein [brine shrimp arlivirus 9] diamond 279 164 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Mononegavirales Lispiviridae Arlivirus brine shrimp arlivirus 9
31871937 31871937 PRJNA1134759_P_NODE_27977_length_315_cov_2.314050_g27801_i0 PRJNA1134759 27977 315 2.31405 7.2892575 Cripavirus sp. 1955141 Viruses Viruses 94 9.02e-20   NR ULF99842.1 1955141 g27801 i0 46.7 1 105 52 96.2 2 313 11 326 430 ULF99842.1 MAG: hypothetical protein 2 [Cripavirus sp.] diamond 315 94 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus sp.
32410011 32410011 PRJNA1134759_P_NODE_6339_length_603_cov_2.928302_g6170_i0 PRJNA1134759 6339 603 2.928302 17.65766106 Erwinia phage pEa_SNUABM_11 2859245 Viruses Viruses 108 8.02e-24   NR QXO09483.1 2859245 g6170 i0 42.3 0.706467661691542 142 78 69.2 3 421 5 3 143 QXO09483.1 hypothetical protein pEaSNUABM11_00059 [Erwinia phage pEa_SNUABM_11] diamond 426 108 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Chimalliviridae Wellingtonvirus Erwinia phage pEa_SNUABM_11

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