RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA627467", tax_kingdom = "Orthornavirae" 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

  • Orthornavirae · 3 ✖

bioproject 1

  • PRJNA627467 · 3 ✖

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
1875303 1875303 PRJNA627467_P_NODE_20242_length_157_cov_3.203704_g20173_i0 PRJNA627467 20242 157 3.203704 5.02981528 Sopamon virus 3131721 Viruses Viruses 147 5.78e-31   NTclustered gi|2717323235|gb|PP174022.1| 3131721 g20173 i0 83.974 15.7388535031847 156 21 98 4 1 154 379 226 MAG: Sopamon virus isolate SP1B_k141_91399 genomic sequence blastn 2471 147 1 Viruses   Orthornavirae Lenarviricota Leviviricetes       Sopamon virus
6977737 6977737 PRJNA627467_P_NODE_8386_length_207_cov_2.297468_g8317_i0 PRJNA627467 8386 207 2.297468 4.75575876 Emesvirus zinderi 329852 Viruses Viruses 56.5 0.001   NTclustered gi|2494998033|dbj|LC710218.1| 12022 g8317 i0 96.97 0.294685990338164 33 1 16 0 141 173 23 55 Escherichia phage MS2 GI_B RNA, complete genome blastn 61 56.5 1 Viruses   Orthornavirae Lenarviricota Leviviricetes Norzivirales Fiersviridae Emesvirus Emesvirus zinderi
23551745 23551745 PRJNA627467_P_NODE_18899_length_162_cov_0.902655_g18830_i0 PRJNA627467 18899 162 0.902655 1.4623011 Ripachij virus 3130407 Viruses Viruses 152 1.29e-32   NTclustered gi|2717319663|gb|PP172709.1| 3130407 g18830 i0 84.049 119.172839506173 163 20 98 5 1 159 504 664 MAG: Ripachij virus isolate KCAP1_k141_392510 genomic sequence blastn 19306 152 1 Viruses   Orthornavirae Lenarviricota Leviviricetes       Ripachij 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);;