RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA315314" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 20 ✖

tax_kingdom 1

bioproject 1

  • PRJNA315314 · 20 ✖

analysis 1

  • diamond · 20 ✖

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
26631226 26631226 PRJNA315314_S_NODE_7721_length_290_cov_7.164751_g7400_i0 PRJNA315314 7721 290 7.164751 20.7777779 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 174 4.269999999999999e-48   NR XCM68434.1 3003959 g7400 i0 89.6 0.993103448275862 96 10 99.3 0 288 1 315 410 XCM68434.1 MAG: structural polyprotein [Picornavirales sp.] diamond 288 174 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
26757683 26757683 PRJNA315314_S_NODE_15421_length_208_cov_9.100559_g15100_i0 PRJNA315314 15421 208 9.100559 18.92916272 Chemarfal virus 132 3062909 Viruses Viruses 87.8 3.09e-18   NR WPR18001.1 3062909 g15100 i0 57.1 1.875 63 27 90.9 0 200 12 282 344 WPR18001.1 MAG: structural polyprotein [Chemarfal virus 132] diamond 390 87.8 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Chemarfal virus 132
26916129 26916129 PRJNA315314_S_NODE_2122_length_538_cov_12.381139_g1835_i0 PRJNA315314 2122 538 12.381139 66.61052782 Marnaviridae sp. 2715102 Viruses Viruses 230 2.69e-66   NR ULG00027.1 2715102 g1835 i0 61.5 2.76579925650558 174 63 97 1 2 523 597 766 ULG00027.1 MAG: hypothetical protein 1 [Marnaviridae sp.] diamond 1488 230 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae sp.
27376629 27376629 PRJNA315314_S_NODE_23703_length_171_cov_8.098592_g23382_i0 PRJNA315314 23703 171 8.098592 13.84859232 Viruses 10239 Viruses Viruses 122 1.79e-30   NR ULF99969.1 2715102 g23382 i0 93 10 57 4 100 0 1 171 455 511 ULF99969.1 MAG: hypothetical protein 1 [Marnaviridae sp.] diamond 1710 122 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae sp.
27390577 27390577 PRJNA315314_S_NODE_4603_length_373_cov_8.593023_g4282_i0 PRJNA315314 4603 373 8.593023 32.05197579 Qianjiang marna-like virus 197 3347626 Viruses Viruses 192 4.659999999999999e-54   NR XHA88391.1 3347626 g4282 i0 72.6 0.997319034852547 124 34 99.7 0 372 1 680 803 XHA88391.1 MAG: polyprotein [Qianjiang marna-like virus 197] diamond 372 192 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Qianjiang marna-like virus 197
27706561 27706561 PRJNA315314_S_NODE_5364_length_346_cov_9.943218_g5043_i0 PRJNA315314 5364 346 9.943218 34.40353428 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 125 1.63e-30   NR XCM68434.1 3003959 g5043 i0 61.6 0.858381502890173 99 38 85.8 0 50 346 12 110 XCM68434.1 MAG: structural polyprotein [Picornavirales sp.] diamond 297 125 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
27958743 27958743 PRJNA315314_S_NODE_25325_length_166_cov_7.992701_g25004_i0 PRJNA315314 25325 166 7.992701 13.26788366 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 84.3 2.78e-17   NR XCM68434.1 3003959 g25004 i0 69.6 1.01204819277108 56 15 97.6 1 164 3 587 642 XCM68434.1 MAG: structural polyprotein [Picornavirales sp.] diamond 168 84.3 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
27990447 27990447 PRJNA315314_S_NODE_7165_length_301_cov_10.562500_g6844_i0 PRJNA315314 7165 301 10.5625 31.793125 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 85.1 9.95e-17   NR XCM68103.1 3003959 g6844 i0 43.8 0.956810631229236 96 53 95.7 1 300 13 338 432 XCM68103.1 MAG: nonstructural polyprotein, partial [Picornavirales sp.] diamond 288 85.1 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
28242752 28242752 PRJNA315314_S_NODE_31246_length_152_cov_4.308943_g30925_i0 PRJNA315314 31246 152 4.308943 6.54959336 Chemarfal virus 132 3062909 Viruses Viruses 45.8 8.82e-4   NR WPR18001.1 3062909 g30925 i0 50 0.868421052631579 44 21 84.9 1 22 150 120 163 WPR18001.1 MAG: structural polyprotein [Chemarfal virus 132] diamond 132 45.8 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Chemarfal virus 132
28337680 28337680 PRJNA315314_S_NODE_29226_length_156_cov_13.141732_g28905_i0 PRJNA315314 29226 156 13.141732 20.50110192 Picornaviridae sp. 1530251 Viruses Viruses 62 1.77e-9   NR URG14852.1 1530251 g28905 i0 54 0.961538461538462 50 23 96.2 0 155 6 201 250 URG14852.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.] diamond 150 62 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
28337690 28337690 PRJNA315314_S_NODE_6686_length_312_cov_9.911661_g6365_i0 PRJNA315314 6686 312 9.911661 30.92438232 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 105 6.190000000000001e-27   NR XCM68433.1 3003959 g6365 i0 57.1 0.807692307692308 84 36 80.8 0 3 254 40 123 XCM68433.1 MAG: hypothetical protein, partial [Picornavirales sp.] diamond 252 105 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
28369158 28369158 PRJNA315314_S_NODE_4526_length_376_cov_8.610951_g4205_i0 PRJNA315314 4526 376 8.610951 32.37717576 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 83.6 8.4e-16   NR XCM68434.1 3003959 g4205 i0 67.3 0.438829787234043 55 18 43.9 0 371 207 820 874 XCM68434.1 MAG: structural polyprotein [Picornavirales sp.] diamond 165 83.6 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
29916561 29916561 PRJNA315314_S_NODE_4851_length_364_cov_10.889552_g4530_i0 PRJNA315314 4851 364 10.889552 39.63796928 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 194 3.789999999999999e-55   NR XCM68434.1 3003959 g4530 i0 72.3 0.980769230769231 119 33 98.1 0 3 359 636 754 XCM68434.1 MAG: structural polyprotein [Picornavirales sp.] diamond 357 194 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
30485113 30485113 PRJNA315314_S_NODE_11053_length_243_cov_8.742991_g10732_i0 PRJNA315314 11053 243 8.742991 21.24546813 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 116 5.26e-28   NR XCM68434.1 3003959 g10732 i0 65.4 1 81 28 100 0 243 1 488 568 XCM68434.1 MAG: structural polyprotein [Picornavirales sp.] diamond 243 116 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
30485140 30485140 PRJNA315314_S_NODE_28813_length_157_cov_6.328125_g28492_i0 PRJNA315314 28813 157 6.328125 9.93515625 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 86.7 3.92e-18   NR XCM68434.1 3003959 g28492 i0 75 0.993630573248408 52 13 99.4 0 1 156 403 454 XCM68434.1 MAG: structural polyprotein [Picornavirales sp.] diamond 156 86.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
31071446 31071446 PRJNA315314_S_NODE_19835_length_185_cov_13.217949_g19514_i0 PRJNA315314 19835 185 13.217949 24.45320565 Viruses 10239 Viruses Viruses 90.1 3.53e-19   NR UNY42173.1 1955153 g19514 i0 71.7 2.91891891891892 60 17 97.3 0 185 6 1423 1482 UNY42173.1 MAG: polyprotein, partial [Picornavirales sp.] diamond 540 90.1 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Picornavirales sp.
31988378 31988378 PRJNA315314_S_NODE_4678_length_370_cov_9.249267_g4357_i0 PRJNA315314 4678 370 9.249267 34.2222879 Viruses 10239 Viruses Viruses 160 6.739999999999999e-43   NR YP_009337755.1 1923378 g4357 i0 64.2 3.98918918918919 123 44 99.7 0 369 1 382 504 YP_009337755.1 hypothetical protein 1 [Sanxia picorna-like virus 9] diamond 1476 160 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Sanxia picorna-like virus 9
32160988 32160988 PRJNA315314_S_NODE_2418_length_508_cov_8.580376_g2115_i0 PRJNA315314 2418 508 8.580376 43.58831008 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 52.4 2.51e-4   NR XCM67860.1 3003959 g2115 i0 27.7 1.86614173228346 159 105 89.2 5 493 41 872 1028 XCM67860.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 948 52.4 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
32319285 32319285 PRJNA315314_S_NODE_13299_length_223_cov_12.886598_g12978_i0 PRJNA315314 13299 223 12.886598 28.73711354 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 125 3.0699999999999996e-31   NR XCM68434.1 3003959 g12978 i0 80 1.00896860986547 75 14 99.6 1 222 1 215 289 XCM68434.1 MAG: structural polyprotein [Picornavirales sp.] diamond 225 125 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
32715471 32715471 PRJNA315314_S_NODE_6040_length_328_cov_10.725753_g5719_i0 PRJNA315314 6040 328 10.725753 35.18046984 Viruses 10239 Viruses Viruses 80.5 5.93e-15   NR XCO49658.1 1955153 g5719 i0 44.6 1.51829268292683 83 43 73.2 1 241 2 446 528 XCO49658.1 MAG: putative ORF1 protein, partial [Picornavirales sp.] diamond 498 80.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Picornavirales sp.

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