RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA358009" and tax_kingdom = "Heunggongvirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Heunggongvirae · 4 ✖

bioproject 1

  • PRJNA358009 · 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
26948183 26948183 PRJNA358009_P_NODE_7942_length_214_cov_4.745455_g7873_i0 PRJNA358009 7942 214 4.745455 10.1552737 Caudoviricetes sp. 2832643 Viruses Viruses 46.6 0.00111   NR DAH25884.1 2832643 g7873 i0 65.4 1.35981308411215 26 9 36.4 0 214 137 379 404 DAH25884.1 MAG TPA: large terminase [Caudoviricetes sp.] diamond 291 46.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27454282 27454282 PRJNA358009_P_NODE_16783_length_159_cov_4.727273_g16714_i0 PRJNA358009 16783 159 4.727273 7.51636407 Rhizobium phage RHph_TM26 2509758 Viruses Viruses 43.1 0.00432   NR QIG67116.1 2509758 g16714 i0 47.9 1.86792452830189 48 24 90.6 1 154 11 51 97 QIG67116.1 DUF4406 domain-containing protein [Rhizobium phage RHph_TM26] diamond 297 43.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Rhizobium phage RHph_TM26
27927705 27927705 PRJNA358009_P_NODE_9685_length_184_cov_5.281481_g9616_i0 PRJNA358009 9685 184 5.281481 9.71792504 Caudoviricetes sp. 2832643 Viruses Viruses 41.6 0.0443   NR DAL89344.1 2832643 g9616 i0 35.5 1.01086956521739 62 38 99.5 2 2 184 245 305 DAL89344.1 MAG TPA: tail sheath tube [Caudoviricetes sp.] diamond 186 41.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28748582 28748582 PRJNA358009_P_NODE_2167_length_328_cov_2.437276_g2104_i0 PRJNA358009 2167 328 2.437276 7.99426528 Caudoviricetes sp. 2832643 Viruses Viruses 43.5 0.0456   NR XOS02006.1 2832643 g2104 i0 59.4 0.292682926829268 32 11 29.3 1 229 324 181 210 XOS02006.1 MAG: hypothetical protein MSP1217_36 [Caudoviricetes sp.] diamond 96 43.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes 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);;