RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA800053" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 13 ✖

bioproject 1

  • PRJNA800053 · 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
21198689 21198689 PRJNA800053_P_NODE_3537_length_470_cov_3.866499_g3374_i0 PRJNA800053 3537 470 3.866499 18.1725453 Tolivirales sp. 2809914 Viruses Viruses 227 7.729999999999999e-66   NR WRQ65272.1 2809914 g3374 i0 66.5 0.98936170212766 155 52 98.9 0 467 3 98 252 WRQ65272.1 polyprotein [Tolivirales sp.] diamond 465 227 1 Viruses   Orthornavirae Kitrinoviricota Tolucaviricetes Tolivirales     Tolivirales sp.
27180240 27180240 PRJNA800053_P_NODE_12382_length_284_cov_1.639810_g12218_i0 PRJNA800053 12382 284 1.63981 4.6570604 Patatavirales sp. 2809655 Viruses Viruses 51.6 4.7e-5   NR WRQ64757.1 2809655 g12218 i0 32.3 1.61619718309859 96 51 94 3 269 3 544 632 WRQ64757.1 polyprotein 2 [Patatavirales sp.] diamond 459 51.6 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales     Patatavirales sp.
27338688 27338688 PRJNA800053_P_NODE_2323_length_565_cov_2.894309_g2166_i0 PRJNA800053 2323 565 2.894309 16.35284585 African cichlid piscichuvirus 3065075 Viruses Viruses 92 8.18e-18   NR WLN26256.1 3065075 g2166 i0 50 0.488495575221239 92 46 48.8 0 264 539 229 320 WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus] diamond 276 92 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Jingchuvirales Chuviridae Piscichuvirus African cichlid piscichuvirus
28412181 28412181 PRJNA800053_P_NODE_4586_length_420_cov_3.293948_g4423_i0 PRJNA800053 4586 420 3.293948 13.8345816 Tolivirales sp. 2809914 Viruses Viruses 197 1.6199999999999995e-55   NR WRQ65272.1 2809914 g4423 i0 68.8 0.985714285714286 138 32 98.6 1 5 418 451 577 WRQ65272.1 polyprotein [Tolivirales sp.] diamond 414 197 1 Viruses   Orthornavirae Kitrinoviricota Tolucaviricetes Tolivirales     Tolivirales sp.
28696460 28696460 PRJNA800053_P_NODE_7827_length_339_cov_2.563910_g7663_i0 PRJNA800053 7827 339 2.56391 8.6916549 Skomarfal virus 4 3063437 Viruses Viruses 53.1 2.51e-5   NR WPR18392.1 3063109 g7663 i0 34.5 0.743362831858407 84 54 73.5 1 250 2 546 629 WPR18392.1 MAG: hypothetical protein, partial [Skomarfal virus 40] diamond 252 53.1 1 Viruses   Orthornavirae Kitrinoviricota Tolucaviricetes Tolivirales Tombusviridae   Skomarfal virus 40
29517049 29517049 PRJNA800053_P_NODE_25230_length_204_cov_5.656489_g25066_i0 PRJNA800053 25230 204 5.656489 11.53923756 Tolivirales sp. 2809914 Viruses Viruses 105 1.07e-24   NR WRQ64995.1 2809914 g25066 i0 70.3 1.88235294117647 64 19 94.1 0 12 203 1 64 WRQ64995.1 structural protein [Tolivirales sp.] diamond 384 105 1 Viruses   Orthornavirae Kitrinoviricota Tolucaviricetes Tolivirales     Tolivirales sp.
29737950 29737950 PRJNA800053_P_NODE_16710_length_254_cov_2.817680_g16546_i0 PRJNA800053 16710 254 2.81768 7.1569072 Tolivirales sp. 2809914 Viruses Viruses 117 1.72e-28   NR WRQ65272.1 2809914 g16546 i0 66.3 0.980314960629921 83 24 98 1 5 253 249 327 WRQ65272.1 polyprotein [Tolivirales sp.] diamond 249 117 1 Viruses   Orthornavirae Kitrinoviricota Tolucaviricetes Tolivirales     Tolivirales sp.
29864496 29864496 PRJNA800053_P_NODE_12591_length_282_cov_4.110048_g12427_i0 PRJNA800053 12591 282 4.110048 11.59033536 Tolivirales sp. 2809914 Viruses Viruses 120 2.95e-29   NR WRQ65272.1 2809914 g12427 i0 59.1 0.98936170212766 93 38 98.9 0 4 282 702 794 WRQ65272.1 polyprotein [Tolivirales sp.] diamond 279 120 1 Viruses   Orthornavirae Kitrinoviricota Tolucaviricetes Tolivirales     Tolivirales sp.
30527933 30527933 PRJNA800053_P_NODE_10113_length_306_cov_2.841202_g9949_i0 PRJNA800053 10113 306 2.841202 8.69407812 Tolivirales sp. 2809914 Viruses Viruses 138 2.44e-35   NR WRQ65272.1 2809914 g9949 i0 65.3 0.990196078431373 101 35 99 0 304 2 902 1002 WRQ65272.1 polyprotein [Tolivirales sp.] diamond 303 138 1 Viruses   Orthornavirae Kitrinoviricota Tolucaviricetes Tolivirales     Tolivirales sp.
31065371 31065371 PRJNA800053_P_NODE_11635_length_290_cov_1.783410_g11471_i0 PRJNA800053 11635 290 1.78341 5.171889 Nodamuvirales sp. 2809606 Viruses Viruses 68.2 7.6e-11   NR XKB76524.1 2809606 g11471 i0 41.9 0.76551724137931 74 43 76.6 0 4 225 850 923 XKB76524.1 MAG: methyltransferase, partial [Nodamuvirales sp.] diamond 222 68.2 1 Viruses   Orthornavirae Kitrinoviricota Magsaviricetes Nodamuvirales     Nodamuvirales sp.
32330678 32330678 PRJNA800053_P_NODE_9159_length_318_cov_2.693878_g8995_i0 PRJNA800053 9159 318 2.693878 8.56653204 Tolivirales sp. 2809914 Viruses Viruses 76.3 1.35e-13   NR WRQ65316.1 2809914 g8995 i0 40 0.990566037735849 105 63 99.1 0 316 2 48 152 WRQ65316.1 structural protein [Tolivirales sp.] diamond 315 76.3 1 Viruses   Orthornavirae Kitrinoviricota Tolucaviricetes Tolivirales     Tolivirales sp.
32362246 32362246 PRJNA800053_P_NODE_14039_length_272_cov_1.532663_g13875_i0 PRJNA800053 14039 272 1.532663 4.16884336 Picornaviridae sp. 1530251 Viruses Viruses 92.4 1.1e-19   NR URG14603.1 1530251 g13875 i0 52.8 1.94117647058824 89 41 98.2 1 4 270 154 241 URG14603.1 MAG: structural protein, partial [Picornaviridae sp.] diamond 528 92.4 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
32362248 32362248 PRJNA800053_P_NODE_24259_length_237_cov_3.408537_g24095_i0 PRJNA800053 24259 237 3.408537 8.07823269 Tolivirales sp. 2809914 Viruses Viruses 102 4.64e-23   NR WRQ65272.1 2809914 g24095 i0 64 0.949367088607595 75 27 94.9 0 5 229 565 639 WRQ65272.1 polyprotein [Tolivirales sp.] diamond 225 102 1 Viruses   Orthornavirae Kitrinoviricota Tolucaviricetes Tolivirales     Tolivirales sp.

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