RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

27 rows where analysis = "diamond", bioproject = "PRJNA909412" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_kingdom 2

tax_superkingdom 1

  • Viruses · 27 ✖

bioproject 1

  • PRJNA909412 · 27 ✖

analysis 1

  • diamond · 27 ✖

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
26707568 26707568 PRJNA909412_P_NODE_17181_length_151_cov_1.491071_g17040_i0 PRJNA909412 17181 151 1.491071 2.25151721 Kadipiro virus 104580 Viruses Viruses 90.9 1.11e-19   NR WZI48451.1 104580 g17040 i0 89.8 0.973509933774834 49 5 97.4 0 3 149 1137 1185 WZI48451.1 MAG: VP1 protein [Kadipiro virus] diamond 147 90.9 1 Viruses   Orthornavirae Duplornaviricota Resentoviricetes Reovirales Sedoreoviridae Seadornavirus Seadornavirus kadipiroense
26866455 26866455 PRJNA909412_P_NODE_8501_length_183_cov_1.166667_g8360_i0 PRJNA909412 8501 183 1.166667 2.13500061 Wenzhou picorna-like virus 34 1923620 Viruses Viruses 42.4 0.0232   NR APG78512.1 1923620 g8360 i0 100 0.278688524590164 17 0 27.9 0 104 154 287 303 APG78512.1 hypothetical protein 1 [Wenzhou picorna-like virus 34] diamond 51 42.4 1 Viruses               Wenzhou picorna-like virus 34
26897970 26897970 PRJNA909412_P_NODE_3981_length_264_cov_0.924444_g3840_i0 PRJNA909412 3981 264 0.924444 2.44053216 Picornaviridae sp. 1530251 Viruses Viruses 95.5 1.36e-20   NR URG14535.1 1530251 g3840 i0 56.5 0.965909090909091 85 30 96.6 1 10 264 393 470 URG14535.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.] diamond 255 95.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
27000043 27000043 PRJNA909412_P_NODE_4702_length_241_cov_1.643564_g4561_i0 PRJNA909412 4702 241 1.643564 3.96098924 Viruses 10239 Viruses Viruses 70.5 6.13e-12   NR YP_009336819.1 1923440 g4561 i0 52.9 1.64315352697095 68 32 84.6 0 212 9 413 480 YP_009336819.1 hypothetical protein [Shahe picorna-like virus 10] diamond 396 70.5 1 Viruses               Shahe picorna-like virus 10
27277427 27277427 PRJNA909412_P_NODE_3223_length_293_cov_2.515748_g3082_i0 PRJNA909412 3223 293 2.515748 7.37114164 Terrestrivirus sp. 2487775 Viruses Viruses 53.5 5.45e-6   NR AYV76183.1 2487775 g3082 i0 47.9 0.491467576791809 48 25 49.1 0 281 138 157 204 AYV76183.1 MAG: hypothetical protein Terrestrivirus5_5 [Terrestrivirus sp.] diamond 144 53.5 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae   Terrestrivirus sp.
27372436 27372436 PRJNA909412_P_NODE_8643_length_181_cov_2.415493_g8502_i0 PRJNA909412 8643 181 2.415493 4.37204233 clirnapec virus 3 3368302 Viruses Viruses 50.8 2.18e-5   NR XII42744.1 3368303 g8502 i0 58.5 0.679558011049724 41 17 68 0 5 127 211 251 XII42744.1 MAG: hypothetical protein [clirnapec virus 30] diamond 123 50.8 1 Viruses               clirnapec virus 30
27568939 27568939 PRJNA909412_P_NODE_9544_length_174_cov_1.540741_g9403_i0 PRJNA909412 9544 174 1.540741 2.68088934 Viruses 10239 Viruses Viruses 101 1.26e-23   NR QDH87395.1 2585031 g9403 i0 80.7 4.89655172413793 57 11 98.3 0 173 3 116 172 QDH87395.1 MAG: hypothetical protein H3Bulk42153_000002 [Riboviria sp.] diamond 852 101 1 Viruses               Riboviria sp.
27624868 27624868 PRJNA909412_P_NODE_5744_length_218_cov_1.843575_g5603_i0 PRJNA909412 5744 218 1.843575 4.0189935 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 90.9 3.04e-19   NR XCM67722.1 3003959 g5603 i0 56.3 0.977064220183486 71 31 97.7 0 2 214 939 1009 XCM67722.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 213 90.9 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
27751248 27751248 PRJNA909412_P_NODE_6504_length_206_cov_1.095808_g6363_i0 PRJNA909412 6504 206 1.095808 2.25736448 Tolivirales sp. 2809914 Viruses Viruses 63.9 7.78e-10   NR WRQ65280.1 2809914 g6363 i0 57.1 0.713592233009709 49 21 71.4 0 151 5 483 531 WRQ65280.1 polyprotein, partial [Tolivirales sp.] diamond 147 63.9 1 Viruses   Orthornavirae Kitrinoviricota Tolucaviricetes Tolivirales     Tolivirales sp.
27845585 27845585 PRJNA909412_P_NODE_5124_length_231_cov_1.578125_g4983_i0 PRJNA909412 5124 231 1.578125 3.64546875 Tolivirales sp. 2809914 Viruses Viruses 84.3 5.45e-18   NR WRQ66009.1 2809914 g4983 i0 58.8 1.77922077922078 68 26 87 2 229 29 147 213 WRQ66009.1 structural protein [Tolivirales sp.] diamond 411 84.3 1 Viruses   Orthornavirae Kitrinoviricota Tolucaviricetes Tolivirales     Tolivirales sp.
27877298 27877298 PRJNA909412_P_NODE_7905_length_189_cov_1.100000_g7764_i0 PRJNA909412 7905 189 1.1 2.079 Picornaviridae sp. 1530251 Viruses Viruses 85.5 1.54e-17   NR URG14535.1 1530251 g7764 i0 58.1 0.984126984126984 62 25 96.8 1 5 187 297 358 URG14535.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.] diamond 186 85.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
28130017 28130017 PRJNA909412_P_NODE_11345_length_170_cov_1.618321_g11204_i0 PRJNA909412 11345 170 1.618321 2.7511457 Shahe picorna-like virus 1 1923439 Viruses Viruses 57.8 6.94e-8   NR YP_009336819.1 1923440 g11204 i0 55.3 0.829411764705882 47 21 82.9 0 29 169 2009 2055 YP_009336819.1 hypothetical protein [Shahe picorna-like virus 10] diamond 141 57.8 1 Viruses               Shahe picorna-like virus 10
28224426 28224426 PRJNA909412_P_NODE_2386_length_345_cov_1.696078_g2246_i0 PRJNA909412 2386 345 1.696078 5.8514691 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 116 2.0500000000000003e-27   NR XCM67722.1 3003959 g2246 i0 66.2 0.617391304347826 71 24 61.7 0 2 214 683 753 XCM67722.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 213 116 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
28800171 28800171 PRJNA909412_P_NODE_1487_length_452_cov_3.285714_g1347_i0 PRJNA909412 1487 452 3.285714 14.85142728 Mimiviridae 549779 Viruses Viruses 67 4.28e-10   NR YP_010782374.1 2126985 g1347 i0 27.8 1.65929203539823 126 84 80.3 2 86 448 55 178 YP_010782374.1 hypothetical protein QJ857_gp0333 [Tupanvirus soda lake] diamond 750 67.4 0.99406528189911 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae Tupanvirus Tupanvirus salinum
29171989 29171989 PRJNA909412_P_NODE_8929_length_179_cov_1.192857_g8788_i0 PRJNA909412 8929 179 1.192857 2.13521403 Shahe picorna-like virus 1 1923439 Viruses Viruses 51.2 1.63e-5   NR YP_009336819.1 1923440 g8788 i0 41 1.02234636871508 61 32 97.2 3 178 5 881 940 YP_009336819.1 hypothetical protein [Shahe picorna-like virus 10] diamond 183 51.2 1 Viruses               Shahe picorna-like virus 10
29266382 29266382 PRJNA909412_P_NODE_12309_length_162_cov_2.195122_g12168_i0 PRJNA909412 12309 162 2.195122 3.55609764 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 75.5 3.47e-14   NR XCM67722.1 3003959 g12168 i0 64.2 0.981481481481482 53 18 98.1 1 3 161 1075 1126 XCM67722.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 159 75.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
29898194 29898194 PRJNA909412_P_NODE_3451_length_282_cov_3.946502_g3310_i0 PRJNA909412 3451 282 3.946502 11.12913564 Betacoronavirus pandemicum 3418604 Viruses Viruses 46.2 0.0032   NR 8XYZ_B 2697049 g3310 i0 79.2 0.25531914893617 24 5 25.5 0 208 279 2 25 8XYZ_B Chain B, Signal peptide, Spike protein S1 [Severe acute respiratory syndrome coronavirus 2] diamond 72 46.2 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
29898196 29898196 PRJNA909412_P_NODE_4671_length_241_cov_3.465347_g4530_i0 PRJNA909412 4671 241 3.465347 8.35148627 Edafosvirus sp. 2487765 Viruses Viruses 49.3 1.31e-4   NR AYV78538.1 2487765 g4530 i0 47.4 0.473029045643154 38 20 47.3 0 14 127 146 183 AYV78538.1 MAG: hypothetical protein Edafosvirus17_14 [Edafosvirus sp.] diamond 114 49.3 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae   Edafosvirus sp.
30435461 30435461 PRJNA909412_P_NODE_6233_length_210_cov_1.619883_g6092_i0 PRJNA909412 6233 210 1.619883 3.4017543 Marnaviridae sp. 2715102 Viruses Viruses 105 1.43e-24   NR ULG00020.1 2715102 g6092 i0 67.6 1.92857142857143 68 22 97.1 0 5 208 2704 2771 ULG00020.1 MAG: hypothetical protein [Marnaviridae sp.] diamond 405 105 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae sp.
30687820 30687820 PRJNA909412_P_NODE_6173_length_211_cov_1.819767_g6032_i0 PRJNA909412 6173 211 1.819767 3.83970837 Crogonang virus 58 3063050 Viruses Viruses 113 2.93e-27   NR WPR18299.1 3063050 g6032 i0 75.7 0.995260663507109 70 17 99.5 0 1 210 466 535 WPR18299.1 MAG: structural polyprotein, partial [Crogonang virus 58] diamond 210 113 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Crogonang virus 58
31256695 31256695 PRJNA909412_P_NODE_4015_length_263_cov_1.424107_g3874_i0 PRJNA909412 4015 263 1.424107 3.74540141 Crogonang virus 58 3063050 Viruses Viruses 132 2.24e-35   NR XII42581.1 3063050 g3874 i0 74.7 1.98479087452471 87 21 99.2 1 3 263 212 297 XII42581.1 MAG: capsid protein, partial [Crogonang virus 58] diamond 522 132 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Crogonang virus 58
31509938 31509938 PRJNA909412_P_NODE_9256_length_176_cov_2.423358_g9115_i0 PRJNA909412 9256 176 2.423358 4.26511008 Hubei tombus-like virus 8 1923295 Viruses Viruses 91.7 7.53e-20   NR YP_009336790.1 1923295 g9115 i0 75.9 0.988636363636364 58 14 98.9 0 3 176 396 453 YP_009336790.1 hypothetical protein 2 [Hubei tombus-like virus 8] diamond 174 91.7 1 Viruses               Hubei tombus-like virus 8
31699590 31699590 PRJNA909412_P_NODE_9697_length_173_cov_1.216418_g9556_i0 PRJNA909412 9697 173 1.216418 2.10440314 clirnapec virus 156 3368143 Viruses Viruses 85.5 1.24e-17   NR XII42844.1 3368143 g9556 i0 71.9 0.988439306358382 57 16 98.8 0 2 172 646 702 XII42844.1 MAG: capsid protein, partial [clirnapec virus 156] diamond 171 85.5 1 Viruses               clirnapec virus 156
32269213 32269213 PRJNA909412_P_NODE_18058_length_150_cov_1.495495_g17917_i0 PRJNA909412 18058 150 1.495495 2.2432425 Klosneuvirus KNV1 1977640 Viruses Viruses 62.8 8.59e-10   NR ARF12269.1 1977640 g17917 i0 62 1 50 18 98 1 2 148 274 323 ARF12269.1 ornithine decarboxylase [Klosneuvirus KNV1] diamond 150 62.8 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae Klosneuvirus Klosneuvirus KNV1
32585545 32585545 PRJNA909412_P_NODE_2299_length_351_cov_3.544872_g2159_i0 PRJNA909412 2299 351 3.544872 12.44250072 Betacoronavirus pandemicum 3418604 Viruses Viruses 46.2 0.00645   NR 8XYZ_B 2697049 g2159 i0 79.2 0.205128205128205 24 5 20.5 0 277 348 2 25 8XYZ_B Chain B, Signal peptide, Spike protein S1 [Severe acute respiratory syndrome coronavirus 2] diamond 72 46.2 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
32774143 32774143 PRJNA909412_P_NODE_8380_length_184_cov_1.503448_g8239_i0 PRJNA909412 8380 184 1.503448 2.76634432 Orchesella springtail adintovirus 2609862 Viruses Viruses 95.5 1.35e-22   NR DAC81369.1 2609862 g8239 i0 67.8 0.96195652173913 59 19 96.2 0 179 3 5 63 DAC81369.1 TPA_asm: FtsK [Orchesella springtail adintovirus] diamond 177 95.5 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Orchesella springtail adintovirus
32805682 32805682 PRJNA909412_P_NODE_14580_length_157_cov_1.406780_g14439_i0 PRJNA909412 14580 157 1.40678 2.2086446 Crogonang virus 58 3063050 Viruses Viruses 99.8 9.85e-23   NR XII42580.1 3063050 g14439 i0 84.6 1.98726114649682 52 8 99.4 0 2 157 38 89 XII42580.1 MAG: RNA-dependent RNA polymerase [Crogonang virus 58] diamond 312 99.8 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Crogonang virus 58

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