RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJEB83711" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 4 ✖

bioproject 1

  • PRJEB83711 · 4 ✖

analysis 1

  • diamond · 4 ✖

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
28763829 28763829 PRJEB83711_P_NODE_50507_length_266_cov_1.357513_g50241_i0 PRJEB83711 50507 266 1.357513 3.6109845800000002 Ilarvirus 12316 Viruses Viruses 84.3 1.36e-17   NR NP_620774.1 12317 g50241 i0 63.2 3.24812030075188 57 21 64.3 0 1 171 177 233 NP_620774.1 coat protein [Tobacco streak virus] diamond 864 84.3 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Bromoviridae Ilarvirus Ilarvirus TSV
29971135 29971135 PRJEB83711_P_NODE_35711_length_302_cov_3.030568_g35445_i0 PRJEB83711 35711 302 3.030568 9.15231536 Morogoro maize-associated virus 2497337 Viruses Viruses 204 2.03e-64   NR YP_010087199.1 2497337 g35445 i0 95 0.993377483443709 100 5 99.3 0 2 301 99 198 YP_010087199.1 matrix protein [Morogoro maize-associated virus] diamond 300 204 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Mononegavirales Rhabdoviridae Alphanucleorhabdovirus Alphanucleorhabdovirus morogoromaydis
31481007 31481007 PRJEB83711_P_NODE_81696_length_229_cov_2.006410_g81430_i0 PRJEB83711 81696 229 2.00641 4.5946789 Ilarvirus 12316 Viruses Viruses 99 1.47e-23   NR YP_009551517.1 2116599 g81430 i0 61 2.0174672489083 77 29 99.6 1 1 228 86 162 YP_009551517.1 coat protein [Cape gooseberry ilarvirus 1] diamond 462 99 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Bromoviridae Ilarvirus Cape gooseberry ilarvirus 1
32405586 32405586 PRJEB83711_P_NODE_16099_length_442_cov_1.249322_g15833_i0 PRJEB83711 16099 442 1.249322 5.52200324 Tobacco streak virus 12317 Viruses Viruses 184 7.459999999999998e-55   NR NP_620773.1 12317 g15833 i0 78.9 1.54751131221719 114 24 77.4 0 345 4 1 114 NP_620773.1 movement protein [Tobacco streak virus] diamond 684 184 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Bromoviridae Ilarvirus Ilarvirus TSV

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