RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "diamond", bioproject = "PRJNA1040136" and tax_phylum = "Phixviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Phixviricota · 14 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1040136 · 14 ✖

analysis 1

  • diamond · 14 ✖

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
15472565 15472565 PRJNA1040136_S_NODE_2213_length_254_cov_1.060773_g2210_i0 PRJNA1040136 2213 254 1.060773 2.69436342 Gokushovirinae sp. 2655021 Viruses Viruses 85.1 6.8e-18   NR QZQ78943.1 2655021 g2210 i0 57.1 0.992125984251969 84 36 99.2 0 2 253 11 94 QZQ78943.1 major capsid protein, partial [Gokushovirinae sp.] diamond 252 85.1 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Gokushovirinae sp.
26741889 26741889 PRJNA1040136_S_NODE_1861_length_268_cov_1.030769_g1858_i0 PRJNA1040136 1861 268 1.030769 2.76246092 Viruses 10239 Viruses Viruses 78.6 6.57e-15   NR WNK12595.1 2202559 g1858 i0 45.7 1.80223880597015 81 44 90.7 0 254 12 201 281 WNK12595.1 MAG: replication initiator protein [Microvirus sp.] diamond 483 78.6 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
26940122 26940122 PRJNA1040136_S_NODE_2122_length_257_cov_1.282609_g2119_i0 PRJNA1040136 2122 257 1.282609 3.29630513 Microviridae sp. ctKAt32 2656697 Viruses Viruses 147 8.72e-40   NR QGH73231.1 2656697 g2119 i0 81.7 1.93774319066148 82 15 95.7 0 256 11 137 218 QGH73231.1 MAG: major capsid protein [Microviridae sp. ctKAt32] diamond 498 147 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp. ctKAt32
28488076 28488076 PRJNA1040136_S_NODE_1987_length_263_cov_1.215789_g1984_i0 PRJNA1040136 1987 263 1.215789 3.19752507 Microvirus sp. 2202559 Viruses Viruses 123 8.149999999999998e-32   NR QJB19276.1 2202559 g1984 i0 91.7 0.684410646387833 60 5 68.4 0 84 263 1 60 QJB19276.1 MAG: replication initiator protein [Microvirus sp.] diamond 180 123 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
29687475 29687475 PRJNA1040136_S_NODE_1850_length_268_cov_1.661538_g1847_i0 PRJNA1040136 1850 268 1.661538 4.45292184 Microviridae sp. 2202644 Viruses Viruses 46.6 2.88e-4   NR AXH73126.1 2202644 g1847 i0 55 0.817164179104478 40 18 44.8 0 3 122 48 87 AXH73126.1 MAG: nonstructural protein [Microviridae sp.] diamond 219 46.6 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
29719090 29719090 PRJNA1040136_S_NODE_2730_length_241_cov_1.571429_g2727_i0 PRJNA1040136 2730 241 1.571429 3.78714389 Microvirus sp. 2202559 Viruses Viruses 82.4 1.43e-18   NR QJB19375.1 2202559 g2727 i0 65.5 0.721991701244813 58 20 72.2 0 1 174 21 78 QJB19375.1 MAG: nonstructural protein [Microvirus sp.] diamond 174 82.4 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
30035278 30035278 PRJNA1040136_S_NODE_851_length_336_cov_2.296578_g848_i0 PRJNA1040136 851 336 2.296578 7.71650208 Microvirus sp. 2202559 Viruses Viruses 192 1.73e-58   NR QJB19276.1 2202559 g848 i0 84.3 0.964285714285714 108 17 96.4 0 2 325 215 322 QJB19276.1 MAG: replication initiator protein [Microvirus sp.] diamond 324 192 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
30129660 30129660 PRJNA1040136_S_NODE_2672_length_242_cov_1.656805_g2669_i0 PRJNA1040136 2672 242 1.656805 4.0094681 Arizlama microvirus 2859450 Viruses Viruses 42.4 0.0261   NR QXP08365.1 2859450 g2669 i0 57.1 0.520661157024793 42 13 48.3 2 1 117 108 147 QXP08365.1 MAG: internal scaffolding protein [Arizlama microvirus] diamond 126 42.4 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Arizlama microvirus
30161349 30161349 PRJNA1040136_S_NODE_1472_length_287_cov_1.621495_g1469_i0 PRJNA1040136 1472 287 1.621495 4.65369065 Microvirus sp. 2202559 Viruses Viruses 77.8 2.48e-15   NR QJB19271.1 2202559 g1469 i0 54.1 0.888501742160279 85 31 86.8 2 286 38 109 187 QJB19271.1 MAG: DNA pilot protein [Microvirus sp.] diamond 255 77.8 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
30383177 30383177 PRJNA1040136_S_NODE_1293_length_298_cov_2.306667_g1290_i0 PRJNA1040136 1293 298 2.306667 6.87386766 Microvirus sp. 2202559 Viruses Viruses 54.3 3.54e-6   NR WNK12590.1 2202559 g1290 i0 51.6 0.644295302013423 64 31 64.4 0 296 105 87 150 WNK12590.1 MAG: DNA pilot protein [Microvirus sp.] diamond 192 54.3 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
30667105 30667105 PRJNA1040136_S_NODE_93_length_643_cov_3.114035_g90_i0 PRJNA1040136 93 643 3.114035 20.02324505 Microvirus sp. 2202559 Viruses Viruses 262 6.62e-84   NR WNK12595.1 2202559 g90 i0 66.1 0.881804043545879 189 58 87.7 2 582 19 1 184 WNK12595.1 MAG: replication initiator protein [Microvirus sp.] diamond 567 262 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
30698634 30698634 PRJNA1040136_S_NODE_1994_length_263_cov_1.168421_g1991_i0 PRJNA1040136 1994 263 1.168421 3.07294723 Microvirus sp. 2202559 Viruses Viruses 128 9.639999999999999e-34   NR QJB19276.1 2202559 g1991 i0 69 3.83269961977186 87 20 99.2 1 3 263 82 161 QJB19276.1 MAG: replication initiator protein [Microvirus sp.] diamond 1008 128 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
31615411 31615411 PRJNA1040136_S_NODE_576_length_386_cov_1.603834_g573_i0 PRJNA1040136 576 386 1.603834 6.19079924 Microviridae sp. 2202644 Viruses Viruses 130 4.78e-36   NR XOF03713.1 2202644 g573 i0 64.2 0.847150259067358 109 39 84.7 0 359 33 1 109 XOF03713.1 MAG: hypothetical protein, partial [Microviridae sp.] diamond 327 130 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
32619503 32619503 PRJNA1040136_S_NODE_2760_length_241_cov_0.916667_g2757_i0 PRJNA1040136 2760 241 0.916667 2.20916747 Viruses 10239 Viruses Viruses 139 1.3799999999999999e-38   NR QJB19040.1 2202559 g2757 i0 83.8 1.94190871369295 80 13 99.6 0 241 2 163 242 QJB19040.1 MAG: replication initiator protein [Microvirus sp.] diamond 468 140 0.992857142857143 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus 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);;