RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA330616", tax_phylum = "Lenarviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 4 ✖

tax_phylum 1

  • Lenarviricota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA330616 · 4 ✖

analysis 1

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
28211420 28211420 PRJNA330616_P_NODE_6746_length_322_cov_1.164835_g6337_i0 PRJNA330616 6746 322 1.164835 3.7507687 Narnaviridae sp. 2583949 Viruses Viruses 116 9.23e-28   NR URG16935.1 2583949 g6337 i0 57.3 2.76708074534162 103 42 96 1 6 314 228 328 URG16935.1 MAG: RNA dependent RNA polymerase, partial [Narnaviridae sp.] diamond 891 116 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes Wolframvirales Narnaviridae   Narnaviridae sp.
28527568 28527568 PRJNA330616_P_NODE_8367_length_287_cov_1.226891_g7958_i0 PRJNA330616 8367 287 1.226891 3.52117717 Narnaviridae sp. 2583949 Viruses Viruses 67 1.81e-10   NR URG16933.1 2583949 g7958 i0 39.8 3.13588850174216 98 56 99.3 1 1 285 459 556 URG16933.1 MAG: RNA dependent RNA polymerase, partial [Narnaviridae sp.] diamond 900 67 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes Wolframvirales Narnaviridae   Narnaviridae sp.
31022544 31022544 PRJNA330616_P_NODE_26655_length_166_cov_0.871795_g26246_i0 PRJNA330616 26655 166 0.871795 1.4471797 Macrobrachium rosenbergii narna-like virus 1 3132536 Viruses Viruses 48.1 1.67e-4   NR WWZ85587.1 3132536 g26246 i0 43.6 0.993975903614458 55 31 99.4 0 166 2 280 334 WWZ85587.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii narna-like virus 1] diamond 165 48.1 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes Wolframvirales Narnaviridae   Macrobrachium rosenbergii narna-like virus 1
31939412 31939412 PRJNA330616_P_NODE_15697_length_211_cov_1.259259_g15288_i0 PRJNA330616 15697 211 1.259259 2.65703649 Ripaglac virus 3130411 Viruses Viruses 67.4 4.79e-11   NR WZH59599.1 3130411 g15288 i0 65.8 0.540284360189573 38 13 54 0 96 209 9 46 WZH59599.1 MAG: RNA-dependent RNA polymerase [Ripaglac virus] diamond 114 67.4 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);;