RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "diamond", bioproject = "PRJEB64798" 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

  • PRJEB64798 · 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
27159959 27159959 PRJEB64798_P_NODE_246122_length_153_cov_3.750000_g244356_i0 PRJEB64798 246122 153 3.75 5.7375 Microviridae sp. 2202644 Viruses Viruses 69.3 3.18e-12   NR AXH76119.1 2202644 g244356 i0 75 0.941176470588235 48 12 94.1 0 146 3 35 82 AXH76119.1 MAG: DNA pilot protein [Microviridae sp.] diamond 144 69.3 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
28100609 28100609 PRJEB64798_P_NODE_199045_length_167_cov_18.915254_g197279_i0 PRJEB64798 199045 167 18.915254 31.58847418 root 1 Root_unresolved Root_unresolved 47.8 2.27e-4   NR QJB19711.1 2202559 g197279 i0 55 1.34730538922156 40 18 71.9 0 2 121 118 157 QJB19711.1 MAG: major capsid protein [Microvirus sp.] diamond 225 48.1 0.993762993762994 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
28265323 28265323 PRJEB64798_P_NODE_179426_length_174_cov_11.512000_g177660_i0 PRJEB64798 179426 174 11.512 20.03088 Apis mellifera associated microvirus 49 2494779 Viruses Viruses 51.6 1.02e-5   NR AZL82869.1 2494779 g177660 i0 65.5 0.982758620689655 29 10 50 0 57 143 1 29 AZL82869.1 replication initiator protein [Apis mellifera associated microvirus 49] diamond 171 51.6 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Apis mellifera associated microvirus 49
28991971 28991971 PRJEB64798_P_NODE_131728_length_197_cov_10.695946_g129962_i0 PRJEB64798 131728 197 10.695946 21.07101362 Microviridae sp. 2202644 Viruses Viruses 51.6 1.18e-5   NR AXH76516.1 2202644 g129962 i0 67.6 0.517766497461929 34 11 51.8 0 102 1 198 231 AXH76516.1 MAG: DNA pilot protein [Microviridae sp.] diamond 102 51.6 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
29749230 29749230 PRJEB64798_P_NODE_231711_length_158_cov_3.532110_g229945_i0 PRJEB64798 231711 158 3.53211 5.5807338 Arizlama microvirus 2859450 Viruses Viruses 93.2 1.61e-22   NR QXP08621.1 2859450 g229945 i0 86 2.86708860759494 50 7 94.9 0 6 155 41 90 QXP08621.1 MAG: internal scaffolding protein [Arizlama microvirus] diamond 453 93.2 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Arizlama microvirus
30318601 30318601 PRJEB64798_P_NODE_117712_length_207_cov_12.715190_g115946_i0 PRJEB64798 117712 207 12.71519 26.3204433 Microviridae sp. 2202644 Viruses Viruses 84.7 3.49e-17   NR WXW90121.1 2202644 g115946 i0 71.7 1.56521739130435 53 15 76.8 0 160 2 442 494 WXW90121.1 MAG: capsid protein [Microviridae sp.] diamond 324 84.7 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
30413143 30413143 PRJEB64798_P_NODE_142513_length_192_cov_3.748252_g140747_i0 PRJEB64798 142513 192 3.748252 7.19664384 Microviridae sp. 2202644 Viruses Viruses 100 7.839999999999999e-23   NR AXH76777.1 2202644 g140747 i0 84.5 0.90625 58 8 90.6 1 177 4 363 419 AXH76777.1 MAG: major capsid protein [Microviridae sp.] diamond 174 100 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
31202425 31202425 PRJEB64798_P_NODE_64515_length_242_cov_3.295337_g62750_i0 PRJEB64798 64515 242 3.295337 7.97471554 Microvirus sp. 2202559 Viruses Viruses 136 3.8399999999999995e-37   NR QJB19245.1 2202559 g62750 i0 81 0.979338842975207 79 15 97.9 0 1 237 62 140 QJB19245.1 MAG: replication initiator protein [Microvirus sp.] diamond 237 136 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
31360990 31360990 PRJEB64798_P_NODE_119856_length_206_cov_8.394904_g118090_i0 PRJEB64798 119856 206 8.394904 17.29350224 Microviridae sp. 2202644 Viruses Viruses 48.5 1.98e-4   NR XOE95391.1 2202644 g118090 i0 65.8 0.553398058252427 38 13 55.3 0 2 115 67 104 XOE95391.1 MAG: replication initiation protein [Microviridae sp.] diamond 114 48.5 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
31677112 31677112 PRJEB64798_P_NODE_160077_length_183_cov_5.716418_g158311_i0 PRJEB64798 160077 183 5.716418 10.46104494 Ariapismic virus 59 3376564 Viruses Viruses 52.8 2.43e-6   NR XJW04579.1 3376564 g158311 i0 56 1.70491803278689 50 22 82 0 178 29 71 120 XJW04579.1 MAG: DNA pilot protein [Ariapismic virus 59] diamond 312 52.8 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Ariapismic virus 59
31803640 31803640 PRJEB64798_P_NODE_231477_length_158_cov_4.091743_g229711_i0 PRJEB64798 231477 158 4.091743 6.46495394 Microviridae sp. 2202644 Viruses Viruses 52 6.21e-6   NR AXH78097.1 2202644 g229711 i0 57.8 0.854430379746835 45 19 85.4 0 154 20 282 326 AXH78097.1 MAG: replication initiator protein [Microviridae sp.] diamond 135 52 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
32183541 32183541 PRJEB64798_P_NODE_211258_length_164_cov_5.252174_g209492_i0 PRJEB64798 211258 164 5.252174 8.61356536 Microvirus sp. 2202559 Viruses Viruses 69.7 2.73e-12   NR QJB19664.1 2202559 g209492 i0 63.3 1.77439024390244 49 18 89.6 0 3 149 159 207 QJB19664.1 MAG: replication initiator protein [Microvirus sp.] diamond 291 69.7 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
32246948 32246948 PRJEB64798_P_NODE_108598_length_210_cov_9.844720_g106832_i0 PRJEB64798 108598 210 9.84472 20.673912 Microviridae sp. 2202644 Viruses Viruses 42.4 0.0315   NR DAZ92349.1 2202644 g106832 i0 67.7 0.442857142857143 31 10 44.3 0 6 98 190 220 DAZ92349.1 TPA_asm: replication initiator protein [Microviridae sp.] diamond 93 42.4 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
32373584 32373584 PRJEB64798_P_NODE_94779_length_212_cov_4.404908_g93013_i0 PRJEB64798 94779 212 4.404908 9.33840496 Microviridae sp. 2202644 Viruses Viruses 114 7.960000000000001e-29   NR XOF05520.1 2202644 g93013 i0 71.3 2.26415094339623 80 13 99.1 1 210 1 154 233 XOF05520.1 MAG: replication initiation protein [Microviridae sp.] diamond 480 114 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);;