RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJNA675331" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 22 ✖

bioproject 1

  • PRJNA675331 · 22 ✖

analysis 1

  • diamond · 22 ✖

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
3198699 3198699 PRJNA675331_P_NODE_3_length_8078_cov_5110.284447_g1_i0 PRJNA675331 3 8078 5110.284447 412808.77762866 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 1984 0   NR XCM68232.1 3003959 g1 i0 66.6 0.542584798217381 1461 400 54 4 7279 2915 3 1381 XCM68232.1 MAG: nonstructural polyprotein, partial [Picornavirales sp.] diamond 4383 1984 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
4475798 4475798 PRJNA675331_P_NODE_4_length_8078_cov_4540.552030_g1_i1 PRJNA675331 4 8078 4540.55203 366785.7929834 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 1982 0   NR XCM68232.1 3003959 g1 i1 66.5 0.542584798217381 1461 401 54 4 7279 2915 3 1381 XCM68232.1 MAG: nonstructural polyprotein, partial [Picornavirales sp.] diamond 4383 1982 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
5751356 5751356 PRJNA675331_P_NODE_5_length_7832_cov_5551.764274_g1_i2 PRJNA675331 5 7832 5551.764274 434814.17793968 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 2020 0   NR XCM68232.1 3003959 g1 i2 70.6 0.528217568947906 1379 400 52.6 3 7033 2915 3 1381 XCM68232.1 MAG: nonstructural polyprotein, partial [Picornavirales sp.] diamond 4137 2020 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
7026459 7026459 PRJNA675331_P_NODE_6_length_7661_cov_4903.854375_g1_i3 PRJNA675331 6 7661 4903.854375 375684.28366875 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 1984 0   NR XCM68232.1 3003959 g1 i3 66.6 0.572118522386111 1461 400 57 4 800 5164 3 1381 XCM68232.1 MAG: nonstructural polyprotein, partial [Picornavirales sp.] diamond 4383 1984 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
15197018 15197018 PRJNA675331_P_NODE_10992_length_303_cov_1.482609_g10820_i0 PRJNA675331 10992 303 1.482609 4.49230527 Terrestrivirus sp. 2487775 Viruses Viruses 94 6.18e-20   NR AYV75677.1 2487775 g10820 i0 52.6 1.57425742574257 78 37 77.2 0 2 235 263 340 AYV75677.1 MAG: putative AAA+ family ATPase [Terrestrivirus sp.] diamond 477 94 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae   Terrestrivirus sp.
27081933 27081933 PRJNA675331_P_NODE_2182_length_621_cov_1.826642_g2016_i0 PRJNA675331 2182 621 1.826642 11.34344682 Qianjiang picorna-like virus 1 3348691 Viruses Viruses 122 4.82e-28   NR XHA88608.1 3348697 g2016 i0 38 0.966183574879227 200 119 94.7 4 6 593 543 741 XHA88608.1 MAG: putative viral coat protein, partial [Qianjiang picorna-like virus 104] diamond 600 122 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Qianjiang picorna-like virus 104
27081935 27081935 PRJNA675331_P_NODE_382_length_1388_cov_6918.263118_g1_i5 PRJNA675331 382 1388 6918.263118 96025.49207784 Qianjiang picorna-like virus 1 3348691 Viruses Viruses 308 1.04e-92   NR XHA88608.1 3348697 g1 i5 47 0.791066282420749 366 180 77.4 6 1273 200 430 789 XHA88608.1 MAG: putative viral coat protein, partial [Qianjiang picorna-like virus 104] diamond 1098 308 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Qianjiang picorna-like virus 104
27682495 27682495 PRJNA675331_P_NODE_1304_length_789_cov_1.354749_g1152_i0 PRJNA675331 1304 789 1.354749 10.68896961 uncultured virus 340016 Viruses Viruses 62.4 4.16e-7   NR CAH6421701.1 340016 g1152 i0 24.1 0.916349809885932 241 142 88.2 6 739 44 109 317 CAH6421701.1 Hypothetical protein HVR_LOCUS1340 [uncultured virus] diamond 723 62.4 1 Viruses               uncultured virus
28661033 28661033 PRJNA675331_P_NODE_22047_length_244_cov_0.900585_g21875_i0 PRJNA675331 22047 244 0.900585 2.1974274 Fadolivirus algeromassiliense 3060017 Viruses Viruses 114 2.2300000000000003e-27   NR YP_010804150.1 3060017 g21875 i0 65 0.983606557377049 80 28 98.4 0 241 2 311 390 YP_010804150.1 ubiquitin-conjugating enzyme E2 [Fadolivirus algeromassiliense] diamond 240 114 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae Fadolivirus Fadolivirus algeromassiliense
28661035 28661035 PRJNA675331_P_NODE_2527_length_583_cov_2.252941_g2360_i0 PRJNA675331 2527 583 2.252941 13.13464603 Qianjiang dicistro-like virus 18 3347430 Viruses Viruses 53.1 2.17e-4   NR XHA87737.1 3347430 g2360 i0 33.1 1.79073756432247 157 70 67.9 10 518 123 621 767 XHA87737.1 MAG: putative viral coat protein [Qianjiang dicistro-like virus 18] diamond 1044 53.1 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Qianjiang dicistro-like virus 18
28692716 28692716 PRJNA675331_P_NODE_10887_length_304_cov_1.666667_g10715_i0 PRJNA675331 10887 304 1.666667 5.06666768 uncultured virus 340016 Viruses Viruses 82 9.3e-16   NR CAH6420746.1 340016 g10715 i0 48.1 0.799342105263158 81 42 79.9 0 244 2 155 235 CAH6420746.1 Hypothetical protein HVR_LOCUS1278 [uncultured virus] diamond 243 82 1 Viruses               uncultured virus
30398362 30398362 PRJNA675331_P_NODE_3993_length_472_cov_0.962406_g3821_i0 PRJNA675331 3993 472 0.962406 4.54255632 Qianjiang marna-like virus 93 3347744 Viruses Viruses 48.1 0.00529   NR XHA88212.1 3347744 g3821 i0 31.9 0.597457627118644 94 60 59.7 1 332 51 1945 2034 XHA88212.1 MAG: polyprotein [Qianjiang marna-like virus 93] diamond 282 48.1 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Qianjiang marna-like virus 93
30536035 30536035 PRJNA675331_P_NODE_5453_length_410_cov_1.124629_g5281_i0 PRJNA675331 5453 410 1.124629 4.6109789 root 1 Root_unresolved Root_unresolved 69.3 1.1e-11   NR CAH6421657.1 340016 g5281 i0 50.6 3.13170731707317 83 33 60 3 164 409 61 136 CAH6421657.1 TM2 domain protein [uncultured virus] diamond 1284 69.3 1 Viruses               uncultured virus
30555667 30555667 PRJNA675331_P_NODE_5513_length_408_cov_1.364179_g5341_i0 PRJNA675331 5513 408 1.364179 5.56585032 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 60.1 1.91e-7   NR QDH87969.1 3003959 g5341 i0 30.7 1.02941176470588 140 84 99.3 4 406 2 392 523 QDH87969.1 MAG: hypothetical protein H2Rhizo3345_000003 [Picornavirales sp.] diamond 420 60.1 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
30745436 30745436 PRJNA675331_P_NODE_6654_length_375_cov_1.274834_g6482_i0 PRJNA675331 6654 375 1.274834 4.7806275 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 112 6.74e-26   NR QDH87967.1 3003959 g6482 i0 57.8 0.72 90 38 72 0 9 278 1646 1735 QDH87967.1 MAG: RNA-dependent RNA polymerase [Picornavirales sp.] diamond 270 112 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
31409221 31409221 PRJNA675331_P_NODE_16_length_4540_cov_5551.614954_g1_i4 PRJNA675331 16 4540 5551.614954 252043.3189116 Qianjiang picorna-like virus 1 3348691 Viruses Viruses 742 3.949999999999999e-247   NR XHA88608.1 3348697 g1 i4 52.2 0.519383259911894 786 358 51.1 9 2020 4341 10 789 XHA88608.1 MAG: putative viral coat protein, partial [Qianjiang picorna-like virus 104] diamond 2358 742 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Qianjiang picorna-like virus 104
31610840 31610840 PRJNA675331_P_NODE_21376_length_245_cov_1.343023_g21204_i0 PRJNA675331 21376 245 1.343023 3.29040635 root 1 Root_unresolved Root_unresolved 74.3 1.91e-14   NR CAH6421657.1 340016 g21204 i0 53.4 1.81224489795918 73 31 88.2 2 30 245 73 143 CAH6421657.1 TM2 domain protein [uncultured virus] diamond 444 74.7 0.994645247657296 Viruses               uncultured virus
31725348 31725348 PRJNA675331_P_NODE_19437_length_249_cov_0.875000_g19265_i0 PRJNA675331 19437 249 0.875 2.17875 Powai lake megavirus 1842663 Viruses Viruses 88.6 1.75e-18   NR YP_010776183.1 1842663 g19265 i0 59.3 1.93975903614458 81 27 90.4 2 244 20 267 347 YP_010776183.1 hypothetical protein QJ849_gp270 [Powai lake megavirus] diamond 483 88.6 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae Megavirus Megavirus powaiense
31725352 31725352 PRJNA675331_P_NODE_23097_length_243_cov_0.876471_g22925_i0 PRJNA675331 23097 243 0.876471 2.12982453 Qianjiang dicistro-like virus 61 3347476 Viruses Viruses 129 9.999999999999999e-33   NR XHA87823.1 3347476 g22925 i0 72.8 1 81 22 100 0 243 1 1113 1193 XHA87823.1 MAG: polyprotein [Qianjiang dicistro-like virus 61] diamond 243 129 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Qianjiang dicistro-like virus 61
31788478 31788478 PRJNA675331_P_NODE_757_length_1023_cov_1.697895_g637_i0 PRJNA675331 757 1023 1.697895 17.36946585 clirnapec virus 81 3368406 Viruses Viruses 177 2.729999999999999e-47   NR XII42436.1 3368406 g637 i0 37.9 0.912023460410557 311 162 83.6 9 6 860 48 353 XII42436.1 MAG: peptidase A21 family protein [clirnapec virus 81] diamond 933 177 1 Viruses               clirnapec virus 81
31990255 31990255 PRJNA675331_P_NODE_11638_length_296_cov_1.035874_g11466_i0 PRJNA675331 11638 296 1.035874 3.06618704 Mimiviridae 549779 Viruses Viruses 174 5.75e-48   NR YP_004894608.1 1094892 g11466 i0 79.6 2.97972972972973 98 20 99.3 0 3 296 652 749 YP_004894608.1 putative regulator of chromosome condensation [Megavirus chiliensis] diamond 882 175 0.994285714285714 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae Megavirus Megavirus chilense
32453430 32453430 PRJNA675331_P_NODE_24319_length_241_cov_0.892857_g24147_i0 PRJNA675331 24319 241 0.892857 2.15178537 Achromobacter phage JWF 1589748 Viruses Viruses 111 3.87e-28   NR YP_009224035.1 1589748 g24147 i0 74.4 0.970954356846473 78 20 97.1 0 236 3 127 204 YP_009224035.1 hypothetical protein AXJ13_gp029 [Achromobacter phage JWF] diamond 234 111 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Achromobacter phage JWF

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