RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA312107", tax_phylum = "Phixviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Viruses · 3 ✖

tax_phylum 1

  • Phixviricota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA312107 · 3 ✖

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
22054094 22054094 PRJNA312107_P_NODE_16338_length_181_cov_1.401515_g16172_i0 PRJNA312107 16338 181 1.401515 2.53674215 Microviridae sp. 2202644 Viruses Viruses 102 1.51e-17   NTclustered gi|2906146859|gb|PQ646284.1| 2202644 g16172 i0 77.174 1.01657458563536 184 36 100 4 1 181 126 306 MAG: Microviridae sp. isolate k127_129507 genomic sequence blastn 184 102 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microviridae sp.
24603646 24603646 PRJNA312107_P_NODE_20840_length_167_cov_0.881356_g20674_i0 PRJNA312107 20840 167 0.881356 1.47186452 Microvirus sp. 2202559 Viruses Viruses 93.5 8.25e-15   NTclustered gi|2581532851|gb|OR350130.1| 2202559 g20674 i0 86.047 1.01197604790419 86 12 51 0 24 109 1701 1786 MAG: Microvirus sp. isolate LSWO_128 clone LS363, complete genome blastn 169 93.5 1 Viruses   Sangervirae Phixviricota Malgrandaviricetes Petitvirales Microviridae   Microvirus sp.
30200412 30200412 PRJNA312107_P_NODE_25052_length_163_cov_0.912281_g24886_i0 PRJNA312107 25052 163 0.912281 1.48701803 Microvirus sp. 2202559 Viruses Viruses 53.1 7.61e-7   NR WNK14860.1 2202559 g24886 i0 52.9 1.84049079754601 51 18 93.9 1 5 157 82 126 WNK14860.1 MAG: internal scaffolding protein [Microvirus sp.] diamond 300 53.1 1 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);;