RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA1123309" 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

  • PRJNA1123309 · 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
28144261 28144261 PRJNA1123309_P_NODE_60685_length_245_cov_0.906977_g60305_i0 PRJNA1123309 60685 245 0.906977 2.22209365 uncultured Caudovirales phage 2100421 Viruses Viruses 107 3.88e-26   NR CAB4154031.1 2100421 g60305 i0 89.5 0.697959183673469 57 6 69.8 0 73 243 1 57 CAB4154031.1 Thrombospondin type-1 (TSP1) repeat, partial [uncultured Caudovirales phage] diamond 171 107 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
29501624 29501624 PRJNA1123309_P_NODE_61390_length_245_cov_0.906977_g61010_i0 PRJNA1123309 61390 245 0.906977 2.22209365 Staphylococcus phage vB_SepS_SEP9 1434319 Viruses Viruses 43.9 0.00131   NR YP_009007751.1 1434319 g61010 i0 65.5 0.355102040816327 29 10 35.5 0 90 4 3 31 YP_009007751.1 hypothetical protein SEP9_083 [Staphylococcus phage vB_SepS_SEP9] diamond 87 43.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Sextaecvirus Sextaecvirus SEP9
31365965 31365965 PRJNA1123309_P_NODE_51536_length_251_cov_0.865169_g51156_i0 PRJNA1123309 51536 251 0.865169 2.17157419 Caudoviricetes sp. 2832643 Viruses Viruses 120 1.37e-29   NR XOS26090.1 2832643 g51156 i0 67.1 0.9800796812749 82 27 98 0 1 246 467 548 XOS26090.1 MAG: hypothetical protein MSP0002_7 [Caudoviricetes sp.] diamond 246 120 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
31428976 31428976 PRJNA1123309_P_NODE_50916_length_251_cov_0.876404_g50536_i0 PRJNA1123309 50916 251 0.876404 2.19977404 Flavobacterium phage Fpv2 1814282 Viruses Viruses 57.8 7.89e-8   NR YP_009321918.1 1814283 g50536 i0 49 0.585657370517928 49 25 58.6 0 104 250 1 49 YP_009321918.1 hypothetical protein BOW81_gp49 [Flavobacterium phage Fpv20] diamond 147 57.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Fipvunavirus Flavobacterium phage Fpv20
31998451 31998451 PRJNA1123309_P_NODE_64018_length_243_cov_0.917647_g63638_i0 PRJNA1123309 64018 243 0.917647 2.22988221 Caudoviricetes sp. 2832643 Viruses Viruses 144 2.0699999999999998e-42   NR DAL41053.1 2832643 g63638 i0 93.4 2.81481481481481 76 5 93.8 0 14 241 7 82 DAL41053.1 MAG TPA_asm: Terminase [Caudoviricetes sp.] diamond 684 144 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);;