RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJNA781196" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 12 ✖

tax_kingdom 1

bioproject 1

  • PRJNA781196 · 12 ✖

analysis 1

  • diamond · 12 ✖

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
13513132 13513132 PRJNA781196_P_NODE_38911_length_286_cov_1.830986_g38534_i0 PRJNA781196 38911 286 1.830986 5.23661996 Hulunbuir tick virus 1 2972183 Viruses Viruses 172 2.66e-47   NR UYL95332.1 2972183 g38534 i0 83.2 0.996503496503496 95 16 99.7 0 286 2 3098 3192 UYL95332.1 MAG: polyprotein [Hulunbuir tick virus 1] diamond 285 172 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Hypoviridae   Hulunbuir tick virus 1
26610066 26610066 PRJNA781196_P_NODE_10321_length_499_cov_1.730047_g9945_i0 PRJNA781196 10321 499 1.730047 8.63293453 Exserohilum turcicum hypovirus 1 3229025 Viruses Viruses 217 5.9499999999999995e-62   NR XBY85566.1 3229025 g9945 i0 62 1.95991983967936 163 61 98 1 3 491 2615 2776 XBY85566.1 MAG: polyprotein [Exserohilum turcicum hypovirus 1] diamond 978 217 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Hypoviridae Hypovirus Exserohilum turcicum hypovirus 1
28569358 28569358 PRJNA781196_P_NODE_57407_length_248_cov_0.891429_g57030_i0 PRJNA781196 57407 248 0.891429 2.21074392 Poaceae Liege nepovirus A 2822470 Viruses Viruses 121 9.71e-30   NR YP_010840366.1 2822470 g57030 i0 68.4 0.919354838709677 76 24 91.9 0 242 15 1177 1252 YP_010840366.1 polyprotein [Poaceae Liege nepovirus A] diamond 228 121 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Nepovirus Nepovirus poaceae
28948523 28948523 PRJNA781196_P_NODE_14128_length_436_cov_3.181818_g13751_i0 PRJNA781196 14128 436 3.181818 13.87272648 Sobelivirales sp. 2809868 Viruses Viruses 77.4 1.84e-13   NR WRQ64935.1 2809868 g13751 i0 40 0.825688073394495 120 65 79.8 5 2 349 259 375 WRQ64935.1 structural protein, partial [Sobelivirales sp.] diamond 360 77.4 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Sobelivirales     Sobelivirales sp.
29232620 29232620 PRJNA781196_P_NODE_62209_length_245_cov_0.906977_g61832_i0 PRJNA781196 62209 245 0.906977 2.22209365 Poaceae Liege nepovirus A 2822470 Viruses Viruses 122 3.66e-30   NR YP_010840366.1 2822470 g61832 i0 74.7 1.01632653061224 83 19 99.2 2 2 244 1049 1131 YP_010840366.1 polyprotein [Poaceae Liege nepovirus A] diamond 249 122 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Nepovirus Nepovirus poaceae
29516506 29516506 PRJNA781196_P_NODE_59710_length_247_cov_0.896552_g59333_i0 PRJNA781196 59710 247 0.896552 2.21448344 Durnavirales sp. 2809355 Viruses Viruses 53.9 4.28e-6   NR WRQ64726.1 2809355 g59333 i0 36.3 1.94331983805668 80 50 96 1 242 6 98 177 WRQ64726.1 RNA-dependent RNA polymerase, partial [Durnavirales sp.] diamond 480 53.9 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales     Durnavirales sp.
29705633 29705633 PRJNA781196_P_NODE_33650_length_305_cov_1.008621_g33273_i0 PRJNA781196 33650 305 1.008621 3.07629405 Hulunbuir tick virus 1 2972183 Viruses Viruses 179 9.4e-50   NR UYL95332.1 2972183 g33273 i0 75.2 0.99344262295082 101 25 99.3 0 2 304 3386 3486 UYL95332.1 MAG: polyprotein [Hulunbuir tick virus 1] diamond 303 179 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Hypoviridae   Hulunbuir tick virus 1
30148071 30148071 PRJNA781196_P_NODE_31572_length_313_cov_1.300000_g31195_i0 PRJNA781196 31572 313 1.3 4.069 Sobelivirales sp. 2809868 Viruses Viruses 129 3.05e-33   NR WRQ64934.1 2809868 g31195 i0 63.1 0.987220447284345 103 37 98.7 1 312 4 147 248 WRQ64934.1 RNA-dependent RNA polymerase [Sobelivirales sp.] diamond 309 129 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Sobelivirales     Sobelivirales sp.
30338343 30338343 PRJNA781196_P_NODE_51592_length_252_cov_0.871508_g51215_i0 PRJNA781196 51592 252 0.871508 2.19620016 Beet ringspot virus 191547 Viruses Viruses 134 1.69e-34   NR NP_734032.2 191547 g51215 i0 75.6 1.95238095238095 82 20 97.6 0 2 247 451 532 NP_734032.2 NTP-binding domain [Beet ringspot virus] diamond 492 134 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Nepovirus Nepovirus betae
30969909 30969909 PRJNA781196_P_NODE_19934_length_378_cov_1.534426_g19557_i0 PRJNA781196 19934 378 1.534426 5.80013028 Sobelivirales sp. 2809868 Viruses Viruses 145 3.79e-39   NR WRQ64935.1 2809868 g19557 i0 61.7 0.952380952380952 120 44 94.4 2 17 373 114 232 WRQ64935.1 structural protein, partial [Sobelivirales sp.] diamond 360 145 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Sobelivirales     Sobelivirales sp.
31886756 31886756 PRJNA781196_P_NODE_817_length_1459_cov_3.401876_g689_i0 PRJNA781196 817 1459 3.401876 49.63337084 Hebei hypo-like virus 3 3401102 Viruses Viruses 437 1.2699999999999999e-133   NR XHY85258.1 3401102 g689 i0 64.2 1.99657299520219 327 112 66.2 2 1459 494 1722 2048 XHY85258.1 MAG: polyprotein, partial [Hebei hypo-like virus 3] diamond 2913 437 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Hypoviridae   Hebei hypo-like virus 3
32361662 32361662 PRJNA781196_P_NODE_39979_length_283_cov_1.414286_g39602_i0 PRJNA781196 39979 283 1.414286 4.00242938 Tomato black ring virus 12275 Viruses Viruses 150 1.18e-39   NR NP_958814.1 12275 g39602 i0 79.6 1.96113074204947 93 19 98.6 0 281 3 1123 1215 NP_958814.1 polyprotein [Tomato black ring virus] diamond 555 150 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Nepovirus Nepovirus nigranuli

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