RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJNA675331" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 12 ✖

tax_kingdom 1

bioproject 1

  • PRJNA675331 · 12 ✖

analysis 1

  • diamond · 12 ✖

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

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