RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA1120203" and tax_phylum = "Phixviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Phixviricota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1120203 · 7 ✖

analysis 1

  • diamond · 7 ✖

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
1549395 1549395 PRJNA1120203_P_NODE_39422_length_364_cov_1.333333_g38407_i0 PRJNA1120203 39422 364 1.333333 4.85333212 Microviridae sp. 2202644 Viruses Viruses 143 2.07e-37   NR DAW35801.1 2202644 g38407 i0 52.9 5.9010989010989 119 56 98.1 0 359 3 126 244 DAW35801.1 MAG TPA: Replication associated protein [Microviridae sp.] diamond 2148 143 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
4101642 4101642 PRJNA1120203_P_NODE_14444_length_767_cov_2.125360_g13497_i0 PRJNA1120203 14444 767 2.12536 16.3015112 Microviridae sp. 2202644 Viruses Viruses 280 9.57e-90   NR DAH60082.1 2202644 g13497 i0 61.8 2.67535853976532 228 87 89.2 0 1 684 130 357 DAH60082.1 MAG TPA: DNA pilot protein VP2 [Microviridae sp.] diamond 2052 280 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
6652649 6652649 PRJNA1120203_P_NODE_34106_length_397_cov_2.200617_g33091_i0 PRJNA1120203 34106 397 2.200617 8.73644949 Microviridae sp. 2202644 Viruses Viruses 144 9.119999999999999e-40   NR DAU47700.1 2202644 g33091 i0 65.3 0.937027707808564 124 43 93.7 0 396 25 57 180 DAU47700.1 MAG TPA: DNA pilot protein VP2 [Microviridae sp.] diamond 372 144 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
28080691 28080691 PRJNA1120203_P_NODE_89485_length_247_cov_0.885057_g88469_i0 PRJNA1120203 89485 247 0.885057 2.18609079 Microviridae sp. 2202644 Viruses Viruses 100 2.48e-22   NR DAX05085.1 2202644 g88469 i0 72.3 0.789473684210526 65 18 78.9 0 247 53 258 322 DAX05085.1 MAG TPA: Major capsid protein [Microviridae sp.] diamond 195 100 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
29406847 29406847 PRJNA1120203_P_NODE_91029_length_246_cov_0.971098_g90013_i0 PRJNA1120203 91029 246 0.971098 2.38890108 Microviridae sp. 2202644 Viruses Viruses 144 1.2999999999999998e-38   NR DAF70985.1 2202644 g90013 i0 87.3 5.68292682926829 79 10 96.3 0 239 3 297 375 DAF70985.1 MAG TPA: Major capsid protein [Microviridae sp.] diamond 1398 144 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
29469720 29469720 PRJNA1120203_P_NODE_9610_length_1105_cov_1.270349_g8831_i0 PRJNA1120203 9610 1105 1.270349 14.03735645 bajarodmic virus 669 3344038 Viruses Viruses 128 9.829999999999999e-30   NR XHH69183.1 3344038 g8831 i0 35.6 0.876923076923077 323 137 75.2 8 268 1098 7 304 XHH69183.1 DNA pilot protein [bajarodmic virus 669] diamond 969 128 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae Microvirus bajarodmic virus 669
29912293 29912293 PRJNA1120203_P_NODE_54751_length_305_cov_1.327586_g53735_i0 PRJNA1120203 54751 305 1.327586 4.0491373 Microviridae sp. 2202644 Viruses Viruses 198 1.26e-58   NR AXH74328.1 2202644 g53735 i0 89.9 0.973770491803279 99 10 97.4 0 6 302 116 214 AXH74328.1 MAG: putative replication initiation protein [Microviridae sp.] diamond 297 198 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);;