RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA661142" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 6 ✖

tax_phylum 1

tax_kingdom 1

bioproject 1

  • PRJNA661142 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
14657047 14657047 PRJNA661142_P_NODE_10232_length_208_cov_1.603774_g10167_i0 PRJNA661142 10232 208 1.603774 3.33584992 Pseudomonas phage ZRG1 3032262 Viruses Viruses 125 2.8099999999999997e-35   NR WID42129.1 3032262 g10167 i0 88.2 0.980769230769231 68 8 98.1 0 204 1 12 79 WID42129.1 baseplate assembly protein W [Pseudomonas phage ZRG1] diamond 204 125 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Pseudomonas phage ZRG1
26701398 26701398 PRJNA661142_P_NODE_11901_length_165_cov_0.879310_g11836_i0 PRJNA661142 11901 165 0.87931 1.4508615 Myoviridae sp. ctThM1 2656730 Viruses Viruses 64.3 3.03e-10   NR QGH72520.1 2656730 g11836 i0 76.3 0.690909090909091 38 9 69.1 0 3 116 379 416 QGH72520.1 MAG: DNA polymerase I [Myoviridae sp. ctThM1] diamond 114 64.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Myoviridae sp. ctThM1
29291877 29291877 PRJNA661142_P_NODE_11409_length_167_cov_0.864407_g11344_i0 PRJNA661142 11409 167 0.864407 1.44355969 uncultured Caudovirales phage 2100421 Viruses Viruses 45.4 4.51e-4   NR CAB5214299.1 2100421 g11344 i0 48.9 1.45508982035928 45 23 80.8 0 165 31 76 120 CAB5214299.1 hypothetical protein UFOVP190_46 [uncultured Caudovirales phage] diamond 243 45.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
29355184 29355184 PRJNA661142_P_NODE_3709_length_408_cov_1.136490_g3645_i0 PRJNA661142 3709 408 1.13649 4.6368792 Caudoviricetes sp. 2832643 Viruses Viruses 72.8 6.97e-12   NR XOS04929.1 2832643 g3645 i0 41.1 0.786764705882353 107 54 72.1 3 33 326 3 109 XOS04929.1 MAG: hypothetical protein MSP1124_12 [Caudoviricetes sp.] diamond 321 72.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29796975 29796975 PRJNA661142_P_NODE_4471_length_368_cov_10.050157_g4406_i0 PRJNA661142 4471 368 10.050157 36.98457776 Caudoviricetes sp. 2832643 Viruses Viruses 136 1.0299999999999998e-37   NR XOS67955.1 2832643 g4406 i0 56.9 1.00271739130435 123 49 97.8 3 361 2 73 194 XOS67955.1 MAG: p53 [Caudoviricetes sp.] diamond 369 136 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30744919 30744919 PRJNA661142_P_NODE_10534_length_197_cov_1.722973_g10469_i0 PRJNA661142 10534 197 1.722973 3.39425681 Caudoviricetes sp. 2832643 Viruses Viruses 95.5 8.05e-22   NR DAW55533.1 2832643 g10469 i0 70.8 0.989847715736041 65 19 99 0 3 197 105 169 DAW55533.1 MAG TPA: S adenosylmethionine synthase [Caudoviricetes sp.] diamond 195 95.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);;