RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA751877" and tax_kingdom = "Heunggongvirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Heunggongvirae · 6 ✖

bioproject 1

  • PRJNA751877 · 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
27400566 27400566 PRJNA751877_P_NODE_26083_length_246_cov_0.890173_g25961_i0 PRJNA751877 26083 246 0.890173 2.18982558 EBPR siphovirus 2 1048521 Viruses Viruses 106 2.75e-27   NR AEI71064.1 1048521 g25961 i0 67.2 0.817073170731707 67 22 81.7 0 41 241 1 67 AEI71064.1 deoxycytidylate deaminase [EBPR siphovirus 2] diamond 201 106 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       EBPR siphovirus 2
27905356 27905356 PRJNA751877_P_NODE_13005_length_317_cov_0.946721_g12883_i0 PRJNA751877 13005 317 0.946721 3.00110557 Stenotrophomonas phage CUB19 2976424 Viruses Viruses 111 1.11e-29   NR UWJ04786.1 2976424 g12883 i0 80.7 0.539432176656151 57 11 53.9 0 1 171 24 80 UWJ04786.1 hypothetical protein CUB19_gp79 [Stenotrophomonas phage CUB19] diamond 171 111 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Stenotrophomonas phage CUB19
27937287 27937287 PRJNA751877_P_NODE_23465_length_250_cov_0.870056_g23343_i0 PRJNA751877 23465 250 0.870056 2.17514 Acinetobacter phage vB_AbaM_phiAbaA1 1605379 Viruses Viruses 81.3 1.17e-15   NR YP_009304775.1 1605379 g23343 i0 51.3 0.936 78 38 93.6 0 235 2 2598 2675 YP_009304775.1 tail protein [Acinetobacter phage vB_AbaM_phiAbaA1] diamond 234 81.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Saclayvirus Acinetobacter phage vB_AbaM_phiAbaA1
28505495 28505495 PRJNA751877_P_NODE_18447_length_275_cov_1.519802_g18325_i0 PRJNA751877 18447 275 1.519802 4.1794555 Burkholderia phage FLC9 2906467 Viruses Viruses 52.4 1.99e-5   NR BDD79547.1 2906467 g18325 i0 34.4 2.58545454545455 90 55 96 2 273 10 97 184 BDD79547.1 hypothetical protein [Burkholderia phage FLC9] diamond 711 52.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Burkholderia phage FLC9
29231872 29231872 PRJNA751877_P_NODE_22749_length_251_cov_0.865169_g22627_i0 PRJNA751877 22749 251 0.865169 2.17157419 Bacillus phage vB_BspM_AgentSmith 2836110 Viruses Viruses 127 6.899999999999999e-32   NR QXN70467.1 2836110 g22627 i0 73.5 0.99203187250996006 83 22 99.2 0 251 3 370 452 QXN70467.1 putative structural protein [Bacillus phage vB_BspM_AgentSmith] diamond 249 127 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Bacillus phage vB_BspM_AgentSmith
31917705 31917705 PRJNA751877_P_NODE_29897_length_241_cov_0.916667_g29775_i0 PRJNA751877 29897 241 0.916667 2.20916747 Xylella phage Bacata 2674970 Viruses Viruses 53.5 5.29e-6   NR YP_009997487.1 2674970 g29775 i0 76.5 2.10373443983402 34 8 42.3 0 102 1 1 34 YP_009997487.1 tail assembly protein [Xylella phage Bacata] diamond 507 53.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Casjensviridae Salvovirus Salvovirus bacata

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