RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA929924" and tax_phylum = "Lenarviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Lenarviricota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA929924 · 3 ✖

analysis 1

  • diamond · 3 ✖

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
27277910 27277910 PRJNA929924_P_NODE_12463_length_196_cov_1.414966_g12300_i0 PRJNA929924 12463 196 1.414966 2.77333336 Austropotamobius pallipes associated mitovirus 1 2993407 Viruses Viruses 99.8 1.26e-22   NR DBA06308.1 2993407 g12300 i0 70.8 0.994897959183674 65 19 99.5 0 1 195 314 378 DBA06308.1 TPA_asm: RdRp, partial [Austropotamobius pallipes associated mitovirus 1] diamond 195 99.8 1 Viruses   Orthornavirae Lenarviricota Howeltoviricetes Cryppavirales Mitoviridae Mitovirus Austropotamobius pallipes associated mitovirus 1
30025123 30025123 PRJNA929924_P_NODE_9471_length_261_cov_2.165094_g9308_i0 PRJNA929924 9471 261 2.165094 5.65089534 Austropotamobius pallipes associated mitovirus 1 2993407 Viruses Viruses 127 1.5099999999999999e-32   NR DBA06308.1 2993407 g9308 i0 66.7 1 87 29 100 0 261 1 130 216 DBA06308.1 TPA_asm: RdRp, partial [Austropotamobius pallipes associated mitovirus 1] diamond 261 127 1 Viruses   Orthornavirae Lenarviricota Howeltoviricetes Cryppavirales Mitoviridae Mitovirus Austropotamobius pallipes associated mitovirus 1
30372888 30372888 PRJNA929924_P_NODE_11252_length_217_cov_2.041667_g11089_i0 PRJNA929924 11252 217 2.041667 4.43041739 Ripaglac virus 3130411 Viruses Viruses 114 1.09e-27   NR WZH59599.1 3130411 g11089 i0 74.6 0.981566820276498 71 18 98.2 0 1 213 259 329 WZH59599.1 MAG: RNA-dependent RNA polymerase [Ripaglac virus] diamond 213 114 1 Viruses   Orthornavirae Lenarviricota Howeltoviricetes Cryppavirales Mitoviridae   Ripaglac virus

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