RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJEB6054" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_kingdom 2

tax_superkingdom 1

  • Viruses · 4 ✖

bioproject 1

  • PRJEB6054 · 4 ✖

analysis 1

  • diamond · 4 ✖

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
32928884 32928884 PRJEB6054_S_NODE_1969_length_307_cov_1.591912_g1880_i0 PRJEB6054 1969 307 1.591912 4.88716984 uncultured Caudovirales phage 2100421 Viruses Viruses 73.9 8.48e-13   NR CAB4121518.1 2100421 g1880 i0 60.3 0.615635179153095 63 21 57.7 1 305 129 543 605 CAB4121518.1 Bacteriophage lambda, GpH, tail tape measure, C-terminal [uncultured Caudovirales phage] diamond 189 73.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
33065356 33065356 PRJEB6054_S_NODE_1277_length_351_cov_5.357595_g1188_i0 PRJEB6054 1277 351 5.357595 18.80515845 Bunyaviricetes sp. 3240187 Viruses Viruses 69.3 6.48e-11   NR XKB76342.1 3240187 g1188 i0 54 0.538461538461538 63 29 53.8 0 346 158 608 670 XKB76342.1 MAG: RNA-dependent RNA polymerase, partial [Bunyaviricetes sp.] diamond 189 69.3 1 Viruses   Orthornavirae Negarnaviricota Bunyaviricetes       Bunyaviricetes sp.
33082514 33082514 PRJEB6054_S_NODE_8118_length_188_cov_7.745098_g8029_i0 PRJEB6054 8118 188 7.745098 14.56078424 Ripegrog virus 3130582 Viruses Viruses 106 3.89e-25   NR WZH59919.1 3130582 g8029 i0 78.3 0.957446808510638 60 13 95.7 0 4 183 303 362 WZH59919.1 MAG: RNA-dependent RNA polymerase, partial [Ripegrog virus] diamond 180 106 1 Viruses   Orthornavirae Negarnaviricota Ellioviricetes Bunyavirales     Ripegrog virus
33099535 33099535 PRJEB6054_S_NODE_54_length_806_cov_10.044099_g51_i0 PRJEB6054 54 806 10.044099 80.95543794 Bunyaviricetes sp. 3240187 Viruses Viruses 51.6 0.00263   NR XKB76342.1 3240187 g51 i0 30 0.521091811414392 140 82 50.2 3 586 182 20 148 XKB76342.1 MAG: RNA-dependent RNA polymerase, partial [Bunyaviricetes sp.] diamond 420 51.6 1 Viruses   Orthornavirae Negarnaviricota Bunyaviricetes       Bunyaviricetes 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);;