RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

25 rows where analysis = "diamond", bioproject = "PRJNA599208" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 25 ✖

tax_kingdom 1

bioproject 1

  • PRJNA599208 · 25 ✖

analysis 1

  • diamond · 25 ✖

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
572294 572294 PRJNA599208_P_NODE_8261_length_250_cov_1.281690_g8065_i0 PRJNA599208 8261 250 1.28169 3.204225 Tolivirales sp. 2809914 Viruses Viruses 159 1.5599999999999999e-43   NR WRQ65630.1 2809914 g8065 i0 85.4 1.956 82 12 98.4 0 3 248 365 446 WRQ65630.1 polyprotein, partial [Tolivirales sp.] diamond 489 159 1 Viruses   Orthornavirae Kitrinoviricota Tolucaviricetes Tolivirales     Tolivirales sp.
23524556 23524556 PRJNA599208_P_NODE_11639_length_193_cov_1.416667_g11443_i0 PRJNA599208 11639 193 1.416667 2.73416731 Kadipiro virus 104580 Viruses Viruses 113 2.27e-27   NR WZI48451.1 104580 g11443 i0 82.8 0.994818652849741 64 11 99.5 0 2 193 1083 1146 WZI48451.1 MAG: VP1 protein [Kadipiro virus] diamond 192 113 1 Viruses   Orthornavirae Duplornaviricota Resentoviricetes Reovirales Sedoreoviridae Seadornavirus Seadornavirus kadipiroense
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
26699862 26699862 PRJNA599208_P_NODE_10401_length_210_cov_1.341040_g10205_i0 PRJNA599208 10401 210 1.34104 2.816184 Qianjiang tombus-like virus 232 3347905 Viruses Viruses 69.7 4.88e-12   NR XHA86950.1 3347905 g10205 i0 51.4 1 70 30 98.6 2 208 2 215 281 XHA86950.1 MAG: hypothetical protein [Qianjiang tombus-like virus 232] diamond 210 69.7 1 Viruses   Orthornavirae Kitrinoviricota Tolucaviricetes Tolivirales Tombusviridae   Qianjiang tombus-like virus 232
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.
26921718 26921718 PRJNA599208_P_NODE_3822_length_432_cov_2.594937_g3628_i0 PRJNA599208 3822 432 2.594937 11.21012784 Shahe picorna-like virus 1 1923439 Viruses Viruses 104 7.169999999999999e-23   NR YP_009336819.1 1923440 g3628 i0 40.8 0.986111111111111 142 73 97.9 2 423 1 960 1091 YP_009336819.1 hypothetical protein [Shahe picorna-like virus 10] diamond 426 104 1 Viruses               Shahe picorna-like virus 10
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
28501144 28501144 PRJNA599208_P_NODE_7107_length_279_cov_2.380165_g6911_i0 PRJNA599208 7107 279 2.380165 6.64066035 Shahe picorna-like virus 1 1923439 Viruses Viruses 93.2 1.13e-19   NR YP_009336819.1 1923440 g6911 i0 52.3 0.924731182795699 86 41 92.5 0 276 19 445 530 YP_009336819.1 hypothetical protein [Shahe picorna-like virus 10] diamond 258 93.2 1 Viruses               Shahe picorna-like virus 10
28564261 28564261 PRJNA599208_P_NODE_6867_length_286_cov_2.277108_g6671_i0 PRJNA599208 6867 286 2.277108 6.51252888 Shahe picorna-like virus 1 1923439 Viruses Viruses 50.1 1.69e-4   NR YP_009336819.1 1923440 g6671 i0 36.7 1.02797202797203 98 46 98.6 5 3 284 2445 2530 YP_009336819.1 hypothetical protein [Shahe picorna-like virus 10] diamond 294 50.1 1 Viruses               Shahe picorna-like virus 10
29227489 29227489 PRJNA599208_P_NODE_7629_length_265_cov_1.219298_g7433_i0 PRJNA599208 7629 265 1.219298 3.2311397 Shahe picorna-like virus 1 1923439 Viruses Viruses 93.2 8.81e-20   NR YP_009336819.1 1923440 g7433 i0 52.9 0.984905660377358 87 41 98.5 0 3 263 2323 2409 YP_009336819.1 hypothetical protein [Shahe picorna-like virus 10] diamond 261 93.2 1 Viruses               Shahe picorna-like virus 10
29524828 29524828 PRJNA599208_P_NODE_11830_length_191_cov_0.876623_g11634_i0 PRJNA599208 11830 191 0.876623 1.67434993 Viruses 10239 Viruses Viruses 113 2.9700000000000004e-27   NR APG77477.1 1923376 g11634 i0 83.9 2.92146596858639 62 10 97.4 0 3 188 2444 2505 APG77477.1 hypothetical protein, partial [Sanxia picorna-like virus 7] diamond 558 113 1 Viruses               Sanxia picorna-like virus 7
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
30679995 30679995 PRJNA599208_P_NODE_16713_length_150_cov_2.044248_g16517_i0 PRJNA599208 16713 150 2.044248 3.066372 Wenzhou picorna-like virus 34 1923620 Viruses Viruses 42.4 0.0143   NR APG78512.1 1923620 g16517 i0 100 0.34 17 0 34 0 95 145 287 303 APG78512.1 hypothetical protein 1 [Wenzhou picorna-like virus 34] diamond 51 42.4 1 Viruses               Wenzhou picorna-like virus 34
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
31913187 31913187 PRJNA599208_P_NODE_15097_length_161_cov_1.233871_g14901_i0 PRJNA599208 15097 161 1.233871 1.98653231 Qianjiang tombus-like virus 324 3348008 Viruses Viruses 64.3 1.42e-10   NR XHA87152.1 3348008 g14901 i0 67.4 0.857142857142857 46 14 83.9 1 135 1 197 242 XHA87152.1 MAG: hypothetical protein [Qianjiang tombus-like virus 324] diamond 138 64.3 1 Viruses   Orthornavirae Kitrinoviricota Tolucaviricetes Tolivirales Tombusviridae   Qianjiang tombus-like virus 324
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.
32134817 32134817 PRJNA599208_P_NODE_7438_length_270_cov_2.124464_g7242_i0 PRJNA599208 7438 270 2.124464 5.7360528 Shahe picorna-like virus 1 1923439 Viruses Viruses 50.4 1.03e-4   NR YP_009336819.1 1923440 g7242 i0 32.2 0.966666666666667 87 58 95.6 1 3 260 578 664 YP_009336819.1 hypothetical protein [Shahe picorna-like virus 10] diamond 261 50.4 1 Viruses               Shahe picorna-like virus 10
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
32735221 32735221 PRJNA599208_P_NODE_15040_length_161_cov_1.693548_g14844_i0 PRJNA599208 15040 161 1.693548 2.72661228 Shahe picorna-like virus 1 1923439 Viruses Viruses 56.6 1.55e-7   NR YP_009336819.1 1923440 g14844 i0 51 0.950310559006211 51 24 95 1 7 159 1878 1927 YP_009336819.1 hypothetical protein [Shahe picorna-like virus 10] diamond 153 56.6 1 Viruses               Shahe picorna-like virus 10
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);;