RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA599208" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 13 ✖

tax_kingdom 1

bioproject 1

  • PRJNA599208 · 13 ✖

analysis 1

  • diamond · 13 ✖

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
26668131 26668131 PRJNA599208_P_NODE_9321_length_228_cov_1.863874_g9125_i0 PRJNA599208 9321 228 1.863874 4.24963272 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 112 9.28e-27   NR XCM67722.1 3003959 g9125 i0 67.1 0.960526315789474 73 24 96.1 0 2 220 1082 1154 XCM67722.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 219 112 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
26731327 26731327 PRJNA599208_P_NODE_9781_length_220_cov_1.142077_g9585_i0 PRJNA599208 9781 220 1.142077 2.5125694 Picornaviridae sp. 1530251 Viruses Viruses 61.2 8.38e-9   NR URG14535.1 1530251 g9585 i0 54.5 0.75 55 25 75 0 165 1 459 513 URG14535.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.] diamond 165 61.2 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
28185068 28185068 PRJNA599208_P_NODE_9546_length_224_cov_1.577540_g9350_i0 PRJNA599208 9546 224 1.57754 3.5336896 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 71.2 2.66e-12   NR XCM67722.1 3003959 g9350 i0 53.2 0.830357142857143 62 29 83 0 189 4 923 984 XCM67722.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 186 71.2 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
29827064 29827064 PRJNA599208_P_NODE_14191_length_168_cov_1.389313_g13995_i0 PRJNA599208 14191 168 1.389313 2.33404584 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 63.9 4.6e-10   NR QDH89621.1 3003959 g13995 i0 49.1 0.946428571428571 53 27 94.6 0 4 162 489 541 QDH89621.1 MAG: RNA-dependent RNA polymerase, partial [Picornavirales sp.] diamond 159 63.9 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
30142740 30142740 PRJNA599208_P_NODE_9472_length_225_cov_2.351064_g9276_i0 PRJNA599208 9472 225 2.351064 5.289894 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 146 1.22e-38   NR XCM67722.1 3003959 g9276 i0 85.3 1 75 11 100 0 225 1 506 580 XCM67722.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 225 146 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
30490703 30490703 PRJNA599208_P_NODE_11953_length_189_cov_1.960526_g11757_i0 PRJNA599208 11953 189 1.960526 3.70539414 Crogonang virus 47 3063018 Viruses Viruses 90.5 2.68e-19   NR WPR18236.1 3063018 g11757 i0 70.4 0.857142857142857 54 16 85.7 0 182 21 671 724 WPR18236.1 MAG: capsid protein [Crogonang virus 47] diamond 162 90.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Crogonang virus 47
30743399 30743399 PRJNA599208_P_NODE_13734_length_172_cov_1.111111_g13538_i0 PRJNA599208 13734 172 1.111111 1.91111092 Marnaviridae sp. 2715102 Viruses Viruses 65.9 1.02e-10   NR ULF99991.1 2715102 g13538 i0 60 0.959302325581395 55 22 95.9 0 7 171 2398 2452 ULF99991.1 MAG: hypothetical protein [Marnaviridae sp.] diamond 165 65.9 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae sp.
31565490 31565490 PRJNA599208_P_NODE_15456_length_158_cov_1.900826_g15260_i0 PRJNA599208 15456 158 1.900826 3.00330508 Picornaviridae sp. 1530251 Viruses Viruses 73.6 1.58e-13   NR URG14535.1 1530251 g15260 i0 68.6 0.968354430379747 51 15 94.9 1 1 150 322 372 URG14535.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.] diamond 153 73.6 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
31565491 31565491 PRJNA599208_P_NODE_15776_length_156_cov_1.336134_g15580_i0 PRJNA599208 15776 156 1.336134 2.08436904 Crogonang virus 58 3063050 Viruses Viruses 80.5 5.5e-16   NR WPR18299.1 3063050 g15580 i0 72.5 0.980769230769231 51 14 98.1 0 3 155 473 523 WPR18299.1 MAG: structural polyprotein, partial [Crogonang virus 58] diamond 153 80.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Crogonang virus 58
31641695 31641695 PRJNA599208_P_NODE_9256_length_229_cov_1.729167_g9060_i0 PRJNA599208 9256 229 1.729167 3.95979243 Viruses 10239 Viruses Viruses 107 1.58e-25   NR AUX13132.1 2080259 g9060 i0 71.2 3.83842794759825 73 21 95.6 0 9 227 285 357 AUX13132.1 hypothetical protein, partial [Blacklegged tick picorna-like virus 2] diamond 879 107 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Blacklegged tick picorna-like virus 2
31944672 31944672 PRJNA599208_P_NODE_5917_length_319_cov_1.535461_g5721_i0 PRJNA599208 5917 319 1.535461 4.89812059 Marnaviridae sp. 2715102 Viruses Viruses 161 2.3999999999999998e-43   NR ULG00020.1 2715102 g5721 i0 69.2 4.90909090909091 104 31 97.8 1 3 314 2684 2786 ULG00020.1 MAG: hypothetical protein [Marnaviridae sp.] diamond 1566 161 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae sp.
32293277 32293277 PRJNA599208_P_NODE_4419_length_393_cov_2.042135_g4225_i0 PRJNA599208 4419 393 2.042135 8.02559055 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 129 1.04e-31   NR XCM67722.1 3003959 g4225 i0 65.4 0.618320610687023 81 28 61.8 0 1 243 673 753 XCM67722.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 243 129 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
32829577 32829577 PRJNA599208_P_NODE_8560_length_243_cov_1.315534_g8364_i0 PRJNA599208 8560 243 1.315534 3.19674762 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 71.2 3.55e-12   NR XCM67722.1 3003959 g8364 i0 67.4 0.567901234567901 46 15 56.8 0 243 106 210 255 XCM67722.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 138 71.2 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3

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