RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA561138" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 5 ✖

tax_phylum 1

tax_kingdom 1

bioproject 1

  • PRJNA561138 · 5 ✖

analysis 1

  • diamond · 5 ✖

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
27995140 27995140 PRJNA561138_P_NODE_9685_length_409_cov_1.273810_g9490_i0 PRJNA561138 9685 409 1.27381 5.2098829 Caudoviricetes sp. 2832643 Viruses Viruses 117 8.869999999999999e-31   NR XOR38101.1 2832643 g9490 i0 58.1 0.858190709046455 117 29 71.1 2 401 111 24 140 XOR38101.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 351 117 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29429570 29429570 PRJNA561138_P_NODE_20389_length_286_cov_1.103286_g20194_i0 PRJNA561138 20389 286 1.103286 3.15539796 root 1 Root_unresolved Root_unresolved 121 3.7599999999999997e-31   NR UVX42955.1 38018 g20194 i0 56.5 2.87412587412587 92 40 96.5 0 282 7 75 166 UVX42955.1 MAG: HNH endonuclease [Bacteriophage sp.] diamond 822 121 1 Viruses               Bacteriophage sp.
31437828 31437828 PRJNA561138_P_NODE_23676_length_257_cov_1.673913_g23481_i0 PRJNA561138 23676 257 1.673913 4.30195641 Rhizobium phage P11VFA 2763530 Viruses Viruses 78.6 6.97e-17   NR QNH72157.1 2763530 g23481 i0 47.6 1.91439688715953 84 39 92.2 2 250 14 4 87 QNH72157.1 hypothetical protein P11VFA_042 [Rhizobium phage P11VFA] diamond 492 78.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Rhizobium phage P11VFA
32860147 32860147 PRJNA561138_P_NODE_16680_length_321_cov_1.129032_g16485_i0 PRJNA561138 16680 321 1.129032 3.62419272 Vibrio phage 2.275.O._1 1881285 Viruses Viruses 65.9 5.84e-11   NR AUS02934.1 1881285 g16485 i0 38.4 0.682242990654206 73 45 68.2 0 1 219 65 137 AUS02934.1 NUDIX domain protein [Vibrio phage 2.275.O._10N.286.54.E11] diamond 219 65.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Vibrio phage 2.275.O._10N.286.54.E11
32891523 32891523 PRJNA561138_P_NODE_28320_length_244_cov_0.900585_g28125_i0 PRJNA561138 28320 244 0.900585 2.1974274 Aphanizomenon phage Yong-DA 2932864 Viruses Viruses 137 2.7199999999999997e-35   NR UOX39762.1 2932864 g28125 i0 82.7 0.995901639344262 81 14 99.6 0 244 2 40 120 UOX39762.1 dockerin domain-containing protein [Aphanizomenon phage Yong-DA] diamond 243 137 1 Viruses               Aphanizomenon phage Yong-DA

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);;