RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJEB20058" and tax_phylum = "Phixviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Phixviricota · 16 ✖

tax_kingdom 1

bioproject 1

  • PRJEB20058 · 16 ✖

analysis 1

  • diamond · 16 ✖

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
25927458 25927458 PRJEB20058_P_NODE_30852_length_755_cov_8.430836_g28368_i0 PRJEB20058 30852 755 8.430836 63.6528118 Microvirus sp. 2202559 Viruses Viruses 132 1.0599999999999999e-34   NR QJB21229.1 2202559 g28368 i0 53.2 0.985430463576159 124 56 48.5 1 119 484 10 133 QJB21229.1 MAG: hypothetical protein [Microvirus sp.] diamond 744 132 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
32720016 32720016 PRJEB20058_S_NODE_60_length_1826_cov_5.503683_g58_i0 PRJEB20058 60 1826 5.503683 100.49725158 Ariapismic virus 2 3376436 Viruses Viruses 509 1.57e-173   NR XJW04221.1 3376436 g58 i0 55.7 0.690032858707557 420 182 68.3 3 1658 411 6 425 XJW04221.1 MAG: major capsid protein [Ariapismic virus 2] diamond 1260 509 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Ariapismic virus 2
32910343 32910343 PRJEB20058_P_NODE_100801_length_405_cov_8.037791_g97994_i0 PRJEB20058 100801 405 8.037791 32.55305355 Microvirus sp. 2202559 Viruses Viruses 77 1.33e-14   NR QJB21202.1 2202559 g97994 i0 56.1 0.977777777777778 66 29 48.9 0 311 114 68 133 QJB21202.1 MAG: hypothetical protein [Microvirus sp.] diamond 396 77 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
32962121 32962121 PRJEB20058_P_NODE_140938_length_327_cov_3.548872_g138117_i0 PRJEB20058 140938 327 3.548872 11.60481144 Microvirus sp. 2202559 Viruses Viruses 97.1 8.150000000000001e-21   NR QJB21192.1 2202559 g138117 i0 44.9 0.89908256880733906 98 52 89.9 1 294 1 349 444 QJB21192.1 MAG: major capsid protein [Microvirus sp.] diamond 294 97.1 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
32962756 32962756 PRJEB20058_P_NODE_31674_length_745_cov_10.862573_g29167_i0 PRJEB20058 31674 745 10.862573 80.92616885 Wigfec virus K19_83 2985970 Viruses Viruses 138 1.13e-37   NR UYD39172.1 2985970 g29167 i0 72.8 0.728859060402685 92 23 37 1 361 86 10 99 UYD39172.1 MAG: hypothetical protein [Wigfec virus K19_83] diamond 543 138 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Wigfec virus K19_83
32996115 32996115 PRJEB20058_P_NODE_148379_length_316_cov_2.337255_g145557_i0 PRJEB20058 148379 316 2.337255 7.3857258 Microviridae sp. 2202644 Viruses Viruses 49.7 3.07e-4   NR WNN13387.1 2202644 g145557 i0 34.6 0.740506329113924 78 51 74.1 0 266 33 240 317 WNN13387.1 MAG: major capsid protein [Microviridae sp.] diamond 234 49.7 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
32996828 32996828 PRJEB20058_P_NODE_54131_length_571_cov_9.539216_g51390_i0 PRJEB20058 54131 571 9.539216 54.46892336 Microviridae sp. 2202644 Viruses Viruses 70.5 2.18e-10   NR WAE43701.1 2202644 g51390 i0 83.8 1.2031523642732 37 6 19.4 0 441 551 1 37 WAE43701.1 MAG: major capsid protein [Microviridae sp.] diamond 687 70.5 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
33031148 33031148 PRJEB20058_P_NODE_68476_length_504_cov_2.981941_g65706_i0 PRJEB20058 68476 504 2.981941 15.02898264 Microviridae sp. 2202644 Viruses Viruses 74.7 6.42e-14   NR AXH73343.1 2202644 g65706 i0 44.4 0.482142857142857 81 39 44.6 1 252 476 7 87 AXH73343.1 MAG: hypothetical protein [Microviridae sp.] diamond 243 74.7 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
33031242 33031242 PRJEB20058_P_NODE_84068_length_450_cov_5.956298_g81280_i0 PRJEB20058 84068 450 5.956298 26.803341 Microvirus sp. 2202559 Viruses Viruses 120 1.8599999999999995e-31   NR QJB21202.1 2202559 g81280 i0 54.7 1.41333333333333 106 48 70.7 0 420 103 28 133 QJB21202.1 MAG: hypothetical protein [Microvirus sp.] diamond 636 120 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
33047910 33047910 PRJEB20058_P_NODE_41517_length_652_cov_20.961083_g38862_i0 PRJEB20058 41517 652 20.961083 136.66626116 Microvirus sp. 2202559 Viruses Viruses 182 1.02e-50   NR QJB21198.1 2202559 g38862 i0 56.7 2.89877300613497 157 60 70.9 3 26 487 394 545 QJB21198.1 MAG: major capsid protein [Microvirus sp.] diamond 1890 182 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
33065025 33065025 PRJEB20058_P_NODE_44477_length_630_cov_27.826011_g41798_i0 PRJEB20058 44477 630 27.826011 175.3038693 Microvirus sp. 2202559 Viruses Viruses 79.7 9.96e-15   NR QJB21229.1 2202559 g41798 i0 50.7 0.814285714285714 73 36 34.8 0 617 399 61 133 QJB21229.1 MAG: hypothetical protein [Microvirus sp.] diamond 513 79.7 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
33082319 33082319 PRJEB20058_P_NODE_7942_length_1499_cov_15.336579_g6706_i0 PRJEB20058 7942 1499 15.336579 229.89531921 Petitvirales sp. 2833078 Viruses Viruses 490 1.6299999999999999e-167   NR XOF02244.1 2833078 g6706 i0 84 0.562374916611074 281 45 56.2 0 1478 636 164 444 XOF02244.1 MAG: hypothetical protein [Petitvirales sp.] diamond 843 490 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales     Petitvirales sp.
33115534 33115534 PRJEB20058_P_NODE_154231_length_307_cov_130.833333_g151408_i0 PRJEB20058 154231 307 130.833333 401.65833231 Microviridae sp. 2202644 Viruses Viruses 131 1.26e-33   NR AXH77573.1 2202644 g151408 i0 65.9 2.48208469055375 85 29 83.1 0 24 278 420 504 AXH77573.1 MAG: major capsid protein [Microviridae sp.] diamond 762 131 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
33116467 33116467 PRJEB20058_P_NODE_91703_length_428_cov_17.869210_g88904_i0 PRJEB20058 91703 428 17.86921 76.4802188 Sedum sarmentosum microvirus 2740151 Viruses Viruses 141 4.239999999999999e-37   NR QKI28950.1 2740151 g88904 i0 59 1.60514018691589 122 46 84.1 2 415 56 85 204 QKI28950.1 VP4 [Sedum sarmentosum microvirus] diamond 687 141 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Sedum sarmentosum microvirus
33132604 33132604 PRJEB20058_P_NODE_137303_length_333_cov_4.323529_g134482_i0 PRJEB20058 137303 333 4.323529 14.39735157 Microvirus sp. 2202559 Viruses Viruses 75.5 2.87e-13   NR QJB21242.1 2202559 g134482 i0 42.9 0.945945945945946 105 55 91.9 3 26 331 180 282 QJB21242.1 MAG: replication initiator protein [Microvirus sp.] diamond 315 75.5 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
33161715 33161715 PRJEB20058_P_NODE_127096_length_351_cov_2.382759_g124277_i0 PRJEB20058 127096 351 2.382759 8.36348409 Viruses 10239 Viruses Viruses 171 4.459999999999999e-48   NR AXH76876.1 2202644 g124277 i0 68.9 5.47008547008547 106 33 90.6 0 26 343 97 202 AXH76876.1 MAG: major capsid protein [Microviridae sp.] diamond 1920 171 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae 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);;