RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "diamond", bioproject = "PRJNA429937" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 2 ✖

tax_kingdom 1

bioproject 1

  • PRJNA429937 · 2 ✖

analysis 1

  • diamond · 2 ✖

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
27518105 27518105 PRJNA429937_P_NODE_43443_length_544_cov_2.188350_g27761_i0 PRJNA429937 43443 544 2.18835 11.904624 Colletotrichum cliviicola partitivirus 1 3400824 Viruses Viruses 143 1.31e-36   NR XOT41440.1 3400824 g27761 i0 39.1 2.83455882352941 256 81 99.8 4 544 2 248 503 XOT41440.1 RNA-dependent RNA polymerase [Colletotrichum cliviicola partitivirus 1] diamond 1542 143 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae   Colletotrichum cliviicola partitivirus 1
30360553 30360553 PRJNA429937_P_NODE_63472_length_431_cov_2.199005_g43092_i0 PRJNA429937 63472 431 2.199005 9.47771155 Nigrospora oryzae partitivirus 2 3231912 Viruses Viruses 132 6.24e-33   NR XCK16958.1 3231912 g43092 i0 87 0.960556844547564 69 9 48 0 173 379 437 505 XCK16958.1 RNA-dependent RNA polymerase [Nigrospora oryzae partitivirus 2] diamond 414 132 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae   Nigrospora oryzae partitivirus 2

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