RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA1103784" and tax_kingdom = "Heunggongvirae"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Heunggongvirae · 3 ✖

bioproject 1

  • PRJNA1103784 · 3 ✖

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
23972474 23972474 PRJNA1103784_P_NODE_5499_length_253_cov_1.511111_g5444_i0 PRJNA1103784 5499 253 1.511111 3.82311083 Viruses 10239 Viruses Viruses 468 1.92e-127   NTclustered gi|1490671587|gb|MH673674.1| 2301537 g5444 i0 100 3 253 0 100 0 1 253 10749 10497 Thermus phage phiMa, complete genome blastn 759 468 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Thermus phage phiMa
27668080 27668080 PRJNA1103784_P_NODE_6904_length_245_cov_0.895349_g6849_i0 PRJNA1103784 6904 245 0.895349 2.19360505 uncultured Caudovirales phage 2100421 Viruses Viruses 96.7 1.18e-21   NR CAB4131764.1 2100421 g6849 i0 62.5 0.979591836734694 80 30 98 0 1 240 154 233 CAB4131764.1 Phage head morphogenesis domain containing protein [uncultured Caudovirales phage] diamond 240 96.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
29972904 29972904 PRJNA1103784_P_NODE_4191_length_278_cov_1.531707_g4136_i0 PRJNA1103784 4191 278 1.531707 4.25814546 Staphylococcus phage Madawaska 2797424 Viruses Viruses 51.2 6.12e-5   NR QQO92741.1 2797424 g4136 i0 60.5 1.65107913669065 38 15 41 0 151 264 1434 1471 QQO92741.1 tail lysin [Staphylococcus phage Madawaska] diamond 459 51.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Staphylococcus phage Madawaska

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