RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA758398", tax_clade = "Pithoviruses" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 4 ✖

tax_clade 1

  • Pithoviruses · 4 ✖

bioproject 1

  • PRJNA758398 · 4 ✖

analysis 1

tax_phylum 0

tax_kingdom 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
26957975 26957975 PRJNA758398_S_NODE_8862_length_324_cov_1.483636_g8721_i0 PRJNA758398 8862 324 1.483636 4.80698064 Solumvirus sp. 2487773 Viruses Viruses 74.3 1.45e-13   NR AYV86227.1 2487773 g8721 i0 54.2 0.666666666666667 72 33 66.7 0 217 2 31 102 AYV86227.1 MAG: hypothetical protein Solumvirus2_34 [Solumvirus sp.] diamond 216 74.3 1 Viruses Pithoviruses             Solumvirus sp.
29358389 29358389 PRJNA758398_S_NODE_33869_length_184_cov_1.340741_g33728_i0 PRJNA758398 33869 184 1.340741 2.46696344 Pithovirus LCDPAC 2506601 Viruses Viruses 50.8 3.37e-6   NR QBK84901.1 2506601 g33728 i0 42.9 0.798913043478261 49 28 79.9 0 32 178 45 93 QBK84901.1 MAG: hypothetical protein LCDPAC02_01000 [Pithovirus LCDPAC02] diamond 147 50.8 1 Viruses Pithoviruses             Pithovirus LCDPAC02
29705225 29705225 PRJNA758398_S_NODE_8690_length_327_cov_1.496403_g8549_i0 PRJNA758398 8690 327 1.496403 4.89323781 Solumvirus sp. 2487773 Viruses Viruses 79 2.6e-15   NR AYV86227.1 2487773 g8549 i0 70.2 0.522935779816514 57 12 47.7 1 326 171 131 187 AYV86227.1 MAG: hypothetical protein Solumvirus2_34 [Solumvirus sp.] diamond 171 79 1 Viruses Pithoviruses             Solumvirus sp.
31633234 31633234 PRJNA758398_S_NODE_41256_length_168_cov_1.714286_g41115_i0 PRJNA758398 41256 168 1.714286 2.88000048 Pithovirus LCPAC1 2506586 Viruses Viruses 50.4 4.78e-6   NR QBK89839.1 2506586 g41115 i0 54.1 0.660714285714286 37 17 66.1 0 132 22 2 38 QBK89839.1 MAG: SNF2 subfamily protein [Pithovirus LCPAC101] diamond 111 50.4 1 Viruses Pithoviruses             Pithovirus LCPAC101

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