RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA534016" and tax_phylum = "Uroviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Uroviricota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA534016 · 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
26856560 26856560 PRJNA534016_P_NODE_19161_length_226_cov_2.771242_g19071_i0 PRJNA534016 19161 226 2.771242 6.26300692 Caudoviricetes sp. 2832643 Viruses Viruses 70.5 5.18e-12   NR XOR60197.1 2832643 g19071 i0 45.2 2.77433628318584 73 39 96.9 1 219 1 843 914 XOR60197.1 MAG: ATP-dependent DNA helicase uvsW [Caudoviricetes sp.] diamond 627 70.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30077639 30077639 PRJNA534016_P_NODE_19132_length_226_cov_6.751634_g19042_i0 PRJNA534016 19132 226 6.751634 15.25869284 Pseudomonas phage Rollin 3079657 Viruses Viruses 87.4 1.05e-20   NR WNV50608.1 3079657 g19042 i0 71 0.823008849557522 62 18 82.3 0 28 213 11 72 WNV50608.1 hypothetical protein [Pseudomonas phage Rollin] diamond 186 87.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Pseudomonas phage Rollin
30867609 30867609 PRJNA534016_P_NODE_4634_length_384_cov_1.897106_g4544_i0 PRJNA534016 4634 384 1.897106 7.28488704 Caudoviricetes sp. 2832643 Viruses Viruses 150 9.879999999999999e-43   NR XOR95715.1 2832643 g4544 i0 88.8 0.625 80 9 62.5 0 145 384 3 82 XOR95715.1 MAG: minor tail protein [Caudoviricetes sp.] diamond 240 150 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30994143 30994143 PRJNA534016_P_NODE_7514_length_309_cov_2.042373_g7424_i0 PRJNA534016 7514 309 2.042373 6.31093257 Caudoviricetes sp. 2832643 Viruses Viruses 53.9 5.81e-6   NR XOR43833.1 2832643 g7424 i0 33 1.90291262135922 103 66 99 3 307 2 12 112 XOR43833.1 MAG: P23 [Caudoviricetes sp.] diamond 588 53.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32544154 32544154 PRJNA534016_P_NODE_11039_length_271_cov_1.232323_g10949_i0 PRJNA534016 11039 271 1.232323 3.33959533 Erwinia phage pEa_SNUABM_49 2859284 Viruses Viruses 53.1 1.2e-6   NR QXO12696.1 2859284 g10949 i0 37.5 0.797047970479705 72 42 77.5 2 11 220 2 72 QXO12696.1 hypothetical protein pEaSNUABM49_00464 [Erwinia phage pEa_SNUABM_49] diamond 216 53.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Eneladusvirus Eneladusvirus BF

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