RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA1139127" and tax_kingdom = "Heunggongvirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Heunggongvirae · 5 ✖

bioproject 1

  • PRJNA1139127 · 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
27323309 27323309 PRJNA1139127_P_NODE_29963_length_321_cov_1.193548_g29471_i0 PRJNA1139127 29963 321 1.193548 3.83128908 Caudoviricetes sp. 2832643 Viruses Viruses 204 2.19e-59   NR XOR55186.1 2832643 g29471 i0 89.7 1 107 11 100 0 321 1 587 693 XOR55186.1 MAG: intein-containing putative ribonucleoside diphosphate reductase alpha subunit precursor [Caudoviricetes sp.] diamond 321 204 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28175647 28175647 PRJNA1139127_P_NODE_22046_length_397_cov_1.364198_g21555_i0 PRJNA1139127 22046 397 1.364198 5.41586606 Staphylococcus phage vB_StaM_PB5 2944247 Viruses Viruses 90.1 6.01e-18   NR WPH64261.1 3093914 g21555 i0 42.1 0.861460957178841 114 62 84.6 2 336 1 1733 1844 WPH64261.1 hypothetical protein [Staphylococcus phage vB_StaM_PB50] diamond 342 90.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Staphylococcus phage vB_StaM_PB50
31397735 31397735 PRJNA1139127_P_NODE_1436_length_1806_cov_2.743797_g1314_i0 PRJNA1139127 1436 1806 2.743797 49.55297382 Staphylococcus phage Madawaska 2797424 Viruses Viruses 457 2.48e-139   NR QQO92742.1 2797424 g1314 i0 45.5 1.03986710963455 626 281 99.7 14 1 1800 1133 1724 QQO92742.1 tape measure protein [Staphylococcus phage Madawaska] diamond 1878 457 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Staphylococcus phage Madawaska
31682052 31682052 PRJNA1139127_P_NODE_45397_length_247_cov_1.333333_g44904_i0 PRJNA1139127 45397 247 1.333333 3.29333251 Staphylococcus phage vB_StaM_SA1 2785444 Viruses Viruses 55.5 1.34e-6   NR QPI17073.1 2785444 g44904 i0 59.3 0.65587044534413 54 18 65.6 1 163 2 347 396 QPI17073.1 tail tape measure protein [Staphylococcus phage vB_StaM_SA1] diamond 162 55.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Staphylococcus phage vB_StaM_SA1
32599707 32599707 PRJNA1139127_P_NODE_13440_length_560_cov_1.414784_g12961_i0 PRJNA1139127 13440 560 1.414784 7.9227904 Staphylococcus phage Machias 2797423 Viruses Viruses 53.9 1.11e-4   NR QQO92481.1 2797423 g12961 i0 59.2 0.2625 49 20 26.3 0 414 560 1014 1062 QQO92481.1 tape measure protein [Staphylococcus phage Machias] diamond 147 53.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Staphylococcus phage Machias

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