RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJEB64798" and tax_clade = "unclassified ssRNA positive-strand viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • unclassified ssRNA positive-strand viruses · 17 ✖

bioproject 1

  • PRJEB64798 · 17 ✖

analysis 1

  • diamond · 17 ✖

tax_phylum 0

tax_kingdom 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
26773695 26773695 PRJEB64798_P_NODE_172741_length_177_cov_8.656250_g170975_i0 PRJEB64798 172741 177 8.65625 15.3215625 Negevirus 1307798 Viruses Viruses 56.6 1.94e-7   NR YP_009351835.1 1170422 g170975 i0 50.8 3 59 27 96.6 1 172 2 1504 1562 YP_009351835.1 hypothetical protein 1 [Loreto virus] diamond 531 56.6 1 Viruses unclassified ssRNA positive-strand viruses           Negevirus Loreto virus
26907315 26907315 PRJEB64798_P_NODE_70602_length_230_cov_4.331492_g68837_i0 PRJEB64798 70602 230 4.331492 9.9624316 Sclerophthora macrospora virus B 75914 Viruses Viruses 75.9 5.1e-14   NR NP_821131.1 75914 g68837 i0 52.8 0.939130434782609 72 34 93.9 0 6 221 47 118 NP_821131.1 coat protein [Sclerophthora macrospora virus B] diamond 216 75.9 1 Viruses unclassified ssRNA positive-strand viruses             Sclerophthora macrospora virus B
26970331 26970331 PRJEB64798_P_NODE_169822_length_179_cov_1.415385_g168056_i0 PRJEB64798 169822 179 1.415385 2.53353915 Sclerophthora macrospora virus A 191289 Viruses Viruses 87 2.92e-18   NR NP_995579.1 191289 g168056 i0 69 9.72067039106145 58 18 97.2 0 174 1 133 190 NP_995579.1 coat protein [Sclerophthora macrospora virus A] diamond 1740 87 1 Viruses unclassified ssRNA positive-strand viruses             Sclerophthora macrospora virus A
27760577 27760577 PRJEB64798_P_NODE_135064_length_196_cov_2.673469_g133298_i0 PRJEB64798 135064 196 2.673469 5.23999924 Weevil wasp positive-strand RNA virus 2 2848914 Viruses Viruses 53.5 3.21e-6   NR QWT43280.1 2848914 g133298 i0 47.3 0.841836734693878 55 28 82.7 1 7 168 1218 1272 QWT43280.1 polyprotein [Weevil wasp positive-strand RNA virus 2] diamond 165 53.5 1 Viruses unclassified ssRNA positive-strand viruses             Weevil wasp positive-strand RNA virus 2
28549977 28549977 PRJEB64798_P_NODE_5027_length_864_cov_16.168098_g3995_i0 PRJEB64798 5027 864 16.168098 139.69236672 Ohio negev-like virus 2 2789605 Viruses Viruses 48.9 0.0189   NR QPN36937.1 2789605 g3995 i0 41.5 0.225694444444444 65 37 22.6 1 585 779 97 160 QPN36937.1 RNA-dependent RNA polymerase [Ohio negev-like virus 2] diamond 195 48.9 1 Viruses unclassified ssRNA positive-strand viruses           Negevirus Ohio negev-like virus 2
28865370 28865370 PRJEB64798_P_NODE_187928_length_171_cov_3.409836_g186162_i0 PRJEB64798 187928 171 3.409836 5.83081956 Weevil wasp positive-strand RNA virus 2 2848914 Viruses Viruses 71.6 9e-13   NR QWT43280.1 2848914 g186162 i0 75 0.771929824561403 44 11 77.2 0 133 2 489 532 QWT43280.1 polyprotein [Weevil wasp positive-strand RNA virus 2] diamond 132 71.6 1 Viruses unclassified ssRNA positive-strand viruses             Weevil wasp positive-strand RNA virus 2
28921537 28921537 PRJEB64798_P_NODE_43828_length_297_cov_12.907258_g42063_i0 PRJEB64798 43828 297 12.907258 38.33455626 Viruses 10239 Viruses Viruses 75.1 3.05e-13   NR NP_821130.1 75914 g42063 i0 45.1 1.83838383838384 91 48 89.9 2 6 272 1165 1255 NP_821130.1 polyprotein [Sclerophthora macrospora virus B] diamond 546 75.1 1 Viruses unclassified ssRNA positive-strand viruses             Sclerophthora macrospora virus B
29275841 29275841 PRJEB64798_P_NODE_64829_length_241_cov_6.343750_g63064_i0 PRJEB64798 64829 241 6.34375 15.2884375 Sclerophthora macrospora virus B 75914 Viruses Viruses 78.6 6.3e-15   NR NP_821131.1 75914 g63064 i0 56 0.933609958506224 75 33 93.4 0 235 11 47 121 NP_821131.1 coat protein [Sclerophthora macrospora virus B] diamond 225 78.6 1 Viruses unclassified ssRNA positive-strand viruses             Sclerophthora macrospora virus B
30002334 30002334 PRJEB64798_P_NODE_214371_length_163_cov_12.122807_g212605_i0 PRJEB64798 214371 163 12.122807 19.76017541 Sclerophthora macrospora virus B 75914 Viruses Viruses 41.2 0.0438   NR NP_821130.1 75914 g212605 i0 36.8 1.04907975460123 57 30 93.9 1 9 161 614 670 NP_821130.1 polyprotein [Sclerophthora macrospora virus B] diamond 171 41.2 1 Viruses unclassified ssRNA positive-strand viruses             Sclerophthora macrospora virus B
30184773 30184773 PRJEB64798_P_NODE_3632_length_986_cov_14.092850_g2805_i0 PRJEB64798 3632 986 14.09285 138.955501 Negevirus 1307798 Viruses Viruses 94 1.13e-18   NR YP_009351837.1 1170422 g2805 i0 33.8 1.47565922920893 160 106 48.7 0 284 763 36 195 YP_009351837.1 hypothetical protein 3 [Loreto virus] diamond 1455 94 1 Viruses unclassified ssRNA positive-strand viruses           Negevirus Loreto virus
30381816 30381816 PRJEB64798_P_NODE_3993_length_952_cov_18.314507_g3117_i0 PRJEB64798 3993 952 18.314507 174.35410664 ssRNA positive-strand virus sp. 2835730 Viruses Viruses 115 2.07e-24   NR QVG74716.1 2835730 g3117 i0 32.5 2.46743697478992 268 171 82.6 3 847 62 178 441 QVG74716.1 hypothetical protein 2 [ssRNA positive-strand virus sp.] diamond 2349 115 1 Viruses unclassified ssRNA positive-strand viruses             ssRNA positive-strand virus sp.
30879894 30879894 PRJEB64798_P_NODE_374_length_2533_cov_15.354267_g256_i0 PRJEB64798 374 2533 15.354267 388.92358311 Negevirus 1307798 Viruses Viruses 341 1.25e-95   NR YP_009351835.1 1170422 g256 i0 30.3 2.00868535333597 837 523 95.7 23 2428 5 36 841 YP_009351835.1 hypothetical protein 1 [Loreto virus] diamond 5088 342 0.997076023391813 Viruses unclassified ssRNA positive-strand viruses           Negevirus Loreto virus
31163986 31163986 PRJEB64798_P_NODE_211375_length_164_cov_4.826087_g209609_i0 PRJEB64798 211375 164 4.826087 7.91478268 Viruses 10239 Viruses Viruses 67 3.48e-11   NR QCH41360.1 2575590 g209609 i0 56.6 1.9390243902439 53 23 97 0 5 163 95 147 QCH41360.1 VP4 [Haematobia irritans Nora virus] diamond 318 67 1 Viruses unclassified ssRNA positive-strand viruses             Haematobia irritans Nora virus
31487636 31487636 PRJEB64798_P_NODE_157876_length_184_cov_7.162963_g156110_i0 PRJEB64798 157876 184 7.162963 13.17985192 Weevil wasp positive-strand RNA virus 2 2848914 Viruses Viruses 88.2 1.68e-18   NR QWT43280.1 2848914 g156110 i0 61.7 0.978260869565217 60 23 97.8 0 181 2 2885 2944 QWT43280.1 polyprotein [Weevil wasp positive-strand RNA virus 2] diamond 180 88.2 1 Viruses unclassified ssRNA positive-strand viruses             Weevil wasp positive-strand RNA virus 2
31487676 31487676 PRJEB64798_P_NODE_18956_length_458_cov_6.498778_g17233_i0 PRJEB64798 18956 458 6.498778 29.76440324 Sclerophthora macrospora virus B 75914 Viruses Viruses 67.4 7.4e-10   NR NP_821131.1 75914 g17233 i0 40.7 0.563318777292576 86 49 56.3 1 451 194 286 369 NP_821131.1 coat protein [Sclerophthora macrospora virus B] diamond 258 67.4 1 Viruses unclassified ssRNA positive-strand viruses             Sclerophthora macrospora virus B
31930317 31930317 PRJEB64798_P_NODE_72717_length_226_cov_7.966102_g70952_i0 PRJEB64798 72717 226 7.966102 18.00339052 Soybean thrips nege-like virus 1 2802957 Viruses Viruses 43.1 0.023   NR QQP18763.1 2802957 g70952 i0 35.5 0.823008849557522 62 39 82.3 1 195 10 2321 2381 QQP18763.1 RNA-dependent RNA polymerase [Soybean thrips nege-like virus 1] diamond 186 43.1 1 Viruses unclassified ssRNA positive-strand viruses           Negevirus Soybean thrips nege-like virus 1
32056900 32056900 PRJEB64798_P_NODE_2718_length_1117_cov_16.821161_g2037_i0 PRJEB64798 2718 1117 16.821161 187.89236837 Castlerea virus 1969351 Viruses Viruses 101 3.57e-19   NR AQZ42313.1 1969351 g2037 i0 36.3 1.05282005371531 182 102 45.9 6 1117 605 856 1034 AQZ42313.1 ORF1 [Castlerea virus] diamond 1176 101 1 Viruses unclassified ssRNA positive-strand viruses           Negevirus Castlerea virus

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